Loading...
HomeMy WebLinkAboutOct 21 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 - 218,202.77 93,000.00 (125,202.77) 234.63% 347004 - Golf Green Fees 45,739.65 771,552.10 795,000.00 23,447.90 97.05% 347005 - Golf Cart Rentals 34,237.96 375,523.39 360,000.00 (15,523.39) 104.31% 347006 - Golf Pro Shop Retail 4,295.18 72,766.05 59,500.00 (13,266.05) 122.30% 347007 - Golf Driving Range 2,094.00 33,271.97 30,000.00 (3,271.97) 110.91% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347012 - Food Sales 5,469.76 66,090.97 53,277.00 (12,813.97) 124.05% 347013 - Nonalcoholic Beverage 2,714.16 40,202.49 33,398.00 (6,804.49) 120.37% 347014 - Alcoholic Beverage Sales 12,120.36 144,490.40 110,000.00 (34,490.40) 131.35% 347026 - Room Rental 1,300.00 3,600.00 - (3,600.00) 0.00% 347100 - Concessions-Employee Discounts (191.96) (3,374.49) - 3,374.49 0.00% Total Culture & Recreation 107,779.11 1,722,330.65 1,534,175.00 (188,155.65) 112.26% Total Charges for Services 107,779.11 1,722,330.65 1,534,175.00 (188,155.65) 112.26% Miscellaneous Revenue 360000 - Miscellaneous 146.98 2,958.58 5,000.00 2,041.42 59.17% Total Miscellaneous Revenue 146.98 2,958.58 5,000.00 2,041.42 59.17% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,717.00 3,176.00 (541.00) 117.03% 396000 - Refunds - 3,263.85 3,264.00 0.15 100.00% Total Refunds & Reimbursements - 6,980.85 6,440.00 (540.85) 108.40% Total Revenue 107,926.09 1,732,270.08 1,545,615.00 (186,655.08) 112.08% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 38,411.49 280,960.91 - 280,960.91 308,284.00 27,323.09 91.14% 410002 - Teamster Wages 8,989.25 66,722.42 - 66,722.42 83,842.00 17,119.58 79.58% 410003 - Permanent Part Time 40,411.15 224,577.69 - 224,577.69 234,000.00 9,422.31 95.97% 410004 - Extra & Overtime 882.06 5,107.02 - 5,107.02 5,050.00 (57.02) 101.13% 410005 - Seasonal & Interns 11,260.77 57,194.17 - 57,194.17 60,673.00 3,478.83 94.27% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 99,954.72 635,162.21 - 635,162.21 692,449.00 57,286.79 91.73% Employee Benefits 411001 - FICA Regular 7,536.87 47,378.63 - 47,378.63 53,149.00 5,770.37 89.14% 411004 - PERF Regular 5,403.53 39,948.80 - 39,948.80 46,907.00 6,958.20 85.17% 411005 - PERF Union 75.34 841.14 - 841.14 1,330.00 488.86 63.24% 411007 - Unemployment Comp 15.15 108.51 - 108.51 149.00 40.49 72.83% 411008 - Health Insurance 7,812.94 81,173.30 - 81,173.30 82,943.00 1,769.70 97.87% 411009 - Life Insurance 80.00 765.00 - 765.00 960.00 195.00 79.69% 411014 - Parental Leave 168.95 1,231.52 - 1,231.52 1,558.00 326.48 79.04% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 100.00% 411201 - Tool Allowance 400.94 400.94 - 400.94 275.00 (125.94) 145.80% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 100.00% 411206 - Cell Phone Allowance 55.00 550.00 - 550.00 660.00 110.00 83.33% Total Employee Benefits 21,548.72 173,647.84 - 173,647.84 189,181.00 15,533.16 91.79% Total Personnel Expenditures 121,503.44 808,810.05 - 808,810.05 881,630.00 72,819.95 91.74% October 31, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies 426.04 1,956.37 - 1,956.37 934.00 (1,022.37) 209.46% 421002 - Stationary & Printing - 329.11 - 329.11 - (329.11) 0.00% Total Office Supplies 426.04 2,285.48 - 2,285.48 934.00 (1,351.48) 244.70% Operating Supplies 422000 - Other Operating Supplies 4,240.38 85,572.84 1,797.27 87,370.11 67,334.00 (20,036.11) 129.76% 422001 - C.S. Gasoline - 1,173.20 - 1,173.20 1,900.00 726.80 61.75% 422002 - Diesel/CNG 1,495.12 9,695.06 2,816.80 12,511.86 10,947.00 (1,564.86) 114.29% 422003 - Gasoline - 8,436.88 5,460.00 13,896.88 10,556.00 (3,340.88) 131.65% 422005 - Uniforms 5.14 1,795.86 142.50 1,938.36 2,900.00 961.64 66.84% 422010 - Plants Chemicals Seed & Fertilizer 7,973.08 85,154.22 4,934.86 90,089.08 84,351.77 (5,737.31) 106.80% 422014 - Concessions Inventory 17,111.63 85,431.00 2,312.85 87,743.85 64,048.00 (23,695.85) 137.00% 422016 - Inventory For Sale 6,071.67 40,533.98 3,782.58 44,316.56 41,905.00 (2,411.56) 105.75% Total Operating Supplies 36,897.02 317,793.04 21,246.86 339,039.90 283,941.77 (55,098.13) 119.40% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,049.36 31,207.13 1,208.95 32,416.08 28,742.00 (3,674.08) 112.78% 423001 - Building Materials - 393.64 - 393.64 394.00 0.36 99.91% 423006 - Small Tools & Equipment - 31,175.00 - 31,175.00 31,175.00 - 100.00% 423009 - Repair Parts 2,047.41 4,233.55 161.24 4,394.79 1,491.23 (2,903.56) 294.71% Total Repair & Maintenance Supplies 7,096.77 67,009.32 1,370.19 68,379.51 61,802.23 (6,577.28) 110.64% Total Supplies Expenditures 44,419.83 387,087.84 22,617.05 409,704.89 346,678.00 (63,026.89) 118.18% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 7,260.95 20,977.79 2,495.00 23,472.79 15,396.65 (8,076.14) 152.45% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 100.00% 431019 - Security Services 270.43 4,323.08 - 4,323.08 4,756.00 432.92 90.90% Total Professional Services 7,531.38 25,315.87 2,495.00 27,810.87 20,167.65 (7,643.22) 137.90% Communication & Transportation 432002 - Mailing - 12.10 - 12.10 13.00 0.90 93.08% 432004 - Telecommunications - 80.87 9.13 90.00 243.00 153.00 37.04% Total Communication & Transportation - 92.97 9.13 102.10 256.00 153.90 39.88% Printing & Advertising 433003 - Promotional - 680.00 - 680.00 681.00 1.00 99.85% Total Printing & Advertising - 680.00 - 680.00 681.00 1.00 99.85% Utilties 435001 - Electric 10,078.94 61,887.91 - 61,887.91 45,035.00 (16,852.91) 137.42% 435002 - Natural Gas 490.34 12,489.81 - 12,489.81 15,419.00 2,929.19 81.00% Total Utilities 10,569.28 74,377.72 - 74,377.72 60,454.00 (13,923.72) 123.03% Repairs & Maintenance 436000 - Other R&M 19,660.00 28,357.00 6,491.54 34,848.54 40,197.00 5,348.46 86.69% Total Repairs & Maintenance 19,660.00 28,357.00 6,491.54 34,848.54 40,197.00 5,348.46 86.69% Rentals 437002 - Equipment Rental - 556.00 - 556.00 - (556.00) 0.00% Total Rentals - 556.00 - 556.00 - (556.00) 0.00% Debt Service 438100 - Principal - 65,325.96 - 65,325.96 65,326.00 0.04 100.00% 438200 - Interest - 8,479.62 - 8,479.62 8,480.00 0.38 100.00% Total Debt Service - 73,805.58 - 73,805.58 73,806.00 0.42 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 610.64 6,232.81 800.83 7,033.64 7,128.43 94.79 98.67% 439001 - Other Contractual Services - 53.66 333.80 387.46 387.80 0.34 99.91% 439002 - Licenses & Permits - 4,715.59 - 4,715.59 5,531.00 815.41 85.26% 439003 - Subscriptions 129.98 2,649.90 - 2,649.90 390.00 (2,259.90) 679.46% 439004 - Dues & Memberships - 623.04 - 623.04 3,279.00 2,655.96 19.00% 439005 - Bank & Credit Card Fees 2,398.15 37,346.84 - 37,346.84 31,400.00 (5,946.84) 118.94% 439009 - Trash Removal 1,359.95 6,091.18 - 6,091.18 4,345.00 (1,746.18) 140.19% 439099 - Cashier Over/Short (108.13) (710.60) - (710.60) 15.00 725.60 (4737.33%) 439100 - Refunds/Awards/Indemnities 176.67 1,382.58 - 1,382.58 1,405.00 22.42 98.40% Total Other Services & Charges 4,567.26 58,385.00 1,134.63 59,519.63 53,881.23 (5,638.40) 110.46% Total Services & Charges Expenditures 42,327.92 261,570.14 10,130.30 271,700.44 249,442.88 (22,257.56) 108.92% Other Uses 452002 - Allocations-Admin Cost 6,281.00 62,810.00 - 62,810.00 75,372.00 12,562.00 83.33% 452004 - Allocations-Liability Insurance 859.00 8,589.00 - 8,589.00 10,307.00 1,718.00 83.33% 452009 - Allocations-Facilities Mgmt 218.00 2,179.00 - 2,179.00 2,615.00 436.00 83.33% Total Other Uses 7,358.00 73,578.00 - 73,578.00 88,294.00 14,716.00 83.33% Total Expenditures 215,609.19 1,531,046.03 32,747.35 1,563,793.38 1,566,044.88 2,251.50 99.86%