8:01 aLTE Search Peterson Chapter 9 A Q fx pler 9, Qeestion (Spreadsheet hint: Use the ROUNDUP fanction in the ells indicated throaghout the problem to round wp rooms) Sereaming Saloon Inn Number of rooms Days open peryr Average number of rooms available per day Averaze daily rate 10 200 365 95% 59000 Variable costs as of sales Annual fixed costs 12. 40% S604 800 S800.000 36% S40 000 00 Desired after-ax profit Tax rats Proposed new assistant manazer cost (Spreadsheet hint: Do not calculate SP Percentage. You mast type in 100 See SP Percentane in ender for the grid to calculate preeerls Pereentage 00n Per Unit (Rosm s9000 SP 19 536.00 20 40% CM 554.00 60% Tetal fixed coss Desirad after-tax profit Tax rate Before-tax profit S604800 S800.000 36% $1.250.000h 24 26 27 Rooms available for sale per vear 69350 30 Breakeven point in rooms sold 1.200 Occupancy % 16.1% Breakeven peim in sales dollars S1,008,000 34348 15 Rooms sold o achiee desired atera profits Rondol ae 3434 Occupancy % 49.5% Sales dollars te achieve desined after-tax peofn 42 $3.091.333 43 44 Total fixed costs 45 46 Breakeven peim in rooms seld Roundol ae 47 48 Occupancy % 49 50 Breakeven point in sales dollars Roundad ur Rosms sold to achicve desirod aftar-tax profits Ocorancy Sales dollars to achieve desired after-tax peofi Q6 Q7 Q8 + 8:04 aLTE fx C31 Emated occupancy wth new assistant Sals Rooms Projeted Sales Rocakeven Sales Margin of Safety type in 100 fer SP Pertage Spreadsheet hist: Do net calculate SP Ferceatage. Y order for the grid to caleulate property) with peoposed gifshep opning ADR incan Variable cost inrease Fined gnt inrcane I% 24.000 Peroatage Per Unit (Reom) SP CM Total Sed costs Ronded Breakeven point in rooms sold Oceupancy % Beeakeven poie in sales dollars Ronded u Roons sold te achieve desired after-tas prot Ocoupancy Sales dollars to ahieve desired atera Big Tex has an average occupancy of 55%, will be be able so hine his new assistant manager and l achieve his desined peofir? Way or why o Base your answer on occupancy percestage Asswer k Ir Big Tex has an average occupancy of 55% will he be able to hire his new assistat manage, ope hi proposed gift shop, and still achieve his desired profie? Why or why not? Base your anwr on occupancy percentage Answr 5 Q6 Q7 Q8 + 8:01 aLTE Search Peterson Chapter 9 A Q fx pler 9, Qeestion (Spreadsheet hint: Use the ROUNDUP fanction in the ells indicated throaghout the problem to round wp rooms) Sereaming Saloon Inn Number of rooms Days open peryr Average number of rooms available per day Averaze daily rate 10 200 365 95% 59000 Variable costs as of sales Annual fixed costs 12. 40% S604 800 S800.000 36% S40 000 00 Desired after-ax profit Tax rats Proposed new assistant manazer cost (Spreadsheet hint: Do not calculate SP Percentage. You mast type in 100 See SP Percentane in ender for the grid to calculate preeerls Pereentage 00n Per Unit (Rosm s9000 SP 19 536.00 20 40% CM 554.00 60% Tetal fixed coss Desirad after-tax profit Tax rate Before-tax profit S604800 S800.000 36% $1.250.000h 24 26 27 Rooms available for sale per vear 69350 30 Breakeven point in rooms sold 1.200 Occupancy % 16.1% Breakeven peim in sales dollars S1,008,000 34348 15 Rooms sold o achiee desired atera profits Rondol ae 3434 Occupancy % 49.5% Sales dollars te achieve desined after-tax peofn 42 $3.091.333 43 44 Total fixed costs 45 46 Breakeven peim in rooms seld Roundol ae 47 48 Occupancy % 49 50 Breakeven point in sales dollars Roundad ur Rosms sold to achicve desirod aftar-tax profits Ocorancy Sales dollars to achieve desired after-tax peofi Q6 Q7 Q8 + 8:04 aLTE fx C31 Emated occupancy wth new assistant Sals Rooms Projeted Sales Rocakeven Sales Margin of Safety type in 100 fer SP Pertage Spreadsheet hist: Do net calculate SP Ferceatage. Y order for the grid to caleulate property) with peoposed gifshep opning ADR incan Variable cost inrease Fined gnt inrcane I% 24.000 Peroatage Per Unit (Reom) SP CM Total Sed costs Ronded Breakeven point in rooms sold Oceupancy % Beeakeven poie in sales dollars Ronded u Roons sold te achieve desired after-tas prot Ocoupancy Sales dollars to ahieve desired atera Big Tex has an average occupancy of 55%, will be be able so hine his new assistant manager and l achieve his desined peofir? Way or why o Base your answer on occupancy percestage Asswer k Ir Big Tex has an average occupancy of 55% will he be able to hire his new assistat manage, ope hi proposed gift shop, and still achieve his desired profie? Why or why not? Base your anwr on occupancy percentage Answr 5 Q6 Q7 Q8 +