CITY O( =QUOT LAKES Interim Financial Rep( • Monthly Comparison 24/2006
<br /> As of 03/24/2006
<br /> For the Month Ended March Year to Date
<br /> Water
<br /> Budsaet Actual Variance Budget Actual Variance
<br /> Receipts:
<br /> Interest Earnings $583.33 $0.00 ($583.33) $7,000.00 $2,526.04 ($4,473.96)
<br /> Water Sales $18,085.00 $13,487.42 ($4,597.58) $217,020.00 $51,670.29 ($165,349.71)
<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 $169.45 $169.45 $0.00 $658.97 $658.97
<br /> Water Meter Deposits $208.33 $0.00 ($208.33) $2,500.00 $225.00 ($2,275.00)
<br /> Refunds& Reimbursements $0.00 $790.17 $790.17 $0.00 $836.90 $836.90
<br /> Total Revenues $19,460.00 $14,447.04 ($5,012.96) $233,520.00 $55,917.20 ($177,602.80)
<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,317.92 ($515.41) $46,000.00 $10,068.76 $35,931.24
<br /> City Share-PERA Contrib. $230.00 $207.57 ($22.43) $2,760.00 $621.18 $2,138.82
<br /> City Share-FICA Contrib. $237.67 $200.79 ($36.88) $2,852.00 $609.48 $2,242.52
<br /> City Share-MED. Contrib. $55.58 $46.97 ($8.61) $667.00 $142.57 $524.43
<br /> City Share-Health Ins. $323.67 $323.64 ($0.03) $3,884.00 $970.92 $2,913.08
<br /> City Share-Life Ins. $3.42 $3.40 ($0.02) $41.00 $6.80 $34.20
<br /> Office Supplies $83.33 $8.92 ($74.41) $1,000.00 $620.30 $379.70
<br /> Clothing Allowance $25.00 $0.00 ($25.00) $300.00 $0.00 $300.00
<br /> Sales & Use Tax $250.00 $785.00 $535.00 $3,000.00 $1,572.00 $1,428.00
<br /> Engineering Fees $208.33 $0.00 ($208.33) $2,500.00 $0.00 $2,500.00
<br /> Medical $8.33 $0.00 ($8.33) $100.00 $11.25 $88.75
<br /> Risk Management $83.33 $150.00 $66.67 $1,000.00 $185.00 $815.00
<br /> Travel/Conference/Schools $62.50 $0.00 ($62.50) $750.00 $0.00 $750.00
<br /> Telephone $100.00 $59.26 ($40.74) $1,200.00 $189.35 $1,010.65
<br /> Postage $83.33 $3.66 ($79.67) $1,000.00 $66.37 $933.63
<br /> Publishing $25.00 $18.75 ($6.25) $300.00 $18.75 $281.25
<br /> Insurance $500.00 $1,068.60 $568.60 $6,000.00 $2,064.85 $3,935.15
<br /> Electricity $708.33 $801.38 $93.05 $8,500.00 $2,427.86 $6,072.14
<br /> Heating $291.67 $397.82 $106.15 $3,500.00 $959.12 $2,540.88
<br /> Fuel $166.67 $12.83 ($153.84) $2,000.00 $134.99 $1,865.01
<br /> Repair/Maint/Services $1,166.67 $675.88 ($490.79) $14,000.00 $1,632.59 $12,367.41
<br /> Page 1
<br />
|