(47 x v fx =(31 T ted through Spreadsheet Use the ROUNDUPI the problem to rep r .) Screaming Saloon In Number of rooms Days oper year Average number of roces available per day Average daily rate Variable costs as of sales A lfined costs Desired after-tax profit $90.00 40% SOLO 000 16% $40,000.00 Proposed new assistant manager cost (Sprehet a Decak Percentage in order for the grid to s Percentage. You must types 100 for SP tate properly.) Per Unit (Room) Percentage $90.00 $36.00 55400 S1,800 E2 ER ENXERRRRRRRRR $1,250,000 Roces available for sale per year 69,350 10:00 Roo old to achievedewed after-tax profit 14,348 15 Rounded up Occupancy Title Page 01 02 03 04 C D E F d. Total fixed costs $604,800 Break even point in rooms sold 11,200.00 Rounded up Occupancy Broke point in sales dollar Room sold to achieve desintertex profit Rounded up Occupancy Sales dollars to achieve desid eram profit Estimated occupancy with ne 7045 Spreadsheet hints De Bocallate SP Percentage. Youm order for the grid to call te properly.) pored shop opening ADRI lecce Sonnels Per Unit (Room) Percentage Total fixed costs Brukerpoint sold Rounded up Bakeven point in sales de la Title Page 01 02 03 Paste Times New Roman v 12 v A A BIUvEv v Av fx =C31 C47 x Rooms sold to achieve desired after tax profit Rounded up Occupancy Sales dollars to achieve desired after tax profit 97 If Big Tex has an average occupancy of 55%, will he be able to hire his new assistant manager and still 98 achieve his desired profit? Why or why not? Base your answer on occupancy percentage 99 Answer: 100. If Big Tex has an average occupancy of 55%, will be be able to hire his new assistant manager, open 101 his proposed gift shop, and still achieve his desired profit? Why or why not? Base your answer on 102 occupancy percentage 103 Answer: 104 105 106 107 109 110 123 124 125 126 127 128 129 130