On the left side of the Spreadsheet, find row titled “Locations”. Based on your analyses as illustrated above, determine the number of locations required for each process (some of which include both labor and machine. Enter that number for each process.
Then, in leftmost cell of row titled “Total Labor Resources”, build a formula to sum all the required labor resources across the spreadsheet, and round the sum to 1 decimal place.
Finally, in leftmost cell of row titled “Total Locations”, sum all the required locations, or footprints.
Save all your work on the Resource Calculation Spreadsheet, which will be a key source document for creating your Conceptual Line Design in Exercise #9!
|People = STwLABOR / Takt||Leave the result fractional and round up for the entire line or based on feeder grouping and ability to flex.|
|Workstations = STwLABOR / Takt||Same formula as above, but usually round up per process.|
|Machines = STwMACHINE / Takt||This formula applies to machines that run one piece at a time. Usually round up in the process. ST is from piece to piece.|
|Pieces = STwMACHINE / Takt||Applies to multi-spindle or batch machines. Calculates required capacity in units per machine batch – as test tubes in a centrifuge – to achieve Takt.|