Scribd
Upload
209 views1 page

Restaurant: Meal Period: Date: (A) (B) (C) (D) (E) (F) (G) (H) (I) (J)

This document analyzes a restaurant menu for the week. It provides sales data for each menu item, including number sold, menu mix percentage, food cost, selling price, contribution margin, and contribution to total margin. Items are categorized as high or low margin and mix percentage. This allows classification of items as "stars", "puzzles", "plowhorses", or "dogs" to determine how well each item performs and whether adjustments are needed. The total contribution margin for the week is calculated and compared to an average to determine performance.

Uploaded by

Mohammad pharabia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
209 views1 page

Restaurant: Meal Period: Date: (A) (B) (C) (D) (E) (F) (G) (H) (I) (J)

This document analyzes a restaurant menu for the week. It provides sales data for each menu item, including number sold, menu mix percentage, food cost, selling price, contribution margin, and contribution to total margin. Items are categorized as high or low margin and mix percentage. This allows classification of items as "stars", "puzzles", "plowhorses", or "dogs" to determine how well each item performs and whether adjustments are needed. The total contribution margin for the week is calculated and compared to an average to determine performance.

Uploaded by

Mohammad pharabia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Menu Analysis Worksheet KEY

Restaurant: Meal Period: Date:


(A) (B) (C) (D) (E) (F) (G) (H) (I) (J)
Menu
Mix
Menu Item Menu Contribution %
# Sold/ Mix Item Contribution Contribution Margin Category Menu
Menu % Food Item Selling Margin Margin Category Low<7% Item
Menu Item Name Mix (B/K) Cost Price (E-D) (F X B) * 8%>High Classification

Chinese Chicken
Salad 210 13.1 2.05 4.50 2.45 514.50 Low High Plowhorse

Mexican Pasta
Salad 63 4.0 1.36 4.50 3.14 197.82 Low Low Dog

Mexican Taco
Salad 390 24.4 1.77 4.50 2.73 1064.70 Low High Plowhorse

Twisted Chicken
Salad 140 8.7 1.16 5.30 4.14 579.60 High High Star

Sweet and Sour


Meatballs 277 17.3 1.86 5.65 3.79 1049.83 High High Star

Pasta Provencal 80 5.0 1.63 5.65 4.02 321.60 High Low Puzzle

Honey Glazed
Chicken Stir-Fry 440 27.5 1.35 5.00 3.65 1606.00 High High Star

Column Totals (K) (Should (L)


total
1600 100%) 5334.05
*Categorized as high or low based on relationship to the average contribution margin.
Average Contribution Margin Achievement Rate: L (5334.05) / K (1600) = $3.33

Menu Item Classification: Low contribution margin, low menu mix percent DOG
High contribution margin, low menu mix percent PUZZLE
Low contribution margin, high menu mix percent PLOWHORSE
High contribution margin, high menu mix percent STAR

You might also like