Report
kayee95
MeunEngineeringreport.xlsxMains
| 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 | |||||||||||
| Whiskey smoked ribeye | 1 | 0.28% | $14.83 | $42.00 | $27.17 | $14.83 | [$$]42.00 | $27.17 | high | low | challenge |
| fennel crusted tuna | 19 | 5.26% | $11.82 | $34.42 | $22.60 | $224.58 | [$$]654.00 | $429.42 | high | high | Star |
| cauliflower vadouvan curry w/ quinoa pilaf | 84 | 23.24% | $13.20 | $28.00 | $14.80 | $1,108.80 | [$$]2,352.00 | $1,243.20 | high | high | Star |
| edamame hummus | 149 | 41.23% | $8.40 | $14.00 | $5.60 | $1,251.60 | [$$]2,086.00 | $834.40 | low | high | Workhorse |
| Cost | Revenue | Profit | |||||||||
| Total | 253 | 70.00% | $2,599.81 | $5,134.00 | $2,534.19 | ||||||
| Food Cost % | Ave Item Profit | ||||||||||
| 50.64% | NT$10.02 | ||||||||||
| (100% / Items) * (80%) | |||||||||||
| 50.60 | |||||||||||
| Menu Popularity Factor | |||||||||||
| Done By: All member | |||||||||||
| Checked by:All member | |||||||||||
Apps
| 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 | |||||||||||||
| crunch garlic - sweet and sour sauce wings | 250 | 40.89% | $1.71 | $17.00 | $15.29 | $427.50 | [$$]4,250.00 | $3,822.50 | high | high | star | ||
| Tempura | 178 | 29.11% | $7.65 | $18.00 | $10.35 | $1,361.70 | [$$]3,204.00 | $1,842.30 | low | high | workhorse | Missing the cost for what's in the tempura | |
| Cripsy Brussels Sprouts | $6.43 | $9.00 | $2.57 | ||||||||||
| Truffle french fries | 359 | 58.71% | $13.00 | $4,667.00 | |||||||||
| truffle fries? | |||||||||||||
| Brussel Sprouts? | |||||||||||||
| BURRATA BRUSCHETTA? | |||||||||||||
| Cost | Revenue | Profit | |||||||||||
| Total | 428 | 70.00% | $1,789.20 | $7,454.00 | $5,664.80 | ||||||||
| Food Cost % | Avg Item Profit | ||||||||||||
| 24.00% | NT$13.24 | ||||||||||||
| (100% / Items) * (80%) | |||||||||||||
| 0.19% | |||||||||||||
| Menu Popularity Factor | |||||||||||||
| Done By:All member | |||||||||||||
| Checked by:All member | |||||||||||||
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 | |||||||||||||||
| tuna poke | 259 | 46.02% | $12.79 | $18.00 | $5.21 | $3,312.61 | [$$]4,662.00 | $1,349.39 | low | high | Workhorse | ||||
| castro greens salad | 135 | 23.98% | $4.51 | $23.82 | $19.31 | $608.85 | [$$]3,216.00 | $2,607.15 | high | high | star | ||||
| . | |||||||||||||||
| Cost | Revenue | Profit | |||||||||||||
| Total | 394 | 70.00% | $3,921.46 | $7,878.00 | $3,956.54 | ||||||||||
| Food Cost % | Avg Item Profit | ||||||||||||||
| 49.78% | NT$10.04 | ||||||||||||||
| (100% / Items) * (80%) | |||||||||||||||
| 0.20% | |||||||||||||||
| Menu Popularity Factor | |||||||||||||||
| Done By:All member | |||||||||||||||
| Checked by:All member | |||||||||||||||
