Your friend, Big Al, provides you with the following information about his property. Altantica Hotel Number of rooms 200 Days open per year 365 Average number of rooms available per day 95% Aerage daily air $90.00 Variable costs as % of sales 40% Annual fixed cost 5604,800 Desired after-tax profit $400,000 30% $40,000.00 Tax rate Proposed new assiant manager cost a Big Alaskes you to calculate the following Spreadsheet in Do not calculate SP Percentage ou mat hype in 100 for SP Percentage in ander for the graduate props) SP VC CM Per Unit (Room) Percentage Total fixed cots Desired after-tax profit Tale Before-tax profi Ross available sale per year b. Calculate the rooms sold, occupancy percentage, and sales dollars we will need to breakeven Breakeven point in rooms sold Occupancy Breakeven point in sales dollars 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 prof Big Al decides to hire a new assistant manger to help him out around the hotel, he will pay a total of 540,000 per year to the assistant manager d. Calculate the rooms sold, occupancy percentage, and the sales dollars he will need to breakeven after he fires the new assistant manager. 1. Total fixed s Breakeven poim in rooms sold Rounded up Occupancy Breakeven point in sales dollars Caculate the rooms sold, occupancy percentage, and the sales dollars he will need to achieve his desired profit after he hires the new assistant manager Roms 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? Projected Sales Breakeven Sales Margin of Safety Sales (5) Rooms Assignment Your friend, Big Al, provides you with the following information about his property. Altantica Hotel Number of rooms 200 Days open per year 365 Average number of rooms available per day 95% Average daily rate $90.00 Variable costs as % of sales 40% Annual fixed costs $604,800 Desired after-tax profit $800,000 Tax rate Proposed new assistant manager cost 36% $40,000.00 a. 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.) SP VC CM Per Unit (Room) Percentage 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 $40,000 per year to the assistant manager d. Calculate the rooms sold, occupancy percentage, and the sales dollars he will need to breakeven after he fires the new assistant manager. 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 the new assistant manager Rooms sold to achieve desired after-tax profit Rounded up s Occupancy % Sales dollars to achieve desired after-tax profit f. If occupancy percentage averages 70% after he hires the new assistant manager, what is his margin of safety? Projected Sales Breakeven Sales Margin of Safety Sales (5) Rooms