|
|
|
|
|
| TOWN OF CARY, NORTH
CAROLINA |
|
|
|
|
| SEWER PROJECT SUB-FUND |
|
|
|
|
| SCHEDULE OF
REVENUES, EXPENDITURES, AND |
|
|
|
| CHANGES IN FUND NET
ASSETS |
|
|
|
|
| BUDGET AND ACTUAL
(NON-GAAP) |
|
|
|
|
| From Inception To June 30, 2006 |
|
|
|
|
|
|
|
|
|
| Schedule
12 |
|
|
|
|
|
|
|
Actual |
|
|
Project |
Prior |
Current |
Total |
|
Authorization |
Years |
Year |
To Date |
| REVENUES |
|
|
|
|
|
|
|
|
|
| Intergovernmental
Grants |
$1,564,750 |
1,359,156 |
205,594 |
1,564,750 |
| Investment
Earnings |
117,561 |
117,561 |
--- |
117,561 |
| Developer
Reimbursements (Paid by Developers) |
64,953 |
64,953 |
41,050 |
106,003 |
| Miscellaneous
Reimbursements |
142,500 |
142,500 |
--- |
142,500 |
| Sub-total |
1,889,764 |
1,684,170 |
246,644 |
1,930,814 |
| Less: Completed Projects |
(1,314,750) |
(1,109,156) |
(205,594) |
(1,314,750) |
| TOTAL
REVENUES |
575,014 |
575,014 |
41,050 |
616,064 |
|
|
|
|
|
|
|
|
|
|
| EXPENDITURES |
|
|
|
|
|
|
|
|
|
| Asset-Related
Projects |
|
|
|
|
| Annexation
Sewer Lines - Doylin Dr. * |
75,665 |
75,665 |
--- |
75,665 |
| Annexation
Sewer Lines - Frostwood Dr. * |
185,730 |
185,730 |
--- |
185,730 |
| Annexation
Sewer Lines - Greenwood Acres |
1,080,000 |
--- |
129,679 |
129,679 |
| Annexation
Sewer Lines - Hazelwood Sewer |
190,000 |
--- |
--- |
--- |
| Annexation
Sewer Lines - Hillsdale Forest |
1,320,000 |
241,266 |
767,220 |
1,008,486 |
| Annexation
Sewer Lines - Larkwood Ln. * |
384,381 |
370,145 |
14,237 |
384,382 |
| Annexation
Sewer Lines - Summerwinds 1 & 2 |
1,400,000 |
--- |
--- |
--- |
| Annexation
Sewer Lines - Triangle Forest * |
414,809 |
23,071 |
391,738 |
414,809 |
Annexation
Sewer Lines - Tryon Road
(Summerwinds) * |
130,000 |
--- |
130,000 |
130,000 |
| Annexation
Sewer Lines - Wild Weasel Way |
145,000 |
--- |
--- |
--- |
| Annexation
Sewer Lines - Windsor Oaks |
1,520,359 |
--- |
25,954 |
25,954 |
| Annexation
Sewer Lines - Woodland Dr. |
250,000 |
--- |
--- |
--- |
| Annexation
Sewer Lines - 2104 Piney Plains |
250,000 |
--- |
--- |
--- |
Annexation
Sewer Lines - 9520 Chapel
Hill Rd. * |
38,432 |
36,531 |
1,901 |
38,432 |
| Annexation
Sewer Lines - Main Project |
1,615,624 |
8,107 |
(7,943) |
164 |
Bachelor
Branch Interceptor & Pump Station
Elimination |
1,950,000 |
--- |
--- |
--- |
| Camp
Branch 'Reach A' Interceptor |
1,580,000 |
29,907 |
173,892 |
203,799 |
| Cape
Fear Discharge Planning/Permitting |
374,977 |
286,251 |
115,647 |
401,898 |
| East
Kit Creek Sewer Interceptor * |
103,952 |
--- |
103,952 |
103,952 |
| Fairfield
Inn Pump Station Elimination * |
495,000 |
276,898 |
13,326 |
290,224 |
| Fieldstone
Pump Station Improvement |
337,474 |
--- |
--- |
--- |
Hollybrook
Sewer Extension Pump Station
Elimination |
1,460,000 |
21,000 |
--- |
21,000 |
| Asset-Related
Projects (cont'd) |
|
|
|
|
| Inflow/Infiltration
SS Overflow Rehabilitation |
$350,000 |
--- |
--- |
--- |
| Kit
Creek Basin Sanitary Sewer |
429,548 |
--- |
--- |
--- |
| Kit
Creek Pump Station Upgrade |
3,200,000 |
2,391,824 |
(17,785) |
2,374,039 |
| Long
Beverage Wholesale Distbution - Sewer |
540,000 |
285,912 |
211,503 |
497,415 |
| Morris
Branch Regional Pump Station |
$6,387,479 |
4,058,206 |
30,761 |
4,088,967 |
| Morrisville
Pump Station Telemetry Upgrade |
15,000 |
--- |
14,619 |
14,619 |
| NCWRF
Odor Control |
3,270,000 |
70,000 |
--- |
70,000 |
| NCWRF
Upgrade (10 to 12 mgd) * |
13,198,333 |
9,988,450 |
489,779 |
10,478,229 |
NCWRF
Scum Thickener/Digester Pump
Station Replacement * |
174,800 |
168,451 |
--- |
168,451 |
| NC55
Widening - Sewer Line |
20,000 |
--- |
--- |
--- |
| NW
Area Reclaimed Water - Phase 1 |
975,000 |
--- |
--- |
--- |
| Replace/Rehabilitate
Sewer Clay Mains FY2003 * |
212,762 |
212,762 |
--- |
212,762 |
| Replace/Rehabilitate
Sewer Clay Mains FY2006 |
1,744,986 |
--- |
170,737 |
170,737 |
| Replace/Rehabilitate
Sewer Clay Mains |
937,500 |
874,912 |
11,000 |
885,912 |
| Rocky
Branch Sewer & Pump Station Elimination |
3,970,000 |
83,000 |
139,329 |
222,329 |
| Sanitary
Sewer Oversizings FY2006 * |
100,000 |
--- |
--- |
--- |
| Sewer
System Flow Measure |
350,000 |
205 |
135,587 |
135,792 |
| Station
#7 Offsite Sewer Extension |
505,000 |
--- |
54,973 |
54,973 |
| Swift
Creek Cross Gravitational Sewer Extension |
100,000 |
--- |
--- |
--- |
| Swift
Creek Pump Station Expansion |
4,950,000 |
286,642 |
2,613,838 |
2,900,480 |
| SCWRF
Clarifier Repair & Upgrade * |
135,000 |
124,720 |
84 |
124,804 |
| SCWRF
Effluent Structure Cover |
30,000 |
--- |
--- |
--- |
| SCWRF
Filter & Clearwell Cover * |
30,000 |
16,131 |
--- |
16,131 |
| SCWRF
Odor Control |
795,008 |
41,600 |
25,883 |
67,483 |
| Terrington
Pump Station |
800,000 |
--- |
8,022 |
8,022 |
| Thermal
Biosolids Digester |
1,200,000 |
--- |
75,984 |
75,984 |
| Thermal
Biosolids Dryer * |
12,399,084 |
10,302,681 |
1,251,431 |
11,554,112 |
| Thermal
Biosolids Pump |
30,000 |
--- |
8,770 |
8,770 |
| US1/64
Utility Relocation - Sewer |
300,000 |
--- |
--- |
--- |
| Walnut
Creek Flow Diversion |
2,925,000 |
557,394 |
9,263 |
566,657 |
| Walnut
Creek Pump Station Grinder Addition * |
160,000 |
47,241 |
--- |
47,241 |
| Wastewater
SCADA |
130,000 |
--- |
--- |
--- |
White
Oak & Bachelor Branch Interceptor & Pump
Station Elimination |
2,060,000 |
58,040 |
51,477 |
109,517 |
| Asset-Related
Projects (cont'd) |
|
|
|
|
WWRWMF
- Design & Phase 4
Planning/Permitting |
$5,000,000 |
721,083 |
640,064 |
1,361,147 |
| WWRWMF
- New Water Reclamation Facility |
13,453,253 |
--- |
795,157 |
795,157 |
WWRWMF
- New Water Reclamation Facility
Pump Station & Force Main |
3,313,396 |
--- |
14,377 |
14,377 |
WWRWMF
- Organization & Financial
Development |
600,000 |
61,296 |
6,025 |
67,321 |
| WWRWMF
- Project Management |
45,000 |
--- |
29,655 |
29,655 |
WWRWMF
- West Cary Pump Station &
Force Main |
12,955,000 |
1,001,102 |
2,597,484 |
3,598,586 |
| WWRWMF
- Water Reclamation Facility Land |
8,000,000 |
2,228 |
3,798,897 |
3,801,125 |
WWRWMF
- Beaver Creek Pump Station &
Force Main |
1,384,762 |
--- |
--- |
--- |
| Less: Local Government Reimbursements |
(10,948,039) |
(14,286) |
(1,701,399) |
(1,715,685) |
| Total Expenditures , net |
111,529,275 |
32,894,165 |
13,325,118 |
46,219,283 |
| Less: Completed Projects (noted
by *) |
(24,557,971) |
(21,828,476) |
(2,281,546) |
(24,110,022) |
| Construction-in-Progress |
86,971,304
|
11,065,689 |
11,043,572 |
22,109,261 |
|
|
|
|
|
| Expense
Projects |
|
|
|
|
| Force
Main Discharge Manhole |
157,700 |
--- |
781 |
781 |
| I/I
Elimination/Manhole Repair |
425,000 |
268,670 |
--- |
268,670 |
| Reclaimed
Water System Master Plan |
150,000 |
--- |
--- |
--- |
| SCWRF
Filter & Clearwell Cover * |
20,000 |
17,525 |
--- |
17,525 |
| Video
Survey - Sewer Interceptor |
788,100 |
240 |
268,534 |
268,774 |
| West Cary Collection
System Odor Control |
75,000 |
--- |
--- |
--- |
| Water
Reclamation Facility Management Study |
250,000 |
--- |
--- |
--- |
| Total Expenditures |
1,865,800 |
286,435 |
269,315 |
555,750 |
| Less: Completed Projects (noted
by *) |
(20,000) |
(17,525) |
--- |
(17,525) |
| Other Projects-in-Progress |
1,845,800 |
268,910 |
269,315 |
538,225 |
|
|
|
|
|
| TOTAL EXPENDITURES |
113,395,075 |
33,180,600 |
13,594,433 |
46,775,033 |
| Total Completed Projects |
(24,577,971) |
(21,846,001) |
(2,281,546) |
(24,127,547) |
| TOTAL PROJECTS IN
PROGRESS |
88,817,104 |
11,334,599 |
11,312,887 |
22,647,486 |
|
|
|
|
|
| Revenues Under
Expenditures |
(88,242,090) |
(10,759,585) |
(11,271,837) |
(22,031,422) |
|
|
|
|
|
| OTHER
FINANCING SOURCES: |
|
|
|
|
| State Revolving Loan Proceeds |
$16,084,334 |
9,644,274 |
2,424,930 |
12,069,204 |
| Bond Proceeds |
57,324,346 |
19,280,435 |
--- |
19,280,435 |
| Transfers In, net |
|
|
|
|
| Utility System Operations Sub-Fund |
9,000,000 |
9,000,000 |
--- |
9,000,000 |
| Capital Reserve Sub-Fund, net |
29,096,631 |
22,345,856 |
6,750,767 |
29,096,623 |
| Appropriation from Fund
Balance |
--- |
--- |
--- |
--- |
| Sub-Total |
111,505,311 |
60,270,565 |
9,175,697 |
69,446,262 |
| Less:
Completed Projects |
(23,263,221) |
(22,820,825) |
(442,395) |
(23,263,220) |
| TOTAL
OTHER FINANCING SOURCES |
88,242,090 |
37,449,740 |
8,733,302 |
46,183,042 |
| Increase
(Decrease) |
|
26,690,155 |
(2,538,535) |
24,151,620 |
| Adjustment
for Closed Projects |
|
2,083,980 |
(2,083,980) |
--- |
| FUND
BALANCE |
$ --- |
28,774,135 |
(4,622,515) |
24,151,620 |
|
|
|
|
|
|
|
Accrual adjustments: |
|
|
|
|
Construction-in-Progress Current Year |
13,325,118 |
|
|
|
Construction-in-Progress Write-Off |
(20,085) |
|
|
|
NCDOT Funding Earned in Previous Years |
|
|
|
|
Debt Proceeds |
(2,424,930) |
|
|
|
CHANGE IN NET ASSETS |
6,257,588 |
|
|
|
|
|
|
|
|
Net Assets - Beginning of Year |
55,067,746 |
|
|
|
Reclassification Between Utility Sub-Funds |
(24,089,932) |
|
|
|
|
|
|
|
|
NET ASSETS - End of Year |
$37,235,402
|
|
|
|
|
|
|
|
|
|
|
|