Loading...
01 July 2024 SilverRock Resort - Monthly Financial StatementLVCRP\OCK 0 R E S O R T Monthly Financial Statements July 01, 2024 - July 31, 2024 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 8t Administrative Expense Statement 8 Operating Leases 8t Miscellaneous Expense Statement 9 Complimentary Report 10 SilverRock Resort Summary Operating Income Statement July 2024 Month to Date Year to Date Annual Budget G/L # Series Account Description Income July 2024 Final Budget Variance Percentage Difference Final Budget Variance Annual Budget Unemcumb. o / Bdgt 400000 Golf Green Fee Revenue 70,195.91 95,760.00 (25,564.09) -26.7% 70,195.91 95,760.00 (25,564.09) 4,406,783.00 4,336,587.09 2% 401000 Miscellaneous Golf Revenue 5,646.11 4,150.00 1,496.11 36.1% 5,646.11 4,150.00 1,496.11 179,960.00 174,313.89 3% 410000 Revenue -Golf Shop 5,245.35 5,509.00 (263.65) -4.8% 5,245.35 5,509.00 (263.65) 247,518.00 242,272.65 2% 420000 Food & Beverage Revenue 16,911.30 19,000.00 (2,088.70) -11.0% 16,911.30 19,000.00 (2,088.70) 774,989.00 758,077.70 2/ Total Income 97,998.67 124,419.00 (26,420.33) -21.23% 97,998.67 124,419.00 (26,420.33) 5,609,250.00 5,511,251.33 2/ Cost of Goods Sold 510000 COS -Golf Shop 2,728.22 $ 3,081.00 (352.78) 11.5% 2,728.22 3,081.00 352.78 138,526.00 135,797.78 2% 520000 COS -Food & Beverage 7,848.45 $ 5,455.00 2,393.45 -43.9/ 7,848.45 5,455.00 (2,393.45) 221,939.00 214,090.55 4/ Total COS 10,576.67 8,536.00 2,040.67 -23.9/ 10,576.67 8,536.00 (2,040.67) 360,465.00 349,888.33 3/ Gross Profit 87,422.00 115,883.00 (28,461.00) -24.6/ 87,422.00 115,883.00 (28,461.00) 5,248,785.00 5,161,363.00 2/ Expenses 610000 Golf Pro Shop 20,794.27 14,461.00 6,333.27 -43.8% 20,794.27 14,461.00 6,333.27 $ 281,235.00 260,440.73 7% 630000 Course Maintenance 157,620.31 154,896.00 2,724.31 -1.8% 157,620.31 154,896.00 2,724.31 $ 2,076,015.00 1,918,394.69 8% 633000 Maintenance Water & Energy 32,993.06 27,130.00 5,863.06 -21.6% 32,993.06 27,130.00 5,863.06 $ 333,584.00 300,590.94 10% 640000 Outside Services 34,641.13 29,949.00 4,692.13 -15.7% 34,641.13 29,949.00 4,692.13 $ 598,965.00 564,323.87 6% 650000 Clubhouse 12,699.94 13,698.00 (998.06) 7.3% 12,699.94 13,698.00 (998.06) $ 168,276.00 155,576.06 8% 660000 Marketing 6,506.80 5,037.00 1,469.80 -29.2% 6,506.80 5,037.00 1,469.80 $ 170,826.00 164,319.20 4% 670000 General & Administrative 39,721.07 41,969.00 (2,247.93) 5.4% 39,721.07 41,969.00 (2,247.93) $ 520,777.00 481,055.93 8% 680000 Leases 24,491.76 29,572.00 (5,080.24) 17.2% 24,491.76 29,572.00 (5,080.24) $ 421,264.00 396,772.24 6% 690000 Miscellaneous Other Expense 22,428.70 23,951.00 (1,522.30) 6.4% 22,428.70 23,951.00 (1,522.30) $ 295,568.00 273,139.30 8% 620000 Food & Beverage Expenses 30,394.20 36,263.00 (5,868.80) 16.2% 30,394.20 36,263.00 (5,868.80) $ 609,573.00 579,178.80 8% Total Expenses 382,291.24 376,926.00 5,365.24 -1.4% 382,291.24 376,926.00 (5,365.24) 5,476,083.00 4,514,612.96 7/ Net Income (294,869.24) (261,043.00) (33,826.24) -47.2/ (294,869.24) (261,043.00) (33,826.24) (227,298.00) 646,750.04 400000 Rounds of Golf Played Paid Rounds Played 1,234 1,900 (666) -35.1% 1,234 1,900 (666) 44,545 43,311 3% Ave $ Per Paid Round Green Fee 56.88 50.40 6.48 12.9% 56.88 50.40 6.48 98.93 42.04 58% Ave $ Per Paid Round Merchandise 4.25 2.90 1.35 46.6% 4.25 2.90 1.35 5.56 1.31 76% Ave $ Per Paid Miscellaneous 4.58 2.18 2.39 109.5% 4.58 2.18 2.39 4.04 (0.54) 113% SilverRock Resort Statement of Fees - Revenue July 2024 Month to Date Year to Date Annual Budget July 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4000000 Revenue -Fees 70,195.91 95,760.00 (25,564.09) 70,195.91 95,760.00 (25,564.09) 4,406,783.00 4,336,587.09 98.4% 4010000 Rider Fee 670.00 1,000.00 (330.00) 670.00 1,000.00 (330.00) 22,190.00 21,520.00 97.0% 4040000 Club Rental 1,452.11 800.00 652.11 1,452.11 800.00 652.11 42,175.00 40,722.89 96.6% 4050000 Driving Range 2,546.00 1,600.00 946.00 2,546.00 1,600.00 946.00 102,000.00 99,454.00 97.5% 4060000 Handicap Fees 228.00 250.00 (22.00) 228.00 250.00 (22.00) 4,595.00 4,367.00 95.0% 4090000 Ball Retriever/Subcontract 750.00 - 750.00 750.00 - 750.00 6,500.00 5,750.00 88.5% 4091000 Golf Professional Rental Fee - 500.00 (500.00) - 500.00 (500.00) 2,500.00 2,500.00 100.0% Total Miscellaneous Revenue 59646.11 759842.02 49150.00 999910.00 19496.11 (249067.98) 59646.11 75,842.02 49150.00 999910.00 19496.11 (249067.98) 1799960.00 495869743.00 174,313.89 495109900.98 96.9% 98.3% Total Revenue Fees Total Income 759842.02 999910.00 1 (249067.98) 759842.02 999910.00 1 (249067.98) 495869743.00 415109900.98 98.3% SilverRock Resort Golf Shop Income Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Income Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget 4100000 Sales Miscellaneous 138.70 - 138.70 138.70 - 138.70 0 0 0% 4100110 Sales Hard Goods 2,698.50 1,377.00 1,321.50 2,698.50 1,377.00 1,321.50 61,406.00 58,707.50 95.6% 4100112 Sales -Soft Goods 2,408.15 4,132.00 (1,723.85) 2,408.15 4,132.00 (1,723.85) 185,638 183,229.98 98.7% 5100639 GS -Discounts -Mdse - - - - - - - - 0.0% Total Revenue Golf Shop 5,245.35 5,509.00 (263.65) 5,245.35 5,509.00 (263.65) 247,044.13 241,937.48 97.9% COS 5100150 COS -GS -Hard Goods 1,283.01 798.00 485.01 1,283.01 798.00 485.01 35,890.00 34,606.99 96.4% 5100151 COS -GS -Soft Goods 1,380.24 2,396.00 (1,015.76) 1,380.24 2,396.00 (1,015.76) 107,670.00 106,289.76 98.7% 5100152 COS -GS -Purchase Disc (19.82) (160.00) 140.18 (19.82) (160.00) 140.18 (7,178.00) (7,158.18) 0.0% 5100220 COS -GS -Freight Merch 84.79 47.00 37.79 84.79 47.00 37.79 2,153.00 2,068.21 96.1% Cost of Sales - Golf Shop 2,728.22 3,081.00 (352.78) 2,728.22 3,081.00 (352.78) 138,535.00 135,806.78 98.0% Gross Profit 2,517.13 2,428.00 89.13 2,517.13 2,428.00 89.13 108,509.13 106,130.70 97.8% COS % 52.0% 55.9% 3.9% 52.0% 55.9% 3.9% 53.1% 56.1% 105.8% Expense 61 -PS -SALARIES & BENEFITS 6101320 Insurance Group 439.13 1,539.00 (1,099.87) 439.13 1,539.00 (1,099.87) 18,468.00 18,028.87 97.6% 6101325 Insurance -Workers Comp 790.00 793.00 (3.00) 790.00 793.00 (3.00) 16,380.00 15,590.00 95.2% 6101720 Salaries 6,384.00 6,575.00 (191.00) 6,384.00 6,575.00 (191.00) 78,900.00 72,516.00 91.9% 6101800 Taxes -Employer Payroll 2,594.73 979.00 1,615.73 2,594.73 979.00 1,615.73 20,212.00 17,617.27 87.2% 6101880 Wages -Hourly 10,190.14 3,465.00 6,725.14 10,190.14 3,465.00 6,725.14 128,400.00 118,209.86 92.1% 6101882 Wages -Overtime 6.60 - 6.60 6.60 - 6.60 - (6.60) 0.0% Total -PS-SALARIES & BENEFITS 20,404.60 13,351.00 7,053.60 20,404.60 13,351.00 7,053.60 262,360.00 241,955.40 92.2% 61 -PS OTHER EXPENSES 6103762 Supplies -Office - 250.00 (250.00) - 250.00 (250.00) 3000.00 3,000.00 100.0% 6109150 Dues and Subscriptions _ _ _ _ _ - 2300.00 2,300.00 100.0% 6109220 Freight & Delivery _ _ _ _ _ _ 75.00 75.00 100.0% 6109490 Miscellaneous 27.80 500.00 (472.20) 27.80 500.00 (472.20) 6,000.00 5,972.20 99.5% 6109500 ProShop Over/Under (5.50) - (5.50) (5.50) (5.50) - 5.50 0.0% 6109722 Seminars/Training - 150.00 (150.00) - 150.00 (150.00) 3,690.00 3,690.00 100.0% 6109810 Travel - Merchandise _ - _ _ _ _ 90.00 90.00 100.0% 6109820 Uniforms 257.37 100.00 157.37 257.37 100.00 157.37 2,400.00 2,142.63 89.3% 6117840 Telephones 110.00 110.00 - 110.00 110.00 - 1,320.00 1,210.00 91.7% Total - Other Expenses 389.67 1,110.00 (720.33) 389.67 1,110.00 (720.33) 18,875.00 18,485.33 97.9% Total Expenses -Golf Shop 20,794.27 14,461.00 6,333.27 20,794.27 14,461.00 6,333.27 281,235.00 260,440.73 92.6% Net Income (18,277.14) (12,033.00) (6,244.14) (18,277.14) (12,033.00) (6,244.14) (172,725.88) (154,310.04) 89.3% E SilverRock Resort Course Maintenance Expense Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 63 -CM -SALARIES & BENEFITS 6311320 Insurance -Group 9,811.18 8,106.00 1,705.18 9,811.18 8,106.00 1,705.18 100,863.00 91,051.82 90.3% 6311325 Insurance -Workers Comp 3,040.00 2,910.00 130.00 3,040.00 2,910.00 130.00 41,298.00 38,258.00 92.6% 6311720 Salaries 16,152.00 17,210.00 (1,058.00) 16,152.00 17,210.00 (1,058.00) 206,520.00 190,368.00 92.2% 6311800 Taxes -Employer Payroll 6,624.38 5,961.00 663.38 6,624.38 5,961.00 663.38 85,580.00 78,955.62 92.3% 6311880 Wages -Hourly 46,355.00 43,924.00 2,431.00 46,355.00 43,924.00 2,431.00 640,702.00 594,347.00 92.8% 6311882 Wages -Overtime 7,874.27 - 7,874.27 7,874.27 - 7,874.27 30,518.00 22,643.73 74.2% Total -CM -SALARIES & BENEFITS 899856.83 789111.00 119745.83 899856.83 789111.00 119745.83 191059481.00 1,015,624.17 91.9% 63 -CM -SUPPLIES & MATERIALS - 14,000.00 (14,000.00) - 14,000.00 (14,000.00) 47,000.00 47,000.00 100.0% 6313745 Chemicals 6313744 Fertilizer 6,146.79 6,000.00 146.79 6,146.79 6,000.00 146.79 114,000.00 107,853.21 94.6% 6313746 Flowers/Plants - - - - - - 13,000.00 13,000.00 100.0% 6313748 Fuel -Gasoline 5,167.71 6,800.00 (1,632.29) 5,167.71 6,800.00 (1,632.29) 81,600.00 76,432.29 93.7% 6313750 Golf Course Accessories - - - - - - 16,000.00 16,000.00 100.0% 6313756 POA Control 8,542.53 - 8,542.53 8,542.53 - 8,542.53 10,000.00 1,457.47 14.6% 6313758 Miscellaneous Supp 247.77 - 247.77 247.77 - 247.77 5,950.00 5,702.23 95.8% 6313776 Sand - - - - - - 8,500.00 8,500.00 6313778 Seed - - - - - - 150,000.00 150,000.00 100.0% 6313780 Small Tools & Non -Capital Equip 1,710.87 600.00 1,110.87 1,710.87 600.00 1,110.87 7,025.00 5,314.13 75.6% 6313782 Sod 1,984.69 7,500.00 (5,515.31) 1,984.69 7,500.00 (5,515.31) 15,500.00 13,515.31 87.2% 6313784 Topdressing 1,332.04 3,000.00 (1,667.96) 1,332.04 3,000.00 (1,667.96) 19,000.00 17,667.96 93.0% Total--CM-SUPPLIES & MATERIALS 25,132.40 37,900.00 (12,767.60) 25,132.40 37,900.00 (12,767.60) 487,575.00 462,442.60 94.8% 63 -CM -REPAIRS & MAINTENANCE 4,346.00 4,346.00 - 4,346.00 4,346.00 - 52,152.00 47,806.00 91.7% 6315095 CM -R&M -Contract Lake Maint 6315685 CM-R&M-Bldngs & Othr Structures 129.50 500.00 (370.50) 129.50 500.00 (370.50) 6,000.00 5,870.50 97.8% 6315690 CM -R&M -Equipment 5,130.48 3,000.00 2,130.48 5,130.48 3,000.00 2,130.48 46,500.00 41,369.52 89.0% 6315692 CM -R&M -Irrigation System 2,816.13 4,750.00 (1,933.87) 2,816.13 4,750.00 (1,933.87) 33,250.00 30,433.87 91.5% 6315696 CM -R&M -Pumps 1,522.50 1,000.00 522.50 1,522.50 1,000.00 522.50 10,500.00 8,977.50 85.5% 6315815 CM -R&M -Trees -Pruning Etc - - - - - - 16,550.00 16,550.00 100.0% Total -CM-Repair & Maintenance 139944.61 139596.00 348.61 139944.61 139596.00 348.61 164,952.00 151,007.39 91.5% 6317836 Utilities -Natural Gas/LPG 26.54 30.00 (3.46) 26.54 30.00 (3.46) 360.00 333.46 0.0% 6317840 Telephones 788.86 475.00 313.86 788.86 475.00 313.86 5,700.00 4,911.14 86.2% Total -CM -UTILITIES 815.40 505.00 310.40 815.40 505.00 310.40 6,060.00 5,244.60 86.5% 63 -CM -OTHER EXPENSES 6319020 Auto Mileage/Allowance 400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7% 6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,500.00 4,500.00 100.0% 6319102 Contract Svcs -Trash Removal - 524.00 (524.00) - 524.00 (524.00) 6,288.00 6,288.00 100.0% 6319150 Dues & Subscriptions 485.97 - 485.97 485.97 - 485.97 1,100.00 614.03 55.8% 6319170 Employee Education - 50.00 (50.00) - 50.00 (50.00) 3,900.00 3,900.00 100.0% 6319197 Equipment Rental - 200.00 (200.00) - 200.00 (200.00) 3,400.00 3,400.00 100.0% 6319206 Licenses & Permits 1,115.00 100.00 1,015.00 1,115.00 100.00 1,015.00 4,300.00 3,185.00 74.1% 6319490 Miscellaneous 164.22 100.00 64.22 164.22 100.00 64.22 1,200.00 1,035.78 86.3% 6319718 Safety Equipment & Training - 200.00 (200.00) - 200.00 (200.00) 3,850.00 3,850.00 100.0% 6319822 Uniforms 1,245.60 1,210.00 35.60 1,245.60 1,210.00 35.60 14,520.00 13,274.40 91.4% Total -CM -OTHER EXPENSES 3,410.79 2,784.00 626.79 3,410.79 29784.00 626.79 47,858.00 449447.21 92.87% E SilverRock Resort Course Maintenance Expense Statement July 2024 E Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 632 -CM -CONTRACT SERVICES 6321880 Contract Labor 24,460.28 22,000.00 2,460.28 24,460.28 22,000.00 2,460.28 264,000.00 239,539.72 90.7% Total Contract Service 24,460.28 22,000.00 29460.28 24,460.28 22,000.00 29460.28 2649000.00 239,539.72 90.7% Total -COURSE MAINTENANCE 157,620.31 154,896.00 2,724.31 157,620.31 154,896.00 2,724.31 2,075,926.00 1,918,305.69 92.4% Silverrock Resort Course Maintenance Water & Energy July 2024 Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget 633 -CM -WATER & ENERGY 6337834 Utilities -Electricity -Pumping 21,454.25 18,500.00 2,954.25 21,454.25 18,500.00 2,954.25 236,340.00 214,885.75 90.9% 6337842 Utilities -Water 11,538.81 8,630.00 2,908.81 11,538.81 8,630.00 2,908.81 97,244.00 85,705.19 88.1% Total -CM -WATER & ENERGY 32,993.06 27,130.00 5,863.06 32,993.06 27,130.00 5,863.06 333,584.00 300,590.94 90.1% E 5 SilverRock Resort Outside Services Expense Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense -SALARIES & BENEFITS 6411320 Insurance -Group 906.65 1,026.00 (119.35) 906.65 1,026.00 (119.35) $ 16,416.00 15,509.35 94.5% 6411325 Insurance -Workers Comp 1,060.00 1,069.00 (9.00) 1,060.00 1,069.00 (9.00) $ 22,483.00 21,423.00 95.3% 6411800 Taxes -Employer Payroll 1,311.99 1,684.00 (372.01) 1,311.99 1,684.00 (372.01) $ 35,424.00 34,112.01 96.3% 6411880 Wages -Hourly 14,033.48 13,532.00 501.48 14,033.48 13,532.00 501.48 $ 284,534.00 270,500.52 95.1% 6411882 Wages -Overtime 296.01 - 296.01 296.01 - 296.01 $ - (296.01) 0.0% Total -CBR -SALARIES & BENEFITS 177608.13 - 177311.00 - 297.13 - 177608.13 - 177311.00 - 297.13 - 358,857.00 1,850.00 341,248.87 95.1% 0.0% 64 -1 -CBR -SUPPLIES & MATER/ALS 6413732 Supplies -Carts 6413742 Supplies -Expendable 147.73 600.00 (452.27) 147.73 600.00 (452.27) 6,750.00 6,602.27 97.8% 6413748 Supplies -Fuel for Shuttle _ _ _ _ _ _ _ _ 0.0% 6413752 Supplies -Range Balls - - - - - - 15,000.00 15,000.00 100.0% 6413762 Supplies -Office - 25.00 (25.00) - 25.00 (25.00) 525.00 525.00 100.0% 6413768 Supplies -Printing and Stationary _ _ _ _ - - 420.00 420.00 100.0% 6413786 Supplies -Towels 240.00 120.00 120.00 240.00 120.00 120.00 2,182.00 1,942.00 89.0% 6413796 Supplies -Bottled Water 7,472.00 2,500.00 4,972.00 7,472.00 2,500.00 4,972.00 30,000.00 22,528.00 75.1% Total -CBR -SUPPLIES & MATER/ALS 77859.73 - 3,245.00 300.00 47614.73 (300.00) 77859.73 - 37245.00 300.00 47614.73 (300.00) 56,727.00 3,600.00 47,017.27 3,600.00 82.9% 100.0% 641 -CBR -REPAIRS & MAINTENANCE 6415690 CBR -R&M -Equipment 6415695 CBR -R&M -Cart Maintenance & Repai 2,012.00 3,603.00 (1,591.00) 2,012.00 3,603.00 (1,591.00) 18,036.00 16,024.00 88.8% Total -CBR -REPAIRS & MAINTENANCE 2,012.00 748.44 39903.00 800.00 (19891.00) (51.56) 29012.00 748.44 39903.00 800.00 (1,891.00) (51.56) 21,636.00 9,600.00 19,624.00 8,851.56 90.7% 92.2% 641 -CBR -OTHER EXPENSES 6419094 Contract Services-Laundry/Linen 6419220 Freight/Delivery - 75.00 (75.00) - 75.00 (75.00) 450.00 450.00 100.0% 6419490 Miscellaneous - 600.00 (600.00) - 600.00 (600.00) 7,200.00 7,200.00 100.0% 6419820 Uniforms 15.11 - 15.11 15.11 - 15.11 5,200.00 5,184.89 99.7% Total -CBR -OTHER EXPENSES 763.55 28,243.41 250.00 19475.00 259934.00 258.00 (711.45) (711.45) (8.00) 763.55 289243.41 250.00 17475.00 259934.00 258.00 (711.45) 27309.41 (8.00) $ 22,450.00 4597670.00 9,088.00 21,686.45 4299576.59 8,838.00 96.6% 93.5% 97.2% TOTAL-CARTS,BA GROOM& RANGE 643 -CS -SALARIES & BENEFITS 6431325 Insurance -Workers Comp 6431800 Taxes -Employer Payroll 1,797.85 318.00 1,479.85 1,797.85 318.00 1,479.85 $ 11,214.00 9,416.15 84.0% 6431880 Wages -Hourly 4,325.12 3,264.00 1,061.12 4,325.12 3,264.00 1,061.12 $ 115,017.00 110,691.88 96.2% 6431882 Wages -Overtime - - - - - - $ - - 0.0% Total -CS -SALARIES & BENEFITS 67372.97 - 39840.00 50.00 27532.97 (50.00) 67372.97 - 37840.00 50.00 27532.97 (50.00) 135,319.00 1,050.00 128,946.03 1,050.00 95.3% 100.0% 643 -CS -OTHER EXPENSES 6433742 Supplies Expendable 6439490 Miscellaneous _ _ _ _ - - 200.00 200.00 100.0% 6439718 Safety Equipment & Training - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0% 6439820 Uniforms 24.75 75.00 (50.25) 24.75 75.00 (50.25) 2,125.00 2,100.25 98.8% Total -CS -OTHER EXPENSES 24.75 175.00 (150.25) 24.75 175.00 (150.25) 3,975.00 39950.25 99.4% Total -COURSE SERVICES 67397.72 47015.00 27382.72 67397.72 47015.00 27382.72 1397294.00 1327896.28 95.4% TOTAL OUTSIDE SERVICES 34,641.13 29,949.00 4,692.13 34,641.13 29,949.00 4,692.13 598,964.00 558,522.62 93.2% 5 C.j SilverRock Resort Clubhouse Expense Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Annual Final Budget Variance Budget Variance Variance Budget Unemcumb. %Budget Expense 65 -CH -SUPPLIES & MATERIALS 6503742 Supplies -Expendable 200.00 520.00 (320.00) 200.00 520.00 (320.00) 2,400.00 2,200.00 91.7% Total--CH-SUPPLIES & MATERIALS 200.00 520.00 (320.00) 200.00 520.00 (320.00) 2,400.00 2,200.00 91.7% 65 -CH -UTILITIES 6507836 Utilities -Natural Gas 949.28 1,000.00 (50.72) 949.28 1,000.00 (50.72) 12,000.00 11,050.72 92.1% 6507840 Utilities -Telephone 1,356.43 1,750.00 (393.57) 1,356.43 1,750.00 (393.57) 21,000.00 19,643.57 93.5% 6507842 Utilities -Water 593.50 608.00 (14.50) 593.50 608.00 (14.50) 7,296.00 6,702.50 91.9% 6507844 Utilities -Cable 425.07 420.00 5.07 425.07 420.00 5.07 5,040.00 4,614.93 91.6% Total -CH -UTILITIES 3,324.28 3,778.00 (453.72) 3,324.28 3,778.00 (453.72) 45,336.00 42,011.72 92.7% 65 -CH -OTHER EXPENSES 6509091 Contract Services -Cleaning 480.00 500.00 (20.00) 480.00 500.00 (20.00) 8,000.00 7,520.00 94.0% 6509099 Contract Services -Security 6,868.40 7,100.00 (231.60) 6,868.40 7,100.00 (231.60) 85,200.00 78,331.60 91.9% 6509215 Flowers & Decorations - - - - - - 1,900.00 1,900.00 100.0% 6509490 Miscellaneous - - - - - - - - 0.0% 6509718 Safety Equipment & Training - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0% Total--CH-OTHER EXPENSES 7,348.40 7,700.00 (351.60) 7,348.40 7,700.00 (351.60) 96,300.00 88,951.60 92.4% 65 -CH -REPAIRS & MAINTENANCE 6515685 CH -R&M -Building Structures 470.78 300.00 170.78 470.78 300.00 170.78 3,600.00 3,129.22 86.9% 6515686 CH -R&M -Restaurant Repairs - 700.00 (700.00) - 700.00 (700.00) 8,400.00 8,400.00 100.0% 6515690 CH -R&M -Equipment Repair 1,356.48 700.00 656.48 1,356.48 700.00 656.48 8,400.00 7,043.52 83.9% Total -CH -REPAIRS & MAINTENANCE 1,827.26 12,699.94 1,700.00 13,698.00 127.26 (998.06) 1,827.26 12,699.94 1,700.00 13,698.00 127.26 (998.06) 20,400.00 164,436.00 18,572.74 37,145.48 91.0% 22.6% Total CLUBHOUSE C.j 7 SilverRock Resort Marketing Expense Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 66 -MKT -SALARIES & BENEFITS 6601320 Insurance -Group 415.23 - 415.23 415.23 - 415.23 $ 3,591.00 3,175.77 88.4% 6601325 Insurance -Workers Comp 99.00 99.00 - 99.00 99.00 - $ 1,185.00 1,086.00 91.6% 6601720 Salaries 2,500.00 1,250.00 1,250.00 2,500.00 1,250.00 1,250.00 $ 15,000.00 12,500.00 83.3% 6601800 Tax -Employer Payroll 244.00 122.00 122.00 244.00 122.00 122.00 $ 1,462.00 1,218.00 83.3% Total -MKT -SALARIES & BENEFITS 3,258.23 - 1,471.00 100.00 1,787.23 (100.00) 3,258.23 - 1,471.00 100.00 1,787.23 (100.00) 21,238.00 1,200.00 17,979.77 1,200.00 84.7% 100.0% 66 -MKT -SUPPLIES & MATERIALS 6603762 Supplies -Office 6603768 Supplies -Printing & Stationery 133.58 - 133.58 133.58 - 133.58 4,425.00 4,291.42 97.0% Total -MKT -SUPPLIES & MARKET/NG 133.58 100.00 33.58 133.58 100.00 33.58 5,625.00 5,491.42 97.6% 66 -MKT -UTILITIES 6607840 Utilities -Telephone 100.00 100.00 - 100.00 100.00 - 1,200.00 1,100.00 91.7% Total -MKT -UTILITIES 100.00 100.00 - 100.00 100.00 - 1,200.00 1,100.00 91.7% 66 -MKT -OTHER EXPENSES 6609010 Advertising 3,014.99 2,566.00 448.99 3,014.99 2,566.00 448.99 113,787.00 110,772.01 97.4% 6609040 Business Meals - 25.00 (25.00) - 25.00 (25.00) 300.00 300.00 100.0% 6609080 Collateral Material - 500.00 (500.00) - 500.00 (500.00) 21,000.00 21,000.00 100.0% 6609102 Contract Services -Web Page - 150.00 (150.00) - 150.00 (150.00) 1,800.00 1,800.00 100.0% 6609150 Dues & Subscriptions - - - - - - 735.00 735.00 100.0% 6609620 Postage - - - - - - 600.00 600.00 100.0% 6609490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 400.00 400.00 100.0% 6609630 Promotion _ _ _ _ - - 1,000.00 1,000.00 100.0% 6609633 Promotion-Cummunity - 75.00 (75.00) - 75.00 (75.00) 2,250.00 2,250.00 100.0% 6609634 Promotion-Media/Vendor - - - - - - 700.00 700.00 100.0% 6609820 Uniforms - - - - - - 600.00 600.00 100.0% Total -MKT -OTHER EXPENSES 39014.99 39366.00 (351.01) 39014.99 39366.00 (351.01) 1439172.00 1409157.01 97.9% TOTAL MARKET/NG 6,506.80 5,037.00 1,469.80 6,506.80 5,037.00 1,469.80 171,235.00 164,728.20 96.2% 7 0 SilverRock Resort General and Administrative Expense Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. %Budget Expense 67 -G&A -SALARIES & BENEFITS 6701320 Insurance -Group 5,223.83 5,148.00 75.83 5,223.83 5,148.00 75.83 $ 61,776.00 56,552.17 91.5% 6701325 Insurance -Workers Comp 2,050.00 2,052.00 (2.00) 2,050.00 2,052.00 (2.00) $ 24,621.00 22,571.00 91.7% 6701720 Salaries 16,476.06 20,170.00 (3,693.94) 16,476.06 20,170.00 (3,693.94) $ 242,040.00 225,563.94 93.2% 6701800 Taxes -Employer Payroll 2,986.00 2,532.00 454.00 2,986.00 2,532.00 454.00 $ 30,381.00 27,395.00 90.2% 6701880 Wages -Hourly 5,980.62 5,797.00 183.62 5,980.62 5,797.00 183.62 $ 69,564.00 63,583.38 91.4% 6701882 Wages -Overtime - - - - - - $ - - Total-G&A-SALAR/ES & BENEFITS 32,716.51 35,699.00 (2,982.49) 32,716.51 35,699.00 (2,982.49) 428,382.00 395,665.49 92.4% 67 -G&A -SUPPLIES & MATERIALS 79.96 500.00 (420.04) 79.96 500.00 (420.04) 6,300.00 6,220.04 98.7% 6703740 Supplies -Computer 6703762 Supplies -Office 86.96 105.00 (18.04) 86.96 105.00 (18.04) 1,260.00 1,173.04 93.1% 6703768 Supplies -Printing & Stationery - 100.00 (100.00) - 100.00 (100.00) 3,300.00 3,300.00 100.0% Total--G&A-SUPPLIES & MATERIALS 166.92 - 705.00 150.00 (538.08) (150.00) 166.92 - 705.00 150.00 (538.08) (150.00) 10,860.00 7,300.00 10,693.08 7,300.00 98.5% 100.0% 67 -G&A -REPAIRS & MAINTENANCE 6705690 Repairs & Maintenance -Equipment Total -G&A -REPAIRS & MAINTENANCE - 150.00 (150.00) - 150.00 (150.00) 7,300.00 7,300.00 100.0% 67-G&A-0THER EXPENSES 6709020 Auto/Mileage Allowance 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7% 6709150 Dues & Subscriptions 1,048.47 50.00 998.47 1,048.47 50.00 998.47 1,550.00 501.53 32.4% 6709180 Employee Recruiting/Relocation 35.00 - 35.00 35.00 - 35.00 1,200.00 1,165.00 97.1% 6709197 Equipment Rental 659.85 1,100.00 (440.15) 659.85 1,100.00 (440.15) 13,200.00 12,540.15 95.0% 6709202 Fees -Bank 73.57 90.00 (16.43) 73.57 90.00 (16.43) 1,080.00 1,006.43 93.2% 6709208 Fees -Payroll Processing 1,481.15 1,500.00 (18.85) 1,481.15 1,500.00 (18.85) 18,000.00 16,518.85 91.8% 6709220 Freight/Delivery - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0% 6709490 Miscellaneous 1,250.00 100.00 1,150.00 1,250.00 100.00 1,150.00 6,000.00 4,750.00 79.2% 6709620 Postage/Mail Services 16.32 75.00 (58.68) 16.32 75.00 (58.68) 900.00 883.68 98.2% 6709625 Expense Professional Fees 1,440.88 1,500.00 (59.12) 1,440.88 1,500.00 (59.12) 18,000.00 16,559.12 92.0% 6709636 Promotion/Entertainment - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0% 6709722 Seminars & Training - 200.00 (200.00) - 200.00 (200.00) 3,400.00 3,400.00 100.0% 6709810 Travel - - - - - - 1,100.00 1,100.00 100.0% 6709820 Uniforms 332.40 150.00 182.40 332.40 150.00 182.40 2,000.00 1,667.60 83.4% Total-G&A-0THER EXPENSES 6,837.64 39,721.07 5,415.00 41,969.00 1,422.64 (2,247.93) 6,837.64 39,721.07 5,415.00 41,969.00 1,422.64 (2,247.93) 74,230.00 520,772.00 67,392.36 481,050.93 90.8% 92.4% Total -GENERAL & ADMINISTRATIVE 0 0 Silverrock Resort Operating Leases & Miscellaneous Other Expense Statement July 2024 Month to Date Year to Date Annual Budget July 2024 Final Budget Variance Final Budget Variance Annual Budget Unemcumb. % Budget Expense 68 -LEASES 6800193 Equipment Leases -Maintenance 18,310.28 18,150.00 160.28 18,310.28 18,150.00 160.28 252,600.00 234,289.72 92.8% 6800195 Trailer Lease - 5,200.00 (5,200.00) - 5,200.00 (5,200.00) - - - 6800196 Equipment Leases -GPS 5,363.33 5,072.00 291.33 5,363.33 5,072.00 291.33 60,864.00 55,500.67 91.2% 6800197 Equipment Leases -Others 818.15 1,150.00 (331.85) 818.15 1,150.00 (331.85) 20,200.00 19,381.85 95.9% Total -LEASES 24,491.76 29,572.00 (5,080.24) 24,491.76 29,572.00 (5,080.24) 333,664.00 309,172.24 92.7% 69-M/SC OTHER EXPENSES 11,437.00 11,436.00 1.00 11,437.00 11,436.00 1.00 137,232.00 125,795.00 91.7% 6900096 Contract Srvcs-Management Fee 6900210 FF&E Reserve 1,403.92 1,915.00 (511.08) 1,403.92 1,915.00 (511.08) 88,136.00 86,732.08 98.4% 6900323 Insurance -Commercial 4,132.64 4,600.00 (467.36) 4,132.64 4,600.00 (467.36) 55,200.00 51,067.36 92.5% 6900800 Personal Property Taxes 5,455.14 6,000.00 (544.86) 5,455.14 6,000.00 (544.86) 15,000.00 9,544.86 63.6% Tota/--M/SC OTHER EXPENSES 22,428.70 23,951.00 (1,522.30)l 22,428.70 23,951.00 (1,522.30)l 295,568.00 273,139.30 92.4% 0 SilverRock Resort -Arnold Palmer Classic Course Comp Golf Report -2024-2025 Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf Comp Category Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf 8 67 0 0 0 0 4 79 0 0 0 0 0 0 0 0 0 0 0 10