Valuating Resource Consumption (goods, labor)

Objective

After completing this lesson, you will be able to detail the goods issue step, the confirmation of work for routing operations' level, and their subsequent posting mechanisms.

Reporting Apps for Production Costs Analysis

Overview

When the production order is created and the production is launched, additional steps are immediately triggered. There are several methods for initiating them. Let’s concentrate on the general principle and suppose your SAP S/4HANA Cloud system uses the Event-Based Production Cost Posting solution.

Analyze Production Costs - Event-Based app

Before discussing the details of the postings, let’s review the main apps for monitoring the sequence.

If you want to track up-to-date production cost data for event-based manufacturing orders, even in parallel ledgers and in multiple currencies, you can use the Analyze Production Costs - Event-Based app.

It provides you with a cost comparison of actual, plan, and target costs at order level for open and closed manufacturing orders, as well as per cost component groups. Indeed, if cost component structures have been set up for different analysis needs, you can use this combination of cost components. Only cost components that are defined as Cost of Goods Manufactured are shown.

This screenshot shows you the Analyze Production Costs—Event-Based app, with the 2 tabs for order item details and cost component groups.

Order Costs Details - Event-Based app

The Order Costs Details - Event-Based app offers a cost comparison of actual, plan, and target costs at both order header and item levels, in multiple currencies, for orders using the Event-Based Production Cost Posting solution (3F0).

You can access it directly or from the Analyze Production Costs - Event-Based app.

The main interest is to provide you with the following:

  • The full details of costs by G/L account, and by business transaction
  • A variance split after orders are delivered, or technically completed
This screenshot shows the Order Costs Details - Event-Based app, with the 2 views for cost details and COGM overview.

Goods Issue and Subsequent Postings

Graphic showing an extract of the production order cycle that emphasizes the business events (Goods issue and Activity confirmation) and their impact in terms of incurring costs.

When the order’s status authorizes them (released status), goods issues can be posted based on material staging in the warehouse. On the basis of the associated BOM, eventually combined with information from the routing’s operations, the consumption of the necessary quantity of components is withdrawn in Inventory Management either all at once, operation after operation, or retroactively after the last operation’s confirmation (also known as backflushing).

These components (frame, driving components set, pedals) are necessary to manufacture the finished product (frameset).

When goods issues are posted in Inventory Accounting, a line item is generated in Production Accounting and the system automatically generates postings in Financial Accounting. Such costs, which are directly traced to the cost object that used the materials, are called direct costs. These actual costs are allocated to the production order.

Results: By posting goods issues and material components to production orders, the corresponding material issue is recorded, and stock quantities and stock values are decreased with actual values. The value of the goods issue is determined as follows:

quantity withdrawn x price available in material master data

Note that the price control indicator in the material master record determines whether the costs are updated at standard price or moving average price. The price used is in the Accounting view of the material master record.

Activity Confirmation and Subsequent Postings

When the order is released (released status), activity confirmation can also be input. Based on the routing associated with the order, the system displays, for each operation, the default values for the quantities to be confirmed and where they are handled. These quantities of activities can be changed.

Result: When activities are confirmed, the cost centers, analytically representing the work centers, by means of this internal activity allocation, are credited by the amount of allocated costs (quantity of activity confirmed x activity rate). In counterpart, the order is debited automatically. The price (standard or actual) used to value the activities is determined thanks to the valuation variant linked to the order. The system uses the valuation variant that is assigned to the costing variant specified in the Costing variant actual field in the production order, inherited from configuration activities in the order type.

Note

You can use milestone confirmation in order-related production.

Confirming a milestone automatically confirms all preceding operations larger than the previous milestone in the routing. Milestones can include an automatic goods receipt, selecting the relevant BOM for material withdrawals. The goods receipt is linked to the milestone confirmation using the backflush method, with material quantities defaulted from the BOM in the production order. In backflushes, the order is debited by a goods issue, with material quantities valued with a price from the material master record, in accordance with the price control indicator.

This graphic shows the impact on the production order cycle of the business events (Goods issue or Activity confirmation) and their impact in terms of calculation (WIP and Overhead Posting).

Overhead Calculation

Let’s now outline the overhead costs calculation related to prior business event postings, such as goods issues and activity confirmations.

To know more about the overhead costs' calculation, please refer to the course, Evaluating Cost Estimate options.

As already mentioned, SAP recommends using the event-based overhead calculation, the default method in SAP S/4HANA Cloud, Public edition. This method, part of the Event-Based Production Cost Posting (scope item 3F0) solution, posts production costs as well as their associated overhead costs as they occur rather than at the end of the period. Overhead costs are automatically posted alongside each business transaction when producing a service or material, such as issuing goods or confirming production activities. This method eliminates the need for additional steps in Management Accounting and Margin Analysis.

The calculation uses a costing sheet associated with the order type through the valuation variant.

After defining this event-based costing sheet, the system calculates the overhead for each business transaction input. If a transaction includes a cost that matches a cost element defined in the costing sheet’s cost basis, the overhead is calculated based on the specified percentage rate. The system posts the resulting overhead amount in a separate journal entry.

If an outgoing posting is partially or completely reversed (for example, cancellation of activity or goods issue), the system recalculates or reverses the overhead, keeping the overhead costing consistent.

Partial Goods Receipt and Subsequent Calculations

After all production operations are executed, you need to update the inventory records in SAP S/4HANA Cloud and post the goods receipt for the manufactured products, such as for some framesets.

As soon as you post the receipt of the goods, the finished framesets are passed on to the stock and the order is credited. This capitalization is valued at standard price.

Goods receipts can be created automatically at the time of confirmation of the last operation of the routing in a manufacturing order.

When delivering goods to the make-to-stock inventory, the valuation occurs as follows: quantity delivered to inventory x price.

The price used is found in the Accounting 1 view of the material master record. In addition, the price control specified in the accounting view determines which price to select to valuate the goods receipts: standard (S) or moving average price (V).

For example, when a frameset (whose price control is mentioned as S) is delivered to stock, the order will be credited using the standard price.

This graphic shows you an extract of the production order cycle that emphasizes the business event (Partial Goods receipt) and their impact in terms of incurring costs.

Work in Process

Each time goods are received into inventory; the system valuates the receipt and credits the manufacturing order accordingly. The actual costs posted to an order can equal or differ from the value an order is credited upon goods receipt.

Such credit and debit differences are processed during order settlement. Depending on whether the production is finished or not, there are 2 situations to distinguish. Here, the production is still ongoing. Work in process (WIP) is capitalized.

The WIP value is the difference between the actual debit costs and actual credit costs of an order that hasn’t been fully delivered. Actual debit costs include raw materials/components value, internal activity, external activities, and order overhead. Actual credit costs include the finished product value that was delivered from order to stock.

This graphic details the formula for WIP calculation.

Event-Based Production Cost Posting (3F0)

In SAP S/4HANA Cloud, Public Edition, the Event-Based Production Cost Posting (3F0) scope item is selected by default. In addition, if the Settlement based on business events approach is chosen for your production order (through event-based processing key RSEBW in order type), the system calculates and settles WIP automatically, after each additional goods issue or activity confirmation.

Note

Remember that the Event-Based Production Cost Posting (3F0) offers two approaches:

  • Settlement based on business events (Event-Based Order with Event-Based Production Cost Posting (primary approach))
  • Manual Settlement (Event-Based Order with Manual Settlement (alternative approach)

You can use the Work in Process – Event-Based app that uses event-based posting to show up-to-date work in process and other information for all production orders (order type categories 10 - production orders).

More generally, statuses have also an impact on the type of calculation to be performed: WIP or variances (detailed later in the lesson).

Product Cost by Order has the following statuses:

  • If the order has neither the status delivered (DLV) nor technically completed (TECO), WIP is calculated based on actual costs. The difference between all debits and credits of the order is the value of the WIP.
  • If the order has status DLV or TECO, any existing WIP will be canceled, and the system considers the entire remaining order balance as variances. Various variance causes are evaluated and summarized into appropriate variance categories.
This graphic details the formula for WIP calculation depending on the order status (Actual costs if status is PREL or REL, Actual Costs-Valuated Goods Receipt).

Final Goods Receipt and Subsequent Postings

By posting a final goods receipt for the last finished framesets of the production order, the corresponding production quantities are documented. Stock quantities and stock values are increased. The finished products are valued at a standard price. In parallel, since production is completed, the production order should be credited in full (balance of zero). It is done by the automatic settlement of the production order.

This graphic shows an extract of the production order cycle that emphasizes the business event (Final Goods Receipt and Final Activity confirmation) and their impact in terms of incurring costs.

There are 2 situations to distinguish depending on whether the production is finished or not. Now, the production is finished.

When the last finished goods are delivered to stock, the order status is set to Delivered (DLV). Any remaining work in process value must be zero. The variance is settled.

Order balances are posted to both total price differences and production variance categories, which can indicate production performance in product profitability reporting. Meanwhile, the total price difference is settled to the actual costing/material ledger.

This graphics shows the impact on the production order cycle of the business events (Goods issue or Activity confirmation), activating a new status DLV (Delivered) and their impact in terms of calculation (WIP Clearing and Variance Posting).

Variance

Before discussing variance calculation, let's review the different valuations in the production process. At the start of the fiscal year, production accounting sets a standard cost estimate using routing and bill of materials data, determining the standard price for bike framesets applied to all goods movements. Then, the production order calculates planned manufacturing costs, and variances are found by comparing the results of the preliminary cost estimate (planned costs for the order) with the results of the standard cost estimate (planned costs for the material). After the final goods receipt, actual costs are compared with both estimates for variance analysis.

After some configuration activities, total variance (difference between the actual costs debited to the object and the credit from goods receipt) can be split into different variance categories:

  • Input quantity variance
  • Input price variance
  • Resource usage variance
  • Output price variance
  • Lot size variance
  • Remaining variance

This topic is detailed in the course, Detailing Production Accounting by Order, or you can see Variance Split Categories for more information.

This graphic details the formula for WIP and Variance calculation depending on the order status. The emphasis is put on the different variance categories, as presented earlier.

Production Costs and Variance

In order to improve your analysis, you can use the following apps. From the Production Cost Overview - Event-Based app launcher, you can drill down in to the variance details for specific orders.

You can also use directly the Analyze Production Costs - Event-Based app to have an overview of the total variance and variance split.

The most detailed is the Order Cost Details - Event-Based app.

The Product Profitability with Production Variances app can be used to analyze contribution margins and other profitability characteristics. It allows for a detailed examination of fixed and variable costs based on the standard cost component split. Additionally, it provides reporting on product variances. This app supports only production variances with the event-based variance category split.

Log in to track your progress & complete quizzes