Why is "Treating more events as more volume" a common mistake when using the Promo Calendar Optimizer?

Symptom: Annual event count drifts from 8 to 12 to 14 across two planning cycles. Per-event ROI declines every year. Total incremental volume plateaus or falls. Fix: **Work out the carrying capacity before you pick a single mechanic.** Every event needs its weeks on deal plus about a 4-week gap after it, so eight two-week events fill 48 of the year's 52 weeks and fit, and nine need 54 and do not. The ninth event is condemned before anyone chooses its depth.

Why is "Deepening events instead of fixing timing" a common mistake when using the Promo Calendar Optimizer?

Symptom: The discount on a poor event grows year over year while ROI stays flat or negative. The post-event review keeps citing 'mechanic execution' as the cause. Fix: **Move the event before you deepen it, and check break-even before you do either.** Depth does not fix wrong timing or a tight gap, and it makes the target harder: a deeper cut raises the uplift the event must clear at the same time as it raises what the event costs. Drag the bar to open the gap, then re-test.

Why is "Judging the calendar one event at a time" a common mistake when using the Promo Calendar Optimizer?

Symptom: Every post-promotion review comes back green. The trade budget is spent, the events all reported positive returns, and nobody has looked at what the brand sells in a full-price week compared with last year. Fix: **Read the Base Erosion tile, because no event report contains it.** It is levied on the whole year's base volume and driven by one thing you control, the share of the year running on deal above 30%. A plan where every event passes and the year still loses is the normal case, not the exotic one, and it is invisible to anyone reviewing events.

Why is "Moving a weak event into a peak month to rescue it" a common mistake when using the Promo Calendar Optimizer?

Symptom: A December slot is treated as a fix for an event that underperformed in a trough month. The plan concentrates spend into the peaks on the theory that demand does the rest. Fix: **The season appears nowhere in break-even uplift, so a peak month changes how big the result is and never whether the event covers its discount.** A peak month makes a sound event bigger and an unsound event worse. Test whether the event clears its break-even first; only then does the question of which month it belongs in become worth asking.

Why is "Letting overlapping events stay on the calendar" a common mistake when using the Promo Calendar Optimizer?

Symptom: Two events scheduled in the same window 'because the retailer wanted both'. Together the two events add far fewer extra units than their separate forecasts added up to, and the post-event report for the event with the smaller discount shows its fee against almost no volume. Fix: **Move one of the overlapping events to a clean window with at least 4 weeks of separation, or take it off the plan.** The shelf carries one price, so the shallower event is paying for weeks the deeper one is selling. Overlaps cost nothing to fix, which puts them near the top of the running order. Negotiate alternating brands or pack sizes if the retailer insists on the slot.

Why is "Reading the Health Score without reading the per-event table" a common mistake when using the Promo Calendar Optimizer?

Symptom: Calendar Health Score lands above 75 but two or three individual events still show negative ROI. The composite hides the loss. Fix: **The Health Score is necessary, not sufficient.** Always cross-check the per-event diagnostic table; cut or restructure every event whose ROI does not clear the +11.1% operating-profit hurdle before locking the calendar into the JBP. The composite can be defensible while individual rows are still bleeding profit.

Free tool · no login required

Promo Calendar Optimizer

Build a 52-week promotional calendar for an FMCG biscuits brand, choosing when each event runs, how deep it cuts and how many events you run. As you work, the Calendar Health Score grades spacing, overlap, break-even coverage and event count. It shows you too many weeks on deal, events crowding each other, and events that cannot cover their own discount, before any of them lock into the next Joint Business Plan with a strategic retailer.

Updated 6 May 2026Extracted from the Trade Promotion Optimization module, lesson 8: Promotion Calendar Optimization

Loading calculator...

Guided walkthrough

Explore the tool, from setup to common mistakes

Five short sections explain the scenario, what each control does, how to read the output, and the mistakes to avoid. Open whichever helps. The tool above works without them.

5.1Scenario setup

The starting SKU, market, and assumptions the model makes.

You are the Trade Marketing Director or Key Account Director on a biscuits brand at a top‑3 retailer. The 52‑week promotional calendar starts the year with nine events, $2.26M of trade investment, an average two‑week duration, and no gap at all between the tightest pair. Four of the nine cannot cover their own discount. The plan earns money event by event and loses money over the year. Most calendars in real RGM rooms look like this draft on day one, before anyone has tested whether the spacing, depth, and rhythm hold up.

Your objective

Your goal is to turn the year positive and get the Calendar Health Score above 75, working the four controls you actually have: which events run at all, how deep each one cuts, how long it runs, and where it sits. What the calendar costs is an output of those choices, never an input you set.

Key assumptions

SKU calibration: biscuits, 100,000‑unit weekly baseline volume, $1.20 average margin per unit, $3.00 shelf price, $30,000 fixed cost per event
Optimal inter‑event gap: 4 weeks (consumption cycle plus post‑promo recovery)
Seasonal index scales the BASELINE, not the uplift, and runs from 78 in January to 142 in December
Crowding penalty decays geometrically from a 25% cap as the gap widens, and it bites the uplift ABOVE base rather than the base itself
Reference‑price erosion charges 1.2% of the year's base volume whatever you do, plus 0.5 of a point for every point of the year on deal past 30%
Calendar Health Score averages four checks on how the calendar is built (spacing, overlap count, the share of events clearing break‑even, and event count), and the year's return then caps it

5.2Controls & toggles

Every input the calculator exposes, its range, and what it changes.

Control	Range	Default	What it changes
Drag event bar	Anywhere across weeks 1 to 52	Default 9-event calendar	Moves the entire event window. Snaps to weeks. Spacing, overlap and the season the event runs in all update when you let go of the bar. The cheapest gesture on the board, because moving an event costs nothing, though on the seeded year it is worth a fraction of deciding which events run at all.
Discount depth (per event)	5% to 35% off, in 1-point steps	12% to 22% depending on event	Sets how many points come off the shelf price. You set the depth, and what the event costs follows from it. A deeper cut hands back more on every unit sold, including the ones the shop would have sold anyway, so the event costs more AND the uplift it must reach to break even goes up. Past 35% the give‑away would be eating most of the $1.20 margin.
Duration slider (per event)	1 to 4 weeks	2 weeks	Stretches or shrinks the event window. Longer events sell more extra units above baseline at the same uplift multiple, and they also fund the discount on every extra unit and push up the share of the year on deal. Whether a longer run helps or hurts the year depends on whether the events that lose money are still on the calendar.
Base uplift slider (per event)	1.1x to 3.5x in 0.1x steps	1.4x to 2.5x depending on event	The uplift the deal would deliver with the shelf to itself, before the crowding penalty cuts it down. The adjusted uplift in the diagnostic table is what actually drives the extra units above baseline, and it is the figure to compare against break‑even. This is where display and feature support live, along with the occasion itself, which is why it moves when the discount does not. Earlier TPO lessons put real weight on it: Lesson 4 ranks adding display or feature support second of the five ways to fix a failing event and puts cutting depth last. Lesson 1 puts a well‑designed event with display support at 55 to 70 percent net share of uplift against 35 to 45 for an untargeted shelf price cut (net share of uplift = net incremental volume / uplift: of the extra units above normal sales, the share that was genuinely new). So this is the one control here that can carry an event over a break‑even bar that no start month, length or depth will reach. Two things before you use it that way. The extra uplift has to be bought, with display and feature money this model does not charge you for, and it has to be evidenced by what the event delivered last time rather than assumed into next year's plan.
Add event / Delete event	5 to 13 events typical	9 events	Add inserts a new event in the next open gap at 15% depth and 2 weeks. Delete takes the selected event off the plan and leaves the others where they are. It is the sharpest control on the calendar: deleting an event that cannot clear its break‑even uplift removes its fee, its give‑away and its weeks on deal in one move, and nothing else available comes close. Use both against the calendar's carrying capacity: every event needs its weeks on deal plus a quiet period after it, long enough for a shopper who stocked up on the deal to use up what they bought. That quiet period is the gap, and on biscuits it lasts about 4 weeks. So a two‑week event costs the year six weeks, eight of them fit inside 52 weeks and nine do not.
Seasonal anchor flag	On / off per event	On for Easter, Valentine's, Back-to-School, Halloween, Holiday Season	It holds the event inside its own month. The uplift belongs to the occasion rather than to the calendar slot, and there is no Halloween in December, so dragging one there would book a pull that is not there. Use it to label which events you treat as locked‑anchor in the joint business plan (JBP) versus quarterly‑flexible.

5.3Step-by-step exploration

7-step guided exploration of the scenario.

Read the starting position, and read both nets
Open the tool and let it run on defaults. Note the Calendar Health Score, the Min Gap, the Overlap count and the weeks‑on‑deal percentage. Then compare the two money lines: Event Net, which is what a post‑promotion review would report, and Year Net, which also takes off Base Erosion, the full‑price sales the plan gave away to earn it. Do not make any changes yet.
Expected outcome: The score reads 39 REBUILD. Min Gap is 0. Weeks on deal runs 38.5%, well past the 30% ceiling. Event Net is POSITIVE and Year Net is NEGATIVE, and that disagreement in sign is the whole lesson: every event on this plan can pass its own review while the calendar loses money.
Stop the events that cannot cover their own discount
Read Needs against Gets in the diagnostic table, event by event. Four rows deliver less than they need. Delete each of those four and leave everything else exactly as it is.
Expected outcome: The year turns from a loss to a profit on far less money, and the score climbs from 39 REBUILD to 75 TUNE. Nothing was funded better and nothing was re‑timed. Try the planning levers on this board one at a time and stopping the losing events is by far the biggest of them. That ranking is the one to take away from the tool.
Move a losing event into December and watch it lose more
Reset to defaults. Take New Year Push, Spring Promo or Summer Deal, each of which gets less uplift than it needs, and drag it into December, the highest month on the seasonal index. (Valentine's falls short too, but it is a seasonal anchor and stays in February.) Read its Net before and after.
Expected outcome: It loses MORE, not less. Break‑even uplift is margin divided by (margin minus give‑away), and the season appears nowhere in it. So the peak month multiplies what a losing event loses on its discount, just as it would have multiplied a winner's gains. The season decides how much an event makes or loses against its own discount, and never whether it covers it.
Close the gap between two events and read the crowding penalty
Reset to defaults, then drag one event so it starts two weeks after its neighbour ends. Check the crowding column on the diagnostic table for the second event of the pair, then push it out to six weeks and read it again.
Expected outcome: The penalty runs about 25% with no gap at all and has decayed to a couple of points by four weeks, so most of what you lose comes back in the first two weeks you give it. It bites the uplift above base and never the base, because a full cupboard stops a shopper buying the extra packs the deal was meant to move and does not stop the shop selling what it was always going to sell.
Cut six points of depth off everything, and watch it get worse
Reset to defaults. Take six points off the discount depth of all nine events and keep every one of them running. This is the move most teams reach for first when a calendar is losing money.
Expected outcome: The year ends up WORSE than doing nothing. A shallower cut on an event that was never going to clear its break‑even just buys less volume for the same fixed fee. Cutting depth only pays on events that could cover their discount in the first place, which is why deciding which events to stop comes first.
Bring weeks on deal under the ceiling
Reset to defaults, where the year runs 38.5% of its weeks on deal. Shorten event durations until that share drops under 30%, and watch the Base Erosion tile rather than the event rows.
Expected outcome: Every point you take off the share of the year on deal above 30% takes 0.5 of a point off the erosion charge, and that charge is levied on the whole year's base volume rather than on the promoted weeks. Once you are under the ceiling the line stops moving, because what is left is the 1.2% drift the model books against any year that runs promotions at all. This is the one number on the page that no event report can see, and on the starting calendar it is larger than the whole of Event Net.
Lock the calendar for the JBP
Mark every locked‑anchor event with the seasonal‑anchor flag. Note the events you would hold flexible for quarterly review. Snapshot the Calendar Health Score, the per‑event diagnostic table and both money lines, Event Net and Year Net, to bring into the next quarterly business review and JBP draft.
Expected outcome: You leave with a calendar you can defend (REFINE or TUNE band, score above 75) and a clear split between locked and flexible events. You also leave with a record that answers the question a buyer will ask about every row: what did this event have to deliver, and did it?

5.4Reading the output

Every KPI, the formula behind it, and how to interpret a positive or negative value.

KPI	Formula	How to read it
Calendar Health Score	the average of four checks on how the calendar is built (spacing, overlap, share of events clearing break‑even, event count), then CAPPED by the year's return	Read the band, and know which half is holding it down. 80 and above is REFINE and ready for the quarterly business review; 60 to 80 is TUNE; 40 to 60 is RESTRUCTURE; below 40 is REBUILD. The cap is the part people miss: a year that loses money cannot show above 39 however well it is built, and one earning a positive return below the +11.1% hurdle cannot show above 74. So a beautifully spaced calendar can print 39, and when it does, the answer is never better spacing.
Min Gap (weeks)	the smallest gap on the board: for each neighbouring pair, the empty weeks between the end of one event and the start of the next	4 weeks is the floor for biscuits. Below that the second event picks up a crowding penalty on the uplift it was counting on; at zero the two events behave as one long sale. Most of the damage is in the first two weeks you fail to give it.
Overlap count	how many pairs of events share at least one week	Zero is the only defensible number. A shared week carries one shelf price, so the deepest cut running in it takes every sale that week, and every other event in that week sells nothing while you still pay its fee. Overlaps are also free to fix, which puts them above depth in the running order.
Event Net against Year Net	Event Net = incremental gross profit minus trade spend, added up. Year Net = Event Net minus Base Erosion, the charge for the reference price the plan wears down	When those two disagree in sign, the plan is earning money event by event and losing it over the year. The first is what every post‑promotion evaluation in the industry lands on. The second takes off the base business the plan gave away to earn it, and that cost belongs to no single event, so no event review ever has to answer for it. On the starting calendar the first is positive and the second is negative.
Weeks-on-deal %	weeks with any event running, counted once each, divided by 52	30% is the ceiling, and count the weeks rather than adding up durations. Two events overlapping in one week is still one week the shopper met a deal price. Past the ceiling the promoted price starts becoming the price the shopper believes, full‑price weeks sell less than they used to, and getting back is slower than getting here.
Break-even uplift	margin per unit divided by (margin per unit minus the give‑away per unit), so $1.20 / ($1.20 - depth x $3.00). At a 20% cut on a $3.00 pack you hand back $0.60 a unit and need 2.00x before the DISCOUNT pays for itself. Clearing that bar is not the same as making money: the $30,000 fee for running the event at all sits on top of it.	The single most useful number on a promotional plan, and it carries no seasonal term at all. The uplift a deal has to clear against its own discount is the same in January as in December, which is why moving a losing event into a peak month makes it lose more rather than less. Compute it first, and then let the season decide how much rather than whether the discount is covered. The one break‑even the season does move is the one that includes the fixed fee, because a peak month spreads that fee across more base sales.
Per-event ROI	((uplift - 1) x 100,000‑unit baseline x seasonal index x weeks the event actually sells x $1.20 margin - cost) / cost. A week shared with a deeper overlapping deal drops out of that count, because the shelf sells that week at the other event's price. The cost is the $30,000 fixed fee plus the give‑away on EVERY unit sold while the deal runs, the incremental ones and the base the shop would have sold anyway. Volume answers depth on the same constant‑elasticity curve the pricing lessons use, at a brand‑level elasticity of -2.6, and caps at 3x because an event runs out of shoppers before it runs out of discount.	Every event ROI must beat the +11.1% operating‑profit hurdle of a 1% price move. Anything below loses to a portfolio‑wide price hold and should be cut or restructured before the next JBP draft.

The Calendar Health Score is the headline; the per‑event diagnostic table is the audit trail that backs it up, and the two money lines are what settle an argument. Bring all three to the quarterly business review. The What to fix next panel lists the fixes in order of importance, and that order is worth learning in its own right. Stop the events that cannot clear break‑even, bring the share of the year on deal under the ceiling, fix overlaps because they cost nothing, and only then tune depth and timing on the events that remain.

5.55 common mistakes to avoid

Diagnostic patterns that catch the most common misuse of this calculator.

Mistake 1Treating more events as more volume
Symptom: Annual event count drifts from 8 to 12 to 14 across two planning cycles. Per‑event ROI declines every year. Total incremental volume plateaus or falls.
Fix: Work out the carrying capacity before you pick a single mechanic. Every event needs its weeks on deal plus about a 4‑week gap after it, so eight two‑week events fill 48 of the year's 52 weeks and fit, and nine need 54 and do not. The ninth event is condemned before anyone chooses its depth.
Mistake 2Deepening events instead of fixing timing
Symptom: The discount on a poor event grows year over year while ROI stays flat or negative. The post‑event review keeps citing 'mechanic execution' as the cause.
Fix: Move the event before you deepen it, and check break‑even before you do either. Depth does not fix wrong timing or a tight gap, and it makes the target harder: a deeper cut raises the uplift the event must clear at the same time as it raises what the event costs. Drag the bar to open the gap, then re‑test.
Mistake 3Judging the calendar one event at a time
Symptom: Every post‑promotion review comes back green. The trade budget is spent, the events all reported positive returns, and nobody has looked at what the brand sells in a full‑price week compared with last year.
Fix: Read the Base Erosion tile, because no event report contains it. It is levied on the whole year's base volume and driven by one thing you control, the share of the year running on deal above 30%. A plan where every event passes and the year still loses is the normal case, not the exotic one, and it is invisible to anyone reviewing events.
Mistake 4Moving a weak event into a peak month to rescue it
Symptom: A December slot is treated as a fix for an event that underperformed in a trough month. The plan concentrates spend into the peaks on the theory that demand does the rest.
Fix: The season appears nowhere in break‑even uplift, so a peak month changes how big the result is and never whether the event covers its discount. A peak month makes a sound event bigger and an unsound event worse. Test whether the event clears its break‑even first; only then does the question of which month it belongs in become worth asking.
Mistake 5Letting overlapping events stay on the calendar
Symptom: Two events scheduled in the same window 'because the retailer wanted both'. Together the two events add far fewer extra units than their separate forecasts added up to, and the post‑event report for the event with the smaller discount shows its fee against almost no volume.
Fix: Move one of the overlapping events to a clean window with at least 4 weeks of separation, or take it off the plan. The shelf carries one price, so the shallower event is paying for weeks the deeper one is selling. Overlaps cost nothing to fix, which puts them near the top of the running order. Negotiate alternating brands or pack sizes if the retailer insists on the slot.
Mistake 6Reading the Health Score without reading the per‑event table
Symptom: Calendar Health Score lands above 75 but two or three individual events still show negative ROI. The composite hides the loss.
Fix: The Health Score is necessary, not sufficient. Always cross‑check the per‑event diagnostic table; cut or restructure every event whose ROI does not clear the +11.1% operating‑profit hurdle before locking the calendar into the JBP. The composite can be defensible while individual rows are still bleeding profit.

Related concepts

Go deeper on the theory

Continue with the lessons

Go further inside Trade Promotion Optimization

This calculator is the sandbox slice of Lesson 8: Promotion Calendar Optimization. Each of the other 7 Trade Promotion Optimization lessons teaches a complementary concept that sharpens how you read the output above.

See Promo Calendar Optimizer inside the full lesson

RGM Academy lets you pull every commercial lever yourself inside a senior-practitioner simulator, with the AI RGM Strategist coaching every decision you make.

Unlock the full Promotion Calendar Optimization lesson

Or see what a team rollout includes