[See] A soft drink manufacturer, Sara Soda, Ltd., has recently begun negotiations with brokers in the areas where it intends to distribute its products.
Question: A soft drink manufacturer, Sara Soda, Ltd., has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, Manager Dave Pepper wants to determine shipping routes and costs. The firm has three plants with capacities as shown below:
Estimated demands in each of the warehouse localities are:
The estimated per unit shipping costs per case for the various routes are
Use Excel and determine the optimal shipping plan that will minimize total shipping cost under these conditions:
- Route Ridge-RS4 is unacceptable.
-
All routes are acceptable.
C. What is the additional cost of the Ridge-RS4 route not being acceptable?
Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document