Versions Compared

Old Version 35

changes.mady.by.user Marielle MOINET

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
borderColor#4DBED3
bgColor#4DBED3
borderStylesolid

SYMPA ACADEMY

 



HideElements
metastruecommentstrue
breadcrumbtrue
childpagestrue
sidebartrue
titletrue
favoritetrue
space-logotrue
toolslabelstrue
Viewtracker
likes
hidelabelstrue




Panel
true
borderColor
viewtracker
#B2E2EC
hide
bgColor
true
#B2E2EC

Structure of the training


Panel
borderColor#B2E2EC
bgColor#f2f2f2
How has been structured the training?

1- The first part explains the construction of the BFC P/L. Several concepts need to be presented such as Master Data, closing process and Product Costing. Master Data

are

 are the static concepts used to carry out properly the closing process. Closing

subsection

 subsection demonstrate the dynamic use of the master data. Product costing

is

 is a sub-product but it is an important section because a big amount of the Cost of Goods Sold (COGS) is built during product costing process.  

2- The second part presents all

the

the reports

to

 to be used to carry out performance analysis and how you can use those reports.

 

 

 

Image Removed


Image Added






Panel
borderColor#B2E2EC
bgColor#B2E2EC

Read me first


Expand
titleUnderstand BFC P/L methodology
 

Include Page
SYMPA academy - Understand BFC P/L

before the implementation of SYMPA model.

 

 

Image Removed

Info
titleInfo
  • Initial inventory = 0
  • Variable cost = 60
  • Fixed Cost Period = 40
  • Dep. Period = 10
  • Sales = 60%
Panel
  • R25460-FC period = 0
  • R25470-Non proportional Cost Absorbed = 0

Those two lines are every month equal to 0 in the BFC P/L before the implementation of SYMPA model.

Panel

FC + Dep. Period = 40 + 10 = 50

We have sold 60% => 50*60% = 30

R25490 COGS FC = 30 – Dep. = 30 – 10 = 20

R25860 Dep. Period  is a FI information available in the balance sheet. In this example, Dep. Period = 10

Let’s imagine that next month there are no sales => COGS has to be equal to 0 but  Dep. Will be still equal to 10. => COGS = 0 – Dep. = 0 – 10 = -10 It is not relevant.   

BFC P/L : Theory

 

Image Removed

Info
titleInfo
  • Initial inventory = 0
  • Variable cost = 60
  • Fixed Cost Period = 40
  • Dep. Period = 10
  • Sales = 60%
Panel
  • R25460-FC period = 40 => In PF1 model all the costs of the period are sent to inventories.
  • R25470-Non proportional Cost Absorbed = -40 => Full absorption is the model applied in PF1, so Non proportional cost absorbed is the absorption of the full amount of FC period.
  • R25490-FC COGS = variable cost * sales = 40 * 60% = 24
  • R25860 Dep. Period  is a FI information available in the balance sheet. In this example, Dep. Period = 10
  • R25870 Dep. Absorbed = -10 => Full absorption is the model applied in PF1, so Dep. absorbed is the absorption of the full amount of Dep. period.
  • R25890-Dep. COGS = dep. period * sales = 10 * 60% = 6

BFC P/L : From theory P/L to PF1 P/L after implementation of the SYMPA model

Warning

The theoretical P/L has been not implemented because the use of R25870-Dep Absorbed and R25890-Dep. COGS would have driven erroneous REBITDA calculation.

Image Removed

Panel
  • R25460-FC period = 40 => In PF1 model all the costs of the period are sent to inventories.
  • R25470-Non proportional Cost Absorbed =  Full absorption of FC period + full absorption of Dep. = -40 + -10 = -50.
  • R25490-FC COGS = variable cost * sales + Dep Period * sales = 40 * 60% + 10 * 60% = 24 + 6 = 30
  • R25860 Dep. Period  is a FI information available in the balance sheet. In this example, Dep. Period = 10
  • R25870 Dep. Absorbed = 0
  • R25890-Dep. COGS = 0

 

methodology
SYMPA academy - Understand BFC P/L methodology


Expand
titleWhere are the data coming to build BFC P/L

Include Page
Where are the data coming from to build BFC P/L?
Where are the data coming from to build BFC P/L?


Panel
borderColor#B2E2EC
bgColor#B2E2EC

SECTION 1 Construction of the P/L


SECTION 1 Construction of the P&L

 
Expand
titleHow P&L is built
Include Page
Rules P&L - PF1Rules P&L - PF1
Expand
titleMaster data


Expand
titleOverview of the CO structure


Expand
titleCO structure

Include Page
CostFAQ:Rules - CO structure - PF1PF2
CostFAQ:Rules - CO structure - PF1PF2


Expand
titleBusiness structure

Include Page
CostFAQ:Rules - Business structure
CostFAQ:Rules - Business structure


Expand
titleProduct hierarchy

Include Page
CostFAQ:Rules - PF1 - PIF
CostFAQ:Rules - PF1 - PIF


Expand
titlePlant

Logistics Organizational Unit representing the place where either materials are produced or goods and services provided.

Identification of production and non production plants.

Use in CO:

  • Organizational Cost Centers standard hierarchy 
  • Profit Centers standard hierarchy 
  • Cost Object Hierarchy (first 2 levels in the structure) 
  • Materials: To identify the ones relevant for costing and to be updated during the Project (Accounting / Costing views). 
  • Material Ledger activation (customizing).


Expand
titleCountry code

1 digit code identifying the country inside Solvay ERP.

Use in CO:

  • Reporting Profit Centers codification at PIF level (position before last)


Expand
titleEstablishment code

It is used in the codification of the Cost Centers (=first two digits) in PF1.

The establishment code is a combination of a legal company on a site

  • SM = cy 0001 SCH
  • XR = cy 0270 Solvay Quimica, Italian in Rosignano
  • SV = cy 0306 Solvay Portugal, Prod Quim.

The codes are part of the enterprise structure and managed by Core Tables 

The establishment code can be displayed with PF1 PF2 - ZPRI Display table ETAB


Expand
titleStructure axes

Include Page
CostFAQ:Rules - PF1 PF2 - Activity 1
CostFAQ:Rules - PF1 PF2 - Activity 1



Expand
titleCost element


Info
titleSAP t-code

KA03 - Display Cost Element


Expand
titleCodification

Include Page
CostFAQ:Rules - Cost Element codification - PF1element Codification
CostFAQ:Rules - Cost Element codification - PF1element Codification


Expand
titleCost elements group


Info
titleSAP t-code

KAH3 - Display cost element group


Expand
titleZRCS-FC

Include Page
CostFAQ:Rules - Cost element Group ZRCS-FC
CostFAQ:Rules - Cost element Group ZRCS-FC


Expand
titleXCS-ALL

 

Include Page
CostFAQ:Rules - Cost element Group XCS-ALL
CostFAQ:Rules - Cost element Group XCS-ALL




Expand
titleCost Center

 


Expand
titleA. Standard hierarchy & codification


Expand
titleStandard hierarchy

 

Include Page
CostFAQ:Rules - PF1 PF2 - Cost Center Standard hierarchy
CostFAQ:Rules - PF1 PF2 - Cost Center Standard hierarchy


Expand
titleReporting Cost Centers - PF1

 

Include Page
CostFAQ:Rules - PF1 PF2 - Cost Center Reporting codification - HISTORICAL INFORMATION ONLY !
CostFAQ:Rules - PF1 PF2 - Cost Center Reporting codification - HISTORICAL INFORMATION ONLY !


Expand
titleOrganizational Cost Centers - PF1

 

Include Page
CostFAQ:Rules - PF1 PF2 - Cost Center Organizational codification
CostFAQ:Rules - PF1 PF2 - Cost Center Organizational codification



Expand
titleB. ZCBS hierarchy

 

Include Page
CostFAQ:Rules - Cost Center ZCBS hierarchy
CostFAQ:Rules - Cost Center ZCBS hierarchy


Expand
titleC. Validity date

 

Include Page
CostFAQ:Rules - Cost Center Validity date
CostFAQ:Rules - Cost Center Validity date


Expand
titleD. Profit Center

The Result (Reporting) Profit Centers are the basis for Group reporting

All elements for BFC statement are extracted from the Profit centers (except NETV, QTV and TPT which are extracted from CO-Profitability Analysis -> CO-PA). To make this extraction work (through interfaces), all objects in CO must be assigned to a profit center;
  • Material (plant level, Costing view)
  • Cost centers
  • CO orders
  • PM orders
  • PP orders
  • Cost collectors
  • WBS
The Result Profit centers are depending on the Profit center group “CHEFCHEOPS”. These profit centers are generally assigned to all the ERP companies;
The non reporting Profit Center are in group “CHEF_CNTRL
 


Expand
titleOrganizational Profit Centers

 

Include Page
CostFAQ:Rules - PF1 PF2 - Profit Center Organizational codification
CostFAQ:Rules - PF1 PF2 - Profit Center Organizational codification


Expand
titleReporting Profit Centers

 

Include Page
CostFAQ:Rules - PF1 PF2 - Profit Center Reporting codification
CostFAQ:Rules - PF1 PF2 - Profit Center Reporting codification



Expand
titleE. Business area

Include Page
CostFAQ:Rules - Cost Center Business Area
CostFAQ:Rules - Cost Center Business Area


Expand
titleF. Responsible

The person responsible of a cost center is accountable for the elements allocated in the cost center

The companies using SRM7 for purchasing should have a SRM7 user ID (=BIP user ID) entered in this field, starting with 5, such as 50000000

To display the list of person responsible use the report PF1 PF2 - SRM Validators in cost centers


Expand
titleG. Name in english

Usually the name & description of a cost center is free but in some cases there can be special needs.


Expand
titleH. Cycles


Expand
titleAssessment cycles


Info

An assessment cycle is used in SAP to assign all primary cost elements and secondary cost elements from a sending cost center to the receiver cost center.When you want to transfer costs from one cost center to another through an assessment cycle, sap use a secondary cost element and accumulates all the primary cost and secondary cost and send it to the receiving cost center.

Include Page
CostFAQ:Assessment cycles - PF1
CostFAQ:Assessment cycles - PF1


Expand
titleDistribution cycles


Info

A distribution cycle is used in SAP to transfer primary costs from a sender cost center to receiving controlling objects. The original cost element remains the same. 

Include Page
CostFAQ:Distribution cycles - PF1
CostFAQ:Distribution cycles - PF1


Expand
titleCOPA cycles


Info

COPA Assessment cycle assesses costs from a Cost Center to COPA Value Fields. 

Include Page
CostFAQ:COPA cycles - PF1PF2
CostFAQ:COPA cycles - PF1PF2



Expand
titleKey Principles

Include Page
Costing Key Principles - PF1
Costing Key Principles - PF1



Expand
titleCost Collector

Include Page
Cost collector
Cost collector


Expand
titleAllocation Structure

Include Page
CostFAQ:Allocation structure - PF1
CostFAQ:Allocation structure - PF1


Expand
titleSplitting Structure

Include Page
Splitting structure - PF1
Splitting structure - PF1


Expand
titleCost Component

Include Page
Cost Component Structures - PF1
Cost Component Structures - PF1



Image RemovedImage Removed

 

Expand
titleClosing

Include Page
Understand the closing process
Understand the closing process

Expand
titleThe daily flow of financial information

Image Removed

 

Expand
titleD4 CO-ML-COPA to Reporting

Image Removed

 

Expand
titleCosting - P&L Process – Plants


Expand
titleProduct Costing-PLcosting

Include Page
Understand the closing process
Understand the closing process


Image Removed

PRG vs ML: Main Differences

  • PRG provides the product Costing at Cost Object hierarchy (Group of Materials)
  • Material Ledger Provides it at Material code Level
  • PRG provides info about Utilities consumption and other SKF
  • Material Ledger does not
  • Material Ledger is integrated and is the basis for the Cost of Good Sold.

 

SECTION 2 Usage of different reports to explain

Panel
borderColor#B2E2EC
bgColor#B2E2EC

Image Removed

Expand
titleKey pain points have been identified by assessing the current PF1 CO Architecture

Root cause analysis for the contribution margin readability: split building between «Variable costs» and «Fixed costs» 

Image Removed

 

Expand
titlePRG vs ML
PL

the P/L


Use PF1 Use PF2 - KE30 - Report Z1KCHEOPS to have a report of Sales (R10000) & variable logistic costs (R12910)65%

Image Modified

 

 


Expand
titleKE30
Section
Column
width35%
Column
width


Expand
titleBW


Info

PF1 Data have been merged in BW – production - WBP to facilitate the analysis of GBUs using WP1 & PF1. For more details, you can visit RtR PE Reporting

Access WBP and Open a data source or workbook or go go to BW - Analysis Workbook Guide for more details regarding BW

To have the P&L in BW you can use the report ZZKPL_M01_BASIC_02 


Expand
titleZZKPL_M01_BASIC_02 - Basic Report

 

Include Page
ZZKPL_M01_BASIC_02 - Basic Report
ZZKPL_M01_BASIC_02 - Basic Report

 


Other reports that can be used

ReportDescription of the report

ZZKPL_M01_CONSO_01

P&L - Consolidation Report.

Not used at legal entity level but used by GBU controllers. It is set-up with the consolidation methodology used in BFC

ZZKPL_M01_CONSO_03

P&L - Consolidation Report

Integrated Margin. It considers the Margin taking in account the production cost at Origin. Only available for SpP and Soda Ash (active also for Peroxide but not validated yet with GBU controller).

 

 




Expand
titleGR55

Include Page
SAPCostCostOP:PF1 PF2 - GR55 - BFC Monthly evolutionSAPCost
CostOP:PF1 PF2 - GR55 - BFC Monthly evolution
 



Expand
titleML

Include Page
Material ledger - reports
Material ledger - reports

 



Expand
titleCCs Reports

With S_ALR_87013615 - Breakdown by Partner,

Info

To have a report of R25460 - Absorption variance: Period non-proportional costs of production (excl depr) & R25860 - Absorption variance: Period non-proportional depreciation of production

Select:

  • Cost centers group : CCCCXXCC; where CCCC is company code XX the 2 digits of the division (or activity 1)
  • Cost elements group. Use the group Rules - Cost element Group XCS-ALL or its subgroups
    • XCS-FCPE  in case you want to report Period Fixed costs
    • XCS-DEPPE in case you want to report Period Depreciation

Info

To have a report of Administrative expenses (non-functions) (R33310), Commercial expenses (R33320) & Shared service function expenses (function costs at the origin) (R33400)

Select:

 


Warning

The report will not tie with the P&L when:

  • there are direct posting in Reporting cost centers,

  • there are costs centers not using the appropriate allocation structure

 

 




Expand
titleQlikView

Include Page
CostFAQ:Qlikview Fixed costs dashboard
CostFAQ:Qlikview Fixed costs dashboard

 



Expand
titlePRG

Use the report PF1 PF2- Z1K_MATCOST_SYMPA - Prix de revient

There are PRG templates that:

  • Are provided to controllers for their scope: Entity - plant
  • There are adapted to local request.
  • Filters can be changed by controllers: eg unfilter depreciation services. Or they can add other dimension.
 


 



Expand
titleFixed costs reconciliation

Include Page
PF1 - Fixed costs reconciliation
PF1 - Fixed costs reconciliation
 

Viewtrackerhidetrue