Loading...
03 Septeber 2015 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2015 – September 2015 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 September Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue128,235.25 131,828.00 (3,592.75) -2.7% 282,404.75 283,273.00 (868.25) 3,199,237.00 2,916,832.25 9%401000 Miscellaneous Golf Revenue12,812.50 8,360.00 4,452.50 53.3% 31,036.50 20,615.00 10,421.50 349,259.00 318,222.50 9%410000 Revenue-Golf Shop11,030.97 14,260.00 (3,229.03) -22.6% 27,229.70 30,336.00 (3,106.30) 278,585.00 251,355.30 10%420000 Revenue-F&B Concession500.00 500.00 - 0.0%1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income1.93 - 1.93 5.93 - 5.93 - (5.93) 0%Total Income152,580.65 154,948.00 (2,367.35) -1.5% 342,176.88 335,724.00 6,452.88 3,839,081.00 3,496,904.12 9%Cost of Goods Sold510000 COS-Golf Shop6,338.97 7,980.80 (1,641.83) 20.6% 15,800.06 16,978.88 1,178.82 155,924.00 140,123.94 10%Total COS6,338.97 7,980.80 (1,641.83) 20.6% 15,800.06 16,978.88 1,178.82 155,924.00 140,123.94 10%Gross Profit146,241.68 146,967.20 (725.52) -0.5% 326,376.82 318,745.12 7,631.70 3,683,157.00 3,356,780.18 9%Expenses610000 Golf Pro Shop 12,705.30 13,513.00 (807.70) 6.0% 39,475.99 41,339.00 (1,863.01) 204,827.00 165,351.01 19%630000 Course Maintenance131,353.02 143,399.00 (12,045.98) 8.4% 381,431.82 391,917.00 (10,485.18) 1,712,795.00 1,331,363.18 22%633000 Maintenance Water & Energy22,299.41 19,975.00 2,324.41 -11.6% 64,413.87 60,260.00 4,153.87 225,129.00 160,715.13 29%640000 Outside Services17,780.40 16,704.00 1,076.40 -6.4% 48,298.58 48,889.00 (590.42) 309,830.00 261,531.42 16%650000 Clubhouse11,423.52 10,636.00 787.52 -7.4% 31,552.05 31,908.00 (355.95) 136,332.00 104,779.95 23%660000 Marketing24,471.12 21,191.00 3,280.12 -15.5% 45,353.34 38,269.00 7,084.34 240,177.00 194,823.66 19%670000 General & Administrative23,254.99 25,091.00 (1,836.01) 7.3% 69,484.49 75,230.00 (5,745.51) 327,511.00 258,026.51 21%680000 Leases22,633.77 22,550.00 83.77 -0.4% 66,934.49 67,650.00 (715.51) 271,050.00 204,115.51 25%690000 Miscellaneous Other Expense16,378.12 17,157.00 (778.88) 4.5% 48,504.25 46,426.00 2,078.25 202,025.00 153,520.75 24%Total Expenses282,299.65 290,216.00 (7,916.35) 2.7% 795,448.88 801,888.00 6,439.12 3,629,676.00 2,834,227.12 22%(136,057.97) (143,248.80) 7,190.83 5.0%(469,072.06) (483,142.88) 14,070.82 53,481.00 522,553.06 0%Rounds of Golf PlayedPaid Rounds Played2,792 3,100 (308) -9.9%7,571 7,925 (354) 41,100 33,529 18%Ave $ Per Paid Round Green Fee45.93 42.53 3.40 8.0%37.30 35.74 1.56 77.84 40.54 48%Ave $ Per Paid Round Merchandise3.95 4.60 (0.65) -14.1%3.60 3.83 (0.23) 6.78 3.18 53%Ave $ Per Paid Miscellaneous 4.59 2.70 1.89 70.2%4.10 2.60 1.50 8.50 4.40 48%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateSeptember 20151 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees128,235.25 131,828.00 (3,592.75) 282,404.75 283,273.00 (868.25) 3,199,237.00 2,916,832.25 91.2%4010000 Rider Fee777.50 310.00 467.50 1,932.50 793.00 1,139.50 7,738.00 5,805.50 75.0%4040000 Club Rental985.00 1,550.00 (565.00) 2,390.00 3,963.00 (1,573.00) 23,238.00 20,848.00 89.7%4050000 Driving Range3,850.00 3,100.00 750.00 9,320.00 7,159.00 2,161.00 100,984.00 91,664.00 90.8%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 300.00 (300.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract - - - 894.00 1,000.00 (106.00) 4,000.00 3,106.00 77.7%4091000 Golf Professional Rental Fee- - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue7,200.00 3,300.00 3,900.00 16,500.00 7,400.00 9,100.00 171,200.00 154,700.00 90.4% Total Revenue Fees141,047.75 140,188.00 859.75 313,441.25 303,888.00 9,553.25 3,548,497.00 3,235,055.75 91.2%141,047.75 140,188.00 859.75 313,441.25 303,888.00 9,553.25 3,548,497.00 3,235,055.75 91.2%SilverRock ResortStatement of Fees RevenueSeptember 2015Total IncomeMonth to DateYear to DateAnnual Budget2 Revenues ActualBudgetVariance$12,812.50 $8,360.00 4,452.50Favorable: Due to increased Resident Card Sales by $3,900. We continue to try and understand the patterns or trends related to Resident Card purchases. ActualBudgetVariance11,030.97$ 14,260.00$ (3,229.03)Unfavorable: Due to rounds of golf being 308 rounds below budget. In addition, discounted golf rates typically bring in customers who do not spend as much while at the course.ExpensesActualBudgetVariance$22,299.41 $19,975.00 2,324.41Unfavorable: Due to run time of front entrance water feature being slightly more than what was projected.ActualBudgetVariance$24,471.12 $21,191.00 3,280.12Unfavorable: Due to timing of invoices from Kiner Marketing and Time Warner Cable. This will offset as we continue through the 2015-2016 Fiscal Year.MarketingMiscellaneous Golf RevenuePro Shop Merchandise SalesWater & Energyprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationSeptember 2015The 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 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous48.40 - 48.40 367.11 - 367.11 00 0%4100110 Sales Hard Goods5,308.75 4,991.00 317.75 13,627.27 10,618.00 3,009.27 97,505.00 83,877.73 86.0%4100112 Sales-Soft Goods6,807.50 9,269.00 (2,461.50) 16,852.00 19,718.00 (2,866.00) 181,080.00 164,228.00 90.7%5100639 GS-Discounts-Mdse (1,133.68) - (1,133.68) (3,616.68) - (3,616.68) - 3,616.68 0.0% Total Revenue Golf Shop11,030.97 14,260.00 (3,229.03) 27,229.70 30,336.00 (3,106.30) 278,585.00 251,722.41 90.4%COS 5100150 COS-GS-Hard Goods 2,916.76 2,894.78 21.98 7,482.37 6,158.44 1,323.93 56,552.90 49,070.53 86.8%5100151 COS-GS-Soft Goods 3,330.78 5,376.02 (2,045.24) 7,921.40 11,436.44 (3,515.04) 105,026.40 97,105.00 92.5%5100152 COS-GS-Purchase Disc- (414.00) 414.00 - (880.00) 880.00 (8,079.00) (8,079.00) 100.0%5100220 COS-GS-Freight Merch 91.43 124.00 (32.57) 396.29 264.00 132.29 2,424.00 2,027.71 83.7%Cost of Sales - Golf Shop6,338.97 7,980.80 (1,641.83) 15,800.06 16,978.88 (1,178.82) 155,924.30 140,124.24 89.9%Gross Profit 4,692.00 6,279.20 (1,587.20) 11,429.64 13,357.12 (1,927.48) 122,660.70 111,598.17 91.0%COS % 57.5% 56.0% -1.5% 58.0% 56.0% -2.1% 53.1% 55.7% 104.9%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,684.45 2,046.00 (361.55) 5,034.60 6,138.00 (1,103.40) 27,621.00 22,586.40 81.8%6101325 Insurance-Workers Comp 330.08 330.00 0.08 1,785.30 1,016.00 769.30 5,042.00 3,256.70 64.6%6101720 Salaries4,037.70 3,950.00 87.70 11,261.10 11,850.00 (588.90) 45,000.00 33,738.90 75.0%6101800 Taxes-Employer Payroll 177.45 1,231.00 (1,053.55) 2,140.54 3,789.00 (1,648.46) 18,825.00 16,684.46 88.6%6101880 Wages-Hourly4,931.37 4,846.00 85.37 16,821.75 15,216.00 1,605.75 89,463.00 72,641.25 81.2%6101882 Wages-Overtime18.09 - 18.09 96.19 - 96.19 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 11,179.14 12,403.00 (1,223.86) 37,139.48 38,009.00 (869.52) 185,951.00 149,860.59 80.6%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office424.58 250.00 174.58 424.58 750.00 (325.42) 3,000.00 2,575.42 85.8%6109220 Freight & Delivery- - - - - - 75.00 75.00 100.0%6109490 Miscellaneous511.34 500.00 11.34 1,082.24 1,500.00 (417.76) 6,000.00 4,917.76 82.0%6109150 Dues and Subscriptions- - - 102.30 - 102.30 2,300.00 2,197.70 95.6%6109500 ProShop-Over/Short(0.14) - (0.14) 3.63 - 3.63 - (3.63) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 450.00 (450.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms524.96 100.00 424.96 524.96 300.00 224.96 2,400.00 1,875.04 78.1%6117840 Telephones65.42 110.00 (44.58) 198.80 330.00 (131.20) 1,320.00 1,121.20 84.9%1,526.16 1,110.00 416.16 2,336.51 3,330.00 (993.49) 18,875.00 16,538.49 87.6%12,705.30 13,513.00 (807.70) 39,475.99 41,339.00 (1,863.01) 204,826.00 166,399.08 81.2%Net Income(8,013.30) (7,233.80) (779.50) (28,046.35) (27,981.88) (64.47) (82,165.30) (54,800.91) 66.7%SilverRock ResortGolf Shop Income StatementSeptember 2015Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group6,695.61 8,990.00 (2,294.39) 25,185.33 26,970.00 (1,784.67) 107,880.00 82,694.67 76.7%6311325 Insurance-Workers Comp1,825.06 1,825.00 0.06 7,535.60 5,475.00 2,060.60 24,794.00 17,258.40 69.6%6311720 Salaries11,926.20 11,900.00 26.20 33,167.80 35,700.00 (2,532.20) 142,017.20 108,849.40 76.6%6311800 Taxes-Employer Payroll6,083.51 6,814.00 (730.49) 15,456.51 20,442.00 (4,985.49) 93,302.00 77,845.49 83.4%6311880 Wages-Hourly37,354.28 36,772.00 582.28 114,579.58 110,316.00 4,263.58 508,481.80 393,902.22 77.5%6311882 Wages-Overtime- - - 79.32 - 79.32 15,945.00 15,865.68 99.5%Total-CM-SALARIES & BENEFITS63,884.66 66,301.00 (2,416.34) 196,004.14 198,903.00 (2,898.86) 892,420.00 696,415.86 78.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals4,441.48 3,500.00 941.48 13,411.15 9,000.00 4,411.15 34,600.00 21,188.85 61.2%6313744 Fertilizer7,887.41 11,000.00 (3,112.59) 37,684.83 36,000.00 1,684.83 112,500.00 74,815.17 66.5%6313745 Herbicides7,972.16 7,000.00 972.16 7,972.16 7,000.00 972.16 17,000.00 9,027.84 53.1%6313746 Flowers/Plants- 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline4,028.39 5,100.00 (1,071.61) 13,496.83 15,500.00 (2,003.17) 55,020.00 41,523.17 75.5%6313750 Golf Course Accessories80.34 500.00 (419.66) 1,050.62 900.00 150.62 13,000.00 11,949.38 91.9%6313756 POA Control- - - 250.09 - 250.09 7,000.00 6,749.91 96.4%6313758 Miscellaneous Supp74.28 750.00 (675.72) 1,076.39 2,250.00 (1,173.61) 4,350.00 3,273.61 75.3%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 5,000.00 (5,000.00) - 5,780.00 (5,780.00) 13,460.00 13,460.00 100.0%6313776 Seed- 250.00 (250.00) 595.32 950.00 (354.68) 125,900.00 125,304.68 99.5%6313778 Small Tools & Non-Capital Equip273.29 2,000.00 (1,726.71) 340.89 2,200.00 (1,859.11) 5,000.00 4,659.11 93.2%6313780 Sod3,449.13 2,000.00 1,449.13 4,819.66 5,500.00 (680.34) 10,450.00 5,630.34 53.9%6313782 Topdressing- - - 2,289.59 2,500.00 (210.41) 10,600.00 8,310.41 78.4%Total-CM-SUPPLIES & MATERIALS28,206.48 38,100.00 (9,893.52) 82,987.53 88,580.00 (5,592.47) 411,930.00 328,942.47 79.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint4,316.50 2,600.00 1,716.50 9,976.50 7,800.00 2,176.50 31,200.00 21,223.50 68.0%6315685 CM-R&M-Bldngs & Othr Structures 225.06 550.00 (324.94) 1,545.06 2,550.00 (1,004.94) 5,550.00 4,004.94 72.2%6315690 CM-R&M-Equipment1,600.94 2,000.00 (399.06) 9,621.95 6,500.00 3,121.95 40,000.00 30,378.05 75.9%6315692 CM-R&M-Irrigation System1,436.63 1,500.00 (63.37) 8,286.46 9,400.00 (1,113.54) 19,050.00 10,763.54 56.5%6315696 CM-R&M-Pumps3,247.77 1,000.00 2,247.77 4,997.77 3,000.00 1,997.77 10,500.00 5,502.23 52.4%6315815 CM-R&M-Trees-Pruning Etc5,075.27 5,500.00 (424.73) 5,075.27 5,500.00 (424.73) 12,050.00 6,974.73 57.9%Total-CM-REPAIRS & MAINTENANCE15,902.17 13,150.00 2,752.17 39,503.01 34,750.00 4,753.01 118,350.00 78,846.99 66.6%6317836 Utilities-Natural Gas/LPG 19.11 15.00 4.11 60.10 45.00 15.10 180.00 119.90 0.0%6317840 Telephones1,041.87 850.00 191.87 3,288.34 2,550.00 738.34 10,200.00 6,911.66 67.8%Total-CM-UTILITIES1,060.98 865.00 195.98 3,348.44 2,595.00 753.44 10,380.00 7,031.56 67.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6319100 Contract Svcs-Soil/Tissue Test2,000.00 2,000.00 - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal752.46 524.00 228.46 2,257.38 1,572.00 685.38 6,288.00 4,030.62 64.1%6319150 Dues & Subscriptions210.00 - 210.00 345.00 - 345.00 540.00 195.00 36.1%6319170 Employee Education- 50.00 (50.00) - 150.00 (150.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 150.00 (150.00) 178.87 500.00 (321.13) 3,400.00 3,221.13 94.7%6319206 Licenses & Permits223.89 80.00 143.89 223.89 280.00 (56.11) 4,180.00 3,956.11 94.6%6319490 Miscellaneous307.79 100.00 207.79 307.79 300.00 7.79 1,200.00 892.21 74.4%6319718 Safety Equipment & Training650.50 750.00 (99.50) 916.72 1,050.00 (133.28) 3,850.00 2,933.28 76.2%6319822 Uniforms809.87 920.00 (110.13) 2,368.99 2,760.00 (391.01) 11,040.00 8,671.01 78.5%Total-CM-OTHER EXPENSES5,454.51 5,074.00 380.51 10,098.64 10,112.00 (13.36) 42,048.00 31,949.36 76.0%SilverRock ResortCourse Maintenance Expense StatementSeptember 2015Annual BudgetMonth to DateYear to Date5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,979.35 2,728.00 (748.65) 5,906.80 8,184.00 (2,277.20) 32,736.00 26,829.20 82.0%6321325 Insurance-Workers Comp507.18 507.00 0.18 1,740.22 1,473.00 267.22 6,171.00 4,430.78 71.8%6321800 Taxes-Employer Payroll1,058.64 1,938.00 (879.36) 3,186.80 5,544.00 (2,357.20) 23,334.00 20,147.20 86.3%6321880 Wages-Hourly13,196.20 12,880.00 316.20 38,228.76 38,640.00 (411.24) 160,320.00 122,091.24 76.2%6321882 Wages-Overtime- 966.00 (966.00) - 966.00 (966.00) 6,351.00 6,351.00 100.0%Total-CM-LM-SALARIES & BENEFITS16,741.37 19,019.00 (2,277.63) 49,062.58 54,807.00 (5,744.42) 228,912.00 179,849.42 78.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0%6323788 Uniforms102.85 290.00 (187.15) 427.48 870.00 (442.52) 3,480.00 3,052.52 87.7%Total-CM-LM-SUPPLIES & MATERIALS102.85 390.00 (287.15) 427.48 1,170.00 (742.52) 4,505.00 4,077.52 90.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%131,353.02 143,399.00 (12,045.98) 381,431.82 391,917.00 (10,485.18) 1,712,795.00 1,331,363.18 77.7% September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 14,863.27 13,815.00 1,048.27 44,561.47 40,900.00 3,661.47 179,791.00 135,229.53 75.2%6337842 Utilities-Water7,436.14 6,160.00 1,276.14 19,852.40 19,360.00 492.40 45,338.00 25,485.60 56.2%22,299.41 19,975.00 2,324.41 64,413.87 60,260.00 4,153.87 225,129.00 160,715.13 71.4%Silverrock ResortCourse Maintenance Water & EnergySeptember 2015Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementSeptember 2015Silverrock ResortAnnual BudgetMonth to DateYear to Date6 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 2,046.00 (2,046.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp307.05 301.00 6.05 1,105.99 774.00 331.99 5,229.00 4,123.01 78.8%6411800 Taxes-Employer Payroll1,026.32 1,000.00 26.32 2,543.86 2,571.00 (27.14) 17,360.00 14,816.14 85.3%6411880 Wages-Hourly8,630.75 8,033.00 597.75 22,452.18 20,656.00 1,796.18 139,434.00 116,981.82 83.9%6411882 Wages-Overtime 20.26 - 20.26 229.55 - 229.55 - (229.55) 0.0%Total-CBR-SALARIES & BENEFITS9,984.38 10,016.00 (31.62) 26,331.58 26,047.00 284.58 170,207.00 143,875.42 84.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts651.72 - 651.72 1,955.16 - 1,955.16 1,850.00 `0.0%6413742 Supplies-Expendable449.28 150.00 299.28 1,629.16 1,350.00 279.16 6,750.00 5,120.84 75.9%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 100.00 (100.00) 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) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 80.00 120.00 (40.00) 800.00 360.00 440.00 2,182.00 1,382.00 63.3%6413796 Supplies-Bottled Water108.00 50.00 58.00 216.00 3,600.00 (3,384.00) 11,000.00 10,784.00 98.0%Total-CBR-SUPPLIES & MATERIALS1,289.00 445.00 844.00 4,600.32 5,485.00 (884.68) 34,727.00 30,231.84 87.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) - 900.00 (900.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair 1,437.72 500.00 937.72 1,672.72 1,500.00 172.72 6,450.00 4,777.28 74.1%Total-CBR-REPAIRS & MAINTENANCE1,437.72 800.00 637.72 1,672.72 2,400.00 (727.28) 10,050.00 8,377.28 83.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen149.98 800.00 (650.02) 1,331.36 2,400.00 (1,068.64) 9,600.00 8,268.64 86.1%6419220 Freight/Delivery- 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0%6419490 Miscellaneous760.25 600.00 160.25 1,941.78 1,800.00 141.78 7,200.00 5,258.22 73.0%6419820 Uniforms - - - 98.29 - 98.29 5,200.00 5,101.71 98.1%Total-CBR-OTHER EXPENSES910.23 1,475.00 (564.77) 3,371.43 4,425.00 (1,053.57) 22,450.00 19,078.57 85.0%TOTAL-CARTS,BAGROOM & RANGE13,621.33 12,736.00 (564.77) 35,976.05 38,357.00 (2,380.95) 237,434.00 201,563.11 84.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp121.05 119.00 2.05 513.79 317.00 196.79 2,179.00 1,665.21 76.4%6431800 Taxes-Employer Payroll319.21 445.00 (125.79) 1,119.04 1,183.00 (63.96) 8,135.00 7,015.96 86.2%6431880 Wages-Hourly3,105.00 3,179.00 (74.00) 9,992.50 8,457.00 1,535.50 58,108.00 48,115.50 82.8%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,545.26 3,743.00 (197.74) 11,625.33 9,957.00 1,668.33 68,422.00 56,796.67 83.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 200.00 (200.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous613.81 - 613.81 697.20 - 697.20 200.00 (497.20) -248.6%6439718 Safety Equipment & Training- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES613.81 225.00 388.81 697.20 575.00 122.20 3,975.00 3,277.80 82.5%Total-COURSE SERVICES4,159.07 3,968.00 191.07 12,322.53 10,532.00 1,790.53 72,397.00 60,074.47 83.0%17,780.40 16,704.00 1,076.40 48,298.58 48,889.00 (590.42) 309,831.00 258,359.78 83.4%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementSeptember 2015Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 405.00 400.00 5.00 1,205.00 1,200.00 5.00 4,800.00 3,595.00 74.9%Total-CH-SUPPLIES & MATERIALS405.00 400.00 5.00 1,205.00 1,200.00 5.00 4,800.00 3,595.00 74.9%65-CH-UTILITIES6507836 Utilities-Natural Gas263.83 300.00 (36.17) 956.67 900.00 56.67 3,600.00 2,643.33 73.4%6507840 Utilities-Telephone1,443.22 1,150.00 293.22 1,986.01 3,450.00 (1,463.99) 13,800.00 11,813.99 85.6%6507842 Utilities-Water629.45 321.00 308.45 1,604.00 963.00 641.00 3,852.00 2,248.00 58.4%6507844 Utilities-Cable481.41 340.00 141.41 1,444.23 1,020.00 424.23 4,080.00 2,635.77 64.6%Total-CH-UTILITIES2,817.91 2,111.00 706.91 5,990.91 6,333.00 (342.09) 25,332.00 19,341.09 76.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,945.00 1,825.00 120.00 5,595.00 5,475.00 120.00 22,500.00 16,905.00 75.1%6509099 Contract Services-Security5,547.12 4,900.00 647.12 15,800.40 14,700.00 1,100.40 60,400.00 44,599.60 73.8%6509215 Flowers & Decorations- - - 57.56 - 57.56 1,900.00 1,842.44 97.0%6509490 Miscellaneous69.99 200.00 (130.01) 69.99 600.00 (530.01) 7,000.00 6,930.01 99.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,562.11 7,025.00 537.11 21,522.95 21,075.00 447.95 93,000.00 71,477.05 76.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures463.50 300.00 163.50 1,243.86 900.00 343.86 3,600.00 2,356.14 65.4%6515686 CH-R&M-Restaurant Repairs175.00 400.00 (225.00) 595.00 1,200.00 (605.00) 4,800.00 4,205.00 87.6%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 994.33 1,200.00 (205.67) 4,800.00 3,805.67 79.3%Total-CH-REPAIRS & MAINTENANCE638.50 1,100.00 (461.50) 2,833.19 3,300.00 (466.81) 13,200.00 10,366.81 78.5%11,423.52 10,636.00 787.52 31,552.05 31,908.00 (355.95) 136,332.00 20,733.62 15.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementSeptember 2015Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 387.21 341.00 46.21 1,045.21 1,023.00 22.21 4,092.00 3,046.79 74.5%6601325 Insurance-Workers Comp108.00 94.00 14.00 495.00 282.00 213.00 1,129.00 634.00 56.2%6601720 Salaries2,608.70 2,508.00 100.70 6,218.10 7,524.00 (1,305.90) 30,096.00 23,877.90 79.3%6601800 Taxes-Employer Payroll361.12 351.00 10.12 652.56 1,053.00 (400.44) 4,213.00 3,560.44 84.5%Total-MKT-SALARIES & BENEFITS3,465.03 3,294.00 171.03 8,410.87 9,882.00 (1,471.13) 39,530.00 31,119.13 78.7%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 289.75 300.00 (10.25) 1,200.00 910.25 75.9%6603768 Supplies-Printing & Stationery 270.41 200.00 70.41 884.27 200.00 684.27 4,425.00 3,540.73 80.0%270.41 300.00 (29.59) 1,174.02 500.00 674.02 5,625.00 4,450.98 79.1%66-MKT-UTILITIES6607840 Utilities-Telephone 63.08 100.00 (36.92) 184.24 300.00 (115.76) 1,200.00 1,015.76 84.6%Total-MKT-UTILITIES63.08 100.00 (36.92) 184.24 300.00 (115.76) 1,200.00 1,015.76 84.6%66-MKT-OTHER EXPENSES6609010 Advertising 20,514.58 17,197.00 3,317.58 35,327.19 26,687.00 8,640.19 178,987.00 143,659.81 80.3%6609040 Business Meals- - - - - - 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) 99.00 450.00 (351.00) 1,800.00 1,701.00 94.5%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6609630 Promotion- 25.00 (25.00) - 75.00 (75.00) 700.00 700.00 100.0%6609633 Promotion-Community76.50 75.00 1.50 76.50 225.00 (148.50) 2,250.00 2,173.50 96.6%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms81.52 - 81.52 81.52 - 81.52 600.00 518.48 86.4%Total-MKT-OTHER EXPENSES20,672.60 17,497.00 3,175.60 35,584.21 27,587.00 7,997.21 193,822.00 158,237.79 81.6%24,471.12 21,191.00 3,280.12 45,353.34 38,269.00 7,084.34 240,177.00 194,823.66 81.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementSeptember 2015Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group980.63 1,488.00 (507.37) 3,746.28 4,464.00 (717.72) 17,856.00 14,109.72 79.0%6701325 Insurance-Workers Comp601.10 594.00 7.10 2,241.58 1,805.00 436.58 7,717.00 5,475.42 71.0%6701720 Salaries13,445.00 13,438.00 7.00 40,622.00 40,314.00 308.00 177,996.00 137,374.00 77.2%6701800 Taxes-Employer Payroll2,050.52 2,219.00 (168.48) 4,428.58 6,741.00 (2,312.42) 28,812.00 24,383.42 84.6%6701880 Wages-Hourly1,807.00 2,412.00 (605.00) 7,196.00 7,836.00 (640.00) 27,800.00 20,604.00 74.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS18,884.25 20,151.00 (1,266.75) 58,234.44 61,160.00 (2,925.56) 260,181.00 201,946.56 77.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 331.46 1,500.00 (1,168.54) 6,300.00 5,968.54 94.7%6703762 Supplies-Office171.00 150.00 21.00 432.54 450.00 (17.46) 1,800.00 1,367.46 76.0%6703768 Supplies-Printing & Stationery70.68 100.00 (29.32) 184.68 300.00 (115.32) 3,300.00 3,115.32 94.4%Total-G&A-SUPPLIES & MATERIALS241.68 750.00 (508.32) 948.68 2,250.00 (1,301.32) 11,400.00 10,451.32 91.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6709150 Dues & Subscriptions- 200.00 (200.00) - 250.00 (250.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 60.00 200.00 (140.00) 1,400.00 1,340.00 95.7%6709197 Equipment Rental449.86 550.00 (100.14) 1,594.45 1,650.00 (55.55) 6,600.00 5,005.55 75.8%6709202 Fees-Bank136.27 90.00 46.27 397.00 270.00 127.00 1,080.00 683.00 63.2%6709208 Fees-Payroll Processing1,269.73 1,200.00 69.73 3,427.43 3,600.00 (172.57) 14,400.00 10,972.57 76.2%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous38.78 100.00 (61.22) 38.78 300.00 (261.22) 1,200.00 1,161.22 96.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services165.30 75.00 90.30 209.59 225.00 (15.41) 900.00 690.41 76.7%6709625 Professional Fees1,630.50 850.00 780.50 3,335.50 2,550.00 785.50 10,200.00 6,864.50 67.3%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms38.62 75.00 900.00 38.62 225.00 (186.38) 1,050.00 1,011.38 96.3%Total-G&A-OTHER EXPENSES4,129.06 4,090.00 975.44 10,301.37 11,620.00 (1,318.63) 54,030.00 43,728.63 80.9%23,254.99 25,091.00 (1,836.01) 69,484.49 75,230.00 (5,745.51) 327,511.00 258,026.51 78.8%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2015Annual Budget10 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 31,090.35 30,150.00 940.35 121,050.00 89,959.65 74.3%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 16,714.50 18,150.00 (1,435.50) 72,600.00 55,885.50 77.0%6800194 Equipment Leases-Trailer512.61 600.00 (87.39) 1,285.22 1,800.00 (514.78) 7,200.00 5,914.78 82.1%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 13,500.00 14,100.00 (600.00) 56,400.00 42,900.00 76.1%6800197 Equipment Leases-Others1,686.21 1,150.00 536.21 4,344.42 3,450.00 894.42 13,800.00 9,455.58 0.0%22,633.77 22,550.00 83.77 66,934.49 67,650.00 (715.51) 271,050.00 204,115.51 75.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 24,960.00 24,960.00 - 99,840.00 74,880.00 75.0%6900210 FF&E Reserve2,564.71 2,637.00 (72.29) 5,648.10 5,666.00 (17.90) 63,985.00 58,336.90 91.2%6900800 Personal Property Taxes5,493.41 4,000.00 1,493.41 12,117.83 9,200.00 2,917.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial- 2,200.00 (2,200.00) 5,778.32 6,600.00 (821.68) 26,400.00 20,621.68 78.1%16,378.12 17,157.00 (778.88) 48,504.25 46,426.00 2,078.25 202,025.00 153,520.75 76.0%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2015Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐20162015 2015 2015 2015 2015 2015Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia24SalesPromotionGolf IndustryVIPCelebrityPGA Comp383738Charity/Gift Certificate7Rain/Wind Checks121Club Staff956280LQ HS Golf211718168 121 1430002016 2016 2016 2016 2016 2016Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012