How to Isolate Variance Before It Compounds
This guide explains inventory tracking, its restaurant use-cases, the variance math, and the exact workflow inside RCS.
Inventory Tracking and Variance Control: Catch Losses Before They Compound
Inventory tracking adds a live control layer on top of periodic counts. It compares theoretical and actual values so operators can isolate waste, process misses, and shrink in near real time.
What Inventory Tracking Is
Inventory tracking is the ongoing process of posting beginning snapshots, purchase events, usage events, and actual count snapshots into a ledger so on-hand value can be compared against expected values.
In RCS, the tracking workflow uses PMix-driven usage and inventory ledger events to calculate theoretical on-hand and quantify variance by period.
What Inventory Tracking Is Used for in Restaurants
- Identify unexplained inventory loss earlier than monthly close.
- Separate purchasing issues from production or service execution issues.
- Validate whether menu mix and recipe usage assumptions match reality.
- Focus coaching on stations or categories with persistent variance.
- Build confidence in food cost reporting at both store and enterprise levels.
How to Calculate Inventory Tracking Metrics
The key value is the gap between expected inventory and counted inventory.
1
Theoretical Usage Value
abs(Sum(Usage Ledger Value Delta))
What your recipes say you should have used, based on sales data alone — the perfect-world baseline.
2
Theoretical On Hand Value
Beginning Value + Purchases Value − Theoretical Usage Value
What your inventory should be worth if your kitchen ran perfectly — zero waste, zero theft, zero portioning error.
3
Variance Value
Actual Count Value − Theoretical On Hand Value
The gap between theory and reality. Negative variance means you're losing more than recipes predict — investigate waste, theft, or portioning.
PMix usage quality depends on accurate menu recipe definitions. If recipe mappings are incomplete, theoretical usage may understate true consumption.
Tutorial: How to Use Inventory Tracking in Restaurant Core Systems
Inventory Tracking tab -> Post Beginning Snapshot -> Post Actual Count -> Run PMix Usage
- Open Operations -> Inventory and select the target inventory run.
- Switch to the Inventory Tracking tab inside the run.
- Click Post Beginning Snapshot to seed the ledger from your prior completed run.
- Click Post Actual Count to write current counted values into the ledger.
- Run PMix Usage to post theoretical usage events for the run date range.
- Use Refresh Summary and review Beginning, Purchases, Theoretical Usage, Theoretical On Hand, Actual Count, and Variance.
- Investigate large variance categories first, then adjust ordering, prep controls, or receiving workflows.
Recommended cadence: refresh tracking after each major receiving day and again during end-of-week close. This helps reduce compounding variances before they affect margin reporting.