Given the following cost information, solve for the optimal transportation cost: Use MODI MethodAt the third solution, what is the value of R3?At the third solution, what is the value of K3?How much is the cost of the third solution? Cost of transporting 1 load toPlantProjectProjectProjectProjectProjectProject PlantA BDEСараcityP50 P100 P150 100200505002001005050100200600Y150502002005015075010020010015050250650ProjectRequirement3004503504255004752500w/

Given the following cost information, solve for the optimal transportation cost: Use MODI Method At the third solution, what is the value of R3? At the third solution, what is the value of K3? How much is the cost of the third solution?

Given the following cost information, solve for the optimal transportation cost: Use MODI Method At the third solution, what is the value of R3? At the third solution, what is the value of K3? How much is the cost of the third solution?

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 solve
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B 1 $1.70 $1.90 $1.60 $1.70 2 $1.40 $1.90 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center needed, O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. C. The sum of supply capacities…
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B D $1.90 $1.90 $1.70 $1.60 $1.70 2 $1.40 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. O C. The sum of supply capacities…
Answer the following question based on the image below: 1- state objective function 2- state the constraints
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?
Your fast-food outlet, Burger Queen, has obtained a license to open branches in three closely situated South African cities: Brakpan, Nigel, and Springs. Your market surveys show that Brakpan and Nigel each provide a potential market of 2,500 burgers a day, while Springs provides a potential market of 1,000 burgers per day. Your company can only finance an outlet in one of those cities at the present time. Your main competitor, Burger Princess, has also obtained licenses for these cities, and is similarly planning to open only one outlet. If you both happen to locate at the same city, you will share the total business from all three cities equally, but if you locate in different cities, you will each get all the business in the cities in which you have located, plus half the business in the third city. The payoff is the number of burgers you will sell per day minus the number of burgers your competitor will sell per day. Set up the payoff matrix. O a. Your Competitor B N S Вг 1,5001…
The prices for traveling between five cities in Colorado by bus are given in the table below. Use the edge-picking algorithm to find a low-cost bus route that starts and ends in Boulder and visits each city. Colorado Springs Grand Junction $48 $24 $21 $44 $57 Boulder Denver Boulder $15 Colorado Springs $24 Grand Junction $48 Durango $73 Denver $15 $21 $44 $71 O Boulder-Denver-Colorado Springs-Grand Junction-Durango-Boulder O Boulder-Colorado Springs-Denver-Durango-Grand Junction-Boulder O Boulder-Colorado Springs-Denver-Grand Junction-Durango-Boulder O Boulder-Denver-Colorado Springs-Durango-Grand Junction-Boulder O Boulder-Grand Junction-Colorado Springs-Denver-Durango-Boulder $57 $58 -- $31 Durango $73 $71 $58 $31
Study the scenario below and answer the question that follow. Transcard– an integrated travel card for Johannesburg Metro The Big 5 (South African Black Business Consortium) won ZAR400 Million contract to build and operate the Transcard system in 2013 and have it operating by 2015. The parent corporation of Affirmative Action Group (AAG) International Inc., is a software engineering application maintenance, program management and consulting services company that had extensive experience in overseeing and project managing transport and technology companies to produce integrated system, and had implemented similar systems in In Capetown and Durban. Big 5 supervised four technology and infrastructure companies and their sub-contractors, and provided back-end financial system. The Big 5 companies provided the terminal management system and fare collection equipment; communication systems installation and maintenance; automated fare collection systems; and smart cards and related card…
Please solve this Optimization problem using VAM method manually