On this page

• Form 1: Medical Cost Center
  

HCET Home > On-line Training > Money Matters > 4. Form 1: Medical Cost Center

Illustrates steps 6-8 in the development of cost based fees

Download or view the worksheet Form 1

• WI Medical Cost Center worksheet: Form 1
• WI Medical Cost Center worksheet: Form 1 in PDF format
• Wisconsin Cost Center Report - entire file in Excel

Look at Form1 in the Excel file. The relative value for each of the CPT codes is inserted automatically from the “procedures” spreadsheet onto the form. The next step is to insert utilization numbers for each of the CPT codes for the time frame under analysis.

The spreadsheet will automatically calculate:

1. the “Total Service Units”
2. the “Average Cost Per Service Unit”, and
3. the “Service Cost”

This last column (K - Fee) of the worksheet is the current fee schedule of the clinic that was in place during the timeframe of the analysis.
 

Section: Main 1 2 3 4 5 6 7 8

©Health Care Education & Training, Inc.
URL: http://www.hcet.org/training/Mmatters/ModII/F1Med.htm
 Last update: 04/22/08