Loading...
06 December 2024 SilverRock Resort - Monthly Financial StatementSI LVERROCK® R E SORT Monthly Financial Statements July 01, 2024 - December 31, 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 Et Administrative Expense Statement 8 Operating Leases Ft Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement December 2024 Month to Date Year to Date Annual Budget _ G/L # Series Account Description December 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. % Bdgt Income 400000 407,857.00 453,315.00 (45,458.00) 17,908.00 22,300.00 (4,392.00) 18,632.52 28,200.00 (9,567.48) 73,473.25 86,010.00 (12,536.75) -10.0% -19.7% -33.9% -14.6% -12.20% 25.3% -5.4/ 6.6% -12.6% 30.1% -3.8% 21.0% 19.9% -2.6% 46.4% 14.7% 54.4% -5.1% -8.7% 10.0% -14.8% 1,074,149.91 1,406,469.00 (332,319.09) 49,996.11 53,300.00 (3,303.89) 54,881.49 78,223.00 (23,341.51) 215,535.33 253,210.00 (37,674.67) 4,406,783.00 179,960.00 247,518.00 774,989.00 3,332,633.09 129,963.89 192,636.51 559,453.67 24% 28% 22% 28% 25% Golf Green Fee Revenue Miscellaneous Golf Revenue Revenue -Golf Shop Food & Beverage Revenue Total Income 401000 410000 420000 510000 517,870.77 589,825.00 (71,954.23) 1,394,562.84 1,791,202.00 (396,639.16) 5,609,250.00 4,214,687.16 Cost of Goods Sold 11,790.70 $ 15,783.00 (3,992.30) 25,980.99 $ 24,651.00 1,329.99 35,021.97 43,774.00 8,752.03 98,716.43 73,298.00 (25,418.43) 138,526.00 221,939.00 103,504.03 123,222.57 25% 44% 37% COS -Golf Shop COS -Food & Beverage Total COS 520000 610000 37,771.69 40,434.00 (2,662.31) 133,738.40 117,072.00 (16,666.40) 360,465.00 226,726.60 Gross Profit 480,099.08 549,391.00 (69,291.92) 1,260,824.44 1,674,130.00 (413,305.56) 5,248,785.00 3,987,960.56 24% 39% 58% 51% 38% 47% 35% 46% 34% 43% 43% 47% 19,806.92 28,351.00 (8,544.08) 162,675.77 156,756.00 5,919.77 19,762.39 25,025.00 (5,262.61) 47,053.77 58,768.00 (11,714.23) 14,055.97 13,698.00 357.97 9,313.42 17,375.00 (8,061.58) 40,169.04 47,069.00 (6,899.96) 15,820.17 34,722.00 (18,901.83) 26,372.62 25,103.00 1,269.62 65,413.88 60,177.00 5,236.88 110,355.96 112,453.00 (2,097.04) 1,196,494.46 1,136,108.00 60,386.46 168,726.02 167,465.00 1,261.02 227,121.34 248,729.00 (21,607.66) 79,228.13 84,688.00 (5,459.87) 59,635.09 73,125.00 (13,489.91) 237,656.07 261,714.00 (24,057.93) 142,880.72 187,732.00 (44,851.28) 127,537.85 139,349.00 (11,811.15) 230,225.71 243,909.00 (13,683.29) 281,235.00 2,076,015.00 333,584.00 598,965.00 168,276.00 170,826.00 520,777.00 421,264.00 295,568.00 609,573.00 170,879.04 879,520.54 164,857.98 371,843.66 89,047.87 111,190.91 283,120.93 278,383.28 168,030.15 379,347.29 Expenses I Golf Pro Shop Course Maintenance Maintenance Water & Energy Outside Services Clubhouse Marketing General & Administrative Leases Miscellaneous Other Expense Food & Beverage Expenses Total Expenses 630000 633000 640000 650000 660000 670000 680000 690000 620000 5,476,083.00 2,516,874.36 420,443.95 467,044.00 (46,600.05) 2,579,861.35 2,655,272.00 (75,410.65) Net Income (1,319,036.91) (981,142.00) (337,894.91) (227,298.00) 1,471,086.20 59,655.13 82,347.00 (22,691.87) 400000 Rounds of Golf Played 4,026 4,700 (674) 101.31 96.45 4.86 4.63 6.00 (1.37) 4.45 4.74 (0.30) -14.3% 5.0% -22.9% -6.3% 12,092 16,550 (4,458) 88.83 84.98 3.85 4.54 4.73 (0.19) 4.13 3.22 0.91 44,545 98.93 5.56 4.04 32,453 10.10 1.02 (0.09) 27% 90% 82% 102% Paid Rounds Played Ave $ Per Paid Round Green Fee Ave $ Per Paid Round Merchandise Ave $ Per Paid Miscellaneous 1 2 SilverRock Resort Statement of Fees - Revenue December 2024 1 Month to Date Year to Date Annual Budget December Income 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 407,857.00 453,315.00 (45,458.00) 1,074,149.91 1,406,469.00 (332,319.09) 4,406,783.00 3,332,633.09 75.6% 4010000 Rider Fee 2,005.00 3,100.00 (1,095.00) 5,950.00 9,200.00 (3,250.00) 22,190.00 16,240.00 73.2% 4040000 Club Rental 4,775.00 4,500.00 275.00 11,262.11 10,950.00 312.11 42,175.00 30,912.89 73.3% 4050000 Driving Range 10,615.00 13,000.00 (2,385.00) 30,304.00 27,500.00 2,804.00 102,000.00 71,696.00 70.3% 4060000 Handicap Fees 513.00 700.00 (187.00) 1,235.00 2,650.00 (1,415.00) 4,595.00 3,360.00 73.1% 4090000 Ball Retriever/Subcontract - 1,000.00 (1,000.00) 945.00 2,000.00 (1,055.00) 6,500.00 5,555.00 85.5% 4091000 Golf Professional Rental Fee - - - 300.00 1,000.00 (700.00) 2,500.00 2,200.00 88.0% Total Miscellaneous Revenue 17,908.00 22,300.00 (4,392.00) 49,996.11 53,300.00 (3,303.89) 179,960.00 129,963.89 72.2% 425,765.00 475,615.00 (49,850.00) 1,124,146.02 1,459,769.00 (335,622.98) 4,586,743.00 3,462,596.98 75.5% Total Revenue Fees Total Income 425,765.00 475,615.00 (49,850.00)1 1,124,146.021 1,459,769.00 (335,622.98)1 4,586,743.00 3,462,596.98 75,5% 1 2 3 SilverRock Golf Shop December Resort Income Statement 2024 Month to Date Year to Date Annual Budget December Income 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous - - - (2,512.52) - (2,512.52) 0 0 0% 4100110 Sales Hard Goods 8,011.39 7,050.00 961.39 27,700.38 19,555.00 8,145.38 61,406.00 33,705.62 54.9% 4100112 Sales -Soft Goods 10,621.13 21,150.00 (10,528.87) 29,693.63 58,668.00 (28,974.37) 185,638 155,944.50 84.0% 5100639 GS -Discounts -Mdse - - - - - - - - 0.0% Total Revenue Golf Shop 18,632.52 28,200.00 (9,567.48) 54,881.49 78,223.00 (23,341.51) 247,044.13 189,650.12 76.8% COS 5100150 COS -GS -Hard Goods 4,372.98 4,089.00 283.98 14,681.33 11,340.00 3,341.33 35,890.00 21,208.67 59.1% 5100151 COS -GS -Soft Goods 7,138.44 12,267.00 (5,128.56) 19,441.05 34,025.00 (14,583.95) 107,670.00 88,228.95 81.9% 5100152 COS -GS -Purchase Disc (273.80) (818.00) 544.20 (1,000.46) (2,269.00) 1,268.54 (7,178.00) (6,177.54) 0.0% 5100220 COS -GS -Freight Merch 553.08 245.00 308.08 1,900.05 678.00 1,222.05 2,153.00 252.95 11.7% Cost of Sales - Golf Shop 11,790.70 15,783.00 (3,992.30) 35,021.97 43,774.00 (8,752.03) 138,535.00 103,513.03 74,7% Gross Profit 6,841.82 12,417.00 (5,575.18) 19,859.52 34,449.00 (14,589.48) 108,509.13 86,137.09 79,4% COS % 63.3% 56.0% -7.3% 63.8% 56.0% -7.9% 53.1% 54.6% 102.8% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 398.50 1,539.00 (1,140.50) 2,891.46 9,234.00 (6,342.54) 18,468.00 15,576.54 84.3% 6101325 Insurance -Workers Comp 824.20 1,721.00 (896.80) 4,371.20 6,448.00 (2,076.80) 16,380.00 12,008.80 73.3% 6101720 Salaries 6,384.00 6,575.00 (191.00) 41,496.00 39,450.00 2,046.00 78,900.00 37,404.00 47.4% 6101800 Taxes -Employer Payroll 1,349.40 2,124.00 (774.60) 7,672.83 7,959.00 (286.17) 20,212.00 12,539.17 62.0% 6101880 Wages -Hourly 10,414.01 15,207.00 (4,792.99) 48,780.91 42,177.00 6,603.91 128,400.00 79,619.09 62.0% 6101882 Wages -Overtime 45.56 - 45.56 55.54 - 55.54 - (55.54) 0.0% Total -PS-SALARIES & BENEFITS 19,415.67 27,166.00 (7,750.33) 105,267.94 105,268.00 (0.06) 262,360.00 157,092.06 59.9% 61 -PS OTHER EXPENSES 6103762 Supplies -Office - 250.00 (250.00) 862.00 1,500.00 (638.00) 3000.00 2,138.00 71.3% 6109150 Dues and Subscriptions - _ - - - - 2300.00 2,300.00 100.0% 6109220 Freight & Delivery - 25.00 (25.00) - 75.00 (75.00) 75.00 75.00 100.0% 6109490 Miscellaneous 13.70 500.00 (486.30) 675.45 3,000.00 (2,324.55) 6,000.00 5,324.55 88.7% 6109500 ProShop Over/Under (1.56) - (1.56) 1.88 1.88 - (1.88) 0.0% 6109722 Seminars/Training 250.00 100.00 150.00 400.00 1,050.00 (650.00) 3,690.00 3,290.00 89.2% 6109810 Travel - Merchandise - _ - - - - 90.00 90.00 100.0% 6109820 Uniforms 59.26 200.00 (140.74) 2,610.80 900.00 1,710.80 2,400.00 (210.80) -8.8% 6117840 Telephones 69.85 110.00 (40.15) 537.89 660.00 (122.11) 1,320.00 782.11 59.3% Total - Other Expenses 391.25 1,185.00 (793.75) 5,088.02 7,185.00 (2,096.98) 18,875.00 13,786.98 73.0% Total Expenses -Golf Shop 19,806.92 28,351.00 (8,544.08) 110,355.96 112,453.00 (2,097.04) 281,235.00 170,879.04 60.8% Net Income 112,965.10) (15,934.00) 2,968.90 190,496.44) 178,004.00) (12,492.44) (172,725.88) (84,741.96) 49.1% 3 SilverRock Resort Course Maintenance Expense Statement December 2024 4 Month to Date Year to Date Annual Budget December 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 63 Expense -CM -SALARIES & BENEFITS 6311320 Insurance -Group 9,561.44 8,619.00 942.44 57,902.16 49,662.00 8,240.16 100,863.00 42,960.84 42.6% 6311325 Insurance -Workers Comp 2,346.04 3,532.00 (1,185.96) 15,158.93 19,915.00 (4,756.07) 41,298.00 26,139.07 63.3% 6311720 Salaries 16,152.00 17,210.00 (1,058.00) 99,988.00 103,260.00 (3,272.00) 206,520.00 106,532.00 51.6% 6311800 Taxes -Employer Payroll 5,128.76 7,235.00 (2,106.24) 37,134.18 41,496.00 (4,361.82) 85,580.00 48,445.82 56.6% 6311880 Wages -Hourly 50,318.63 57,000.00 (6,681.37) 308,321.69 300,640.00 7,681.69 640,702.00 332,380.31 51.9% 6311882 Wages -Overtime 1,571.06 - 1,571.06 20,704.66 21,700.00 (995.34) 30,518.00 9,813.34 32.2% Total -CM -SALARIES & BENEFITS 85,077.93 93,596.00 (8,518.07) 539,209.62 536,673.00 2,536.62 1,105,481.00 566,271.38 51.2% 63 -CM -SUPPLIES & MATERIALS 6313745 Chemicals 3,117.21 - 3,117.21 26,657.98 33,000.00 (6,342.02) 47,000.00 20,342.02 43.3% 6313744 Fertilizer 15,349.54 10,000.00 5,349.54 84,514.04 69,000.00 15,514.04 114,000.00 29,485.96 25.9% 6313746 Flowers/Plants -- - 1,895.93 6,000.00 (4,104.07) 13,000.00 11,104.07 85.4% 6313748 Fuel -Gasoline 4,399.72 6,800.00 (2,400.28) 31,492.08 40,800.00 (9,307.92) 81,600.00 50,107.92 61.4% 6313750 Golf Course Accessories 301.20 - 301.20 13,376.15 14,000.00 (623.85) 16,000.00 2,623.85 16.4% 6313756 POA Control 10,815.11 10,000.00 815.11 19,357.64 10,000.00 9,357.64 10,000.00 (9,357.64) -93.6% 6313758 Miscellaneous Supp 375.97 500.00 (124.03) 3,403.22 3,750.00 (346.78) 5,950.00 2,546.78 42.8% 6313776 Sand 7,111.72 - 7,111.72 23,672.77 8,500.00 15,172.77 8,500.00 (15,172.77) -178.5% 6313778 Seed -- - 147,630.50 150,000.00 (2,369.50) 150,000.00 2,369.50 1.6% 6313780 Small Tools & Non -Capital Equip 142.02 575.00 (432.98) 2,095.25 3,575.00 (1,479.75) 7,025.00 4,929.75 70.2% 6313782 Sod -- - 10,251.23 11,000.00 (748.77) 15,500.00 5,248.77 33.9% 6313784 Topdressing -- - 3,334.47 6,000.00 (2,665.53) 19,000.00 15,665.53 82.5% Total -CM -SUPPLIES & MATERIALS 41,612.49 27,875.00 13,737.49 367,681.26 355,625.00 12,056.26 487,575.00 119,893.74 24.6% 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 4,346.00 4,346.00 - 26,076.00 26,076.00 - 52,152.00 26,076.00 50.0% 6315685 CM-R&M-Bldngs & Othr Structures 70.00 500.00 (430.00) 1,248.50 3,000.00 (1,751.50) 6,000.00 4,751.50 79.2% 6315690 CM -R&M -Equipment 5,720.21 2,500.00 3,220.21 35,234.65 28,000.00 7,234.65 46,500.00 11,265.35 24.2% 6315692 CM -R&M -Irrigation System 2,956.51 1,500.00 1,456.51 22,838.60 18,500.00 4,338.60 33,250.00 10,411.40 31.3% 6315696 CM -R&M -Pumps - 1,000.00 (1,000.00) 2,522.50 6,000.00 (3,477.50) 10,500.00 7,977.50 76.0% 6315815 CM -R&M -Trees -Pruning Etc - - - 23,319.00 6,550.00 16,769.00 16,550.00 (6,769.00) -40.9% Total -CM-Repair & Maintenance 13,092.72 9,846.00 3,246.72 111,239.25 88,126.00 23,113.25 164,952.00 53,712.75 32.6% 6317836 Utilities -Natural Gas/LPG 3.11 30.00 (26.89) 155.95 180.00 (24.05) 360.00 204.05 0.0% 6317840 Telephones 475.49 475.00 0.49 2,988.49 2,850.00 138.49 5,700.00 2,711.51 47.6% Total -CM -UTILITIES 478.60 505.00 (26.40) 3,144.44 3,030.00 114.44 6,060.00 2,915.56 48.1% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0% 6319100 Contract Svcs-Soil/Tissue Test -- - 362.00 1,500.00 (1,138.00) 4,500.00 4,138.00 92.0% 6319102 Contract Svcs -Trash Removal - 524.00 (524.00) 1,417.58 3,144.00 (1,726.42) 6,288.00 4,870.42 77.5% 6319150 Dues & Subscriptions 375.00 - 375.00 3,731.85 - 3,731.85 1,100.00 (2,631.85) -239.3% 6319170 Employee Education - 50.00 (50.00) 3,400.00 300.00 3,100.00 3,900.00 500.00 12.8% 6319197 Equipment Rental 261.32 200.00 61.32 2,826.47 2,300.00 526.47 3,400.00 573.53 16.9% 6319206 Licenses & Permits 75.00 50.00 25.00 2,441.46 400.00 2,041.46 4,300.00 1,858.54 43.2% 6319490 Miscellaneous - 100.00 (100.00) 939.78 600.00 339.78 1,200.00 260.22 21.7% 6319718 Safety Equipment & Training - 400.00 (400.00) 771.10 2,750.00 (1,978.90) 3,850.00 3,078.90 80.0% 6319822 Uniforms 772.83 1,210.00 (437.17) 6,651.52 7,260.00 (608.48) 14,520.00 7,868.48 54.2% Total -CM -OTHER EXPENSES 1,884.15 2,934.00 (1,049.85) 24,941.76 20,654.00 4,287.76 47,858.00 22,916.24 47.88% 4 SilverRock Resort Course Maintenance Expense Statement December 2024 4 Month to Date Year to Date Annual Budget December Variance Final Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 20,529.88 22,000.00 (1,470.12) 150,278.13 132,000.00 18,278.13 264,000.00 113,721.87 43.1% 43.1% 42.4% 6321880 Contract Labor Total Contract Service 20,529.88 22,000.00 (1,470.12) 150,278.13 132,000.00 18,278.13 264,000.00 113,721.87 Total -COURSE MAINTENANCE 162,675.77 156,756.00 5,919.77 1,196,494.46 1,136,108.00 60,386.46 2,075,926.00 879,431.54 Silverrock Resort Course Maintenance Water & Energy December 2024 Month to Date Year to Date Annual Budget December Variance Final Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 13,365.88 6,396.51 21,240.00 (7,874.12) 3,785.00 2,611.51 104,218.36 114,380.00 64,507.66 53,085.00 (10,161.64) 11,422.66 236,340.00 97,244.00 132,121.64 32,736.34 55.9% 33.7% 49.4% 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total -CM -WATER & ENERGY 19,762.39 25,025.00 (5,262.61) 168,726.02 167,465.00 1,261.02 333,584.00 164,857.98 4 SilverRock Resort Outside Services Expense Statement December 2024 Expense -SALARIES & BENEFITS 6411320 Insurance -Group 6411325 Insurance -Workers Comp 6411800 Taxes -Employer Payroll 6411880 Wages -Hourly 6411882 Wages -Overtime Total -CBR -SALARIES & BENEFITS 641 -CBR -SUPPLIES & MATER/ALS 6413732 Supplies -Carts 6413742 Supplies -Expendable 6413748 Supplies -Fuel for Shuttle 6413752 Supplies -Range Balls 6413762 Supplies -Office 6413768 Supplies -Printing and Stationary 6413786 Supplies -Towels 6413796 Supplies -Bottled Water Total -CBR -SUPPLIES & MATER/ALS 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 6415695 CBR -R&M -Cart Maintenance & Repai Total -CBR -REPAIRS & MAINTENANCE 641 -CBR -OTHER EXPENSES 6419094 6419220 6419490 6419820 Contract Services-Laundry/Linen Freight/Delivery Miscellaneous Uniforms Total -CBR -OTHER EXPENSES TOTAL-CARTS,BAGROOM & RANGE 643 -CS -SALARIES & BENEFITS 6431325 6431800 6431880 6431882 Total -CS -SALARIES & BENEFITS Insurance -Workers Comp Taxes -Employer Payroll Wages -Hourly Wages -Overtime 643 -CS -OTHER EXPENSES 6433742 6439490 6439718 6439820 Supplies Expendable Miscellaneous Safety Equipment & Training Uniforms Total -CS -OTHER EXPENSES Total -COURSE SERVICES TOTAL OUTSIDE SERVICES Month to Date December 2024 Final Budget Variance 362.91 1,456.98 1,892.21 22,239.09 1,128.15 1,539.00 2,130.00 3,357.00 26,960.00 (1,176.09) (673.02) (1,464.79) (4,720.91) 1,128.15 27,079.34 33,986.00 (6,906.66) 3,586.45 3,586.45 44.68 2,012.00 2,056.68 1,352.68 422.09 267.18 2,041.95 500.00 150.00 50.00 195.00 2,500.00 3,395.00 300.00 3,603.00 (500.00) 3,436.45 (50.00) (195.00) (2,500.00) 191.45 (255.32) (1,591.00) 3,903.00 (1,846.32) 800.00 75.00 600.00 500.00 1,975.00 34,764.42 43,259.00 1,139.01 832.32 10,241.92 1,011.00 1,248.00 12,800.00 552.68 (75.00) (177.91) (232.82) 66.95 66.95 128.01 (415.68) (2,558.08) 12,213.25 15,059.00 (2,845.75) 76.10 76.10 100.00 50.00 50.00 250.00 450.00 (23.90) (50.00) (50.00) (250.00) (373.90) 12,289.35 15,509.00 (3,219.65) 47,053.77 58,768.00 (11,714.23) Year to Date Final Budget Variance 3,919.39 6,306.43 7,560.84 86,047.23 2,601.34 7,182.00 8,258.00 13,014.00 104,534.00 (3,262.61) (1,951.57) (5,453.16) (18,486.77) 2,601.34 106,435.23 132,988.00 (26,552.77) 4,841.23 14,681.25 1,920.00 14,960.00 1,500.00 3,450.00 15,000.00 225.00 860.00 15,000.00 36,402.48 36,035.00 1,363.51 23,641.50 1,800.00 21,618.00 25,005.01 23,418.00 4,658.98 1,653.50 3,706.45 10,018.93 4,800.00 450.00 3,600.00 3,000.00 (1,500.00) 1,391.23 (318.75) (225.00) 1,060.00 (40.00) 367.48 (436.49) 2,023.50 1,587.01 (141.02) (450.00) (1,946.50) 706.45 11,850.00 (1,831.07) 177,861.65 204,291.00 (26,429.35) 4,327.11 6,499.01 30,660.17 2,829.00 3,492.00 35,817.00 41,486.29 42,138.00 5,131.19 41.23 2,600.98 500.00 150.00 300.00 1,350.00 7,773.40 2,300.00 49,259.69 1,498.11 3,007.01 (5,156.83) (651.71) 4,631.19 (108.77) (300.00) 1,250.98 5,473.40 44,438.00 4,821.69 227,121.34 248,729.00 (21,607.66) Annual Budget Annual Budget Unemcumb. % Budget 16,416.00 22,483.00 35,424.00 284, 534.00 12,496.61 16,176.57 27,863.16 198,486.77 (2,601.34) 358,857.00 252,421.77 1,850.00 6,750.00 15,000.00 525.00 420.00 2,182.00 30,000.00 56,727.00 3,600.00 18,036.00 21,636.00 9,600.00 450.00 7,200.00 5,200.00 22,450.00 1,908.77 318.75 525.00 420.00 262.00 15, 040.00 18,474.52 76.1% 72.0% 78.7% 69.8% 0.0% 70.3% 0.0% 28.3% 0.0% 2.1% 100.0% 100.0% 12.0% 50.1% 32.6% 2,236.49 62.1% (5,605.50) -31.1% 13,369.01) -15.6% 4,941.02 450.00 5,546.50 1,493.55 12,431.07 51.5% 100.0% 77.0% 28.7% 55.4% 459,670.00 279,958.35 60.9% 9,088.00 11,214.00 115,017.00 135,319.00 1,050.00 200.00 600.00 2,125.00 3,975.00 139,294.00 4,760.89 4,714.99 84,356.83 93,832.71 (4,081.19) 158.77 600.00 (475.98) (3,798.40) 90,034.31 52.4% 42.0% 73.3% 0.0% 69.3% -388.7% 79.4% 100.0% -22.4% -95.6% 64.6% 598,964.00 373,791.06 62.4% 5 6 SilverRock Resort Clubhouse Expense Statement December 2024 Month to Date Year to Date Annual Budget December 2024 Final Budget Variance Budget Variance Variance Annual Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MA TERIALS 6503742 Supplies -Expendable 520.00 520.00 - 2,800.00 3,120.00 (320.00) 2,400.00 (400.00) -16.7% Total -CH -SUPPLIES & MATERIALS 520.00 520.00 - 2,800.00 3,120.00 (320.00) 2,400.00 (400.00) -16.7% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 1,000.00 1,000.00 - 5,014.92 6,000.00 (985.08) 12,000.00 6,985.08 58.2% 6507840 Utilities -Telephone 1,527.49 1,750.00 (222.51) 8,479.08 10,500.00 (2,020.92) 21,000.00 12,520.92 59.6% 6507842 Utilities -Water 661.35 608.00 53.35 4,035.73 3,648.00 387.73 7,296.00 3,260.27 44.7% 6507844 Utilities -Cable 432.32 420.00 12.32 2,568.67 2,520.00 48.67 5,040.00 2,471.33 49.0% Total -CH -UTILITIES 3,621.16 3,778.00 (156.84) 20,098.40 22,668.00 (2,569.60) 45,336.00 25,237.60 55.7% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 880.00 500.00 380.00 2,880.00 5,000.00 (2,120.00) 8,000.00 5,120.00 64.0% 6509099 Contract Services -Security 7,633.40 7,100.00 533.40 43,465.68 42,600.00 865.68 85,200.00 41,734.32 49.0% 6509215 Flowers & Decorations -- - - 500.00 (500.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous -- - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0% Total -CH -OTHER EXPENSES 8,513.40 7,700.00 813.40 46,345.68 48,700.00 (2,354.32) 96,300.00 49,954.32 51.9% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 897.59 300.00 597.59 4,342.20 1,800.00 2,542.20 3,600.00 (742.20) -20.6% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) 1,831.97 4,200.00 (2,368.03) 8,400.00 6,568.03 78.2% 6515690 CH -R&M -Equipment Repair 503.82 700.00 (196.18) 3,809.88 4,200.00 (390.12) 8,400.00 4,590.12 54.6% Total -CH -REPAIRS & MAINTENANCE 1,401.41 1,700.00 (298.59) 9,984.05 10,200.00 (215.95) 20,400.00 10,415.95 51.1% Total CLUBHOUSE 14,055.97 13,698.00 357.97 79,228.13 84,688.00 15,459.87) 164,436.00 20,831.90 12.7% 6 7 SilverRock Resort Marketing Expense Statement December 2024 Month to Date Year to Date Annual Budget December 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group 440.73 513.00 (72.27) 855.96 513.00 342.96 $ 3,591.00 2,735.04 76.2% 6601325 Insurance -Workers Comp 126.56 99.00 27.56 665.93 594.00 71.93 $ 1,185.00 519.07 43.8% 6601720 Salaries 1,250.00 1,250.00 - 10,250.00 7,500.00 2,750.00 $ 15,000.00 4,750.00 31.7% 6601800 Tax -Employer Payroll 122.00 122.00 - 1,098.00 732.00 366.00 $ 1,462.00 364.00 24.9% Total -MKT -SALARIES & BENEFITS 1,939.29 1,984.00 (44.71) 12,869.89 9,339.00 3,530.89 21,238.00 8,368.11 39.4% 66 -MKT -SUPPLIES & MATERIALS 6603762 Supplies -Office - 100.00 (100.00) 542.18 600.00 (57.82) 1,200.00 657.82 54.8% 6603768 Supplies -Printing & Stationery 1,243.18 200.00 1,043.18 3,925.08 3,600.00 325.08 4,425.00 499.92 11.3% Total -MKT -SUPPLIES & MARKETING 1,243.18 300.00 943.18 4,467.26 4,200.00 267.26 5,625.00 1,157.74 20.6% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 90.12 100.00 (9.88) 868.21 600.00 268.21 1,200.00 331.79 27.6% Total -MKT -UTILITIES 90.12 100.00 (9.88) 868.21 600.00 268.21 1,200.00 331.79 27.6% 66 -MKT -OTHER EXPENSES 6609010 Advertising 5,875.99 11,366.00 (5,490.01) 35,599.92 46,186.00 (10,586.08) 113,787.00 78,187.08 68.7% 6609040 Business Meals - 25.00 (25.00) - 150.00 (150.00) 300.00 300.00 100.0% 6609080 Collateral Material 54.67 2,500.00 (2,445.33) 5,300.55 9,000.00 (3,699.45) 21,000.00 15,699.45 74.8% 6609102 Contract Services -Web Page - 150.00 (150.00) - 900.00 (900.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions - - - 198.00 - 198.00 735.00 537.00 73.1% 6609620 Postage - 50.00 (50.00) 16.62 100.00 (83.38) 600.00 583.38 97.2% 6609490 Miscellaneous 38.17 50.00 (11.83) 38.17 300.00 (261.83) 400.00 361.83 90.5% 6609630 Promotion 72.00 - 72.00 72.00 - 72.00 1,000.00 928.00 92.8% 6609633 Promotion-Cummunity - 750.00 (750.00) - 1,800.00 (1,800.00) 2,250.00 2,250.00 100.0% 6609634 Promotion-MediaNendor - 50.00 (50.00) - 150.00 (150.00) 700.00 700.00 100.0% 6609820 Uniforms - 50.00 (50.00) 204.47 400.00 (195.53) 600.00 395.53 65.9% Total -MKT -OTHER EXPENSES 6,040.83 14,991.00 (8,950.17) 41,429.73 58,986.00 (17,556.27) 143,172.00 101,742.27 71.1% TOTAL MARKETING 9,313.42 17,375.00 (8,061.58) 59,635.09 73,125.00 (13,489.91)1 171,235.00 111,599.91 65.2% 7 SilverRock Resort General and Administrative Expense Statement December 2024 Month to Date Year to Date Annual Budget December 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 5,132.94 5,148.00 (15.06) 700.81 2,052.00 (1,351.19) 17,726.06 20,170.00 (2,443.94) 1,734.69 2,532.00 (797.31) 5,282.40 5,797.00 (514.60) 11.88 - 11.88 30,470.50 30,888.00 (417.50) 6,381.09 12,312.00 (5,930.91) 113,094.39 121,020.00 (7,925.61) 15,191.82 15,192.00 (0.18) 36,298.36 34,782.00 1,516.36 11.88 - 11.88 $ 61,776.00 31,305.50 50.7% $ 24,621.00 18,239.91 74.1% $ 242,040.00 128,945.61 53.3% $ 30,381.00 15,189.18 50.0% $ 69,564.00 33,265.64 47.8% $ - - 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 6701325 Insurance -Workers Comp 6701720 Salaries 6701800 Taxes -Employer Payroll 6701880 Wages -Hourly 6701882 Wages -Overtime Total-G&A-SALAR/ES & BENEFITS 201,448.04 214,194.00 (12,745.96) 428,382.00 226,933.96 53.0% 30,588.78 35,699.00 (5,110.22) 67 -G&A -SUPPLIES & MATER/ALS 809.32 3,000.00 (2,190.68) 148.98 630.00 (481.02) 576.37 900.00 (323.63) 6,300.00 5,490.68 87.2% 1,260.00 1,111.02 88.2% 3,300.00 2,723.63 82.5% 52.97 500.00 (447.03) 8.72 105.00 (96.28) - 400.00 (400.00) 6703740 Supplies -Computer 6703762 Supplies -Office 6703768 Supplies -Printing & Stationery Total -G&A -SUPPLIES & MATER/ALS 1,534.67 4,530.00 (2,995.33) 61.69 1,005.00 (943.31) 10,860.00 9,325.33 85.9% 67 -G&A -REPAIRS & MAINTENANCE 40.77 4,550.00 (4,509.23) 7,300.00 7,259.23 99.4% - 850.00 (850.00) 6705690 Repairs & Maintenance -Equipment Total -G&A -REPAIRS & MAINTENANCE 40.77 4,550.00 (4,509.23) 7,300.00 7,259.23 99.4% - 850.00 (850.00) 67 -G&A -OTHER EXPENSES 500.00 500.00 - - 50.00 (50.00) - 200.00 (200.00) 504.09 1,100.00 (595.91) 52.28 90.00 (37.72) 1,396.51 1,500.00 (103.49) - 50.00 (50.00) 6,000.00 4,000.00 2,000.00 84.19 75.00 9.19 981.50 1,500.00 (518.50) - 100.00 (100.00) - 200.00 (200.00) - - - - 150.00 (150.00) 3,000.00 3,000.00 - 1,518.47 500.00 1,018.47 35.00 650.00 (615.00) 5,250.43 6,600.00 (1,349.57) 362.01 540.00 (177.99) 4,464.35 9,000.00 (4,535.65) 26.45 300.00 (273.55) 7,411.70 5,400.00 2,011.70 748.93 450.00 298.93 9,873.13 9,000.00 873.13 1,000.00 600.00 400.00 250.00 1,200.00 (950.00) - 100.00 (100.00) 692.12 1,100.00 (407.88) 6,000.00 3,000.00 50.0% 1,550.00 31.53 2.0% 1,200.00 1,165.00 97.1% 13,200.00 7,949.57 60.2% 1,080.00 717.99 66.5% 18,000.00 13,535.65 75.2% 600.00 573.55 95.6% 6,000.00 (1,411.70) -23.5% 900.00 151.07 16.8% 18,000.00 8,126.87 45.1% 1,200.00 200.00 16.7% 3,400.00 3,150.00 92.6% 1,100.00 1,100.00 100.0% 2,000.00 1,307.88 65.4% 6709020 Auto/Mileage Allowance 6709150 Dues & Subscriptions 6709180 Employee Recruiting/Relocation 6709197 Equipment Rental 6709202 Fees -Bank 6709208 Fees -Payroll Processing 6709220 Freight/Delivery 6709490 Miscellaneous 6709620 Postage/Mail Services 6709625 Expense Professional Fees 6709636 Promotion/Entertainment 6709722 Seminars & Training 6709810 Travel 6709820 Uniforms Total -G&A -OTHER EXPENSES 34,632.59 38,440.00 (3,807.41) 9,518.57 9,515.00 3.57 74,230.00 39,597.41 53.3% Total -GENERAL & ADMINISTRATIVE 40,169.04 47,069.00 (6,899.96) 237,656.07 261,714.00 (24,057.93) 520,772.00 283,115.93 54.4% 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement December 2024 Month to Date Year to Date Annual Budget December 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 6800193 6800195 6800196 6800197 69-MISC Expense 10,642.68 - 5,130.83 46.66 22,500.00 5,200.00 5,072.00 1,950.00 (11,857.32) (5,200.00) 58.83 (1,903.34) 107,665.26 - 31,017.48 4,197.98 117,600.00 31,200.00 30,432.00 8,500.00 (9,934.74) (31,200.00) 585.48 (4,302.02) 252,600.00 - 60,864.00 20,200.00 144,934.74 - 29,846.52 16,002.02 57.4% - 49.0% 79.2% 57.2% 50.0% 75.6% 42.1% 63.6% 56.8% 68 -LEASES Equipment Leases -Maintenance Trailer Lease Equipment Leases -GPS Equipment Leases -Others Total -LEASES 15,820.17 34,722.00 (18,901.83) 142,880.72 187,732.00 (44,851.28) 333,664.00 190,783.28 OTHER EXPENSES 11,437.00 8,157.14 6,778.48 - 11,437.00 9,066.00 4,600.00 - - (908.86) 2,178.48 - 68,622.00 21,494.96 31,965.75 5,455.14 68,620.00 28,129.00 27,600.00 15,000.00 2.00 (6,634.04) 4,365.75 (9,544.86) 137,232.00 88,136.00 55,200.00 15,000.00 68,610.00 66,641.04 23,234.25 9,544.86 6900096 Contract Srvcs-Management Fee 6900210 FF&E Reserve 6900323 Insurance -Commercial 6900800 Personal Property Taxes Total--M/SC OTHER EXPENSES 26,372.62 25,103.00 1,269.62 127,537.85 139,349.00 (11,811.15) 295,568.00 168,030.15 9 SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report -2024-2025 Comp Category Media Sales Promotion Golf Industry VIP Celebrity 2024 2024 2024 2024 2024 2024 July August September October November December PGA Comp 8 8 11 Charity/Gift Certificate 12 Rain/Wind Checks 3 15 Club Staff 67 39 79 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 4 8 8 11 24 8 11 4 8 48 6 79 50 117 0 59 77 2025 2025 2025 2025 2025 2025 January February March April May June 0 0 0 0 0 0 10