| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Note | ||
|---|---|---|
|
It includes:
- Packaging components: Actual + target quantities and costs
- Manufactured materials (so-called products):
Actual production quantities and costs (total + variable) of products including “direct” packaging consumption, in order to measure weight of packaging vs production metrics
Info metrics. “Direct” means that if finished
AB has semi finished
BA in its BoM, and if
BA has packaging component P in its BoM, only
BA is reported as product in Screen report (and not
AB) => multi level consumption is not
supportedsupported.
- Sold quantity, Net sales and Variables Cost of sales, in order to measure weight of packaging costs vs sales and costs of sales
- . Same products as identified above.
It mainly includes IMEP - Integrated Manufacturing & Energy Performance data
- Packaging materials are selected as BoM components (IMEP - Index 1 = 3) according to their Valuation class: WP1 Z110 (stock account 31000300) and PF1 Z051 (2110110000)
Related products are all the ones for which packaging is consumed in the same Plant / Period (IMEP Index1 - Index 1 = 1/6)
Info Production qties and costs are the whole of the Plant/Period (including Prod./Process orders w/o packaging consumption)
It also includes COPA P&L data (sales) data:
For all selected products (see above), some related sales infos (including Sold qtyquantity, Net sales and variable Cost Variable Costs of Sales) are pull pulled from COPA at Company code / Period level
Info . That means that for ex in Period 01.2021, if Material 10363 is produced in Plant 7851, the whole sales of 10363 in Company 8090 are taken into account, and not only sales from Plant 7851
It is assumed that, most of the time, production and sales do not occur during the same period; for this reason, comparisons should be done for several rolling periods in order to minimize this time effect
- A technical split is performed in Screen in order to get iMEP packaging costs all along sales dimensions (Customer, Ship-to...) that do not exist in iMEP
Access the workbook
The workbook to be used is BW_WBK_SCRE_0003 – Pack. Manuf. Consumption analysis (Core Workbook)
=> Go to Analysis for Office in excel
=> Click "Open Workbook"
| Anchor | ||||
|---|---|---|---|---|
|
It is mandatory to enter:
- Conso view (2) : enter 1 to apply the legal entity consolidation rate or 0 not to take the consolidation rate into consideration
- Calendar Month/Year (3) : MM.YYYY : Document fiscal period (Purchase order creation date / Goods Receipt posting date / Invoice Receipt posting date) from posting date
It is also possible to enter:
- a Company Code (4)
- a Plant (5)
- a PRS Company code (6)
- Target Curr. for conversion (7) : the exchange rate used is CAR3
- UoM for Qty conv. : Unit of Measure (VKG by default)
- BFC GBU (8)
Click "OK"
Anchor basic_report basic_report
Basic report
| basic_report | |
| basic_report |
The report is displayed with :
- Pack. Actual Qty: actual packaging consumption on Production orders (Cost collectors / Process orders) (IMEP index - Index 1 = 3, . It corresponds to movement types 261/262)
- Pack Actual Costs bef. ML Reval.: value of actual packaging packaging consumption
- WP1:
- same as Actual costs (3)
- PF1:
- standard value
- before month-end
- ML revaluation
- Pack Actual Costs bef. ML Reval.:value of actual packaging packaging consumption
- WP1:
- consumed qty at standard price (IMEP - Index 1 = 3)
- PF1:
- real value
- including month-end
Agreement Unit price (in local & target currency)
- Info record Unit price (in local & target currency)
| Info |
|---|
Not all Purchase orders are created with reference to an Agreement/InfoRecord |
- Material Ledger revaluation (IMEP - Index 1 = 3)
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order. In the header:
1. Double click on "Outline agreement" to display Contract (= transaction ME33K - Display Contract)
2. Double click on "Info rec." to display Info Record (= transaction ME13 - Display Info Record)
- PO Qty: Ordered qty in PO UoM & in Material base UoM
- PO value: Ordered value in PO Currency & in Local (Company code) currency or in any Target currency if entered in prompt
- PO Unit Price: Ordered value in Local curr. / Ordered qty in PO UoM & Ordered value in Local curr. / Ordered qty in PO UoM
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order. In the header, the PO Qty (1) & PO Unit Price (3) can be displayed.
PO UoM vs Material base UoM
- PO UoM = Unit of mesure maintained in the Purchase order
- Material base UoM = Unit of mesure maintained in the Material master data (MM03 - Display Material - Purchasing view)
GR qty : Quantity received in PO UoM & in Material base UoM
GR value : Quantity received in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt
GR unit price : GR value in Local curr. / GR qty in PO UoM & GR value in Local/Target curr. / GR qty in PO UoM
GR Price diff.: difference between GR value and standard value
of stock entry, in PO & Local or Target curr., when posted in GR doc.
Standard value = GR qty * Material standard price
Material movements with the transaction MB51 - Material Document List.
- Enter Movement type = 26* in the prompt:
Consumption of material 1081129 BIG BAG 108X108X202 1T BLCK ST / plant 0087 in 01.2021 in process orders
- = 1 739 PC
- = 24 972,04 EUR (at standard costs)
Production quantities & costs
Prod. Actual qty: actual production qty issued from Production/Process orders (IMEP index 1 = 1)
QUR *100: Pack. Actual qty / Prod. Actual qty * 100
Actual number of packaging units needed to produce 1 unit of finished product
- Prod. Actual Costs: Actual production costs
- In WP1: Standard costs (IMEP index 1 = 3) + Process order variances (IMEP index 1 = 6)
- In PF1: Production costs including Material ledger revaluation (IMEP index 1 = 3)
- Pack. vs Prod Total Costs %: Actual packaging costs / Prod. Actual Costs (3)
- Prod. Actual Var. Costs: Variable production costs (costs of raw materials & energy)
- Pack. vs Prod. Var. Costs %: Actual packaging costs / Prod. Actual Var. Costs (5)
- QUS *100: Pack. Target qty / Prod. Actual qty * 100
- Theoritical number of packaging units needed to produce 1 unit of finished product (according to its standard Bill of Materials)
- Pack. vs Prod Sdt Costs %: Packaging target costs / Production Actual costs (3) x 100 => Theoritical part of packaging costs in standard production costs
- Pack. vs Prod Sdt Var. Costs %: Packaging target costs / Production Actual variable costs (5) x 100 => Theoritical part of packaging costs in variable standard production costs
Anchor sales sales
| sales | |
| sales |
Sales quantities & costs
- Sold Qty: Quantity sold (BFC account = N8110)
- Sales: Product net sales (BFC account = R10000 - Net sales)
- Var. CoS: Variable costs of goods sold (BFC account = R15400 - Variable costs of sales)
by product sold (=Material (Prod.)
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order & open the tab "Purchase Order History" to see the goods receipt.
Consignment
There are specific indicators to follow-up consignment:
- GR Consign. qty : in Material base UoM
- GR Consign. value : in Doc. Curr. & in Local (Company code) curr. or any Target curr. if entered in prompt
- GR unit price : GR Consign. value in Doc. curr. / GR Consign. qty in base UoM & GR Consign. value in Local/Target curr. / GR Consign. qty in base UoM
- GR Price diff.: difference between GR Consign. value and standard value of stock entry, in Doc. & Local or Target curr.
| Info |
|---|
GR Unit Price & Price diff. columns/ratios are the same for both standard and consignment GR |
- IR qty : Invoice receipt in PO UoM & in Material base UoM
- IR value : Invoice receipt in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt
- IR unit price : Invoice value in Local curr. / IR qty in PO UoM & IR value in Local/Target curr. / IR qty in PO UoM
- IR Price diff.: difference between GR value and standard value of stock entry, in PO & Local or Target currency, when posted in IR doc.
Standard value = IR qty * Material standard price
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order & open the tab "Purchase Order History" to see the invoice receipt.
Consignment
As for goods receipt, there are specific indicators to follow-up consignment invoices:
- IR Consign. qty : in Material base UoM
- IR Consign. value : in Doc. Curr. & in Local (Company code) curr. or any Target curr. if entered in prompt
- IR unit price : GR Consign. value in Doc. curr. / GR Consign. qty in base UoM & GR Consign. value in Local/Target curr. / GR Consign. qty in base UoM
- IR Price diff.: difference between IR Consign. value and standard value of stock entry, in Doc. & Local or Target curr.
| Info |
|---|
As Consignment invoices are auto invoices (MRKO tr.), no IR Price diff. should occur |
| Info |
|---|
IR Unit Price & Price diff. columns/ratios are the same for both standard and consignment IR |
In KE30 - Profitability report
- Sold Qty: Qty unit base
- Sales: B00 Net Sales
- Var. CoS: D00 VC Variable Cost
Packaging costs / sales
- Pack. Costs per Sold unit * 100: Pack. Actual Costs (a) / Sold Qty (b) => Actual packaging cost for 1 unit of product sold
- Pack. Costs vs Sales %: Pack. Actual Costs (a) / Sales (c) => Weight of Actual packaging costs compared to related product sales
- Pack. Costs vs Var. CoS %: Pack. Actual Costs (a) / Var. CoS (d) => Weight of Actual packaging costs compared to related variable costs of sales
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|