Loading...
HomeMy WebLinkAboutJuly 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 1,382.00 268,494.20 172,000.00 (96,494.20) 156.10% 347004 - Golf Green Fees 148,057.42 471,427.03 805,000.00 333,572.97 58.56% 347005 - Golf Cart Rentals 67,707.12 211,417.40 365,000.00 153,582.60 57.92% 347006 - Golf Pro Shop Retail 12,996.84 42,875.43 59,500.00 16,624.57 72.06% 347007 - Golf Driving Range 7,545.00 24,830.00 30,000.00 5,170.00 82.77% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 2,548.91 6,827.74 - (6,827.74) 0.00% 347012 - Food Sales 12,285.43 38,686.02 53,277.00 14,590.98 72.61% 347013 - Nonalcoholic Beverage 7,646.23 22,720.81 31,500.00 8,779.19 72.13% 347014 - Alcoholic Beverage Sales 27,707.45 86,858.80 110,900.00 24,041.20 78.32% 347026 - Room Rental - 11,504.09 10,000.00 (1,504.09) 115.04% 347100 - Concessions-Employee Discounts (318.62) (1,100.94) - 1,100.94 0.00% Total Culture & Recreation 287,557.78 1,184,575.58 1,637,177.00 452,601.42 72.35% Total Charges for Services 287,557.78 1,184,575.58 1,637,177.00 452,601.42 72.35% Miscellaneous Revenue 360000 - Miscellaneous 2,106.54 2,571.50 2,500.00 (71.50) 102.86% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 2,106.54 4,344.12 2,500.00 (1,844.12) 173.76% Refunds & Reimbursements 380000 - Misc Reimbursements 48.44 4,056.44 4,008.00 (48.44) 101.21% 396000 - Refunds 2,463.90 8,136.40 5,673.00 (2,463.40) 143.42% Total Refunds & Reimbursements 2,512.34 12,192.84 9,681.00 (2,511.84) 125.95% Total Revenue 292,176.66 1,201,112.54 1,649,358.00 448,245.46 72.82% 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,834.32 198,140.96 - 198,140.96 412,922.00 214,781.04 47.99% 410002 - Teamster Wages 6,808.28 28,578.57 - 28,578.57 86,090.00 57,511.43 33.20% 410003 - Permanent Part Time 45,891.00 163,168.49 - 163,168.49 292,076.00 128,907.51 55.87% 410004 - Extra & Overtime 1,226.96 3,762.93 - 3,762.93 5,675.00 1,912.07 66.31% 410005 - Seasonal & Interns 6,403.94 26,198.30 - 26,198.30 41,776.00 15,577.70 62.71% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 87,164.50 420,099.25 - 420,099.25 839,139.00 419,039.75 50.06% Employee Benefits 411001 - FICA Regular 6,535.70 32,304.07 - 32,304.07 64,409.00 32,104.93 50.15% 411004 - PERF Regular 3,430.44 26,448.52 - 26,448.52 56,557.00 30,108.48 46.76% 411005 - PERF Union 56.09 430.30 - 430.30 1,371.00 940.70 31.39% 411007 - Unemployment Comp 56.16 345.91 - 345.91 804.00 458.09 43.02% 411008 - Health Insurance 8,510.84 56,275.28 - 56,275.28 121,999.00 65,723.72 46.13% 411009 - Life Insurance 75.00 495.00 - 495.00 1,080.00 585.00 45.83% 411014 - Parental Leave 119.08 800.20 - 800.20 1,759.00 958.80 45.49% 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 385.00 - 385.00 660.00 275.00 58.33% Total Employee Benefits 18,838.31 118,199.28 - 118,199.28 250,789.00 132,589.72 47.13% July 31, 2022 Total Personnel Expenses 106,002.81 538,298.53 - 538,298.53 1,089,928.00 551,629.47 49.39% Supplies Expenses Office Supplies 421000 - General Office Supplies 262.25 479.40 - 479.40 750.00 270.60 63.92% Total Office Supplies 262.25 479.40 - 479.40 750.00 270.60 63.92% Operating Supplies 422000 - Other Operating Supplies 7,550.79 44,221.02 4,077.72 48,298.74 40,450.00 (7,848.74) 119.40% 422002 - Diesel/CNG - 1,886.00 3,546.27 5,432.27 4,000.00 (1,432.27) 135.81% 422003 - Gasoline - 10,462.61 4,919.82 15,382.43 23,500.00 8,117.57 65.46% 422005 - Uniforms 311.09 422.39 - 422.39 1,095.00 672.61 38.57% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer 12,600.15 86,480.02 24,744.01 111,224.03 113,600.00 2,375.97 97.91% 422014 - Concessions Inventory 12,757.28 54,951.51 10,135.16 65,086.67 51,905.00 (13,181.67) 125.40% 422016 - Inventory For Sale 4,452.66 37,269.28 - 37,269.28 34,035.00 (3,234.28) 109.50% Total Operating Supplies 37,671.97 235,742.76 47,422.98 283,165.74 269,085.00 (14,080.74) 105.23% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,327.69 34,551.04 8,081.40 42,632.44 41,590.63 (1,041.81) 102.50% 423009 - Repair Parts - 2,479.69 - 2,479.69 2,700.00 220.31 91.84% Total Repair & Maintenance Supplies 9,327.69 37,030.73 8,081.40 45,112.13 44,290.63 (821.50) 101.85% Total Supplies Expenses 47,261.91 273,252.89 55,504.38 328,757.27 314,125.63 (14,631.64) 104.66% Services & Charges Expenses Professional Services 431000 - Other Professional Services 10,369.94 29,916.65 580.00 30,496.65 30,380.00 (116.65) 100.38% 431019 - Security Services 274.77 2,403.24 - 2,403.24 1,900.00 (503.24) 126.49% Total Professional Services 10,644.71 32,319.89 580.00 32,899.89 32,280.00 (619.89) 101.92% Communication & Transportation 432002 - Mailing - 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.13 18.38 409.13 390.75 4.49% Printing & Advertising 433001 - Outside Printing Services 2,461.42 3,492.73 - 3,492.73 - (3,492.73) 0.00% 433003 - Promotional 5,182.94 25,969.34 - 25,969.34 32,620.00 6,650.66 79.61% Total Printing & Advertising 7,644.36 29,462.07 - 29,462.07 32,620.00 3,157.93 90.32% Utilties 435001 - Electric 7,048.49 35,431.10 - 35,431.10 49,667.00 14,235.90 71.34% 435002 - Natural Gas 328.31 13,370.76 - 13,370.76 22,519.00 9,148.24 59.38% Total Utilities 7,376.80 48,801.86 - 48,801.86 72,186.00 23,384.14 67.61% Repairs & Maintenance 436000 - Other R&M - 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 - 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 151.50 2,042.22 - 2,042.22 4,350.00 2,307.78 46.95% 439002 - Licenses & Permits 494.57 3,479.86 - 3,479.86 3,360.00 (119.86) 103.57% 439003 - Subscriptions 77.94 1,491.56 - 1,491.56 1,500.00 8.44 99.44% 439004 - Dues & Memberships - 346.93 - 346.93 3,200.00 2,853.07 10.84% 439005 - Bank & Credit Card Fees 6,726.53 28,524.65 - 28,524.65 25,270.00 (3,254.65) 112.88% 439006 - Education & Training - 1,180.92 - 1,180.92 800.00 (380.92) 147.62% 439009 - Trash Removal 1,480.44 8,185.70 1,451.76 9,637.46 13,339.15 3,701.69 72.25% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (128.19) (411.42) - (411.42) - 411.42 0.00% 439100 - Refunds/Awards/Indemnities 465.38 683.11 - 683.11 430.00 (253.11) 158.86% Total Other Services & Charges 9,268.17 45,523.53 19,451.76 64,975.29 70,249.15 5,273.86 92.49% Total Services & Charges Expenses 34,934.04 230,754.62 26,532.43 257,287.05 294,532.82 37,245.77 87.35% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network 17,007.12 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Machinery & Equipment 17,007.12 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Capital Expenses 17,007.12 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Other Uses 452002 - Allocations-Admin Cost 4,962.00 34,734.00 - 34,734.00 59,544.00 24,810.00 58.33% 452003 - Allocations-IT 5,594.67 39,162.65 - 39,162.65 67,136.00 27,973.35 58.33% 452004 - Allocations-Liability Insurance 870.92 6,096.40 - 6,096.40 10,451.00 4,354.60 58.33% 452009 - Allocations-Facilities Mgmt 295.25 2,066.75 - 2,066.75 3,543.00 1,476.25 58.33% Total Other Uses 11,722.84 82,059.80 - 82,059.80 140,674.00 58,614.20 58.33% Total Expenses 216,928.72 1,141,372.96 82,036.81 1,223,409.77 1,856,271.45 632,861.68 65.91%