Sports Bar Game-Day Event Planner & Promotion P&L: Plan, Staff and Measure Every Match Night: Forecast, Menu and Promotion Return
Full description
For sports bar owners and managers who run match nights and want to know which events pay. Grade each fixture A, B or C, and the workbook forecasts covers from the weekday, daypart and uplift, limits them to seats and turns, and works out servers, bartenders, cooks and door staff, hours and labour cost. A narrow special menu is priced per cover. After the match, enter the actual covers, sales, labour hours and promotion spend, and each event becomes a P&L with contribution against a normal night, promotion return, break-even covers, labour %, forecast accuracy and a review status. The Word guide gives the countdown checklists, the briefing script, the promotion rules and the review form.
What is inside
- Game_Day_Event_Planner_and_Promotion_PnL.xlsx: 7 tabs, 1,590 formulas, 2 native charts, 15 drop-down and input rules, 10 integrity checks
- Fixtures and Forecast: 36 sample fixtures plus 6 spare rows, with importance A, B or C, booked covers and promotion budget; forecast covers, servers, bartenders, cooks, door staff, staff hours, labour cost, revenue, contribution and a plan flag calculated
- Special Menu: 10 sample items with price, unit cost, cost %, margin and expected mix per 100 covers; sales, cost and gross profit per cover feed the forecast and the P&L
- Event P&L: 23 sample events played with actual covers, sales, labour hours and promotion spend; contribution, contribution against a normal night, promotion ROI, break-even covers, labour %, forecast accuracy, review status and verdict calculated
- Dashboard with 8 tiles, a table by importance, the next five events and 2 charts
- Game_Day_Checklist_Guide.docx and PDF: 6 pages with event grading, staff plan, menu rules, four countdown checklists, run-sheet roles, a briefing script, promotion rules, a review form and a worked example
- README.txt and LICENSE-and-Terms.txt
How it works
- Set seats, turns, uplift, baseline covers, staffing ratios and rates on Settings.
- List the game-day menu with price, cost and expected mix.
- Enter fixtures in date order and read the forecast and the plan flag.
- After each event, enter the actuals the same night and hold the review within two days.
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 fixtures, menu and results.
- Uplift, ratios, rates and costs are examples. Check licensing, broadcast and opening rules with your local authority before you advertise an event.
- Single-user license. Do not redistribute.
FAQ
How does it forecast covers?
It takes the baseline covers for the weekday and daypart, multiplies by the uplift for the grade, and limits the result to seats times turns. All three come from Settings.
What counts as promotion cost?
Discounts and giveaways, marketing spend, licence or entertainment, and labour hours above a normal night at the same baseline.
How is promotion ROI worked out?
It is the contribution above a normal night, divided by the promotion cost. A result below the minimum on Settings shows as weak or losing money.
How many fixtures and events are included?
36 sample fixtures, 23 of them played with actuals, plus 6 spare fixture rows and 4 spare menu rows.
Do I need macros?
No. Every result is a standard worksheet formula.
