#### Go to HealthTreks Home

Note: Going home clears all of these panels.

#### Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Get
TP120- 2007 Hip Replacement Treatment

#### Capital Budget NPV Calculator

Introduction
This tool calculates net present value totals for operating and capital budget uris. The discounted totals include operating, allocated overhead, capital, and incentive-adjusted totals. Annual totals reflect the cost for operations or components that have an effective life different than 1 period.

Calculation View Description
Sample health care treatment cost used in a tutorial. v171a

Version: 1.7.0

#### Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.

#### Step 1

• Step 1. Real and Nominal Rates: The nominal rate includes inflation while the real rate does not. In the USA, DevTreks recommends using Office of Management and Budget rates for the same year as the date of the input.

#### Step 2

• Step 2. Use Same Calculator Pack In Descendants?: True to insert or update this same calculator in children.
• Step 3. Overwrite Descendants?: True to insert or update all of the attributes of this same calculator in all children. False only updates children attributes that are controlled by the developer of this calculator (i.e. version, stylehsheet name, relatedcalculatorstype ...)
• Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
• Step 2. Related Calculators Type: When the Use Same Calculator Pack in Descendant is true, uses this value to determine which descendant calculator to update. Inserts a new descendant when no descendant has this same name. Updates the descendant that has this same name.
• Step 2. Alternative Type: This property is used to analyze differences between Alternatives.
• Step 2. Target Type: This property is used to analyze progress being achieved with budget goals.
• Step 2. Calculated Results: Please refer to the references below.

#### References

• Hallam, Eidman, Morehart and Klonsky (editors) Commodity Cost and Returns Estimation Handbook, Staff General Research Papers, Iowa State University, Department of Economics, 1999

Current view of document
DevTreks -social budgeting that improves lives and livelihoods
Investment Group : DRG469- Major Joint Replacement or Reattachment of Lower Extremity
Document Status : underrevision
Description : Sample data set used in a health care analysis tutorial.
Label : DRG469 Investment Type : 84
Date : 6/1/2013 12:00:00 AM Last Changed : 6/1/2013 12:00:00 AM
Investment :0SR9019- Example 1 Replace Hip Joint with Metal Syn Subs, Cem, Open
Label 1 Label 2 Last Modif. Init. Value Salv. Value Interest Rates Nom. Rate Real Rate
0SR9019 none 6/1/2013 12:00:00 AM 0.0000 0.0000
Description
Example 1 of a sample health care analysis used in a tutorial.
Time Period : Hip Replacement Treatment
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2007 True True 1 each 0 0
Time Period TP120- 2007 Hip Replacement Treatment Last Changed 6/1/2013 12:00:00 AM
Description
Sample data set used in a health care analysis tutorial.
Label none Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : 0SR9019- 2007 Replace Hip Joint with Metal Syn Subs, Cem, Open
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2007 0SR9019 1 none 1 0.0000 0.0000 0
Description
This health care treatment is used in a health care analysis tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : 2007 OSR9019P1- Patient-reported quality measures Label : OSR9019P1
1 1 each 1 each 0.0000 0.00
Description
Benefits are defined using ME indicators summarized from patient reported satisfaction surveys.
Interest 0.00
2014-09-25T00:00:00 Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.00
Output : 2007 OSR9019P2 -Physician-reported quality measures Label : OSR9019P2
1 1 each 1 each 0.0000 0.00
Description
Benefits are defined using ME indicators summarized from patient reported satisfaction surveys.
Interest 0.00
2014-09-25T00:00:00 Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.00
Benefit Interest - Outcome 0.00 0.00
Total Benefit - Outcome 0.00 0.00
Total Incentive-Adjusted Benefits - Outcome 0.00 0.00
Totals Annual Totals
Total Benefit -Time Period 0.00 0.00
Total Incentive Ben -Time Period 0.00 0.00
Costs
Component : 0SR9019- 2007 Replace Hip Joint with Metal Syn Subs, Cem, Open
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2007 0SR9019 1 each 1 0.0000 0.0000 0
Description
Standard hip replacement surgery for patient with no major preoperative conditions.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2007 OSR9019A1 -Overhead, Administrative Label : OSR9019A1
5/31/2007 12:00:00 AM 1 False 0 each 0.2800 0.00
Allocated OH 0 percent 0.0000 0.00
Capital 7810.28 each 0.2800 2,186.88
Incentive 0.0000 0 2,186.88
Description
The price reflects the standard decimal percentage charged for administrative expenses.
Input : 2007 OSR9019D1 Drugs, Anesthesia Label : OSR9019D1
5/31/2007 12:00:00 AM 1 False 0 each 165.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 165.0000 165.00
Incentive 0.0000 0 165.00
Description
Standard does of anesthesia delivered in routine surgery.
Input : 2007 OSR9019D1 Drugs, Drug 01 Label : OSR9019D1
5/31/2007 12:00:00 AM 1 False 0 day 171.0000 0.00
Allocated OH 0 day 0.0000 0.00
Capital 3.5 day 171.0000 598.50
Incentive 0.0000 0 598.50
Description
Routine pain relief drugs delivered daily after inpatient surgery.
Input : 2007 OSR9019L1 -Labor, Anesthetist Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 hour 152.5000 0.00
Allocated OH 0 hour 0.0000 0.00
Capital 2 hour 152.5000 305.00
Incentive 0.0000 0 305.00
Description
Labor during surgery.
Input : 2007 OSR9019L1 -Labor, Nurse Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 hour 55.0000 0.00
Allocated OH 0 hour 0.0000 0.00
Capital 3 hour 55.0000 165.00
Incentive 0.0000 0 165.00
Description
Labor during surgery.
Input : 2007 OSR9019L1 -Labor, Physician Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 hour 152.5000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 2 hour 152.5000 305.00
Incentive 0.0000 0 305.00
Description
Labor during surgery.
Input : 2007 OSR9019M1 -Materials, Hip Joint Metal Synthetic Substitute Label : OSR9019M1
5/31/2007 12:00:00 AM 1 False 0 each 880.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 880.0000 880.00
Incentive 0.0000 0 880.00
Description
Hip replacement surgery prosthetic.
Input : 2007 OSR9019M1 -Materials, Surgery Label : OSR9019M1
5/31/2007 12:00:00 AM 1 False 0 each 142.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 142.0000 142.00
Incentive 0.0000 0 142.00
Description
Standard materials associated with routine surgeries.
Input : 2007 OSR9019P1 -Profit Label : OSR9019P1
5/31/2007 12:00:00 AM 1 False 0 each 0.2100 0.00
Allocated OH 0 percent 0.0000 0.00
Capital 9997 each 0.2100 2,099.37
Incentive 0.0000 0 2,099.37
Description
The price reflects the standard decimal percentage charged for profits.
Input : 2007 OSR9019R1 -Room, Hospital Stay Label : OSR9019R1
5/31/2007 12:00:00 AM 1 False 0 day 1500.0000 0.00
Allocated OH 0 day 0.0000 0.00
Capital 3.5 day 1500.0000 5,250.00
Incentive 0.0000 0 5,250.00
Description
Standard room rate for post operative stays with no major complications.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 12,096.75 12,096.75
Total Incentive-Adjusted Costs - Component 12,096.75 12,096.75
Component : 0SR9019a- 2007 Orthopedic Evaluation
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2007 0SR9019a 1 each 1 0.0000 0.0000 0
Description
Standard orthopedic evaluation for hip replacement surgery.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2007 OSR9019L1 -Orthopedic Doctor Visit Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 each 150.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 2 each 150.0000 300.00
Incentive 0.0000 0 300.00
Description
Standard evaluation visit to an orthopedic doctor.
Input : 2007 OSR9019M1 -Materials, General Label : OSR9019M1
5/31/2007 12:00:00 AM 1 False 0 each 10.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 10.0000 10.00
Incentive 0.0000 0 10.00
Description
Standard materials associated with routine doctor visits.
Input : 2007 OSR9019T1 -Laboratory Fees Label : OSR9019T1
5/31/2007 12:00:00 AM 1 False 0 each 10.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 10.0000 10.00
Incentive 0.0000 0 10.00
Description
Standard fees associated with processing laboratory paper work.
Input : 2007 OSR9019T1 -Tests, X-Rays Label : OSR9019T1
5/31/2007 12:00:00 AM 1 False 0 each 120.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 120.0000 120.00
Incentive 0.0000 0 120.00
Description
Standard set of x-rays for common procedures.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 440.00 440.00
Total Incentive-Adjusted Costs - Component 440.00 440.00
Component : 0SR9019b- 2007 Hip Replacement Home Recovery
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2007 0SR9019b 1 each 1 0.0000 0.0000 0
Description
Standard hip replacement surgery home recovery for patient with no major complications.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2007 OSR9019D1 Drugs, Pain Relief Drug 01 Label : OSR9019D1
5/31/2007 12:00:00 AM 1 False 0 each 5.7500 0.00
Allocated OH 0 each 0.0000 0.00
Capital 100 each 5.7500 575.00
Incentive 0.0000 0 575.00
Description
Standard pain relief pills used in post operative care.
Input : 2007 OSR9019H1 -Household, Hip Replace Improvements Label : OSR9019H1
5/31/2007 12:00:00 AM 1 False 0 each 300.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 1 each 300.0000 300.00
Incentive 0.0000 0 300.00
Description
Standard household improvements made after hip replacement surgery.
Input : 2007 OSR9019H1 -Transportation, Taxi Label : OSR9019H1
5/31/2007 12:00:00 AM 1 False 0 mile 1.2500 0.00
Allocated OH 0 mile 0.0000 0.00
Capital 400 mile 1.2500 500.00
Incentive 0.0000 0 500.00
Description
Standard taxi hourly charges.
Input : 2007 OSR9019L1 -Labor, Nurse Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 hour 55.0000 0.00
Allocated OH 0 hour 0.0000 0.00
Capital 2 hour 55.0000 110.00
Incentive 0.0000 0 110.00
Description
Labor during surgery.
Input : 2007 OSR9019L1 -Orthopedic Doctor Visit Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 each 150.0000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 4 each 150.0000 600.00
Incentive 0.0000 0 600.00
Description
Standard evaluation visit to an orthopedic doctor.
Input : 2007 OSR9019L1 -Physical Therapy Visits Label : OSR9019L1
5/31/2007 12:00:00 AM 1 False 0 each 152.5000 0.00
Allocated OH 0 each 0.0000 0.00
Capital 4 each 152.5000 610.00
Incentive 0.0000 0 610.00
Description
Standard physical therapy visits after surgery.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 2,695.00 2,695.00
Total Incentive-Adjusted Costs - Component 2,695.00 2,695.00
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 0.00 0.00
Allocated Overhead Costs (AOH)
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 0.00 0.00
Capital Costs (CAP)
Total Capital Costs -Time Period 15,231.75 15,231.75
Net Returns -Time Period -15,231.75 -15,231.75
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 15,231.75 15,231.75
Net Incentive Returns -Time Period -15,231.75 -15,231.75
Sample data set used in a health care analysis tutorial.

Uploading a new file will replace any existing file. If necessary, please package and download the existing file prior to this action. If the file has been uploaded successfully, this page will refresh and show the new file information. If the file can't be uploaded (i.e. exceeds 60MB, unsupported mimetype, bad xml, bad html) this page will refresh and show the existing file information.

The file has been uploaded.