2. A healthcare provider offers a single service to its patients, and the patients are covered by only two different third parties. Payer 1, Medicare, represents 50% of the patients and pays a fixed fee of $85 per patient. Payer 2, a Commercial Insurer, represents 45% of the patients and pays 75% of the provider's gross charge. The remaining patients are Charity Care patients who do not pay for their services. The provider treats 5,000 patients per month. The fixed costs of the provider each month is $77,500, and their variable cost per patient is $125. The provider desires to set its gross charge per patient to achieve a profit, or net income, of $50,000 for the month. a. Set up an Algebraic expression, with "p" being the gross charge (price) of the service to each patient being seen in the month, to solve this problem. Show this expression on your spreadsheet. b. Solve the problem finding the Gross Price to be charged to achieve the profit target. c. How many charity patients does the organization treat per month? d. What is the grand total sum of payments that the Commercial Insurer pays for all its patients in a month? (Note, this is not the total for one patient, but instead it is the total for all their patients together in the month). Note: we are testing three things in these problems: 1. Your understanding cost/volume/profit concepts in a health care setting. 2. Your Quantitative Literacy abilities to solve problems. 3. Your use of Excel as a tool for calculations and communicating information. 2. A healthcare provider offers a single service to its patients, and the patients are covered by only two different third parties. Payer 1, Medicare, represents 50% of the patients and pays a fixed fee of $85 per patient. Payer 2, a Commercial Insurer, represents 45% of the patients and pays 75% of the provider's gross charge. The remaining patients are Charity Care patients who do not pay for their services. The provider treats 5,000 patients per month. The fixed costs of the provider each month is $77,500, and their variable cost per patient is $125. The provider desires to set its gross charge per patient to achieve a profit, or net income, of $50,000 for the month. a. Set up an Algebraic expression, with "p" being the gross charge (price) of the service to each patient being seen in the month, to solve this problem. Show this expression on your spreadsheet. b. Solve the problem finding the Gross Price to be charged to achieve the profit target. c. How many charity patients does the organization treat per month? d. What is the grand total sum of payments that the Commercial Insurer pays for all its patients in a month? (Note, this is not the total for one patient, but instead it is the total for all their patients together in the month). Note: we are testing three things in these problems: 1. Your understanding cost/volume/profit concepts in a health care setting. 2. Your Quantitative Literacy abilities to solve problems. 3. Your use of Excel as a tool for calculations and communicating information