Overhead Apportionment Calculator

Overhead apportionment is the process of apportioning general overhead between cost centers or departments. This overhead apportionment calculator can be used to apportion eight types of overhead, each with its own apportionment base, between six cost centers.

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

overhead apportionment calculator v 1.0
Overhead Apportionment Calculator Preview

Instructions

The Excel overhead apportionment calculator, available for download below, is used by entering the amount and apportionment base details for each of eight overhead types. The calculator then apportions the overhead over six cost centers.

To use the calculator enter the details as follows:

Apportionment Base

1. Enter Cost Center Names

Enter the names of up to six departments or cost centers over which overhead is to be apportioned. For example, manufacturing, servicing, stores department etc.

2. Enter Overhead Details

For each of up to eight overhead types enter details of the overhead name (e.g. staff canteen costs), the apportionment base (e.g. number of employees), and the quantity of the base for each of the cost centers (e.g. manufacturing 28 employees, servicing department 15 employees etc). The overhead apportionment calculator will total each base quantity.

If an overhead line is not being used leave the information details blank, and enter zero for each cost center base quantity.

Apportionment

3. Enter the Overhead Amount

For each type of overhead enter the amount to be apportioned for the accounting period. The calculator will then use the amount entered and apportion it between the cost centers using the appropriate apportionment base.

For example, if staff canteen costs of 7,000 are apportioned to a department which has a 28 employees out of a total of 108 employees, then the amount apportioned is 7,000 x 28 / 108 = 1,815. Further details of overhead apportionment calculations can be found in our cost apportionment of general overhead tutorial.

Overhead Apportionment Calculator Download

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

The overhead apportionment 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 apportionment 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 apportioning calculator that you might use when considering how to determine overhead apportionment. 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 cost allocation calculator, please let us know and we will try to fix it.
Overhead Apportionment Calculator November 6th, 2016Team

You May Also Like


Related pages


how to calculate receivables turnover rationet60 payment termsunearned income balance sheethow to figure out gross profit marginprofitability index equationdouble entry ledger templateassets turnover ratio formuladepreciation schedule straight line methodpv of an annuity duehow to record a vehicle purchase in quickbooksretained earnings debit or credit balancesample of retained earnings statementcontribution margin exampleallowance for uncollectible accounts is classified asjournaling accountingdepreciation expense equationwhat is pmt functiondebits increasewhat is present value annuityverifiability accounting8 steps in the accounting cyclerecording depreciation expense journal entryaccounts reconciliation templatedeclaring a cash dividend willprovision accounting entriesvariable overhead formulastraight line method amortizationbank reconciliation template xlsoffice supplies on hand adjusting entrywhat is the purpose of closing entriescompounded continuously interest formulahalf year convention depreciationdefine amortiseformula annuity duedirect material price variancedisbursement ledgercash book with cash and bank columnstvm calculator free downloadmanufacturing overhead journal entryeom payment termsgeneral journal closing entriesincome statement creatoraccounting ajeeffective yield method amortizationstatement of changes in equity templatewhat is debtors journalthe entry to replenish a petty cash fund includescash in transit accounting definitionhow to record collection of accounts receivableunrealized loss journal entryexamples of ledgerspresent value of growing annuity formulaproject payback periodmark up in accountingclosing dividends to retained earningsamortizing bond discountsuspense account balance sheetinterest coverage ratio calculatortrade receivables debtorsreceivable conversion periodjournal entry for allowance for doubtful accountscash receipts and cash disbursementscost of goods sales formulawhat is contra assetcalculating wiphow to calculate trial balancesimple trial balance exampleaccounting journalizing exampleswhat is the meaning of imprestthe number of days sales in receivablesrent prepaid journal entrythe economic entity assumption requires that the activitiespayroll tax accountant salarycapitalized lease obligationspresent value tables annuity dueexcel present value of future cash flowsliquidity ratio quick ratiocartage outwardsretained earning