Loading...
11 May 2024 SilverRock Resort - Monthly Financial StatementLVCRP\OCK & R E S O R T Monthly Financial Statements July 01, 2023 - May 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 &t Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement May 2024 Month to Date Year to Date Annual Budget G/L # Series Account Description Income May 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. / Bdgt 400000 Golf Green Fee Revenue 404,134.00 354,320.00 49,814.00 14.1% 4,217,581.47 3,972,273.00 245,308.47 4,110,847.00 (106,734.47) 103% 401000 Miscellaneous Golf Revenue 13,060.00 10,395.00 2,665.00 25.6% 184,177.61 151,035.00 33,142.61 156,180.00 (27,997.61) 118% 410000 Revenue -Golf Shop 30,020.48 21,071.00 8,949.48 42.5% 225,750.67 234,354.00 (8,603.33) 245,623.00 19,872.33 92% 420000 Food & Beverage Revenue 91,433.52 63,899.00 27,534.52 43.1% 722,322.90 676,175.00 46,147.90 710,099.00 (12,223.90) 102% Total Income 538,648.00 449,685.00 88,963.00 19.78% 5,349,832.65 5,033,837.00 315,995.65 5,222,749.00 (127,083.65) 102% Cost of Goods Sold 510000 COS -Golf Shop 17,785.82 11,792.00 5,993.82 -50.8% 127,978.83 131,170.00 3,191.17 137,475.00 9,496.17 93% 520000 COS -Food & Beverage 28,449.70 18,972.00 9,477.70 -50.0% 285,515.79 206,569.00 (78,946.79) 218,834.00 (66,681.79) 130% Total COS 46,235.52 30,764.00 15,471.52 -50.3% 413,494.62 337,739.00 (75,755.62) 356,309.00 (57,185.62) 116% Gross Profit 492,412.48 418,921.00 73,491.48 17.5/ 4,936,338.03 4,696,098.00 240,240.03 4,866,440.00 (69,898.03) 101% Expenses 610000 Golf Pro Shop 26,466.15 26,255.00 211.15 -0.8% 245,281.07 238,498.00 6,783.07 259,447.00 14,165.93 95% 630000 Course Maintenance 166,444.97 1371477.00 28,967.97 -21.1% 1,969,300.45 1,853,228.00 116,072.45 2,005,608.00 36,307.55 98% 633000 Maintenance Water & Energy 34,577.19 26,750.00 7,827.19 -29.3% 311,607.10 258,885.00 52,722.10 282,424.00 (29,183.10) 110% 640000 Outside Services 58,570.60 39,668.00 18,902.60 -47.7% 534,816.19 512,667.00 22,149.19 542,757.00 7,940.81 99% 650000 Clubhouse 121341.40 15,301.00 (2,959.60) 19.3% 163,662.66 169,811.00 (6,148.34) 185,512.00 21,849.34 88% 660000 Marketing 11,693.67 12,327.00 (633.33) 5.1% 134,106.04 162,737.00 (28,630.96) 170,814.00 36,707.96 79% 670000 General & Administrative 36,912.45 37,282.00 (369.55) 1.0% 449,653.11 434,472.00 15,181.11 472,307.00 22,653.89 95% 680000 Leases 24,250.15 36,850.00 (12,599.85) 34.2% 324,057.37 388,494.00 (64,436.63) 425,344.00 101,286.63 76% 690000 Miscellaneous Other Expense 25,547.42 26,895.00 (1,347.58) 5.0% 293,745.77 309,144.00 (15,398.23) 343,521.00 49,775.23 86% 620000 Food & Beverage Expenses 67,065.41 36,162.00 30,903.41 -85.5/ 575,772.54 458,655.00 117,117.54 491,697.00 (84,075.54) 86% Total Expenses 463,869.41 394,967.00 68,902.41 -17.4/ 5,002,002.30 4,786,591.00 (215,411.30) 5,179,431.00 261,504.24 97/ Net Income 28,543.07 23,954.00 4,589.07 19.9/ (65,664.27) (90,493.00) 24,828.73 (312,991.00) (331,402.27) 400000 Rounds of Golf Played Paid Rounds Played 4,422 4,300 122 2.8% 40,746 41,825 (1,079) 41,996 1,250 97% Ave $ Per Paid Round Green Fee 91.39 82.40 8.99 10.9% 103.51 94.97 8.54 97.89 (5.62) 106% Ave $ Per Paid Round Merchandise 6.79 4.90 1.89 38.5% 5.54 5.60 (0.06) 5.85 0.31 95% Ave $ Per Paid Miscellaneous 2.95 2.42 0.54 22.2% 4.52 3.61 0.91 3.72 (0.80) 122% SilverRock Resort Statement of Fees - Revenue May 2024 Month to Date Year to Date Annual Budget May 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 404,134.00 354,320.00 49,814.00 4,217,581.47 3,972,273.00 245,308.47 4,110,847.00 (106,734.47) -2.6% 4010000 Rider Fee 2,985.00 495.00 2,490.00 22,705.00 17,235.00 5,470.00 17,480.00 (5,225.00) -29.9% 4040000 Club Rental 3,600.00 2,475.00 1,125.00 44,658.11 28,575.00 16,083.11 29,800.00 (14,858.11) -49.9% 4050000 Driving Range 6,475.00 7,425.00 (950.00) 105,537.00 93,675.00 11,862.00 97,350.00 (8,187.00) -8.4% 4060000 Handicap Fees - - - 2,605.00 1,550.00 1,055.00 1,550.00 (1,055.00) -68.1% 4090000 Ball Retriever/Subcontract - - - 1,672.50 2,500.00 (827.50) 2,500.00 827.50 33.1% 4091000 Golf Professional Rental Fee - - - 7,000.00 7,500.00 (500.00) 7,500.00 500.00 6.7% Total Miscellaneous Revenue 139060.00 4179194.00 109395.00 364JI5.00 29665.00 52,479.00 1849177.61 49401 J59.08 1519035.00 491239308.00 339142.61 2789451.08 1569180.00 492679027.00 (279997.61) (1349732.08) -17.9% .3.2% Total Revenue Fees Total Income 4179194.00 3649715.00 529479.00 494019759.08 491239308.00 2789451.08 492679027.00 (134J32.08) _3.2% 2 SilverRock Resort Golf Shop Income Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous _ _ - 4,037.40 - 4,037.40 0 0 0% 4100110 Sales Hard Goods 15,648.67 5,268.00 10,380.67 88,372.63 58,589.00 29,783.63 61,406.00 (26,966.63) -43.9% 4100112 Sales -Soft Goods 14,371.81 15,803.00 (1,431.19) 140,342.19 175,765.00 (35,422.81) 184,217.00 43,874.81 23.8% 5100639 GS-Discounts-Mdse - - - (7,001.55) - (7,001.55) - 7,001.55 0.0% Total Revenue Golf Shop 30,020.48 21,071.00 8,949.48 225,750.67 234,354.00 (1,601.78) 245,623.00 16,908.18 6.9% COS 5100150 COS-GS-Hard Goods 7,774.77 3,055.00 4,719.77 47,845.94 33,983.00 13,862.94 35,615.00 (12,230.94) -34.3% 5100151 COS-GS-Soft Goods 9,973.70 9,165.00 808.70 78,481.80 101,945.00 (23,463.20) 106,846.00 28,364.20 26.5% 5100152 COS-GS-Purchase Disc (93.97) (611.00) 517.03 (2,129.14) (6,797.00) 4,667.86 (7,123.00) (4,993.86) 0.0% 5100220 COS-GS-Freight Merch 131.32 183.00 (51.68) 3,780.23 2,039.00 1,741.23 2,137.00 (1,643.23) -76.9% Cost of Sales - Golf Shop 17,785.82 11,792.00 5,993.82 127,978.83 131,170.00 (3,191.17) 137,475.00 9,496.17 6.9% Gross Profit 12,234.66 9,279.00 2,955.66 97,771.84 103,184.00 1,589.39 108,148.00 7,412.01 6.9% COS % 59.2% 56.0% -3.3% 56.7% 56.0% -0.7% 53.1 % 56.2% 105.8% Expense 61-PS-SALARIES & BENEFITS 6101320 Insurance Group 422.20 774.00 (351.80) 4,922.76 8,514.00 (3,591.24) 9,288.00 4,365.24 47.0% 6101325 Insurance -Workers Comp 1,435.00 1,439.00 (4.00) 14,116.96 14,644.00 (527.04) 15,959.00 1,842.04 11.5% 6101720 Salaries 6,384.00 6,436.00 (52.00) 71,382.54 70,796.00 586.54 77,250.00 5,867.46 7.6% 6101800 Taxes -Employer Payroll 1,733.73 1,725.00 8.73 19,340.11 17,553.00 1,787.11 19,129.00 (211.11) -1.1% 6101880 Wages -Hourly 14,807.21 11,256.00 3,551.21 124,930.12 109,226.00 15,704.12 118,952.00 (5,978.12) -5.0% 6101882 Wages -Overtime 174.95 - 174.95 1,506.78 - 1,506.78 - (1,506.78) 0.0% Total -PS-SALARIES & BENEFITS 24,957.09 21,630.00 3,327.09 236,199.27 220,733.00 15,466.27 240,578.00 4,378.73 1.8% 61-PS OTHER EXPENSES 6103762 Supplies -Office 500.58 250.00 250.58 1,591.74 2,750.00 (1,158.26) 3,000.00 1,408.26 46.9% 6109150 Dues and Subscriptions 649.00 2,300.00 (1,651.00) 1,064.00 2,300.00 (1,236.00) 2,300.00 1,236.00 53.7% 6109220 Freight & Delivery _ _ _ - 75.00 (75.00) 75.00 75.00 100.0% 6109490 Miscellaneous 205.49 500.00 (294.51) 2,148.77 5,500.00 (3,351.23) 6,000.00 3,851.23 64.2% 6109500 ProShop Over/Under (0.20) - (0.20) (28.40) (28.40) - 28.40 0.0% 6109722 Seminars/Training - 1,250.00 (1,250.00) 598.99 3,655.00 (3,056.01) 3,690.00 3,091.01 83.8% 6109810 Travel - Merchandise - 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 100.0% 6109820 Uniforms 114.13 200.00 (85.87) 2,217.69 2,200.00 17.69 2,400.00 182.31 7.6% 6117840 Telephones 40.06 110.00 (69.94) 1,489.01 1,210.00 279.01 1,320.00 (169.01) -12.8% Total - Other Expenses 1,509.06 4,625.00 (3,115.94) 9,081.80 17,765.00 (8,683.20) 18,875.00 9,793.20 51.9% Total Expenses -Golf Shop 26,466.15 26,255.00 211.15 245,281.07 238,498.00 6,783.07 259,453.00 14,171.93 5.5% Net Income (14,231.49) (16,976.00) 2,744.51 (147,509.23) (135,314.00) (5,193.68) (151,305.00) (6,759.92) 4.5% C] SilverRock Resort Course Maintenance Expense Statement May 2024 Month to Date I Year to Date Annual Budget May 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63-CM-SALARIES & BENEFITS 6311320 Insurance -Group 10,234.67 9,696.00 538.67 84,478.62 98,142.00 (13,663.38) 107,838.00 23,359.38 21.7% 6311325 Insurance -Workers Comp 3,585.00 3,589.00 (4.00) 37,717.06 39,293.00 (1,575.94) 42,860.00 5,142.94 12.0% 6311720 Salaries 16,152.00 16,716.00 (564.00) 180,759.96 183,852.00 (3,092.04) 200,000.00 19,240.04 9.6% 6311800 Taxes -Employer Payroll 5,474.29 7,225.00 (1,750.71) 63,529.47 79,280.00 (15,750.53) 86,375.00 22,845.53 26.4% 6311880 Wages -Hourly 48,722.15 54,792.00 (6,069.85) 550,026.10 595,649.00 (45,622.90) 652,304.00 102,277.90 15.7% 6311882 Wages -Overtime 854.25 2,592.00 (1,737.75) 30,473.33 33,620.00 (3,146.67) 33,620.00 3,146.67 9.4% Total -CM -SALARIES & BENEFITS 859022.36 4,789.52 949610.00 3,000.00 (99587.64) 1,789.52 9469984.54 45,435.19 190299836.00 41,500.00 (829851.46) 3,935.19 191229997.00 46,500.00 176,012.46 1,064.81 15.7% 2.3% 63-CM-SUPPLIES & MATERIALS 6313745 Chemicals 6313744 Fertilizer 7,444.60 3,400.00 4,044.60 118,764.54 103,800.00 14,964.54 111,800.00 (6,964.54) -6.2% 6313746 Flowers/Plants 2,247.44 - 2,247.44 9,771.12 7,000.00 2,771.12 7,000.00 (2,771.12) -39.6% 6313748 Fuel -Gasoline 5,962.60 5,700.00 262.60 68,997.71 62,700.00 6,297.71 68,400.00 (597.71) -0.9% 6313750 Golf Course Accessories - - - 8,232.86 16,000.00 (7,767.14) 16,000.00 7,767.14 48.5% 6313756 POA Control - - - 11,920.57 20,000.00 (8,079.43) 20,000.00 8,079.43 40.4% 6313758 Miscellaneous Supp 728.01 100.00 628.01 6,635.37 5,850.00 785.37 5,950.00 (685.37) -11.5% 6313776 Sand - - - 53,448.09 13,500.00 39,948.09 13,500.00 (39,948.09) 6313778 Seed - - - 143,371.74 190,500.00 (47,128.26) 190,500.00 47,128.26 24.7% 6313780 Small Tools & Non -Capital Equip - 575.00 (575.00) 6,656.69 6,450.00 206.69 7,025.00 368.31 5.2% 6313782 Sod 6,020.00 - 6,020.00 13,413.10 11,000.00 2,413.10 15,500.00 2,086.90 13.5% 6313784 Topdressing 8,020.03 3,000.00 5,020.03 9,939.65 9,000.00 939.65 19,000.00 9,060.35 47.7% Total -CM -SUPPLIES & MATERIALS 359212.20 4,346.00 159775.00 5,143.00 199437.20 (797.00) 4969586.63 50,092.00 4879300.00 56,573.00 99286.63 (6,481.00) 521,175.00 61,716.00 24,588.37 11,624.00 4.7% 18.8% 63-CM-REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 6315685 CM-R&M-Bldngs & Othr Structures 163.09 250.00 (86.91) 2,015.53 5,300.00 (3,284.47) 5,550.00 3,534.47 63.7% 6315690 CM -R&M -Equipment 3,281.02 2,500.00 781.02 52,167.65 36,000.00 16,167.65 38,500.00 (13,667.65) -35.5% 6315692 CM -R&M -Irrigation System 2,453.12 1,250.00 1,203.12 35,352.18 21,800.00 13,552.18 23,300.00 (12,052.18) -51.7% 6315696 CM -R&M -Pumps - 500.00 (500.00) 12,276.52 10,500.00 1,776.52 10,500.00 (1,776.52) -16.9% 6315815 CM -R&M -Trees -Pruning Etc 16,000.00 - 16,000.00 33,630.00 14,050.00 19,580.00 14,050.00 (19,580.00) -139.4% Total -CM-Repair & Maintenance 269243.23 99643.00 169600.23 1859533.88 1449223.00 419310.88 153,616.00 (31,917.88) -20.8% 6317836 Utilities -Natural Gas/LPG 25.77 15.00 10.77 262.81 165.00 97.81 180.00 (82.81) 0.0% 6317840 Telephones (10,511.37) 850.00 (11,361.37) 6,291.09 1 9,350.00 (3,058.91) 10,200.00 3,908.91 38.3% Total -CM -UTILITIES (10,485.60) 865.00 (11,350.60) 6,553.90 99515.00 (29961.10) 10,380.00 3,826.10 36.9% 63-CM-OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3% 6319100 Contract Svcs-Soil/Tissue Test - 1,500.00 (1,500.00) 360.00 4,500.00 (4,140.00) 4,500.00 4,140.00 92.0% 6319102 Contract Svcs -Trash Removal - 524.00 (524.00) - 5,764.00 (5,764.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions - - - 2,372.93 580.00 1,792.93 680.00 (1,692.93) -249.0% 6319170 Employee Education 150.00 50.00 100.00 500.00 3,850.00 (3,350.00) 3,900.00 3,400.00 87.2% 6319197 Equipment Rental 1,327.38 200.00 1,127.38 1,327.38 3,300.00 (1,972.62) 3,400.00 2,072.62 61.0% 6319206 Licenses & Permits 2,528.00 - 2,528.00 3,228.00 4,300.00 (1,072.00) 4,300.00 1,072.00 24.9% 6319490 Miscellaneous 115.59 100.00 15.59 1,642.61 1,100.00 542.61 1,200.00 (442.61) -36.9% 6319718 Safety Equipment & Training - 100.00 (100.00) 673.34 3,750.00 (3,076.66) 3,850.00 3,176.66 82.5% 6319822 Uniforms 856.13 1,210.00 (353.87) 9,698.76 13,310.00 (3,611.24) 14,520.00 4,821.24 33.2% Total -CM -OTHER EXPENSES 59377.10 49084.00 19293.10 249203.02 449854.00 (20v65O.98) 479438.00 239234.98 48.98% SilverRock Resort Course Maintenance Expense Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632-CM-CONTRACT SERVICES 6321880 Contract Labor 25,075.68 12,500.00 12,575.68 309,438.48 137,500.00 171,938.48 150,000.00 (159,438.48) -106.3% Total Contract Service 259075.68 129500.00 129575.68 3099438.48 1379500.00 171,938.48 150,000.00 (159,438.48) -106.3% Total -COURSE MAINTENANCE 166,444.97 1372477.00 28,967.97 1,969,300.45 1,853,228.00 116,072.45 2,005,606.00 36,305.55 1.8% Silverrock Resort Course Maintenance Water & Energy May 2024 Month to Date Year to Date Annual Budget May 2024 Final Budget Variance Final 1 Budget Variance Annual Budget Unemcumb. %Budget 633-CM-WATER & ENERGY 6337834 Utilities -Electricity -Pumping 25,788.53 13,500.00 12,288.53 219,928.91 152,840.00 67,088.91 144,810.00 (75,118.91) -51.9% 6337842 Utilities -Water 8,788.66 13,250.00 (4,461.34) 91,678.19 106,045.00 (14,366.81) 115,484.00 23,805.81 20.6% Total -CM -WATER & ENERGY 34,577.19 26,750.00 7,827.19 311,607.10 258,885.00 52,722.10 260,294.00 (51,313.10) -19.7% II SilverRock Resort Outside Services Expense Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Annual Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance -Group 2,933.54 774.00 2,159.54 7,508.60 8,514.00 (1,005.40) 9,288.00 1,779.40 19.2% 6411325 Insurance -Workers Comp 1,640.00 1,643.00 (3.00) 20,751.01 20,567.00 184.01 21,662.00 910.99 4.2% 6411800 Taxes -Employer Payroll 965.49 2,515.00 (1,549.51) 24,831.61 31,478.00 (6,646.39) 33,156.00 8,324.39 25.1% 6411880 Wages -Hourly 23,690.04 20,200.00 3,490.04 223,681.46 252,827.00 (29,145.54) 266,317.00 42,635.54 16.0% 6411882 Wages -Overtime 3,082.30 - 3,082.30 22,744.36 - 22,744.36 - (22,744.36) 0.0% Total-CBR-SALARIES & BENEFITS 329311.37 25,132.00 79179.37 2999517.04 3139386.00 (139868.96) 330,423.00 30,905.96 9.4% 641-CBR-SUPPLIES & MATERIALS 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 & MATERIALS 64'1-CBR-REPAIRS & MAINTENANCE 6415690 CBR-R&M-Equipment 6415695 CBR-R&M-Cart Maintenance & Repai Total-CBR-REPAIRS & MAINTENANCE 641-CBR-OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 6419220 Freight/Delivery 6419490 Miscellaneous 6419820 Uniforms Total-CBR-OTHER EXPENSES TOTAL-CARTS,BAGROOM & RANGE 643-CS-SALARIES & BENEFITS - 50.00 (50.00) 147.73 500.00 (352.27) - 50.00 (50.00) - 70.00 (70.00) 480.00 250.00 230.00 8,260.96 2,500.00 5,760.96 89888.69 39420.00 59468.69 2,431.86 1,800.00 631.86 5,593.65 6,250.00 (656.35) 14,681.25 10,000.00 4,681.25 86.05 475.00 (388.95) - 350.00 (350.00) 3,516.34 2,110.00 1,406.34 30,649.00 27,500.00 3,149.00 56,958.15 489485.00 89473.15 1,850.00 6,750.00 1,156.35 10,000.00 (4,681.25) 525.00 438.95 420.00 420.00 2,182.00 (1,334.34) 30.000.00 (649.00) 51.727.00 (4.649.29) 0.0% 17.1% 0.0% -46.8% 83.6% 100.0% -61.2% -2.2% -9.0% 1,240.00 300.00 940.00 32,475.06 3,300.00 29,175.06 3,600.00 (28,875.06) -802.1% 1,216.00 1,503.00 (287.00) 17,031.14 16,533.00 498.14 18,036.00 1,004.86 5.6% 29456.00 19803.00 653.00 499506.20 199833.00 299673.20 21,636.00 (27,870.20) -128.8% 888.25 800.00 88.25 6,029.68 8,800.00 (2,770.32) 9,600.00 3,570.32 37.2% - - - - 450.00 (450.00) 450.00 450.00 100.0% 419.91 600.00 (180.09) 2,341.09 6,600.00 (4,258.91) 7,200.00 4,858.91 67.5% 1,939.25 1,500.00 439.25 5,271.78 5,000.00 271.78 5,200.00 (71.78) -1.4% 39247.41 29900.00 347.41 139642.55 209850.00 (79207.45) 22,450.00 8,807.45 39.2% 46,903.47 339255.00 347.41 4199623.94 4029554.00 17,069.94 4269236.00 79193.92 1.7% 6431325 Insurance -Workers Comp 425.00 429.00 (4.00) 7,491.46 7,337.00 154.46 6431800 Taxes -Employer Payroll 1,389.25 514.00 875.25 11,804.57 8,797.00 3,007.57 6431880 Wages -Hourly 9,778.24 5,270.00 4,508.24 92,712.22 90,204.00 2,508.22 6431882 Wages -Overtime - - - - - - Total -CS -SALARIES & BENEFITS 11,592.49 69213.00 59379.49 1129008.25 1069338.00 59670.25 643-CS-OTHER EXPENSES 6433742 Supplies Expendable 6439490 Miscellaneous 6439718 Safety Equipment & Training 6439820 Uniforms Total -CS -OTHER EXPENSES Total -COURSE SERVICES TOTAL OUTSIDE SERVICES 7,766.00 274.54 3.5% 9,308.00 (2,496.57) -26.8% 95,471.00 2,758.78 2.9% - - 0.0% 112,545.00 536.75 0.5% - 75.00 (75.00) 1,265.39 975.00 290.39 1,050.00 (215.39) -20.5% 74.64 - 74.64 107.24 200.00 (92.76) 200.00 92.76 46.4% - 50.00 (50.00) 140.00 550.00 (410.00) 600.00 460.00 76.7% - 75.00 (75.00) 1 1,671.37 2,050.00 (378.63) 1 2,125.00 453.63 21.3% 74.64 200.00 (125.36) 39184.00 39775.00 (591.00) 39975.00 791.00 19.9% 119667.13 69413.00 59254.13 1159192.25 1109113.00 59079.25 1169520.00 19327.75 1.1 % 58,570.60 39,668.00 18,902.60 1 534,816.19 5121667.00 22,149.19 1 542,756.00 7,730.67 1.4% 5 SilverRock Resort Clubhouse Expense Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Annual Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65-CH-SUPPLIES & MATERIALS 6503742 Supplies -Expendable 400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3% Total -CH -SUPPLIES & MATERIALS 400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3% 65-CH-UTILITIES 6507836 Utilities -Natural Gas 1,132.51 1,000.00 132.51 10,237.86 11,000.00 (762.14) 12,000.00 1,762.14 14.7% 6507840 Utilities -Telephone 1,144.39 1,750.00 (605.61) 16,223.75 19,250.00 (3,026.25) 21,000.00 4,776.25 22.7% 6507842 Utilities -Water 581.20 321.00 260.20 6,376.89 3,531.00 2,845.89 3,852.00 (2,524.89) -65.5% 6507844 Utilities -Cable 415.07 380.00 35.07 4,815.27 4,180.00 635.27 4,560.00 (255.27) -5.6% Total -CH -UTILITIES 3,273.17 3,451.00 (177.83) 37,653.77 37,961.00 (307.23) 41,412.00 3,758.23 9.1 % 65-CH-OTHER EXPENSES 6509091 Contract Services -Cleaning 400.00 2,850.00 (2,450.00) 27,090.97 31,350.00 (4,259.03) 34,200.00 7,109.03 20.8% 6509099 Contract Services -Security 7,093.40 6,800.00 293.40 81,856.20 74,800.00 7,056.20 81,600.00 (256.20) -0.3% 6509215 Flowers & Decorations - - - - 1,500.00 (1,500.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) 140.00 1,100.00 (960.00) 1,200.00 1,060.00 88.3% Total -CH -OTHER EXPENSES 7,493.40 9,750.00 (2,256.60) 109,087.17 108,750.00 337.17 118,900.00 9,812.83 8.3% 65-CH-REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 440.76 300.00 140.76 5,924.37 3,300.00 2,624.37 3,600.00 (2,324.37) -64.6% 6515686 CH -R&M -Restaurant Repairs 225.00 700.00 (475.00) 3,762.00 7,700.00 (3,938.00) 8,400.00 4,638.00 55.2% 6515690 CH -R&M -Equipment Repair 509.07 700.00 (190.93) 2,835.35 7,700.00 (4,864.65) 8,400.00 5,564.65 66.2% Total -CH -REPAIRS & MAINTENANCE 1,174.83 12,341.40 1,700.00 15,301.00 (525.17) (2,959.60) 12,521.72 163,662.66 18,700.00 169,811.00 (6,178.28) (6,148.34) 20,400.00 185,512.00 7,878.28 15,756.56 38.6% 8.5% Total CLUBHOUSE SilverRock Resort Marketing Expense Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Annual Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 66-MKT-SALARIES & BENEFITS 6601320Insurance-Group 415.23 387.00 28.23 2,351.00 2,322.00 29.00 2,709.00 358.00 13.2% 6601325 Insurance -Workers Comp 100.00 102.00 (2.00) 902.00 1,122.00 (220.00) 1,220.00 318.00 26.1% 6601720 Salaries 1,250.00 1,250.00 - 15,000.00 13,750.00 1,250.00 15,000.00 - 0.0% 6601800 Tax -Employer Payroll 122.00 122.00 - 1,564.00 1,342.00 222.00 1,463.00 (101.00) -6.9% Total -MKT -SALARIES & BENEFITS 1,887.23 - 1,861.00 100.00 26.23 (100.00) 19,817.00 544.83 18,536.00 1,100.00 1,281.00 (555.17) 20,392.00 1,200.00 575.00 655.17 2.8% 54.6% 66-MKT-SUPPLIES & MATERIALS 6603762 Supplies -Office 6603768 Supplies -Printing & Stationery 2,843.96 125.00 2,718.96 9,113.63 4,300.00 4,813.63 4,425.00 (4,688.63) -106.0% Total -MKT -SUPPLIES & MARKETING 2,843.96 225.00 2,618.96 9,658.46 5,400.00 4,258.46 5,625.00 (4,033.46) -71.7% 66-MKT-UTILITIES 6607840 Utilities -Telephone 258.49 100.00 158.49 2,151.44 1,100.00 1,051.44 1,200.00 (951.44) -79.3% Total -MKT -UTILITIES 258.49 100.00 158.49 2,151.44 1,100.00 1,051.44 1,200.00 (951.44) -79.3% 66-MKT-OTHER EXPENSES 6609010 Advertising 6,703.99 8,741.00 (2,037.01) 87,793.23 125,216.00 (37,422.77) 129,762.00 41,968.77 32.3% 6609040 Business Meals - 25.00 (25.00) 74.33 275.00 (200.67) 300.00 225.67 75.2% 6609080 Collateral Material - 1,000.00 (1,000.00) 12,572.82 4,500.00 8,072.82 5,500.00 (7,072.82) -128.6% 6609102 Contract Services -Web Page - 150.00 (150.00) - 1,650.00 (1,650.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions - - - - 735.00 (735.00) 350.00 350.00 100.0% 6609620 Postage - 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0% 6609490 Miscellaneous - 50.00 (50.00) - 550.00 (550.00) 700.00 700.00 100.0% 6609630 Promotion - - - 142.73 1,000.00 (857.27) 2,250.00 2,107.27 93.7% 6609633 Promotion-Cummunity - 75.00 (75.00) 625.00 2,175.00 (1,550.00) 1,000.00 375.00 37.5% 6609634 Promotion-Media/Vendor - 50.00 (50.00) 1,040.40 650.00 390.40 735.00 (305.40) -41.6% 6609820 Uniforms - - - 230.63 600.00 (369.37) 600.00 369.37 61.6% Total -MKT -OTHER EXPENSES 6J03.99 109141.00 (39437.01) 1029479.14 1379701.00 (359221.86) 1439597.00 419117.86 28.6% TOTAL MARKETING 11,693.67 12,327.00 (633.33) 134,106.04 162,737.00 (28,630.96) 170,814.00 36,707.96 21.5% 7 SilverRock Resort General and Administrative Expense Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67-G&A-SALARIES & BENEFITS 6701320 Insurance -Group 5,138.43 3,117.00 2,021.43 47,882.38 34,287.00 13,595.38 37,404.00 (10,478.38) -28.0% 6701325 Insurance -Workers Comp 1,950.00 1,951.00 (1.00) 21,193.84 22,302.00 (1,108.16) 24,251.00 3,057.16 12.6% 6701720 Salaries 17,726.06 20,141.00 (2,414.94) 207,798.69 221,551.00 (13,752.31) 266,243.00 58,444.31 22.0% 6701800 Taxes -Employer Payroll 1,785.06 2,338.00 (552.94) 26,776.98 26,729.00 47.98 29,069.00 2,292.02 7.9% 6701880 Wages -Hourly 5,952.50 3,840.00 2,112.50 75,171.40 52,608.00 22,563.40 31,900.00 (43,271.40) -135.6% 6701882 Wages -Overtime - - - 76.66 - 76.66 - - Total-G&A-SALAR/ES & BENEFITS 32,552.05 57.06 31,387.00 500.00 1,165.05 (442.94) 378,899.95 2,403.77 357,477.00 5,500.00 21,422.95 (3,096.23) 388,867.00 6,300.00 9,967.05 3,896.23 2.6% 61.8% 67-G&A-SUPPLIES & MATERIALS 6703740 Supplies -Computer 6703762 Supplies -Office 44.17 105.00 (60.83) 740.85 1,155.00 (414.15) 1,260.00 519.15 41.2% 6703768 Supplies -Printing & Stationery - 400.00 (400.00) 1,947.87 2,900.00 (952.13) 3,300.00 1,352.13 41.0% Total-G&A-SUPPLIES & MATERIALS 101.23 14.12 1,005.00 100.00 (903.77) (85.88) 5,092.49 179.90 9,555.00 1,800.00 (4,462.51) (1,620.10) 10,860.00 1,900.00 5,767.51 1,720.10 53.1 % 90.5% 67-G&A-REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment Total-G&A-REPAIRS & MAINTENANCE 14.12 100.00 (85.88) 179.90 1,800.00 (1,620.10) 1,900.00 1,720.10 90.5% 67-G&A-0THER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 8.3% 6709150 Dues & Subscriptions 200.00 50.00 150.00 682.05 950.00 (267.95) 1,550.00 867.95 56.0% 6709180 Employee Recruiting/Relocation 35.00 - 35.00 2,120.33 1,200.00 920.33 1,200.00 (920.33) -76.7% 6709197 Equipment Rental 663.43 550.00 113.43 9,058.07 6,050.00 3,008.07 6,600.00 (2,458.07) -37.2% 6709202 Fees -Bank 45.75 90.00 (44.25) 631.20 990.00 (358.80) 1,080.00 448.80 41.6% 6709208 Fees -Payroll Processing 1,717.28 1,000.00 717.28 19,044.40 11,000.00 8,044.40 12,000.00 (7,044.40) -58.7% 6709220 Freight/Delivery - 50.00 (50.00) - 550.00 (550.00) 600.00 600.00 100.0% 6709490 Miscellaneous - 100.00 (100.00) 8,138.89 5,900.00 2,238.89 6,000.00 (2,138.89) -35.6% 6709620 Postage/Mail Services 164.59 75.00 89.59 1,360.41 825.00 535.41 900.00 (460.41) -51.2% 6709625 Expense Professional Fees 669.00 1,500.00 (831.00) 15,181.89 26,500.00 (11,318.11) 28,000.00 12,818.11 45.8% 6709636 Promotion/Entertainment - 100.00 (100.00) 94.61 1,100.00 (1,005.39) 1,200.00 1,105.39 92.1% 6709722 Seminars & Training 250.00 200.00 50.00 1,803.78 3,200.00 (1,396.22) 3,400.00 1,596.22 46.9% 6709810 Travel - 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms - 75.00 (75.00) 1,865.14 975.00 890.14 1,050.00 (815.14) -77.6% Total-G&A-OTHER EXPENSES 4,245.05 36,912.45 4,790.00 37,282.00 (544.95) (369.55) 65,480.77 449,653.11 65,640.00 434,472.00 (159.23) 15,181.11 70,680.00 472,307.00 5,199.23 22,653.89 7.4% 4.8% Total -GENERAL & ADMINISTRATIVE 0 • Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement May 2024 Month to Date Year to Date Annual Budget May 2024 Annual 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 140,344.00 (67,088.37) 154,344.00 81,088.37 52.5% 6800193 Equipment Leases -Maintenance 18,310.28 18,150.00 160.28 201,384.15 199,650.00 1,734.15 217,800.00 16,415.85 7.5% 6800196 Equipment Leases-GPS 4,718.00 2,750.00 1,968.00 37,190.00 30,250.00 6,940.00 33,000.00 (4,190.00) -12.7% 6800197 Equipment Leases -Others 1,221.87 1,950.00 (728.13) 12,227.59 18,250.00 (6,022.41) 20,200.00 7,972.41 39.5% Total -LEASES 24,250.15 36,850.00 (12,599.85) 324,057.37 388,494.00 (64,436.63) 425,344.00 101,286.63 23.8% 69-M/SC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 119,812.00 119,812.00 - 130,704.00 10,892.00 8.3% 6900210 FF&E Reserve 8,082.68 7,086.00 996.68 84,360.19 79,445.00 4,915.19 82,217.00 (2,143.19) -2.6% 6900323 Insurance -Commercial 6,572.74 8,917.00 (2,344.26) 74,304.90 98,087.00 (23,782.10) 107,000.00 32,695.10 30.6% 6900800 Personal Property Taxes - - - 15,268.68 11,800.00 3,468.68 11,800.00 (3,468.68) -29.4% Total-M/SC OTHER EXPENSES 25,547.42 26,895.00 (1,347.58)l 293,745.77 309,144.00 (15,398.23) 331,721.00 37,975.23 11.4% 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 Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf 9 7 16 16 4 4 12 3 10 7 11 9 26 14 7 31 55 4 6 38 0 24 25 66 98 4 6 13 14 6 13 7 4 4 16 14 10 17 22 21 6 33 38 34 41 59 12 47 27 72 60 81 113 118 158 Ll 10