Cookery project
Ajupme
MenuPriceBalance_wb.xlsxSample
| Futura Group© | |||||||
| Menu Price Balance Trattoria Sample | |||||||
| Covers | Average Spend: | ||||||
| 32 | $53.25 | ||||||
| Entrées | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Minestrone | $1.32 | $12.00 | 11.0% | 12 | $15.84 | $144.00 | 11.0% |
| Carpaccio of Kingfish | $6.17 | $24.00 | 25.7% | 9 | $55.53 | $216.00 | 25.7% |
| Prosciutto and Semi-Dried Tomatoes | $5.72 | $18.00 | 31.8% | 5 | $28.60 | $90.00 | 31.8% |
| Totals | $13.21 | $54.00 | 24.5% | 26 | $99.97 | $450.00 | 22.2% |
| 3 | 3 | 3 | 3 | 3 | |||
| Main Courses | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Chicken Napolitana | $2.36 | $22.00 | 10.7% | 11 | $25.96 | $242.00 | 10.7% |
| Beef Wellington | $6.83 | $35.00 | 19.5% | 13 | $88.79 | $455.00 | 19.5% |
| Zucchini Flowers | $1.64 | $22.00 | 7.5% | 8 | $13.12 | $176.00 | 7.5% |
| Totals | $10.83 | $79.00 | 13.7% | 32 | $127.87 | $873.00 | 14.6% |
| 3 | 3 | 3 | 3 | 3 | |||
| Desserts | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Vanilla Bean Panna Cotta | $0.65 | $12.00 | 5.4% | 8 | $5.20 | $96.00 | 5.4% |
| Flourless Chocolate Cake | $0.83 | $15.00 | 5.5% | 12 | $9.96 | $180.00 | 5.5% |
| Crêpes Soufflé | $1.02 | $15.00 | 6.8% | 7 | $7.14 | $105.00 | 6.8% |
| Totals | $2.50 | $42.00 | 6.0% | 27 | $22.30 | $381.00 | 5.9% |
| 3 | 3 | 3 | 3 | 3 | |||
| Combined Portion Costs | Combined Menu Prices | Food Cost% | Covers | Total Food Cost | Total Sales Revenue | Menu Food Cost % | |
| $26.54 | $175.00 | 15.2% | 32 | $250.14 | $1,704.00 | 14.7% | |
| 3 | 3 | 3 | 3 | ||||
Page &P &F
Menu Price Balance Template
| Futura Group© | |||||||
| Menu Price Balance Template | |||||||
| Covers | Average Spend: | ||||||
| 2 | $0.00 | ||||||
| Starters | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Totals | |||||||
| 0 | 0 | 0 | 0 | 0 | |||
| Entrées | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Totals | |||||||
| 0 | 0 | 0 | 0 | 0 | |||
| Main Courses | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| $1.00 | |||||||
| $1.00 | |||||||
| $1.00 | |||||||
| $1.00 | |||||||
| $1.00 | |||||||
| Totals | $5.00 | ||||||
| 0 | 5 | 0 | 0 | 0 | |||
| Desserts | 1 | 0 | 0 | ||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Totals | $0.00 | $0.00 | ERROR:#DIV/0! | 0 | |||
| 1 | 1 | 1 | 0 | 0 | |||
| Combined Portion Costs | Combined Menu Prices | Food Cost% | Covers | Total Food Cost | Total Sales Revenue | Menu Food Cost % | |
| 2 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||
Page &P &F
