4. A company imports goods at two ports: Philadelphia and New Orleans. Shipments of oneproduct are made to customers in Atlanta, Dallas, Columbus, and Boston. For the nextplanning period, the supplies at each port, customer demands, and shipping costs per casefrom each port to each customer are as follows:CustomersPortPhiladelphiaNew OrleansDemandAtlanta211400Dallas623200Columbus652000Boston271400Port Supply50003000a. Develop a network representation of the distribution system (transportation problem).b. Develop a linear programming model for the problem; be sure to define the variables inyour model.c. Solve the linear program to determine the optimal solution.d. Discuss the distributions from the Port to the customers.

PortCustomersPort SupplyAtlantaDallasColumbusBoston Philadelphia26625000 New Orleans12573000…

Answered: 4. A company imports goods at two…

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

The HERCULES company's Process Manager should decide the location of his company's facilities. He has come up with 4 options in 4 communities. The table below shows fixed (land purchase costs, taxes, insurance, machinery, building erection costs, etc.) and variable costs (wages, materials, transportation costs, etc.) for each option Community Issues: A B с D Fixed costs (Annual) $ 150,000 $ 300,000 $ 500,000 $ 600,000 Variable costs (per unit of product) $ 62 $ 38 $ 24 $ 30 (a) Calculate the range of output for which each community minimizes its production costs. (b) If the expected demand for the product is 15,000 units per year, in which community would you advise the process manager to locate his company's plant?
a. Goods have to be transported from sources S1, S2 and S3, to destinations D1, D2 and D3. The transportation cost per unit capacities of the sources and requirements of destinations are given in the following table: Destination Source S1 S2 S4 D1 8 15 3 150 D2 5 10 9 Demand 80 50 Determine the transportation schedule so that cost is minimized. D3 6 12 10 Supply 120 80 80
a-) find the initial solution using the Vogel's Approximation Method (VAM). and Find the optimal solution.
The Maytubig Water Company purifies drinking water in Luzon and Mindanao, which it plans to distribute to typhoon-hit areas in Tacloban, Ilo-ilo, Ormoc, Northern Cebu, and Eastern Samar. The Luzon filtering plant is expected to produce 85,000 liters and the Mindanao filtering plant is expected to produce 50,000 liters a week. These are estimated weekly water requirement according to DSWD: WHOLESALER LITERS OF PURIFIED WATER Tacloban Ilo-ilo. Ormoc Northern Cebu Eastern Samar 45,000 25,000 40,000 12,000 20,000 Here is the cost of shipping 1,000 liters of purified drinking water from each filtering plant to each affected area: PLANT WHOLESALER COST Luzon Tacloban P 20 Luzon llo-ilo 30 Luzon Ormoc 50 Luzon Northern Cebu 60 Luzon Eastern Samar 35 Mindanao Tacloban 50 Mindanao Ilo-ilo 60 Mindanao Ormoc 20 Mindanao Northern Cebu 30 Mindanao Eastern Samar 70 Which of the following is true about the optimal solution for the problem? n O None of the above. O Northern Cebu will be short of…
For the following transportation problem find the optimal Solution by using :Multipliers method Q:- For the following transportation problem find the optimal Solution by using Multipliers method: 2 3 supply 2.5 1.7 1.8 1 100 300 400 2.8 1.8 1.4 2 200 300 500 demand 300 300 300
1. Ethan Steel, Inc. has two factories that manufacture steel components for two different rail projects located at two different sites. They would like to determine the number of steel components they need to transport from each factory to each project site. The demand for the steel components for the two projects, Project A, and Project B are 3000, and 4000, respectively. The production and shipping details are as below:Production details:Factory 12Maximum capacity 20005000Shipping details (with per-unit shipping cost in dollars):Project Factory A B 178265Develop a linear programming optimization model to determine the distribution plan (from factories to projects) that minimizes the total transportation cost. (Do NOT solve the model.)
The City of Boston is taking bids on four construction projects. Four companies have made the bids as shown in the following table: Company 1 2 3 4 Bids Project 1 Project 2 Project 3 Project 4 $4000 $5000 $4000 - $3000 $2000 $4000 $4000 $5000 a. Each bidder can be assigned only I route. Use the assignment method (Hungarian Method) to minimize the cost of assigning the four project contracts.
What Companies Use JIT Inventory Management?
A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs. The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are: PLANT CAPACITY (PIECES PER WEEK) WAREHOUSE 1 2 3 400 800 600 A B C D DEMAND (PIECES PER WEEK) 900 200 400 300 The estimated ship cost per box for the various routes are: ΤΟ FROM A B C D 1 5 7 9 12 2 10 7 2 3 3 8 9 6 4 Row/Column Opportunity Cost Demand Row/Column Cell Total Cost Opportunity Cost Cost of the above Test of unallocated Cells allocation Supply Amount char
The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown in Figure. What is the total cost of the optimal solution?
like this fill the boxes
1-ATTA & SONS OPTIMAL SOLUTION

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