solution

PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS (SCREENSHOTS) AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. All WORK SHOULD BE IN EXCEL. SCREENSHOT A PICTURE OF ANSWERS THEN A SCREENSHOT OF FORMULAS IN EXCEL

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?

Work Task	Tast Time (seconds)	Task Predecessor(s)
A	70	–
B	60	A
C	120	B
D	60	–
E	240	C, D
F	100	A
G	190	E, F