Machine Shop Scheduling Excel Template (Job Shop Schedule and Load)
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.
| Job | Part | Machine | Qty | Setup (h) | Cycle per part (min) | Run hours | Total hours | Planned start | Due date | Priority | Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 14.5 | |||||||||||
15 | 16.5 | |||||||||||
12 | 14 | |||||||||||
14 | 17 | |||||||||||
15 | 16 |
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.
From spreadsheet to ERP scheduling
Optional: a short review of how to move this schedule into your ERP with a private AI layer for what-if questions.
Optional. The tool and every export work without this. No spam.
How to use the job shop schedule
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.
- 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
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
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
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.
Frequently Asked Questions
What is the best scheduling rule for a machine shop?
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?
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?
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?
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.
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.
Related Tools
Production Schedule Template
Generate a printable weekly production schedule with jobs, setups, due dates, assumptions, risks and sign-off lines.
MES & Shop FloorFinite Capacity Scheduling Worksheet
Load jobs against a work center with setup, run time and available hours per day, and see the hours and days of work you are committing.
Discrete ManufacturingManufacturing Capacity Planning Template (Excel)
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.
MES & Shop FloorDaily Production Schedule Board Worksheet
An editable job board that totals setup and run hours per line so a scheduler can see whether the day fits the shift.
MES & Shop FloorJob Shop On-Time Delivery Tracker Worksheet
An editable tracker that computes days late per job and the shop on-time delivery rate from promised and actual ship days.
More Discrete Manufacturing tools
See all- OEE Calculator (Overall Equipment Effectiveness)
- Scrap Rate Cost Calculator
- Takt Time Calculator
- Cycle Time & Capacity Calculator
- Inventory Carrying Cost Calculator
- Economic Order Quantity (EOQ) Calculator
- MRP Nervousness Assessment
- Production Scheduling Maturity Assessment
- Shop Floor Digitization Scorecard
Keep exploring
Free tools
- Excel Machine Shop Quote TemplateA fillable machine shop quote with price breaks, setup charges, lead time and terms. Includes a worked example and format notes for sheet metal and injection molding quotations.
- Job Shop Machine Hour Rate WorksheetEditable worksheet that converts machine price, life, hours, power draw and maintenance into a cost per run hour for each machine.
- Job Shop Material Certification Log WorksheetAn editable log linking material heat or lot numbers to jobs, purchase orders and cert status, exportable to Excel for customer or auditor requests.
ERP fixes and how-tos
- How to Run Live Scheduling in Global Shop SolutionsHow to set up and run Live Scheduling in Global Shop Solutions, from work center setup through the scheduling board, and why the board can drift from reality.
- Epicor Kinetic Dashboard Examples (Shop Floor, Sales, Purchasing) and How to Add FiltersPractical Epicor Kinetic dashboard examples for shop floor, sales and purchasing, with the tables to query and how to add filters and parameters.
- How to Add a Private AI Layer to Global Shop Solutions On-PremHow to add a private on-prem AI assistant to Global Shop Solutions ERP: read-only data access, scheduling data, security mapping, GPU sizing and phased rollout.
Guides
- Scheduling Build-to-Print Jobs When Customers Keep Changing Due DatesHow build-to-print shops schedule when customers change due dates: capacity visibility, outside processing lead times, expedite rules and honest promise dates.
- Machine Shop Scheduling for CNC Job Shops: Why Schedules Break and How to Fix ThemMachine shop scheduling for CNC job shops: why schedules break, finite versus infinite capacity, the data it needs, and where AI helps daily.
- Scheduling an Aerospace Machine Shop With Outside ProcessingHow aerospace job shops schedule around CMM, FAI holds, source inspection and outside processing lead times, and where finite-capacity tools and AI help.
AI on your ERP
- AI for Global Shop Solutions schedulingHow AI reads Global Shop Solutions work orders, routings, and finite schedule data to explain late jobs and test rush orders, read-only and private.
- AI for ECI JobBOSS2 and E2 Shop SystemAdd AI to ECI JobBOSS2 or E2 Shop System for faster quoting, tighter scheduling, and shop-floor answers, without sending your job data to the cloud.
Integrations
- How to add a mobile app to Priority ERPBuild or extend a mobile app for Priority ERP: barcode scanning, inventory moves, labor reporting and approvals over the OData API, with offline handling.
- How to add AI agents to Priority ERPHow to add AI agents to Priority ERP: an OData tool layer, approval gates on every write, and open-weight models that run on-prem next to your Priority server.
Software
- Global Shop SolutionsWhat Global Shop Solutions ERP is, how its estimating, scheduling and shop floor modules serve job shops, and which ERP alternatives to compare.
- Priority SoftwarePriority Software ERP explained: modules, low-code customization, OData API integration, deployment options, limitations and alternatives for manufacturers.