Chapter 11
Capacity Analytics, Optimization and Decision Models
Post Graduate Program in Production Management
Capacity Requirement Planning
•
Post Graduate
Capacity Analytics, Optimization and Decision Models
Introduction
Capacity decisions determine whether an operation can satisfy demand, deliver promised lead times, and earn an acceptable return on invested resources. At postgraduate level, capacity planning is not merely the calculation of available machine hours. It is a decision problem involving uncertainty, economics, technology, labour, supply networks, quality, sustainability and strategic flexibility.
Capacity Requirement Planning (CRP) translates the master production schedule and material requirements plan into time-phased requirements for labour, machines, tools and supporting resources. The analytical challenge is to compare these requirements with feasible capacity and then select an appropriate response: reschedule work, add shifts, subcontract, purchase equipment, redesign the process, or expand permanently.
This chapter develops a decision toolkit comprising break-even analysis, learning curves, linear programming (LP), mixed-integer linear programming (MILP), simulation, multi-criteria decision analysis (MCDA), and performance dashboards. These methods are complementary. Optimization identifies a mathematically efficient plan under stated assumptions; simulation tests performance under variability; MCDA incorporates strategic and qualitative criteria; dashboards support continuing control.
Learning Objectives
After studying this chapter, the reader should be able to:
Calculate and interpret operating break-even points and capacity-related sensitivity measures.
Apply learning-curve models to labour and capacity estimates while recognising their limitations.
Formulate LP and MILP models for resource allocation, make-or-buy and expansion decisions.
Use simulation to evaluate capacity policies under uncertainty and congestion.
Construct an MCDA model that makes assumptions and trade-offs transparent.
Design a capacity performance dashboard using valid operational and economic measures.
Integrate analytical results with managerial judgement, governance and responsible decision-making.
1. Capacity as an Economic and Operational Decision
Three capacity concepts must be distinguished:
Design capacity is the theoretical maximum output under specified conditions.
Effective capacity is the maximum output after considering planned maintenance, product mix, breaks, changeovers and other normal losses.
Actual output is what the system produces in a specified period.
Capacity utilisation and efficiency are different measures. If output and capacity are measured in the same units,
Utilisation = Actual output ÷ Design capacity × 100%
Efficiency = Actual output ÷ Effective capacity × 100%
These ratios assume that output is meaningfully aggregatable. In a high-mix environment, standard hours or equivalent units are often preferable to physical units. A utilisation rate above 100% may indicate overtime, temporary labour or an understated design standard; it does not necessarily indicate a sustainable condition.
A resource is a bottleneck when its available capacity constrains system throughput. The bottleneck may be a machine, skilled employee, inspection station, supplier, warehouse dock, information system or managerial approval. The Theory of Constraints therefore emphasises identifying the constraint, exploiting it, subordinating other activities, elevating it, and then repeating the process when the constraint moves.
A CRP comparison is commonly expressed as:
Net capacity gapt = Required capacityt − Available capacityt
A positive gap indicates overload; a negative gap indicates nominal surplus. This calculation is useful only when the time bucket, resource definition, calendar, routing standards and units are consistent.
2. Break-Even and Capacity Economics
Break-even analysis examines the volume at which total revenue equals total cost. Under a single-product, linear-cost model:
QBE = F ÷ (p − v)
where QBE is break-even quantity (units), F is total fixed cost per period (currency), p is selling price per unit (currency/unit), and v is variable cost per unit (currency/unit). The denominator, p − v, is the unit contribution margin.
The corresponding break-even sales revenue is:
SBE = F ÷ CMratio
where CMratio = (p − v) ÷ p. The model assumes constant price and variable cost, fixed costs unchanged over the relevant range, all output sold, a single product or constant sales mix, and linear capacity. It becomes unreliable near step changes, overtime thresholds, quantity discounts or multiple bottlenecks.
Worked example: make-or-buy volume
A plant can make a component for a fixed annual cost of $180,000 and a variable cost of $14 per unit. A supplier offers the component for $26 per unit. Ignoring avoidable-versus-unavoidable fixed-cost distinctions initially, the indifference volume is:
Q = 180,000 ÷ (26 − 14) = 15,000 units
Below 15,000 units, buying is cheaper under these assumptions; above 15,000 units, making is cheaper. However, the conclusion changes if only $120,000 of fixed cost is avoidable when buying. The relevant comparison then uses $120,000, producing an indifference volume of 10,000 units. This illustrates a central managerial principle: decisions should use relevant incremental cash flows, not allocated accounting costs.
For two alternatives with different fixed and variable costs, the cost difference is:
∆Cost = (Fmake − Fbuy) + (vmake − vbuy)Q
Sensitivity analysis should vary demand, price, scrap, energy cost, exchange rate, supplier reliability and the value of released capacity. If released capacity can produce a profitable product, its opportunity cost must be included in the make decision.
3. Learning Curves and Capacity Estimation
Learning effects occur when cumulative production improves task time through repetition, process refinement, better tooling and organisational learning. The cumulative-average learning model is:
Y = aXb
where Y is cumulative average labour time per unit after producing X units, a is the time for the first unit, and b = log2(r) when r is the learning rate expressed as a decimal. For example, an 80% curve has r = 0.80 and b < 0. The model assumes a stable product, comparable work content, and a consistent learning mechanism.
If cumulative output doubles, cumulative average time becomes r times its former value. The total time for the first X units is:
Ttotal = X × Y = aX^(b+1)
Worked example
The first aircraft assembly requires 1,000 direct labour hours and the process follows an 80% cumulative-average curve. For 4 assemblies:
b = log2(0.80) ≈ −0.3219
Y = 1,000 × 4^(−0.3219) ≈ 640 hours per assembly
Thus, total labour for the first four assemblies is approximately:
Ttotal = 4 × 640 = 2,560 labour hours
The estimate is not a promise that the fourth unit individually requires 640 hours. It is a cumulative average. Confusing cumulative-average and unit-time learning curves can materially distort CRP results.
Learning models should be recalibrated with observed data. They may fail when employees rotate, automation changes the work, design modifications reset learning, quality problems increase rework, or learning saturates. A prudent planner uses a range of learning rates and includes ramp-up uncertainty rather than relying on one point estimate.
4. Linear Programming for Resource Allocation
LP allocates divisible quantities among competing activities. A general maximisation model is:
Maximise Z = ∑(j=1 to n) cj xj
subject to
∑(j=1 to n) aij xj ≤ bi, for each resource i
xj ≥ 0
Here, xj is the quantity of activity or product j, cj is its contribution per unit, aij is resource i consumed per unit, bi is available resource i, and Z is total contribution. Coefficients must use compatible units, such as machine-hours per unit and available machine-hours per period.
Worked example: constrained product mix
Products A and B provide contributions of $40 and $30. Each unit requires machine and labour hours as follows:
Product
Machine hours
Labour hours
Contribution
A
2
1
$40
B
1
1.5
$30
Available capacity is 100 machine-hours and 90 labour-hours. The LP is:
Maximise Z = 40A + 30B
subject to
2A + B ≤ 100 A + 1.5B ≤ 90 A, B ≥ 0
At the intersection of both constraints, 2A+B=100 and A+1.5B=90. Solving gives A=36 and B=28. The contribution is:
Z = 40(36) + 30(28) = $2,280
The solution uses all 100 machine-hours and 78 labour-hours, so machine capacity is binding while labour has 12 hours of slack. In a formal LP, a solver also reports shadow prices, which estimate the marginal value of one additional unit of a binding resource within the valid sensitivity range. Shadow prices are not automatically valid for large capacity expansions or nonlinear changes.
LP is appropriate when products can be fractionally represented or quantities are sufficiently large for continuous approximation. It is inappropriate when setup decisions, indivisible machines, minimum batches or logical conditions are essential.
5. Mixed-Integer Linear Programming for Discrete Capacity Decisions
MILP extends LP by requiring selected variables to be integers or binary. Binary variables represent yes/no decisions such as opening a shift, buying a machine, using a supplier or activating overtime.
A simplified expansion model is:
Minimise Total cost = ∑ Fk yk + ∑ cj xj
subject to
∑ aij xj ≤ ∑ Capik yk, for each resource i
∑ dj xj ≥ Demand
yk ∈ {0,1}, xj ≥ 0
yk indicates whether capacity option k is selected, Fk is its fixed cost, Capik is the capacity it contributes to resource i, and dj is output or demand coverage associated with activity j. Additional constraints can represent minimum run lengths, mutually exclusive technologies, supplier qualification, overtime limits and lead-time requirements.
A common modelling error is failure to link a continuous activity to a binary activation variable. If production is possible only when a line is opened, a constraint such as xj ≤ M yk is required, where M is a valid upper bound. An excessively large M can weaken computational performance and produce numerical difficulties; the bound should be as tight as operationally defensible.
MILP results should be interpreted with the optimality gap, data quality and scenario assumptions. A mathematically optimal solution may be operationally fragile if it depends on exact demand forecasts, zero disruption or unrealistic changeover times.
6. Simulation for Variability and Congestion
Optimization often uses average values. Real capacity systems experience stochastic arrivals, processing times, breakdowns, absenteeism, rework and priority changes. Discrete-event simulation represents the sequence of events through time and estimates distributions of waiting time, throughput, work-in-process and utilisation.
A basic simulation study follows these steps:
Define the decision question, system boundary and performance measures.
Map entities, resources, queues, routing logic and priority rules.
Collect and validate arrival, processing, failure and repair data.
Build a conceptual model before coding.
Verify that the programmed model implements the conceptual model.
Validate outputs against historical or expert evidence.
Specify warm-up, run length, replications and random-number controls.
Compare policies using confidence intervals and operationally meaningful scenarios.
For a queueing system, Little’s Law provides a powerful consistency check:
L = λW
where L is average number of items in the system, λ is average throughput rate, and W is average time in the system. Units must be consistent, for example units = units/hour × hours. The relationship applies under stable long-run conditions and suitable averaging; it does not by itself describe variability or guarantee that a system is stable.
In a single-server queue, utilisation is often represented as:
ρ = λ ÷ μ
where μ is service rate. As ρ approaches 1, waiting can increase sharply, particularly with variable arrivals and service times. Therefore, a target utilisation below nominal maximum may be economically rational.
Simulation should not be used to conceal weak assumptions. Input distributions, warm-up periods, finite-population effects and random seeds should be documented. Results should include uncertainty, not only a single simulated average.
7. Multi-Criteria Decision Analysis
Capacity decisions frequently involve criteria that cannot be reduced credibly to money: safety, resilience, carbon emissions, strategic capability, quality risk and employee impact. MCDA makes these trade-offs explicit.
A simple weighted-sum model is:
Scorej = ∑(i=1 to m) wi rij
where Scorej is the score of option j, wi is the weight of criterion i, and rij is the normalised rating of option j on criterion i. Usually wi ≥ 0 and ∑wi=1. The method assumes preferential independence and that the scales are meaningfully normalised.
For a beneficial quantitative criterion:
rij = (xij − min xi) ÷ (max xi − min xi)
For a cost or risk criterion, the direction is reversed:
rij = (max xi − xij) ÷ (max xi − min xi)
If all options have the same value for a criterion, this range formula is undefined; the criterion contributes no discrimination unless an externally defined scale is used.
Weights should be elicited from relevant stakeholders and tested through sensitivity analysis. Rank reversal, double-counting correlated criteria and subjective scoring are important limitations. MCDA should structure judgement, not create false precision. Safety, legal compliance and minimum resilience may be treated as non-negotiable constraints rather than merely weighted preferences.
8. Integrated Capacity Decision Framework
A robust decision process combines methods rather than selecting one universally superior technique.
Integrated capacity decision framework
Figure: Integrated capacity decision framework
Figure: An integrated workflow for capacity decisions.
The sequence begins with validated demand, routings, calendars and resource data. Economic analysis removes clearly dominated alternatives. LP or MILP identifies feasible allocations and discrete expansion combinations. Simulation evaluates variability and service consequences. MCDA incorporates strategic, social and environmental criteria. A governance review then determines whether the recommended option is affordable, compliant, explainable and reversible.
9. Capacity Performance Dashboards
A dashboard should support decisions, not merely display attractive numbers. Indicators should be connected to a decision owner, threshold, data source, review frequency and corrective action.
Dimension
Example measure
Interpretation
Demand
Forecast error, bias, demand volatility
Whether planning assumptions are credible
Capacity
Load by bottleneck, available hours, capacity gap
Where overload or surplus exists
Flow
Throughput, cycle time, queue time, WIP
Whether capacity converts into customer flow
Reliability
OEE, downtime, schedule adherence
Whether nominal capacity is dependable
Quality
First-pass yield, scrap, rework hours
Capacity lost through nonconformance
Economics
Contribution per bottleneck hour, cost per unit
Whether scarce capacity is economically allocated
Resilience
Supplier concentration, recovery time, capacity reserve
Ability to absorb disruption
Sustainability
Energy per unit, emissions, waste
Environmental consequences of capacity choices
Overall Equipment Effectiveness is commonly decomposed as:
OEE = Availability × Performance × Quality
Availability, performance and quality are ratios defined by the organisation’s standard. They must not be mixed with inconsistent planned-loss conventions. OEE is diagnostic, not a complete measure of system effectiveness: maximising local OEE can increase inventory or starve a downstream constraint.
Dashboard governance includes master-data ownership, version control, audit trails, access controls and definitions that remain stable across periods. AI-based forecasting or anomaly detection can assist prioritisation, but managers must monitor data drift, explainability, bias and the risk of automated recommendations amplifying historical inequities or unsafe practices.
10. Illustrative Case: Northstar Components
Background
Northstar Components produces two industrial assemblies, X and Y. Demand is seasonal, and a heat-treatment cell is approaching overload. Management is considering overtime, subcontracting or a second furnace.
Problem
The monthly forecast is 300 units of X and 220 units of Y. Each X requires 1.5 heat-treatment hours and contributes $90; each Y requires 2.0 hours and contributes $110. The cell has 850 regular hours. Overtime provides up to 120 hours at an incremental cost of $35 per hour. A qualified subcontractor can supply at most 100 units of either product, but delivery reliability is uncertain. A second furnace costs $42,000 per month and adds 500 hours.
Analysis
Internal requirements are:
300(1.5) + 220(2.0) = 890 hours
The regular-time gap is 40 hours. If only the forecast volume is considered, overtime can cover the gap. However, the relevant capacity decision must include forecast error, failure risk, qualification lead time and future demand. A contribution-per-bottleneck-hour comparison gives:
X: $90 ÷ 1.5 = $60 per heat-treatment hour
Y: $110 ÷ 2.0 = $55 per heat-treatment hour
If demand is flexible and customer commitments permit, X receives priority during shortage. That rule cannot override contractual service requirements or strategic customer considerations.
Northstar formulates a MILP with production quantities, overtime activation, subcontract quantities and furnace acquisition as decision variables. It then simulates each feasible policy using uncertain demand, furnace failures and subcontract delivery delays. The simulation indicates that overtime is cheapest at the forecast but produces unacceptable late deliveries in high-demand scenarios. Subcontracting improves resilience but introduces quality and supplier-risk exposure. The second furnace has the best service performance but is uneconomic unless demand remains above approximately 500 additional heat-treatment hours per month.
An MCDA review assigns criteria for cost, service, resilience, quality risk and emissions. Instead of hiding the trade-off in one cost figure, Northstar presents a recommended staged policy: use limited overtime immediately, qualify the subcontractor as a contingent source, install enhanced condition monitoring, and defer the furnace until a demand trigger is sustained for three months. The trigger is reviewed monthly.
Outcome and learning points
The case illustrates that an average-load calculation alone would understate risk. LP logic supports prioritisation; MILP represents discrete choices; simulation reveals tail performance; MCDA incorporates non-financial concerns. The final policy is a real option: it preserves flexibility while buying information before committing capital. Its success depends on explicit triggers, data quality and disciplined review rather than on the model alone.
11. Challenges, Ethics and Best Practices
Capacity models are vulnerable to inaccurate routings, outdated standard times, missing downtime, forecast bias and double-counted capacity. Aggregating products with incompatible labour or machine content can produce meaningless utilisation. Financial models may treat safety, worker fatigue or environmental damage as externalities. A decision that appears efficient may transfer risk to temporary workers, suppliers, communities or future periods.
Best practice includes:
define the decision, horizon, constraints and objective before selecting a method;
use incremental costs and opportunity costs for alternatives;
reconcile calendars, routings, units and data ownership;
separate hard constraints from preferences;
test base, adverse and upside scenarios;
validate models with operators and subject-matter experts;
report uncertainty, sensitivity and assumptions;
protect confidential supplier, employee and customer data;
preserve human accountability for safety, employment and compliance decisions;
monitor outcomes after implementation and recalibrate the model.
Contemporary capacity analytics increasingly combines ERP/MRP data, Industrial Internet of Things sensors, digital twins, probabilistic forecasting and optimization-as-a-service. These technologies improve timeliness but do not eliminate model risk. A digital twin that reproduces flawed master data is a faster way to reach a flawed conclusion. Responsible deployment therefore requires data lineage, cybersecurity, access governance, model monitoring and a clear escalation path when algorithmic recommendations conflict with operational knowledge.
Chapter Summary
Capacity analytics links operational requirements to economically and strategically defensible decisions. Break-even analysis provides a first screening tool, but relevant costs, opportunity costs and nonlinear capacity steps must be considered. Learning curves improve ramp-up estimates when their assumptions are tested against actual work. LP allocates divisible resources, while MILP represents discrete expansion, activation and make-or-buy choices. Simulation captures variability, queues and service risk that average-based models overlook. MCDA makes financial, operational, environmental and social trade-offs explicit. Dashboards convert analytical conclusions into continuing control through carefully defined indicators. The strongest practice integrates these methods, validates data and models, reports uncertainty, and retains accountable managerial judgement.
Key Terms
Available capacity: Usable resource time after calendars, planned losses and stated constraints.
Bottleneck: A constraint that limits system throughput.
Break-even point: Volume at which relevant revenue equals relevant cost.
Capacity gap: Difference between required and available capacity.
Contribution margin: Selling price less variable cost per unit.
Design capacity: Theoretical maximum output under specified conditions.
Effective capacity: Practical maximum output after normal losses.
Learning curve: Relationship between cumulative output and declining time or cost.
Linear programming: Optimization with linear objective and constraints and continuous variables.
Mixed-integer linear programming: Linear optimization containing integer or binary decisions.
Opportunity cost: Value of the best alternative use of a constrained resource.
OEE: Product of availability, performance and quality ratios.
Shadow price: Marginal value of relaxing a binding constraint within a valid range.
Simulation: Computational representation of system behaviour over time under specified uncertainty.
Utilisation: Actual output relative to design capacity.
Efficiency: Actual output relative to effective capacity.
MCDA: Structured comparison of alternatives across multiple criteria.
Queue: Waiting line formed when demand for a resource exceeds immediate service capacity.
Review Questions
Short Answer Questions
Distinguish design capacity, effective capacity and actual output.
State the assumptions of the basic break-even model.
Explain why a bottleneck’s contribution per hour can be more useful than contribution per unit.
Distinguish LP from MILP.
State Little’s Law and define its variables.
Long Answer Questions
Explain how break-even analysis should be adapted for a make-or-buy decision involving avoidable fixed costs and released capacity.
Discuss the cumulative-average learning curve, including its assumptions and risks of misinterpretation.
Compare LP, MILP and simulation as capacity decision tools.
Explain how an MCDA model can incorporate resilience, quality and sustainability without creating false precision.
Design a capacity dashboard for a high-mix manufacturing plant and justify its measures.
Analytical / Application Questions
A plant has fixed cost of $240,000, selling price of $50 and variable cost of $30 per unit. Calculate the break-even quantity and explain how the result changes if only $150,000 of fixed cost is avoidable in a make-or-buy decision.
Product P contributes $72 and uses 1.2 bottleneck hours; product Q contributes $90 and uses 2.0 bottleneck hours. If demand is flexible and the bottleneck is scarce, determine which product should receive priority and identify one managerial condition that could reverse the recommendation.
Propose an integrated LP/MILP, simulation and MCDA approach for deciding whether to add a production shift. Specify at least two variables, two constraints, two simulation outputs and three MCDA criteria.
Multiple Choice Questions with Answers
Question 1
A product sells for $40, has a variable cost of $24, and the relevant fixed cost is $80,000. What is the break-even quantity?
A. 2,000 units
B. 3,333 units
C. 5,000 units
D. 6,667 units
Correct Answer: C. 5,000 units
Question 2
In the cumulative-average learning model, what does the learning rate describe?
A. The percentage increase in total cost when output doubles
B. The cumulative average time as cumulative output doubles
C. The maximum utilisation of a resource
D. The proportion of fixed cost that becomes variable
Correct Answer: B. The cumulative average time as cumulative output doubles
Question 3
Which condition is represented most directly by a binary variable in an MILP model?
A. The exact processing time of a unit
B. The average demand forecast
C. Whether a second machine is purchased
D. The contribution margin per unit
Correct Answer: C. Whether a second machine is purchased
Question 4
A product contributes $60 and uses 1.5 hours of a bottleneck. Its contribution per bottleneck hour is:
A. $40
B. $60
C. $90
D. $120
Correct Answer: A. $40
Question 5
Little’s Law is expressed as:
A. L = λW
B. L = λ ÷ W
C. W = Lλ
D. λ = LW
Correct Answer: A. L = λW
Question 6
Why can a simulation be useful after an optimization model identifies a capacity plan?
A. It removes the need for input data
B. It tests the plan under variability and sequencing effects
C. It guarantees the plan is financially optimal
D. It converts all qualitative criteria into prices
Correct Answer: B. It tests the plan under variability and sequencing effects
Question 7
In a weighted-sum MCDA model, the usual condition on criterion weights is:
A. Every weight must equal zero
B. Weights must be negative
C. Weights should sum to one
D. Weights must equal the criterion scores
Correct Answer: C. Weights should sum to one
Question 8
If actual output is 800 units and effective capacity is 1,000 units, efficiency is:
A. 20%
B. 80%
C. 100%
D. 125%
Correct Answer: B. 80%
Question 9
Which statement about a shadow price is most accurate?
A. It is always the market price of a resource
B. It estimates the objective improvement from relaxing a binding constraint within a valid range
C. It applies only to binary variables
D. It measures product quality loss
Correct Answer: B. It estimates the objective improvement from relaxing a binding constraint within a valid range
Question 10
Which dashboard measure most directly indicates capacity lost through nonconformance?