Loading...
05 November 2023 SilverRock Resort - Monthly Financial StatementS1LVERROCK® RESORT Monthly Financial Statements July 01, 2023 - November 30, 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 Ft Administrative Expense Statement 8 Operating Leases Et Miscellaneous Expense Statement 9 Complimentary Report 10 1 SilverRock Resort Summary Operating Income Statement November 2023 Month to Date Year to Date Annual Budget November Percentage G/L # Series Account Description 2023 Final Budget Variance Difference Final Budget Variance Annual Budget Unemcumb. Bdgt Income 400000 Golf Green Fee Revenue 531,488.00 546,480.00 (14,992.00) -2.7% 894,634.00 900,099.00 (5,465.00) 4,110,847.00 3,216,213.00 22% 401000 Miscellaneous Golf Revenue 23,316.00 17,400.00 5,916.00 34.0% 42,488.00 29,350.00 13,138.00 156,180.00 113,692.00 27% 410000 Revenue -Golf Shop 25,432.91 29,700.00 (4,267.09) -14.4% 54,516.55 49,040.00 5,476.55 245,623.00 191,106.45 22% 420000 Food & Beverage Revenue 88,638.39 87,780.00 858.39 1.0% 158,493.05 148,573.00 9,920.05 710,099.00 551,605.95 22% Total Income 668,875.30 681,360.00 (12,484.70) -1.83% 1,150,131.60 1,127,062.00 23,069.60 5,222,749.00 4,072,617.40 22% Cost of Goods Sold 510000 COS -Golf Shop 14,225.00 16,624.00 (2,399.00) 14.4% 30,664.41 27,449.00 (3,215.41) 137,475.00 106,810.59 22% 520000 COS -Food & Beverage 40,866.13 25,314.00 15,552.13 -61.4% 88,657.76 49,693.00 (38,964.76) 218,834.00 130,176.24 41% Total COS 55,091.13 41,938.00 13,153.13 -31.4% 119,322.17 77,142.00 (42,180.17) 356,309.00 236,986.83 33% Gross Profit 613,784.17 639,422.00 (25,637.83) -4.0% 1,030,809.43 1,049,920.00 (19,110.57) 4,866,440.00 3,835,630.57 21% Expenses 610000 Golf Pro Shop 22,079.40 23,805.00 (1,725.60) 7.2% 85,314.05 84,008.00 1,306.05 259,447.00 174,132.95 33% 630000 Course Maintenance 190,462.82 151,193.00 39,269.82 -26.0% 993,426.34 966,539.00 26,887.34 2,005,608.00 1,012,181.66 50% 633000 Maintenance Water & Energy 28,547.36 28,000.00 547.36 -2.0% 158,399.46 125,630.00 32,769.46 282,424.00 124,024.54 56% 640000 Outside Services 72,976.05 65,255.00 7,721.05 -11.8% 176,581.51 168,421.00 8,160.51 542,757.00 366,175.49 33% 650000 Clubhouse 14,853.33 15,301.00 (447.67) 2.9% 78,089.97 77,005.00 1,084.97 185,512.00 107,422.03 42% 660000 Marketing 9,864.13 21,935.00 (12,070.87) 55.0% 61,969.50 56,240.00 5,729.50 170,814.00 108,844.50 36% 670000 General & Administrative 38,193.53 37,596.00 597.53 -1.6% 202,878.88 199,130.00 3,748.88 472,307.00 269,428.12 43% 680000 Leases 32,455.75 36,850.00 (4,394.25) 11.9% 162,308.35 167,394.00 (5,085.65) 425,344.00 263,035.65 38% 690000 Miscellaneous Other Expense 27,224.36 30,739.00 (3,514.64) 11.4% 111,040.25 128,847.00 (17,806.75) 343,521.00 232,480.75 32% 620000 Food & Beverage Expenses 52,730.25 40,260.00 12,470.25 -31.0% 169,292.14 150,266.00 19,026.14 491,697.00 322 404.86 32% Total Expenses 489,386.98 450,934.00 38,452.98 -8.5% 2,199,300.45 2,123,480.00 (75,820.45) 5,179,431.00 2,657,725.69' 42% Net Income 124,397.19 188,488.00 (64,090.81) -14.4% (1,168,491.02) (1,073,560.00) (94,931.02) (312,991.00) 1,177,904.88 400000 1 Rounds of Golf Played ■ ■ ■ ■ ■ 1 Paid Rounds Played 5,258 5,400 (142) -2.6% 10,233 11,600 (1,367) 41,996 31,763 24% Ave $ Per Paid Round Green Fee 101.08 101.20 (0.12) -0.1% 87.43 77.59 9.83 97.89 10.46 89% Ave $ Per Paid Round Merchandise 4.84 5.50 (0.66) -12.1% 5.33 4.23 1.10 5.85 0.52 91% Ave $ Per Paid Miscellaneous 4.43 3.22 1.21 37.6% 4.15 2.53 1.62 3.72 (0.43) 112% 1 2 SilverRock Resort Statement of Fees - Revenue November 2023 Month to Date Year to Date Annual Budget November Income 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 531,488.00 546,480.00 (14,992.00) 894,634.00 900,099.00 (5,465.00) 4,110,847.00 3,216,213.00 78.2% 4010000 Rider Fee 2,245.00 2,500.00 (255.00) 4,635.00 6,100.00 (1,465.00) 17,480.00 12,845.00 73.5% 4040000 Club Rental 6,100.00 3,900.00 2,200.00 13,050.00 6,500.00 6,550.00 29,800.00 16,750.00 56.2% 4050000 Driving Range 14,110.00 10,000.00 4,110.00 23,695.00 14,750.00 8,945.00 97,350.00 73,655.00 75.7% 4060000 Handicap Fees 361.00 - 361.00 608.00 - 608.00 1,550.00 942.00 60.8% 4090000 Ball Retriever/Subcontract - - - - 1,000.00 (1,000.00) 2,500.00 2,500.00 100.0% 4091000 Golf Professional Rental Fee 500.00 1,000.00 (500.00) 500.00 1,000.00 (500.00) 7,500.00 7,000.00 93.3% Total Miscellaneous Revenue 23,316.00 17,400.00 5,916.00 42,488.00 29,350.00 13,138.00 156,180.00 113,692.00 72.8% 554,804.00 563,880.00 (9,076.00) 937,122.00 929,449.00 7,673.00 4,267,027.00 3,329,905.00 78.0% Total Revenue Fees Total Income 1 554,804.00 563,880.00 (9,076.00) 937,122.00 929,449.00 7,673.00 4,267,027.00 3,329,905.00 78.0% 2 SilverRock Resort Golf Shop Income Statement November 2023 Month to Date Year to Date Annual Budget November Annual Income 2023 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget - 4100000 Sales Miscellaneous 939.00 - 939.00 3,289.40 - - 3,289.40 0 0 0% 4100110 Sales Hard Goods 9,697.58 22,275.00 (12,577.42) 23,097.48 36,780.00 (13,682.52) 61,406.00 38,308.52 62.4% 4100112 Sales -Soft Goods 14,796.33 7,425.00 7,371.33 35,131.22 12,260.00 22,871.22 184,217.00 149,085.78 80.9% 5100639 GS -Discounts -Mdse - - - (7,001.55) - (7,001.55) - 7,001.55 0.0% Total Revenue Golf Shop 25,432.91 29,700.00 (4,267.09) 54,516.55 49,040.00 12,478.10 245,623.00 187,394.30 76.3% COS 1 5100150 COS -GS -Hard Goods 5,433.67 4,307.00 1,126.67 11,930.71 7,112.00 4,818.71 35,615.00 23,684.29 66.5% 5100151 COS -GS -Soft Goods 8,737.53 12,920.00 (4,182.47) 18,370.33 21,334.00 (2,963.67) 106,846.00 88,475.67 82.8% 5100152 COS -GS -Purchase Disc (294.04) (861.00) - (1,019.33) (1,423.00) 403.67 (7,123.00) (6,103.67) 0.0% 5100220 COS -GS -Freight Merch 347.84 258.00 89.84 1,382.70 426.00 956.70 2,137.00 754.30 35.3% Cost of Sales - Golf Shop 14,225.00 16,624.00 (2,965.96) 30,664.41 27,449.00 3,215.41 137,475.00 106,810.59 77.7% Gross Profit 11,207.91 13,076.00 (1,301.13) 23,852.14 21,591.00 9,262.69 108,148.00 80,583.71 74,50/ COS % 55.9% 56.0% 0.0% I 56.2% 56.0% -0.3% 53.1% 57.0% 107.4% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 170.42 774.00 (603.58) 2,663.09 3,870.00 (1,206.91) 9,288.00 6,624.91 71.3% 6101325 Insurance -Workers Comp 1,500.00 1,507.00 (7.00) 4,751.96 5,115.00 (363.04) 15,959.00 11,207.04 70.2% 6101720 Salaries 5,769.24 6,436.00 (666.76) 31,730.82 32,180.00 (449.18) 77,250.00 45,519.18 58.9% 6101800 Taxes -Employer Payroll 1,484.11 1,807.00 (322.89) 5,628.27 6,133.00 (504.73) 19,129.00 13,500.73 70.6% 6101880 Wages -Hourly 12,086.27 12,096.00 (9.73) 37,267.67 30,710.00 6,557.67 118,952.00 81,684.33 68.7% 6101882 Wages -Overtime 71.45 - 71.45 434.43 - 434.43 - (434.43) 0.0% Total -PS-SALARIES & BENEFITS 21,081.49 22,620.00 (1,538.51) 82,476.24 78,008.00 4,468.24 240.578.00 158.101.76 65.7% 61 -PS OTHER EXPENSES 6103762 Supplies -Office 732.22 250.00 482.22 798.16 1,250.00 (451.84) 3,000.00 2,201.84 73.4% 6109150 Dues and Subscriptions _ - - - - - 1 2,300.00 2,300.00 100.0% 6109220 Freight & Delivery - 25.00 (25.00) - 50.00 (50.00) 75.00 75.00 100.0% 6109490 Miscellaneous - 500.00 (500.00) 40.13 2,500.00 (2,459.87) 6,000.00 5,959.87 99.3% 6109722 Seminars/Training - - - - 950.00 (950.00) 3,690.00 3,690.00 100.0% 6109810 Travel - Merchandise - - - - - - 90.00 90.00 100.0% 6109820 Uniforms 170.52 300.00 (129.48) 1,455.64 700.00 755.64 2,400.00 944.36 39.3% 6117840 Telephones 95.17 110.00 (14.83) 543.88 550.00 (6.12) 1,320.00 776.12 58.8% Total - Other Expenses 997.91 1,185.00 (187.09) 2,837.81 6,000.00 (3,162.19) 18,875.00 16,037.19 85.0% I Total Expenses -Golf Shop 22,079.40 23,805.00 (1,725.60) 85,314.05 84,008.00 1,306.05 259,453.00 174,138.95 67.1% Net Income (10,871.491 (10,729.00) (142.49) (61,461.91) (62,417.001 7.956.64 (151,305.001 (93,555.24) 61.8% 3 4 SilverRock Resort Course Maintenance Expense Statement November 2023 Month to Date Year to Date Annual Budget November 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 7,351.24 9,696.00 (2,344.76) 35,919.16 39,966.00 (4,046.84) 107,838.00 71,918.84 66.7% 6311325 Insurance -Workers Comp 3,500.00 3,588.00 (88.00) 15,532.06 16,976.00 (1,443.94) 42,860.00 27,327.94 63.8% 6311720 Salaries 14,691.38 16,713.00 (2,021.62) 80,802.59 83,565.00 (2,762.41) 200,000.00 119,197.41 59.6% 6311800 Taxes -Employer Payroll 5,063.13 7,224.00 (2,160.87) 23,336.71 34,539.00 (11,202.29) 86,375.00 63,038.29 73.0% 6311880 Wages -Hourly 42,865.28 54,788.00 (11,922.72) 237,775.77 247,339.00 (9,563.23) 652,304.00 414,528.23 63.5% 6311882 Wages -Overtime 3,510.92 2,592.00 918.92 22,384.89 23,344.00 (959.11) 33,620.00 11,235.11 33.4% Total -CM -SALARIES & BENEFITS 76,981.95 94,601.00 (17,619.05) 415,751.18 445,729.00 (29,977.82) 1,122,997.00 707.245.82 63.0% 63 -CM -SUPPLIES & MATER/ALS 6313734 Chemicals 21,516.46 2,000.00 19,516.46 36,375.23 32,500.00 3,875.23 46,500.00 10,124.77 21.8% 6313744 Fertilizer 14,752.51 10,000.00 4,752.51 53,295.45 58,400.00 (5,104.55) 111,800.00 58,504.55 52.3% 6313746 Flowers/Plants 3,761.84 - 3,761.84 7,523.68 3,500.00 4,023.68 7,000.00 (523.68) -7.5% 6313748 Fuel -Gasoline 5,979.14 5,700.00 279.14 26,968.80 28,500.00 (1,531.20) 68,400.00 41,431.20 60.6% 6313750 Golf Course Accessories _ - 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 353.35 500.00 (148.65) 2,828.04 3,250.00 (421.96) 5,950.00 3,121.96 52.5% 6313774 Pesticides - - - - - - - 0.0% 6313778 Sand 17,249.21 2,500.00 14,749.21 39,262.05 8,500.00 30,762.05 13,500.00 (25,762.05) 6313778 Seed - 5,500.00 (5,500.00) 139,984.20 190,500.00 (50,515.80) 190,500.00 50,515.80 26.5% 6313780 Small Tools & Non -Capital Equip 161.72 600.00 (438.28) 5,519.89 3,000.00 2,519.89 7,025.00 1,505.11 21.4% 6313782 Sod - - - 6,653.59 11,000.00 (4,346.41) 15,500.00 8,846.41 57.1% 6313784 Topdressing- - - 1,919.62 6,000.00 (4,080.38) 19,000.00 17,080.38 89.9% To641-CMSUPPL/ES 4 MATERIALS 63,774.23 26,800.00 36,974.23 336,018.94 359,150.00 (23,131.06) 521.175.00 185.156.06 35.5% 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 4,100.00 5,143.00 (1,043.00) 20,900.00 25,715.00 (4,815.00) 61,716.00 40,816.00 66.1% 6315685 CM-R&M-Bldngs & Othr Structures 330.44 500.00 (169.56) 954.66 3,550.00 (2,595.34) 5,550.00 4,595.34 82.8% 6315690 CM -R&M -Equipment 3,221.55 5,000.00 (1,778.45) 31,681.44 22,500.00 9,181.44 38,500.00 6,818.56 17.7% 6315692 CM -R&M -Irrigation System 967.82 1,400.00 (432.18) 13,314.71 14,300.00 (985.29) 23,300.00 9,985.29 42.9% 6315696 CM -R&M -Pumps 8,233.99 1,000.00 7,233.99 10,208.28 5,000.00 5,208.28 10,500.00 291.72 2.8% 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 16,853.80 13,043.00 3,810.80 94,689.09 77,115.00 17,574.09 153.616.00 58.926.91 38.4% 6317836 Utilities -Natural Gas/LPG 22.95 15.00 7.95 44.35 75.00 (30.65) 180.00 135.65 0.0% 6317840 Telephones 1,792.98 850.00 942.98 9,525.03 4,250.00 5,275.03 10.200.00 674.97 6.6% Total -CM -UTILITIES 1,815.93 865.00 950.93 9,569.38 4,325.00 5,244.38 10.380.00 810.62 7.8% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3% 6319100 Contract Svcs-Soil/Tissue 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,620.00 (2,620.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions 160.00 - 160.00 1,557.93 - 1,557.93 680.00 (877.93) -129.1% 6319170 Employee Education - 50.00 (50.00) - 250.00 (250.00) 3,900.00 3,900.00 100.0% 6319197 Equipment Rental - 600.00 (600.00) - 2,100.00 (2,100.00) 3,400.00 3,400.00 100.0% 6319206 Licenses & Permits - - - - 350.00 (350.00) 4,300.00 4,300.00 100.0% 6319490 Miscellaneous - 100.00 (100.00) 1,126.99 500.00 626.99 1,200.00 73.01 6.1% 6319718 Safety Equipment& Training - 500.00 (500.00) - 2,350.00 (2,350.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms 1,757.11 1,210.00 547.11 3,672.91 6,050.00 (2,377.09) 14,520.00 10,847.09 74,714 Total -CM -OTHER EXPENSES 2,317.11 3,384.00 (1,066.89) 8,357.83 17,720.00 (9,362.17) 47,438.00 39,080.17 82.38% 4 SilverRock Resort Course Maintenance Expense Statement November 2023 4 Silverrock Resort Course Maintenance Water & Energy November 2023 Month to Date Year to Date Annual Budget November 2023 Final Budget Variance Final Budget Variance Annual Budget Unemeumb. %Budget 632 -CM -CONTRACT SERV/CES 28,719.80 12,500.00 16,219.80 129,039.92 62,500.00 66,539.92 150,000.00 20,960.08 14.0% 14.0% 50.5% 6321880 Contract Labor Total Contract Service 28,719.80 12,500.00 16,219.80 129,039.92 62,500.00 66,539.92 150,000.00 20960.08 Total -COURSE MAINTENANCE 190.462.82 151.193.00 39.269.82 993.426.34 966.539.00 26.887.34 2 005 606.00 1 012 179.66 4 Silverrock Resort Course Maintenance Water & Energy November 2023 Month to Date Year to Date Annual Budget November 2023 Final Budget Variance Final Budget Variance Annual Budget Unemeumb. %Budget 633 -CM -WATER 8 ENERGY 19,859.39 8,687.97 12,000.00 16,000.00 7,859.39 (7,312.03) 97,038.69 61,360.77 68,730.00 56,900.00 28,308.69 4,460.77 144,810.00 115,484.00 47,771.31 54,123.23 33.0% 46.9% 39.1% 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total -CM -WATER & ENERGY 28.547.36 28.000.00 547.36 158.399.46 125 630.00 32 769.46 260.294.00 101.894.54 4 5 SilverRock Resort Outside Services Expense Statement November 2023 I Month to Date Year to Date Annual Budget November 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense •SALARIES & BENEFITS 6411320 Insurance -Group 500.77 774.00 (273.23) 2,745.00 3,870.00 (1,125.00) 9,288.00 6,543.00 70.4% 6411325 Insurance -Workers Comp 2,050.00 2,070.00 (20.00) 6,111.01 5,847.00 264.01 21,662.00 15,550.99 71.8% 6411800 Taxes -Employer Payroll 2,323.86 3,168.00 (844.14) 5,837.79 8,948.00 (3,110.21) 33,156.00 27,318.21 82.4% 6411880 Wages -Hourly 23,249.53 25,445.00 (2,195.47) 64,451.64 71,877.00 (7,425.36) 266,317.00 201,865.36 75.8% 6411882 Wages -Overtime 3,509.17 - 3,509.17 4,928.04 - 4,928.04 - (4.928.04) 0.0% Total -CBR -SALARIES & BENEFITS 31,633.33 31,457.00 176.33 84,073.48 90,542.00 (6,468.52) 330,423.00 246 349.52 74.6% 641 -CBR -SUPPLIES & MATERIALS 6413732 Supplies -Carts - 500.00 (500.00) - 1,000.00 (1,000.00) 1,850.00 ' 0.0% 6413742 Supplies -Expendable 1,393.25 1,800.00 (406.75) 2,547.66 3,300.00 (752.34) 6,750.00 4,202.34 62.3% 6413748 Supplies -Fuel for Shuttle - 0.0% 6413752 Supplies -Range Balls 14,681.25 10,000.00 4,681.25 14,681.25 10,000.00 4,681.25 10,000.00 (4,681.25) -46.8% 6413762 Supplies -Office - 50.00 (50.00) - 175.00 (175.00) 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationar 420.00 420.00 100.0% 6413786 Supplies -Towels 400.00 185.00 215.00 1,436.34 665.00 771.34 2,182.00 745.66 34.2% 6413796 Supplies -Bottled Water 6,912.00 2,500.00 4,412.00 13,824.00 12,500.00 1,324.00 30.000.00 16,176.00 53.9% Total -CBR -SUPPLIES & MATER/ALS 23,386.50 15,035.00 8,351.50 32,489.25 27,640.00 4,849.25 51 727.00 17 387.75 33.6% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 895.36 300.00 595.36 14,813.71 1,500.00 13,313.71 3,600.00 (11,213.71) -311.5% 6415695 CBR -R&M -Cart Maintenance & F 2,630.15 1,503.00 1,127.15 9,238.90 7,515.00 1,723.90 18.036.00 8.797.10 48.8% Total -CBR -REPAIRS & MAINTENANCE 3,525.51 1,803.00 1,722.51 24,052.61 9,015.00 15,037.61 21,636.00 (2,416.61) -11.2 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Line 400.90 800.00 (399.10) 2,627.05 4,000.00 (1,372.95) 9,600.00 6,972.95 72.6% 6419220 Freight/Delivery - 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0% 6419490 Miscellaneous 439.33 600.00 (160.67) 1,601.13 3,000.00 (1,398.87) 7,200.00 5,598.87 77.8% 6419820 Uniforms 914.01 500.00 414.01 2,943.91 2,500.00 443.91 5.200.00 2.256.09 43.4% Total -CBR -OTHER EXPENSES 1,754.24 1,975.00 (220.76) 7,172.09 9,875.00 (2,702.91) 22450.00 15,277.91 68.1% TOTAL -CARTS BAGROOM & RANGE 60,299.58 50,270.00 (220.76) 147,787.43 137,072.00 10,715.43 426,236.00 276,598.57 64.9% 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 1,000.00 1,015.00 (15.00) 2,251.46 2,035.00 216.46 7,766.00 5,514.54 71.0% 6431800 Taxes -Employer Payroll 951.35 1,217.00 (265.65) 2,096.91 2,440.00 (343.09) 9,308.00 7,211.09 77.5% 6431880 Wages -Hourly 10,345.19 12,478.00 (2,132.81) 22,600.05 25,024.00 (2,423.95) 95,471.00 72,870.95 76.3% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 12,296.54 14,710.00 (2,413.46) 26,948.42 29,499.00 (2,550.58) 112 545.00 85 596.58 76.1% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 379.93 100.00 279.93 417.92 400.00 17.92 1,050.00 632.08 60.2% 6439490 Miscellaneous - 50.00 (50.00) 32.60 100.00 (67.40) 200.00 167.40 83.7% 6439718 Safety Equipment & Training - 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0% 6439820 Uniforms - 75.00 (75.00) 1,395.14 1,100.00 295.14 2,125.00 729.86 34.3% Total -CS -OTHER EXPENSES 379.93 275.00 104.93 1,845.66 1,850.00 (4.34) 3,975.00 2,129.34 53.6% Total -COURSE SERVICES 12,676.47 14,985.00 (2,308.53) 28,794.08 31,349.00 (2,554.92) 116,520.00 87,725.92 75.3% TOTAL OUTSIDE SERV/CES 72.976.05 65.255.00 7.721.05 176,581.51 168,421.00 8.160.51 542 756.00 362 195.15 66.7% 5 6 SilverRock Resort Clubhouse Expense Statement November 2023 Month to Date Year to Date Annual Budget November Annual 2023 Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATER/ALS 6503742 Supplies -Expendable 400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3% Total -CH -SUPPLIES & MATERIALS 400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 1,874.12 1,000.00 874.12 4,581.84 5,000.00 (418.16) 12,000.00 7,418.16 61.8% 6507840 Utilities -Telephone 1,633.11 1,750.00 (116.89) 8,383.21 8,750.00 (366.79) 21,000.00 12,616.79 60.1% 6507842 Utilities -Water 595.96 321.00 274.96 2,843.15 1,605.00 1,238.15 3,852.00 1,008.85 26.2% 6507844 Utilities -Cable 409.29 380.00 29.29 2,331.75 1,900.00 431.75 4,560.00 2,228.25 48.9% Total -CH -UTILITIES 4,512.48 3,451.00 1,061.48 18,139.95 17,255.00 884.95 41,412.00 23,272.05 56.2% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 3,218.22 2,850.00 368.22 15,184.17 14,250.00 934.17 34,200.00 19,015.83 55.6% 6509099 Contract Services -Security 6,294.88 6,800.00 (505.12) 39,983.92 34,000.00 5,983.92 81,600.00 41,616.08 51.0% 6509215 Flowers & Decorations - - - - 500.00 (500.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous -- - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0% Total--CH-OTHER EXPENSES 9,513.10 9,750.00 (236.90) 55,168.09 49,250.00 5,918.09 118,900.00 63,731.91 53.6% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 427.75 300.00 127.75 2,474.70 1,500.00 974.70 3,600.00 1,125.30 31.3% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) - 3,500.00 (3,500.00) 8,400.00 8,400.00 100.0% 6515690 CH -R&M -Equipment Repair- 700.00 (700.00) 307.23 3,500.00 (3,192.77) 8,400.00 8,092.77 96.3% Total -CH -REPAIRS & MAINTENANCE 427.75 1,700.00 (1,272.25) 2,781.93 8,500.00 (5,718.07) 20,400.00 17,618.07 86.4% Total CLUBHOUSE 14,853.33 15,301.00 (447.67) 78,089.97 77,005.00 1,084.97 185,512.00 35,236.14 19.0% 6 7 SilverRock Resort Marketing Expense Statement November 2023 Month to Date Year to Date Annual Budget November 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 102.00 102.00 - 302.00 510.00 (208.00) 1,220.00 918.00 75.2% 6601720 Salaries 1,250.00 1,250.00 - 6,875.00 6,250.00 625.00 15,000.00 8,125.00 54.2% 6601800 Tax -Employer Payroll 122.00 122.00 - 771.00 610.00 161.00 1,463.00 692.00 47.3% Total -MKT -SALARIES & BENEFITS 1,474.00 1,474.00 - 7,948.00 7,370.00 578.00 20,392.00 12,444.00 61.0% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office - 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0% 6603768 Supplies -Printing & Stationery 71.31 200.00 (128.69) 5,516.50 3,400.00 2,116.50 4,425.00 (1,091.50) -24.7% Total -MKT -SUPPLIES & MARKET/NG 71.31 300.00 (228.69) 5,516.50 3,900.00 1,616.50 5,625.00 108.50 1.9% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 189.83 100.00 89.83 893.80 500.00 393.80 1,200.00 306.20 25.5% Total -MKT -UTILITIES 189.83 100.00 89.83 893.80 500.00 393.80 1,200.00 306.20 25.5% 66 -MKT -OTHER EXPENSES 6609010 Advertising 8,128.99 17,936.00 (9,807.01) 39,386.79 40,295.00 (908.21) 129,762.00 90,375.21 69.6% 6609040 Business Meals - 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0% 6609080 Collateral Material - 1,000.00 (1,000.00) 8,165.15 1,500.00 6,665.15 5,500.00 (2,665.15) -48.5% 6609102 Contract Services -Web Page - 150.00 (150.00) - 750.00 (750.00) 1,800.00 1,800.00 100.0% 6609490 Miscellaneous - - - - - - 350.00 350.00 100.0% 6609620 Postage - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0% 6609630 Promotion - 50.00 (50.00) - 250.00 (250.00) 700.00 700.00 100.0% 6609633 Promotion-Cummunity - - - - - - 2,250.00 2,250.00 100.0% 6609634 Promotion-MediaNendor - 750.00 (750.00) - 1,050.00 (1,050.00) 1,000.00 1,000.00 100.0% 6609150 Dues & Subscriptions - 50.00 (50.00) - 100.00 (100.00) 735.00 735.00 100.0% 6609820 Uniforms - 50.00 (50.00) 59.26 350.00 (290.74) 600.00 540.74 90.1% Total -MKT -OTHER EXPENSES 8,128.99 20,061.00 (11,932.01) 47,611.20 44,470.00 3,141.20 143,597.00 95,985.80 66.8% TOTAL MARKETING 9 864.13 21,935.00 (12.070.87) 61,969.50 56,240.00 5 729.50 170,814.00 108,844.50 63.7% 7 SilverRock Resort General and Administrative Expense Statement November 2023 Month to Date Year to Date Annual Budget November 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 3,837.22 3,117.00 720.22 18,966.06 15,585.00 3,381.06 37,404.00 18,437.94 49.3% 6701325 Insurance -Workers Comp 1,800.00 1,826.00 (26.00) 9,593.84 10,596.00 (1,002.16) 24,251.00 14,657.16 60.4% 6701720 Salaries 16,749.60 20,141.00 (3,391.40) 96,084.80 100,705.00 (4,620.20) 266,243.00 170,158.20 63.9% 6701800 Taxes -Employer Payroll 2,150.51 2,188.00 (37.49) 10,890.12 12,701.00 (1,810.88) 29,069.00 18,178.88 62.5% 6701880 Wages -Hourly 6,579.41 2,304.00 4,275.41 40,302.96 29,568.00 10,734.96 31,900.00 (8,402.96) -26.3% 6701882 Wages -Overtime 16.62 - 16.62 22.49 - 22.49 - - Total -G&A -SALARIES & BENEFITS 31,133.36 29,576.00 1,557.36 175,860.27 169,155.00 6,705.27 388,867.00 213,006.73 54.8% 67 -G&A -SUPPLIES & MATERIALS 6703740 Supplies -Computer (68.27) 500.00 (568.27) 900.44 2,500.00 (1,599.56) 6,300.00 5,399.56 85.7% 6703762 Supplies -Office 102.00 105.00 (3.00) 414.56 525.00 (110.44) 1,260.00 845.44 67.1% 6703768 Supplies -Printing & Stationery 243.34 100.00 143.34 878.97 500.00 378.97 3,300.00 2,421.03 73.4/ Total -G&A -SUPPLIES & MATERIALS 277.07 705.00 (427.93) 2,193.97 3,525.00 (1,331.03) 10,860.00 8,666.03 70.80/0 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment - 900.00 (900.00) - 1,200.00 (1,200.00) 1,900.00 1,900.00 100.0% Total -G&A -REPAIRS & MAINTENANCE - 900.00 (900.00) - 1,200.00 (1,200.00) 1,900.00 1,900.00 100.0% 67 -G&A -OTHER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.3% 6709150 Dues & Subscriptions - 50.00 (50.00) 233.29 450.00 (216.71) 1,550.00 1,316.71 84.9% 6709180 Employee Recruiting/Relocation 374.25 150.00 224.25 685.01 450.00 235.01 1,200.00 514.99 42.9% 6709197 Equipment Rental 921.21 550.00 371.21 4,179.98 2,750.00 1,429.98 6,600.00 2,420.02 36.7% 6709202 Fees -Bank 53.44 90.00 (36.56) 243.91 450.00 (206.09) 1,080.00 836.09 77.4% 6709208 Fees -Payroll Processing 1,580.94 1,000.00 580.94 5,137.08 5,000.00 137.08 12,000.00 6,862.92 57.2% 6709220 Freight/Delivery - 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0% 6709490 Miscellaneous 877.22 1,000.00 (122.78) 2,037.42 1,400.00 637.42 6,000.00 3,962.58 66.0% 6709620 Postage/Mail Services 164.59 75.00 89.59 529.18 375.00 154.18 900.00 370.82 41.2% 6709625 Expense Professional Fees 2,044.00 2,500.00 (456.00) 7,674.89 9,500.00 (1,825.11) 28,000.00 20,325.11 72.6% 6709636 Promotion/Entertainment - 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0% 6709722 Seminars & Training - 200.00 (200.00) 953.78 1,000.00 (46.22) 3,400.00 2,446.22 71.9% 6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms 267.45 150.00 117.45 650.10 525.00 125.10 1,050.00 399.90 38.1% Total -G&A -OTHER EXPENSES 6,783.10 6,415.00 368.10 24,824.64 25,250.00 (425.36) 70,680.00 45,855.36 64.9% 38.193.53 37.596.00 597.53 202.878.88 199.130.00 3.748.88 472,307.00 269.428.12 57.0% Total -GENERAL & ADMINISTRATIVE 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement November 2023 Month to Date Year to Date Annual Budget November Annual 2023 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 68 -LEASES 6800192 Equipment Leases -Carts 10,465.09 14,000.00 (3,534.91) 52,325.45 56,344.00 (4,018.55) 154,344.00 102,018.55 66.1% 6800193 Equipment Leases -Maintenance 18,310.28 18,150.00 160.28 91,551.40 90,750.00 801.40 217,800.00 126,248.60 58.0% 6800196 Equipment Leases -GPS 2,640.00 2,750.00 (110.00) 13,200.00 13,750.00 (550.00) 33,000.00 19,800.00 60.0% 6800197 Equipment Leases -Others 1,040.38 1,950.00 (909.62) 5,231.50 6,550.00 (1,318.50) 20,200.00 14,968.50 74.1% Total -LEASES 32,455.75 36,850.00 (4,394.25) 162,308.35 167,394.00 (5,085.65) 425,344.00 263,035.65 61.8% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 54,460.00 54,460.00 - 130,704.00 76,244.00 58.3% 6900210 FF&E Reserve 10,629.76 10,930.00 (300.24) 17,901.24 18,002.00 (100.76) 82,217.00 64,315.76 78.2% 6900323 Insurance -Commercial 972.60 8,917.00 (7,944.40) 28,865.47 44,585.00 (15,719.53) 107,000.00 78,134.53 73.0% 6900800 Personal Property Taxes 4,730.00 - 4,730.00 9,813.54 11,800.00 (1,986.46) 11,800.00 1,986.46 16.8% Total--M/SC OTHER EXPENSES 27,224.36 30,739.00 (3,514.64) 111,040.25 128,847.00 (17,806.75) 331,721.00 220,680.75 66.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 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 38 0 24 25 66 0 2024 2024 2024 2024 2024 2024 January February March April May June 0 0 0 0 0 0 10