Checking the Assembly Backflush Results for Operation 0010 – Cropping and Forming

Objectives

After completing this lesson, you will be able to:
  • Follow the Calculation Steps of the System when the first Operation is confirmed.
  • Understand the Postings executed Automatically with the Confirmation.

Assembly Backflush Method

Cropping and Forming

In our Handlebar production scenario when operation 0010 - Cropping and Forming is finished, the actual values are entered in the Confirm Repetitive Manufacturing app using the Assembly Backflush method.

The following figure shows that using the app, only the actual activity quantities of the Machine and Labor activity have to be entered as they differ from the default values in the routing. The actual component quantities correspond to the default values in BOM, so using the app no data change is necessary.

This figure illustrates the final confirmation of Operation 0010 in repetitive manufacturing, detailing material usage, activities, and product cost collector information.

When you choose the Post button, a goods issue is automatically posted as the message in the figure shows. You will also see the Material Management document number.

In the following, we will first show the posting results on the product cost collector which has order number 700021 in our scenario and then will we will first calculate all results and finally see which documents are posted in parallel when the Post button in the Confirm Repetitive Manufacturing app is executed.

Posting Results at the End of Operation 0010

If you open the Product Cost Collector Details - Event-Based app, you will find that at the end of operation 0010 - Cropping and Forming Actual Costs of EUR 291 result as well as a Total Cost Variance of EUR 22. WIP is EUR 269.

This figure illustrates the production costs and cost variances for an order, highlighting both total and remaining variances in the production of the handlebar S11-000.

If you had executed the Schedule Product Costing Jobs app after this first operation, you would have got the information that EUR 20 of the Total Variance of EUR 22 represents the Input Quantity Variance and EUR 2 refers to the Remaining Variance. This amount results from an overhead production percentage of 10% which was calculated on top of the activities' amount (and here on top of the Input Quantity Variance of EUR 20).

We will execute the Schedule Product Costing Jobs app when also operation 0020 is finished!

In the following, we will first see how the values on our product cost collector are calculated. In a second step, we will have a look at the documents posted.

How Material Costs and Material Overhead Costs are Calculated

The following figure shows you how the material costs and the overhead costs are calculated.

This figure illustrates the calculation of material costs for the production of Handlebar S11-000, including raw materials and overhead expenses, for a quantity of 10 pieces, with specific cost breakdowns and the total cost summarized under order number 700021 for the product cost collector.

How Production Costs and Production Overhead Costs are Calculated

This figure shows you how the calculation of the production costs takes the following into account: the actual quantities for activity MACH are 4 min per one S11-000 Handlebar and 3 min for activity PERS. In addition, 10% of the production costs represent the calculated production overhead costs.

This figure outlines the calculation of production costs for producing 10 pieces of Handlebar S11-000, including internal activity costs and overheads, leading to a total cost of 77 euros for order number 700021.

Material Costs and Production Costs - Total Actual Costs

The following table gives an overview of the actual material costs and production costs and explains that the Total Actual Costs at the end of operation 0010 are EUR 291.

This figure illustrates the material costs and production costs for producing 10 pieces of Handlebar S11-000, detailing raw materials, overhead, internal activity, and total actual costs.

Calculation of Target Costs 1/2

The following figure summarizes all the relevant data for the calculation of the Target Costs and also contains the cost rates of the activities. These are plan cost rates!

Note

For the calculation of Target Costs it's always the plan cost rates that are relevant. Actual cost rates are not relevant for the calculation of Target Costs. Instead, they are relevant for actual cost estimate calculation.
This figure provides a detailed breakdown of target cost calculations for the production of a single handlebar, outlining machine and labor times, raw material requirements, and associated fixed and variable costs.

Calculation of Target Costs 2/2

The following figure explains how to calculate Target Costs which are always calculated dynamically but not stored in the database.

This figure illustrates the target costs and work-in-progress (WIP) valuation for the production of 10 handlebar units, detailing material, activity, and overhead costs which culminate in a total target cost and WIP of EUR 269 at this operation stage.

The formula in the figure explains how to calculate Target Costs.

Here some annotations:

  • In general, the target quantity is the planned quantity adjusted to the actual output of the product.
  • In our scenario, the planned quantity of 10 S11-000 handlebars equals the quantity of 10 handlebars produced.
  • Since 10 handlebars were planned in our scenario and 10 handlebars are actually also produced, the number of input materials of R111-000 - Bar depends on the lot size of 10 pieces.
  • As a result, the planned quantity and the actual delivery quantity are the same in our scenario.
  • This means that the factor in the formula, namely "Actual Output Quantity/Costing Lot Size", is 10/10 = 1.

At the same time, the actual delivery quantity corresponds to the yield of 10 S11-000 handlebars on the order because there is no scrap. Since no setup costs were planned in our scenario, the Planned Lot Size Independent Costs are zero in the formula.

Since WIP is valuated based on Target Costs, the result value for both is EUR 269.

Calculation of Total Variance

The following figure explains how the Total Variance of EUR 22 is calculated.

As you can see, the difference between Actual Costs and Target Costs results in the Total Variance.

This figure provides a calculation of the total variance for the production of handlebar S11-000, showing actual costs of EUR 291, target costs of EUR 269, resulting in a total variance of EUR 22.

Calculation of Input Variance

If you run the split run, the Total Variance is split in variance categories. In our scenario, EUR 20 of EUR 22 refer to the Input Quantity Variance and EUR 2 of EUR 22 refer to the Remaining Variance.

The following figure explains how the Input Quantity Variance is calculated.

This figure illustrates the calculation of input quantity variance for the production of 10 handlebars, comparing actual input quantities with target input quantities and costs, resulting in an input quantity variance of EUR 20.

Posting Effects of Assembly Backflush

We will now focus on the documents that are created when the Post button in the Confirm Repetitive Manufacturing app is executed.

This figure illustrates the posting effects of assembly backflush - component in repetitive manufacturing, detailing information in a material document (4900000793) for material R111-000 with a quantity of 10 PC moved under Movement Type 261 at Plant 1010.

When you select the Post button in the Confirm Repetitive Manufacturing app, you will get information about the Material Management Document Number and will find that a goods issue of 10 pieces of material R111-000 - Bar was posted on the product cost collector (that is, order ID 700021) using G/L Account 51100000 - Consumption - Raw Material together with Movement Type 261 - Goods Issue.

If you check the Material Documents Overview app for your Material Management Document, you will get some more detailed information about the goods issues including the storage location out of which the material was taken for production.

This figure illustrates the posting effects of an assembly backflush for a component, detailing the material document and accounting information related to the transaction in an SAP system.

In addition, you get information about the accounting document which was created in parallel. This is shown in the Process Flow section of this app.

This figure shows the posting effects of an assembly backflush component entry including account details, quantities, and associated journal entries in DE Plant 1.

Checking the accounting document using the Manage Journal Entries app, you will see that the stock of material is reduced by 10 pieces and an amount of EUR 200. This is represented by a credit posting on the asset G/L Account 13100000 - Inventory Raw Material.

The debit posting is done on expense G/L Account 51100000 - Consumption Raw Material.

In addition you can see that a further accounting document is created.

When you check the second accounting document you can see that it represents the posting of the material overhead costs. They are debited with EUR 14 on the originator of the costs, that is, the product cost collector (Order ID 700021). Cost Center 10101201 - Purch and Store 1 (DE) is credited in parallel according to the setup of Costing Sheet 1010EP - Event-based costing sheet (DE).

This figure outlines the posting effects of an assembly backflush component, detailing journal entries, associated entries, and related documents, including specific monetary debits and credits.

REM Backflush Document

Once again, we will focus on the documents created when the Post button in the Confirm Repetitive Manufacturing app is executed.

This figure illustrates the process and documentation of posting effects in assembly backflush for repetitive manufacturing, highlighting specific details such as confirmation number, counter, document number, cost collector, and quantities involved.

You will also get information about the REM Backflush Document if you open the posting message and double-click the confirmation number which is 907 in our scenario.

The document will show you that the yield quantity actually is 10 pieces since the scrap quantity is zero.

Activity Change 1/3

The accounting document in the following figure shows how many activity quantities of activity MACH and PERS cost center 10101302 - Manufacturing 2 (DE) delivered for the production of the S11-000 - Handlebar and in which amount this cost center was therefore credited. The product cost collector (that is, Order ID 700021) as the cost object is therefore debited with the same amount.

This figure displays the posting effects of an assembly backflush activity change, including associated journal entries, cost centers, activities, and related documents.

This accounting document also references a further accounting document that contains the production overhead costs.

Checking the second accounting document you can see that it represents the posting of the production overhead costs.

This figure illustrates the posting effects of an assembly backflush activity change, detailing the accounting document entries, associated journal entries, and related documents within a company code.

The product cost collector (Order ID 700021) as the originator of the costs is debited with EUR 7 and in parallel Cost Center 10101301 - Manufacturing 1 (DE) is credited according to the setup of Costing Sheet 1010EP - Event-based costing sheet (DE).

The last accounting document contains two postings

  • The Total Variance posting
  • The WIP posting
This figure illustrates the posting effects of an assembly backflush for total variance and WIP, displaying detailed accounting journal entries and related documents.

The Total Variance posting document is posted on the product cost collector (Order ID 700021) and Product S11-000 Handlebar as a debit posting on G/L account 52070000 - Loss Prodn. Var for the S11-000 Handlebar. The credit posting is done on offset G/L account 55100000 - Adj. Plnt act. prod. Order.

The increase of WIP is posted to the product cost collector (Order ID 700021) with a debit posting on G/L account 13200000 - Inventory WIP.

The credited offset G/L account is G/LAccount 54200100 - Inv. Ch WIP Evt Based.

Log in to track your progress & complete quizzes