For FnB Live, we need to do an analysis of beverage recipes and products in the system and need advice on what reports can provide information around this

Follow

Caroline Bethell

February 06, 2020 00:00

We would like to know: - how many beverage recipes are currently live and in use in the system (Last 12 months) - total sales for all recipes - a breakdown of the number of recipes items by category? - total number of beverage products that are live and set up in FnB

0

• 

  Paul Mortensen February 06, 2020 00:00

  Hi @Caroline Bethell​ 

  1. You can run the 'Sales Mix Analysis' report (Enterprise > Reports > Analysis > Sales Mix Analysis). However, if you have a large volume of sites and recipes, then the report may not generate over a time frame as large as 12 months, and you may need to run the report in batches.
  2. The above report should also be able to give you this information
  3. With the same report you can group by menu group (aka category) and use excel to show how many menu items exist in each group
  4. There is not a report that wil highlight products in use, but there are many that will highlight those that are not:

  Enterprise > Reports > Organisation > Products with no Activity

  Enterprise > Reports > Organisation >Site Products not used in Menu Items or Batches

   

  Many thanks

  Paul Mortensen - Senior Solution Consultant P2P&I Restaurants

  0

  Comment actions Permalink
• 

  Caroline Bethell February 06, 2020 00:00

  Thanks Paul 😊

  0

  Comment actions Permalink

Please sign in to leave a comment.