Consider the transportation problem having the following data:Destination:Source123Demand133243Unit Cost (S)274333839624252Supply52323a. Draw the network representation of this problem.b. Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimalsolution.

Answered: Consider the transportation problem…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

solve the following LP MODELS
2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 Factory 2 A 8 9 400 10 6 12 8 190 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ?
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
J 2 An electronics store wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given in the accompanying table. Develop a model to find the best location, assuming that straight-line distances can be used between the locations. Experiment with the model by testing each of the possible best solutions, included, to find the best location. Click here to view the data for the store locations and annual numbers of truckloads. Click here to view some possible best solutions. The best location is at____. (Type an ordered pair. Round each coordinate to the nearest integer as needed.)
b.FIND THE OPTIMAL SOLUTION: Use the least optimal initial basic feasible solution from (a) as your starting point to find the optimal solution. c. Draw a network showing the quantities obtained in the final iteration and the optimal value of z.
Prescott Industries transports sand and stone extracted fromits open-pit mines located in Odessa and Bryan to its con-crete block manufacturing facilities in Abilene, Tyler, and SanAngelo. For the capacities, locations, and shipment costs pertruckload shown in the Figure 13.13, determine the shippingpattern that will minimize transportation costs. What are theestimated transportation costs associated with this optimalallocation pattern?
A company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation cost
Jason Company manufactures plastic products at three locations in Malaysia: Skudai, Taiping, and Ujok. The company needs to supply the products to three clients in Penang, Kuantan, and Melaka. The production capacities of the plants are given below. Find the optimal solution using stepping stone method. Client Plant (То) Supply (From) Penang Kuantan Melaka RM50 RM40 RM60 Skudai 4000 RM30 RM45 RM40 Taiping 3000 RM60 RM35 RM30 Ujok 3000 Demand 2000 4500 3500 10000
A valve manufacturer is considering three alternative locations for a new plant for manufacturing ball valves for oil and gas industry. Since the plant ships nationwide, revenue is assumed the same regardless of plant location. The estimated annual fixed and variable costs for each site is shown in TABLE Location Costs A B C Fixed (RM) 700,000 1,000,000 $1,500,000 Variable (RM) $28 $18 $12 Identify the range of output for which each location provides the lowest total cost. Show necessary graph and calculation used in the analysis. Discuss on the finding(s).
(C) to four distribution centres. The following table shows the cost per (in RM), capacity, and demand for the company. To Distribution Centre Сарacity From F G H 8. 7 11 10 150 11 8. 9. 11 100 Demand 70 60 90 30 (a) Find an initial solution. (b) Determine an optimal solution and the minimum transportation cost. (c) Is there an alternative optimal solution? 5. Man Yee Company manufactures printers in two factories and ships them to three distribution centres. The following table shows the cost (RM) per um capacity, and demand for the company.
An auto compant currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached Using the northwest-corner method, determine the initial allocated quantity for eachshipping route as well as the overall cost.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS