# Capacity Planning Template for Manufacturing (Excel)

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

## Short answer

An editable capacity planning spreadsheet for work centers. Enter machines, shifts and planned load by week and see available hours, utilization, spare hours and overload flags.

## Category

manufacturing

## Audience

- Production planner
- Plant manager
- Scheduler

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Work center

**Key:** wc

**Type:** text

#### Week

**Key:** week

**Type:** text

#### Machines or stations

**Key:** machines

**Type:** number

#### Hours per shift

**Key:** hrs_shift

**Type:** number

**Unit:** h

#### Shifts per day

**Key:** shifts

**Type:** number

#### Working days

**Key:** days

**Type:** number

#### Efficiency

**Key:** eff

**Type:** number

**Unit:** %

**Help:** Realistic share of scheduled time that is productive

#### Available hours

**Key:** avail

**Type:** number

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

**Format:** number

#### Planned load

**Key:** load

**Type:** number

**Unit:** h

**Help:** Setup plus run hours from planned orders

#### Utilization

**Key:** util

**Type:** number

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

**Format:** percent

#### Spare hours

**Key:** spare

**Type:** number

**Expr:** avail - load

**Format:** number

#### Overload (1 = yes)

**Key:** over

**Type:** number

**Expr:** if(gt(load,avail),1,0)

**Format:** integer

**Rows:**

**Wc:** CNC Mill

**Week:** W45

**Machines:** 4

**Hrs shift:** 8

**Shifts:** 2

**Days:** 5

**Eff:** 80

**Load:** 290

**Wc:** CNC Lathe

**Week:** W45

**Machines:** 3

**Hrs shift:** 8

**Shifts:** 2

**Days:** 5

**Eff:** 82

**Load:** 215

**Wc:** Deburr

**Week:** W45

**Machines:** 2

**Hrs shift:** 8

**Shifts:** 1

**Days:** 5

**Eff:** 90

**Load:** 78

**Wc:** CNC Mill

**Week:** W46

**Machines:** 4

**Hrs shift:** 8

**Shifts:** 2

**Days:** 5

**Eff:** 80

**Load:** 335

**Wc:** CNC Lathe

**Week:** W46

**Machines:** 3

**Hrs shift:** 8

**Shifts:** 2

**Days:** 5

**Eff:** 82

**Load:** 190

**Wc:** Deburr

**Week:** W46

**Machines:** 2

**Hrs shift:** 8

**Shifts:** 1

**Days:** 5

**Eff:** 90

**Load:** 60

**Totals:**

#### Total available hours

**Key:** avail

**Agg:** sum

**Format:** number

#### Total planned load

**Key:** load

**Agg:** sum

**Format:** number

#### Overloaded work center-weeks

**Key:** over

**Agg:** sum

**Format:** integer

**Summary:**

#### Overall utilization

**Key:** overall

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

**Format:** percent

**Primary:** true

#### Net spare hours

**Key:** spare_total

**Expr:** sum_avail - sum_load

**Format:** number

**Notes:** Add one row per work center per week. If a week is a holiday, reduce working days. Treat anything above about 85 to 90 percent utilization as a risk for queue time and late jobs.

## Content

**Intro:** This capacity planning template compares the hours each work center can supply with the hours your planned orders demand, week by week. Edit the sample rows, add your own work centers, and export the result to Excel.

**Sections:**

#### How to use the capacity planning template

**Body:** Create one row per work center per week. Enter the number of machines, hours per shift, shifts per day and working days. Enter an efficiency percentage that reflects real output, not the nameplate. Then enter planned load in hours, which is setup time plus run time from the orders you intend to release. The sheet computes available hours, utilization, spare hours and flags any row where load is above available hours.

**Bullets:**

- Use routing run times, not quote estimates, for load
- Include setup hours, they are real capacity
- Reduce working days for holidays and planned shutdowns
- Review the overload flags first, then the lowest utilization rows

#### The formula behind it

**Body:** Available hours = machines x hours per shift x shifts per day x working days x efficiency. Utilization = planned load divided by available hours. Spare hours = available minus load. This is rough-cut capacity planning: it checks whether the plan fits in total hours, not the exact sequence of jobs. Finite scheduling then decides what runs when. Rough-cut is the right first check because it is fast and shows overloaded work centers before you commit to dates.

#### Reading the result and fixing overloads

**Body:** In the sample, the CNC Mill is at about 91 percent in week 45 and over 100 percent in week 46. That is the signal to act: move work to an earlier week, add overtime or a shift, outsource a few operations, or move work to a different machine. Fix the overload in the plan, not on the shop floor. A work center loaded near 100 percent will have long queues, so keep a buffer for rework and emergency orders.

#### Common mistakes and ERP notes

**Body:** Common errors are using 100 percent efficiency, forgetting setup time, and planning against the machine count on paper instead of machines that are actually running. Most ERPs hold this data as work centers, routings and calendars, and they report load against capacity. Use this template when you do not have that visibility, or to sanity check the ERP's capacity requirements planning output before you trust it.

**Cta:** If your work center, routing and order data sits in an ERP, Netray can add a private AI layer on your own servers that answers questions like which work center is overloaded next month, without exporting data to a spreadsheet.

**Faq:**

#### What efficiency should I enter?

**Answer:** Use a figure based on your own history of actual hours versus scheduled hours. Many shops land between 65 and 85 percent once changeovers, breaks, maintenance and waiting are counted. Start conservative and adjust after a few weeks of measured data.

#### Is this finite or infinite capacity planning?

**Answer:** It is rough-cut, which compares total load with total capacity per period. It shows where the plan does not fit. A finite scheduling tool or ERP scheduling run then sequences the jobs within the available hours.

#### How do I handle several machines with different speeds?

**Answer:** Give each machine type its own work center row, or convert load into standard hours on a common basis. Mixing slow and fast machines in one row hides bottlenecks and distorts utilization.

#### What utilization is too high?

**Answer:** Above roughly 85 to 90 percent, queues grow quickly and lead times lengthen. Plan critical work centers lower, and treat any overload flag as something to resolve before releasing orders.

## Search terms

capacity planning template excel, capacity planning spreadsheet template, manufacturing capacity planning excel template, manufacturing capacity planning template excel free, manufacturing capacity analysis template, capacity planning in excel for manufacturing

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