Transcript Title

Advance Inventory Planning
Integration Overview
Pedro Pinto
Overview of the Integrated Inventory Management Suite
INTEGRATION
July 16, 2015
© 2008 Wipro Ltd - Confidential
2
Architecture
RMS
RETL
APC
RO
RO
RIB
AIP
External
Systems
RDF
Note: There is no integration developed neither documented with BI (RDW) and Planning modules (mainly MFP).
July 16, 2015
© 2008 Wipro Ltd - Confidential
3
Integration Availability Overview
RMS
RIB ? Integration being evaluated internally
P
RETL
APC
RO
?
P
P*
RO
O
O
AIP
O
O
External
Systems
O
RDF
* - Integration just for store, warehouse is missing.
P- Integration already developed (not tested)
O - Integration not developed
July 16, 2015
© 2008 Wipro Ltd - Confidential
4
Integration RMS to AIP
AIP
RMS
P
P
Measure Data
. Product Hierarchy
. Location Hierarchy
. Supplier Hierarchy
. Warehouses
. Store Promotional Substitution Start Date for Warehouse
. Store Promotional Substitution End Date for Warehouse
. Corporate Discontinuation Date
. Value Added Commodity Association
. Commodity-Supplier Links
. Banded Item Association
. Direct Suppliers
. Store on hand inventory (used to be historical inv)
. Store In transits
. Store On Orders
. Store Product Life
. Current WH Inventory (on hand)
. Warehouse On Orders
. Warehouse In Transits
. Warehouse Orders in the well
. Warehouse Type
. RMS received quantity
. RMS closed orders
- Integration already developed (not tested)
July 16, 2015
P
Hierarchy Data
© 2008 Wipro Ltd - Confidential
5
Integration AIP to RMS
AIP Data
? Being analyzed
. Store Purchase Orders
. Store Transfers
. Warehouse Purchase Orders
. Warehouse Transfers
AIP
RMS
. The integration with RMS is done via RIB, although it is also provided integrated
scripts via RETL to integrate AIP to other external systems.
July 16, 2015
© 2008 Wipro Ltd - Confidential
6
Integration Inventory Management Suite Data Flow
July 16, 2015
© 2008 Wipro Ltd - Confidential
7
Integration RDF to AIP
AIP
RDF
O
Measure Data
. RDF Detail Alert
. RDF Detail Alert Mask
. RDF Detail Alert Count
. Daily Store Forecast Standard Deviation
. Weekly Store Forecast Standard Deviation
. Daily Store Demand Forecast
. Weekly Store Demand Forecast
O
- Integration not developed
July 16, 2015
© 2008 Wipro Ltd - Confidential
8
Integration AIP with RO
P
AIP Data for Stores and Warehouses
(aip_export_to_ro.sh)
. Lead Time
. Review Time
. Pack Size
AIP
RO
P
Warehouse Measure Data
(ro_export_to_aip.sh)
. WH_MINMAX
. WH_DYNAMIC
. WH_TIMESUPPLY
. WH_HYBRID
. WH_MINSS
. WH_ROUpdate
. STR_MINMAX
. STR_DYNAMIC
. STR_TIMESUPPLY
. STR_HYBRID
. STR_POISSON
. STR_MINSS
. STR_ROUpdate
P
O
O
Store Measure Data
- Integration already developed (not tested)
- Integration not developed
July 16, 2015
© 2008 Wipro Ltd - Confidential
9
Integration RO to AIP (more detail)
AIP
Store Measure Data
RO
Warehouse Measure Data
. STR_MINMAX
. WH_MINMAX
- Store Min Stock
- Minimum Stock Exception
- Store Max Stock
- Maximum Stock Exception
- Store Repl Method
- Replenishment Method Exception
. STR_DYNAMIC
. WH_DYNAMIC
- Store Service Level
- Service Level Exception
- Store Inventory Selling Days
- Inventory Selling Days Exception
- Store Repl Method
- Replenishment Method Exception
. STR_TIMESUPPLY
. WH_TIMESUPPLY
- Store Min Time Supply Days
- Minimum Time Supply Days Exception
- Store Max Time Supply Days
- Maximum Time Supply Days Exception
- Store Time Supply Horizon
- Time Supply Horizon Exception
- Store Repl Method
- Replenishment Method Exception
. STR_HYBRID
. WH_HYBRID
- Store Min Time Supply Days
- Minimum Time Supply Days Exception
- Store Inventory Selling Days
- Inventory Selling Days Exception
- Store Repl Method
- Replenishment Method Exception
. STR_POISSON
. WH_MINSS
- Store Service Level
- Minimum Safety Stock Units Exception
- Store Inventory Selling Days
. WH_ROUpdate
- Store Repl Method
- Replenishment Optimization Update for Stores
. STR_MINSS
- Store Min Safety Stock Units
. STR_ROUpdate
- Replenishment Optimization Update for Stores
July 16, 2015
© 2008 Wipro Ltd - Confidential
10
Integration External Systems to AIP
External
Systems
AIP
O
O
O
Hierarchy Data
Measure Data
Measure Data
. Ad Hierarchy (advertisement)
. Interval Hierarchy
. Week to Day Forecast Percentage Default
. Store Week to Day Forecast Percentage Override
. Hold Back Quantity
. Loaded Safety Stock
. SPQ Order Commit Quantity
. Replenishment Subtype Code
. Replenishment Type Code
. Historical Weekly Sales
. Total Held Stock
. Stocking Point Holding Capacity
. Item Attribute
. Item Attribute Type
. Available Purchase Order Number
. Sister Store
. Sister Warehouse
. Store Ads
. Store Ads Grand Opening
. Store Ads Inserts
. Store Ads Others
. Store Ads Run On Press
. Store Adjusted Sales
. Store Average Weekly Rate of Sale Loaded
. Store Customer Orders
. Daily Short Code Sales
. Store Expected Write-off
. Store Historical Lost Sales
. Inventory Adjustments
. Store Known Demand
. Store Replenishment Type Code
. Store Replenishment Subtype Code
. Store Loaded Safety Stock
. Store Trading Days
. Loaded Weekly Base Sales Forecast
. Waste Adjustments
. SRP Poisson Distribution Lookup
. SKU Retail Price
. Store Format Pack Size
. Store Pack Size
. SKU Cost
. SKU Weight and Volume
Measure Data
. Default Warehouse
. Direct Store Format Pack Size
. Direct Store Pack Size
. Off-Sale Effective Date
. On-Sale Effective Date
. Pack Type
. Pre-Priced Status
. Receiving Supplier / Ship To
. Ad/Rollout Notes
. Store Ad End Date
. Store Ad Start Date
. Total Store Average Rate Of Sales
. SPQ Commitment Type Exception
- Integration not developed
July 16, 2015
© 2008 Wipro Ltd - Confidential
11
Integration AIP to External Systems
External
Systems
AIP
O
O
AIP Data
. Store Purchase Orders
. Store Transfers
. Warehouse Purchase Orders
. Warehouse Transfers
- Integration not developed
July 16, 2015
© 2008 Wipro Ltd - Confidential
12
External Integration
July 16, 2015
© 2008 Wipro Ltd - Confidential
13
Internal Integration
July 16, 2015
© 2008 Wipro Ltd - Confidential
14
Daily Batch
July 16, 2015
© 2008 Wipro Ltd - Confidential
15