Loading...
04 October 2015 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2015 – October 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 October Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue33,187.00 18,500.00 14,687.00 79.4% 315,591.75 301,773.00 13,818.75 3,199,237.00 2,883,645.25 10%401000 Miscellaneous Golf Revenue8,475.00 9,400.00 (925.00) -9.8% 39,511.50 30,015.00 9,496.50 349,259.00 309,747.50 11%410000 Revenue-Golf Shop4,126.44 2,500.00 1,626.44 65.1% 31,356.14 32,836.00 (1,479.86) 278,585.00 247,228.86 11%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 Income2.25 - 2.25 8.18 - 8.18 - (8.18) 0%Total Income47,290.69 31,900.00 15,390.69 48.2% 389,467.57 367,624.00 21,843.57 3,839,081.00 3,449,613.43 10%Cost of Goods Sold510000 COS-Golf Shop2,283.90 1,399.00 884.90 -63.3% 18,083.96 18,377.88 293.92 155,924.00 137,840.04 12%Total COS2,283.90 1,399.00 884.90 -63.3% 18,083.96 18,377.88 293.92 155,924.00 137,840.04 12%Gross Profit45,006.79 30,501.00 14,505.79 47.6% 371,383.61 349,246.12 22,137.49 3,683,157.00 3,311,773.39 10%Expenses610000 Golf Pro Shop 11,541.44 12,376.00 (834.56) 6.7% 51,017.43 53,715.00 (2,697.57) 204,827.00 153,809.57 25%630000 Course Maintenance282,474.98 280,814.00 1,660.98 -0.6% 663,906.80 672,731.00 (8,824.20) 1,712,795.00 1,048,888.20 39%633000 Maintenance Water & Energy17,748.90 16,350.00 1,398.90 -8.6% 82,162.77 76,610.00 5,552.77 225,129.00 142,966.23 36%640000 Outside Services17,646.63 16,231.00 1,415.63 -8.7% 65,945.21 65,120.00 825.21 309,830.00 243,884.79 21%650000 Clubhouse12,326.35 11,736.00 590.35 -5.0% 43,878.40 43,644.00 234.40 136,332.00 92,453.60 32%660000 Marketing15,534.17 21,466.00 (5,931.83) 27.6% 60,887.51 59,735.00 1,152.51 240,177.00 179,289.49 25%670000 General & Administrative24,962.07 25,123.00 (160.93) 0.6% 94,446.56 100,353.00 (5,906.44) 327,511.00 233,064.44 29%680000 Leases21,973.09 22,550.00 (576.91) 2.6% 88,907.58 90,200.00 (1,292.42) 271,050.00 182,142.42 33%690000 Miscellaneous Other Expense14,068.01 13,490.00 578.01 -4.3% 62,572.26 59,916.00 2,656.26 202,025.00 139,452.74 31%Total Expenses418,275.64 420,136.00 (1,860.36) 0.4% 1,213,724.52 1,222,024.00 8,299.48 3,629,676.00 2,415,951.48 33%(373,268.85) (389,635.00) 16,366.15 4.2%(842,340.91) (872,777.88) 30,436.97 53,481.00 895,821.91 0%Rounds of Golf PlayedPaid Rounds Played566 500 66 13.2%8,137 8,425 (288) 41,100 32,963 20%Ave $ Per Paid Round Green Fee58.63 37.00 21.63 58.5%38.78 35.82 2.97 77.84 39.06 50%Ave $ Per Paid Round Merchandise7.29 5.00 2.29 45.8%3.85 3.90 (0.04) 6.78 2.92 57%Ave $ Per Paid Miscellaneous 14.97 18.80 (3.83) -20.4%4.86 3.56 1.29 8.50 3.64 57%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateOctober 20151 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees33,187.00 18,500.00 14,687.00 315,591.75 301,773.00 13,818.75 3,199,237.00 2,883,645.25 90.1%4010000 Rider Fee150.00 50.00 100.00 2,082.50 843.00 1,239.50 7,738.00 5,655.50 73.1%4040000 Club Rental545.00 250.00 295.00 2,935.00 4,213.00 (1,278.00) 23,238.00 20,303.00 87.4%4050000 Driving Range730.00 500.00 230.00 10,050.00 7,659.00 2,391.00 100,984.00 90,934.00 90.0%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 400.00 (400.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract - 1,000.00 (1,000.00) 894.00 2,000.00 (1,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,050.00 7,500.00 (450.00) 23,550.00 14,900.00 8,650.00 171,200.00 147,650.00 86.2% Total Revenue Fees41,662.00 27,900.00 13,762.00 355,103.25 331,788.00 23,315.25 3,548,497.00 3,193,393.75 90.0%41,662.00 27,900.00 13,762.00 355,103.25 331,788.00 23,315.25 3,548,497.00 3,193,393.75 90.0%SilverRock ResortStatement of Fees RevenueOctober 2015Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$33,187.00$18,500.0014,687.00Favorable: Due to timing of payments for GolfNow and UnderPar.ActualBudgetVariance4,126.44$ 2,500.00$ 1,626.44Favorable: Due to sale items we discounted prior to closing for overseeding.ExpensesActualBudgetVariance$15,534.17$21,466.00(5,931.83)Favorable: Due to not utilizing line item Supplies Printing and Stationery. Normally we use the budgeted amount for scorecards, rack rates and resident information cards. Currently, we have a sufficient supply.Pro Shop Merchandise SalesGolf Green Fee Revenueprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationOctober 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 areMarketing3-20-133 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous133.50 - 133.50 500.61 - 500.61 00 0%4100110 Sales Hard Goods2,195.59 875.00 1,320.59 15,822.86 11,493.00 4,329.86 97,505.00 81,682.14 83.8%4100112 Sales-Soft Goods2,205.50 1,625.00 580.50 19,057.50 21,343.00 (2,285.50) 181,080.00 162,022.50 89.5%5100639 GS-Discounts-Mdse(408.15) - (408.15) (4,024.83) - (4,024.83) - 4,024.83 0.0% Total Revenue Golf Shop4,126.44 2,500.00 1,626.44 31,356.14 32,836.00 (1,479.86) 278,585.00 247,729.47 88.9%COS 5100150 COS-GS-Hard Goods 803.75 507.50 296.25 8,286.12 6,665.94 1,620.18 56,552.90 48,266.78 85.3%5100151 COS-GS-Soft Goods771.30 942.50 (171.20) 8,692.70 12,378.94 (3,686.24) 105,026.40 96,333.70 91.7%5100152 COS-GS-Purchase Disc- (73.00) 73.00 - (953.00) 953.00 (8,079.00) (8,079.00) 100.0%5100220 COS-GS-Freight Merch 708.85 22.00 686.85 1,105.14 286.00 819.14 2,424.00 1,318.86 54.4%Cost of Sales - Golf Shop2,283.90 1,399.00 884.90 18,083.96 18,377.88 (293.92) 155,924.30 137,840.34 88.4%Gross Profit 1,842.54 1,101.00 741.54 13,272.18 14,458.12 (1,185.94) 122,660.70 109,889.13 89.6%COS % 55.3% 56.0% 0.6% 57.7% 56.0% -1.7% 53.1% 55.6% 104.8%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,697.76 2,387.00 (689.24) 6,732.36 8,525.00 (1,792.64) 27,621.00 20,888.64 75.6%6101325 Insurance-Workers Comp 202.51 271.00 (68.49) 1,987.81 1,287.00 700.81 5,042.00 3,054.19 60.6%6101720 Salaries3,909.05 3,950.00 (40.95) 15,170.15 15,800.00 (629.85) 45,000.00 29,829.85 66.3%6101800 Taxes-Employer Payroll 666.11 1,011.00 (344.89) 2,806.65 4,800.00 (1,993.35) 18,825.00 16,018.35 85.1%6101880 Wages-Hourly3,302.89 3,272.00 30.89 20,124.64 18,488.00 1,636.64 89,463.00 69,338.36 77.5%6101882 Wages-Overtime9.19 - 9.19 105.38 - 105.38 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 9,787.51 10,891.00 (1,103.49) 46,926.99 48,900.00 (1,973.01) 185,951.00 140,082.27 75.3%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office316.94 250.00 66.94 741.52 1,000.00 (258.48) 3,000.00 2,258.48 75.3%6109220 Freight & Delivery140.00 25.00 115.00 140.00 25.00 115.00 75.00 (65.00) -86.7%6109490 Miscellaneous500.00 500.00 - 1,582.24 2,000.00 (417.76) 6,000.00 4,417.76 73.6%6109150 Dues and Subscriptions- - - 102.30 - 102.30 2,300.00 2,197.70 95.6%6109500 ProShop-Over/Short0.07 - 0.07 3.70 - 3.70 - (3.70) 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 Uniforms732.25 100.00 632.25 1,257.21 400.00 857.21 2,400.00 1,142.79 47.6%6117840 Telephones64.67 110.00 (45.33) 263.47 440.00 (176.53) 1,320.00 1,056.53 80.0%1,753.93 1,485.00 268.93 4,090.44 4,815.00 (724.56) 18,875.00 14,784.56 78.3%11,541.44 12,376.00 (834.56) 51,017.43 53,715.00 (2,697.57) 204,826.00 154,866.83 75.6%Net Income(9,698.90) (11,275.00) 1,576.10 (37,745.25) (39,256.88) 1,511.63 (82,165.30) (44,977.70) 54.7%SilverRock ResortGolf Shop Income StatementOctober 2015Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,914.60 8,990.00 (1,075.40) 33,099.93 35,960.00 (2,860.07) 107,880.00 74,780.07 69.3%6311325 Insurance-Workers Comp2,034.05 2,328.00 (293.95) 9,569.65 7,803.00 1,766.65 24,794.00 15,224.35 61.4%6311720 Salaries12,295.40 11,900.00 395.40 45,463.20 47,600.00 (2,136.80) 142,017.20 96,554.00 68.0%6311800 Taxes-Employer Payroll7,185.68 9,181.00 (1,995.32) 22,642.19 29,623.00 (6,980.81) 93,302.00 70,659.81 75.7%6311880 Wages-Hourly44,291.28 43,156.00 1,135.28 158,870.86 153,472.00 5,398.86 508,481.80 349,610.94 68.8%6311882 Wages-Overtime9,867.80 10,526.00 (658.20) 9,947.12 10,526.00 (578.88) 15,945.00 5,997.88 37.6%Total-CM-SALARIES & BENEFITS83,588.81 86,081.00 (2,492.19) 279,592.95 284,984.00 (5,391.05) 892,420.00 612,827.05 68.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals7,031.04 4,600.00 2,431.04 20,442.19 13,600.00 6,842.19 34,600.00 14,157.81 40.9%6313744 Fertilizer16,442.27 17,500.00 (1,057.73) 54,127.10 53,500.00 627.10 112,500.00 58,372.90 51.9%6313745 Herbicides- - - 7,972.16 7,000.00 972.16 17,000.00 9,027.84 53.1%6313746 Flowers/Plants- 250.00 (250.00) - 1,250.00 (1,250.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline5,014.58 8,000.00 (2,985.42) 18,511.41 23,500.00 (4,988.59) 55,020.00 36,508.59 66.4%6313750 Golf Course Accessories9,031.24 10,000.00 (968.76) 10,081.86 10,900.00 (818.14) 13,000.00 2,918.14 22.4%6313756 POA Control248.67 - 248.67 498.76 - 498.76 7,000.00 6,501.24 92.9%6313758 Miscellaneous Supp661.75 500.00 161.75 1,738.14 2,750.00 (1,011.86) 4,350.00 2,611.86 60.0%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 2,000.00 (2,000.00) - 7,780.00 (7,780.00) 13,460.00 13,460.00 100.0%6313776 Seed107,545.16 102,000.00 5,545.16 108,140.48 102,950.00 5,190.48 125,900.00 17,759.52 14.1%6313778 Small Tools & Non-Capital Equip 2,249.23 2,000.00 249.23 2,590.12 4,200.00 (1,609.88) 5,000.00 2,409.88 48.2%6313780 Sod777.60 250.00 527.60 5,597.26 5,750.00 (152.74) 10,450.00 4,852.74 46.4%6313782 Topdressing2,275.78 2,500.00 (224.22) 4,565.37 5,000.00 (434.63) 10,600.00 6,034.63 56.9%Total-CM-SUPPLIES & MATERIALS151,277.32 149,600.00 1,677.32 234,264.85 238,180.00 (3,915.15) 411,930.00 177,665.15 43.1%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,830.00 2,600.00 230.00 12,806.50 10,400.00 2,406.50 31,200.00 18,393.50 59.0%6315685 CM-R&M-Bldngs & Othr Structures 321.22 500.00 (178.78) 1,866.28 3,050.00 (1,183.72) 5,550.00 3,683.72 66.4%6315690 CM-R&M-Equipment12,182.28 11,000.00 1,182.28 21,804.23 17,500.00 4,304.23 40,000.00 18,195.77 45.5%6315692 CM-R&M-Irrigation System2,999.31 2,000.00 999.31 11,285.77 11,400.00 (114.23) 19,050.00 7,764.23 40.8%6315696 CM-R&M-Pumps882.00 1,000.00 (118.00) 5,879.77 4,000.00 1,879.77 10,500.00 4,620.23 44.0%6315815 CM-R&M-Trees-Pruning Etc2,105.68 550.00 1,555.68 7,180.95 6,050.00 1,130.95 12,050.00 4,869.05 40.4%Total-CM-REPAIRS & MAINTENANCE21,320.49 17,650.00 3,670.49 60,823.50 52,400.00 8,423.50 118,350.00 57,526.50 48.6%6317836 Utilities-Natural Gas/LPG 20.71 15.00 5.71 80.81 60.00 20.81 180.00 99.19 0.0%6317840 Telephones1,126.74 850.00 276.74 4,415.08 3,400.00 1,015.08 10,200.00 5,784.92 56.7%Total-CM-UTILITIES1,147.45 865.00 282.45 4,495.89 3,460.00 1,035.89 10,380.00 5,884.11 56.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6319100 Contract Svcs-Soil/Tissue Test- - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal752.46 524.00 228.46 3,009.84 2,096.00 913.84 6,288.00 3,278.16 52.1%6319150 Dues & Subscriptions230.00 - 230.00 575.00 - 575.00 540.00 (35.00) -6.5%6319170 Employee Education- 50.00 (50.00) - 200.00 (200.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental732.57 1,000.00 (267.43) 911.44 1,500.00 (588.56) 3,400.00 2,488.56 73.2%6319206 Licenses & Permits- - - 223.89 280.00 (56.11) 4,180.00 3,956.11 94.6%6319490 Miscellaneous- 100.00 (100.00) 307.79 400.00 (92.21) 1,200.00 892.21 74.4%6319718 Safety Equipment & Training431.34 800.00 (368.66) 1,348.06 1,850.00 (501.94) 3,850.00 2,501.94 65.0%6319822 Uniforms1,177.44 920.00 257.44 3,546.43 3,680.00 (133.57) 11,040.00 7,493.57 67.9%Total-CM-OTHER EXPENSES3,823.81 3,894.00 (70.19) 13,922.45 14,006.00 (83.55) 42,048.00 28,125.55 66.9%SilverRock ResortCourse Maintenance Expense StatementOctober 2015Annual BudgetMonth to DateYear to Date5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,916.70 2,728.00 (811.30) 7,823.50 10,912.00 (3,088.50) 32,736.00 24,912.50 76.1%6321325 Insurance-Workers Comp501.20 568.00 (66.80) 2,241.42 2,041.00 200.42 6,171.00 3,929.58 63.7%6321800 Taxes-Employer Payroll2,267.25 2,277.00 (9.75) 5,454.05 7,821.00 (2,366.95) 23,334.00 17,879.95 76.6%6321880 Wages-Hourly13,039.20 12,880.00 159.20 51,267.96 51,520.00 (252.04) 160,320.00 109,052.04 68.0%6321882 Wages-Overtime3,352.57 3,381.00 (28.43) 3,352.57 4,347.00 (994.43) 6,351.00 2,998.43 47.2%Total-CM-LM-SALARIES & BENEFITS21,076.92 21,834.00 (757.08) 70,139.50 76,641.00 (6,501.50) 228,912.00 158,772.50 69.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 400.00 (400.00) 1,025.00 1,025.00 100.0%6323788 Uniforms240.18 290.00 (49.82) 667.66 1,160.00 (492.34) 3,480.00 2,812.34 80.8%Total-CM-LM-SUPPLIES & MATERIALS240.18 390.00 (149.82) 667.66 1,560.00 (892.34) 4,505.00 3,837.34 85.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%282,474.98 280,814.00 1,660.98 663,906.80 672,731.00 (8,824.20) 1,712,795.00 1,048,888.20 61.2% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 13,255.83 12,150.00 1,105.83 57,817.30 53,050.00 4,767.30 179,791.00 121,973.70 67.8%6337842 Utilities-Water4,493.07 4,200.00 293.07 24,345.47 23,560.00 785.47 45,338.00 20,992.53 46.3%17,748.90 16,350.00 1,398.90 82,162.77 76,610.00 5,552.77 225,129.00 142,966.23 63.5%Silverrock ResortCourse Maintenance Water & EnergyOctober 2015Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementOctober 2015Silverrock ResortAnnual BudgetMonth to DateYear to Date6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 2,728.00 (2,728.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp209.20 228.00 (18.80) 1,315.19 1,002.00 313.19 5,229.00 3,913.81 74.8%6411800 Taxes-Employer Payroll316.67 756.00 (439.33) 2,860.53 3,327.00 (466.47) 17,360.00 14,499.47 83.5%6411880 Wages-Hourly7,160.18 6,069.00 1,091.18 29,612.36 26,725.00 2,887.36 139,434.00 109,821.64 78.8%6411882 Wages-Overtime - - - 229.55 - 229.55 - (229.55) 0.0%Total-CBR-SALARIES & BENEFITS7,686.05 7,735.00 (48.95) 34,017.63 33,782.00 235.63 170,207.00 136,189.37 80.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts651.72 500.00 151.72 2,606.88 500.00 2,106.88 1,850.00 `0.0%6413742 Supplies-Expendable1,351.08 150.00 1,201.08 2,980.24 1,500.00 1,480.24 6,750.00 3,769.76 55.8%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 200.00 (200.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 9,000.00 9,000.00 100.0%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) 800.00 480.00 320.00 2,182.00 1,382.00 63.3%6413796 Supplies-Bottled Water216.00 50.00 166.00 432.00 3,650.00 (3,218.00) 11,000.00 10,568.00 96.1%Total-CBR-SUPPLIES & MATERIALS2,218.80 970.00 1,248.80 6,819.12 6,455.00 364.12 34,727.00 28,664.76 82.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment422.91 300.00 122.91 422.91 1,200.00 (777.09) 3,600.00 3,177.09 88.3%6415695 CBR-R&M-Cart Maintenance & Repair 865.52 950.00 (84.48) 2,538.24 2,450.00 88.24 6,450.00 3,911.76 60.6%Total-CBR-REPAIRS & MAINTENANCE1,288.43 1,250.00 38.43 2,961.15 3,650.00 (688.85) 10,050.00 7,088.85 70.5%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen96.85 800.00 (703.15) 1,428.21 3,200.00 (1,771.79) 9,600.00 8,171.79 85.1%6419220 Freight/Delivery- 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 1,941.78 2,400.00 (458.22) 7,200.00 5,258.22 73.0%6419820 Uniforms 2,298.23 2,000.00 298.23 2,396.52 2,000.00 396.52 5,200.00 2,803.48 53.9%Total-CBR-OTHER EXPENSES2,395.08 3,475.00 (1,079.92) 5,766.51 7,900.00 (2,133.49) 22,450.00 16,683.49 74.3%TOTAL-CARTS,BAGROOM & RANGE13,588.36 13,430.00 (1,079.92) 49,564.41 51,787.00 (2,222.59) 237,434.00 188,626.47 79.4%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp54.20 57.00 (2.80) 567.99 374.00 193.99 2,179.00 1,611.01 73.9%6431800 Taxes-Employer Payroll178.12 214.00 (35.88) 1,297.16 1,397.00 (99.84) 8,135.00 6,837.84 84.1%6431880 Wages-Hourly2,154.12 1,530.00 624.12 12,146.62 9,987.00 2,159.62 58,108.00 45,961.38 79.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,386.44 1,801.00 585.44 14,011.77 11,758.00 2,253.77 68,422.00 54,410.23 79.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable200.20 100.00 100.20 200.20 300.00 (99.80) 1,050.00 849.80 80.9%6439490 Miscellaneous- 50.00 (50.00) 697.20 50.00 647.20 200.00 (497.20) -248.6%6439718 Safety Equipment & Training- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms 1,471.63 800.00 671.63 1,471.63 1,025.00 446.63 2,125.00 653.37 30.7%Total-CS-OTHER EXPENSES1,671.83 1,000.00 671.83 2,369.03 1,575.00 794.03 3,975.00 1,605.97 40.4%Total-COURSE SERVICES4,058.27 2,801.00 1,257.27 16,380.80 13,333.00 3,047.80 72,397.00 56,016.20 77.4%17,646.63 16,231.00 1,415.63 65,945.21 65,120.00 825.21 309,831.00 243,036.70 78.4%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementOctober 2015Annual Budget7 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 1,605.00 1,600.00 5.00 4,800.00 3,195.00 66.6%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,605.00 1,600.00 5.00 4,800.00 3,195.00 66.6%65-CH-UTILITIES6507836 Utilities-Natural Gas330.64 300.00 30.64 1,287.31 1,200.00 87.31 3,600.00 2,312.69 64.2%6507840 Utilities-Telephone1,200.00 1,150.00 50.00 3,186.01 4,600.00 (1,413.99) 13,800.00 10,613.99 76.9%6507842 Utilities-Water1,255.81 321.00 934.81 2,859.81 1,284.00 1,575.81 3,852.00 992.19 25.8%6507844 Utilities-Cable481.41 340.00 141.41 1,925.64 1,360.00 565.64 4,080.00 2,154.36 52.8%Total-CH-UTILITIES3,267.86 2,111.00 1,156.86 9,258.77 8,444.00 814.77 25,332.00 16,073.23 63.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 2,425.00 (600.00) 7,420.00 7,900.00 (480.00) 22,500.00 15,080.00 67.0%6509099 Contract Services-Security4,912.72 4,900.00 12.72 20,713.12 19,600.00 1,113.12 60,400.00 39,686.88 65.7%6509215 Flowers & Decorations191.19 500.00 (308.81) 248.75 500.00 (251.25) 1,900.00 1,651.25 86.9%6509490 Miscellaneous12.55 200.00 (187.45) 82.54 800.00 (717.46) 7,000.00 6,917.46 98.8%6509718 Safety Equipment & Training- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES6,941.46 8,125.00 (1,183.54) 28,464.41 29,200.00 (735.59) 93,000.00 64,535.59 69.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures319.00 300.00 19.00 1,562.86 1,200.00 362.86 3,600.00 2,037.14 56.6%6515686 CH-R&M-Restaurant Repairs790.01 400.00 390.01 1,385.01 1,600.00 (214.99) 4,800.00 3,414.99 71.1%6515690 CH-R&M-Equipment Repair608.02 400.00 208.02 1,602.35 1,600.00 2.35 4,800.00 3,197.65 66.6%Total-CH-REPAIRS & MAINTENANCE1,717.03 1,100.00 617.03 4,550.22 4,400.00 150.22 13,200.00 8,649.78 65.5%12,326.35 11,736.00 590.35 43,878.40 43,644.00 234.40 136,332.00 17,299.56 12.7%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementOctober 2015Annual Budget8 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 435.79 341.00 94.79 1,481.00 1,364.00 117.00 4,092.00 2,611.00 63.8%6601325 Insurance-Workers Comp87.20 94.00 (6.80) 582.20 376.00 206.20 1,129.00 546.80 48.4%6601720 Salaries2,500.70 2,508.00 (7.30) 8,718.80 10,032.00 (1,313.20) 30,096.00 21,377.20 71.0%6601800 Taxes-Employer Payroll281.32 351.00 (69.68) 933.88 1,404.00 (470.12) 4,213.00 3,279.12 77.8%Total-MKT-SALARIES & BENEFITS3,305.01 3,294.00 11.01 11,715.88 13,176.00 (1,460.12) 39,530.00 27,814.12 70.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 133.72 100.00 33.72 423.47 400.00 23.47 1,200.00 776.53 64.7%6603768 Supplies-Printing & Stationery 242.49 3,000.00 (2,757.51) 1,126.76 3,200.00 (2,073.24) 4,425.00 3,298.24 74.5%376.21 3,100.00 (2,723.79) 1,550.23 3,600.00 (2,049.77) 5,625.00 4,074.77 72.4%66-MKT-UTILITIES6607840 Utilities-Telephone 63.08 100.00 (36.92) 247.32 400.00 (152.68) 1,200.00 952.68 79.4%Total-MKT-UTILITIES63.08 100.00 (36.92) 247.32 400.00 (152.68) 1,200.00 952.68 79.4%66-MKT-OTHER EXPENSES6609010 Advertising11,690.87 13,822.00 (2,131.13) 47,018.06 40,509.00 6,509.06 178,987.00 131,968.94 73.7%6609040 Business Meals- - - - - - 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) 198.00 600.00 (402.00) 1,800.00 1,602.00 89.0%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- 25.00 (25.00) - 100.00 (100.00) 700.00 700.00 100.0%6609633 Promotion-Community- 125.00 (125.00) 76.50 350.00 (273.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 Uniforms- 300.00 (300.00) 81.52 300.00 (218.48) 600.00 518.48 86.4%Total-MKT-OTHER EXPENSES11,789.87 14,972.00 (3,182.13) 47,374.08 42,559.00 4,815.08 193,822.00 146,447.92 75.6%15,534.17 21,466.00 (5,931.83) 60,887.51 59,735.00 1,152.51 240,177.00 179,289.49 74.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementOctober 2015Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group993.60 1,488.00 (494.40) 4,739.88 5,952.00 (1,212.12) 17,856.00 13,116.12 73.5%6701325 Insurance-Workers Comp591.20 617.00 (25.80) 2,832.78 2,422.00 410.78 7,717.00 4,884.22 63.3%6701720 Salaries14,488.00 13,438.00 1,050.00 55,110.00 53,752.00 1,358.00 177,996.00 122,886.00 69.0%6701800 Taxes-Employer Payroll2,084.32 2,303.00 (218.68) 6,512.90 9,044.00 (2,531.10) 28,812.00 22,299.10 77.4%6701880 Wages-Hourly3,199.10 2,412.00 787.10 10,395.10 10,248.00 147.10 27,800.00 17,404.90 62.6%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS21,356.22 20,258.00 1,098.22 79,590.66 81,418.00 (1,827.34) 260,181.00 180,590.34 69.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 331.46 2,000.00 (1,668.54) 6,300.00 5,968.54 94.7%6703762 Supplies-Office160.21 150.00 10.21 592.75 600.00 (7.25) 1,800.00 1,207.25 67.1%6703768 Supplies-Printing & Stationery100.00 100.00 - 284.68 400.00 (115.32) 3,300.00 3,015.32 91.4%Total-G&A-SUPPLIES & MATERIALS260.21 750.00 (489.79) 1,208.89 3,000.00 (1,791.11) 11,400.00 10,191.11 89.4%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 Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) - 300.00 (300.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 60.00 400.00 (340.00) 1,400.00 1,340.00 95.7%6709197 Equipment Rental416.88 550.00 (133.12) 2,011.33 2,200.00 (188.67) 6,600.00 4,588.67 69.5%6709202 Fees-Bank150.93 90.00 60.93 547.93 360.00 187.93 1,080.00 532.07 49.3%6709208 Fees-Payroll Processing1,108.46 1,200.00 (91.54) 4,535.89 4,800.00 (264.11) 14,400.00 9,864.11 68.5%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous- 100.00 (100.00) 38.78 400.00 (361.22) 1,200.00 1,161.22 96.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services147.00 75.00 72.00 356.59 300.00 56.59 900.00 543.41 60.4%6709625 Professional Fees602.50 850.00 (247.50) 3,938.00 3,400.00 538.00 10,200.00 6,262.00 61.4%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 800.00 (550.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms269.87 150.00 900.00 308.49 375.00 (66.51) 1,050.00 741.51 70.6%Total-G&A-OTHER EXPENSES3,345.64 4,015.00 110.77 13,647.01 15,635.00 (1,987.99) 54,030.00 40,382.99 74.7%24,962.07 25,123.00 (160.93) 94,446.56 100,353.00 (5,906.44) 327,511.00 233,064.44 71.2%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2015Annual Budget10 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 41,453.80 40,200.00 1,253.80 121,050.00 79,596.20 65.8%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 22,286.00 24,200.00 (1,914.00) 72,600.00 50,314.00 69.3%6800194 Equipment Leases-Trailer512.61 600.00 (87.39) 1,797.83 2,400.00 (602.17) 7,200.00 5,402.17 75.0%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 18,000.00 18,800.00 (800.00) 56,400.00 38,400.00 68.1%6800197 Equipment Leases-Others1,025.53 1,150.00 (124.47) 5,369.95 4,600.00 769.95 13,800.00 8,430.05 0.0%21,973.09 22,550.00 (576.91) 88,907.58 90,200.00 (1,292.42) 271,050.00 182,142.42 67.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 33,280.00 33,280.00 - 99,840.00 66,560.00 66.7%6900210 FF&E Reserve663.74 370.00 293.74 6,311.84 6,036.00 275.84 63,985.00 57,673.16 90.1%6900800 Personal Property Taxes- 2,600.00 (2,600.00) 12,117.83 11,800.00 317.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial5,084.27 2,200.00 2,884.27 10,862.59 8,800.00 2,062.59 26,400.00 15,537.41 58.9%14,068.01 13,490.00 578.01 62,572.26 59,916.00 2,656.26 202,025.00 139,452.74 69.0%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 2015Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐20162015 2015 2015 2015 2015 2015Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia24SalesPromotionGolf IndustryVIPCelebrityPGA Comp38373811Charity/Gift Certificate7Rain/Wind Checks121Club Staff9562806LQ HS Golf2117182168 121 14319002016 2016 2016 2016 2016 2016Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012