please show work in excel

2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes: A level production rate, back orders are allowed and are charged at the rate of $15 per unit per month, inventory holding costs are $2 per unit per month in average inventory, regular time cost is $12 per unit and beginning inventory is zero. Show the aggregate plan and determine the cost of this plan. (60 pts) Month 1 Forecast 420 520 340 550 10 11 1 12 85 13 10 14 ur 15 330 16 85 470 400 2355NTE