Question

In: Accounting

Price per Unit Variable Cost per Unit Units Sold per Year Basic $ 700 $ 220...

Price
per Unit
Variable Cost
per Unit
Units Sold
per Year
Basic $ 700 $ 220 700
Retest 1,050 580 200
Vital 4,600 3,100 100

Variable costs include the labor costs of the medical technicians at the lab. Fixed costs of $490,000 per year include building and equipment costs and the costs of administration. A basic "unit" is a routine drug test administered. A retest is given if there is concern about the results of the first test, particularly if the test indicates that the athlete has taken drugs that are on the banned drug list. Retests are not done by the laboratory that performed the basic test. A "vital" test is the laboratory's code for a high-profile case. This might be a test of a famous athlete and/or a test that might be challenged in court. The laboratory does extra work and uses expensive expert technicians to ensure the accuracy of vital drug tests. Limitless Labs is subject to a 20 percent tax rate.

a. How much will Limitless Labs earn each year after taxes?

b. Assuming the above sales mix is the same at the break-even point, at what sales revenue does Limitless Labs break even? (Do not round intermediate calculations. Round your final answer to the nearest whole dollar.)

c. At what sales revenue will the company earn $200,000 per year after taxes assuming the above sales mix? (Do not round intermediate calculations. Round your final answer to the nearest whole dollar.)

d-1. Limitless Labs is considering becoming more specialized in retests and vital cases. Assume the number of retests increased to 500 per year and the number of vital tests increased to 250 per year, while the number of basic tests dropped to 100 per year? With this change in product mix, the company would increase fixed costs to $520,000 per year. What would be the effect of this change in product mix on Limitless Labs's earnings after taxes per year?

d-2. If the laboratory's managers seek to maximize the company's after-tax earnings, would this change be a good idea?

Solutions

Expert Solution

1.Income “LimitLess Lab” will earn when tax Rate is 20%:

Calculation of Contribution for Each Test:

Particulars

Basic

Retest

Vital

Sales Price per unit

700

1050

4600

Less: Variable Cost per unit

220

580

3100

Contribution

480

470

1500

Income Statement:

Particulars

Basic

Retest

Vital

Contribution

480

470

1500

Units Sold

700

200

100

Contribution Earned

336,000

94,000

150,000

Particulars

Amount ($)

Combined Contribution from all the 3 Tests

580,000

Less: Fixed Costs

(490,000)

Net Profit (Before Tax)

90,000

Less: Tax @ 20%

(18,000)

Net Income earned (After Tax)

72,000

2. To Breakeven

For the company to break even it should earn atleast revenue before tax of $ 490,000 to cover the Fixed Costs. If the Company wants to maintain the sales mix in the ratio of 7:2:1, then the Sales mix at Break even will be as follows:

Calculation of Revenue of $ 490,000 in ratio of 7:2:1

Particulars

Basic

Retest

Amount ($) / Vital

  1. Combined Revenue

490,000

  1. Ratio

7

2

1

  1. Revenue

343,000

98,000

49,000

  1. Contribution per Unit

480

470

1500

  1. Units (a/b)

714.5833

208.51063

32.6666

Calculation of Sales Mix

Particulars

Basic

Retest

Vital

  1. Revenue

343,000

98,000

49,000

  1. Contribution per Unit

480

470

1500

  1. Units (a/b)

714.5833

208.51063

32.6666

Therefore to break even the company shall make revenue of 490,000 in above units of sales

3. At What Sales Revenue Company will earn after tax sales of $200,000 in above sales mix:

Particulars

Amount ($)

Net Income earned (After Tax)

200,000

Add: Tax @ 20%

50,000

Net Profit (Before Tax)

250,000

Add: Fixed Costs

490,000

Combined Contribution from all the 3 Tests

740,000

Particulars

Basic

Retest

Vital

Sales Mix

7

2

1

Revenue in Sales Mix

518,000

148,000

74,000

Contribution Per Unit

480

470

1500

No. of Units

1079.1666

314.8936

49.3333

4. Effect of Changes

Calculation of Contribution for Each Test:

Particulars

Basic

Retest

Vital

Sales Price per unit

700

1050

4600

Less: Variable Cost per unit

220

580

3100

Contribution

480

470

1500

Income Statement:

Particulars

Basic

Retest

Vital

Contribution

480

470

1500

Units Sold

100

500

250

Contribution Earned

48,000

235,000

375,000

Particulars

Amount ($)

Combined Contribution from all the 3 Tests

658,000

Less: Fixed Costs

(520,000)

Net Profit (Before Tax)

138,000

Less: Tax @ 20%

(27,600)

Net Income earned (After Tax)

110,400

Due to the change in the Sales Mix and increase in Fixed Costs Net Profit (After Taxes) increases to $ 110,400.

5.If the Manager opines to change to this Revised Product Mix, it will be beneficial to company as the profit increased by $ 38,400 ($ 110,400 - $ 72,000).


Related Solutions

If 12,500 units are produced and sold, what is the variable cost per unit produced and sold?
Martinez Company’s relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its average costs per unit are as follows:  Average Cost Per UnitDirect materials$ 5.60Direct labor$ 3.10Variable manufacturing overhead$ 1.40Fixed manufacturing overhead$ 4.00Fixed selling expense$ 2.60Fixed administrative expense$ 2.20Sales commissions$ 1.20Variable administrative expense$ 0.454. If 12,500 units are produced and sold, what is the variable cost per unit produced and sold? (Round your answer to 2 decimal places.)
1. If 18,000 units are produced and sold, what is the variable cost per unit produced and sold?
Refer to the data given in Exercise 1-7. Answer all questions independently.  Kubin Company's relevant range of production is 18,000 to 22,000 units. When it produces and sells 20,000 units, its average costs per unit are as follows:   Required: 1. If 18,000 units are produced and sold, what is the variable cost per unit produced and sold? 2. If 22,000 units are produced and sold, what is the variable cost per unit produced and sold? 3. If 18,000 units are...
Currently, the sales of a company is $12,800,000 per year: price per unit $12.8; units sold...
Currently, the sales of a company is $12,800,000 per year: price per unit $12.8; units sold 1,000,000 per year; direct cost per unit $9.60; A/R 25% of $ sales (ignore A/P); inventory 25% of direct cost; cash operating expense $890,000 per year; annual depreciation $600,000; tax rate 34%; capital expenditure is zero. Now you are estimating the free cash flow for the next year when the unit sales price changes to $15.36, thus changing $ sales; however, the number of...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit Selling expenses $5,100 plus 5% of selling price Administrative expenses $3,000 plus 20% of selling price note Note that some costs have variable components such as commissions on sales and shipping costs. The contribution margin ratio would be: A) 70%. B) 45%. C) 75%. D) 55%.
Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income...
Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income Werner Company produces and sells disposable foil baking pans to retailers for $2.50 per pan. The variable cost per pan is as follows: Direct materials $0.30 Direct labor 0.57 Variable factory overhead 0.74 Variable selling expense 0.17 Fixed manufacturing cost totals $136,541 per year. Administrative cost (all fixed) totals $18,619. Required: 1. Compute the number of pans that must be sold for Werner to...
4. If a product can be sold for $850 per unit, the variable cost per unit...
4. If a product can be sold for $850 per unit, the variable cost per unit is $380 and the fixed costs are $2,350,000, how many units must be produced and sold to achieve the breakeven? Show your calculations. (1 point)
(Break-even analysis) Project Accounting ​Break-Even Point​ (in units) Price per Unit Variable Cost per Unit Fixed...
(Break-even analysis) Project Accounting ​Break-Even Point​ (in units) Price per Unit Variable Cost per Unit Fixed Costs Depreciation A 6, 230 ​$52 ​$102,000 ​$26,000 B    760 ​$1,000 ​$499,000 ​$103,000 C 1,970 ​$25 ​$13 ​$5,000 D 1,970 ​$25 ​$7 ​$17,000 a.  Calculate the missing information for each of the above projects. b.  Note that Projects C and D share the same accounting​ break-even. If sales are above the​ break-even point, which project would you​ prefer? Explain why. c.  Calculate the cash​...
CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable...
CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable expenses per unit $45 per unit Fixed expenses $240,000 Enter a formula into each of the cells marked with a ? below Review Problem: CVP Relationships Compute the CM ratio and variable expense ratio Selling price per unit ? per unit Variable expenses per unit ? per unit Contribution margin per unit ? per unit CM ratio ? Variable expense ratio ? Compute the...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable expenses per unit $30 per unit 7 Fixed expenses $810,000 What is the break-even in dollar sales?        (b) What is the margin of safety percentage?        (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)        3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating...
                           Purchase Units  Unit Cost    Sold Units Beg.nventory    &
                           Purchase Units  Unit Cost    Sold Units Beg.nventory          3000                  0.60$             Dec3           4000             0.74$ Dec5                                                                  4400 Dec17    2200    0.80$ Dec22    2100 Compute ending inventory and cost of goods sold using moving- average cost, assuming the Company uses the perpetual inventory system
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT