Loading...
HomeMy WebLinkAboutNov 20 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 92% 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 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 - 2,995.60 3,300.00 304.40 9.22% 347003 - Golf Season Pass - 162,676.20 165,000.00 2,323.80 1.41% 347004 - Golf Green Fees 31,628.50 794,697.01 550,000.00 (244,697.01) (44.49%) 347005 - Golf Cart Rentals 15,756.31 357,119.62 330,000.00 (27,119.62) (8.22%) 347006 - Golf Pro Shop Retail 2,165.88 52,734.07 60,000.00 7,265.93 12.11% 347007 - Golf Driving Range 773.00 31,874.18 30,530.00 (1,344.18) (4.40%) 347008 - Golf Gift Certificate (39.74) 517.53 260.00 (257.53) (99.05%) 347011 - Special Events 6,865.15 386,719.68 941,465.00 554,745.32 58.92% 347012 - Food Sales 3,598.37 62,590.79 102,000.00 39,409.21 38.64% 347013 - Nonalcoholic Beverage 1,959.99 39,603.10 68,000.00 28,396.90 41.76% 347014 - Alcoholic Beverage Sales 4,295.72 108,683.60 90,000.00 (18,683.60) (20.76%) 347015 - Lease of Stadium - 45,000.00 75,000.00 30,000.00 40.00% 347016 - East Race Waterway 701.72 53,730.42 50,000.00 (3,730.42) (7.46%) 347017 - Ice Skating 14,764.70 178,081.12 123,500.00 (54,581.12) (44.20%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347019 - Site Mowing 9,331.20 118,310.40 95,000.00 (23,310.40) (24.54%) 347021 - Tree Maintenance 708.49 152,006.13 160,000.00 7,993.87 5.00% 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,726.36 5,646.40 - (5,646.40) 0.00% 347030 - Merch Sales 34.67 34.67 - (34.67) 0.00% 347040 - Pavilion Rental - 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% 347050 - Ice Rink Gift Cards 5,125.90 5,125.90 - (5,125.90) 0.00% 347999 - Cash Over/Short (0.28) 784.02 - (784.02) 0.00% Total Culture & Recreation 100,395.94 2,579,582.31 3,037,084.00 457,501.69 15.06% Total Charges for Services 100,395.94 2,579,582.31 3,037,084.00 457,501.69 15.06% Miscellaneous Revenue 360000 - Miscellaneous 64.22 15,429.63 26,270.00 10,840.37 41.27% 361000 - Interest Earnings 272.17 7,066.34 37,250.00 30,183.66 81.03% 362000 - Rental of Property - 72,255.24 60,000.00 (12,255.24) (20.43%) 367000 - Donations from Private Sources 749.00 1,025,499.00 1,290,000.00 264,501.00 20.50% Total Miscellaneous Revenue 1,085.39 1,120,250.21 1,413,520.00 293,269.79 20.75% November 30, 2020 Refunds & Reimbursements 380000 - Misc Reimbursements 1,755.00 10,937.37 45,899.00 34,961.63 76.17% 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 1,755.00 15,885.41 50,703.00 34,817.59 68.67% Other Sources 391000 - Interfund Transfers In 66,667.00 733,333.00 800,000.00 66,667.00 8.33% 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 746,765.00 813,432.00 66,667.00 8.20% Total Revenue 169,903.33 10,797,005.21 16,473,634.00 5,676,628.79 34.46% 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 223,141.01 2,803,740.84 - 2,803,740.84 3,067,175.00 263,434.16 8.59% 410002 - Teamster Wages 114,917.89 1,356,171.80 - 1,356,171.80 1,423,153.00 66,981.20 4.71% 410003 - Permanent Part Time 59,297.90 859,421.03 - 859,421.03 872,676.00 13,254.97 1.52% 410004 - Extra & Overtime 3,642.16 65,702.68 - 65,702.68 79,490.00 13,787.32 17.34% 410005 - Seasonal & Interns 26,079.35 507,376.76 - 507,376.76 682,140.00 174,763.24 25.62% 410007 - Longevity Pay 350.00 7,450.00 - 7,450.00 8,050.00 600.00 7.45% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 427,428.31 5,599,863.11 - 5,599,863.11 6,133,884.00 534,020.89 8.71% Employee Benefits 411001 - FICA Regular 31,336.42 415,497.65 - 415,497.65 464,022.00 48,524.35 10.46% 411004 - PERF Regular 36,833.72 463,741.05 - 463,741.05 528,858.00 65,116.95 12.31% 411005 - PERF Union 1,402.48 17,245.07 - 17,245.07 22,652.00 5,406.93 23.87% 411007 - Unemployment Comp 34.22 423.10 - 423.10 531.00 107.90 20.32% 411008 - Health Insurance 91,027.57 1,007,504.32 - 1,007,504.32 1,117,598.00 110,093.68 9.85% 411009 - Life Insurance 905.04 10,195.44 - 10,195.44 11,320.00 1,124.56 9.93% 411014 - Parental Leave 1,195.93 14,789.63 - 14,789.63 16,128.00 1,338.37 8.30% 411200 - Clothing Allowance - 123.04 - 123.04 200.00 76.96 38.48% 411201 - Tool Allowance 1,591.07 3,876.79 827.61 4,704.40 5,028.00 323.60 6.44% 411203 - Job Readiness Allow. - 14,768.75 - 14,768.75 15,300.00 531.25 3.47% 411204 - Auto Allowance 266.66 2,933.26 - 2,933.26 3,200.00 266.74 8.34% 411206 - Cell Phone Allowance 1,265.00 14,960.00 - 14,960.00 16,995.00 2,035.00 11.97% Total Employee Benefits 165,858.11 1,966,058.10 827.61 1,966,885.71 2,201,832.00 234,946.29 10.67% Total Personnel Expenditures 593,286.42 7,565,921.21 827.61 7,566,748.82 8,335,716.00 768,967.18 9.22% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 927.65 2,686.73 123.89 2,810.62 1,855.00 (955.62) (51.52%) 421002 - Stationary & Printing 625.19 5,629.20 3,599.43 9,228.63 21,687.00 12,458.37 57.45% Total Office Supplies 1,552.84 8,315.93 3,723.32 12,039.25 23,542.00 11,502.75 48.86% Operating Supplies 422000 - Other Operating Supplies 27,765.03 285,128.32 50,739.50 335,867.82 345,911.00 10,043.18 2.90% 422001 - C.S. Gasoline 8,468.20 107,445.52 - 107,445.52 168,900.00 61,454.48 36.39% 422002 - Diesel/CNG - 3,142.40 - 3,142.40 3,510.00 367.60 10.47% 422003 - Gasoline - 11,934.72 503.00 12,437.72 17,201.00 4,763.28 27.69% 422004 - Oil - 957.85 - 957.85 1,000.00 42.15 4.22% 422005 - Uniforms 280.90 18,229.45 991.50 19,220.95 36,930.00 17,709.05 47.95% 422006 - Computer Supplies & Equipment - 227.55 - 227.55 100.00 (127.55) (127.55%) 422007 - Cleaning Supplies 185.76 980.80 - 980.80 200.00 (780.80) (390.40%) 422008 - Medical/Safety Supplies 1,061.99 7,096.40 113.84 7,210.24 11,663.00 4,452.76 38.18% 422009 - Recreation Supplies 6,670.89 140,801.99 12,220.07 153,022.06 270,467.00 117,444.94 43.42% 422010 - Plants Chemicals Seed & Fertilizer 14,958.80 140,180.65 5,426.54 145,607.19 162,745.00 17,137.81 10.53% 422013 - Promotional Supplies 267.49 1,805.48 - 1,805.48 610.00 (1,195.48) (195.98%) 422014 - Concessions Inventory 6,670.66 78,729.15 8,865.12 87,594.27 120,940.00 33,345.73 27.57% 422016 - Inventory For Sale 2,274.57 35,893.20 857.50 36,750.70 37,858.00 1,107.30 2.92% Total Operating Supplies 68,604.29 832,553.48 79,717.07 912,270.55 1,178,035.00 265,764.45 22.56% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,253.52 91,038.77 70,485.96 161,524.73 198,763.00 37,238.27 18.74% 423001 - Building Materials 2,939.36 59,040.63 4,958.78 63,999.41 90,368.00 26,368.59 29.18% 423006 - Small Tools & Equipment 2,389.04 19,333.06 1,075.86 20,408.92 30,053.00 9,644.08 32.09% 423009 - Repair Parts 6,383.62 59,259.60 6,793.47 66,053.07 72,839.00 6,785.93 9.32% Total Repair & Maintenance Supplies 13,965.54 228,672.06 83,314.07 311,986.13 392,023.00 80,036.87 20.42% Total Supplies Expenditures 84,122.67 1,069,541.47 166,754.46 1,236,295.93 1,593,600.00 357,304.07 22.42% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 18,058.21 176,705.11 29,148.67 205,853.78 240,714.00 34,860.22 14.48% 431009 - Computer & Technology - 824.29 - 824.29 1,000.00 175.71 17.57% 431014 - Collection Costs - 75.00 50.50 125.50 500.00 374.50 74.90% 431019 - Security Services 505.46 3,521.84 - 3,521.84 7,303.00 3,781.16 51.78% Total Professional Services 18,563.67 181,126.24 29,199.17 210,325.41 249,517.00 39,191.59 15.71% Communication & Transportation 432000 - Other Communication/Transp. - 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing - 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 60.92 2,157.62 84.52 2,242.14 8,200.00 5,957.86 72.66% 432005 - Mileage Reimb 184.00 1,245.42 - 1,245.42 6,522.00 5,276.58 80.90% Total Communication & Transportation 244.92 7,323.86 84.52 7,408.38 44,797.00 37,388.62 83.46% Printing & Advertising 433001 - Outside Printing Services 173.00 9,039.56 560.50 9,600.06 32,229.00 22,628.94 70.21% 433002 - Publication of Legal Notice 56.32 334.29 1,990.04 2,324.33 3,000.00 675.67 22.52% 433003 - Promotional 7,503.74 83,761.52 30,355.30 114,116.82 224,329.00 110,212.18 49.13% Total Printing & Advertising 7,733.06 93,135.37 32,905.84 126,041.21 259,558.00 133,516.79 51.44% Utilties 435001 - Electric 26,586.01 432,219.95 - 432,219.95 480,034.00 47,814.05 9.96% 435002 - Natural Gas 5,475.49 103,653.77 - 103,653.77 143,097.00 39,443.23 27.56% 435004 - Water 17,773.21 205,485.19 (66,542.65) 138,942.54 198,000.00 59,057.46 29.83% Total Utilities 49,834.71 741,358.91 (66,542.65) 674,816.26 821,131.00 146,314.74 17.82% Repairs & Maintenance 436000 - Other R&M 16,801.80 80,952.14 26,358.24 107,310.38 67,308.00 (40,002.38) (59.43%) 436001 - Building R&M 1,816.64 49,768.59 3,462.74 53,231.33 87,284.00 34,052.67 39.01% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 14,707.20 341,837.19 356.00 342,193.19 240,000.00 (102,193.19) (42.58%) 436005 - Other Equip R&M - 1,749.80 - 1,749.80 7,810.00 6,060.20 77.60% 436006 - Radio Equip R&M 2,547.85 13,417.91 1,996.00 15,413.91 16,500.00 1,086.09 6.58% 436011 - Exterminating 572.50 3,847.50 2,553.50 6,401.00 7,500.00 1,099.00 14.65% Total Repairs & Maintenance 36,445.99 491,573.13 34,726.48 526,299.61 434,902.00 (91,397.61) (21.02%) Rentals 437002 - Equipment Rental 965.00 1,118.90 725.00 1,843.90 1,933.00 89.10 4.61% 437006 - Recreation Space Rental - 500.00 700.00 1,200.00 1,200.00 - 0.00% Total Rentals 965.00 1,618.90 1,425.00 3,043.90 3,133.00 89.10 2.84% Debt Service 438100 - Principal 59,802.09 492,088.07 - 492,088.07 528,634.00 36,545.93 6.91% 438200 - Interest 5,258.46 41,359.13 - 41,359.13 47,472.00 6,112.87 12.88% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 4,400.00 - 0.00% Total Debt Service 65,060.55 537,847.20 - 537,847.20 580,506.00 42,658.80 7.35% Other Charges & Services 439000 - Misc Charges & Svcs 57,172.17 519,016.59 94,827.04 613,843.63 588,414.00 (25,429.63) (4.32%) 439001 - Other Contractual Services 1,162.19 5,347.78 4,124.26 9,472.04 4,700.00 (4,772.04) (101.53%) 439003 - Subscriptions - 131.98 - 131.98 - (131.98) 0.00% 439004 - Dues & Memberships 12.95 3,064.98 - 3,064.98 5,210.00 2,145.02 41.17% 439005 - Bank & Credit Card Fees 358.00 8,242.65 - 8,242.65 20,835.00 12,592.35 60.44% 439006 - Education & Training 3,398.19 37,580.74 - 37,580.74 38,185.00 604.26 1.58% 439009 - Trash Removal 1,001.00 11,167.31 1,100.00 12,267.31 31,549.00 19,281.69 61.12% 439100 - Refunds/Awards/Indemnities 589.56 23,679.07 7,747.41 31,426.48 47,933.00 16,506.52 34.44% 439300 - Grants & Subsidies 1,004.67 13,202.39 - 13,202.39 19,500.00 6,297.61 32.30% 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% 64,698.73 1,342,039.61 107,798.71 1,449,838.32 1,478,426.00 28,587.68 1.93% Total Services & Charges Expenditures 243,546.63 3,396,023.22 139,597.07 3,535,620.29 3,871,970.00 336,349.71 8.69% 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 1,500.00 956,545.39 74,543.25 1,031,088.64 1,200,895.00 169,806.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 598,221.00 - 598,221.00 652,606.00 54,385.00 8.33% 452003 - Allocations-IT 40,874.00 449,614.00 - 449,614.00 490,488.00 40,874.00 8.33% 452004 - Allocations-Liability Insurance 15,093.00 166,017.00 - 166,017.00 181,110.00 15,093.00 8.33% 452008 - Allocations-Payroll Cost 6,579.00 72,368.00 - 72,368.00 78,947.00 6,579.00 8.33% 452009 - Allocations-Facilities Mgmt 1,505.00 16,564.00 - 16,564.00 18,069.00 1,505.00 8.33% Total Other Uses 118,436.00 1,302,784.00 - 1,302,784.00 1,421,220.00 118,436.00 8.33% Total Expenditures 1,039,391.72 13,406,375.69 307,179.14 13,713,554.83 15,294,612.00 1,581,057.17 10.34%