$3.$ Hi I need help with this question please!

Alyeskl Tours operates day tours ot coastal glaclers In Alaska on Its tour boat the Blue Glacler_ Management nas Identified two cost drlversttne number ot crulses and the number ot passengersthat It uses In Its budgeting and performance reports. The company publlsnes a schedule ot day cruises that It may supplement wltn special salllngs It there Is sufficient demand. Up to 84 passengers can be accommodated on the tour boat Data concerning the company's cost formulas appear below: Vessel operating costs Advertising Administrative costs Insurance Fixed Cost per month S 6,7ea S 2,gea S 5, sea S 3,1ea Cost per Cruise S 475.ae S 34.ae Cost per Passenger s 1.50 For example, vessel operating costs should be $6,700 per month plus $473.00 per cruise plus $340 per passenger. The company's sales should average S3400 per passenger In July, the company provlded 54 cruises tor a total ot 3,200 passengers. Requlred: Prepare the company's flexible budget tor July. Alyeski Tours Flexible Budget ed Jul Revenue Expenses: Vessel operating costs Advertising Administrative costs Insurance Total expense Net operating income