| PSWID USDA CIP Program FY21 thru FY26 | ||||||||||
| Fiscal Year to Date Thru June 2023 | ||||||||||
| Approved Project Budget | ||||||||||
| PSWID USDA CIP PROGRAM FY21 THRU FY26 | Approved Budget Changes | Approved Revised Budget | Total Costs to Date FY 2022 | Total Costs to Date FY 2023 | Total Costs to Date FY 2023 | Total Costs to Date | FY 23 CIP Remaining Budget | |||
| Project # | PROJECT NAME | PHASE | Engineering & Other | 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,518,758.00 | 1 | $13,692.00 | $95,365.20 | $109,057.20 | $5,409,700.80 | |||
| 6 | Whispering Pines Waterline Replacement | $421,083.00 | 1 | $61,358.40 | $6,458.79 | $1,240.50 | $69,057.69 | $352,025.31 | ||
| 7 | Cool Pines Phase A Waterline Replacement | $805,064.00 | 1 | $99,433.75 | $9,751.32 | $130,601.37 | $239,786.44 | $565,277.56 | ||
| 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 | $233,471.00 | $51,100.47 | $263,033.90 | $547,605.37 | $2,400,809.63 | ||
| 10 | Pine Mountain Acres/Pinion Waterline Replacement-Deleted | $0.00 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| 11 | White Oak/Cedar Meadows Waterline Replacement-Amended | $684,612.00 | 1 | $78,263.85 | $71,829.85 | $850.00 | $150,943.70 | $533,668.30 | ||
| 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,682,611.00 | $486,219.00 | $234,505.63 | $395,725.77 | $1,116,450.40 | $33,566,160.60 | ||||
| 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 | $181,703.22 | $73,894.25 | $255,597.47 | $44,402.53 | |||
| USDA OTHER PROJECTS | $1,154,915.00 | $181,703.22 | $73,894.25 | $0.00 | $255,597.47 | $899,317.53 | ||||
| 1 | Strawberry Ranch PZ Deep Well | $1,959,571.00 | 2 | $29,578.80 | $18,042.46 | $47,621.26 | $1,911,949.74 | |||
| Publication Ads – All Projects | $4,000.00 | 1 | $0.00 | $3,425.68 | $3,425.68 | $574.32 | ||||
| $1,963,571.00 | $29,578.80 | $21,468.14 | $0.00 | $51,046.94 | $1,912,524.06 | |||||
| TOTAL PROJECTS | $37,801,097.00 | $697,501.02 | $329,868.02 | $395,725.77 | $1,423,094.81 | $36,378,002.19 | ||||
| PNC Bank Payoff | $4,000,000.00 | $3,646,269.09 | $0.00 | $0.00 | $3,646,269.09 | $353,730.91 | ||||
| Interim Financing Fees | $1,196,000.00 | $3,762.00 | $3,940.73 | $0.00 | $7,702.73 | $1,188,297.27 | ||||
| Legal Fees | $116,733.00 | $13,500.00 | $3,153.00 | $4,522.06 | $21,175.06 | $95,557.94 | ||||
| Single Audit Fees | $15,000.00 | $3,750.00 | $0.00 | $3,750.00 | $11,250.00 | |||||
| Program Management Fees | $1,316,768.00 | $66,565.77 | $25,261.20 | $16,356.29 | $108,183.26 | $1,208,584.74 | ||||
| USDA OTHER FEES | $6,644,501.00 | $3,730,096.86 | $36,104.93 | $20,878.35 | $3,787,080.14 | $2,857,420.86 | ||||
| TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED | $44,445,598.00 | $4,427,597.88 | $365,972.95 | $416,604.12 | $5,210,174.95 | $39,235,423.05 | ||||
| $1,563,905.86 | $39,235,423.05 | |||||||||