Is the menu as profitable as the recipe cards say?
Fourteen-month-old recipe cards overstated the menu's margin by 6.1 points (64.5%, not 70.6%), and nine dishes were selling below cost.
What went in
- Files
- 3
- Rows
- 68,892
- Period
- Jan 1 – Jun 30
- Verification
- 16 checks passed
Source files
- product_mix_jan_jun.csv68,412 rows
- recipe_costs.xlsx62 rows
- supplier_price_list.pdf418 rows
What came back
- 64.5%
- $78,168
- 3
The finished project
The menu margin is 64.5%, not the 70.6% the recipe cards give.
The recipe cards were costed fourteen months ago and supplier prices have moved since. Recomputed against the current price list, with modifiers attached to the dishes they belong to and waste counted, contribution over six months is $78,168 lower than reported. Three of the sixty-two dishes sell below what they cost to make, all of them lunch items on a promotional price nobody revisited, and together they lost $2,141. Loaded fries, the second-best seller, contributes $3.10 a plate against $9.85 for the burger beside it.
Every category costs more than its recipe card says
Sides drift furthest: 76.4% reported, 64.1% real
- 01The recipe cards are fourteen months old and overstate margin by 6.1 points.
- 02Three dishes sell for less than they cost to make.
- 0311.4% of revenue is booked to modifier lines attached to no dish.
Filed under
Closest to this one
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.