Q4
#0000081411
4 / 48
A spreadsheet has been developed to calculate the cycle time for an assembly line required to meet a given production demand. Cells A1 through A5 contain the task times, cell B1 contains the number of stations, and cell B2 contains the cycle time. The equation for balance delay is
(no. of stations)(cycle time)−sum of task times(no. of stations)(cycle time)
If cell C1 is to contain the balance delay for the solution, what formula should be put into it?