Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06 December 2018 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2018 – December 2018 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Golf Shop Income Statement 4 Course Maintenance Expense Statement 5 Outside Service Expense Statement 7 Clubhouse Expense Statement 8 Marketing Expense Statement 9 General & Administrative Expense Statement 10 Operating Leases & Miscellaneous Expense Statement 12 Complimentary Report 13 Annual BudgetAccount Description December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue305,195.83 310,985.00 (5,789.17) -1.9% 990,065.63 955,386.00 34,679.63 3,401,303.00 2,411,237.37 29%401000 Miscellaneous Golf Revenue32,687.00 36,125.00 (3,438.00) -9.5% 105,579.85 98,310.60 7,269.25 302,066.00 196,486.15 35%410000 Revenue-Golf Shop23,842.47 25,625.00 (1,782.53) -7.0% 85,662.47 87,250.00 (1,587.53) 277,150.00 191,487.53 31%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.03 - 0.03 0.0%0.21 - 0.21 - (0.21) 0%Total Income363,225.33 374,235.00 (11,009.67) -2.9% 1,187,308.16 1,146,946.60 40,361.56 3,992,519.00 2,805,210.84 30%Cost of Goods Sold510000 COS-Golf Shop12,682.29 13,822.39 (1,140.10) 8.2% 48,020.68 47,705.28 (315.40) 155,121.00 107,100.32 31%Total COS12,682.29 13,822.39 (1,140.10) 8.2% 48,020.68 47,705.28 (315.40) 155,121.00 107,100.32 31%Gross Profit350,543.04 360,412.61 (9,869.57) -2.7% 1,139,287.48 1,099,241.32 40,046.16 3,837,398.00 2,698,110.52 30%Expenses610000 Golf Pro Shop 20,996.87 20,452.03 544.84 -2.7% 102,970.61 96,204.34 6,766.27 221,115.00 118,144.39 47%630000 Course Maintenance135,682.94 135,639.00 43.94 0.0% 943,893.48 978,154.00 (34,260.52) 1,740,490.00 796,596.52 54%633000 Maintenance Water & Energy11,690.19 16,775.00 (5,084.81) 30.3% 103,728.52 119,356.00 (15,627.48) 249,838.00 146,109.48 42%640000 Outside Services37,505.61 36,361.05 1,144.56 -3.1% 168,951.59 147,998.97 20,952.62 354,598.00 185,646.41 48%650000 Clubhouse10,871.07 10,776.00 95.07 -0.9% 64,035.49 68,056.00 (4,020.51) 136,412.00 72,376.51 47%660000 Marketing24,332.29 27,031.00 (2,698.71) 10.0% 107,297.35 109,675.00 (2,377.65) 229,960.00 122,662.65 47%670000 General & Administrative26,909.99 30,442.00 (3,532.01) 11.6% 138,637.85 162,665.14 (24,027.29) 329,053.00 190,415.15 42%680000 Leases25,610.60 26,000.00 (389.40) 1.5% 153,771.57 153,250.00 521.57 309,250.00 155,478.43 50%690000 Miscellaneous Other Expense20,576.26 19,719.70 856.56 -4.3% 112,372.22 111,907.73 464.49 241,826.00 129,453.78 46%Total Expenses314,175.82 323,195.78 (9,019.96) 2.8% 1,895,658.68 1,947,267.18 51,608.50 3,812,542.00 1,916,883.32 50%36,367.22 37,216.83 (849.61) -2.3%(756,371.20) (848,025.86) 91,654.66 24,856.00 781,227.20 0%Rounds of Golf PlayedPaid Rounds Played4,227 4,100 127 3.1%17,260 16,855 405 42,173 24,913 41%Ave $ Per Paid Round Green Fee72.20 75.85 (3.65) -4.8%57.36 56.68 0.68 80.65 23.29 71%Ave $ Per Paid Round Merchandise5.64 6.25 (0.61) -9.8%4.96 5.18 (0.21) 6.57 1.61 76%Ave $ Per Paid Miscellaneous 7.73 8.81 (1.08) -12.2%6.12 5.83 0.28 7.16 1.05 85%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateDecember 20181 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees305,195.83 310,985.00 (5,789.17) 990,065.63 955,386.00 34,679.63 3,401,303.00 2,411,237.37 70.9%4010000 Rider Fee1,115.00 1,025.00 90.00 4,732.85 1,902.30 2,830.55 7,307.00 2,574.15 35.2%4040000 Club Rental3,450.00 2,050.00 1,400.00 9,230.00 6,436.50 2,793.50 21,087.00 11,857.00 56.2%4050000 Driving Range10,222.00 10,250.00 (28.00) 27,832.00 29,171.80 (1,339.80) 94,872.00 67,040.00 70.7%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - 75.00 2,000.00 (1,925.00) 4,000.00 3,925.00 98.1%4091000 Golf Professional Rental Fee 500.00 1,000.00 (500.00) 2,000.00 2,000.00 - 7,000.00 5,000.00 71.4%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue17,400.00 22,800.00 (5,400.00) 61,710.00 56,800.00 4,910.00 165,300.00 103,590.00 62.7% Total Revenue Fees337,882.83 348,110.00(10,227.17) 1,095,645.481,053,696.60 41,948.88 3,703,369.00 2,607,723.52 70.4%337,882.83 348,110.00(10,227.17) 1,095,645.481,053,696.60 41,948.88 3,703,369.00 2,607,723.52 70.4%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetDecember 20182 Actual BudgetVariance$11,690.19 $16,775.00(5,084.81)Favorable: Due to timing of invoices on two of the meters. Unable to get a reading or amount by phone.Actual BudgetVariance$26,909.99 $30,442.00(3,532.01)Favorable: Due to gift cards for employees was partially expensed in November 2018.Maintenance - Water & EnergyVariance ExplanationDecember 2018The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations areprovided for those cost of sales percentage that are greater than 5%.General and Administrative3-20-133 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous828.07 - 828.07 3,297.88 - 3,297.88 00 0%4100110 Sales Hard Goods7,625.04 6,406.25 1,218.79 32,501.64 21,812.50 10,689.14 69,288.00 36,786.36 53.1%4100112 Sales-Soft Goods18,341.00 19,218.75 (877.75) 62,658.00 65,437.50 (2,779.50) 207,863.00 145,205.00 69.9%5100639 GS-Discounts-Mdse (2,951.64) - (2,951.64) (12,795.05) - (12,795.05) - 12,795.05 0.0% Total Revenue Golf Shop23,842.47 25,625.00 (1,782.53) 85,662.47 87,250.00 (1,587.53) 277,151.00 194,786.41 70.3%COS 5100150 COS-GS-Hard Goods 3,807.66 3,585.58 222.08 17,219.86 12,208.46 5,011.40 40,187.04 22,967.18 57.2%5100151 COS-GS-Soft Goods 8,389.98 10,757.00 (2,367.02) 28,146.89 37,268.00 (9,121.11) 120,560.54 92,413.65 76.7%5100152 COS-GS-Purchase Disc (29.55) (743.13) 713.58 (137.59) (2,530.26) 2,392.67 (8,037.00) (7,899.41) 98.3%5100220 COS-GS-Freight Merch 514.20 222.94 291.26 2,791.52 759.08 2,032.44 2,411.00 (380.52) -15.8%Cost of Sales - Golf Shop12,682.29 13,822.39 (1,140.10) 48,020.68 47,705.28 315.40 155,121.58 107,100.90 69.0%Gross Profit 11,160.18 11,802.61 (642.43) 37,641.79 39,544.72 (1,902.93) 122,029.42 87,685.51 71.9%COS % 53.2% 53.9% 0.7% 56.1% 54.7% -1.4% 53.1% 55.0% 103.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group425.94 2,436.00 (2,010.06) 6,058.84 12,180.00 (6,121.16) 26,796.00 20,737.16 77.4%6101325 Insurance-Workers Comp 1,485.60 540.61 944.99 4,426.64 2,468.08 1,958.56 5,635.00 1,208.36 21.4%6101720 Salaries5,292.31 4,400.00 892.31 29,138.47 26,400.00 2,738.47 51,000.00 21,861.53 42.9%6101800 Taxes-Employer Payroll 1,094.45 1,874.12 (779.67) 6,438.36 8,555.99 (2,117.63) 19,935.00 13,496.64 67.7%6101880 Wages-Hourly12,016.25 10,016.30 1,999.95 51,964.75 39,415.27 12,549.48 98,874.00 46,909.25 47.4%6101882 Wages-Overtime200.64 - 200.64 339.40 - 339.40 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 20,515.19 19,267.03 1,248.16 98,366.46 89,019.34 9,347.12 202,240.00 105,165.82 52.0%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office349.41 250.00 99.41 812.78 1,500.00 (687.22) 3,000.00 2,187.22 72.9%6109220 Freight & Delivery37.03 25.00 12.03 37.03 75.00 (37.97) 75.00 37.97 50.6%6109490 Miscellaneous75.59 500.00 (424.41) 494.73 3,000.00 (2,505.27) 6,000.00 5,505.27 91.8%6109150 Dues and Subscriptions- - - 1,072.50 - 1,072.50 2,300.00 1,227.50 53.4%6109500 ProShop-Over/Short(17.81) - (17.81) 20.14 - 20.14 - (20.14) 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 Uniforms- 200.00 (200.00) 1,916.65 900.00 1,016.65 2,400.00 483.35 20.1%6117840 Telephones37.46 110.00 (72.54) 250.32 660.00 (409.68) 1,320.00 1,069.68 81.0%481.68 1,185.00 (703.32) 4,604.15 7,185.00 (2,580.85) 18,875.00 14,270.85 75.6%20,996.87 20,452.03 544.84 102,970.61 96,204.34 6,766.27 221,115.00 119,436.67 54.0%Net Income(9,836.69) (8,649.42) (1,187.27) (65,328.82) (56,659.62) (8,669.20) (99,085.58) (31,751.16) 32.0%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetDecember 20184 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,411.09 9,165.00 (753.91) 50,609.49 48,030.00 2,579.49 103,020.00 52,410.51 50.9%6311325 Insurance-Workers Comp3,416.88 2,352.00 1,064.88 14,397.08 13,242.00 1,155.08 26,974.00 12,576.92 46.6%6311720 Salaries12,715.38 12,476.92 238.46 75,099.98 74,861.52 238.46 146,400.00 71,300.02 48.7%6311800 Taxes-Employer Payroll4,708.22 8,154.00 (3,445.78) 30,498.93 46,439.00 (15,940.07) 94,048.00 63,549.07 67.6%6311880 Wages-Hourly62,752.94 50,246.08 12,506.86 281,150.41 270,011.48 11,138.93 564,695.00 283,544.59 50.2%6311882 Wages-Overtime7,464.65 - 7,464.65 41,513.14 12,350.00 29,163.14 12,350.00 (29,163.14) -236.1%Total-CM-SALARIES & BENEFITS99,469.16 82,394.00 17,075.16 493,269.03 464,934.00 28,335.03 947,487.00 454,217.97 47.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals1,846.64 - 1,846.64 26,015.78 8,380.00 17,635.78 17,760.00 (8,255.78) -46.5%6313744 Fertilizer1,010.70 8,820.00 (7,809.30) 52,148.82 66,880.00 (14,731.18) 100,520.00 48,371.18 48.1%6313745 Herbicides- - - 1,854.50 18,061.00 (16,206.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants- 750.00 (750.00) 2,971.85 2,000.00 971.85 3,050.00 78.15 2.6%6313748 Fuel-Gasoline3,457.56 4,150.00 (692.44) 21,856.09 24,250.00 (2,393.91) 46,860.00 25,003.91 53.4%6313750 Golf Course Accessories- - - 12,986.55 12,300.00 686.55 13,140.00 153.45 1.2%6313756 POA Control- 7,500.00 (7,500.00) 141.06 9,900.00 (9,758.94) 9,900.00 9,758.94 98.6%6313758 Miscellaneous Supp597.09 500.00 97.09 2,300.70 3,750.00 (1,449.30) 4,350.00 2,049.30 47.1%6313762 Supplies-Office44.48 - 44.48 2,368.01 - 2,368.01 - (2,368.01) 0.0%6313774 Sand- 800.00 (800.00) 4,062.01 12,580.00 (8,517.99) 13,460.00 9,397.99 69.8%6313776 Seed- - - 103,424.93 117,400.00 (13,975.07) 117,400.00 13,975.07 11.9%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) 1,640.97 4,400.00 (2,759.03) 5,000.00 3,359.03 67.2%6313780 Sod- - - 5,163.51 8,800.00 (3,636.49) 13,500.00 8,336.49 61.8%6313782 Topdressing- - - 4,849.65 7,000.00 (2,150.35) 10,000.00 5,150.35 51.5%Total-CM-SUPPLIES & MATERIALS6,956.47 22,620.00 (15,663.53) 241,784.43 295,701.00 (53,916.57) 380,458.00 138,673.57 36.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,850.00 3,850.00 - 17,275.00 23,100.00 (5,825.00) 46,200.00 28,925.00 62.6%6315685 CM-R&M-Bldngs & Othr Structures 590.30 500.00 90.30 5,165.04 4,050.00 1,115.04 5,550.00 384.96 6.9%6315690 CM-R&M-Equipment3,521.50 2,000.00 1,521.50 34,887.21 24,500.00 10,387.21 38,500.00 3,612.79 9.4%6315692 CM-R&M-Irrigation System1,452.37 550.00 902.37 12,885.30 12,850.00 35.30 19,050.00 6,164.70 32.4%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 7,513.30 6,000.00 1,513.30 10,500.00 2,986.70 28.4%6315815 CM-R&M-Trees-Pruning Etc- - - 5,190.00 6,050.00 (860.00) 12,050.00 6,860.00 56.9%Total-CM-REPAIRS & MAINTENANCE9,414.17 7,900.00 1,514.17 82,915.85 76,550.00 6,365.85 131,850.00 48,934.15 37.1%6317836 Utilities-Natural Gas/LPG 21.46 15.00 6.46 117.77 90.00 27.77 180.00 62.23 0.0%6317840 Telephones836.29 850.00 (13.71) 4,896.78 5,100.00 (203.22) 10,200.00 5,303.22 52.0%Total-CM-UTILITIES857.75 865.00 (7.25) 5,014.55 5,190.00 (175.45) 10,380.00 5,365.45 51.7%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- - - 691.38 1,000.00 (308.62) 2,000.00 1,308.62 65.4%6319102 Contract Svcs-Trash Removal104.02 524.00 (419.98) 520.10 3,144.00 (2,623.90) 6,288.00 5,767.90 91.7%6319150 Dues & Subscriptions365.00 - 365.00 840.00 - 840.00 680.00 (160.00) -23.5%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) - 2,300.00 (2,300.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- 50.00 (50.00) 827.05 400.00 427.05 4,300.00 3,472.95 80.8%6319490 Miscellaneous- 100.00 (100.00) 115.27 600.00 (484.73) 1,200.00 1,084.73 90.4%6319718 Safety Equipment & Training- 400.00 (400.00) 1,556.21 2,750.00 (1,193.79) 3,850.00 2,293.79 59.6%6319822 Uniforms799.46 920.00 (120.54) 5,344.06 5,520.00 (175.94) 11,040.00 5,695.94 51.6%Total-CM-OTHER EXPENSES1,668.48 2,644.00 (975.52) 12,294.07 18,414.00 (6,119.93) 41,458.00 29,163.93 70.3%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetDecember 2018Month to DateYear to Date5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,675.32 2,784.00 (108.68) 17,609.05 16,704.00 905.05 33,408.00 15,798.95 47.3%6321325 Insurance-Workers Comp742.80 500.00 242.80 3,500.75 3,037.00 463.75 5,955.00 2,454.25 41.2%6321800 Taxes-Employer Payroll592.75 1,733.00 (1,140.25) 5,622.14 10,677.00 (5,054.86) 20,793.00 15,170.86 73.0%6321880 Wages-Hourly12,984.16 13,334.00 (349.84) 76,932.02 78,714.00 (1,781.98) 156,528.00 79,595.98 50.9%6321882 Wages-Overtime112.00 - 112.00 2,741.69 3,418.00 (676.31) 3,418.00 676.31 19.8%Total-CM-LM-SALARIES & BENEFITS17,107.03 18,351.00 (1,243.97) 106,405.65 112,550.00 (6,144.35) 220,102.00 113,696.35 51.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) 233.75 575.00 (341.25) 1,025.00 791.25 77.2%6323788 Uniforms209.88 290.00 (80.12) 1,976.15 1,740.00 236.15 3,480.00 1,503.85 43.2%Total-CM-LM-SUPPLIES & MATERIALS209.88 365.00 (155.12) 2,209.90 2,315.00 (105.10) 4,505.00 2,295.10 50.9%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%135,682.94 135,639.00 43.94 943,893.48 978,154.00 (34,260.52) 1,740,490.00 796,596.52 45.8% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,201.32 9,685.00 (483.68) 69,876.48 61,166.00 8,710.48 179,791.00 109,914.52 61.1%6337842 Utilities-Water2,488.87 7,090.00 (4,601.13) 33,852.04 58,190.00 (24,337.96) 70,047.00 36,194.96 51.7%11,690.19 16,775.00 (5,084.81) 103,728.52 119,356.00 (15,627.48) 249,838.00 146,109.48 58.5%Silverrock ResortCourse Maintenance Water & EnergyDecember 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementDecember 2018Silverrock ResortAnnual BudgetMonth to DateYear to Date6 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group668.51 696.00 (27.49) 2,674.10 4,176.00 (1,501.90) 8,352.00 5,677.90 68.0%6411325 Insurance-Workers Comp1,782.72 668.25 1,114.47 4,896.44 2,311.46 2,584.98 6,172.00 1,275.56 20.7%6411800 Taxes-Employer Payroll1,839.83 2,218.59 (378.76) 6,389.66 7,674.00 (1,284.34) 20,493.00 14,103.34 68.8%6411880 Wages-Hourly18,322.88 17,820.00 502.88 68,492.10 61,638.50 6,853.60 164,599.00 96,106.90 58.4%6411882 Wages-Overtime429.83 - 429.83 877.76 - 877.76 - (877.76) 0.0%Total-CBR-SALARIES & BENEFITS23,043.7721,402.841,640.93 83,330.06 75,799.96 7,530.10 199,616.00 116,285.94 58.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts146.71 500.00 (353.29) 696.30 1,500.00 (803.70) 1,850.00 `0.0%6413742 Supplies-Expendable- 150.00 (150.00) 113.10 3,450.00 (3,336.90) 6,750.00 6,636.90 98.3%6413748 Supplies-Fuel for Shuttle309.70 400.00 (90.30) 309.70 900.00 (590.30) 3,000.00 2,690.30 89.7%6413752 Supplies-Range Balls- - - 10,568.25 9,000.00 1,568.25 9,000.00 (1,568.25) -17.4%6413762 Supplies-Office- 50.00 (50.00) 14.67 225.00 (210.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- - - 61.55 - 61.55 420.00 358.45 85.3%6413786 Supplies-Towels240.00 195.00 45.00 4,929.97 860.00 4,069.97 2,182.00 (2,747.97) -125.9%6413796 Supplies-Bottled Water340.39 100.00 240.39 19,572.80 5,000.00 14,572.80 12,900.00 (6,672.80) -51.7%Total-CBR-SUPPLIES & MATERIALS1,036.80 1,395.00 (358.20) 36,266.34 20,935.00 15,331.34 36,627.00 (793.04) -2.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 31.50 1,800.00 (1,768.50) 3,600.00 3,568.50 99.1%6415695 CBR-R&M-Cart Maintenance & Repair 4,330.51 500.00 3,830.51 13,506.75 3,450.00 10,056.75 6,450.00 (7,056.75) -109.4%Total-CBR-REPAIRS & MAINTENANCE4,330.51 800.00 3,530.51 13,538.25 5,250.00 8,288.25 10,050.00 (3,488.25) -34.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen992.90 800.00 192.90 3,962.22 4,800.00 (837.78) 9,600.00 5,637.78 58.7%6419220 Freight/Delivery- 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous183.22 600.00 (416.78) 821.27 3,600.00 (2,778.73) 7,200.00 6,378.73 88.6%6419820 Uniforms- 500.00 (500.00) 895.92 3,000.00 (2,104.08) 5,200.00 4,304.08 82.8%Total-CBR-OTHER EXPENSES1,176.12 1,975.00 (798.88) 5,679.41 11,850.00 (6,170.59) 22,450.00 16,770.59 74.7%TOTAL-CARTS,BAGROOM & RANGE29,587.2025,572.84(798.88) 138,814.06113,834.9624,979.10 268,743.00 128,775.24 47.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp742.80 332.06 410.74 2,362.23 1,023.48 1,338.75 2,630.00 267.77 10.2%6431800 Taxes-Employer Payroll439.61 1,151.15 (711.54) 2,132.21 3,548.03 (1,415.82) 9,117.00 6,984.79 76.6%6431880 Wages-Hourly6,736.00 8,855.00 (2,119.00) 25,404.75 27,292.50 (1,887.75) 70,133.00 44,728.25 63.8%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,918.41 10,338.21(2,419.80) 29,899.19 31,864.01 (1,964.82) 81,880.00 51,980.81 63.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 82.64 500.00 (417.36) 1,050.00 967.36 92.1%6439490 Miscellaneous- 50.00 (50.00) 155.70 150.00 5.70 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6439820 Uniforms- 250.00 (250.00) - 1,350.00 (1,350.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 450.00 (450.00) 238.34 2,300.00 (2,061.66) 3,975.00 3,736.66 94.0%Total-COURSE SERVICES7,918.41 10,788.21(2,869.80) 30,137.53 34,164.01 (4,026.48) 85,855.00 55,717.47 64.9%37,505.6136,361.051,144.56 168,951.59147,998.9720,952.62 354,598.00 180,756.05 51.0%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetDecember 20187 December Final 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 Gas307.35 300.00 7.35 2,150.86 1,800.00 350.86 3,600.00 1,449.14 40.3%6507840 Utilities-Telephone1,197.77 1,150.00 47.77 5,953.01 6,900.00 (946.99) 13,800.00 7,846.99 56.9%6507842 Utilities-Water760.76 321.00 439.76 4,976.23 1,926.00 3,050.23 3,852.00 (1,124.23) -29.2%6507844 Utilities-Cable495.80 380.00 115.80 2,974.88 2,280.00 694.88 4,560.00 1,585.12 34.8%Total-CH-UTILITIES2,761.68 2,151.00 610.68 16,054.98 12,906.00 3,148.98 25,812.00 9,757.02 37.8%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning350.00 1,825.00 (1,475.00) 2,949.00 11,550.00 (8,601.00) 22,500.00 19,551.00 86.9%6509099 Contract Services-Security5,673.56 5,000.00 673.56 32,176.33 30,000.00 2,176.33 60,000.00 27,823.67 46.4%6509215 Flowers & Decorations- - - - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 2,677.58 3,500.00 (822.42) 7,000.00 4,322.42 61.7%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 600.00 (348.53) 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES6,023.56 7,125.00 (1,101.44)38,054.38 46,150.00 (8,095.62) 92,600.00 54,545.62 58.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures739.10 300.00 439.10 6,204.40 1,800.00 4,404.40 3,600.00 (2,604.40) -72.3%6515686 CH-R&M-Restaurant Repairs818.37 400.00 418.37 1,193.37 2,400.00 (1,206.63) 4,800.00 3,606.63 75.1%6515690 CH-R&M-Equipment Repair128.36 400.00 (271.64) 128.36 2,400.00 (2,271.64) 4,800.00 4,671.64 97.3%Total-CH-REPAIRS & MAINTENANCE1,685.83 1,100.00 585.83 7,526.13 6,600.00 926.13 13,200.00 5,673.87 43.0%10,871.07 10,776.0095.07 64,035.49 68,056.00 (4,020.51) 136,412.00 11,347.74 8.3%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetDecember 20188 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 1,779.45 1,740.00 39.45 4,176.00 2,396.55 57.4%6601325 Insurance-Workers Comp89.01 94.00 (4.99) 476.58 470.00 6.58 1,129.00 652.42 57.8%6601720 Salaries1,905.20 2,508.00 (602.80) 9,526.00 12,540.00 (3,014.00) 30,096.00 20,570.00 68.3%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 726.00 1,630.00 (904.00) 3,912.00 3,186.00 81.4%Total-MKT-SALARIES & BENEFITS2,495.30 3,276.00 (780.70) 12,508.03 16,380.00 (3,871.97) 39,313.00 26,804.97 68.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office134.74 100.00 34.74 686.50 500.00 186.50 1,200.00 513.50 42.8%6603768 Supplies-Printing & Stationery454.17 200.00 254.17 2,184.98 3,400.00 (1,215.02) 4,425.00 2,240.02 50.6%588.91 300.00 288.91 2,871.48 3,900.00 (1,028.52) 5,625.00 2,753.52 49.0%66-MKT-UTILITIES6607840 Utilities-Telephone148.49 100.00 48.49 1,971.36 500.00 1,471.36 1,200.00 (771.36) -64.3%Total-MKT-UTILITIES148.49 100.00 48.49 1,971.36 500.00 1,471.36 1,200.00 (771.36) -64.3%66-MKT-OTHER EXPENSES6609010 Advertising24,533.01 25,680.00 (1,146.99) 58,824.77 57,189.00 1,635.77 169,987.00 111,162.23 65.4%6609040 Business Meals- 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material- 1,000.00 (1,000.00) 4,579.50 1,500.00 3,079.50 5,500.00 920.50 16.7%6609102 Contract Services-Web Page99.00 150.00 (51.00) 297.00 750.00 (453.00) 1,800.00 1,503.00 83.5%6609490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 700.00 100.00 600.00 700.00 - 0.0%6609633 Promotion-Community- 750.00 (750.00) 913.85 1,050.00 (136.15) 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 500.00 (500.00) 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) 299.07 350.00 (50.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES24,632.01 28,305.00 (3,672.99) 65,614.19 61,864.00 3,750.19 183,822.00 118,207.81 64.3%27,864.71 31,981.00 (4,116.29) 82,965.06 82,644.00 321.06 229,960.00 146,994.94 63.9%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetNovember 20189 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,630.48 1,509.00 1,121.48 13,728.93 9,054.00 4,674.93 18,108.00 4,379.07 24.2%6701325 Insurance-Workers Comp445.68 677.00 (231.32) 3,303.05 3,838.00 (534.95) 7,905.00 4,601.95 58.2%6701720 Salaries13,842.20 13,851.00 (8.80) 73,316.20 82,506.00 (9,189.80) 177,996.00 104,679.80 58.8%6701800 Taxes-Employer Payroll1,657.24 2,349.00 (691.76) 7,049.69 13,314.00 (6,264.31) 32,800.00 25,750.31 78.5%6701880 Wages-Hourly4,103.62 4,211.00 (107.38) 17,872.07 19,883.14 (2,011.07) 27,404.00 9,531.93 34.8%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS22,679.22 22,597.00 82.22 115,269.94 128,595.14 (13,325.20) 264,213.00 148,943.06 56.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer24.98 500.00 (475.02) 616.52 3,000.00 (2,383.48) 6,300.00 5,683.48 90.2%6703762 Supplies-Office- 105.00 (105.00) 265.31 630.00 (364.69) 1,260.00 994.69 78.9%6703768 Supplies-Printing & Stationery451.31 400.00 51.31 1,164.68 900.00 264.68 3,300.00 2,135.32 64.7%Total-G&A-SUPPLIES & MATERIALS476.29 1,005.00 (528.71) 2,046.51 4,530.00 (2,483.49) 10,860.00 8,813.49 81.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 683.14 1,300.00 (616.86) 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 683.14 1,300.00 (616.86) 1,900.00 1,216.86 64.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 & Subscriptions150.00 50.00 100.00 330.00 400.00 (70.00) 1,150.00 820.00 71.3%6709180 Employee Recruiting/Relocation102.00 200.00 (98.00) 588.26 650.00 (61.74) 1,200.00 611.74 51.0%6709197 Equipment Rental542.56 550.00 (7.44) 2,964.18 3,300.00 (335.82) 6,600.00 3,635.82 55.1%6709202 Fees-Bank6.00 90.00 (84.00) 329.69 540.00 (210.31) 1,080.00 750.31 69.5%6709208 Fees-Payroll Processing599.40 1,000.00 (400.60) 3,392.10 6,000.00 (2,607.90) 12,000.00 8,607.90 71.7%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous800.00 3,000.00 (2,200.00) 3,514.06 6,000.00 (2,485.94) 6,600.00 3,085.94 46.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 553.20 450.00 103.20 900.00 346.80 38.5%6709625 Professional Fees786.00 850.00 (64.00) 4,759.50 5,100.00 (340.50) 10,200.00 5,440.50 53.3%6709636 Promotion/Entertainment- 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 1,200.00 (950.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms268.52 75.00 900.00 957.27 600.00 357.27 1,050.00 92.73 8.8%Total-G&A-OTHER EXPENSES3,754.48 6,740.00 (2,279.04) 20,638.26 28,240.00 (7,601.74) 52,080.00 31,441.74 60.4%26,909.99 30,442.00 (3,532.01) 138,637.85 162,665.14 (24,027.29) 329,053.00 190,415.15 57.9%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetDecember 201810 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 58,975.63 60,750.00 (1,774.37) 121,050.00 62,074.37 51.3%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 55,087.20 57,000.00 (1,912.80) 114,000.00 58,912.80 51.7%6800194 Equipment Leases-Trailer658.07 600.00 58.07 4,133.42 3,600.00 533.42 7,200.00 3,066.58 42.6%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 23,220.00 23,400.00 (180.00) 46,800.00 23,580.00 50.4%6800197 Equipment Leases-Others2,072.06 1,950.00 122.06 12,355.32 8,500.00 3,855.32 20,200.00 7,844.68 0.0%25,610.60 26,000.00(389.40) 153,771.57153,250.00 521.57 309,250.00 155,478.4350.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 57,000.00 57,000.00 - 114,000.00 57,000.00 50.0%6900210 FF&E Reserve6,103.92 6,219.70 (115.78) 19,801.33 19,107.73 693.60 68,026.00 48,224.67 70.9%6900800 Personal Property Taxes- - - 14,738.21 11,800.00 2,938.21 11,800.00 (2,938.21) -24.9%6900323 Insurance-Commercial4,972.34 4,000.00 972.34 20,832.68 24,000.00 (3,167.32) 48,000.00 27,167.32 56.6%20,576.26 19,719.70856.56 112,372.22111,907.73 464.49 241,826.00 129,453.7853.5%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateDecember 201811 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-20192018 2018 2018 2018 2018 2018Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia2 4SalesPromotion4Golf IndustryVIPCelebrityPGA Comp18 208818Charity/Gift Certificate6244912Rain/Wind Checks223Club Staff13 37 42 14 39 58LQ HS Golf23121839 64 72 18 58 1132019 2019 2019 2019 2019 2019Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2018-2019December 2018 Date TimeDescriptionCategoryPlayers12/26/201811:30 AMFrank CullenPromo413