Prescott Industries transports sand and stone extracted from its open-pit mines located inOdessa and Bryan to its concrete block manufacturing facilities in Abilene, Tyler and SanAngelo. For the capacities, locations, and shipment costs per truckload shown in thetableau below, determine the shipping pattern that will minimize transportation costs. What arethe estimated transportation costs associated with this optimal allocation pattern?SourceOdessaBryanDemandSourceOdessaBryanAbilene$90Demand$454,500Abilene$90$45DestinationTyler4,500$25$90Fill in the tableau below by indicating the optimal number of shipments from a source to adestination in each cell. (Enter your responses as whole numbers. A response of "0" isequivalent to no shipments being planned.)The corresponding optimal total cost is $8,400DestinationTyler$25$90San Angelo$758,400$506,100San Angelo$75$50Capacity6,1008,40010,600Capacity8,40010,600(Enter your response as a whole number.)

We formulate the table in Excel as shown below:

Answered: Prescott Industries transports sand and…

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

What do the authors mean when they talk about the idea that logistics is boundary spanning?
Why did Singapore have an advantage in shipping out COVID-19 vaccines? O They locked down borders quickly, which means an available workforce to manage the supply chain. Their large geography allows for plenty of warehouse storage space flexibility. O Their strategic location allows for reach of a significant portion of the global population with short flights. Their tropical location means that the vaccines have less chance to freeze.
6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle, which ship their production to four demand centers, with the transportation costs indicated in the following table. Using the northwest corner method and stepping stone find the optimal solution. Boston Dallas Seattle Demand 1 $3 $6 $1 20 2 $5 $8 $9 60 3 $7 $5 $7 30 4 $4 $2 $3 40 Capacity 50 50 50 150
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…
Please solve this Optimization problem using VAM method manually
An auto compant currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached Using the northwest-corner method, determine the initial allocated quantity for eachshipping route as well as the overall cost.

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