Overhead Recovery Rate Calculator

In order to make decisions about pricing, profitability and inventory valuations, a business needs to absorb some of its overhead into the cost of its products. This overhead recovery rate calculator can be used to calculate the amount of overhead to be absorbed by a product, based on a given budgeted overhead and absorption base.

If you need further information on the calculation of overhead absorption, this is more fully discussed in our overhead absorption in cost accounting tutorial.

overhead recovery rate calculator
Overhead Recovery Rate Calculator

Instructions

The Excel overhead recovery rate calculator, available for download below, is used by entering the budgeted overhead and the absorption base and units to be used.

By entering the number of absorption base units used in the manufacture of each product, the calculator then determines the amount of overhead to be absorbed

To use the calculator enter the details as follows:

Budget

1. Enter the Budgeted Overhead

Enter the total amount of budgeted overhead which is to be absorbed by the production units.

2. Enter the Absorption Base Units

The absorption base forms the basis on which overhead is absorbed into the cost of the production units. The base is normally a quantity such as direct labor cost, direct labor hours, machine hours or material cost.

If for example, overhead is to be absorbed on the basis of direct labor hours and it is budgeted that 30,000 direct labor hours will be used in an accounting period, then 30,000 is entered as the absorption base units.

The overhead recovery rate calculator works out the absorption rate per base unit, sometimes referred to as the overhead recovery rate. If the budgeted overhead is 75,000 and the absorption base units are 30,000, then the predetermined overhead recovery rate is calculated using the absorption rate formula as follows.

Overhead absorption rate = Overhead / Absorption base units
Overhead absorption rate = 75,000 / 30,000 = 2.50 per base unit

Product Overhead Absorption

3. Enter the Product Base Units

For each product enter a description of the product and the number of absorption base units used in the manufacture of the product. For example, if the base used is direct labor hours, and the number of labor hours used in the manufacture of the product is 3.50, then enter 3.50 under the base units column for the product.

Finally, for each product, the overhead recovery rate calculator determines the overhead to be absorbed by one unit of the product.

For example if the predetermined absorption rate is 2.50 per direct labor hour, and it takes 3.50 direct labor hours to manufacture the product, the amount to be absorbed by each unit of the product is calculated as follows.

Overhead absorbed by the product = Overhead absorption rate x Labor hours used
Overhead absorbed by the product = 2.50 x 3.50 = 8.75 per unit of product

The total overhead absorbed can be calculated by multiplying this value by the number of units produced. If for example 1,200 units are produced, then the overhead absorbed is determined as follows.

Overhead absorbed = Product absorption rate x Number of product units
Overhead absorbed = 8.75 x 1,200 = 10,500

Overhead Recovery Rate Calculator Download

The overhead recovery rate calculator spreadsheet is available for download in Excel format by following the link below.

The overhead recovery rate calculator is one of many financial calculators used in bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this overhead absorption 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 cost recovery calculator that you might use when considering how to determine product overhead absorption. 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 manufacturing overhead recovery rate calculator, please let us know and we will try to fix it.
Overhead Recovery Rate Calculator November 22nd, 2016Team

You May Also Like


Related pages


general ledger reconciliation templateaging accounts payablethe formula for computing annual straight line depreciation isfuture value of annuity due formulacommon size balance sheet ratiosvariable expenses formuladebtors control account definitionpayback period online calculatorexcel irraccounting rate of return examplejob sheet templateshow to reconcile petty cashover absorption of overheadsmandatory redeemable preferred sharescalculate simple interest in excelinventory turns ratiodeclining balance depreciation calculatorwhere to find marketable securities on balance sheetpresent value of an annuity calculatoraverage payment period ratiowhat is meant by accounting equationreceivable conversion periodt accounts excel templatemarkup factoraccounting for convertible debenturesstockholders equity accountsdefine payback periodaccounts receivable debit balancemeaning of accrued revenuerule 78 calculatoraccounting closing entries examplesdirect material formulacost of good sold formula accountingjournal entry for bad debtsebit interest covertemporary accounts accountingadvantages and disadvantages of zero based budgetingsingle entry ledger booklcm accountinghow to compute gross profitmoney voucher templatedirect material price varianceperpetual vs periodic inventory systemposting journal entries to general ledgera predetermined overhead rate is used tostandard cost and standard costingtotal labor variance formulaaccruals and deferralscash suspense account definitionexcel bookkeeping templateslifo reserve adjustmenthow to calculate straight line amortizationbook in accountingthe accounting for warranty costs is based on thesales ledger control account exampleprovision for doubtful debts in income statementbounced check definitionaged receivable reportarr formulawhat is accounts payable ledgermargin formula excelcalculate total variable cost per unitaccounts receivable debitaccounting double entry system examplebook keeping basicsledger proformainterest bearing calculatorhow to calculate percentage mark upaccounting fifo methodjournal entry for payment by chequereserve for obsolete inventoryfixed assets turnoverunearned revenue ifrscalculate interest expense on bondsunearned income liabilityaccounts payable examplestransaction sheet template