-->

Manufacturing Corner

Production manufacturing solution

Translate

Section 30 Repetitive Production Through Multiple Work Centres - Pull Schedule

Here is the schedule from Section 21 which introduced the concept of repetitive production, and sequential operations being undertaken, on a product, at the same time. Again we will compare it with a pull version of the same schedule.





Section 29 Multiple Work Centre - Pull Schedule

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.





Section 28 Applying Calendar Formula 3 to a Pull Schedule

Applying Calendar Formula 3 to a Pull Schedule

Here is the schedule from Section 9 again, but this time it works backwards from the stop of the last job.



Section 27 Working Backwards Through a Calendar (Calendar Formula 3)

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.




With a series of substitutions, the 15 formulas can be condensed into 4 as follows:
Calc1 6 =MATCH(E16,B9:B14)+(MATCH(E16,B9:B14)=MATCH(E16,C9:C14))
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


Back To Top