[SOLVED] Supplier Water Risk Mapping

Assignment #4: Supplier Water Risk Mapping
Sustainable Operations
SUMA PS5170

Due to ongoing drought conditions and water supply shortages, one of your key material suppliers in Mexico has experienced periodic supply disruptions over the past 18 months. Your Global Procurement team is currently evaluating several alternative suppliers of this material in Mexico to help maintain the required supply
continuity and cost. As part of the alternate supplier evaluation, your Chief Procurement Officer has asked you if there are any quick and affordable water risk screening methods available to help inform the upcoming business decision. A more thorough and costly consultant-led water risk assessment may be warranted
over time, however a generalized water risk evaluation is needed in two weeks as part of the new supplier screening.
Your assignment is to utilize WRI’s online Aqueduct water risk tool to map out the locations of 3 potential new suppliers in Mexico, obtain water risk data associated with these supplier locations, and then summarize the findings
and report back to the Global Procurement team. Use the online Aqueduct tool to analyze Current Conditions (Baseline) on “Overall Water Risk”,
“Physical Risk Quantity”, “Baseline Water Stress”, “Riverine Flood Risk”, and “Drought Risk” for all 3 suppliers (default weighting). Also, report back on the Projected Change in Water Stress in 2030 and 2040 (Future), assuming a Pessimistic scenario. Summarize your findings using relevant graphs/tables
and recommendations inserted into a brief email memo (max 300 words) back to your Chief Procurement Officer.
Use the following alternate Supplier locations in Mexico: 1) Guadalajara,
Jalisco 2) Santiago de Queretaro, Qro 3) Cuernavaca, Morelos

Link to WRI Aqueduct Water Risk Atlas:
http://www.wri.org/our-work/project/aqueduct
IMPORTANT: the data entered into Aqueduct will not be saved once you exit. Either make note of the results & graphs, take screenshots or export results prior to exiting the program.

Assignment Guidance
WRI Aqueduct Water Risk Mapping Tool: https://www.wri.org/aqueduct
– Click on Aqueduct Water Risk Atlas – “Launch Tool” to get started
– Click on “Baseline” tab, then select
– Temporal Resolution: Annual
– Weightings: Default (unchecked box)
– Click on the “Future” tab, then select:
1. Indicator: “Water Stress”
2. Timeframe: 2030 (then repeat for 2040)
3. Scenario: “Pessimistic”
4. Unit of Measurement: “Absolute Value” (then repeat for “Change from
Baseline”)
IMPORTANT: the data entered into Aqueduct will not be saved once you exit. Either make note of the
results & graphs, take screenshots or Export Location Data results prior to exiting the program…
Assignment Guidance
● Select “Enter Address”
● Create 3 supplier locations
● Export to Excel by clicking “Download as CSV” and “Instructions” to read the data,
or copy-paste your results.
○ You can also opt to see the changes and results on the WRI Website instead of
downloading the data.
IMPORTANT: the data entered into Aqueduct will not be saved once you exit. Either make note of the
results & graphs, take screenshots or Export Location Data results prior to exiting the program…
Assignment Guidance
● Utilize the Baseline tab for “Overall Water Risk”, “Physical Risk Quantity”, “Baseline
Water Stress”, Riverine Flood Risk” and “Drought Risk”, and the Future tab for 2030
and 2040 projections in your overall assessment
● In total, you should explore the following scenarios:
○ Baseline
○ Future 2030 – Absolute value
○ Future 2030 – From baseline
○ Future 2040 – Absolute value
○ Future 2040 – From Baseline
IMPORTANT: the data entered into Aqueduct will not be saved once you exit. Either make note of the
results & graphs, take screenshots or Export Location Data results prior to exiting the program…
Supplier Water Risk Mapping Supplier Water Risk Mapping