XLS www.montana.edu

Machinery and Equipment Cost WorksheetShaded Numbers are Calculated, Others Must be EnteredSelf PropelledCALCULATION OF HOURS OF USEor ImplementMACHINE NAME OR DESCRIPTIONTractorSpeed of Implement or Powered Equipment in MPH4Width of Implement or Equipment in Feet20Field Efficiency (Enter As a Decimal, 80% as .8)0.8 See Factors Page for GuidelinesTotal Acres of Annual Use3500 Count Each Pass Over the Same Piece of Ground To Get the Total Acres of Annual use.Calculated Hours of Annual Use=IF(G12=0,0,G12/G17)Calculated Acres Per Hour=G8*G9*(IF(G103,G33/100,G33)) Calculated Repair Cost Per Hour=IF(G21=0,0,G34/G21) Total Repair Costs (Average Annual Estimate)=G35*G20TOTAL OPERATING COSTS FOR THE YEAR=G29+G30+G36 Estimated Average Operating Costs Per Hour=IF(G20=0,0,G37/G20) Estimated Averatge Operation Costs Per Acre=IF(G12=0,0,G37/G12)OWNERSHIP COSTS:DEPRECIATION: Calculated Depreciation Costs Per Hour=IF(G21=0,0,(G19-G22)/G21) Total Depreciation (Straight Line Method)=G44*G20OPPORTUNITY COST: Interest Rate (Real Rates of Interest Should be Used)0.05 (Enter 5% as .05, Not 5)Calculated Average Value of Machine - Equipment=(G19+G22)/2Calculated Opportunity Cost=G47*G49TAXES: Taxable Value Rate (See Your County Assessor)0.11 (Enter Rate as a Decimal - 11 as .11 and Not 11.0) Millage Rate Per $1000 of Valuation (See Assessor)300 Calculated Annual Taxes=G49/1000*(IF(G521,G55,G55*100))INSURANCE: Premimum Rate Per $1000 of Valuation4.5 Calculated Insurance Cost=G49/1000*G58Total Average Annual Ownership Cost=G45+G50+G56+G59Avearage Ownership Cost Per Hour of Annual Use=IF(G20=0,0,G61/G20)Avearage Ownership Cost Per Acre of Annual Use=IF(G12=0,0,G61/G12)TOTAL COSTS:TOTAL COSTS (OWNERSHIP + OPERATING COSTS)=G37+G61Average Total Cost Per Hour of Annual Use=IF(G20=0,0,G66/G20) Does Not Include Labor (Operator) CostAverage Total Cost per Acre=G40+G64 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download