Examples
Operations examples
Scheduling and stock: the day-to-day mechanics of a place, and what they cost when they slip.
- In this subject
- 5 of 11
- Subject
- Operations
- Every one opens
- in full
Featured project
Sales & stock · 94,154 rows
$128,000 of stock had not sold in nine months, and half was bought to reach a supplier discount.
Stock and sales: 12 months · 4 files, opened in full: the finding, the number behind it, and the trace.
Which stock is tying up cash?Stock value
$412,000
Not sold in 9 months
31.0%
SKUs below zero
214
Rows analysed
94,154
Customers · 26,066 rows
The 22.4% rate combined three different events; the unrecovered no-show rate was 11.4%.
Why is our no-show rate 22%?
11.4%Unrecovered no-shows
Money · 68,892 rows
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.
Is the menu as profitable as the recipe cards say?
64.5%Contribution margin
Cash flow & budgets · 1,210 rows
28 leases worth $85,700 a month all come up for renewal in a single quarter: two-fifths of the rent roll at once.
How concentrated is our lease-renewal risk?
39.9%Rent expiring in one quarter
People & teams · 100,459 rows
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.
Who is actually carrying our overtime?
28.8%Attrition
A project can answer more than one kind of question, so these also appear under other subjects. See all 11.