Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An air-conditioning manufacturer produces room air conditioners at plants in Houston, Phoenix, and Memphis. These are sent to regional distributors in Dallas, Atlanta, and Denver.

An air-conditioning manufacturer produces room air conditioners at plants in Houston, Phoenix, and Memphis. These are sent to regional distributors in Dallas, Atlanta, and Denver. The shipping costs vary, and the company would like to find the least-cost way to meet the demands at each of the distribution centers. Dallas needs to receive 800 air conditioners per month, Atlanta needs 600, and Denver needs 250. Houston has 850 air conditioners available each month, Phoenix has 650, and Memphis has 300. The shipping cost per unit from Houston to Dallas is $8,to Atlanta is $12, and to Denver is $10. The shipping cost per unit from Phoenix to Dallas is $11, to Atlanta is $14, and to Denver is $9. The shipping cost per unit from Memphis to Dallas is $12, to Atlanta is $8, and to Denver is $14. How many units should be shipped from each plant to each regional distribution center? What is the total cost for this?

Please work in Excel or Google sheets and attach a downloadable document so I can see all formulas that were used. If you are not able to attach a doc, please show screenshot of all formulas used and screenshots of the steps used to get to your answer. I will rate your work immediately :)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Measure Theory And Integration

Authors: M M Rao, MM Rao

2nd Edition

1351991485, 9781351991483

More Books

Students also viewed these Mathematics questions