|
CITY OFEQUOT LAKES Interim Financial Rep Monthly Comparison ?6/28/2005
<br /> As of 06/28/2005
<br /> For the Month Ended June Year to Date
<br /> Water
<br /> Budget Actual Variance Budget Actual Variance
<br /> Receipts:
<br /> Interest Earnings $458.33 $0.00 ($458.33) $5,500.00 $0.00 ($5,500.00)
<br /> Water Sales $15,228.58 $14,677.10 ($551.48) $182,743.00 $79,637.54 ($103,105.46)
<br /> Water Availability Charge $500.00 $4,500.00 $4,000.00 $6,000.00 $6,000.00 $0.00
<br /> State Sales Tax Collected $0.00 $316.17 $316.17 $0.00 $1,241.29 $1,241.29
<br /> Water Meter Deposits $441.67 $2,125.00 $1,683.33 $5,300.00 $2,850.00 ($2,450.00)
<br /> Sale of Gen. Fixed Assets $0.00 $0.00 $0.00 $0.00 $150.00 $150.00
<br /> Refunds& Reimbursements $0.00 $531.10 $531.10 $0.00 $1,153.06 $1,153.06
<br /> Total Revenues $16,628.58 $22,149.37 $5,520.79 $199,543.00 $91,031.89 ($108,511.11)
<br /> Other Financing Sources:
<br /> Sale of Investments $0.00 $0.00
<br /> Transfers from other Funds $3,000.00 $3,000.00
<br /> Disbursements:
<br /> Escrow
<br /> Repair/Maint/Services $0.00 $3,473.00 $3,473.00 $0.00 $3,473.00 ($3,473.00)
<br /> Water
<br /> Wages $3,258.25 $2,898.00 ($360.25) $39,099.00 $18,184.75 $20,914.25
<br /> City Share-PERA Contrib. $180.17 $162.38 ($17.79) $2,162.00 $979.54 $1,182.46
<br /> City Share-FICA Contrib. $202.00 $172.71 ($29.29) $2,424.00 $959.52 $1,464.48
<br /> City Share-MED. Contrib. $47.25 $19.32 ($27.93) $567.00 $227.40 $339.60
<br /> City Share-Health Ins. $487.50 $509.58 $22.08 $5,850.00 $1,528.74 $4,321.26
<br /> City Share-Life Ins. $3.42 $3.40 ($0.02) $41.00 $20.40 $20.60
<br /> Office Supplies $45.83 $54.75 $8.92 $550.00 $367.26 $182.74
<br /> Clothing Allowance $25.00 $77.34 $52.34 $300.00 $77.34 $222.66
<br /> Sales& Use Tax $0.00 $0.00 $0.00 $0.00 $1,003.65 ($1,003.65)
<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 $0.00 $100.00
<br /> Travel/Conference/Schools $62.50 $67.64 $5.14 $750.00 $595.60 $154.40
<br /> Telephone $83.33 $59.98 ($23.35) $1,000.00 $551.53 $448.47
<br /> Postage $41.67 $3.50 ($38.17) $500.00 $276.73 $223.27
<br /> Publishing $16.67 $0.00 ($16.67) $200.00 $0.00 $200.00
<br /> Insurance $291.67 $3,867.28 $3,575.61 $3,500.00 $4,485.28 ($985.28)
<br /> Electricity $666.67 $717.97 $51.30 $8,000.00 $4,276.25 $3,723.75
<br /> Heating $291.67 $73.27 ($218.40) $3,500.00 $1,374.70 $2,125.30
<br /> Repair/Maint/Services $1,250.00 $2,525.76 $1,275.76 $15,000.00 $6,782.58 $8,217.42
<br /> Page 1
<br />
|