Forecasting: Time series and trend analysis
sri999
TransportationExample.xlsx
3.30
|
|
|
|
|
|
|
|
|
|
| Production |
| Plants |
Tacoma |
San Diego |
Dallas |
Denver |
St Louis |
Tampa |
Baltimore |
Capacity |
| Cost |
| Macon |
2.50 |
2.75 |
1.75 |
2.00 |
2.10 |
1.80 |
1.65 |
18000 |
| 35.50 |
| Louisville |
1.85 |
1.90 |
1.50 |
1.60 |
1.00 |
1.90 |
1.85 |
15000 |
| 37.50 |
| Detroit |
2.30 |
2.25 |
1.85 |
1.25 |
1.50 |
2.25 |
2.00 |
25000 |
| 39.00 |
| Phoenix |
1.90 |
0.90 |
1.60 |
1.75 |
2.00 |
2.50 |
2.65 |
20000 |
| 36.25 |
| Demand |
8,500 |
14,500 |
5,000 |
12,600 |
8,000 |
15,000 |
9,000 |
|
|
|
|
|
|
|
|
| Units |
Shipping |
Production |
| Plants |
Tacoma |
San Diego |
Dallas |
Denver |
St Louis |
Tampa |
Baltimore |
Shipped |
Cost |
Cost |
| Macon |
0 |
0 |
0 |
0 |
0 |
15000 |
3000 |
18000 |
31950 |
639000 |
| Louisville |
3000 |
0 |
4000 |
0 |
8000 |
0 |
0 |
15000 |
19550 |
562500 |
| Detroit |
0 |
0 |
1000 |
12600 |
0 |
0 |
6000 |
19600 |
29600 |
764400 |
| Phoenix |
5500 |
14500 |
0 |
0 |
0 |
0 |
0 |
20000 |
23500 |
725000 |
| Delivered |
8500 |
14500 |
5000 |
12600 |
8000 |
15000 |
9000 |
| 104600 |
2690900 |
|
|
|
|
|
|
|
|
|
| Grand TC |
2795500 |
