Create the sales forecast for how much of each category for next quarter.
Now that we have a ballpark topline number, we can simply use the percentage of total sales from the same quarter last year to determine how much we expect to sell in the next quarter.
The result should look like:
This says, next quarter we should expect 31.8K in beverage sales, 23.2K in Condiments, etc.
The expert performance time for this task is 1 minute. This assumes you already have the quarterly sales data and overall forecast in place in excel.