Client Login

Revenue and GP on the Stock Usage Comparison Report

Daisy Lang
12 Jun 2015 3min read

A little while ago we introduced the ability the exclude certain ingredient categories from your GP calculations. This, combined with an ability to exclude certain lead types from having revenue attributed to them, gives you more control than ever over how you see your sales and profits reported on the Stock Usage Comparison Report. However, this has the potential to require some fairly complex calculations and because these figures are critical to your business, we felt them worth unpacking in more detail.

On the Stock Usage Comparison Report, we give you headline actual and theoretical GP figures. Actual is based on physical stock usage as defined by stock checks, theory is based on expected stock usage from your sales.  These figures then get broken down into the various components that have contributed to them.

The PLUs you sell have recipes made up of ingredients, all ingredients sit within a category and all ingredient categories fall under a lead type – most often Food, Wet or Controllables. When you sell a PLU, we assess the sale price and recipe make up to proportionally attribute the sales revenue to each ingredient. This then gets reported at ingredient level, by ingredient category and finally by lead type.

If you choose to define a lead type as not included in this process, then the revenue its ingredients would normally be attributed gets split equally between the other ingredients in the recipe. A use case for this might be to sell a burrito whose recipe includes the food ingredients required to make the product and also the relevant packaging ingredients, e.g. foil wrap, napkin, bag. You’d want the packaging to be in the recipe so the stock usage gets accounted for, but you might not want it being seen to generate revenue when the item is sold.

In this scenario, provided you’d stock checked the packaging category, you’d see zero revenue alongside the Controllables lead type (in which the category sits) on the Stock Usage Comparison Report. All the revenue generated by sales of this item would be attributed to the ingredients in the Food lead type. However, you would still see the cost of the Controllables stock usage, in actual and theoretical terms. The cost of the Controllables stock used also gets factored into your overall GP figures for the period, as they are a cost associated with your sales.

Sometimes you may hold stock that never gets sold to your customers, such as cleaning supplies. The cost of using stock of this type is therefore not associated with sales and is less appropriate to include in GP calculations. In this scenario, you’d mark the relevant ingredient category as excluded from GP calculations, and as a result you get a slightly different view of these categories on the Stock Usage Comparison Report.

For categories excluded from GP calculations, we don’t display any attributed revenue, theory usage or figures relating to theory versus actual. For this reason, if you have ingredients included in recipes, their categories cannot be excluded in this way.


More Posts

31 May 2022 11min read

Finding The Best EPoS System For Your Hospitality Business

Finding the best system for your business can be challenging due to [...]

24 May 2024 7min read

Managing Irregular Hours: What Your Business Needs To Know

Legal changes from 1 January 2024 in the UK specifically address how [...]

02 May 2024 2min read

Stepping Up for Burnt Chefs: Our Virtual Walk Across England

We are partnering with The Burnt Chef Project to raise funds for [...]

Stay updated with the latest news and updates from Kobas.