Menu Engineering Workshee

LOLIVO & AJA

(A) (B) (C) (D) (E) (F)

Menu Item Number Sold Menu Item Item Item CM
Name (MM) Mix % Food Cost Selling Price (E - D)
Fettucine Alferd (2815) 223.00 1.43% 6.07 65 $ 58.93
Green salad N (12215) 275.00 1.76% 2.23 60 $ 57.77
Insalata Caprese (2208) 471.00 3.02% 5.85 65 $ 59.15
Margherita (3001) 454.00 2.91% 3.15 60 $ 56.85
Penne al Arabia. (2803) 125.00 0.80% 2.22 65 $ 62.78
Pizza 4 Seasons (3007) 191.00 1.22% 3.68 70 $ 66.32
Pizza Carnivale (3008) 138.00 0.88% 5.51 70 $ 64.49
Pizza Tonno (3011) 56.00 0.36% 5.02 70 $ 64.98
Quattro Formaggi (3002) 233.00 1.49% 4.16 45 $ 40.84
Rixos Tiramisu (3202) 653.00 4.18% 8.90 45 $ 36.10
Spaghtti Bologne (2813) 410.00 2.63% 5.45 45 $ 39.55
Lasagna Tra. (2801) 186.00 1.19% 9.97 70 $ 60.03
Beef Carpaccio (2209) 281.00 1.80% 8.43 65 $ 56.57
Carre D Ag. Bro. (2603) 303.00 1.94% 8.33 145 $ 136.67
Filetto di Manzo (2602) 243.00 1.56% 10.61 150 $ 139.40
Fritto Misto (2228) 485.00 3.11% 2.41 70 $ 67.59
Linguine Gamberi (2827) 234.00 1.50% 1.58 80 $ 78.42
Minestrone Soup (2402) 238.00 1.52% 1.62 45 $ 43.38
Mushroom Soup (2411) 323.00 2.07% 3.10 45 $ 41.90
Panna cotta (3201) 295.00 1.89% 5.32 45 $ 39.68
Penne Alfredo (2810) 1.00 0.01% 9.97 45 $ 35.03
Rigatoni Arabiat (2835) 33.00 0.21% 2.23 25 $ 22.77
Risotoo Asparagu (2831) 55.00 0.35% 5.31 75 $ 69.69
Risotto Mushroom (2833) 59.00 0.38% 5.71 75 $ 69.29
Roasted Seabream (2653) 80.00 0.51% 5.63 125 $ 119.37
Gnocchi Pumpkin (2829) 27.00 0.17% 7.92 70 $ 62.08
Chicken Ragout (2825) 63.00 0.40% 2.32 75 $ 72.68
Assorted Tempura (10205) 230.00 1.47% 4.51 70 $ 65.49
Bana Spri Roll (10810) 244.00 1.56% 1.59 30 $ 28.41
Beef Salad (10212) 126.00 0.81% 7.80 65 $ 57.20
Black Pepper Bee (10624) 151.00 0.97% 9.54 145 $ 135.46
Butter Chicken N (10617) 95.00 0.61% 8.07 110 $ 101.93
Cream Brulee (10812) 115.00 0.74% 3.64 45 $ 41.36
Kung Pao Chicken (10622) 106.00 3.27% 3.47 110 $ 106.53
Mie Goreng (10620) 273.00 4.01% 4.19 80 $ 75.81
Pad Thai (10608) 77.00 3.07% 10.10 90 $ 79.90
Rising Sun N (10207) 394.00 2.92% 24.74 195 $ 170.26
Selet of Ice Cre (10807) 29.00 2.74% 4.55 15 $ 10.45
Teriyaki Salmon (10626) 99.00 3.37% 11.25 125 $ 113.75
Thai Curry N (10616) 134.00 2.90% 7.07 90 $ 82.93
Vegetables Soup (10408) 21.00 3.43% 3.11 45 $ 41.89
hot & sour soup (10401) 94.00 2.70% 2.77 45 $ 42.24
tom yam goong (10403) 222.00 2.70% 4.20 50 $ 45.80

(N)
15,619

Additional Computations:

CM = Contribution Margin
MM = Menu Mix

NOTE:-
STAR:-High popularity and High Profitability
Plowhorse:-High popularity and Low Profitability
Puzzle:-Low Popularity and High Profitability
Dogs:-Low popularity and Low profitability
ering Worksheet

Period: July 2017

(G) (H) (L) (P) (R) (S)

Menu Costs Menu Revenues Menu CM CM MM % Menu Item OUTLET
(D x B) (E x B) (H - G) Category Category Classification
$ 1,352.94 $ 14,495.00 $ 13,142.06 High Low Puzzle LOLIVO
$ 612.43 $ 16,500.00 $ 15,887.58 High Low Puzzle LOLIVO
$ 2,755.82 $ 30,615.00 $ 27,859.18 High High Star LOLIVO
$ 1,428.28 $ 27,240.00 $ 25,811.72 High High Star LOLIVO
$ 277.50 $ 8,125.00 $ 7,847.50 High Low Puzzle LOLIVO
$ 702.88 $ 13,370.00 $ 12,667.12 High Low Puzzle LOLIVO
$ 760.38 $ 9,660.00 $ 8,899.62 High Low Puzzle LOLIVO
$ 281.06 $ 3,920.00 $ 3,638.94 High Low Puzzle LOLIVO
$ 968.35 $ 10,485.00 $ 9,516.65 Low Low Dog LOLIVO
$ 5,814.31 $ 29,385.00 $ 23,570.69 Low High Plowhorse LOLIVO
$ 2,235.73 $ 18,450.00 $ 16,214.27 Low High Plowhorse LOLIVO
$ 1,855.16 $ 13,020.00 $ 11,164.84 High Low Puzzle LOLIVO
$ 2,368.27 $ 18,265.00 $ 15,896.73 High High Star LOLIVO
$ 2,523.99 $ 43,935.00 $ 41,411.01 High High Star LOLIVO
$ 2,577.02 $ 36,450.00 $ 33,872.99 High Low Puzzle LOLIVO
$ 1,169.34 $ 33,950.00 $ 32,780.67 High High Star LOLIVO
$ 369.25 $ 18,720.00 $ 18,350.75 High Low Puzzle LOLIVO
$ 385.08 $ 10,710.00 $ 10,324.92 Low Low Dog LOLIVO
$ 1,001.62 $ 14,535.00 $ 13,533.38 Low High Plowhorse LOLIVO
$ 1,568.52 $ 13,275.00 $ 11,706.49 Low High Plowhorse LOLIVO
$ 9.97 $ 45.00 $ 35.03 Low Low Dog LOLIVO
$ 73.59 $ 825.00 $ 751.41 Low Low Dog LOLIVO
$ 292.22 $ 4,125.00 $ 3,832.79 High Low Puzzle LOLIVO
$ 336.95 $ 4,425.00 $ 4,088.05 High Low Puzzle LOLIVO
$ 450.32 $ 10,000.00 $ 9,549.68 High Low Puzzle LOLIVO
$ 213.73 $ 1,890.00 $ 1,676.27 High Low Puzzle LOLIVO
$ 146.10 $ 4,725.00 $ 4,578.90 High Low Puzzle LOLIVO
$ 1,037.53 $ 16,100.00 $ 15,062.47 High Low Puzzle AJA
$ 387.72 $ 7,320.00 $ 6,932.28 Low Low Dog AJA
$ 982.93 $ 8,190.00 $ 7,207.07 High Low Puzzle AJA
$ 1,440.09 $ 21,895.00 $ 20,454.91 High Low Puzzle AJA
$ 766.27 $ 10,450.00 $ 9,683.73 High Low Puzzle AJA
$ 419.06 $ 5,175.00 $ 4,755.94 Low Low Dog AJA
$ 368.24 $ 11,660.00 $ 11,291.76 low low Dog AJA
$ 1,142.78 $ 21,840.00 $ 20,697.22 low low Dog AJA
$ 777.55 $ 6,930.00 $ 6,152.45 low low Dog AJA
$ 9,747.17 $ 76,830.00 $ 67,082.83 low low Dog AJA
$ 131.89 $ 435.00 $ 303.11 low low Dog AJA
$ 1,113.45 $ 12,375.00 $ 11,261.55 low low Dog AJA
$ 947.11 $ 12,060.00 $ 11,112.89 low low Dog AJA
$ 65.23 $ 945.00 $ 879.77 low low Dog AJA
$ 259.91 $ 4,230.00 $ 3,970.09 low low Dog AJA
$ 932.84 $ 11,100.00 $ 10,167.16 low low Dog AJA

(I) (J) (M)

$ 114,030.16 $ 864,315.00 $ 750,284.84
(O) = M/N (Q) = (100%/Items) (70%)
$ 48.04 1.79%

Cost %