Restaurant Business Intelligence: Prime Cost, Labor and Menu Mix on Your Phone
The point of sale knows what sold, the scheduling app knows who worked, and the bookkeeper knows what the food cost, but only once a month. Owners need all three on one screen by the next morning.
Restaurant business intelligence means seeing yesterday's sales, food cost and labor together, by location and daypart, without waiting for the monthly P&L. Lightray Solutions, a remote business intelligence consulting firm, builds it in Power BI from the systems you already run, your point of sale, scheduling and accounting, and Edward Pinela, MBA, sets it up himself.
Owners read it in the Power BI app on an iPhone or Android phone. The Google review on this page comes from a restaurant owner whose daily dashboard runs on QuickBooks data, which is a typical starting point.
Setup is quoted at a fixed price after a short discovery; work on an existing Power BI report runs on Power BI Flex Support, from $2,500 for 20 hours, with hours that never expire. Book a free 30-minute strategy call through the form; you hear back within 4 business hours.
“Amazing! Lightray Solutions built us a Power BI dashboard based on my busy restaurant’s quickbooks data that allows me to see my entire business on a daily basis which has been a game-changer! Excellent communication and service!”
— Quinn R., Google review
Which numbers should a restaurant dashboard show?
Six, mostly: prime cost, food cost percentage, labor percentage, sales per labor hour, covers with average check, and menu mix. Together they show whether the restaurant made money yesterday and why. Each has a simple formula, set out in the table, but each depends on first agreeing what counts as sales and what counts as labor; choosing and defining measures like these is the core of our KPI dashboard creation work.
| Measure | How it is calculated | What it tells you |
|---|---|---|
| Prime cost | Cost of goods sold + total labor cost (wages, payroll taxes and benefits) | The two biggest costs a manager controls, in one figure |
| Food cost % | Food cost of goods sold ÷ food sales | Whether portions, waste and menu prices are in line |
| Labor % | Total labor cost ÷ total sales | Whether the schedule fits the business actually done |
| Sales per labor hour | Net sales ÷ hours worked | Productivity by shift and daypart, independent of wage rates |
| Covers and average check | Guests served; net sales ÷ covers | Traffic versus spend, the two halves of any sales change |
| Menu mix | Each item's share of items sold, alongside its contribution margin | Which dishes to promote, reprice or drop |
Where does a restaurant dashboard get its data?
From three places: the point of sale for sales, items and covers; the scheduling or timekeeping system for hours and wages; and the accounting system for purchases and food cost. Most restaurant systems can share that data, but each does it differently, and the route decides how fresh the figures can be and how much setup it takes.
- Toast. Standard API access gives read-only credentials covering orders, labor and menus, for one location or a management group; Toast's documentation notes that requests run location by location.
- Square. The Orders API holds item-level sales, and the Labor API records each worked shift as a timecard, so sales and hours come from one vendor.
- Clover. The REST API exposes a merchant's orders, inventory and payments, along with employee records and shifts.
- Accounting. QuickBooks Online or another ledger supplies purchases and invoices for food cost; weekly inventory counts, if you take them, turn food cost from an estimate into a measured figure (the same stock-and-shrink logic used in retail inventory analytics).
Can owners check it on a phone?
Yes. Microsoft's Power BI mobile apps run on iPhone, iPad and Android, and a report can carry a separate phone layout so the handful of numbers an owner checks before service fit on one screen. Data alerts on dashboard tiles can notify you when a figure moves beyond a limit you set, such as labor going over its target percentage.
How fresh the numbers are depends on the source. Most setups refresh early each morning for the previous day, and some can refresh several times a day for labor checks during long shifts. Food cost is the slowest figure, because it depends on invoices and counts, so it is shown weekly, with the theoretical cost from your recipes beside it if you keep them.
What changes with more than one location?
Mostly the definitions. One model holds every location with the same rules for net sales, comps and labor, so a comparison across sites is fair. Managers can be limited to their own restaurant with row-level security, while the owner sees the group, a ranking of locations and which ones are drifting on prime cost or sales per labor hour.
Hotels and resorts have different questions, such as room revenue and occupancy; those belong on our hospitality BI consulting page.
What does restaurant BI cost?
A dashboard for one location on one point of sale, with sales, labor and food cost, is a small fixed-price project. Several locations, several point-of-sale systems or recipe-level costing make it larger, and the written quote says so before you commit. Later additions run on Flex Support hours at $100 to $125 an hour.
Our Power BI guarantee: if the first 4 hours of working together don't convince you, you get your money back. Edward has 20+ years and 200+ delivered projects behind him, and Lightray's Google rating is 4.9★.
Further reading: Microsoft Learn — What are the Power BI mobile apps?.
Want yesterday's prime cost before today's lunch rush?
Book a free 30-minute call with Edward Pinela, MBA. You get an honest read on what to fix first — and if we are not the right fit, you will hear that on the call.
Frequently asked questions
Our locations use different point-of-sale systems. Is that a problem?
It adds work, but it is common. Each system is mapped to one menu list and one set of definitions, so the same burger is the same item everywhere. Discovery checks what each system can share before anything is quoted.
Is it real-time?
Not usually, and it rarely needs to be. A morning refresh covering yesterday answers most questions, and a few refreshes a day suit labor checks in busy periods. Truly live figures need streaming tools that cost more than most independent restaurants would gain from them.
How long does setup take?
For one location on one point of sale with tidy accounting, a first dashboard usually takes two to four weeks, most of it spent agreeing definitions and checking figures against your POS reports. More locations or systems take longer, and the quote says how much.
What do you need from us?
Admin access or an API credential for the point of sale, access to scheduling and accounting, and twenty minutes a week from the owner or general manager to check drafts against what they know happened on the floor.
You Won’t Get Handed Off to Junior Staff.
At most consulting firms, the senior person who sold you shows up for the kickoff — then you get handed to a team of juniors learning on your dime. That’s not how we work.
When you hire Lightray Solutions, you work directly with Edward Pinela, MBA — a principal consultant with 20+ years of experience across Power BI, web development, SEO, and CRM systems. Edward architects every engagement personally, stays involved through delivery, and answers his own phone.
Read Edward’s Full Bio“Mid-market companies deserve senior-level expertise without paying enterprise-agency prices. That’s the gap Lightray fills.”
Simple. Transparent. Proven.
No black-box processes. No endless discovery phases. A straightforward three-step approach designed to deliver measurable results fast.
Discovery Call
Free 30-minute strategy session where we assess your data landscape, website, marketing — and where AI would genuinely pay off versus where it's hype.
Free · No ObligationCustom Roadmap
You receive a tailored plan with clear deliverables, realistic timelines, and expected ROI. You approve every detail before we start.
Fixed Scope · Clear PricingMeasurable Results
We execute, measure, and optimize. You get dashboards, regular check-ins, and full visibility — so you always know the impact.
Data-Driven · TransparentGet a clear plan in one free call.
Tell us what you are trying to fix. Your request goes to Edward Pinela, MBA — the principal consultant who would do the work — and you hear back within 4 business hours.
Prefer to call? +1 (714) 872-9606