Limitless Labs offers three basic drug testing services for professional athletes The budget for the 2 nd Quarter of 2022 is shown below Variable costs include the labor costs of the medical technicians and consumable materials for testing Fixed costs total $370,000 per year, consisting of equipment depreciation (direct fixed costs), and building depreciation and administration costs (common fixed costs) A basic unit is a routine 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 tests positive for drugs that are on the banned list Retests are not done by the laboratory that performed the basic test but instead are conducted by a different Lab in the network A priority test is the laboratorys 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 expert technicians to ensure the accuracy of priority tests Limitless Labs is subject to a 21 tax rate Treat each of the following questions independently and document your work Determine the breakeven point, in units, for the Basic Tests line of service Determine the number of Retests that would need to be administered for that service line to generate $10,000 segment margin Determine the budgeted weighted average contribution margin per unit (WACM unit) and weighted average contribution margin ratio (WACM ) for Limitless Labs Determine the budgeted sales mix based on volume and the budgeted sales mix based on revenue Assume the actual sales mix remains the same as expected in the quarter determine the sales revenue (in total and by product line) necessary for the lab to achieve overall breakeven ($0 after tax profit) Assume the actual sales mix remains the same as expected in the quarter determine the sales revenue (in total and by product line) necessary for the lab to achieve $100,000 after tax profit Limitless Labs is considering increasing its advertising for the quarter by adding $15,000 of advertising expenses Historically, sales volume increases uniformly across the product lines by 2 for each $5,000 of additional advertising budget Considering the impact on Operating Income, is the additional advertising worthwhile Limitless Labs Budgeted Contribution Margin Analysis Quarter 2, 2022 Basic Tests Retests 100 850 S500 $120 $380 $425,000 102,000 $323,000 105,000 S218,000 Testing Volume (units) Revenue Variable costs Contribution Margin Direct Fixed Costs Segment Margin Common Fixed Costs Operating income Income taxes (21 ) Net Operating income $80,000 40 000 $40,000 35,000 $5,000 $800 $400 $400 Priority Tests 50 $250,000 $5,000 140,000 S2,800 $110,000 $2,200 50,000 $60,000 Total 1,000 S755,000 282,000 $473,000 190,000 $283,000 180,000 S 103,000 21,630 81,370 S

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 14, 2024

Limitless Labs offers three basic drug-testing services for professional athletes. The budget for the 2 nd Quarter of 2022 is shown below. Variable costs include

Limitless Labs offers three basic drug-testing services for professional athletes. The budget for the 2^nd Quarter of 2022 is shown below.

image text in transcribed

Variable costs include the labor costs of the medical technicians and consumable materials for testing. Fixed costs total $370,000 per year, consisting of equipment depreciation (direct fixed costs), and building depreciation and administration costs (common fixed costs). A basic unit is a routine 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 tests positive for drugs that are on the banned list. Retests are not done by the laboratory that performed the basic test but instead are conducted by a different Lab in the network. A priority test is the laboratorys 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 expert technicians to ensure the accuracy of priority tests. Limitless Labs is subject to a 21% tax rate.

Treat each of the following questions independently and document your work.

Determine the breakeven point, in units, for the Basic Tests line of service.
Determine the number of Retests that would need to be administered for that service line to generate $10,000 segment margin.
Determine the budgeted weighted average contribution margin per unit (WACM/unit) and weighted average contribution margin ratio (WACM%) for Limitless Labs.
Determine the budgeted sales mix based on volume and the budgeted sales mix based on revenue.
Assume the actual sales mix remains the same as expected in the quarter; determine the sales revenue (in total and by product line) necessary for the lab to achieve overall breakeven ($0 after-tax profit)
Assume the actual sales mix remains the same as expected in the quarter; determine the sales revenue (in total and by product line) necessary for the lab to achieve $100,000 after-tax profit.
Limitless Labs is considering increasing its advertising for the quarter by adding $15,000 of advertising expenses. Historically, sales volume increases uniformly across the product lines by 2% for each $5,000 of additional advertising budget. Considering the impact on Operating Income, is the additional advertising worthwhile?

Limitless Labs Budgeted Contribution Margin Analysis - Quarter 2, 2022 Basic Tests Retests 100 850 S500 $120 $380 $425,000 102,000 $323,000 105,000 S218,000 Testing Volume (units) Revenue Variable costs Contribution Margin Direct Fixed Costs Segment Margin Common Fixed Costs Operating income Income taxes (21%) Net Operating income $80,000 40.000 $40,000 35,000 $5,000 $800 $400 $400 Priority Tests 50 $250,000 $5,000 140,000 S2,800 $110,000 $2,200 50,000 $60,000 Total 1,000 S755,000 282,000 $473,000 190,000 $283,000 180,000 S 103,000 21,630 81,370 S