Loading...
04 October 2023 SilverRock Resort - Monthly Financial StatementS1LVERROCK® RESORT Monthly Financial Statements July 01, 2023 - October 31, 2023 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 October 2023 Month to Date Year to Date Annual Budget October Percentage G/L # Series Account Description 2023 Final Budget Variance Difference Final Budget Variance Annual Budget Unemcumb. Bdgt Income 400000 Golf Green Fee Revenue 196,398.00 13,910.00 182,488.00 1311.9% 363,146.00 353,619.00 9,527.00 4,110,847.00 3,747,701.00 9% 401000 Miscellaneous Golf Revenue 11,090.00 800.00 10,290.00 1286.3% 19,172.00 11,950.00 7,222.00 156,180.00 137,008.00 12% 410000 Revenue -Golf Shop 11,634.70 500.00 11,134.70 2226.9% 29,083.64 19,340.00 9,743.64 245,623.00 216,539.36 12% 420000 Food & Beverage Revenue 1,500.00 1,500.00 - 0.0% 60,793.00 60,793.00 - 710,099.00 649,306.00 9% Total Income 220,622.70 16,710.00 203,912.70 1220.30% 472,194.64 445,702.00 26,492.64 5,222,749.00 4,750,554.36 9% Cost of Goods Sold 510000 COS -Golf Shop 6,989.22 280.00 6,709.22 -2396.2% 16,439.41 10,825.00 (5,614.41) 137,475.00 121,035.59 12% 520000 COS -Food & Beverage 2,335.00 2,335.00 - 0.0% 24,379.00 24,379.00 - 218,834.00 194,455.00 11% Total COS 9,324.22 2,615.00 6,709.22 -256.6% 40,818.41 35,204.00 (5,614.41) 356,309.00 315,490.59 11% Gross Profit 211,298.48 14,095.00 197,203.48 1399.1% 431,376.23 410,498.00 20,878.23 4,866,440.00 4,435,063.77 9% Expenses 610000 Golf Pro Shop 13,510.96 11,981.00 1,529.96 -12.8% 62,236.66 60,203.00 2,033.66 259,447.00 197,210.34 24% 630000 Course Maintenance 324,388.20 401,659.00 (77,270.80) 19.2% 804,446.76 816,846.00 (12,399.24) 2,005,608.00 1,201,161.24 40% 633000 Maintenance Water & Energy 28,974.04 25,410.00 3,564.04 -14.0% 129,852.10 97,630.00 32,222.10 282,424.00 152,571.90 46% 640000 Outside Services 13,535.28 23,138.00 (9,602.72) 41.5% 103,605.46 103,166.00 439.46 542,757.00 439,151.54 19% 650000 Clubhouse 12,616.08 15,801.00 (3,184.92) 20.2% 63,236.64 61,704.00 1,532.64 185,512.00 122,275.36 34% 660000 Marketing 16,056.01 19,590.00 (3,533.99) 18.0% 52,105.37 34,305.00 17,800.37 170,814.00 118,708.63 31% 670000 General & Administrative 37,381.33 39,064.00 (1,682.67) 4.3% 164,786.89 161,534.00 3,252.89 472,307.00 307,520.11 35% 680000 Leases 32,481.67 32,636.00 (154.33) 0.5% 129,852.60 130,544.00 (691.40) 425,344.00 295,491.40 31% 690000 Miscellaneous Other Expense 22,162.36 22,687.00 (524.64) 2.3% 89,939.24 98,108.00 (8,168.76) 343,521.00 253,581.76 620000 Food & Beverage Expenses 18,794.00 18,794.00 - 0.0% 110,006.00 110,006.00 - 491 697.00 381 691.00 26% Total Expenses 519,899.93 610,760.00 (90,860.07) 14.9% 1,710,067.72 1,674,046.003(6,021.72) 5,179,431.00 3,087,672.28 33% Net Income (308,601.45) (596,665.00) 288,063.55 2634.3% (1,278,691.49) (1,263,548.00) (15,143.49) (312,991.00) I 1,347,391.49 400000 1 Rounds of Golf Played ■ • ■ ■ ■ 1 Paid Rounds Played 2,126 2,400 (274) -11.4% 4,975 6,000 (1,025) 41,996 37,021 12% Ave $ Per Paid Round Green Fee 92.38 5.80 86.58 1493.9% 170.81 58.94 111.88 97.89 (72.93) 174% Ave $ Per Paid Round Merchandise 5.47 0.21 5.26 2526.8% 13.68 3.22 10.46 5.85 (7.83) 234% Ave $ Per Paid Miscellaneous 5.22 0.33 4.88 1464.9% 3.85 1.99 1.86 3.72 (0.13) 104% 1 2 SilverRock Resort Statement of Fees - Revenue October 2023 Month to Date Year to Date Annual Budget October Income 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 196,398.00 13,910.00 182,488.00 363,146.00 353,619.00 9,527.00 4,110,847.00 3,747,701.00 91.2% 4010000 Rider Fee 815.00 - 815.00 2,390.00 3,600.00 (1,210.00) 17,480.00 15,090.00 86.3% 4040000 Club Rental 4,575.00 50.00 4,525.00 6,950.00 2,600.00 4,350.00 29,800.00 22,850.00 76.7% 4050000 Driving Range 5,700.00 250.00 5,450.00 9,585.00 4,750.00 4,835.00 97,350.00 87,765.00 90.2% 4060000 Handicap Fees - - - 247.00 - 247.00 1,550.00 1,303.00 84.1% 4090000 Ball Retriever/Subcontract - 500.00 (500.00) - 1,000.00 (1,000.00) 2,500.00 2,500.00 100.0% 4091000 Golf Professional Rental Fee - - - - - - 7,500.00 7,500.00 100.0% Total Miscellaneous Revenue 11,090.00 800.00 10,290.00 19,172.00 11,950.00 7,222.00 156,180.00 137,008.00 87.7% 207,488.00 14,710.00 192,778.00 382,318.00 365,569.00 16,749.00 4,267,027.00 3,884,709.00 91.0% Total Revenue Fees Total Income 1 207,488.00 14,710.00 192,778.00 382,318.00 365,569.00 16,749.00 4,267,027.00 3,884,709.00 91.0% 2 3 SilverRock Resort Golf Shop Income Statement October 2023 Month to Date Year to Date Annual Budget October Annual Income 2023 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 371.26 - 371.26 2,350.40 - - 2,350.40 0 0 0% 4100110 Sales Hard Goods 5,659.94 375.00 5,284.94 13,399.90 14,505.00 (1,105.10) 61,406.00 48,006.10 78.2% 4100112 Sales -Soft Goods 6,946.64 125.00 6,821.64 20,334.89 4,835.00 15,499.89 184,217.00 163,882.11 89.0% 5100639 GS -Discounts -Mdse (1,343.14) - (1,343.14) (7,001.55) - (7,001.55) - 7,001.55 0.0% Total Revenue Golf Shop 11,634.70 500.00 12,477.84 29,083.64 19,340.00 16,745.19 245,623.00 211,888.21 86.3% COS 5100150 COS -GS -Hard Goods 2,684.84 73.00 2,611.84 6,497.04 2,805.00 3,692.04 35,615.00 29,117.96 81.8% 5100151 COS -GS -Soft Goods 4,085.90 218.00 3,867.90 9,632.80 8,414.00 1,218.80 106,846.00 97,213.20 91.0% 5100152 COS -GS -Purchase Disc (621.73) (15.00) (1,343.14) (725.29) (562.00) (163.29) (7,123.00) (6,397.71) 0.0% 5100220 COS -GS -Freight Merch 840.21 4.00 836.21 1,034.86 168.00 866.86 2,137.00 1,102.14 51.6% Cost of Sales - Golf Shop 6,989.22 280.00 5,972.81 16,439.41 10,825.00 5,614.41 137,475.00 121,035.59 88.0% Gross Profit 4,645.48 220.00 6,505.03 12,644.23 8,515.00 11,130.78 108,148.00 90,852.62 84.0% COS % 60.1% 56.0% -4.1% 56.5% 56.0% -0.6% 53.1% 57.1% 107.6% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 455.00 774.00 (319.00) 1,494.68 3,096.00 (1,601.32) 9,288.00 7,793.32 83.9% 6101325 Insurance -Workers Comp 600.00 671.00 (71.00) 3,251.96 3,608.00 (356.04) 15,959.00 12,707.04 79.6% 6101720 Salaries 5,769.24 6,436.00 (666.76) 25,961.58 25,744.00 217.58 77,250.00 51,288.42 66.4% 6101800 Taxes -Employer Payroll 873.39 804.00 69.39 4,144.16 4,326.00 (181.84) 19,129.00 14,984.84 78.3% 6101880 Wages -Hourly 4,338.68 1,811.00 2,527.68 25,181.40 18,614.00 6,567.40 118,952.00 93,770.60 78.8% 6101882 Wages -Overtime 94.36 - 94.36 362.98 - 362.98 - (362.98) 0.0% Total -PS-SALARIES & BENEFITS 12,130.67 10,496.00 1,634.67 60,396.76 55,388.00 5,008.76 240.578.00 180.181.24 74.9% 61 -PS OTHER EXPENSES 6103762 Supplies -Office - 250.00 (250.00) 65.94 1,000.00 (934.06) 3,000.00 2,934.06 97.8% 6109150 Dues and Subscriptions _ _ _ - - - 2,300.00 2,300.00 100.0% 6109220 Freight & Delivery - 25.00 (25.00) - 25.00 (25.00) 75.00 75.00 100.0% 6109490 Miscellaneous - 500.00 (500.00) 40.13 2,000.00 (1,959.87) 6,000.00 5,959.87 99.3% 6109722 Seminars/Training - 500.00 (500.00)- 950.00 (950.00) 3,690.00 3,690.00 100.0% 6109810 Travel - Merchandise - - - 90.00 90.00 100.0% 6109820 Uniforms 1,285.12 100.00 1,185.12 1,285.12 400.00 885.12 2,400.00 1,114.88 46.5% 6117840 Telephones 95.17 110.00 (14.83) 448.71 440.00 8.71 1,320.00 871.29 66.0% Total - Other Expenses 1,380.29 1,485.00 (104.71) 1,839.90 4,815.00 (2,975.10) 18,875.00 17,035.10 90.3% Total Expenses -Golf Shop 13,510.96 11,981.00 1,529.96 62,236.66 60,203.00 2,033.66 259,453.00 197,216.34 76.0% Net Income (8,865.48) (11,761.00) 2,895.52 (49,592.43) (51,688.00) 9,097.12 (151,305.00) (106,363.72) 70.3% 3 4 SilverRock Resort Course Maintenance Expense Statement October 2023 Month to Date Year to Date Annual Budget October 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63-CM-SALARIES & BENEFITS 6311320 Insurance-Group 8,754.68 8,922.00 (167.32) 29,621.20 30,270.00 (648.80) 107,838.00 78,216.80 72.5% 6311325 Insurance-Workers Comp 4,000.00 4,090.00 (90.00) 12,032.06 13,388.00 (1,355.94) 42,860.00 30,827.94 71.9% 6311720 Salaries 14,691.38 16,713.00 (2,021.62) 66,111.21 66,852.00 (740.79) 200,000.00 133,888.79 66.9% 6311800 Taxes-Employer Payroll 5,274.26 8,658.00 (3,383.74) 18,273.58 27,315.00 (9,041.42) 86,375.00 68,101.42 78.8% 6311880 Wages-Hourly 46,787.28 56,084.00 (9,296.72) 194,910.49 192,551.00 2,359.49 652,304.00 457,393.51 70.1% 6311882 Wages-Overtime 4,967.74 16,000.00 (11,032.26) 18,873.97 20,752.00 (1,878.03) 33,820.00 14,746.03 43.9% Total-CM-SALARIES 6 BENEFITS 84,475.34 110,467.00 (25,991.66) 339,822.51 351,128.00 (11,305.49) 1,122,997.00 783.174.49 69.7% 63-CM-SUPPLIES 4 MATERIALS 6313734 Chemicals 8,203.04 8,000.00 203.04 14,858.77 30,500.00 (15,641.23) 46,500.00 31,641.23 68.0% 6313744 Fertilizer 15,903.95 30,000.00 (14,096.05) 38,542.94 48,400.00 (9,857.06) 111,800.00 73,257.06 65.5% 6313745 Herbicides - - - - - - - 0.0% 6313746 Flowers/Plants 3,761.84 3,500.00 261.0 3,761.84 3,500.00 261.84 7,000.00 3,238.16 46.3% 6313748 Fuel-Gasoline 3,333.83 5,700.00 (2,366.17) 20,989.66 22,800.00 (1,810.34) 68,400.00 47,410.34 69.3% 6313750 Golf Course Accessories 6,397.75 14,000.00 (7,602.25) 6,397.75 14,000.00 (7,602.25) 16,000.00 9,602.25 60.0% 6313756 POA Control - - 9,290.64 - 9,290.64 20,000.00 10,709.36 53.5% 6313758 Miscellaneous Supp 1,569.66 1,000.00 569.66 2,474.69 4,250.00 (1,775.31) 5,950.00 3,475.31 58.4% 6313762 Pesticides - - - 429.96 - 429.96 - (429.96) 0.0% 6313766 Sand 4,174.31 6,000.00 22,012.84 6,000.00 13,500.00 (8,512.84) 6313774 Seed 120,555.99 185,000.00 (64,444.01) 139,984.20 185,000.00 (45,015.80) 190,500.00 50,515.80 26.5% 6313776 Small Tools & Non -Capital Equip 2,606.99 600.00 2,006.99 5,358.17 2,400.00 2,958.17 7,025.00 1,666.83 23.7% 6313778 Sod - - - 6,653.59 11,000.00 (4,348.41) 15,500.00 8,846.41 57.1% 6313780 Topdressing- - - 1,919.62 6,000.00 (4,080.38) 19,000.00 17,080.38 89.9% Total-CM-SUPPLIES & MATERIALS 166,507.36 253,800.00 (85,466.95) 272,674.67 333,850.00 (77,188.17) 521.175.00 248.500.33 47.7% 63-CM-REPAIRS & MAINTENANCE 6315095 CM-R&M-Contract Lake Maint 4,500.00 5,143.00 (643.00) 16,800.00 20,572.00 (3,772.00) 61,716.00 44,916.00 72.8% 6315685 CM-R&M-Bldngs & Othr Structures 176.74 500.00 (323.26) 624.22 3,050.00 (2,425.78) 5,550.00 4,925.78 88.8% 6315690 CM-R&M-Equipment 8,893.29 10,000.00 (1,106.71) 28,459.89 17,500.00 10,959.89 38,500.00 10,040.11 26.1% 6315692 CM-R&M-Irrigation System 2,271.75 2,500.00 (228.25) 12,346.89 12,900.00 (553.11) 23,300.00 10,953.11 47.0% 6315696 CM-R&M-Pumps 780.83 1,000.00 (219.17) 1,974.29 4,000.00 (2,025.71) 10,500.00 8,525.71 81.2% 6315815 CM-R&M-Trees-Pruning Etc - 550.00 (550.00) 17,630.00 6,050.00 11,580.00 14.050.00 (3,580.00) -25.5% Total-CM-REPAIRS & MAINTENANCE 16,622.61 19,693.00 (3,070.39) 77,835.29 64,072.00 13,763.29 153.616.00 75.780.71 49.3% 6317836 Utilities-Natural Gas/LPG - 15.00 (15.00) 21.40 60.00 (38.60) 180.00 158.60 0.0% 6317840 Telephones 1,861.87 850.00 1,011.87 7,732.05 3,400.00 4,332.05 10.200.00 2.467.95 24.2% Total-CM-UTILITIES 1,861.87 865.00 996.87 7,753.45 3,460.00 4,293.45 10.380.00 2.626.55 25.3% 63-CM-OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7% 6319100 Contract SvcsSoillTissue Test - - - - 1,500.00 (1,500.00) 4,500.00 4,500.00 100.0% 6319102 Contract Svcs-Trash Removal - 524.00 (524.00) - 2,096.00 (2,096.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions 309.60 - 309.60 1,397.93 - 1,397.93 680.00 (717.93) -105.6% 6319170 Employee Education - 50.00 (50.00) - 200.00 (200.00) 3,900.00 3,900.00 100.0% 6319197 Equipment Rental - 1,000.00 (1,000.00)- 1,500.00 (1,500.00) 3,400.00 3,400.00 100.0% 6319206 Licenses & Permits - 250.00 (250.00) - 350.00 (350.00) 4,300.00 4,300.00 100.0% 6319490 Miscellaneous 534.45 100.00 434.45 1,126.99 400.00 726.99 1,200.00 73.01 6.1% 6319718 Safety Equipment& Training - 800.00 (800.00) - 1,850.00 (1,850.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms 1,182.71 1,210.00 (27.29) 1,915.80 4,840.00 (2,924.20) 14,520.00 12,604.20 86.8% To841-CM-OTHER EXPENSES 2,426.76 4,334.00 (1,907.24) 6,040.72 14,336.00 (8,295.28) 47,438.00 41,397.28 87.27% 4 SilverRock Resort Course Maintenance Expense Statement October 2023 4 Silverrock Resort Course Maintenance Water & Energy October 2023 Month to Date Year to Date Annual Budget October 2023 Final Budget Variance Final Budget Variance Annual Budget Unemeumb. %Budget 632 -CM -CONTRACT SERVICES 52,494.26 12,500.00 39,994.26 100,320.12 50,000.00 50,320.12 150,000.00 49,679.88 33.1% 33.1% 59.9% 6321880 Contract Labor Total Contract Service 52,494.26 12,500.00 39,994.26 100,320.12 50,000.00 50,320.12 150,000.00 49 679.88 Total -COURSE MAINTENANCE 324 388.20 401 659.00 (75.445.11) 804 446.76 816 846.00 (12.399.24) 2 005 606.00 1 201 159.24 4 Silverrock Resort Course Maintenance Water & Energy October 2023 Month to Date Year to Date Annual Budget October 2023 Final Budget Variance Final Budget Variance Annual Budget Unemeumb. %Budget 633 -CM -WATER & ENERGY 19,283.01 9,691.03 14,210.00 11,200.00 5,073.01 (1,508.97) 77,179.30 52,672.80 56,730.00 40,900.00 20,449.30 11,772.80 144,810.00 115,484.00 67,630.70 62,811.20 46.7% 54,4% 50.1% 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total -CM -WATER 8 ENERGY 28 974.04 25 410.00 3 564.04 129 852.10 97 630.00 32 222.10 260.294.00 130.441.90 4 5 SilverRock Resort Outside Services Expense Statement October 2023 Month to Date 1 Year to Date Annual Budget October 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense •SALARIES & BENEFITS 6411320 Insurance -Group 856.19 774.00 82.19 2,244.23 3,096.00 (851.77) 9,288.00 7,043.77 75.8% 6411325 Insurance -Workers Comp 600.00 652.00 (52.00) 4,061.01 3,777.00 284.01 21,662.00 17,600.99 81.3% 6411800 Taxes -Employer Payroll 391.48 997.00 (605.52) 3,513.93 5,780.00 (2,266.07) 33,156.00 29,642.07 89.4% 6411880 Wages -Hourly 4,339.13 8,011.00 (3,671.87) 41,202.11 46,432.00 (5,229.89) 266,317.00 225,114.89 84.5% 6411882 Wages -Overtime 694.98 - 694.98 1,418.87 - 1,418.87 - (1.418.87) 0.0% Total -CBR -SALARIES & BENEFITS 6,881.78 10,434.00 (3,552.22) 52,440.15 59,085.00 (6,644.85) 330,423.00 277 982.85 84.1% 641 -CBR -SUPPLIES & MATERIALS 6413732 Supplies -Carts - 500.00 (500.00) - 500.00 (500.00) 1,850.00 ' 0.0% 6413742 Supplies -Expendable 144.86 150.00 (5.14) 1,154.41 1,500.00 (345.59) 6,750.00 5,595.59 82.9% 6413748 Supplies -Fuel for Shuttle 6413752 Supplies -Range Balls - - 10,000.00 10,000.00 100.0% 6413762 Supplies -Office - 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationar 420.00 420.00 100.0% 6413786 Supplies -Towels 80.00 120.00 (40.00) 1,036.34 480.00 556.34 2,182.00 1,145.66 52.5% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 6,912.00 10,000.00 (3,088.00) 30.000.00 23,088.00 77.0% Total -CBR -SUPPLIES & MATER/ALS 224.86 3,320.00 (3,095.14) 9,102.75 12,605.00 (3,502.25) 51 727.00 40 774.25 78.8% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 332.48 300.00 32.48 13,918.35 1,200.00 12,718.35 3,600.00 (10,318.35) -286.6% 6415695 CBR -R&M -Cart Maintenance & F 1,216.00 1,503.00 (287.00) 6,608.75 6,012.00 596.75 18.036.00 11.427.25 63.4% Total -CBR -REPAIRS & MAINTENANCE 1,548.48 1,803.00 (254.52) 20,527.10 7,212.00 13,315.10 21,636.00 1 108.90 5.1% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Line 80.18 800.00 (719.82) 2,226.15 3,200.00 (973.85) 9,600.00 7,373.85 76.8% 6419220 Freight/Delivery - 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 1,161.80 2,400.00 (1,238.20) 7,200.00 6,038.20 83.9% 6419820 Uniforms 2,029.90 2,000.00 29.90 2,029.90 2,000.00 29.90 5.200.00 3.170.10 61.0% Total -CBR -OTHER EXPENSES 2,110.08 3,475.00 (1,364.92) 5,417.85 7,900.00 (2,482.15) 22 450.00 17,032.15 75.9% TOTAL-CARTSBAGROOM&RANGE 10,765.20 19,032.00 (1,364.92) 87,487.85 86,802.00 685.85 426,236.00 336,898.15 79.0% 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 200.00 214.00 (14.00) 1,251.46 1,020.00 231.46 7,766.00 6,514.54 83.9% 6431800 Taxes -Employer Payroll 100.63 257.00 (156.37) 1,145.56 1,223.00 (77.44) 9,308.00 8,162.44 87.7% 6431880 Wages -Hourly 1,074.31 2,635.00 (1,560.69) 12,254.86 12,546.00 (291.14) 95,471.00 83,216.14 87.2% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 1,374.94 3,106.00 (1,731.06) 14,651.88 14,789.00 (137.12) 112 545.00 97 893.12 87.0% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 100.00 (100.00) 37.99 300.00 (262.01) 1,050.00 1,012.01 96.4% 6439490 Miscellaneous - 50.00 (50.00) 32.60 50.00 (17.40) 200.00 167.40 83.7% 6439718 Safety Equipment & Training 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0% 6439820 Uniforms 1,395.14 800.00 595.14 1,395.14 1,025.00 370.14 2,125.00 729.86 34.3% Total -CS -OTHER EXPENSES 1,395.14 1,000.00 395.14 1,465.73 1,575.00 (109.27) 3,975.00 2,509.27 63.1% Total -COURSE SERVICES 2,770.08 4,106.00 (1,335.92) 16,117.61 16,364.00 (246.39) 116,520.00 100,402.39 86.2% TOTAL OUTSIDE SERV/CES 13 535.28 23 138.00 (9,602.72) 103,605.46 103,166.00 439.46 542 756.00 434 791.27 80.1% 5 6 SilverRock Resort Clubhouse Expense Statement October 2023 Month to Date Year to Date Annual Budget October Annual 2023 Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATER/ALS 6503742 Supplies -Expendable 400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7% Total -CH -SUPPLIES & MATERIALS 400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 24.53 1,000.00 (975.47) 2,707.72 4,000.00 (1,292.28) 12,000.00 9,292.28 77.4% 6507840 Utilities -Telephone 1,556.46 1,750.00 (193.54) 6,750.10 7,000.00 (249.90) 21,000.00 14,249.90 67.9% 6507842 Utilities -Water 591.65 321.00 270.65 2,247.19 1,284.00 963.19 3,852.00 1,604.81 41.7% 6507844 Utilities -Cable 402.29 380.00 22.29 1,922.46 1,520.00 402.46 4,560.00 2,637.54 57.8% Total -CH -UTILITIES 2,574.93 3,451.00 (876.07) 13,627.47 13,804.00 (176.53) 41,412.00 27,784.53 67.1% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 2,768.22 2,850.00 (81.78) 11,965.95 11,400.00 565.95 34,200.00 22,234.05 65.0% 6509099 Contract Services -Security 6,384.96 6,800.00 (415.04) 33,689.04 27,200.00 6,489.04 81,600.00 47,910.96 58.7% 6509215 Flowers & Decorations - 500.00 (500.00) - 500.00 (500.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous -- - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0% Total--CH-OTHER EXPENSES 9,153.18 10,250.00 (1,096.82) 45,654.99 39,500.00 6,154.99 118,900.00 73,245.01 61.6% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 487.97 300.00 187.97 2,046.95 1,200.00 846.95 3,600.00 1,553.05 43.1% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) - 2,800.00 (2,800.00) 8,400.00 8,400.00 100.0% 6515690 CH -R&M -Equipment Repair- 700.00 (700.00) 307.23 2,800.00 (2,492.77) 8,400.00 8,092.77 96.3% Total -CH -REPAIRS & MAINTENANCE 487.97 1,700.00 (1,212.03) 2,354.18 6,800.00 (4,445.82) 20,400.00 18,045.82 88.5% Total CLUBHOUSE 12,616.08 15,801.00 (3,184.92) 63,236.64 61,704.00 1,532.64 185,512.00 36,091.64 19.5% 6 7 SilverRock Resort Marketing Expense Statement October 2023 Month to Date Year to Date Annual Budget October Annual 2023 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group - - - - - - 2,709.00 2,709.00 100.0% 6601325 Insurance -Workers Comp 100.00 102.00 (2.00) 200.00 408.00 (208.00) 1,220.00 1,020.00 83.6% 6601720 Salaries 1,250.00 1,250.00 - 5,625.00 5,000.00 625.00 15,000.00 9,375.00 62.5% 6601800 Tax -Employer Payroll 122.00 122.00 - 649.00 488.00 161.00 1,463.00 814.00 55.6% Total -MKT -SALARIES & BENEFITS 1,472.00 1,474.00 (2.00) 6,474.00 5,896.00 578.00 20,392.00 13,918.00 68.3% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0% 6603768 Supplies -Printing & Stationery 59.78 3,000.00 (2,940.22) 5,445.19 3,200.00 2,245.19 4,425.00 (1,020.19) -23.1% Total -MKT -SUPPLIES & MARKET/NG 59.78 3,100.00 (3,040.22) 5,445.19 3,600.00 1,845.19 5.625.00 179.81 3.2% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 189.83 100.00 89.83 703.97 400.00 303.97 1,200.00 496.03 41.3% Total -MKT -UTILITIES 189.83 100.00 89.83 703.97 400.00 303.97 1,200.00 496.03 41.3% 66 -MKT -OTHER EXPENSES 6609010 Advertising 6,109.99 13,766.00 (7,656.01) 31,257.80 22,359.00 8,898.80 129,762.00 98,504.20 75.9% 6609040 Business Meals - 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0 6609080 Collateral Material 8,165.15 500.00 7,665.15 8,165.15 500.00 7,665.15 5,500.00 (2,665.15) -48.5% 6609102 Contract Services -Web Page - 150.00 (150.00) - 600.00 (600.00) 1,800.00 1,800.00 100.0% 6609490 Miscellaneous - - - - - - 350.00 350.00 100.0% 6609620 Postage - - - - - - 600.00 600.00 100.0% 6609630 Promotion - 50.00 (50.00) - 200.00 (200.00) 700.00 700.00 100.0% 6609633 Promotion-Cummunity - - - - - - 2,250.00 2,250.00 100.0% 6609634 Promotion-MediaNendor - 75.00 (75.00) - 300.00 (300.00) 1,000.00 1,000.00 100.0% 6609150 Dues & Subscriptions - 50.00 (50.00) - 50.00 (50.00) 735.00 735.00 100.0% 6609820 Uniforms 59.26 300.00 (240.74) 59.26 300.00 (240.74) 600.00 540.74 90.1% Total -MKT -OTHER EXPENSES 14,334.40 14,916.00 (581.60) 39,482.21 24,409.00 15,073.21 143,597.00 104,114.79 72.5% TOTAL MARKETING 16,056.01 19 590.00 (3.533.99) 52,105.37 34.305.00 17,800.37 170.814.00 118.708.63 69.5% 7 SilverRock Resort General and Administrative Expense Statement October 2023 Month to Date Year to Date Annual Budget October 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 3,210.71 3,117.00 93.71 15,128.84 12,468.00 2,660.84 37,404.00 22,275.16 59.6% 6701325 Insurance -Workers Comp 1,900.00 2,044.00 (144.00) 7,793.84 8,770.00 (976.16) 24,251.00 16,457.16 67.9% 6701720 Salaries 16,749.60 20,141.00 (3,391.40) 79,335.20 80,564.00 (1,228.80) 266,243.00 186,907.80 70.2% 6701800 Taxes -Employer Payroll 1,800.07 2,450.00 (649.93) 8,739.61 10,513.00 (1,773.39) 29,069.00 20,329.39 69.9% 6701880 Wages -Hourly 7,270.55 4,992.00 2,278.55 33,723.55 27,264.00 6,459.55 31,900.00 (1,823.55) -5.7% 6701882 Wages -Overtime - - - 5.87 - 5.87 - - Total -G&A -SALARIES & BENEFITS 30,930.93 32,744.00 (1,813.07) 144,726.91 139,579.00 5,147.91 388,867.00 244,140.09 62.8% 67 -G&A -SUPPLIES & MATERIALS 6703740 Supplies -Computer 734.65 500.00 234.65 968.71 2,000.00 (1,031.29) 6,300.00 5,331.29 84.6% 6703762 Supplies -Office 130.09 105.00 25.09 312.56 420.00 (107.44) 1,260.00 947.44 75.2% 6703768 Supplies -Printing & Stationery - 100.00 (100.00) 635.63 400.00 235.63 3,300.00 2,664.37 80.7% Total -G&A -SUPPLIES 8 MATERIALS 864.74 705.00 159.74 1,916.90 2,820.00 (903.10) 10,860.00 8,943.10 82.3% ' 67 -G&A -REPAIRS & MAINTENANCE ' 6705690 Repairs & Maintenance -Equipment - 100.00 (100.00) - 300.00 (300.00) 1,900.00 1,900.00 100.0% -G&A -REPAIRS & MAINTENANCE - 100.00 (100.00) - 300.00 (300.00) 1,900.00 1,900.00 100.0% ITotal 67 -G&A -OTHER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7% 6709150 Dues & Subscriptions - 50.00 (50.00) 233.29 400.00 (166.71) 1,550.00 1,316.71 84.9% 6709180 Employee Recruiting/Relocation 105.00 150.00 (45.00) 310.76 300.00 10.76 1,200.00 889.24 74.1% 6709197 Equipment Rental 695.21 550.00 145.21 3,258.77 2,200.00 1,058.77 6,600.00 3,341.23 50.6% 6709202 Fees -Bank 52.73 90.00 (37.27) 190.47 360.00 (169.53) 1,080.00 889.53 82.4% 6709208 Fees -Payroll Processing 1,252.32 1,000.00 252.32 3,657.68 4,000.00 (342.32) 12,000.00 8,342.32 69.5% 6709220 Freight/Delivery - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0% 6709490 Miscellaneous 513.83 100.00 413.83 1,160.20 400.00 760.20 6,000.00 4,839.80 80.7% 6709620 Postage/Mail Services - 75.00 (75.00) 364.59 300.00 64.59 900.00 535.41 59.5% 6709625 Expense Professional Fees 1,900.50 2,500.00 (599.50) 5,630.89 7,000.00 (1,369.11) 28,000.00 22,369.11 79.9% 6709636 Promotion/Entertainment - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0% 6709722 Seminars & Training 453.78 200.00 253.78 953.78 800.00 153.78 3,400.00 2,446.22 71.9% 6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms 112.29 150.00 (37.71) 382.65 375.00 7.65 1,050.00 667.35 63.6% Total -G&A -OTHER EXPENSES 5,585.66 5,515.00 70.66 18,143.08 18,835.00 (691.92) 70,680.00 52,536.92 74.3% 37.381.33 39.064.00 (1,682.67) 164.786.89 161.534.00 3 252.89 472,307.00 307.520.11 65.1% Total -GENERAL & ADMINISTRATIVE 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement October 2023 Month to Date Year to Date Annual Budget October Annual 2023 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 68 -LEASES 6800192 Equipment Leases -Carts 10,465.09 10,586.00 (120.91) 41,860.36 42,344.00 (483.64) 154,344.00 112,483.64 72.9% 6800193 Equipment Leases -Maintenance 18,310.28 18,150.00 160.28 73,241.12 72,600.00 641.12 217,800.00 144,558.88 66.4% 6800196 Equipment Leases -GPS 2,640.00 2,750.00 (110.00) 10,560.00 11,000.00 (440.00) 33,000.00 22,440.00 68.0% 6800197 Equipment Leases -Others 1,066.30 1,150.00 (83.70) 4,191.12 4,600.00 (408.88) 20,200.00 16,008.88 79.3% Total -LEASES 32,481.67 32,636.00 (154.33) 129,852.60 130,544.00 (691.40) 425,344.00 295,491.40 69.5% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 43,568.00 43,568.00 - 130,704.00 87,136.00 66.7% 6900210 FF&E Reserve 3,927.96 278.00 3,649.96 7,271.48 7,072.00 199.48 82,217.00 74,945.52 91.2% 6900323 Insurance -Commercial 2,258.86 8,917.00 (6,658.14) 28,561.08 35,668.00 (7,106.92) 107,000.00 78,438.92 73.3% 6900800 Personal Property Taxes 5,083.54 2,600.00 2,483.54 10,538.68 11,800.00 (1,261.32) 11,800.00 1,261.32 10.7% Total--M/SC OTHER EXPENSES 22,162.36 22,687.00 (524.64) 89,939.24 98,108.00 (8,168.76) 331,721.00 241,781.76 72.9% 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 2023 2023 2023 2023 2023 2023 July August September October November December 9 3 26 10 14 7 4 7 7 38 0 24 25 0 0 2024 2024 2024 2024 2024 2024 January February March April May June 0 0 0 0 0 0 10