FM_Project2

xlsx

School

Maasai Mara University *

*We aren’t endorsed by this school

Course

ECO 2103

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

9

Uploaded by Ambiro

Report
Using the following information for the Blue Moon hotel: Rooms 300 ADR $ 140.00 Occupancy 80% Revenue Ratio to sales Rooms 65.10% Food 15.90% Beverage 4.00% Other food & beverage 8.50% Other operated department 0.40% Miscellaneous income 6.10% Total revenue 100.00% Departmental expenses Fixed Rooms 38.60% 80% Food & beverage 89.60% 80% Other department 258.70% 90% Total department expenses 51.50% Departmental profits Rooms 61.40% Food & beverage 10.40% Other department -158.70% Total departmental profit 48.50% Undistributed operating expenses Fixed Administrative & general 7.70% 90% Information and telecommunication sytems 1.40% 100% Marketing (excluding franchise) 5.30% 60% Franchise fees 0.10% 0% Utility costs 2.10% 90% Property operation & maintenance 4.30% 90% Total undistributed operating expenses 20.90% Gross operating profit 27.60% Fixed Base management fees 3.10% 0% Incentive management fees 1.80% 0% Income before fixed charges 22.60%
Fixed charges Fixed Non-operating income - 100% Rent 2.30% 100% Property taxes 5.50% 100% Insurance 0.50% 100% EBITDA 14.20% Additional information Depreciation and amortization (year) $ 500,000 Interest (per year) $ 200,000 Income taxes 18% Required: 1. Prepare a profit loss according to the USALI, assuming the hotel operates 365 2. Prepare a profit and loss showing variable costs and fixed costs (you can use a 3. Compute the weighted average CMR for the Blue Moon hotel. 4. Compute the break even point for the Blue Moon hotel. 5. If the B hotel wants to make $1,700,000 of net income, what must its room sa
REQUIREMENT #1 Rooms Revenue $ 12,264,000.00 Food and Beverage Revenue $ 5,350,193.55 Other $ 75,354.84 Misc. Revenue $ 1,149,161.29 TOTAL REVENUE $ 18,838,709.68 Dept. Expenses Rooms $ 4,733,904.00 Food & Beverage $ 4,793,773.42 Other Dept. $ 194,942.97 Variable Total Dept. Expenses $ 9,722,620.39 20% Dept. Profits 20% Rooms $ 7,530,096.00 10% Food & Beverage $ 556,420.13 Other dept. $ (119,588.13) Total Dept. Profit $ 7,966,928.00 Undistributed Operating Exp. A&G $ 1,450,580.65 Info & Telecommunications Systems $ 263,741.94 Marketing (excluding franchise) $ 998,451.61 Franchise Fees $ 18,838.71 Utility Costs $ 395,612.90 Variable Property Operationg & Maintenance $ 810,064.52 10% Total Undist. Operating Expenses $ 3,937,290.32 0% Gross Operating Profit $ 5,178,798.97 40% Base Mangement Fees $ 584,000.00 100% Incentive Mangement Fees $ 339,096.77 10% Income Before Fixed Charges $ 4,255,702.19 10% Fixed Charges Non-operating Income $ - Rent $ 433,290.32 Variable Property Taxes $ 1,036,129.03 100% Insurance $ 94,193.55 100% EBITDA $ 2,692,089.29 Additional Information Depreciation & Amortization $ 500,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Variable Interest $ 200,000 0% income Before Taxes $ 1,992,089.29 0% Income Taxes $ 358,576.07 0% Net Income $ 1,633,513.22 0% $ 1,992,089.29 $ 358,576 days . You have to present three departments: rooms, food and beverage, and other operated dep a similar presentation than problem 23, p. 391) ales equal? What is the corresponding occupany rate?
Fixed Costs Variable Costs $ 3,787,123.20 $ 946,780.80 $ 3,835,018.74 $ 958,754.68 $ 175,448.67 $ 19,494.30 $ 1,305,522.58 $ 145,058.06 $ 263,741.94 $ - $ 599,070.97 $ 399,380.65 $ - $ 18,838.71 $ 356,051.61 $ 39,561.29 $ 729,058.06 $ 81,006.45 $ - $ 584,000.00 $ - $ 339,096.77 $ 433,290.32 $ - $ 1,036,129.03 $ 94,193.55 Requirement #5 Total Reveenue $ 19,529,371.35 Rooms Sales $ 12,713,620.75 248.80
OCC% 82.93% EBITDA $ 2,773,170.73 Dep + Amor $ 500,000.00 Interest $ 200,000.00 Income Before Taxes $ 2,073,170.73 Net Income $ 1,700,000.00 partment
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Requirement #2 Revenue Variable Costs Rooms $ 12,264,000.00 $ 946,780.80 Food & Beverage $ 5,350,193.55 $ 958,754.68 Other $ 75,354.84 $ 19,494.30 Misc. $ 1,149,161.29 Total department Profit Other variable expenses Other fixed costs Pretax income Income Taxes Net Income Requirement #3 Weighted Average CMR CMR Total Revenue $ 18,838,709.68 Total VC $ 3,531,971.72 $ 15,306,737.96 CMR 81.25% $ 3,531,971.72 Requirement #4 Fixed Costs $ 13,314,648.67 Contribution Margin 81.25% Breakeven Point $ 16,386,953.34 Requirement #5 Net Income $ 1,700,000.00 Get pre tax income + fixed Tax Rate 18% total reve = rooms % by rev Pretax Income $ 1,992,089.29 Income Taxes $ 358,576.07 Tax Rate 0.18 Fixed Costs $ 13,314,648.67 cmr = (total revenue - total variable costs) / total revenue
Required Sales $ 18,839,062.11 Room Sales $ 12,264,000.00 Total Sales $ 18,838,709.68 Required Sales for Room Dept. $ 12,264,229.43 Part 2 of Requirement #5 Tax Rate 82% Net Income $ 1,700,000.00
Fixed Costs Department Income $ 3,787,123.20 $ 7,530,096.00 $ 3,835,018.74 $ 556,420.13 $ 175,448.67 $ (119,588.13) $ 1,149,161.29 $ 9,116,089.29 $ 1,606,941.94 $ 5,517,058.06 $ 1,992,089.29 $ 358,576.07 $ 1,633,513.22 costs = total revenue verse egineering
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help