# Machine Shop Scheduling Excel Template (Job Shop Schedule and Load) > Source: https://netray.co/tools/machine-shop-scheduling-excel-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable job shop schedule with machines, jobs, setup and run hours, due dates and priority. Includes scheduling model examples such as earliest due date and shortest processing time. ## Category manufacturing ## Audience - Machine shop owner - Scheduler - Production supervisor ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Job **Key:** job **Type:** text #### Part **Key:** part **Type:** text #### Machine **Key:** machine **Type:** select **Options:** - Mill 1 - Mill 2 - Lathe 1 - Lathe 2 - Grinder - Saw - Outside process #### Qty **Key:** qty **Type:** number #### Setup **Key:** setup **Type:** number **Unit:** h #### Cycle per part **Key:** cycle **Type:** number **Unit:** min #### Run hours **Key:** run **Type:** number **Expr:** qty * cycle / 60 **Format:** number #### Total hours **Key:** total **Type:** number **Expr:** setup + run **Format:** number #### Planned start **Key:** start **Type:** date #### Due date **Key:** due **Type:** date #### Priority **Key:** prio **Type:** select **Options:** - Hot - Normal - Low #### Status **Key:** status **Type:** select **Options:** - Not started - Setup - Running - Waiting inspection - Done **Rows:** **Job:** J-2601 **Part:** Valve body **Machine:** Mill 1 **Qty:** 40 **Setup:** 2.5 **Cycle:** 18 **Start:** 2026-10-26 **Due:** 2026-10-30 **Prio:** Hot **Status:** Setup **Job:** J-2602 **Part:** Shaft **Machine:** Lathe 1 **Qty:** 150 **Setup:** 1.5 **Cycle:** 6 **Start:** 2026-10-26 **Due:** 2026-11-02 **Prio:** Normal **Status:** Running **Job:** J-2603 **Part:** Flange **Machine:** Lathe 2 **Qty:** 80 **Setup:** 2 **Cycle:** 9 **Start:** 2026-10-27 **Due:** 2026-11-03 **Prio:** Normal **Status:** Not started **Job:** J-2604 **Part:** Bracket **Machine:** Mill 2 **Qty:** 60 **Setup:** 3 **Cycle:** 14 **Start:** 2026-10-28 **Due:** 2026-11-04 **Prio:** Low **Status:** Not started **Job:** J-2605 **Part:** Pin **Machine:** Grinder **Qty:** 300 **Setup:** 1 **Cycle:** 3 **Start:** 2026-10-28 **Due:** 2026-11-05 **Prio:** Normal **Status:** Not started **Totals:** #### Total scheduled hours **Key:** total **Agg:** sum **Format:** number #### Total run hours **Key:** run **Agg:** sum **Format:** number #### Total setup hours **Key:** setup **Agg:** sum **Format:** number #### Jobs on the schedule **Key:** job **Agg:** count **Format:** integer **Summary:** #### Setup share of hours **Key:** setup_share **Expr:** if(gt(sum_total,0), sum_setup / sum_total * 100, 0) **Format:** percent #### Shop-days at 8 hours **Key:** shop_days **Expr:** sum_total / 8 **Format:** number **Primary:** true **Notes:** Filter by machine in Excel after export to see each machine's load. Sort by due date for an earliest-due-date view, or by total hours for shortest processing time. ## Content **Intro:** This machine shop scheduling template lists every job with its machine, setup and run hours, planned start, due date and priority. It totals the hours so you can see whether the week fits, then exports to Excel for sorting and filtering. **Sections:** #### How to use the job shop schedule **Body:** Enter one row per job operation. Choose the machine, enter quantity, setup hours and cycle time per part in minutes. The sheet computes run hours and total hours. Set planned start and due dates and mark priority and status. After export, sort by machine to see the load per machine, and by due date to see what is at risk. Update status daily at the shift handover so the sheet matches the floor. **Bullets:** - Use one row per operation if a job visits several machines - Keep setup separate from run hours - Mark hot jobs only when the customer date truly drives them - Update status at each shift change #### Scheduling model examples **Body:** Simple rules work well in a small shop. First-in first-out is fair but ignores due dates. Earliest due date minimises the maximum lateness. Shortest processing time clears many small jobs and reduces average wait. Critical ratio divides time remaining by work remaining and flags jobs falling behind. Forward scheduling starts at today and finds the finish date, while backward scheduling starts at the due date and finds the latest start. Sorting the exported sheet lets you apply each rule in seconds. #### Reading the load **Body:** Sum the total hours per machine and compare to available hours, for example 8 hours per shift times the number of shifts times efficiency. If a machine's total exceeds that, push jobs, add overtime, or use a different machine. In the sample, the lathe load is heavy early in the week while the saw is empty, which is a typical imbalance a spreadsheet makes visible. #### Limits of a spreadsheet schedule **Body:** A spreadsheet does not know tool availability, material arrival or operator skills, and it does not reschedule automatically when a job slips. Once you have more than a few dozen jobs a week, the update effort grows. That is when finite scheduling in your ERP or a scheduling system pays for itself. Until then, a disciplined sheet with a daily review is a good, cheap start. **Cta:** If jobs and routings already live in your ERP, Netray can add a private AI layer on your own servers so a scheduler can ask which jobs will miss their dates, instead of rebuilding the sheet each morning. **Faq:** #### What is the best scheduling rule for a machine shop? **Answer:** There is no single best rule. Earliest due date is a good default for on-time delivery, shortest processing time lowers average wait, and critical ratio is useful for monitoring. Pick one, apply it consistently and measure on-time delivery. #### How do I schedule jobs that need several machines? **Answer:** Add one row per operation and keep the job number the same. Sequence operations by routing order, and schedule each at the machine, allowing for queue and move time between operations. #### How do I include setup time in the schedule? **Answer:** Enter setup hours separately from run hours and let the sheet add them. Grouping similar jobs on the same machine reduces setup, so check the setup share in the summary. #### Can I use this for production scheduling in other plants? **Answer:** Yes. Rename the machine list to your work centers and change the units if needed. The logic of hours, due dates and priority applies to any discrete manufacturing shop. ## Search terms machine shop scheduling excel template, manufacturing schedule template excel, manufacturing production scheduling examples, manufacturing production scheduling models, job shop scheduling template, job shop schedule spreadsheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json