please show all steps

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. 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