Loading...
HomeMy WebLinkAboutDec 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 (656.00) 217,546.77 224,000.00 6,453.23 97.12% 347004 - Golf Green Fees (14,573.12) 770,126.98 791,530.00 21,403.02 97.30% 347005 - Golf Cart Rentals 2,176.36 384,592.18 384,400.00 (192.18) 100.05% 347006 - Golf Pro Shop Retail 1,647.83 76,129.41 74,500.00 (1,629.41) 102.19% 347007 - Golf Driving Range - 33,649.97 34,000.00 350.03 98.97% 347008 - Golf Gift Certificate 1,065.47 1,070.47 - (1,070.47) 0.00% 347012 - Food Sales 78.15 67,104.83 67,227.00 122.17 99.82% 347013 - Nonalcoholic Beverage 104.14 40,816.51 41,543.00 726.49 98.25% 347014 - Alcoholic Beverage Sales 508.83 148,601.07 148,120.00 (481.07) 100.32% 347026 - Room Rental 2,524.00 7,424.00 4,900.00 (2,524.00) 151.51% 347100 - Concessions-Employee Discounts - (3,528.54) - 3,528.54 0.00% Total Culture & Recreation (7,124.34) 1,743,533.65 1,770,220.00 26,686.35 98.49% Total Charges for Services (7,124.34) 1,743,533.65 1,770,220.00 26,686.35 98.49% Miscellaneous Revenue 360000 - Miscellaneous 1.57 2,988.67 3,000.00 11.33 99.62% Total Miscellaneous Revenue 1.57 2,988.67 3,000.00 11.33 99.62% 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 (7,122.77) 1,753,503.17 1,779,660.00 26,156.83 98.53% 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,621.73 332,125.14 - 332,125.14 348,282.00 16,156.86 95.36% 410002 - Teamster Wages 3,241.60 73,573.91 - 73,573.91 79,674.00 6,100.09 92.34% 410003 - Permanent Part Time 8,042.82 245,754.86 - 245,754.86 250,847.00 5,092.14 97.97% 410004 - Extra & Overtime 30.40 5,654.24 - 5,654.24 6,141.00 486.76 92.07% 410005 - Seasonal & Interns - 59,665.37 - 59,665.37 62,137.00 2,471.63 96.02% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 36,936.55 717,373.52 - 717,373.52 747,681.00 30,307.48 95.95% Employee Benefits 411001 - FICA Regular 2,798.58 53,524.52 - 53,524.52 54,074.00 549.48 98.98% 411004 - PERF Regular 3,226.08 46,503.99 - 46,503.99 46,907.00 403.01 99.14% 411005 - PERF Union 49.08 944.22 - 944.22 1,330.00 385.78 70.99% 411007 - Unemployment Comp 8.99 126.65 - 126.65 149.00 22.35 85.00% 411008 - Health Insurance 7,673.74 96,590.38 - 96,590.38 96,660.00 69.62 99.93% 411009 - Life Insurance 70.00 910.00 - 910.00 960.00 50.00 94.79% 411014 - Parental Leave 102.90 1,438.55 - 1,438.55 1,558.00 119.45 92.33% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 100.00% 411201 - Tool Allowance - 400.94 - 400.94 401.00 0.06 99.99% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 100.00% 411206 - Cell Phone Allowance 55.00 660.00 - 660.00 660.00 - 100.00% Total Employee Benefits 13,984.37 202,349.25 - 202,349.25 203,949.00 1,599.75 99.22% Total Personnel Expenditures 50,920.92 919,722.77 - 919,722.77 951,630.00 31,907.23 96.65% December 31, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies - 2,321.41 - 2,321.41 2,394.00 72.59 96.97% 421002 - Stationary & Printing 39.12 368.23 - 368.23 510.00 141.77 72.20% Total Office Supplies 39.12 2,689.64 - 2,689.64 2,904.00 214.36 92.62% Operating Supplies 422000 - Other Operating Supplies 6,551.93 101,240.39 - 101,240.39 114,964.00 13,723.61 88.06% 422001 - C.S. Gasoline - 1,173.20 - 1,173.20 1,900.00 726.80 61.75% 422002 - Diesel/CNG - 11,036.84 - 11,036.84 12,597.00 1,560.16 87.61% 422003 - Gasoline - 9,696.88 - 9,696.88 14,106.00 4,409.12 68.74% 422005 - Uniforms - 1,795.86 - 1,795.86 2,900.00 1,104.14 61.93% 422010 - Plants Chemicals Seed & Fertilizer 1,779.32 88,544.24 - 88,544.24 101,951.77 13,407.53 86.85% 422014 - Concessions Inventory 828.10 86,730.30 - 86,730.30 97,048.00 10,317.70 89.37% 422016 - Inventory For Sale 2,653.87 43,315.16 - 43,315.16 44,170.00 854.84 98.06% Total Operating Supplies 11,813.22 343,532.87 - 343,532.87 389,636.77 46,103.90 88.17% Repair & Maintenance Supplies 423000 - Other R&M Supplies 115.02 32,567.66 - 32,567.66 37,151.37 4,583.71 87.66% 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 - 4,368.29 - 4,368.29 4,491.23 122.94 97.26% Total Repair & Maintenance Supplies 115.02 68,504.59 - 68,504.59 73,211.60 4,707.01 93.57% Total Supplies Expenditures 11,967.36 414,727.10 - 414,727.10 465,752.37 51,025.27 89.04% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,260.75 25,327.31 - 25,327.31 28,368.65 3,041.34 89.28% 431015 - Laboratory Water Testing - 67.48 - 67.48 115.00 47.52 58.68% 431019 - Security Services 682.10 5,446.13 - 5,446.13 6,074.00 627.87 89.66% Total Professional Services 1,942.85 30,840.92 - 30,840.92 34,557.65 3,716.73 89.24% Communication & Transportation 432002 - Mailing - 12.10 - 12.10 13.00 0.90 93.08% 432004 - Telecommunications - 80.87 - 80.87 233.87 153.00 34.58% Total Communication & Transportation - 92.97 - 92.97 246.87 153.90 37.66% Printing & Advertising 433001 - Outside Printing Services 175.00 425.00 - 425.00 500.00 75.00 85.00% 433003 - Promotional 1,612.57 2,292.57 - 2,292.57 2,381.00 88.43 96.29% Total Printing & Advertising 1,787.57 2,717.57 - 2,717.57 2,881.00 163.43 94.33% Utilties 435001 - Electric 1,781.60 65,394.74 - 65,394.74 70,535.00 5,140.26 92.71% 435002 - Natural Gas 1,601.69 14,420.03 - 14,420.03 33,254.00 18,833.97 43.36% Total Utilities 3,383.29 79,814.77 - 79,814.77 103,789.00 23,974.23 76.90% Repairs & Maintenance 436000 - Other R&M - 28,357.00 - 28,357.00 29,211.46 854.46 97.07% Total Repairs & Maintenance - 28,357.00 - 28,357.00 29,211.46 854.46 97.07% Rentals 437002 - Equipment Rental - 556.00 - 556.00 650.00 94.00 85.54% Total Rentals - 556.00 - 556.00 650.00 94.00 85.54% 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 416.40 6,738.43 - 6,738.43 8,398.43 1,660.00 80.23% 439001 - Other Contractual Services - 53.66 - 53.66 387.80 334.14 13.84% 439002 - Licenses & Permits - 4,715.59 - 4,715.59 5,355.00 639.41 88.06% 439003 - Subscriptions 62.94 2,725.79 - 2,725.79 2,800.00 74.21 97.35% 439004 - Dues & Memberships - 623.04 - 623.04 1,229.00 605.96 50.69% 439005 - Bank & Credit Card Fees 434.39 38,513.96 - 38,513.96 39,500.00 986.04 97.50% 439006 - Education & Training 127.00 127.00 - 127.00 200.00 73.00 63.50% 439009 - Trash Removal 1,056.58 7,381.29 - 7,381.29 7,655.85 274.56 96.41% 439099 - Cashier Over/Short (5.08) (725.92) - (725.92) 65.00 790.92 (1116.80%) 439100 - Refunds/Awards/Indemnities 335.00 1,717.58 - 1,717.58 1,870.00 152.42 91.85% Total Other Services & Charges 2,427.23 61,870.42 - 61,870.42 67,461.08 5,590.66 91.71% Total Services & Charges Expenditures 9,540.94 278,055.23 - 278,055.23 312,603.06 34,547.83 88.95% Other Uses 452002 - Allocations-Admin Cost 6,281.00 75,372.00 - 75,372.00 75,372.00 - 100.00% 452004 - Allocations-Liability Insurance 859.00 10,307.00 - 10,307.00 10,307.00 - 100.00% 452009 - Allocations-Facilities Mgmt 218.00 2,615.00 - 2,615.00 2,615.00 - 100.00% Total Other Uses 7,358.00 88,294.00 - 88,294.00 88,294.00 - 100.00% Total Expenditures 79,787.22 1,700,799.10 - 1,700,799.10 1,818,279.43 117,480.33 93.54%