BI Case Studies in Hospitality (Restaurants)

Potbelly Sandwich Works: Restaurant Boosts Revenues 2.5 Percent by Giving Performance Data to Managers: Potbelly Sandwich Works is a fast-growing restaurant company. But the information on which Potbelly personnel made business decisions was limited in scope and available only to some of the people who needed it. To address the problem, Potbelly adopted a Microsoft® Business Intelligence solution that consolidates disparate data sources into a central data warehouse. Users access the analysis through scorecards and reports that enable them to drill down into the information. A pilot deployment immediately increased revenues 2.5 percent just by giving restaurant operators insight into the performance of their stores. Executives have visibility into company performance and can identify high performers and “best practices.” The decision to extend an existing investment in Microsoft software saves Potbelly U.S.$300,000 per year—50 percent—in licensing costs compared to a Hyperion system.

Culver Franchising Systems Inc.: Culver’s Improves Operations with Microsoft Business Intelligence Solution: CFSI turned to trusted partner RedPrairie, provider of Culver’s retail management systems. The company was impressed by RedPrairie’s powerful Performance Management solution, based on Microsoft® Business Intelligence (BI) technologies. The RedPrairie-Microsoft solution gives CFSI easy access to the data needed to make better decisions and improve store operations, while vastly reducing reporting time.

Muammad Din Sons Limited: Fast Food Firm Deploys Enterprise Resource System for Supply Chain Management: Fast food chain and domestic appliances manufacturer Muammad Din Sons Limited wanted a business management solution for its expanding interests in Pakistan. Having considered systems from Oracle and SAP, the company standardised on Microsoft Dynamics AX 2009. Stock levels are managed more effectively, and accuracy in specifying materials requirements at the factory has improved by 400 per cent. Managers now also get performance reports in real time.

Devyani International Ltd: Retail Company Automates Processes, Integrates Operations with new Business Solution Established in 1991, Delhi based Devyani International Ltd. is an Indian franchisee of KFC and Pizza Hut chain of restaurants in agreement with Yum! Brands and UK's Costa Coffee chain. However, with a total of 130 outlets, the challenges of performing accounting, billing and reporting activities along with point-of-sales terminal management increased. With disparate systems and unconnected point-of-sales terminals the company struggled with manual processes that required extra man power and introduced inaccuracies. To address these challenges, it worked with Trident Information Systems, a Microsoft® Certified Partner, to implement an end-to-end POS retail solution based on LS Retail 5.0 built on Microsoft® Dynamics™ NAV 4.0 with Service Pack 3. The solution at DIL manages all the aspects of sales related business from point-of-sale to back-office management including promotional and discount schemes. It streamlines operations and supports growth in the retail business. With all the point-of-sale terminals and stores integrated with the head office, the solution saves huge person-hours resulting in reduced administrative costs.