Loading...
HomeMy WebLinkAboutNov 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 450.00 269,622.20 172,000.00 (97,622.20) 156.76% 347004 - Golf Green Fees 20,636.00 852,695.32 805,000.00 (47,695.32) 105.92% 347005 - Golf Cart Rentals 20,170.03 396,828.94 365,000.00 (31,828.94) 108.72% 347006 - Golf Pro Shop Retail 3,767.20 74,150.11 59,500.00 (14,650.11) 124.62% 347007 - Golf Driving Range 1,098.00 41,429.00 30,000.00 (11,429.00) 138.10% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings - 7,808.89 - (7,808.89) 0.00% 347012 - Food Sales 2,247.50 74,063.11 53,277.00 (20,786.11) 139.02% 347013 - Nonalcoholic Beverage 1,040.89 40,576.03 31,500.00 (9,076.03) 128.81% 347014 - Alcoholic Beverage Sales 4,944.05 155,131.44 110,900.00 (44,231.44) 139.88% 347026 - Room Rental - 19,191.49 10,000.00 (9,191.49) 191.91% 347100 - Concessions-Employee Discounts (84.62) (1,909.84) - 1,909.84 0.00% Total Culture & Recreation 54,269.05 1,929,621.69 1,637,177.00 (292,444.69) 117.86% Total Charges for Services 54,269.05 1,929,621.69 1,637,177.00 (292,444.69) 117.86% Fines, Forefeitures, Fees 351002 - Bad Checks Fines - 24.00 - (24.00) 0.00% Total Fines, Forfeitures, Fees - 24.00 - (24.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 191.44 3,578.60 2,500.00 (1,078.60) 143.14% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 191.44 5,351.22 2,500.00 (2,851.22) 214.05% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,056.44 4,008.00 (48.44) 101.21% 396000 - Refunds 475.00 8,611.40 5,673.00 (2,938.40) 151.80% Total Refunds & Reimbursements 475.00 12,667.84 9,681.00 (2,986.84) 130.85% Total Revenue 54,935.49 1,947,664.75 1,649,358.00 (298,306.75) 118.09% 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,374.84 317,579.33 - 317,579.33 412,922.00 95,342.67 76.91% 410002 - Teamster Wages 6,434.95 58,290.15 - 58,290.15 86,090.00 27,799.85 67.71% 410003 - Permanent Part Time 20,773.06 323,732.89 - 323,732.89 292,076.00 (31,656.89) 110.84% 410004 - Extra & Overtime 128.47 5,680.32 - 5,680.32 5,675.00 (5.32) 100.09% 410005 - Seasonal & Interns 3,307.01 51,620.38 - 51,620.38 41,776.00 (9,844.38) 123.56% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 57,018.33 757,153.07 - 757,153.07 839,139.00 81,985.93 90.23% Employee Benefits 411001 - FICA Regular 4,225.01 57,540.39 - 57,540.39 64,409.00 6,868.61 89.34% 411004 - PERF Regular 3,659.47 43,534.81 - 43,534.81 56,557.00 13,022.19 76.98% 411005 - PERF Union 49.64 660.59 - 660.59 1,371.00 710.41 48.18% 411007 - Unemployment Comp 3.30 413.65 - 413.65 804.00 390.35 51.45% 411008 - Health Insurance 9,060.94 92,466.54 - 92,466.54 121,999.00 29,532.46 75.79% 411009 - Life Insurance 80.00 815.00 - 815.00 1,080.00 265.00 75.46% 411014 - Parental Leave 115.33 1,342.59 - 1,342.59 1,759.00 416.41 76.33% 411015 - Other Fringe Benefits - 290.00 - 290.00 300.00 10.00 96.67% November 30, 2022 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 605.00 - 605.00 660.00 55.00 91.67% Total Employee Benefits 17,248.69 198,093.57 - 198,093.57 250,789.00 52,695.43 78.99% Total Personnel Expenses 74,267.02 955,246.64 - 955,246.64 1,089,928.00 134,681.36 87.64% Supplies Expenses Office Supplies 421000 - General Office Supplies 129.63 1,790.22 - 1,790.22 750.00 (1,040.22) 238.70% Total Office Supplies 129.63 1,790.22 - 1,790.22 750.00 (1,040.22) 238.70% Operating Supplies 422000 - Other Operating Supplies 3,874.93 67,535.67 8,669.47 76,205.14 40,450.00 (35,755.14) 188.39% 422002 - Diesel/CNG 2,303.18 11,764.45 2,349.00 14,113.45 4,000.00 (10,113.45) 352.84% 422003 - Gasoline 4,548.25 22,948.43 1,811.10 24,759.53 23,500.00 (1,259.53) 105.36% 422005 - Uniforms 370.40 1,796.79 - 1,796.79 1,095.00 (701.79) 164.09% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer - 91,965.20 24,744.01 116,709.21 113,600.00 (3,109.21) 102.74% 422013 - Promotional Supplies (0.11) 499.80 - 499.80 - (499.80) 0.00% 422014 - Concessions Inventory 3,216.69 118,889.65 1,359.96 120,249.61 51,905.00 (68,344.61) 231.67% 422016 - Inventory For Sale 1,268.11 53,317.62 6,621.21 59,938.83 34,035.00 (25,903.83) 176.11% Total Operating Supplies 15,581.45 368,767.54 45,554.75 414,322.29 269,085.00 (145,237.29) 153.97% Repair & Maintenance Supplies 423000 - Other R&M Supplies 3,635.18 59,501.25 2,686.93 62,188.18 41,590.63 (20,597.55) 149.52% 423009 - Repair Parts 76.11 2,555.80 - 2,555.80 2,700.00 144.20 94.66% Total Repair & Maintenance Supplies 3,711.29 62,057.05 2,686.93 64,743.98 44,290.63 (20,453.35) 146.18% Total Supplies Expenses 19,422.37 432,614.81 48,241.68 480,856.49 314,125.63 (166,730.86) 153.08% Services & Charges Expenses Professional Services 431000 - Other Professional Services 1,593.55 42,498.01 - 42,498.01 30,380.00 (12,118.01) 139.89% 431019 - Security Services 484.77 4,037.67 - 4,037.67 1,900.00 (2,137.67) 212.51% Total Professional Services 2,078.32 46,535.68 - 46,535.68 32,280.00 (14,255.68) 144.16% Communication & Transportation 432002 - Mailing - 9.25 188.24 197.49 - (197.49) 0.00% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - 9.25 197.37 206.62 409.13 202.51 50.50% Printing & Advertising 433001 - Outside Printing Services - 3,492.73 - 3,492.73 - (3,492.73) 0.00% 433003 - Promotional 2,345.00 32,466.08 400.00 32,866.08 32,620.00 (246.08) 100.75% Total Printing & Advertising 2,345.00 35,958.81 400.00 36,358.81 32,620.00 (3,738.81) 111.46% Utilties 435001 - Electric 5,794.19 61,331.67 - 61,331.67 49,667.00 (11,664.67) 123.49% 435002 - Natural Gas 1,466.88 16,495.47 - 16,495.47 22,519.00 6,023.53 73.25% Total Utilities 7,261.07 77,827.14 - 77,827.14 72,186.00 (5,641.14) 107.81% Repairs & Maintenance 436000 - Other R&M - 6,619.57 6,491.54 13,111.11 12,971.54 (139.57) 101.08% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance - 7,144.27 6,491.54 13,635.81 13,971.54 335.73 97.60% Rentals 437002 - Equipment Rental 556.50 556.50 - 556.50 - (556.50) 0.00% Total Rentals 556.50 556.50 - 556.50 - (556.50) 0.00% 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 183.87 4,374.60 - 4,374.60 4,350.00 (24.60) 100.57% 439002 - Licenses & Permits - 3,493.63 2,000.00 5,493.63 3,360.00 (2,133.63) 163.50% 439003 - Subscriptions 64.99 1,660.39 - 1,660.39 1,500.00 (160.39) 110.69% 439004 - Dues & Memberships 119.40 1,171.33 - 1,171.33 3,200.00 2,028.67 36.60% 439005 - Bank & Credit Card Fees 1,348.09 46,316.41 - 46,316.41 25,270.00 (21,046.41) 183.29% 439006 - Education & Training - 1,180.92 - 1,180.92 800.00 (380.92) 147.62% 439009 - Trash Removal - 14,224.41 366.22 14,590.63 13,339.15 (1,251.48) 109.38% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (269.59) (543.74) - (543.74) - 543.74 0.00% 439100 - Refunds/Awards/Indemnities 45.56 960.81 - 960.81 430.00 (530.81) 223.44% Total Other Services & Charges 1,492.32 72,838.76 20,366.22 93,204.98 70,249.15 (22,955.83) 132.68% Total Services & Charges Expenses 13,733.21 313,686.82 27,455.13 341,141.95 294,532.82 (46,609.13) 115.82% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Machinery & Equipment - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Capital Expenses - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Other Uses 452002 - Allocations-Admin Cost - 49,620.00 - 49,620.00 59,544.00 9,924.00 83.33% 452003 - Allocations-IT - 55,946.66 - 55,946.66 67,136.00 11,189.34 83.33% 452004 - Allocations-Liability Insurance - 8,709.16 - 8,709.16 10,451.00 1,741.84 83.33% 452009 - Allocations-Facilities Mgmt - 2,952.50 - 2,952.50 3,543.00 590.50 83.33% Total Other Uses - 117,228.32 - 117,228.32 140,674.00 23,445.68 83.33% Bad Debt Expense 490000 - Bad Debt Expense - 100.00 - 100.00 - (100.00) 0.00% Total Bad Debt Expense - 100.00 - 100.00 - (100.00) 0.00% Total Expenses 107,422.60 1,835,883.71 75,696.81 1,911,580.52 1,856,271.45 (55,309.07) 102.98%