Bar and Club Sales and Price Dashboard Template

Description
Report SummaryThe Bar and Club Sales and Price Dashboard Template is a report that applies free data input applications, used to manage sales and inventory insights to restaurants, bars, or both. This report was designed to provide a low-cost solution for restaurant & bar business owners who may not have the knowledge and/or access to easy technical solutions.
This report was created to provide visibility to a restaurant and/or bar’s sales and inventory. It provides a week-to-date (WTD) and month-to-date (MTD) sales projection, and detail trends to daily sales. This report provides an option to filter all settings based on various locations and sites. The report provides insights into the top orders, based on the menu and the beverages. This report can provide specific details to where owners are winning or losing based on the sales order. It can provide user insight to discard or scale back on less popular items and focus on the wins for more profits. The report provides a second tab that captures the current inventory status and insights based on the inventory inputs. It compares last month's inventory to the current inventory. It also compares sales based on Cost Categories to inventory status.
Below are the key highlights for this report:
· Free sources to update through Google Sheets, automate, and maintain the report.
· Ability to see sales projections daily to make quicker decisions and changes.
· Provides 80% profit menu price vs cost comparison, built into the report. (Liquor, Beer, Food items)
· Detailed Sales report features to identify low and popular items.
· Drill Through feature to breakdown sales categories.
Set Up Requirements
To maintain continued use of this report the user will require the following free applications to implement the product.
· Free Google Account to use Free Google Sheets
· Free Microsoft/ Outlook Account to use Free Power BI Application and Power BI