Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1 Rototech Corp. supplies motors for all washing machines manufactured by Launders Inc. The motors are produced in Rototech s facilities located in New
Problem
Rototech Corp. supplies motors for all washing machines manufactured by Launders Inc.
The motors are produced in Rototechs facilities located in New York City, Fort Worth, and
San Diego. Rototechs production capacities are as follows:
New York City
Fort Worth
San Diego
Launders Inc. manufactures the washers at five locations around the country. Based on the
manufacturing plans over the next months, the following table provides the number of motors
required at each Launders Inc. manufacturing location:
Boulder
Minneapolis
Gary
Memphis
Macon
Shipments will be made in lots of motors from Rototech to Launders. Due to varying
production and distribution costs, Rototechs profits depend on where the motors are produced
and where they are shipped. Based on estimates from Rototechs Accounting Department, the
following table provides the profit in dollars per unit.
Shipped To
Produced at Boulder Minneapolis Gary Memphis Macon
New York $ $ $ $ $
Fort Worth $ $ $ $ $
San Diego $ $ $ $ $
Given profit maximization as a criterion, use the Transportation Method of Linear
Programming to determine the optimum ship quantity from each Rototech location to
each Launders Inc. location. Include the following items in your response:
a Submit your Excel file Solver addon
Demonstrate your understanding of the Solver results by answering the following questions:
b Based on your solution, how many motors should be shipped from Fort Worth to Memphis?
c Based on your solution, report how much additional production capacity is still available at each of Rototechs production plant
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started