Profit & Loss Dashboard for Restaurant Business
Originally published: 09/07/2020 08:16
Last version published: 26/11/2020 08:07
Publication number: ELQ-81185-3
View all versions & Certificate
certified

Profit & Loss Dashboard for Restaurant Business

Profit & Loss Statement Dashboard for Restaurant Business in Microsoft Excel.

Description
This tool takes your boring Profit & Loss statement and turns it into a useful and attractive Profit & Loss Dashboard. This tool was designed for the Food & Beverage industry, but could be adapted for other types of businesses.

SUMMARY

The dashboard contains a comparative year-over-year profit and loss statement, calculations for items as percentage of revenue, as well as the change from one year to the next.

It contains three graphs/charts:
- year over year sales comparison by type
- sales mix pie chart
- profit margins bar chart

It also contains some useful metrics for the restaurant industry, including: net profit percentage, gross margin percentage, prime cost (labor plus cost of goods sold), labor cost %, and sales growth % year over year.

The Dashboard tab works by pulling information populated into the 2020 Data, 2019 Data, and Graphs tabs. 2020 and 2019 data is populated into the respective tabs utilizing 'categories'. Categories are preset, so when you add your P&L item to Column A of the Data tabs, you will need to select one of the existing categories from the drop down menu. Everything on the dashboard is calculated automatically, the only thing you need to change is the month you're working with.

INSTRUCTIONS
- Change the months in cells G3, C6 and E6
- In the 2020 Data tab: clear the existing data keeping the headings. Copy and paste your profit and loss items into column A, and the respective amounts into column C. Select the category from the drop down list in column B
- In the 2019 Data tab: clear the existing data keeping the headings. Copy and paste your profit and loss items into column A, and the respective amounts into column C. Select the category from the drop down list in column B
- Review the graphs tab to make sure that the data for your company is being pulled correctly into the graphs contained on the Dashboard

That's it!! Everything in the Dashboard tab is automatically populated from the Data tabs.

This Best Practice includes
1 Excel Spreadsheet

Nadine Popova offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.7 / 5 (20 votes)

please wait...