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

present value of infinite cash flowbasic accounting and bookkeepingcogs gross profitfuture value of an annuity examplelump sum discountsales ledger account formatoverhead allocation rate formulaaccounting prudenceadjusting entry for notes payableclosing entries general journalprovision accounting entriesexamples of annuity duefifo method examplebond pricing equationcorrecting trial balance errorsdifference between notes payable and accounts payablevertical analysis accountingwhat is accrued payrollaccounting basic quizdepreciation rate calculatorpaid salaries to employees journal entrycreditors ledgerpayment voucher format wordjournal entry to record deferred revenuesum of the years digits depreciationexcel basics quizpresent value of growing annuity formulaprepaid expense on balance sheetlump sum formuladso ratio formuladsi accountingaccounting journalizingcontra account listexamples of capital receiptscontra entry in accountingexamples of revenue and capital expenditurehow do you calculate asset turnoverjurnal account payablepresent value of annuity example problemsvariable cost examples in accountingfixed overhead varianceaverage cost inventory methodwhat does fob on an invoice meanhow to prepare an income statement in excelhow to calculate markup percentagebond pv calculatorformula for markup percentagecash flow perpetuity formulajournal entry for prepaid rent receivedhow to post journal entries to t accountsdefine consigned goodscash conversion cycle equationpresent value annuity due formuladebtors control account definitionpersonal ledger account formatoperating lease journal entriesaccount payable and note payablefinancial gearing ratio formulahow to calculate marketable securities from balance sheetbookkeeping for a small business templatedepreciation reducing balance methodpurpose of subsidiary ledgeraccounting bank reconciliation practice problemsmarketable securities in accountingprepaid expenses in trial balancedebit credit chartwhat is the purpose of double entry bookkeepingmarkup on selling price calculatorcash discount in accountingcalculating asset turnover ratioroa calculationhow to calculate remaining mortgage balancestock split journal entrydouble declining depreciation calculation formulalifo calculation formulapresent value of lease payments calculator