|
CITY C( EQUOT LAKES Interim Financial Red - Monthly Comparison 12712006
<br /> As of 12/27/2006
<br /> For the Month Ended December Year to Date
<br /> Water
<br /> Budget Actual Variance Budget Actual Variance
<br /> Receipts:
<br /> Local Government Aid $0.00 $0.00 $0.00 $0.00 $34.55 $34.55
<br /> Special Asses- Principal $0.00 $39.05 $39.05 $0.00 $78.09 $78.09
<br /> Interest Earnings $583.33 $0.00 ($583.33) $7,000.00 $15,514.02 $8,514.02
<br /> Water Sales $18,085.00 $14,545.54 ($3,539.46) $217,020.00 $229,247.60 $12,227.60
<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 $189.87 $189.87 $0.00 $3,879.36 $3,879.36
<br /> Water Meter Deposits $208.33 $0.00 ($208.33) $2,500.00 $675.00 ($1,825.00)
<br /> Refunds& Reimbursements $0.00 $279.57 $279.57 $0.00 $8,809.53 $8,809.53
<br /> Total Revenues $19,460.00 $15,054.03 ($4,405.97) $233,520.00 $258,238.15 $24,718.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,833.33 $4,506.86 $673.53 $46,000.00 $45,040.61 $959.39
<br /> City Share-PERA Contrib. $230.00 $126.46 ($103.54) $2,760.00 $2,482.91 $277.09
<br /> City Share-FICA Contrib. $237.67 $241.72 $4.05 $2,852.00 $2,648.79 $203.21
<br /> City Share-MED. Contrib. $55.58 $56.55 $0.97 $667.00 $619.61 $47.39
<br /> City Share-Health Ins. $323.67 $0.00 ($323.67) $3,884.00 $2,953.98 $930.02
<br /> City Share-Life Ins. $3.42 $1.60 ($1.82) $41.00 $33.00 $8.00
<br /> Unemployment Compensation $0.00 $0.00 $0.00 $0.00 $1,170.00 ($1,170.00)
<br /> Office Supplies $83.33 $53.49 ($29.84) $1,000.00 $1,011.65 ($11.65)
<br /> Clothing Allowance $25.00 $0.00 ($25.00) $300.00 $245.73 $54.27
<br /> Sales & Use Tax $250.00 $0.00 ($250.00) $3,000.00 $4,642.00 ($1,642.00)
<br /> Engineering Fees $208.33 $345.00 $136.67 $2,500.00 $9,557.50 ($7,057.50)
<br /> Attorney Fees $0.00 $1,636.96 $1,636.96 $0.00 $1,636.96 ($1,636.96)
<br /> Medical $8.33 $0.00 ($8.33) $100.00 $42.50 $57.50
<br /> Risk Management $83.33 $0.00 ($83.33) $1,000.00 $265.25 $734.75
<br /> Travel/Conference/Schools $62.50 $200.00 $137.50 $750.00 $401.46 $348.54
<br /> Telephone $100.00 $169.99 $69.99 $1,200.00 $1,202.66 ($2.66)
<br /> Postage $83.33 $40.58 ($42.75) $1,000.00 $599.23 $400.77
<br /> Publishing $25.00 $0.00 ($25.00) $300.00 $130.75 $169.25
<br /> Insurance $500.00 $0.00 ($500.00) $6,000.00 $5,445.79 $554.21
<br /> Page 1
<br />
|