Sample Coastal Resort Grill: Server Performance Dashboard SAMPLE DATA

1. Pool overview

One pool covers the whole 24 hours and is split by points: servers earn 1.0 point per hour worked and bartenders 0.75. The pool is assumed to be 17% of sales (an example assumption). Servers are paid California minimum wage ($11 per hour in 2018 for employers with 26 or more employees) plus their pool share, and bartenders are paid $19 per hour plus their pool share. Only servers and bartenders share the pool in this example, with no bussers or runners. Staffing is about 6 to 8 servers per shift and about 2 bartenders per shift (the bartender count is an assumption).

Pool dollars per point-hour, week by week

2. Total pay per hour

Hourly wage plus pool share per hour, for servers and bartenders. Because the pool is split by hours and points, pay per hour differs between people mostly through the days and shifts they work (weekends and dinners fill the pool faster).

3. Server leaderboard

Tap a column heading to sort. Sales per labor hour is the main number in a shared pool. Liquor per guest shows who sells spirits and cocktails.

4. Beverage breakdown: wine, liquor and beer

Drink dollars per guest for each server, split into wine, liquor (cocktails, spirits neat or on the rocks, and after-dinner drinks such as cognac, scotch and port) and beer. Total drinks also includes non-alcoholic drinks.

WineLiquorBeer (numbers are percent of alcohol dollars)

Cocktails, after-dinner drinks and wine detail

In the bottles vs. glasses bar, dark is bottles and gold is glasses.

5. Add-on rate

The share of tables that ordered an appetizer or a dessert, and specials sold per 10 tables.

6. Each server against similar shifts

Each server's sales per labor hour, and liquor per guest, compared with the average of all servers on the same kind of shift (lunch or dinner, weekday or weekend). A Saturday dinner is only compared with other weekend dinners.

7. Table turn time by party size

Average minutes from seating to table reset.

8. Comps, voids and discounts

Shown as a share of each server's sales, compared with the group in each category. A flag means a category is well above the group, which is worth a conversation. It is not proof of a problem.

9. Guest mentions and reviews (example)

Made-up guest comments that name a server.

10. Pool contribution vs. pool share (servers)

Servers receive 1.0 point for every hour worked, so a server's pool share depends on hours, not on sales. This compares the pool a server's own sales generated with the pool they received. Positive means they brought in more than they received.

11. Bartenders

Bar sales each bartender rang, pool points at 0.75 per hour, and the pool they brought in compared with the pool they received. Bartenders are paid $19 per hour plus pool share. The shift and day filters apply; the section filter does not.

12. Where this data comes from

As an example, a dashboard like this could be fed by the sales-by-server reports from a restaurant's point-of-sale system (such as Oracle Micros/Simphony or Toast) together with scheduled or clocked hours. What is actually available depends on the system and how it is set up.

Nothing on this page comes from a real system. All figures are generated example data.