county of peterborough asset management capital plan and ... · county of peterborough asset...
TRANSCRIPT
-
1
County Of PeterboroughAsset Management
Capital Plan and Financial StrategyJanuary 16, 2019
-
2
Introductions
• Peterborough County– Trena DeBruijn (Director of Finance/Treasurer)– Dan Sutherland (Asset Management Analyst)– Doug Saccoccia (Assistant Manager, Engineering & Design)
• Consultants– David Munford (BASc Civil Engineering)– Ron Awde (Architect)– Tammy Carruthers (CEO, WSCS Consulting, BA CPA, CGA CFE
CICA PMP CLSSBB CCA MCITP CISA)
-
3
Meeting Objectives
• Asset Management Policy and Plan Project (AMPP)– Current status and upcoming activities
• Needs Analysis and Options, by Asset Type• Financial Analysis• Next Steps
-
4
AMPP Project Status
Phase % done Target Date Notes
Strategic Policy 95% 30-Jan-19 Draft policy completed
System Setup/Config 100%
Data collection/QA 100%
Needs Analysis 100%
Financial Analysis 100%
Council Orientation 100%
Council Consultation 0% 16-Jan-19
Council Approval 0% 6-Feb-19
AMP Document 7% 30-Jan-19
Current Status & Upcoming Activities
Project 1
To-do list
To be completed by:Name
Deadline:Date
Project 1
Column1Phase% doneTarget DateNotes
Strategic Policy95%30-Jan-19Draft policy completed
System Setup/Config100%
Data collection/QA100%
Needs Analysis100%
Financial Analysis100%
Council Orientation100%
Council Consultation0%16-Jan-19
Council Approval0%6-Feb-19
AMP Document7%30-Jan-19
Project 2
To-do list
To be completed by:Name
Deadline:Date
Project 2
% donePhaseDue ByNotes
0%Planning
0%Preparation
0%Task a
0%Task b
0%Task c
0%Task d
0%Paperwork
0%Hand-off
0%Follow-up
Project 3
To-do list
To be completed by:Name
Deadline:Date
Project 3
% donePhaseDue ByNotes
0%Planning
0%Preparation
0%Task a
0%Task b
0%Task c
0%Task d
0%Paperwork
0%Hand-off
0%Follow-up
-
5
Summary of County AssetsAsset Type Records Quantity Replacement Cost
Bridge 127 24,145.11 M2 (Deck Area) $123,249,841
Cross Culvert 1,200 22,642.19 M (Length) $34,450,000
Culvert 26 691.50 M (Length) $22,342,364
Equipment 106 106.00 Each $11,321,152
Faci l i ty 34 194,455.00 Sq Ft (Floor Area) $35,569,080
Forest 3 2,130.80 Hectar $0
Landfi l l 1 158.00 Hectar (Area) $0
Road 225 709.86 Km (Length) $744,783,954
Signals 10 10.00 Each $741,000
Tra i l s 1 5.35 Km (Length) $0
$ 972,457,391
AllAssets
Asset TypeRecordsQuantityReplacement Cost
Bridge12724,145.11 M2 (Deck Area)$123,249,841
Cross Culvert1,20022,642.19 M (Length)$34,450,000
Culvert26691.50 M (Length)$22,342,364
Equipment106106.00 Each$11,321,152
Facility34194,455.00 Sq Ft (Floor Area)$35,569,080
Forest32,130.80 Hectar$0
Landfill1158.00 Hectar (Area)$0
Road225709.86 Km (Length)$744,783,954
Signals1010.00 Each$741,000
Trails15.35 Km (Length)$0
$ 972,457,391
roads
Asset ClassRecordsLength (km)Replacement CostValueAvg Cond
CLA_R_HCBClass A Road - Rural - Hot Mix2456.40$ 77,610,839$ 60,971,65778.53
CLA_U_HCBClass A Road - Urban - Hot Mix76.97$ 14,935,966$ 12,574,79284.35
CLB_LCBClass B Road - Surface Treated3078.14$ 59,332,132$ 45,502,40676.57
CLB_R_HCBClass B Road - Rural - Hot Mix84323.81$ 352,741,100$ 267,671,61375.85
CLB_U_HCBClass B Road - Urban - Hot Mix2118.99$ 37,948,863$ 30,974,54981.69
CLC_LCBClass C Road - Surface Treated31112.51$ 82,552,716$ 61,705,90974.76
CLC_R_HCBClass C Road - Rural - Hot MIx22109.77$ 111,798,785$ 75,099,49567.92
CLC_U_HCBClass C Road - Urban - Hot Mix63.27$ 7,863,553$ 5,555,69072.62
$ 744,783,95474.90
Facilities
Asset ClassUnitsFloor Area (SqFt)Replacement CostNeedsAverage FCI
Courthouse136,000.00$ 10,800,000$ 3,649,8200.89Poor
EMS12,000.00$ 500,000$ 53,6800.95Fair0.70714285718200
Garage1260.00$ 51,080$ 50,2000.00Poor0.2928571429
Office865,100.00$ 15,188,000$ 2,320,7000.95Fair
Quonset12,000.00$ 50,000$ 15,8001.00Good19800
Salt Shed67,800.00$ 936,000$ 328,2000.83Fair
Sand Dome648,000.00$ 2,200,000$ 591,6200.96Good
Storage Garage46,920.00$ 1,308,000$ 326,3700.98Good
Tourism417,075.00$ 4,100,000$ 103,2200.99Good
$ 35,133,080
Equip
Asset ClassDescriptionUnitsReplacement CostAvg AgeAsset ClassClass DescriptionUnitsReplacement CostAvg Age
EQ01Grading4$ 604,7024.00EQ01Grading5$ 604,7024.00
EQ02Loaders4$ 803,5797.00EQ02Loaders4$ 803,5797.00
EQ03Excavation4$ 789,8958.00EQ03Excavation4$ 789,8958.00
EQ04Mowers6$ 187,2947.00EQ04Mowers6$ 187,2947.00
EQ05Plow Trucks15$ 3,237,8696.00EQ05Plow Trucks18$ 3,237,8696.00
EQ06Supervisor/Inspection9$ 305,8576.00EQ06Supervisor/Inspection10$ 305,8576.00
EQ07Other Equipment10$ 589,13710.00EQ07Other Equipment10$ 589,13710.00
EQ08Trailers3$ 86,0397.00EQ08Trailers4$ 96,0397.00
EQ09Fleet Vehicle26$ 997,6164.00EQ09Fleet Vehicle29$ 997,6164.00
EQ10Recycling111.00EQ12Ambulances23$ 2,785,4672.00
EQ12Ambulances23$ 2,785,4672.00EQ13CORP - VEHICLES1
IT82Servers1$ 160,000IT82Servers1$ 160,000
IT84Tech Appliance2$ 18,000IT84Tech Appliance2$ 18,000
$ 10,575,455
ClassDescriptionUnitsReplacement CostAvg AgeNeedsValueAvg CondAvg Ph Cond
EQ01Grading4$ 913,8774.00
EQ02Loaders3$ 631,8076.67
EQ03Excavation5$ 1,036,6675.60
EQ04Mowers6$ 187,2946.33
EQ05Plow Trucks15$ 3,538,1695.80
EQ06Supervisor/Inspection8$ 268,7246.13
EQ07Other Equipment10$ 589,13713.60
EQ08Trailers3$ 86,0395.00
EQ09Fleet Vehicle26$ 961,9714.58
EQ12Ambulances23$ 2,785,4672.78
IT82Servers1$ 160,0001.00
IT84Tech Appliance2$ 18,0001.00
106$ 11,177,152
CrossCUlv
MaterialRecordsReplacement CostMaterialDepartmentRecordsQuantityUnitsQty MeasureReplacement CostDepartmentRecordsQuantityUnitsQty MeasureReplacement Cost
Concrete32$ 1,100,000ConcreteFair131.82MLength$ 75,0001-Excellent240.04MLength$ 50,000
Corregated Steel1,107$ 31,650,000ConcreteGood26620.79MLength$ 900,0002-Very Good971,843.16MLength$ 2,975,000
Plastic61$ 1,700,000ConcreteVery Good5103.74MLength$ 125,0003-Good5279,893.60MLength$ 15,100,000
Corregated SteelExcellent240.04MLength$ 50,0004-Fair3476,405.77MLength$ 9,850,000
Corregated SteelFair3436,327.10MLength$ 9,700,0005-Poor1833,657.27MLength$ 5,425,000
Corregated SteelGood4658,631.16MLength$ 13,275,0006-Very Poor23456.30MLength$ 675,000
Corregated SteelPoor1833,657.27MLength$ 5,425,0007-Unknown21346.05MLength$ 375,000
Corregated SteelUnknown21346.05MLength$ 375,000
Corregated SteelVery Good701,379.93MLength$ 2,150,000
Corregated SteelVery Poor23456.30MLength$ 675,000
PlasticFair346.85MLength$ 75,000
PlasticGood36641.65MLength$ 925,000
PlasticVery Good22359.49MLength$ 700,000
Cross Culverts
1-Excellent2-Very Good3-Good4-Fair5-Poor6-Very Poor29752734718323
BridgeCulv
Asset TypeRecordsQuantityReplacement CostNeedsAvg CondAvg Age
Bridge12724,157.59 m2 (Deck Area)$ 133,395,879$ 31,335,30045.7753.98
Culvert26691.50 m (Length)$ 13,413,042$ 2,217,90062.7449.35
-
6
Project and PresentationScope and Assumptions
• Asset preservation and capacity needs• Assuming operating activities that affect capital are
performed as needed e.g. oil change
-
7
Needs Analysis
• Goals – as prescribed by legislation1. Maintain existing condition/service level2. Activity level3. 10 year plan4. Cost Effective
• No Inflation, all values in 2018
-
8
Roads (Preservation)
• County road inspections 2013, 2015, 2017 using Pavement Condition Index (PCI)
• Three forms of analysis1. Best Practices2. Performance Modelling3. Manual workplan
-
9
Roads – Asset Class ExampleClass B Rural Hot Mix (CLB_R_HCB)
Year Condition Description Affect5 96 Crackseal ($2,530) Hold for 2 yrs
14 86 Microsurface ($55,424) Hold for 5 yrs22 80 Resurface ($300,679) Increase by 17
24 96 Crackseal ($2,530) Hold for 2 yrs33 86 Microsurface ($55,424) Hold for 5 yrs49 63 Rehab ($438,760) Restore To 100
54 96 Crackseal ($2,530) Hold for 2 yrs63 86 Microsurface ($55,424) Hold for 5 yrs91 39 Reconstruct ($983,911) Restore To 100
Sheet1
1.4
150 mm DI$ 478.79 ERROR:#VALUE!150478.793.19
200 mm DI$ 517.82 200517.822.59
250 mm DI$ 553.53 250553.532.21
300 mm DI$ 617.62 300617.622.06
400 mm con$ 898.31 $ 898.31
400 mm DI$ 858.39 $ 858.39
450 mm con$ 1,159.05 $ 1,159.05
500 mm DI$ 1,141.03 $ 1,141.03
600 mm con$ 1,308.54 $ 1,308.54
Sheet2
IMpr_IDDESCNew 102New 90Old
1DST2Double Surface Treatment Rehab545,595.67545,328.00267.670.05%267.670.05%
1MICRO2DMicrosurfacing - Scratch and Surface Lift929,574.40951,806.00911,121.0018,453.402.03%40,685.004.47%
1MILLO1a2Grind and Overlay - Urban 216,991.59218,368.00146,111.0070,880.5948.51%72,257.0049.45%
1ROL12Rural Overlay - County 2,519,255.052,553,798.001,281,000.001,238,255.0596.66%1,272,798.0099.36%
1SST1aSingle Surface Treatment - County 277,452.04277,315.00137.040.05%137.040.05%
CIR-R2Cold in Place Recycling - Rural (100mm) 290,535.07290,535.000.070.00%0.070.00%
CIR-U2Cold in Place Recycling - Urban 55,925.1155,925.000.110.00%0.110.00%
CRK4rdsCrack Sealing113,279.81115,900.0039,470.0073,809.81187.00%76,430.00193.64%
FDR-R2Full Depth Expanded Rural 1,683,052.771,733,342.001,639,735.0043,317.772.64%93,607.005.71%
FDR-U2Full Depth Expanded - Urban 128,168.83130,370.00129,663.00-1,494.17-1.15%707.000.55%
LCB-REC2LCB Full Reconstruct2,283,858.392,282,721.001,137.390.05%1,137.390.05%
RR-HM-CLA2Class A Roads - Rural - Hot Mix - Reconstruction749,113.29749,113.000.290.00%0.290.00%
RR-HM-CLB2Class B Roads - Rural - Hot Mix - Reconstruction3,411,586.683,285,445.00126,141.683.84%126,141.683.84%
RR-HM-CLC2Class C Roads - Rural - Hot Mix - Reconstruction952,720.061,079,101.00965,511.00-12,790.94-1.32%113,590.0011.76%
URCONHMBC2Class B & C Roads - Urban - Hot Mix Reconstruction433,300.20442,189.00440,098.00-6,797.80-1.54%2,091.000.48%
URECONHMA2Class A Road - Urban - Hot Mix - Reconstruction144,164.54144,165.00-0.46-0.00%-0.46-0.00%
Sheet3
YearConditionDescriptionAffect
596Crackseal ($2,530)Hold for 2 yrs
1486Microsurface ($55,424)Hold for 5 yrs
2280Resurface ($300,679)Increase by 17
2496Crackseal ($2,530)Hold for 2 yrs
3386Microsurface ($55,424)Hold for 5 yrs
4963Rehab ($438,760)Restore To 100
5496Crackseal ($2,530)Hold for 2 yrs
6386Microsurface ($55,424)Hold for 5 yrs
9139Reconstruct ($983,911)Restore To 100
-
10
Roads – Asset Class ExampleBenefits of Recommended Maintenance
• Every time you miss a rehabilitation activity you shift towards “Do Nothing”. Lifecycle costs increase and average condition decreases.
RecommendedDo Nothing
Missed Preservation Activity
-
11
Roads – Best Practices
• Description– Based on asset class lifecycle activities
• Most cost effective approach to managing each class of road– Assumptions
• System is in an average overall condition• All activities completed on time• Only preservation
– No growth factors or other influences
– Output: Average Annual Cost = $13.33M
-
12
Roads – Performance Modelling
• Scenarios for discussion:– Optimal. Do all activities at the recommended time.– Maintain. Cost to maintain current average condition.
• Generated scenarios will still require human adjustments– Safety– Operations– Work scheduling
-
13
Scenario: Optimal• All activities,
when needed
• Average Annual Cost = $12.5M
-
14
Maintain Scenario: Activity Prioritization
• There are many options to achieve the target average condition. How does the analysis choose the activities to fund?
• Return on Investment (ROI)• Worst First
-
15
Comparison of Prioritization Methods
• Blue –$5M/Year prioritized by ROI
• Green –$10M/Year prioritized by worst first
-
16
Scenario: Maintain Current Average Condition
• Use ROI to prioritize funded activities• Set minimum tolerable condition • Does reconstruction ever get funded?
– Triggered by minimum policy values– Maintenance activities
-
17
Scenario: Maintain Current Condition
• Lowest cost to maintain current average condition
• Average Annual Cost = $11.6M
-
18
Roads – Manual Workplan
• Manual 10 year workplan maintained by County staff and shared annually with senior leadership team and Council
• Many factors including ROI, safety, operations• Plan identifies $13M/Year in needs over next 10 years• Details at end of roads analysis
-
19
Recap – Assessing Target Annual Spending
Analysis Description Result (M/year)
Best Practices Best Practices $13.33 M/year
Optimal All activities done when needed $12.50 M/year
Maintain Cost to Maintain current condition $11.61 M/year
Manual Manual Workplan, considers additional factors such as safety, maintenance
$13.00 M/year
• All forms analysis support an annual budget of between $11.6 and $13M
• $13M accepted as average annual cost
-
20
10 Year Forecast Manual Workplan - Format
Projected Timeline
Estimated Total Funded Amount
Project Description
Asset ID
Local Township
Scope of Work
Estimated Cost
Carry Over
-
21
Proposed 2019
Construction Program
Proposed 2019
Construction Program
-
22
-
23
-
24
-
25
Bridges and Culverts – Needs by recommended timing
• Total needs over next 10 years = $40,014,635
2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Total Average/Yr$4,715,000 $2,875,000 $3,947,000 $3,373,000 $4,354,500 $3,848,500 $3,440,335 $4,332,800 $4,622,000 $4,506,500 $40,014,635 $4,001,464
Baseline
Needs, Adjusted to 2018 Values
Asset TypeDept20182019202020212022202320242025202620272028TotalAverage/YrFund Source(s)Levy-R&BLevy-CCLevy-SignalsLevy-FacGas TaxOCIFDCLPVCorp EqEnv EqPCCPEM EqPW EqTotalUnfunded TP$ 41,632,716
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$ 40,014,635$ 4,001,464Levy, Gas Tax, OCIF$40,014,635$40,014,635Divide by 17 yrs$ 2,448,983
Cross Culvert$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$ 6,791,000$ 679,100Levy$6,791,000$6,791,000
EquipmentCORP$63,725$164,444$203,332$ 431,502$ 43,150Corp Equip Reserve$431,502$431,502Spending 2019$ 12,780,640
EquipmentENV$31,351$ 31,351$ 3,135Env Equip Reserve$31,351$31,351Spend Limit cur staff$ 13,000,000
EquipmentEM$39,409$39,404$55,672$ 134,485$ 13,448EM Equip Reserve$134,485$134,485Staff %6.00%
EquipmentPCCP$627,429$640,827$290,305$509,212$590,841$460,693$559,714$269,479$472,681$443,617$ 4,864,799$ 486,480PCCP Equip Reserve$4,864,799$4,864,799
EquipmentPW$841,512$535,287$415,524$658,743$996,031$826,905$758,831$624,074$906,945$944,486$ 7,508,339$ 750,834PW Equip Reserve$7,508,339$7,508,3391% Levy$ 411,000
Facility$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632Levy$7,566,322.42$7,566,322
Road$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$ 130,000,000$ 13,000,000Levy, Gas Tax, OCIF, DC$107,562,656$17,227,596$5,209,748$130,000,0002018 Levy
Signals$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$ 260,000$ 26,000Levy, Gas Tax$260,000$260,000
Transportation Plan$1,635,000$6,610,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$ 13,412,284$ 1,341,228Levy, Gas Tax, OCIF, DC$13,412,284$13,412,284
Transportation Plan - Unfunded$2,448,983$2,448,983$2,448,983$2,448,983$2,448,983$2,448,983$2,448,983$ 17,142,883$ 1,714,288Levy, Gas Tax, OCIF, DC$15,855,167.06$1,287,716$17,142,883
Staffing (13M Base, 6% above)$436,133$641,378$479,031$440,847$501,711$496,380$455,759$519,643$544,061$596,286$ 5,111,227$ 511,123Levy$2,555,614$2,555,614$5,111,227
$22,277,088$25,507,132$22,168,704$22,120,701$23,450,426$23,096,375$22,401,634$23,129,581$24,194,704$24,922,483$233,268,828$23,326,883Need$165,988,072$6,791,000$260,000$10,121,936$17,227,596$5,209,748$14,700,000$431,502$31,351$4,864,799$134,485$7,508,339$233,268,828
Reserve OpenTargetForecastAvailable
Levy - Roads+Bridges7,584,0857,584,0857,858,828$8,680,828$9,520,713$10,377,395$11,251,211$12,142,503$13,051,621$13,978,922$14,924,768$15,889,531$16,873,590$134,275,167$126,691,082Available$126,691,082$1,840,000$100,000$2,164,160$17,227,596$5,209,748$14,700,000$521,838$59,070$8,317,307$130,294$7,146,869$184,107,965
Levy - Cross Culverts00184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$1,840,000$1,840,000(Funding Gap)/Surplus($39,296,990)($4,951,000)($160,000)($7,957,776)$90,336$27,719$3,452,508($4,190)($361,470)
Levy - Signals0010,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$100,000$100,000Funding Gap -Levy, excl Eq($52,365,766)
Levy - Facilities00216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160$2,164,160Annual Levy Funding Gap($5,236,577)
(Levy) LPV000Annual Levy Increase12.74%
(Levy) Corp Eq112,017
David: David:Assume Server = 80% of IT network, Server, Applications36,72326,629$26,629$31,105$35,395$39,505$43,440$47,206$50,807$54,249$57,536$60,674$558,561$521,83840.00%
(Levy) Env Eq40,00040,0004,278$4,278$4,894$5,491$6,070$6,630$6,532$6,435$6,340$6,246$6,154$99,070$59,070
(Levy) PCCP Eq1,587,8293,727,017806,920$806,920$851,888$899,567$950,127$1,003,746$1,060,618$1,120,945$1,184,944$1,252,846$1,324,894$12,044,324$8,317,307
(Levy) EM Eq30,00060,00012,414$12,414$13,978$15,492$16,959$17,544$17,285$17,029$16,778$16,530$16,286$190,294$130,29490.00%
(Levy) PW Eq3,476,5162,950,776640,394$640,394$645,126$649,893$654,696$659,533$664,406$669,315$674,261$679,243$684,263$10,097,645$7,146,869
Gas Tax$1,692,246$1,692,246$1,769,166$1,769,166$1,846,087$1,691,737$1,691,737$1,691,737$1,691,737$1,691,737$17,227,596$17,227,596
DC - Roads4,500,0000$1,500,000$1,500,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$14,700,000$14,700,000
OCIF00$497,150$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$5,209,748$5,209,748
$14,271,275$15,193,987$15,886,438$16,821,771$17,453,521$18,273,442$19,269,229$20,287,115$21,327,707$22,391,635$198,506,566$184,107,965
43091.360155375
Excluding Equipment
Needs (Excluding Equipment)$20,705,013$24,331,018$21,462,875$20,788,302$21,863,554$21,769,373$21,051,737$22,180,356$22,611,746$23,534,379$220,298,352
Funding (Including Equipment)$9,759,879$12,780,640$13,646,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$163,432,586
Reserve Adjustment RB
Reserve Adjustment DC$4,500,000$4,500,000
Shortfall (Excl Equipment)$7,924,373$6,184,021$7,182,276$5,633,887$6,140,926$5,291,977$3,647,040$3,829,813$3,296,440$3,235,014$52,365,766
Levy Shortfall Excl Equip %19.28%15.05%17.48%13.71%14.94%12.88%8.87%9.32%8.02%7.87%
Unadjusted Values12345678910
Asset TypeDepartment2019202020212022202320242025202620272028TotalAverage/Yr
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$ 40,014,635$ 4,001,464Manual Workplan41335635
Cross Culvert$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$ 6,791,000$ 679,1009 Year AAC4068959
EquipmentCORP$65,000$178,000$243,000$ 486,000$ 48,6002.00%
EquipmentENV$34,795$ 34,795$ 3,4801.50%
EquipmentEM$40,000$43,086$62,714$ 145,800$ 14,5801.50%
EquipmentPCCP$636,840$660,196$303,566$540,459$636,504$503,742$621,196$303,566$540,459$514,836$ 5,261,364$ 526,1361.50%
EquipmentPW$854,135$551,466$434,504$699,166$1,073,008$904,174$842,185$703,015$1,036,992$1,096,115$ 8,194,760$ 819,4761.50%
Facility$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632
Road$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$ 130,000,000$ 13,000,000
Signals$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$ 260,000$ 26,000
Transportation Plan$1,635,000$6,610,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$ 13,412,284$ 1,341,228
Transportation Plan - Unfunded
$21,864,855$24,901,302$21,721,914$19,316,096$20,622,372$20,275,012$19,645,171$20,281,025$21,439,152$22,100,061$212,166,960$21,216,696
Reserve OpenTargetAddn + OpeningAvailable (less target)Infl%Cap%
Levy - Roads+Bridges7,584,0857,584,085$8,680,828$9,520,713$10,377,395$11,251,211$12,142,503$13,051,621$13,978,922$14,924,768$15,889,531$16,873,590$134,275,167$126,691,0820.00%100.00%
Levy - Cross Culverts00$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$1,840,000$1,840,000100.00%Capital portion in operating budget
Levy - Signals00$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$100,000$100,000100.00%Capital portion in operating account
Levy - Facilities00$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160$2,164,160100.00%Capital portion in Operating budget, should have a reserve acct
(Levy) LPV00$63,000$63,000$63,000$63,000$63,000$63,000$63,000$63,000$63,000$63,000$630,000$630,0000.00%Fund seem to only be for artifact buildings
(Levy) Corp Eq112,017
David: David:Assume Server = 80% of IT network, Server, Applications
David: David:Assume Server = 80% of IT network, Server, Applications36,723$67,903$80,903$93,903$106,903$119,903$132,903$145,903$158,903$171,903$184,903$1,376,047$1,339,3242.00%40.00%
(Levy) Env Eq40,00040,000$31,015$36,015$41,015$46,015$51,015$51,015$51,015$51,015$51,015$51,015$500,150$460,1501.50%14.00%
(Levy) PCCP1,587,8293,727,017$819,024$877,636$940,658$1,008,430$1,081,320$1,159,726$1,244,075$1,334,831$1,432,491$1,537,593$13,023,613$9,296,5961.50%100.00%
(Levy) EM30,00060,000$14,000$16,000$18,000$20,000$21,000$21,000$21,000$21,000$21,000$21,000$224,000$164,0001.50%90.00%
(Levy) PW3,476,5162,950,776$650,000$664,625$679,579$694,870$710,504$726,490$742,836$759,550$776,640$794,115$10,675,725$7,724,9491.50%100.00%
Gas Tax$1,692,246$1,692,246$1,769,166$1,769,166$1,846,087$1,691,737$1,691,737$1,691,737$1,691,737$1,691,737$17,227,596$17,227,596100.00%
DC4,500,0000$1,500,000$1,500,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$14,700,000$14,700,000100.00%
OCIF00$497,150$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$5,209,748$5,209,748100.00%
$14,425,582$15,385,176$16,116,754$17,093,633$17,769,370$18,631,530$19,672,526$20,738,842$21,831,355$22,950,991$187,547,605
Options
SPENDING
Asset TypeDept20182019202020212022202320242025202620272028TotalAverage/YrFund Source(s)Levy-R&BLevy-CCLevy-SignalsLevy-FacGas TaxDCOCIFLPVCorp EqEnv EqPCCPEM EqPW EqTotal
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$ 40,014,635$ 4,001,464Levy, Gas Tax, OCIF$40,014,635$40,014,635
Cross Culvert$479,100$579,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$ 6,491,000$ 649,100Levy$6,491,000$6,491,000
EquipmentCORP$63,725$164,444$203,332$ 431,502$ 43,150Corp Equip Reserve$431,502$431,502
EquipmentENV$31,351$ 31,351$ 3,135Env Equip Reserve$31,351$31,351
EquipmentEM$39,409$39,404$55,672$ 134,485$ 13,448EM Equip Reserve$134,485$134,485
EquipmentPCCP$627,429$640,827$290,305$509,212$590,841$460,693$559,714$269,479$472,681$443,617$ 4,864,799$ 486,480PCCP Equip Reserve$4,864,799$4,864,799
EquipmentPW$841,512$535,287$415,524$658,743$996,031$826,905$758,831$624,074$906,945$944,486$ 7,508,339$ 750,834PW Equip Reserve$7,508,339$7,508,339
Facility$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632Levy$7,566,322.42$7,566,322
Road$6,000,000$7,000,000$8,000,000$11,000,000$11,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$ 108,000,000$ 10,800,000Levy, Gas Tax, OCIF, DC$85,562,656$17,227,596$5,209,748$108,000,000
Signals$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$ 260,000$ 26,000Levy, Gas Tax$260,000$260,000
Transportation Plan$1,635,000$6,610,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$ 13,412,284$ 1,341,228Levy, Gas Tax, OCIF, DC$13,412,284$13,412,284
Transportation Plan - Unfunded$2,448,983$1,000,000$500,000$500,000$500,000$1,200,000$1,200,000$ 7,348,983$ 734,898$ 9,793,900Levy, Gas Tax, OCIF, DC$7,348,983$1,287,716$8,636,699
Staffing (13M Base, 6% above)$98,457$345,945$221,380$400,791$389,984$459,061$419,813$459,657$564,100$604,633$ 3,963,822$ 396,382Levy$2,774,675$1,189,146.61$3,963,822
TOTAL SPENDING$14,739,413$19,111,699$16,911,053$20,080,645$19,889,716$21,110,073$20,416,705$21,120,612$22,965,759$23,681,847$200,027,523$20,002,752Need$135,700,950$6,491,000$260,000$8,755,469$17,227,596$14,700,000$5,209,748$431,502$31,351$4,864,799$134,485$7,508,339$201,315,239
FUNDING
NEW MONEYReserve OpenTarget2018ForecastAvailableDiff
Levy - Roads+Bridges7,584,0857,584,0857,858,828.00$8,680,828$9,931,713$10,788,395$12,073,211$12,964,503$13,873,621$14,800,922$15,746,768$16,711,531$17,695,590$133,267,082$133,267,082Available$133,267,082$1,840,000$100,000$5,554,910$17,227,596$14,700,000$5,209,748$521,838$59,070$8,317,307$130,294$7,146,869$194,074,715
Levy - Cross Culverts00184,000.00$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$1,840,000$1,840,000(Funding Gap)/Surplus($2,433,868)($4,651,000)($160,000)($3,200,559)$90,336$27,719$3,452,508($4,190)($361,470)
Levy - Signals0010,000.00$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$100,000$100,000Funding Gap -Levy, excl Eq($10,445,427)
Levy - Facilities00216,416.00$216,416$421,916$524,666$627,416$627,416$627,416$627,416$627,416$627,416$627,416$5,554,910$5,554,910Annual Levy Funding Gap($1,044,543)0.00%0.00%0.00%
(Levy) LPV000.00Annual Levy Increase2.54%
(Levy) Corp Eq112,01736,72326,628.63$26,629$31,105$35,395$39,505$43,440$47,206$50,807$54,249$57,536$60,674$446,544$521,838$75,294
(Levy) Env Eq40,00040,0004,277.93$4,278$4,894$5,491$6,070$6,630$6,532$6,435$6,340$6,246$6,154$59,070$59,070
(Levy) PCCP Eq1,587,8293,727,017806,920.20$806,920$851,888$899,567$950,127$1,003,746$1,060,618$1,120,945$1,184,944$1,252,846$1,324,894$10,456,495$8,317,307($2,139,188)
(Levy) EM Eq30,00060,00012,413.79$12,414$13,978$15,492$16,959$17,544$17,285$17,029$16,778$16,530$16,286$160,294$130,294($30,000)
(Levy) PW Eq3,476,5162,950,776640,394.09$640,394$645,126$649,893$654,696$659,533$664,406$669,315$674,261$679,243$684,263$6,621,129$7,146,869$525,740
Gas Tax000.00$1,692,246$1,692,246$1,769,166$1,769,166$1,846,087$1,691,737$1,691,737$1,691,737$1,691,737$1,691,737$17,227,596$17,227,596
DC - Roads4,500,00000.00$1,500,000$1,500,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$10,200,000$14,700,000$4,500,000
OCIF000.00$497,150$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$5,209,748$5,209,748
Total$17,330,447$14,398,601$9,759,879$14,271,275$15,810,487$16,605,688$18,054,771$18,686,521$19,506,442$20,502,229$21,520,115$22,560,707$23,624,635$191,142,870$194,074,715$2,931,846
FROM/TO RESERVE
Levy - Roads+Bridges
DC - Roads$4,500,000$4,500,000
PCCP($851,888)($899,567)($387,733)($2,139,188)
Total Reserve Adjustments$3,648,112($899,567)($387,733)$2,360,812
Net Funding$14,271,275$19,458,599$15,706,120$17,667,038$18,686,521$19,506,442$20,502,229$21,520,115$22,560,707$23,624,635$193,503,682
LEVY (incl Equipment)
Baseline$9,759,879$12,780,640$13,646,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365
Proposed, Levy only$10,581,879$12,094,619$13,112,900$14,561,983$15,516,812$16,491,083$17,486,870$18,504,756$19,545,348$20,609,276
Increase over Baseline($2,198,761)($1,552,378)($1,167,699)($592,432)($205,816)$13,687$82,173$154,213$230,042$309,911
Incr over Previous Year (Baseline + Proposed)2.00%1.57%0.94%1.40%0.94%0.53%0.17%0.18%0.18%0.19%
Incr over Baseline0.00%-3.78%-2.84%-1.44%-0.50%0.03%0.20%0.38%0.56%0.75%
Incr over 20182.00%5.68%8.16%11.68%14.01%16.38%18.80%21.28%23.81%26.40%
Excluding Equipment
Total Needs Excl Eq$13,167,337$17,935,585$16,205,224$18,748,246$18,302,844$19,783,071$19,066,808$20,171,387$21,382,801$22,293,743$187,057,047$188,344,763
Total Funding Excl Eq$12,780,640$18,763,497$14,999,849$16,387,415$16,955,628$17,710,396$18,637,697$19,583,543$20,548,306$21,532,365$177,899,336$177,899,3364,500,000
Shortfall$386,697($827,912)$1,205,375$2,360,831$1,347,216$2,072,675$429,111$587,844$834,495$761,378$9,157,711
Shortfall(Surplus) Levy %0.94%-2.01%2.93%5.74%3.28%5.04%1.04%1.43%2.03%1.85%
SPENDINGApply?TotalRationalImplicationsRisk Mitigation
Cross Culverts, ramp up100.00%($200,000)($100,000)($300,000)Ramp up, planUnplanned failurePrioritize very poor
Roads, ramp up100.00%($7,000,000)($6,000,000)($5,000,000)($2,000,000)($2,000,000)($22,000,000)Ramp up, planMissed savings oppReduce Reconstruction
TP, defer new projects100.00%($1,448,983)($1,948,983)($1,948,983)($1,948,983)($1,248,983)($1,248,983)($9,793,900)Optional, prioritize preservationCongestion
Reduce staffing increase0.00%($436,133)($641,378)($479,031)($440,847)($501,711)($496,380)($455,759)($519,643)($544,061)($596,286)($5,111,227)
($7,636,133)($6,741,378)($5,479,031)($2,440,847)($3,950,694)($2,445,363)($2,404,742)($2,468,626)($1,793,044)($1,845,269)($32,093,900)
REVENUETotal
Levy - Facilities100.00%$205,500$308,250$411,000$411,000$411,000$411,000$411,000$411,000$411,000$3,390,750
Levy - Trans Plan100.00%$411,000$411,000$822,000$822,000$822,000$822,000$822,000$822,000$822,000$6,576,000
Levy Change over baseline$616,500$719,250$1,233,000$1,233,000$1,233,000$1,233,000$1,233,000$1,233,000$1,233,000$9,966,750
Levy Change %0.00%1.50%1.75%3.00%3.00%3.00%3.00%3.00%3.00%3.00%
Levy change over PY1.50%0.25%1.25%0.00%0.00%0.00%0.00%0.00%0.00%
Cumulative Levy Change, with changesBase$10,581,8790.00%3.68%6.16%9.68%12.01%14.38%16.80%19.28%21.81%24.40%
Cumulative Levy Change, no changesBase$10,581,8790.00%2.18%4.41%6.68%9.01%11.38%13.80%16.28%18.81%21.40%
Trans PlanFac
Unfunded$17,142,883$5,402,162
Spending Reduction($9,793,900)
Rev Increase($6,576,000)($3,390,750)
$772,983$2,011,412
Pres_Needs
Asset Type2019202020212022202320242025202620272028TotalAverage/YrAsset TypeAverage/YrHistoric AvgGap
Bridges/Culverts$4,816,454$2,952,838$4,037,104$3,446,079$4,456,771$3,938,300$3,516,465$4,436,744$4,735,952$4,623,648$40,960,356$4,096,036Bridges/Culverts$4,096,036$2,137,275$1,958,761$945,721
Cross Culvert$693,712$697,486$694,603$693,813$695,050$694,946$694,127$695,392$695,843$696,753$6,951,726$695,173Cross Culvert$695,173$184,000$511,173$160,726
Equipment$1,572,075$1,176,114$705,829$1,332,400$1,586,872$1,327,003$1,349,897$949,225$1,582,958$1,388,104$12,970,476$1,297,048Equipment$1,297,048$1,123,500$173,548
Facility$218,380$513,065$648,944$470,346$607,193$1,033,987$757,970$935,753$1,005,802$1,556,958$7,748,397$774,840Facility$774,840$216,416$558,424
Road$13,279,726$13,351,965$13,296,771$13,281,658$13,305,322$13,303,339$13,287,671$13,311,871$13,320,505$13,337,941$133,076,768$13,307,677Road$13,307,677$4,388,936$8,918,741
Signals$26,559$26,704$26,594$26,563$26,611$26,607$26,575$26,624$26,641$26,676$266,154$26,615Signals$26,615$10,000$16,615
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952$3,129,495Transportation Plan$3,129,495$961,963$2,167,532
Total$22,277,088$25,507,132$22,168,704$22,120,701$23,450,426$23,096,375$22,401,634$23,129,581$24,194,704$24,922,483$233,268,828$23,326,883Total$23,326,883$9,022,090$14,304,793
Staff Cost$436,133$641,378$479,031$440,847$501,711$496,380$455,759$519,643$544,061$596,286$5,111,227
Staff Base$20,268,880$23,689,640$20,983,844$20,347,455$21,361,843$21,272,993$20,595,978$21,660,713$22,067,685$22,938,093
Staff Cost %0.0215170.0270740.0228290.0216660.0234860.0233340.0221290.0239900.0246540.025995
Opening+ Levy- 10 Year Needs= Forecast- Reserve Target= Over(Under)
(Levy) Corp Eq$112,017$446,544($431,502)$127,060$36,723$90,336
(Levy) Env Eq$40,000$59,070($31,351)$67,719$40,000$27,719
(Levy) PCCP Eq$1,587,829$10,456,495($4,864,799)$7,179,525$3,727,017$3,452,508
(Levy) EM Eq$30,000$160,294($134,485)$55,810$60,000($4,190)
(Levy) PW Eq$3,476,516$6,621,129($7,508,339)$2,589,306$2,950,776($361,470)
Bridge and Culverts, without staffing
Asset Type2019202020212022202320242025202620272028TotalAverage/Yr
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$40,014,635$4,001,464
Pres_Funding_xEq
Asset TypeFund Source(s)NeedLevy-R&BLevy-CCLevy-SignalsLevy-FacGas TaxOCIFDCTOTAL
Bridges/CulvertsLevy, Gas Tax, OCIF$40,960,356$40,960,356$40,960,356
Cross CulvertLevy$6,951,726$6,951,726$6,951,726
FacilityLevy$7,748,397$7,748,397$7,748,397
RoadLevy, Gas Tax, OCIF, DC$133,076,768$110,639,424$17,227,596$5,209,748$133,076,768
SignalsLevy, Gas Tax$266,154$266,154$266,154
Transportation PlanLevy, Gas Tax, OCIF, DC$31,294,952$16,594,952$14,700,000$31,294,952
Total Needs$220,298,352$168,194,732$6,951,726$266,154$7,748,397$17,227,596$5,209,748$14,700,000$220,298,352
Available Funding$126,691,082$1,840,000$100,000$2,164,160$17,227,596$5,209,748$14,700,000$167,932,586
Funding Shortfall$41,503,650$5,111,726$166,154$5,584,237$52,365,766
Asset TypeFund Source(s)NeedLevy-TransLevy-FacGas TaxOCIFDCTOTAL35.47%
Transportation-PreservationLevy, Gas Tax, OCIF, DC$181,255,003$158,817,659$17,227,596$5,209,748$181,255,003
Transportation PlanLevy, Gas Tax, OCIF, DC$31,294,952$16,594,952$14,700,000$31,294,952
FacilitiesLevy$7,748,397$7,748,397$7,748,397
Total Needs$220,298,352$175,412,611$7,748,397$17,227,596$5,209,748$14,700,000$220,298,352
Available Funding$128,631,082$2,164,160$17,227,596$5,209,748$14,700,000$167,932,586
Funding Shortfall$46,781,529$5,584,237$52,365,766
Asset TypeFund Source(s)NeedLevy-TransGas TaxOCIFDCTOTAL
Transportation-PreservationLevy, Gas Tax, OCIF, DC$212,549,955$175,412,611$17,227,596$5,209,748$14,700,000$212,549,955
Total Needs$212,549,955$175,412,611$17,227,596$5,209,748$14,700,000$212,549,955
Available Funding$128,631,082$17,227,596$5,209,748$14,700,000
Funding Shortfall$46,781,529
NeedFundingShortfall
Transportation-Preservation$181,255,003$151,068,426$30,186,577
Transportation Plan$31,294,952$14,700,000$16,594,952
Subtotal - Transportation$212,549,955$165,768,426$46,781,529
Facilities$7,748,397$2,164,160$5,584,237
Total$220,298,352$167,932,586$52,365,766
Sheet1
12345678910
20182019202020212022202320242025202620272028
County Levy41,170,80041,994,21642,834,10043,690,78244,564,59845,455,89046,365,00847,292,30848,238,15449,202,91750,186,975
Increase %2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%
Levy Increase823,416839,884856,682873,816891,292909,118927,300945,846964,763984,058
839884.32
Pres_10Yr_xEq
Asset Type2019202020212022202320242025202620272028Total$411,7081% Levy
Roads/Bridges-PreservationNeeds$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003$41,170,8002018 Levy
Available$11,064,224$11,930,581$12,864,183$13,737,999$14,706,212$15,460,980$16,388,281$17,334,127$18,298,890$19,282,949$151,068,426151068426
Shortfall$7,752,228$5,098,412$5,190,889$3,710,115$3,777,541$2,502,212$1,136,557$1,136,504$480,050($597,931)$30,186,577
Transportation PlanNeeds$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Available$1,500,000$6,000,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$14,700,000
Shortfall$170,181$788,961$1,558,859$1,669,843$1,972,607$1,972,194$1,968,929$1,973,972$2,027,004$2,492,402$16,594,952
FacilitiesNeeds$218,380$513,065$648,944$470,346$607,193$1,033,987$757,970$935,753$1,005,802$1,556,958$7,748,397
Baseline Funding$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160
Shortfall$1,964$296,649$432,528$253,930$390,777$817,571$541,554$719,337$789,386$1,340,542$5,584,237
AllNeeds$20,705,013$24,331,018$21,462,875$20,788,302$21,863,554$21,769,373$21,051,737$22,180,356$22,611,746$23,534,379$220,298,352
Available$12,780,640$18,146,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$167,932,586
Shortfall$7,924,373$6,184,021$7,182,276$5,633,887$6,140,926$5,291,977$3,647,040$3,829,813$3,296,440$3,235,014$52,365,766
2019202020212022202320242025202620272028
Roads/Bridges-Preservation$7,752,228$5,098,412$5,190,889$3,710,115$3,777,541$2,502,212$1,136,557$1,136,504$480,050($597,931)
Transportation Plan$170,181$788,961$1,558,859$1,669,843$1,972,607$1,972,194$1,968,929$1,973,972$2,027,004$2,492,402
Facilities$1,964$296,649$432,528$253,930$390,777$817,571$541,554$719,337$789,386$1,340,542
Facilities - Fully Funded B2019202020212022202320242025202620272028Total
FacilitiesNeeds$218,380$513,065$648,944$470,346$607,193$1,033,987$757,970$935,753$1,005,802$1,556,958$7,748,397
Baseline Funding$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160
Shortfall$1,964$296,649$432,528$253,930$390,777$817,571$541,554$719,337$789,386$1,340,542$5,584,237
Starting Levy Base$41,170,800$41,170,800$41,376,654$41,582,508$41,789,391$41,893,348$41,893,348$41,893,348$41,893,348$41,893,348
Yearly Levy Adjustment$205,854$205,854$206,883$103,956
Cumulative Levy Adjustment$205,854$411,708$618,591$722,548$722,548$722,548$722,548$722,548$722,548$5,571,439
Levy increase - over current1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%
Levy increase - year over year0.50%0.50%0.50%0.25%0.00%0.00%0.00%0.00%0.00%1.75%
Adjusted Funding$216,416$422,270$628,124$835,007$938,964$938,964$938,964$938,964$938,964$938,964$7,735,599
Adjusted Shortfall (Surplus)$1,964$90,795$20,820($364,662)($331,770)$95,023($180,994)($3,211)$66,838$617,995$12,798
711381.6
Transportation - Compromise2019202020212022202320242025202620272028Total
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Available Funding$12,564,224$17,930,581$14,064,183$14,937,999$15,506,212$16,260,980$17,188,281$18,134,127$19,098,890$20,082,949$165,768,426
Shortfall (Surplus)$7,922,409$5,887,373$6,749,748$5,379,957$5,750,148$4,474,406$3,105,486$3,110,476$2,507,054$1,894,472$46,781,529
Reduced Road Preservation($7,000,000)($5,500,000)($5,000,000)($2,000,000)($2,000,000)($21,500,000)
Reduced Transportation Plan($170,181)($788,961)($1,558,859)($1,669,843)($1,972,607)($1,972,194)($1,968,929)($1,973,972)($12,075,546)
Levy Adjustment-TransPlan
0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Transportation Preservation$11,816,452$11,528,993$13,055,072$15,448,114$16,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$159,755,003
Transportation Plan$1,670,181$6,788,961$2,588,678$2,080,882$1,213,748$1,102,352$796,322$801,778$858,075$1,318,430$19,219,406
Adjusted Funding$12,564,224$17,930,581$14,064,183$14,937,999$15,506,212$16,260,980$17,188,281$18,134,127$19,098,890$20,082,949$165,768,426
Adjusted Shortfall (Surplus)$922,409$387,373$1,579,567$2,590,997$2,191,289$2,804,564$1,132,879$1,138,282$538,125($79,501)$13,205,983
Transportation - Fully Funded B2019202020212022202320242025202620272028Total
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Subtotal - Needs$20,486,633$23,817,954$20,813,931$20,317,956$21,256,360$20,735,386$20,293,767$21,244,603$21,605,944$21,977,421$212,549,955
Baseline Funding$12,564,224$17,930,581$14,064,183$14,937,999$15,506,212$16,260,980$17,188,281$18,134,127$19,098,890$20,082,949$165,768,426
Shortfall (Surplus)$7,922,409$5,887,373$6,749,748$5,379,957$5,750,148$4,474,406$3,105,486$3,110,476$2,507,054$1,894,472$46,781,529
Reduced Road Preservation
Reduced Transportation Plan
Starting Levy Base$41,170,800$41,170,800$42,163,016$43,155,233$44,171,361$45,211,402$46,275,932$47,365,527$48,480,777$49,622,2860.00%Annual Levy Base Increase
Yearly Levy Adjustment$992,216$992,216$1,016,129$1,040,041$1,064,530$1,089,595$1,115,250$1,141,509$1,168,387
Cumulative Levy Adjustment$992,216$1,984,433$3,000,561$4,040,602$5,105,132$6,194,727$7,309,977$8,451,486$9,619,873$46,699,007
Levy increase - year over year2.41%2.41%2.41%2.41%2.41%2.41%2.41%2.41%2.41%21.69%
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Adjusted Funding$12,564,224$18,922,797$16,048,616$17,938,560$19,546,814$21,366,112$23,383,008$25,444,104$27,550,376$29,702,822$212,467,433
Adjusted Shortfall (Surplus)$7,922,409$4,895,156$4,765,315$2,379,396$1,709,546($630,726)($3,089,241)($4,199,501)($5,944,432)($7,725,401)$82,522
Reduce SpendingReduced Spending + Levy
TransportationTotalAdjustmentRevisedAdjustmentRevised
Transportation Preservation$181,255,003($21,500,000)$159,755,003$181,255,003
Transportation Plan$31,294,952($12,075,546)$19,219,406$31,294,952
Available Funding$165,768,426$165,768,426$165,768,426
Shortfall (Surplus)$46,781,529($33,575,546)$13,205,983$46,781,529
Transportation - Fully Funded A2019202020212022202320242025202620272028Total
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Subtotal - Needs$20,486,633$23,817,954$20,813,931$20,317,956$21,256,360$20,735,386$20,293,767$21,244,603$21,605,944$21,977,421$212,549,955
Baseline Funding$12,564,224$17,930,581$14,064,183$14,937,999$15,506,212$16,260,980$17,188,281$18,134,127$19,098,890$20,082,949$165,768,426
Shortfall (Surplus)$7,922,409$5,887,373$6,749,748$5,379,957$5,750,148$4,474,406$3,105,486$3,110,476$2,507,054$1,894,472$46,781,529
Reduced Road Preservation
Reduced Transportation Plan
Starting Levy Base$41,170,800$41,170,800$46,366,555$46,366,555$46,366,555$46,366,555$46,366,555$46,366,555$46,366,555$46,366,5550.00%Annual Levy Base Increase
Yearly Levy Adjustment$5,195,755
Cumulative Levy Adjustment$5,195,755$5,195,755$5,195,755$5,195,755$5,195,755$5,195,755$5,195,755$5,195,755$5,195,755$46,761,795
Levy increase - year over year12.62%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%12.62%
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Adjusted Funding$12,564,224$23,126,336$19,259,938$20,133,754$20,701,967$21,456,735$22,384,036$23,329,882$24,294,645$25,278,704$212,530,221
Adjusted Shortfall (Surplus)$7,922,409$691,618$1,553,993$184,202$554,393($721,349)($2,090,269)($2,085,279)($2,688,701)($3,301,283)$19,734
Facilities - Fully Funded A2019202020212022202320242025202620272028Total
0$218,380$513,065$648,944$470,346$607,193$1,033,987$757,970$935,753$1,005,802$1,556,958
Reduced Road Preservation$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416
Reduced Transportation Plan$1,964$296,649$432,528$253,930$390,777$817,571$541,554$719,337$789,386$1,340,542
Starting Levy Base$41,170,800$41,170,800$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362
Yearly Levy Adjustment$617,562
Cumulative Levy Adjustment$617,562$617,562$617,562$617,562$617,562$617,562$617,562$617,562$617,562$5,558,058
Levy increase - over current1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%
Levy increase - year over year1.50%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%1.50%
Adjusted Funding$216,416$833,978$833,978$833,978$833,978$833,978$833,978$833,978$833,978$833,978$7,722,218
Adjusted Shortfall (Surplus)$1,964($320,913)($185,034)($363,632)($226,785)$200,009($76,008)$101,775$171,824$722,980$26,179
Combined2019202020212022202320242025202620272028Total
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Facilities$218,380$513,065$648,944$470,346$607,193$1,033,987$757,970$935,753$1,005,802$1,556,958$7,748,397
Needs$20,705,013$24,331,018$21,462,875$20,788,302$21,863,554$21,769,373$21,051,737$22,180,356$22,611,746$23,534,379$220,298,352
Baseline Funding$12,780,640$18,146,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$167,932,586
Shortfall (Surplus)$7,924,373$6,184,021$7,182,276$5,633,887$6,140,926$5,291,977$3,647,040$3,829,813$3,296,440$3,235,014$52,365,766
Funding Option A
Levy Increase - Facilities0.00%0.50%0.50%0.50%0.25%0.00%0.00%0.00%0.00%0.00%1.75%
Levy Increase - Transportation0.00%2.41%2.41%2.41%2.41%2.41%2.41%2.41%2.41%2.41%21.69%
Total Levy Increase over baseline0.00%2.91%2.91%2.91%2.66%2.41%2.41%2.41%2.41%2.41%23.44%
Levy Increase Included in baseline2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%20.00%
Total Levy Increase - Baseline + New2.00%4.91%4.91%4.91%4.66%4.41%4.41%4.41%4.41%4.41%43.44%
Funding Option B
Levy Increase - Facilities0.00%1.50%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%1.50%
Levy Increase - Transportation0.00%12.62%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%12.62%
Total Levy Increase over baseline0.00%14.12%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%14.12%
Levy Increase Included in baseline2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%20.00%
Total Levy Increase - Baseline + New2.00%16.12%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%34.12%
Combined B2019202020212022202320242025202620272028Total
Transportation Preservation$18,816,452$17,028,993$18,055,072$17,448,114$18,483,753$17,963,192$17,524,838$18,470,631$18,778,940$18,685,018$181,255,003
Transportation Plan$1,670,181$6,788,961$2,758,859$2,869,843$2,772,607$2,772,194$2,768,929$2,773,972$2,827,004$3,292,402$31,294,952
Facilities$218,380$513,065$648,944$470,346$607,193$1,033,987$757,970$935,753$1,005,802$1,556,958$7,748,397
Needs$20,705,013$24,331,018$21,462,875$20,788,302$21,863,554$21,769,373$21,051,737$22,180,356$22,611,746$23,534,379$220,298,352
Baseline Funding$12,780,640$18,146,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$167,932,586
Shortfall (Surplus)$7,924,373$6,184,021$7,182,276$5,633,887$6,140,926$5,291,977$3,647,040$3,829,813$3,296,440$3,235,014$52,365,766
Funding Shortfall
Roads/Bridges-Preservation20192020202120222023202420252026202720287752227.93406246235098412.18747941785190888.77010770893710114.54595335953777541.13063184542502212.04869710281136557.24866618591136504.124428086480049.95922072232-597930.62773738429Transportation Plan2019202020212022202320242025202620272028170180.88458760432788960.559299339541558859.07083934451669842.63263775271972607.28053093241972194.14643989881968929.10840411251973972.08920579122027003.81559157232492402.1945832348Facilities20192020202120222023202420252026202720281963.9813499315351296648.65322123934432527.79905294755253929.63817359542390777.48060193181817570.69662770268541553.54989440856719336.87813083106789385.841952409831340542.3249188561
Notes
Notes
- Signal capital part of roads and bridges
- equipment needs include inflation, all other do not (at this time…)
- many funds where the capital portion is only a part. Percent value used to separate values
- Funding forecasts and targets taken from "Annual Reserve Plan Review Appendix A"
- culvert funding currently in operating budget
- reserve taregt for roads/bridges set equal to current balance. Target was 21M
- PW equipment reserve issue can be resolved by increasing chargeout rates if needed. Reassess in 2 years.
- LPV reserve only covered ARTIFACT buildings
- PCCP could have some facility numbers - 60k
- Signal funding coming from operating or capital?
- reserve targets exclude contingencies
Sheet2
18000$18,000 for Janitor House Roof
28500$28,500 for Court House Parking Lot Maintenance
75000$75,000 for Building Repairs & Maintenance (Court House)
10000$10,000 for Court House Electrical Repairs
45000$45,000 for Court House Heating & Air Conditioning
4500$4,500 for Energy RetroFit
10000$10,000 for Building Repairs (Security Upgrade)
4500$4,500 for Parking Lot Maintenance
159620$159,620 for Garage Maintenance at Douro Dummer
65054$65,054 for Salt and Sand Domes at Douro Dummer
54257$54,257 for Millbrook Garage Maintenance
49336$49,336 for Buckhorn Garage Maintenance
63290$63,290 for Havelock Garage Maintenance
$12,000 for Fencing at Waste Management Depot
$15,000 for Lakefield PCCP Renovation - this building not included in our inventory (leased?)
20000$20,000 for Security at PCCP Facility Is this Armour Road?
25000$25,000 for PCCP Garage Catch BasinIs this Armour Road?
$10,000 for Emergency Repairs at Court House
$18,000 for Clonsilla Building Repairs & Maintenance - this building not included in our inventory
$3,000 for Clonsilla Energy Retro Fit - this building not included in our inventory
$10,000 for Buckhorn PCCP Building Repairs & Maintenance - this building not included in our inventory
$10,000 for Norwood PCCP Building Repairs & Maintenance - this building not included in our inventory
12000$12,000 for Apsley PCCP Building Repairs & Maintenance
644057
Facilities
Asset Class2019202020212022202320242025202620272028TotalAverage/Yr
EMS$17,100$5,380$750$900$5,600$1,150$12,800$10,000$ 53,680$ 5,368
Garage$50,200$ 50,200$ 5,020
Office$138,100$409,330$572,060$433,550$424,240$722,250$577,810$791,410$754,700$1,147,070$ 5,970,520$ 597,052
Quonset$15,000$800$ 15,800$ 1,580
Salt Shed$11,300$42,400$28,200$16,621$70,600$36,960$27,250$20,020$60,251$29,190$ 342,793$ 34,279
Sand Dome$27,380$26,670$20,100$9,450$42,520$18,000$93,060$80,300$87,050$258,960$ 663,490$ 66,349
Storage Garage$1,500$1,800$10,700$211,170$42,800$5,000$35,800$17,600$ 326,370$ 32,637
Tourism$18,400$13,960$3,400$4,800$1,430$640$15,950$31,000$53,890$ 143,470$ 14,347
$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632
Equipment
Department2019202020212022202320242025202620272028TotalAverage/Yr
CORPORATE$65,000$178,000$243,000$ 486,000$ 48,600
EMERGENCY MEASURES$40,000$ 40,000$ 4,000
ENVIRONMENTAL$34,795$ 34,795$ 3,480
PCCP$636,840$660,196$303,566$540,459$636,504$503,742$621,196$303,566$540,459$514,836$ 5,261,364$ 526,136
PUBLIC WORKS$854,135$551,466$434,504$699,166$1,073,008$904,174$842,185$703,015$1,036,992$1,096,115$ 8,194,760$ 819,476
$1,595,975$1,211,662$738,070$1,417,625$1,709,512$1,407,916$1,498,176$1,006,581$1,820,451$1,610,951$ 14,016,919$ 1,401,692
-
26
Transportation Plan – Summary
Transportation Plan 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 TotalFunded (Planned) $1,885,000 $6,360,000 $2,697,284 $360,000 $260,000 $260,000 $260,000 $260,000 $310,000 $760,000 $13,412,284
Unfunded (unplanned) $2,532,219 $2,532,219 $2,532,219 $2,532,219 $2,532,219 $2,532,219 $2,532,219 $17,725,530
Tota l $1,885,000 $6,360,000 $2,697,284 $2,892,219 $2,792,219 $2,792,219 $2,792,219 $2,792,219 $2,842,219 $3,292,219 $31,137,814
• Update to Transportation Master Plan in 2019$57,645,000 Transportation Plan, remaining projects - $1,185,000 Funded in 2018
- $13,412,284 Planned 2019-2028__________________$43,047,716 Unplanned (Unfunded)$ 2,532,219 Per year over next 17 years
Baseline
Needs, Adjusted to 2018 ValuesVariableValueComments
Asset TypeDept20182019202020212022202320242025202620272028TotalAverage/YrFund Source(s)Levy-R&BLevy-CCLevy-SignalsLevy-FacGas TaxOCIFDCLPVCorp EqEnv EqPCCPEM EqPW EqTotalUnfunded TP$43,047,7162013 estimate for unfinished - 2018 carryover - planned
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$ 40,014,635$ 4,001,464Levy, Gas Tax, OCIF$40,014,635$40,014,635Divide by 17 yrs$2,532,219
Cross Culvert$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$ 6,791,000$ 679,100Levy$6,791,000$6,791,000
EquipmentCORP$63,725$164,444$203,332$ 431,502$ 43,150Corp Equip Reserve$431,502$431,502Spending 2019$12,780,640
EquipmentENV$31,351$ 31,351$ 3,135Env Equip Reserve$31,351$31,351Spend Limit cur staff$13,000,000
EquipmentEM$39,409$39,404$55,672$ 134,485$ 13,448EM Equip Reserve$134,485$134,485Staff %6.00%
EquipmentPCCP$627,429$640,827$290,305$509,212$590,841$460,693$559,714$269,479$472,681$443,617$ 4,864,799$ 486,480PCCP Equip Reserve$4,864,799$4,864,799
EquipmentPW$841,512$535,287$415,524$658,743$996,031$826,905$758,831$624,074$906,945$944,486$ 7,508,339$ 750,834PW Equip Reserve$7,508,339$7,508,3391% Levy$411,000
Facility$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632Levy$7,566,322.42$7,566,322
Road$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$ 130,000,000$ 13,000,000Levy, Gas Tax, OCIF, DC$107,562,656$17,227,596$5,209,748$130,000,0002018 Levy
Signals$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$ 260,000$ 26,000Levy, Gas Tax$260,000$260,000
Transportation Plan$1,885,000$6,360,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$ 13,412,284$ 1,341,228Levy, Gas Tax, OCIF, DC$13,412,284$13,412,284
Transportation Plan - Unfunded$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$ 17,725,530$ 1,772,553Levy, Gas Tax, OCIF, DC$16,437,814.12$1,287,716$17,725,530
Staffing (13M Base, 6% above)$451,133$626,378$479,031$445,841$506,705$501,374$460,753$524,637$549,055$601,280$ 5,146,186$ 514,619Levy$2,573,093$2,573,093$5,146,186
$22,542,088$25,242,132$22,168,704$22,208,931$23,538,655$23,184,605$22,489,863$23,217,811$24,282,933$25,010,712$233,886,434$23,388,643Need$166,588,198$6,791,000$260,000$10,139,416$17,227,596$5,209,748$14,700,000$431,502$31,351$4,864,799$134,485$7,508,339$233,886,434
Reserve OpenTargetForecastAvailable
Levy - Roads+Bridges7,584,0857,584,0857,858,828$8,680,828$9,520,713$10,377,395$11,251,211$12,142,503$13,051,621$13,978,922$14,924,768$15,889,531$16,873,590$134,275,167$126,691,082Available$126,691,082$1,840,000$100,000$2,164,160$17,227,596$5,209,748$14,700,000$521,838$59,070$8,317,307$130,294$7,146,869$184,107,965
Levy - Cross Culverts00184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$1,840,000$1,840,000(Funding Gap)/Surplus($39,897,116)($4,951,000)($160,000)($7,975,256)$90,336$27,719$3,452,508($4,190)($361,470)
Levy - Signals0010,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$100,000$100,000Funding Gap -Levy, excl Eq($52,983,372)
Levy - Facilities00216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160$2,164,160Annual Levy Funding Gap($5,298,337)
(Levy) LPV000Annual Levy Increase12.89%
(Levy) Corp Eq112,017
David: David:Assume Server = 80% of IT network, Server, Applications36,72326,629$26,629$31,105$35,395$39,505$43,440$47,206$50,807$54,249$57,536$60,674$558,561$521,83840.00%
(Levy) Env Eq40,00040,0004,278$4,278$4,894$5,491$6,070$6,630$6,532$6,435$6,340$6,246$6,154$99,070$59,070
(Levy) PCCP Eq1,587,8293,727,017806,920$806,920$851,888$899,567$950,127$1,003,746$1,060,618$1,120,945$1,184,944$1,252,846$1,324,894$12,044,324$8,317,307
(Levy) EM Eq30,00060,00012,414$12,414$13,978$15,492$16,959$17,544$17,285$17,029$16,778$16,530$16,286$190,294$130,29490.00%$ 220,915,958
(Levy) PW Eq3,476,5162,950,776640,394$640,394$645,126$649,893$654,696$659,533$664,406$669,315$674,261$679,243$684,263$10,097,645$7,146,869
Gas Tax$1,692,246$1,692,246$1,769,166$1,769,166$1,846,087$1,691,737$1,691,737$1,691,737$1,691,737$1,691,737$17,227,596$17,227,596
DC - Roads4,500,0000$1,500,000$1,500,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$14,700,000$14,700,000
OCIF00$497,150$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$5,209,748$5,209,748
$14,271,275$15,193,987$15,886,438$16,821,771$17,453,521$18,273,442$19,269,229$20,287,115$21,327,707$22,391,635$198,506,566$184,107,965
43091.360155375
Excluding Equipment
Needs (Excluding Equipment)$20,970,013$24,066,018$21,462,875$20,876,531$21,951,783$21,857,602$21,139,966$22,268,586$22,699,975$23,622,608$220,915,958822,000
Funding (Including Equipment)$9,759,879$12,780,640$13,646,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$163,432,586
Reserve Adjustment RB
Reserve Adjustment DC$4,500,000$4,500,000
Shortfall (Excl Equipment)$8,189,373$5,919,021$7,182,276$5,722,116$6,229,155$5,380,206$3,735,269$3,918,043$3,384,669$3,323,243$52,983,372
Levy Shortfall Excl Equip %19.93%14.40%17.48%13.92%15.16%13.09%9.09%9.53%8.24%8.09%
Unadjusted Values12345678910
Asset TypeDepartment2019202020212022202320242025202620272028TotalAverage/Yr
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$ 40,014,635$ 4,001,464Manual Workplan41335635
Cross Culvert$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$ 6,791,000$ 679,1009 Year AAC4068959
EquipmentCORP$65,000$178,000$243,000$ 486,000$ 48,6002.00%
EquipmentENV$34,795$ 34,795$ 3,4801.50%
EquipmentEM$40,000$43,086$62,714$ 145,800$ 14,5801.50%
EquipmentPCCP$636,840$660,196$303,566$540,459$636,504$503,742$621,196$303,566$540,459$514,836$ 5,261,364$ 526,1361.50%
EquipmentPW$854,135$551,466$434,504$699,166$1,073,008$904,174$842,185$703,015$1,036,992$1,096,115$ 8,194,760$ 819,4761.50%
Facility$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632
Road$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$ 130,000,000$ 13,000,000
Signals$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$ 260,000$ 26,000
Transportation Plan$1,885,000$6,360,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$ 13,412,284$ 1,341,228
Transportation Plan - Unfunded$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$ 17,725,530$ 1,772,553
$22,114,855$24,651,302$21,721,914$21,848,315$23,154,591$22,807,231$22,177,390$22,813,244$23,971,371$24,632,280$229,892,491$22,989,249
Reserve OpenTargetAddn + OpeningAvailable (less target)Infl%Cap%
Levy - Roads+Bridges7,584,0857,584,085$8,680,828$9,520,713$10,377,395$11,251,211$12,142,503$13,051,621$13,978,922$14,924,768$15,889,531$16,873,590$134,275,167$126,691,0820.00%100.00%
Levy - Cross Culverts00$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$1,840,000$1,840,000100.00%Capital portion in operating budget
Levy - Signals00$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$100,000$100,000100.00%Capital portion in operating account
Levy - Facilities00$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160$2,164,160100.00%Capital portion in Operating budget, should have a reserve acct
(Levy) LPV00$63,000$63,000$63,000$63,000$63,000$63,000$63,000$63,000$63,000$63,000$630,000$630,0000.00%Fund seem to only be for artifact buildings
(Levy) Corp Eq112,017
David: David:Assume Server = 80% of IT network, Server, Applications
David: David:Assume Server = 80% of IT network, Server, Applications36,723$67,903$80,903$93,903$106,903$119,903$132,903$145,903$158,903$171,903$184,903$1,376,047$1,339,3242.00%40.00%
(Levy) Env Eq40,00040,000$31,015$36,015$41,015$46,015$51,015$51,015$51,015$51,015$51,015$51,015$500,150$460,1501.50%14.00%
(Levy) PCCP1,587,8293,727,017$819,024$877,636$940,658$1,008,430$1,081,320$1,159,726$1,244,075$1,334,831$1,432,491$1,537,593$13,023,613$9,296,5961.50%100.00%
(Levy) EM30,00060,000$14,000$16,000$18,000$20,000$21,000$21,000$21,000$21,000$21,000$21,000$224,000$164,0001.50%90.00%
(Levy) PW3,476,5162,950,776$650,000$664,625$679,579$694,870$710,504$726,490$742,836$759,550$776,640$794,115$10,675,725$7,724,9491.50%100.00%
Gas Tax$1,692,246$1,692,246$1,769,166$1,769,166$1,846,087$1,691,737$1,691,737$1,691,737$1,691,737$1,691,737$17,227,596$17,227,596100.00%
DC4,500,0000$1,500,000$1,500,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$14,700,000$14,700,000100.00%
OCIF00$497,150$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$5,209,748$5,209,748100.00%
$14,425,582$15,385,176$16,116,754$17,093,633$17,769,370$18,631,530$19,672,526$20,738,842$21,831,355$22,950,991$187,547,605
Options
SPENDING
Asset TypeDept20182019202020212022202320242025202620272028TotalAverage/YrFund Source(s)Levy-R&BLevy-CCLevy-SignalsLevy-FacGas TaxDCOCIFLPVCorp EqEnv EqPCCPEM EqPW EqTotal
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$ 40,014,635$ 4,001,464Levy, Gas Tax, OCIF$40,014,635$40,014,635
Cross Culvert$479,100$579,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$679,100$ 6,491,000$ 649,100Levy$6,491,000$6,491,000
EquipmentCORP$63,725$164,444$203,332$ 431,502$ 43,150Corp Equip Reserve$431,502$431,502
EquipmentENV$31,351$ 31,351$ 3,135Env Equip Reserve$31,351$31,351
EquipmentEM$39,409$39,404$55,672$ 134,485$ 13,448EM Equip Reserve$134,485$134,485
EquipmentPCCP$627,429$640,827$290,305$509,212$590,841$460,693$559,714$269,479$472,681$443,617$ 4,864,799$ 486,480PCCP Equip Reserve$4,864,799$4,864,799
EquipmentPW$841,512$535,287$415,524$658,743$996,031$826,905$758,831$624,074$906,945$944,486$ 7,508,339$ 750,834PW Equip Reserve$7,508,339$7,508,339
Facility$213,780$499,540$634,460$460,371$593,260$1,010,410$741,560$913,830$981,601$1,517,510$ 7,566,322$ 756,632Levy$7,566,322.42$7,566,322
Road$6,000,000$7,000,000$8,000,000$11,000,000$11,000,000$13,000,000$13,000,000$13,000,000$13,000,000$13,000,000$ 108,000,000$ 10,800,000Levy, Gas Tax, OCIF, DC$85,562,656$17,227,596$5,209,748$108,000,000
Signals$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$26,000$ 260,000$ 26,000Levy, Gas Tax$260,000$260,000
Transportation Plan$1,885,000$6,360,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$ 13,412,284$ 1,341,228Levy, Gas Tax, OCIF, DC$13,412,284$13,412,284
Transportation Plan - Unfunded$2,532,219$1,000,000$500,000$500,000$500,000$1,200,000$1,200,000$ 7,432,219$ 743,222$ 10,293,312Levy, Gas Tax, OCIF, DC$7,432,219$1,287,716$8,719,935
Staffing (13M Base, 6% above)$113,457$330,945$221,380$405,785$389,984$459,061$419,813$459,657$564,100$604,633$ 3,968,816$ 396,882Levy$2,778,171$1,190,644.84$3,968,816
TOTAL SPENDING$15,004,413$18,846,699$16,911,053$20,168,875$19,889,716$21,110,073$20,416,705$21,120,612$22,965,759$23,681,847$200,115,752$20,011,575Need$135,787,681$6,491,000$260,000$8,756,967$17,227,596$14,700,000$5,209,748$431,502$31,351$4,864,799$134,485$7,508,339$201,403,468
FUNDING
NEW MONEYReserve OpenTarget2018ForecastAvailableDiff
Levy - Roads+Bridges7,584,0857,584,0857,858,828.00$8,680,828$9,931,713$10,788,395$12,073,211$12,964,503$13,873,621$14,800,922$15,746,768$16,711,531$17,695,590$133,267,082$133,267,082Available$133,267,082$1,840,000$100,000$5,554,910$17,227,596$14,700,000$5,209,748$521,838$59,070$8,317,307$130,294$7,146,869$194,074,715
Levy - Cross Culverts00184,000.00$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$184,000$1,840,000$1,840,000(Funding Gap)/Surplus($2,520,599)($4,651,000)($160,000)($3,202,057)$90,336$27,719$3,452,508($4,190)($361,470)
Levy - Signals0010,000.00$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$100,000$100,000Funding Gap -Levy, excl Eq($10,533,656)
Levy - Facilities00216,416.00$216,416$421,916$524,666$627,416$627,416$627,416$627,416$627,416$627,416$627,416$5,554,910$5,554,910Annual Levy Funding Gap($1,053,366)0.00%0.00%0.00%
(Levy) LPV000.00Annual Levy Increase2.56%
(Levy) Corp Eq112,01736,72326,628.63$26,629$31,105$35,395$39,505$43,440$47,206$50,807$54,249$57,536$60,674$446,544$521,838$75,294
(Levy) Env Eq40,00040,0004,277.93$4,278$4,894$5,491$6,070$6,630$6,532$6,435$6,340$6,246$6,154$59,070$59,070
(Levy) PCCP Eq1,587,8293,727,017806,920.20$806,920$851,888$899,567$950,127$1,003,746$1,060,618$1,120,945$1,184,944$1,252,846$1,324,894$10,456,495$8,317,307($2,139,188)
(Levy) EM Eq30,00060,00012,413.79$12,414$13,978$15,492$16,959$17,544$17,285$17,029$16,778$16,530$16,286$160,294$130,294($30,000)
(Levy) PW Eq3,476,5162,950,776640,394.09$640,394$645,126$649,893$654,696$659,533$664,406$669,315$674,261$679,243$684,263$6,621,129$7,146,869$525,740
Gas Tax000.00$1,692,246$1,692,246$1,769,166$1,769,166$1,846,087$1,691,737$1,691,737$1,691,737$1,691,737$1,691,737$17,227,596$17,227,596
DC - Roads4,500,00000.00$1,500,000$1,500,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$10,200,000$14,700,000$4,500,000
OCIF000.00$497,150$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$523,622$5,209,748$5,209,748
Total$17,330,447$14,398,601$9,759,879$14,271,275$15,810,487$16,605,688$18,054,771$18,686,521$19,506,442$20,502,229$21,520,115$22,560,707$23,624,635$191,142,870$194,074,715$2,931,846
FROM/TO RESERVE
Levy - Roads+Bridges
DC - Roads$4,500,000$4,500,000
PCCP($851,888)($899,567)($387,733)($2,139,188)
Total Reserve Adjustments$3,648,112($899,567)($387,733)$2,360,812
Net Funding$14,271,275$19,458,599$15,706,120$17,667,038$18,686,521$19,506,442$20,502,229$21,520,115$22,560,707$23,624,635$193,503,682
LEVY (incl Equipment)
Baseline$9,759,879$12,780,640$13,646,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365
Proposed, Levy only$10,581,879$12,094,619$13,112,900$14,561,983$15,516,812$16,491,083$17,486,870$18,504,756$19,545,348$20,609,276
Increase over Baseline($2,198,761)($1,552,378)($1,167,699)($592,432)($205,816)$13,687$82,173$154,213$230,042$309,911
Incr over Previous Year (Baseline + Proposed)2.00%1.57%0.94%1.40%0.94%0.53%0.17%0.18%0.18%0.19%
Incr over Baseline0.00%-3.78%-2.84%-1.44%-0.50%0.03%0.20%0.38%0.56%0.75%
Incr over 20182.00%5.68%8.16%11.68%14.01%16.38%18.80%21.28%23.81%26.40%
Excluding Equipment
Total Needs Excl Eq$13,432,337$17,670,585$16,205,224$18,836,475$18,302,844$19,783,071$19,066,808$20,171,387$21,382,801$22,293,743$187,145,276$188,432,992
Total Funding Excl Eq$12,780,640$18,763,497$14,999,849$16,387,415$16,955,628$17,710,396$18,637,697$19,583,543$20,548,306$21,532,365$177,899,336$177,899,3364,500,000
Shortfall$651,697($1,092,912)$1,205,375$2,449,060$1,347,216$2,072,675$429,111$587,844$834,495$761,378$9,245,940
Shortfall(Surplus) Levy %1.59%-2.66%2.93%5.96%3.28%5.04%1.04%1.43%2.03%1.85%
SPENDINGApply?TotalRationalImplicationsRisk Mitigation
Cross Culverts, ramp up100.00%($200,000)($100,000)($300,000)Ramp up, planUnplanned failurePrioritize very poor
Roads, ramp up100.00%($7,000,000)($6,000,000)($5,000,000)($2,000,000)($2,000,000)($22,000,000)Ramp up, planMissed savings oppReduce Reconstruction
TP, defer new projects100.00%($1,532,219)($2,032,219)($2,032,219)($2,032,219)($1,332,219)($1,332,219)($10,293,312)Optional, prioritize preservationCongestion
Reduce staffing increase0.00%($451,133)($626,378)($479,031)($445,841)($506,705)($501,374)($460,753)($524,637)($549,055)($601,280)($5,146,186)
($7,651,133)($6,726,378)($5,479,031)($2,445,841)($4,038,923)($2,533,592)($2,492,971)($2,556,856)($1,881,274)($1,933,498)($32,593,312)
REVENUETotal
Levy - Facilities100.00%$205,500$308,250$411,000$411,000$411,000$411,000$411,000$411,000$411,000$3,390,750
Levy - Trans Plan100.00%$411,000$411,000$822,000$822,000$822,000$822,000$822,000$822,000$822,000$6,576,000
Levy Change over baseline$616,500$719,250$1,233,000$1,233,000$1,233,000$1,233,000$1,233,000$1,233,000$1,233,000$9,966,750
Levy Change %0.00%1.50%1.75%3.00%3.00%3.00%3.00%3.00%3.00%3.00%
Levy change over PY1.50%0.25%1.25%0.00%0.00%0.00%0.00%0.00%0.00%
Cumulative Levy Change, with changesBase$10,581,8790.00%3.68%6.16%9.68%12.01%14.38%16.80%19.28%21.81%24.40%
Cumulative Levy Change, no changesBase$10,581,8790.00%2.18%4.41%6.68%9.01%11.38%13.80%16.28%18.81%21.40%
Trans PlanFac
Unfunded$17,725,530$5,402,162
Spending Reduction($10,293,312)
Rev Increase($6,576,000)($3,390,750)
$856,219$2,011,412
Pres_Needs
Asset Type2019202020212022202320242025202620272028TotalAverage/YrAsset TypeAverage/YrHistoric AvgGap
Bridges/Culverts$4,818,665$2,951,829$4,037,104$3,446,606$4,457,388$3,938,850$3,516,989$4,437,342$4,736,566$4,624,202$40,965,541$4,096,554Bridges/Culverts$4,096,554$2,137,275$1,959,279$950,906
Cross Culvert$694,031$697,248$694,603$693,919$695,146$695,043$694,231$695,485$695,933$696,837$6,952,476$695,248Cross Culvert$695,248$184,000$511,248$161,476
Equipment$1,572,075$1,176,114$705,829$1,332,400$1,586,872$1,327,003$1,349,897$949,225$1,582,958$1,388,104$12,970,476$1,297,048Equipment$1,297,048$1,123,500$173,548
Facility$218,480$512,889$648,944$470,418$607,278$1,034,131$758,083$935,879$1,005,932$1,557,145$7,749,178$774,918Facility$774,918$216,416$558,502
Road$13,285,821$13,347,399$13,296,771$13,283,688$13,307,164$13,305,197$13,289,653$13,313,663$13,322,231$13,339,539$133,091,127$13,309,113Road$13,309,113$4,388,936$8,920,177
Signals$26,572$26,695$26,594$26,567$26,614$26,610$26,579$26,627$26,644$26,679$266,182$26,618Signals$26,618$10,000$16,618
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454$3,189,145Transportation Plan$3,189,145$961,963$2,227,182
Total$22,542,088$25,242,132$22,168,704$22,208,931$23,538,655$23,184,605$22,489,863$23,217,811$24,282,933$25,010,712$233,886,434$23,388,643Total$23,388,643$9,022,090$14,366,553
Excl Eq$220,915,958
Staff Cost$451,133$626,378$479,031$445,841$506,705$501,374$460,753$524,637$549,055$601,280$5,146,186
Staff Base$20,518,880$23,439,640$20,983,844$20,430,690$21,445,079$21,356,229$20,679,214$21,743,949$22,150,920$23,021,329
Staff Cost %0.0219860.0267230.0228290.0218220.0236280.0234770.0222810.0241280.0247870.026118
Opening+ Levy- 10 Year Needs= Forecast- Reserve Target= Over(Under)
(Levy) Corp Eq$112,017$446,544($431,502)$127,060$36,723$90,336
(Levy) Env Eq$40,000$59,070($31,351)$67,719$40,000$27,719
(Levy) PCCP Eq$1,587,829$10,456,495($4,864,799)$7,179,525$3,727,017$3,452,508
(Levy) EM Eq$30,000$160,294($134,485)$55,810$60,000($4,190)
(Levy) PW Eq$3,476,516$6,621,129($7,508,339)$2,589,306$2,950,776($361,470)
Bridge and Culverts, without staffing
Asset Type2019202020212022202320242025202620272028TotalAverage/Yr
Bridges/Culverts$4,715,000$2,875,000$3,947,000$3,373,000$4,354,500$3,848,500$3,440,335$4,332,800$4,622,000$4,506,500$40,014,635$4,001,464
Transportation Plan2019202020212022202320242025202620272028Total
Funded (Planned)$1,885,000$6,360,000$2,697,284$360,000$260,000$260,000$260,000$260,000$310,000$760,000$13,412,284
Unfunded (unplanned)$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$2,532,219$17,725,530
Total$1,885,000$6,360,000$2,697,284$2,892,219$2,792,219$2,792,219$2,792,219$2,792,219$2,842,219$3,292,219$31,137,814
Pres_Funding_xEq
Asset TypeFund Source(s)NeedLevy-R&BLevy-CCLevy-SignalsLevy-FacGas TaxOCIFDCTOTAL
Bridges/CulvertsLevy, Gas Tax, OCIF$40,965,541$40,965,541$40,965,541
Cross CulvertLevy$6,952,476$6,952,476$6,952,476
FacilityLevy$7,749,178$7,749,178$7,749,178
RoadLevy, Gas Tax, OCIF, DC$133,091,127$110,653,783$17,227,596$5,209,748$133,091,127
SignalsLevy, Gas Tax$266,182$266,182$266,182
Transportation PlanLevy, Gas Tax, OCIF, DC$31,891,454$17,191,454$14,700,000$31,891,454
Total Needs$220,915,958$168,810,778$6,952,476$266,182$7,749,178$17,227,596$5,209,748$14,700,000$220,915,958
Baseline Funding$126,691,082$1,840,000$100,000$2,164,160$17,227,596$5,209,748$14,700,000$167,932,586
Funding Shortfall$42,119,696$5,112,476$166,182$5,585,018$52,983,372
Asset TypeFund Source(s)NeedLevy-TransLevy-FacGas TaxOCIFDCTOTAL36.27%
Transportation-PreservationLevy, Gas Tax, OCIF, DC$181,275,326$158,837,982$17,227,596$5,209,748$181,275,326
Transportation PlanLevy, Gas Tax, OCIF, DC$31,891,454$17,191,454$14,700,000$31,891,454
FacilitiesLevy$7,749,178$7,749,178$7,749,178
Total Needs$220,915,958$176,029,436$7,749,178$17,227,596$5,209,748$14,700,000$220,915,958
Baseline Funding$128,631,082$2,164,160$17,227,596$5,209,748$14,700,000$167,932,586
Funding Shortfall$47,398,354$5,585,018$52,983,372
Asset TypeFund Source(s)NeedLevy-TransGas TaxOCIFDCTOTAL
Transportation-PreservationLevy, Gas Tax, OCIF, DC$213,166,780$176,029,436$17,227,596$5,209,748$14,700,000$213,166,780
Total Needs$213,166,780$176,029,436$17,227,596$5,209,748$14,700,000$213,166,780
Available Funding$128,631,082$17,227,596$5,209,748$14,700,000
Funding Shortfall$47,398,354
NeedFundingShortfall
Transportation-Preservation$181,275,326$151,068,426$30,206,900
Transportation Plan$31,891,454$14,700,000$17,191,454
Subtotal - Transportation$213,166,780$165,768,426$47,398,354
Facilities$7,749,178$2,164,160$5,585,018
Total$220,915,958$167,932,586$52,983,372
Sheet1
12345678910
20182019202020212022202320242025202620272028
County Levy41,170,80041,994,21642,834,10043,690,78244,564,59845,455,89046,365,00847,292,30848,238,15449,202,91750,186,975
Increase %2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%
Levy Increase823,416839,884856,682873,816891,292909,118927,300945,846964,763984,058
839884.32
Pres_10Yr_xEq
Asset Type2019202020212022202320242025202620272028Total$411,7081% Levy
Roads/Bridges-PreservationNeeds$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326$41,170,8002018 Levy
Available$11,064,224$11,930,581$12,864,183$13,737,999$14,706,212$15,460,980$16,388,281$17,334,127$18,298,890$19,282,949$151,068,426151068426
Shortfall$7,760,865$5,092,590$5,190,889$3,712,782$3,780,101$2,504,721$1,139,171$1,138,991$482,484($595,692)$30,206,900
Transportation PlanNeeds$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454
Available$1,500,000$6,000,000$1,200,000$1,200,000$800,000$800,000$800,000$800,000$800,000$800,000$14,700,000
Shortfall$426,444$529,959$1,558,859$1,755,333$2,058,193$2,057,771$2,054,432$2,059,589$2,112,669$2,578,206$17,191,454
FacilitiesNeeds$218,480$512,889$648,944$470,418$607,278$1,034,131$758,083$935,879$1,005,932$1,557,145$7,749,178
Baseline Funding$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160
Shortfall$2,064$296,473$432,528$254,002$390,862$817,715$541,667$719,463$789,516$1,340,729$5,585,018
AllNeeds$20,970,013$24,066,018$21,462,875$20,876,531$21,951,783$21,857,602$21,139,966$22,268,586$22,699,975$23,622,608$220,915,958
Available$12,780,640$18,146,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$167,932,586
Shortfall$8,189,373$5,919,021$7,182,276$5,722,116$6,229,155$5,380,206$3,735,269$3,918,043$3,384,669$3,323,243$52,983,372
2019202020212022202320242025202620272028
Roads/Bridges-Preservation$7,760,865$5,092,590$5,190,889$3,712,782$3,780,101$2,504,721$1,139,171$1,138,991$482,484($595,692)
Transportation Plan$426,444$529,959$1,558,859$1,755,333$2,058,193$2,057,771$2,054,432$2,059,589$2,112,669$2,578,206
Facilities$2,064$296,473$432,528$254,002$390,862$817,715$541,667$719,463$789,516$1,340,729
Facilities - Fully Funded A2019202020212022202320242025202620272028Total
Needs$218,480$512,889$648,944$470,418$607,278$1,034,131$758,083$935,879$1,005,932$1,557,145$7,749,178
Baseline Funding$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160
Shortfall (Surplus)$2,064$296,473$432,528$254,002$390,862$817,715$541,667$719,463$789,516$1,340,729$5,585,018
Starting Levy Base$41,170,800$41,170,800$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362$41,788,362
Yearly Levy Adjustment$617,562
Cumulative Levy Adjustment$617,562$617,562$617,562$617,562$617,562$617,562$617,562$617,562$617,562$5,558,058
Levy increase - over current1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%
Levy increase - year over year1.50%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%1.50%
Adjusted Funding$216,416$833,978$833,978$833,978$833,978$833,978$833,978$833,978$833,978$833,978$7,722,218
Adjusted Shortfall (Surplus)$2,064($321,089)($185,034)($363,560)($226,700)$200,153($75,895)$101,901$171,954$723,167$26,960
Facilities - Fully Funded B2019202020212022202320242025202620272028Total
Needs$218,480$512,889$648,944$470,418$607,278$1,034,131$758,083$935,879$1,005,932$1,557,145$7,749,178
Baseline Funding$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$216,416$2,164,160
Shortfall$2,064$296,473$432,528$254,002$390,862$817,715$541,667$719,463$789,516$1,340,729$5,585,018
Starting Levy Base$41,170,800$41,170,800$41,376,654$41,583,537$41,791,455$41,895,934$41,895,934$41,895,934$41,895,934$41,895,934
Yearly Levy Adjustment$205,854$206,883$207,918$104,479
Cumulative Levy Adjustment$205,854$412,737$620,655$725,134$725,134$725,134$725,134$725,134$725,134$5,590,048
Levy increase - over current1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%
Levy increase - year over year0.50%0.50%0.50%0.25%0.00%0.00%0.00%0.00%0.00%1.75%
Adjusted Funding$216,416$422,270$629,153$837,071$941,550$941,550$941,550$941,550$941,550$941,550$7,754,208
Adjusted Shortfall (Surplus)$2,064$90,619$19,791($366,653)($334,272)$92,581($183,467)($5,671)$64,383$615,595($5,030)
2% of replacement$711,382
Transportation - Fully Funded A2019202020212022202320242025202620272028Total
Transportation Preservation$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454
Subtotal - Needs$20,751,533$23,553,129$20,813,931$20,406,114$21,344,506$20,823,471$20,381,884$21,332,707$21,694,043$22,065,463$213,166,780
Baseline Funding$12,564,224$17,930,581$14,064,183$14,937,999$15,506,212$16,260,980$17,188,281$18,134,127$19,098,890$20,082,949$165,768,426
Shortfall (Surplus)$8,187,309$5,622,548$6,749,748$5,468,115$5,838,294$4,562,491$3,193,603$3,198,580$2,595,153$1,982,514$47,398,354
Reduced Road Preservation
Reduced Transportation Plan
Starting Levy Base$41,170,800$41,170,800$46,436,545$46,436,545$46,436,545$46,436,545$46,436,545$46,436,545$46,436,545$46,436,5450.00%Annual Levy Base Increase
Yearly Levy Adjustment$5,265,745
Cumulative Levy Adjustment$5,265,745$5,265,745$5,265,745$5,265,745$5,265,745$5,265,745$5,265,745$5,265,745$5,265,745$47,391,708
Levy increase - year over year12.79%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%12.79%
Transportation Preservation$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454
Adjusted Funding$12,564,224$23,196,326$19,329,928$20,203,744$20,771,957$21,526,725$22,454,026$23,399,872$24,364,635$25,348,694$213,160,134
Adjusted Shortfall (Surplus)$8,187,309$356,803$1,484,003$202,369$572,548($703,254)($2,072,143)($2,067,166)($2,670,593)($3,283,231)$6,646
Transportation - Fully Funded B2019202020212022202320242025202620272028Total
Transportation Preservation$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454
Subtotal - Transportation Needs$20,751,533$23,553,129$20,813,931$20,406,114$21,344,506$20,823,471$20,381,884$21,332,707$21,694,043$22,065,463$213,166,780
Baseline Funding$12,564,224$17,930,581$14,064,183$14,937,999$15,506,212$16,260,980$17,188,281$18,134,127$19,098,890$20,082,949$165,768,426
Shortfall (Surplus)$8,187,309$5,622,548$6,749,748$5,468,115$5,838,294$4,562,491$3,193,603$3,198,580$2,595,153$1,982,514$47,398,354
Reduced Road Preservation
Reduced Transportation Plan
Starting Levy Base$41,170,800$41,992,800$43,773,324$45,610,528$47,506,020$49,461,447$51,478,501$53,558,921$55,704,487$57,917,0300.00%Annual Levy Base Increase
Yearly Levy Adjustment$940,639$980,522$1,021,676$1,064,135$1,107,936$1,153,118$1,199,720$1,247,780$1,297,3411Adjust Base with 2% plan, 1= yes
Cumulative Levy Adjustment$940,639$1,921,161$2,942,837$4,006,972$5,114,908$6,268,027$7,467,747$8,715,527$10,012,868$47,390,6860.16%Annual levy % reduction
Levy increase - year over year2.24%2.24%2.24%2.24%2.24%2.24%2.24%2.24%2.24%20.16%
Transportation Preservation$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454
Adjusted Funding$12,564,224$18,871,220$15,985,344$17,880,836$19,513,184$21,375,888$23,456,308$25,601,874$27,814,417$30,095,817$213,159,112
Adjusted Shortfall (Surplus)$8,187,309$4,681,909$4,828,587$2,525,278$1,831,322($552,417)($3,074,424)($4,269,167)($6,120,374)($8,030,354)$7,668
Combined2019202020212022202320242025202620272028Total
Transportation Preservation$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454$213,166,780
Facilities$218,480$512,889$648,944$470,418$607,278$1,034,131$758,083$935,879$1,005,932$1,557,145$7,749,178
Needs$20,970,013$24,066,018$21,462,875$20,876,531$21,951,783$21,857,602$21,139,966$22,268,586$22,699,975$23,622,608$220,915,958
Baseline Funding$12,780,640$18,146,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$167,932,586
Shortfall (Surplus)$8,189,373$5,919,021$7,182,276$5,722,116$6,229,155$5,380,206$3,735,269$3,918,043$3,384,669$3,323,243$52,983,372
Funding Option A - Immediate
Levy Increase - Facilities0.00%1.50%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%1.50%
Levy Increase - Transportation0.00%12.79%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%12.79%
Total Levy Increase over baseline0.00%14.29%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%14.29%
Levy Increase Included in baseline2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%20.00%
Total Levy Increase - Baseline + New2.00%16.29%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%34.29%
Funding Option B - Incremental
Levy Increase - Facilities0.00%0.50%0.50%0.50%0.25%0.00%0.00%0.00%0.00%0.00%1.75%
Levy Increase - Transportation0.00%2.24%2.24%2.24%2.24%2.24%2.24%2.24%2.24%2.24%20.16%
Total Levy Increase over baseline0.00%2.74%2.74%2.74%2.49%2.24%2.24%2.24%2.24%2.24%21.91%
Levy Increase Included in baseline2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%20.00%
Total Levy Increase - Baseline + New2.00%4.74%4.74%4.74%4.49%4.24%4.24%4.24%4.24%4.24%41.91%
Combined B2019202020212022202320242025202620272028Total
Transportation Preservation$18,825,089$17,023,171$18,055,072$17,450,781$18,486,313$17,965,701$17,527,452$18,473,118$18,781,374$18,687,257$181,275,326
Transportation Plan$1,926,444$6,529,959$2,758,859$2,955,333$2,858,193$2,857,771$2,854,432$2,859,589$2,912,669$3,378,206$31,891,454
Facilities$218,480$512,889$648,944$470,418$607,278$1,034,131$758,083$935,879$1,005,932$1,557,145$7,749,178
Needs$20,970,013$24,066,018$21,462,875$20,876,531$21,951,783$21,857,602$21,139,966$22,268,586$22,699,975$23,622,608$220,915,958
Baseline Funding$12,780,640$18,146,997$14,280,599$15,154,415$15,722,628$16,477,396$17,404,697$18,350,543$19,315,306$20,299,365$167,932,586
Shortfall (Surplus)$8,189,373$5,919,021$7,182,276$5,722,116$6,229,155$5,380,206$3,735,269$3,918,043$3,384,669$3,323,243$52,983,372
Reduce SpendingReduced Spending + Levy
TransportationTotalAdjustment