Mikadata November 29, 2022 Admin Bandung Indonesia
To examine pull scheduling logic further we have repeated the push schedule in Section 20, and compared it with a pull version of the same schedule. The pull schedule works backwards from the stop of the last job, and each job will be dependent on the next job on the work centre, and the next operation on the job.
Mikadata November 29, 2022 Admin Bandung Indonesia
Section 29 Multiple Work Centre - Pull Schedule
To examine pull scheduling logic further we have repeated the push schedule in Section 20, and compared it with a pull version of the same schedule. The pull schedule works backwards from the stop of the last job, and each job will be dependent on the next job on the work centre, and the next operation on the job.
Here is the schedule from Section 9 again, but this time it works backwards from the stop of the last job.
To make a pull schedule that works through a calendar, we will need a formula that works backwards, or upwards through the calendar. Given a job stop and working hours, when will I need to start. Here is the development of the formula from Section 6, and it can be modified by changing just one sign.
Calc2 9 =INDEX(E9:E14,B41,1)-(INDEX(C9:C14,B41,1)-MAX(INDEX(B9:B14,B41,1),E16))
Calc3 2 =MATCH(B42-E17,E9:E14)+1
Job Stop 8.5 =INDEX(C9:C14,B43,1)-INDEX(E9:E14,B43,1)+B42-E17
Section 27 Working Backwards Through a Calendar (Calendar Formula 3)
To make a pull schedule that works through a calendar, we will need a formula that works backwards, or upwards through the calendar. Given a job stop and working hours, when will I need to start. Here is the development of the formula from Section 6, and it can be modified by changing just one sign.
Calc2 9 =INDEX(E9:E14,B41,1)-(INDEX(C9:C14,B41,1)-MAX(INDEX(B9:B14,B41,1),E16))
Calc3 2 =MATCH(B42-E17,E9:E14)+1
Job Stop 8.5 =INDEX(C9:C14,B43,1)-INDEX(E9:E14,B43,1)+B42-E17