Sample result
Financial Dashboard Builder for Restaurants
The owner asked this:«I want the financial board for my two locations. We sell 214 million a month, but in January and February the cash always suffers and I never know how much I can take.»
① Block A · the financial dictionary (5 of 12)
Every indicator with its real source. Whatever lacks one today comes in flagged, not estimated.
| Indicator | Formula | Source | Frequency | Owner | Target or ceiling |
|---|---|---|---|---|---|
| Operating margin | (Sales − costs − expenses) / sales | Monthly P&L | Monthly | Owner | Declared target 14% (today 8%) |
| Real food cost | Period consumption / food sales | Inventory close | Weekly | Head chef | Ceiling declared by the house (today 34%) |
| Labor cost | Full payroll with charges / sales | Payroll + POS | Monthly | Manager | Ceiling declared by the house (today 28%) |
| Cash available | Banks + cash − checks issued | Banks + till count | Weekly | Manager | Floor: 1.5 payrolls |
| Break-even | Fixed costs / the month's contribution margin | P&L + costed menu | Monthly | Owner | Recalculated at every close |
Today's weakest datum: weekly consumption is estimated from memory. With no Friday inventory count, the board's food cost is an opinion with two decimals.
SUPUESTO: the two ceilings above are the ones this house declared, not a sector average. If the real food cost ceiling were 2 points higher, the kitchen's light turns from red to amber and the month's first decision stops being purchasing.
② Block B · the finanzas.html file, read on a Friday
One screen, three blocks. Top: the month's P&L against the previous one — sales 214.0 M (+3.1%), food cost 34% in amber against the declared ceiling, labor cost 28% in green, operating margin 8% in amber with the 14% target marked.
Middle: the cash matrix, one column per week across 8 weeks:
| W1 | W2 | W3 | W4 | W5 | W6 | W7 | W8 | |
|---|---|---|---|---|---|---|---|---|
| Inflows | 51.4 | 49.8 | 52.1 | 53.0 | 38.2 | 36.9 | 41.0 | 44.3 |
| Outflows | 47.2 | 61.5 | 45.8 | 63.1 | 46.0 | 60.4 | 44.7 | 58.9 |
| Balance | 🟢 | 🟡 | 🟢 | 🟡 | 🟡 | 🔴 −9.4 | 🟡 | 🟡 |
The high outflows land on payroll weeks (15th and 30th) and rent (the 5th); inflows in weeks 5 and 6 drop with the January seasonality the owner declared. Week 6 needs 18 M set aside before December 31 to be crossed without a panic loan.
Bottom: the month's break-even — 171 M in sales, that is 3.9 M a day, about 81 covers a day at the 48,000 average ticket, and the current safety margin: 20%.
The full example has 1 more part(s): you see them inside the library, with your account.