Forecasting & Replenishment

1. Forecasting & Replenishment

2. Forecasting & Replenishment Forecasting

3. Forecasting & Replenishment Forecasting Historical Usage

4. Forecasting & Replenishment Forecasting Historical Usage ADJ

5. Forecasting & Replenishment Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas

6. Forecasting & Replenishment Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas Adjustment at SKU level

7. Forecasting & Replenishment Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas Forecast Summary Adjustment at SKU level

8. Forecasting & Replenishment Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas Collaborative Forecast Forecast Summary Adjustment at SKU level

9. Forecasting & Replenishment Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas Collaborative Forecast Sales Promotions Forecast Summary Adjustment at SKU level

10. Collaborative Forecasting Historical Usage T O T A L F O R E C A S T Statistical Forecast Adjustments Promotions

11. Collaborative Forecasting Historical Usage T O T A L F O R E C A S T Customer 123 Statistical Forecast Adjustments Promotions

12. Collaborative Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T Customer 123 Formulas Statistical Forecast Adjustments Promotions

13. Collaborative Forecasting Historical Usage F O R E C A S T Collaborative Forecast T O T A L F O R E C A S T Customer 123 Formulas Statistical Forecast Adjustments Promotions

14. Collaborative Forecasting Historical Usage F O R E C A S T Collaborative Forecast T O T A L F O R E C A S T Customer 123 Formulas Excel Statistical Forecast Adjustments Promotions Customer 123 Sales Representative

15. Collaborative Forecasting Historical Usage F O R E C A S T Collaborative Forecast Customer Forecast T O T A L F O R E C A S T Customer 123 Formulas Excel Statistical Forecast Adjustments Promotions Customer 123 Sales Representative

16. Forecasting & Replenishment Forecasting Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas Collaborative Forecast Sales Promotions Forecast Summary Adjustment at SKU level

17. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Formulas Collaborative Forecast Sales Promotions Forecast Summary Adjustment at SKU level

18. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas 52 Period Forecast Collaborative Forecast Sales Promotions Forecast Summary Adjustment at SKU level

19. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas 52 Period Forecast Collaborative Forecast Sales Promotions Forecast Summary Adjustment at SKU level

20. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas Suggested Order 52 Period Forecast Expected Inventory Collaborative Forecast Sales Promotions Forecast Summary Adjustment at SKU level

21. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas Suggested Order 52 Period Forecast Expected Inventory Collaborative Forecast Lead Time Sales Promotions Vendor Targets Forecast Summary Adjustment at SKU level

22. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas Suggested Order 52 Period Forecast Expected Inventory Collaborative Forecast Lead Time Sales Promotions Vendor Targets Forecast Summary Surplus Inventory Adjustment at SKU level

23. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas Suggested Order 52 Period Forecast Expected Inventory Collaborative Forecast Lead Time Sales Promotions Vendor Targets Transfer Order Forecast Summary Surplus Inventory Adjustment at SKU level

24. Forecasting & Replenishment Forecasting Production & Kits 52 Period Forecast Historical Usage F O R E C A S T T O T A L F O R E C A S T ADJ Replenishment Formulas Suggested Order Purchase Order 52 Period Forecast Expected Inventory Collaborative Forecast Lead Time Sales Promotions Vendor Targets Transfer Order Forecast Summary Surplus Inventory Adjustment at SKU level

25. Vendor Replenishment • Lead Time Horizon Calculation • Lead Time - Days • Review Cycle - Days • Safety Stock – Days or Dynamic Safety Stock Review Cycle Days Lead Time Days Safety Stock Today 60 Days 7 Days 14 Days Buying For 81 Days

26. Distribution Requirements Planning (DRP) • DRP Looks at the Entire Company and Optimizes Inventory Across All Warehouses • Rolls Historical Usage Up Based on Replenishment Path • Forecast At Each Warehouse/Item • Compares Time Phased Inventory to Rolled Up Forecast • Manages • Vendor Replenishment • Hub and Spoke • Branch Replenishment • Inventory Balancing

27. Replenishment Path – Hub and Spoke Vendor 1 Vendor 2 WH 1 WH 2 WH 3 WH 4 WH 5 WH 6 WH 7 WH 8 WH 9 Vendor Replenishment – Based on Lead Time Horizon Warehouse Replenishment – Based on Days Supply Example: WH 1, WH2 = Lead Time Horizon 90 Days WH 3 = Lead Time Horizon 30 Days WH 4, WH 5, WH6 = Min Days 14 Max Days 21 WH 9 – Min Days 10 Max Days 14 WH 7, WH 8 – Min Days 10 Max Days 14

28. Inventory Balancing – Hub and Spoke Vendor 1 Vendor 2 Transfer 100 Transfer 100 WH 1 WH 2 WH 3 Transfer 50 WH 4 WH 5 WH 6 WH 7 WH 8 Example: WH 1 has Need of 250 WH 2 has Surplus of 100 WH 3 has Surplus of 100 WH 7 has Surplus of 75 WH 9

29. Software Demonstration