STAT804 Optimization and Operations Research
STAT804 Optimization and Operations Research
Semester 2, 2023
Project
This project is based on the case study provided by SUEZ Smart Solutions NZ in class on 21 August 2023. It will contribute 40% towards the final mark for STAT804.
Project Aim: Build the most cost-effective 24 hour schedule for Suez Town water distribution network and conduct cost-benefit analysis to explore the impact of pump upgrades and a lockdown.
Each group must complete:
Presentation |
To be held between 10am and 4pm on Monday 25th September 2023 Upload slides by 10am 25th Sept. 2023 |
25 marks |
Report |
Due: 11:59pm Sunday 24th September 2023 |
55 marks |
Each individual must complete: |
|
|
Self and Peer Evaluation (mid point) |
Due: 11pm Thursday 1st September 2022 |
0 marks |
Individual Contribution Statement |
Due: 11:59pm Sunday 24th September 2023 |
0 marks |
Self and Peer Evaluation (end of project) |
Due: 11:59pm Sunday 1st October 2023 |
0 marks |
Individual Reflective Report |
Due: 11:59pm Sunday 1st October 2023 |
20 marks |
1 Group Work
2 Late Assignments
3 Special Consideration
4 Originality
5 Group Tasks (80 marks)
5.1 Report (55 marks)
– Title page– Abstract (150 – 250 words)– Acknowledgements (optional)– Table of Contents– Introduction (0.5 – 1 pages)– Schedule Optimisation
* Model Formulation (max 2 pages)* Model Implementation (max 1 page)* Model Solution (max 3 pages)* Model Extensions (max 3 pages per extension)
– Cost Benefit Analysis
* Pump Upgrade Analysis (max 3 pages)* Lockdown Demand Analysis (max 3 pages)
– Conclusion (1 – 2 pages)– References– Appendix A: Individual Contribution Statements– Standard elements of a report: page numbers, figure/table captions.
– All SAS program files should run on any computer (relative referencing only).– All datasets should be provided.– Use relative referencing to refer to datasets and libraries. (See guide on Canvas)– Use comments within your code where appropriate.– SAS code will be assessed based on its accuracy and elegance.– If other code is used (e.g. R code), this also should be included.
Detailed Requirements & Marking Criteria
1.Introduction
The introduction should contain relevant background information and clearly state the purpose and scope of the report.
2. Schedule Optimization
A mixed integer linear programming model should be developed to obtain the most cost-effective 24 hour schedule for Suez Town water distribution network, while making sure each tank ends up with the same or similar volume of water as in the beginning of the day (starts at 6:00am).
(a)Model Formulation
The decision variables, constraints and objective function of the model should be clearly defined, using a mixture of words and mathematical notation, as required. A mathematical formulation of the model should also be provided. Assumptions should be clearly defined and justified.
• meet the requirements specified by the client in the case study brief.
• ensure that each tank ends up with the same or similar volume of water as in the beginning of the day.
(b)Model Implementation in SAS
The model should be implemented with proc optmodel in SAS and used to obtain the most cost-effective 24 hour schedule for Suez Town water distribution network.
Notes:
• Any data manipulation (either before/after optimisation in SAS) can be done in software of your choice. However, it must be “reproducible” and any code used should be included in the zip file.
• Marks will be awarded for correct and elegant implementation of the model in SAS, and clear and logical presentation of the solution. Elegant code is easy to read, simple, concise, efficient, generalisable, minimises “hard coding of variables”, and well-commented.
• SAS code is not required within the report, but all SAS files should be included in the zip file submitted.
(c) Model Solution
The results of the optimisation model should be presented in the report and accompanied by appropriate interpretation/discussion. The results should include:
– Times and levels at which pumps should be operated.– Times and levels at which valves should be open.
• The cost of the schedule.
• Graph/s of the water level of each tank over the 24 hour period (along with minimum and maximum allowable levels),
• Graph/s of the pump and valve levels over the 24 hour period (along with minimum and maximum allowable levels),
• An interpretation/discussion of the schedule.
• Figures and tables etc. can be developed using software of your choice.
• Any figures and tables etc. should be clearly and professionally presented. Do not use screenshots of code or output in the report.
(d) Model Extensions
The case study brief includes two “extensions” regarding the operation of the source and pumps.
For each extension:
• Implement the model in SAS and provide the corresponding solution,
• Discuss/interpret the solution.
3. Cost Benefit Analysis
(a)Pump Upgrades: What benefit could be achieved by upgrading some or all of the pumps to more efficient modern pumps?
(b)Lockdown demand analysis: The town is in lockdown and this has resulted in a change in demand. How is the optimisation affected?
Refer to the case study brief for further details about these issues.
The cost benefit analysis conducted should investigate these issues and provide useful insights to a manager at Suez Town council. Appropriate graphs, statistics and explanations should be included.You can use software of your choice to do the cost benefit analysis.
4.Conclusion
5. Report Structure & Quality
6. Appendix A: Individual Contribution Statement
Together the group should agree on a percentage allocation of the work undertaken and should state this at the start of Appendix A. This information, along with the Individual Contribution Statement and the Self and Peer Evaluation, will be used to determine the marks allocated to each group member. The percentages must sum to 100%.
Example percentage allocation: Person A 25%, person B 30%, person C 20%, and person D 25%.
5.2 Presentation (25 marks)
• Presentations should be 20 minutes long.
• Following each presentation, there will be 5 minutes for Q&A.
• All team members should participate in the presentation.
• The presentation should be aimed at an data science manager who has some knowledge of optimisation models, but is also interested in the key insights for Suez.
• If you successfully incorporated the extension(s) in part 2d, you should present the findings from the extended model in the presentation, rather than the original model.
1.Presentation Content
2.Presentation Mechanics & Style
The presentation has a clear and logical structure, flows well with points clearly linked, and adheres to the time limit. Visual aids (e.g. slides) are useful to the audience and are well laid out and accurate with correct spelling and grammar.
6 Individual Tasks (20 marks)6.1 Self and Peer Evaluation (0 marks)
Each group member should complete the self and peer evaluation (S&PE) via Canvas twice - once at the mid-point and once at the end of the project. Marks will not be awarded for this task, however failure to complete it will result in a mark of 0 for the assignment. The results of the S&PE will be used by the lecturers to determine how the members in each group have worked together. The results will not be released to students.
The mid-point S&PE will be used by the lecturers to determine how the groups are working together and whether or not any intervention is required. The results of mid-point S&PE will not directly influence the final grades in the project.
6.2 Individual Reflective Report (20 marks)
personal and professional growth as a result of the project. It should not be a description of what you did, but rather a critical evaluation of the success of the project, your performance in the project and your experience of undertaking the project. As part of this critical evaluation it is expected that you will reference the required reading and at least one other piece of relevant literature.
In the reflective statement it is okay to talk about things that did not go well, as these circumstances often provide rich learning experiences. The reflective statement should be written in the first person, i.e. “In this project, I ... ”.
Detailed Requirements & Marking Criteria
1.Introduction
2.Three Learning Points (5 marks each)
For each learning point, write 200 - 300 words addressing the following points2 :
3.Conclusion (150 - 300 words)
4.Presentation, Quality, and Literature
Required reading for the reflective statement
2023-10-12