SAP Activity Type Rate Calculator: Plan Price, Utilization and Under or Over Absorption
An activity type price is how a cost center charges its cost to production orders, maintenance orders and projects. If it is wrong, product costs are wrong. This calculator divides planned cost by planned quantity into a fixed and variable price, shows the effect of idle capacity and tests the result at an actual activity level.
Your numbers
Depreciation, rent, supervision and similar costs that do not move with activity.
Power, consumables and other costs that move with activity.
Activity to be allocated to orders in the year.
Maximum hours the resource could deliver.
Hours actually allocated to orders.
Fixed plus variable actual cost.
Your results
Planning logic only. Actual cost is held constant while the chart sweeps activity, so the under or over figure shows what a volume shortfall does to a fixed cost base.
Absorbed cost vs actual activity
Sweeps Actual activity delivered from 6000 to 15000, holding your other inputs fixed.
Cost center rate review
Optional: ask us to compare your planned activity rates with actual utilization from your SAP data.
Optional. The tool and every export work without this. No spam.
How to use it
Enter planned fixed and variable cost for the cost center, the activity quantity you plan to allocate, and the capacity. The result is the total price you would enter or confirm in KP26 or let SAP calculate through iterative price determination (KSPI) or activity price calculation from the planned cost. Then enter actual activity and actual cost to see whether the cost center ends the year under or over absorbed.
The formula behind it
Price equals planned cost divided by planned activity quantity, split into fixed and variable portions. Many companies plan against capacity rather than planned activity so that idle capacity does not inflate product cost. The second fixed price output shows that alternative. Whichever basis you use, document it, because it changes the standard cost estimate for every product that uses the resource.
Reading the result
With the defaults the price is about 60.83 per hour and planned utilization is 80 percent. At 11,200 actual hours the orders absorb 681,333, while the cost center spent 705,000, so it is under absorbed by about 23,667. That difference remains on the cost center until it is allocated or written off at period close, usually through an assessment or settlement to a variance account.
Common mistakes
Planning activity from last year's actuals without adjusting for a sales forecast. Including costs allocated in from other centers in the fixed number twice. Forgetting to update the price after a significant change in depreciation. Using the same activity type for very different machines. Not reviewing the resulting price against the market cost of an outside subcontract.
Frequently Asked Questions
What is the difference between fixed and variable activity price?
The fixed price spreads costs that do not change with volume, such as depreciation, over the planned quantity. The variable price spreads costs that follow volume, such as energy. Product costing uses both, and variance analysis often treats them separately.
Should I plan on capacity or on planned activity?
Planned activity gives a rate that reflects expected volume, but idle time inflates the price. Capacity-based planning gives a lower, stable rate and leaves idle cost on the cost center as an explicit loss. Choose one policy and apply it consistently.
Where is the price maintained in SAP?
Planned prices are maintained in KP26 for activity types and in KP27 for the plan values for an activity-dependent cost view. Automatic calculation is available through the activity price calculation transaction when you plan cost and quantity in the same version.
What does under absorption mean for product cost?
Orders were charged less than the cost center actually spent. The gap is not in product cost until it is allocated, so margins in profitability reports look better than the true cost until that allocation is made.
If you want rates and utilization pulled from your own plan versions and actuals, Netray can build a read-only view across your SAP cost centers.
Related Tools
SAP Standard Cost Variance Calculator
Split a production variance into material price, material usage, labor rate and labor efficiency using the standard formulas.
SAPSAP Cost Center Hierarchy Upload Worksheet
Lay out cost centers and their parent groups in one sheet, check lengths, and export the file for your upload tool.
SAPSAP Period End Closing Checklist
A month-end close checklist in a sensible order, with the SAP transactions to run for each step.
SAPSAP Cost Element Categories Reference
A searchable list of SAP CO cost element categories, S/4HANA account types and the master data objects around them.
More SAP tools
See all- SAP SD Rebate Agreement Request Form Template
- SAP SD Sales Order Item ABAP SELECT Generator
- SAP Document Types Reference
- SAP Posting Keys Reference
- SAP CO-PA Value Field Mapping Worksheet
- SAP Transport Request Checklist
- SAP Role Design Worksheet
- SAP Critical Authorization Objects Reference
- SAP Segregation of Duties Conflict Matrix Worksheet