# SyteLine Work Center Capacity and Load Worksheet

> Source: https://netray.co/tools/syteline-work-center-capacity-load-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compare weekly available capacity with planned load by work center and spot overloaded and underused resources.

## Category

syteline

## Erp

Infor SyteLine

## Audience

- Production planner
- Scheduler
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Work center

**Key:** wc

**Type:** text

#### Machines or stations

**Key:** machines

**Type:** number

#### Hours per shift

**Key:** hrs_shift

**Type:** number

**Unit:** hrs

#### Shifts per day

**Key:** shifts

**Type:** number

#### Days per week

**Key:** days

**Type:** number

#### Efficiency

**Key:** eff

**Type:** number

**Unit:** %

#### Planned load

**Key:** load

**Type:** number

**Unit:** hrs

#### Capacity (hrs/wk)

**Key:** cap

**Type:** number

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

**Format:** number

#### Utilization

**Key:** util

**Type:** number

**Expr:** load / (machines * hrs_shift * shifts * days * eff / 100) * 100

**Format:** percent

#### Headroom (hrs)

**Key:** headroom

**Type:** number

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

**Format:** number

**Rows:**

**Wc:** CNC Mill

**Machines:** 4

**Hrs shift:** 7.5

**Shifts:** 2

**Days:** 5

**Eff:** 82

**Load:** 540

**Wc:** CNC Lathe

**Machines:** 3

**Hrs shift:** 7.5

**Shifts:** 2

**Days:** 5

**Eff:** 85

**Load:** 330

**Wc:** Deburr

**Machines:** 2

**Hrs shift:** 7.5

**Shifts:** 1

**Days:** 5

**Eff:** 90

**Load:** 80

**Wc:** Heat treat (outside)

**Machines:** 1

**Hrs shift:** 8

**Shifts:** 1

**Days:** 5

**Eff:** 95

**Load:** 36

**Wc:** Assembly

**Machines:** 6

**Hrs shift:** 7.5

**Shifts:** 1

**Days:** 5

**Eff:** 80

**Load:** 160

**Totals:**

#### Total planned load

**Key:** load

**Agg:** sum

**Format:** number

#### Total capacity

**Key:** cap

**Agg:** sum

**Format:** number

**Summary:**

#### Overall utilization

**Key:** overall_util

**Expr:** sum_load / sum_cap * 100

**Format:** percent

**Primary:** true

#### Total headroom (hrs)

**Key:** overall_head

**Expr:** sum_cap - sum_load

**Format:** number

**Notes:** Enter planned load from a capacity requirements report or your open job routings for the week. Over 100% means the work center is overloaded; below about 70% suggests slack.

## Content

**Intro:** Before you promise dates, you need to know whether the work centers can absorb the load. This worksheet turns shifts, machines and efficiency into weekly capacity and compares it with planned hours.

**Sections:**

#### How to use the worksheet

**Body:** Add a row per work center. Enter the number of machines or stations, productive hours per shift, shifts per day, days per week and efficiency. Enter planned load in hours for the week from your open jobs or an MRP generated capacity report. Capacity, utilization and headroom calculate automatically. Edit the sample rows or delete them, then export to Excel to share with production meetings.

**Bullets:**

- Use net hours after breaks and planned maintenance
- Use the same work center names as in your routings
- Build one sheet per week or per planning bucket

#### Formulas

**Body:** Capacity equals machines times hours per shift times shifts per day times days per week times efficiency. Utilization equals planned load divided by capacity. Headroom is capacity minus load. Overall utilization uses the totals so a lightly used assembly area does not hide an overloaded milling cell. A bottleneck is the work center with the highest utilization, and it sets the throughput of the whole plant.

#### Reading the results

**Body:** Treat utilization over 85 to 90% as risky in a job shop, because queues grow rapidly as utilization approaches 100%. Overloaded centers call for overtime, outsourcing, rerouting to another machine or moving due dates. Underused centers may be a sign that the bottleneck is upstream. Remember that infinite capacity MRP does not detect these overloads, so a finite schedule or this review is the safeguard.

**Bullets:**

- Check load includes setup as well as run hours
- Consider alternate work centers for overflow
- Review weekly, not only at month end

**Cta:** If you would like weekly work center load pulled automatically from SyteLine jobs and presented as a live dashboard, we can build that.

**Faq:**

#### Where do I get planned load?

**Answer:** From open job operations with remaining setup and run hours by work center, or from a capacity requirements report. Sum them per week for the periods you plan.

#### What efficiency should I use?

**Answer:** Use observed efficiency from reported labor or machine hours against standard. Many shops sit between 70 and 90 percent. Avoid using 100 percent.

#### Why do I get a very high utilization?

**Answer:** Check units: load and capacity must both be in hours for the same period. Also confirm that machines and shift counts are entered correctly.

#### Does this replace finite scheduling?

**Answer:** No. It is a quick check of aggregate capacity. Finite scheduling or APS sequences jobs and considers calendars and constraints in detail.

## Search terms

work center capacity worksheet, capacity planning excel template, capacity vs load spreadsheet, syteline work center capacity, machine utilization calculator, resource load report, weekly capacity plan, rough cut capacity planning template

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