FnB Live: How to: Calculate Sales Distribution for Batches

Calculating of Sales Quantity

To calculate quantity sold for a batch determine the quantity sold of each recipe the batch is used in.
 

Fig 1 - Batch Item

• In Fig 2 below, the batch Mustard Mayo is used in 3 Menu Items.
  • PLU 1 > 25g of the batch being used.
  • PLU 2 > 25g of the batch being used.
  • PLU 3 > 25g of the batch being used.

Fig 2 - Recipe Usage Tab

• If, for example there are sales of 10 against each menu item then total PLU quantity of the batch sold per menu item are as follows:
  • PLU 1: 10 sold which is the the equivalent 250g of the batch being sold.
  • PLU 2: 10 sold which is the the equivalent 250g of the batch being sold.
  • PLU 3: 10 sold which is the the equivalent 250g of the batch being sold.
• A total of 750g of the batch has been sold.
• The UOM of the batch is 100g.
• Batch Quantity Sold = 750g/100g = 7.5.
• 7.5 multiplied by the ingredients in the batch gives the sales quantity per ingredient in the batch.
  • Mayo - Low Fat: 7.5 * 50ml = 3750ml.
  • The UOM of Mayo - Low Fat is 10L
  • Quantity Sold = 375ml/ 10,000ml = 0.0375
  • Mustard wholegrain: 7.5 * 50g = 375g
  • The UOM of "Mustard wholegrain" is stocked as a UOM of 2kg.
  • Quanity Sold = 375g/2,000g = 0.187 or 0.19 rounded to two decimal places.

Also See

• FnB Live - Calculating Sales Distribution
• Inventory | Restaurants - Creating Batches in Master Data
• Inventory | Restaurants - Publishing a Recipe to the Stock System