| PSWID USDA CIP Program FY21 thru FY26 | |||||||||||
| Fiscal Year to Date Thru June 2024 | |||||||||||
| 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 FY 2024 | Total Costs to Date | FY 24 CIP Remaining Budget | Project % Complete to Date | |||
| Project # | PROJECT NAME | PHASE | Engineering & Construction | Engineering & Other | 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,180,358.00 | 1 | $5,180,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 | $5,979,000.00 | 1 | $242,751.50 | $4,894.10 | $0.00 | $247,645.60 | $5,731,354.40 | 4.14% | ||
| 6 | Whispering Pines Waterline Replacement | $421,776.00 | 1 | $69,297.44 | $0.00 | $108.75 | $69,406.19 | $352,369.81 | 16.46% | ||
| 7 | Cool Pines Phase A Waterline Replacement | $1,450,137.00 | 1 | $984,682.05 | $0.00 | $28,703.50 | $1,013,385.55 | $436,751.45 | 69.88% | ||
| 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 | $806,609.10 | $0.00 | $450.00 | $807,059.10 | $2,141,355.90 | 27.37% | ||
| 10 | Pine Mountain Acres/Pinion Waterline Replacement-Deleted | $0.00 | 1 | $0.00 | |||||||
| 11 | White Oak/Cedar Meadows Waterline Replacement-Amended | $1,257,894.00 | 1 | $152,266.20 | $0.00 | $0.00 | $152,266.20 | $1,105,627.80 | 12.10% | ||
| 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 | $36,361,901.00 | $2,255,606.29 | $4,894.10 | $29,262.25 | $2,289,762.64 | $34,072,138.36 | |||||
| 17 | Milk Ranch Tank | $305,915.00 | 1 | $305,915.00 | |||||||
| 18 | System Wide Scada | $549,000.00 | 1 | $549,000.00 | |||||||
| 19 | System Wide Water Model | $300,000.00 | 1 | $262,709.22 | $1,883.00 | $0.00 | $264,592.22 | $35,407.78 | 88.20% | ||
| USDA OTHER PROJECTS | $1,154,915.00 | $262,709.22 | $1,883.00 | $0.00 | $264,592.22 | $890,322.78 | |||||
| 1 | Strawberry Ranch PZ Deep Well | $1,959,571.00 | 2 | $49,018.01 | $605.50 | $0.00 | $49,623.51 | $1,909,947.49 | 2.53% | ||
| Publication Ads – All Projects | $4,000.00 | 1 | $3,425.68 | $0.00 | $0.00 | $3,425.68 | $574.32 | 85.64% | |||
| $1,963,571.00 | $52,443.69 | $605.50 | $0.00 | $53,049.19 | $1,910,521.81 | ||||||
| TOTAL PROJECTS | $39,480,387.00 | $2,570,759.20 | $7,382.60 | $29,262.25 | $2,607,404.05 | $36,872,982.95 | |||||
| PNC Bank Payoff | $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,196,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,196,000.00 | 0.00% | ||||
| Legal Fees | $116,733.00 | $24,805.56 | $53.00 | $0.00 | $24,858.56 | $91,874.44 | 21.30% | ||||
| Single Audit Fees | $15,000.00 | $3,750.00 | $0.00 | $0.00 | $3,750.00 | $11,250.00 | 25.00% | ||||
| Program Management Fees | $1,316,768.00 | $145,726.63 | $21,481.10 | $0.00 | $167,207.73 | $1,149,560.27 | 12.70% | ||||
| USDA OTHER FEES | $6,644,501.00 | $3,820,551.28 | $21,534.10 | $0.00 | $3,842,085.38 | $2,802,415.62 | |||||
| TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED | $46,124,888.00 | $6,391,310.48 | $28,916.70 | $29,262.25 | $6,449,489.43 | $39,675,398.57 | |||||
| $2,803,220.34 | $39,675,398.57 | ||||||||||