LISCOLearning Institute for
Supply Chain Optimization.
Supply Chain Optimization.
LISCOManage your entire supply chain with the power of Excel. Not Just Theory, Learn How to Apply End-to-End Supply Chain Practically with Excel.
Unlock the full potential of Microsoft Excel to manage your entire supply chain—from strategic planning to final delivery. This hands-on program shows you how to build dynamic, integrated dashboards that simplify operations, improve visibility, and support smarter, data-driven decisions at every stage.
Whether you're a professional looking to sharpen your skills or a student eager to gain practical SCM experience, this course is designed to make you Excel-confident and supply-chain ready. You'll learn how to use Excel’s analytical power to solve real operational challenges—from demand planning and procurement to inventory control and logistics.
If you’ve ever felt stuck between theory and real execution, this course closes that gap. Integrated Supply Chain Management with Excel gives you the tools, techniques, and hands-on practice to run a complete supply chain inside a single platform. By the end, you won’t just understand the process—you’ll be able to design it, control it, and improve it.
If you’re serious about leveling up your career and proving your impact with real, measurable results, this is the course you don’t want to miss.
By the end of this program, you will be able to:
Laptop or Mobile, Zoom or Google Meet Compatible
Learn from experts and earn a valuable certificate
Supply Chain Manager at Gazi International, Concern of Gazi Group. Former Asstt. Manager, Commercial & Planning at General Pharmaceuticals Ltd.,
MBA in Finance & Banking, PGD in Supply Chain Management, Certified Supply Chain Optimizer (CSCO)
He is trained in:
Certificate in Computer Application (CCA) from BCCT,
Inventory Management from BDJobs.com,
Supply Chain Management from Bangladesh Institute of Management (BIM),
Lean Six Sigma from Bangladesh Japan Training Institute (BJTI),
Become a Supply Chain Manager from linkedin.com
Emdadul Huq has over 20 years of experience in supply chain optimization and strategic planning. He has worked with renown companies to streamline their supply chain operations and reduce costs by up to 30%.
Upon successful completion, you'll receive:
Master these in-demand supply chain skills
Potential career paths after completing this program
Comprehensive learning journey over days
Goal: Build a strong foundation of how the entire supply chain works and create forecasting models in Excel.
1. Supply Chain Overview
• What supply chain really is and why it matters
• End-to-end process flow: Forecast → MPS → MRP → Procurement → Inventory → Delivery
• How information, materials, and money move through the supply chain
• Key concepts: SKU structure, lead time, safety stock, and basic terminology
2. Understanding SCM Processes
• Demand planning (Plan)
• Procurement and purchasing (Source)
• Production planning (Make)
• Inventory, warehouse & distribution management (Deliver)
3. Demand Forecasting Deep Dive
• Understanding demand patterns and seasonality
• Types of demand patterns: stable, trend, seasonal, irregular
• Excel forecasting models you’ll build:
o Simple Moving Average (SMA)
o Weighted Moving Average (WMA)
o Basic Trend Forecasting
4. Hands-On in Excel
• Cleaning and organizing historical sales data
• Building forecast models
• Creating a monthly forecast sheet
• Output: Forecast ready to feed into MPS
Goal: Turn demand forecasts into actionable production and material plans.
1. Master Production Schedule (MPS)
• What an MPS is and why it matters
• Converting forecasts into weekly/monthly schedules
• Linking MPS directly with inventory and material planning
• Hands-on: Build an Excel-based MPS planner
• Capacity planning: required vs. available
2. Production Planning
• How MPS drives the production plan
• Weekly/monthly production planning
• Batch sizing and lot control
• Production lead times
• Aligning production with material availability
• Understanding and using Bill of Materials (BOM)
3. Material Requirement Planning (MRP)
• What an MRP is and why it matters
• MRP logic: Gross requirement → Net requirement → Planned orders
• How BOM, inventory, and lead times integrate
• Real-world MRP flow in manufacturing
4. Hands-On in Excel
• Build an MPS sheet
• Create a working BOM structure
• Develop a full MRP calculator
• Generate planned purchase and production orders
Choose your preferred cohort
Everything you need to succeed
Watch this video to learn more about what you'll achieve in this course
Explore what makes our program unique
Interactive online learning platform with real-time collaboration
Expert instructors with industry experience
Hands-on projects based on real-world challenges
Comprehensive learning materials and case studies
Networking opportunities with industry professionals
Career support and job placement assistance
Join hundreds of professionals who have transformed their careers with LISCO
Browse All Programs