Loading...
HomeMy WebLinkAboutAug 20 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 67% 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 423.03 2,816.87 46,000.00 43,183.13 93.88% 347002 - Picnic Site Rental 660.00 2,602.60 3,300.00 697.40 21.13% 347003 - Golf Season Pass 3,371.50 162,739.70 165,000.00 2,260.30 1.37% 347004 - Golf Green Fees 177,267.99 575,455.79 550,000.00 (25,455.79) (4.63%) 347005 - Golf Cart Rentals 74,395.84 245,501.31 330,000.00 84,498.69 25.61% 347006 - Golf Pro Shop Retail 10,610.93 35,401.80 60,000.00 24,598.20 41.00% 347007 - Golf Driving Range 6,803.10 22,987.82 20,000.00 (2,987.82) (14.94%) 347008 - Golf Gift Certificate (205.25) 956.68 5,500.00 4,543.32 82.61% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347011 - Special Events 30,381.91 345,160.61 941,465.00 596,304.39 63.34% 347012 - Food Sales 13,201.56 42,510.57 102,000.00 59,489.43 58.32% 347013 - Nonalcoholic Beverage 9,602.32 29,669.38 68,000.00 38,330.62 56.37% 347014 - Alcoholic Beverage Sales 23,443.60 73,898.47 90,000.00 16,101.53 17.89% 347015 - Lease of Stadium 5,000.00 40,000.00 75,000.00 35,000.00 46.67% 347016 - East Race Waterway 21,377.06 47,509.64 50,000.00 2,490.36 4.98% 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 21,849.60 75,110.40 95,000.00 19,889.60 20.94% 347021 - Tree Maintenance 1,169.86 51,694.86 160,000.00 108,305.14 67.69% 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) 0.00% 347040 - Pavilion Rental 2,655.00 7,870.00 17,500.00 9,630.00 55.03% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short 197.45 792.59 - (792.59) 0.00% Total Culture & Recreation 402,205.50 1,920,317.11 3,036,794.00 1,116,476.89 36.76% Total Charges for Services 402,205.50 1,920,317.11 3,036,794.00 1,116,476.89 36.76% Miscellaneous Revenue 360000 - Miscellaneous 2,374.99 36,455.75 22,500.00 (13,955.75) (62.03%) 361000 - Interest Earnings 1,487.66 3,996.93 37,250.00 33,253.07 89.27% 362000 - Rental of Property 542.99 17,240.24 60,000.00 42,759.76 71.27% 367000 - Donations from Private Sources 500,000.00 1,020,750.00 1,290,000.00 269,250.00 20.87% Total Miscellaneous Revenue 504,405.64 1,078,442.92 1,409,750.00 331,307.08 23.50% Refunds & Reimbursements August 31, 2020 380000 - Misc Reimbursements 1,158.00 (17,248.21) 45,807.00 63,055.21 137.65% 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,055.99 1,056.00 0.01 0.00% Total Refunds & Reimbursements 2,213.99 (12,444.17) 50,611.00 63,055.17 124.59% Other Sources 391000 - Interfund Transfers In 66,667.00 533,332.00 800,000.00 266,668.00 33.33% Total Other Sources 66,667.00 533,332.00 800,000.00 266,668.00 33.33% Total Revenue 975,492.13 9,854,170.14 16,456,050.00 6,601,879.86 40.12% 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 239,720.65 2,007,662.83 - 2,007,662.83 3,174,690.00 1,167,027.17 36.76% 410002 - Teamster Wages 116,255.19 960,329.99 - 960,329.99 1,423,153.00 462,823.01 32.52% 410003 - Permanent Part Time 90,199.37 603,683.79 - 603,683.79 813,176.00 209,492.21 25.76% 410004 - Extra & Overtime 8,240.76 48,058.51 - 48,058.51 63,850.00 15,791.49 24.73% 410005 - Seasonal & Interns 121,857.60 360,532.08 - 360,532.08 763,665.00 403,132.92 52.79% 410007 - Longevity Pay 500.00 5,450.00 - 5,450.00 8,050.00 2,600.00 32.30% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 576,773.57 3,985,717.20 - 3,985,717.20 6,247,784.00 2,262,066.80 36.21% Employee Benefits 411001 - FICA Regular 42,808.40 295,919.01 - 295,919.01 481,017.00 185,097.99 38.48% 411004 - PERF Regular 39,110.90 332,655.95 - 332,655.95 529,678.00 197,022.05 37.20% 411005 - PERF Union 1,446.72 12,322.02 - 12,322.02 22,652.00 10,329.98 45.60% 411007 - Unemployment Comp 36.32 301.85 - 301.85 511.00 209.15 40.93% 411008 - Health Insurance 93,129.16 734,375.43 - 734,375.43 1,114,598.00 380,222.57 34.11% 411009 - Life Insurance 930.04 7,470.32 - 7,470.32 11,520.00 4,049.68 35.15% 411014 - Parental Leave 1,272.08 10,554.46 - 10,554.46 16,408.00 5,853.54 35.67% 411200 - Clothing Allowance - 123.04 - 123.04 - (123.04) 0.00% 411201 - Tool Allowance - 1,097.16 624.47 1,721.63 5,228.00 3,506.37 67.07% 411203 - Job Readiness Allow. - 14,768.75 - 14,768.75 15,300.00 531.25 3.47% 411204 - Auto Allowance 266.66 2,133.28 - 2,133.28 3,200.00 1,066.72 33.34% 411206 - Cell Phone Allowance 1,320.00 11,055.00 - 11,055.00 17,820.00 6,765.00 37.96% Total Employee Benefits 180,320.28 1,422,776.27 624.47 1,423,400.74 2,217,932.00 794,531.26 35.82% Total Personnel Expenditures 757,093.85 5,408,493.47 624.47 5,409,117.94 8,465,716.00 3,056,598.06 36.11% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 63.06 1,203.69 64.68 1,268.37 1,855.00 586.63 31.62% 421002 - Stationary & Printing 135.99 4,471.12 972.62 5,443.74 22,587.00 17,143.26 75.90% Total Office Supplies 199.05 5,674.81 1,037.30 6,712.11 24,442.00 17,729.89 72.54% Operating Supplies 422000 - Other Operating Supplies 41,643.30 218,259.80 48,421.80 266,681.60 327,811.00 61,129.40 18.65% 422001 - C.S. Gasoline 13,574.51 78,479.47 - 78,479.47 166,800.00 88,320.53 52.95% 422002 - Diesel/CNG - 710.40 - 710.40 710.00 (0.40) (0.06%) 422003 - Gasoline 2,761.15 10,164.16 - 10,164.16 22,996.00 12,831.84 55.80% 422004 - Oil 525.55 957.85 - 957.85 1,000.00 42.15 4.22% 422005 - Uniforms 2,834.34 16,365.80 991.50 17,357.30 37,385.00 20,027.70 53.57% 422006 - Computer Supplies & Equipment - 27.56 - 27.56 - (27.56) 0.00% 422007 - Cleaning Supplies 86.56 293.89 - 293.89 100.00 (193.89) (193.89%) 422008 - Medical/Safety Supplies 190.67 5,743.33 113.84 5,857.17 11,663.00 5,805.83 49.78% 422009 - Recreation Supplies 8,074.05 106,831.59 14,998.17 121,829.76 270,467.00 148,637.24 54.96% 422010 - Plants Chemicals Seed & Fertilizer 4,748.23 107,827.97 21,659.18 129,487.15 183,745.00 54,257.85 29.53% 422013 - Promotional Supplies 5.31 394.99 - 394.99 410.00 15.01 3.66% 422014 - Concessions Inventory 6,863.95 42,533.42 13,247.43 55,780.85 108,040.00 52,259.15 48.37% 422016 - Inventory For Sale 4,187.88 23,424.57 857.50 24,282.07 45,858.00 21,575.93 47.05% Total Operating Supplies 85,495.50 612,014.80 100,289.42 712,304.22 1,176,985.00 464,680.78 39.48% Repair & Maintenance Supplies 423000 - Other R&M Supplies 8,181.85 60,935.47 84,709.36 145,644.83 202,463.00 56,818.17 28.06% 423001 - Building Materials 1,495.73 54,327.96 4,861.18 59,189.14 90,868.00 31,678.86 34.86% 423006 - Small Tools & Equipment 507.23 16,139.98 99.99 16,239.97 30,053.00 13,813.03 45.96% 423009 - Repair Parts 5,893.73 46,256.05 5,205.52 51,461.57 68,789.00 17,327.43 25.19% Total Repair & Maintenance Supplies 16,078.54 177,659.46 94,876.05 272,535.51 392,173.00 119,637.49 30.51% Total Supplies Expenditures 101,773.09 795,349.07 196,202.77 991,551.84 1,593,600.00 602,048.16 37.78% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 8,105.25 151,654.57 24,945.75 176,600.32 265,644.00 89,043.68 33.52% 431009 - Computer & Technology 318.00 824.29 - 824.29 800.00 (24.29) (3.04%) 431014 - Collection Costs - - - - 500.00 500.00 100.00% 431019 - Security Services 156.83 1,732.83 - 1,732.83 6,103.00 4,370.17 71.61% Total Professional Services 8,580.08 154,211.69 24,945.75 179,157.44 273,047.00 93,889.56 34.39% Communication & Transportation 432000 - Other Communication/Transp. - 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing 45.63 1,706.01 - 1,706.01 5,375.00 3,668.99 68.26% 432003 - Travel - 2,005.14 - 2,005.14 24,900.00 22,894.86 91.95% 432004 - Telecommunications 59.16 2,079.13 163.01 2,242.14 8,200.00 5,957.86 72.66% 432005 - Mileage Reimb 780.28 875.16 - 875.16 6,422.00 5,546.84 86.37% Total Communication & Transportation 885.07 6,689.44 163.01 6,852.45 44,897.00 38,044.55 84.74% Printing & Advertising 433001 - Outside Printing Services - 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 6,846.79 58,071.17 35,913.75 93,984.92 226,329.00 132,344.08 58.47% Total Printing & Advertising 6,846.79 63,896.21 38,128.75 102,024.96 261,558.00 159,533.04 60.99% Utilties 435001 - Electric 60,320.08 383,996.82 - 383,996.82 380,034.00 (3,962.82) (1.04%) 435002 - Natural Gas 171.92 97,603.22 - 97,603.22 113,097.00 15,493.78 13.70% 435004 - Water 36,058.83 118,913.52 79,085.96 197,999.48 198,000.00 0.52 0.00% Total Utilities 96,550.83 600,513.56 79,085.96 679,599.52 691,131.00 11,531.48 1.67% Repairs & Maintenance 436000 - Other R&M 905.00 58,008.76 14,274.99 72,283.75 67,308.00 (4,975.75) (7.39%) 436001 - Building R&M 4,091.80 38,973.21 5,422.30 44,395.51 87,284.00 42,888.49 49.14% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 51,705.11 270,687.14 - 270,687.14 240,000.00 (30,687.14) (12.79%) 436005 - Other Equip R&M 999.80 1,749.80 - 1,749.80 7,810.00 6,060.20 77.60% 436006 - Radio Equip R&M 1,790.15 7,332.81 - 7,332.81 16,500.00 9,167.19 55.56% 436011 - Exterminating 532.50 2,210.00 3,880.00 6,090.00 7,500.00 1,410.00 18.80% Total Repairs & Maintenance 60,024.36 378,961.72 23,577.29 402,539.01 434,902.00 32,362.99 7.44% Rentals 437002 - Equipment Rental - 153.90 725.00 878.90 950.00 71.10 7.48% 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 2,150.00 71.10 3.31% Debt Service 438100 - Principal 710.98 326,745.87 59,507.69 386,253.56 528,634.00 142,380.44 26.93% 438200 - Interest 28.08 33,722.05 5,485.62 39,207.67 47,472.00 8,264.33 17.41% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 4,400.00 - 0.00% Total Debt Service 739.06 364,867.92 64,993.31 429,861.23 580,506.00 150,644.77 25.95% Other Charges & Services 439000 - Misc Charges & Svcs 50,016.57 394,222.79 138,669.49 532,892.28 581,417.00 48,524.72 8.35% 439001 - Other Contractual Services 365.12 2,912.76 5,222.66 8,135.42 3,700.00 (4,435.42) (119.88%) 439003 - Subscriptions - 131.98 - 131.98 - (131.98) 0.00% 439004 - Dues & Memberships 103.95 2,966.13 - 2,966.13 4,945.00 1,978.87 40.02% 439005 - Bank & Credit Card Fees 275.00 7,279.65 - 7,279.65 20,835.00 13,555.35 65.06% 439006 - Education & Training 6,987.23 22,302.38 - 22,302.38 27,000.00 4,697.62 17.40% 439009 - Trash Removal 1,399.99 8,987.37 - 8,987.37 31,449.00 22,461.63 71.42% 439100 - Refunds/Awards/Indemnities 2,443.39 18,626.25 10,958.73 29,584.98 45,133.00 15,548.02 34.45% 439300 - Grants & Subsidies 1,013.01 11,264.07 - 11,264.07 19,200.00 7,935.93 41.33% 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 5,100.00 (506.12) (9.92%) 62,604.26 1,189,299.50 154,850.88 1,344,150.38 1,453,779.00 109,628.62 7.54% Total Services & Charges Expenditures 236,230.45 2,759,093.94 387,169.95 3,146,263.89 3,741,970.00 595,706.11 15.92% 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 5,062.50 753,514.14 277,564.50 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 435,066.00 - 435,066.00 652,606.00 217,540.00 33.33% 452003 - Allocations-IT 40,874.00 326,992.00 - 326,992.00 490,488.00 163,496.00 33.33% 452004 - Allocations-Liability Insurance 15,093.00 120,738.00 - 120,738.00 181,110.00 60,372.00 33.33% 452008 - Allocations-Payroll Cost 6,579.00 52,631.00 - 52,631.00 78,947.00 26,316.00 33.33% 452009 - Allocations-Facilities Mgmt 1,505.00 12,049.00 - 12,049.00 18,069.00 6,020.00 33.32% Total Other Uses 118,436.00 947,476.00 - 947,476.00 1,421,220.00 473,744.00 33.33% Total Expenditures 1,213,533.39 9,982,518.27 583,997.19 10,566,515.46 15,294,612.00 4,728,096.54 30.91%