Loading...
12 June 2024 SilverRock Resort - Monthly Financial StatementLVCRP\OCK 0 R E S O R T Monthly Financial Statements July 01, 2023 - June 30, 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 8t Administrative Expense Statement 8 Operating Leases 8t Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement June 2024 Month to Date Year to Date Annual Budget G/L # Series Account Description Income June 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. % Bdgt 400000 Golf Green Fee Revenue 159,555.00 138,575.00 20,980.00 15.1% 4,377,136.47 4,110,848.00 266,288.47 4,110,847.00 (266,289.47) 106% 401000 Miscellaneous Golf Revenue 7,432.00 5,145.00 2,287.00 44.5% 191,609.61 156,180.00 35,429.61 156,180.00 (35,429.61) 123% 410000 Revenue -Golf Shop 12,374.20 11,271.00 1,103.20 9.8% 238,124.87 245,625.00 (7,500.13) 245,623.00 7,498.13 97% 420000 Food & Beverage Revenue 35,525.99 33,925.00 1,600.99 4.7/ 757,848.89 710,100.00 47,748.89 710,099.00 (47,749.89) 107% Total Income 214,887.19 188,916.00 25,971.19 13.75% 5,564,719.84 5,222,753.00 341,966.84 5,222,749.00 (341,970.84) 107% Cost of Goods Sold 510000 COS -Golf Shop 8,971.77 6,307.00 2,664.77 -42.3% 136,950.60 137,477.00 526.40 137,475.00 524.40 100% 520000 COS -Food & Beverage 12,132.77 12,265.00 (132.23) 1.1/ 280,987.48 218,834.00 (62,153.48) 218,834.00 (62,153.48) 128% Total COS 21,104.54 18,572.00 2,532.54 -13.6% 417,938.08 356,311.00 (61,627.08) 356,309.00 (61,629.08) 117% Gross Profit 193,782.65 170,344.00 23,438.65 13.8/ 5,146,781.76 4,866,442.00 280,339.76 4,866,440.00 (280,341.76) 106% Expenses 610000 Golf Pro Shop 22,988.90 20,948.00 2,040.90 -9.7% 268,269.97 259,446.00 8,823.97 259,447.00 (8,822.97) 103% 630000 Course Maintenance 128,707.24 152,382.00 (23,674.76) 15.5% 2,091,987.69 2,005,610.00 86,377.69 2,005,608.00 (86,379.69) 104% 633000 Maintenance Water & Energy 33,620.93 23,539.00 10,081.93 -42.8% 345,228.03 282,424.00 62,804.03 282,424.00 (62,804.03) 122% 640000 Outside Services 37,643.06 30,099.00 7,544.06 -25.1% 572,459.25 542,766.00 29,693.25 542,757.00 (29,702.25) 105% 650000 Clubhouse 13,702.69 15,701.00 (1,998.31) 12.7% 177,365.35 185,512.00 (8,146.65) 185,512.00 8,146.65 96% 660000 Marketing 3,307.91 8,082.00 (4,774.09) 59.1% 137,313.95 170,819.00 (33,505.05) 170,814.00 33,500.05 80% 670000 General & Administrative 36,426.89 37,832.00 (1,405.11) 3.7% 487,100.69 472,304.00 14,796.69 472,307.00 (14,793.69) 103% 680000 Leases 24,250.15 36,850.00 (12,599.85) 34.2% 348,307.52 425,344.00 (77,036.48) 425,344.00 77,036.48 82% 690000 Miscellaneous Other Expense 18,307.91 34,381.00 (16,073.09) 46.7% 312,053.68 343,525.00 (31,471.32) 343,521.00 31,467.32 91% 620000 Food & Beverage Expenses 43,468.77 33,043.00 10,425.77 -31.6% 587,523.50 491,698.00 95,825.50 491,697.00 (95,826.50) 91% Total Expenses 362,424.45 392,857.00 (30,432.55) 7.7/ 5,327,609.63 5,179,448.00 (148,161.63) 5,179,431.00 (52,352.13) 103% Net Income (168,641.80) (222,513.00) 53,871.20 35.3% (180,827.87) (313,006.00) 132,178.13 (312,991.00) (227,989.63) 400000 Rounds of Golf Played Paid Rounds Played 1,918 2,300 (382) -16.6% 42,664 44,125 (1,461) 41,996 (668) 102% Ave $ Per Paid Round Green Fee 83.19 60.25 22.94 38.1% 102.60 93.16 9.43 97.89 (4.71) 105% Ave $ Per Paid Round Merchandise 6.45 4.90 1.55 31.7% 5.58 5.57 0.01 5.85 0.27 95% Ave $ Per Paid Miscellaneous 3.87 2.24 1.64 73.2% 4.49 3.54 0.95 3.72 (0.77) 121% SilverRock Resort Statement of Fees - Revenue June 2024 Month to Date Year to Date Annual Budget June 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue-Fees 159,555.00 138,575.00 20,980.00 4,377,136.47 4,110,848.00 266,288.47 4,110,847.00 (266,289.47) -6.5% 4010000 Rider Fee 1,685.00 245.00 1,440.00 24,390.00 17,480.00 6,910.00 17,480.00 (6,910.00) -39.5% 4040000 Club Rental 2,095.00 1,225.00 870.00 46,753.11 29,800.00 16,953.11 29,800.00 (16,953.11) -56.9% 4050000 Driving Range 3,405.00 3,675.00 (270.00) 108,942.00 97,350.00 11,592.00 97,350.00 (11,592.00) -11.9% 4060000 Handicap Fees 247.00 - 247.00 2,852.00 1,550.00 1,302.00 1,550.00 (1,302.00) -84.0% 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 79432.00 1669987.00 59145.00 1439720.00 29287.00 239267.00 1919609.61 495689746.08 1569180.00 492679028.00 359429.61 3019718.08 1569180.00 492679027.00 (359429.61) (3019719.08) -22.7% -7.1% Total Revenue Fees Total Income 1669987.00 1439720.00 239267.00 495689746.08 492679028.00 3019718.08 492679027.00 (3019719.08) _7.1% 3 SilverRock Resort Golf Shop Income Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 21.25 - 21.25 4,058.65 - 4,058.65 0 0 0% 4100110 Sales Hard Goods 7,289.92 2,818.00 4,471.92 95,662.55 61,407.00 34,255.55 61,406.00 (34,256.55) -55.8% 4100112 Sales -Soft Goods 5,063.03 8,453.00 (3,389.97) 145,405.22 184,218.00 (38,812.78) 184,217.00 38,811.78 21.1% 5100639 GS-Discounts-Mdse - - - (7,001.55) - (7,001.55) - 7,001.55 0.0% Total Revenue Golf Shop 12,374.20 11,271.00 1,103.20 238,124.87 245,625.00 (498.58) 245,623.00 4,555.23 1.9% COS 5100150 COS-GS-Hard Goods 6,118.69 1,634.00 4,484.69 53,964.63 35,617.00 18,347.63 35,615.00 (18,349.63) -51.5% 5100151 COS-GS-Soft Goods 3,025.52 4,902.00 (1,876.48) 81,507.32 106,847.00 (25,339.68) 106,846.00 25,338.68 23.7% 5100152 COS-GS-Purchase Disc (223.93) (327.00) 103.07 (2,353.07) (7,124.00) 4,770.93 (7,123.00) (4,769.93) 0.0% 5100220 COS-GS-Freight Merch 51.49 98.00 (46.51) 3,831.72 2,137.00 1,694.72 2,137.00 (1,694.72) -79.3% Cost of Sales - Golf Shop 8,971.77 6,307.00 2,664.77 136,950.60 137,477.00 (526.40) 137,475.00 524.40 0.4% Gross Profit 3,402.43 4,964.00 (1,561.57) 101,174.27 108,148.00 27.82 108,148.00 4,030.83 3.7% COS % 72.5% 56.0% -16.5% 57.5% 56.0% -1.5% 53.1% 11.5% 21.7% Expense 61-PS-SALARIES & BENEFITS 6101320 Insurance Group 368.29 774.00 (405.71) 5,291.05 9,288.00 (3,996.95) 9,288.00 3,996.95 43.0% 6101325 Insurance-Workers Comp 1,310.00 1,315.00 (5.00) 15,426.96 15,959.00 (532.04) 15,959.00 532.04 3.3% 6101720 Salaries 6,384.00 6,436.00 (52.00) 77,766.54 77,232.00 534.54 77,250.00 (516.54) -0.7% 6101800 Taxes-Employer Payroll 1,521.18 1,577.00 (55.82) 20,861.29 19,130.00 1,731.29 19,129.00 (1,732.29) -9.1% 6101880 Wages-Hourly 12,976.70 9,736.00 3,240.70 137,906.82 118,962.00 18,944.82 118,952.00 (18,954.82) -15.9% 6101882 Wages-Overtime 76.24 - 76.24 1,583.02 - 1,583.02 - (1,583.02) 0.0% Total -PS-SALARIES & BENEFITS 22,636.41 19,838.00 2,798.41 258,835.68 240,571.00 18,264.68 240,578.00 (18,257.68) -7.6% 61-PS OTHER EXPENSES 6103762 Supplies-Office 141.36 250.00 (108.64) 1,733.10 3,000.00 (1,266.90) 3,000.00 1,266.90 42.2% 6109150 Dues and Subscriptions _ _ - 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 129.88 500.00 (370.12) 2,278.65 6,000.00 (3,721.35) 6,000.00 3,721.35 62.0% 6109500 ProShop Over/Under _ _ _ (28.40) (28.40) - 28.40 0.0% 6109722 Seminars/Training - 35.00 (35.00) 598.99 3,690.00 (3,091.01) 3,690.00 3,091.01 83.8% 6109810 Travel - Merchandise - 15.00 (15.00) - 90.00 (90.00) 90.00 90.00 100.0% 6109820 Uniforms - 200.00 (200.00) 2,217.69 2,400.00 (182.31) 2,400.00 182.31 7.6% 6117840 Telephones 81.25 110.00 (28.75) 1,570.26 1,320.00 250.26 1,320.00 (250.26) -19.0% Total - Other Expenses 352.49 1,110.00 (757.51) 9,434.29 18,875.00 (9,440.71) 18,875.00 9,440.71 50.0% Total Expenses-Golf Shop 22,988.90 20,948.00 2,040.90 268,269.97 259,446.00 8,823.97 259,453.00 (8,816.97) -3.4% Net Income (19,586.47) (15,984.00) (3,602.47) (167,095.70) (151,298.00) (8,796.15) (151,305.00) 12,847.80 -8.5%MWJ 3 SilverRock Resort Course Maintenance Expense Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 6,732.57 9,696.00 (2,963.43) 91,211.19 107,838.00 (16,626.81) 107,838.00 16,626.81 15.4% 6311325 Insurance -Workers Comp 3,560.00 3,567.00 (7.00) 41,277.06 42,860.00 (1,582.94) 42,860.00 1,582.94 3.7% 6311720 Salaries 16,152.00 16,716.00 (564.00) 196,911.96 200,568.00 (3,656.04) 200,000.00 3,088.04 1.5% 6311800 Taxes -Employer Payroll 4,033.21 7,098.00 (3,064.79) 67,562.68 86,378.00 (18,815.32) 86,375.00 18,812.32 21.8% 6311880 Wages -Hourly 58,191.42 56,088.00 2,103.42 608,217.52 651,737.00 (43,519.48) 652,304.00 44,086.48 6.8% 6311882 Wages -Overtime 1,164.01 - 1,164.01 31,637.34 33,620.00 (1,982.66) 33,620.00 1,982.66 5.9% Total -CM -SALARIES & BENEFITS 899833.21 939165.00 (39331.79) 190369817.75 191239001.00 (869183.25) 191229997.00 86,179.25 7.7% 63 -CM -SUPPLIES & MATERIALS - 5,000.00 (5,000.00) 45,435.19 46,500.00 (1,064.81) 46,500.00 1,064.81 2.3% 6313745 Chemicals 6313744 Fertilizer 3,896.82 8,000.00 (4,103.18) 122,661.36 111,800.00 10,861.36 111,800.00 (10,861.36) -9.7% 6313746 Flowers/Plants - - - 9,771.12 7,000.00 2,771.12 7,000.00 (2,771.12) -39.6% 6313748 Fuel -Gasoline 6,133.12 5,700.00 433.12 75,130.83 68,400.00 6,730.83 68,400.00 (6,730.83) -9.8% 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 244.20 100.00 144.20 6,879.57 5,950.00 929.57 5,950.00 (929.57) -15.6% 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 7,025.00 (368.31) 7,025.00 368.31 5.2% 6313782 Sod - 4,500.00 (4,500.00) 7,393.10 15,500.00 (8,106.90) 15,500.00 8,106.90 52.3% 6313784 Topdressing - 10,000.00 (10,000.00) 9,939.65 19,000.00 (9,060.35) 19,000.00 9,060.35 47.7% Total--CM-SUPPLIES & MATERIALS 10,274.14 33,875.00 (23,600.86) 500,840.77 5219175.00 (20,334.23) 521,175.00 20,334.23 3.9% 63 -CM -REPAIRS & MAINTENANCE 4,346.00 5,143.00 (797.00) 54,438.00 61,716.00 (7,278.00) 61,716.00 7,278.00 11.8% 6315095 CM -R&M -Contract Lake Maint 6315685 CM-R&M-Bldngs & Othr Structures 129.50 250.00 (120.50) 2,145.03 5,550.00 (3,404.97) 5,550.00 3,404.97 61.4% 6315690 CM -R&M -Equipment 2,818.43 2,500.00 318.43 54,986.08 38,500.00 16,486.08 38,500.00 (16,486.08) -42.8% 6315692 CM -R&M -Irrigation System 4,564.07 1,500.00 3,064.07 39,916.25 23,300.00 16,616.25 23,300.00 (16,616.25) -71.3% 6315696 CM -R&M -Pumps - - - 12,276.52 10,500.00 1,776.52 10,500.00 (1,776.52) -16.9% 6315815 CM -R&M -Trees -Pruning Etc - - - 33,630.00 14,050.00 19,580.00 14,050.00 (19,580.00) -139.4% Total -CM-Repair & Maintenance 119858.00 99393.00 29465.00 1979391.88 1539616.00 439775.88 153,616.00 (43,775.88) -28.5% 6317836 Utilities -Natural Gas/LPG 24.93 15.00 9.93 287.74 180.00 107.74 180.00 (107.74) 0.0% 6317840 Telephones 664.21 850.00 (185.79) 6,955.30 10,200.00 (3,244.70) 10,200.00 3,244.70 31.8% Total -CM -UTILITIES 689.14 865.00 (175.86) 79243.04 109380.00 (39136.96) 10,380.00 3,136.96 30.2% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0% 6319100 Contract Svcs-Soil/Tissue Test - - - 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) - 6,288.00 (6,288.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions 375.00 100.00 275.00 2,747.93 680.00 2,067.93 680.00 (2,067.93) -304.1% 6319170 Employee Education - 50.00 (50.00) 500.00 3,900.00 (3,400.00) 3,900.00 3,400.00 87.2% 6319197 Equipment Rental - 100.00 (100.00) 1,327.38 3,400.00 (2,072.62) 3,400.00 2,072.62 61.0% 6319206 Licenses & Permits - - - 3,228.00 4,300.00 (1,072.00) 4,300.00 1,072.00 24.9% 6319490 Miscellaneous - 100.00 (100.00) 1,642.61 1,200.00 442.61 1,200.00 (442.61) -36.9% 6319718 Safety Equipment & Training - 100.00 (100.00) 673.34 3,850.00 (3,176.66) 3,850.00 3,176.66 82.5% 6319822 Uniforms 868.47 1,210.00 (341.53) 10,567.23 14,520.00 (3,952.77) 14,520.00 3,952.77 27.2% Total -CM -OTHER EXPENSES 19643.47 29584.00 (940.53) 259846.49 479438.00 (219591.51) 479438.00 219591.51 45.52% SilverRock Resort Course Maintenance Expense Statement June 2024 E Month to Date Year to Date Annual Budget June 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 6321880 Contract Labor Total Contract Service Total -COURSE MAINTENANCE 14,409.28 14,409.28 12,500.00 129500.00 1,909.28 19909.28 323,847.76 3239847.76 150,000.00 1509000.00 173,847.76 1739847.76 150,000.00 1509000.00 2,005,606.00 (173,847.76) (173,847.76) (86,381.69) -115.9% -115.9% -4.3% 128,707.24 152,382.00 (23,674.76) 2,091,987.69 2,005,610.00 86,377.69 Silverrock Resort Course Maintenance Water & Energy June 2024 Month to Date Year to Date Annual Budget June 2024 Variance Final AnnualBudget Unemcumb. %Budget 633 -CM -WATER & ENERGY 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total -CM -WATER & ENERGY 22,336.87 11,284.06 33,620.93 14,100.00 9,439.00 23,539.00 8,236.87 1,845.06 10,081.93 242,265.78 102,962.25 345,228.03 166,940.00 115,484.00 282,424.00 75,325.78 (12,521.75) 62,804.03 144,810.00 115,484.00 260,294.00 (97,455.78) 12,521.75 (84,934.03) -67.3% 10.8% -32.6% E 5 SilverRock Resort Outside Services Expense Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance -Group 1,099.08 774.00 325.08 8,607.68 9,288.00 (680.32) 9,288.00 680.32 7.3% 6411325 Insurance -Workers Comp 1,090.00 1,097.00 (7.00) 21,841.01 21,664.00 177.01 21,662.00 (179.01) -0.8% 6411800 Taxes -Employer Payroll 1,793.49 1,680.00 113.49 26,625.10 33,158.00 (6,532.90) 33,156.00 6,530.90 19.7% 6411880 Wages -Hourly 17,501.94 13,490.00 4,011.94 241,183.40 266,317.00 (25,133.60) 266,317.00 25,133.60 9.4% 6411882 Wages -Overtime 1,952.38 - 1,952.38 24,696.74 - 24,696.74 - (24,696.74) 0.0% Total -CER -SALARIES & BENEFITS 239436.89 - 17,041.00 50.00 69395.89 (50.00) 3229953.93 2,431.86 330,427.00 1,850.00 (79473.07) 581.86 330,423.00 1,850.00 7,469.07 2.3% 0.0% 641 -CBR -SUPPLIES & MATER/ALS 6413732 Supplies -Carts 6413742 Supplies -Expendable 147.73 500.00 (352.27) 5,741.38 6,750.00 (1,008.62) 6,750.00 1,008.62 14.9% 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 - 50.00 (50.00) 86.05 525.00 (438.95) 525.00 438.95 83.6% 6413768 Supplies -Printing and Stationary - 70.00 (70.00) - 420.00 (420.00) 420.00 420.00 100.0% 6413786 Supplies -Towels 400.00 72.00 328.00 3,916.34 2,182.00 1,734.34 2,182.00 (1,734.34) -79.5% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 30,649.00 30,000.00 649.00 30,000.00 (649.00) -2.2% Total--CBR-SUPPLIES & MATER/ALS 547.73 304.02 39242.00 300.00 (29694.27) 4.02 579505.88 32,779.08 519727.00 3,600.00 59778.88 29,179.08 51,727.00 3,600.00 (5,197.02) (29,179.08) -10.0% -810.5% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 6415695 CBR -R&M -Cart Maintenance & Repai 3,604.00 1,503.00 2,101.00 20,635.14 18,036.00 2,599.14 18,036.00 (2,599.14) -14.4% Total -CBR -REPAIRS & MAINTENANCE 39908.02 1,086.50 19803.00 800.00 29105.02 286.50 53,414.22 7,116.18 219636.00 9,600.00 31,778.22 (2,483.82) 21,636.00 9,600.00 (31,778.22) 2,483.82 -146.9% 25.9% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 2,341.09 7,200.00 (4,858.91) 7,200.00 4,858.91 67.5% 6419820 Uniforms - 200.00 (200.00) 5,271.78 5,200.00 71.78 5,200.00 (71.78) -1.4% Total -CBR -OTHER EXPENSES 19086.50 28,979.14 420.00 19600.00 239686.00 429.00 (513.50) (513.50) (9.00) 149729.05 448,603.08 7,911.46 229450.00 4269240.00 7,766.00 (79720.95) 22,363.08 145.46 22,450.00 4269236.00 7,766.00 7,720.95 (219785.22) (145.46) 34.4% -5.1% -1.9% TOTAL-CARTS,BAGROOM & RANGE 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 6431800 Taxes -Employer Payroll 861.20 514.00 347.20 12,665.77 9,311.00 3,354.77 9,308.00 (3,357.77) -36.1% 6431880 Wages -Hourly 7,382.72 5,270.00 2,112.72 100,094.94 95,474.00 4,620.94 95,471.00 (4,623.94) -4.8% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 89663.92 - 69213.00 75.00 29450.92 (75.00) 1209672.17 1,265.39 1129551.00 1,050.00 89121.17 215.39 112,545.00 1,050.00 (8,127.17) (215.39) -7.2% -20.5% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 6439490 Miscellaneous - - - 107.24 200.00 (92.76) 200.00 92.76 46.4% 6439718 Safety Equipment & Training - 50.00 (50.00) 140.00 600.00 (460.00) 600.00 460.00 76.7% 6439820 Uniforms - 75.00 (75.00) 1,671.37 2,125.00 (453.63) 2,125.00 453.63 21.3% Total -CS -OTHER EXPENSES - 200.00 (200.00) 31184.00 39975.00 (791.00) 39975.00 791.00 19.9% Total -COURSE SERVICES 89663.92 6,413.00 29250.92 1239856.17 1169526.00 79330.17 1169520.00 (7,336.17) -6.3% TOTAL OUTSIDE SERVICES 37,643.06 30,099.00 7,544.06 572,459.25 542,766.00 29,693.25 542,756.00 (29,912.39) -5.5% 5 0 SilverRock Resort Clubhouse Expense Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Annual Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATERIALS 6503742 Supplies -Expendable 400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0% Total--CH-SUPPLIES & MATERIALS 400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 923.02 1,000.00 (76.98) 11,160.88 12,000.00 (839.12) 12,000.00 839.12 7.0% 6507840 Utilities -Telephone 1,237.46 1,750.00 (512.54) 17,461.21 21,000.00 (3,538.79) 21,000.00 3,538.79 16.9% 6507842 Utilities -Water 616.87 321.00 295.87 6,993.76 3,852.00 3,141.76 3,852.00 (3,141.76) -81.6% 6507844 Utilities -Cable 415.07 380.00 35.07 5,230.34 4,560.00 670.34 4,560.00 (670.34) -14.7% Total -CH -UTILITIES 3,192.42 3,451.00 (258.58) 40,846.19 41,412.00 (565.81) 41,412.00 565.81 1.4% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 560.00 2,850.00 (2,290.00) 27,650.97 34,200.00 (6,549.03) 34,200.00 6,549.03 19.1% 6509099 Contract Services -Security 7,344.20 6,800.00 544.20 89,200.40 81,600.00 7,600.40 81,600.00 (7,600.40) -9.3% 6509215 Flowers & Decorations - 400.00 (400.00) - 1,900.00 (1,900.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) 140.00 1,200.00 (1,060.00) 1,200.00 1,060.00 88.3% Total--CH-OTHER EXPENSES 7,904.20 10,150.00 (2,245.80) 116,991.37 118,900.00 (1,908.63) 118,900.00 1,908.63 1.6% 65 -CH -REPAIRS & MAINTENANCE 440.75 300.00 140.75 6,365.12 3,600.00 2,765.12 3,600.00 (2,765.12) -76.8% 6515685 CH -R&M -Building Structures 6515686 CH -R&M -Restaurant Repairs 1,609.01 700.00 909.01 5,371.01 8,400.00 (3,028.99) 8,400.00 3,028.99 36.1% 6515690 CH -R&M -Equipment Repair 156.31 700.00 (543.69) 2,991.66 8,400.00 (5,408.34) 8,400.00 5,408.34 64.4% Total -CH -REPAIRS & MAINTENANCE 2,206.07 1,700.00 506.07 14,727.79 20,400.00 (5,672.21) 20,400.00 5,672.21 27.8% Total CLUBHOUSE 13,702.69 15,701.00 (1,998.31) 177,365.35 185,512.00 (8,146.65) 185,512.00 11,344.42 6.1% 0 7 SilverRock Resort Marketing Expense Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group 415.23 387.00 28.23 2,766.23 2,709.00 57.23 2,709.00 (57.23) -2.1% 6601325 Insurance -Workers Comp 100.00 102.00 (2.00) 1,002.00 1,224.00 (222.00) 1,220.00 218.00 17.9% 6601720 Salaries 1,250.00 1,250.00 - 16,250.00 15,000.00 1,250.00 15,000.00 (1,250.00) -8.3% 6601800 Tax -Employer Payroll 122.00 122.00 - 1,586.00 1,464.00 122.00 1,463.00 (123.00) -8.4% Total -MKT -SALARIES & BENEFITS 1,887.23 138.31 1,861.00 100.00 26.23 38.31 21,604.23 683.14 20,397.00 1,200.00 1,207.23 (516.86) 20,392.00 1,200.00 (1,212.23) 516.86 -5.9% 43.1% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office 6603768 Supplies -Printing & Stationery 132.04 125.00 7.04 9,245.67 4,425.00 4,820.67 4,425.00 (4,820.67) -108.9% Total -MKT -SUPPLIES & MARKET/NG 270.35 225.00 45.35 9,928.81 5,625.00 4,303.81 5,625.00 (4,303.81) -76.5% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 235.97 100.00 135.97 2,387.41 1,200.00 1,187.41 1,200.00 (1,187.41) -99.0% Total -MKT -UTILITIES 235.97 100.00 135.97 2,387.41 1,200.00 1,187.41 1,200.00 (1,187.41) -99.0% 66 -MKT -OTHER EXPENSES 6609010 Advertising 714.99 4,546.00 (3,831.01) 88,508.22 129,762.00 (41,253.78) 129,762.00 41,253.78 31.8% 6609040 Business Meals - 25.00 (25.00) 74.33 300.00 (225.67) 300.00 225.67 75.2% 6609080 Collateral Material - 1,000.00 (1,000.00) 12,572.82 5,500.00 7,072.82 5,500.00 (7,072.82) -128.6% 6609102 Contract Services -Web Page - 150.00 (150.00) - 1,800.00 (1,800.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions - - - - 735.00 (735.00) 350.00 350.00 100.0% 6609620 Postage - - - - 350.00 (350.00) 600.00 600.00 100.0% 6609490 Miscellaneous - 50.00 (50.00) - 600.00 (600.00) 700.00 700.00 100.0% 6609630 Promotion 199.37 - 199.37 342.10 1,000.00 (657.90) 2,250.00 1,907.90 84.8% 6609633 Promotion-Cummunity - 75.00 (75.00) 625.00 2,250.00 (1,625.00) 1,000.00 375.00 37.5% 6609634 Promotion-Media/Vendor - 50.00 (50.00) 1,040.40 700.00 340.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 914.36 5,896.00 (49981.64) 103,393.50 143,597.00 (409203.50) 1439597.00 409203.50 28.0% TOTAL MARKET/NG 3,307.91 8,082.00 (4,774.09) 137,313.95 170,819.00 (33,505.05) 170,814.00 33,500.05 19.6% 7 0 SilverRock Resort General and Administrative Expense Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 5,042.05 3,117.00 1,925.05 52,924.43 37,404.00 15,520.43 37,404.00 (15,520.43) -41.5% 6701325 Insurance -Workers Comp 1,950.00 1,951.00 (1.00) 23,143.84 24,253.00 (1,109.16) 24,251.00 1,107.16 4.6% 6701720 Salaries 17,726.06 20,141.00 (2,414.94) 225,524.75 241,692.00 (16,167.25) 266,243.00 40,718.25 15.3% 6701800 Taxes -Employer Payroll 1,772.15 2,338.00 (565.85) 28,549.13 29,067.00 (517.87) 29,069.00 519.87 1.8% 6701880 Wages -Hourly 5,783.87 3,840.00 1,943.87 80,955.27 56,448.00 24,507.27 31,900.00 (49,055.27) -153.8% 6701882 Wages -Overtime - - - 76.66 - 76.66 - - Total -G&A -SALARIES & BENEFITS 32,274.13 31,387.00 887.13 411,174.08 388,864.00 22,310.08 388,867.00 (22,307.08) _5.7% 67 -G&A -SUPPLIES & MATERIALS 39.98 800.00 (760.02) 2,443.75 6,300.00 (3,856.25) 6,300.00 3,856.25 61.2% 6703740 Supplies -Computer 6703762 Supplies -Office 0.95 105.00 (104.05) 741.80 1,260.00 (518.20) 1,260.00 518.20 41.1% 6703768 Supplies -Printing & Stationery - 400.00 (400.00) 1,947.87 3,300.00 (1,352.13) 3,300.00 1,352.13 41.0% Total--G&A-SUPPLIES & MATERIALS 40.93 - 1,305.00 100.00 (1,264.07) (100.00) 5,133.42 179.90 10,860.00 1,900.00 (5,726.58) (1,720.10) 10,860.00 1,900.00 5,726.58 1,720.10 52.7% 90.5% 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment Total -G&A -REPAIRS & MAINTENANCE - 100.00 (100.00) 179.90 1,900.00 (1,720.10) 1,900.00 1,720.10 90.5% 67-G&A-0THER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 0.0% 6709150 Dues & Subscriptions 200.00 600.00 (400.00) 882.05 1,550.00 (667.95) 1,550.00 667.95 43.1% 6709180 Employee Recruiting/Relocation _ _ - 2,120.33 1,200.00 920.33 1,200.00 (920.33) -76.7% 6709197 Equipment Rental 529.73 550.00 (20.27) 9,587.80 6,600.00 2,987.80 6,600.00 (2,987.80) -45.3% 6709202 Fees -Bank 68.99 90.00 (21.01) 700.19 1,080.00 (379.81) 1,080.00 379.81 35.2% 6709208 Fees -Payroll Processing 1,206.61 1,000.00 206.61 21,271.70 12,000.00 9,271.70 12,000.00 (9,271.70) -77.3% 6709220 Freight/Delivery - 50.00 (50.00) - 600.00 (600.00) 600.00 600.00 100.0% 6709490 Miscellaneous - 100.00 (100.00) 8,138.89 6,000.00 2,138.89 6,000.00 (2,138.89) -35.6% 6709620 Postage/Mail Services - 75.00 (75.00) 1,360.41 900.00 460.41 900.00 (460.41) -51.2% 6709625 Expense Professional Fees 1,606.50 1,500.00 106.50 16,788.39 28,000.00 (11,211.61) 28,000.00 11,211.61 40.0% 6709636 Promotion/Entertainment - 100.00 (100.00) 94.61 1,200.00 (1,105.39) 1,200.00 1,105.39 92.1% 6709722 Seminars & Training - 200.00 (200.00) 1,803.78 3,400.00 (1,596.22) 3,400.00 1,596.22 46.9% 6709810 Travel - 200.00 (200.00) - 1,100.00 (1,100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms - 75.00 (75.00) 1,865.14 1,050.00 815.14 1,050.00 (815.14) _77.6% Total -G&A -OTHER EXPENSES 4,111.83 36,426.89 5,040.00 37,832.00 (928.17) (1,405.11) 70,613.29 487,100.69 70,680.00 472,304.00 (66.71) 14,796.69 70,680.00 472,307.00 66.71 (14,793.69) 0.1% -3.1% Total -GENERAL & ADMINISTRATIVE 0 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement June 2024 Month to Date Year to Date Annual Budget June 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 68 -LEASES 6800192 Equipment Leases -Carts - 14,000.00 (14,000.00) 73,255.63 154,344.00 (81,088.37) 154,344.00 81,088.37 52.5% 6800193 Equipment Leases -Maintenance 18,310.28 18,150.00 160.28 219,694.43 217,800.00 1,894.43 217,800.00 (1,894.43) -0.9% 6800196 Equipment Leases -GPS 4,718.00 2,750.00 1,968.00 41,908.00 33,000.00 8,908.00 33,000.00 (8,908.00) -27.0% 6800197 Equipment Leases -Others 1,221.87 1,950.00 (728.13) 13,449.46 20,200.00 (6,750.54) 20,200.00 6,750.54 33.4% Total -LEASES 24,250.15 36,850.00 (12,599.85) 348,307.52 425,344.00 (77,036.48) 425,344.00 77,036.48 18.1% 69-M/SC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 130,704.00 130,704.00 - 130,704.00 - 0.0% 6900210 FF&E Reserve 3,182.53 2,772.00 410.53 87,542.72 82,217.00 5,325.72 82,217.00 (5,325.72) -6.5% 6900323 Insurance -Commercial 4,233.38 8,917.00 (4,683.62) 78,538.28 107,004.00 (28,465.72) 107,000.00 28,461.72 26.6% 6900800 Personal Property Taxes - 11,800.00 (11,800.00) 15,268.68 23,600.00 (8,331.32) 11,800.00 (3,468.68) -29.4% Tota/--M/SC OTHER EXPENSES 18,307.91 34,381.00 (16,073.09) 312,053.68 343,525.00 (31,471.32) 331,721.00 19,667.32 5.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 14 6 7 16 16 4 4 4 4 12 3 17 10 7 11 9 26 38 14 7 31 55 12 47 27 4 6 38 0 24 25 66 98 4 6 13 14 6 13 7 14 4 4 16 14 10 17 22 21 6 1 33 38 34 41 59 64 12 47 27 72 60 81 113 118 158 79 10