Loading...
2017 IOTB 05.09.18City of Atlantic Beach CIP - Improvements Other Than Buildings Project Reconciliation Fiscal Year 2017 Project Description RUSSELL PK RENOVATION BULL PK PLAYGRND EQUIPMT DUTTON ISLE RD IMPROVMENT NEW POLICE BLDG JORDAN PARK BATHROOMS JORDAN&DONNER ADA PG IMP SHADE STRUCTURE - SS PIER Repair 24" Efflt For Main Repair 12" Force Main Effluent Pump at WWTP Connect A1A @ Mallard Cve EFF OUTFALL @ SHERMAN PT SOFT STARTS - WTP1, 2 &3 CHLORINE AUTO CONTROL VAL CONTROL BUBBLER SYSTEM REPLACE SEASPRAY H20 SERV SEWER SYSTEM REHAB SEAOAT CONTROL PANEL LIFT STA WW SOFTSTARTS LIFT ST. ABC&D PHORPHOROUS TREATMENT FAC REPLACE EFF PUMP #2 REPLACE RAS PUMP & MOTOR REPLAC INFLUENT PUMP WWTP REPLACE H20 SERVICE SEASP SOFTSTART LIFT STATION E MARINA L/S REPLACE 4 WETWELL TOPS MASTER LS CONTROL UPGRADE REPLACE DISK - KRUGER DIS TWO EFFLUENT SCREEN REPLA Robert Street Ditch SALTAIR/STURDIVAN SIDEWLK SEMINOLE STREET SCAPE Marsh Project Ped Path SALTAIR DRAINAGE UPGRADE FRANCIS AVE DRAINAGE IMPR MARSH PRESERVE PATH PH 2 SIDEWALK AND ST IMP AQUATIV GARDENS POND IMPR JASMINE POND BANK RESTORA SALTAIR DRAINAGE IMP Project Number PM1501 PM1504 PM1505 PS1501 PM1701 PM1702 PM1705 PU1308 PU1309 PU1409 PU1410 PU1504 PU1602 PU1603 PU1604 PU1605 PU1607 PU1608 PU1609 PU1611 PU1614 PU1615 PU1616 PU1703 PU1708 PU1709 PU1710 PU1711 PU1713 PU1714 PW1404 PW1406 PW1407 PW1408 PW1411 PW1502 PW1603 PW1702 PW1705 PW1706 PW1711 Project Sub-Total G/L Total Difference 400 410 470 900 169.90-00 Bal @ 9/30/2016 249720.24 16038.8 7386 1159231.94 0 0 0 7850.7 5019.3 48417.6 98567 63.75 23263.72 25915.7 172.16 97339.25 0 14049.02 20091.93 24832.75 574.92 26520.57 252.71 0 0 0 0 0 0 0 28854.82 173528.95 116614.7 105868 192293.53 438040.45 416946.7 0 0 0 0 0 3297455.21 3297455.21 0 268569.97 147673.25 324166.56 2557045.43 3297455.21 63-00 2016 CWIP 0 11880 0 2544481.51 5619.04 118860.02 5394.48 0 0 0 0 528263.52 0 0 8575.29 0 206671.7 0 0 362110.7 49943.5 6988.2 20320.5 149105.1 3324.63 6859.9 9744.1 27972.44 6392.79 31083.8 0 0 20970.99 2035 0 200056.08 42612.67 17286.73 56119.32 15197.26 170937.98 0 4628807.25 4628807.25 0 167758.1 1259675.78 220489.53 2980883.84 4628807.25 Retainage or Reclass 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -13627.62 0 -13627.62 -13627.62 0 0 0 -13627.62 0 -13627.62 164.91-** Completed & Capitalized -249720.24 0 -7386 -3703713.45 -5619.04 -118860.02 -5394.48 -7850.7 -5019.3 -48417.6 -98567 0 -23263.72 -25915.7 -8747.45 -97339.25 -206671.7 -14049.02 -20091.93 0 -50518.42 -33508.77 -20573.21 0 0 -6859.9 -9744.1 0 -6392.79 -31083.8 -28854.82 -173528.95 0 0 -192293.53 -638096.53 0 0 0 0 0 0 -5838081.42 -5838081.42 0 -253833.12 -460781.24 -265832.19 -4857634.87 -5838081.42 169.90-00 Bal @ 9/30/2017 0 27918.8 0 0 0 0 0 0 0 0 0 528327.27 0 0 0 0 0 0 0 386943.45 0 0 0 149105.1 3324.63 0 0 27972.44 0 0 0 0 137585.69 107903 0 0 459559.37 17286.73 56119.32 15197.26 157310.36 0 2074553.42 2074553.42 0 182494.95 946567.79 265196.28 680294.4 2074553.42 5/21/2018 12:46:52 PM Fixed Asset # 2787 2788 2791 2760 2762 2763 2764 2765 2766 2767 2778 2779 2768 2769 2770 2771 2780 2783 2772 2773 2784 2774 2775 2776 2777 2785 2786 2789 Complete PM1504 Complete Complete Complete Complete Complete Complete Complete Complete Complete PU1504 Complete Complete Complete Complete Complete Complete Complete PU1611 Complete Complete Complete PU1703 PU1708 Complete Complete PU1711 Complete Complete Complete Complete PW1407 PW1408 Complete Complete PW1603 PW1702 PW1705 PW1706 PW1711 Project # City of Atlantic Beach CIP - Improvements Other Than Buildings Project Reconciliation Fiscal Year 2017 Project Description Connect A1A @ Mallard Cve SOFT STARTS WTP1, 2 &3 CHLORINE AUTO CONTROL VAL CONTROL BUBBLER SYSTEM REPLACE SEASPRAY H20 SERV REPLACE H20 SERVICE SEASP SEMINOLE STREET SCAPE O:\Finance\Audit\FY 2017\AA - Open Item List\01 - Fixed Assets\IOTB\[2017 IOTB 05.09.18.xls]rec Project Number PU1410 PU1602 PU1603 PU1604 PU1605 PU1703 PW1407 Project Sub-Total 169.90-00 Bal @ 9/30/2016 98567 23263.72 25915.7 172.16 97339.25 0 23312.14 268569.97 63-00 2016 CWIP 0 0 0 8575.29 0 149105.1 10077.71 167758.1 Retainage or Reclass 0 0 164.91-** Completed & Capitalized -98567 -23263.72 -25915.7 -8747.45 -97339.25 -253833.12 169.90-00 Bal @ 9/30/2017 0 0 0 0 0 149105.1 33389.85 182494.95 86075.02 5/21/2018 12:46:52 PM Fixed Asset # 2767 2778 2779 2768 2769 0 0 Fund # 400 400 400 400 400 400 400 400-0000-167-90-00 400-0000-533-59-11 Complete Complete Complete Complete Complete PU1703 PW1407 Project # Capitalize Capitalize PO171140 has a balace of 20,250 PO141833 has a balance of $2,338.28 City of Atlantic Beach CIP - Improvements Other Than Buildings Project Reconciliation Fiscal Year 2017 Project Description Repair 24" Efflt For Main Repair 12" Force Main Effluent Pump at WWTP EFF OUTFALL @ SHERMAN PT SEWER SYSTEM REHAB SEAOAT CONTROL PANEL LIFT STA WW SOFTSTARTS LIFT ST. ABC&D PHORPHOROUS TREATMENT FAC REPLACE EFF PUMP #2 REPLACE RAS PUMP & MOTOR REPLAC INFLUENT PUMP WWTP SOFTSTART LIFT STATION E MARINA L/S REPLACE 4 WETWELL TOPS MASTER LS CONTROL UPGRADE REPLACE DISK - KRUGER DIS TWO EFFLUENT SCREEN REPLA O:\Finance\Audit\FY 2017\AA - Open Item List\01 - Fixed Assets\IOTB\[2017 IOTB 05.09.18.xls]rec Project Number PU1308 PU1309 PU1409 PU1504 PU1607 PU1608 PU1609 PU1611 PU1614 PU1615 PU1616 PU1708 PU1709 PU1710 PU1711 PU1713 PU1714 Project Sub-Total 169.90-00 Bal @ 9/30/2016 7850.7 5019.3 48417.6 63.75 14049.02 20091.93 24832.75 574.92 26520.57 252.71 147673.25 63-00 2016 CWIP 0 0 0 528263.52 206671.7 0 0 362110.7 49943.5 6988.2 20320.5 3324.63 6859.9 9744.1 27972.44 6392.79 31083.8 1259675.78 Retainage or Reclass 0 0 0 0 164.91-** Completed & Capitalized -7850.7 -5019.3 -48417.6 -206671.7 -14049.02 -20091.93 -50518.42 -33508.77 -20573.21 -6859.9 -9744.1 -6392.79 -31083.8 -460781.24 169.90-00 Bal @ 9/30/2017 0 0 0 528327.27 0 0 0 386943.45 0 0 0 3324.63 0 0 27972.44 0 0 946567.79 5/21/2018 12:46:52 PM Fixed Asset # 2764 2765 2766 0 2770 2771 2780 0 2783 2772 2773 0 2784 2774 0 2775 2776 Fund # 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 Complete Complete Complete PU1504 Complete Complete Complete PU1611 Complete Complete Complete PU1708 Complete Complete PU1711 Complete Complete Project # PO 161471 has a balance of $23,190 FY18 activity FY18 activity FY18 activity City of Atlantic Beach CIP - Improvements Other Than Buildings Fund 470 Reconciliation Fiscal Year 2017 Project Description Saltair/Sturdivant Sidewalk (& Drainage) Design Seminole Streetscape SALTAIR DRAINAGE UPGRADE AQUATIV GARDENS POND IMPR JASMINE POND BANK RESTORA SALTAIR DRAINAGE IMP Project Number PW1406 PW1407 PW1411 PW1705 PW1706 PW1711 Project Sub-Total 169.90-00 Bal @ 9/30/2016 73538.66 58334.37 192293.53 324166.56 63-00 2016 CWIP 0 679.65 0 56119.32 15197.26 148493.3 220489.53 Retainage or Reclass 0 0 0 0 0 -13627.62 -13627.62 164.91-** Completed & Capitalized -73538.66 0 -192293.53 0 0 0 -265832.19 169.90-00 Bal @ 9/30/2017 0 59014.02 0 56119.32 15197.26 134865.68 265196.28 -544656.09 5/21/2018 12:46:52 PM Fixed Asset # 2785 0 2786 0 0 0 Fund # 470 470 470 470 470 470 Complete PW1407 Complete PW1705 PW1706 PW1711 Project # PO 141833 balance of $2,338.28 FY18 activity PO 170785 has a balance of $18,369.04 FY18 activity Project Description RUSSELL PK RENOVATION BULL PK PLAYGRND EQUIPMT DUTTON ISLE RD IMPROVMENT JORDAN PARK BATHROOMS JORDAN&DONNER ADA PG IMP SHADE STRUCTURE - SS PIER Robert Street Ditch SALTAIR/STURDIVAN SIDEWLK SEMINOLE STREET SCAPE Marsh Project - Ped Path FRANCIS AVE DRAINAGE IMPR MARSH PRESERVE PATH PH 2 NEW POLICE BLDG SIDEWALK AND ST IMP SALTAIR DRAINAGE IMP 900-0000-169-90-00 Project Number PM1501 PM1504 PM1505 PM1701 PM1702 PM1705 PW1404 PW1406 PW1407 PW1408 PW1502 PW1603 PS1501 PW1702 PW1711 Project Sub-Total D 169.90-00 Bal @ 9/30/2016 249720.24 16038.8 7386 28854.82 99990.29 34968.19 105868 438040.45 416946.7 1159231.94 2557045.43 2557045.16 -0.269999999552965 63-00 2016 CWIP 0 11880 0 5619.04 118860.02 5394.48 0 0 10213.63 2035 200056.08 42612.67 2544481.51 17286.73 22444.68 2980883.84 Retainage or Reclass 0 D 164.91-** Completed & Capitalized -249720.24 -7386 -5619.04 -118860.02 -5394.48 -28854.82 -99990.29 -638096.53 -3703713.45 -4857634.87 -4447709.08 5/21/2018 12:46:52 PM D 169.90-00 Bal @ 9/30/2017 0 27918.8 0 0 0 0 0 0 45181.82 107903 0 459559.37 0 17286.73 22444.68 680294.4 2834719.49 2154425.09 2154425.36 Fixed Asset # 2787 0 2788 2760 2762 2763 2777 2785 0 0 2789 0 2791 0 0 Fund # 131 131 320 1 110 131 1 131 131 320 110 320 300 131 131 Complete PM1504 Complete Complete Complete Complete Complete Complete PW1407 PW1408 Complete PW1603 Complete PW1702 PW1711 FY18 Activity PO 141833 has a balance of $2,338.28 PO 140989 $31,424 PO 181170 has a balance of $3,000 FY18 Activity FY18 Activity HTE info Group type (F4) Group date Accounting period Accounting year Group description Create document Count entered Debit amount entered Credit amount entered Fund/Account Name GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Capital Expense Reclass GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED GFAAG/Capital Expense Reclass GFAAG/Capital Expense Reclass Water Fund/IOTB WaterFund/Capital Expense Reclass Water Fund/IOTB WaterFund/Capital Expense Reclass Water Fund/IOTB WaterFund/Capital Expense Reclass Water Fund/IOTB WaterFund/Capital Expense Reclass WaterFund/Capital Expense Reclass Water Fund/IOTB WaterFund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Sewer Fund/IOTB Sewer Fund/Capital Expense Reclass Stormwater Fund/IOTB Stormwater Fund/Capital Expense Reclass Stormwater Fund/IOTB Stormwater Fund/Capital Expense Reclass Batch Count: Explanation: Prepared by: O:\Finance\Audit\FY 2017\AA - Open Item List\01 - Fixed Assets\IOTB\[2017 IOTB 05.09.18.xls]rec Record FY 2016/2017 completed projects Transaction date Group number AJ 9/30/2017 13 2017 Record Completed Projects N 64 5838081.42 5838081.42 9/30/2017 4148 64 Adjusting journal (Y=Yes; N=No) Project # PM1501 PM1501 PM1505 PM1505 PM1701 PM1701 PM1702 PM1702 PM1705 PM1705 PW1404 PW1404 PW1406 PW1406 PW1502 PW1502 PW1502 PS1501 PS1501 PS1501 PU1410 PU1410 PU1602 PU1602 PU1603 PU1603 PU1604 PU1604 PU1604 PU1605 PU1605 PU1308 PU1308 PU1309 PU1309 PU1409 PU1409 PU1607 PU1607 PU1608 PU1608 PU1609 PU1609 PU1614 PU1614 PU1614 PU1615 PU1615 PU1615 PU1616 PU1616 PU1616 PU1709 PU1709 PU1710 PU1710 PU1713 PU1713 PU1714 PU1714 PW1406 PW1406 PW1411 PW1411 Funding Source 131 131 320 320 1 1 110 110 131 131 1 1 131 131 110 110 110 300 300 300 400 400 400 400 400 400 400 400 400 400 400 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 470 470 470 470 Account number 900 900 900 900 900 900 900 900 900 900 900 900 900 900 900 900 900 900 900 900 400 400 400 400 400 400 400 400 400 400 400 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 470 470 470 470 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 164 169 164 169 164 599 164 599 164 599 164 169 164 169 164 169 599 164 169 599 164 169 164 169 164 169 164 169 599 164 169 164 169 164 169 164 169 164 599 164 169 164 169 164 169 599 164 169 599 164 169 599 164 599 164 599 164 599 164 599 164 169 164 169 91 90 91 90 91 69 91 69 91 69 91 90 91 90 91 90 69 91 90 69 91 90 91 90 91 90 91 90 69 91 90 91 90 91 90 91 90 91 69 91 90 91 90 91 90 69 91 90 69 91 90 69 91 69 91 69 91 69 91 69 91 90 91 90 Control Total Page: 00 00 00 00 00 99 00 99 00 99 00 00 00 00 00 00 99 00 00 99 00 00 00 00 00 00 00 00 99 00 00 00 00 00 00 00 00 00 99 00 00 00 00 00 00 99 00 00 99 00 00 99 00 99 00 99 00 99 00 99 00 00 00 00 1 Debit 249720.24 7386 5619.04 118860.02 5394.48 28854.82 99990.29 638096.53 3703713.45 98567 23263.72 25915.7 8747.45 97339.25 7850.7 5019.3 48417.6 206671.7 14049.02 20091.93 50518.42 33508.77 20573.21 6859.9 9744.1 6392.79 31083.8 73538.66 192293.53 5838081.42 1 Credit 249720.24 7386 5619.04 118860.02 5394.48 28854.82 99990.29 438040.45 200056.08 1159231.94 2544481.51 98567 23263.72 25915.7 172.16 8575.29 97339.25 7850.7 5019.3 48417.6 206671.7 14049.02 20091.93 574.92 49943.5 26520.57 6988.2 252.71 20320.5 6859.9 9744.1 6392.79 31083.8 73538.66 192293.53 5838081.42 HTE info Group type (F4) Group date Accounting period Accounting year Group description Create document Count entered Debit amount entered Credit amount entered Fund/Account Name Water Fund/CIP Water Fund/Capital Expense Reclass Water Fund/CIP Water Fund/Capital Expense Reclass Sewer Fund/CIP Sewer Fund/Capital Expense Reclass Sewer Fund/CIP Sewer Fund/Capital Expense Reclass Sewer Fund/CIP Sewer Fund/Capital Expense Reclass Sewer Fund/CIP Sewer Fund/Capital Expense Reclass Storm Fund/CIP Storm Fund/Capital Expense Reclass Storm Fund/CIP Storm Fund/Capital Expense Reclass Storm Fund/CIP Storm Fund/Capital Expense Reclass Storm Fund/CIP Storm Fund/Capital Expense Reclass GFA/CIP GFA/Capital Expense Reclass GFA/CIP GFA/Capital Expense Reclass GFA/CIP GFA/Capital Expense Reclass GFA/CIP GFA/Capital Expense Reclass GFA/CIP GFA/Capital Expense Reclass GFA/CIP GFA/Capital Expense Reclass Batch Count: Explanation: Prepared by: O:\Finance\Audit\FY 2017\AA - Open Item List\01 - Fixed Assets\IOTB\[2017 IOTB 05.09.18.xls]rec Record FY 2016/2017 CIP Additions Transaction date Group number AJ 9/30/2017 13 2017 Record FY 2014 CIP Additons N 32 1394188.72 1394188.72 9/30/2017 4147 32 Adjusting journal (Y=Yes; N=No) Project # PU1703 PU1703 PW1407 PW1407 PU1504 PU1504 PU1611 PU1611 PU1708 PU1708 PU1711 PU1711 PW1407 PW1407 PW1705 PW1705 PW1706 PW1706 PW1711 PW1711 PM1504 PM1504 PW1407 PW1407 PW1408 PW1408 PW1603 PW1603 PW1702 PW1702 PW1711 PW1711 Account number 400 400 400 400 410 410 410 410 410 410 410 410 470 470 470 470 470 470 470 470 900 900 900 900 900 900 900 900 900 900 900 900 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 169 599 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 90 69 Control Total Page: 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 00 99 1 Debit 149105.1 10077.71 528263.52 362110.7 3324.63 27972.44 679.65 56119.32 15197.26 134865.68 11880 10213.63 2035 42612.67 17286.73 22444.68 1394188.72 1 Credit 149105.1 10077.71 528263.52 362110.7 3324.63 27972.44 679.65 56119.32 15197.26 134865.68 11880 10213.63 2035 42612.67 17286.73 22444.68 1394188.72 PROJ # S17IRM S16MAT S17IRM S17IRM S17IRM S17IRM S17IRM S16MAT S17IRM PS1501 S17IRM S17IRM S16MAT S17IRM S17IRM S17IRM S16MAT S16MAT S17IRM S16MAT S17IRM S16MAT S17IRM S16MAT S17IRM S16MAT S17IRM S17IRM S17IRM S17IRM S16MAT S17IRM S17IRM S17IRM S17IRM S17IRM S16MAT S16MAT S16MAT PM1701 PM1702 PW1502 PM1703 PW1703 PW1701 PM1706 PW1406 PW1407 PW1601 PW1702 PW1707 PW1711 PM1501 PM1504 PM1704 PM1705 PM1707 PW1409 PW1602 PS1501 PS1701 PM1505 PW1408 PW1409 PW1410 PW1603 S17IRM S17IRM S17IRM S17IRM S16MAT S16MAT PU1501 PU1502 PU1601 PU1602 PU1603 PU1604 PU1701 PU1702 S17IRM S17IRM S17IRM S17IRM PU1605 PU1606 PU1703 PU1704 PU1705 PU1706 PW1407 S17IRM S17IRM S17IRM S17IRM S16MAT S17IRM S16MAT PU1408 PU1504 PU1607 PU1608 PU1609 PU1610 PU1707 PU1708 PU1709 PU1710 PU1711 S17IRM S17IRM S17IRM S17IRM S16MAT S17IRM S16MAT S16MAT PU1611 PU1612 PU1613 PU1614 PU1615 PU1616 PU1712 PU1713 PU1714 PU1715 PU1716 PU1717 PU1718 S16MAT S17IRM S17IRM S17IRM S17IRM S17IRM S17IRM S17IRM S16MAT S16MAT S17IRM PW1704 PW1407 PW1411 PW1412 PW1705 PW1706 PW1708 PW1711 PW1712 PROJECT Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Irma NEW POLICE BLDG-DES/CONST Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Matthew Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Matthew Hurricane Matthew JORDAN PARK BATHROOMS JORDAN&DONNER ADA PG IMP FRANCIS AVE DRAINAGE IMPR DECK & BIKE RACK TOWNCENT DIGITAL LIGHTING PED CROS 6 BAY VEHICLE STORAGE CITY EVENT SIGN - MAYPORT SALTAIR/STURDIVAN SIDEWLK SEMINOLE STREET SCAPE TOWNCENTER IMPR DECK & BR SIDEWALK AND ST IMP SEMINOLE RD PROJ SALTAIR DRAINAGE IMP RUSSELL PK RENOVATION BULL PK PLAYGRND EQUIPMT RUSSELL PARK TENNIS COURT SHADE STRUCTURE - SS PIER LIFEGUARD STATION IMPROVE MRSH OVRLOOK+KAYAK LAUNCH VET PARK PLAYSET NEW POLICE BLDG-DES/CONST Public safety building ff DUTTON ISLE RD IMPROVMENT Marsh Project Ped Path MRSH OVRLOOK+KAYAK LAUNCH MARSH PRESERVE PATH PHZ-I MARSH PRESERVE PATH PH 2 Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Matthew WELL LOGGING-6 WELLS UPDATE MODELS NORTH FENCE REPLACE WTP2 SOFT STARTS - WTP1, 2 &3 CHLORINE AUTO CONTROL VAL CONTROL BUBBLER SYSTEM WELL LOGGING CHLORINE CTL VALVE WTP3 Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma REPLACE SEASPRAY H20 SERV ATLANTIC WATER MAIN REPLA REPLACE H20 SERVICE SEASP ATL BLD WATER MAIN REPLAC SEMINOLE RD UTILITIES PRJ METER PROJECT SEMINOLE STREET SCAPE Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Matthew EFFLUENT OUTFALL REPLCMT EFF OUTFALL @ SHERMAN PT SEWER SYSTEM REHAB SEAOAT CONTROL PANEL LIFT STA WW SOFTSTARTS LIFT ST. ABC&D 2 POINT REP. EFF GRAV ICW CONTROL PANEL OCEANWLK LS SOFTSTART LIFT STATION E MARINA L/S REPLACE 4 WETWELL TOPS MASTER LS CONTROL UPGRADE Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Irma Hurricane Matthew Hurricane Matthew PHORPHOROUS TREATMENT FAC REPLACE DISKS KRUGER DISF INFLUENT SCREENS (2) REPLACE EFF PUMP #2 REPLACE RAS PUMP & MOTOR REPLAC INFLUENT PUMP WWTP PHOSPHOROUS TREATMENT FAC REPLACE DISK - KRUGER DIS TWO EFFLUENT SCREEN REPLA REPLACE INFLUENT PUMP REPLACE CLARIFER DRIVES 2ND CETNRIFUGE CENTIRFUGE Hurricane Matthew Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Irma Hurricane Matthew Hurricane Matthew Hurricane Irma LAND - EASEMENT SEMINOLE STREET SCAPE SALTAIR DRAINAGE UPGRADE SE SEMINOLE RD DRAIN IMPR AQUATIV GARDENS POND IMPR JASMINE POND BANK RESTORA SWMPU PROJ-W PLAZA @ CARN SALTAIR DRAINAGE IMP SEMINOLE RD SOUTH DRAINAG PREPARED 05/23/2017, 8:01:34 CITY OF ATLANTIC BEACH PAGE 1 PROGRAM: GM285L PROJECT REPORT PROJECT REPORT THRU September 2016 Fund 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 110 110 120 130 131 131 131 131 131 131 131 131 131 131 131 131 131 131 131 300 300 320 320 320 320 320 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 410 420 420 420 420 470 470 470 470 470 470 470 470 470 470 470 470 470 470 470 470 Dept / Div 1003 1009 1011 1012 1012 1012 1012 2001 2001 2001 2001 2001 3005 5001 5001 5001 5001 5001 5002 5002 5002 5002 5002 5002 5002 5002 5002 5002 5002 5002 5002 5002 5002 6020 6020 6020 6020 6020 6020 6020 5002 5002 6040 5002 5002 5002 5002 5002 5002 5002 5002 5002 6020 6020 6020 6020 6020 6020 6020 2000 2000 6040 6040 6040 6040 6040 5502 5502 5502 5502 5502 5502 5502 5502 5502 5502 5502 5502 5502 5502 5504 5504 5504 5504 5504 5504 5504 5504 5504 5504 5504 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5506 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 5508 4201 4201 4201 4201 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 GRAN Act / Sub 513 519 516 519 519 519 519 521 521 521 521 521 522 541 541 541 541 541 541 541 541 541 541 541 541 541 541 541 541 541 541 541 541 572 572 572 572 572 572 572 541 541 572 541 541 541 541 541 541 541 541 541 572 572 572 572 572 572 572 521 521 572 572 572 572 572 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 533 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 535 524 534 534 534 538 538 538 538 538 538 538 538 538 538 538 538 538 538 538 538 TO Elem 51 34 52 14 15 21 24 34 44 49 51 52 52 14 21 24 46 52 14 14 15 21 21 24 24 34 34 34 34 44 52 52 52 14 21 24 34 46 52 63 63 63 63 63 62 63 63 63 63 63 63 63 63 63 63 63 63 63 63 62 62 63 63 63 63 63 14 15 21 24 34 52 63 63 63 63 63 63 63 63 14 15 21 24 63 63 63 63 63 63 63 14 15 21 24 34 34 52 63 63 63 63 63 63 63 63 63 63 63 14 15 21 24 34 34 46 52 63 63 63 63 63 63 63 63 63 63 63 63 63 34 14 21 24 14 15 21 24 34 52 52 61 63 63 63 63 63 63 63 63 AL Obj 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99 0 0 0 0 0 0 0 2 3 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 16 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 BUDGET 10000 119324 850056 40000 11000 89000 3000 -62099 261383 26000 100000 250000 62151 162330 50880 125000 30000 90000 -6 40000 5389660 150000 42234 33459 6 540000 42714 130000 630 10000 47999 31001 22000 124340 15660 100000 100000 175000 100000 700000 160000 711247 -1028 852764 406704 19000 55000 30000 20000 6500 20000 24000 100000 382854 6000 20000 99944 56988 22000 225000 6500 42000 22000 225000 129573 -2000 375000 5000 680 -99943 650000 250000 100000 135000 349941 650000 150000 YTD TOTAL 22.77 100 12.83 152.38 10.11 11.24 7.8 175 297.66 12060.4 656.52 3291.16 1575 376.44 28 5.11 576.12 364 389.52 162.9 13.49 12.36 27.59 4.64 25.37 1125 5072.75 24.25 48.5 6838.1 1923.6 1736.68 1963.55 612.3 45.65 16.74 44292.28 5552.88 4684.78 5619.04 118860.02 200056.08 10213.63 17286.73 22444.68 11880 5394.48 2544481.51 98688.35 2035 42612.67 329.5 12.22 25.24 6.54 5500.1 95.3 8575.29 377.71 0.28 27.99 10.89 149105.1 10077.71 428.54 0.28 32.41 8.41 4854.05 33770.1 47.65 528263.52 206671.7 3324.63 6859.9 9744.1 27972.44 90.66 0.28 6.95 1.28 1819.95 136.5 374.52 95.3 362110.7 49943.5 6988.2 20320.5 6392.79 31083.8 381362.02 9.29 0.68 0.59 242.63 10.11 17.78 16 1000 4353.64 900 679.65 56119.32 15197.26 148493.3 98688.35 YTD BALANCE -22.77 -100 -12.83 -152.38 -10.11 -11.24 -7.8 -175 -297.66 -12060.4 -656.52 -3291.16 -1575 -376.44 -28 -5.11 -576.12 -364 -389.52 -162.9 -13.49 -12.36 -27.59 -4.64 -25.37 -1125 -5072.75 -24.25 -48.5 -6838.1 -1923.6 -1736.68 -1963.55 -612.3 -45.65 -16.74 -44292.28 -5552.88 -4684.78 4380.96 463.98 649999.92 40000 11000 89000 3000 -62099 251169.37 26000 82713.27 250000 39706.32 162330 39000 125000 24605.52 90000 -6 40000 2845178.49 51311.65 42234 31424 6 540000 101.33 -329.5 -12.22 -25.24 -6.54 -5500.1 -95.3 130000 630 10000 47999 31001 13424.71 124340 15660 -377.71 -0.28 -27.99 -10.89 100000 100000 25894.9 100000 700000 160000 701169.29 -428.54 -0.28 -32.41 -8.41 -4854.05 -33770.1 -47.65 -1028 324500.48 200032.3 19000 55000 30000 20000 3175.37 13140.1 14255.9 72027.56 -90.66 -0.28 -6.95 -1.28 -1819.95 -136.5 -374.52 -95.3 20743.3 6000 20000 50000.5 49999.8 1679.5 225000 107.21 10916.2 22000 225000 129573 -2000 -6362.02 -9.29 -0.68 -0.59 -242.63 -10.11 -17.78 -16 -1000 -4353.64 -900 5000 0.35 -99943 650000 193880.68 84802.74 135000 201447.7 650000 51311.65 ENCUMBRANCE PM1404 PM1501 PM1502 PM1503 PM1504 PM1505 PS1402 PS1501 PU0805 PU1403 PU1404 PU1408 PU1410 PU1501 PU1502 PU1503 PU1504 PU1505 PU1506 PU1507 PU1508 PU1509 PU1601 PU1602 PU1603 PU1604 PU1605 PU1606 PU1607 PU1608 PU1609 PU1610 PU1611 PU1612 PU1613 PU1614 PU1615 PU1616 PW1405 PW1406 PW1407 PW1408 PW1409 PW1411 PW1412 PW1501 PW1502 PW1503 PW1504 PW1601 PW1602 GATE-ELECTRC-DUTT ISLE PK RUSSELL PK RENOVATION HOWELL PK PARKING LOT IMP DONNER PK PLAYGRND LIGHTS BULL PK PLAYGRND EQUIPMT DUTTON ISLE RD IMPROVMENT LIFE GUARD BLDG IMP NEW POLICE BLDG-DES/CONST RECLAIM WATER FACILITY RPLC WM SEA OATS&PARK TER INLINE VALVE INSTALLATION EFFLUENT OUTFALL REPLCMT CONNECT AIA @ MALLARD CVE WELL LOGGING-6 WELLS UPDATE MODELS WTR MAIN RPLC-SEMINOLE RD EFF OUTFALL @ SHERMAN PT WETWLL LINE-MIM COVE LS WETWELL LINE-FAIRWAY V LS EFF GRAV OUTFL-TELEVISE FENCE/WALL @ WWTP & GATES RPLC IRR SYST W/REUSE SYS NORTH FENCE REPLACE WTP2 SOFT STARTS - WTP1, 2 &3 CHLORINE AUTO CONTROL VAL CONTROL BUBBLER SYSTEM REPLACE SEASPRAY H20 SERV ATLANTIC WATER MAIN REPLA SEWER SYSTEM REHAB SEAOAT CONTROL PANEL LIFT STA WW SOFTSTARTS LIFT ST. ABC&D 2 POINT REP. EFF GRAV ICW PHORPHOROUS TREATMENT FAC REPLACE DISKS KRUGER DISF INFLUENT SCREENS (2) REPLACE EFF PUMP #2 REPLACE RAS PUMP & MOTOR REPLAC INFLUENT PUMP WWTP SIDEWALK AND CURDS SALTAIR/STURDIVAN SIDEWLK SEMINOLE STREET SCAPE Marsh Project Ped Path MRSH OVRLOOK+KAYAK LAUNCH SALTAIR DRAINAGE UPGRADE SE SEMINOLE RD DRAIN IMPR BIKE RACKS & STREET LIGHT FRANCIS AVE DRAINAGE IMPR BEGONIA W6TH-9TH DESIGN CH PARK LOT LIGHTS-LAST TOWNCENTER IMPR DECK & BR VET PARK PLAYSET