

Excel optimization
Please formulate the problem, include decision variables, type
formulas for constraints, and optimize your solution using solver.
When face a new scenario, please use a new sheet in Excel. You may
use other tools in Excel for forecasting.
Show transcribed image text Distribution Center (DC) Location Annual Output 250 Tons Indianapolis, IN Pittsburgh, PA 130 Tons Rochester, NY 235 Tons Table 1 Distribution Center Annual Output
Distribution Center (DC) Location Annual Output 250 Tons Indianapolis, IN Pittsburgh, PA 130 Tons Rochester, NY 235 Tons Table 1 Distribution Center Annual Output





