Mirus Reporter

What Comes First?

Determining the reason why two restaurant reporting numbers are different can be a real challenge, like the chicken or the egg. In this era of big data, many restaurant companies are racing to improve their use and comprehension of the data they have locked up in their system silos. But, the question for this post is: Does data make people smarter or is it the other way around?

In 2017, same-store sales of all restaurants fell by -1.1% according to TD2NK and their Black Box Intelligence index. This index is computed on data from 30,000 restaurants, so it is a pretty good aggregation of data - about 5% of the restaurant industry. In this population, I think it is fair to say that some of the companies use their data aggressively and some do not.

Overview

Before we jump into the characteristics of an Enterprise Data Warehouse (‘EDW’) it might help to define what an EDW consists of. An EDW is a centralized repository that integrates data from various transactional, legacy, or 3rd party systems and applications that are used to operate and manage your business. In contrast to these systems, the EDW is built for analysis and retrieval of data rather than the upkeep of individual transactional records.

Ralph Kimball, one of the original architects of data warehousing and someone whose teachings we adhere to, provided a more concise definition of a data warehouse: “A data warehouse is a copy of transaction data specifically structured for query and analysis.”.

Finding new ways to maximize the overall profitability of a restaurant business is on the mind of every restaurant owner. Whether you have a few restaurants or a few hundred, you’re constantly trying to think up ways to beef up the profit margin. Your executives analyze the numbers, think up ideas to control costs, cut down on food waste, offer Limited Time Offers, cut back labor hours and eliminate overtime, all with the ultimate goal of increasing profitability. But what steps are taken to ensure that any of these ideas will prove successful? Are they examining performance metrics in order to track and evaluate what steps are effective and which areas need improvement?

Our clients love us and we love them right back! We're constantly amazed by their ingenuity and accomplishments. Their ideas and requests are what keep us on the leading edge of restaurant business solutions. Periodically we like to shine the light on our clients, their accomplishments and what they're doing to increase their restaurant profit margin.

2017, what a year it was for the restaurant industry. We saw our share of ups and downs having fought through hurricanes, floods, and wildfires. The stock market hit record highs with increased valuations of some restaurant stocks. There were many major acquisitions throughout the industry.

Mirus also had a busy year. This 2017 Year in Review details some of the highlights from the year.

December continues to look like an important month for the restaurant industry. After years of poor or lackluster results overall, the first half of December has delivered positive same store sales and traffic, according to the Mirus Index.

The CTO Challenge: Labor

One of the many challenges of the restaurant CTO is to implement a reporting solution that can help lower labor costs and maximize profits. They’re tasked with integrating the latest technology, seeking the right platforms for their structure, drive success and create a competitive lead. The days of Excel spreadsheets are numbered. Ultimately, the CTO needs to find and recommend a platform that will aid restaurant executives in making the best decisions in operations and finance and developing strategies that provide a significant ROI. The CTO’s research and definitive recommendation of the suitable reporting tool is vital and can affect the productivity (or lack thereof) of all departments.

Much has been written over the past two years about the dismal pattern of same store sales and traffic for restaurants. Traffic has been negative throughout this period, and sales have rarely been positive, and then only when restaurants increase prices.

Analyzing Restaurant Profits

Restaurants are changing the way they analyze profits and performance. New techniques for examining data are being used. New metrics are being calculated. And perhaps the most important change is the amount of data being examined every day, and throughout the day in some cases.

Historically, restaurants reported highly summarized data each day to manage the business. Sales for Lunch or Dinner, or sales mix for a day or week, or labor dollars as a percent of sales for the day are typical examples. Summarized data can mask operational issues, and it limits the depth of performance analysis you can conduct. For example, a daily labor metric could hide the fact that there were hours where too many employees were on the clock while at different times of the day staffing was insufficient to service customer demand.

Our clients love us and we love them right back! We're constantly amazed by their ingenuity and accomplishments. Their ideas and requests are what keep us on the leading edge of restaurant business solutions. Periodically we like to shine the light on our clients, their accomplishments and what they're doing to increase their restaurant profit margin.