Excel Sourcing Risk Analytics

I have a graduate-level case that calls for a complete sourcing analytics model to be built and documented entirely in Microsoft Excel. The study explores global risk exposure and will compare multiple sourcing scenarios through Foreign Exchange (FX) simulations, Net Present Value (NPV) calculations and, most critically, an Analytic Hierarchy Process (AHP) framework to weight the decision criteria.

Scope of data
The workbook needs to accommodate market intelligence, internal company figures and supplier-specific inputs so that all three perspectives feed the risk analysis seamlessly.

Core objective
The end goal is sound risk-management insight—cost reduction and performance considerations are secondary—but every formula, scenario, and dashboard should trace back to how each option affects our overall risk profile in a volatile FX environment.

Key tasks and expectations
• Build a clean, well-structured Excel file (no add-ins) that:
 – Runs FX sensitivity tables tied to multiple currency pairs
 – Calculates NPV for each sourcing alternative using adjustable discount rates
 – Implements AHP with transparent pair-wise comparison matrices and consistency checks
• Integrate all outputs into an executive-ready summary sheet with slicers or drop-downs for easy scenario toggling.
• Include concise in-cell comments or a separate “Read Me” tab so another analyst can follow the logic step by step.

Acceptance criteria
1. All calculations are traceable, unlocked, and error-free.
2. AHP consistency ratio ≤ 0.1.
3. Scenario toggle instantly updates FX, NPV, and combined risk scores without manual refresh.
4. Final file opens flawlessly in standard desktop Excel (Office 365) with no external links.

Deliver the finished workbook plus a short explanatory note (PDF or doc) that summarizes methodology, assumptions, and take-away recommendations.