Supply Chain Planning and Demand Forecasting: From Forecast to Stock Decision
Stock-outs, excess inventory and rush orders usually trace back to weak planning. A forecast that is wrong in a known direction, a safety stock set by habit or a supplier lead time nobody has measured all create cost. This course gives planners and buyers a practical routine.
The two days move from understanding demand, through forecasting methods and accuracy measures, to inventory rules and the monthly planning meeting. Exercises use Excel and sample data. It is operations focused and complements the procurement integrity course, which covers ethics and controls rather than planning.
HRD Corp SBL-Khas Claimable
Programme Agenda
Day 1, 9:00 AM - 9:15 AM
Welcome and Programme Overview
Introduction to the session, objectives, and housekeeping.
Day 1, 9:15 AM - 10:15 AM
The Planning Cycle and Where Things Go Wrong
How demand, supply, inventory and cash connect, the planning roles and where typical failures start. Choosing the few measures that show whether planning is working.
Day 1, 10:15 AM - 10:30 AM
Break
Day 1, 10:30 AM - 12:30 PM
Understanding Demand: Patterns and Data
Trend, seasonality, promotions and one-off events, cleaning demand history, separating true demand from sales and handling new products with little history.
Day 1, 12:30 PM - 1:30 PM
Lunch
Day 1, 1:30 PM - 3:15 PM
Forecasting Methods You Can Use in Excel
Moving averages, exponential smoothing and simple seasonal methods, when each works and how judgement and sales input should be added and recorded.
Day 1, 3:15 PM - 3:30 PM
Break
Day 1, 3:30 PM - 4:45 PM
Measuring Forecast Accuracy and Bias
Error measures such as MAPE and bias, tracking accuracy by product group, finding systematic over- or under-forecasting and setting realistic targets.
Day 1, 4:45 PM - 5:00 PM
Day 1 Close
Recap and what to review before day two.
Day 2, 9:00 AM - 9:15 AM
Day 1 Review
Recap of day one and the questions it left open.
Day 2, 9:15 AM - 10:15 AM
Inventory Policy: Safety Stock and Reorder Points
Service levels, demand and lead-time variability, safety stock and reorder point calculations, order quantity trade-offs and ABC classification.
Day 2, 10:15 AM - 10:30 AM
Break
Day 2, 10:30 AM - 12:30 PM
Supplier Lead Times and Replenishment
Measuring real lead times and their variation, working with suppliers on reliability, minimum order quantities and handling shortages and delays.
Day 2, 12:30 PM - 1:30 PM
Lunch
Day 2, 1:30 PM - 3:15 PM
Sales and Operations Planning
The monthly S&OP cycle, who attends, what each function brings, reconciling demand and supply plans and resolving trade-offs with finance.
Day 2, 3:15 PM - 3:30 PM
Break
Day 2, 3:30 PM - 4:45 PM
Capstone: A Planning Pack for One Product Family
Participants build a forecast, calculate safety stock and reorder points and prepare a one-page plan with risks, using sample or their own data.
Day 2, 4:45 PM - 5:00 PM
Wrap-Up and Q&A
Key takeaways, next steps, and close.
Key Outcomes
- Describe the planning cycle and choose useful measures
- Prepare demand data and identify patterns
- Build simple forecasts in Excel and add judgement transparently
- Measure forecast accuracy and bias
- Set safety stock and reorder points from service level and variability
- Prepare input for a monthly S&OP meeting
Training Mode Physical / Online / Hybrid / e-learning
HRD Corp SBL-Khas Claimable
Level Foundation to intermediate, for planners, buyers, warehouse, operations and sales support staff. Basic Excel skills are assumed.
Duration 2 Days (16 Hours) | 9:00 AM to 5:00 PM daily
Venue In-house at the client's premises, or delivered via the client's preferred platform (Microsoft Teams, Zoom, or equivalent)
Assessment A capstone planning pack built in Excel, plus a short knowledge check
Certificate Certificate of Completion issued to all participants upon full attendance