please show steps

Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don't forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optimal production quantity in month 1 ? 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. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don't forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optimal production quantity in month 1 ? 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