THE ANALYSTANALYTICAL WORK SIMULATIONS
OPEN WORKBENCH ↗
ASSIGNMENT REGISTER

SUPPLY PLANNING / INCOMING BRIEF

Forty-Eight Hours of Stock

Forecast 21-day SKU/warehouse risk and recommend transfers, expedites, or substitutions.

ACCEPT THE ASSIGNMENT PASS THE BRIEF

Preview anywhere. Complete the work in a current laptop or desktop browser.

ASSIGNMENT
SP-251201
YOUR ROLE
Supply Planning Data Scientist
WORKLOAD
12–18 hours
prepared learner
COMPLEXITY BAND
Practicum
01 / SITUATION

THE OPERATING MOMENT

The decision is already in motion.

Inventory risk is moving faster than the replenishment cycle. Transfers, expedites, and substitutions all consume limited operational capacity.

YOUR MANDATE

Build an honest demand-and-supply view, backtest the forecast, simulate lead-time risk, and issue a constrained action file.

02 / OPERATING CONDITIONS

WHAT THE WORK DEMANDS

Interrogate before you recommend.

You receive access to a bounded part of Meridian’s synthetic enterprise estate. The briefing defines the decision—not the analytical path or a preferred answer.

SQL / EVIDENCE CONSTRUCTION

Establish the facts.

Reconcile movement, demand, receipt, transfer, and vendor facts into a complete daily spine.

PYTHON / ANALYTICAL JUDGMENT

Stress-test the decision.

Backtest honest baselines, forecast intermittent demand, simulate lead-time risk, and produce a constrained action file.

CAPABILITY PROFILE1 FOUNDATION / 5 ADVANCED
SQL4/5
Python5/5
Data complexity5/5
Statistical reasoning5/5
Decision ambiguity5/5
Deliverable load5/5
03 / READINESS

BEFORE YOU ACCEPT

Know the neighborhood.

This is an open-ended workplace simulation. You can inspect the available schemas and tables before committing to an approach, but the brief intentionally does not identify every useful field or analytic test.

RECOMMENDED PREREQUISITES
  • Time-series validation
  • Forecast error
  • Simulation
  • Operational constraints
DATA NEIGHBORHOOD

6 tables across 1 schema

  • supply.inventory_movement
  • supply.inventory_position_daily
  • supply.purchase_order
  • supply.purchase_order_line
  • supply.goods_receipt
  • supply.product_vendor
MONDAY, 01 DEC / 06:45

Take the desk as Supply Planning Data Scientist.

Your SQL, Python, notes, evidence, figures, and final handoff stay in your browser until you choose to export them.

OPEN WORKBENCH
FORWARDING DESK / OPTIONAL

CHALLENGE A COLLEAGUE

Pass the Brief

Send the same decision pressure to someone else. The link opens this spoiler-free briefing; it does not include your work, identity, or progress.

SUGGESTED NOTE

You have 48 hours to turn a demand forecast into stock decisions. Take the supply-planning practicum in The Analyst.

EMAIL
MORE WAYS TO PASS THE BRIEF