Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 3E
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Analyze 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…
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…
Analyze 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:
Chapter 9 Solutions
Introduction To Managerial Accounting
Ch. 9.A - Fixed Overhead Variances Primara Corporation has a...Ch. 9.A - Predetermined Overhead Rate: Overhead Variances...Ch. 9.A - Applying Overhead in a Standard Costing System...Ch. 9.A - Prob. 4ECh. 9.A - Using Fixed Overhead Variances The standard cost...Ch. 9.A - Prob. 6ECh. 9.A - Relations Among Fixed Overhead Variances Selected...Ch. 9.A - Applying Overhead; Overhead Variances Lane Company...Ch. 9.A - Applying Overhead; Overhead Variances Chilczuk....Ch. 9.A - Comprehensive Standard Cost Variances "Wonderful!...
Ch. 9.A - Comprehensive Standard Cost Variances Flandro...Ch. 9.A - Selection of a Denominator: Overhead Analysis:...Ch. 9.B - Standard Cost Flows: Income Statement Preparation...Ch. 9.B - Standard Cost Flows: Income Statement Preparation...Ch. 9.B - Standard Cost Flows Bowen Company manufactures one...Ch. 9.B - Standard Cost Flows Hartwell Company manufactures...Ch. 9.B - Transaction Analysis; Income Statement Preparation...Ch. 9.B - Transaction Analysis; Income Statement Preparation...Ch. 9 - What is a static planning budget?Ch. 9 - What is a flexible budget and how does it differ...Ch. 9 - What are some of the possible reasons that actual...Ch. 9 - Why is it difficult to interpret a difference...Ch. 9 - What is a revenue variance and what does it mean?Ch. 9 - What is a spending variance and what does it mean?Ch. 9 - What does a flexible budget enable that a simple...Ch. 9 - How does a flexibe budget based on the cost...Ch. 9 - Prob. 9QCh. 9 - Why are separate price and quantity variances...Ch. 9 - Who is generally responsible for the materials...Ch. 9 - Prob. 12QCh. 9 - Prob. 13QCh. 9 - Our workers are all under labor contracts:...Ch. 9 - Prob. 15QCh. 9 - Prob. 16QCh. 9 - Prob. 17QCh. 9 - The Excel worksheet form that appears below is to...Ch. 9 - Prob. 2AECh. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 2F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 4F15Ch. 9 - Prob. 5F15Ch. 9 - Prob. 6F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 8F15Ch. 9 - Prob. 9F15Ch. 9 - Prob. 10F15Ch. 9 - Prob. 11F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prob. 13F15Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Preble Company manufactures one product. Its...Ch. 9 - Prepare a Flexible Budget Puget Sound Divers is a...Ch. 9 - Prepare a Report Shong Revenue and Spending...Ch. 9 - Prepare a Flexible Budget with More Than One Cost...Ch. 9 - Direct Materials Variances Bandar Industries...Ch. 9 - Prob. 5ECh. 9 - Prob. 6ECh. 9 - Planning Budget Lavage Rapide is a Canadian...Ch. 9 - EXERCISE 98 Flexible Budget L091 Refer to the data...Ch. 9 - Prepare a Report Showing Revenue and Spending...Ch. 9 - Direct Labor and Variable Manufacturing Overhead...Ch. 9 - Prob. 11ECh. 9 - Working with More Than One Cost Driver The...Ch. 9 - Direct Materials and Direct Labor Variances Huron...Ch. 9 - Direct Materials Variances Refer to the data in...Ch. 9 - Prob. 15ECh. 9 - Prob. 16ECh. 9 - Prob. 17ECh. 9 - Comprehensive Variance Analysis Miller Toy Company...Ch. 9 - More than One Cost Driver Milano Pizza is a small...Ch. 9 - Basic Variance Analysis: the Impact of Vanances on...Ch. 9 - Multiple Products. Materials, and Processes...Ch. 9 - Variance Analysis In a Hospital John Fleming,...Ch. 9 - Flexible Budgets and Spending Variances You have...Ch. 9 - Comprehensive Variance Analysis Marvel Parts....Ch. 9 - Direct Materials and Direct Labor Variances:...Ch. 9 - Comprehensive Variance Analysis Highland Company...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Novo, 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_forwardMcinerney 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: Fixed elementper month Variable elementper guest Variable element per jeep Revenue $ 0 $ 161 $ 0 Tour guide wages $ 0 $ 0 $ 132 Vehicle expenses $ 4,600 $ 22 $ 75 Administrative expenses $ 3,300 $ 15 $ 0 In October, the company budgeted for 339 guests and 105 jeeps. The actual activity for the month was 410 guests and 152 jeeps. Required: Prepare the company's flexible budget for the actual level of activity in October.arrow_forwardCryan 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: Fixed elementper month Variable elementper guest Variable element per jeep Revenue $ 0 $ 157 $ 0 Tour guide wages $ 0 $ 0 $ 167 Vehicle expenses $ 5,000 $ 9 $ 64 Administrative expenses $ 1,500 $ 8 $ 0 In May, the company budgeted for 467 guests and 172 jeeps. The company's income statement showing the actual results for the month appears below: Cryan Jeep Tours Income Statement For the Month Ended May 31 Actual guests 482 Actual jeeps 167 Revenue $ 65,854 Expenses: Tour guide wages 28,357 Vehicle expenses 17,640 Administrative expenses 4,888 Total expense 50,885 Net operating…arrow_forward
- NEED HELP ASAP!!!! Cryan 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: Fixed element per month Variable element per guest Variable element per jeep $0 $ 287 $0 Tour guide wages $0 $0 $ 154 Vehicle expenses $ 6,300 $ 22 $77 Administrative expenses $ 2,800 $ 21 $0 In May, the company budgeted for 532 guests and 237 jeeps. The company's income statement showing the actual results for the month appears below: Revenue Cryan Jeep Tours Income Statement For the Month Ended May 31 Actual guests Actual jeeps Revenue Expenses: Tour guide wages Vehicle expenses Administrative expenses Total expense Net operating income 547 232 $ 122,854 38,757 24,140 11,388 74,285 $ 48,569 Required: Prepare a report showing the company's revenue…arrow_forwardBruer 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: Guests Jeeps Revenue Expenses: Fixed element per month Revenue $0 Tour guide wages Vehicle expenses $ 6,000 Administrative expenses $ 3,100 In November, the company budgeted for 370 guests and 165 Jeeps. The actual activity for the month was 384 guests and 150 Jeeps. Tour guide wages Vehicle expenses Administrative expenses Total expense Net operating income Variable element per guest $183 Required: Prepare a report showing the company's activity variances for November. Label each varlance as favorable (F) or unfavorable (U). (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero varlance). Input…arrow_forwardActivity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $58,000 per year (A total of 12,000 welding hours are supplied by the six workers.) • Welding supplies: $400 per job • Welding hours: 4 hours used per job During the year, the activity operated at 95 percent of capacity and incurred the following actual activity and resource costs. • Lease cost: $60,000 • Salaries: $365,400 • Parts and supplies: $1,134,200 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. Welding cost = $fill in the blank e95687f99006fa4_1 + $fill in the blank e95687f99006fa4_2 X 2. Prepare a performance report for the welding activity. In the last column of Foy Company Activity-Based…arrow_forward
- Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…arrow_forwardActivity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $11,000 per year per unit • Six welding employees each paid a salary of $51,000 per year (A total of 12,000 welding hours are supplied by the six workers.) • Welding supplies: $400 per job • Welding hours: 4 hours used per job During the year, the activity operated at 85 percent of capacity and incurred the following actual activity and resource costs. • Lease cost: $44,000 • Salaries: $321,300 • Parts and supplies: $1,014,900 1. Prepare a performance report for the welding activity. In the last column of Foy Company Activity-Based Performance Report, if variance amount is unfavorable select "U" , select "F", if it is Favorable and select "NA" if there is no variance. Foy Company Activity-Based Performance Report Activity Actual Cost Budgeted Cost…arrow_forwardCompute the Margin of Safety Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month’s budget appear below: Required: 1. What is the company’s margin of safety? 2. What is the company’s margin of safety as a percentage of its sales?arrow_forward
- Analyze Adventure Park’s Staffing Budget Describe and illustrate the use of staffing budgets for nonmanufacturing businesses. 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 non school days. Non school 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. Determine the annual parking lot staff budget for school…arrow_forwardOzark Bird Hunters (OBH) conducts birding tours in the local area. The company owners create a management budget using two measures of activities (also referred to as cost drivers): Customers and Jeeps. Each tour conducted includes one field guide with one jeep. OBH uses the following data to create the budget: Fixed cost Variable cost per Variable cost per per month Customer Jeep Revenue $ 650 Field Guide fee $ 275 Jeep expenses $ 3,500 Administrative expenses $ 1,500 In April, the company budgeted for 500 customers and 100 jeeps. The actual activity for the month was 524 customers and 110 jeeps. Create a report showing the activity variances for April. The FORMAT of your report should look EXACTLY like the report in your textbook in Exhibit 9-6 on page 411. Label each variance as favorable (F) or Unfavorable (U). If rounding is required, round to the nearest whole dollar (for example, $10.666666667 would be $11)arrow_forwardGig Harbor Boating is the wholesale distributor of a small recreational catamaran sailboat. Management has prepared the following summary data to use in its annual budgeting process: Budgeted unit sales Selling price per unit Cost per unit Variable selling and administrative expense (per unit) Fixed selling and administrative expense (per year) Interest expense for the year Required: Prepare the company's budgeted income statement for the year. Gig Harbor Boating Budgeted Income Statement Check my workarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones 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 Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY