Loading...
02 August 2021 SilverRock Resort - Monthly Financial StatementLVERROCK 0 R E S O R T Monthly Financial Statements July 1, 2021 - August 31, 2021 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue Golf Shop Income Statement 2 C Course Maintenance Expense Statement 4 Outside Service Expense Statement 5 Clubhouse Expense Statement Marketing Expense Statement 7 General 8t Administrative Expense Statement 8 Operating Leases 8t Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement August 2021 Month to Date Year to Date Annual Budget Percentages GIL # Series Account Description August 2021 Unfavorable (-) Annual Final Budget Variance Favorable (+) Final Budget Variance Budget Unemcumb. % Bdgt Income 400000 Golf Green Fee Revenue 101,091.50 88,266.00 12,825.50 14.5% 199,771.75 174,125.00 25,646.75 3,107,870.00 2,908,098.25 6% 401000 Miscellaneous Golf Revenue 8,586.00 2,250.00 6,336.00 281.6% 16,506.00 5,100.00 11,406.00 301,080.00 284,574.00 5% I 410000 Revenue -Golf Shop 10,072.18 5,075.00 4,997.18 98.5% 20,266.24 10,150.00 10,116.24 198,743.00 178,476.76 10% 420000 Food & Beverage Revenue 20,942.46 7,000.00 13,942.46 199.2% 44,648.11 14,088.00 30,560.11 534,903.00 490,254.89 0% Total Income 140,692.14 1 102,591.00 38,101.14 37.1% 281,192.10 203,463.00 77,729.10 4,142,596.00 3,161,403.90 7/ Cost of Goods Sold 510000 COS -Golf Shop 520000 COS -Food & Beverage Total COS Gross Profit Expenses 610000 630000 633000 640000 650000 660000 670000 680000 690000 620000 Golf Pro Shop Course Maintenance Maintenance Water & Energy Outside Services Clubhouse Marketing General & Administrative Leases Miscellaneous Other Expense Food & Beverage Expenses Total Expenses Net Income Rounds of Golf Played Paid Rounds Played Ave $ Per Paid Round Green Fee Ave $ Per Paid Round Merchandise Ave $ Per Paid Miscellaneous 5,561.37 2,841.00 2,720.37 .95.8% 11,277.80 5,682.00 (5,595.80) 111,236.00 99,958.20 10% 8,076.47 4,102.00 3,974.47 .96.9% 15,825.07 15,825.00 (0.07) 186,194.00 170,368.93 8% 13,637.84 6,943.00 6,694.84 .96.4% 27,102.87 21,507.00 (5,595.87) 297,430.00 99,958.20 9% 127,054.30 I 95,648.00 31,406.30 32 g% 254,089.23 181,956.00 72,133.23 3,845,166.00 3,761,445.70 7% 14,991.49 11,295.00 3,696.49 -32.7% 30,207.29 22,590.00 7,617.29 215,716.00 185,508.71 14% 86,145.43 92,710.00 (6,564.57) 7.1% 182,804.60 202,254.00 (19,449.40) 1,744,514.00 1,561,709.40 10% 29,753.60 23,360.00 6,393.60 -27.4% 57,102.20 47,610.00 9,492.20 249,219.00 192,116.80 23% 23,940.99 19,632.00 4,308.99 -21.9% 46,621.19 39,500.00 7,121.19 435,911.00 389,289.81 11% 9,733.51 10,301.00 (567.49) 5.5% 18,094.52 20,602.00 (2,507.48) 127,492.00 109,397.48 14% 8,008.47 4,516.00 3,492.47 -77.3% 18,004.45 9,032.00 8,972.45 191,765.00 173,760.55 9% 28,876.58 30,297.00 (1,420.42) 4.7% 58,326.57 60,444.00 (2,117.43) 383,648.00 325,321.43 15% 26,748.94 28,450.00 (1,701.06) 6.0% 53,549.99 56,900.00 (3,350.01) 347,800.00 294,250.01 15% 17,207.77 17,045.00 162.77 .1.0% 39,436.84 39,242.00 194.84 269,117.00 229,680.16 28,026.21 18,931.00 9,095.21 .48.0% 54,517.12 36,913.00 17,604.12 348,708.00 294,190.88 15% 273,432.99 1256,537.00 16,895.99 g,g% 558,664.77 535,087.00 (23,577.77) 4,313,890.00 3,461,034.35 13% 1,771 1,750 21 1.2% 3,952 3,500 452 43,667 57.08 50.44 6.64 13.2% 83.62 49.75 33.87 71.17 5.69 2.90 2.79 96.1 % 8.48 2.90 5.58 4.55 2.78 1.00 1.78 178.1% 2.26 1.17 1.09 6.89 39,715 9% (12.45) 117% (3.93) 186% 4.63 33% SilverRock Resort Statement of Fees Revenue August 2021 Month to Date Year to Date Annual Budget August I Income 2021 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 101,091.50 88,266.00 12,825.50 199,771.75 174,125.00 25,646.75 3,107,870.00 2,908,098.25 93.6% 4010000 Rider Fee 1,325.00 - 1,325.00 2,800.00 - 2,800.00 5,580.00 2,780.00 49.8% 4040000 Club Rental 840.00 50.00 790.00 1,795.00 100.00 1,695.00 21,500.00 19,705.00 91.7% 4050000 Driving Range 1,500.00 1,700.00 (200.00) 3,090.00 3,500.00 (410.00) 96,200.00 93,110.00 96.8% 4060000 Handicap Fees 361.00 - 361.00 361.00 - 361.00 2,500.00 2,139.00 85.6% 4090000 Ball Retriever/Subcontract 900.00 - 900.00 900.00 500.00 400.00 2,500.00 1,600.00 64.0% 4091000 Golf Professional Rental Fee - - - - - - 7,500.00 7,500.00 100.0% 4092000 Golf Lessons - - - - - - - - 0.0% 4093000 Resident Card Issue 3,660.00 500.00 3,160.00 7,560.00 1,000.00 6,560.00 165,300.00 157,740.00 95.4% Total Revenue Fees 109,677.50 90,516.00 19,161.50 216,277.75 179,225.00 37,052.75 3,408,950.00 3,192,672.25 93.7% Total Income 109,677.50 1 90,516.00 19,161.50 216,277.751 179,225.00 11 3,408,950.00 1 3,192,672.25 193,7% 2 Income 4100000 Sales Miscellaneous 4100110 Sales Hard Goods 4100112 Sales -Soft Goods 5100639 GS-Discounts-Mdse Total Revenue Golf Shop COS 5100150 COS-GS-Hard Goods 5100151 COS-GS-Soft Goods 5100152 COS-GS-Purchase Disc 5100220 COS-GS-Freight Merch Cost of Sales - Golf Shop Gross Profit COS % Expense 61-PS-SALARIES & BENEFITS 6101320 Insurance Group 6101325 Insurance -Workers Comp 6101720 Salaries 6101800 Taxes -Employer Payroll 6101880 Wages -Hourly 6101882 Wages -Overtime Total -PS-SALARIES & BENEFITS 61-PS OTHER EXPENSES 6103742 Supplies -Expendable 6103762 Supplies -Office 6109220 Freight & Delivery 6109490 Miscellaneous 6109150 Dues and Subscriptions 6109500 ProShop-Over/Short 6109722 Seminars/Training 6109810 Travel- Merchandise 6109820 Uniforms 6117840 Telephones Total Expenses -Golf Shop SilverRock Resort Golf Shop Income Statement August 2021 Month to Date Year to Date Annual Budget August 2021 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 284.50 284.50 614.61 614.61 0 0 0% 4,645.65 1,269.00 3,376.65 9,101.43 2,538.00 6,563.43 49,686.00 40,584.57 81.7% 6,443.25 3,806.00 2,637.25 13,238.25 7,612.00 5,626.25 149,057.00 135,818.75 91.1% 1,301.22 1,301.22 2,688.05 2,688.05 2,688.05 0.0% 10,072.18 5,075.00 4,997.18 20,266.24 10,150.00 10,116.24 198,743.00 179,091.37 90.1% 2,440.91 736.00 1,704.91 5,016.39 1,472.00 3,544.39 28,817.88 23,801.49 82.6% 3,019.59 2,208.00 811.59 6,120.79 4,416.00 1,704.79 86,453.06 80,332.27 92.9% (100.20) (147.00) 46.80 (157.44) (294.00) 136.56 (5,764.00) (5,606.56) 97.3% 201.07 44.00 157.07 298.06 88.00 210.06 1,729.00 1,430.94 82.8% 5,561.37 2,841.00 2,720.37 11,277.80 5,682.00 5,595.80 111,235.94 99,958.14 89.9% 4,510.81 2,234.00 2,276.81 8,988.44 4,468.00 4,520.44 87,507.06 79,133.23 90.4% 55.2% 56.0% 0.8% 55.6% 56.0% 0.3% 53.1% 55.8% 105.2% 739.72 736.00 3.72 1,162.64 1,472.00 (309.36) 8,832.00 7,669.36 86.8% 518.20 507.00 11.20 1,068.30 1,014.00 54.30 10,091.00 9,022.70 89.4% 5,168.16 5,350.00 (181.84) 10,336.32 10,700.00 (363.68) 65,000.00 54,663.68 84.1% 1,052.95 794.00 258.95 2,097.06 1,588.00 509.06 15,806.00 13,708.94 86.7% 7,366.44 2,798.00 4,568.44 14,951.45 5,596.00 9,355.45 97,112.00 82,160.55 84.6% 0.54 0.54 (0.54) 0.0% 14,845.47 10,185.00 4,660.47 29,616.31 20,370.00 9,246.31 196,841.00 167,224.69 85.0% 250.00 (250.00) 100.97 500.00 (399.03) 60.88 60.88 80.74 80.74 500.00 (500.00) 1,000.00 (1,000.00) (10.57) (10.57) (12.43) (12.43) 150.00 (150.00) 300.00 (300.00) 100.00 (100.00) 245.09 200.00 45.09 95.71 110.00 (14.29) 176.61 220.00 (43.39) 146.02 1,110.00 963.98 590.98 2,220.00 1,629.02 14,991.49 11,295.00 3,696.49 30,207.29 22,590.00 7,617.29 0.0% 3,000.00 2,899.03 96.6% 75.00 (5.74) -7.7% 6,000.00 6,000.00 100.0% 2,300.00 2,300.00 100.0% 12.43 0.0% 3,690.00 3,690.00 100.0% 90.00 90.00 100.0% 2,400.00 2,154.91 89.8% 1,320.00 1,143.39 86.6% 18,875.00 18,284.02 96.9% 215,716.00 185,508.71 86.0% Net Income 10( 480.68) (9,061.00) 1( 419.68) 21( 218.85) 18( 122.00) 3( 096.85)I (128,208.94) (106,375.48) g3,0�/a 3 SilverRock Resort Course Maintenance Expense Statement August 2021 Month to Date Year to Date Annual Budget August 2021 Annual Final Budget Variance Final Budget Variance Budget Unemcumb. %Budget Expense 63-CM-SALARIES & BENEFITS 6311320 Insurance -Group 4,844.59 6,000.00 (1,155.41) 12,901.99 12,000.00 901.99 99,232.00 86,330.01 87.0% 6311325 Insurance -Workers Comp 1,403.20 1,303.00 100.20 3,093.70 2,606.00 487.70 28,865.00 25,771.30 89.3% 6311720 Salaries 9,339.69 13,500.00 (4,160.31) 13,871.69 27,000.00 (13,128.31) 169,250.00 155,378.31 91.8% 6311800 Taxes -Employer Payroll 4,018.99 3,388.00 630.99 7,713.55 6,776.00 937.55 75,649.00 67,935.45 89.8% 6311880 Wages -Hourly 31,940.12 21,252.00 10,688.12 65,659.42 42,504.00 23,155.42 588,141.00 522,481.58 88.8% 6311882 Wages -Overtime 1,438.32 1,438.32 5,821.51 5,821.51 18,500.00 12,678.49 68.5% Total -CM -SALARIES & BENEFITS 52,984.91 45,443.00 7,541.91 109,061.86 90,886.00 18,175.86 979,637.00 870,575.14 88.9% 63-CM-SUPPLIES & MATERIALS 6313734 Chemicals 190.00 (190.00) 13,944.00 (13,944.00) 50,060.00 50,060.00 100.0% 6313744 Fertilizer 723.07 4,100.00 (3,376.93) 4,045.36 9,970.00 (5,924.64) 93,670.00 89,624.64 95.7% 6313745 Herbicides 600.30 600.30 600.30 600.30 (600.30) 0.0% 6313746 Flowers/Plants 3,050.00 3,050.00 100.0% 6313748 Fuel -Gasoline 2,347.73 3,450.00 (1,102.27) 6,653.45 6,650.00 3.45 46,860.00 40,206.55 85.8% 6313750 Golf Course Accessories 13,140.00 13,140.00 100.0% 6313756 PDA Control 9,900.00 9,900.00 100.0% 6313758 Miscellaneous Supp 799.93 750.00 49.93 999.85 1,500.00 (500.15) 4,350.00 3,350.15 77.0% 6313762 Supplies -Office 0.0% 6313774 Sand 390.00 (390.00) 780.00 (780.00) 13,460.00 13,460.00 100.0% 6313776 Seed 722.34 722.34 116,900.00 116,177.66 99.4% 6313778 Small Tools & Non -Capital Equip 212.97 100.00 112.97 212.97 200.00 12.97 5,000.00 4,787.03 95.7% 6313780 Sod 353.45 4,500.00 (4,146.55) 353.45 9,800.00 (9,446.55) 15,500.00 15,146.55 97.7% 6313782 Topdressing 2,200.00 (2,200.00) 1,757.81 4,200.00 (2,442.19 ) 10,000.00 8,242.19 82.4% Total -CM -SUPPLIES & MATERIALS 5,037.45 15,680.00 (10,642.55) 15,345.53 47,044.00 31( 698.47) 381,890.00 366,544.47 96.0% 63-CM-REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Maint 3,850.00 (3,850.00) 3,605.00 7,700.00 (4,095.00) 30,800.00 27,195.00 88.3% 6315685 CM-R&M-Bldngs & Othr Structures 83.50 750.00 (666.50) 3,667.00 2,000.00 1,667.00 5,550.00 1,883.00 33.9% 6315690 CM -R&M -Equipment 7,319.99 2,500.00 4,819.99 10,545.35 4,500.00 6,045.35 38,500.00 27,954.65 72.6% 6315692 CM -R&M -Irrigation System 3,500.00 (3,500.00) 165.47 7,900.00 (7,734.53) 19,050.00 18,884.53 99.1% 6315696 CM -R&M -Pumps 300.00 1,000.00 (700.00) 300.00 2,000.00 (1,700.00) 10,500.00 10,200.00 97.1% 6315815 CM -R&M -Trees -Pruning Etc 14,050.00 14,050.00 100.0% Total -CM -REPAIRS & MAINTENANCE 7,703.49 11,600.00 (3,896.51) 18,282.82 24,100.00 (5,817.18 ) 118,450.00 100,167.18 84.6% 6317836 Utilities -Natural GasILPG 41.36 15.00 26.36 41.36 30.00 11.36 180.00 138.64 0.0% 6317840 Telephones 1,471.20 850.00 621.20 2,371.45 1,700.00 671.45 10,200.00 7,828.55 76.8% Total -CM -UTILITIES 1,512.56 865.00 647.56 2,412.81 1,730.00 682.81 10,380.00 7,967.19 76.8% 63-CM-OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 (400.00) 800.00 (800.00) 4,800.00 4,800.00 100.0% 6319100 Contract Svcs-Soil/Tissue Test 113.84 113.84 2,000.00 1,886.16 94.3% 6319102 Contract Svcs -Trash Removal 161.49 524.00 (362.51) 163.61 1,048.00 (884.39) 6,288.00 6,124.39 97.4% 6319150 Dues & Subscriptions 680.00 680.00 100.0% 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 - - 1,069.82 100.00 969.82 4,300.00 3,230.18 75.1% 6319490 Miscellaneous 115.98 100.00 15.98 157.99 200.00 (42.01) 1,200.00 1,042.01 86.8% 6319718 Safety Equipment & Training - 100.00 (100.00) 511.91 300.00 211.91 3,850.00 3,338.09 86.7% 6319822 Uniforms 532.20 920.00 (387.80) 1,132.11 1,840.00 (707.89) 11,040.00 9,907.89 89.7% Total -CM -OTHER EXPENSES 809.67 2,244.00 (1,434.33) 3,149.28 4,738.00 1,588.72 41,458.00 38,308.72 92.4^/ SilverRock Resort Course Maintenance Expense Statement August 2021 Month to Date Year to Date Annual Budget August 2021 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632-CM-LANDSCAPE MAINTENANCE 632-CM-LM-SALARIES & BENEFITS 6321320 Insurance -Group 1,126.70 1,104.00 22.70 2,052.08 2,208.00 (155.92) 22,488.00 20,435.92 90.9% :321325 Insurance -Workers Comp 551.09 500.00 51.09 1,311.49 1,000.00 311.49 5,955.00 4,643.51 78.0% 321800 Taxes -Employer Payroll 871.43 1,300.00 (428.57) 1,760.60 2,600.00 (839.40) 15,595.00 13,834.40 88.7% 6321880 Wages -Hourly 14,800.00 13,334.00 1,466.00 27,840.00 26,668.00 1,172.00 156,528.00 128,688.00 82.2% 6321882 Wages -Overtime 748.13 748.13 1,588.13 1,588.13 3,418.00 1,829.87 53.5% Total-CM-LM-SALARIES & BENEFITS 18,097.35 16,238.00 1,859.35 34,552.30 32,476.00 2,076.30 203,984.00 169,431.70 83.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 86,145.43 92,710.00 (6,564.57) 182,804.60 202,254.00 19,449.40 1,744,554.00 1,561,749.40 89.5% Silverrock Resort Course Maintenance Water & Energy August 2021 Month to Date Year to Date Annual Budget August 2021 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633-CM-WATER & ENERGY 6337834 Utilities -Electricity -Pumping 17,980.17 14,210.00 3,770.17 35,855.38 28,310.00 7,545.38 141,610.00 105,754.62 74.7% 6337842 Utilities -Water 11,773.43 9,150.00 2,623.43 21,246.82 19,300.00 1,946.82 107,649.00 86,402.18 80.3% Total -CM -WATER & ENERGY L 29,753.60 23,360.00 6,393.60 57,102.20 47,610.00 9,492.20 249,259.00 192,156.80 77.1% 5 SilverRock Resort Outside Services Expense Statement August2021 Month to Date Year to Date Annual Budget August 2021Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 641-CBR-SALARIES & BENEFITS 6411320 Insurance -Group 376.84 736.00 (359.16) 802.36 1,472.00 (669.64) 8,832.00 8,029.64 90.9% 6411325 Insurance -Workers Comp 584.20 519.00 65.20 1,244.40 1,038.00 206.40 12,597.00 11,352.60 90.1% 6411800 Taxes -Employer Payroll 1,165.75 1,037.00 128.75 2,322.02 2,074.00 248.02 25,193.00 22,870.98 90.8% 6411880 Wages -Hourly 11,988.61 8,330.00 3,658.61 24,149.54 16,660.00 7,489.54 202,354.00 178,204.46 88.1% 6411882 Wages -Overtime 47.38 47.38 100.35 100.35 (100.35) 0.0% Total-CBR-SALARIES & BENEFITS 14,162.78 10,622.00 3,540.78 28,618.67 21,244.00 7,374.67 248,976.00 220,357.33 88.5% 641-CBR-SUPPLIES & MATERIALS 6413732 Supplies -Carts 15.16 15.16 1,850.00 0.0% 6413742 Supplies -Expendable 120.71 1 600.00 (479.29) 120.71 1,200.00 (1,079.29) 6,750.00 6,629.29 98.2% 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 320.00 120.00 200.00 640.00 240.00 400.00 2,182.00 1,542.00 70.70/ 6413796 Supplies -Bottled Water 1,322.80 1,500.00 (177.20) 2,072.55 3,000.00 (927.45) 19,900.00 17,827.45 89.6% Total-CBR-SUPPLIES & MATERIALS 1,763.51 2,245.00 481.49 2,848.42 4,490.00 1,641.58 41,627.00 36,943.74 88.7% 641-CBR-REPAIRS & MAINTENANCE 6415690 CBR-R&M-Equipment 326.24 300.00 26.24 326.24 600.00 (273.76) 3,600.00 3,273.76 90.9% 6415695 CBR-R&M-Cart Maintenance & Repair 1,216.00 1,503.00 287.00 2,432.00 3,006.00 574.00 18,036.00 15,604.00 86.5% Total-CBR-REPAIRS & MAINTENANCE 1,542.24 1,803.00 (260.76) 2,758.24 3,606.00 (847.76) 21,636.00 18,877.76 87.3% 641-CBR-OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 981.22 800.00 181.22 2,234.74 1,600.00 634.74 9,600.00 7,365.26 76.7% 6419220 Freight/Delivery - 75.00 (75.00) 150.00 (150.00) 450.00 450.00 100.0% 6419490 Miscellaneous 108.73 600.00 (491.27) 140.18 1,200.00 (1,059.82) 7,200.00 7,059.82 98.1 % 6419820 Uniforms 407.79 407.79 407.79 407.79 5,200.00 4,792.21 92.2% Total-CBR-OTHER EXPENSES 1,497.74 1,475.00 22.74 2,782.71 2,950.00 (167.29) 22,450.00 19,667.29 87.6% TOTAL-CARTS,BAGROOM & RANGE 18,966.27 16,145.00 22.74 37,008.04 32,290.00 4,718.04 334,689.00 295,846.12 88.4% 643-CS-SALARIES & BENEFITS t I 6431320 Insurance -Group 0.0% 6431325 Insurance -Workers Comp 207.20 178.00 29.20 431.60 368.00 63.60 5,220.00 4,788.40 91.7% 6431800 Taxes -Employer Payroll 330.22 278.00 52.22 678.09 576.00 102.09 8,176.00 7,497.91 91.7% 6431880 Wages -Hourly 4,316.34 2,856.00 1,460.34 8,382.50 5,916.00 2,466.50 83,852.00 75,469.50 90.0% 6431882 Wages -Overtime 0.0% Total -CS -SALARIES & BENEFITS 4,853.76 3,312.00 1,541.76 9,492.19 6,860.00 2,632.19 97,248.00 87,755.81 90.2% 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 120.96 75.00 45.96 120.96 150.00 (29.04) 2,125.00 2,004.04 94.3% Total -CS -OTHER EXPENSES 120.96 175.00 54.04 120.96 350.00 229.04 3,975.00 3,854.04 97.0% Total -COURSE SERVICES 4,974.72 3,487.00 1,487.72 9,613.15 7,210.00 2,403.15 101,223.00 91,609.85 90.5% TOTAL OUTSIDE SERVICES 23,940.99 19,632.00 4,308.99 46,621.19 39,500.00 7,121.19 435,912.00 383,601.93 88.0% 6 Expense 65-CH-SUPPLIES & MATERIALS 6503742 Supplies -Expendable Total -CH -SUPPLIES & MATERIALS 65-CH-UTILITIES 6507836 Utilities -Natural Gas 6507840 Utilities -Telephone 6507842 Utilities -Water 6507844 Utilities -Cable Total -CH -UTILITIES 65-CH-OTHER EXPENSES 6509091 Contract Services -Cleaning 6509099 Contract Services -Security 6509215 Flowers & Decorations 6509490 Miscellaneous 6509718 Safety Equipment & Training Total -CH -OTHER EXPENSES 65-CH-REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 6515686 CH -R&M -Restaurant Repairs 6515690 CH -R&M -Equipment Repair Total -CH -REPAIRS & MAINTENANCE Total CLUBHOUSE SilverRock Resort Clubhouse Expense Statement August 2021 August j 2021 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 400.00 400.00 800.00 800.00 400.00 400.00 800.00 800.00 4,800.00 4,000.00 83.3% 4,800.00 4,000.00 83.3% 1,077.89 850.00 227.89 1,077.89 1,700.00 (622.11) 12,180.00 11,102.11 91.2% 680.90 1,150.00 (469.10) 2,117.56 2,300.00 (182.44) 13,800.00 11,682.44 84.7% 534.71 321.00 213.71 1,106.88 642.00 464.88 3,852.00 2,745.12 71.3% 320.98 380.00 (59.02) 641.96 760.00 (118.04) 4,560.00 3,918.04 85.9% 2,614.48 2,701.00 (86.52) 4,944.29 5,402.00 (457.71) 34,392.00 29,447.71 85.6% 480.00 400.00 80.00 990.00 800.00 190.00 4,800.00 3,810.00 79.4% 5,538.00 5,000.00 538.00 10,077.04 10,000.00 77.04 60,000.00 49,922.96 83.2% 1,900.00 1,900.00 100.0% 373.08 373.08 7,000.00 6,626.92 94.7% 100.00 (100.00) 200.00 (200.00) 1,200.00 1,200.00 100.0% 6,018.00 5,500.00 518.00 11,440.12 11,000.00 440.12 74,900.00 63,459.88 84.7% 701.03 300.00 401.03 910.11 600.00 310.11 3,600.00 2,689.89 74.7% 700.00 (700.00) 1,400.00 (1,400.00) 4,800.00 4,800.00 100.0% 700.00 (700.00) 1,400.00 (1,400.00) 4,800.00 4,800.00 100.0% 701.03 1,700.00 (998.97) 910.11 3,400.00 (2,489.89) 13,200.00 12,289.89 93.1% 9,733.51 10,301.00 (567.49) 18,094.52 20,602.00 (2,507.48) 127,292.00 24,579.78 19.3% 7 SilverRock Resort Marketing Expense Statement August 2021 Month to Date Year to Date Annual Budget August 2021 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 66-MKT-SALARIES & BENEFITS 6601320 Insurance -Group 2,576.00 2,576.00 100.0% 6601325 Insurance -Workers Comp 138.07 78.00 60.07 229.07 156.00 73.07 934.00 704.93 75.5% 6601720 Salaries 1,207.50 1,250.00 (42.50) 3,622.50 2,500.00 1,122.50 15,000.00 11,377.50 75.9% 6601800 Taxes -Employer Payroll 121.70 122.00 (0.30) 365.10 244.00 121.10 1,463.00 1,097.90 75.0% Total -MKT -SALARIES & BENEFITS 1,467.27 1,450.00 17.27 4,216.67 2,900.00 1,316.67 19,973.00 15,756.33 78.9% 66-MKT-SUPPLIES & MATERIALS 6603762 Supplies -Office 27.40 100.00 (72.60) 27.40 200.00 (172.60) 1,200.00 1,172.60 97.7% 6603768 Supplies -Printing & Stationery 48.45 48.45 105.66 105.66 4,425.00 4,319.34 97.6% 75.85 100.00 (24.15) 133.06 200.00 66.94 5,625.00 5,491.94 97.6% 66-MKT-UTILITIES 6607840 Utilities -Telephone 324.89 100.00 224.89 527.38 200.00 327.38 1,200.00 672.62 56.1% Total -MKT -UTILITIES 324.89 100.00 224.89 527.38 200.00 327.38 1,200.00 672.62 56.1% 66-MKT-OTHER EXPENSES 6609010 Advertising 5,669.74 2,566.00 3,103.74 11,086.33 5,132.00 5,954.33 151,133.00 140,046.67 92.7% 6609040 Business Meals 25.00 (25.00) 50.00 (50.00) 300.00 300.00 100.0% 6609080 Collateral Material 150.59 150.59 1,720.88 1,720.88 5,500.00 3,779.12 68.7% 6609102 Contract Services -Web Page 150.00 (150.00) 300.00 (300.00) 1,800.00 1,800.00 100.0% 6609490 Miscellaneous 350.00 350.00 100.0% 6609620 Postage 50.00 (50.00) 100.00 (100.00) 600.00 600.00 100.0% 6609630 Promotion 320.13 320.13 320.13 320.13 700.00 379.87 54.3% 6609633 Promotion -Community 75.00 (75.00) 150.00 (150.00) 2,250.00 2,250.00 100.0% 6609634 Prom otion-MedialVendor 1,000.00 1,000.00 100.0% 6609150 Dues and Subscriptions 735.00 735.00 100.0% 6609820 Uniforms 600.00 600.00 100.0% Total -MKT -OTHER EXPENSES 6,140.46 2,866.00 3,274.46 13,127.34 5,732.00 7,395.34 164,968.00 151,840.66 92.0% Total -MARKETING 8,008.47 4,516.00 3,492.47 18,004.45 9,032.00 8,972.45 191,766.00 173,761.55 90.6% 0 SilverRock Resort General & Administrative Expense Statement August 2021 Month to Date Year to Date Annual Budget August 2021 Final Budget Variance Final Budget Variance Annual Budge Unemcumb. %Budget Expense 67-G&A-SALARIES & BENEFITS 6701320 Insurance -Group 2,575.32 2,688.00 (112.68) 5,319.66 5,376.00 (56.34) 32,256.00 26,936.34 83.5% 6701325 Insurance -Workers Comp 1,308.00 1,227.00 81.00 2,698.10 2,454.00 244.10 15,252.00 12,553.90 82.3% 6701720 Salaries 14,220.40 16,783.00 (2,562.60) 28,440.80 33,566.00 (5,125.20) 204,516.00 176,075.20 86.1% 6701800 Taxes -Employer Payroll 1,371.34 1,922.00 (550.66) 2,686.56 3,844.00 (1,157.44) 23,899.00 21,212.44 88.8% 6701880 Wages -Hourly 4,008.68 2,932.00 1,076.68 6,682.72 5,864.00 818.72 40,492.00 33,809.28 83.5% 6701882 Wages -Overtime Total-G&A-SALARIES & BENEFITS 23,483.74 25,552.00 (2,068.26 ) 45,827.84 51,104.00 (5,276.16 ) 316,415.00 270,587.16 855% 67-G&A-SUPPLIES & MATERIALS 6703740 Supplies -Computer I 100.45 500.00 (399.55) 357.78 1,000.00 (642.22) 6,300.00 5,942.22 94.3% 6703762 Supplies -Office 105.00 (105.00) 21.99 210.00 (188.01) 1,260.00 1,238.01 98.3% 6703768 Supplies -Printing & Stationery 106.84 100.00 6.84 106.84 200.00 93.16 3,300.00 3,193.16 96.8% Total-G&A-SUPPLIES & MATERIALS 207.29 705.00 (497.71) 486.61 1,410.00 (923.39) 10,860.00 10,373.39 955% 67-G&A-REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment Total-G&A-REPAIRS & MAINTENANCE 67-G&A-OTHER EXPENSES 6709020 Auto/Mileage Allowance 6709090 Contract Services 6709150 Dues & Subscriptions 6709180 Employee Recruiting/Relocation 6709197 Equipment Rental 6709202 Fees -Bank 6709208 Fees -Payroll Processing 6709220 Freight/Delivery 6709490 Miscellaneous 6709620 Postage/Mail Services 6709625 Professional Fees 6709636 Promotion/Entertainment 6709722 Seminars & Training 6709810 Travel 6709820 Uniforms Total-G&A-OTHER EXPENSES Total -GENERAL & ADMINISTRATIVE 100.00 (100.00 100.00 (100.00) 500.00 500.00 I 1,000.00 100.00 100.00 1,900.00 1,900.00 100.00 (100.00) 1,900.00 1,900.00 1,000.00 6,000.00 5,000.00 180.00 50.00 130.00 1,150.00 970.00 450.00 450.00 1,356.25 1,356.25 1,200.00 (156.25) 614.12 550.00 64.12 1,210.51 1,100.00 110.51 6,600.00 5,389.49 115.49 90.00 25.49 243.76 180.00 63.76 1,080.00 836.24 1,038.60 1,000.00 38.60 2,186.94 2,000.00 186.94 12,000.00 9,813.06 50.00 (50.00) 100.00 (100.00) 600.00 600.00 106.36 100.00 6.36 470.35 200.00 270.35 6,000.00 5,529.65 160.68 75.00 85.68 360.68 150.00 210.68 900.00 539.32 1,950.30 1,100.00 850.30 4,579.30 2,200.00 2,379.30 13,200.00 8,620.70 100.00 (100.00) 200.00 (200.00) 1,200.00 1,200.00 250.00 200.00 50.00 250.00 400.00 (150.00) 2,400.00 2,150.00 100.00 (100.00) 100.00 (100.00) 1,100.00 1,100.00 75.00 (75.00) 174.33 150.00 24.33 1,050.00 875.67 5,185.55 3,940.00 1,245.55 12,012.12 7,830.00 4,182.12 54,480.00 42,467.88 28,876.58 30,297.00 1,420.42 58,326.57 60,444.00 2,117.43) 383,655.00 325,328.43 100.0% 100.0% 83.3% 0.0% 84.3% -13.0% 81.7% 77.4% 81.8% 100.0% 92.2% I 59.9% 65.3% 100.0% 89.6% 100.0% 834% 78.0% 84.8% 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement August 2021 Expense 68-LEASES 6800192 Equipment Leases -Carts 6800193 Equipment Leases -Maintenance 6800196 Equipment Leases-GPS 6800197 Equipment Leases -Others TM, 1_I LACGC 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 6900800 Personal Property Taxes 6900323 Insurance -Commercial 6900210 FF&E Reserve Total-MISC OTHER EXPENSES Month to Date Year to Date I Annual Budget August 2021 Final Budget Variance I Final Budget Variance Annual Budget Unemcumb. % Budget 8,386.18 12,000.00 (3,613.82) 12,379.40 12,400.00 (20.60) 2,751.00 2,900.00 (149.00) 3,232.36 1,150.00 2,082.36 26,748.94 28,450.00 1,701.06) ` 9,880.00 9,880.00 - 5,305.94 5,400.00 (94.06) 2,021.83 1,765.00 256.83 17,207.77 17,045.00 162.77 19,023.12 24,000.00 (4,976.88) 24,758.80 24,800.00 (41.20) 5,391.00 5,800.00 (409.00)1 4,377.07 2,300.00 2,077.07 53,549.99 56,900.00 3,350.01) 19,266.00 19,760.00 (494.00) 5,405.56 5,200.00 205.56 10,769.84 10,800.00 (30.16) 3,995.44 3,482.00 513.44 39,436.84 39,242.00 194.84 144, 000.00 124, 976.88 148,800.00 124,041.20 34,800.00 29,409.00 20,200.00 15,822.93 347,800.00 294,250.01 118,560.00 99,294.00 11,800.00 6,394.44 64,800.00 54,030.16 62,157.00 58,161.56 257,317.00 217,880.16 86.8% 83.4% 84.5% 0.0% 84.6% 83.8% 54.2% 83.4% 93.6% 84.7% 10 SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report-2021-2022 Comp Category Media Sales Promotion 5 Golf Industry VIP Celebrity PGA Comp 4 17 Charity/Gift Certificate Rain/Wind Checks Club Staff 37 48 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 41 70 0 0 0 0 0 0 0 0 0 0 11