SITXFIN003 Manage Finances within a Budge

Task 2 Variance Analysis

Note

You have been provided with the projected data sheet for reference in the Task 2 Spread sheet.

Please use the Assessment Task 2 spread sheet file to complete the calculations.

SITXFIN003 Manage finances within a budget The Bentley Hotel Forecast room revenues Room Type Total Rooms Available King Suite Queen Suite Deluxe Room Standard Room Total Room Type 20 10 50 40 Total Rooms Available King Suite Queen Suite Deluxe Room Standard Room Total Room Type Total Rooms Available King Suite Queen Suite Deluxe Room Standard Room Total Total Rooms Available Room Rate $575 $475 $375 $275 Room Rate 70% 80% 89% 90% Projected/Forecasted Occupancy 20 10 50 40 $575 $475 $375 $275 70% 80% 89% 90% Projected/Forecasted Occupancy 20 10 50 40 Room Rate 70% 80% 89% 90% Projected/Forecasted Occupancy 20 10 50 40 King Suite Queen Suite Deluxe Room Standard Room Total Room Type Projected/Forecasted Occupancy 70% 80% 89% 90% $575 $475 $375 $275 Room Rate $575 $475 $375 $275 Annually Available days Projected /Forecasted Revenue per room type 365 365 365 365 Monthly Jan Projected /Forecasted Revenue per room type 31 31 31 31 Monthly Feb Projected /Forecasted Revenue per room type 28 28 28 28 Monthly Mar Projected /Forecasted Revenue per room type 31 31 31 31 SITXFIN003 Manage finances within a budget The Bentley Hotel Actual room revenues Room Type Total Rooms Available King Suite Queen Suite Deluxe Room Standard Room Total Room Type 20 10 50 40 Total Rooms Available King Suite Queen Suite Deluxe Room Standard Room Total Room Type King Suite Queen Suite Deluxe Room Standard Room Total Actual Occupancy Room Rate 65% 70% 85% 85% Actual Occupancy 20 10 50 40 Total Rooms Available Room Rate 68% 55% 85% 70% Actual Occupancy 20 10 50 40 $575 $475 $375 $275 $575 $475 $375 $275 Room Rate 67% 80% 89% 90% $575 $475 $375 $275 he Bentley Hotel Monthly Jan Revenue per room type Variance % Revenue per room type Variance % Revenue per room type Variance % 31 31 31 31 Monthly Feb 28 28 28 28 Monthly Mar 31 31 31 31