Question 18 15 points Number Help Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming quarters: Quarter Demand 1 730 2 930 3 1,230 4 650 300 units Previous Production level Quarter ) Inventory holding cost Hiring workers Firing workers Subcontracting cost Regular time production cost Overtime production cost $10 $20 $40 $200 $100 $150 per unit per quarter per unit per unit per unit per unit per unit a) [8 points] The beginning inventory is 0. Develop an aggregate plan using the chase (i.e. produce to demand) strategy. The demands have been set in the table below. Complete the aggregate plan to determine regular time production levels, and increases and decreases in production levels from quarter to quarter. Calculate the overall cost. Please do enter for the cells with zero values. They will be graded as part of your solution. Quarter Demand Regular time Inventory Subcontract Hiring p n/a n/a 730 Number Number Number Number Firing 1800 n/a n/a 1 n/a 2 2 930 Number Number nia Number Number 13 1.230 Number Number n/a Number Number 14 550 Number Number n/a Number Number Total na units) Number Number nia a Number Number Overall Cost: Number dollars b) [8 points] The beginning inventory is now 50 units. The aggregate planning strategy is level strategy of 750 units per quarter. If the production cannot meet the demand, subcontracting is then utilized. Calculate the overall cost. Please do enter for the cells with zero values. They will be graded as part of your solution Quarter Demand Regular time Inventory Subconract Hiring Firing p Ina 1200 50 n/a n/a n/a 1 1730 Number Number Number Number Number 1 2 930 Number Number Number Number Number 13 1,230 Number Number Number Number Number + 650 Number Number Number Number Number Total units) n/a Number Number Number Number Number Overall cost: Number dollars c) [3 points] The aggregate planning strategy is level strategy of 750 units per quarter. There are 60 working days per quarter. The labor hours needed to produce one unit is 3 hours and each worker will work 8 hours per day. Number workers we need to meet the level strategy. (Round to two decimal places if needed) ) Question 18 15 points Number Help Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming quarters: Quarter Demand 1 730 2 930 3 1,230 4 650 300 units Previous Production level Quarter ) Inventory holding cost Hiring workers Firing workers Subcontracting cost Regular time production cost Overtime production cost $10 $20 $40 $200 $100 $150 per unit per quarter per unit per unit per unit per unit per unit a) [8 points] The beginning inventory is 0. Develop an aggregate plan using the chase (i.e. produce to demand) strategy. The demands have been set in the table below. Complete the aggregate plan to determine regular time production levels, and increases and decreases in production levels from quarter to quarter. Calculate the overall cost. Please do enter for the cells with zero values. They will be graded as part of your solution. Quarter Demand Regular time Inventory Subcontract Hiring p n/a n/a 730 Number Number Number Number Firing 1800 n/a n/a 1 n/a 2 2 930 Number Number nia Number Number 13 1.230 Number Number n/a Number Number 14 550 Number Number n/a Number Number Total na units) Number Number nia a Number Number Overall Cost: Number dollars b) [8 points] The beginning inventory is now 50 units. The aggregate planning strategy is level strategy of 750 units per quarter. If the production cannot meet the demand, subcontracting is then utilized. Calculate the overall cost. Please do enter for the cells with zero values. They will be graded as part of your solution Quarter Demand Regular time Inventory Subconract Hiring Firing p Ina 1200 50 n/a n/a n/a 1 1730 Number Number Number Number Number 1 2 930 Number Number Number Number Number 13 1,230 Number Number Number Number Number + 650 Number Number Number Number Number Total units) n/a Number Number Number Number Number Overall cost: Number dollars c) [3 points] The aggregate planning strategy is level strategy of 750 units per quarter. There are 60 working days per quarter. The labor hours needed to produce one unit is 3 hours and each worker will work 8 hours per day. Number workers we need to meet the level strategy. (Round to two decimal places if needed) )