Modified Supply Costs - Using the EXCEL solverexample what is the optimal solution if thesupply costs are changed as follows: P1 to W1= $3.75 and W2 to C2 = $0.85. All other datais the same as in Slide 35 Lecture-2.O936200O 6825001020000O 1092500O 749000 NETWORK FLOW OPTIMIZATION - EXAMPLE• Distribution network for a single productTwo production plants P1 and P2Plant P1 has unlimited supply capacity,Plant P2 has a supply capacity of 60,000 units/yearProduction cost is the same at both plants.Two warehouses W1 and W2 with identical warehouse handling costsand both having unlimited capacity.• Three market areas C1, C2 and C3 with demand of 50000, 100000and 50000 units/year.• Unit transportation costs:W1W2Plant →→ WarehouseP1P2$0 $4$5$2Warehouse →→ Market CenterC1C2C3$3$4$5$2$1$2

Answered: NETWORK FLOW OPTIMIZATION - EXAMPLE .…

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

20# The Great Bear Lodge is a hotel with an adjoining indoor waterpark and indoor minature golf center. The hotel sells packages which include overnight hotel stays with waterpark passes and minature golf passes. The hotel also has a plicy of selling daily passes to the indoor waterpakr and daily passes to the indoor minature golf center (in other words people do not need to stay at the hotel to use the indoor waterpark or indoor minature golf center.) Hotel guests may also choose to reserve just a hotel room without purchasing the waterpark or minature golf center passes. Great Bear Lodge is offering an incentive for the month of April. They are offering a package in which guests who reserve an overnight stay with the waterpark pass package will receive a free pass to the minature golf center. The total price for this package is $225 per night. The typical pricing for each of these sold independently are: One night hotel stay: $180, Daily Waterpark pass: $90, Minature Golf…
4 A local authority operates over a large geographical area. The Education Department is responsible for ensuring that stocks of a certain item are kept for distribution to schools through the area on request. In order to try to ensure supplies reach the schools promptly, the department currently operates two store warehouses, which operate independently of each other. The department is trying to assess the pros and cons of merging the two store warehouses and offering a centralised facility. For one item under consideration demand is 250 items per annum via Store A and 100 items per annum via Store B. Order costs are £10 at Store A and £11 at Store B, with holding costs 20 per cent of stock value. The item costs £4 per unit. (a) Calculate the impact on costs if the two stores merge and place combined orders for this item. (b) What other factors would you want to take into account before making a decision as to whether or not to merge the two stores?
What is task logistics manager?
Q2) (a) A Missouri job shop has four departments--machining (M), dipping in a chemical bath (D), finishing (F), and plating (P)-assigned to four work areas. The operations manager, Mary Marrs, has gathered the following data for this job shop as it is currently laid out. It costs $0.50 to move 1 workpiece 1 foot in the job shop. Determine cost of material handling in the current layout. Further, suggest a revised layout that has the lowest material handling cost. 100s of Workpieces Moved Between Work Areas Distances Between Work Areas in Feet M D F P M D F P M 18 2 20 12 8 4 2 6. 10 F 18 4
• Use this information for the question below. Low-Grade Copper Ore $571 per Ton High-Grade Copper Ore $843 per Ton Coloma Cooper Incorporated is able to produce $640 worth of copper from one ton of low-grade copper ore. Because of its higher copper content, Coloma can produce $940 worth of copper from one ton of high-grade copper ore. A mining company is offering to trade 7,250 tons of low-grade copper ore for 5,000 tons of high-grade copper ore. Assuming Coloma currently has 5,000 tons of high-grade ore, what should it do?
Consider the following distribution system: Single product. Two plants, referred to as plant p1 and plant p2. Plant p2 has an annual capacity of 40,000 units. The two plants have the same production costs. • • Two existing warehouses, referred to as warehouse w1 and warehouse w2, have identical warehouse handling costs. • Three markets areas, c1, c2, and c3, with demands of 50,000, 100,000 and 50, 000, respectively, Table 1 provides distribution cost per unit. For instance, distributing one unit from plant p1 to warehouse w2 costs $5. Convert the following diagram into the table. No need for any calculation. Facility warehouse w1 W2 p1 2 3 p2 2 0 c1 3 5 c2 3 2 C3 4 3
a) b) Cargo Statistics (Freight Weight Tonne) Source: Port Klang Authority Official Portal, 2018 Based on the above table: c) Cargo Statistics (Freight Weight Tonne) Year Dry Bulk Liquid Bulk General Container Total 109,658,732 122,004,592 2005 8,648,931 5,291,150 7,989,319 87,729,332 2006 8,499,114 5,652,325 7,879,086 99,974,067 2007 7,651,197 5,443,261 2008 7,501,160 5,618,335 9,072,372 130,156,643 152,348,510 2009 4,947,486 5,778,601 7,690,757 9,048,023 113,372,115 135,514,596 119,276,676 137,693,520 6,398,369 8,614,812 147,081,483 170,957,449 7,751,074 9,829,213 166,576,695 194,167,667 197,907,084 2010 8,862,785 2011 10,010,685 2012 10,010,573 7,396,956 10,373,165 169,824,390 2013 10,531,812 8,063,651 2014 10,327,287 6,212,566 9,425,756 191,323,740 217,289,349 2015 10,140,564 4,929,554 9,223,965 2016 7,281,820 9,972,322 11,246,909 170,436,528 200,278,901 195,548,521 219,842,603 207,488,632 235,588,801 10,846,027 2017 10,623,637 6,547,363 8,318,739 186,145,852 211,635,591 List five…
Write finctional and non function requirements for Location based service
Q1. Explain how the principle of compatibility in retail location will assist yourbusiness. Note: it is important that you consider using examples when responding to this question.
What are the four advantages to centralized shipping and receiving? SUBJECT: Facility Design and material handling
Answer Question 2. Book: Essentials of Service Marketing Wirtz, J., & Lovelock, C. (2018). Essentials of services marketing (3rd ed.). Essex, England: Pearson. Case 6: The Accra Beach Hotel: Block Booking of Capacity During a Peak Period, located in the textbook: 2. Identify the various market segments currently served by the hotel. What are the pros and cons of seeking to serve customers from several segments?
Pls help me answer the items here. Thank you.

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