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


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.


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 closing stock from trial balancecreditors aging reportmarkup and profit marginhow to make adjusting journal entriescalculating declining balance depreciationpre operating expenses accounting treatmenthow to record depreciation expense in journal entrydebtors reconciliation templatetraditional costing formuladouble entry system advantages and disadvantagesdepreciation double entryexamples of overstatementjournal entry accounts receivablemeaning of unpresented chequeconvertible participating preferred150 double declining balance depreciation calculatorcalculating arrinventory shrinkage accountingdefine amortization expenseentries for depreciationaverage inventory cost methodjournal entry for accrued expensesprepaid assets accountingaccounts receivable statement templatenper in excelwages payable journal entrywhat is a suspense account on balance sheetdefinition of bounced checkweighted average cost inventory formulatotal contribution margin formulajournal entry for bad debtsexample of journalizing in accountingmarkup rate calculatorrent paid in advance journal entryplant assets examplesaccounting for non profit organisation pdfrecord cogsexcel cash flow formulavoucher booklet templateformula annuity duelcm in accountingledger sheet printable freemargin vs markup calculatorhow to record sale of asset in quickbooksnotes receivablesadjusting entry for depreciation expenseaccumulated depreciation assetgeneral ledger formsample statement of retained earningsjournal entries for tdsgeneral ledger formatadjusting entry for notes payableexamples of petty cash expensesfuture value annuity factor tablethe calculation of depreciation using the declining-balance methodlessor accounting capital leaseretained earning meaningcommon size balance sheet and income statementnote payable journal entryformula to calculate future value of annuitypost closing trial balance definitionoverhead expenses examples12 column worksheet accountingwip accounting definitionbookkeeping sample testimpress accounthow to calculate variable expenses per unitcash flow statement equationnormal balance of unearned revenuecalculating ending inventoryequity method of accounting for joint venturesexamples of debits and creditshow to calculate operating leveragedividends journal entrymonthly payment function excelcalculating double declining depreciationaccounting for accrued expensesdiscount amortization table