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 90 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 Vessel operating costs $ 6,700 $ 472.00 $ 3.40 Advertising $ 2,500     Administrative costs $ 5,300 $ 36.00 $ 1.50 Insurance $ 3,700       For example, vessel operating costs should be $6,700 per month plus $472.00 per cruise plus $3.40 per passenger. The company’s sales should average $28.00 per passenger. In July, the company provided 55 cruises for a total of 3,050 passengers.   Required: Prepare the company’s flexible budget for July.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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 90 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
Vessel operating costs $ 6,700 $ 472.00 $ 3.40
Advertising $ 2,500    
Administrative costs $ 5,300 $ 36.00 $ 1.50
Insurance $ 3,700    

 

For example, vessel operating costs should be $6,700 per month plus $472.00 per cruise plus $3.40 per passenger. The company’s sales should average $28.00 per passenger. In July, the company provided 55 cruises for a total of 3,050 passengers.

 

Required:

Prepare the company’s flexible budget for July.

**Alyeski Tours**

**Flexible Budget**

**For the Month Ended July 31**

|                               | Amount   |
|-------------------------------|----------|
| Revenue                       |          |
| **Expenses:**                 |          |
| - Vessel operating costs      |          |
| - Advertising                 |          |
| - Administrative costs        |          |
| - Insurance                   |          |
| **Total expense**             |          |
| **Net operating income**      |          |

This table is a template for creating a flexible budget for Alyeski Tours for the month ending July 31. It includes sections for revenue and various expenses, such as vessel operating costs, advertising, administrative costs, and insurance. The total expense and net operating income are calculated by summing up the expenses and subtracting them from the revenue.
Transcribed Image Text:**Alyeski Tours** **Flexible Budget** **For the Month Ended July 31** | | Amount | |-------------------------------|----------| | Revenue | | | **Expenses:** | | | - Vessel operating costs | | | - Advertising | | | - Administrative costs | | | - Insurance | | | **Total expense** | | | **Net operating income** | | This table is a template for creating a flexible budget for Alyeski Tours for the month ending July 31. It includes sections for revenue and various expenses, such as vessel operating costs, advertising, administrative costs, and insurance. The total expense and net operating income are calculated by summing up the expenses and subtracting them from the revenue.
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education