A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of $100$ units per month will be used. Back orders are allowed, and they are charged at the rate of $6$ per unit per month. Inventory holding costs are$3$ per unit per month in ending inventory. Determine the cost of this plan if regular time cost is $25$ per unit and beginning inventory is zero. No overtime or subcontracting is used. A forecast for the next six periods is provided below: Fill out the blank space of the Excel sheet ASAP. Thank you. A manager has prepared a forecast of expected aggregate demand for the next six months. Dev are charged at the rate of $ $6$ per unit per month. Inventory holding costs are $ $3$ per unit per mo Click to open: $$ Steps for completion: $1.$ Select the link that opens a pre$-$populated spreadsheet containing the aggregate planning tempWCK HERE TO SAVE YOUR WORK