Now that BBS is utilising the ‘Weekly Usage’ on a product code more and more for things like the ‘! SLOW STOCK !’ notations, we felt it important to update the algorithm to make it more accurate.

 

Previously, BBS created a weighted average weekly usage based on 12 months of sales/transfer/build history, excluding the current month as you cannot average a month that is incomplete. While this worked well, what it did mean is that the weekly usage figure would not change throughout the month. Now with the ‘! SLOW STOCK !’ notations relying on the weekly usage, this could mean a product could show as slow moving for an entire month even if you have started selling it again.

 

We have updated the algorithm to calculate the weighted average weekly usage each night, based on 12x30 day blocks (including the day that has just completed). This means that the weekly usage figures will update each day, and include the most current sales in the calculation making the figure more accurate for its intended purpose.