Problem $19(15$ 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).(5$ points$)$ Has this modification changed the optimal production in month $1($from the book this was $5,000)(2\mathrm{.}5$ points$).$ Do not forget to provide your spreadsheet showing your results.

Second, reduce the planning horizon to $4$ months. $(5$ points$)$ Has this modification changed the optimal production in month $1($from the book this was $5,000)(2\mathrm{.}5$ points$).$ Do not forget to provide your spreadsheet showing your results.