AnalyticsGuideBeginnerProfitability
Daily Gross Profit Tracking: Know Your Margin Every Morning, Not Every Month-End
Retailer: monthly gross margin 38%. COGS jumps week 2 (new supplier invoice at 5% higher price). Wit…
AnalyticsGuideBeginnerEfficiency
Revenue Per Employee: SGD 200K Is Good, SGD 80K Is a Warning — Where Do You Stand?
Retail chain: SGD 2.4M revenue, 18 employees = SGD 133K revenue per employee. Industry benchmark: SG…
AnalyticsGuideBeginnerRisk
Supplier Concentration Risk: Top 1 Supplier = 60% of Purchases = Business Stops If They Stop
Manufacturer: total purchases SGD 800K/year. Supplier A: SGD 480K (60%). Supplier B: SGD 160K (20%).…
AnalyticsGuideBeginnerRetention
Lapsed Customer Winback: 30% Reactivation Rate = Free Revenue From Customers You Already Paid For
Retailer: 2K active customers, 800 lapsed (no purchase in 90 days). Winback campaign: email + SGD 10…
AnalyticsGuideBeginnerInventory
Inventory Carrying Cost: Holding SGD 500K Stock Costs SGD 100K/Year Without Selling a Unit
Retailer: SGD 500K inventory on hand. Carrying cost: capital cost 4.5% (overdraft rate on SGD 500K) …
AnalyticsGuideBeginnerRetention
Net Revenue Retention: If Your NRR Is Below 100%, Your Business Is Shrinking Without Knowing
Subscription/recurring-revenue business: January cohort SGD 50K MRR. By July (6 months): churned SGD…
AnalyticsGuideBeginnerProfitability
Customer Profitability: B2B Segment 30% Margin, Retail 20%, Wholesale 5% (Defund Wholesale)
Manufacturer: B2B (direct to companies) SGD 5M revenue, 30% margin = SGD 1.5M profit. Retail (e-comm…
AnalyticsGuideBeginnerEfficiency
OpEx Ratio: 35% of Revenue Spent on Overhead (Should Be 25%) = Losing Profit
Retail chain SGD 10M revenue: operating costs SGD 3.5M (35% ratio = too high). Breakdown: rent SGD 1…
AnalyticsGuideBeginnerRisk
Concentration Risk: 3 Customers = 40% of Revenue (Fragile Business)
B2B manufacturer SGD 10M annual revenue: top 3 customers = SGD 4M (40%). Lose 1 customer = SGD 3.33M…
AnalyticsGuideBeginnerProfitability
Gross Margin: Category A 50% (healthy), Category B 15% (dying slowly)
Retail store: electronics category SGD 1M revenue, 15% margin = SGD 150K gross. Apparel SGD 800K rev…
AnalyticsGuideBeginnerWorking Capital
Cash Conversion Cycle: 60 Days (Receive Payment After 30 Days, Pay Supplier in 7) = Burn
Restaurant: holds inventory 5 days (perishable goods), collects payment 30 days average (B2B caterin…
AnalyticsGuideBeginnerGeography
Geographic Profitability: NYC Store 40% Higher Margin Than Phoenix (Why Open There?)
Retail chain: NYC store SGD 200K revenue, 25% margin = SGD 50K profit. Phoenix store SGD 200K revenu…
AnalyticsComparisonBeginnerMarketing
Marketing ROI: Google Ads 300% ROI vs Facebook Ads 50% = Defund Facebook
Monthly ad spend: Google SGD 10K → SGD 30K revenue (SGD 20K profit at 40% margin) = 200% ROI. Facebo…
AnalyticsGuideBeginnerMarketing
CAC Payback: SGD 500 to Acquire, SGD 50/Month Revenue, 10-Month Payback = Long
E-commerce: monthly marketing spend SGD 10K, customers acquired 20. CAC = SGD 500/customer. Monthly …
AnalyticsGuideBeginnerSales
Sales Pipeline: 50 Qualified Leads × 20% Close Rate = SGD 500K Forecast
B2B sales: 100 prospects (5% close rate) = 5 deals. 50 qualified leads (20% close rate) = 10 deals. …
AnalyticsGuideBeginnerProfitability
Break-Even Point: 1000 Units/Month at SGD 50 Price (Below This = Loss)
Restaurant: fixed costs SGD 30K/month (rent, utilities, staff). Variable cost per meal SGD 8 (COGS).…
AnalyticsGuideBeginnerForecasting
Seasonal Demand Forecast: Summer 40% Higher Than Winter (Prep Inventory Now)
Retail apparel: winter avg 100 units/month, summer avg 140 units/month (40% spike). Current inventor…
AnalyticsGuideBeginnerProfitability
Transaction Unit Economics: 30% of Sales Lose Money (Identify & Eliminate)
Online retailer order: SGD 50 price, SGD 30 COGS (GROSS SGD 20). Minus shipping SGD 5, payment fee S…
AnalyticsGuideBeginnerPricing
Price Sensitivity: 10% Price Increase = 20% Volume Drop (Elastic Demand)
Product A: base price SGD 50, volume 100 units. Raise to SGD 55 (10% increase): volume drops to 80 u…
AnalyticsComparisonBeginnerCustomer Value
Customer LTV: Premium Segment (SGD 5K/Customer) vs Budget Segment (SGD 500/Customer)
Retail: premium customers (bought furniture, avg SGD 2K/order, 5 orders lifetime) = SGD 10K revenue,…