a. Formula to calculate the total amount earned from each payor per visit type. b. Formula to calculate the total of all revenue per payor. c. Formula to calculate Total Revenue from all payors per visit type. d. Formula to calculate the Total Revenue of all payors and visit types. e. Formula to calculate the Total Revenue for the month of October.

MOA: Billing \& Coding; Health Administration Case Study One of your job duties at your medical office (Piedmont Healthcare OR Guilford Medical Associates) includes tracking patient visits by type and by insurance. It is your responsibility to track these visits on a monthly basis. In this case study you will create an Excel Spreadsheet that will track the following patient visits for the month of October: I have given you the total number of visits per payor that your office received for the various visit types. You will create a formula to calculate the TOTAL number of visits (indicated by " X " in the above table.) THEN you will create the following formulas that will CALCULATE the following: a. Formula to calculate the total amount earned from each payor per visit type. b. Formula to calculate the total of all revenue per payor. c. Formula to calculate Total Revenue from all payors per visit type. d. Formula to calculate the Total Revenue of all payors and visit types. e. Formula to calculate the Total Revenue for the month of October. IF you have set your formulas up correctly the amount generated in d. and e. above should match!! Columns dealing with money should have proper formatting applied showing a \$ sign and TWO decimal places. Grading Criteria: 1. Professionally Formatted (with Header Row that indicates Practice Name, Month, and 2. Make sure you have columns and rows for all the information you are tracking above. Revenue) 3. Whole spreadsheet should fit to one page in landscape view. 4. If the example has any grammar or spelling errors, 3 points will be deducted per error. 5. Formulas used to create these calculations: a. Formula to calculate the total amount earned from each payor per visit type. b. Formula to calculate the total of all revenue per payor. c. Formula to calculate Total Revenue from all payors per visit type. d. Formula to calculate the Total Revenue of all payors and visit types. e. Formula to calculate the Total Revenue for the month of October