{% extends 'mbaApp_base.html' %} {% load static %} {% block content %}
{% csrf_token %}
Output
{% if table1_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 1.1: Work, Practice, Liability and Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% for dat in table1_1_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table1_1_results|length %} {% endif %} {% endfor %} {% endif %} {% if table1_1_percent_total %} {% for tot in table1_1_percent_total %} {% endfor %} {% endif %}
Table 1.1: RVUs are standardized weights that reflect the resources used in the production of medical services. Work RVUs represent provider work efforts, Practice RVUs represent practice costs, PLI RVUs represent liability costs, and Total RVUs represent the total resources involved in the production of medical services. RVUs are not affected by payer mix or collections efforts, and are considered the 'gold standard' for medical services resource requirements. This table presents standardized RVU metrics representing provider work, practice costs, liability costs, and total production resources for each principal provider, and as a percent of total production for the reference period. Collaboration among providers is not considered in this table. 3/12/2021
RVU VOLUME Work RVUs Practice RVUs Liability RVUs Total RVUs
Primary Provider {{dat.CURRENT_PROVIDER_LABEL}} {{dat.WORK_RVU}} {{dat.PRACTICE_RVU}} {{dat.MALP_RVU}} {{dat.TOTAL_RVU}}
{{dat.WORK_RVU_PERCENT}}% {{dat.PRACTICE_RVU_PERCENT}}% {{dat.MALP_RVU_PERCENT}}% {{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.TOTAL_WORK_RVU}} {{dat.TOTAL_PRACTICE_RVU}} {{dat.TOTAL_MALP_RVU}} {{dat.FINAL_TOTAL_RVU}}
{{tot.TOTAL_WORK_RVU_PERCENT}}% {{tot.TOTAL_PRACTICE_RVU_PERCENT}}% {{tot.TOTAL_MALP_RVU_PERCENT}}% {{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if graph1_1_path %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Graph 1.1: Total Work RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% endif %} {% if table1_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 1.2: Payer Mix by Total RVUs
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% for dat in table1_2_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table1_2_results|length %} {% endif %} {% endfor %} {% endif %} {% if table1_2_percent_total %} {% for tot in table1_2_percent_total %} {% endfor %} {% endif %}
Table 1.2: Total RVUs represent the total resources (Work, Practice and Liability) utilized in the production of beneficiary services during the reference period. Payers are ranked by the total resources expended. 3/12/2021
PAYER TOTAL RVUS
INSURANCE {{dat.CURRENT_INSURANCE_LABEL}} {{dat.TOTAL_RVU}}
{{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.FINAL_TOTAL_RVU}}
{{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if graph1_2_path %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Graph 1.2: Payer Mix by Total RVUs
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% endif %} {% if report3_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Report 3.1: Procedure Costs and Margins for Selected Payers

{% endfor %}
{% for dat in report3_1_results %} {% endfor %} {% endif %}
Blue Cross Code Margin Medicare Location Margin Medicaid Description Margin Aggregate Volume Procedure Cost
{{dat.CPTCODE}} {{dat.LOCATION}} {{dat.DESCRIPTION}} {{dat.AGG_VOLUME}} {{dat.TOT_COST}} {{dat.M11_BCBS_AL____LOCAL____123119_FEE}} {{dat.M11_MEDICARE_10112______123119_FEE}} {{dat.M11_MEDICAID_AL_244032__123119_FEE}}
{% if report3_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Report 3.2: Market Basket Procedures and Costs

{% endfor %}
{% for dat in report3_2_results %} {% endfor %} {% endif %}
Aggregate Code Cost Major Payer Description Collections Payer Margin Aggregate Volume Procedure Cost Major Payer Fee
{{dat.CPTCODE}} {{dat.DESCRIPTION}} {{dat.PAYER}} {{dat.AGG_VOLUME}} {{dat.TOT_COST}} {{dat.MPF1}} {{dat.MPF2}} {{dat.MPF3}} {{dat.MPF4}}
{% if table4_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 4.1: New Patient Mix by Primary Provider

{% endfor %}
{% for cpt in table4_1_cpt %} {% endfor %} {% for cpt in table4_1_cpt %} {% endfor %} {% for dat in table4_1_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% endfor %} {% endif %}
  CPT CODE
{{cpt}}Total Visits
Sum Row Sum % Sum Row Sum %
CURRENT PROVIDER LABEL {{dat.CURRENT_PROVIDER_LABEL}} {{dat.99201}} {{dat.99201_percent}}% {{dat.99202}} {{dat.99202_percent}}% {{dat.99203}} {{dat.99203_percent}}% {{dat.99204}} {{dat.99204_percent}}% {{dat.99205}} {{dat.99205_percent}}% {{dat.TOTAL_VISITS}} 100.0%
{% if table4_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 4.2: Established Patient Mix by Primary Provider

{% endfor %}
{% for cpt in table4_2_cpt %} {% endfor %} {% for cpt in table4_2_cpt %} {% endfor %} {% for dat in table4_2_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% endfor %} {% endif %}
  CPT CODE
{{cpt}}Total Visits
Sum Row Sum % Sum Row Sum %
CURRENT PROVIDER LABEL {{dat.CURRENT_PROVIDER_LABEL}} {{dat.99211}} {{dat.99211_percent}}% {{dat.99212}} {{dat.99212_percent}}% {{dat.99213}} {{dat.99213_percent}}% {{dat.99214}} {{dat.99214_percent}}% {{dat.99215}} {{dat.99215_percent}}% {{dat.TOTAL_VISITS}} 100.0%
{% if table8_1_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer1_label%} Table 8.1: {{gdat.payer1_label}} Work, Practice, Liability and Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endif %} {% endfor %}
{% for dat in table8_1_1_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table8_1_1_results|length %} {% endif %} {% endfor %} {% endif %} {% if table8_1_1_percent_total %} {% for tot in table8_1_1_percent_total %} {% endfor %} {% endif %}
Table 8.1: Production is represented by components Work Contribution, Overhead Contribution and Liability Contribution. Total Production Contribution represents the total component resources involved in medical services production for the reference period. 3/12/2021
RVU VOLUME Work Contribution Overhead Contribution Liability Contribution Total Production Contribution
PHYSICIAN {{dat.CURRENT_PROVIDER_LABEL}} {{dat.WORK_RVU}} {{dat.PRACTICE_RVU}} {{dat.MALP_RVU}} {{dat.TOTAL_RVU}}
{{dat.WORK_RVU_PERCENT}}% {{dat.PRACTICE_RVU_PERCENT}}% {{dat.MALP_RVU_PERCENT}}% {{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.TOTAL_WORK_RVU}} {{dat.TOTAL_PRACTICE_RVU}} {{dat.TOTAL_MALP_RVU}} {{dat.FINAL_TOTAL_RVU}}
{{tot.TOTAL_WORK_RVU_PERCENT}}% {{tot.TOTAL_PRACTICE_RVU_PERCENT}}% {{tot.TOTAL_MALP_RVU_PERCENT}}% {{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if table8_1_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer2_label%} Table 8.1: {{gdat.payer2_label}} Work, Practice, Liability and Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endif %} {% endfor %}
{% for dat in table8_1_2_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table8_1_2_results|length %} {% endif %} {% endfor %} {% endif %} {% if table8_1_2_percent_total %} {% for tot in table8_1_2_percent_total %} {% endfor %} {% endif %}
Table 8.1: Production is represented by components Work Contribution, Overhead Contribution and Liability Contribution. Total Production Contribution represents the total component resources involved in medical services production for the reference period. 3/12/2021
RVU VOLUME Work Contribution Overhead Contribution Liability Contribution Total Production Contribution
PHYSICIAN {{dat.CURRENT_PROVIDER_LABEL}} {{dat.WORK_RVU}} {{dat.PRACTICE_RVU}} {{dat.MALP_RVU}} {{dat.TOTAL_RVU}}
{{dat.WORK_RVU_PERCENT}}% {{dat.PRACTICE_RVU_PERCENT}}% {{dat.MALP_RVU_PERCENT}}% {{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.TOTAL_WORK_RVU}} {{dat.TOTAL_PRACTICE_RVU}} {{dat.TOTAL_MALP_RVU}} {{dat.FINAL_TOTAL_RVU}}
{{tot.TOTAL_WORK_RVU_PERCENT}}% {{tot.TOTAL_PRACTICE_RVU_PERCENT}}% {{tot.TOTAL_MALP_RVU_PERCENT}}% {{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if table8_1_3_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer3_label%} Table 8.1: {{gdat.payer3_label}} Work, Practice, Liability and Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endif %} {% endfor %}
{% for dat in table8_1_3_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table8_1_3_results|length %} {% endif %} {% endfor %} {% endif %} {% if table8_1_3_percent_total %} {% for tot in table8_1_3_percent_total %} {% endfor %} {% endif %}
Table 8.1: Production is represented by components Work Contribution, Overhead Contribution and Liability Contribution. Total Production Contribution represents the total component resources involved in medical services production for the reference period. 3/12/2021
RVU VOLUME Work Contribution Overhead Contribution Liability Contribution Total Production Contribution
PHYSICIAN {{dat.CURRENT_PROVIDER_LABEL}} {{dat.WORK_RVU}} {{dat.PRACTICE_RVU}} {{dat.MALP_RVU}} {{dat.TOTAL_RVU}}
{{dat.WORK_RVU_PERCENT}}% {{dat.PRACTICE_RVU_PERCENT}}% {{dat.MALP_RVU_PERCENT}}% {{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.TOTAL_WORK_RVU}} {{dat.TOTAL_PRACTICE_RVU}} {{dat.TOTAL_MALP_RVU}} {{dat.FINAL_TOTAL_RVU}}
{{tot.TOTAL_WORK_RVU_PERCENT}}% {{tot.TOTAL_PRACTICE_RVU_PERCENT}}% {{tot.TOTAL_MALP_RVU_PERCENT}}% {{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if table8_1_4_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer4_label%} Table 8.1: {{gdat.payer4_label}} Work, Practice, Liability and Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endif %} {% endfor %}
{% for dat in table8_1_4_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table8_1_4_results|length %} {% endif %} {% endfor %} {% endif %} {% if table8_1_4_percent_total %} {% for tot in table8_1_4_percent_total %} {% endfor %} {% endif %}
Table 8.1: Production is represented by components Work Contribution, Overhead Contribution and Liability Contribution. Total Production Contribution represents the total component resources involved in medical services production for the reference period. 3/12/2021
RVU VOLUME Work Contribution Overhead Contribution Liability Contribution Total Production Contribution
PHYSICIAN {{dat.CURRENT_PROVIDER_LABEL}} {{dat.WORK_RVU}} {{dat.PRACTICE_RVU}} {{dat.MALP_RVU}} {{dat.TOTAL_RVU}}
{{dat.WORK_RVU_PERCENT}}% {{dat.PRACTICE_RVU_PERCENT}}% {{dat.MALP_RVU_PERCENT}}% {{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.TOTAL_WORK_RVU}} {{dat.TOTAL_PRACTICE_RVU}} {{dat.TOTAL_MALP_RVU}} {{dat.FINAL_TOTAL_RVU}}
{{tot.TOTAL_WORK_RVU_PERCENT}}% {{tot.TOTAL_PRACTICE_RVU_PERCENT}}% {{tot.TOTAL_MALP_RVU_PERCENT}}% {{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if table8_1_5_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer5_label%} Table 8.1: {{gdat.payer5_label}} Work, Practice, Liability and Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endif %} {% endfor %}
{% for dat in table8_1_5_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table8_1_5_results|length %} {% endif %} {% endfor %} {% endif %} {% if table8_1_5_percent_total %} {% for tot in table8_1_5_percent_total %} {% endfor %} {% endif %}
Table 8.1: Production is represented by components Work Contribution, Overhead Contribution and Liability Contribution. Total Production Contribution represents the total component resources involved in medical services production for the reference period. 3/12/2021
RVU VOLUME Work Contribution Overhead Contribution Liability Contribution Total Production Contribution
PHYSICIAN {{dat.CURRENT_PROVIDER_LABEL}} {{dat.WORK_RVU}} {{dat.PRACTICE_RVU}} {{dat.MALP_RVU}} {{dat.TOTAL_RVU}}
{{dat.WORK_RVU_PERCENT}}% {{dat.PRACTICE_RVU_PERCENT}}% {{dat.MALP_RVU_PERCENT}}% {{dat.TOTAL_RVU_PERCENT}}%
  Total {{dat.TOTAL_WORK_RVU}} {{dat.TOTAL_PRACTICE_RVU}} {{dat.TOTAL_MALP_RVU}} {{dat.FINAL_TOTAL_RVU}}
{{tot.TOTAL_WORK_RVU_PERCENT}}% {{tot.TOTAL_PRACTICE_RVU_PERCENT}}% {{tot.TOTAL_MALP_RVU_PERCENT}}% {{tot.FINAL_TOTAL_RVU_PERCENT}}%
{% if graph8_1_path %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{% endfor %} {% for pdat in payer_data %} {%if pdat.payer_selfpay%} Graph 8.1: {{pdat.payer_selfpay}} Total RVUs by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endif %} {% endfor %}
{% endif %} {% if report8_2_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer1_label%} Report 8.2: {{gdat.payer1_label}} Volume, Cost, Fee and Margin by Procedure
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in report8_2_1_results %} {% if dat.row == report8_2_1_results|length %} {% endif %} {% endfor %}
Code Facility Code Description Service Volume Procedure Cost Aggregate Cost Payer Fee Procedure Margin Projected Collections Aggregate Margin
{{dat.CPTCODE}} {{dat.LOCATION}} {{dat.DESCRIPTION}} {{dat.Service_Volume}} {{dat.Procedure_Cost}} {{dat.Aggregate_Cost}} {{dat.Payer_Fee}} {{dat.Procedure_Margin}} {{dat.Projected_Collections}} {{dat.Aggregate_Margin}}
Total         {{dat.TOTAL_AGG_COST}}     {{dat.TOTAL_COLLECT}} {{dat.TOTAL_AGGREGATE_MARGIN}}
Payer Pecent Margin                 {{dat.PAYER_PERCENT_MARGIN}}%
{% endif %} {% if report8_2_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer2_label%} Report 8.2: {{gdat.payer2_label}} Volume, Cost, Fee and Margin by Procedure
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in report8_2_2_results %} {% if dat.row == report8_2_2_results|length %} {% endif %} {% endfor %}
Code Facility Code Description Service Volume Procedure Cost Aggregate Cost Payer Fee Procedure Margin Projected Collections Aggregate Margin
{{dat.CPTCODE}} {{dat.LOCATION}} {{dat.DESCRIPTION}} {{dat.Service_Volume}} {{dat.Procedure_Cost}} {{dat.Aggregate_Cost}} {{dat.Payer_Fee}} {{dat.Procedure_Margin}} {{dat.Projected_Collections}} {{dat.Aggregate_Margin}}
Total         {{dat.TOTAL_AGG_COST}}     {{dat.TOTAL_COLLECT}} {{dat.TOTAL_AGGREGATE_MARGIN}}
Payer Pecent Margin                 {{dat.PAYER_PERCENT_MARGIN}}%
{% endif %} {% if report8_2_3_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer3_label%} Report 8.2: {{gdat.payer3_label}} Volume, Cost, Fee and Margin by Procedure
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in report8_2_3_results %} {% if dat.row == report8_2_3_results|length %} {% endif %} {% endfor %}
Code Facility Code Description Service Volume Procedure Cost Aggregate Cost Payer Fee Procedure Margin Projected Collections Aggregate Margin
{{dat.CPTCODE}} {{dat.LOCATION}} {{dat.DESCRIPTION}} {{dat.Service_Volume}} {{dat.Procedure_Cost}} {{dat.Aggregate_Cost}} {{dat.Payer_Fee}} {{dat.Procedure_Margin}} {{dat.Projected_Collections}} {{dat.Aggregate_Margin}}
Total         {{dat.TOTAL_AGG_COST}}     {{dat.TOTAL_COLLECT}} {{dat.TOTAL_AGGREGATE_MARGIN}}
Payer Pecent Margin                 {{dat.PAYER_PERCENT_MARGIN}}%
{% endif %} {% if report8_2_4_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer4_label%} Report 8.2: {{gdat.payer4_label}} Volume, Cost, Fee and Margin by Procedure
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in report8_2_4_results %} {% if dat.row == report8_2_4_results|length %} {% endif %} {% endfor %}
Code Facility Code Description Service Volume Procedure Cost Aggregate Cost Payer Fee Procedure Margin Projected Collections Aggregate Margin
{{dat.CPTCODE}} {{dat.LOCATION}} {{dat.DESCRIPTION}} {{dat.Service_Volume}} {{dat.Procedure_Cost}} {{dat.Aggregate_Cost}} {{dat.Payer_Fee}} {{dat.Procedure_Margin}} {{dat.Projected_Collections}} {{dat.Aggregate_Margin}}
Total         {{dat.TOTAL_AGG_COST}}     {{dat.TOTAL_COLLECT}} {{dat.TOTAL_AGGREGATE_MARGIN}}
Payer Pecent Margin                 {{dat.PAYER_PERCENT_MARGIN}}%
{% endif %} {% if report8_2_5_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{%if gdat.payer5_label%} Report 8.2: {{gdat.payer5_label}} Volume, Cost, Fee and Margin by Procedure
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in report8_2_5_results %} {% if dat.row == report8_2_5_results|length %} {% endif %} {% endfor %}
Code Facility Code Description Service Volume Procedure Cost Aggregate Cost Payer Fee Procedure Margin Projected Collections Aggregate Margin
{{dat.CPTCODE}} {{dat.LOCATION}} {{dat.DESCRIPTION}} {{dat.Service_Volume}} {{dat.Procedure_Cost}} {{dat.Aggregate_Cost}} {{dat.Payer_Fee}} {{dat.Procedure_Margin}} {{dat.Projected_Collections}} {{dat.Aggregate_Margin}}
Total         {{dat.TOTAL_AGG_COST}}     {{dat.TOTAL_COLLECT}} {{dat.TOTAL_AGGREGATE_MARGIN}}
Payer Pecent Margin                 {{dat.PAYER_PERCENT_MARGIN}}%
{% endif %} {% if report8_3_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{% endfor %} {% for pdat in payer_data %} {%if pdat.payer_selfpay%} Report 8.3: {{pdat.payer_selfpay}} Under-Compensated Services Volume, Cost, Fee and Margin by Procedure
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in report8_3_results %} {% if dat.row == report8_3_results|length %} {% endif %} {% endfor %}
Code Description Service Volume TOT_COST_A Aggregate Cost Payer Fee Procedure Margin Projected Collections Aggregate Margin
{{dat.CPTCODE}} {{dat.DESCRIPTION}} {{dat.Service_Volume}} {{dat.TOT_COST_A}} {{dat.Aggregate_Cost}} {{dat.Payer_Fee}} {{dat.Procedure_Margin}} {{dat.Projected_Collections}} {{dat.Aggregate_Margin}}
Total       {{dat.TOTAL_AGG_COST}}     {{dat.TOTAL_COLLECT}} {{dat.TOTAL_AGGREGATE_MARGIN}}
{% endif %} {% if table8_4_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
{% endfor %} {% for pdat in payer_data %} {%if pdat.payer_selfpay%} Table 8.4: {{pdat.payer_selfpay}} Actual Payments, Production Costs and Margin
for the Period Ending {{gdat.end_date}}

{% endif %} {% endfor %}
{% for dat in table8_4_results %} {% endfor %}
Table 8.4: Aggregate Costs Analysis. This report represents actual collections received and actual costs incurred in medical services production. Payments are dollars collected, and production costs are actual costs incurred in producing services. Margin represents the profit or loss on payer's services during the reference period, and Margin Percent represents the ratio of Margin to Payments. 3/12/2021
PAYMENTS {{dat.PAYMENTS}}
Actual Production Costs {{dat.PAYER_AGGREGATE_COST}}
Margin on Services {{dat.PAYER_AGGREGATE_MARGIN}}
Margin Percent {{dat.MARGIN_PERCENT}}%
{% endif %} {% if table8_5_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 8.5: Comparative Margin Analyses Based on Payer Allowables and Component Costs
for the Period Ending {{gdat.end_date}}

{% endfor %}
{% for gdat in generic_data %} {% endfor %} {% if table8_5_results %} {% for dat in table8_5_results %} {% if dat.PPA_1 %} {% endif %} {% if dat.PPA_2 %} {% endif %} {% if dat.PPA_3 %} {% endif %} {% if dat.PPA_4 %} {% endif %} {% if dat.PPA_5 %} {% endif %} {% if dat.PC_1 %} {% endif %} {% if dat.PC_2 %} {% endif %} {% if dat.PC_3 %} {% endif %} {% if dat.PC_4 %} {% endif %} {% if dat.PC_5 %} {% endif %} {% if dat.MOS_1 %} {% endif %} {% if dat.MOS_2 %} {% endif %} {% if dat.MOS_3 %} {% endif %} {% if dat.MOS_4 %} {% endif %} {% if dat.MOS_5 %} {% endif %} {% if dat.MP_1 %} {% else %} {% endif%} {% if dat.MP_2 %} {% else %} {% endif%} {% if dat.MP_3 %} {% else %} {% endif%} {% if dat.MP_4 %} {% else %} {% endif%} {% if dat.MP_5 %} {% else %} {% endif%} {% endfor %} {% endif %}
Table 8.5: This report compares the margins of selected payers. Payments are based upon payer's fee schedule allowables, and production costs are the costs ascribed to the production of payer's specific quantity and mix of services. Margin represents the profit or loss realized from the production of services for payer's beneficiaries during the reference period, and Margin Percent represents the ratio of Margin to Payments. Comparison of this table to Table 8.6 helps to identify problems such as payer under-reimbursement, tardy payments, collection issues, and inaccurate or changed fee schedules. 3/12/2021
  Payer
{{gdat.payer1_label}} {{gdat.payer2_label}} {{gdat.payer3_label}} {{gdat.payer4_label}} {{gdat.payer5_label}}
Projected Payer Allowables{{dat.PPA_1}}{{dat.PPA_2}}{{dat.PPA_3}}{{dat.PPA_4}}{{dat.PPA_5}}
Production Costs{{dat.PC_1}}{{dat.PC_2}}{{dat.PC_3}}{{dat.PC_4}}{{dat.PC_5}}
Margin on Services{{dat.MOS_1}}{{dat.MOS_2}}{{dat.MOS_3}}{{dat.MOS_4}}{{dat.MOS_5}}
Margin Percent{{dat.MP_1}}%None{{dat.MP_2}}%None{{dat.MP_3}}%None{{dat.MP_4}}%None{{dat.MP_5}}%None
{% endif %} {% if table8_6_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 8.6: Comparative Margin Analyses Based on Actual Payments and Component Costs
for the Period Ending {{gdat.end_date}}

{% endfor %}
{% for gdat in generic_data %} {% endfor %} {% if table8_6_results %} {% for dat in table8_6_results %} {% endfor %} {% endif %}
Table 8.6: This report compares the margins of selected payers. Payments are based upon actual payments received from all sources, and production costs are the costs ascribed to the production of payer's specific quantity and mix of services. Margin represents the profit or loss realized from the production of services for payer's beneficiaries during the reference period, and Margin Percent represents the ratio of Margin to Payments. Comparison of this table to Table 8.6 helps to identify problems such as payer under-reimbursement, tardy payments, collection issues, and inaccurate or changed fee schedules. 3/12/2021
  Payer
{{gdat.payer1_label}} {{gdat.payer2_label}} {{gdat.payer3_label}} {{gdat.payer4_label}} {{gdat.payer5_label}}
Actual Payments {{dat.AP_1}} {{dat.AP_2}} {{dat.AP_3}} {{dat.AP_4}} {{dat.AP_5}}
Production Costs {{dat.PC_1}} {{dat.PC_2}} {{dat.PC_3}} {{dat.PC_4}} {{dat.PC_5}}
Margin on Services {{dat.MOS_1}} {{dat.MOS_2}} {{dat.MOS_3}} {{dat.MOS_4}} {{dat.MOS_5}}
Margin Percent {{dat.MP_1}}% {{dat.MP_2}}% {{dat.MP_3}}% {{dat.MP_4}}% {{dat.MP_5}}%
{% endif %} {% if table9_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 9.1: Component Cost Allocations by Primary Provider ID
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Weights

{% endfor %}
{% for dat in table9_1_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table9_1_results|length %} {% endif %} {% endfor %} {% if table9_1_percent_total %} {% for tot in table9_1_percent_total %} {% endfor %} {% endif %} {% endif %}
3/12/2021
Cost Allocations MD Work Cost Practice Cost Malpractice Cost Total Cost
Provider ID {{dat.CURRENT_PROVIDER}} {{dat.EXT_WORK_COST}} {{dat.EXT_PRAC_COST}} {{dat.EXT_MALP_COST}} {{dat.EXT_TOT_COST}}
{{dat.WORK_COST_PERCENT}}% {{dat.PRACTICE_COST_PERCENT}}% {{dat.MALP_COST_PERCENT}}% {{dat.TOTAL_COST_PERCENT}}%
  Total {{dat.TOTAL_EXT_WORK_COST}} {{dat.TOTAL_EXT_PRAC_COST}} {{dat.TOTAL_EXT_MALP_COST}} {{dat.TOTAL_EXT_TOT_COST}}
{{tot.TOTAL_WORK_COST_PERCENT}}% {{tot.TOTAL_PRACTICE_COST_PERCENT}}% {{tot.TOTAL_MALP_COST_PERCENT}}% {{tot.FINAL_TOTAL_COST_PERCENT}}%
{% if table9_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 9.2: Component Cost Allocations by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Weights

{% endfor %}
{% for dat in table9_2_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table9_2_results|length %} {% endif %} {% endfor %} {% if table9_2_percent_total %} {% for tot in table9_2_percent_total %} {% endfor %} {% endif %} {% endif %}
3/12/2021
Cost Allocations MD Work Cost Practice Cost Malpractice Cost Total Cost
Provider {{dat.CURRENT_PROVIDER}} {{dat.EXT_WORK_COST}} {{dat.EXT_PRAC_COST}} {{dat.EXT_MALP_COST}} {{dat.EXT_TOT_COST}}
{{dat.WORK_COST_PERCENT}}% {{dat.PRACTICE_COST_PERCENT}}% {{dat.MALP_COST_PERCENT}}% {{dat.TOTAL_COST_PERCENT}}%
  Total {{dat.TOTAL_EXT_WORK_COST}} {{dat.TOTAL_EXT_PRAC_COST}} {{dat.TOTAL_EXT_MALP_COST}} {{dat.TOTAL_EXT_TOT_COST}}
{{tot.TOTAL_WORK_COST_PERCENT}}% {{tot.TOTAL_PRACTICE_COST_PERCENT}}% {{tot.TOTAL_MALP_COST_PERCENT}}% {{tot.FINAL_TOTAL_COST_PERCENT}}%
{% if table9_3_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 9.3: Component Cost and Bonus Allocations by Primary Provider ID
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Weights

{% endfor %}
{% for dat in table9_3_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table9_3_results|length %} {% endif %} {% endfor %} {% if table9_3_percent_total %} {% for tot in table9_3_percent_total %} {% endfor %} {% endif %} {% endif %}
3/12/2021
Cost and Bonus Allocations MD Work Cost Practice Cost Malpractice Cost Total Cost Available for MD Bonus Maximum MD Total
Provider ID {{dat.CURRENT_PROVIDER}} {{dat.EXT_WORK_COST}} {{dat.EXT_PRAC_COST}} {{dat.EXT_MALP_COST}} {{dat.EXT_TOT_COST}} {{dat.EXT_BONUS_COST}} {{dat.EXT_MD_COMP}}
{{dat.WORK_COST_PERCENT}}% {{dat.PRACTICE_COST_PERCENT}}% {{dat.MALP_COST_PERCENT}}% {{dat.TOTAL_COST_PERCENT}}% {{dat.BONUS_COST_PERCENT}}% {{dat.MD_COMP_PERCENT}}%
  Total {{dat.TOTAL_EXT_WORK_COST}} {{dat.TOTAL_EXT_PRAC_COST}} {{dat.TOTAL_EXT_MALP_COST}} {{dat.TOTAL_EXT_TOT_COST}} {{dat.TOTAL_EXT_BONUS_COST}} {{dat.TOTAL_EXT_MD_COMP}}
{{tot.TOTAL_WORK_COST_PERCENT}}% {{tot.TOTAL_PRACTICE_COST_PERCENT}}% {{tot.TOTAL_MALP_COST_PERCENT}}% {{tot.FINAL_TOTAL_COST_PERCENT}}% {{tot.TOTAL_BONUS_COST_PERCENT}}% {{tot.TOTAL_MD_COMP_PERCENT}}%
{% if table9_4_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 9.4: Component Cost and Bonus Allocations by Primary Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Weights

{% endfor %}
{% for dat in table9_4_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table9_4_results|length %} {% endif %} {% endfor %} {% if table9_4_percent_total %} {% for tot in table9_4_percent_total %} {% endfor %} {% endif %} {% endif %}
3/12/2021
Cost and Bonus Allocations MD Work Cost Practice Cost Malpractice Cost Total Cost Available for MD Bonus Maximum MD Total
Provider {{dat.CURRENT_PROVIDER}} {{dat.EXT_WORK_COST}} {{dat.EXT_PRAC_COST}} {{dat.EXT_MALP_COST}} {{dat.EXT_TOT_COST}} {{dat.EXT_BONUS_COST}} {{dat.EXT_MD_COMP}}
{{dat.WORK_COST_PERCENT}}% {{dat.PRACTICE_COST_PERCENT}}% {{dat.MALP_COST_PERCENT}}% {{dat.TOTAL_COST_PERCENT}}% {{dat.BONUS_COST_PERCENT}}% {{dat.MD_COMP_PERCENT}}%
  Total {{dat.TOTAL_EXT_WORK_COST}} {{dat.TOTAL_EXT_PRAC_COST}} {{dat.TOTAL_EXT_MALP_COST}} {{dat.TOTAL_EXT_TOT_COST}} {{dat.TOTAL_EXT_BONUS_COST}} {{dat.TOTAL_EXT_MD_COMP}}
{{tot.TOTAL_WORK_COST_PERCENT}}% {{tot.TOTAL_PRACTICE_COST_PERCENT}}% {{tot.TOTAL_MALP_COST_PERCENT}}% {{tot.FINAL_TOTAL_COST_PERCENT}}% {{tot.TOTAL_BONUS_COST_PERCENT}}% {{tot.TOTAL_MD_COMP_PERCENT}}%
{% if table10_1_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 10.1: Work, Practice Expense and Liability RVUs by Collaborating Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% for dat in table10_1_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table10_1_results|length %} {% endif %} {% endfor %} {% endif %} {% if table10_1_percent_total %} {% for tot in table10_1_percent_total %} {% endfor %} {% endif %}
3/12/2021
RVU Volume Independent Work Primary Colloboration Work Primary Supervision Work Secondary Colloboration Work Secondary Supervision Work Total Work RVUs
Collaborating Provider {{dat.COLLBORATING_PROVIDER}} {{dat.INDEPENDENT_WORK}} {{dat.PRIMARY_COLLABORATION_WORK}} {{dat.PRIMARY_SUPERVISION_WORK}} {{dat.SECONDARY_COLLABORATION_WORK}} {{dat.SECONDARY_SUPERVISION_WORK}} {{dat.TOTAL_WORK_RVUS}}
{{dat.INDEPENDENT_WORK_PERCENT}}% {{dat.PRIMARY_COLLABORATION_WORK_PERCENT}}% {{dat.PRIMARY_SUPERVISION_WORK_PERCENT}}% {{dat.SECONDARY_COLLABORATION_WORK_PERCENT}}% {{dat.SECONDARY_SUPERVISION_WORK_PERCENT}}% {{dat.TOTAL_WORK_RVUS_PERCENT}}%
  Total {{dat.TOTAL_INDEPENDENT_WORK}} {{dat.TOTAL_PRIMARY_COLLABORATION_WORK}} {{dat.TOTAL_PRIMARY_SUPERVISION_WORK}} {{dat.TOTAL_SECONDARY_COLLABORATION_WORK}} {{dat.TOTAL_SECONDARY_SUPERVISION_WORK}} {{dat.FINAL_TOTAL_WORK_RVUS}}
{{tot.TOTAL_INDEPENDENT_WORK_PERCENT}}% {{tot.TOTAL_PRIMARY_COLLABORATION_WORK_PERCENT}}% {{tot.TOTAL_PRIMARY_SUPERVISION_WORK_PERCENT}}% {{tot.FINAL_TOTAL_SECONDARY_COLLABORATION_WORK_PERCENT}}% {{tot.TOTAL_SECONDARY_SUPERVISION_WORK_PERCENT}}% {{tot.FINAL_TOTAL_WORK_RVUS_PERCENT}}%
{% if graph10_1_path %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Graph 10.1: Total Work RVUs by Collaborating Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% endif %} {% if table10_2_results %}
{% for gdat in generic_data %}

{{gdat.group_name}}
Table 10.2: Work, Practice, and Malpractice RVUs by Collaborating Provider
Period Ending {{gdat.end_date}} with {{gdat.year}} RVU Values

{% endfor %}
{% for dat in table10_2_results %} {% if dat.row == 1 %} {% else %} {% endif %} {% if dat.row == table10_2_results|length %} {% endif %} {% endfor %} {% endif %} {% if table10_2_percent_total %} {% for tot in table10_2_percent_total %} {% endfor %} {% endif %}
3/12/2021
RVU Volume Total Work RVUs Total Practice RVUs Total Malpractice RVUs Total RVUs
Provider {{dat.PROVIDER}} {{dat.TOTAL_WORK_RVUS}} {{dat.TOTAL_PRACTICE_RVUS}} {{dat.TOTAL_MALP_RVUS}} {{dat.TOTAL_RVUS}}
{{dat.TOTAL_WORK_RVUS_PERCENT}}% {{dat.TOTAL_PRACTICE_RVUS_PERCENT}}% {{dat.TOTAL_MALP_RVUS_PERCENT}}% {{dat.TOTAL_RVUS_PERCENT}}%
  Total {{dat.FINAL_TOTAL_WORK_RVUS}} {{dat.FINAL_TOTAL_PRACTICE_RVUS}} {{dat.FINAL_TOTAL_MALP_RVUS}} {{dat.FINAL_TOTAL_RVUS}}
{{tot.FINAL_TOTAL_WORK_RVUS_PERCENT}}% {{tot.FINAL_TOTAL_PRACTICE_RVUS_PERCENT}}% {{tot.FINAL_TOTAL_MALP_RVUS_PERCENT}}% {{tot.FINAL_TOTAL_RVUS_PERCENT}}%
{% endblock content %}