Scribd
Upload
7 views4 pages

3 Pass Job Scheduling for Work Centres

This document describes a 3-pass scheduling logic for jobs passing through multiple work centres. The scheduling logic considers 7 factors: the start of the schedule, job length, due date, previous job stop time, next job start time, previous operation stop time, and next operation start time. Formulas are provided to calculate the start and stop times for each job/operation based on these factors in order to generate a schedule. The schedule can be adjusted by changing job hours and due dates.

Uploaded by

sahilsahni20
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
7 views4 pages

3 Pass Job Scheduling for Work Centres

This document describes a 3-pass scheduling logic for jobs passing through multiple work centres. The scheduling logic considers 7 factors: the start of the schedule, job length, due date, previous job stop time, next job start time, previous operation stop time, and next operation start time. Formulas are provided to calculate the start and stop times for each job/operation based on these factors in order to generate a schedule. The schedule can be adjusted by changing job hours and due dates.

Uploaded by

sahilsahni20
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Multiple Work Centre - 3 Pass Schedule

Here we apply the 3 pass logic set out in Section 31 to jobs that pass through multiple work centres. The logic that applies to th
the columns narrower this way. The Push 2 logic is the same as in Section 32, except that the start is subject to an additional co

- the start of the schedule (hour zero)


- the length of the job in hours
- when the job is due
- the stop of the previous job on the work centre
- the start of the next job on the work centre
- the stop of the previous operation on the job
- the start of the next next operation on the job

Push 1
Prev. Op Stop of
W/C Jobs Op Job/Op Hours Due Prev. Op Row Prev. Op Start
6 job A 1 A/1 16 A/0 #N/A 0 0
6 job B 1 B/1 16 B/0 #N/A 0 16
6 job C 1 C/1 8 C/0 #N/A 0 32
7 job A 2 A/2 8 A/1 15 16 16
7 job B 2 B/2 32 B/1 16 32 32
7 job C 2 C/2 8 C/1 17 40 64
8 job A 3 A/3 16 24 A/2 18 24 24
8 job B 3 B/3 8 72 B/2 19 64 64
8 job C 3 C/3 16 96 C/2 20 72 72

These are the formulas that are different:


=IF(ISERROR(M23),F23,INDEX(O$1:O$28,M23,1))
=MIN(IF(A23=A24,O24,999),N23)
=MAX(J23,O23,Q23,IF(A23=A22,S22,0))

Try changing the hours and due figures, and see how the schedule behaves.
ntres. The logic that applies to the Push 1 part of the schedule is explained in Section 20. The Pull part is in Section 29, but has been modi
start is subject to an additional constraint, the stop of the previous operation. So now the scheduling of a job takes 7 things into consideratio

Pull Push 2
Next Op Start of Stop of
Stop Next Op Row Next Op Start Stop Prev. Op Start Stop 0
16 A/2 18 0 -16 0 0 0 16
32 B/2 19 32 16 32 0 16 32
40 C/2 20 72 64 72 0 64 72
24 A/3 21 8 0 8 16 16 24
64 B/3 22 64 32 64 32 32 64
72 C/3 23 80 72 80 72 72 80
40 A/4 #N/A 24 8 24 24 24 40
72 B/4 #N/A 72 64 72 64 64 72
88 C/4 #N/A 96 80 96 80 80 96

X(O$1:O$28,M23,1)) - if there isn't a next operation put in the time due, else find the start of the next op in coumn O
- the stop is the earlier of: the start of the next job on the work centre if there is one, else the st
- the start is the later of: earliest (push 1) start
latest (pull) start
stop of the previous operation
stop of the previous job on the work centre, if there is one
Section 29, but has been modified to cope with Due time. This example uses hurs rather than Julian dates, simply because we can make
b takes 7 things into consideration:

Day 1 Day 2 Day 3 Day 4

8 16 24 32 40 48 56 64 72 80
1 1
1 1
1
1
1 1 1 1
1
1 1
1

start of the next op in coumn O


centre if there is one, else the start of the next op (or the time due)

work centre, if there is one


s, simply because we can make

Day 4

88 96

1 1

You might also like