The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 355 Weeks Ago, 5 Days Ago |
| Questions Answered: | 20103 |
| Tutorials Posted: | 20155 |
MBA, PHD
Phoniex
Jul-2007 - Jun-2012
Corportae Manager
ChevronTexaco Corporation
Feb-2009 - Nov-2016
Question description
Â
Â
Â
Q: There are production facilities in Battle Creek, Cherry Creek, and Dee Creek with annual capacities of 500 units, 400 units, and 600 units, respectively. The annual demands at warehouses in Worchester, Dorchester, and Rochester are 300 units, 700 units, and 400 units, respectively. The table below gives the unit transportation costs between the production facilities and the warehouses.
Â
Â
| Â |
Worchester   |
Dorchester   |
Rochester   |
|
Battle Creek    |
$20/unit |
$30/unit |
$13/unit |
|
Cherry Creek |
$10/unit |
$5/unit |
$17/unit |
|
Dee Creek |
$15/unit |
$12/unit |
$45/unit |
Â
How much of the demand at each of the warehouses must be met by each of the production facilities?
By using Excel Solver (Excel Solver is an Add-in that does not come standard with Excel. Installing it is quick and easy with the right instructions. (I'll provide two PDFs which will help the tutor (once the task is assigned ) to understand the question and they are  MUST to review )).Â
Remember that you must show all work for this assignment and interpret your result.
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l