network design in supply chain and using a solver in excel
â€¢ Assume that the company now faces the increased demand below (instead of the demand described in the original problem)
â€“ New demand at each market region
â€¢ East : 300,000
â€¢ South : 1,000,000
â€¢ Midwest: 300,000
â€¢ West : 200,000
â€¢ Production costs, transport costs, and fixed costs of plants are same as those in Table 5-6
â€“ (1-1) Where should DryIce build its plants and how large should they be?
â€“ (1-2) How much units should DryIce transport to each market region from each plant?
â€“ Submit Excel files/sheet with all necessary conditions for Solver to run optimization â€“ so that Solver models can be checked