Menu Engineering Activity

Use the following data to populate the blank Menu Engineering Worksheet attached here.

Only use the cells on the worksheet that are yellow, the other cells will automatically calculate as you insert the information into the yellow cells.

Your Menu Data

Between the months of July 2021 and December 21 (6 months) you have the following sales and costing data.

Using the Menu Engineering Excel Worksheet, complete your calculations and make recommendations as to your analysis.

Once you have completed your worksheet, download the solution here and check your answers.

Discussion

Using the results of the menu analysis task that we have given you, explain which menu items you would keep on the menu and which you would get rid of and why.