Loading...
HomeMy WebLinkAboutAug 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 678.00 269,172.20 172,000.00 (97,172.20) 156.50% 347004 - Golf Green Fees 180,559.23 651,986.26 805,000.00 153,013.74 80.99% 347005 - Golf Cart Rentals 82,890.99 294,308.39 365,000.00 70,691.61 80.63% 347006 - Golf Pro Shop Retail 14,375.59 57,251.02 59,500.00 2,248.98 96.22% 347007 - Golf Driving Range 7,806.00 32,636.00 30,000.00 (2,636.00) 108.79% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 981.15 7,808.89 - (7,808.89) 0.00% 347012 - Food Sales 14,763.43 53,449.45 53,277.00 (172.45) 100.32% 347013 - Nonalcoholic Beverage 9,041.10 31,761.91 31,500.00 (261.91) 100.83% 347014 - Alcoholic Beverage Sales 29,677.91 116,536.71 110,900.00 (5,636.71) 105.08% 347026 - Room Rental 1,250.00 12,754.09 10,000.00 (2,754.09) 127.54% 347100 - Concessions-Employee Discounts (324.70) (1,425.64) - 1,425.64 0.00% Total Culture & Recreation 341,698.70 1,526,274.28 1,637,177.00 110,902.72 93.23% Total Charges for Services 341,698.70 1,526,274.28 1,637,177.00 110,902.72 93.23% Fines, Forefeitures, Fees 351002 - Bad Checks Fines 24.00 24.00 - (24.00) 0.00% Total Fines, Forfeitures, Fees 24.00 24.00 - (24.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 349.54 2,921.04 2,500.00 (421.04) 116.84% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 349.54 4,693.66 2,500.00 (2,193.66) 187.75% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,056.44 4,008.00 (48.44) 101.21% 396000 - Refunds - 8,136.40 5,673.00 (2,463.40) 143.42% Total Refunds & Reimbursements - 12,192.84 9,681.00 (2,511.84) 125.95% Total Revenue 342,072.24 1,543,184.78 1,649,358.00 106,173.22 93.56% 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 27,055.00 225,195.96 - 225,195.96 412,922.00 187,726.04 54.54% 410002 - Teamster Wages 6,806.40 35,384.97 - 35,384.97 86,090.00 50,705.03 41.10% 410003 - Permanent Part Time 45,788.12 208,956.61 - 208,956.61 292,076.00 83,119.39 71.54% 410004 - Extra & Overtime 989.03 4,751.96 - 4,751.96 5,675.00 923.04 83.73% 410005 - Seasonal & Interns 6,416.13 32,614.43 - 32,614.43 41,776.00 9,161.57 78.07% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 87,054.68 507,153.93 - 507,153.93 839,139.00 331,985.07 60.44% Employee Benefits 411001 - FICA Regular 6,523.07 38,827.14 - 38,827.14 64,409.00 25,581.86 60.28% 411004 - PERF Regular 3,438.03 29,886.55 - 29,886.55 56,557.00 26,670.45 52.84% 411005 - PERF Union 53.80 484.10 - 484.10 1,371.00 886.90 35.31% 411007 - Unemployment Comp 55.52 401.43 - 401.43 804.00 402.57 49.93% 411008 - Health Insurance 9,053.94 65,329.22 - 65,329.22 121,999.00 56,669.78 53.55% 411009 - Life Insurance 80.00 575.00 - 575.00 1,080.00 505.00 53.24% 411014 - Parental Leave 119.31 919.51 - 919.51 1,759.00 839.49 52.27% 411015 - Other Fringe Benefits - 290.00 - 290.00 300.00 10.00 96.67% August 31, 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 440.00 - 440.00 660.00 220.00 66.67% Total Employee Benefits 19,378.67 137,577.95 - 137,577.95 250,789.00 113,211.05 54.86% Total Personnel Expenses 106,433.35 644,731.88 - 644,731.88 1,089,928.00 445,196.12 59.15% Supplies Expenses Office Supplies 421000 - General Office Supplies 139.59 618.99 - 618.99 750.00 131.01 82.53% Total Office Supplies 139.59 618.99 - 618.99 750.00 131.01 82.53% Operating Supplies 422000 - Other Operating Supplies 7,129.73 51,350.75 1,334.11 52,684.86 40,450.00 (12,234.86) 130.25% 422002 - Diesel/CNG 3,546.27 5,432.27 2,331.92 7,764.19 4,000.00 (3,764.19) 194.10% 422003 - Gasoline 4,344.07 14,806.68 5,381.50 20,188.18 23,500.00 3,311.82 85.91% 422005 - Uniforms 317.79 740.18 - 740.18 1,095.00 354.82 67.60% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer 2,035.68 88,515.70 27,638.01 116,153.71 113,600.00 (2,553.71) 102.25% 422013 - Promotional Supplies 459.91 459.91 - 459.91 - (459.91) 0.00% 422014 - Concessions Inventory 23,485.33 78,436.84 7,055.85 85,492.69 51,905.00 (33,587.69) 164.71% 422016 - Inventory For Sale 4,542.24 41,811.52 8,486.00 50,297.52 34,035.00 (16,262.52) 147.78% Total Operating Supplies 45,861.02 281,603.78 52,227.39 333,831.17 269,085.00 (64,746.17) 124.06% Repair & Maintenance Supplies 423000 - Other R&M Supplies 11,647.56 46,198.60 2,686.93 48,885.53 41,590.63 (7,294.90) 117.54% 423009 - Repair Parts - 2,479.69 - 2,479.69 2,700.00 220.31 91.84% Total Repair & Maintenance Supplies 11,647.56 48,678.29 2,686.93 51,365.22 44,290.63 (7,074.59) 115.97% Total Supplies Expenses 57,648.17 330,901.06 54,914.32 385,815.38 314,125.63 (71,689.75) 122.82% Services & Charges Expenses Professional Services 431000 - Other Professional Services 2,840.48 32,757.13 580.00 33,337.13 30,380.00 (2,957.13) 109.73% 431019 - Security Services 484.77 2,888.01 - 2,888.01 1,900.00 (988.01) 152.00% Total Professional Services 3,325.25 35,645.14 580.00 36,225.14 32,280.00 (3,945.14) 112.22% 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 - 3,492.73 - 3,492.73 - (3,492.73) 0.00% 433003 - Promotional 1,093.90 27,063.24 - 27,063.24 32,620.00 5,556.76 82.97% Total Printing & Advertising 1,093.90 30,555.97 - 30,555.97 32,620.00 2,064.03 93.67% Utilties 435001 - Electric 5,564.00 40,995.10 - 40,995.10 49,667.00 8,671.90 82.54% 435002 - Natural Gas 668.34 14,039.10 - 14,039.10 22,519.00 8,479.90 62.34% Total Utilities 6,232.34 55,034.20 - 55,034.20 72,186.00 17,151.80 76.24% Repairs & Maintenance 436000 - Other R&M 2,970.49 4,267.40 6,491.54 10,758.94 12,971.54 2,212.60 82.94% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance 2,970.49 4,792.10 6,491.54 11,283.64 13,971.54 2,687.90 80.76% 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 298.06 2,340.28 - 2,340.28 4,350.00 2,009.72 53.80% 439002 - Licenses & Permits 13.77 3,493.63 - 3,493.63 3,360.00 (133.63) 103.98% 439003 - Subscriptions 77.94 1,569.50 - 1,569.50 1,500.00 (69.50) 104.63% 439004 - Dues & Memberships - 346.93 - 346.93 3,200.00 2,853.07 10.84% 439005 - Bank & Credit Card Fees 8,052.50 36,577.15 - 36,577.15 25,270.00 (11,307.15) 144.75% 439006 - Education & Training - 1,180.92 - 1,180.92 800.00 (380.92) 147.62% 439009 - Trash Removal 1,451.76 9,637.46 542.19 10,179.65 13,339.15 3,159.50 76.31% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (107.91) (519.33) - (519.33) - 519.33 0.00% 439100 - Refunds/Awards/Indemnities 76.65 759.76 - 759.76 430.00 (329.76) 176.69% Total Other Services & Charges 9,862.77 55,386.30 18,542.19 73,928.49 70,249.15 (3,679.34) 105.24% Total Services & Charges Expenses 23,484.75 254,239.37 25,622.86 279,862.23 294,532.82 14,670.59 95.02% 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 4,962.00 39,696.00 - 39,696.00 59,544.00 19,848.00 66.67% 452003 - Allocations-IT 5,594.67 44,757.32 - 44,757.32 67,136.00 22,378.68 66.67% 452004 - Allocations-Liability Insurance 870.92 6,967.32 - 6,967.32 10,451.00 3,483.68 66.67% 452009 - Allocations-Facilities Mgmt 295.25 2,362.00 - 2,362.00 3,543.00 1,181.00 66.67% Total Other Uses 11,722.84 93,782.64 - 93,782.64 140,674.00 46,891.36 66.67% Bad Debt Expense 490000 - Bad Debt Expense 100.00 100.00 - 100.00 - (100.00) 0.00% Total Bad Debt Expense 100.00 100.00 - 100.00 - (100.00) 0.00% Total Expenses 199,389.11 1,340,762.07 80,537.18 1,421,299.25 1,856,271.45 434,972.20 76.57%