Need help with part C only, please show work and use Excel if possible.

Need help with part C only, please show work and use Excel if possible.

Question 2: The times required to complete each of eight jobs in a two-machine flow shop are shov in the table that follows. Each job must follow the same sequence, beginning with machine A and moving to machine B. a. Determine a sequence that will minimize makespan time. c. For the sequence determined in part a, how much would machine B's idle time be reduced by splitting the last two jobs in half