ASSIGNMENT #$1$A $-$ CALCULATE PAYER MIX

Assume you are the practice manager for a primary care physician In a typical month your physician sees the following number of patients:

$\backslash$table$[[$Payer Category,Patient Volume$],[$Medicare$,250],[$Medicaid$,100],[$Managed Care,$150],[$Charity Care$/$Self$-$Pay,$20],[$Total Patient Volume,$520]]$

Calculate Payer Mix below. READ THESE INSTRUCTIONS CAREFULLY

Use Excel functionality for EVERY amount

No hard coded numbers

Format the Patient Volume EXACTLY as you see above

Format the Payer Mix as a Percent $(\%)$ and NO decimal points

PAYER MIX CALCULATION

Payer Category Patient Volume

Medicare

Medicaid

Managed Care

Charity Care$/$Self$-$Pay

Total

ASSIGNMENT #$1$B $-$ CALCULATE REVENUE

Assume you are the practice manager for a primary care physician In a typical month your physician sees the following number of patients:

$\backslash$table$[[$Payer Category,Patient Volume$],[$Medicare$,250],[$Medicaid$,100],[$Managed Care,$150],[$Charity Care$/$Self$-$Pay,$20],[$Total Patient Volume,$520]]$

Each insurance company will pay the following average amount:

$\backslash$table$[[$Payer Category,Payment$],[$Medicare$,$$$120$