View-PDF
   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 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 $5,518,758.00 1   $5,518,758.00 $242,751.50 $30,725.00 $1,262.50 $274,739.00 $5,244,019.00 4.98%
6 Whispering Pines Waterline Replacement $421,083.00 1 $205,959.55 $627,042.55 $69,807.80 $54,815.91 $448,115.00 $572,738.71 $54,303.84 91.34%
7 Cool Pines Phase A Waterline Replacement $805,064.00 1 $767,547.72 $1,572,611.72 $949,906.69 $67,077.30 $543,912.64 $1,560,896.63 $11,715.09 99.26%
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 $88,902.00 $3,037,317.00 $803,502.30 $86,374.92 $1,104,217.36 $1,994,094.58 $1,043,222.42 65.65%
10 Pine Mountain Acres/Pinion Waterline Replacement-Deleted $0.00 1             $0.00  
11 White Oak/Cedar Meadows Waterline Replacement-Amended $684,612.00 1 $650,371.00 $1,334,983.00 $152,829.23 $1,320.00 $0.00 $154,149.23 $1,180,833.77 22.52%
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,712,780.27 $12,090,712.27 $2,218,797.52 $240,313.13 $2,097,507.50 $4,556,618.15 $31,738,773.12  
                       
17 Milk Ranch Tank-SV3 Tank & Booster $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 $6,512.25 $0.00 $269,221.47 $30,778.53 89.74%
                       
  USDA OTHER PROJECTS $1,154,915.00   $0.00 $1,154,915.00 $262,709.22 $6,512.25 $0.00 $269,221.47 $885,693.53  
                       
1 Strawberry Ranch PZ Deep Well $2,059,571.00 2 $91,620.00 $2,151,191.00 $50,296.91 $64,811.07 $421,331.59 $536,439.57 $1,614,751.43 26.05%
    $2,059,571.00   $91,620.00 $2,151,191.00 $50,296.91 $64,811.07 $421,331.59 $536,439.57 $1,614,751.43  
                       
  TOTAL PROJECTS $37,797,097.00   $1,804,400.27 $15,396,818.27 $2,531,803.65 $311,636.45 $2,518,839.09 $5,362,279.19 $32,434,817.81  
                       
  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 $397.50 $0.00 $25,203.06 $91,529.94 21.59%
  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 $117,803.27 $0.00 $263,529.90 $1,053,238.10 20.01%
                       
  USDA OTHER FEES $6,648,501.00   $0.00 $6,648,501.00 $3,820,551.28 $122,300.77 $0.00 $3,942,852.05 $2,705,648.95  
                       
  TOTAL PER USDA PROJECT SCHEDULE-ADJUSTED $44,445,598.00   $1,804,400.27 $22,045,319.27 $6,352,354.93 $433,937.22 $2,518,839.09 $9,305,131.24 $35,140,466.76  
                  $5,658,862.15 $35,140,466.76