See which promotions add margin after discounts and returns
An illustrative retail and e-commerce concept connecting sales lines, promotion calendars, product costs, discounts, and returns for retail promotion profitability.
Promotion gross margin (%)
Discount as a share of sales (%)
Promoted item return rate (%)
Promotion sell through rate (%)
THE CHALLENGE
Promotion sales can grow while contribution remains unclear
Stock not visible
Closing stock is reported irregularly or not at all.
Static norms
Stock norms do not change with seasonal sales velocity.
Fast-mover gaps
High-velocity SKUs run out while slow SKUs pile up.
Ordering by habit
Primary orders follow last month's quantity rather than need.
THE SOLUTION
Retail Promotion Profitability Review Framework
Offer allocation
Collect daily or weekly closing stock from every distributor.
Velocity-based norms
Set norms from recent secondary sales velocity and lead time.
Gap identification
Compare stock with norm for every SKU and distributor.
Order suggestion
Show suggested primary quantities for sales team review.
THE APPROACH
Promotion Calendar Mapping
Standardise closing stock submissions and track missing reports.
Sales Velocity Calculation
Calculate rolling daily secondary sales by SKU and distributor.
Norm Recalculation
Recalculate days-of-cover norms with lead time and seasonality.
Below Norm Alerts
Link partial and delayed returns to the original promotional sale and restate the relevant offer cohort.
Availability Context Review
Compare promoted sell through with available stock so constrained inventory is visible beside sales performance.
Offer Margin Evaluation
Review low-margin promotions with commercial owners and use controlled tests before claiming incremental sales lift.
THE IMPACT
Offer clarity
Teams could compare promotions using consistent discount allocation.
Margin visibility
Commercial reviews could include cost rather than sales alone.
Return context
Late returns could remain linked to the original offer.
Stock awareness
Weak availability could be distinguished from weak customer response.
Controlled review
Authorized teams could review loss-making offers, overlapping discounts, and constrained promoted items, with source evidence retained beside the review case.
Measurable evaluation
A pilot could establish baseline values for promotion gross margin (%) and assess changes after approved actions. Incremental sales lift would require a controlled comparison; descriptive results would not establish causality.
Explore Distributor Inventory And Stock Norms
Work with RUSA Analytics to connect distributor closing stock, stock norms, secondary sales velocity, and pending primary orders and create a governed workflow to review distributors below stock norm on fast movers or holding excess slow stock. Start with a scoped concept or pilot and agreed success measures.
MORE WORK
Explore other case studies