margin before17,1%
margin after the spike15,0%
consulting
P&L review
Restaurant chain
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
- We break the P&L down by location and expense item and look for what grew everywhere at once.
- We build a profit model with seasonality and rent as a percentage of revenue.
- We pick out weak locations by their economics and find the cause of the decline at each one.
- 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
next case study
Automations for the owner
discuss a project
discuss a project on telegram