Based on a presentation by Tom King
SAP work centers connect production operations to Product Costing. Their costing formulas calculate the machine, labor, and setup quantities required for an operation. SAP values these quantities using the relevant cost center and activity type prices.
Accurate work center assignments, standard values, formulas, and activity rates help you explain how production costs flow into material cost estimates and manufacturing orders. This article covers the key settings, a worked example, and practical checks for SAP ERP and SAP S/4HANA.
How Work Centers Connect Production and Costing
A work center represents where an operation is performed, such as a machine, production line, or group of people. In process manufacturing, a resource performs a comparable role in the master recipe. Work centers and resources support scheduling, capacity planning, and costing.
A routing operation references a work center. For internal activity costing, the work center supplies the cost center assignment, activity types, and formula keys. For each validity period, a work center can be assigned to one cost center; several work centers can share that cost center.
| Master data or setting | Role in Product Costing |
|---|---|
| Routing or master recipe | Defines the production operations and their quantities. |
| Work center or resource | Connects an operation to costing formulas and the assigned cost center. |
| Standard values | Provide inputs such as setup, machine, or labor time. |
| Activity type | Identifies the activity whose quantity and price are used for valuation. |
| Activity rate | Values the calculated quantity for the relevant cost center/activity type. |
| Control key and costing relevance | Determine whether and how an operation participates in costing. |
The operation quantity and standard values feed the formulas. The activity quantities calculated by those formulas are then valued by Controlling. This separation lets you investigate a quantity problem independently from a rate problem.
Standard Values and the Rule of Six
The standard value key defines the meaning and units of up to six standard values, for example setup time, machine time, and labor time. Production work centers support up to six activity types for this integration; other work center categories can have different limits.
The six standard-value positions do not require six different calculations. A costing formula can use the parameters needed for the activity, including values from other positions. Confirm that each activity type, formula, and unit represents the work you intend to cost.
Keep the distinction between elapsed machine time and total labor effort. Two people working for two hours represent four labor hours, even when the operation takes only two elapsed hours.
Design and Test Costing Formulas
A costing formula determines activity input, such as machine hours or labor hours. The rate used to value that activity is maintained or calculated in Cost Center Accounting. Select a formula permitted for costing and assign it to the relevant activity type in the work center.
Formula parameters can obtain values from routing or operation fields, standard values, work center constants, and configured user fields. Typical inputs include operation quantity, base quantity, machine time, setup time, and crew size.
For a simple quantity-dependent operation:
Machine hours = machine time for the base quantity × operation quantity ÷ base quantity.
Maintain consistent dimensions and verify unit conversion. Test normal production quantities, small lots, and zero or missing denominator values. SAP work center formulas support arithmetic operators and additional mathematical functions; use the formula syntax supported by your system rather than assuming a general programming language.
Keep Scheduling Splits Separate from Total Costing Effort
Splits support parallel processing. Dividing total machine or labor effort by the number of parallel splits can understate the activity quantity to be costed, even when it correctly reduces elapsed time for scheduling. Include splits in a costing formula only when they represent the intended consumption. Test scheduling, capacity, and costing formulas against the same production scenario.
Model Setup, Speed, Efficiency, and Crew Size
Use parameters to represent the way work is performed. For example, machine speed can determine runtime, a crew-size parameter can convert runtime to labor effort, and an efficiency adjustment can affect the required activity quantity. Check the configured performance efficiency rate key and avoid applying the same adjustment twice.
A fixed setup time normally applies once to the modeled lot, while run time scales with the operation quantity. Confirm the formula's behavior when lot sizes change. A fixed setup quantity is distinct from the fixed and variable portions of an activity price.
Work Center Costing Example
The following illustrative example costs one operation for a lot of 100 units. Assume the formulas produce one setup hour, two machine hours, and four labor hours, and that each price is quoted per one hour.
| Activity | Calculated quantity | Illustrative rate | Planned activity cost |
|---|---|---|---|
| Setup | 1 hour | 50.00 per hour | 50.00 |
| Machine | 2 hours | 75.00 per hour | 150.00 |
| Labor | 4 hours | 40.00 per hour | 160.00 |
| Total for 100 units | 360.00 |
Activity cost per unit = 360.00 ÷ 100 = 3.60. Materials, overhead, external processing, and other cost components are excluded from this example.
If the lot doubles and setup remains one hour, machine and labor quantities double while setup does not. Total activity cost becomes 670.00 for 200 units, or 3.35 per unit. This shows why the costing lot size and the treatment of setup matter.
Activity Rates and Cost Flow
The work center's cost center/activity type combination links the calculated quantity to an activity price. The cost estimate's valuation settings determine which price is selected. Classic KP26 activity planning is one way to maintain planned quantities and prices where that workflow is available.
Activity cost = calculated activity quantity × activity price ÷ price unit. When the price is quoted per one hour, the price unit is 1. Check both the activity unit and the price unit before comparing rates.
A material cost estimate records the planned value of internal activities in its costing results. Calculating a cost estimate does not itself create an actual accounting posting. During production, cost-relevant confirmations can trigger actual activity allocations to manufacturing orders, depending on the operation and confirmation settings. Planned quantities, actual confirmed quantities, and the prices used for valuation can therefore differ.
For more detail, read the SAP Activity Types overview, the category 1 activity posting example, and the complete Activity Type posting series.
Analyze Costs by Work Center in SAP S/4HANA
The SAP Fiori app Analyze Costs by Work Center/Operation (F3331) helps production cost accountants compare planned and actual costs and investigate variances at work center or operation level. You can explore the associated orders and activities to identify where cost differences arise.
Use the analysis to distinguish changes in activity consumption from changes in valuation. Confirm the app's availability, authorizations, supported order types, and reporting prerequisites for your SAP S/4HANA edition and release.
Master Data and Troubleshooting Checks
When a cost estimate or order shows unexpected activity costs, trace the quantity and price separately:
- Check the work center assignment. Verify the cost center, validity dates, activity types, and the work center used by the operation.
- Check operation relevance. Review the control key, costing settings, routing selection, and relevant dates.
- Test the formula. Review standard values, base quantity, operation quantity, units, efficiency settings, and any split or crew-size parameters.
- Check the rate. Verify the cost center/activity type price, price unit, fiscal period, and valuation settings.
- Review master data changes. Check copied defaults, reference indicators, operation overrides, and existing order data. Do not assume that changing a work center automatically refreshes every routing or order.
- Recalculate and reconcile. In an appropriate test scenario, compare formula results with the expected activity quantities and the cost estimate or order report.
Validity periods allow a cost center assignment to change over time. Use the relevant costing dates when checking the assignment, and verify the effect of any change on existing task lists and orders before using the revised setup.
Are Your Work Centers Producing the Right Costs?
ERPCorp can help review work center formulas, routing standard values, activity rates, and production variances so your team can explain and improve manufacturing costs.
Glossary
Work Center
Master data representing where an operation is performed. It supplies information used for scheduling, capacity planning, and costing. A resource serves a comparable purpose in process manufacturing.
Routing
A task list describing the operations required to manufacture a product, including work centers and standard values. Process manufacturing uses master recipes.
Standard Value
An operation input such as setup, machine, or labor time. The standard value key defines the available positions, their meanings, and units.
Activity Type
A classification of the activity provided by a cost center, such as machine hours or labor hours. It links an activity quantity to its valuation.
Activity Rate
The price used to value an activity for a cost center/activity type combination. Check the quantity unit and price unit when applying the rate.
Costing Formula
A formula assigned in the work center that determines the activity quantity needed for an operation using configured parameters.
Costing Lot Size
The quantity used as the basis for a material cost estimate. It affects how lot-dependent costs, including setup, are spread across units.
Valuation Variant
Configuration assigned through the costing variant that defines valuation strategies, including the selection of activity prices for costing.
This article is based on Tom King's presentation, “How Work Centers Impact Product Costing,” at the SAP Controlling Conference. Explore ERPCorp membership for access to in-depth SAP Controlling content.
SAP documentation: Costing with Cost Centers; Rules for Maintaining Formulas; Analyze Costs by Work Center/Operation.