Assume your organization has 100 patients analyzed in the following manner.
15 – Medicare patients who pay $2,000 per diagnosis
25 – Medicaid patients who pay $1,800 per diagnosis
20 – Managed Care patients who pay charges minus a 20% discount
10 – Managed Care patients who pay charges minus a 25% discount
10 – Private insurance patients who pay charges
10 – Charity Patients who pay nothing
10 – Bad debt patients who pay nothing
Your organization’s average cost per patient is $2,000. Calculate the charge necessary to recover your cost. See cost-shifting problem
Provide your answers in Microsoft Excel and show all of your work.