CITY OF PEQUOT LAKES Interim Financial Report - Monthly Comparison 10/31/2006
<br /> As of 10/31/2006
<br /> For the Month Ended October 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 $0.00 $0.00 $0.00 $141.83 $141.83
<br /> Interest Earnings $583.33 $0.00 ($583.33) $7,000.00 $12,066.03 $5,066.03
<br /> Water Sales $18,085.00 $17,105.76 ($979.24) $217,020.00 $195,727.96 ($21,292.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 $282.61 $282.61 $0.00 $3,317.40 $3,317.40
<br /> Water Meter Deposits $208.33 $0.00 ($208.33) $2,500.00 $675.00 ($1,825.00)
<br /> Refunds& Reimbursements $0.00 $207.35 $207.35 $0.00 $8,482.84 $8,482.84
<br /> Total Revenues $19,460.00 $17,595.72 ($1,864.28) $233,520.00 $220,445.61 ($13,074.39)
<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,196.59 ($636.74) $46,000.00 $36,848.38 $9,151.62
<br /> City Share-PERA Contrib. $230.00 $204.16 ($25.84) $2,760.00 $2,238.21 $521.79
<br /> City Share-FICA Contrib. $237.67 $196.79 ($40.88) $2,852.00 $2,183.95 $668.05
<br /> City Share-MED. Contrib. $55.58 $46.04 ($9.54) $667.00 $510.86 $156.14
<br /> City Share-Health Ins. $323.67 $0.00 ($323.67) $3,884.00 $2,589.12 $1,294.88
<br /> City Share-Life Ins. $3.42 $3.20 ($0.22) $41.00 $29.80 $11.20
<br /> Unemployment Compensation $0.00 $0.00 $0.00 $0.00 $1,170.00 ($1,170.00)
<br /> Office Supplies $83.33 $170.27 $86.94 $1,000.00 $902.98 $97.02
<br /> Clothing Allowance $25.00 $165.75 $140.75 $300.00 $245.73 $54.27
<br /> Sales& Use Tax $250.00 $1,354.00 $1,104.00 $3,000.00 $4,642.00 ($1,642.00)
<br /> Engineering Fees $208.33 $0.00 ($208.33) $2,500.00 $932.50 $1,567.50
<br /> Medical $8.33 $0.00 ($8.33) $100.00 $27.50 $72.50
<br /> Risk Management $83.33 $7.50 ($75.83) $1,000.00 $265.25 $734.75
<br /> Travel/Conference/Schools $62.50 $0.00 ($62.50) $750.00 $201.46 $548.54
<br /> Telephone $100.00 $58.45 ($41.55) $1,200.00 $902.26 $297.74
<br /> Postage $83.33 $26.58 ($56.75) $1,000.00 $468.09 $531.91
<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 /> Electricity $708.33 $963.78 $255.45 $8,500.00 $8,717.91 ($217.91)
<br /> P, ) 1
<br />
|