Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use Excel's Solver and include screenshots were needed! Thank you Assume a restaurant in Los Angeles has become popular nationwide over the years and

Please use Excel's Solver and include screenshots were needed! Thank you

Assume a restaurant in Los Angeles has become popular nationwide over the years and has started distributing its pasta and sauces to gourmet food stores around the country. It has set up a centralized facility in Los Angeles and has engaged the services of a transportation company to ship its items. The transportation company has a complex network, based on the consignments of several small businesses it carries. The cost (in dollars for 5 crates) of shipping between pairs of different cities in the Westward direction is shown below. If no information is available, it means that path is either not possible or not relevant. The restaurant owner wants to find the least expensive way to ship 5 crates to Omaha, Nebraska, which has emerged as the biggest consumption point.

From\To Cleveland Columbus Detroit Indianapolis Chicago St. Louis Omaha
  1. Los Angeles
80 90 - 180 250 - -
  1. Cleveland
- - 60 100 120 - -
  1. Columbus
- - 70 80 95 340 500
  1. Detroit
- - - - 70 - 400
  1. Indianapolis
- - - - - 250 -
  1. Chicago
- - - - - 180 300
  1. St. Louis
- - - - - - 200

Show how the above problem can be represented by a network model. Formulate a linear programming model in Excel with decision variables, constraints, and the objective function. Use Solver in Exel to find the optimal solution and provide an interpretation for the managers of the restaurant in Los Angeles. (Hint: It would be helpful to set the decision variables as binary i.e., 0 or 1 in the constraints in Solver.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Management Information Systems

Authors: Ken Laudon, Kenneth C Laudon

10th Edition

0133033090, 9780133033090

More Books

Students also viewed these General Management questions

Question

7. How can an interpreter influence the utterer (sender)?

Answered: 1 week ago

Question

8. How can an interpreter influence the message?

Answered: 1 week ago