Navigation:  Warehouse Management > Reports (F&B) >

Menu Engineering

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

Main Menu > Warehouse Management  > Reports (F&B) > Menu Engineering

At first, select a Menu from the list of Menus. The details of transactions of Items of the selected menu are shown. This report shows the sale value, Cost and Contribution of each Item in the Menu.

It also shows the Sale, Profit & Item Classification based on the data.

Columns in the Menu Engineering:

Columns in the Menu Engineering are as follows:

Menu Item

Shows name of the menu item.

Sale Qty

Shows sold quantity of the item.

Sale %

Shows % in total sale quantities.

Item Cost

Shows item cost as per recipe / purchase.

Sale Rate

Shows sale rate of the item.

Item Profit

Shows item profit for the sale of one unit (Sale Rate - Item Cost).

Total Cost

Shows total  cost of production for the sold items (Sale Qty X Item Cost).

Total Sales

Shows total sale amount (Sale Qty X Sale Rate).

Total Profit

Shows total profit (Total Sales - Total Cost).

Profit Category

High = If Item Profit is higher than average profit (profit per piece) (Grand Total Profit / Grand Total Sale.
Low = If Item Profit is lower than average profit (profit per piece) (Grand Total Profit / Grand Total Sale.

Sales % Category

High = If it is sold above 80% of average item's popularity. If Average(Sales% Column) < Sales% Item Then High.        
Low = .If it is sold below 80% of average item's popularity. If Average(Sales% Column) > Sales% Item Then Low.        

Menu Item Classification

Dog = Both "Profit Category" and "Sales % Category" is Low. These are your losers, they are  unpopular and yield low contribution margins.These items may have to be eliminated or their price increased to see whether they can at least reach the status of Puzzles.        
Puzzle = "Sales % Category" is Low but "Profit Category" is High. Also known as Challenge, these items are low in popularity yet yield high contribution margins. You may have to consider whether these items should be on your menu at all.        
Horse = "Profit Category" is Low but  "Sales % Category" is High. Also known as Plow horse / Workhorse, these items are popular, even though they do not yield a high contribution margin. They are normally items popular with your price-conscious clientele.
Star = Both "Profit Category" and "Sales % Category" is High. These are the most profitable items on your menu. One should maintain rigid specifications for quality, portion size and presentation. These items should be in a highly visible position on the menu and well be your restaurant's signature items.

 

Buttons in the Menu Engineering:

Buttons are explained in Using Reports (Register). Buttons specific to “Menu Engineering” are discussed here:

-L Select Menu

To select the menu from the list.