Hotel Financial report

This report displays a base dataset and three comparative datasets with variances between the comparatives and the base, % of Line and POR or PAR statistics for the selected datasets, for a single period. An optional flow through calculation appears at the bottom of the report.

The lines displayed on the report are configured in the Budgeting Report Builder.

Formulas

• Flow through calculation = Value 1 (sum of all lines with a tag of "value1") ÷ Value 2 (sum of all lines with a tag of "value2").

• Conditions:

  • If Values 1 and 2 are both positive, flow through = Value 2 ÷ Value 1

  • If Values 1 and 2 are both negative and Value 2 is greater than Value 1, flow through = 1 - (Value 2 ÷Value 1)

  • If Value 1 is negative and Value 2 is positive, flow through = 1 - (Value 2 ÷ Value 1)

  • If Values 1 and 2 are both negative and Value 2 is less than Value 1, flow through = -(Value 2 ÷ Value 1)

  • If Value 1 is positive and Value 2 is negative, flow through = Value 2 ÷ Value 1 - 1

  • If Values 1 and 2 are negative and Value 1 is equal to Value 2, flow through = 0.0.

• POR/PAR = (total dollars for each budget line) ÷ (total occupied rooms/available rooms)

• Variances = (base - comparative) ÷ comparative × 100

Note: KBI and calculated lines do not display POR or PAR data or % of Line data.

For more information:

• Running reports

• Report configuration

• Reporter