Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07 January 2018 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2017 – January 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 JanuaryFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue454,727.49 388,875.00 65,852.49 16.9% 1,159,300.60 1,116,548.00 42,752.60 2,964,060.00 1,804,759.40 39%401000 Miscellaneous Golf Revenue47,510.00 48,450.00 (940.00) -1.9% 146,849.00 154,763.00 (7,914.00) 166,766.00 19,917.00 88%410000 Revenue-Golf Shop28,165.36 31,251.00 (3,085.64) -9.9% 97,070.34 103,364.00 (6,293.66) 262,017.00 164,946.66 37%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%7,500.00 7,500.00 - 12,000.00 4,500.00 63%890000 Interest Income- - - 0.26 - 0.26 - (0.26) 0%Total Income531,902.85 470,076.00 61,826.85 13.2% 1,410,720.20 1,382,175.00 28,545.20 3,404,843.00 1,994,122.80 41%Cost of Goods Sold510000 COS-Golf Shop16,853.85 17,491.58 (637.73) 3.6% 60,180.33 57,853.12 (2,327.21) 146,651.00 86,470.67 41%Total COS16,853.85 17,491.58 (637.73) 3.6% 60,180.33 57,853.12 (2,327.21) 146,651.00 86,470.67 41%Gross Profit515,049.00 452,584.42 62,464.58 13.8% 1,350,539.87 1,324,321.88 26,217.99 3,258,192.00 1,907,652.13 41%Expenses610000 Golf Pro Shop 23,481.02 19,956.00 3,525.02 -17.7% 110,315.54 106,476.00 3,839.54 199,990.00 89,674.46 55%630000 Course Maintenance150,354.78 124,532.00 25,822.78 -20.7% 1,027,379.52 1,100,206.00 (72,826.48) 1,735,790.00 708,410.48 59%633000 Maintenance Water & Energy14,948.38 17,713.00 (2,764.62) 15.6% 134,597.54 137,069.00 (2,471.46) 249,838.00 115,240.46 54%640000 Outside Services40,779.48 36,298.00 4,481.48 -12.3% 183,731.85 180,506.00 3,225.85 331,964.00 148,232.15 55%650000 Clubhouse12,211.38 11,276.00 935.38 -8.3% 78,369.07 79,332.00 (962.93) 136,412.00 58,042.93 57%660000 Marketing25,748.21 26,378.00 (629.79) 2.4% 126,174.60 137,043.00 (10,868.40) 230,960.00 104,785.40 55%670000 General & Administrative23,431.36 27,545.00 (4,113.64) 14.9% 162,483.46 190,197.00 (27,713.54) 329,053.00 166,569.54 49%680000 Leases26,059.20 28,800.00 (2,740.80) 9.5% 177,781.30 177,050.00 731.30 321,050.00 143,268.70 55%690000 Miscellaneous Other Expense22,875.11 20,304.00 2,571.11 -12.7% 136,118.23 118,417.00 17,701.23 211,468.00 75,349.77 64%Total Expenses339,888.92 312,802.00 27,086.92 -8.7% 2,136,951.11 2,226,296.00 89,344.89 3,746,525.00 1,609,573.89 57%175,160.08 139,782.42 35,377.66 25.3%(786,411.24) (901,974.12) 115,562.88 (488,333.00) 298,078.24 0%Rounds of Golf PlayedPaid Rounds Played5,442 5,000 442 8.8%18,445 17,873 572 42,173 23,728 44%Ave $ Per Paid Round Green Fee83.56 77.78 5.78 7.4%62.85 62.47 0.38 70.28 7.43 89%Ave $ Per Paid Round Merchandise5.18 6.25 (1.07) -17.2%5.26 5.78 (0.52) 6.21 0.95 85%Ave $ Per Paid Miscellaneous 8.73 9.69 (0.96) -9.9%7.96 8.66 (0.70) 3.95 (4.01) 201%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJanuary 20181 Income JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees454,727.49 388,875.00 65,852.49 1,159,300.60 1,116,548.00 42,752.60 2,964,060.00 1,804,759.40 60.9%4010000 Rider Fee1,350.00 1,250.00 100.00 3,740.00 3,153.00 587.00 7,307.00 3,567.00 48.8%4040000 Club Rental2,975.00 2,500.00 475.00 10,615.00 8,938.00 1,677.00 21,087.00 10,472.00 49.7%4050000 Driving Range14,945.00 15,000.00 (55.00) 41,969.00 44,172.00 (2,203.00) 94,872.00 52,903.00 55.8%4060000 Handicap Fees- 1,700.00 (1,700.00) - 1,700.00 (1,700.00) 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- 1,000.00 (1,000.00) - 3,000.00 (3,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee 1,000.00 5,000.00 (4,000.00) 3,210.00 15,000.00 (11,790.00) 37,000.00 33,790.00 91.3%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue27,240.00 22,000.00 5,240.00 87,315.00 78,800.00 8,515.00 165,300.00 77,985.00 47.2% Total Revenue Fees502,237.49 437,325.00 64,912.49 1,306,149.60 1,271,311.00 34,838.60 3,296,126.00 1,989,976.40 60.4%502,237.49 437,325.00 64,912.49 1,306,149.60 1,271,311.00 34,838.60 3,296,126.00 1,989,976.40 60.4%SilverRock ResortStatement of Fees RevenueJanuary 2018Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$454,727.49$388,875.0065,852.49Favorable: Due to extremely excellent weather which allowed for full field play each day.ExpensesActualBudgetVariance$23,481.02 $19,956.00 3,525.02Unfavorable: Due to increased hours worked for the increase in business. Also, adjustment for for end of year payroll tax adjustment.ActualBudgetVariance$150,354.78$124,532.0025,822.78Unfavorable: Due to end of year payroll tax adjustment, timing of fertilizer invoices and irrigation repairs on the back 9.ActualBudgetVariance$14,948.38 $17,713.00 (2,764.62)Favorable: Due to runtimes on the front entrance waterfall.ActualBudgetVariance$40,779.48 $36,298.00 4,481.48Unfavorable: Due to end of year payroll tax adjustment.ActualBudgetVariance$25,748.21 $26,378.00 (629.79)Favorable: Due to reduced advertising spent. We are in align with the current year to date budget number.ActualBudgetVariance$23,431.36 $27,545.00 (4,113.64)Favorable: Due to reduced payroll, and line items. ActualBudgetVariance$22,875.11 $20,304.00 2,571.11Unfavorable: Due to payments for commerical insurance down payment.Golf ShopVariance ExplanationJanuary 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%.Golf Green Fee RevenueGolf Course MaintenanceGeneral and AdministrativeMarketingMiscellaneous Other ExpenseMaintenance Water and EnergyOutside Services3-20-133 Income JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous99.60 - 99.60 1,920.47 - 1,920.47 00 0%4100110 Sales Hard Goods8,455.99 10,938.00 (2,482.01) 34,667.90 36,178.00 (1,510.10) 91,706.00 57,038.10 62.2%4100112 Sales-Soft Goods21,660.00 20,313.00 1,347.00 74,031.42 67,186.00 6,845.42 170,311.00 96,279.58 56.5%5100639 GS-Discounts-Mdse (2,050.23) - (2,050.23) (13,549.45) - (13,549.45) - 13,549.45 0.0% Total Revenue Golf Shop28,165.36 31,251.00 (3,085.64) 97,070.34 103,364.00 (6,293.66) 262,017.00 166,867.13 63.7%COS 5100150 COS-GS-Hard Goods 5,818.99 6,344.04 (525.05) 20,499.56 20,983.24 (483.68) 53,189.48 32,689.92 61.5%5100151 COS-GS-Soft Goods 10,488.60 11,781.54 (1,292.94) 37,171.14 38,967.88 (1,796.74) 97,137.52 59,966.38 61.7%5100152 COS-GS-Purchase Disc (179.91) (906.00) 726.09 (187.53) (2,998.00) 2,810.47 (7,598.00) (7,410.47) 97.5%5100220 COS-GS-Freight Merch 726.17 272.00 454.17 2,697.16 900.00 1,797.16 2,280.00 (417.16) -18.3%Cost of Sales - Golf Shop16,853.85 17,491.58 (637.73) 60,180.33 57,853.12 2,327.21 145,009.00 84,828.67 58.5%Gross Profit11,311.51 13,759.42 (2,447.91) 36,890.01 45,510.88 (8,620.87) 117,008.00 82,038.46 70.1%COS % 59.8% 56.0% -3.9% 62.0% 56.0% -6.0% 53.1% 50.8% 95.8%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,404.84 2,436.00 (1,031.16) 11,845.72 14,616.00 (2,770.28) 26,796.00 14,950.28 55.8%6101325 Insurance-Workers Comp 471.20 478.00 (6.80) 3,637.34 2,635.00 1,002.34 4,957.00 1,319.66 26.6%6101720 Salaries4,400.00 4,001.00 399.00 28,600.00 28,007.00 593.00 45,000.00 16,400.00 36.4%6101800 Taxes-Employer Payroll 4,275.35 1,659.00 2,616.35 9,524.08 9,137.00 387.08 18,825.00 9,300.92 49.4%6101880 Wages-Hourly11,503.75 8,757.00 2,746.75 49,913.30 42,271.00 7,642.30 87,179.00 37,265.70 42.7%6101882 Wages-Overtime334.51 - 334.51 712.71 - 712.71 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 22,389.65 17,331.00 5,058.65 104,233.15 96,666.00 7,567.15 182,757.00 80,189.44 43.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office696.26 250.00 446.26 898.84 1,750.00 (851.16) 3,000.00 2,101.16 70.0%6109220 Freight & Delivery10.28 - 10.28 149.31 75.00 74.31 75.00 (74.31) -99.1%6109490 Miscellaneous15.00 500.00 (485.00) 1,340.02 3,500.00 (2,159.98) 6,000.00 4,659.98 77.7%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short18.65 - 18.65 184.14 - 184.14 - (184.14) 0.0%6109722 Seminars/Training- 1,250.00 (1,250.00) - 2,300.00 (2,300.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 15.00 (15.00) 90.00 90.00 100.0%6109820 Uniforms313.25 500.00 (186.75) 2,777.36 1,400.00 1,377.36 2,400.00 (377.36) -15.7%6117840 Telephones37.93 110.00 (72.07) 732.72 770.00 (37.28) 1,320.00 587.28 44.5%1,091.37 2,625.00 (1,533.63) 6,082.39 9,810.00 (3,727.61) 18,875.00 12,792.61 67.8%23,481.02 19,956.00 3,525.02 110,315.54 106,476.00 3,839.54 201,632.00 92,982.05 46.1%Net Income(12,169.51) (6,196.58) (5,972.93) (73,425.53) (60,965.12) (12,460.41) (84,624.00) (10,943.59) 12.9%SilverRock ResortGolf Shop Income StatementJanuary 2018Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,188.03 9,165.00 (976.97) 54,205.50 57,195.00 (2,989.50) 103,020.00 48,814.50 47.4%6311325 Insurance-Workers Comp2,169.20 2,352.00 (182.80) 16,878.32 15,594.00 1,284.32 26,974.00 10,095.68 37.4%6311720 Salaries12,476.92 12,200.00 276.92 82,662.64 85,400.00 (2,737.36) 146,400.00 63,737.36 43.5%6311800 Taxes-Employer Payroll12,093.42 8,154.00 3,939.42 36,248.40 54,593.00 (18,344.60) 91,481.00 55,232.60 60.4%6311880 Wages-Hourly50,510.00 50,523.00 (13.00) 309,171.31 322,166.00 (12,994.69) 567,262.00 258,090.69 45.5%6311882 Wages-Overtime1,275.86 - 1,275.86 46,613.50 12,350.00 34,263.50 12,350.00 (34,263.50) -277.4%Total-CM-SALARIES & BENEFITS86,713.43 82,394.00 4,319.43 545,779.67 547,298.00 (1,518.33) 947,487.00 401,707.33 42.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals18.00 3,033.00 (3,015.00) 14,242.49 29,474.00 (15,231.51) 17,760.00 3,517.51 19.8%6313744 Fertilizer10,605.41 4,000.00 6,605.41 44,611.28 72,880.00 (28,268.72) 105,970.00 61,358.72 57.9%6313745 Herbicides6,113.88 - 6,113.88 14,989.25 - 14,989.25 25,518.00 10,528.75 41.3%6313746 Flowers/Plants419.39 750.00 (330.61) 2,069.81 2,750.00 (680.19) 3,050.00 980.19 32.1%6313748 Fuel-Gasoline2,203.57 3,570.00 (1,366.43) 19,427.35 29,490.00 (10,062.65) 48,950.00 29,522.65 60.3%6313750 Golf Course Accessories1,793.78 - 1,793.78 13,375.56 12,300.00 1,075.56 13,140.00 (235.56) -1.8%6313756 POA Control- - - - 9,900.00 (9,900.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp724.83 100.00 624.83 5,503.19 3,850.00 1,653.19 4,350.00 (1,153.19) -26.5%6313762 Supplies-Office1,323.80 - 1,323.80 1,444.55 - 1,444.55 - (1,444.55) 0.0%6313774 Sand463.70 380.00 83.70 4,275.68 12,960.00 (8,684.32) 13,460.00 9,184.32 68.2%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 2,036.49 100.00 1,936.49 3,831.47 4,500.00 (668.53) 5,000.00 1,168.53 23.4%6313780 Sod772.13 - 772.13 8,251.24 8,800.00 (548.76) 13,500.00 5,248.76 38.9%6313782 Topdressing- - - 6,473.47 7,000.00 (526.53) 10,000.00 3,526.53 35.3%Total-CM-SUPPLIES & MATERIALS26,474.98 11,933.00 14,541.98 242,922.97 311,304.00 (68,381.03) 387,998.00 145,075.03 37.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 25,784.24 19,810.00 5,974.24 33,960.00 8,175.76 24.1%6315685 CM-R&M-Bldngs & Othr Structures 759.18 250.00 509.18 3,485.86 4,300.00 (814.14) 5,550.00 2,064.14 37.2%6315690 CM-R&M-Equipment2,674.48 2,500.00 174.48 23,463.18 27,000.00 (3,536.82) 38,500.00 15,036.82 39.1%6315692 CM-R&M-Irrigation System4,076.17 1,200.00 2,876.17 17,242.95 14,050.00 3,192.95 19,050.00 1,807.05 9.5%6315696 CM-R&M-Pumps3,005.26 1,000.00 2,005.26 6,470.13 7,000.00 (529.87) 10,500.00 4,029.87 38.4%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 & MAINTENANCE14,355.09 7,780.00 6,575.09 83,126.36 78,210.00 4,916.36 119,610.00 36,483.64 30.5%6317836 Utilities-Natural Gas/LPG 22.64 15.00 7.64 159.22 105.00 54.22 180.00 20.78 0.0%6317840 Telephones264.24 850.00 (585.76) 6,236.83 5,950.00 286.83 10,200.00 3,963.17 38.9%Total-CM-UTILITIES286.88 865.00 (578.12) 6,396.05 6,055.00 341.05 10,380.00 3,983.95 38.4%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 2,800.00 2,800.00 - 4,800.00 2,000.00 41.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) - 3,668.00 (3,668.00) 6,288.00 6,288.00 100.0%6319150 Dues & Subscriptions535.00 - 535.00 955.00 - 955.00 680.00 (275.00) -40.4%6319170 Employee Education- 50.00 (50.00) - 350.00 (350.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental2,622.38 200.00 2,422.38 4,407.67 2,500.00 1,907.67 3,400.00 (1,007.67) -29.6%6319206 Licenses & Permits- - - 359.29 400.00 (40.71) 4,300.00 3,940.71 91.6%6319490 Miscellaneous79.58 100.00 (20.42) 714.67 700.00 14.67 1,200.00 485.33 40.4%6319718 Safety Equipment & Training- 400.00 (400.00) 1,625.86 3,150.00 (1,524.14) 3,850.00 2,224.14 57.8%6319822 Uniforms1,501.46 920.00 581.46 6,165.44 6,440.00 (274.56) 11,040.00 4,874.56 44.2%Total-CM-OTHER EXPENSES5,138.42 2,594.00 2,544.42 17,027.93 21,008.00 (3,980.07) 41,458.00 24,430.07 58.9%SilverRock ResortCourse Maintenance Expense StatementJanuary 2018Annual BudgetMonth to DateYear to Date5 JanuaryFinal 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) 26,364.02 19,488.00 6,876.02 33,408.00 7,043.98 21.1%6321325 Insurance-Workers Comp421.70 500.00 (78.30) 3,603.28 3,537.00 66.28 5,955.00 2,351.72 39.5%6321800 Taxes-Employer Payroll3,150.05 1,733.00 1,417.05 10,642.96 12,410.00 (1,767.04) 20,793.00 10,150.04 48.8%6321880 Wages-Hourly11,183.96 13,334.00 (2,150.04) 85,581.08 92,048.00 (6,466.92) 156,528.00 70,946.92 45.3%6321882 Wages-Overtime- - - 1,973.86 3,418.00 (1,444.14) 3,418.00 1,444.14 42.3%Total-CM-LM-SALARIES & BENEFITS17,385.98 18,351.00 (965.02) 128,165.20 130,901.00 (2,735.80) 220,102.00 91,936.80 41.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) 386.77 650.00 (263.23) 1,025.00 638.23 62.3%6323788 Uniforms- 290.00 (290.00) 360.87 2,030.00 (1,669.13) 3,480.00 3,119.13 89.6%Total-CM-LM-SUPPLIES & MATERIALS- 365.00 (365.00) 747.64 2,680.00 (1,932.36) 4,505.00 3,757.36 83.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) 3,213.70 2,750.00 463.70 4,250.00 1,036.30 24.4%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) 3,213.70 2,750.00 463.70 4,250.00 1,036.30 24.4%150,354.78 124,532.00 25,822.78 1,027,379.52 1,100,206.00 (72,826.48) 1,735,790.00 708,410.48 40.8% JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,532.28 15,016.00 (2,483.72) 77,140.15 87,806.00 (10,665.85) 179,791.00 102,650.85 57.1%6337842 Utilities-Water2,416.10 2,697.00 (280.90) 57,457.39 49,263.00 8,194.39 70,047.00 12,589.61 18.0%14,948.38 17,713.00 (2,764.62) 134,597.54 137,069.00 (2,471.46) 249,838.00 115,240.46 46.1%Silverrock ResortCourse Maintenance Water & EnergyJanuary 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementJanuary 2018Silverrock ResortAnnual BudgetMonth to DateYear to Date6 JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 4,872.00 (4,872.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp668.05 671.00 (2.95) 4,476.72 2,906.00 1,570.72 5,623.00 1,146.28 20.4%6411800 Taxes-Employer Payroll4,451.18 2,228.00 2,223.18 8,851.38 9,648.00 (796.62) 18,667.00 9,815.62 52.6%6411880 Wages-Hourly17,239.79 17,895.00 (655.21) 69,535.99 77,500.00 (7,964.01) 149,934.00 80,398.01 53.6%6411882 Wages-Overtime 490.39 - 490.39 894.71 - 894.71 - (894.71) 0.0%Total-CBR-SALARIES & BENEFITS22,849.41 21,490.00 1,359.41 83,758.80 94,926.00 (11,167.20) 182,576.00 98,817.20 54.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 75.00 (75.00) 61.75 1,575.00 (1,513.25) 1,850.00 `0.0%6413742 Supplies-Expendable114.19 1,000.00 (885.81) 2,324.24 4,450.00 (2,125.76) 6,750.00 4,425.76 65.6%6413748 Supplies-Fuel for Shuttle201.31 450.00 (248.69) 201.31 1,350.00 (1,148.69) 3,000.00 2,798.69 93.3%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) - 275.00 (275.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) - 70.00 (70.00) 420.00 420.00 100.0%6413786 Supplies-Towels 160.00 250.00 (90.00) 1,778.35 1,110.00 668.35 2,182.00 403.65 18.5%6413796 Supplies-Bottled Water5,279.00 100.00 5,179.00 11,204.50 5,100.00 6,104.50 12,900.00 1,695.50 13.1%Total-CBR-SUPPLIES & MATERIALS5,754.50 1,995.00 3,759.50 26,336.40 22,930.00 3,406.40 36,627.00 8,502.35 23.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 22,280.89 2,100.00 20,180.89 3,600.00 (18,680.89) -518.9%6415695 CBR-R&M-Cart Maintenance & Repair 3,000.00 500.00 2,500.00 3,500.00 3,950.00 (450.00) 6,450.00 2,950.00 45.7%Total-CBR-REPAIRS & MAINTENANCE3,000.00 800.00 2,200.00 25,780.89 6,050.00 19,730.89 10,050.00 (15,730.89) -156.5%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen600.63 800.00 (199.37) 4,567.60 5,600.00 (1,032.40) 9,600.00 5,032.40 52.4%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous73.99 600.00 (526.01) 1,568.43 4,200.00 (2,631.57) 7,200.00 5,631.57 78.2%6419820 Uniforms - - - - 3,000.00 (3,000.00) 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES674.62 1,400.00 (725.38) 6,136.03 13,250.00 (7,113.97) 22,450.00 16,313.97 72.7%TOTAL-CARTS,BAGROOM & RANGE32,278.53 25,685.00 (725.38) 142,012.12 137,156.00 4,856.12 251,703.00 107,902.63 42.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp307.31 332.00 (24.69) 2,498.87 1,308.00 1,190.87 2,450.00 (48.87) -2.0%6431800 Taxes-Employer Payroll1,949.23 1,151.00 798.23 4,461.79 4,540.00 (78.21) 8,494.00 4,032.21 47.5%6431880 Wages-Hourly5,115.65 8,855.00 (3,739.35) 29,651.03 34,927.00 (5,275.97) 65,341.00 35,689.97 54.6%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,372.19 10,338.00 (2,965.81) 36,611.69 40,775.00 (4,163.31) 76,285.00 39,673.31 52.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 600.00 (600.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- 50.00 (50.00) - 200.00 (200.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6439820 Uniforms 1,128.76 75.00 1,053.76 5,108.04 1,425.00 3,683.04 2,125.00 (2,983.04) -140.4%Total-CS-OTHER EXPENSES1,128.76 275.00 853.76 5,108.04 2,575.00 2,533.04 3,975.00 (1,133.04) -28.5%Total-COURSE SERVICES8,500.95 10,613.00 (2,112.05) 41,719.73 43,350.00 (1,630.27) 80,260.00 38,540.27 48.0%40,779.48 36,298.00 4,481.48 183,731.85 180,506.00 3,225.85 331,963.00 147,575.94 44.5%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementJanuary 2018Annual Budget7 JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 2,800.00 2,800.00 - 4,800.00 2,000.00 41.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,800.00 2,800.00 - 4,800.00 2,000.00 41.7%65-CH-UTILITIES6507836 Utilities-Natural Gas211.05 300.00 (88.95) 2,076.59 2,100.00 (23.41) 3,600.00 1,523.41 42.3%6507840 Utilities-Telephone900.22 1,150.00 (249.78) 6,355.75 8,050.00 (1,694.25) 13,800.00 7,444.25 53.9%6507842 Utilities-Water209.40 321.00 (111.60) 1,825.81 2,247.00 (421.19) 3,852.00 2,026.19 52.6%6507844 Utilities-Cable494.41 380.00 114.41 3,453.05 2,660.00 793.05 4,560.00 1,106.95 24.3%Total-CH-UTILITIES1,815.08 2,151.00 (335.92) 13,711.20 15,057.00 (1,345.80) 25,812.00 12,100.80 46.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning75.00 1,825.00 (1,750.00) 11,230.00 13,375.00 (2,145.00) 22,500.00 11,270.00 50.1%6509099 Contract Services-Security7,961.28 5,000.00 2,961.28 37,267.90 35,000.00 2,267.90 60,000.00 22,732.10 37.9%6509215 Flowers & Decorations- 500.00 (500.00) - 1,000.00 (1,000.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous339.42 200.00 139.42 2,244.42 3,700.00 (1,455.58) 7,000.00 4,755.58 67.9%6509718 Safety Equipment & Training33.89 100.00 (66.11) 33.89 700.00 (666.11) 1,200.00 1,166.11 97.2%Total-CH-OTHER EXPENSES8,409.59 7,625.00 784.59 50,776.21 53,775.00 (2,998.79) 92,600.00 41,823.79 45.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,586.71 300.00 1,286.71 7,515.12 2,100.00 5,415.12 3,600.00 (3,915.12) -108.8%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,256.84 2,800.00 (1,543.16) 4,800.00 3,543.16 73.8%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,309.70 2,800.00 (490.30) 4,800.00 2,490.30 51.9%Total-CH-REPAIRS & MAINTENANCE1,586.71 1,100.00 486.71 11,081.66 7,700.00 3,381.66 13,200.00 2,118.34 16.0%12,211.38 11,276.00 935.38 78,369.07 79,332.00 (962.93) 136,412.00 4,236.68 3.1%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementJanuary 2018Annual Budget8 JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 351.02 348.00 3.02 2,805.14 2,436.00 369.14 4,176.00 1,370.86 32.8%6601325 Insurance-Workers Comp87.40 94.00 (6.60) 652.87 658.00 (5.13) 1,129.00 476.13 42.2%6601720 Salaries1,905.08 2,508.00 (602.92) 13,334.84 17,556.00 (4,221.16) 30,096.00 16,761.16 55.7%6601800 Taxes-Employer Payroll1,168.20 326.00 842.20 2,039.40 2,282.00 (242.60) 3,912.00 1,872.60 47.9%Total-MKT-SALARIES & BENEFITS3,511.70 3,276.00 235.70 18,832.25 22,932.00 (4,099.75) 39,313.00 20,480.75 52.1%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 588.85 700.00 (111.15) 1,200.00 611.15 50.9%6603768 Supplies-Printing & Stationery 3,053.96 200.00 2,853.96 5,241.05 3,800.00 1,441.05 4,425.00 (816.05) -18.4%3,118.13 300.00 2,818.13 5,829.90 4,500.00 1,329.90 5,625.00 (204.90) -3.6%66-MKT-UTILITIES6607840 Utilities-Telephone 30.49 100.00 (69.51) 894.25 700.00 194.25 1,200.00 305.75 25.5%Total-MKT-UTILITIES30.49 100.00 (69.51) 894.25 700.00 194.25 1,200.00 305.75 25.5%66-MKT-OTHER EXPENSES6609010 Advertising17,549.45 20,967.00 (3,417.55) 94,338.55 100,876.00 (6,537.45) 169,987.00 75,648.45 44.5%6609040 Business Meals- 25.00 (25.00) - 175.00 (175.00) 300.00 300.00 100.0%6609080 Collateral Material988.63 500.00 488.63 1,759.35 2,000.00 (240.65) 5,500.00 3,740.65 68.0%6609102 Contract Services-Web Page99.00 150.00 (51.00) 594.00 1,050.00 (456.00) 1,800.00 1,206.00 67.0%6609490 Miscellaneous- 50.00 (50.00) - 150.00 (150.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6609630 Promotion- 300.00 (300.00) 2,064.31 450.00 1,614.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community- 75.00 (75.00) 824.19 1,875.00 (1,050.81) 2,250.00 1,425.81 63.4%6609634 Promotion-Media/Vendor- 500.00 (500.00) 586.99 1,500.00 (913.01) 2,000.00 1,413.01 70.7%6609150 Dues and Subscriptions- 35.00 (35.00) - 35.00 (35.00) 735.00 735.00 100.0%6609820 Uniforms450.81 50.00 400.81 450.81 450.00 0.81 600.00 149.19 24.9%Total-MKT-OTHER EXPENSES19,087.89 22,702.00 (3,614.11) 100,618.20 108,911.00 (8,292.80) 184,822.00 84,203.80 45.6%25,748.21 26,378.00 (629.79) 126,174.60 137,043.00 (10,868.40) 230,960.00 104,785.40 45.4%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementJanuary 2018Annual Budget9 JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,930.24 1,509.00 421.24 12,734.10 10,563.00 2,171.10 18,108.00 5,373.90 29.7%6701325 Insurance-Workers Comp664.30 677.00 (12.70) 4,531.65 4,515.00 16.65 7,905.00 3,373.35 42.7%6701720 Salaries11,494.92 15,465.00 (3,970.08) 87,642.44 101,365.00 (13,722.56) 177,996.00 90,353.56 50.8%6701800 Taxes-Employer Payroll1,557.48 2,349.00 (791.52) 8,826.04 15,663.00 (6,836.96) 32,800.00 23,973.96 73.1%6701880 Wages-Hourly2,566.38 2,600.00 (33.62) 15,427.99 19,076.00 (3,648.01) 27,404.00 11,976.01 43.7%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS18,213.32 22,600.00 (4,386.68) 129,162.22 151,182.00 (22,019.78) 264,213.00 135,050.78 51.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer399.03 500.00 (100.97) 2,818.10 3,500.00 (681.90) 6,300.00 3,481.90 55.3%6703762 Supplies-Office84.20 105.00 (20.80) 292.55 735.00 (442.45) 1,260.00 967.45 76.8%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 1,407.36 1,300.00 107.36 3,300.00 1,892.64 57.4%Total-G&A-SUPPLIES & MATERIALS483.23 1,005.00 (521.77) 4,518.01 5,535.00 (1,016.99) 10,860.00 6,341.99 58.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 1,354.66 100.00 1,254.66 1,354.66 1,400.00 (45.34) 1,900.00 545.34 28.7%Total-G&A-REPAIRS & MAINTENANCE1,354.66 100.00 1,254.66 1,354.66 1,400.00 (45.34) 1,900.00 545.34 28.7%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 41.7%6709150 Dues & Subscriptions- 100.00 (100.00) 420.00 500.00 (80.00) 1,150.00 730.00 63.5%6709180 Employee Recruiting/Relocation180.00 150.00 30.00 701.95 800.00 (98.05) 1,200.00 498.05 41.5%6709197 Equipment Rental635.35 550.00 85.35 3,838.88 3,850.00 (11.12) 6,600.00 2,761.12 41.8%6709202 Fees-Bank115.52 90.00 25.52 1,585.00 630.00 955.00 1,080.00 (505.00) -46.8%6709208 Fees-Payroll Processing1,023.45 1,000.00 23.45 4,936.33 7,000.00 (2,063.67) 12,000.00 7,063.67 58.9%6709220 Freight/Delivery- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6709490 Miscellaneous32.63 100.00 (67.37) 3,539.95 6,100.00 (2,560.05) 6,600.00 3,060.05 46.4%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 1,054.59 525.00 529.59 900.00 (154.59) -17.2%6709625 Professional Fees402.30 850.00 (447.70) 5,360.81 5,950.00 (589.19) 10,200.00 4,839.19 47.4%6709636 Promotion/Entertainment161.89 100.00 61.89 326.10 700.00 (373.90) 1,200.00 873.90 72.8%6709722 Seminars & Training- 200.00 (200.00) 1,270.08 1,400.00 (129.92) 2,400.00 1,129.92 47.1%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms329.01 75.00 900.00 914.88 675.00 239.88 1,050.00 135.12 12.9%Total-G&A-OTHER EXPENSES3,380.15 3,840.00 186.14 27,448.57 32,080.00 (4,631.43) 52,080.00 24,631.43 47.3%23,431.36 27,545.00 (4,113.64) 162,483.46 190,197.00 (27,713.54) 329,053.00 166,569.54 50.6%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementJanuary 2018Annual Budget10 JanuaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 68,804.89 70,800.00 (1,995.11) 121,050.00 52,245.11 43.2%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 64,268.40 58,700.00 5,568.40 116,200.00 51,931.60 44.7%6800194 Equipment Leases-Trailer260.00 600.00 (340.00) 3,911.74 4,200.00 (288.26) 7,200.00 3,288.26 45.7%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 27,090.00 32,900.00 (5,810.00) 56,400.00 29,310.00 52.0%6800197 Equipment Leases-Others2,918.73 1,950.00 968.73 13,706.27 10,450.00 3,256.27 20,200.00 6,493.73 0.0%26,059.20 28,800.00 (2,740.80) 177,781.30 177,050.00 731.30 321,050.00 143,268.70 44.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,999.00 8,999.00 - 63,493.00 62,993.00 500.00 107,987.00 44,494.00 41.2%6900210 FF&E Reserve9,094.55 8,605.00 489.55 23,186.03 24,724.00 (1,537.97) 59,281.00 36,094.97 60.9%6900800 Personal Property Taxes- - - 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 34,339.55 18,900.00 15,439.55 32,400.00 (1,939.55) -6.0%22,875.11 20,304.00 2,571.11 136,118.23 118,417.00 17,701.23 211,468.00 75,349.77 35.6%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJanuary 2018Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic Course Comp Golf Report-2017-2018 2017 2017 2017 2017 2017 2017 Comp Category July August September October November December Media 13 5 Sales Promotion Golf Industry VIP Celebrity PGA Comp 20 12 27 5 16 Charity/Gift Certificate 2 2 13 10 Rain/Wind Checks 2 Club Staff 53 38 65 16 32 66 LQ HS Golf 10 6 6 3 8 26 85 58 98 19 71 125 2018 2018 2018 2018 2018 2018 Comp Category January February March April May June Media 4 Sales Promotion 4 Golf Industry VIP Celebrity PGA Comp 31 Charity/Gift Certificate 22 Rain/Wind Checks 5 Club Staff 31 LQ HS Golf 8 105 0 0 0 0 0 12 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-2018January 2018 Date TimeDescriptionCategoryPlayers1/8/2018 10:15:00 AM Marc Troast Promo 41/11/2018 7:00:00 AM Jason KoskyMedia413