|
CITY O( =QUOT LAKES Interim Financial Rep • Monthly Comparison 30/2007
<br /> As of 01/30/2007
<br /> For the Month Ended January Year to Date
<br /> Water
<br /> Budget Actual Variance Budget Actual Variance
<br /> Receipts:
<br /> MISCELLANEOUS REVENUES $0.00 $105.00 $105.00 $0.00 $105.00 $105.00
<br /> Interest Earnings $833.33 $0.00 ($833.33) $10,000.00 $0.00 ($10,000.00)
<br /> Water Sales $21,526.67 $15,810.73 ($5,715.94) $258,320.00 $15,810.73 ($242,509.27)
<br /> State Sales Tax Collected $0.00 $212.72 $212.72 $0.00 $212.72 $212.72
<br /> Water Meter Deposits $208.33 $0.00 ($208.33) $2,500.00 $0.00 ($2,500.00)
<br /> Refunds& Reimbursements $0.00 $24.40 $24.40 $0.00 $24.40 $24.40
<br /> Total Revenues $22,568.33 $16,152.85 ($6,415.48) $270,820.00 $16,152.85 ($254,667.15)
<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,970.00 $2,684.57 ($1,285.43) $47,640.00 $2,684.57 $44,955.43
<br /> City Share-PERA Contrib. $248.33 $204.34 ($43.99) $2,980.00 $204.34 $2,775.66
<br /> City Share-FICA Contrib. $246.67 $218.55 ($28.12) $2,960.00 $218.55 $2,741.45
<br /> City Share-MED. Contrib. $58.33 $51.13 ($7.20) $700.00 $51.13 $648.87
<br /> City Share-Health Ins. $481.67 $0.00 ($481.67) $5,780.00 $0.00 $5,780.00
<br /> City Share-Life Ins. $3.33 $1.60 ($1.73) $40.00 $1.60 $38.40
<br /> Office Supplies $116.67 $19.27 ($97.40) $1,400.00 $19.27 $1,380.73
<br /> Clothing Allowance $29.17 $0.00 ($29.17) $350.00 $0.00 $350.00
<br /> Sales& Use Tax $250.00 $882.00 $632.00 $3,000.00 $882.00 $2,118.00
<br /> Engineering Fees $416.67 $0.00 ($416.67) $5,000.00 $0.00 $5,000.00
<br /> Medical $8.33 $0.00 ($8.33) $100.00 $0.00 $100.00
<br /> Risk Management $83.33 $0.00 ($83.33) $1,000.00 $0.00 $1,000.00
<br /> Travel/Conference/Schools $62.50 $0.00 ($62.50) $750.00 $0.00 $750.00
<br /> Telephone $100.00 ($3.21) ($103.21) $1,200.00 ($3.21) $1,203.21
<br /> Postage $83.33 $55.00 ($28.33) $1,000.00 $55.00 $945.00
<br /> Publishing $29.17 $0.00 ($29.17) $350.00 $0.00 $350.00
<br /> Insurance $500.00 $0.00 ($500.00) $6,000.00 $0.00 $6,000.00
<br /> Electricity $708.33 $714.33 $6.00 $8,500.00 $714.33 $7,785.67
<br /> Heating $333.33 $147.01 ($186.32) $4,000.00 $147.01 $3,852.99
<br /> Fuel $250.00 $0.00 ($250.00) $3,000.00 $0.00 $3,000.00
<br /> Repair/MainUServices $1,333.33 $40.60 ($1,292.73) $16,000.00 $40.60 $15,959.40
<br /> Page 1
<br />
|