Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11 May 2019 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2018 – May 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 May Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue298,536.47 315,871.88 (17,335.41) -5.5% 3,111,716.18 3,246,340.13 (134,623.95) 3,401,303.00 289,586.82 91%401000 Miscellaneous Golf Revenue23,426.00 26,020.00 (2,594.00) -10.0% 290,954.05 281,295.60 9,658.45 302,066.00 11,111.95 96%410000 Revenue-Golf Shop23,076.67 29,700.00 (6,623.33) -22.3% 237,245.08 262,450.00 (25,204.92) 277,150.00 39,904.92 86%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income0.05 - 0.05 0.0%0.32 - 0.32 - (0.32) 0%Total Income345,539.19 372,091.88 (26,552.69) -7.1% 3,651,415.63 3,801,585.73 (150,170.10) 3,992,519.00 341,103.37 91%Cost of Goods Sold510000 COS-Golf Shop12,860.79 16,624.09 (3,763.30) 22.6% 132,164.62 146,896.27 14,731.65 155,121.00 22,956.38 85%Total COS12,860.79 16,624.09 (3,763.30) 22.6% 132,164.62 146,896.27 14,731.65 155,121.00 22,956.38 85%Gross Profit332,678.40 355,467.79 (22,789.39) -6.4% 3,519,251.01 3,654,689.46 (135,438.45) 3,837,398.00 318,146.99 92%Expenses610000 Golf Pro Shop 21,458.16 23,331.63 (1,873.47) 8.0% 208,646.51 201,858.59 6,787.92 221,115.00 12,468.49 94%630000 Course Maintenance136,691.70 126,069.00 10,622.70 -8.4% 1,570,484.97 1,605,016.00 (34,531.03) 1,740,490.00 170,005.03 90%633000 Maintenance Water & Energy23,067.18 25,736.00 (2,668.82) 10.4% 187,382.65 218,869.00 (31,486.35) 249,838.00 62,455.35 75%640000 Outside Services30,993.05 24,548.07 6,444.98 -26.3% 361,928.43 332,463.76 29,464.67 354,598.00 (7,330.43) 102%650000 Clubhouse11,466.53 10,776.00 690.53 -6.4% 121,929.07 125,236.00 (3,306.93) 136,412.00 14,482.93 89%660000 Marketing12,032.54 13,013.00 (980.46) 7.5% 203,218.41 219,741.00 (16,522.59) 229,960.00 26,741.59 88%670000 General & Administrative28,352.19 28,092.00 260.19 -0.9% 270,900.55 301,175.00 (30,274.45) 329,053.00 58,152.45 82%680000 Leases25,603.68 26,000.00 (396.32) 1.5% 280,852.79 283,250.00 (2,397.21) 309,250.00 28,397.21 91%690000 Miscellaneous Other Expense20,443.07 19,817.44 625.63 -3.2% 227,712.44 225,226.82 2,485.62 241,826.00 14,113.56 94%Total Expenses310,108.10 297,383.14 12,724.96 -4.3% 3,433,055.82 3,512,836.17 79,780.35 3,812,542.00 379,486.18 90%22,570.30 58,084.65 (35,514.35) -61.1%86,195.19 141,853.29 (55,658.10) 24,856.00 (61,339.19) 0%Rounds of Golf PlayedPaid Rounds Played4,708 4,950 (242) -4.9%42,460 43,705 (1,245) 43,155 695 98%Ave $ Per Paid Round Green Fee63.41 63.81 (0.40) -0.6%73.29 74.28 (0.99) 78.82 5.53 93%Ave $ Per Paid Round Merchandise4.90 6.00 (1.10) -18.3%5.59 6.01 (0.42) 6.42 0.83 87%Ave $ Per Paid Miscellaneous 4.98 5.26 (0.28) -5.3%6.85 6.44 0.42 7.00 0.15 98%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMay 20191 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees298,536.47 315,871.88 (17,335.41) 3,111,716.18 3,246,340.13 (134,623.95) 3,401,303.00 289,586.82 8.5%4010000 Rider Fee1,050.00 495.00 555.00 11,232.85 7,062.30 4,170.55 7,307.00 (3,925.85) -53.7%4040000 Club Rental2,840.00 2,475.00 365.00 25,960.00 19,861.50 6,098.50 21,087.00 (4,873.00) -23.1%4050000 Driving Range7,095.00 7,425.00 (330.00) 100,432.00 91,196.80 9,235.20 94,872.00 (5,560.00) -5.9%4060000 Handicap Fees841.00 - 841.00 841.00 2,500.00 (1,659.00) 2,500.00 1,659.00 66.4%4090000 Ball Retriever/Subcontract- - - 1,738.20 4,000.00 (2,261.80) 4,000.00 2,261.80 56.5%4091000 Golf Professional Rental Fee 2,000.00 1,000.00 1,000.00 7,500.00 7,000.00 500.00 7,000.00 (500.00) -7.1%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue9,600.00 15,625.00 (6,025.00) 143,250.00 149,675.00 (6,425.00) 165,300.00 22,050.00 13.3% Total Revenue Fees321,962.47 342,891.88(20,929.41) 3,402,670.233,527,635.73 (124,965.50)3,703,369.00 300,698.77 8.1%321,962.47 342,891.88(20,929.41) 3,402,670.233,527,635.73 (124,965.50)3,703,369.00 300,698.77 8.1%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetMay 20192 RevenuesActual BudgetVariance$23,426.00 $26,020.00(2,594.00)Unfavorable: Due to reduced resident cards issued. Actual BudgetVariance$23,076.67 $29,700.00(6,623.33)Unfavorable: Due to reduction of inventory in preparation of moving the retail to our temporary location.ExpensesActual BudgetVariance$23,067.18 $25,736.00(2,668.82)Favorable: Due to timing of invoices on two of the meters. Unable to get a reading or amount by phone.Actual BudgetVariance$30,993.05 $24,548.076,444.98Unfavorable: Due to an increase in expenses for maintenance of golf carts. This is the final year for this fleet and extra maintenance is required.Actual BudgetVariance$11,466.53 $10,776.00690.53Unfavorable: Due repair and maintenance requirements. The applicances in Food and Beverage are starting to age and they needed replacing.Outside ServicesClubhouseMaintenance - Water & EnergyVariance ExplanationMay 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 SalesMiscellaneous Golf Revenue3-20-133 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous234.98 - 234.98 5,716.41 - 5,716.41 00 0%4100110 Sales Hard Goods9,774.01 7,425.00 2,349.01 81,889.82 65,612.50 16,277.32 69,288.00 (12,601.82) -18.2%4100112 Sales-Soft Goods17,094.00 22,275.00 (5,181.00) 179,881.25 196,837.50 (16,956.25) 207,863.00 27,981.75 13.5%5100639 GS-Discounts-Mdse (4,026.32) - (4,026.32) (30,242.40) - (30,242.40) - 30,242.40 0.0% Total Revenue Golf Shop23,076.67 29,700.00 (6,623.33) 237,245.08 262,450.00 (25,204.92) 277,151.00 45,622.33 16.5%COS 5100150 COS-GS-Hard Goods5,337.04 4,307.00 1,030.04 44,070.80 38,057.00 6,013.80 40,187.04 (3,883.76) -9.7%5100151 COS-GS-Soft Goods 7,454.31 12,920.00 (5,465.69) 83,324.48 114,167.00 (30,842.52) 120,560.54 37,236.06 30.9%5100152 COS-GS-Purchase Disc (8.40) (861.30) 852.90 (214.57) (7,611.06) 7,396.49 (8,037.00) (7,822.43) 97.3%5100220 COS-GS-Freight Merch 77.84 258.39 (180.55) 4,983.91 2,283.33 2,700.58 2,411.00 (2,572.91) -106.7%Cost of Sales - Golf Shop12,860.79 16,624.09 (3,763.30) 132,164.62 146,896.27 (14,731.65) 155,121.58 22,956.96 14.8%Gross Profit 10,215.88 13,075.91 (2,860.03) 105,080.46 115,553.73 (10,473.27) 122,029.42 22,665.37 18.6%COS % 55.7% 56.0% 0.2% 55.7% 56.0% 0.3% 53.1% 50.3% 94.8%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group423.10 2,436.00 (2,012.90) 10,683.27 24,360.00 (13,676.73) 26,796.00 16,112.73 60.1%6101325 Insurance-Workers Comp 1,085.60 522.61 562.99 8,960.32 5,130.63 3,829.69 5,635.00 (3,325.32) -59.0%6101720 Salaries4,812.24 4,400.00 412.24 55,543.49 48,400.00 7,143.49 51,000.00 (4,543.49) -8.9%6101800 Taxes-Employer Payroll 2,061.69 1,811.72 249.97 16,504.01 17,786.19 (1,282.18) 19,935.00 3,430.99 17.2%6101880 Wages-Hourly11,542.89 9,536.30 2,006.59 108,067.84 88,416.77 19,651.07 98,874.00 (9,193.84) -9.3%6101882 Wages-Overtime67.31 - 67.31 833.69 - 833.69 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 19,992.83 18,706.63 1,286.20 200,592.62 184,093.59 16,499.03 202,240.00 3,433.95 1.7%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office92.38 250.00 (157.62) 2,110.26 2,750.00 (639.74) 3,000.00 889.74 29.7%6109220 Freight & Delivery93.56 - 93.56 186.84 75.00 111.84 75.00 (111.84) -149.1%6109490 Miscellaneous18.52 500.00 (481.48) 1,104.95 5,500.00 (4,395.05) 6,000.00 4,895.05 81.6%6109150 Dues and Subscriptions 977.00 2,300.00 (1,323.00) 2,049.50 2,300.00 (250.50) 2,300.00 250.50 10.9%6109500 ProShop-Over/Short(1.16) - (1.16) 0.61 - 0.61 - (0.61) 0.0%6109722 Seminars/Training- 1,250.00 (1,250.00) - 3,655.00 (3,655.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 100.0%6109820 Uniforms236.85 200.00 36.85 2,832.99 2,200.00 632.99 2,400.00 (432.99) -18.0%6117840 Telephones48.18 110.00 (61.82) 499.78 1,210.00 (710.22) 1,320.00 820.22 62.1%1,465.33 4,625.00 (3,159.67) 8,784.93 17,765.00 (8,980.07) 18,875.00 10,090.07 53.5%21,458.16 23,331.63 (1,873.47) 209,377.55 201,858.59 7,518.96 221,115.00 13,524.02 6.1%Net Income(11,242.28) (10,255.72) (986.56) (104,297.09) (86,304.86) (17,992.23) (99,085.58) 9,141.35 -9.2%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetMay 20194 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group6,955.17 9,165.00 (2,209.83) 90,903.16 93,855.00 (2,951.84) 103,020.00 12,116.84 11.8%6311325 Insurance-Workers Comp2,615.68 2,352.00 263.68 28,080.49 24,698.00 3,382.49 26,974.00 (1,106.49) -4.1%6311720 Salaries16,519.14 12,476.92 4,042.22 142,662.64 137,246.12 5,416.52 146,400.00 3,737.36 2.6%6311800 Taxes-Employer Payroll5,840.05 8,154.00 (2,313.95) 66,689.40 86,157.00 (19,467.60) 94,048.00 27,358.60 29.1%6311880 Wages-Hourly53,600.10 50,246.08 3,354.02 508,470.87 513,148.88 (4,678.01) 564,695.00 56,224.13 10.0%6311882 Wages-Overtime4,476.71 - 4,476.71 60,032.55 12,350.00 47,682.55 12,350.00 (47,682.55) -386.1%Total-CM-SALARIES & BENEFITS90,006.85 82,394.00 7,612.85 896,839.11 867,455.00 29,384.11 947,487.00 50,647.89 5.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,438.97 2,200.00 1,238.97 38,331.54 14,060.00 24,271.54 17,760.00 (20,571.54) -115.8%6313744 Fertilizer- 3,350.00 (3,350.00) 62,612.50 89,890.00 (27,277.50) 100,520.00 37,907.50 37.7%6313745 Herbicides- - - 1,854.50 22,710.00 (20,855.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants1,786.98 - 1,786.98 6,577.67 3,050.00 3,527.67 3,050.00 (3,527.67) -115.7%6313748 Fuel-Gasoline3,827.56 3,850.00 (22.44) 38,402.55 43,280.00 (4,877.45) 46,860.00 8,457.45 18.0%6313750 Golf Course Accessories- - - 14,567.51 13,140.00 1,427.51 13,140.00 (1,427.51) -10.9%6313756 POA Control2,492.55 - 2,492.55 8,120.63 9,900.00 (1,779.37) 9,900.00 1,779.37 18.0%6313758 Miscellaneous Supp571.01 100.00 471.01 5,610.69 4,250.00 1,360.69 4,350.00 (1,260.69) -29.0%6313762 Supplies-Office- - - 3,415.41 - 3,415.41 - (3,415.41) 0.0%6313774 Sand- 100.00 (100.00) 6,313.04 13,360.00 (7,046.96) 13,460.00 7,146.96 53.1%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) 2,111.41 4,900.00 (2,788.59) 5,000.00 2,888.59 57.8%6313780 Sod- 1,250.00 (1,250.00) 5,343.51 10,050.00 (4,706.49) 13,500.00 8,156.49 60.4%6313782 Topdressing- 1,500.00 (1,500.00) 4,849.65 8,500.00 (3,650.35) 10,000.00 5,150.35 51.5%Total-CM-SUPPLIES & MATERIALS12,117.07 12,450.00 (332.93) 301,535.54 354,490.00 (52,954.46) 380,458.00 78,922.46 20.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,500.00 3,850.00 (350.00) 24,625.00 42,350.00 (17,725.00) 46,200.00 21,575.00 46.7%6315685 CM-R&M-Bldngs & Othr Structures 320.30 250.00 70.30 6,920.04 5,300.00 1,620.04 5,550.00 (1,370.04) -24.7%6315690 CM-R&M-Equipment3,807.41 2,500.00 1,307.41 52,714.70 36,000.00 16,714.70 38,500.00 (14,214.70) -36.9%6315692 CM-R&M-Irrigation System1,899.58 1,000.00 899.58 22,272.38 18,050.00 4,222.38 19,050.00 (3,222.38) -16.9%6315696 CM-R&M-Pumps- 500.00 (500.00) 10,551.61 10,500.00 51.61 10,500.00 (51.61) -0.5%6315815 CM-R&M-Trees-Pruning Etc- - - 10,240.00 12,050.00 (1,810.00) 12,050.00 1,810.00 15.0%Total-CM-REPAIRS & MAINTENANCE9,527.29 8,100.00 1,427.29 127,323.73 124,250.00 3,073.73 131,850.00 4,526.27 3.4%6317836 Utilities-Natural Gas/LPG22.81 15.00 7.81 241.62 165.00 76.62 180.00 (61.62) 0.0%6317840 Telephones734.28 850.00 (115.72) 8,736.21 9,350.00 (613.79) 10,200.00 1,463.79 14.4%Total-CM-UTILITIES757.09 865.00 (107.91) 8,977.83 9,515.00 (537.17) 10,380.00 1,402.17 13.5%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%6319100 Contract Svcs-Soil/Tissue Test- 1,000.00 (1,000.00) 691.38 2,000.00 (1,308.62) 2,000.00 1,308.62 65.4%6319102 Contract Svcs-Trash Removal104.02 524.00 (419.98) 1,144.22 5,764.00 (4,619.78) 6,288.00 5,143.78 81.8%6319150 Dues & Subscriptions- - - 1,430.00 580.00 850.00 680.00 (750.00) -110.3%6319170 Employee Education- 50.00 (50.00) - 3,850.00 (3,850.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) - 3,300.00 (3,300.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits1,050.00 - 1,050.00 7,194.05 4,300.00 2,894.05 4,300.00 (2,894.05) -67.3%6319490 Miscellaneous- 100.00 (100.00) 282.29 1,100.00 (817.71) 1,200.00 917.71 76.5%6319718 Safety Equipment & Training- 100.00 (100.00) 3,987.85 3,750.00 237.85 3,850.00 (137.85) -3.6%6319822 Uniforms218.00 920.00 (702.00) 10,529.50 10,120.00 409.50 11,040.00 510.50 4.6%Total-CM-OTHER EXPENSES1,772.02 3,294.00 (1,521.98) 29,659.29 39,164.00 (9,504.71) 41,458.00 11,798.71 28.5%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementAnnual BudgetMay 20195 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 4,282.44 2,784.00 1,498.44 35,666.39 30,624.00 5,042.39 33,408.00 (2,258.39) -6.8%6321325 Insurance-Workers Comp742.80 500.00 242.80 6,906.00 5,471.00 1,435.00 5,955.00 (951.00) -16.0%6321800 Taxes-Employer Payroll593.57 1,733.00 (1,139.43) 10,562.18 19,115.00 (8,552.82) 20,793.00 10,230.82 49.2%6321880 Wages-Hourly13,978.00 13,334.00 644.00 138,877.14 143,624.00 (4,746.86) 156,528.00 17,650.86 11.3%6321882 Wages-Overtime1,166.63 - 1,166.63 6,630.45 3,418.00 3,212.45 3,418.00 (3,212.45) -94.0%Total-CM-LM-SALARIES & BENEFITS20,763.44 18,351.00 2,412.44 198,642.16 202,252.00 (3,609.84) 220,102.00 21,459.84 9.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools181.00 75.00 106.00 414.75 950.00 (535.25) 1,025.00 610.25 59.5%6323788 Uniforms1,440.80 290.00 1,150.80 4,351.51 3,190.00 1,161.51 3,480.00 (871.51) -25.0%Total-CM-LM-SUPPLIES & MATERIALS1,621.80 365.00 1,256.80 4,766.26 4,140.00 626.26 4,505.00 (261.26) -5.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 126.14 250.00 (123.86) 2,741.05 3,750.00 (1,008.95) 4,250.00 1,508.95 35.5%Total-CM-LM-REPAIRS & MAINTENANCE126.14 250.00 (123.86) 2,741.05 3,750.00 (1,008.95) 4,250.00 1,508.95 35.5%136,691.70 126,069.00 10,622.70 1,570,484.97 1,605,016.00 (34,531.03) 1,740,490.00 170,005.03 9.8% May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 8,730.96 7,719.00 1,011.96 109,820.15 93,208.00 16,612.15 179,791.00 69,970.85 38.9%6337842 Utilities-Water14,336.22 18,017.00 (3,680.78) 77,562.50 125,661.00 (48,098.50) 70,047.00 (7,515.50) -10.7%23,067.18 25,736.00 (2,668.82) 187,382.65 218,869.00 (31,486.35) 249,838.00 62,455.35 25.0%Total-COURSE MAINTENANCECourse Maintenance Expense StatementMay 2019Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyMay 2019Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group278.29 696.00 (417.71) 5,275.67 7,656.00 (2,380.33) 8,352.00 3,076.33 36.8%6411325 Insurance-Workers Comp782.72 486.00 296.72 8,948.08 5,713.46 3,234.62 6,172.00 (2,776.08) -45.0%6411800 Taxes-Employer Payroll2,079.20 1,613.52 465.68 19,894.31 18,968.64 925.67 20,493.00 598.69 2.9%6411880 Wages-Hourly14,926.19 12,960.00 1,966.19 160,352.56 152,358.50 7,994.06 164,599.00 4,246.44 2.6%6411882 Wages-Overtime1,115.82 - 1,115.82 5,714.76 - 5,714.76 - (5,714.76) 0.0%Total-CBR-SALARIES & BENEFITS19,182.2215,755.523,426.70 200,185.38184,696.6015,488.78 199,616.00 (569.38) -0.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 50.00 (50.00) 696.30 1,800.00 (1,103.70) 1,850.00 `0.0%6413742 Supplies-Expendable- 500.00 (500.00) 340.39 6,250.00 (5,909.61) 6,750.00 6,409.61 95.0%6413748 Supplies-Fuel for Shuttle- 200.00 (200.00) 309.70 2,900.00 (2,590.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 475.00 (460.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 61.55 350.00 (288.45) 420.00 358.45 85.3%6413786 Supplies-Towels528.77 250.00 278.77 6,818.74 2,110.00 4,708.74 2,182.00 (4,636.74) -212.5%6413796 Supplies-Bottled Water120.71 200.00 (79.29) 20,756.00 12,700.00 8,056.00 12,900.00 (7,856.00) -60.9%Total-CBR-SUPPLIES & MATERIALS649.48 1,320.00 (670.52) 39,565.60 35,585.00 3,980.60 36,627.00 (4,092.30) -11.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment537.38 300.00 237.38 2,769.70 3,300.00 (530.30) 3,600.00 830.30 23.1%6415695 CBR-R&M-Cart Maintenance & Repair 4,317.57 500.00 3,817.57 25,364.49 5,950.00 19,414.49 6,450.00 (18,914.49) -293.2%Total-CBR-REPAIRS & MAINTENANCE4,854.95 800.00 4,054.95 28,134.19 9,250.00 18,884.19 10,050.00 (18,084.19) -179.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen1,587.18 800.00 787.18 12,801.12 8,800.00 4,001.12 9,600.00 (3,201.12) -33.3%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous110.26 600.00 (489.74) 4,356.39 6,600.00 (2,243.61) 7,200.00 2,843.61 39.5%6419820 Uniforms- 1,500.00 (1,500.00) 3,097.36 5,000.00 (1,902.64) 5,200.00 2,102.64 40.4%Total-CBR-OTHER EXPENSES1,697.44 2,900.00 (1,202.56) 20,254.87 20,850.00 (595.13) 22,450.00 2,195.13 9.8%TOTAL-CARTS,BAGROOM & RANGE 26,384.0920,775.52(1,202.56) 288,140.04250,381.6037,758.44 268,743.00 (20,550.74) -7.6%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp742.80 114.75 628.05 5,267.49 2,515.23 2,752.26 2,630.00 (2,637.49) -100.3%6431800 Taxes-Employer Payroll668.16 397.80 270.36 7,427.40 8,719.43 (1,292.03) 9,117.00 1,689.60 18.5%6431880 Wages-Hourly3,198.00 3,060.00 138.00 59,459.75 67,072.50 (7,612.75) 70,133.00 10,673.25 15.2%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,608.96 3,572.55 1,036.41 72,154.64 78,307.16 (6,152.52) 81,880.00 9,725.36 11.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 75.00 (75.00) 427.45 975.00 (547.55) 1,050.00 622.55 59.3%6439490 Miscellaneous- - - 155.70 200.00 (44.30) 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 550.00 (550.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) 1,050.60 2,050.00 (999.40) 2,125.00 1,074.40 50.6%Total-CS-OTHER EXPENSES- 200.00 (200.00) 1,633.75 3,775.00 (2,141.25) 3,975.00 2,341.25 58.9%Total-COURSE SERVICES4,608.96 3,772.55 836.41 73,788.39 82,082.16 (8,293.77) 85,855.00 12,066.61 14.1%30,993.0524,548.076,444.98 361,928.43332,463.7629,464.67 354,598.00 (10,825.38) -3.1%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetMay 20197 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%65-CH-UTILITIES6507836 Utilities-Natural Gas601.77 300.00 301.77 5,541.77 3,300.00 2,241.77 3,600.00 (1,941.77) -53.9%6507840 Utilities-Telephone1,206.30 1,150.00 56.30 12,034.41 12,650.00 (615.59) 13,800.00 1,765.59 12.8%6507842 Utilities-Water739.64 321.00 418.64 8,743.91 3,531.00 5,212.91 3,852.00 (4,891.91) -127.0%6507844 Utilities-Cable509.62 380.00 129.62 5,490.08 4,180.00 1,310.08 4,560.00 (930.08) -20.4%Total-CH-UTILITIES3,057.33 2,151.00 906.33 31,810.17 23,661.00 8,149.17 25,812.00 (5,998.17) -23.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning715.00 1,825.00 (1,110.00) 5,494.00 20,675.00 (15,181.00) 22,500.00 17,006.00 75.6%6509099 Contract Services-Security5,094.72 5,000.00 94.72 57,780.73 55,000.00 2,780.73 60,000.00 2,219.27 3.7%6509215 Flowers & Decorations- - - - 1,500.00 (1,500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous258.88 200.00 58.88 3,705.14 6,800.00 (3,094.86) 7,000.00 3,294.86 47.1%6509718 Safety Equipment & Training- 100.00 (100.00) 418.69 1,100.00 (681.31) 1,200.00 781.31 65.1%Total-CH-OTHER EXPENSES6,068.60 7,125.00 (1,056.40)67,398.56 85,075.00 (17,676.44)92,600.00 25,201.44 27.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures972.60 300.00 672.60 10,467.40 3,300.00 7,167.40 3,600.00 (6,867.40) -190.8%6515686 CH-R&M-Restaurant Repairs968.00 400.00 568.00 4,966.22 4,400.00 566.22 4,800.00 (166.22) -3.5%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,886.72 4,400.00 (1,513.28) 4,800.00 1,913.28 39.9%Total-CH-REPAIRS & MAINTENANCE1,940.60 1,100.00 840.60 18,320.34 12,100.00 6,220.34 13,200.00 (5,120.34) -38.8%11,466.53 10,776.00690.53 121,929.07125,236.00(3,306.93) 136,412.00 (10,240.68) -7.5%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetMay 20198 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 398.81 348.00 50.81 4,043.75 3,828.00 215.75 4,176.00 132.25 3.2%6601325 Insurance-Workers Comp107.20 94.00 13.20 1,066.83 1,034.00 32.83 1,129.00 62.17 5.5%6601720 Salaries3,448.80 2,508.00 940.80 24,044.40 27,588.00 (3,543.60) 30,096.00 6,051.60 20.1%6601800 Taxes-Employer Payroll271.80 326.00 (54.20) 1,850.40 3,586.00 (1,735.60) 3,912.00 2,061.60 52.7%Total-MKT-SALARIES & BENEFITS4,226.61 3,276.00 950.61 31,005.38 36,036.00 (5,030.62) 39,313.00 8,307.62 21.1%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 67.37 100.00 (32.63) 1,023.35 1,100.00 (76.65) 1,200.00 176.65 14.7%6603768 Supplies-Printing & Stationery 553.82 125.00 428.82 8,271.79 4,300.00 3,971.79 4,425.00 (3,846.79) -86.9%621.19 225.00 396.19 9,295.14 5,400.00 3,895.14 5,625.00 (3,670.14) -65.2%66-MKT-UTILITIES6607840 Utilities-Telephone 150.88 100.00 50.88 2,908.90 1,100.00 1,808.90 1,200.00 (1,708.90) -142.4%Total-MKT-UTILITIES150.88 100.00 50.88 2,908.90 1,100.00 1,808.90 1,200.00 (1,708.90) -142.4%66-MKT-OTHER EXPENSES6609010 Advertising 6,208.54 8,012.00 (1,803.46) 148,104.54 163,720.00 (15,615.46) 169,987.00 21,882.46 12.9%6609040 Business Meals- 25.00 (25.00) - 275.00 (275.00) 300.00 300.00 100.0%6609080 Collateral Material726.32 1,000.00 (273.68) 9,036.42 4,500.00 4,536.42 5,500.00 (3,536.42) -64.3%6609102 Contract Services-Web Page99.00 150.00 (51.00) 792.00 1,650.00 (858.00) 1,800.00 1,008.00 56.0%6609490 Miscellaneous- 50.00 (50.00) - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 550.00 (550.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 863.11 650.00 213.11 700.00 (163.11) -23.3%6609633 Promotion-Community- 75.00 (75.00) 913.85 2,175.00 (1,261.15) 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- - - - 2,000.00 (2,000.00) 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- - - - 735.00 (735.00) 735.00 735.00 100.0%6609820 Uniforms- - - 299.07 600.00 (300.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES7,033.86 9,412.00 (2,378.14) 160,008.99 177,205.00 (17,196.01) 183,822.00 23,813.01 13.0%12,032.54 13,013.00 (980.46) 203,218.41 219,741.00 (16,522.59) 229,960.00 26,741.59 11.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetMay 20199 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,743.99 1,509.00 1,234.99 26,935.73 16,599.00 10,336.73 18,108.00 (8,827.73) -48.8%6701325 Insurance-Workers Comp445.68 677.00 (231.32) 5,666.26 7,223.00 (1,556.74) 7,905.00 2,238.74 28.3%6701720 Salaries14,497.37 13,851.00 646.37 139,207.01 151,761.00 (12,553.99) 177,996.00 38,788.99 21.8%6701800 Taxes-Employer Payroll1,971.20 2,349.00 (377.80) 15,200.15 25,059.00 (9,858.85) 32,800.00 17,599.85 53.7%6701880 Wages-Hourly5,014.59 4,211.00 803.59 36,084.13 40,938.00 (4,853.87) 27,404.00 (8,680.13) -31.7%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS24,672.83 22,597.00 2,075.83 223,093.28 241,580.00 (18,486.72) 264,213.00 41,119.72 15.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 3,270.82 5,500.00 (2,229.18) 6,300.00 3,029.18 48.1%6703762 Supplies-Office24.98 105.00 (80.02) 651.60 1,155.00 (503.40) 1,260.00 608.40 48.3%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 2,392.35 2,900.00 (507.65) 3,300.00 907.65 27.5%Total-G&A-SUPPLIES & MATERIALS24.98 1,005.00 (980.02) 6,314.77 9,555.00 (3,240.23) 10,860.00 4,545.23 41.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 683.14 1,800.00 (1,116.86) 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 683.14 1,800.00 (1,116.86) 1,900.00 1,216.86 64.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 8.3%6709150 Dues & Subscriptions- 300.00 (300.00) 330.00 1,100.00 (770.00) 1,150.00 820.00 71.3%6709180 Employee Recruiting/Relocation- - - 1,288.01 1,200.00 88.01 1,200.00 (88.01) -7.3%6709197 Equipment Rental505.94 550.00 (44.06) 6,071.03 6,050.00 21.03 6,600.00 528.97 8.0%6709202 Fees-Bank82.36 90.00 (7.64) 1,045.76 990.00 55.76 1,080.00 34.24 3.2%6709208 Fees-Payroll Processing560.55 1,000.00 (439.45) 7,019.95 11,000.00 (3,980.05) 12,000.00 4,980.05 41.5%6709220 Freight/Delivery- 50.00 (50.00) - 550.00 (550.00) 600.00 600.00 100.0%6709490 Miscellaneous54.90 100.00 (45.10) 3,851.42 6,500.00 (2,648.58) 6,600.00 2,748.58 41.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services306.63 75.00 231.63 1,226.65 825.00 401.65 900.00 (326.65) -36.3%6709625 Professional Fees1,083.00 850.00 233.00 12,328.86 9,350.00 2,978.86 10,200.00 (2,128.86) -20.9%6709636 Promotion/Entertainment- 100.00 (100.00) 129.41 1,100.00 (970.59) 1,200.00 1,070.59 89.2%6709722 Seminars & Training561.00 200.00 361.00 1,061.00 2,200.00 (1,139.00) 2,400.00 1,339.00 55.8%6709810 Travel- 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 957.27 975.00 (17.73) 1,050.00 92.73 8.8%Total-G&A-OTHER EXPENSES3,654.38 4,390.00 (735.62) 40,809.36 48,240.00 (7,430.64) 52,080.00 11,270.64 21.6%28,352.19 28,092.00 260.19 270,900.55 301,175.00 (30,274.45) 329,053.00 58,152.45 17.7%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetMay 201910 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 108,121.98 111,000.00 (2,878.02) 121,050.00 12,928.02 10.7%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 100,993.20 104,500.00 (3,506.80) 114,000.00 13,006.80 11.4%6800194 Equipment Leases-Trailer635.60 600.00 35.60 7,281.36 6,600.00 681.36 7,200.00 (81.36) -1.1%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 41,640.00 42,900.00 (1,260.00) 46,800.00 5,160.00 11.0%6800197 Equipment Leases-Others2,087.61 1,950.00 137.61 22,816.25 18,250.00 4,566.25 20,200.00 (2,616.25) 0.0%25,603.68 26,000.00(396.32) 280,852.79283,250.00 (2,397.21) 309,250.00 28,397.21 9.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 104,500.00 104,500.00 - 114,000.00 9,500.00 8.3%6900210 FF&E Reserve5,970.73 6,317.44 (346.71) 62,234.36 64,926.82 (2,692.46) 68,026.00 5,791.64 8.5%6900800 Personal Property Taxes- - - 14,738.21 11,800.00 2,938.21 11,800.00 (2,938.21) -24.9%6900323 Insurance-Commercial4,972.34 4,000.00 972.34 46,239.87 44,000.00 2,239.87 48,000.00 1,760.13 3.7%20,443.07 19,817.44625.63 227,712.44225,226.82 2,485.62 241,826.00 14,113.56 5.8%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateMay 201911 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-20192018 2018 2018 2018 2018 2018Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia2 4SalesPromotion4Golf IndustryVIPCelebrityPGA Comp18 208818Charity/Gift Certificate6244912Rain/Wind Checks223Club Staff13 37 42 14 39 58LQ HS Golf23121839 64 72 18 58 1132019 2019 2019 2019 2019 2019Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia8 2SalesPromotion2Golf IndustryVIPCelebrity2PGA Comp815 14 16 17Charity/Gift Certificate10914817Rain/Wind Checks28319Club Staff30 28 24 52 40LQ HS Golf16 42 72 39 1268 104 155 132 88012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-2019May 2019 Date TimeDescriptionCategoryPlayers5/20/201912:50 PMJessa Houser / Instagram GolferMedia213