X=44

PLEASE USE EXCEL TO SOLVE AND SHOW FORMULAS

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? 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