Childfair has three factories that manufacture folding strollers and ship them to four distribution centers. Plants 1,2 and 3 produce 12, 17,Il shipping units per month. Each distribution center requires 10 shipping units of cargo per month. The shipping cost per shipping unit is $1 permile.The journey from each factory to each distribution center is shown in the table below.Table 1. Distance from factory to distribution centerDistance to Distribution Center (miles)2.34.Factory 18001300400700Factory 2110014006001000Factory 36001200800900Describe the problem in a spreadsheet and use Solver to get the optimal solution.

Transportation and SCM are important aspects for any company. A huge chunk of amount is spent by…

Answered: Childfair has three factories that…

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

On a daily basis, the Vampire Van is dispatched from Maplewood Hospital to pickup blood and platelet donations made at its local donation centers. The distances in miles between all locations may be found in Table.a. The Vampire Van travels from Maplewood Hospital (A) to (B) to (C) to (D) to (E) and then returns to the hospital (A). What is the total number of miles that the van must travel using this route?b. Using Maplewood Hospital as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?c. Using Valley Hills (E) as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?
Find the shortest route for a delivery truck going from the PLANT, to the warehouse, then delivery to points 3, 4, and 5 (can be interchanged), and back to the plant again. Plant 1 100 200 50 3 200 100 40 5 150 100 100 6 Warehouse
A county wants to build one centrally-located processing facility to serve the county's four recycling drop-off locations. The four drop-offs have characteristics as given in the table below. What is the approximate center of gravity of these four locations? (Round answer to two decimal places.) Location Drop-off point A Drop-off point B Drop-off point C Drop-off point D O A. (22.46, 25.17) O B. (8.00, 10.00) O C. (1,370.00, 730.00) O D. (11.25, 11.25) O E. (13.70, 7.30) X-coordinate 5 8 41 7 Y-coordinate 7 275 10 Tonnage 20 30 20 30
A company is considering four modes of transportationfor its shipments. It plans to ship 32 pallets weighing500 pounds each from Salt Lake City, Utah to Reno,Nevada at a distance of 518 miles. What is the best way tomake these shipments given the following information?
a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this mill. All mileage references use Browns Town as (0,0). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000
2. Metropolitan Manila has four incinerator sites for processing solid waste. There are five garbage collection areas within the metropolis. The city wants to determine the least-cost method of disposing of its trash. Each incinerator is characterized by an operating cost for processing each ton of waste and also a cost for transporting each ton of waste is summarized in the table below: Collection Incinerator Site Area 1 2 3 4 50 120 110 60 B 100 55 90 70 60 40 80 65 90 75 85 110 80 100 95 65 Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each, site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000 tons. There are 4,000 tons of waste generated at area A, 8,000 tons at area B and 5,000 tons each at areas C and D, each week. A total of 25,000 tons of waste each week are generated from all five areas.
GANIER RIDGE EAST LOT-> ACCESS TRAIL
Travelling Salesman Problem (TSP); Given the following distance matrix, use the nearest neighbor (NN) heuristic to find a route that starts from the warehouse (W), visits each customer only once, and finishes at the warehouse to minimize the distance traveled. What is the route and the corresponding distance? Distances W 1 2 3 4 in miles 18 57 27 50 18 0 65 29 61 57 65 0 36 99 3 27 29 36 0 76 4 50 61 99 76 Route=W-1-3-2-4, Distance=182 miles Route=W-3-1-2-4-W, Distance=270 miles Route = W-3-1-2-4, Distance=220 miles Route=W-1-3-2-4-W, Distance=232 miles Route=W-1-3-4-2, Distance=272 miles 1, 2.
1. Central Construction Company moves materials between three plants and three projects. Project A requires 72 truckloads each week, project B requires 102, and project C requires 41. Plant W can supply 56 loads, plant X can supply 82, and plant Y can supply 77. Using the cost information given in the following table, compute the optimum transportation cost using the stepping stone method. COST INFORMATION From To Project A To Project B To Project C Plant w P 4.00 8.00 8.00 Plant X 16.00 24.00 16.00 Plant Y 8.00 16.00 24.00
Chapter 9. Fresh Egg Delivery service brings fresh eggs from two different egg suppliers to two Farmer's Markets in the North San Antonio area. With the costs of fuel rising to $5 per mile driven by the delivery trucks, whether they are empty or loaded, the owner of Fresh Egg wants to make sure that he is minimizing his costs of transportation. The distance in miles from Egg Supplier A to the First Farmer's Market is 5 miles and to the Second Farmer's Market is 6 miles. The distance in miles from Egg Supplier B to the First Farmer's Market is 4 miles and to the Second Farmer's Market is 7 miles. The maximum number of truckloads that Egg Supplier A can provide is 20 truckloads per month, whereas Egg Supplier B can provide 30 truckloads a month. Both the Farmer's Markets have a steady demand of 25 truckloads per month, each. As we can see the total supply available is the same as the total demand available in this system, so applying a simple transportation model can help the Fresh Egg…
The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose lati-tudes and longitudes are shown in Table 13.1, along with the population in each census tract (in thou-sands). Customers will travel from the seven census-tract centers to the new facility when they needhealth care. What is the target area’s center of gravity for the Health-Watch medical facility?
A dynamic distance vector protocol used in the Internet as exterior routing protocol: O OFPF О ВБР O ICMP RIP

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