Purchasing & Inventory
Actual vs Theoretical Variance Percentage Calculator
Calculate actual vs theoretical variance percentage for hotel and restaurant operations.
Purchase Price Variance Calculator
Use this tool to review purchase price variance with a consistent period, denominator, and operating rule.
- No login required
- Save in this browser
- Optional account sync
- Built for hotel operators
Formula
How this calculator works
This formula converts source operating values into purchase price variance for quick review.
PPV = (Actual Unit Price − Standard Unit Price) × Actual Quantity Purchased
Context
Why this metric matters
Useful for vendor negotiation and inflation tracking. Split favorable vs unfavorable and track by key SKU.
Hotel insight
Industry context
- Useful for vendor negotiation and inflation tracking. Split favorable vs unfavorable and track by key SKU.
- Small changes in denominator rules can move the result, so keep the same reporting basis when comparing periods.
Operational notes
Before you act on the number
- ($3.20 − $3.00) × 1,000 = $200 unfavorable
- Confirm whether internal-use, complimentary, adjustment, or excluded activity should be included before comparing periods.
- Use this result as an operating guide and review it with the supporting business context.