Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
6th Edition
ISBN: 9781260848700
Author: William N. Lanen Professor, Shannon Anderson Associate Professor, Michael W Maher
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 13, Problem 48E
Sensitivity Analysis
Classic Limo, Inc., provides limousine service to Tri-Cities airport. The price of the service is fixed at a flat rate for each trip and most costs of the providing the service are stable for each trip. Marc Pence, the owner, budgets income by estimating two factors that fluctuate with the economy: the fuel cost associated with each trip and the number of customers who will take trips. Looking at next year, Marc develops the following estimates of contribution margin (price less variable cost of the trip, including fuel) and for the estimated number of customers. Although Marc understands that it is not strictly true, he assumes that the cost of fuel and the number of customers are independent.
In addition to the costs of a ride, Marc estimates that other service costs are $50,000 plus $5 for each customer (ride) in excess of 6,000 rides. Annual administrative and marketing costs are estimated to be $25,000 plus 10 percent of the contribution margin.
Required
Use a spreadsheet to prepare an analysis of the possible operating income for Classic Limo, Inc., similar to that in Exhibit 13.5. What is the range of possible operating incomes?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Classic Limo, Inc., provides limousine service to Tri-Cities airport. The price of the service is fixed at a flat rate for each trip and most costs of providing service are stable for each trip. Marc Pence, the owner, budgets income by estimating two factors that fluctuate with the economy: the fuel cost associated with each trip and the number of customers who will take trips. Looking at next year, Marc develops the following estimates of contribution margin (price less variable cost of the trip, including fuel) and for the estimated number of customers. Although Marc understands that it is not strictly true, he assumes that the cost of fuel and the number of customers are independent.
Contribution Margin per Ride
Scenario
(Price – Variable cost)
Number of Customers
Excellent
$55
4,800
Fair
25
3,500
Poor
20
2,200
In addition to the costs of a ride, Marc estimates that other service costs are $41,000 plus $5…
Using sensitivity analysis
The Circle Clock Company sells a particular clock for $25. The variable costs are $13 per clock and the breakeven point is 250 clocks. The company expects to sell 300 clocks this year. If the company actually Sells 400 clocks, what effect would the sale of additional 100 clocks have on operating income? Explain your answer.
CVP and Margin of Safety Bristol Car Service offers airport service in a mid-size city. Bristol charges $50 per trip to or from the airport. The variable cost for a trip totals S12, for fuel, driver, and so on. The monthly fixed cost for Bristol Rainbow Tours is S2,736.
Required
1-How many trips must Bristol sell every month to break even?
2-Bristol's owner believes that 90 trips is a reasonable forecast of the average monthly demand.What is the margin of safety in terms of the number of airport trips!
Chapter 13 Solutions
Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
Ch. 13 - Prob. 1RQCh. 13 - Prob. 2RQCh. 13 - Prob. 3RQCh. 13 - What role does the master budget play in the...Ch. 13 - What problems might arise if a firm relies solely...Ch. 13 - What is the coordinating role of budgeting?Ch. 13 - Prob. 7RQCh. 13 - Write out the inventory equation that is used to...Ch. 13 - What makes creating budgets for marketing and...Ch. 13 - Prob. 10RQ
Ch. 13 - Preparing a budget is a waste of time. The...Ch. 13 - In the Business Application feature, Using the...Ch. 13 - Prob. 13CADQCh. 13 - Would the budgeting plans for a company that uses...Ch. 13 - Government agencies are limited in spending by...Ch. 13 - What is the difference between the planning and...Ch. 13 - When might the master budget start with a forecast...Ch. 13 - In some organizations (firms, universities,...Ch. 13 - Our cash budget shows a surplus for the quarter,...Ch. 13 - Your boss asks for your estimate on the costs of a...Ch. 13 - The chapter identified four techniques used for...Ch. 13 - Role of Budgets and Plans
Cosmic Corporation is a...Ch. 13 - Human Element in Budgeting
Roller Partners is a...Ch. 13 - Estimate Sales Revenues Stubs-R-Us is a local...Ch. 13 - Estimate Sales Revenues Friendly Financial has 160...Ch. 13 - Estimate Sales Revenues Larson, Inc., manufactures...Ch. 13 - Estimate Production Levels Offenbach Son has just...Ch. 13 - Estimate Sales Levels Using Production Budgets...Ch. 13 - Estimate Inventory Levels Using Production Budgets...Ch. 13 - Estimate Production Levels: Capacity Constraints...Ch. 13 - Prob. 31ECh. 13 - Estimate Purchases and Cash Disbursements Midland...Ch. 13 - Estimate Purchases and Cash Disbursements Lakeside...Ch. 13 - Estimate Cash Disbursements Cascade, Ltd., a...Ch. 13 - Estimate Cash Collections Minot Corporation is...Ch. 13 - Estimate Cash Collections Ewing Company is...Ch. 13 - Estimate Cash Receipts Scare-2-B-U (S2BU)...Ch. 13 - Estimate Cash Receipts Varmit-B-Gone is a pest...Ch. 13 - Prepare Budgeted Financial Statements
Refer to the...Ch. 13 - Prepare Budgeted Financial Statements Cycle-1 is a...Ch. 13 - Prepare Budgeted Financial Statements Carreras Caf...Ch. 13 - Budgeting in a Service Organization Executive...Ch. 13 - Prob. 43ECh. 13 - Prob. 44ECh. 13 - Prob. 45ECh. 13 - Prob. 46ECh. 13 - Sensitivity Analysis Sanjanas Sweet Shoppe...Ch. 13 - Sensitivity Analysis Classic Limo, Inc., provides...Ch. 13 - Prob. 49ECh. 13 - Prob. 50ECh. 13 - Prepare Budgeted Financial Statements The...Ch. 13 - Prob. 52PCh. 13 - Prepare Budgeted Financial Statements Gulf States...Ch. 13 - Prob. 54PCh. 13 - Prob. 55PCh. 13 - Prepare a Production Budget Haggstrom, Inc.,...Ch. 13 - Sales Expense Budget SPU, Ltd., has just received...Ch. 13 - Budgeted Purchases and Cash Flows Mast Corporation...Ch. 13 - Prepare Budgeted Financial Statements HomeSuites...Ch. 13 - Prob. 60PCh. 13 - Comprehensive Budget Plan Brighton, Inc.,...Ch. 13 - Comprehensive Budget Plan Panther Corporation...Ch. 13 - Budgeted Financial Statements in a Retail...Ch. 13 - Cash Budgets and Sensitivity Analysis in a Retail...Ch. 13 - Prob. 66IC
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
- Hammond Company runs a driving range and golf shop. The budgeted income statement for the coming year is as follows. Required: 1. What is Hammonds variable cost ratio? Its contribution margin ratio? 2. Suppose Hammonds actual revenues are 200,000 greater than budgeted. By how much will before-tax profits increase? Give the answer without preparing a new income statement. 3. How much sales revenue must Hammond earn in order to break even? What is the expected margin of safety? (Round your answers to the nearest dollar.) 4. How much sales revenue must Hammond generate to earn a before-tax profit of 130,000? An after-tax profit of 90,000? (Round your answers to the nearest dollar.) Prepare a contribution margin income statement to verify the accuracy of your last answer.arrow_forwardBrahma Industries sells vinyl replacement windows to home improvement retailers nationwide. The national sales manager believes that if they invest an additional $25,000 in advertising, they would increase sales volume by 10,000 units. Prepare a forecasted contribution margin income statement for Brahma if they incur the additional advertising costs, using this information:arrow_forwardMyrtle Air Express decided to offer direct service from Cleveland to Myrtle Beach. Management must decide between a full-price service using the companys new fleet of jet aircraft and a discount service using smaller-capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based on two possible levels of demand for service to Myrtle Beach: strong and weak. The following table shows the estimated quarterly profits (in thousands of dollars): a. What is the decision to be made, what is the chance event, and what is the consequence for this problem? How many decision alternatives are there? How many outcomes are there for the chance event? b. If nothing is known about the probabilities of the chance outcomes, what is the recommended decision using the optimistic, conservative, and minimax regret approaches? c. Suppose that management of Myrtle Air Express believes that the probability of strong demand is 0.7 and the probability of weak demand is 0.3. Use the expected value approach to determine an optimal decision. d. Suppose that the probability of strong demand is 0.8 and the probability of weak demand is 0.2. What is the optimal decision using the expected value approach? e. Use sensitivity analysis to determine the range of demand probabilities for which each of the decision alternatives has the largest expected value.arrow_forward
- Schylar Pharmaceuticals, Inc., plans to sell 130,000 units of antibiotic at an average price of 22 each in the coming year. Total variable costs equal 1,086,800. Total fixed costs equal 8,000,000. (Round all ratios to four significant digits, and round all dollar amounts to the nearest dollar.) Required: 1. What is the contribution margin per unit? What is the contribution margin ratio? 2. Calculate the sales revenue needed to break even. 3. Calculate the sales revenue needed to achieve a target profit of 245,000. 4. What if the average price per unit increased to 23.50? Recalculate: a. Contribution margin per unit b. Contribution margin ratio (rounded to four decimal places) c. Sales revenue needed to break even d. Sales revenue needed to achieve a target profit of 245,000arrow_forwardMarginal cost-benefit analysis and the goal of the firm Ken Allen, capital budgeting analyst for Bally Gears, Inc., has been asked to evaluate a proposal. The manager of the automotive division believes that replacing the robotics used on the heavy truck gear line will produce total benefits of $584,000 (in today's dollars) over the next 5 years. The existing robotics would produce benefits of $398,000 (also in today's dollars) over that same time period. An initial cash investment of $233,600 would be required to install the new equipment. The manager estimates that the existing robotics can be sold for $62,000. Show how Ken will apply marginal cost-benefit analysis techniques to determine the following: a. The marginal (added) benefits of the proposed new robotics is.......? b. The marginal (added) cost of the proposed new robotics is...........? c. The net benefit of the proposed new robotics is........? d. Ken Allen should recommend the company............? (Select the…arrow_forwardDerby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 18 per unit Variable costs 7 per unit Fixed costs 27,000 per month Assume that the projected number of units sold for the month is 7,000. Consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? b. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? d. Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?arrow_forward
- Hello please help with the problem below. Thanks Last year’s operating income for the Barnum company was $30,000. The selling price during the year was $15 per unit. The total variable costs were $180,000 and total fixed costs were $90,000. The sales manager wants to increase the selling price next year by 15% although she knows that the number of units sold would likely be reduced by 10%. If her proposal is adopted and her assumption about volume of sales is correct, what would the new operating income be?arrow_forwardCost-plus, target return on investment pricing. Sweet Tastings makes candy bars for vending machines and sells them to vendors in cases of 30 bars. Although Sweet Tastings makes a variety of candy, the cost differences are insignificant, and the cases all sell for the same price. Sweet Tastings has a total capital investment of $10,000,000. It expects to produce and sell 400,000 cases of candy next year. Sweet Tastings requires a 12% target return on investment. Expected costs for next year are:arrow_forwardDerby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 21 per unit Variable costs 7 per unit Fixed costs 27,000 per month Assume that the projected number of units sold for the month is 7,000. consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? B. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? d. suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much? complete this question by entering your…arrow_forward
- Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 21 per unit Variable costs 7 per unit Fixed costs 27,000 per month Assume that the projected number of units sold for the month is 7,000. consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? B. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? d. suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much? complete this question by entering your…arrow_forwardDerby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 22 per unit Variable costs 5 per unit Fixed costs 25,000 per month Assume that the projected number of units sold for the month is 7,000. Consider requirements (b), (c), and (d) independently of each other. Required: b. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent?arrow_forwardDerby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 23 per unit Variable costs 6 per unit Fixed costs 24,000 per month Assume that the projected number of units sold for the month is 6,000. Consider requirements (b), (c), and (d) independently of each other. Required: What will the operating profit be? What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Enterprise Resource Planning (ERP); Author: tutor2u;https://www.youtube.com/watch?v=A98X_bvX2QA;License: Standard Youtube License