Jones Inc. is preparing an aggregate production plan for next year. The company expects demand to be 1300 units in quarter 2.100 units in quarter 24100 units in quarter 3, and 3500 units in quarter 4 The company will have 150 units in inventory at the beginning of the year and desires to maintain at least that number at the end of each quarter as safety stock. Assume hing and layoffing.it necessary, occur at the beginning of the quarter Other information Regular production labor cost-$110 per unit Overtime production cost per unit - $165 Inventory Carying cost $20/unit quarter based on quarter-ending inventory Hiring cost $2.500 per worker Firing/layoff cost $3,000 per worker Beginning number of workers 15 DictureClick here for the Excel Data Bile Each worker can produce 100 units per quarter. --1. Given the planning Information, develop a level production plan and a chase production plan (Leave no cells blank.be certain to enter" wherever required) Regolar Ovembre 1 2 3 1.100 2,100 4100 3.1001 10.400 To --2 What is the total cost of a level plan? -1. Given the planning Information, develop a chase production plan utilizing hiring and firing (Leave no cells blank - be certain to enter "o" wherever required) Coco TH Wom Room Chase Plan Ve Woche Rogala Product 1 1.100 2 2.100 3 4.100 4 3.100 Total 10,400 b 2. What is the total cost of a chase plan utilizing hining and firing! 1. Suppose Jones management wekiant to constantly change the workforce by hand in the five additional workers at the beginning of the year. The company will build inventory in low-demand month demand months. In addition, if necessary, overtime will be used to meet demand requirements the overtory available (Leave no cell blank be certain to enter" wherever required) Ovom ulicom Hogar Production Ending Iwan Warhorn Hered Fice layoff Quarta 1 2 Demand 1.100 2.100 1160 3,100 10.400 4 Total a c-2. What is the total cost of this plan? Total com