Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06 December 2017 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2017 – December 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 DecemberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue303,853.93 288,794.00 15,059.93 5.2% 704,573.11 727,673.00 (23,099.89) 2,964,060.00 2,259,486.89 24%401000 Miscellaneous Golf Revenue38,125.00 41,125.00 (3,000.00) -7.3% 99,339.00 106,313.00 (6,974.00) 166,766.00 67,427.00 60%410000 Revenue-Golf Shop27,528.44 25,625.00 1,903.44 7.4% 68,904.98 72,113.00 (3,208.02) 262,017.00 193,112.02 26%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%6,000.00 6,000.00 - 12,000.00 6,000.00 50%890000 Interest Income0.09 - 0.09 0.26 - 0.26 - (0.26) 0%Total Income371,007.46 357,044.00 13,963.46 3.9% 878,817.35 912,099.00 (33,281.65) 3,404,843.00 2,526,025.65 26%Cost of Goods Sold510000 COS-Golf Shop15,798.50 14,342.50 1,456.00 -10.2% 43,326.48 40,361.54 (2,964.94) 146,651.00 103,324.52 30%Total COS15,798.50 14,342.50 1,456.00 -10.2% 43,326.48 40,361.54 (2,964.94) 146,651.00 103,324.52 30%Gross Profit355,208.96 342,701.50 12,507.46 3.6% 835,490.87 871,737.46 (36,246.59) 3,258,192.00 2,422,701.13 26%Expenses610000 Golf Pro Shop 18,173.92 18,516.00 (342.08) 1.8% 86,834.52 86,520.00 314.52 199,990.00 113,155.48 43%630000 Course Maintenance119,027.14 136,949.67 (17,922.53) 13.1% 881,024.74 975,704.67 (94,679.93) 1,735,790.00 854,765.26 51%633000 Maintenance Water & Energy19,875.85 16,775.00 3,100.85 -18.5% 119,649.16 119,356.00 293.16 249,838.00 130,188.84 48%640000 Outside Services26,888.73 35,125.00 (8,236.27) 23.4% 142,952.37 144,208.00 (1,255.63) 331,964.00 189,011.63 43%650000 Clubhouse9,736.90 10,776.00 (1,039.10) 9.6% 66,157.69 68,056.00 (1,898.31) 136,412.00 70,254.31 48%660000 Marketing24,412.36 27,526.00 (3,113.64) 11.3% 100,426.39 110,665.00 (10,238.61) 230,960.00 130,533.61 43%670000 General & Administrative23,910.19 30,430.00 (6,519.81) 21.4% 139,052.10 162,652.00 (23,599.90) 329,053.00 190,000.90 42%680000 Leases25,016.51 28,800.00 (3,783.49) 13.1% 151,722.10 148,250.00 3,472.10 321,050.00 169,327.90 47%690000 Miscellaneous Other Expense21,592.32 17,475.00 4,117.32 -23.6% 113,243.12 96,548.00 16,695.12 211,468.00 98,224.88 54%Total Expenses288,633.92 322,372.67 (33,738.75) 10.5% 1,801,062.19 1,911,959.67 110,897.48 3,746,525.00 1,945,462.81 48%66,575.04 20,328.83 46,246.21 227.5%(965,571.32) (1,040,222.21) 74,650.89 (488,333.00) 477,238.32 0%Rounds of Golf PlayedPaid Rounds Played4,754 4,100 654 16.0%13,003 12,873 130 42,173 29,170 31%Ave $ Per Paid Round Green Fee63.92 70.44 (6.52) -9.3%54.19 56.53 (2.34) 70.28 16.10 77%Ave $ Per Paid Round Merchandise5.79 6.25 (0.46) -7.4%5.30 5.60 (0.30) 6.21 0.91 85%Ave $ Per Paid Miscellaneous 8.02 10.03 (2.01) -20.0%7.64 8.26 (0.62) 3.95 (3.69) 193%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateDecember 20171 Income DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees303,853.93 288,794.00 15,059.93 704,573.11 727,673.00 (23,099.89) 2,964,060.00 2,259,486.89 76.2%4010000 Rider Fee1,050.00 1,025.00 25.00 2,390.00 1,903.00 487.00 7,307.00 4,917.00 67.3%4040000 Club Rental3,430.00 2,050.00 1,380.00 7,640.00 6,438.00 1,202.00 21,087.00 13,447.00 63.8%4050000 Driving Range9,785.00 10,250.00 (465.00) 27,024.00 29,172.00 (2,148.00) 94,872.00 67,848.00 71.5%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - - 2,000.00 (2,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee 1,000.00 5,000.00 (4,000.00) 2,210.00 10,000.00 (7,790.00) 37,000.00 34,790.00 94.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue22,860.00 22,800.00 60.00 60,075.00 56,800.00 3,275.00 165,300.00 105,225.00 63.7% Total Revenue Fees341,978.93 329,919.00 12,059.93 803,912.11 833,986.00 (30,073.89) 3,296,126.00 2,492,213.89 75.6%341,978.93 329,919.00 12,059.93 803,912.11 833,986.00 (30,073.89) 3,296,126.00 2,492,213.89 75.6%SilverRock ResortStatement of Fees RevenueDecember 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$38,125.00$41,125.00(3,000.00)Unfavorable: Due to reduced income from Golf Schools; Golf Made Simple is not teaching this year due to clubhouse relocation plans and uncertain circumstances of facilities. ActualBudgetVariance$27,528.44$25,625.001,903.44Unfavorable: Due to reduced cost of green fees, and reduction of inventory to prepare for new season.ExpensesActualBudgetVariance$119,027.14$136,949.67(17,922.53)Favorable: Due to timing of fertilizer invoices. This was order in December but has yet to be received.ActualBudgetVariance$19,875.85$16,775.003,100.85Unfavorable: Due to a warmer December and the grow-in on the back nine holes water costs is up.ActualBudgetVariance$26,888.73$35,125.00(8,236.27)Favorable: Due to reduced payroll and line items, this was in an effort to align actuals with year to date budget. ActualBudgetVariance$24,412.36$27,526.00(3,113.64)Favorable: Due to reduced advertising spent. We are in align with the current year to date budget number.ActualBudgetVariance$23,910.19$30,430.00(6,519.81)Favorable: Due to reduced payroll, and line items. The line items is reduced due to timing of invoice.ActualBudgetVariance$25,471.92$28,800.00(3,328.08)Favorable: Due to missing invoice for partial maintenance equipment lease.ActualBudgetVariance$21,592.32$17,475.004,117.32Unfavorable: Due to payments for commerical insurance down payment.Golf Course MaintenanceGeneral and AdministrativeMarketingMiscellaneous Other ExpenseLeasesMaintenance Water and EnergyOutside Servicesprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesMiscellaneous Golf RevenueVariance ExplanationDecember 2017The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations are3-20-133 Income DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous305.52 - 305.52 1,820.87 - 1,820.87 00 0%4100110 Sales Hard Goods 10,550.91 8,969.00 1,581.91 26,211.91 25,240.00 971.91 91,706.00 65,494.09 71.4%4100112 Sales-Soft Goods20,626.75 16,656.00 3,970.75 52,371.42 46,873.00 5,498.42 170,311.00 117,939.58 69.2%5100639 GS-Discounts-Mdse (3,954.74) - (3,954.74) (11,499.22) - (11,499.22) - 11,499.22 0.0% Total Revenue Golf Shop27,528.44 25,625.00 1,903.44 68,904.98 72,113.00 (3,208.02) 262,017.00 194,932.89 74.4%COS 5100150 COS-GS-Hard Goods 5,607.69 5,202.02 405.67 14,680.57 14,639.20 41.37 53,189.48 38,508.91 72.4%5100151 COS-GS-Soft Goods 9,874.09 9,660.48 213.61 26,682.54 27,186.34 (503.80) 97,137.52 70,454.98 72.5%5100152 COS-GS-Purchase Disc- (743.00) 743.00 (7.62) (2,092.00) 2,084.38 (7,598.00) (7,590.38) 99.9%5100220 COS-GS-Freight Merch 316.72 223.00 93.72 1,970.99 628.00 1,342.99 2,280.00 309.01 13.6%Cost of Sales - Golf Shop15,798.50 14,342.50 1,456.00 43,326.48 40,361.54 2,964.94 145,009.00 101,682.52 70.1%Gross Profit 11,729.94 11,282.50 447.44 25,578.50 31,751.46 (6,172.96) 117,008.00 93,250.37 79.7%COS % 57.4% 56.0% -1.4% 62.9% 56.0% -6.9% 53.1% 52.2% 98.3%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,404.84 2,436.00 (1,031.16) 10,440.88 12,180.00 (1,739.12) 26,796.00 16,355.12 61.0%6101325 Insurance-Workers Comp 451.40 478.00 (26.60) 3,166.14 2,157.00 1,009.14 4,957.00 1,790.86 36.1%6101720 Salaries4,200.00 4,001.00 199.00 24,200.00 24,006.00 194.00 45,000.00 20,800.00 46.2%6101800 Taxes-Employer Payroll 1,202.41 1,659.00 (456.59) 5,248.73 7,478.00 (2,229.27) 18,825.00 13,576.27 72.1%6101880 Wages-Hourly9,690.62 8,757.00 933.62 38,409.55 33,514.00 4,895.55 87,179.00 48,769.45 55.9%6101882 Wages-Overtime4.89 - 4.89 378.20 - 378.20 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 16,954.16 17,331.00 (376.84) 81,843.50 79,335.00 2,508.50 182,757.00 102,244.58 55.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) 202.58 1,500.00 (1,297.42) 3,000.00 2,797.42 93.2%6109220 Freight & Delivery49.87 25.00 24.87 139.03 75.00 64.03 75.00 (64.03) -85.4%6109490 Miscellaneous9.75 500.00 (490.25) 1,325.02 3,000.00 (1,674.98) 6,000.00 4,674.98 77.9%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short0.05 - 0.05 165.49 - 165.49 - (165.49) 0.0%6109722 Seminars/Training- 100.00 (100.00) - 1,050.00 (1,050.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms1,107.98 200.00 907.98 2,464.11 900.00 1,564.11 2,400.00 (64.11) -2.7%6117840 Telephones52.11 110.00 (57.89) 694.79 660.00 34.79 1,320.00 625.21 47.4%1,219.76 1,185.00 34.76 4,991.02 7,185.00 (2,193.98) 18,875.00 13,883.98 73.6%18,173.92 18,516.00 (342.08) 86,834.52 86,520.00 314.52 201,632.00 116,128.56 57.6%Net Income(6,443.98) (7,233.50) 789.52 (61,256.02) (54,768.54) (6,487.48) (84,624.00) (22,878.19) 27.0%SilverRock ResortGolf Shop Income StatementDecember 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,474.69 9,165.00 (690.31) 46,017.47 48,030.00 (2,012.53) 103,020.00 57,002.53 55.3%6311325 Insurance-Workers Comp2,370.50 2,352.00 18.50 14,709.12 13,242.00 1,467.12 26,974.00 12,264.88 45.5%6311720 Salaries12,208.66 12,200.00 8.66 70,185.72 73,200.00 (3,014.28) 146,400.00 76,214.28 52.1%6311800 Taxes-Employer Payroll4,523.40 8,154.00 (3,630.60) 28,154.98 46,439.00 (18,284.02) 91,481.00 63,326.02 69.2%6311880 Wages-Hourly48,785.34 50,553.67 (1,768.33) 258,661.31 271,673.67 (13,012.36) 567,262.00 308,600.69 54.4%6311882 Wages-Overtime2,598.04 - 2,598.04 45,337.64 12,350.00 32,987.64 12,350.00 (32,987.64) -267.1%Total-CM-SALARIES & BENEFITS78,960.63 82,424.67 (3,464.04) 463,066.24 464,934.67 (1,868.43) 947,487.00 484,420.76 51.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals18.00 - 18.00 14,224.49 26,441.00 (12,216.51) 17,760.00 3,535.51 19.9%6313744 Fertilizer- 10,820.00 (10,820.00) 34,005.87 68,880.00 (34,874.13) 105,970.00 71,964.13 67.9%6313745 Herbicides3,785.55 - 3,785.55 8,875.37 - 8,875.37 25,518.00 16,642.63 65.2%6313746 Flowers/Plants- 750.00 (750.00) 1,650.42 2,000.00 (349.58) 3,050.00 1,399.58 45.9%6313748 Fuel-Gasoline2,845.53 4,450.00 (1,604.47) 17,223.78 25,920.00 (8,696.22) 48,950.00 31,726.22 64.8%6313750 Golf Course Accessories215.77 - 215.77 11,581.78 12,300.00 (718.22) 13,140.00 1,558.22 11.9%6313756 POA Control- 7,500.00 (7,500.00) - 9,900.00 (9,900.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp933.55 500.00 433.55 4,778.36 3,750.00 1,028.36 4,350.00 (428.36) -9.8%6313762 Supplies-Office66.75 - 66.75 120.75 - 120.75 - (120.75) 0.0%6313774 Sand- 800.00 (800.00) 3,811.98 12,580.00 (8,768.02) 13,460.00 9,648.02 71.7%6313776 Seed- - - 104,427.63 117,400.00 (12,972.37) 117,400.00 12,972.37 11.0%6313778 Small Tools & Non-Capital Equip 1,553.45 100.00 1,453.45 1,794.98 4,400.00 (2,605.02) 5,000.00 3,205.02 64.1%6313780 Sod- - - 7,479.11 8,800.00 (1,320.89) 13,500.00 6,020.89 44.6%6313782 Topdressing- - - 6,473.47 7,000.00 (526.53) 10,000.00 3,526.53 35.3%Total-CM-SUPPLIES & MATERIALS9,418.60 24,920.00 (15,501.40) 216,447.99 299,371.00 (82,923.01) 387,998.00 171,550.01 44.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 21,944.24 16,980.00 4,964.24 33,960.00 12,015.76 35.4%6315685 CM-R&M-Bldngs & Othr Structures 421.95 500.00 (78.05) 2,726.68 4,050.00 (1,323.32) 5,550.00 2,823.32 50.9%6315690 CM-R&M-Equipment1,626.99 2,000.00 (373.01) 20,788.70 24,500.00 (3,711.30) 38,500.00 17,711.30 46.0%6315692 CM-R&M-Irrigation System1,417.99 550.00 867.99 13,166.78 12,850.00 316.78 19,050.00 5,883.22 30.9%6315696 CM-R&M-Pumps1,824.20 1,000.00 824.20 3,464.87 6,000.00 (2,535.13) 10,500.00 7,035.13 67.0%6315815 CM-R&M-Trees-Pruning Etc- - - 6,680.00 6,050.00 630.00 12,050.00 5,370.00 44.6%Total-CM-REPAIRS & MAINTENANCE9,131.13 6,880.00 2,251.13 68,771.27 70,430.00 (1,658.73) 119,610.00 50,838.73 42.5%6317836 Utilities-Natural Gas/LPG 20.70 15.00 5.70 136.58 90.00 46.58 180.00 43.42 0.0%6317840 Telephones829.97 850.00 (20.03) 5,972.59 5,100.00 872.59 10,200.00 4,227.41 41.4%Total-CM-UTILITIES850.67 865.00 (14.33) 6,109.17 5,190.00 919.17 10,380.00 4,270.83 41.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%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) - 3,144.00 (3,144.00) 6,288.00 6,288.00 100.0%6319150 Dues & Subscriptions210.00 - 210.00 420.00 - 420.00 680.00 260.00 38.2%6319170 Employee Education- 50.00 (50.00) - 300.00 (300.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) 1,785.29 2,300.00 (514.71) 3,400.00 1,614.71 47.5%6319206 Licenses & Permits120.00 50.00 70.00 359.29 400.00 (40.71) 4,300.00 3,940.71 91.6%6319490 Miscellaneous581.72 100.00 481.72 635.09 600.00 35.09 1,200.00 564.91 47.1%6319718 Safety Equipment & Training495.00 400.00 95.00 1,625.86 2,750.00 (1,124.14) 3,850.00 2,224.14 57.8%6319822 Uniforms1,391.87 920.00 471.87 4,663.98 5,520.00 (856.02) 11,040.00 6,376.02 57.8%Total-CM-OTHER EXPENSES3,198.59 2,644.00 554.59 11,889.51 18,414.00 (6,524.49) 41,458.00 29,568.49 71.3%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2017Annual Budget5 DecemberFinal 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) 23,733.75 16,704.00 7,029.75 33,408.00 9,674.25 29.0%6321325 Insurance-Workers Comp495.50 500.00 (4.50) 3,181.58 3,037.00 144.58 5,955.00 2,773.42 46.6%6321800 Taxes-Employer Payroll1,733.00 1,733.00 - 7,492.91 10,677.00 (3,184.09) 20,793.00 13,300.09 64.0%6321880 Wages-Hourly12,176.38 13,334.00 (1,157.62) 74,397.12 78,714.00 (4,316.88) 156,528.00 82,130.88 52.5%6321882 Wages-Overtime432.37 - 432.37 1,973.86 3,418.00 (1,444.14) 3,418.00 1,444.14 42.3%Total-CM-LM-SALARIES & BENEFITS17,467.52 18,351.00 (883.48) 110,779.22 112,550.00 (1,770.78) 220,102.00 109,322.78 49.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) 386.77 575.00 (188.23) 1,025.00 638.23 62.3%6323788 Uniforms- 290.00 (290.00) 360.87 1,740.00 (1,379.13) 3,480.00 3,119.13 89.6%Total-CM-LM-SUPPLIES & MATERIALS- 365.00 (365.00) 747.64 2,315.00 (1,567.36) 4,505.00 3,757.36 83.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) 3,213.70 2,500.00 713.70 4,250.00 1,036.30 24.4%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) 3,213.70 2,500.00 713.70 4,250.00 1,036.30 24.4%119,027.14 136,949.67 (17,922.53) 881,024.74 975,704.67 (94,679.93) 1,735,790.00 854,765.26 49.2% DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 8,003.04 9,090.00 (1,086.96) 64,607.87 72,790.00 (8,182.13) 179,791.00 115,183.13 64.1%6337842 Utilities-Water11,872.81 7,685.00 4,187.81 55,041.29 46,566.00 8,475.29 70,047.00 15,005.71 21.4%19,875.85 16,775.00 3,100.85 119,649.16 119,356.00 293.16 249,838.00 130,188.84 52.1%Total-COURSE MAINTENANCECourse Maintenance Expense StatementDecember 2017Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyDecember 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 4,176.00 (4,176.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp603.50 644.00 (40.50) 3,808.67 2,235.00 1,573.67 5,623.00 1,814.33 32.3%6411800 Taxes-Employer Payroll707.76 2,136.00 (1,428.24) 4,400.20 7,420.00 (3,019.80) 18,667.00 14,266.80 76.4%6411880 Wages-Hourly14,609.50 17,160.00 (2,550.50) 52,296.20 59,605.00 (7,308.80) 149,934.00 97,637.80 65.1%6411882 Wages-Overtime 213.97 - 213.97 404.32 - 404.32 - (404.32) 0.0%Total-CBR-SALARIES & BENEFITS16,134.73 20,636.00 (4,501.27) 60,909.39 73,436.00 (12,526.61) 182,576.00 121,666.61 66.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts61.75 500.00 (438.25) 61.75 1,500.00 (1,438.25) 1,850.00 `0.0%6413742 Supplies-Expendable679.69 150.00 529.69 2,210.05 3,450.00 (1,239.95) 6,750.00 4,539.95 67.3%6413748 Supplies-Fuel for Shuttle- 400.00 (400.00) - 900.00 (900.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - 10,766.25 9,000.00 1,766.25 9,000.00 (1,766.25) -19.6%6413762 Supplies-Office- 50.00 (50.00) - 225.00 (225.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 240.00 195.00 45.00 1,618.35 860.00 758.35 2,182.00 563.65 25.8%6413796 Supplies-Bottled Water107.75 100.00 7.75 5,925.50 5,000.00 925.50 12,900.00 6,974.50 54.1%Total-CBR-SUPPLIES & MATERIALS1,089.19 1,395.00 (305.81) 20,581.90 20,935.00 (353.10) 36,627.00 14,256.85 38.9%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 22,280.89 1,800.00 20,480.89 3,600.00 (18,680.89) -518.9%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 500.00 3,450.00 (2,950.00) 6,450.00 5,950.00 92.2%Total-CBR-REPAIRS & MAINTENANCE- 800.00 (800.00) 22,780.89 5,250.00 17,530.89 10,050.00 (12,730.89) -126.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen766.54 800.00 (33.46) 3,966.97 4,800.00 (833.03) 9,600.00 5,633.03 58.7%6419220 Freight/Delivery- 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 1,494.44 3,600.00 (2,105.56) 7,200.00 5,705.56 79.2%6419820 Uniforms - 500.00 (500.00) - 3,000.00 (3,000.00) 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES766.54 1,975.00 (1,208.46) 5,461.41 11,850.00 (6,388.59) 22,450.00 16,988.59 75.7%TOTAL-CARTS,BAGROOM & RANGE17,990.46 24,806.00 (1,208.46) 109,733.59 111,471.00 (1,737.41) 251,703.00 140,181.16 55.7%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp301.50 317.00 (15.50) 2,191.56 976.00 1,215.56 2,450.00 258.44 10.5%6431800 Taxes-Employer Payroll813.75 1,099.00 (285.25) 2,512.56 3,389.00 (876.44) 8,494.00 5,981.44 70.4%6431880 Wages-Hourly7,783.02 8,453.00 (669.98) 24,535.38 26,072.00 (1,536.62) 65,341.00 40,805.62 62.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS8,898.27 9,869.00 (970.73) 29,239.50 30,437.00 (1,197.50) 76,285.00 47,045.50 61.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 500.00 (500.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- 50.00 (50.00) - 150.00 (150.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6439820 Uniforms - 250.00 (250.00) 3,979.28 1,350.00 2,629.28 2,125.00 (1,854.28) -87.3%Total-CS-OTHER EXPENSES- 450.00 (450.00) 3,979.28 2,300.00 1,679.28 3,975.00 (4.28) -0.1%Total-COURSE SERVICES 8,898.27 10,319.00 (1,420.73) 33,218.78 32,737.00 481.78 80,260.00 47,041.22 58.6%26,888.73 35,125.00 (8,236.27) 142,952.37 144,208.00 (1,255.63) 331,963.00 187,226.66 56.4%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementDecember 2017Annual Budget7 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%65-CH-UTILITIES6507836 Utilities-Natural Gas265.48 300.00 (34.52) 1,865.54 1,800.00 65.54 3,600.00 1,734.46 48.2%6507840 Utilities-Telephone1,113.52 1,150.00 (36.48) 5,455.53 6,900.00 (1,444.47) 13,800.00 8,344.47 60.5%6507842 Utilities-Water- 321.00 (321.00) 1,616.41 1,926.00 (309.59) 3,852.00 2,235.59 58.0%6507844 Utilities-Cable494.41 380.00 114.41 2,958.64 2,280.00 678.64 4,560.00 1,601.36 35.1%Total-CH-UTILITIES1,873.41 2,151.00 (277.59) 11,896.12 12,906.00 (1,009.88) 25,812.00 13,915.88 53.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,920.00 1,825.00 95.00 11,155.00 11,550.00 (395.00) 22,500.00 11,345.00 50.4%6509099 Contract Services-Security3,125.04 5,000.00 (1,874.96) 29,306.62 30,000.00 (693.38) 60,000.00 30,693.38 51.2%6509215 Flowers & Decorations- - - - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous1,127.10 200.00 927.10 1,905.00 3,500.00 (1,595.00) 7,000.00 5,095.00 72.8%6509718 Safety Equipment & Training- 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES6,172.14 7,125.00 (952.86) 42,366.62 46,150.00 (3,783.38) 92,600.00 50,233.38 54.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,291.35 300.00 991.35 5,928.41 1,800.00 4,128.41 3,600.00 (2,328.41) -64.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,256.84 2,400.00 (1,143.16) 4,800.00 3,543.16 73.8%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,309.70 2,400.00 (90.30) 4,800.00 2,490.30 51.9%Total-CH-REPAIRS & MAINTENANCE1,291.35 1,100.00 191.35 9,494.95 6,600.00 2,894.95 13,200.00 3,705.05 28.1%9,736.90 10,776.00 (1,039.10) 66,157.69 68,056.00 (1,898.31) 136,412.00 7,410.10 5.4%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementDecember 2017Annual Budget8 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 351.02 348.00 3.02 2,454.12 2,088.00 366.12 4,176.00 1,721.88 41.2%6601325 Insurance-Workers Comp87.47 94.00 (6.53) 565.47 564.00 1.47 1,129.00 563.53 49.9%6601720 Salaries1,904.96 2,508.00 (603.04) 11,429.76 15,048.00 (3,618.24) 30,096.00 18,666.24 62.0%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 871.20 1,956.00 (1,084.80) 3,912.00 3,040.80 77.7%Total-MKT-SALARIES & BENEFITS2,488.65 3,276.00 (787.35) 15,320.55 19,656.00 (4,335.45) 39,313.00 23,992.45 61.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 524.68 600.00 (75.32) 1,200.00 675.32 56.3%6603768 Supplies-Printing & Stationery 386.62 200.00 186.62 2,187.09 3,600.00 (1,412.91) 4,425.00 2,237.91 50.6%450.79 300.00 150.79 2,711.77 4,200.00 (1,488.23) 5,625.00 2,913.23 51.8%66-MKT-UTILITIES6607840 Utilities-Telephone 164.69 100.00 64.69 863.76 600.00 263.76 1,200.00 336.24 28.0%Total-MKT-UTILITIES164.69 100.00 64.69 863.76 600.00 263.76 1,200.00 336.24 28.0%66-MKT-OTHER EXPENSES6609010 Advertising19,796.74 22,225.00 (2,428.26) 76,789.10 79,909.00 (3,119.90) 169,987.00 93,197.90 54.8%6609040 Business Meals- 25.00 (25.00) - 150.00 (150.00) 300.00 300.00 100.0%6609080 Collateral Material487.18 - 487.18 770.72 1,500.00 (729.28) 5,500.00 4,729.28 86.0%6609102 Contract Services-Web Page99.00 150.00 (51.00) 495.00 900.00 (405.00) 1,800.00 1,305.00 72.5%6609490 Miscellaneous- 50.00 (50.00) - 100.00 (100.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 2,064.31 150.00 1,914.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community338.32 750.00 (411.68) 824.19 1,800.00 (975.81) 2,250.00 1,425.81 63.4%6609634 Promotion-Media/Vendor586.99 500.00 86.99 586.99 1,000.00 (413.01) 2,000.00 1,413.01 70.7%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES21,308.23 23,850.00 (2,541.77) 81,530.31 86,209.00 (4,678.69) 184,822.00 103,291.69 55.9%24,412.36 27,526.00 (3,113.64) 100,426.39 110,665.00 (10,238.61) 230,960.00 130,533.61 56.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementDecember 2017Annual Budget9 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,930.24 1,509.00 421.24 10,803.86 9,054.00 1,749.86 18,108.00 7,304.14 40.3%6701325 Insurance-Workers Comp603.47 677.00 (73.53) 3,867.35 3,838.00 29.35 7,905.00 4,037.65 51.1%6701720 Salaries12,147.52 15,450.00 (3,302.48) 76,147.52 85,900.00 (9,752.48) 177,996.00 101,848.48 57.2%6701800 Taxes-Employer Payroll828.99 2,349.00 (1,520.01) 7,268.56 13,314.00 (6,045.44) 32,800.00 25,531.44 77.8%6701880 Wages-Hourly1,148.71 2,600.00 (1,451.29) 12,861.61 16,476.00 (3,614.39) 27,404.00 14,542.39 53.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS16,658.93 22,585.00 (5,926.07) 110,948.90 128,582.00 (17,633.10) 264,213.00 153,264.10 58.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 2,419.07 3,000.00 (580.93) 6,300.00 3,880.93 61.6%6703762 Supplies-Office- 105.00 (105.00) 208.35 630.00 (421.65) 1,260.00 1,051.65 83.5%6703768 Supplies-Printing & Stationery467.63 400.00 67.63 1,407.36 900.00 507.36 3,300.00 1,892.64 57.4%Total-G&A-SUPPLIES & MATERIALS467.63 1,005.00 (537.37) 4,034.78 4,530.00 (495.22) 10,860.00 6,825.22 62.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 1,300.00 (1,300.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 1,300.00 (1,300.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.0%6709150 Dues & Subscriptions- 50.00 (50.00) 420.00 400.00 20.00 1,150.00 730.00 63.5%6709180 Employee Recruiting/Relocation270.00 200.00 70.00 521.95 650.00 (128.05) 1,200.00 678.05 56.5%6709197 Equipment Rental485.37 550.00 (64.63) 3,203.53 3,300.00 (96.47) 6,600.00 3,396.47 51.5%6709202 Fees-Bank102.44 90.00 12.44 1,469.48 540.00 929.48 1,080.00 (389.48) -36.1%6709208 Fees-Payroll Processing1,091.35 1,000.00 91.35 3,912.88 6,000.00 (2,087.12) 12,000.00 8,087.12 67.4%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous3,350.00 3,000.00 350.00 3,507.32 6,000.00 (2,492.68) 6,600.00 3,092.68 46.9%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services271.63 75.00 196.63 1,054.59 450.00 604.59 900.00 (154.59) -17.2%6709625 Professional Fees436.81 850.00 (413.19) 4,958.51 5,100.00 (141.49) 10,200.00 5,241.49 51.4%6709636 Promotion/Entertainment26.03 100.00 (73.97) 164.21 600.00 (435.79) 1,200.00 1,035.79 86.3%6709722 Seminars & Training250.00 200.00 50.00 1,270.08 1,200.00 70.08 2,400.00 1,129.92 47.1%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 585.87 600.00 (14.13) 1,050.00 464.13 44.2%Total-G&A-OTHER EXPENSES6,783.63 6,740.00 1,018.63 24,068.42 28,240.00 (4,171.58) 52,080.00 28,011.58 53.8%23,910.19 30,430.00 (6,519.81) 139,052.10 162,652.00 (23,599.90) 329,053.00 190,000.90 57.7%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2017Annual Budget10 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 58,975.62 60,750.00 (1,774.38) 121,050.00 62,074.38 51.3%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 55,087.20 47,200.00 7,887.20 116,200.00 61,112.80 52.6%6800194 Equipment Leases-Trailer843.07 600.00 243.07 3,651.74 3,600.00 51.74 7,200.00 3,548.26 49.3%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 23,220.00 28,200.00 (4,980.00) 56,400.00 33,180.00 58.8%6800197 Equipment Leases-Others1,292.97 1,950.00 (657.03) 10,787.54 8,500.00 2,287.54 20,200.00 9,412.46 0.0%25,016.51 28,800.00 (3,783.49) 151,722.10 148,250.00 3,472.10 321,050.00 169,327.90 52.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 10,730.00 8,999.00 1,731.00 54,494.00 53,994.00 500.00 107,987.00 53,493.00 49.5%6900210 FF&E Reserve6,077.08 5,776.00 301.08 14,091.48 14,554.00 (462.52) 59,281.00 45,189.52 76.2%6900800 Personal Property Taxes3.68 - 3.68 15,099.65 11,800.00 3,299.65 11,800.00 (3,299.65) -28.0%6900323 Insurance-Commercial4,781.56 2,700.00 2,081.56 29,557.99 16,200.00 13,357.99 32,400.00 2,842.01 8.8%21,592.32 17,475.00 4,117.32 113,243.12 96,548.00 16,695.12 211,468.00 98,224.88 46.4%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 2017Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-20182017 2017 2017 2017 2017 2017Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia13 5SalesPromotionGolf IndustryVIPCelebrityPGA Comp20 12 27516Charity/Gift Certificate2213 10Rain/Wind Checks2Club Staff53 38 65 16 32 66LQ HS Golf1066382685 58 98 19 71 1252018 2018 2018 2018 2018 2018Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-2018December 2017 Date TimeDescriptionCategoryPlayers12/3/2017 11:30:00 AM John White Local News AnchorMedia412/11/2017 11:38:00 AM Tom Paskings - Golfweek RaterMedia113