Loading...
01 July 2017 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2017 – July 2017 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 JulyFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue22,360.25 25,137.00 (2,776.75) -11.0% 22,360.25 25,137.00 (2,776.75) 2,964,060.00 2,941,699.75 1%401000 Miscellaneous Golf Revenue4,415.00 2,860.00 1,555.00 54.4%4,415.00 2,860.00 1,555.00 166,766.00 162,351.00 3%410000 Revenue-Golf Shop3,024.54 3,423.00 (398.46) -11.6% 3,024.54 3,423.00 (398.46) 262,017.00 258,992.46 1%420000 Revenue-F&B Concession500.00 500.00 - 0.0%500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income- - - - - - - - 0%Total Income30,299.79 31,920.00 (1,620.21) -5.1% 30,299.79 31,920.00 (1,620.21) 3,404,843.00 3,374,543.21 1%Cost of Goods Sold510000 COS-Golf Shop1,844.07 1,916.34 (72.27) 3.8%1,844.07 1,916.34 72.27 146,651.00 144,806.93 1%Total COS1,844.07 1,916.34 (72.27) 3.8%1,844.07 1,916.34 72.27 146,651.00 144,806.93 1%Gross Profit28,455.72 30,003.66 (1,547.94) -5.2% 28,455.72 30,003.66 (1,547.94) 3,258,192.00 3,229,736.28 1%Expenses610000 Golf Pro Shop 14,806.92 12,777.00 2,029.92 -15.9% 14,806.92 12,777.00 2,029.92 199,990.00 185,183.08 7%630000 Course Maintenance120,674.29 125,520.00 (4,845.71) 3.9% 120,674.29 125,520.00 (4,845.71) 1,735,790.00 1,615,115.71 7%633000 Maintenance Water & Energy16,726.71 23,415.00 (6,688.29) 28.6% 16,726.71 23,415.00 (6,688.29) 249,838.00 233,111.29 7%640000 Outside Services17,168.74 16,548.00 620.74 -3.8% 17,168.74 16,548.00 620.74 331,964.00 314,795.26 5%650000 Clubhouse10,405.23 10,776.00 (370.77) 3.4% 10,405.23 10,776.00 (370.77) 136,412.00 126,006.77 8%660000 Marketing11,208.33 7,521.00 3,687.33 -49.0% 11,208.33 7,521.00 3,687.33 230,960.00 219,751.67 5%670000 General & Administrative23,069.59 24,845.00 (1,775.41) 7.1% 23,069.59 24,845.00 (1,775.41) 329,053.00 305,983.41 7%680000 Leases25,770.03 22,550.00 3,220.03 -14.3% 25,770.03 22,550.00 3,220.03 321,050.00 295,279.97 8%690000 Miscellaneous Other Expense13,107.62 17,402.00 (4,294.38) 24.7% 13,107.62 17,402.00 (4,294.38) 211,468.00 198,360.38 6%Total Expenses252,937.46 261,354.00 (8,416.54) 3.2% 252,937.46 261,354.00 8,416.54 3,746,525.00 3,493,587.54 7%(224,481.74) (231,350.34) 6,868.60 3.0%(224,481.74) (231,350.34) 6,868.60 (488,333.00) (263,851.26) 0%Rounds of Golf PlayedPaid Rounds Played948 1,007 (59) -5.9%948 1,007 (59) 42,173 41,225 2%Ave $ Per Paid Round Green Fee23.59 24.96 (1.38) -5.5%23.59 24.96 (1.38) 70.28 46.70 34%Ave $ Per Paid Round Merchandise3.19 3.40 (0.21) -6.1%3.19 3.40 (0.21) 6.21 3.02 51%Ave $ Per Paid Miscellaneous 4.66 2.84 1.82 64.0%4.66 2.84 1.82 3.95 (0.70) 118%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJuly 20171 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees22,360.25 25,137.00 (2,776.75) 22,360.25 25,137.00 (2,776.75) 2,964,060.00 2,941,699.75 99.2%4010000 Rider Fee85.00 101.00 (16.00) 85.00 101.00 (16.00) 7,307.00 7,222.00 98.8%4040000 Club Rental290.00 504.00 (214.00) 290.00 504.00 (214.00) 21,087.00 20,797.00 98.6%4050000 Driving Range1,940.00 755.00 1,185.00 1,940.00 755.00 1,185.00 94,872.00 92,932.00 98.0%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee- - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue2,100.00 500.00 1,600.00 2,100.00 500.00 1,600.00 165,300.00 163,200.00 98.7% Total Revenue Fees26,775.25 27,997.00 (1,221.75) 26,775.25 27,997.00 (1,221.75) 3,296,126.00 3,269,350.75 99.2%26,775.25 27,997.00 (1,221.75) 26,775.25 27,997.00 (1,221.75) 3,296,126.00 3,269,350.75 99.2%SilverRock ResortStatement of Fees RevenueJuly 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$22,360.25 $25,137.00 (2,776.75)Unfavorable: Rounds down by 59 due to extreme heat and humidity.ActualBudgetVariance$4,415.00$2,860.00(14,840.00)Favorable: Due to Resident Card issue up.ActualBudgetVariance$3,024.54$3,423.00(398.46)Unfavorable: Due to rounds being down and temperatures.ExpensesActualBudgetVariance$15,826.02 $21,498.00 (5,671.98)Unfavorable: Due to labor cost driven by assistance in other departments.ActualBudgetVariance$16,726.71 $23,415.00 (6,688.29)Favorable: Due to reduced runtime of the water features and the closure of the back none for construction.ActualBudgetVariance$11,208.33 $7,521.00 3,687.33Unfavorable: Due to timing of advertising invoices.ActualBudgetVariance$10,405.23 $10,776.00 (370.77)Unfavorable: Due to additional expenditures on repairs to clubhouse and restaurant.ActualBudgetVariance$17,247.46 $25,736.00 (8,488.54)Favorable: Due to reduced watering cycles and reduced runtime on the waterfalls at the entry.ActualBudgetVariance$25,471.92 $28,800.00 (3,328.08)Unfavorable: Erroneously budgeted previous lease payments amounts for the first 4 months of the new fiscal year.ActualBudgetVariance$14,622.72 $17,071.00 (2,448.28)Favorable: Due to budget for property tax bill being late.Golf ShopClubhouseMarketingMiscellaneous Other ExpenseMaintenance Water and EnergyLeasesMaintenance Water and Energyprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueVariance ExplanationJuly 2017The 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 are3-20-133 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous170.66 - 170.66 170.66 - 170.66 00 0%4100110 Sales Hard Goods1,265.32 1,198.00 67.32 1,265.32 1,198.00 67.32 91,706.00 90,440.68 98.6%4100112 Sales-Soft Goods1,588.56 2,225.00 (636.44) 1,588.56 2,225.00 (636.44) 170,311.00 168,722.44 99.1%5100639 GS-Discounts-Mdse- - - - - - - - 0.0% Total Revenue Golf Shop3,024.54 3,423.00 (398.46) 3,024.54 3,423.00 (398.46) 262,017.00 259,163.12 98.9%COS 5100150 COS-GS-Hard Goods 708.50 694.84 13.66 708.50 694.84 13.66 53,189.48 52,480.98 98.7%5100151 COS-GS-Soft Goods789.59 1,290.50 (500.91) 789.59 1,290.50 (500.91) 97,137.52 96,347.93 99.2%5100152 COS-GS-Purchase Disc- (99.00) 99.00 - (99.00) 99.00 (7,598.00) (7,598.00) 100.0%5100220 COS-GS-Freight Merch 345.98 30.00 315.98 345.98 30.00 315.98 2,280.00 1,934.02 84.8%Cost of Sales - Golf Shop1,844.07 1,916.34 (72.27) 1,844.07 1,916.34 (72.27) 145,009.00 143,164.93 98.7%Gross Profit1,180.47 1,506.66 (326.19) 1,180.47 1,506.66 (326.19) 117,008.00 115,998.19 99.1%COS % 61.0% 56.0% -5.0% 61.0% 56.0% -5.0% 53.1% 55.2% 104.1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,615.72 1,740.00 875.72 2,615.72 1,740.00 875.72 26,796.00 24,180.28 90.2%6101325 Insurance-Workers Comp 880.17 319.00 561.17 880.17 319.00 561.17 4,957.00 4,076.83 82.2%6101720 Salaries4,000.00 4,001.00 (1.00) 4,000.00 4,001.00 (1.00) 45,000.00 41,000.00 91.1%6101800 Taxes-Employer Payroll 803.62 1,105.00 (301.38) 803.62 1,105.00 (301.38) 18,825.00 18,021.38 95.7%6101880 Wages-Hourly5,629.01 4,502.00 1,127.01 5,629.01 4,502.00 1,127.01 87,179.00 81,549.99 93.5%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 13,928.52 11,667.00 2,261.52 13,928.52 11,667.00 2,261.52 182,757.00 169,781.36 92.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office83.97 250.00 (166.03) 83.97 250.00 (166.03) 3,000.00 2,916.03 97.2%6109220 Freight & Delivery70.61 - 70.61 70.61 - 70.61 75.00 4.39 5.9%6109490 Miscellaneous500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short5.16 - 5.16 5.16 - 5.16 - (5.16) 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 Uniforms48.15 100.00 (51.85) 48.15 100.00 (51.85) 2,400.00 2,351.85 98.0%6117840 Telephones170.51 110.00 60.51 170.51 110.00 60.51 1,320.00 1,149.49 87.1%878.40 1,110.00 (231.60) 878.40 1,110.00 (231.60) 18,875.00 17,996.60 95.3%14,806.92 12,777.00 2,029.92 14,806.92 12,777.00 2,029.92 201,632.00 187,777.96 93.1%Net Income(13,626.45) (11,270.34) (2,356.11) (13,626.45) (11,270.34) (2,356.11) (84,624.00) (71,779.77) 84.8%SilverRock ResortGolf Shop Income StatementJuly 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group16,529.04 7,425.00 9,104.04 16,529.04 7,425.00 9,104.04 103,020.00 86,490.96 84.0%6311325 Insurance-Workers Comp3,017.71 2,006.00 1,011.71 3,017.71 2,006.00 1,011.71 26,974.00 23,956.29 88.8%6311720 Salaries11,557.08 12,200.00 (642.92) 11,557.08 12,200.00 (642.92) 146,400.00 134,842.92 92.1%6311800 Taxes-Employer Payroll3,036.48 6,953.00 (3,916.52) 3,036.48 6,953.00 (3,916.52) 91,481.00 88,444.52 96.7%6311880 Wages-Hourly40,226.74 41,284.00 (1,057.26) 40,226.74 41,284.00 (1,057.26) 567,262.00 527,035.26 92.9%6311882 Wages-Overtime- - - - - - 12,350.00 12,350.00 100.0%Total-CM-SALARIES & BENEFITS74,367.05 69,868.00 4,499.05 74,367.05 69,868.00 4,499.05 947,487.00 873,119.95 92.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals6,413.94 6,972.00 (558.06) 6,413.94 6,972.00 (558.06) 17,760.00 11,346.06 63.9%6313744 Fertilizer3,800.55 5,870.00 (2,069.45) 3,800.55 5,870.00 (2,069.45) 105,970.00 102,169.45 96.4%6313745 Herbicides- - - - - - 25,518.00 25,518.00 100.0%6313746 Flowers/Plants- - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline119.32 3,440.00 (3,320.68) 119.32 3,440.00 (3,320.68) 48,950.00 48,830.68 99.8%6313750 Golf Course Accessories989.40 - 989.40 989.40 - 989.40 13,140.00 12,150.60 92.5%6313756 POA Control- - - - - - 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp67.93 750.00 (682.07) 67.93 750.00 (682.07) 4,350.00 4,282.07 98.4%6313762 Supplies-Office18.00 - 18.00 18.00 - 18.00 - (18.00) 0.0%6313774 Sand- 390.00 (390.00) - 390.00 (390.00) 13,460.00 13,460.00 100.0%6313776 Seed- - - - - - 117,400.00 117,400.00 100.0%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) - 100.00 (100.00) 5,000.00 5,000.00 100.0%6313780 Sod- 4,300.00 (4,300.00) - 4,300.00 (4,300.00) 13,500.00 13,500.00 100.0%6313782 Topdressing3,475.39 - 3,475.39 3,475.39 - 3,475.39 10,000.00 6,524.61 65.2%Total-CM-SUPPLIES & MATERIALS14,884.53 21,822.00 (6,937.47) 14,884.53 21,822.00 (6,937.47) 387,998.00 373,113.47 96.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint1,415.00 2,830.00 (1,415.00) 1,415.00 2,830.00 (1,415.00) 33,960.00 32,545.00 95.8%6315685 CM-R&M-Bldngs & Othr Structures 1,731.35 1,250.00 481.35 1,731.35 1,250.00 481.35 5,550.00 3,818.65 68.8%6315690 CM-R&M-Equipment2,238.17 2,000.00 238.17 2,238.17 2,000.00 238.17 38,500.00 36,261.83 94.2%6315692 CM-R&M-Irrigation System2,876.59 4,400.00 (1,523.41) 2,876.59 4,400.00 (1,523.41) 19,050.00 16,173.41 84.9%6315696 CM-R&M-Pumps1,276.48 1,000.00 276.48 1,276.48 1,000.00 276.48 10,500.00 9,223.52 87.8%6315815 CM-R&M-Trees-Pruning Etc1,200.00 - 1,200.00 1,200.00 - 1,200.00 12,050.00 10,850.00 90.0%Total-CM-REPAIRS & MAINTENANCE10,737.59 11,480.00 (742.41) 10,737.59 11,480.00 (742.41) 119,610.00 108,872.41 91.0%6317836 Utilities-Natural Gas/LPG40.74 15.00 25.74 40.74 15.00 25.74 180.00 139.26 0.0%6317840 Telephones888.21 850.00 38.21 888.21 850.00 38.21 10,200.00 9,311.79 91.3%Total-CM-UTILITIES928.95 865.00 63.95 928.95 865.00 63.95 10,380.00 9,451.05 91.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7%6319100 Contract Svcs-Soil/Tissue Test- - - - - - 2,000.00 2,000.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- - - - - - 680.00 680.00 100.0%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- 100.00 (100.00) - 100.00 (100.00) 4,300.00 4,300.00 100.0%6319490 Miscellaneous12.68 100.00 (87.32) 12.68 100.00 (87.32) 1,200.00 1,187.32 98.9%6319718 Safety Equipment & Training- 200.00 (200.00) - 200.00 (200.00) 3,850.00 3,850.00 100.0%6319822 Uniforms434.61 920.00 (485.39) 434.61 920.00 (485.39) 11,040.00 10,605.39 96.1%Total-CM-OTHER EXPENSES847.29 2,494.00 (1,646.71) 847.29 2,494.00 (1,646.71) 41,458.00 40,610.71 98.0%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2017Annual Budget5 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 4,589.65 2,784.00 1,805.65 4,589.65 2,784.00 1,805.65 33,408.00 28,818.35 86.3%6321325 Insurance-Workers Comp628.69 500.00 128.69 628.69 500.00 128.69 5,955.00 5,326.31 89.4%6321800 Taxes-Employer Payroll809.65 1,733.00 (923.35) 809.65 1,733.00 (923.35) 20,793.00 19,983.35 96.1%6321880 Wages-Hourly12,740.44 13,334.00 (593.56) 12,740.44 13,334.00 (593.56) 156,528.00 143,787.56 91.9%6321882 Wages-Overtime- - - - - - 3,418.00 3,418.00 100.0%Total-CM-LM-SALARIES & BENEFITS18,768.43 18,351.00 417.43 18,768.43 18,351.00 417.43 220,102.00 201,333.57 91.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 100.00 (100.00) 1,025.00 1,025.00 100.0%6323788 Uniforms- 290.00 (290.00) - 290.00 (290.00) 3,480.00 3,480.00 100.0%Total-CM-LM-SUPPLIES & MATERIALS- 390.00 (390.00) - 390.00 (390.00) 4,505.00 4,505.00 100.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 140.45 250.00 (109.55) 140.45 250.00 (109.55) 4,250.00 4,109.55 96.7%Total-CM-LM-REPAIRS & MAINTENANCE140.45 250.00 (109.55) 140.45 250.00 (109.55) 4,250.00 4,109.55 96.7%120,674.29 125,520.00 (4,845.71) 120,674.29 125,520.00 (4,845.71) 1,735,790.00 1,615,115.71 93.0% JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping10,274.18 13,265.00 (2,990.82) 10,274.18 13,265.00 (2,990.82) 179,791.00 169,516.82 94.3%6337842 Utilities-Water6,452.53 10,150.00 (3,697.47) 6,452.53 10,150.00 (3,697.47) 70,047.00 63,594.47 90.8%16,726.71 23,415.00 (6,688.29) 16,726.71 23,415.00 (6,688.29) 249,838.00 233,111.29 93.3%Total-COURSE MAINTENANCECourse Maintenance Expense StatementJuly 2017Silverrock ResortAnnual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyJuly 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 696.00 (696.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp1,760.33 289.00 1,471.33 1,760.33 289.00 1,471.33 5,623.00 3,862.67 68.7%6411800 Taxes-Employer Payroll539.51 960.00 (420.49) 539.51 960.00 (420.49) 18,667.00 18,127.49 97.1%6411880 Wages-Hourly7,055.67 7,714.00 (658.33) 7,055.67 7,714.00 (658.33) 149,934.00 142,878.33 95.3%6411882 Wages-Overtime4.69 - 4.69 4.69 - 4.69 - (4.69) 0.0%Total-CBR-SALARIES & BENEFITS9,360.20 9,659.00 (298.80) 9,360.20 9,659.00 (298.80) 182,576.00 173,215.80 94.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable565.50 600.00 (34.50) 565.50 600.00 (34.50) 6,750.00 6,184.50 91.6%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) - 25.00 (25.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels160.00 120.00 40.00 160.00 120.00 40.00 2,182.00 2,022.00 92.7%6413796 Supplies-Bottled Water107.75 100.00 7.75 107.75 100.00 7.75 12,900.00 12,792.25 99.2%Total-CBR-SUPPLIES & MATERIALS833.25 845.00 (11.75) 833.25 845.00 (11.75) 36,627.00 33,943.75 92.7%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 2,025.81 300.00 1,725.81 2,025.81 300.00 1,725.81 3,600.00 1,574.19 43.7%6415695 CBR-R&M-Cart Maintenance & Repair500.00 500.00 - 500.00 500.00 - 6,450.00 5,950.00 92.2%Total-CBR-REPAIRS & MAINTENANCE2,525.81 800.00 1,725.81 2,525.81 800.00 1,725.81 10,050.00 7,524.19 74.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen304.34 800.00 (495.66) 304.34 800.00 (495.66) 9,600.00 9,295.66 96.8%6419220 Freight/Delivery- 75.00 (75.00) - 75.00 (75.00) 450.00 450.00 100.0%6419490 Miscellaneous356.25 600.00 (243.75) 356.25 600.00 (243.75) 7,200.00 6,843.75 95.1%6419820 Uniforms- - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES660.59 1,475.00 (814.41) 660.59 1,475.00 (814.41) 22,450.00 21,789.41 97.1%TOTAL-CARTS,BAGROOM & RANGE 13,379.85 12,779.00 (814.41) 13,379.85 12,779.00 600.85 251,703.00 236,473.15 93.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp754.43 115.00 639.43 754.43 115.00 639.43 2,450.00 1,695.57 69.2%6431800 Taxes-Employer Payroll236.20 400.00 (163.80) 236.20 400.00 (163.80) 8,494.00 8,257.80 97.2%6431880 Wages-Hourly2,798.26 3,079.00 (280.74) 2,798.26 3,079.00 (280.74) 65,341.00 62,542.74 95.7%6431882 Wages-Overtime- - - - - #N/A- - 0.0%Total-CS-SALARIES & BENEFITS3,788.89 3,594.00 194.89 3,788.89 3,594.00 #N/A76,285.00 72,496.11 95.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) - 50.00 (50.00) 1,050.00 1,050.00 100.0%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- 75.00 (75.00) - 75.00 (75.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 175.00 (175.00) - 175.00 (175.00) 3,975.00 3,975.00 100.0%Total-COURSE SERVICES3,788.89 3,769.00 19.89 3,788.89 3,769.00 #N/A80,260.00 76,471.11 95.3%17,168.74 16,548.00 620.74 17,168.74 16,548.00 620.74 331,963.00 308,969.26 93.1%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementJuly 2017Annual Budget7 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7%65-CH-UTILITIES6507836 Utilities-Natural Gas211.77 300.00 (88.23) 211.77 300.00 (88.23) 3,600.00 3,388.23 94.1%6507840 Utilities-Telephone1,072.46 1,150.00 (77.54) 1,072.46 1,150.00 (77.54) 13,800.00 12,727.54 92.2%6507842 Utilities-Water391.99 321.00 70.99 391.99 321.00 70.99 3,852.00 3,460.01 89.8%6507844 Utilities-Cable 490.49 380.00 110.49 490.49 380.00 110.49 4,560.00 4,069.51 89.2%Total-CH-UTILITIES2,166.71 2,151.00 15.71 2,166.71 2,151.00 15.71 25,812.00 23,645.29 91.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,750.00 1,825.00 (75.00) 1,750.00 1,825.00 (75.00) 22,500.00 20,750.00 92.2%6509099 Contract Services-Security5,286.24 5,000.00 286.24 5,286.24 5,000.00 286.24 60,000.00 54,713.76 91.2%6509215 Flowers & Decorations- - - - - - 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 200.00 (200.00) 7,000.00 7,000.00 100.0%6509718 Safety Equipment & Training - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,036.24 7,125.00 (88.76) 7,036.24 7,125.00 (88.76) 92,600.00 85,563.76 92.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures802.28 300.00 502.28 802.28 300.00 502.28 3,600.00 2,797.72 77.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair - 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE802.28 1,100.00 (297.72) 802.28 1,100.00 (297.72) 13,200.00 12,397.72 93.9%10,405.23 10,776.00 (370.77) 10,405.23 10,776.00 (370.77) 136,412.00 24,795.44 18.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementJuly 2017Annual Budget8 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 702.04 348.00 354.04 702.04 348.00 354.04 4,176.00 3,473.96 83.2%6601325 Insurance-Workers Comp94.00 94.00 - 94.00 94.00 - 1,129.00 1,035.00 91.7%6601720 Salaries1,904.96 2,508.00 (603.04) 1,904.96 2,508.00 (603.04) 30,096.00 28,191.04 93.7%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 145.20 326.00 (180.80) 3,912.00 3,766.80 96.3%Total-MKT-SALARIES & BENEFITS2,846.20 3,276.00 (429.80) 2,846.20 3,276.00 (429.80) 39,313.00 36,466.80 92.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office64.17 100.00 (35.83) 64.17 100.00 (35.83) 1,200.00 1,135.83 94.7%6603768 Supplies-Printing & Stationery310.42 - 310.42 310.42 - 310.42 4,425.00 4,114.58 93.0%374.59 100.00 274.59 374.59 100.00 274.59 5,625.00 5,250.41 93.3%66-MKT-UTILITIES6607840 Utilities-Telephone177.72 100.00 77.72 177.72 100.00 77.72 1,200.00 1,022.28 85.2%Total-MKT-UTILITIES177.72 100.00 77.72 177.72 100.00 77.72 1,200.00 1,022.28 85.2%66-MKT-OTHER EXPENSES6609010 Advertising 7,016.37 3,745.00 3,271.37 7,016.37 3,745.00 3,271.37 169,987.00 162,970.63 95.9%6609040 Business Meals- 25.00 (25.00) - 25.00 (25.00) 300.00 300.00 100.0%6609080 Collateral Material- - - - - - 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page198.00 150.00 48.00 198.00 150.00 48.00 1,800.00 1,602.00 89.0%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6609630 Promotion595.45 - 595.45 595.45 - 595.45 700.00 104.55 14.9%6609633 Promotion-Community- 75.00 (75.00) - 75.00 (75.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,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 EXPENSES7,809.82 4,045.00 3,764.82 7,809.82 4,045.00 3,764.82 184,822.00 177,012.18 95.8%11,208.33 7,521.00 3,687.33 11,208.33 7,521.00 3,687.33 230,960.00 219,751.67 95.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementJuly 2017Annual Budget9 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group3,667.54 1,509.00 2,158.54 3,667.54 1,509.00 2,158.54 18,108.00 14,440.46 79.7%6701325 Insurance-Workers Comp377.21 610.00 (232.79) 377.21 610.00 (232.79) 7,905.00 7,527.79 95.2%6701720 Salaries12,800.00 13,250.00 (450.00) 12,800.00 13,250.00 (450.00) 177,996.00 165,196.00 92.8%6701800 Taxes-Employer Payroll1,168.90 2,115.00 (946.10) 1,168.90 2,115.00 (946.10) 32,800.00 31,631.10 96.4%6701880 Wages-Hourly2,479.66 3,016.00 (536.34) 2,479.66 3,016.00 (536.34) 27,404.00 24,924.34 91.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,493.31 20,500.00 (6.69) 20,493.31 20,500.00 (6.69) 264,213.00 243,719.69 92.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer262.94 500.00 (237.06) 262.94 500.00 (237.06) 6,300.00 6,037.06 95.8%6703762 Supplies-Office- 105.00 (105.00) - 105.00 (105.00) 1,260.00 1,260.00 100.0%6703768 Supplies-Printing & Stationery- 100.00 (100.00) - 100.00 (100.00) 3,300.00 3,300.00 100.0%Total-G&A-SUPPLIES & MATERIALS262.94 705.00 (442.06) 262.94 705.00 (442.06) 10,860.00 10,597.06 97.6%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- - - - - - 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- - - - - - 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7%6709150 Dues & Subscriptions240.00 50.00 190.00 240.00 50.00 190.00 1,150.00 910.00 79.1%6709180 Employee Recruiting/Relocation- - - - - - 1,200.00 1,200.00 100.0%6709197 Equipment Rental553.28 550.00 3.28 553.28 550.00 3.28 6,600.00 6,046.72 91.6%6709202 Fees-Bank- 90.00 (90.00) - 90.00 (90.00) 1,080.00 1,080.00 100.0%6709208 Fees-Payroll Processing305.00 1,000.00 (695.00) 305.00 1,000.00 (695.00) 12,000.00 11,695.00 97.5%6709220 Freight/Delivery- 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6709490 Miscellaneous72.12 100.00 (27.88) 72.12 100.00 (27.88) 6,600.00 6,527.88 98.9%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services158.99 75.00 83.99 158.99 75.00 83.99 900.00 741.01 82.3%6709625 Professional Fees483.95 850.00 (366.05) 483.95 850.00 (366.05) 10,200.00 9,716.05 95.3%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) 2,400.00 2,400.00 100.0%6709810 Travel- - - - - - 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 - 75.00 (75.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES2,313.34 3,640.00 (351.66) 2,313.34 3,640.00 (1,326.66) 52,080.00 49,766.66 95.6%23,069.59 24,845.00 (1,775.41) 23,069.59 24,845.00 (1,775.41) 329,053.00 305,983.41 93.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2017Annual Budget10 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 9,829.27 10,050.00 (220.73) 9,829.27 10,050.00 (220.73) 121,050.00 111,220.73 91.9%6800193 Equipment Leases-Maintenance 9,181.20 6,050.00 3,131.20 9,181.20 6,050.00 3,131.20 116,200.00 107,018.80 92.1%6800194 Equipment Leases-Trailer802.07 600.00 202.07 802.07 600.00 202.07 7,200.00 6,397.93 88.9%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 3,870.00 4,700.00 (830.00) 56,400.00 52,530.00 93.1%6800197 Equipment Leases-Others2,087.49 1,150.00 937.49 2,087.49 1,150.00 937.49 20,200.00 18,112.51 0.0%25,770.03 22,550.00 3,220.03 25,770.03 22,550.00 3,220.03 321,050.00 295,279.97 92.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,999.00 (346.20) 8,652.80 8,999.00 (346.20) 107,987.00 99,334.20 92.0%6900210 FF&E Reserve447.21 503.00 (55.79) 447.21 503.00 (55.79) 59,281.00 58,833.79 99.2%6900800 Personal Property Taxes- 5,200.00 (5,200.00) - 5,200.00 (5,200.00) 11,800.00 11,800.00 100.0%6900323 Insurance-Commercial4,007.61 2,700.00 1,307.61 4,007.61 2,700.00 1,307.61 32,400.00 28,392.39 87.6%13,107.62 17,402.00 (4,294.38) 13,107.62 17,402.00 (4,294.38) 211,468.00 198,360.38 93.8%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 2017Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-20182017 2017 2017 2017 2017 2017Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp20Charity/Gift Certificate2Rain/Wind ChecksClub Staff53LQ HS Golf1085000002018 2018 2018 2018 2018 2018Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012