|
CITY OF HUGO
<br />PUBLIC WORKS FACILITY FUND
<br />ACCOUNT
<br />NUMBER
<br />ACCOUNT BALANCE BALANCE 2005 PROJECTED
<br />DESCRIPTION 12/3112004 12131/2005 ACTIVITY BUDGET
<br />417-000.000-010.100 Cash
<br />417-000.000-010.450 ;Accrued Interest Receivable
<br />417-000.000-120.200 Accounts Payable
<br />417-000.000-120.600 ,Contracts Payable
<br />417-000.000-253.000 Fund Balance
<br />REVENUES
<br />417-362.000-362.100 Interest Earnings
<br />417-392.000-392.030 Transfer from Water & Sewer Utility Fund
<br />417-393.000-393.100 Bond Proceeds
<br />$ 539,056.14 $
<br />$ 2,779.91 $
<br />$ /326,000.96) $
<br />$ (98,035.60)l $
<br />$ 117,799.49 1 $
<br />- $ (539.056.14)1 $
<br />- $ (2,779.91)1 $
<br />- 1 $ 326.000.96 1 $
<br />$ 98,035.60 ', $
<br />1 $ (117,799.49)': $
<br />$ 9,126.60 I $ 9,816.35 $
<br />$ - 1 $ 62,439.78 $
<br />$ 2,473,787.53 1 $ 2,473,787.53 I $
<br />2,482,914.13 $ 2,546,043.66 1 $ 63,129.53 $ 2,546,043.66
<br />6B9.75 ! $ 9,816.35
<br />62,439.78 $ 62,439.78
<br />- 1 $ 2,473,787.53
<br />EXPENDITURES
<br />Engineering Fees:
<br />417-431.000-403.303 WSB & Associates
<br />417-431.000-403.352 Pro(ect Testing Services
<br />Architect Fees:
<br />417-431.000-403.368 Construction Documents
<br />417-431.000-403.372 Community Room Revisions
<br />417-431.000-403.367 Bidding Fees
<br />417-431.000-403.369 Construction Administration
<br />417-431.000-403.370 Reimbursable Expenses
<br />Septic System Evaluation_
<br />417-4310D0-403.371 Ingleside Engineering
<br />Insurance:
<br />417-431.000-407.362 Builders Risk Insurance
<br />Utilities:
<br />417-431 0004(18381 _ Electricity (to be reimbursed by Parkos) $ 640.69 ' $ 1,723.54 . $ (1,062.85) $ 1,723.54
<br />417-431.000 408.381 Deducted from Retainage $ - $ (1,723.54) $ 1,723.54 $ (1,723.54)
<br />417-431.000-408.383 Gas (to be reimbursed by Parkos) $ 1,527.17 $ 4,716.47 $ (3,189.30) $ 4,716.47
<br />...
<br />417-431.000-408.383 Deducted from Retainage $ - $ (4,716.47) $ 4,716.47 (4,716.47)
<br />Permits:
<br />417-431.000-412.435 NPDES Permit
<br />Construction Contracts:
<br />417-431.000-413.504 Building Base Bid & Alternates (Parkos) $ 1,727,980.12 $ 1,735,329.12 $ (7,349_00) $ 1,735,329.12
<br />417-431.000-413.504 E• lectrical Work 1 $ - $ 925.00 $ (925.00) $ 925.00
<br />417-431 000-413.504! Snow Guards i $ - $ 17,600.00 ! $ (17,600.00) $ 17,600.00
<br />417-431.000-413.504 Change Locks 1 $ - $ 939.00 $ (939.00) $ 939.00
<br />417-431.000-413.504 Rice Lake Park Centre Signage I $ - $ 4,977.15 $ (4,977.15) $ 4,977.15
<br />417-431.000-413.504 Repaint Exterior $ - $ 3,553.00 ' $ (3,553.00) $ 3,553.00
<br />417-431 000-413.507 S• prinkler System ; $ - $ 7,475.00 $ (7,475.00) $ 7,475.00
<br />417-431.000-413.508 Sitework (Arnt Construction) 1 $ 232,731.80 $ 268,020.62 $ (35,288.82) $ 268,020.62
<br />417-431.000-413.508 I Silt Fence $ 62.05 $ 62.05 $ $ 62.05
<br />417-431.000-413.525 Water System (Ingleside Engineering) i $ 30,923.20 $ 30,923.20 $ $ 30,923.20
<br />417-431.000-413.518 S• anitary Sewer System (Ingleside Engineering) i $ 10,450.00 $ 10,450.00 $ $ 10,450.00
<br />417-431.000-413.503. Fencing (Century Fence) $ $ 16,896.00 $ (16,896.00) $ 16,896.00
<br />417-431000-403.333 Landscaping $ - $ 12,777.78 $ (12,777.78) $ 12,777.78
<br />Equipment: $ -
<br />417-431.000-413.505 I Welding Hood & Blower (Airgas North Central) $ 3,198.18 $ 3,198.18 $ $ 3,198.18
<br />417-431.000-413.512: Shop Sweeper (Tennant) $ 20,591.29 $ 21,381.62 $ (790.33) $ 21,381.62
<br />417-431.000-413.513; Vehicle Hoists (Pump & Meter Service) 1 $ 38,399.33 $ 37,899.33 $ 500.00 $ 37,899.33
<br />417-431.000-413.520 Exhaust Extraction System : $ 11,362.00 $ 12,363.88 $ (1,001.88) $ 12,363.88
<br />417-431.000-413.532 Poured Concrete Pit ; $ 15,980.80 $ 15,980.80 $ - $ 15,980.80
<br />417431.000-413.522 4,000 Gallon Holding Tank ; $ 6,696.72 $ 6,696.72 $ $ 6,696.72
<br />417-431.000-413.528 Bulk Fuel & Lubricant Tanks j $ 23,445.05 $ 24,858.26 $ (1,413.21), $ 24,858.26
<br />417-431.000-413.533 Air Compressor $ - 3,581.81 $ 3,581.81 $ - $ 3,581.81
<br />417-431.000-413.521 Air Lines $ 386.93 $ 1,569.90 $ (1,182.97), $ 1,569.90
<br />417431.000-413.526 Pressure WasherlWash Bay 9,202 52 $ 9,590.66 $ (388.14), $ 9,590.66
<br />:Furniture, Fixtures & Equipment
<br />417431.000413.515 Voice & Data Cabling $ 6,111.24 $ 6,384.12 . $
<br />417-431000-413.516 Shelving $ 3,846.22 $ 11,085.15 $
<br />417-431.000-413.535 Telephone System $ $ 26,749.26 $
<br />417-431.000-413.541 Blinds, Bench Vise, Hydraulic Lift, Cabinets... $ 1,579 41 $ 6189 79 $
<br />417-431.000-413.570 Office Furniture & Equipment 1 $ 3,546.45 $ 35,714.60 $
<br />Financing Costs
<br />Underwriters Discount
<br />417-470.000-403.316 Cost of Issuance
<br />Capitalized Interest
<br />Total Project Costs
<br />455.39
<br />11,661.40
<br />$
<br />455.39 1 $
<br />$ 11,661.40 11 $
<br />114,000.00 $ 114,000.00 1 $
<br />6,146.62 $ 6,146.62 i$
<br />7,600.00 1 $ 7,600.00 $
<br />30,400.00 $ 30,400.00 $
<br />10,000.00 ; $ 10,000.00 $
<br />350.00 . $ 350.00 $
<br />1,974.00
<br />$ 400.00 ` $ 400.00 $
<br />$ 455.39
<br />11,661.40
<br />$ 114,000.00
<br />$ 6,146.62
<br />$ 7,600.00
<br />$ 30 400.00
<br />$ 10,000.00
<br />350.00
<br />1,974.00 $ - $ 1,974.00
<br />- $ 400.00
<br />(272.88) I $ 6,384.12
<br />(7,238.93)1 $ 11,085.15
<br />(26,749.26) $ 26,749.26
<br />(4,610.38)1 $ 6,189.79
<br />132,168.15)1 $ 35,714.60
<br />I $ 2,335,230.39 $ 2,516,159.41 $ (180,929.02) $ 2,516,159.41
<br />29,884.25 $ 29,884.25 $
<br />I$
<br />$ 29,884.25
<br />-_$
<br />$ 29,884.25 $ 29,884.25
<br />$ 29,884.25
<br />$ 2,365,114.64 $ 2,546,043.66 $-(180,929.02
<br />$ 2,546,043.66
<br />Fund Balance $ 117,799.49 $ $ (117,799.49) $
<br />This fund was established to account for the construction of a public works facility. Funding was provided through the sale of capital: improvement bo
<br />Page 32
<br />
|