Forecasting Replenishment Forecasting Replenishment Forecasting Forecasting Replenishment Forecasting

  • Slides: 29
Download presentation
Forecasting & Replenishment

Forecasting & Replenishment

Forecasting & Replenishment Forecasting

Forecasting & Replenishment Forecasting

Forecasting & Replenishment Forecasting Historical Usage

Forecasting & Replenishment Forecasting Historical Usage

Forecasting & Replenishment Forecasting Historical Usage ADJ

Forecasting & Replenishment Forecasting Historical Usage ADJ

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Collaborative Forecasting T O T A L Historical Usage Statistical Forecast Adjustments Promotions F

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

Collaborative Forecasting T O T A L Customer 123 Historical Usage Statistical Forecast Adjustments

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

Collaborative Forecasting Customer 123 F O R E C A S T T O

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

Collaborative Forecasting Customer 123 F O R E C A S T T O

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

Collaborative Forecasting Customer 123 F O R E C A S T T O

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

Collaborative Forecasting Customer 123 F O R E C A S T Collaborative Forecast

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Forecasting & Replenishment Forecasting Historical Usage ADJ F O R E C A S

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

Vendor Replenishment § Lead Time Horizon Calculation – Lead Time - Days – Review

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

Distribution Requirements Planning (DRP) § DRP Looks at the Entire Company and Optimizes Inventory

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 4

Replenishment Path – Hub and Spoke Vendor 1 Vendor 2 WH 1 WH 4 WH 5 WH 9 WH 2 WH 6 WH 3 WH 7 WH 8 Vendor Replenishment – Based on Lead Time Horizon Warehouse Replenishment – Based on Days Supply Example: WH 1, WH 2 = Lead Time Horizon 90 Days WH 3 = Lead Time Horizon 30 Days WH 4, WH 5, WH 6 = 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 WH 1

Inventory Balancing – Hub and Spoke Vendor 1 Vendor 2 Transfer 100 WH 1 WH 4 WH 5 WH 9 Transfer 100 WH 2 WH 6 Transfer 50 WH 3 WH 7 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 8

Software Demonstration

Software Demonstration

Entering Item Replenishment Attributes Concept Entering Item ReplenishmentEntering Item Replenishment Attributes Concept Entering Item Replenishment
Viewing Replenishment Requests Concept Viewing Replenishment Requests ViewingViewing Replenishment Requests Concept Viewing Replenishment Requests Viewing
EOB Warehousing Replenishment Set Up QAD Warehousing ReplenishmentEOB Warehousing Replenishment Set Up QAD Warehousing Replenishment
EOB Warehousing Replenishment Set Up QAD Warehousing ReplenishmentEOB Warehousing Replenishment Set Up QAD Warehousing Replenishment
Creating Replenishment Requests Concept Creating Replenishment Requests CreatingCreating Replenishment Requests Concept Creating Replenishment Requests Creating
Calculating Replenishment Parameters Concept Calculating Replenishment Parameters CalculatingCalculating Replenishment Parameters Concept Calculating Replenishment Parameters Calculating
EOB Warehousing Warehusing Replenishment QAD Warehousing Replenishment ObjectivesEOB Warehousing Warehusing Replenishment QAD Warehousing Replenishment Objectives
CHAPTER 5 DEMAND FORECASTING COLLABORATIVE PLANNING FORECASTING REPLENISHMENTCHAPTER 5 DEMAND FORECASTING COLLABORATIVE PLANNING FORECASTING REPLENISHMENT
forecasting longterm forecasting middleterm forecasting shortterm forecasting 2forecasting longterm forecasting middleterm forecasting shortterm forecasting 2
Secure Collaborative Planning Forecasting and Replenishment Vinayak DeshpandeSecure Collaborative Planning Forecasting and Replenishment Vinayak Deshpande
Introduction Definition Forecasting Technology Technological Forecasting Process ForecastingIntroduction Definition Forecasting Technology Technological Forecasting Process Forecasting
Forecasting Forecasting Problems and Methods New product forecastingForecasting Forecasting Problems and Methods New product forecasting
Forecasting Forecasting A Basis of Forecasting In businessForecasting Forecasting A Basis of Forecasting In business
Forecasting Forecasting A Basis of Forecasting In businessForecasting Forecasting A Basis of Forecasting In business
DEMAND FORECASTING DEMAND FORECASTING Demand forecasting means estimationDEMAND FORECASTING DEMAND FORECASTING Demand forecasting means estimation
Forecasting Models FORECASTING Forecasting is attempting to predictForecasting Models FORECASTING Forecasting is attempting to predict
IBM SCPM Replenishment Order 17 September 2020 2004IBM SCPM Replenishment Order 17 September 2020 2004
OnePlate Single Component EN Bath MakeUp and ReplenishmentOnePlate Single Component EN Bath MakeUp and Replenishment
Operations Risk Management Planning Template for Underway ReplenishmentOperations Risk Management Planning Template for Underway Replenishment
Bar Code Assisted Picking and Replenishment An EnhancementBar Code Assisted Picking and Replenishment An Enhancement
Replenishment Workload Tool By Amber Slike Project ObjectivesReplenishment Workload Tool By Amber Slike Project Objectives
Managing Facilitating Goods Replenishment order Factory Production DelayManaging Facilitating Goods Replenishment order Factory Production Delay
MCC Demand Planning DP Replenishment Planning RP SpaceCategoryMCC Demand Planning DP Replenishment Planning RP SpaceCategory
Decision Support for Vendor Managed Inventory Replenishment MartinDecision Support for Vendor Managed Inventory Replenishment Martin