2. Aggregate Planning: Use the aggregate planning example excel file and the aggregate planning example presentation on slides 27-31, do the following to reflect the following additional requirements a) management wants a chase strategy where production levels can vary that ending inventory at Month 6 =0 that ending backlog at Month 6 =0 b) management wants a level strategy but would like to identify the optimal production level that ending inventory at Month 6 =0 that ending backlog at Month 6 =0 c) management would like to include the labor balance and labor capacity into the planning problem as follows: You are told that there are 4 workers to start with but you may hire or layoff people if necessary during each month. Hiring a worker costs $500 per worker and laying off costs the company $1000 per worker. Each worker can work 160 hours per month on a regular basis and can also do overtime up to 32 hours per month. Production of 1 unit requires 3 hours of a worker's time. Submit your Excel computation file along with your HW. 2. Aggregate Planning: Use the aggregate planning example excel file and the aggregate planning example presentation on slides 27-31, do the following to reflect the following additional requirements a) management wants a chase strategy where production levels can vary that ending inventory at Month 6 =0 that ending backlog at Month 6 =0 b) management wants a level strategy but would like to identify the optimal production level that ending inventory at Month 6 =0 that ending backlog at Month 6 =0 c) management would like to include the labor balance and labor capacity into the planning problem as follows: You are told that there are 4 workers to start with but you may hire or layoff people if necessary during each month. Hiring a worker costs $500 per worker and laying off costs the company $1000 per worker. Each worker can work 160 hours per month on a regular basis and can also do overtime up to 32 hours per month. Production of 1 unit requires 3 hours of a worker's time. Submit your Excel computation file along with your HW