Loading...
08 February 2019 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2018 – February 2019 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Golf Shop Income Statement 4 Course Maintenance Expense Statement 5 Outside Service Expense Statement 7 Clubhouse Expense Statement 8 Marketing Expense Statement 9 General & Administrative Expense Statement 10 Operating Leases & Miscellaneous Expense Statement 12 Complimentary Report 13 Annual BudgetAccount Description February Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue476,272.24 552,818.75 (76,546.51) -13.8% 1,863,321.27 1,929,392.25 (66,070.98) 3,401,303.00 1,537,981.73 55%401000 Miscellaneous Golf Revenue41,095.00 44,625.00 (3,530.00) -7.9% 190,041.65 188,785.60 1,256.05 302,066.00 112,024.35 63%410000 Revenue-Golf Shop31,083.90 38,500.00 (7,416.10) -19.3% 144,357.16 157,000.00 (12,642.84) 277,150.00 132,792.84 52%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%9,000.00 9,000.00 - 12,000.00 3,000.00 75%890000 Interest Income- - - 0.0%0.21 - 0.21 - (0.21) 0%Total Income549,951.14 637,443.75 (87,492.61) -13.7% 2,206,720.29 2,284,177.85 (77,457.56) 3,992,519.00 1,785,798.71 55%Cost of Goods Sold510000 COS-Golf Shop16,739.75 20,766.56 (4,026.81) 19.4% 79,452.97 87,098.13 7,645.16 155,121.00 75,668.03 51%Total COS16,739.75 20,766.56 (4,026.81) 19.4% 79,452.97 87,098.13 7,645.16 155,121.00 75,668.03 51%Gross Profit533,211.39 616,677.19 (83,465.80) -13.5% 2,127,267.32 2,197,079.72 (69,812.40) 3,837,398.00 1,710,130.68 55%Expenses610000 Golf Pro Shop 21,401.00 20,377.03 1,023.97 -5.0% 145,718.35 138,473.40 7,244.95 221,115.00 75,396.65 66%630000 Course Maintenance121,296.24 113,380.00 7,916.24 -7.0% 1,189,526.87 1,216,086.00 (26,559.13) 1,740,490.00 550,963.13 68%633000 Maintenance Water & Energy11,382.64 17,148.00 (5,765.36) 33.6% 132,274.54 154,217.00 (21,942.46) 249,838.00 117,563.46 53%640000 Outside Services36,352.53 45,883.33 (9,530.80) 20.8% 242,618.52 232,915.63 9,702.89 354,598.00 111,979.48 68%650000 Clubhouse9,534.01 10,776.00 (1,241.99) 11.5% 83,626.56 90,108.00 (6,481.44) 136,412.00 52,785.44 61%660000 Marketing17,254.71 24,063.00 (6,808.29) 28.3% 146,945.11 160,116.00 (13,170.89) 229,960.00 83,014.89 64%670000 General & Administrative25,975.93 27,792.00 (1,816.07) 6.5% 190,012.34 217,999.00 (27,986.66) 329,053.00 139,040.66 58%680000 Leases25,889.62 26,000.00 (110.38) 0.4% 204,981.40 205,250.00 (268.60) 309,250.00 104,268.60 66%690000 Miscellaneous Other Expense24,543.28 24,556.38 (13.10) 0.1% 159,327.51 158,387.86 939.65 241,826.00 82,498.49 66%Total Expenses293,629.96 309,975.74 (16,345.78) 5.3% 2,495,031.20 2,573,552.89 78,521.69 3,812,542.00 1,317,510.80 65%239,581.43 306,701.45 (67,120.02) -21.9%(367,763.88) (376,473.17) 8,709.29 24,856.00 392,619.88 0%Rounds of Golf PlayedPaid Rounds Played4,678 5,500 (822) -14.9%26,583 27,355 (772) 42,173 15,590 63%Ave $ Per Paid Round Green Fee101.81 100.51 1.30 1.3%70.09 70.53 (0.44) 80.65 10.56 87%Ave $ Per Paid Round Merchandise6.64 7.00 (0.36) -5.1%5.43 5.74 (0.31) 6.57 1.14 83%Ave $ Per Paid Miscellaneous 8.78 8.11 0.67 8.3%7.15 6.90 0.25 7.16 0.01 100%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateFebruary 20191 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees476,272.24 552,818.75 (76,546.51) 1,863,321.27 1,929,392.25 (66,070.98) 3,401,303.00 1,537,981.73 45.2%4010000 Rider Fee1,075.00 1,375.00 (300.00) 6,982.85 4,527.30 2,455.55 7,307.00 324.15 4.4%4040000 Club Rental2,660.00 2,750.00 (90.00) 14,050.00 11,686.50 2,363.50 21,087.00 7,037.00 33.4%4050000 Driving Range19,020.00 16,500.00 2,520.00 61,612.00 60,671.80 940.20 94,872.00 33,260.00 35.1%4060000 Handicap Fees- 400.00 (400.00) - 2,100.00 (2,100.00) 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - 436.80 3,000.00 (2,563.20) 4,000.00 3,563.20 89.1%4091000 Golf Professional Rental Fee 1,000.00 1,000.00 - 4,000.00 4,000.00 - 7,000.00 3,000.00 42.9%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue17,340.00 24,000.00 (6,660.00) 102,960.00 102,800.00 160.00 165,300.00 62,340.00 37.7% Total Revenue Fees517,367.24 598,843.75(81,476.51) 2,053,362.922,118,177.85 (64,814.93) 3,703,369.00 1,650,006.08 44.6%517,367.24 598,843.75(81,476.51) 2,053,362.922,118,177.85 (64,814.93) 3,703,369.00 1,650,006.08 44.6%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetFebruary 20192 RevenuesActual BudgetVariance$476,272.24$552,818.75(76,546.51)Unfavorable: One full day of rain with course closure, multiple other days of rain, frost and winds negatively impacted rounds of golf and revenue. Actual BudgetVariance$31,083.90 $38,500.00(7,416.10)Unfavorable: Poor weather negatively impacted rounds of golf thus driving down merchandise sales. ExpensesActual BudgetVariance$11,382.64 $17,148.00(5,765.36)Favorable: Due to timing of invoices on two of the meters. Unable to get a reading or amount by phone.Actual BudgetVariance$36,352.53 $45,883.33(9,530.80)Unfavorable: Due to early payment for range balls.Actual BudgetVariance$9,534.01 $10,776.00(1,241.99)Favorable: Due to discontinuance of contract cleaning services.Actual BudgetVariance$17,254.71 $24,063.00(6,808.29)Favorable: Due to timing of invoices for advertising.Outside ServicesClubhouseMarketingMaintenance - Water & EnergyVariance ExplanationFebruary 2019The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations areprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee Revenue3-20-133 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous198.80 - 198.80 5,088.62 - 5,088.62 00 0%4100110 Sales Hard Goods9,389.17 9,625.00 (235.83) 49,325.06 39,250.00 10,075.06 69,288.00 19,962.94 28.8%4100112 Sales-Soft Goods23,010.26 28,875.00 (5,864.74) 105,581.26 117,750.00 (12,168.74) 207,863.00 102,281.74 49.2%5100639 GS-Discounts-Mdse (1,514.33) - (1,514.33) (15,637.78) - (15,637.78) - 15,637.78 0.0% Total Revenue Golf Shop31,083.90 38,500.00 (7,416.10) 144,357.16 157,000.00 (12,642.84) 277,151.00 137,882.46 49.7%COS 5100150 COS-GS-Hard Goods 4,847.87 5,387.11 (539.24) 25,861.98 22,538.23 3,323.75 40,187.04 14,325.06 35.6%5100151 COS-GS-Soft Goods 11,521.24 16,161.00 (4,639.76) 49,802.60 67,747.00 (17,944.40) 120,560.54 70,757.94 58.7%5100152 COS-GS-Purchase Disc- (1,116.50) 1,116.50 (149.29) (4,553.01) 4,403.72 (8,037.00) (7,887.71) 98.1%5100220 COS-GS-Freight Merch 370.64 334.95 35.69 3,937.68 1,365.91 2,571.77 2,411.00 (1,526.68) -63.3%Cost of Sales - Golf Shop16,739.75 20,766.56 (4,026.81) 79,452.97 87,098.13 (7,645.16) 155,121.58 75,668.61 48.8%Gross Profit 14,344.15 17,733.44 (3,389.29) 64,904.19 69,901.87 (4,997.68) 122,029.42 62,213.85 51.0%COS % 53.9% 53.9% 0.1% 55.0% 55.5% 0.4% 53.1% 54.9% 103.4%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,026.60 2,436.00 (409.40) 8,347.60 17,052.00 (8,704.40) 26,796.00 18,448.40 68.8%6101325 Insurance-Workers Comp 608.58 540.61 67.97 5,603.52 3,549.30 2,054.22 5,635.00 31.48 0.6%6101720 Salaries4,861.54 4,400.00 461.54 40,861.55 35,200.00 5,661.55 51,000.00 10,138.45 19.9%6101800 Taxes-Employer Payroll 2,176.48 1,874.12 302.36 10,925.60 12,304.23 (1,378.63) 19,935.00 9,009.40 45.2%6101880 Wages-Hourly11,045.77 10,016.30 1,029.47 74,168.89 59,447.87 14,721.02 98,874.00 24,705.11 25.0%6101882 Wages-Overtime220.33 - 220.33 608.12 - 608.12 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 20,939.30 19,267.03 1,672.27 140,515.28 127,553.40 12,961.88 202,240.00 63,285.72 31.3%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office120.63 250.00 (129.37) 1,033.95 2,000.00 (966.05) 3,000.00 1,966.05 65.5%6109220 Freight & Delivery- - - 37.03 75.00 (37.97) 75.00 37.97 50.6%6109490 Miscellaneous176.77 500.00 (323.23) 671.50 4,000.00 (3,328.50) 6,000.00 5,328.50 88.8%6109150 Dues and Subscriptions- - - 1,072.50 - 1,072.50 2,300.00 1,227.50 53.4%6109500 ProShop-Over/Short(6.62) - (6.62) 12.74 - 12.74 - (12.74) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 2,335.00 (2,335.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 30.00 (30.00) 90.00 90.00 100.0%6109820 Uniforms113.10 200.00 (86.90) 2,029.75 1,600.00 429.75 2,400.00 370.25 15.4%6117840 Telephones57.82 110.00 (52.18) 345.60 880.00 (534.40) 1,320.00 974.40 73.8%461.70 1,110.00 (648.30) 5,203.07 10,920.00 (5,716.93) 18,875.00 13,671.93 72.4%21,401.00 20,377.03 1,023.97 145,718.35 138,473.40 7,244.95 221,115.00 76,957.65 34.8%Net Income(7,056.85) (2,643.59) (4,413.26) (80,814.16) (68,571.53) (12,242.63) (99,085.58) (14,743.80) 14.9%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetFebruary 20194 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group10,848.39 9,165.00 1,683.39 69,093.31 66,360.00 2,733.31 103,020.00 33,926.69 32.9%6311325 Insurance-Workers Comp2,716.88 2,124.00 592.88 19,331.05 17,718.00 1,613.05 26,974.00 7,642.95 28.3%6311720 Salaries12,476.92 12,476.92 - 100,653.82 99,815.36 838.46 146,400.00 45,746.18 31.2%6311800 Taxes-Employer Payroll7,870.44 7,365.00 505.44 47,898.46 61,958.00 (14,059.54) 94,048.00 46,149.54 49.1%6311880 Wages-Hourly41,178.68 44,176.08 (2,997.40) 370,374.98 364,433.64 5,941.34 564,695.00 194,320.02 34.4%6311882 Wages-Overtime2,000.00 - 2,000.00 45,650.59 12,350.00 33,300.59 12,350.00 (33,300.59) -269.6%Total-CM-SALARIES & BENEFITS77,091.31 75,307.00 1,784.31 653,002.21 622,635.00 30,367.21 947,487.00 294,484.79 31.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals2,420.59 190.00 2,230.59 30,175.88 8,570.00 21,605.88 17,760.00 (12,415.88) -69.9%6313744 Fertilizer4,084.84 3,020.00 1,064.84 60,237.59 72,900.00 (12,662.41) 100,520.00 40,282.41 40.1%6313745 Herbicides- - - 1,854.50 21,094.00 (19,239.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants- 100.00 (100.00) 2,971.85 2,850.00 121.85 3,050.00 78.15 2.6%6313748 Fuel-Gasoline2,808.10 3,880.00 (1,071.90) 28,295.74 31,700.00 (3,404.26) 46,860.00 18,564.26 39.6%6313750 Golf Course Accessories367.66 160.00 207.66 13,354.21 12,460.00 894.21 13,140.00 (214.21) -1.6%6313756 POA Control- - - 1,828.08 9,900.00 (8,071.92) 9,900.00 8,071.92 81.5%6313758 Miscellaneous Supp696.81 100.00 596.81 3,714.16 3,950.00 (235.84) 4,350.00 635.84 14.6%6313762 Supplies-Office386.02 - 386.02 2,754.03 - 2,754.03 - (2,754.03) 0.0%6313774 Sand- 100.00 (100.00) 4,062.01 13,060.00 (8,997.99) 13,460.00 9,397.99 69.8%6313776 Seed- - - 103,424.93 117,400.00 (13,975.07) 117,400.00 13,975.07 11.9%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) 1,719.91 4,600.00 (2,880.09) 5,000.00 3,280.09 65.6%6313780 Sod180.00 - 180.00 5,343.51 8,800.00 (3,456.49) 13,500.00 8,156.49 60.4%6313782 Topdressing- - - 4,849.65 7,000.00 (2,150.35) 10,000.00 5,150.35 51.5%Total-CM-SUPPLIES & MATERIALS10,944.02 7,650.00 3,294.02 264,586.05 314,284.00 (49,697.95) 380,458.00 115,871.95 30.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint- 3,850.00 (3,850.00) 21,125.00 30,800.00 (9,675.00) 46,200.00 25,075.00 54.3%6315685 CM-R&M-Bldngs & Othr Structures 549.74 250.00 299.74 5,906.03 4,550.00 1,356.03 5,550.00 (356.03) -6.4%6315690 CM-R&M-Equipment2,602.16 2,500.00 102.16 39,907.33 29,500.00 10,407.33 38,500.00 (1,407.33) -3.7%6315692 CM-R&M-Irrigation System5,071.01 1,000.00 4,071.01 18,258.39 15,050.00 3,208.39 19,050.00 791.61 4.2%6315696 CM-R&M-Pumps1,500.00 1,000.00 500.00 10,061.35 8,000.00 2,061.35 10,500.00 438.65 4.2%6315815 CM-R&M-Trees-Pruning Etc- - - 5,190.00 6,050.00 (860.00) 12,050.00 6,860.00 56.9%Total-CM-REPAIRS & MAINTENANCE9,722.91 8,600.00 1,122.91 100,448.10 93,950.00 6,498.10 131,850.00 31,401.90 23.8%6317836 Utilities-Natural Gas/LPG 27.60 15.00 12.60 168.75 120.00 48.75 180.00 11.25 0.0%6317840 Telephones787.35 850.00 (62.65) 6,472.49 6,800.00 (327.51) 10,200.00 3,727.51 36.5%Total-CM-UTILITIES814.95 865.00 (50.05) 6,641.24 6,920.00 (278.76) 10,380.00 3,738.76 36.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%6319100 Contract Svcs-Soil/Tissue Test- - - 691.38 1,000.00 (308.62) 2,000.00 1,308.62 65.4%6319102 Contract Svcs-Trash Removal208.04 524.00 (315.96) 832.16 4,192.00 (3,359.84) 6,288.00 5,455.84 86.8%6319150 Dues & Subscriptions380.00 200.00 180.00 1,220.00 200.00 1,020.00 680.00 (540.00) -79.4%6319170 Employee Education- 1,000.00 (1,000.00) - 1,350.00 (1,350.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) - 2,700.00 (2,700.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits3,100.00 - 3,100.00 3,927.05 400.00 3,527.05 4,300.00 372.95 8.7%6319490 Miscellaneous- 100.00 (100.00) 249.69 800.00 (550.31) 1,200.00 950.31 79.2%6319718 Safety Equipment & Training570.85 200.00 370.85 2,700.59 3,350.00 (649.41) 3,850.00 1,149.41 29.9%6319822 Uniforms1,347.45 920.00 427.45 8,028.75 7,360.00 668.75 11,040.00 3,011.25 27.3%Total-CM-OTHER EXPENSES6,006.34 3,544.00 2,462.34 20,849.62 24,552.00 (3,702.38) 41,458.00 20,608.38 49.7%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetFebruary 2019Month to DateYear to Date5 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,671.28 2,784.00 (112.72) 22,878.22 22,272.00 606.22 33,408.00 10,529.78 31.5%6321325 Insurance-Workers Comp742.80 450.00 292.80 4,677.60 3,987.00 690.60 5,955.00 1,277.40 21.5%6321800 Taxes-Employer Payroll1,090.69 1,561.00 (470.31) 7,462.37 13,971.00 (6,508.63) 20,793.00 13,330.63 64.1%6321880 Wages-Hourly11,536.19 12,004.00 (467.81) 100,459.14 104,052.00 (3,592.86) 156,528.00 56,068.86 35.8%6321882 Wages-Overtime675.75 - 675.75 3,417.44 3,418.00 (0.56) 3,418.00 0.56 0.0%Total-CM-LM-SALARIES & BENEFITS16,716.71 16,799.00 (82.29) 138,894.77 147,700.00 (8,805.23) 220,102.00 81,207.23 36.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) 233.75 725.00 (491.25) 1,025.00 791.25 77.2%6323788 Uniforms- 290.00 (290.00) 2,256.22 2,320.00 (63.78) 3,480.00 1,223.78 35.2%Total-CM-LM-SUPPLIES & MATERIALS- 365.00 (365.00) 2,489.97 3,045.00 (555.03) 4,505.00 2,015.03 44.7%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) 2,614.91 3,000.00 (385.09) 4,250.00 1,635.09 38.5%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) 2,614.91 3,000.00 (385.09) 4,250.00 1,635.09 38.5%121,296.24 113,380.00 7,916.24 1,189,526.87 1,216,086.00 (26,559.13) 1,740,490.00 550,963.13 31.7% February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 5,806.13 5,132.00 674.13 83,969.76 73,995.00 9,974.76 179,791.00 95,821.24 53.3%6337842 Utilities-Water5,576.51 12,016.00 (6,439.49) 48,304.78 80,222.00 (31,917.22) 70,047.00 21,742.22 31.0%11,382.64 17,148.00 (5,765.36) 132,274.54 154,217.00 (21,942.46) 249,838.00 117,563.46 47.1%Silverrock ResortCourse Maintenance Water & EnergyFebruary 2019Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementFebruary 2019Silverrock ResortAnnual BudgetMonth to DateYear to Date6 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group854.76 696.00 158.76 4,197.37 5,568.00 (1,370.63) 8,352.00 4,154.63 49.7%6411325 Insurance-Workers Comp981.52 729.00 252.52 6,599.92 3,769.46 2,830.46 6,172.00 (427.92) -6.9%6411800 Taxes-Employer Payroll2,836.67 2,420.28 416.39 11,809.21 12,514.56 (705.35) 20,493.00 8,683.79 42.4%6411880 Wages-Hourly18,806.13 19,440.00 (633.87) 104,967.49 100,518.50 4,448.99 164,599.00 59,631.51 36.2%6411882 Wages-Overtime737.64 - 737.64 1,933.42 - 1,933.42 - (1,933.42) 0.0%Total-CBR-SALARIES & BENEFITS24,216.7223,285.28931.44 129,507.41122,370.527,136.89 199,616.00 70,108.59 35.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 75.00 (75.00) 696.30 1,650.00 (953.70) 1,850.00 `0.0%6413742 Supplies-Expendable- 1,000.00 (1,000.00) 340.39 5,450.00 (5,109.61) 6,750.00 6,409.61 95.0%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) 309.70 1,800.00 (1,490.30) 3,000.00 2,690.30 89.7%6413752 Supplies-Range Balls- - - 10,568.25 9,000.00 1,568.25 9,000.00 (1,568.25) -17.4%6413762 Supplies-Office- 50.00 (50.00) 14.67 325.00 (310.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 61.55 140.00 (78.45) 420.00 358.45 85.3%6413786 Supplies-Towels160.00 250.00 (90.00) 5,569.97 1,360.00 4,209.97 2,182.00 (3,387.97) -155.3%6413796 Supplies-Bottled Water114.19 7,000.00 (6,885.81) 19,801.18 12,100.00 7,701.18 12,900.00 (6,901.18) -53.5%Total-CBR-SUPPLIES & MATERIALS274.19 8,895.00 (8,620.81) 37,362.01 31,825.00 5,537.01 36,627.00 (1,888.71) -5.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment85.12 300.00 (214.88) 116.62 2,400.00 (2,283.38) 3,600.00 3,483.38 96.8%6415695 CBR-R&M-Cart Maintenance & Repair 3,006.00 500.00 2,506.00 18,231.91 4,450.00 13,781.91 6,450.00 (11,781.91) -182.7%Total-CBR-REPAIRS & MAINTENANCE3,091.12 800.00 2,291.12 18,348.53 6,850.00 11,498.53 10,050.00 (8,298.53) -82.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen736.27 800.00 (63.73) 7,042.20 6,400.00 642.20 9,600.00 2,557.80 26.6%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous331.82 600.00 (268.18) 1,153.09 4,800.00 (3,646.91) 7,200.00 6,046.91 84.0%6419820 Uniforms- - - 895.92 3,000.00 (2,104.08) 5,200.00 4,304.08 82.8%Total-CBR-OTHER EXPENSES1,068.09 1,400.00 (331.91) 9,091.21 14,650.00 (5,558.79) 22,450.00 13,358.79 59.5%TOTAL-CARTS,BAGROOM & RANGE28,650.1234,380.28(331.91) 194,309.16175,695.5218,613.64 268,743.00 73,280.14 27.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp742.80 362.25 380.55 3,439.09 1,747.98 1,691.11 2,630.00 (809.09) -30.8%6431800 Taxes-Employer Payroll1,159.61 1,255.80 (96.19) 4,333.18 6,059.63 (1,726.45) 9,117.00 4,783.82 52.5%6431880 Wages-Hourly5,800.00 9,660.00 (3,860.00) 40,298.75 46,612.50 (6,313.75) 70,133.00 29,834.25 42.5%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,702.41 11,278.05(3,575.64) 48,071.02 54,420.11 (6,349.09) 81,880.00 33,808.98 41.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 82.64 700.00 (617.36) 1,050.00 967.36 92.1%6439490 Miscellaneous- - - 155.70 200.00 (44.30) 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) - 1,500.00 (1,500.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 225.00 (225.00) 238.34 2,800.00 (2,561.66) 3,975.00 3,736.66 94.0%Total-COURSE SERVICES7,702.41 11,503.05(3,800.64) 48,309.36 57,220.11 (8,910.75) 85,855.00 37,545.64 43.7%36,352.5345,883.33(9,530.80) 242,618.52232,915.639,702.89 354,598.00 107,089.12 30.2%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetFebruary 20197 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%65-CH-UTILITIES6507836 Utilities-Natural Gas848.62 300.00 548.62 3,599.27 2,400.00 1,199.27 3,600.00 0.73 0.0%6507840 Utilities-Telephone1,215.59 1,150.00 65.59 8,383.44 9,200.00 (816.56) 13,800.00 5,416.56 39.3%6507842 Utilities-Water764.72 321.00 443.72 6,485.87 2,568.00 3,917.87 3,852.00 (2,633.87) -68.4%6507844 Utilities-Cable495.80 380.00 115.80 3,966.48 3,040.00 926.48 4,560.00 593.52 13.0%Total-CH-UTILITIES3,324.73 2,151.00 1,173.73 22,435.06 17,208.00 5,227.06 25,812.00 3,376.94 13.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning275.00 1,825.00 (1,550.00) 3,699.00 15,200.00 (11,501.00) 22,500.00 18,801.00 83.6%6509099 Contract Services-Security4,711.68 5,000.00 (288.32) 42,174.25 40,000.00 2,174.25 60,000.00 17,825.75 29.7%6509215 Flowers & Decorations- - - - 1,000.00 (1,000.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 2,677.58 3,900.00 (1,222.42) 7,000.00 4,322.42 61.7%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 800.00 (548.53) 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES4,986.68 7,125.00 (2,138.32)48,802.30 60,900.00 (12,097.70)92,600.00 43,797.70 47.3%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures822.60 300.00 522.60 7,849.60 2,400.00 5,449.60 3,600.00 (4,249.60) -118.0%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,193.37 3,200.00 (2,006.63) 4,800.00 3,606.63 75.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 146.23 3,200.00 (3,053.77) 4,800.00 4,653.77 97.0%Total-CH-REPAIRS & MAINTENANCE822.60 1,100.00 (277.40) 9,189.20 8,800.00 389.20 13,200.00 4,010.80 30.4%9,534.01 10,776.00(1,241.99)83,626.56 90,108.00 (6,481.44) 136,412.00 8,021.60 5.9%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetFebruary 20198 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 2,847.12 2,784.00 63.12 4,176.00 1,328.88 31.8%6601325 Insurance-Workers Comp105.20 94.00 11.20 760.03 752.00 8.03 1,129.00 368.97 32.7%6601720 Salaries1,905.20 2,508.00 (602.80) 16,194.20 20,064.00 (3,869.80) 30,096.00 13,901.80 46.2%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 1,234.20 2,608.00 (1,373.80) 3,912.00 2,677.80 68.5%Total-MKT-SALARIES & BENEFITS2,511.49 3,276.00 (764.51) 21,035.55 26,208.00 (5,172.45) 39,313.00 18,277.45 46.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 67.37 100.00 (32.63) 888.61 800.00 88.61 1,200.00 311.39 25.9%6603768 Supplies-Printing & Stationery 237.79 125.00 112.79 5,274.94 3,925.00 1,349.94 4,425.00 (849.94) -19.2%305.16 225.00 80.16 6,163.55 4,725.00 1,438.55 5,625.00 (538.55) -9.6%66-MKT-UTILITIES6607840 Utilities-Telephone 168.49 100.00 68.49 2,436.83 800.00 1,636.83 1,200.00 (1,236.83) -103.1%Total-MKT-UTILITIES168.49 100.00 68.49 2,436.83 800.00 1,636.83 1,200.00 (1,236.83) -103.1%66-MKT-OTHER EXPENSES6609010 Advertising 13,356.50 18,612.00 (5,255.50) 109,067.69 118,498.00 (9,430.31) 169,987.00 60,919.31 35.8%6609040 Business Meals- 25.00 (25.00) - 200.00 (200.00) 300.00 300.00 100.0%6609080 Collateral Material814.07 500.00 314.07 5,833.57 2,500.00 3,333.57 5,500.00 (333.57) -6.1%6609102 Contract Services-Web Page99.00 150.00 (51.00) 495.00 1,200.00 (705.00) 1,800.00 1,305.00 72.5%6609490 Miscellaneous- 50.00 (50.00) - 200.00 (200.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 700.00 500.00 200.00 700.00 - 0.0%6609633 Promotion-Community- 75.00 (75.00) 913.85 1,950.00 (1,036.15) 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 2,000.00 (2,000.00) 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- 400.00 (400.00) - 435.00 (435.00) 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) 299.07 500.00 (200.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES14,269.57 20,462.00 (6,192.43) 117,309.18 128,383.00 (11,073.82) 183,822.00 66,512.82 36.2%17,254.71 24,063.00 (6,808.29) 146,945.11 160,116.00 (13,170.89) 229,960.00 83,014.89 36.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetFebruary 20199 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,518.58 1,509.00 1,009.58 18,766.09 12,072.00 6,694.09 18,108.00 (658.09) -3.6%6701325 Insurance-Workers Comp445.68 677.00 (231.32) 4,329.22 5,192.00 (862.78) 7,905.00 3,575.78 45.2%6701720 Salaries13,494.80 13,851.00 (356.20) 99,705.80 110,208.00 (10,502.20) 177,996.00 78,290.20 44.0%6701800 Taxes-Employer Payroll1,481.81 2,349.00 (867.19) 10,593.60 18,012.00 (7,418.40) 32,800.00 22,206.40 67.7%6701880 Wages-Hourly2,788.05 4,211.00 (1,422.95) 24,529.91 28,305.00 (3,775.09) 27,404.00 2,874.09 10.5%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,728.92 22,597.00 (1,868.08) 157,924.62 173,789.00 (15,864.38) 264,213.00 106,288.38 40.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,726.56 500.00 1,226.56 2,393.04 4,000.00 (1,606.96) 6,300.00 3,906.96 62.0%6703762 Supplies-Office122.04 105.00 17.04 451.67 840.00 (388.33) 1,260.00 808.33 64.2%6703768 Supplies-Printing & Stationery300.27 400.00 (99.73) 1,497.58 1,700.00 (202.42) 3,300.00 1,802.42 54.6%Total-G&A-SUPPLIES & MATERIALS2,148.87 1,005.00 1,143.87 4,342.29 6,540.00 (2,197.71) 10,860.00 6,517.71 60.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 683.14 1,500.00 (816.86) 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 683.14 1,500.00 (816.86) 1,900.00 1,216.86 64.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 33.3%6709150 Dues & Subscriptions- 200.00 (200.00) 330.00 700.00 (370.00) 1,150.00 820.00 71.3%6709180 Employee Recruiting/Relocation446.00 200.00 246.00 1,168.01 1,000.00 168.01 1,200.00 31.99 2.7%6709197 Equipment Rental705.46 550.00 155.46 4,014.29 4,400.00 (385.71) 6,600.00 2,585.71 39.2%6709202 Fees-Bank84.42 90.00 (5.58) 716.42 720.00 (3.58) 1,080.00 363.58 33.7%6709208 Fees-Payroll Processing392.20 1,000.00 (607.80) 4,661.55 8,000.00 (3,338.45) 12,000.00 7,338.45 61.2%6709220 Freight/Delivery- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6709490 Miscellaneous138.84 100.00 38.84 3,719.98 6,200.00 (2,480.02) 6,600.00 2,880.02 43.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services94.72 75.00 19.72 806.91 600.00 206.91 900.00 93.09 10.3%6709625 Professional Fees736.50 850.00 (113.50) 6,308.45 6,800.00 (491.55) 10,200.00 3,891.55 38.2%6709636 Promotion/Entertainment- 100.00 (100.00) 129.41 800.00 (670.59) 1,200.00 1,070.59 89.2%6709722 Seminars & Training- 200.00 (200.00) 250.00 1,600.00 (1,350.00) 2,400.00 2,150.00 89.6%6709810 Travel- 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 957.27 750.00 207.27 1,050.00 92.73 8.8%Total-G&A-OTHER EXPENSES3,098.14 4,090.00 (991.86) 27,062.29 36,170.00 (9,107.71) 52,080.00 25,017.71 48.0%25,975.93 27,792.00 (1,816.07) 190,012.34 217,999.00 (27,986.66) 329,053.00 139,040.66 42.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateGeneral & Administrative Expense StatementAnnual BudgetFebruary 201910 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 78,634.17 80,850.00 (2,215.83) 121,050.00 42,415.83 35.0%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 73,449.60 76,000.00 (2,550.40) 114,000.00 40,550.40 35.6%6800194 Equipment Leases-Trailer843.07 600.00 243.07 5,374.56 4,800.00 574.56 7,200.00 1,825.44 25.4%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 30,960.00 31,200.00 (240.00) 46,800.00 15,840.00 33.8%6800197 Equipment Leases-Others2,166.08 1,950.00 216.08 16,563.07 12,400.00 4,163.07 20,200.00 3,636.93 0.0%25,889.62 26,000.00(110.38) 204,981.40205,250.00 (268.60) 309,250.00 104,268.6033.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 76,000.00 76,000.00 - 114,000.00 38,000.00 33.3%6900210 FF&E Reserve9,525.45 11,056.38 (1,530.93) 37,266.45 38,587.86 (1,321.41) 68,026.00 30,759.55 45.2%6900800 Personal Property Taxes- - - 14,738.21 11,800.00 2,938.21 11,800.00 (2,938.21) -24.9%6900323 Insurance-Commercial5,517.83 4,000.00 1,517.83 31,322.85 32,000.00 (677.15) 48,000.00 16,677.15 34.7%24,543.28 24,556.38(13.10) 159,327.51158,387.86 939.65 241,826.00 82,498.49 34.1%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateFebruary 201911 SilverRock Resort-Arnold Palmer Classic Course Comp Golf Report-2018-2019 2018 2018 2018 2018 2018 2018 Comp Category July August September October November December Media 2 4 Sales Promotion 4 Golf Industry VIP Celebrity PGA Comp 18 20 8 8 18 Charity/Gift Certificate 6 2 4 4 9 12 Rain/Wind Checks 2 2 3 Club Staff 13 37 42 14 39 58 LQ HS Golf 2 3 12 18 39 64 72 18 58 113 2019 2019 2019 2019 2019 2019 Comp Category January February March April May June Media Sales Promotion 2 Golf Industry VIP Celebrity 2 PGA Comp 8 15 Charity/Gift Certificate 10 9 Rain/Wind Checks 2 8 Club Staff 30 28 LQ HS Golf 16 42 68 104 0 0 0 0 12 SilverRock Resort-Arnold Palmer Classic Course Comp Golf Report-2018-2019 February 2019 Date Time Description Category Players 2/15/2019 1:10 p.m.2 Guys Who Golf / Golf Review Website Promo 2 13