Loading...
HomeMy WebLinkAboutMay 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 - - 46,000.00 46,000.00 100.00% 347002 - Picnic Site Rental - 210.00 3,300.00 3,090.00 93.64% 347011 - Special Events 1,700.00 222,489.99 880,465.00 657,975.01 74.73% 347012 - Food Sales - 81.92 42,000.00 41,918.08 99.80% 347013 - Nonalcoholic Beverage - 400.83 38,000.00 37,599.17 98.95% 347016 - East Race Waterway - - 50,000.00 50,000.00 100.00% 347017 - Ice Skating 90.00 148,838.02 123,500.00 (25,338.02) (20.52%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347040 - Pavilion Rental - 170.00 17,500.00 17,330.00 99.03% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short - 181.49 - (181.49) 0.00% Total Culture & Recreation 1,790.00 413,732.28 1,227,765.00 814,032.72 66.30% Total Charges for Services 1,790.00 413,732.28 1,227,765.00 814,032.72 66.30% Miscellaneous Revenue 360000 - Miscellaneous 84.08 334.08 - (334.08) 0.00% 362000 - Rental of Property - 16,247.25 60,000.00 43,752.75 72.92% Total Miscellaneous Revenue 84.08 16,581.33 60,000.00 43,418.67 72.36% Refunds & Reimbursements 380000 - Misc Reimbursements 900.50 900.50 - (900.50) 0.00% Total Refunds & Reimbursements 900.50 900.50 - (900.50) 0.00% Total Revenue 2,774.58 431,214.11 1,287,765.00 856,550.89 66.51% EXPENDITURES Current YTD Total YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 39,889.94 436,109.42 - 436,109.42 1,021,711.00 585,601.58 57.32% 410003 - Permanent Part Time 2,008.56 152,684.05 - 152,684.05 234,112.00 81,427.95 34.78% 410004 - Extra & Overtime 40.13 56.25 - 56.25 1,000.00 943.75 94.38% 410005 - Seasonal & Interns 6,288.09 25,437.81 - 25,437.81 501,845.00 476,407.19 94.93% Total Salaries & Wages 48,226.72 614,287.53 - 614,287.53 1,758,668.00 1,144,380.47 65.07% Employee Benefits 411001 - FICA Regular 3,502.80 45,084.05 - 45,084.05 134,740.00 89,655.95 66.54% 411004 - PERF Regular 4,415.74 48,382.23 - 48,382.23 114,839.00 66,456.77 57.87% 411007 - Unemployment Comp 4.00 43.46 - 43.46 102.00 58.54 57.39% 411008 - Health Insurance 11,534.97 112,757.10 - 112,757.10 267,039.00 154,281.90 57.78% 411009 - Life Insurance 115.00 1,130.00 - 1,130.00 2,760.00 1,630.00 59.06% 411014 - Parental Leave 139.60 1,526.36 - 1,526.36 3,579.00 2,052.64 57.35% 411206 - Cell Phone Allowance - 1,100.00 - 1,100.00 2,640.00 1,540.00 58.33% Total Employee Benefits 19,712.11 210,023.20 - 210,023.20 525,699.00 315,675.80 60.05% Total Personnel Expenditures 67,938.83 824,310.73 - 824,310.73 2,284,367.00 1,460,056.27 63.92% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 54.09 - - - - - 0.00% 421002 - Stationary & Printing - 704.79 373.82 1,078.61 3,587.00 2,508.39 69.93% May 31, 2020 Total Office Supplies 54.09 704.79 373.82 1,078.61 3,587.00 2,508.39 69.93% Operating Supplies 422000 - Other Operating Supplies 2,408.75 21,239.75 1,684.21 22,923.96 82,505.00 59,581.04 72.22% 422005 - Uniforms - 550.00 - 550.00 10,860.00 10,310.00 94.94% 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 5,335.14 32,409.30 13,030.80 45,440.10 118,187.00 72,746.90 61.55% 422014 - Concessions Inventory - 938.35 - 938.35 36,000.00 35,061.65 97.39% 422016 - Inventory For Sale - - 857.50 857.50 3,858.00 3,000.50 77.77% Total Operating Supplies 7,743.89 55,137.40 15,572.51 70,709.91 256,500.00 185,790.09 72.43% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,087.08 180.83 1,058.08 1,238.91 2,000.00 761.09 38.05% Total Repair & Maintenance Supplies 1,087.08 180.83 1,058.08 1,238.91 2,000.00 761.09 38.05% Total Supplies Expenditures 8,885.06 56,023.02 17,004.41 73,027.43 262,087.00 189,059.57 72.14% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,451.00 10,234.07 - 10,234.07 113,842.00 103,607.93 91.01% 431009 - Computer & Technology 13.50 78.87 - 78.87 - (78.87) 0.00% Total Professional Services 2,464.50 10,312.94 - 10,312.94 113,842.00 103,529.06 90.94% Communication & Transportation 432003 - Travel - 45.20 - 45.20 18,000.00 17,954.80 99.75% 432005 - Mileage Reimb - 94.88 - 94.88 5,922.00 5,827.12 98.40% Total Communication & Transportation - 140.08 - 140.08 23,922.00 23,781.92 99.41% Printing & Advertising 433001 - Outside Printing Services - 270.00 - 270.00 21,106.00 20,836.00 98.72% 433003 - Promotional - - 1,500.00 1,500.00 10,200.00 8,700.00 85.29% Total Printing & Advertising - 270.00 1,500.00 1,770.00 31,306.00 29,536.00 94.35% 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 100.00 400.00 - 400.00 1,200.00 800.00 66.67% Total Rentals 100.00 400.00 - 400.00 1,200.00 800.00 66.67% 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 19,195.54 69,988.15 664.00 70,652.15 110,158.00 39,505.85 35.86% 439003 - Subscriptions - 2,118.00 - 2,118.00 - (2,118.00) 0.00% 439004 - Dues & Memberships - 417.25 - 417.25 7,460.00 7,042.75 94.41% 439005 - Bank & Credit Card Fees - 3,606.47 - 3,606.47 8,000.00 4,393.53 54.92% 439006 - Education & Training - 2,448.98 - 2,448.98 14,699.00 12,250.02 83.34% 439100 - Refunds/Awards/Indemnities 1,683.40 5,657.06 - 5,657.06 15,000.00 9,342.94 62.29% 439999 - Bad Debt Expense - 4,637.12 - 4,637.12 4,100.00 (537.12) (13.10%) Total Other Services & Charges 23,443.44 225,356.67 67,157.31 292,513.98 520,622.00 228,108.02 43.81% Total Services & Charges Expenditures 23,443.44 225,356.67 67,157.31 292,513.98 520,622.00 228,108.02 43.81% Other Uses 452002 - Allocations-Admin Cost 9,839.00 49,194.00 - 49,194.00 118,067.00 68,873.00 58.33% Total Other Uses 9,839.00 59,033.00 - 59,033.00 118,067.00 59,034.00 50.00% Total Expenditures 110,106.33 1,154,884.42 84,161.72 1,239,046.14 3,185,143.00 1,946,096.86 61.10%