Forecasting

Forecasting · Halden & Rowe

Full-year sales holding to plan; margin under pressure, cash tight in Q3.

Demand is tracking within tolerance. Margin is the exposed number: promotion depth in womenswear and cost inflation in outdoor are compressing full-year gross margin below plan.

Health · Watch

Sales on plan; margin and Q3 cash are the exposed positions.

Metrics

Forecasting at a glance

The readings a retailer would look at first.

Demand forecast

1.02× plan

up 0.4 pts vs last week

Weather-adjusted; consumer confidence supportive.

Sales forecast

£152m

in line with plan

Ireland ahead, UK flat.

Margin forecast

40.6%

down 1.4 pts vs plan

Womenswear promotion depth is the largest single driver.

Cash forecast

£11.2m in Q3

£1.8m below plan

Working capital tied up in outdoor overhang; tightest week is 12 September.

Weather impact

Neutral

cooler week ahead

Supportive for autumn transition; unhelpful for garden clearance.

Calendar impact

Positive

Bank Holiday weekend

Loyalty double-points event lands 24–26 August.

Economic drivers

Softening

confidence down 2 pts

Consumer confidence easing in the mid-market band.

Consumer trends

Toward value

loyalty basket up 3.1%

Members trading down in womenswear; up in home.

Summary

Forecasting summary

Ana's editorial reading of the discipline this week.

Sales are on plan for the full year and demand is holding within tolerance. The tone of the forecast is not sales; it is margin and cash.

Womenswear promotion depth and outdoor cost inflation together account for the 1.4 point margin softness. Q3 cash is the sharper number: £1.8m below plan, with the tightest week landing on 12 September.

Visual evidence

How the forecast is developing

Five commercial readings, one confidence band.

Sales

Sales are tracking plan within tolerance

Weekly sales, actual against plan, £m.

£18.5m£19.0m£19.5m£20.0mW1W2W3W4W5W6ActualPlan

Source · Sales facts · Forecast v42

What this shows

Actual weekly sales against the current plan.

Why it matters

The gap is small and stable — no reason yet to reforecast top-line.

Demand

Underlying demand is firming into autumn

Weather-adjusted demand index, rebased to W1.

0.981.001.021.041.06W1W2W3W4W5W6W7W8Weather-adjusted demand index

Source · Retail Signals · Demand overlay

What this shows

Portfolio demand once weather effects are removed.

Why it matters

Demand is quietly improving. That is what supports the current margin position.

Margin bridge

Forecast margin lands 1.4pp behind plan

Movement from plan margin to forecast margin, percentage points.

0.0%10.0%20.0%30.0%40.0%42.0%Plan margin-1.6%Womenswear promo depth-0.5%Supplier cost pressure-0.4%Outdoor markdown reserve0.4%Menswear mix0.7%Footwear full-price strength40.6%Forecast margin

Source · Forecast v42

What this shows

Which decisions move margin between plan and forecast.

Why it matters

Womenswear promotional depth is the single largest drag. Everything else roughly offsets.

Inventory

Inventory unwinds through Q4

Projected month-end inventory value against target ceiling, £m.

£38m£40m£42m£44m£46m£48m£50mJulAugSepOctNovDecProjected inventory value (£m)Target ceiling

Source · Forecast v42 · Inventory projection

What this shows

Month-end inventory value against the target ceiling.

Why it matters

The forecast crosses the ceiling by October — organic unwind is achievable if promotional plans hold.

Cash

A short cash trough opens in mid-September

Projected cash position against operating floor, £m.

£9.0m£10.0m£11.0m£12.0m£13.0m£14.0m£15.0m£16.0m£17.0mJulAugSep 12Sep 30OctNovCash position (£m)Operating floor

Source · Cash posture · owned by Forecast

What this shows

Projected cash position over the next five months.

Why it matters

One dip approaches the operating floor for roughly a fortnight — worth flagging, not yet worth acting on.

Confidence

Sales confidence band widens into December

Expected sales, upper and lower commercial case, £m.

£20m£22m£24m£26m£28m£30m£32m£34m£36m£38mJulAugSepOctNovDecExpectedUpper / lower commercial case

Source · Forecast v42 · confidence envelope

What this shows

The forecast range, described commercially rather than statistically.

Why it matters

December carries the widest range — that is where scenario planning earns its keep.

Commercial impact

£1.8m of Q3 cash is exposed if the current forecast holds.

Tightening promotion depth in womenswear and releasing working capital from outdoor closes the gap without compromising the sales plan.

Executive actions

What to decide next

Ana's recommended next moves for this discipline.

Reduce womenswear promotion depth

Move the depth ceiling from 40% to 30% for the remainder of the season to protect gross margin.

Owner

Commercial Director

Horizon

this week

Bring forward outdoor markdown

Release working capital before Q3 to relieve the September cash trough.

Owner

Buying Director

Horizon

this week

Confirm Bank Holiday plan

Loyalty double-points event is the largest single lever on Q3 trading; confirm scope by Friday.

Owner

Marketing Director

Horizon

this week

Related

What lives behind Forecasting

The canonical business objects surfaced through this discipline.