X=32 please post formulas and work used in excel!!

4. Jobs A, B, and C are waiting to be started on machine center M1 and then be completed on machine center M2. The following information pertains to the jobs and work centers. (Chapter 11) Machine center M1 and machine center M2 have 40 hours of capacity per week ( 5 working days per week, eight hours/day). Two days are allowed to move jobs between machine centers. a. If these jobs are rescheduled by earliest due date, can they be completed on time? b. Can the jobs be completed on time (using the earliest due date rule) if 20 hours of overtime are run in machine center M1 each week? c. If these jobs are rescheduled by the critical ratio, can they be completed on time? d. If these jobs are rescheduled by shortest operation (shortest processing time), can they be completed on time