⚠Sample data shown. Once data sources are connected (PowerBI, Dayforce, Google, ServiceCheck, Jolt), this dashboard will update daily at 10:00 AM.
Guest Check Average by Store
Prior business date
Labor % by Store
Target varies by store volume
Change % vs Prior Year
YoY net sales comp by store
Google Ratings by Store
Current average rating (out of 5.0)
✓Live data from ServiceCheck Insights. Updated daily at 10:00 AM MT.
Contact Method
How customers reached out
Category Breakdown
Type of contact received
Business Segment
Where contacts originated
Retention Status
Open vs closed contacts
Top Problem Issues
Most common problem categories this week
Issue Category
Count
Impact
Problem SCs by Store
Current week problem service check count
Week-over-Week Trend
Total problem SCs -- last 4 weeks
Executive Summary
ServiceCheck contacts overview (rolling period)
Monthly Contact Trend
Top Problems
Fulfillment & Compensations
Customer compensations issued
Store
Incident #
Reported
Type
Category
Amount
✓Live data from QBO P&L & PLV Reports. Real PLV data for stores 726, 898, 1205, 1364. PLV reports found for 1029, 1056, 1153, 1357, 1391 (pending extraction). Missing: 1187.
Mitigation & Discounts
Manager Meals, Employee Meals, and other discount categories
Category
Store
Count
$ Amount
% of Sales
High Variance Items
Items with >1% variance from theory -- sorted by dollar impact
Item
Store
Theory Cost
Actual Cost
$ Variance
% Variance
Impact
Food Cost % Variance Heatmap
Theory vs Actual by store -- darker = higher variance
Food Cost Trend
Weekly food cost % -- all stores
✓Live data from QuickBooks — Patel DT LLC. Last updated: Jul 2026.
Monthly Net Sales Trend
Portfolio net sales by month
Monthly NOI Trend
Net Operating Income by month
Food Cost % Trend
Monthly food cost as % of sales — 30% threshold
Labor Cost % Trend
Monthly payroll as % of sales — 37% threshold
Controllable Expenses Breakdown
Share of controllable costs — YTD
Key Expense Ratios
Food, Payroll, Utilities as % of sales — monthly trend