Loading...
07 January 2019 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2018 – January 2019 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 January Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue396,983.40 421,187.50 (24,204.10) -5.7% 1,387,049.03 1,376,573.50 10,475.53 3,401,303.00 2,014,253.97 41%401000 Miscellaneous Golf Revenue43,366.80 41,750.00 1,616.80 3.9% 148,946.65 142,760.60 6,186.05 302,066.00 153,119.35 49%410000 Revenue-Golf Shop27,610.79 31,250.00 (3,639.21) -11.6% 113,273.26 118,500.00 (5,226.74) 277,150.00 163,876.74 41%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.0%0.21 - 0.21 - (0.21) 0%Total Income469,460.99 495,687.50 (26,226.51) -5.3% 1,656,769.15 1,645,334.10 11,435.05 3,992,519.00 2,335,749.85 41%Cost of Goods Sold510000 COS-Golf Shop14,692.54 16,856.29 (2,163.75) 12.8% 62,713.22 66,331.57 3,618.35 155,121.00 92,407.78 40%Total COS14,692.54 16,856.29 (2,163.75) 12.8% 62,713.22 66,331.57 3,618.35 155,121.00 92,407.78 40%Gross Profit454,768.45 478,831.21 (24,062.76) -5.0% 1,594,055.93 1,579,002.53 15,053.40 3,837,398.00 2,243,342.07 42%Expenses610000 Golf Pro Shop 21,346.74 21,892.03 (545.29) 2.5% 124,317.35 118,096.37 6,220.98 221,115.00 96,797.65 56%630000 Course Maintenance125,983.09 124,552.00 1,431.09 -1.1% 1,068,775.52 1,102,706.00 (33,930.48) 1,740,490.00 671,714.48 61%633000 Maintenance Water & Energy17,163.38 17,713.00 (549.62) 3.1% 120,891.90 137,069.00 (16,177.10) 249,838.00 128,946.10 48%640000 Outside Services37,314.40 39,033.33 (1,718.93) 4.4% 206,265.99 187,032.30 19,233.69 354,598.00 148,332.01 58%650000 Clubhouse10,057.06 11,276.00 (1,218.94) 10.8% 74,092.55 79,332.00 (5,239.45) 136,412.00 62,319.45 54%660000 Marketing22,393.05 26,378.00 (3,984.95) 15.1% 129,690.40 136,053.00 (6,362.60) 229,960.00 100,269.60 56%670000 General & Administrative24,616.75 27,542.00 (2,925.25) 10.6% 163,431.33 190,207.00 (26,775.67) 329,053.00 165,621.67 50%680000 Leases25,320.21 26,000.00 (679.79) 2.6% 179,091.78 179,250.00 (158.22) 309,250.00 130,158.22 58%690000 Miscellaneous Other Expense22,412.01 21,923.75 488.26 -2.2% 134,784.23 133,831.48 952.75 241,826.00 107,041.77 56%Total Expenses306,606.69 316,310.11 (9,703.42) 3.1% 2,201,341.05 2,263,577.15 62,236.10 3,812,542.00 1,611,200.95 58%148,161.76 162,521.10 (14,359.34) -8.8%(607,285.12) (684,574.62) 77,289.50 24,856.00 632,141.12 0%Rounds of Golf PlayedPaid Rounds Played4,645 5,000 (355) -7.1%21,905 21,855 50 42,173 20,268 52%Ave $ Per Paid Round Green Fee85.46 84.24 1.23 1.5%63.32 62.99 0.33 80.65 17.33 79%Ave $ Per Paid Round Merchandise5.94 6.25 (0.31) -4.9%5.17 5.42 (0.25) 6.57 1.40 79%Ave $ Per Paid Miscellaneous 9.34 8.35 0.99 11.8%6.80 6.53 0.27 7.16 0.36 95%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJanuary 20191 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees396,983.40 421,187.50 (24,204.10) 1,387,049.03 1,376,573.50 10,475.53 3,401,303.00 2,014,253.97 59.2%4010000 Rider Fee1,175.00 1,250.00 (75.00) 5,907.85 3,152.30 2,755.55 7,307.00 1,399.15 19.1%4040000 Club Rental2,160.00 2,500.00 (340.00) 11,390.00 8,936.50 2,453.50 21,087.00 9,697.00 46.0%4050000 Driving Range14,760.00 15,000.00 (240.00) 42,592.00 44,171.80 (1,579.80) 94,872.00 52,280.00 55.1%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/Subcontract361.80 1,000.00 (638.20) 436.80 3,000.00 (2,563.20) 4,000.00 3,563.20 89.1%4091000 Golf Professional Rental Fee 1,000.00 1,000.00 - 3,000.00 3,000.00 - 7,000.00 4,000.00 57.1%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue23,910.00 22,000.00 1,910.00 85,620.00 78,800.00 6,820.00 165,300.00 79,680.00 48.2% Total Revenue Fees440,350.20 465,637.50(25,287.30) 1,535,995.681,519,334.10 16,661.58 3,703,369.00 2,167,373.32 58.5%440,350.20 465,637.50(25,287.30) 1,535,995.681,519,334.10 16,661.58 3,703,369.00 2,167,373.32 58.5%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetJanuary 20192 RevenuesActual BudgetVariance$27,610.79 $31,250.00(3,639.21)Unfavorable: Due to reduced rounds caused by cold rainy weather.ExpensesActual BudgetVariance$10,057.06 $11,276.00(1,218.94)Favorable: Due to discontinuance of contract cleaning services.Actual BudgetVariance$22,393.05 $26,378.00(3,984.95)Favorable: Due to timing of invoices for advertising.Actual BudgetVariance$24,616.75 $27,542.00(2,925.25)Favorable: Due to reduced line items, repair & maintenance,and supplies.ClubhouseGeneral and AdministrativeMarketingVariance ExplanationJanuary 2019The 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%.Pro Shop Merchandise Sales3-20-133 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,591.94 - 1,591.94 4,889.82 - 4,889.82 00 0%4100110 Sales Hard Goods7,434.25 7,812.50 (378.25) 39,935.89 29,625.00 10,310.89 69,288.00 29,352.11 42.4%4100112 Sales-Soft Goods19,913.00 23,437.50 (3,524.50) 82,571.00 88,875.00 (6,304.00) 207,863.00 125,292.00 60.3%5100639 GS-Discounts-Mdse (1,328.40) - (1,328.40) (14,123.45) - (14,123.45) - 14,123.45 0.0% Total Revenue Golf Shop27,610.79 31,250.00 (3,639.21) 113,273.26 118,500.00 (5,226.74) 277,151.00 168,767.56 60.9%COS 5100150 COS-GS-Hard Goods 3,794.25 4,372.66 (578.41) 21,014.11 17,151.12 3,862.99 40,187.04 19,172.93 47.7%5100151 COS-GS-Soft Goods 10,134.47 13,118.00 (2,983.53) 38,281.36 51,586.00 (13,304.64) 120,560.54 82,279.18 68.2%5100152 COS-GS-Purchase Disc (11.70) (906.25) 894.55 (149.29) (3,436.51) 3,287.22 (8,037.00) (7,887.71) 98.1%5100220 COS-GS-Freight Merch 775.52 271.88 503.64 3,567.04 1,030.96 2,536.08 2,411.00 (1,156.04) -47.9%Cost of Sales - Golf Shop14,692.54 16,856.29 (2,163.75) 62,713.22 66,331.57 (3,618.35) 155,121.58 92,408.36 59.6%Gross Profit 12,918.25 14,393.71 (1,475.46) 50,560.04 52,168.43 (1,608.39) 122,029.42 76,359.20 62.6%COS % 53.2% 53.9% 0.7% 55.4% 56.0% 0.6% 53.1% 54.8% 103.2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group262.16 2,436.00 (2,173.84) 6,321.00 14,616.00 (8,295.00) 26,796.00 20,475.00 76.4%6101325 Insurance-Workers Comp 568.30 540.61 27.69 4,994.94 3,008.69 1,986.25 5,635.00 640.06 11.4%6101720 Salaries6,861.54 4,400.00 2,461.54 36,000.01 30,800.00 5,200.01 51,000.00 14,999.99 29.4%6101800 Taxes-Employer Payroll 2,310.76 1,874.12 436.64 8,749.12 10,430.11 (1,680.99) 19,935.00 11,185.88 56.1%6101880 Wages-Hourly11,158.37 10,016.30 1,142.07 63,123.12 49,431.57 13,691.55 98,874.00 35,750.88 36.2%6101882 Wages-Overtime48.39 - 48.39 387.79 - 387.79 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 21,209.52 19,267.03 1,942.49 119,575.98 108,286.37 11,289.61 202,240.00 84,004.69 41.5%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office100.54 250.00 (149.46) 913.32 1,750.00 (836.68) 3,000.00 2,086.68 69.6%6109220 Freight & Delivery- - - 37.03 75.00 (37.97) 75.00 37.97 50.6%6109490 Miscellaneous- 500.00 (500.00) 494.73 3,500.00 (3,005.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(0.78) - (0.78) 19.36 - 19.36 - (19.36) 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 Uniforms- 500.00 (500.00) 1,916.65 1,400.00 516.65 2,400.00 483.35 20.1%6117840 Telephones37.46 110.00 (72.54) 287.78 770.00 (482.22) 1,320.00 1,032.22 78.2%137.22 2,625.00 (2,487.78) 4,741.37 9,810.00 (5,068.63) 18,875.00 14,133.63 74.9%21,346.74 21,892.03 (545.29) 124,317.35 118,096.37 6,220.98 221,115.00 98,138.32 44.4%Net Income(8,428.49) (7,498.32) (930.17) (73,757.31) (65,927.94) (7,829.37) (99,085.58) (21,779.12) 22.0%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetJanuary 20194 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,635.43 9,165.00 (1,529.57) 58,244.92 57,195.00 1,049.92 103,020.00 44,775.08 43.5%6311325 Insurance-Workers Comp2,217.09 2,352.00 (134.91) 16,614.17 15,594.00 1,020.17 26,974.00 10,359.83 38.4%6311720 Salaries13,076.92 12,476.92 600.00 88,176.90 87,338.44 838.46 146,400.00 58,223.10 39.8%6311800 Taxes-Employer Payroll9,529.09 8,154.00 1,375.09 40,028.02 54,593.00 (14,564.98) 94,048.00 54,019.98 57.4%6311880 Wages-Hourly48,590.78 50,246.08 (1,655.30) 329,741.19 320,257.56 9,483.63 564,695.00 234,953.81 41.6%6311882 Wages-Overtime2,137.45 - 2,137.45 43,650.59 12,350.00 31,300.59 12,350.00 (31,300.59) -253.4%Total-CM-SALARIES & BENEFITS83,186.76 82,394.00 792.76 576,455.79 547,328.00 29,127.79 947,487.00 371,031.21 39.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals1,739.51 - 1,739.51 27,755.29 8,380.00 19,375.29 17,760.00 (9,995.29) -56.3%6313744 Fertilizer5,104.98 3,000.00 2,104.98 56,152.75 69,880.00 (13,727.25) 100,520.00 44,367.25 44.1%6313745 Herbicides- 3,033.00 (3,033.00) 1,854.50 21,094.00 (19,239.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants- 750.00 (750.00) 2,971.85 2,750.00 221.85 3,050.00 78.15 2.6%6313748 Fuel-Gasoline3,631.55 3,570.00 61.55 25,487.64 27,820.00 (2,332.36) 46,860.00 21,372.36 45.6%6313750 Golf Course Accessories- - - 12,986.55 12,300.00 686.55 13,140.00 153.45 1.2%6313756 POA Control1,687.02 - 1,687.02 1,828.08 9,900.00 (8,071.92) 9,900.00 8,071.92 81.5%6313758 Miscellaneous Supp716.65 100.00 616.65 3,017.35 3,850.00 (832.65) 4,350.00 1,332.65 30.6%6313762 Supplies-Office- - - 2,368.01 - 2,368.01 - (2,368.01) 0.0%6313774 Sand- 380.00 (380.00) 4,062.01 12,960.00 (8,897.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 Equip78.94 100.00 (21.06) 1,719.91 4,500.00 (2,780.09) 5,000.00 3,280.09 65.6%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 & MATERIALS12,958.65 10,933.00 2,025.65 253,642.03 306,634.00 (52,991.97) 380,458.00 126,815.97 33.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,850.00 3,850.00 - 21,125.00 26,950.00 (5,825.00) 46,200.00 25,075.00 54.3%6315685 CM-R&M-Bldngs & Othr Structures 191.25 250.00 (58.75) 5,356.29 4,300.00 1,056.29 5,550.00 193.71 3.5%6315690 CM-R&M-Equipment2,417.96 2,500.00 (82.04) 37,305.17 27,000.00 10,305.17 38,500.00 1,194.83 3.1%6315692 CM-R&M-Irrigation System302.08 1,200.00 (897.92) 13,187.38 14,050.00 (862.62) 19,050.00 5,862.62 30.8%6315696 CM-R&M-Pumps1,048.05 1,000.00 48.05 8,561.35 7,000.00 1,561.35 10,500.00 1,938.65 18.5%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 & MAINTENANCE7,809.34 8,800.00 (990.66) 90,725.19 85,350.00 5,375.19 131,850.00 41,124.81 31.2%6317836 Utilities-Natural Gas/LPG 23.38 15.00 8.38 141.15 105.00 36.15 180.00 38.85 0.0%6317840 Telephones788.36 850.00 (61.64) 5,685.14 5,950.00 (264.86) 10,200.00 4,514.86 44.3%Total-CM-UTILITIES811.74 865.00 (53.26) 5,826.29 6,055.00 (228.71) 10,380.00 4,553.71 43.9%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- - - 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) 624.12 3,668.00 (3,043.88) 6,288.00 5,663.88 90.1%6319150 Dues & Subscriptions- - - 840.00 - 840.00 680.00 (160.00) -23.5%6319170 Employee Education- 50.00 (50.00) - 350.00 (350.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) - 2,500.00 (2,500.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- - - 827.05 400.00 427.05 4,300.00 3,472.95 80.8%6319490 Miscellaneous134.42 100.00 34.42 249.69 700.00 (450.31) 1,200.00 950.31 79.2%6319718 Safety Equipment & Training573.53 400.00 173.53 2,129.74 3,150.00 (1,020.26) 3,850.00 1,720.26 44.7%6319822 Uniforms1,337.24 920.00 417.24 6,681.30 6,440.00 241.30 11,040.00 4,358.70 39.5%Total-CM-OTHER EXPENSES2,549.21 2,594.00 (44.79) 14,843.28 21,008.00 (6,164.72) 41,458.00 26,614.72 64.2%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementAnnual BudgetJanuary 20195 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,597.89 2,784.00 (186.11) 20,206.94 19,488.00 718.94 33,408.00 13,201.06 39.5%6321325 Insurance-Workers Comp434.05 500.00 (65.95) 3,934.80 3,537.00 397.80 5,955.00 2,020.20 33.9%6321800 Taxes-Employer Payroll749.54 1,733.00 (983.46) 6,371.68 12,410.00 (6,038.32) 20,793.00 14,421.32 69.4%6321880 Wages-Hourly11,990.93 13,334.00 (1,343.07) 88,922.95 92,048.00 (3,125.05) 156,528.00 67,605.05 43.2%6321882 Wages-Overtime- - - 2,741.69 3,418.00 (676.31) 3,418.00 676.31 19.8%Total-CM-LM-SALARIES & BENEFITS15,772.41 18,351.00 (2,578.59) 122,178.06 130,901.00 (8,722.94) 220,102.00 97,923.94 44.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) 233.75 650.00 (416.25) 1,025.00 791.25 77.2%6323788 Uniforms280.07 290.00 (9.93) 2,256.22 2,030.00 226.22 3,480.00 1,223.78 35.2%Total-CM-LM-SUPPLIES & MATERIALS280.07 365.00 (84.93) 2,489.97 2,680.00 (190.03) 4,505.00 2,015.03 44.7%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation2,614.91 250.00 2,364.91 2,614.91 2,750.00 (135.09) 4,250.00 1,635.09 38.5%Total-CM-LM-REPAIRS & MAINTENANCE2,614.91 250.00 2,364.91 2,614.91 2,750.00 (135.09) 4,250.00 1,635.09 38.5%125,983.09 124,552.00 1,431.09 1,068,775.52 1,102,706.00 (33,930.48) 1,740,490.00 671,714.48 38.6% January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 8,287.15 7,697.00 590.15 78,163.63 68,863.00 9,300.63 179,791.00 101,627.37 56.5%6337842 Utilities-Water8,876.23 10,016.00 (1,139.77) 42,728.27 68,206.00 (25,477.73) 70,047.00 27,318.73 39.0%17,163.38 17,713.00 (549.62) 120,891.90 137,069.00 (16,177.10) 249,838.00 128,946.10 51.6%Total-COURSE MAINTENANCECourse Maintenance Expense StatementJanuary 2019Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyJanuary 2019Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group668.51 696.00 (27.49) 3,342.61 4,872.00 (1,529.39) 8,352.00 5,009.39 60.0%6411325 Insurance-Workers Comp721.96 729.00 (7.04) 5,618.40 3,040.46 2,577.94 6,172.00 553.60 9.0%6411800 Taxes-Employer Payroll2,582.88 2,420.28 162.60 8,972.54 10,094.28 (1,121.74) 20,493.00 11,520.46 56.2%6411880 Wages-Hourly17,669.26 19,440.00 (1,770.74) 86,161.36 81,078.50 5,082.86 164,599.00 78,437.64 47.7%6411882 Wages-Overtime318.02 - 318.02 1,195.78 - 1,195.78 - (1,195.78) 0.0%Total-CBR-SALARIES & BENEFITS21,960.6323,285.28(1,324.65) 105,290.6999,085.24 6,205.45 199,616.00 94,325.31 47.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 75.00 (75.00) 696.30 1,575.00 (878.70) 1,850.00 `0.0%6413742 Supplies-Expendable227.29 1,000.00 (772.71) 340.39 4,450.00 (4,109.61) 6,750.00 6,409.61 95.0%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) 309.70 1,350.00 (1,040.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 275.00 (260.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 61.55 70.00 (8.45) 420.00 358.45 85.3%6413786 Supplies-Towels480.00 250.00 230.00 5,409.97 1,110.00 4,299.97 2,182.00 (3,227.97) -147.9%6413796 Supplies-Bottled Water114.19 100.00 14.19 19,686.99 5,100.00 14,586.99 12,900.00 (6,786.99) -52.6%Total-CBR-SUPPLIES & MATERIALS821.48 1,995.00 (1,173.52) 37,087.82 22,930.00 14,157.82 36,627.00 (1,614.52) -4.4%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 31.50 2,100.00 (2,068.50) 3,600.00 3,568.50 99.1%6415695 CBR-R&M-Cart Maintenance & Repair 1,719.16 500.00 1,219.16 15,225.91 3,950.00 11,275.91 6,450.00 (8,775.91) -136.1%Total-CBR-REPAIRS & MAINTENANCE1,719.16 800.00 919.16 15,257.41 6,050.00 9,207.41 10,050.00 (5,207.41) -51.8%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen2,343.71 800.00 1,543.71 6,305.93 5,600.00 705.93 9,600.00 3,294.07 34.3%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 821.27 4,200.00 (3,378.73) 7,200.00 6,378.73 88.6%6419820 Uniforms- - - 895.92 3,000.00 (2,104.08) 5,200.00 4,304.08 82.8%Total-CBR-OTHER EXPENSES2,343.71 1,400.00 943.71 8,023.12 13,250.00 (5,226.88) 22,450.00 14,426.88 64.3%TOTAL-CARTS,BAGROOM & RANGE26,844.9827,480.28943.71 165,659.04141,315.2424,343.80 268,743.00 101,930.26 37.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp334.06 362.25 (28.19) 2,696.29 1,385.73 1,310.56 2,630.00 (66.29) -2.5%6431800 Taxes-Employer Payroll1,041.36 1,255.80 (214.44) 3,173.57 4,803.83 (1,630.26) 9,117.00 5,943.43 65.2%6431880 Wages-Hourly9,094.00 9,660.00 (566.00) 34,498.75 36,952.50 (2,453.75) 70,133.00 35,634.25 50.8%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS10,469.4211,278.05(808.63) 40,368.61 43,142.06 (2,773.45) 81,880.00 41,511.39 50.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 82.64 600.00 (517.36) 1,050.00 967.36 92.1%6439490 Miscellaneous- 50.00 (50.00) 155.70 200.00 (44.30) 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) - 1,425.00 (1,425.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 275.00 (275.00) 238.34 2,575.00 (2,336.66) 3,975.00 3,736.66 94.0%Total-COURSE SERVICES10,469.4211,553.05(1,083.63) 40,606.95 45,717.06 (5,110.11) 85,855.00 45,248.05 52.7%37,314.4039,033.33(1,718.93) 206,265.99187,032.3019,233.69 354,598.00 143,441.65 40.5%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetJanuary 20197 January Final 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 Gas599.79 300.00 299.79 2,750.65 2,100.00 650.65 3,600.00 849.35 23.6%6507840 Utilities-Telephone1,214.84 1,150.00 64.84 7,167.85 8,050.00 (882.15) 13,800.00 6,632.15 48.1%6507842 Utilities-Water744.92 321.00 423.92 5,721.15 2,247.00 3,474.15 3,852.00 (1,869.15) -48.5%6507844 Utilities-Cable495.80 380.00 115.80 3,470.68 2,660.00 810.68 4,560.00 1,089.32 23.9%Total-CH-UTILITIES3,055.35 2,151.00 904.35 19,110.33 15,057.00 4,053.33 25,812.00 6,701.67 26.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning475.00 1,825.00 (1,350.00) 3,424.00 13,375.00 (9,951.00) 22,500.00 19,076.00 84.8%6509099 Contract Services-Security5,286.24 5,000.00 286.24 37,462.57 35,000.00 2,462.57 60,000.00 22,537.43 37.6%6509215 Flowers & Decorations- 500.00 (500.00) - 1,000.00 (1,000.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 2,677.58 3,700.00 (1,022.42) 7,000.00 4,322.42 61.7%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 700.00 (448.53) 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES5,761.24 7,625.00 (1,863.76)43,815.62 53,775.00 (9,959.38) 92,600.00 48,784.38 52.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures822.60 300.00 522.60 7,027.00 2,100.00 4,927.00 3,600.00 (3,427.00) -95.2%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,193.37 2,800.00 (1,606.63) 4,800.00 3,606.63 75.1%6515690 CH-R&M-Equipment Repair17.87 400.00 (382.13) 146.23 2,800.00 (2,653.77) 4,800.00 4,653.77 97.0%Total-CH-REPAIRS & MAINTENANCE840.47 1,100.00 (259.53) 8,366.60 7,700.00 666.60 13,200.00 4,833.40 36.6%10,057.06 11,276.00(1,218.94)74,092.55 79,332.00 (5,239.45) 136,412.00 9,666.80 7.1%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetJanuary 20198 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 2,491.23 2,436.00 55.23 4,176.00 1,684.77 40.3%6601325 Insurance-Workers Comp87.20 94.00 (6.80) 654.83 658.00 (3.17) 1,129.00 474.17 42.0%6601720 Salaries1,905.20 2,508.00 (602.80) 14,289.00 17,556.00 (3,267.00) 30,096.00 15,807.00 52.5%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 1,089.00 2,282.00 (1,193.00) 3,912.00 2,823.00 72.2%Total-MKT-SALARIES & BENEFITS2,493.49 3,276.00 (782.51) 18,524.06 22,932.00 (4,407.94) 39,313.00 20,788.94 52.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 67.37 100.00 (32.63) 821.24 700.00 121.24 1,200.00 378.76 31.6%6603768 Supplies-Printing & Stationery 708.10 200.00 508.10 5,037.15 3,800.00 1,237.15 4,425.00 (612.15) -13.8%775.47 300.00 475.47 5,858.39 4,500.00 1,358.39 5,625.00 (233.39) -4.1%66-MKT-UTILITIES6607840 Utilities-Telephone 148.49 100.00 48.49 2,268.34 700.00 1,568.34 1,200.00 (1,068.34) -89.0%Total-MKT-UTILITIES148.49 100.00 48.49 2,268.34 700.00 1,568.34 1,200.00 (1,068.34) -89.0%66-MKT-OTHER EXPENSES6609010 Advertising 18,535.60 20,967.00 (2,431.40) 95,711.19 99,886.00 (4,174.81) 169,987.00 74,275.81 43.7%6609040 Business Meals- 25.00 (25.00) - 175.00 (175.00) 300.00 300.00 100.0%6609080 Collateral Material440.00 500.00 (60.00) 5,019.50 2,000.00 3,019.50 5,500.00 480.50 8.7%6609102 Contract Services-Web Page- 150.00 (150.00) 396.00 1,050.00 (654.00) 1,800.00 1,404.00 78.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) 700.00 450.00 250.00 700.00 - 0.0%6609633 Promotion-Community- 75.00 (75.00) 913.85 1,875.00 (961.15) 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 1,500.00 (1,500.00) 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- 35.00 (35.00) - 35.00 (35.00) 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) 299.07 450.00 (150.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES18,975.60 22,702.00 (3,726.40) 103,039.61 107,921.00 (4,881.39) 183,822.00 80,782.39 43.9%22,393.05 26,378.00 (3,984.95) 129,690.40 136,053.00 (6,362.60) 229,960.00 100,269.60 43.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetJanuary 20199 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,518.58 1,509.00 1,009.58 16,247.51 10,563.00 5,684.51 18,108.00 1,860.49 10.3%6701325 Insurance-Workers Comp580.49 677.00 (96.51) 3,883.54 4,515.00 (631.46) 7,905.00 4,021.46 50.9%6701720 Salaries12,894.80 13,851.00 (956.20) 86,211.00 96,357.00 (10,146.00) 177,996.00 91,785.00 51.6%6701800 Taxes-Employer Payroll2,062.10 2,349.00 (286.90) 9,111.79 15,663.00 (6,551.21) 32,800.00 23,688.21 72.2%6701880 Wages-Hourly3,869.79 4,211.00 (341.21) 21,741.86 24,094.00 (2,352.14) 27,404.00 5,662.14 20.7%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS21,925.76 22,597.00 (671.24) 137,195.70 151,192.00 (13,996.30) 264,213.00 127,017.30 48.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer49.96 500.00 (450.04) 666.48 3,500.00 (2,833.52) 6,300.00 5,633.52 89.4%6703762 Supplies-Office64.32 105.00 (40.68) 329.63 735.00 (405.37) 1,260.00 930.37 73.8%6703768 Supplies-Printing & Stationery32.63 400.00 (367.37) 1,197.31 1,300.00 (102.69) 3,300.00 2,102.69 63.7%Total-G&A-SUPPLIES & MATERIALS146.91 1,005.00 (858.09) 2,193.42 5,535.00 (3,341.58) 10,860.00 8,666.58 79.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 683.14 1,400.00 (716.86) 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 683.14 1,400.00 (716.86) 1,900.00 1,216.86 64.0%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) 330.00 500.00 (170.00) 1,150.00 820.00 71.3%6709180 Employee Recruiting/Relocation133.75 150.00 (16.25) 722.01 800.00 (77.99) 1,200.00 477.99 39.8%6709197 Equipment Rental344.65 550.00 (205.35) 3,308.83 3,850.00 (541.17) 6,600.00 3,291.17 49.9%6709202 Fees-Bank- 90.00 (90.00) 506.42 630.00 (123.58) 1,080.00 573.58 53.1%6709208 Fees-Payroll Processing397.75 1,000.00 (602.25) 3,789.85 7,000.00 (3,210.15) 12,000.00 8,210.15 68.4%6709220 Freight/Delivery- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6709490 Miscellaneous67.08 100.00 (32.92) 3,581.14 6,100.00 (2,518.86) 6,600.00 3,018.86 45.7%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services158.99 75.00 83.99 712.19 525.00 187.19 900.00 187.81 20.9%6709625 Professional Fees812.45 850.00 (37.55) 5,571.95 5,950.00 (378.05) 10,200.00 4,628.05 45.4%6709636 Promotion/Entertainment129.41 100.00 29.41 129.41 700.00 (570.59) 1,200.00 1,070.59 89.2%6709722 Seminars & Training- 200.00 (200.00) 250.00 1,400.00 (1,150.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 957.27 675.00 282.27 1,050.00 92.73 8.8%Total-G&A-OTHER EXPENSES2,544.08 3,840.00 (1,295.92) 23,359.07 32,080.00 (8,720.93) 52,080.00 28,720.93 55.1%24,616.75 27,542.00 (2,925.25) 163,431.33 190,207.00 (26,775.67) 329,053.00 165,621.67 50.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetJanuary 201910 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 68,804.90 70,800.00 (1,995.10) 121,050.00 52,245.10 43.2%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 64,268.40 66,500.00 (2,231.60) 114,000.00 49,731.60 43.6%6800194 Equipment Leases-Trailer398.07 600.00 (201.93) 4,531.49 4,200.00 331.49 7,200.00 2,668.51 37.1%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 27,090.00 27,300.00 (210.00) 46,800.00 19,710.00 42.1%6800197 Equipment Leases-Others2,041.67 1,950.00 91.67 14,396.99 10,450.00 3,946.99 20,200.00 5,803.01 0.0%25,320.21 26,000.00(679.79) 179,091.78179,250.00 (158.22) 309,250.00 130,158.2242.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 66,500.00 66,500.00 - 114,000.00 47,500.00 41.7%6900210 FF&E Reserve7,939.67 8,423.75 (484.08) 27,741.00 27,531.48 209.52 68,026.00 40,285.00 59.2%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 25,805.02 28,000.00 (2,194.98) 48,000.00 22,194.98 46.2%22,412.01 21,923.75488.26 134,784.23133,831.48 952.75 241,826.00 107,041.7744.3%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateJanuary 201911