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