Loading...
HomeMy WebLinkAboutNov 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 - 56,410.07 20,000.00 (36,410.07) 282.05% 347002 - Picnic Site Rental - 5,999.45 3,300.00 (2,699.45) 181.80% 347010 - Concession Sales 1,880.47 54,694.23 31,000.00 (23,694.23) 176.43% 347011 - Recreational Programming 41,371.12 356,394.99 300,500.00 (55,894.99) 118.60% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway - 51,900.42 55,000.00 3,099.58 94.36% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 4,781.90 58,387.11 9,000.00 (49,387.11) 648.75% 347030 - Merch Sales 391.23 2,164.82 2,500.00 335.18 86.59% 347040 - Pavilion Rental 285.64 32,847.76 22,446.00 (10,401.76) 146.34% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347051 - Park Reservations - 100.00 - (100.00) 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 48,710.36 785,613.64 743,746.00 (41,867.64) 105.63% Total Charges for Services 48,710.36 785,613.64 743,746.00 (41,867.64) 105.63% Miscellaneous Revenue 360000 - Miscellaneous 28.00 128.00 - (128.00) 0.00% 362000 - Rental of Property 5,414.75 68,740.75 60,000.00 (8,740.75) 114.57% Total Miscellaneous Revenue 5,442.75 68,868.75 60,000.00 (8,868.75) 114.78% Refunds & Reimbursements 380000 - Misc Reimbursements 4.00 23,992.01 35,396.00 11,403.99 67.78% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 4.00 24,407.60 35,396.00 10,988.40 68.96% Total Revenue 54,157.11 878,889.99 839,142.00 (39,747.99) 104.74% 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 68,792.63 871,133.01 - 871,133.01 954,340.00 83,206.99 91.28% 410003 - Permanent Part Time 13,082.15 163,238.05 - 163,238.05 216,788.00 53,549.95 75.30% 410004 - Extra & Overtime - 5,176.10 - 5,176.10 5,639.00 462.90 91.79% 410005 - Seasonal & Interns 10,167.08 358,110.85 - 358,110.85 406,582.00 48,471.15 88.08% Total Salaries & Wages 92,041.86 1,397,658.01 - 1,397,658.01 1,583,349.00 185,690.99 88.27% Employee Benefits 411001 - FICA Regular 6,647.30 103,002.09 - 103,002.09 119,187.00 16,184.91 86.42% 411004 - PERF Regular 7,392.68 93,145.41 - 93,145.41 102,166.00 9,020.59 91.17% 411007 - Unemployment Comp 22.11 271.83 - 271.83 298.00 26.17 91.22% 411008 - Health Insurance 17,740.40 206,724.77 - 206,724.77 226,568.00 19,843.23 91.24% 411009 - Life Insurance 170.00 1,975.00 - 1,975.00 2,165.00 190.00 91.22% 411014 - Parental Leave 240.78 3,055.85 - 3,055.85 3,355.00 299.15 91.08% 411206 - Cell Phone Allowance 165.00 1,815.00 - 1,815.00 2,170.00 355.00 83.64% Total Employee Benefits 32,378.27 409,989.95 - 409,989.95 455,909.00 45,919.05 89.93% Total Personnel Expenditures 124,420.13 1,807,647.96 - 1,807,647.96 2,039,258.00 231,610.04 88.64% November 30, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies 101.10 1,726.76 - 1,726.76 2,960.00 1,233.24 58.34% 421002 - Stationary & Printing 683.96 4,277.73 - 4,277.73 8,194.00 3,916.27 52.21% Total Office Supplies 785.06 6,004.49 - 6,004.49 11,154.00 5,149.51 53.83% Operating Supplies 422000 - Other Operating Supplies 1,383.94 25,901.12 5,241.05 31,142.17 50,128.62 18,986.45 62.12% 422005 - Uniforms 1,087.29 4,616.49 2,233.98 6,850.47 11,128.00 4,277.53 61.56% 422006 - Computer Supplies & Equipment - - - - 2,200.00 2,200.00 0.00% 422008 - Medical/Safety Supplies - 1,124.78 - 1,124.78 2,540.00 1,415.22 44.28% 422009 - Recreation Supplies 5,896.61 85,617.53 3,009.00 88,626.53 121,703.82 33,077.29 72.82% 422013 - Promotional Supplies - 557.26 - 557.26 700.00 142.74 79.61% 422014 - Concessions Inventory 70.26 24,968.38 - 24,968.38 32,340.00 7,371.62 77.21% 422016 - Inventory For Sale - 182.33 - 182.33 2,300.00 2,117.67 7.93% Total Operating Supplies 8,438.10 142,967.89 10,484.03 153,451.92 223,040.44 69,588.52 68.80% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 6,455.33 - 6,455.33 7,155.00 699.67 90.22% Total Repair & Maintenance Supplies - 6,455.33 - 6,455.33 7,155.00 699.67 90.22% Total Supplies Expenditures 9,223.16 155,427.71 10,484.03 165,911.74 241,349.44 75,437.70 68.74% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,157.69 53,127.02 2,339.00 55,466.02 75,388.00 19,921.98 73.57% Total Professional Services 2,157.69 53,127.02 2,339.00 55,466.02 75,388.00 19,921.98 73.57% Communication & Transportation 432002 - Mailing - 0.52 - 0.52 1.00 0.48 52.00% 432003 - Travel 952.41 2,703.10 - 2,703.10 14,010.00 11,306.90 19.29% 432005 - Mileage Reimb - 132.72 - 132.72 6,019.00 5,886.28 2.21% Total Communication & Transportation 952.41 2,836.34 - 2,836.34 20,030.00 17,193.66 14.16% Printing & Advertising 433001 - Outside Printing Services - 3,429.10 - 3,429.10 12,956.00 9,526.90 26.47% 433003 - Promotional 1,012.00 1,122.00 - 1,122.00 7,585.00 6,463.00 14.79% Total Printing & Advertising 1,012.00 4,551.10 - 4,551.10 20,541.00 15,989.90 22.16% Repairs & Maintenance 436000 - Other R&M - 10.91 - 10.91 11.00 0.09 99.18% 436001 - Building R&M - 1,568.80 - 1,568.80 3,200.00 1,631.20 49.03% Total Repairs & Maintenance - 1,579.71 - 1,579.71 3,211.00 1,631.29 49.20% Rentals 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - 1,200.00 700.00 1,900.00 1,900.00 - 100.00% Total Rentals - 13,200.00 700.00 13,900.00 13,900.00 - 100.00% Debt Service 438100 - Principal 61,282.75 160,391.86 - 160,391.86 169,416.00 9,024.14 94.67% 438200 - Interest 3,429.58 15,555.01 - 15,555.01 21,220.00 5,664.99 73.30% Total Debt Service 64,712.33 175,946.87 - 175,946.87 190,636.00 14,689.13 92.29% Other Charges & Services 439000 - Misc Charges & Svcs 10,098.79 63,574.26 5,914.60 69,488.86 86,295.78 16,806.92 80.52% 439001 - Other Contractual Services 3,048.00 8,651.01 - 8,651.01 26,355.00 17,703.99 32.82% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 2,953.00 1,140.26 61.39% 439004 - Dues & Memberships - 955.26 - 955.26 2,478.00 1,522.74 38.55% 439005 - Bank & Credit Card Fees 3,483.90 32,339.50 - 32,339.50 38,397.00 6,057.50 84.22% 439006 - Education & Training 2,672.60 4,667.00 - 4,667.00 10,231.00 5,564.00 45.62% 439009 - Trash Removal 84.69 1,944.81 359.95 2,304.76 2,800.00 495.24 82.31% 439099 - Cashier Over/Short - (78.75) - (78.75) - 78.75 0.00% 439100 - Refunds/Awards/Indemnities 1,103.44 18,704.38 - 18,704.38 27,466.00 8,761.62 68.10% 439999 - Bad Debt Expense - - - - - - 0.00% Total Other Services & Charges 20,491.42 132,570.21 6,274.55 138,844.76 196,975.78 58,131.02 70.49% Total Services & Charges Expenditures 89,325.85 383,811.25 9,313.55 393,124.80 520,681.78 127,556.98 75.50% Other Uses 452002 - Allocations-Admin Cost 12,750.00 140,253.00 - 140,253.00 153,003.00 12,750.00 91.67% Total Other Uses 12,750.00 140,253.00 - 140,253.00 153,003.00 12,750.00 91.67% Total Expenditures 235,719.14 2,487,139.92 19,797.58 2,506,937.50 2,954,292.22 447,354.72 84.86%