|
CITY O( 2QUOT LAKES Interim Financial Rep( - Monthly Comparison l 24/2006
<br /> As of 04/24/2006
<br /> For the Month Ended April 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 $3,949.21 ($3,050.79)
<br /> Water Sales $18,085.00 $10,591.44 ($7,493.56) $217,020.00 $65,806.96 ($151,213.04)
<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 $97.94 $97.94 $0.00 $819.52 $819.52
<br /> Water Meter Deposits $208.33 $0.00 ($208.33) $2,500.00 $225.00 ($2,275.00)
<br /> Refunds& Reimbursements $0.00 $0.07 $0.07 $0.00 $836.97 $836.97
<br /> Total Revenues $19,460.00 $10,689.45 ($8,770.55) $233,520.00 $71,637.66 ($161,882.34)
<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 $1,868.48 ($1,964.85) $46,000.00 $13,677.63 $32,322.37
<br /> City Share-PERA Contrib. $230.00 $114.27 ($115.73) $2,760.00 $839.88 $1,920.12
<br /> City Share-FICA Contrib. $237.67 $111.22 ($126.45) $2,852.00 $828.61 $2,023.39
<br /> City Share-MED. Contrib. $55.58 $26.02 ($29.56) $667.00 $193.83 $473.17
<br /> City Share-Health Ins. $323.67 $323.64 ($0.03) $3,884.00 $1,294.56 $2,589.44
<br /> City Share-Life Ins. $3.42 $3.40 ($0.02) $41.00 $10.20 $30.80
<br /> Office Supplies $83.33 $0.00 ($83.33) $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 $682.00 $432.00 $3,000.00 $2,254.00 $746.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 $0.00 ($83.33) $1,000.00 $185.00 $815.00
<br /> Travel/Conference/Schools $62.50 $164.75 $102.25 $750.00 $164.75 $585.25
<br /> Telephone $100.00 $145.98 $45.98 $1,200.00 $335.33 $864.67
<br /> Postage $83.33 $75.00 ($8.33) $1,000.00 $141.37 $858.63
<br /> Publishing $25.00 $0.00 ($25.00) $300.00 $18.75 $281.25
<br /> Insurance $500.00 $1,068.60 $568.60 $6,000.00 $3,133.45 $2,866.55
<br /> Electricity $708.33 $855.53 $147.20 $8,500.00 $3,283.39 $5,216.61
<br /> Heating $291.67 $436.54 $144.87 $3,500.00 $1,395.66 $2,104.34
<br /> Fuel $166.67 $0.00 ($166.67) $2,000.00 $134.99 $1,865.01
<br /> Repair/Maint/Services $1,166.67 $3,684.83 $2,518.16 $14,000.00 $5,317.42 $8,682.58
<br /> Page 1
<br />
|