Loading...
HomeMy WebLinkAboutJan 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 8,647.70 8,647.70 657,384.00 648,736.30 98.68% 347012 - Food Sales - - 25,939.00 25,939.00 100.00% 347013 - Nonalcoholic Beverage - - 12,820.00 12,820.00 100.00% 347016 - East Race Waterway - - 38,504.00 38,504.00 100.00% 347017 - Ice Skating 61,965.60 61,965.60 120,000.00 58,034.40 48.36% 347026 - Room Rental 1,575.00 1,575.00 - (1,575.00) 0.00% 347030 - Merch Sales 292.00 292.00 - (292.00) 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 3,299.95 3,299.95 - (3,299.95) 0.00% Total Culture & Recreation 75,780.25 75,780.25 920,921.00 845,140.75 91.77% Total Charges for Services 75,780.25 75,780.25 920,921.00 845,140.75 91.77% Miscellaneous Revenue 362000 - Rental of Property 200.00 200.00 - (200.00) 0.00% Total Miscellaneous Revenue 200.00 200.00 - (200.00) #DIV/0! Refunds & Reimbursements 380000 - Misc Reimbursements 571.68 571.68 - (571.68) 0.00% Total Refunds & Reimbursements 571.68 571.68 - (571.68) 0.00% Total Revenue 76,551.93 76,551.93 920,921.00 844,369.07 91.69% 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 105,302.18 105,302.18 - 105,302.18 870,500.00 765,197.82 87.90% 410003 - Permanent Part Time 13,582.23 13,582.23 - 13,582.23 262,755.00 249,172.77 94.83% 410004 - Extra & Overtime 44.50 44.50 - 44.50 45.00 0.50 1.11% 410005 - Seasonal & Interns 28,508.00 28,508.00 - 28,508.00 479,240.00 450,732.00 94.05% Total Salaries & Wages 147,436.91 147,436.91 - 147,436.91 1,612,540.00 1,465,103.09 90.86% Employee Benefits 411001 - FICA Regular 10,941.56 10,941.56 - 10,941.56 123,561.00 112,619.44 91.14% 411004 - PERF Regular 8,674.89 8,674.89 - 8,674.89 97,792.00 89,117.11 91.13% 411007 - Unemployment Comp 10.50 10.50 - 10.50 261.00 250.50 95.98% 411008 - Health Insurance 18,819.27 18,819.27 - 18,819.27 197,377.00 178,557.73 90.47% 411009 - Life Insurance 180.00 180.00 - 180.00 2,040.00 1,860.00 91.18% 411014 - Parental Leave 368.56 368.56 - 368.56 3,047.00 2,678.44 87.90% 411206 - Cell Phone Allowance 110.00 110.00 - 110.00 2,640.00 2,530.00 95.83% Total Employee Benefits 39,104.78 39,104.78 - 39,104.78 426,718.00 387,613.22 90.84% Total Personnel Expenditures 186,541.69 186,541.69 - 186,541.69 2,039,258.00 1,852,716.31 90.85% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 80.35 80.35 - 80.35 - (80.35) 0.00% 421002 - Stationary & Printing 88.06 88.06 - 88.06 3,500.00 3,411.94 97.48% January 31, 2021 Total Office Supplies 168.41 168.41 - 168.41 3,500.00 3,331.59 95.19% Operating Supplies 422000 - Other Operating Supplies 3,298.80 3,298.80 5,186.13 8,484.93 91,370.62 82,885.69 90.71% 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 12,997.95 12,997.95 380.70 13,378.65 94,763.82 81,385.17 85.88% 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 16,296.75 16,296.75 5,566.83 21,863.58 235,849.44 213,985.86 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 16,465.16 16,465.16 5,566.83 22,031.99 241,349.44 219,317.45 90.87% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 3,746.85 3,746.85 1,385.00 5,131.85 129,714.00 124,582.15 96.04% Total Professional Services 3,746.85 3,746.85 1,385.00 5,131.85 129,714.00 124,582.15 96.04% 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% Rentals 437006 - Recreation Space Rental (12,000.00) (12,000.00) 700.00 (11,300.00) 1,900.00 13,200.00 694.74% Total Rentals (12,000.00) (12,000.00) 700.00 (11,300.00) 1,900.00 13,200.00 694.74% Debt Service 438100 - Principal 38,720.41 38,720.41 - 38,720.41 167,118.00 128,397.59 76.83% 438200 - Interest 7,801.80 7,801.80 - 7,801.80 23,518.00 15,716.20 66.83% Total Debt Service 46,522.21 46,522.21 - 46,522.21 190,636.00 144,113.79 75.60% Other Charges & Services 439000 - Misc Charges & Svcs 28,046.34 28,046.34 1,882.34 29,928.68 101,743.78 71,815.10 70.58% 439001 - Other Contractual Services 612.23 612.23 - 612.23 1,000.00 387.77 38.78% 439004 - Dues & Memberships - - - - 7,460.00 7,460.00 100.00% 439005 - Bank & Credit Card Fees 4,302.72 4,302.72 - 4,302.72 8,000.00 3,697.28 46.22% 439006 - Education & Training - - - - 13,000.00 13,000.00 100.00% 439099 - Cashier Over/Short 2.01 2.01 - 2.01 - (2.01) 0.00% 439100 - Refunds/Awards/Indemnities 1,442.80 1,442.80 - 1,442.80 15,000.00 13,557.20 90.38% Total Other Services & Charges 34,406.10 34,406.10 1,882.34 36,288.44 146,203.78 109,915.34 75.18% Total Services & Charges Expenditures 72,675.16 72,675.16 3,967.34 76,642.50 520,681.78 444,039.28 85.28% Other Uses 452002 - Allocations-Admin Cost 12,753.00 12,753.00 - 12,753.00 153,003.00 140,250.00 91.66% Total Other Uses 12,753.00 12,753.00 - 12,753.00 153,003.00 140,250.00 91.66% Total Expenditures 288,435.01 288,435.01 9,534.17 297,969.18 2,954,292.22 2,656,323.04 89.91%