01 / 05
Which stock is tying up cash?
$128,000 of stock had not sold in nine months, and half was bought to reach a supplier discount.
- $412,000
- 31.0%
- 214
Stock and sales, 12 months · 4 files · 94,154 rows
Open case studyOperations examples
Scheduling and stock: the day-to-day mechanics of a place, and what they cost when they slip.
5 of 11 · Operations
See all examples02 / 05
Why is our no-show rate 22%?
The 22.4% rate combined three different events; the unrecovered no-show rate was 11.4%.
- 11.4%
- 24.00
- $340,000
Appointment book, January to June · 3 files · 26,066 rows
Open case study03 / 05
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.
- 64.5%
- $78,168
- 3
Product mix and recipe costs, January to June · 3 files · 68,892 rows
Open case study04 / 05
How concentrated is our lease-renewal risk?
28 leases worth $85,700 a month all come up for renewal in a single quarter: two-fifths of the rent roll at once.
- 39.9%
- $93,100
- 72.6%
Rent roll and ledger, three properties · 3 files · 1,210 rows
Open case study05 / 05
Who is actually carrying our overtime?
Eleven people worked 37% of the overtime, and seven of them have since left. The cost is concentrated on the people walking out the door.
- 28.8%
- 5.0%
- $574,454
Rota, clock and headcount, July to June · 3 files · 100,459 rows
Open case study
Have something like this sitting in a folder?
Drop it in and see what comes back. You only pay once you like it.