| |
PSWID USDA CIP Program FY21 thru FY26
|
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
|
Approved Project Budget |
|
|
|
|
|
|
|
|
|
| |
PSWID USDA CIP PROGRAM FY21 THRU FY26 |
|
Approved Budget Changes |
Approved Revised Budget |
Total Costs to Date FY 2023 Construction |
Total Costs to Date FY 2024 |
Total Costs to Date FY 2024 |
Total Costs to Date |
FY 24 CIP Remaining Budget |
Project % Complete to Date |
| Project # |
PROJECT NAME |
PHASE |
|
|
Engineering & Other |
Engineering & Non-Const |
Construction |
ALL |
|
|
| 1 |
Strawberry Creek Foothills/Strawberry Pines Waterline |
$3,630,883.00 |
1 |
|
|
|
|
|
|
$3,630,883.00 |
|
| 2 |
RW/MME2/SMS/Fitz-Strawberry Waterline Replacement |
$5,080,358.00 |
1 |
|
|
|
|
|
|
$5,080,358.00 |
|
| 3 |
Strawberry View 3/Shady Lane Waterline Replacement |
$3,535,788.00 |
1 |
|
|
|
|
|
|
$3,535,788.00 |
|
| 4 |
Strawberry View 1&2 Waterline Replacement |
$3,722,603.00 |
1 |
|
|
|
|
|
|
$3,722,603.00 |
|
| 5 |
Portals 1, 2 & 3 Waterline Replacement-C/O #1 Engineering Credit |
$5,518,758.00 |
1 |
-$141,150.00 |
$5,377,608.00 |
$242,751.50 |
$34,675.00 |
$1,788,693.77 |
$2,066,120.27 |
$3,311,487.73 |
38.42% |
| 6 |
Whispering Pines Waterline Replacement-C/O #1 Engineering Credit |
$421,083.00 |
1 |
$165,006.46 |
$586,089.46 |
$69,807.80 |
$65,166.66 |
$448,115.00 |
$583,089.46 |
$3,000.00 |
99.49% |
| 7 |
Cool Pines Phase A Waterline Replacement-C/O #1 Engineering Credit |
$805,064.00 |
1 |
$762,328.63 |
$1,567,392.63 |
$949,906.69 |
$70,573.30 |
$543,912.64 |
$1,564,392.63 |
$3,000.00 |
99.81% |
| 8 |
Woodland Heights Phase A Waterline Replacement |
$0.00 |
1 |
|
|
|
|
|
|
|
|
| 9 |
Woodland Heights Phase B &C Waterline Replacement-Combined-Amend #1 |
$2,948,415.00 |
1 |
-$24,510.01 |
$2,923,904.99 |
$803,502.30 |
$180,494.77 |
$1,937,770.95 |
$2,921,768.02 |
$2,136.97 |
99.93% |
| 10 |
Pine Mountain Acres/Pinion Waterline Replacement-Deleted |
$0.00 |
1 |
|
|
|
|
|
|
$0.00 |
|
| 11 |
White Oak/Cedar Meadows Waterline Replacement-MHE C/O #2-C/O #2 Engineering |
$684,612.00 |
1 |
$950,083.84 |
$1,634,695.84 |
$152,829.23 |
$92,123.25 |
$612,225.86 |
$857,178.34 |
$777,517.50 |
125.21% |
| 12 |
Hidden Pines Waterline Replacement |
$450,156.00 |
1 |
|
|
|
|
|
|
$450,156.00 |
|
| 13 |
Cimmaron Pines Waterline Replacement |
$1,219,173.00 |
1 |
|
|
|
|
|
|
$1,219,173.00 |
|
| 14 |
Brookview Terrace 1 & 2 Waterline Replacement |
$1,410,360.00 |
1 |
|
|
|
|
|
|
$1,410,360.00 |
|
| 15 |
Strawberry Mtn Shadows 1&2/Pine Cove Waterline Replacement |
$4,689,125.00 |
1 |
|
|
|
|
|
|
$4,689,125.00 |
|
| 16 |
Strawberry Mtn Shadows 2 Service Corp Stop Replacement |
$466,233.00 |
1 |
|
|
|
|
|
|
$466,233.00 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
USDA WATERLINE PROJECTS |
$34,582,611.00 |
|
$1,711,758.92 |
$12,089,690.92 |
$2,218,797.52 |
$443,032.98 |
$5,330,718.22 |
$7,992,548.72 |
$28,301,821.20 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| 17 |
MRTank-SV3 Tank/Booster Bldg/Well Pump, Etc. |
$305,915.00 |
1 |
|
$305,915.00 |
|
|
|
|
$305,915.00 |
|
| 18 |
System Wide Scada |
$549,000.00 |
1 |
|
$549,000.00 |
|
|
|
|
$549,000.00 |
|
| 19 |
System Wide Water Model |
$300,000.00 |
1 |
|
$300,000.00 |
$262,709.22 |
$23,798.75 |
$0.00 |
$286,507.97 |
$13,492.03 |
95.50% |
| |
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER PROJECTS |
$1,154,915.00 |
|
$0.00 |
$1,154,915.00 |
$262,709.22 |
$23,798.75 |
$0.00 |
$286,507.97 |
$868,407.03 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| 1 |
Strawberry Ranch PZ Deep Well-KP C/O $327,470.60-GL C/O $47,876 |
$2,059,571.00 |
2 |
$466,966.60 |
$2,526,537.60 |
$50,296.91 |
$198,035.53 |
$1,228,128.34 |
$1,476,460.78 |
$1,050,076.82 |
71.69% |
| |
|
$2,059,571.00 |
|
$466,966.60 |
$2,526,537.60 |
$50,296.91 |
$198,035.53 |
$1,228,128.34 |
$1,476,460.78 |
$1,050,076.82 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PROJECTS |
$37,797,097.00 |
|
$2,178,725.52 |
$15,771,143.52 |
$2,531,803.65 |
$664,867.26 |
$6,558,846.56 |
$9,755,517.47 |
$28,041,579.53 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
PNC Bank Payoff |
$4,000,000.00 |
|
|
$4,000,000.00 |
$3,646,269.09 |
$0.00 |
$0.00 |
$3,646,269.09 |
$353,730.91 |
91.16% |
| |
Interim Financing Fees |
$1,200,000.00 |
|
|
$1,200,000.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1,200,000.00 |
0.00% |
| |
Legal Fees |
$116,733.00 |
|
|
$116,733.00 |
$24,805.56 |
$2,252.50 |
$0.00 |
$27,058.06 |
$89,674.94 |
23.18% |
| |
Single Audit Fees |
$15,000.00 |
|
|
$15,000.00 |
$3,750.00 |
$4,100.00 |
$0.00 |
$7,850.00 |
$7,150.00 |
52.33% |
| |
Program Management Fees |
$1,316,768.00 |
|
|
$1,316,768.00 |
$145,726.63 |
$282,042.08 |
$0.00 |
$427,768.71 |
$888,999.29 |
32.49% |
| |
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER FEES |
$6,648,501.00 |
|
$0.00 |
$6,648,501.00 |
$3,820,551.28 |
$288,394.58 |
$0.00 |
$4,108,945.86 |
$2,539,555.14 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED |
$44,445,598.00 |
|
$2,178,725.52 |
$22,419,644.52 |
$6,352,354.93 |
$953,261.84 |
$6,558,846.56 |
$13,864,463.33 |
$30,581,134.67 |
|
| |
|
|
|
|
|
|
|
|
$10,218,194.24 |
$30,581,134.67 |
|
