Chapter 2
Why did it happen? Diagnostic analysis
Year-over-year performance
2023 revenue
$917K
821 transactions
2024 revenue
$885K
799 transactions · −3.6%
2025 YTD
$405K
380 txn · Jan–Jun only
2025 avg ticket
$1,066
Lowest of 3 years
Revenue declined 3.6% from 2023 to 2024, and the average transaction value dropped further in 2025 ($1,066 vs $1,118 in 2023). Both volume and basket size are under pressure simultaneously — a compounding signal.
Store performance gap
S2 ($195K) and S5 ($203K) significantly underperform compared to S8 ($245K) — a 26% revenue gap. S2 also has the lowest average ticket at $1,006 vs the network mean of $1,104.
Key outliers — 12 high-value anomaly transactions
12 transactions exceed $3,855 — more than 3 standard deviations above the mean. These are not uniformly distributed: S10 accounts for 3 outliers (Printer × 2, Tablet × 1), S3 accounts for 3 (Desk, Phone, Laptop), and Chair is the most frequent outlier product (5 of 12). This could indicate bulk orders, pricing errors, or a premium client segment that is untracked.
Product concentration risk
Monitor and Phone together contribute 30.5% of total revenue ($674K). If either category faces supply disruption or demand softening, the portfolio is materially exposed. Laptop — the lowest revenue product — represents only 12.9% of sales despite being in the lineup.
Manager performance
Liam manages the lowest total revenue ($471K) and lowest avg ticket ($1,064). The gap between Mia/Noah and Olivia/Liam may reflect store location mix, team training differences, or product-mix emphasis. This warrants a qualitative review before conclusions are drawn.
August 2024 — anomalous revenue dip
August 2024 recorded only $39,286 in revenue across 56 transactions — the lowest month in the entire dataset. For context, November 2024 reached $94,960. This 58% variance within the same year suggests a specific operational event (e.g., inventory issue, staffing, seasonal closure) rather than a systemic trend. It should be investigated as a root-cause priority.
Chapter 3
What next? Predictive & prescriptive outlook
2025 full-year forecast (annualized from H1 pace)
2025 H1 actual
$405K
Jan–Jun 2025
Projected FY 2025
~$810K
If H2 matches H1 pace
vs 2024 full year
−8.4%
Continued decline
Risk level
Medium
Declining avg ticket
Trend signals to watch
Average ticket trend↓ Declining · $1,118 → $1,107 → $1,066
Transaction volume↓ Declining · 821 → 799 → ~760 est.
Evening & Tue/Thu peaks↑ Consistent · high-value segment stable
Monitor/Phone category demand↑ Resilient · top revenue contributors
S2 & S5 underperformance→ Persistent · no signs of recovery
Unit price inconsistency→ Unresolved · min $5 to max $400 per product
Recommendations
01 · Priority — High
Investigate and rescue S2 and S5
These two stores underperform on both volume and basket size. Conduct on-site operational audits, review local competitive context, and assess whether the product mix matches local demand. Consider rotating top-performing cashiers or applying Mia/Noah's management practices to these locations as a pilot.
02 · Priority — High
Audit outlier transactions and introduce a bulk-order workflow
12 transactions above $3,855 are untracked in terms of context. Determine whether these are bulk orders, B2B clients, or data entry errors. If legitimate, create a dedicated B2B sales track with volume discounts and relationship management — this segment could be grown deliberately rather than incidentally.
03 · Priority — Medium
Standardize unit pricing or document dynamic pricing rules
Unit prices ranging from $5 to $400 for the same product category create audit and margin risk. Establish a pricing governance policy: either enforce SKU-level fixed prices or document a tiered pricing model (e.g., quantity discounts). This will also improve data quality scoring.
04 · Priority — Medium
Shift marketing spend toward Tue–Thu evenings
Tuesday and Thursday have the highest average ticket ($1,192 and $1,176) and evenings drive the most total revenue ($857K). Promotional campaigns, upsell nudges, and loyalty incentives targeted at these windows should yield above-average return. Consider testing extended hours on peak evenings for the top 3 stores.
05 · Priority — Medium
Root-cause analysis on August 2024 collapse
The $39K August 2024 result is a significant anomaly. Understanding whether this was caused by supply chain disruption, an IT system issue, staffing gaps, or external factors is critical to preventing recurrence. If unexplained, it also inflates uncertainty in any revenue forecast model.
06 · Priority — Low
Diversify beyond Monitor and Phone dependency
These two products represent 30.5% of revenue. Growing Laptop (currently bottom of the lineup at $285K) through targeted promotions or bundling with Monitor/Tablet accessories could reduce concentration risk and improve overall margin mix.