Need help with questions 1-12 please

help with questions 1-12 please

Number of rooms	240
	2019
ADR	$320
OCC	80%
RevPAR	$256
REVENUE		New Revenues	Sales Mix
Rooms	$22,425,600
Food & Beverage	$6,240,000
Other Operated Departments	$480,500
Miscellaneous Income	$40,000
TOTAL REVENUE	$29,186,100
			Fixed Cost	Variable Cost
DEPARTMENTAL EXPENSES
Rooms	$5,157,888
Food & Beverage	$3,868,800
Other Operated Departments	$120,125
TOTAL DEPARTMENTAL EXPENSES	$9,146,813
TOTAL DEPARTMENTAL PROFITS	$20,039,287
UNDISTRIBUTED OPERATING EXPENSES
Administrative & General	$4,669,776
Marketing	$2,918,610
Utility Costs	$291,861
Property Operation & Maintenance	$350,233
TOTAL UNDISTRIBUTED OPERATING EXPENSES	$8,230,480
GROSS OPERATING PROFIT	$11,808,807
Franchise Fees	$897,024
Management Fees	$708,528
INCOME BEFORE FIXED CHARGES	$10,203,254
SELECTED FIXED CHARGES
Property Taxes	$420,000
Insurance	$62,000
Reserve For Capital Replacement	$180,000
EBITDA	$9,541,254
Depreciation	$236,000
Interest Expense	$20,000
Income Before Income Tax	$9,285,254
Income Tax @ 25%	$2,321,314
Net Income	$6,963,941
		Total
		CMR
		New CMR

Based on the income statement and the information below: The income tax rate is 25%. Number of rooms is 240 , and hotel operates at 80% occupancy. Room, Food \& Beverage, and Other Operated Department expenses are directly variable with total sales revenue. Administrative \& General: $2,400,000 is fixed, the remainder is variable with total revenue. Marketing $1,240,000 is fixed, the remainder is variable with total revenue. Utilities cost: $180,000 is fixed, the remainder is variable with total revenue. Property Operations \& Maintenance: $188,000 is fixed, the remainder is variable with total revenue. Assume both franchise fees and management fees to be fixed. Answer the following questions. 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 at $320 ADR? 4. What revenue is required to achieve desired operating income (income before income tax) of $12,000,000 ? 5. If the operating income (income before income tax) of $12,000,000 achieved, how much would the food and beverage revenue be? 6. If rooms and food \& beverage revenues increase by 10% and 15%, respectively, through price increases, what would the new breakeven be? 7. If fixed cost increases by $2,400,000, how much addional revenues is needed to cover the additional fixed expenses? 8. What would the required revenue be if a net income of $9,000,000 is desired? 9. What would the occupancy rate be if a net income of $9,000,000 is achieved at $320ADR ? 10. If the depreciation expense decreases by 100,000 , what would the breakeven point be? Based on the income statement and the information below: The income tax rate is 25%. Number of rooms is 240 , and hotel operates at 80% occupancy. Room, Food \& Beverage, and Other Operated Department expenses are directly variable with total sales revenue. Administrative \& General: $2,400,000 is fixed, the remainder is variable with total revenue. Marketing $1,240,000 is fixed, the remainder is variable with total revenue. Utilities cost: $180,000 is fixed, the remainder is variable with total revenue. Property Operations \& Maintenance: $188,000 is fixed, the remainder is variable with total revenue. Assume both franchise fees and management fees to be fixed. Answer the following questions. 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 at $320 ADR? 4. What revenue is required to achieve desired operating income (income before income tax) of $12,000,000 ? 5. If the operating income (income before income tax) of $12,000,000 achieved, how much would the food and beverage revenue be? 6. If rooms and food \& beverage revenues increase by 10% and 15%, respectively, through price increases, what would the new breakeven be? 7. If fixed cost increases by $2,400,000, how much addional revenues is needed to cover the additional fixed expenses? 8. What would the required revenue be if a net income of $9,000,000 is desired? 9. What would the occupancy rate be if a net income of $9,000,000 is achieved at $320ADR ? 10. If the depreciation expense decreases by 100,000 , what would the breakeven point be? Based on the income statement and the information below: The income tax rate is 25%. Number of rooms is 240 , and hotel operates at 80% occupancy. Room, Food \& Beverage, and Other Operated Department expenses are directly variable with total sales revenue. Administrative \& General: $2,400,000 is fixed, the remainder is variable with total revenue. Marketing $1,240,000 is fixed, the remainder is variable with total revenue. Utilities cost: $180,000 is fixed, the remainder is variable with total revenue. Property Operations \& Maintenance: $188,000 is fixed, the remainder is variable with total revenue. Assume both franchise fees and management fees to be fixed. Answer the following questions. 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 at $320 ADR? 4. What revenue is required to achieve desired operating income (income before income tax) of $12,000,000 ? 5. If the operating income (income before income tax) of $12,000,000 achieved, how much would the food and beverage revenue be? 6. If rooms and food \& beverage revenues increase by 10% and 15%, respectively, through price increases, what would the new breakeven be? 7. If fixed cost increases by $2,400,000, how much addional revenues is needed to cover the additional fixed expenses? 8. What would the required revenue be if a net income of $9,000,000 is desired? 9. What would the occupancy rate be if a net income of $9,000,000 is achieved at $320ADR ? 10. If the depreciation expense decreases by 100,000 , what would the breakeven point be? Based on the income statement and the information below: The income tax rate is 25%. Number of rooms is 240 , and hotel operates at 80% occupancy. Room, Food \& Beverage, and Other Operated Department expenses are directly variable with total sales revenue. Administrative \& General: $2,400,000 is fixed, the remainder is variable with total revenue. Marketing $1,240,000 is fixed, the remainder is variable with total revenue. Utilities cost: $180,000 is fixed, the remainder is variable with total revenue. Property Operations \& Maintenance: $188,000 is fixed, the remainder is variable with total revenue. Assume both franchise fees and management fees to be fixed. Answer the following questions. 1. What is the revenue at breakeven point? 2. At breakeven point, what would the room revenu