2. Develop a Level Aggregate Plan using inventories but not back orders. All demand must be met each period. Use the data provided in the accompanying Excel file. a. Calculate the aggregate production rate. b. Calculate the appropriate workforce given the aggregate production rate. c. Show what would happen if this plan were implemented. d. Calculate the costs of this plan. e. Evaluate the plan in terms of cost, customer service, operations, and human resources. 12 18 84 12 21 600 450 Information provided by Kid Gloves, Manufacturing Cost Data Regular-time labor cost per hour: Overtime labor cost per hour Subcontracting cost per unit (labor only): Holding cost per unit per period: Back-order cost per unit per period: Hiring cost per employee: Firing cost per employee: Capacity Data Beginning workforce (employees) Beginning inventory (units) Labor standard per unit (hours) Regular time available per period (hours) Overtime available per period (hours) Subcontracting maximum per period (units) Subcontracting minimum per period (units) Demand Data Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 Total Periods Part a 210 2000 6 160 32 1000 500 6000 4800 7840 5200 6560 3600 6000 5296 2112 2112 Part b Part 2 41 5 51 61 71 B 8 91 10 Total Total Aggregate Demand Production Rate/Period Workforce for Aggregate Production Rate Period Demand Net of Inventory Cumulative Demand Production per Period Cumulative Production Cum. Dem. Minus Cum. Prod Ending linventory Back Orders Back order costs Holding Costs Regular Time Labor Costs Total Costs Part d Parte 12 18 84 12 21 600 450 210 2000 Information provided by Kid Gloves, Manufacturing Cost Data Regular-time labor cost per hour: Overtime labor cost per hour Subcontracting cost per unit (labor only): Holding cost per unit per period: Back-order cost per unit per period: Hiring cost per employee: Firing cost per employee: Capacity Data Beginning workforce (employees) Beginning inventory (units) Labor standard per unit hours) Regular time available per period [hours) Overtime available per period [hours) Subcontracting maximum per period (units) Subcontracting minimum per period (units) Demand Data Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 Total Periods 6 160 32 1000 500 6000 4800 7940 5200 6560 3600 6000 5296 2112 2112 Part 1 4 5 6 8 9 10 Tot Plan Computations Period Demand Net of inventory Cumulative Demand Cumu Demand/Period Production per Period Cumulative Production Cum. Dem. Minus Cum. Prod Ending inventory Back Orders Compute Level Prodcution Rate and Workforce Needed Production Rate Units per Employee per Period Employees Needed Number Hire Number Fire Part a Part 6 11