Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
09 March 2019 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2018 – March 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 March Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue584,216.86 597,075.00 (12,858.14) -2.2% 2,447,538.13 2,526,467.25 (78,929.12) 3,401,303.00 953,764.87 72%401000 Miscellaneous Golf Revenue47,030.00 35,125.00 11,905.00 33.9% 237,071.65 225,310.60 11,761.05 302,066.00 64,994.35 78%410000 Revenue-Golf Shop38,341.83 42,000.00 (3,658.17) -8.7% 182,698.99 199,000.00 (16,301.01) 277,150.00 94,451.01 66%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 Income- - - 0.0%0.21 - 0.21 - (0.21) 0%Total Income671,088.69 675,700.00 (4,611.31) -0.7% 2,877,808.98 2,961,277.85 (83,468.87) 3,992,519.00 1,114,710.02 72%Cost of Goods Sold510000 COS-Golf Shop20,472.69 23,507.40 (3,034.71) 12.9% 99,925.66 111,382.30 11,456.64 155,121.00 55,195.34 64%Total COS20,472.69 23,507.40 (3,034.71) 12.9% 99,925.66 111,382.30 11,456.64 155,121.00 55,195.34 64%Gross Profit650,616.00 652,192.60 (1,576.60) -0.2% 2,777,883.32 2,849,895.55 (72,012.23) 3,837,398.00 1,059,514.68 72%Expenses610000 Golf Pro Shop 21,715.49 20,377.03 1,338.46 -6.6% 167,433.84 158,850.43 8,583.41 221,115.00 53,681.16 76%630000 Course Maintenance126,126.55 127,525.00 (1,398.45) 1.1% 1,315,653.42 1,343,611.00 (27,957.58) 1,740,490.00 424,836.58 76%633000 Maintenance Water & Energy17,006.45 17,252.00 (245.55) 1.4% 149,280.99 171,469.00 (22,188.01) 249,838.00 100,557.01 60%640000 Outside Services44,182.42 38,708.33 5,474.09 -14.1% 286,800.94 271,623.96 15,176.98 354,598.00 67,797.06 81%650000 Clubhouse12,078.38 13,576.00 (1,497.62) 11.0% 95,704.94 103,684.00 (7,979.06) 136,412.00 40,707.06 70%660000 Marketing21,774.20 23,831.00 (2,056.80) 8.6% 168,719.31 183,947.00 (15,227.69) 229,960.00 61,240.69 73%670000 General & Administrative24,995.12 27,542.00 (2,546.88) 9.2% 215,007.46 245,541.00 (30,533.54) 329,053.00 114,045.54 65%680000 Leases24,675.40 26,000.00 (1,324.60) 5.1% 229,656.80 231,250.00 (1,593.20) 309,250.00 79,593.20 74%690000 Miscellaneous Other Expense26,156.68 25,441.50 715.18 -2.8% 185,484.19 183,829.36 1,654.83 241,826.00 56,341.81 77%Total Expenses318,710.69 320,252.86 (1,542.17) 0.5% 2,813,741.89 2,893,805.75 80,063.86 3,812,542.00 998,800.11 74%331,905.31 331,939.74 (34.43) 0.0%(35,858.57) (43,910.20) 8,051.63 24,856.00 60,714.57 0%Rounds of Golf PlayedPaid Rounds Played5,959 6,000 (41) -0.7%32,542 33,355 (813) 42,173 9,631 77%Ave $ Per Paid Round Green Fee98.04 99.51 (1.47) -1.5%75.21 75.74 (0.53) 80.65 5.44 93%Ave $ Per Paid Round Merchandise6.43 7.00 (0.57) -8.1%5.61 5.97 (0.35) 6.57 0.96 85%Ave $ Per Paid Miscellaneous 7.89 5.85 2.04 34.8%7.29 6.75 0.53 7.16 (0.12) 102%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMarch 20191 Income March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees584,216.86 597,075.00 (12,858.14) 2,447,538.13 2,526,467.25 (78,929.12) 3,401,303.00 953,764.87 28.0%4010000 Rider Fee1,725.00 1,500.00 225.00 8,707.85 6,027.30 2,680.55 7,307.00 (1,400.85) -19.2%4040000 Club Rental5,240.00 3,000.00 2,240.00 19,290.00 14,686.50 4,603.50 21,087.00 1,797.00 8.5%4050000 Driving Range21,425.00 15,000.00 6,425.00 83,037.00 75,671.80 7,365.20 94,872.00 11,835.00 12.5%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- - - 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 - 5,000.00 5,000.00 - 7,000.00 2,000.00 28.6%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue17,640.00 15,625.00 2,015.00 120,600.00 118,425.00 2,175.00 165,300.00 44,700.00 27.0% Total Revenue Fees631,246.86 633,600.00(2,353.14) 2,684,609.782,751,777.85 (67,168.07) 3,703,369.00 1,018,759.22 27.5%631,246.86 633,600.00(2,353.14) 2,684,609.782,751,777.85 (67,168.07) 3,703,369.00 1,018,759.22 27.5%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetMarch 20192 RevenuesActual BudgetVariance$47,030.00 $35,125.0011,905.00Favorable: Due to increase in resident cards sales, driving range fees and rental clubs.ExpensesActual BudgetVariance$44,182.42 $38,708.335,474.09Unfavorable: Due to repairs and maintenance to golf carts which are getting at the end of the lease. Also, maintenance work required on the handicapgolf car and a multi-flex disc for the range ball retriever.Actual BudgetVariance$12,078.38 $13,576.00(1,497.62)Favorable: Due to discontinuance of contract cleaning services.Variance ExplanationMarch 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%.Miscellaneous Golf RevenueOutside ServicesClubhouse3-20-133 Income March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous292.06 - 292.06 5,380.68 - 5,380.68 00 0%4100110 Sales Hard Goods 11,748.98 10,500.00 1,248.98 61,074.04 49,750.00 11,324.04 69,288.00 8,213.96 11.9%4100112 Sales-Soft Goods30,010.99 31,500.00 (1,489.01) 135,592.25 149,250.00 (13,657.75) 207,863.00 72,270.75 34.8%5100639 GS-Discounts-Mdse (3,710.20) - (3,710.20) (19,347.98) - (19,347.98) - 19,347.98 0.0% Total Revenue Golf Shop38,341.83 42,000.00 (3,658.17) 182,698.99 199,000.00 (16,301.01) 277,151.00 99,832.69 36.0%COS 5100150 COS-GS-Hard Goods 6,362.25 6,090.00 272.25 32,224.23 28,856.00 3,368.23 40,187.04 7,962.81 19.8%5100151 COS-GS-Soft Goods 13,442.21 18,270.00 (4,827.79) 63,244.81 86,566.00 (23,321.19) 120,560.54 57,315.73 47.5%5100152 COS-GS-Purchase Disc (29.45) (1,218.00) 1,188.55 (178.74) (5,771.01) 5,592.27 (8,037.00) (7,858.26) 97.8%5100220 COS-GS-Freight Merch 697.68 365.40 332.28 4,635.36 1,731.31 2,904.05 2,411.00 (2,224.36) -92.3%Cost of Sales - Golf Shop20,472.69 23,507.40 (3,034.71) 99,925.66 111,382.30 (11,456.64) 155,121.58 55,195.92 35.6%Gross Profit17,869.14 18,492.60 (623.46) 82,773.33 87,617.70 (4,844.37) 122,029.42 44,636.77 36.6%COS % 53.4% 56.0% 2.6% 54.7% 56.0% 1.3% 53.1% 55.3% 104.2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,601.66 2,436.00 (834.34) 9,949.26 19,488.00 (9,538.74) 26,796.00 16,846.74 62.9%6101325 Insurance-Workers Comp 1,485.60 540.61 944.99 7,089.12 4,089.91 2,999.21 5,635.00 (1,454.12) -25.8%6101720 Salaries4,861.54 4,400.00 461.54 45,723.09 39,600.00 6,123.09 51,000.00 5,276.91 10.3%6101800 Taxes-Employer Payroll 1,913.61 1,874.12 39.49 12,839.21 14,178.35 (1,339.14) 19,935.00 7,095.79 35.6%6101880 Wages-Hourly11,195.33 10,016.30 1,179.03 85,364.22 69,464.17 15,900.05 98,874.00 13,509.78 13.7%6101882 Wages-Overtime88.13 - 88.13 696.25 - 696.25 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 21,145.87 19,267.03 1,878.84 161,661.15 146,820.43 14,840.72 202,240.00 42,227.98 20.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office176.25 250.00 (73.75) 1,210.20 2,250.00 (1,039.80) 3,000.00 1,789.80 59.7%6109220 Freight & Delivery- - - 37.03 75.00 (37.97) 75.00 37.97 50.6%6109490 Miscellaneous98.48 500.00 (401.52) 769.98 4,500.00 (3,730.02) 6,000.00 5,230.02 87.2%6109150 Dues and Subscriptions- - - 1,072.50 - 1,072.50 2,300.00 1,227.50 53.4%6109500 ProShop-Over/Short8.19 - 8.19 20.93 - 20.93 - (20.93) 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 Uniforms228.88 200.00 28.88 2,258.63 1,800.00 458.63 2,400.00 141.37 5.9%6117840 Telephones57.82 110.00 (52.18) 403.42 990.00 (586.58) 1,320.00 916.58 69.4%569.62 1,110.00 (540.38) 5,772.69 12,030.00 (6,257.31) 18,875.00 13,102.31 69.4%21,715.49 20,377.03 1,338.46 167,433.84 158,850.43 8,583.41 221,115.00 55,330.29 25.0%Net Income(3,846.35) (1,884.43) (1,961.92) (84,660.51) (71,232.73) (13,427.78) (99,085.58) (10,693.52) 10.8%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetMarch 20194 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,349.38 9,165.00 (1,815.62) 76,442.69 75,525.00 917.69 103,020.00 26,577.31 25.8%6311325 Insurance-Workers Comp3,416.88 2,352.00 1,064.88 22,747.93 20,070.00 2,677.93 26,974.00 4,226.07 15.7%6311720 Salaries12,476.92 12,476.92 - 113,130.74 112,292.28 838.46 146,400.00 33,269.26 22.7%6311800 Taxes-Employer Payroll7,725.44 8,154.00 (428.56) 55,623.90 70,112.00 (14,488.10) 94,048.00 38,424.10 40.9%6311880 Wages-Hourly44,664.99 50,246.08 (5,581.09) 415,039.97 414,679.72 360.25 564,695.00 149,655.03 26.5%6311882 Wages-Overtime5,237.10 - 5,237.10 50,887.69 12,350.00 38,537.69 12,350.00 (38,537.69) -312.0%Total-CM-SALARIES & BENEFITS80,870.71 82,394.00 (1,523.29) 733,872.92 705,029.00 28,843.92 947,487.00 213,614.08 22.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals4,698.69 190.00 4,508.69 34,874.57 8,760.00 26,114.57 17,760.00 (17,114.57) -96.4%6313744 Fertilizer106.82 3,370.00 (3,263.18) 60,344.41 76,270.00 (15,925.59) 100,520.00 40,175.59 40.0%6313745 Herbicides- 1,616.00 (1,616.00) 1,854.50 22,710.00 (20,855.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants690.56 100.00 590.56 3,662.41 2,950.00 712.41 3,050.00 (612.41) -20.1%6313748 Fuel-Gasoline2,845.86 3,880.00 (1,034.14) 31,141.60 35,580.00 (4,438.40) 46,860.00 15,718.40 33.5%6313750 Golf Course Accessories173.99 - 173.99 13,528.20 12,460.00 1,068.20 13,140.00 (388.20) -3.0%6313756 POA Control3,800.00 - 3,800.00 5,628.08 9,900.00 (4,271.92) 9,900.00 4,271.92 43.2%6313758 Miscellaneous Supp714.73 100.00 614.73 4,428.89 4,050.00 378.89 4,350.00 (78.89) -1.8%6313762 Supplies-Office- - - 2,754.03 - 2,754.03 - (2,754.03) 0.0%6313774 Sand2,251.03 100.00 2,151.03 6,313.04 13,160.00 (6,846.96) 13,460.00 7,146.96 53.1%6313776 Seed- - - 103,424.93 117,400.00 (13,975.07) 117,400.00 13,975.07 11.9%6313778 Small Tools & Non-Capital Equip290.47 100.00 190.47 2,010.38 4,700.00 (2,689.62) 5,000.00 2,989.62 59.8%6313780 Sod- - - 5,343.51 8,800.00 (3,456.49) 13,500.00 8,156.49 60.4%6313782 Topdressing- - - 4,849.65 7,000.00 (2,150.35) 10,000.00 5,150.35 51.5%Total-CM-SUPPLIES & MATERIALS15,572.15 9,456.00 6,116.15 280,158.20 323,740.00 (43,581.80) 380,458.00 100,299.80 26.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint- 3,850.00 (3,850.00) 21,125.00 34,650.00 (13,525.00) 46,200.00 25,075.00 54.3%6315685 CM-R&M-Bldngs & Othr Structures 376.71 250.00 126.71 6,282.74 4,800.00 1,482.74 5,550.00 (732.74) -13.2%6315690 CM-R&M-Equipment3,950.93 2,000.00 1,950.93 43,858.26 31,500.00 12,358.26 38,500.00 (5,358.26) -13.9%6315692 CM-R&M-Irrigation System275.19 1,000.00 (724.81) 18,533.58 16,050.00 2,483.58 19,050.00 516.42 2.7%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 10,061.35 9,000.00 1,061.35 10,500.00 438.65 4.2%6315815 CM-R&M-Trees-Pruning Etc2,000.00 2,000.00 - 7,190.00 8,050.00 (860.00) 12,050.00 4,860.00 40.3%Total-CM-REPAIRS & MAINTENANCE6,602.83 10,100.00 (3,497.17) 107,050.93 104,050.00 3,000.93 131,850.00 24,799.07 18.8%6317836 Utilities-Natural Gas/LPG25.70 15.00 10.70 194.45 135.00 59.45 180.00 (14.45) 0.0%6317840 Telephones788.51 850.00 (61.49) 7,261.00 7,650.00 (389.00) 10,200.00 2,939.00 28.8%Total-CM-UTILITIES814.21 865.00 (50.79) 7,455.45 7,785.00 (329.55) 10,380.00 2,924.55 28.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- - - 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) 936.18 4,716.00 (3,779.82) 6,288.00 5,351.82 85.1%6319150 Dues & Subscriptions210.00 - 210.00 1,430.00 200.00 1,230.00 680.00 (750.00) -110.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) - 2,900.00 (2,900.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- 1,000.00 (1,000.00) 3,927.05 1,400.00 2,527.05 4,300.00 372.95 8.7%6319490 Miscellaneous- 100.00 (100.00) 249.69 900.00 (650.31) 1,200.00 950.31 79.2%6319718 Safety Equipment & Training310.88 200.00 110.88 3,011.47 3,550.00 (538.53) 3,850.00 838.53 21.8%6319822 Uniforms1,099.26 920.00 179.26 9,128.01 8,280.00 848.01 11,040.00 1,911.99 17.3%Total-CM-OTHER EXPENSES2,124.16 5,744.00 (3,619.84) 22,973.78 30,296.00 (7,322.22) 41,458.00 18,484.22 44.6%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetMarch 2019Month to DateYear to Date5 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 4,278.69 2,784.00 1,494.69 27,156.91 25,056.00 2,100.91 33,408.00 6,251.09 18.7%6321325 Insurance-Workers Comp742.80 500.00 242.80 5,420.40 4,487.00 933.40 5,955.00 534.60 9.0%6321800 Taxes-Employer Payroll920.13 1,733.00 (812.87) 8,382.50 15,704.00 (7,321.50) 20,793.00 12,410.50 59.7%6321880 Wages-Hourly12,520.00 13,334.00 (814.00) 112,979.14 117,386.00 (4,406.86) 156,528.00 43,548.86 27.8%6321882 Wages-Overtime1,026.38 - 1,026.38 4,443.82 3,418.00 1,025.82 3,418.00 (1,025.82) -30.0%Total-CM-LM-SALARIES & BENEFITS19,488.00 18,351.00 1,137.00 158,382.77 166,051.00 (7,668.23) 220,102.00 61,719.23 28.0%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 233.75 800.00 (566.25) 1,025.00 791.25 77.2%6323788 Uniforms654.49 290.00 364.49 2,910.71 2,610.00 300.71 3,480.00 569.29 16.4%Total-CM-LM-SUPPLIES & MATERIALS654.49 365.00 289.49 3,144.46 3,410.00 (265.54) 4,505.00 1,360.54 30.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 2,614.91 3,250.00 (635.09) 4,250.00 1,635.09 38.5%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) 2,614.91 3,250.00 (635.09) 4,250.00 1,635.09 38.5%126,126.55 127,525.00 (1,398.45) 1,315,653.42 1,343,611.00 (27,957.58) 1,740,490.00 424,836.58 24.4% March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping10,515.90 5,247.00 5,268.90 94,485.66 79,242.00 15,243.66 179,791.00 85,305.34 47.4%6337842 Utilities-Water6,490.55 12,005.00 (5,514.45) 54,795.33 92,227.00 (37,431.67) 70,047.00 15,251.67 21.8%17,006.45 17,252.00 (245.55) 149,280.99 171,469.00 (22,188.01) 249,838.00 100,557.01 40.2%Silverrock ResortCourse Maintenance Water & EnergyMarch 2019Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementMarch 2019Silverrock ResortAnnual BudgetMonth to Date Year to Date6 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group521.72 696.00 (174.28) 4,719.09 6,264.00 (1,544.91) 8,352.00 3,632.91 43.5%6411325 Insurance-Workers Comp782.72 729.00 53.72 7,382.64 4,498.46 2,884.18 6,172.00 (1,210.64) -19.6%6411800 Taxes-Employer Payroll3,074.14 2,420.28 653.86 14,883.35 14,934.84 (51.49) 20,493.00 5,609.65 27.4%6411880 Wages-Hourly20,056.13 19,440.00 616.13 125,023.62 119,958.50 5,065.12 164,599.00 39,575.38 24.0%6411882 Wages-Overtime1,397.07 - 1,397.07 3,330.49 - 3,330.49 - (3,330.49) 0.0%Total-CBR-SALARIES & BENEFITS25,831.7823,285.282,546.50 155,339.19145,655.809,683.39 199,616.00 44,276.81 22.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 50.00 (50.00) 696.30 1,700.00 (1,003.70) 1,850.00 `0.0%6413742 Supplies-Expendable- 150.00 (150.00) 340.39 5,600.00 (5,259.61) 6,750.00 6,409.61 95.0%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) 309.70 2,250.00 (1,940.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 375.00 (360.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 61.55 210.00 (148.45) 420.00 358.45 85.3%6413786 Supplies-Towels160.00 250.00 (90.00) 5,729.97 1,610.00 4,119.97 2,182.00 (3,547.97) -162.6%6413796 Supplies-Bottled Water476.32 200.00 276.32 20,277.50 12,300.00 7,977.50 12,900.00 (7,377.50) -57.2%Total-CBR-SUPPLIES & MATERIALS636.32 1,220.00 (583.68) 37,998.33 33,045.00 4,953.33 36,627.00 (2,525.03) -6.9%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 2,115.70 300.00 1,815.70 2,232.32 2,700.00 (467.68) 3,600.00 1,367.68 38.0%6415695 CBR-R&M-Cart Maintenance & Repair2,572.25 500.00 2,072.25 20,804.16 4,950.00 15,854.16 6,450.00 (14,354.16) -222.5%Total-CBR-REPAIRS & MAINTENANCE4,687.95 800.00 3,887.95 23,036.48 7,650.00 15,386.48 10,050.00 (12,986.48) -129.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen919.21 800.00 119.21 7,961.41 7,200.00 761.41 9,600.00 1,638.59 17.1%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous229.78 600.00 (370.22) 1,382.87 5,400.00 (4,017.13) 7,200.00 5,817.13 80.8%6419820 Uniforms501.44 500.00 1.44 1,397.36 3,500.00 (2,102.64) 5,200.00 3,802.64 73.1%Total-CBR-OTHER EXPENSES1,650.43 1,900.00 (249.57) 10,741.64 16,550.00 (5,808.36) 22,450.00 11,708.36 52.2%TOTAL-CARTS,BAGROOM & RANGE 32,806.4827,205.28(249.57) 227,115.64202,900.8024,214.84 268,743.00 40,473.66 15.1%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp742.80 362.25 380.55 4,181.89 2,110.23 2,071.66 2,630.00 (1,551.89) -59.0%6431800 Taxes-Employer Payroll1,215.73 1,255.80 (40.07) 5,548.91 7,315.43 (1,766.52) 9,117.00 3,568.09 39.1%6431880 Wages-Hourly8,022.00 9,660.00 (1,638.00) 48,320.75 56,272.50 (7,951.75) 70,133.00 21,812.25 31.1%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS9,980.53 11,278.05(1,297.52) 58,051.55 65,698.16 (7,646.61) 81,880.00 23,828.45 29.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable 344.81 100.00 244.81 427.45 800.00 (372.55) 1,050.00 622.55 59.3%6439490 Miscellaneous- - - 155.70 200.00 (44.30) 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6439820 Uniforms1,050.60 75.00 975.60 1,050.60 1,575.00 (524.40) 2,125.00 1,074.40 50.6%Total-CS-OTHER EXPENSES1,395.41 225.00 1,170.41 1,633.75 3,025.00 (1,391.25) 3,975.00 2,341.25 58.9%Total-COURSE SERVICES 11,375.9411,503.05(127.11) 59,685.30 68,723.16 (9,037.86) 85,855.00 26,169.70 30.5%44,182.4238,708.335,474.09 286,800.94271,623.9615,176.98 354,598.00 64,302.11 18.1%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetMarch 20197 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.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 Gas671.32 300.00 371.32 4,270.59 2,700.00 1,570.59 3,600.00 (670.59) -18.6%6507840 Utilities-Telephone1,221.92 1,150.00 71.92 9,605.36 10,350.00 (744.64) 13,800.00 4,194.64 30.4%6507842 Utilities-Water764.42 321.00 443.42 7,250.29 2,889.00 4,361.29 3,852.00 (3,398.29) -88.2%6507844 Utilities-Cable504.36 380.00 124.36 4,470.84 3,420.00 1,050.84 4,560.00 89.16 2.0%Total-CH-UTILITIES3,162.02 2,151.00 1,011.02 25,597.08 19,359.00 6,238.08 25,812.00 214.92 0.8%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning480.00 1,825.00 (1,345.00) 4,179.00 17,025.00 (12,846.00) 22,500.00 18,321.00 81.4%6509099 Contract Services-Security5,544.72 5,000.00 544.72 47,718.97 45,000.00 2,718.97 60,000.00 12,281.03 20.5%6509215 Flowers & Decorations- 500.00 (500.00) - 1,500.00 (1,500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous320.19 2,500.00 (2,179.81) 2,997.77 6,400.00 (3,402.23) 7,000.00 4,002.23 57.2%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 900.00 (648.53) 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES6,344.91 9,925.00 (3,580.09)55,147.21 70,825.00 (15,677.79)92,600.00 37,452.79 40.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures822.60 300.00 522.60 8,672.20 2,700.00 5,972.20 3,600.00 (5,072.20) -140.9%6515686 CH-R&M-Restaurant Repairs598.85 400.00 198.85 1,792.22 3,600.00 (1,807.78) 4,800.00 3,007.78 62.7%6515690 CH-R&M-Equipment Repair750.00 400.00 350.00 896.23 3,600.00 (2,703.77) 4,800.00 3,903.77 81.3%Total-CH-REPAIRS & MAINTENANCE2,171.45 1,100.00 1,071.45 11,360.65 9,900.00 1,460.65 13,200.00 1,839.35 13.9%12,078.38 13,576.00(1,497.62)95,704.94 103,684.00(7,979.06) 136,412.00 3,678.70 2.7%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetMarch 20198 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 398.91 348.00 50.91 3,246.03 3,132.00 114.03 4,176.00 929.97 22.3%6601325 Insurance-Workers Comp98.40 94.00 4.40 858.43 846.00 12.43 1,129.00 270.57 24.0%6601720 Salaries2,102.20 2,508.00 (405.80) 18,296.40 22,572.00 (4,275.60) 30,096.00 11,799.60 39.2%6601800 Taxes-Employer Payroll163.20 326.00 (162.80) 1,397.40 2,934.00 (1,536.60) 3,912.00 2,514.60 64.3%Total-MKT-SALARIES & BENEFITS2,762.71 3,276.00 (513.29) 23,798.26 29,484.00 (5,685.74) 39,313.00 15,514.74 39.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office- 100.00 (100.00) 888.61 900.00 (11.39) 1,200.00 311.39 25.9%6603768 Supplies-Printing & Stationery131.14 125.00 6.14 5,406.08 4,050.00 1,356.08 4,425.00 (981.08) -22.2%131.14 225.00 (93.86) 6,294.69 4,950.00 1,344.69 5,625.00 (669.69) -11.9%66-MKT-UTILITIES6607840 Utilities-Telephone 170.31 100.00 70.31 2,607.14 900.00 1,707.14 1,200.00 (1,407.14) -117.3%Total-MKT-UTILITIES170.31 100.00 70.31 2,607.14 900.00 1,707.14 1,200.00 (1,407.14) -117.3%66-MKT-OTHER EXPENSES6609010 Advertising17,970.96 18,980.00 (1,009.04) 127,038.65 137,478.00 (10,439.35) 169,987.00 42,948.35 25.3%6609040 Business Meals- 25.00 (25.00) - 225.00 (225.00) 300.00 300.00 100.0%6609080 Collateral Material640.08 500.00 140.08 6,473.65 3,000.00 3,473.65 5,500.00 (973.65) -17.7%6609102 Contract Services-Web Page99.00 150.00 (51.00) 594.00 1,350.00 (756.00) 1,800.00 1,206.00 67.0%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) 700.00 550.00 150.00 700.00 - 0.0%6609633 Promotion-Community- 75.00 (75.00) 913.85 2,025.00 (1,111.15) 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- - - - 2,000.00 (2,000.00) 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- 300.00 (300.00) - 735.00 (735.00) 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) 299.07 550.00 (250.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES18,710.04 20,230.00 (1,519.96) 136,019.22 148,613.00 (12,593.78) 183,822.00 47,802.78 26.0%21,774.20 23,831.00 (2,056.80) 168,719.31 183,947.00 (15,227.69) 229,960.00 61,240.69 26.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetMarch 20199 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,681.76 1,509.00 1,172.76 21,447.85 13,581.00 7,866.85 18,108.00 (3,339.85) -18.4%6701325 Insurance-Workers Comp445.68 677.00 (231.32) 4,774.90 5,869.00 (1,094.10) 7,905.00 3,130.10 39.6%6701720 Salaries13,533.80 13,851.00 (317.20) 113,239.60 124,059.00 (10,819.40) 177,996.00 64,756.40 36.4%6701800 Taxes-Employer Payroll1,348.24 2,349.00 (1,000.76) 11,941.84 20,361.00 (8,419.16) 32,800.00 20,858.16 63.6%6701880 Wages-Hourly3,269.82 4,211.00 (941.18) 27,799.73 32,516.00 (4,716.27) 27,404.00 (395.73) -1.4%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS21,279.30 22,597.00 (1,317.70) 179,203.92 196,386.00 (17,182.08) 264,213.00 85,009.08 32.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 2,393.04 4,500.00 (2,106.96) 6,300.00 3,906.96 62.0%6703762 Supplies-Office97.60 105.00 (7.40) 549.27 945.00 (395.73) 1,260.00 710.73 56.4%6703768 Supplies-Printing & Stationery326.18 400.00 (73.82) 1,823.76 2,100.00 (276.24) 3,300.00 1,476.24 44.7%Total-G&A-SUPPLIES & MATERIALS423.78 1,005.00 (581.22) 4,766.07 7,545.00 (2,778.93) 10,860.00 6,093.93 56.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 683.14 1,600.00 (916.86) 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 683.14 1,600.00 (916.86) 1,900.00 1,216.86 64.0%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) 330.00 750.00 (420.00) 1,150.00 820.00 71.3%6709180 Employee Recruiting/Relocation120.00 200.00 (80.00) 1,288.01 1,200.00 88.01 1,200.00 (88.01) -7.3%6709197 Equipment Rental748.30 550.00 198.30 4,762.59 4,950.00 (187.41) 6,600.00 1,837.41 27.8%6709202 Fees-Bank99.30 90.00 9.30 815.72 810.00 5.72 1,080.00 264.28 24.5%6709208 Fees-Payroll Processing390.35 1,000.00 (609.65) 5,051.90 9,000.00 (3,948.10) 12,000.00 6,948.10 57.9%6709220 Freight/Delivery- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6709490 Miscellaneous37.48 100.00 (62.52) 3,757.46 6,300.00 (2,542.54) 6,600.00 2,842.54 43.1%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services113.11 75.00 38.11 920.02 675.00 245.02 900.00 (20.02) -2.2%6709625 Professional Fees1,033.50 850.00 183.50 7,341.95 7,650.00 (308.05) 10,200.00 2,858.05 28.0%6709636 Promotion/Entertainment- 100.00 (100.00) 129.41 900.00 (770.59) 1,200.00 1,070.59 89.2%6709722 Seminars & Training250.00 200.00 50.00 500.00 1,800.00 (1,300.00) 2,400.00 1,900.00 79.2%6709810 Travel- - - - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 957.27 825.00 132.27 1,050.00 92.73 8.8%Total-G&A-OTHER EXPENSES3,292.04 3,840.00 (547.96) 30,354.33 40,010.00 (9,655.67) 52,080.00 21,725.67 41.7%24,995.12 27,542.00 (2,546.88) 215,007.46 245,541.00 (30,533.54) 329,053.00 114,045.54 34.7%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetMarch 201910 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 9,829.27 10,050.00 (220.73) 88,463.44 90,900.00 (2,436.56) 121,050.00 32,586.56 26.9%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 82,630.80 85,500.00 (2,869.20) 114,000.00 31,369.20 27.5%6800194 Equipment Leases-Trailer635.60 600.00 35.60 6,010.16 5,400.00 610.16 7,200.00 1,189.84 16.5%6800196 Equipment Leases-GPS2,940.00 3,900.00 (960.00) 33,900.00 35,100.00 (1,200.00) 46,800.00 12,900.00 27.6%6800197 Equipment Leases-Others2,089.33 1,950.00 139.33 18,652.40 14,350.00 4,302.40 20,200.00 1,547.60 0.0%24,675.40 26,000.00(1,324.60) 229,656.80231,250.00 (1,593.20) 309,250.00 79,593.20 25.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 85,500.00 85,500.00 - 114,000.00 28,500.00 25.0%6900210 FF&E Reserve11,684.34 11,941.50 (257.16) 48,950.79 50,529.36 (1,578.57) 68,026.00 19,075.21 28.0%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 36,295.19 36,000.00 295.19 48,000.00 11,704.81 24.4%26,156.68 25,441.50715.18 185,484.19183,829.36 1,654.83 241,826.00 56,341.81 23.3%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to DateYear to DateMarch 201911