Units of Production Depreciation Calculator

The units of production depreciation method can be used to calculate the depreciation expense for property, plant and equipment based on the level of units produced. The method is particularly useful in a manufacturing environment where a production asset reduces in value in proportion to the amount it is used.

The calculation is carried out using the units of production depreciation formula which takes the cost of the asset less any expected salvage (residual) value, and divides this by the expected lifetime production capacity of the asset in units of production. The formula used in the units of production depreciation calculator is given as follows:

Units of production depreciation = (Cost – Salvage value) / Expected lifetime units

Full details of how the method is used can be found in our units of production depreciation tutorial.

units of production depreciation calculator
Units of Production Depreciation Calculator Preview

Using the Units of Production Depreciation Calculator

The Excel units of production depreciation calculator, available for download below, is used to compute units of production depreciation by entering details relating to the asset and unit production levels. The calculator is used as follows:

  1. Enter the cost of the asset. The cost of the asset can be found in the long term asset account, asset register, or on the original source document (invoice) for the asset
  2. Enter the salvage value. The salvage or residual value is the amount the asset is expected to be worth at the end of its useful life. The units of production depreciation calculator works out the cost which is subject to depreciation, known as the depreciable cost.
  3. Enter the lifetime units of production. The lifetime units of production is the number of units which the asset is expected to produce during its lifetime with the business. The units of production depreciation calculator works out the depreciation per production unit for the asset.
  4. Enter the period units of production. The period units of production is the number of units actually produced by the asset during the accounting period. The units of production depreciation calculator works out the depreciation expense for the asset for the accounting period.

Units of Production Depreciation Calculator Download

The units of production depreciation spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this units of production depreciation calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a units of production method of depreciation calculator that you might use when considering how to calculate units of production depreciation. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this units of production calculator, please let us know and we will try to fix it.
Units of Production Depreciation Calculator November 6th, 2016Team

You May Also Like

Related pages

capital lease journal entries lesseeunearned revenue journal entriesunearned revenue in balance sheetpurchase ledger control account formatexcel pv calculationequation rearranger onlinebalance sheet reconciliations examplesdoubtful accounts journal entryfuture value annuity duewhat is accounts receivable aginghow to calculate activity based costingbookkeeping to trial balance exam paperslifo reserve journal entryaged creditorsbill discounting without recoursedeclining perpetuity formulaamortising bondspay back period calculatorsuspense accounts definitionaccounting forms printablefull accounting cycle examplesfixed asset turnover ratio calculatorcontra revenuesix steps of accounting cycleoverhead absorption rate calculationpv pmt calculatorjournal entry accounts payableformula for working capital turnover ratiorule of 78sinterest revenue journal entrygoal seek effective interest ratetrial balance vs general ledgerimprest checkconsignment sales revenue recognitionformula of accounting equationmarkup calculator exceltreatment of deferred tax in cash flow statementdefine fob originaccounting entry for bad debtscredits and debits accountinginstallment loan formulaeffective annual interest rate equationoverhead apportionmentbond premium amortization calculatorexcel pmt formula exampleaccruals and deferred incomeentry for accrued incomehow is depreciation expense calculatedannuity value formulaprove it accounts payable testformula to calculate accumulated depreciationloan amortization ukis accounts receivable debit or creditdifference between single entry and double entry bookkeepingfree printable ledger sheetsaccrued revenues areexamples of income statementspaid creditor on account journal entryexcel template accountinghow to compute total manufacturing costbookkeeping tutorial philippineswhat are accruals on balance sheetmarkup percentage calculationbank overdraft asset or liabilitypetty cash bookkeepingtotal overhead varianceageing accounts receivablevertical analysis of income statement examplediscount rate annuitypmt funtiontotal variable costs formulabad debts journal entriescompute the payback periodcalculate fv of annuityprintable blank spreadsheet templatesannuity formula with growthgeneral ledger explainedfreight terms fobdebtor collection ratiosalary accrual journal entrydepreciation calculator straight linewhat is a profitability indexsmall business expense template