Question

In: Finance

In this exercise, we will use our knowledge of the relationships between revenue, variable costs, fixed...

In this exercise, we will use our knowledge of the relationships between revenue, variable costs, fixed costs, contribution margin, operating margin, and unit charge or sales price. We will calculate the number of UOS we need to perform to break even, what the revenue needed to achieve a target operating income, and compute the contribution income statement to prove our results. Please use the Contribution Margin Method to arrive at your answers and show all your calculations for the answer and the proof.

Case 1:

The Laboratory Manager wants to know the number of lab test procedures it will take to achieve the desired operating income of $450,000 next year.

Data Assumptions:

Unit charge for each lab test $250

Variable cost per lab test $150

Total fixed costs $125,000

Please calculate the number of tests needed to be performed and the total revenue needed to achieve an operating income of $450,000. Then compute the contribution income statement method to prove your answers. Please show all calculations.

Case 2:

Now the Laboratory Manager wants to know how many of the lab test procedures will need to be performed to break even next year. Use the same data assumptions you have from the above example. Please calculate the number of lab tests needed to be done to break even and use the contribution income statement method to prove your answer. Please show all calculations.

Case 3:

The Laboratory Manager now wants to forecast what her operating income will be if the Lab performs 3,000 lab tests next year. Use the same data assumptions shown above and calculate the operating income for performing 3,000 tests using the contribution margin income statement method. Please show all calculations.

Rubric

Solutions

Expert Solution

Case 1: Desired Operating Income = $450,000

Add: Total Fixed Costs = $125,000

Desired Contribution Margin = $575,000

Contribution margin per Unit = Selling Price per Unit – Variable Cost per Unit

= 250-150

= $100

Hence, number of test required = 575,000/100

= 5,750

Contribution Margin Income Statement

Sales 250*5,750	1,437,500
Less: Variable Costs 150*5,750	862,500
Contribution Margin	575,000
Less: Fixed Costs	125,000
Operating Income	450,000

Case2: Break even tests = Fixed costs/Contribution Margin per Unit

= 125,000/100

= 1,250 tests

Contribution Margin Income Statement

Sales 250*1,250	312,500
Less: Variable Costs 150*1,250	187,500
Contribution Margin	125,000
Less: Fixed Costs	125,000
Operating Income	0

Case 3:

Contribution Margin Income Statement

Sales 250*3,000	750,000
Less: Variable Costs 150*3,000	450,000
Contribution Margin	300,000
Less: Fixed Costs	125,000
Operating Income	175,000

Hence, operating income will be $175,000

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Exercise 4: We will use the code in ArrayDemo.cpp to explore arrays and the relationships between...

Exercise 4: We will use the code in ArrayDemo.cpp to explore arrays and the relationships between arrays and pointers. First of all, make sure you understand the purpose and syntax of the forward declarations at the beginning of the file. Then do the following (90 minutes in coding): Coding (finish in 30min): Add a function called linearSearch() This function takes as input an array, its size, and a target integer to find It should return -1 if the item is...

What is the difference between fixed costs and variable costs?’ Are there fixed costs in the...

What is the difference between fixed costs and variable costs?’ Are there fixed costs in the long run? Explain briefly. Are fixed costs also sunk costs? Explain. What are diminishing marginal returns as they relate to costs? Which costs are measured on a per-unit basis: fixed costs, average cost, the average variable cost, variable costs, and marginal cost? How is each of the following calculated: marginal cost, average total cost, average variable cost? What shapes would you generally expect each...

Contribution Margin Analysis: We calculate contribution margin by taking our sales revenue less our variable costs....

Contribution Margin Analysis: We calculate contribution margin by taking our sales revenue less our variable costs. This basically tells us the portion of our sales that are available to cover the fixed cost of the business. Contribution margin per unit is especially useful. We compute this by taking our sales revenues per unit less our variable cost per unit. With this, we can easily compute our break-even point. Dog Day Care Pricing at $18 per dog per day, you can...

Expalin the difference between variable and fixed costs

Explain the difference between fixed and variable costs

A resort hotel annual sales revenue of $1,000,000, Variable costs of $350,000, and a fixed costs...

A resort hotel annual sales revenue of $1,000,000, Variable costs of $350,000, and a fixed costs of $570,000. The fixed costs include $80,000 a year for land rental lease. a) Calculate the hotel's breakeven point. b) If the owners had an equity investment in the hotel of $1,200,000. What level of sales revenue is required for an operating income (BT) representing a 15% return on their investment? c). In a renegotiation of the land lease, the landowner has offered management...

Within the relevant range, the difference between variable costs and fixed costs is: (2) a. variable...

Within the relevant range, the difference between variable costs and fixed costs is: (2) a. variable costs per unit fluctuate and fixed costs per unit remain constant . b. both total variable costs and total fixed costs are constant. c. both total variable costs and total fixed costs fluctuate. d. variable costs per unit are constant and fixed costs per unit fluctuate.

h) What is the difference between fixed costs and variable costs? What is the difference between...

h) What is the difference between fixed costs and variable costs? What is the difference between accounting costs and economic costs? What is the differ - ence between private costs and external costs? Name all the categories that comprise economic costs. i) How do we determine the profit-maximizing level of production using analy - sis of total costs and total revenues? What is the rule for profit maximization using marginal analysis? What happens to economic profits in a perfectly competitive...

Total sales revenue is $1000, total variable costs are $600 and total fixed costs are $1000....

Total sales revenue is $1000, total variable costs are $600 and total fixed costs are $1000. The price is $10 per unit. Compute the break-even volume in units (assume that the break-even point is in the relevant range). A) 166.7 units B) 250 units C) 280 units D) 2500 units Beta company allocates fixed overhead costs based on direct labor dollars, with an allocation rate of $5 per DL$. Beta sells 1000 units of product X per month at a...

If the revenue of a segment does not cover its variable costs and its traceable fixed...

If the revenue of a segment does not cover its variable costs and its traceable fixed costs, that segment should usually be dropped. True or False? A complete and detailed income statement does need not be prepared as part of a differential cost analysis. True or False? When a balanced scorecard is correctly developed and implemented, the four performance measures should be separate and independent of each other so that the bad performance of one measure will not result in...

Subjects