please see attachments

Assignment Content Complete Assignment Exercise 5-1: Contractual Allowances. It can be found on page 528 & 529 of the text, or access it at the bottom of the Table of Contents in your eBook, in the section Examples & Exercises, Chapter 5, Assignment Exercise 5-1. In the text, be sure to read the information at the top of Page 529. This assignment must be completed using Excel. Specifically, this means you must include formulas in the Excel Worksheet. You are v not permitted to do manual calculations and simply insert a number into a cell. The absence of formulas will result in a reduction of your grade for this assignment.CHAPTER 5 Example 5A: Contractual Allowances Contractual allowances represent the difference between the full established rate and the agreed-upon contractual rate that will be paid. An example was given in the text of Chapter 5 by which the hospital's full established rate for a certain procedure is $100, but Giant Health Plan has negotiated a managed care contract whereby the plan pays only $90 for that procedure. The contractual allowance is $10 ($100 less $90 = $10). Assume instead that Near-By Health Plan has negotiated its own managed care contract whereby this plan pays $95 for that procedure. In this case the contractual allowance is $5 ($100 less $95 = $5). Assignment Exercise 5-1: Contractual Allowances Physician office revenue for visit code 99214 has a full established rate of $72.00. Of 10 different payers, there are 9 different contracted rates, as follows: Payer Contracted Rate (in dollars) FHP 35.70 HPHP 58.85 MC 54.90 UND 60.40 CON 70.20 MO 70.75 CGN 10.00 PRU 54.90 Aa )) 11:14 AM 5/16/2021 O XPayer Contracted Rate (in dollars) FHP 35.70 HPHP 58.85 MC 54.90 UND 60.40 CON 70.20 MO 70.75 CGN 10.00 PRU 54.90 PHCS 50.00 ANA 45.00 Rates for illustration only Required 1. Set up a worksheet with four columns: Payer, Full Rate, Contracted Rate, and Contractual Allowance 2. For each payer, enter the full rate and the contracted rate 3. For each payer, compute the contractual allowance