1. 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. You may want to try using the excel solver to find a low cost solution. Remember that your final solution needs an integer number of lines and an integer number of overtime hours for each quarter. (Solutions that require 8.9134 lines and 1.256 hours of overtime are not feasible.) It is important that your spreadsheet calculations are set up so that any values in the number of lines and overtime hours rows evaluates correctly.

(Redo question 1 with the following revisions. You do not need to solve the questions using linear programming. All you need to do is to set 11 lines and one hour of overtime for each quarter.
	The overtime pay rate is $30/hour in Q1 and Q2, $32 in Q3 and $34 in Q4.
	It is possible to run up to three hours of overtime each day.
	Safety stock is four weeks of supply.
	The lines are run for 7 hours each normal shift in Q1 and Q2, and 8 hours in Q3 and Q4.