Loading...
HomeMy WebLinkAboutAug 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 982.00 218,084.77 93,000.00 (125,084.77) 234.50% 347004 - Golf Green Fees 142,096.29 605,700.53 795,000.00 189,299.47 76.19% 347005 - Golf Cart Rentals 70,906.23 289,343.05 360,000.00 70,656.95 80.37% 347006 - Golf Pro Shop Retail 10,942.83 59,326.17 59,500.00 173.83 99.71% 347007 - Golf Driving Range 5,426.00 26,415.97 30,000.00 3,584.03 88.05% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347012 - Food Sales 11,298.13 49,222.83 53,277.00 4,054.17 92.39% 347013 - Nonalcoholic Beverage 8,335.97 31,536.55 33,398.00 1,861.45 94.43% 347014 - Alcoholic Beverage Sales 26,489.13 109,276.48 110,000.00 723.52 99.34% 347026 - Room Rental 1,050.00 1,850.00 - (1,850.00) 0.00% 347100 - Concessions-Employee Discounts (742.20) (2,796.43) - 2,796.43 0.00% Total Culture & Recreation 276,784.38 1,387,964.92 1,534,175.00 146,210.08 90.47% Total Charges for Services 276,784.38 1,387,964.92 1,534,175.00 146,210.08 90.47% Miscellaneous Revenue 360000 - Miscellaneous 454.78 2,562.19 5,000.00 2,437.81 51.24% Total Miscellaneous Revenue 454.78 2,562.19 5,000.00 2,437.81 51.24% 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 277,239.16 1,397,507.96 1,545,615.00 148,107.04 90.42% 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 25,889.74 216,739.63 - 216,739.63 322,507.00 105,767.37 67.20% 410002 - Teamster Wages 6,468.00 51,448.98 - 51,448.98 83,842.00 32,393.02 61.36% 410003 - Permanent Part Time 31,250.36 153,111.00 - 153,111.00 234,000.00 80,889.00 65.43% 410004 - Extra & Overtime 1,335.95 3,645.40 - 3,645.40 5,050.00 1,404.60 72.19% 410005 - Seasonal & Interns 9,050.56 38,727.81 - 38,727.81 46,450.00 7,722.19 83.38% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 73,994.61 464,272.82 - 464,272.82 692,449.00 228,176.18 67.05% Employee Benefits 411001 - FICA Regular 5,543.12 34,526.93 - 34,526.93 53,149.00 18,622.07 64.96% 411004 - PERF Regular 4,203.81 30,980.09 - 30,980.09 46,907.00 15,926.91 66.05% 411005 - PERF Union 56.60 716.67 - 716.67 1,330.00 613.33 53.88% 411007 - Unemployment Comp 10.20 83.16 - 83.16 124.00 40.84 67.06% 411008 - Health Insurance 7,805.94 65,554.42 - 65,554.42 82,943.00 17,388.58 79.04% 411009 - Life Insurance 80.00 605.00 - 605.00 960.00 355.00 63.02% 411014 - Parental Leave 116.63 948.77 - 948.77 1,458.00 509.23 65.07% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 100.00% 411201 - Tool Allowance - - - - 400.00 400.00 0.00% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 100.00% 411206 - Cell Phone Allowance 55.00 440.00 - 440.00 660.00 220.00 66.67% Total Employee Benefits 17,871.30 135,105.04 - 135,105.04 189,181.00 54,075.96 71.42% Total Personnel Expenditures 91,865.91 599,377.86 - 599,377.86 881,630.00 282,252.14 67.99% August 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 390.79 1,432.44 - 1,432.44 934.00 (498.44) 153.37% 421002 - Stationary & Printing 23.53 23.53 - 23.53 - (23.53) 0.00% Total Office Supplies 414.32 1,455.97 - 1,455.97 934.00 (521.97) 155.89% Operating Supplies 422000 - Other Operating Supplies 6,038.15 67,797.80 3,681.87 71,479.67 68,334.00 (3,145.67) 104.60% 422001 - C.S. Gasoline - - 1,173.20 1,173.20 2,500.00 1,326.80 46.93% 422002 - Diesel/CNG 1,483.50 8,199.94 1,500.00 9,699.94 10,947.00 1,247.06 88.61% 422003 - Gasoline - 6,102.08 1,161.60 7,263.68 10,556.00 3,292.32 68.81% 422005 - Uniforms 718.57 1,548.91 142.50 1,691.41 2,900.00 1,208.59 58.32% 422010 - Plants Chemicals Seed & Fertilizer 3,711.39 75,729.49 3,380.93 79,110.42 82,956.77 3,846.35 95.36% 422014 - Concessions Inventory 18,427.69 61,541.88 7,469.21 69,011.09 64,048.00 (4,963.09) 107.75% 422016 - Inventory For Sale 988.00 34,462.31 7,777.08 42,239.39 42,500.00 260.61 99.39% Total Operating Supplies 31,367.30 255,382.41 26,286.39 281,668.80 284,741.77 3,072.97 98.92% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,979.39 23,688.87 2,862.87 26,551.74 27,942.00 1,390.26 95.02% 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 485.22 1,734.51 161.24 1,895.75 1,491.23 (404.52) 127.13% Total Repair & Maintenance Supplies 2,464.61 56,992.02 3,024.11 60,016.13 61,002.23 986.10 98.38% Total Supplies Expenditures 34,246.23 313,830.40 29,310.50 343,140.90 346,678.00 3,537.10 98.98% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,194.00 12,401.80 2,470.00 14,871.80 15,096.65 224.85 98.51% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 100.00% 431019 - Security Services 688.31 3,479.97 - 3,479.97 5,056.00 1,576.03 68.83% Total Professional Services 2,882.31 15,896.77 2,470.00 18,366.77 20,167.65 1,800.88 91.07% 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 5,683.01 44,064.97 - 44,064.97 45,035.00 970.03 97.85% 435002 - Natural Gas 566.67 11,796.50 - 11,796.50 15,419.00 3,622.50 76.51% Total Utilities 6,249.68 55,861.47 - 55,861.47 60,454.00 4,592.53 92.40% Repairs & Maintenance 436000 - Other R&M - 8,697.00 26,151.54 34,848.54 15,197.00 (19,651.54) 229.31% Total Repairs & Maintenance - 8,697.00 26,151.54 34,848.54 15,197.00 (19,651.54) 229.31% Rentals 437002 - Equipment Rental 136.00 136.00 - 136.00 - (136.00) 0.00% Total Rentals 136.00 136.00 - 136.00 - (136.00) 0.00% Debt Service 438100 - Principal 313.61 65,325.96 - 65,325.96 65,326.00 0.04 100.00% 438200 - Interest 2.50 8,479.62 - 8,479.62 8,480.00 0.38 100.00% Total Debt Service 316.11 73,805.58 - 73,805.58 73,806.00 0.42 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 724.50 5,412.06 384.43 5,796.49 7,128.43 1,331.94 81.32% 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 2,000.00 2,454.93 - 2,454.93 390.00 (2,064.93) 629.47% 439004 - Dues & Memberships - 623.04 - 623.04 3,279.00 2,655.96 19.00% 439005 - Bank & Credit Card Fees 6,255.54 29,753.33 - 29,753.33 31,400.00 1,646.67 94.76% 439009 - Trash Removal 596.11 2,692.94 1,132.68 3,825.62 4,345.00 519.38 88.05% 439099 - Cashier Over/Short (163.04) (408.93) - (408.93) 15.00 423.93 (2726.20%) 439100 - Refunds/Awards/Indemnities 183.73 1,064.84 - 1,064.84 1,405.00 340.16 75.79% Total Other Services & Charges 9,596.84 46,361.46 1,850.91 48,212.37 53,881.23 5,668.86 89.48% Total Services & Charges Expenditures 19,180.94 201,531.25 30,481.58 232,012.83 224,442.88 (7,569.95) 103.37% Other Uses 452002 - Allocations-Admin Cost 6,281.00 50,248.00 - 50,248.00 75,372.00 25,124.00 66.67% 452004 - Allocations-Liability Insurance 859.00 6,871.00 - 6,871.00 10,307.00 3,436.00 66.66% 452009 - Allocations-Facilities Mgmt 218.00 1,743.00 - 1,743.00 2,615.00 872.00 66.65% Total Other Uses 7,358.00 58,862.00 - 58,862.00 88,294.00 29,432.00 66.67% Total Expenditures 152,651.08 1,173,601.51 59,792.08 1,233,393.59 1,541,044.88 307,651.29 80.04%