jr ., principal health care information consultants llc slides ► presentations calculating present value B u s i n e s s F i n a n c e

Assigned Reading

1. Example of a traditional cost evaluation for a pharmacy system. Read► Slides► Calculations►
2. Elusive benefits of electronic health records Read► Slides►
3. Activity based costing of electronic health records Read► Slides► Listen► WMV► You Tube 1►You Tube 2► You Tube 3►
4. Causal analysis of business value of IT Read► Slides► Slides 2003► Listen► SWF►
5. Presentation by James L. Oakes, Jr., Principal Health Care Information Consultants LLC Slides►

Presentations

1. Calculating present value from future returns Slides► You Tube►
2. Example of a bottom up evaluation of cost of EHR Excel►
3. Current approaches, by Yumn Abduljawad Listen►
4. How to calculate correlations? Listen►
5. Scatter plot in Excel You Tube►

Do One Assignment: ROI on an IT Project

Adult learners understand a topic best by doing it. It gives them both new skills and confidence in their ability to carryout the recommended procedures. In this project, you will estimate the relative value of VistA for the Veterans Administration. In order to make sure that the project can be done in a short time interval, no data collection is necessary. All needed data will be provided by the instructor in response to your queries. Use the approach proposed in the course to calculate the business value of the Vista information system to the Veterans Administration.

1. In August 20, 2007 we asked the Department of Veterans Affairs to provide us two pieces of information under the Freedom of Information Act. We asked them for the budget of the Office of Information in the last decade (this office was recently organized and the FOIA officer had to estimate what the budget of the office would have been prior to the re-organization). We also asked for the number of patient records in VistA database. On October 16th 2007 they provided us with the following information:
   

   Fiscal Year	Budget of Office of Information	Number of Records in VistA	VHA Cost per Patient Index
   2004	533,190,714	4,976,773	0.8%
   2003	316,467,395	4,806,871	-4.6%
   2002	245,998,730	4,545,559	-9.1%
   2001	187,087,714	4,088,075	-7.3%
   2000	171,353,392	3,673,612	-6.5%
   1999	203,211,123	3,425,474	-8.6%
   1998	199,997,062	3,273,020	-6.2%
   Table 2: Investment in IT, Use of VistA and Cost per Patient Index

1. Calculate the correlations between (a) index on cost of care per patient, (b) number of records in VistA system and the budget of the office of information.
2. Provide scatter diagram showing the relationship between IT investment (budget of Office of Information) and cost of care (VHA cost per Patient Index)? How►
3. What came first, IT investment or changes in cost of care? How►