Capacity Planning Models

Your board wants $30M next year. You closed $23M this year. You added 2 reps. Coolio. Where's the other $7M coming from? Magic? Leadership sets aggressive growth targets without doing the capacity math. Then they blame sales for missing when it was a math problem from day one. Wanting 30% growth is fine. But if you only funded 12% capacity increase, the numbers will never work. Here's why: Most VPs build headcount models that assume perfect conditions. They assume: - Every new hire ramps on schedule (they don't). - Nobody quits (they do). - Every ramped rep hits quota (60% actually do). - Territory productivity stays constant (it declines as you add reps). Then Q3 hits and you're at 70% of plan. The board asks what happened. What happened is the math never worked! Here's how to fix it: 1. Model ramp by time (not title). Every new hire isn't a quota-carrying AE. They're an investment curve: - Month 1-2: Training, zero pipeline. - Month 3: Pipeline opens, close rates low. - Month 6: First meaningful bookings. - Month 9-12: Full ramp (maybe). If you don't know this curve by role, you can't predict bookings. Add 5 AEs in Q1 modeled at full quota? Reality: 0% for 3 months, 30% for 3 months, 60% for 3 months, MAYBE 100% by EOY. Your $30M plan just became $24M. 2. Track productivity per ramp stage. Build bands: - Early Ramp (0-3 months): 0% of quota. - Mid Ramp (3-6 months): 25-50% - Late Ramp (6-12 months): 75% - Fully Ramped (12+ months): 100%+ Model quarterly revenue based on how many reps fall into each stage. 3. Run capacity math before asking for headcount. Before accepting a $30M target, build bottom-up: - Target: $30M. - Avg quota per ramped AE: $1.2M. - Ramped AEs needed: 25. - You have 15 today. - Need 10 more ramped equivalents. New hires aren't ramped for 9-12 months, so hire 15-18 to get 10 ramped by EOY. Factor in 15-20% attrition? You'll lose 3-4 reps. Now you need to hire 18-22 just to net the 10 you need. Suddenly "add 2 reps" looks bonkers. 4. Add drag factors. No model survives reality. Build in: - Ramp delays. - Attrition (10-20% annual). - External shocks (macro headwinds, comp changes). Your model should NEVER presume perfection. 5. Present capacity constraints. Don't say "I need 18 more reps." Say: "To hit $30M with our current productivity and ramp curve, we need 25 fully ramped AEs by EOY. We have 15 today. After factoring ramp time and attrition, that means hiring 18-20 starting Q1." Now THAT'S a business case. The hardest part? Telling leadership their target isn't realistic given current investment. But have that conversation in January. Not October when you're $5M behind. Remember that a headcount plan is nothing more than a capacity forecast. Your CEO, CFO, and board don't want to hear how many reps you hope to hire. They want to know how many fully ramped, productive reps you'll have when it matters. So don't ask for headcount. Prove the need, then hit the number.

Spend 2 minutes reading this post and I'll give you back my notes on Capacity planning in system design interviews, which took me 12+ months to create. Capacity planning is one of the most overlooked yet critical parts of system design. It’s the difference between a system that scales smoothly and one that crumbles under unexpected load.  - In interviews, candidates often throw out random numbers.   - In real-world engineering, inaccurate estimates can cause outages, cost overruns, and poor performance.  Let’s break down how to approach capacity planning properly, with real insights from large-scale distributed systems.  ► Capacity Planning in Interviews: The Checklist  You don’t need exact numbers, but you do need a thought process. Here’s what a structured answer looks like:  1️⃣ Estimate Traffic & Workload      - Number of users per day/month/year      - Requests per second (RPS) at peak load      - Read vs. write ratio      - Data growth over time  2️⃣ Estimate Storage Requirements      - How much data each user generates      - How frequently it needs to be stored      - What kind of storage (SQL, NoSQL, object storage)  3️⃣ Compute & Memory Requirements      - How much CPU is required for each request?      - How much RAM do we need for caching?      - Can we optimize with compression?  4️⃣ Network & Bandwidth Needs      - How much data transfer happens per request?      - Do we need CDNs or caching layers?  5️⃣ Scaling Strategy      - Do we scale vertically (bigger machines) or horizontally (more machines)?      - When do we auto-scale, and how do we handle failovers?  6️⃣ Failure Scenarios & Contingency Planning      - What happens when a database node fails?      - How do we handle spikes in traffic (Black Friday problem)?      - How do we ensure high availability?  This is what interviewers want to see, not memorized numbers, but structured problem-solving.  ► Capacity Planning in the Real World: What Actually Happens  1. You’re Not Working With Theoretical Numbers, — You’re Working With Live Data  - In real-world systems, capacity planning is an ongoing process, not a one-time calculation.  - Engineers constantly monitor metrics (latency, error rates, disk utilization) to adjust resources dynamically.  2. Capacity Planning is Business-Driven  - Your system doesn’t just scale infinitely, there are cost constraints.  - You work with finance teams to optimize cloud costs instead of over-provisioning servers.   - Example: Netflix doesn’t just store all videos forever; they tier storage based on popularity. 

From Siloed Projections to System-Wide Planning: How We Built Singapore’s Healthcare Capacity Framework 3 years ago, our healthcare demand projections were done in silos. Today, we have a coherent, system-wide framework that links demand to infrastructure, manpower, and budget planning. Honoured by the recognition on the work done by the team. Here’s the transformation journey. The Challenge We Faced Demand for each care setting is projected independently, using different assumptions and methodologies. 2023: Building the Foundation Introduced more granular inputs: added parameters e.g. functional impairment levels and family support in long-term care projections. Linked patient flows: Connected across settings (e.g. ED visits to acute inpatient to community hospital). 2024: Achieving System Coherence The coordination challenge: Working across 8+ divisions (IPP, HSD, PCC, APO, MP&S, HF) while handling new policy simulations & evolving capacity decisions. The solution: Set up Capacity Planning Committee (CPC) as single decision platform, replacing piecemeal EXCO discussions. The breakthrough: Obtained approval for our projections alignment framework: • Single baseline model across all projections • Common parameters where models intersect • Systematic accounting for care transformation impacts Real impact: Secured approval for new hospital beds through white space activation and new hospital sites. 2025: Advanced System Modelling Healthier SG simulation: Collaborated with Duke-NUS to quantify HSG’s long-term impact on healthcare demand and costs - answering our persistent questions. Disease-based projections: Piloted new method for mental health services, endorsed and used for service planning Tight deadline delivery: Completed baseline and care transformation projections across all settings that should have taken a few years to complete within one year. The Framework That Changed Everything Our Long-Term Capacity Planning Framework now seamlessly connects: • Demand drivers (population aging, functional impairment) • Care settings (from acute to community to home-based care) • Resource planning (manpower, infrastructure, budget) Policy interventions like HSG, right-siting efforts, and palliative care strategies are incorporated. Key Lessons Learned 1. Coordination is as important as methodology - The CPC structure solved more problems than technical improvements alone 2. Resilience matters - When our HSG model wasn’t endorsed initially, we went back to fundamentals and rebuilt stakeholder confidence 3. Granular parameters drive better insights - Moving from broad assumptions to specific factors like family support levels improved accuracy The result? A coherent planning system that helps Singapore prepare for demographic transitions while optimising resource allocation across the entire healthcare continuum. What challenges are you facing in system-wide planning and coordination across multiple stakeholders?

The Fab Whisperer: Capacity Planning - From Spreadsheets to Self-Learning Models. Last week we looked at the widening gap between silicon demand and fab capacity — the classic setup for another boom-and-bust cycle. Imbalance is inherent in the market. We try to balance it in the way we plan capacity. For an industry that spends hundreds of billions on CAPEX, capacity planning should be science. Yet it often I see frozen spreadsheets, heroic assumptions, and “best-guess” throughput models that quietly drift from reality. Are we building fabs based on models that no longer represent how fabs actually run? Using the wrong model for the wrong purpose? CAPEX Planning ≠ Fab Daily Operations Planning Capacity — deciding what, when, and where to build. Running Capacity — managing flow, bottlenecks, and daily WIP. CAPEX models are strategic: they test economics, demand scenarios, and sensitivity to capacity detractors. Operational models are tactical: they simulate variability, queueing, and dispatch logic. When fabs try to use the same model for both, they end up with bad investments and bad daily decisions. It’s like using a telescope to check your pulse. Most Common Methods of How We Plan Capacity 1. Static Models (Spreadsheet Economics) Quick and transparent — perfect for early CAPEX justifications. But fixed throughput and yield assumptions age fast. Once products, recipes, or WPH shift, the model collapses. 2. Dynamic Simulations (Discrete-Event or Digital Twins based) Capture queues, PM downtime, and rework loops — essential for operational decision-making. Great for optimizing how to run a fab, not what to build next. Powerful but maintenance-heavy; too often abandoned after the big study. The Next Frontier Not mainstream yet but they point to the future: AI-Driven and Hybrid Models. These models will learn from real time fab data, adapt to product mix, and continuously recalibrate effective capacity. They will bridge the gap between planning and operations — a single living model that never goes stale. The barrier isn’t technology — it’s data discipline and trust. The Real Challenge The biggest risk isn’t model complexity — it’s model decay. Assumptions age. Routings evolve. PM cycles shift. By the time the next CAPEX round starts, you’re planning the future based on a fab that no longer exists. What can we do meanwhile Match the model type to the decision horizon. CAPEX → financial sensitivity and long-term. Operations → flow dynamics, variability control, short term. Treat models as living systems, not one-off projects. Assign ownership for keeping assumptions, routings, and rates current. Benchmark quarterly — compare modeled vs. actual effective capacity. Start building the bridge: integrate AI and fab data into planning cycles today. Are your capacity models describing reality — or nostalgia? #TheFabWhisperer #Semiconductor #FabOperations #CapacityPlanning #DigitalTwin #AI #ManufacturingExcellence #FabModeling

How a Shared Forging Line Taught Me the Real Cost of Capacity Bottlenecks In one of my Assembly Systems Optimization projects, a shared forging line turned out to be the silent bottleneck — the single factor deciding whether customer orders shipped on time or missed deadlines (and penalty fees). By modeling the system in AMPL, I discovered the root issue wasn’t total capacity — it was how that capacity was allocated across products, shifts, and setup sequences. Once we aligned our plan with realistic capacity profiles, late delivery penalties dropped by around 15%. Here’s what changed: -Treated the forging line as a true constraint, not an infinite resource — accounting for available hours, setup times, and batch logic. -Used the model to flag high-risk orders early, adjusting start dates or routings before the floor felt the pressure. -Smoothed the mix on the shared line by staggering complex jobs and grouping similar parts, cutting unnecessary changeovers and freeing up capacity for urgent builds. The big takeaway: Capacity planning isn’t about adding machines or extra shifts. It’s about orchestrating plans, product mix, and constraint behavior so every critical hour on the shop floor drives on-time delivery — not bottlenecks. #CapacityPlanning #ProductionPlanning #Manufacturing #OperationsResearch #SupplyChainExcellence

Because capacity is a silent killer of growth and profits... This infographic shows 10 capacity calculations that every supply planner should master... ✅ 1️⃣ Gross Capacity Requirement 👉 Concept: calculates the total capacity required to meet production goals without considering any constraints or limitations 🧮 Calculation: Planned Production Quantity X Standard Hours per Unit ✅ 2️⃣ Net Capacity Requirement 👉 Concept: takes the gross capacity requirement and adjusts it for factors including scrap, rework, and inefficiencies 🧮 Calculation: Gross Capacity Requirement – Expected Losses ✅ 3️⃣ Resource Load 👉 Concept: estimates the workload on a specific resource to see if it’s doable with the current capacity 🧮 Calculation: Load = Required Hours / Available Hours ✅ 4️⃣ Load Capacity Ratio 👉 Concept: compares total demand to available capacity, useful for identifying potential bottlenecks 🧮 Calculation: (Total Load / Available Capacity) X 100 ✅ 5️⃣ Utilization Percentage 👉 Concept: indicates how much of the available capacity is planned to be used, helpful for balancing workloads 🧮 Calculation: (Capacity Used / Available Capacity) X 100 ✅ 6️⃣ Standard Time Variance 👉 Concept: measures how much actual production time differs from the expected (standard) production time. 🧮 Calculation: Standard Time Variance= Actual Time – Standard Time ✅ 7️⃣ Capacity Adjustment Factor 👉 Concept: adjusts for factors such as seasonal variations or planned downtime 🧮 Calculation: Available Capacity X Capacity Adjustment Factor ✅ 8️⃣ Capacity Gap 👉 Concept: shows the difference between required and available capacity, indicating if adjustments are needed 🧮 Calculation: Net Capacity Requirement – Available Capacity ✅ 9️⃣ Production Rate 👉 Concept: calculates units produced per hour to compare against standard rates to assess feasibility 🧮 Calculation: Planned Units / Planned Hours ✅ 1️⃣0️⃣ Capacity Cushion for Rough Cut Capacity 👉 Concept: provides a buffer, ensuring capacity can handle variability or unanticipated demand 🧮 Calculation: [(Available Capacity – Required Capacity) / Available Capacity] X 100 Any others to add?

State-of-the-art indigenously developed Resource adequacy model (STELLAR) launched by Central Electricity Authority A Useful tool for all Discoms and load Despatchers An indigenously developed Integrated Generation, Transmission, and Storage Expansion Planning Model with Demand Response—a vital Resource Adequacy Tool—was launched on 11.04.2025 by Shri Ghanshyam Prasad, Chairperson, Central Electricity Authority (CEA), in the presence of Sh. Alok Kumar, Ex-Secretary (Power) and partner TLG, and various representatives from the State Power Utilities. It is planned to distribute this software model to all the States/ Discoms free of cost. The indigenously developed tool is specifically designed to assist the states in carrying out a comprehensive Resource Adequacy plan in line with the resource adequacy guidelines issued by the Ministry of Power in June 2023. After the issuance of the Resource Adequacy Guidelines, CEA has been carrying out the Resource Adequacy (RA) plans for all the Discoms. To begin with, CEA completed the exercise for all Discoms up to 2032, and now all of them have been updated to 2034-35. CEA has also finished the national-level exercise up to 2034-35. Since the plan is dynamic and is mandated to be revised every year, it was thought to develop a common tool for all and share it with them free of cost to play with it. It will also help integrate the studies easily and bring out the optimum solutions for the country. The model explicitly considers: Chronological operation of the power system All unit commitment constraints, including technical minimum, minimum up and down times, and ramp-up/ramp-down rates. Endogenous demand response Ancillary services, and many more. The benefits of the tool include: Ensuring adequate resource adequacy (neither less nor more) in the electricity grid. Zero load shedding, No stressed capacity and least cost solutions. Optimisation of the cost of power system generation expansion and system operation while considering the benefit of demand response. Optimisation of energy and ancillary services. Optimisation of size and location of storage. The software has been developed entirely in India with the active guidance of CEA, ensuring complete transparency. CEA will update and upgrade this tool based on further suggestions from users (Discoms/ load despatchers) of this software. The launch event highlighted the collaboration between CEA, The Lantau Group (TLG) and the Asian Development Bank (ADB) under the Technical Assistance program. #EnergyTransition #PowerOptimisation BloombergNEF United Nations Climate Technology Centre & Network (CTCN), MoEF&CC, ASSOCHAM (The Associated Chambers of Commerce and Industry of India) Rangan Banerjee Ministry of New and Renewable Energy (MNRE) Centre for Energy Regulation (CER)

Three Types of Capacity in Manufacturing 1. Design Capacity * Maximum theoretical output the machine or process is engineered to deliver * Assumes ideal operating conditions at all times * No breakdowns, maintenance, setups, or quality losses * Demand and material availability are assumed to be unlimited * Used mainly for equipment selection, layout design, and long term investment decisions 2. Effective Capacity * Maximum output that can be realistically planned and committed * Considers all known and expected constraints at planning time * Includes technical, commercial, and supply related limitations * Used for production planning, order acceptance, and capacity loading Assumptions and considerations * Planned maintenance and setups * Breaks and standard operating policies * Product mix and changeovers * Known no order periods * Planned material availability constraints 3. Actual Capacity * Output actually achieved during execution * Reflects how well the system performs in reality * Includes both planned and unplanned losses * Used to evaluate operational performance Assumptions and considerations * Machine breakdowns and minor stoppages * Scrap, rework, and yield losses * Operator performance variation * Unplanned material or utility interruptions