Planning to Product and the Impact to Product Costing

Objective

After completing this lesson, you will be able to understand the Impact to Product Costing

Product and Product Costing

Material Requirements Planning in the Make-to-Order Scenario

Material requirements planning (MRP) is carried out for the configurable forklift's material number through the MRP run. The MRP run identifies the individual customer requirement from the customer order—in this example, customer order number 92. This identification is controlled by the requirement type "KEK" (German: Kundeneinzelkonfiguration, or customer individual configuration) in the customer order item.

The MRP run incorporates the variant configuration from the customer order item for the forklift truck into the generated planned order. In the configuration used here, all assemblies—including configured assemblies such as counterweight, motorization, etc.—have the collective requirement indicator set in their material master records.

Key Implications:

  1. There is no separate planning for configured variant assemblies in this MRP run
  2. Variant assemblies are planned differently, such as based on inventory development
  3. The company maintains inventories for all variants

If the variant assemblies were controlled based on individual requirements, the MRP run would have:

  • Generated a separate planned order for each variant assembly controlled by individual requirements, or
  • Created a purchase requisition for materials identified as external procurement items

This individual-requirement approach wasn't used in this scenario because it would have significantly increased complexity—especially in the subsequent exercise. Since the focus is on profitability accounting, we opted for collective requirement planning instead of individual requirement planning.

Material Requirement Planning for Sales Order

First, a look at the inventory and requirements list shows the MRP feature of the customer order with the order number 92. The individual customer requirements reduce to a certain extent the availability of the material related to the forklift truck CM-FL-V00.

Stock/Requirement List

In this scenario, the MRP run will recognize the individual customer requirement and generate a planned order for the forklift with the number CM-FL-V00. The following figures show the individual steps for creating an MRP run.

Schedule MRP Runs - Step 1

The first step is, if necessary, to select a template for the MRP run and assign an ID.

Schedule MRP Runs - Step 2

In the second step, the start of the MRP run is specified - in this case, single run, and immediate start. It is also specified whether it is a recurring, i.e., periodic, MRP run. Here, the MRP run is set as a single run.

Finally, in the third step - as shown in the following figure - the selection is determined. The selection is made via the material number, so that other customer orders would also be considered if necessary.

The MRP run is usually carried out as regenerative planning. This means that existing plans are only replanned if there is a change in the data relevant to planning. For example: new date, new quantity, or changes in the bill of materials (BOM) or routing.

Schedule MRP Runs - Step 3

The third step involves the precise selection of the requirements that are to be processed by the MRP run. In the scenario presented here, reference is made to the material number and plant. Requirements that have already been processed by the MRP run would also be reprocessed if the bill of materials had changed. Even a transit stock of ordered goods could be considered. The Regenerative Planning indicator was not set, which means that existing planning will not be replanned without changes to the planning-relevant data (new date, new required quantities). The aim of this scenario is to show that the customer order with number 92 was selected by the MRP run and a planned order was created accordingly. All required raw materials are in stock and therefore available.

As the following figure shows, a planned order with the order number 16 was generated by the MRP run for the customer order with the order number 92.

Plan-Order generated based on Sales Order

We will look at the planned order and take a closer look.

The planned order must be assigned to the sales order. Only then will the inventory generated during production be posted as a customer order individual inventory. This is necessary because the delivery for the customer order can only be posted with the customer individual inventory. After all, the customer doesn't want just any forklift, but the forklift configured in his order. The figure below shows the assignment of the planned order with number 4000000003 to the sales order with order number 16.

Planned Order assigned to Sales Order

With reference to the individual customer production, the configuration of the product - in this case the forklift truck - and the associated components such as drive, counterweight, etc. must also have been included in the planned order. This is shown in the following figure.

Variant configuration in the planned order

In the next step, the planned order is converted into a production order. This is usually done in a collective processing. In the sense of this scenario in this learning, this is done by individually processing the planned order.

Converting Planned Order in Production Order

For the planned order to be converted into a production order, the indicator for implementation must be set in the planned order. The following figure shows this.

Conversion Indicator in Planned Order

To clarify this planning step, the following figure shows the selection of the planned order in the requirements and inventory list. By double-clicking, you can then select which order type the planned order should be converted into. In this scenario of discrete manufacturing or plant construction, this is implemented in a production order.

Conversion of a Planned Order into a Production Order

A look at the production order shows that the customer order has been assigned. The configured customer order BOM with the configured components has been transferred to the production order.

Another aspect is the preliminary costing for the production order. The calculated planned costs are identical to the customer order costing.

However, the customer order calculation could still contain administrative and sales overhead costs that are not included in the preliminary calculation for the production order. In this respect, a distinction must be made between COGM (production order, valuation of inventory) and COGS (plus administrative and sales overhead costs).

Profitability accounting or margin analysis is based on the COGM used for inventory assessment. COGM is the basis for the evaluation of goods issue as part of the delivery for the customer order. In this scenario, no administrative and sales overheads were calculated.

Production Order with Assignment to Sales Order - MTO

The figure below shows how the preliminary cost estimate for the production order can be selected. The second figure shows that the itemized proof for the preliminary cost estimate of the production order contains the variant components.

Selection of the preliminary costing of production order
Itemization of Preliminary Costing

Production Order Processing

As part of capacity planning, all work steps are planned with the earliest start date and start time at the respective workstations. In this scenario, this takes place at the workstation level. SAP S/4HANA also contains the PP-DS (Production Planning Detailed Scheduling) function. In PP-DS, the scheduling and capacity planning is refined for each individual resource, for example, handling robots, processing robots, etc. With the focus on profitability accounting and the associated explanation of the transfer of production deviations according to margin analysis, PP-DS will therefore not be discussed further.

In addition to the availability of the required working hours at the workstations, the availability of the required components is also checked. If the availability of all required resources is confirmed, the production order can be set to the RELEASED status. This leads to the reservation of all components and working hours.

The production order can be printed after approval. Of course, everything is usually done digitally. This includes, for example, work papers that are handed over to the production employees.

The steps of material consumption, production order confirmation, and warehouse receipt are explained in the following lessons. Finally, the variances are calculated and settled to Margin Analysis.

Schedule and Release the Production Order

Before production control can begin, the availability of materials must be checked. If the availability of materials is given, the production order can be set to the RELEASED status. This means that the required materials are reserved according to the component overview. The required production times are also reserved according to the process overview.

The following two figures show the component overview and the process overview for the production order. The component overview contains the components based on the variant configuration of the related sales order.

Component Overview in Production Order

The process overview was also transferred from the sales order. Reason: The variant configuration may make it necessary for the configured forklift to be manufactured on variant-specific workstations.

The following figure shows the operations for the forklift production order.

Operations of the Production Order

The operations for the production order were planned down to the second. Each operation has an earliest start date and start time, process duration, and correspondingly calculated earliest end date and end time.

Schedule of Operations in Production Order

Material Movements & Event-Based Work in Process

The posting of material consumption refers to the materials reserved for the production order. Material consumption occurs for the order. The figure also shows that material consumption could also occur at a cost center. In this context, however, this only applies to operating materials if the consumption quantities are so small that they are not assigned to the production order as cost items. Rather, these costs are considered via overhead surcharges.

The removal of material is documented via a goods issue slip.

The integration of material consumption into accounting is explained below.

Of course, the material statistics are updated with the material consumption.

Since the material ledger is generally active in SAP S/4HANA, the material inventory and the corresponding material movements are managed or posted in the company code currency and in the group currency.

Post Goods Issue for Production Order

As the previous figure shows, the reserved materials are selected for the production order. The counterweight of 5000 kg is made up of 5 counterweight plates of 1000 kg each. In this scenario, a withdrawal quantity of 6 plates is booked from the Counterweight Plate component instead of 5 plates. This will lead to a quantity variance in the variance analysis of the production order.

Using the Analyze Order app, we can analyze the costs of the production order.

The following figure shows that the actual costs for the counterweight are EUR 110,- higher than the planned costs. This is due to the goods issue of 6 counterweight plates instead of the required 5 counterweight plates. It can also be seen that no target costs were calculated. The target costs result from multiplying the calculated costs per unit of the product (forklift) by the actual yield quantity reported within a confirmation for the production order. Since no confirmation has been recorded yet for the production order, no target costs were calculated.

Analyze Production Order Costs – Material Consumption

From the Analyze Order report, you can jump to the individual line item and from there to the material document. From the material document, you can jump into the accounting documents. The accounting document shows the posting of the material consumption with the posting inventory change against inventory.

Accounting document for material goods issue - expenses

The system created two accounting documents. The second accounting document contains the posting:

Inventory Change against Inventory

Which is relevant for balance sheet and profit & loss statement.

Accounting Document for Goods Issue – results relevant

The first accounting document contains the creation of Work in Process (WIP) based on the material costs.

List of Documents in Accounting
Accounting document for material goods issue – Work in Process

Note

Because the indicator for Event-based posting has been set in the production order – based on the order type of the production order – the system automatically created Work in Process (WIP) based on the material cost.
Indicator Event-based Posting in the Production Order

Because these are expenses posted with assignment to the CO object production order, a cost accounting document is also created in addition to the financial accounting document for prima nota reasons.

Controlling Document Goods Issue for Production Order

Based on Event-based posting being active for the production order, the inventory change for Work in Process (WIP) has been posted.

Controlling Document Inventory Change WIP Event Based

The Material Ledger document displayed in the selection documents shows the posting in company code currency (FI) and group currency (CO).

Material-Ledger Document

Confirmation of the production order

An order confirmation is used for the consumption of internal activities. Confirmations are an important basis for entering internal activities performed for an order, progress check, and subsequent capacity requirements planning. For this reason, exact real-time confirmations are important.

After an order has been confirmed, the subsequent functions are performed. The confirmed quantity, the CNF (finally confirmed) status, and the actual costs are written in the production order. When an operation is confirmed, an automatic goods issue could be posted based on the quantity assigned to the material components (backflush). The material components must be prepared for backflush posting and provided for use at the work center.

When you confirm the last operation (or confirm the operation where this posting is defined in the control key), an automatic GR is posted.

Depending on the request, the GR posting for the materials produced can be attached to the order confirmation or carried out separately.

Capacity reduction is carried out in proportion to the quantity or activity. If a scrap or rework quantity is confirmed, the system automatically generates a quality notification.

Confirmation for Production Order

The figure above gives an overview of the operations to confirm. The order quantity from a forklift is recorded as the actual good quantity. The production order therefore has the status CNF, which means finally confirmed.

Confirmation and Completion of a Production Order Operation
Status of Production Order with Final Confirmation

The goods receipt for the production order can also be posted automatically. This can be set using a corresponding control key in the work process in the production order. This is not the case in this scenario. Therefore, the goods receipt of the actual good quantity recorded as 1 piece is posted manually as part of the confirmation. The production order is then given the status DLV (Delivered) and the cost variances can be calculated.

Note

With the final confirmation of all operations, the production order is still not completed. Only with the posting of the goods receipt for the final confirmed yield quantity will the production order get the status DLV – Delivered. Because of this, there is no offsetting entry for the WIP.

Goods Receipt Production Order – WIP Event-based

The GR posting represents the stock receipt of a product produced using a production order. The following functions are executed when a GR is posted:

  • The system generates material documents, accounting documents, material ledger documents, and controlling (CO) documents.
  • The material document describes the goods movement from a materials management (warehouse) perspective.
  • The accounting document describes the goods movement from a financial accounting (FI) perspective.
  • The system updates the delivered quantity in the order.
  • The CO document records the credit posted to the production order.

The GR posting is controlled using a movement type (101), to which each posting refers. This can take place manually or automatically.

The material ledger document updates the moving price.

Goods Receipt Production Order

The figure shows the posting of the goods receipt. The plant and storage location are automatically selected from the production order if it has been entered there. Otherwise, it must be entered with the goods movement.

Accounting Document for Goods Receipt in MTO

The financial accounting document shows that the goods receipt was valued based on the sales order cost estimate.

The work in process (WIP) has been offset.

The production order gets the status DLV – Delivered. The indicator for final delivery has been set.

Production Order with status delivered (DLV)
Stock Type in MT

Since this is a make-to-order production, the goods receipt was posted with the inventory type E - customer order stock.

Calculation of Variances – Event-Based

In this scenario, a quantity deviation occurs because instead of the required 5 pieces of counterweight plates, an actual quantity of 6 pieces of counterweight plates was posted as goods issue.

The goods issue of the components used leads to a debit posting on the production order cost object. The actual times recorded as part of the confirmation for the production order led to an actual performance allocation of the production cost centers to the production order. Here too, with a debit posting. Additional actual cost debits would be possible, for example, by using additional external services. The posting of the goods receipt of the actual good quantity in the form of the forklift truck produced, on the other hand, leads to a credit posting. Since the production order has the status DELIVERED, the actual cost balance is also the variance.

Event-based posting of variances

In SAP S/4HANA Public Cloud Edition, event-based posting is the standard. If the indicator for event-based posting is set in the production order, it is not necessary and not possible to calculate variances manually.

Notification

The calculated variances can directly be analyzed in margin analysis.

The report shows the quantity variances of the production order, which has an assignment of the sales order.

Product Profitability with Production Variances

The variances in the margin analysis report are shown in group currency USD.

To get a detailed report of the variance categories, you can use the costing analysis in the production order. In the production order, you can select the cost analysis.

Goto > Costs > AnalysisProduction Order Costs

The figure above shows the cost variances in company code currency of about EUR 110. The reason is the posting of goods issue for the counterweight plate of 6 pcs. instead of the needed 5 pcs.

You can navigate to the detailed variance analysis by pressing the arrow on the left.

The following figure confirms that there is a quantity deviation between the target quantity of 5 pieces and the actual quantity of 6 pieces. The additional consumption of 1 piece was multiplied by the price of the counterweight relevant for the evaluation.

Variance Analysis Production Order

Settlement of Variances Event-based

In SAP S/4HANA Public Cloud Edition, you do not need to perform the settlement of Work in Process (WIP) or variances, as it is calculated automatically and updated in the universal journal ACDOCA (Accounting Documents Actual).

The same applies for the settlement. When the variances have been calculated automatically and updated in ACDOCA, you can analyze them using CDS-based reporting. Using the event-based posting, the production order does not need to be settled manually. The cost report in the production order shows that the actual costs have a balance of zero.

The figure below shows that the production order is automatically credited with the variances. Therefore, the actual balance is zero.

Costing of Production Order – Actual Balance

Log in to track your progress & complete quizzes