a. Your friend, Big Al, provides you with the following information about his property. Altantica Hotel Number of rooms

[answerhappygod]

A Your Friend Big Al Provides You With The Following Information About His Property Altantica Hotel Number Of Rooms 1 (110.26 KiB) Viewed 42 times

A Your Friend Big Al Provides You With The Following Information About His Property Altantica Hotel Number Of Rooms 2 (87.58 KiB) Viewed 42 times

A Your Friend Big Al Provides You With The Following Information About His Property Altantica Hotel Number Of Rooms 3 (54.41 KiB) Viewed 42 times

This is all in one assignment. please send answers in organized manner.
please and thanks.
a. Your friend, Big Al, provides you with the following information about his property. Altantica Hotel Number of rooms 300 Days open per year 365 Average number of rooms available per day 90% Average daily rate $110.00 Variable costs as % of sales 45% Annual fixed costs $604,800 Desired after-tax profit $800,000 Tax rate 30% Proposed new assistant manager cost $45,000.00 Big Al askes you to calculate the following (Spreadsheet hint: Do not calculate SP Percentage. You must type in 100 for SP Percentage in order for the grid to calculate properly.) Per Unit (Room) Percentage SP VC CM Total fixed costs Desired after-tax profit Tax rate Before-tax profit Rooms available for sale per year
b. Calculate the room sold, occupancy percentage, and sales dollars we will need to breakeven Breakeven point in rooms sold Occupancy % Breakeven point in sales dollars C. Calculate the rooms sold, occupancy percentage, and the dollars he will need to achieve his desired profits Rooms sold to achieve desired after-tax profit Rounded up = Occupancy % Sales dollars to achieve desired after-tax profit Big Al decides to hire a new assistant manger to help him out around the hotel, he will pay a total of $45,000 per year to the assis Calculate the rooms sold, occupancy percentage, and the sales dollars he will need to breakeven after he fires the new assistar d. Total fixed costs Breakeven point in rooms sold Rounded up = Occupancy % Breakeven point in sales dollars
e. Caculate the rooms sold, occupancy percentage, and the sales dollars he will need to achieve his desired profit after he hires ti Rooms sold to achieve desired after-tax profit Rounded up = Occupancy % Sales dollars to achieve desired after-tax profit if occupancy percentage averages 70% after he hires the new assistant manager, what is his margin of safety? f. Sales ($) Rooms Projected Sales Breakeven Sales Margin of Safety