Loading...
08 February 2024 SilverRock Resort - Monthly Financial StatementSILVERROCK® RESORT Monthly Financial Statements July 01, 2023 - February 29, 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 1 SilverRock Resort Summary Operating Income Statement February 2024 Month to Date Year to Date Annual Budget G/L # Series Account Description February 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. Bdgt Income 400000 Golf Green Fee Revenue 684,313.00 602,940.00 81,373.00 13.5% 2,561,079.00 2,428,634.00 132,445.00 4,110,847.00 1,549,768.00 62% 401000 Miscellaneous Golf Revenue 26,622.55 26,550.00 72.55 0.3% 114,873.55 98,200.00 16,673.55 156,180.00 41,306.45 74% 410000 Revenue -Golf Shop 29,243.84 36,400.00 (7,156.16) -19.7% 127,613.63 141,900.00 (14,286.37) 245,623.00 118,009.37 52% 420000 Food & Beverage Revenue 107,120.09 97,760.00 9,360.09 9.6% 420,777.20 406,044.00 14,733.20 710,099.00 289,321.80 59% Total Income 847,299.48 763,650.00 83,649.48 10.95% 3,224,343.38 3,074,778.00 149,565.38 5,222,749.00 1,998,405.62 62% Cost of Goods Sold 510000 COS -Golf Shop 16,611.04 20,373.00 (3,761.96) 18.5% 70,296.76 79,424.00 9,127.24 137,475.00 67,178.24 51% 520000 COS -Food & Beverage 39,045.25 29,187.00 9,858.25 _33,8% 185,118.78 127,610.00 (57,508.78) 218,834.00 33,715.22 85% Total COS 55,656.29 49,560.00 6,096.29 -12.3% 255,415.54 207,034.00 (48,381.54) 356,309.00 100,893.46 72% Gross Profit 791,643.19 714,090.00 77,553.19 10.9% 2,968,927.84 2,867,744.00 101,183.84 4,866,440.00 1,897,512.16 61% Expenses 610000 Golf Pro Shop 25,041.01 25,546.00 (504.99) 2.0% 159,319.82 161,599.00 (2,279.18) 259,447.00 100,127.18 61% 630000 Course Maintenance 146,675.90 149,676.00 (3,000.10) 2.0% 1,479,681.05 1,411,257.00 68,424.05 2,005,608.00 525,926.95 74% 633000 Maintenance Water & Energy 21,454.78 20,220.00 1,234.78 -6.1% 220,726.33 186,665.00 34,061.33 282,424.00 61,697.67 78% 640000 Outside Services 52,085.65 61,692.00 (9,606.35) 15.6% 327,956.82 353,464.00 (25,507.18) 542,757.00 214,800.18 60% 650000 Clubhouse 18,768.53 15,301.00 3,467.53 -22.7% 124,876.04 123,408.00 1,468.04 185,512.00 60,635.96 67% 660000 Marketing 10,671.27 21,602.00 (10,930.73) 50.6% 94,542.46 116,551.00 (22,008.54) 170,814.00 76,271.54 55% 670000 General & Administrative 35,966.71 39,232.00 (3,265.29) 8.3% 320,879.70 321,226.00 (346.30) 472,307.00 151,427.30 68% 680000 Leases 24,602.90 36,850.00 (12,247.10) 33.2% 251,826.75 277,944.00 (26,117.25) 425,344.00 173,517.25 59% 690000 Miscellaneous Other Expense 30,403.84 31,868.00 (1,464.16) 4.6% 208,190.50 218,845.00 (10,654.50) 343,521.00 135,330.50 61% 620000 Food & Beverage Expenses 60,795.27 55,273.00 5,522.27 -10.0% 351,197.75 317,760.00 33,437.75 491,697.00 140,499.25 61% Total Expenses 426,465.86 457,260.00 (30,794.14) 6.7% 3,539,197.22 3,488,719.00 (50,478.22) 5,179,431.00 1 1,499,734.53 68% Net Income 365,177.33 256,830.00 108,347.33 28.5% (570,269.38) (620,975.00) 50,705.62 (312,991.00) 397,777.63 400000 Rounds of Golf Played Paid Rounds Played 5,293 5,200 93 1.8% 25,253 26,210 (957) 41,996 16,743 60% Ave $ Per Paid Round Green Fee 129.29 115.95 13.34 11.5% 101.42 92.66 8.76 97.89 (3.53) 104% Ave $ Per Paid Round Merchandise 5.53 7.00 (1.47) -21.1% 5.05 5.41 (0.36) 5.85 0.80 86% Ave $ Per Paid Miscellaneous 5.03 5.11 (0.08) -1.5% 4.55 3.75 0.80 3.72 (0.83) 122% 1 2 SilverRock Resort Statement of Fees - Revenue February 2024 Month to Date Year to Date Annual Budget February Income 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 684,313.00 602,940.00 81,373.00 2,561,079.00 2,428,634.00 132,445.00 4,110,847.00 1,549,768.00 37.7% 4010000 Rider Fee 2,180.00 2,400.00 (220.00) 11,035.00 14,700.00 (3,665.00) 17,480.00 6,445.00 36.9% 4040000 Club Rental 3,097.55 4,250.00 (1,152.45) 25,422.55 18,600.00 6,822.55 29,800.00 4,377.45 14.7% 4050000 Driving Range 19,465.00 18,000.00 1,465.00 71,445.00 57,750.00 13,695.00 97,350.00 25,905.00 26.6% 4060000 Handicap Fees 380.00 400.00 (20.00) 2,206.00 1,150.00 1,056.00 1,550.00 (656.00) -42.3% 4090000 Ball Retriever/Subcontract - - - 765.00 1,500.00 (735.00) 2,500.00 1,735.00 69.4% 4091000 Golf Professional Rental Fee 1,500.00 1,500.00 - 4,000.00 4,500.00 (500.00) 7,500.00 3,500.00 46.7% Total Miscellaneous Revenue 26,622.55 26,550.00 72.55 114,873.55 98,200.00 16,673.55 156,180.00 41,306.45 26.4% 710,935.55 629,490.00 81,445.55 2,675,952.55 2,526,834.00 149,118.55 4,267,027.00 1,591,074.45 37.3% Total Revenue Fees Total Income I 710,935.55 629,490.00 81,445.55 2,675,952.55 2,526,834.00 149,118.55 4,267,027.00 1,591,074.45 37.3% 2 3 SilverRock Resort Golf Shop Income Statement February 2024 Month to Date Year to Date Annual Budget February Annual Income 2024 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 10.00 - 10.00 3,877.40 - 3,877.40 0 0 0% 4100110 Sales Hard Goods 8,460.77 27,300.00 (18,839.23) 47,540.73 106,425.00 (58,884.27) 61,406.00 13,865.27 22.6% 4100112 Sales -Soft Goods 20,773.07 9,100.00 11,673.07 83,197.05 35,475.00 47,722.05 184,217.00 101,019.95 54.8% 5100639 GS -Discounts -Mdse - - - (7,001.55) - (7,001.55) - 7,001.55 0.0% Total Revenue Golf Shop 29,243.84 36,400.00 (7,156.16) 127,613.63 141,900.00 (7,284.82) 245,623.00 114,885.22 46.8% COS 5100150 COS -GS -Hard Goods 5,382.17 5,278.00 104.17 25,907.71 20,577.00 5,330.71 35,615.00 9,707.29 27.3% 5100151 COS -GS -Soft Goods 10,963.78 15,834.00 (4,870.22) 43,323.83 61,728.00 (18,404.17) 106,846.00 63,522.17 59.5% 5100152 COS -GS -Purchase Disc (390.37) (1,056.00) 665.63 (1,954.91) (4,116.00) 2,161.09 (7,123.00) (5,168.09) 0.0% 5100220 COS -GS -Freight Merch 655.46 317.00 338.46 3,020.13 1,235.00 1,785.13 2,137.00 (883.13) -41.3% Cost of Sales - Golf Shop 16,611.04 20,373.00 (3,761.96) 70,296.76 79,424.00 (9,127.24) 137,475.00 67,178.24 48.9% Gross Profit 12,632.80 16,027.00 (3,394.20) 57,316.87 62,476.00 1,842.42 108,148.00 47,706.98 44.1% COS % 56.8% 56.0% -0.8% 55.1% 56.0% 0.9% 53.1% 58.5% 110.2% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 360.14 774.00 (413.86) 3,585.28 6,192.00 (2,606.72) 9,288.00 5,702.72 61.4% 6101325 Insurance -Workers Comp 1,600.00 1,633.00 (33.00) 9,451.96 9,970.00 (518.04) 15,959.00 6,507.04 40.8% 6101720 Salaries 5,769.24 6,436.00 (666.76) 49,038.54 51,488.00 (2,449.46) 77,250.00 28,211.46 36.5% 6101800 Taxes -Employer Payroll 2,695.56 1,957.00 738.56 12,811.68 11,951.00 860.68 19,129.00 6,317.32 33.0% 6101880 Wages -Hourly 13,721.81 13,636.00 85.81 77,470.46 71,078.00 6,392.46 118,952.00 41,481.54 34.9% 6101882 Wages -Overtime 148.15 - 148.15 814.92 - 814.92 - (814.92) 0.0% Total -PS-SALARIES & BENEFITS 24,294.90 24,436.00 (141.10) 153,172.84 150,679.00 2,493.84 240.578.00 87.405.16 36.3% 61 -PS OTHER EXPENSES 6103762 Supplies -Office - 250.00 (250.00) 1,086.74 2,000.00 (913.26) 3,000.00 1,913.26 63.8% 6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 100.0% 6109220 Freight & Delivery - - - - 75.00 (75.00) 75.00 75.00 100.0% 6109490 Miscellaneous - 500.00 (500.00) 1,592.63 4,000.00 (2,407.37) 6,000.00 4,407.37 73.5% 6109722 Seminars/Training 458.99 35.00 423.99 458.99 2,335.00 (1,876.01) 3,690.00 3,231.01 87.6% 6109810 Travel - Merchandise - 15.00 (15.00) - 30.00 (30.00) 90.00 90.00 100.0% 6109820 Uniforms - 200.00 (200.00) 1,816.42 1,600.00 216.42 2,400.00 583.58 24.3% 6117840 Telephones 287.12 110.00 177.12 1,192.20 880.00 312.20 1,320.00 127.80 9,7% Total - Other Expenses 746.11 1,110.00 (363.89) 6,146.98 10,920.00 (4,773.02) 18,875.00 12,728.02 67.4% Total Expenses -Golf Shop 25,041.01 25,546.00 (504.99) 159,319.82 161,599.00 (2,279.18) 259,453.00 100,133.18 38.6% Net Income (12,408.21) (9,519.00) (2,889.21) (102,002.95) (99,123.00) 4,121.60 (151,305.00) (52,426.20) 34.6% 3 4 SilverRock Resort Course Maintenance Expense Statement February 2024 Month to Date Year to Date Annual Budget February 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 9,087.53 9,696.00 (608.47) 59,469.46 69,054.00 (9,584.54) 107,838.00 48,368.54 44.9% 6311325 Insurance -Workers Comp 3,700.00 3,779.00 (79.00) 26,612.06 28,149.00 (1,536.94) 42,860.00 16,247.94 37.9% 6311720 Salaries 15,076.92 16,713.00 (1,636.08) 125,840.58 133,704.00 (7,863.42) 200,000.00 74,159.42 37.1% 6311800 Taxes -Employer Payroll 8,401.48 7,603.00 798.48 45,072.64 56,856.00 (11,783.36) 86,375.00 41,302.36 47.8% 6311880 Wages -Hourly 51,774.82 58,676.00 (6,901.18) 380,201.61 423,497.00 (43,295.39) 652,304.00 272,102.39 41.7% 6311882 Wages -Overtime 1,151.28 2,592.00 (1,440.72) 27,353.69 25,936.00 1,417.69 33,620.00 6,266.31 18.6% Total -CM -SALARIES & BENEFITS 89,192.03 99,059.00 (9,866.97) 664,550.04 737,196.00 (72,645.96) 1,122,997.00 458,446.96 40.8% 63 -CM -SUPPLIES & MATERIALS 6313745 Chemicals 801.20 3,000.00 (2,198.80) 38,903.10 35,500.00 3,403.10 46,500.00 7,596.90 16.3% 6313744 Fertilizer 9,478.86 3,500.00 5,978.86 95,893.46 81,900.00 13,993.46 111,800.00 15,906.54 14.2% 6313746 Flowers/Plants - - - 7,523.68 3,500.00 4,023.68 7,000.00 (523.68) -7.5% 6313748 Fuel -Gasoline 7,258.31 5,700.00 1,558.31 53,753.26 45,600.00 8,153.26 68,400.00 14,646.74 21.4% 6313750 Golf Course Accessories - - - 8,232.86 14,000.00 (5,767.14) 16,000.00 7,767.14 48.5% 6313756 POA Control - 10,000.00 (10,000.00) 9,290.64 20,000.00 (10,709.36) 20,000.00 10,709.36 53.5% 6313758 Miscellaneous Supp 107.86 500.00 (392.14) 4,396.26 4,750.00 (353.74) 5,950.00 1,553.74 26.1% 6313776 Sand 3,100.56 - 3,100.56 50,339.38 13,500.00 36,839.38 13,500.00 (36,839.38) 6313778 Seed 1,479.01 - 1,479.01 142,349.53 190,500.00 (48,150.47) 190,500.00 48,150.47 25.3% 6313780 Small Tools & Non -Capital Equip 230.17 575.00 (344.83) 5,966.31 4,725.00 1,241.31 7,025.00 1,058.69 15.1% 6313782 Sod - - - 7,393.10 11,000.00 (3,606.90) 15,500.00 8,106.90 52.3% 6313784 Topdressing- - - 1,919.62 6,000.00 (4,080.38) 19,000.00 17,080.38 89,9/ Total -CM -SUPPLIES & MATERIALS 22,455.97 23,275.00 (819.03) 425,961.20 430,975.00 (5,013.80) 521,175.00 95,213.80 18.3% 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 4,100.00 5,143.00 (1,043.00) 33,200.00 41,144.00 (7,944.00) 61,716.00 28,516.00 46.2% 6315685 CM-R&M-Bldngs & Othr Structures 129.50 250.00 (120.50) 1,319.16 4,550.00 (3,230.84) 5,550.00 4,230.84 76.2% 6315690 CM -R&M -Equipment 2,168.40 2,500.00 (331.60) 42,458.57 29,500.00 12,958.57 38,500.00 (3,958.57) -10.3% 6315692 CM -R&M -Irrigation System 1,183.92 1,250.00 (66.08) 22,907.77 18,050.00 4,857.77 23,300.00 392.23 1.7% 6315696 CM -R&M -Pumps 2,068.24 1,000.00 1,068.24 12,276.52 8,000.00 4,276.52 10,500.00 (1,776.52) -16.9% 6315815 CM -R&M -Trees -Pruning Etc - - - 17,630.00 6,050.00 11,580.00 14,050.00 (3,580.00) -25.5% Total -CM-Repair & Maintenance 9,650.06 10,143.00 (492.94) 129,792.02 107,294.00 22,498.02 153 616.00 23,823.98 15.5% 6317836 Utilities -Natural Gas/LPG 31.22 15.00 16.22 130.86 120.00 10.86 180.00 49.14 0.0% 6317840 Telephones 871.36 850.00 21.36 16,090.87 6,800.00 9,290.87 10,200.00 (5,890.87) -57.8% Total -CM -UTILITIES 902.58 865.00 37.58 16,221.73 6,920.00 9,301.73 10 380.00 (5,841.73) -56.3% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 3,200.00 3,200.00- 4,800.00 1,600.00 33.3% 6319100 Contract Svcs-Soil/Tissue Test - - - - 3,000.00 (3,000.00) 4,500.00 4,500.00 100.0% 6319102 Contract Svcs -Trash Removal - 524.00 (524.00)- 4,192.00 (4,192.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions - 200.00 (200.00) 2,372.93 200.00 2,172.93 680.00 (1,692.93) -249.0% 6319170 Employee Education 50.00 1,000.00 (950.00) 350.00 1,350.00 (1,000.00) 3,900.00 3,550.00 91.0% 6319197 Equipment Rental - 200.00 (200.00) - 2,700.00 (2,700.00) 3,400.00 3,400.00 100.0% 6319206 Licenses & Permits - - - 700.00 400.00 300.00 4,300.00 3,600.00 83.7% 6319490 Miscellaneous - 100.00 (100.00) 1,236.99 800.00 436.99 1,200.00 (36.99) -3.1% 6319718 Safety Equipment & Training - 200.00 (200.00)- 3,350.00 (3,350.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms 376.22 1,210.00 (833.78) 4,919.90 9,680.00 (4,760.10) 14,520.00 9,600.10 66.1% Total -CM -OTHER EXPENSES 826.22 3,834.00 (3,007.78) 12,779.82 28,872.00 (16,092.18) 47,438.00 34,658.18 73.06% 4 SilverRock Resort Course Maintenance Expense Statement February 2024 4 Silverrock Resort Course Maintenance Water & Energy February 2024 Month to Date Year to Date Annual Budget February 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 23,649.04 12,500.00 11,149.04 230,376.24 100,000.00 130,376.24 150,000.00 (80,376.24) -53.6% -53.6 26.2% 6321880 Contract Labor Total Contract Service 23,649.04 12,500.00 11,149.04 230,376.24 100,000.00 130,376.24 150,000.00 (80,376.24) Total -COURSE MAINTENANCE 146,675.90 149,676.00 (3,000.10) 1,479,681.05 1,411,257.00 68,424.05 2,005,606.00 525,924.95 4 Silverrock Resort Course Maintenance Water & Energy February 2024 Month to Date Year to Date Annual Budget February 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 18,770.39 2,684.39 14,100.00 6,120.00 4,670.39 (3,435.61) 147,690.81 73,035.52 111,140.00 75,525.00 36,550.81 (2,489.48) 144,810.00 115,484.00 (2,880.81) 42,448.48 -2.0% 36.8% 15.2 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total -CM -WATER & ENERGY 21,454.78 20,220.00 1,234.78 220,726.33 186,665.00 34,061.33 260,294.00 39,567.67 4 5 SilverRock Resort Outside Services Expense Statement February 2024 Month to Date Year to Date Annual Budget February 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance -Group 575.77 774.00 (198.23) 4,290.82 6,192.00 (1,901.18) 9,288.00 4,997.18 53.8% 6411325 Insurance -Workers Comp 2,600.00 2,620.00 (20.00) 13,911.01 13,684.00 227.01 21,662.00 7,750.99 35.8% 6411800 Taxes -Employer Payroll 4,298.15 4,010.00 288.15 16,166.36 20,943.00 (4,776.64) 33,156.00 16,989.64 51.2% 6411880 Wages -Hourly 26,421.76 32,205.00 (5,783.24) 136,731.40 168,217.00 (31,485.60) 266,317.00 129,585.60 48.7% 6411882 Wages -Overtime 2,676.04 - 2,676.04 12,425.02 - 12,425.02 - (12,425.021 0.0% Total -CBR -SALARIES & BENEFITS 36,571.72 39,609.00 (3,037.28) 183,524.61 209,036.00 (25,511.39) 330,423.00 146 898.39 44.5% 641 -CBR -SUPPLIES & MATERIALS 6413732 Supplies -Carts 308.75 75.00 233.75 2,244.32 1,650.00 594.32 1,850.000.0% 6413742 Supplies -Expendable 1,291.48 1,000.00 291.48 4,783.67 5,450.00 (666.33) 6,750.00 1,966.33 29.1% 6413748 Supplies -Fuel for Shuttle - - - - - - - - 0.0% 6413752 Supplies -Range Balls - - - 14,681.25 10,000.00 4,681.25 10,000.00 (4,681.25) -46.8% 6413762 Supplies -Office 86.05 50.00 36.05 86.05 325.00 (238.95) 525.00 438.95 83.6% 6413768 Supplies -Printing and Stationary - 70.00 (70.00) - 140.00 (140.00) 420.00 420.00 100.0% 6413786 Supplies -Towels 160.00 250.00 (90.00) 2,396.34 1,360.00 1,036.34 2,182.00 (214.34) -9.8% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 14,400.00 20,000.00 (5,600.00) 30,000.00 15,600.00 52.0% Total -CBR -SUPPLIES & MATERIALS 1,846.28 3,945.00 (2,098.72) 38,591.63 38,925.00 (333.37) 51,727.00 13,529.69 26.2% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment - 300.00 (300.00) 15,447.50 2,400.00 13,047.50 3,600.00 (11,847.50) -329.1% 6415695 CBR -R&M -Cart Maintenance & Repa- 1,503.00 (1,503.00) 10,696.14 12,024.00 (1,327.86) 18,036.00 7,339.86 40.7% Total -CBR -REPAIRS & MAINTENANCE - 1,803.00 (1,803.00) 26,143.64 14,424.00 11,719.64 21 636.00 (4.507.64) -20.8% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 282.70 800.00 (517.30) 4,065.10 6,400.00 (2,334.90) 9,600.00 5,534.90 57.7% 6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0% 6419490 Miscellaneous 73.88 600.00 (526.12) 1,699.89 4,800.00 (3,100.11) 7,200.00 5,500.11 76.4% 6419820 Uniforms 3,272.07 3,000.00 272.07 5,200.00 1,927.93 37.1% Total -CBR -OTHER EXPENSES 356.58 1,400.00 (1,043.42) 9,037.06 14,650.00 (5,612.94) 22 450.00 13 412.94 59.7% TOTAL-CARTS,BAGROOM & RANGE 38,774.58 46,757.00 (1,043.42) 257,296.94 277,035.00 (19,738.06) 426,236.00 169,333.38 39.7% 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 1,000.00 1,015.00 (15.00) 5,251.46 5,080.00 171.46 7,766.00 2,514.54 32.4% 6431800 Taxes -Employer Payroll 1,532.29 1,217.00 315.29 6,407.21 6,091.00 316.21 9,308.00 2,900.79 31.2% 6431880 Wages -Hourly 10,429.92 12,478.00 (2,048.08) 56,530.46 62,458.00 (5,927.54) 95,471.00 38,940.54 40.8% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 12,962.21 14,710.00 (1,747.79) 68,189.13 73,629.00 (5,439.87) 112 545.00 44 355.87 39.4% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 348.86 100.00 248.86 766.78 700.00 66.78 1,050.00 283.22 27.0% 6439490 Miscellaneous - - - 32.60 200.00 (167.40) 200.00 167.40 83.7% 6439718 Safety Equipment & Training - 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0% 6439820 Uniforms- 75.00 (75.00) 1,671.37 1,500.00 171.37 2,125.00 453.63 21.3% Total -CS -OTHER EXPENSES 348.86 225.00 123.86 2,470.75 2,800.00 (329.25) 3,975.00 1,504.25 37.8% Total -COURSE SERVICES 13,311.07 14,935.00 (1,623.93) 70,659.88 76,429.00 (5,769.12) 116,520.00 45,860.12 39.4% TOTAL OUTSIDE SERVICES 52,085.65 61,692.00 (9 606.35) 327,956.82 353,464.00 (25.507.18) 542 756.00 213,689.25 39.4% 5 6 SilverRock Resort Clubhouse Expense Statement February 2024 Month to Date Year to Date Annual Budget February Annual 2024 Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATERIALS 6503742 Supplies -Expendable 400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3% Total -CH -SUPPLIES & MATER/ALS 400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 2,093.60 1,000.00 1,093.60 6,675.44 8,000.00 (1,324.56) 12,000.00 5,324.56 44.4% 6507840 Utilities -Telephone 1,162.08 1,750.00 (587.92) 12,732.63 14,000.00 (1,267.37) 21,000.00 8,267.37 39.4% 6507842 Utilities -Water 599.65 321.00 278.65 4,618.53 2,568.00 2,050.53 3,852.00 (766.53) -19.9% 6507844 Utilities -Cable 409.73 380.00 29.73 3,560.06 3,040.00 520.06 4,560.00 999.94 21.9% Total -CH -UTILITIES 4,265.06 3,451.00 814.06 27,586.66 27,608.00 (21.34) 41,412.00 13,825.34 33.4% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 3,216.16 2,850.00 366.16 24,975.31 22,800.00 2,175.31 34,200.00 9,224.69 27.0% 6509099 Contract Services -Security 6,359.56 6,800.00 (440.44) 60,271.76 54,400.00 5,871.76 81,600.00 21,328.24 26.1% 6509215 Flowers & Decorations - - - - 1,000.00 (1,000.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - - - - - - - 0.0% 6509718 Safety Equipment & Training- 100.00 (100.00) - 800.00 (800.00) 1,200.00 1,200.00 100.0% Total -CH -OTHER EXPENSES 9,575.72 9,750.00 (174.28) 85,247.07 79,000.00 6,247.07 118,900.00 33,652.93 28.3% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 990.75 300.00 690.75 4,320.95 2,400.00 1,920.95 3,600.00 (720.95) -20.0% 6515686 CH -R&M -Restaurant Repairs 3,537.00 700.00 2,837.00 3,537.00 5,600.00 (2,063.00) 8,400.00 4,863.00 57.9% 6515690 CH -R&M -Equipment Repair - 700.00 (700.00) 984.36 5,600.00 (4,615.64) 8,400.00 7,415.64 88,3% Total -CH -REPAIRS & MAINTENANCE 4,527.75 1,700.00 2,827.75 8,842.31 13,600.00 (4,757.69) 20,400.00 11,557.69 56.7% Total CLUBHOUSE 18,768.53 15,301.00 3,467.53 124,876.04 123,408.00 1,468.04 185,512.00 23,115.38 12.5% 6 7 SilverRock Resort Marketing Expense Statement February 2024 Month to Date Year to Date Annual Budget February Annual 2024 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group 376.77 387.00 (10.23) 1,143.77 1,161.00 (17.23) 2,709.00 1,565.23 57.8% 6601325 Insurance -Workers Comp 100.00 102.00 (2.00) 602.00 816.00 (214.00) 1,220.00 618.00 50.7% 6601720 Salaries 1,250.00 1,250.00- 10,625.00 10,000.00 625.00 15,000.00 4,375.00 29.2% 6601800 Tax -Employer Payroll 122.00 122.00- 1,137.00 976.00 161.00 1,463.00 326.00 22.3% Total -MKT -SALARIES & BENEFITS 1,848.77 1,861.00 (12.23) 13,507.77 12,953.00 554.77 20,392.00 6,884.23 33.8% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office 59.99 100.00 (40.01) 241.72 800.00 (558.28) 1,200.00 958.28 79.9% 6603768 Supplies -Printing & Stationery - 125.00 (125.00) 6,145.23 3,925.00 2,220.23 4,425.00 (1,720.231 -38.9% Total -MKT -SUPPLIES & MARKET/NG 59.99 225.00 (165.01) 6,386.95 4,725.00 1,661.95 5,625.00 (761.951 -13.5% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 205.12 100.00 105.12 1,480.87 800.00 680.87 1,200.00 (280.87) -23.4% Total -MKT -UTILITIES 205.12 100.00 105.12 1,480.87 800.00 680.87 1,200.00 (280.87) -23.4% 66 -MKT -OTHER EXPENSES 6609010 Advertising 5,614.99 17,566.00 (11,951.01) 59,468.26 89,188.00 (29,719.74) 129,762.00 70,293.74 54.2% 6609040 Business Meals 74.33 25.00 49.33 74.33 200.00 (125.67) 300.00 225.67 75.2% 6609080 Collateral Material 2,131.50 500.00 1,631.50 11,616.68 2,500.00 9,116.68 5,500.00 (6,116.68) -111.2% 6609102 Contract Services -Web Page- 150.00 (150.00) - 1,200.00 (1,200.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions- 400.00 (400.00) - 435.00 (435.00) 350.00 350.00 100.0% 6609620 Postage- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0% 6609490 Miscellaneous- 50.00 (50.00) - 400.00 (400.00) 700.00 700.00 100.0% 6609630 Promotion 111.57 500.00 (388.43) 111.57 1,000.00 (888.43) 2,250.00 2,138.43 95.0% 6609633 Promotion-Cummunity 625.00 75.00 550.00 625.00 1,950.00 (1,325.00) 1,000.00 375.00 37.5% 6609634 Promotion-MediaNendor- 50.00 (50.00) 1,040.40 500.00 540.40 735.00 (305.40) -41.6% 6609820 Uniforms - 50.00 (50.00) 230.63 500.00 (269.37) 600.00 369.37 61.6% Total -MKT -OTHER EXPENSES 8,557.39 19,416.00 (10,858.61) 73,166.87 98,073.00 (24,906.13) 143,597.00 70,430.13 49.0% TOTAL MARKETING 10,671.27 21,602.00 (10,930.73) 94,542.46 116,551.00 (22,008.54) 170,814.00 76,271.54 44.7% 7 SilverRock Resort General and Administrative Expense Statement February 2024 Month to Date Year to Date Annual Budget February 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 4,642.11 3,117.00 1,525.11 32,739.09 24,936.00 7,803.09 37,404.00 4,664.91 12.5% 6701325 Insurance -Workers Comp 1,950.00 1,951.00 (1.00) 15,393.84 16,449.00 (1,055.16) 24,251.00 8,857.16 36.5% 6701720 Salaries 16,749.60 20,141.00 (3,391.40) 146,333.60 161,128.00 (14,794.40) 266,243.00 119,909.40 45.0% 6701800 Taxes -Employer Payroll 2,030.76 2,338.00 (307.24) 17,905.24 19,715.00 (1,809.76) 29,069.00 11,163.76 38.4% 6701880 Wages -Hourly 5,026.76 3,840.00 1,186.76 57,934.98 41,088.00 16,846.98 31,900.00 (26,034.98) -81.6% 6701882 Wages -Overtime - - - 45.61 - 45.61 - - Total -G&A -SALARIES & BENEFITS 30,399.23 31,387.00 (987.77) 270,352.36 263,316.00 7,036.36 388,867.00 118,514.64 30.5% 67 -G&A -SUPPLIES & MATERIALS 6703740 Supplies -Computer 340.62 500.00 (159.38) 1,750.39 4,000.00 (2,249.61) 6,300.00 4,549.61 72.2% 6703762 Supplies -Office 69.15 105.00 (35.85) 582.58 840.00 (257.42) 1,260.00 677.42 53.8% 6703768 Supplies -Printing & Stationery - 400.00 (400.00) 1,527.31 1,700.00 (172.69) 3,300.00 1,772.69 53.7 Total -G&A -SUPPLIES & MATER/ALS 409.77 1,005.00 (595.23) 3,860.28 6,540.00 (2,679.72) 10,860.00 6,999.72 64.5% 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment 165.78 100.00 65.78 165.78 1,500.00 (1,334.22) 1,900.00 1,734.22 91.3% Total -G&A -REPAIRS & MAINTENANCE 165.78 100.00 65.78 165.78 1,500.00 (1,334.22) 1,900.00 1,734.22 91.3% 67 -G&A -OTHER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 33.3% 6709150 Dues & Subscriptions 98.99 200.00 (101.01) 482.05 800.00 (317.95) 1,550.00 1,067.95 68.9% 6709180 Employee Recruiting/Relocation 807.00 200.00 607.00 1,772.01 1,000.00 772.01 1,200.00 (572.01) -47.7% 6709197 Equipment Rental 925.01 550.00 375.01 6,586.56 4,400.00 2,186.56 6,600.00 13.44 0.2% 6709202 Fees -Bank 66.04 90.00 (23.96) 448.82 720.00 (271.18) 1,080.00 631.18 58.4% 6709208 Fees -Payroll Processing 1,661.25 1,000.00 661.25 11,038.18 8,000.00 3,038.18 12,000.00 961.82 8.0% 6709220 Freight/Delivery - 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0% 6709490 Miscellaneous - 100.00 (100.00) 8,094.95 5,600.00 2,494.95 6,000.00 (2,094.95) -34.9% 6709620 Postage/Mail Services 264.64 75.00 189.64 994.82 600.00 394.82 900.00 (94.82) -10.5% 6709625 Expense Professional Fees 669.00 3,500.00 (2,831.00) 10,619.39 20,000.00 (9,380.61) 28,000.00 17,380.61 62.1% 6709636 Promotion/Entertainment - 100.00 (100.00) 94.61 800.00 (705.39) 1,200.00 1,105.39 92.1% 6709722 Seminars & Training - 200.00 (200.00) 953.78 2,600.00 (1,646.22) 3,400.00 2,446.22 71.9% 6709810 Travel - 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms- 75.00 (75.00) 1,416.11 750.00 666.11 1,050.00 (366.11) -34.9% Total -G&A -OTHER EXPENSES 4,991.93 6,740.00 (1,748.07) 46,501.28 49,870.00 (3,368.72) 70,680.00 24,178.72 34.2% Total -GENERAL & ADMINISTRATIVE 35,966.71 39.232.00 (3,265.29) 320.879.70 321.226.00 (346.30) 472,307.00 151.427.30 32.1% 8 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement February 2024 Month to Date Year to Date Annual Budget February Annual 2024 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 68 -LEASES 6800192 Equipment Leases -Carts - 14,000.00 (14,000.00) 73,255.63 98,344.00 (25,088.37) 154,344.00 81,088.37 52.5% 6800193 Equipment Leases -Maintenance 18,683.72 18,150.00 533.72 146,855.68 145,200.00 1,655.68 217,800.00 70,944.32 32.6% 6800196 Equipment Leases -GPS 4,664.00 2,750.00 1,914.00 23,144.00 22,000.00 1,144.00 33,000.00 9,856.00 29.9% 6800197 Equipment Leases -Others 1,255.18 1,950.00 (694.82) 8,571.44 12,400.00 (3,828.56) 20,200.00 11,628.56 57.6% Total -LEASES I 24,602.90 36,850.00 (12,247.10) 1 251,826.75 277,944.00 (26,117.25) i 425,344.00 173,517.25 40.8% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 87,136.00 87,136.00 - 130,704.00 43,568.00 33.3% 6900210 FF&E Reserve 13,686.26 12,059.00 1,627.26 51,230.14 48,573.00 2,657.14 82,217.00 30,986.86 37.7% 6900323 Insurance -Commercial 5,825.58 8,917.00 (3,091.42) 54,555.68 71,336.00 (16,780.32) 107,000.00 52,444.32 49.0% 6900800 Personal Property Taxes - - - 15,268.68 11,800.00 3,468.68 11,800.00 (3,468.68) -29.4% Tota/-M/SC OTHER EXPENSES 30,403.84 31,868.00 (1,464.16) 208 190.50 218 845.00 j10,654.50) 331,721.00 123,530.50 37.2% 9 SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report -2023-2024 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 2023 2023 2023 2023 2023 2023 July August September October November December 9 3 26 7 16 4 4 10 7 11 14 7 31 4 16 12 9 55 6 38 0 24 25 66 98 2024 2024 2024 2024 2024 2024 January February March April May June 4 Golf Industry 6 VIP Celebrity PGA Comp 13 14 Charity/Gift Certificate 4 Rain/Wind Checks 10 17 Club Staff 33 38 LQ HS Golf 12 60 81 0 0 0 0 10