Loading...
02 August 2022 SilverRock Resort - Monthly Financial StatementSILVERROCK® RESORT Monthly Financial Statements July 1, 2022 - August 31, 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 August 2022 Month to Date Year to Date Annual Budget Percentages GIL # Series Account Description August Unfavorable (-) Annual 2022 Final Budget Variance Favorable (+1 Final Budget Variance Budget Unemcumb. % Bdgt IIncome 400000 Golf Green Fee Revenue 65,331.00 84,613.00 (19,282.00) -22.8% 163,237.00 169,226.00 (5,989.00) 3,745,355.00 3,582,118.00 4% 401000 Miscellaneous Golf Revenue 7,349.50 3,850.00 3,499.50 90.9% 13,054.50 8,250.00 4,804.50 307,480.00 294,425.50 4% 410000 Revenue -Golf Shop 5,350.13 5,075.00 275.13 5.4% 13,402.74 10,150.00 3,252.74 212,618.00 199,215.26 6% 420000 Food & Beverage Revenue 14,947.28 10,500.00 4,447.28 42.4% 36,038.83 21,000.00 15,038.83 585,382.00 549,343.17 6% Total Income 92,977.91 104,038.00 (11,060.09) -10.6% 225,733.07 208,626.00 17,107.07 4,850,835.00 4,625,101.93 5% Cost of Goods Sold 510000 COS -Golf Shop 2,936.50 2,840.97 95.53 -3,4% 7,971.44 5,679.94 (2,291.50) 119,002.00 111,030.56 7% 520000 COS -Food & Beverage 6,812.58 5,010.00 1,802.58 -36.0% 15,045.46 10,020.00 (5,025.46) 199,408.00 184,362.54 8% Total COS 9,749.08 7,1350.97 1,895.11 -242% 23,016.90 15,599.94 (7,315.96) 318,41U.UU 111,030.55 7% Gross Profit 83,228.83 96,187.03 (12,958.20) -13.5% 202,716.17 192,926.06 9,790.11 4,532,425.00 4,514,071.37 4% Expenses 610000 Golf Pro Shop 15,171.09 14,518.00 653.09 -4.5% 29,604.34 29,231.00 373.34 216,775.00 187,170.66 14% 630000 Course Maintenance 136,529.78 96,377.07 40,152.71 -41.7% 234,708.19 209,888.14 24,820.05 2,070,664.00 1,835,955.81 11% 633000 Maintenance Water & Energy 30,473.37 23,360.00 7,113.37 -30.5% 61,788.07 47,610.00 14,178.07 260,294.00 198,505.93 24% 640000 Outside Services 29,770.66 25,196.50 4,574.16 -18.2% 61,704.24 50,393.00 11,311.24 529,580.00 467,875.76 12% 650000 Clubhouse 11,992.08 10,301.00 1,691.08 -16.4% 25,052.43 20,602.00 4,450.43 127,492.00 102,439.57 20% 660000 Marketing 7,979.42 4,530.00 3,449.42 -76.1% 12,036.58 9,060.00 2,976.58 192,267.00 180,230.42 6% 670000 General &Administrative 30,359.29 34,440.00 (4,080.71) 112% 61,157.34 68,730.00 (7,572.66) 451,899.00 390,741.66 14% 680000 Leases 26,146.03 31,950.00 (5,803.97) 18.2% 54,317.31 63,900.00 (9,582.69) 389,800.00 335,482.69 14% 690000 Miscellaneous Other Expense 18,224.13 17,983.25 240.88 -1.3% 42,554.90 41,166.50 1,388.40 293,999.00 251,444.10 620000 Food & Beverage Expenses 29,746.44 25,547.00 4,199.44 -16.4% 54,988.17 50,145.00 4,843.17 453,954.00 398,965.83 14% Total Expenses 336,392.29 284,202.82 52,189.47 -18.4% 637,911.57 590,725.64 (47,185.93) 4,986,724.00 3,949,846.60 13% Net Income (253,163.46) (188,015.79) (65,147.67) -42.5% (435,195.40) (397,799.58) (37,395.82) (454,299.00) 564,224.77 96% 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 46.24 48.35 (2.11) -4.4% 46.72 48.35 (1.63) 89.18 42.46 52% Ave $ Per Paid Round Merchandise 3.79 2.90 0.89 30.6% 3.84 2.90 0.94 5.06 1.23 76% Ave $ Per Paid Miscellaneous 2.50 1.91 0.58 30.4% 2.00 2.07 (0.07) 7.32 5.32 27% 1 SilverRock Resort Statement of Fees - Revenue August 2022 Month to Date Year to Date Annual Budget August Income 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 65,331.00 84,613.00 (19,282.00) 163,237.00 169,226.00 (5,989.00) 3,745,355.00 3,582,118.00 95.6% 4010000 Rider Fee 630.00 1,100.00 (470.00) 1,155.00 2,100.00 (945.00) 18,180.00 17,025.00 93.6% 4040000 Club Rental 475.00 750.00 (275.00) 1,305.00 1,550.00 (245.00) 24,100.00 22,795.00 94.6% 4050000 Driving Range 1,565.00 1,500.00 65.00 3,665.00 3,100.00 565.00 87,850.00 84,185.00 95.8% 4060000 Handicap Fees 266.00 - 266.00 266.00 - 266.00 2,050.00 1,784.00 87.0% 4090000 Ball Retriever/Subcontract 592.50 - 592.50 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 3,821.00 500.00 3,321.00 6,071.00 1,000.00 5,071.00 165,300.00 159,229.00 96.3% 72,680.50 88,463.00 (15,782.50) 176,291.50 177,476.00 (1,184.50) 4,052,835.00 3,876,543.50 95.7% Total Revenue Fees Total Income I 72,680.50 88,463.00 (15,782.50) 176,291.50 177,476.00I (1,184.50) 4,052,835.00I 3,876,543.50I 95.7% I 2 SilverRock Resort Golf Shop Income Statement August 2022 Month to Date Year to Date Annual Budget Income August 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 180.38 - 180.38 388.91 - 388.91 0 0 0% 4100110 Sales Hard Goods 2,730.10 1,269.00 1,461.10 6,745.73 2,538.00 4,207.73 53,155.00 46,409.27 87.3% 4100112 Sales -Soft Goods 3,086.00 3,806.00 (720.00) 8,212.00 7,612.00 600.00 159,464.00 151,252.00 94.9% 5100639 GS•Discounts•Mdse (646.35) - (646.35) (1,943.90) • (1,943.90) • 1,943.90 0.0% Total Revenue Golf Shop 5,350.13 5,075.00 275.13 13,402.74 10,150.00 3,252.74 212,619.00 199,605.17 919% COS 5100150 COS-GS-Hard Goods 1,491.85 736.00 755.85 3,865.65 1,471.00 2,394.65 30,829.00 26,963.35 87.5% 5100151 COS-GS-Soft Goods 1,379.33 2,208.00 (828.67) 3,660.94 4,415.00 (754.06) 92,489.00 88,828.06 96.0% 5100152 COS-GS-Purchase Disc (31.92) (147.18) 115.26 (33.09) (294.36) 261.27 (6,166.00) (6,132.91) 99.5% 5100220 COS-GS-Freight Merch 97.24 44.15 53.09 477.94 88.30 389.64 1,850.00 1,372.06 74.2% Cost of Sales - Golf Shop 2,936.50 2,840.97 95.53 7,971.44 5,679.94 2,291.50 119,002.00 111,030.56 93.3% Gross Profit 2,413.63 2,234.03 179.60 5,431.30 4,470.06 961.24 93,617.00 88,574.61 94.6% COS % 54.9% 56.0% 1.1% 59.5% 56.0% -3.5% 53.1% 55.6% 104.8% Expense 61-PS-SALARIES & BENEFITS 6101320 Insurance Group 414.45 826.00 (411.55) 849.87 1,652.00 (802.13) 9,912.00 9,062.13 91.4% 6101325 Insurance -Workers Comp 945.60 801.00 144.60 1,791.61 1,615.00 176.61 11,980.00 10,188.39 85.0% 6101720 Salaries 5,323.16 5,957.00 (633.84) 10,646.32 11,914.00 (1,267.68) 65,000.00 54,353.68 83.6% 6101800 Taxes -Employer Payroll 982.95 1,047.00 (64.05) 1,884.95 2,110.00 (225.05) 13,896.00 12,011.05 86.4% 6101880 Wages -Hourly 7,345.19 4,777.00 2,568.19 13,813.19 9,720.00 4,093.19 97,112.00 83,298.81 85.8% 6101882 Wages -Overtime 4.80 - 4.80 4.80 - 4.80 - (4.80) 0.0% Total -PS -SALARIES & BENEFITS 15,016.15 13,408.00 1,608.15 28,990.74 27,011.00 1,979.74 197,900.00 168,909.26 85.4% 61-PS OTHER EXPENSES 6103742 Supplies•Expendable • - • - - 0.0% 6103762 Supplies•Office 22.61 250.00 (227.39) 194.95 500.00 (305.05) 3,000.00 2,805.05 93.5% 6109220 Freight & Delivery - 23.76 23.76 75.00 51.24 68.3% 6109490 Miscellaneous • 500.00 (500.00) 1,000.00 (1,000.00) 6,000.00 6,000.00 100.0% 6109150 Dues and Subscriptions •- • 2,300.00 2,300.00 100.0% 6109500 ProShop•Over/Short (0.39) - (0.39) (1.12) • (1.12) 1.12 0.0% 6109722 Seminars/Training 150.00 (150.00) 300.00 (300.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 200.00 (69.43) 2,400.00 2,269.43 94.6% 6117840 Telephones 132.72 110.00 22.72 265.44 220.00 45.44 1,320.00 1,054.56 79.9% Total - Other Expenses 154.94 1,110.00 (955.06) 613.60 2,220.00 (1,606.40) 18,875.00 18,261.40 96.7% Total Expenses -Golf Shop 15,171.09 14,518.00 653.09 29,604.34 29,231.00 373.34 216,775.00 187,170.66 86.3% Net Income (12 757.46) (12 283.971 (473.49) (24 173.04) (24 760.94) 587.90 (123 158.00) (98 596.051 80.1 % 3 SilverRock Resort Course Maintenance Expense Statement August 2022 Month to Date Year to Date Annual Budget August 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63-CM-SALARIES & BENEFITS 6311320 Insurance•Group 5,405.14 6,860.00 (1,454.86) 6,004.81 13,720.00 (7,715.19) 112,882.00 106,877.19 94.7% 6311325 Insurance•Workers Comp 1,795.80 1,639.00 156.80 3,717.20 3,278.00 439.20 37,437.00 33,719.80 90.1% 6311720 Salaries 14,537.38 16,664.00 (2,126.62) 29,074.76 33,328.00 (4,253.24) 200,000.00 170,925.24 85.5% 6311800 Taxes -Employer Payroll 4,381.09 3,551.00 830.09 8,570.32 7,102.00 1,468.32 81,715.00 73,144.68 89.5% 6311880 Wages -Hourly 26,690.45 19,761.00 6,929.45 46,765.88 39,522.00 7,243.88 619,606.00 572,840.12 92.5% 6311882 Wages•Overtime 2,133.31 - 2,133.31 6,952.88 • 6,952.88 18,500.00 11,547.12 62.4% Total -CM -SALARIES & BENEFITS 54,943.17 48,475.00 6,468.17 101,085.85 96,950.00 4,135.85 1,070,140.00 969,054.15 90.6% 63-CM-SUPPLIES & MATERIALS 6313734 Chemicals 5,940.36 190.00 5,750.36 5,940.36 13,944.00 (8,003.64) 50,060.00 44,119.64 88.1% 6313744 Fertilizer 7,899.00 4,100.00 3,799.00 17,820.27 9,970.00 7,850.27 110,340.00 92,519.73 83.8% 6313745 Herbicides • - - - - - - - 0.0% 6313746 Flowers/Plants 1,380.04 - 1,380.04 1,380.04 - 1,380.04 3,050.00 1,669.96 54.8% 6313748 Fuel -Gasoline 6,172.97 3,850.00 2,322.97 12,286.68 7,750.00 4,536.68 53,800.00 41,513.32 77.2% 6313750 Golf Course Accessories • - - - - - 13,140.00 13,140.00 100.0% 6313756 POA Control • - - - - - 9,900.00 9,900.00 100.0% 6313758 Miscellaneous Supp 1,286.08 750.00 536.08 2,630.36 1,500.00 1,130.36 4,350.00 1,719.64 39.5% 6313762 Supplies -Office 318.83 - 318.83 318.83 - 318.83 - (318.83) 0.0% 6313774 Sand 84.69 390.00 (305.31) 84.69 780.00 (695.31) 13,460.00 13,375.31 99.4% 6313776 Seed • - - - - - 325,000.00 325,000.00 100.0% 6313778 Small Tools & Non -Capital Equip • 100.00 (100.00) - 200.00 (200.00) 5,000.00 5,000.00 100.0% 6313780 Sod 11,891.04 4,500.00 7,391.04 12,505.49 9,800.00 2,705.49 15,500.00 2,994.51 19.3% 6313782 Topdressing 7,110.88 2,200.00 4,910.88 7,110.88 4,200.00 2,910.88 10,000.00 2,889.12 28.9% Total -CM -SUPPLIES & MATERIALS 42,083.89 16,080.00 26,003.89 60,077.60 48,144.00 11,933.60 613,600.00 553,522.40 90.2% 63-CM-REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 4,185.00 3,850.00 335.00 4,520.00 7,700.00 (3,180.00) 30,800.00 26,280.00 85.3% 6315685 CM-R&M-Bldngs & OthrStructures 101.00 750.00 (649.00) 101.00 2,000.00 (1,899.00) 5,550.00 5,449.00 98.2% 6315690 CM -R&M -Equipment 9,447.03 2,500.00 6,947.03 19,394.33 4,500.00 14,894.33 38,500.00 19,105.67 49.6% 6315692 CM -R&M -Irrigation System 2,899.19 3,500.00 (600.81) 3,908.52 7,900.00 (3,991.48) 19,050.00 15,141.48 79.5% 6315696 CM -R&M -Pumps 1,839.22 1,000.00 839.22 1,839.22 2,000.00 (160.78) 10,500.00 8,660.78 82.5% 6315815 CM-R&M-Trees•Pruning Etc - - - - • - 14 050.00 14,050.00 100.0% Total -CM -REPAIRS & MAINTENANCE 18,471.44 11,600.00 6,871.44 29,763.07 24,100.00 5,663.07 118,450.00 88,686.93 74.9% 6317836 Utilities•Natural Gas/LPG 22.83 15.00 7.83 48.30 30.00 18.30 180.00 131.70 0.0% 6317840 Telephones 1,014.44 850.00 164.44 2,015.86 1,700.00 315.86 10,200.00 8,184.14 80.2% Total -CM -UTILITIES 1,037.27 865.00 172.27 2,064.16 1,730.00 334.16 10,380.00 8,315.84 80.1% 63-CM-OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3% 6319100 Contract Svcs-Soil/Tissue Test • - - - - - 2,000.00 2,000.00 100.0% 6319102 Contract Svcs -Trash Removal 820.70 524.00 296.70 820.70 1,048.00 (227.30) 6,288.00 5,467.30 86.9% 6319150 Dues & Subscriptions 1,330.00 - 1,330.00 1,610.00 - 1,610.00 680.00 (930.00) •136.8% 6319170 Employee Education • 50.00 (50.00) - 100.00 (100.00) 3,900.00 3,900.00 100.0% 6319197 Equipment Rental • 150.00 (150.00) - 350.00 (350.00) 3,400.00 3,400.00 100.0% 6319206 Licenses & Permits • - - 745.00 100.00 645.00 4,300.00 3,555.00 82.7% 6319490 Miscellaneous 131.66 100.00 31.66 176.24 200.00 (23.76) 1,200.00 1,023.76 85.3% 6319718 Safety Equipment & Training • 100.00 (100.00) - 300.00 (300.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms • 920.00 (920.00) 455.12 1,840.00 (1,384.88) 11,040.00 10,584.88 95.9% Total -CM -OTHER EXPENSES 2,682.36 2,244.00 438.36 4,607.06 4,738.00 (130.94) 41,458.00 36,850.94 88.89% Course SilverRock Resort Maintenance Expense Statement August 2022 Month to Date Year to Date Annual Budget August2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632-CM-LANDSCAPE MAINTENANCE 632-CM-LM-SALARIES & BENEFITS 6321320 Insurance•Group 1,209.00 1,239.00 (30.00) 2,345.23 2,478.00 (132.77) 25,193.00 22,847.77 90.7% 6321325 Insurance•Workers Comp 795.20 600.00 195.20 1,516.60 1,200.00 316.60 7,147.00 5,630.40 78.8% 6321800 Taxes -Employer Payroll 920.32 1,300.07 (379.75) 2,308.61 2,600.14 (291.53) 15,595.00 13,286.39 85.2% 6321880 Wages -Hourly 13,240.00 13,334.00 (94.00) 28,432.00 26,668.00 1,764.00 156,528.00 128,096.00 81.8% 6321882 Wages -Overtime 1,147.13 - 1,147.13 2,508.01 2,508.01 3,418.00 909.99 26.6% Total-CM-LM-SALARIES & BENEFITS 17,311.65 16,473.07 838.58 37,110.45 32,946.14 4,164.31 207,881.00 170,770.55 82.1% 632-CM-LM-SUPPLIES & MATERIALS 6323778 Small Tools - 100.00 (100.00) - 200.00 (200.00) 1,025.00 1,025.00 100.0% 6323788 Uniforms - 290.00 (290.00) - 580.00 (580.00) 3,480.00 3,480.00 100.0% Total-CM-LM-SUPPLIES & MATERIALS • 390.00 (390.00) - 780.00 (780.00) 4,505.00 4,505.00 100.0% 632-CM-LM-REPAIRS & MAINTENANCE 6325687 CM-LM-R&M-Drip Irrigation • 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0% Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0% Total -COURSE MAINTENANCE 136,529.78 96,377.07 40,152.71 234,708.19 209,888.14 24,820.05 2,070,664.00 1,835,955.81 88.7% Silverrock Resort Course Maintenance Water & Energy August 2022 Month to Date Year to Date Annual Budget August2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633-CM-WATER & ENERGY 16,792.28 13,681.09 14,210.00 9,150.00 2,582.28 4,531.09 35,549.73 26,238.34 28,310.00 19,300.00 7,239.73 6,938.34 144,810.00 109,260.27 115,484.00 89,245.66 75.5% 77.3% 76.3% I 6337834 Utilities -Electricity -Pumping 6337842 Utilities•Water Total -CM -WATER & ENERGY 30,473.37 23,360.00 7,113.37 61,788.07 47,610.00 14,178.07 260,294.00 198,505.93 5 SilverRock Resort Outside Services Expense Statement August 2022 Month to Date Year to Date Annual Budget August 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 641-CBR-SALARIES & BENEFITS 6411320 Insurance -Group 752.93 826.00 (73.07) 1,541.10 1,652.00 (110.90) 9,912.00 8,370.90 84.5% 6411325 Insurance -Workers Comp 982.70 877.00 105.70 1,936.90 1,754.00 182.90 19,271.00 17,334.10 89.9% 6411800 Taxes -Employer Payroll 1,330.57 1,462.50 (131.93) 2,499.25 2,925.00 (425.75) 32,119.00 29,619.75 92.2% 6411880 Wages -Hourly 15,758.67 11,747.00 4,011.67 30,259.16 23,494.00 6,765.16 257,980.00 227,720.84 88.3% 6411882 Wages -Overtime 308.13 - 308.13 487.72 - 487.72 - (487.721 0.0% Total-CBR-SALARIES & BENEFITS 19,133.00 14,912.50 4,220.50 36,724.13 29,825.00 6,899.13 319,282.00 282,557.87 88.5% 641-CBR-SUPPLIES & MATERIALS 6413732 Supplies -Carts - - - - - - 1,850.00 ' 0.0% 6413742 Supplies -Expendable 429.39 600.00 (170.61) 713.92 1,200.00 (486.08) 6,750.00 6,036.08 89.4°/ 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) - 50.00 (50.00) 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationary - - - - - - 420.00 420.00 100.0% 6413786 Supplies -Towels 400.00 120.00 280.00 720.00 240.00 480.00 2,182.00 1,462.00 67.0% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 4,302.86 5,000.00 (697.14) 30,000.00 25,697.14 85,7% Total-CBR-SUPPLIES & MATERIALS 829.39 3,245.00 (2,415.61) 5,736.78 6,490.00 (753.22) 51,727.00 44,140.22 85,3°/ 641-CBR-REPAIRS & MAINTENANCE 6415690 CBR-R&M-Equipment - 300.00 (300.00) 1,385.13 600.00 785.13 3,600.00 2,214.87 61.5% 6415695 CBR-R&M-Cart Maintenance & Repair 2,656.93 1,503.00 1,153.93 3,872.93 3,006.00 866.93 18,036.00 14,163.07 78,5°/ Total-CBR-REPAIRS & MAINTENANCE 2,656.93 1,803.00 853.93 5,258.06 3,606.00 1,652.06 21,636.00 16,377.94 75,7 % 641-CBR-OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 1,888.15 800.00 1,088.15 2,938.14 1,600.00 1,338.14 9,600.00 6,661.86 69.4% 6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 131.41 1,200.00 (1,068.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,888.15 1,475.00 413.15 3,596.87 2,950.00 646.87 22 450.00 18 853.13 84.0% TOTAL-CARTS,BAGROOM& RANGE 24,507.47 21,435.50 413.15 51,315.84 42,871.00 8,444.84 415,095.00 361,929.16 87,2°/ 643-CS-SALARIES & BENEFITS 6431320 Insurance -Group - - - - - - - - 0.0% 6431325 Insurance -Workers Comp 368.40 228.00 140.40 699.80 456.00 243.80 7,042.00 6,342.20 90.1% 6431800 Taxes -Employer Payroll 466.04 298.00 168.04 904.00 596.00 308.00 9,192.00 8,288.00 90.2% 6431880 Wages -Hourly 4,428.75 3,060.00 1,368.75 8,784.60 6,120.00 2,664.60 94,275.00 85,490.40 90.7% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 5,263.19 3,586.00 1,677.19 10,388.40 7,172.00 3,216.40 110 509.00 100 120.60 90.6% 643-CS-OTHER EXPENSES 6433742 Supplies Expendable - 50.00 (50.00) - 100.00 (100.00) 1,050.00 1,050.00 100.0% 6439490 Miscellaneous - - - - - - 200.00 200.00 100.0% 6439718 Safety Equipment & Training - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0% 6439820 Uniforms - 75.00 (75.00) - 150.00 (150.00) 2,125.00 2,125.00 100.0% Total -CS -OTHER EXPENSES - 175.00 (175.00) - 350.00 (350.00) 3,975.00 3,975.00 100.0% Total -COURSE SERVICES 5,263.19 3,761.00 1,502.19 10,388.40 7,522.00 2,866.40 114,484.00 104,095.60 90.9% TOTAL OUTSIDE SERVICES 29,770.66 25,196.50 4,574.16 61,704.24 50,393.00 11,311.24 529,579.00 462,049.76 87.2% 6 SilverRock Resort Clubhouse Expense Statement August 2022 Month to Date Year to Date Annual Budget August 2022 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 65-CH-SUPPLIES Al MATERIALS 6503742 Supplies -Expendable 400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3% Total -CH -SUPPLIES & MATERIALS 400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3% 65-CH-UTILITIES 6507836 Utilities -Natural Gas - 850.00 (850.00) 1,263.69 1,700.00 (436.31) 12,180.00 10,916.31 89.6% 6507840 Utilities -Telephone 1,446.86 1,150.00 296.86 2,864.23 2,300.00 564.23 13,800.00 10,935.77 79.2% 6507842 Utilities -Water 524.52 321.00 203.52 999.67 642.00 357.67 3,852.00 2,852.33 74.0% 6507844 Utilities -Cable 75.99 380.00 (304.01) 463.58 760.00 (296.42) 4,560.00 4,096.42 89,8% Total -CH -UTILITIES 2,047.37 2,701.00 (653.63) 5,591.17 5,402.00 189.17 34,392.00 28,800.83 83.7% 65-CH-OTHER EXPENSES 6509091 Contract Services -Cleaning 2,935.72 400.00 2,535.72 5,871.44 800.00 5,071.44 4,800.00 (1,071.44) -22.3% 6509099 Contract Services -Security 5,750.08 5,000.00 750.08 11,580.16 10,000.00 1,580.16 60,000.00 48,419.84 80.7% 6509215 Flowers & Decorations - - - - - - 1,900.00 1,900.00 100.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0% Total -CH -OTHER EXPENSES 8,685.80 5,500.00 3,185.80 17,451.60 11,000.00 6,451.60 67,900.00 50,448.40 74.3% 65-CH-REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 858.91 300.00 558.91 1,060.91 600.00 460.91 3,600.00 2,539.09 70.5% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) - 1,400.00 (1,400.00) 8,400.00 8,400.00 100.0% 6515690 CH -R&M -Equipment Repair - 700.00 (700.00) 148.75 1,400.00 (1,251.25) 8,400.00 8,251.25 98.2% Total -CH -REPAIRS & MAINTENANCE 858.91 1,700.00 (841.09) 1,209.66 3,400.00 (2,190.34) 20,400.00 19,190.34 94.1% Total CLUBHOUSE 11,992.08 10,301.00 1,691.08 25,052.43 20,602.00 4,450.43 127,492.00 38,380.68 30.1% 7 SilverRock Resort Marketing Expense Statement August 2022 Month to Date Year to Date Annual Budget August 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 104.20 93.00 11.20 200.70 186.00 14.70 1,121.00 920.30 82.1% 6601720 Salaries 1,250.00 1,250.00 - 2,500.00 2,500.00 - 15,000.00 12,500.00 83.3% 6601800 Tax -Employer Payroll 122.00 121.00 1.00 244.00 242.00 2.00 1,463.00 1,219.00 83.3% Total -MKT -SALARIES & BENEFITS 1,476.20 1,464.00 12.20 2,944.70 2,928.00 16.70 20,475.00 17,530.30 85.6% 66-MKT-SUPPLIES & MATERIALS 6603762 Supplies -Office - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0% 6603768 Supplies -Printing & Stationery 2,255.91 - 2,255.91 2,338.98 - 2,338.98 4,425.00 2,086.02 47.1% Total -MKT -SUPPLIES & MARKETING 2,255.91 100.00 2,155.91 2,338.98 200.00 2,138.98 5,625.00 3,286.02 58.4% 66-MKT-UTILITIES 6607840 Utilities -Telephone 208.07 100.00 108.07 417.14 200.00 217.14 1,200.00 782.86 65.2% Total -MKT -UTILITIES 208.07 100.00 108.07 417.14 200.00 217.14 1,200.00 782.86 65.2% 66-MKT-OTHER EXPENSES 6609010 Advertising 4,039.24 2,566.00 1,473.24 6,202.77 5,132.00 1,070.77 151,133.00 144,930.23 95.9% 6609040 Business Meals - 25.00 (25.00) - 50.00 (50.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) - 300.00 (300.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) - 100.00 (100.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 150.00 (134.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 4,039.24 2,866.00 1,173.24 6,335.76 5,732.00 603.76 164,968.00 158,632.24 96.2% TOTAL MARKETING 7,979.42 4,530.00 3,449.42 12,036.58 9,060.00 2,976.58 192,268.00 180,231.42 93.7% 8 SilverRock Resort General and Administrative Expense Statement August 2022 Month to Date Year to Date Annual Budget August 2022 Final Budget Variance Final Budget Variance Annual Budge Unemcumb. %Budget Expense 67-G&A-SALARIES & BENEFITS 6701320 Insurance -Group 2,615.63 3,143.00 (527.37) 5,445.64 6,286.00 (840.36) 37,716.00 32,270.36 85.6% 6701325 Insurance -Workers Comp 1,720.40 1,666.00 54.40 3,193.20 3,332.00 (138.80) 21,077.00 17,883.80 84.8% 6701720 Salaries 17,058.80 20,000.00 (2,941.20) 34,117.60 40,000.00 (5,882.40) 240,000.00 205,882.40 85.8% 6701800 Taxes -Employer Payroll 1,738.07 2,175.00 (436.93) 3,258.18 4,350.00 (1,091.82) 27,510.00 24,251.82 88.2% 6701880 Wages -Hourly 4,651.32 2,311.00 2,340.32 7,808.04 4,622.00 3,186.04 42,156.00 34,347.96 81.5% 6701882 Wages -Overtime - - - - - - - - Total-G&A-SALARIES & BENEFITS 27,784.22 29,295.00 (1,510.78) 53,822.66 58,590.00 (4,767.34) 368,459.00 314,636.34 85.4% 67-G&A-SUPPLIES & MATERIALS 6703740 Supplies -Computer 52.64 500.00 (447.36) 214.98 1,000.00 (785.02) 6,300.00 6,085.02 96.6% 6703762 Supplies -Office - 105.00 (105.00) 1,131.36 210.00 921.36 1,260.00 128.64 10.2% 6703768 Supplies -Printing & Stationery 46.55 100.00 (53.45) 46.55 200.00 (153.45) 3,300.00 3,253.45 98_6% Total-G&A-SUPPLIES & MATERIALS 99.19 705.00 (605.81) 1,392.89 1,410.00 (17.11) 10,860.00 9,467.11 87.2% 67-G&A-REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment - 100.00 (100.00) - 100.00 (100.00) 1,900.00 1,900.00 100.0% Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 100.00 (100.00) 1,900.00 1,900.00 100.0% 67-G&A-OTHER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 83.3% 6709090 Contract Services - - - - - - - 0.0% 6709150 Dues & Subscriptions - - - 396.50 50.00 346.50 1,550.00 1,153.50 74.4% 6709180 Employee RecruitinglRelocation 235.24 - 235.24 410.24 - 410.24 1,200.00 789.76 65.8% 6709197 Equipment Rental 683.48 550.00 133.48 1,369.28 1,100.00 269.28 6,600.00 5,230.72 79.3% 6709202 Fees -Bank - 90.00 (90.00) 80.31 180.00 (99.69) 1,080.00 999.69 92.6% 6709208 Fees -Payroll Processing - 1,000.00 (1,000.00) 697.01 2,000.00 (1,302.99) 12,000.00 11,302.99 94.2% 6709220 Freight/Delivery - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0% 6709490 Miscellaneous (29.00) 100.00 (129.00) 53.29 200.00 (146.71) 6,000.00 5,946.71 99.1% 6709620 Postage/Mail Services 367.68 75.00 292.68 367.68 150.00 217.68 900.00 532.32 59.1% 6709625 Professional Fees 669.00 1,500.00 (831.00) 1,338.00 3,000.00 (1,662.00) 28,000.00 26,662.00 95.2% 6709636 Promotion/Entertainment - 100.00 (100.00) 180.00 200.00 (20.00) 1,200.00 1,020.00 85.0% 6709722 Seminars & Training - 200.00 (200.00) - 400.00 (400.00) 3,400.00 3,400.00 100.0% 6709810 Travel - 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms 49.48 75.00 (25.52) 49.48 150.00 (100.52) 1,050.00 1,000.52 95.3% Total-G&A-OTHER EXPENSES 2,475.88 4,340.00 (1,864.12) 5,941.79 8,630.00 (2,688.21) 70,680.00 64,738.21 91_6% Total -GENERAL & ADMINISTRATIVE 30,359.29 34,440.00 (4,080.71) 61,157.34 68,730.00 (7,572.66) 451 899.00 390.741.66 86.5% 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement August 2022 Month to Date Year to Date Annual Budget August 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) 21,623.12 24,000.00 (2,376.88) 144,000.00 122,376.88 85.0% 6800193 Equipment Leases -Maintenance 11,674.14 15,900.00 (4,225.86) 25,364.61 31,800.00 (6,435.39) 190,800.00 165,435.39 86.7% 6800196 Equipment Leases-GPS 2,640.00 2,900.00 (260.00) 5,280.00 5,800.00 (520.00) 34,800.00 29,520.00 84.8% 6800197 Equipment Leases -Others 1,020.33 1,150.00 (129.67) 2,049.58 2,300.00 (250.42) 20,200.00 18,150.42 0.0% Total -LEASES 26,146.03 31,950.00 (5,803.97) 54,317.31 63,900.00 (9,582.69) 389,800.00 335,482.69 86.1% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs•Management Fee 10,374.00 10,374.00 - 20,748.00 20,748.00 - 124,488.00 103,740.00 83.3% 6900800 Personal Property Taxes - - - 5,455.14 5,200.00 255.14 11,800.00 6,344.86 53.8% 6900323 Insurance -Commercial 6,543.51 5,917.00 626.51 13,087.02 11,834.00 1,253.02 71,004.00 57,916.98 81.6% 6900210 FF&E Reserve 1,306.62 1,692.25 (385.63) 3,264.74 3,384.50 (119.76) 74,907.00 71,642.26 95.6% Total-M/SC OTHER EXPENSES 18,224.13 17,983.25 240.88 42,554.90 41,166.50 1,388.40 282,199.00 2 239,644.10 84.9% 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 Charity/Gift Certificate Rain/Wind Checks 5 2 Club Staff 2 36 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 0 0 0 0 2023 2023 2023 2023 2023 2023 January February March April May June 0 0 0 0 0 0