FILE NAME: FLOW3
FUNCTION: Scheduling 3 work stations in series
OVERVIEW: FLOW3 computes a schedule for a group of jobs to be processed through 3 work stations in series. This is done by reducing the problem to a 2 station problem for computational purposes. In I12..I17, the times for station 1 and 2 are added. In K12..K17, the times for stations 2 and 3 are added. These two sets of artificial processing times are used in exactly the same manner as in FLOW2 to develop a schedule.
This procedure yields the optimal makespan when at least one of the following conditions is met:
1. The minimum time on station 1 is greater that or equal to the maximum time on station 2, or
2. The minimum time on station 3 is greater than or equal to the maximum time on station 2.
Even if the makespan is not optimal, the scheduling procedure gives good results.
INPUT: In rows 12-16, list job Names and processing times on the three workstations. Pressing <CNTL> A sorts by job Name, <CNTL> B by random, and <CNTL> C for the optimal sequences.
OUTPUT: Beginning and ending hour numbers for each job are shown in B21..H25. The Gantt chart at the bottom of the worksheet converts the hour numbers to times of day. For each sort, makespan and average flow time are reported in cells J6 and J8. Cell I6 tells you whether the conditions mentioned above are met.
MODIFYING THE WORKSHEET:
To add jobs, insert new rows at the row for job C in each of five sections of the worksheet: rows 12-16, 21-25, 34-38, 40-44, and 46-50. In each section, copy the row of formulas above the inserted rows through the last row in that section. For the first section, just copy the formulas under L..M. The other columns for job Names and processing times need to be input for each new job. You can extend the Gantt chart to show additioNal work days by copying range O30..O52 to the right. To modify the Gantt chart for different work schedules, edit row 31 to show a sequence of work hour numbers, interrupted by labels for lunch and other breaks, In row 32, enter a sequence of times corresponding to the work hour numbers and labels.
1. Get Started
2. Workstation Production Models
3. Scheduling 2 Workstation in Series
4. Scheduling 3 Workstation in Series
5. Scheduling 4 and more Workstation in Series
6. Scheduling 2 Workstation in Parallel
7. Project Management - Daily Schedule
10. Gantt Charting