Question: PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS (SCREENSHOTS) AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT
PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS (SCREENSHOTS) AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER.
Develop a solution for the following line balancing problem, allowing a cycle time of 5 minutes.
a. Calculate the theoretical minimum number of workstations?
b. Balance this line using the longest task time heuristic.
c. What tasks are assigned to which stations? Does the solution have the minimum number of stations? Explain.
d. How much idle time is there, summed over all workstations?
e.What is the efficiency of this line?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
