Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible Budget For the Month Ended July 31
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![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:
Fixed Cost per Month Cost per Cruise Cost per Passenger
$ 480.00
Vessel operating costs
Advertising
Administrative costs
$ 5,200
$1,700
$ 4,300
$ 2,900
$2.00
$ 24.00
$1.00
Insurance
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.
Alyeski Tours
Flexible Budget
For the Month Ended July 31
Revenue
Expenses:
Vessel operating costs
Advertising
Administrative costs
Insurance
Total expense
Net operating income](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F217af487-2bd5-4c3c-9135-0f568fa5de33%2F4319c5ab-3b82-4e74-bc64-d8852fbaa704%2Fqkh9ez9_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Financial And Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)