Change the maximum sales constraint to a minimum sales constraint and use Solver to find the optimal solution (6 points) Do not forget to provide your spreadsheet showing your results. What do you find? In particular, are all the constraints satisfied? (6 points) Now, make the values in row 23 one quarter of their current values and rerun Solver (provide this new worksheet) (6 points). What do you find? In particular, are all the constraints satisfied? (6 points) Problem 19 (22 points) First, include two more months so that the planning horizon is now 8 months. You have to assume and values for the production costs, production capacity, demand and storage capacity for months 7 and 8 (for example you can just use the values of these variables in month 6). Has this modification changed the optimal production in month 1 (from the book this was 5,000) (11 points). Do not forget to provide your spreadsheet showing your results. Second, reduce the planning horizon to 4 months. Has this modification changed the optimal production in month 1 (from the book this was 5,000) (11 points). Do not forget to provide your spreadsheet showing your results.

Change the maximum sales constraint to a minimum sales constraint and use Solver to find the optimal solution ( 6 points) Do not forget to provide your spreadsheet showing your results. What do you find? In particular, are all the constraints satisfied? (6 points) Now, make the values in row 23 one quarter of their current values and rerun Solver (provide this new worksheet) ( 6 points). What do you find? In particular, are all the constraints satisfied? ( 6 points) Problem 19 (22 points) First, include two more months so that the planning horizon is now 8 months. You have to assume and values for the production costs, production capacity, demand and storage capacity for months 7 and 8 (for example you can just use the values of these variables in month 6). Has this modification changed the optimal production in month 1 (from the book this was 5,000) (11 points). Do not forget to provide your spreadsheet showing your results. Second, reduce the planning horizon to 4 months. Has this modification changed the optimal production in month 1 (from the book this was 5,000) (11 points). Do not forget to provide your spreadsheet showing your results