Write a recommendation
zhaoyishou
menuengineeringstanfordcourtupdates.xlsxSmall Bites
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu | ||||
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |||||
| ITEM | |||||||||||||||
| San Francisco Clam Chowder | 256 | 26.45% | $6.73 | $14.00 | $7.27 | $1,722.88 | $3,584.00 | $1,861.12 | High | High | Star | Why did you separate all of the sections on the menu when doing menu engineering. Is that tru in the mind of the consumer, most probably not. Need to re organize the groups to more accurately investigate. | |||
| Hummus Platter | 498 | 51.45% | $1.44 | $12.00 | $10.56 | $717.12 | $5,976.00 | $5,258.88 | High | High | Star | Some prices don't match your costing because the costing needs revision. | |||
| Warm Sourdough Bread | 99 | 10.23% | $0.47
: Ryan Smith: Problem |
$6.00 | $5.53 | $46.53 | $594.00 | $547.47 | Low | Low | Dog | calculations are correct but needs the quick revision from above | |||
| Mixed Field Greens Half | 115 | 11.88% | $1.26 | $5.00 | $3.75 | $144.33 | $575.00 | $430.68 | Low | Low | Dog | ||||
| Cost | Revenue | Profit | |||||||||||||
| Total | 968 | 100.00% | $2,630.86 | $10,729.00 | $8,098.15 | ||||||||||
| Food Cost % | Ave Item Profit | ||||||||||||||
| 24.52% | $ 6.78 | ||||||||||||||
| (100% / Items) * (80%) | |||||||||||||||
| 193.60 | |||||||||||||||
| Menu Popularity Factor | |||||||||||||||
| Done By: | Vanessa | Megan | Lizsandra | Brandon | |||||||||||
| Checked by: | Megan | ||||||||||||||
Small-Medium Bites
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu |
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |
| ITEM | |||||||||||
| Basil Chicken Bites | 460 | 60.61% | $4.37 | $11.00 | $6.63 | $2,010.20 | $5,060.00 | $3,049.80 | Low | High | Plowhorse |
| Crispy Fried Calamari | 164 | 21.61% | $2.69 | $12.00 | $9.31 | $441.16 | $1,968.00 | $1,526.84 | High | Low | Puzzle |
| Mixed Field Greens Full | 135 | 17.79% | $2.51 | $10.00 | $7.49 | $338.85 | $1,350.00 | $1,011.15 | Low | Low | Dog |
| Cost | Revenue | Profit | |||||||||
| Total | 759 | 100.00% | $2,790.21 | $8,378.00 | $5,587.79 | ||||||
| Food Cost % | Ave Item Profit | ||||||||||
| 33.30% | $ 7.81 | ||||||||||
| (100% / Items) * (80%) | |||||||||||
| 202.40 | |||||||||||
| Menu Popularity Factor | |||||||||||
| Done By: | Vanessa | Lizsandra | Brandon | ||||||||
| Checked by: | Megan | ||||||||||
Medium Bites
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu |
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |
| ITEM | |||||||||||
| The Triple Dip | 206 | 20.52% | $1.13 | $13.00 | $11.87 | $232.78 | $2,678.00 | $2,445.22 | High | High | Star |
| Grilled Sausage Sampler | 123 | 12.25% | $3.41 | $16.00 | $12.59 | $419.43 | $1,968.00 | $1,548.57 | High | Low | Puzzle |
| TSC Seasonal Pizza | 458 | 45.62% | $8.97 | $14.00 | $5.03 | $4,108.26 | $6,412.00 | $2,303.74 | Low | High | Plowhorse |
| California Charcuterie and Local Artisan Cheese Plate | 217 | 21.61% | $10.89
: Ryan Smith: doesn't match |
$15.00 | $4.11 | $2,363.13 | $3,255.00 | $891.87 | Low | High | Plowhorse |
| Cost | Revenue | Profit | |||||||||
| Total | 1004 | 100.00% | $7,123.60 | $14,313.00 | $7,189.40 | ||||||
| Food Cost % | Ave Item Profit | ||||||||||
| 49.77% | $ 8.40 | ||||||||||
| (100% / Items) * (80%) | |||||||||||
| 200.80 | |||||||||||
| Menu Popularity Factor | |||||||||||
| Done By: | Vanessa | Brandon | |||||||||
| Checked by: | Megan | ||||||||||
Salads
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu |
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |
| ITEM | |||||||||||
| Caprese Salad | 166 | 17.72% | $4.75 | $13.00 | $8.25 | $788.50 | $2,158.00 | $1,369.50 | High | Low | Puzzle |
| Caesar Salad | 394 | 42.05% | $6.46 | $12.00 | $5.54 | $2,545.24 | $4,728.00 | $2,182.76 | High | High | Plowhorse |
| Harvest Cobb | 353 | 37.67% | $15.82 | $14.00 | ($1.82) | $5,584.46 | $4,942.00 | ($642.46) | Low | High | Plowhorse |
| Shrimp Tempura | 24 | 2.56% | $7.13 | $14.00 | $6.87 | $171.12 | $336.00 | $164.88 | High | Low | Puzzle |
| Cost | Revenue | Profit | |||||||||
| Total | 937 | 100.00% | $9,089.32 | $12,164.00 | $3,074.68 | ||||||
| Food Cost % | Ave Item Profit | ||||||||||
| 0.747231174 | $4.71 | ||||||||||
| (100% / Items) * (80%) | |||||||||||
| 187.40 | |||||||||||
| Menu Popularity Factor | |||||||||||
| Done By: | Eriko | Megan | Zhaoyi | ||||||||
| Checked by: | Megan | ||||||||||
Sandwiches-Big Bites
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu | ||
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |||
| ITEM | |||||||||||||
| Nob Hill Club | 788 | 56.69% | $2.85 | $15.00 | $12.15 | $2,245.80 | $11,820.00 | $9,574.20 | High | High | Star | ||
| Classic Italian Sub | 139 | 10.00% | $7.65 | $14.00 | $6.35 | $1,063.35 | $1,946.00 | $882.65 | Low | Low | Dog | costs again | |
| Signature Beef Sando | 82 | 5.90% | $2.13 | $16.00 | $13.87 | $174.66 | $1,312.00 | $1,137.34 | High | Low | Puzzle | ||
| Mac & Cheese | 381 | 21.67% | $1.67 | $12.00 | $10.33 | $636.27 | $4,572.00 | $3,935.73 | Low | High | Plowhorse | ||
| Cost | Revenue | Profit | |||||||||||
| Total | 1390 | 94.26% | $4,120.08 | $19,650.00 | $15,529.92 | ||||||||
| Food Cost % | Ave Item Profit | ||||||||||||
| 0.2096732824 | $10.68 | ||||||||||||
| (100% / Items) * (80%) | |||||||||||||
| 278.00 | |||||||||||||
| Menu Popularity Factor | |||||||||||||
| Done By: | Zhaoyi | Lizsandra | |||||||||||
| Checked by: | Megan | ||||||||||||
Big Bites
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu |
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |
| ITEM | |||||||||||
| Tony Burger | 1068 | 60.75% | $27.82 | $20.00 | ($7.82) | $29,711.76 | $21,360.00 | ($8,351.76) | Low | High | Plowhorse |
| Grilled Salmon | 406 | 23.09% | $23.46 | $25.00 | $1.54 | $9,524.76 | $10,150.00 | $625.24 | Low | High | Plowhorse |
| Meyer Lemon Chicken | 214 | 12.17% | $5.26 | $22.00 | $16.74 | $1,125.64 | $4,708.00 | $3,582.36 | High | Low | Puzzle |
| Orange Glazed BBQ Pork Ribs Half Slab | 52 | 2.96% | $1.96 | $18.00 | $16.04 | $101.92 | $936.00 | $834.08 | High | Low | Puzzle |
| Orange Glazed BBQ Pork Ribs Full Slab | 18 | 1.02% | $3.92 | $26.00 | $22.08 | $70.56 | $468.00 | $397.44 | High | Low | Puzzle |
| Cost | Revenue | Profit | |||||||||
| Total | 1758 | 100.00% | $40,534.64 | $37,622.00 | ($2,912.64) | ||||||
| Food Cost % | Ave Item Profit | ||||||||||
| 1.077418532 | $9.72 | ||||||||||
| (100% / Items) * (80%) | |||||||||||
| 281.28 | |||||||||||
| Menu Popularity Factor | |||||||||||
| Done By: | Megan | Brandon | Eriko | Lizsandra | |||||||
| Checked by: | Megan | ||||||||||
Desserts
| Menu Item Name | Number | Popularity | Item Food | Item Sell | Item | Total | Total | Total | Profit | Popularity | Menu |
| Sold | % | Cost | Price | Profit | Cost | Revenue | Profit | Category | Category | Item Class | |
| ITEM | |||||||||||
| Tiramisu | 192 | 53.33% | $1.99 | $12.00 | $10.01 | $382.08 | $2,304.00 | $1,921.92 | High | High | Star |
| Chocolate Bomb | 168 | 46.67% | $3.62 | $13.00 | $9.38 | $608.16 | $2,184.00 | $1,575.84 | Low | High | Plowhorse |
| Cost | Revenue | Profit | |||||||||
| Total | 360 | 100.00% | $990.24 | $4,488.00 | $3,497.76 | ||||||
| Food Cost % | Ave Item Profit | ||||||||||
| 0.2206417112 | $9.70 | ||||||||||
| (100% / Items) * (80%) | |||||||||||
| 144.00 | |||||||||||
| Menu Popularity Factor | |||||||||||
| Done By: | Eriko | ||||||||||
| Checked by: | Megan | ||||||||||
