On the Inventory Review screen, you are comparing the Actual Value (from Inventory Counts) to the Book Value (Begin + Received – Sold – Adjusted). This tells you how much variance there is between what is physically on hand vs what the system thinks you should have. This calculated as follows:
- Variance $ = [ Physical Value + In Transit Value – Book Value ]
Note: The Cumulative Variance Value will be the sum of all variances for each included post period; this includes mid-period variances (which also appear in the "Adjusted" column).
On the Actual vs. Theoretical Cost Report, you are comparing what is actually counted on Inventory to what is rung in on your POS (via Menu Mix). This value gives you insight into how much variance there is between how much product you should have used to complete orders vs what you actually used throughout the period. This is calculated as follows:
- Actual Value = [ Beginning + Purchases + Production - Transfers Out – Production Consumption Reversal – Ending ]
- Theoretical Value – Total cost of recipe components and "A/T Cost Item" recipes sold through the POS interface or via Commissary/Customer Order.
- Variance Value = [ Theoretical Value – Actual Value ]
Since these variances represent slightly different metrics, and are calculated differently, the only time they would match is by coincidence.
Comments
0 comments
Please sign in to leave a comment.