Concept explainers
Prepare a Flexible Budget with More Than One Cost Driver
Alyeski Tours operates day tours of coastal glaciers in Alaska on its tow boat the Blue Glacer. 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 companys cost formulas appear below:
For example, vessel operating costs should be Ss.200 per month plus $480 per cruise plus $2 per passenger. The company’s sales should average S2S per passenger. In July. the company provided 24 cruises for a total of 1,400 passengers.
Required: Using Exhibit 9−7 as your guide, prepare the company’s flexible budget for July.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
GEN COMBO LOOSELEAF INTRODUCTION TO MANAGERIAL ACCOUNTING; CONNECT AC
- 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…arrow_forwardAlyeski 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 87 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Vessel operating costs Advertising Administrative costs Insurance For example, vessel operating costs should be $6,500 per month plus $475.00 per cruise plus $3.10 per passenger. The company's sales should average $34.00 per passenger. In July, the company provided 57 cruises for a total of 3,150 passengers. Required: Prepare the company's flexible budget for July. Revenue Expenses: Fixed Cost per Cost per Month Cruise $6,500 $475.00 $ 2,100 $ 5,700 $31.00 $ 3,500 Alyeski Tours Flexible Budget For the Month Ended July 31 Vessel operating…arrow_forwardNonearrow_forward
- Nonearrow_forwardA2arrow_forwardPrepare a Flexible Budget Performance Report Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below: The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount. Required: 1. Using Exhibit 9–8 as your guide, prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. 2. Which of the variances should be of concern to management? Explain. Exhibit 9–8 Performance Report Combining Activity Variances with Revenue and Spending Variancesarrow_forward
- Please do not give solution in image format ? And Fast Answering Please ? And please explain proper steps by Step ?.arrow_forwardNovo, Inc., wants to develop an activity flexible budget for the activity of moving materials. Novo uses eight forklifts to move materials from receiving to stores. The forklifts are also used to move materials from stores to the production area. The forklifts are obtained through an operating lease that costs 18,000 per year per forklift. Novo employs 25 forklift operators who receive an average salary of 50,000 per year, including benefits. Each move requires the use of a crate. The crates are used to store the parts and are emptied only when used in production. Crates are disposed of after one cycle (two moves), where a cycle is defined as a move from receiving to stores to production. Each crate costs 1.80. Fuel for a forklift costs 3.60 per gallon. A gallon of gas is used every 20 moves. Forklifts can make three moves per hour and are available for 280 days per year, 24 hours per day (the remaining time is downtime for various reasons). Each operator works 40 hours per week and 50 weeks per year. Required: 1. Prepare a flexible budget for the activity of moving materials, using the number of cycles as the activity driver. 2. Calculate the activity capacity for moving materials. Suppose Novo works at 80 percent of activity capacity and incurs the following costs: Prepare the budget for the 80 percent level and then prepare a performance report for the moving materials activity. 3. Calculate and interpret the volume variance for moving materials. 4. Suppose that a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. What would be the budget formula for this new activity level? What is the budgeted cost for this new activity level? Has activity performance improved? How does this activity performance evaluation differ from that described in Requirement 2? Explain.arrow_forwardPlease do not give solution in image format thankuarrow_forward
- Bruer Jeep Tours operates jeep tours in the heart of the Colorado Rockies. The company bases its budgets on two measures of activity (i.e., cost drivers), namely guests and jeeps. One vehicle used in one tour on one day counts as a jeep. Each jeep has one tour guide. The company uses the following data in its budgeting: Revenue Tour guide wages Vehicle expenses Administrative expenses Fixed element Variable element per Variable element per per month guest jeep $ 0 $ 179 $ 0 $ 0 $ 0 $ 180 $ 5,800 $ 2,900 $ 19 $ 10 $ 57 $ 0 In November, the company budgeted for 366 guests and 161 jeeps. The actual activity for the month was 382 guests and 148 jeeps. Required: Prepare a report showing the company's activity variances for November. Label each variance as favorable (F) or unfavorable (U). Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Guests Jeeps Revenue…arrow_forwardAnalyze Adventure Park's staffing budget Adventure Park is a large theme park. Staffing for the theme park involves many different labor classifications, one of which is the parking lot staff. The parking lot staff collects parking fees, provides directions, and operates trams. The staff size is a function of the number of daily vehicles. Adventure Park has determined from historical experience that a staff member is needed for every 200 vehicles. Adventure Park estimates staff for both school days and nonschool days. Nonschool days are higher attendance days than school days. The number of expected vehicles for each day is as follows: School Days Nonschool Days Number of vehicles per day 3,000 8,000 Number of days per year 165 200 Parking fees are $10 per vehicle. Each parking lot employee is paid $110 per day. a. Determine the annual parking lot staff budget for school days, nonschool days, and total. School Days Nonschool Days Total Total parking lot staff expense $ b. Determine the…arrow_forwardAnalyze Adventure Park’s staffing budget Adventure Park is a large theme park. Staffing for the theme park involves many different labor classifications, one of which is the parking lot staff. The parking lot staff collects parking fees, provides directions, and operates trams. The staff size is a function of the number of daily vehicles. Adventure Park has determined from historical experience that a staff member is needed for every 200 vehicles. Adventure Park estimates staff for both school days and nonschool days. Nonschool days are higher attendance days than school days. The number of expected vehicles for each day is as follows:arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,