Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainManufacturing & OperationsProduction Capacity Planner

SpreadsheetManufacturing & OperationsFree

Production Capacity Planner

Compare required hours with effective capacity for every work centre, using efficiency and OEE, and find the bottleneck.

Shown with sample data

Colour

Production Capacity Planner

Compare required hours with effective capacity for every work centre, using efficiency and OEE, and find the bottleneck.

Effective capacity
4,399
Hours this period
Required hours
2,414.5
Over capacity
1
Work centres
Bottleneck
Paint booth
Highest utilisation
Utilisation by work centre
  • CNC machining91.5%
  • Injection moulding54%
  • Press-fit cell15.3%
  • Assembly line 375%
  • Leak test16.6%
  • Paint booth106.8%
  • Packing55.3%
Required vs effective hours
  • CNC machining769
  • Injection moulding744
  • Press-fit cell74
  • Assembly line 3173
  • Leak test90
  • Paint booth113
  • Packing451.5

How to use it

  1. 1On Work centres, enter machines, shifts per day, hours per shift and working days in the period.
  2. 2Set efficiency (labour and scheduling losses) and OEE for each work centre from your own data.
  3. 3On Demand, list each product operation with units required, cycle minutes per unit and set-up hours.
  4. 4Read utilisation: over 100% means the demand cannot be made in the period without changes.
  5. 5Act on the bottleneck first: extra time there adds output to the whole plant; elsewhere it does not.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Can the plant make what sales has promised? List each work centre with machines, shifts, hours, days, efficiency and OEE to get effective capacity hours, then list the demand by product and operation with cycle times and set-ups. The planner loads every work centre, shows utilisation and spare hours, flags anything over capacity or tight and names the bottleneck, so you can add a shift, outsource or re-sequence before orders go late.

Who it’s for

  • Rough-cut capacity planning for next month or quarter
  • Checking if a big order fits
  • Deciding on overtime, extra shifts or new equipment
  • S&OP meetings

What’s included

  • Work centres sheet: Capacity, load and utilisation for each work centre.
  • Demand sheet: Required hours by product and operation.

How to use it

  1. 1On Work centres, enter machines, shifts per day, hours per shift and working days in the period.
  2. 2Set efficiency (labour and scheduling losses) and OEE for each work centre from your own data.
  3. 3On Demand, list each product operation with units required, cycle minutes per unit and set-up hours.
  4. 4Read utilisation: over 100% means the demand cannot be made in the period without changes.
  5. 5Act on the bottleneck first: extra time there adds output to the whole plant; elsewhere it does not.

Tips

  • Plan to about 85% utilisation. Above that, small disruptions turn into late orders.
  • Use real OEE from your OEE tracking, not the nameplate rate. World-class OEE is about 85%; many plants run at 55–65%.
  • Cycle time should be per unit per machine; if a part runs on two machines at once, halve the cycle time or count both machines.

Questions

How is effective capacity calculated?

Available hours (machines × shifts × hours per shift × days) × efficiency × OEE. It is the productive time you can realistically expect.

What is a bottleneck?

The resource with the highest utilisation. It limits the output of the whole system, so improvements there matter most (Theory of Constraints).

Is this finite scheduling?

No. It is rough-cut capacity planning for a period. Use a production schedule to sequence individual orders by day and shift.

Related searchesproduction capacity planningcapacity planner excelrough cut capacity planningmachine capacity calculationbottleneck analysiscapacity utilization

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
30 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetManufacturing & OperationsFree

Production Capacity Planner

Compare required hours with effective capacity for every work centre, using efficiency and OEE, and find the bottleneck.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
30 min
Level
Intermediate
Price
Free

Your copy is private to you.

More manufacturing & operations templates

View all
Equipment Maintenance Log3 sheets

Overdue

1

Due in 14 days

3

Maintenance spend

$2,875

ABCD
1EquipmentLocationTypeInterval (days)
2Commercial espresso machineFront counterKitchen90
3Walk-in fridgeKitchenRefrigeration180
4DishwasherKitchenKitchen120
5HVAC unitRoofBuilding180
Assets
SpreadsheetManufacturing & Operations

Equipment Maintenance Log

Preventive maintenance due dates from each asset's service history, with overdue alerts, repair and downtime tracking, and maintenance cost by asset and month.

10 min setupPreview
Weekly Production Schedule3 sheets

Attainment

100%

Yield

99%

Downtime

160

ABCD
1DateLineOrder #Product
2Nov 5Line 1MO-871Sourdough loaf 800g
3Nov 5Line 2MO-872Granola bar 40g
4Nov 5Line 3MO-873Oat cookies 12pk
5Nov 6Line 1MO-874Seeded rolls 6pk
Schedule
SpreadsheetManufacturing & Operations

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

10 min setupPreview
OEE Calculator2 sheets

Average OEE

79%

Availability

90%

Performance

90%

ABCD
1DateLineShiftPlanned minutes
2Nov 3Line 1Day450
3Nov 3Line 1Night450
4Nov 3Line 2Day450
5Nov 3Line 2Night450
Shifts
SpreadsheetManufacturing & Operations

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ