Prepare an aggregate plan for the coming year, assuming that the sales forecast is perfect. Use the worksheet “Bradford Manufacturing” that is in the “19 Sales and Operations Planning” spreadsheet. In the worksheet, an area has been designated for your aggregate plan solution. Supply the number of packaging lines to run and the number of overtime hours for each quarter. You will need to set up the cost calculations in the spreadsheet.