KAK Industries sells air-handling units. The annual demand for these
units in each region of the country is as follows: East, 100,000;
South, 150,000; Midwest, 110,000; West, 90,000. KAK is considering
building its air-handling units in four different cities: New York,
Atlanta, Chicago, and Los Angeles. The cost of producing an
air-handling unit in a city and shipping it to a region of the country
is given in the table below. Any factory can produce up to 150,000
air-handling units per year. The annual fixed cost of operating a
factory in each city is presented below. At least 50,000 units of the
Midwest demand for air-handlers must come from New York, and at least
50,000 units of the Midwest demand must come from Atlanta.
Unit production and shipping costs
To
East South Midwest West
From N.Y. $206 $225 $230 $290
Atlanta $225 $206 $221 $270
Chicago $230 $221 $208 $262
L.A. $290 $270 $262 $215
Annual fixed costs (millions)
N.Y. $6.0
Atlanta $5.5
Chicago $5.8
L.A. $6.2
a. Formulate an appropriate model to determine how KAK Enterprises can
minimize the total annual cost of meeting demand for its air-handling
units. Clearly define your decision variables, your objective function,
and your constraints. Place your algebraic formulation in the space
below.
b. Using Excel Solver, solve the problem. Place your solution in the
space below. Identify the locations of the factories that KAK should
use to manufacture its air-handlers and clearly and completely describe
the production and shipping schedule you have derived and clearly
indicate the total cost of meeting the customers’ demands.
PAGE 2
PAGE 1
Statistics Homework Solutions
#1877
Problems with Using the Excel Solver- Kak Industries
I just need help with the calculations as I am new with Excel Solver, and I am having problems formulating.
For the LP problems, you will need to solve using the Excel Solver. We have used the Sum Product feature when using Excel. So in cases where you can use that, please do so.
What is this?
By OTA - Overall OTA Rating
Noor Lalani, MBA - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
- Attached file(s):
- Solution 1877.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Quantitative Methods - Solve the model formulated in problem 11 for the Irwin Textile Mills graphically. a. How much extra cotton and processing time are left over at the optimal solution? Is the demand for corduroy met ...
- Solver - Modify the Barney-Jones investment problem so that there is a minimum amount that must be put into any investment, although this minimum can vary by investment. For example, the minimum amount for Inv ...
- Charleston Textiles-Linear Programming - 2.Charleston Textiles produces two types of cotton cloth: denim and corduroy. Corduroy is a heavier grade of cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 po ...
- Optimization Modeling: Use solver to help the farmer maximize the profit from his land. - A farmer in Iowa owns 45 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $200 profit, requires 3 workers, and requires 2 tons of fertilizer; eac ...
- QUANTITATIVE METHODS EXERCISES - Please refer to attached word document for instructions. You can use any software or graphical method Thanks
