week6assign

Before making hiring or purchasing decisions, healthcare organizations must consider whether the decision is financially profitable. By calculating break-even points, organizations are able to examine actual costs and make more sound financial decisions. For this Assignment, you use data from an imaging center and calculate break-even points.

To prepare for this Assignment, review the Week 6 Assignment 2 document provided to you by the Instructor. Examine the imaging center scenario. Reflect on how you will use the provided financial data to calculate break-even points. Refer to Chapter 9 of Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts and Applications for additional guidance.

The Assignment

Given the imaging center scenario and financial data, create an Excel spreadsheet showing the following:.

• Solve for monthly volume to break even.
• Solve for monthly volume needed to break even at desired $5,000 per month profit level.
• Solve for volume needed to break even at new reimbursement of $55 per screen and no profit.
• Solve for volume needed to break even with additional labor.