Loading...
03 September 2023 SilverRock Resort - Monthly Financial StatementS1LVERROCK® RESORT Monthly Financial Statements July 01, 2023 - September 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 September 2023 Month to Date Year to Date Annual Budget G/L # Series Account Description September 2023 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. % Bdgt Income 400000 Golf Green Fee Revenue 63,424.00 165,648.00 (102,224.00) -61.7% 167,180.00 339,709.00 (172,529.00) 4,110,847.00 3,943,667.00 4% 401000 I Miscellaneous Golf Revenue 2,822.00 3,900.00 (1,078.00) -27.6% 8,082.00 11,150.00 (3,068.00) 156,180.00 148,098.00 5% 410000 Revenue -Golf Shop 6,343.66 8,400.00 (2,056.34) -24.5% 17,448.94 18,840.00 (1,391.06) 245,623.00 228,174.06 7% 420000 Food & Beverage Revenue 20,880.00 20,880.00 - 0.0% 59,293.00 59,293.00 - 710,099.00 650,806.00 8% Total Income 93,469.66 198,828.00 (105,358.34) -52.99% 252,003.94 428,992.00 (176,988.06) 5,222,749.00 4,970,745.06 5% Cost of Goods Sold I 510000 COS -Golf Shop 3,461.81 4,701.00 (1,239.19) 26.4% 9,049.85 10,545.00 1,495.15 137,475.00 128,425.15 7% 520000COS-Food & Beverage 7,396.00 7,396.00 - 0.0% 22,044.00 22,044.00 - 218,834.00 196,790.00 10% Total COS 10,857.81 12,097.00 (1,239.19) 10.2% 31,093.85 32,589.00 1,495.15 356,309.00 325,215.15 9% Gross Profit 82,611.85 186,731.00 (104,119.15) -55.8% 220,910.09 396,403.00 (175,492.91) 4,866,440.00 4,645,529.91 5% Expenses 610000 Golf Pro Shop 18,449.16 16,074.00 2,375.16 -14.8% 48,610.06 48,222.00 388.06 259,447.00 210,836.94 19% 630000 Course Maintenance 187,370.88 150,712.00 36,658.88 -24.3% 449,499.39 414,187.00 35,312.39 2,005,608.00 1,556,108.61 22% 633000 Maintenance Water & Energy 26,566.74 24,610.00 1,956.74 -8.0"/ 90,021.52 72,220.00 17,801.52 282,424.00 192,402.48 32% 640000 Outside Services 19,300.37 27,794.00 (8,493.63) 30.6% 82,614.01 80,028.00 2,586.01 542,757.00 460,142.99 15% 650000 Clubhouse 15,228.07 15,301.00 (72.93) 0.5% 43,582.29 45,903.00 (2,320.71) 185,512.00 141,929.71 23% 660000 Marketing 10,425.23 5,635.00 4,790.23 -85.0% 22,111.85 14,715.00 7,396.85 170,814.00 148,702.15 13% 670000 General & Administrative 41,339.50 39,598.00 1,741.50 -4.4"/ 124,142.62 122,470.00 1,672.62 472,307.00 348,164.38 26% 680000 Leases 32,474.24 32,636.00 (161.76) 0.5% 96,603.57 97,908.00 (1,304.43) 425,344.00 328,740.43 23% 690000 Miscellaneous Other Expense 12,269.20 27,122.00 (14,852.80) 54.8% 61,653.53 75,421.00 (13,767.47) 343,521.00 281,867.47 620000 Food & Beverage Expenses 31,459.00 31,459.00 - 0.0% 91,212.00 91,212.00 - 491,697.00 400,485.00 18% Total Expenses 394,882.39 370,941.00 23,941.39 -6.5% 1,110,050.84 1,062,286.00 (47,764.84) 5,179,431.00 3,668,895.16 21% Net Income (312,270.54) (184,210.00) (128,060.54) -115.2% (889,140.75) (665,883.00) (223,257.75) (312,991.00) 976,634.75 400000 Rounds of Golf Played Paid Rounds Played 834 2,400 (1,566) -65.3% 2,849 6,000 (3,151) 41,996 39,147 7% Ave $ Per Paid Round Green Fee 76.05 69.02 7.03 10.2% 58.68 56.62 2.06 97.89 39.21 60% Ave $ Per Paid Round Merchandise 7.61 3.50 4.11 117.3% 6.12 3.14 2.98 5.85 (0.28) 105% Ave $ Per Paid Miscellaneous 3.38 1.63 1.76 108.2% 2.84 1.86 0.98 3.72 0.88 76% 1 2 SilverRock Resort Statement of Fees - Revenue September 2023 Month to Date Year to Date Annual Budget September Income 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 63,424.00 165,648.00 (102,224.00) 167,180.00 339,709.00 (172,529.00) 4,110,847.00 3,943,667.00 95.9% 4010000 Rider Fee 410.00 1,500.00 (1,090.00) 1,575.00 3,600.00 (2,025.00) 17,480.00 15,905.00 91.0% 4040000 Club Rental 650.00 1,000.00 (350.00) 2,375.00 2,550.00 (175.00) 29,800.00 27,425.00 92.0% 4050000 Driving Range 1,515.00 1,400.00 115.00 3,885.00 4,500.00 (615.00) 97,350.00 93,465.00 96.0% 4060000 Handicap Fees 247.00 - 247.00 247.00 - 247.00 1,550.00 1,303.00 84.1% 4090000 Ball Retriever/Subcontract - - - - 500.00 (500.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 2,822.00 3,900.00 (1,078.00) 8,082.00 11,150.00 (3,068.00) 156,180.00 148,098.00 94.8% 66,246.00 169,548.00 (103,302.00) 175,262.00 350,859.00 (175,597.00) 4,267,027.00 4,091,765.00 95.9% Total Revenue Fees Total Income 1 66,246.00 169,548.00 (103,302.00) 175,262.00 350,859.00 (175,597.00) 4,267,027.00 4,091,765.00 95.90/0 2 3 SilverRock Resort Golf Shop Income Statement September 2023 Month to Date I Year to Date Annual Budget September I Income 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 781.00 - 781.00 1,979.14 - 1,979.14 0 0 0% 4100110 Sales Hard Goods 1,898.54 6,300.00 (4,401.46) 7,739.96 14,130.00 (6,390.04) 61,406.00 53,666.04 87.4% 4100112 Sales -Soft Goods 4,921.00 2,100.00 2,821.00 13,388.25 4,710.00 8,678.25 184,217.00 170,828.75 92.7% 5100639 GS-Discounts-Mdse (1,256.88) - (1,256.88) (5,658.41) - (5,658.41) - 5,658.41 0.0% Total Revenue Golf Shop 6,343.66 8,400.00 (799.46) 17,448.94 18,840.00 4,267.35 245,623.00 224,494.79 91.4% COS 5100150 COS-GS-Hard Goods 1,120.00 1,218.00 (98.00) 3,637.34 2,732.00 905.34 35,615.00 31,977.66 89.8% 5100151 COS-GS-Soft Goods 2,340.00 3,654.00 (1,314.00)1 5,546.90 8,196.00 (2,649.10) 106,846.00 101,299.10 94.8% 5100152 COS-GS-Purchase Disc (35.64) (244.00) (1,256.88) (35.64) (547.00) 511.36 (7,123.00) (7,087.36) 0.0% 5100220 COS-GS-Freight Merch 37.45 73.00 (35.55) (98.75) 164.00 (262.75) 2,137.00 2,235.75 104.6% Cost of Sales - Golf Shop 3,461.81 4,701.00 (2,704.43) I 9,049.85 10,545.00 (1,495.15) 137,475.00 128,425.15 93.4% Gross Profit 2,881.85 3,699.00 1,904.97 8,399.09 8,295.00 5,762.50 108,148.00 96,069.64 88.8% COS % 54.6% 56.0% 1.4% 51.9% 56.0% 4.1% 53.1% 57.2% 107.8% Expense 61-PS-SALARIES & BENEFITS 6101320 Insurance Group 407.06 774.00 (366.94) 1,039.68 2,322.00 (1,282.32) 9,288.00 8,248.32 88.8% 6101325 Insurance-Workers Comp 950.50 979.00 (28.50) 2,651.96 2,937.00 (285.04) 15,959.00 13,307.04 83.4% 6101720 Salaries 8,653.86 6,436.00 2,217.86 20,192.34 19,308.00 884.34 77,250.00 57,057.66 73.9% 6101800 Taxes-Employer Payroll 1,249.05 1,174.00 75.05 3,270.77 3,522.00 (251.23) 19,129.00 15,858.23 82.9% 6101880 Wages-Hourly 6,760.99 5,601.00 1,159.99 20,842.72 16,803.00 4,039.72 118,952.00 98,109.28 82.5% 6101882 Wages-Overtime 268.62 - 268.62 268.62 - 268.62 - (268.62) 0.0% Total -PS-SALARIES & BENEFITS 18,290.08 14,964.00 3,326.08 48,266.09 44,892.00 3,374.09 240,578.00 192,311.91 79.9% 61-PS OTHER EXPENSES 6103762 Supplies-Office - 250.00 (250.00) 65.94 750.00 (684.06) 3,000.00 2,934.06 97.8% 6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 100.0% 6109220 Freight & Delivery - - _ i - - - 75.00 75.00 100.0% 6109490 Miscellaneous 40.13 500.00 (459.87) 40.13 1,500.00 (1,459.87) 6,000.00 5,959.87 99.3% 6109722 Seminars/Training - 150.00 (150.00)- 450.00 (450.00) 3,690.00 3,690.00 100.0% 6109810 Travel - Merchandise - - - _ - - 90.00 90.00 100.0% 6109820 Uniforms - 100.00 (100.00) - 300.00 (300.00) 2,400.00 2,400.00 100.0% 6117840 Telephones 118.95 110.00 8.95 237.90 330.00 (92.10) 1,320.00 1,082.10 82.0% Total - Other Expenses 159.08 1,110.00 (950.92) 343.97 3,330.00 (2,986.03) 18,875.00 18,531.03 98.2% Total Expenses-Golf Shop 18,449.16 16,074.00 2,375.16 48,610.06 48,222.00 388.06 259,453.00 210,842.94 81.3% Net Income (15,567.31) (12,375.00) (3,192.31) (40,210.97) (39,927.00) 5,374.44 (151,305.00) (114,773.30) 75.9% 3 4 SilverRock Resort Course Maintenance Expense Statement September 2023 Month to Date Year to Date , Annual Budget September 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 6,354.26 8,148.00 (1,793.74) 20,856.62 21,348.00 (491.38) 107,838.00 86,981.38 80.7% 6311325 Insurance -Workers Comp 3,050.00 3,347.00 (297.00) 8,032.06 9,298.00 (1,265.94) 42,860.00 34,827.94 81.3% 6311720 5918,08 22,037.07 16,713.00 5,324.07 51,419.83 50,139.00 1,280.83 200,000.00 148,580.17 74.3% 6311800 Taxes -Employer Payroll 6,826.99 6,745.00 81.99 12,999.32 18,657.00 (5,657.68) 86,375.00 73,375.68 85.0% 6311880 W08es-Hourly 61,368.97 49,875.00 11,493.97 148,123.21 136,467.00 11,656.21 652,304.00 504,180.79 77.3% 6311882 Wa9es-Overtime 8,907.10 2,592.00 6,315.10 13,906.23 4,752.00 9,154.23 33,620.00 19,713.77 58.6% Total -CM -SALARIES & BENEFITS 108,544.39 87,420.00 21,124.39 255,337.27 240,661.00 14,676.27 1,122,997.00 867.659.73 77.3% 63 -CM -SUPPLIES .6 MATERIALS 6313734 Chemicals 6,138.27 - 6,138.27 10,818.12 - 10,818.12 46,500.00 35,681.88 76.7% 6313744 Fertilizer 3,284.25 9,000.00 (5,715.75) 16,831.74 18,400.00 (1,568.26) 111,800.00 94,968.26 84.9% 6313745 Herbicides 8,000.00 (8,000.00) - 22,500.00 (22,500.00) - - 0.0% 0313746 Flowers/Plants - -•- - 7,000.00 7,000.00 100.0% 6313748 Fuel -Gasoline 6,238.38 5,700.00 538.38 14,670.60 17,100.00 (2,429.40) 68,400.00 53,729.40 78.6% 6313750 Golf Course Accessories - _ - - 16,000.00 16,000.00 100.0% 6313756 POA Control• •- 20,000.00 20,000.00 100.0% 6313758 Miscellaneous Supp 129.81 750.00 (620.19) 430.22 2,250.00 (1,819.78) 5,950.00 5,519.78 92.8% 6313762 Pesticides - 0.0% 6313766 Sand 5,347.45 - 8,477.09 - 13,500.00 5,022.91 6313774 Seed 15,594.76 - 15,594.76 19,428.21 - 19,428.21 190,500.00 171,071.79 89.8% 6313776 Small Tools & Non -Capital Equip _ 600.00 (600.00) 2,751.18 1,800.00 951.18 7,025.00 4,273.82 60.8% 6313778 Sod 1,000.00 (1,000.00) 5,653.08 11,000.00 (5,346.92) 15,500.00 9,846.92 63.5% 6313780 Topdressing - 3,000.00 (3,000.00) 962.41 6,000.00 (5,037.59) 19,000.00 18,037.59 949% Total -CM -SUPPLIES & MATERIALS 36,732.92 28,050.00 3,335.47 80,022.65 79,050.00 (7,504.44) 521,175.00 441,152.35 84.6% 63 -CM -REPAIRS & MAINTENANCE 6315095 CM•R&M.Contract Lake Malnt 4,100.00 5,143.00 (1,043.00) 12,300.00 15,429.00 (3,129.00) 61,716.00 49,416.00 80.1% 6315685 CM-R&M-Bldngs & Othr Structures 117.50 550.00 (432.50) 352.48 2,550.00 (2,197.52) 5,550.00 5,197.52 93.6% 6315690 CM-R&M-Eqr2pment 7,403.35 3,000.00 4,403.35 19,349.83 7,500.00 11,849.83 38,500.00 19,150.17 497% 6315692 CM -R&M -Irrigation System 4,355.99 2,000.00 2,355.99 7,937.67 10,400.00 (2,462.33) 23,300.00 15,362.33 65.9% 6315698 CM-R&M-P09rp9 - 1,000.00 (1,000.00) - 3,000.00 (3,000.00) 10,500.00 10,500.00 100.0% 6315815 CM -R&M -Trees -Pruning Etc - 5,500.00 (5,500.00) 17,630.00 5,500.00 12,130.00 14,050.00 (3,580.00) -25.5% Total -CM -REPAIRS & MAINTENANCE 15,976.84 17,193.00 (1,216.16) 57,569.98 44,379.00 13,190.98 153.616.00 96.046.02 62.5% 6317836 Utilities -Natural Gas/LPG • 15.00 (15.00) 21.40 45.00 (23.60) 180.00 158.60 0.0% 6317840 Telephones 1,747.71 850.00 897.71 5,392.10 2,550.00 2,842.10 10200.00 4,807.90 47.1% Total -CM -UTILITIES 1,747.71 865.00 882.71 5,413.50 2,595.00 2,818.50 10.380.00 4.966.50 47.8% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 1,200.00 1,200.00- 4,800.00 3,600.00 75.0% 6319100 Contract Svcs-SoilfTissue Test _ 1,500.00 (1,500.00) - 1,500.00 (1,500.00) 4,500.00 4,500.00 100.0% 6319102 Contract Svcs -Trash Removal 524.00 (524.00) - 1,572.00 (1,572.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions 375.00 - 375.00 804.50 - 804.50 680.00 (124.50) -18.3% 6319170 Employee Education 50.00 (50.00) - 150.00 (150.00) 3,900.00 3,900.00 100.0% 6319197 Equipment Rental - 150.00 (150.00) - 500.00 (500.00) 3,400.00 3,400.00 100.0% 6319206 Licenses & Permits _ 100.00 (100.00) 4,300.00 4,300.00 100.0% 6319490 Miscellaneous 219.02 100.00 119.02 592.54 300.00 292.54 1,200.00 607.46 50.6% 6319718 Safety Equipment & Training 750.00 (750.00) - 1,050.00 (1,050.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms 549.14 1,210.00 (660.86) 733.09 3,630.00 (2,896.91) 14,520.00 13,786.91 95.0% Total•CMFOTHER EXPENSES 1,543.16 4,684.00 (3,140.84) 3,330.13 10,002.00 (6,671.87) 47,438.00 44,107.87 92.98% 4 SilverRock Resort Course Maintenance Expense Statement September 2023 4 Silverrock Resort Course Maintenance Water & Energy September 2023 Month to Date • Year to Date Annual Budget September 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 22,825.86 22,825.86 12,500.00 12,500.00 10,325.86 10,325.86 47,825.86 47,825.86 37,500.00 37,500.00 10,325.86 10,325.86 150,000.00 150,000.00 102,174.14 102.774.14 68.1% 68.1% 77.6% 6321880 Contract Labor Total Contract Service Total -COURSE MAINTENANCE 187.370.88 150.712.00 31.311.43 449.499.39 414.187.00 35.312.39 2 005 606.00 1 556 106.61 4 Silverrock Resort Course Maintenance Water & Energy September 2023 • Month to Date Year to Date Annual Budget September 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 17,071.77 9,494.97 14,210.00 10,400.00 2,861.77 (905.03) 57,896.29 32,125.23 42,520.00 29,700.00 15,376.29 2,425.23 144,810.00 115,484.00 86,913.71 83,358.77 60.0% 72.2% 65.4% 6337834 Utilities -Electricity -Pumping 6337842 068t1e6-W0ter Total -CM -WATER A ENERGY 26 566.74 24 610.00 1 956.74 90 021.52 72 220.00 17 801.52 260 294.00 170 272.48 4 5 SilverRock Resort Outside Services Expense Statement September 2023 Month to Date Year to Date Annual Budget September 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense •SALARIES & BENEFITS 6411320 Insurance -Group 502.63 774.00 (271.37) 1,388.04 2,322.00 (933.96) 9,288.00 7,899.96 85.1% 6411325 Insurance -Workers Comp 950.00 1,113.00 (163.00) 3,461.01 3,125.00 336.01 21,662.00 18,200.99 84.0% 6411800 Taxes -Employer Payroll 1,009.74 1,703.00 (693.26) 3,122.45 4,783.00 (1,660.55) 33,156.00 30,033.55 90.6% 6411880 Wa9es-Hourly 11,374.25 13,677.00 (2,302.75) 36,862.98 38,421.00 (1,558.02) 266,317.00 229,454.02 86.2% 6411882 Wages -Overtime 563.03 - 563.03 723.89 - 723.89 - (723.89) 0.0% Total -CBR -SALARIES & BENEFITS 14,399.65 17,267.00 (2,867.35) 45,558.37 48,651.00 (3,092.63) 330 423.00 284 864.63 86.2% 641 -CBR -SUPPLIES & MATERIALS 6413732 Supplies -Carts - - - - - 1,850.00 ' 0.0% 6413742 Supplies -Expendable 144.86 150.00 (5.14) 579.44 1,350.00 (770.56) 6,750.00 6,170.56 91.4% 6413748 Supplies -Fuel for Shuttle- 6413752 Supplies -Range Balls - - _ - 10,000.00 10,000.00 100.0% 6413762 Supplies -Office - 25.00 (25.00) - 75.00 (75.00) 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationar - - - _ - 420.00 420.00 100.0% 6413786 Supplies -Towels 240.00 120.00 120.00 716.34 360.00 356.34 2,182.00 1,465.66 67.2% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 6,912.00 7,500.00 (588.00) 30,000.00 23,088.00 77.0% Total -CBR -SUPPLIES & MATERIALS 384.86 2,795.00 (2,410.14) 8,207.78 9,285.00 (1,077.22) 51 727.00 41 669.22 80.6% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 300.00 (300.00) 10,493.48 900.00 9,593.48 3,600.00 (6,893.48) -191.5% 6415695 CBR -R&M -Cart Maintenance & F 1,216.00 1,503.00 (287.00) 4,176.75 4,509.00 (332.25) 18.036.00 13.859.25 76.8% Total -CBR -REPAIRS & MAINTENANCE 1,216.00 1,803.00 (587.00) 14,670.23 5,409.00 9,261.23 21 636.00 6 965.77 32.2% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Line 240.54 800.00 (559.46) 721.44 2,400.00 (1,678.56) 9,600.00 8,878.56 92.5% 6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 108.66 1,800.00 (1,691.34) 7,200.00 7,091.34 98.5% 6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0% Total -CBR -OTHER EXPENSES 240.54 1,475.00 (1,234.46) 830.10 4,425.00 (3,594.90) 22 450.00 21 619.90 96.3% TOTAL-CARTS,BAGROOM & RANGE 16,241.05 23,340.00 (1,234.46) 69,266.48 67,770.00 1,496.48 426,236.00 355,119.52 83.3% 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 292.00 (292.00) 1,051.46 806.00 245.46 7,766.00 6,714.54 86.5% 6431800 Taxes -Employer Payroll 270.52 350.00 (79.48) 1,044.93 966.00 78.93 9,308.00 8,263.07 88.8% 6431880 Wages-H0urly 2,788.80 3,587.00 (798.20) 11,180.55 9,911.00 1,269.55 95,471.00 84,290.45 88.3% 6431882 Wages -Overtime Total -CS -SALARIES & BENEFITS 88.2% 3,059.32 4,229.00 (1,169.68) 13,276.94 11,683.00 1,593.94 112 545.00 99 268.06 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 100.00 (100.00) 37.99 200.00 (162.01) 1,050.00 1,012.01 96.4% 6439490 Miscellaneous _ - 32.60 - 32.60 200.00 167.40 83.7% 6439718 Safety Equipment & Training 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0% 6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 2,125.00 2,125.00 100.0% Total -CS -OTHER EXPENSES - 225.00 (225.00) 70.59 575.00 (504.41) 3,975.00 3,904.41 98.2% Total -COURSE SERVICES 3,059.32 4,454.00 (1,394.68) 13,347.53 12,258.00 1,089.53 116,520.00 103,172.47 88.5% TOTAL OUTSIDE SERVICES 19,300.37 27 794.00 (8,493.63) 82 614.01 80 028.00 2 586.01 542 756.00 454 387.58 83.7% 5 6 SilverRock Resort Clubhouse Expense Statement September 2023 Month to Date Year to Date Annual Budget September 2023 Final Budget Variance Budget Variance Variance Annual Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATER/ALS 6503742 Supplies -Expendable 400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0% Total -CH -SUPPLIES & MATERIALS 400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 788.50 1,000.00 (211.50) 2,004.42 3,000.00 (995.58) 12,000.00 9,995.58 83.3% 6507840 Utilities -Telephone 1,608.63 1,750.00 (141.37) 5,193.64 5,250.00 (56.36) 21,000.00 15,806.36 75.3% 6507842 Utilities -Water 585.50 321.00 264.50 1,655.54 963.00 692.54 3,852.00 2,196.46 57.0% 6507844 Utilities -Cable 721.59 380.00 341.59 1,845.47 1,140.00 705.47 4,560.00 2,714.53 59.5% Total -CH -UTILITIES 3,704.22 3,451.00 253.22 10,699.07 10,353.00 346.07 41,412.00 30,712.93 74.2% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 2,848.22 2,850.00 (1.78) 8,717.73 8,550.00 167.73 34,200.00 25,482.27 74.5% 6509099 Contract Services -Security 7,640.28 6,800.00 840.28 21,099.28 20,400.00 699.28 81,600.00 60,500.72 74.1% 6509215 Flowers & Decorations - - -- - - 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - -- - - - - 0.0% 6509718 Safety Equipment & Training- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0% Total--CH-OTHER EXPENSES 10,488.50 9,750.00 738.50 29,817.01 29,250.00 567.01 118,900.00 89,082.99 74.9% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 427.75 300.00 127.75 1,558.98 900.00 658.98 3,600.00 2,041.02 56.7% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) - 2,100.00 (2,100.00) 8,400.00 8,400.00 100.0% 6515690 CH -R&M -Equipment Repair 207.60 700.00 (492.40) 307.23 2,100.00 (1,792.77) 8,400.00 8,092.77 96.3% Total -CH -REPAIRS & MAINTENANCE 635.35 1,700.00 (1,064.65) 1,866.21 5,100.00 (3,233.79) 20,400.00 18,533.79 90.9% Total CLUBHOUSE 15,228.07 15,301.00 (72.93) 43,582.29 45,903.00 (2,320.71) 185,512.00 37,067.58 20.0% 6 7 SilverRock Resort Marketing Expense Statement September 2023 Month to Date Year to Date Annual Budget September Variance Final Annual Budget Unemcumb. % Budget 2023 Final Budget Budget Variance 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) 100.00 306.00 (206.00) 1,220.00 1,120.00 91.8% 6601720 Salaries 1,875.00 1,250.00 625.00 4,375.00 3,750.00 625.00 15,000.00 10,625.00 70.8% 6601800 Tax -Employer Payroll 183.00 122.00 61.00 527.00 366.00 161.00 1,463.00 936.00 64.0% Total -MKT -SALARIES & BENEFITS 2,158.00 1,474.00 684.00 5,002.00 4,422.00 580.00 20,392.00 15,390.00 75.5% 66 -MKT -SUPPLIES & MATER/ALS 6603762 Supplies -Office - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0% 6603768 Supplies -Printing & Stationery 38.64 200.00 (161.36) 5,281.84 200.00 5,081.84 4,425.00 (856.841 -19.4% Total -MKT -SUPPLIES & MARKETING 38.64 300.00 (261.36) 5,281.84 500.00 4,781.84 5,625.00 343.16 6.1 66 -MKT -UTILITIES 6607840 Utilities -Telephone 213.60 100.00 113.60 427.20 300.00 127.20 1,200.00 772.80 64.4% Total-MK7-UTILITIES 213.60 100.00 113.60 427.20 300.00 127.20 1,200.00 772.80 64.4% 66 -MKT -OTHER EXPENSES 6609010 Advertising 8,014.99 3,461.00 4,553.99 11,400.81 8,593.00 2,807.81 129,762.00 118,361.19 91.2% 6609040 Business Meals - 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0% 6609080 Collateral Material - - - - - - 5,500.00 5,500.00 100.0 6609102 Contract Services -Web Page - 150.00 (150.00) - 450.00 (450.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) - 150.00 (150.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) - 225.00 (225.00) 1,000.00 1,000.00 100.0 6609150 Dues & Subscriptions - - - - - - 735.00 735.00 100.0 6609820 Uniforms _ _ - - - - 600.00 600.00 100.0 Total -MKT -OTHER EXPENSES 8,014.99 3,761.00 4,253.99 11,400.81 9,493.00 1,907.81 143,597.00 132,196.19 92.1% TOTAL MARKETING 10,425.23 5 635.00 4.790.23 22 111.85 14,715.00 7.396.85 170,814.00 148,702.15 87.1% 7 SilverRock Resort General and Administrative Expense Statement September 2023 Month to Date Year to Date Annual Budget 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 3,079.31 3,117.00 (37.69) 11,918.13 9,351.00 2,567.13 37,404.00 25,485.87 68.1% 6701325 Insurance -Workers Comp 1,900.00 2,138.00 (238.00) 5,893.84 6,726.00 (832.16) 24,251.00 18,357.16 75.7% 6701720 Salaries 25,124.40 20,141.00 4,983.40 62,585.60 60,423.00 2,162.60 266,243.00 203,657.40 76.5% 6701800 Taxes -Employer Payroll 2,485.33 2,563.00 (77.67) 6,939.54 8,063.00 (1,123.46) 29,069.00 22,129.46 76.1% 6701880 Wages -Hourly 7,016.07 6,144.00 872.07 26,453.00 22,272.00 4,181.00 31,900.00 5,447.00 17.1% 6701882 Wages -Overtime - - - 5.87 - 5.87 - - Total -G&A -SALARIES & BENEFITS 39,605.11 34,103.00 5,502.11 113,795.98 106,835.00 6,960.98 388,867.00 275,071.02 70.7% 67 -G&A -SUPPLIES & MATERIALS 6703740 Supplies -Computer 54.97 500.00 (445.03) 234.06 1,500.00 (1,265.94) 6,300.00 6,065.94 96.3% 6703762 Supplies -Office 122.47 105.00 17.47 182.47 315.00 (132.53) 1,260.00 1,077.53 85.5% 6703768 Supplies -Printing & Stationery - 100.00 (100.00) 635.63 300.00 335.63 3,300.00 2,664.37 80,7 Total -G&A -SUPPLIES & MATERIALS 177.44 705.00 (527.56) 1,052.16 2,115.00 (1,062.84) 10,860.00 9,807.84 90.3 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment - 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0% Total -G&A -REPAIRS & MAINTENANCE - 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0% 67 -G&A -OTHER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0% 6709150 Dues & Subscriptions - 300.00 (300.00) 233.29 350.00 (116.71) 1,550.00 1,316.71 84.9% 6709180 Employee Recruiting/Relocation 170.76 150.00 20.76 205.76 150.00 55.76 1,200.00 994.24 82.9% 6709197 Equipment Rental 685.95 550.00 135.95 1,964.99 1,650.00 314.99 6,600.00 4,635.01 70.2% 6709202 Fees -Bank - 90.00 (90.00) 90.91 270.00 (179.09) 1,080.00 989.09 91.6% 6709208 Fees -Payroll Processing 533.93 1,000.00 (466.07) 1,206.82 3,000.00 (1,793.18) 12,000.00 10,793.18 89.9% 6709220 Freight/Delivery - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0% 6709490 Miscellaneous (123.28) 100.00 (223.28) 646.37 300.00 346.37 6,000.00 5,353.63 89.2% 6709620 Postage/Mail Services 164.59 75.00 89.59 364.59 225.00 139.59 900.00 535.41 59.5% 6709625 Expense Professional Fees (375.00) 1,500.00 (1,875.00) 2,311.39 4,500.00 (2,188.61) 28,000.00 25,688.61 91.7% 6709636 Promotion/Entertainment - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0% 6709722 Seminars & Training - 200.00 (200.00) 500.00 600.00 (100.00) 3,400.00 2,900.00 85.3% 6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms - 75.00 (75.00) 270.36 225.00 45.36 1,050.00 779.64 74.3% Total -G&A -OTHER EXPENSES 1,556.95 4,690.00 (3,133.05) 9,294.48 13,320.00 (4,025.52) 70,680.00 61,385.52 86.8% Total -GENERAL & ADMINISTRATIVE 41,339.50 39.598.00 1.741.50 124.142.62 122.470.00 1.672.62 472,307.00 348.164.38 73.7% 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement September 2023 Month to Date Year to Date Annual Budget September Variance Final Annual Budget Unemcumb. % Budget 2023 Final Budget Budget Variance Expense 68 -LEASES 6800192 Equipment Leases -Carts 10,465.09 10,586.00 (120.91) 31,395.27 31,758.00 (362.73) 154,344.00 122,948.73 79.7% 6800193 Equipment Leases -Maintenance 18,310.28 18,150.00 160.28 54,930.84 54,450.00 480.84 217,800.00 162,869.16 74.8% 6800196 Equipment Leases -GPS 2,640.00 2,750.00 (110.00) 7,920.00 8,250.00 (330.00) 33,000.00 25,080.00 76.0% 6800197 Equipment Leases -Others 1,058.87 1,150.00 (91.13) 2,357.46 3,450.00 (1,092.54) 20,200.00 17,842.54 0.0% Total -LEASES 32,474.24 32,636.00 (161.76) 96,603.57 97,908.00 (1,304.43) 425,344.00 328,740.43 77.3% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 32,676.00 32,676.00 - 130,704.00 98,028.00 75.0% 6900210 FF&E Reserve 1,268.40 3,313.00 (2,044.60) 3,343.52 6,794.00 (3,450.48) 82,217.00 78,873.48 95.9% 6900323 Insurance -Commercial 108.80 8,917.00 (8,808.20) 25,634.01 26,751.00 (1,116.99) 107,000.00 81,365.99 76.0% 6900800 Personal Property Taxes - 4,000.00 (4,000.00) - 9,200.00 (9,200.00) 11,800.00 11,800.00 100.0% Tota/--M/SC OTHER EXPENSES 12,269.20 27,122.00 f 14,852.80) 61,653.53 75,421.00 f 13 767.47) 331 721.00 270,067.47 81.4% 9 SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report -2023-2024 Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf 2023 2023 2023 2023 2023 2023 July August September October November December 9 3 26 10 14 38 0 24 0 0 0 2024 2024 2024 2024 2024 2024 January February March April May June 0 0 0 0 0 0 10