Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02 August 2024 SilverRock Resort - Monthly Financial Statement
S1LVERROCK® RESORT Monthly Financial Statements August 01, 2024 - August 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 & Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement August 2024 Month to Date G/L # Series 400000 401000 410000 420000 510000 520000 610000 630000 633000 640000 650000 660000 670000 680000 690000 620000 Account Description Income Golf Green Fee Revenue Miscellaneous Golf Revenue Revenue -Golf Shop Food & Beverage Revenue Total Income Cost of Goods Sold COS -Golf Shop COS -Food & Beverage Total COS Gross Profit August 2024 Final Budget Variance Percentage Difference 75,146.00 4,339.00 4,135.29 20,628.96 93,240.00 3,550.00 5,365.00 18,870.00 (18,094.00) 789.00 (1,229.71) 1,758.96 104,249.25 121,025.00 (16,775.75) 3,766.84 $ 9,379.12 $ 13,145.96 3,000.00 5,540.00 8,540.00 766.84 3,839.12 4,605.96 91,103.29 112,485.00 (21,381.71) Expenses Golf Pro Shop Course Maintenance Maintenance Water & Energy Outside Services Clubhouse Marketing General & Administrative Leases Miscellaneous Other Expense Food & Beverage Expenses Total Expenses Net Income 18,991.59 176,394.30 32,540.16 38,098.62 11,545.43 10,266.26 46,335.47 26,470.34 20,394.03 40,736.85 421,773.05 14,460.00 4,531.59 136,731.00 39,663.30 26,130.00 6,410.16 29,949.00 8,149.62 13,698.00 (2,152.57) 5,037.00 5,229.26 42,019.00 4,316.47 29,572.00 (3,101.66) 17,901.00 2,493.03 35,213.00 5,523.85 350,710.00 71,063.05 (330,669.76) (238,225.00) (92,444.76) -19.4% 22.2% -22.9% 9.3% -13.86% - 25.6% - 69.3% -53.9% - 19.0% -31.3% -29.0% -24.5% -27.2% 15.7% -103.8% - 10.3% 10.5% - 13.9% - 15.7% -20.3% -53.1% 400000 Rounds of Golf Played Paid Rounds Played Ave $ Per Paid Round Green Fee Ave $ Per Paid Round Merchandise Ave $ Per Paid Miscellaneous 1,461 1,850 (389) 51.43 50.40 1.03 3.35 2.90 0.45 2.97 1.92 1.05 -21.0% 2.1% 15.6% 54.8% Year to Date Final Budget Variance 145,341.91 9,985.11 9,380.64 37,540.26 202,247.92 189,000.00 7,700.00 10,874.00 37,870.00 (43,658.09) 2,285.11 (1,493.36) (329.74) 245,444.00 (43,196.08) 6,495.06 17,227.57 23,722.63 6,081.00 10,995.00 (414.06) (6,232.57) 17,076.00 (6,646.63) 178,525.29 228,368.00 (49,842.71) 39,785.86 334,014.61 65,533.22 72,739.75 24,245.37 16,773.06 86,056.24 50,962.10 42,822.73 71,131.05 804,063.99 (625,538.70) 28,921.00 292,377.00 53,260.00 59,898.00 27,396.00 10,074.00 83,988.00 59,144.00 41,852.00 71,476.00 10,864.86 41,637.61 12,273.22 12,841.75 (3,150.63) 6,699.06 2,068.24 (8,181.90) 970.73 (344.95) 728,386.00 (75,677.99) (500,018.00) (125,520.70) 2,695 3,750 (1,055) 53.93 50.40 3.53 3.48 2.90 0.58 3.71 2.05 1.65 Annual Budget Annual Budget 4,406,783.00 179,960.00 247,518.00 774,989.00 5,609,250.00 138,526.00 221,939.00 360,465.00 5,248,785.00 $ 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 5,476,083.00 (227,298.00) Unemcumb. 4,261,441.09 169,974.89 238,137.36 737,448.74 5,407,002.08 132,030.94 204,711.43 336,742.37 5,070,259.71 241,449.14 1,742,000.39 268,050.78 526,225.25 144,030.63 154,052.94 434,720.76 370,301.90 252,745.27 538,441.95 4,133,577.06 936,682.65 44,545 98.93 5.56 4.04 41,850 45.00 2.08 0.33 Bdgt 3% 6% 4% 5% 4% 5% 8% 7% 3% 14% 16% 20% 12% 14% 10% 17% 12% 14% 14% 15% 6% 55% 63% 92% 1 SilverRock Resort Statement of Fees - Revenue August 2024 1 Month to Date Year to Date Annual Budget Income August 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 75,146.00 93,240.00 (18,094.00) 595.00 1,100.00 (505.00) 1,225.00 750.00 475.00 2,253.00 1,500.00 753.00 266.00 200.00 66.00 - - - - - - 4,339.00 3,550.00 789.00 145,341.91 189,000.00 (43,658.09) 1,265.00 2,100.00 (835.00) 2,677.11 1,550.00 1,127.11 4,799.00 3,100.00 1,699.00 494.00 450.00 44.00 750.00 - 750.00 - 500.00 (500.00) 9,985.11 7,700.00 2,285.11 4,406,783.00 4,261,441.09 96.7% 22,190.00 20,925.00 94.3% 42,175.00 39,497.89 93.7% 102,000.00 97,201.00 95.3% 4,595.00 4,101.00 89.2% 6,500.00 5,750.00 88.5% 2,500.00 2,500.00 100.0% 179,960.00 169,974.89 94.5% 79,485.00 96,790.00 (17,305.00) 155,327.02 196,700.00 (41,372.98) 4,586,743.00 4,431,415.98 96.6% Total Revenue Fees Total Income 1 79,485.00 96,790.00 (17,305.00)1 155,327.02 196,700.00 (41,372.98)1 4,586,743.00 4,431,415.981 96.6% I 2 3 SilverRock Golf Shop August Resort Income Statement 2024 Month to Date Year to Date Annual Budget August 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous (2,660.46) - (2,660.46) (2,521.76) - (2,521.76) 0 0 0% 4100110 Sales Hard Goods 4,275.90 1,341.00 2,934.90 6,974.40 2,718.00 4,256.40 61,406.00 54,431.60 88.6% 4100112 Sales -Soft Goods 2,519.85 4,024.00 (1,504.15) 4,928.00 8,156.00 (3,228.00) 185,638 180,710.13 97.3% 5100639 GS -Discounts -Mdse - - - - - - - - 0.0% Total Revenue Golf Shop 4,135.29 5,365.00 (1,229.71) 9,380.64 10,874.00 (1,493.36) 247,044.13 235,141.73 95.2% COS 5100150 COS -GS -Hard Goods 1,867.49 777.00 1,090.49 3,150.50 1,575.00 1,575.50 35,890.00 32,739.50 91.2% 5100151 COS -GS -Soft Goods 1,618.12 2,333.00 (714.88) 2,998.36 4,729.00 (1,730.64) 107,670.00 104,671.64 97.2% 5100152 COS -GS -Purchase Disc (11.52) (156.00) 144.48 (31.34) (316.00) 284.66 (7,178.00) (7,146.66) 0.0% 5100220 COS -GS -Freight Merch 292.75 46.00 246.75 377.54 93.00 284.54 2,153.00 1,775.46 82.5% Cost of Sales - Golf Shop 3,766.84 3,000.00 766.84 6,495.06 6,081.00 414.06 138,535.00 132,039.94 95,3% Gross Profit 368.45 2,365.00 (1,996.55) 2,885.58 4,793.00 (1,907.42) 108,509.13 103,101.79 95.0% COS % 91.1% 55.9% -35.2% 69.2% 55.9% -13.3% 53.1% 56.2% 105.8% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 818.94 1,539.00 (720.06) 1,258.07 3,078.00 (1,819.93) 18,468.00 17,209.93 93.2% 6101325 Insurance -Workers Comp 793.06 793.00 0.06 1,583.06 1,586.00 (2.94) 16,380.00 14,796.94 90.3% 6101720 Salaries 7,576.00 6,575.00 1,001.00 13,960.00 13,150.00 810.00 78,900.00 64,940.00 82.3% 6101800 Taxes -Employer Payroll 1,270.58 979.00 291.58 3,865.31 1,958.00 1,907.31 20,212.00 16,346.69 80.9% 6101880 Wages -Hourly 8,167.52 3,464.00 4,703.52 18,357.66 6,929.00 11,428.66 128,400.00 110,042.34 85.7% 6101882 Wages -Overtime - - - 6.60 - 6.60 - (6.60) 0.0% Total -PS-SALARIES & BENEFITS 18,626.10 13,350.00 5,276.10 39,030.70 26,701.00 12,329.70 262,360.00 223,329.30 85.1% 61 -PS OTHER EXPENSES 6103762 Supplies -Office 128.11 250.00 (121.89) 128.11 500.00 (371.89) 3000.00 2,871.89 95.7% 6109150 Dues and Subscriptions - - - - - - 2300.00 2,300.00 100.0% 6109220 Freight & Delivery - - - - - - 75.00 75.00 100.0% 6109490 Miscellaneous - 500.00 (500.00) 27.80 1,000.00 (972.20) 6,000.00 5,972.20 99.5% 6109500 ProShop Over/Under 23.98 - 23.98 18.48 18.48 - (18.48) 0.0% 6109722 Seminars/Training - 150.00 (150.00) - 300.00 (300.00) 3,690.00 3,690.00 100.0% 6109810 Travel - Merchandise - - - - - - 90.00 90.00 100.0% 6109820 Uniforms 49.48 100.00 (50.52) 306.85 200.00 106.85 2,400.00 2,093.15 87.2% 6117840 Telephones 163.92 110.00 53.92 273.92 220.00 53.92 1,320.00 1,046.08 79.2% Total - Other Expenses 365.49 1,110.00 (744.51) 755.16 2,220.00 (1,464.84) 18,875.00 18,119.84 96.0% Total Expenses -Golf Shop 18,991.59 14,460.00 4,531.59 39,785.86 28,921.00 10,864.86 281,235.00 241,449.14 85.9% Net Income (18,623.14) (12,095.00) (6,528.14) 136,900.28) (24,128.00) (12,772.28) (172,725.88) 1138,347.36) 80.1% 3 SilverRock Resort Course Maintenance Expense Statement August 2024 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 6311325 6311720 6311800 6311880 6311882 Insurance -Group Insurance -Workers Comp Salaries Taxes -Employer Payroll Wages -Hourly Wages -Overtime Total -CM -SALARIES & BENEFITS 63 -CM -SUPPLIES & MATERIALS 6313745 6313744 6313746 6313748 6313750 6313756 6313758 6313776 6313778 6313780 6313782 6313784 Chemicals Fertilizer Flowers/Plants Fuel -Gasoline Golf Course Accessories POA Control Miscellaneous Supp Sand Seed Small Tools & Non -Capital Equip Sod Topdressing Total -CM -SUPPLIES & MA TERIALS 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 6315685 CM-R&M-Bldngs & Othr Structures CM -R&M -Equipment CM -R&M -Irrigation System 6315690 6315692 6315696 CM -R&M -Pumps 6315815 CM -R&M -Trees -Pruning Etc Total -CM-Repair & Maintenance 6317836 6317840 6319020 6319100 6319102 Contract Svcs -Trash Removal 6319150 Utilities -Natural Gas/LPG Telephones Total -CM -UTILITIES 63 -CM -OTHER EXPENSES Auto Mileage/Allowance Contract Svcs-Soil/Tissue Test 6319170 6319197 6319206 6319490 6319718 6319822 Dues & Subscriptions Employee Education Equipment Rental Licenses & Permits Miscellaneous Safety Equipment & Training Uniforms Total -CM -OTHER EXPENSES 8,971.97 2,786.69 19,228.00 8,074.30 56,810.53 2,473.32 98,344.81 4,446.69 12,205.52 3,510.31 867.45 5,338.05 2,466.67 28,834.69 4,346.00 379.50 5,982.68 3,131.26 8,106.00 3,042.00 17,210.00 6,290.00 45,474.00 1,824.00 865.97 (255.31) 2,018.00 1,784.30 11,336.53 649.32 81,946.00 16,398.81 1,000.00 4,000.00 6,800.00 750.00 600.00 2,500.00 3,446.69 8,205.52 (3,289.69) 117.45 5,338.05 (600.00) (33.33) 15,650.00 13,184.69 4,346.00 500.00 3,500.00 4,750.00 1,000.00 13,839.44 14,096.00 25.61 695.34 720.95 400.00 1,300.00 3,400.00 1,510.44 6,610.44 30.00 475.00 505.00 400.00 524.00 50.00 150.00 100.00 100.00 1,210.00 2,534.00 (120.50) 2,482.68 (1,618.74) (1,000.00) (256.56) (4.39) 220.34 215.95 (524.00) 1,300.00 3,350.00 (150.00) (100.00) (100.00) 300.44 4,076.44 18,783.15 5,826.69 35, 380.00 14,698.68 103,165.53 10, 347.59 188,201.64 4,446.69 18,352.31 8,678.02 8,542.53 1,115.22 5,338.05 1,710.87 4,451.36 1,332.04 53,967.09 8,692.00 509.00 11,113.16 5,947.39 1,522.50 27,784.05 52.15 1,484.20 1,536.35 800.00 1,785.97 3,400.00 1,115.00 164.22 2,756.04 10,021.23 16,212.00 5,952.00 34,420.00 12,251.00 89,398.00 1,824.00 2,571.15 (125.31) 960.00 2,447.68 13, 767.53 8,523.59 160,057.00 28,144.64 15,000.00 10,000.00 13,600.00 1,500.00 1,200.00 10,000.00 3,000.00 54,300.00 8,692.00 1,000.00 6,500.00 9,500.00 2,000.00 27,692.00 60.00 950.00 1,010.00 800.00 1,048.00 100.00 350.00 100.00 200.00 300.00 2,420.00 5,318.00 (10,553.31) 8,352.31 (4,921.98) 8,542.53 (384.78) 5,338.05 510.87 (5,548.64) (1,667.96) (332.91) (491.00) 4,613.16 (3,552.61) (477.50) 92.05 (7.85) 534.20 526.35 (1,048.00) 1,785.97 3,300.00 (350.00) 1,015.00 (35.78) (300.00) 336.04 4,703.23 100,863.00 41,298.00 206,520.00 85,580.00 640, 702.00 30, 518.00 82, 079.85 35,471.31 171,140.00 70,881.32 537, 536.47 20,170.41 1,105,481.00 917,279.36 47,000.00 114,000.00 13,000.00 81,600.00 16,000.00 10,000.00 5,950.00 8,500.00 150,000.00 7,025.00 15,500.00 19,000.00 42,553.31 95, 647.69 13,000.00 72,921.98 16,000.00 1,457.47 4,834.78 3,161.95 150,000.00 5,314.13 11, 048.64 17, 667.96 487,575.00 433,607.91 52,152.00 6,000.00 46,500.00 33,250.00 10,500.00 16,550.00 81.4% 85.9% 82.9% 82.8% 83.9% 66.1% 83.0% 90.5% 83.9% 100.0% 89.4% 100.0% 14.6% 81.3% 37.2% 100.0% 75.6% 71.3% 93.0% 88.9% 43,460.00 83.3% 5,491.00 91.5% 35,386.84 76.1% 27, 302.61 82.1% 8,977.50 85.5% 16,550.00 100.0% 164, 952.00 137,167.95 360.00 5,700.00 6,060.00 4,800.00 4,500.00 6,288.00 1,100.00 3,900.00 3,400.00 4,300.00 1,200.00 3,850.00 14, 520.00 83.2% 307.85 0.0% 4,215.80 74.0% 4,523.65 74.6% 4,000.00 4,500.00 6,288.00 (685.97) 500.00 3,400.00 3,185.00 1,035.78 83.3% 100.0% 100.0% -62.4% 12.8% 100.0% 74.1% 86.3% 3,850.00 100.0% 11,763.96 81.0% 47,858.00 37,836.77 79.06% 4 SilverRock Resort Course Maintenance Expense Statement August 2024 4 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 52,504.25 44,000.00 8,504.25 264,000.00 211,495.75 80.1% 6321880 Contract Labor 28,043.97 22,000.00 6,043.97 Total Contract Service 28,043.97 22,000.00 6,043.97 52,504.25 44,000.00 8,504.25 264,000.00 211,495.75 80.1% Total -COURSE MAINTENANCE 176,394.30 136,731.00 39,663.30 334,014.61 292,377.00 41,637.61 2,075,926.00 1,741,911.39 83.9% Silverrock Resort Course Maintenance Water & Energy August 2024 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 19,503.07 18,500.00 1,003.07 13 037.09 7 630.00 5 407.09 40,957.32 37,000.00 3,957.32 24 575.90 16 260.00 8 315.90 236,340.00 195,382.68 82.7% 97 244.00 72 668.10 74.7% 6337834 Utilities -Electricity -Pumping Utilities -Water 6337842 Total -CM -WATER & ENERGY 32,540.16 26,130.00 6,410.16 65,533.22 53,260.00 12,273.22 333,584.00 268,050.78 80.4% 4 5 SilverRock Resort Outside Services Expense Statement August 2024 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance-Group 1,126.86 1,026.00 100.86 2,033.51 2,052.00 (18.49) $ 16,416.00 14,382.49 87.6% 6411325 Insurance-Workers Comp 1,069.27 1,069.00 0.27 2,129.27 2,138.00 (8.73) $ 22,483.00 20,353.73 90.5% 6411800 Taxes-Employer Payroll 1,884.60 1,684.00 200.60 3,196.59 3,368.00 (171.41) $ 35,424.00 32,227.41 91.0% 6411880 Wages-Hourly 16,404.01 13,532.00 2,872.01 30,437.49 27,064.00 3,373.49 $ 284,534.00 254,096.51 89.3% 6411882 Wages-Overtime 118.80 - 118.80 414.81 - 414.81 $ - (414.81) 0.0% Total-CBR-SALARIES & BENEFITS 20,603.54 17,311.00 3,292.54 38,211.67 34,622.00 3,589.67 358,857.00 320,645.33 89.4% 641-CBR-SUPPLIES & MATER/ALS 6413732 Supplies-Carts - - - - - - 1,850.00 0.0% 6413742 Supplies-Expendable 147.73 600.00 (452.27) 295.46 1,200.00 (904.54) 6,750.00 6,454.54 95.6% 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) - 50.00 (50.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 840.00 240.00 600.00 2,182.00 1,342.00 61.5% 6413796 Supplies-Bottled Water - 2,500.00 (2,500.00) 7,472.00 5,000.00 2,472.00 30,000.00 22,528.00 75.1% Total-CBR-SUPPLIES & MATER/ALS 747.73 3,245.00 (2,497.27) 8,607.46 6,490.00 2,117.46 56,727.00 46,269.54 81.6% 641-CBR-REPAIRS & MAINTENANCE 6415690 CBR-R&M-Equipment 860.28 300.00 560.28 860.28 600.00 260.28 3,600.00 2,739.72 76.1% 6415695 CBR-R&M-Cart Maintenance & Repair 7,796.75 3,603.00 4,193.75 9,808.75 7,206.00 2,602.75 18,036.00 8,227.25 45.6% Total-CBR-REPAIRS & MAINTENANCE 8,657.03 3,903.00 4,754.03 10,669.03 7,806.00 2,863.03 21,636.00 10,966.97 50.7% 641-CBR-OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 1,047.40 800.00 247.40 1,795.84 1,600.00 195.84 9,600.00 7,804.16 81.3% 6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) - 1,200.00 (1,200.00) 7,200.00 7,200.00 100.0% 6419820 Uniforms 32.34 - 32.34 47.45 - 47.45 5,200.00 5,152.55 99.1% Total-CBR-OTHER EXPENSES 1,079.74 1,475.00 (395.26) 1,843.29 2,950.00 (1,106.71) 22,450.00 20,606.71 91.8% TOTAL-CARTS,BAGROOM & RANGE 31,088.04 25,934.00 (395.26) 59,331.45 51,868.00 7,463.45 459,670.00 398,488.55 86.7% 643-CS-SALARIES & BENEFITS 6431325 Insurance-Workers Comp 713.05 258.00 455.05 963.05 516.00 447.05 $ 9,088.00 8,124.95 89.4% 6431800 Taxes-Employer Payroll 1,067.76 318.00 749.76 2,865.61 636.00 2,229.61 $ 11,214.00 8,348.39 74.4% 6431880 Wages-Hourly 4,860.17 3,264.00 1,596.17 9,185.29 6,528.00 2,657.29 $ 115,017.00 105,831.71 92.0% 6431882 Wages-Overtime - - - - - - $ - - 0.0% Total-CS-SALARIES & BENEFITS 6,640.98 3,840.00 2,800.98 13,013.95 7,680.00 5,333.95 135,319.00 122,305.05 90.4% 643-CS-OTHER EXPENSES 6433742 Supplies Expendable - 50.00 (50.00) - 100.00 (100.00) 1,050.00 1,050.00 100.0% 6439490 Miscellaneous - - - - - - 200.00 200.00 100.0% 6439718 Safety Equipment & Training - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0% 6439820 Uniforms 369.60 75.00 294.60 394.35 150.00 244.35 2,125.00 1,730.65 81.4% Total-CS-OTHER EXPENSES 369.60 175.00 194.60 394.35 350.00 44.35 3,975.00 3,580.65 90.1% Total-COURSE SERVICES 7,010.58 4,015.00 2,995.58 13,408.30 8,030.00 5,378.30 139,294.00 125,885.70 90.4% TOTAL OUTSIDE SERVICES 38,098.62 29,949.00 8,149.62 72,739.75 59,898.00 12,841.75 598,964.00 520,793.60 86.9% 5 6 SilverRock Resort Clubhouse Expense Statement August 2024 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Budget Variance Variance Annual Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MA TERIALS 6503742 Supplies -Expendable 520.00 520.00 - 720.00 1,040.00 (320.00) 2,400.00 1,680.00 70.0% Total -CH -SUPPLIES & MATERIALS 520.00 520.00 - 720.00 1,040.00 (320.00) 2,400.00 1,680.00 70.0% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 276.62 1,000.00 (723.38) 1,225.90 2,000.00 (774.10) 12,000.00 10,774.10 89.8% 6507840 Utilities -Telephone 1,395.62 1,750.00 (354.38) 2,752.05 3,500.00 (747.95) 21,000.00 18,247.95 86.9% 6507842 Utilities -Water 657.22 608.00 49.22 1,250.72 1,216.00 34.72 7,296.00 6,045.28 82.9% 6507844 Utilities -Cable 426.32 420.00 6.32 851.39 840.00 11.39 5,040.00 4,188.61 83.1% Total -CH -UTILITIES 2,755.78 3,778.00 (1,022.22) 6,080.06 7,556.00 (1,475.94) 45,336.00 39,255.94 86.6% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 480.00 500.00 (20.00) 960.00 1,000.00 (40.00) 8,000.00 7,040.00 88.0% 6509099 Contract Services -Security 6,771.84 7,100.00 (328.16) 13,640.24 14,200.00 (559.76) 85,200.00 71,559.76 84.0% 6509215 Flowers & Decorations -- - - - - 1,900.00 1,900.00 100.0% 6509490 Miscellaneous -- - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0% Total -CH -OTHER EXPENSES 7,251.84 7,700.00 (448.16) 14,600.24 15,400.00 (799.76) 96,300.00 81,699.76 84.8% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 1,017.81 300.00 717.81 1,488.59 600.00 888.59 3,600.00 2,111.41 58.7% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) - 1,400.00 (1,400.00) 8,400.00 8,400.00 100.0% 6515690 CH -R&M -Equipment Repair - 700.00 (700.00) 1,356.48 1,400.00 (43.52) 8,400.00 7,043.52 83.9% Total -CH -REPAIRS & MAINTENANCE 1,017.81 1,700.00 (682.19) 2,845.07 3,400.00 (554.93) 20,400.00 17,554.93 86.1% Total CLUBHOUSE 11,545.43 13,698.00 (2,152.57)1 24,245.37 27,396.00 (3,150.63) 164,436.00 35,109.86 21.4% 6 7 SilverRock Resort Marketing Expense Statement August 2024 Month to Date Year to Date Annual Budget August 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 99.00 99.00 - 198.00 198.00 - $ 1,185.00 987.00 83.3% 6601720 Salaries 2,750.00 1,250.00 1,500.00 5,250.00 2,500.00 2,750.00 $ 15,000.00 9,750.00 65.0% 6601800 Tax -Employer Payroll 366.00 122.00 244.00 610.00 244.00 366.00 $ 1,462.00 852.00 58.3% Total -MKT -SALARIES & BENEFITS 3,215.00 1,471.00 1,744.00 6,473.23 2,942.00 3,531.23 21,238.00 14,764.77 69.5% 66 -MKT -SUPPLIES & MATERIALS 6603762 Supplies -Office - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0% 6603768 Supplies -Printing & Stationery 1,856.28 - 1,856.28 1,989.86 - 1,989.86 4,425.00 2,435.14 55.0% Total -MKT -SUPPLIES & MARKETING 1,856.28 100.00 1,756.28 1,989.86 200.00 1,789.86 5,625.00 3,635.14 64.6% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 365.67 100.00 265.67 465.67 200.00 265.67 1,200.00 734.33 61.2% Total -MKT -UTILITIES 365.67 100.00 265.67 465.67 200.00 265.67 1,200.00 734.33 61.2% 66 -MKT -OTHER EXPENSES 6609010 Advertising 3,810.00 2,566.00 1,244.00 6,824.99 5,132.00 1,692.99 113,787.00 106,962.01 94.0% 6609040 Business Meals - 25.00 (25.00) - 50.00 (50.00) 300.00 300.00 100.0% 6609080 Collateral Material 1,019.31 500.00 519.31 1,019.31 1,000.00 19.31 21,000.00 19,980.69 95.1% 6609102 Contract Services -Web Page - 150.00 (150.00) - 300.00 (300.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions - - - - - - 735.00 735.00 100.0% 6609620 Postage - - - - - - 600.00 600.00 100.0% 6609490 Miscellaneous - 50.00 (50.00) - 100.00 (100.00) 400.00 400.00 100.0% 6609630 Promotion - - - - - - 1,000.00 1,000.00 100.0% 6609633 Promotion-Cummunity - 75.00 (75.00) - 150.00 (150.00) 2,250.00 2,250.00 100.0% 6609634 Promotion-Media/Vendor - - - - - - 700.00 700.00 100.0% 6609820 Uniforms - - - - - - 600.00 600.00 100.0% Total -MKT -OTHER EXPENSES 4,829.31 3,366.00 1,463.31 7,844.30 6,732.00 1,112.30 143,172.00 135,327.70 94.5% TOTAL MARKETING 10,266.26 5,037.00 5,229.26 16,773.06 10,074.00 6,699.06 ' 171,235.00 154,461.94 90.2% 7 SilverRock Resort General and Administrative Expense Statement August 2024 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 5,132.94 5,148.00 (15.06) 2,034.04 2,052.00 (17.96) 22,714.09 20,170.00 2,544.09 2,851.87 2,532.00 319.87 7,405.86 5,797.00 1,608.86 - - - 10,356.77 10,296.00 60.77 4,084.04 4,104.00 (19.96) 39,190.15 40,340.00 (1,149.85) 5,837.87 5,064.00 773.87 13,386.48 11,594.00 1,792.48 - - - $ 61,776.00 51,419.23 83.2% $ 24,621.00 20,536.96 83.4% $ 242,040.00 202,849.85 83.8% $ 30,381.00 24,543.13 80.8% $ 69,564.00 56,177.52 80.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 72,855.31 71,398.00 1,457.31 428,382.00 355,526.69 83.0% 40,138.80 35,699.00 4,439.80 67-G&A-SUPPLIES & MATER/ALS 450.37 1,000.00 (549.63) 86.96 210.00 (123.04) 133.11 200.00 (66.89) 6,300.00 5,849.63 92.9% 1,260.00 1,173.04 93.1% 3,300.00 3,166.89 96.0% 370.41 500.00 (129.59) - 105.00 (105.00) 133.11 100.00 33.11 6703740 Supplies-Computer 6703762 Supplies-Office 6703768 Supplies-Printing & Stationery Total-G&A-SUPPLIES & MATER/ALS 670.44 1,410.00 (739.56) 503.52 705.00 (201.48) 10,860.00 10,189.56 93.8% 67-G&A-REPAIRS & MAINTENANCE - 300.00 (300.00) 7,300.00 7,300.00 100.0% - 150.00 (150.00) 6705690 Repairs & Maintenance-Equipment Total-G&A-REPAIRS & MAINTENANCE - 300.00 (300.00) 7,300.00 7,300.00 100.0% - 150.00 (150.00) 67-G&A-OTHER EXPENSES 500.00 500.00 - - - - - - - 896.85 1,100.00 (203.15) 88.92 90.00 (1.08) 266.85 1,500.00 (1,233.15) 26.45 50.00 (23.55) - 100.00 (100.00) 282.83 75.00 207.83 3,631.25 1,500.00 2,131.25 - 100.00 (100.00) - 200.00 (200.00) - 100.00 (100.00) - 150.00 (150.00) 1,000.00 1,000.00 - 1,048.47 50.00 998.47 35.00 - 35.00 1,556.70 2,200.00 (643.30) 162.49 180.00 (17.51) 1,748.00 3,000.00 (1,252.00) 26.45 100.00 (73.55) 1,249.70 200.00 1,049.70 299.15 150.00 149.15 5,072.13 3,000.00 2,072.13 - 200.00 (200.00) - 400.00 (400.00) - 100.00 (100.00) 332.40 300.00 32.40 6,000.00 5,000.00 83.3% 1,550.00 501.53 32.4% 1,200.00 1,165.00 97.1% 13,200.00 11,643.30 88.2% 1,080.00 917.51 85.0% 18,000.00 16,252.00 90.3% 600.00 573.55 95.6% 6,000.00 4,750.30 79.2% 900.00 600.85 66.8% 18,000.00 12,927.87 71.8% 1,200.00 1,200.00 100.0% 3,400.00 3,400.00 100.0% 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 12,530.49 10,880.00 1,650.49 5,693.15 5,465.00 228.15 74,230.00 61,699.51 83.1% Total-GENERAL & ADMINISTRATIVE 46,335.47 42,019.00 4,316.47 86,056.24 83,988.00 2,068.24 520,772.00 434,715.76 83.5% 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement August 2024 Month to Date Year to Date Annual Budget August 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 6800193 6800195 6800196 6800197 69-MISC Expense 20,475.16 - 5,130.83 864.35 18,150.00 5,200.00 5,072.00 1,150.00 2,325.16 (5,200.00) 58.83 (285.65) 38,785.44 - 10,494.16 1,682.50 36,300.00 10,400.00 10,144.00 2,300.00 2,485.44 (10,400.00) 350.16 (617.50) 252,600.00 - 60,864.00 20,200.00 213,814.56 - 50,369.84 18,517.50 84.6% - 82.8% 91.7% 84.7% 83.3% 96.7% 79.0% 63.6% 85.5% 68 -LEASES Equipment Leases -Maintenance Trailer Lease Equipment Leases -GPS Equipment Leases -Others Total -LEASES 26,470.34 29,572.00 (3,101.66) 50,962.10 59,144.00 (8,181.90) 333,664.00 282,701.90 OTHER EXPENSES 11,437.00 1,502.92 7,454.11 - 11,436.00 1,865.00 4,600.00 - 1.00 (362.08) 2,854.11 - 22,874.00 2,906.84 11,586.75 5,455.14 22,872.00 3,780.00 9,200.00 6,000.00 2.00 (873.16) 2,386.75 (544.86) 137,232.00 88,136.00 55,200.00 15,000.00 114,358.00 85,229.16 43,613.25 9,544.86 6900096 Contract Srvcs-Management Fee 6900210 FF&E Reserve 6900323 Insurance -Commercial 6900800 Personal Property Taxes Total--M/5C OTHER EXPENSES 20,394.03 17,901.00 2,493.03 42,822.73 41,852.00 970.73 295,568.00 252,745.27 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 Charity/Gift Certificate Rain/Wind Checks 3 Club Staff 67 39 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 79 50 0 0 0 0 2025 2025 2025 2025 2025 2025 January February March April May June 0 0 0 0 0 0 10