Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management identified two cost drivers for budgeting purposes$-$the number of cruises and the number of passengers. The company publishes a schedule of day cruises that

$2$

it may supplement with special sailings if there is sufficient demand. Up to $84$ passengers can be accommodated on the tour boat.

points

Data concerning the company's cost formulas appear below:

Skipped

References

Print

Ask

Hint

$\backslash$table$[[,$Fixed Cost$],[$per Month,Cruise,Cost per$],[$Passenger$,,]]$

For example, vessel operating costs should be $$6,500$ per month plus $$479\mathrm{.}00$ per cruise plus $$3\mathrm{.}30$ per passenger. The company's sales should average $$33\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.

$\backslash$table$[[$Alyeski Tours$],[$Flexible Budget,$],[,],[,],[,],[$Revenue the Month Ended July $31,],[$Expenses:$,],[$Vessel operating costs,$],[$Advertising$,],[$Administrative costs,$],[$Insurance$,],[$Total expenses,$],[$Net operating income,$]]$