Please solve the MT and CT for the excel sheet $($input wheat formulas i need to put for every single box$)$ and answer the questions $1-4$ below the main question.

MAIN QUESTION: The local university has developed an eight process for screening the thousands of admissions applications it gets each year. The provost has decided that the best way to take a first cut at all these applications is by employing a line process. The following table shows the times and predecessors for the various tasks. The goal is to process $240$ applications in an $8$ hr working day.

$$NOTE: work out a line balancing layout by using longest cycle time rule as the primary rule to break tie, and work out another layout by using most followers rule as the primary

Question $1$: Which line balancing layout, the one using longest cycle time rule or the one using most followers rule, will you recommend? Why?

Question $2$: Which line balancing layout has shorter percent idle time?

Question $3$: Which line balancing layout has longer actual takt time?

Question $4$: Which line balancing layout requires more stations?