FUNDAMENTALS OF COST ACCOUNTING
6th Edition
ISBN: 9781266742040
Author: LANEN
Publisher: MCG
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
Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most
costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two
factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who
will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable
cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly
true, the owner assumes that the cost of fuel and the number of customers are independent.
Contribution Margin per Service Call
Scenario
Excellent
Fair
Poor
(Price -
$ 50
Variable cost) Service Calls
40
12
Number of
10,950
8,500
6,200
In addition to the variable costs of service, the owner estimates that other costs are $63,000…
Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and
most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by
estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the
number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of
contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although
the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are
Independent.
Contribution Margin per Service Call
Scenario
Excellent
Fair
Poor
(Price -
Number of
Variable cost) Service Calls
$:30
20
12
10,450
8,000
5,700
In addition to the variable costs of service, the owner estimates that other costs are $51,000…
Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most
costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two
factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who
will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable
cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly
true, the owner assumes that the cost of fuel and the number of customers are independent.
Contribution Margin per Service Call
(Price -
Variable
cost)
$ 50
40
12
Scenario
Excellent
Fair
Poor
In addition to the variable costs of service, the owner estimates that other costs are $65,000 plus $8 for each service call in excess of…
Chapter 13 Solutions
FUNDAMENTALS OF COST ACCOUNTING
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
- Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Call (Price - Scenario Excellent Fair Poor Excellent Fair Poor Excellent In addition to the variable costs of service, the owner estimates that other costs are $49,000 plus $8 for each service call in excess…arrow_forwardLamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Call (Price - Variable cost) $ 30 20 12 Scenario Excellent Fair Poor In addition to the variable costs of service, the owner estimates that other posts are $47,000 plus $8 for each service call in excess of…arrow_forwardLamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Coll Scenario Excellent Fair Poor (Price - Number of Variable cost) Service Calls $40 Excellent 30 12 In addition to the variable costs of service, the owner estimates that other costs are $59,000 plus $8 for…arrow_forward
- Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:arrow_forwardHammond 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_forwardPlanck, the new owner of the vehicle accessory shop, is considering buying sets of winter tyres for $ 299 per set and selling each set at $ 520. Fixed costs related to this operation amount to $ 3250 per month. It is expected that 18 sets per month could be sold. How much profit will Planck make each month? Round to the nearest one. Hint: use the contribution margin approach.arrow_forward
- Projected financial results for the university's cafeteria for next year are shown. Answer each of the following independent questions. (a) How much is the contribution margin and the contribution rate? (b) How much does the business need to sell to break even? (c) If the business was to spend $23,000 to upgrade their processes, how much does the business need to sell to break even? (d) If 3% more meals were sold, what would be the resulting net income? (a) The contribution margin is $. (Type an integer or a decimal.) Sales Fixed cost Total variable cost Total cost Net income $594,000 213,440 $893,000 807,440 $85,560arrow_forwardPlank, the new owner of the vehicle accessory shop, is considering buying sets of winter tyres for $ 299 per set and selling them at $ 520 each. Fixed costs related to this operation amount to $ 3250 per month. It is expected that 18 sets per month could be sold. How much profit will Plank make each month? Hint: use the contribution margin approach.arrow_forwardA distribution company is considering three different alternatives to satisfy their customer's demands. Their options are to rent a ready distribution center (D01), Rent and mobilize a center (D02), or outsourcing (OS). The estimate for each method is shown. The lifetime for D01, D02, and OS are 3, 6, and 2 respectively. MARR is 0.04 per year. and the percentage of change for all of the cases are 0 % Note: all units are in thousand $ D01 D02 OS First Cost, $ -136 -973 0 Annual Operation Cost,$ -92 -59 -123 Salvage Value,$ 28 333 0 a: Calculate the Fw of D01? b) Calculate FW for D02 c )What is the FW for outsourcing? d: Which alternative will be selected? f: Draw the cash flow for all of these three alternatives. If contract value with subcontractor increases by 15 % every year calculate FW for Outsourcing. Is there any change in your previous decision on the basis of the new condition? If yes, which…arrow_forward
- What volume of sales (in dollars) must Disk City achieve in the coming year to maintain the same net income as projected for the current year if the unit selling price remains at $17? 2. In order to cover a 20 percent increase in the disk’s purchase price for the coming year and still maintain the current contribution-margin ratio, what selling price per disk must Disk City establish for the coming year?arrow_forwardConduct the CVP analysis for your business for the upcoming five years. Specifically, you need to do the following:3.1 Calculate how many units of your product you will need to sell to break even in each of the upcoming five years. Fixed cost $120,000, Variable costs per unit $60, Sales price per unit $100 3.2 Calculate the margin of safety in units for each of the upcoming five years. 3.3 Decide how much you would like to make in before-tax operating income (target profit) in each of the upcoming five years. Calculate how many units you would need to sell in each of the upcoming years to meet those target profit levels.arrow_forwardCost-plus target return on investment pricing. Jason Brady is the managing partner of a business that has just finished building a 60-room motel. Brady anticipates that he will rent these rooms for 15,000 nights next year (or 15,000 room-nights). All rooms are similar and will rent for the same price. Brady estimates the following operating costs for next year:arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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
Enterprise Resource Planning (ERP); Author: tutor2u;https://www.youtube.com/watch?v=A98X_bvX2QA;License: Standard Youtube License