Drew's company, Ace Hasells com sets of poor clos Helden doing a plan for next year on a quarterly bass The expected demand 500, 200, 600 and 600 sets of chips, respectively, for quarters one through four. He currently has 70 sets on hand that can be used to meet next year's demand. He can produce 150 units per month for 450 per quarter) at the regular rate of $60 perset. His team will work overtime when needed and available, producing up to 300 units in Q1, 150 in 2 none in Q3 and 200 In Q4. Sets produced via overtime cost a total of $90 per set. He can leverage a competitor form and outsource production at the cost of $110 per set, with a capacity of 300 units per quarter. Storage costs are $5 per set per quarter. Drew has determined that he will have a policy of back-ordering at a cost of $1.50 Based on utilizing the Transportation Method: a. What is the optimal cost for Drew? Select b. Wore any units held over during the planning period? If so, how many and what was the total holding cost incurred? Select) c. How many total units would be produced via overtime? Select) d. How many units would be produced via subcontracting? Select 1 a. What is the optimal cost for Drew? Select] b. Were any units held over during the planning period? If so, how many and what was the total holding cost incurred? Select c. How many total units would be produced via overtime? Select) d. How many units would be produced via subcontracting? Select) e. How many units of excess capacity are there? Select f. Was there a need to back-order? If so, how many units and what was the total cost? Select) Drew's company, Ace Hasells com sets of poor clos Helden doing a plan for next year on a quarterly bass The expected demand 500, 200, 600 and 600 sets of chips, respectively, for quarters one through four. He currently has 70 sets on hand that can be used to meet next year's demand. He can produce 150 units per month for 450 per quarter) at the regular rate of $60 perset. His team will work overtime when needed and available, producing up to 300 units in Q1, 150 in 2 none in Q3 and 200 In Q4. Sets produced via overtime cost a total of $90 per set. He can leverage a competitor form and outsource production at the cost of $110 per set, with a capacity of 300 units per quarter. Storage costs are $5 per set per quarter. Drew has determined that he will have a policy of back-ordering at a cost of $1.50 Based on utilizing the Transportation Method: a. What is the optimal cost for Drew? Select b. Wore any units held over during the planning period? If so, how many and what was the total holding cost incurred? Select) c. How many total units would be produced via overtime? Select) d. How many units would be produced via subcontracting? Select 1 a. What is the optimal cost for Drew? Select] b. Were any units held over during the planning period? If so, how many and what was the total holding cost incurred? Select c. How many total units would be produced via overtime? Select) d. How many units would be produced via subcontracting? Select) e. How many units of excess capacity are there? Select f. Was there a need to back-order? If so, how many units and what was the total cost? Select)