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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf business plan worksheet foodtruckr
- xls equipment lifecycle cost calculator acctech systems
- pdf restaurant food waste action guide refed
- pdf costing a recipe with an excel spreadsheet world class cad
- pdf excel templates for budgets man power user guide
- pdf ch 1 the need for a personal budget
- pdf budget worksheet
- xlsx
- pdf six forms of software cost estimation
- pdf jim and joe re we are you restaurant owner
Related searches
- https www municipalonlinepayments
- directorio de empresas 2019 in xls file
- convert pdf to xls file
- csv to xls converter
- batch convert xls to csv
- powershell convert xls to csv without excel
- convert xls to csv online
- xlsx to xls converter microsoft download
- convert xlsx to xls free
- powershell convert xls to csv
- convert xls to xlsx powershell
- xls convert to excel