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 assume you are starting with 0 on hand. 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 on the day before your report date (i.e., the close of the previous period), then we’ll calculate the on-hand for you.
Same with the last date of the report. If we don’t find a count on that date, then we’ll calculate the on-hand for you.
Ideally, you want to have counts at each end of the report, so we are reporting actual usage based on your *actual* levels, not the levels we assume based on your inventory fluctuations.
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.