SAP Costing Sheet Overhead Rate and Absorption Calculator
A costing sheet in SAP product costing and order costing applies overhead percentages to a base such as material or labor. This calculator lets you derive the production overhead rate from planned cost, build a simple cost of sales, and measure how much overhead is under or over absorbed once actual volume differs from plan.
Your numbers
Actual quantity of the base the overhead is applied to.
Total planned cost to be absorbed, for example from cost center planning.
Your results
Simplified single-rate costing sheet. Real SAP costing sheets use credit keys, multiple bases, activity-based rates and surcharges by cost center or order type.
Absorbed overhead and under absorption vs actual labor base
Sweeps Actual direct labor (allocation base) from 50000 to 500000, holding your other inputs fixed.
Costing sheet design review
Share your overhead structure and we will point out base and rate choices that commonly cause under absorption.
Optional. The tool and every export work without this. No spam.
How to use it
Start with the planned overhead pool and planned base from your cost center plan to get the predetermined rate. Then enter actual direct material and actual labor. The tool applies the material rate and the production rate, adds administrative overhead on cost of manufacture, and compares absorbed production overhead with the overhead actually posted. The chart changes the actual labor base so you can see how volume swings drive under or over absorption.
- Use planned values from the same version as your standard cost estimate
- Keep the base consistent: labor cost in plan and in actuals
- Treat the result as the variance you would expect on the cost center or order
The method
The predetermined overhead rate is planned overhead divided by the planned allocation base. Absorbed overhead equals the actual base multiplied by that rate. Under absorption is actual overhead minus absorbed overhead: if you absorbed less than you spent, the difference remains as a debit in the ledger and appears as an overhead variance. In SAP the percentage and base are set in the costing sheet (rows with base and overhead keys), and the calculated credit goes to the cost center or order that carries the overhead.
Reading the result
A modest positive under absorption is normal when volume falls below plan, because fixed overhead is spread over a smaller base. A large number suggests the planned rate is stale or that activity was posted on the wrong base. Negative figures mean you recovered more overhead than you spent, which flatters inventory value until the variance is settled at period end.
Common mistakes
Using actual overhead in the numerator, which defeats the purpose of a predetermined rate. Mixing hours and currency bases. Forgetting administrative overhead is applied to cost of manufacture and not to material alone. Updating the plan rate mid-year without revaluing inventory, leaving a mismatch between old standard costs and the new rate.
Frequently Asked Questions
Is this the same as SAP activity type pricing?
No. Costing sheet overhead applies percentage surcharges to a base, while activity types price internal services per unit such as machine hour. Both feed product costing, but they use different configuration and different rate logic.
What is a good overhead rate?
There is no universal number. It depends on how much cost is in the pool compared with the base. Compare the rate across years and cost centers instead, and investigate sharp moves, since they usually reflect plan changes rather than efficiency.
How do I fix large under absorption?
Review the planned volume, remove costs that do not belong to the pool, or choose a base that tracks the driver better, such as machine hours instead of labor. Then re-plan and run the cost estimate again so standards reflect the new rate.
Does it handle multiple bases?
This version uses one material rate and one labor-based production rate. For several bases, run the calculation once per base and add the results, or build the logic into your costing sheet and test with a cost estimate.
If you want faster answers on overhead variances without opening five reports, Netray can set up a read-only question interface over your SAP controlling data. Talk to us about what you need to check.
Related Tools
SAP Cost Center Assessment Allocation Calculator
Split a shared cost pool across receiver cost centers by headcount, area or any statistical key figure, and see the rate per unit.
SAPSAP Production Order WIP Calculator
Estimate work in process on a production order from actual costs and goods receipts at standard, and compare with WIP at target cost.
SAPSAP Purchase Price Variance and Moving Average Price Calculator
See the price difference posted at goods receipt for a standard price material and the new moving average price for a MAP material.
SAPSAP Material Ledger Periodic Unit Price Calculator
Compute the periodic unit price, ending inventory value and consumption value for a material in an actual costing period, and compare it with standard.