COULD YOU PLEASE SHOW EXCEL FORMULAS PLEASE HELP. THANK YOU! Dave Grubbs of Grubbs Auto Body has five cars waiting for Economy Detailing. An Economy

Detailing consists of a wash and then a hand wax. Cars cannot be waxed until they are washed.

ROUND UP $($X$/5)$ & $($X$/10).($Chapter $11$ Production Activity Control$)(30$ points$)$

a$.$ What schedule produces the shortest time span in which these orders can be completed?

Sequence:

b$.$ Create a Gantt chart for the optimal sequence $($shortest time span$).$

c$.$ How many hours does it take to complete the five orders?

d$.$ For the schedule in question $"a",$ how many hours is the waxing task idle?

e$.$ When will Dave finish the Cadillac?

f$.$ What is the average order completion time?