Profitability and margin improvement opportunities · Café Aurora
Example business: Café Aurora — a coffee shop and bakery with one location and delivery-app sales.
The ten sections organize this illustrative example. Each product report has its own scope and format.
Analysis overview
Business, period, currency and scope.
- Business
- Café Aurora (fictitious data)
- Period
- January – June 2025
- Currency
- USD
- Scope
- Gross margin by category and channel; fixed expenses not allocated.
Executive summary
Main results and opportunities.
The business had USD 186,400 in net sales for the half-year with a 42.0% gross margin. Margin fell 1.3 points versus the previous half: the sales mix shifted toward lunches, the lowest-margin category, and delivery-app commissions grew faster than sales.
- Hot drinks contribute 54% of total margin with only 33% of sales.
- The retail coffee-bean line runs at a 5.8% margin, close to break-even.
- Three calculated scenarios could add up to USD 12,200 in annual margin under explicit assumptions.
Data quality and sufficiency
Available costs, exclusions and limitations.
The sales file includes unit cost for 91% of the lines; lines without cost are excluded from margin calculations and listed in the annex. Fixed expenses were not available, so the report is limited to gross margin.
- 9,412 sales lines analyzed; 842 excluded for missing cost.
- App commissions taken from the aggregator’s monthly statement.
- No waste data: the real cost of bakery items may be underestimated.
Key indicators
Revenue, costs and calculable margins.
Net sales
USD 186,400
+6%
Direct cost
USD 108,100
+8.3%
Gross margin
USD 78,300
+2.8%
Gross margin %
42.0%
-3%
Disaggregated profitability
By product, service, category, channel or customer, depending on availability.
Profitability was disaggregated by category; the product- and channel-level detail is in the annex.
Margin contribution by category
Gross margin in dollars contributed by each category over the half-year.
Explore with the pointer or keyboard. Tap a value to keep its detail visible.
Factors associated with margin
Discounts, costs and sales mix.
Three factors explain the 1.3-point drop: sales mix, per-channel commission cost and discounts. Lunches went from 22% to 28% of sales, and every mix point that migrates from drinks to lunches erodes margin.
Improvement scenarios
Cost or discount changes under explicit assumptions.
Each scenario was calculated separately over the half-year data and annualized. Assumptions are explicit and must be validated before executing.
AI analysis
Interpretation of the results and improvement opportunities supported by the data.
Key findings
The app channel erodes lunch margin
Some 31% of lunches sell through apps at an 8.9% commission, versus a 2.1% commercial cost at the counter. The same dish leaves 6.8 fewer margin points through that channel.
Evidence: Discounts and commissions by channel table (element 6).
Retail coffee beans are close to break-even
At a 5.8% margin and USD 1,400 of half-year contribution, the line depends on zero waste and no promotions to avoid a loss.
Evidence: Margin by category (element 5).
Mix explains more than prices
Average prices per category rose slightly; the total margin drop comes from a 6-point mix shift toward lunches.
Evidence: Key indicators (element 4) and the mix detail in the annex.
Business interpretation
Margin is not being lost in the kitchen but in the channel and the mix. Before touching prices, decide the role of each channel: apps bring lunch volume that is currently paid for with margin. The decision this report can support is renegotiating the commission or partially moving that cost into channel pricing.
Hypotheses and limitations
- The bakery margin decline could come from unrecorded waste; a two-week production count is needed to validate it.
- There is no price-elasticity data: the effect of scenario C is an assumption, not a measurement.
Prioritized recommendations
Renegotiate the app commission
At the current order volume, negotiating from 8.9% to 6% is the highest calculated-impact lever (USD 5,600 per year) and does not touch the customer experience.
Channel-differentiated lunch pricing
If renegotiation fails, evaluate a 6–8% higher price on apps, a common practice in the category. Pilot with two dishes before extending it.
Decide the future of the coffee-bean line
Re-price it, treat it explicitly as a loss-leader, or discontinue it. Keeping it without a decision consumes working capital with no contribution.
Proposed follow-up
Action plan
Prioritized measures, suggested owners and follow-up metrics.
Methodology and annexes
Formulas, assumptions and detailed tables.
Gross margin = net sales − directly attributable costs (inputs, packaging, commissions and discounts). Fixed expenses were not allocated because they were not available in the data.
- Annex A: margin by product (214 products).
- Annex B: lines excluded for missing cost.
- Annex C: calculation detail for the three scenarios.