Loading...
HomeMy WebLinkAboutOct 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 (63.50) 162,676.20 165,000.00 2,323.80 1.41% 347004 - Golf Green Fees 53,372.01 763,068.51 550,000.00 (213,068.51) (38.74%) 347005 - Golf Cart Rentals 32,362.96 341,363.31 330,000.00 (11,363.31) (3.44%) 347006 - Golf Pro Shop Retail 4,489.66 50,568.19 60,000.00 9,431.81 15.72% 347007 - Golf Driving Range 1,802.00 31,101.18 30,530.00 (571.18) (1.87%) 347008 - Golf Gift Certificate (536.11) 557.27 260.00 (297.27) (114.33%) 347012 - Food Sales 4,704.92 45,869.93 60,000.00 14,130.07 23.55% 347013 - Nonalcoholic Beverage 1,935.63 29,389.63 30,000.00 610.37 2.03% 347014 - Alcoholic Beverage Sales 9,549.50 104,387.88 90,000.00 (14,387.88) (15.99%) 347026 - Room Rental - - - - 0.00% 347999 - Cash Over/Short 36.88 615.59 - (615.59) 0.00% Total Culture & Recreation 107,653.95 1,529,597.69 1,315,790.00 (213,807.69) (16.25%) Total Charges for Services 107,653.95 1,529,597.69 1,315,790.00 (213,807.69) (16.25%) Miscellaneous Revenue 360000 - Miscellaneous 136.26 6,146.40 6,270.00 123.60 1.97% Total Miscellaneous Revenue 136.26 6,146.40 6,270.00 123.60 1.97% Refunds & Reimbursements 380000 - Misc Reimbursements - 92.00 92.00 - 0.00% Total Refunds & Reimbursements - 92.00 92.00 - 0.00% Total Revenue 107,790.21 1,535,836.09 1,322,152.00 (213,684.09) (16.16%) 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 32,033.45 277,033.39 - 277,033.39 314,481.00 37,447.61 11.91% 410002 - Teamster Wages 9,628.80 70,614.81 - 70,614.81 83,012.00 12,397.19 14.93% 410003 - Permanent Part Time 39,803.21 194,550.10 - 194,550.10 231,000.00 36,449.90 15.78% 410004 - Extra & Overtime 811.34 4,429.88 - 4,429.88 4,550.00 120.12 2.64% 410005 - Seasonal & Interns 11,051.85 41,275.93 - 41,275.93 42,950.00 1,674.07 3.90% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 93,328.65 588,504.11 - 588,504.11 676,593.00 88,088.89 13.02% Employee Benefits 411001 - FICA Regular 6,998.40 43,730.00 - 43,730.00 51,936.00 8,206.00 15.80% 411004 - PERF Regular 4,733.80 38,928.97 - 38,928.97 45,131.00 6,202.03 13.74% 411005 - PERF Union 152.65 1,101.27 - 1,101.27 1,317.00 215.73 16.38% 411007 - Unemployment Comp 4.21 34.99 - 34.99 40.00 5.01 12.53% 411008 - Health Insurance 7,694.40 78,196.80 - 78,196.80 92,883.00 14,686.20 15.81% 411009 - Life Insurance 70.00 780.00 - 780.00 960.00 180.00 18.75% 411014 - Parental Leave 147.73 1,222.69 - 1,222.69 1,402.00 179.31 12.79% 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 550.00 - 550.00 660.00 110.00 16.67% Total Employee Benefits 19,856.19 165,926.09 - 165,926.09 195,979.00 30,052.91 15.33% Total Personnel Expenditures 113,184.84 754,430.20 - 754,430.20 872,572.00 118,141.80 13.54% Supplies Expenditures October 31, 2020 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 - 37,546.59 4,434.08 41,980.67 44,001.00 2,020.33 4.59% 422003 - Gasoline - 1,632.26 - 1,632.26 2,000.00 367.74 18.39% 422010 - Plants Chemicals Seed & Fertilizer - 60,628.93 - 60,628.93 66,560.00 5,931.07 8.91% 422014 - Concessions Inventory - 7,358.24 - 7,358.24 8,040.00 681.76 8.48% 422016 - Inventory For Sale - 5,671.26 - 5,671.26 6,000.00 328.74 5.48% Total Operating Supplies - 112,837.28 4,434.08 117,271.36 126,601.00 9,329.64 7.37% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,159.26 18,993.61 1,092.41 20,086.02 22,707.00 2,620.98 11.54% Total Repair & Maintenance Supplies 1,159.26 18,993.61 1,092.41 20,086.02 22,707.00 2,620.98 11.54% Total Supplies Expenditures 1,159.26 132,153.76 5,526.49 137,680.25 149,733.00 12,052.75 8.05% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 115.50 231.00 - 231.00 120.00 (111.00) (92.50%) 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 115.50 509.04 - 509.04 4,220.00 3,710.96 87.94% 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 2,377.52 49,658.26 - 49,658.26 55,556.00 5,897.74 10.62% 435002 - Natural Gas 190.07 15,448.97 - 15,448.97 18,519.00 3,070.03 16.58% Total Utilities 2,567.59 65,107.23 - 65,107.23 74,075.00 8,967.77 12.11% Debt Service 438100 - Principal 79.66 62,155.29 - 62,155.29 62,235.00 79.71 0.13% 438200 - Interest 4.47 11,586.56 - 11,586.56 11,591.00 4.44 0.04% Total Debt Service 84.13 73,741.85 - 73,741.85 73,826.00 84.15 0.11% Other Charges & Services 439000 - Misc Charges & Svcs - 10,669.08 468.80 11,137.88 23,450.00 12,312.12 52.50% 439001 - Other Contractual Services 29.24 260.46 363.04 623.50 1,300.00 676.50 52.04% 439003 - Subscriptions - 210.00 - 210.00 225.00 15.00 6.67% 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 29.24 14,539.72 831.84 15,371.56 35,575.00 20,203.44 56.79% Total Services & Charges Expenditures 2,796.46 154,419.48 831.84 155,251.32 189,186.00 33,934.68 17.94% Other Uses 452002 - Allocations-Admin Cost 4,770.00 47,698.00 - 47,698.00 57,238.00 9,540.00 16.67% 452009 - Allocations-Facilities Mgmt 233.00 2,332.00 - 2,332.00 2,798.00 466.00 16.65% Total Other Uses 5,003.00 50,030.00 - 50,030.00 60,036.00 10,006.00 16.67% Total Expenditures 122,143.56 1,091,033.44 6,358.33 1,097,391.77 1,271,527.00 174,135.23 13.69%