Modify the original Grand Prix example as follows. Increase the demands at the regions by $200$ each, so that total demand is well above total plant capacity. However, now interpret these $$demands$$ as $$maxi$-$ mum sales,$$ the most each region can accommodate, and change the $$demand$$ constraints to become $$#$$ constraints, not $$$$$ constraints. How does the optimal solution change? Does it make realistic sense? If not, how might you change the model to obtain a realistic solution? $($SHOW WORK IN EXCEL, SHOW FORMULAS AND SOLVER PARAMETERS, AND GIVE CONCLUSION STATEMENT$)$

Figure $5\mathrm{.}3$ Transportation Model