Machinery Inventory List Spreadsheet Created by Tom Welch at MSU-Northern - "Use at your own risk" Current Year Current Year Current Year
Name of Farm Ranch On the Grow # 1 Current Year--------------------------------> 2009 Annual Annual Annual
Machine Description Manufacturer Model Year Made List Price Current Price Eng. HP Hours/Yr. Var. Cost/Hr Fix. Cost/Hr. Total Cost/Hr. Var. Costs Fixed Costs TOTAL COSTS
4 X 4 Tractor Big Bud 525/50 1980 214000 47756 525 210 $124.37 $65.01 $189.38 $26,117.70 $13,652.10 $39,769.80
MFWD Tractor/Loader John Deere 7510 2000 73993 59934 134 200 $26.11 $16.90 $43.01 $5,222.00 $3,380.00 $8,602.00
2 X 4 Tractor John Deere 4440 1980 45145 15365 148 100 $34.48 $5.18 $39.66 $3,448.00 $518.00 $3,966.00
Utility Tractor/Loader Case IH CX60 2000 24000 18004 58 100 $17.52 $16.56 $34.08 $1,752.00 $1,656.00 $3,408.00
Backhoe Tractor CAT 416 1992 70000 18500 90 100 $25.13 $36.51 $61.64 $2,513.00 $3,651.00 $6,164.00
Skid Steer Loader New Holland 160 2002 21915 15998 53 150 $16.96 $2.83 $19.79 $2,544.00 $424.50 $2,968.50
Chisel Plow Flex-Coil 820 (43') 2005 26500 22000 110 $14.41 $20.40 $34.81 $1,585.10 $2,244.00 $3,829.10
Harrow Degleman 70' 2005 35000 28000 45 $16.40 $44.38 $60.78 $738.00 $1,997.10 $2,735.10
Air Seeder Flex-Coil 7500 (50') 2000 120000 74500 100 $108.54 $76.88 $185.42 $10,854.00 $7,688.00 $18,542.00
Combine John Deere 9760STS 2005 260000 235000 340 125 $45.03 $186.02 $231.05 $5,628.75 $23,252.50 $28,881.25
Round Baler John Deere 567 2003 26630 19440 50 $16.99 $34.18 $51.17 $849.50 $1,709.00 $2,558.50
Windrower (16') Hesston 8400 1997 67237 23533 96 45 $27.03 $59.88 $86.91 $1,216.35 $2,694.60 $3,910.95
Hay Rake New Holland (24') 2004 10000 7000 40 $12.75 $19.26 $32.01 $510.00 $770.40 $1,280.40
Grass/Legume Drill Brillion 14 8000 25 $15.08 $21.02 $36.10 $377.00 $525.50 $902.50
Hydra Bed Circle D 2006 6000 5000 270 $12.01 $2.47 $14.48 $3,242.70 $666.90 $3,909.60
Field Sprayer Flex-Coil 67XL 2003 35000 21500 85 $12.12 $19.29 $31.41 $1,030.20 $1,639.65 $2,669.85
Grain Auger # 1 FarmKing 13"/70' 2006 14200 14200 50 $12.71 $31.80 $44.51 $635.50 $1,590.00 $2,225.50
Grain Auger # 2 FarmKing 8"/41' 2006 4312 4312 50 $14.76 $6.30 $21.06 $738.00 $315.00 $1,053.00
Grain Vacuum 2000 30000 10000 50 $12.22 $44.64 $56.86 $611.00 $2,232.00 $2,843.00
Post Hole Digger New Holland 12" 5000 50 $14.47 $7.27 $21.74 $723.50 $363.50 $1,087.00
Post Pounder FarmHand 1800 50 $12.00 $7.40 $19.40 $600.00 $370.00 $970.00
GPS 2004 5500 3000 500 $12.07 $0.73 $12.80 $6,035.00 $365.00 $6,400.00
$0.00 $0.00 $0.00 $0.00
$0.00
$0.00
Machine Description Manufacturer Model Year Made List Price Current Price Miles/Year $/Mile Var. Costs/Yr. Fix Costs/Yr. Total Costs/Yr.
Semi Tractor Kenworth W900L 2000 90000 44500 10000 $1.14 $3,684.52 $7,723.33 $11,407.85
Semi Grain Trailer Timpte 48' 2007 32000 32000 10000 $0.42 $756.67 $3,465.83 $4,222.50
Grain Truck Kenworth W900 1993 80000 41500 8000 $1.08 $4,790.67 $3,866.67 $8,657.34
Dump Truck Kenworth W900 1983 45000 18500 1800 $2.91 $1,179.21 $4,050.00 $5,229.21
4X4 1-Ton Pickup Ford F350 2002 36000 25190 20000 $0.52 $4,283.33 $6,175.00 $10,458.33
4X4 3/4 Ton Feed Pickup GMC 2500 1985 11000 3500 2500 $0.50 $798.11 $447.73 $1,245.84
4X4 Utility Pickup Ford F250 1979 5200 500 2000 $0.54 $614.29 $470.00 $1,084.29
Service Truck 1-Ton Chevrolet 3500 1992 20000 6500 8000 $0.39 $876.82 $500.00 $1,376.82
Gooseneck Stock Trailer Featherlite 24' 2000 20000 15000 3000 $0.51 $125.00 $1,415.00 $1,540.00
Flatbed Trailer Travalong 33' 2006 8000 7000 2000 $0.21 $147.62 $266.67 $414.29
ATV Honda 4Trax 2006 7000 6500 1500 $0.64 $376.25 $580.00 $956.25
VARIABLE FIXED TOTAL
CURRENT MACHINERY VALUE-----------------> $851,732.00 MACHINE COSTS FOR CURRENT YEAR----> $94,603.79 $100,664.98 $195,268.77
0.229260812
Machinery Field Operations & Enterprises
Enterprises & Machine Hours/Miles Per Ente
Field Operations Machine(s) Required WW SW BLY
Tilling 4 X 4 Tractor 90 0 18
Chisel Plow 90 0 18
Service Truck 1-Ton 120 0 20
Planting Grain Crop 4 X 4 Tractor 60 30 10
Air Seeder 60 30 10
Grain Truck 200 100 $33.00
Semi Grain Trailer 200 100 $33.00
Semi Tractor 200 100 $33.00
Service Truck 1-Ton 120 50 $20.00
Harvesting Grain Combine
Semi Tractor
Semi Grain Trailer
Grain Truck
Grain Auger # 2
Service Truck 1-Ton
Spraying 2 X 4 Tractor
Field Sprayer
Flatbed Trailer
4X4 1-Ton Pickup
Harvesting Hay Windrower (16')
Hay Rake
Service Truck 1-Ton
Flatbed Trailer
4X4 1-Ton Pickup
Fencing 4X4 Utility Pickup
Skid Steer Loader
ATV
Livestock Management (salting, chasing, checking)
Livestock Hauling
Grain Hauling
Livestock Feeding 4X4 3/4 Ton Feed Pickup
Hydra Bed
Planting Forage Crops
4 X 4 Tractor
MFWD Tractor/Loader
2 X 4 Tractor
Utility Tractor/Loader
Backhoe Tractor
Skid Steer Loader
Chisel Plow
Harrow
Air Seeder
Combine
Round Baler
Windrower (16')
Hay Rake
Grass/Legume Drill
Hydra Bed
Field Sprayer
Grain Auger # 1
Grain Auger # 2
Grain Vacuum
Post Hole Digger
Post Pounder
GPS
0
Machine Description
Semi Tractor
Semi Grain Trailer
Grain Truck
Dump Truck
4X4 1-Ton Pickup
4X4 3/4 Ton Feed Pickup
4X4 Utility Pickup
Service Truck 1-Ton
Gooseneck Stock Trailer
Flatbed Trailer
ATV
0
0
0
0
Annual TOTAL
hine Hours/Miles Per Enterprise MACHINE
ALFALFA OTHER HAY RANGE CRP HOURS/MILES
2 0 0 0 110
2 0 0 0 110
10 0 0 0 150
0 0 0 0 100
0 0 0 0 100
0 0 0 0 333
0 0 0 0 333
0 0 0 0 333
0 0 0 0 190
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Yearly
Enterprises & Acres Per Enterprise & Field Operation Acres
Field Operations WW SW BLY ALFALFA OTHER HAY
Total Acres 3000 1500 500 160 200
Tilling
Planting
Harvesting Grain
Spraying
Harvesting Hay
Fencing
Livestock Management (salting, chasing, checking)
Livestock Hauling
Grain Hauling
0
0
0
0
0
0
Tilling
0
0
#REF!
Planting Grain Crop
0
0
0
Harvesting Grain
0
0
0
0
0
Spraying
0
0
0
Harvesting Hay
0
0
0
0
Fencing
0
0
0
0
Livestock Management (salting, chasing, checking)
0
0
0
Livestock Hauling
0
0
0
Grain Hauling
0
0
0
0
Livestock Feeding
0
0
0
0
Planting Forage Crops
0
0
0
RANGE CRP
2800 1280
Current Year Current Year
Machine Description Manufacturer Model Var. Costs Fixed Costs
0 0 0 $0.00 $0.00
0 0 0 $0.00 $0.00
0 0 0 $0.00 $0.00
0 0 0 $0.00 $0.00
0 0 0 $0.00 $0.00
Flatbed Trailer Travalong 33' $147.62 $266.67
Grass/Legume Drill Brillion 14 $377.00 $525.50
ATV Honda 4Trax $376.25 $580.00
Post Pounder FarmHand 0 $600.00 $370.00
Grain Auger # 2 FarmKing 8"/41' $738.00 $315.00
4X4 Utility Pickup Ford F250 $614.29 $470.00
Post Hole Digger New Holland 12" $723.50 $363.50
4X4 3/4 Ton Feed PickupGMC 2500 $798.11 $447.73
Hay Rake New Holland (24') $510.00 $770.40
Service Truck 1-Ton Chevrolet 3500 $876.82 $500.00
F
Gooseneck Stock Trailer eatherlite 24' $125.00 $1,415.00
Grain Auger # 1 FarmKing 13"/70' $635.50 $1,590.00
Round Baler John Deere 567 $849.50 $1,709.00
Field Sprayer Flex-Coil 67XL $1,030.20 $1,639.65
Harrow Degleman 70' $738.00 $1,997.10
Grain Vacuum 0 0 $611.00 $2,232.00
Skid Steer Loader New Holland 160 $2,544.00 $424.50
Utility Tractor/Loader Case IH CX60 $1,752.00 $1,656.00
Chisel Plow Flex-Coil 820 (43') $1,585.10 $2,244.00
Hydra Bed Circle D 0 $3,242.70 $666.90
Windrower (16') Hesston 8400 $1,216.35 $2,694.60
2 X 4 Tractor John Deere 4440 $3,448.00 $518.00
Semi Grain Trailer Timpte 48' $756.67 $3,465.83
Dump Truck Kenworth W900 $1,179.21 $4,050.00
Backhoe Tractor CAT 416 $2,513.00 $3,651.00
GPS 0 0 $6,035.00 $365.00
MFWD Tractor/Loader John Deere 7510 $5,222.00 $3,380.00
Grain Truck Kenworth W900 $4,790.67 $3,866.67
4X4 1-Ton Pickup Ford F350 $4,283.33 $6,175.00
Semi Tractor Kenworth W900L $3,684.52 $7,723.33
Air Seeder Flex-Coil 7500 (50') $10,854.00 $7,688.00
Combine John Deere 9760STS $5,628.75 $23,252.50
4 X 4 Tractor Big Bud 525/50 $26,117.70 $13,652.10
Current Year Annual Machinery Cost
4 X 4 Tractor
Combine
Air Seeder
Semi Tractor
Semi Tractor
4X4 1-Ton Pickup
Grain Truck
MFWD Tractor/Loader
GPS
Backhoe Tractor
Dump Truck
Semi Grain Trailer
2 X 4 Tractor
Windrower (16')
Hydra Bed
Chisel Plow
Utility Tractor/Loader
Skid Steer Loader
Grain Vacuum
Harrow
Field Sprayer
Round Baler
Grain Auger # 1
Gooseneck Stock Trailer
Service Truck 1-Ton
Hay Rake
4X4 3/4 Ton Feed Pickup
Post Hole Digger
4X4 Utility Pickup
Grain Auger # 2
Post Pounder
ATV
Grass/Legume Drill
Flatbed Trailer
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
Current Year
TOTAL COSTS
$0.00
$0.00
$0.00
$0.00
$0.00
$414.29
$902.50
$956.25
$970.00
$1,053.00
$1,084.29
$1,087.00
$1,245.84
$1,280.40
$1,376.82
$1,540.00
$2,225.50
$2,558.50
$2,669.85
$2,735.10
$2,843.00
$2,968.50
$3,408.00
$3,829.10
$3,909.60
$3,910.95
$3,966.00
$4,222.50
$5,229.21
$6,164.00
$6,400.00
$8,602.00
$8,657.34
$10,458.33
$11,407.85
$18,542.00
$28,881.25
$39,769.80
Machinery Costs
$25,000.00 $30,000.00 $35,000.00 $40,000.00 $45,000.00