Course Overview for Strategic Production Planning and Control: Integrating Demand Forecasting, Resource Availability and Capacity Planning
In today’s competitive and fast-changing business environment, manufacturers face constant pressure to deliver the right products, in the right quantity, at the right time, at the lowest possible cost. Fluctuating customer demand, limited resources, capacity constraints and supply chain disruptions make production planning increasingly complex. Without a structured approach, organizations often struggle with missed delivery dates, excess inventory, idle capacity, frequent overtime and rising operating costs.
Effective Production Planning and Control (PPC) is the foundation of operational excellence. It connects demand forecasts with the realities of manpower, machines, materials and capacity, so the organization can make informed decisions, commit to achievable schedules and respond quickly to change. When forecasting, resource planning and capacity planning work together, companies gain better visibility, stronger cross-functional alignment and greater control over their operations.
This two-day program, Strategic Production Planning and Control: Integrating Demand Forecasting, Resource Availability and Capacity Planning, gives participants the concepts, tools and practical techniques to plan and control production effectively. Through interactive discussions, real-world case studies and hands-on Excel workshops, participants will learn how to forecast demand, assess resource readiness, balance capacity against requirements, build realistic production schedules and monitor performance using key indicators. By the end of the program, participants will be ready to apply a structured planning approach that improves efficiency, reduces costs and enhances on-time delivery to customers.
Course Objectives
By the end of this program, participants will be able to:
- Explain the role, scope and importance of Production Planning and Control (PPC) in achieving organizational and operational goals.
- Apply qualitative and quantitative forecasting techniques to estimate customer demand and measure forecast accuracy.
- Develop aggregate production plans through the Sales and Operations Planning (S&OP) process to align demand with supply.
- Assess resource availability in manpower, machines and materials, and identify constraints that may affect production.
- Calculate capacity requirements, analyze bottlenecks and apply suitable strategies to close capacity–demand gaps.
- Build a Master Production Schedule (MPS) and apply Material Requirements Planning (MRP) logic to support production execution.
- Use scheduling and sequencing techniques to manage shop floor operations, including rush orders and unexpected disruptions.
- Monitor production performance using key PPC indicators and drive continuous improvement to raise efficiency, reduce costs and improve on-time delivery.
Learning Outcomes
- Describe the PPC planning hierarchy and how strategic, tactical and operational plans link to one another.
- Produce demand forecasts using moving average, weighted moving average and exponential smoothing methods in Excel.
- Evaluate forecast performance
- Prepare an aggregate production plan using chase, level or hybrid strategies, and compare their cost implications.
- Complete a resource readiness assessment covering manpower, machine availability (OEE) and material lead times.
- Perform rough-cut capacity calculations, identify bottleneck resources and propose actions to balance capacity with demand.
- Construct a Master Production Schedule and MRP record, and develop a shop floor schedule using appropriate sequencing rules.
Methodology
This program uses a workshop-based, experiential learning approach, with roughly 70% hands-on practice and 30% concept input. Participants learn by doing: each concept is introduced briefly, then immediately applied through practical workshops built around an integrated case company. This ensures participants leave with practical skills, ready-to-use tools and a clear plan for workplace application.
Learning Approach
- Concept Briefing (Learn)
Short, focused input sessions introduce key PPC principles, techniques and formulas, supported by real industry examples. - Hands-On Workshops (Apply)
Participants work in small groups of 4–5 on eight progressive workshops using the “ABC Manufacturing Sdn Bhd” case. Each workshop builds on the previous one, so by the end of Day 2 groups have developed a complete plan, from demand forecast to shop floor schedule. - Excel-Based Planning Tools (Practice)
Participants use Excel templates to calculate forecasts, aggregate plans, capacity loads, MPS and MRP records, building skills they can apply directly at work. - Simulation (Experience)
The Shop Floor Disruption Game recreates real production pressures such as breakdowns, rush orders and material delays, training participants to replan quickly and make sound decisions. - Group Presentations and Peer Review (Share)
Groups present their outputs to “management” and receive feedback from the facilitator and peers, strengthening analytical, communication and teamwork skills.
Course Content
Day 1: Forecasting and Planning Foundations
Module 1: Introduction to Production Planning and Control
- Purpose and scope of PPC
- The planning hierarchy: strategic, tactical and operational
- Links between sales, operations, procurement and finance
- Common PPC challenges and their cost to the business
- Activity: Identify planning pain points in your organization
Module 2: Demand Forecasting Techniques
- Why forecasting matters: make-to-stock vs make-to-order
- Qualitative methods: market research, Delphi, sales force input
- Quantitative methods: moving average, weighted moving average, exponential smoothing, trend and seasonality
- Measuring forecast accuracy
- Workshop: Build and compare forecasts in Excel
Module 3: Sales and Operations Planning (S&OP)
- The S&OP process and monthly cycle
- Aggregate planning strategies: chase, level and hybrid
- Cost trade-offs: overtime, hiring, subcontracting and inventory
- Aligning demand plans with supply plans
- Case study: Develop an aggregate production plan
Module 4: Resource Availability Assessment
- Manpower planning: skills matrix, shifts, absenteeism and productivity
- Machine availability: uptime, maintenance schedules and OEE
- Material availability: lead times, supplier reliability and safety stock
- Identifying resource constraints early
- Group exercise: Resource readiness checklist
Day 2: Capacity, Scheduling and Control
Module 5: Capacity Planning
- Design, effective and actual capacity; utilization and efficiency
- Capacity planning levels: RCCP and CRP
- Bottleneck analysis and Theory of Constraints (TOC)
- Strategies to close capacity gaps: lead, lag and match
- Workshop: Calculate capacity requirements and identify bottlenecks
Module 6: Master Production Scheduling and MRP
- Building the Master Production Schedule (MPS)
- Available-to-Promise (ATP) and time fences
- Material Requirements Planning (MRP) logic: BOM, lead time offsetting and lot sizing
- Exercise: Develop an MPS and MRP record
Module 7: Production Scheduling and Shop Floor Control
- Scheduling methods: forward, backward and finite vs infinite loading
- Sequencing rules
- Gantt charts and visual scheduling
- Managing rush orders, breakdowns and schedule changes
- Simulation: Scheduling under real-world disruptions
Module 8: Performance Monitoring and Continuous Improvement
- Key PPC KPIs: schedule adherence, OTIF, capacity utilization, forecast accuracy and inventory turns
- Production control meetings and escalation routines
- Lean tools to support PPC: heijunka, kanban and SMED
- Action plan: Apply the learning in your workplace


