Inventory Optimization: E-com SCM & Logistics

Learning Goal: Mastering inventory optimization and supply chain management for rapidly growing e-commerce brands.

• Prerequisites: Basic business math and familiarity with spreadsheet environments (like Microsoft Excel or Google Sheets).
• Estimated Total Study Time: 14 hours

Module 1: Introduction to E-commerce SCM & Logistics

This module establishes the core framework of supply chain management (SCM) and logistics within the digital retail ecosystem. You will examine the transition from traditional linear distribution networks to highly agile, consumer-centric e-commerce setups, tracking how information and physical goods move from manufacturers to final customer doorsteps.

Recommended Videos

Logistics and Supply Chain Management: An Introduction

@EMPCIGNOU29:55280

Logistics and Supply Chain Management: An Introduction

Logistics and Supply Chain Management (LSCM) is the integrated process of planning, implementing, and controlling the flow of materials, information, and resources from suppliers to end customers, involving key functional areas such as order processing, inventory control, warehousing, transportation, and packaging. The system approach views material flow as a single chain requiring close coordination among all players (suppliers, manufacturers, warehouses, retailers, and customers) to achieve co

@EMPCIGNOU · 29:55

• Why this video: This academic lecture lays down a structured foundation of logistics and supply chain theory. It defines key terminologies (inbound/outbound logistics, information flow) necessary to build professional competency before diving into e-commerce-specific scenarios.

Ecommerce model and how supply chain of online shopping works

@manishjain631701:427702

Ecommerce model and how supply chain of online shopping works

The e-commerce supply chain operates through a sequential process where consumer orders placed on platforms like Amazon or eBay are processed by order management teams, then shared with central warehouses which coordinate with local warehouses and suppliers to fulfill orders through multi-stage shipping from supplier to central warehouse, then to local warehouse, and finally delivered to the customer.

@manishjain6317 · 01:42

• Why this video: This concise, visual explainer shows the practical architecture of online shopping networks. It traces order placement, central warehousing systems, order management routing, and last-mile operations, making abstract logistics concepts tangible.

Inside Amazon: Secrets of an Online Mega-Giant

@ABCNews04:412853763

Inside Amazon: Secrets of an Online Mega-Giant

This video illustrates the complete e-commerce supply chain process. When customers place online orders, items are retrieved from fulfillment center shelves, placed into barcoded bins, and tracked through extensive warehouse facilities using conveyor belts and scanning systems. Workers then pack items, add verification notes, and prepare shipments. Packages are delivered to customers' doorsteps within approximately 48 hours. This end-to-end process demonstrates how modern e-commerce platforms ma

@ABCNews · 04:41

• Why this video: This deep dive inside Amazon's fulfillment centers reveals the high-tech reality of modern e-commerce operations. Seeing how inventory is barcoded, dynamically stored, retrieved, and shipped illustrates the standard of speed and efficiency that modern brands are up against.

Amazon FBA vs Shopify (Which One Is Better?)

@MoneyTalksMediaCo03:49102

Amazon FBA vs Shopify (Which One Is Better?)

Amazon FBA handles fulfillment automatically but charges daily storage fees and per-item fees, potentially leaving only $8 profit on a $30 product. Shopify offers higher margins ($15 profit) but requires $20+ in ad spend per customer. Amazon risks account suspension and fee changes, while Shopify risks ad inefficiency and logistics issues. The smartest founders use both: launch on Amazon for quick cash flow, then transition loyal customers to Shopify for long-term brand ownership. Choose Amazon

@MoneyTalksMediaCo · 03:49

• Why this video: For an e-commerce strategist, picking a sales and fulfillment platform dictates margin structure and supply chain control. This video provides a direct, financial contrast between Amazon FBA's automatic but costly fulfillment and Shopify's higher-margin, merchant-managed approach.

Knowledge Checkpoint

• Contrast inbound and outbound logistics and explain how they interact within a digital retail platform.
• Trace the path of an e-commerce order from the click of the "buy button" to dispatch from a central fulfillment hub.
• Define the core trade-offs between third-party automated distribution networks (like Amazon FBA) and independent store control (like Shopify).

Module 2: Inventory Fundamentals & Key Metrics

This module transitions from high-level supply flows to the mathematical principles governing inventory holding. You will learn how to calculate variables designed to buffer against supplier delays and market volatility, balance warehousing costs against the risk of stockouts, and monitor overall inventory health.

Recommended Videos

How Do You Calculate Safety Stock and Reorder Points in Inventory Management? | Unleashed

@unleashedsoftware03:2514468

How Do You Calculate Safety Stock and Reorder Points in Inventory Management? | Unleashed

Calculating safety stock requires analyzing historical data including maximum daily usage, average daily usage, maximum lead time, and average lead time. The safety stock formula is: (Maximum Daily Use × Maximum Lead Time) - (Average Daily Use × Average Lead Time). Using this formula with example data (maximum daily use = 100 units, average daily use = 90 units, maximum lead time = 15 days, average lead time = 5 days), the calculated safety stock equals 1,050 units. The reorder point formula bui

@unleashedsoftware · 03:25

• Why this video: Calculating safety stock protects growing brands from unexpected disruptions. This tutorial explains the variables required—including maximum daily usage, average daily usage, and lead times—to compute defensible safety stock levels and reorder points (ROP).

How to Calculate Inventory - Q R Model (Min Max)

@mfgsupplychainforum03:4214076

How to Calculate Inventory - Q R Model (Min Max)

Safety stock (SS) formula: SS = Z × Sigma_L × √L, where Z is the Z-score for service level. For 95% service level, Z = 1.64 (from NORM.S.INV(0.95)). With Sigma_L = 182.5 and L = 2, SS = 1.64 × 182.5 × √2 ≈ 423 units. Reorder point (R) formula: R = mu × L + SS. Using mu = 250, L = 2, SS = 423, R = 250 × 2 + 423 = 923 units. These calculations ensure desired service level while minimizing inventory costs.

@mfgsupplychainforum · 03:42

• Why this video: This video introduces the statistical precision of the Q-R (Min-Max) inventory model. It demonstrates how to integrate a specific service level Z-score (such as 1.64 for a 95% service level) and demand standard deviations to establish robust safety stock.

Advanced Forecasting & Inventory Control | Inventory Planner | Demand Forecasting for eCommerce

@InventoryPlanner05:0911104

Advanced Forecasting & Inventory Control | Inventory Planner | Demand Forecasting for eCommerce

Four foundational metrics assess current inventory status: (1) Stock turn measures how quickly inventory converts to cash, calculated as revenue divided by inventory cost value; (2) GMROI (Gross Margin Return on Investment) shows return on investment after vendor costs; (3) Inventory valuation considers both cost value (vendor payments) and retail value (potential revenue); (4) On-order inventory tracks purchase orders in transit affecting cash flow timing. ABC classification categorizes items b

@InventoryPlanner · 05:09

• Why this video: Effective inventory optimization requires tracking health metrics beyond basic stock levels. This guide breaks down fundamental, advanced KPIs like Stock Turn (revenue divided by inventory cost value) and GMROI (Gross Margin Return on Investment), which assess how efficiently working capital converts to cash.

Acknowledging Coverage Gaps

• SKU Rationalization: The video pool has limited dedicated coverage of SKU rationalization (auditing and weeding out underperforming variants). To master this, we recommend searching YouTube independently for "SKU rationalization matrix e-commerce tutorial" to learn how to categorise your catalog into A, B, and C performers.

Knowledge Checkpoint

• Calculate the Reorder Point (ROP) using the standard formula: $ROP = (\text{Average Daily Demand} \times \text{Lead Time}) + \text{Safety Stock}$.
• Calculate Safety Stock mathematically, accounting for demand variations (standard deviation) and targeted customer service levels (Z-score).
• Explain how GMROI bridges the gap between marketing margins and inventory efficiency.

Module 3: Demand Forecasting & Replenishment Planning

Overstocking drains cash reserves, while understocking limits revenue. This module covers predictive analytics and algebraic optimizations. You will learn to build data-driven sales forecasts and calculate the Economic Order Quantity (EOQ) to minimize combined holding and ordering costs.

Recommended Videos

EOQ Economic Order Quantity formula and explanation

@Edspira10:15302310

EOQ Economic Order Quantity formula and explanation

The Economic Order Quantity (EOQ) formula calculates the optimal order size that minimizes total inventory costs by balancing ordering costs (cost to place each order) against carrying costs (cost to store inventory). The formula is Q* = √(2RD/H), where R is the order cost, D is the annual demand, and H is the carrying cost per unit per year. For example, with an order cost of $50, annual demand of 200 units, and carrying cost of $2 per unit per year, the optimal order quantity is 100 units.

@Edspira · 10:15

• Why this video: This video provides a clear, foundational explanation of the Economic Order Quantity (EOQ) formula: $EOQ = \sqrt{\frac{2DS}{H}}$ It explains the relationship between annual demand ($D$), ordering costs ($S$), and unit carrying costs ($H$), laying a solid foundation for your replenishment decisions.

How to forecast sales and revenue in Excel

@MelCompton09:078596

How to forecast sales and revenue in Excel

Excel's Forecast Sheet feature enables users to predict future sales or revenue by analyzing historical data patterns, providing a forecast line with upper and lower confidence bounds that indicate the predicted range of values based on past trends, while offering customization options for confidence intervals, seasonality detection, and handling of missing or duplicate data points.

@MelCompton · 09:07

• Why this video: This video offers a practical step-by-step tutorial on using Microsoft Excel's built-in "Forecast Sheet" feature. You'll learn to process historical e-commerce transactional data, automatically account for seasonal cycles, and establish high and low confidence boundaries.

Build a Forecast for Your Subscription Brand (FREE TEMPLATE INCLUDED)

@StoreHero03:1628659

Build a Forecast for Your Subscription Brand (FREE TEMPLATE INCLUDED)

A complete e-commerce forecast template consists of two main sections: inputs/assumptions and the generated forecast. The input section contains yellow-highlighted values that users can modify, including starting month selection, cost of goods percentage, and operational expenses. The forecast section generates monthly projections based on these inputs. Key metrics tracked include net sales, cost of goods, marketing spend, contribution margin, operating expenses, and net profit for each month ov

@StoreHero · 03:16

• Why this video: This e-commerce-specific forecasting walkthrough illustrates how to build dynamic spreadsheets using operational inputs, active marketing assumptions, and historical customer cohorts to project demand.

Knowledge Checkpoint

• Calculate the Economic Order Quantity (EOQ) when given annual item demand, fixed order fees, and inventory storage cost percentages.
• Create an automated monthly demand projection chart in Excel using historical, multi-year sales data.
• Differentiate qualitative forecasting methods (e.g., Delphi Technique) from quantitative methods (e.g., historical time-series regression).

Module 4: Warehouse Management & Order Fulfillment

Even the best inventory plan will fail if warehouse operations are inefficient. This module covers physical facility layouts, picking and packing strategies, and logistics partnerships. You will analyze in-house warehouse configurations and learn how to manage outsourced third-party logistics (3PL) models.

Recommended Videos

Revolutionizing Logistics: The Goods-to-Person Approach for Efficient Supply Chains

@alpinesupplychainsolutions850015:05135

Revolutionizing Logistics: The Goods-to-Person Approach for Efficient Supply Chains

This comprehensive section covers the complete spectrum of warehouse picking and packing operations. Five picking strategies progress from simple discrete picking (individual orders with high accuracy) through badge picking (multiple orders per trip), zone picking (fixed zones with product delivery), wave picking (batching by shipping deadlines), to multi-order picking (simple orders near docks). Three packing strategies balance quality versus efficiency: individual packing (maximum oversight),

@alpinesupplychainsolutions8500 · 15:05

• Why this video: Designed to address a critical gap in warehouse layouts, this deep dive outlines various picking systems. It covers everything from basic paper-guided collections to advanced wave, batch, and automated goods-to-person workflows.

Let's make picking easy with Odoo

@Odoo07:0117183

Let's make picking easy with Odoo

Three primary picking strategies optimize warehouse operations: (1) Wave picking assigns employees to specific zones/shelves who pick orders independently and consolidate at a central table, (2) Batch picking collects all products for multiple orders onto a single trolley before consolidation, and (3) Cluster picking extends batch methods by immediately sorting items into destination-specific packages during picking. Each strategy balances efficiency gains against implementation complexity.

@Odoo · 07:01

• Why this video: This software demonstration shows how warehouse management systems (WMS) optimize floor operations. It clearly contrasts batch picking (gathering inventory for multiple orders at once) with wave picking (staging orders by zone/shipping carrier), showing how they improve warehouse throughput.

What Is Third Party Logistics (3PL) Simple Guide

@Ennilogistics00:421031

What Is Third Party Logistics (3PL) Simple Guide

Third-party logistics (3PL) is a business model where companies outsource their warehouse, inventory management, and distribution facilities to third-party logistics providers. In this arrangement, the company acts as a client of the 3PL provider rather than maintaining its own logistics department or warehouses. This outsourcing allows businesses to focus on their core operations while leaving logistical activities to specialized external partners.

@Ennilogistics · 00:42

• Why this video: An essential, fast introduction to the concept of third-party logistics. It highlights how businesses delegate their warehousing, raw stock management, and customer packaging to external specialists.

How to Fulfill Shopify Orders with Amazon FBA for Free | Tutorial

@scott_suggs07:1118704

How to Fulfill Shopify Orders with Amazon FBA for Free | Tutorial

To fulfill Shopify orders using Amazon FBA inventory, connect your Shopify account with Amazon through the Shopify Help Center, configure shipping settings (offering standard shipping based on order value rather than weight), sync products by changing inventory management to 'managed by Amazon Marketplace' and entering Amazon SKUs, then manually fulfill orders by clicking 'request fulfillment' and selecting the customer's shipping method, with Amazon handling the rest of the fulfillment process.

@scott_suggs · 07:11

• Why this video: This step-by-step tutorial bridges software integration and physical logistics. It shows how to connect a Shopify store with Amazon Multi-Channel Fulfillment (MCF) to automate order fulfillment.

Knowledge Checkpoint

• Differentiate between discrete, batch, and wave warehouse picking processes, and identify when to use each.
• List the operational trade-offs of using an outsourced 3PL warehouse versus managing an in-house facility.
• Configure the settings required to connect a Shopify storefront to an external fulfillment network like Amazon FBA.

Module 5: Multi-Channel Logistics & Supply Chain Scaling

Scaling an e-commerce brand requires managing multiple sales channels (Shopify, Amazon, wholesale) without siloing your inventory. This module covers advanced scaling strategies. You will learn to manage multichannel supply networks, mitigate the costly "Bullwhip Effect" across your supply chain, and use modern software to sync your stock in real-time.

Recommended Videos

Why Everything Is On Sale: The Bullwhip Effect | WSJ

@wsj04:28601019

Why Everything Is On Sale: The Bullwhip Effect | WSJ

The bullwhip effect is a phenomenon where small fluctuations in consumer demand cause progressively larger variations as they move up the supply chain, leading to excessive inventory buildup when retailers overestimate demand based on initial trends, which then amplifies through each stage of distribution, resulting in markdowns and sales as companies work to clear excess stock.

@wsj · 04:28

• Why this video: This Wall Street Journal production illustrates the Bullwhip Effect. It shows how minor changes in consumer purchases can turn into massive oversupply or shortages as orders travel up the supply chain.

Bullwhip Effect in a Supply Chain

@cscplearning104412:427659

Bullwhip Effect in a Supply Chain

The bullwhip effect is a supply chain phenomenon where small demand fluctuations at the retail level cause progressively larger fluctuations at upstream levels (wholesale, distributor, manufacturer, and raw material suppliers), resulting in increased inventory, overproduction, and inefficiencies throughout the supply chain. This effect occurs due to factors including lack of communication, lead time variability, inaccurate demand forecasting, excessive discounts and promotions, large order inter

@cscplearning1044 · 12:42

• Why this video: This deeper academic analysis breaks down the root causes of the Bullwhip Effect, such as order batching, price variations, and rationing. It also provides actionable strategies to stabilize your supply chain.

Veeqo Walkthrough - Is This the Best Inventory Software for New Sellers?

@MyAmazonGuy00:418989

Veeqo Walkthrough - Is This the Best Inventory Software for New Sellers?

Vico provides unified inventory visibility across all connected marketplaces. Whether a seller operates on Amazon, Shopify, Walmart, or other platforms, Vico allows them to understand their complete inventory status from a single dashboard. This multi-channel inventory management capability is particularly valuable for sellers who fulfill orders themselves and need to track stock levels across different sales channels.

@MyAmazonGuy · 00:41

• Why this video: Managing multiple storefronts without dedicated inventory software often leads to stockouts or double-selling. This walkthrough demonstrates how systems like Veeqo sync stock levels across Amazon, Shopify, and eBay in real-time.

No BS Advice to Scale From 7 to 8 Figures with Your Ecom Brand

@thedanielbudai00:31100

No BS Advice to Scale From 7 to 8 Figures with Your Ecom Brand

Solid logistics can pull multiple levers for e-commerce growth: (1) Decrease cost of goods for larger margins; (2) Make delivery faster to increase customer happiness, LTV, and conversion rate; (3) Make delivery cheaper through smart logistics; (4) Open new locations and countries; (5) Improve cash flow cycle by paying fulfillment companies later. The speaker notes that logistics is often overlooked but is a significant opportunity for growth.

@thedanielbudai · 00:31

• Why this video: This high-level summary outlines the three main supply chain levers needed to scale from 7 to 8 figures: reducing cost of goods sold (COGS), speeding up delivery times, and optimizing working capital.

Knowledge Checkpoint

• Define the Bullwhip Effect and explain how over-ordering at the retail level creates severe factory-level disruptions.
• List three ways to minimize the Bullwhip Effect in an e-commerce supply chain.
• Explain how a multi-channel inventory management system prevents double-selling on different platforms during sales spikes.

Course Map

This map outlines the recommended learning path and shows how the modules build on one another.

Key People Index

• Professor Hau Lee (Stanford Graduate School of Business): One of the world's leading authorities on supply chain management. He is widely recognized for his pioneering research on the "Bullwhip Effect" (often called the Lee-Forrester effect), which explains how demand variability amplifies as it moves upstream.
• Michael Burry (Founder of Scion Asset Management): Well-known macro investor who frequently highlights how post-pandemic inventory cycles and the "Bullwhip Effect" influence consumer inflation, supply chain overcorrections, and wholesale liquidation trends.

Final Self-Assessment

Complete this comprehensive self-assessment to verify your mastery of e-commerce inventory optimization.

• I can clearly explain the differences between inbound logistics, outbound logistics, and last-mile operations.
• I can calculate safety stock using the standard deviation of lead time and demand, along with a specified service level Z-score.
• I can calculate a brand's Reorder Point (ROP) for any product based on average daily sales, supplier lead times, and safety stock.
• I can calculate the Economic Order Quantity (EOQ) to find the ideal balance between ordering and carrying costs.
• I can run a sales and revenue forecast in Microsoft Excel using historical data and its built-in Forecast Sheet tools.
• I can calculate Stock Turn and GMROI to evaluate how efficiently a business is using its working capital.
• I can differentiate between discrete, batch, and wave picking, and identify which strategy fits a given warehouse layout.
• I can outline the steps needed to integrate a Shopify storefront with Amazon Multi-Channel Fulfillment (MCF) for automated shipping.
• I can define the "Bullwhip Effect," identify its main causes, and implement three strategies to minimize its impact.
• I can explain how real-time inventory management software syncs stock levels across multiple sales channels to prevent overselling.