Loading...
HomeMy WebLinkAboutSept 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 - 162,739.70 165,000.00 2,260.30 1.37% 347004 - Golf Green Fees 133,998.71 709,454.50 550,000.00 (159,454.50) (28.99%) 347005 - Golf Cart Rentals 63,349.44 308,850.75 330,000.00 21,149.25 6.41% 347006 - Golf Pro Shop Retail 10,528.07 45,929.87 60,000.00 14,070.13 23.45% 347007 - Golf Driving Range 6,311.36 29,299.18 20,000.00 (9,299.18) (46.50%) 347008 - Golf Gift Certificate 239.39 1,196.07 5,500.00 4,303.93 78.25% 347009 - Golf Outings - - 5,000.00 5,000.00 100.00% 347012 - Food Sales 9,571.71 41,158.02 60,000.00 18,841.98 31.40% 347013 - Nonalcoholic Beverage 4,679.87 27,399.63 30,000.00 2,600.37 8.67% 347014 - Alcoholic Beverage Sales 20,458.83 94,357.30 90,000.00 (4,357.30) (4.84%) 347026 - Room Rental - 200.00 - (200.00) 0.00% 347999 - Cash Over/Short 78.58 578.71 - (578.71) 0.00% Total Culture & Recreation 249,215.96 1,421,163.73 1,315,500.00 (105,663.73) (8.03%) Total Charges for Services 249,215.96 1,421,163.73 1,315,500.00 (105,663.73) (8.03%) Miscellaneous Revenue 360000 - Miscellaneous 335.97 6,010.14 2,500.00 (3,510.14) (140.41%) Total Miscellaneous Revenue 335.97 6,010.14 2,500.00 (3,510.14) (140.41%) Refunds & Reimbursements 380000 - Misc Reimbursements - 92.00 - (92.00) 0.00% Total Refunds & Reimbursements - 92.00 - (92.00) 0.00% Total Revenue 249,551.93 1,427,265.87 1,318,000.00 (109,265.87) (8.29%) 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 30,246.57 244,999.94 - 244,999.94 314,481.00 69,481.06 22.09% 410002 - Teamster Wages 6,421.00 60,986.01 - 60,986.01 83,012.00 22,025.99 26.53% 410003 - Permanent Part Time 29,622.08 154,746.89 - 154,746.89 231,000.00 76,253.11 33.01% 410004 - Extra & Overtime 934.86 3,618.54 - 3,618.54 4,550.00 931.46 20.47% 410005 - Seasonal & Interns 7,194.33 30,224.08 - 30,224.08 42,950.00 12,725.92 29.63% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 74,418.84 495,175.46 - 495,175.46 676,593.00 181,417.54 26.81% Employee Benefits 411001 - FICA Regular 5,573.87 36,731.60 - 36,731.60 51,936.00 15,204.40 29.28% 411004 - PERF Regular 3,763.30 34,195.17 - 34,195.17 45,131.00 10,935.83 24.23% 411005 - PERF Union 100.91 948.62 - 948.62 1,317.00 368.38 27.97% 411007 - Unemployment Comp 3.71 30.78 - 30.78 40.00 9.22 23.05% 411008 - Health Insurance 7,833.60 70,502.40 - 70,502.40 92,883.00 22,380.60 24.10% 411009 - Life Insurance 70.00 710.00 - 710.00 960.00 250.00 26.04% 411014 - Parental Leave 129.42 1,074.96 - 1,074.96 1,402.00 327.04 23.33% 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 495.00 - 495.00 660.00 165.00 25.00% Total Employee Benefits 17,529.81 146,069.90 - 146,069.90 195,979.00 49,909.10 25.47% Total Personnel Expenditures 91,948.65 641,245.36 - 641,245.36 872,572.00 231,326.64 26.51% September 30, 2020 Supplies Expenditures Office Supplies 421002 - Stationary & Printing - 322.87 - 322.87 1,550.00 1,227.13 79.17% Total Office Supplies - 322.87 - 322.87 1,550.00 1,227.13 0.79 Operating Supplies 422000 - Other Operating Supplies 4,061.35 62,748.29 7,603.21 70,351.50 76,875.00 6,523.50 8.49% 422001 - C.S. Gasoline 792.40 2,578.00 - 2,578.00 2,800.00 222.00 7.93% 422002 - Diesel/CNG 788.80 1,499.20 - 1,499.20 1,710.00 210.80 12.33% 422003 - Gasoline - 10,164.16 - 10,164.16 19,500.00 9,335.84 47.88% 422005 - Uniforms 1,500.00 2,574.00 991.50 3,565.50 4,600.00 1,034.50 22.49% 422010 - Plants Chemicals Seed & Fertilizer 8,640.70 83,384.27 523.71 83,907.98 98,055.00 14,147.02 14.43% 422014 - Concessions Inventory 19,983.31 60,587.66 11,167.04 71,754.70 72,040.00 285.30 0.40% 422016 - Inventory For Sale 1,604.46 25,029.03 - 25,029.03 38,000.00 12,970.97 34.13% Total Operating Supplies 37,371.02 248,564.61 20,285.46 268,850.07 313,580.00 44,729.93 14.26% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,424.41 31,896.62 2,431.66 34,328.28 44,034.00 9,705.72 22.04% 423001 - Building Materials - 389.90 - 389.90 1,000.00 610.10 61.01% 423009 - Repair Parts 1,162.25 5,285.23 136.18 5,421.41 5,610.00 188.59 3.36% Total Repair & Maintenance Supplies 3,586.66 37,571.75 2,567.84 40,139.59 50,644.00 10,504.41 20.74% Total Supplies Expenditures 40,957.68 286,459.23 22,853.30 309,312.53 365,774.00 56,461.47 15.44% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,089.82 2,342.99 (260.00) 2,082.99 1,950.00 (132.99) (6.82%) 431009 - Computer & Technology - 58.48 - 58.48 100.00 41.52 41.52% 431019 - Security Services 52.48 1,785.31 - 1,785.31 6,443.00 4,657.69 72.29% Total Professional Services 1,142.30 4,186.78 (260.00) 3,926.78 8,493.00 4,566.22 53.76% 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 719.64 47,280.74 - 47,280.74 55,556.00 8,275.26 14.90% 435002 - Natural Gas 118.88 15,258.90 - 15,258.90 18,519.00 3,260.10 17.60% Total Utilities 838.52 62,539.64 - 62,539.64 74,075.00 11,535.36 15.57% Repairs & Maintenance 436005 - Other Equip R&M - 750.00 - 750.00 800.00 50.00 6.25% Total Repairs & Maintenance - 750.00 - 750.00 800.00 50.00 6.25% Rentals 437002 - Equipment Rental - 153.90 - 153.90 200.00 46.10 23.05% Total Rentals - 153.90 - 153.90 200.00 46.10 23.05% Debt Service 438100 - Principal 79.34 62,075.63 - 62,075.63 62,235.00 159.37 0.26% 438200 - Interest 4.78 11,582.09 - 11,582.09 11,591.00 8.91 0.08% Total Debt Service 84.12 73,657.72 - 73,657.72 73,826.00 168.28 0.23% Other Charges & Services 439000 - Misc Charges & Svcs 6,030.58 20,592.31 4,000.12 24,592.43 52,347.00 27,754.57 53.02% 439001 - Other Contractual Services 29.24 231.22 392.28 623.50 1,300.00 676.50 52.04% 439003 - Subscriptions - 443.18 - 443.18 465.00 21.82 4.69% 439004 - Dues & Memberships - 1,755.00 - 1,755.00 4,000.00 2,245.00 56.13% 439005 - Bank & Credit Card Fees 5,592.46 22,042.70 - 22,042.70 26,685.00 4,642.30 17.40% 439006 - Education & Training 49.47 208.88 - 208.88 250.00 41.12 16.45% 439009 - Trash Removal - 2,410.38 1,698.49 4,108.87 9,360.00 5,251.13 56.10% 439100 - Refunds/Awards/Indemnities - - - - 200.00 200.00 100.00% Total Other Services & Charges 11,701.75 47,683.67 6,090.89 53,774.56 94,607.00 40,832.44 43.16% Total Services & Charges Expenditures 13,766.69 189,493.35 5,830.89 195,324.24 253,491.00 58,166.76 22.95% Other Uses 452002 - Allocations-Admin Cost 4,770.00 42,928.00 - 42,928.00 57,238.00 14,310.00 25.00% 452009 - Allocations-Facilities Mgmt 233.00 2,099.00 - 2,099.00 2,798.00 699.00 24.98% Total Other Uses 5,003.00 45,027.00 - 45,027.00 60,036.00 15,009.00 25.00% Total Expenditures 151,676.02 1,162,224.94 28,684.19 1,190,909.13 1,551,873.00 360,963.87 23.26%