Please show all work and make it easy for me to understand and work in Excel. Thank you!

SYG Manufacturing Corporation contracted with PEG Motors to provide motor casings.

According to the contract, SYG should design their assembly line to produce $480$ units of

casings in $12$ hours. SYG gathered tasks, task times, and sequence requirements shown

below. No cellular layout will be used.

What is the theoretical minimum number of workstations required?

Calculate efficiency for theoretical number of stations and also for following the

immediate predecessor chart?

Calculate idle time for each workstation $($Hint$,$ Cycle time minus what you assigned for

each workstation$).$