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 erosion charge, 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: **Break-even uplift carries no seasonal term, so the peak scales the answer and never changes it.** A peak month makes a sound event bigger and an unsound event worse, in the same proportion. 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'. Combined incremental volume is well below the sum of each event's standalone forecast, and the shallower event's post-event report 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 by event timing, depth, and frequency, and watch the Calendar Health Score recompute live across spacing, overlap, break-even coverage and event count so you spot weeks-on-deal fatigue, cannibalization, 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: 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 execution sub‑scores (spacing, overlap count, the share of events clearing break‑even, and event count) and the money then caps the result

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 seasonal month all recompute as the bar settles. 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.
Run this event	Running / Stopped	All nine running	Takes the event off the plan entirely. The sharpest control on the calendar: stopping 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.
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. This is the control and the money is an output: a deeper cut hands back more on every unit sold, base units included, so the event costs more AND the uplift it must clear runs away from it. 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 earn more incremental volume on the same uplift, and they also fund the discount on every extra unit and push up the share of the year on deal. Which way that nets out depends on whether the losing events are still on the board.
Base uplift slider (per event)	1.1x to 3.5x in 0.1x steps	1.4x to 2.5x depending on event	The raw uplift the deal would deliver with the shelf to itself, before crowding takes its bite. The adjusted uplift in the diagnostic table is what actually drives incremental volume, 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, and Lesson 1 puts a well-designed event with display support at 55 to 70 percent incrementality against 35 to 45 for an untargeted shelf price cut. 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 lift 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 removes the selected event and reflows the calendar. Use both against the carrying capacity: every event needs its weeks on deal plus a quiet run after it, long enough for a shopper who stocked up on the deal to work through what they bought. That quiet run 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 read the two money lines against each other: the event‑level net, which is what a post‑promotion review would report, and the net calendar profit, which takes off the base business 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. The event-level net is POSITIVE and the year 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 the break‑even column against the delivered uplift, event by event. Four rows deliver less than they need. Switch each of those four to Stopped 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. Take the planning levers on this board one at a time and stopping the losers is far and away the largest of them, which is the ranking a student should carry out of the tool.
Move a losing event into December and watch it lose more
Reset to defaults. Take any event whose delivered uplift sits below its break‑even uplift and drag it into December, the highest month on the seasonal strip. 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 contains no seasonal term at all, so the peak month scales a losing event's losses exactly as it would have scaled 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 fortnight 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. Depth discipline only pays on events that were viable to begin with, which is why the stop decision 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 erosion line 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 category does to you anyway and no calendar decision removes it. This is the one number on the page that no event report can see, and on the starting calendar it is larger than the entire event-level 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 to bring into the next quarterly business review and JBP draft.
Expected outcome: You leave with a defensible calendar (REFINE or TUNE band, score above 75), a clear locked-versus-flexible split, and an artefact that answers the question a buyer will ask about every single 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 execution sub-scores (spacing, overlap, share of events clearing break-even, event count), then CAPPED by the money	Read the band, and know which half is holding it down. Above 80 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 sells the whole week and every other event in that week books nothing while its fee keeps running. Overlaps are also free to fix, which puts them above depth in the running order.
Event-level net against net calendar profit	event-level net = incremental gross profit minus trade spend, added up. Net calendar profit = event-level net minus the reference-price erosion charge	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 bar the season does move is the full-cost one, because the fixed fee spreads across a bigger base in a peak month.
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 a deeper overlapping cut owns drops out of that count, because the shelf sells it on the other event's deal. 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 recommendations panel sequences the fixes in order of leverage, and the order is worth learning on its own: stop the events that cannot clear break‑even, bring the share of the year on deal under the ceiling, fix overlaps because they are free, and only then tune depth and timing on what survives.

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 erosion charge, 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: **Break-even uplift carries no seasonal term, so the peak scales the answer and never changes it.** A peak month makes a sound event bigger and an unsound event worse, in the same proportion. 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'. Combined incremental volume is well below the sum of each event's standalone forecast, and the shallower event's post-event report 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: 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 Lesson 8: Promotion Calendar Optimization lesson

Or see what a team rollout includes