Loading...
02 August 2023 SilverRock Resort - Monthly Financial StatementSI LVERROCK® R E SORT Monthly Financial Statements July 1, 2023 - August 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 Et Administrative Expense Statement 8 Operating Leases Ft Miscellaneous Expense Statement 9 SilverRock Resort Summary Operating Income Statement August 2023 Month to Date Year to Date Annual Budget GIL # Series Account Description August 2023 Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income 400000 Golf Green Fee Revenue 1,086.00 84,613.00 (83,527.00) -98.7% 103,756.00 174,061.00 (70,305.00) 4,110,847.00 4,007,091.00 3% 401000 Miscellaneous Golf Revenue 165.00 3,350.00 (3,185.00) -95.1% 5,260.00 7,250.00 (1,990.00) 156,180.00 150,920.00 3% 410000 Revenue -Golf Shop 168.57 5,075.00 (4,906.43) .96.7% 11,105.28 10,440.00 665.28 245,623.00 234,517.72 5% 420000 Food & Beverage Revenue 15,750.00 15,750.00 - 0.0% 40,186.58 38,413.00 1,773.58 710,099.00 669,912.42 6% Total Income 17,169.57 108,788.00 (91,618.43) -84.2% 160,307.86 230,164.00 (69,856.14) 5,222,749.00 5,062,441.14 3% Cost of Goods Sold 510000 COS -Golf Shop 135.10 2,841.00 (2,705.90) 95.2% 5,785.54 5,844.00 58.46 137,475.00 131,689.46 4% 520000 COS -Food & Beverage 6,317.00 6,317.00 - 0.0% 14,648.00 14,648.00 - 218,834.00 204,186.00 7% Total COS 6,452.10 9,158.00 (2,705.90) 29.5% 20,433.54 20,492.00 58.46 356,309.00 335,875.46 6% Gross Profit 10,717.47 99,630.00 (88,912.53) -89.2% 139,874.32 209,672.00 (69,797.68) 4,866,440.00 4,726,565.68 3% Expenses L 610000 Golf Pro Shop 14,273.32 16,074.00 (1,800.68) 11.2% 30,160.90 32,148.00 (1,987.10) 259,447.00 229,286.10 12% 630000 Course Maintenance 149,758.16 121,386.00 28,372.16 -23.4% 262,170.58 263,475.00 (1,304.42) 2,005,608.00 1,743,437.42 13% 633000 Maintenance Water & Energy 31,705.87 23,360.00 8,345.87 -35.7% 63,454.78 47,610.00 15,844.78 282,424.00 218,969.22 22% 640000 Outside Services 17,803.43 26,117.00 (8,313.57) 31.8% 63,313.64 52,184.00 11,129.64 542,757.00 479,443.36 12% 650000 Clubhouse 13,838.68 15,301.00 (1,462.32) 9.6% 28,354.22 30,602.00 (2,247.78) 185,512.00 157,157.78 15% 660000 Marketing 9,929.79 4,540.00 5,389.79 -118.7% 11,790.62 9,080.00 2,710.62 170,814.00 159,023.38 7% 670000 General & Administrative 35,311.31 41,511.00 (6,199.69) 14.9% 82,803.12 82,872.00 (68.88) 472,307.00 389,503.88 18% 680000 Leases 35,355.98 32,636.00 2,719.98 -8.3% 86,916.58 65,272.00 21,644.58 425,344.00 338,427.42 Y0% 690000 Miscellaneous Other Expense 23,680.68 21,501.00 2,179.68 -10.1% 54,817.75 48,299.00 6,518.75 343,521.00 288,703.25 620000 Food & Beverage Expenses 29,739.00 29,739.00 - 0.0% 59,753.00 59,753.00 - 491,697.00 431,944.00 16% Total Expenses 361,396.22 332,165.00 29,231.22 -8.8% 743,535.19 691,295.00 (52,240.19) 5,179,431.00 4,003,951.81 14% Net Income (350,678.75) (232,535.00) (118,143.75) -182.3% (603,660.87) (481,623.00) (122,037.87) (312,991.00) 722,613.87 193% 400000 Rounds of Golf Playe. Paid Rounds Played 63 1,750 (1,687) -96.4% 2,003 3,600 (1,597) 44,125 42,122 5% Ave $ Per Paid Round Green Fee 17.24 48.35 (31.11) -64.3% 51.80 48.35 3.45 93.16 41.36 56% Ave $ Per Paid Round Merchandise 2.68 2.90 (0.22) .7.7% 5.54 2.90 2.64 5.57 0.02 100% Ave $ Per Paid Miscellaneous 2.62 1.91 0.70 36.8% 2.63 2.01 0.61 3.54 0.91 74% 2 SilverRock Resort Statement of Fees - Revenue August 2023 Month to Date Year to Date Annual Budget August Income 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 1,086.00 84,613.00 (83,527.00) 103,756.00 174,061.00 (70,305.00) 3,745,355.00 3,641,599.00 97.2% 4010000 Rider Fee 60.00 1,100.00 (1,040.00) 1,165.00 2,100.00 (935.00) 18,180.00 17,015.00 93.6% 4040000 Club Rental - 750.00 (750.00) 1,725.00 1,550.00 175.00 24,100.00 22,375.00 92.8% 4050000 Driving Range 105.00 1,500.00 (1,395.00) 2,370.00 3,100.00 (730.00) 87,850.00 85,480.00 97.3% 4060000 Handicap Fees - - - - - - 2,050.00 2,050.00 100.0% 4090000 Ball RetrieverlSubcontract - - - - 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 165.00 3,350.00 (3,185.00) 5,260.00 7,250.00 (1,990.00) 142,180.00 136,920.00 96.3% 87,963.00 (86,712.00) 109,016.00 181,311.00 (72,295.00) 3,887,535.00 3,778,519.00 97.2% Total Revenue Fees 1,251.00 Total Income 1 1,251.00 87,963.00 (86,712.00) 109,016.00 181,311.001 (72,295.00) 3,887,535.001 3,778,519.001 97.2% I 2 SilverRock Resort Golf Shop Income Statement August 2023 Month to Date Year to Date Annual Budget Income August 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous - - - 1,198.14 - 1,198.14 0 0 0% 4100110 Sales Hard Goods 85.60 3,806.00 (3,720.40) 5,841.42 7,830.00 (1,988.58) 53,155.00 47,313.58 89.0% 4100112 Sales -Soft Goods 160.00 1,269.00 (1,109.00) 8,467.25 2,610.00 5,857.25 159,464.00 150,996.75 94.7% 5100639 GS -Discounts -Mdse (77.03) • 50,881.20 (4,401.53) - (4,401.53) 159,464.00 163,865.53 0.0% Total Revenue Golf Shop 168.57 5,075.00 46,051.80 11,105.28 10,440.00 665.28 372,083.00 362,175.86 97.3% COS 5100150 COS -GS -Hard Goods 58.04 736.00 (677.96) 2,517.34 1,514.00 1,003.34 43,829.00 41,311.66 94.3% 5100151 COS•GS-Soft Goods 60.97 2,208.00 (2,147.03) 3,206.90 4,542.00 (1,335.10) 98,880.00 95,673.10 96.8% 5100152 COS•GS-Purchase Disc - (147.00) (1,705.00) - (303.00) 303.00 (7,124.00) (7,124.00) 0.0% 5100220 COS -GS -Freight Merch 16.09 44.00 (27.91) 61.30 91.00 (29.70) 1,850.00 1,788.70 96.7% Cost of Sales - Golf Shop 135.10 2,841.00 (4,557.90) 5,785.54 5,844.00 (58.46) 137,435.00 131,649.46 95.8% Gross Profit 33.47 2,234.00 50,609.70 5,319.74 4,596.00 723.74 234,648.00 230,526.40 98.2% COS % 80.1% 56.0% -24.2% 52.1% 56.0% 3.9% 53.1% 36.3% 68.5% Expense 61 -PS -SALARIES 5 BENEFITS 6101320 Insurance Group 337.72 774.00 (436.28) 632.62 1,548.00 (915.38) 9,298.00 8,665.38 93.2% 6101325 Insurance -Workers Comp 850.00 979.00 (129.00) 1,701.46 1,958.00 (256.54) 15,959.00 14,257.54 89.3% 6101720 Salaries 5,769.24 6,436.00 (666.76) 11,538.48 12,872.00 (1,333.52) 77,250.00 65,711.52 85.1% 6101800 Taxes -Employer Payroll 940.58 1,174.00 (233.42) 2,021.72 2,348.00 (326.28) 19,129.00 17,107.28 89.4% 6101880 Wages -Hourly 6,256.83 5,601.00 655.83 14,081.73 11,202.00 2,879.73 118,936.00 104,854.27 88.2% 6101882 Wages -Overtime - - - - - - - - 0.0% Total -PS-SALARIES & BENEFITS 14,154.37 14,964.00 (809.63) 29,976.01 29,928.00 48.01 240,572.00 210,595.99 87.5% 61 -PS OTHER EXPENSES 6103762 Supplies -Office - 250.00 (250.00) 65.94 500.00 (434.06) 3,000.00 2,934.06 97.8% 6109150 Dues and Subscriptions - - - - - 2,300.00 2,300.00 100.0% 6109220 Freight & Delivery - - - - - - 75.00 75.00 100.0% 6109490 Miscellaneous - 500.00 (500.00) - 1,000.00 (1,000.00) 6,000.00 6,000.00 100.0% 6109500 ProShop-Over/Short - - - - - - - 0.0% 6109722 Seminars/Training - 150.00 (150.00) - - - 3,690.00 3,690.00 100.0% 6109810 Travel - Merchandise - - - 300.00 (300.00) 90.00 90.00 100.0% 6109820 Uniforms - 100.00 (100.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0% 6117840 Telephones 118.95 110.00 8.95 118.95 220.00 (101.05) 1,320.00 1,201.05 91.0% Total - Other Expenses 118.95 1,110.00 (991.05) 184.89 2,220.00 (2,035.11) 18,875.00 18,690.11 99.0% TotalExpenses-GolfShop 14,273.32 16,074.00 (1,800.68) 30,160.90 32,148.00 (1,987.10) 259,447.00 229,286.10 88.4% Net Income (14,239.851 (13,840.00) (399.85) (24,841.161 (27,552.001 2,710.84 (24,799.00) 1,240.30 -5.0% 4 Course SilverRock Resort Maintenance Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 7,774.17 6,600.00 1,174.17 14,502.36 13,200.00 1,302.36 112,882.00 98,379.64 87.2% 6311325 Insurance -Workers Comp 2,850.00 3,056.00 (206.00) 4,982.06 5,951.00 (968.94) 37,437.00 32,454.94 86.7% 6311720 Salaries 14,691.38 16,713.00 (2,021.62) 29,382.76 33,426.00 (4,043.24) 200,000.00 170,617.24 85.3% 6311800 Taxes -Employer Payroll 2,307.41 6,151.00 (3,843.59) 6,172.33 11,912.00 (5,739.67) 81,715.00 75,542.67 92.4% 6311880 Wages -Hourly 50,350.55 44,214.00 6,136.55 86,754.24 86,592.00 162.24 619,606.00 532,851.76 86.0% 6311882 Wages -Overtime 2,701.12 2,160.00 541.12 4,999.13 2,160.00 2,839.13 18,500.00 13,500.87 73.0% Total-CM-SALARIES&BENEFITS 80,674.63 78,894.00 1,780.63 146,792.88 153,241.00 (6,448.12) 1,070,140.00 923.347.12 86.3% 63 -CM -SUPPLIES & MATERIALS 6313734 Chemicals 3,972.97 - 3,972.97 4,679.85 - 4,679.85 50,060.00 45,380.15 90.7% 6313744 Fertilizer 8,413.40 3,400.00 5,013.40 13,547.49 9,400.00 4,147.49 110,340.00 96,792.51 87.7% 6313745 Herbicides - 500.00 (500.00) - 14,500.00 (14,500.00) - - 0.0% 6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0% 6313748 Fuel -Gasoline 3,497.10 5,700.00 (2,202.90) 8,432.22 11,400.00 (2,967.78) 53,800.00 45,367.78 84.3% 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 342.48 1,000.00 (657.52) 342.48 2,000.00 (1,657.52) 4,350.00 4,007.52 92.1% 6313762 Supplies -Office - - - - - - - - 0.0% 6313766 Pesticides - - - - 6313774 Sand 3,129.64 - 3,129.64 3,129.64 - 3,129.64 13,460.00 10,330.36 76.7% 6313776 Seed 3,833.45 - 3,833.45 3,833.45 - 3,833.45 325,000.00 321,166.55 98.8% 6313778 Small Tools & Non -Capital Equip 1,157.54 600.00 557.54 2,751.18 1,200.00 1,551.18 5,000.00 2,248.82 45.0% 6313780 Sod (1,513.56) 2,500.00 (4,013.56) 5,653.08 10,000.00 (4,346.92) 15,500.00 9,846.92 63.5% 6313782 Topdressing 962.41 - 962.41 962.41 3,000.00 (2,037.59) 10,000.00 9,037.59 90.4% Total -CM -SUPPLIES & MATERIALS 23,795.43 13,700.00 10,095.43 43,331.80 51,500.00 (8,168.20) 613.600.00 570.268.20 92.9% 63 -CM -REPAIRS & MAINTENANCE 6315095 CM -R&M -Contract Lake Mainl 4,100.00 5,143.00 (1,043.00) 8,200.00 10,286.00 (2,086.00) 30,800.00 22,600.00 73.4% 6315685 CM-R&M-Bldngs & Othr Structures - 750.00 (750.00) 234.98 2,000.00 (1,765.02) 5,550.00 5,315.02 95.8% 6315690 CM -R&M -Equipment 6,482.67 2,500.00 3,982.67 11,946.48 4,500.00 7,446.48 38,500.00 26,553.52 69.0% 6315692 CM -R&M -Irrigation System 1,224.86 3,500.00 (2,275.14) 3,581.68 7,900.00 (4,318.32) 19,050.00 15,468.32 81.2% 6315696 CM -R&M -Pumps - 1,000.00 (1,000.00) - 2,000.00 (2,000.00) 10,500.00 10,500.00 100.0% 6315815 CM -R&M -Trees -Pruning Etc 17,630.00 - 17,630.00 17,630.00 - 17,630.00 14,050.00 (3,580.00) -25.5% Total -CM -REPAIRS & MAINTENANCE 29,437.53 12,893.00 16,544.53 41,593.14 26,686.00 14,907.14 118.450.00 76.856.86 64.9% 6317836 Utilities -Natural GasILPG 21.40 15.00 6.40 21.40 30.00 (8.60) 180.00 158.60 0.0% 6317840 Telephones 2,538.28 850.00 1,688.28 3,644.39 1,700.00 1,944.39 10.200.00 6.555.61 64.3% Total -CM -UTILITIES 2,559.68 865.00 1,694.68 3,665.79 1,730.00 1,935.79 10,380.00 6,714.21 64.7% 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 - 524.00 (524.00) - 1,048.00 (1,048.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions 299.50 - 299.50 429.50 - 429.50 680.00 250.50 36.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 - - - - 100.00 (100.00) 4,300.00 4,300.00 100.0% 6319490 Miscellaneous - 100.00 (100.00) 373.52 200.00 173.52 1,200.00 826.48 68.9% 6319718 Safety Equipment & Training - 100.00 (100.00) - 300.00 (300.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms 91.39 1,210.00 (1,118.61) 183.95 2,420.00 (2,236.05) 11,040.00 10,856.05 98.3% Total -CM -OTHER EXPENSES 790.89 2,534.00 (1,743.11) 1,786.97 5,318.00 (3,531.03) 41,458.00 39,671.03 95.69% 4 4 SilverRock Resort Course Maintenance Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 Final Budget Variance - - 28.372.16 Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERV/CES 12,500.00 12,500.00 12,500.00 12,500.00 25,000.00 25,000.00 25,000.00 25,000.00 - - (1 304.42) 150,000.00 125,000.00 150,000.00 125,000.00 2 004 028.00 1 741 857.42 83.3 83.3 86.9 6321880 Contract Labor Total -CM -LM -SALARIES & BENEFITS Total -COURSE MAINTENANCE 149,758.16 121,386.00 262,170.58 263,475.00 4 Silverrock Resort Course Maintenance Water & Energy August 2023 Month to Date Year to Date Annual Budget August2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 19,058.87 12,647.00 14,210.00 9,150.00 4,848.87 3,497.00 40,824.52 22,630.26 28,310.00 19,300.00 12,514.52 3,330.26 144,810.00 103,985.48 115,484.00 92,853.74 71.8% 80.4% 75.6% 6337834 Utilities -Electricity -Pumping 6337842 Utilities -Water Total--CM-WATER & ENERGY 31,705.87 23,360.00 8,345.87 63,454.78 47,610.00 15 844.78 260,294.00 196,839.22 4 SilverRock Resort Outside Services Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 641 -CBR -SALARIES & BENEFITS 6411320 Insurance -Group 488.87 774.00 (285.13) 885.41 1,548.00 (662.59) 9,912.00 9,026.59 91.1% 6411325 Insurance -Workers Comp 950.00 1,006.00 (56.00) 2,511.01 2,012.00 499.01 19,271.00 16,759.99 87.0% 6411800 Taxes -Employer Payroll 799.92 1,540.00 (740.08) 2,112.71 3,080.00 (967.29) 32,119.00 30,006.29 93.4% 6411880 Wages -Hourly 10,182.52 12,372.00 (2,189.48) 25,488.73 24,744.00 744.73 257,980.00 232,491.27 90.1% 6411882 Wages -Overtime 53.59 - 53.59 160.86 - 160.86 - (160.86) 0.0% Total-CBR-SALAR/ES&BENEFITS 12,474.90 15,692.00 (3,217.10) 31,158.72 31,384.00 (225.28) 319,282.00 288,123.28 90.2% 641 -CBR -SUPPLIES & MATERIALS 6413732 Supplies -Carts - - - - - - 1,850.00 ' 0.0% 6413742 Supplies -Expendable 289.72 600.00 (310.28) 434.58 1,200.00 (765.42) - (434.58) 0.0% 6413752 Supplies -Range Balls - - - - - - 10,000.00 10,000.00 100.0% 6413762 Supplies -Office - 25.00 (25.00) - - - 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationary - - - - -- 420.00 420.00 100.0% 6413786 Supplies -Towels 160.00 120.00 40.00 476.34 240.00 236.34 2,182.00 1,705.66 78.2% 6413796 Supplies -Bottled Water - 2,500.00 (2,500.00) 6,912.00 5,000.00 1,912.00 30,000.00 23,088.00 77.0% Total--CBR-SUPPLIES & MATERIALS 449.72 3,245.00 (2,795.28) 7,822.92 6,440.00 1,382.92 44,977.00 35,304.08 78,50/ 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment - 300.00 (300.00) 10,493.48 600.00 9,893.48 3,600.00 (6,893.48) -191.5% 6415695 CBR -R&M -Cart Maintenance & Repair 1,216.00 1,503.00 (287.00) 2,960.75 3,006.00 (45.25) 18 036.00 15 075.25 83.6% Total -CBR -REPAIRS & MAINTENANCE 1,216.00 1,803.00 (587.00) 13,454.23 3,606.00 9,848.23 21,636.00 8,181.77 37,8 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 160.36 800.00 (639.64) 480.90 1,600.00 (1,119.10) 9,600.00 9,119.10 95.0% 6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) 108.66 1,200.00 (1,091.34) 7,200.00 7,091.34 98.5% 6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0% Total -CBR -OTHER EXPENSES 160.36 1,475.00 (1,314.64) 589.56 2,950.00 (2,360.44) 22,450.00 21,860.44 97,4/ TOTAL-CARTSBAGROOM& RANGE 14,300.98 22,215.00 (1,314.64) 53,025.43 44,380.00 8,645.43 408,345.00 353,469.57 86.6% 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 200.00 257.00 (57.00) 1,051.46 514.00 537.46 7,042.00 5,990.54 85.1% 6431800 Taxes -Employer Payroll 292.02 308.00 (15.98) 774.41 616.00 158.41 9,192.00 8,417.59 91.6% 6431880 Wages -Hourly 3,010.43 3,162.00 (151.57) 8,391.75 6,324.00 2,067.75 94,275.00 85,883.25 91.1% 6431882 Wages -Overtime - - - - - - - - 0.0% Total -CS -SALARIES & BENEFITS 3,502.45 3,727.00 (224.55) 10,217.62 7,454.00 2,763.62 110 509.00 100 291.38 90.8% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable - 50.00 (50.00) 37.99 100.00 (62.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) - 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) 70.59 350.00 (279.41) 3,975.00 3,904.41 98.2% Total -COURSE SERVICES 3,502.45 3,902.00 (399.55) 10,288.21 7,804.00 2,484.21 114,484.00 104,195.79 91.0% TOTAL OUTSIDE SERVICES 17,803.43 26,117.00 (8,313.571 63,313.64 52,184.00 11,129.64 522.829.00 453,760.95 86` 5 6 SilverRock Resort Clubhouse Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & 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 - 1,000.00 (1,000.00) 1,215.92 2,000.00 (784.08) 12,180.00 10,964.08 90.0% 6507840 Utilities -Telephone 1,801.18 1,750.00 51.18 3,585.01 3,500.00 85.01 13,800.00 10,214.99 74.0% 6507842 Utilities -Water 533.84 321.00 212.84 1,070.04 642.00 428.04 3,852.00 2,781.96 72.2% 6507844 Utilities -Cable 721.59 380.00 341.59 1,123.88 760.00 363.88 4,560.00 3,436.12 75.4% Total--CH-UTILITIES 3,056.61 3,451.00 (394.39) 6,994.85 6,902.00 92.851 34,392.00 24,011.33 69.8% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 2,988.22 2,850.00 138.22 5,869.51 5,700.00 169.51 4,800.00 (1,069.51) -22.3% 6509099 Contract Services -Security 6,983.96 6,800.00 183.96 13,459.00 13,600.00 (141.00) 60,000.00 46,541.00 77.6% 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 9,972.18 9,750.00 222.18 19,328.51 19,500.00 (171.49) ■ 67,900.00 48,571.49 71.5% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 310.26 300.00 10.26 1,131.23 600.00 531.23 3,600.00 2,468.77 68.6% 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 99.63 700.00 (600.37) 99.63 1,400.00 (1,300.37)1 8,400.00 8,300.37 98.8% Total -CH -REPAIRS & MAINTENANCE 409.89 1,700.00 (1,290.11) 1,230.86 3,400.00 (2,169.14) 20,400.00 19,169.14 94.0% Total CLUBHOUSE 13,838.68 15,301.00 (1,462.32) 28,354.22 30,602.00 (2,247.78) 127,492.00 38,338.28 30.1% 6 7 SilverRock Resort Marketing Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 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 102.00 102.00 - 204.00 204.00 - 1,121.00 917.00 81.8% 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 122.00 - 244.00 244.00 - 1,463.00 1,219.00 83.3% Total -MKT -SALARIES & BENEFITS 1,474.00 1,474.00 - 2,948.00 2,948.00 - 20,475.00 17,527.00 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 5,243.20 5,243.20 5,243.20 - 5,243.20 4,425.00 (818.20) -18.5% Total -MKT -SUPPLIES & MARKETING 5,243.20 100.00 5,143.20 5,243.20 200.00 5,043.20 5,625.00 381.80 6.8% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 213.60 100.00 113.60 213.60 200.00 13.60 1,200.00 986.40 82.2% Total -MKT -UTILITIES 213.60 100.00 113.60 213.60 200.00 13.60 1,200.00 986.40 82.2% 66 -MKT -OTHER EXPENSES 6609010 Advertising 2,998.99 2,566.00 432.99 3,385.82 5,132.00 (1,746.18) 151,133.00 147,747.18 97.8% 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 - - - - - - 350.00 350.00 100.0% 6609620 Postage - - - - - - 600.00 600.00 100.0% 6609630 Promotion - 50.00 (50.00) - 100.00 (100.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) - 150.00 (150.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 2,998.99 2,866.00 132.99 3,385.82 5,732.00 (2,346.18) 164,968.00 161,582.18 97.9% TOTAL MARKETING 9,949.79 4,540.00 5,389.79 11,790.62 9,080.00 2,710.62 192,268.00 180,477.38 93.9% 7 SilverRock Resort General and Administrative Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 Final Budget Variance Final Budget Variance Annual Budge Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 4,678.81 3,117.00 1,561.81 8,838.82 6,234.00 2,604.82 37,716.00 28,877.18 76.6% 6701325 Insurance -Workers Comp 2,000.00 2,294.00 (294.00) 3,993.84 4,588.00 (594.16) 21,077.00 17,083.16 81.1% 6701720 Salaries 16,749.60 20,141.00 (3,391.40) 37,461.20 40,282.00 (2,820.80) 240,000.00 202,538.80 84.4% 6701800 Taxes -Employer Payroll 1,796.11 2,750.00 (953.89) 4,454.21 5,500.00 (1,045.79) 27,510.00 23,055.79 83.8% 6701880 Wages -Hourly 5,875.78 8,064.00 (2,188.22) 19,436.93 16,128.00 3,308.93 42,156.00 22,719.07 53.9% 6701882 Wages -Overtime 1.73 - (120.91) 5.87 - 5.87 5.87 - Total -G&A -SALARIES & BENEFITS 31,102.03 36,366.00 (5,386.61) 74,190.87 72,732.00 1,458.87 368,464.87 294,274.00 79.9% 67 -G&A -SUPPLIES & MATERIALS 6703740 Supplies -Computer 39.98 500.00 (460.02) 179.09 1,000.00 (820.91) 6,300.00 6,120.91 97.2% 6703762 Supplies -Office • 105.00 (105.00) 60.00 210.00 (150.00) 1,260.00 1,200.00 95.2% 6703768 Supplies -Printing & Stationery 474.96 100.00 374.96 635.63 200.00 435.63 3,300.00 2,664.37 80.7% Total -G&A -SUPPLIES & MATERIALS 514.94 705.00 190.06) 874.72 1,410.00 (535.28) 10,860.00 9,985.28 91.9% 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% 6709150 Dues & Subscriptions 53.29 - 53.29 233.29 50.00 183.29 1,550.00 1,316.71 84.9% 6709180 Employee Recruiting/Relocation 35.00 - 35.00 35.00 - 35.00 1,200.00 1,165.00 97.1% 6709197 Equipment Rental 623.86 550.00 73.86 1,279.04 1,100.00 179.04 6,600.00 5,320.96 80.6% 6709202 Fees -Bank 45.65 90.00 (44.35) 90.91 180.00 (89.09) 1,080.00 989.09 91.6% 6709208 Fees -Payroll Processing 672.89 1,000.00 (327.11) 672.89 2,000.00 (1,327.11) 12,000.00 11,327.11 94.4% 6709220 Freight/Delivery - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0% 6709490 Miscellaneous 269.65 100.00 169.65 769.65 200.00 569.65 6,000.00 5,230.35 87.2% 6709620 Postage/Mail Services 200.00 75.00 125.00 200.00 150.00 50.00 900.00 700.00 77.8% 6709625 Professional Fees 1,044.00 1,500.00 (456.00) 2,686.39 3,000.00 (313.61) 28,000.00 25,313.61 90.4% 6709636 Promotion/Entertainment - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0% 6709722 Seminars & Training 250.00 200.00 50.00 500.00 400.00 100.00 3,400.00 2,900.00 85.3% 6709810 Travel - 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0% 6709820 Uniforms - 75.00 75.00) 270.36 150.00 120.36 1,050.00 779.64 74.3% Total -G&A -OTHER EXPENSES 3,694.34 4,340.00 (645.66) 7,737.53 8,630.00 (892.47) 70,680.00 62,942.47 89_1% Total -GENERAL & ADMINISTRATIVE 35,311.31 41,511.00 (6,199.69) 82,803.12 82,872.00 68.88 451,904.87 369,101.75 81.7% 8 9 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement August 2023 Month to Date Year to Date Annual Budget August 2023 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 68 -LEASES 6800192 Equipment Leases -Carts 10,465.09 10,586.00 (120.91) 20,930.18 21,172.00 (241.82) 144,000.00 123,069.82 85.5% 6800193 Equipment Leases -Maintenance 21,990.96 18,150.00 3,840.96 59,407.81 36,300.00 23,107.81 190,800.00 131,392.19 68.9% 6800196 Equipment Leases -GPS 2,640.00 2,750.00 (110.00) 5,280.00 5,500.00 (220.00) 34,800.00 29,520.00 84.8% 6800197 Equipment Leases -Others 259.93 1,150.00 (890.07) 1,298.59 2,300.00 (1,001.41) 20,200.00 18,901.41 0.0% Total -LEASES 35,355.98 32,636.00 2,719.98 86,916.58 65,272.00 21,644.58 389,800.00 302,883.42 77.7% 69-MISC OTHER EXPENSES 6900096 Contract Srvcs-Management Fee 10,892.00 10,892.00 - 21,784.00 21,784.00 - 124,488.00 102,704.00 82.5% 6900323 Insurance -Commercial 12,766.96 8,917.00 3,849.96 25,525.21 17,834.00 7,691.21 71,004.00 45,478.79 64.1% 6900800 Personal Property Taxes - - - 5,455.14 5,200.00 255.14 11,800.00 6,344.86 53.8% 6900210 FF&E Reserve 21.72 1,692.00 (1,670.28) 2,053.40 3,481.00 (1,427.60) 74,907.00 72,853.60 97.3% Total--M/SC OTHER EXPENSES 23,680.68 21,501.00 2,179.68 54,817.75 48,299.00 6,518.75 282,199.00 227.381.25 80.6% 9