๐Ÿข Star Glory โœฆ BI & Sales Analytics Strategy Report

Report Date: June 3, 2026  |  Classification: Internal โ€” Management  |  Data Source: 2022โ€“2026 (10,296 transactions)

๐Ÿ“‹ Executive Summary

This report leverages Star Glory's five-year sales transaction dataset (2022โ€“2026) across Major Appliances and Kitchen Appliances to deliver three core strategic modules for management decision-making:

ModuleObjectiveKey Finding
19-Month Rolling ForecastSet 2026 Jun โ€“ 2027 revenue targets2027 full-year target: $23.20M (+22.7% vs 2026)
BCG Portfolio MatrixOptimal resource allocationWestinghouse = absolute Cash Cow (GM 40.7%); ELLE = high-velocity Star (3yr CAGR 500%+)
Anomaly Detection SystemRisk early-warning & margin protection5 trigger criteria for real-time alerts on margin and client health

Historical Revenue Overview

YearStatusRevenue (USD)YoYCost (USD)Avg GMOrder Qty
2022โœ… Actual$19,179,478โ€”$13,236,35831.0%1,089,818
2023โœ… Actual$21,913,585+14.3% โ–ฒ$15,764,05928.1%1,535,450
2024โœ… Actual$21,326,257โˆ’2.7% โ–ผ$14,813,47730.5%1,575,645
2025โœ… Actual$16,575,772โˆ’22.3% โ–ผ$9,591,47342.1%966,611
2026 (Janโ€“May)โœ… Actual$7,553,921โ€”$4,977,67734.1%359,527
โš ๏ธ Key Observation: Revenue declined from 2023โ€“2025, but gross margin improved dramatically to 42.1% in 2025 โ€” reflecting a deliberate shift toward higher-margin orders. 2026 YTD (Janโ€“May) revenue stands at $7.55M, annualised run-rate ~$18.1M.

1. Rolling 19-Month Sales Forecast (2026 Jun โ€“ 2027 Dec)

1.1 Methodology

Using Weighted Moving Average (WMA) combined with seasonal adjustment factors, we project forward from the 2026 Janโ€“May actual baseline. The home appliance export industry exhibits strong seasonality (H2 โ‰ˆ 55% of annual revenue due to Q3 holiday-season restocking by North American and European retailers).

1.2 Forecast Targets & Baseline

PeriodStatusWestinghouseELLE FamilyOther BrandsTotal
2025 Full Yearโœ… Actual$9,468,800$816,820$6,290,152$16,575,772
2026 Janโ€“Mayโœ… Actual$3,329,008$539,923$3,684,991$7,553,921
2026 Junโ€“Dec๐Ÿ”ฎ Forecast$6,508,624$552,176$4,295,542$11,356,342
2026 Full Year๐Ÿ“Š Combined$9,837,632$1,092,099$7,980,532$18,910,263
2027 Full Year๐Ÿ”ฎ Forecast$12,788,921$1,474,334$8,938,196$23,201,452
๐Ÿ“Š Forecast Summary:
โ€ข 2026 full year projected at $18.91M (Janโ€“May actual $7.55M + Junโ€“Dec forecast $11.36M)
โ€ข 2026 H2 (Julโ€“Dec) forecast $10.03M, +10.0% vs 2025 H2 ($9.12M) โœ“
โ€ข 2027 full-year target $23.20M, +22.7% vs 2026 full year (WH +30%, ELLE +35%, Other +12%)

๐Ÿ“Š Brand Annual Performance โ€” Bar Charts (Actual vs Forecast)

๐Ÿ”ต Westinghouse

Actual Forecast

๐ŸŸข ELLE Family

Actual Forecast

๐ŸŸค Other Brands

Actual Forecast

๐ŸŸฃ Overall Business (All Brands Combined)

Actual Forecast

1.3 19-Month Monthly Rolling Forecast (2026 Jun โ€“ 2027 Dec)

MonthWestinghouseELLE FamilyOther BrandsMonthly TotalCumulative
2026 Jun ๐Ÿ”ฎ$780,000$58,000$490,000$1,328,000$8,881,921
2026 Jul ๐Ÿ”ฎ$850,000$65,000$525,000$1,440,000$10,321,921
2026 Aug ๐Ÿ”ฎ$920,000$72,000$560,000$1,552,000$11,873,921
2026 Sep ๐Ÿ”ฎ$1,050,000$80,000$620,000$1,750,000$13,623,921
2026 Oct ๐Ÿ”ฎ$1,180,000$85,000$680,000$1,945,000$15,568,921
2026 Nov ๐Ÿ”ฎ$1,100,000$78,000$640,000$1,818,000$17,386,921
2026 Dec ๐Ÿ”ฎ$920,000$68,000$535,000$1,523,000$18,909,921
โ€”โ€” 2026 Full Year Combined: $18,910,263 โ€”โ€”
2027 Jan ๐Ÿ”ฎ$780,000$62,000$480,000$1,322,000$20,231,921
2027 Feb ๐Ÿ”ฎ$820,000$68,000$510,000$1,398,000$21,629,921
2027 Mar ๐Ÿ”ฎ$880,000$75,000$550,000$1,505,000$23,134,921
2027 Apr ๐Ÿ”ฎ$950,000$80,000$580,000$1,610,000$24,744,921
2027 May ๐Ÿ”ฎ$1,020,000$88,000$610,000$1,718,000$26,462,921
2027 Jun ๐Ÿ”ฎ$1,080,000$92,000$650,000$1,822,000$28,284,921
2027 Jul ๐Ÿ”ฎ$1,150,000$98,000$680,000$1,928,000$30,212,921
2027 Aug ๐Ÿ”ฎ$1,220,000$105,000$720,000$2,045,000$32,257,921
2027 Sep ๐Ÿ”ฎ$1,380,000$115,000$810,000$2,305,000$34,562,921
2027 Oct ๐Ÿ”ฎ$1,520,000$125,000$880,000$2,525,000$37,087,921
2027 Nov ๐Ÿ”ฎ$1,420,000$118,000$830,000$2,368,000$39,455,921
2027 Dec ๐Ÿ”ฎ$1,180,000$98,000$700,000$1,978,000$41,433,921
โ€”โ€” 2027 Full Year Total: $23,201,452 โ€”โ€”

1.4 Growth Drivers by Brand Line

A) Westinghouse (~52% of revenue) โ€” ๐Ÿ„ Cash Cow, Steady Expansion

2027 Target: $12.79M (+30.0% vs 2026)

Growth DriverDetails
Product Depth400+ SKUs covering all categories. 2026โ€“2027: new IoT smart appliance line (WiFi Kettle, App-Controlled Air Fryer)
Established Client BaseCOSTCO, Walmart, Loblaw and other Tier-1 retailers. 57.1% of total company revenue in 2025
Brand PremiumAll-period average GM 40.7%, far above OEM (15.7%). 2025 GM reached 50.2%
Supply Chain OptimizationGM improved 13.2pp from 2024 to 2025 (37.0% โ†’ 50.2%) through procurement cost control

B) ELLE Family (~6% of revenue, high-growth) โ€” โญ Rising Star

2027 Target: $1.47M (+35.0% vs 2026)

Growth DriverDetails
Explosive GrowthFrom $3,163 in 2022 โ†’ $816,820 in 2025. 3-year CAGR exceeds 500%
French Fashion Brand EquityELLE average GM 57.5%, ELLE Sport 77.0%
Panache Premium LineAir Fryer, Kettle, Toaster, Coffee Maker launched 2025โ€“2026. AI virtual ambassador Estelle video marketing active
Channel ExpansionExpanded from single client to Costco, COBAN, MELCOM, and into Japan, France, Middle East in 2026

C) Other Brands (~42% of revenue) โ€” ๐Ÿ”„ Optimization Phase

2027 Target: $8.94M (+12.0% vs 2026)

Brand2025 RevenueAvg GMStatus
OEM$2,612,05015.7%Cash Cow Volume play, thin margin
Blaupunkt$3,508,61925.6%Question Mark 2026 YTD declined to $1.76M
Oster$53,00128.7%Question Mark Too small
Black & Decker$115,86026.9%Question Mark 2026 YTD rebounded to $301K
Daewoo$62118.1%Dog Effectively exited

2. Business Portfolio Management โ€” BCG Matrix

2.1 Brand & Product Line Quadrant Classification

QuadrantBrand / Product Line2025 Revenue3yr GrowthGMResource Allocation
โญ StarELLE Panache Series$799,639500%+71.2%Invest Aggressively
35% budget
โญ StarELLE Home / ELLE Sport$8,466New100%
โญ StarWestinghouse IoT Smart AppliancesNewโ€”Est. 50%+
๐Ÿ„ Cash CowWestinghouse Core Series$9,468,800Stable50.2%Maintain & Harvest
50% budget
๐Ÿ„ Cash CowOEM Quality Clients (GM>20%)(Included)Stable20%+
โ“ Question MarkBlaupunkt$3,508,619Slowing30.3%Selective Investment
10% budget
โ“ Question MarkBlack & Decker$115,860Rebounding16.7%
โ“ Question MarkOster$53,001Uncertain54.5%
๐Ÿ• DogDaewoo$621Cliff dropN/AExit / Streamline
5% budget
๐Ÿ• DogLow-Margin OEM (GM<12%)(Included)โ€”<12%
๐Ÿ• DogSpare Parts / AccessoriesMinimalFragmentedVariable

2.2 Management Recommendations by Quadrant

QuadrantBrand / Product2027 Resource AllocationKey Actions
โญ StarELLE Family, WH IoT AppliancesAggressive Investment (35%)Hire dedicated ELLE Brand Manager; scale AI ambassador video marketing to 2โ€“3/month; expand to 5โ€“8 new international distributors
๐Ÿ„ Cash CowWestinghouse Core, OEM QualityMaintain & Harvest (50%)Supply chain optimization targeting 3โ€“5% cost reduction; extract 15โ€“20% of WH profit to fund Star quadrant
โ“ Question MarkBlaupunkt, Black & Decker, OsterSelective Investment (10%)6-month observation window; Blaupunkt exit if H2 2026 < $1.3M
๐Ÿ• DogDaewoo, Low-GM OEM, Spare PartsExit / Streamline (5%)Formally terminate Daewoo; renegotiate or exit low-GM OEM within 90 days

3. Anomaly Detection & Alert System

An AI-driven dual-layer (statistical thresholds + industry heuristics) anomaly detection engine that scans the sales database daily and notifies management via Telegram / Email / Dashboard when any of the following 5 criteria are triggered.

๐Ÿšจ Alert 1: Key Client Order Decline
ThresholdConsecutive 2 months order volume decline โ‰ฅ 30%
ScopeTop 10 clients (ranked by trailing 12-month revenue)
Severity๐ŸŸ  Warning
NotificationTelegram push + Email to VP Sales
SLAClient contact within 24h; mitigation plan within 72h
๐Ÿšจ Alert 2: Gross Margin Anomaly
ThresholdMonthly GM below trailing 12-month average by โ‰ฅ 10pp
ScopeAll active brand lines + Top 20 SKUs
Severity๐Ÿ”ด Critical
NotificationDashboard pinned + Telegram + Email to Procurement & Finance Directors
SLARoot cause identified within 48h (supplier / customer / FX)
๐Ÿšจ Alert 3: Procurement Cost Spike
ThresholdSame SKU unit cost increase โ‰ฅ 25% vs trailing 12-month average
ScopeAll PO and FPO unit procurement costs
Severity๐ŸŸก Info
NotificationPO auto-frozen in approval workflow โ†’ manual review by Procurement Director
SLAPO held until approved; if rejected, notify supplier within 48h
๐Ÿšจ Alert 4: Accounts Receivable Overdue
ThresholdOverdue โ‰ฅ 60 days AND cumulative amount โ‰ฅ $50,000
ScopeAll client receivables
Severity๐Ÿ”ด Critical
NotificationTelegram + Email to CFO & VP Sales
SLAImmediately halt new order shipments to that client
๐Ÿšจ Alert 5: Supplier Concentration Risk
ThresholdSingle supplier share โ‰ฅ 60% of any brand line procurement
ScopeSupplier procurement share per brand line
Severity๐ŸŸ  Warning
NotificationDashboard monthly review + Supply Chain Risk Report
SLAInitiate 2nd supplier evaluation within 30 days; backup supplier onboarded within 90 days

3.1 Alert Severity & Response SLA

SeverityColorResponse TimeEscalation
Critical๐Ÿ”ด Red2 hours24h unresolved โ†’ auto-escalate to CEO
Warning๐ŸŸ  Orange24 hours72h unresolved โ†’ escalate to VP
Info๐ŸŸก Yellow5 business daysMonthly summary report

4. Strategic Action Plan

Immediate (30 Days)

#Action ItemOwner
1Begin anomaly detection system development (5 criteria above)IT + BI
2Initiate 6-month Blaupunkt observation periodSales
3Identify all OEM orders with GM < 12%Procurement
4Formally terminate Daewoo brand lineManagement

90-Day Actions

#Action ItemOwner
5Hire dedicated ELLE Brand ManagerHR
6Launch ELLE AI ambassador monthly video programme (2โ€“3/month)Marketing
7Finalize Westinghouse IoT smart appliance product roadmapProduct
8Supplier concentration risk assessment reportProcurement

2027 Full-Year KPI Targets

KPI2026 Estimate2027 TargetGrowth
Total Revenue$18,910,263$23,201,452+22.7%
Westinghouse Revenue$9,837,632$12,788,921+30.0%
ELLE Family Revenue$1,092,099$1,474,334+35.0%
Other Brands Revenue$7,980,532$8,938,196+12.0%
Overall Gross Margin~38%42%++4pp
Active Clients~150175++16.7%

5. Conclusion

Star Glory stands at a pivotal strategic inflection point. Westinghouse, the Cash Cow, provides a rock-solid profit foundation (~$10M annual revenue at 50%+ GM), while ELLE Family's explosive growth (3-year CAGR 500%+) opens a new premium brand pathway.

The three modules presented in this report โ€” 19-month precision forecasting, BCG resource allocation matrix, and AI-driven anomaly detection โ€” form a complete BI & Sales Analytics strategic framework. With decisive execution of the action plan above, Star Glory is positioned to achieve $23.20M in revenue at 42%+ gross margin in 2027, setting the stage to break the $30M barrier in 2028.

๐Ÿ“Ž Report Info: Generated by AI business analytics engine from Star Glory's 2022โ€“2026 transactional database (10,296 records). Forecast model: Weighted Moving Average (WMA) with seasonal adjustment (H2 = 55% weighting).
๐Ÿ”„ Next Update: Monthly rolling forecast refresh recommended.
๐Ÿ“Š Data Source: Star Glory Major Appliances BI Dashboard v6