Hotel Inventory Stock Variance Form
Use this form to compare theoretical inventory against counted stock for housekeeping, minibar, kitchen, laundry, spa, or maintenance items.
Formula Used
Available Stock = Opening Stock + Purchases + Transfers In + Internal Returns In
Expected Usage = Theoretical Usage + Complimentary Usage + Wastage
Expected Closing = Available Stock − Expected Usage − Transfers Out − Returns to Supplier
Actual Usage = Available Stock − Actual Closing − Transfers Out − Returns to Supplier
Closing Variance = Actual Closing − Expected Closing
Usage Variance = Actual Usage − Expected Usage
Cost Variance = Closing Variance × Unit Cost
Inventory Accuracy = 100 − (|Closing Variance| ÷ |Expected Closing| × 100)
How to Use This Calculator
- Enter the stock item, department, and reporting period.
- Add opening stock, purchases, transfers, and internal returns.
- Enter planned usage, complimentary issues, and wastage.
- Enter the physical closing count after stocktake.
- Add unit cost, selling price, par stock, and occupied rooms if available.
- Press Calculate Stock Variance to view the result summary.
- Review the variance table and Plotly graph for operational insight.
- Use the CSV or PDF buttons to save the result for audit or reporting.
Example Data Table
This sample matches the quick example loaded by the button.
| Field | Example Value |
|---|---|
| Item Name | Bath Towels |
| Department | Housekeeping |
| Period | March 2026 |
| Opening Stock | 320 |
| Purchases Received | 140 |
| Transfers In | 20 |
| Internal Returns In | 10 |
| Transfers Out | 25 |
| Returns to Supplier | 5 |
| Theoretical Usage | 210 |
| Complimentary Usage | 12 |
| Wastage / Damage | 8 |
| Actual Closing Count | 210 |
| Unit Cost | 4.50 |
| Selling Price per Unit | 8.00 |
| Par Stock Target | 240 |
| Occupied Rooms | 185 |
Frequently Asked Questions
1) What does stock variance mean in a hotel?
Stock variance is the gap between expected inventory and physically counted inventory. It helps hotels identify shortages, surpluses, posting delays, wastage, or possible control weaknesses.
2) Why are transfers included in the formula?
Hotels often move items between stores, kitchens, floors, laundries, or outlets. Ignoring transfers can create false shortages or surpluses, even when the physical stock is actually correct.
3) What is theoretical usage?
Theoretical usage is the quantity your system expects to consume based on issues, recipes, room setup standards, minibar replenishment rules, or operating procedures during the selected period.
4) What does a negative closing variance show?
A negative closing variance means the actual closing count is lower than expected. This usually signals stock loss, unrecorded usage, damage, theft, counting mistakes, or delayed transaction entry.
5) How should I use par stock with variance results?
Par stock gives you a target safety level. After checking variance, compare actual closing to par stock to see whether you need replenishment or whether your outlet still holds enough inventory.
6) Why measure usage per occupied room?
Usage per occupied room helps normalize consumption by hotel activity. It lets managers compare linen, amenities, minibar items, or supplies across periods with different occupancy levels.
7) Can this calculator be used for housekeeping and minibar items?
Yes. It works for housekeeping supplies, minibar stock, kitchen ingredients, laundry items, spa consumables, and many other hotel inventory categories that rely on count-based control.
8) When should stock variance be reviewed?
Review variance daily for high-risk items and at least weekly or monthly for slower-moving stock. Frequent review helps prevent leakage and improves purchasing, usage control, and audit readiness.