Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identifie

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 sufficien

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 $$6,700$ per month plus $$474\mathrm{.}00$ per cruise plus $$3\mathrm{.}20$ per passenger. The

company's sales should average $$35\mathrm{.}00$ per passenger. In July, the company provided $51$ cruises for a total of $3,150$

passengers.

Required:

Prepare the company's flexible budget for July.