| |
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,187,914.94 |
$1,465,341.44 |
$3,912,266.56 |
27.25% |
| 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 |
$891,269.84 |
$1,575,881.84 |
$152,829.23 |
$69,335.24 |
$448,269.45 |
$670,433.92 |
$905,447.92 |
97.93% |
| 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,652,944.92 |
$12,030,876.92 |
$2,218,797.52 |
$420,244.97 |
$4,565,982.98 |
$7,205,025.47 |
$29,030,530.45 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| 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 |
$19,607.75 |
$0.00 |
$282,316.97 |
$17,683.03 |
94.11% |
| |
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER PROJECTS |
$1,154,915.00 |
|
$0.00 |
$1,154,915.00 |
$262,709.22 |
$19,607.75 |
$0.00 |
$282,316.97 |
$872,598.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 |
$191,743.28 |
$1,164,511.44 |
$1,406,551.63 |
$1,119,985.97 |
68.29% |
| |
|
$2,059,571.00 |
|
$466,966.60 |
$2,526,537.60 |
$50,296.91 |
$191,743.28 |
$1,164,511.44 |
$1,406,551.63 |
$1,119,985.97 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PROJECTS |
$37,797,097.00 |
|
$2,119,911.52 |
$15,712,329.52 |
$2,531,803.65 |
$631,596.00 |
$5,730,494.42 |
$8,893,894.07 |
$28,903,202.93 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
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,173.00 |
$0.00 |
$26,978.56 |
$89,754.44 |
23.11% |
| |
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 |
$249,153.09 |
$0.00 |
$394,879.72 |
$921,888.28 |
29.99% |
| |
|
|
|
|
|
|
|
|
|
|
|
| |
USDA OTHER FEES |
$6,648,501.00 |
|
$0.00 |
$6,648,501.00 |
$3,820,551.28 |
$255,426.09 |
$0.00 |
$4,075,977.37 |
$2,572,523.63 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED |
$44,445,598.00 |
|
$2,119,911.52 |
$22,360,830.52 |
$6,352,354.93 |
$887,022.09 |
$5,730,494.42 |
$12,969,871.44 |
$31,475,726.56 |
|
| |
|
|
|
|
|
|
|
|
$9,323,602.35 |
$31,475,726.56 |
|
