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. 2. Calculate the Contribution to Margin as a percent. Round your response to the nearest tenth - 1 decimal place. 3. What is the average cost per test with a volume of 10,000 tests? 4. What are the total revenues you could expect to have with a volume of 30,000 tests? 5. What are the total fixed costs at a volume of 55,000 tests? 6. What are the total variable costs you would have with a volume of 55,000 tests? 7. What are the total costs that you would expect to have with a volume of 40,000 tests? 8. What is the expected profit or (loss) at a volume of 30,000 tests? 9. What is the expected profit or (loss) at a volume of 50,000 tests? 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 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. 2. Calculate the Contribution to Margin as a percent. Round your response to the nearest tenth - 1 decimal place. 3. What is the average cost per test with a volume of 10,000 tests? 4. What are the total revenues you could expect to have with a volume of 30,000 tests? 5. What are the total fixed costs at a volume of 55,000 tests? 6. What are the total variable costs you would have with a volume of 55,000 tests? 7. What are the total costs that you would expect to have with a volume of 40,000 tests? 8. What is the expected profit or (loss) at a volume of 30,000 tests? 9. What is the expected profit or (loss) at a volume of 50,000 tests? 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