SLS-298 · Lesson 11 of 12 · 27 min

The midseason review

▶ Video coming soon A video version of this lesson is on the way.

Halfway through a season is the last point at which a department can change its result. Stage 11 of the simulation is the midseason review: on Monday, May 17, 2027, Aiden presents the department's first three months to Bev Halvorsen, with Carl Jensen attending as the store's senior seller and a member of the planning group. The brief contains every result from stages 3 to 10, the May sales so far, and the July receipts that are still open to change. The deliverable is a midseason review pack: a scorecard against the season goals, an explanation of the main variances, a reforecast for May to July, and no more than three decisions, each with what it costs and what it will change.

The rule Bev gives every department lead is simple: a midseason review is not a report on what happened. It is a meeting to decide what happens next. A pack that explains February in detail and says nothing about June has failed, however accurate it is.

The scorecard

A scorecard puts each season goal next to its result to date, so that the reader can see in a minute where the department stands. Aiden's scorecard covers February 1 to April 30, the first half of the season by months and almost half by planned sales.

Midseason scorecard, upholstery, February 1 to April 30, 2027
GoalPlan to April 30Actual to April 30Status
Sales890,000 dollars911,000 dollarsAhead
Transactions500506Ahead
Average sale1,780 dollars1,800 dollarsAhead
Gross margin rate46.0 in 10045.2 in 100Behind
Gross margin409,400 dollars411,772 dollarsAhead
Markdowns71,200 dollars (8.0 in 100)79,800 dollars (8.8 in 100)Behind
Shrink0.8 in 1001.4 in 100Behind
Protection-plan attachment28 in 10026 in 100Behind
Plan cancellations within 30 days5 in 100 or less3.8 in 100On goal
Satisfaction, 4 or 5 out of 590 in 10088 in 100Behind
A line chart of cumulative upholstery sales from February to July 2027. The plan line rises to 1,850,000 dollars. The actual line runs slightly above plan to 911,000 dollars at the end of April. A dashed forecast line continues from May to July and ends at about 1,860,000 dollars.
Cumulative sales against plan, with Aiden's midseason forecast.

The scorecard shows a familiar midseason pattern: the headline is good and the detail is mixed. Sales and gross margin dollars are ahead of plan, but the margin rate, markdowns, shrink, attachment and satisfaction are all behind. A lead who reported only the first line would be telling the truth and hiding the problem.

Explaining the sales variance

Sales were 21,000 dollars ahead of plan. Before deciding whether that will continue, Aiden split the variance into its two drivers: more transactions and a higher average sale.

Worked problem

Splitting the sales variance

The plan was 500 transactions at 1,780 dollars. The actual was 506 transactions at about 1,800.40 dollars. How much of the 21,000-dollar variance came from each driver?

Show solution
  1. Transaction effect, at the planned average sale:
  2. \[(506 - 500) \times 1{,}780 = 10{,}680 \text{ dollars}\]
  3. Average-sale effect, on the actual transactions:
  4. \[(1{,}800.40 - 1{,}780) \times 506 \approx 10{,}320 \text{ dollars}\]
  5. Check:
  6. \[10{,}680 + 10{,}320 = 21{,}000 \text{ dollars}\]

Answer: The variance came about equally from the two drivers. The extra transactions came mostly from the April promotion weekend. The higher average sale came from custom sectionals, Leon's coaching plan from stage 7 and the promotion's free-delivery threshold of 1,500 dollars. Both causes were partly one-off: the promotion will not repeat, so Aiden did not assume the full variance would continue.

A bridge chart from planned sales of 890,000 dollars to actual sales of 911,000 dollars, with two rising steps: transactions plus 10,680 and average sale plus 10,320.
The sales variance split into its two drivers.

Explaining the margin variance

Gross margin dollars were 2,372 dollars ahead, but the rate was 0.8 points behind. Both statements are true, and the review has to show why.

Worked problem

Splitting the margin variance

Planned gross margin was 409,400 dollars, 46 in 100 of 890,000. The actual was 411,772 dollars, 45.2 in 100 of 911,000. Split the variance into a volume effect and a rate effect.

Show solution
  1. Volume effect, the extra sales at the planned rate:
  2. \[21{,}000 \times 0.46 = 9{,}660 \text{ dollars}\]
  3. Rate effect, the lower rate on actual sales:
  4. \[(0.452 - 0.46) \times 911{,}000 \approx -7{,}288 \text{ dollars}\]
  5. Total:
  6. \[9{,}660 - 7{,}288 = 2{,}372 \text{ dollars}\]

Answer: The extra sales earned 9,660 dollars of margin, but the lower rate gave up 7,288 of it. Markdowns explain most of the rate gap: they ran 8,600 dollars above the plan for the period, including the promotion weekend's delivery cost, the terracotta discount and early clearance of damaged pieces. The unrecorded damage found in stage 9 had also been sold at reduced prices.

Checking the tests set earlier

Several earlier stages set tests to be checked at midseason. A review that skips them teaches the team that tests do not matter.

Tests from earlier stages
Test (stage)Rule setResult to April 30Decision
999 sofa line (5)Pays for itself if at least 18 of 120 are new sales58 sold; sellers recorded 14 buyers who had been shopping a competitor's price, on pace for about 29Keep; reorder in June
Feature display (6)Feature beats control by a clear margin118 groups and 3 sales against 46 and 1Keep feature layout
Terracotta test colour (5, 8)Reorder if 4 of 6 sell by mid-April3 by April 16; 5 of 6 after the discountDo not reorder at full depth; offer as a special-order colour
Promotion (8)Net margin positiveNet plus 4,082 dollarsRepeat only with a smaller markdown element

The terracotta decision shows the discipline the review needs. The colour reached five of six, which sounds like success, but it needed a discount to get there. Aiden judged it by the rule he had set before the season, not by the final count, and kept it as a special-order colour where it costs no stock.

The reforecast

A reforecast is a new estimate of the season's result, made with what the department now knows. It does not replace the plan; the plan stays as the measure the department is judged against. The reforecast tells the store what to expect.

May sales to May 16 were running about 2 in 100 below plan, and Tessa reported that web traffic to upholstery pages was down a little from April. Without a promotion, Aiden expected May to July to come in slightly below plan.

Worked problem

The season reforecast

The plan for May to July is 960,000 dollars. Aiden forecasts 950,000. What is the forecast for the season, and how does it compare with the plan of 1,850,000?

Show solution
  1. Season forecast:
  2. \[911{,}000 + 950{,}000 = 1{,}861{,}000 \text{ dollars}\]
  3. Against plan:
  4. \[1{,}861{,}000 - 1{,}850{,}000 = 11{,}000 \text{ dollars}\]
  5. As a share of plan:
  6. \[\frac{11{,}000}{1{,}850{,}000} \approx 0.006\]

Answer: The forecast is 1,861,000 dollars, 11,000 above plan, or about 0.6 in 100. Aiden presented it as a range of 1,840,000 to 1,880,000, because a 2 in 100 swing in June or July would move it by about 20,000.

Worked problem

What margin rate does the rest of the season need?

The season goal is 851,000 dollars of gross margin. Margin to April 30 was 411,772. If May to July sales are 950,000, what gross margin rate is needed from May to July to reach the goal?

Show solution
  1. Margin still needed:
  2. \[851{,}000 - 411{,}772 = 439{,}228 \text{ dollars}\]
  3. Rate needed:
  4. \[\frac{439{,}228}{950{,}000} \approx 0.462\]

Answer: The department needs about 46.2 in 100 for the rest of the season, slightly above the plan rate, to make up for the first half. That sets the limit on markdowns for May to July.

Worked problem

The markdown budget left

The season markdown budget is 148,000 dollars and 79,800 has been used. What is left, and what rate of the forecast May to July sales does that allow?

Show solution
  1. Budget left:
  2. \[148{,}000 - 79{,}800 = 68{,}200 \text{ dollars}\]
  3. Rate on forecast sales:
  4. \[\frac{68{,}200}{950{,}000} \approx 0.072\]

Answer: About 7.2 in 100 for May to July, against 8.0 in the plan. The May floor-model clearance from stage 9 takes 4,100 of it, and the July end-of-season clearance must be planned inside what remains.

Adjusting July receipts

Because the reforecast lowers May to July sales by 10,000 dollars, Aiden lowered July receipts. With a cost complement of 54 in 100, 10,000 dollars of retail is about 5,400 dollars at cost. He cancelled four accent chairs from a July order that had not yet been confirmed by the supplier, worth about 5,300 at cost, and kept the reserve from stage 5 for the grey sectional reorder in stage 9. Cancelling stock that has not shipped is far cheaper than marking it down in August.

The attachment decision

The hardest decision in the review was about protection-plan attachment. To reach 28 in 100 for the whole season, the department would need to sell about 158 plans on the roughly 528 transactions expected from May to July.

Worked problem

What would catching up require?

There have been 132 plans on 506 transactions. If May to July brings about 528 transactions, what attachment rate would those months need for the season to reach 28 in 100?

Show solution
  1. Plans needed for the season:
  2. \[0.28 \times (506 + 528) \approx 290\]
  3. Plans still needed:
  4. \[290 - 132 = 158\]
  5. Rate needed from May to July:
  6. \[\frac{158}{528} \approx 0.30\]

Answer: The department would need 30 in 100 for the rest of the season. April had already reached about 32 in 100 after the coaching in stage 7, so it is possible. But stage 3 set a cancellation limit for a reason: pressure to catch up is how sellers start pushing plans that customers cancel.

Aiden recommended keeping the monthly target at 28 in 100 and not setting a catch-up target. He would rather miss the season goal by a point than see cancellations rise and customers feel pushed. Bev agreed, and asked him to report cancellations with attachment in every weekly huddle.

Three decisions

Midseason decisions
DecisionCostWhat it should changeOwner
Apply the delivery reconfirmation standard and lead-time script from stage 10 to all special orders from May 17About 6 hours a week of seller and office timeTiming complaints down to 4 a month or fewer; satisfaction to 90 in 100Aiden, with Carl coaching
Hold markdowns to 68,200 dollars for the rest of the season; July clearance planned within itNo direct costMargin rate of at least 46.2 in 100 for May to JulyAiden
Keep shrink actions from stage 9; weekly damage review and cycle countAbout 2 hours a weekShrink at or below 0.8 in 100 for May to JulyAiden, with Marcus

Template: the midseason review pack

Midseason review pack template
SectionWhat to include
ScorecardEvery season goal, plan and actual to date, status
VariancesThe two or three largest, split into their drivers
TestsEach test set earlier, its rule and the decision
ReforecastSeason forecast as a number and a range; margin and markdown limits for the rest of the season
DecisionsNo more than three, each with cost, expected change and owner
RisksWhat could move the forecast, and what the department will watch

Model answer and Bev's scoring

Bev scored the pack 19 out of 20, the highest score of the season. She gave full marks for the scorecard, which showed every goal including the ones behind, for the variance analysis, and for the decisions. She took one point from the reforecast because the risk section named the June trade-area road construction that Tessa had flagged but did not say what the department would do if traffic fell more than expected. Carl added a note of his own: the attachment decision was the one he would remember, because it put the customer ahead of a number on the scorecard.

Rubric for the midseason review pack, with Aiden's scores (total 19)
CriterionExcellent (4)Developing (2)Aiden
ScorecardEvery goal shown honestly with statusOnly favourable results shown4
Variance analysisVariances split into drivers, causes explainedTotals only4
TestsEach test judged by its ruleTests ignored or judged afterwards4
ReforecastNumber, range and limits for the rest of the seasonPlan repeated3
DecisionsThree or fewer, costed and ownedA long list of intentions4

Reflection

Why is it tempting to lead a midseason review with the best number? Would you have set a catch-up target for attachment? What would you need to believe for that to be the right call?

Common mistakes

  • MistakeReporting only the results that are ahead of plan.

    InsteadShow every goal, with its status.

  • MistakeExplaining a variance as a single number.

    InsteadSplit it into its drivers, such as transactions and average sale, or volume and rate.

  • MistakeReplacing the plan with the reforecast.

    InsteadKeep the plan as the measure and use the reforecast to guide decisions.

  • MistakeJudging a test by its final count after the fact.

    InsteadJudge it by the rule set before the season.

  • MistakeSetting catch-up targets that invite pressure selling.

    InsteadKeep targets that protect the customer, and report the guardrail alongside.

Summary and key terms

  • A midseason review decides what happens next; it is not only a report on what happened.
  • The scorecard shows every goal honestly: sales and margin dollars were ahead, but margin rate, markdowns, shrink, attachment and satisfaction were behind.
  • Sales variance split into transactions (10,680 dollars) and average sale (10,320); margin variance into volume (9,660) and rate (minus 7,288).
  • The reforecast was 1,861,000 dollars, with a range, and set limits for the rest of the season: a margin rate of about 46.2 in 100 and 68,200 dollars of markdowns.
  • Three costed decisions with owners are better than a long list.
Scorecard
A table showing each goal, its result to date and its status.
Variance
The difference between an actual result and the plan.
Volume effect
The part of a margin variance caused by selling more or less.
Rate effect
The part of a margin variance caused by a higher or lower margin rate.
Reforecast
An updated estimate of the season's result, made during the season.
Cost complement
One minus the markup on retail; the share of a retail price that is cost.

Practice problems

Work each problem on paper first, then reveal the answer to check.

  1. Plan: 400 transactions at 1,500 dollars. Actual: 420 at 1,480. Split the variance.

    Show answer

    Transaction effect 20 × 1,500 = 30,000; average-sale effect (1,480 − 1,500) × 420 = −8,400; total 21,600.

  2. Margin to date is 300,000 dollars, the season goal is 640,000, and the rest of the season is forecast at 720,000 dollars of sales. What rate is needed?

    Show answer

    340,000 ÷ 720,000 ≈ 0.472, about 47.2 in 100.

  3. Why might a lead decline to set a catch-up attachment target?

    Show answer

    Because pressure to catch up tends to raise cancellations and harm customer trust.

Lesson quiz · 5 questions

Score 60% or more to complete this lesson.

Take the quiz