SEPT 702 Final Exam W2019
This take-home exam is comprised of three (3) questions worth a total of 50 (fifty) marks. This exam is available on March 27 @ 11:59 am and due on April 10 @ 11:59 pm via the assigned dropbox on Avenue2Learn – no late submissions will be accepted and will receive a grade of ZERO. If you have any technological issues submitting this examination via Avenue2Learn – contact the instructor directly at zilberg@mcmaster.ca to identify the issue in advance of the due date.
This examination is an individual examination – ALL submissions will be reviewed using TurnitIn and by the instructor to validate that the examination was completed individually. Any plagiarism will be dealt with in accordance to McMaster University¡¯s Academic Integrity Policy.
Each of the following questions outlines the problem, expected deliverables, and the format in which the submission should be completed. You are not expected to look for external data to complete these responses – all the information required to complete the exam is available within the following 10 pages.
Question 1 (15 marks)
Complete the following decision support system based on the initial steps shown for a waste management facility. The table below outlines all potential decisions, criteria that would trigger the decision and whether the specific step is applicable. The goal of this DSS is to highlight when specific criteria would force the process to shift to a higher level as well as the stepwise process itself (as with the initial steps presented).
The criteria in the table is presented in random order – it is up to you to present a logically structured DSS diagram.
Expected Deliverable: Complete the DSS following the same approach initiated as a single DSS diagram.
Submission Format: PDF (you can create in MS Excel, MS Visio, or LucidChart – but convert to PDF for submission). Either fit your flowchart on one page or divide up logically.
1
DSS Criteria:
2
Question 2 (15 marks)
Part A: Create a Sankey diagram (using http://sankeymatic.com/) of Canada¡¯s greenhouse gas emissions in 2015. Specifically, create a sankey diagram that shows the contribution of greenhouse gas emissions by each province to Canada¡¯s total CO2 emissions, the breakdown by sector of the economy, and the contribution of sector activities by specific activity/fuel/mode where available as provided in tables A.3 to A.7 (from Environment and Climate Change Canada (2017) Canadian Environmental Sustainability Indicators: Greenhouse Gas Emissions).
Part B: You are considering a policy framework that will achieve the following outcomes by 2050, update the Sankey diagram to show the changes for the sectors and the provinces (assume proportion distribution across provinces relative to current CO2 emissions unless specifically stated):
1. Coal power generation is eliminated in Canada and replaced with natural gas (it is assumed that natural gas will emit 50% of the greenhouse gas emissions of coal for the same power output) (assume no coal power generation in ON, QC, and BC)
2. All oil sands associated activity is eliminated (assume all activity in Alberta)
3. Electric vehicle adoption for Passenger cars and light trucks is expected to be 100%
4. Electric vehicle adoption of freight trucks is expected to be 50%
5. As a result of 2, 3 and 4 natural gas utilization is expected double to meet electrical
demand
Expected Deliverable: Two (2) Sankey diagrams; one (1) document with sankeymatic code for both diagrams – explanations must be included as comments in the sankeymatic code or as separate comments in the same document. Be clear in your explanations of any assumptions.
Submission Format: PDF (include all expected deliverables above in the PDF) – size, rotate, organize diagrams to be clearly legible in the submission.
3
4
5
6
7
Question 3 (20 marks)
Design a linear programming (LP) worksheet for a home builder looking to optimize energy upgrade decisions in order to maximize the cost saving for her home. She is considering the following upgrades with the associated capital costs and savings as follows:
Lighting:
1. The main floor is an open concept so if she was to change one light, she would like to
change them all to match; there at a total of 20 lights that would cost $12 per light to
replace and would save $25/year in electricity cost
2. The second floor is separated in 5 (five) distinct areas with 3 (three) lights in each one so
each area could be changed independent of the others (ie. 3 lights at a time); costs and savings for lights are the same as for the main floor
Insulation/Windows:
1. There are a total of 10 (ten) distinct areas in the house that could be insulated separately
– each area would cost about $300 to insulate and save $4/month per area insulated
2. There is one window in each of these ten areas that are quite old and replacing would
result in $12/month per window with a window replacement cost of $600 per area
Heating/Cooling:
8
1. The existing furnace and air conditioner are still operating but inefficient . These could be replaced for $7,000 (air conditioner) and $12,000 (furnace) – the resulting saving would be $80/month (during operating months) for the air conditioner and $50/month (during operating months) for the furnace. These are average monthly savings over the 4 months the air conditioner operates and the 8 months that the furnace operates.
2. A geothermal system could be installed instead of the air conditioner and furnace mentioned in (1) above. The geothermal system would cost $20,000 and save $150/month over each of the 12 month when compared to the existing inefficient system. The geothermal system would meet cooling needs but would require a smaller furnace to run 8 month of the year. The smaller furnace costs $5,000 and would save $20/month (during operating months) for the 8 month when compared to the existing old furnace – also, these savings would be in addition to the geothermal savings.
Using MS Excel Solver (Simplex LP Method) – determine the maximum savings based on the each increment of the budget as outline in the table below (namely, from $2000 to $40,000 in $2000 increments). For each budget level, fill out the details in the attached summary table of the quantities of lighting changes, number of areas insulated and/or upgraded with new windows, which heating/cooling systems are installed, the annual savings and the actual cost. Do not provide comments in the summary table – only numeric values or YES/NO as specified.
Complete the summary table either by hand (using the template on the next page) or using the excel sheet provided with the same table and submit as a PDF.
Expected Deliverable:
1. MS Excel sheet with linear programming model. The excel sheet must clearly highlight the objective function, constraints, and variables. Be sure to design excel sheet so these aspects are clearly understand and include text within the excel sheet to explain. It is expected that the model design, input and outputs are logical – not simply mathematically accurate.
2. Summary table of the quantities of lighting changes, number of areas insulated and/or upgraded with new windows, which heating/cooling systems are installed, the annual savings and the actual cost.
Submission Format:
1. Linear programming model in MS Excel.
2. Summary table as a PDF (you can write out by hand or use the excel version but the submission must be a PDF).
9
Summary Table
10