Loading...
HomeMy WebLinkAboutSept 20 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 75% 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 318.00 2,920.60 3,300.00 379.40 11.50% 347003 - Golf Season Pass - 162,739.70 165,000.00 2,260.30 1.37% 347004 - Golf Green Fees 133,998.71 709,454.50 550,000.00 (159,454.50) (28.99%) 347005 - Golf Cart Rentals 63,349.44 308,850.75 330,000.00 21,149.25 6.41% 347006 - Golf Pro Shop Retail 10,528.07 45,929.87 60,000.00 14,070.13 23.45% 347007 - Golf Driving Range 6,311.36 29,299.18 20,000.00 (9,299.18) (46.50%) 347008 - Golf Gift Certificate 239.39 1,196.07 5,500.00 4,303.93 78.25% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347011 - Special Events 19,883.43 363,582.04 941,465.00 577,882.96 61.38% 347012 - Food Sales 10,785.34 53,295.91 102,000.00 48,704.09 47.75% 347013 - Nonalcoholic Beverage 5,456.43 35,124.88 68,000.00 32,875.12 48.35% 347014 - Alcoholic Beverage Sales 20,458.83 94,357.30 90,000.00 (4,357.30) (4.84%) 347015 - Lease of Stadium 5,000.00 45,000.00 75,000.00 30,000.00 40.00% 347016 - East Race Waterway 5,519.06 53,028.70 50,000.00 (3,028.70) (6.06%) 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 19,968.00 95,078.40 95,000.00 (78.40) (0.08%) 347021 - Tree Maintenance 796.20 52,516.06 160,000.00 107,483.94 67.18% 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 300.00 500.00 - (500.00) 0.00% 347040 - Pavilion Rental 1,305.00 9,175.00 17,500.00 8,325.00 47.57% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short (5.17) 787.42 - (787.42) 0.00% Total Culture & Recreation 304,212.09 2,223,091.27 3,036,794.00 813,702.73 26.79% Total Charges for Services 304,212.09 2,223,091.27 3,036,794.00 813,702.73 26.79% Miscellaneous Revenue 360000 - Miscellaneous (44,035.29) (7,579.54) 22,500.00 30,079.54 133.69% 361000 - Interest Earnings 2,053.09 6,050.02 37,250.00 31,199.98 83.76% 362000 - Rental of Property 1,477.01 18,717.25 60,000.00 41,282.75 68.80% 367000 - Donations from Private Sources - 1,020,750.00 1,290,000.00 269,250.00 20.87% Total Miscellaneous Revenue (40,505.19) 1,037,937.73 1,409,750.00 371,812.27 26.37% Refunds & Reimbursements September 30, 2020 380000 - Misc Reimbursements 45,416.66 28,168.45 45,807.00 17,638.55 38.51% 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 - (144.00) 0.00% Total Refunds & Reimbursements 45,560.66 33,116.49 50,611.00 17,494.51 34.57% Other Sources 391000 - Interfund Transfers In 66,667.00 599,999.00 800,000.00 200,001.00 25.00% 392000 - Gain/Loss on Sale of Asset 2,162.00 2,162.00 - (2,162.00) 0.00% 392005 - Sale of Non-Capital Assets 11,270.00 11,270.00 - (11,270.00) 0.00% Total Other Sources 80,099.00 613,431.00 800,000.00 186,569.00 23.32% Total Revenue 389,366.56 10,242,098.77 16,456,050.00 6,213,951.23 37.76% 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 237,835.53 2,245,498.36 - 2,245,498.36 3,084,690.00 839,191.64 27.21% 410002 - Teamster Wages 113,118.50 1,073,448.49 - 1,073,448.49 1,423,153.00 349,704.51 24.57% 410003 - Permanent Part Time 81,978.34 685,662.13 - 685,662.13 823,176.00 137,513.87 16.71% 410004 - Extra & Overtime 7,246.16 55,304.67 - 55,304.67 63,850.00 8,545.33 13.38% 410005 - Seasonal & Interns 57,951.18 418,483.26 - 418,483.26 753,665.00 335,181.74 44.47% 410007 - Longevity Pay 700.00 6,150.00 - 6,150.00 8,050.00 1,900.00 23.60% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 498,829.71 4,484,546.91 - 4,484,546.91 6,157,784.00 1,673,237.09 27.17% Employee Benefits 411001 - FICA Regular 36,717.19 332,636.20 - 332,636.20 481,017.00 148,380.80 30.85% 411004 - PERF Regular 38,276.74 370,932.69 - 370,932.69 529,678.00 158,745.31 29.97% 411005 - PERF Union 1,413.78 13,735.80 - 13,735.80 22,652.00 8,916.20 39.36% 411007 - Unemployment Comp 36.02 337.87 - 337.87 511.00 173.13 33.88% 411008 - Health Insurance 91,152.76 825,528.19 - 825,528.19 1,074,598.00 249,069.81 23.18% 411009 - Life Insurance 910.04 8,380.36 - 8,380.36 11,520.00 3,139.64 27.25% 411014 - Parental Leave 1,253.68 11,808.14 - 11,808.14 16,408.00 4,599.86 28.03% 411200 - Clothing Allowance - 123.04 - 123.04 200.00 76.96 38.48% 411201 - Tool Allowance 196.86 1,294.02 427.61 1,721.63 5,028.00 3,306.37 65.76% 411203 - Job Readiness Allow. - 14,768.75 - 14,768.75 15,300.00 531.25 3.47% 411204 - Auto Allowance 266.66 2,399.94 - 2,399.94 3,200.00 800.06 25.00% 411206 - Cell Phone Allowance 1,320.00 12,375.00 - 12,375.00 17,820.00 5,445.00 30.56% Total Employee Benefits 171,543.73 1,594,320.00 427.61 1,594,747.61 2,177,932.00 583,184.39 26.78% Total Personnel Expenditures 670,373.44 6,078,866.91 427.61 6,079,294.52 8,335,716.00 2,256,421.48 27.07% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 372.64 1,576.33 73.89 1,650.22 1,855.00 204.78 11.04% 421002 - Stationary & Printing 377.26 4,858.37 805.96 5,664.33 22,587.00 16,922.67 74.92% Total Office Supplies 749.90 6,434.70 879.85 7,314.55 24,442.00 17,127.45 70.07% Operating Supplies 422000 - Other Operating Supplies 18,219.61 237,695.32 53,275.12 290,970.44 337,411.00 46,440.56 13.76% 422001 - C.S. Gasoline 10,177.46 88,656.93 - 88,656.93 167,800.00 79,143.07 47.17% 422002 - Diesel/CNG 788.80 1,499.20 - 1,499.20 1,710.00 210.80 12.33% 422003 - Gasoline - 10,164.16 - 10,164.16 22,696.00 12,531.84 55.22% 422004 - Oil - 957.85 - 957.85 1,000.00 42.15 4.22% 422005 - Uniforms 1,500.00 17,865.80 991.50 18,857.30 37,385.00 18,527.70 49.56% 422006 - Computer Supplies & Equipment - 27.56 - 27.56 100.00 72.44 72.44% 422007 - Cleaning Supplies 230.03 523.92 - 523.92 200.00 (323.92) (161.96%) 422008 - Medical/Safety Supplies 63.28 5,806.61 113.84 5,920.45 11,663.00 5,742.55 49.24% 422009 - Recreation Supplies 6,235.72 113,127.31 16,061.00 129,188.31 270,467.00 141,278.69 52.24% 422010 - Plants Chemicals Seed & Fertilizer 14,660.95 122,488.92 10,099.16 132,588.08 174,045.00 41,456.92 23.82% 422013 - Promotional Supplies - 462.97 - 462.97 610.00 147.03 24.10% 422014 - Concessions Inventory 21,447.55 64,106.11 12,197.20 76,303.31 108,040.00 31,736.69 29.37% 422016 - Inventory For Sale 3,470.75 26,895.32 857.50 27,752.82 41,858.00 14,105.18 33.70% Total Operating Supplies 76,794.15 690,277.98 93,595.32 783,873.30 1,174,985.00 391,111.70 33.29% Repair & Maintenance Supplies 423000 - Other R&M Supplies 19,181.57 80,117.04 75,602.92 155,719.96 202,463.00 46,743.04 23.09% 423001 - Building Materials 391.29 54,719.25 5,456.32 60,175.57 90,868.00 30,692.43 33.78% 423006 - Small Tools & Equipment 108.58 16,248.56 99.99 16,348.55 30,053.00 13,704.45 45.60% 423009 - Repair Parts 2,242.22 48,498.27 9,365.99 57,864.26 70,789.00 12,924.74 18.26% Total Repair & Maintenance Supplies 21,923.66 199,583.12 90,525.22 290,108.34 394,173.00 104,064.66 26.40% Total Supplies Expenditures 99,467.71 896,295.80 185,000.39 1,081,296.19 1,593,600.00 512,303.81 32.15% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 5,333.29 157,037.33 23,218.82 180,256.15 236,894.00 56,637.85 23.91% 431009 - Computer & Technology - 824.29 - 824.29 1,000.00 175.71 17.57% 431014 - Collection Costs - - 75.00 75.00 500.00 425.00 85.00% 431019 - Security Services 52.48 1,785.31 - 1,785.31 7,103.00 5,317.69 74.87% Total Professional Services 5,385.77 159,646.93 23,293.82 182,940.75 245,497.00 62,556.25 25.48% Communication & Transportation 432000 - Other Communication/Transp. - 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing 185.15 1,891.16 - 1,891.16 5,375.00 3,483.84 64.82% 432003 - Travel - 2,005.14 - 2,005.14 24,700.00 22,694.86 91.88% 432004 - Telecommunications - 2,079.13 163.01 2,242.14 8,200.00 5,957.86 72.66% 432005 - Mileage Reimb - 875.16 186.26 1,061.42 6,522.00 5,460.58 83.73% Total Communication & Transportation 185.15 6,874.59 349.27 7,223.86 44,797.00 37,573.14 83.87% Printing & Advertising 433001 - Outside Printing Services - 5,547.07 490.00 6,037.07 32,229.00 26,191.93 81.27% 433002 - Publication of Legal Notice - 277.97 1,871.52 2,149.49 3,000.00 850.51 28.35% 433003 - Promotional 10,472.65 69,295.33 30,865.00 100,160.33 224,329.00 124,168.67 55.35% Total Printing & Advertising 10,472.65 75,120.37 33,226.52 108,346.89 259,558.00 151,211.11 58.26% Utilties 435001 - Electric 1,779.94 385,776.76 - 385,776.76 480,034.00 94,257.24 19.64% 435002 - Natural Gas 174.76 97,777.98 - 97,777.98 143,097.00 45,319.02 31.67% 435004 - Water 37,135.59 156,049.11 41,950.37 197,999.48 198,000.00 0.52 0.00% Total Utilities 39,090.29 639,603.85 41,950.37 681,554.22 821,131.00 139,576.78 17.00% Repairs & Maintenance 436000 - Other R&M 6,141.58 64,150.34 15,139.24 79,289.58 67,308.00 (11,981.58) (17.80%) 436001 - Building R&M 4,412.30 43,385.51 6,970.18 50,355.69 87,284.00 36,928.31 42.31% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 26,413.36 297,100.50 - 297,100.50 240,000.00 (57,100.50) (23.79%) 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,558.51 8,891.32 - 8,891.32 16,500.00 7,608.68 46.11% 436011 - Exterminating 532.50 2,742.50 3,658.50 6,401.00 7,500.00 1,099.00 14.65% Total Repairs & Maintenance 39,058.25 418,019.97 25,767.92 443,787.89 434,902.00 (8,885.89) (2.04%) 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 713.83 327,459.70 59,507.69 386,967.39 528,634.00 141,666.61 26.80% 438200 - Interest 25.21 33,747.26 5,485.62 39,232.88 47,472.00 8,239.12 17.36% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 4,400.00 - 0.00% Total Debt Service 739.04 365,606.96 64,993.31 430,600.27 580,506.00 149,905.73 25.82% Other Charges & Services 439000 - Misc Charges & Svcs 34,607.28 429,388.79 114,654.23 544,043.02 597,017.00 52,973.98 8.87% 439001 - Other Contractual Services 977.12 3,889.88 4,886.30 8,776.18 4,700.00 (4,076.18) (86.73%) 439003 - Subscriptions - 131.98 - 131.98 - (131.98) 0.00% 439004 - Dues & Memberships 72.95 3,039.08 - 3,039.08 5,210.00 2,170.92 41.67% 439005 - Bank & Credit Card Fees - 7,279.65 - 7,279.65 20,835.00 13,555.35 65.06% 439006 - Education & Training 6,622.81 29,015.16 - 29,015.16 34,685.00 5,669.84 16.35% 439009 - Trash Removal 574.47 9,561.84 - 9,561.84 31,449.00 21,887.16 69.60% 439100 - Refunds/Awards/Indemnities 1,255.49 19,881.74 10,220.03 30,101.77 47,933.00 17,831.23 37.20% 439300 - Grants & Subsidies 372.45 11,636.52 - 11,636.52 19,500.00 7,863.48 40.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 7,100.00 1,493.88 21.04% 44,482.57 1,234,430.76 129,760.56 1,364,191.32 1,483,429.00 119,237.68 8.04% Total Services & Charges Expenditures 139,413.72 2,899,957.33 320,766.77 3,220,724.10 3,871,970.00 651,245.90 16.82% 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 201,531.25 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 489,451.00 - 489,451.00 652,606.00 163,155.00 25.00% 452003 - Allocations-IT 40,874.00 367,866.00 - 367,866.00 490,488.00 122,622.00 25.00% 452004 - Allocations-Liability Insurance 15,093.00 135,831.00 - 135,831.00 181,110.00 45,279.00 25.00% 452008 - Allocations-Payroll Cost 6,579.00 59,210.00 - 59,210.00 78,947.00 19,737.00 25.00% 452009 - Allocations-Facilities Mgmt 1,505.00 13,554.00 - 13,554.00 18,069.00 4,515.00 24.99% Total Other Uses 118,436.00 1,065,912.00 - 1,065,912.00 1,421,220.00 355,308.00 25.00% Total Expenditures 1,027,690.87 11,013,137.83 506,194.77 11,519,332.60 15,294,612.00 3,775,279.40 24.68%