Assume your organization has 100 patients analyzed in the following manner.

Assume your organization has 100 patients analyzed in the following manner. 15 Medicare patients who pay $2000 per diagnosis25 Medicaid patients who pay $1800 per diagnosis20 Managed Care patients who pay charges minus a 20% discount10 Managed Care patients who pay charges minus a 25% discount10 Private insurance patients who pay charges10 Charity Patients who pay nothing10 Bad debt patients who pay nothingYour organizations average cost per patient is $2000. Calculate the charge necessary to recover your cost. See cost-shifting problemProvide your answers in Microsoft Excel andshow all of your work.