HomeMy Public PortalAboutExhibit MSD 86C - Summary Schedule of Adjustments to SW CIRP Projections RevisedSummary Schedule of Adjustments to SW CIRP Projections ‐ Revised ‐ 4/8/201520172018201920202021202220232024TotalEngineering Numbers16,370,200$ 10,422,000$ 16,112,000$ 6,999,000$ 4,235,000$ 3,980,000$ 1,525,000$ ‐$59,643,200$ 1Inflation Rates (2.5% ‐ 2016 Base Cost)102.50% 105.06% 107.69% 110.38% 113.14% 115.97% 118.87% 121.84%Inflated Values16,779,455$ 10,949,614$ 17,350,862$ 7,725,586$ 4,791,514$ 4,615,580$ 1,812,746$ ‐$64,025,356$ % Change from Engineering Numbers 2.5% 5.1% 7.7% 10.4% 13.1% 16.0% 18.9% N/A 7.3%2Appropriation Delay (86%/14%)16,769,801$ 11,765,792$ 16,454,687$ 9,073,125$ 5,202,284$ 4,640,211$ 2,205,143$ 253,784$ 66,364,826$ % Change from Inflated Numbers‐0.1% 7.5%‐5.2% 17.4% 8.6% 0.5% 21.6% N/A 3.7%Example:$16,779,455 x 14% + $10,949,614 x 84% = $11,765,7923Liquidation (8% ‐ 3 years delayed)16,441,451$ 11,188,194$ 15,219,224$ 7,731,541$ 4,261,021$ 3,323,836$ 1,479,293$ (162,398)$ 59,482,161$ % Change from Appropriation Delay Numbers‐2.0%‐4.9%‐7.5%‐14.8%‐18.1%‐28.4%‐32.9%‐164.0%‐10.4%Example:$9,073,125 ‐ 8% x $16,769,801 = $7,731,541Infrastructure Repair2,000,000$ 3,000,000$ 3,000,000$ 3,000,000$ ‐$‐$‐$‐$11,000,000$ Adjusted Total18,441,451$ 14,188,194$ 18,219,224$ 10,731,541$ 4,261,021$ 3,323,836$ 1,479,293$ (162,398)$ 70,482,161$ 10.0%20.6%10.7%18.3%‐18.1%‐28.4%‐32.9%‐164.0%6.2%Net Change from Original2,071,251$ 3,766,194$ 2,107,224$ 3,732,541$ 26,021$ (656,164)$ (45,707)$ (162,398)$ 10,838,961$ % Change from Engineering Numbers12.7%36.1%13.1%53.3%0.6%‐16.5%‐3.0%N/A18.2%Assumption Notes:1 Inflation rates were taken from the St. Louis index published by the Engineering News‐Record. An average rate for the 12‐months ended September 30, 2014 according to this index was 2.5%.2The key performance measure, construction budget performance, from the FY14 and FY15 budget books showed 84% and 88%, respectively.3A sample of over 250 completed projects of various types and sizes were analyzed, and the overall liquidation percentage from that sample was 8%.Exhibit MSD 86C