General presentation

Objective of the application

The two reports are built over the Stocks data adding other information (Dynasys, OTIF, Open Order and SMOG) in order to provide some Production analysis.

Tool Leader + IT leader of the application: Carolina Camacho + Diogo Paiva

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Authorization objects

List of authorization objects mandatory for the application.

Dataflow overview

Delta report:

Objects developed:

• CPMMIM08 - Delta Analysis

Production report:

Objects developed:

• ABMMIM08R - Material Movement - Snapshot 6 months
• CV_MM_IM_CPMIMIM09
• CPMMIM09 - MTO-FB Analysis

Functional and Technical rules on Workbench + Reporting

Delta report definition:

Production report definition:

Reporting

Main queries

BW_QRY_CPMMIM08_0001 - Delta Report

Row: 

• Material
• Final decision on Strategy

Key figures:

• Batch Size

Formula: Material Plant attribute Fixed Lot Size

• Safety Stock
• Target Stock
• Year/Month (Inventory Stock Quantity from Last Month from previous year)
• Year/Month (Inventory Stock Quantity from M-3)
• Year/Month (Inventory Stock Quantity from M-2)
• Year/Month (Inventory Stock Quantity from M-1)
• Year/Month (Inventory Stock Quantity from M)
• Year/Month (Value EUR) (Inventory Stock Value EUR from M)
• Year/Month (Value LC)    (Inventory Stock Value LC from M)
• SMOG Quantity Year/Month
• SMOG Value Year/Month
• Year/Month vs Target

Formula: Stock M - Target Stock

• Year/Month vs Year/Month

Formula: Stock M - Stock M-1

• Year/Month vs Year/Month

Formula:  Stock M - Stock Last Month from Y-1

• DEFICIENT: Need to build inventory

Formula: If Year/Month vs Target < 0 then Year/Month vs Target else 0

• EXCESS: Need to reduce inventory

Formula: If Year/Month vs Target > 0 then Year/Month vs Target else 0

• Avg Target Stock PI Dynasys for 01.2021

Formula: ( Cycle Stock (12 months) + Safety Stock (12 months) ) / 12

• DIOH Target based on Baseline

Formula: Target Stock * 365 / Dynasys Past Future Demand (PI scope from prompt)

• DIOH Target based on Past

Formula: Target Stock * 365 / 4 * Dynasys Past Future Demand (Consumption from last 3 months)

• DIOH Target based on Future Demand

Formula: Target Stock * 365 / 4 * Dynasys Past Future Demand (Current Month + 2 months)

• Actual DIOH based on Past

Formula: Inventory Stock M * 365 / 4 * Dynasys Past Future Demand (Consumption from last 3 months)

• Actual DIOH based on Future

Formula: Inventory Stock M * 365 / 4 * Dynasys Past Future Demand (Current Month + 2 months)

• DIOH Target based on Past (OTIF)

Formula: Target Stock * 365 / 4 * OTIF (Consumption from last 3 months)

• Actual DIOH based on Past (OTIF)

Formula: Inventory Stock M * 365 / 4 * OTIF (Consumption from last 3 months)

BW_QRY_CPMMIM09_0001 - Production Report

Row:

• Material

Key figures:

• Batch Size 

            Formula: Material Plant attribute Fixed Lot Size

• AVERAGE Requested Deliver - Production 

             Formula: 1 St ATP Date - Production Date

• Production Quantity
• Shipped Quantity
• Quantity Consumed Internally
• Inventory Accumulation

            Formula: Production Quantity - Shipped Quantity - Quantity Consumed Internally

• SMOG
• EOM - Valuated Stock
• Open Order Request Quantity

Workbooks

BW_WBK_CPMMIM08_0001 - Delta Report

BW_WBK_CPMMIM09_0001 - Production Report