Loading...
10 April 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2015 – April 2016 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Course Maintenance Expense Statement 4 Outside Service Expense Statement 6 Clubhouse Expense Statement 7 Marketing Expense Statement 8 General & Administrative Expense Statement 9 Operating Leases & Miscellaneous Expense Statement 10 Complimentary Report 11 Annual BudgetAccount Description AprilFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue369,253.27 408,915.00 (39,661.73) -9.7% 2,741,996.73 2,773,173.00 (31,176.27) 3,199,237.00 457,240.27 86%401000 Miscellaneous Golf Revenue37,973.50 34,065.00 3,908.50 11.5% 332,508.89 298,470.00 34,038.89 349,259.00 16,750.11 95%410000 Revenue-Golf Shop30,136.59 33,751.00 (3,614.41) -10.7% 209,253.54 234,188.00 (24,934.46) 278,585.00 69,331.46 75%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,000.00 11,000.00 - 12,000.00 1,000.00 92%890000 Interest Income- - - 12.40 - 12.40 - (12.40) 0%Total Income437,863.36 477,231.00 (39,367.64) -8.2% 3,294,771.56 3,316,831.00 (22,059.44) 3,839,081.00 544,309.44 86%Cost of Goods Sold510000 COS-Golf Shop17,123.18 18,890.58 (1,767.40) 9.4% 116,549.21 131,074.04 14,524.83 155,924.00 39,374.79 75%Total COS17,123.18 18,890.58 (1,767.40) 9.4% 116,549.21 131,074.04 14,524.83 155,924.00 39,374.79 75%Gross Profit420,740.18 458,340.42 (37,600.24) -8.2% 3,178,222.35 3,185,756.96 (7,534.61) 3,683,157.00 504,934.65 86%Expenses610000 Golf Pro Shop 18,217.67 17,813.00 404.67 -2.3% 159,305.78 165,788.00 (6,482.22) 204,827.00 45,521.22 78%630000 Course Maintenance119,971.78 123,124.00 (3,152.22) 2.6% 1,441,733.42 1,475,946.00 (34,212.58) 1,712,795.00 271,061.58 84%633000 Maintenance Water & Energy21,875.88 20,967.00 908.88 -4.3% 186,734.32 172,817.00 13,917.32 225,129.00 38,394.68 83%640000 Outside Services41,811.40 31,096.00 10,715.40 -34.5% 283,599.72 269,149.00 14,450.72 309,830.00 26,230.28 92%650000 Clubhouse10,996.60 10,636.00 360.60 -3.4% 116,209.45 114,660.00 1,549.45 136,332.00 20,122.55 85%660000 Marketing20,268.68 22,799.00 (2,530.32) 11.1% 206,369.97 216,613.00 (10,243.03) 240,177.00 33,807.03 86%670000 General & Administrative26,213.20 27,361.00 (1,147.80) 4.2% 253,119.38 271,742.00 (18,622.62) 327,511.00 74,391.62 77%680000 Leases22,230.84 22,550.00 (319.16) 1.4% 225,205.30 225,950.00 (744.70) 271,050.00 45,844.70 83%690000 Miscellaneous Other Expense18,567.16 18,698.00 (130.84) 0.7% 186,070.61 172,465.00 13,605.61 202,025.00 15,954.39 92%Total Expenses300,153.21 295,044.00 5,109.21 -1.7% 3,058,347.95 3,085,130.00 26,782.05 3,629,676.00 571,328.05 84%120,586.97 163,296.42 (42,709.45) -26.2%119,874.40 100,626.96 19,247.44 53,481.00 (66,393.40) 0%Rounds of Golf PlayedPaid Rounds Played5,665 5,400 265 4.9%39,451 38,975 476 41,100 1,649 96%Ave $ Per Paid Round Green Fee65.18 75.73 (10.54) -13.9%69.50 71.15 (1.65) 77.84 8.34 89%Ave $ Per Paid Round Merchandise5.32 6.25 (0.93) -14.9%5.30 6.01 (0.70) 6.78 1.47 78%Ave $ Per Paid Miscellaneous 6.70 6.31 0.39 6.3%8.43 7.66 0.77 8.50 0.07 99%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateApril 20161 Income AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees369,253.27 408,915.00 (39,661.73) 2,741,996.73 2,773,173.00 (31,176.27) 3,199,237.00 457,240.27 14.3%4010000 Rider Fee1,600.00 540.00 1,060.00 10,370.00 6,998.00 3,372.00 7,738.00 (2,632.00) -34.0%4040000 Club Rental2,985.00 2,700.00 285.00 19,016.00 19,538.00 (522.00) 23,238.00 4,222.00 18.2%4050000 Driving Range10,220.00 8,100.00 2,120.00 93,632.00 89,884.00 3,748.00 100,984.00 7,352.00 7.3%4060000 Handicap Fees- - - - 2,500.00 (2,500.00) 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 2,600.00 (2,600.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract 1,576.00 1,000.00 576.00 3,073.80 4,000.00 (926.20) 4,000.00 926.20 23.2%4091000 Golf Professional Rental Fee 6,862.50 6,000.00 862.50 38,792.09 33,000.00 5,792.09 37,000.00 (1,792.09) -4.8%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue14,730.00 15,625.00 (895.00) 167,625.00 139,950.00 27,675.00 171,200.00 3,575.00 2.1% Total Revenue Fees407,226.77 442,980.00 (35,753.23) 3,074,505.62 3,071,643.00 2,862.62 3,548,497.00 473,991.38 13.4%407,226.77 442,980.00 (35,753.23) 3,074,505.62 3,071,643.00 2,862.62 3,548,497.00 473,991.38 13.4%SilverRock ResortStatement of Fees RevenueApril 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$37,973.50$34,065.003,908.50Favorable: Due to increased in sales of driving range and professional fees.ActualBudgetVariance$30,136.59$33,751.00(3,614.41)Unfavorable: Merchandise sales were down 13% as a result of consumer spending being reduced. The majority of this can be attributed to the weak Canadian Dollar that has become very weak against the Dollar. Nearly 1/3 of our players are Canadian during the winter & season months. ExpensesActualBudgetVariance$41,811.40$31,096.0010,715.40Unfavorable: Due to timing of shipment of bottled water from Niagra.ActualBudgetVariance$20,268.68$22,799.00(2,530.32)Favorable: Due to timing of advertisement invoices, also, we are currently tracking with our year to date budgeted amount.MarketingCartbarn-Course ServicesVariance ExplanationApril 2016The 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 arePro Shop Merchandise SalesMiscellaneous Golf Revenueprovided for those cost of sales percentage that are greater than 5%.3-20-133 Income AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous217.00 - 217.00 2,237.77 - 2,237.77 00 0%4100110 Sales Hard Goods9,855.70 11,813.00 (1,957.30) 70,370.76 81,967.00 (11,596.24) 97,505.00 27,134.24 27.8%4100112 Sales-Soft Goods23,630.00 21,938.00 1,692.00 163,225.50 152,221.00 11,004.50 181,080.00 17,854.50 9.9%5100639 GS-Discounts-Mdse (3,566.11) - (3,566.11) (26,580.49) - (26,580.49) - 26,580.49 0.0% Total Revenue Golf Shop30,136.59 33,751.00 (3,614.41) 209,253.54 234,188.00 (24,934.46) 278,585.00 71,569.23 25.7%COS 5100150 COS-GS-Hard Goods 3,229.24 6,851.54 (3,622.30) 36,619.22 47,540.86 (10,921.64) 56,552.90 19,933.68 35.2%5100151 COS-GS-Soft Goods 13,663.01 12,724.04 938.97 76,902.12 88,288.18 (11,386.06) 105,026.40 28,124.28 26.8%5100152 COS-GS-Purchase Disc- (979.00) 979.00 (130.20) (6,793.00) 6,662.80 (8,079.00) (7,948.80) 98.4%5100220 COS-GS-Freight Merch 230.93 294.00 (63.07) 3,158.07 2,038.00 1,120.07 2,424.00 (734.07) -30.3%Cost of Sales - Golf Shop17,123.18 18,890.58 (1,767.40) 116,549.21 131,074.04 (14,524.83) 155,924.30 39,375.09 25.3%Gross Profit13,013.41 14,860.42 (1,847.01) 92,704.33 103,113.96 (10,409.63) 122,660.70 32,194.14 26.2%COS % 56.8% 56.0% -0.8% 55.7% 56.0% 0.3% 53.1% 55.0% 103.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,053.40 2,387.00 (333.60) 19,387.91 22,847.00 (3,459.09) 27,621.00 8,233.09 29.8%6101325 Insurance-Workers Comp 651.02 456.00 195.02 5,719.78 4,133.00 1,586.78 5,042.00 (677.78) -13.4%6101720 Salaries4,002.00 3,950.00 52.00 39,064.35 39,500.00 (435.65) 45,000.00 5,935.65 13.2%6101800 Taxes-Employer Payroll 1,507.62 1,702.00 (194.38) 13,629.00 15,432.00 (1,803.00) 18,825.00 5,196.00 27.6%6101880 Wages-Hourly8,303.51 8,208.00 95.51 69,949.32 70,736.00 (786.68) 89,463.00 19,513.68 21.8%6101882 Wages-Overtime63.01 - 63.01 436.70 - 436.70 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 16,580.56 16,703.00 (122.44) 148,187.06 152,648.00 (4,460.94) 185,951.00 39,153.52 21.1%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 273.99 - 273.99 - (273.99) 0.0%6103762 Supplies-Office492.99 250.00 242.99 1,881.44 2,500.00 (618.56) 3,000.00 1,118.56 37.3%6109220 Freight & Delivery49.94 - 49.94 396.74 75.00 321.74 75.00 (321.74) -429.0%6109490 Miscellaneous500.00 500.00 - 4,582.24 5,000.00 (417.76) 6,000.00 1,417.76 23.6%6109150 Dues and Subscriptions- - - 102.30 - 102.30 2,300.00 2,197.70 95.6%6109500 ProShop-Over/Short123.10 - 123.10 188.69 - 188.69 - (188.69) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 2,405.00 (2,405.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 60.00 (60.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 2,134.92 2,000.00 134.92 2,400.00 265.08 11.0%6117840 Telephones471.08 110.00 361.08 1,558.40 1,100.00 458.40 1,320.00 (238.40) -18.1%1,637.11 1,110.00 527.11 11,118.72 13,140.00 (2,021.28) 18,875.00 7,756.28 41.1%18,217.67 17,813.00 404.67 159,305.78 165,788.00 (6,482.22) 204,826.00 46,909.80 22.9%Net Income(5,204.26) (2,952.58) (2,251.68) (66,601.45) (62,674.04) (3,927.41) (82,165.30) (14,715.66) 17.9%SilverRock ResortGolf Shop Income StatementApril 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group10,613.46 8,990.00 1,623.46 84,786.93 89,900.00 (5,113.07) 107,880.00 23,093.07 21.4%6311325 Insurance-Workers Comp1,929.60 2,065.00 (135.40) 25,399.74 20,592.00 4,807.74 24,794.00 (605.74) -2.4%6311720 Salaries14,505.30 11,900.00 2,605.30 115,402.90 119,000.00 (3,597.10) 142,017.20 26,614.30 18.7%6311800 Taxes-Employer Payroll6,508.87 7,709.00 (1,200.13) 58,032.22 77,483.00 (19,450.78) 93,302.00 35,269.78 37.8%6311880 Wages-Hourly45,129.91 43,161.00 1,968.91 426,723.30 421,376.00 5,347.30 508,481.80 81,758.50 16.1%6311882 Wages-Overtime- - - 12,421.76 13,076.00 (654.24) 15,945.00 3,523.24 22.1%Total-CM-SALARIES & BENEFITS78,687.14 73,825.00 4,862.14 722,766.85 741,427.00 (18,660.15) 892,420.00 169,653.15 19.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals640.82 2,000.00 (1,359.18) 32,681.03 31,700.00 981.03 34,600.00 1,918.97 5.5%6313744 Fertilizer4,180.00 5,000.00 (820.00) 115,096.75 102,500.00 12,596.75 112,500.00 (2,596.75) -2.3%6313745 Herbicides- - - 19,367.52 17,000.00 2,367.52 17,000.00 (2,367.52) -13.9%6313746 Flowers/Plants- 100.00 (100.00) 1,124.44 3,050.00 (1,925.56) 3,050.00 1,925.56 63.1%6313748 Fuel-Gasoline2,156.05 4,100.00 (1,943.95) 34,651.45 48,820.00 (14,168.55) 55,020.00 20,368.55 37.0%6313750 Golf Course Accessories196.82 100.00 96.82 11,425.14 12,800.00 (1,374.86) 13,000.00 1,574.86 12.1%6313756 POA Control- - - 6,757.37 7,000.00 (242.63) 7,000.00 242.63 3.5%6313758 Miscellaneous Supp863.36 100.00 763.36 7,082.64 4,150.00 2,932.64 4,350.00 (2,732.64) -62.8%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 100.00 (100.00) 1,879.45 13,260.00 (11,380.55) 13,460.00 11,580.55 86.0%6313776 Seed- 350.00 (350.00) 132,015.98 125,200.00 6,815.98 125,900.00 (6,115.98) -4.9%6313778 Small Tools & Non-Capital Equip894.35 100.00 794.35 4,043.85 4,800.00 (756.15) 5,000.00 956.15 19.1%6313780 Sod- - - 5,597.26 9,750.00 (4,152.74) 10,450.00 4,852.74 46.4%6313782 Topdressing- - - 7,213.94 8,000.00 (786.06) 10,600.00 3,386.06 31.9%Total-CM-SUPPLIES & MATERIALS8,931.40 11,950.00 (3,018.60) 378,936.82 388,030.00 (9,093.18) 411,930.00 32,993.18 8.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,210.00 2,600.00 610.00 31,651.50 26,000.00 5,651.50 31,200.00 (451.50) -1.4%6315685 CM-R&M-Bldngs & Othr Structures 150.28 250.00 (99.72) 3,078.46 5,050.00 (1,971.54) 5,550.00 2,471.54 44.5%6315690 CM-R&M-Equipment2,075.85 2,500.00 (424.15) 38,442.14 35,500.00 2,942.14 40,000.00 1,557.86 3.9%6315692 CM-R&M-Irrigation System844.20 1,000.00 (155.80) 15,349.58 17,050.00 (1,700.42) 19,050.00 3,700.42 19.4%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 11,124.86 10,000.00 1,124.86 10,500.00 (624.86) -6.0%6315815 CM-R&M-Trees-Pruning Etc1,000.00 4,000.00 (3,000.00) 9,555.95 12,050.00 (2,494.05) 12,050.00 2,494.05 20.7%Total-CM-REPAIRS & MAINTENANCE7,280.33 11,350.00 (4,069.67) 109,202.49 105,650.00 3,552.49 118,350.00 9,147.51 7.7%6317836 Utilities-Natural Gas/LPG- 15.00 (15.00) 200.56 150.00 50.56 180.00 (20.56) 0.0%6317840 Telephones1,760.37 850.00 910.37 9,943.84 8,500.00 1,443.84 10,200.00 256.16 2.5%Total-CM-UTILITIES1,760.37 865.00 895.37 10,144.40 8,650.00 1,494.40 10,380.00 235.60 2.3%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 500.00 (100.00) 4,900.00 5,000.00 (100.00) 6,000.00 1,100.00 18.3%6319100 Contract Svcs-Soil/Tissue Test- - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal1,041.00 524.00 517.00 7,669.07 5,240.00 2,429.07 6,288.00 (1,381.07) -22.0%6319150 Dues & Subscriptions- 200.00 (200.00) 1,170.00 440.00 730.00 540.00 (630.00) -116.7%6319170 Employee Education- 50.00 (50.00) 1,650.99 1,450.00 200.99 1,550.00 (100.99) -6.5%6319197 Equipment Rental- 200.00 (200.00) 911.44 3,100.00 (2,188.56) 3,400.00 2,488.56 73.2%6319206 Licenses & Permits2,084.00 2,900.00 (816.00) 2,307.89 4,180.00 (1,872.11) 4,180.00 1,872.11 44.8%6319490 Miscellaneous132.39 100.00 32.39 728.53 1,000.00 (271.47) 1,200.00 471.47 39.3%6319718 Safety Equipment & Training209.49 100.00 109.49 4,313.58 3,650.00 663.58 3,850.00 (463.58) -12.0%6319822 Uniforms1,826.33 920.00 906.33 10,537.92 9,200.00 1,337.92 11,040.00 502.08 4.5%Total-CM-OTHER EXPENSES5,693.21 5,494.00 199.21 36,189.42 35,260.00 929.42 42,048.00 5,858.58 13.9%SilverRock ResortCourse Maintenance Expense StatementApril 2016Annual BudgetMonth to DateYear to Date5 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.25 2,728.00 (410.75) 24,267.85 27,280.00 (3,012.15) 32,736.00 8,468.15 25.9%6321325 Insurance-Workers Comp301.50 519.00 (217.50) 4,372.99 5,107.00 (734.01) 6,171.00 1,798.01 29.1%6321800 Taxes-Employer Payroll1,060.94 1,938.00 (877.06) 13,662.13 19,314.00 (5,651.87) 23,334.00 9,671.87 41.4%6321880 Wages-Hourly13,770.20 13,840.00 (69.80) 135,837.53 132,640.00 3,197.53 160,320.00 24,482.47 15.3%6321882 Wages-Overtime- - - 4,181.01 5,313.00 (1,131.99) 6,351.00 2,169.99 34.2%Total-CM-LM-SALARIES & BENEFITS17,449.89 19,025.00 (1,575.11) 182,321.51 189,654.00 (7,332.49) 228,912.00 46,590.49 20.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 875.00 (875.00) 1,025.00 1,025.00 100.0%6323788 Uniforms169.44 290.00 (120.56) 2,171.93 2,900.00 (728.07) 3,480.00 1,308.07 37.6%Total-CM-LM-SUPPLIES & MATERIALS169.44 365.00 (195.56) 2,171.93 3,775.00 (1,603.07) 4,505.00 2,333.07 51.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) - 3,500.00 (3,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 3,500.00 (3,500.00) 4,250.00 4,250.00 100.0%119,971.78 123,124.00 (3,152.22) 1,441,733.42 1,475,946.00 (34,212.58) 1,712,795.00 271,061.58 15.8% AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 19,701.39 19,417.00 284.39 148,109.47 137,244.00 10,865.47 179,791.00 31,681.53 17.6%6337842 Utilities-Water2,174.49 1,550.00 624.49 38,624.85 35,573.00 3,051.85 45,338.00 6,713.15 14.8%21,875.88 20,967.00 908.88 186,734.32 172,817.00 13,917.32 225,129.00 38,394.68 17.1%Silverrock ResortCourse Maintenance Water & EnergyApril 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementApril 2016Silverrock ResortAnnual BudgetMonth to DateYear to Date6 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 6,820.00 (6,820.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp785.04 613.00 172.04 6,924.36 4,430.00 2,494.36 5,229.00 (1,695.36) -32.4%6411800 Taxes-Employer Payroll2,747.14 2,036.00 711.14 16,882.45 14,709.00 2,173.45 17,360.00 477.55 2.8%6411880 Wages-Hourly17,687.00 16,350.00 1,337.00 128,297.62 118,135.00 10,162.62 139,434.00 11,136.38 8.0%6411882 Wages-Overtime 1,117.50 - 1,117.50 2,505.29 - 2,505.29 - (2,505.29) 0.0%Total-CBR-SALARIES & BENEFITS22,336.68 19,681.00 2,655.68 154,609.72 144,094.00 10,515.72 170,207.00 15,597.28 9.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 56.20 50.00 6.20 3,313.08 1,750.00 1,563.08 1,850.00 `0.0%6413742 Supplies-Expendable1,418.24 150.00 1,268.24 6,143.76 5,750.00 393.76 6,750.00 606.24 9.0%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) - 2,700.00 (2,700.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - 9,000.00 9,000.00 - 9,000.00 - 0.0%6413762 Supplies-Office- 50.00 (50.00) - 425.00 (425.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 94.87 280.00 (185.13) 420.00 325.13 77.4%6413786 Supplies-Towels 427.10 250.00 177.10 2,667.10 1,860.00 807.10 2,182.00 (485.10) -22.2%6413796 Supplies-Bottled Water6,955.20 50.00 6,905.20 12,224.40 10,900.00 1,324.40 11,000.00 (1,224.40) -11.1%Total-CBR-SUPPLIES & MATERIALS8,856.74 1,070.00 7,786.74 33,443.21 32,665.00 778.21 34,727.00 2,746.87 7.9%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 3,986.38 3,000.00 986.38 3,600.00 (386.38) -10.7%6415695 CBR-R&M-Cart Maintenance & Repair 1,049.82 500.00 549.82 10,286.68 5,450.00 4,836.68 6,450.00 (3,836.68) -59.5%Total-CBR-REPAIRS & MAINTENANCE1,049.82 800.00 249.82 14,273.06 8,450.00 5,823.06 10,050.00 (4,223.06) -42.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen765.28 800.00 (34.72) 5,687.78 8,000.00 (2,312.22) 9,600.00 3,912.22 40.8%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous660.34 600.00 60.34 4,096.12 6,000.00 (1,903.88) 7,200.00 3,103.88 43.1%6419820 Uniforms - - - 2,917.33 3,500.00 (582.67) 5,200.00 2,282.67 43.9%Total-CBR-OTHER EXPENSES1,425.62 1,400.00 25.62 12,701.23 17,950.00 (5,248.77) 22,450.00 9,748.77 43.4%TOTAL-CARTS,BAGROOM & RANGE33,668.86 22,951.00 25.62 215,027.22 203,159.00 11,868.22 237,434.00 23,869.86 10.1%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp351.02 242.00 109.02 3,415.16 1,988.00 1,427.16 2,179.00 (1,236.16) -56.7%6431800 Taxes-Employer Payroll1,049.85 903.00 146.85 6,491.64 7,420.00 (928.36) 8,135.00 1,643.36 20.2%6431880 Wages-Hourly6,412.50 6,450.00 (37.50) 54,975.12 53,007.00 1,968.12 58,108.00 3,132.88 5.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,813.37 7,595.00 218.37 64,881.92 62,415.00 2,466.92 68,422.00 3,540.08 5.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable 279.17 100.00 179.17 906.72 900.00 6.72 1,050.00 143.28 13.6%6439490 Miscellaneous- - - 1,031.60 200.00 831.60 200.00 (831.60) -415.8%6439718 Safety Equipment & Training50.00 50.00 - 50.00 500.00 (450.00) 600.00 550.00 91.7%6439820 Uniforms - 400.00 (400.00) 1,702.26 1,975.00 (272.74) 2,125.00 422.74 19.9%Total-CS-OTHER EXPENSES329.17 550.00 (220.83) 3,690.58 3,575.00 115.58 3,975.00 284.42 7.2%Total-COURSE SERVICES8,142.54 8,145.00 (2.46) 68,572.50 65,990.00 2,582.50 72,397.00 3,824.50 5.3%41,811.40 31,096.00 10,715.40 283,599.72 269,149.00 14,450.72 309,831.00 27,409.94 8.8%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementApril 2016Annual Budget7 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,005.00 4,000.00 5.00 4,800.00 795.00 16.6%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,005.00 4,000.00 5.00 4,800.00 795.00 16.6%65-CH-UTILITIES6507836 Utilities-Natural Gas518.50 300.00 218.50 4,198.45 3,000.00 1,198.45 3,600.00 (598.45) -16.6%6507840 Utilities-Telephone1,106.14 1,150.00 (43.86) 9,727.30 11,500.00 (1,772.70) 13,800.00 4,072.70 29.5%6507842 Utilities-Water430.80 321.00 109.80 8,033.89 3,210.00 4,823.89 3,852.00 (4,181.89) -108.6%6507844 Utilities-Cable 579.49 340.00 239.49 5,300.31 3,400.00 1,900.31 4,080.00 (1,220.31) -29.9%Total-CH-UTILITIES2,634.93 2,111.00 523.93 27,259.95 21,110.00 6,149.95 25,332.00 (1,927.95) -7.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,900.00 1,825.00 75.00 18,522.00 18,850.00 (328.00) 22,500.00 3,978.00 17.7%6509099 Contract Services-Security5,094.72 4,900.00 194.72 52,684.40 50,600.00 2,084.40 60,400.00 7,715.60 12.8%6509215 Flowers & Decorations- - - 586.16 1,500.00 (913.84) 1,900.00 1,313.84 69.1%6509490 Miscellaneous127.46 200.00 (72.54) 2,843.62 6,600.00 (3,756.38) 7,000.00 4,156.38 59.4%6509718 Safety Equipment & Training- 100.00 (100.00) 320.32 1,000.00 (679.68) 1,200.00 879.68 73.3%Total-CH-OTHER EXPENSES7,122.18 7,025.00 97.18 74,956.50 78,550.00 (3,593.50) 93,000.00 18,043.50 19.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures331.76 300.00 31.76 3,708.30 3,000.00 708.30 3,600.00 (108.30) -3.0%6515686 CH-R&M-Restaurant Repairs205.04 400.00 (194.96) 3,544.97 4,000.00 (455.03) 4,800.00 1,255.03 26.1%6515690 CH-R&M-Equipment Repair302.69 400.00 (97.31) 2,734.73 4,000.00 (1,265.27) 4,800.00 2,065.27 43.0%Total-CH-REPAIRS & MAINTENANCE839.49 1,100.00 (260.51) 9,988.00 11,000.00 (1,012.00) 13,200.00 3,212.00 24.3%10,996.60 10,636.00 360.60 116,209.45 114,660.00 1,549.45 136,332.00 6,424.00 4.7%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementApril 2016Annual Budget8 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group - 341.00 (341.00) 3,075.80 3,410.00 (334.20) 4,092.00 1,016.20 24.8%6601325 Insurance-Workers Comp87.00 94.00 (7.00) 763.20 940.00 (176.80) 1,129.00 365.80 32.4%6601720 Salaries1,904.96 2,508.00 (603.04) 19,801.04 25,080.00 (5,278.96) 30,096.00 10,294.96 34.2%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 2,312.72 3,510.00 (1,197.28) 4,213.00 1,900.28 45.1%Total-MKT-SALARIES & BENEFITS2,137.16 3,294.00 (1,156.84) 25,952.76 32,940.00 (6,987.24) 39,530.00 13,577.24 34.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 659.01 1,000.00 (340.99) 1,200.00 540.99 45.1%6603768 Supplies-Printing & Stationery- 125.00 (125.00) 4,949.77 4,175.00 774.77 4,425.00 (524.77) -11.9%- 225.00 (225.00) 5,608.78 5,175.00 433.78 5,625.00 16.22 0.3%66-MKT-UTILITIES6607840 Utilities-Telephone110.00 100.00 10.00 590.48 1,000.00 (409.52) 1,200.00 609.52 50.8%Total-MKT-UTILITIES110.00 100.00 10.00 590.48 1,000.00 (409.52) 1,200.00 609.52 50.8%66-MKT-OTHER EXPENSES6609010 Advertising15,929.04 18,230.00 (2,300.96) 163,396.09 165,413.00 (2,016.91) 178,987.00 15,590.91 8.7%6609040 Business Meals- - - - - - 300.00 300.00 100.0%6609080 Collateral Material- 500.00 (500.00) 6,596.48 3,500.00 3,096.48 5,500.00 (1,096.48) -19.9%6609102 Contract Services-Web Page99.00 150.00 (51.00) 1,386.00 1,500.00 (114.00) 1,800.00 414.00 23.0%6609490 Miscellaneous- 50.00 (50.00) - 300.00 (300.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) 158.97 500.00 (341.03) 600.00 441.03 73.5%6609630 Promotion- 25.00 (25.00) - 250.00 (250.00) 700.00 700.00 100.0%6609633 Promotion-Community646.86 125.00 521.86 723.36 2,700.00 (1,976.64) 2,250.00 1,526.64 67.9%6609634 Promotion-Media/Vendor1,346.62 - 1,346.62 1,346.62 2,000.00 (653.38) 2,000.00 653.38 32.7%6609150 Dues and Subscriptions- - - 110.00 735.00 (625.00) 735.00 625.00 85.0%6609820 Uniforms- 50.00 (50.00) 500.43 600.00 (99.57) 600.00 99.57 16.6%Total-MKT-OTHER EXPENSES18,021.52 19,180.00 (1,158.48) 174,217.95 177,498.00 (3,280.05) 193,822.00 19,604.05 10.1%20,268.68 22,799.00 (2,530.32) 206,369.97 216,613.00 (10,243.03) 240,177.00 33,807.03 14.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementApril 2016Annual Budget9 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,030.38 1,488.00 (457.62) 12,362.85 14,880.00 (2,517.15) 17,856.00 5,493.15 30.8%6701325 Insurance-Workers Comp- 662.00 (662.00) 5,735.54 6,394.00 (658.46) 7,717.00 1,981.46 25.7%6701720 Salaries15,421.00 15,050.00 371.00 140,275.50 144,500.00 (4,224.50) 177,996.00 37,720.50 21.2%6701800 Taxes-Employer Payroll1,084.72 2,471.00 (1,386.28) 18,034.00 23,870.00 (5,836.00) 28,812.00 10,778.00 37.4%6701880 Wages-Hourly3,238.20 2,600.00 638.20 27,762.00 25,998.00 1,764.00 27,800.00 38.00 0.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,774.30 22,271.00 (1,496.70) 204,169.89 215,642.00 (11,472.11) 260,181.00 56,011.11 21.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer62.84 500.00 (437.16) 1,364.56 5,000.00 (3,635.44) 6,300.00 4,935.44 78.3%6703762 Supplies-Office217.34 150.00 67.34 1,382.24 1,500.00 (117.76) 1,800.00 417.76 23.2%6703768 Supplies-Printing & Stationery115.50 400.00 (284.50) 2,048.51 2,500.00 (451.49) 3,300.00 1,251.49 37.9%Total-G&A-SUPPLIES & MATERIALS395.68 1,050.00 (654.32) 4,795.31 9,000.00 (4,204.69) 11,400.00 6,604.69 57.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment7.50 100.00 (92.50) 1,307.50 1,700.00 (392.50) 1,900.00 592.50 31.2%Total-G&A-REPAIRS & MAINTENANCE7.50 100.00 (92.50) 1,307.50 1,700.00 (392.50) 1,900.00 592.50 31.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%6709150 Dues & Subscriptions- 50.00 (50.00) 419.00 1,150.00 (731.00) 1,700.00 1,281.00 75.4%6709180 Employee Recruiting/Relocation30.00 - 30.00 1,347.78 1,400.00 (52.22) 1,400.00 52.22 3.7%6709197 Equipment Rental813.62 550.00 263.62 6,512.17 5,500.00 1,012.17 6,600.00 87.83 1.3%6709202 Fees-Bank53.90 90.00 (36.10) 1,267.33 900.00 367.33 1,080.00 (187.33) -17.3%6709208 Fees-Payroll Processing1,156.81 1,200.00 (43.19) 12,308.73 12,000.00 308.73 14,400.00 2,091.27 14.5%6709220 Freight/Delivery- 50.00 (50.00) 10.68 500.00 (489.32) 600.00 589.32 98.2%6709490 Miscellaneous- 100.00 (100.00) 4,223.20 6,400.00 (2,176.80) 1,200.00 (3,023.20) -251.9%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services193.73 75.00 118.73 1,080.81 750.00 330.81 900.00 (180.81) -20.1%6709625 Professional Fees1,547.66 850.00 697.66 9,282.78 8,500.00 782.78 10,200.00 917.22 9.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 1,000.00 (1,000.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 834.70 2,000.00 (1,165.30) 2,400.00 1,565.30 65.2%6709810 Travel- 200.00 (200.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 719.50 900.00 (180.50) 1,050.00 330.50 31.5%Total-G&A-OTHER EXPENSES5,035.72 3,940.00 2,070.72 42,846.68 45,400.00 (2,553.32) 54,030.00 11,183.32 20.7%26,213.20 27,361.00 (1,147.80) 253,119.38 271,742.00 (18,622.62) 327,511.00 74,391.62 22.7%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementApril 2016Annual Budget10 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 103,634.50 100,500.00 3,134.50 121,050.00 17,415.50 14.4%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 55,715.00 60,950.00 (5,235.00) 72,600.00 16,885.00 23.3%6800194 Equipment Leases-Trailer823.88 600.00 223.88 4,924.76 6,000.00 (1,075.24) 7,200.00 2,275.24 31.6%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 45,000.00 47,000.00 (2,000.00) 56,400.00 11,400.00 20.2%6800197 Equipment Leases-Others972.01 1,150.00 (177.99) 15,931.04 11,500.00 4,431.04 13,800.00 (2,131.04) 0.0%22,230.84 22,550.00 (319.16) 225,205.30 225,950.00 (744.70) 271,050.00 45,844.70 16.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 83,200.00 83,200.00 - 99,840.00 16,640.00 16.7%6900210 FF&E Reserve7,385.07 8,178.00 (792.93) 54,839.94 55,465.00 (625.06) 63,985.00 9,145.06 14.3%6900800 Personal Property Taxes- - - 12,117.83 11,800.00 317.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial2,862.09 2,200.00 662.09 35,912.84 22,000.00 13,912.84 26,400.00 (9,512.84) -36.0%18,567.16 18,698.00 (130.84) 186,070.61 172,465.00 13,605.61 202,025.00 15,954.39 7.9%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementApril 2016Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐20162015 2015 2015 2015 2015 2015Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia24414SalesPromotion4Golf IndustryVIPCelebrityPGA Comp383738112366Charity/Gift Certificate72626Rain/Wind Checks12129Club Staff956280652111LQ HS Golf2117182530168 121 14319112 2602016 2016 2016 2016 2016 2016Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia4224SalesPromotion4Golf IndustryVIPCelebrityPGA Comp43424446Charity/Gift Certificate42612Rain/Wind Checks1134Club Staff77668351LQ HS Golf2624178 110159 137 316 2270012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐2016April 2016 Date Time DescriptionCategoryPlayers4/4/2016 10:00 a.m. Kris Long Media 413