Machine Cost Calculator Instructions
Prepared by L. Hurd Template is being tested
This spreadsheet will estimate the costs of owning and operating a tractor and one pull type machine. Replace the numbers in the colored area with those that are applicable to your situation.
Section 1 - Assumptions
Tractor Size of tractor (PTO horsepower) Fuel Type (1=diesel, 2=gasoline) Fuel Price Capital cost of tractor Machine type from Table 1 (A91) Annual use (all uses) Age Expected useful life when new Machine Width covered by machine (feet)) Capital cost of machine Machine type from Table 1 Annual use calculated Hours per acre calculated Acres per hour calculated Age Expected useful life when new Speed of use Field efficiency Table 1 -> Size of field(s) Number of times over field Other Hird labour (1 = hired, 2=owner) Hired labour rate ($/hour) Owner/operator rate ($/hour) Interest Rate (%)
Enter Your Numbers Here 100 1 $0.32 $80,000 1 600 1 12
22 $16,000 7 132 0.26 3.78 1 15 5 85% 500 3
1 $8.00 $12.00 5
* If the tractor horsepower is given as net engine power multipy by .88 to obtain Power Take Off (PTO) rating
Results
Variable Costs Fuel and Lubrication Equipment Repairs Hired Labour Operator Labour Total Variable Costs Fixed Costs Insurance and Housing Depreciation Investment Total Fixed Costs Total Costs Per Hour 6.13 3.78 8.00 0.00 17.91 Per Per Total Acre Operation 1.62 0.54 811 1.00 0.33 500 2.12 0.71 1,059 0.00 0.00 0 4.74 1.58 2,370
2.54 17.25 6.39 26.18 44.09
0.67 4.57 1.69 6.93 11.67
0.22 1.52 0.56 2.31 3.89
336 2,284 845 3,465 5,836
Machine Summary Per Hour Variable Costs 15.09 2.82 17.91 Fixed Costs 15.00 11.18 26.18 Total Variable Costs Costs 30.09 3.99 14.00 0.75 44.09 4.74 Per Acre Fixed Costs 3.97 2.96 6.93 Total Costs 7.96 3.71 11.67
Tractor Machine
Annual Costs Per Acre - Tractor and Pulled Machine Variable Costs Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Table 1 Group No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Total Life Repairs 100% 100% 150% 60% 60% 80% 80% 40% 40% 60% 100% 80% 80% 80% 80% 70% 60% 80% 35% Repair Factor Estimated RF1 RF2 Life 0.01 2.00 10,000 0.01 2.00 10,000 0.43 1.80 2,000 0.18 1.70 2,000 0.18 1.70 2,000 0.30 1.40 2,000 0.30 1.40 2,000 0.30 1.40 2,000 0.16 1.30 2,000 0.16 1.30 2,000 0.23 1.40 2,000 0.22 2.20 2,000 0.36 2.00 1,500 0.54 2.10 1,200 0.54 2.10 1,200 0.54 2.10 1,200 0.14 2.30 2,000 0.12 2.30 2,000 0.26 1.60 2,000 0.08 2.10 2,000 Speed Field (mph) Efficiency 4.5 80% 4.5 85% 4.0 80% 4.5 85% 5.5 85% 5.0 85% 6.0 85% 5.0 80% 7.0 80% 3.5 80% 3.0 85% 3.0 65% 4.5 60% 4.0 70% 2.5 65% 3.0 65% 4.5 75% 3.0 70% Fuel 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 1.62 Repairs 1.31 1.78 2.20 2.59 2.96 3.33 3.68 4.02 4.36 4.70 5.03 5.35 5.67 5.99 6.31 Labour 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 Total 5.05 5.52 5.94 6.33 6.70 7.07 7.42 7.76 8.10 8.44 8.77 9.09 9.41 9.73 10.05 Insur 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 Fixed Costs Dep 38.40 30.72 24.58 19.66 15.73 12.58 10.07 8.05 6.44 5.15 4.12 3.30 2.64 2.11 1.69 Invest 9.60 7.68 6.14 4.92 3.93 3.15 2.52 2.01 1.61 1.29 1.03 0.82 0.66 0.53 0.42 Total 48.67 39.07 31.39 25.25 20.33 16.40 13.26 10.74 8.73 7.12 5.83 4.80 3.97 3.31 2.78 53.72 44.59 37.33 31.58 27.04 23.47 20.67 18.50 16.83 15.55 14.59 13.89 13.39 13.04 12.83 Total Costs
2 Whl drive and stationary 4 whl Drive & Crawlers Moldboard plow Heavy duty disk Tandem Disk Chiesel Plow Field cultivator Spring tooth harrow Roller packer, Mulcher packer Mulcher packer Rotary hoe Row crop cultivator Rotary tiller Row crop planter -No till tillage Row crop planter -Conventional tillage Grain drill Corn picker sheller Pull type combine Pull type swather ?? S.p. combine
0.012 0.010 0.075 0.029 0.029 0.050 0.040 0.020 0.030 0.051 0.054 0.066
0.044 0.039 0.026
21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
S.p. swather ?? Mower Mower-conditioner Side delivery rake Baler Big bale baler Long hay stacker Pull type forage harvester Self propelled forage harvester Sugar beet harvester Potato harvester Corn picker or stripper Fertilizer spreader Boom type sprayer Air carrier sprayer Bean puller-windrower Beet topper stalk chopper Forage blower Wagon Truck Truck
80% 150% 80% 100% 80% 80% 80% 80% 40% 70% 70% 60% 120% 70% 60% 60% 60% 50% 80%
0.26 0.46 0.26 0.38 0.23 0.23 0.23 0.26 0.06 0.19 0.19 0.17 0.95 0.41 0.20 0.20 0.23 0.14 0.19 0.01
1.60 1.70 1.60 1.40 1.80 1.80 1.80 1.60 2.00 1.40 1.40 1.80 1.30 1.30 1.60 1.60 1.40 1.80 1.30 2.00
2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,500 2,500 2,500 2,000 1,200 1,500 2,000 2,000 2,000 2,000 3,000 3,000
0.039 0.075 0.039 0.050 0.040 0.040 0.040 0.040
0.027 0.100 0.046 0.030
4.5 5.0 4.5 4.5 3.5 3.5 3.5 2.5 3.0 3.0 2.0 3.0 4.5 6.5 3.0 3.5 2.5
0.024 0.026 0.004
75% 80% 75% 80% 75% 65% 60% 65% 70% 70% 60% 70% 70% 65% 60% 80% 70% 100% 100% 100% 100%
Depreciation YEAR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Investment 5% YEAR 1 2 Rate --> OPEN 32.00 25.60 20.48 16.38 13.11 10.49 8.39 6.71 5.37 4.29 3.44 2.75 2.20 1.76 1.41 1.13 0.90 0.72 0.58 0.46 Machine AMOUNT 1.60 1.28
Machine 20% AMOUNT 6.40 5.12 4.10 3.28 2.62 2.10 1.68 1.34 1.07 0.86 0.69 0.55 0.44 0.35 0.28 0.23 0.18 0.14 0.12 0.09
CLOSE 25.60 20.48 16.38 13.11 10.49 8.39 6.71 5.37 4.29 3.44 2.75 2.20 1.76 1.41 1.13 0.90 0.72 0.58 0.46 0.37
Depreciation Tractor Rate --> 30% YEAR OPEN AMOUNT CLOSE 1 160.00 32.00 128.00 2 128.00 25.60 102.40 3 102.40 20.48 81.92 4 81.92 16.38 65.54 5 65.54 13.11 52.43 6 52.43 10.49 41.94 7 41.94 8.39 33.55 8 33.55 6.71 26.84 9 26.84 5.37 21.47 10 21.47 4.29 17.18 11 17.18 3.44 13.74 12 13.74 2.75 11.00 13 11.00 2.20 8.80 14 8.80 1.76 7.04 15 7.04 1.41 5.63 16 5.63 1.13 4.50 17 4.50 0.90 3.60 18 3.60 0.72 2.88 19 2.88 0.58 2.31 20 2.31 0.46 1.84 Total Invest 9.60 7.68
Total Dep 38.40 30.72 24.58 19.66 15.73 12.58 10.07 8.05 6.44 5.15 4.12 3.30 2.64 2.11 1.69 1.35 1.08 0.86 0.69 0.55
Investment Tractor 5% YEAR AMOUNT 1 8.00 2 6.40
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
1.02 0.82 0.66 0.52 0.42 0.34 0.27 0.21 0.17 0.14 0.11 0.09 0.07 0.06 0.05 0.04 0.03 0.02
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
5.12 4.10 3.28 2.62 2.10 1.68 1.34 1.07 0.86 0.69 0.55 0.44 0.35 0.28 0.23 0.18 0.14 0.12
6.14 4.92 3.93 3.15 2.52 2.01 1.61 1.29 1.03 0.82 0.66 0.53 0.42 0.34 0.27 0.22 0.17 0.14
Repair Cost Per Acre Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Workspace Depreciation Tractor Machine 1,323.53 960.00 17.25 ($/hr) 4.57 $/acre Investment 485.29 360.00 6.39 ($/hr) 1.69 $/acre Repairs 127.06 373.32 3.78 ($/hr) 1.00 $/acre Insurance Repair Average Housing Cost Repair 176.47 per hour per hour 160.00 Tractor 1.44 0.96 2.54 Machine 3.50 2.82 ($/hr) 0.67 %/100 hr %/100 hr $/acre Tractor 0% 8.3% Machine 2% 20.3% Tractor 0.13 0.38 0.64 0.89 1.14 1.40 1.65 1.91 2.16 2.41 2.67 2.92 3.18 3.43 3.68 3.94 4.19 4.45 4.70 4.96 5.21 Machine 0.57 0.93 1.14 1.31 1.45 1.57 1.67 1.77 1.86 1.95 2.03 2.10 2.18 2.24 2.31 2.37 2.43 2.49 2.54 2.60 2.65 Total 1.31 1.78 2.20 2.59 2.96 3.33 3.68 4.02 4.36 4.70 5.03 5.35 5.67 5.99 6.31 6.62 6.94 7.25 7.55 7.86
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Costs -->
Per Hour $44.09
Per Acre $11.67
Per Field $5,836
Per Operation $3.89