Reference no: EM132678920

Physician Office Revenue for Visit Code 99214 has a full established rate of $62.00. Of ten different payers, there are nine different contracted rates, as follows:

Payer               Contracted Rate
FHP                  $58.75
HPHP                  48.25
MC                     54.90
UND                   60.40
CCN                    62.00
MO                        50.75
CGN                      12.00
PRU                   55.95
PHCS                    40.00
ANA                    49.00

• Rates for illustration only.

Required

Problem 1. Set up a worksheet with four columns: Payer, Full Rate, Contracted Rate, and Contractual Allowance.

Problem 2. For each payer, enter the full rate and the contracted rate.

Problem 3. For each payer, compute the contractual allowance.

The first payer has been computed below:

Full Contracted Contractual
Payer Rate (less) Rate = Allowance
FHP $72.00 $35.70 $36.30