Loading...
HomeMy WebLinkAboutMay 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 27,150.00 256,015.20 172,000.00 (84,015.20) 148.85% 347004 - Golf Green Fees 96,614.85 146,871.85 805,000.00 658,128.15 18.24% 347005 - Golf Cart Rentals 47,263.72 67,789.19 365,000.00 297,210.81 18.57% 347006 - Golf Pro Shop Retail 7,994.51 16,152.90 59,500.00 43,347.10 27.15% 347007 - Golf Driving Range 4,965.00 9,464.00 30,000.00 20,536.00 31.55% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 583.13 2,623.13 - (2,623.13) 0.00% 347012 - Food Sales 8,261.26 12,745.13 53,277.00 40,531.87 23.92% 347013 - Nonalcoholic Beverage 4,367.82 6,506.32 31,500.00 24,993.68 20.65% 347014 - Alcoholic Beverage Sales 21,548.30 31,229.51 110,900.00 79,670.49 28.16% 347026 - Room Rental 4,619.63 10,833.09 10,000.00 (833.09) 108.33% 347100 - Concessions-Employee Discounts (299.42) (411.12) - 411.12 0.00% Total Culture & Recreation 223,068.80 559,854.20 1,637,177.00 1,077,322.80 34.20% Total Charges for Services 223,068.80 559,854.20 1,637,177.00 1,077,322.80 34.20% Miscellaneous Revenue 360000 - Miscellaneous 145.01 208.53 2,500.00 2,291.47 8.34% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 145.01 1,981.15 2,500.00 518.85 79.25% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,008.00 - (4,008.00) 0.00% 396000 - Refunds - 5,672.50 - (5,672.50) 0.00% Total Refunds & Reimbursements - 9,680.50 - (9,680.50) 0.00% Total Revenue 223,213.81 571,515.85 1,639,677.00 1,068,161.15 34.86% 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.79 144,573.75 - 144,573.75 412,922.00 268,348.25 35.01% 410002 - Teamster Wages 3,233.04 17,659.84 - 17,659.84 86,090.00 68,430.16 20.51% 410003 - Permanent Part Time 38,257.28 74,652.07 - 74,652.07 295,201.00 220,548.93 25.29% 410004 - Extra & Overtime 554.78 938.48 - 938.48 2,550.00 1,611.52 36.80% 410005 - Seasonal & Interns 6,859.58 12,623.35 - 12,623.35 41,776.00 29,152.65 30.22% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 75,279.47 250,697.49 - 250,697.49 839,139.00 588,441.51 29.88% Employee Benefits 411001 - FICA Regular 5,630.29 19,605.13 - 19,605.13 64,409.00 44,803.87 30.44% 411004 - PERF Regular 3,354.41 19,563.71 - 19,563.71 56,557.00 36,993.29 34.59% 411005 - PERF Union 52.81 313.39 - 313.39 1,371.00 1,057.61 22.86% 411007 - Unemployment Comp 47.84 237.75 - 237.75 804.00 566.25 29.57% 411008 - Health Insurance 7,967.74 39,796.70 - 39,796.70 121,999.00 82,202.30 32.62% 411009 - Life Insurance 70.00 350.00 - 350.00 1,080.00 730.00 32.41% 411014 - Parental Leave 104.65 570.63 - 570.63 1,759.00 1,188.37 32.44% 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 275.00 - 275.00 660.00 385.00 41.67% Total Employee Benefits 17,282.74 81,427.31 - 81,427.31 250,789.00 169,361.69 32.47% May 31, 2022 Total Personnel Expenses 92,562.21 332,124.80 - 332,124.80 1,089,928.00 757,803.20 30.47% Supplies Expenses Office Supplies 421000 - General Office Supplies 74.99 161.03 - 161.03 1,250.00 1,088.97 12.88% Total Office Supplies 74.99 161.03 - 161.03 1,250.00 1,088.97 12.88% Operating Supplies 422000 - Other Operating Supplies 7,594.64 32,222.13 2,833.41 35,055.54 42,100.00 7,044.46 83.27% 422002 - Diesel/CNG 1,886.00 1,886.00 - 1,886.00 4,000.00 2,114.00 47.15% 422003 - Gasoline 7,657.61 10,462.61 631.50 11,094.11 24,000.00 12,905.89 46.23% 422005 - Uniforms - 111.30 - 111.30 2,200.00 2,088.70 5.06% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer 12,774.65 69,161.89 29,278.01 98,439.90 111,800.00 13,360.10 88.05% 422014 - Concessions Inventory 1,178.62 16,192.96 4,817.55 21,010.51 44,550.00 23,539.49 47.16% 422016 - Inventory For Sale 1,079.80 30,008.84 2,569.00 32,577.84 36,535.00 3,957.16 89.17% Total Operating Supplies 32,171.32 160,095.66 40,129.47 200,225.13 265,685.00 65,459.87 75.36% Repair & Maintenance Supplies 423000 - Other R&M Supplies 8,693.39 22,592.37 10,306.90 32,899.27 43,090.63 10,191.36 76.35% 423009 - Repair Parts 383.10 2,347.71 - 2,347.71 4,100.00 1,752.29 57.26% Total Repair & Maintenance Supplies 9,076.49 24,940.08 10,306.90 35,246.98 47,190.63 11,943.65 74.69% Total Supplies Expenses 41,322.80 185,196.77 50,436.37 235,633.14 314,125.63 78,492.49 75.01% Services & Charges Expenses Professional Services 431000 - Other Professional Services 2,967.84 17,507.49 - 17,507.49 31,680.00 14,172.51 55.26% 431019 - Security Services 481.44 1,815.45 - 1,815.45 1,600.00 (215.45) 113.47% Total Professional Services 3,449.28 19,322.94 - 19,322.94 33,280.00 13,957.06 58.06% Communication & Transportation 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - - 9.13 9.13 409.13 400.00 2.23% Printing & Advertising 433003 - Promotional 1,615.50 19,755.51 - 19,755.51 36,620.00 16,864.49 53.95% Total Printing & Advertising 1,615.50 19,755.51 - 19,755.51 36,620.00 16,864.49 53.95% Utilties 435001 - Electric 3,964.19 19,409.77 - 19,409.77 49,667.00 30,257.23 39.08% 435002 - Natural Gas 1,260.32 12,569.56 - 12,569.56 22,519.00 9,949.44 55.82% Total Utilities 5,224.51 31,979.33 - 31,979.33 72,186.00 40,206.67 44.30% Repairs & Maintenance 436000 - Other R&M 740.00 961.41 6,491.54 7,452.95 12,971.54 5,518.59 57.46% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance 740.00 1,486.11 6,491.54 7,977.65 13,971.54 5,993.89 57.10% Debt Service 438100 - Principal 67,578.98 67,578.98 - 67,578.98 67,579.00 0.02 100.00% 438200 - Interest 5,237.43 5,237.43 - 5,237.43 5,238.00 0.57 99.99% Total Debt Service 72,816.41 72,816.41 - 72,816.41 72,817.00 0.59 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 105.86 1,890.72 - 1,890.72 4,250.00 2,359.28 44.49% 439002 - Licenses & Permits 49.47 2,985.29 - 2,985.29 3,360.00 374.71 88.85% 439003 - Subscriptions - 1,260.70 - 1,260.70 1,500.00 239.30 84.05% 439004 - Dues & Memberships 64.99 346.93 - 346.93 3,000.00 2,653.07 11.56% 439005 - Bank & Credit Card Fees 5,205.26 13,716.34 - 13,716.34 25,270.00 11,553.66 54.28% 439006 - Education & Training - 665.92 - 665.92 800.00 134.08 83.24% 439009 - Trash Removal 3,993.33 6,705.26 - 6,705.26 8,839.15 2,133.89 75.86% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 389.79 265.58 - 265.58 - (265.58) 0.00% 439100 - Refunds/Awards/Indemnities 72.64 110.97 - 110.97 230.00 119.03 48.25% Total Other Services & Charges 9,881.34 27,947.71 18,000.00 45,947.71 65,249.15 19,301.44 70.42% Total Services & Charges Expenses 93,727.04 173,308.01 24,500.67 197,808.68 294,532.82 96,724.14 67.16% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network - - 17,009.17 17,009.17 - (17,009.17) 0.00% Total Machinery & Equipment - - 17,009.17 17,009.17 - (17,009.17) 0.00% Total Capital Expenses - - 17,009.17 17,009.17 - (17,009.17) 0.00% Other Uses 452002 - Allocations-Admin Cost 4,962.00 24,810.00 - 24,810.00 59,544.00 34,734.00 41.67% 452003 - Allocations-IT 5,594.67 27,973.31 - 27,973.31 67,136.00 39,162.69 41.67% 452004 - Allocations-Liability Insurance 870.92 4,354.56 - 4,354.56 10,451.00 6,096.44 41.67% 452009 - Allocations-Facilities Mgmt 295.25 1,476.25 - 1,476.25 3,543.00 2,066.75 41.67% Total Other Uses 11,722.84 58,614.12 - 58,614.12 140,674.00 82,059.88 41.67% Total Expenses 239,334.89 749,243.70 91,946.21 841,189.91 1,839,260.45 998,070.54 45.74%