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…
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. D Demand Forecast Component A B C Time Standard Processing Setup (hr/unit) (hr/lot) 0.04 1.0 0.20 4.4 0.05 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected Optimistic Pessimistic 16,000 10,000 18,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…
Read the scenarios below to answer the following question : After operating from the founder’s garage for three years, the team at Yebo Sauce, a condiment manufacturing business, that is dealing primarily in table sauces, has decided that it is time to expand their operation to the rest of Gauteng province. The implication of this expansion is that they need to introduce wide-ranging supply chain management processes within the business. As the newly appointed head for the logistics part of the operation, your primary focus is to align all employees and managers to the key concepts, processes and implications of adopting the necessary supply chain processes. Sauces & Spices Revenue in the Sauces & Condiments segment amounts to US$486.40m in 2022. The market is expected to grow annually by 3.49% (CAGR 2022-2027). In global comparison, most revenue is generated in China (US$38.24bn in 2022). In relation to total population figures, per person revenues of US$8.01 are generated…
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.
A gold mining area in Lanao contains on average, 1 ounce of gold per ton. Two methods of processing are available; method A costs ₱1.5 M per ton and recovers 90% of gold; method B cost ₱1.3M per ton and recovers 80% of the gold. If gold can be sold for ₱2.4M per ounce, which method is better and by how much?
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