Forecasting: Time series and trend analysis
sri999
3 years ago
60
files (34)AssignmentProblem.xlsx
Twohubtemplatewihoutcost.xlsx
Naivenumber2.xls
Hubselectiontemplate.xlsx
Twohubtemplatewihoutcost.xlsx
- TransportationExample.xlsx
- Threehubtemplate.xlsx
- SampleRegressionandInventoryProblems.doc
- TransProbwithFC.xlsx
- TransProbwithFC.xlsx
- APPtransmodel.xls
- SampleRegressionProblem.xlsx
- Forecasting.pptx
- Minhubsgivenmaxmilage.xlsx
- Transshipment.xlsx
- TwoHubtemplate.xlsx
- RegressionandCorrelationNotes.doc
- Chapter-9.pdf
- ClssroomTimneSeriesExampleSolved.docx
- ProfitRDExample.xlsx
- TransportaionTemplate.xlsx
- ForecastingClassroomexample.xlsx
- Problem9.30Render.xlsx
- ForecastingChapter4and5solutions.xls
- SCMNetworkDesignProblems.docx
- render_qam13e_ppt_09.pptx
- TimeSeriesExample.xlsx
- render_qam13e_ppt_10.pptx
- Regressionconcepts.xlsx
- MultiRegression.xls
- Chapter-10.pdf
- Chapter-4.pdf
- Chapter-5.pdf
- ClssroomTimneSeriesExample.docx
AssignmentProblem.xlsx
Assignment
| Assignment problem | |||||||
| Add or delate # of rows and columns | |||||||
| Enter Data in shaded light blue area and go to Solver and click on Solve | |||||||
| Make sure that the # of jobs and # of people are equal | |||||||
| Job 1 | Job 2 | Job 3 | Job 4 | Job 5 | |||
| Person 1 | 7 | 8 | 9 | 10 | 12 | ||
| Person 2 | 12 | 6 | 8 | 9 | 12 | ||
| Person 3 | 13 | 10 | 12 | 8 | 13 | ||
| Person 4 | 10 | 99999 | 15 | 7 | 13 | ||
| Person 5 | 99999 | 7 | 11 | 9 | 99999 | ||
| Solution: | Job 1 | Job 2 | Job 3 | Job 4 | Job 5 | Cost | |
| Person 1 | 1 | 0 | 0 | 0 | 0 | 1 | 7 |
| Person 2 | 0 | 0 | 1 | 0 | 0 | 1 | 8 |
| Person 3 | 0 | 0 | 0 | 0 | 1 | 1 | 13 |
| Person 4 | 0 | 0 | 0 | 1 | 0 | 1 | 7 |
| Person 5 | 0 | 1 | 0 | 0 | 0 | 1 | 7 |
| 1 | 1 | 1 | 1 | 1 | 42 | ||
| Total Cost |
Twohubtemplatewihoutcost.xlsx
Sheet1
| Distances from | Assignment | ||||||||
| Area | X | Y | hub 1 | hub2 | hub1 | Hub2 | total | distnce | |
| A1 | 1 | 1 | 6.5309332582 | 5.0016077339 | 0 | 1 | 1 | 5.0016077339 | |
| A2 | 3 | 1 | 5.508743749 | 3.6077878265 | 0 | 1 | 1 | 3.6077878265 | |
| A3 | 5 | 1 | 5.1028841021 | 3.0026964679 | 0 | 1 | 1 | 3.0026964679 | |
| A4 | 7 | 1 | 5.452760276 | 3.6078025384 | 0 | 1 | 1 | 3.6078025384 | |
| E2 | 3 | 9 | 3.5650157534 | 5.3826563623 | 1 | 0 | 1 | 3.5650157534 | |
| E3 | 5 | 9 | 2.8987076068 | 4.9973035321 | 1 | 0 | 1 | 2.8987076068 | |
| E4 | 7 | 9 | 3.4778835889 | 5.3826662231 | 1 | 0 | 1 | 3.4778835889 | |
| E5 | 9 | 9 | 4.8773807239 | 6.4010271634 | 1 | 0 | 1 | 4.8773807239 | |
| 4 | 4 | 30.0388822397 | 5.0016077339 | ||||||
| Loc 1 | Loc 2 | Total | maximum | ||||||
| X | 5.076707883 | 4.9999867306 | |||||||
| Y | 6.1023075231 | 4.0026964679 |
Naivenumber2.xls
Sheet1
| Y | Ycap | Error | Err^2 | APE |
| Sales | mean | |||
| 20 | 25.8 | 5.8 | 33.64 | 0.290 |
| 24 | 25.8 | 1.8 | 3.24 | 0.075 |
| 27 | 25.8 | 1.2 | 1.44 | 0.044 |
| 29 | 25.8 | 3.2 | 10.24 | 0.110 |
| 23 | 25.8 | 2.8 | 7.84 | 0.122 |
| 31 | 25.8 | 5.2 | 27.04 | 0.168 |
| 16 | 25.8 | 9.8 | 96.04 | 0.613 |
| 20 | 25.8 | 5.8 | 33.64 | 0.290 |
| 23 | 25.8 | 2.8 | 7.84 | 0.122 |
| 27 | 25.8 | 1.2 | 1.44 | 0.044 |
| 29 | 25.8 | 3.2 | 10.24 | 0.110 |
| 28 | 25.8 | 2.2 | 4.84 | 0.079 |
| 32 | 25.8 | 6.2 | 38.44 | 0.194 |
| 30 | 25.8 | 4.2 | 17.64 | 0.140 |
| 28 | 25.8 | 2.2 | 4.84 | 0.079 |
| 25.8 | 3.84 | 19.8933333333 | 0.165 | |
| MAD | MSE | MAPE |
Sheet2
| Sales |
| 8 |
| 12 |
| 10 |
| 13 |
| 7 |
| 15 |
| 12 |
Sheet3
Hubselectiontemplate.xlsx
Sheet1
| Hub Selection | ||||||||||
| Note: If $/mile/ton is not given then use 1 for each location. | ||||||||||
| $/ton/mile | Tons | X cord | Y Cord | distance | Cost | Optimal Solution | ||||
| A | 1.5 | 500 | 650 | 750 | 158.1129258317 | 118584.694373798 | X | 500.0011930466 | ||
| B | 1.3 | 1000 | 550 | 1050 | 353.5537685958 | 459619.899174538 | Y | 699.9994477268 | ||
| C | 1.95 | 1200 | 750 | 950 | 353.5529375002 | 827313.873750477 | Objective | 7229742.35689002 | Minmum Cost | |
| D | 1.1 | 800 | 850 | 550 | 380.7873411593 | 335092.860220182 | ||||
| E | 1.85 | 700 | 650 | 350 | 380.787677711 | 493120.042635736 | ||||
| F | 1.25 | 1400 | 780 | 980 | 395.9793443712 | 692963.852649541 | ||||
| G | 1.55 | 1000 | 400 | 800 | 141.4225903655 | 219205.015066481 | 400 | 7229742.35689002 | ||
| H | 1.05 | 900 | 950 | 250 | 636.3948689406 | 601393.151148884 | 800 | 9292587 | ||
| P1 | 2 | 4000 | 500 | 700 | 0.0013146733 | 10.5173861716 | 9292586.71681756 | 2062844.64310998 | ||
| P2 | 2 | 2000 | 300 | 400 | 360.5553298129 | 1442221.31925143 | ||||
| P3 | 2 | 1500 | 900 | 150 | 680.0723770776 | 2040217.13123278 | ||||
| 15000 | ||||||||||
| Approximate Solution using Center of gravity Method | ||||||||||
| X | 613.8 | Y | 631.4666666667 |
Twohubtemplatewihoutcost.xlsx
Sheet1
| Distances from | Assignment | ||||||||
| Area | X | Y | hub 1 | hub2 | hub1 | Hub2 | total | distnce | |
| A1 | 1 | 1 | 6.5309332582 | 5.0016077339 | 0 | 1 | 1 | 5.0016077339 | |
| A2 | 3 | 1 | 5.508743749 | 3.6077878265 | 0 | 1 | 1 | 3.6077878265 | |
| A3 | 5 | 1 | 5.1028841021 | 3.0026964679 | 0 | 1 | 1 | 3.0026964679 | |
| A4 | 7 | 1 | 5.452760276 | 3.6078025384 | 0 | 1 | 1 | 3.6078025384 | |
| E2 | 3 | 9 | 3.5650157534 | 5.3826563623 | 1 | 0 | 1 | 3.5650157534 | |
| E3 | 5 | 9 | 2.8987076068 | 4.9973035321 | 1 | 0 | 1 | 2.8987076068 | |
| E4 | 7 | 9 | 3.4778835889 | 5.3826662231 | 1 | 0 | 1 | 3.4778835889 | |
| E5 | 9 | 9 | 4.8773807239 | 6.4010271634 | 1 | 0 | 1 | 4.8773807239 | |
| 4 | 4 | 30.0388822397 | 5.0016077339 | ||||||
| Loc 1 | Loc 2 | Total | maximum | ||||||
| X | 5.076707883 | 4.9999867306 | |||||||
| Y | 6.1023075231 | 4.0026964679 |
TransportationExample.xlsx
This file is too large to display.View in new window
Threehubtemplate.xlsx
This file is too large to display.View in new window
SampleRegressionandInventoryProblems.doc
This file is too large to display.View in new window
TransProbwithFC.xlsx
This file is too large to display.View in new window
TransProbwithFC.xlsx
This file is too large to display.View in new window
APPtransmodel.xls
This file is too large to display.View in new window
SampleRegressionProblem.xlsx
This file is too large to display.View in new window
Forecasting.pptx
This file is too large to display.View in new window
Minhubsgivenmaxmilage.xlsx
This file is too large to display.View in new window
Transshipment.xlsx
This file is too large to display.View in new window
TwoHubtemplate.xlsx
This file is too large to display.View in new window
RegressionandCorrelationNotes.doc
This file is too large to display.View in new window
Chapter-9.pdf
This file is too large to display.View in new window
ClssroomTimneSeriesExampleSolved.docx
This file is too large to display.View in new window
ProfitRDExample.xlsx
This file is too large to display.View in new window
TransportaionTemplate.xlsx
This file is too large to display.View in new window
ForecastingClassroomexample.xlsx
This file is too large to display.View in new window
Problem9.30Render.xlsx
This file is too large to display.View in new window
ForecastingChapter4and5solutions.xls
This file is too large to display.View in new window
SCMNetworkDesignProblems.docx
This file is too large to display.View in new window
render_qam13e_ppt_09.pptx
This file is too large to display.View in new window
TimeSeriesExample.xlsx
This file is too large to display.View in new window
render_qam13e_ppt_10.pptx
This file is too large to display.View in new window
Regressionconcepts.xlsx
This file is too large to display.View in new window
MultiRegression.xls
This file is too large to display.View in new window
Chapter-10.pdf
This file is too large to display.View in new window
Chapter-4.pdf
This file is too large to display.View in new window
Chapter-5.pdf
This file is too large to display.View in new window
ClssroomTimneSeriesExample.docx
This file is too large to display.View in new window
