Menu Engineering Periode Nov 2020

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 16

Period : NOV 2020

Popularity Cost Price Sell Price Rest


Menu # Sold
MM % IFC ISP
RS TRR CLB PPB
Coffee
Cappucino 4 11 1 10.32% 10,170 41,000
Mochacino 0.00% 12,770 41,000
Caffe Late 2 8 6.45% 9,580 41,000
Regular Coffee 8 5.16% 7,170 41,000
Cappucino BF 0.00% 10,170 14,876
0.00%
Sub Total 14 0 19 1 21.94% 49,860 178,876

Tea
Mint Tea 0.00% 2,200 24,000
Lychee Tea 0.00% 2,200 24,000
Black Tea 3 3 3.87% 2,200 24,000
Ice Tea 4 1 3.23% 2,200 24,000
Lemon Tea 2 1.29% 2,520 24,000
Ginger Tea 0.00% 2,200 24,000
Jasmin Tea 0.00% 2,200 24,000
Sub Total 9 0 4 0 8.39% 15,720 168,000

Long Drinks
Long Island Ice Tea 0.00% 63,626 149,000
illusion 0.00% 69,384 149,000
Green Mile 0.00% 35,421 149,000
D'braga 0.00% 33,239 149,000
Sub Total 0 0 0 0 0.00% 201,669 596,000

Milk
Fresh Milk 1 0.65% 3,700 30,000
Chocolate 2 2 2.58% 4,644 30,000
Sub Total 2 0 3 0 3.23% 8,344 60,000

Soft Drinks & Mineral Water


Diet Coke 0.00% 4,857 29,000
Sprite 0.00% 4,693 29,000
Ginger Ale 3 1.94% 4,636 29,000
Soda Water 0.00% 2,688 29,000
Ron 88 31 14 29.03% 1,208 15,000
Coca Cola 4 2.58% 4,495 29,000
Equil Natural 0.00% 6,454 29,000
Equil Sparkling 0.00% 7,650 29,000
Traditional 0.00%
BANDREK 11 1 1 8.39% 8,600 30,000
Tea Tarik 5 3.23% 4,800 30,000
Sub Total 54 1 15 0 45.16% 50,081 278,000

Healthy Drink
Body Protector 0.00% 8,540 45,000
Fat Reduction 0.00% 4,563 45,000
Eye's Keeper 0.00% 4,790 45,000
Sub Total 0 0 0 0 0.00% 17,893 135,000

Smoothies
Banana 0.00% 10,800 40,000
Strawberry 0.00% 11,359 40,000
Mango 0.00% 11,009 40,000
Papaya 0.00% 10,850 40,000
Melon 0.00% 11,510 40,000
Pineapple 0.00% 11,449 40,000
Sub Total 0 0 0 0 0.00% 66,977 240,000

Milk Shakes
Vanilla 0.00% 9,669 40,000
Strawberry 0.00% 6,164 40,000
Chocolate 1 0.65% 7,881 40,000
Orange 0.00% 6,947 40,000
Mango 0.00% 6,570 40,000
Fresh Juices
Orange 12 3 2 10.97% 8,021 50,000
Avocado 4 5 2 7.10% 6,789 50,000
Carrot 0.00% 4,379 50,000
Strawberry 1 0.65% 4,231 50,000
Lychee 0.00% 4,045 50,000
Melon 0.00% 5,191 50,000
Watermelon 2 1 1.94% 3,907 50,000
Tomato 0.00% 2,740 50,000
Mango 0.00% 3,989 50,000
Pineapple 0.00% 3,853 50,000
Lemon Squash 0.00% 7,047 50,000
Apple 0.00% 8,097 50,000
Guava 0.00% 1,691 50,000
Sub Total 20 0 9 4 21.29% 101,213 850,000
GRAND TOTAL 99 1 50 5 100%
MM % 155 1.25%
AMCM
Total Food Cost
TOP TEN BEST SELLER PERIOD NOV

Orange-Juice 17.30% 1
Ron 88 13.74% 2
Cappucino 13.35% 3
Avocado-Juice 11.19% 4
Caffe Late 8.34% 5
Bandrek 7.94% 6
Regular Coffee 6.67% 7
Tea Tarik 3.05% 8
Watermelon-Juice 3.05% 9
Black Tea 2.93% 10
Total Sales CLASS OF
ICM TMC TMR TMCM Categories
% MENU

Pop. CM

30,830 162,720 656,000 493,280 13.35% HIgh


28,230 - - - 0.00%
31,420 95,800 410,000 314,200 8.34% High
33,830 57,360 328,000 270,640 6.67% High
4,706 - - - 0.00%
- - - -
129,016 315,880 1,394,000 1,078,120 28.37%

21,800 - - - 0.00%
21,800 - - - 0.00%
21,800 13,200 144,000 130,800 2.93% HIgh
21,800 11,000 120,000 109,000 2.44% HIgh
21,480 5,040 48,000 42,960 0.98% High
21,800 - - - 0.00%
21,800 - - - 0.00%
152,280 29,240 312,000 282,760 6.35%

85,374 - - - 0.00%
79,616 - - - 0.00%
113,579 - - - 0.00%
115,761 - - - 0.00%
394,331 - - - 0.00%

26,300 3,700 30,000 26,300 0.61% Low Low Dog


25,356 18,578 120,000 101,422 2.44% High Low Workhorse
51,656 22,278 150,000 127,722 3.05%

24,143 - - - 0.00%
24,307 - - - 0.00%
24,364 13,908 87,000 73,092 1.77% HIgh Low Workhorse
26,312 - - - 0.00%
13,792 54,360 675,000 620,640 13.74% HIgh Low Workhorse
24,505 17,980 116,000 98,020 2.36% HIgh Low Workhorse
22,546 - - - 0.00%
21,350 - - - 0.00%
0.00%
21,400 111,800 390,000 278,200 7.94% HIgh Low Workhorse
25,200 24,000 150,000 126,000 3.05% High Low Workhorse
227,919 222,048 1,418,000 1,195,952 28.86%

36,460 - - - 0.00%
40,437 - - - 0.00%
40,210 - - - 0.00%
117,107 - - - 0.00%

29,200 - - - 0.00%
28,641 - - - 0.00%
28,991 - - - 0.00%
29,150 - - - 0.00%
28,490 - - - 0.00%
28,551 - - - 0.00%
173,023 - - - 0.00%

30,331 - - - 0.00%
33,836 - - - 0.00%
32,119 7,881 40,000 32,119 0.81% Low High Challenge
33,053 - - - 0.00%
33,430 - - - 0.00%

41,979 136,362 850,000 713,638 17.30% HIgh HIgh Star


43,211 74,680 550,000 475,320 11.19% HIgh HIgh Star
45,621 - - - 0.00%
45,769 4,231 50,000 45,769 1.02% Low High Challenge
45,955 - - - 0.00%
44,809 - - - 0.00%
46,093 11,722 150,000 138,278 3.05% High High Star
47,260 - - - 0.00%
46,011 - - - 0.00%
46,147 - - - 0.00%
42,953 - - - 0.00%
41,903 - - - 0.00%
48,309 - - - 0.00%
748,787 234,877 1,640,000 1,405,123 33.37%
824,322.58 4,914,000.00 4,089,677.42 100%

26,385
16.77%
Actual
10.50%
Difference
6.27%
Period: NOV 2020
Popularity
Menu # Sold
MM %
RS TRR CLB PPB
Tos Raos Specialties
Sop Buntut 5 2.30%
Nasi Tutug Oncom 0.00%
Ayam Kampung Kalasan 0.00%
Tongseng Kambing 0.00%
Sate Campur Pelangi 0.00%
Opor Ayam 0.00%
Nasi Galor Komplit 0.00%
Ayam Lada Garam 0.00%
Soto Bandung 0.00%
Sop Iga Garang Asam 0.00%
Hainan Chicken Rice 0.00%
Sub Total 5 0 0 0 2.30%

For Your Appetite


Gado-gado Braga 0.00%
Tropical Slice Fruit 1 0.46%
Chef's Salad 0.00%
Thai Beef Salad 0.00%
Chicken Caesar Salad 0.00%
Karedok 0.00%
Greek Salad 0.00%
Sub Total 1 0 0 0 0.46%

Soup's Up
Wild Mushroom Cream Soup 0.00%
Tom Yum Goong 0.00%
Chicken Corn Soup 0.00%
Soto Karuhun 0.00%
Choice of Cream Soup 0.00%
Soup Selection of Chef 0.00%
Sub Total 0 0 0 0 0.00%

Burger & Sandwiches


Cheese Burger 0.00%
Barbeque Steak Sandwich 0.00%
The Aston Club Sandwich 0.00%
Aston Club Lama 0.00%
Tuna Sandwich 0.00%
Tuna Melt 0.00%
Smoked Salmon Sandwich 0.00%
Sub Total 0 0 0 0 0.00%

The Fried-Rice
Nasi Goreng Tos Raos 0.00%
Nasi Goreng Jambal 0.00%
Nasi Goreng Seafood Oriental / Nasi Goreng Bahari 5 2.30%
Hokkian Fried Rice 0.00%
Nasi Goreng Kambing 0.00%
Nasi Goreng Thailand 0.00%
Fried Noodle 0.00%
Mie, Kwetiaw or Bihun (Noodles) 17 7.83%
Cruncy Seafood Noodle 0.00%
Char Beef Kwetiaw 0.00%
Sub Total 22 0 0 0 10.14%

Pasta-Fiesta
Carbonara 1 0.46%
Seafood Tomato 0.00%
Bolognaise 0.00%
Aglio Olio 0.00%
Spicy Tuna 0.00%
Al Pesto 0.00%
Napolitaine 0.00%
Sub Total 0.46%

Our Charcoal Grill


Barbeque Ranch Chicken 0.00%
Lamb Rack 0.00%
Sirloin Steak 0.00%
Grilled Salmon Pasta 0.00%
Chicken 0.00%
French Fries 4 1.84%
Sausage Fries 8 3.69%
Sub Total 12 0 0 0 5.53%

The Sweet Thing


Chocolate Melted 0.00%
Cream Caramel puding 0.00%
Pisang Goreng 13 5.99%
Singkong ala Thai 0.00%
Avocado Cake 0.00%
Rappan Ice Cream 0.00%
Scoop of Ice Cream 0.00%
Exotic Tropical Fruit 0.00%
MENU ROOM SERVICE NEW
Appetizers & Salad
Lotek Buah Batu 0.00%
Batagor Burangrang 21 9.68%
Baso Tahu Padalarang 8 3.69%
0.00%
Ketan Bakar Lembang 0.00%
Perkedel Stasiun 0.00%
Chicken Wing Suniaraja 0.00%
Sub Total 42 0 0 0 19.35%
Soup
Mie Kocok Kosambi 0.00%
Sup Iga Banceuy 22 10.14%
Mie Baso Cikudapateuh 0.00%
Sub Total 22 0 0 0 10.14%
Mains Dishes
Nasi Tutug Oncom Ciwidey 0.00%
Sate Campur Maranggi 0.00%
Nasi Timbel Kemuning 0.00%
Mie or Bihun Goreng Naripan 0.00%
Fish and Chip Viaduct 1 0.46%
Nasi Goreng Cihampelas 51 23.50%
Nasi Gila Cipaganti 11 5.07%
Tos Raos Steak 0.00%
Bubur Ayam Asia Afrika 14 6.45%
Sub Total 77 0 0 0 35.48%
Dessert
Steamed Rice 31 14.29%
Cendol Tegalega 0.00%
Roti Bakar Cibadak 5 2.30%
Sub Total 36 0 0 0 16.59%
GRAND TOTAL 217 0 0 0 100%
MM % 217 0.83%
AMCM
Total Food Cost

TOP TEN BEST SELLER PERIOD NOV 2020


Nasi Goreng Cihampelas 31.19% 1
Sup Iga Banceuy 13.45% 2
Mie, Kwetiaw or Bihun (Noodles) 9.65% 3
Batagor Burangrang 9.17% 4
Nasi Gila Cipaganti 6.73% 5
Pisang Goreng 5.11% 6
Bubur Ayam Asia Afrika 4.28% 7
Sop Buntut 3.93% 8
Baso Tahu Padalarang 3.49% 9
Steamed Rice 3.25% 10
Cost Price Sell Price Rest Total Sales
ICM TMC TMR TMCM
IFC ISP %

21,253 90,000 68,747 106,266 450,000 343,734 3.93%


14,260 70,000 55,740 - - - 0.00%
23,582 65,000 41,418 - - - 0.00%
9,431 70,000 60,569 - - - 0.00%
30,222 70,000 39,778 - - - 0.00%
10,937 65,000 54,063 - - - 0.00%
8,519 65,000 56,481 - - - 0.00%
10,889 65,000 54,111 - - - 0.00%
17,317 65,000 47,683 - - - 0.00%
17,710 65,000 47,290 - - - 0.00%
10,241 85,000 74,759 - - - 0.00%
174,362 775,000 600,638 106,266 450,000 343,734 3.93%

9,006 40,000 30,994 - - - 0.00%


10,302 45,000 34,698 10,302 45,000 34,698 0.39%
15,164 65,000 49,836 - - - 0.00%
23,559 50,000 26,441 - - - 0.00%
22,056 65,000 42,944 - - - 0.00%
4,401 40,000 35,599 - - - 0.00%
17,370 40,000 22,630 - - - 0.00%
101,858 345,000 243,142 10,302 45,000 34,698 0.39%

17,649 65,000 47,351 - - - 0.00%


20,611 65,000 44,389 - - - 0.00%
13,571 65,000 51,429 - - - 0.00%
10,159 32,321 22,162 - - - 0.00%
11,561 65,000 53,439 - - - 0.00%
17,649 40,000 22,351 - - - 0.00%
91,201 332,321 241,120 - - - 0.00%

21,142 75,000 53,858 - - - 0.00%


20,166 65,000 44,834 - - - 0.00%
21,068 75,000 53,932 - - - 0.00%
14,524 65,000 50,476 - - - 0.00%
20,540 65,000 44,460 - - - 0.00%
17,049 65,000 47,951 - - - 0.00%
26,197 60,000 33,803 - - - 0.00%
140,686 470,000 329,314 - - - 0.00%

7,259 65,000 57,741 - - - 0.00%


10,446 65,000 54,554 - - - 0.00%
21,974 70,000 48,026 109,870 350,000 240,130 3.06%
15,654 60,000 44,346 - - - 0.00%
13,406 70,000 56,594 - - - 0.00%
25,947 65,000 39,053 - - - 0.00%
0.00%
15,375 65,000 49,625 261,374 1,105,000 843,626 9.65%
22,775 60,000 37,225 - - - 0.00%
12,039 65,000 52,961 - - - 0.00%
144,875 585,000 440,125 371,245 1,455,000 1,083,755 12.71%

20,051 70,000 49,949 20,051 70,000 49,949 0.61%


15,908 70,000 54,092 - - - 0.00%
16,078 75,000 58,922 - - - 0.00%
9,815 75,000 65,185 - - - 0.00%
18,711 75,000 56,289 - - - 0.00%
15,494 60,000 44,506 - - - 0.00%
11,025 75,000 63,975 - - - 0.00%
107,084 500,000 392,916 20,051 70,000 49,949 0.61%

20,062 80,000 59,938 - - - 0.00%


44,181 160,000 115,819 - - - 0.00%
47,033 160,000 112,967 - - - 0.00%
29,343 160,000 130,657 - - - 0.00%
20,506 130,000 109,494 - - - 0.00%
8,280 25,000 16,720 33,120 100,000 66,880 0.87%
12,582 35,000 22,418 100,656 280,000 179,344 2.45%
181,987 750,000 568,013 133,776 380,000 246,224 3.32%

19,429 45,000 25,571 - - - 0.00%


6,085 45,000 38,915 - - - 0.00%
10,132 45,000 34,868 131,722 585,000 453,278 5.11%
9,970 35,000 25,030 - - - 0.00%
18,699 60,000 41,301 - - - 0.00%
11,271 40,000 28,729 - - - 0.00%
14,535 35,000 20,465 - - - 0.00%
3,418 50,000 46,582 - - - 0.00%
8,701 35,000 26,299 - - - 0.00%
17,530 50,000 32,470 368,135 1,050,000 681,865 9.17%
22,000 50,000 28,000 176,000 400,000 224,000 3.49%
18,805 50,000 31,195 - - - 0.00%
8,568 25,000 16,432 - - - 0.00%
7,089 25,000 17,911 - - - 0.00%
10,590 45,000 34,410 - - - 0.00%
186,821 635,000 448,179 675,857 2,035,000 1,359,143 17.78%

8,925 40,000 31,075 - - - 0.00%


24,043 70,000 45,957 528,956 1,540,000 1,011,044 13.45%
9,233 40,000 30,767 - - - 0.00%
42,202 150,000 107,798 528,956 1,540,000 1,011,044 13.45%

12,474 70,000 57,526 - - - 0.00%


42,221 75,000 32,779 - - - 0.00%
5,952 70,000 64,048 - - - 0.00%
4,263 70,000 65,737 - - - 0.00%
20,097 70,000 49,903 20,097 70,000 49,903 0.61%
9,445 70,000 60,555 481,683 3,570,000 3,088,317 31.19%
13,101 70,000 56,899 144,109 770,000 625,891 6.73%
47,642 170,000 122,358 - - - 0.00%
6,344 35,000 28,656 88,823 490,000 401,177 4.28%
161,539 700,000 538,461 734,712 4,900,000 4,165,288 42.81%

3,400 12,000 8,600 105,400 372,000 266,600 3.25%


4,470 25,000 20,530 - - - 0.00%
4,020 40,000 35,980 20,100 200,000 179,900 1.75%
11,890 77,000 65,110 125,500 572,000 446,500 5.00%
2,706,665.04 11,447,000.00 8,740,334.96 100%

40,278
30.10%
Actual
31.06%
Difference
-0.96%
CLASS OF
Categories
MENU

Pop. CM

High High Star

Low Low Dog


High HIgh Star

HIgh High Star

Low High Challenge

High Low Workhorse


HIgh Low Workhorse

High Low Workhorse


HIgh Low Workhorse
HIgh Low Workhorse

HIgh High Star

Low High Challenge


HIgh HIgh Star
High High Star

High Low Workhorse

HIgh Low Workhorse

HIgh Low Workhorse

You might also like