The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 304 Weeks Ago, 6 Days Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
Â
| Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| COST OF SHIPPING ONE UNIT FROM WAREHOUSE TO CUSTOMER | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | CUSTOMERS | Â | Â | Â | Â | Â | Â | ||
| Warehouses | London | Delhi | Lagos | Seoul | Auckland |  | TOTAL COST OF SHIPPING | ||
| San Diego | $100.00 | $80.00 | $60.00 | $60.00 | $40.00 | Â | Â | Â | |
| Dubai | $60.00 | $50.00 | $40.00 | $30.00 | $60.00 |  |
|
 | |
| Dublin | $30.00 | $40.00 | $50.00 | $50.00 | $90.00 | Â | Â | Â | |
| Â | Â | Â | Â | Â | Â | Â | THIS SHOULD BE MINIMISED | ||
| NUMBER OF UNITS TO SHIP FROM WAREOUSE TO CUSTOMER | Â | Â | Â | Â | Â | Â | Â | Â | |
|  | CUSTOMERS |  |  |  |  | Total To | Total In | ||
| Warehouses | London | Delhi | Lagos | Seoul | Auckland |  | Ship | Warehouse | |
| San Diego | Â | Â | Â | Â | Â | Â | Â | 1550 | |
| Dubai |  |  |  |  |  |  |  | 1300 | |
| Dublin | Â | Â | Â | Â | Â | Â | Â | 1400 | |
| Total To Ship | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Total Ordered | 900 | 400 | 1000 | 800 | 1100 | Â | Â | Â | |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| we have three warehouses in San Diego, Dubai and Dublin, we have orders from customers in london, delhi, lagos, seoul and auckland that need to be filled. Which customers should we ship from which warehouse? At the bottom we see how much each custormer has ordered and on the right we see how many units we have in each warehouse. | |||||||||
| the yellow areas are to be filled with the appropriate formulae and my total cost of shippin should be minimized. | |||||||||
Â
Attachments:
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly