Cookery project
Ajupme
MenuPriceBalance.xlsxMenu Price Balance Template
| Menu Price Balance Template | |||||||
| Covers | Average Spend: | ||||||
| ERROR:#REF! | |||||||
| Entrées | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| $10.00 | $20.00 | 50.0% | 10 | $100.00 | $200.00 | 50.0% | |
| $10.00 | $20.00 | 50.0% | 10 | $100.00 | $200.00 | 50.0% | |
| $10.00 | $20.00 | 50.0% | 10 | $100.00 | $200.00 | 50.0% | |
| Totals | $30.00 | $60.00 | 50.0% | 30 | $300.00 | $600.00 | 50.0% |
| 3 | 3 | 3 | 3 | 3 | |||
| Main Courses | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | ERROR:#REF! | Total Food Cost | ERROR:#REF! | ERROR:#REF! |
| $10.00 | |||||||
| $10.00 | |||||||
| $10.00 | |||||||
| Totals | |||||||
| Main Courses | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| $10.00 | |||||||
| $10.00 | |||||||
| $10.00 | |||||||
| Totals | $30.00 | ||||||
| 3 | 0 | 0 | 0 | 0 | |||
| Desserts | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| $10.00 | |||||||
| $10.00 | |||||||
| $10.00 | |||||||
| Totals | $30.00 | ||||||
| 3 | 0 | 0 | 0 | 0 | |||
| Combined Portion Costs | Combined Menu Prices | Food Cost% | Covers | Total Food Cost | Total Sales Revenue | Menu Food Cost % | |
| $90.00 | $60.00 | 150.0% | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
Page &P &F
Menu Price Balance Sample
| Futura Group© | |||||||
| Menu Price Balance Template Sample | |||||||
| Covers | Average Spend: | ||||||
| 65 | $42.66 | ||||||
| Entrées | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Entrée 1 | $3.10 | $15.00 | 20.7% | 25 | $77.50 | $375.00 | 20.7% |
| Entrée 2 | $1.80 | $15.00 | 12.0% | 10 | $18.00 | $150.00 | 12.0% |
| Entrée 3 | $5.10 | $16.50 | 30.9% | 8 | $40.80 | $132.00 | 30.9% |
| Totals | $10.00 | $46.50 | 21.5% | 43 | $136.30 | $657.00 | 20.7% |
| 3 | 3 | 3 | 3 | 3 | |||
| Main Courses | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Main Course 1 | $7.50 | $25.00 | 30.0% | 25 | $187.50 | $625.00 | 30.0% |
| Main Course 2 | $9.30 | $28.50 | 32.6% | 14 | $130.20 | $399.00 | 32.6% |
| Main Course 3 | $8.40 | $27.00 | 31.1% | 21 | $176.40 | $567.00 | 31.1% |
| Totals | $25.20 | $80.50 | 31.3% | 60 | $494.10 | $1,591.00 | 31.1% |
| 3 | 3 | 3 | 3 | 3 | |||
| Desserts | |||||||
| Menu Items | Portion Cost | Sales Price | Food Cost% | Covers | Total Food Cost | Revenue | Food Cost% |
| Dessert 1 | $2.80 | $12.50 | 22.4% | 15 | $42.00 | $187.50 | 22.4% |
| Dessert 2 | $3.25 | $12.50 | 26.0% | 18 | $58.50 | $225.00 | 26.0% |
| Dessert 3 | $1.85 | $12.50 | 14.8% | 9 | $16.65 | $112.50 | 14.8% |
| Totals | $7.90 | $37.50 | 21.1% | 42 | $117.15 | $525.00 | 22.3% |
| 3 | 3 | 3 | 3 | 3 | |||
| Combined Portion Costs | Combined Menu Prices | Food Cost% | Covers | Total Food Cost | Total Sales Revenue | Menu Food Cost % | |
| $43.10 | $164.50 | 26.2% | 65 | $747.55 | $2,773.00 | 27.0% | |
| 3 | 3 | 3 | 3 | ||||
Page &P &F
