While these two metrics are similar, they are calculated a little differently. Here's a breakdown of how these two values are calculated:
The Variance Quantity on the Inventory Review screen displays the difference between the amount of Product physically counted for the Period to the Book quantity.
Variance Quantity = Physical + In Transit - Book
The Approximate Units on the Actual vs Theoretical report attempts to convert the Value Variance on the AvT report to a Quantity based on the current Unit Price of the Product.
Approx. Units (rounded to whole number) = Variance Value / Unit Price
Since the Unit Cost changes over time, the Approximate Unit estimation can vary from the true Variance Quantity seen on the Inventory Review screen.
Comments
0 comments
Please sign in to leave a comment.