Resource Capacity Planner Calculator

Enter Planning Inputs

This page uses a single-column page flow. The calculator fields below adjust to three columns on large screens, two on medium screens, and one on mobile.

Available Resources

Working Days In Planning Period

Shifts Per Day

Hours Per Shift

Break Minutes Per Shift

Planned Downtime Hours

Setup / Changeover Hours

Attendance Rate %

Efficiency / OEE Factor %

Total Overtime Hours

Demand Units

Standard Cycle Time Per Unit (Minutes)

Expected Scrap Rate %

Capacity Buffer %

Target Utilization %

Example Data Table

The example below reflects a typical monthly manufacturing planning scenario and shows how the calculator converts availability, losses, and demand into a staffing decision.

Example Metric	Sample Value	Explanation
Available Resources	12	Operators or machines included in the plan.
Working Days	22	Total production days in the planning period.
Shifts Per Day	2	Two production shifts operate every day.
Hours Per Shift	8	Standard shift duration before deductions.
Break Minutes Per Shift	30	Break time removed from gross availability.
Planned Downtime + Setup	42 hours	Includes maintenance, cleaning, and changeovers.
Attendance / Efficiency	96% / 87%	Realistic execution factors applied to scheduled hours.
Demand / Cycle Time	32,000 units / 6.5 minutes	Demand converted into required production hours.
Utilization Result	113.80%	The line is overloaded under these assumptions.
Extra Resources Needed	2	Additional resources required to recover the shortfall.

Formula Used

1) Gross Scheduled Hours

Gross Scheduled Hours = Resources × Working Days × Shifts Per Day × Hours Per Shift

2) Break Loss Hours

Break Loss Hours = Resources × Working Days × Shifts Per Day × (Break Minutes ÷ 60)

3) Net Scheduled Hours

Net Scheduled Hours = Gross Scheduled Hours − Break Loss Hours + Overtime Hours

4) Effective Capacity Hours

Effective Capacity Hours = (Net Scheduled Hours − Planned Downtime − Setup Hours) × Attendance Factor × Efficiency Factor × (1 − Buffer Rate)

5) Adjusted Demand Units

Adjusted Demand Units = Demand Units ÷ (1 − Scrap Rate)

6) Required Production Hours

Required Production Hours = Adjusted Demand Units × Cycle Time ÷ 60

7) Planned Utilization

Planned Utilization % = Required Production Hours ÷ Effective Capacity Hours × 100

8) Required Resources

Required Resources = Required Production Hours ÷ Effective Hours Per Resource

These formulas help planners combine calendar time, losses, execution performance, and demand into one operational view. They are useful for monthly planning, rough-cut capacity planning, and shift-level staffing studies.

How To Use This Calculator

Enter the number of resources that can produce within the selected period.
Add calendar details such as working days, shifts, shift hours, and break minutes.
Enter expected losses from planned downtime, setup time, absenteeism, and efficiency gaps.
Provide demand units, standard cycle time, scrap rate, and desired capacity buffer.
Click Calculate Capacity to show results above the form.
Review utilization, gap hours, gap units, and required resources.
Use the chart to compare available capacity against required demand visually.
Export the results as CSV or PDF for scheduling meetings, planning reviews, or management reporting.

FAQs

1. What does this resource capacity planner measure?

It estimates how much effective manufacturing capacity you actually have after breaks, downtime, setup, attendance losses, efficiency losses, and planning buffers. It then compares that capacity with required production hours and required units.

2. Why is scrap rate included in the model?

Scrap increases the number of units you must start to finish the required good output. Including scrap gives a more realistic demand load and prevents underestimating required hours.

3. What is the difference between efficiency and attendance?

Attendance reflects how much labor or machine presence is actually available. Efficiency reflects how well scheduled time converts into productive output. Both reduce practical capacity, but they represent different causes of loss.

4. When should I use a capacity buffer?

Use a buffer when demand is variable, downtime risk is uncertain, suppliers are unstable, or customer service levels are strict. A buffer protects the plan from small disruptions that can create missed shipments.

5. What does utilization above 100% mean?

It means the required production hours are greater than effective capacity hours. The plan cannot be achieved as entered unless you add resources, extend time, raise efficiency, reduce scrap, or lower demand.

6. Can this calculator be used for machines instead of people?

Yes. A resource can represent a machine, production cell, team, or operator group. The calculator works as long as cycle time and available hours are defined consistently.

7. Is this tool suitable for rough-cut capacity planning?

Yes. It is especially useful for rough-cut planning, monthly reviews, weekly staffing checks, and scenario comparison. It gives a fast decision view before detailed line balancing or finite scheduling begins.

8. Which inputs have the biggest effect on the result?

Cycle time, efficiency, attendance, scrap rate, and available resource hours usually move the result most. Small changes in these inputs can significantly change utilization, shortfall, and staffing needs.