Advertisements

Inventory & Warehouse Management in Excel + AI: 170+ Tools

Advertisements
Cut stockouts and dead stock: safety stock, reorder point, EOQ, ABC analysis, demand forecasting, WMS and 10 calculators
1
1/5
(64) Ratings
398 students
Created by PapaHR ★ 180K students: Human Resources, HR Management, SHRM, AI Analytics, Recruitment, Payroll, Certification, CIPD, Claude
Advertisements

What you'll learn

  • Take away 170+ tools in 20 downloadable resources: 10 lecture presentations plus 10 interactive HTML calculators that run in your browser
  • Get our top working files: ROP & Safety Stock Calculator, ABC/XYZ Matrix, Warehouse KPI Dashboard, Shift Staffing Planner
  • Set safety stock and reorder points by service level from the real spread of your demand and supplier lead times
  • Classify SKUs with ABC/XYZ analysis in Excel and write one stock rule for every cell of the matrix
  • Forecast seasonal demand three ways, measure MAPE, bias and RMSE, and check an AI forecast before you trust it
  • Calculate EOQ, test price breaks and set Min-Max order quantities rounded up to your pallet
  • Find excess and dead stock with an aging report, price the holding cost and choose an action for every lot
  • Measure the warehouse with KPIs: order accuracy, OTIF, lines per hour, cost per order and dock-to-stock time
  • Plan shift headcount from volume, run a safety walk, and score WMS vendors on must-haves and three-year cost
  • Use Copilot in Excel and Claude with a 7-prompt pack and five checks that catch AI errors on your SKU export
This course includes:
8 total hours on-demand video
0 articles
20 downloadable resources
10 lessons
Full lifetime access
Access on mobile and TV
Certificate of completion
Advertisements

Course content

Requirements

  • Basic Excel or Google Sheets: SUM, AVERAGE, sorting and simple formulas
  • A modern browser to open the HTML calculators: no install, no sign-up, works offline after download
  • Optional: an export of your own SKUs, sales and counts; every tool also ships with a fictional example company
  • Optional: access to Copilot in Excel, ChatGPT or Claude for the AI parts; the checks work with any assistant
  • No WMS or ERP access and no supply chain degree needed

Description

This course contains the use of artificial intelligence

Your system says 300 units. The shelf holds 288. Every inventory problem starts with a number nobody has checked, and ends as a stockout, a write-off or a truck that waits at the dock.

Most warehouses run out of the best sellers and overflow with last season at the same time. Reorder points are guessed, safety stock is a habit, dead stock sits in the far aisles and costs a quarter of its value every year to keep. The spreadsheet that should fix it is the one nobody trusts.

This course turns that spreadsheet into a set of working models. You will know which SKUs deserve your attention, how much to order and when, what your stock costs to hold in dollars, and how fast your warehouse moves from the dock to the truck. You will plan shifts from volume instead of from memory, and you will use AI to do the heavy analysis while you check the logic.

Ten lessons, one retail chain. Every lesson is a short case from a fictional retailer with 40 stores, one distribution center and 6,000 SKUs: phantom heaters in a bin, a grill season that broke the forecast, a warehouse full of last summer, a peak week with ten people missing.

What you work with

  • 10 interactive calculators that open in any browser: cycle count tracker, ABC/XYZ matrix, forecast model, reorder point and safety stock calculator, EOQ and min-max model, dead stock report, dock-to-stock flow map, warehouse KPI dashboard, shift staffing planner and a WMS scorecard.
  • Excel formulas for every calculation, so you can rebuild each model in your own workbook.
  • Ready prompts for Copilot in Excel, ChatGPT and Claude, plus five checks to run before you trust an AI answer.
  • Step-by-step demos of each calculator on real lesson numbers, and interface mockups of cycle counting, receiving and wave picking in a typical WMS.

Who teaches it

  • Mike, founder and head of an online academy, former HR director in media, gaming and tech companies.
  • 1,800,000+ course enrollments and 170,000 students in his courses.
  • Author of about 200 books on Amazon.
  • PHRi certified, HRCI representative in Eastern Europe, and the person who built the HR system of the unicorn Preply.

The path

First you make the records trustworthy with cycle counts and root causes. Then you classify SKUs, forecast demand, set safety stock and reorder points, size every order and clear the dead stock. Next you follow the warehouse flow from receiving to shipping and measure it with KPIs in dollars. Finally you plan the people and shifts, check safety, choose a WMS by weighted requirements and build your AI routine for inventory analysis.

What’s included

  • Lifetime access to all lessons, presentations and calculators.
  • Active instructor support in Q&A.
  • Certificate of Completion.
  • Practical assignments on your own SKUs and your own warehouse in every lesson.

Every month without a reorder point is a month of stockouts you paid for twice: once in lost sales and once in the stock that sat in the wrong place. Your competitors are already rebuilding their inventory with data and AI.

Enroll now and start your first lesson today.

Who this course is for:

  • Inventory managers, inventory controllers and inventory analysts who own stock levels in Excel and an ERP
  • Warehouse managers and supervisors running receiving, picking and shipping in one to five warehouses
  • Supply chain and operations specialists at retailers, distributors, e-commerce and manufacturing companies
  • Demand and replenishment planners who set reorder points, safety stock and order quantities
  • Small business and e-commerce owners fighting stockouts and overstock at the same time
  • Team leads about to step into an inventory or warehouse role
  • Operations managers choosing a WMS who want AI to speed up inventory analysis
Advertisements
PAPAHR_NOV_777865
Advertisements
Advertisements
Free Online Courses with Certificates
Logo
Register New Account