Loading...
HomeMy WebLinkAboutSept 20 Fin 5South Bend Venues, Parks and Arts Recreation: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected 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% 347011 - Special Events 19,883.43 338,285.85 880,465.00 542,179.15 61.58% 347012 - Food Sales 1,213.63 12,137.89 42,000.00 29,862.11 71.10% 347013 - Nonalcoholic Beverage 776.56 7,725.25 38,000.00 30,274.75 79.67% 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% 347026 - Room Rental 300.00 300.00 - (300.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 (83.75) 208.71 - (208.71) 0.00% Total Culture & Recreation 29,231.93 580,036.89 1,227,765.00 647,728.11 52.76% Total Charges for Services 29,231.93 580,036.89 1,227,765.00 647,728.11 52.76% Miscellaneous Revenue 360000 - Miscellaneous 888.50 1,252.58 - (1,252.58) 0.00% 362000 - Rental of Property 1,477.01 18,717.25 60,000.00 41,282.75 68.80% Total Miscellaneous Revenue 2,365.51 19,969.83 60,000.00 40,030.17 66.72% Refunds & Reimbursements 380000 - Misc Reimbursements - 2,058.50 - (2,058.50) 0.00% 396000 - Refunds 144.00 144.00 - (144.00) 0.00% Total Refunds & Reimbursements 144.00 2,202.50 - (2,202.50) 0.00% Total Revenue 31,741.44 602,209.22 1,287,765.00 685,555.78 53.24% 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 82,746.17 767,357.96 - 767,357.96 1,021,711.00 254,353.04 24.89% 410003 - Permanent Part Time 23,737.40 243,768.46 - 243,768.46 264,112.00 20,343.54 7.70% 410004 - Extra & Overtime 1,131.51 2,834.34 - 2,834.34 3,000.00 165.66 5.52% 410005 - Seasonal & Interns 18,986.45 207,231.32 - 207,231.32 469,845.00 262,613.68 55.89% Total Salaries & Wages 126,601.53 1,221,192.08 - 1,221,192.08 1,758,668.00 537,475.92 30.56% Employee Benefits 411001 - FICA Regular 9,187.51 89,754.67 - 89,754.67 134,740.00 44,985.33 33.39% 411004 - PERF Regular 8,458.63 83,428.94 - 83,428.94 114,839.00 31,410.06 27.35% 411007 - Unemployment Comp 8.38 76.61 - 76.61 102.00 25.39 24.89% 411008 - Health Insurance 21,051.54 202,976.46 - 202,976.46 267,039.00 64,062.54 23.99% 411009 - Life Insurance 210.00 2,020.00 - 2,020.00 2,760.00 740.00 26.81% 411014 - Parental Leave 293.88 2,689.97 - 2,689.97 3,579.00 889.03 24.84% 411206 - Cell Phone Allowance 220.00 1,980.00 - 1,980.00 2,640.00 660.00 25.00% Total Employee Benefits 39,429.94 382,926.65 - 382,926.65 525,699.00 142,772.35 27.16% Total Personnel Expenditures 166,031.47 1,604,118.73 - 1,604,118.73 2,284,367.00 680,248.27 29.78% Supplies Expenditures Office Supplies September 30, 2020 421000 - Other Office Supplies 1.68 110.27 - 110.27 175.00 64.73 36.99% 421002 - Stationary & Printing 173.34 937.13 373.82 1,310.95 3,487.00 2,176.05 62.40% Total Office Supplies 175.02 1,047.40 373.82 1,421.22 3,662.00 2,240.78 61.19% Operating Supplies 422000 - Other Operating Supplies 4,705.77 49,458.02 9,516.08 58,974.10 82,405.00 23,430.90 28.43% 422005 - Uniforms - 3,931.35 - 3,931.35 10,785.00 6,853.65 63.55% 422007 - Cleaning Supplies 230.03 330.64 - 330.64 100.00 (230.64) (230.64%) 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 2,649.09 53,037.89 8,432.40 61,470.29 118,187.00 56,716.71 47.99% 422014 - Concessions Inventory 1,464.24 3,518.45 1,030.16 4,548.61 36,000.00 31,451.39 87.36% 422016 - Inventory For Sale 1,866.29 1,866.29 857.50 2,723.79 3,858.00 1,134.21 29.40% Total Operating Supplies 10,915.42 112,142.64 19,836.14 131,978.78 256,425.00 124,446.22 48.53% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 1,267.91 104.46 1,372.37 2,000.00 627.63 31.38% Total Repair & Maintenance Supplies - 1,267.91 104.46 1,372.37 2,000.00 627.63 31.38% Total Supplies Expenditures 11,090.44 114,457.95 20,314.42 134,772.37 262,087.00 127,314.63 48.58% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 199.47 14,019.83 - 14,019.83 54,742.00 40,722.17 74.39% 431009 - Computer & Technology - 362.37 - 362.37 400.00 37.63 9.41% Total Professional Services 199.47 14,382.20 - 14,382.20 55,142.00 40,759.80 73.92% Communication & Transportation 432003 - Travel - 45.20 - 45.20 17,400.00 17,354.80 99.74% 432005 - Mileage Reimb - 875.16 163.82 1,038.98 5,922.00 4,883.02 82.46% Total Communication & Transportation - 920.36 163.82 1,084.18 23,322.00 22,237.82 95.35% Printing & Advertising 433001 - Outside Printing Services - 270.00 - 270.00 21,106.00 20,836.00 98.72% 433003 - Promotional - 3.20 1,500.00 1,503.20 10,200.00 8,696.80 85.26% Total Printing & Advertising - 273.20 1,500.00 1,773.20 31,306.00 29,532.80 94.34% Repairs & Maintenance 436005 - Other Equip R&M - - - - 300.00 300.00 100.00% Total Repairs & Maintenance - - - - 300.00 300.00 100.00% Rentals 437006 - Recreation Space Rental - 500.00 700.00 1,200.00 1,200.00 - 0.00% Total Rentals - 500.00 700.00 1,200.00 1,200.00 - 0.00% Debt Service 438100 - Principal - 107,348.84 59,507.69 166,856.53 166,857.00 0.47 0.00% 438200 - Interest - 18,011.78 5,485.62 23,497.40 23,778.00 280.60 1.18% Total Debt Service - 125,360.62 64,993.31 190,353.93 190,635.00 281.07 0.15% Other Charges & Services 439000 - Misc Charges & Svcs 8,944.86 132,253.87 7,105.75 139,359.62 159,658.00 20,298.38 12.71% 439001 - Other Contractual Services 612.00 1,382.40 - 1,382.40 1,500.00 117.60 7.84% 439003 - Subscriptions - 2,118.00 - 2,118.00 3,000.00 882.00 29.40% 439004 - Dues & Memberships - 417.25 - 417.25 7,460.00 7,042.75 94.41% 439005 - Bank & Credit Card Fees 1,030.35 6,972.46 - 6,972.46 8,000.00 1,027.54 12.84% 439006 - Education & Training - 2,448.98 - 2,448.98 14,699.00 12,250.02 83.34% 439009 - Trash Removal - 153.04 1,196.96 1,350.00 2,300.00 950.00 41.30% 439100 - Refunds/Awards/Indemnities 127.40 8,306.82 - 8,306.82 15,000.00 6,693.18 44.62% 439999 - Bad Debt Expense - 5,606.12 - 5,606.12 7,100.00 1,493.88 21.04% Total Other Services & Charges 10,714.61 159,658.94 8,302.71 167,961.65 218,717.00 50,755.35 23.21% Total Services & Charges Expenditures 10,914.08 301,095.32 75,659.84 376,755.16 520,622.00 143,866.84 27.63% Other Uses 452002 - Allocations-Admin Cost 9,839.00 88,550.00 - 88,550.00 118,067.00 29,517.00 25.00% Total Other Uses 9,839.00 88,550.00 - 88,550.00 118,067.00 29,517.00 25.00% Total Expenditures 197,874.99 2,108,222.00 95,974.26 2,204,196.26 3,185,143.00 980,946.74 30.80%