In this example, we’ll see how a missed delivery makes an impact on your variance.
Looking at this Coors Light, it shows we sold 50 cans, but only consumed 2. While this looks like a dream come true, it is in fact a data error.
If we click on the details button, we can get more information:
When we look at the Sold / Consumed tab, we see we started with 60 bottles, received no deliveries, and ended with 58 bottles. This puts our consumption at 2 bottles.
If we go to the Item Inventory / Deliveries tab, we see that there is no history of intakes for this item.
In this example, let's say we received two cases of 24 cans earlier in the week, but forgot to enter it in WISK. To fix the consumption, we must add this delivery into the system. You can add a manual delivery in the app, or on the Web Portal, go to Deliveries > Actions > New Delivery.
Now that we have added our delivery of 2 cases of 24 units (for a total of 48), we can go back to the Item Inventory / Deliveries tab:
The delivery now appears, but you can see that when we entered the delivery, we forgot to backdate it. Even though we have added it into the system, it is not applying to the most recent inventory period between Apr 2 3:59pm and Apr 9th 4:13pm.
We need to go back into that delivery, and edit the time to reflect when it was put into stock. In the web, just click the date and adjust the time:
With the time changed, you’ll now see that the intakes fall in between the two most recent inventories.
When we go back to the Variance page, we’ll now see that the Consumption and Sales match, and there is no longer a variance.