Loading...
HomeMy WebLinkAboutNov 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 13,148.00 784,700.10 795,000.00 10,299.90 98.70% 347005 - Golf Cart Rentals 6,892.43 382,415.82 360,000.00 (22,415.82) 106.23% 347006 - Golf Pro Shop Retail 1,715.53 74,481.58 59,500.00 (14,981.58) 125.18% 347007 - Golf Driving Range 378.00 33,649.97 30,000.00 (3,649.97) 112.17% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347012 - Food Sales 935.71 67,026.68 53,277.00 (13,749.68) 125.81% 347013 - Nonalcoholic Beverage 509.88 40,712.37 33,398.00 (7,314.37) 121.90% 347014 - Alcoholic Beverage Sales 3,601.84 148,092.24 110,000.00 (38,092.24) 134.63% 347026 - Room Rental 1,300.00 4,900.00 - (4,900.00) 0.00% 347100 - Concessions-Employee Discounts (154.05) (3,528.54) - 3,528.54 0.00% Total Culture & Recreation 28,327.34 1,750,657.99 1,534,175.00 (216,482.99) 114.11% Total Charges for Services 28,327.34 1,750,657.99 1,534,175.00 (216,482.99) 114.11% Miscellaneous Revenue 360000 - Miscellaneous 28.52 2,987.10 5,000.00 2,012.90 59.74% Total Miscellaneous Revenue 28.52 2,987.10 5,000.00 2,012.90 59.74% 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 28,355.86 1,760,625.94 1,545,615.00 (215,010.94) 113.91% 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,542.50 306,503.41 - 306,503.41 308,284.00 1,780.59 99.42% 410002 - Teamster Wages 3,609.89 70,332.31 - 70,332.31 83,842.00 13,509.69 83.89% 410003 - Permanent Part Time 13,134.35 237,712.04 - 237,712.04 234,000.00 (3,712.04) 101.59% 410004 - Extra & Overtime 516.82 5,623.84 - 5,623.84 5,050.00 (573.84) 111.36% 410005 - Seasonal & Interns 2,471.20 59,665.37 - 59,665.37 60,673.00 1,007.63 98.34% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 45,274.76 680,436.97 - 680,436.97 692,449.00 12,012.03 98.27% Employee Benefits 411001 - FICA Regular 3,347.31 50,725.94 - 50,725.94 53,149.00 2,423.06 95.44% 411004 - PERF Regular 3,329.11 43,277.91 - 43,277.91 46,907.00 3,629.09 92.26% 411005 - PERF Union 54.00 895.14 - 895.14 1,330.00 434.86 67.30% 411007 - Unemployment Comp 9.15 117.66 - 117.66 149.00 31.34 78.97% 411008 - Health Insurance 7,743.34 88,916.64 - 88,916.64 82,943.00 (5,973.64) 107.20% 411009 - Life Insurance 75.00 840.00 - 840.00 960.00 120.00 87.50% 411014 - Parental Leave 104.13 1,335.65 - 1,335.65 1,558.00 222.35 85.73% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 100.00% 411201 - Tool Allowance - 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 605.00 - 605.00 660.00 55.00 91.67% Total Employee Benefits 14,717.04 188,364.88 - 188,364.88 189,181.00 816.12 99.57% Total Personnel Expenditures 59,991.80 868,801.85 - 868,801.85 881,630.00 12,828.15 98.54% November 30, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies 365.04 2,321.41 - 2,321.41 2,394.00 72.59 96.97% 421002 - Stationary & Printing - 329.11 - 329.11 410.00 80.89 80.27% Total Office Supplies 365.04 2,650.52 - 2,650.52 2,804.00 153.48 94.53% Operating Supplies 422000 - Other Operating Supplies 9,115.62 94,688.46 1,655.90 96,344.36 77,764.00 (18,580.36) 123.89% 422001 - C.S. Gasoline - 1,173.20 - 1,173.20 1,900.00 726.80 61.75% 422002 - Diesel/CNG 1,341.78 11,036.84 1,500.00 12,536.84 12,597.00 60.16 99.52% 422003 - Gasoline 1,260.00 9,696.88 4,200.00 13,896.88 14,106.00 209.12 98.52% 422005 - Uniforms - 1,795.86 - 1,795.86 2,900.00 1,104.14 61.93% 422010 - Plants Chemicals Seed & Fertilizer 1,610.70 86,764.92 5,103.48 91,868.40 61,951.77 (29,916.63) 148.29% 422014 - Concessions Inventory 471.20 85,902.20 828.10 86,730.30 57,048.00 (29,682.30) 152.03% 422016 - Inventory For Sale 127.31 40,661.29 335.00 40,996.29 41,905.00 908.71 97.83% Total Operating Supplies 13,926.61 331,719.65 13,622.48 345,342.13 270,171.77 (75,170.36) 127.82% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,245.51 32,452.64 590.63 33,043.27 37,642.00 4,598.73 87.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 134.74 4,368.29 - 4,368.29 4,491.23 122.94 97.26% Total Repair & Maintenance Supplies 1,380.25 68,389.57 590.63 68,980.20 73,702.23 4,722.03 93.59% Total Supplies Expenditures 15,671.90 402,759.74 14,213.11 416,972.85 346,678.00 (70,294.85) 120.28% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 3,088.77 24,066.56 2,470.00 26,536.56 23,718.65 (2,817.91) 111.88% 431015 - Laboratory Water Testing 52.48 67.48 - 67.48 115.00 47.52 58.68% 431019 - Security Services 440.95 4,764.03 - 4,764.03 5,874.00 1,109.97 81.10% Total Professional Services 3,582.20 28,898.07 2,470.00 31,368.07 29,707.65 (1,660.42) 105.59% 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 433001 - Outside Printing Services 250.00 250.00 - 250.00 - (250.00) 0.00% 433003 - Promotional - 680.00 - 680.00 681.00 1.00 99.85% Total Printing & Advertising 250.00 930.00 - 930.00 681.00 (249.00) 136.56% Utilties 435001 - Electric 1,725.23 63,613.14 - 63,613.14 37,035.00 (26,578.14) 171.76% 435002 - Natural Gas 328.53 12,818.34 - 12,818.34 5,419.00 (7,399.34) 236.54% Total Utilities 2,053.76 76,431.48 - 76,431.48 42,454.00 (33,977.48) 180.03% Repairs & Maintenance 436000 - Other R&M - 28,357.00 6,491.54 34,848.54 35,703.00 854.46 97.61% Total Repairs & Maintenance - 28,357.00 6,491.54 34,848.54 35,703.00 854.46 97.61% Rentals 437002 - Equipment Rental - 556.00 - 556.00 150.00 (406.00) 370.67% Total Rentals - 556.00 - 556.00 150.00 (406.00) 370.67% 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 89.22 6,322.03 416.40 6,738.43 8,008.43 1,270.00 84.14% 439001 - Other Contractual Services - 53.66 - 53.66 387.80 334.14 13.84% 439002 - Licenses & Permits - 4,715.59 - 4,715.59 5,540.00 824.41 85.12% 439003 - Subscriptions 12.95 2,662.85 - 2,662.85 2,650.00 (12.85) 100.48% 439004 - Dues & Memberships - 623.04 - 623.04 1,279.00 655.96 48.71% 439005 - Bank & Credit Card Fees 732.73 38,079.57 - 38,079.57 39,500.00 1,420.43 96.40% 439009 - Trash Removal 233.53 6,324.71 1,056.58 7,381.29 7,795.00 413.71 94.69% 439099 - Cashier Over/Short (10.24) (720.84) - (720.84) 15.00 735.84 (4805.60%) 439100 - Refunds/Awards/Indemnities - 1,382.58 - 1,382.58 1,510.00 127.42 91.56% Total Other Services & Charges 1,058.19 59,443.19 1,472.98 60,916.17 66,685.23 5,769.06 91.35% Total Services & Charges Expenditures 6,944.15 268,514.29 10,443.65 278,957.94 249,442.88 (29,515.06) 111.83% Other Uses 452002 - Allocations-Admin Cost 6,281.00 69,091.00 - 69,091.00 75,372.00 6,281.00 91.67% 452004 - Allocations-Liability Insurance 859.00 9,448.00 - 9,448.00 10,307.00 859.00 91.67% 452009 - Allocations-Facilities Mgmt 218.00 2,397.00 - 2,397.00 2,615.00 218.00 91.66% Total Other Uses 7,358.00 80,936.00 - 80,936.00 88,294.00 7,358.00 91.67% Total Expenditures 89,965.85 1,621,011.88 24,656.76 1,645,668.64 1,566,044.88 (79,623.76) 105.08%