The Four R Report provides a graphical display of each item’s margin vs. quantity sold in order to help you determine if items are priced correctly. A chart that begins on page two of the report helps you quickly identify the details of each item. 


Report Usage 


The “Four R’s” are: Retain, Re-think, Reprice, or Replate. The graph at the beginning of this report helps you quickly identify which items should be retained, re-thought, repriced, or replated. Items with an above-average margin and an above average quantity sold are ideal and should be retained. Items that have a below-average quantity sold and a below-average margin may need to be re-thought. All other items (items that are high-quantity/low-margin or low-quantity/high-margin) may need to be repriced or replated. 


Report Features 


  • Filter by location(s) or location group(s). 
  • Filter by date. This report can be run for any specified length of time. 
  • Filter by metric. You may select either “Margin $” or “Cost %”. 
  • Select the order in which you would like the report results to be sorted. 
  • Filter by Daypart. 
  • Select whether to show all items or just the top selling items. If you select to show the top selling items, specify how many top selling items you would like to display on the report in the ‘Top Selling Items’ field. 
  • Select whether to show, hide, or exclude chain modifiers. 
  • Select whether you would like to display items by Sale Department or by Item Group. If you select “By Item Group”, you will be able to select an item group from the ‘Item Group’ dropdown. If you select “By Sale Department”, you will be able to select the Master Sale Department and the Sale Department. 
  • Select whether or not to exclude Zero Cost items. 
  • Select whether or not to exclude Zero Price items. 
  • Select whether or not to exclude items with a Quantity Sold that is less than an amount that you specify. The default amount is 100. 
  • Select whether or not to exclude items with a Quantity Sold that is greater than an amount that you specify. The default amount is 100. 
  • Select whether or not to exclude items with a Margin that is less than an amount that you specify. Your specified amount can either be a dollar amount or a percentage. The default amount is $5. 
  • Select whether to exclude items with a Margin that is greater than an amount that you specify. Your specified amount can either be a dollar amount or a percentage. The default amount is $5. 
  • This report can be viewed/exported in various formats. It can also be directly emailed.


Frequently Asked Questions 


Q: In the report header, what does the ‘Menu Item Cost Source’ indicate? 

A: The ‘Menu Item Cost Source’ provides information about where data is being pulled from, since the report is not able to support a Step 3 selection allowing you to choose a source. This data is pulled via the Recipes module, or directly from the POS system; “mixed” will be displayed when both sources are used. 


Q: How is the action determined for each item? 

A: Actions are determined as follows: 

  • Metric: Margin $, Total Margin $ 
  • Retain: Qty Sld >= Qty Sld (avg) AND Metric >= Metric (avg) 
  • Rethink: Qty Sld < Qty Sld (avg) AND Metric < Metric (avg) 
  • Reprice / Replate: Qty Sld >= Qty Sld (avg) AND Metric < Metric (avg) Qty Sld < Qty Sld (avg) AND Metric >= Metric (avg) 
  • Metric: Cost % Retain Qty Sld >= Qty Sld (avg) AND Metric <= Metric (avg) 
  • Rethink: Qty Sld < Qty Sld (avg) AND Metric > Metric (avg) 
  • Reprice / Replate: Qty Sld >= Qty Sld (avg) AND Metric > Metric (avg) Qty Sld < Qty Sld (avg) AND Metric <= Metric (avg) 


Formula Notes 


Values marked with “(avg)” above are the average for ALL items, and can be found on the “Total and Averages” line at the bottom of the report. “Metric” is a place holder for the selected metric. 


Action Notes 

When selecting Margin $ or Total Margin $, items may indicate the “Reprice/Replate” action despite having a low cost percentage and high sale quantities. This is due to the item’s margin being less than the average margin for all items and indicates that it is underpriced.