Concept explainers
Extensions of the CVP Model—Multiple Products and Taxes
Assume that Painless Dental Clinics, Inc., offers three basic dental services. Here are its prices and costs:
Variable costs include the labor costs of the dental hygienists and dentists. Fixed costs of $400,000 per year include building and equipment costs, marketing costs, and the costs of administration. Painless Dental Clinics is subject to a 30 percent tax rate on income. A cleaning “unit” is a routine teeth cleaning that takes about 45 minutes. A filling “unit” is the work done to fill one or more cavities in one session. A capping “unit” is the work done to put a crown on one tooth. If more than one tooth is crowned in a session, then the clinic counts one unit per tooth (e.g., putting crowns on two teeth counts as two units).
Required
- a. Given the above information, how much will Painless Dental Clinics, Inc., earn each year after taxes?
- b. Assuming the above sales mix is the same at the break-even point, at what sales revenue does Painless Dental Clinics, Inc., break even?
- c. Assuming the above sales mix, at what sales revenue will the company earn $140,000 per year after taxes?
- d. Painless Dental Clinics, Inc., is considering becoming more specialized in cleanings and fillings. What would be the company’s revenues per year if the number of cleanings increased to 12,000 per year, the number of fillings increased to 1,000 per year, while the number of cappings dropped to zero? With this change in product mix, the company would increase its fixed costs to $450,000 per year. What would be the effect of this change in product mix on the clinic’s earnings after taxes per year? If the clinic’s managers seek to maximize the clinic’s after-tax earnings, would this change be a good idea?
a.
Calculate the profit after tax for Company P.
Answer to Problem 69P
Company P earns $84,000 of profit after tax.
Explanation of Solution
Operating profit: The operating profit is the excess of total revenues over total expenses after adjusting for depreciation and taxes.
Contribution margin:
Particulars | Cleaning | Filling | Capping |
Sales price (unit) | $120 | $400 | $1,200 |
Less: variable cost (unit) | $80 | $300 | $500 |
Contribution margin (unit) | $40 | $100 | $700 |
Units sold per year | 9,000 | 900 | 100 |
Fixed cost | $400,000 | ||
Tax rate | 30% |
Table: (1)
Compute the profit after tax of Company P:
Particulars | Amount |
Sales revenue | |
Cleaning | $1,080,000 |
Filling | $360,000 |
Capping | $120,000 |
Total sales revenue (a) | $1,560,000 |
Less: | |
Variable cost | |
Cleaning | $720,000 |
Filling | $270,000 |
Capping | $50,000 |
Total variable cost (b) | $1,040,000 |
Contribution: | $520,000 |
Less: | |
Fixed cost (d) | $400,000 |
Profit before tax: | $120,000 |
Tax rate | 30% |
Tax (f) | $36,000 |
Profit after tax: | $84,000 |
Table: (2)
Thus, Company P earns $84,000 of profit after tax.
b.
Calculate the sales revenue for cleaning, filling and capping at the break-even point.
Answer to Problem 69P
The sales revenue for cleaning, filling, and capping is $830,760, $276,800 and $91,200 respectively.
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.
Compute the total sales revenue of each product:
Particulars | Sales mix | Break-even point |
Sales Price (b) |
Total sales revenue |
Cleaning | 90% | 6,923 | $120 | $830,760 |
Filling | 9% | 692 | $400 | $276,800 |
Capping | 1% | 76 | $1,200 | $91,200 |
Table: (3)
Thus, the sales revenue for cleaning, filling, and capping is $830,760, $276,800 and $91,200 respectively.
Working note 1:
Compute the break-even point:
Working note 2:
Compute the total weighted average contribution margin:
Particulars | Sales price (a) | Variable cost (b) |
Contribution margin | Sales mix (d) |
Weighted average contribution margin |
Cleaning | $120 | $80 | $40 | 90% | $36 |
Filling | $400 | $300 | $100 | 9% | $9 |
Capping | $1,200 | $500 | $700 | 1% | $7 |
Total weighted average contribution margin | $52 |
Table: (4)
c.
Calculate the dollar sales required to earn the profit after tax of $140,000.
Answer to Problem 69P
To earn the profit after tax of $140,000, Company P must make the sales revenue of $1,246,104, $415,200 and $138,000 for cleaning, filling and capping for respectively.
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.
Compute the dollar sales required to earn the profit after tax of $140,000:
The total target volume is 11,538, so it will be distributed among the products in their sales mix ratio.
Particulars | Sales mix |
Sales units | Sales price | Sales revenue |
Cleaning | 90% | 10,384 | $120 | $1,246,104 |
Filling | 9% | 1,038 | $400 | $415,200 |
Capping | 1% | 115 | $1,200 | $138,000 |
Total sales revenue | $1,799,304 |
Table: (5)
Thus, to earn the profit after tax of $140,000, Company P must make the sales revenue of $1,246,104, $415,200 and $138,000 for cleaning, filling and capping respectively.
Working note 3:
Compute the volume of sales required to earn the profit after tax of $140,000:
d.
- I. Calculate the revenue of Company P if the number of cleanings increased to 12,000 per year, the number of fillings increased to 1,000 per year, while the number of capping dropped to zero.
- II. Calculate the effect on the profit after tax if the company increases its fixed cost to $450,000 with the given product mix.
- III. Suggest that the given change is a good idea or not.
Answer to Problem 69P
- I. The revenue of Company P would be $1,840,000 if the number of cleanings increased to 12,000 per year, the number of fillings increased to 1,000 per year, while the number of capping dropped to zero.
- II. The profit after tax increases by $7,000 if the company increases its fixed cost to $450,000 with the given product mix.
- III. Yes, the change of sales mix and an increase in fixed cost is a good idea for Company P.
Explanation of Solution
I.
Compute the revenue of Company P if the number of cleanings increased to 12,000 per year, the number of fillings increased to 1,000 per year, while the number of capping dropped to zero:
Particulars | Amount |
Sales revenue | |
Cleaning | $1,440,000 |
Filling | $400,000 |
Capping | $0 |
Total sales revenue (a) | $1,840,000 |
Table: (6)
Thus, the revenue of Company P is $1,840,000 if the number of cleanings increased to 12,000 per year, the number of fillings increased to 1,000 per year, while the number of capping dropped to zero.
II.
Compute the effect on the profit after tax if the company increases its fixed cost to $450,000 with the given product mix:
Thus, the profit after tax increases by $7,000 if the company increases fixed cost to $450,000 with the given product mix.
Working note 4:
Compute the profit after tax of Company P:
Particulars | Amount |
Sales revenue | |
Cleaning | $1,440,000 |
Filling | $400,000 |
Capping | $0 |
Total sales revenue (a) | $1,840,000 |
Less: | |
Variable cost | |
Cleaning | $960,000 |
Filling | $300,000 |
Capping | $0 |
Total variable cost (b) | $1,260,000 |
Contribution: | $580,000 |
Less: | |
Fixed cost (d) | $450,000 |
Profit before tax: | $130,000 |
Tax rate | 30% |
Tax (f) | $39,000 |
Profit after tax: | $91,000 |
Table: (7)
III.
If the clinic’s managers seek to maximize the clinic’s after-tax earnings, this is a good idea as the profit has increased by 7,000 with the change in sales mix and an increase in fixed cost.
Thus, the change in sales mix and an increase in fixed cost is a good idea for Company P.
Want to see more full solutions like this?
Chapter 3 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- Assume that Painless Dental Clinics, Inc., offers three basic dental services. The following are its prices and costs. Priceper Unit Variable Costper Unit Units Soldper Year Cleaning $ 400 $ 220 8,500 Filling 680 660 1,200 Capping 1,550 920 300 Variable costs include the labor costs of the dental hygienists and dentists. Fixed costs of $540,000 per year include building and equipment costs, marketing costs, and the costs of administration. Painless Dental Clinics is subject to a 20 percent tax rate on income. A cleaning “unit” is a routine teeth cleaning that takes about 45 minutes. A filling “unit” is the work done to fill one or more cavities in one session. A capping “unit” is the work done to put a crown on one tooth. If more than one tooth is crowned in a session, then the clinic counts one unit per tooth (e.g., putting crowns on two teeth counts as two units). d-1.…arrow_forwardMake or Buy - Home Grocery (HG) provides home delivery of groceries. Customers submit orders to the HG website by selecting the needed items from a menu. Currently, HG has employees who deliver the groceries, but the company is considering the option of contracting out deliveries. The fixed cost of the grocery delivery operation is $500,000 per year, of which, $200,000 is avoidable if grocery deliveries are contracted out. A statistical study suggests delivery costs vary with both the number of customers and the number of items purchased. On average, the fixed annual delivery cost per customer is $250 and the average variable delivery cost of each grocery item delivered is $0.50. On average, each customer purchases 1,000 grocery items per year. Therefore, if there are 2,000 customers budgeted, the number of grocery item deliveries will be 2 million. Custom delivery (CD) has offered to deliver groceries for HG as a flat rate of $850 per customer per year irrespective of the number of…arrow_forwardGardendale Associates offers landscape consultations, where they provide design advice and plans to residential customers. A single consultation is priced at $750.00. The variable costs of a consultation total $330.00 consisting mostly of labor and supplies. Annual fixed costs are $102,900. Gardendale Associates is subject to an Income tax rate of 24 percent. Required: a. What total revenue does Gardendale have to generate from selling consultations to break even? b. What total revenue does Gardendale have to generate from selling consultations to earn an annual operating profit of $106,400 after taxes? Break-even revenue Required revenuearrow_forward
- The accounting department at the corporate office has provided you with some historical cost data. Economy rentals cost $17.10 per day while luxury vehicles cost $25.12 per day. Regardless of vehicle type, a rental contract requires $8.90 for reconditioning. Additional vehicles can be delivered from the regional hub at a cost of $35/vehicle, on top of the costs above. Do you have any concerns about using this accounting data to set prices? Hint: Consider the difference between average and marginal cost. In addition to answering the questions above, provide pricing recommendations for economy vehicles for the next four weeks.arrow_forwardBest Windows is a small company that installs windows. Its cost structure is as follows: Selling price from each window installation Variable cost of each window installation Annual fixed costs $ $ $ 160,000 Use (a) the equation method and (b) the contribution method to calculate operating income if Best installs 4,000 windows. Use (a) the Equation method to calculate operating income if Best installs 4,000 windows. Begin by determining the formula to calculate the operating income using the equation method. Then, calculate the operating income. (Abbreviation used: FC = Fixed costs, SP = Selling price, VCU = Variable cost per unit, Q = Quantity of units sold.) X X )-( )-( X X 700 600 X = Operating income = Next, use (b) the contribution method to calculate operating income if Best installs 4,000 windows. Begin by determining the formula to calculate the operating income using the contribution method. Then, calculate the operating income. = Operating incomearrow_forwardMany different businesses employ markup on cost to arrive at a price. For each of the following situations, explain what the markup covers and why it is the amount that it is. a. Department stores have a markup of 100 percent of purchase cost. b. Jewelry stores charge anywhere from 100 percent to 300 percent of the cost of the jewelry. (The 300 percent markup is referred to as keystone.) c. Johnson Construction Company charges 12 percent on direct materials, direct labor, and subcontracting costs. d. Hamilton Auto Repair charges customers for direct materials and direct labor. Customers are charged 45 per direct labor hour worked on their job; however, the employees actually cost Hamilton 15 per hour.arrow_forward
- Brahma 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_forwardCollege Pizza delivers pizzas to the dormitories and apartments near a major state university. The company’s annual fixed expenses are $40,000. The sales price of a pizza is $10, and it costs the company $5 to make and deliver each pizza. (In the following requirements, ignore income taxes.)Required:1. Using the contribution-margin approach, compute the company’s break-even point in units (pizzas).2. What is the contribution-margin ratio?3. Compute the break-even sales revenue. Use the contribution-margin ratio in your calculation.4. How many pizzas must the company sell to earn a target profit of $65,000? Use the equation method.arrow_forwardSpectrum Corp. makes two products: C and D. The following data have been summarized: (Click the icon to view the data.) Spectrum Corp. desires a 25% target gross profit after covering all product costs. Considering the total product costs assigned to the Products C and D, what would Spectrum have to charge the customer to achieve that gross profit? Round to two decimal places. Begin by selecting the formula to compute the amount that the company should charge for each product. Required sales price per unit Data table Direct materials cost per unit Direct labor cost per unit Indirect manufacturing cost per unit Total costs assigned Print $ $ Product C 600.00 $ 300.00 270.00 1,170.00 S Done - X Product D 2,400.00 200.00 604.00 3,204.00arrow_forward
- Rundle Electronics currently produces the shipping containers it uses to deliver the electronics products it sells. The monthly cost of producing 9,300 containers follows. Unit-level materials. Unit-level labor Unit-level overhead Product-level costs* Allocated facility-level costs One-third of these costs can be avoided by purchasing the containers. Russo Container Company has offered to sell comparable containers to Rundle for $2.60 each. Required a. Calculate the total relevant cost. Should Rundle continue to make the containers? b. Rundle could lease the space it currently uses in the manufacturing process. If leasing would produce $11,600 per month, calculate the total avoidable costs. Should Rundle continue to make the containers? Answer is complete but not entirely correct. $ a. Total relevant cost a. Should Rundle continue to make the containers? b. Total avoidable cost b. Should Rundle continue to make the containers? 190.650,000 Yes $24,180,000 $ 5,200 6,100 4,000 7,800…arrow_forward1 Lazy Days Inc. (LDI), sells hammocks. Revenue and cost information is given below: Sales Price 3. TL 30 Unit Variable Cost 20 Annual Fixed Operating Expenses 47,500 Required: a) Determine the sales volume in units and TL amount that would be required to attain a TL 12,500 profit. Verify your answer by preparing an income statement using the contribution margin format. b) LDI is considering the implementation of a quality improvement program. The program will require a TL 2.50 increase in the variable cost per unit. To inform its customers of the quality improvements, the company plans to spend an additional TL 5,000 for advertising. Assuming that the improvement program will increase sales to a level that is 1,500 units above the amount computed in requirement a, should LDI proceed with plans to improve product quality? Support your answer by preparing a budgeted income statement. c) Determine the new break-even point volume of units and sales in TL as well as the margin of safety…arrow_forwardRainbow Paints operates a chain of retail paint stores. Although the paint is sold under the Rainbow label, it is purchased from an independent paint manufacturer. Guy Walker, president of Rainbow Paints, is studying the advisability of opening another store. His estimates of monthly costs for the proposed location are as follows: Fixed costs: Occupancy costs Salaries Other Variable costs (including cost of paint) $6 per gallon Although Rainbow stores sell several different types of paint, monthly sales revenue consistently averages $10 per gallon sold. Required: a. Compute the contribution margin ratio and the break-even point in dollar sales and in gallons sold for the proposed store. c. Walker thinks that the proposed store will sell between 2,200 and 2,600 gallons of paint per month. Compute the amount of operating income that would be earned per month at each of these sales volumes. a. Contribution margin ratio a. Break-even sales volume in dollars a. Break-even sales volume in…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College