One Course
Every lesson, project and mock exam in Supply chain analytics.
Billed monthly. Cancel any time.
Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Courses / Business and operations
Practice supply chain management with a fictional distributor's data in a spreadsheet, a SQL editor and a Python notebook. Build forecasts and stock policies, investigate delivery performance and compare transport options. The exercises check your calculations on changed inputs as well as the original data.
Unit 1, Stock and demand: 5 lessons and 26 checked exercises, with no account or card.
Start the free unitThe rest of the course opens with a One Course or All Access plan. See plans and prices
Choose access here. Your course is already selected.
The inventory planner needs a two-product baseline before releasing the next purchase plan. Reconcile usable supply, obligations and annual turns. Deliver a six-sheet workbook with linked results that another planner can audit.
6 steps · 32 minCase study · BeginnerDemand forecast discrepancyThe demand planner compares a rolling forecast with a manual adjustment. Rebuild both products using the same information date, smoothing convention and WAPE denominator. The final checked error is the decision evidence; an appealing sales explanation cannot replace the calculation.
6 steps · 32 minCase study · BeginnerBuyer segmentation caseThe buyer has been assigning A status by selling price. Rebuild consumption values, cumulative shares and variability for two products. Deliver the numerical evidence for a differentiated policy and keep zero-demand variation flagged instead of pretending it is stable demand.
6 steps · 32 minProject · IntermediatePlanner replenishment modelThe replenishment planner must explain why two supplier lead-time models produce different buffers. Build fixed-lead-time safety stock, independent variable-lead-time safety stock and reorder points. The six-sheet deliverable preserves units and assumptions for both product families.
6 steps · 32 minProject · IntermediateBuyer purchase planThe buyer reviews two product families before issuing purchase orders. Reconcile periodic targets, EOQ assumptions and full-carton quantities. The deliverable is a linked order recommendation with the pack rounding visible. Compare the documents in [SAP purchasing](/sap/sap-me21n-purchase-order/) and [goods receipt](/sap/sap-migo-goods-receipt/).
6 steps · 32 minCase study · IntermediateService failure reconciliationThe service manager sees backlog even though production met its plan. Reconcile the opening obligations, physical supply and inventory position for two product families. The final backlog calculation must retain the unfulfilled commitment. Trace the event difference in [SAP sales orders](/sap/sap-va01-sales-order/) and [deliveries](/sap/sap-vl01n-delivery/).
6 steps · 32 minProject · AdvancedLogistics analyst network reviewThe logistics analyst compares two distribution arrangements. Reconcile sellable landed unit cost, volume-weighted distance and a second-center break-even. Deliver the six calculations and distinguish the cost threshold from the separate capacity and service decision. No route optimizer is assumed.
6 steps · 32 minProject · AdvancedS&OP constraint reviewThe operations manager needs a feasible monthly family plan. Rebuild projected supply, overload hours and closing backlog for two scenarios. Keep negative supply balances visible and do not confuse output with fulfilled orders. The final workbook identifies what demand can remain unserved despite a busy production line.
6 steps · 32 minMock exam · ExpertSupply chain job-test mock AThis 40-minute assessment uses original planner, buyer and logistics questions. It is a practical job-test format, not an ASCM exam or a certificate. The clock continues between questions and across reloads. State the grain, time unit and denominator before choosing a calculation.
12 questions · 40 minMock exam · ExpertSupply chain job-test mock BComplete a second 40-minute planner, buyer and logistics job test using fresh spreadsheet, SQL and Python inputs.
12 questions · 40 minWork as a planner, buyer and logistics analyst at Pine Harbor Distribution, a fictional distributor. You build demand forecasts, segment ABC and XYZ inventory, calculate safety stock and reorder points, reconcile S&OP capacity, audit supplier records and compare transport networks. Use the working spreadsheet, SQL editor and Python notebook to produce results that survive changed data. Twelve fresh practice sets, eight projects and cases, three interview sets and two timed job-test mocks take you from a stock baseline to an integrated planning decision. The cases use original data and state their assumptions. This course does not award a vendor or professional certificate.
Beginner
Reconcile stock, commitments and cost-based inventory performance.
Build and evaluate forecasts using information available at the issue date.
Segment consumption value and variation without mixing their meanings.
Intermediate
State the assumptions behind buffers and replenishment triggers.
Translate requirements into feasible periodic and full-pack purchases.
Measure complete orders, unit fill and actual lead time at the correct grain.
Advanced
Audit duplicate receipts and reconcile supplier quality and transport cost.
Build a family plan that exposes shortages, capacity limits and backlog.
Compare landed cost, weighted distance and fixed-cost tradeoffs.
Expert
Use pandas for product-level error, rolling forecasts and cumulative stock.
Quantify disruption exposure and combine ABC and XYZ evidence.
Reconcile cash, forecast improvements and integrated job-test decisions.
A forecast feeds a stock decision. Compare forecast errors before you choose a method, then calculate safety stock and a reorder point using the stated demand and lead time. The cases make you check units and time periods: weekly demand and a lead time in days cannot go into the same formula unchanged.
ABC and XYZ classifications help you compare items, but they don’t decide the stock policy for you. Review supplier performance and the cost of a shortage before you recommend which items need attention.
The supply chain analyst course path connects these exercises with Excel, SQL and logistics practice. Use it when you want to turn a calculation into an explanation of a planning decision. The operations manager path adds process improvement and decisions across teams.
For purchasing documents and freight decisions, continue with the logistics and procurement course. The Lean Six Sigma course covers process variation and improvement cases. These courses use fictional workplace data and original practice tests; they don’t award an external professional certification.
The PLC programming course covers the control logic behind a simulated conveyor and packaging line. Use it to practice machine sequences and fault diagnosis after the planning and inventory work here.
The spreadsheet, SQL editor and Python notebook run in your browser. All distributor data is fictional.
It teaches analysis across tools. Related purchasing and sales lessons link to the SAP course.
The timed tests contain original practical job-test questions. Passing them does not award a professional certification.