Loading...
HomeMy WebLinkAboutJuly 21 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 25,853.31 47,613.37 20,000.00 (27,613.37) 238.07% 347002 - Picnic Site Rental 791.48 4,391.05 3,300.00 (1,091.05) 133.06% 347010 - Concession Sales 13,069.26 35,640.22 31,000.00 (4,640.22) 114.97% 347011 - Recreational Programming 36,316.09 254,279.36 300,500.00 46,220.64 84.62% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway 17,679.60 27,515.15 55,000.00 27,484.85 50.03% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 6,965.33 39,521.58 9,000.00 (30,521.58) 439.13% 347030 - Merch Sales 141.12 940.31 2,500.00 1,559.69 37.61% 347040 - Pavilion Rental 3,196.36 25,035.48 22,446.00 (2,589.48) 111.54% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 104,012.55 601,651.31 743,746.00 142,094.69 80.89% Total Charges for Services 104,012.55 601,651.31 743,746.00 142,094.69 80.89% Miscellaneous Revenue 360000 - Miscellaneous - 100.00 - (100.00) 0.00% 362000 - Rental of Property - 47,078.75 60,000.00 12,921.25 78.46% Total Miscellaneous Revenue - 47,178.75 60,000.00 12,821.25 78.63% Refunds & Reimbursements 380000 - Misc Reimbursements 10,041.02 42,074.48 35,396.00 (6,678.48) 118.87% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 10,041.02 42,490.07 35,396.00 (7,094.07) 120.04% Total Revenue 114,053.57 691,320.13 839,142.00 147,821.87 82.38% 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 69,913.93 560,942.41 - 560,942.41 867,756.00 306,813.59 64.64% 410003 - Permanent Part Time 18,290.45 100,651.10 - 100,651.10 262,755.00 162,103.90 38.31% 410004 - Extra & Overtime 485.78 2,274.08 - 2,274.08 2,789.00 514.92 81.54% 410005 - Seasonal & Interns 94,975.66 237,711.43 - 237,711.43 479,240.00 241,528.57 49.60% Total Salaries & Wages 183,665.82 901,579.02 - 901,579.02 1,612,540.00 710,960.98 55.91% Employee Benefits 411001 - FICA Regular 13,731.48 66,606.56 - 66,606.56 123,561.00 56,954.44 53.91% 411004 - PERF Regular 7,667.43 58,949.02 - 58,949.02 97,792.00 38,842.98 60.28% 411007 - Unemployment Comp 22.08 172.53 - 172.53 261.00 88.47 66.10% 411008 - Health Insurance 18,791.60 132,609.57 - 132,609.57 197,377.00 64,767.43 67.19% 411009 - Life Insurance 180.00 1,270.00 - 1,270.00 2,040.00 770.00 62.25% 411014 - Parental Leave 244.77 1,963.67 - 1,963.67 3,047.00 1,083.33 64.45% 411206 - Cell Phone Allowance 165.00 1,155.00 - 1,155.00 2,640.00 1,485.00 43.75% Total Employee Benefits 40,802.36 262,726.35 - 262,726.35 426,718.00 163,991.65 61.57% Total Personnel Expenditures 224,468.18 1,164,305.37 - 1,164,305.37 2,039,258.00 874,952.63 57.09% Supplies Expenditures July 31, 2021 Office Supplies 421000 - Other Office Supplies 113.36 1,034.37 - 1,034.37 220.00 (814.37) 470.17% 421002 - Stationary & Printing 121.58 1,065.44 747.88 1,813.32 6,050.00 4,236.68 29.97% Total Office Supplies 234.94 2,099.81 747.88 2,847.69 6,270.00 3,422.31 45.42% Operating Supplies 422000 - Other Operating Supplies 841.71 17,223.04 4,968.15 22,191.19 33,340.62 11,149.43 66.56% 422005 - Uniforms 1,246.20 3,251.20 - 3,251.20 11,228.00 7,976.80 28.96% 422008 - Medical/Safety Supplies - 479.78 - 479.78 4,540.00 4,060.22 10.57% 422009 - Recreation Supplies 8,076.90 52,844.19 701.04 53,545.23 150,670.82 97,125.59 35.54% 422013 - Promotional Supplies - 443.34 - 443.34 - (443.34) 0.00% 422014 - Concessions Inventory 6,557.98 19,539.38 - 19,539.38 30,300.00 10,760.62 64.49% 422016 - Inventory For Sale - - - - 3,000.00 3,000.00 0.00% Total Operating Supplies 16,722.79 93,780.93 5,669.19 99,450.12 233,079.44 133,629.32 42.67% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 6,455.33 - 6,455.33 2,000.00 (4,455.33) 322.77% Total Repair & Maintenance Supplies - 6,455.33 - 6,455.33 2,000.00 (4,455.33) 322.77% Total Supplies Expenditures 16,957.73 102,336.07 6,417.07 108,753.14 241,349.44 132,596.30 45.06% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 10,553.95 34,716.02 4,745.00 39,461.02 79,569.00 40,107.98 49.59% Total Professional Services 10,553.95 34,716.02 4,745.00 39,461.02 79,569.00 40,107.98 49.59% Communication & Transportation 432002 - Mailing - 0.52 - 0.52 - (0.52) 0.00% 432003 - Travel 439.40 439.40 3,642.60 4,082.00 19,060.00 14,978.00 21.42% 432005 - Mileage Reimb - - - - 6,494.00 6,494.00 0.00% Total Communication & Transportation 439.40 439.92 3,642.60 4,082.52 25,554.00 21,471.48 15.98% Printing & Advertising 433001 - Outside Printing Services 86.00 3,429.10 - 3,429.10 21,106.00 17,676.90 16.25% 433003 - Promotional - - - - 9,550.00 9,550.00 0.00% Total Printing & Advertising 86.00 3,429.10 - 3,429.10 30,656.00 27,226.90 11.19% Repairs & Maintenance 436001 - Building R&M - 1,568.80 - 1,568.80 1,600.00 31.20 98.05% Total Repairs & Maintenance - 1,568.80 - 1,568.80 1,600.00 31.20 98.05% Rentals 437002 - Equipment Rental - - - - 1,200.00 1,200.00 0.00% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - - 700.00 700.00 700.00 - 100.00% Total Rentals - 12,000.00 700.00 12,700.00 13,900.00 1,200.00 91.37% Debt Service 438100 - Principal - 99,109.11 - 99,109.11 169,416.00 70,306.89 58.50% 438200 - Interest - 12,125.43 - 12,125.43 21,220.00 9,094.57 57.14% Total Debt Service - 111,234.54 - 111,234.54 190,636.00 79,401.46 58.35% Other Charges & Services 439000 - Misc Charges & Svcs 3,876.98 29,495.46 12,478.65 41,974.11 55,097.78 13,123.67 76.18% 439001 - Other Contractual Services 450.00 4,953.01 - 4,953.01 36,965.00 32,011.99 13.40% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 1,553.00 (259.74) 116.73% 439004 - Dues & Memberships 215.00 768.00 - 768.00 6,660.00 5,892.00 11.53% 439005 - Bank & Credit Card Fees 2,937.17 24,693.24 - 24,693.24 36,075.00 11,381.76 68.45% 439006 - Education & Training 1,061.60 1,061.60 1,190.00 2,251.60 12,703.00 10,451.40 17.72% 439009 - Trash Removal 850.78 850.78 79.26 930.04 2,400.00 1,469.96 38.75% 439099 - Cashier Over/Short (122.82) (118.02) - (118.02) - 118.02 0.00% 439100 - Refunds/Awards/Indemnities 3,719.22 12,139.48 - 12,139.48 27,313.00 15,173.52 44.45% 439999 - Bad Debt Expense 57.00 57.00 - 57.00 - (57.00) 0.00% Total Other Services & Charges 13,044.93 75,713.29 13,747.91 89,461.20 178,766.78 89,305.58 50.04% Total Services & Charges Expenditures 24,124.28 239,101.67 22,835.51 261,937.18 520,681.78 258,744.60 50.31% Other Uses 452002 - Allocations-Admin Cost 12,750.00 89,253.00 - 89,253.00 153,003.00 63,750.00 58.33% Total Other Uses 12,750.00 89,253.00 - 89,253.00 153,003.00 63,750.00 58.33% Total Expenditures 278,300.19 1,594,996.11 29,252.58 1,624,248.69 2,954,292.22 1,330,043.53 54.98%