Question
can you show this problem in excel The Future Furniture Company recently began construction of a new warehouse. During the construction period, several changes have
can you show this problem in excel
The Future Furniture Company recently began construction of a new warehouse. During the construction period, several changes have occurred that require development of new distribution plan. The current figures for supply are
| PLANT | CAPACITY (Pieces per Week) |
| East L.A. (ELA) | 600 |
| West L.A. (WLA) | 800 |
| El Toro (ET) | 400 |
Current figures for demand are
| WAREHOUSE | DEMAND (Pieces per Week) |
| Orange County # 1 (OC1) | 300 |
| Orange County # 2 (OC2) | 400 |
| Long Beach (LB) | 200 |
| Los Angeles (LA) | 900 |
Average Shipping costs per unit are
|
| Orange County # 1 | Orange County # 2 | Long Beach | Los Angeles |
| East L.A. | $8 | $9 | $6 | $4 |
| West L.A. | 10 | 7 | 2 | 3 |
| El Toro | 5 | 7 | 9 | 12 |
Use Excel and Solve to determine the shipping schedule that minimizes the total cost
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
Bucks The Next Step Advanced Medical Coding And Auditing 2019/2020
Authors: Elsevier
1st Edition
0323582613, 978-0323582612
