If your intake is not processed at the correct date and time, it can lead to faulty consumption data. To have a complete understanding of the its impact, you only need to know two things:
- Your consumption between two inventory sessions is calculated as follows:
Consumption = Total Bottles (Beginning) + Bottles Received - Total Bottles (End)
- WISK uses the date/time that inventory was started for all calculation purposes
Wrong Intake Date
If an intake is processed at the wrong date, it may not fall into the correct inventory period. It is very important that the intake be sandwiched between the right dates so that the Consumption calculation above contains the correct values.
Wrong Intake Time
The same issue can arise when processing an intake on the same date as an inventory session.
Since WISK uses the inventory's Start Time to determine when it occurred, it will make a difference whether the intake is processed before or after the inventory has begun.
For these instances, we recommend leaving your received stock to the side, doing your inventory (while excluding these new bottles), then processing the intake after the inventory has been completed.
Let's say for a given week, you start off with 10 bottles, receive 6 bottles, then end up with 9 bottles the next time you take inventory. Based on the above Consumption calculation, you should have consumed 7 bottles.
10 (beginning) + 6 (received) - 9 (ending) = 7 bottles consumed
If your intake of 6 bottles was processed at the incorrect time (at a date/time outside of the inventory period), the consumption calculation for the period will look like this:
10 (beginning) + 0 (received) - 9 (ending) = 1 bottle consumed
The resulting consumption will be too low for the period that was supposed to contain this intake and it will be too high for the period that now mistakingly contains this intake.
Whenever you see Negative Consumption in your reports, it is either due to miscounts, or due to situations with faulty intakes.
If you take the same example as above, but start off with 7 bottles instead, look what happens to your consumption when an intake is not processed correctly:
7 (beginning) + 6 (received) - 9 (ending) = 4 bottles consumed
7 (beginning) + 0 (received) - 9 (ending) = -2 bottles consumed