Loading...
HomeMy WebLinkAboutFeb 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 - - 33,766.00 33,766.00 100.00% 347002 - Picnic Site Rental - - 2,952.00 2,952.00 100.00% 347011 - Special Events 7,454.96 16,327.66 657,384.00 641,056.34 97.52% 347012 - Food Sales - - 25,939.00 25,939.00 100.00% 347013 - Nonalcoholic Beverage 188.79 188.79 12,820.00 12,631.21 98.53% 347016 - East Race Waterway - - 38,504.00 38,504.00 100.00% 347017 - Ice Skating 70,184.81 132,150.41 120,000.00 (12,150.41) (10.13%) 347026 - Room Rental 1,800.01 3,375.01 - (3,375.01) 0.00% 347030 - Merch Sales 212.95 504.95 - (504.95) 0.00% 347040 - Pavilion Rental - - 12,490.00 12,490.00 100.00% 347041 - Picnic Shelter - - 17,066.00 17,066.00 100.00% 347050 - Ice Rink Gift Cards 588.00 3,887.95 - (3,887.95) 0.00% Total Culture & Recreation 80,429.52 156,434.77 920,921.00 764,486.23 83.01% Total Charges for Services 80,429.52 156,434.77 920,921.00 764,486.23 83.01% Miscellaneous Revenue 362000 - Rental of Property 20,000.00 20,200.00 - (20,200.00) 0.00% Total Miscellaneous Revenue 20,000.00 20,200.00 - (20,200.00) #DIV/0! Refunds & Reimbursements 380000 - Misc Reimbursements 8,970.59 9,542.27 - (9,542.27) 0.00% Total Refunds & Reimbursements 8,970.59 9,542.27 - (9,542.27) 0.00% Total Revenue 109,400.11 186,177.04 920,921.00 734,743.96 79.78% 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 64,099.95 169,402.13 - 169,402.13 870,500.00 701,097.87 80.54% 410003 - Permanent Part Time 10,327.18 23,909.41 - 23,909.41 262,755.00 238,845.59 90.90% 410004 - Extra & Overtime - 44.50 - 44.50 45.00 0.50 1.11% 410005 - Seasonal & Interns 23,878.12 52,386.12 - 52,386.12 479,240.00 426,853.88 89.07% Total Salaries & Wages 98,305.25 245,742.16 - 245,742.16 1,612,540.00 1,366,797.84 84.76% Employee Benefits 411001 - FICA Regular 7,258.73 18,200.29 - 18,200.29 123,561.00 105,360.71 85.27% 411004 - PERF Regular 7,163.48 15,838.37 - 15,838.37 97,792.00 81,953.63 83.80% 411007 - Unemployment Comp 6.45 16.95 - 16.95 261.00 244.05 93.51% 411008 - Health Insurance 17,733.40 36,552.67 - 36,552.67 197,377.00 160,824.33 81.48% 411009 - Life Insurance 170.00 350.00 - 350.00 2,040.00 1,690.00 82.84% 411014 - Parental Leave 224.38 592.94 - 592.94 3,047.00 2,454.06 80.54% 411206 - Cell Phone Allowance 110.00 220.00 - 220.00 2,640.00 2,420.00 91.67% Total Employee Benefits 32,666.44 71,771.22 - 71,771.22 426,718.00 354,946.78 83.18% Total Personnel Expenditures 130,971.69 317,513.38 - 317,513.38 2,039,258.00 1,721,744.62 84.43% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 107.27 187.62 - 187.62 - (187.62) 0.00% 421002 - Stationary & Printing - 88.06 - 88.06 3,500.00 3,411.94 97.48% February 28, 2021 Total Office Supplies 107.27 275.68 - 275.68 3,500.00 3,224.32 92.12% Operating Supplies 422000 - Other Operating Supplies 1,230.02 4,528.82 7,039.52 11,568.34 91,370.62 79,802.28 87.34% 422005 - Uniforms - - - - 10,625.00 10,625.00 100.00% 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 2,141.59 15,139.54 414.00 15,553.54 94,763.82 79,210.28 83.59% 422014 - Concessions Inventory - - - - 31,000.00 31,000.00 100.00% 422016 - Inventory For Sale - - - - 3,000.00 3,000.00 100.00% Total Operating Supplies 3,371.61 19,668.36 7,453.52 27,121.88 235,849.44 208,727.56 43.98% Repair & Maintenance Supplies 423000 - Other R&M Supplies - - - - 2,000.00 2,000.00 100.00% Total Repair & Maintenance Supplies - - - - 2,000.00 2,000.00 100.00% Total Supplies Expenditures 3,478.88 19,944.04 7,453.52 27,397.56 241,349.44 213,951.88 88.65% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,511.72 6,258.57 3,110.00 9,368.57 129,714.00 120,345.43 92.78% Total Professional Services 2,511.72 6,258.57 3,110.00 9,368.57 129,714.00 120,345.43 92.78% Communication & Transportation 432003 - Travel - - - - 16,500.00 16,500.00 100.00% 432005 - Mileage Reimb - - - - 5,922.00 5,922.00 100.00% Total Communication & Transportation - - - - 22,422.00 22,422.00 100.00% Printing & Advertising 433001 - Outside Printing Services - - - - 21,106.00 21,106.00 100.00% 433003 - Promotional - - - - 8,700.00 8,700.00 100.00% Total Printing & Advertising - - - - 29,806.00 29,806.00 100.00% Repairs & Maintenance 436001 - Building R&M 1,568.80 1,568.80 - 1,568.80 - (1,568.80) 0.00% Total Repairs & Maintenance 1,568.80 1,568.80 - 1,568.80 - (1,568.80) 0.00% Rentals 437005 - Parking Space Rental 12,000.00 12,000.00 - 12,000.00 - (12,000.00) 0.00% 437006 - Recreation Space Rental 12,000.00 - 700.00 700.00 1,900.00 1,200.00 63.16% Total Rentals 24,000.00 12,000.00 700.00 12,700.00 1,900.00 (10,800.00) (568.42%) Debt Service 438100 - Principal - 38,720.41 - 38,720.41 167,118.00 128,397.59 76.83% 438200 - Interest - 7,801.80 - 7,801.80 23,518.00 15,716.20 66.83% Total Debt Service - 46,522.21 - 46,522.21 190,636.00 144,113.79 75.60% Other Charges & Services 439000 - Misc Charges & Svcs (19,447.45) 8,598.89 10,613.02 19,211.91 101,743.78 82,531.87 81.12% 439001 - Other Contractual Services - 612.23 - 612.23 1,000.00 387.77 38.78% 439002 - Licenses & Permits 553.08 553.08 - 553.08 - (553.08) 0.00% 439004 - Dues & Memberships - - - - 7,460.00 7,460.00 100.00% 439005 - Bank & Credit Card Fees 4,477.81 8,815.53 - 8,815.53 8,000.00 (815.53) (10.19%) 439006 - Education & Training - - - - 13,000.00 13,000.00 100.00% 439099 - Cashier Over/Short (0.01) 2.00 - 2.00 - (2.00) 0.00% 439100 - Refunds/Awards/Indemnities 523.70 1,966.50 - 1,966.50 15,000.00 13,033.50 86.89% Total Other Services & Charges (13,892.87) 20,548.23 10,613.02 31,161.25 146,203.78 115,042.53 78.69% Total Services & Charges Expenditures 14,187.65 86,897.81 14,423.02 101,320.83 520,681.78 419,360.95 80.54% Other Uses 452002 - Allocations-Admin Cost 12,750.00 25,503.00 - 25,503.00 153,003.00 127,500.00 83.33% Total Other Uses 12,750.00 25,503.00 - 25,503.00 153,003.00 127,500.00 83.33% Total Expenditures 161,388.22 449,858.23 21,876.54 471,734.77 2,954,292.22 2,482,557.45 84.03%