Loading...
03 September 2024 SilverRock Resort - Monthly Financial StatementLVCRP\OCK & R E S O R T Monthly Financial Statements July 019 2024 - September 30, 2024 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Golf Shop Income Statement 3 Course Maintenance Expense Statement 4 Outside Service Expense Statement 5 Clubhouse Expense Statement 6 Marketing Expense Statement 7 General 8t Administrative Expense Statement 8 Operating Leases Ft Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement September 2024 Month to Date Year to Date Annual Budget September Percentage G/L # Series Account Description Income 2024 Final Budget Variance Difference Final Budget Variance Annual Budget Unemcumb. % Bdgt 400000 Golf Green Fee Revenue 125,264.00 186,354.00 (61,090.00) -32.8% 270,605.91 375,354.00 (104,748.09) 4,406,783.00 4,136,177.09 6% 401000 Miscellaneous Golf Revenue 4,925.00 4,150.00 775.00 18.7% 14,910.11 11,850.00 3,060.11 179,960.00 165,049.89 8% 410000 Revenue -Golf Shop 10,424.97 9,449.00 975.97 10.3% 19,805.61 20,323.00 (517.39) 247,518.00 227,712.39 8% 420000 Food & Beverage Revenue 28,627.41 34,560.00 (5,932.59) -17.2% 66,167.67 72,430.00 (6,262.33) 774,989.00 708,821.33 9% Total Income 169,241.38 234,513.00 (65,271.62) -27.83% 371,489.30 479,957.00 (108,467.70) 5,609,250.00 5,237,760.70 7% Cost of Goods Sold 510000 COS -Golf Shop 6,234.56 $ 5,288.00 946.56 -17.9% 12,729.62 11,369.00 (1,360.62) 138,526.00 125,796.38 9% 520000 COS -Food & Beverage 11,893.95 $ 10,212.00 1,681.95 -16.5% 29,121.52 21,207.00 (7,914.52) 221,939.00 192,817.48 13% Total COS 18,128.51 15,500.00 2,628.51 -17.0% 41,851.14 32,576.00 (9,275.14) 360,465.00 318,613.86 12% Gross Profit 151,112.87 219,013.00 (67,900.13) -31.0% 329,638.16 447,381.00 (117,742.84) 5,248,785.00 4,919,146.84 6% Expenses 610000 Golf Pro Shop 22,033.45 15,461.00 6,572.45 -42.5% 61,819.31 44,382.00 17,437.31 281,235.00 219,415.69 22% 630000 Course Maintenance 175,888.00 157,131.00 18,757.00 -11.9% 509,902.61 449,508.00 60,394.61 2,076,015.00 1,566,112.39 25% 633000 Maintenance Water & Energy 30,573.68 27,380.00 3,193.68 -11.7% 96,106.90 80,640.00 15,466.90 333,584.00 237,477.10 29% 640000 Outside Services 47,084.65 31,621.00 15,463.65 -48.9% 119,824.40 91,519.00 28,305.40 598,965.00 479,140.60 20% 650000 Clubhouse 14,296.66 13,698.00 598.66 -4.4% 38,542.03 41,094.00 (2,551.97) 168,276.00 129,733.97 23% 660000 Marketing 15,334.99 6,132.00 9,202.99 -150.1% 31,108.05 16,206.00 14,902.05 170,826.00 139,717.95 18% 670000 General & Administrative 44,126.49 43,219.00 907.49 -2.1% 128,741.85 127,207.00 1,534.85 520,777.00 392,035.15 25% 680000 Leases 25,364.80 29,572.00 (4,207.20) 14.2% 76,326.90 88,716.00 (12,389.10) 421,264.00 344,937.10 18% 690000 Miscellaneous Other Expense 19,753.64 24,764.00 (5,010.36) 20.2% 62,576.37 66,616.00 (4,039.63) 295,568.00 232,991.63 21% 620000 Food & Beverage Expenses 29,281.73 38,279.00 (8,997.27) 23.5% 100,412.78 109,755.00 (9,342.22) 609,573.00 509,160.22 21% Total Expenses 423,738.09 387,257.00 36,481.09 -9.4% 1,225,361.20 1,115,643.00 (109,718.20) 5,476,083.00 3,741,561.58 22% Net Income (272,625.22) (168,244.00) (104,381.22) -68.3% (895,723.04) (668,262.00) (227,461.04) (227,298.00) 1,177,585.26 400000 Rounds of Golf Played Paid Rounds Played 1,675 2,700 (1,025) -38.0% 1,675 6,450 (4,775) 44,545 421,870 Ave $ Per Paid Round Green Fee 74.78 69.02 5.76 8.4% 161.56 58.19 103.36 98.93 (62.63) J213% Ave $ Per Paid Round Merchandise 6.22 3.50 2.72 77.8% 11.82 3.15 8.67 5.56 (6.27) Ave $ Per Paid Miscellaneous 2.94 1.54 1.40 91.3% 8.90 1.84 7.06 4.04 (4.86) 2 SilverRock Resort Statement of Fees - Revenue September 2024 Month to Date Year to Date Annual Budget September Income 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 125,264.00 186,354.00 (61,090.00) 270,605.91 375,354.00 (104,748.09) 4,406,783.00 4,136,177.09 93.9% 4010000 Rider Fee 650.00 1,500.00 (850.00) 1,915.00 3,600.00 (1,685.00) 22,190.00 20,275.00 91.4% 4040000 Club Rental 1,025.00 1,000.00 25.00 3,702.11 2,550.00 1,152.11 42,175.00 38,472.89 91.2% 4050000 Driving Range 3,250.00 1,400.00 1,850.00 8,049.00 4,500.00 3,549.00 102,000.00 93,951.00 92.1% 4060000 Handicap Fees - 250.00 (250.00) 494.00 700.00 (206.00) 4,595.00 4,101.00 89.2% 4090000 Ball Retriever/Subcontract - - - 750.00 - 750.00 6,500.00 5,750.00 88.5% 4091000 Golf Professional Rental Fee - - - - 500.00 (500.00) 2,500.00 2,500.00 100.0% Total Miscellaneous Revenue 49925.00 1309189.00 49150.00 1909504.00 775.00 (609315.00) 149910.11 285,516.02 119850.00 3879204.00 39060.11 (1019687.98) 1799960.00 495869743.00 1659049.89 493019226.98 91.7% 93.8% Total Revenue Fees Total Income 1309189.00 1909504.00 1 (609315.00) 2859516.02 3879204.00 1 (1019687.98) 495869743.00 4,301,226.98 93.8% 2 3 SilverRock Resort Golf Shop Income Statement September 2024 Month to Date Year to Date Annual Budget September Income 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 9.24 - 9.24 (2,512.52) - (2,512.52) 0 0 0% 4100110 Sales Hard Goods 5,285.81 2,362.00 2,923.81 12,260.21 5,080.00 7,180.21 61,406.00 49,145.79 80.0% 4100112 Sales -Soft Goods 5,129.92 7,087.00 (1,957.08) 10,057.92 15,243.00 (5,185.08) 185,638 175,580.21 94.6% 5100639 GS -Discounts -Mdse - - - - - - - - 0.0% Total Revenue Golf Shop 10,424.97 9,449.00 975.97 19,805.61 20,323.00 (517.39) 247,044.13 224,726.00 91.0% COS 5100150 COS -GS -Hard Goods 3,102.80 1,370.00 1,732.80 6,253.30 2,945.00 3,308.30 35,890.00 29,636.70 82.6% 5100151 COS -GS -Soft Goods 3,030.35 4,110.00 (1,079.65) 6,028.71 8,839.00 (2,810.29) 107,670.00 101,641.29 94.4% 5100152 COS -GS -Purchase Disc (30.05) (274.00) 243.95 (61.39) (590.00) 528.61 (7,178.00) (7,116.61) 0.0% 5100220 COS -GS -Freight Merch 131.46 82.00 49.46 509.00 175.00 334.00 2,153.00 1,644.00 76.4% Cost of Sales - Golf Shop 6,234.56 5,288.00 946.56 12,729.62 11,369.00 1,360.62 138,535.00 125,805.38 90.8% Gross Profit 4,190.41 4,161.00 29.41 7,075.99 8,954.00 (1,878.01) 108,509.13 98,920.62 91.2% COS % 59.8% 56.0% -3.8% 64.3% 55.9% -8.3% 53.1% 56.0% 105.5% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 474.87 1,539.00 (1,064.13) 1,732.94 4,617.00 (2,884.06) 18,468.00 16,735.06 90.6% 6101325 Insurance -Workers Comp 643.84 860.00 (216.16) 2,226.90 2,446.00 (219.10) 16,380.00 14,153.10 86.4% 6101720 Salaries 8,384.00 6,575.00 1,809.00 22,344.00 19,725.00 2,619.00 78,900.00 56,556.00 71.7% 6101800 Taxes -Employer Payroll 712.32 1,062.00 (349.68) 4,577.63 3,020.00 1,557.63 20,212.00 15,634.37 77.4% 6101880 Wages -Hourly 10,612.66 4,315.00 6,297.66 28,970.32 11,244.00 17,726.32 128,400.00 99,429.68 77.4% 6101882 Wages -Overtime - - - 6.60 - 6.60 - (6.60) 0.0% Total -PS-SALARIES & BENEFITS 20,827.69 14,351.00 6,476.69 59,858.39 41,052.00 18,806.39 262,360.00 202,501.61 77.2% 61 -PS OTHER EXPENSES 6103762 Supplies -Office 263.19 250.00 13.19 391.30 750.00 (358.70) 3000.00 2,608.70 87.0% 6109150 Dues and Subscriptions _ _ _ _ _ - 2300.00 2,300.00 100.0% 6109220 Freight & Delivery _ _ _ _ _ _ 75.00 75.00 100.0% 6109490 Miscellaneous 409.09 500.00 (90.91) 436.89 1,500.00 (1,063.11) 6,000.00 5,563.11 92.7% 6109500 ProShop Over/Under (1.05) - (1.05) 17.43 17.43 - (17.43) 0.0% 6109722 Seminars/Training 150.00 150.00 - 150.00 450.00 (300.00) 3,690.00 3,540.00 95.9% 6109810 Travel - Merchandise _ _ _ _ _ - 90.00 90.00 100.0% 6109820 Uniforms 322.41 100.00 222.41 629.26 300.00 329.26 2,400.00 1,770.74 73.8% 6117840 Telephones 62.12 110.00 (47.88) 336.04 330.00 6.04 1,320.00 983.96 74.5% Total - Other Expenses 1,205.76 1,110.00 95.76 1,960.92 3,330.00 (1,369.08) 18,875.00 16,914.08 89.6% Total Expenses -Golf Shop 22,033.45 15,461.00 6,572.45 61,819.31 44,382.00 17,437.31 281,235.00 219,415.69 78.0% Net Income (17,843.04) (11,300.00) (6,543.04) (54,743.32) (35,428.00) (19,315.32) (172,725.88) (120,495.08) 69.8% 3 4 SilverRock Resort Course Maintenance Expense Statement September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 9,691.92 8,106.00 1,585.92 28,475.07 24,318.00 4,157.07 100,863.00 72,387.93 71.8% 6311325 Insurance -Workers Comp 1,824.21 3,042.00 (1,217.79) 7,650.90 8,994.00 (1,343.10) 41,298.00 33,647.10 81.5% 6311720 Salaries 16,152.00 17,210.00 (1,058.00) 51,532.00 51,630.00 (98.00) 206,520.00 154,988.00 75.0% 6311800 Taxes -Employer Payroll 6,368.26 6,290.00 78.26 21,066.94 18,541.00 2,525.94 85,580.00 64,513.06 75.4% 6311880 Wages -Hourly 49,569.51 45,474.00 4,095.51 152,735.04 134,872.00 17,863.04 640,702.00 487,966.96 76.2% 6311882 Wages -Overtime 1,312.13 1,824.00 (511.87) 11,659.72 3,648.00 8,011.72 30,518.00 18,858.28 61.8% Total--CM-SALAR/ES & BENEFITS 849918.03 819946.00 29972.03 2739119.67 2429003.00 319116.67 191059481.00 832,361.33 75.3% 63 -CM -SUPPLIES & MATERIALS 1,335.87 8,000.00 (6,664.13) 5,782.56 23,000.00 (17,217.44) 47,000.00 41,217.44 87.7% 6313745 Chemicals 6313744 Fertilizer 4,193.90 9,000.00 (4,806.10) 22,546.21 19,000.00 3,546.21 114,000.00 91,453.79 80.2% 6313746 Flowers/Plants - - - - - - 13,000.00 13,000.00 100.0% 6313748 Fuel -Gasoline 7,515.67 6,800.00 715.67 16,193.69 20,400.00 (4,206.31) 81,600.00 65,406.31 80.2% 6313750 Golf Course Accessories - - - - - - 16,000.00 16,000.00 100.0% 6313756 POA Control - - - 8,542.53 - 8,542.53 10,000.00 1,457.47 14.6% 6313758 Miscellaneous Supp 499.66 750.00 (250.34) 1,614.88 2,250.00 (635.12) 5,950.00 4,335.12 72.9% 6313776 Sand 3,869.20 - 3,869.20 9,207.25 - 9,207.25 8,500.00 (707.25) -8.3% 6313778 Seed - - - - - - 150,000.00 150,000.00 100.0% 6313780 Small Tools & Non -Capital Equip 74.00 600.00 (526.00) 1,784.87 1,800.00 (15.13) 7,025.00 5,240.13 74.6% 6313782 Sod 5,799.87 1,000.00 4,799.87 10,251.23 11,000.00 (748.77) 15,500.00 5,248.77 33.9% 6313784 Topdressing 1,333.07 3,000.00 (1,666.93) 2,665.11 6,000.00 (3,334.89) 19,000.00 16,334.89 86.0% Total--CM-SUPPLIES & MATERIALS 249621.24 2%150.00 (49528.76) 78,588.33 83,450.00 (49861.67) 487,575.00 408,986.67 83.9% 63 -CM -REPAIRS & MAINTENANCE 4,346.00 4,346.00 - 13,038.00 13,038.00 - 52,152.00 39,114.00 75.0% 6315095 CM -R&M -Contract Lake Maint 6315685 CM-R&M-Bldngs & Othr Structures 129.50 500.00 (370.50) 638.50 1,500.00 (861.50) 6,000.00 5,361.50 89.4% 6315690 CM -R&M -Equipment 5,840.77 4,000.00 1,840.77 16,953.93 10,500.00 6,453.93 46,500.00 29,546.07 63.5% 6315692 CM -R&M -Irrigation System 5,522.66 3,000.00 2,522.66 11,470.05 12,500.00 (1,029.95) 33,250.00 21,779.95 65.5% 6315696 CM -R&M -Pumps - 1,000.00 (1,000.00) 1,522.50 3,000.00 (1,477.50) 10,500.00 8,977.50 85.5% 6315815 CM -R&M -Trees -Pruning Etc 13,319.00 6,000.00 7,319.00 13,319.00 6,000.00 7,319.00 16,550.00 3,231.00 19.5% Total -CM-Repair & Maintenance 299157.93 189846.00 109311.93 569941.98 469538.00 109403.98 164,952.00 108,010.02 65.5% 6317836 Utilities -Natural Gas/LPG 23.60 30.00 (6.40) 75.75 90.00 (14.25) 360.00 284.25 0.0% 6317840 Telephones 473.12 475.00 (1.88) 1,957.32 1,425.00 532.32 5,700.00 3,742.68 65.7% Total -CM -UTILITIES 496.72 505.00 (8.28) 29033.07 19515.00 518.07 6,060.00 4,026.93 66.5% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0% 6319100 Contract Svcs-Soil/Tissue Test - 1,500.00 (1,500.00) - 1,500.00 (1,500.00) 4,500.00 4,500.00 100.0% 6319102 Contract Svcs -Trash Removal 1,000.83 524.00 476.83 1,000.83 1,572.00 (571.17) 6,288.00 5,287.17 84.1% 6319150 Dues & Subscriptions 1,570.88 - 1,570.88 3,356.85 - 3,356.85 1,100.00 (2,256.85) -205.2% 6319170 Employee Education - 50.00 (50.00) 3,400.00 150.00 3,250.00 3,900.00 500.00 12.8% 6319197 Equipment Rental 222.37 150.00 72.37 222.37 500.00 (277.63) 3,400.00 3,177.63 93.5% 6319206 Licenses & Permits 1,116.46 - 1,116.46 2,231.46 100.00 2,131.46 4,300.00 2,068.54 48.1% 6319490 Miscellaneous 380.49 100.00 280.49 544.71 300.00 244.71 1,200.00 655.29 54.6% 6319718 Safety Equipment & Training 666.74 750.00 (83.26) 666.74 1,050.00 (383.26) 3,850.00 3,183.26 82.7% 6319822 Uniforms 984.43 1,210.00 (225.57) 3,740.47 3,630.00 110.47 14,520.00 10,779.53 74.2% Total -CM -OTHER EXPENSES 69342.20 4,684.00 19658.20 16,363.43 10,002.00 6,361.43 47,858.00 319494.57 65.81% 4 SilverRock Resort Course Maintenance Expense Statement September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 6321880 Contract Labor 30,351.88 22,000.00 8,351.88 82,856.13 66,000.00 16,856.13 264,000.00 181,143.87 68.6% Total Contract Service 309351.88 22,000.00 89351.88 82,856.13 669000.00 169856.13 2649000.00 181,143.87 68.6% Total -COURSE MAINTENANCE 175,888.00 1572131.00 18,757.00 509,902.61 449,508.00 60,394.61 2,075,926.00 1,566,023.39 75.4% Silverrock Resort Course Maintenance Water & Energy September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance 1 Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 6337834 Utilities -Electricity -Pumping 17,603.34 18,500.00 (896.66) 58,560.66 55,500.00 3,060.66 236,340.00 177,779.34 75.2% 6337842 Utilities -Water 12,970.34 8,880.00 4,090.34 37,546.24 25,140.00 12,406.24 97,244.00 59,697.76 61.4% Total -CM -WATER & ENERGY 30,573.68 27,380.00 3,193.68 96,106.90 80,640.00 15,466.90 333,584.00 237,477.10 71.2% SilverRock Resort Outside Services Expense Statement September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance -Group 590.92 1,026.00 (435.08) 2,624.43 3,078.00 (453.57) $ 16,416.00 13,791.57 84.0% 6411325 Insurance -Workers Comp 1,020.19 1,172.00 (151.81) 3,149.46 3,310.00 (160.54) $ 22,483.00 19,333.54 86.0% 6411800 Taxes -Employer Payroll 1,296.85 1,847.00 (550.15) 4,493.44 5,215.00 (721.56) $ 35,424.00 30,930.56 87.3% 6411880 Wages -Hourly 19,210.85 14,838.00 4,372.85 49,648.34 41,902.00 7,746.34 $ 284,534.00 234,885.66 82.6% 6411882 Wages -Overtime 183.32 - 183.32 598.13 - 598.13 $ - (598.13) 0.0% Total -CER -SALARIES & BENEFITS 22,302.13 - 18,883.00 - 39419.13 - 609513.80 - 539505.00 - 79008.80 - 358,857.00 1,850.00 298,343.20 83.1% 0.0% 641 -CBR -SUPPLIES & MATER/ALS 6413732 Supplies -Carts 6413742 Supplies -Expendable 147.73 150.00 (2.27) 443.19 1,350.00 (906.81) 6,750.00 6,306.81 93.4% 6413748 Supplies -Fuel for Shuttle _ _ _ _ _ _ _ _ 0.0% 6413752 Supplies -Range Balls - - - - - - 15,000.00 15,000.00 100.0% 6413762 Supplies -Office - 25.00 (25.00) - 75.00 (75.00) 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationary _ _ _ _ _ - 420.00 420.00 100.0% 6413786 Supplies -Towels 600.00 120.00 480.00 1,440.00 360.00 1,080.00 2,182.00 742.00 34.0% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 7,472.00 7,500.00 (28.00) 30,000.00 22,528.00 75.1% Total -CBR -SUPPLIES & MATER/ALS 747.73 458.55 29795.00 300.00 (29047.27) 158.55 99355.19 1,318.83 99285.00 900.00 70.19 418.83 56,727.00 3,600.00 45,521.81 2,281.17 80.2% 63.4% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 6415695 CBR -R&M -Cart Maintenance & Repai 7,796.75 3,603.00 4,193.75 17,605.50 10,809.00 6,796.50 18,036.00 430.50 2.4% Total -CBR -REPAIRS & MAINTENANCE 89255.30 1,037.07 3,903.00 800.00 49352.30 237.07 189924.33 2,832.91 119709.00 2,400.00 79215.33 432.91 21,636.00 9,600.00 2,711.67 6,767.09 12.5% 70.5% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) - 1,800.00 (1,800.00) 71200.00 7,200.00 100.0% 6419820 Uniforms - - - 47.45 - 47.45 5,200.00 5,152.55 99.1% Total -CBR -OTHER EXPENSES 19037.07 329342.23 858.45 19475.00 27,056.00 291.00 (437.93) (437.93) 567.45 29880.36 919673.68 1,821.50 49425.00 789924.00 807.00 (19544.64) 129749.68 1,014.50 $ 22,450.00 4599670.00 9,088.00 19,569.64 366,146.32 7,266.50 87.2% 79.7% 80.0% TOTAL-CARTS,BAGROOM & RANGE 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 6431800 Taxes -Employer Payroll 2,408.56 360.00 2,048.56 5,274.17 996.00 4,278.17 $ 11,214.00 5,939.83 53.0% 6431880 Wages -Hourly 6,420.32 3,689.00 2,731.32 15,605.61 10,217.00 5,388.61 $ 115,017.00 99,411.39 86.4% 6431882 Wages -Overtime - - - - - - $ - - 0.0% Total -CS -SALARIES & BENEFITS 99687.33 5,055.09 49340.00 100.00 59347.33 4,955.09 229701.28 5,055.09 129020.00 200.00 109681.28 4,855.09 135,319.00 1,050.00 112,617.72 (4,005.09) 83.2% -381.4% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 6439490 Miscellaneous _ _ _ _ - - 200.00 200.00 100.0% 6439718 Safety Equipment & Training - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0% 6439820 Uniforms - 75.00 (75.00) 394.35 225.00 169.35 2,125.00 1,730.65 81.4% Total -CS -OTHER EXPENSES 59055.09 225.00 49830.09 59449.44 575.00 49874.44 39975.00 (1,474.44) -37.1% Total -COURSE SERVICES 14,742.42 41565.00 109177.42 289150.72 129595.00 159555.72 1399294.00 111,143.28 79.8% TOTAL OUTSIDE SERVICES 47,084.65 31,621.00 15,463.65 119,824.40 91,519.00 28,305.40 598,964.00 478,764.04 79.9% SilverRock Resort Clubhouse Expense Statement September 2024 Month to Date Year to Date Annual Budget September Annual 2024 Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATERIALS 6503742 Supplies -Expendable 520.00 520.00 - 1,240.00 1,560.00 (320.00) 2,400.00 1,160.00 48.3% Total--CH-SUPPLIES & MATERIALS 520.00 520.00 - 1,240.00 1,560.00 (320.00) 2,400.00 1,160.00 48.3% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 986.32 1,000.00 (13.68) 2,212.22 3,000.00 (787.78) 12,000.00 9,787.78 81.6% 6507840 Utilities -Telephone 1,394.62 1,750.00 (355.38) 4,146.67 5,250.00 (1,103.33) 21,000.00 16,853.33 80.3% 6507842 Utilities -Water 655.92 608.00 47.92 1,906.64 1,824.00 82.64 7,296.00 5,389.36 73.9% 6507844 Utilities -Cable 426.32 420.00 6.32 1,277.71 1,260.00 17.71 5,040.00 3,762.29 74.6% Total -CH -UTILITIES 3,463.18 3,778.00 (314.82) 9,543.24 11,334.00 (1,790.76) 45,336.00 35,792.76 78.9% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 480.00 500.00 (20.00) 1,440.00 1,500.00 (60.00) 8,000.00 6,560.00 82.0% 6509099 Contract Services -Security 7,922.60 7,100.00 822.60 21,562.84 21,300.00 262.84 85,200.00 63,637.16 74.7% 6509215 Flowers & Decorations - - - - - - 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0% Total--CH-OTHER EXPENSES 8,402.60 470.78 7,700.00 300.00 702.60 170.78 23,002.84 1,959.37 23,100.00 900.00 (97.16) 1,059.37 96,300.00 3,600.00 73,297.16 1,640.63 76.1% 45.6% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 6515686 CH -R&M -Restaurant Repairs 700.00 700.00 - 700.00 2,100.00 (1,400.00) 8,400.00 7,700.00 91.7% 6515690 CH -R&M -Equipment Repair 740.10 700.00 40.10 2,096.58 2,100.00 (3.42) 8,400.00 6,303.42 75.0% Total -CH -REPAIRS & MAINTENANCE 1,910.88 14,296.66 1,700.00 13,698.00 210.88 598.66 4,755.95 38,542.03 5,100.00 41,094.00 (344.05) (2,551.97) 20,400.00 164,436.00 15,644.05 31,288.10 76.7% 19.0% Total CLUBHOUSE SilverRock Resort Marketing Expense Statement September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group - - - 415.23 - 415.23 $ 3,591.00 3,175.77 88.4% 6601325 Insurance -Workers Comp 107.31 99.00 8.31 305.31 297.00 8.31 $ 1,185.00 879.69 74.2% 6601720 Salaries 1,250.00 1,250.00 - 6,500.00 3,750.00 2,750.00 $ 15,000.00 8,500.00 56.7% 6601800 Tax -Employer Payroll 122.00 122.00 - 732.00 366.00 366.00 $ 1,462.00 730.00 49.9% Total -MKT -SALARIES & BENEFITS 1,479.31 - 1,471.00 100.00 8.31 (100.00) 7,952.54 - 4,413.00 300.00 3,539.54 (300.00) 21,238.00 1,200.00 13,285.46 1,200.00 62.6% 100.0% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office 6603768 Supplies -Printing & Stationery 56.92 200.00 (143.08) 2,046.78 200.00 1,846.78 4,425.00 2,378.22 53.7% Total -MKT -SUPPLIES & MARKET/NG 56.92 300.00 (243.08) 2,046.78 500.00 1,546.78 5,625.00 3,578.22 63.6% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 132.18 100.00 32.18 597.85 300.00 297.85 1,200.00 602.15 50.2% Total -MKT -UTILITIES 132.18 100.00 32.18 597.85 300.00 297.85 1,200.00 602.15 50.2% 66 -MKT -OTHER EXPENSES 6609010 Advertising 10,646.96 3,461.00 7,185.96 16,471.95 8,593.00 7,878.95 113,787.00 97,315.05 85.5% 6609040 Business Meals - 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0% 6609080 Collateral Material 2,805.00 500.00 2,305.00 3,824.31 1,500.00 2,324.31 21,000.00 17,175.69 81.8% 6609102 Contract Services -Web Page - 150.00 (150.00) - 450.00 (450.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions 198.00 - 198.00 198.00 - 198.00 735.00 537.00 73.1% 6609620 Postage 16.62 - 16.62 16.62 - 16.62 600.00 583.38 97.2% 6609490 Miscellaneous - 50.00 (50.00) - 150.00 (150.00) 400.00 400.00 100.0% 6609630 Promotion _ _ _ _ - - 1,000.00 1,000.00 100.0% 6609633 Promotion-Cummunity - 75.00 (75.00) - 225.00 (225.00) 2,250.00 2,250.00 100.0% 6609634 Promotion -Med iaNendor - - - - - - 700.00 700.00 100.0% 6609820 Uniforms - - - - - - 600.00 600.00 100.0% Total -MKT -OTHER EXPENSES 139666.58 49261.00 99405.58 209510.88 109993.00 99517.88 1439172.00 1229661.12 85.7% TOTAL MARKET/NG 15,334.99 6,132.00 9,202.99 31,108.05 16,206.00 14,902.05 171,235.00 140,126.95 81.8% SilverRock Resort General and Administrative Expense Statement September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 4,714.91 5,148.00 (433.09) 15,071.68 15,444.00 (372.32) $ 61,776.00 46,704.32 75.6% 6701325 Insurance -Workers Comp 429.23 2,052.00 (1,622.77) 4,513.27 6,156.00 (1,642.73) $ 24,621.00 20,107.73 81.7% 6701720 Salaries 20,726.06 20,170.00 556.06 59,916.21 60,510.00 (593.79) $ 242,040.00 182,123.79 75.2% 6701800 Taxes -Employer Payroll 4,091.03 2,532.00 1,559.03 9,928.90 7,596.00 2,332.90 $ 30,381.00 20,452.10 67.3% 6701880 Wages -Hourly 7,759.00 5,797.00 1,962.00 21,145.48 17,391.00 3,754.48 $ 69,564.00 48,418.52 69.6% 6701882 Wages -Overtime - - - - - - $ - - Total-G&A-SALAR/ES & BENEFITS 37,720.23 35,699.00 2,021.23 110,575.54 107,097.00 3,478.54 428,382.00 317,806.46 74.2% 67 -G&A -SUPPLIES & MATERIALS 155.64 500.00 (344.36) 606.01 1,500.00 (893.99) 6,300.00 5,693.99 90.4% 6703740 Supplies -Computer 6703762 Supplies -Office - 105.00 (105.00) 86.96 315.00 (228.04) 1,260.00 1,173.04 93.1% 6703768 Supplies -Printing & Stationery 173.11 100.00 73.11 306.22 300.00 6.22 3,300.00 2,993.78 90.7% Total -G&A -SUPPLIES & MATERIALS 328.75 - 705.00 1,000.00 (376.25) (1,000.00) 999.19 - 2,115.00 1,300.00 (1,115.81) (1,300.00) 10,860.00 7,300.00 9,860.81 7,300.00 90.8% 100.0% 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment Total -G&A -REPAIRS & MAINTENANCE - 1,000.00 (1,000.00) - 1,300.00 (1,300.00) 7,300.00 7,300.00 100.0% 67-GBA-0THER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0% 6709150 Dues & Subscriptions 235.00 300.00 (65.00) 1,283.47 350.00 933.47 1,550.00 266.53 17.2% 6709180 Employee Recruiting/Relocation - 150.00 (150.00) 35.00 150.00 (115.00) 1,200.00 1,165.00 97.1% 6709197 Equipment Rental 518.50 1,100.00 (581.50) 2,075.20 3,300.00 (1,224.80) 13,200.00 11,124.80 84.3% 6709202 Fees -Bank 63.50 90.00 (26.50) 225.99 270.00 (44.01) 1,080.00 854.01 79.1% 6709208 Fees -Payroll Processing 463.13 1,500.00 (1,036.87) 2,211.13 4,500.00 (2,288.87) 18,000.00 15,788.87 87.7% 6709220 Freight/Delivery - 50.00 (50.00) 26.45 150.00 (123.55) 600.00 573.55 95.6% 6709490 Miscellaneous - 100.00 (100.00) 1,249.70 300.00 949.70 6,000.00 4,750.30 79.2% 6709620 Postage/Mail Services - 75.00 (75.00) 299.15 225.00 74.15 900.00 600.85 66.8% 6709625 Expense Professional Fees 3,047.38 1,500.00 1,547.38 6,678.63 4,500.00 2,178.63 18,000.00 11,321.37 62.9% 6709636 Promotion/Entertainment 1,000.00 100.00 900.00 1,000.00 300.00 700.00 1,200.00 200.00 16.7% 6709722 Seminars & Training 250.00 200.00 50.00 250.00 600.00 (350.00) 3,400.00 3,150.00 92.6% 6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms - 150.00 (150.00) 332.40 450.00 (117.60) 2,000.00 1,667.60 83.4% Total-GBA-0THER EXPENSES 6,077.51 44,126.49 5,815.00 43,219.00 262.51 907.49 17,167.12 128,741.85 16,695.00 127,207.00 472.12 1,534.85 74,230.00 520,772.00 57,062.88 392,030.15 76.9% 75.3% Total -GENERAL & ADMINISTRATIVE Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement September 2024 Month to Date Year to Date Annual Budget September 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 68 -LEASES 6800193 Equipment Leases -Maintenance 19,412.38 18,150.00 1,262.38 58,197.82 54,450.00 3,747.82 252,600.00 194,402.18 77.0% 6800195 Trailer Lease - 5,200.00 (5,200.00) - 15,600.00 (15,600.00) - - - 6800196 Equipment Leases -GPS 5,130.83 5,072.00 58.83 15,624.99 15,216.00 408.99 60,864.00 45,239.01 74.3% 6800197 Equipment Leases -Others 821.59 1,150.00 (328.41) 2,504.09 3,450.00 (945.91) 20,200.00 17,695.91 87.6% Total -LEASES 25,364.80 29,572.00 (4,207.20) 76,326.90 88,716.00 (12,389.10) 333,664.00 257,337.10 77.1% 69-M/SC OTHER EXPENSES 11,437.00 11,437.00 - 34,311.00 34,309.00 2.00 137,232.00 102,921.00 75.0% 6900096 Contract Srvcs-Management Fee 6900210 FF&E Reserve 2,517.24 3,727.00 (1,209.76) 5,424.08 7,507.00 (2,082.92) 88,136.00 82,711.92 93.8% 6900323 Insurance -Commercial 5,799.40 4,600.00 1,199.40 17,386.15 13,800.00 3,586.15 55,200.00 37,813.85 68.5% 6900800 Personal Property Taxes - 5,000.00 (5,000.00) 5,455.14 11,000.00 (5,544.86) 15,000.00 9,544.86 63.6% Tota/--M/SC OTHER EXPENSES 19,753.64 24,764.00 (5,010.36)l 62,576.37 66,616.00 (4,039.63)l 295,568.00 232,991.63 78.8% SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report -2024-2025 Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf 8 8 11 12 3 15 67 39 79 4 79 50 117 0 0 0 0 0 0 0 10 C L