Loading...
HomeMy WebLinkAboutJuly 20 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 58% 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 388,123.84 5,250,387.20 9,340,797.00 4,090,409.80 43.79% Total Property Taxes 388,123.84 5,250,387.20 9,340,797.00 4,090,409.80 43.79% Total Taxes 388,123.84 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,393.84 2,393.84 46,000.00 43,606.16 94.80% 347002 - Picnic Site Rental 970.00 1,942.60 3,300.00 1,357.40 41.13% 347003 - Golf Season Pass 2,759.50 159,368.20 165,000.00 5,631.80 3.41% 347004 - Golf Green Fees 159,224.65 398,187.80 550,000.00 151,812.20 27.60% 347005 - Golf Cart Rentals 71,634.76 171,105.47 330,000.00 158,894.53 48.15% 347006 - Golf Pro Shop Retail 10,413.41 24,790.87 60,000.00 35,209.13 58.68% 347007 - Golf Driving Range 6,036.55 16,184.72 20,000.00 3,815.28 19.08% 347008 - Golf Gift Certificate 321.61 1,161.93 5,500.00 4,338.07 78.87% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347011 - Special Events 33,423.13 314,778.70 941,465.00 626,686.30 66.57% 347012 - Food Sales 16,446.61 29,309.01 102,000.00 72,690.99 71.27% 347013 - Nonalcoholic Beverage 10,861.65 20,067.06 68,000.00 47,932.94 70.49% 347014 - Alcoholic Beverage Sales 19,976.26 50,454.87 90,000.00 39,545.13 43.94% 347015 - Lease of Stadium 5,000.00 35,000.00 75,000.00 40,000.00 53.33% 347016 - East Race Waterway 22,793.83 26,132.58 50,000.00 23,867.42 47.73% 347017 - Ice Skating - 148,838.02 123,500.00 (25,338.02) (20.52%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347019 - Site Mowing 53,260.80 53,260.80 95,000.00 41,739.20 43.94% 347021 - Tree Maintenance 1,456.00 50,525.00 160,000.00 109,475.00 68.42% 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 200.00 200.00 - (200.00) 0.00% 347040 - Pavilion Rental 5,045.00 5,215.00 17,500.00 12,285.00 70.20% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short 172.29 595.14 - (595.14) 0.00% Total Culture & Recreation 422,389.89 1,518,111.61 3,036,794.00 1,518,682.39 50.01% Total Charges for Services 422,389.89 1,518,111.61 3,036,794.00 1,518,682.39 50.01% Miscellaneous Revenue 360000 - Miscellaneous 23,181.53 34,080.76 22,500.00 (11,580.76) (51.47%) 361000 - Interest Earnings 5,127.19 2,509.27 37,250.00 34,740.73 93.26% 362000 - Rental of Property 450.00 16,697.25 60,000.00 43,302.75 72.17% 367000 - Donations from Private Sources - 520,750.00 1,290,000.00 769,250.00 59.63% Total Miscellaneous Revenue 28,758.72 574,037.28 1,409,750.00 835,712.72 59.28% Refunds & Reimbursements July 31, 2020 380000 - Misc Reimbursements (113,449.69) (18,406.21) 45,807.00 64,213.21 140.18% 380001 - Insurance Claims 708.00 708.00 708.00 - 0.00% 380007 - Energy Rebates - 3,040.05 3,040.00 (0.05) (0.00%) 381000 - Misc Reimbursements - - 1,056.00 1,056.00 100.00% Total Refunds & Reimbursements (112,741.69) (14,658.16) 50,611.00 65,269.16 128.96% Other Sources 391000 - Interfund Transfers In 66,667.00 466,665.00 800,000.00 333,335.00 41.67% Total Other Sources 66,667.00 466,665.00 800,000.00 333,335.00 41.67% Total Revenue 793,197.76 8,878,678.01 16,456,050.00 7,577,371.99 46.05% 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 230,014.42 1,767,942.18 - 1,767,942.18 3,174,690.00 1,406,747.82 44.31% 410002 - Teamster Wages 116,046.57 844,074.80 - 844,074.80 1,423,153.00 579,078.20 40.69% 410003 - Permanent Part Time 93,051.87 513,484.42 - 513,484.42 715,176.00 201,691.58 28.20% 410004 - Extra & Overtime 10,505.40 39,817.75 - 39,817.75 59,850.00 20,032.25 33.47% 410005 - Seasonal & Interns 117,278.13 238,674.48 - 238,674.48 865,665.00 626,990.52 72.43% 410007 - Longevity Pay 150.00 4,950.00 - 4,950.00 8,050.00 3,100.00 38.51% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 567,046.39 3,408,943.63 - 3,408,943.63 6,247,784.00 2,838,840.37 45.44% Employee Benefits 411001 - FICA Regular 41,958.26 253,110.61 - 253,110.61 481,017.00 227,906.39 47.38% 411004 - PERF Regular 39,596.87 293,545.05 - 293,545.05 529,678.00 236,132.95 44.58% 411005 - PERF Union 1,455.28 10,875.30 - 10,875.30 22,652.00 11,776.70 51.99% 411007 - Unemployment Comp 35.49 265.53 - 265.53 511.00 245.47 48.04% 411008 - Health Insurance 93,171.16 641,246.27 - 641,246.27 1,114,598.00 473,351.73 42.47% 411009 - Life Insurance 940.04 6,540.28 - 6,540.28 11,520.00 4,979.72 43.23% 411014 - Parental Leave 1,238.59 9,282.38 - 9,282.38 16,408.00 7,125.62 43.43% 411200 - Clothing Allowance - 123.04 - 123.04 - (123.04) 0.00% 411201 - Tool Allowance 347.69 1,097.16 427.61 1,524.77 5,228.00 3,703.23 70.83% 411203 - Job Readiness Allow. - 14,768.75 - 14,768.75 15,300.00 531.25 3.47% 411204 - Auto Allowance 266.66 1,866.62 - 1,866.62 3,200.00 1,333.38 41.67% 411206 - Cell Phone Allowance 1,320.00 9,735.00 - 9,735.00 17,820.00 8,085.00 45.37% Total Employee Benefits 180,330.04 1,242,455.99 427.61 1,242,883.60 2,217,932.00 975,048.40 43.96% Total Personnel Expenditures 747,376.43 4,651,399.62 427.61 4,651,827.23 8,465,716.00 3,813,888.77 45.05% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 400.78 1,140.63 - 1,140.63 575.00 (565.63) (98.37%) 421002 - Stationary & Printing 361.96 4,276.13 736.32 5,012.45 24,187.00 19,174.55 79.28% Total Office Supplies 762.74 5,416.76 736.32 6,153.08 24,762.00 18,608.92 75.15% Operating Supplies 422000 - Other Operating Supplies 30,917.43 176,410.29 65,908.32 242,318.61 324,111.00 81,792.39 25.24% 422001 - C.S. Gasoline 11,308.92 64,904.96 - 64,904.96 166,800.00 101,895.04 61.09% 422002 - Diesel/CNG 710.40 710.40 - 710.40 - (710.40) 0.00% 422003 - Gasoline 4,682.75 7,403.01 - 7,403.01 23,196.00 15,792.99 68.08% 422004 - Oil 432.30 432.30 525.55 957.85 1,000.00 42.15 4.22% 422005 - Uniforms 645.45 13,229.90 991.50 14,221.40 37,285.00 23,063.60 61.86% 422006 - Computer Supplies & Equipment 27.56 27.56 - 27.56 - (27.56) 0.00% 422007 - Cleaning Supplies 75.77 207.33 - 207.33 100.00 (107.33) (107.33%) 422008 - Medical/Safety Supplies 299.67 5,552.66 113.84 5,666.50 11,663.00 5,996.50 51.41% 422009 - Recreation Supplies 7,979.68 98,265.69 15,483.89 113,749.58 270,847.00 157,097.42 58.00% 422010 - Plants Chemicals Seed & Fertilizer 11,118.65 102,914.53 13,115.64 116,030.17 187,555.00 71,524.83 38.14% 422013 - Promotional Supplies 183.96 389.68 - 389.68 210.00 (179.68) (85.56%) 422014 - Concessions Inventory 19,731.75 35,669.47 13,414.50 49,083.97 106,040.00 56,956.03 53.71% 422016 - Inventory For Sale 5.54 19,236.69 857.50 20,094.19 48,858.00 28,763.81 58.87% Total Operating Supplies 88,119.83 525,354.47 110,410.74 635,765.21 1,177,665.00 541,899.79 46.01% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,514.42 52,080.23 10,679.80 62,760.03 202,463.00 139,702.97 69.00% 423001 - Building Materials 19,835.38 52,832.23 5,332.20 58,164.43 90,868.00 32,703.57 35.99% 423006 - Small Tools & Equipment 1,052.33 15,632.75 99.99 15,732.74 30,053.00 14,320.26 47.65% 423009 - Repair Parts 3,978.34 40,362.32 6,233.14 46,595.46 67,789.00 21,193.54 31.26% Total Repair & Maintenance Supplies 34,380.47 160,907.53 22,345.13 183,252.66 391,173.00 207,920.34 53.15% Total Supplies Expenditures 123,263.04 691,678.76 133,492.19 825,170.95 1,593,600.00 768,429.05 48.22% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,707.52 143,003.80 26,048.45 169,052.25 260,644.00 91,591.75 35.14% 431009 - Computer & Technology 206.96 506.29 - 506.29 700.00 193.71 27.67% 431014 - Collection Costs - - - - 500.00 500.00 100.00% 431019 - Security Services 1,242.64 1,576.00 - 1,576.00 4,860.00 3,284.00 67.57% Total Professional Services 4,157.12 145,086.09 26,048.45 171,134.54 266,704.00 95,569.46 35.83% Communication & Transportation 432000 - Other Communication/Transp. 16.00 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing 60.93 1,660.38 - 1,660.38 5,375.00 3,714.62 69.11% 432003 - Travel - 2,005.14 - 2,005.14 28,500.00 26,494.86 92.96% 432004 - Telecommunications 257.83 2,019.97 222.17 2,242.14 8,200.00 5,957.86 72.66% 432005 - Mileage Reimb - 94.88 - 94.88 6,422.00 6,327.12 98.52% Total Communication & Transportation 334.76 5,804.37 222.17 6,026.54 48,497.00 42,470.46 87.57% Printing & Advertising 433001 - Outside Printing Services 227.57 5,547.07 401.00 5,948.07 32,229.00 26,280.93 81.54% 433002 - Publication of Legal Notice - 277.97 1,814.00 2,091.97 3,000.00 908.03 30.27% 433003 - Promotional 7,734.62 51,224.38 36,751.75 87,976.13 232,579.00 144,602.87 62.17% Total Printing & Advertising 7,962.19 57,049.42 38,966.75 96,016.17 267,808.00 171,791.83 64.15% Utilties 435001 - Electric 85,905.38 323,676.74 - 323,676.74 379,834.00 56,157.26 14.78% 435002 - Natural Gas 9,083.29 97,431.30 - 97,431.30 111,297.00 13,865.70 12.46% 435004 - Water 28,360.03 82,854.69 115,144.79 197,999.48 198,000.00 0.52 0.00% Total Utilities 123,348.70 503,962.73 115,144.79 619,107.52 689,131.00 70,023.48 10.16% Repairs & Maintenance 436000 - Other R&M 1,574.00 57,103.76 10,279.99 67,383.75 67,308.00 (75.75) (0.11%) 436001 - Building R&M 11,990.63 34,881.41 8,668.30 43,549.71 89,284.00 45,734.29 51.22% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 25,117.18 218,982.03 - 218,982.03 240,000.00 21,017.97 8.76% 436005 - Other Equip R&M - 750.00 - 750.00 7,810.00 7,060.00 90.40% 436006 - Radio Equip R&M 558.77 5,542.66 - 5,542.66 16,500.00 10,957.34 66.41% 436011 - Exterminating 1,677.50 1,677.50 4,412.50 6,090.00 7,500.00 1,410.00 18.80% Total Repairs & Maintenance 40,918.08 318,937.36 23,360.79 342,298.15 436,902.00 94,603.85 21.65% Rentals 437002 - Equipment Rental - 153.90 725.00 878.90 200.00 (678.90) (339.45%) 437006 - Recreation Space Rental - 500.00 700.00 1,200.00 1,200.00 - 0.00% Total Rentals - 653.90 1,425.00 2,078.90 1,400.00 (678.90) (48.49%) Debt Service 438100 - Principal 25,541.14 326,034.89 59,507.69 385,542.58 528,634.00 143,091.42 27.07% 438200 - Interest 332.03 33,693.97 5,485.62 39,179.59 47,472.00 8,292.41 17.47% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 4,400.00 - 0.00% Total Debt Service 25,873.17 364,128.86 64,993.31 429,122.17 580,506.00 151,383.83 26.08% Other Charges & Services 439000 - Misc Charges & Svcs 59,611.25 344,206.22 120,935.97 465,142.19 584,120.00 118,977.81 20.37% 439001 - Other Contractual Services 911.48 2,547.64 5,587.78 8,135.42 1,700.00 (6,435.42) (378.55%) 439003 - Subscriptions 131.98 131.98 - 131.98 - (131.98) 0.00% 439004 - Dues & Memberships 233.18 2,862.18 - 2,862.18 4,945.00 2,082.82 42.12% 439005 - Bank & Credit Card Fees 700.90 7,004.65 - 7,004.65 19,835.00 12,830.35 64.69% 439006 - Education & Training 5,803.80 15,315.15 - 15,315.15 27,000.00 11,684.85 43.28% 439009 - Trash Removal 368.47 7,587.38 - 7,587.38 31,349.00 23,761.62 75.80% 439100 - Refunds/Awards/Indemnities 2,056.03 16,182.86 9,917.12 26,099.98 42,773.00 16,673.02 38.98% 439300 - Grants & Subsidies 1,675.00 10,251.06 - 10,251.06 19,200.00 8,948.94 46.61% 439999 - Bad Debt Expense - 715,000.00 - 715,000.00 715,000.00 - 0.00% Total Other Services & Charges - 4,637.12 - 4,637.12 5,100.00 462.88 9.08% 71,492.09 1,125,726.24 136,440.87 1,262,167.11 1,451,022.00 188,854.89 13.02% Total Services & Charges Expenditures 274,086.11 2,521,348.97 406,602.13 2,927,951.10 3,741,970.00 814,018.90 21.75% 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 - 748,451.64 2,000.00 750,451.64 1,200,895.00 450,443.36 37.51% 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 380,681.00 - 380,681.00 652,606.00 271,925.00 41.67% 452003 - Allocations-IT 40,874.00 286,118.00 - 286,118.00 490,488.00 204,370.00 41.67% 452004 - Allocations-Liability Insurance 15,093.00 105,645.00 - 105,645.00 181,110.00 75,465.00 41.67% 452008 - Allocations-Payroll Cost 6,579.00 46,052.00 - 46,052.00 78,947.00 32,895.00 41.67% 452009 - Allocations-Facilities Mgmt 1,505.00 10,544.00 - 10,544.00 18,069.00 7,525.00 41.65% Total Other Uses 118,436.00 829,040.00 - 829,040.00 1,421,220.00 592,180.00 41.67% Total Expenditures 1,263,161.58 8,765,573.14 540,521.93 9,306,095.07 15,294,612.00 5,988,516.93 39.15%