Loading...
HomeMy WebLinkAboutOct 20 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 83% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Taxes Property Taxes 311000 - Civil City Property Taxes - 5,250,387.20 9,340,797.00 4,090,409.80 43.79% Total Property Taxes - 5,250,387.20 9,340,797.00 4,090,409.80 43.79% Total Taxes - 5,250,387.20 9,340,797.00 4,090,409.80 43.79% Intergovernmental Revenue Grants 331070 - Fed Grants-Culture & Recreation - - 125,000.00 125,000.00 100.00% 331080 - Fed Grants-Conserv of Natural Resources - - 200,000.00 200,000.00 100.00% Total Grants - - 325,000.00 325,000.00 100.00% Intergovernmental Revenue State Shared Revenue 335002 - Vehicle/Aircraft Excise - 352,861.04 700,000.00 347,138.96 49.59% 335007 - Commercial Vehicle Excise - 83,176.04 145,000.00 61,823.96 42.64% Total State Shared Revenue - 436,037.08 845,000.00 408,962.92 48.40% Other Intergovernmental Revenue 337001 - Local Govt Grants - 648,098.00 648,098.00 - 0.00% Total Other Intergovernmental - 648,098.00 648,098.00 - 0.00% Total Intergovernmental Revenue - 1,084,135.08 1,818,098.00 733,962.92 40.37% Charges for Services Culture & Recreation 347001 - Swimming Pool - 2,816.87 46,000.00 43,183.13 93.88% 347002 - Picnic Site Rental 75.00 2,995.60 3,300.00 304.40 9.22% 347003 - Golf Season Pass (63.50) 162,676.20 165,000.00 2,323.80 1.41% 347004 - Golf Green Fees 53,372.01 763,068.51 550,000.00 (213,068.51) (38.74%) 347005 - Golf Cart Rentals 32,362.96 341,363.31 330,000.00 (11,363.31) (3.44%) 347006 - Golf Pro Shop Retail 4,489.66 50,568.19 60,000.00 9,431.81 15.72% 347007 - Golf Driving Range 1,802.00 31,101.18 30,530.00 (571.18) (1.87%) 347008 - Golf Gift Certificate (536.11) 557.27 260.00 (297.27) (114.33%) 347011 - Special Events 16,272.49 379,854.53 941,465.00 561,610.47 59.65% 347012 - Food Sales 5,689.52 58,992.42 102,000.00 43,007.58 42.16% 347013 - Nonalcoholic Beverage 2,463.86 37,643.11 68,000.00 30,356.89 44.64% 347014 - Alcoholic Beverage Sales 9,549.50 104,387.88 90,000.00 (14,387.88) (15.99%) 347015 - Lease of Stadium - 45,000.00 75,000.00 30,000.00 40.00% 347016 - East Race Waterway - 53,028.70 50,000.00 (3,028.70) (6.06%) 347017 - Ice Skating 14,478.40 163,316.42 123,500.00 (39,816.42) (32.24%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347019 - Site Mowing 13,900.80 108,979.20 95,000.00 (13,979.20) (14.71%) 347021 - Tree Maintenance 98,781.58 151,297.64 160,000.00 8,702.36 5.44% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% 347024 - Sponsorship Income - 4,000.00 - (4,000.00) 0.00% 347026 - Room Rental 2,620.04 2,920.04 - (2,920.04) 0.00% 347040 - Pavilion Rental 60.00 9,235.00 17,500.00 8,265.00 47.23% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short (3.12) 784.30 - (784.30) 0.00% Total Culture & Recreation 255,315.09 2,479,186.37 3,037,084.00 557,897.63 18.37% Total Charges for Services 255,315.09 2,479,186.37 3,037,084.00 557,897.63 18.37% Miscellaneous Revenue 360000 - Miscellaneous 23,026.20 15,365.41 26,270.00 10,904.59 41.51% 361000 - Interest Earnings 744.15 6,794.17 37,250.00 30,455.83 81.76% 362000 - Rental of Property 53,537.99 72,255.24 60,000.00 (12,255.24) (20.43%) 367000 - Donations from Private Sources 4,000.00 1,024,750.00 1,290,000.00 265,250.00 20.56% Total Miscellaneous Revenue 81,308.34 1,119,164.82 1,413,520.00 294,355.18 20.82% Refunds & Reimbursements 380000 - Misc Reimbursements (19,067.33) 9,182.37 45,899.00 36,716.63 79.99% October 31, 2020 380001 - Insurance Claims - 708.00 708.00 - 0.00% 380007 - Energy Rebates - 3,040.05 3,040.00 (0.05) (0.00%) 381000 - Misc Reimbursements - 1,055.99 1,056.00 0.01 0.00% 396000 - Refunds - 144.00 - (144.00) 0.00% Total Refunds & Reimbursements (19,067.33) 14,130.41 50,703.00 36,572.59 72.13% Other Sources 391000 - Interfund Transfers In 66,667.00 666,666.00 800,000.00 133,334.00 16.67% 392000 - Gain/Loss on Sale of Asset - 2,162.00 2,162.00 - 0.00% 392005 - Sale of Non-Capital Assets - 11,270.00 11,270.00 - 0.00% Total Other Sources 66,667.00 680,098.00 813,432.00 133,334.00 16.39% Total Revenue 384,223.10 10,627,101.88 16,473,634.00 5,846,532.12 35.49% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 335,101.47 2,580,599.83 - 2,580,599.83 3,067,175.00 486,575.17 15.86% 410002 - Teamster Wages 167,805.42 1,241,253.91 - 1,241,253.91 1,423,153.00 181,899.09 12.78% 410003 - Permanent Part Time 114,461.00 800,123.13 - 800,123.13 872,676.00 72,552.87 8.31% 410004 - Extra & Overtime 6,755.85 62,060.52 - 62,060.52 79,490.00 17,429.48 21.93% 410005 - Seasonal & Interns 62,814.15 481,297.41 - 481,297.41 682,140.00 200,842.59 29.44% 410007 - Longevity Pay 950.00 7,100.00 - 7,100.00 8,050.00 950.00 11.80% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 687,887.89 5,172,434.80 - 5,172,434.80 6,133,884.00 961,449.20 15.67% Employee Benefits 411001 - FICA Regular 51,525.03 384,161.23 - 384,161.23 464,022.00 79,860.77 17.21% 411004 - PERF Regular 55,974.64 426,907.33 - 426,907.33 528,858.00 101,950.67 19.28% 411005 - PERF Union 2,106.79 15,842.59 - 15,842.59 22,652.00 6,809.41 30.06% 411007 - Unemployment Comp 51.01 388.88 - 388.88 531.00 142.12 26.76% 411008 - Health Insurance 90,948.56 916,476.75 - 916,476.75 1,117,598.00 201,121.25 18.00% 411009 - Life Insurance 910.04 9,290.40 - 9,290.40 11,320.00 2,029.60 17.93% 411014 - Parental Leave 1,785.56 13,593.70 - 13,593.70 16,128.00 2,534.30 15.71% 411200 - Clothing Allowance - 123.04 - 123.04 200.00 76.96 38.48% 411201 - Tool Allowance 991.70 2,285.72 515.29 2,801.01 5,028.00 2,226.99 44.29% 411203 - Job Readiness Allow. - 14,768.75 - 14,768.75 15,300.00 531.25 3.47% 411204 - Auto Allowance 266.66 2,666.60 - 2,666.60 3,200.00 533.40 16.67% 411206 - Cell Phone Allowance 1,320.00 13,695.00 - 13,695.00 16,995.00 3,300.00 19.42% Total Employee Benefits 205,879.99 1,800,199.99 515.29 1,800,715.28 2,201,832.00 401,116.72 18.22% Total Personnel Expenditures 893,767.88 6,972,634.79 515.29 6,973,150.08 8,335,716.00 1,362,565.92 16.35% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 116.19 1,759.08 180.52 1,939.60 1,855.00 (84.60) (4.56%) 421002 - Stationary & Printing 145.64 5,004.01 3,675.32 8,679.33 21,837.00 13,157.67 60.25% Total Office Supplies 261.83 6,763.09 3,855.84 10,618.93 23,692.00 13,073.07 55.18% Operating Supplies 422000 - Other Operating Supplies 18,087.54 257,363.29 61,749.88 319,113.17 338,911.00 19,797.83 5.84% 422001 - C.S. Gasoline 10,320.39 98,977.32 - 98,977.32 169,300.00 70,322.68 41.54% 422002 - Diesel/CNG 1,643.20 3,142.40 - 3,142.40 2,710.00 (432.40) (15.96%) 422003 - Gasoline 1,770.56 11,934.72 503.00 12,437.72 15,201.00 2,763.28 18.18% 422004 - Oil - 957.85 - 957.85 1,000.00 42.15 4.22% 422005 - Uniforms 82.75 17,948.55 991.50 18,940.05 37,935.00 18,994.95 50.07% 422006 - Computer Supplies & Equipment 199.99 227.55 - 227.55 100.00 (127.55) (127.55%) 422007 - Cleaning Supplies 271.12 795.04 - 795.04 200.00 (595.04) (297.52%) 422008 - Medical/Safety Supplies 157.72 6,034.41 113.84 6,148.25 11,663.00 5,514.75 47.28% 422009 - Recreation Supplies 17,951.56 134,131.10 13,569.17 147,700.27 270,467.00 122,766.73 45.39% 422010 - Plants Chemicals Seed & Fertilizer 2,732.93 125,221.85 18,968.04 144,189.89 166,545.00 22,355.11 13.42% 422013 - Promotional Supplies 1,075.02 1,537.99 - 1,537.99 610.00 (927.99) (152.13%) 422014 - Concessions Inventory 7,952.38 72,058.49 12,993.59 85,052.08 119,235.00 34,182.92 28.67% 422016 - Inventory For Sale 6,723.31 33,618.63 857.50 34,476.13 40,358.00 5,881.87 14.57% Total Operating Supplies 68,968.47 763,949.19 109,746.52 873,695.71 1,174,235.00 300,539.29 25.59% Repair & Maintenance Supplies 423000 - Other R&M Supplies 8,668.21 88,785.25 139,306.45 228,091.70 202,963.00 (25,128.70) (12.38%) 423001 - Building Materials 1,382.02 56,101.27 5,273.73 61,375.00 90,368.00 28,993.00 32.08% 423006 - Small Tools & Equipment 695.46 16,944.02 2,848.86 19,792.88 30,053.00 10,260.12 34.14% 423009 - Repair Parts 4,377.71 52,875.98 8,983.76 61,859.74 72,289.00 10,429.26 14.43% Total Repair & Maintenance Supplies 15,123.40 214,706.52 156,412.80 371,119.32 395,673.00 24,553.68 6.21% Total Supplies Expenditures 84,353.70 985,418.80 270,015.16 1,255,433.96 1,593,600.00 338,166.04 21.22% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,590.04 158,646.90 31,559.62 190,206.52 238,014.00 47,807.48 20.09% 431009 - Computer & Technology - 824.29 - 824.29 1,000.00 175.71 17.57% 431014 - Collection Costs 75.00 75.00 - 75.00 500.00 425.00 85.00% 431019 - Security Services 1,231.07 3,016.38 - 3,016.38 7,203.00 4,186.62 58.12% Total Professional Services 2,896.11 162,562.57 31,559.62 194,122.19 246,717.00 52,594.81 21.32% Communication & Transportation 432000 - Other Communication/Transp. - 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing 0.52 1,891.68 - 1,891.68 5,375.00 3,483.32 64.81% 432003 - Travel - 2,005.14 - 2,005.14 24,700.00 22,694.86 91.88% 432004 - Telecommunications 17.57 2,096.70 145.44 2,242.14 8,200.00 5,957.86 72.66% 432005 - Mileage Reimb 186.26 1,061.42 - 1,061.42 6,522.00 5,460.58 83.73% Total Communication & Transportation 204.35 7,078.94 145.44 7,224.38 44,797.00 37,572.62 83.87% Printing & Advertising 433001 - Outside Printing Services 3,319.49 8,866.56 443.00 9,309.56 32,229.00 22,919.44 71.11% 433002 - Publication of Legal Notice - 277.97 1,900.86 2,178.83 3,000.00 821.17 27.37% 433003 - Promotional 6,873.19 76,257.78 37,119.55 113,377.33 224,329.00 110,951.67 49.46% Total Printing & Advertising 10,192.68 85,402.31 39,463.41 124,865.72 259,558.00 134,692.28 51.89% Utilties 435001 - Electric 19,857.18 405,633.94 - 405,633.94 480,034.00 74,400.06 15.50% 435002 - Natural Gas 400.30 98,178.28 - 98,178.28 143,097.00 44,918.72 31.39% 435004 - Water 31,662.87 187,711.98 20,287.50 207,999.48 198,000.00 (9,999.48) (5.05%) Total Utilities 51,920.35 691,524.20 20,287.50 711,811.70 821,131.00 109,319.30 13.31% Repairs & Maintenance 436000 - Other R&M - 64,150.34 40,081.24 104,231.58 67,308.00 (36,923.58) (54.86%) 436001 - Building R&M 4,566.44 47,951.95 4,562.74 52,514.69 87,284.00 34,769.31 39.83% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 30,029.49 327,129.99 - 327,129.99 240,000.00 (87,129.99) (36.30%) 436005 - Other Equip R&M - 1,749.80 - 1,749.80 7,810.00 6,060.20 77.60% 436006 - Radio Equip R&M 1,978.74 10,870.06 1,996.00 12,866.06 16,500.00 3,633.94 22.02% 436011 - Exterminating 532.50 3,275.00 3,126.00 6,401.00 7,500.00 1,099.00 14.65% Total Repairs & Maintenance 37,107.17 455,127.14 49,765.98 504,893.12 434,902.00 (69,991.12) (16.09%) Rentals 437002 - Equipment Rental - 153.90 1,690.00 1,843.90 950.00 (893.90) (94.09%) 437006 - Recreation Space Rental - 500.00 700.00 1,200.00 1,200.00 - 0.00% Total Rentals - 653.90 2,390.00 3,043.90 2,150.00 (893.90) (41.58%) Debt Service 438100 - Principal 104,826.28 432,285.98 59,507.69 491,793.67 528,634.00 36,840.33 6.97% 438200 - Interest 2,353.41 36,100.67 5,485.62 41,586.29 47,472.00 5,885.71 12.40% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 4,400.00 - 0.00% Total Debt Service 107,179.69 472,786.65 64,993.31 537,779.96 580,506.00 42,726.04 7.36% Other Charges & Services 439000 - Misc Charges & Svcs 32,455.63 461,844.42 103,472.05 565,316.47 593,297.00 27,980.53 4.72% 439001 - Other Contractual Services 295.71 4,185.59 4,519.05 8,704.64 4,700.00 (4,004.64) (85.21%) 439003 - Subscriptions - 131.98 - 131.98 - (131.98) 0.00% 439004 - Dues & Memberships 12.95 3,052.03 - 3,052.03 5,210.00 2,157.97 41.42% 439005 - Bank & Credit Card Fees 605.00 7,884.65 - 7,884.65 20,835.00 12,950.35 62.16% 439006 - Education & Training 5,099.04 34,182.55 - 34,182.55 37,185.00 3,002.45 8.07% 439009 - Trash Removal 555.00 10,166.31 1,380.00 11,546.31 31,449.00 19,902.69 63.29% 439100 - Refunds/Awards/Indemnities 3,207.77 23,089.51 7,012.26 30,101.77 47,933.00 17,831.23 37.20% 439300 - Grants & Subsidies 511.20 12,197.72 - 12,197.72 19,500.00 7,302.28 37.45% 439999 - Bad Debt Expense - 715,000.00 - 715,000.00 715,000.00 - 0.00% Total Other Services & Charges - 5,606.12 - 5,606.12 7,100.00 1,493.88 21.04% 42,742.30 1,277,340.88 116,383.36 1,393,724.24 1,482,209.00 88,484.76 5.97% Total Services & Charges Expenditures 252,242.65 3,152,476.59 324,988.62 3,477,465.21 3,871,970.00 394,504.79 10.19% Capital Outlay Buildings 443001 - Building Improvements - 72,105.79 - 72,105.79 72,106.00 0.21 0.00% Total Buildings - 72,105.79 - 72,105.79 72,106.00 0.21 0.00% 444000 - Land Improvements - 955,045.39 76,033.25 1,031,078.64 1,200,895.00 169,816.36 14.14% Total Capital Expenditures - 72,105.79 - 72,105.79 72,106.00 0.21 0.00% Other Uses 452002 - Allocations-Admin Cost 54,385.00 543,836.00 - 543,836.00 652,606.00 108,770.00 16.67% 452003 - Allocations-IT 40,874.00 408,740.00 - 408,740.00 490,488.00 81,748.00 16.67% 452004 - Allocations-Liability Insurance 15,093.00 150,924.00 - 150,924.00 181,110.00 30,186.00 16.67% 452008 - Allocations-Payroll Cost 6,579.00 65,789.00 - 65,789.00 78,947.00 13,158.00 16.67% 452009 - Allocations-Facilities Mgmt 1,505.00 15,059.00 - 15,059.00 18,069.00 3,010.00 16.66% Total Other Uses 118,436.00 1,184,348.00 - 1,184,348.00 1,421,220.00 236,872.00 16.67% Total Expenditures 1,348,800.23 12,366,983.97 595,519.07 12,962,503.04 15,294,612.00 2,332,108.96 15.25%