310 likes | 502 Views
Forecasting & Replenishment. Forecasting & Replenishment. Forecasting. Forecasting & Replenishment. Forecasting. Historical Usage. Forecasting & Replenishment. Forecasting. Historical Usage. ADJ. Forecasting & Replenishment. Forecasting. Historical Usage. F O R E C A S T. T O
E N D
Forecasting & Replenishment Forecasting
Forecasting & Replenishment Forecasting Historical Usage
Forecasting & Replenishment Forecasting Historical Usage ADJ
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
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
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
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
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
Collaborative Forecasting Historical Usage T O T A L F O R E C A S T Statistical Forecast Adjustments Promotions
Collaborative Forecasting Historical Usage T O T A L F O R E C A S T Customer 123 Statistical Forecast Adjustments Promotions
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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