Loading...
01 July 2018 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2018 – July 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 JulyFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue75,915.57 74,927.25 988.32 1.3% 75,915.57 74,927.25 988.32 3,401,303.00 3,325,387.43 2%401000 Miscellaneous Golf Revenue6,150.00 2,859.45 3,290.55 115.1% 6,150.00 2,859.45 3,290.55 302,066.00 295,916.00 2%410000 Revenue-Golf Shop8,431.36 8,500.00 (68.64) -0.8%8,431.36 8,500.00 (68.64) 277,150.00 268,718.64 3%420000 Revenue-F&B Concession500.00 500.00 - 0.0%500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income0.05 - 0.05 0.05 - 0.05 - (0.05) 0%Total Income90,996.98 86,786.70 4,210.28 4.9% 90,996.98 86,786.70 4,210.28 3,992,519.00 3,901,522.02 2%Cost of Goods Sold510000 COS-Golf Shop4,883.69 4,757.81 125.88 -2.6%4,883.69 4,757.81 (125.88) 155,121.00 150,237.31 3%Total COS4,883.69 4,757.81 125.88 -2.6%4,883.69 4,757.81 (125.88) 155,121.00 150,237.31 3%Gross Profit86,113.29 82,028.89 4,084.40 5.0% 86,113.29 82,028.89 4,084.40 3,837,398.00 3,751,284.71 2%Expenses610000 Golf Pro Shop 15,856.95 14,298.33 1,558.62 -10.9% 15,856.95 14,298.33 1,558.62 221,115.00 205,258.05 7%630000 Course Maintenance129,104.51 126,300.00 2,804.51 -2.2% 129,104.51 126,300.00 2,804.51 1,740,490.00 1,611,385.49 7%633000 Maintenance Water & Energy23,591.84 23,415.00 176.84 -0.8% 23,591.84 23,415.00 176.84 249,838.00 226,246.16 9%640000 Outside Services19,278.86 16,992.06 2,286.80 -13.5% 19,278.86 16,992.06 2,286.80 354,598.00 335,319.14 5%650000 Clubhouse9,536.21 10,776.00 (1,239.79) 11.5%9,536.21 10,776.00 (1,239.79) 136,412.00 126,875.79 7%660000 Marketing7,994.64 7,521.00 473.64 -6.3%7,994.64 7,521.00 473.64 229,960.00 221,965.36 3%670000 General & Administrative21,931.66 24,846.00 (2,914.34) 11.7% 21,931.66 24,846.00 (2,914.34) 329,053.00 307,121.34 7%680000 Leases25,524.23 25,200.00 324.23 -1.3% 25,524.23 25,200.00 324.23 309,250.00 283,725.77 8%690000 Miscellaneous Other Expense21,202.94 20,198.55 1,004.39 -5.0% 21,202.94 20,198.55 1,004.39 241,826.00 220,623.06 9%Total Expenses274,021.84 269,546.94 4,474.90 -1.7% 274,021.84 269,546.94 (4,474.90) 3,812,542.00 3,538,520.16 7%(187,908.55) (187,518.05) (390.50) -0.2%(187,908.55) (187,518.05) (390.50) 24,856.00 212,764.55 0%Rounds of Golf PlayedPaid Rounds Played2,453 2,500 (47) -1.9%2,453 2,500 (47) 42,173 39,720 6%Ave $ Per Paid Round Green Fee30.95 29.97 0.98 3.3%30.95 29.97 0.98 80.65 49.70 38%Ave $ Per Paid Round Merchandise3.44 3.40 0.04 1.1%3.44 3.40 0.04 6.57 3.13 52%Ave $ Per Paid Miscellaneous 2.51 1.14 1.36 119.2%2.51 1.14 1.36 7.16 4.66 35%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJuly 20181 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees75,915.57 74,927.25 988.32 75,915.57 74,927.25 988.32 3,401,303.00 3,325,387.43 97.8%4010000 Rider Fee530.00 100.70 429.30 530.00 100.70 429.30 7,307.00 6,777.00 92.7%4040000 Club Rental450.00 503.50 (53.50) 450.00 503.50 (53.50) 21,087.00 20,637.00 97.9%4050000 Driving Range1,870.00 755.25 1,114.75 1,870.00 755.25 1,114.75 94,872.00 93,002.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- - - - - - 7,000.00 7,000.00 100.0%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue3,300.00 500.00 2,800.00 3,300.00 500.00 2,800.00 165,300.00 162,000.00 98.0% Total Revenue Fees82,065.57 77,786.70 4,278.87 82,065.57 77,786.70 4,278.87 3,703,369.00 3,621,303.43 97.8%82,065.57 77,786.70 4,278.87 82,065.57 77,786.70 4,278.87 3,703,369.00 3,621,303.43 97.8%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetJuly 20182 RevenuesActualBudgetVariance$6,150.00$2,859.453,290.55Favorable: Due to an increase in Resident Cards, budgeted $500.00 and sold $3300.00ExpensesActualBudgetVariance$15,856.95 $14,298.33 1,558.62Unfavorable: Due to increased hours worked for the increase in business. ActualBudgetVariance$19,278.86 $16,992.06 2,286.80Unfavorable: Due to additional manpower to maintain the services we provide with taking into consideration the extreme heat and humidity.ActualBudgetVariance$9,536.21$10,776.00(1,239.79)Favorable: Due to elimination of private cleaner which has been done in house in an effort to save expenses.ActualBudgetVariance$21,931.66 $24,846.00 (2,914.34)Favorable: Due to reallocation of accounting payroll. Golf ShopVariance ExplanationJuly 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%.Miscellaneous Golf RevenueOutside ServicesClubhouseGeneral and Administrative3-20-133 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,163.55 - 1,163.55 1,163.55 - 1,163.55 00 0%4100110 Sales Hard Goods3,611.47 2,125.00 1,486.47 3,611.47 2,125.00 1,486.47 69,288.00 65,676.53 94.8%4100112 Sales-Soft Goods4,588.00 6,375.00 (1,787.00) 4,588.00 6,375.00 (1,787.00) 207,863.00 203,275.00 97.8%5100639 GS-Discounts-Mdse(931.66) - (931.66) (931.66) - (931.66) - 931.66 0.0% Total Revenue Golf Shop8,431.36 8,500.00 (68.64) 8,431.36 8,500.00 (68.64) 277,151.00 269,883.19 97.4%COS 5100150 COS-GS-Hard Goods 2,034.91 1,189.36 845.55 2,034.91 1,189.36 845.55 40,187.04 38,152.13 94.9%5100151 COS-GS-Soft Goods 2,644.40 3,741.00 (1,096.60) 2,644.40 3,741.00 (1,096.60) 120,560.54 117,916.14 97.8%5100152 COS-GS-Purchase Disc (15.32) (246.50) 231.18 (15.32) (246.50) 231.18 (8,037.00) (8,021.68) 99.8%5100220 COS-GS-Freight Merch 219.70 73.95 145.75 219.70 73.95 145.75 2,411.00 2,191.30 90.9%Cost of Sales - Golf Shop4,883.69 4,757.81 125.88 4,883.69 4,757.81 125.88 155,121.58 150,237.89 96.9%Gross Profit 3,547.67 3,742.19 (194.52) 3,547.67 3,742.19 (194.52) 122,029.42 119,645.30 98.0%COS %57.9% 56.0% -1.9% 57.9% 56.0% -1.9% 53.1% 55.7% 104.9%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,875.98 1,740.00 135.98 1,875.98 1,740.00 135.98 26,796.00 24,920.02 93.0%6101325 Insurance-Workers Comp 575.83 367.72 208.11 575.83 367.72 208.11 5,635.00 5,059.17 89.8%6101720 Salaries4,400.00 4,400.00 - 4,400.00 4,400.00 - 51,000.00 46,600.00 91.4%6101800 Taxes-Employer Payroll 959.16 1,274.76 (315.60) 959.16 1,274.76 (315.60) 19,935.00 18,975.84 95.2%6101880 Wages-Hourly7,879.50 5,405.85 2,473.65 7,879.50 5,405.85 2,473.65 98,874.00 90,994.50 92.0%6101882 Wages-Overtime12.00 - 12.00 12.00 - 12.00 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 15,702.47 13,188.33 2,514.14 15,702.47 13,188.33 2,514.14 202,240.00 187,502.41 92.7%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) - 250.00 (250.00) 3,000.00 3,000.00 100.0%6109220 Freight & Delivery- - - - - - 75.00 75.00 100.0%6109490 Miscellaneous- 500.00 (500.00) - 500.00 (500.00) 6,000.00 6,000.00 100.0%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short59.27 - 59.27 59.27 - 59.27 - (59.27) 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 Uniforms32.63 100.00 (67.37) 32.63 100.00 (67.37) 2,400.00 2,367.37 98.6%6117840 Telephones62.58 110.00 (47.42) 62.58 110.00 (47.42) 1,320.00 1,257.42 95.3%154.48 1,110.00 (955.52) 154.48 1,110.00 (955.52) 18,875.00 18,720.52 99.2%15,856.95 14,298.33 1,558.62 15,856.95 14,298.33 1,558.62 221,115.00 206,222.93 93.3%Net Income(12,309.28) (10,556.14) (1,753.14) (12,309.28) (10,556.14) (1,753.14) (99,085.58) (86,577.63) 87.4%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetJuly 20184 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group9,744.57 7,425.00 2,319.57 9,744.57 7,425.00 2,319.57 103,020.00 93,275.43 90.5%6311325 Insurance-Workers Comp2,039.61 2,006.00 33.61 2,039.61 2,006.00 33.61 26,974.00 24,934.39 92.4%6311720 Salaries12,476.92 12,476.92 - 12,476.92 12,476.92 - 146,400.00 133,923.08 91.5%6311800 Taxes-Employer Payroll4,430.88 6,953.00 (2,522.12) 4,430.88 6,953.00 (2,522.12) 94,048.00 89,617.12 95.3%6311880 Wages-Hourly40,282.61 41,007.08 (724.47) 40,282.61 41,007.08 (724.47) 564,695.00 524,412.39 92.9%6311882 Wages-Overtime5,649.27 - 5,649.27 5,649.27 - 5,649.27 12,350.00 6,700.73 54.3%Total-CM-SALARIES & BENEFITS74,623.86 69,868.00 4,755.86 74,623.86 69,868.00 4,755.86 947,487.00 872,863.14 92.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals993.72 190.00 803.72 993.72 190.00 803.72 17,760.00 16,766.28 94.4%6313744 Fertilizer11,794.62 5,870.00 5,924.62 11,794.62 5,870.00 5,924.62 100,520.00 88,725.38 88.3%6313745 Herbicides1,854.50 6,782.00 (4,927.50) 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,004.48 3,200.00 (195.52) 3,004.48 3,200.00 (195.52) 46,860.00 43,855.52 93.6%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 Supp293.07 750.00 (456.93) 293.07 750.00 (456.93) 4,350.00 4,056.93 93.3%6313762 Supplies-Office211.79 - 211.79 211.79 - 211.79 - (211.79) 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 Sod1,684.07 4,300.00 (2,615.93) 1,684.07 4,300.00 (2,615.93) 13,500.00 11,815.93 87.5%6313782 Topdressing2,045.74 - 2,045.74 2,045.74 - 2,045.74 10,000.00 7,954.26 79.5%Total-CM-SUPPLIES & MATERIALS21,881.99 21,582.00 299.99 21,881.99 21,582.00 299.99 380,458.00 358,576.01 94.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 3,850.00 (10.00) 3,840.00 3,850.00 (10.00) 46,200.00 42,360.00 91.7%6315685 CM-R&M-Bldngs & Othr Structures 130.43 1,250.00 (1,119.57) 130.43 1,250.00 (1,119.57) 5,550.00 5,419.57 97.6%6315690 CM-R&M-Equipment2,822.36 2,000.00 822.36 2,822.36 2,000.00 822.36 38,500.00 35,677.64 92.7%6315692 CM-R&M-Irrigation System4,446.54 4,400.00 46.54 4,446.54 4,400.00 46.54 19,050.00 14,603.46 76.7%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 10,500.00 10,500.00 100.0%6315815 CM-R&M-Trees-Pruning Etc- - - - - - 12,050.00 12,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE11,239.33 12,500.00 (1,260.67) 11,239.33 12,500.00 (1,260.67) 131,850.00 120,610.67 91.5%6317836 Utilities-Natural Gas/LPG 20.22 15.00 5.22 20.22 15.00 5.22 180.00 159.78 0.0%6317840 Telephones759.15 850.00 (90.85) 759.15 850.00 (90.85) 10,200.00 9,440.85 92.6%Total-CM-UTILITIES779.37 865.00 (85.63) 779.37 865.00 (85.63) 10,380.00 9,600.63 92.5%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 Removal104.02 524.00 (419.98) 104.02 524.00 (419.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) - 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 & Permits575.00 100.00 475.00 575.00 100.00 475.00 4,300.00 3,725.00 86.6%6319490 Miscellaneous- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training256.47 200.00 56.47 256.47 200.00 56.47 3,850.00 3,593.53 93.3%6319822 Uniforms767.45 920.00 (152.55) 767.45 920.00 (152.55) 11,040.00 10,272.55 93.0%Total-CM-OTHER EXPENSES2,102.94 2,494.00 (391.06) 2,102.94 2,494.00 (391.06) 41,458.00 39,355.06 94.9%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementAnnual BudgetJuly 20185 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 3,597.86 2,784.00 813.86 3,597.86 2,784.00 813.86 33,408.00 29,810.14 89.2%6321325 Insurance-Workers Comp 574.07 500.00 74.07 574.07 500.00 74.07 5,955.00 5,380.93 90.4%6321800 Taxes-Employer Payroll863.30 1,733.00 (869.70) 863.30 1,733.00 (869.70) 20,793.00 19,929.70 95.8%6321880 Wages-Hourly12,830.48 13,334.00 (503.52) 12,830.48 13,334.00 (503.52) 156,528.00 143,697.52 91.8%6321882 Wages-Overtime611.31 - 611.31 611.31 - 611.31 3,418.00 2,806.69 82.1%Total-CM-LM-SALARIES & BENEFITS18,477.02 18,351.00 126.02 18,477.02 18,351.00 126.02 220,102.00 201,624.98 91.6%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 - 250.00 (250.00) - 250.00 (250.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 250.00 (250.00) 4,250.00 4,250.00 100.0%129,104.51 126,300.00 2,804.51 129,104.51 126,300.00 2,804.51 1,740,490.00 1,611,385.49 92.6% JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 17,171.38 13,350.00 3,821.38 17,171.38 13,350.00 3,821.38 179,791.00 162,619.62 90.4%6337842 Utilities-Water6,420.46 10,065.00 (3,644.54) 6,420.46 10,065.00 (3,644.54) 70,047.00 63,626.54 90.8%23,591.84 23,415.00 176.84 23,591.84 23,415.00 176.84 249,838.00 226,246.16 90.6%Total-COURSE MAINTENANCECourse Maintenance Expense StatementJuly 2018Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyJuly 2018Total-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 Comp556.48 298.03 258.45 556.48 298.03 258.45 6,172.00 5,615.52 91.0%6411800 Taxes-Employer Payroll924.78 989.46 (64.68) 924.78 989.46 (64.68) 20,493.00 19,568.22 95.5%6411880 Wages-Hourly9,656.38 7,947.50 1,708.88 9,656.38 7,947.50 1,708.88 164,599.00 154,942.62 94.1%6411882 Wages-Overtime41.27 - 41.27 41.27 - 41.27 - (41.27) 0.0%Total-CBR-SALARIES & BENEFITS11,178.919,930.99 1,247.92 11,178.91 9,930.99 1,247.92 199,616.00 188,437.09 94.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable113.10 600.00 (486.90) 113.10 600.00 (486.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-Office14.67 25.00 (10.33) 14.67 25.00 (10.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels778.81 120.00 658.81 778.81 120.00 658.81 2,182.00 1,403.19 64.3%6413796 Supplies-Bottled Water114.19 100.00 14.19 114.19 100.00 14.19 12,900.00 12,785.81 99.1%Total-CBR-SUPPLIES & MATERIALS1,020.77 845.00 175.77 1,020.77 845.00 175.77 36,627.00 33,756.23 92.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) - 300.00 (300.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair 2,200.50 500.00 1,700.50 2,200.50 500.00 1,700.50 6,450.00 4,249.50 65.9%Total-CBR-REPAIRS & MAINTENANCE2,200.50 800.00 1,400.50 2,200.50 800.00 1,400.50 10,050.00 7,849.50 78.1%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen722.48 800.00 (77.52) 722.48 800.00 (77.52) 9,600.00 8,877.52 92.5%6419220 Freight/Delivery- 75.00 (75.00) - 75.00 (75.00) 450.00 450.00 100.0%6419490 Miscellaneous98.66 600.00 (501.34) 98.66 600.00 (501.34) 7,200.00 7,101.34 98.6%6419820 Uniforms- - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES821.14 1,475.00 (653.86) 821.14 1,475.00 (653.86) 22,450.00 21,628.86 96.3%TOTAL-CARTS,BAGROOM & RANGE15,221.3213,050.99(653.86) 15,221.32 13,050.99 2,170.33 268,743.00 251,671.68 93.6%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp160.63 120.97 39.66 160.63 120.97 39.66 2,630.00 2,469.37 93.9%6431800 Taxes-Employer Payroll319.16 419.35 (100.19) 319.16 419.35 (100.19) 9,117.00 8,797.84 96.5%6431880 Wages-Hourly3,577.75 3,225.75 352.00 3,577.75 3,225.75 352.00 70,133.00 66,555.25 94.9%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,057.54 3,766.07 291.47 4,057.54 3,766.07 291.47 81,880.00 77,822.46 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 SERVICES4,057.54 3,941.07 116.47 4,057.54 3,941.07 116.47 85,855.00 81,797.46 95.3%19,278.8616,992.062,286.80 19,278.86 16,992.06 2,286.80 354,598.00 329,494.14 92.9%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetJuly 20187 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.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 Gas448.85 300.00 148.85 448.85 300.00 148.85 3,600.00 3,151.15 87.5%6507840 Utilities-Telephone- 1,150.00 (1,150.00) - 1,150.00 (1,150.00) 13,800.00 13,800.00 100.0%6507842 Utilities-Water832.40 321.00 511.40 832.40 321.00 511.40 3,852.00 3,019.60 78.4%6507844 Utilities-Cable495.84 380.00 115.84 495.84 380.00 115.84 4,560.00 4,064.16 89.1%Total-CH-UTILITIES1,777.09 2,151.00 (373.91) 1,777.09 2,151.00 (373.91) 25,812.00 24,034.91 93.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning475.00 1,825.00 (1,350.00) 475.00 1,825.00 (1,350.00) 22,500.00 22,025.00 97.9%6509099 Contract Services-Security5,391.21 5,000.00 391.21 5,391.21 5,000.00 391.21 60,000.00 54,608.79 91.0%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 & Training251.47 100.00 151.47 251.47 100.00 151.47 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES6,117.68 7,125.00 (1,007.32)6,117.68 7,125.00 (1,007.32) 92,600.00 86,482.32 93.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,241.44 300.00 941.44 1,241.44 300.00 941.44 3,600.00 2,358.56 65.5%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 & MAINTENANCE1,241.44 1,100.00 141.44 1,241.44 1,100.00 141.44 13,200.00 11,958.56 90.6%9,536.21 10,776.00(1,239.79)9,536.21 10,776.00 (1,239.79) 136,412.00 23,917.12 17.5%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetJuly 20188 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 355.89 348.00 7.89 4,176.00 3,820.11 91.5%6601325 Insurance-Workers Comp94.17 94.00 0.17 94.17 94.00 0.17 1,129.00 1,034.83 91.7%6601720 Salaries1,905.20 2,508.00 (602.80) 1,905.20 2,508.00 (602.80) 30,096.00 28,190.80 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,500.46 3,276.00 (775.54) 2,500.46 3,276.00 (775.54) 39,313.00 36,812.54 93.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 426.28 - 426.28 426.28 - 426.28 4,425.00 3,998.72 90.4%426.28 100.00 326.28 426.28 100.00 326.28 5,625.00 5,198.72 92.4%66-MKT-UTILITIES6607840 Utilities-Telephone 376.94 100.00 276.94 376.94 100.00 276.94 1,200.00 823.06 68.6%Total-MKT-UTILITIES376.94 100.00 276.94 376.94 100.00 276.94 1,200.00 823.06 68.6%66-MKT-OTHER EXPENSES6609010 Advertising4,690.96 3,745.00 945.96 4,690.96 3,745.00 945.96 169,987.00 165,296.04 97.2%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 Page- 150.00 (150.00) - 150.00 (150.00) 1,800.00 1,800.00 100.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 Promotion- - - - - - 700.00 700.00 100.0%6609633 Promotion-Community- 75.00 (75.00) - 75.00 (75.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 EXPENSES4,690.96 4,045.00 645.96 4,690.96 4,045.00 645.96 183,822.00 179,131.04 97.4%7,994.64 7,521.00 473.64 7,994.64 7,521.00 473.64 229,960.00 221,965.36 96.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetJuly 20189 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,173.01 1,509.00 664.01 2,173.01 1,509.00 664.01 18,108.00 15,934.99 88.0%6701325 Insurance-Workers Comp505.92 610.00 (104.08) 505.92 610.00 (104.08) 7,905.00 7,399.08 93.6%6701720 Salaries11,494.80 13,251.00 (1,756.20) 11,494.80 13,251.00 (1,756.20) 177,996.00 166,501.20 93.5%6701800 Taxes-Employer Payroll1,068.64 2,115.00 (1,046.36) 1,068.64 2,115.00 (1,046.36) 32,800.00 31,731.36 96.7%6701880 Wages-Hourly2,485.00 3,016.00 (531.00) 2,485.00 3,016.00 (531.00) 27,404.00 24,919.00 90.9%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS17,727.37 20,501.00 (2,773.63) 17,727.37 20,501.00 (2,773.63) 264,213.00 246,485.63 93.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer446.68 500.00 (53.32) 446.68 500.00 (53.32) 6,300.00 5,853.32 92.9%6703762 Supplies-Office93.24 105.00 (11.76) 93.24 105.00 (11.76) 1,260.00 1,166.76 92.6%6703768 Supplies-Printing & Stationery480.82 100.00 380.82 480.82 100.00 380.82 3,300.00 2,819.18 85.4%Total-G&A-SUPPLIES & MATERIALS1,020.74 705.00 315.74 1,020.74 705.00 315.74 10,860.00 9,839.26 90.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 & Subscriptions- 50.00 (50.00) - 50.00 (50.00) 1,150.00 1,150.00 100.0%6709180 Employee Recruiting/Relocation60.00 - 60.00 60.00 - 60.00 1,200.00 1,140.00 95.0%6709197 Equipment Rental367.75 550.00 (182.25) 367.75 550.00 (182.25) 6,600.00 6,232.25 94.4%6709202 Fees-Bank61.79 90.00 (28.21) 61.79 90.00 (28.21) 1,080.00 1,018.21 94.3%6709208 Fees-Payroll Processing355.20 1,000.00 (644.80) 355.20 1,000.00 (644.80) 12,000.00 11,644.80 97.0%6709220 Freight/Delivery- 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6709490 Miscellaneous167.81 100.00 67.81 167.81 100.00 67.81 6,600.00 6,432.19 97.5%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) - 75.00 (75.00) 900.00 900.00 100.0%6709625 Professional Fees1,671.00 850.00 821.00 1,671.00 850.00 821.00 10,200.00 8,529.00 83.6%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 EXPENSES3,183.55 3,640.00 518.55 3,183.55 3,640.00 (456.45) 52,080.00 48,896.45 93.9%21,931.66 24,846.00 (2,914.34) 21,931.66 24,846.00 (2,914.34) 329,053.00 307,121.34 93.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetJuly 201810 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,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 9,500.00 (318.80) 9,181.20 9,500.00 (318.80) 114,000.00 104,818.80 91.9%6800194 Equipment Leases-Trailer583.07 600.00 (16.93) 583.07 600.00 (16.93) 7,200.00 6,616.93 91.9%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 3,870.00 3,900.00 (30.00) 46,800.00 42,930.00 91.7%6800197 Equipment Leases-Others2,060.69 1,150.00 910.69 2,060.69 1,150.00 910.69 20,200.00 18,139.31 0.0%25,524.23 25,200.00324.23 25,524.23 25,200.00 324.23 309,250.00 283,725.7791.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 9,500.00 9,500.00 - 114,000.00 104,500.00 91.7%6900210 FF&E Reserve1,518.32 1,498.55 19.77 1,518.32 1,498.55 19.77 68,026.00 66,507.68 97.8%6900800 Personal Property Taxes5,403.06 5,200.00 203.06 5,403.06 5,200.00 203.06 11,800.00 6,396.94 54.2%6900323 Insurance-Commercial4,781.56 4,000.00 781.56 4,781.56 4,000.00 781.56 48,000.00 43,218.44 90.0%21,202.94 20,198.551,004.39 21,202.94 20,198.55 1,004.39 241,826.00 220,623.0691.2%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateJuly 201811 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-20192018 2018 2018 2018 2018 2018Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp18Charity/Gift Certificate6Rain/Wind ChecksClub Staff13LQ HS Golf239000002019 2019 2019 2019 2019 2019Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012