|
CITY OI(' =QUOT LAKES Interim Financial Rep(( - Monthly Comparison ( 26/2006
<br /> As of 05/2612006
<br /> For the Month Ended May Year to Date
<br /> Water
<br /> Budget Actual Variance Budget Actual Variance
<br /> Receipts:
<br /> Interest Earnings $583.33 $0.00 ($583.33) $7,000.00 $5,254.84 ($1,745.16)
<br /> Water Sales $18,085.00 $14,943.33 ($3,141.67) $217,020.00 $87,218.86 ($129,801.14)
<br /> Water Availability Charge $583.33 $0.00 ($583.33) $7,000.00 $0.00 ($7,000.00)
<br /> State Sales Tax Collected $0.00 $266.00 $266.00 $0.00 $1,280.27 $1,280.27
<br /> Water Meter Deposits $208.33 $0.00 ($208.33) $2,500.00 $225.00 ($2,275.00)
<br /> Refunds & Reimbursements $0.00 $8.20 $8.20 $0.00 $845.21 $845.21
<br /> Total Revenues $19,460.00 $15,217.53 ($4,242.47) $233,520.00 $94,824.18 ($138,695.82)
<br /> Other Financing Sources:
<br /> Sale of Investments $0.00 $0.00
<br /> Transfers from other Funds $0.00 $0.00
<br /> Disbursements:
<br /> Water
<br /> Wages $3,833.33 $3,283.53 ($549.80) $46,000.00 $18,440.16 $27,559.84
<br /> City Share-PERA Contrib. $230.00 $204.16 ($25.84) $2,760.00 $1,139.42 $1,620.58
<br /> City Share-FICA Contrib. $237.67 $197.25 ($40.42) $2,852.00 $1,117.57 $1,734.43
<br /> City Share-MED. Contrib. $55.58 $46.14 ($9.44) $667.00 $261.42 $405.58
<br /> City Share-Health Ins. $323.67 $323.64 ($0.03) $3,884.00 $1,618.20 $2,265.80
<br /> City Share-Life Ins. $3.42 $3.40 ($0.02) $41.00 $13.60 $27.40
<br /> Unemployment Compensation $0.00 $1,170.00 $1,170.00 $0.00 $1,170.00 ($1,170.00)
<br /> Office Supplies $83.33 $19.44 ($63.89) $1,000.00 $639.74 $360.26
<br /> Clothing Allowance $25.00 $79.98 $54.98 $300.00 $79.98 $220.02
<br /> Sales& Use Tax $250.00 $0.00 ($250.00) $3,000.00 $2,254.00 $746.00
<br /> Engineering Fees $208.33 $57.50 ($150.83) $2,500.00 $57.50 $2,442.50
<br /> Medical $8.33 $0.00 ($8.33) $100.00 $11.25 $88.75
<br /> Risk Management $83.33 $0.00 ($83.33) $1,000.00 $185.00 $815.00
<br /> Travel/Conference/Schools $62.50 $36.71 ($25.79) $750.00 $201.46 $548.54
<br /> Telephone $100.00 $97.90 ($2.10) $1,200.00 $433.23 $766.77
<br /> Postage $83.33 $6.61 ($76.72) $1,000.00 $147.98 $852.02
<br /> Publishing $25.00 $0.00 ($25.00) $300.00 $18.75 $281.25
<br /> Insurance $500.00 $175.14 ($324.86) $6,000.00 $3,308.59 $2,691.41
<br /> Electricity $708.33 $774.33 $66.00 $8,500.00 $4,057.72 $4,442.28
<br /> Heating $291.67 $255.17 ($36.50) $3,500.00 $1,650.83 $1,849.17
<br /> Fuel $166.67 $42.21 ($124.46) $2,000.00 $177.20 $1,822.80
<br /> Page 1
<br />
|