3. A hotel operation has 100 rooms and a 100-seat restaurant. Please prepare a pro forma income statement for each of the department as well as the consolidated pro forma income statement of the hotel the next year. Rooms department: In 2019, the occupancy rate was 70% and the average room rate was $50. The GM is forecasting the occupancy rate to increase by 10% and the average room rate is to be increased by $10 in 2020. Cost of sales per room occupied is forecasted to be $10 per room. Department fixed operating expenses is estimated to be $350,000. The hotel opens 365 days a year. Restaurant department: In 2019, average check was $20, with an average seat turnover of 2.50. The GM is forecasting the average check to increase by $5 and seat turnover to decrease by 0.50. Costs of food and beverage and other variable operating expenses are expected to be 30% and 20% of revenue respectively. The fixed operating expenses is estimated to be $250,000 per year. The restaurant opens 300 days a year. Company-wide undistributed expenses & fixed charges: The indirect operating expenses and fixed charges were $300,000 and $400,000, respectively in 2019. GM expect the indirect costs to increase by 2.5% and no changes for fixed charges in 2020. The tax rate is expected to be 20%.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

Hello! I need help on how to do this. Thank you!

**Pro Forma Income Statement Preparation for a Hotel Operation**

This guide details the preparation of a pro forma income statement for a hotel operation consisting of a 100-room facility and a 100-seat restaurant. The pro forma income statement should be developed for each department as well as a consolidated statement for the entire hotel for the forthcoming year. Below are the specifics for each department:

### Rooms Department:

- **2019 Statistics:**
  - Occupancy Rate: 70%
  - Average Room Rate: $50

- **Forecast for 2020:**
  - Expected Increase in Occupancy Rate: 10%
  - Expected Increase in Average Room Rate: $10

- **Cost Analysis:**
  - Cost of Sales per Room Occupied: $10
  - Fixed Operating Expenses: $350,000 annually

- **Operational Days:**
  - The hotel operates 365 days a year.

### Restaurant Department:

- **2019 Statistics:**
  - Average Check: $20
  - Average Seat Turnover: 2.50

- **Forecast for 2020:**
  - Expected Increase in Average Check: $5
  - Expected Decrease in Seat Turnover: 0.50

- **Cost Structure:**
  - Costs of Food and Beverage: 30% of revenue
  - Other Variable Operating Expenses: 20% of revenue
  - Fixed Operating Expenses: $250,000 annually

- **Operational Days:**
  - The restaurant operates 300 days a year.

### Company-Wide Undistributed Expenses & Fixed Charges:

- **2019 Expenses:**
  - Indirect Operating Expenses: $300,000
  - Fixed Charges: $400,000

- **Forecast for 2020:**
  - Expected Increase in Indirect Costs: 2.5%
  - No change is anticipated for fixed charges.

- **Tax Consideration:**
  - The tax rate is expected to be 20%.

This framework should guide the development of the detailed pro forma income statement, ensuring that all variables and forecasts are accounted for to provide a comprehensive view of the expected financial performance for the year.
Transcribed Image Text:**Pro Forma Income Statement Preparation for a Hotel Operation** This guide details the preparation of a pro forma income statement for a hotel operation consisting of a 100-room facility and a 100-seat restaurant. The pro forma income statement should be developed for each department as well as a consolidated statement for the entire hotel for the forthcoming year. Below are the specifics for each department: ### Rooms Department: - **2019 Statistics:** - Occupancy Rate: 70% - Average Room Rate: $50 - **Forecast for 2020:** - Expected Increase in Occupancy Rate: 10% - Expected Increase in Average Room Rate: $10 - **Cost Analysis:** - Cost of Sales per Room Occupied: $10 - Fixed Operating Expenses: $350,000 annually - **Operational Days:** - The hotel operates 365 days a year. ### Restaurant Department: - **2019 Statistics:** - Average Check: $20 - Average Seat Turnover: 2.50 - **Forecast for 2020:** - Expected Increase in Average Check: $5 - Expected Decrease in Seat Turnover: 0.50 - **Cost Structure:** - Costs of Food and Beverage: 30% of revenue - Other Variable Operating Expenses: 20% of revenue - Fixed Operating Expenses: $250,000 annually - **Operational Days:** - The restaurant operates 300 days a year. ### Company-Wide Undistributed Expenses & Fixed Charges: - **2019 Expenses:** - Indirect Operating Expenses: $300,000 - Fixed Charges: $400,000 - **Forecast for 2020:** - Expected Increase in Indirect Costs: 2.5% - No change is anticipated for fixed charges. - **Tax Consideration:** - The tax rate is expected to be 20%. This framework should guide the development of the detailed pro forma income statement, ensuring that all variables and forecasts are accounted for to provide a comprehensive view of the expected financial performance for the year.
c. Prepare the consolidated pro-forma income statement of the hotel operation (combining rooms and restaurant).
Transcribed Image Text:c. Prepare the consolidated pro-forma income statement of the hotel operation (combining rooms and restaurant).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Money Management and Achieving Financial Goals
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
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