The Baseline: Normal Daily Orders, the Weekday Pattern and the Sale-Day Baseline
This lesson is part of the course
In this lesson
You tag four normal weeks of orders with their weekday, average the orders per weekday with AVERAGEIFS, turn them into a weekday index and estimate how many orders the sale day would bring without any sale.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Baseline: Normal Daily Orders, the Weekday Pattern and the Sale-Day Baseline Locked
- Break-Even Uplift: How Much More You Must Sell to Pay for the Discount Locked
- Discount Ladder: 10 / 20 / 30 % Scenarios, Margin per Order and the Free-Shipping Threshold Locked
- Event Forecast: Uplift Factors by Category, Units and Revenue per Day Locked
- Stock Build-Up: Units Needed, Case Packs, Lead Times and Latest Order Dates Locked
- Pull-Forward and the Post-Sale Dip: Net Incremental Units Locked
- Operations Peak: Orders per Hour, Packing Staff and Parcel Volumes vs Carrier Capacity Locked
- Post-Event Review: Incremental Profit, Returns Allowance, New vs Existing Customers and a Chart Locked