You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Status

  Approved

Owner
Stakeholders

Issue

The purpose of this document is to provide an assessment of the two valuation approaches that we have currently in Syensqo. These are,  the revaluation on actuals with the use of the Material ledger and the so-called semi-standard approach. The objective is to collectively, business and IT,  assess what will be the approach that will be implemented in the S4 in relation to the above.

This document explores in detail the product cost approach and the integration with the manufacturing.


Decision


Background & Context


We currently have two systems with two different valuation approaches and ways of working. These differences stem from mergers and acquisitions (M&As), where the acquired organizations used different valuation methodologies. Additionally, there were fiscal requirements that necessitated deviations from standard operating procedures. In this document, the two approaches are referred to as follows:

    • Re-valuation on actuals with Material ledger for PF1
    • Semi-standard for WP1

Assumptions

  • Currently we have two different approaches for assigning company codes to controlling areas in the two systems. These are, 
    • PF1: single controlling area 
    • WP1: Four controlling areas by Region (Europe, APAC, North America, South America) + one for Financial companies, total five controlling areas
  • In S4 we anticipate having a uniform enterprise structure. Especially on lower controlling objects like cost centers, profit centers, segments etc
  • In S4 we will have a single costing approach for all Legal entities. Local deviations are expected due to local fiscal requirements.
  • The product cost system will be S4
  • The implications of Universal Parallel Accounting, whether positive or negative, on the valuation question are not considered in this KDD. There will be another KDD to address Universal Parallel Accounting's new features and their overall implications for product costing.
  • Manufacturing is using Manufacturing Execution Systems (MES) as well as planning systems, specifically Dynasys, and in the future, Kinaxis. MES and in some instances spreadsheets and manual input feeds SAP processes and production orders with confirmations and consumptions. 
  • Currently, in PF1 the confirmation is on std quantities and hour
  • Currently, In WP1, some plants confirm actual quantities and hours, while others do not.
  • Std prices are calculated in both systems
  • Activity prices are entered manually. Although in WP1, there is an activity calculation process, the capacities are loaded manually. Please see below on the additional information sections  


Constraints

  • In S4 material ledger is mandatory. but his does not imply that actual cost is mandatory.
  • If the transfer price functionality is implemented then actual costing has to be activated. Transfer price functionality is addressed to a separate KDD with the same title.


Impacts


Business Rules


Options considered

Option A:

Revaluation on actuals with Material Ledger (PF1)

The Material Ledger consists of two main functionalities: actual costing and parallel valuation. A common misconception about the Material Ledger is that it refers solely to actual costing because actual costing tends to get the most attention. Therefore, when hearing the term “Material Ledger,” many immediately think of actual costing, not parallel valuation. Conversely, when the actual costing functionality is mentioned, it’s usually referred to generically as a “Material Ledger functionality.”  Furthermore, the Material Ledger falls within the CO menu, but it has as much impact on the FI module as it does in the CO module because of its impact on the inventory transactions that are posted to the general ledger

Actual costing generates a Material Ledger document and valuates all goods movements within a period at the standard price (preliminary valuation). At the end of the period, you calculate the actual price for each material based on the actual costs of the period. You call this actual price the periodic unit price, and you can use it to revaluate the inventory and COGS (and other consumptions) for the period you are closing. In addition, you can use this actual price as the standard price for the next period.

The revaluation on Actuals with Material Ledger makes it possible to use an actual cost system in addition to the standard cost system, because the values of the standard cost cannot be readjusted during a subsequent allocation. The Revaluation on actuals program with ML creates postings to the general ledger and relevant cost objects.

Option B: Semi standard

The semi-standard approach emphasizes the importance of accurately calculating and allocating costs in a manufacturing environment. It distinguishes between fixed and variable costs and ensures proper accounting and variance tracking to maintain cost efficiency and accuracy. The semi-standard costing method is highlighted as a key practice for effective cost management.

Raw materials, trading goods, semi-finished and finished products, and packaging are controlled under Price Control S (standard price), while spare parts use Price Control V (moving average price). In SAP, the Moving Average Price (MAP) is calculated regardless of the material's price control designation. If a material is under Price Control S (standard cost), the MAP serves only as statistical information. The MAP is calculated at every goods receipt by considering the quantities and values in stock along with the quantities and purchase price of the goods receipt (GR). If the invoice does not match the quantities and values of the GR, the variances are also considered in the MAP, provided there are stocks available at the time of invoice verification. 

Exceptionally, in Brazil and Korea, raw materials are valued at the moving average price (Price Control V) due to tax authorities' requirements. Strategic raw materials can have their prices entered manually if the MAP is not adequate for calculating the semi-standard cost of the period.

A new standard price is recalculated monthly for raw materials, packaging, semi-finished products, finished products, and trading goods. This recalculated price is then released, revaluating the inventory accordingly.

The strategy sequence used in the semi-standard approach (WP1) is as follows:

- Commercial price

- MAP (Moving Average Price) plus any additive cost

- Purchase price (info-record)

- Standard price

This valuation strategy ensures that with the new standard price calculation, the Moving Average Price becomes the standard price for raw materials, trading goods, and packaging. Using the cost roll-up method, these new standard prices for the Bill of Materials (BOM) components will roll over multiple production levels all the way to the Semi Finished and finished products.

In summary, the semi-standard approach is also a "revaluation on actuals" process with notable similarities and differences, which are summarised below.



  1. Similarities and differences 

The two methods might sound different but are quite similar. ML Actual valuation allocates cost variances from lower levels of production to higher levels, whether these variances come from purchasing or production. Similarly, the semi-standard approach does the same but instead of allocating variances, it recalculating the standard prices by using the moving average price.

One major difference between the two approaches is that the ML approach revaluates not only the inventory but the COGS and other consumptions, as well.

Broad Similarities and differences:

There are some important similarities and differences between the two approaches that we need to look at closely. The similarities are not about the system used (which is SAP in both cases) but more about the accounting and management aspects. On the other hand, there are also some key differences between the two approaches. Below, we will list these differences and similarities and see what can stay the same regardless of the final choice. By doing this, we want to show that even though there are differences in how things are done, the accounting and management results are not significantly affected.






Option C: 





Option D: 


Evaluation



Option A

Option B
Option C
Option D
Criterion 1

(plus)Pro

(minus)Con

(plus)Pro

(plus)Pro

(plus)Pro

(minus)Con

(plus)Pro

(minus)Con

Criterion 2

(plus)Pro

(minus)Con

(minus)Con

(plus)Pro

(plus)Pro

(minus)Con

(minus)Con

Criterion 3(plus)Pro(minus)Con(minus)Con(plus)Pro

See also


No files shared here yet.

Change log

Version Published Changed By Comment
CURRENT (v. 11) Aug 07, 2024 18:12 TAMIOLAKIS-ext, Emmanouel
v. 84 Aug 07, 2024 17:58 TAMIOLAKIS-ext, Emmanouel
v. 83 Aug 07, 2024 14:00 TAMIOLAKIS-ext, Emmanouel
v. 82 Aug 05, 2024 14:11 TAMIOLAKIS-ext, Emmanouel
v. 81 Aug 05, 2024 10:29 TAMIOLAKIS-ext, Emmanouel
v. 80 Aug 02, 2024 14:18 TAMIOLAKIS-ext, Emmanouel
v. 79 Aug 02, 2024 14:17 TAMIOLAKIS-ext, Emmanouel
v. 78 Jul 30, 2024 10:17 TAMIOLAKIS-ext, Emmanouel
v. 77 Jul 29, 2024 17:36 TAMIOLAKIS-ext, Emmanouel
v. 76 Jul 29, 2024 17:22 TAMIOLAKIS-ext, Emmanouel
v. 75 Jul 25, 2024 16:01 WENNINGER-ext, Sascha
v. 74 Jul 25, 2024 08:48 TAMIOLAKIS-ext, Emmanouel
v. 73 Jul 25, 2024 08:47 TAMIOLAKIS-ext, Emmanouel
v. 72 Jul 24, 2024 17:24 TAMIOLAKIS-ext, Emmanouel
v. 71 Jul 24, 2024 17:07 TAMIOLAKIS-ext, Emmanouel
v. 70 Jul 24, 2024 16:53 WENNINGER-ext, Sascha
v. 69 Jul 24, 2024 15:46 TAMIOLAKIS-ext, Emmanouel
v. 68 Jul 24, 2024 13:41 TAMIOLAKIS-ext, Emmanouel
v. 67 Jul 24, 2024 13:07 WENNINGER-ext, Sascha
v. 66 Jul 24, 2024 13:02 WENNINGER-ext, Sascha
v. 65 Jul 24, 2024 12:55 WENNINGER-ext, Sascha
v. 64 Jul 23, 2024 10:17 TAMIOLAKIS-ext, Emmanouel
v. 63 Jul 18, 2024 17:53 TAMIOLAKIS-ext, Emmanouel
v. 62 Jul 18, 2024 12:02 TAMIOLAKIS-ext, Emmanouel
v. 61 Jul 18, 2024 11:45 TAMIOLAKIS-ext, Emmanouel
v. 60 Jul 18, 2024 10:23 TAMIOLAKIS-ext, Emmanouel
v. 59 Jul 18, 2024 10:10 TAMIOLAKIS-ext, Emmanouel
v. 58 Jul 18, 2024 10:00 TAMIOLAKIS-ext, Emmanouel
v. 57 Jul 18, 2024 09:35 TAMIOLAKIS-ext, Emmanouel
v. 56 Jul 18, 2024 09:25 TAMIOLAKIS-ext, Emmanouel
v. 55 Jul 18, 2024 09:14 TAMIOLAKIS-ext, Emmanouel
v. 54 Jul 17, 2024 17:21 TAMIOLAKIS-ext, Emmanouel
v. 53 Jul 17, 2024 17:19 TAMIOLAKIS-ext, Emmanouel
v. 52 Jul 17, 2024 16:39 TAMIOLAKIS-ext, Emmanouel
v. 51 Jul 17, 2024 16:08 TAMIOLAKIS-ext, Emmanouel
v. 50 Jul 17, 2024 15:39 TAMIOLAKIS-ext, Emmanouel
v. 49 Jul 17, 2024 13:12 TAMIOLAKIS-ext, Emmanouel
v. 48 Jul 17, 2024 12:59 TAMIOLAKIS-ext, Emmanouel
v. 47 Jul 17, 2024 11:48 TAMIOLAKIS-ext, Emmanouel
v. 46 Jul 16, 2024 19:15 TAMIOLAKIS-ext, Emmanouel
v. 45 Jul 16, 2024 19:03 TAMIOLAKIS-ext, Emmanouel
v. 44 Jul 16, 2024 18:36 TAMIOLAKIS-ext, Emmanouel
v. 43 Jul 16, 2024 17:53 TAMIOLAKIS-ext, Emmanouel
v. 42 Jul 16, 2024 17:14 TAMIOLAKIS-ext, Emmanouel
v. 41 Jul 16, 2024 10:50 TAMIOLAKIS-ext, Emmanouel
v. 40 Jul 15, 2024 13:59 TAMIOLAKIS-ext, Emmanouel
v. 39 Jul 15, 2024 12:54 TAMIOLAKIS-ext, Emmanouel
v. 38 Jul 15, 2024 12:50 TAMIOLAKIS-ext, Emmanouel
v. 37 Jul 12, 2024 18:20 TAMIOLAKIS-ext, Emmanouel
v. 36 Jul 12, 2024 18:16 TAMIOLAKIS-ext, Emmanouel
v. 35 Jul 12, 2024 17:57 TAMIOLAKIS-ext, Emmanouel
v. 34 Jul 12, 2024 17:28 TAMIOLAKIS-ext, Emmanouel
v. 33 Jul 12, 2024 17:13 TAMIOLAKIS-ext, Emmanouel
v. 32 Jul 12, 2024 16:48 TAMIOLAKIS-ext, Emmanouel
v. 31 Jul 12, 2024 16:35 TAMIOLAKIS-ext, Emmanouel
v. 30 Jul 12, 2024 16:08 TAMIOLAKIS-ext, Emmanouel
v. 29 Jul 12, 2024 15:48 TAMIOLAKIS-ext, Emmanouel
v. 28 Jul 12, 2024 15:31 TAMIOLAKIS-ext, Emmanouel
v. 27 Jul 12, 2024 15:01 TAMIOLAKIS-ext, Emmanouel
v. 26 Jul 11, 2024 18:43 TAMIOLAKIS-ext, Emmanouel
v. 25 Jul 11, 2024 18:40 TAMIOLAKIS-ext, Emmanouel
v. 24 Jul 09, 2024 14:40 TAMIOLAKIS-ext, Emmanouel
v. 23 Jul 04, 2024 19:14 TAMIOLAKIS-ext, Emmanouel
v. 22 Jul 04, 2024 19:04 TAMIOLAKIS-ext, Emmanouel
v. 21 Jul 04, 2024 18:58 TAMIOLAKIS-ext, Emmanouel
v. 20 Jul 04, 2024 18:28 TAMIOLAKIS-ext, Emmanouel
v. 19 Jul 04, 2024 17:43 TAMIOLAKIS-ext, Emmanouel
v. 18 Jul 03, 2024 12:42 WENNINGER-ext, Sascha
v. 17 Jul 03, 2024 12:14 WENNINGER-ext, Sascha
v. 16 Jul 03, 2024 11:55 TAMIOLAKIS-ext, Emmanouel
v. 15 Jul 02, 2024 18:35 TAMIOLAKIS-ext, Emmanouel
v. 14 Jul 01, 2024 08:28 TAMIOLAKIS-ext, Emmanouel
v. 13 Jun 21, 2024 15:26 TAMIOLAKIS-ext, Emmanouel
v. 12 Jun 21, 2024 15:24 TAMIOLAKIS-ext, Emmanouel
v. 11 Jun 20, 2024 16:51 TAMIOLAKIS-ext, Emmanouel
v. 10 Jun 20, 2024 16:25 TAMIOLAKIS-ext, Emmanouel
v. 9 Jun 20, 2024 13:18 TAMIOLAKIS-ext, Emmanouel
v. 8 Jun 20, 2024 13:17 TAMIOLAKIS-ext, Emmanouel
v. 7 Jun 20, 2024 13:15 TAMIOLAKIS-ext, Emmanouel
v. 6 Jun 20, 2024 12:31 TAMIOLAKIS-ext, Emmanouel
v. 5 Jun 20, 2024 12:26 TAMIOLAKIS-ext, Emmanouel
v. 4 Jun 20, 2024 12:15 TAMIOLAKIS-ext, Emmanouel
v. 3 Jun 20, 2024 11:59 TAMIOLAKIS-ext, Emmanouel
v. 2 Jun 20, 2024 11:56 TAMIOLAKIS-ext, Emmanouel
v. 1 Jun 20, 2024 11:51 TAMIOLAKIS-ext, Emmanouel

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.

  • No labels