Following measure are available in the BW query "DIP - Distribution Planning"
| Category | BW Measure | Generic description | TS MODEL | FOR SBS Team: U99 - Export Dynasys Datafield |
| Inventory | Initial inventory | Starting inventory for the current period (last dynamic refresh) | Initial Inventory from SAP | U99_O402_70- Initial inventory |
| Inventory | Available Inventory as validated | End of month projected inventory validated during the S&OP exercise | !End of period inventory | U99_O402_19 - Available Inventory as validated |
| Inventory | Actuals & Projected Inventory | Actuals and projected inventory | !Closing Inventory | U99_O402_88 - Actuals & projected inventory |
| Inventory | Physical inventory | End of month physical inventory (all types, intransit excluded) | / | U99_O402_62 - Physical inventory |
| Inventory | In transit inventory from SAP (ETA) | Stock in transit in SAP, between two sites, displayed in the received period (only current orders) | Intransit Inventory | U99_O402_14 - In Transit Inventory from SAP (ETA) |
| Inventory | Projected Transit inventory ETA | Stock in transit between 2 sites, current orders AND Dynasys planned, displayed in the month not yet arrived ("on the road") | Distribution in process | U99_O402_76 - Projected Transit inventory ETA |
| Inventory | Projected Inventory value | End of month projected inventory x CCR | Inventory value | U99_O402_64 - Projected Inventory value |
| Inventory | Available inventory (Budget) | End of month projected inventory validated during the Budget exercise | / | U99_O402_61 - Available inventory (Budget) |
| Inventory | Safety stock (SAP) | Safety stock defined in SAP, MRP view | I300 Safety stock quantity | U99_0402_85_Safety stock from SAP |
| Inventory | Safety stock v3 | Safety stock calculated in Dynasys, based on the V3 formula (projected requirements variability, service level, RLT) | Safety stock calculated from the P&I | U99_O402_71 - Safety stock v3 |
| Inventory | Final safety stock | Safety stock taken in the Planning (DIP) | Safety stock | U99_O402_30 - Final Safety Stock |
| Inventory | Anticipated Inventory | Anticipated Inventory | Anticipation Inventory | U99_O402_106 - Anticipated Inventory |
| Inventory | Blocked Stock | Blocked stock due to bad quality or some production irregularities | Blocked stock | U99_O402_9 - Blocked Stock |
| Inventory | QM Batch | Batch that is retained for quality inspection | / | U99_O402_103 - QM Batch |
| Inventory | Restricted Stock | Stock other than Unrestricted stock (Quality, Blocked, etc) | Restricted stock from SAP | U99_O402_104 - Restricted Stock |
| Inventory | Working Stock | For Silica: In the past: addition of EoM Unrestricted inventory + EoM vendor inventory + EoM QM batch // In the current month + future = available inventory calculated by the tool | U99_O402_110 - Working Stock | |
| Inventory | Working Stock as Validated | For Silica: Working stock validated during the last validation | U99_O402_111 - Working Stock as Validated | |
| Inventory | Budget Working Stock | For Silica: Working stock validated during the last Budget exercice | U99_O402_99 - Budget Working Stock | |
| Inventory | N/A | Not used | U99_O402_29 - Safety Stock in D.O.S | |
| Inventory | N/A | Not used | U99_O402_20 - Planned Inventory coverage | |
| Sales | Final forecast from DP (ETD) | Final forecast defined in ETD in DP | Unconstraint demand from DP Final | U99_O402_12 - Final Forecast ETD (from DP) |
| Sales | Final forecast from DP (ETA) | Final forecast defined in ETA in DP | Unconstraint demand from DP Final | U99_O402_66 - Final Forecast ETA (from DP) |
| Sales | Actual shipped and Final Demand (ETD) | Customer Demand taken by the DRP to calculate the requirements (after netting process) | Sales requirement sourced | U99_O402_53 - Actual shipped and final demand (ETD) |
| Sales | Actual Shipments (to customers) | Actuals shipped in ETD (Goods Issue date) filtered only to ShipTo destination | Actual Shipped in ETD (with site dim) | U99_O402_4 - Actual Sales |
| Sales | Backorders in ETD | Orders in a past period in SAP with the dimension site only sourced for dip3 now | Backorder Sales order book dim site to be added | U99_O402_52 - BackOrders in ETD |
| Sales | Firm Shipments ETD | Current orders in ETD (customer orders, inter site orders) | Open Orders | U99_O402_16 - Firm Shipments (ETD) |
| Sales | Orderbook | Orderbook = Firm shipments (open orders) + actuals | Calculated in BW | |
| Sales | Shipping requirements as validated (ETD) | Requirements to ship to ShipTo (outcome from the DRP calculation), validated during the S&OP process | Detailed shipping requirement | U99_0402_47 - Shipping requirements as validated (ETD) |
| Sales | Gross requirements | Gross requirements | U99_0402_48 - Gross Requirements | |
| Sales | Shipping Plan as validated (ETD) | Plan to ship to Customers (outcome from the DRP or DEPLOYMENT calculation), validated during the S&OP process | Demand | U99_0402_24 - Shipping plan as validated (ETD) |
| Sales | Plan to ship to customers (outcome from the DRP or DEPLOYMENT calculation), validated during the BUDGET process | Budget from DP with main site | U99_O402_36 - Budget (Sales) | |
| Sales | Plan to ship to customers (outcome from the DRP or DEPLOYMENT calculation), validated during the BFR process | U99_O402_38 - BFR (Sales) | ||
| Sales | [Orderbook / Budget Sales] * 100 | Calculated in Qlikview | ||
| Sales | [Orderbook / BFR Sales] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Requirement as validated (to Customers) / Actual Shipments (to Customers)] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Plan as validated (to Customers) / Actual Shipments (to Customers)] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Requirement as validated - Shipping Plan as validated (to Customers)] | Calculated in Qlikview | ||
| Sales | Shortage (ETA) | Created when the demand is superior of the actual stock and production capacity => Final stock expected <0 | U99_O402_97 - Shortage (ETA) | |
| Sales | Demand Review (ETA) | For Silica: Budget Review validated in DP | U99_O402_107 - Demand Review (ETA) | |
| Sales | Final Demand as validated | U99_O402_112- Final Demand as validated ETD | ||
| Sales | BFR Forecast from DP (ETD) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year | U99_O402_115 - BFR Forecast from DP (ETD) | |
| Sales | BFR Forecast from DP (ETA) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year | U99_O402_102 - BFR Forecast from DP (ETA) | |
| Sales | Orderbook in ETD | Firm Shipment + Actuals shipped | U99_O402_93 - Order Book requested ETD | |
| Sales | Budget Final Demand | Final demand after netting calculated by the tool with the Budget Forecast from DP | U99_O402_98 - Budget Final Demand ETD | |
| Shipments | Actuals shipments ETD (not available for the moment) | Actuals shipped in ETD (Goods Issue date) to All destinations | Actual shipped in ETD (with Site dim) | U99_O402_5 - Actual Shipments (ETD) |
| Shipments | Shipping requirements ETD | Requirements to ship to all destination (outcome from the DRP calculation) | Detailed shipping requirement | U99_O402_77 - Shipping requirements ETD |
| Shipments | Shipping requirements as validated | Requirements to ship to all destination (outcome from the DRP calculation), validated during the S&OP process | Detailed shipping requirement | U99_O402_47 - Shipping requirement as validated |
| Shipments | Firm shipping requirements (ETD) | Firm shipping requirements | U99_O402_87 - Firm shipping requirements (ETD) | |
| Shipments | Shipping Plan as validated | Plan to ship to all destination (outcome from the DRP or DEPLOYMENT calculation), validated during the S&OP process | Demand | U99_O402_24 - Shipping plan as validated |
| Shipments | Internal flows ETD | Plan to ship to other Intra GBU site (Inter Site), in shipping period | Actual Shipped // Shipping Plan | U99_O402_73 - Internal flows ETD |
| Shipments | External flows detailed ETD | Plan to ship to customers, in shipping period, with the detailed by destination | Actual shipped in ETD (wo site dim) | U99_O402_79 - External flows detailed ETD |
| Shipments | External flows ETD | Plan to ship to customers, in shipping period, WITHOUT the detailed by destination | Actual shipped in ETD (wo site dim) | U99_O402_74- External flows ETD |
| Shipments | Firm Receipt ETA | Current orders in SAP (customers, Inter Sites), in delivery date | Firm shipment in shipping | U99_O402_72 - Firm Receipt ETA |
| Shipments | Receipt Plant ETA | Receipt Plan by All destination, in the receipt month | Receipt plan | U99_O402_78 - Receipt plan ETA |
| Shipments | Constraint demand (ETA) | Receipt Plan by customers, in the receipt month | Projected resupply plan | U99_O402_11 - Constraint Demand (ETA) |
| Shipments | Budget Shipping requirement | Shipping requirement calculated by the tool with the Budget Forecast from DP | / | U99_O402_96 - Budget Shipping requirement ETD |
| Shipments | Budget Shipping Plan | Shipping plan calculated by the tool with the Budget Forecast from DP | / | U99_O402_55 - Budget Shipping Plan ETD |
| Shipments | Actual Shipments / Total Planned Shipments *100 | Calculated in Qlikview | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Production | Actual Production | Actual production with no consideration of the resource | I402 - Actual production plan (INT) | U99_O402_2 - Actual production |
| Production | Actual production with the consideration of the resource, filtered on specific product to follow, or Resource ("consolidated", "Reactor",... depending on GBU rule) | I402 - Actual production plan | U99_O402_46 - Actual Production by resource (detail) | |
| Production | Actual production by resource | Actual production with the consideration of the resource, for all product | Not applicable | U99_O402_46 - Actual Production by resource (detail) |
| Production | Production plan | U99_O402_22 - Planned Production | ||
| Production | Production Plan by resource as validated | Production Plan validated during the S&OP process (with the consideration of the resource) | Not applicable | U99_O402_45 - Production Plan by ressource |
| Production | Production Plan as validated | Production Plan validated during the S&OP process (no consideration of the resource) | Not applicable | U99_O402_50 - Planned production by resource as validated |
| Production | Plan by resource | Production Plan validated during the S&OP process (with the consideration of the resource AND specifically on "consolidated" Materials to be followed) | Not applicable | U99_O402_45 - Planned Production by resource (detail) |
| Production | Production capacity | Maximum capacity by product / Resource in quantity | Not applicable | U99_O402_27 - Production capacity |
| Production | Production capacity (H) | U99_O402_114 - Production Capacity (H) | ||
| Production | Available capacity | Capacity by resource per period (opening days x hours per day) | Not applicable | U99_O402_08 - Available capacity |
| Production | Production requirements | Need to produce, considering the production constraints like batch size, minimum, ... Could be considered as the Unconstraint Production plan | Not applicable | U99_O402_65 - Production requirements |
| Production | Internal consumption | Dependent requirements for a component consumed in a Parent product | Dependent requirement | U99_O402_41 - Internal Consumption |
| Production | Load % | Production Requirements / Available capacity x100 | Not applicable | U99_O402_67 - Unconstrained Load % |
| Production | Scheduled % | Production Plan / Available capacity x100 | Not applicable | U99_O402_10 - Scheduled load % |
| Production | Balance | Difference between demand (or unconstraint production) and Production plan | Not applicable | U99_O402_68 - Balance |
| Production | Cumulative Balance | Balance cumulated over the entire horizon | Not applicable | U99_O402_69 - Cumulative Balance |
| Production | Budget Production Plan | Production plan validated during the BUDGET process | Not applicable | U99_O402_35 - Budget production Plan |
| Production | Production plan validated during the BFR process | Not applicable | U99_0402_37 - BFR (Production) | |
| Production | Actuals / Production plan validated during the last S&OP process | Not applicable | Calculated in Qlikview | |
| Production | Number of Closed days by period | Not applicable | U99_O402_32 - Shutdown in nbr of days | |
| Production | Planned Shutdown | The number of planned shutdown days / Resource | U99_O402_105 - Planned Shutdown | |
| Production | Overall Equipement Effectiveness (OEE) | Identifies the percentage of manufacturing time that is truly productive. | U99_O402_108 -Overall Equipement Effectiveness (OEE) | |
| Production | Maximum Daily Capacity (MDC) | Maximum Daily Capacity | U99_O402_109 -Maximum Daily Capacity (MDC) | |
| Production | Production Planned (H) | U99_O402_113 - Production Planned (H) | ||
| Production | Not applicable | U99_O402_39 - Cheap Production | ||
| Production | Not applicable | U99_O402_40 - Expensive Production | ||
| Production | Not applicable | ? | ||
| Production | Not applicable | U99_O402_18 - Planned conbsumption - Brine negative qty | ||
| Production | Planned production / available capacity | Calculated in Qlikview | ||
| Costs | Shipment cost + Warehouse cost | Calculated in Qlikview | ||
| Costs | Shipments x Planned logistic costs | Distribution cost transposed | U99_O402_49 - Planned shipment costs (€) | |
| Costs | Distribution cost (transportation) | / | U99_O402_21 - Planned logistic costs (€) | |
| Costs | Warehouse costing | Inventory value | U99_O402_34 - Warehouse costs | |
| Costs | Production cost (CCR) x production plan | Production cost | U99_O402_28 - Production Costs (€) | |
| Costs | Not used | N/A | ||
| Costs | Not used | U99_O402_86 - Actual shipments costs (€) | ||
| P&I | Cycle Stock | Cycle stock calculated for P&I exercise | Not applicable | U99_O402_57 - Cycle Stock |
| P&I | SHS Rlt | SHS-Replenishment Lead time is calculated from a number of different lead times coming from SAP. This SHS RLT is multilevel & multi-site | Not applicable | U99_O402_59 - SHS RLT |
| P&I | Past and future demand | Not applicable | U99_O402_63 - Past and Futur demand | |
| Other KPIs | Purchase plan (ETA) | Receipt plan for products coming from external source (external supplier) | Projected supply plan | U99_O402_23 - Purchased plan (ETA) |
| Other KPIs | Actuals received from external supplier | Firm purchase (From SAP) | U99_O402_3 - Actual purchased material | |
| Other KPIs | Swap balance | Not applicable | U99_O402_25 - Planned SWAP U.S |
| Category | BW Measure | Generic description | AROMA MODEL | FOR SBS Team: U99 - Export Dynasys Datafield |
| Inventory | Initial inventory | Starting inventory for the current period (last dynamic refresh) | Initial Inventory | U99_O402_70- Initial inventory |
| Inventory | Available Inventory as validated | End of month projected inventory validated during the S&OP exercise | SOIP Ref - Total Stock | U99_O402_19 - Available Inventory as validated |
| Inventory | Actuals & Projected Inventory | Actuals and projected inventory | Available inventory | U99_O402_88 - Actuals & projected inventory |
| Inventory | Physical inventory | End of month physical inventory (all types, intransit excluded) | Total physical inventory | U99_O402_62 - Physical inventory |
| Inventory | In transit inventory from SAP (ETA) | Stock in transit in SAP, between two sites, displayed in the received period (only current orders) | SOIP Ref - Intransit Inventory | U99_O402_14 - In Transit Inventory from SAP (ETA) |
| Inventory | Projected Transit inventory ETA | Stock in transit between 2 sites, current orders AND Dynasys planned, displayed in the month not yet arrived ("on the road") | Total Distribution in process | U99_O402_76 - Projected Transit inventory ETA |
| Inventory | Projected Inventory value | End of month projected inventory x CCR | Inventory value | U99_O402_64 - Projected Inventory value |
| Inventory | Available inventory (Budget) | End of month projected inventory validated during the Budget exercise | Budget- Available Inventory | U99_O402_61 - Available inventory (Budget) |
| Inventory | Safety stock (SAP) | Safety stock defined in SAP, MRP view | I300 Safety stock quantity | U99_0402_85_Safety stock from SAP |
| Inventory | Safety stock v3 | Safety stock calculated in Dynasys, based on the V3 formula (projected requirements variability, service level, RLT) | Safety stock SCE formula V3 (1) | U99_O402_71 - Safety stock v3 |
| Inventory | Final safety stock | Safety stock taken in the Planning (DIP) | Final safety stock | U99_O402_30 - Final Safety Stock |
| Inventory | Anticipated Inventory | Anticipated Inventory | Anticipation Inventory | U99_O402_106 - Anticipated Inventory |
| Inventory | Blocked Stock | Blocked stock due to bad quality or some production irregularities | Blocked stock | U99_O402_9 - Blocked Stock |
| Inventory | QM Batch | Batch that is retained for quality inspection | QM batch from SAP | U99_O402_103 - QM Batch |
| Inventory | Restricted Stock | Stock other than Unrestricted stock (Quality, Blocked, etc) | Restricted stock from SAP | U99_O402_104 - Restricted Stock |
| Inventory | Working Stock | For Silica: In the past: addition of EoM Unrestricted inventory + EoM vendor inventory + EoM QM batch // In the current month + future = available inventory calculated by the tool | U99_O402_110 - Working Stock | |
| Inventory | Working Stock as Validated | For Silica: Working stock validated during the last validation | U99_O402_111 - Working Stock as Validated | |
| Inventory | Budget Working Stock | For Silica: Working stock validated during the last Budget exercice | U99_O402_99 - Budget Working Stock | |
| Inventory | N/A | Not used | U99_O402_29 - Safety Stock in D.O.S | |
| Inventory | N/A | Not used | U99_O402_20 - Planned Inventory coverage | |
| Sales | Final forecast from DP (ETD) | Final forecast defined in ETD in DP | Unconstraint demand from DP | U99_O402_12 - Final Forecast ETD (from DP) |
| Sales | Final forecast from DP (ETA) | Final forecast defined in ETA in DP | / | U99_O402_66 - Final Forecast ETA (from DP) |
| Sales | Actual shipped and Final Demand (ETD) | Customer Demand taken by the DRP to calculate the requirements (after netting process) | Actuals / Shipping Requirements (SKU ship to) | U99_O402_53 - Actual shipped and final demand (ETD) |
| Sales | Actual Shipments (to customers) | Actuals shipped in ETD (Goods Issue date) filtered only to ShipTo destination | Actual Shipped in ETD (with Site dim) | U99_O402_4 - Actual Sales |
| Sales | Backorders in ETD | Orders in a past period in SAP with the dimension site only sourced for dip3 now | Backorder Sales order book dim site to be added | U99_O402_52 - BackOrders in ETD |
| Sales | Firm Shipments ETD | Current orders in ETD (customer orders, inter site orders) | Order book in ETD | U99_O402_16 - Firm Shipments (ETD) |
| Sales | Orderbook | Orderbook = Firm shipments (open orders) + actuals | Calculated in BW | |
| Sales | Shipping requirements as validated (ETD) | Requirements to ship to ShipTo (outcome from the DRP calculation), validated during the S&OP process | SOIP Ref -Shipping Requirements | U99_0402_47 - Shipping requirements as validated (ETD) |
| Sales | Gross requirements | Gross requirements | U99_0402_48 - Gross Requirements | |
| Sales | Shipping Plan as validated (ETD) | Plan to ship to Customers (outcome from the DRP or DEPLOYMENT calculation), validated during the S&OP process | SOIP Ref -Shipping Plan | U99_0402_24 - Shipping plan as validated (ETD) |
| Sales | Plan to ship to customers (outcome from the DRP or DEPLOYMENT calculation), validated during the BUDGET process | Budget-Sales (avec site) | U99_O402_36 - Budget (Sales) | |
| Sales | Plan to ship to customers (outcome from the DRP or DEPLOYMENT calculation), validated during the BFR process | BFR06 - Sales (avec site) | U99_O402_38 - BFR (Sales) | |
| Sales | [Orderbook / Budget Sales] * 100 | Calculated in Qlikview | ||
| Sales | [Orderbook / BFR Sales] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Requirement as validated (to Customers) / Actual Shipments (to Customers)] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Plan as validated (to Customers) / Actual Shipments (to Customers)] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Requirement as validated - Shipping Plan as validated (to Customers)] | Calculated in Qlikview | ||
| Sales | Shortage (ETA) | Created when the demand is superior of the actual stock and production capacity => Final stock expected <0 | U99_O402_97 - Shortage (ETA) | |
| Sales | Demand Review (ETA) | For Silica: Budget Review validated in DP | U99_O402_107 - Demand Review (ETA) | |
| Sales | Final Demand as validated | U99_O402_112- Final Demand as validated ETD | ||
| Sales | BFR Forecast from DP (ETD) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year | U99_O402_115 - BFR Forecast from DP (ETD) | |
| Sales | BFR Forecast from DP (ETA) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year | U99_O402_102 - BFR Forecast from DP (ETA) | |
| Sales | Orderbook in ETD | Firm Shipment + Actuals shipped | U99_O402_93 - Order Book requested ETD | |
| Sales | Budget Final Demand | Final demand after netting calculated by the tool with the Budget Forecast from DP | U99_O402_98 - Budget Final Demand ETD | |
| Shipments | Actuals shipments ETD (not available for the moment) | Actuals shipped in ETD (Goods Issue date) to All destinations | Actual shipped in ETD (with Site dim) | U99_O402_5 - Actual Shipments (ETD) |
| Shipments | Shipping requirements ETD | Requirements to ship to all destination (outcome from the DRP calculation) | Detailed shipping requirement | U99_O402_77 - Shipping requirements ETD |
| Shipments | Shipping requirements as validated | Requirements to ship to all destination (outcome from the DRP calculation), validated during the S&OP process | SOIP Ref - Shipping Requirements | U99_O402_47 - Shipping requirement as validated |
| Shipments | Firm shipping requirements (ETD) | Firm shipping requirements | U99_O402_87 - Firm shipping requirements (ETD) | |
| Shipments | Shipping Plan as validated | Plan to ship to all destination (outcome from the DRP or DEPLOYMENT calculation), validated during the S&OP process | SOIP Ref - Shipping Plan | U99_O402_24 - Shipping plan as validated |
| Shipments | Internal flows ETD | Plan to ship to other Intra GBU site (Inter Site), in shipping period | Actual Shipped // Shipping Plan | U99_O402_73 - Internal flows ETD |
| Shipments | External flows detailed ETD | Plan to ship to customers, in shipping period, with the detailed by destination | External Sales ETD | U99_O402_79 - External flows detailed ETD |
| Shipments | External flows ETD | Plan to ship to customers, in shipping period, WITHOUT the detailed by destination | External sales ETD | U99_O402_74- External flows ETD |
| Shipments | Firm Receipt ETA | Current orders in SAP (customers, Inter Sites), in delivery date | Firm shipment in receipt | U99_O402_72 - Firm Receipt ETA |
| Shipments | Receipt Plant ETA | Receipt Plan by All destination, in the receipt month | Receipt plan | U99_O402_78 - Receipt plan ETA |
| Shipments | Constraint demand (ETA) | Receipt Plan by customers, in the receipt month | SOIP Ref - Receipt Plan | U99_O402_11 - Constraint Demand (ETA) |
| Shipments | Budget Shipping requirement | Shipping requirement calculated by the tool with the Budget Forecast from DP | / | U99_O402_96 - Budget Shipping requirement ETD |
| Shipments | Budget Shipping Plan | Shipping plan calculated by the tool with the Budget Forecast from DP | Budget - Shipping Plan | U99_O402_55 - Budget Shipping Plan ETD |
| Shipments | Actual Shipments / Total Planned Shipments *100 | Calculated in Qlikview | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Production | Actual Production | Actual production with no consideration of the resource | I402 - Actual production plan (INT) | U99_O402_2 - Actual production |
| Production | Actual production with the consideration of the resource, filtered on specific product to follow, or Resource ("consolidated", "Reactor",... depending on GBU rule) | I402 - Actual production plan | U99_O402_46 - Actual Production by resource (detail) | |
| Production | Actual production by resource | Actual production with the consideration of the resource, for all product | U99_O402_46 - Actual Production by resource (detail) | |
| Production | Production plan Total | U99_O402_22 - Planned Production | ||
| Production | Production Plan by resource as validated | Production Plan validated during the S&OP process (with the consideration of the resource) | SOIP Ref - Plan by resource total | U99_O402_45 - Production Plan by ressource |
| Production | Production Plan as validated | Production Plan validated during the S&OP process (no consideration of the resource) | SOIP Ref - Plan by resource total | U99_O402_50 - Planned production by resource as validated |
| Production | Plan by resource | Production Plan validated during the S&OP process (with the consideration of the resource AND specifically on "consolidated" Materials to be followed) | SOIP Ref - Plan by resource total | U99_O402_45 - Planned Production by resource (detail) |
| Production | Production capacity | Maximum capacity by product / Resource in quantity | Production at full capacity (by material) (wo inv control) | U99_O402_27 - Production capacity |
| Production | Production capacity (H) | U99_O402_114 - Production Capacity (H) | ||
| Production | Available capacity | Capacity by resource per period (opening days x hours per day) | Capacity unused by plan | U99_O402_08 - Available capacity |
| Production | Production requirements | Need to produce, considering the production constraints like batch size, minimum, ... Could be considered as the Unconstraint Production plan | Production requirements | U99_O402_65 - Production requirements |
| Production | Internal consumption | Dependent requirements for a component consumed in a Parent product | SOIP Ref - Dependent requirement | U99_O402_41 - Internal Consumption |
| Production | Load % | Production Requirements / Available capacity x100 | / | U99_O402_67 - Unconstrained Load % |
| Production | Scheduled % | Production Plan / Available capacity x100 | Capacity used by plan | U99_O402_10 - Scheduled load % |
| Production | Balance | Difference between demand (or unconstraint production) and Production plan | / | U99_O402_68 - Balance |
| Production | Cumulative Balance | Balance cumulated over the entire horizon | / | U99_O402_69 - Cumulative Balance |
| Production | Budget Production Plan | Production plan validated during the BUDGET process | Budget - Plan by Resource total | U99_O402_35 - Budget production Plan |
| Production | Production plan validated during the BFR process | BFR (Production) - Reference | U99_0402_37 - BFR (Production) | |
| Production | Actuals / Production plan validated during the last S&OP process | Calculated in Qlikview | ||
| Production | Number of Closed days by period | Total closed days | U99_O402_32 - Shutdown in nbr of days | |
| Production | Planned Shutdown | The number of planned shutdown days / Resource | U99_O402_105 - Planned Shutdown | |
| Production | Overall Equipement Effectiveness (OEE) | Identifies the percentage of manufacturing time that is truly productive. | U99_O402_108 -Overall Equipement Effectiveness (OEE) | |
| Production | Maximum Daily Capacity (MDC) | Maximum Daily Capacity | U99_O402_109 -Maximum Daily Capacity (MDC) | |
| Production | Production Planned (H) | U99_O402_113 - Production Planned (H) | ||
| Production | Not applicable | U99_O402_39 - Cheap Production | ||
| Production | Not applicable | U99_O402_40 - Expensive Production | ||
| Production | Not applicable | ? | ||
| Production | Not applicable | U99_O402_18 - Planned conbsumption - Brine negative qty | ||
| Production | Planned production / available capacity | Calculated in Qlikview | ||
| Costs | Shipment cost + Warehouse cost | Calculated in Qlikview | ||
| Costs | Shipments x Planned logistic costs | / | U99_O402_49 - Planned shipment costs (€) | |
| Costs | Distribution cost (transportation) | / | U99_O402_21 - Planned logistic costs (€) | |
| Costs | Warehouse costing | Warehouse cost | U99_O402_34 - Warehouse costs | |
| Costs | Production cost (CCR) x production plan | Total production cost | U99_O402_28 - Production Costs (€) | |
| Costs | Not used | N/A | ||
| Costs | Not used | U99_O402_86 - Actual shipments costs (€) | ||
| P&I | Cycle Stock | Cycle stock calculated for P&I exercise | Not applicable | U99_O402_57 - Cycle Stock |
| P&I | SHS Rlt | SHS-Replenishment Lead time is calculated from a number of different lead times coming from SAP. This SHS RLT is multilevel & multi-site | Not applicable | U99_O402_59 - SHS RLT |
| P&I | Past and future demand | Not applicable | U99_O402_63 - Past and Futur demand | |
| Other KPIs | Purchase plan (ETA) | Receipt plan for products coming from external source (external supplier) | / | U99_O402_23 - Purchased plan (ETA) |
| Other KPIs | Actuals received from external supplier | External purchase from SAP | U99_O402_3 - Actual purchased material | |
| Other KPIs | Swap balance | Not applicable | U99_O402_25 - Planned SWAP U.S |
| Category | BW Measure | Generic description | NOVECARE MODEL | FOR SBS Team: U99 - Export Dynasys Datafield |
| Inventory | Initial inventory | Starting inventory for the current period (last dynamic refresh) | Initial Inventory | U99_O402_70- Initial inventory |
| Inventory | Available Inventory as validated | End of month projected inventory validated during the S&OP exercise | M-1 // Total All Stock | U99_O402_19 - Available Inventory as validated |
| Inventory | Actuals & Projected Inventory | Actuals and projected inventory | Projected inventory | U99_O402_88 - Actuals & projected inventory |
| Inventory | Physical inventory | End of month physical inventory (all types, intransit excluded) | Physical inventory | U99_O402_62 - Physical inventory |
| Inventory | In transit inventory from SAP (ETA) | Stock in transit in SAP, between two sites, displayed in the received period (only current orders) | Transit inventory (sourced) | U99_O402_14 - In Transit Inventory from SAP (ETA) |
| Inventory | Projected Transit inventory ETA | Stock in transit between 2 sites, current orders AND Dynasys planned, displayed in the month not yet arrived ("on the road") | Projected transit inventory NOV | U99_O402_76 - Projected Transit inventory ETA |
| Inventory | Projected Inventory value | End of month projected inventory x CCR | Projected inventory value NOV | U99_O402_64 - Projected Inventory value |
| Inventory | Available inventory (Budget) | End of month projected inventory validated during the Budget exercise | Budget- Projected Inventory | U99_O402_61 - Available inventory (Budget) |
| Inventory | Safety stock (SAP) | Safety stock defined in SAP, MRP view | I300 Safety stock quantity | U99_0402_85_Safety stock from SAP |
| Inventory | Safety stock v3 | Safety stock calculated in Dynasys, based on the V3 formula (projected requirements variability, service level, RLT) | N/A | U99_O402_71 - Safety stock v3 |
| Inventory | Final safety stock | Safety stock taken in the Planning (DIP) | Safety stock | U99_O402_30 - Final Safety Stock |
| Inventory | Anticipated Inventory | Anticipated Inventory | Anticipation Inventory | U99_O402_106 - Anticipated Inventory |
| Inventory | Blocked Stock | Blocked stock due to bad quality or some production irregularities | Blocked stock from SAP | U99_O402_9 - Blocked Stock |
| Inventory | QM Batch | Batch that is retained for quality inspection | QM batch from SAP | U99_O402_103 - QM Batch |
| Inventory | Restricted Stock | Stock other than Unrestricted stock (Quality, Blocked, etc) | Restricted stock from SAP | U99_O402_104 - Restricted Stock |
| Inventory | Working Stock | For Silica: In the past: addition of EoM Unrestricted inventory + EoM vendor inventory + EoM QM batch // In the current month + future = available inventory calculated by the tool | U99_O402_110 - Working Stock | |
| Inventory | Working Stock as Validated | For Silica: Working stock validated during the last validation | U99_O402_111 - Working Stock as Validated | |
| Inventory | Budget Working Stock | For Silica: Working stock validated during the last Budget exercice | U99_O402_99 - Budget Working Stock | |
| Inventory | N/A | Not used | U99_O402_29 - Safety Stock in D.O.S | |
| Inventory | N/A | Not used | U99_O402_20 - Planned Inventory coverage | |
| Sales | Final forecast from DP (ETD) | Final forecast defined in ETD in DP | Forecast from DP (ETD) (actuals for the past) | U99_O402_12 - Final Forecast ETD (from DP) |
| Sales | Final forecast from DP (ETA) | Final forecast defined in ETA in DP | Unconstraint demand from DP | U99_O402_66 - Final Forecast ETA (from DP) |
| Sales | Actual shipped and Final Demand (ETD) | Customer Demand taken by the DRP to calculate the requirements (after netting process) | Actual Shipped ETD in the past / Shipping requirement (Independent requirement) This include INTERNAL and EXTERNAL flows | U99_O402_53 - Actual shipped and final demand (ETD) |
| Sales | Backorders in ETD | Orders in a past period in SAP with the dimension site only sourced for dip3 now | BackOrders | U99_O402_52 - BackOrders in ETD |
| Sales | Actual Shipments (to customers) (Used to calculate orderbook ETD) | Actuals shipped in ETD (Goods Issue date) filtered only to ShipTo destination | Actual Shipped ETD (SKU plant) | U99_O402_4 - Actual Sales |
| Sales | Firm Shipments ETD (Used to calculate orderbook ETD) | Current orders in ETD (customer orders, inter site orders) | Firm shipment in shipping SAP | U99_O402_16 - Firm Shipments (ETD) |
| Sales | Orderbook ETD | Orderbook = Firm shipments ETD + Actual Shipped ETD | Calculated in BW | |
| Sales | Shipping requirements as validated (ETD) | Requirements to ship to ShipTo (outcome from the DRP calculation), validated during the S&OP process | S&OP Validated - Actual Shipped // Independent requierement | U99_0402_47 - Shipping requirements as validated (ETD) |
| Sales | Gross requirements | Gross requirements | U99_0402_48 - Gross Requirements | |
| Sales | Shipping Plan as validated (ETD) | Plan to ship to Customers (outcome from the DRP or DEPLOYMENT calculation), validated during the S&OP process | S&OP Validated - Actual Shipped // Independent requierement | U99_0402_24 - Shipping plan as validated (ETD) |
| Sales | Plan to ship to customers (outcome from the DRP or DEPLOYMENT calculation), validated during the BUDGET process | Budget Final Demand sourced (SKU transpo) | U99_O402_36 - Budget (Sales) | |
| Sales | Plan to ship to customers (outcome from the DRP or DEPLOYMENT calculation), validated during the BFR process | N/A | U99_O402_38 - BFR (Sales) | |
| Sales | [Orderbook / Budget Sales] * 100 | Calculated in Qlikview | ||
| Sales | [Orderbook / BFR Sales] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Requirement as validated (to Customers) / Actual Shipments (to Customers)] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Plan as validated (to Customers) / Actual Shipments (to Customers)] * 100 | Calculated in Qlikview | ||
| Sales | [Shipping Requirement as validated - Shipping Plan as validated (to Customers)] | Calculated in Qlikview | ||
| Sales | Shortage (ETA) | Created when the demand is superior of the actual stock and production capacity => Final stock expected <0 | U99_O402_97 - Shortage (ETA) | |
| Sales | Demand Review (ETA) | For Silica: Budget Review validated in DP | U99_O402_107 - Demand Review (ETA) | |
| Sales | Final Demand as validated | S&OP Validated -Final Demand ETD sourced | U99_O402_112- Final Demand as validated ETD | |
| Sales | BFR Forecast from DP (ETD) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year | U99_O402_115 - BFR Forecast from DP (ETD) | |
| Sales | BFR Forecast from DP (ETA) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year | U99_O402_102 - BFR Forecast from DP (ETA) | |
|
|
| ||
| Sales | Budget Final Demand | Final demand after netting calculated by the tool with the Budget Forecast from DP | U99_O402_98 - Budget Final Demand ETD | |
| Shipments | Actuals shipments ETD (not available for the moment) | Actuals shipped in ETD (Goods Issue date) to All destinations | Actual shipped ETD (SKU plant) | U99_O402_5 - Actual Shipments (ETD) |
| Shipments | Shipping requirements ETD | Requirements to ship to all destination (outcome from the DRP calculation) | Detailed shipping requierement | U99_O402_77 - Shipping requirements ETD |
| Shipments | Shipping requirements as validated | Requirements to ship to all destination (outcome from the DRP calculation), validated during the S&OP process | S&OP Validated - Actual Shipped // Independent requierement | U99_O402_47 - Shipping requirement as validated |
| Shipments | Firm shipping requirements (ETD) | Firm shipping requirement | U99_O402_87 - Firm shipping requirements (ETD) | |
| Shipments | Shipping Plan as validated | Plan to ship to all destination (outcome from the DRP or DEPLOYMENT calculation), validated during the S&OP process | S&OP Validated - Shipping plan (from May validation - past not archived) | U99_O402_24 - Shipping plan as validated |
| Shipments | Internal flows ETD | Plan to ship to other Intra GBU site (Inter Site), in shipping period | Actual Shipped // Independent requierement | U99_O402_73 - Internal flows ETD |
| Shipments | External flows detailed ETD | Plan to ship to customers, in shipping period, with the detailed by destination | Actual Shipped // Independent requierement | U99_O402_79 - External flows detailed ETD |
| Shipments | External flows ETD | Plan to ship to customers, in shipping period, WITHOUT the detailed by destination | Actual Shipped // Independent requierement | U99_O402_74- External flows ETD |
| Shipments | Firm Receipt ETA | Current orders in SAP (customers, Inter Sites), in delivery date | Firm receipt (ETA) | U99_O402_72 - Firm Receipt ETA |
| Shipments | Receipt Plant ETA | Receipt Plan by All destination, in the receipt month | Inbound Transfers | U99_O402_78 - Receipt plan ETA |
| Shipments | Constraint demand (ETA) | Receipt Plan by customers, in the receipt month | S&OP validated - Actual receipt // Proposed receipt plan | U99_O402_11 - Constraint Demand (ETA) |
| Shipments | Budget Shipping requirement | Shipping requirement calculated by the tool with the Budget Forecast from DP | Budget - Independent requirement | U99_O402_96 - Budget Shipping requirement ETD |
| Shipments | Budget Shipping Plan | Shipping plan calculated by the tool with the Budget Forecast from DP | Budget - Independent requirement | U99_O402_55 - Budget Shipping Plan ETD |
| Shipments | Actual Shipments / Total Planned Shipments *100 | Calculated in Qlikview | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Shipments | Not used | N/A | ||
| Production | Actual Production | Actual production with no consideration of the resource | Actuals Production | U99_O402_2 - Actual production |
| Production | Actual production with the consideration of the resource, filtered on specific product to follow, or Resource ("consolidated", "Reactor",... depending on GBU rule) | Actuals / Plan by resource | U99_O402_46 - Actual Production by resource (detail) | |
| Production | Actual production by resource | Actual production with the consideration of the resource, for all product | Actuals / Plan by resource | U99_O402_46 - Actual Production by resource (detail) |
| Production | Planned Production | U99_O402_22 - Planned Production | ||
| Production | Production Plan by resource as validated | Production Plan validated during the S&OP process (with the consideration of the resource) | plan by resource | U99_O402_45 - Production Plan by ressource |
| Production | Production Plan as validated | Production Plan validated during the S&OP process (no consideration of the resource) | plan by resource | U99_O402_50 - Planned production by resource as validated |
| Production | Plan by resource | Production Plan validated during the S&OP process (with the consideration of the resource AND specifically on "consolidated" Materials to be followed) | plan by resource | U99_O402_45 - Planned Production by resource (detail) |
| Production | Production capacity | Maximum capacity by product / Resource in quantity | Available capacity in QTY | U99_O402_27 - Production capacity |
| Production | Production capacity (H) | U99_O402_114 - Production Capacity (H) | ||
| Production | Available capacity | Capacity by resource per period (opening days x hours per day) | Available capacity // HR | U99_O402_08 - Available capacity |
| Production | Production requirements | Need to produce, considering the production constraints like batch size, minimum, ... Could be considered as the Unconstraint Production plan | Production requierements // QTY | U99_O402_65 - Production requirements |
| Production | Internal consumption | Dependent requirements for a component consumed in a Parent product | S&OP Validated - Actual Consumption // Dependent requirement | U99_O402_41 - Internal Consumption |
| Production | Load % | Production Requirements / Available capacity x100 | Load% | U99_O402_67 - Unconstrained Load % |
| Production | Scheduled % | Production Plan / Available capacity x100 | Scheduled % | U99_O402_10 - Scheduled load % |
| Production | Balance | Difference between demand (or unconstraint production) and Production plan | Balance | U99_O402_68 - Balance |
| Production | Cumulative Balance | Balance cumulated over the entire horizon | Cumulative balance | U99_O402_69 - Cumulative Balance |
| Production | Budget Production Plan | Production plan validated during the BUDGET process | Budget - production | U99_O402_35 - Budget production Plan |
| Production | Production plan validated during the BFR process | N/A | U99_0402_37 - BFR (Production) | |
| Production | Actuals / Production plan validated during the last S&OP process | Calculated in Qlikview | ||
| Production | Number of Closed days by period | Closed days total | U99_O402_32 - Shutdown in nbr of days | |
| Production | Planned Shutdown | The number of planned shutdown days / Resource | U99_O402_105 - Planned Shutdown | |
| Production | Overall Equipement Effectiveness (OEE) | Identifies the percentage of manufacturing time that is truly productive. | U99_O402_108 -Overall Equipement Effectiveness (OEE) | |
| Production | Maximum Daily Capacity (MDC) | Maximum Daily Capacity | U99_O402_109 -Maximum Daily Capacity (MDC) | |
| Production | Production Planned (H) | U99_O402_113 - Production Planned (H) | ||
| Production | Not applicable | U99_O402_39 - Cheap Production | ||
| Production | Not applicable | U99_O402_40 - Expensive Production | ||
| Production | Not applicable | ? | ||
| Production | Not applicable | U99_O402_18 - Planned conbsumption - Brine negative qty | ||
| Production | Planned production / available capacity | Calculated in Qlikview | ||
| Costs | Shipment cost + Warehouse cost | Calculated in Qlikview | ||
| Costs | Shipments x Planned logistic costs | / | U99_O402_49 - Planned shipment costs (€) | |
| Costs | Distribution cost (transportation) | / | U99_O402_21 - Planned logistic costs (€) | |
| Costs | Warehouse costing | / | U99_O402_34 - Warehouse costs | |
| Costs | Production cost (CCR) x production plan | / | U99_O402_28 - Production Costs (€) | |
| Costs | Not used | N/A | ||
| Costs | Not used | U99_O402_86 - Actual shipments costs (€) | ||
| P&I | Cycle Stock | Cycle stock calculated for P&I exercise | Cycle stock | U99_O402_57 - Cycle Stock |
| P&I | SHS Rlt | SHS-Replenishment Lead time is calculated from a number of different lead times coming from SAP. This SHS RLT is multilevel & multi-site | SHS RLT | U99_O402_59 - SHS RLT |
| P&I | Past and future demand | Actual total demand & Future demand | U99_O402_63 - Past and Futur demand | |
| Other KPIs | Purchase plan (ETA) | Receipt plan for products coming from external source (external supplier) | resupply from supplier (U01 Z115) | U99_O402_23 - Purchased plan (ETA) |
| Other KPIs | Actuals received from external supplier | External purchase from SAP | U99_O402_3 - Actual purchased material | |
| Other KPIs | Swap balance | Not applicable | U99_O402_25 - Planned SWAP U.S |
The best way to get IT support is to use the new
Service One Platform.