Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identified two cost drivers-the number of cruises and the number of passengers-that it uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand: Up to 80 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: For example, vessel operating costs should be $5,200 per month plus $480 per cruise plus $2 per passenger. The company's sales should average $25 per passenger. In July, the company provided 24 cruises for a total of 1,400 passengers. Required: Prepare the company's flexible budget for July. Flexible Budget For the Month Ended July 31 \begin{tabular}{|l|l|} \hline Actual cruises \\ \hline Actual passengers \\ \hline Revenue & \\ \hline Expenses: \\ \hline Vessel operating costs \\ \hline Advertising & \\ \hline Administrative costs & \\ \hline Insurance & \\ \hline Total expense & \\ \hline Net operating income & $ \\ \hline \end{tabular}