Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced 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.) Macon Gary 100,000 100,000 150,000 PRODUCED AT NEW YORK CITY FORT WORTH Boulder From/To 50,000 Boulder Macon Gary Requirements 20 8 SHIPPED TO SAN DIEGO 12 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem. MINNEAPOLIS 13 New York City Fort Worth San Diego Minneapolis Supply

Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced 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.) Macon Gary 100,000 100,000 150,000 PRODUCED AT NEW YORK CITY FORT WORTH Boulder From/To 50,000 Boulder Macon Gary Requirements 20 8 SHIPPED TO SAN DIEGO 12 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem. MINNEAPOLIS 13 New York City Fort Worth San Diego Minneapolis Supply

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section: Chapter Questions
Problem 100P
See similar textbooks
icon
Related questions
Question

Can you assist me with Chapter 15 Problem 9 everytime I make an attempt I get the formulas mixed up on the excel sheet. Thank you 

Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced 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.) 50,000 100,000 100,000 150,000 PRODUCED AT NEW YORK CITY Boulder Macon Gary From/To Boulder Macon Gary Requirements 7 20 SHIPPED TO FORT WORTH 17 18 SAN DIEGO 12 13 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. *. Develop a transportation grid for this problem. New York City MINNEAPOLIS 13 10 16 Fort Worth San Diego Minneapolis Supply
Transcribed Image Text:Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced 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.) 50,000 100,000 100,000 150,000 PRODUCED AT NEW YORK CITY Boulder Macon Gary From/To Boulder Macon Gary Requirements 7 20 SHIPPED TO FORT WORTH 17 18 SAN DIEGO 12 13 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. *. Develop a transportation grid for this problem. New York City MINNEAPOLIS 13 10 16 Fort Worth San Diego Minneapolis Supply
b. Find the optimal solution using Microsoft Excel. (Note: Due to existing transportation contracts, Macon must ship 50,000 motors to Fort Worth and O motors to San Diego. These requirements are already shown in the Candidate Solution below.) (Leave no cells blank - be certain to enter "0" wherever required.) Candidate Solution Boulder Macon Gary Total supplied Profit Boulder Macon Gary Total profit Total Shipped
Transcribed Image Text:b. Find the optimal solution using Microsoft Excel. (Note: Due to existing transportation contracts, Macon must ship 50,000 motors to Fort Worth and O motors to San Diego. These requirements are already shown in the Candidate Solution below.) (Leave no cells blank - be certain to enter "0" wherever required.) Candidate Solution Boulder Macon Gary Total supplied Profit Boulder Macon Gary Total profit Total Shipped
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS