Loading...
HomeMy WebLinkAboutAug 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 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% 347011 - Special Events 30,381.91 319,864.42 880,465.00 560,600.58 63.67% 347012 - Food Sales 4,364.44 10,924.26 42,000.00 31,075.74 73.99% 347013 - Nonalcoholic Beverage 2,481.29 6,949.62 38,000.00 31,050.38 81.71% 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% 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 95.51 292.46 - (292.46) 0.00% Total Culture & Recreation 62,438.24 552,267.89 1,227,765.00 675,497.11 55.02% Total Charges for Services 62,438.24 552,267.89 1,227,765.00 675,497.11 55.02% Miscellaneous Revenue 360000 - Miscellaneous 30.00 364.08 - (364.08) 0.00% 362000 - Rental of Property 542.99 17,240.24 60,000.00 42,759.76 71.27% Total Miscellaneous Revenue 572.99 17,604.32 60,000.00 42,395.68 70.66% Refunds & Reimbursements 380000 - Misc Reimbursements 1,158.00 2,058.50 - (2,058.50) 0.00% Total Refunds & Reimbursements 1,158.00 2,058.50 - (2,058.50) 0.00% Total Revenue 64,169.23 571,930.71 1,287,765.00 715,834.29 55.59% 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 88,915.79 684,611.79 - 684,611.79 1,021,711.00 337,099.21 32.99% 410003 - Permanent Part Time 26,632.97 220,031.06 - 220,031.06 234,112.00 14,080.94 6.01% 410004 - Extra & Overtime 607.68 1,702.83 - 1,702.83 3,000.00 1,297.17 43.24% 410005 - Seasonal & Interns 73,529.44 188,244.87 - 188,244.87 499,845.00 311,600.13 62.34% Total Salaries & Wages 189,685.88 1,094,590.55 - 1,094,590.55 1,758,668.00 664,077.45 37.76% Employee Benefits 411001 - FICA Regular 14,079.79 80,567.16 - 80,567.16 134,740.00 54,172.84 40.21% 411004 - PERF Regular 8,872.82 74,970.31 - 74,970.31 114,839.00 39,868.69 34.72% 411007 - Unemployment Comp 8.86 68.23 - 68.23 102.00 33.77 33.11% 411008 - Health Insurance 23,027.94 181,924.92 - 181,924.92 267,039.00 85,114.08 31.87% 411009 - Life Insurance 220.00 1,810.00 - 1,810.00 2,760.00 950.00 34.42% 411014 - Parental Leave 311.22 2,396.09 - 2,396.09 3,579.00 1,182.91 33.05% 411206 - Cell Phone Allowance 220.00 1,760.00 - 1,760.00 2,640.00 880.00 33.33% Total Employee Benefits 46,740.63 343,496.71 - 343,496.71 525,699.00 182,202.29 34.66% Total Personnel Expenditures 236,426.51 1,438,087.26 - 1,438,087.26 2,284,367.00 846,279.74 37.05% Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 108.59 - 108.59 175.00 66.41 37.95% 421002 - Stationary & Printing - 763.79 433.80 1,197.59 3,487.00 2,289.41 65.66% August 31, 2020 Total Office Supplies - 872.38 433.80 1,306.18 3,662.00 2,355.82 64.33% Operating Supplies 422000 - Other Operating Supplies 8,974.38 44,165.73 10,878.07 55,043.80 82,505.00 27,461.20 33.28% 422005 - Uniforms 2,834.34 3,931.35 - 3,931.35 10,785.00 6,853.65 63.55% 422007 - Cleaning Supplies 63.28 100.61 - 100.61 - (100.61) 0.00% 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 983.42 50,388.80 7,152.00 57,540.80 118,187.00 60,646.20 51.31% 422014 - Concessions Inventory 776.48 2,054.21 1,216.64 3,270.85 36,000.00 32,729.15 90.91% 422016 - Inventory For Sale - - 857.50 857.50 3,858.00 3,000.50 77.77% Total Operating Supplies 13,631.90 100,640.70 20,104.21 120,744.91 256,425.00 135,680.09 52.91% 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 13,631.90 102,780.99 20,642.47 123,423.46 262,087.00 138,663.54 52.91% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 327.77 13,820.36 199.47 14,019.83 84,742.00 70,722.17 83.46% 431009 - Computer & Technology 90.00 362.37 - 362.37 200.00 (162.37) (81.19%) Total Professional Services 417.77 14,182.73 199.47 14,382.20 84,942.00 70,559.80 83.07% Communication & Transportation 432003 - Travel - 45.20 - 45.20 17,400.00 17,354.80 99.74% 432005 - Mileage Reimb 780.28 875.16 - 875.16 5,922.00 5,046.84 85.22% Total Communication & Transportation 780.28 920.36 - 920.36 23,322.00 22,401.64 96.05% 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 20,639.95 122,761.16 7,667.07 130,428.23 134,658.00 4,229.77 3.14% 439001 - Other Contractual Services - 770.40 - 770.40 500.00 (270.40) (54.08%) 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,580.20 5,852.14 - 5,852.14 8,000.00 2,147.86 26.85% 439006 - Education & Training - 2,448.98 - 2,448.98 14,699.00 12,250.02 83.34% 439009 - Trash Removal 38.26 153.04 116.96 270.00 500.00 230.00 46.00% 439100 - Refunds/Awards/Indemnities 478.96 8,179.42 - 8,179.42 15,000.00 6,820.58 45.47% 439999 - Bad Debt Expense - 5,606.12 - 5,606.12 5,100.00 (506.12) (9.92%) Total Other Services & Charges 22,737.37 148,306.51 7,784.03 156,090.54 188,917.00 32,826.46 17.38% Total Services & Charges Expenditures 23,935.42 289,543.42 75,176.81 364,720.23 520,622.00 155,901.77 29.95% Other Uses 452002 - Allocations-Admin Cost 9,839.00 78,711.00 - 78,711.00 118,067.00 39,356.00 33.33% Total Other Uses 9,839.00 78,711.00 - 78,711.00 118,067.00 39,356.00 33.33% Total Expenditures 283,832.83 1,909,122.67 95,819.28 2,004,941.95 3,185,143.00 1,180,201.05 37.05%