Loading...
HomeMy WebLinkAboutJune 22 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 11,097.00 267,112.20 172,000.00 (95,112.20) 155.30% 347004 - Golf Green Fees 176,497.76 323,369.61 805,000.00 481,630.39 40.17% 347005 - Golf Cart Rentals 75,921.09 143,710.28 365,000.00 221,289.72 39.37% 347006 - Golf Pro Shop Retail 13,725.69 29,878.59 59,500.00 29,621.41 50.22% 347007 - Golf Driving Range 7,821.00 17,285.00 30,000.00 12,715.00 57.62% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 1,655.70 4,278.83 - (4,278.83) 0.00% 347012 - Food Sales 13,655.46 26,400.59 53,277.00 26,876.41 49.55% 347013 - Nonalcoholic Beverage 8,568.26 15,074.58 31,500.00 16,425.42 47.86% 347014 - Alcoholic Beverage Sales 27,921.84 59,151.35 110,900.00 51,748.65 53.34% 347026 - Room Rental 671.00 11,504.09 10,000.00 (1,504.09) 115.04% 347100 - Concessions-Employee Discounts (371.20) (782.32) - 782.32 0.00% Total Culture & Recreation 337,163.60 897,017.80 1,637,177.00 740,159.20 54.79% Total Charges for Services 337,163.60 897,017.80 1,637,177.00 740,159.20 54.79% Miscellaneous Revenue 360000 - Miscellaneous 256.43 464.96 2,500.00 2,035.04 18.60% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 256.43 2,237.58 2,500.00 262.42 89.50% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,008.00 4,008.00 - 100.00% 396000 - Refunds - 5,672.50 5,673.00 0.50 99.99% Total Refunds & Reimbursements - 9,680.50 9,681.00 0.50 99.99% Total Revenue 337,420.03 908,935.88 1,649,358.00 740,422.12 55.11% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 26,732.89 171,306.64 - 171,306.64 412,922.00 241,615.36 41.49% 410002 - Teamster Wages 4,110.45 21,770.29 - 21,770.29 86,090.00 64,319.71 25.29% 410003 - Permanent Part Time 42,625.42 117,277.49 - 117,277.49 292,076.00 174,798.51 40.15% 410004 - Extra & Overtime 1,597.49 2,535.97 - 2,535.97 5,675.00 3,139.03 44.69% 410005 - Seasonal & Interns 7,171.01 19,794.36 - 19,794.36 41,776.00 21,981.64 47.38% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 82,237.26 332,934.75 - 332,934.75 839,139.00 506,204.25 39.68% Employee Benefits 411001 - FICA Regular 6,163.24 25,768.37 - 25,768.37 64,409.00 38,640.63 40.01% 411004 - PERF Regular 3,454.37 23,018.08 - 23,018.08 56,557.00 33,538.92 40.70% 411005 - PERF Union 60.82 374.21 - 374.21 1,371.00 996.79 27.29% 411007 - Unemployment Comp 52.00 289.75 - 289.75 804.00 514.25 36.04% 411008 - Health Insurance 7,967.74 47,764.44 - 47,764.44 121,999.00 74,234.56 39.15% 411009 - Life Insurance 70.00 420.00 - 420.00 1,080.00 660.00 38.89% 411014 - Parental Leave 110.49 681.12 - 681.12 1,759.00 1,077.88 38.72% 411015 - Other Fringe Benefits - 290.00 - 290.00 300.00 10.00 96.67% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,050.00 625.00 40.48% 411206 - Cell Phone Allowance 55.00 330.00 - 330.00 660.00 330.00 50.00% Total Employee Benefits 17,933.66 99,360.97 - 99,360.97 250,789.00 151,428.03 39.62% June 30, 2022 Total Personnel Expenses 100,170.92 432,295.72 - 432,295.72 1,089,928.00 657,632.28 39.66% Supplies Expenses Office Supplies 421000 - General Office Supplies 56.12 217.15 - 217.15 750.00 532.85 28.95% Total Office Supplies 56.12 217.15 - 217.15 750.00 532.85 28.95% Operating Supplies 422000 - Other Operating Supplies 4,448.10 36,670.23 2,436.66 39,106.89 40,450.00 1,343.11 96.68% 422002 - Diesel/CNG - 1,886.00 1,693.50 3,579.50 4,000.00 420.50 89.49% 422003 - Gasoline - 10,462.61 2,251.50 12,714.11 23,500.00 10,785.89 54.10% 422005 - Uniforms - 111.30 - 111.30 1,095.00 983.70 10.16% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer 4,717.98 73,879.87 36,964.51 110,844.38 113,600.00 2,755.62 97.57% 422014 - Concessions Inventory 26,001.27 42,194.23 5,355.55 47,549.78 51,905.00 4,355.22 91.61% 422016 - Inventory For Sale 2,807.78 32,816.62 209.00 33,025.62 34,035.00 1,009.38 97.03% Total Operating Supplies 37,975.13 198,070.79 48,910.72 246,981.51 269,085.00 22,103.49 91.79% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,630.98 25,223.35 16,006.90 41,230.25 41,590.63 360.38 99.13% 423009 - Repair Parts 131.98 2,479.69 - 2,479.69 2,700.00 220.31 91.84% Total Repair & Maintenance Supplies 2,762.96 27,703.04 16,006.90 43,709.94 44,290.63 580.69 98.69% Total Supplies Expenses 40,794.21 225,990.98 64,917.62 290,908.60 314,125.63 23,217.03 92.61% Services & Charges Expenses Professional Services 431000 - Other Professional Services 2,039.22 19,546.71 7,790.00 27,336.71 30,880.00 3,543.29 88.53% 431019 - Security Services 313.02 2,128.47 - 2,128.47 1,900.00 (228.47) 112.02% Total Professional Services 2,352.24 21,675.18 7,790.00 29,465.18 32,780.00 3,314.82 89.89% Communication & Transportation 432002 - Mailing 9.25 9.25 - 9.25 - (9.25) 0.00% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation 9.25 9.25 9.13 18.38 409.13 390.75 4.49% Printing & Advertising 433001 - Outside Printing Services 1,031.31 1,031.31 - 1,031.31 - (1,031.31) 0.00% 433003 - Promotional 1,030.89 20,786.40 - 20,786.40 36,620.00 15,833.60 56.76% Total Printing & Advertising 2,062.20 21,817.71 - 21,817.71 36,620.00 14,802.29 59.58% Utilties 435001 - Electric 8,972.84 28,382.61 - 28,382.61 49,667.00 21,284.39 57.15% 435002 - Natural Gas 472.89 13,042.45 - 13,042.45 22,519.00 9,476.55 57.92% Total Utilities 9,445.73 41,425.06 - 41,425.06 72,186.00 30,760.94 57.39% Repairs & Maintenance 436000 - Other R&M 335.50 1,296.91 6,491.54 7,788.45 12,971.54 5,183.09 60.04% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance 335.50 1,821.61 6,491.54 8,313.15 13,971.54 5,658.39 59.50% Debt Service 438100 - Principal - 67,578.98 - 67,578.98 67,579.00 0.02 100.00% 438200 - Interest - 5,237.43 - 5,237.43 5,238.00 0.57 99.99% Total Debt Service - 72,816.41 - 72,816.41 72,817.00 0.59 100.00% Other Charges & Services 439000 - Misc Charges & Svcs - 1,890.72 - 1,890.72 4,350.00 2,459.28 43.46% 439002 - Licenses & Permits - 2,985.29 - 2,985.29 3,360.00 374.71 88.85% 439003 - Subscriptions 152.92 1,413.62 - 1,413.62 1,500.00 86.38 94.24% 439004 - Dues & Memberships - 346.93 - 346.93 3,200.00 2,853.07 10.84% 439005 - Bank & Credit Card Fees 8,081.78 21,798.12 - 21,798.12 25,270.00 3,471.88 86.26% 439006 - Education & Training 515.00 1,180.92 - 1,180.92 800.00 (380.92) 147.62% 439009 - Trash Removal - 6,705.26 1,253.35 7,958.61 8,839.15 880.54 90.04% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (548.81) (283.23) - (283.23) - 283.23 0.00% 439100 - Refunds/Awards/Indemnities 106.76 217.73 - 217.73 430.00 212.27 50.63% Total Other Services & Charges 8,307.65 36,255.36 19,253.35 55,508.71 65,749.15 10,240.44 84.42% Total Services & Charges Expenses 22,512.57 195,820.58 33,544.02 229,364.60 294,532.82 65,168.22 77.87% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network - - 17,009.17 17,009.17 17,011.00 1.83 99.99% Total Machinery & Equipment - - 17,009.17 17,009.17 17,011.00 1.83 99.99% Total Capital Expenses - - 17,009.17 17,009.17 17,011.00 1.83 99.99% Other Uses 452002 - Allocations-Admin Cost 4,962.00 29,772.00 - 29,772.00 59,544.00 29,772.00 50.00% 452003 - Allocations-IT 5,594.67 33,567.98 - 33,567.98 67,136.00 33,568.02 50.00% 452004 - Allocations-Liability Insurance 870.92 5,225.48 - 5,225.48 10,451.00 5,225.52 50.00% 452009 - Allocations-Facilities Mgmt 295.25 1,771.50 - 1,771.50 3,543.00 1,771.50 50.00% Total Other Uses 11,722.84 70,336.96 - 70,336.96 140,674.00 70,337.04 50.00% Total Expenses 175,200.54 924,444.24 115,470.81 1,039,915.05 1,856,271.45 816,356.40 56.02%