Restaurant Technology Solutions

P&L visibility module concept

Restaurant Financial Performance Dashboard

Modeled 2024 calendar-year view for five McAlister's stores, anchored to historical P&L files with missing periods reasonably modeled for demo continuity.

McAlister's Multi-Store GroupFull Year 2024

Modeled data, built from P&L anchors. Not accounting output.

Portfolio Analytics Explorer

Compare stores, categories, trends, outliers, and full P&Ls without opening spreadsheets.

Uses the existing modeled store P&L data already loaded into this dashboard.

Total Sales$13,699,999Entire portfolio ยท 5 stores
Total EBITDA$1,164,8808.5% margin
Average Labor %29.8%Weighted by sales
Average Food Cost %26.2%COGS / sales
Prime Cost %56.0%COGS + labor
Average Net Income$836,0836.1% margin

Labor multi-store trend

Hover-ready executive comparison with store toggles, company average, and target benchmark.

36.0%34.0%32.0%30.0%28.0%26.0%
JanFebMarAprMayJunJulAugSepOctNovDec
Speedway29.0%Range 28.2% - 31.6%Greenwood27.9%Range 27.5% - 27.9%Park Meridian34.4%Range 31.6% - 34.4%Cool Creek29.6%Range 28.4% - 31.4%Hamilton TC30.7%Range 29.6% - 31.9%

Variance explainer

Park Meridian EBITDA up $2,200 vs prior month.

Sales+$31,667
Labor-$11,373
Repairs+$500
Utilities-$684
Marketing-$532
Net change: +$2,200

Executive insights

Automatically generated from existing portfolio trends.

Park Meridian has exceeded group labor targets across the recent quarter.

Greenwood has the strongest EBITDA trend over the last quarter.

Greenwood maintains the lowest controllable expenses in the portfolio.

Repairs increased significantly in March and April across Park Meridian and Cool Creek.

Food cost variance has narrowed over the last six months as COGS stabilized in most locations.

Net Sales$13,699,999-$134,261 vs budget
Prime Cost56.0%26.2% COGS + 29.8% labor
EBITDA$1,164,8808.5% margin
Prior Year$483,8403.7% sales growth

Sales, Budget, Prior Year

Monthly 2024 model
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Actual/modelBudgetPrior year

Cost Structure

Percent of sales
COGS26.2%
Labor29.8%
Packaging4.2%
Controllables15.0%
EBITDA8.5%

Store Ranking

Sorted by EBITDA margin
StoreSalesPrimeEBITDAVs Budget
GreenwoodGW1273$3.0M52.3%17.9%-$29.4K
Cool CreekCC 1364$2.7M54.8%11.5%-$26.5K
SpeedwaySPDWY$2.5M55.4%5.9%-$24.5K
Hamilton TCHTC1304$3.5M58.0%5.4%-$34.3K
Park MeridianPM 1275$2.0M60.5%-0.9%-$19.6K

Attention Signals

P&L exceptions
Prime cost watch

Park Meridian and Hamilton TC trend above the group target, mostly from labor pressure.

COGS variance

Hamilton TC modeled COGS runs above the group average, matching older P&L pressure patterns.

Budget discipline

Speedway and Greenwood remain the strongest stores for budget comparison and margin.

Source Coverage

Historical files used as anchors
SPDWY: PD 1, 2, 3, 10, 11, 12, 13 workbooksGW1273: late 2021 + 2022 P&LsPM 1275: 2022 P&Ls and trial balance PDFsCC 1364: 2018 P&LsHTC1304: 2017-2018 P&Ls and profit review

Modeling Notes

2024 demo construction

Store-level 2024 values were modeled from observed P&L line structure: total sales, food and beverage mix, COGS, packaging, labor, controllables, budget columns, and prior-year columns.

Stores with partial or older files were normalized into a full calendar-year demo so the module can show trends and multi-store comparison.