Prepare an aggregate plan for the coming year assuming that the sales forcast is perfect Use a spreadsheet Bradford Manufacturing in the spreadsheet an area has been designated for your aggregate plan solution. Supply the number of packaging lines to run and the number of overtime for each quater. You will need to set up the cost calcuations in the spreadsheet.You may want to try using Excel Solver to find a solutions remember that your final solution need an interger number of lines and an interger number of overtime hours for each quaters (solutions that requires 8.9134 lines and 1.256 hours of overtime and not feasible).