Monthly Demand Supply Process

Step 1: Sales Revenue

+ Historical Data

+ Seasonal Holiday

+ Store Ratio

+ Actual Active Selling SKU

+ Promotion Plan

Step 2: Set % Buffer Stock per day

+ Product Mix

+ Selling Price per channel

+ Selling price after discount

Step 3: MRP - Material Resource Planning

+ Production Quantity = Monthly Target - EOH + Safety Stock

Safety Stock

+ Store ratio

+ New launching/ Selling/ End of line SKU

+ Promotion in Which SKU

+ Leadtime Production

+ Shelf-life of Product

+ Timeline from Starting production to end (reach store level)

Case study

Q & A