Tabellab

Inventory and supply chain courses: stock, planning and lead times

Too much stock ties up cash and too little loses sales, so inventory work is a constant balancing act.

Inventory & Supply Chain courses (13)

$9.90Beginner

Excel for Supply Planners: Demand Forecast, Safety Stock & Replenishment

20 hands-on labs for new demand and supply planners: clean demand history, moving average forecasts, MAD, MAPE and bias, season index, safety stock with NORM.S.INV, reorder point, projected inventory balance, MOQ and pack-size orders, ABC classes, supplier lead times, fill rate, a planner dashboard, promotion lift, cartons, pallets and trucks, excess and slow movers, shelf-life risk, fair-share allocation, warehouse rebalancing, open purchase orders and a weekly replenishment plan.

20 lessons · 20 labs

$9.90Intermediate

Periodic Review & Min–Max Inventory Policies: Review Periods, Order-Up-To Levels, Pipeline Stock, a 52-Week Simulation & Joint Replenishment

Run inventory the way many shops and warehouses do, with a check every week or month, in 20 hands-on labs: set order-up-to levels, min–max rules and review periods, track on-hand, on-order and pipeline stock through a 52-week simulation, measure fill rates and stock-outs, group a supplier's items into one combined order, turn service targets into safety stock with NORM.S.INV, cover variable and changing lead times, follow a seasonal forecast, stagger review days, fill the truck, check order proposals and finish with a periodic review dashboard, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Inventory Accounting: FIFO, LIFO, Weighted Average & Valuation

Value an outdoor retailer's stock with periodic FIFO, LIFO and weighted average, a perpetual moving-average stock card, NRV write-downs and count adjustments, turnover and GMROI, then perpetual FIFO layers, returns and allowances, specific identification, import landed costs, LIFO liquidation, dollar-value LIFO, periodic closing entries, a ledger roll-forward, a workshop's three inventories, a purchases budget, the cash conversion cycle and a year-end close – 20 labs, every cell checked live.

20 lessons · 20 labs

$9.90Intermediate

Excess & Obsolete Inventory by the Numbers: Coverage, Ageing, Excess Quantities, Obsolescence Triggers, Reserve Matrices, Recovery Channels, Write-Down Scenarios, Prevention & a Dashboard

Run the excess and obsolete stock review for a fictional lighting company in 20 hands-on labs – months of cover, excess units and value, ageing layers, dead stock, obsolescence triggers, PO cancellations, reserve matrices and roll-forwards, recovery channels, markdowns, write-down scenarios, root causes, prevention and a final dashboard – with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Operations & Supply Chain in Excel

Inventory KPIs, ABC, EOQ, safety stock, forecasting, capacity, landed cost and Lean metrics, then XYZ classes, fill-rate safety stock, newsvendor seasonal buys, the bullwhip effect, excess and obsolete stock, cost to serve, dual sourcing, container freight, Little's law, the cost of service, perfect orders and a second-site dashboard: 20 labs on one distributor's real-looking data.

20 lessons · 20 labs

$9.90Intermediate

Supply Chain Risk & Resilience: Safety Stock, Dual Sourcing & Disruption Scenarios

Score a risk register and colour it as a heat map, measure supplier concentration on tier 1 and tier 2, compare time to recover with time to survive, size safety stock and strategic buffers, track OTIF and the bullwhip effect, plan recovery and pre-builds, stress-test margins for tariffs and currency, fund mitigations under a budget and build a resilience dashboard: 20 graded labs on one e-bike maker's supply chain.

20 lessons · 20 labs

$9.90Advanced

Multi-Echelon Inventory by the Numbers: Echelon Stock, Base-Stock Levels, Risk Pooling, Central vs Local Safety Stock, Distribution Plans, Fair Shares, Transshipments & a Dashboard

Plan stock for a fictional central DC and four depots in 20 hands-on labs – weeks of cover, echelon stock, base-stock levels, risk pooling with and without correlation, safety stock placement, distribution plans, fair shares, transshipments and a network dashboard – with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Operations & Supply Chain Exam Math: EOQ, MRP, Capacity & Forecast Error (CPIM/CSCP-Style Practice)

Practice the calculation questions of operations and supply chain exams in 20 hands-on labs: MAD, MAPE, bias and tracking signal, exponential smoothing, EOQ with price breaks, EPQ, the newsvendor critical ratio, safety stock from MAD, MRP netting with scrap and common parts, lot-sizing rules, DRP, MPS and ATP, rough-cut and detailed capacity, lead time and Little's law, constraint-based product mix, learning curves, planning bills, inventory turns and ABC cycle counting, every cell checked as you go. Independent practice, not affiliated with ASCM; CPIM and CSCP are registered marks of ASCM (APICS).

20 lessons · 20 labs

$9.90Intermediate

Order Promising & Lead-Time Analytics: Order-to-Delivery Stages, Quoted vs Actual Lead Times, Promise Accuracy, Available-to-Promise, Capacity Dates, Late-Order Causes & a Dashboard

Work through 20 hands-on labs at a fictional furniture maker – stage times in working days, quote rules from p80 lead times, available-to-promise, capacity and component dates, accuracy windows, re-promises, backlog ageing, late-order causes, cut-offs, expedite decisions and a delivery promise dashboard – with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Sales & Operations Planning: Demand Plans by Product Family, Capacity Gaps, Inventory Projections, Level vs Chase & the Monthly S&OP Pack

Run a monthly S&OP cycle for a fictional manufacturer in 20 hands-on labs: consensus demand by family, capacity in hours, gaps and options, projected inventory, level vs chase plans, scenarios and the financial view, then rough-cut capacity by work centre, backorders, workforce and hybrid plans, material and warehouse checks, time fences, product launches, plan vs budget, a make-to-order backlog, a scorecard and a 12-month dashboard, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Choosing Transport Modes: Road, Rail, Sea, Air & Intermodal – Door-to-Door Cost, Transit Time, Inventory in Transit & CO₂ per Tonne-km

Compare ways of moving the same goods. You will build door-to-door costs including pre- and on-carriage, transit times and reliability, the capital tied up in goods on the move, extra safety stock, CO₂ per tonne-km and the distance at which rail beats road, then empty running and backhauls, fuel-price sensitivity, block trains, departure frequency, value density for air, the cost of late deliveries, due-date mode choice, an internal carbon price, a weight-by-distance mode map, capacity-limited mode mixes, data plausibility checks and a lane portfolio dashboard. 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Value Stream Mapping by the Numbers: Lead Time, Process Efficiency & Flow

Turn a value stream map into numbers: data boxes, takt vs cycle time, Little's law, lead time and PCE, the bottleneck and rolled yield, a future state and the kaizen case – then go further with product families, EPEI, delivery frequency, transport, the office stream, measured lead times, WIP cost build-up, demand scenarios, data checks, kaizen priorities, future-state tracking and a dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

Too much stock ties up cash and too little loses sales, so inventory work is a constant balancing act. These courses cover the core calculations: reorder points and safety stock, periodic-review min-max policies, excess and obsolete stock, assortment and SKU rationalisation, sales and operations planning, and lead-time analytics. Operations and supply chain exam math is included for people preparing for a certification, and each lab runs in a built-in spreadsheet.

This topic hub gathers 13 Inventory & Supply Chain courses from Logistics, Business, Accounting, E-Commerce: 1 beginner, 11 intermediate, 1 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: safety stock formula excel; reorder point calculation; inventory management excel; s&op planning excel.

Frequently asked questions

Which Inventory & Supply Chain course should I start with?

Start with “Excel for Supply Planners”. It is a beginner-level course, so no prior knowledge is assumed. Then move on to the more specialised courses in the list above.

How much do the Inventory & Supply Chain courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Inventory & Supply Chain courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses