Beverage Ratios Report

1. Open the Back Office.
2. Click the Reports icon.
3. Click Beverage Ratios.
   
4. When the Beverage Ratios Report window appears, configure your report settings:
• Select a report Start Date and End Date.
• Enter a report Start Time and End Time.
• Beverage Department Masks specify the departments to show. Users can enter up to five department masks. Department masks can be configured in Department Maintenance. This is intended for drink-only restaurants.
• No-Beverage Item Mask includes "No-Beverage" items. This field must be used by a "No-Beverage" item. For a restaurant selling both food and beverages, use the User Defined Beverage Ratios to Report section to input food masks. This is intended for drink-only restaurants.
• Water Item Mask includes "Water" items. Users must configure a water item in Item Maintenance. This is intended for drink-only restaurants.
• Configure User Defined Beverage Ratios to Report:
  • Column Description specifies the column name that will be used on the report. For example, Alcohol.
  • Beverage Dept. Mask specify the departments that will be included in the column specified. For example, all alcoholic beverages by department. For our dataset we would enter 2* to specify all departments beginning with a two. These values will vary based on department settings configured in Department Maintenance. This section is an exception to the No-Beverage Item Mask and Water Item Mask. The Beverage Dept. Mask section relies on items being identified in those sections to do a comparison.
• Select the Employees you would like to view from the listbox OR click the Select/De-Select All Emp's button to select or de-select all employees.
  • Select the Include Inactive check box to include employees that are configured as inactive in Employee Maintenance.
5. When you have finished configuring your report settings, click the Run Report button. The Beverage Ratios Report Preview window will appear.
   

Beverage Ratios Summary

Displays a ratio of beverages sold to the customer count. Users can also view the ratio of items purchased with no beverage, water, and user specified beverage columns. Users can specify and custom label beverages they would like shown as individual columns when entering their report settings.

Name: The name of the employee who sold the beverages.

Guests: The customer count by employee. This value is based on the number of seats assigned to each check or the customer count entered on the Front End, depending on your settings. 

Edit Section Info > Force Entry of Customer Count will prompt the user to input the customer count on the Front End. This option can also be configured to automatically add the specified number of seats to the sale.

Edit Section Info > Track Customers by Seat will adjust the customer count when a seat is added to or removed from the sale on the Front End.

Settings 1 > Adjust Customer Number when adding removing seats automatically adjusts the customer count when seats are added to the sale or removed from the sale.

Bev %: The ratio of beverages sold to the customer count by employee.

Water %: The ratio of water sold to the customer count by employee. Users will need to configure a "Water" item in Item Maintenance.

No Bev %: The ratio of no-beverages sold to the customer count by employee. Users will need to configure a No Beverage item in Item Maintenance.

Totals: The total number of guests and total ratio of beverages sold to the customer count for all employees.

Users can configure Auto Report Settings by clicking File > Auto Report in the report preview window. For more information, see Auto Reports.