Using the tab entitled "Break Even 1" work the following problems. You are
the manager of a lab facility and Blue Cross has offered you a contract.
Develop the P&L statement for the following assumptions between 0 and
65,000 procedures in increments of 2,500:
Blue Cross is offering you a contract that will pay you $55 per procedure
Variable costs per procedure are $37.00
Fixed costs are $1,000,000
You will need to hire an additional salaried employee with volumes of
40,000 or more at an annual cost of $50,000.
Remember:
Do not include the $ in your response on Bb
Do use comma separators between thousands
Enter negative values with "-" sign
Round your responses to the nearest whole dollar.
1. Calculate the Contribution to Margin in dollars.
Answer:
2. Calculate the Contribution to Margin as a percent. Round your response
to the nearest tenth 1 decimal place.
Answer:
3. What is the average cost per test with a volume of 10,000 tests?
Answer:
4. What are the total revenues you could expect to have with a volume of
30,000 tests?
Answer:
5. What are the total fixed costs at a volume of 55,000 tests?
Answer:
6. What are the total variable costs you would have with a volume of 55,000
tests?
Answer:
7. What are the total costs that you would expect to have with a volume of
40.000 tests?
Answer:
8. What is the expected profit or (loss) at a volume of 30,000 tests?
Answer:
9. What is the expected profit or (loss) at a volume of 50,000 tests?
Answer:
10. What is the break-even point?
a) Between 52,500 and 55,000 Tests
b) Between 55,000 and 57,500 Tests
c) Between 57,500 and 60,000 Tests
d) Between 60,000 and 62,500 Tests
e) None of the above
