a) use microsoft office excel solver to find the least-cost CHASE aggregate production plan with a CONSTANT workforce. Workers may be hired or fired only at the beginning of january. Vart production using overtime. Your solver setup will be graded.

CHASE aggregate production plan with a CONSTANT worldorce. Workers may be hired or fred only at the beginning of January Vary production using overtime. Your Solver setup will be GRADED (20 point January 5000 February 6000 March 8000 April 10000 May 12000 June 3000 July 4000 August 8000 September 3000 October 12000 November 6000 December 3000 400 5000 8000 8000 10000 12000 8000 4000 6000 8000 12000 6000 3000 For Age Pro 000 0004 Mar 000 10000 2000 Ane 1000 4000 go 0000 D. 12000 ory to 400 OD 0000 3000 od 32000 1000 4000 6000 1000 coats 0000 3000 low Co 40 ingust 41 2 Heng Cont COM Oros Total Plan 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.xls" 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 insort 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