REVENUE SCENARIOS AND BASIC EXCEL SKILLSASSIGNMENT #$2$A $-$ REVENUE SCENARIOS $-$ BASELINEAssume you are the practice manager for a primary care physician In a typical month your physician sees the following number of patients:ASSIGNMENT #$2$B $-$ REVENUE SCENARIOS $-$ HIGH MANAGED CAREASSIGNMENT #$2$C$-$ REVENUE SCENARIOS $-$ HIGH CHARITY$/$SELF$-$IAssume you are the practice manager for a primary care physicianAssume you are the practice manager for a primary care physicianIn a typical month your physician sees the following number of patients:In a typical month your physician sees the following number of patients:Payer CategoryMedicare MedicaidManaged CareCharity Care$/$Self$-$PayTotal Patient VolumePatient Volume$25010015020520$Payer CategoryMedicare MedicaidManaged CareCharity Care$/$Self$-$PayTotal Patient VolumePatient Volume$1505031010520$Payer CategoryMedicare MedicaidManaged CareCharity Care$/$Self$-$PayTotal Patient VolumePatient Volume$25010050120520$Each insurance company will pay the following average amount:Each insurance company will pay the following average amount:Each insurance company will pay the following average amount:Payer CategoryMedicareMedicaidManaged CareCharity Care$/$Self$-$PayPayment$$120$$$25$$$150$$OPayer CategoryMedicare MedicaidManaged CareCharity Care$/$Self$-$PayPayment$$120$$$25$$$150$$OPayer CategoryMedicareMedicaidManaged CareCharity Care$/$Self$-$PayPayment$$120$$$25$$$150$$OCalculate Payer Mix below. READ THESE INSTRUCTIONS CAREFULI Calculate Revenue below. READ THESE INSTRUCTIONS CAREFULIY$-$ Use Excel functionality for EVERY amount$-$ Use Excel functionality for EVERY amount$-$ No hard coded numbers$-$ No hard coded numbers$-$ Format the Patient Volume and Payment EXACTLY as you see above$-$ Format the Patient Volume and Payment EXACTLY as you see above$-$ Format the Revenue with a Dollar Sign $($S$)$ and NO decimal points$-$ Format the Revenue with a Dollar Sign $($$$)$ and NO decimal points$-$ Do not calculate a total payment$-$ Do not calculate a total paymentCalculate Revenue below. READ THESE INSTRUCTIONS CAREFULLY$-$ Use Excel functionality for EVERY amount$-$ No hard coded numbers$-$ Format the Patient Volume and Payment EXACTLY as you see above$-$ Format the Revenue with a Dollar Sign $($$$)$ and NO decimal points$-$ Do not calculate a total paymentREVENUE CALCULATION $-$ BASELINEPayer CategoryPatient VolumeMedicareMedicaidManaged CareCharity Care$/$Self$-$PayTotalPaymentRevenuexxxxxxxxxxxxxxREVENUE CALCULATION $-$ HIGH MANAGED CAREPayer CategoryPatient VolumePaymentMedicareMedicaidManaged CareCharity Care$/$Self$-$PayTotalxxxxxxxxxxxxxXRevenueREVENUE CALCULATION $-$ HIGH CHARITY$/$SELF$-$PAYPayer CategoryPatient Volume $||$PaymentMedicareMedicaidManaged CareCharity Care$/$Self$-$PayTotalxxxxxxxxxxxxxx$|$Revenue