margin before17,1%
margin after the spike15,0%
consulting

P&L review

Restaurant chain

clientRestaurant chain
year2026
workP&L, Profit model, Weak locations

task

The chain's monthly margin fell from 17.1% to 15.0%, and the report did not show why. We went line by line and found an expense item that had grown at thirteen locations at once.

what we did

  1. We break the P&L down by location and expense item and look for what grew everywhere at once.
  2. We build a profit model with seasonality and rent as a percentage of revenue.
  3. We pick out weak locations by their economics and find the cause of the decline at each one.
  4. Code does the tables, the model writes the conclusions, and the estimates are reconciled with the P&L every night.

result

2/3of the margin drop explained by one expense item that grew 4–15 times
4–6 ppof location margin was understated by office salaries in the books; the error was found
+12–23%check growth while guest numbers fell at 11 of 13 weak locations
−52%drop in dine-in at the shopping mall location while delivery held steady
discuss a project
discuss a project on telegram
€250 reviewbook