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 85 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,400 $ 478.00 $ 3.50 Advertising $ 2,900 Administrative costs $ 5,100 $ 40.00 $ 1.50 Insurance $ 3,600 For example, vessel operating costs should be $6,400 per month plus $478.00 per cruise plus $3.50 per passenger. The company’s sales should average $32.00 per passenger. In July, the company provided 58 cruises for a total of 3,150 passengers. Required: Prepare the company’s flexible budget for July.

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 85 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,400 $ 478.00 $ 3.50 Advertising $ 2,900 Administrative costs $ 5,100 $ 40.00 $ 1.50 Insurance $ 3,600 For example, vessel operating costs should be $6,400 per month plus $478.00 per cruise plus $3.50 per passenger. The company’s sales should average $32.00 per passenger. In July, the company provided 58 cruises for a total of 3,150 passengers. Required: Prepare the company’s flexible budget for July.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 20M

See similar textbooks

Similar questions

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 81 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,300 $ 478.00 $ 3.40 Advertising $ 2,700 Administrative costs $ 5,500 $ 33.00 $ 1.50 Insurance $ 3,800 For example, vessel operating costs should be $6,300 per month plus $478.00 per cruise plus $3.40 per passenger. The company’s sales should average $29.00 per passenger. In July, the company provided 59 cruises for a total of 3,100 passengers. Required: Prepare…
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 86 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Cost per Passenger $ 3.20 Fixed Cost per Month $ 6,500 $ 2,800 $ 5,400 $ 3,700 Cost per Cruise $ 471.00 Vessel operating costs Advertising Administrative costs $ 40.00 $ 1.50 Insurance For example, vessel operating costs should be $6,500 per month plus $471.00 per cruise plus $3.20 per passenger. The company's sales should average $31.00 per passenger. In July, the company provided 57 cruises for a total of 3,000 passengers. Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible…
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 86 passengers can be accommodated on the tour boat. Data concerning the company’s cost formulas appear below: Fixed Costper Month Cost perCruise Cost perPassenger Vessel operating costs $ 6,200 $ 479.00 $ 3.20 Advertising $ 2,700 Administrative costs $ 5,400 $ 35.00 $ 1.50 Insurance $ 3,300 For example, vessel operating costs should be $6,200 per month plus $479.00 per cruise plus $3.20 per passenger. The company’s sales should average $30.00 per passenger. The company’s planning budget for July is based on 59 cruises and 3,000 passengers. Required: Complete the…
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 $ 476.00 $3.30 Advertising $ 3,000 Administrative costs $5,100 $ 32.00 $ 1.50 Insurance $3,700 For example, vessel operating costs should be $6,700 per month plus $476.00 per cruise plus $3.30 per passenger. The company's sales should average $34.00 per passenger. In July, the company provided 56 cruises for a total of 3,050 passengers. Required: Prepare the company's flexible budget for July.
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 88 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Cost per Passenger $ 3.30 Fixed Cost per Month Vessel operating costs $ 6,100 Cost per Cruise $ 474.00 $ 2,300 Administrative costs $ 5,800 $ 3,900 $ 30.00 $ 1.50 Advertising Insurance For example, vessel operating costs should be $6,100 per month plus $474.00 per cruise plus $3.30 per passenger. The company's sales should average $29.00 per passenger. In July, the company provided 59 cruises for a total of 3,000 passengers. Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible…
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 85 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Fixed Cost per Month $ 6,100 $ 2,400 $ 5,300 $ 3,900 Cost per Cruise $ 472.00 Cost per Passenger $ 3.30 Vessel operating costs Advertising Administrative costs $ 38.00 $ 1.50 Insurance For example, vessel operating costs should be $6,100 per month plus $472.00 per cruise plus $3.30 per passenger. The company's sales should average $30.00 per passenger. In July, the company provided 60 cruises for a total of 3,050 passengers. Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible…
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…
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 Cost per Cost per Month Cruise Passenger 5,200 480.00 Vessel operating costs $ $ $2.00 Advertising $1,700 4,300 24.00 Administrative costs $ $ $ 1.00 2,900 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. The company's planning budget for July is based on 24 cruises and 1,400 passengers. Required: Complete the company's planning budget for July.
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 85 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Vessel operating costs Advertising Administrative costs Insurance Fixed Cost per Month $6,600 $2,200 $5,900 $3,100 Required: Complete the company's planning budget for July. For example, vessel operating costs should be S6,600 per month plus $471.00 per cruise plus $3.10 per passenger. The company's sales should average $34.00 per passenger. The company's planning budget for July is based on 55 cruises and 3,150 passengers. Alyeski Tours Planning Budget For the Month Ended July 31 Revenue Expenses: Vessel…
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 81 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Fixed Cost Cost per Cost per per Month $ 6,400 $ 2,900 $ 5,900 $ 3,200 Cruise Passenger $ 3.40 $ 475.00 Vessel operating costs Advertising Administrative costs $ 38.00 $ 1.50 Insurance For example, vessel operating costs should be $6,400 per month plus $475.00 per cruise plus $3.40 per passenger. The company's sales should average $30.00 per passenger. In July, the company provided 57 cruises for a total of 3,100 passengers. Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible…
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 it may supplement with special sailings if there is sufficient demand. Up to 85 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Vessel operating costs Advertising Fixed Cost Cost per per Cost per Month Cruise Passenger $ $ 3.30 6,000 470.00 $ $ 2,400 Administrative $ $ $ 1.50 costs 5,700 35.00 Insurance $ 3,700 For example, vessel operating costs should be $6,000 per month plus $470.00 per cruise plus $3.30 per passenger. The company's sales should average $28.00 per passenger. In July, the company provided 53 cruises for a total of 3,200 passengers. Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible Budget For the Month Ended July 31…
es 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: Vessel operating costs Advertising Administrative costs Insurance Fixed Cost per Month $ 5,200 $1,700. $ 4,300 $ 2,900 Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible Budget Cost per Cruise $480.00 $ 24.00 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. Cost per Passenger $ 2.00 $ 1.00

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	Fixed Cost per Month	Cost per Cruise	Cost per Passenger
Vessel operating costs	$	6,400		$	478.00	$	3.50
Advertising	$	2,900
Administrative costs	$	5,100		$	40.00	$	1.50
Insurance	$	3,600