As part of a major plant renovation project, the industrial engineering department has been asked to balance a revised assembly operation to achieve an output of 240 units per eight hour day. Task times and precedence relationships are as follows 02 4.4 02 1. 1. 1.0 Cock here for the Excel Data Eile Do each of the following a. Determine the minimum cycle time, the maximum cycle time, and the calculated cycle time (Round your answers to 1 decimal place.) The minimum cycle time The maximum eyde time Calculated cyde time minutes per unit minutes per unit minutes per unit b. Determine the minimum number of stations needed (Round your answer to the next whole number.) c. Assign tasks to workstations on the basis of greatest number of following tasks Use longest processing time as a tiebreaker If lie still exist, assume indifference in choice ti IV d. Compute the percentage of idle time for the assignment in part d. Use the actual bottleneck cycle time in your calculation (Round your answer to 2 decimal places.)