Supply Chain & Inventory Optimisation
OperationsIntermediate60 min
Scenario
You are an Operations Analyst at PacificFlow, a Canadian distributor with warehouses
across five regions. The VP of Operations has flagged rising holding costs and a growing
number of stockout incidents. She suspects one region and one supplier are responsible
for most of the problems but needs hard data before she escalates to the supplier
Tasks
- 1.Calculate the on-time delivery rate for each supplier
- 2.Identify region has the highest stockout risk and why
- 3.Find supplier-region combination causing the most chronic delays
- 4.Calculate total monthly holding costs by region and identify the highest cost area
- 5.Deliver a 300-word VP Operations memo recommending two specific actions with
- 6.supporting data
Submission Requirements
- •On-time delivery rate per supplier (as percentages)
- •The worst-performing supplier-region combination with specific delay figures
- •Total holding costs by region
- •Your two action recommendations with data backing
- •Which AI tools you used and how
Dataset Actions
Start the challenge to unlock dataset and submission.
Allowed Tools
AI Tools
ClaudeChatGPTPython with AI assistanceNotion AI
Analysis Tools
ExcelGoogle Sheets
Scoring Rubric
Data accuracy30 pts
Correct on-time rates, correct holding cost totals
Problem identification25 pts
Correctly identifies Halifax + SupplierD as the core issue
Recommendations25 pts
Two specific, data-backed actions (not generic advice)
Communication20 pts
VP memo is professional, specific, and escalation-ready
Submit Solution
Submissions are scored automatically using real evaluation criteria.
Begin the challenge to unlock the submission workspace.