|Title||GeoConnections geospatial return on investment case study: PRISM-GIS and PRISM-911|
|Author||Stewart, M A|
|Source||Canadian Geospatial Data Infrastructure, Information Product 14, 2010, 25 pages, https://doi.org/10.4095/288862 (Open Access)|
|Links||Quinte West, PRISM Program|
|Publisher||Natural Resources Canada|
|NTS||31C/03NW; 31C/04; 31C/05SE; 31C/06SW; 40P/04; 40P/05; 40P/11; 40P/12; 40P/13; 40P/14; 41A/04|
|Area||Huron; Quinte West; Goderich; Frankford; Trenton; Bay of Quinte|
|Lat/Long WENS|| -77.7500 -77.4167 44.3167 44.0000|
|Lat/Long WENS|| -81.7500 -81.0000 44.2500 43.2500|
|Subjects||mathematical and computational geology; geographic information system|
|Released||2010 01 01|
|Abstract||In late 2009 GeoConnections commissioned a Geospatial Return on Investment Case Study to add to the body of knowledge of case studies based on the GITA ROI methodology for financial analysis of
geospatial projects. The study focuses on the PRISM-GIS and PRISM-911 applications developed by the City of Quinte West in Southern Ontario. PRISM-GIS, launched in 2007, assists First Responders during emergency situations in the field and at the
Central Command Centre and facilitates communication between the field and the Command Centre. PRISM-911, launched in 2008, provides emergency notification by telephone.|
Backward-looking five-year analysis of Quinte West PRISM: Total investment
has been $130,757 (2006 $CA). Cumulative benefits are $405,972 (2006 $CA). Net Present Value is $275,215 (2006 $CA), with an annualized Return on Investment of 42.1%. Breakeven point was reached in 2008, two years into the project. The greatest
tangible benefit is lowered risk to public health. Considerable benefits were also found from efficiencies in transferring manual notification to automated notification.
Forward-looking 15-year analysis of Quinte West PRISM: Cumulative benefits
are $3.5M. Net Present Value is $3.1M with an annualized Return on Investment of 54.33%. Payback period is under one year as a result of startup costs being externalized into the backward-looking study. This high rate of return and short payback
period reflects the dramatic benefits realized through leveraging the initial work done by the City of Quinte West.
Sensitivity analysis: A combined 19-year analysis of Quinte West PRISM showed Net Present Value of $3.109M. ROI is 31.66%.
Sensitivity analysis was also performed on the combined 19-year business case showing only benefits to the City of Quinte West, by removing public benefits. Net Present Value to the city alone is $1.261M, with an ROI of 12.84%.
Huron County is
Quinte West's first external client for PRISM. Huron recently leased PRISM from the City of Quinte West, launching it in November 2009.
Forward-looking 16-year analysis of Huron County PRISM: Cumulative benefits are $4,154,920 with a Net Present
Value of $3,503,431 and an annualized Return on Investment of 33.61%. Payback period is one year. Huron County's Net Present Value is approximately $400,000 higher than the Quinte West combined study NPV, predominantly a result of greater public
benefits from automated notification of Boil Water Advisories. A province-wide analysis illustrates potential costs and benefits if 50 municipalities, counties or regions adopt the system. Cumulative benefits are $163M over the 15-year analysis. Net
Present Value is $132M with an annualized Return on Investment of 28.52%. Payback period is
Sensitivity analysis was performed to show the effect of slow ramp-up of 50 agency implementations of PRISM over the lifetime of the analysis.
This forward-looking 15-year analysis showed Net Present Value of $79.3M. ROI for the ramped study is 26.03%. Cumulative benefits for the ramped study are $100M.