Network Design in Supply Chain and using a solver in Excel

I’m working on a Business exercise and need support.

• 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

• Questions

– (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

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support
Posted in Uncategorized