Loading...
09 March 2024 SilverRock Resort - Monthly Financial StatementSI LVERROCK® R E SORT Monthly Financial Statements July 01, 2023 - March 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 &t Administrative Expense Statement 8 Operating Leases &t Miscellaneous Expense Statement 9 Complimentary Report 10 4/221 1 SilverRock Resort Summary Operating Income Statement March 2024 Month to Date Year to Date Annual Budget G/L # Series Account Description March 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. Bdgt Income 400000 Golf Green Fee Revenue 756,492.00 701,195.00 55,297.00 7.9% 3,317,571.00 3,129,829.00 187,742.00 4,110,847.00 793,276.00 81% 401000 Miscellaneous Golf Revenue 33,275.56 27,400.00 5,875.56 21.4% 148,149.11 125,600.00 22,549.11 156,180.00 8,030.89 95% 410000 Revenue -Golf Shop 41,706.53 42,700.00 (993.47) -2.3% 169,320.16 184,600.00 (15,279.84) 245,623.00 76,302.84 69% 420000 Food & Beverage Revenue 122,116.50 108,580.00 13,536.50 12.5% 542,893.70 514,624.00 28,269.70 710,099.00 167,205.30 76% Total Income 953,590.59 879,875.00 73,715.59 8.38% 4,177,933.97 3,954,653.00 223,280.97 5,222,749.00 1,044,815.03 80% Cost of Goods Sold 510000 COS -Golf Shop 23,349.51 23,900.00 (550.49) 2.3% 93,307.58 103,324.00 10,016.42 137,475.00 44,167.42 68% 520000 COS -Food & Beverage 43,535.57 31,814.00 11,721.57 -36.8% 228,654.35 159,424.00 (69,230.35) 218,834.00 (9,820.35) 104% Total COS 66,885.08 55,714.00 11,171.08 -20.1% 321,961.93 262,748.00 (59,213.93) 356,309.00 34,347.07 90% Gross Profit 886,705.51 824,161.00 62,544.51 7.6% 3,855,972.04 3,691,905.00 164,067.04 4,866,440.00 1,010,467.96 79% Expenses 610000 Golf Pro Shop 31,619.82 25,546.00 6,073.82 -23.8% 190,939.64 187,145.00 3,794.64 259,447.00 68,507.36 74% 630000 Course Maintenance 168,679.14 147,780.00 20,899.14 -14.1% 1,648,360.19 1,559,037.00 89,323.19 2,005,608.00 357,247.81 82% 633000 Maintenance Water & Energy 21,191.97 21,250.00 (58.03) 0.3% 241,918.30 207,915.00 34,003.30 282,424.00 40,505.70 86% 640000 Outside Services 86,602.20 61,317.00 25,285.20 -41.2% 414,570.92 414,781.00 (210.08) 542,757.00 128,186.08 76% 650000 Clubhouse 14,048.64 15,801.00 (1,752.36) 11.1% 138,924.68 139,209.00 (284.32) 185,512.00 46,587.32 75% 660000 Marketing 14,638.02 18,777.00 (4,138.98) 22.0% 110,464.48 135,328.00 (24,863.52) 170,814.00 60,349.52 65% 670000 General & Administrative 45,504.14 38,982.00 6,522.14 -16.7% 367,155.36 360,208.00 6,947.36 472,307.00 105,151.64 78% 680000 Leases 23,789.05 36,850.00 (13,060.95) 35.4% 275,615.80 314,794.00 (39,178.20) 425,344.00 149,728.20 65% 690000 Miscellaneous Other Expense 32,720.58 33,833.00 (1,112.42) 3.3% 240,911.08 252,678.00 (11,766.92) 343,521.00 102,609.92 70% 620000 Food & Beverage Expenses 92,464.61 56,268.00 36,196.61 -64.3% 443,662.36 374,028.00 69,634.36 491,697.00 48,034.64 70% Total Expenses 531,258.17 456,404.00 74,854.17 -16.4% 4,072,522.81 3,945,123.00 (127,399.81) 5,179,431.00 1 1,058,873.55 79% Net Income 355,447.34 367,757.00 (12,309.66) -0.4% (216,550.77) (253,218.00) 36,667.23 (312,991.00) (48,405.59) 400000 Rounds of Golf Played Paid Rounds Played 6,109 6,100 9 0.1% 31,362 32,310 (948) 41,996 10,634 75% Ave $ Per Paid Round Green Fee 123.83 114.95 8.88 7.7% 105.78 96.87 8.91 97.89 (7.90) 108% Ave $ Per Paid Round Merchandise 6.83 7.00 (0.17) -2.5% 5.40 5.71 (0.31) 5.85 0.45 92% Ave $ Per Paid Miscellaneous 5.45 4.49 0.96 21.3% 4.72 3.89 0.84 3.72 (1.00) 127% 1 2 SilverRock Resort Statement of Fees - Revenue March 2024 Month to Date Year to Date Annual Budget March 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 756,492.00 701,195.00 55,297.00 3,317,571.00 3,129,829.00 187,742.00 4,110,847.00 793,276.00 19.3% 4010000 Rider Fee 4,910.00 1,500.00 3,410.00 15,945.00 16,200.00 (255.00) 17,480.00 1,535.00 8.8% 4040000 Club Rental 9,385.56 4,500.00 4,885.56 34,808.11 23,100.00 11,708.11 29,800.00 (5,008.11) -16.8% 4050000 Driving Range 17,980.00 19,500.00 (1,520.00) 89,425.00 77,250.00 12,175.00 97,350.00 7,925.00 8.1% 4060000 Handicap Fees - 400.00 (400.00) 2,206.00 1,550.00 656.00 1,550.00 (656.00) -42.3% 4090000 Ball Retriever/Subcontract - - - 765.00 1,500.00 (735.00) 2,500.00 1,735.00 69.4% 4091000 Golf Professional Rental Fee 1,000.00 1,500.00 (500.00) 5,000.00 6,000.00 (1,000.00) 7,500.00 2,500.00 33.3% Total Miscellaneous Revenue 33,275.56 27,400.00 5,875.56 148,149.11 125,600.00 22,549.11 156,180.00 8,030.89 5.1% 789,767.56 728,595.00 61,172.56 3,465,720.11 3,255,429.00 210,291.11 4,267,027.00 801,306.89 18.8% Total Revenue Fees Total Income 789,767.56 728,595.00 61,172.56 3,465,720.11 3,255,429.00 210,291.11 4,267,027.00 801,306.89 18.8% 2 3 SilverRock Resort Golf Shop Income Statement March 2024 Month to Date Year to Date Annual Budget March 2024 Annual Income Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 160.00 - 160.00 4,037.40 - 4,037.40 0 0 0% 4100110 Sales Hard Goods 15,158.52 10,675.00 4,483.52 62,699.25 46,150.00 16,549.25 61,406.00 (1,293.25) -2.1% 4100112 Sales -Soft Goods 26,388.01 32,025.00 (5,636.99) 109,585.06 138,450.00 (28,864.94) 184,217.00 74,631.94 40.5% 5100639 GS -Discounts -Mdse - - - (7,001.55) - (7,001.55) - 7,001.55 0.0% Total Revenue Golf Shop 41,706.53 42,700.00 (993.47) 169,320.16 184,600.00 (8,278.29) 245,623.00 73,338.69 29.9% COS 5100150 COS -GS -Hard Goods 8,242.65 6,192.00 2,050.65 34,150.36 26,769.00 7,381.36 35,615.00 1,464.64 4.1% 5100151 COS -GS -Soft Goods 14,787.53 18,575.00 (3,787.47) 57,772.67 80,303.00 (22,530.33) 106,846.00 49,073.33 45.9% 5100152 COS -GS -Purchase Disc (43.24) (1,238.00) 1,194.76 (1,998.15) (5,354.00) 3,355.85 (7,123.00) (5,124.85) 0.0% 5100220 COS -GS -Freight Merch 362.57 371.00 (8.43) 3,382.70 1,606.00 1,776.70 2,137.00 (1,245.70) -58.3% Cost of Sales - Golf Shop 23,349.51 23,900.00 (550.49) 93,307.58 103,324.00 (10,016.42) 137,475.00 44,167.42 32.1% Gross Profit 18,357.02 18,800.00 (442.98) 76,012.58 81,276.00 1,738.13 108,148.00 29,171.27 27.0% COS % 56.0% 56.0% 0.0% 55.1% 56.0% 0.9% 53.1% 60.2% 113.5% en Expse 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 365.54 774.00 (408.46) 3,950.82 6,966.00 (3,015.18) 9,288.00 5,337.18 57.5% 6101325 Insurance -Workers Comp 1,630.00 1,633.00 (3.00) 11,081.96 11,603.00 (521.04) 15,959.00 4,877.04 30.6% 6101720 Salaries 8,653.86 6,436.00 2,217.86 57,692.40 57,924.00 (231.60) 77,250.00 19,557.60 25.3% 6101800 Taxes -Employer Payroll 3,140.31 1,957.00 1,183.31 15,951.99 13,908.00 2,043.99 19,129.00 3,177.01 16.6% 6101880 Wages -Hourly 17,004.58 13,636.00 3,368.58 94,475.04 84,714.00 9,761.04 118,952.00 24,476.96 20.6% 6101882 Wages -Overtime 404.79 - 404.79 1,219.71 - 1,219.71 - (1,219.71) 0.0% Total -PS-SALARIES & BENEFITS 31,199.08 24,436.00 6,763.08 184,371.92 175,115.00 9,256.92 240.578.00 56.206.08 23.4% 61 -PS OTHER EXPENSES 6103762 Supplies -Office (49.93) 250.00 (299.93) 1,036.81 2,250.00 (1,213.19) 3,000.00 1,963.19 65.4% 6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 100.0% 6109220 Freight & Delivery - - - - 75.00 (75.00) 75.00 75.00 100.0% 6109490 Miscellaneous - 500.00 (500.00) 1,592.63 4,500.00 (2,907.37) 6,000.00 4,407.37 73.5% 6109722 Seminars/Training 140.00 35.00 105.00 598.99 2,370.00 (1,771.01) 3,690.00 3,091.01 83.8% 6109810 Travel - Merchandise - 15.00 (15.00) - 45.00 (45.00) 90.00 90.00 100.0% 6109820 Uniforms 194.71 200.00 (5.29) 2,011.13 1,800.00 211.13 2,400.00 388.87 16.2% 6117840 Telephones 135.96 110.00 25.96 1,328.16 990.00 338.16 1,320.00 (8.16) -0.6% Total - Other Expenses 420.74 1,110.00 (689.26) 6,567.72 12,030.00 (5,462.28) 18,875.00 12,307.28 65.2% Total Expenses -Golf Shop 31,619.82 25,546.00 6,073.82 190,939.64 187,145.00 3,794.64 259,453.00 68,513.36 26.4% Net Income (13,262.80) (6,746.00) (6,516.80) (114,927.06) (105,869.00) (2,056.51) (151,305.00) (39,342.09) 26.0% 3 SilverRock Resort Course Maintenance Expense Statement March 2024 Month to Date Year to Date Annual Budget March 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 6311325 Insurance -Workers Comp 6311720 Salaries 6311800 Taxes -Employer Payroll 6311880 Wages -Hourly 6311882 Wages -Overtime Total -CM -SALARIES & BENEFITS 63 -CM -SUPPLIES & MATERIALS 6313745 Chemicals 6313744 Fertilizer 6313746 Flowers/Plants 6313748 Fuel -Gasoline 6313750 Golf Course Accessories 6313756 POA Control 6313758 Miscellaneous Supp 6313776 Sand 6313778 Seed 6313780 Small Tools & Non -Capital Equip 6313782 Sod 6313784 Topdressing Total -CM -SUPPLIES & MATERIALS 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 6315685 CM-R&M-Bldngs & Othr Structures 6315690 CM -R&M -Equipment 6315692 CM -R&M -Irrigation System 6315696 CM -R&M -Pumps 6315815 CM -R&M -Trees -Pruning Etc Total -CM-Repair & Maintenance 6317836 Utilities -Natural Gas/LPG 6317840 Telephones Total -CM -UTILITIES 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 6319100 Contract Svcs-Soil/Tissue Test 6319102 Contract Svcs -Trash Removal 6319150 Dues & Subscriptions 6319170 Employee Education 6319197 Equipment Rental 6319206 Licenses & Permits 6319490 Miscellaneous 6319718 Safety Equipment & Training 6319822 Uniforms Total -CM -OTHER EXPENSES 11,000.59 9,696.00 1,304.59 3,770.00 3,776.00 (6.00) 22,615.38 16,716.00 5,899.38 8,651.32 7,595.00 1,056.32 63,995.09 58,680.00 5,315.09 1,121.45 2,500.00 (1,378.55) 111,153.83 98,963.00 12,190.83 1,469.93 - 1,469.93 10,072.70 3,500.00 6,572.70 3,500.00 (3,500.00) 2,298.23 5,700.00 (3,401.77) 2,000.00 (2,000.00) 870.75 500.00 3,108.71 443.15 169.61 575.00 370.75 3,108.71 443.15 (405.39) 18,433.08 15,775.00 2,658.08 4,100.00 403.78 3,315.71 5,321.02 5,143.00 250.00 2,000.00 1,250.00 1,000.00 4,000.00 (1,043.00) 153.78 1,315.71 4,071.02 (1,000.00) (4,000.00) 13,140.51 13,643.00 (502.49) 32.01 (194.77) (162.76) 15.00 850.00 865.00 400.00 400.00 17.01 (1,044.77) (1,027.76) 524.00 (524.00) 2,400.00 (2,400.00) 200.00 (200.00) 1,000.00 (1,000.00) 290.03 100.00 190.03 140.00 200.00 (60.00) 1,874.77 1,210.00 664.77 2,704.80 6,034.00 (3,329.20) 70,470.05 30,382.06 148,455.96 53,723.96 444,196.70 28,475.14 78,750.00 31,925.00 150,420.00 64,451.00 482,177.00 28,436.00 (8,279.95) (1,542.94) (1,964.04) (10,727.04) (37,980.30) 39.14 775,703.87 836,159.00 (60,455.13) 40,373.03 105,966.16 7,523.68 56,051.49 8,232.86 9,290.64 5,267.01 53,448.09 142,792.68 6,135.92 7,393.10 1,919.62 35,500.00 85,400.00 7,000.00 51,300.00 16,000.00 20,000.00 5,250.00 13,500.00 190,500.00 5,300.00 11,000.00 6,000.00 4,873.03 20,566.16 523.68 4,751.49 (7,767.14) (10,709.36) 17.01 39,948.09 (47,707.32) 835.92 (3,606.90) (4,080.38) 444,394.28 446,750.00 (2,355.72) 37,300.00 46,287.00 (8,987.00) 1,722.94 4,800.00 (3,077.06) 45,774.28 31,500.00 14,274.28 28,228.79 19,300.00 8,928.79 12,276.52 9,000.00 3,276.52 17,630.00 10,050.00 7,580.00 142,932.53 120,937.00 21,995.53 162.87 135.00 27.87 15,896.10 7,650.00 8,246.10 16,058.97 7,785.00 8,273.97 3,600.00 3,600.00 3,000.00 (3,000.00) 4,716.00 (4,716.00) 2,372.93 200.00 2,172.93 350.00 3,750.00 (3,400.00) 2,900.00 (2,900.00) 700.00 1,400.00 (700.00) 1,527.02 900.00 627.02 140.00 3,550.00 (3,410.00) 6,794.67 10,890.00 (4,095.33) 15,484.62 34,906.00 (19,421.38) 107,838.00 37,367.95 34.7% 42,860.00 12,477.94 29.1% 200,000.00 51,544.04 25.8% 86,375.00 32,651.04 37.8% 652,304.00 208,107.30 31.9% 33,620.00 5,144.86 15.3% 1,122,997.00 347,293.13 30.9% 46,500.00 111,800.00 7,000.00 68,400.00 16,000.00 20,000.00 5,950.00 13,500.00 190,500.00 7,025.00 15,500.00 19,000.00 6,126.97 13.2% 5,833.84 5.2% (523.68) -7.5% 12,348.51 18.1% 7,767.14 48.5% 10,709.36 53.5% 682.99 11.5% (39,948.09) 47,707.32 25.0% 889.08 12.7% 8,106.90 52.3% 17,080.38 89.9% 521,175.00 76,780.72 14.7% 61,716.00 5,550.00 38,500.00 23,300.00 10,500.00 14,050.00 24,416.00 39.6% 3,827.06 69.0% (7,274.28) -18.9% (4,928.79) -21.2% (1,776.52) -16.9% (3,580.00) -25.5% 153 616.00 10,683.47 7.0% 180.00 10,200.00 17.13 0.0% (5,696.10) -55.8% 10 380.00 (5,678.97) -54.7% 4,800.00 4,500.00 6,288.00 680.00 3,900.00 3,400.00 4,300.00 1,200.00 3,850.00 14,520.00 1,200.00 25.0% 4,500.00 100.0% 6,288.00 100.0% (1,692.93) -249.0% 3,550.00 91.0% 3,400.00 100.0% 3,600.00 83.7% (327.02) -27.3% 3,710.00 96.4% 7,725.33 53.2% 47,438.00 31,953.38 67.36% 4 SilverRock Resort Course Maintenance Expense Statement March 2024 4 Silverrock Resort Course Maintenance Water & Energy March 2024 Month to Date Year to Date Annual Budget March 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 23,409.68 12,500.00 10,909.68 253,785.92 112,500.00 141,285.92 150,000.00 (103,785.92) -69.2% -69.2% 17.8% 6321880 Contract Labor Total Contract Service 23,409.68 12,500.00 10,909.68 253,785.92 112,500.00 141,285.92 150,000.00 (103,785.92) Total -COURSE MAINTENANCE 168,679.14 147,780.00 20,899.14 1,648,360.19 1,559,037.00 89,323.19 2,005,606.00 357,245.81 4 Silverrock Resort Course Maintenance Water & Energy March 2024 Month to Date Year to Date Annual Budget March 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 18,054.36 3,137.61 14,100.00 7,150.00 3,954.36 (4,012.39) 165,745.17 76,173.13 125,240.00 82,675.00 40,505.17 (6,501.87) 144,810.00 115,484.00 (20,935.17) 39,310.87 -14.5% 34.0% 7.1% 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total -CM -WATER & ENERGY 21,191.97 21,250.00 t58.03) 241,918.30 207,915.00 34,003.30 260,294.00 18,375.70 4 5 SilverRock Resort Outside Services Expense Statement March 2024 Month to Date Year to Date Annual Budget March 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance -Group 501.37 774.00 (272.63) 4,804.09 6,966.00 (2,161.91) 9,288.00 4,483.91 48.3% 6411325 Insurance -Workers Comp 2,600.00 2,620.00 (20.00) 16,511.01 16,304.00 207.01 21,662.00 5,150.99 23.8% 6411800 Taxes -Employer Payroll 5,367.74 4,010.00 1,357.74 21,534.10 24,953.00 (3,418.90) 33,156.00 11,621.90 35.1% 6411880 Wages -Hourly 34,614.47 32,205.00 2,409.47 171,345.87 200,422.00 (29,076.13) 266,317.00 94,971.13 35.7% 6411882 Wages -Overtime 4,780.49 - 4,780.49 17,205.51 - 17,205.51 (17,205.51) 0.0% Total -CBR -SALARIES & BENEFITS 47,864.07 39,609.00 8,255.07 231,400.58 248,645.00 (17,244.42) 330,423.00 99,022.42 30.0% 641 -CBR -SUPPLIES & MATER/ALS 6413732 Supplies -Carts 187.54 50.00 137.54 2,431.86 1,700.00 731.86 I 1,850.00 0.0% 6413742 Supplies -Expendable 514.52 150.00 364.52 5,298.19 5,600.00 (301.81) 6,750.00 1,451.81 21.5% 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 375.00 (288.95) 525.00 438.95 83.6% 6413768 Supplies -Printing and Stationary - 70.00 (70.00) - 210.00 (210.00) 420.00 420.00 100.0% 6413786 Supplies -Towels 400.00 250.00 150.00 2,796.34 1,610.00 1,186.34 2,182.00 (614.34) -28.2% 6413796 Supplies -Bottled Water 7,988.04 2,500.00 5,488.04 22,388.04 22,500.00 (111.96) 30,000.00 7,611.96 25.4% Total -CBR -SUPPLIES & MATERIALS 9,090.10 3,070.00 6,020.10 47,681.73 41,995.00 5,686.73 51,727.00 4,627.13 8.9% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 7,618.85 300.00 7,318.85 23,066.35 2,700.00 20,366.35 3,600.00 (19,466.35) -540.7% 6415695 CBR -R&M -Cart Maintenance & Repa 3,648.00 1,503.00 2,145.00 14,344.14 13,527.00 817.14 18,036.00 3,691.86 20.5% Total -CBR -REPAIRS & MAINTENANCE 11,266.85 1,803.00 9,463.85 37,410.49 16,227.00 21,183.49 21,636.00 (15 774.49) -72.9% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 671.72 800.00 (128.28) 4,736.82 7,200.00 (2,463.18) 9,600.00 4,863.18 50.7% 6419220 FreightlDelivery - - - - 450.00 (450.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 1,699.89 5,400.00 (3,700.11) 7,200.00 5,500.11 76.4% 6419820 Uniforms- 500.00 (500.00) 3,272.07 3,500.00 (227.93) 5,200.00 1,927.93 37.1% Total -CBR -OTHER EXPENSES 671.72 1,900.00 (1,228.28) 9,708.78 16,550.00 (6,841.22) 22,450.00 12,741.22 56.8% TOTAL-CARTS,BAGROOM & RANGE 68,892.74 46,382.00 (1,228.28) 326,201.58 323,417.00 2,784.58 426,236.00 100,616.28 23.6% 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 1,015.00 1,015.00 - 6,266.46 6,095.00 171.46 7,766.00 1,499.54 19.3% 6431800 Taxes -Employer Payroll 2,449.02 1,217.00 1,232.02 8,856.23 7,308.00 1,548.23 9,308.00 451.77 4.9% 6431880 Wages -Hourly 14,105.44 12,478.00 1,627.44 70,635.90 74,936.00 (4,300.10) 95,471.00 24,835.10 26.0% 6431882 Wages -Overtime 0.0% Total -CS -SALARIES & BENEFITS 17,569.46 14,710.00 2,859.46 85,758.59 88,339.00 (2,580.41) 112,545.00 26,786.41 23.8% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable - 100.00 (100.00) 766.78 800.00 (33.22) 1,050.00 283.22 27.0% 6439490 Miscellaneous - - - 32.60 200.00 (167.40) 200.00 167.40 83.7% 6439718 Safety Equipment & Training 140.00 50.00 90.00 140.00 450.00 (310.00) 600.00 460.00 76.7% 6439820 Uniforms - 75.00 (75.00) 1,671.37 1,575.00 96.37 2,125.00 453.63 21.3% Total -CS -OTHER EXPENSES 140.00 225.00 (85.00) 2,610.75 3,025.00 (414.25) 3,975.00 1,364.25 34.3% Total -COURSE SERVICES 17,709.46 14,935.00 2,774.46 88,369.34 91,364.00 (2,994.66) 116,520.00 28,150.66 24.2% TOTAL OUTSIDE SERVICES 86,602.20 61,317.00 25,285.20 414 570.92 414,781.00 (210.08) 542,756.00 127,402.69 23.5% 5 6 SilverRock Resort Clubhouse Expense Statement March 2024 Month to Date Year to Date Annual Budget March Annual 2024 Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATER/ALS 6503742 Supplies -Expendable 400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0% Total -CH -SUPPLIES & MATER/ALS 400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 1,417.64 1,000.00 417.64 8,093.08 9,000.00 (906.92) 12,000.00 3,906.92 32.6% 6507840 Utilities -Telephone 1,192.97 1,750.00 (557.03) 13,925.60 15,750.00 (1,824.40) 21,000.00 7,074.40 33.7% 6507842 Utilities -Water 591.04 321.00 270.04 5,209.57 2,889.00 2,320.57 3,852.00 (1,357.57) -35.2% 6507844 Utilities -Cable 420.07 380.00 40.07 3,980.13 3,420.00 560.13 4,560.00 579.87 12.7% Total -CH -UTILITIES 3,621.72 3,451.00 170.72 31,208.38 31,059.00 149.38 41,412.00 10,203.62 24.6% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 617.64 2,850.00 (2,232.36) 25,592.95 25,650.00 (57.05) 34,200.00 8,607.05 25.2% 6509099 Contract Services -Security 7,911.84 6,800.00 1,111.84 68,183.60 61,200.00 6,983.60 81,600.00 13,416.40 16.4% 6509215 Flowers & Decorations - 500.00 (500.00) - 1,500.00 (1,500.00) 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - - - - - - - 0.0% 6509718 Safety Equipment & Training 140.00 100.00 40.00 140.00 900.00 (760.00) 1,200.00 1,060.00 88.3% Total -CH -OTHER EXPENSES 8,669.48 10,250.00 (1,580.52) 93,916.55 89,250.00 4,666.55 118,900.00 24,983.45 21.0% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 721.91 300.00 421.91 5,042.86 2,700.00 2,342.86 3,600.00 (1,442.86) -40.1% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) 3,537.00 6,300.00 (2,763.00) 8,400.00 4,863.00 57.9% 6515690 CH -R&M -Equipment Repair 635.53 700.00 (64.47) 1,619.89 6,300.00 (4,680.11) 8,400.00 6,780.11 80.7% Total -CH -REPAIRS & MAINTENANCE 1,357.44 1,700.00 (342.56) 10,199.75 15,300.00 (5,100.25) 20,400.00 10,200.25 50.0% Total CLUBHOUSE 14,048.64 15,801.00 (1,752.36) 138,924.68 139,209.00 (284.32) 185,512.00 20,400.50 11.0% 6 7 SilverRock Resort Marketing Expense Statement March 2024 Month to Date Year to Date Annual Budget March Annual 2024 Final Budget Variance Final Budget Variance Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group 376.77 387.00 (10.23) 1,520.54 1,548.00 (27.46) 2,709.00 1,188.46 43.9% 6601325 Insurance -Workers Comp 100.00 102.00 (2.00) 702.00 918.00 (216.00) 1,220.00 518.00 42.5% 6601720 Salaries 1,875.00 1,250.00 625.00 12,500.00 11,250.00 1,250.00 15,000.00 2,500.00 16.7% 6601800 Tax -Employer Payroll 183.00 122.00 61.00 1,320.00 1,098.00 222.00 1,463.00 143.00 9.8% Total -MKT -SALARIES & BENEFITS 2,534.77 1,861.00 673.77 16,042.54 14,814.00 1,228.54 20,392.00 4,349.46 21.3% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office- 100.00 (100.00) 241.72 900.00 (658.28) 1,200.00 958.28 79.9% 6603768 Supplies -Printing & Stationery - 125.00 (125.00) 6,145.23 4,050.00 2,095.23 4,425.00 (1,720.231 -38.9% Total -MKT -SUPPLIES & MARKET/NG - 225.00 (225.00) 6,386.95 4,950.00 1,436.95 5,625.00 (761.95) -13.5% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 205.12 100.00 105.12 1,685.99 900.00 785.99 1,200.00 (485.99) -40.5% Total -MKT -UTILITIES 205.12 100.00 105.12 1,685.99 900.00 785.99 1,200.00 (485.99) -40.5% 66 -MKT -OTHER EXPENSES 6609010 Advertising 10,941.99 15,341.00 (4,399.01) 71,694.25 104,529.00 (32,834.75) 129,762.00 58,067.75 44.7% 6609040 Business Meals- 25.00 (25.00) 74.33 225.00 (150.67) 300.00 225.67 75.2% 6609080 Collateral Material 956.14 500.00 456.14 12,572.82 3,000.00 9,572.82 5,500.00 (7,072.82) -128.6% 6609102 Contract Services -Web Page- 150.00 (150.00) - 1,350.00 (1,350.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions- 300.00 (300.00) - 735.00 (735.00) 350.00 350.00 100.0% 6609620 Postage- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0% 6609490 Miscellaneous- 50.00 (50.00) - 450.00 (450.00) 700.00 700.00 100.0% 6609630 Promotion- - - 111.57 1,000.00 (888.43) 2,250.00 2,138.43 95.0% 6609633 Promotion-Cummunity- 75.00 (75.00) 625.00 2,025.00 (1,400.00) 1,000.00 375.00 37.5% 6609634 Promotion-MediaNendor- 50.00 (50.00) 1,040.40 550.00 490.40 735.00 (305.40) -41.6% 6609820 Uniforms - 50.00 (50.00) 230.63 550.00 (319.37) 600.00 369.37 61.6% Total -MKT -OTHER EXPENSES 11,898.13 16,591.00 (4,692.87) 86,349.00 114,664.00 (28,315.00) 143,597.00 57,248.00 39.9% TOTAL MARKETING 14,638.02 18,777.00 (4,138.98) 110,464.48 135,328.00 (24,863.52) 170,814.00 60,349.52 35.3% 7 SilverRock Resort General and Administrative Expense Statement March 2024 Month to Date Year to Date Annual Budget March 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 4,661.11 3,117.00 1,544.11 37,400.20 28,053.00 9,347.20 37,404.00 3.80 0.0% 6701325 Insurance -Workers Comp 1,950.00 1,951.00 (1.00) 17,343.84 18,400.00 (1,056.16) 24,251.00 6,907.16 28.5% 6701720 Salaries 21,824.40 20,141.00 1,683.40 168,158.00 181,269.00 (13,111.00) 266,243.00 98,085.00 36.8% 6701800 Taxes -Employer Payroll 2,719.56 2,338.00 381.56 20,624.80 22,053.00 (1,428.20) 29,069.00 8,444.20 29.0% 6701880 Wages -Hourly 4,951.58 3,840.00 1,111.58 62,886.56 44,928.00 17,958.56 31,900.00 (30,986.56) -97.1% 6701882 Wages -Overtime 31.05 - 31.05 76.66 - 76.66 - - Total -G&A -SALARIES & BENEFITS 36,137.70 31,387.00 4,750.70 306,490.06 294,703.00 11,787.06 388,867.00 82,376.94 21.2% 67 -G&A -SUPPLIES & MATERIALS 6703740 Supplies -Computer 245.85 500.00 (254.15) 1,996.24 4,500.00 (2,503.76) 6,300.00 4,303.76 68.3% 6703762 Supplies -Office 14.10 105.00 (90.90) 596.68 945.00 (348.32) 1,260.00 663.32 52.6% 6703768 Supplies -Printing & Stationery 165.92 400.00 (234.08) 1,693.23 2,100.00 (406.77) 3,300.00 1,606.77 48.7% Total -G&A -SUPPLIES & MATERIALS 425.87 1,005.00 (579.13) 4,286.15 7,545.00 (3,258.85) 10,860.00 6,573.85 60.5% 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment- 100.00 (100.00) 165.78 1,600.00 (1,434.22) 1,900.00 1,734.22 91.3% Total--G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 165.78 1,600.00 (1,434.22) 1,900.00 1,734.22 91.3% 67 -G&A -OTHER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 25.0% 6709150 Dues & Subscriptions - 50.00 (50.00) 482.05 850.00 (367.95) 1,550.00 1,067.95 68.9% 6709180 Employee Recruiting/Relocation 208.32 200.00 8.32 1,980.33 1,200.00 780.33 1,200.00 (780.33) -65.0% 6709197 Equipment Rental 909.36 550.00 359.36 7,495.92 4,950.00 2,545.92 6,600.00 (895.92) -13.6% 6709202 Fees -Bank 53.96 90.00 (36.04) 502.78 810.00 (307.22) 1,080.00 577.22 53.4% 6709208 Fees -Payroll Processing 3,809.66 1,000.00 2,809.66 15,619.36 9,000.00 6,619.36 12,000.00 (3,619.36) -30.2% 6709220 Freight/Delivery - 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0% 6709490 Miscellaneous 43.94 100.00 (56.06) 8,138.89 5,700.00 2,438.89 6,000.00 (2,138.89) -35.6% 6709620 Postage/Mail Services - 75.00 (75.00) 994.82 675.00 319.82 900.00 (94.82) -10.5% 6709625 Expense Professional Fees 2,474.50 3,500.00 (1,025.50) 13,093.89 23,500.00 (10,406.11) 28,000.00 14,906.11 53.2% 6709636 Promotion/Entertainment - 100.00 (100.00) 94.61 900.00 (805.39) 1,200.00 1,105.39 92.1% 6709722 Seminars & Training 600.00 200.00 400.00 1,553.78 2,800.00 (1,246.22) 3,400.00 1,846.22 54.3% 6709810 Travel - - - - 200.00 (200.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms 340.83 75.00 265.83 1,756.94 825.00 931.94 1,050.00 (706.94) -67.3% Total -G&A -OTHER EXPENSES 8,940.57 6,490.00 2,450.57 56,213.37 56,360.00 (146.63) 70,680.00 14,466.63 20.5% Total -GENERAL & ADMINISTRATIVE 45.504.14 38.982.00 6.522.14 367.155.36 360.208.00 6.947.36 472,307.00 105.151.64 22.3% 8 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement March 2024 Month to Date Year to Date Annual Budget March 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 112,344.00 (39,088.37) 154,344.00 81,088.37 52.5% 6800193 Equipment Leases -Maintenance 17,907.91 18,150.00 (242.09) 164,763.59 163,350.00 1,413.59 217,800.00 53,036.41 24.4% 6800196 Equipment Leases -GPS 4,664.00 2,750.00 1,914.00 27,808.00 24,750.00 3,058.00 33,000.00 5,192.00 15.7% 6800197 Equipment Leases -Others 1,217.14 1,950.00 (732.86) 9,788.58 14,350.00 (4,561.42) 20,200.00 10,411.42 51.5% Total -LEASES I 23,789.05 36,850.00 (13,060.95) 1 275,615.80 314,794.00 (39,178.20) i 425,344.00 149,728.20 35.2% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 98,028.00 98,028.00 - 130,704.00 32,676.00 25.0% 6900210 FF&E Reserve 15,129.84 14,024.00 1,105.84 66,359.98 62,597.00 3,762.98 82,217.00 15,857.02 19.3% 6900323 Insurance -Commercial 6,698.74 8,917.00 (2,218.26) 61,254.42 80,253.00 (18,998.58) 107,000.00 45,745.58 42.8% 6900800 Personal Property Taxes - - - 15,268.68 11,800.00 3,468.68 11,800.00 (3,468.68) -29.4% Tota/-M/SC OTHER EXPENSES 32,720.58 33,833.00 (1,112.42) 240 911.08 252 678.00 111,766.92) 331,721.00 90,809.92 27.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 2023 2023 2023 2023 2023 2023 July August September October November December 9 3 26 7 16 4 4 10 7 11 14 7 31 4 16 12 9 55 6 38 0 24 25 66 98 2024 2024 2024 2024 2024 2024 January February March April May June 4 Golf Industry 6 VIP Celebrity PGA Comp 13 14 6 Charity/Gift Certificate 4 4 Rain/Wind Checks 10 17 22 Club Staff 33 38 34 LQ HS Golf 12 47 60 81 113 0 0 0 10