How to Calculate a Restaurant's Daily Sales Mix

What does restaurant sales mix measure?

Sales mix describes how sales are distributed among menu items or categories during a defined period. There are at least two useful views: unit mix, based on quantities sold, and revenue mix, based on sales value. They answer different questions and should not be combined into one unlabeled percentage.

Unit mix for an item = item quantity sold ÷ total menu-item quantity sold × 100.

Revenue mix for an item = item net sales ÷ total net sales for the same item set × 100.

Use a fixed menu-item set and a consistent period. State whether discounts, refunds, taxes, modifiers, combos and complimentary items are included. Point-of-sale reports may use different definitions; inspect the report settings before interpreting the percentages.

Worked example with unit mix and revenue mix

Suppose a café records 120 dosa orders at ₹180 each and 80 sandwich orders at ₹220 each for a week. In this example there are 200 items in the chosen set. Dosa has 120 ÷ 200 = 60% unit mix; sandwiches have 40%. Gross item sales are ₹21,600 for dosa and ₹17,600 for sandwiches, giving total sales of ₹39,200. Revenue mix is therefore about 55.1% dosa and 44.9% sandwich, before any discounts, taxes or other adjustments. These invented amounts show the arithmetic only.

The two views differ because the average selling prices differ. The item with the larger unit share does not necessarily generate the larger revenue share. Neither measure by itself shows profit: the calculation does not subtract ingredient, labor or channel costs.

Add contribution margin only when cost records support it

A contribution view needs a consistent variable-cost basis for every included menu item. OpenStax defines contribution margin as sales less variable costs and notes that a multi-product break-even analysis depends on maintaining the assumed sales mix. A restaurant can calculate item contribution as item net sales less the selected variable costs, then show each item’s contribution share. It should not call revenue mix “profit mix.”

For a multi-item venue, calculate the chosen mix from the same point-of-sale export and period. If a combo includes several dishes, decide whether it counts as one sale unit or whether the restaurant has reliable component quantities to allocate. Avoid mixing item counts from one report with revenue totals from another. Check whether cancellations and voids have been removed and whether modifiers appear as separate lines.

Compare periods carefully

Use the same item definitions across periods. A renamed dish, changed category, menu price, discount, channel or unavailable-item status can change the data. If an item appears only part of the period, note that before comparing its share with a full-period item. City or outlet comparisons require consistent menus and accounting/report settings too.

Worked unit-share and revenue-share example

Suppose three menu items sell 120, 80 and 50 units during a week. Total unit sales are 250. Their unit shares are 48%, 32% and 20%, respectively. If the first item is priced at ₹200 and sells 120 units, it contributes ₹24,000 in gross item sales before any adjustments. Another item with fewer units at a higher price can have a larger revenue share than unit share. Those percentages answer different questions, so label the report.

Use the same date range, item identity, outlet and order statuses for every numerator and the total denominator. Decide how to handle discounts, refunds, voids, bundled items and modifiers; state whether sales are gross or net. A change in category names or item IDs can split one item into several rows unless the data is normalized. Sales mix does not equal profit mix: item cost and other variable expenses require separate cost data. A popularity rank alone cannot establish profitability.

A rising unit share means that item accounted for a larger proportion of recorded units in the selected set; it does not establish why guests chose it. Sales mix is descriptive. It does not prove demand beyond the observed period, customer preference, margin, or the effect of a menu change. For related math, read menu-item contribution margin, fixed and variable restaurant costs, and average order value for a restaurant.

Simple reporting table

The figures are hypothetical; the table illustrates how to keep units and rupees in separate columns. A good report labels its period, outlet, channel and inclusion rules so another person can reproduce it.

• Dosa: 120 units; 60% of units; ₹21,600 in example gross sales; 55.1% of example revenue.
• Sandwich: 80 units; 40% of units; ₹17,600 in example gross sales; 44.9% of example revenue.
• Total: 200 units and ₹39,200 in example gross sales.