In MS Excel, complete the exercises in part 1. In APA format, respond to the questions in part 2.
Part 1
- Lutheran Regional Hospital uses a planning process to define a new radiology service line. The decision matrix gave it a high priority, and administrators want to evaluate its financial feasibility. Estimated fixed costs are $1 million, and the estimated net reimbursement level is $1,500 per procedure. Physician and other provider salaries on a direct basis are $340 per procedure, and total operating expenses will add another $160 per procedure. Calculate the breakeven point for this potential new service line.
- If Lutheran Regional discovered a way to reduce the total initial investment to $600,000, causing the average pricing level to fall to $1,200 and the other assumptions to stay the same, how many procedures would be required to break even?
