All tools

Cost-pool allocation

Allocate an overhead pool across cost centres on a quantitative driver, and see the allocation rate.

Result

Allocation rate
240
Total driver quantity
2000
Allocated total
480000.00

Download the workbook

The method

  1. Allocation rate = cost pool ÷ total driver quantity, then multiplied by each centre's quantity.
  2. The allocated total equals the pool exactly; the rounding difference lands on one centre rather than disappearing.

Built forAn accountant reviewing an entry or balance before close

When you need it

You have connected figures that need testing before they enter the close file. Allocate an overhead pool across cost centres on a quantitative driver, and see the allocation rate.

The decision it supports

Use the result to decide whether the work can be accepted or a difference or classification needs tracing. The tool shows its method beside the result so you can review it.

What you receive

Cost-pool allocation result

A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.

An example you can inspect

A ready-to-run example

The tool opens with: Cost pool = 480000.00, First centre driver = 1200, Second centre driver = 800. Change any value to see its effect immediately.

Continue the workflow