Loading...
HomeMy WebLinkAboutJuly 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,393.84 2,393.84 46,000.00 43,606.16 94.80% 347002 - Picnic Site Rental 970.00 1,942.60 3,300.00 1,357.40 41.13% 347011 - Special Events 33,423.13 289,482.51 880,465.00 590,982.49 67.12% 347012 - Food Sales 6,183.57 6,559.82 42,000.00 35,440.18 84.38% 347013 - Nonalcoholic Beverage 3,704.98 4,468.33 38,000.00 33,531.67 88.24% 347016 - East Race Waterway 22,793.83 26,132.58 50,000.00 23,867.42 47.73% 347017 - Ice Skating - 148,838.02 123,500.00 (25,338.02) (20.52%) 347018 - Skate Rental - - 2,000.00 2,000.00 100.00% 347040 - Pavilion Rental 5,045.00 5,215.00 17,500.00 12,285.00 70.20% 347041 - Picnic Shelter - 4,600.00 25,000.00 20,400.00 81.60% 347999 - Cash Over/Short 1.46 196.95 - (196.95) 0.00% Total Culture & Recreation 74,515.81 489,829.65 1,227,765.00 737,935.35 60.10% Total Charges for Services 74,515.81 489,829.65 1,227,765.00 737,935.35 60.10% Miscellaneous Revenue 360000 - Miscellaneous - 334.08 - (334.08) 0.00% 362000 - Rental of Property 450.00 16,697.25 60,000.00 43,302.75 72.17% Total Miscellaneous Revenue 450.00 17,031.33 60,000.00 42,968.67 71.61% Refunds & Reimbursements 380000 - Misc Reimbursements - 900.50 - (900.50) 0.00% Total Refunds & Reimbursements - 900.50 - (900.50) 0.00% Total Revenue 74,965.81 507,761.48 1,287,765.00 780,003.52 60.57% 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 79,779.87 595,696.00 - 595,696.00 1,021,711.00 426,015.00 41.70% 410003 - Permanent Part Time 29,682.10 193,398.09 - 193,398.09 234,112.00 40,713.91 17.39% 410004 - Extra & Overtime 998.77 1,095.15 - 1,095.15 1,000.00 (95.15) (9.52%) 410005 - Seasonal & Interns 70,364.28 114,715.43 - 114,715.43 501,845.00 387,129.57 77.14% Total Salaries & Wages 180,825.02 904,904.67 - 904,904.67 1,758,668.00 853,763.33 48.55% Employee Benefits 411001 - FICA Regular 13,372.02 66,487.37 - 66,487.37 134,740.00 68,252.63 50.66% 411004 - PERF Regular 8,856.13 66,097.49 - 66,097.49 114,839.00 48,741.51 42.44% 411007 - Unemployment Comp 7.94 59.37 - 59.37 102.00 42.63 41.79% 411008 - Health Insurance 23,069.94 158,896.98 - 158,896.98 267,039.00 108,142.02 40.50% 411009 - Life Insurance 230.00 1,590.00 - 1,590.00 2,760.00 1,170.00 42.39% 411014 - Parental Leave 279.21 2,084.87 - 2,084.87 3,579.00 1,494.13 41.75% 411206 - Cell Phone Allowance 220.00 1,540.00 - 1,540.00 2,640.00 1,100.00 41.67% Total Employee Benefits 46,035.24 296,756.08 - 296,756.08 525,699.00 228,942.92 43.55% Total Personnel Expenditures 226,860.26 1,201,660.75 - 1,201,660.75 2,284,367.00 1,082,706.25 47.40% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 54.50 108.59 - 108.59 75.00 (33.59) (44.79%) 421002 - Stationary & Printing - 704.79 373.82 1,078.61 3,587.00 2,508.39 69.93% July 31, 2020 Total Office Supplies 54.50 813.38 373.82 1,187.20 3,662.00 2,474.80 67.58% Operating Supplies 422000 - Other Operating Supplies 11,289.21 35,191.35 16,230.95 51,422.30 82,505.00 31,082.70 37.67% 422005 - Uniforms 245.45 795.45 - 795.45 10,785.00 9,989.55 92.62% 422007 - Cleaning Supplies 37.33 37.33 - 37.33 - (37.33) 0.00% 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 6,090.22 48,913.53 7,492.94 56,406.47 118,187.00 61,780.53 52.27% 422014 - Concessions Inventory - 1,277.73 1,636.86 2,914.59 36,000.00 33,085.41 91.90% 422016 - Inventory For Sale - - 857.50 857.50 3,858.00 3,000.50 77.77% Total Operating Supplies 17,662.21 86,215.39 26,218.25 112,433.64 256,425.00 143,991.36 56.15% 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 17,716.71 88,296.68 26,696.53 114,993.21 262,087.00 147,093.79 56.12% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 807.52 13,492.59 445.97 13,938.56 84,742.00 70,803.44 83.55% 431009 - Computer & Technology 90.00 272.37 - 272.37 100.00 (172.37) (172.37%) Total Professional Services 897.52 13,764.96 445.97 14,210.93 84,842.00 70,631.07 83.25% Communication & Transportation 432003 - Travel - 45.20 - 45.20 18,000.00 17,954.80 99.75% 432005 - Mileage Reimb - 94.88 - 94.88 5,922.00 5,827.12 98.40% Total Communication & Transportation - 140.08 - 140.08 23,922.00 23,781.92 99.41% Printing & Advertising 433001 - Outside Printing Services - 270.00 - 270.00 21,106.00 20,836.00 98.72% 433003 - Promotional - 3.20 1,500.00 1,503.20 10,200.00 8,696.80 85.26% Total Printing & Advertising - 273.20 1,500.00 1,773.20 31,306.00 29,532.80 94.34% 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 - 107,348.84 59,507.69 166,856.53 166,857.00 0.47 0.00% 438200 - Interest - 18,011.78 5,485.62 23,497.40 23,778.00 280.60 1.18% Total Debt Service - 125,360.62 64,993.31 190,353.93 190,635.00 281.07 0.15% Other Charges & Services 439000 - Misc Charges & Svcs 10,737.52 102,121.21 11,490.83 113,612.04 134,658.00 21,045.96 15.63% 439001 - Other Contractual Services 300.00 770.40 - 770.40 - (770.40) 0.00% 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 537.40 4,271.94 - 4,271.94 8,000.00 3,728.06 46.60% 439006 - Education & Training - 2,448.98 - 2,448.98 14,699.00 12,250.02 83.34% 439009 - Trash Removal 114.78 114.78 155.22 270.00 500.00 230.00 46.00% 439100 - Refunds/Awards/Indemnities 300.00 7,700.46 - 7,700.46 15,000.00 7,299.54 48.66% 439999 - Bad Debt Expense - 4,637.12 - 4,637.12 5,100.00 462.88 9.08% Total Other Services & Charges 11,989.70 124,600.14 11,646.05 136,246.19 188,417.00 52,170.81 27.69% Total Services & Charges Expenditures 12,887.22 264,639.00 79,285.33 343,924.33 520,622.00 176,697.67 33.94% Other Uses 452002 - Allocations-Admin Cost 9,839.00 68,872.00 - 68,872.00 118,067.00 49,195.00 41.67% Total Other Uses 9,839.00 68,872.00 - 68,872.00 118,067.00 49,195.00 41.67% Total Expenditures 267,303.19 1,623,468.43 105,981.86 1,729,450.29 3,185,143.00 1,455,692.71 45.70%