Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Sample Transportation Reporting Spreadsheets by yia21345

VIEWS: 42 PAGES: 30

Sample Transportation Reporting Spreadsheets document sample

More Info
									  Texas Christian
University Treatment
     Costs and                                             Outpatient Drug-Free Substance Abuse
  Organizational                                            Treatment Cost Analysis Workbook
 Monitoring (TCOM)                                                                                                                               Overview
      Project                                                                                                                                     Page 1

I. Summary Description. This Cost Analysis Workbook is a series of linked Excel spreadsheets designed to assist in the cost analysis of
outpatient substance abuse treatment programs involved in the NIDA funded Texas Christian University TCOM Project.
The objective of the program-level cost analysis is to identify a series of traditional unit cost measures including "cost per episode",
"cost per enrolled patient day", as well as "cost per counseling hour" for each program on an annual basis. This is achieved by asking
programs to provide client volume data, counseling information, facility-level cost and revenue data, personnel and non-personnel
cost data, and computing estimates based on these figures. This workbook includes data source codes (to determine the degree
of reliability of each response) and links between data points that will help check for consistency in responses so that programs
will obtain the most reliable cost data possible. An accompanying data entry guide is available for reference and some
data definitions are located in notes (indicated with a red flag) within worksheets.

The workbook includes the following specific spreadsheets:
Spreadsheet                              Description/Type of Data
Page 1. Overview                                           Workbook Summary and Facility Administrative Information
Page 2. Parent Organization Level Data -                   Parent Organizational Level Information and Relationship to Program
Page 3. Program Level Data -                               Client Volume, Facility Level Costs/Revenues and Counseling Information
Page 4. FTE (Full Time Employee) Costs -                   FTE and Volunteer Counts, Hourly Rates, and Hours Worked Per Week
Page 5. PTE (Part Time Employee)/Contractor Costs -        PTE, Contractor, and Volunteer Counts, Hourly Rates, Hours Worked per Week
Page 6. Non-Personnel Costs                                Calculated Unit Costs - Page is Locked and For Analysis Only
Page 7. Unit Cost Analyses                                 Calculated Personnel Cost Summary - Page is Locked and For Analysis Only
Page 8. Personnel Cost Analyses -                          Calculated Counseling Cost Analysis - Page is Locked and For Analysis Only
Page 9. Counseling Cost Analyses                           Workbook Summary Analyses and Wrap-Up Review
Page 10 Data Summary                                       Data Source Codes are Defined for Data Entry
Appendix A. Sources Codes                                  Comparative Data (To be defined)
Comparison Chart #1                                        Compares ADSS Personnel Cost Distribution with Program Personnel Cost Distribution
Comparison Chart #2                                        Compares ADSS Adjusted Unit Costs for Outpatient Programs to the Current Program
Comparison Chart #3                                        Compares ADSS Adjusted Mean Hourly Personnel Rates by Full-Time Staffing Category
II. Administrative Data
Drug Free OP Program Name
Parent Name (if any)
Program Address:
            street
            city, state zip

Primary Program Contact
Program Contact Number
Program ID Number
Beginning Survey Date:
Preparer's Name:
Date of Preparation:

Program Type and Subtype
Please check (X) the program type and subtype for the substance abuse treatment unit of analysis

Outpatient Non-Methadone
             Regular Outpatient
             Intensive Outpatient
Ownership Type
             Public
             Private
             Non-Profit

III. Financial Reporting Questions
                                                                                                               Start Date                  End Date
1.    For what 12-month period are you reporting these data?

2.    Is the reporting period the last fiscal year? (Please Mark in Red to the Right ------>)                  YES                         NO

                                                                                                               Start Date                  End Date
2b.   If not, what is your annual fiscal year period (starting and ending months)?                             March                       May




3.    Please estimate the number of hours used to complete this workbook.                                                    (Hours)




                                                                                                                                                            Instructions
                                                                                         Source Codes - Adjustments and
                                                       Source Codes - Documented Data
Texas Christian University Treatment                                                     Estimates
                                                       MIS=Management Information
                                                                                         ADJ=Adjustment of Documented
Costs and Organizational Monitoring                    AFS=Audited Financial Statement
                                                                                         Data
          (TCOM) Project                               AR=Annual Report
                                                                                         IE=Internal Estimate
                                                       OD=Other Documentation
                                                                                         EE=External Estimate                       Parent Organization Level Data
                                                                                                                                               Page 2
                                                                                                                             Go to Overview Page

   Item                                                                                                                                                           Data Item
 Number       Data Item and Description                                                                   Data Entry                   Source Code       Comments/Reference


  1       Does your program operate under a parent organization?                         Yes                        NO                             N/A
       (Please Mark YES or NO in Red to the Right ------>)
          If "YES", please list the name of the parent organization/agency                                                                         N/A
          If "No" Please skip to Page 3. Program Level Data

  2       How many sibilings do you
          have? (how many other
          programs are under this
          parent organization?


  3       Total Costs of the Parent
          Treatment
          Facility/Organization
          ( including all child program
          costs)                                                                         $                          -

  4       Total Costs of the Parent
          Treatment
          Facility/Organization
          ( excluding all child program
          costs)

                                                                                         $                          -
  5       Estimated Proportion of All
          Parent Organization
          Resources Used by the
          Selected Outpatient
          Program
                                                                                                                        0%
  6       Calculated Parent
          Organization Costs
          Allocated to Program (NO
          DATA ENTRY)                                                                    $                          -


  7       Total Costs of the Identified
          Treatment Program for Cost
          Analysis                                                                       $                          -


   8      Calculated Proportion of All
          Parent Organization
          Resources Used by the
          Selected OP Program                                                                       #DIV/0!




                                                                                                                                                                         PhaseII-1
                                         Source Codes - Documented Data    Source Codes - Adjustments and
Texas Christian University Treatment     MIS=Management Information        Estimates
Costs and Organizational Monitoring      AFS=Audited Financial Statement   ADJ=Adjustment of Documented Data
          (TCOM) Project                 AR=Annual Report                  IE=Internal Estimate
                                         OD=Other Documentation            EE=External Estimate                              Program Level Data
                                                                                                                                   Page 3
                                                                                                                   Go to Overview Page

  Item                                                                                                                                            Data Item
Number      Data Item and Description                                                           Data Entry            Source Code        Comments/Reference

  1      Program Name (NO DATA ENTRY)                                                                          0

  2      Point Prevalence                                                                                      0

  3      Annual Admission Count                                                                                0

  4      Annual Discharge/Inactive Count                                                                       0

  5      Average Length of Stay (Days)                                                                         0

  6      Client Capacity (Number of TXT Slots)                                                                 0

  7      Total Costs                                                                                      $0

  8      Total Revenues                                                                                   $0

  9      Individual Counseling                                                                                 0
         Sessions per Client per Week

 10      Group Counseling Sessions:
         (Average Number of Clients in Attendance)
         Group Therapy Sessions                                                                                0
         Group Educational Sessions                                                                            0
         Self-help Group Meetings                                                                              0
         Community or Governing Meetings                                                                       0
         Other:                                                                                                0

 11      Group Sessions per Client
         per Week                                                                                              0

 12      Average Group Session Length (Tenths of Hours)                                                  0.00

 13      Average number of
         counselors per group
         session                                                                                               0




                                                                                                                                                       PhaseII-1
Texas Christian University    Source Codes - Documented Data    Source Codes - Adjustments and
  Treatment Costs and         MIS=Management Information        Estimates
                              AFS=Audited Financial Statement   ADJ=Adjustment of Documented Data
Organizational Monitoring     AR=Annual Report                  IE=Internal Estimate
     (TCOM) Project           OD=Other Documentation            EE=External Estimate                           Fulltime (FTE) Personnel Costs
                                                                                                                           Page 4
                                                                                                       Go to Overview Page
    Item      Data Item and
  Number        Description                                                         Data Entry        Source Code            Data Item Comments/Reference


   13      Full Time Staff:                                                   Number of FTEs
           a. Physicians                                                                   0
           b. R N                                                                          0
           c. Other Medical                                                                0
           d. Phd Counselors                                                               0
           e. Master Counselors                                                            0
           f. Bachelor Counselors                                                          0
           g. Non Degreed Counselors                                                       0
           h. Senior Management Staff                                                      0
           I. Clinical Management Staff                                                    0
           j. Support Staff                                                                0
           k. Volunteers                                                                   0

                                                                      Average Hrly Rate
           a. Physicians                                        $                            -
           b. R N                                               $                            -
           c. Other Medical                                     $                            -
           d. Phd Counselors                                    $                            -
           e. Master Counselors                                 $                            -
           f. Bachelor Counselors                               $                            -
           g. Non Degreed Counselors                            $                            -
           h. Senior Management Staff                           $                            -
           I. Clinical Management Staff                         $                            -
           j. Support Staff                                     $                            -
           k. Volunteers                                        $                            -

                                                      Average Number of Hours Worked Per Week
           a. Physicians                                                              0
           b. R N                                                                     0
           c. Other Medical                                                           0
           d. Phd Counselors                                                          0
           e. Master Counselors                                                       0
           f. Bachelor Counselors                                                     0
           g. Non Degreed Counselors                                                  0
           h. Senior Management Staff                                                 0
           I. Clinical Management Staff                                               0
           j. Support Staff                                                           0
           k. Volunteers                                                              0



           FTE Fringe Benefit Rate                                                               0%




                                                                                                                                                     PhaseII-2
   Texas Christian University       Source Codes - Documented Data    Source Codes - Adjustments and
      Treatment Costs and           MIS=Management Information        Estimates
                                    AFS=Audited Financial Statement   ADJ=Adjustment of Documented Data
Organizational Monitoring (TCOM)    AR=Annual Report                  IE=Internal Estimate                  Parttime (PTE) and Contract Staff
             Project                OD=Other Documentation            EE=External Estimate                          Personnel Costs
                                                                                                                         Page 5
                                                                                                          Go to Overview Page
   Item             Data Item and                                                                                                         Data Item
 Number               Description                                                          Data Entry        Source Code        Comments/Reference


   14     Part-time & Contract Staff                                  Number of PTEs and Contract Staff
          a. Physicians                                                                         0
          b. R N                                                                                0
          c. Other Medical                                                                      0
          d. Phd Counselors                                                                     0
          e. Master Counselors                                                                  0
          f. Bachelor Counselors                                                                0
          g. Non Degreed Counselors                                                             0
          h. Senior Management Staff                                                            0
          I. Clinical Management Staff                                                          0
          j. Support Staff                                                                      0
          k. Volunteers                                                                         0

                                                                             Average Hourly Rate
          a. Physicians                                                $                       -
          b. R N                                                       $                       -
          c. Other Medical                                             $                       -
          d. Phd Counselors                                            $                       -
          e. Master Counselors                                         $                       -
          f. Bachelor Counselors                                       $                       -
          g. Non Degreed Counselors                                    $                       -
          h. Senior Management Staff                                   $                       -
          I. Clinical Management Staff                                 $                       -
          j. Support Staff                                             $                       -
          k. Volunteers                                                $                       -


                                                               Average Number of Hours Worked Per Week
          a. Physicians                                                                        0
          b. R N                                                                               0
          c. Other Medical                                                                     0
          d. Phd Counselors                                                                    0
          e. Master Counselors                                                                 0
          f. Bachelor Counselors                                                               0
          g. Non Degreed Counselors                                                            0
          h. Senior Management Staff                                                           0
          I. Clinical Management Staff                                                         0
          j. Support Staff                                                                     0
          k. Volunteers                                                                        0

          PTE and Contract Staff
          Fringe Rate                                                                                0%




                                                                                                                                               PhaseII-3
Texas Christian University Treatment
Costs and Organizational Monitoring
          (TCOM) Project



                                    What was the cost of the miscella

 Non-Personnel Capital Resources



                         Data Item and
Item Number                Description

    1         Computer System 1


    2         Computer System 2

    3         Computer System 3

    4         Computer System 4


    5         Facilities/Buildings #1

    6         Facilities/Buildings #2

    7         Other Capital Resource
  8      Total Non-Personnel Capital Resources


Other Non-Personnel Resources




  9      Administrative Items

 10      Dietary

 11      Housekeeping and Laundry

 12      Medical Care

 13      Laboratory

 14      Client Transportation

 15      Rent and Interest

 16      Taxes



         Total Annual Non-
         Personnel Non-Capital
 17      Costs (NO DATA ENTRY)
     Combined Total for
     Capital, Other Non-
     Personnel Purchased,
18   and Donated Items


     Proportion of Non-
     Personnel Costs to Total
19   Costs
                                      Source Codes - Adjustments and
    Source Codes - Documented Data
                                      Estimates
    MIS=Management Information
                                      ADJ=Adjustment of Documented
    AFS=Audited Financial Statement
                                      Data
    AR=Annual Report
                                      IE=Internal Estimate
    OD=Other Documentation
                                      EE=External Estimate




What was the cost of the miscellaneous items listed below that were u




                                      Expected Life Years of
         Amortization Rate            Capital Item

                  3%                                 0


                  3%                                 0

                  3%                                 0

                  3%                                 0


                  3%                                 0

                  3%                                 0

                  3%                                 0
nel Capital Resources




                              Data Entry #1 -
                            Purchased Amount

                        $                   -

                        $                   -

 Laundry                $                   -

                        $                   -

                        $                   -

                        $                   -

                        $                   -

                        $                   -




                        $                   -
$             -




    #DIV/0!
isted below that were used by the treatment program during the fiscal ye




       Amount        Capital
       Paid for     Resource
       the Item     Allocation    Annualized Cost

       $     -             100%                 $0.00


       $     -             100%                 $0.00

       $     -             100%                 $0.00

       $     -             100%                 $0.00


       $     -             100%                 $0.00

       $     -             100%                 $0.00

       $     -             100%                 $0.00
                  $0.00




Data Entry #2 -
   Donated
 Market Value

$          -

$          -

$          -

$          -

$          -

$          -

$          -

$          -




$          -
                       Non-Personnel Costs
                             Page 6
          Go to Overview Page

ing the fiscal year?

                                          Data Item
         Source Code             Comments/Reference
                                                                       Source Codes - Adjustments and
Texas Christian University    Source Codes - Documented Data
                                                                       Estimates
                              MIS=Management Information
  Treatment Costs and                                                  ADJ=Adjustment of Documented
                              AFS=Audited Financial Statement
Organizational Monitoring                                              Data                   IE=Internal
                              AR=Annual Report
     (TCOM) Project                                                    Estimate             EE=External
                              OD=Other Documentation
                                                                       Estimate
                                                                                                                                                      Unit Cost Analysis
                                                                                                                                Page 7 - For Data Analysis and Review Only (NO DATA ENTRY)
                                                                                                            Go to Overview Page

    1. Client Volume -                                                                                                                                                              Data Analysis
      Analysis Data:                         Data Analysis Items                           Source Code                  2. Financial / Costs & Revenues - Analysis Data                    Items        Source Code

A. Client Count - Beginning                                       0                                     0   A. Total Costs                                                         $             -


B. Admissions                                                     0                                     0   B. Total Revenues                                                      $             -

                                                                                                                                                                                                     Expected Range
C.Discharges                                                      0                                     0   Financial Difference Variable                                              #DIV/0!       Public         <.20
                                                                                                                                                                                                     Private        <.50
                                                                                                                                                                                                     Non-Profit     <.20
D. Average Length of
Stay (Days)                                                       0                                     0
                                                                                                            3. Unadjusted Cost Per Episode and Cost Per Enrolled Patient Day
E. Average Client Count:(Calc)                                                                                (All items calculated)
 1. Admission Derivative                    #DIV/0!
 2. Discharge Derivative                    #DIV/0!                                                         A.1. Cost per Episode based on Admissions                                  #DIV/0!
 3. Point Prevalence -
Reported                                                        0.00                                           2. Cost Per Enrolled Patient Day - based on Admissions                  #DIV/0!

F. Client Capacity                                                0                                     0   B.1. Cost Per Episode based on Discharges                                  #DIV/0!
                                                                                                              2. Cost Per Enrolled Patient Day based on Discharges                     #DIV/0!
G. Occupancy Rates:(Calc)                                              Expected Range
 1. Admission Based                         #DIV/0!                    70-100%                              C.1. Cost Per Episode based on Point Prevalence and Average Length of Stay #DIV/0!
 2. Discharged Based                        #DIV/0!                    70-100%                                2. Cost Per Enrolled Patient Day based on Point Prevalence and ALOS      #DIV/0!
 3. Point Prevalence Based                  #DIV/0!                    70-100%
                                                                                                                                                                                                     Expected Range
H. Client Var.: Admiss. vs.
Pt. Prev.                                   #DIV/0!                    <.25                                 D. Cost Per Episode Difference: Admit Based vs. Point Prevalence           #DIV/0!       <.20
I. Client Var.: Disch. vs.
Pt. Prev.                                   #DIV/0!                    <.25
                                                                                                            E. Cost Per Episode Difference: Discharge Based vs. Point Prevalence       #DIV/0!       <.20

                                                                                                            F. Cost Per Episode Difference: Admit Based vs. Discharge Based            #DIV/0!       <.20




                                                                                                                                                                                                                      Analysis Page 1
                                                                       Source Codes - Adjustments
 Texas Christian University      Source Codes - Documented Data
                                                                       and Estimates
                                 MIS=Management Information
   Treatment Costs and                                                 ADJ=Adjustment of
                                 AFS=Audited Financial Statement
 Organizational Monitoring                                             Documented Data
                                 AR=Annual Report
                                                                       IE=Internal Estimate
      (TCOM) Project             OD=Other Documentation
                                                                       EE=External Estimate
                                                                                                                           Salary/Wage Analysis
                                                                                                     Page 8 - For Data Analysis and Review Only                               (NO
                                                                                                                               DATA ENTRY)
                                                                                                    Go to Overview Page
Salary Wage Analysis :
                                                                                                                                 Source                      Source
                                 FTE's                                           Source Code                 Hrly Rate            Code    Hours/Wk            Code     Annual Salaries
Full Time Staff
a. Physicians                                                      0                           0    $                     -           0                  0         0   $        -
b. R N                                                             0                           0    $                     -           0                  0         0   $        -
c. Other Medical                                                   0                           0    $                     -           0                  0         0   $        -
d. Phd Counselors                                                  0                           0    $                     -           0                  0         0   $        -
e. Master Counselors                                               0                           0    $                     -           0                  0         0   $        -
f. Bachelor Counselors                                             0                           0    $                     -           0                  0         0   $        -
g. Non Degreed Counselors                                          0                           0    $                     -           0                  0         0   $        -
h. Senior Management Staff                                         0                           0    $                     -           0                  0         0   $        -
I. Clinical Management Staff                                       0                           0    $                     -           0                  0         0   $        -
j. Support Staff                                                   0                           0    $                     -           0                  0         0   $        -
k. Volunteers                                                      0                           0    $                     -           0                  0         0   $        -
Total Salaries FTE                                                                                                                                                     $        -

                                 Number                                           SC                         Hrly Rate           SC       Hours/Wk            SC       Annual Salaries
Part time & Contract Staff
a. Physicians                                                      0                           0    $                     -           0                  0         0   $        -
b. R N                                                             0                           0    $                     -           0                  0         0   $        -
c. Other Medical                                                   0                           0    $                     -           0                  0         0   $        -
d. Phd Counselors                                                  0                           0    $                     -           0                  0         0   $        -
e. Master Counselors                                               0                           0    $                     -           0                  0         0   $        -
f. Bachelor Counselors                                             0                           0    $                     -           0                  0         0   $        -
g. Non Degreed Counselors                                          0                           0    $                     -           0                  0         0   $        -
h. Senior Management Staff                                         0                           0    $                     -           0                  0         0   $        -
I. Clinical Management Staff                                       0                           0    $                     -           0                  0         0   $        -
j. Support Staff                                                   0                           0    $                     -           0                  0         0   $        -
k. Volunteers                                                      0                           0    $                     -           0                  0         0   $        -
Total Salaries PTE                                                                                                                                                     $        -

Totals-FTE and PTE Combined - Salaries Only                                                                                                                            $        -
FTE Fringe Benefits                                                                                                       0.0%        0                                $        -
PTE and Contract Staff Fringe Benefits                                                                                    0.0%        0                                $        -
Total Personnel Services Costs                                                                                                                                         $        -
Added Economic Cost of Volunteers                                                                                                                                      $        -        Expected Range
Current Total Costs:                                                                                                                                                   $        -



6. Per Cent of Personnel Services to Total Costs:                                                                                             Salaries                     #DIV/0!                70-90%

 1. Ratio of Counselors / Total Personnel Services                                                                                        $         -                      #DIV/0!                >60%

 2. Ratio of Medical /Total Personnel Services                                                                                            $         -                      #DIV/0!                <10%

 3.Ratio of Admin/Total Personnel Services                                                                                                $         -                      #DIV/0!                15-30%

 4. Direct Care to Total Labor                                                                                                            $         -                      #DIV/0!                70-85%




                                                                                                                                                                                                   Analysis Page 3
                                                                          Source Codes -              Source Codes -
                                                                          Documented Data             Adjustments and
    Texas Christian University Treatment Costs and                        MIS=Management              Estimates
                                                                          Information AFS=Audited     ADJ=Adjustment of
      Organizational Monitoring (TCOM) Project
                                                                          Financial Statement         Documented Data
                                                                          AR=Annual Report            IE=Internal Estimate
                                                                          OD=Other Documentation      EE=External Estimate           Counseling Services Analysis -
                                                                                                                                                Page 9
                                                                                                                              Go to Overview Page
5. Counseling Services & Costs

Professional Staff                                      0.00                                     0
All Counselors                                          0.00                                     0
( Based 1880 Net Hour basis-40 hr/wk)                 (fte's)                                  (yrly hrs)
(for 35 hour week use -1645 net hrs)
c. Individual Counseling Sessions/Wk                        0        0                            0                                   0                0
                                               (sessions)                 (admits)                                             (alos-wks)       (ind couns. hrs)

d. Group Counseling Sessions:                         Actual              Attendance                                          Adjusted         Weighted
                                                     Attends                      Weight                                       Weight         Attendance
    Group Therapy Sessions                                 0                                  70%                                  0%                 0
    Group Educational Sessions                             0                                  10%                                  0%                 0
    Self-help Group Meetings                               0                                  10%                                  0%                 0
    Community or Governing                                 0                                   5%                                  0%                 0
    Other: Family                                          0                                   5%                                  0%                 0
       TOTAL                                               0                                 100%                                  0%                 0

Counselor Requirement - Groups                    #DIV/0!                          #DIV/0!                                     #DIV/0!
(Based on Avg Client Count-Admits)                                        (Avg Attend)                                       (Couns Gps)
No. Weekly Sessions/Client                                  0
Counselor Group Counseling Hours                  #DIV/0!            PO                           0                                  50         #DIV/0!
                                               (sessions)                                    (length in hrs)                   (wks/yr)         (gp couns. hrs)


e.1. Total Counseling Hours:                                                                                                   #DIV/0!
                                                                                                                                                                   Outpatient
                                                                                                                                                                   Non-
 e.2. PerCent of Available Hours (All Counselors)                                                                              #DIV/0!                             Methadone
e.3. Percent of Professional Staff Hours (Phd, Masters, Bachelors)                                                             #DIV/0!
e4. Cost Per Counseling Hour                                                                                                   #DIV/0!                             60-80%
e5. Cost Per Group Counseling Hour Per Client                                                                                  #DIV/0!                             60-80%




                                                                                                                                                                                Analysis Page 4
   Texas Christian University     Source Codes - Documented Data
                                  MIS=Management Information
     Treatment Costs and
                                  AFS=Audited Financial Statement
   Organizational Monitoring      AR=Annual Report
        (TCOM) Project            OD=Other Documentation




Program Name                                                            0

                                  Data Items

Total Costs of the Parent
Treatment Facility/Organization
Costs (including all sibling
costs)
                                                                    -
Total Costs of the Identified
Treatment Program for Cost
Analysis
                                                                        0

Total Personnel Services Costs
                                   $                                -

Combined Total for Capital,
Other Non-Personnel
Purchased, and Donated Items
                                   $                                -
Source Codes - Adjustments
and Estimates
ADJ=Adjustment of
Documented Data
IE=Internal Estimate
EE=External Estimate         Salary/Wage Analysis   Page 10 - Program Summary
                                                         DATA ENTRY)
                             Go to Overview Page


Proportion of Costs to
Total Costs




                    100%


         #DIV/0!


         #DIV/0!




         #DIV/0!
Summary   (NO
)
                       Percentage Distribution of Personnel Costs for
                       Outpatient Nonmethadone Treatment ADSS and
                         Selected Outpatient Program for Analysis


             80%
                      71%
             70%

             60%

             50%
Percentage




                                                                          ADSS
             40%
                                                                          Program
             30%
                                                            23%
             20%

             10%                         6%
                            0%                  0%                 0%
             0%
                   Counseling Staff     Medical Staff       Other Staff
                                        Type of Staff
             Average Program Costs: Adjusted ADSS and Program Data

         $100.00                            $93.03


          $80.00


          $60.00
Amount




                                                                                     ADSS
                                                                                     Program
          $40.00


          $20.00
                      $11.28                                       $9.71
                               $-                    $-                    $-
             $-
                   Cost Per Enrollment   Cost Per Individual     Cost Per Group
                          Day             Counseling Hour      Counseling Hour Per
                                                                     Client

                                             Unit Cost
                         Mean Hourly Personnel Rates, by Full-Time Staffing Category

                $70.00
                                                                                                          ADSS (Adjusted)
                           $61.60
                $60.00
                                                                                                          Program

                $50.00
Hourly Salary




                $40.00
                                                                   $33.26

                $30.00
                                         $22.34
                                                                                $20.23
                $20.00                                                                        $16.89
                                                      $16.10
                                                                                                                       $14.37
                                                                                                           $12.93

                $10.00

                                 $-           $-           $-           $-           $-            $-            $-          $-
                   $-
                           Physicians   Reg. Nurses     Other      Doctoral      Masters      Bachelors    NonDegreed Admin./Other

                                        Medical                                           Counselors
                                                               Personnel Type
Appendix A. Data Sources Codes

Description . In order to track each item obtained for the cost analysis, each data item in th
to associate the data item collected with a source locator. Futhermore, there is an "data it
of the need to make notes on a specific item.

This link will take you to a sample source code data entry point on Page 3 for the da

Data Source Codes Include the Following:
I. Documented Data - Data Identified in Program Documentation from Various Possi


        Source Code               Source Definition
        MIS                       Management Information System or Database
        AFS                       Audited Financial Statement
        AR                        Annual Report
        OD                        Other Documentation (I.e.Monthly Internal Reports)

II. Adjustments and Estimations - Data Based on Adjustments to Documented Data

        Source Code               Source Definition
        ADJ                       Adjustment of Documented Data
        IE                        Internal Estimate
        EE                        External Estimate
                                 Go to Overview Page

 lysis, each data item in the workbook has a corresponding source code
rmore, there is an "data item comments/reference" column in case


oint on Page 3 for the data item "Point Prevalence".



 ion from Various Possible Sources


                         Explanation
 m or Database           Data obtained via computer. (E.g. Database queries, auto reports, etc.)
                         Data obtained from existing audited financial statements
                         Data obtained from the facilities' or program's annual report
hly Internal Reports)    Data obtained from other documents (including internal reports)

ts to Documented Data or Estimated Using Internal or External Data

                         Explanation
                         Data adjusted from any of the above documentation sources
                         Data estimated based on knowledge of other requested data items
                         Data estimated based on knowledge of the substance abuse treatment fie
eries, auto reports, etc.)

nnual report
internal reports)




ation sources
quested data items
stance abuse treatment field
                                            ADSS             Program
Counseling Staff                                       71%         #DIV/0!
Medical Staff                                           6%         #DIV/0!
Other Staff                                            23%         #DIV/0!       ADSS Adjustment

                                            ADSS             Program
Cost Per Enrollment Day                      $       11.28         #DIV/0!             97
Cost Per Individual Counseling Hour          $       93.03         #DIV/0!             98
Cost Per Group Counseling Hour Per Client    $        9.71         #DIV/0!             99
                                                                                        0
                                                                                        1
                                                                                        2
                                                                                        3
                                                                                        4

                                            ADSS (Adjusted) Program
Physicians                                   $        61.60 $                -
Reg. Nurses                                  $        22.34 $                -
Other                                        $        16.10 $                -
Doctoral                                     $        33.26 $                -
Masters                                      $        20.23 $                -
Bachelors                                    $        16.89 $                -
NonDegreed                                   $        12.93 $                -
Admin./Other                                 $        14.37 $                -
ADSS Adjustment

                      1.03
              12.04
           12.4012
          12.77324
          13.15643
          13.55113
          13.95766
          14.37639
          14.80768

								
To top