Reference no: EM133123312 , Length: 10 pages

Question 1:

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).

Question 2:

Part A: Create a Sankey diagram 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

Question 3:

A new Sustainability Manager has started working at a manufacturing facility. She knows the CSO is keen to present a carbon neutral product to the rest of the leadership team but has limited understanding of the gap to reach that target. The organization has completed a number of carbon footprinting calculations in the past as well as Global Reporting Initiative (GRI) reports, however, the information is incomplete. She has decided to hire a consulting firm (of MEPP grads) to help her piece this information together.

The information she currently has is below.

Total Emissions from the product (from GRI report):
Scope 1 Emissions: 100 kg of CO2e per functional unit Scope 2 Emissions: 10 kg of CO2e per functional unit Scope 3 Emissions: 200 kg of CO2e per functional unit

Emissions by Process Step:
Raw Material Extraction & Transportation (third-party, no affiliation with the company)
• 120 kg of CO2e per functional unit
Raw Material Processing (fully owned subsidiary of the company)
• 80 kg of CO2e per functional unit

Assembly Plant (fully owned and operated by the company)
• No information available
Distribution to Customers (third-party distributors, no affiliation with the company)
• No information available Utilization by Customer
• 20 kg of CO2e per functional unit End-of-Life Processing
• 40 kg of CO2e per functional unit

There were four (4) projects identified in the past that she has found information about (all reductions are per function unit):

1. Installation of solar panels that will offset all purchased electricity with an NPV of $3,500.

2. A raw material supplier that can reduce extraction by 10 kg with a MAC of $270/kg CO2e.

3. Reducing 50% of all direct emissions at the Assembly Plant. The reduction is related completely to methane emissions (CH4 = 100-year GWP factor of 28). The MAC for this project is $ -4/kg CH4.

4. Reducing embodied carbon emissions by 30% with an NPV of $-15,000.

Attachment:- Decision support system.rar