Section 10 - Multiple Machines or Work Centres

Manufacturing Corner on

Saturday, November 26, 2022

 Multiple Machines or Work Centres

So far we have only considered one work centre. For multiple work centres we could create a separate schedule for each,

but here is another way of doing it:

In this example a job can be assigned to Work Centre 1 OR Work Centre 2, and then assigned a sequence within it.

(We shall look one job passing through multiple work centres later) 

Note that the 1's and 2's in the Work Centre column are codes rather than numbers, so they have been formatted as text

Format|Cells|Number|Text.

You can now change both the work centre number and the sequence number, and sort with Data|Sort

- Sort By W/C Ascending

- Then By Seq Ascending

Labels: Scheduling Excel Basic

Thanks for reading Section 10 - Multiple Machines or Work Centres. Please share...!