Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures thewashers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the followingnumbers of washing machines to be produced at each location:New York CityFort WorthSan DiegoMinneapolisBindley has three plants that can produce the motors. The plants and production capacities are105,000135,000120,000BoulderMaconGary60,00070,000105,00050,000Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they wereproduced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit(Shipment will be made in lots of 1,000)PRODUCED AT NEW YORK CITYBoulder142212MaconGarySHIPPED TOFORT WORTH182614SAN DIEGO2514MINNEAPOLIS131422Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant andhow many motors should be shipped from each plant to each destination.a. Develop a transportation grid for this problem. Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant andhow many motors should be shipped from each plant to each destination.a. Develop a transportation grid for this problem.New York City Fort WorthFrom/ToBoulderMaconGaryRequirementsCandidate SolutionBoulderMaconGaryTotal suppliedb. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.)ProfitSan DiegoBoulderMaconGaryTotal profitMinneapolisSupplyTotal Shipped

The transportation problem is a classic optimization problem in operations research that deals with…

Answered: Bindley Corporation has a one-year…

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

Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
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…
DryIce, Inc. is a manufacturer of air conditioners that has seen its demand grow significantly. The company anticipates nationwide demand for the year 2010 to be 180,000 units in the South; 120,000 units in the Midwest; 110,000 units in the East; and 100,000 units in the West. Managers at DryIce are designing the manufacturing network and have selected four potential sites – New York, Atlanta, Chicago, and San Diego. Plants could have a capacity of either 200,000 or 400,000 units. The annual fixed costs at the four locations are shown in the table below, along with the cost of producing and shipping an air conditioner to each of the four markets. Where should DryIce build its factories and how large should they be? New York Atlanta Chicago San Diego Annual fixed cost of 200,00 plant $6 miilion 5.5 million 5.6 million 6.1 million Annual fixed cost of 400,000 $10 million $9.2 million 9.3 million 10.2 million EAST $211 $232 $238 $299 SOUTH $232 $212…
Problem 4
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. i Demand Forecast Component A B C Time Standard Processing (hr/unit) 0.04 0.20 0.05 Setup (hr/lot) 1.0 4.4 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected 16,000 17,000 10,000 12,000 18,000 24,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
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 O None of the above 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 The distribution cost for the optimal solution is: OP 3,250,000 OP 3,275,000 OP 3,325,000 45,000 25,000 40,000 OP 3,430,000 12,000 20,000
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
Mazoon, a four-wheeler company, is a leading company in Shalala manufacturing chassis of bus/lorry, in 300 acres of land with 200 employees. The annual production capacity of the plant is 40,000 chassis. The market research department projected its future demand to be 1.5 times the present capacity of the plant. So, the company took a decision to set up another plant in Nizwa with a capacity of 100,000 chassis. It is in the process of procurement of the required land of 800 acres. The projected number of employees in the new factory would be 1,000. The productivity of any company mainly depends on the type of layout that is used to carry out the activities to produce the product. So, the industrial engineering department of the exiting company is given the task of design the right type of layout for the new company. All the sections of the automobile company will not have the same type of layout. The final assembly of chassis is done on a powered conveyer belt. This part of the company…
What drove Amazon to have their own air transportation services in house is: A- Number of hubs B- Prices and availability during high seasons C. Maintenance schedules D. Crew schedules.
Jason Company manufactures plastic products at three locations in Malaysia: Skudai, Taiping, and Ujok. The company needs to supply the products to three clients in Penang, Kuantan, and Melaka. The production capacities of the plants are given below. Find the optimal solution using stepping stone method. Client Plant (То) Supply (From) Penang Kuantan Melaka RM50 RM40 RM60 Skudai 4000 RM30 RM45 RM40 Taiping 3000 RM60 RM35 RM30 Ujok 3000 Demand 2000 4500 3500 10000
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