Be Your Professional Data Analyst In Spss, Stata, Eviews And Ms Excel

Don’t rely on your POS System for Menu Engineering – Do Menu Engineering in MS Excel.

That sounds like an interesting ! Menu Engineering/Analysis is a valuable process for analyzing the profitability & popularity of menu items. I will process and provide insights on menu engineering. To get started, I will need data of your food items, being sold in your restaurant/outlet which includes costs, selling prices, and sales data. How I will do Menu Engineering ?

1. Will create a new Excel spreadsheet and set up the following columns: Item Name, Cost, Selling Price (per item) and Sales Data (e.g., total number of each food items sold during the period for which menu engineering is required).
2. Calculate the Contribution Margin for each item. Contribution Margin is the difference between the Selling Price and the Cost per Portion. Use the formula: Contribution Margin = Selling Price – Cost per Portion.
3. Calculate the Total Contribution for each item by multiplying the Contribution Margin by the Sales Data. Use the formula: Total Contribution = Contribution Margin
4. Will calculate Quadrant Placement of each items (Plow Horse/ Star/Dog/Puzzle) by applying proper formula.

Thank you.