Kleveroo

Hotel Wine: Reports & Decisions

Preview
Departmental Context & Duties
Core Reports Overview
Supporting Reports
Formulas & Calculations
Interpretation & Decisions
Host This Board for real

About This Board

This board helps players review Wine Analytics through a Jeopardy-style game format on Kleveroo. It includes categories such as Departmental Context & Duties, Core Reports Overview, Supporting Reports, Formulas & Calculations, Interpretation & Decisions. It is useful for classroom review, team trivia, family game night, test prep, and group play.

Best For

Questions in this game

A peek at what's on the board — 5 categories and one sample clue from each. Answers stay hidden until you open them, so the game still works.

  • Departmental Context & Duties

    In some hotels, this management area or a sommelier runs the wine program.

    Show answer

    Food & Beverage

    +4 more clues in this category

  • Core Reports Overview

    This report records what wine is on hand, its movement, and value.

    Show answer

    Wine Inventory Report

    +4 more clues in this category

  • Supporting Reports

    Tracks orders, prices paid, and supplier reliability.

    Show answer

    Wine Purchasing & Supplier Performance

    +4 more clues in this category

  • Formulas & Calculations

    Sales Mix % equals this revenue divided by total wine revenue times 100.

    Show answer

    category revenue

    +4 more clues in this category

  • Interpretation & Decisions

    High revenue growth says nothing about this, so read with the Cost & Profitability Report.

    Show answer

    margin

    +4 more clues in this category

Board content

Departmental Context & Duties

$100 — In some hotels, this management area or a sommelier runs the wine program.
Food & Beverage
$200 — Inventory control and this ensures guests find bottles when they want them.
stock availability
$300 — Designing the list and managing this guides guest choices.
guest preference management
$400 — Sales performance must be tracked across these two dimensions.
outlets and service periods
$500 — Reports and statistics, not intuition, enable these kinds of decisions.
defensible, repeatable decisions

Core Reports Overview

$100 — This report records what wine is on hand, its movement, and value.
Wine Inventory Report
$200 — This sales report tracks revenue, volume and mix.
Wine Sales Report
$300 — Measures cost versus revenue to show contribution to profit.
Wine Cost & Profitability Report
$400 — Compares theoretical and actual consumption to flag discrepancies.
Wine Inventory Variance Report
$500 — In the turnover example, the figure from $21,000 and $75,000.
0.28×

Supporting Reports

$100 — Tracks orders, prices paid, and supplier reliability.
Wine Purchasing & Supplier Performance
$200 — Classifies wines by popularity and profitability.
Wine Menu Engineering Report
$300 — Estimates future consumption and checks stock versus lead time.
Wine Demand Forecast & Stock Availability
$400 — Breaks revenue by point of sale and service period.
Wine Sales by Outlet & Service Period
$500 — In the supplier example, the on-time delivery rate for 21 of 24.
87.5%

Formulas & Calculations

$100 — Sales Mix % equals this revenue divided by total wine revenue times 100.
category revenue
$200 — Average selling price equals wine revenue divided by this.
units sold
$300 — Gross Profit equals Wine Sales Revenue minus this.
Cost of Wine Consumed
$400 — Actual Consumption equals Opening plus Purchases minus this.
Closing Inventory
$500 — Days on Hand equals Current Inventory divided by this.
average daily consumption

Interpretation & Decisions

$100 — High revenue growth says nothing about this, so read with the Cost & Profitability Report.
margin
$200 — Gross profit should not be reported as this.
net profit
$300 — There is no universal target for this percentage across hotels.
Wine Cost %
$400 — A positive variance means more wine left the cellar than these records explain.
POS records
$500 — When days on hand near this time, trigger purchase orders.
supplier lead time

Kleveroo is an online review game platform for teachers, teams, and families. Create Jeopardy-style boards, host live trivia, and play educational games — no PowerPoint templates required.

Find more like this

More Business boardswine analyticsdepartmental context dutiescore reports overviewsupporting reports

Like this game? Create your own with our free Jeopardy game maker.