Concept explainers
CVP Analysis—Sensitivity Analysis (spreadsheet recommended)
Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer courses on tile installation, which might also increase the demand for its products. The basic installation course has the following (tentative) price and cost characteristics:
Required
- a. What enrollment will enable Alameda Tile to break even?
- b. How many students will enable Alameda Tile to make an operating profit of $80,000 for the year?
- c. Assume that the projected enrollment for the year is 800 students for each of the following (considered independently):
- 1. What will be the operating profit (for 800 students)?
- 2. What would be the operating profit if the tuition per student (that is, sales price) decreased by 10 percent? Increased by 20 percent?
- 3. What would be the operating profit if variable costs per student decreased by 10 percent? Increased by 20 percent?
- 4. Suppose that fixed costs for the year are 10 percent lower than projected, whereas variable costs per student are 10 percent higher than projected. What would be the operating profit for the year?
a.
Calculate the enrolment required to break-even for Company A.
Answer to Problem 53P
Company A requires 500 enrolments to break-even.
Explanation of Solution
Breakeven point (BEP): The breakeven point or BEP is that level of output at which the total revenue is equal to the total cost. The BEP means there are no operating income and no operating losses. The management keeps an eye on the breakeven point in order to avoid the operating losses in order to avoid losses.
Contribution margin: The excess of sales price over the variable expenses is referred to as the contribution margin. It is computed by deducting the variable expenses from the sales revenue.
Compute the break-even point:
Thus, Company A requires 500 enrolments to break-even.
Working note 1:
Compute the contribution margin:
b.
Calculate the enrolment required to make the operating profit of $80,000 for the year.
Answer to Problem 53P
Company A requires 750 enrolments to make the operating profit of $80,000 for the year.
Explanation of Solution
Operating profit: The operating profit is the excess of total revenues over total expenses after adjusting for depreciation and taxes.
Compute the enrolments required to make the operating profit of $80,000 for the year:
Thus, Company A requires 750 enrolments to make the operating profit of $80,000 for the year.
c.
- 1. Calculate the operating profit of 800 students.
- 2. Calculate the operating profit when tuition fee per students decreases by 10%. Increases by 20%.
- 3. Calculate the operating profit when the variable cost per students decreases by 10%. Increases by 20%.
- 4. Calculate the operating profit when fixed cost decreases by 10% and variable cost increases by 10%.
Answer to Problem 53P
- 1. Operating profit for selling 800 units is $96,000.
- 2. Operating profit will be $32,000 if the tuition fee per student decreases by 10%.
Operating profit will be $224,000 if tuition fee per student increases by 20%.
- 3. Operating profit will be $134,400 if the variable cost per student decreases by 10%.
Operating profit will be $19,200 if the variable cost per student increases by 20%.
- 4. Operating profit will be $73,600 if fixed costs for the year are 10 per cent lower than projected, whereas variable costs per student are 10 per cent higher than projected.
Explanation of Solution
Target volume: the level of sales which need to be achieved during a particular period of time is termed as target volume.
Target profit: the amount of profit which needs to be achieved during a particular period of time on a particular level of sales is termed as target profit.
1.
Compute the operating profit for 800 units:
Thus, operating profit for selling 800 units is $96,000.
2.
(I)
Calculate the operating profit when tuition fee per students decreases by 10%.
Thus, operating profit will be 32,000 if tuition fee per student decreases by 10%.
Working note 2:
Revised sales price:
(II)
Calculate the operating profit when tuition fee per students increases by 20%:
Thus, operating profit will be 224,000 if tuition fee per student increases by 20%.
Working note 3:
Revised sales price:
3.
(I)
Calculate the operating profit when variable per students decreases by 10%.
Thus, operating profit will be 134,400 if the variable cost per student decreases by 10%.
Working note 4:
Revised variable cost:
(II)
Calculate the operating profit when the variable cost per students increases by 20%:
Thus, operating profit will be $19,200 if the variable cost per student increases by 20%.
Working note 5:
Revised variable price:
4.
Compute the operating profit if fixed costs for the year are 10 per cent lower than projected, whereas variable costs per student are 10 per cent higher than projected:
Thus, operating profit will be $73,600 if fixed costs for the year are 10 per cent lower than projected, whereas variable costs per student are 10 per cent higher than projected.
Working note 6:
Compute the revised variable cost:
Working note 7:
Compute the revised fixed cost:
Want to see more full solutions like this?
Chapter 3 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- You own a furniture manufacturing company. You are looking to expand into glass furniture and need to buy new manufacturing equipment to manufacture this type of furniture. You have researched many suppliers but have found that two machines will best suit your needs. The cost of machine 1 is $90,000, and the cost of machine 2 is $110,000. The estimated net profits the machines will generate are in the attached image. a)Compare the ARR for both machines and decide which machine you should buy. b)Critically evaluate the ARR technique in evaluating investment options.arrow_forwardShonda & Shonda is a company that does land surveys and engineering consulting. They have an opportunity to purchase new computer equipment that will allow them to render their drawings and surveys much more quickly. The new equipment will cost them an additional $1.200 per month, but they will be able to increase their sales by 10% per year. Their current annual cost and break-even figures are as follows: A. What will be the impact on the break-even point if Shonda & Shonda purchases the new computer? B. What will be the impact on net operating income if Shonda & Shonda purchases the new computer? C. What would be your recommendation to Shonda & Shonda regarding this purchase?arrow_forwardEthical Behavior Consider the following scenario between Dave, a printer, and Steve, an assistant in the local universitys athletic department. Steve: Dave, our department needs to have 10,000 posters printed for the basketball team for next year. Heres the mock-up, and well need them in a month. How much will you charge? Dave: Well, given the costs I have for ink and paper, 1 can come in at around 5,000. Steve: Great, heres what I want you to do. Print me up an invoice for 7,500. Huts our budget. Then, when they pay you, you give me a check for 2,500. Ill make sure that you get the job. Required: CONCEPTUAL CONNECTION Is Steves proposal ethical? What should Dave do?arrow_forward
- Colin OShea has a carpentry shop that employs 4 carpenters. Colin received an order for 1,000 coffee tables. The coffee tables have a round table top and four decorative legs. An offer for $500 per table was received. Colin found an unfinished round table top that he could buy for $50 each. A. Using this quantitative cost data to make the table top, should Colin buy the table top or make it? B. What qualitative factors would be included in your decision. B. Can the vendor make it to the same quality standards? Can it be completed on time? Is there idle capacity in the factory that could be used?arrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?arrow_forwardSouthland Corporation’s decision to produce a new line of recreational products resulted in the need to construct either a small plant or a large plant. The best selection of plant size depends on how the marketplace reacts to the new product line. To conduct an analysis, marketing management has decided to view the possible long-run demand as low, medium, or high. The following payoff table shows the projected profit in millions of dollars: What is the decision to be made, and what is the chance event for Southland’s problem? Construct a decision tree. Recommend a decision based on the use of the optimistic, conservative, and minimax regret approaches.arrow_forward
- Keith Golding has decided to purchase a personal computer. He has narrowed his choices to two: Brand A and Brand B. Both brands have the same processing speed, hard disk capacity, RAM, graphics card memory, and basic software support package. Both come from companies with good reputations. The selling price for each is identical. After some review, Keith discovers that the cost of operating and maintaining Brand A over a three-year period is estimated to be 200. For Brand B, the operating and maintenance cost is 600. The sales agent for Brand A emphasized the lower operating and maintenance cost. She claimed that it was lower than any other PC brand. The sales agent for Brand B, however, emphasized the service reputation of the product. She provided Keith with a copy of an article appearing in a PC magazine that rated service performance of various PC brands. Brand B was rated number one. Based on all the information, Keith decided to buy Brand B. Required: 1. What is the total product purchased by Keith? 2. Is the Brand A company pursuing a cost leadership or differentiation strategy? The Brand B company? Explain. 3. When asked why he purchased Brand B, Keith replied, I think Brand B offered more value than Brand A. What are the possible sources of this greater value? If Keiths reaction represents the majority opinion, what suggestions could you offer to help improve the strategic position of Brand A?arrow_forwardYou own a furniture manufacturing company. You are looking to expand into glass furniture and need to buy new manufacturing equipment to manufacture this type of furniture. You have researched many suppliers but have found that two machines will best suit your needs. The cost of machine 1 is $90,000, and the cost of machine 2 is $110,000. The estimated net profits the machines will generate are in the following table: Net Profit Machine 1 (cost $90,000) Machine 2 (cost $110,000) Year 1 $20,000 $10,000 Year 2 $30,000 $20,000 Year 3 $40,000 $40,000 Year 4 $20,000 $60,000 Year 5 $20,000 $50,000 Total $130,000 $180,000 a) Compare the ARR for both machines and decide which machine you should buy. b. Critically evaluate the ARR technique in evaluating investment options.arrow_forwardYou own a furniture manufacturing company. You are looking to expand into glass furniture and need to buy new manufacturing equipment to manufacture this type of furniture. You have researched many suppliers but have found that two machines will best suit your needs. The cost of machine 1 is $90,000, and the cost of machine 2 is $110,000. The estimated net profits the machines will generate are in the following table: Net Profit Machine 1 (cost $90,000) Machine 2 (cost $110,000) Year 1 $20,000 $10,000 Year 2 $30,000 $20,000 Year 3 $40,000 $40,000 Year 4 $20,000 $60,000 Year 5 $20,000 $50,000 Total $130,000 $180,000 Compare the ARR for both machines and decide which machine you should buy. [Note: you are supposed to show every step of your calculation and interpret the result.]arrow_forward
- Skiable Acres operates a Rocky Mountain ski resort. The company is planning its lift ticket pricing for the coming ski season. (Click the icon to view the information.) Read the requirements. Requirement 1. If Skiable Acres cannot reduce its costs, what profit will it earn? State your answer in dollars and as a percent of assets. Will investors be happy with the profit level? Complete the following table to calculate Skiable Acres's projected income. Revenue at market price Less: Total costs i More Info Operating income (Round the percentage to the nearest hundredth percent, X.XX%.) Investors would like to earn a 10% return on investment on the company's $270,000,000 of assets. Skiable Acres projects fixed costs to be $31,000,000 for the ski season. The resort serves about 725,000 skiers and snowboarders each season. Variable costs are about $13 per guest. Last year, due to its favorable reputation, Skiable Acres was a price-setter and was able to charge $3 more per lift ticket than…arrow_forwardThe Pet Paradise Pet Shop, specialized in selling pet houses, is currently facing profitability challenges. The founder, Lisa, recognizes your expertise in business knowledge and financial acumen and seeks your advice to determine crucial sales targets for breaking even and achieving specific profit margins. Key Financial Parameters: Fixed Costs: The fixed costs for Pet Paradise Pet Shop amount to $25,000 annually. Variable Costs: The variable cost associated with each pet house sold is $150. Product Price: The selling price for each pet product is $450. Goals for Analysis: Lisa wants to understand the sales targets required to achieve the following financial milestones: a. Break-even Point: Determine the number of pet houses Pet Paradise needs to sell annually to cover the fixed and variable costs, resulting in a break-even situation. b . Profit of $50,000: Identify the sales volume needed to generate a profit of $50,000 after covering fixed and variable costs. c. Profit of…arrow_forwardAlyssa Stuart is thinking of starting a store that specializes in handmade Viennese style bentwood chairs. Before opening her store, Alyssa is curious about how her profit, revenue, and variable costs will change depending on the amount she charges for the chairs. Alyssa would like you to perform the work required for this analysis and has given you the data. Here are a few things to consider while you perform your analysis: Current competitive prices for Viennese style bentwood chairs are between $225 and $275 a chair. Variable costs will be either $100 or $150 a chair depending on the types of material Alyssa chooses to use. Fixed costs are $10,000 a month. Create an Excel file containing the following information: Alyssa's chairs - Price One Alyssa's chairs - Price Two Chair Price $ 225 Chair Price $ 275 Variable Cost per chair $ 125 Variable Cost per chair $ 150 Fixed Cost $ 10,000 Fixed Cost $…arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning