Deloitte Virtual Internship

Cold-chain fulfilment operations practical

Complete five connected assignments, from reliable event ingestion to fulfilment analysis, access investigation, service review and a delivery proposal. Open every input, complete output and reference answer on this site.

Open complete workbench Download complete learning pack

Complete reference results

197 mature orders, 90 late orders and 10 open overdue orders. The access investigation identifies six unauthorized exports and one expired-session read.

216 orders · 640 source records · 69 access requests

Five tasks

Every material and full answer can be read here. Checkpoints let you start each task independently.

Task 01

Dual-system order event ingestion

Build one reliable event layer from two feeds and explain which records must not enter analysis.

Open task and complete output Read complete output first

Task 02

Fulfilment review and interactive dashboard

Identify priority orders and hubs using a valid historical window, and deliver a readable decision report.

Open task and complete output Read complete output first

Task 03

Export access investigation

Use policy, session and request evidence to identify control gaps and propose verifiable actions.

Open task and complete output Read complete output first

Task 04

Service performance disparity review

Control for service mix and sample size before setting hub review priorities.

Open task and complete output Read complete output first

Task 05

Operations workbench delivery proposal

Turn the preceding evidence into a scoped, estimated and testable delivery proposal.

Open task and complete output Read complete output first

How to start

Ape Intern cold-chain fulfilment practical

The five tasks connect event ingestion, operations analysis, access investigation, service review and a delivery proposal. Open the completed workbench and full reports first, then produce your own outputs. Suggested task effort is 18–24 hours, with 2–4 more for review and revision.

Files and independent starts

learner/task-01.md through task-05.md contain instructions. learner/materials contains raw data, the dictionary and stakeholder brief. learner/checkpoints provides complete intermediate results so each task can be started independently. instructor/answers contains full reference outputs, and instructor/scripts contains runnable Python and tests.

Use Python 3.10 or later. No third-party Python packages are required. Keep CSV input as UTF-8 and preserve timezone text when opening it in a spreadsheet application. The reference calculation does not depend on spreadsheet date parsing.

From the extracted pack directory run:

python3 --version
python3 instructor/scripts/solution.py learner/materials my-results
python3 instructor/scripts/test_lab.py

The reference command writes a new my-results directory without modifying the raw inputs. If Python is absent, install it through your operating system's official channel. Implement learner/starter.py and run python3 smoke_test.py from learner. Its unfinished functions identify the work to complete. Explain your own decisions and revisions rather than representing a reference run as independent work.

Review and revision guide Read the full file

Download file

Practitioner review and revision guide

Five tasks are worth 20 points each. Run the learner's code, trace conclusions to raw records, and require critical rule corrections even when the score exceeds 14. Actual practitioner allocation remains a delivery decision; do not pre-fill a practitioner's identity or claim that a review has already happened.

Review conversation

Ask the learner to open the output and give a conclusion in three minutes, trace one piece of evidence in five, recalculate a boundary in five, and record one revision plus its acceptance check. Retain the original, revised output and test record.

Questions by task

Task one: move a conflicting ID to the start of the input. The accepted result must not change. Replay across feeds should compare canonical content, not source labels.
Task two: move a future delivery before the cutoff and explain the cohort change. Later feed recovery must not rewrite the old historical review. Why is cancellation not on-time delivery?
Task three: authorize op-7's role but retain its high frequency. The export conclusion must change. A denied request changed to 200 needs session and scope checks. Approved bulk archival is a necessary counterexample.
Task four: compare a 25% rate at n=4 with n=20. The former needs more data first. Exactly 15 percentage points is Review needed. Explain a changed service weight.
Task five: identify where production R5 tests will run. Frontend visibility cannot establish identity integration. Reconcile 140 hours to four 35-hour weeks.

Revision record

Record finding → evidence → affected conclusion → correction → re-test → learner explanation. Complete at least one revision per task. Different visualizations, wording and architectures can pass when their rules, evidence, assumptions and acceptance are sound. A reference answer is not a script to memorize. Do not invent employment, client endorsement or outcome claims.