Daily Administration Spreadsheets Build Consistent Restaurant Management Systems
Daily Administration Spreadsheets Build Consistent Restaurant Management Systems
Did you know the key to building consistent restaurant management systems starts with a simple group of spreadsheets that only take about 15 minutes a day to complete? And did you know that if you don't track this data, you're most likely losing money? Let’s talk about these spreadsheets and what they do for your business and your ability to run a consistent operation.
****How to Solve Your Restaurant's Cost and Management Challenges: https://dsp.coach/transformation-opt-in
📖 I wrote a book for restaurant owners and managers: https://amzn.to/2ZYlL7Y
🔔 Be sure to subscribe to this channel to get alerts when I post a new tip: http://bit.ly/2Yk484P
🎧 Take me on the go and listen to my podcast: https://dsp.coach/podcast
**********************************
Welcome to my YouTube Channel. I am David Scott Peters, a restaurant coach and speaker who teaches restaurant operators how to cut costs and increase profits with my trademark Restaurant Prosperity Formula. Known as THE expert in the restaurant industry, I apply my no-BS style to teach and motivate restaurant owners to take control of their businesses and finally realize their full potential. Thousands of restaurants have used my formula to transform their businesses. To learn more about me and my coaching program, visit http://www.davidscottpeters.com.
**********************************
To run a profitable restaurant, one that doesn't require you, the restaurant owner, to be in it 24-7, and have managers who can run the business for you your way, you need to start with implementing a very specific group of spreadsheets. These spreadsheets allow you to share the tasks, free you up to lead your restaurant versus working in it, and track key data to help you build consistent restaurant management systems.
Here are five daily admin Google Sheets I provide my members as an example of what you need to have in place to achieve these goals.
1. Sales Forecast Generator: You need a spreadsheet that allows you to take past data, whether last month or the same month last year that you want to forecast for. Simply copy and paste data and add a target sales figure for that upcoming month so it automatically shows you what your sales are by day. These numbers are extremely important for other systems. This forecast drives all of your systems that are proactive.
2. Daily Sales Report Tracker: I call this the DSR. Your POS system prints off a daily sales report that tells you what your sales are, but it's important your DSR tracker tracks the right data. For example, you want to track gross sales by category, not net sales. You want to know your comps so you know how much less cash to expect. You want to know your accounts payable, such as gift cards sold or catering deposits, so you know how much more cash to expect. And this tells you exactly based on your sales minus your discounts plus those accounts payable, such as sales tax collected, how much money you should expect to bring in.
3. Invoice Log: When it comes to the proactive ordering system to know how much you can order for your next order, you need an invoice log that summarizes the bottom of the invoice, which is how much food, how much janitorial paper and so on.
4. Paid Out Tracker. If you run to the store for tomatoes and also buy printer paper, you want to make sure that not only are you controlling your cash, which that paid out goes into that DSR tracker, but you know how much of that receipt was food.
5. Manager Log: Whether it's a Google spreadsheet, built into software, a Microsoft tool or Slack, using anything that communicates is incredibly important because it keeps your managers on the same page, whether they've been there or not for a day, two or three.
These five systems are so critical and so easy to do. The most amazing thing about these sheets is that they only take about 15 minutes to complete each day, and they're completed by your management team, not you.
These are just some of the major systems those five spreadsheets set you up to use these bigger systems to make real change in your business and make the money you deserve.
**********************************
Find more about how to run a restaurant business on my other platforms:
👍 Facebook: / davidscottpetersbiz
📸 Instagram: / davidscottpeters
📱 Twitter: / restaurantxpert
🔔 Subscribe to YouTube: http://bit.ly/2Yk484P
🎧 Podcast page: https://dsp.coach/podcast