Recipe Margin Report

The Recipe Margin report displays recipe price and cost data for the current location. This report enables authorized users to quickly view information about a recipe’s selling price, its actual and ideal costs, as well as these values calculated as a percentage of the selling price. The report will also display the difference between the selling price and the recipe cost, and between the recipe cost and the ideal recipe cost.

Menu Paths: Net-Chef > Production: Reports > Recipe Margin
Menu Paths: Net-Chef > Reports: Production > Recipe Margin

Report Controls

Group By: N/A (default), Category, Subcategory, Microcategory, GL Code

View Recipe Detail: Downloads a more detailed report showing cost and price details for the recipe and its components

Funnel (Filters): Any report column

Printer (Export): PDF, Excel, CSV formats

Report Columns:

Click any column header to sort by the data in that column.

Product Number – The recipe Product Number, from the Recipe Details screen in Enterprise Manager.
Recipe Name – The Recipe Name, from the Recipe Details screen.
PLU – The PLU # for the selected location, from the Location tab of the Recipe Details screen if populated. If not, will display the entry from the Recipe tab.
Selling Price – The Recipe Price for the selected location, from the Location tab if populated. If not, will display the Ideal Price per Portion from the Recipe tab.
Recipe Cost – The Cost per Portion, calculated based on the location's "POS Decrement" setting.

If "POS Decrement" = 'Component', this is the sum of the Issue Cost values of the recipe components (i.e. the cost per portion if made today). If a component does not have an Issue Cost value, the product's contract or lowest bid price in the location's market will be used.
If "POS Decrement" = 'Item', this is the Issue Cost for the recipe's Location Product (i.e. the cost per portion of current inventory). Note: If this value is displayed, it may not match the “Recipe Details” view, which always shows the component costs and their sum.

Difference: Price - Cost = [ Selling Price - Recipe Cost ]
Ideal Recipe Cost = [ Selling Price x Ideal Recipe Cost % ]
Actual Recipe Cost % = [ (Recipe Cost ¸ Selling Price) x 100 ]; the cost per portion as a percentage of the selling price.
Ideal Recipe Cost % = The Ideal Cost % from the Recipe Details screen.
Value Difference = [ Recipe Cost – Ideal Recipe Cost ]
Category – The Category assigned to the company product.
Subcategory – The Subcategory assigned to the company product.
Microcategory – The Microcategory assigned to the company product.

The View Recipe Detail link opens a window to allow users to view all recipes displayed in the report, along with the cost and pricing details of each. This report can also be printed from PDF format or exported to an Excel worksheet.