A salesman for Healthproof Pharmaceutical Company travels each week from his office in Atlanta to one (1) offive (5) cities in the Southeast where he has clients. The travel time (in hours) between cities along interstatehighways is shown along each branch in the following network:5642347513A. Determine the shortest route from Atlanta to each of the other five (5) cities in the network.B. Assume that the network now represents six (6) different communities in a city. The local transportationauthority wants to design a rail system to connect all six (6) communities with the minimum amount oftrack. The miles between each community are shown on each branch. Develop a minimal spanningtree for this problem.CO2.LO2.LO

Answered: A salesman for Healthproof…

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

please do it in excel BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. Note:One image is of the data and the other image is option 1 to solve the exercise.
Moonlight Company aims to minimize the distance travelled in miles from the office to its construction sites. Its objective function is provided below. Using the objective function below, draw the network for Moonlight Company and find the shortest route. At the bottom of your drawing, write the shortest route.
Describe how a transportation planner could use a routing guide.
(2) Find an optimal solution for the following transportation problem. Town To Valley FROM Madison (M) Yonkers (1) Pittsburgh (P) Demand FROM Madison (M) Yonkers Pittsburgh FROM 3.50 Madison (M) Yonkers FROM $8 350 Madison (M) Yonkers (1) Pittsburgh $5 SIS 350 Valley (5) $8 $5 $15 Using the Stepping-Stone method to find an optimal plan. Tol Valley Town Junction (7) $8 Pittsburgh Demand 350 Part (a) Find the new TC= $5 $15 50 350 The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), and its total cost = 350($8) +50($10)+150($12) +250($4)+200($11) +250($14) = $11.800, 150 $8 200 $5 The improvement indices below are determined as follows: Supply row M first, then sows Y and P) MJ: 9-4+12-10-2 400 MB: 6-11+12-10=-3 rv: 5-12+10-8-5 600 PP: 15-14+11-12-10-8-2 PT: 6-14+11-12- PA 11-14+11-4-4 Demand 350 200 the "most negative index" We focus on cell PT (index=-9). Its closed path is: PT to PB to YB to YT, and back to PT. To increase the…
solve the following LP MODELS
SOLVE THE FOLLOWING PROBLEM OF TRANSPORTATION.Fertimex manufactures fertilizer for general application in 3 different plants located in Acayucan, Ver., Celaya, Gto. andSaltillo, Coah. and sends the final product to 4 different warehouses, 1,2,3 and 4. Since some manufacturing operationshave been around longer than others, there are different production costs at different plants. (TheNewer plants use more modern and up-to-date processes that result in lower costs of ownership.production). The table shows the production costs in pesos per ton and the capacity ofproduction in tons of each plant: Table 1 The requirements in tons of warehouses 1, 2, 3 and 4 are 300, 450, 500 and 600, respectively. Due toSince each warehouse operates separately, the sales prices per ton differ a little, being $62.00,$63.00, $64.00 and $64.00, respectively. How Fertimex managers want to maximize profitscompany totals; for this they must consider the transportation costs associated with the shipment of the…
Answer correctly on excel and show workings
The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
Intermodal Management is a key element to any business where the transportation of freight is critical to the organization. a. Why has the development of a global economy created the need for an effective intermodal transport system? b. The pricing of intermodal movements has based on the combination of the modes of transportation that used for the shipment. What example can you find to support the statement? c. Moving freight from one location to another presents many challenges. Give two (2) of those challenges with recommendations to reduce the impact of each one.
Please help me with part b
1-Comment on the enablers and obstacles for intermodalism considering different geographic zones in comparison. 2-Compare the current situation in terms of inland container terminals/freight villages in Turkey, Europe and United States of America. a) Brief information about the current situation of such interchange points b) Comparison in terms of infrastructure, investment, handling volumes, superstructure
The National Post Company has established various truck routes around Leb- anon over which it ships parcels. The holiday season is approaching which means a dramatic increase in the number of packages that will be sent. The company wants to know the maximum flow of packages it can accommodate, in tons, from station 1 to station 7. The network of routes and the flow capac- ities, in tons of packages per day, along each route are shown in the following network: 6 5 1 2 2 6 3 3 7 4 2 4 6 4 2 3 5 9 2 6 4 0 0 0 7 a. Determine the maximum tonnage of packages that can be transported per day from station 1 to station 7, HAND b. Indicate the flow along each branch.

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