hospitality assignment
aqnaboy0y1
Menuanalysis.xlsxA La Carte
| Name | Qty. | Qty. | UOM | Cost | |
| Entrée | |||||
| 1 | Pork & Prawn Gyoza (6 PCS per Serve) | 5 | |||
| All Purpose Flour | 270 | 54 | g. | 0.05 | |
| Warm Water | 135 | 27 | ml. | 0.02 | |
| Salt | 1/4 | 1 | Tsp | 0.01 | |
| Mince Pork | 210 | 10 | g. | 0.07 | |
| Mince Prawn | 90 | 10 | g. | 0.27 | |
| Savoy Cabbage | 210 | 10 | g. | 0.01 | |
| Garlic | 3 | 0.6 | Cloves | 0.01 | |
| Cheives | 60 | 10 | g. | 0.01 | |
| Soy Sauce (Shoyu) | 3 | 0.6 | Tsp | 0.01 | |
| Oyster Sauce | 3 | 0.6 | Tsp | 0.01 | |
| Sugar | 1 | 0.2 | Tsp | 0.01 | |
| White Pepper | 1/2 | 0.0166666667 | Tsp | 0.01 | |
| Potato Starch | 2 | 0.4 | Tsp | 0.01 | |
| Sesami Oil | 1 | 0.2 | Tsp | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.50 | ||||
| Selling Price | 1.67 | ||||
| 2 | Vegetable Spring Rolls (5 PCS per Serve) (V) | 4 | |||
| Vermicelli Noodle | 100 | 25 | g. | 0.15 | |
| Vegetable Oil | 1 | 1 | Tsp | 0.01 | |
| Garlic | 2 | 0.5 | Cloves | 0.01 | |
| Carrot (grated) | 100 | 25 | g. | 0.03 | |
| Cabbage (grated) | 100 | 25 | g. | 0.03 | |
| Soy Sauce (Vegetarian) | 1 | 0.25 | Tsp | 0.01 | |
| White Pepper | 1/4 | 0.25 | Tsp | 0.01 | |
| Sugar | 1 | 0.25 | Tsp | 0.01 | |
| Sesami Oil | 1/2 | 0.25 | Tsp | 0.01 | |
| Corn Flour | 2 | 1 | Tsp | 0.01 | |
| Tofu (Hard) Chop | 100 | 25 | g. | 0.33 | |
| Frozen spring roll wrappers (21.5 cm) | 20 | 5 | PCS | 0.20 | |
| Sweet Chilli Sauce | 30 | ml. | 0.05 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.87 | ||||
| Selling Price | 2.89 | ||||
| 3 | Chicken Soup (Clear Soup) (GF) | 4 | |||
| Chicken Breast | 800 | 200 | g. | 1.80 | |
| Brown Onion (Chop) | 50 | 12.5 | g. | 0.02 | |
| Carrot (Chop) | 100 | 25 | g. | 0.03 | |
| Daikon (Chop) | 100 | 25 | g. | 0.03 | |
| Potato (Chop) | 100 | 25 | g. | 0.02 | |
| Coriander Root | 2 | 0.5 | Root | 0.01 | |
| Coriander (Chop) | 2 | 0.5 | Tbsp | 0.01 | |
| Whole Black peppercorn | 1/2 | 0.125 | Tsp | 0.01 | |
| Salt | 1/4 | 0.0625 | Tsp | 0.01 | |
| Garlic | 2 | 0.5 | Cloves | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.95 | ||||
| Selling Price | 6.49 | ||||
| 4 | Beef Noodle Salad (Cold) (GF) | ||||
| Beef Rib Eye (Grilled) | 150 | 150 | g. | 3.45 | |
| Soba Noodle (GF) | 200 | 180 | g. | 0.60 | |
| White Sesami | 10 | 10 | g. | 0.01 | |
| Black Sesami | 10 | 10 | g. | 0.01 | |
| Pumpkin Seed | 10 | 10 | g. | 0.01 | |
| Carrot (shredded) | 30 | 30 | g. | 0.02 | |
| Zuchini (shredded) | 30 | 30 | g. | 0.02 | |
| Daikon (pickle) | 30 | 30 | g. | 0.03 | |
| Spring Onion (Chop) | 10 | 10 | g. | 0.01 | |
| Coriander (Chop) | 10 | 10 | g. | 0.01 | |
| Soy Sauce (Shoyu) | 1 | 1 | Tbsp | 0.01 | |
| Sesami Oil | 1 | 1 | Tsp | 0.01 | |
| White pepper | 1/4 | 1/4 | Tsp | 0.01 | |
| Sugar | 1/2 | 1/2 | Tsp | 0.01 | |
| Mirin | 1 | 1 | Tbsp | 0.01 | |
| Japanese Dressing | 2 | 2 | Tbsp | 0.02 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 4.23 | ||||
| Selling Price | 14.12 | ||||
| 5 | Seafood Okonomiyaki | ||||
| Prawn | 20 | 20 | g. | 0.54 | |
| Mussel | 20 | 20 | g. | 0.30 | |
| Octopus | 20 | 20 | g. | 0.36 | |
| Calamari Ring | 20 | 20 | g. | 0.22 | |
| Chicken Stock | 80 | 80 | ml. | 0.02 | |
| Egg | 1 | 1 | Egg | 0.20 | |
| Cabbage | 100 | 100 | g. | 0.20 | |
| Carrot | 100 | 100 | g. | 0.20 | |
| Spring Onion | 10 | 10 | g. | 0.01 | |
| Kewpie Mayonnaise | 15 | 15 | ml. | 0.01 | |
| Katsuoboshi (Benito Flake) | 10 | 10 | g. | 0.01 | |
| Okonomiyaki Sauce | 15 | 15 | ml. | 0.01 | |
| Aonori (Seaweed Flake) | 10 | 10 | g. | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 2.09 | ||||
| Selling Price | 6.97 | ||||
| Main | |||||
| 1 | BBQ Pork on Sticky Rice and Salad | ||||
| Pork Neck | 250 | 250 | g. | 2.50 | |
| Sticky Rice | 100 | 80 | g. | 0.20 | |
| Coriander Seed | 10 | 10 | g. | 0.01 | |
| Coriender Root | 10 | 10 | g. | 0.01 | |
| Whole White Peppercorn | 10 | 10 | g. | 0.01 | |
| Garlic | 10 | 10 | g. | 0.01 | |
| Palm Sugar | 20 | 20 | g. | 0.01 | |
| Oyster Sauce | 2 | 2 | Tbsp | 0.01 | |
| Soy Sauce | 2 | 2 | Tbsp | 0.01 | |
| Papaya | 30 | 30 | g. | 0.08 | |
| Cherry Tomato | 30 | 30 | g. | 0.04 | |
| Carrot | 30 | 30 | g. | 0.02 | |
| Coriander (Chop) | 10 | 10 | g. | 0.01 | |
| Lime Juice | 1 | 1 | Tbsp | 0.01 | |
| Fish Sauce | 1 | 1 | Tbsp | 0.01 | |
| Penut | 10 | 10 | g. | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 2.95 | ||||
| Selling Price | 9.83 | ||||
| 2 | Salmon Steak with Teriyaki and Stream Vegetable | ||||
| Salmon Fillet | 300 | 300 | g. | 7.50 | |
| Mirin | 1 | 1 | Tbsp | 0.01 | |
| Soy Sauce | 3 | 3 | Tbsp | 0.01 | |
| Sugar | 1 | 1 | Tbsp | 0.01 | |
| Carrot (Julian) | 30 | 30 | g. | 0.02 | |
| Blocoli | 30 | 30 | g. | 0.02 | |
| Coliflower | 30 | 30 | g. | 0.02 | |
| Capsicum (Red) | 10 | 10 | g. | 0.01 | |
| White Pepper | 1/4 | 1/4 | Tsp | 0.10 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 7.70 | ||||
| Selling Price | 25.67 | ||||
| 3 | Seafood Pineapple Fried Rice | ||||
| Rice (cold) | 200 | 200 | g. | 0.30 | |
| Pineapple | 30 | 30 | g. | 0.02 | |
| Carrot | 30 | 30 | g. | 0.02 | |
| Blocoli | 30 | 30 | g. | 0.03 | |
| Cashew Nut | 20 | 20 | g. | 0.02 | |
| Prawn | 50 | 50 | g. | 1.35 | |
| Calamari | 50 | 50 | g. | 0.60 | |
| Mussel | 50 | 50 | g. | 0.75 | |
| Egg | 1 | 1 | Egg | 0.15 | |
| Soy Sauce | 1 | 1 | Tsp | 0.01 | |
| Black soy sauce | 1 | 1 | Tsp | 0.01 | |
| Oyster Sauce | 1 | 1 | Tsp | 0.01 | |
| White Pepper | 1/4 | 1/4 | Tsp | 0.01 | |
| Sugar | 1/4 | 1/4 | Tsp | 0.01 | |
| Garlic | 1 | 1 | Clove | 0.01 | |
| Coriander | 10 | 10 | g. | 0.01 | |
| Lemon (Wage) | 0.01 | ||||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 3.32 | ||||
| Selling Price | 11.07 | ||||
| 4 | Chicken on Rice with Fried Egg (GF) | ||||
| Chicken Breast (Dice Chop) | 100 | 100 | g. | 0.90 | |
| Egg | 1 | 1 | Egg | 0.15 | |
| Chinese sausage | 50 | 50 | g. | 0.10 | |
| Carrot | 50 | 50 | g. | 0.03 | |
| Shitake Mushroom | 30 | 30 | g. | 0.05 | |
| Baby Corn | 30 | 30 | g. | 0.02 | |
| Stream Rice | 200 | 200 | g. | 0.20 | |
| Oyster Sauce | 1 | 1 | Tsp | 0.01 | |
| Soy Sauce | 1 | 1 | Tsp | 0.01 | |
| Sesami Oil | 1 | 1 | Tsp | 0.01 | |
| Corn Flour (GF) | 1 | 1 | Tbsp | 0.01 | |
| Vegetable Oil | 1 | 1 | Tsp | 0.01 | |
| Black soy sauce | 1 | 1 | Tsp | 0.01 | |
| Sugar | 1/2 | 1/2 | Tsp | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.52 | ||||
| Selling Price | 5.07 | ||||
| 5 | Vegetable Tempura with Soba Noodle [Cold] (V) | ||||
| Soba Noodle (GF) | 200 | 180 | g. | 0.60 | |
| Nori | 50 | 50 | g. | 0.02 | |
| Plain Flour | 1/4 | 1/4 | Cup | 0.01 | |
| Corn Flour | 1/4 | 1/4 | Cup | 0.01 | |
| Bicabonate Soda | 8 | 2 | g. | 0.00 | |
| Egg | 1 | 1 | Egg | 0.15 | |
| Soda Water (Chilled) | 1/4 | 1/4 | Cup | 0.00 | |
| Carrot | 120 | 40 | g. | 0.02 | |
| Egg Plant | 120 | 40 | g. | 0.02 | |
| Sweet Potato | 120 | 40 | g. | 0.02 | |
| Pumpkin | 120 | 40 | g. | 0.03 | |
| Baby Corn | 120 | 40 | g. | 0.03 | |
| Asparagus | 120 | 40 | g. | 0.02 | |
| Black Sesami | 20 | 10 | g. | 0.01 | |
| Japanese Noodle Soy Sauce | 200 | 50 | ml. | 0.02 | |
| Vegetable Oil for fried | 0.00 | ||||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.96 | ||||
| Selling Price | 3.21 | ||||
| Dessert | |||||
| 1 | Green Tea Mousse with Red Bean Paste (GF) | 7 | |||
| White Chocolate Compound | 210 | 30 | g. | 0.21 | |
| Green Tea Powder | 10 | g. | 1.00 | ||
| Butter (Melted) | 21 | 3 | g. | 0.02 | |
| Vanila Extract | 1 | 0.1428571429 | Tsp | 0.06 | |
| Thickened Cream | 375 | 53.5714285714 | ml. | 0.19 | |
| Egg | 3 | 0.4285714286 | Egg | 0.08 | |
| Red Bean | 140 | 20 | g. | 0.13 | |
| Custer Sugar | 70 | 10 | g. | 0.02 | |
| Salt | 8 | 1.1428571429 | g. | 0.00 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.70 | ||||
| Selling Price | 5.66 | ||||
| 2 | Brownie with Green Tea Ice Cream | 9 | |||
| Brown Sugar | 130 | 14.4444444444 | g. | 0.04 | |
| Custa Sugar | 110 | 12.2222222222 | g. | 0.02 | |
| Cocoa Powder | 75 | 8.3333333333 | g. | 0.06 | |
| All Purpose Flour | 75 | 8.3333333333 | g. | 0.01 | |
| Baking Powder | 1/4 | 0.0277777778 | Tsp | 0.04 | |
| Unsalted Butter (Melted) | 150 | 16.6666666667 | g. | 0.08 | |
| Egg | 3 | 0.3333333333 | Egg | 0.05 | |
| Vanila Extract | 1 | 0.1111111111 | Tsp | 0.29 | |
| Chocolate Chip | 200 | 22.2222222222 | g. | 0.28 | |
| Green Tea Ice Cream | 400 | 44.4444444444 | g. | 0.31 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.18 | ||||
| Selling Price | 3.94 | ||||
| 3 | Thai Pumpkin Custard on Sticky Rice | ||||
| Pumpkin | 50 | 50 | g. | 0.03 | |
| Pandan Leaf | 2 | 2 | 0.03 | ||
| Sticky Rice | 50 | 50 | g. | 0.10 | |
| Plam Sugar | 60 | 60 | g. | 0.03 | |
| Sugar | 50 | 50 | g. | 0.01 | |
| Salt | 1/4 | 1/4 | Tsp | 0.00 | |
| Egg | 2 | 2 | Egg | 0.30 | |
| Coconut Milk | 50 | g. | 0.02 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.52 | ||||
| Selling Price | 1.74 | ||||
| 4 | Vegan Chocolate Cake with Lime Sorbet (V) | 8 | |||
| All Purpose Flour | 120 | 15 | g. | 0.02 | |
| Cocoa Powder | 3 | 0.375 | Tbsp | 0.04 | |
| Baking Soda | 1/2 | 0.0625 | Tsp | 0.12 | |
| Custer Sugar | 150 | 18.75 | g. | 0.04 | |
| Vegetable Oil | 1/4 | 0.03125 | Cup | 0.07 | |
| Cold Water | 250 | 31.25 | ml. | 0.27 | |
| Vanila Extract | 1 | 0.125 | Tsp | 0.29 | |
| Salt | 8 | 1 | g. | 0.00 | |
| Lime Sorbet | 400 | 50 | g. | 0.40 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.24 | ||||
| Selling Price | 4.13 | ||||
| 5 | Japanese Cheese Cake | 9 | |||
| Cream Cheese | 250 | 27.7777777778 | g. | 0.39 | |
| Custa Sugar | 85 | 9.4444444444 | g. | 0.02 | |
| Unsalted Butter (Soft) | 30 | 3.3333333333 | g. | 0.02 | |
| Egg | 3 | 0.3333333333 | Egg | 0.05 | |
| Thickened Cream | 150 | 16.6666666667 | ml. | 0.06 | |
| Vanila Extract | 1/2 | 0.0555555556 | Tsp | 0.29 | |
| Lemon Extract | 1/2 | 0.0555555556 | Tsp | 0.11 | |
| All Purpose Flour | 32 | 3.5555555556 | g. | 0.00 | |
| Icing Sugar (Decorate) | 2 | 0.2222222222 | Tbsp | 0.20 | |
| Stawberry (Decorate) | 9 | 1 | EA | 0.38 | |
| Whip Cream | 90 | 10 | ml. | 0.03 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.55 | ||||
| Selling Price | 5.15 |
Table D Hote
| Name | Qty. | Qty. | UOM | Cost | |
| Entrée | |||||
| 1 | Pork & Prawn Gyoza (6 PCS per Serve) | 5 | |||
| All Purpose Flour | 270 | 54 | g. | 0.05 | |
| Warm Water | 135 | 27 | ml. | 0.02 | |
| Salt | 1/4 | 1 | Tsp | 0.01 | |
| Mince Pork | 210 | 10 | g. | 0.07 | |
| Mince Prawn | 90 | 10 | g. | 0.27 | |
| Savoy Cabbage | 210 | 10 | g. | 0.01 | |
| Garlic | 3 | 0.6 | Cloves | 0.01 | |
| Cheives | 60 | 10 | g. | 0.01 | |
| Soy Sauce (Shoyu) | 3 | 0.6 | Tsp | 0.01 | |
| Oyster Sauce | 3 | 0.6 | Tsp | 0.01 | |
| Sugar | 1 | 0.2 | Tsp | 0.01 | |
| White Pepper | 1/2 | 0.0166666667 | Tsp | 0.01 | |
| Potato Starch | 2 | 0.4 | Tsp | 0.01 | |
| Sesami Oil | 1 | 0.2 | Tsp | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.50 | ||||
| Selling Price | 1.67 | ||||
| 2 | Vegetable Spring Rolls (V) (5 PCS per Serve) | 4 | |||
| Vermicelli Noodle | 100 | 25 | g. | 0.15 | |
| Vegetable Oil | 1 | 1 | Tsp | 0.01 | |
| Garlic | 2 | 0.5 | Cloves | 0.01 | |
| Carrot (grated) | 100 | 25 | g. | 0.03 | |
| Cabbage (grated) | 100 | 25 | g. | 0.03 | |
| Soy Sauce (Vegetarian) | 1 | 0.25 | Tsp | 0.01 | |
| White Pepper | 1/4 | 0.25 | Tsp | 0.01 | |
| Sugar | 1 | 0.25 | Tsp | 0.01 | |
| Sesami Oil | 1/2 | 0.25 | Tsp | 0.01 | |
| Corn Flour | 2 | 1 | Tsp | 0.01 | |
| Tofu (Hard) Chop | 100 | 25 | g. | 0.33 | |
| Frozen spring roll wrappers (21.5 cm) | 20 | 5 | PCS | 0.20 | |
| Sweet Chilli Sauce | 30 | ml. | 0.05 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.87 | ||||
| Selling Price | 2.89 | ||||
| Main | |||||
| 1 | Beef Stir Fried Noodle (Hokien Noodle) | ||||
| Beef Fillet (Lion) | 250 | g. | 4.50 | ||
| Noodle | 200 | g. | 0.90 | ||
| Carrot (Julian) | 50 | g. | 0.20 | ||
| Blocoli | 50 | g. | 0.20 | ||
| Coliflower | 50 | g. | 0.20 | ||
| Spring Onion | 10 | g. | 0.01 | ||
| Garlic | 1 | Cloves | 0.01 | ||
| Oyster Sauce | 1 | Tbsp | 0.01 | ||
| Soy Sauce | 1 | Tbsp | 0.01 | ||
| Vegetable Oil | 2 | Tbsp | 0.01 | ||
| Sesami Oil | 1 | Tsp | 0.01 | ||
| White pepper | 1/4 | Tsp | 0.00 | ||
| Sugar | 1/4 | Tsp | 0.00 | ||
| Chinese Wine Cooking | 1 | Tsp | 0.01 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 6.07 | ||||
| Selling Price | 20.24 | ||||
| 2 | Salmon Steak with Teriyaki and Stream Vegetable | ||||
| Salmon Fillet | 300 | 300 | g. | 7.50 | |
| Mirin | 1 | 1 | Tbsp | 0.01 | |
| Soy Sauce | 3 | 3 | Tbsp | 0.01 | |
| Sugar | 1 | 1 | Tbsp | 0.01 | |
| Carrot (Julian) | 30 | 30 | g. | 0.02 | |
| Blocoli | 30 | 30 | g. | 0.02 | |
| Coliflower | 30 | 30 | g. | 0.02 | |
| Capsicum (Red) | 10 | 10 | g. | 0.01 | |
| White Pepper | 1/4 | 1/4 | Tsp | 0.10 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 7.70 | ||||
| Selling Price | 25.67 | ||||
| Dessert | |||||
| 1 | Green Tea Mousse with Red Bean Paste (GF) | 7 | |||
| White Chocolate Compound | 210 | 30 | g. | 0.21 | |
| Green Tea Powder | 10 | g. | 1.00 | ||
| Butter (Melted) | 21 | 3 | g. | 0.02 | |
| Vanila Extract | 1 | 0.1428571429 | Tsp | 0.06 | |
| Thickened Cream | 375 | 53.5714285714 | ml. | 0.19 | |
| Egg | 3 | 0.4285714286 | Egg | 0.08 | |
| Red Bean | 140 | 20 | g. | 0.13 | |
| Custer Sugar | 70 | 10 | g. | 0.02 | |
| Salt | 8 | 1.1428571429 | g. | 0.00 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.70 | ||||
| Selling Price | 5.66 | ||||
| 2 | Vegan Chocolate Cake with Lime Sorbet (V) | 8 | |||
| All Purpose Flour | 120 | 15 | g. | 0.02 | |
| Cocoa Powder | 3 | 0.375 | Tbsp | 0.04 | |
| Baking Soda | 1/2 | 0.0625 | Tsp | 0.12 | |
| Custa Sugar | 150 | 18.75 | g. | 0.04 | |
| Vegetable Oil | 1/4 | 0.03125 | Cup | 0.07 | |
| Cold Water | 250 | 31.25 | ml. | 0.27 | |
| Vanila Extract | 1 | 0.125 | Tsp | 0.29 | |
| Salt | 8 | 1 | g. | 0.00 | |
| Lime Sorbet | 400 | 50 | g. | 0.40 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.24 | ||||
| Selling Price | 4.13 | ||||
Brunch
| Name | Qty. | Qty. | UOM | Cost | |
| Savory (Hot & Cold) | |||||
| 1 | BBQ Pork on Sticky Rice and Salad | ||||
| Pork Neck | 250 | 250 | g. | 2.50 | |
| Sticky Rice | 100 | 80 | g. | 0.20 | |
| Coriander Seed | 10 | 10 | g. | 0.01 | |
| Coriender Root | 10 | 10 | g. | 0.01 | |
| Whole White Peppercorn | 10 | 10 | g. | 0.01 | |
| Garlic | 10 | 10 | g. | 0.01 | |
| Palm Sugar | 20 | 20 | g. | 0.01 | |
| Oyster Sauce | 2 | 2 | Tbsp | 0.01 | |
| Soy Sauce | 2 | 2 | Tbsp | 0.01 | |
| Papaya | 30 | 30 | g. | 0.08 | |
| Cherry Tomato | 30 | 30 | g. | 0.04 | |
| Carrot | 30 | 30 | g. | 0.02 | |
| Coriander (Chop) | 10 | 10 | g. | 0.01 | |
| Lime Juice | 1 | 1 | Tbsp | 0.01 | |
| Fish Sauce | 1 | 1 | Tbsp | 0.01 | |
| Penut | 10 | 10 | g. | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 2.95 | ||||
| Selling Price | 9.83 | ||||
| 2 | Salmon Steak with Teriyaki and Stream Vegetable | ||||
| Salmon Fillet | 300 | 300 | g. | 7.50 | |
| Mirin | 1 | 1 | Tbsp | 0.01 | |
| Soy Sauce | 3 | 3 | Tbsp | 0.01 | |
| Sugar | 1 | 1 | Tbsp | 0.01 | |
| Carrot (Julian) | 30 | 30 | g. | 0.02 | |
| Blocoli | 30 | 30 | g. | 0.02 | |
| Coliflower | 30 | 30 | g. | 0.02 | |
| Capsicum (Red) | 10 | 10 | g. | 0.01 | |
| White Pepper | 1/4 | 1/4 | Tsp | 0.10 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 7.70 | ||||
| Selling Price | 25.67 | ||||
| 3 | Seafood Pineapple Fried Rice | ||||
| Rice (cold) | 200 | 200 | g. | 0.30 | |
| Pineapple | 30 | 30 | g. | 0.02 | |
| Carrot | 30 | 30 | g. | 0.02 | |
| Blocoli | 30 | 30 | g. | 0.03 | |
| Cashew Nut | 20 | 20 | g. | 0.02 | |
| Prawn | 50 | 50 | g. | 1.35 | |
| Calamari | 50 | 50 | g. | 0.60 | |
| Mussel | 50 | 50 | g. | 0.75 | |
| Egg | 1 | 1 | Egg | 0.15 | |
| Soy Sauce | 1 | 1 | Tsp | 0.01 | |
| Black soy sauce | 1 | 1 | Tsp | 0.01 | |
| Oyster Sauce | 1 | 1 | Tsp | 0.01 | |
| White Pepper | 1/4 | 1/4 | Tsp | 0.01 | |
| Sugar | 1/4 | 1/4 | Tsp | 0.01 | |
| Garlic | 1 | 1 | Clove | 0.01 | |
| Coriander | 10 | 10 | g. | 0.01 | |
| Lemon (Wage) | 0.01 | ||||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 3.32 | ||||
| Selling Price | 11.07 | ||||
| 4 | Chicken on Rice with Fried Egg (GF) | ||||
| Chicken Breast (Dice Chop) | 100 | 100 | g. | 0.90 | |
| Egg | 1 | 1 | Egg | 0.15 | |
| Chinese sausage | 50 | 50 | g. | 0.10 | |
| Carrot | 50 | 50 | g. | 0.03 | |
| Shitake Mushroom | 30 | 30 | g. | 0.05 | |
| Baby Corn | 30 | 30 | g. | 0.02 | |
| Stream Rice | 200 | 200 | g. | 0.20 | |
| Oyster Sauce | 1 | 1 | Tsp | 0.01 | |
| Soy Sauce | 1 | 1 | Tsp | 0.01 | |
| Sesami Oil | 1 | 1 | Tsp | 0.01 | |
| Corn Flour (GF) | 1 | 1 | Tbsp | 0.01 | |
| Vegetable Oil | 1 | 1 | Tsp | 0.01 | |
| Black soy sauce | 1 | 1 | Tsp | 0.01 | |
| Sugar | 1/2 | 1/2 | Tsp | 0.01 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.52 | ||||
| Selling Price | 5.07 | ||||
| 5 | Vegetable Tempura with Soba Noodle [Cold] (V) | ||||
| Soba Noodle (GF) | 200 | 180 | g. | 0.60 | |
| Nori | 50 | 50 | g. | 0.02 | |
| Plain Flour | 1/4 | 1/4 | Cup | 0.01 | |
| Corn Flour | 1/4 | 1/4 | Cup | 0.01 | |
| Bicabonate Soda | 8 | 2 | g. | 0.00 | |
| Egg | 1 | 1 | Egg | 0.15 | |
| Soda Water (Chilled) | 1/4 | 1/4 | Cup | 0.00 | |
| Carrot | 120 | 40 | g. | 0.02 | |
| Egg Plant | 120 | 40 | g. | 0.02 | |
| Sweet Potato | 120 | 40 | g. | 0.02 | |
| Pumpkin | 120 | 40 | g. | 0.03 | |
| Baby Corn | 120 | 40 | g. | 0.03 | |
| Asparagus | 120 | 40 | g. | 0.02 | |
| Black Sesami | 20 | 10 | g. | 0.01 | |
| Japanese Noodle Soy Sauce | 200 | 50 | ml. | 0.02 | |
| Vegetable Oil for fried | 0.00 | ||||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.96 | ||||
| Selling Price | 3.21 | ||||
| 6 | Beef Stir Fried Noodle (Hokien Noodle) | ||||
| Beef Fillet (Lion) | 250 | g. | 4.50 | ||
| Noodle | 200 | g. | 0.90 | ||
| Carrot (Julian) | 50 | g. | 0.20 | ||
| Blocoli | 50 | g. | 0.20 | ||
| Coliflower | 50 | g. | 0.20 | ||
| Spring Onion | 10 | g. | 0.01 | ||
| Garlic | 1 | Cloves | 0.01 | ||
| Oyster Sauce | 1 | Tbsp | 0.01 | ||
| Soy Sauce | 1 | Tbsp | 0.01 | ||
| Vegetable Oil | 2 | Tbsp | 0.01 | ||
| Sesami Oil | 1 | Tsp | 0.01 | ||
| White pepper | 1/4 | Tsp | 0.00 | ||
| Sugar | 1/4 | Tsp | 0.00 | ||
| Chinese Wine Cooking | 1 | Tsp | 0.01 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 6.07 | ||||
| Selling Price | 20.24 | ||||
| 7 | Lamb Curry Puffs (5 PCS per serve) | ||||
| Mince Lamb | 100 | g. | 0.50 | ||
| Vegetable Oil | 1 | Tsp | 0.01 | ||
| Brown Onion (Chop) | 15 | g. | 0.02 | ||
| Madras Curry Paste | 1 | Tsp | 0.01 | ||
| Carrot (Chop) | 50 | g. | 0.03 | ||
| Frozen Pea | 50 | g. | 0.03 | ||
| Frozen Corn | 50 | g. | 0.03 | ||
| Coriander (Chop) | 2 | Tbsp | 0.01 | ||
| Garlic | 1 | Tsp | 0.01 | ||
| Frozen Puff Pastries | 5 | PCS | 1.00 | ||
| Egg | 1 | Egg | 0.15 | ||
| Turmaric Powder | 1 | Tsp | 0.01 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.81 | ||||
| Selling Price | 6.02 | ||||
| Dessert | |||||
| 1 | Green Tea Mousse with Red Bean Paste (GF) | 7 | |||
| White Chocolate Compound | 210 | 30 | g. | 0.21 | |
| Green Tea Powder | 10 | g. | 1.00 | ||
| Butter (Melted) | 21 | 3 | g. | 0.02 | |
| Vanila Extract | 1 | 0.1428571429 | Tsp | 0.06 | |
| Thickened Cream | 375 | 53.5714285714 | ml. | 0.19 | |
| Egg | 3 | 0.4285714286 | Egg | 0.08 | |
| Red Bean | 140 | 20 | g. | 0.13 | |
| Custer Sugar | 70 | 10 | g. | 0.02 | |
| Salt | 8 | 1.1428571429 | g. | 0.00 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.70 | ||||
| Selling Price | 5.66 | ||||
| 2 | Brownie with Green Tea Ice Cream | 9 | |||
| Brown Sugar | 130 | 14.4444444444 | g. | 0.04 | |
| Custa Sugar | 110 | 12.2222222222 | g. | 0.02 | |
| Cocoa Powder | 75 | 8.3333333333 | g. | 0.06 | |
| All Purpose Flour | 75 | 8.3333333333 | g. | 0.01 | |
| Baking Powder | 1/4 | 0.0277777778 | Tsp | 0.04 | |
| Unsalted Butter (Melted) | 150 | 16.6666666667 | g. | 0.08 | |
| Egg | 3 | 0.3333333333 | Egg | 0.05 | |
| Vanila Extract | 1 | 0.1111111111 | Tsp | 0.29 | |
| Chocolate Chip | 200 | 22.2222222222 | g. | 0.28 | |
| Green Tea Ice Cream | 400 | 44.4444444444 | g. | 0.31 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.18 | ||||
| Selling Price | 3.94 | ||||
| 3 | Thai Pumpkin Custard on Sticky Rice | ||||
| Pumpkin | 50 | 50 | g. | 0.03 | |
| Pandan Leaf | 2 | 2 | 0.03 | ||
| Sticky Rice | 50 | 50 | g. | 0.10 | |
| Plam Sugar | 60 | 60 | g. | 0.03 | |
| Sugar | 50 | 50 | g. | 0.01 | |
| Salt | 1/4 | 1/4 | Tsp | 0.00 | |
| Egg | 2 | 2 | Egg | 0.30 | |
| Coconut Milk | 50 | g. | 0.02 | ||
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 0.52 | ||||
| Selling Price | 1.74 | ||||
| 4 | Vegan Chocolate Cake with Lime Sorbet (V) | 8 | |||
| All Purpose Flour | 120 | 15 | g. | 0.02 | |
| Cocoa Powder | 3 | 0.375 | Tbsp | 0.04 | |
| Baking Soda | 1/2 | 0.0625 | Tsp | 0.12 | |
| Custa Sugar | 150 | 18.75 | g. | 0.04 | |
| Vegetable Oil | 1/4 | 0.03125 | Cup | 0.07 | |
| Cold Water | 250 | 31.25 | ml. | 0.27 | |
| Vanila Extract | 1 | 0.125 | Tsp | 0.29 | |
| Salt | 8 | 1 | g. | 0.00 | |
| Lime Sorbet | 400 | 50 | g. | 0.40 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.24 | ||||
| Selling Price | 4.13 | ||||
| 5 | Japanese Cheese Cake | 9 | |||
| Cream Cheese | 250 | 27.7777777778 | g. | 0.39 | |
| Custa Sugar | 85 | 9.4444444444 | g. | 0.02 | |
| Unsalted Butter (Soft) | 30 | 3.3333333333 | g. | 0.02 | |
| Egg | 3 | 0.3333333333 | Egg | 0.05 | |
| Thickened Cream | 150 | 16.6666666667 | ml. | 0.06 | |
| Vanila Extract | 1/2 | 0.0555555556 | Tsp | 0.29 | |
| Lemon Extract | 1/2 | 0.0555555556 | Tsp | 0.11 | |
| All Purpose Flour | 32 | 3.5555555556 | g. | 0.00 | |
| Icing Sugar (Decorate) | 2 | 0.2222222222 | Tbsp | 0.20 | |
| Stawberry (Decorate) | 9 | 1 | EA | 0.38 | |
| Whip Cream | 90 | 10 | ml. | 0.03 | |
| Fixed Cost - Utility (per Month) | 500.00 | ||||
| Fixed Cost - Rent (per Month) | 2,500.00 | ||||
| Fixed Cost - Staff (per Month) | 14,400.00 | ||||
| Total Cost | 1.55 | ||||
| Selling Price | 5.15 |
A La Carte Analysis
| A La Carte Menu Analysis | |||||||
| Menu Item | Menu Mix% Cholaitp: Cholaitp: Amount Sold/Total Dishes Sold * 100 | Amount Sold | Food Cost % Cholaitp: Cholaitp: Food Cost/Sale Price* 100 | Food Cost | Sales Price | Menu Cost Cholaitp: Cholaitp: Food Cost * Amount Sold | Menu Revenue Cholaitp: Cholaitp: Sale Price * Amount Sold |
| Entrées | |||||||
| 1. Pork & Prawn Gyoza (6 PCS per Serve) | 9.04 | 15 | 30.00 | 0.50 | 1.67 | 7.50 | 25.00 |
| 2. Vegetable Spring Rolls (5 PCS per Serve) (V) | 9.04 | 15 | 30.00 | 0.87 | 2.89 | 13.00 | 43.34 |
| 3. Chicken Soup (Clear Soup) (GF) | 4.82 | 8 | 30.00 | 1.95 | 6.49 | 15.57 | 51.89 |
| 4. Beef Noodle Salad (Cold) (GF) | 6.02 | 10 | 30.00 | 4.23 | 14.12 | 42.35 | 141.17 |
| 5. Seafood Okonomiyaki | 3.61 | 6 | 30.00 | 2.09 | 6.97 | 12.54 | 41.80 |
| Mains | |||||||
| 1. BBQ Pork on Sticky Rice and Salad | 7.23 | 12 | 30.00 | 2.95 | 9.83 | 35.40 | 118.00 |
| 2. Salmon Steak with Teriyaki and Stream Vegetable | 4.82 | 8 | 30.00 | 7.70 | 25.67 | 61.60 | 205.33 |
| 3. Seafood Pineapple Fried Rice | 7.23 | 12 | 30.00 | 3.32 | 11.07 | 39.84 | 132.80 |
| 4. Chicken on Rice with Fried Egg (GF) | 6.02 | 10 | 30.00 | 1.52 | 5.07 | 15.20 | 50.67 |
| 5. Vegetable Tempura with Soba Noodle [Cold] (V) | 6.02 | 10 | 30.00 | 0.96 | 3.21 | 9.63 | 32.10 |
| Desserts | |||||||
| 1. Green Tea Mousse with Red Bean Paste (GF) | 7.23 | 12 | 30.00 | 1.70 | 5.66 | 20.39 | 67.96 |
| 2. Brownie with Green Tea Ice Cream | 9.04 | 15 | 30.00 | 1.18 | 3.94 | 17.74 | 59.12 |
| 3. Thai Pumpkin Custard on Sticky Rice | 4.82 | 8 | 30.00 | 0.52 | 1.74 | 4.17 | 13.89 |
| 4. Vegan Chocolate Cake with Lime Sorbet (V) | 6.02 | 10 | 30.00 | 1.24 | 4.13 | 12.38 | 41.26 |
| 5. Japanese Cheese Cake | 9.04 | 15 | 30.00 | 1.55 | 5.15 | 23.18 | 77.26 |
| Total Dishes Sold | 166 | ||||||
| Total food cost percentage% Cholaitp: Cholaitp: (Menu Cost / Menu Revenue)*100 | 30.00 | Totals | 330.48 | 1,101.60 |
Table D Hote Analysis
| Table D Hote Menu Analysis | |||||||||||||
| Menu Item | Menu Mix% Cholaitp: Cholaitp: Amount Sold/Total Dishes Sold * 100 | Amount Sold | Food Cost % Cholaitp: Cholaitp: Food Cost/Sale Price* 100 | Food Cost | Sales Price | Menu Cost Cholaitp: Cholaitp: Food Cost * Amount Sold | Menu Revenue Cholaitp: Cholaitp: Sale Price * Amount Sold |
||||||
| Entrée's | |||||||||||||
| 1. Pork & Prawn Gyoza (6 PCS per Serve) | 20.00 | 30 | 30.00 | 0.50 | 1.67 | 15.00 | 50.00 | ||||||
| 2. Vegetable Spring Rolls (5 PCS per Serve) (V) | 13.33 | 20 | 30.00 | 0.87 | 2.89 | 17.34 | 57.79 | ||||||
| Mains | |||||||||||||
| 1. Beef Stir Fried Noodle (Hokien Noodle) | 13.33 | 20 | 30.00 | 6.07 | 20.24 | 121.44 | 404.80 | ||||||
| 2. Salmon Steak with Teriyaki and Stream Vegetable | 20.00 | 30 | 30.00 | 7.70 | 25.67 | 231.00 | 770.00 | ||||||
| Desserts | |||||||||||||
| 1. Green Tea Mousse with Red Bean Paste (GF) | 20.00 | 30 | 30.00 | 1.70 | 5.66 | 50.97 | 169.90 | ||||||
| 2. Vegan Chocolate Cake with Lime Sorbet (V) | 13.33 | 20 | 30.00 | 1.24 | 4.13 | 24.76 | 82.53 | ||||||
| Total Dishes Sold | 150 | ||||||||||||
| Total food cost percentage% Cholaitp: Cholaitp: (Menu Cost / Menu Revenue)*100 |
Cholaitp: Cholaitp: Amount Sold/Total Dishes Sold * 100 |
Cholaitp: Cholaitp: Food Cost/Sale Price* 100 |
Cholaitp: Cholaitp: Food Cost * Amount Sold |
Cholaitp: Cholaitp: Sale Price * Amount Sold | 30.00 | Totals | 460.51 | 1,535.02 | |||||
Brunch Analysis
| Brunch Menu Analysis | |||||||||||||
| Menu Item | Menu Mix% Cholaitp: Cholaitp: Amount Sold/Total Dishes Sold * 100 | Amount Sold | Food Cost % Cholaitp: Cholaitp: Food Cost/Sale Price* 100 | Food Cost | Sales Price | Menu Cost Cholaitp: Cholaitp: Food Cost * Amount Sold | Menu Revenue Cholaitp: Cholaitp: Sale Price * Amount Sold |
||||||
| F | F | T | T | T | T | T | |||||||
| Savory (Hot & Cold) | |||||||||||||
| 1. BBQ Pork on Sticky Rice and Salad | 32.43 | 12 | 30.00 | 2.95 | 9.83 | 35.40 | 118.00 | ||||||
| 2. Salmon Steak with Teriyaki and Stream Vegetable | 27.03 | 10 | 30.00 | 5.00 | 10.00 | 50.00 | 100.00 | ||||||
| 3. Seafood Pineapple Fried Rice | 20.00 | 15 | 30.00 | 4.00 | 11.00 | 60.00 | 165.00 | ||||||
| 4. Chicken on Rice with Fried Egg (GF) | 0.00 | - 0 | - 0 | ||||||||||
| 5. Vegetable Tempura with Soba Noodle [Cold] (V) | 0.00 | - 0 | - 0 | ||||||||||
| 6. Beef Stir Fried Noodle (Hokien Noodle) | 0.00 | - 0 | - 0 | ||||||||||
| 7. Lamb Curry Puffs (5 PCS per serve) | 0.00 | - 0 | - 0 | ||||||||||
| Desserts | |||||||||||||
| 1. Green Tea Mousse with Red Bean Paste (GF) | |||||||||||||
| 2. Brownie with Green Tea Ice Cream | |||||||||||||
| 3. Thai Pumpkin Custard on Sticky Rice | |||||||||||||
| 4. Vegan Chocolate Cake with Lime Sorbet (V) | |||||||||||||
| 5. Japanese Cheese Cake | |||||||||||||
| Total Dishes Sold | 37 | ||||||||||||
| Total food cost percentage% Cholaitp: Cholaitp: (Menu Cost / Menu Revenue)*100 |
Cholaitp: Cholaitp: Food Cost * Amount Sold |
Cholaitp: Cholaitp: Sale Price * Amount Sold | 37.96 | Totals | 145.40 | 383.00 |
