The Bentley Hotel Actual room revenues Monthly Jan Room Type Total Rooms Available Actual Occupancy Room Rate Revenue per room type Variance King Suite Queen Suite Deluxe Room $575 $475 20 65% 31 10 70% 31 $375 $275 50 85% 31 Standard Room 40 85% 31 Total Monthly Feb Total Rooms Available Room Rate Variance Room Type King Suite Queen Suite Actual Occupancy Revenue per room type $575 $475 $375 $275 20 68% 28 10 55% 28 Deluxe Room 50 85% 28 Standard Room 40 70% 28 Total Monthly Mar Actual Occupancy 67% 80% Room Type Total Rooms Available Room Rate Revenue per room type Variance $575 $475 $375 $275 King Suite Queen Suite 20 31 10 31 Deluxe Room 50 89% 31 Standard Room 40 90% 31 Total

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
SITXFINO03 Manage finances within a budget
The Bentley Hotel
Actual room revenues
Monthly
Total Rooms Available
Room Rate
Variance
%
Room Type
King Suite
Queen Suite
Actual Occupancy
65%
Jan
Revenue per room type
$575
$475
$375
$275
20
31
10
70%
31
Deluxe Room
Standard Room
50
85%
31
40
85%
31
Total
Monthly
Actual Occupancy
68%
Room Type
Total Rooms Available
Room Rate
Feb
Revenue per room type
Variance
%
King Suite
Queen Suite
Deluxe Room
Standard Room
$575
$475
$375
$275
20
28
10
55%
28
50
85%
28
40
70%
28
Total
Monthly
Room Type
Total Rooms Available
Actual Occupancy
Room Rate
Mar
Revenue per room type
Variance
%
King Suite
Queen Suite
$575
$475
$375
$275
20
67%
31
10
80%
31
Deluxe Room
Standard Room
50
89%
31
40
90%
31
Total
Transcribed Image Text:SITXFINO03 Manage finances within a budget The Bentley Hotel Actual room revenues Monthly Total Rooms Available Room Rate Variance % Room Type King Suite Queen Suite Actual Occupancy 65% Jan Revenue per room type $575 $475 $375 $275 20 31 10 70% 31 Deluxe Room Standard Room 50 85% 31 40 85% 31 Total Monthly Actual Occupancy 68% Room Type Total Rooms Available Room Rate Feb Revenue per room type Variance % King Suite Queen Suite Deluxe Room Standard Room $575 $475 $375 $275 20 28 10 55% 28 50 85% 28 40 70% 28 Total Monthly Room Type Total Rooms Available Actual Occupancy Room Rate Mar Revenue per room type Variance % King Suite Queen Suite $575 $475 $375 $275 20 67% 31 10 80% 31 Deluxe Room Standard Room 50 89% 31 40 90% 31 Total
The Bentley Hotel
Forecast room revenues
Projected/Forecasted Room Rate
Occupancy
Annually
Available days Projected /Forecasted
Room Type
Total Rooms Available
Revenue per room type
King Suite
Queen Suite
20
70%
$575
365
10
80%
$475
365
Deluxe Room
50
89%
$375
365
Standard Room
40
90%
$275
365
Total
Monthly
Projected/Forecasted Room Rate
Occupancy
Projected /Forecasted
Revenue per room type
Room Type
Total Rooms Available
Jan
70%
King Suite
Queen Suite
Deluxe Room
$575
$475
$375
$275
20
31
10
80%
31
50
89%
31
Standard Room
40
90%
31
Total
Monthly
Room Type
Total Rooms Available
Projected/Forecasted Room Rate
Feb
Projected /Forecasted
Occupancy
Revenue per room type
King Suite
$575
$475
$375
$275
20
70%
28
80%
89%
Queen Suite
10
28
Deluxe Room
50
28
Standard Room
Total
40
90%
28
Monthly
Mar
Projected/Forecasted Room Rate
Occupancy
Room Type
Total Rooms Available
Projected /Forecasted
Revenue per room type
King Suite
Queen Suite
20
70%
$575
31
$475
$375
$275
10
80%
31
Deluxe Room
50
89%
31
Standard Room
40
90%
31
Total
Transcribed Image Text:The Bentley Hotel Forecast room revenues Projected/Forecasted Room Rate Occupancy Annually Available days Projected /Forecasted Room Type Total Rooms Available Revenue per room type King Suite Queen Suite 20 70% $575 365 10 80% $475 365 Deluxe Room 50 89% $375 365 Standard Room 40 90% $275 365 Total Monthly Projected/Forecasted Room Rate Occupancy Projected /Forecasted Revenue per room type Room Type Total Rooms Available Jan 70% King Suite Queen Suite Deluxe Room $575 $475 $375 $275 20 31 10 80% 31 50 89% 31 Standard Room 40 90% 31 Total Monthly Room Type Total Rooms Available Projected/Forecasted Room Rate Feb Projected /Forecasted Occupancy Revenue per room type King Suite $575 $475 $375 $275 20 70% 28 80% 89% Queen Suite 10 28 Deluxe Room 50 28 Standard Room Total 40 90% 28 Monthly Mar Projected/Forecasted Room Rate Occupancy Room Type Total Rooms Available Projected /Forecasted Revenue per room type King Suite Queen Suite 20 70% $575 31 $475 $375 $275 10 80% 31 Deluxe Room 50 89% 31 Standard Room 40 90% 31 Total
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education