Loading...
HomeMy WebLinkAbout2009-06-30 Handouts BUDGET REPORT FOR GENERAL FUND AT 06-30-2009 CITY OF CENTERVILLE 07/08/094:33 PM Page 1 Monthly Revenue Report tervi{{e Current Period: JUNE 2009 'Estabfislid l1J57 2008 2009 JUNE 2009 %01 Account Oeser 2008 AmI YTD AmI Budgel 2009 AmI YTD AmI Balance Budget FUND 101 GENERAL FUND DEPT 41400 Administration R 101-41400-32100 Rental/Liquor Lie $19,050.00 $5,550.00 $20,000.00 $685.00 $4,445.00 $15,555.00 22.23% R 101-41400-34105 Sale of Maps and $15.00 $1.25 $2,000.00 $4.00 $10.25 $1,989.75 0.51% R 101-41400-34107 Assessment Sear $135.00 $45.00 $0.00 $0.00 $360.00 -$360.00 0.00% R 101-41400-36200 Miscellaneous Re $265.06 $33.50 $15,000.00 $49.81 $62.23 $14,937.77 0.41% R 101-41400-36270 Refunds/Reimbur $1,318.93 $366.41 $0.00 $0.00 $369.19 -$369.19 0.00% DEPT 41400 Administration $20,783.99 $5,996.16 $37,000.00 $738.81 $5,246.67 $31,753.33 OEPT 41910 Planning and Zoning R 101-41910-32215 Zoning Fees $0.00 $0.00 $2,000.00 $0.00 $700.00 $1,300.00 35.00% DEPT 42110 Police Administration R 101-42110-35000 Fines and Forfeit $29,796.90 $14,086.39 $35,000.00 $2,806.15 $16,167.25 $18,832.75 46.19% R 101-42110-35101 Police State Aid $37,266.55 $0.00 $35,000.00 $0.00 $0.00 $35,000.00 0.00% DEPT 42110 Police Administration $67,063.45 $14,086.39 $70,000.00 $2,806.15 $16,167.25 $53,832.75 DEPT 42285 Fire Protection R 101-42285-32000 Special Use/Burn $90.00 $60.00 $0.00 $0.00 $30.00 -$30.00 0.00% R 101-42285-33405 Fire Relief Aid $119,664.00 $4,000.00 $125,000.00 $0.00 $1,000.00 $124,000.00 0.80% DEPT 42285 Fire Protection $119,754.00 $4,060.00 $125,000.00 $0.00 $1,030.00 $123,970.00 DEPT 42400 Building Inspection (GENERAL) R 101-42400-32180 Plumbing Permits $1,177.00 $704.00 $2,000.00 $90.50 $389.50 $1,610.50 19.48% R 101-42400-32210 Building Permits $265,890.13 $107,151.87 $120,000.00 $10,298.09 $40,70325 $79,296.75 33.92% R 101-42400-32212 Mechanical Perm $6,114.50 $1,323.50 $6,000.00 $525.50 $1,151.00 $4,849.00 19.18% R 101-42400-32213 Encroachment P $1,100.00 $300.00 $1,000.00 $100.00 $600.00 $400.00 60.00% R 101-42400-32214 Right-of-Way Per $675.00 $375.00 $1,000.00 $0.00 $0.00 $1,000.00 0.00% R 101-42400-32230 Water/Sewer Con $695.00 $395.00 $1,000.00 $75.00 $75.00 $925.00 7.50% R 101-42400.36200 Miscellaneous Re $268.38 $28.38 $0.00 $200.00 $250.00 -$250.00 0.00% DEPT 42400 Buildin9 Inspection (GENERA $275,920.01 $110,277.75 $131,000.00 $11,289.09 $43,168.75 $87,831.25 DEPT 42403 Etectricallnspection R 101-42403-32225 Electricallnspecti $22,790.00 $2,345.00 $10,000.00 $1,087.00 $7,415.00 $2,585.00 74.15% DEPT 42700 Animal Control CITY OF CENTERVILLE 07/08/09 4:33 PM page 2 Monthly Budget Report by Dept tervi{{e Current Period: JUNE 2009 'EstaJj(islid 1857 2009 2008 2009 JUNE 2009 %01 Account Oeser 2008 Amt YTO Amt Budgat 2009 Amt YTD Amt Balance Budgat DEPT 41550 Assessing E 101-41550-300 Professional Srvs $15,166.00 $7,583.00 $17,000.00 $3,842.63 $7,685.26 $9,314.74 45.21% DEPT 41600 Law/Legal Services E 101-41600-304 Legal Fees $28,838.51 $5,306.90 $30,000.00 $0.00 $8,232.10 $21,767.90 27.44% E 101-41600-314 Prosecution $44,507.02 $11,098.54 $45,000.00 $0.00 $8,339.75 $36,660.25 18.53% OEPT 41600 Law/Legal Services $73,345.53 $16,405.44 $75,000.00 $0.00 $16,571.85 $58,428.15 22.10% DEPT 41910 Planning and Zoning E 101-41910-300 Professional Srvs $6,201.44 $5,346.94 $5,000.00 $126.25 $536.25 $4,463.75 10.73% E 101-41910-350 Ord., Pub. Hearings, etc. $240.98 $0.00 $500.00 $0.00 $471.60 $28.40 94.32% e 101-41910-430 Miscellaneous $199.37 $127.85 $500.00 $0.00 $53.91 $446.09 10.78% E 101-41910-433 Dues and Subscriptions $138.00 $138.00 $500.00 $0.00 $69.00 $431.00 13.80% E. 101-41910-438 Meeting Per Diem $1,480.00 $380.00 $500.00 $0.00 $320.00 $180.00 64.00% E 101-41910-441 Conf. & Schooling $125.00 $125.00 $500.00 $0.00 $0.00 $500.00 0.00% DEPT 41910 Planning and Zoning $8,384.79 $6,117.79 $7,500.00 $126.25 $1,450.76 $6,049.24 19.34% OEPT 41950 Engineering Services E 101-41950-258 Maps $266.25 $266.25 $500.00 $0.00 $266.25 $233.75 53.25% E 101-41950-300 Professional Srvs $0.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-41950-303 Engineering Fees $18,691.58 $10,075.18 $11,000.00 $414.14 $2,979.49 $8,020.51 27.09%. DEPT 41950 Engineering Services $18,957.83 $10,341.43 $12,000.00 $414.14 $3,245.74 $8,754.26 27.05% DEPT 42110 Police Administration E 101-42110-300 Professional Srvs $711,008.52 $355,691.76 $716,032.00 $55,559.97 $346,107.81 $369,924.19 48.34% E 101-42110-810 Refunds & Reimb. $0.00 $0.00 $35,000.00 $0.00 $0.00 $35,000.00 0.00% DEPT 42110 Police Administration $711,008.52 $355,691.76 $751,032.00 $55,559.97 $346,107.81 $404,924.19 46.08% OEPT 42280 City Hall/Fire Hall E 101-42280-100 Wages and Salaries (GENERAL) $2,173.92 $1,154.45 $2,500.00 $154.83 $984.84 $1,515.16 39.39% E 101-42280-122 FICA $162.54 $88.27 $200.00 $11.83 $75.26 $124.74 37.63% E 101-42280-151 Worker's Camp Insurance Prem $0.00 $0.00 $0.00 $0.00 $153.00 -$153.00 0.00% E 101-42280-210 Operatin9 Supplies $3.00 $3.00 $100.00 $0.00 $21.17 $78.83 21.17% E 101-42280-220 Repair/Maint Supply $217.99 $30,41 $200.00 $0.00 $93.02 $106.98 46.51% E 101-42280-300 Professional Srvs $426.54 $0.00 $2,000.00 $262.50 $646.80 $1,353.20 32.34% E 101-42280-380 Utility Services $13,225.84 $7,684.75 $24,000.00 $468.26 $5,822.85 $18,177.15 24.26% E 101-42280-381 Electric Utilities $0.00 $0.00 $4,000.00 $0.00 $0.00 $4,000.00 0.00% E 101-42280-430 Miscellaneous $42.54 $42.54 $2,500.00 $0.00 $0.00 $2,500.00 0.00% E 101-42280-454 Property Taxes $233.68 $233.68 $500.00 $0.00 $0.00 $500.00 0.00% E 101-42280-640 Turf Maintenance $342.51 $114.08 $1,000.00 $0.00 $114.35 $885.65 11.44% E 101-42280-650 Lawn Mowing $1,012.44 $141.72 $3,000.00 $0.00 $0.00 $3,000.00 0.00% CITY OF CENTERVILLE 07/08/094:33 PM Page 3 Monthly Budget Report by Dept ervi{{e CUrrent Period: JUNE 2009 2009 2008 2009 JUNE 2009 %of Account Deser 2008 Amt YTD Amt Budget 2009 Amt YTDAmt Balance Budget DEPT 42280 CRY Hall/Fire Hall $17,840.80 $9,472.90 $40,000.00 $897.42 $7,911.29 $32,088.71 19.78% OEPT 42285 Fire Protection E 101-42285--300 Professional Srvs $106,510.00 $53,255.00 $112,000.00 $0.00 $56,023.00 $55,977.00 50.02% E 101-42265-810 Refunds & Reimb. $119,664.00 $4,000.00 $125,000.00 $0.00 $0.00 $125,000.00 0.00% OEPT 42285 Fire Protection $226,174.00 $57,255.00 $237,000.00 $0.00 $56,023.00 $180,977.00 23.64% DEPT 42400 Buiiding Inspection (GENERAL) E 101-42400-100 Wages and Salaries (GENERAL) $91,862.42 $40,324.17 $113,955.00 $8,214.85 $50,328.32 $63,626.68 44.17% E 101-42400-121 PERA $5,571.38 $2,674.85 $7,490.00 $497.78 $3,135.92 $4,354.06 41.87% E 101-42400-122 FICA $7,363.81 $3,487.08 $9,630.00 $614.88 $3,849.77 $5,780.23 39.98% E 101-42400-130 Cafeteria Contribution $19,557.56 $10,914.83 $26,000.00 $878.74 $6,727.70 $19,272.30 25.88% E 101-42400-142 Unemployment Benefit Payments $0.00 $0.00 $0.00 $0.00 $358.15 -$358.15 0.00% E 101-42400.151 Worker's Camp Insurance Prem $1,652.29 $1,337.20 $2,000.00 $0.00 $3,900.00 -$1,900.00 195.00% E 101-42400-200 Office Supplies (GENERAL) $319.72 $224.20 $1,000.00 $29.10 $461.21 $538.79 46.12% E 101-42400-210 Operating Supplies $0.00 $0.00 $1,000.00 $0.00 $0.00 $1,000.00 0.00% E 101-42400-212 Motor Fuels $2,246.43 $1,194.03 $3,000.00 $93.09 $518.86 $2,481.14 17.30% E 101-42400-321 Telephone $541.08 $130.63 $500.00 $31.03 $260.58 $239.42 52.12% E 101-42400-331 Travel Expenses $1,007.50 $178.60 $500.00 $22.55 $170.90 $329.10 34.18% E 101-42400.356 Document Recording Fees $0.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-42400-360 Insurance (Liability Ins.) $218.06 $218.06 $500.00 $0.00 $188.00 $312.00 37.60% E 101-4240Q-404 Repairs/Maint Machinery/Equip $0.00 $0.00 $0.00 $0.00 $258.30 -$256.30 0.00% E 101-42400-433 Dues and SubSCriptions $100.00 $100.00 $500.00 $0.00 $250.00 $250.00 50.00% E 101-42400-435 Books and Pamphlets $85.93 $49.93 $500.00 $0.00 $0.00 $500.00 0.00% E 101-4240Q-439 Clothing Allowance $400.00 $0.00 $500.00 $0.00 $114.99 $385.01 23.00% E 101-42400-441 Conf. & Schooling $2,080.00 $1,020.00 $1,000.00 $70.00 $1,055.00 -$55.00 105.50% DEPT 42400 Building Inspection (GENERAl) $133,006.18 $61,853.58 $168,575.00 $10,452.02 $71,577.70 $96,997.30 42.46% OEPT 42403 Electrical Inspection E 101-42403-300 Professional Srvs $16,101.80 $0.00 $7,000.00 $0.00 $3,832.50 $3,157.40 54_lSD/it OEPT 42500 Civil Defense E 101-42500-300 Professional Srvs $910.80 $455.40 $1,000.00 $455.40 $455.40 $544.60 45.54% E 101-42500-430 Miscellaneous $198.00 $168.01 $500.00 $0.00 $0.00 $500.00 0.00% DEPT 42500 Civil Defense $1,108.80 $623.41 $1,500.00 $455.40 $455.40 $1,044.60 30.36% DEPT 42700 Animal Control E 101-42700-200 Office Supplies (GENERAL) $4.34 $4.34 $500.00 $0.00 $0.00 $500.00 0.00% E 101-42700-300 Professional Srvs $1,240.28 $959.44 $1,000.00 $181.00 $461.82 $538.18 46.18% OEPT 42700 Animal Control $1,244.62 $963.78 $1,500.00 $181.00 $461.82 $1,038.18 30.79% A CITY OF CENTERVILLE 07/081094:33 PM Page 4 Monthly Budget Report by Dept tervi[[e Current Period: JUNE 2009 TstabfMetf 1857 2009 2008 2009 JUNE 2009 %of Account Deser 2008 Amt YTO Amt Budget 2009 Amt YTO AmI Balance Budget DEPT 42800 Other Proteclion (GENERAL) E 101-42800-300 Professional 8rvs $2,100.00 $2,100.00 $600.00 $0.00 $0.00 $600.00 0.00% DEPT 43000 Public Works (GENERAL) E 101-43000-100 Wages and SalaMes (GENERAL) $90,703.48 $40,899.77 $76,438.00 $6,865.68 $45,832.38 $30,605.62 59.96% E 101-43000-121 PERA $5,357.85 $2,588.66 $6,420.00 $427.49 $2,926.88 $3,493.12 45.59% E 101-43000-122 FICA $6,959.33 $3,240.09 $8,560.00 $534.06 $3,530.94 $5,029.06 41.25% E 101-43000-130 Cafeteria Contribution $14,682.50 $7,469.99 $17,000,00 $1,063.78 $6,752.68 $10,247.32 39.72% E 101-43000-151 Worker's Camp Insurance Prem $2,790.19 $2,262.68 $2,500.00 $0.00 $3,900.00 -$1,400.00 156.00% E 101-43000-200 Office Supplias (GENERAL) $218.53 $72.63 $1,000.00 $0.00 $134.39 $865.61 13.44% E 101-43000-210 Operating Supplies $2,783.09 $1,553.02 $2,500.00 $214.68 $398.85 $2,101.15 15.95% E 101-43000-212 Motor Fuels $3,846.99 $637.93 $2,500.00 $428.75 $1,100.31 $1,399.69 44.01% E 101-43000-220 Rapair/Maint Supply $1,989.04 $1,335.35 $1,500.00 $0.00 $933.11 $566.89 62.21% E 101-43000-300 Professional 8rvs $2,655.80 $1,233.88 $1,500.00 $0.00 $807.10 $692.90 53.81% E 101-43000-303 Engineering Fees $4,008.96 $3,303.16 $3,500.00 $0.00 $0.00 $3,500.00 0.00% E 101-43000-310 Appraisal Fees $0.00 $0.00 $1,000.00 $0.00 $0.00 $1,000.00 0.00% E 101-43000-321 Talephona $3,317.08 $1,619.99 $3,500.00 $215.73 $1,247.41 $2,252.59 35.64% E 101-43000-331 Travel Expenses $99.20 $0.00 $500.00 $140.08 $345.87 $154.13 69.17% E 101-43000-340 Advertising & Printing $735.00 $735.00 $1,000.00 $45.00 $45.00 $955.00 4.50% E 101-43000-356 Document Recording Fees $0.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-43000-360 Insurance (Liability Ins.) $7,745.33 $7,745.33 $7,000.00 $0.00 $7,626.33 -$626.33 108.95% E 101-43000-380 Utility Services $15,058.65 $7,676.24 $17,500.00 $527.97 $8,318.82 $9,181.18 47.54% E 101-43000-400 Computer. Copier Main. Contrac $1,596.54 $1,557.51 $1,000.00 $0.00 $1,412.00 -$412.00 141.20% E 101-43000-401 Repairs/Maint Buildings $1,370.00 $0.00 $1,000.00 $0.00 $0.00 $1,000.00 0.00% E 101-4300~04 Repairs/Maint Machinery/Equip $7,992.35 $2,832.84 $3,000.00 $175.98 $2,525.41 $474.59 84.18% E 101-43000-430 Miscellaneous $549.19 $529.65 $1,000.00 $0.00 $477.36 $522.64 47.74% E 101-43000-433 Dues and Subscriptions $746.61 $347.07 $1,000.00 $66.56 $504.36 $495.64 50.44% E 101-43000-439 Clothing Allowance $1,534.49 $55.55 $2,000.00 $0.00 $0.00 $2,000.00 0.00% E 101-43000-441 Conf. & Schoolin9 $1,217.50 $590.00 $2,000.00 $0.00 $808.13 $1,191.87 40.41% E 101-43000-500 Capital Outlay (GENERAL) $527,215.56 $427,030.67 $0.00 $0.00 $105,712.33 -$105,712.33 0.00% E 101-43000-550 Motor Vehicles $0.00 $0.00 $6,000.00 $4,814.25 $4,846.75 $1,153.25 80.78% E 101-43000-580 Other Equipment $2,642.02 $0.00 $0.00 $0.00 $32.72 -$32.72 0.00% E 101-43000-650 Lawn Mowin9 $4,303.96 $427.20 $4,000.00 $0.00 $0.00 $4,000,00 0.00% DEPT 43000 Public Works (GENERAL) $712,119.24 $615,942.21 $175,418.00 $15,520.01 $200,219.13 -$24,801.13 114.14% DEPT 43140 Streets E 101-43140-210 Operating Supplies $899.99 $0.00 $0.00 $446.56 $461.40 -$461.40 0.00% E 101-43140-212 Motor Fuels $2,869.78 $2,135.08 $4,000.00 $127.00 $1,297.28 $2,702.72 32.43% E 101-43140-220 Repair/Maint Supply $3,640.94 $2,168.99 $3,000.00 $0.00 $858.65 $2,141.35 28.62% E 101-43140-226 Street & Road Signs $263.27 $0.00 $0.00 $0.00 $874.83 -$674.83 0.00% E 101-43140-300 Professional $rvs $183.75 $0.00 $20,000.00 $0.00 $0.00 $20,000.00 0.00% E 101-43140-303 Engineering Fees $3,415.54 $0.00 $12,000.00 $0.00 $0.00 $12,000.00 0.00% E 101-43140-360 Insurance (Liability Ins.) $524.46 $524.46 $1,500.00 $0.00 $1,412.00 $88.00 94.13% CITY OF CENTERVILLE 07/08/09 4:33 PM Page 5 Monthly Budget Report by Dept tervi{{e Current Period: JUNE 2009 'Estalifislid 1857 2009 2008 2009 JUNE 2009 %of Account Oeser 2008 AmI YTD AmI Budget 2009 AmI YTD AmI Balance Budget E 101-43140-386 Other Utilities $29,309,20 $13,219.75 $35,000,00 $2,492,52 $12,816.98 $22,183,02 36.62% E 101-43140-404 Repairs/Maint Machinery/Equip $0.00 $0.00 $0,00 $655.22 $655.22 -$655.22 0.00% DEPT 43140 Streets $41,106.93 $18,048.28 $75,500.00 $3,721.30 $18,176,36 $57,323,64 24.07% DEPT 43141 Special Proj, - CR 14 E 101-43141-100 Wages and Salaries (GENERAL) $0,00 $0,00 $0.00 $322.88 $2,993.58 -$2,993,58 0.00% E 101-43141-121 PERA $0.00 $0.00 $0.00 $21.80 $198.71 -$198,71 0.00% E 101-43141-122 FICA $0.00 $0.00 $0,00 $26.20 $231,30 -$231,30 0.00% E 101-43141-130 Cafeteria Contribution $0.00 $0,00 $0,00 $46.26 $92.52 -$92.52 0.00% DEPT 43141 Special Proj, - CR 14 $0.00 $0,00 $0,00 $417,14 $3,516.11 -$3,516.11 0.00% OEPT 43142 Special Proj. - Str - 09 E 101-43142-100 Wages and Salaries (GENERAL) $0.00 $0.00 $0.00 $9,706.71 $13,763.47 -$13,763.47 0.00% E 101-43142-121 PERA $0.00 $0.00 $0,00 $648.48 $922,28 -$922.28 0.00% E 101-43142-122 FICA $0.00 $0,00 $0,00 $732.85 $1,030.74 -$1,030.74 0.00% E 101-43142-130 Cafeteria Contribution $0.00 $0.00 $0,00 $138.76 $302.52 -$302.52 0.00% E 101-43142-210 Operating Supplies $0.00 $0.00 $0.00 $0.00 $1,311,96 -$1,311,96 0.00% E 101-43142-331 Travel Expenses $0.00 $0.00 $0,00 $460.68 $594,26 -$594,28 0.00% DEPT 43142 Special Pro). - Str - 09 $0,00 $0.00 $0.00 $11,687,48 $17,925,25 -$17,925.25 0.00% DEPT 43143 Special Pro). - TRAILS E 101-43143-100 Wages and Salaries (GENERAL) $0,00 $0.00 $0.00 $372.88 $695.76 -$695.76 0,00% E 101-43143-121 PERA $0.00 $0,00 $0.00 $21.80 $43,60 -$43,60 0.00% E 101-43143-122 FICA $0.00 $0.00 $0,00 $30,03 $56,23 -$56.23 0.00% E 101-43143-130 Cafeteria Contribution $0.00 $0,00 $0,00 $46,22 $92.44 -$92.44 0,00% DEPT 43143 Special Pro), - TRAILS $0,00 $0.00 $0,00 $470.93 $888,03 -$888,03 0.00% DEPT 45200 Parks/Rae. Committee E 101-45200-300 Professional Srvs $0,00 $0.00 $500.00 $0,00 $0,00 $500,00 0.00% E 101-45200-303 Engineering Fees $0,00 $0.00 $1,000.00 $0,00 $0.00 $1,000,00 0.00% E 101-45200-340 Advertising & Printing $242.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-45200-430 Miscellaneous $0.00 $0,00 $500,00 $0.00 $0.00 $500.00 0.00% E 101-45200-438 Meeting Per Diem $1,160,00 $260,00 $1,500.00 $0.00 $300.00 $1,200,00 20.00% DEPT 45200 Parks/Rec. Committee $1,402,00 $260,00 $4,000.00 $0.00 $300.00 $3,700,00 7.50% DEPT 45201 Parks/Ree Programs E 101-45201-100 Wages and Salaries (GENERAL) $3,040,17 $2,600,57 $5,000.00 $0.00 $2,023.88 $2,976.12 40.48% E 101-45201-122 FICA $198,94 $198,94 $500.00 $0.00 $154,85 $345,15 30.97% E 101-45201-132 Parks Programs $2,900,00 $1,000.00 $0.00 $0,00 $1,750,00 -$1,750,00 0.00% E 101-45201-151 Worker's Camp Insurance Prem $48.90 $39,34 $500.00 $0,00 $62.00 $438.00 12.40% E 101-45201-200 Office Supplies (GENERAL) $0.00 $0.00 $0,00 $0.00 $36.83 -$36.83 0.00% E 101-45201-303 Engineering Fees $0,00 $0,00 $2,000,00 $0.00 $0,00 $2,000,00 0.00% ~ - - -- --.- - - CITY OF CENTERVILLE 07/081094:33 PM Page 6 Monthly Budget Report by Dept teroi[[e Current Period: JUNE 2009 'EstagWie<f 1857 2009 2008 2009 JUNE 2009 %of Account Oeser 2008 Amt Y1D Amt Budget 2009 Amt YTDAmt Balance Budget E 101-45201-331 Travel Expenses $0.00 $0.00 $0.00 $0.00 $14.14 -$14.14 0.00% E 101-45201-340 Advertising & Printing $0.00 $0.00 $0.00 $175.00 $201.63 -$201.63 0.00% E 101-45201-430 Miscellaneous $0.00 $0.00 $500.00 $0.00 $67.50 $432.50 13.50% DEPT 45201 Parks/Rec Programs $6,188.01 $3,836.85 $8,500.00 $175.00 $4,310.83 $4,189.17 50.72% DEPT 45202 Parks Maintenance E 101-45202-100 Wages and Salaries (GENERAL) $21,205.03 $9,739.07 $20.825.00 $2,229.88 $10,896.05 $9,928.95 52.32% E 101-45202-121 PERA $925.28 $448.44 $1,070.00 $80.15 $546.79 $523.21 51.10% E 101-45202-122 FICA $1,609.93 $760.76 $2,140.00 $173.80 $843.12 $1,298.88 39.40% E 101-45202.130 Cafeteria Contribution $2,792.50 $1,350.00 $3,000.00 $231.26 $1,387.56 $1,612.44 46.25% E 101-45202-151 Worker's Camp Insurance Pram $502.33 $408.43 $1.000.00 $0.00 $529.00 $471.00 52.90% E 101-45202-210 Operating Supplies $579.27 $185.24 $2,000.00 $95.34 $182.55 $1,817.45 9.13% E 101-45202-212 Motor Fuels $1,913.28 $797.31 $2,500.00 $20.93 $75.85 $2,424.15 3.03% E 101-45202-220 Repair/Main! Supply $1,450.06 $320.05 $500.00 $0.00 $84.11 $415.89 16.82% E 101-45202-221 Equipment Parts $92.24 $92.24 $1,000.00 $0.00 $22.50 $977.50 2.25% E 101-45202-223 Building Repair Supplies $23.05 $0.00 $0.00 $23.24 $23.24 -$23.24 0.00% E 101-45202-225 landscaping Materials $1,148.42 $549.25 $1.000.00 $363.29 $404.73 $595.27 40.47% E 101-45202-300 Professional 8M $6,790.13 $30,374.40 $2,500.00 $45.00 $23,307.98 -$20,807.96 932.32% E 101-45202-321 Telephone $666.84 $332.60 $1,000.00 $55.70 $333.57 $666.43 33.36% E 101-45202-331 Travel Expenses $33.33 $33.33 $0.00 $0.00 $30.60 -$30.80 0.00% E 101-45202-360 Insurance (Liability Ins.) $2,066.53 $2,066.53 $2,500.00 $0.00 $6,566.00 -$4,066.00 262,64% E 101-45202-380 Utility Services $2,511.63 $1.664.54 $3,000.00 -$76.20 $1,210.81 $1,789.19 40,36% E 101-45202-404 Repairs/Maint Machinery/Equip $1,325.71 $738.05 $1,000.00 $0.00 $0.00 $1,000.00 0,00% E 101-45202-410 Rentals (GENERAL) $0.00 $0.00 $500.00 $642.40 $642.40 -$142.40 128.48% E 101-45202-430 Miscellaneous $612.46 $445.21 $500.00 $0.00 $33.72 $466.28 6.74% E 101-45202-441 ConI. & Schooling $1,217.50 $590.00 $1,000.00 $0.00 $332.50 $667.50 33.25% E 101-45202-454 Property Taxes $298.73 $296.73 $500.00 $0.00 $298.73 $201.27 59.75% E 101-45202-500 Capital Outlay (GENERAL) $0.00 $20,266.29 $25,000.00 $616.79 $616.79 $24,383.21 2.47% E 101-45202-640 Turf Maintenance $4,074.85 $1,763.14 $4.500.00 $0.00 $1,787.28 $2,732.72 39.27%, E 101-45202-650 Lawn Mowing $18,623.92 $2.196.04 $18,500.00 $0.00 $0.00 $18,500.00 0.00% OEPT 45202 Parks Maintenance $70,463.02 $75,419.55 $95,535.00 $4,501.56 $50,136.08 $45,398.92 52.48% DEPT 45350 RECYCLING E 101-45350-100 Wages and Salaries (GENERAL) $2,347.80 $783.33 $3,500.00 $244.08 $1,598.97 $1,901.03 45.68% E 101-4535~121 PERA $187.11 $91.70 $200.00 $16.46 $107.88 $92.12 53.94% E 101-45350-122 FICA $164.34 $55.69 $200.00 $17.54 $119.05 $80.95 59.53% E 101-45350-130 Cafeteria Contribution $558.51 $270.00 $600.00 $46.24 $277.46 $322.54 46.24% E 101-4535~231 Recycling Supplies $0.00 $0.00 $100.00 $0.00 $106.07 -$6.07 106.07% E 101-45350-300 Professional 8rvs $10,001.75 $1,588.00 $1,500.00 $0.00 $979.00 $521.00 65.27% E 101-45350-331 Travel Expenses $0.00 $0.00 $0.00 $0.00 $11.00 -$11.00 0.00% E 101-45350-340 Advertising & Printing $104.50 $104.50 $400.00 $0.00 $85.50 $314.50 21.38% DEPT 45350 RECYCLING $13,364.01 $2,893.42 $6,500.00 $324.32 $3,284.93 $3,215.07 50.54% CITY OF CENTERVILLE 07/081094:33 PM Page 7 Monthly Budget Report by Dept tervi{{e Current Period: JUNE 2009 'EstoiJ[isfw{ 1857 2009 2008 2009 JUNE 2009 %of Account Deser 2008 AmI YTD AmI Budget 2009 AmI YTD AmI Balance Budget DEPT 46203 Downtown Redevelopment E 101-46203-303 Engineering Fees $0.00 $0.00 $0.00 $63.00 $63.00 -$63.00 0.00% E 101-46203-310 Appraisal Fees $0.00 $0.00 $0.00 $0.00 $5,200.00 -$5,200.00 0.00% DEPT 46203 Downtown Redevelopment $0.00 $0.00 $0.00 $63.00 $5,263.00 -$5,263.00 0.00% OEPT 46211 TE Trail Grant E 101-46211-303 Engineering Fees $0.00 $495.33 $0.00 $0.00 $154,611.78 -$154,611.78 0.00% DEPT 46500 Economic Develop'mt (GENERAL) E 101-46500-300 Professional 8rvs $211.84 $211.84 $500.00 $0.00 $0.00 $500.00 0.00% E 101-46500-322 Postage $0.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-46500-331 Travel Expenses $0.00 $0.00 $0.00 $0.00 $11.00 -$11.00 0.00% E 101-46500-340 Advertising & Printing $2,376.00 $2,000.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-46500-410 Rentals (GENERAL) $0.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-4650Q-430 Miscellaneous $442.67 $0.00 $0.00 $0.00 $395.06 -$395.06 0.00% E 101-46500-600 Debt Srv Principal (GENERAL) $0.00 $6,335.21 $12,000.00 $6,335.21 $12,670.42 -$670.42 105.59% OEPT 46500 Economic Develop'mt (GENERAL) $3,030.51 $8,547.05 $14,000.00 $6,335.21 $13,076.48 $923.52 93.40% OEPT 49200 Unallocated E 101-49200-500 Cepital Outlay (GENERAL) $0.00 $0.00 $25,000.00 $0.00 $0.00 $25,000.00 0.00% E 101-49200-720 Operating Transfers $0.00 $0.00 $382,900.00 $0.00 $0.00 $382,900.00 0.00% DEPT 49200 Unallocated $0.00 $0.00 $407,900.00 $0.00 $0.00 $407,900.00 0.00% DEPT 50000 City F&stival E 101-50000-170 Fireworks Display Insurance $250.00 $0.00 $500.00 $250.00 $250.00 $250.00 50.00% E 101-50000-322 Postage $0.00 $0.00 $0.00 $0.00 $58.05 -$58.05 0.00% E 101-50000-490 Donations to Civic Org's $19,219.00 $19,044.00 $23,500.00 $0.00 $15,203.46 $8,296.54 64.70% DEPT 50000 City FE:stival $19,469.00 $19,04400 $24,000.00 $250.00 $15,511.51 $8,488.49 64.63% FUND 101 GENERAL FUND $2,509,383.82 $1,386,273.39 $2,604,320.00 $139,773.54 $1,182,053.18 $1,422,266.82 45.39% - - CITY OF CENTERVILLE 07/08/094:33 PM Page 1 Monthly Budget Report by Dept tervi[[e Current Period: JUNE 2009 'EstaEfislied 1857 2009 2008 2009 JUNE 2009 %of Account Oeser 2008 AmI YTD AmI Budget 2009 AmI YTD AmI Balance Budgel FUND 101 GENERAL FUND DEPT 41110 Council E 101-41110-100 Wages and Salanes (GENERAL) $27,900.00 $11,625.00 $30,000.00 $2,325.00 $11,625.00 $18,375.00 38.75% E 101-41110-122 FICA $2,134.56 $889.40 $2,500.00 $177.88 $889.40 $1,610.60 35.58% E 101-41110-331 Travel Expenses $312.93 $160.42 $500.00 $0.00 $0.00 $500.00 0.00% E 101-41110-430 Miscellaneous $219.38 $219.38 $500.00 $0.00 $53.38 $446.62 10.68% E 101-41110-433 Dues and Subscriptions $20.00 $0.00 $500.00 $0.00 $0.00 $500.00 0.00% E 101-41110-441 Conf. & Schooling $580.88 $580.88 $1,000.00 $0.00 $505.00 $495.00 50.50% OEPT 41110 Council $31,167.75 $13,475.08 $35,000.00 $2,502.88 $13,072.78 $21,927.22 37.35% DEPT 41400 Administration E 101-41400-100 Wages and Salanes (GENERAL) $223,067.35 $105,359.21 $250,380.00 $13,609.82 $91,032.57 $159,347.43 36.36% E 101-41400-121 PERA $14,055.81 $6,859.38 $17,120.00 $905.68 $6,119.50 $11,000.50 35.74% E 101-41400-122 FICA $16,481.61 $8,043.32 $19,260.00 $993.96 $6,686.47 $12,573.53 34.72% E 101-41400-130 Cafeteria Contribution $35,538.20 $17,280.00 $36,000.00 $2,266.26 $14,291.32 $21,708.68 39.70% E 101-41400-151 Worker's Camp Insurance Prem $9,288.61 $7,601.71 $9,000.00 $0.00 $2,594.00 $6,408.00 28.82% E 101-41400-200 Office Supplies (GENERAL) $4,184.43 $2,253.92 $8,000.00 $626.15 $1,595.57 $6,404.43 19.94% E 101-41400-220 Repair/Maint SUpply $211.23 $0.00 $1,000.00 $0.00 $288.04 $711.96 28.80% E 101-41400-300 Professional 8rvs $8,282.91 $4,474.08 $10,000.00 $408.10 $7,655.29 $2,344.71 76.55% E 101-41400-304 Legal Fees $0.00 $0.00 $1,000.00 $0.00 $0.00 $1,000.00 0.00% E 101-41400-321 Telephone $4,257.94 $2,196.98 $5,000.00 $362.06 $2,190.69 $2,809.31 43.81% E 101-41400-322 Postage $1,972.92 $809.12 $3,000.00 $209.95 $249.75 $2,750.25 8.33% E 101-41400-331 Travel Expenses $2,136.69 $825.37 $3,000.00 $31.90 $179.37 $2,820.63 5.98% E 101-41400-340 Advertising & Printing $194.45 $191.50 $1,000.00 $0.00 $453.15 $546.85 45.32% E 101-41400-350 Ord., Pub. Hearings, etc. $153.00 $91.80 $1,000.00 $0.00 $627.90 $372.10 62.79% E 101-41400-356 Document Recording Fees $506.00 $138.00 $1,000.00 $46.00 $296.00 $704.00 29.60% E 101-41400-360 Insurance (Liability Ins.) $14,382.64 $13,882.84 $14,000.00 $0.00 $12,063.00 $1,937.00 86.16% E 101-41400-400 Computer, Copier Main. Contrac $13,240.15 $10,785.37 $25,000.00 $2,188.00 $7,301.91 $17,698.09 29.21% E 101-41400-425 Bank Service Charges $1,017.47 $400.99 $1,000.00 $0.00 $415.09 $584.91 41.51% E 101-41400-428 ACH File Charge $240.00 $120.00 $250.00 $0.00 $263.96 -$13.96 105.58% E 101-41400-430 Miscellaneous $344.13 $81.71 $1,250.00 $158.00 $304.98 $945.02 24.40% E 101-41400-433 Dues and Subscriptions $5,358.75 $1,000.00 $5,500.00 $70.00 $958.00 $4,542.00 17.42% E 101-41400-435 Books and Pamphlets $0.00 $0.00 $1,000.00 $0.00 $28.00 $972.00 2.80% E 101-41400-439 Clothing Allowance $447.04 $386.49 $1,000.00 $0.00 $0.00 $1,000.00 0.00% E 101-41400-441 Cont. & Schooling $4,737.05 $3,330.08 $5,000.00 $0.00 $843.12 $4,156.88 16.86% E 101-41400-500 Cap"al Outlay (GENERAL) $11,653.10 $11,104.76 $2,000.00 $0.00 $0.00 $2,000.00 0.00% E 101-41400-810 Retunds & Reimb. $2,885.00 $2,885.00 $2,500.00 $0.00 $0.00 $2,500.00 0.00% DEPT 41400 Administration $374,634.48 $199,901.43 $424,260.00 $21,875.88 $156,437.68 $267,822.32 36.87% DEPT 41500 Financial Administration E 101-41500-301 Auditing and Acct'g Services $12,000.00 $0.00 $15,000.00 $0.00 $10,000.00 $5,000.00 66.67% CITY OF CENTERVILLE 07/08/094:33 PM Page 2 Monthly Revenue Report tervi{{e Current Period: JUNE 2009 'EstahtL<fid 1857 2008 2009 JUNE 2009 %01 Account Oeser 2008 Amt YTD Amt Budget 2009 Amt YTD Amt Balance Budget R 101-42700.32200 Animal Licenses $1,310.00 $1,030.00 $2,000.00 $30.00 $277.50 $1,722.50 13.88% DEPT 43000 Public Works (GENERAL) R 101-43000-32260 Antenna Leases $15,011.22 $15,011.22 $15,000.00 $0.00 $15,461.56 -$461.56 103.08% DEPT 45201 Parks/Ree Programs R 101-45201-34780 Recreation Fees $0.00 $0.00 $0.00 $230.00 $290.00 -$290.00 0.00% DEPT 45202 Parks Maintenance R 101-45202-36270 Refunds/Reimbur $7.695.66 $0.00 $0.00 $50.98 $50.98 -$50.98 0.00% DEPT 45350 RECYCLING R 101-45350-33630 County SCORE F $16,577.20 $0.00 $0.00 $0.00 $11,305.17 -$11,305.17 0.00% DEPT 46500 Economic Develop'mt (GENERAL) R 101-46500-36230 Contributions and $150.00 $0.00 $0.00 $0.00 $400.00 -$400.00 0.00% R 10146500-36270 Refunds/Reimbur $2.50 $0.00 $0.00 $0.00 $28.76 -$28.76 0.00% DEPT 46500 Economic Develop'mt (GENE $152.50 $0.00 $0.00 $0.00 $428.76 -$428.76 DEPT 49200 Unallocated R 101-49200-31000 General Property $1,908,634.69 $0.00 $2,042,320.00 $0.00 $15,904.38 $2,026,415.62 0.78% R 101-49200-33400 State Grants and $1,333.00 $0.00 $6,500.00 $0.00 $0.00 $6,500.00 0.00% R 10149200-36100 Special Assessm $1,915.13 $0.00 $20,000.00 $0.00 $0.00 $20,000.00 0.00% R 101-49200-36210 Interest Earnings $47,037.03 $23,767.79 $40,000.00 $0.00 $11,734.06 $28,265.92 29.34% R 101-49200-39203 Transfer from Oth $35,977.02 $36,548.03 $99,500.00 $0.00 $0.00 $99,500.00 0.00% DEPT 49200 Unallocaled $1,994,896.87 $60,315.82 $2,208,320.00 $0.00 $27,638.46 $2,180.681.54 FUND 101 GENERAL FUND $2,541,954.90 $213.122.34 $2,600,320.00 $16,232.03 $129,180.10 $2,471,139.90