Job Sequencing & Shop Scheduling by Hand: FCFS, SPT, EDD, Critical Ratio, Weighted Rules, Johnson's Rule & Changeover Matrices
Decide which job runs next on the shop floor. You will compare sequencing rules on one machine by flow time, lateness and tardiness, use the critical ratio for daily dispatching, weight jobs by importance, sequence two machines with Johnson's rule, cost sequence-dependent changeovers from a matrix, improve a sequence with a nearest-neighbour heuristic and build a Gantt chart, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you plan the work of a fictional machine shop, with every cell checked. You turn job lists into start and completion times, rank jobs with RANK.EQ and compute SPT and EDD completions with SUMIF, then compare mean flow time, lateness, tardiness and late jobs. You build a daily dispatch list with the critical ratio, weight jobs by importance with WSPT, sequence a saw and a machining centre with Johnson's rule and a MAX-based timetable, look up sequence-dependent changeovers with INDEX/MATCH and finish with a rule comparison table and a stacked-bar Gantt chart.
Lessons
- Job Data: Processing Times, Due Dates & Completion Times Pro
- FCFS, SPT & EDD: Three Sequences, Three Mean Flow Times Pro
- Lateness & Tardiness: Who Is Late, by How Much, and How Many Pro
- Critical Ratio: The Daily Dispatch List Pro
- Weighted Rules: WSPT and Weighted Tardiness Pro
- Johnson's Rule: Two Machines in Series, Makespan & Idle Time Pro
- Changeovers: A Sequence-Dependent Matrix, Plan Totals & Nearest Neighbour Pro
- Capstone: Rule Comparison Table & a Gantt Chart Pro