anaylsis

You are the ceo of a facility and Aetna has offered you a contract. Develop the P&L statement for the following assumptions between and 65,000 procedures in increments of 2,500:

Aetna is offering you a contract that will pay you $55 per procedure

Variable costs per procedure = $37.00

Fixed costs = $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

questions

what is contribution to margin in dollars?

what is average cost per test with volume of 10,000 tests?

what are total variable costs for volume of 55,000 tests?

please show your excel sheet for volumes 0 - 65,000 so i can see how its done