Loading...
04 October 2024 SilverRock Resort - Monthly Financial StatementSILVERROCK® RESORT Monthly Financial Statements July 01, 2024 - October 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 a Administrative Expense Statement 8 Operating Leases Et Miscellaneous Expense Statement 9 SilverRock Resort Summary Operating Income Statement October 2024 Month to Date Year to Date Annual Budget _ G/L # Series Account Description October 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. % Bdgt Income 400000 -- - 423.00 1,150.00 (727.00) -- - 1,180.06 - 1,180.06 #DIV/0! -63.2% #DIV/0! #DIV/0! 39.40% #DIV/0! #DIV/0! #DIV/0! 39.4% -5.3% 9.1% -0.4% -3.2% 8.4% 16.0% 19.9% 14.2% 31.6% -11.4% 9.1% 87.9% 270,605.91 375,354.00 (104,748.09) 15,333.11 13,000.00 2,333.11 19,805.61 20,323.00 (517.39) 67,347.73 72,430.00 (5,082.27) 4,406,783.00 179,960.00 247,518.00 774,989.00 4,136,177.09 164,626.89 227,712.39 707,641.27 6% 9% 8% 9% 7% Golf Green Fee Revenue Miscellaneous Golf Revenue Revenue -Golf Shop Food & Beverage Revenue Total Income 401000 410000 420000 510000 1,603.06 1,150.00 453.06 373,092.36 481,107.00 (108,014.64) 5,609,250.00 5,236,157.64 Cost of Goods Sold - $ - - - $ - - 12,729.62 11,369.00 (1,360.62) 29,121.52 21,207.00 (7,914.52) 138,526.00 221,939.00 125,796.38 192,817.48 9% 13% 12% COS -Golf Shop COS -Food & Beverage Total COS 520000 610000 -- - 41,851.14 32,576.00 (9,275.14) 360,465.00 318,613.86 Gross Profit 1,603.06 1,150.00 453.06 331,241.22 448,531.00 (117,289.78) 5,248,785.00 4,917,543.78 6/ 13,208.63 12,546.00 662.63 342,422.27 376,878.00 (34,455.73) 28,287.96 28,180.00 107.96 23,946.25 23,209.00 737.25 14,836.65 16,198.00 (1,361.35) 14,356.42 17,087.00 (2,730.58) 34,990.73 43,669.00 (8,678.27) 25,364.80 29,572.00 (4,207.20) 13,714.67 20,037.00 (6,322.33) 24,505.35 21,996.00 2,509.35 75,027.94 56,928.00 18,099.94 852,324.88 826,386.00 25,938.88 124,394.86 108,820.00 15,574.86 143,770.65 114,728.00 29,042.65 53,378.68 57,292.00 (3,913.32) 45,464.47 33,293.00 12,171.47 163,732.58 170,876.00 (7,143.42) 101,691.70 118,288.00 (16,596.30) 76,291.04 86,653.00 (10,361.96) 124,918.13 131,751.00 (6,832.87) 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 206,207.06 1,223,690.12 209,189.14 455,194.35 114,897.32 125,361.53 357,044.42 319,572.30 219,276.96 484,654.87 27% 41% 37% 24% 32% 27% 31% 24% 26% 26% 32% 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 3,230,433.20 535,633.73 589,372.00 (53,738.27) 1,760,994.93 1,705,015.00 55,979.93 Net Income (1,429,753.71) (1,256,484.00) (173,269.71) (227,298.00) 1,687,110.58 (534,030.67) (588,222.00) 54,191.33 400000 Rounds of Golf Played -- - - #DIV/0! #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 4,278 6,450 (2,172) 161.56 58.19 103.36 11.82 3.15 8.67 3.58 2.02 1.57 44,545 98.93 5.56 4.04 40,267 (62.63) (6.27) 0.46 10% 163% 213% 89% Paid Rounds Played Ave $ Per Paid Round Green Fee Ave $ Per Paid Round Merchandise Ave $ Per Paid Miscellaneous 1 SilverRock Resort Statement of Fees - Revenue October 2024 1 Month to Date Year to Date Annual Budget Income October 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 4010000 Rider Fee 4040000 Club Rental 4050000 Driving Range 4060000 Handicap Fees 4090000 Ball Retriever/Subcontract 4091000 Golf Professional Rental Fee Total Miscellaneous Revenue - - - - - - - - - - - - 228.00 650.00 (422.00) 195.00 - 195.00 - 500.00 (500.00) 423.00 1,150.00 (727.00) 270,605.91 375,354.00 (104,748.09) 1,915.00 3,600.00 (1,685.00) 3,702.11 2,550.00 1,152.11 8,049.00 4,500.00 3,549.00 722.00 1,350.00 (628.00) 945.00 - 945.00 - 1,000.00 (1,000.00) 15,333.11 13,000.00 2,333.11 4,406,783.00 4,136,177.09 93.9% 22,190.00 20,275.00 91.4% 42,175.00 38,472.89 91.2% 102,000.00 93,951.00 92.1% 4,595.00 3,873.00 84.3% 6,500.00 5,555.00 85.5% 2,500.00 2,500.00 100.0% 179,960.00 164,626.89 91.5% 423.00 1,150.00 (727.00) 285,939.02 388,354.00 (102,414.98) 4,586,743.00 4,300,803.98 93.8% Total Revenue Fees Total Income 423.00 1,150.00 (727.00)1 285,939.021 388,354.00 (102,414.98)1 4,586,743.00 4,300,803.98 93.8% I 2 3 SilverRock Golf Shop October Resort Income Statement 2024 Month to Date Year to Date Annual Budget October 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 - - - 12,260.21 5,080.00 7,180.21 61,406.00 49,145.79 80.0% 4100112 Sales -Soft Goods - - - 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 - - - 19,805.61 20,323.00 (517.39) 247,044.13 224,726.00 91.0% COS 5100150 COS -GS -Hard Goods - - - 6,253.30 2,945.00 3,308.30 35,890.00 29,636.70 82.6% 5100151 COS -GS -Soft Goods _ - - 6,028.71 8,839.00 (2,810.29) 107,670.00 101,641.29 94.4% 5100152 COS -GS -Purchase Disc _ - - (61.39) (590.00) 528.61 (7,178.00) (7,116.61) 0.0% 5100220 COS -GS -Freight Merch - - - 509.00 175.00 334.00 2,153.00 1,644.00 76.4% Cost of Sales - Golf Shop - - - 12,729.62 11,369.00 1,360.62 138,535.00 125,805.38 90.8% Gross Profit - - - 7,075.99 8,954.00 (1,878.01) 108,509.13 98,920.62 91.2% COS % #DIV/0! #DIV/0! #DIV/0! 64.3% 55.9% -8.3% 53.1% 56.0% 105.5% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 380.01 1,539.00 (1,158.99) 2,112.95 6,156.00 (4,043.05) 18,468.00 16,355.05 88.6% 6101325 Insurance -Workers Comp 525.05 639.00 (113.95) 2,751.95 3,085.00 (333.05) 16,380.00 13,628.05 83.2% 6101720 Salaries 6,384.00 6,575.00 (191.00) 28,728.00 26,300.00 2,428.00 78,900.00 50,172.00 63.6% 6101800 Taxes -Employer Payroll 716.34 789.00 (72.66) 5,293.97 3,809.00 1,484.97 20,212.00 14,918.03 73.8% 6101880 Wages -Hourly 2,826.12 1,519.00 1,307.12 31,796.44 12,763.00 19,033.44 128,400.00 96,603.56 75.2% 6101882 Wages -Overtime - - - 6.60 - 6.60 - (6.60) 0.0% Total -PS-SALARIES & BENEFITS 10,831.52 11,061.00 (229.48) 70,689.91 52,113.00 18,576.91 262,360.00 191,670.09 73.1% 61 -PS OTHER EXPENSES 6103762 Supplies -Office 239.01 250.00 (10.99) 630.31 1,000.00 (369.69) 3000.00 2,369.69 79.0% 6109150 Dues and Subscriptions - _ - - - - 2300.00 2,300.00 100.0% 6109220 Freight & Delivery - 25.00 (25.00) - 25.00 (25.00) 75.00 75.00 100.0% 6109490 Miscellaneous 224.86 500.00 (275.14) 661.75 2,000.00 (1,338.25) 6,000.00 5,338.25 89.0% 6109500 ProShop Over/Under - - - 17.43 17.43 - (17.43) 0.0% 6109722 Seminars/Training - 500.00 (500.00) 150.00 950.00 (800.00) 3,690.00 3,540.00 95.9% 6109810 Travel - Merchandise - _ - - - - 90.00 90.00 100.0% 6109820 Uniforms 1,851.09 100.00 1,751.09 2,480.35 400.00 2,080.35 2,400.00 (80.35) -3.3% 6117840 Telephones 62.15 110.00 (47.85) 398.19 440.00 (41.81) 1,320.00 921.81 69.8% Total - Other Expenses 2,377.11 1,485.00 892.11 4,338.03 4,815.00 (476.97) 18,875.00 14,536.97 77.0% Total Expenses -Golf Shop 13,208.63 12,546.00 662.63 75,027.94 56,928.00 18,099.94 281,235.00 206,207.06 73.3% Net Income (13,208.63) (12,546.00) (662.63) 167,951.95) (47,974.00) (19,977.95) (172,725.88) 1107,286.45) 62.1% 3 SilverRock Resort Course Maintenance Expense Statement October 2024 4 Month to Date Year to Date Annual Budget October 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 63 Expense -CM -SALARIES & BENEFITS 6311320 Insurance -Group 9,913.47 8,106.00 1,807.47 38,388.54 32,424.00 5,964.54 100,863.00 62,474.46 61.9% 6311325 Insurance -Workers Comp 1,785.14 3,940.00 (2,154.86) 9,436.04 12,934.00 (3,497.96) 41,298.00 31,861.96 77.2% 6311720 Salaries 16,152.00 17,210.00 (1,058.00) 67,684.00 68,840.00 (1,156.00) 206,520.00 138,836.00 67.2% 6311800 Taxes -Employer Payroll 5,876.57 8,590.00 (2,713.43) 26,943.51 27,131.00 (187.49) 85,580.00 58,636.49 68.5% 6311880 Wages -Hourly 55,266.66 54,897.00 369.66 208,001.70 189,769.00 18,232.70 640,702.00 432,700.30 67.5% 6311882 Wages -Overtime 6,459.50 16,000.00 (9,540.50) 18,119.22 19,648.00 (1,528.78) 30,518.00 12,398.78 40.6% Total -CM -SALARIES & BENEFITS 95,453.34 108,743.00 (13,289.66) 368,573.01 350,746.00 17,827.01 1,105,481.00 736,907.99 66.7% 63 -CM -SUPPLIES & MATERIALS 6313745 Chemicals 11,011.94 8,000.00 3,011.94 16,794.50 31,000.00 (14,205.50) 47,000.00 30,205.50 64.3% 6313744 Fertilizer 21,174.96 30,000.00 (8,825.04) 43,721.17 49,000.00 (5,278.83) 114,000.00 70,278.83 61.6% 6313746 Flowers/Plants 1,895.93 6,000.00 (4,104.07) 1,895.93 6,000.00 (4,104.07) 13,000.00 11,104.07 85.4% 6313748 Fuel -Gasoline 6,390.94 6,800.00 (409.06) 22,584.63 27,200.00 (4,615.37) 81,600.00 59,015.37 72.3% 6313750 Golf Course Accessories 11,283.75 14,000.00 (2,716.25) 11,283.75 14,000.00 (2,716.25) 16,000.00 4,716.25 29.5% 6313756 POA Control -- - 8,542.53 - 8,542.53 10,000.00 1,457.47 14.6% 6313758 Miscellaneous Supp 1,034.31 500.00 534.31 2,649.19 2,750.00 (100.81) 5,950.00 3,300.81 55.5% 6313776 Sand 6,482.71 6,000.00 482.71 15,689.96 6,000.00 9,689.96 8,500.00 (7,189.96) -84.6% 6313778 Seed 126,802.50 150,000.00 (23,197.50) 126,802.50 150,000.00 (23,197.50) 150,000.00 23,197.50 15.5% 6313780 Small Tools & Non -Capital Equip - 600.00 (600.00) 1,784.87 2,400.00 (615.13) 7,025.00 5,240.13 74.6% 6313782 Sod -- - 10,251.23 11,000.00 (748.77) 15,500.00 5,248.77 33.9% 6313784 Topdressing 669.36 - 669.36 3,334.47 6,000.00 (2,665.53) 19,000.00 15,665.53 82.5% Tota/ -CM -SUPPLIES & MATERIALS 186,746.40 221,900.00 (35,153.60) 265,334.73 305,350.00 (40,015.27) 487,575.00 222,240.27 45.6% 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 4,346.00 4,346.00 - 17,384.00 17,384.00 - 52,152.00 34,768.00 66.7% 6315685 CM-R&M-Bldngs & Othr Structures 540.00 500.00 40.00 1,178.50 2,000.00 (821.50) 6,000.00 4,821.50 80.4% 6315690 CM -R&M -Equipment 8,453.32 10,000.00 (1,546.68) 25,407.25 20,500.00 4,907.25 46,500.00 21,092.75 45.4% 6315692 CM -R&M -Irrigation System 6,537.42 3,000.00 3,537.42 18,007.47 15,500.00 2,507.47 33,250.00 15,242.53 45.8% 6315696 CM -R&M -Pumps - 1,000.00 (1,000.00) 1,522.50 4,000.00 (2,477.50) 10,500.00 8,977.50 85.5% 6315815 CM -R&M -Trees -Pruning Etc 10,000.00 550.00 9,450.00 23,319.00 6,550.00 16,769.00 16,550.00 (6,769.00) -40.9% Tota/ -CM-Repair & Maintenance 29,876.74 19,396.00 10,480.74 86,818.72 65,934.00 20,884.72 164,952.00 78,133.28 47.4% 6317836 Utilities -Natural Gas/LPG 49.87 30.00 19.87 125.62 120.00 5.62 360.00 234.38 0.0% 6317840 Telephones - 475.00 (475.00) 1,957.32 1,900.00 57.32 5,700.00 3,742.68 65.7% Total--CM-UTILITIES 49.87 505.00 (455.13) 2,082.94 2,020.00 62.94 6,060.00 3,977.06 65.6% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7% 6319100 Contract Svcs-Soil/Tissue Test 102.00 - 102.00 102.00 1,500.00 (1,398.00) 4,500.00 4,398.00 97.7% 6319102 Contract Svcs -Trash Removal - 524.00 (524.00) 1,000.83 2,096.00 (1,095.17) 6,288.00 5,287.17 84.1% 6319150 Dues & Subscriptions -- - 3,356.85 - 3,356.85 1,100.00 (2,256.85) -205.2% 6319170 Employee Education - 50.00 (50.00) 3,400.00 200.00 3,200.00 3,900.00 500.00 12.8% 6319197 Equipment Rental 2,081.46 1,000.00 1,081.46 2,303.83 1,500.00 803.83 3,400.00 1,096.17 32.2% 6319206 Licenses & Permits 135.00 250.00 (115.00) 2,366.46 350.00 2,016.46 4,300.00 1,933.54 45.0% 6319490 Miscellaneous 218.80 100.00 118.80 763.51 400.00 363.51 1,200.00 436.49 36.4% 6319718 Safety Equipment & Training 104.36 800.00 (695.64) 771.10 1,850.00 (1,078.90) 3,850.00 3,078.90 80.0% 6319822 Uniforms 1,030.44 1,210.00 (179.56) 4,770.91 4,840.00 (69.09) 14,520.00 9,749.09 67.1% Total -CM -OTHER EXPENSES 4,072.06 4,334.00 (261.94) 20,435.49 14,336.00 6,099.49 47,858.00 27,422.51 57.30% 4 SilverRock Resort Course Maintenance Expense Statement October 2024 4 Month to Date Year to Date Annual Budget October 2024 Variance Final Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 26,223.86 22,000.00 4,223.86 109,079.99 88,000.00 21,079.99 264,000.00 154,920.01 58.7% 58.7% 58.9% 6321880 Contract Labor Total Contract Service 26,223.86 22,000.00 4,223.86 109,079.99 88,000.00 21,079.99 264,000.00 154,920.01 Total -COURSE MAINTENANCE 342,422.27 376,878.00 (34,455.73) 852,324.88 826,386.00 25,938.88 2,075,926.00 1,223,601.12 Silverrock Resort Course Maintenance Water & Energy October 2024 Month to Date Year to Date Annual Budget October Variance Final Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 18,177.99 10,109.97 18,500.00 (322.01) 9,680.00 429.97 76,738.65 47,656.21 74,000.00 34,820.00 2,738.65 12,836.21 236,340.00 97,244.00 159,601.35 49,587.79 67.5% 51.0% 62.7% 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total--CM-WATER & ENERGY 28,287.96 28,180.00 107.96 124,394.86 108,820.00 15,574.86 333,584.00 209,189.14 4 SilverRock Resort Outside Services Expense Statement October 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 October 2024 Final Budget Variance 535.47 999.63 364.85 4,461.10 174.57 1,026.00 688.00 1,085.00 8,712.00 (490.53) 311.63 (720.15) (4,250.90) 174.57 6,535.62 11,511.00 (4,975.38) 147.73 7,488.00 7,635.73 2,012.00 2,012.00 413.60 3,018.79 3,432.39 500.00 150.00 50.00 120.00 2,500.00 (500.00) (2.27) (50.00) (120.00) 4,988.00 3,320.00 4,315.73 300.00 3,603.00 (300.00) (1,591.00) 3,903.00 (1,891.00) 800.00 75.00 600.00 2,000.00 3,475.00 19,615.74 22,209.00 789.62 111.18 1,394.56 2,295.36 2,035.15 2,035.15 4,330.51 23,946.25 100.00 50.00 50.00 800.00 (800.00) (75.00) (186.40) 1,018.79 (42.61) (42.61) 789.62 111.18 1,394.56 2,295.36 (100.00) (50.00) (50.00) 1,235.15 1,000.00 1,035.15 1,000.00 3,330.51 23,209.00 737.25 Year to Date Final Budget Variance 3,159.90 4,149.09 4,858.29 54,109.44 772.70 67,049.42 590.92 1,440.00 14,960.00 4,104.00 3,998.00 6,300.00 50,614.00 (944.10) 151.09 (1,441.71) 3,495.44 772.70 65,016.00 2,033.42 500.00 1,500.00 125.00 480.00 10,000.00 16,990.92 12,605.00 1,318.83 19,617.50 1,200.00 14,412.00 20,936.33 15,612.00 2,832.91 413.60 3,066.24 6,312.75 111,289.42 2,611.12 5,385.35 17,000.17 24,996.64 5,055.09 2,429.50 3,200.00 300.00 2,400.00 2,000.00 (500.00) (909.08) (125.00) 960.00 4,960.00 4,385.92 118.83 5,205.50 5,324.33 (367.09) (300.00) (1,986.40) 1,066.24 7,900.00 (1,587.25) 101,133.00 10,156.42 807.00 996.00 10,217.00 1,804.12 4,389.35 6,783.17 12,020.00 12,976.64 300.00 50.00 200.00 1,025.00 7,484.59 1,575.00 32,481.23 143,770.65 4,755.09 (50.00) (200.00) 1,404.50 5,909.59 13,595.00 18,886.23 114,728.00 29,042.65 Annual Budget Annual Budget Unemcumb. % Budget 16,416.00 22,483.00 35,424.00 284, 534.00 13,256.10 18,333.91 30,565.71 230,424.56 (772.70) 358,857.00 291,807.58 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 6,159.08 15,000.00 525.00 420.00 742.00 15, 040.00 37,886.08 80.8% 81.5% 86.3% 81.0% 0.0% 81.3% 0.0% 91.2% 0.0% 100.0% 100.0% 100.0% 34.0% 50.1% 66.8% 2,281.17 63.4% (1,581.50) -8.8% 699.67 3.2% 6,767.09 450.00 6,786.40 2,133.76 16,137.25 70.5% 100.0% 94.3% 41.0% 71.9% 459,670.00 346,530.58 75.4% 9,088.00 11,214.00 115,017.00 6,476.88 5,828.65 98,016.83 135,319.00 110,322.36 1,050.00 200.00 600.00 2,125.00 3,975.00 (4,005.09) 200.00 600.00 (304.50) (3,509.59) 139,294.00 106,812.77 598,964.00 456,852.94 71.3% 52.0% 85.2% 0.0% 81.5% -381.4% 100.0% 100.0% -14.3% -88.3% 76.7% 76.3% 5 6 SilverRock Resort Clubhouse Expense Statement October 2024 Month to Date Year to Date Annual Budget October 2024 Final Budget Variance Budget Variance Variance Annual Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MA TERIALS 6503742 Supplies -Expendable 520.00 520.00 - 1,760.00 2,080.00 (320.00) 2,400.00 640.00 26.7% Total -CH -SUPPLIES & MATERIALS 520.00 520.00 - 1,760.00 2,080.00 (320.00) 2,400.00 640.00 26.7% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 1,143.79 1,000.00 143.79 3,356.01 4,000.00 (643.99) 12,000.00 8,643.99 72.0% 6507840 Utilities -Telephone 1,394.71 1,750.00 (355.29) 5,541.38 7,000.00 (1,458.62) 21,000.00 15,458.62 73.6% 6507842 Utilities -Water 738.79 608.00 130.79 2,645.43 2,432.00 213.43 7,296.00 4,650.57 63.7% 6507844 Utilities -Cable 426.32 420.00 6.32 1,704.03 1,680.00 24.03 5,040.00 3,335.97 66.2% Total -CH -UTILITIES 3,703.61 3,778.00 (74.39) 13,246.85 15,112.00 (1,865.15) 45,336.00 32,089.15 70.8% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 80.00 2,500.00 (2,420.00) 1,520.00 4,000.00 (2,480.00) 8,000.00 6,480.00 81.0% 6509099 Contract Services -Security 7,046.64 7,100.00 (53.36) 28,609.48 28,400.00 209.48 85,200.00 56,590.52 66.4% 6509215 Flowers & Decorations - 500.00 (500.00) - 500.00 (500.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous -- - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0% Total--CH-OTHER EXPENSES 7,126.64 10,200.00 (3,073.36) 30,129.48 33,300.00 (3,170.52) 96,300.00 66,170.52 68.7% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 1,144.95 300.00 844.95 3,104.32 1,200.00 1,904.32 3,600.00 495.68 13.8% 6515686 CH -R&M -Restaurant Repairs 1,131.97 700.00 431.97 1,831.97 2,800.00 (968.03) 8,400.00 6,568.03 78.2% 6515690 CH -R&M -Equipment Repair 1,209.48 700.00 509.48 3,306.06 2,800.00 506.06 8,400.00 5,093.94 60.6% Total -CH -REPAIRS & MAINTENANCE 3,486.40 1,700.00 1,786.40 8,242.35 6,800.00 1,442.35 20,400.00 12,157.65 59.6% Total CLUBHOUSE 14,836.65 16,198.00 (1,361.35) 53,378.68 57,292.00 13,913.32) 164,436.00 24,315.30 14.8% 6 7 SilverRock Resort Marketing Expense Statement October 2024 Month to Date Year to Date Annual Budget October 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 105.01 99.00 6.01 410.32 396.00 14.32 $ 1,185.00 774.68 65.4% 6601720 Salaries 1,250.00 1,250.00 - 7,750.00 5,000.00 2,750.00 $ 15,000.00 7,250.00 48.3% 6601800 Tax -Employer Payroll 122.00 122.00 - 854.00 488.00 366.00 $ 1,462.00 608.00 41.6% Total -MKT -SALARIES & BENEFITS 1,477.01 1,471.00 6.01 9,429.55 5,884.00 3,545.55 21,238.00 11,808.45 55.6% 66 -MKT -SUPPLIES & MATERIALS 6603762 Supplies -Office 542.18 100.00 442.18 542.18 400.00 142.18 1,200.00 657.82 54.8% 6603768 Supplies -Printing & Stationery 635.12 3,000.00 (2,364.88) 2,681.90 3,200.00 (518.10) 4,425.00 1,743.10 39.4% Total -MKT -SUPPLIES & MARKETING 1,177.30 3,100.00 (1,922.70) 3,224.08 3,600.00 (375.92) 5,625.00 2,400.92 42.7% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 90.12 100.00 (9.88) 687.97 400.00 287.97 1,200.00 512.03 42.7% Total -MKT -UTILITIES 90.12 100.00 (9.88) 687.97 400.00 287.97 1,200.00 512.03 42.7% 66 -MKT -OTHER EXPENSES 6609010 Advertising 11,611.99 10,266.00 1,345.99 28,083.94 18,859.00 9,224.94 113,787.00 85,703.06 75.3% 6609040 Business Meals - 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0% 6609080 Collateral Material - 1,500.00 (1,500.00) 3,824.31 3,000.00 824.31 21,000.00 17,175.69 81.8% 6609102 Contract Services -Web Page - 150.00 (150.00) - 600.00 (600.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions - - - 198.00 - 198.00 735.00 537.00 73.1% 6609620 Postage - - - 16.62 - 16.62 600.00 583.38 97.2% 6609490 Miscellaneous - 50.00 (50.00) - 200.00 (200.00) 400.00 400.00 100.0% 6609630 Promotion - - - - - - 1,000.00 1,000.00 100.0% 6609633 Promotion-Cummunity - 75.00 (75.00) - 300.00 (300.00) 2,250.00 2,250.00 100.0% 6609634 Promotion-MediaNendor - 50.00 (50.00) - 50.00 (50.00) 700.00 700.00 100.0% 6609820 Uniforms - 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0% Total -MKT -OTHER EXPENSES 11,611.99 12,416.00 (804.01) 32,122.87 23,409.00 8,713.87 143,172.00 111,049.13 77.6% TOTAL MARKETING 14,356.42 17,087.00 (2,730.58) 45,464.47 33,293.00 12,171.47' 171,235.00 125,770.53 73.4% 7 SilverRock Resort General and Administrative Expense Statement October 2024 Month to Date Year to Date Annual Budget October 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 5,132.94 5,148.00 (15.06) 420.01 2,052.00 (1,631.99) 17,726.06 20,170.00 (2,443.94) 1,834.63 2,532.00 (697.37) 5,113.44 5,797.00 (683.56) - - - 20,204.62 20,592.00 (387.38) 4,933.28 8,208.00 (3,274.72) 77,642.27 80,680.00 (3,037.73) 11,763.53 10,128.00 1,635.53 26,258.92 23,188.00 3,070.92 - - - $ 61,776.00 41,571.38 67.3% $ 24,621.00 19,687.72 80.0% $ 242,040.00 164,397.73 67.9% $ 30,381.00 18,617.47 61.3% $ 69,564.00 43,305.08 62.3% $ - - 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 140,802.62 142,796.00 (1,993.38) 428,382.00 287,579.38 67.1% 30,227.08 35,699.00 (5,471.92) 67 -G&A -SUPPLIES & MATER/ALS 675.98 2,000.00 (1,324.02) 94.10 420.00 (325.90) 454.16 400.00 54.16 6,300.00 5,624.02 89.3% 1,260.00 1,165.90 92.5% 3,300.00 2,845.84 86.2% 69.97 500.00 (430.03) 7.14 105.00 (97.86) 147.94 100.00 47.94 6703740 Supplies -Computer 6703762 Supplies -Office 6703768 Supplies -Printing & Stationery Total -G&A -SUPPLIES & MATER/ALS 1,224.24 2,820.00 (1,595.76) 225.05 705.00 (479.95) 10,860.00 9,635.76 88.7% 67 -G&A -REPAIRS & MAINTENANCE 40.77 2,800.00 (2,759.23) 7,300.00 7,259.23 99.4% 40.77 1,500.00 (1,459.23) 6705690 Repairs & Maintenance -Equipment Total -G&A -REPAIRS & MAINTENANCE 40.77 2,800.00 (2,759.23) 7,300.00 7,259.23 99.4% 40.77 1,500.00 (1,459.23) 67 -G&A -OTHER EXPENSES 500.00 500.00 - - 50.00 (50.00) - 150.00 (150.00) 2,126.53 1,100.00 1,026.53 46.63 90.00 (43.37) 417.67 1,500.00 (1,082.33) - 50.00 (50.00) 162.00 100.00 62.00 201.00 75.00 126.00 1,044.00 1,500.00 (456.00) - 100.00 (100.00) - 200.00 (200.00) - - - - 350.00 (350.00) 2,000.00 2,000.00 - 1,283.47 400.00 883.47 35.00 300.00 (265.00) 4,201.73 4,400.00 (198.27) 272.62 360.00 (87.38) 2,628.80 6,000.00 (3,371.20) 26.45 200.00 (173.55) 1,411.70 400.00 1,011.70 500.15 300.00 200.15 7,722.63 6,000.00 1,722.63 1,000.00 400.00 600.00 250.00 800.00 (550.00) - 100.00 (100.00) 332.40 800.00 (467.60) 6,000.00 4,000.00 66.7% 1,550.00 266.53 17.2% 1,200.00 1,165.00 97.1% 13,200.00 8,998.27 68.2% 1,080.00 807.38 74.8% 18,000.00 15,371.20 85.4% 600.00 573.55 95.6% 6,000.00 4,588.30 76.5% 900.00 399.85 44.4% 18,000.00 10,277.37 57.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,667.60 83.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 21,664.95 22,460.00 (795.05) 4,497.83 5,765.00 (1,267.17) 74,230.00 52,565.05 70.8% Total -GENERAL & ADMINISTRATIVE 34,990.73 43,669.00 (8,678.27) 163,732.58 170,876.00 (7,143.42) 520,772.00 357,039.42 68.6% 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement October 2024 Month to Date Year to Date Annual Budget October 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 6800193 6800195 6800196 6800197 69-MISC Expense 19,412.38 - 5,130.83 821.59 18,150.00 5,200.00 5,072.00 1,150.00 1,262.38 (5,200.00) 58.83 (328.41) 77,610.20 - 20,755.82 3,325.68 72,600.00 20,800.00 20,288.00 4,600.00 5,010.20 (20,800.00) 467.82 (1,274.32) 252,600.00 - 60,864.00 20,200.00 174,989.80 - 40,108.18 16,874.32 69.3% - 65.9% 83.5% 69.5% 66.7% 93.8% 64.4% 63.6% 74.2% 68 -LEASES Equipment Leases -Maintenance Trailer Lease Equipment Leases -GPS Equipment Leases -Others Total -LEASES 25,364.80 29,572.00 (4,207.20) 101,691.70 118,288.00 (16,596.30) 333,664.00 231,972.30 OTHER EXPENSES 11,437.00 - 2,277.67 - 11,437.00 - 4,600.00 4,000.00 - - (2,322.33) (4,000.00) 45,748.00 5,424.08 19,663.82 5,455.14 45,746.00 7,507.00 18,400.00 15,000.00 2.00 (2,082.92) 1,263.82 (9,544.86) 137,232.00 88,136.00 55,200.00 15,000.00 91,484.00 82,711.92 35,536.18 9,544.86 6900096 Contract Srvcs-Management Fee 6900210 FF&E Reserve 6900323 Insurance -Commercial 6900800 Personal Property Taxes Total--M/5C OTHER EXPENSES 13,714.67 20,037.00 (6,322.33) 76,291.04 86,653.00 (10,361.96) 295,568.00 219,276.96 9