. . . Read Ch. 5 Exercise 2 "Dryice, Inc." in the textbook 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 : 400,000 South :800,000 Midwest: 300,000 West : 200,000 Production costs, transport costs, and fixed costs of plants are same as those in Table 5-5 in the textbook Questions (1-1) Where should Dryice build its plants and how large should they be? (1-2) How much units should Drylce transport to each market region from each plant? Submit Excel file with answers and all necessary conditions for Solver to run optimization - so that Solver models can be checked . - . . . Read Ch. 5 Exercise 2 "Dryice, Inc." in the textbook 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 : 400,000 South :800,000 Midwest: 300,000 West : 200,000 Production costs, transport costs, and fixed costs of plants are same as those in Table 5-5 in the textbook Questions (1-1) Where should Dryice build its plants and how large should they be? (1-2) How much units should Drylce transport to each market region from each plant? Submit Excel file with answers and all necessary conditions for Solver to run optimization - so that Solver models can be checked