Candidate-facing files

Candidate packet viewer

Read every supplied file directly in the browser, or download the originals individually. The ZIP remains available for working locally.

START_HERE_Candidate_Brief.pdf · Browser preview

Candidate brief

Download original

Open the brief PDF

01_purchase_orders.xlsx · Excel workbook · rendered as HTML

Purchase orders

Download original

PO Headers

po_numbervendor_idvendor_nameorder_datepromised_datedestination_warehousebuyer
PO-26-001V001AquaWorks Manufacturing2026-06-032026-09-13Riverside, CAA. Torres
PO-26-002V002BlueRiver Components2026-06-042026-09-14Riverside, CAJ. Patel
PO-26-003V003ClearFlow Industrial2026-06-052026-09-15Phoenix, AZM. Chen
PO-26-004V004HydraCore Systems2026-06-062026-09-16Riverside, CAA. Torres
PO-26-005V005PureLine Media2026-06-072026-09-17Riverside, CAJ. Patel
PO-26-006V006Summit Valve Company2026-06-082026-09-18Phoenix, AZM. Chen
PO-26-007V001AquaWorks Manufacturing2026-06-092026-09-19Riverside, CAA. Torres
PO-26-008V002BlueRiver Components2026-06-1010/03/2026Riverside, CAJ. Patel
PO-26-009V003ClearFlow Industrial2026-06-112026-09-21Phoenix, AZM. Chen
PO-26-010V004HydraCore Systems2026-06-122026-09-22Riverside, CAA. Torres
PO-26-011V005Blue River Components2026-06-132026-09-23Riverside, CAJ. Patel
PO-26-012V006Summit Valve Co.2026-06-142026-09-24Phoenix, AZM. Chen
PO-26-013V001AquaWorks Manufacturing2026-06-152026-09-25Riverside, CAA. Torres
PO-26-014V002BlueRiver Components2026-06-162026-09-26Riverside, CAJ. Patel
PO-26-015V003ClearFlow Industrial2026/07/01 00:002026-09-27Phoenix, AZM. Chen
PO-26-016V004HydraCore Systems2026-06-182026-09-28Riverside, CAA. Torres
PO-26-017V005PureLine Media2026-06-192026-09-29Riverside, CAJ. Patel
PO-26-018V006Summit Valve Co.2026-06-202026-09-30Phoenix, AZM. Chen
PO-26-019V001AquaWorks Manufacturing2026-06-212026-10-01Riverside, CAA. Torres
PO-26-020V002BlueRiver Components2026-06-022026-10-02Riverside, CAJ. Patel
PO-26-021V003ClearFlow Industrial2026-06-032026-10-03Phoenix, AZM. Chen
PO-26-022V004HydraCore Systems2026-06-042026-10-04Riverside, CAA. Torres

PO Lines

po_numberline_numberskudescriptionquantity_orderedunit_cost_usd
PO-26-0011CTRL-X2Ctrl X29638.5
PO-26-0012BRINE-18Brine 1811545.5
PO-26-0021FILTER-20Filter 2013351.5
PO-26-0022MEMBRANE-4Membrane 415258.5
PO-26-0023PUMP-075Pump 07517165.5
PO-26-0031PUMP-075Pump 07517064.5
PO-26-0041METER-DIGMeter Dig20777.5
PO-26-0042FITTING-KITFitting Kit22684.5
PO-26-0051MEDIA-GACMedia Gac24490.5
PO-26-0052TANK-0844Tank 08444397.5
PO-26-0053VALVE-1INValve 1In62104.5
PO-26-0061VALVE-1INValve 1In61103.5
PO-26-0071CTRL-X2Ctrl X298116.5
PO-26-0072BRINE-18Brine 18117123.5
PO-26-0081FILTER-20Filter 20135129.5
PO-26-0082MEMBRANE-4Membrane 4154136.5
PO-26-0083PUMP-075Pump 075173143.5
PO-26-0091PUMP-075Pump 075172142.5
PO-26-0101METER-DIGMeter Dig209155.5
PO-26-0102FITTING-KITFitting Kit228162.5
PO-26-0111MEDIA-GACMedia Gac246168.5
PO-26-0112TANK-0844Tank 084445175.5
PO-26-0113VALVE-1INValve 1In64182.5
PO-26-0121VALVE-1INValve 1In63181.5
PO-26-0131CTRL-X2Ctrl X2100194.5
PO-26-0132BRINE-18Brine 18119201.5
PO-26-0141FILTER-20Filter 20137207.5
PO-26-0142MEMBRANE-4Membrane 415624.5
PO-26-0143PUMP-075Pump 07517531.5
PO-26-0151PUMP-075Pump 07517430.5
PO-26-0161METER-DIGMeter Dig21143.5
PO-26-0162FITTING-KITFitting Kit23050.5
PO-26-0171MEDIA-GACMedia Gac24856.5
PO-26-0172TANK-0844Tank 08444763.5
PO-26-0173VALVE-1INValve 1In6670.5
PO-26-0181VALVE-1INValve 1In6569.5
PO-26-0191CTRL-X2Ctrl X210282.5
PO-26-0192BRINE-18Brine 1812189.5
PO-26-0201FILTER-20Filter 2013995.5
PO-26-0202MEMBRANE-4Membrane 4158102.5
PO-26-0203PUMP-075Pump 075177109.5
PO-26-0211PUMP-075Pump 075176108.5
PO-26-0221METER-DIGMeter Dig213121.5
PO-26-0222FITTING-KITFitting Kit232128.5
03_forwarder_updates.xlsx · Excel workbook · rendered as HTML

Forwarder updates

Download original

Updates

update_idforwarder_referencecontainer_numberreported_statuslatest_locationrevised_etaupdate_timestampsource_contact
FU-001BK-8801MSCU6639871Vessel arrivedLong Beach anchorage2026-09-142026-09-11 07:30pacificdesk@atlasfreight.test
FU-002BK-8802OOLU-721524-5In transitPacific Ocean2026-09-212026-09-10 16:45amy@northstarlogistics.test
FU-003BK-8803CMAU3123456Customs holdLong Beach terminal2026-09-202026-09-11 08:05imports@atlasfreight.test
FU-004BK-8804TGHU8492013DischargedLong Beach terminal2026-09-152026-09-10 12:00ops@harborbridge.test
FU-005BK-8805MAEU 123456 7Rolled — awaiting new sailingYantian origin terminal2026-09-09 09:20amy@northstarlogistics.test
FU-006BK-8806HLCU7654321In transitSouth China Sea2026-09-292026-09-10 14:20pacificdesk@atlasfreight.test
FU-007BK-8807COSU4412098In transitPacific Ocean2026-09-192026-09-04 08:00ops@harborbridge.test
FU-008BK-8808EGHU3098742Port congestionShanghai2026-10-032026-09-11 06:10imports@atlasfreight.test
FU-009BK-8809TEMU5501289In transitPacific Ocean2026-09-202026-09-07 11:00amy@northstarlogistics.test
FU-010BK-8810FCIU9283410BookedKaohsiung2026-09-282026-09-10 10:30ops@harborbridge.test
FU-011BK-8811SEGU4456721In transitPacific Ocean2026-09-252026-09-10 18:10pacificdesk@atlasfreight.test
FU-012BK-8812TRHU6723984Gate-in pendingHai Phong2026-10-042026-09-11 05:55amy@northstarlogistics.test
FU-013BK-8813YMLU3098765In transitPacific Ocean2026-09-182026-09-03 07:15imports@atlasfreight.test
FU-014BK-8814ONEU7263419In transitEast China Sea2026-09-292026-09-10 13:40ops@harborbridge.test
FU-015BK-8815APZU4918273BookedBusan2026-10-012026-09-10 09:05pacificdesk@atlasfreight.test
FU-016BK-9999ZZZU12345In transitUnknown2026-09-302026-09-11 09:00imports@atlasfreight.test
FU-017BK-8816BMOU3309812Booking cancelledKaohsiung2026-09-11 09:15ops@harborbridge.test
FU-018BK-8808EGHU3098742Port congestionShanghai2026-10-032026-09-11 06:10imports@atlasfreight.test
04_operations_tracker.xlsx · Excel workbook · rendered as HTML

Operations tracker

Download original

Tracker

container_numberoperations_prioritymanual_eta_overridecustomer_commitmentowneroperations_notelast_reviewed
MSCU6639871HighInstall project starts 2026-09-18SaraExpedite drayage after release2026-09-10
OOLU7215245Normal2026-09-10
CMAU3123456CriticalBackorders waitingLuisBroker says documents incomplete2026-09-10
TGHU8492013HighSaraNot delivered. ERP status appears wrong; awaiting terminal release.2026-09-10
MAEU1234567Critical2026-10-06Large dealer order due 2026-09-25LuisBuyer heard cargo was rolled again; confirm with forwarder.2026-09-10
HLCU7654321HighMinaLoaded quantity looks short against PO.2026-09-10
COSU4412098NormalMinaNo recent update; chase forwarder.2026-09-10
EGHU3098742CriticalPhoenix replenishmentSaraPort congestion reported.2026-09-10
TEMU5501289Normal2026-09-10
FCIU9283410Normal2026-09-10
SEGU445672INormal2026-09-10
TRHU6723984Normal2026-09-10
YMLU3098765Normal2026-09-10
ONEU7263419Normal2026-09-10
APZU4918273Normal2026-09-10
BMOU3309812HighLuisBooking may be cancelled. Need replacement plan.2026-09-10
02_erp_shipments.csv · CSV · rendered as HTML

ERP shipment export

Download original
shipment_idpo_numbercontainer_numbercarrierbooking_referenceorigin_portdestination_portetdetaerp_statusquantity_loadedlast_erp_update
SHP-1001PO-26-001MSCU6639871MaerskBK-8801NingboLong Beach2026-08-182026-09-16In Transit2112026-09-08 06:00
SHP-1002PO-26-002OOLU 721524 5OOCLBK-8802ShanghaiLong Beach2026-08-202026-09-18In Transit4562026-09-08 06:00
SHP-1002PO-26-003OOLU 721524 5OOCLBK-8802ShanghaiLong Beach2026-08-202026-09-18In Transit1702026-09-08 06:00
SHP-1003PO-26-004CMAU3123456CMA CGMBK-8803BusanLong Beach2026-08-242026-09-17In Transit4332026-09-08 06:00
SHP-1004PO-26-005TGHU8492013Hapag-LloydBK-8804KaohsiungLong Beach2026-08-212026-09-15Delivered3492026-09-08 06:00
SHP-1005PO-26-006MAEU1234567MaerskBK-8805YantianLong Beach2026-08-272026-09-22In Transit612026-09-08 06:00
SHP-1005PO-26-007MAEU1234567MaerskBK-8805YantianLong Beach2026-08-272026-09-22In Transit2152026-09-08 06:00
SHP-1006PO-26-008HLCU7654321Hapag-LloydBK-8806Hai PhongLong Beach2026-08-282026-09-24In Transit4372026-09-08 06:00
SHP-1007PO-26-009COSU4412098COSCOBK-8807NingboLong Beach2026-08-252026-09-19In Transit1722026-09-08 06:00
SHP-1008PO-26-010EGHU3098742EvergreenBK-8808ShanghaiLong Beach2026-08-3009/26/2026In Transit4372026-09-08 06:00
SHP-1008PO-26-011EGHU3098742EvergreenBK-8808ShanghaiLong Beach2026-08-3009/26/2026In Transit3552026-09-08 06:00
SHP-1009PO-26-012TEMU5501289MaerskBK-8809BusanLong Beach2026-08-262026-09-20In Transit632026-09-08 06:00
SHP-1010PO-26-013FCIU9283410ONEBK-8810KaohsiungLong Beach2026-09-012026-09-28Booked2192026-09-08 06:00
SHP-1010PO-26-014FCIU9283410ONEBK-8810KaohsiungLong Beach2026-09-012026-09-28Booked4682026-09-08 06:00
SHP-1011PO-26-015SEGU4456721SealandBK-8811YantianLong Beach2026-08-292026-09-23In Transit1742026-09-08 06:00
SHP-1012PO-26-016TRHU6723984MaerskBK-8812Hai PhongLong Beach2026-09-022026-09-30Booked4412026-09-08 06:00
SHP-1012PO-26-017TRHU6723984MaerskBK-8812Hai PhongLong Beach2026-09-022026-09-30Booked3612026-09-08 06:00
SHP-1013PO-26-018YMLU3098765Yang MingBK-8813NingboLong Beach2026-08-232026-09-18In Transit652026-09-08 06:00
SHP-1014PO-26-019ONEU7263419ONEBK-8814ShanghaiLong Beach2026-08-312026-09-27In Transit2232026-09-08 06:00
SHP-1015PO-26-020APZU4918273APLBK-8815BusanLong Beach2026-09-032026-10-01Booked4742026-09-08 06:00
SHP-1015PO-26-021APZU4918273APLBK-8815BusanLong Beach2026-09-032026-10-01Booked1762026-09-08 06:00
SHP-1016PO-26-022BMOU3309812CMA CGMBK-8816KaohsiungLong Beach2026-09-042026-10-02Booked4452026-09-08 06:00
SHP-1008PO-26-010EGHU3098742EvergreenBK-8808ShanghaiLong Beach2026-08-3009/26/2026In Transit4372026-09-08 06:00
forwarder_emails/ · 6 text files · expand to read

Forwarder and operational emails

Download original
Candidate_Submission_Template.docx · Word document · rendered as HTML

Candidate submission template

Download original

Candidate Submission Template

Inbound Freight Transformation Exercise

1. Executive summary

What did you find, and what should leadership do first?

Candidate response area

2. Deliverables

List the files, links, or applications included in your submission.

Candidate response area

3. Data model / ERD

Insert or link your data-model diagram and explain the grain of each core table.

Candidate response area

4. Source reconciliation

Explain source precedence, normalization, duplicate handling, and any records left unresolved.

Candidate response area

5. Exceptions and recommended actions

Summarize the highest-priority records and why they matter.

Candidate response area

6. Automation proposal

Describe the first practical automation, controls, failure handling, and human-review points.

Candidate response area

7. Decision log

List assumptions, ambiguous requirements, and questions you would ask the business.

Candidate response area

8. AI and tools used

State what tools you used, where they helped, and how you checked their output.

Candidate response area

9. Validation

Describe the checks you performed and their results.

Candidate response area
All companies, contacts, and records are synthetic.