CITY OF PEQUOT LAKES
<br /> DETAIL EXPENDITURES WITH COMPARISON TO BUDGET
<br /> FOR THE 5 MONTHS ENDING MAY 31, 2007
<br /> FUND 101 - GENERAL FUND
<br /> PERIOD BUDGET %OF
<br /> ACTUAL YTD ACTUAL AMOUNT VARIANCE BUDGET
<br /> COUNCIL
<br /> 101-41110-100 WAGES 2,095.00 12,937.25 23,700.00 10,762.75 54.59
<br /> 101-41110-112 EMPLOYEE SHARE-INSURANCE .00 4,292.50 .00 ( 4,292.50) .00
<br /> 101-41110-121 EMPLOYER SHARE-PERA 64.25 368.25 1,190.00 821.75 30.95
<br /> 101-41110-122 EMPLOYER SHARE-FICA 24.18 123.69 1,470.00 1,346.31 8.41
<br /> 101-41110-125 EMPLOYER SHARE-MEDICARE 24.29 118.42 350.00 231.58 33.83
<br /> 101-41110-133 EMPLOYER SHARE-LIFE INSURANC 11.20 67.20 200.00 132.80 33.60
<br /> 101-41110-200 OFFICE SUPPLIES .00 428.33 500.00 71.67 85.67
<br /> 101-41110-308 TRAVEL/CONFERENCES/SCHOOLS .00 489.18 4,000.00 3,510.82 12.23
<br /> 101-41110-322 POSTAGE .00 1.02 200.00 198.98 .51
<br /> 101-41110-350 PUBLISHING .00 .00 100.00 100.00 .00
<br /> 101-41110-433 DUES/LICENSING/SUBSCRIPTIONS .00 36.00 .00 ( 36.00) .00
<br /> 101-41110-437 CONTINGENCY .00 3,000.00 28,500.00 25,500.00 10.53
<br /> TOTAL COUNCIL 2,218.92 21,861.84 60,210.00 38,348.16 36.31
<br /> CLERK
<br /> 101-41400-100 WAGES 6,915.55 37,963.20 91,890.00 53,926.80 41.31
<br /> 101-41400-121 EMPLOYER SHARE-PERA 430.50 2,328.13 5,750.00 3,421.87 40.49
<br /> 101-41400-122 EMPLOYER SHARE-FICA 400.45 2,185.04 5,700.00 3,514.96 38.33
<br /> 101-41400-125 EMPLOYER SHARE-MEDICARE 93.66 511.01 1,340.00 828.99 38.14
<br /> 101-41400-131 EMPLOYER SHARE-HEALTH INSURA 860.46 5,162.86 10,720.00 5,557.14 48.16
<br /> 101-41400-133 EMPLOYER SHARE-LIFE INSURANC 16.90 55.30 120.00 64.70 46.08
<br /> 101-41400-200 OFFICE SUPPLIES 129.32 2,799.73 5,600.00 2,800.27 50.00
<br /> 101-41400-304 ATTORNEY FEES 630.26 1,047.91 5,000.00 3,952.09 20.96
<br /> 101-41400-308 TRAVEUCONFERENCES/SCHOOLS .00 56.00 2,500.00 2,444.00 2.24
<br /> 101-41400-311 RISK MANAGEMENT .00 98.58 1,000.00 901.42 9.86
<br /> 101-41400-313 CONTRACT SERVICES .00 2,218.23 27,500.00 25,281.77 8.07
<br /> 101-41400-321 TELEPHONE 186.53 756.36 2,500.00 1,743.64 30.25
<br /> 101-41400-322 POSTAGE 150.00 544.40 1,200.00 655.60 45.37
<br /> 101-41400-350 PUBLISHING .00 105.00 1,500.00 1,395.00 7.00
<br /> 101-41400-400 REPAIR/MAINTENANCE/SERVICES .00 49.22 500.00 450.78 9.84
<br /> 101-41400-433 DUES/LICENSING/SUBSCRIPTIONS 500.00 1,492.00 10,710.00 9,218.00 13.93
<br /> 101-41400-500 CAPITAL OUTLAY 11,800.00 23,600.00 20,000.00 ( 3,600.00) 118.00
<br /> TOTAL CLERK 22,113.63 80,972.97 193,530.00 112,557.03 41.84
<br /> SALES&USE TAX
<br /> 101-41420-310 SALES&USE TAX .00 983.00 1,400.00 417.00 70.21
<br /> TOTAL SALES&USE TAX .00 983.00 1,400.00 417.00 70.21
<br /> FOR ADMINISTRATION USE ONLY 41 %OF THE FISCAL YEAR HAS ELAPSED 05/30/2007 09:49AM PAGE: 3
<br />
|