Screwfix Space & Category Review

Auto-Calculating Dynamic Index

Slide 25 Dynamic Engine • All 15 Stores Fully Loaded • Benchmark £2,974.75/wk

Screwfix POC • Store Performance Deep Dive • 7-day Weekly Average
Space & Category Review

Bristol-Bedminster (BT1) – 24 / 24 core plans

Full-Format Trade Counter • 1,291.7 sq ft Trade Space

#1 Trial Store Performer
Top plan: EBS3 £2,348.98/wk
Weekly Sales

£6,208

£24.8k 4-Wk Total
Weekly Units

1,085

4,340 4-Wk Units
Space Allocation

48.45m

Total Linear Metres
Return / Metre Auto

£128.14

+55.4% vs Trial Avg
Avg Stock Cover

2.1d

Fast Turn (<3 Days)
Core Plans

24/24

100% Plan Compliance
Store Index Formula

208.7

+108.7% vs Benchmark

Category Space % vs Sales % — Bristol-Bedminster

Space % Sales %

Compares physical front-of-house shelf allocation with weekly revenue contribution.

Benchmarked across 6 core merchandise families Sealants & Adhesives leads category sales
Top Five Performers Based on Sales Ranked by weekly revenue
Product DOS Units Sales (£)
Bottom Five Performers Based on Sales Candidates for facing reduction
Product DOS Units Sales (£)
Commercial Audit Observation:

Soudal Fix All High Tack Adhesive had unusually high sales in Bedminster (£1,789/wk, making up 83% of all sales across the 15 trial stores). This indicates a large local contractor buying in bulk.

25. All figures represent 7-day weekly averages converted from Space Planning 4-week movement data.
Movement tables filter out £0.00 sales and customer returns to isolate active, positive-trading SKUs.
Fast Update Studio

Update Monthly Actuals & Excel Import

Calculates Index and Return/Metre live as you type or paste.

Month Data Status: Audited Actuals

1. Key Performance Numbers

2. Category Space % vs Sales %

Category Space % Sales %

3. Top Five Lines

4. Bottom Five Lines

5. Commercial Observation Note

Auto-calculating index