Loading...
03 September 2022 SilverRock Resort - Monthly Financial StatementSILVERROCK® RESORT Monthly Financial Statements July 1, 2022 - September 30, 2022 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 a Administrative Expense Statement 8 Operating Leases Et Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement September 2022 Month to Date Year to Date Annual Budget Percentages GIL # Series Account Description September Unfavorable (-) Annual 2022 Final Budget Variance Favorable (+1 Final Budget Variance Budget Unemcumb. % Bdgt IIncome 400000 Golf Green Fee Revenue 102,095.00 151,975.00 (49,880.00) -32.8% 265,332.00 321,201.00 (55,869.00) 3,745,355.00 3,480,023.00 7% 401000 Miscellaneous Golf Revenue 7,595.00 4,400.00 3,195.00 72.6% 20,649.50 12,650.00 7,999.50 307,480.00 286,830.50 70/0 410000 Revenue -Golf Shop 9,240.98 8,225.00 1,015.98 12.4% 22,643.72 18,375.00 4,268.72 212,618.00 189,974.28 11% 420000 Food & Beverage Revenue 16,709.51 10,500.00 6,209.51 59.1% 52,748.34 35,100.00 17,648.34 585,382.00 532,633.66 9% Total Income 135,640.49 175,100.00 (39,459.51) -22.50/0 361,373.56 387,326.00 (25,952.44) 4,850,835.00 4,489,461.44 7% Cost of Goods Sold 510000 COS -Golf Shop 5,202.22 4,602.03 600.19 -13.0% 13,173.66 10,281.97 (2,891.69) 119,002.00 105,828.34 11% 520000 COS -Food & Beverage 5,843.73 5,010.00 833.73 -16.6% 20,889.19 10,020.00 (10,869.19) 199,408.00 178,518.81 10% Total COS 11,045.95 9,012.03 1,433.92 -14.9% 34,002.95 20,301.97 (13,700.98) 318,41U.OU 105,929.34 11% Gross Profit 124,594.54 165,487.97 (40,893.43) -24.7% 327,310.71 367,024.03 (39,713.32) 4,532,425.00 4,383,633.10 7% Expenses 610000 Golf Pro Shop 16,761.50 14,518.00 2,243.50 -15.5% 46,365.84 43,749.00 2,616.84 216,775.00 170,409.16 21% 630000 Course Maintenance 148,288.38 127,378.14 20,910.24 -16.4% 407,996.57 337,266.28 70,730.29 2,070,664.00 1,662,667.43 20% 633000 Maintenance Water & Energy 32,566.96 19,300.00 13,266.96 -68.7% 94,355.03 66,910.00 27,445.03 260,294.00 165,938.97 36% 640000 Outside Services 38,545.41 26,761.89 11,783.52 -44.0% 100,249.65 77,154.89 23,094.76 529,580.00 429,330.35 19% 650000 Clubhouse 14,262.46 10,301.00 3,961.46 -38.5% 39,314.89 30,903.00 8,411.89 127,492.00 88,177.11 31% 660000 Marketing 15,644.85 12,879.00 2,765.85 -21.5% 27,681.43 21,939.00 5,742.43 192,267.00 164,585.57 14% 670000 General & Administrative 37,695.69 34,790.00 2,905.69 -8.4% 98,853.03 103,520.00 (4,666.97) 451,899.00 353,045.97 22% 680000 Leases 32,802.22 31,950.00 852.22 -2.7% 87,119.53 95,850.00 (8,730.47) 389,800.00 302,680.47 22% 690000 Miscellaneous Other Expense 16,030.70 23,330.49 (7,299.79) 31.3% 58,585.60 64,496.99 (5,911.39) 293,999.00 235,413.40 620000 Food & Beverage Expenses 25,928.93 25,547.00 381.93 -1.5% 80,917.10 50,145.00 30,772.10 453,954.00 373,036.90 20% Total Expenses 378,527.10 326,755.52 51,771.58 -15.8% 1,041,438.67 891,934.16 (149,504.51)i 4,986,724.00 3,572,248.43 21% Net Income (253,932.56) (161,267.55) (92,665.01) -63.1% (714,127.96) (524,910.13) (189,217.83) (454,299.00) 811,384.67 157% 400000 Rounds of Golf Played Paid Rounds Played 1,413 1,750 (337) -19.3% 3,494 3,500 (6) 41,996 38,502 8% Ave $ Per Paid Round Green Fee 72.25 86.84 (14.59) -16.8% 75.94 91.77 (15.83) 89.18 13.24 85% Ave $ Per Paid Round Merchandise 6.54 4.70 1.84 39.1% 6.48 5.25 1.23 5.06 (1.42) 128% Ave $ Per Paid Miscellaneous 2.03 2.23 (0.19) -8.7% 2.82 3.19 (0.36) 7.32 4.50 39% 1 SilverRock Resort Statement of Fees - Revenue September 2022 Month to Date Year to Date Annual Budget September Income 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 102,095.00 151,975.00 (49,880.00) 265,332.00 321,201.00 (55,869.00) 3,745,355.00 3,480,023.00 92.9% 4010000 Rider Fee 485.00 1,500.00 (1,015.00) 1,640.00 3,600.00 (1,960.00) 18,180.00 16,540.00 91.0% 4040000 Club Rental 735.00 1,000.00 (265.00) 2,040.00 2,550.00 (510.00) 24,100.00 22,060.00 91.5% 4050000 Driving Range 1,655.00 1,400.00 255.00 5,320.00 4,500.00 820.00 87,850.00 82,530.00 93.9% 4060000 Handicap Fees - - - 266.00 - 266.00 2,050.00 1,784.00 87.0% 4090000 Ball Retriever/Subcontract - - - 592.50 500.00 92.50 2,500.00 1,907.50 76.3% 4091000 Golf Professional Rental Fee - - - - - - 7,500.00 7,500.00 100.0% 4092000 Golf Lessons - - - - - - - - 0.0% 4093000 Resident Card Issue 4,720.00 500.00 4,220.00 10,791.00 1,500.00 9,291.00 165,300.00 154,509.00 93.5% 109,690.00 156,375.00 (46,685.00) 285,981.50 333,851.00 (47,869.50) 4,052,835.00 3,766,853.50 92.9% Total Revenue Fees Total Income 1109,690.00 156,375.00 (46,685.00) 285,981.50I 333,851.00I (47,869.50) 4,052,835.00I 3,766,853.50I 92.9% I 2 SilverRock Resort Golf Shop Income Statement September 2022 Month to Date Year to Date Annual Budget Income September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 825.04 - 825.04 1,213.95 - 1,213.95 0 0 0% 4100110 Sales Hard Goods 4,249.34 2,056.00 2,193.34 10,995.07 4,594.00 6,401.07 53,155.00 42,159.93 79.3% 4100112 Sales -Soft Goods 5,111.00 6,169.00 (1,058.00) 13,323.00 13,781.00 (458.00) 159,464.00 146,141.00 91.6% 5100639 GS-Discounts•Mdse (944.40) - (944.40) (2,888.30) - (2,888.30) • 2,888.30 0.0% Total Revenue Golf Shop 9,240.98 8,225.00 1,015.98 22,643.72 18,375.00 4,268.72 212,619.00 191,189.23 89.9% COS 5100150 COS-GS-Hard Goods 2,502.16 1,191.00 1,311.16 6,367.81 2,662.00 3,705.81 30,829.00 24,461.19 79.3% 5100151 COS-GS-Soft Goods 2,499.84 3,578.00 (1,078.16) 6,160.78 7,993.00 (1,832.22) 92,489.00 86,328.22 93.3% 5100152 COS-GS-Purchase Disc - (238.53) 238.53 (33.09) (532.89) 499.80 (6,166.00) (6,132.91) 99.5% 5100220 COS-GS-Freight Merch 200.22 71.56 128.66 678.16 159.86 518.30 1,850.00 1,171.84 63.3% Cost of Sales - Golf Shop 5,202.22 4,602.03 600.19 13,173.66 10,281.97 2,891.69 119,002.00 105,828.34 88.9% Gross Profit 4,038.76 3,622.97 415.79 9,470.06 8,093.03 1,377.03 93,617.00 85,360.89 91.2% COS % 56.3% 56.0% -0.3% 58.2% 56.0% -2.2% 53.1% 55.4% 104.3% Expense 61-PS-SALARIES & BENEFITS 6101320 Insurance Group 414.45 826.00 (411.55) 1,264.32 2,478.00 (1,213.68) 9,912.00 8,647.68 87.2% 6101325 Insurance -Workers Comp 787.51 801.00 (13.49) 2,579.12 2,416.00 163.12 11,980.00 9,400.88 78.5% 6101720 Salaries 6,653.95 5,957.00 696.95 17,300.27 17,871.00 (570.73) 65,000.00 47,699.73 73.4% 6101800 Taxes -Employer Payroll 1,056.43 1,047.00 9.43 2,941.38 3,157.00 (215.62) 13,896.00 10,954.62 78.8% 6101880 Wages -Hourly 7,048.11 4,777.00 2,271.11 20,861.30 14,497.00 6,364.30 97,112.00 76,250.70 78.5% 6101882 Wages -Overtime 173.40 - 173.40 178.20 - 178.20 - (178.20) 0.0% Total -PS -SALARIES & BENEFITS 16,133.85 13,408.00 2,725.85 45,124.59 40,419.00 4,705.59 197,900.00 152,775.41 77.2% 61-PS OTHER EXPENSES 6103742 Supplies•Expendable • - • - - 0.0% 6103762 Supplies•Office 71.17 250.00 (178.83) 266.12 750.00 (483.88) 3,000.00 2,733.88 91.1% 6109220 Freight & Delivery 35.43 - 35.43 59.19 59.19 75.00 15.81 21.1% 6109490 Miscellaneous 398.60 500.00 (101.40) 398.60 1,500.00 (1,101.40) 6,000.00 5,601.40 93.4% 6109150 Dues and Subscriptions - - 2,300.00 2,300.00 100.0% 6109500 ProShop-Over/Short (10.27) - (10.27) (11.39) - (11.39) • 11.39 0.0% 6109722 SeminarslTraining 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) 130.57 300.00 (169.43) 2,400.00 2,269.43 94.6% 6117840 Telephones 132.72 110.00 22.72 398.16 330.00 68.16 1,320.00 921.84 69,8% Total - Other Expenses 627.65 1,110.00 (482.35) 1,241.25 3,330.00 (2,088.75) 18,875.00 17,633.75 93.4% Total Expenses -Golf Shop 16,761.50 14,518.00 2,243.50 46,365.84 43,749.00 2,616.84 216,775.00 170,409.16 78.6% Net Income (12,722.74) (10,895.031 (1,827.71) (36,895.78) (35,655.97) (1,239.81) (123,158.00) ( (85,048.271 69.1% 3 SilverRock Resort Course Maintenance Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63-CM-SALARIES & BENEFITS 6311320 Insurance•Group 3,982.87 8,512.00 (4,529.13) 9,987.68 22,232.00 (12,244.32) 112,882.00 102,894.32 91.2% 6311325 Insurance•Workers Comp 2,379.40 1,870.00 509.40 6,096.60 5,148.00 948.60 37,437.00 31,340.40 83.7% 6311720 Salaries 18,171.72 16,664.00 1,507.72 47,246.48 49,992.00 (2,745.52) 200,000.00 152,753.52 76.4% 6311800 Taxes -Employer Payroll 4,465.45 4,052.00 413.45 13,035.77 11,154.00 1,881.77 81,715.00 68,679.23 84.0% 6311880 Wages•Hourly 35,354.01 24,899.00 10,455.01 107,119.89 64,421.00 42,698.89 619,606.00 512,486.11 82.7% 6311882 Wages -Overtime 3,723.47 - 3,723.47 10,676.35 • 10,676.35 18,500.00 7,823.65 42.3% Total -CM -SALARIES & BENEFITS 68,076.92 55,997.00 12,079.92 194,162.77 152,947.00 41,215.77 1,070,140.00 875,977.23 81.9% 63-CM-SUPPLIES & MATERIALS 6313734 Chemicals 6,428.07 7,820.00 (1,391.93) 12,368.43 21,764.00 (9,395.57) 50,060.00 37,691.57 75.3% 6313744 Fertilizer 3,284.25 9,880.00 (6,595.75) 21,104.52 19,850.00 1,254.52 110,340.00 89,235.48 80.9% 6313745 Herbicides • - - - - - - - 0.0% 6313746 Flowers/Plants • 1,000.00 (1,000.00) 1,380.04 1,000.00 380.04 3,050.00 1,669.96 54.8% 6313748 Fuel -Gasoline 6,414.95 4,500.00 1,914.95 18,701.63 12,250.00 6,451.63 53,800.00 35,098.37 65.2% 6313750 Golf Course Accessories • - - - - - 13,140.00 13,140.00 100.0% 6313756 POA Control • 2,400.00 (2,400.00) - 2,400.00 (2,400.00) 9,900.00 9,900.00 100.0% 6313758 Miscellaneous Supp 613.70 750.00 (136.30) 3,244.06 2,250.00 994.06 4,350.00 1,105.94 25.4% 6313762 Supplies -Office 2,322.10 - 2,322.10 2,640.93 - 2,640.93 - (2,640.93) 0.0% 6313774 Sand 3,451.83 5,000.00 (1,548.17) 3,536.52 5,780.00 (2,243.48) 13,460.00 9,923.48 73.7% 6313776 Seed • - - - - - 325,000.00 325,000.00 100.0% 6313778 Small Tools & Non -Capital Equip • 2,000.00 (2,000.00) - 2,200.00 (2,200.00) 5,000.00 5,000.00 100.0% 6313780 Sod 1,190 82 1,000.00 190.82 13,696.31 10,800.00 2,896.31 15,500.00 1,803.69 11.6% 6313782 Topdressing I - 7,110.88 4,200.00 2,910.88 10,000.00 2,889.12 28.9% Total -CM -SUPPLIES & MATERIALS 23,705.72 34,350.00 (10,644.28) 83,783.32 82,494.00 1,289.32 613,600.00 529,816.68 86.3% 63-CM-REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 4,185.00 3,850.00 335.00 8,705.00 11,550.00 (2,845.00) 30,800.00 22,095.00 71.7% 6315685 CM-R&M-Bldngs & OthrStructures 1,079.75 550.00 529.75 1,180.75 2,550.00 (1,369.25) 5,550.00 4,369.25 78.7% 6315690 CM -R&M -Equipment 2,940.24 3,000.00 (59.76) 22,334.57 7,500.00 14,834.57 38,500.00 16,165.43 42.0% 6315692 CM -R&M -Irrigation System 4,426.66 1,500.00 2,926.66 8,335.18 9,400.00 (1,064.82) 19,050.00 10,714.82 56.2% 6315696 CM -R&M -Pumps 1,640.07 1,000.00 640.07 3,479.29 3,000.00 479.29 10,500.00 7,020.71 66.9% 6315815 CM-R&M-Trees•Pruning Etc 16,890.00 5,500.00 11,390.00 16,890.00 5,500.00 11,390.00 14 050.00 (2,840.00) -20.2% Total -CM -REPAIRS & MAINTENANCE 31,161.72 15,400.00 15,761.72 60,924.79 39,500.00 21,424.79 118,450.00 57,525.21 48.6% 6317836 Utilities•Natural Gas/LPG 23.65 15.00 8.65 71.95 45.00 26.95 180.00 108.05 0.0% 6317840 Telephones 1,003.64 850.00 153.64 3,019.50 2,550.00 469.50 10,200.00 7,180.50 70.4% Total -CM -UTILITIES 1,027.29 865.00 162.29 3,091.45 2,595.00 496.45 10,380.00 7,288.55 70.2% 63-CM-OTHER EXPENSES I6319020 Auto Mileage/Allowance 400.00 400.00 1,200.00 1,200.00 4,800.00 3,600.00 75.0% 6319100 Contract Svcs-Soil/Tissue Test 1,000.00 (1,000.00) 1,000.00 (1,000.00) 2,000.00 2,000.00 100.0% 6319102 Contract Svcs -Trash Removal • 524.00 (524.00) 820.70 1,572.00 (751.30) 6,288.00 5,467.30 86.9% 6319150 Dues & Subscriptions 210.00 - 210.00 1,820.00 - 1,820.00 680.00 (1,140.00) •167.6% 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 290.41 - 290.41 1,035.41 100.00 935.41 4,300.00 3,264.59 75.9% 6319490 Miscellaneous 11.50 100.00 (88.50) 187.74 300.00 (112.26) 1,200.00 1,012.26 84.4% 6319718 Safety Equipment & Training • 750.00 (750.00) - 1,050.00 (1,050.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms • 920.00 (920.00) 455.12 2,760.00 2(304.88) 11,040.00 10,584.88 95.9% Total -CM -OTHER EXPENSES 911.91 3,894.00 (2,9812.09) 5,518.97 8,632.00 (3,113.03) 41,458.00 35,939.03 86.69% SilverRock Resort Course Maintenance Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632-CM-LANDSCAPE MAINTENANCE 632-CM-LM-SALARIES & BENEFITS 6321320 Insurance•Group 1,120.00 1,239.00 (119.00) 3,465.23 3,717.00 (251.77) 25,193.00 21,727.77 86.2% 6321325 Insurance•Workers Comp 726.40 581.00 145.40 2,243.00 1,781.00 462.00 7,147.00 4,904.00 68.6% 6321800 Taxes -Employer Payroll 1,715.91 1,258.14 457.77 4,024.52 3,858.28 166.24 15,595.00 11,570.48 74.2% 6321880 Wages -Hourly 19,058.75 12,904.00 6,154.75 47,490.75 39,572.00 7,918.75 156,528.00 109,037.25 69.7% 6321882 Wages -Overtime 783.76 - 783.76 3,291.77 3,291.77 3,418.00 126.23 3.7% Total-CM-LM-SALARIES & BENEFITS 23,404.82 15,982.14 7,422.68 60,515.27 48,928.28 11,586.99 207,881.00 147,365.73 70.9% 632-CM-LM-SUPPLIES & MATERIALS 6323778 Small Tools - 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0% 6323788 Uniforms - 290.00 (290.00) - 870.00 (870.00) 3,480.00 3,480.00 100.0% Total-CM-LM-SUPPLIES & MATERIALS • 390.00 (390.00) - 1,170.00 (1,170.00) 4,505.00 4,505.00 100.0% 632-CM-LM-REPAIRS & MAINTENANCE 6325687 CM-LM-R&M-Drip Irrigation • 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0% Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0% Total -COURSE MAINTENANCE 148,288.38 127,378.14 20,910.24 407,996.57 337,266.28 70,730.29 2,070,664.00 1,662,667.43 80.3% Silverrock Resort Course Maintenance Water & Energy September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633-CM-WATER & ENERGY 21,570.27 10,996.69 8,900.00 10,400.00 12,670.27 596.69 57,120.00 37,235.03 37,210.00 29,700.00 19,910.00 7,535.03 144,810.00 87,690.00 115,484.00 78,248.97 60.6% 67.8% 63.8% I 6337834 Utilities -Electricity -Pumping 6337842 Utilities•Water Total -CM -WATER & ENERGY 32,566.96 19,300.00 13,266.96 94,355.03 66,910.00 27,445.03 260,294.00 165,938.97 5 SilverRock Resort Outside Services Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. I Budget Expense 641-CBR-SALARIES & BENEFITS 6411320 Insurance -Group 424.44 826.00 (401.56) 1,965.54 2,478.00 (512.46) 9,912.00 7,946.46 80.2% 6411325 Insurance -Workers Comp 1,121.28 968.00 153.28 3,058.18 2,722.00 336.18 19,271.00 16,212.82 84.1% 6411800 Taxes -Employer Payroll 1,880.71 1,614.89 265.82 4,379.96 4,539.89 (159.93) 32,119.00 27,739.04 86.4% 6411880 Wages -Hourly 18,634.56 12,971.00 5,663.56 48,893.72 36,465.00 12,428.72 257,980.00 209,086.28 81.0% 6411882 Wages -Overtime 956.62 - 956.62 1,444.34 - 1,444.34 - (1,444.341 0.0% Total-CBR-SALARIES & BENEFITS 23,017.61 16,379.89 6,637.72 59,741.74 46,204.89 13,536.85 319,282.00 259,540.26 81.3% 641-CBR-SUPPLIES & MATERIALS 6413732 Supplies -Carts 284.53 - 284.53 284.53 - 284.53 1,850.00 ' 0.0% 6413742 Supplies -Expendable 290.63 150.00 140.63 1,004.55 1,350.00 (345.45) 6,750.00 5,745.45 85.1% 6413748 Supplies -Fuel for Shuttle - - - - - - - - 0.0% 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 Stationary - - - - - - 420.00 420.00 100.0% 6413786 Supplies -Towels 320.00 120.00 200.00 1,040.00 360.00 680.00 2,182.00 1,142.00 52.3% 6413796 Supplies -Bottled Water 7,117.46 2,500.00 4,617.46 11,420.32 7,500.00 3,920.32 30,000.00 18,579.68 61.9% Total-CBR-SUPPLIES & MATERIALS 8,012.62 2,795.00 5,217.62 13,749.40 9,285.00 4,464.40 51,727.00 36,412.13 70,4°/ 641-CBR-REPAIRS & MAINTENANCE 6415690 CBR-R&M-Equipment 572.53 300.00 272.53 1,957.66 900.00 1,057.66 3,600.00 1,642.34 45.6% 6415695 CBR-R&M-Cart Maintenance & Repair - 1,503.00 (1,503.00) 3,872.93 4,509.00 (636.07) 18,036.00 14,163.07 78.5% Total-CBR-REPAIRS & MAINTENANCE 572.53 1,803.00 (1,230.47) 5,830.59 5,409.00 421.59 21,636.00 15,805.41 73.1 641-CBR-OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 1,259.07 800.00 459.07 4,197.21 2,400.00 1,797.21 9,600.00 5,402.79 56.3°/ 6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 131.41 1,800.00 (1,668.59) 7,200.00 7,068.59 98.2% 6419820 Uniforms - - - 527.32 - 527.32 5200.00 4672.68 89,9°/ Total-CBR-OTHER EXPENSES 1,259.07 1,475.00 (215.93) 4,855.94 4,425.00 430.94 22450.00 17594.06 78,4/ TOTAL-CARTS,BAGROOM& RANGE 32,861.83 22,452.89 (215.93) 84,177.67 65,323.89 18,853.78 415,095.00 329,351.86 79,3°/ 643-CS-SALARIES & BENEFITS 6431320 Insurance -Group - - - - - - - - 0.0% 6431325 Insurance -Workers Comp 312.36 260.00 52.36 1,012.16 716.00 296.16 7,042.00 6,029.84 85.6% 6431800 Taxes -Employer Payroll 465.86 339.00 126.86 1,369.86 935.00 434.86 9,192.00 7,822.14 85.1% 6431880 Wages -Hourly 4,892.32 3,485.00 1,407.32 13,676.92 9,605.00 4,071.92 94,275.00 80,598.08 85.5% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 5,670.54 4,084.00 1,586.54 16,058.94 11,256.00 4,802.94 110 509.00 94 450.06 85,5°/ 643-CS-OTHER EXPENSES 6433742 Supplies Expendable 13.04 100.00 (86.96) 13.04 200.00 (186.96) 1,050.00 1,036.96 98.8% 6439490 Miscellaneous - - - - - - 200.00 200.00 100.0% 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 13.04 225.00 (211.96) 13.04 575.00 (561.96) 3,975.00 3,961.96 99,7°/ Total -COURSE SERVICES 5,683.58 4,309.00 1,374.58 16,071.98 11,831.00 4,240.98 114,484.00 98,412.02 86.0% TOTAL OUTSIDE SERVICES 38,545.41 26,761.89 11,783.52 100,249.65 77,154.89 23,094.76 529,579.00 423,801.92 80.0% 6 SilverRock Resort Clubhouse Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 65-CH-SUPPLIES & MATERIALS 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 1,908.56 850.00 1,058.56 3,172.25 2,550.00 622.25 12,180.00 9,007.75 74.0% 6507840 Utilities -Telephone 120.00 1,150.00 (1,030.00) 2,984.23 3,450.00 (465.77) 13,800.00 10,815.77 78.4% 6507842 Utilities -Water 1,215.07 321.00 894.07 2,214.74 963.00 1,251.74 3,852.00 1,637.26 42.5% 6507844 Utilities -Cable 387.59 380.00 7.59 851.17 1,140.00 (288.83) 4,560.00 3,708.83 81.3% Total -CH -UTILITIES 3,631.22 2,701.00 930.22 9,222.39 8,103.00 1,119.39 34,392.00 25,169.61 73.2% 65-CH-OTHER EXPENSES 6509091 Contract Services -Cleaning 2,995.72 400.00 2,595.72 8,867.16 1,200.00 7,667.16 4,800.00 (4,067.16) -84.7% 6509099 Contract Services -Security 6,315.40 5,000.00 1,315.40 17,895.56 15,000.00 2,895.56 60,000.00 42,104.44 70.2% 6509215 Flowers & Decorations - - - - - - 1,900.00 1,900.00 100.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 9,311.12 5,500.00 3,811.12 26,762.72 16,500.00 10,262.72 67,900.00 41,137.28 60.6% 65-CH-REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 514.14 300.00 214.14 1,575.05 900.00 675.05 3,600.00 2,024.95 56.2% 6515686 CH -R&M -Restaurant Repairs 405.98 700.00 (294.02) 405.98 2,100.00 (1,694.02) 8,400.00 7,994.02 95.2% 6515690 CH -R&M -Equipment Repair - 700.00 (700.00) 148.75 2,100.00 (1,951.25) 8,400.00 8,251.25 98.2% Total -CH -REPAIRS & MAINTENANCE 920.12 1,700.00 (779.88) 2,129.78 5,100.00 (2,970.22) 20,400.00 18,270.22 89.6% Total CLUBHOUSE 14,262.46 10,301.00 3,961.46 39,314.89 30,903.00 8,411.89 127,492.00 36,540.44 28.7% 7 SilverRock Resort Marketing Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 66-MKT-SALARIES & BENEFITS 6601320 Insurance -Group - - - - - - 2,891.00 2,891.00 100.0% 6601325 Insurance -Workers Comp 82.32 93.00 (10.68) 283.02 279.00 4.02 1,121.00 837.98 74.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 121.00 62.00 427.00 363.00 64.00 1,463.00 1,036.00 70.8% Total -MKT -SALARIES & BENEFITS 2,140.32 1,464.00 676.32 5,085.02 4,392.00 693.02 20,475.00 15,389.98 75.2% 66-MKT-SUPPLIES & MATERIALS 6603762 Supplies -Office - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0% 6603768 Supplies -Printing & Stationery 315.98 200.00 115.98 2,654.96 200.00 2,454.96 4,425.00 1,770.04 40.0% Total -MKT -SUPPLIES & MARKETING 315.98 300.00 15.98 2,654.96 500.00 2,154.96 5,625.00 2,970.04 52.8% 66-MKT-UTILITIES 6607840 Utilities -Telephone 1,502.92 100.00 1,402.92 1,920.06 300.00 1,620.06 1,200.00 (720.06) -60.0% Total -MKT -UTILITIES 1,502.92 100.00 1,402.92 1,920.06 300.00 1,620.06 1,200.00 (720.06) -60.0% 66-MKT-OTHER EXPENSES 6609010 Advertising 11,324.99 10,715.00 609.99 17,527.76 15,847.00 1,680.76 151,133.00 133,605.24 88.4% 6609040 Business Meals - 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0% 6609080 Collateral Material 360.64 - 360.64 360.64 - 360.64 5,500.00 5,139.36 93.4% 6609102 Contract Services -Web Page - 150.00 (150.00) - 450.00 (450.00) 1,800.00 1,800.00 100.0% 6609490 Miscellaneous - - - 47.84 - 47.84 350.00 302.16 86.3% 6609620 Postage - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0% 6609630 Promotion - - - 69.36 - 69.36 700.00 630.64 90.1% 6609633 Promotion-Cummunity - 75.00 (75.00) 15.79 225.00 (209.21) 2,250.00 2,234.21 99.3% 6609634 Promotion-MediaNendor - - - - - - 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 11,685.63 11,015.00 670.63 18,021.39 16,747.00 1,274.39 164,968.00 146,946.61 89.1% TOTAL MARKETING 15,644.85 12,879.00 2,765.85 27,681.43 21,939.00 5,742.43 192,268.00 164,586.57 85.6% 8 SilverRock Resort General and Administrative Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budge Unemcumb. %Budget Expense 67-G&A-SALARIES & BENEFITS 6701320 Insurance -Group 2,568.34 3,143.00 (574.66) 8,013.98 9,429.00 (1,415.02) 37,716.00 29,702.02 78.8% 6701325 Insurance -Workers Comp 1,465.96 1,666.00 (200.04) 4,659.16 4,998.00 (338.84) 21,077.00 16,417.84 77.9% 6701720 Salaries 21,323.50 20,000.00 1,323.50 55,441.10 60,000.00 (4,558.90) 240,000.00 184,558.90 76.9% 6701800 Taxes -Employer Payroll 1,996.00 2,175.00 (179.00) 5,254.18 6,525.00 (1,270.82) 27,510.00 22,255.82 80.9% 6701880 Wages -Hourly 4,565.38 2,311.00 2,254.38 12,373.42 6,933.00 5,440.42 42,156.00 29,782.58 70.6% 6701882 Wages -Overtime 8.51 - - 8.51 - 8.51 8.51 - Total-G&A-SALARIES & BENEFITS 31,927.69 29,295.00 2,624.18 85,750.35 87,885.00 (2,134.65) 368,467.51 282,717.16 76.7% 67-G&A-SUPPLIES & MATERIALS 6703740 Supplies -Computer 41.97 500.00 (458.03) 256.95 1,500.00 (1,243.05) 6,300.00 6,043.05 95.9% 6703762 Supplies -Office 41.63 105.00 (63.37) 1,172.99 315.00 857.99 1,260.00 87.01 6.9% 6703768 Supplies -Printing & Stationery - 100.00 (100.00) 46.55 300.00 (253.45) 3,300.00 3,253.45 98.6% Total-G&A-SUPPLIES & MATERIALS 83.60 705.00 (621.40) 1,476.49 2,115.00 (638.51) 10,860.00 9,383.51 86.4% 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% 6709090 Contract Services - - - - - - - 0.0% 6709150 Dues & Subscriptions - 300.00 (300.00) 396.50 350.00 46.50 1,550.00 1,153.50 74.4% 6709180 Employee RecruitinglRelocation 35.00 150.00 (115.00) 445.24 150.00 295.24 1,200.00 754.76 62.9% 6709197 Equipment Rental 760.34 550.00 210.34 2,129.62 1,650.00 479.62 6,600.00 4,470.38 67.7% 6709202 Fees -Bank - 90.00 (90.00) 80.31 270.00 (189.69) 1,080.00 999.69 92.6% 6709208 Fees -Payroll Processing - 1,000.00 (1,000.00) 697.01 3,000.00 (2,302.99) 12,000.00 11,302.99 94.2% 6709220 FreightlDelivery - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0% 6709490 Miscellaneous 300.00 100.00 200.00 353.29 300.00 53.29 6,000.00 5,646.71 94.1% 6709620 Postage/Mail Services 9.85 75.00 (65.15) 377.53 225.00 152.53 900.00 522.47 58.1% 6709625 Professional Fees 2,999.41 1,500.00 1,499.41 4,337.41 4,500.00 (162.59) 28,000.00 23,662.59 84.5% 6709636 Promotion/Entertainment - 100.00 (100.00) 180.00 300.00 (120.00) 1,200.00 1,020.00 85.0% 6709722 Seminars & Training 1,079.80 200.00 879.80 1,079.80 600.00 479.80 3,400.00 2,320.20 68.2% 6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms - 75.00 (75.00) 49.48 225.00 (175.52) 1,050.00 1,000.52 95.3% Total-G&A-OTHER EXPENSES 5,684.40 4,690.00 994.40 11,626.19 13,320.00 (1,693.81) 70,680.00 59,053.81 83_6% Total-GENER4L & ADMINISTRATIVE 37,695.69 34,790.00 2,905.69 98,853.03 103,520.00 (4,666.97) 451 907.51 353,054.48 78.1% 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement September 2022 Month to Date Year to Date Annual Budget September 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 68-LEASES 6800192 Equipment Leases -Carts 10,811.56 12,000.00 (1,188.44) 32,434.68 36,000.00 (3,565.32) 144,000.00 111,565.32 77.5% 6800193 Equipment Leases -Maintenance 18,330.33 15,900.00 2,430.33 43,694.94 47,700.00 (4,005.06) 190,800.00 147,105.06 77.1% 6800196 Equipment Leases-GPS 2,640.00 2,900.00 (260.00) 7,920.00 8,700.00 (780.00) 34,800.00 26,880.00 77.2% 6800197 Equipment Leases -Others 1,020.33 1,150.00 (129.67) 3,069.91 3,450.00 (380.09) 20,200.00 17,130.09 0.0% Total -LEASES 32,802.22 31,950.00 852.22 87,119.53 95,850.00 (8,730.47) 389,800.00 302,680.47 77.7% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs•Management Fee 10,374.00 10,374.00 - 31,122.00 31,122.00 - 124,488.00 93,366.00 75.0% 6900800 Personal Property Taxes 3,614.80 4,000.00 (385.20) 9,069.94 9,200.00 (130.06) 11,800.00 2,730.06 23.1% 6900323 Insurance -Commercial - 5,917.00 (5,917.00) 13,087.02 17,751.00 (4,663.98) 71,004.00 57,916.98 81.6% 6900210 FF&E Reserve 2,041.90 3,039.49 (997.59) 5,306.64 6,423.99 (1,117.35) 74,907.00 69,600.36 92.9% Total-M/SC OTHER EXPENSES 16,030.70 23,330.49 (7,299.79) 58,585.60 64,496.99 (5,911.39) 282,199.00 2 223,613.40 79.2% 10 SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report-2022-2023 Comp Category Media Sales Promotion Golf Industry VIP Celebrity 2022 2022 2022 2022 2022 2022 July August September October November December PGA Comp 15 8 7 Charity/Gift Certificate Rain/Wind Checks 5 2 4 Club Staff 2 36 40 LQ HS Golf 42 Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf 64 46 51 0 0 0 2023 2023 2023 2023 2023 2023 January February March April May June 0 0 0 0 0 0