Calculating Sales Value

The sales value is distributed as a % of the Cost of the Menu item
The Sales Mix Report by product will show the breakdown of the sales per product

Fig 1 - Menu Item Ingredients

Sales are always distributed at a Net Sales value. In Fig 1 above the Sales price is £3.55. The VAT value is set as (S) for standard and 20% VAT applies
- £3.55/1.20 = £2.958
The Net sales value if 1 item is sold of the PLU will be £2.958. Once the Net sales value is determined, the sales distribution can be calculated
Assuming 10 items of the above PLU are sold the Gross Sales value would be £35.50.
This would calculate to a Net Sales value of £29.58 (£35.50/1.20 = £29.58)
The sales value is distributed as a % of the Cost of an ingredient within Menu item
Take the net sales value of the PLU and work out the % per ingredient in the menu item
Example above shows Bacon has a 23.39% distribution of the overall cost. £29.58 (net sales value) / 100 * 23.39% (% Cost) = £6.91
This means that the sales value for the bacon based on £29.58 worth of sales will be £6.91
The table below works out the distribution for the entire menu item

Fig.2 - Distribution for an entire menu item

Please Note:

When calculating the values manually there may be a variance of up to 5p items however this is due to the amount of decimal places FnB calculates to
Where the item in the menu is a recipe the distribution of that recipe would need to be calculated separately
For recipe CYO cheddar take the calculated sales value of £1.70 and then use this value to work out the distribution of the items within the recipe

To distribute the sales quantity of a product take the total sales quantity of the menu item and work out the quantity sold within an individual menu item
For example, Bacon with the sales quantity of 10 would mean that 200g had been sold (10*20g). The product base UOM is 1kg
- Bacon Quanity Sold = (total quantity sold of bacon) / (UOM of product)
- 200g / 1000g = 0.2

There can be a difference in the sales quantity between the Sales Mix reports and the Stock Reconciliation POS sales this can be due to the Yield of a product
Yield on the sales only applies to the stock recon POS figures not the quantity figures on the sales mix reports
If a product has a yield cost you add the value of the yield onto the sales quantity. You do this by dividing the sales quantity by the yield%
For example if a 20 Salmon were sold and the salmon had a yield of 80%, then add the yield onto the sales
- 20/0.80 would give a sales quantity of 25