Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
09 March 2018 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2017 – March 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 MarchFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue594,577.26 603,825.00 (9,247.74) -1.5% 2,293,287.26 2,384,568.00 (91,280.74) 3,270,479.00 977,191.74 70%401000 Miscellaneous Golf Revenue43,210.00 41,525.00 1,685.00 4.1% 231,044.00 247,313.00 (16,269.00) 332,066.00 101,022.00 70%410000 Revenue-Golf Shop40,054.46 42,000.00 (1,945.54) -4.6% 174,452.69 183,864.00 (9,411.31) 262,017.00 87,564.31 67%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 10,500.00 10,500.00 - 12,000.00 1,500.00 88%890000 Interest Income0.05 - 0.05 0.39 - 0.39 - (0.39) 0%Total Income679,341.77 688,850.00 (9,508.23) -1.4% 2,709,284.34 2,826,245.00 (116,960.66) 3,876,562.00 1,167,277.66 70%Cost of Goods Sold510000 COS-Golf Shop22,394.88 23,507.00 (1,112.12) 4.7% 102,268.41 102,908.12 639.71 146,651.00 44,382.59 70%Total COS22,394.88 23,507.00 (1,112.12) 4.7% 102,268.41 102,908.12 639.71 146,651.00 44,382.59 70%Gross Profit656,946.89 665,343.00 (8,396.11) -1.3% 2,607,015.93 2,723,336.88 (116,320.95) 3,729,911.00 1,122,895.07 70%Expenses610000 Golf Pro Shop 19,212.94 18,441.00 771.94 -4.2% 149,036.97 143,358.00 5,678.97 199,990.00 50,953.03 75%630000 Course Maintenance132,979.43 126,675.67 6,303.76 -5.0% 1,281,059.80 1,339,241.00 (58,181.20) 1,735,790.00 454,730.20 74%633000 Maintenance Water & Energy15,804.94 17,252.00 (1,447.06) 8.4% 165,796.86 171,469.00 (5,672.14) 249,838.00 84,041.14 66%640000 Outside Services34,665.24 34,718.00 (52.76) 0.2% 253,439.33 257,117.00 (3,677.67) 331,964.00 78,524.67 76%650000 Clubhouse11,033.42 13,576.00 (2,542.58) 18.7% 98,320.75 103,684.00 (5,363.25) 136,412.00 38,091.25 72%660000 Marketing25,243.30 23,831.00 1,412.30 -5.9% 174,364.84 184,937.00 (10,572.16) 230,960.00 56,595.16 75%670000 General & Administrative21,709.95 27,545.00 (5,835.05) 21.2% 203,125.42 245,537.00 (42,411.58) 329,053.00 125,927.58 62%680000 Leases25,524.23 28,800.00 (3,275.77) 11.4% 228,741.56 234,650.00 (5,908.44) 321,050.00 92,308.44 71%690000 Miscellaneous Other Expense25,672.11 23,776.00 1,896.11 -8.0% 185,828.71 164,783.00 21,045.71 217,596.00 31,767.29 85%Total Expenses311,845.56 314,614.67 (2,769.11) 0.9% 2,739,714.24 2,844,776.00 105,061.76 3,752,653.00 1,012,938.76 73%345,101.33 350,728.33 (5,627.00) -1.6%(132,698.31) (121,439.12) (11,259.19) (22,742.00) 109,956.31 0%Rounds of Golf PlayedPaid Rounds Played6,263 6,000 263 4.4%30,145 29,373 772 42,173 12,028 71%Ave $ Per Paid Round Green Fee94.93 100.64 (5.70) -5.7%76.08 81.18 (5.11) 77.55 1.47 98%Ave $ Per Paid Round Merchandise6.40 7.00 (0.60) -8.6%5.79 6.26 (0.47) 6.21 0.43 93%Ave $ Per Paid Miscellaneous 6.90 6.92 (0.02) -0.3%7.66 8.42 (0.76) 7.87 0.21 97%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMarch 20181 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees594,577.26 603,825.00 (9,247.74) 2,293,287.26 2,384,568.00 (91,280.74) 2,964,060.00 670,772.74 22.6%4010000 Rider Fee2,075.00 1,500.00 575.00 7,215.00 6,028.00 1,187.00 7,307.00 92.00 1.3%4040000 Club Rental5,265.00 3,000.00 2,265.00 19,580.00 14,688.00 4,892.00 21,087.00 1,507.00 7.1%4050000 Driving Range16,725.00 15,000.00 1,725.00 76,484.00 75,672.00 812.00 94,872.00 18,388.00 19.4%4060000 Handicap Fees- 400.00 (400.00) - 2,500.00 (2,500.00) 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - - 3,000.00 (3,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee 500.00 6,000.00 (5,500.00) 4,210.00 27,000.00 (22,790.00) 37,000.00 32,790.00 88.6%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue18,645.00 15,625.00 3,020.00 123,555.00 118,425.00 5,130.00 165,300.00 41,745.00 25.3% Total Revenue Fees637,787.26 645,350.00(7,562.74) 2,524,331.262,631,881.00 (107,549.74)3,296,126.00 771,794.74 23.4%637,787.26 645,350.00(7,562.74) 2,524,331.262,631,881.00 (107,549.74)3,296,126.00 771,794.74 23.4%SilverRock ResortStatement of Fees RevenueMarch 2018Total IncomeMonth to DateYear to DateAnnual Budget2 ActualBudgetVariance$11,033.42$13,576.00(2,542.58)Favorable: Due to in house janitorial service, and reduced miscellaneous expenses.ActualBudgetVariance$21,709.95$27,545.00(5,835.05)Favorable: Due to reduced payroll, and line items. ActualBudgetVariance$25,471.92$28,800.00(3,328.08)Variance ExplanationMarch 2018General and AdministrativeClubhouseLeases3 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,136.67 - 1,136.67 3,093.64 - 3,093.64 00 0%4100110 Sales Hard Goods 14,225.51 14,700.00 (474.49) 60,551.26 64,353.00 (3,801.74) 91,706.00 31,154.74 34.0%4100112 Sales-Soft Goods28,263.56 27,300.00 963.56 131,036.98 119,511.00 11,525.98 170,311.00 39,274.02 23.1%5100639 GS-Discounts-Mdse (3,571.28) - (3,571.28) (20,229.19) - (20,229.19) - 20,229.19 0.0% Total Revenue Golf Shop40,054.46 42,000.00 (1,945.54) 174,452.69 183,864.00 (9,411.31) 262,017.00 90,657.95 34.6%COS 5100150 COS-GS-Hard Goods 7,301.00 8,526.00 (1,225.00) 34,450.10 37,324.74 (2,874.64) 53,189.48 18,739.38 35.2%5100151 COS-GS-Soft Goods 14,527.97 15,834.00 (1,306.03) 64,497.48 69,316.38 (4,818.90) 97,137.52 32,640.04 33.6%5100152 COS-GS-Purchase Disc (21.84) (1,218.00) 1,196.16 (232.77) (5,333.00) 5,100.23 (7,598.00) (7,365.23) 96.9%5100220 COS-GS-Freight Merch 587.75 365.00 222.75 3,553.60 1,600.00 1,953.60 2,280.00 (1,273.60) -55.9%Cost of Sales - Golf Shop22,394.88 23,507.00 (1,112.12) 102,268.41 102,908.12 (639.71) 145,009.00 42,740.59 29.5%Gross Profit17,659.58 18,493.00 (833.42) 72,184.28 80,955.88 (8,771.60) 117,008.00 47,917.36 41.0%COS % 55.9% 56.0% 0.1% 58.6% 56.0% -2.7% 53.1% 47.1% 88.8%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,639.79 2,436.00 (796.21) 14,963.47 19,488.00 (4,524.53) 26,796.00 11,832.53 44.2%6101325 Insurance-Workers Comp 361.40 478.00 (116.60) 4,904.61 3,591.00 1,313.61 4,957.00 52.39 1.1%6101720 Salaries4,400.00 4,001.00 399.00 37,400.00 36,009.00 1,391.00 45,000.00 7,600.00 16.9%6101800 Taxes-Employer Payroll 1,798.78 1,659.00 139.78 13,362.97 12,455.00 907.97 18,825.00 5,462.03 29.0%6101880 Wages-Hourly10,165.25 8,757.00 1,408.25 70,206.55 59,785.00 10,421.55 87,179.00 16,972.45 19.5%6101882 Wages-Overtime346.14 - 346.14 1,199.50 - 1,199.50 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 18,711.36 17,331.00 1,380.36 142,037.10 131,328.00 10,709.10 182,757.00 42,872.28 23.5%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office308.37 250.00 58.37 1,406.40 2,250.00 (843.60) 3,000.00 1,593.60 53.1%6109220 Freight & Delivery- - - 169.49 75.00 94.49 75.00 (94.49) -126.0%6109490 Miscellaneous111.48 500.00 (388.52) 1,501.50 4,500.00 (2,998.50) 6,000.00 4,498.50 75.0%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short(6.35) - (6.35) 197.40 - 197.40 - (197.40) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 2,370.00 (2,370.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 45.00 (45.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 2,866.35 1,800.00 1,066.35 2,400.00 (466.35) -19.4%6117840 Telephones88.08 110.00 (21.92) 858.73 990.00 (131.27) 1,320.00 461.27 34.9%501.58 1,110.00 (608.42) 6,999.87 12,030.00 (5,030.13) 18,875.00 11,875.13 62.9%19,212.94 18,441.00 771.94 149,036.97 143,358.00 5,678.97 201,632.00 54,747.41 27.2%Net Income(1,553.36) 52.00 (1,605.36) (76,852.69) (62,402.12) (14,450.57) (84,624.00) (6,830.05) 8.1%SilverRock ResortGolf Shop Income StatementMarch 2018Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group9,175.74 9,165.00 10.74 71,863.37 75,525.00 (3,661.63) 103,020.00 31,156.63 30.2%6311325 Insurance-Workers Comp2,141.70 2,352.00 (210.30) 21,608.22 20,070.00 1,538.22 26,974.00 5,365.78 19.9%6311720 Salaries12,476.92 12,200.00 276.92 107,616.48 109,800.00 (2,183.52) 146,400.00 38,783.52 26.5%6311800 Taxes-Employer Payroll7,638.59 8,154.00 (515.41) 51,323.58 70,112.00 (18,788.42) 91,481.00 40,157.42 43.9%6311880 Wages-Hourly42,071.30 50,523.67 (8,452.37) 397,581.76 417,142.00 (19,560.24) 567,262.00 169,680.24 29.9%6311882 Wages-Overtime6,874.87 - 6,874.87 57,275.78 12,350.00 44,925.78 12,350.00 (44,925.78) -363.8%Total-CM-SALARIES & BENEFITS80,379.12 82,394.67 (2,015.55) 707,269.19 704,999.00 2,270.19 947,487.00 240,217.81 25.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals18.00 1,806.00 (1,788.00) 15,156.84 31,470.00 (16,313.16) 17,760.00 2,603.16 14.7%6313744 Fertilizer10,418.56 3,370.00 7,048.56 59,003.32 79,270.00 (20,266.68) 105,970.00 46,966.68 44.3%6313745 Herbicides4,303.94 - 4,303.94 19,293.19 - 19,293.19 25,518.00 6,224.81 24.4%6313746 Flowers/Plants- 100.00 (100.00) 2,738.08 2,950.00 (211.92) 3,050.00 311.92 10.2%6313748 Fuel-Gasoline7,424.09 4,050.00 3,374.09 27,514.55 37,420.00 (9,905.45) 48,950.00 21,435.45 43.8%6313750 Golf Course Accessories1,397.93 - 1,397.93 14,817.40 12,460.00 2,357.40 13,140.00 (1,677.40) -12.8%6313756 POA Control- - - - 9,900.00 (9,900.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp802.18 100.00 702.18 7,551.96 4,050.00 3,501.96 4,350.00 (3,201.96) -73.6%6313762 Supplies-Office167.13 - 167.13 1,924.87 - 1,924.87 - (1,924.87) 0.0%6313774 Sand- 100.00 (100.00) 4,275.68 13,160.00 (8,884.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- 100.00 (100.00) 3,831.47 4,700.00 (868.53) 5,000.00 1,168.53 23.4%6313780 Sod- - - 9,023.37 8,800.00 223.37 13,500.00 4,476.63 33.2%6313782 Topdressing- - - 6,473.47 7,000.00 (526.53) 10,000.00 3,526.53 35.3%Total-CM-SUPPLIES & MATERIALS24,531.83 9,626.00 14,905.83 276,031.83 328,580.00 (52,548.17) 387,998.00 111,966.17 28.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 33,464.24 25,470.00 7,994.24 33,960.00 495.76 1.5%6315685 CM-R&M-Bldngs & Othr Structures 77.41 250.00 (172.59) 7,238.20 4,800.00 2,438.20 5,550.00 (1,688.20) -30.4%6315690 CM-R&M-Equipment2,330.95 2,000.00 330.95 28,941.96 31,500.00 (2,558.04) 38,500.00 9,558.04 24.8%6315692 CM-R&M-Irrigation System1,717.76 1,000.00 717.76 19,513.20 16,050.00 3,463.20 19,050.00 (463.20) -2.4%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 9,110.58 9,000.00 110.58 10,500.00 1,389.42 13.2%6315815 CM-R&M-Trees-Pruning Etc- 2,000.00 (2,000.00) 6,680.00 8,050.00 (1,370.00) 12,050.00 5,370.00 44.6%Total-CM-REPAIRS & MAINTENANCE7,966.12 9,080.00 (1,113.88) 104,948.18 94,870.00 10,078.18 119,610.00 14,661.82 12.3%6317836 Utilities-Natural Gas/LPG 24.21 15.00 9.21 206.56 135.00 71.56 180.00 (26.56) 0.0%6317840 Telephones816.45 850.00 (33.55) 7,874.26 7,650.00 224.26 10,200.00 2,325.74 22.8%Total-CM-UTILITIES840.66 865.00 (24.34) 8,080.82 7,785.00 295.82 10,380.00 2,299.18 22.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.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 Removal59.55 524.00 (464.45) 119.10 4,716.00 (4,596.90) 6,288.00 6,168.90 98.1%6319150 Dues & Subscriptions210.00 - 210.00 1,165.00 200.00 965.00 680.00 (485.00) -71.3%6319170 Employee Education- 2,400.00 (2,400.00) - 3,750.00 (3,750.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) 4,407.67 2,900.00 1,507.67 3,400.00 (1,007.67) -29.6%6319206 Licenses & Permits- 1,000.00 (1,000.00) 359.29 1,400.00 (1,040.71) 4,300.00 3,940.71 91.6%6319490 Miscellaneous65.36 100.00 (34.64) 780.03 900.00 (119.97) 1,200.00 419.97 35.0%6319718 Safety Equipment & Training250.00 200.00 50.00 2,138.88 3,550.00 (1,411.12) 3,850.00 1,711.12 44.4%6319822 Uniforms1,251.85 920.00 331.85 8,583.68 8,280.00 303.68 11,040.00 2,456.32 22.2%Total-CM-OTHER EXPENSES2,236.76 5,744.00 (3,507.24) 21,153.65 30,296.00 (9,142.35) 41,458.00 20,304.35 49.0%SilverRock ResortCourse Maintenance Expense StatementMarch 2018Annual BudgetMonth to DateYear to Date5 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,731.80 2,784.00 (52.20) 31,864.45 25,056.00 6,808.45 33,408.00 1,543.55 4.6%6321325 Insurance-Workers Comp397.20 500.00 (102.80) 4,647.53 4,487.00 160.53 5,955.00 1,307.47 22.0%6321800 Taxes-Employer Payroll881.36 1,733.00 (851.64) 12,605.74 15,704.00 (3,098.26) 20,793.00 8,187.26 39.4%6321880 Wages-Hourly13,014.58 13,334.00 (319.42) 107,927.22 117,386.00 (9,458.78) 156,528.00 48,600.78 31.0%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,024.94 18,351.00 (1,326.06) 159,018.80 166,051.00 (7,032.20) 220,102.00 61,083.20 27.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) 386.77 800.00 (413.23) 1,025.00 638.23 62.3%6323788 Uniforms- 290.00 (290.00) 956.86 2,610.00 (1,653.14) 3,480.00 2,523.14 72.5%Total-CM-LM-SUPPLIES & MATERIALS- 365.00 (365.00) 1,343.63 3,410.00 (2,066.37) 4,505.00 3,161.37 70.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) 3,213.70 3,250.00 (36.30) 4,250.00 1,036.30 24.4%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) 3,213.70 3,250.00 (36.30) 4,250.00 1,036.30 24.4%132,979.43 126,675.67 6,303.76 1,281,059.80 1,339,241.00 (58,181.20) 1,735,790.00 454,730.20 26.2% MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 13,083.61 15,005.00 (1,921.39) 104,311.11 117,827.00 (13,515.89) 179,791.00 75,479.89 42.0%6337842 Utilities-Water2,721.33 2,247.00 474.33 61,485.75 53,642.00 7,843.75 70,047.00 8,561.25 12.2%15,804.94 17,252.00 (1,447.06) 165,796.86 171,469.00 (5,672.14) 249,838.00 84,041.14 33.6%Silverrock ResortCourse Maintenance Water & EnergyMarch 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementMarch 2018Silverrock ResortAnnual BudgetMonth to DateYear to Date6 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 6,264.00 (6,264.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp501.40 631.00 (129.60) 6,660.45 4,168.00 2,492.45 5,623.00 (1,037.45) -18.5%6411800 Taxes-Employer Payroll2,832.67 2,093.00 739.67 14,326.35 13,834.00 492.35 18,667.00 4,340.65 23.3%6411880 Wages-Hourly18,166.51 16,815.00 1,351.51 104,805.95 111,130.00 (6,324.05) 149,934.00 45,128.05 30.1%6411882 Wages-Overtime1,486.04 - 1,486.04 3,239.75 - 3,239.75 - (3,239.75) 0.0%Total-CBR-SALARIES & BENEFITS22,986.6220,235.002,751.62 129,032.50135,396.00(6,363.50) 182,576.00 53,543.50 29.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts141.98 50.00 91.98 203.73 1,700.00 (1,496.27) 1,850.00 `0.0%6413742 Supplies-Expendable421.76 150.00 271.76 3,652.98 5,600.00 (1,947.02) 6,750.00 3,097.02 45.9%6413748 Supplies-Fuel for Shuttle219.18 450.00 (230.82) 420.49 2,250.00 (1,829.51) 3,000.00 2,579.51 86.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) - 375.00 (375.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) - 210.00 (210.00) 420.00 420.00 100.0%6413786 Supplies-Towels483.60 250.00 233.60 2,581.95 1,610.00 971.95 2,182.00 (399.95) -18.3%6413796 Supplies-Bottled Water- 200.00 (200.00) 11,312.25 12,300.00 (987.75) 12,900.00 1,587.75 12.3%Total-CBR-SUPPLIES & MATERIALS1,266.52 1,220.00 46.52 28,937.65 33,045.00 (4,107.35) 36,627.00 6,043.08 16.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 22,530.96 2,700.00 19,830.96 3,600.00 (18,930.96) -525.9%6415695 CBR-R&M-Cart Maintenance & Repair 440.00 500.00 (60.00) 4,060.70 4,950.00 (889.30) 6,450.00 2,389.30 37.0%Total-CBR-REPAIRS & MAINTENANCE440.00 800.00 (360.00) 26,591.66 7,650.00 18,941.66 10,050.00 (16,541.66) -164.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen712.39 800.00 (87.61) 6,605.40 7,200.00 (594.60) 9,600.00 2,994.60 31.2%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous151.93 600.00 (448.07) 2,028.29 5,400.00 (3,371.71) 7,200.00 5,171.71 71.8%6419820 Uniforms- 500.00 (500.00) 351.53 3,500.00 (3,148.47) 5,200.00 4,848.47 93.2%Total-CBR-OTHER EXPENSES864.32 1,900.00 (1,035.68) 8,985.22 16,550.00 (7,564.78) 22,450.00 13,464.78 60.0%TOTAL-CARTS,BAGROOM & RANGE25,557.4624,155.00(1,035.68) 193,547.03192,641.00906.03 251,703.00 56,509.70 22.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp209.10 332.00 (122.90) 3,484.43 1,972.00 1,512.43 2,450.00 (1,034.43) -42.2%6431800 Taxes-Employer Payroll1,105.50 1,151.00 (45.50) 6,642.37 6,842.00 (199.63) 8,494.00 1,851.63 21.8%6431880 Wages-Hourly7,304.00 8,855.00 (1,551.00) 44,168.28 52,637.00 (8,468.72) 65,341.00 21,172.72 32.4%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS8,618.60 10,338.00(1,719.40) 54,295.08 61,451.00 (7,155.92) 76,285.00 21,989.92 28.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable489.18 100.00 389.18 489.18 800.00 (310.82) 1,050.00 560.82 53.4%6439490 Miscellaneous- - - - 200.00 (200.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) 5,108.04 1,575.00 3,533.04 2,125.00 (2,983.04) -140.4%Total-CS-OTHER EXPENSES489.18 225.00 264.18 5,597.22 3,025.00 2,572.22 3,975.00 (1,622.22) -40.8%Total-COURSE SERVICES9,107.78 10,563.00(1,455.22) 59,892.30 64,476.00 (4,583.70) 80,260.00 20,367.70 25.4%34,665.2434,718.00(52.76) 253,439.33257,117.00(3,677.67) 331,963.00 78,499.62 23.6%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementMarch 2018Annual Budget7 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%65-CH-UTILITIES6507836 Utilities-Natural Gas541.83 300.00 241.83 2,956.66 2,700.00 256.66 3,600.00 643.34 17.9%6507840 Utilities-Telephone1,230.56 1,150.00 80.56 7,933.96 10,350.00 (2,416.04) 13,800.00 5,866.04 42.5%6507842 Utilities-Water713.60 321.00 392.60 3,241.13 2,889.00 352.13 3,852.00 610.87 15.9%6507844 Utilities-Cable494.41 380.00 114.41 4,441.87 3,420.00 1,021.87 4,560.00 118.13 2.6%Total-CH-UTILITIES2,980.40 2,151.00 829.40 18,573.62 19,359.00 (785.38) 25,812.00 7,238.38 28.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning400.00 1,825.00 (1,425.00) 12,429.62 17,025.00 (4,595.38) 22,500.00 10,070.38 44.8%6509099 Contract Services-Security5,544.72 5,000.00 544.72 47,524.30 45,000.00 2,524.30 60,000.00 12,475.70 20.8%6509215 Flowers & Decorations- 500.00 (500.00) - 1,500.00 (1,500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous170.43 2,500.00 (2,329.57) 2,414.85 6,400.00 (3,985.15) 7,000.00 4,585.15 65.5%6509718 Safety Equipment & Training- 100.00 (100.00) 194.15 900.00 (705.85) 1,200.00 1,005.85 83.8%Total-CH-OTHER EXPENSES6,115.15 9,925.00 (3,809.85)62,562.92 70,825.00 (8,262.08)92,600.00 30,037.08 32.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,537.87 300.00 1,237.87 10,017.67 2,700.00 7,317.67 3,600.00 (6,417.67) -178.3%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,256.84 3,600.00 (2,343.16) 4,800.00 3,543.16 73.8%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,309.70 3,600.00 (1,290.30)4,800.00 2,490.30 51.9%Total-CH-REPAIRS & MAINTENANCE1,537.87 1,100.00 437.87 13,584.21 9,900.00 3,684.21 13,200.00 (384.21) -2.9%11,033.42 13,576.00(2,542.58)98,320.75 103,684.00(5,363.25)136,412.00 (768.42) -0.6%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementMarch 2018Annual Budget8 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 3,512.05 3,132.00 380.05 4,176.00 663.95 15.9%6601325 Insurance-Workers Comp87.20 94.00 (6.80) 831.27 846.00 (14.73) 1,129.00 297.73 26.4%6601720 Salaries1,905.20 2,508.00 (602.80) 17,145.24 22,572.00 (5,426.76) 30,096.00 12,950.76 43.0%6601800 Taxes-Employer Payroll212.20 326.00 (113.80) 2,396.80 2,934.00 (537.20) 3,912.00 1,515.20 38.7%Total-MKT-SALARIES & BENEFITS2,560.49 3,276.00 (715.51) 23,885.36 29,484.00 (5,598.64) 39,313.00 15,427.64 39.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 925.05 900.00 25.05 1,200.00 274.95 22.9%6603768 Supplies-Printing & Stationery 647.88 125.00 522.88 6,268.30 4,050.00 2,218.30 4,425.00 (1,843.30) -41.7%712.05 225.00 487.05 7,193.35 4,950.00 2,243.35 5,625.00 (1,568.35) -27.9%66-MKT-UTILITIES6607840 Utilities-Telephone 175.96 100.00 75.96 1,220.70 900.00 320.70 1,200.00 (20.70) -1.7%Total-MKT-UTILITIES175.96 100.00 75.96 1,220.70 900.00 320.70 1,200.00 (20.70) -1.7%66-MKT-OTHER EXPENSES6609010 Advertising18,411.93 18,980.00 (568.07) 129,703.26 138,468.00 (8,764.74) 169,987.00 40,283.74 23.7%6609040 Business Meals- 25.00 (25.00) - 225.00 (225.00) 300.00 300.00 100.0%6609080 Collateral Material1,818.41 500.00 1,318.41 6,178.41 3,000.00 3,178.41 5,500.00 (678.41) -12.3%6609102 Contract Services-Web Page396.00 150.00 246.00 1,089.00 1,350.00 (261.00) 1,800.00 711.00 39.5%6609490 Miscellaneous- 50.00 (50.00) - 250.00 (250.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 2,064.31 550.00 1,514.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community- 75.00 (75.00) 824.19 2,025.00 (1,200.81) 2,250.00 1,425.81 63.4%6609634 Promotion-Media/Vendor1,168.46 - 1,168.46 1,755.45 2,000.00 (244.55) 2,000.00 244.55 12.2%6609150 Dues and Subscriptions- 300.00 (300.00) - 735.00 (735.00) 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) 450.81 550.00 (99.19) 600.00 149.19 24.9%Total-MKT-OTHER EXPENSES21,794.80 20,230.00 1,564.80 142,065.43 149,603.00 (7,537.57) 184,822.00 42,756.57 23.1%25,243.30 23,831.00 1,412.30 174,364.84 184,937.00 (10,572.16) 230,960.00 56,595.16 24.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementMarch 2018Annual Budget9 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,920.96 1,509.00 411.96 16,659.36 13,581.00 3,078.36 18,108.00 1,448.64 8.0%6701325 Insurance-Workers Comp502.17 677.00 (174.83) 5,422.05 5,869.00 (446.95) 7,905.00 2,482.95 31.4%6701720 Salaries11,494.80 15,465.00 (3,970.20) 110,632.04 132,295.00 (21,662.96) 177,996.00 67,363.96 37.8%6701800 Taxes-Employer Payroll1,188.10 2,349.00 (1,160.90) 9,484.75 20,361.00 (10,876.25) 32,800.00 23,315.25 71.1%6701880 Wages-Hourly2,820.38 2,600.00 220.38 21,066.18 24,276.00 (3,209.82) 27,404.00 6,337.82 23.1%6701882 Wages-Overtime- - - 46.59 - 46.59 - (46.59) 0.0%Total-G&A-SALARIES & BENEFITS17,926.41 22,600.00 (4,673.59) 163,310.97 196,382.00 (33,071.03) 264,213.00 100,902.03 38.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer23.38 500.00 (476.62) 3,141.48 4,500.00 (1,358.52) 6,300.00 3,158.52 50.1%6703762 Supplies-Office27.77 105.00 (77.23) 245.54 945.00 (699.46) 1,260.00 1,014.46 80.5%6703768 Supplies-Printing & Stationery190.31 400.00 (209.69) 1,776.59 2,100.00 (323.41) 3,300.00 1,523.41 46.2%Total-G&A-SUPPLIES & MATERIALS241.46 1,005.00 (763.54) 5,163.61 7,545.00 (2,381.39) 10,860.00 5,696.39 52.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 45.34 100.00 (54.66) 1,400.00 1,600.00 (200.00) 1,900.00 500.00 26.3%Total-G&A-REPAIRS & MAINTENANCE45.34 100.00 (54.66) 1,400.00 1,600.00 (200.00) 1,900.00 500.00 26.3%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 25.0%6709150 Dues & Subscriptions- 50.00 (50.00) 740.00 750.00 (10.00) 1,150.00 410.00 35.7%6709180 Employee Recruiting/Relocation245.29 200.00 45.29 1,067.24 1,200.00 (132.76) 1,200.00 132.76 11.1%6709197 Equipment Rental1,403.68 550.00 853.68 5,568.25 4,950.00 618.25 6,600.00 1,031.75 15.6%6709202 Fees-Bank105.90 90.00 15.90 1,793.66 810.00 983.66 1,080.00 (713.66) -66.1%6709208 Fees-Payroll Processing399.35 1,000.00 (600.65) 5,729.48 9,000.00 (3,270.52) 12,000.00 6,270.52 52.3%6709220 Freight/Delivery- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6709490 Miscellaneous37.91 100.00 (62.09) 3,577.86 6,300.00 (2,722.14) 6,600.00 3,022.14 45.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services117.61 75.00 42.61 1,331.19 675.00 656.19 900.00 (431.19) -47.9%6709625 Professional Fees687.00 850.00 (163.00) 6,047.81 7,650.00 (1,602.19) 10,200.00 4,152.19 40.7%6709636 Promotion/Entertainment- 100.00 (100.00) 326.10 900.00 (573.90) 1,200.00 873.90 72.8%6709722 Seminars & Training- 200.00 (200.00) 1,519.24 1,800.00 (280.76) 2,400.00 880.76 36.7%6709810 Travel- - - - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 1,050.01 825.00 225.01 1,050.00 (0.01) 0.0%Total-G&A-OTHER EXPENSES3,496.74 3,840.00 631.74 33,250.84 40,010.00 (6,759.16) 52,080.00 18,829.16 36.2%21,709.95 27,545.00 (5,835.05) 203,125.42 245,537.00 (42,411.58) 329,053.00 125,927.58 38.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementMarch 2018Annual Budget10 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 88,463.43 90,900.00 (2,436.57) 121,050.00 32,586.57 26.9%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 82,630.80 81,700.00 930.80 116,200.00 33,569.20 28.9%6800194 Equipment Leases-Trailer583.07 600.00 (16.93) 4,754.81 5,400.00 (645.19) 7,200.00 2,445.19 34.0%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 34,830.00 42,300.00 (7,470.00) 56,400.00 21,570.00 38.2%6800197 Equipment Leases-Others2,060.69 1,950.00 110.69 18,062.52 14,350.00 3,712.52 20,200.00 2,137.48 0.0%25,524.23 28,800.00(3,275.77) 228,741.56234,650.00 (5,908.44) 321,050.00 92,308.44 28.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,999.00 8,999.00 - 81,491.00 80,991.00 500.00 107,987.00 26,496.00 24.5%6900210 FF&E Reserve11,891.55 12,077.00 (185.45) 45,865.58 47,692.00 (1,826.42) 59,281.00 13,415.42 22.6%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 43,372.48 24,300.00 19,072.48 32,400.00 (10,972.48) -33.9%25,672.11 23,776.001,896.11 185,828.71164,783.00 21,045.71 211,468.00 25,639.29 12.1%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMarch 2018Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-2018March 2018 Date TimeDescriptionCategoryPlayers3/3/2018 7:30:00 AM Locale MagazineMedia43/4/2018 10:38:00 AM Brett Coor - NBC - KMIRMedia43/23/2018 11:08:00 AM Blake Arthur - CBS - KESQMedia412 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia4 7 12SalesPromotion4Golf IndustryVIPCelebrityPGA Comp31 41 30Charity/Gift Certificate22614Rain/Wind Checks5740Club Staff31 42 42LQ HS Golf826 51105 129 189 00013