# Fee comparison workbook

Updated 2026-09-19.

## Purpose

Weighted revenue change, direct contribution and contribution per chair hour — what do the entered records support?

## Who uses this

Authorized payer analyst, billing lead, and practice owner

## Records to gather

Permitted coded procedures, annual volumes, current/proposed allowed amounts, collection rates, direct costs and chair minutes.

## Steps

1. Read Results and Use and Limits; review the separate Fictional Example.
2. Enter permitted coded procedures in Fee Inputs rows 7–306, using one annual period and consistent per-procedure costs and chair minutes. Resolve duplicate codes and incomplete rows.
3. Enter 0 only for a known zero. A complete row with zero annual units contributes zero chair hours when its per-unit chair time is valid. Missing or zero chair time leaves the affected hourly comparison unavailable.
4. Read Minimum revenue change and Maximum revenue change as signed extrema among complete price rows. A positive minimum means all included changes increase revenue; a negative maximum means all included changes decrease revenue.
5. Review unavailable or adverse results and supporting evidence; assign the missing record, reviewer, due date and next action in Review Actions.

## Key terms

- **Allowed amount**: Amount recognized under the specific reviewed payer arrangement, distinct from office fee.
- **Annual units**: Procedure units for the stated trailing or modeled year.
- **Variable cost**: Entered per-unit direct cost for this comparison; document included costs.

## Fictional example

Fictional example: 100 annual units at proposed $90, 95% collection, $20 direct cost and 30 chair minutes produce $8,550 revenue, −$950 change, $6,550 contribution and $131 per chair hour.

## Next action

Review each unavailable or adverse result, then assign the missing record, reviewer, due date and next action in Review Actions.

## Limits

Formulas are editable and sheet protection is not enabled. Use only the prepared rows and keep a clean copy. Recalculation and XLSX reimport were checked with Artifact Tool; Excel desktop/web, Google Sheets and native printing have not been interactively tested. These are aggregate planning tools, not professional verification.

## AI coaching

Help me complete this DenQAI file using the context below. Explain the supplied fictional example first, then ask one question at a time about my permitted fictional or aggregate, non-identifying inputs. Treat missing values as unknown, not zero. Keep example values separate from my case. Do not invent records, source verification, contract terms or professional conclusions. Identify the missing evidence and responsible reviewer before the next action.

File: Fee comparison workbook (XLSX).

Question: Weighted revenue change, direct contribution and contribution per chair hour — what do the entered records support?

Records to gather: Permitted coded procedures, annual volumes, current/proposed allowed amounts, collection rates, direct costs and chair minutes.

Fields or sheets: Results; Fee Inputs; Fictional Example; Review Actions; Use and Limits.

Key terms:
Allowed amount: Amount recognized under the specific reviewed payer arrangement, distinct from office fee.
Annual units: Procedure units for the stated trailing or modeled year.
Variable cost: Entered per-unit direct cost for this comparison; document included costs.

Steps:
1. Read Results and Use and Limits; review the separate Fictional Example.
2. Enter permitted coded procedures in Fee Inputs rows 7–306, using one annual period and consistent per-procedure costs and chair minutes. Resolve duplicate codes and incomplete rows.
3. Enter 0 only for a known zero. A complete row with zero annual units contributes zero chair hours when its per-unit chair time is valid. Missing or zero chair time leaves the affected hourly comparison unavailable.
4. Read Minimum revenue change and Maximum revenue change as signed extrema among complete price rows. A positive minimum means all included changes increase revenue; a negative maximum means all included changes decrease revenue.
5. Review unavailable or adverse results and supporting evidence; assign the missing record, reviewer, due date and next action in Review Actions.

Fictional example:
Fictional example: 100 annual units at proposed $90, 95% collection, $20 direct cost and 30 chair minutes produce $8,550 revenue, −$950 change, $6,550 contribution and $131 per chair hour.

Limits:
Formulas are editable and sheet protection is not enabled. Use only the prepared rows and keep a clean copy. Recalculation and XLSX reimport were checked with Artifact Tool; Excel desktop/web, Google Sheets and native printing have not been interactively tested. These are aggregate planning tools, not professional verification.

Next action: Review each unavailable or adverse result, then assign the missing record, reviewer, due date and next action in Review Actions.

## AI review

Review my permitted fictional or aggregate, non-identifying draft against the DenQAI file context below. Check the actual fields, units, periods, evidence and unresolved contradictions. Use arithmetic only where the stated model supports it; a CSV has no embedded formulas. Keep missing values unknown and separate facts, assumptions and the fictional example. Return specific corrections, questions for the responsible reviewer and the next action; do not invent professional approval.

File: Fee comparison workbook (XLSX).

Question: Weighted revenue change, direct contribution and contribution per chair hour — what do the entered records support?

Records to gather: Permitted coded procedures, annual volumes, current/proposed allowed amounts, collection rates, direct costs and chair minutes.

Fields or sheets: Results; Fee Inputs; Fictional Example; Review Actions; Use and Limits.

Key terms:
Allowed amount: Amount recognized under the specific reviewed payer arrangement, distinct from office fee.
Annual units: Procedure units for the stated trailing or modeled year.
Variable cost: Entered per-unit direct cost for this comparison; document included costs.

Steps:
1. Read Results and Use and Limits; review the separate Fictional Example.
2. Enter permitted coded procedures in Fee Inputs rows 7–306, using one annual period and consistent per-procedure costs and chair minutes. Resolve duplicate codes and incomplete rows.
3. Enter 0 only for a known zero. A complete row with zero annual units contributes zero chair hours when its per-unit chair time is valid. Missing or zero chair time leaves the affected hourly comparison unavailable.
4. Read Minimum revenue change and Maximum revenue change as signed extrema among complete price rows. A positive minimum means all included changes increase revenue; a negative maximum means all included changes decrease revenue.
5. Review unavailable or adverse results and supporting evidence; assign the missing record, reviewer, due date and next action in Review Actions.

Fictional example:
Fictional example: 100 annual units at proposed $90, 95% collection, $20 direct cost and 30 chair minutes produce $8,550 revenue, −$950 change, $6,550 contribution and $131 per chair hour.

Limits:
Formulas are editable and sheet protection is not enabled. Use only the prepared rows and keep a clean copy. Recalculation and XLSX reimport were checked with Artifact Tool; Excel desktop/web, Google Sheets and native printing have not been interactively tested. These are aggregate planning tools, not professional verification.

Next action: Review each unavailable or adverse result, then assign the missing record, reviewer, due date and next action in Review Actions.

## Related guide

[Open the related guide](https://denqai.com/tools/payer-offer)