Franchise DashboardPatel DT LLC • Group 373

Last updated: --
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 CategoryCountImpact

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

StoreIncident #ReportedTypeCategoryAmount
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

CategoryStoreCount$ Amount% of Sales

High Variance Items

Items with >1% variance from theory -- sorted by dollar impact

ItemStoreTheory CostActual Cost$ Variance% VarianceImpact

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

Store P&L Comparison

YTD NOI % by store — ranked