please help with this one. 4

Exercise 9.5 (Algo) Prepare o Flexible Budget with More Than One Cost Driver [LO9-5] Alyeski Tours operates day tours of coastal glaciers in Alaska on ins tout boat the Blue Glacier. Managentent has identified two cost drivers - the number of cruises ond the number of passengeri- that it uses in its budgeting and performance reports The compary publishes a schedule of day cruises that it may wopiement wath specal saings if there is sufficient demand Up to 88 possengers can be accommodated on the tour boat. Data conceming the company's cost formulas appear below For example, vessel operating costs should be $6,300 per month plus $479.00 per cruise plus $310 per passenger. The company/s sales should average $3400 per passenger in July, the company provided 55 cruises for a total of 3.050 passengers. Required: Prepare the company's flexible budget for July