In this assignment, we revisit the WUWU Problem, which was previously discussed in this week's Lesson $2($specifically in Video $3).$ If you have not done so already, please download the WUWU spreadsheet: it is available for Excel and for LibreOffice.

For the questions below, we will use as our starting point the WUWU $1$ problem, which is found in the WUWU$1$ tab of the spreadsheet $($not the WUWU$2$ tab$).$ As it stands now, the objective function for WUWU$1$ problem has an optimal value of $$6,525\mathrm{.}00.$ Try solving for the problem in its current form: you should get the same value.

The questions below will ask you to modify the parameters of this model, and the model itself, to include new constraints and products.

Part $1$

pontos $0\mathrm{.}5/0\mathrm{.}5($classificado$)$

For the first variation of the problem, we will change the capacity in both our DCs$.$ Please increase the capacity of the Atlanta DC from $200$ widgets to $300$ widgets, and decrease the capacity of the Boston DC from $500$ widgets to $400$ widgets. Solve optimally.

What is the new minimum cost of the optimal solution?