SCREEN - Pack. Manuf. Consumption analysis

The aim of this query is to provide users with a transversal view of Packaging material consumption in production process in WP1 and PF1

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. “Direct” means that if finished B has semi finished A in its BoM, and if A has packaging component P in its BoM, only A is reported as product in Screen report (and not B) => multi level consumption is not supported.

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.

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 - Index 1 = 1)

It also includes COPA (sales) data:

For all selected products (see above), some related sales infos (including Sold qty, Net sales and variable Cost of Sales) are pull from COPA at Company code / Period level
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

Data update

The report is displayed with :

Pack. Actual Qty: actual packaging consumption on Production orders (Cost collectors / Process orders) (IMEP - Index 1 = 3, movement types 261/262)
Pack Costs bef. ML Reval.: value of actual packaging consumption
- WP1: same as Actual costs
- PF1: standard value before month-end ML revaluation
Pack Actual Costs: value of actual packaging consumption
- WP1: consumed qty at standard price (IMEP - Index 1 = 3)
- PF1: real value including month-end Material Ledger revaluation (IMEP - Index 1 = 3)

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:
Pack. vs Prod Total Costs %
Prod. Actual Var. Costs
Pack. vs Prod. Var. Costs %
QUS *100
Pack. vs Prod Sdt Costs %
Pack. vs Prod Sdt Var. Costs %

Pack. Target Qty: theoretical consumption qty, equal to Actual produced qty * standard packaging consumption in standard BoM of manufactured Material
Pack. Target Costs: theoretical consumption value, equal to Actual produced qty * packaging cost in standard BoM of manufactured Material

QUS: Pack. Target qty / Prod. Actual qty * 100
- Theoretical number of packaging units needed to produce 1 unit of product (according to its standard BoM)
Prod. Actual (Var.) Costs: (variable) value of Actual produced qty
- Pack. vs Prod. Total (Var.) Costs %: Pack. Actual costs / Prod. Actual (variable) costs * 100 ☛ Share of Actual packaging costs in (variable) production costs
- Pack. vs Sdt Prod. Total (var.) Costs %: Pack. Target costs / Prod. Actual (variable) costs * 100 ☛ Theoretical share of packaging costs in (variable) standard production costs
WP1: “real” (variable) value equals to qty at standard price (IMEP index1 = 3) + month-end price variance (IMEP index1 = 6)
PF1: “real” (variable) value including month-end Material Ledger revaluation (IMEP index1 = 3)

Goods Receipt

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

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.

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

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.

As Consignment invoices are auto invoices (MRKO tr.), no IR Price diff. should occur

IR Unit Price & Price diff. columns/ratios are the same for both standard and consignment IR

Other Screen packaging workbooks

Unable to render {children}. Page not found: SCREEN - Packaging analysis.