Practical ERP Cost Management (2): Cost Master Data, Job Costing and Manufacturing Overhead Allocation

Part 2 of this series, based on a practical ERP cost management course, covers the master data that forms the backbone of cost calculation, job costing, manufacturing overhead allocation and joint costs.

Before choosing a costing method, the first question to settle is: where is cost collected, and on what basis is it allocated to which product?

1. Cost master data determines the calculation result

Master data object Role Examples from the course
Cost center Responsibility unit that plans and collects cost —
Cost element Classifies the nature of expenses and revenues —
Activity type Expresses an activity quantity Labor hours, machine hours
Internal order Tracks cost of a specific purpose Events, campaigns

2. Cost classification criteria

Cost is classified by purpose. The direct/indirect and variable/fixed distinctions in particular have a large effect on allocation and on decision making.

Criterion Categories
Costing object Job costing, process costing
Timing of calculation Pre-calculated cost (before production), post-calculated cost (after production)
Cost basis Standard cost, normal cost, actual cost
Traceability Direct cost, indirect cost
Cost behavior Variable cost, fixed cost

3. Job costing traces cost from raw material to cost of goods sold

Job costing runs through four connected steps.

Step Activity
1 Raw material movements and material cost calculation
2 Aggregation of labor cost and manufacturing overhead
3 WIP valuation and cost of goods manufactured calculation
4 Finished goods movements and cost of goods sold calculation

4. Inventory movements and valuation methods are managed together

The ERP standardizes the inventory management structure and keeps receipts, issues and current stock up to date in real time. The valuation method has to be chosen to fit the accounting policy and the system design.

Area What the ERP standardizes
Inventory management unit Unit at which stock is managed
Organization Organizational units for inventory
Movement types Classification of goods receipts and goods issues
Real-time data Receipts, issues and current stock
Valuation method
Moving average
First-in, first-out (FIFO)
Total (weighted) average
Standard cost

5. Common cost is allocated in stages from indirect departments to products

Cost of the indirect departments is first allocated to the direct production departments, and then from the production departments to products.

Stage From To Basis
1 Indirect departments: plant accounting, labor (HR), equipment maintenance, utilities Direct production departments Allocation base designed per section 6
2 Direct production departments Products Machine hours, labor hours and similar

6. A good allocation base can be explained and verified

Allocation bases and allocation paths are designed with the following principles in mind. The method is chosen according to the company’s cost structure and management purpose.

Principle Meaning
Cause and effect Allocate to the object that caused the cost
Benefits received Allocate to the object that benefited from the cost
Ability to bear Allocate according to the object’s capacity to absorb cost
Fairness Allocation that the receiving parties accept as fair
Allocation method Description
Direct allocation Indirect department cost goes straight to production departments
Step-down allocation Indirect departments are allocated in sequence
Reciprocal allocation Mutual services between indirect departments are taken into account

7. Joint cost arises when one process yields several products

As in a petrochemical process, several joint products can be produced from the same input and the same process. Cost incurred before the split-off point is treated as joint cost and allocated to each product on a reasonable basis.

Term Meaning
Joint products Several products produced from the same input and process
Split-off point Point at which the joint products become separately identifiable
Joint cost Cost incurred before the split-off point

8. Joint cost allocation methods

Product cost and profitability change with the method selected, so consistency and explainability are important.

Method Allocation basis
Physical quantity (production volume) Output quantity of each product
Sales value at split-off point Sales value of each product at the split-off point
Net realizable value Final sales value less further processing cost
Constant gross margin percentage Equal gross margin rate for every product

This is part 2 of a 3-part series on practical ERP cost management.

Comments

Popular posts from this blog

SAP S/4HANA Table Reference — Tables I Actually Query, by Topic

Production Order Variance Calculation KKS1 — Fixing KV031 and KV011, and What Lands in COSB

Modern ABAP Syntax Notes — Patterns and Pitfalls from Real Development