Question

In: Accounting

Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service...

Multiple Product Break-Even Analysis
Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through April 15 at a counter in a local grocery store. All jobs are classified into one of three categories: standard, multiform, and complex. Following is information for last year. Also, last year, the fixed cost of rent, utilities, and so forth were $65,000.

Standard Multiform Complex
Billing rate $65 $140 $265
Average variable costs (30) (75) (150)
Average contribution margin $35 $65 $115
Number of returns prepared 1,750 500 250

Required
(a.) Determine Joe's break-even dollar sales volume.

  • Round contribution margin to three decimal places.
  • Round break-even sales volume to the nearest dollar.

Product

Weighted

Selling Price

Weighted

Contribution

Margin

Standard Answer Answer
Multiform Answer Answer
Complex Answer Answer
Total Answer Answer
Contribution margin ratio: Answer
Break-even sales volume: Answer

(b.) Determine Joe's margin of safety in sales dollars.

Round answer to the nearest whole number.
$Answer

Solutions

Expert Solution

Answer:
Product Number of returns prepared Allocated Percentage
Standard 1,750 70%
(1,750 / 2,500 )
Multiform 500 20%
(500 / 2,500 )
Complex 250 10%
(250 / 2,500 )
Total 2,500 100%
(a)
Product Weighted
Selling Price
Weighted
Contribution Margin
Standard $ 45.50
($ 65 x 70% )
$ 24.50
($ 35 x 70% )
Multiform $ 28
($ 140 x 20% )
$ 13
($ 65 x 20% )
Complex $ 26.5
($ 265 x 10% )
$ 11.50
($ 115 x 10% )
Total $ 100 $ 49
Contribution margin ratio: Contribution margin / Selling price
    = $ 49 / 100
49%
Break-even sale volume Fixed costs/Contribution margin ratio
    = $ 65,000 / 49%
$ 132,653
(b)
Margin of Safety = Actual sales (-) Break-even sales
( $ 65 x 1,750 ) + ($ 140 x 500) + ( $ 265 x 250 )(-) $ 132,653
= $ 113,750 + $ 70,000 + $ 66,250 (-) $ 132,653
=   $ 250,000 (-) $ 132,653
$ 117,347

Related Solutions

Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service...
Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through April 15 at a counter in a local grocery store. All jobs are classified into one of three categories: standard, multiform, and complex. Following is information for last year. Also, last year, the fixed cost of rent, utilities, and so forth were $55,000. Standard Multiform Complex Billing rate $55 $130 $255 Average variable costs (30) (75) (150) Average contribution margin...
Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service...
Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through April 15 at a counter in a local grocery store. All jobs are classified into one of three categories: standard, multiform, and complex. Following is information for last year. Also, last year, the fixed cost of rent, utilities, and so forth were $60,000. Standard Multiform Complex Billing rate $60 $135 $260 Average variable costs (30) (75) (150) Average contribution margin...
Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service...
Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through April 15 at a counter in a local grocery store. All jobs are classified into one of three categories: standard, multiform, and complex. Following is information for last year. Also, last year, the fixed cost of rent, utilities, and so forth were $60,000. Standard Multiform Complex Billing rate $60 $135 $260 Average variable costs (30) (75) (150) Average contribution margin...
Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through...
Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through April 15 at a counter in a local grocery store. All jobs are classified into one of three categories: standard, multiform, and complex. Following is information for last year. Also, last year, the fixed cost of rent, utilities, and so forth were $60,000.                                                                  Standard Multiform     Complex Billing rate                                                   $60          $135            $260 Average variable costs                               (30) (75)    (150) Average contribution margin                       $30           $60            ...
Multiple Product Break-Even Analysis TPG Tax & Accounting is a full-service CPA firm located in Apache...
Multiple Product Break-Even Analysis TPG Tax & Accounting is a full-service CPA firm located in Apache Junction, Arizona. Assume that tax return services are classified into one of three categories: standard, complex, and full-service (includes end-of-year bookkeeping with tax return preparation). Assume that TPG’s fixed costs (rent, utilities, wages, and so forth) totaled $180,000 last year. Additional information from the prior year follows. Standard Complex Full-Service Billing rate $125 $250 $150 Average variable costs (45) (65) (50) Average contribution margin...
Explain break-even analysis, its purpose, and whether break-even analysis can be used in manufacturing and/or service...
Explain break-even analysis, its purpose, and whether break-even analysis can be used in manufacturing and/or service industry.
Consider the concept of break even analysis and target income. In order to apply break even...
Consider the concept of break even analysis and target income. In order to apply break even analysis, why would the expenses reported in external financial reports need to be reorganized into categories based on cost behavior? How do these analytical tools relate to product pricing and cost management (i.e., why would this analysis be useful to management)?
Why? Congress often reduces taxes on middle- and low-income taxpayers with the expectation that consumers will...
Why? Congress often reduces taxes on middle- and low-income taxpayers with the expectation that consumers will spend most of that money and help create more economic growth. Is this idea good or not, and why? 4. Some college students earn money that is paid to them in cash and then do not include this as income when they file their tax returns. What are the pros and cons of this practice?
Multiple Product Break-Even and Net Income Planning Madison Company manufactures and sells the following three products:...
Multiple Product Break-Even and Net Income Planning Madison Company manufactures and sells the following three products: Red Blue Green Unit sales 20,000 30,000 50,000 Unit sales price $30 $62 $18 Unit variable cost $18 $38 $14 Assume that total fixed cost is $324,800. a. Compute the net income before income tax based on the sales volumes shown above. Red Blue Green Unit contribution margin Answer Answer Answer Total contribution margin Answer Answer Answer Net income before income tax $Answer b....
Break-even analysis for a service company Sprint Nextel is one of the largest digital wireless service...
Break-even analysis for a service company Sprint Nextel is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 32.5 million direct subscribers (accounts) that generated revenue of $35,345 million. Costs and expenses for the year were as follows (in millions): Cost of revenue $20,841 Selling, general, and administrative expenses 9,765 Depreciation 2,239 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT