| |
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 |
Total Costs to Date FY 2024 |
Total Costs to Date FYE 2025 |
Total Costs to Date FY 2025 |
Total Costs to Date |
FY 25 CIP Remaining Budget |
Project % Complete to Date |
| Project # |
PROJECT NAME |
PHASE |
|
|
All Costs |
All Costs |
Eng & Non-Eng |
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 |
$1,823,368.77 |
|
$1,190,650.61 |
$3,256,770.88 |
$2,120,837.12 |
60.56% |
| 6 |
Whispering Pines Waterline Replacement-C/O #1 Engineering Credit |
$421,083.00 |
1 |
$162,006.46 |
$583,089.46 |
$69,807.80 |
$513,281.66 |
|
|
$583,089.46 |
$0.00 |
100.00% |
| 7 |
Cool Pines Phase A Waterline Replacement-C/O #1 Engineering Credit |
$805,064.00 |
1 |
$759,328.63 |
$1,564,392.63 |
$949,906.69 |
$614,485.94 |
|
|
$1,564,392.63 |
$0.00 |
100.00% |
| 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 |
-$26,646.98 |
$2,921,768.02 |
$803,502.30 |
$2,118,265.72 |
|
|
$2,921,768.02 |
$0.00 |
100.00% |
| 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 |
$704,349.11 |
$73,229.32 |
$353,546.54 |
$1,283,954.20 |
$350,741.64 |
187.54% |
| 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,703,621.95 |
$12,081,553.95 |
$2,218,797.52 |
$5,773,751.20 |
$73,229.32 |
$1,544,197.15 |
$9,609,975.19 |
$26,676,257.76 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
$6,326.25 |
$0.00 |
$292,834.22 |
$7,165.78 |
97.61% |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER PROJECTS |
$1,154,915.00 |
|
$0.00 |
$1,154,915.00 |
$262,709.22 |
$23,798.75 |
$6,326.25 |
$0.00 |
$292,834.22 |
$862,080.78 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
$1,426,163.87 |
$4,459.60 |
|
$1,480,920.38 |
$1,045,617.22 |
71.90% |
| |
|
$2,059,571.00 |
|
$466,966.60 |
$2,526,537.60 |
$50,296.91 |
$1,426,163.87 |
$4,459.60 |
$0.00 |
$1,480,920.38 |
$1,045,617.22 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PROJECTS |
$37,797,097.00 |
|
$2,170,588.55 |
$15,763,006.55 |
$2,531,803.65 |
$7,223,713.82 |
$84,015.17 |
$1,544,197.15 |
$11,383,729.79 |
$26,413,367.21 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
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 |
$265.00 |
$0.00 |
$27,323.06 |
$89,409.94 |
23.41% |
| |
Single Audit Fees |
$15,000.00 |
|
|
$15,000.00 |
$3,750.00 |
$4,100.00 |
$3,000.00 |
$0.00 |
$10,850.00 |
$4,150.00 |
72.33% |
| |
Program Management Fees |
$1,316,768.00 |
|
|
$1,316,768.00 |
$145,726.63 |
$282,042.08 |
$68,107.22 |
$0.00 |
$495,875.93 |
$820,892.07 |
37.66% |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER FEES |
$6,648,501.00 |
|
$0.00 |
$6,648,501.00 |
$3,820,551.28 |
$288,394.58 |
$71,372.22 |
$0.00 |
$4,180,318.08 |
$2,468,182.92 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED |
$44,445,598.00 |
|
$2,170,588.55 |
$22,411,507.55 |
$6,352,354.93 |
$7,512,108.40 |
$155,387.39 |
$1,544,197.15 |
$15,564,047.87 |
$28,881,550.13 |
|
| |
|
|
|
|
|
|
|
|
|
$11,917,778.78 |
$28,881,550.13 |
|
