Service Investment Analysis

Name of Tab: 1. Svc Pkg & Tx Cost  
     
Step What to Do Comment
1 Name your Service Package.  
2 List treatment modalities that can be a part of your Service Package.  
3 Describe the Unit of Service for each treatment modality. This should match the basis used in your organization's record keeping systems.
4 Enter the 12-month study period. This must be in YYYY format.
5 Enter the number of clients receiving the Service Package during the 12-month study period. Use an unduplicated count.  Count as a "client" those who never re-presented, and also those who tended to re-present.
6 Enter the Direct Cost for each treament modality in the Service Package. Enter the cost per Unit of Service.
7 Select your organization's Indirect Rate. Use the scroll bar to choose the Indirect Rate.
8 Override the Total Cost for any treatment modalities where applying the Indirect Rate may not be appropriate. Optional.
     
Name of Tab: 2. Avoided Svcs  
     
Step What to Do Comment
1 (Option I) Select pre-assembled, aggregate literature benchmarks. Select only one benchmark within each "benchmark domain".
2 (Option II) Construct a customized benchmark using other benchmarks and your agency's experience. Option II is for advanced users.  Refer to User Manual and training notes.
     
Name of Tab: 3. Modeling Assumptions  
     
Step What to Do Comment
1 Describe the disposition status of your clients after one year. Options are:
  (1) Completed Treatment during the year, and
  (2) Still Receiving Treatment by end of the year. 
All other client are considered to have Abandoned Treatment.
2 Estimate the disposition status for client Still Receiving Treatment in the second year, and any subsequent years. When finished, you should have estimated how a single year's "cohort" of clients persisted in treatment over time.
3 Project annual inflation for treatment costs. Default rate is based on recent medical care inflation.
4 Estimate opportunity cost of funding treatment. Return on capital had investors not invested in treatment capacity
5 Project annual inflation for cost of avoided services. Default rate is based on recent medical care inflation.
6 Estimate opportunity cost of funding avoidable services. Return on capital had investors not invested in capacity to deliver avoidable service
7 Activate Option I or Option II benchmark results. Be sure only one "Y" appears between the two Options.
     
Name of Tab: 4a. Ten Yr Chart and 4b. Five Yr Chart Display only; no data entry requirements.
     
Name of Tab: App A - Benchmarks  
     
Step What to Do Comment
1 Add benchmarks applicable to your client population. Using individual benchmarks is related to Option II (advanced users); refer to User Manual & training notes.
     
Name of Tab: App B - Unmeasured  
     
Step What to Do Comment
1 Describe in words costs you can not measure/quantify. These reasons may be overstating your results.
2 Describe in words benefits you can not measure/quantify. These reasons may be understating your results.
     
Name of Tab: App C - Inflation  
     
Step What to Do Comment
1 Update these factors annually using the links provided. Simple trending occurs in the absence of updating.
Back to top