Supply Chain Management Using Excel

What You Will Learn:

• Understand how supply chain flows work, including forward and reverse logistics.

• Learn the SCOR model (Plan – Source – Make – Deliver – Return) and how to apply it in real scenarios.

• Use Excel to model and visualize core supply chain processes: inventory, procurement, logistics, and warehousing.

• Calculate Economic Order Quantity (EOQ), safety stock, reorder points, and manage lead times.

• Build a supplier evaluation matrix using scoring models based on cost, quality, and delivery.

• Design and evaluate facility locations using weighted scoring models.

• Track and improve warehouse KPIs: space utilization, cycle time, stock turnover.

• Create and simulate MRP plans and understand how JIT can improve operations.

• Build interactive dashboards in Excel to monitor supply chain performance using real-time KPIs.
  

Course Description:

In today’s fast-paced and cost-sensitive business environment, mastering supply chain operations is no longer optional — it's essential.

"Supply Chain Management Using Excel " is designed for professionals and students who want to understand the end-to-end flow of goods, data, and decisions across the supply chain — and apply it immediately using Microsoft Excel.

Through 8 hands-on sessions, you'll learn how to:

• Manage inventory effectively,

• Optimize procurement and supplier selection,

• Reduce logistics costs,

• Plan production using MRP and JIT,

• And track performance with real Excel dashboards.

This course bridges the gap between theory and practice, using real-world data models and tools that you can apply to your job or future career.

Whether you work in logistics, procurement, warehousing, or planning — or you're a business student — this course will equip you with the skills, tools, and mindset to improve supply chain performance and make smarter decisions using Excel.

Course Content:

Session 1: Introduction to Supply Chain & Excel Basics

• Supply chain flows (forward & reverse)

• SCOR model overview

• Key Excel tools for logistics data analysis

Session 2: Inventory Management

• EOQ, Safety Stock, Lead Time

• Reorder Point systems

• Dynamic inventory modeling in Excel

Session 3: Facility Location & Site Selection

• Decision factors & cost models

• Weighted scoring and analysis

• Excel-based facility comparison model

Session 4: Procurement & Supplier Evaluation

• Vendor scoring models

• Key supplier KPIs

• Excel tool for supplier comparison

Session 5: Transportation & Logistics Costing

• Cost analysis by mode (air, sea, road, rail)

• Transport route optimization using Excel Solver

Session 6: Warehouse & Storage Management

• Warehouse layout and space utilization

• KPI tracking (cycle time, stock turnover)

• Excel dashboard for warehouse operations

Session 7: Capacity Planning – MRP & JIT

• MRP principles and BOM structure

• JIT planning concepts

• Excel simulation of production plans

Session 8: Performance Measurement & Lean Tools

• OTIF, SLA, Fill Rate, Inventory Turnover

• Lean techniques: 5S, Kaizen, Value Stream Mapping

• Building a supply chain performance dashboard in Excel

Course Requirements:

1. You should be familiar with essential Excel functions like SUM, IF, and basic charts. No advanced Excel is needed , we’ll build up step by step.

2. Familiarity with concepts like inventory, procurement, or logistics is helpful, but not mandatory. We’ll cover the basics as we go.

3. Any recent version (Excel 2019 or later) will work. You’ll be using Excel in every session to complete practical exercises .

Who This Course is For:

• Logistics and supply chain professionals who want to enhance their practical skills using Excel.

• Procurement, warehousing, or operations staff looking to understand how to make data-driven decisions.

• Business analysts who work with supply chain or logistics data.

• Entrepreneurs and business owners who want to optimize their internal operations and supply chain performance.

• Anyone looking to bridge the gap between theory and practice in supply chain management through real Excel-based models.

Certification:

Upon completing this course, participants will receive:

• A certificate of completion from Assaal Academy.

• Option to obtain an additional certificate from the Egyptian Board Academy for an extra fee.