two separate questions. i have to answer in excel

please show calculations for both

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 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 20 managed care 10 charity care 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 PRACTICE PROBL your cost. Using the data from the self-quiz problem on cost shifting, assume those who pay charges will alow a maximum charge of $2,100. Calculate the amount of costs you will need to cut to break even