Exercise 10-5 Prepare a flexible Budget with More Than One Cost Driver (2010-51 Alesklours operates day tours of coastal glaciers in Alaska on its four boat the Blue Glacier Management has berned two cost drivers the number of cruises and the number of passengers that uses in budgeing and performance reports. The company publishes a schedule of day cruises that it may supplement with special salgs if there is suicient demand Up to 9 passengers can be accommodated on the four boat Dala concerning the company's cost formulas appear below Fred Cost per Month $6.300 $2,600 55.000 Cost per Cruise $ 47200 cost per Passenger $ 330 Vessel operating costs Advertising Administrative costs $ 3000 $150 For example, vessel operating costs should be 56.300 per month plus 5472.00 per Cruise plus $3.30 per passenger The company's sales should average 532,00 per passenger The company's planning budget for July is based on 56 cuises and 3,150 passengers Required: Complete the company's planning budget for July Alyeski Tours Planning Budget For the Month Ended July 31 Vessel operating costs Advertising O A ata e o Type here to search NG 101120102 For example, vessel operating costs should be $6,300 per month plus $472 00 per cruise plus $3.30 per passenger. The company's sales should average 532.00 per passenger The company planning budget for July is based on 55 Cruises and 3 150 passengers Required: Complete the company's planning budget for July Alyeski Tours Planning Budget For the Month Ended July 31 Rev Vessel operating costs Advertising Administrative costs Insurance Total expense Net operating income References eBook & Resources * ENG Type here to search N " 144