Loading...
HomeMy WebLinkAboutJune 23 Fin 3South Bend Venues, Parks and Arts Parks Maintenance: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347015 - Lease of Stadium 30,000.00 45,000.00 75,000.00 30,000.00 60.00% 347021 - Tree Maintenance 3,366.21 19,508.09 - (19,508.09) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 33,366.21 64,508.09 77,000.00 12,491.91 83.78% Total Charges for Services 33,366.21 64,508.09 77,000.00 12,491.91 83.78% Miscellaneous Revenue 360000 - Miscellaneous - 2,000.00 - (2,000.00) 0.00% 360001 - Sale of Scrap Metal 241.08 964.73 - (964.73) 0.00% 360011 - Settlement Fees 30,950.00 50,450.00 - (50,450.00) 0.00% Total Miscellaneous Revenue 31,191.08 53,414.73 - (53,414.73) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements - 45,071.48 45,000.00 (71.48) 100.16% 396000 - Refunds - 219.12 - (219.12) 0.00% Total Refunds & Reimbursements - 45,290.60 45,000.00 (290.60) 100.65% Total Revenue 64,557.29 163,213.42 122,000.00 (41,213.42) 133.78% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 70,106.91 439,175.78 - 439,175.78 913,867.00 474,691.22 48.06% 410002 - Teamster Wages 111,527.80 689,917.01 - 689,917.01 1,349,620.00 659,702.99 51.12% 410003 - Permanent Part Time 40,207.95 196,595.95 - 196,595.95 260,000.00 63,404.05 75.61% 410004 - Extra & Overtime 10,434.15 44,343.67 - 44,343.67 56,300.00 11,956.33 78.76% 410005 - Seasonal & Interns 44,700.99 135,443.42 - 135,443.42 300,000.00 164,556.58 45.15% 410007 - Longevity Pay 350.00 4,500.00 - 4,500.00 7,450.00 2,950.00 60.40% 410017 - Stand By Pay - 1,092.78 - 1,092.78 - (1,092.78) 0.00% Total Salaries & Wages 277,327.80 1,511,068.61 - 1,511,068.61 2,887,237.00 1,376,168.39 52.34% Employee Benefits 411001 - FICA Regular 19,615.95 111,218.03 - 111,218.03 222,609.00 111,390.97 49.96% 411004 - PERF Regular 19,926.98 127,024.32 - 127,024.32 263,192.00 136,167.68 48.26% 411005 - PERF Union 964.26 6,767.28 - 6,767.28 21,452.00 14,684.72 31.55% 411007 - Unemployment Comp 19.86 126.73 - 126.73 2,793.00 2,666.27 4.54% 411008 - Health Insurance 44,026.66 283,074.66 - 283,074.66 616,458.00 333,383.34 45.92% 411009 - Life Insurance 410.00 2,610.00 - 2,610.00 5,280.00 2,670.00 49.43% 411010 - Med/Surgical/Dental 493.24 3,234.83 - 3,234.83 - (3,234.83) 0.00% 411014 - Parental Leave 650.48 4,072.63 - 4,072.63 8,145.00 4,072.37 50.00% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 - (1,200.00) 0.00% 411200 - Clothing Allowance - 155.14 - 155.14 156.00 0.86 99.45% 411201 - Tool Allowance 420.81 2,000.33 - 2,000.33 3,844.00 1,843.67 52.04% 411203 - Job Readiness Allow. (9,827.84) (850.00) - (850.00) 12,750.00 13,600.00 (6.67%) 411206 - Cell Phone Allowance 440.00 2,640.00 - 2,640.00 5,940.00 3,300.00 44.44% Total Employee Benefits 77,140.40 543,273.95 - 543,273.95 1,162,619.00 619,345.05 46.73% Total Personnel Expenses 354,468.20 2,054,342.56 - 2,054,342.56 4,049,856.00 1,995,513.44 50.73% Supplies Expenses Office Supplies June 30, 2023 421000 - General Office Supplies - 636.00 - 636.00 2,000.00 1,364.00 31.80% Total Office Supplies - 636.00 - 636.00 2,000.00 1,364.00 31.80% Operating Supplies 422000 - Other Operating Supplies 16,357.94 101,940.16 6,093.66 108,033.82 164,387.69 56,353.87 65.72% 422001 - C.S. Gasoline 17,621.41 108,130.56 - 108,130.56 220,000.00 111,869.44 49.15% 422003 - Gasoline - 13.11 - 13.11 667.00 653.89 1.97% 422005 - Uniforms - 2,135.83 - 2,135.83 2,136.25 0.42 99.98% 422006 - Computer Supplies & Equipment 599.99 766.42 - 766.42 767.00 0.58 99.92% 422007 - Cleaning Supplies 113.58 590.36 - 590.36 600.00 9.64 98.39% 422008 - Medical/Safety Supplies 660.74 9,062.34 - 9,062.34 13,104.00 4,041.66 69.16% 422010 - Plants Chemicals Seed & Fertilizer 3,246.31 64,842.26 10,019.67 74,861.93 120,455.00 45,593.07 62.15% Total Operating Supplies 38,599.97 287,481.04 16,113.33 303,594.37 522,116.94 218,522.57 58.15% Repair & Maintenance Supplies 423000 - Other R&M Supplies 19,858.16 85,034.73 37,822.17 122,856.90 255,878.88 133,021.98 48.01% 423001 - Building Materials 19,100.50 56,530.67 15,065.00 71,595.67 145,169.45 73,573.78 49.32% 423006 - Small Tools & Equipment 8,296.15 28,175.47 315.62 28,491.09 26,852.00 (1,639.09) 106.10% 423009 - Repair Parts 8,556.32 47,455.07 16,910.37 64,365.44 77,164.24 12,798.80 83.41% Total Repair & Maintenance Supplies 55,811.13 217,195.94 70,113.16 287,309.10 505,064.57 217,755.47 56.89% Total Supplies Expenses 94,411.10 505,312.98 86,226.49 591,539.47 1,029,181.51 437,642.04 57.48% Services & Charges Expenses Professional Services 431000 - Other Professional Services 15,893.70 108,028.95 9,480.38 117,509.33 115,933.96 (1,575.37) 101.36% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs - 55.75 - 55.75 100.00 44.25 55.75% 431019 - Security Services 11,394.50 18,874.50 25,022.00 43,896.50 201,669.00 157,772.50 21.77% Total Professional Services 27,288.20 134,709.20 34,502.38 169,211.58 325,977.96 156,766.38 51.91% Communication & Transportation 432002 - Mailing 3.70 3.70 - 3.70 - (3.70) 0.00% 432003 - Travel - 363.93 1,059.98 1,423.91 6,617.50 5,193.59 21.52% 432004 - Telecommunications - 758.91 2,235.89 2,994.80 11,687.41 8,692.61 25.62% Total Communication & Transportation 3.70 1,126.54 3,295.87 4,422.41 18,304.91 13,882.50 24.16% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice - 1,038.00 677.81 1,715.81 3,277.72 1,561.91 52.35% Total Printing & Advertising - 1,038.00 677.81 1,715.81 5,377.72 3,661.91 31.91% Utilties 435001 - Electric 33,283.01 219,819.61 - 219,819.61 470,043.00 250,223.39 46.77% 435002 - Natural Gas 4,454.27 113,114.47 - 113,114.47 282,938.00 169,823.53 39.98% 435004 - Water 40,841.71 96,397.72 - 96,397.72 300,000.00 203,602.28 32.13% Total Utilities 78,578.99 429,331.80 - 429,331.80 1,052,981.00 623,649.20 40.77% Repairs & Maintenance 436000 - Other R&M 15,810.00 33,716.50 26,505.00 60,221.50 299,942.99 239,721.49 20.08% 436001 - Building R&M 49,340.03 284,561.68 61,547.82 346,109.50 354,902.60 8,793.10 97.52% 436003 - Auto Equip R&M 16,840.41 139,516.24 - 139,516.24 351,750.00 212,233.76 39.66% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 5,573.87 11,813.09 - 11,813.09 7,200.00 (4,613.09) 164.07% 436011 - Exterminating 1,488.00 2,042.00 11,345.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 89,052.31 478,565.93 99,397.82 577,963.75 1,037,129.69 459,165.94 55.73% Debt Service 438100 - Principal - 122,623.28 - 122,623.28 246,687.00 124,063.72 49.71% 438200 - Interest - 13,587.83 - 13,587.83 25,735.00 12,147.17 52.80% Total Debt Service - 136,211.11 - 136,211.11 272,422.00 136,210.89 50.00% Other Charges & Services 439000 - Misc Charges & Svcs 3,320.23 32,329.86 48,504.67 80,834.53 75,627.23 (5,207.30) 106.89% 439001 - Other Contractual Services 30,072.36 39,368.72 73,731.07 113,099.79 145,900.00 32,800.21 77.52% 439002 - Licenses & Permits - 1,200.00 - 1,200.00 1,208.00 8.00 99.34% 439003 - Subscriptions 99.99 1,022.08 - 1,022.08 1,281.00 258.92 79.79% 439004 - Dues & Memberships 240.00 1,575.00 - 1,575.00 2,494.00 919.00 63.15% 439006 - Education & Training 1,359.27 10,683.89 3,720.72 14,404.61 15,029.00 624.39 95.85% 439009 - Trash Removal 2,737.50 20,773.93 3,384.62 24,158.55 32,493.15 8,334.60 74.35% 439012 - Uniform Services 3,359.09 11,800.27 - 11,800.27 15,941.00 4,140.73 74.02% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 41,188.44 133,753.75 129,341.08 263,094.83 304,973.38 41,878.55 86.27% Total Services & Charges Expenses 236,111.64 1,314,736.33 267,214.96 1,581,951.29 3,017,166.66 1,435,215.37 52.43% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 28,116.00 28,116.00 0.00% 445003 - Park Equipment - 8,045.00 162,397.40 170,442.40 301,429.00 130,986.60 56.54% 445100 - Lease Purchase/Motor Equip 41,800.00 272,534.00 14,850.00 287,384.00 1,047,863.30 760,479.30 27.43% Total Machinery & Equipment 41,800.00 280,579.00 177,247.40 457,826.40 1,377,408.30 919,581.90 33.24% Total Capital Expenses 41,800.00 280,579.00 177,247.40 457,826.40 1,377,408.30 919,581.90 33.24% Other Uses 452002 - Allocations-Admin Cost - 122,533.68 - 122,533.68 367,601.00 245,067.32 33.33% 452003 - Allocations-IT - 55,263.00 - 55,263.00 165,789.00 110,526.00 33.33% 452004 - Allocations-Liability Insurance - 59,328.32 - 59,328.32 177,985.00 118,656.68 33.33% 452009 - Allocations-Facilities Mgmt - 8,547.00 - 8,547.00 25,641.00 17,094.00 33.33% Total Other Uses - 245,672.00 - 245,672.00 737,016.00 491,344.00 33.33% Total Expenses 726,790.94 4,400,642.87 530,688.85 4,931,331.72 10,210,628.47 5,279,296.75 48.30%