Forecasting: Time series and trend analysis
sri999
TwoHubtemplate.xlsx
Two Hubs
|
|
|
|
| Two Hub Selection |
|
|
|
|
|
| Hub 1 |
Hub 2 |
Hub 1 |
Hub 2 |
| Hub 1 |
Hub 2 |
Total |
Volume |
|
| $/ton/mile |
Tons |
X cord |
Y Cord |
distance |
distance |
Vol |
Vol |
Totals |
Cost |
Cost |
To Hub 1 |
10925 |
| A |
1.5 |
500 |
650 |
750 |
649.9997618681 |
158.1120913261 |
26 |
474 |
500 |
25349.9907128571 |
112417.696932825 |
Out of Hub 1 |
10925 |
| B |
1.3 |
1000 |
550 |
1050 |
965.6601610301 |
353.5542965626 |
0 |
1000 |
1000 |
0 |
459620.585531375 |
Left at Hub 1 |
0 |
| C |
1.95 |
1200 |
750 |
950 |
813.9408256099 |
353.5526416778 |
0 |
1200 |
1200 |
0 |
827313.181525984 |
| D |
1.1 |
800 |
850 |
550 |
403.1126948572 |
380.7860480655 |
0 |
800 |
800 |
0 |
335091.722297611 |
To Hub 2 |
6575 |
| E |
1.85 |
700 |
650 |
350 |
320.1559366282 |
380.7866043559 |
0 |
700 |
700 |
0 |
493118.652640954 |
Out of Hub 2 |
6575 |
| F |
1.25 |
1400 |
780 |
980 |
838.6296386034 |
395.979048548 |
0 |
1400 |
1400 |
0 |
692963.334959018 |
Left at Hub 2 |
0 |
| G |
1.55 |
1000 |
400 |
800 |
820.060707622 |
141.4238647398 |
0 |
1000 |
1000 |
0 |
219206.99034671 |
| H |
1.05 |
10900 |
950 |
250 |
111.8033478169 |
636.3935945678 |
10899 |
1 |
10900 |
1279471.92224885 |
668.2132742962 |
| P1 |
2 |
4000 |
500 |
700 |
680.073261751 |
0.0026179119 |
1 |
3999 |
4000 |
1360.146523502 |
20.9380592275 |
| P2 |
2 |
2000 |
300 |
400 |
649.9997336033 |
360.5553699792 |
1 |
1999 |
2000 |
1299.9994672065 |
1441500.3691768 |
| P3 |
2 |
11500 |
900 |
150 |
0.0002753265 |
680.071164438 |
10923 |
577 |
11500 |
6.0147833658 |
784802.123761426 |
|
|
|
|
|
|
|
|
|
|
| 1307488.07373578 |
5366723.80850623 |
| Optimal Solution |
| X1 |
899.999780846 |
|
| X2 |
500.0023033473 |
Hub 1 $ |
| Total Cost |
6674211.88224201 |
| Y1 |
150.0001666621 |
|
| Y2 |
699.9987557918 |
Hub 2 $ |
|
|
|
|
|
|
| Total |
|
|
| 7229742 |
| 7229742 |
Single Hub
|
|
| Hub Selection |
|
| $/ton/mile |
Tons |
X cord |
Y Cord |
distance |
Cost |
Optimal Solution |
|
|
| $/milee or load |
| A |
1.5 |
500 |
650 |
750 |
593.1871968291 |
444890.397621819 |
X |
891.8306864543 |
|
| 750 |
| B |
1.3 |
1000 |
550 |
1050 |
908.421455086 |
1180947.89161184 |
Y |
208.3460795203 |
|
| 1300 |
| C |
1.95 |
1200 |
750 |
950 |
755.0936904669 |
1766919.23569263 |
Objective |
16307431.9460173 |
Minmum Cost |
| 2340 |
| D |
1.1 |
800 |
850 |
550 |
344.2051825705 |
302900.560662021 |
|
|
|
| 880 |
| E |
1.85 |
700 |
650 |
350 |
280.2640078537 |
362941.890170509 |
|
|
|
| 1295 |
| F |
1.25 |
1400 |
780 |
980 |
779.7152527843 |
1364501.69237255 |
| G |
1.55 |
1000 |
400 |
800 |
769.3840300897 |
1192545.24663902 |
| H |
1.05 |
10900 |
950 |
250 |
71.5452173783 |
818835.01289486 |
| P1 |
2 |
4000 |
500 |
700 |
628.6929810092 |
5029543.84807379 |
|
|
|
| 8000 |
| P2 |
2 |
2000 |
300 |
400 |
622.0890504294 |
2488356.20171761 |
|
|
|
| 4000 |
| P3 |
2 |
11500 |
900 |
150 |
58.9152160244 |
1355049.96856068 |
|
|
|
| 23000 |
|
|
|
|
|
|
|
|
|
|
|
| 41565 |
