Loading...
HomeMy WebLinkAboutOct 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 75.00 2,995.60 3,300.00 304.40 9.22% 347011 - Special Events 16,272.49 354,558.34 880,465.00 525,906.66 59.73% 347012 - Food Sales 984.60 13,122.49 42,000.00 28,877.51 68.76% 347013 - Nonalcoholic Beverage 528.23 8,253.48 38,000.00 29,746.52 78.28% 347016 - East Race Waterway - 53,028.70 50,000.00 (3,028.70) (6.06%) 347017 - Ice Skating 14,478.40 163,316.42 123,500.00 (39,816.42) (32.24%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347026 - Room Rental 2,620.04 2,920.04 - (2,920.04) 0.00% 347040 - Pavilion Rental 60.00 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% 347999 - Cash Over/Short (40.00) 168.71 - (168.71) 0.00% Total Culture & Recreation 34,978.76 615,015.65 1,227,765.00 612,749.35 49.91% Total Charges for Services 34,978.76 615,015.65 1,227,765.00 612,749.35 49.91% Miscellaneous Revenue 360000 - Miscellaneous 106.50 1,359.08 - (1,359.08) 0.00% 362000 - Rental of Property 53,537.99 72,255.24 60,000.00 (12,255.24) (20.43%) Total Miscellaneous Revenue 53,644.49 73,614.32 60,000.00 (13,614.32) (22.69%) Refunds & Reimbursements 380000 - Misc Reimbursements 727.50 2,786.00 - (2,786.00) 0.00% 396000 - Refunds - 144.00 - (144.00) 0.00% Total Refunds & Reimbursements 727.50 2,930.00 - (2,930.00) 0.00% Total Revenue 89,350.75 691,559.97 1,287,765.00 596,205.03 46.30% 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 112,320.69 879,678.65 - 879,678.65 1,041,711.00 162,032.35 15.55% 410003 - Permanent Part Time 32,030.93 275,799.39 - 275,799.39 324,112.00 48,312.61 14.91% 410004 - Extra & Overtime 155.16 2,989.50 - 2,989.50 3,500.00 510.50 14.59% 410005 - Seasonal & Interns 11,234.64 218,465.96 - 218,465.96 405,320.00 186,854.04 46.10% Total Salaries & Wages 155,741.42 1,376,933.50 - 1,376,933.50 1,774,643.00 397,709.50 22.41% Employee Benefits 411001 - FICA Regular 11,476.61 101,231.28 - 101,231.28 119,740.00 18,508.72 15.46% 411004 - PERF Regular 12,199.55 95,628.49 - 95,628.49 114,339.00 18,710.51 16.36% 411007 - Unemployment Comp 11.25 87.86 - 87.86 112.00 24.14 21.55% 411008 - Health Insurance 21,051.54 224,028.00 - 224,028.00 266,539.00 42,511.00 15.95% 411009 - Life Insurance 210.00 2,230.00 - 2,230.00 2,710.00 480.00 17.71% 411014 - Parental Leave 393.72 3,083.69 - 3,083.69 3,644.00 560.31 15.38% 411206 - Cell Phone Allowance 220.00 2,200.00 - 2,200.00 2,640.00 440.00 16.67% Total Employee Benefits 45,562.67 428,489.32 - 428,489.32 509,724.00 81,234.68 15.94% Total Personnel Expenditures 201,304.09 1,805,422.82 - 1,805,422.82 2,284,367.00 478,944.18 20.97% Supplies Expenditures Office Supplies October 31, 2020 421000 - Other Office Supplies 65.88 176.15 50.00 226.15 175.00 (51.15) (29.23%) 421002 - Stationary & Printing - 937.13 373.82 1,310.95 3,487.00 2,176.05 62.40% Total Office Supplies 65.88 1,113.28 423.82 1,537.10 3,662.00 2,124.90 58.03% Operating Supplies 422000 - Other Operating Supplies 1,251.97 50,709.99 10,378.81 61,088.80 82,405.00 21,316.20 25.87% 422005 - Uniforms 82.75 4,014.10 - 4,014.10 10,785.00 6,770.90 62.78% 422007 - Cleaning Supplies 271.12 601.76 - 601.76 100.00 (501.76) (501.76%) 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 9,068.18 62,106.07 7,706.40 69,812.47 118,187.00 48,374.53 40.93% 422013 - Promotional Supplies 873.19 873.19 - 873.19 - (873.19) 0.00% 422014 - Concessions Inventory 1,030.16 4,548.61 - 4,548.61 36,000.00 31,451.39 87.36% 422016 - Inventory For Sale (24.92) 1,841.37 857.50 2,698.87 3,858.00 1,159.13 30.04% Total Operating Supplies 12,552.45 124,695.09 18,942.71 143,637.80 256,425.00 112,787.20 43.98% 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 12,618.33 127,076.28 19,470.99 146,547.27 262,087.00 115,539.73 44.08% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 419.13 14,458.49 - 14,458.49 54,742.00 40,283.51 73.59% 431009 - Computer & Technology - 362.37 - 362.37 400.00 37.63 9.41% Total Professional Services 419.13 14,820.86 - 14,820.86 55,142.00 40,321.14 73.12% Communication & Transportation 432003 - Travel - 45.20 - 45.20 17,400.00 17,354.80 99.74% 432005 - Mileage Reimb 163.82 1,038.98 - 1,038.98 5,922.00 4,883.02 82.46% Total Communication & Transportation 163.82 1,084.18 - 1,084.18 23,322.00 22,237.82 95.35% Printing & Advertising 433001 - Outside Printing Services 482.99 752.99 - 752.99 21,106.00 20,353.01 96.43% 433003 - Promotional - 3.20 1,500.00 1,503.20 10,200.00 8,696.80 85.26% Total Printing & Advertising 482.99 756.19 1,500.00 2,256.19 31,306.00 29,049.81 92.79% 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 5,916.85 138,170.72 4,290.90 142,461.62 159,658.00 17,196.38 10.77% 439001 - Other Contractual Services 428.46 1,810.86 - 1,810.86 1,500.00 (310.86) (20.72%) 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 836.61 7,877.42 - 7,877.42 8,000.00 122.58 1.53% 439006 - Education & Training - 2,448.98 - 2,448.98 14,699.00 12,250.02 83.34% 439009 - Trash Removal 1,158.20 1,311.24 38.76 1,350.00 2,300.00 950.00 41.30% 439100 - Refunds/Awards/Indemnities 112.00 8,468.82 - 8,468.82 15,000.00 6,531.18 43.54% 439999 - Bad Debt Expense - 5,606.12 - 5,606.12 7,100.00 1,493.88 21.04% Total Other Services & Charges 8,452.12 168,229.41 4,329.66 172,559.07 218,717.00 46,157.93 21.10% Total Services & Charges Expenditures 9,518.06 310,751.26 71,522.97 382,274.23 520,622.00 138,347.77 26.57% Other Uses 452002 - Allocations-Admin Cost 9,839.00 98,389.00 - 98,389.00 118,067.00 19,678.00 16.67% Total Other Uses 9,839.00 98,389.00 - 98,389.00 118,067.00 19,678.00 16.67% Total Expenditures 233,279.48 2,341,639.36 90,993.96 2,432,633.32 3,185,143.00 752,509.68 23.63%