Calculating Actual usage is essential for proper management of your operation. It answer this question: what did it cost me to run my operation during this period. You may think it’s just your invoices, but that doesn’t tell you what you’ve used; only what you’ve purchased.
Here’s the calculation: Opening level + purchases – closing level.
If we find actual counts, we’ll use them. That makes it more accurate, so we suggest counting routinely, and running this report around those count dates.
But if there isn’t an opening count, we’ll create an opening level based on your counts and other transactions. Same with the closing level.
We’ll look for a count starting the day *before* the report date, and up to the report closing date. If we don’t find a count, we’ll calculate the on-hand for you.
Usage is calculated by product, then presented by item. That’s why you’ll see dollar amounts, but not units, since the dollar amount may represent different packs of different products.
Click here to learn more about how to sort and filter the results to provide the exact results you want.