Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02 August 2018 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2018 – August 2018 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 August Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue87,444.95 66,994.50 20,450.45 30.5% 163,360.52 141,921.75 21,438.77 3,401,303.00 3,237,942.48 5%401000 Miscellaneous Golf Revenue7,045.00 2,420.45 4,624.55 191.1% 13,195.00 5,279.90 7,915.10 302,066.00 288,871.00 4%410000 Revenue-Golf Shop9,064.37 7,150.00 1,914.37 26.8% 17,495.73 15,650.00 1,845.73 277,150.00 259,654.27 6%420000 Revenue-F&B Concession500.00 500.00 - 0.0%1,000.00 1,000.00 - 12,000.00 11,000.00 8%890000 Interest Income- - - 0.05 - 0.05 - (0.05) 0%Total Income104,054.32 77,064.95 26,989.37 35.0% 195,051.30 163,851.65 31,199.65 3,992,519.00 3,797,467.70 5%Cost of Goods Sold510000 COS-Golf Shop5,440.18 3,856.32 1,583.86 -41.1% 10,323.87 8,614.13 (1,709.74) 155,121.00 144,797.13 7%Total COS5,440.18 3,856.32 1,583.86 -41.1% 10,323.87 8,614.13 (1,709.74) 155,121.00 144,797.13 7%Gross Profit98,614.14 73,208.63 25,405.51 34.7% 184,727.43 155,237.52 29,489.91 3,837,398.00 3,652,670.57 5%Expenses610000 Golf Pro Shop 15,748.52 14,298.33 1,450.19 -10.1% 31,605.47 28,596.66 3,008.81 221,115.00 189,509.53 14%630000 Course Maintenance118,356.71 116,248.00 2,108.71 -1.8% 247,461.22 242,548.00 4,913.22 1,740,490.00 1,493,028.78 14%633000 Maintenance Water & Energy18,188.22 22,810.00 (4,621.78) 20.3% 41,780.06 46,225.00 (4,444.94) 249,838.00 208,057.94 17%640000 Outside Services23,050.15 19,662.36 3,387.79 -17.2% 42,329.01 36,654.42 5,674.59 354,598.00 312,268.99 12%650000 Clubhouse10,885.48 10,776.00 109.48 -1.0% 20,421.69 21,552.00 (1,130.31) 136,412.00 115,990.31 15%660000 Marketing10,193.46 7,521.00 2,672.46 -35.5% 19,188.10 15,042.00 4,146.10 229,960.00 210,771.90 8%670000 General & Administrative21,092.33 25,696.00 (4,603.67) 17.9% 42,602.29 50,542.00 (7,939.71) 329,053.00 286,450.71 13%680000 Leases25,599.23 25,200.00 399.23 -1.6% 51,123.46 50,400.00 723.46 309,250.00 258,126.54 17%690000 Miscellaneous Other Expense24,773.47 14,839.89 9,933.58 -66.9% 45,976.41 35,038.44 10,937.97 241,826.00 195,849.59 19%Total Expenses267,887.57 257,051.58 10,835.99 -4.2% 542,487.71 526,598.52 (15,889.19) 3,812,542.00 3,270,054.29 14%(169,273.43) (183,842.95) 14,569.52 7.9%(357,760.28) (371,361.00) 13,600.72 24,856.00 382,616.28 0%Rounds of Golf PlayedPaid Rounds Played2,222 2,200 22 1.0%4,675 4,700 (25) 42,173 37,498 11%Ave $ Per Paid Round Green Fee39.35 30.45 8.90 29.2%34.94 30.20 4.75 80.65 45.71 43%Ave $ Per Paid Round Merchandise4.08 3.25 0.83 25.5%3.74 3.33 0.41 6.57 2.83 57%Ave $ Per Paid Miscellaneous 3.17 1.10 2.07 188.2%2.82 1.12 1.70 7.16 4.34 39%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateAugust 20181 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees87,444.95 66,994.50 20,450.45 163,360.52 141,921.75 21,438.77 3,401,303.00 3,237,942.48 95.2%4010000 Rider Fee825.00 123.90 701.10 1,355.00 224.60 1,130.40 7,307.00 5,952.00 81.5%4040000 Club Rental675.00 619.50 55.50 1,125.00 1,123.00 2.00 21,087.00 19,962.00 94.7%4050000 Driving Range1,795.00 1,177.05 617.95 3,665.00 1,932.30 1,732.70 94,872.00 91,207.00 96.1%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - - 1,000.00 (1,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee- - - - - - 7,000.00 7,000.00 100.0%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue3,750.00 500.00 3,250.00 7,050.00 1,000.00 6,050.00 165,300.00 158,250.00 95.7% Total Revenue Fees94,489.95 69,414.95 25,075.00 176,555.52 147,201.65 29,353.87 3,703,369.00 3,526,813.48 95.2%94,489.95 69,414.95 25,075.00 176,555.52 147,201.65 29,353.87 3,703,369.00 3,526,813.48 95.2%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetAugust 20182 RevenuesActualBudgetVariance$87,444.95 $66,994.50 20,450.45Favorable: Due to utilizing UnderPar Promotion to lure in additional golfers.ActualBudgetVariance$7,045.00 $2,420.45 4,624.55Favorable: Due to an increase in Resident Cards, budgeted $500.00 and sold $3750.00.Actual BudgetVariance$9,064.37 $7,150.00 1,914.37Favorable: New promotions implented which increased sales of Hardgoods and Softgoods. ExpensesActualBudgetVariance$15,748.52 $14,298.33 1,450.19Unfavorable: Due to increase in hours worked by staff for training purposes.Actual BudgetVariance$18,188.22 $22,810.00 (4,621.78)Favorable: Due to reduced water usage because of humidity.Actual BudgetVariance$23,050.15 $19,662.36 3,387.79Unfavorable: Due to additional manpower to maintain the services we provide with taking into consideration the extreme heat and humidity.Actual BudgetVariance$10,885.48 $10,776.00 109.48Favorable: Due to elimination of private cleaner which has been done in house in an effort to save expenses.Actual BudgetVariance$10,193.46 $7,521.00 2,672.46Unfavorable: Due to restocking of tees, divot tools and scorecard, and pencils.Actual BudgetVariance$21,092.33 $25,696.00 (4,603.67)Favorable: Due to reallocation of accounting payroll. Actual BudgetVariance$25,599.23 $28,800.00 (3,200.77)Favorable: Due to reduced lease payment from projections, and discounted GPS rental fees.ActualBudgetVariance$24,773.47 $14,839.89 9,933.58Unfavorable: Budget not adjusted to reflect the additional maintenance equipment leased.LeasesMiscellaneous Other ExpenseOutside ServicesClubhouseMarketingGeneral and AdministrativeMiscellaneous Golf RevenuePro Shop Merchandise SalesGolf ShopMaintenance Water & EnergyVariance ExplanationAugust 2018The 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%.Golf Green Fee Revenue3 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous834.83 - 834.83 1,998.38 - 1,998.38 00 0%4100110 Sales Hard Goods6,040.03 1,787.50 4,252.53 9,651.50 3,912.50 5,739.00 69,288.00 59,636.50 86.1%4100112 Sales-Soft Goods3,240.46 5,362.50 (2,122.04) 7,828.46 11,737.50 (3,909.04) 207,863.00 200,034.54 96.2%5100639 GS-Discounts-Mdse (1,050.95) - (1,050.95) (1,982.61) - (1,982.61) - 1,982.61 0.0% Total Revenue Golf Shop9,064.37 7,150.00 1,914.37 17,495.73 15,650.00 1,845.73 277,151.00 261,653.65 94.4%COS 5100150 COS-GS-Hard Goods 3,503.22 1,000.46 2,502.76 5,538.13 2,189.82 3,348.31 40,187.04 34,648.91 86.2%5100151 COS-GS-Soft Goods 1,936.96 3,001.00 (1,064.04) 4,581.36 6,742.00 (2,160.64) 120,560.54 115,979.18 96.2%5100152 COS-GS-Purchase Disc- (207.35) 207.35 (15.32) (453.85) 438.53 (8,037.00) (8,021.68) 99.8%5100220 COS-GS-Freight Merch- 62.21 (62.21) 219.70 136.16 83.54 2,411.00 2,191.30 90.9%Cost of Sales - Golf Shop5,440.18 3,856.32 1,583.86 10,323.87 8,614.13 1,709.74 155,121.58 144,797.71 93.3%Gross Profit 3,624.19 3,293.68 330.51 7,171.86 7,035.87 135.99 122,029.42 116,855.94 95.8%COS %60.0% 53.9% -6.1% 59.0% 55.0% -4.0% 53.1% 55.3% 104.3%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,601.66 1,740.00 (138.34) 3,477.64 3,480.00 (2.36) 26,796.00 23,318.36 87.0%6101325 Insurance-Workers Comp 477.03 367.72 109.31 1,052.86 735.44 317.42 5,635.00 4,582.14 81.3%6101720 Salaries4,861.54 4,400.00 461.54 9,261.54 8,800.00 461.54 51,000.00 41,738.46 81.8%6101800 Taxes-Employer Payroll 929.90 1,274.76 (344.86) 1,889.06 2,549.52 (660.46) 19,935.00 18,045.94 90.5%6101880 Wages-Hourly7,267.50 5,405.85 1,861.65 15,147.00 10,811.70 4,335.30 98,874.00 83,727.00 84.7%6101882 Wages-Overtime20.25 - 20.25 32.25 - 32.25 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 15,157.88 13,188.33 1,969.55 30,860.35 26,376.66 4,483.69 202,240.00 172,364.78 85.2%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office140.97 250.00 (109.03) 140.97 500.00 (359.03) 3,000.00 2,859.03 95.3%6109220 Freight & Delivery- - - - - - 75.00 75.00 100.0%6109490 Miscellaneous419.14 500.00 (80.86) 419.14 1,000.00 (580.86) 6,000.00 5,580.86 93.0%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short(7.37) - (7.37) 51.90 - 51.90 - (51.90) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 300.00 (300.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms- 100.00 (100.00) 32.63 200.00 (167.37) 2,400.00 2,367.37 98.6%6117840 Telephones37.90 110.00 (72.10) 100.48 220.00 (119.52) 1,320.00 1,219.52 92.4%590.64 1,110.00 (519.36) 745.12 2,220.00 (1,474.88) 18,875.00 18,129.88 96.1%15,748.52 14,298.33 1,450.19 31,605.47 28,596.66 3,008.81 221,115.00 190,494.66 86.2%Net Income(12,124.33) (11,004.65) (1,119.68) (24,433.61) (21,560.79) (2,872.82) (99,085.58) (73,638.72) 74.3%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetAugust 20184 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,724.00 7,425.00 299.00 17,468.57 14,850.00 2,618.57 103,020.00 85,551.43 83.0%6311325 Insurance-Workers Comp2,441.51 2,006.00 435.51 4,481.12 4,012.00 469.12 26,974.00 22,492.88 83.4%6311720 Salaries12,476.92 12,476.92 - 24,953.84 24,953.84 - 146,400.00 121,446.16 83.0%6311800 Taxes-Employer Payroll3,902.40 6,953.00 (3,050.60) 8,333.28 13,906.00 (5,572.72) 94,048.00 85,714.72 91.1%6311880 Wages-Hourly41,196.11 41,007.08 189.03 81,478.72 82,014.16 (535.44) 564,695.00 483,216.28 85.6%6311882 Wages-Overtime1,824.19 - 1,824.19 7,473.46 - 7,473.46 12,350.00 4,876.54 39.5%Total-CM-SALARIES & BENEFITS69,565.13 69,868.00 (302.87) 144,188.99 139,736.00 4,452.99 947,487.00 803,298.01 84.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals2,525.76 190.00 2,335.76 3,519.48 380.00 3,139.48 17,760.00 14,240.52 80.2%6313744 Fertilizer1,498.49 2,100.00 (601.51) 13,293.11 7,970.00 5,323.11 100,520.00 87,226.89 86.8%6313745 Herbicides- - - 1,854.50 6,782.00 (4,927.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants- - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline3,381.33 3,450.00 (68.67) 6,385.81 6,650.00 (264.19) 46,860.00 40,474.19 86.4%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 Supp289.07 750.00 (460.93) 582.14 1,500.00 (917.86) 4,350.00 3,767.86 86.6%6313762 Supplies-Office- - - 211.79 - 211.79 - (211.79) 0.0%6313774 Sand1,142.15 390.00 752.15 1,142.15 780.00 362.15 13,460.00 12,317.85 91.5%6313776 Seed- - - - - - 117,400.00 117,400.00 100.0%6313778 Small Tools & Non-Capital Equip65.24 100.00 (34.76) 65.24 200.00 (134.76) 5,000.00 4,934.76 98.7%6313780 Sod739.50 3,500.00 (2,760.50) 2,423.57 7,800.00 (5,376.43) 13,500.00 11,076.43 82.0%6313782 Topdressing1,537.25 2,200.00 (662.75) 3,582.99 2,200.00 1,382.99 10,000.00 6,417.01 64.2%Total-CM-SUPPLIES & MATERIALS11,178.79 12,680.00 (1,501.21) 33,060.78 34,262.00 (1,201.22) 380,458.00 347,397.22 91.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 3,850.00 (10.00) 7,680.00 7,700.00 (20.00) 46,200.00 38,520.00 83.4%6315685 CM-R&M-Bldngs & Othr Structures 741.12 750.00 (8.88) 871.55 2,000.00 (1,128.45) 5,550.00 4,678.45 84.3%6315690 CM-R&M-Equipment7,571.43 2,500.00 5,071.43 10,393.79 4,500.00 5,893.79 38,500.00 28,106.21 73.0%6315692 CM-R&M-Irrigation System1,026.59 3,500.00 (2,473.41) 5,473.13 7,900.00 (2,426.87) 19,050.00 13,576.87 71.3%6315696 CM-R&M-Pumps3,705.97 1,000.00 2,705.97 3,705.97 2,000.00 1,705.97 10,500.00 6,794.03 64.7%6315815 CM-R&M-Trees-Pruning Etc- - - - - - 12,050.00 12,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE16,885.11 11,600.00 5,285.11 28,124.44 24,100.00 4,024.44 131,850.00 103,725.56 78.7%6317836 Utilities-Natural Gas/LPG 18.58 15.00 3.58 38.80 30.00 8.80 180.00 141.20 0.0%6317840 Telephones327.75 850.00 (522.25) 1,086.90 1,700.00 (613.10) 10,200.00 9,113.10 89.3%Total-CM-UTILITIES346.33 865.00 (518.67) 1,125.70 1,730.00 (604.30) 10,380.00 9,254.30 89.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.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) 104.02 1,048.00 (943.98) 6,288.00 6,183.98 98.3%6319150 Dues & Subscriptions- - - - - - 680.00 680.00 100.0%6319170 Employee Education- 50.00 (50.00) - 100.00 (100.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 150.00 (150.00) - 350.00 (350.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- - - 575.00 100.00 475.00 4,300.00 3,725.00 86.6%6319490 Miscellaneous- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training- 100.00 (100.00) 256.47 300.00 (43.53) 3,850.00 3,593.53 93.3%6319822 Uniforms941.74 920.00 21.74 1,709.19 1,840.00 (130.81) 11,040.00 9,330.81 84.5%Total-CM-OTHER EXPENSES1,341.74 2,244.00 (902.26) 3,444.68 4,738.00 (1,293.32) 41,458.00 38,013.32 91.7%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetAugust 2018Month to DateYear to Date5 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 3,525.02 2,784.00 741.02 7,122.88 5,568.00 1,554.88 33,408.00 26,285.12 78.7%6321325 Insurance-Workers Comp791.47 500.00 291.47 1,365.54 1,000.00 365.54 5,955.00 4,589.46 77.1%6321800 Taxes-Employer Payroll824.17 1,733.00 (908.83) 1,687.47 3,466.00 (1,778.53) 20,793.00 19,105.53 91.9%6321880 Wages-Hourly13,220.00 13,334.00 (114.00) 26,050.48 26,668.00 (617.52) 156,528.00 130,477.52 83.4%6321882 Wages-Overtime210.38 - 210.38 821.69 - 821.69 3,418.00 2,596.31 76.0%Total-CM-LM-SALARIES & BENEFITS18,571.04 18,351.00 220.04 37,048.06 36,702.00 346.06 220,102.00 183,053.94 83.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 200.00 (200.00) 1,025.00 1,025.00 100.0%6323788 Uniforms468.57 290.00 178.57 468.57 580.00 (111.43) 3,480.00 3,011.43 86.5%Total-CM-LM-SUPPLIES & MATERIALS468.57 390.00 78.57 468.57 780.00 (311.43) 4,505.00 4,036.43 89.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0%118,356.71 116,248.00 2,108.71 247,461.22 242,548.00 4,913.22 1,740,490.00 1,493,028.78 85.8% August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 11,843.13 11,290.00 553.13 29,014.51 24,640.00 4,374.51 179,791.00 150,776.49 83.9%6337842 Utilities-Water6,345.09 11,520.00 (5,174.91) 12,765.55 21,585.00 (8,819.45) 70,047.00 57,281.45 81.8%18,188.22 22,810.00 (4,621.78) 41,780.06 46,225.00 (4,444.94) 249,838.00 208,057.94 83.3%Silverrock ResortCourse Maintenance Water & EnergyAugust 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementAugust 2018Silverrock ResortAnnual BudgetMonth to DateYear to Date6 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 1,392.00 (1,392.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp376.49 245.44 131.05 932.97 543.47 389.50 6,172.00 5,239.03 84.9%6411800 Taxes-Employer Payroll885.46 814.85 70.61 1,810.24 1,804.31 5.93 20,493.00 18,682.76 91.2%6411880 Wages-Hourly9,286.01 6,545.00 2,741.01 18,942.39 14,492.50 4,449.89 164,599.00 145,656.61 88.5%6411882 Wages-Overtime34.70 - 34.70 75.97 - 75.97 - (75.97) 0.0%Total-CBR-SALARIES & BENEFITS10,582.668,301.29 2,281.37 21,761.57 18,232.28 3,529.29 199,616.00 177,854.43 89.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable- 600.00 (600.00) 113.10 1,200.00 (1,086.90) 6,750.00 6,636.90 98.3%6413748 Supplies-Fuel for Shuttle- - - - - - 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office- 25.00 (25.00) 14.67 50.00 (35.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels689.63 120.00 569.63 1,468.44 240.00 1,228.44 2,182.00 713.56 32.7%6413796 Supplies-Bottled Water5,743.58 4,400.00 1,343.58 5,857.77 4,500.00 1,357.77 12,900.00 7,042.23 54.6%Total-CBR-SUPPLIES & MATERIALS6,433.21 5,145.00 1,288.21 7,453.98 5,990.00 1,463.98 36,627.00 27,323.02 74.6%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) - 600.00 (600.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair 1,823.25 500.00 1,323.25 4,023.75 1,000.00 3,023.75 6,450.00 2,426.25 37.6%Total-CBR-REPAIRS & MAINTENANCE1,823.25 800.00 1,023.25 4,023.75 1,600.00 2,423.75 10,050.00 6,026.25 60.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen665.67 800.00 (134.33) 1,388.15 1,600.00 (211.85) 9,600.00 8,211.85 85.5%6419220 Freight/Delivery- 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0%6419490 Miscellaneous73.99 600.00 (526.01) 172.65 1,200.00 (1,027.35) 7,200.00 7,027.35 97.6%6419820 Uniforms- - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES739.66 1,475.00 (735.34) 1,560.80 2,950.00 (1,389.20) 22,450.00 20,889.20 93.0%TOTAL-CARTS,BAGROOM & RANGE19,578.7815,721.29(735.34) 34,800.10 28,772.28 6,027.82 268,743.00 232,092.90 86.4%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp277.03 120.97 156.06 437.66 241.94 195.72 2,630.00 2,192.34 83.4%6431800 Taxes-Employer Payroll235.20 419.35 (184.15) 554.36 838.70 (284.34) 9,117.00 8,562.64 93.9%6431880 Wages-Hourly2,876.50 3,225.75 (349.25) 6,454.25 6,451.50 2.75 70,133.00 63,678.75 90.8%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,388.73 3,766.07 (377.34) 7,446.27 7,532.14 (85.87) 81,880.00 74,433.73 90.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable82.64 50.00 32.64 82.64 100.00 (17.36) 1,050.00 967.36 92.1%6439490 Miscellaneous- - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) - 150.00 (150.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES82.64 175.00 (92.36) 82.64 350.00 (267.36) 3,975.00 3,892.36 97.9%Total-COURSE SERVICES3,471.37 3,941.07 (469.70) 7,528.91 7,882.14 (353.23) 85,855.00 78,326.09 91.2%23,050.1519,662.363,387.79 42,329.01 36,654.42 5,674.59 354,598.00 306,526.63 86.4%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetAugust 20187 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%65-CH-UTILITIES6507836 Utilities-Natural Gas344.88 300.00 44.88 793.73 600.00 193.73 3,600.00 2,806.27 78.0%6507840 Utilities-Telephone1,183.62 1,150.00 33.62 1,183.62 2,300.00 (1,116.38) 13,800.00 12,616.38 91.4%6507842 Utilities-Water800.01 321.00 479.01 1,632.41 642.00 990.41 3,852.00 2,219.59 57.6%6507844 Utilities-Cable495.84 380.00 115.84 991.68 760.00 231.68 4,560.00 3,568.32 78.3%Total-CH-UTILITIES2,824.35 2,151.00 673.35 4,601.44 4,302.00 299.44 25,812.00 21,210.56 82.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning550.00 1,825.00 (1,275.00) 1,025.00 3,650.00 (2,625.00) 22,500.00 21,475.00 95.4%6509099 Contract Services-Security5,249.72 5,000.00 249.72 10,640.93 10,000.00 640.93 60,000.00 49,359.07 82.3%6509215 Flowers & Decorations- - - - - - 1,900.00 1,900.00 100.0%6509490 Miscellaneous235.00 200.00 35.00 235.00 400.00 (165.00) 7,000.00 6,765.00 96.6%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 200.00 51.47 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES6,034.72 7,125.00 (1,090.28)12,152.40 14,250.00 (2,097.60) 92,600.00 80,447.60 86.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,626.41 300.00 1,326.41 2,867.85 600.00 2,267.85 3,600.00 732.15 20.3%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE1,626.41 1,100.00 526.41 2,867.85 2,200.00 667.85 13,200.00 10,332.15 78.3%10,885.48 10,776.00109.48 20,421.69 21,552.00 (1,130.31) 136,412.00 20,664.30 15.1%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetAugust 20188 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 711.78 696.00 15.78 4,176.00 3,464.22 83.0%6601325 Insurance-Workers Comp104.00 94.00 10.00 198.17 188.00 10.17 1,129.00 930.83 82.4%6601720 Salaries1,905.20 2,508.00 (602.80) 3,810.40 5,016.00 (1,205.60) 30,096.00 26,285.60 87.3%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 290.40 652.00 (361.60) 3,912.00 3,621.60 92.6%Total-MKT-SALARIES & BENEFITS2,510.29 3,276.00 (765.71) 5,010.75 6,552.00 (1,541.25) 39,313.00 34,302.25 87.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 420.22 100.00 320.22 420.22 200.00 220.22 1,200.00 779.78 65.0%6603768 Supplies-Printing & Stationery 379.28 - 379.28 805.56 - 805.56 4,425.00 3,619.44 81.8%799.50 100.00 699.50 1,225.78 200.00 1,025.78 5,625.00 4,399.22 78.2%66-MKT-UTILITIES6607840 Utilities-Telephone 148.95 100.00 48.95 1,525.89 200.00 1,325.89 1,200.00 (325.89) -27.2%Total-MKT-UTILITIES148.95 100.00 48.95 1,525.89 200.00 1,325.89 1,200.00 (325.89) -27.2%66-MKT-OTHER EXPENSES6609010 Advertising4,345.97 3,745.00 600.97 9,036.93 7,490.00 1,546.93 169,987.00 160,950.07 94.7%6609040 Business Meals- 25.00 (25.00) - 50.00 (50.00) 300.00 300.00 100.0%6609080 Collateral Material2,289.75 - 2,289.75 2,289.75 - 2,289.75 5,500.00 3,210.25 58.4%6609102 Contract Services-Web Page99.00 150.00 (51.00) 99.00 300.00 (201.00) 1,800.00 1,701.00 94.5%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6609630 Promotion- - - - - - 700.00 700.00 100.0%6609633 Promotion-Community- 75.00 (75.00) - 150.00 (150.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- - - - - - 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES6,734.72 4,045.00 2,689.72 11,425.68 8,090.00 3,335.68 183,822.00 172,396.32 93.8%10,193.46 7,521.00 2,672.46 19,188.10 15,042.00 4,146.10 229,960.00 210,771.90 91.7%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetAugust 20189 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,061.11 1,509.00 552.11 4,234.12 3,018.00 1,216.12 18,108.00 13,873.88 76.6%6701325 Insurance-Workers Comp505.92 632.00 (126.08) 1,011.84 1,242.00 (230.16) 7,905.00 6,893.16 87.2%6701720 Salaries11,494.80 13,851.00 (2,356.20) 22,989.60 27,102.00 (4,112.40) 177,996.00 155,006.40 87.1%6701800 Taxes-Employer Payroll1,087.66 2,193.00 (1,105.34) 2,156.30 4,308.00 (2,151.70) 32,800.00 30,643.70 93.4%6701880 Wages-Hourly2,733.50 3,016.00 (282.50) 5,218.50 6,032.00 (813.50) 27,404.00 22,185.50 81.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS17,882.99 21,201.00 (3,318.01) 35,610.36 41,702.00 (6,091.64) 264,213.00 228,602.64 86.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer97.16 500.00 (402.84) 122.14 1,000.00 (877.86) 6,300.00 6,177.86 98.1%6703762 Supplies-Office- 105.00 (105.00) 93.24 210.00 (116.76) 1,260.00 1,166.76 92.6%6703768 Supplies-Printing & Stationery55.10 100.00 (44.90) 535.92 200.00 335.92 3,300.00 2,764.08 83.8%Total-G&A-SUPPLIES & MATERIALS152.26 705.00 (552.74) 751.30 1,410.00 (658.70) 10,860.00 10,108.70 93.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 630.00 100.00 530.00 630.00 100.00 530.00 1,900.00 1,270.00 66.8%Total-G&A-REPAIRS & MAINTENANCE630.00 100.00 530.00 630.00 100.00 530.00 1,900.00 1,270.00 66.8%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 83.3%6709150 Dues & Subscriptions180.00 - 180.00 180.00 50.00 130.00 1,150.00 970.00 84.3%6709180 Employee Recruiting/Relocation30.00 - 30.00 90.00 - 90.00 1,200.00 1,110.00 92.5%6709197 Equipment Rental543.99 550.00 (6.01) 911.74 1,100.00 (188.26) 6,600.00 5,688.26 86.2%6709202 Fees-Bank65.24 90.00 (24.76) 127.03 180.00 (52.97) 1,080.00 952.97 88.2%6709208 Fees-Payroll Processing342.25 1,000.00 (657.75) 697.45 2,000.00 (1,302.55) 12,000.00 11,302.55 94.2%6709220 Freight/Delivery- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6709490 Miscellaneous- 100.00 (100.00) 167.81 200.00 (32.19) 6,600.00 6,432.19 97.5%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services276.60 75.00 201.60 276.60 150.00 126.60 900.00 623.40 69.3%6709625 Professional Fees489.00 850.00 (361.00) 2,160.00 1,700.00 460.00 10,200.00 8,040.00 78.8%6709636 Promotion/Entertainment- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 400.00 (400.00) 2,400.00 2,400.00 100.0%6709810 Travel- 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 - 150.00 (150.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES2,427.08 3,690.00 (287.92) 5,610.63 7,330.00 (1,719.37) 52,080.00 46,469.37 89.2%21,092.33 25,696.00 (4,603.67) 42,602.29 50,542.00 (7,939.71) 329,053.00 286,450.71 87.1%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetAugust 201810 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 19,658.54 20,100.00 (441.46) 121,050.00 101,391.46 83.8%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 18,362.40 19,000.00 (637.60) 114,000.00 95,637.60 83.9%6800194 Equipment Leases-Trailer658.07 600.00 58.07 1,241.14 1,200.00 41.14 7,200.00 5,958.86 82.8%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 7,740.00 7,800.00 (60.00) 46,800.00 39,060.00 83.5%6800197 Equipment Leases-Others2,060.69 1,150.00 910.69 4,121.38 2,300.00 1,821.38 20,200.00 16,078.62 0.0%25,599.23 25,200.00399.23 51,123.46 50,400.00 723.46 309,250.00 258,126.5483.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 19,000.00 19,000.00 - 114,000.00 95,000.00 83.3%6900210 FF&E Reserve1,748.90 1,339.89 409.01 3,267.22 2,838.44 428.78 68,026.00 64,758.78 95.2%6900800 Personal Property Taxes9,273.20 - 9,273.20 14,676.26 5,200.00 9,476.26 11,800.00 (2,876.26) -24.4%6900323 Insurance-Commercial4,251.37 4,000.00 251.37 9,032.93 8,000.00 1,032.93 48,000.00 38,967.07 81.2%24,773.47 14,839.899,933.58 45,976.41 35,038.44 10,937.97 241,826.00 195,849.5981.0%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateAugust 201811 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-20192018 2018 2018 2018 2018 2018Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia2SalesPromotionGolf IndustryVIPCelebrityPGA Comp18 20Charity/Gift Certificate62Rain/Wind ChecksClub Staff13 37LQ HS Golf2339 6400002019 2019 2019 2019 2019 2019Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-2019August 2018 Date TimeDescriptionCategoryPlayers8/5/20188:00 a.m.Brett Coor / Kris Long CBS2Media213