Loading...
HomeMy WebLinkAboutOct 22 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 - 35,588.78 40,213.00 4,624.22 88.50% 347002 - Picnic Site Rental 33.68 3,596.25 - (3,596.25) 0.00% 347010 - Concession Sales 2,060.08 52,704.70 59,000.00 6,295.30 89.33% 347011 - Recreational Programming 23,834.05 343,225.56 465,565.00 122,339.44 73.72% 347016 - East Race Waterway - 57,503.17 60,000.00 2,496.83 95.84% 347017 - Ice Skating 1,837.50 213,409.38 300,000.00 86,590.62 71.14% 347026 - Room Rental 4,111.88 45,960.74 26,000.00 (19,960.74) 176.77% 347030 - Merch Sales 263.42 3,121.57 - (3,121.57) 0.00% 347040 - Pavilion Rental 716.80 31,910.63 15,000.00 (16,910.63) 212.74% Total Culture & Recreation 32,857.41 787,020.78 965,778.00 178,757.22 81.49% Total Charges for Services 32,857.41 787,020.78 965,778.00 178,757.22 81.49% Miscellaneous Revenue 362000 - Rental of Property 5,915.75 61,503.25 60,000.00 (1,503.25) 102.51% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 5,915.75 84,731.91 60,000.00 (24,731.91) 141.22% Refunds & Reimbursements 380000 - Misc Reimbursements 245.04 3,339.36 3,527.00 187.64 94.68% 396000 - Refunds 897.50 945.38 - (945.38) 0.00% Total Refunds & Reimbursements 1,142.54 4,284.74 3,527.00 (757.74) 121.48% Total Revenue 39,915.70 876,037.43 1,029,305.00 153,267.57 85.11% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 67,776.12 435,824.25 - 435,824.25 385,392.00 (50,432.25) 113.09% 410002 - Teamster Wages - 70,190.17 - 70,190.17 110,309.00 40,118.83 63.63% 410003 - Permanent Part Time 21,004.58 117,832.39 - 117,832.39 232,406.00 114,573.61 50.70% 410004 - Extra & Overtime 454.46 15,195.47 - 15,195.47 16,000.00 804.53 94.97% 410005 - Seasonal & Interns 8,141.89 331,974.63 - 331,974.63 437,105.00 105,130.37 75.95% 410007 - Longevity Pay - 150.00 - 150.00 200.00 50.00 75.00% Total Salaries & Wages 97,377.05 971,166.91 - 971,166.91 1,181,412.00 210,245.09 82.20% Employee Benefits 411001 - FICA Regular 7,147.19 74,235.14 - 74,235.14 90,824.00 16,588.86 81.74% 411004 - PERF Regular 7,485.60 59,256.85 - 59,256.85 57,561.00 (1,695.85) 102.95% 411005 - PERF Union - 457.71 - 457.71 3,000.00 2,542.29 15.26% 411007 - Unemployment Comp 7.27 550.82 - 550.82 819.00 268.18 67.26% 411008 - Health Insurance 17,262.74 127,107.18 - 127,107.18 135,554.00 8,446.82 93.77% 411009 - Life Insurance 170.00 1,155.00 - 1,155.00 1,200.00 45.00 96.25% 411014 - Parental Leave 237.22 1,806.10 - 1,806.10 1,791.00 (15.10) 100.84% 411203 - Job Readiness Allow. - 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 165.00 1,650.00 - 1,650.00 1,260.00 (390.00) 130.95% Total Employee Benefits 32,475.02 267,493.80 - 267,493.80 293,584.00 26,090.20 91.11% Total Personnel Expenses 129,852.07 1,238,660.71 - 1,238,660.71 1,474,996.00 236,335.29 83.98% Supplies Expenses October 31, 2022 Office Supplies 421000 - General Office Supplies 336.91 993.16 - 993.16 1,750.00 756.84 56.75% Total Office Supplies 336.91 993.16 - 993.16 1,750.00 756.84 56.75% Operating Supplies 422000 - Other Operating Supplies 739.91 32,348.34 1,607.57 33,955.91 72,373.57 38,417.66 46.92% 422005 - Uniforms - 4,912.00 396.00 5,308.00 10,800.00 5,492.00 49.15% 422007 - Cleaning Supplies 71.50 90.96 - 90.96 2,400.00 2,309.04 3.79% 422008 - Medical/Safety Supplies - - - - 1,776.00 1,776.00 0.00% 422009 - Recreation Supplies 10,899.44 89,346.88 14,537.50 103,884.38 113,251.60 9,367.22 91.73% 422014 - Concessions Inventory 537.91 30,616.56 27.36 30,643.92 30,600.00 (43.92) 100.14% Total Operating Supplies 12,248.76 157,314.74 16,568.43 173,883.17 231,201.17 57,318.00 75.21% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 57.76 - 57.76 200.00 142.24 28.88% Total Repair & Maintenance Supplies - 57.76 - 57.76 200.00 142.24 28.88% Total Supplies Expenses 12,585.67 158,365.66 16,568.43 174,934.09 233,151.17 58,217.08 75.03% Services & Charges Expenses Professional Services 431000 - Other Professional Services 4,132.68 62,306.38 - 62,306.38 62,307.00 0.62 100.00% Total Professional Services 4,132.68 62,306.38 - 62,306.38 62,307.00 0.62 100.00% Communication & Transportation 432003 - Travel 135.00 5,318.54 6,641.51 11,960.05 11,000.00 (960.05) 108.73% 432005 - Mileage Reimb - 628.96 293.00 921.96 975.00 53.04 94.56% Total Communication & Transportation 135.00 5,947.50 6,934.51 12,882.01 11,975.00 (907.01) 107.57% Printing & Advertising 433001 - Outside Printing Services - 850.00 - 850.00 900.00 50.00 94.44% 433003 - Promotional 1,455.40 42,392.21 3,448.32 45,840.53 46,403.00 562.47 98.79% Total Printing & Advertising 1,455.40 43,242.21 3,448.32 46,690.53 47,303.00 612.47 98.71% Repairs & Maintenance 436000 - Other R&M 307.75 1,934.59 - 1,934.59 1,988.00 53.41 97.31% Total Repairs & Maintenance 307.75 1,934.59 - 1,934.59 1,988.00 53.41 97.31% Rentals 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - 1,200.00 - 1,200.00 1,200.00 - 100.00% Total Rentals - 13,200.00 - 13,200.00 13,200.00 - 100.00% Debt Service 438100 - Principal - 116,167.18 - 116,167.18 175,649.19 59,482.01 66.14% 438200 - Interest - 9,193.45 - 9,193.45 14,986.81 5,793.36 61.34% Total Debt Service - 125,360.63 - 125,360.63 190,636.00 65,275.37 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 12,424.46 104,239.54 11,714.68 115,954.22 115,327.10 (627.12) 100.54% 439001 - Other Contractual Services - 5,039.54 - 5,039.54 4,700.00 (339.54) 107.22% 439002 - Licenses & Permits - 5,431.58 - 5,431.58 5,497.00 65.42 98.81% 439004 - Dues & Memberships - 90.00 - 90.00 180.00 90.00 50.00% 439005 - Bank & Credit Card Fees 1,412.90 35,211.94 - 35,211.94 32,385.00 (2,826.94) 108.73% 439006 - Education & Training 455.00 3,680.00 1,119.73 4,799.73 4,400.00 (399.73) 109.08% 439009 - Trash Removal - 14.85 - 14.85 104.95 90.10 14.15% 439099 - Cashier Over/Short 0.10 1,093.81 - 1,093.81 1,250.00 156.19 87.50% 439100 - Refunds/Awards/Indemnities 364.31 15,890.95 - 15,890.95 15,155.00 (735.95) 104.86% Total Other Services & Charges 14,656.77 170,692.21 12,834.41 183,526.62 178,999.05 (4,527.57) 102.53% Total Services & Charges Expenses 20,687.60 422,683.52 23,217.24 445,900.76 506,408.05 60,507.29 88.05% Capital Outlay Machinery & Equipment 445003 - Park Equipment - 19,750.00 - 19,750.00 19,750.00 - 100.00% Total Machinery & Equipment - 19,750.00 - 19,750.00 19,750.00 - 100.00% Total Capital Expenses - 19,750.00 - 19,750.00 19,750.00 - 100.00% Other Uses 452002 - Allocations-Admin Cost 6,467.00 64,670.00 - 64,670.00 77,604.00 12,934.00 83.33% 452003 - Allocations-IT 14,069.17 140,691.66 - 140,691.66 168,830.00 28,138.34 83.33% Total Other Uses 20,536.17 205,361.66 - 205,361.66 246,434.00 41,072.34 83.33% Total Expenses 183,661.51 2,044,821.55 39,785.67 2,084,607.22 2,480,739.22 396,132.00 84.03%