Loading...
04 October 2017 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2017 – October 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 OctoberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue18,254.30 11,841.00 6,413.30 54.2% 98,783.30 104,544.00 (5,760.70) 2,964,060.00 2,865,276.70 3%401000 Miscellaneous Golf Revenue5,172.00 9,229.00 (4,057.00) -44.0% 21,359.00 17,285.00 4,074.00 166,766.00 145,407.00 13%410000 Revenue-Golf Shop4,062.92 2,500.00 1,562.92 62.5% 16,377.04 16,263.00 114.04 262,017.00 245,639.96 6%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income- - - - - - - - 0%Total Income28,989.22 25,070.00 3,919.22 15.6% 139,519.34 141,092.00 (1,572.66) 3,404,843.00 3,265,323.66 4%Cost of Goods Sold510000 COS-Golf Shop2,743.30 1,399.00 1,344.30 -96.1% 10,152.61 9,102.54 (1,050.07) 146,651.00 136,498.39 7%Total COS2,743.30 1,399.00 1,344.30 -96.1% 10,152.61 9,102.54 (1,050.07) 146,651.00 136,498.39 7%Gross Profit26,245.92 23,671.00 2,574.92 10.9% 129,366.73 131,989.46 (2,622.73) 3,258,192.00 3,128,825.27 4%Expenses610000 Golf Pro Shop 11,452.54 11,529.00 (76.46) 0.7% 53,386.09 49,488.00 3,898.09 199,990.00 146,603.91 27%630000 Course Maintenance267,241.45 308,333.00 (41,091.55) 13.3% 620,433.34 688,874.00 (68,440.66) 1,735,790.00 1,115,356.66 36%633000 Maintenance Water & Energy21,733.13 18,240.00 3,493.13 -19.2% 83,529.04 87,212.00 (3,682.96) 249,838.00 166,308.96 33%640000 Outside Services25,776.40 17,506.00 8,270.40 -47.2% 83,899.22 71,804.00 12,095.22 331,964.00 248,064.78 25%650000 Clubhouse12,065.93 11,876.00 189.93 -1.6% 43,245.81 44,204.00 (958.19) 136,412.00 93,166.19 32%660000 Marketing11,334.43 20,948.00 (9,613.57) 45.9% 51,281.76 50,663.00 618.76 230,960.00 179,678.24 22%670000 General & Administrative23,038.41 25,870.00 (2,831.59) 10.9% 91,018.33 101,651.00 (10,632.67) 329,053.00 238,034.67 28%680000 Leases25,233.84 23,000.00 2,233.84 -9.7% 101,979.47 90,650.00 11,329.47 321,050.00 219,070.53 32%690000 Miscellaneous Other Expense11,286.76 14,536.00 (3,249.24) 22.4% 63,034.09 60,687.00 2,347.09 211,468.00 148,433.91 30%Total Expenses409,162.89 451,838.00 (42,675.11) 9.4% 1,191,807.15 1,245,233.00 53,425.85 3,746,525.00 2,554,717.85 32%(382,916.97) (428,167.00) 45,250.03 10.6%(1,062,440.42) (1,113,243.54) 50,803.12 (488,333.00) 574,107.42 0%Rounds of Golf PlayedPaid Rounds Played455 601 (146) -24.3%3,760 4,123 (363) 42,173 38,413 9%Ave $ Per Paid Round Green Fee40.12 19.70 20.42 103.6%26.27 25.36 0.92 70.28 44.01 37%Ave $ Per Paid Round Merchandise8.93 4.16 4.77 114.7%4.36 3.94 0.41 6.21 1.86 70%Ave $ Per Paid Miscellaneous 11.37 15.36 (3.99) -26.0%5.68 4.19 1.49 3.95 (1.73) 144%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateOctober 20171 Income OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees18,254.30 11,841.00 6,413.30 98,783.30 104,544.00 (5,760.70) 2,964,060.00 2,865,276.70 96.7%4010000 Rider Fee65.00 46.00 19.00 475.00 413.00 62.00 7,307.00 6,832.00 93.5%4040000 Club Rental520.00 228.00 292.00 1,980.00 2,063.00 (83.00) 21,087.00 19,107.00 90.6%4050000 Driving Range1,572.00 455.00 1,117.00 8,239.00 3,809.00 4,430.00 94,872.00 86,633.00 91.3%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- 1,000.00 (1,000.00) - 2,000.00 (2,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 Issue3,015.00 7,500.00 (4,485.00) 10,665.00 9,000.00 1,665.00 165,300.00 154,635.00 93.5% Total Revenue Fees23,426.30 21,070.00 2,356.30 120,142.30 121,829.00 (1,686.70) 3,296,126.00 3,175,983.70 96.4%23,426.30 21,070.00 2,356.30 120,142.30 121,829.00 (1,686.70) 3,296,126.00 3,175,983.70 96.4%SilverRock ResortStatement of Fees RevenueOctober 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$18,254.30 $11,841.00 6,413.30Favorable: Due to good weather and course conditions.ActualBudgetVariance$5,172.00$9,229.00(4,057.00)Unfavorable: Resident card issue down and awaiting check for ball retrieval.ActualBudgetVariance$4,062.92$2,500.001,562.92Favorable: Due to clearance of summer seasonal wear. This adversely affected our cost of sales.ExpensesActualBudgetVariance$267,241.45$308,333.00(41,091.55)Favorable: Due to back nine closed and had additional contracted labor to assist in the final preparations of the new holes.ActualBudgetVariance$25,776.40 $17,506.00 8,270.40Unfavorable: Due to timing of invoice for range balls.ActualBudgetVariance$11,334.43 $20,948.00 (9,613.57)Favorable: Due to reduced advertising expenses. This aligned us with year to date budget numbers.ActualBudgetVariance$23,038.41 $25,870.00 (2,831.59)Favorable: Due to less expenditures on line items to assist with reduced income of course.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$11,286.76 $14,536.00 (3,249.24)Favorable: Personal property tax was paid in September.Variance ExplanationOctober 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 areprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueGeneral and AdministrativeMarketingMiscellaneous Other ExpenseMaintenance Water and EnergyLeasesCourse MaintenanceOutside Services3-20-133 Income OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous168.69 - 168.69 1,019.79 - 1,019.79 00 0%4100110 Sales Hard Goods1,560.45 875.00 685.45 6,304.85 5,692.00 612.85 91,706.00 85,401.15 93.1%4100112 Sales-Soft Goods3,624.39 1,625.00 1,999.39 12,309.29 10,571.00 1,738.29 170,311.00 158,001.71 92.8%5100639 GS-Discounts-Mdse (1,290.61) - (1,290.61) (3,256.89) - (3,256.89) - 3,256.89 0.0% Total Revenue Golf Shop4,062.92 2,500.00 1,562.92 16,377.04 16,263.00 114.04 262,017.00 246,659.75 94.1%COS 5100150 COS-GS-Hard Goods 874.07 507.50 366.57 3,543.78 3,301.36 242.42 53,189.48 49,645.70 93.3%5100151 COS-GS-Soft Goods 1,471.28 942.50 528.78 5,555.02 6,131.18 (576.16) 97,137.52 91,582.50 94.3%5100152 COS-GS-Purchase Disc- (73.00) 73.00 (7.62) (472.00) 464.38 (7,598.00) (7,590.38) 99.9%5100220 COS-GS-Freight Merch 397.95 22.00 375.95 1,061.43 142.00 919.43 2,280.00 1,218.57 53.4%Cost of Sales - Golf Shop2,743.30 1,399.00 1,344.30 10,152.61 9,102.54 1,050.07 145,009.00 134,856.39 93.0%Gross Profit1,319.62 1,101.00 218.62 6,224.43 7,160.46 (936.03) 117,008.00 111,803.36 95.6%COS % 67.5% 56.0% -11.6% 62.0% 56.0% -6.0% 53.1% 54.7% 103.0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,807.00 2,088.00 (281.00) 7,521.52 7,308.00 213.52 26,796.00 19,274.48 71.9%6101325 Insurance-Workers Comp 244.50 256.00 (11.50) 2,306.34 1,201.00 1,105.34 4,957.00 2,650.66 53.5%6101720 Salaries4,000.00 4,001.00 (1.00) 16,000.00 16,004.00 (4.00) 45,000.00 29,000.00 64.4%6101800 Taxes-Employer Payroll 669.46 886.00 (216.54) 2,980.43 4,160.00 (1,179.57) 18,825.00 15,844.57 84.2%6101880 Wages-Hourly4,570.13 2,813.00 1,757.13 21,468.79 16,000.00 5,468.79 87,179.00 65,710.21 75.4%6101882 Wages-Overtime90.94 - 90.94 90.94 - 90.94 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 11,382.03 10,044.00 1,338.03 50,368.02 44,673.00 5,695.02 182,757.00 133,432.80 73.0%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office32.60 250.00 (217.40) 116.57 1,000.00 (883.43) 3,000.00 2,883.43 96.1%6109220 Freight & Delivery- 25.00 (25.00) 89.16 25.00 64.16 75.00 (14.16) -18.9%6109490 Miscellaneous- 500.00 (500.00) 1,000.00 2,000.00 (1,000.00) 6,000.00 5,000.00 83.3%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short- - - 153.20 - 153.20 - (153.20) 0.0%6109722 Seminars/Training- 500.00 (500.00) - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms- 100.00 (100.00) 1,068.57 400.00 668.57 2,400.00 1,331.43 55.5%6117840 Telephones37.91 110.00 (72.09) 590.57 440.00 150.57 1,320.00 729.43 55.3%70.51 1,485.00 (1,414.49) 3,018.07 4,815.00 (1,796.93) 18,875.00 15,856.93 84.0%11,452.54 11,529.00 (76.46) 53,386.09 49,488.00 3,898.09 201,632.00 149,289.73 74.0%Net Income(10,132.92) (10,428.00) 295.08 (47,161.66) (42,327.54) (4,834.12) (84,624.00) (37,486.37) 44.3%SilverRock ResortGolf Shop Income StatementOctober 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,823.15 7,425.00 398.15 29,968.16 29,700.00 268.16 103,020.00 73,051.84 70.9%6311325 Insurance-Workers Comp2,451.00 2,661.00 (210.00) 10,357.92 8,614.00 1,743.92 26,974.00 16,616.08 61.6%6311720 Salaries11,557.08 12,200.00 (642.92) 46,228.32 48,800.00 (2,571.68) 146,400.00 100,171.68 68.4%6311800 Taxes-Employer Payroll7,929.08 9,759.00 (1,829.92) 17,134.04 30,394.00 (13,259.96) 91,481.00 74,346.96 81.3%6311880 Wages-Hourly46,699.35 50,523.00 (3,823.65) 165,208.14 172,620.00 (7,411.86) 567,262.00 402,053.86 70.9%6311882 Wages-Overtime16,734.71 12,350.00 4,384.71 30,348.28 12,350.00 17,998.28 12,350.00 (17,998.28) -145.7%Total-CM-SALARIES & BENEFITS93,194.37 94,918.00 (1,723.63) 299,244.86 302,478.00 (3,233.14) 947,487.00 648,242.14 68.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,200.00 9,359.00 (6,159.00) 14,206.49 24,341.00 (10,134.51) 17,760.00 3,553.51 20.0%6313744 Fertilizer9,458.30 29,560.00 (20,101.70) 13,990.77 47,410.00 (33,419.23) 105,970.00 91,979.23 86.8%6313745 Herbicides4,303.69 - 4,303.69 4,738.57 - 4,738.57 25,518.00 20,779.43 81.4%6313746 Flowers/Plants1,650.42 250.00 1,400.42 1,650.42 1,250.00 400.42 3,050.00 1,399.58 45.9%6313748 Fuel-Gasoline4,735.90 5,270.00 (534.10) 11,987.95 16,400.00 (4,412.05) 48,950.00 36,962.05 75.5%6313750 Golf Course Accessories7,629.35 12,300.00 (4,670.65) 8,618.75 12,300.00 (3,681.25) 13,140.00 4,521.25 34.4%6313756 POA Control- - - - 2,400.00 (2,400.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp919.44 500.00 419.44 1,681.99 2,750.00 (1,068.01) 4,350.00 2,668.01 61.3%6313762 Supplies-Office18.00 - 18.00 54.00 - 54.00 - (54.00) 0.0%6313774 Sand- 2,000.00 (2,000.00) 2,250.01 7,780.00 (5,529.99) 13,460.00 11,209.99 83.3%6313776 Seed101,018.32 105,500.00 (4,481.68) 104,427.63 105,500.00 (1,072.37) 117,400.00 12,972.37 11.0%6313778 Small Tools & Non-Capital Equip99.72 2,000.00 (1,900.28) 143.99 4,200.00 (4,056.01) 5,000.00 4,856.01 97.1%6313780 Sod1,303.20 - 1,303.20 6,169.76 8,800.00 (2,630.24) 13,500.00 7,330.24 54.3%6313782 Topdressing1,498.32 2,200.00 (701.68) 6,473.47 4,400.00 2,073.47 10,000.00 3,526.53 35.3%Total-CM-SUPPLIES & MATERIALS135,834.66 168,939.00 (33,104.34) 176,393.80 237,531.00 (61,137.20) 387,998.00 211,604.20 54.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 14,264.24 11,320.00 2,944.24 33,960.00 19,695.76 58.0%6315685 CM-R&M-Bldngs & Othr Structures 305.31 500.00 (194.69) 2,036.66 3,050.00 (1,013.34) 5,550.00 3,513.34 63.3%6315690 CM-R&M-Equipment8,862.57 10,000.00 (1,137.43) 17,346.85 17,500.00 (153.15) 38,500.00 21,153.15 54.9%6315692 CM-R&M-Irrigation System2,754.36 2,000.00 754.36 11,155.25 11,400.00 (244.75) 19,050.00 7,894.75 41.4%6315696 CM-R&M-Pumps200.00 1,000.00 (800.00) 1,476.48 4,000.00 (2,523.52) 10,500.00 9,023.52 85.9%6315815 CM-R&M-Trees-Pruning Etc- 550.00 (550.00) 6,680.00 6,050.00 630.00 12,050.00 5,370.00 44.6%Total-CM-REPAIRS & MAINTENANCE15,962.24 16,880.00 (917.76) 52,959.48 53,320.00 (360.52) 119,610.00 66,650.52 55.7%6317836 Utilities-Natural Gas/LPG- 15.00 (15.00) 77.39 60.00 17.39 180.00 102.61 0.0%6317840 Telephones640.51 850.00 (209.49) 4,339.77 3,400.00 939.77 10,200.00 5,860.23 57.5%Total-CM-UTILITIES640.51 865.00 (224.49) 4,417.16 3,460.00 957.16 10,380.00 5,962.84 57.4%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6319100 Contract Svcs-Soil/Tissue Test- - - - 1,000.00 (1,000.00) 2,000.00 2,000.00 100.0%6319102 Contract Svcs-Trash Removal- 524.00 (524.00) - 2,096.00 (2,096.00) 6,288.00 6,288.00 100.0%6319150 Dues & Subscriptions- - - 210.00 - 210.00 680.00 470.00 69.1%6319170 Employee Education- 50.00 (50.00) - 200.00 (200.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 1,000.00 (1,000.00) 1,785.29 1,500.00 285.29 3,400.00 1,614.71 47.5%6319206 Licenses & Permits- 250.00 (250.00) 239.29 350.00 (110.71) 4,300.00 4,060.71 94.4%6319490 Miscellaneous- 100.00 (100.00) 53.37 400.00 (346.63) 1,200.00 1,146.63 95.6%6319718 Safety Equipment & Training718.30 800.00 (81.70) 718.30 1,850.00 (1,131.70) 3,850.00 3,131.70 81.3%6319822 Uniforms526.02 920.00 (393.98) 2,566.19 3,680.00 (1,113.81) 11,040.00 8,473.81 76.8%Total-CM-OTHER EXPENSES1,644.32 4,044.00 (2,399.68) 7,172.44 12,676.00 (5,503.56) 41,458.00 34,285.56 82.7%SilverRock ResortCourse Maintenance Expense StatementOctober 2017Annual BudgetMonth to DateYear to Date5 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,630.27 2,784.00 (153.73) 18,473.21 11,136.00 7,337.21 33,408.00 14,934.79 44.7%6321325 Insurance-Workers Comp 541.50 569.00 (27.50) 2,278.88 2,053.00 225.88 5,955.00 3,676.12 61.7%6321800 Taxes-Employer Payroll1,935.21 2,122.00 (186.79) 4,383.47 7,266.00 (2,882.53) 20,793.00 16,409.53 78.9%6321880 Wages-Hourly12,673.60 12,904.00 (230.40) 50,547.14 52,476.00 (1,928.86) 156,528.00 105,980.86 67.7%6321882 Wages-Overtime401.04 3,418.00 (3,016.96) 601.56 3,418.00 (2,816.44) 3,418.00 2,816.44 82.4%Total-CM-LM-SALARIES & BENEFITS18,181.62 21,797.00 (3,615.38) 76,284.26 76,349.00 (64.74) 220,102.00 143,817.74 65.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) 386.77 400.00 (13.23) 1,025.00 638.23 62.3%6323788 Uniforms92.44 290.00 (197.56) 360.87 1,160.00 (799.13) 3,480.00 3,119.13 89.6%Total-CM-LM-SUPPLIES & MATERIALS92.44 390.00 (297.56) 747.64 1,560.00 (812.36) 4,505.00 3,757.36 83.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 1,691.29 500.00 1,191.29 3,213.70 1,500.00 1,713.70 4,250.00 1,036.30 24.4%Total-CM-LM-REPAIRS & MAINTENANCE1,691.29 500.00 1,191.29 3,213.70 1,500.00 1,713.70 4,250.00 1,036.30 24.4%267,241.45 308,333.00 (41,091.55) 620,433.34 688,874.00 (68,440.66) 1,735,790.00 1,115,356.66 64.3% OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping12,015.96 12,150.00 (134.04) 46,679.71 53,050.00 (6,370.29) 179,791.00 133,111.29 74.0%6337842 Utilities-Water9,717.17 6,090.00 3,627.17 36,849.33 34,162.00 2,687.33 70,047.00 33,197.67 47.4%21,733.13 18,240.00 3,493.13 83,529.04 87,212.00 (3,682.96) 249,838.00 166,308.96 66.6%Silverrock ResortCourse Maintenance Water & EnergyOctober 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementOctober 2017Silverrock ResortAnnual BudgetMonth to Date Year to Date6 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 2,784.00 (2,784.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp251.00 258.00 (7.00) 2,796.16 1,125.00 1,671.16 5,623.00 2,826.84 50.3%6411800 Taxes-Employer Payroll740.59 855.00 (114.41) 2,296.50 3,736.00 (1,439.50) 18,667.00 16,370.50 87.7%6411880 Wages-Hourly6,343.27 6,868.00 (524.73) 26,998.91 30,010.00 (3,011.09) 149,934.00 122,935.09 82.0%6411882 Wages-Overtime47.26 - 47.26 72.39 - 72.39 - (72.39) 0.0%Total-CBR-SALARIES & BENEFITS7,382.12 8,677.00 (1,294.88) 32,163.96 37,655.00 (5,491.04) 182,576.00 150,412.04 82.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) - 500.00 (500.00) 1,850.00 `0.0%6413742 Supplies-Expendable227.29 150.00 77.29 1,416.17 1,500.00 (83.83) 6,750.00 5,333.83 79.0%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 200.00 (200.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls10,766.25 - 10,766.25 10,766.25 - 10,766.25 9,000.00 (1,766.25) -19.6%6413762 Supplies-Office- 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels- 120.00 (120.00) 880.00 480.00 400.00 2,182.00 1,302.00 59.7%6413796 Supplies-Bottled Water107.75 100.00 7.75 431.00 4,700.00 (4,269.00) 12,900.00 12,469.00 96.7%Total-CBR-SUPPLIES & MATERIALS11,101.29 1,020.00 10,081.29 13,493.42 7,505.00 5,988.42 36,627.00 21,283.58 58.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 723.00 300.00 423.00 17,874.68 1,200.00 16,674.68 3,600.00 (14,274.68) -396.5%6415695 CBR-R&M-Cart Maintenance & Repair- 950.00 (950.00) 500.00 2,450.00 (1,950.00) 6,450.00 5,950.00 92.2%Total-CBR-REPAIRS & MAINTENANCE723.00 1,250.00 (527.00) 18,374.68 3,650.00 14,724.68 10,050.00 (8,324.68) -82.8%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen- 800.00 (800.00) 1,883.87 3,200.00 (1,316.13) 9,600.00 7,716.13 80.4%6419220 Freight/Delivery- 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 550.91 2,400.00 (1,849.09) 7,200.00 6,649.09 92.3%6419820 Uniforms- 2,000.00 (2,000.00) - 2,000.00 (2,000.00) 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES- 3,475.00 (3,475.00) 2,434.78 7,900.00 (5,465.22) 22,450.00 20,015.22 89.2%TOTAL-CARTS,BAGROOM & RANGE 19,206.41 14,422.00 (3,475.00) 66,466.84 56,710.00 9,756.84 251,703.00 183,386.16 72.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp64.50 67.00 (2.50) 1,682.86 433.00 1,249.86 2,450.00 767.14 31.3%6431800 Taxes-Employer Payroll242.82 232.00 10.82 947.65 1,505.00 (557.35) 8,494.00 7,546.35 88.8%6431880 Wages-Hourly2,674.89 1,785.00 889.89 11,214.09 11,581.00 (366.91) 65,341.00 54,126.91 82.8%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,982.21 2,084.00 898.21 13,844.60 13,519.00 325.60 76,285.00 62,440.40 81.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 300.00 (300.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms3,587.78 800.00 2,787.78 3,587.78 1,025.00 2,562.78 2,125.00 (1,462.78) -68.8%Total-CS-OTHER EXPENSES3,587.78 1,000.00 2,587.78 3,587.78 1,575.00 2,012.78 3,975.00 387.22 9.7%Total-COURSE SERVICES6,569.99 3,084.00 3,485.99 17,432.38 15,094.00 2,338.38 80,260.00 62,827.62 78.3%25,776.40 17,506.00 8,270.40 83,899.22 71,804.00 12,095.22 331,963.00 245,826.56 74.1%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementOctober 2017Annual Budget7 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%65-CH-UTILITIES6507836 Utilities-Natural Gas387.08 300.00 87.08 1,284.33 1,200.00 84.33 3,600.00 2,315.67 64.3%6507840 Utilities-Telephone1,103.06 1,150.00 (46.94) 3,249.65 4,600.00 (1,350.35) 13,800.00 10,550.35 76.5%6507842 Utilities-Water420.04 321.00 99.04 1,616.41 1,284.00 332.41 3,852.00 2,235.59 58.0%6507844 Utilities-Cable 494.41 380.00 114.41 1,969.82 1,520.00 449.82 4,560.00 2,590.18 56.8%Total-CH-UTILITIES2,404.59 2,151.00 253.59 8,120.21 8,604.00 (483.79) 25,812.00 17,691.79 68.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 2,425.00 (600.00) 7,410.00 7,900.00 (490.00) 22,500.00 15,090.00 67.1%6509099 Contract Services-Security5,224.72 5,000.00 224.72 21,214.54 20,000.00 1,214.54 60,000.00 38,785.46 64.6%6509215 Flowers & Decorations- 500.00 (500.00) - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 800.00 (800.00) 7,000.00 7,000.00 100.0%6509718 Safety Equipment & Training - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,049.72 8,225.00 (1,175.28) 28,624.54 29,600.00 (975.46) 92,600.00 63,975.46 69.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,079.02 300.00 779.02 3,768.46 1,200.00 2,568.46 3,600.00 (168.46) -4.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair 1,132.60 400.00 732.60 1,132.60 1,600.00 (467.40) 4,800.00 3,667.40 76.4%Total-CH-REPAIRS & MAINTENANCE2,211.62 1,100.00 1,111.62 4,901.06 4,400.00 501.06 13,200.00 8,298.94 62.9%12,065.93 11,876.00 189.93 43,245.81 44,204.00 (958.19) 136,412.00 16,597.88 12.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementOctober 2017Annual Budget8 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 351.02 348.00 3.02 1,752.08 1,392.00 360.08 4,176.00 2,423.92 58.0%6601325 Insurance-Workers Comp87.20 94.00 (6.80) 385.20 376.00 9.20 1,129.00 743.80 65.9%6601720 Salaries1,904.96 2,508.00 (603.04) 7,619.84 10,032.00 (2,412.16) 30,096.00 22,476.16 74.7%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 580.80 1,304.00 (723.20) 3,912.00 3,331.20 85.2%Total-MKT-SALARIES & BENEFITS2,488.38 3,276.00 (787.62) 10,337.92 13,104.00 (2,766.08) 39,313.00 28,975.08 73.7%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office128.34 100.00 28.34 460.51 400.00 60.51 1,200.00 739.49 61.6%6603768 Supplies-Printing & Stationery454.67 3,000.00 (2,545.33) 1,428.48 3,200.00 (1,771.52) 4,425.00 2,996.52 67.7%583.01 3,100.00 (2,516.99) 1,888.99 3,600.00 (1,711.01) 5,625.00 3,736.01 66.4%66-MKT-UTILITIES6607840 Utilities-Telephone150.50 100.00 50.50 534.38 400.00 134.38 1,200.00 665.62 55.5%Total-MKT-UTILITIES150.50 100.00 50.50 534.38 400.00 134.38 1,200.00 665.62 55.5%66-MKT-OTHER EXPENSES6609010 Advertising 8,013.54 13,322.00 (5,308.46) 35,673.29 31,509.00 4,164.29 169,987.00 134,313.71 79.0%6609040 Business Meals- 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material- 500.00 (500.00) - 500.00 (500.00) 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page99.00 150.00 (51.00) 297.00 600.00 (303.00) 1,800.00 1,503.00 83.5%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 2,064.31 50.00 2,014.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community- 75.00 (75.00) 485.87 300.00 185.87 2,250.00 1,764.13 78.4%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES8,112.54 14,472.00 (6,359.46) 38,520.47 33,559.00 4,961.47 184,822.00 146,301.53 79.2%11,334.43 20,948.00 (9,613.57) 51,281.76 50,663.00 618.76 230,960.00 179,678.24 77.8%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementOctober 2017Annual Budget9 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,638.57 1,509.00 129.57 6,832.29 6,036.00 796.29 18,108.00 11,275.71 62.3%6701325 Insurance-Workers Comp628.50 632.00 (3.50) 2,483.88 2,484.00 (0.12) 7,905.00 5,421.12 68.6%6701720 Salaries12,800.00 13,850.00 (1,050.00) 51,200.00 55,400.00 (4,200.00) 177,996.00 126,796.00 71.2%6701800 Taxes-Employer Payroll1,135.90 2,193.00 (1,057.10) 4,595.08 8,616.00 (4,020.92) 32,800.00 28,204.92 86.0%6701880 Wages-Hourly2,048.44 3,016.00 (967.56) 8,866.48 10,860.00 (1,993.52) 27,404.00 18,537.52 67.6%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS18,251.41 21,200.00 (2,948.59) 73,977.73 83,396.00 (9,418.27) 264,213.00 190,235.27 72.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 2,419.07 2,000.00 419.07 6,300.00 3,880.93 61.6%6703762 Supplies-Office36.68 105.00 (68.32) 95.13 420.00 (324.87) 1,260.00 1,164.87 92.5%6703768 Supplies-Printing & Stationery759.35 100.00 659.35 759.35 400.00 359.35 3,300.00 2,540.65 77.0%Total-G&A-SUPPLIES & MATERIALS796.03 705.00 91.03 3,273.55 2,820.00 453.55 10,860.00 7,586.45 69.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 300.00 (300.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 300.00 (300.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) 420.00 300.00 120.00 1,150.00 730.00 63.5%6709180 Employee Recruiting/Relocation30.00 150.00 (120.00) 251.95 300.00 (48.05) 1,200.00 948.05 79.0%6709197 Equipment Rental491.98 550.00 (58.02) 2,232.79 2,200.00 32.79 6,600.00 4,367.21 66.2%6709202 Fees-Bank173.40 90.00 83.40 548.48 360.00 188.48 1,080.00 531.52 49.2%6709208 Fees-Payroll Processing312.40 1,000.00 (687.60) 2,509.38 4,000.00 (1,490.62) 12,000.00 9,490.62 79.1%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous12.94 100.00 (87.06) 157.32 400.00 (242.68) 6,600.00 6,442.68 97.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services158.99 75.00 83.99 531.59 300.00 231.59 900.00 368.41 40.9%6709625 Professional Fees1,403.00 850.00 553.00 3,672.10 3,400.00 272.10 10,200.00 6,527.90 64.0%6709636 Promotion/Entertainment138.18 100.00 38.18 138.18 400.00 (261.82) 1,200.00 1,061.82 88.5%6709722 Seminars & Training770.08 200.00 570.08 1,020.08 800.00 220.08 2,400.00 1,379.92 57.5%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 150.00 900.00 285.18 375.00 (89.82) 1,050.00 764.82 72.8%Total-G&A-OTHER EXPENSES3,990.97 3,865.00 1,175.97 13,767.05 15,135.00 (1,367.95) 52,080.00 38,312.95 73.6%23,038.41 25,870.00 (2,831.59) 91,018.33 101,651.00 (10,632.67) 329,053.00 238,034.67 72.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2017Annual Budget10 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 9,829.27 10,500.00 (670.73) 39,317.08 40,650.00 (1,332.92) 121,050.00 81,732.92 67.5%6800193 Equipment Leases-Maintenance 9,181.20 6,050.00 3,131.20 36,724.80 24,200.00 12,524.80 116,200.00 79,475.20 68.4%6800194 Equipment Leases-Trailer323.07 600.00 (276.93) 2,225.60 2,400.00 (174.40) 7,200.00 4,974.40 69.1%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 15,480.00 18,800.00 (3,320.00) 56,400.00 40,920.00 72.6%6800197 Equipment Leases-Others2,030.30 1,150.00 880.30 8,231.99 4,600.00 3,631.99 20,200.00 11,968.01 0.0%25,233.84 23,000.00 2,233.84 101,979.47 90,650.00 11,329.47 321,050.00 219,070.53 68.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,999.00 (346.20) 35,111.20 35,996.00 (884.80) 107,987.00 72,875.80 67.5%6900210 FF&E Reserve365.09 237.00 128.09 1,975.68 2,091.00 (115.32) 59,281.00 57,305.32 96.7%6900800 Personal Property Taxes- 2,600.00 (2,600.00) 15,095.97 11,800.00 3,295.97 11,800.00 (3,295.97) -27.9%6900323 Insurance-Commercial2,268.87 2,700.00 (431.13) 10,851.24 10,800.00 51.24 32,400.00 21,548.76 66.5%11,286.76 14,536.00 (3,249.24) 63,034.09 60,687.00 2,347.09 211,468.00 148,433.91 70.2%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 2017Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-20182017 2017 2017 2017 2017 2017Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp20 12 27Charity/Gift Certificate22Rain/Wind ChecksClub Staff53 38 65 16LQ HS Golf1066385 58 98 19002018 2018 2018 2018 2018 2018Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-2018October 2017 Date TimeDescriptionCategoryPlayers13