Destination:Source123Demand3243Unit Cost (S)27434333638263842522Supply52323a. 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: Destination: Source 1 2 3 Demand 1 324…

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

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.
Consider an assignment issue that has the following cost table. a. Draw a network representation of this assignment problem.b. Formulate this problem as a transport problem by drawing up the appropriate parameter table.c. Determine the optimal assignment solution using the Hungarian method!d. Use Excel Solver to get the optimal solution.
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
Wiebe Trucking, Inc., is planning a new warehouse to servethe western United States. Denver, Santa Fe, and Salt LakeCity are under consideration. For each location, annual fixedcosts (rent, equipment, and insurance) and average variablecosts per shipment (labor, transportation, and utilities) arelisted in the following table. Sales projections range from550,000 to 600,000 shipments per year.a. Plot the total cost curves for all the locations on a singlegraph.b. Which city provides the lowest overall costs?
Destination Destination Destination Supply Source 1 75 8 320 Source 2 6 160 13120 4. Source 3 6.5 Demand 160 200 240 Based on the transportation table shown, total transportation cost using North- West Corner Method will be: a. 3040 Ob. 4100 O c. 2640 O d. 1920
J 2 PLEASE SOLVE USING EXCEL SOLVER
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.
Solve the attachment

SEE MORE QUESTIONS

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

Destination: Source 1 2 3 Demand 1 324 3 Unit Cost (5) 2 7 4 3 3 3 638 6 3 8 2 4 425 2 Supply S 2 3 523 a. Draw the network representation of this problem. b Display the problem on a spreadsheet and then use the Excel Solver to obtain an optimal solution.