# Daily Production Schedule Board Worksheet (Excel Export)

> Source: https://netray.co/tools/daily-production-schedule-board-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable job board that totals setup and run hours per line so a scheduler can see whether the day fits the shift.

## Category

mes-shop-floor

## Industry

Discrete Manufacturing

## Audience

- Production scheduler
- Planner
- Shift supervisor

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Seq

**Key:** seq

**Type:** number

#### Job / order

**Key:** job

**Type:** text

#### Part number

**Key:** part

**Type:** text

#### Work center

**Key:** wc

**Type:** text

#### Qty

**Key:** qty

**Type:** number

#### Setup hrs

**Key:** setup_hrs

**Type:** number

**Format:** decimal

#### Run hrs

**Key:** run_hrs

**Type:** number

**Format:** decimal

#### Total hrs

**Key:** total_hrs

**Type:** number

**Expr:** setup_hrs + run_hrs

**Format:** decimal

#### Due date

**Key:** due

**Type:** date

#### Status

**Key:** status

**Type:** select

**Options:**

- Not started
- Kitted
- Running
- Waiting QC
- Complete
- Blocked

**Rows:**

**Seq:** 1

**Job:** WO-100412

**Part:** BRK-1001

**Wc:** CNC-02

**Qty:** 120

**Setup hrs:** 1.5

**Run hrs:** 3.2

**Due:** 2026-10-21

**Status:** Running

**Seq:** 2

**Job:** WO-100415

**Part:** SHF-2204

**Wc:** CNC-02

**Qty:** 60

**Setup hrs:** 0.75

**Run hrs:** 2.4

**Due:** 2026-10-21

**Status:** Kitted

**Seq:** 3

**Job:** WO-100420

**Part:** HSG-3310

**Wc:** CNC-02

**Qty:** 40

**Setup hrs:** 2

**Run hrs:** 1.8

**Due:** 2026-10-22

**Status:** Not started

**Seq:** 4

**Job:** WO-100431

**Part:** PLT-0907

**Wc:** CNC-02

**Qty:** 200

**Setup hrs:** 0.5

**Run hrs:** 1.1

**Due:** 2026-10-23

**Status:** Blocked

**Totals:**

#### Total quantity

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total setup hours

**Key:** setup_hrs

**Agg:** sum

**Format:** decimal

#### Total scheduled hours

**Key:** total_hrs

**Agg:** sum

**Format:** decimal

**Summary:**

#### Setup share of scheduled time

**Key:** setup_share

**Expr:** sum_setup_hrs / sum_total_hrs * 100

**Format:** percent

#### Hours left in an 8 hour shift

**Key:** shift_gap

**Expr:** 8 - sum_total_hrs

**Format:** decimal

**Primary:** true

**Description:** Negative means the board is overloaded for one shift on this work center.

**Notes:** Keep one board per work center per day. Compare the total against the shift hours you can really staff, not the nameplate hours.

## Content

**Intro:** A daily schedule board is the simplest control a production scheduler has. This worksheet lists jobs in running order, adds setup and run hours, and shows at a glance whether the day fits the shift.

**Sections:**

#### How to use the board

**Body:** List the jobs for one work center in the order you want them run, then enter setup and run hours from the routing or from recent actuals. The total column adds them for you and the summary compares the day against an 8 hour shift. Change the status as the shift progresses and export to Excel for the floor copy. If the gap goes negative, move a job to the next day or add overtime rather than hoping the run rates improve.

**Bullets:**

- One board per work center per day keeps the numbers honest.
- Sequence by due date first, then by setup family to cut changeovers.
- Mark Blocked jobs with the missing item so purchasing can see it.

#### Where the hours come from

**Body:** Run hours are quantity divided by the standard rate, adjusted for the yield you actually see. Setup hours should come from the routing, but many shops find routing setups are stale, so compare them with the last three actual setups for that part. Do not schedule to 100 percent of the shift. Breaks, first piece approval, tool breakage and material moves consume time that rarely shows in the routing.

#### Reading the setup share

**Body:** The setup share tells you how much of the plan is not producing parts. A figure above 25 to 30 percent on a machining center usually points to batching that is too small or a sequence that ignores part families. It is a prompt to look at the changeover order, not a target in itself, because small lots may be a customer requirement.

#### Common mistakes

**Body:** The usual errors are scheduling jobs whose material is not kitted, forgetting that a job already running carries over from the previous shift, and ignoring planned maintenance. In an ERP such as SyteLine, Epicor, SAP PP or Oracle, the same board is a view of released orders by work center, but the system date logic often hides these practical gaps.

**Bullets:**

- Include carry-over jobs from the prior shift.
- Subtract planned maintenance and meetings before judging the gap.
- Re-run the board when a hot job arrives.

**Cta:** If your ERP already holds these orders, we can build a read-only board that pulls released jobs by work center and flags the ones that are short of material.

**Faq:**

#### Can I use this for more than one machine?

**Answer:** Yes, add a work center value to each row and filter in Excel after export. For a clean load check, though, keep one board per work center so the total hours compare with one shift capacity.

#### Why is the shift gap fixed at 8 hours?

**Answer:** It is a simple default. Adjust the number after export, or subtract the hours you actually staff. For exact capacity by week, use a capacity worksheet that deducts breaks, maintenance and expected utilization.

#### Where should setup hours come from?

**Answer:** Start with the routing, then compare with recent actual setup times for the same part and machine. If actuals are consistently higher, use actuals in the schedule and fix the routing in your ERP.

#### Does it send data to my ERP?

**Answer:** No. It runs in your browser and exports to Excel, PDF or CSV. Nothing is written back to any system.

## Search terms

daily production schedule template excel, production schedule board, shop floor schedule template, daily job sequence worksheet, production scheduler spreadsheet, work center daily schedule, machine schedule template, free production schedule excel

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