Hotel Breakfast Operations & Cost per Cover Optimiser: Breakfast Cost per Cover Calculator and Standards Guide

Full description

For hotel food and beverage directors, restaurant managers, executive chefs and finance managers who need to know what breakfast costs per cover and whether the service style is right. The workbook prices three styles (buffet, a la carte and continental) from 24 menu items with quantity and waste, adds staffing from covers per server and per cook, and values the breakfast inside the rate as rate premium against take-up times cost. A 60-day log tracks covers against the forecast issued, food cost, labour hours, waste and complaints with flags. A 10-page Word guide sets the daily standard, ordering sequence, waste rules, menu worksheet and weekly review.

What is inside

• Breakfast_Cost_per_Cover_Optimiser.xlsx: 7 tabs, 1,241 formulas, 2 native charts, 21 drop-down and input rules
• Cost Build: 3 service styles, 24 sample menu items (spare rows for yours), staffing ratios, cost per cover, food cost status and value of rate inclusion
• Breakfast Log: 60 sample days plus 24 spare rows, with cost per cover, food cost %, waste per cover, covers per labour hour, forecast error and a flag
• Forecast: 14 sample days plus 7 spare rows, covers, servers, cooks, cost per cover and an equipment list of 8 items
• Dashboard: 7 KPI tiles, a check tile, 2 charts, a style table and a weekly table of 12 weeks; 7 integrity checks
• Breakfast_Operations_Standards_Guide.docx and PDF: 10 pages with 20 operating standards, 6 never rules, a cost per cover worked example, a waste log, a menu worksheet, an equipment table and a weekly review
• README.txt and LICENSE-and-Terms.txt

How it works

1. Enter rooms, guests per room, take-up, labour rates and targets on Settings.
2. Replace the sample styles and menu items on Cost Build and read the cost per cover and the value of rate inclusion.
3. Log each day on Breakfast Log and read the flags for food cost, waste, forecast and complaints.
4. Enter the occupancy forecast to get covers, staffing and equipment. Use the guide to run the standard and the weekly review.

Details

• Formats: 1 Excel workbook (.xlsx), 1 guide in Word (.docx) and PDF, English
• Software: Excel 2016 or later, or LibreOffice Calc 7 or later
• No macros, no external links, no data tables, no array formulas
• 3 files plus README and license; instant digital download

Good to know

• Sample data is illustrative. Replace it with your own figures.
• The value of breakfast in the rate is an allocation agreed with finance. The rate premium and take-up are your own estimates.
• These files are management tools, not financial, legal or food safety advice. Verify wage rates, food safety limits and allergen wording locally.
• Single-user license. Do not redistribute.

FAQ

What does cost per cover include?

Food cost, waste, labour (servers, cooks and supervisor hours) and consumables, divided by covers.

How does it value breakfast in the rate?

It compares the rate premium per guest with take-up times the all-in cost per cover and gives the net value per guest, per room and per month.

Can I compare my own service styles?

Yes. Rename the three styles, change the prices and staffing ratios, and replace the menu items and quantities.

Does the forecast round the covers?

Only at the end. Cost uses unrounded covers, orders use covers rounded up to the next 5 and staffing rounds up per service.

Do I need macros or add-ins?

No. Every result is a standard worksheet formula.