Loading...
HomeMy WebLinkAboutNov 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 - 2,995.60 3,300.00 304.40 9.22% 347011 - Special Events 6,865.15 361,423.49 880,465.00 519,041.51 58.95% 347012 - Food Sales 1,591.81 14,714.30 42,000.00 27,285.70 64.97% 347013 - Nonalcoholic Beverage 822.62 9,076.10 38,000.00 28,923.90 76.12% 347016 - East Race Waterway 701.72 53,730.42 50,000.00 (3,730.42) (7.46%) 347017 - Ice Skating 14,764.70 178,081.12 123,500.00 (54,581.12) (44.20%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347026 - Room Rental 2,651.36 5,571.40 - (5,571.40) 0.00% 347030 - Merch Sales 34.67 34.67 - (34.67) 0.00% 347040 - Pavilion Rental - 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% 347050 - Ice Rink Gift Cards 5,125.90 5,125.90 - (5,125.90) 0.00% 347999 - Cash Over/Short (4.20) 164.51 - (164.51) 0.00% Total Culture & Recreation 32,553.73 647,569.38 1,227,765.00 580,195.62 47.26% Total Charges for Services 32,553.73 647,569.38 1,227,765.00 580,195.62 47.26% Miscellaneous Revenue 360000 - Miscellaneous - 1,359.08 - (1,359.08) 0.00% 362000 - Rental of Property - 72,255.24 60,000.00 (12,255.24) (20.43%) 367000 - Donations from Private Sources 749.00 749.00 - (749.00) 0.00% Total Miscellaneous Revenue 749.00 74,363.32 60,000.00 (14,363.32) (23.94%) Refunds & Reimbursements 380000 - Misc Reimbursements 1,755.00 4,541.00 - (4,541.00) 0.00% 396000 - Refunds - 144.00 - (144.00) 0.00% Total Refunds & Reimbursements 1,755.00 4,685.00 - (4,685.00) 0.00% Total Revenue 35,057.73 726,617.70 1,287,765.00 561,147.30 43.58% 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,552.69 949,231.34 - 949,231.34 1,041,711.00 92,479.66 8.88% 410003 - Permanent Part Time 18,740.20 294,539.59 - 294,539.59 324,112.00 29,572.41 9.12% 410004 - Extra & Overtime - 2,989.50 - 2,989.50 3,500.00 510.50 14.59% 410005 - Seasonal & Interns 8,233.63 226,699.59 - 226,699.59 405,320.00 178,620.41 44.07% Total Salaries & Wages 96,526.52 1,473,460.02 - 1,473,460.02 1,774,643.00 301,182.98 16.97% Employee Benefits 411001 - FICA Regular 7,025.87 108,257.15 - 108,257.15 119,740.00 11,482.85 9.59% 411004 - PERF Regular 7,704.52 103,333.01 - 103,333.01 114,339.00 11,005.99 9.63% 411007 - Unemployment Comp 6.94 94.80 - 94.80 112.00 17.20 15.36% 411008 - Health Insurance 19,916.34 243,944.34 - 243,944.34 266,539.00 22,594.66 8.48% 411009 - Life Insurance 200.00 2,430.00 - 2,430.00 2,710.00 280.00 10.33% 411014 - Parental Leave 243.41 3,327.10 - 3,327.10 3,644.00 316.90 8.70% 411206 - Cell Phone Allowance 165.00 2,365.00 - 2,365.00 2,640.00 275.00 10.42% Total Employee Benefits 35,262.08 463,751.40 - 463,751.40 509,724.00 45,972.60 9.02% Total Personnel Expenditures 131,788.60 1,937,211.42 - 1,937,211.42 2,284,367.00 347,155.58 15.20% November 30, 2020 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 230.44 406.59 50.00 456.59 175.00 (281.59) (160.91%) 421002 - Stationary & Printing - 937.13 373.82 1,310.95 3,487.00 2,176.05 62.40% Total Office Supplies 230.44 1,343.72 423.82 1,767.54 3,662.00 1,894.46 51.73% Operating Supplies 422000 - Other Operating Supplies 10,322.45 61,032.44 3,888.88 64,921.32 82,405.00 17,483.68 21.22% 422005 - Uniforms 280.90 4,295.00 - 4,295.00 10,785.00 6,490.00 60.18% 422007 - Cleaning Supplies 185.76 787.52 - 787.52 100.00 (687.52) (687.52%) 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 3,449.60 65,555.67 6,386.10 71,941.77 118,187.00 46,245.23 39.13% 422013 - Promotional Supplies 267.49 1,140.68 - 1,140.68 - (1,140.68) 0.00% 422014 - Concessions Inventory 413.41 4,962.02 - 4,962.02 36,000.00 31,037.98 86.22% 422016 - Inventory For Sale - 1,841.37 857.50 2,698.87 3,858.00 1,159.13 30.04% Total Operating Supplies 14,919.61 139,614.70 11,132.48 150,747.18 256,425.00 105,677.82 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 15,150.05 142,226.33 11,660.76 153,887.09 262,087.00 108,199.91 41.28% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 11,477.51 25,936.00 915.00 26,851.00 54,742.00 27,891.00 50.95% 431009 - Computer & Technology - 362.37 - 362.37 400.00 37.63 9.41% Total Professional Services 11,477.51 26,298.37 915.00 27,213.37 55,142.00 27,928.63 50.65% Communication & Transportation 432003 - Travel - 45.20 - 45.20 17,400.00 17,354.80 99.74% 432005 - Mileage Reimb 184.00 1,222.98 - 1,222.98 5,922.00 4,699.02 79.35% Total Communication & Transportation 184.00 1,268.18 - 1,268.18 23,322.00 22,053.82 94.56% Printing & Advertising 433001 - Outside Printing Services - 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 - 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 59,507.69 166,856.53 - 166,856.53 166,857.00 0.47 0.00% 438200 - Interest 5,204.64 23,216.42 - 23,216.42 23,778.00 561.58 2.36% Total Debt Service 64,712.33 190,072.95 - 190,072.95 190,635.00 562.05 0.29% Other Charges & Services 439000 - Misc Charges & Svcs 9,494.86 147,665.58 2,492.86 150,158.44 159,658.00 9,499.56 5.95% 439001 - Other Contractual Services 768.00 2,578.86 - 2,578.86 1,500.00 (1,078.86) (71.92%) 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 1,375.28 9,252.70 - 9,252.70 8,000.00 (1,252.70) (15.66%) 439006 - Education & Training - 2,448.98 - 2,448.98 14,699.00 12,250.02 83.34% 439009 - Trash Removal - 1,311.24 38.76 1,350.00 2,300.00 950.00 41.30% 439100 - Refunds/Awards/Indemnities 404.67 8,873.49 - 8,873.49 15,000.00 6,126.51 40.84% 439999 - Bad Debt Expense - 5,606.12 - 5,606.12 7,100.00 1,493.88 21.04% Total Other Services & Charges 12,042.81 180,272.22 2,531.62 182,803.84 218,717.00 35,913.16 16.42% Total Services & Charges Expenditures 88,416.65 399,167.91 5,646.62 404,814.53 520,622.00 115,807.47 22.24% Other Uses 452002 - Allocations-Admin Cost 9,839.00 108,228.00 - 108,228.00 118,067.00 9,839.00 8.33% Total Other Uses 9,839.00 108,228.00 - 108,228.00 118,067.00 9,839.00 8.33% Total Expenditures 245,194.30 2,586,833.66 17,307.38 2,604,141.04 3,185,143.00 581,001.96 18.24%