Supply Chain AI · Analytics · Training
Hyderabad · mathnal.tech
Professional Certification Program

Inventory
Optimization Program

Cut stockouts and excess at the same time. Master ABC/XYZ classification, demand-driven replenishment, safety-stock science and multi-echelon optimization with Excel, Python and Power BI — on real inventory decisions.

Duration
8 Weeks48 live hours
Format
Live + RecordedWeekend cohort
Level
Intermediate+ Capstone
Award
CIOP™Certification
01 — About the Program

Stop choosing between stockouts and dead stock.

Inventory is where cash, service and risk collide. Too little and you lose sales; too much and you bury working capital. This program teaches you to find the optimal balance with quantitative models instead of gut-feel buffers.

Every module pairs the planning concept with hands-on tooling. You leave able to segment a portfolio, size safety stock to a target service level, set the right replenishment policy per item, and ship an inventory health dashboard.

Who Should Attend

  • Inventory & materials planners
  • Supply & demand planners
  • Warehouse & operations managers
  • Procurement & category teams
  • Retail & e-commerce operations
  • SME founders managing stock
02 — What You'll Master

Six capabilities you'll walk away with.

/ 01
Portfolio Segmentation

ABC/XYZ classification to focus effort where it actually pays.

/ 02
Demand-Driven Planning

Forecast-linked replenishment instead of static reorder levels.

/ 03
Safety-Stock Science

Size buffers to a target service level, not a guess.

/ 04
Replenishment Policies

Design (s,S) and (R,Q) policies that fit each item class.

/ 05
Network Optimization

Balance and position stock across multi-echelon networks.

/ 06
Inventory Dashboards

Track turns, DOH and fill rate in living Power BI views.

03 — Curriculum

Ten modules, from cost structure to simulation.

M01
Inventory Foundations & Costs

Inventory types, holding/ordering/stockout costs and working-capital impact.

Excel
M02
ABC / XYZ Classification

Value–variability segmentation and differentiated stocking policy.

ExcelPython
M03
Demand Forecasting for Inventory

Moving average, exponential smoothing and forecast error metrics.

Python
M04
EOQ & Lot Sizing

Economic order quantity, quantity discounts and lot-size trade-offs.

ExcelSolver
M05
Safety Stock & Service Levels

Variability, service-level targets and safety-stock formulas.

Python
M06
Reorder Points & Replenishment

(s,S), (R,Q), periodic vs continuous review policies.

Excel
M07
Multi-Echelon Optimization

Positioning stock across distribution networks for least cost.

Python
M08
Slow-Moving, Obsolete & Perishable

SLOB analysis, shelf-life management and liquidation logic.

Excel
M09
Inventory KPIs & Dashboards

Turns, days-on-hand, fill rate and GMROI in Power BI.

Power BI
M10
Simulation & Scenario Planning

Monte Carlo on demand & lead-time risk, plus the capstone.

Python
04 — Tools & Tech Stack

Hands-on with the tools planners actually run.

Spreadsheet
Excel + Solver

EOQ, policy models, what-if analysis.

Programming
Python

pandas, SciPy, SimPy simulation.

Database
SQL

Pulling stock & movement data.

Visualisation
Power BI

Inventory health dashboards.

05 — Enrolment & Pricing

Choose the track that fits your team.

MOST POPULAR
Professional · Live Cohort
₹24,999
per participant
  • 8-week live weekend cohort
  • All recordings & datasets
  • Capstone project review
  • CIOP™ certification
Self-Paced eLearning
₹9,999
per learner
  • Full recorded curriculum
  • Workbooks & templates
  • Auto-graded assessments
  • Completion certificate
Corporate · In-House
₹2,49,000
flat · team up to 20
  • Built on your SKU & demand data
  • On-site or live online
  • Team capstone on a real category
  • Manager outcome report
College Batch · Model D
₹1,49,000
flat · cohort up to 60
  • Placement-oriented delivery
  • Industry capstone & mentoring
  • Faculty enablement session
  • Bulk CIOP™ certification

* Indicative pricing. GST as applicable. Early-bird and multi-seat discounts available on request.

06 — Certification & Faculty
CIOP
Awarded On Completion

Certified Inventory
Optimisation Professional™

Trained by practitioners, not slide-readers.

Mathnal Analytics is a supply chain AI, analytics and training firm based in Hyderabad. Our programs are designed and delivered by practitioners with deep hands-on experience in forecasting, optimization and inventory analytics across Python, SQL, Power BI and Excel.

Earn the CIOP™ credential by completing the modules and a capstone built on a real inventory problem — a portfolio piece you can show employers and clients.

Enrol Today

Free up cash. Protect service levels.

Seats per cohort are limited to keep capstone reviews personal. Reserve yours or request a corporate proposal.

Reserve a Seat →
Webmathnal.tech
Emailtraining@mathnal.tech
LocationHyderabad, India