Skip to main content
These examples use fictitious data, names and figures. Their content and format are illustrative; available results depend on the product you choose and the data you provide.

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Demo reportSample report

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.

  • Hot drinksUSD 42,200
  • BakeryUSD 21,400
  • LunchesUSD 13,300
  • Coffee beansUSD 1,400

Explore with the pointer or keyboard. Tap a value to keep its detail visible.

Margin by category
CategoryNet salesCostMarginMargin %
Hot drinksUSD 62,100USD 19,900USD 42,20068.0%
BakeryUSD 48,700USD 27,300USD 21,40043.9%
LunchesUSD 51,300USD 38,000USD 13,30025.9%
Coffee beans (retail)USD 24,300USD 22,900USD 1,4005.8%

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.

Discounts and commissions by channel
ChannelNet salesDiscount + commission% of sales
CounterUSD 121,200USD 2,5002.1%
Delivery appsUSD 50,900USD 4,5008.9%
Event ordersUSD 14,300USD 6004.0%

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.

Margin improvement scenarios
ScenarioAssumptionEstimated annual margin
A. Renegotiate app commission to 6%Same volume of app orders.USD 5,600
B. Joint dairy purchasing (−8% cost)Discount confirmed by the supplier above a volume threshold.USD 3,900
C. Raise lunch prices by 5%Assumed 10% volume drop; elasticity has not been measured.USD 2,700

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

Priority: High

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.

Priority: Medium

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.

Priority: Medium

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

Proposed follow-up
IndicatorReference valueReview period
Total gross margin42.0% → proposed target 44% (a goal, not a projection)Monthly review
App channel commercial cost8.9% of channel salesReview when renegotiation closes

Action plan

Prioritized measures, suggested owners and follow-up metrics.

Action plan
ActionSuggested ownerFollow-up metricPriority
Renegotiation meeting with the delivery aggregatorAdministrationAgreed commission %High
Two-week bakery waste countKitchenWaste % of productionMedium
Decision on the coffee-bean lineManagementCategory margin %Medium

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.

Other sample reports

Apply the question to your data

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Profitability and margin improvement opportunities · Sample report · Valerian Data