Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Problem 15-7 (Algo) 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 Boulder Macon Gary Bindley has three plants that can produce the motors. The plants and production capacities are 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.) PRODUCED AT NEW YORK CITY Boulder From To Boulder Macon Gary Requirements 30,000 55,000 65,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Boulder Macon 188,888 120,000 90,000 Profit 10 22 14 Gary Total prof 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. SHIPPED TO FORT WORTH 13 25 28 SAN DIEGO 15 22 MINNEAPOLIS 12 16 b. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Total Shipped New York City Fort Worth San Diego Minneapolls Supply

Problem 15-7 (Algo) 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 Boulder Macon Gary Bindley has three plants that can produce the motors. The plants and production capacities are 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.) PRODUCED AT NEW YORK CITY Boulder From To Boulder Macon Gary Requirements 30,000 55,000 65,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Boulder Macon 188,888 120,000 90,000 Profit 10 22 14 Gary Total prof 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. SHIPPED TO FORT WORTH 13 25 28 SAN DIEGO 15 22 MINNEAPOLIS 12 16 b. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Total Shipped New York City Fort Worth San Diego Minneapolls Supply

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Problem 15-7 (Algo) 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 Boulder Macon Gary Bindley has three plants that can produce the motors. The plants and production capacities are 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.) PRODUCED AT NEW YORK CITY Boulder From To Boulder Macon Gary Requirements 30,000 55,000 65,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Boulder Macon 188,888 120,000 90,000 Profit 10 22 14 Gary Total prof 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. SHIPPED TO FORT WORTH 13 25 28 SAN DIEGO 15 22 MINNEAPOLIS 12 16 b. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Total Shipped New York City Fort Worth San Diego Minneapolls Supply
Transcribed Image Text:Problem 15-7 (Algo) 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 Boulder Macon Gary Bindley has three plants that can produce the motors. The plants and production capacities are 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.) PRODUCED AT NEW YORK CITY Boulder From To Boulder Macon Gary Requirements 30,000 55,000 65,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Boulder Macon 188,888 120,000 90,000 Profit 10 22 14 Gary Total prof 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. SHIPPED TO FORT WORTH 13 25 28 SAN DIEGO 15 22 MINNEAPOLIS 12 16 b. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Total Shipped New York City Fort Worth San Diego Minneapolls Supply
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
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS