Free Restaurant Profit Margin Calculator
Know where your profits are coming from (and going to) with this free template
- Know where your restaurant stands profit-wise in just a glance
- Identify areas to improve on to increase your profit margin
- Completely customizable to meet your restaurant's needs
Restaurant Profit Margin Calculator Template.xlsx
How to use your profit margin template
Keep track of where you are earning and spending money with this free template.
1. Add in all your total restaurant revenue from all sources.
2. Add in your total expenses like CoGs, labor and more.
3. Calculate your profit margin to see where you stand.
4. Make adjustments to areas to improve your margins.
What should you include to calculate profit margin?
To calculate your restaurant profit margin, you’ll need the following numbers: 1. Total revenue, or the total sales of food, beverage, and merchandise 2. Cost of Goods Sold, or what you pay for food and beverage 3. Labor costs, for both hourly and salaried employees (including benefits!) 4. Other expenses, like rent, utilities, maintenance, marketing, and anything else you spend to run your restaurant
What is an average restaurant profit margin?
This varies from restaurant to restaurant, but the average profit margin for a full-service restaurant ranges from 3-5%. For restaurants that are quick service or food trucks, operating costs are lower, leaving profit margins considerably higher, at 6-9%. You should assess your profit margin weekly or monthly to spot trends and make judgements.
Discover more efficiencies to save time and money with 7shifts
How does this free template stack up to 7shifts?
Compare how functionality of this Excel sheet against a robust team management platform like 7shifts.
 | Profit Margin Calculator | |
| Customizable to your restaurant |  |  |
| Free | | |
| Sharable with your team | | |
| Easy schedule builder | |  |
| Free mobile apps | | |
| Robust labor, sales, and compliance reports | | |
| Communication tools (chat, announcement) | | |
| Online manager log book | | |
| Labor budgeting tool | | |
| Labor compliance tools | | |
That is just one piece of the puzzle
A powerful team management platform like 7shifts is the perfect addition to your tech start. Connecting your schedule to your POS and payroll systems can uncover efficiencies you never even realized.
“It is SO easy to use. It is intimidating at first familiarizing yourself with the platform but after a few minutes it feels so natural using it. I used to do all of my scheduling on an excel spreadsheet. It would take two or three times as long as it takes me now on 7shifts.”
Eddie Cuellar
Restaurant owner, Tower Burger
“I was originally drawn to 7shifts because of their simple and easy interface for scheduling, but when I found out they also did payroll, it was a no-brainer. My employees onboarded via the 7shifts mobile app in 10 minutes and I'm already saving hours of time when it comes to processing payroll. Total game changer.”
Fahad Hanif
Owner/Operator, Halal Guys
“If you're a restaurant professional, this is a mandate. If this is a hobby for you, by all means, use something else. Use Excel, use post-it notes if you write it down. But if you're a professional and this is your career and your actual goal is to earn profit for your business, then there's no viable solution or anything that would make sense other than this. There just isn't.”
Mike Bausch
Owner, Andolini's
Find out why 1.5 million restaurant professionals love 7shifts
Start free trial1.7k
Ratings
1M+
Downloads
1.1k
Reviews
99
Reviews
Free Restaurant Management Templates
See all templates
Tip Pooling Template
Download the free excel tip pooling calculator to help determine and distribute tips to your employees using tip pools.
Download now
Manager Log Book Template
Download the log book template to help managers keep track of what's going on in your business.
Download now
Restaurant Budget Template
Get the restaurant budget template to determine the budgeting of your restaurant.
Download now
Restaurant Schedule Template
Get the best restaurant excel-file schedule template to help create your staff work schedules.
Download now