CITY OF PF�'IOT LAKES /
<br /> 2006 INTERIM .,DGET REPORT l
<br /> WATER FUND
<br /> BEGINNING FUND BALANCE $ 345,328.45
<br /> 2006 2006 ACTUAL DIFFERENCE
<br /> RECEIPTS BUDGET TO DATE OF NOTES
<br /> Local Government Aid $ - $ 34.55 $ 34.55 PERA aid
<br /> Special Assessments $ - $ 141.83 $ 141.83
<br /> Interest Earnings $ 7,000.00 $ 13,746.30 $ 6,746.30
<br /> Water Sales $ 217,020.00 $ 210,852.39 $ (6,167.61)
<br /> Water Availability Charge $ 7,000.00 $ - $ (7,000.00)
<br /> State Sales Tax Collected $ - $ 3,619.57 $ 3,619.57 revolving acct(see Sales& Use Tax below)
<br /> Water Meter Deposits $ 2,500.00 $ 675.00 $ (1,825.00)
<br /> Refunds& Reimbursements $ - $ 8,522.38 $ 8,522.38
<br /> TOTAL RECEIPTS $ 233,520.00 $ 237,592.02 $ 4,072.02
<br /> 2006 2006 ACTUAL DIFFERENCE
<br /> DISBURSEMENTS BUDGET TO DATE OF NOTES
<br /> Water
<br /> Wages $ 46,000.00 $ 40,533.75 $ (5,466.25
<br /> City Share- PERA $ 2,760.00 $ 2,356.45 $ (403.55)
<br /> City Share- FICA $ 2,852.00 $ 2,407.07 $ (444.93
<br /> City Share- MEDICARE $ 667.00 $ 563.06 $ (103.94)
<br /> City Share- Health Ins. $ 3,884.00 $ 2,953.98 $ 930.02)
<br /> City Share- Life Ins. $ 41.00 $ 31.40 $ (9.60)
<br /> Unemployment Compensation $ - $ 1,170.00 $ 1,170.00 former employee
<br /> Office Supplies $ 1,000.00 $ 958.16 $ (41.84)
<br /> Clothing Allowance $ 300.00 $ 245.73 $ (54.27)
<br /> Sales& Use Tax $ 3,000.00 $ 4,642.00 $ 1,642.00 $3,620 from commercial water customers-revolving acct(see above),
<br /> remaining amt is from vendors not charging sales tax
<br /> Engineering Fees $ 2,500.00 $ 9,212.50 $ 6,712.50 $710 WSN, $8,503 SCADA upgrade
<br /> Medical $ 100.00 $ 42.50 $ (57.50)
<br /> Risk Management $ 1,000.00 $ 265.25 $ (734.75
<br /> Travel/Conference/Schools $ 750.00 $ 201.46 $ (548.54)
<br /> Telephone $ 1,200.00 $ 1,032.67 $ (167.33)
<br /> Postage $ 1,000.00 $ 558.65 $ (441.35)
<br /> Publishing $ 300.00 $ 130.75 $ (169.25
<br /> Insurance $ 6,000.00 $ 5,445.79 $ (554.21)
<br /> Electricity $ 8,500.00 $ 91505.44 $ 1,005.44
<br /> Heating $ 3,500.00 $ 1,922.61 $ (1,577.39)
<br /> Fuel $ 2,000.00 $ 1,094.27 1 $ (905.73)
<br /> Page 14
<br />
|