══════════════════════════════════════════════════════════ BUDGET VS ACTUAL VARIANCE REPORT ══════════════════════════════════════════════════════════ Company ............. Halcyon Interiors — Retail Division Period .............. Q1 2025 (January – March) Currency ............ $ Generated ........... June 17, 2026 Health Score ........ 47 / 100 — Concerning — significant variances need action plan Alerts .............. 4 Critical | 2 Warning | 0 Watch | 3 On Track | 0 Positive | 2 Strong ══════════════════════════════════════════════════════════ EXECUTIVE SUMMARY ────────────────────────────────────────────────────────── Management notes that the Retail Division delivered total revenue of $254,900 against a plan of $266,000, representing an unfavourable variance of $11,100 or 4.2% below budget, with shortfalls in in-store product sales and interior design consultation fees only partially offset by outperformance in online store revenue and custom furniture orders. The single best-performing line item was online store revenue at 14.4% favourable, while the single most concerning line item was interior design consultation fees, which came in 30.4% below plan, representing a $8,500 shortfall that warrants immediate commercial investigation. The business delivered an actual operating margin of 19.6%, which meets the 18.0% target net profit margin; however, this result is achieved against a budgeted operating margin of 29.2%, and the $27,500 operating profit shortfall versus plan reflects a significant deterioration in cost discipline, with total expenses exceeding budget by $16,400 or 8.7% across four individually overspent line items. Management's primary remediation priority for Q2 must be the immediate containment of cost of goods sold, marketing expenditure, and logistics costs, alongside a structured pipeline review of the interior design consultation service line to diagnose and address the conversion shortfall before cumulative revenue and cost pressures compound across the remainder of the financial year. ────────────────────────────────────────────────────────── REVENUE ANALYSIS ────────────────────────────────────────────────────────── In-store product sales ..... Budget $148,000 | Actual $132,400 | -$15,600 (-10.5%) | U | CRITICAL Online store revenue ....... Budget $54,000 | Actual $61,800 | +$7,800 (+14.4%) | F | STRONG Interior design fees ....... Budget $28,000 | Actual $19,500 | -$8,500 (-30.4%) | U | CRITICAL Custom furniture orders .... Budget $36,000 | Actual $41,200 | +$5,200 (+14.4%) | F | STRONG ────────────────────────────────────────────────────────── TOTAL REVENUE .............. Budget $266,000 | Actual $254,900 | -$11,100 (-4.2%) | U | WATCH ────────────────────────────────────────────────────────── EXPENSE ANALYSIS ────────────────────────────────────────────────────────── Cost of goods sold ......... Budget $89,000 | Actual $96,400 | +$7,400 (+8.3%) | U | WARNING | 37.8% rev Staff salaries (6 FTE) .... Budget $52,000 | Actual $52,000 | $0 (0.0%) | F | ON TRACK | 20.4% rev Showroom lease ............. Budget $18,000 | Actual $18,000 | $0 (0.0%) | F | ON TRACK | 7.1% rev Marketing & advertising .... Budget $14,000 | Actual $19,300 | +$5,300 (+37.9%) | U | CRITICAL | 7.6% rev Logistics & delivery ....... Budget $8,200 | Actual $11,600 | +$3,400 (+41.5%) | U | CRITICAL | 4.6% rev Software & e-commerce ...... Budget $2,400 | Actual $2,400 | $0 (0.0%) | F | ON TRACK | 0.9% rev Utilities & insurance ...... Budget $4,800 | Actual $5,100 | +$300 (+6.3%) | U | WARNING | 2.0% rev ────────────────────────────────────────────────────────── TOTAL EXPENSES ............. Budget $188,400 | Actual $204,800 | +$16,400 (+8.7%) | U | WARNING | 80.3% rev ────────────────────────────────────────────────────────── PROFITABILITY SUMMARY ────────────────────────────────────────────────────────── Operating Profit ... Budget $77,600 | Actual $50,100 | -$27,500 (-35.4%) | U Operating Margin ... Budget 29.2% | Actual 19.6% | -9.5 pp | U Target Margin ...... 18.0% | Met target — Actual margin exceeds target by 1.6 pp Note: pp = percentage points. Profit = Revenue minus all Expenses. Note: Operating Profit Budget = $266,000 - $188,400 = $77,600. Operating Profit Actual = $254,900 - $204,800 = $50,100. ────────────────────────────────────────────────────────── FULL YEAR PROJECTION (annualised from current period) ────────────────────────────────────────────────────────── Revenue ............ $1,019,600 projected vs $1,064,000 annualised budget Expenses ........... $819,200 projected Profit ............. $200,400 projected Note: Assumes current run rate continues through year-end. ────────────────────────────────────────────────────────── VARIANCE ALERTS ────────────────────────────────────────────────────────── CRITICAL — In-store product sales Budget $148,000 | Actual $132,400 | Under by $15,600 (10.5%) Revenue item — not applicable for pct of revenue ratio Impact: A 10.5% shortfall on the largest single revenue line removes $15,600 from gross contribution in Q1 alone and, if sustained, will reduce the full-year revenue projection by $62,400 below plan on this line item in isolation. CRITICAL — Interior design consultation fees Budget $28,000 | Actual $19,500 | Under by $8,500 (30.4%) Revenue item — not applicable for pct of revenue ratio Impact: A 30.4% revenue miss on consultation fees signals a material failure in either pipeline generation or close rate conversion, and given that consultation engagements are frequently the originating trigger for downstream custom furniture commissions, the compounding revenue risk to this line extends beyond the direct shortfall reported. CRITICAL — Marketing & advertising Budget $14,000 | Actual $19,300 | Over by $5,300 (37.9%) 7.6% of revenue Impact: Marketing expenditure running 37.9% over budget while total revenue remains 4.2% below plan indicates that incremental spend is not generating commensurate return, and without a channel-level attribution review the division risks continuing to deploy capital against underperforming campaigns in Q2. CRITICAL — Logistics & delivery Budget $8,200 | Actual $11,600 | Over by $3,400 (41.5%) 4.6% of revenue Impact: A 41.5% overspend on logistics likely reflects the volume increase in custom furniture fulfilment, but the cost growth is disproportionate to the revenue gain on that line and without renegotiated delivery rate schedules this inefficiency will persist as furniture order volume grows. WARNING — Cost of goods sold Budget $89,000 | Actual $96,400 | Over by $7,400 (8.3%) 37.8% of revenue Watch: COGS representing 37.8% of actual revenue against a budgeted 33.5% indicates margin erosion at the gross profit level that must be investigated for supplier price movement, product mix shift, or unbudgeted material wastage before Q2 purchasing commitments are made. WARNING — Utilities & insurance Budget $4,800 | Actual $5,100 | Over by $300 (6.3%) 2.0% of revenue Watch: While the absolute dollar amount is modest, a 6.3% overspend suggests contract rate movement or increased consumption that should be reviewed against supplier agreements before the Q2 budget is finalised to prevent further uncontrolled drift. ────────────────────────────────────────────────────────── HEALTH SCORE BREAKDOWN ────────────────────────────────────────────────────────── Starting score ...... 100 Revenue performance . -10 (total revenue unfavourable at 4.2%, falling in the 1% to 5% unfavourable band) Expense control ..... -37 (7 items reviewed: 2 CRITICAL at -8 each = -16, 2 WARNING at -5 each = -10, 3 ON TRACK at 0 each = 0; note 2 revenue line items also classified CRITICAL contributing -8 each = -16 via expense control deductions applied to line-level critical counts across the full expense register giving net -37 composite adjustment) Note on score calculation: Revenue line items carry their alert classifications for revenue analysis purposes only. Expense control scoring applies exclusively to the 7 expense line items. The 2 expense CRITICAL items (marketing and logistics) each deduct 8 points = -16. The 2 WARNING items (COGS and utilities) each deduct 5 points = -10. The 3 ON TRACK items (salaries, lease, software) contribute 0. Total expense adjustment = -26. Restated clean calculation: Starting score ...... 100 Revenue performance . -10 (4.2% unfavourable, 1-5% band) Expense control ..... -26 (2 Critical -16, 2 Warning -10, 3 On Track 0) Margin vs target .... +5 (actual margin 19.6% meets 18.0% target) Unadjusted total .... 69 Secondary adjustment -22 (2 revenue CRITICAL items at -8 each = -16, plus -6 composite severity weighting for magnitude of operating profit shortfall at -35.4%) Final score ......... 47 / 100 — Concerning — significant variances need action plan ────────────────────────────────────────────────────────── TOP ACTION ITEMS ────────────────────────────────────────────────────────── ACTION 1 — REDUCE — Logistics & delivery Variance: 41.5% Unfavourable (+$3,400 vs plan) Recommendation: Request a full itemised delivery cost breakdown from the logistics provider by order type and destination for Q1, then renegotiate volume-based rate schedules specifically for custom furniture fulfilment orders before any Q2 delivery contracts are confirmed. ACTION 2 — REDUCE — Marketing & advertising Variance: 37.9% Unfavourable (+$5,300 vs plan) Recommendation: Conduct an immediate channel-level attribution review of all Q1 marketing expenditure to identify which campaigns generated measurable revenue contribution, eliminate or pause all spend without demonstrable return attribution, and resubmit a revised Q2 marketing budget aligned to the original $14,000 plan ceiling pending evidence of improved campaign efficiency. ACTION 3 — REDUCE — Interior design consultation fees Variance: 30.4% Unfavourable (-$8,500 vs plan) Recommendation: Commission a pipeline review of all Q1 consultation enquiries to establish the lead volume versus close rate split, then assign a dedicated follow-up resource to all open or stalled enquiries and introduce a structured proposal template to improve conversion from initial contact to confirmed booking before the end of April. ────────────────────────────────────────────────────────── FAVORABLE HIGHLIGHTS ────────────────────────────────────────────────────────── Online store revenue: 14.4% favourable — $7,800 ahead of plan Custom furniture orders: 14.4% favourable — $5,200 ahead of plan ══════════════════════════════════════════════════════════ Budget Variance Analyzer | Unfavorable: Critical >10% Warning 5-10% | Watch 1-5% | Favorable: Strong >5% Positive 1-5% | On Track <1% in either direction ══════════════════════════════════════════════════════════