Procurement & Supply Planning tools and techniques.

PROCUREMENT · SUPPLY PLANNING · MRP · MPS · EOQ · SAFETY STOCK · SUPPLIER SEGMENTATION · NEGOTIATION · INCOTERMS · CONTRACT MANAGEMENT · EXCEL SOLVER

★ Top Performer on Udemy for Business — Chosen by Companies for Procurement Team Training

This course is one of Udemy for Business’s top-performing supply chain courses — the platform used by companies like Nasdaq, Volkswagen, NetApp, and Eventbrite to upskill their teams. With 13,300+ enrolled students, it is the procurement course that corporate L&D teams select when they need their buyers, planners, and supply chain professionals to go beyond theory and actually know how to do the job.

★ The Complete Procurement Practitioner’s Guide — Not a Theory Overview

Most procurement courses on Udemy are 2–5 hours of concepts and frameworks. This course is 14 hours of hands-on, worked-example, do-it-yourself procurement practice — across 17 sections and 158 lectures. You will calculate EOQ with quantity discounts, build safety stock models, run MPS and MRP schedules, optimise sourcing with Excel Solver, apply the Krajlic matrix, analyse contracts, simulate negotiations with game theory, and measure supplier KPIs. Your hands and mind get to work from the first section. If you are building a career in procurement, this course is your practical handbook.

★ Taught by a Ph.D. in Supply Chain from the University of Bordeaux — With Real Client Experience

Haytham holds a Ph.D. in Supply Chain and Forecasting from the University of Bordeaux and a Master of Science in Global Supply Chain Management from Bordeaux École de Management. His consulting clients include Sephora France, Sharaf Group, Aster Group, DNO, PWC Training Academy Dubai, and the Higher College of Technology. Every procurement model, negotiation framework, and supply planning tool in this course has been applied in real client engagements — not adapted from textbooks.

★ End-to-End: From Procurement Strategy to MRP — 17 Sections Covering the Entire Procurement Function

This course covers the full procurement and supply planning function in one program: procurement strategy and process, supplier segmentation and risk, inventory management (EOQ, safety stock, seasonal products), demand forecasting, production scheduling (MPS), material requirements planning (MRP), make-or-buy decisions with optimisation, contract law and Incoterms, negotiation strategy and game theory, KPI measurement, and supplier evaluation. No other procurement course on Udemy covers all of these in a single, coherent program.

★ Procurement Optimisation with Excel Solver — Added by Student Demand

A full chapter on procurement cost optimisation with Excel Solver was added in September 2023 in response to student requests. You will optimise sourcing decisions with capacity constraints, transport and customs costs, fixed administrative costs, and volume discounts — the same type of model that sourcing analysts build for real supplier negotiations and contract awards. This makes the course uniquely analytical among all procurement courses on the platform.

Most procurement courses give you a map. This course gives you the tools to actually navigate. Across 17 sections and 14 hours of hands-on, worked-example content, you will calculate, model, optimise, negotiate, and plan your way through the complete procurement and supply planning function — from purchasing strategy and supplier segmentation to EOQ, MPS, MRP, contract law, Incoterms, and negotiation with game theory. Your hands and mind get to work from the first lecture.

The course is structured as a supply planning journey: you are responsible for forecasting demand, planning production with MPS, and determining material requirements with MRP — just as a procurement or supply planning professional does in practice. Along the way you will master the analytical tools that separate good procurement professionals from great ones: EOQ with quantity discounts, safety stock for finished goods and components, seasonal inventory with critical ratio, and procurement cost optimisation with Excel Solver.

This course is a top performer on Udemy for Business and is taught by a Ph.D. in supply chain from the University of Bordeaux who has trained procurement and supply chain teams at Sephora France, Sharaf Group, Aster Group, and PWC Training Academy Dubai. The analytical rigour comes from doctoral research. The practical relevance comes from live consulting. The depth comes from 14 hours of content that never brushes past a concept without making you apply it.

WHAT MAKES THIS COURSE DIFFERENT

[ FULL ]

17 sections — the entire procurement function

From procurement strategy to MRP, safety stock, forecasting, negotiation, game theory, Incoterms, and KPIs. No other single course covers the full procurement and supply planning function this comprehensively.

[ HANDS ]

Hands-on throughout — calculate, model, optimise

Every concept is worked through in Excel: EOQ with discounts, MPS, MRP, safety stock, critical ratio, Solver optimisation, supplier KPIs. You leave with models you can use tomorrow.

[ THEORY ]

Theory + analytics + negotiation strategy together

Most courses teach procurement process OR quantitative models OR negotiation. This course teaches all three — because the best procurement professionals need all three simultaneously.

TOOLS COVERED IN THIS COURSE

Microsoft Excel | Excel Solver | MPS & MRP Templates | Procurement Frameworks & Worksheets

WHAT YOU WILL LEARN

✓ Understand the procurement function: types of organisational purchases, the procurement process, bidding strategies, RFQ and RFP, and the full purchasing cycle

✓ Segment your suppliers using ABC analysis, multi-criteria segmentation, and the Krajlic matrix — and develop a sourcing strategy for each quadrant

✓ Calculate EOQ with quantity discounts, marginal discounts, lead time, and sensitivity analysis in Excel

✓ Calculate safety stock using two methods for finished goods, materials, and components under demand and lead time variability

✓ Apply seasonal inventory management: critical ratio, point of maximum profit, and data table optimisation in Excel

✓ Forecast demand for procurement purposes using qualitative, quantitative, linear regression, and supply planning journey approaches

✓ Build Master Production Schedules (MPS) using lot-for-lot, periodic planning, fixed horizon, and optimised production methods

✓ Run Material Requirements Planning (MRP) end-to-end: from the end product through plastic and components with bill of materials

✓ Apply make-or-buy analysis: break-even quantity, fixed and variable costs, contribution margin, and procurement optimisation with Excel Solver

✓ Understand contracts: types, clauses, fixed price incentive fee, cost-plus, compensation, suspension, and the full tender process

✓ Master Incoterms and international payment terms — including the difference between EXW, FOB, CIF, DDP, and DAP in practice

✓ Apply negotiation strategies: warrior, diplomatic, collaborative; game theory (Prisoner’s Dilemma, Stag Hunt, Chicken); and the red sheet framework

✓ Measure procurement performance: cost control KPIs, service level KPIs, benchmark types, supplier evaluation, and total landed cost analysis

COURSE CONTENT — 17 SECTIONS · 158 LECTURES · 14 HOURS · 1 PRACTICE TEST

PART 1 — PROCUREMENT FUNDAMENTALS & STRATEGY

SECTION 1: Supply chain overview and procurement fundamentals

Set the foundation. Understand supply chain views, objectives, and planning tools. Define the procurement space — vertically and horizontally integrated supply chains. Learn why procurement matters, what the best deal looks like, procurement strategies, the full procurement process, bidding strategies, RFQ vs RFP, the purchasing cycle, purchase orders, total landed cost, and the hidden costs behind every purchasing decision. Two quizzes including one dedicated to total landed cost.

Concepts Excel

SECTION 2: Supplier segmentation: ABC analysis and multi-criteria

Not all suppliers deserve the same attention. Apply ABC segmentation to both products and suppliers. Build multi-criteria segmentation models. Use the ABC demo in Excel to classify your supplier base and understand which relationships drive the most value — and which carry the most risk. Graded assignment.

Excel

SECTION 3: Supplier risk: the Krajlic matrix and risk mitigation

Strategic sourcing requires understanding risk. Apply the Krajlic matrix to map suppliers across four quadrants (routine, leverage, bottleneck, strategic). Measure and score supplier risk. Develop mitigation strategies for each quadrant, with specific approaches for leverage items and strategic partnerships. Graded quiz.

Frameworks

PART 2 — INVENTORY AND SUPPLY PLANNING

SECTION 4: Economic Order Quantity: from basics to real complexity

Build EOQ from first principles: why we hold stock, inventory strategies and types, total logistics cost and total relevant cost. Then extend to real operational complexity: EOQ with quantity discounts, EOQ sensitivity analysis, and EOQ with lead time. All in Excel with graded assignment and solution.

Excel

SECTION 5: Safety stock for uncertain demand

Demand and lead time are never exactly as planned. Calculate safety stock using two distinct methods under demand variability and lead time variability. Set inventory policies for finished goods, materials, and components. Understand the re-order point with lead time uncertainty. Graded assignment.

Excel

SECTION 6: Seasonal products and critical ratio

Seasonal inventory lives and dies by its sell-through. Model seasonal demand, identify the point of maximum profit, apply the data table method, calculate critical ratio in Excel, and understand what is actually happening probabilistically when you set an order quantity. Graded assignment with full solution.

Excel

PART 3 — FORECASTING AND PRODUCTION PLANNING

SECTION 7: Demand forecasting for procurement

Procurement decisions depend on what you expect to need. Understand qualitative vs quantitative forecasting, optimistic vs pessimistic approaches, and the supply planning journey. Apply linear regression for demand forecasting: prepare data, fit the model, and forecast next year’s demand. Graded assignment with full solution.

Excel

SECTION 8: Master Production Scheduling (MPS)

Given a demand forecast, when should you produce and how much? Build MPS using four approaches: one-time production, lot-for-lot, periodic planning, and fixed production horizon. Then optimise the production plan using Excel Solver with constraints. Graded assignment with full solution walkthrough.

Excel Solver

SECTION 9: Material Requirements Planning (MRP)

MPS tells you what to make. MRP tells you what to buy and when. Build the full MRP cascade from the end product through sub-assemblies and components. Work through the end product MRP, screen MRP, and plastic MRP with bill of materials. Graded assignment with solution.

Excel

PART 4 — MAKE-OR-BUY AND PROCUREMENT OPTIMISATION

SECTION 10: Make-or-buy analysis and procurement optimisation with Excel Solver

Should you make it in-house or source it? Apply break-even quantity analysis, fixed and variable cost modelling, and contribution margin calculation to make-or-buy decisions. Then apply Excel Solver to procurement cost optimisation: model without constraints, add supplier capacity constraints, transport and customs clearance costs, fixed administrative costs, volume discounts (two-part), and marginal volume discounts. Includes a UAE Airlines optimisation case.

Excel Solver

PART 5 — CONTRACTS, INCOTERMS & LEGAL FRAMEWORKS

SECTION 11: Contracts: types, clauses, and the tender process

Every purchase above a threshold requires a contract. Understand the difference between terms and conditions, characteristics of contracts, fixed price incentive fee contracts, and cost-plus contracts. Learn the key contract clauses, compensation provisions, suspension of work, and the full tender process step by step.

Frameworks

SECTION 12: Incoterms and international payment terms

International procurement requires a shared language. Learn the full Incoterms framework: Part 1 (EXW, FCA, CPT, CIP, DAP, DPU, DDP) and Part 2 (FAS, FOB, CFR, CIF), with a worked Incoterms example. Then master payment terms used in purchase orders and contracts.

Frameworks

PART 6 — NEGOTIATION STRATEGY

SECTION 13: Negotiation strategies and cultural intelligence

Procurement is ultimately a negotiation. Learn the three core strategies: warrior, diplomatic, and collaborative. Apply the red sheet framework to structure any negotiation. Understand how culture affects negotiation style and how to adapt to the culture of your counterpart.

Frameworks

SECTION 14: Game theory for procurement negotiations

The most analytically rigorous section of the course. Apply game theory to procurement negotiations: the Prisoner’s Dilemma, the Stag Hunt strategy, the Chicken strategy, and the Trust strategy. Understand which equilibrium each strategy produces and use game theory to predict and influence supplier behaviour in real negotiations.

Frameworks Game Theory

PART 7 — COST ANALYSIS AND KPI MEASUREMENT

SECTION 15: Cost-benefit analysis for procurement decisions

Make the financial case for every procurement decision. Apply non-time-based CBA and CBA with Net Present Value to purchasing, outsourcing, and supplier investment decisions.

Excel

SECTION 16: Procurement KPIs, benchmarking, and supplier evaluation

Measure and improve procurement performance. Apply cost control KPIs, service level KPIs, benchmark types, bid evaluation methodology, supplier evaluation frameworks, and assets turnover analysis. Includes a quick quiz.

Frameworks Excel

THIS COURSE IS NOT FOR YOU IF...

✗ You are looking for a 2–3 hour procurement overview — this is 14 hours of hands-on, applied content; if you want a quick summary of procurement concepts, a shorter course may be more appropriate

✗ You want a Python or data science course — this course uses Excel throughout; the analytical tools are Excel-based models and frameworks, not code

✗ You need a CIPS certification prep course — this course builds practical skills and analytical models, not exam question formats

✗ You have no interest in the quantitative side of procurement — EOQ, safety stock, MPS, and MRP are core modules; if you only want the soft-skills side of procurement, the later sections on negotiation and contracts are available separately

WHAT STUDENTS AND CLIENTS SAY

“Haytham mentored me in my role of Head of Supply Chain Efficiency. He is extremely knowledgeable about supply chain concepts, latest trends, and benchmarks. His analytics-driven approach was very helpful to recommend and implement significant changes to our supply chain.”

Saify Naqvi — Head of Supply Chain Efficiency — Aster Group

“Very good course for general knowledge in the field of procurement. Well-structured and covers everything a procurement professional needs to know, from supplier segmentation through to contract clauses and negotiation strategy.”

Miha — Verified Udemy student

“I participated in the Supply Chain Forecasting & Management training conducted by Haytham. It helped me enormously in my daily work in the purchasing department. Haytham has the pedagogy to explain very difficult calculations and formulas in a simple way. I highly recommend this training.”

Djamel Bouremiz — Purchasing Manager, Mineral Circles Bearings W.L.L.

“Very helpful course on supply chain and procurement. Good mapped-out lecture sections from start to finish. Real-life examples of the theories learned are included throughout.”

Muhammad Nabil — Verified Udemy student

WHO THIS COURSE IS FOR

Procurement and purchasing professionals

You manage supplier relationships, negotiate contracts, and issue purchase orders — and want a rigorous, analytical framework that makes every decision more defensible and every negotiation better prepared.

Supply chain planners and analysts

You are responsible for production planning, material requirements, or inventory management and want the quantitative tools — MPS, MRP, EOQ, safety stock — to plan supply with precision.

Inventory and operations managers

You manage stock levels, reorder points, and safety stock across a product range and want to understand the analytical models — EOQ, critical ratio, seasonal inventory — that justify those decisions.

Demand planning and forecasting professionals

You produce demand forecasts to feed procurement and production schedules and want a structured, model-driven approach to forecasting that connects directly to MPS and MRP outputs.

Logistics and supply chain students

You are studying supply chain, operations, or business and want a course that goes beyond theory — giving you the practical frameworks, Excel models, and analytical tools that employers actually look for.

Career changers entering procurement

You are transitioning into procurement or supply chain from another field and want a complete, structured program that gives you both the domain knowledge and the practical skills to operate from day one.

REQUIREMENTS

● Motivation to learn procurement and supply chain — this is the only formal requirement listed on the Udemy page, and intentionally so: no prior knowledge of procurement, supply chain, or analytics is assumed.

● Basic familiarity with Microsoft Excel is helpful for the inventory, forecasting, MPS, MRP, and optimisation sections — but all Excel models are built step by step from scratch.

● No programming, coding, or data science background required — every analytical tool in this course uses Excel.

WHAT IS INCLUDED

● 17 sections, 158 lectures, and 14 hours of on-demand content covering the complete procurement and supply planning function

● 23 downloadable resources: Excel workbooks, procurement templates, MPS/MRP files, and case study datasets

● 1 practice test and multiple graded assignments across every section — assessed on real procurement and supply chain cases

● Excel Solver procurement optimisation chapter added September 2023 — covering capacity constraints, transport costs, fixed costs, and volume discounts

● Game theory negotiation models — Prisoner’s Dilemma, Stag Hunt, Chicken, and Trust strategies applied to procurement negotiations

● Incoterms and payment terms reference — a complete guide to international trade terms used in purchase orders and contracts

● Lifetime access to all content and any future updates to the curriculum

● 30-day money-back guarantee — no questions asked

● Certificate of completion upon finishing the course

YOUR INSTRUCTOR

Haytham Omar, Ph.D.

Supply Chain & Business Intelligence Consultant · Developer · Trainer — UAE & France · Founder, Rescale Analytics & Keip, Bordeaux

Haytham holds a Ph.D. in Supply Chain and Forecasting from the University of Bordeaux and a Master of Science in Global Supply Chain Management from Bordeaux École de Management. He has trained over 70,000 supply chain and procurement professionals across 70+ workshops in the UAE, and his consulting clients include Sephora France, Sharaf Group, Aster Group, DNO, Qarar, Lamprell, PWC Training Academy Dubai, and the Higher College of Technology.

His procurement expertise spans sourcing strategy, supplier segmentation, contract negotiation, MRP and MPS planning, and supply chain optimisation — all of which he teaches and deploys with active clients. He is also the creator of the Inventorize package for Python and R — used by over 90,000 supply chain professionals worldwide.

This course is the most comprehensive procurement and supply planning course Haytham has built — 17 sections that cover the complete procurement function from strategic sourcing through to quantitative supply planning. It is taught by someone who has worked in procurement, consulted in procurement, and trained procurement teams at some of the largest organisations operating in the Gulf region and France.

If you are building a career in procurement, this course is your practical handbook.

17 sections · 14 hours · EOQ to MRP · Negotiation & game theory · Excel Solver optimisation · Ph.D. instructor · Udemy for Business