A menu item's sales mix needs a clearly named total. “Chicken is 40%” is incomplete unless a colleague knows whether that means item quantities, sales value or something else. This original fictional lunch report teaches quantity mix and shows why a rising item count can accompany a falling share.
Define the items and period first
Our training dataset covers main dishes sold in one dining room during one completed lunch. Every entry is one main dish. It contains no combo components, modifiers, canceled items or returns. Those are classroom assumptions; use your own system's report definitions for actual work.
Oracle's Top Menu Items Summary documentation separates quantity sold and quantity percentage from monetary sales and sales percentage. It also allows the number of displayed top items to be selected. A shortened list should therefore prompt a denominator check before you calculate a percentage.
Calculate the main-dish quantity mix
- Chicken dish: 24 sold.
- Pasta dish: 18 sold.
- Fish dish: 12 sold.
- Vegetable dish: 6 sold.
Total main dishes: 24 + 18 + 12 + 6 gives 60. Divide each item count by 60 and multiply by 100.
- Chicken: 24 ÷ 60 × 100 gives 40%.
- Pasta: 18 ÷ 60 × 100 gives 30%.
- Fish: 12 ÷ 60 × 100 gives 20%.
- Vegetable: 6 ÷ 60 × 100 gives 10%.
The four shares total 100%. A precise note is: “Chicken accounted for 24 of 60 main dishes sold, or 40% of main-dish quantity.” This does not establish a guest count: one person might order more than one item or share a dish.
Avoid two denominator traps
Suppose a screen displays only the two leading items, chicken and pasta. Their displayed counts add to 42. Dividing 24 by 42 gives about 57.1%, but that is chicken's share of those two items only. It is not the 40% share of all 60 main dishes. Read the report's total and selected filters.
In a separate worksheet, someone adds 20 desserts to the original 60 mains. Chicken's share of these 80 items is now 30%. No chicken sale disappeared; the selected category changed. Keep mains-only and mains-plus-desserts comparisons separate and label both clearly.
Compare counts and shares together
A second fictional lunch sells 30 chicken, 34 pasta, 24 fish and 12 vegetable dishes: 100 mains in total. Chicken sales increased from 24 to 30, but its share fell from 40% to 30%. That is an increase of six dishes and a decline of 10 percentage points. Neither statement contradicts the other.
Before comparing real periods, check matching outlets, meal periods, item definitions and included categories. Note unavailable dishes or menu changes that could affect the interpretation. Two invented lunches demonstrate arithmetic, not a demand forecast or proof of a guest preference.
Use the result within its limits
Quantity mix alone does not show revenue share, contribution margin or profit. The example has no prices or costs. Do not label the most ordered dish the most profitable, or change purchasing quantities from this worksheet alone.
Practise explaining the 40%, 57.1% and 30% figures with their denominators. For broader dining-room skills, explore HCA food and beverage service training.
Explore HCA food and beverage service training
