Rate of Sale report

Ideas & feature requests
1

We’ve had a few requests previously for a ‘Rate of Sale’ report, but none have officially been logged on our feature request board. It would be great to hear what Breww users would like from a report like this, so please add your votes and comments!

1 Like
Beer sales report by batch and package
How quickly batches of beer are selling out
2

Absolutely ! One feature I’d like to see is ROS by customer by product/container type (Queens Head - 2 casks per week over the last 2 months) and a report when someone drops below (last week didn’t take any) - this would give sales team members a list of accounts that need some extra care.

From an ops side, I’d like to see the ROS report (or rate of production, rate of consumption etc…) of all SKUs used to then calculate raw material consumption - ie ROS of current SKUs leads to demand of 10k bottles per month over all bottled SKU forecasts, forecast to increasing/decreasing at X% etc. This would help with longer term planning (ie bottle contracts for the year).

Similarly for leased Casks - ROS report would feed into an ordering schedule to Kegstar - 2 pallets a week, increasing to 3 etc.

Cheers

2 Likes
3

I’d like to be able to look at a product type, e.g. Blonde 9G Cask or Cascade 500ml bottle, and be able to look at the rate of sale per week over the last 8 weeks in order to work out an average per week and when I’d need to rebrew before stocks run out. Also to then do a similar process with historical data so look at the same period for a previous year to try predict peaks and troughs.

1 Like
4

Thanks for voting for this request, @ben-pearson.

Regarding:

I just wanted to point out the feature - Beer stock availability forecasting 📊 tool now available - in case you hadn’t seen it, as this is pretty much exactly what this does. It doesn’t (yet) let you look at the same period in previous years for seasonality, however, but that would be a great addition and probably warrants it’s own feature request :+1:

5

Having the ability to quickly see how fast a batch or product of beer sells out is crucial for understanding what sells best and when it’s best to brew certain beers throughout the year.

Currently, I use the log tab at the bottom of the product pages, but this process is quite time-consuming.

A pre-built report would be ideal, or perhaps adjusting the layout of the log tab for easier consumption.

Can this process be improved?

Cheers

JP

1 Like
6

Is the ‘Stock Availability Forecast Report’ not what you are looking for?

Products > Tools & Reports > Stock Availability Forecast Report

7

Continuing the discussion from How quickly batches of beer are selling out:

I made a similar request here: Automatically suggest/plan what to brew, what to package and when to do it based on forecasted available stock - #4 by luke. We have worked with a demand planning and process improvement consultant to do this. We export our sales data every week into a forecasting spreadsheet, then export the currently inventory position of all our products. The spreadsheet then computes a “days on hand” inventory and offers suggested start dates to brew the next batch. We’re now over a 95% fill rate on orders. I’ve asked to see this integrated into Breww but it doesn’t seem to be receiving enough “Up” votes to get any attention. The other thing we added is a capability to determine the correct racking (cases of cans/bottles, sixtels and half-barrels for us) so that we balance our inventory to basically run out all at the same time. it’s taken a lot of the guesswork out of our operation, as our brewer takes the recommendations and stuffs them right back into Breww for the planning cycles. And wherever we have gaps he schedules collabs or one-off special releases, ensuring supply of our core products. We’re currently tracking 15 products this way and it takes less than 30 minutes a week.

1 Like
8

Thanks Langers,

The ‘Stock Availability Forecast Report’ is useful but it not quite what we are after. This only forecasts future stock levels based on planned packaging and previous batches quantities. We want to see how quickly stock depletes in which format, to which customers and at what time of the year which beer sells the best.

That way you would be able to have clear 1 years overview of your brewing schedule and how that directly reflects sales

Cheers

1 Like
9

Thanks John. The Stock Availability Forecast report does also attempt to forecast future sales to predict future stock levels.

Can you give more information on what exactly you would like to see in your report (e.g. an example table/Excel file)? We want to make sure that what we’re building does what you actually need. Thank you.

11

Hi Luke,

I’ve attached an image which will hopefully make it a bit more clear.

Ive kept the beer names to generic styles*

Rate of sale
Rate of sale1920×1459 124 KB

1 Like
12

Thanks John, this is really useful :+1:

13

Any update on this Luke?

Looking forward towards 2025, this information is becoming more and more important to us when scheduling next years brewing.

Cheers

JP

1 Like
14

I’m sorry, but there’s no update to report on this yet. We’ve been busy working on other requests, but do hope to get to this in the future. Please make sure you have voted for it (if you haven’t already).

Please see How do I know if there’s been an update on a feature request?

Thank you :smile:

15

I just wanted to highlight here a recently launched new feature for greatly improved sales forecasting in Breww. I know this isn’t quite the Rate of Sale report that’s been asked for, but as there is quite a bit of overlap, I wanted to mention it here for people looking at this thread.

I’m also going to merge this with a similar thread to ensure all the votes stay in one place. Thanks.