Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Shrute BnB-Tally Number of rooms 180 2019 228 ADR OCC RevPAR 82% 186.96 New Revenues Sales Mix REVENUE Rooms Food & Beverage Other Operated Departments

image text in transcribed
image text in transcribed
Shrute BnB-Tally Number of rooms 180 2019 228 ADR OCC RevPAR 82% 186.96 New Revenues Sales Mix REVENUE Rooms Food & Beverage Other Operated Departments Miscellaneous Income TOTAL REVENUE 12,283,272 3,261,673 376,416 102,168 16,023.529 Fixed Cost Variable Cost DEPARTMENTAL EXPENSES Rooms Food & Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES 3,684,981 750,184 143,109 4,578,274 TOTAL DEPARTMENTAL PROFITS 11,445,255 708,135 663.343 321,555 344,732 2,037,765 UNDISTRIBUTED OPERATING EXPENSES Administrative & General Marketing Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES GROSS OPERATING PROFIT Franchise Fees Management Fees INCOME BEFORE FIXED CHARGES 9,407,490 736,996 752,599 7,917,895 SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement 371,700 $3,600 171,090 EBITDA Depreciation Interest Expense Income Before Income Tax Income Tax Net Income 7,321,505 342,000 98,000 6,881,505 1,376,301 5,505,204 Total CMR New CMR Based on the income statement and the information below: The income tax rate is 20%. Number of rooms is 180, and hotel operates at 82% occupancy Room, Food & Beverage, and Other Operated Department expenses are directly variable with total sales revenue. Administrative & General: $400,000 is fixed, the remainder is variable with total revenue. Marketing $300,000 is fixed, the remainder is variable with total revenue, Utilities cost: $140,000 is fixed, the remainder is variable with total revenue. Property Operations & Maintenance: $275,000 is fixed, the remainder is variable with total revenue. Assume both franchise fees and management fees to be fixed. Answer the following questions based on the given information and the income statement. 1. What is the revenue at breakeven point? 2. At breakeven point, what would the room revenues be? 3. At breakeven point, what is the occupancy rate at $228 ADR? 4. What revenue is required to achieve desired operating income income before income tax) of $8,000,000? 5. If the operating income (income before income tax) of $8,000,000 achieved, how much would the food and beverage revenue be? 6. If rooms and food & beverage revenues increase by 20% and 30%, respectively, through price increases, what would the new breakeven be? 7. If fixed cost increases by $1,500,000, how much addtional revenues is needed to cover the additional fixed expenses? 8. What would the required revenue be if a net income of $10,000,000 is desired

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant Datar, Madhav Rajan

17th Global Edition

129236307X, 9781292363073

More Books

Students also viewed these Accounting questions

Question

Find all solutions in CC of the given equation. Z 6 = -64

Answered: 1 week ago

Question

Define job pricing. What is the purpose of job pricing?

Answered: 1 week ago

Question

What are some companywide pay plans? Briefly discuss each.

Answered: 1 week ago