The typical starting point
Each location sends a weekly stock and sales summary that head office compiles by hand. Food cost is calculated at month-end, waste is not recorded and plate costs vary between locations.
How I would build it
I would build one workbook with a simple daily input sheet per location, a Power Query pipeline that consolidates every location, and a Power Pivot model that calculates food cost %, prime cost and waste per location. A dashboard with location and date slicers gives operations a daily view, and a recipe costing template standardises plate cost across the chain.
What it is designed to deliver
Operations can see each location's food cost daily, spot waste early and hold location managers to one consistent standard.
