# Manufacturing Capacity Planning Excel Template (Free, by Work Center)

> Source: https://netray.co/tools/manufacturing-capacity-planning-excel-template
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable capacity plan by work center. Enter machines, shifts, efficiency and load hours; see utilization and overload automatically and export to Excel.

## Category

mes-shop-floor

## Industry

Discrete Manufacturing

## Audience

- Production planner
- Operations manager
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Work center

**Key:** wc

**Type:** text

#### Machines

**Key:** machines

**Type:** number

#### Hours per shift

**Key:** hrs_shift

**Type:** number

**Unit:** h

#### Shifts per day

**Key:** shifts

**Type:** number

#### Working days in period

**Key:** days

**Type:** number

**Unit:** days

#### Efficiency x utilization

**Key:** eff

**Type:** number

**Unit:** %

**Help:** Realistic productive share of scheduled time, after breaks, downtime and changeovers.

#### Available capacity

**Key:** avail

**Type:** number

**Expr:** machines * hrs_shift * shifts * days * eff / 100

**Format:** hours

#### Load (required hours)

**Key:** load

**Type:** number

**Unit:** h

#### Load vs capacity

**Key:** util

**Type:** number

**Expr:** if(gt(avail,0), load / avail * 100, 0)

**Format:** percent

#### Spare (+) / short (-)

**Key:** gap

**Type:** number

**Expr:** avail - load

**Format:** hours

**Rows:**

**Wc:** CNC Mill

**Machines:** 4

**Hrs shift:** 8

**Shifts:** 2

**Days:** 20

**Eff:** 78

**Load:** 220

**Wc:** CNC Lathe

**Machines:** 3

**Hrs shift:** 8

**Shifts:** 2

**Days:** 20

**Eff:** 80

**Load:** 240

**Wc:** Grinding

**Machines:** 2

**Hrs shift:** 8

**Shifts:** 1

**Days:** 20

**Eff:** 82

**Load:** 300

**Wc:** Deburr and finish

**Machines:** 2

**Hrs shift:** 8

**Shifts:** 1

**Days:** 20

**Eff:** 85

**Load:** 190

**Wc:** Final inspection

**Machines:** 1

**Hrs shift:** 8

**Shifts:** 1

**Days:** 20

**Eff:** 90

**Load:** 120

**Totals:**

#### Total available capacity

**Key:** avail

**Agg:** sum

**Format:** hours

#### Total load

**Key:** load

**Agg:** sum

**Format:** hours

#### Net spare or short

**Key:** gap

**Agg:** sum

**Format:** hours

**Summary:**

#### Plant load vs capacity

**Key:** plant_util

**Expr:** if(gt(sum_avail,0), sum_load / sum_avail * 100, 0)

**Format:** percent

**Description:** Total load divided by total available capacity. Check individual work centers too, the bottleneck matters more than the average.

**Primary:** true

**Notes:** Anything above 100 percent in the Load vs capacity column is overloaded: add shifts, outsource, move work to another center or move the due date. Above roughly 85 to 90 percent, queues grow quickly even though the center is not formally overloaded.

## Content

**Intro:** This capacity planning template compares the hours your work centers can deliver with the hours your orders require. Enter machines, shifts and realistic efficiency, add load from your orders, and see which work center is overloaded.

**Sections:**

#### How to use the capacity planning template

**Body:** Choose the planning period, for example a month with 20 working days, and list your work centers. Enter machine count, hours per shift, shifts per day and working days, then an efficiency figure that reflects real productive time. Available capacity is calculated for you. Enter load as the setup plus run hours from open and forecast orders on that work center, taken from your routings. The sheet shows load as a percentage of capacity and the spare or short hours. Edit rows, add work centers, and export to Excel or PDF for the planning meeting.

**Bullets:**

- Use realistic efficiency, not 100 percent.
- Load = setup hours + run time per piece x quantity, from routings.
- Plan the bottleneck work center first.
- Re-run weekly as orders change.

#### The formula behind the sheet

**Body:** Available capacity = machines x hours per shift x shifts x days x efficiency. Load = sum of required hours of all orders in the period. Load versus capacity = load divided by capacity. Rated capacity in many ERP systems uses the same logic: calendar hours times efficiency times utilization. If your efficiency figure is a single number, it should combine planned downtime, changeovers and typical performance loss. Compare it with OEE from the shop floor when you have it.

#### Reading the result and common mistakes

**Body:** A plant average of 75 percent can hide a grinder at 150 percent. Always read by work center. Common errors are using nameplate hours with no efficiency, ignoring setup time, loading from sales forecasts without routings, and forgetting maintenance shutdowns. When a center is overloaded, look at overtime, extra shifts, alternate routings, subcontracting and lot-size changes before moving customer dates. Keep the plan updated so it matches the ERP's finite or infinite load views.

**Cta:** If load and routing data live in your ERP, Netray can add a private AI layer on your own servers that answers 'which work center is overloaded next month' from live data, without sending it outside.

**Faq:**

#### How do you calculate manufacturing capacity?

**Answer:** Multiply machines by hours per shift, shifts per day and working days to get scheduled hours, then apply an efficiency or utilization factor for downtime and changeovers. Compare that to the hours required by the orders.

#### What efficiency should I use?

**Answer:** Use history where you have it, such as OEE or reported versus standard hours. Many discrete job shops plan between 70 and 85 percent. Start conservative and adjust after a few periods of actuals.

#### Is this the same as finite scheduling?

**Answer:** No. This is rough-cut capacity planning by period. Finite scheduling sequences individual jobs by day against capacity. Use this first to see whether the plan is feasible at all.

#### Can I export it to Excel?

**Answer:** Yes. The sheet exports to Excel, CSV or PDF, and the formulas are computed in the export so you can keep working in your own spreadsheet.

## Search terms

manufacturing capacity planning excel template, machine capacity planning excel template free, manufacturing capacity planning template, production capacity planning template, template for capacity planning, capacity planning report template, work center capacity template, capacity vs load excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json