Loading...
HomeMy WebLinkAboutMay 20 Fin 4South Bend Venues, Parks and Arts Golf: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347003 - Golf Season Pass 17,243.00 141,814.15 165,000.00 23,185.85 14.05% 347004 - Golf Green Fees 39,021.60 47,131.35 550,000.00 502,868.65 91.43% 347005 - Golf Cart Rentals 14,931.52 18,460.07 330,000.00 311,539.93 94.41% 347006 - Golf Pro Shop Retail 2,216.97 2,936.30 60,000.00 57,063.70 95.11% 347007 - Golf Driving Range 2,113.90 2,113.90 20,000.00 17,886.10 89.43% 347008 - Golf Gift Certificate (772.24)(512.24) 5,500.00 6,012.24 109.31% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347012 - Food Sales 905.18 1,184.96 60,000.00 58,815.04 98.03% 347013 - Nonalcoholic Beverage 1,118.43 1,273.09 30,000.00 28,726.91 95.76% 347014 - Alcoholic Beverage Sales 4,116.42 6,409.41 90,000.00 83,590.59 92.88% 347999 - Cash Over/Short (76.45)(76.46) - 76.46 0.00% Total Culture & Recreation 80,818.33 220,734.53 1,315,500.00 1,094,765.47 89.36% Total Charges for Services 80,818.33 220,734.53 1,315,500.00 1,094,765.47 83.22% Miscellaneous Revenue 360000 - Miscellaneous (100.00) 1,569.48 2,500.00 930.52 37.22% Total Miscellaneous Revenue (100.00) 1,569.48 2,500.00 930.52 37.22% Total Revenue 80,718.33 222,304.01 1,318,000.00 1,095,695.99 83.13% EXPENDITURES Current YTD Total YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 37,828.93 138,706.08 - 138,706.08 314,481.00 175,774.92 55.89% 410002 - Teamster Wages 9,628.80 35,305.61 - 35,305.61 83,012.00 47,706.39 57.47% 410003 - Permanent Part Time 19,178.81 26,601.72 - 26,601.72 253,000.00 226,398.28 89.49% 410004 - Extra & Overtime 131.25 131.25 - 131.25 2,550.00 2,418.75 94.85% 410005 - Seasonal & Interns 330.23 446.38 - 446.38 22,950.00 22,503.62 98.05% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 67,098.02 201,791.04 - 201,791.04 676,593.00 474,801.96 70.18% Employee Benefits 411001 - FICA Regular 4,994.88 14,798.27 - 14,798.27 51,936.00 37,137.73 71.51% 411004 - PERF Regular 5,322.31 19,683.51 - 19,683.51 45,131.00 25,447.49 56.39% 411005 - PERF Union 144.53 551.41 - 551.41 1,317.00 765.59 58.13% 411007 - Unemployment Comp 4.72 17.46 - 17.46 40.00 22.54 56.35% 411008 - Health Insurance 7,833.60 39,168.00 - 39,168.00 92,883.00 53,715.00 57.83% 411009 - Life Insurance 80.00 400.00 - 400.00 960.00 560.00 58.33% 411014 - Parental Leave 166.11 610.26 - 610.26 1,402.00 791.74 56.47% 411201 - Tool Allowance - 531.37 - 531.37 800.00 268.63 33.58% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 0.00% 411206 - Cell Phone Allowance 55.00 275.00 - 275.00 660.00 385.00 58.33% Total Employee Benefits 18,601.15 76,885.28 - 76,885.28 195,979.00 119,093.72 60.77% Total Personnel Expenditures 85,699.17 278,676.32 - 278,676.32 872,572.00 593,895.68 68.06% Supplies Expenditures Office Supplies 421002 - Stationary & Printing - - - - 125.00 125.00 100.00% May 31, 2020 Total Office Supplies - - - - 125.00 125.00 100.00% Operating Supplies 422000 - Other Operating Supplies 13,397.99 28,663.69 8,554.07 37,217.76 49,001.00 11,783.24 24.05% 422003 - Gasoline - 1,632.26 - 1,632.26 5,000.00 3,367.74 67.35% 422005 - Uniforms - - - - 450.00 450.00 100.00% 422010 - Plants Chemicals Seed & Fertilizer 6,643.28 60,628.93 - 60,628.93 78,660.00 18,031.07 22.92% 422014 - Concessions Inventory - 7,358.24 - 7,358.24 75,700.00 68,341.76 90.28% 422016 - Inventory For Sale - 5,671.26 - 5,671.26 55,000.00 49,328.74 89.69% Total Operating Supplies 20,041.27 103,954.38 8,554.07 112,508.45 263,811.00 151,302.55 57.35% Repair & Maintenance Supplies 423000 - Other R&M Supplies 525.28 17,834.35 1,092.41 18,926.76 23,707.00 4,780.24 20.16% Total Repair & Maintenance Supplies 525.28 17,834.35 1,092.41 18,926.76 23,707.00 4,780.24 20.16% Total Supplies Expenditures 20,566.55 122,456.05 9,646.48 132,102.53 287,643.00 155,540.47 54.07% Services & Charges Expenditures Professional Services 431009 - Computer & Technology - - - - - - 431019 - Security Services - 219.56 - 219.56 4,500.00 4,280.44 95.12% Total Professional Services - 219.56 - 219.56 4,500.00 4,280.44 95.12% Communication & Transportation 432003 - Travel - 433.92 - 433.92 500.00 66.08 13.22% 432004 - Telecommunications - 87.72 - 87.72 400.00 312.28 78.07% Total Communication & Transportation - 521.64 - 521.64 900.00 378.36 42.04% Printing & Advertising 433001 - Outside Printing Services - - - - 590.00 590.00 100.00% Total Printing & Advertising - - - - 590.00 590.00 100.00% Utilties 435001 - Electric 847.08 14,086.44 - 14,086.44 55,556.00 41,469.56 74.64% 435002 - Natural Gas 1,218.43 11,693.49 - 11,693.49 18,519.00 6,825.51 36.86% Total Utilities 2,065.51 25,779.93 - 25,779.93 74,075.00 48,295.07 65.20% Debt Service 438100 - Principal 61,452.03 61,760.13 - 61,760.13 62,235.00 474.87 0.76% 438200 - Interest 11,532.64 11,561.08 - 11,561.08 11,591.00 29.92 0.26% Total Debt Service 72,984.67 73,321.21 - 73,321.21 73,826.00 504.79 0.68% Other Charges & Services 439000 - Misc Charges & Svcs - 10,549.78 588.10 11,137.88 70,000.00 58,862.12 84.09% 439001 - Other Contractual Services 66.50 66.50 - 66.50 - (66.50) 0.00% 439003 - Subscriptions 119.00 119.00 - 119.00 - (119.00) 0.00% 439004 - Dues & Memberships - 1,755.00 - 1,755.00 4,000.00 2,245.00 56.13% 439005 - Bank & Credit Card Fees (3,170.85) - - - - - 0.00% 439009 - Trash Removal - 1,645.18 - 1,645.18 6,600.00 4,954.82 75.07% Total Other Services & Charges 72,064.83 113,977.80 588.10 114,565.90 234,491.00 119,925.10 51.14% Total Services & Charges Expenditures 72,064.83 113,977.80 588.10 114,565.90 234,491.00 119,925.10 51.14% Other Uses 452002 - Allocations-Admin Cost 4,770.00 23,848.00 - 23,848.00 57,238.00 33,390.00 58.34% 452009 - Allocations-Facilities Mgmt 233.00 1,167.00 - 1,167.00 2,798.00 1,631.00 58.29% Total Other Uses 5,003.00 25,015.00 - 25,015.00 60,036.00 35,021.00 58.33% Total Expenditures 183,333.55 539,457.85 10,234.58 549,692.43 1,454,742.00 905,049.57 62.21%