ABC Manufacturing has the following Aggregate Plan demandrequirements and other data for the upcoming four quarters. QuarterDemand Previous quarter's output 1500 units 1 1300 Beginninginventory 200 units 2 1400 Stockout cost $50 per unit 3 1500Inventory holding cost $10 per unit at end of quarter 4 1300 Hiringworkers $4 per unit Laying off workers $8 per unit Unit cost $30per unit Overtime $10 extra per unit By utilizing the aggregateplanning excel sheet, answer the following: a. Plan A - Chasedemand by hiring and laying off. What is the total cost of theplan? [ Select ] b. Plan B - Mixed strategy producing at a constantrate of 1200 and obtaining the remainder from Overtime. What is thecost of this plan? [ Select ] c. Based on cost, what plan should bechosen?
please show all the work. thank you
