Customer Profile

Sector: Food
Industry: Food service Distributor
Revenue: Over $15 billion

The Wholesale Food Distributor (WFD) has over 250,000 customers. They market and deliver to more than 43,000 national, private label and signature brand items and employ more than 29,500 food service professionals.

Business Situation

The WFD provides restaurant managers with an MS Excel-based tool to help them control food costs. The Excel tool calculates food costs and profits along with generating reports. Managing the Excel spreadsheets became time consuming and cumbersome. The distributor wanted to rebuild the Excel spreadsheets into a database application that was intuitive and robust. The new database would have the following requirements:

  • Recipe and Menu Costing System Requirements
  • Easily track recipe costing and menu item costing
  • Profit analysis for each recipe and menu item
  • Easily manage preparation, assembly, and safety instructions
  • Several other time-saving reports

Solution

The customized system provides the organization with the following functionality:

Recipe Costing

  • Handles thousands of ingredients with price, pack size and unit size
  • Import or hand enter recipes. Copy and rename recipes.
  • Supports US standard and metric units of measurement
  • A recipe may contain ingredients and other recipes
  • Calculates the cost of each recipe and its cost per serving
  • Easily add and view safety instructions for each recipe
  • Easily add and view preparation instructions for each recipe
  • Handles thousands of recipes

Menu Costing

  • Capable of managing thousands of menu items
  • Import or hand enter menu items. Copy and rename menu items.
  • Easily build menu items using ingredients and recipes
  • Automatically calculate profitability of menu items
  • Color coding signifies which menu item margins are low and which are high
  • Easily add kitchen assembly instructions, serving instructions, and server promotion notes for each menu item
  • Easily find and replace a recipe or ingredient across all menu items and recipes

Reporting and Sales Analysis

  • Import sales data from a POS system or hand enter sales
  • Generate graphs and reports with visuals on revenue and profits for each menu item
  • Make better decisions while engineering a menu using reporting that graphs menu items into 4 categories: highest sales quantity and highest profit, lowest sale quantity and highest profit, highest sales quantity and lowest profit, lowest sales quantity and lowest profit
  • Powerful search tool to help locate and report on ingredients, recipes, and menu items
  • Assign security roles to users to give them access to only information that they need

 

The world’s only Microsoft Access Enterprise Support Service Offering!