CITY O( =QUOT LAKES Interim Financial Rep( Monthly Comparison t 27/2007
<br /> Budget Actual Variance Bud et Actual Variance
<br /> Emp. Share-Health/Life In $0.00 $858.50 $858.50 $0.00 $2,575.50 ($2,575.50)
<br /> City Share-PERA Contrib. $99.17 $120.25 $21.08 $1,190.00 $239.75 $950.25
<br /> City Share-FICA Contrib. $122.50 $49.29 ($73.21) $1,470.00 $73.47 $1,396.53
<br /> City Share-MED. Contrib. $29.17 $46.41 $17.24 $350.00 $69.41 $280.59
<br /> City Share-Life Ins. $16.67 $14.40 ($2.27) $200.00 $43.20 $156.80
<br /> Office Supplies $41.67 $42.59 $0.92 $500.00 $228.33 $271.67
<br /> Travel/Conference/Schools $333.33 $0.00 ($333.33) $4,000.00 $489.18 $3,510.82
<br /> Postage $16.67 $0.00 ($16.67) $200.00 $1.02 $198.98
<br /> Publishing $8.33 $0.00 ($8.33) $100.00 $0.00 $100.00
<br /> Dues, Subscrip, Licensing $0.00 $0.00 $0.00 $0.00 $36.00 ($36.00)
<br /> Contingency $2,375.00 $0.00 ($2,375.00) $28,500.00 $0.00 $28,500.00
<br /> Clerk
<br /> Wages $7,657.50 $10,300.80 $2,643.30 $91,890.00 $22,042.10 $69,847.90
<br /> City Share-PERA Contrib. $479.17 $629.38 $150.21 $5,750.00 $1,469.46 $4,280.54
<br /> City Share-FICA Contrib. $475.00 $597.74 $122.74 $5,700.00 $1,386.46 $4,313.54
<br /> City Share-MED. Contrib. $111.67 $139.78 $28.11 $1,340.00 $324.24 $1,015.76
<br /> City Share-Health Ins. $893.33 $1,058.58 $165.25 $10,720.00 $3,175.74 $7,544.26
<br /> City Share-Life Ins. $10.00 $9.60 ($0.40) $120.00 $28.80 $91.20
<br /> Office Supplies $466.67 $207.31 ($259.36) $5,600.00 $1,876.31 $3,723.69
<br /> Attorney Fees $416.67 $184.13 ($232.54) $5,000.00 $282.65 $4,717.35
<br /> Risk Management $83.33 $15.00 ($68.33) $1,000.00 $30.00 $970.00
<br /> Travel/Conference/Schools $208.33 $20.00 ($188.33) $2,500.00 $46.00 $2,454.00
<br /> Telephone $208.33 $188.49 ($19.84) $2,500.00 $381.86 $2,118.14
<br /> Postage $100.00 $0.00 ($100.00) $1,200.00 $167.20 $1,032.80
<br /> Publishing $125.00 $0.00 ($125.00) $1,500.00 $105.00 $1,395.00
<br /> Repair/Maint/Services $41.67 $30.00 ($11.67) $500.00 $52.50 $447.50
<br /> Dues, Subscrip, Licensing $892.50 $480.00 ($412.50) $10,710.00 $992.00 $9,718.00
<br /> Contract Services $2,291.67 $1,837.62 ($454.05) $27,500.00 $2,186.36 $25,313.64
<br /> Capital Outlay $1,666.67 $0.00 ($1,666.67) $20,000.00 $11,800.00 $8,200.00
<br /> E-911 Address Fee
<br /> Contract Services $100.00 $0.00 ($100.00) $1,200.00 $25.00 $1,175.00
<br /> Planning&Zoning
<br /> Wages $4,244.17 $5,590.05 $1,345.88 $50,930.00 $12,094.53 $38,835.47
<br /> Emp. Share-Health/Life In $0.00 $128.78 $128.78 $0.00 $386.34 ($386.34)
<br /> City Share-PERA Contrib. $215.83 $298.89 $83.06 $2,590.00 $691.08 $1,898.92
<br /> City Share-FICA Contrib. $263.33 $381.49 $118.16 $3,160.00 $801.72 $2,358.28
<br /> City Share-MED. Contrib. $61.67 $89.21 $27.54 $740.00 $187.47 $552.53
<br /> City Share-Health Ins. $827.50 $797.08 ($30.42) $9,930.00 $2,391.24 $7,538.76
<br /> City Share-Life Ins. $3.33 $3.20 ($0.13) $40.00 $9.60 $30.40
<br /> Office Supplies $170.00 $805.22 $635.22 $2,040.00 $2,638.21 ($598.21)
<br /> Clothing Allowance $4.17 $0.00 ($4.17) $50.00 $0.00 $50.00
<br /> Engineering Fees $500.00 $0.00 ($500.00) $6,000.00 $897.00 $5,103.00
<br /> Attorney Fees $500.00 $2,177.15 $1,677.15 $6,000.00 $3,612.38 $2,387.62
<br /> Risk Management $41.67 $0.00 ($41.67) $500.00 $0.00 $500.00
<br /> Page 2
<br />
|