3 Directions 4 1. Complete the following two problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time, 5 2. Do not change the name of this file when you save your work. The file should be called "Graded Homework 2 xs 6. 3. Grades are based on the formulas in the cells and the Solver setup (for part (a)) 7 4. To facilitate grading, please do not delete or insert ROWS. 8 I 9 10 11 12 Inventory holding cost (per unit per month) $1.00 13 Hiring cost (per worker hired) $5,000.00 14 Firing cost (per worker fired) $5,000,00 15 Straight-time labor cost (per worker per month) $2.000.00 16 Overtime cost (per worker per month) $4,000.00 17 Production per worker per month 100 18 Present permanent workforce 60 The number of workers must be an INTEGER) 19 Beginning inventory in January 400 30 D. Find the least-cost LEVEL aegate production plan with a CONSTANT workforce. Workers may be hired or fred only at the beginning of January. DO NOT USE SOLVER The Solver setup for question) wil begre January 5000 February 6000 March 8000 April 10000 May 12000 June B000 July 4000 August 6000 September 8000 Octob 12000 Shipment Forecast Aggregate Production Plan Straight Time Production Overtime Production Output Plan Beginning Inventory Shipments Ending Inventory Input Plan Number of Workers Hres 400 5000 6000 8000 10000 12000 8000 4000 6000 3000 1200 Overtime (worker-months) Costs inventory Holding Cost Straight Time Labor Com Hiring Cost Fring Cost Overtime Cost Total Plan Cost the question: b) find the least-cost level aggregate production plan with a constant workforce. workers may be hired or fired only at rhe beginning of january. DO NOT USE SOLVER. the solver set up question (a) will be grades. Fed with a CONSTANT Worters may be betrefy DO NOT USE SOLVER The over het we dont Jay 200 6000 M 3000 Art 10000 May 12000 June 0000 4000 August 0000 1000 Oro 12000 w 000 hon Oro On gy 400 5000 6000 12000 00 4000 6000 1000 12000 0000 do We TC 20 3 Directions 4 1. Complete the following two problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time, 5 2. Do not change the name of this file when you save your work. The file should be called "Graded Homework 2 xs 6. 3. Grades are based on the formulas in the cells and the Solver setup (for part (a)) 7 4. To facilitate grading, please do not delete or insert ROWS. 8 I 9 10 11 12 Inventory holding cost (per unit per month) $1.00 13 Hiring cost (per worker hired) $5,000.00 14 Firing cost (per worker fired) $5,000,00 15 Straight-time labor cost (per worker per month) $2.000.00 16 Overtime cost (per worker per month) $4,000.00 17 Production per worker per month 100 18 Present permanent workforce 60 The number of workers must be an INTEGER) 19 Beginning inventory in January 400 30 D. Find the least-cost LEVEL aegate production plan with a CONSTANT workforce. Workers may be hired or fred only at the beginning of January. DO NOT USE SOLVER The Solver setup for question) wil begre January 5000 February 6000 March 8000 April 10000 May 12000 June B000 July 4000 August 6000 September 8000 Octob 12000 Shipment Forecast Aggregate Production Plan Straight Time Production Overtime Production Output Plan Beginning Inventory Shipments Ending Inventory Input Plan Number of Workers Hres 400 5000 6000 8000 10000 12000 8000 4000 6000 3000 1200 Overtime (worker-months) Costs inventory Holding Cost Straight Time Labor Com Hiring Cost Fring Cost Overtime Cost Total Plan Cost the question: b) find the least-cost level aggregate production plan with a constant workforce. workers may be hired or fired only at rhe beginning of january. DO NOT USE SOLVER. the solver set up question (a) will be grades. Fed with a CONSTANT Worters may be betrefy DO NOT USE SOLVER The over het we dont Jay 200 6000 M 3000 Art 10000 May 12000 June 0000 4000 August 0000 1000 Oro 12000 w 000 hon Oro On gy 400 5000 6000 12000 00 4000 6000 1000 12000 0000 do We TC 20