PLEASE MAKE IT IN EXCEL FORMAT, I need the information of the formula & the answers 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: Do each of the following: a. Draw the precedence diagram. b. Determine the minimum cycle time, the maximum cycle time, and the calculated cycle time. c. Determine the minimum number of stations needed d. Assign tasks to workstations. Note: Try to use a minimal number of workstations. It is okay if you use more workstations than the theoretical minimum number of stations calculated in part c. e. Compute the percentage of idle time for the assignment in part d