Capacity Simulation Data Checklist for Manufacturers

Capacity Simulation Data Checklist for Manufacturers: Inputs, Sources and Validation

Capacity simulation data determines whether a manufacturing model becomes a useful decision-support tool or an attractive but unreliable representation of the factory. The model must reflect actual demand, product routings, processing times, equipment availability, labour constraints, buffers and production-control rules.

Manufacturers do not always need perfectly automated data collection before beginning a simulation project. However, every important input should have a defined source, unit, time period, owner, confidence level and validation method.

This practical checklist explains the information required for capacity and bottleneck simulation, where it can be collected and how manufacturers can validate it before evaluating improvement or investment scenarios.

Quick answer: Capacity simulation data normally includes demand, product mix, routings, cycle times, setup times, shift calendars, equipment downtime, labour availability, buffers, scrap, rework, material movement and scheduling rules. The required detail depends on the decision being studied. Every model should be validated against observed factory performance before future scenarios are compared.

Table of Contents

What Is Capacity Simulation Data?

Capacity simulation data is the structured operational information used to represent how products, machines, people, materials and production rules interact over time.

Unlike a static capacity spreadsheet, a dynamic simulation may need to represent:

  • Different products following different routes
  • Variation in processing and setup times
  • Breakdowns and repair durations
  • Shared operators, tools and fixtures
  • Limited buffer and storage capacity
  • Shift calendars, breaks and overtime
  • Scrap, rework and inspection holds
  • Material-handling delays
  • Production sequencing and priority rules

The objective is not to collect every available data point. The objective is to collect the data required to answer the defined business question with an appropriate level of confidence.

For example, a study evaluating whether one machine can support next year’s demand may require less detail than a study comparing several layouts, shift patterns, product mixes and material-handling strategies.

Start With the Decision, Not the Dataset

Before requesting files from every department, define the decision the simulation must support.

Typical questions include:

  • Can the current line meet forecast demand?
  • Which work centre limits accepted production output?
  • Will another machine increase total throughput?
  • Can demand be met by changing labour or shift patterns?
  • What buffer capacity is required before the constraint?
  • How will a new product affect existing production?
  • Where will the bottleneck move after an improvement?
  • Which factory layout provides the most reliable flow?

A clearly defined question determines the model boundary, data granularity, scenarios and performance measures. It also prevents the project from becoming an uncontrolled data-collection exercise.

Manufacturers planning equipment investment should also review manufacturing debottlenecking scenarios to test before CAPEX.

Minimum Data Required for Capacity Simulation

A preliminary manufacturing capacity model normally requires the following minimum inputs:

  1. Demand or production-order information
  2. Product-to-process routings
  3. Processing or cycle times
  4. Setup and changeover times
  5. Machine and work-centre calendars
  6. Equipment downtime or availability
  7. Operator requirements and shift availability
  8. Buffer or intermediate storage capacity
  9. Scrap, rework and quality-control rules
  10. Production sequencing and dispatching rules

Additional inputs may be needed when the study includes material handling, maintenance, tooling, utilities, warehousing or complex production-control logic.

Complete Capacity Simulation Data Checklist

Data Category Required Information Possible Source Validation Method
Demand Order quantity, product, required date, priority and forecast period ERP, planning system, sales forecast Reconcile with released orders and historical shipments
Product mix Volume or order share by product family ERP, MES, production reports Compare representative periods and future forecasts
Routing Operation sequence, work centre and alternate route ERP routing master, process sheet Review with production and process engineering
Cycle time Processing time by product and operation MES, PLC, time study, machine records Compare system records with shop-floor observations
Setup time Changeover duration by product transition or family MES, setup sheets, manual logs Observe representative changeovers
Equipment calendar Working shifts, breaks, planned stops and holidays Shift roster, planning calendar Confirm with production management
Downtime Failure frequency, duration, reason and planned maintenance CMMS, MES, Andon or maintenance logs Reconcile events with production loss records
Labour Operators by shift, skills, assignments and shared responsibilities Rosters, skill matrix, supervisor interviews Observe actual resource allocation
Buffers and WIP Location, capacity, current level and replenishment rule MES, WIP reports, physical observation Count inventory at representative times
Quality Inspection time, scrap rate, rework route and hold rules QMS, inspection records, MES Compare with approved quality reports
Material handling Travel time, batch quantity, equipment and dispatch rule Warehouse system, route study, observation Measure representative movements
Production rules Sequencing, priority, batch, release and allocation rules Planning procedures, interviews, schedule history Review actual decisions with planners and supervisors

1. Demand and Product-Mix Data

Demand defines what the simulated factory is expected to produce. A single monthly quantity may be insufficient when products have different cycle times, routings or due dates.

Collect demand at the lowest useful level, such as:

  • Production order or schedule line
  • Product or part number
  • Product family
  • Required quantity
  • Release date
  • Required completion date
  • Customer or priority class where relevant
  • Normal, peak and future-demand scenarios

Historical production quantities should not automatically be treated as demand. Historical output may have been restricted by capacity shortages, material unavailability or quality problems. Separate what customers required from what the factory actually completed.

2. Process Routing Data

Routing data describes the sequence of operations required to manufacture each product. It connects demand with machines, labour and supporting resources.

For each product or family, record:

  • Operation number
  • Operation description
  • Primary work centre or machine group
  • Alternate work centre
  • Processing time basis
  • Setup family
  • Required operator skill
  • Required tool, fixture or gauge
  • Batch or transfer quantity
  • Inspection and rework route

ERP routings should be checked with process engineers and shop-floor personnel. The official routing may not include temporary alternate machines, inspection loops or actual material movements used during daily production.

3. Cycle-Time Data

Cycle time is one of the most influential capacity simulation data inputs. It is also one of the most frequently misunderstood.

Before collecting values, define what the recorded time includes:

  • Automatic machine processing
  • Manual loading and unloading
  • Operator walking and preparation
  • In-cycle inspection
  • Tool adjustment
  • Minor recurring delays
  • Batch processing

Do not mix processing time, takt time, lead time and total order duration in the same field. Each measure represents a different aspect of production.

Should the model use an average cycle time?

An average may be suitable for an early screening model when variation is small and does not materially affect the decision. When cycle-time variation creates queues, starvation or missed output, use an appropriate range or probability distribution based on cleaned observations.

Always retain:

  • Number of observations
  • Minimum and maximum values
  • Median and selected percentiles
  • Average and standard deviation where appropriate
  • Product and machine identifiers
  • Observation dates and shifts
  • Reasons for excluded records

For a static starting calculation, see how to calculate production capacity using machine, labour and shift data.

4. Setup and Changeover Data

Setup losses become important when a work centre produces many products or small batches. A single average setup time can hide large differences between product transitions.

Where possible, create a changeover matrix showing the time required to move from one product family to another.

Separate setup activities into:

  • Machine stopping and cleaning
  • Tool or fixture removal
  • Installation and alignment
  • Program or parameter loading
  • Material preparation
  • First-piece production
  • Inspection and approval

This separation helps evaluate whether external preparation, sequencing or standardised setup methods could recover capacity.

5. Shift and Production Calendar Data

A calendar should represent the time when each resource can genuinely operate. Do not simply multiply the number of shifts by eight hours.

Include:

  • Shift start and end time
  • Meal and tea breaks
  • Staggered break coverage
  • Shift handover
  • Daily meetings
  • Planned cleaning
  • Preventive maintenance
  • Weekly offs and holidays
  • Planned overtime
  • Resource-specific calendars

Machine, operator, inspection and maintenance calendars may differ. A machine cannot produce merely because its calendar is open if the required operator or quality inspector is unavailable.

6. Downtime and Reliability Data

Capacity models should distinguish planned and unplanned losses.

Planned events

  • Preventive maintenance
  • Calibration
  • Cleaning
  • Tool replacement
  • Planned utility shutdown

Unplanned events

  • Mechanical failure
  • Electrical or control failure
  • Tool or fixture failure
  • Minor stops
  • Material shortage
  • Quality hold
  • Operator unavailability

For each event, capture the start time, end time, duration, affected resource, reason code and corrective action where available.

MTBF and MTTR can be useful summaries, but they should be calculated from consistent event definitions. A large number of short interruptions may affect production differently from one long breakdown, even when total downtime is similar.

7. Labour and Skill Data

Machine capacity and labour capacity should not be treated as independent when an operator performs loading, inspection, movement or supervision across multiple resources.

Collect:

  • Number of operators by shift
  • Skill or certification matrix
  • Machine-to-operator assignment
  • Shared operator responsibilities
  • Manual task duration
  • Break and relief arrangements
  • Absence assumptions
  • Maximum safe resource coverage

Use actual assignment rules rather than assuming that any available operator can work at any station.

8. Buffer and Work-in-Progress Data

Buffers influence blocking, starvation, lead time and throughput. The model should represent physical and policy limitations.

For each buffer, record:

  • Location
  • Maximum physical capacity
  • Normal operating quantity
  • Minimum replenishment level
  • Container or pallet quantity
  • FIFO, priority or product-separation rule
  • Traceability restrictions
  • Material release conditions

A buffer is not automatically beneficial. Read how buffer capacity and WIP affect manufacturing throughput.

9. Quality, Scrap and Rework Data

Capacity should be measured using accepted production output. Therefore, the model may need to include:

  • Inspection frequency
  • Inspection and testing duration
  • Sampling plan
  • First-piece approval
  • Scrap probability
  • Rework probability
  • Rework routing
  • Quality hold duration
  • Required inspector or laboratory resource

Do not subtract one overall scrap percentage from final production if failures occur at different stages. Early and late rejection can consume very different amounts of capacity.

10. Material-Handling Data

Material movement can become a hidden constraint when production areas depend on forklifts, trolleys, cranes, conveyors or automated guided vehicles.

Collect:

  • Pickup and delivery locations
  • Travel distance and time
  • Loading and unloading time
  • Transport batch quantity
  • Material-handling equipment availability
  • Priority and dispatch rule
  • Charging, refuelling or maintenance calendar
  • Traffic and route restrictions

11. Production-Control and Operational Rules

Two factories with identical machines and cycle times can perform differently because their operating rules differ.

Document how the factory decides:

  • Which job is processed next
  • When orders are released
  • How urgent orders receive priority
  • When batches move to the next operation
  • Which alternate machine is selected
  • How operators are assigned
  • How blocked or failed machines are bypassed
  • When maintenance is permitted
  • How shortages and quality holds are handled

Some rules may not exist in a written procedure. They may be applied through planner, supervisor or operator experience. Interview the people making these decisions and compare their explanations with historical schedules and production events.

Where Can Manufacturers Collect Capacity Simulation Data?

System or Source Useful Data Important Caution
ERP Orders, forecasts, routings, bills of material and planned times Planned values may differ from actual shop-floor performance
MES Order progress, production quantities, cycle events, WIP and downtime Check event definitions, missing scans and manual overrides
PLC or SCADA Machine states, cycles, alarms and process events Raw signals may need contextualisation before analysis
CMMS Failures, repair time, maintenance plans and spare-part events Work-order duration may not equal actual machine downtime
QMS Inspection, rejection, rework, hold and approval records Connect quality events to products and production stages
Spreadsheets Manual schedules, shift reports and local production records Control versions, units, formulas and manual-entry errors
Time study Manual tasks, movement, cycle variation and setup elements Collect representative observations without disrupting work
Interviews Unwritten rules, exceptions and actual decision logic Validate opinions against records and observations
Shop-floor observation Queues, blocking, starvation, operator movement and actual practices Select representative shifts, products and operating conditions

How to Clean Capacity Simulation Data

Raw production records should not be loaded directly into a model without review. Use a documented cleaning process.

Standardise definitions

Agree on definitions for cycle start, cycle completion, downtime, setup, scrap, rework and accepted output.

Standardise units

Convert time, quantities and distances into consistent units. Clearly distinguish seconds, minutes and hours, as well as pieces, batches, pallets and kilograms.

Remove duplicates carefully

Repeated transaction records may be genuine events or duplicate system messages. Review identifiers and timestamps before deletion.

Identify missing records

Check for missing shifts, machines, products and time periods. Do not assume that an absent downtime event means the machine operated continuously.

Review outliers

Extreme values may represent errors, breakdowns, quality problems or genuine operating conditions. Investigate them before deciding whether to exclude or model them.

Align timestamps

Different systems may use different clocks, formats or time zones. Align timestamps before connecting machine, order, maintenance and quality events.

Preserve raw data

Keep an unchanged source copy. Store cleaning rules and exclusions separately so the prepared dataset can be traced back to its origin.

What Should You Do When Capacity Simulation Data Is Missing?

Missing data does not always prevent a simulation project, but it must be handled transparently.

Use the following hierarchy:

  1. Retrieve data from an alternative approved system.
  2. Conduct a targeted time study or physical observation.
  3. Interview process owners and verify the answer with available records.
  4. Use an engineering estimate with a documented basis.
  5. Test a range of plausible values through sensitivity analysis.

Maintain an assumptions register containing:

  • Input name
  • Assumed value or range
  • Reason the actual data is unavailable
  • Responsible owner
  • Confidence level
  • Potential effect on the decision
  • Planned validation action

A model should not display false precision. When an uncertain input materially changes the preferred scenario, collect better data before making the final decision.

How Much Historical Data Is Required?

There is no universal number of days or months suitable for every simulation project. The period should cover the conditions that affect the decision.

A representative dataset may need to include:

  • Normal and peak demand
  • Important product-mix variations
  • Different shifts and crews
  • Typical changeovers
  • Planned and unplanned downtime
  • Material shortages
  • Quality and rework events
  • Seasonal or customer-specific patterns

A long dataset is not automatically better. Old records may represent different machines, products, staffing or operating rules. Select relevant data and document the period used.

How to Validate Capacity Simulation Data and the Baseline Model

Validation asks whether the model represents the real system closely enough for its intended decision. It should involve both numerical comparison and operational review.

Step 1: Validate each important input

Confirm the value, unit, period, source and owner. Use more than one source for critical inputs where practical.

Step 2: Conduct face validation

Review the model logic and animation with planners, operators, supervisors, maintenance, quality and process engineers. Confirm that products and resources behave as expected.

Step 3: Compare model output with factory output

Run the model under known historical conditions and compare:

  • Accepted production output
  • Throughput by product family
  • Work-in-progress by area
  • Queue development
  • Lead time
  • Equipment utilisation
  • Blocked and starved time
  • Constraint location
  • Changeover frequency
  • Downtime behaviour

Step 4: Investigate differences

A mismatch does not automatically mean that the model is wrong. The historical report may use different definitions or contain missing records. Investigate discrepancies jointly.

Step 5: Agree on acceptance criteria

Define acceptable comparison measures and tolerances according to the purpose of the model. A screening model and an investment-grade study may require different validation depth.

Step 6: Freeze the validated baseline

Record the model version, dataset, assumptions and approval. Compare future scenarios against the same baseline unless an intentional change is documented.

Validated data is particularly important in discrete event simulation for manufacturing bottleneck analysis.

Recommended Capacity Simulation Data Workbook

A structured workbook can simplify collection when information comes from several systems and departments.

Recommended tabs include:

  1. Project Scope: decision question, boundary, scenarios and KPIs
  2. Demand: orders, product mix, quantities and dates
  3. Products: product families and attributes
  4. Routings: operation sequence and work centres
  5. Resources: machines, capacities and calendars
  6. Cycle Times: product-operation processing times
  7. Setups: changeover times and setup matrix
  8. Downtime: failures, repair duration and planned maintenance
  9. Labour: people, skills, shifts and assignments
  10. Buffers: locations, capacities and control rules
  11. Quality: inspection, scrap, holds and rework
  12. Material Handling: routes, travel times and transport resources
  13. Operating Rules: sequencing, priority and release logic
  14. Assumptions: missing data, estimates and confidence
  15. Validation: actual-versus-model comparisons and approvals

Each input table should include a source, owner, last-updated date and unit of measurement.

Capacity Simulation Data for Manufacturers in India and Chennai

Manufacturers in India may operate a combination of modern connected equipment, standalone legacy machines and manual production processes. This means capacity simulation data may need to be assembled from both digital and physical sources.

For automotive, precision engineering, electronics and industrial plants in Chennai, Ambattur, Oragadam and Sriperumbudur, common data challenges include:

  • Cycle information divided across ERP, machine counters and spreadsheets
  • Manual downtime and rejection records
  • Different practices across shifts
  • Shared skilled operators and quality inspectors
  • Unrecorded alternate routings
  • Customer-specific schedules and priorities
  • Subcontracted operations
  • Variable supplier and material lead times
  • Mixed production units and naming conventions

A practical study can begin with the data currently available, provided limitations are documented and critical assumptions are validated through targeted observations.

For location-specific planning, learn more about industrial simulation services in India.

Common Capacity Simulation Data Mistakes

  • Starting data collection before defining the decision question
  • Using planned ERP times as actual cycle times without validation
  • Using only average values when variation drives congestion
  • Ignoring setup and product-transition differences
  • Treating every operator as interchangeable
  • Combining planned and unplanned downtime
  • Ignoring scrap, rework and quality holds
  • Using historical production output as customer demand
  • Failing to document operational rules
  • Deleting outliers without investigating their cause
  • Using data from an unrepresentative time period
  • Running future scenarios before validating the baseline

Final Capacity Simulation Data Readiness Checklist

  • The business question and model boundary are documented.
  • Demand is available by relevant product or product family.
  • Actual routings and alternate routings are confirmed.
  • Cycle-time definitions and units are consistent.
  • Setup times reflect important product transitions.
  • Machine, operator and quality calendars are included.
  • Planned and unplanned downtime are separated.
  • Labour skills and shared assignments are represented.
  • Buffers and WIP rules reflect physical limits.
  • Scrap, rework and inspection requirements are included.
  • Material-handling resources are included where relevant.
  • Sequencing, priority and release rules are documented.
  • Missing data and assumptions have named owners.
  • Raw and cleaned datasets are traceable.
  • The baseline model has been compared with actual factory results.

Frequently Asked Questions

What data is required for manufacturing capacity simulation?

Typical inputs include demand, product routings, cycle times, changeovers, calendars, downtime, labour, buffers, scrap, rework, material movement and production-control rules.

Can capacity simulation be completed without MES data?

Yes. Data can be assembled from ERP, machine records, CMMS, spreadsheets, time studies, interviews and shop-floor observations. Important limitations and assumptions should be documented.

Can ERP standard cycle times be used?

They can provide a starting point, but they should be compared with actual operating records and observations before being used for an important decision.

Should simulation use average cycle times?

An average may be adequate when variation is small and unimportant to the decision. When variability affects queues, utilisation or output, the model should represent that variation appropriately.

How much historical production data is needed?

Use enough relevant data to represent normal and important operating conditions, including product-mix changes, shifts, setups, downtime and quality events. There is no universal fixed period.

How should missing manufacturing data be handled?

Use targeted measurements, alternative approved sources, verified engineering estimates and sensitivity analysis. Record the assumption, owner, confidence level and possible decision impact.

What is the difference between data verification and model validation?

Data verification confirms that inputs are correctly recorded and processed. Model validation determines whether the complete model represents the real factory adequately for the intended decision.

Who should approve the simulation data?

Relevant owners may include production planning, operations, process engineering, maintenance, quality, logistics and finance. Approval responsibility depends on the data and decision scope.

Why are production rules important?

Sequencing, release, priority and resource-allocation rules determine how work moves through the factory. Ignoring them can produce unrealistic queues, utilisation and throughput.

Does more data always create a better simulation model?

No. Data must be relevant, correctly defined and validated. Unnecessary detail can increase development effort without improving the decision.

Build a Reliable Capacity Model With Validated Factory Data

Reliable capacity simulation begins with a defined decision and a controlled data process. The strongest models combine system records, engineering knowledge, shop-floor observation and documented validation.

Tech4LYF helps manufacturers collect and structure capacity simulation data, build validated production models and compare machine, labour, shift, routing and buffer scenarios.

Our capacity and bottleneck simulation services support factory-expansion, debottlenecking and pre-CAPEX decisions for manufacturers in Chennai and across India.

Contact Tech4LYF to discuss your production data, capacity question or simulation project.

References and Further Reading

Trusted By Industry Leaders

Zealeye Logo
Zealeye Logo
Zealeye Logo
Zealeye Logo
Zealeye Logo
Zealeye Logo
Zealeye Logo
Zealeye Logo
Annai Printers Logo
Deejos Logo
DICS Logo
ICICI Bank Logo
IORTA Logo
Panuval Logo
Paradigm Logo
Quicup Logo
SPCET Logo
SRM Logo
Thejo Logo
Trilok Logo
Wingo Logo
Zealeye Logo
Scroll