| |
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 |
-$337,500.87 |
$5,181,257.13 |
$242,751.50 |
$1,823,368.77 |
$50,360.21 |
$2,980,294.36 |
$5,096,774.84 |
$84,482.29 |
98.37% |
| 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 |
$1,230,749.02 |
$1,915,361.02 |
$152,829.23 |
$704,349.11 |
$158,722.09 |
$899,460.59 |
$1,915,361.02 |
$0.00 |
100.00% |
| 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,787,936.26 |
$12,165,868.26 |
$2,218,797.52 |
$5,773,751.20 |
$209,082.30 |
$3,879,754.95 |
$12,081,385.97 |
$24,289,161.29 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 17 |
MRTank-SV3 Tank/Booster Bldg/Well Pump, Etc.-Included in 1A |
$0.00 |
1 |
|
$0.00 |
|
|
|
|
|
$0.00 |
|
| 18 |
System Wide Scada-Removed not being done. |
$0.00 |
1 |
|
$0.00 |
|
|
|
|
|
$0.00 |
|
| 19 |
System Wide Water Model |
$300,000.00 |
1 |
-$7,165.78 |
$292,834.22 |
$262,709.22 |
$23,798.75 |
$6,326.25 |
$0.00 |
$292,834.22 |
$0.00 |
100.00% |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER PROJECTS |
$300,000.00 |
|
-$7,165.78 |
$292,834.22 |
$262,709.22 |
$23,798.75 |
$6,326.25 |
$0.00 |
$292,834.22 |
$0.00 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1 |
Strawberry Ranch PZ Deep Well-KP C/O’S Included |
$2,059,571.00 |
2 |
$0.00 |
$2,059,571.00 |
$50,296.91 |
$1,426,163.87 |
$19,829.79 |
$0.00 |
$1,496,290.57 |
$563,280.43 |
72.65% |
| 1A |
Strawberry Ranch PZ Deep Well-KP Phase II-Building/Tank/Booster Pumps, Etc. |
$1,558,719.00 |
2 |
$0.00 |
$1,558,719.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1,558,719.00 |
0.00% |
| 1B |
Strawberry Ranch PZ Deep Well-KP Phase III-Well Pump Equipment & Install |
$400,000.00 |
2 |
$0.00 |
$400,000.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$400,000.00 |
0.00% |
| |
|
$4,018,290.00 |
|
$0.00 |
$3,618,290.00 |
$50,296.91 |
$1,426,163.87 |
$19,829.79 |
$0.00 |
$1,496,290.57 |
$2,121,999.43 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PROJECTS |
$38,900,901.00 |
|
$1,780,770.48 |
$16,076,992.48 |
$2,531,803.65 |
$7,223,713.82 |
$235,238.34 |
$3,879,754.95 |
$13,870,510.76 |
$26,411,160.72 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
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-Reduced due to capitalization not allowed anymore |
$96,196.00 |
|
|
$96,196.00 |
$0.00 |
$0.00 |
|
$0.00 |
$0.00 |
$96,196.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 |
$4,300.00 |
$0.00 |
$12,150.00 |
$2,850.00 |
81.00% |
| |
Program Management Fees |
$1,316,768.00 |
|
|
$1,316,768.00 |
$145,726.63 |
$282,042.08 |
$189,571.70 |
$0.00 |
$617,340.41 |
$699,427.59 |
46.88% |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER FEES |
$5,544,697.00 |
|
$0.00 |
$5,544,697.00 |
$3,820,551.28 |
$288,394.58 |
$194,136.70 |
$0.00 |
$4,303,082.56 |
$1,241,614.44 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED |
$44,445,598.00 |
|
$1,780,770.48 |
$21,621,689.48 |
$6,352,354.93 |
$7,512,108.40 |
$429,375.04 |
$3,879,754.95 |
$18,173,593.32 |
$26,272,004.68 |
|
| |
|
|
|
|
|
|
|
|
|
$14,527,324.23 |
$26,272,004.68 |
|
