Loading...
HomeMy WebLinkAboutAug 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 3,371.50 162,739.70 165,000.00 2,260.30 1.37% 347004 - Golf Green Fees 177,267.99 575,455.79 550,000.00 (25,455.79) (4.63%) 347005 - Golf Cart Rentals 74,395.84 245,501.31 330,000.00 84,498.69 25.61% 347006 - Golf Pro Shop Retail 10,610.93 35,401.80 60,000.00 24,598.20 41.00% 347007 - Golf Driving Range 6,803.10 22,987.82 20,000.00 (2,987.82) (14.94%) 347008 - Golf Gift Certificate (205.25) 956.68 5,500.00 4,543.32 82.61% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347012 - Food Sales 8,837.12 31,586.31 60,000.00 28,413.69 47.36% 347013 - Nonalcoholic Beverage 7,121.03 22,719.76 30,000.00 7,280.24 24.27% 347014 - Alcoholic Beverage Sales 23,443.60 73,898.47 90,000.00 16,101.53 17.89% 347026 - Room Rental - 200.00 - (200.00) 0.00% 347999 - Cash Over/Short 101.94 500.13 - (500.13) 0.00% Total Culture & Recreation 311,747.80 1,171,947.77 1,315,500.00 143,552.23 10.91% Total Charges for Services 311,747.80 1,171,947.77 1,315,500.00 143,552.23 10.91% Miscellaneous Revenue 360000 - Miscellaneous 2,292.69 5,674.17 2,500.00 (3,174.17) (126.97%) Total Miscellaneous Revenue 2,292.69 5,674.17 2,500.00 (3,174.17) (126.97%) Refunds & Reimbursements 380000 - Misc Reimbursements - 92.00 - (92.00) 0.00% Total Refunds & Reimbursements - 92.00 - (92.00) 0.00% Total Revenue 314,040.49 1,177,713.94 1,318,000.00 140,286.06 10.64% 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 25,608.71 214,753.37 - 214,753.37 314,481.00 99,727.63 31.71% 410002 - Teamster Wages 6,421.00 54,565.01 - 54,565.01 83,012.00 28,446.99 34.27% 410003 - Permanent Part Time 32,531.31 125,124.81 - 125,124.81 251,000.00 125,875.19 50.15% 410004 - Extra & Overtime 679.79 2,683.68 - 2,683.68 4,550.00 1,866.32 41.02% 410005 - Seasonal & Interns 8,779.04 23,029.75 - 23,029.75 22,950.00 (79.75) (0.35%) 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 74,019.85 420,756.62 - 420,756.62 676,593.00 255,836.38 37.81% Employee Benefits 411001 - FICA Regular 5,543.31 31,157.73 - 31,157.73 51,936.00 20,778.27 40.01% 411004 - PERF Regular 3,619.87 30,431.87 - 30,431.87 45,131.00 14,699.13 32.57% 411005 - PERF Union 99.84 847.71 - 847.71 1,317.00 469.29 35.63% 411007 - Unemployment Comp 3.23 27.07 - 27.07 40.00 12.93 32.33% 411008 - Health Insurance 7,833.60 62,668.80 - 62,668.80 92,883.00 30,214.20 32.53% 411009 - Life Insurance 80.00 640.00 - 640.00 960.00 320.00 33.33% 411014 - Parental Leave 112.92 945.54 - 945.54 1,402.00 456.46 32.56% 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 440.00 - 440.00 660.00 220.00 33.33% Total Employee Benefits 17,347.77 128,540.09 - 128,540.09 195,979.00 67,438.91 34.41% Total Personnel Expenditures 91,367.62 549,296.71 - 549,296.71 872,572.00 323,275.29 37.05% August 31, 2020 Supplies Expenditures Office Supplies 421002 - Stationary & Printing - 322.87 - 322.87 425.00 102.13 24.03% Total Office Supplies - 322.87 - 322.87 425.00 102.13 0.24 Operating Supplies 422000 - Other Operating Supplies 7,937.98 37,613.23 4,434.08 42,047.31 48,001.00 5,953.69 12.40% 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 - 60,628.93 - 60,628.93 71,560.00 10,931.07 15.28% 422014 - Concessions Inventory - 7,358.24 - 7,358.24 9,040.00 1,681.76 18.60% 422016 - Inventory For Sale - 5,671.26 - 5,671.26 7,000.00 1,328.74 18.98% Total Operating Supplies 7,937.98 112,903.92 4,434.08 117,338.00 141,051.00 23,713.00 16.81% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 17,834.35 1,092.41 18,926.76 22,707.00 3,780.24 16.65% Total Repair & Maintenance Supplies - 17,834.35 1,092.41 18,926.76 22,707.00 3,780.24 16.65% Total Supplies Expenditures 7,937.98 131,061.14 5,526.49 136,587.63 164,183.00 27,595.37 16.81% Services & Charges Expenditures Professional Services 431009 - Computer & Technology - 58.48 - 58.48 100.00 41.52 41.52% 431019 - Security Services - 219.56 - 219.56 4,000.00 3,780.44 94.51% Total Professional Services - 278.04 - 278.04 4,100.00 3,821.96 93.22% 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 9,962.03 46,561.10 - 46,561.10 55,556.00 8,994.90 16.19% 435002 - Natural Gas 171.92 15,140.02 - 15,140.02 18,519.00 3,378.98 18.25% Total Utilities 10,133.95 61,701.12 - 61,701.12 74,075.00 12,373.88 16.70% Debt Service 438100 - Principal 79.03 61,996.29 - 61,996.29 62,235.00 238.71 0.38% 438200 - Interest 5.10 11,577.31 - 11,577.31 11,591.00 13.69 0.12% Total Debt Service 84.13 73,573.60 - 73,573.60 73,826.00 252.40 0.34% Other Charges & Services 439000 - Misc Charges & Svcs 119.30 10,669.08 468.80 11,137.88 23,450.00 12,312.12 52.50% 439001 - Other Contractual Services 29.24 201.98 421.52 623.50 1,300.00 676.50 52.04% 439003 - Subscriptions 91.00 210.00 - 210.00 200.00 (10.00) (5.00%) 439004 - Dues & Memberships - 1,755.00 - 1,755.00 4,000.00 2,245.00 56.13% 439005 - Bank & Credit Card Fees - - - - - - 0.00% 439009 - Trash Removal - 1,645.18 - 1,645.18 6,600.00 4,954.82 75.07% Total Other Services & Charges 239.54 14,481.24 890.32 15,371.56 35,550.00 20,178.44 56.76% Total Services & Charges Expenditures 10,457.62 150,555.64 890.32 151,445.96 189,041.00 37,595.04 19.89% Other Uses 452002 - Allocations-Admin Cost 4,770.00 38,158.00 - 38,158.00 57,238.00 19,080.00 33.33% 452009 - Allocations-Facilities Mgmt 233.00 1,866.00 - 1,866.00 2,798.00 932.00 33.31% Total Other Uses 5,003.00 40,024.00 - 40,024.00 60,036.00 20,012.00 33.33% Total Expenditures 114,766.22 870,937.49 6,416.81 877,354.30 1,285,832.00 408,477.70 31.77%