* Bom Big Tes is a true Team. When he opened his hotel on the plains of West Tesas, he samedit the Screaming Saloon Inn.
Posted: Sun Apr 17, 2022 7:05 pm
BigTex decides to hire new trip him out the both will 0.000 perar for the manager it. Cold, pead he will be the wa Total costs போன வப்பா ப பாயமை Chey pina Cake the room.cy percentages de will need to che il poter hehe threwang Sales dels weddarpared 372 Chapter 9 Managerial Accounting for costs 1. etape beste wawilige Sales (1) Rooms Berales Mergelt y shopThe who will win ADR by 15. vie come by and his frientes Catate the following to let the addition to get up pradeethane Pertamin 100 g de other Per Un Room) Percentage VC Total de 1. Carate the room wypade das he will need to whethe pildhop will I let the colle perdolls bewilde die - WIne #ber withi, day. Mehrwerp Randed ap
372 Chapter 9 Managerial Accounting for Costs 1. If occupancy percentage averages 70% after he hires the new awistant managrewhat is his margin of safety Sales ($) Rooms Projected Sales Breve Sales Margin of Sale Big Tex wants his new assistant manager (the same one mentioned in part (d) above) to oversee a proposed hotel gift shop. The small gift shop will increase his ADR by 19. his variable con by 5%, and his fixed costs by $24,000. Calculate the following to reflect the addition of the gift shop, (Specadsheet lunt: 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 h. Catulate the rooms sold, occupancy percentage, and sales dollars he will need to breakeven if he open the gift shop Becakeven point in rooms sold Rounded up Occupancy Breakeven point in cales dollars i. Calculate the rooms sold, occupancy percentage, and sales dollars he will need to achieve his desired profit if he opens the gift shop Rooms sold to achieve desired after-tax profit Rounded up Occupancy Sales dollars to achieve desired wher-tax profit If Big Tex has an average occupancy of 55%, will he be able to hire his new muistant manager and still achieve his desired profit? Why or why not Base your answer on occupancy percentage k. If Big Tex has an average occupancy of 55%, will be be able to hire his new assistant manager, open his proposed wift shop, and still achieve his desired profit? Why or why not? Buse your answer on occupancy percentage
8 Bonus: Big Tex is a true Texan. When he opened his hotel on the plains of West Texas, he named it the Screaming Saloon Inn. He now provides you with the following information about his property. Screaming Saloon Inn 200 365 Number of rooms Days open per year Average number of rooms available per day Average daily rate Variable costs as % of sales Annual fixed costs Desired after-tax profit Tax rate Proposed new Assistant Manager cost 95% $90.00 40% $604,800 $800,000 36% $40,000.00 (Spreadsheet hint: Use the ROUNDUP function in the cells indicated throughout the problem to round up rooms.) a. Big Tex has asked you to help him 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