Loading...
09 March 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2015 – March 2016 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 Revenue543,909.76 554,175.00 (10,265.24) -1.9% 2,372,743.46 2,364,258.00 8,485.46 3,199,237.00 826,493.54 74%401000 Miscellaneous Golf Revenue50,948.50 44,625.00 6,323.50 14.2% 294,535.39 264,405.00 30,130.39 349,259.00 54,723.61 84%410000 Revenue-Golf Shop40,844.03 42,000.00 (1,155.97) -2.8% 179,116.95 200,437.00 (21,320.05) 278,585.00 99,468.05 64%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- - - 11.98 - 11.98 - (11.98) 0%Total Income637,202.29 642,300.00 (5,097.71) -0.8% 2,856,907.78 2,839,600.00 17,307.78 3,839,081.00 982,173.22 74%Cost of Goods Sold510000 COS-Golf Shop21,719.48 23,507.00 (1,787.52) 7.6% 99,426.03 112,183.46 12,757.43 155,924.00 56,497.97 64%Total COS21,719.48 23,507.00 (1,787.52) 7.6% 99,426.03 112,183.46 12,757.43 155,924.00 56,497.97 64%Gross Profit615,482.81 618,793.00 (3,310.19) -0.5% 2,757,481.75 2,727,416.54 30,065.21 3,683,157.00 925,675.25 75%Expenses610000 Golf Pro Shop 17,295.19 18,519.00 (1,223.81) 6.6% 141,088.11 147,975.00 (6,886.89) 204,827.00 63,738.89 69%630000 Course Maintenance116,159.13 118,874.00 (2,714.87) 2.3% 1,321,916.69 1,352,822.00 (30,905.31) 1,712,795.00 390,878.31 77%633000 Maintenance Water & Energy17,128.36 16,555.00 573.36 -3.5% 164,858.44 151,850.00 13,008.44 225,129.00 60,270.56 73%640000 Outside Services36,252.68 33,155.00 3,097.68 -9.3% 241,788.32 238,053.00 3,735.32 309,830.00 68,041.68 78%650000 Clubhouse11,267.69 13,436.00 (2,168.31) 16.1% 105,212.85 104,024.00 1,188.85 136,332.00 31,119.15 77%660000 Marketing21,768.36 24,549.00 (2,780.64) 11.3% 186,101.29 193,814.00 (7,712.71) 240,177.00 54,075.71 77%670000 General & Administrative25,798.62 27,361.00 (1,562.38) 5.7% 225,983.83 244,381.00 (18,397.17) 327,511.00 101,527.17 69%680000 Leases22,837.80 22,550.00 287.80 -1.3% 202,974.46 203,400.00 (425.54) 271,050.00 68,075.54 75%690000 Miscellaneous Other Expense22,603.45 21,604.00 999.45 -4.6% 167,503.45 153,767.00 13,736.45 202,025.00 34,521.55 83%Total Expenses291,111.28 296,603.00 (5,491.72) 1.9% 2,757,427.44 2,790,086.00 32,658.56 3,629,676.00 872,248.56 76%324,371.53 322,190.00 2,181.53 0.7%54.31 (62,669.46) 62,723.77 53,481.00 53,426.69 0%Rounds of Golf PlayedPaid Rounds Played6,340 6,200 140 2.3%33,786 33,675 111 41,100 7,314 82%Ave $ Per Paid Round Green Fee85.79 89.38 (3.59) -4.0%70.23 70.21 0.02 77.84 7.61 90%Ave $ Per Paid Round Merchandise6.44 6.77 (0.33) -4.9%5.30 5.95 (0.65) 6.78 1.48 78%Ave $ Per Paid Miscellaneous 8.04 7.20 0.84 11.6%8.72 7.85 0.87 8.50 (0.22) 103%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMarch 20161 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees543,909.76 554,175.00 (10,265.24) 2,372,743.46 2,364,258.00 8,485.46 3,199,237.00 826,493.54 25.8%4010000 Rider Fee1,887.50 1,500.00 387.50 8,770.00 6,458.00 2,312.00 7,738.00 (1,032.00) -13.3%4040000 Club Rental3,030.00 3,000.00 30.00 16,031.00 16,838.00 (807.00) 23,238.00 7,207.00 31.0%4050000 Driving Range16,565.00 18,000.00 (1,435.00) 83,412.00 81,784.00 1,628.00 100,984.00 17,572.00 17.4%4060000 Handicap Fees- 400.00 (400.00) - 2,500.00 (2,500.00) 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 2,500.00 (2,500.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract - - - 1,497.80 3,000.00 (1,502.20) 4,000.00 2,502.20 62.6%4091000 Golf Professional Rental Fee 8,121.00 6,000.00 2,121.00 31,929.59 27,000.00 4,929.59 37,000.00 5,070.41 13.7%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue21,345.00 15,625.00 5,720.00 152,895.00 124,325.00 28,570.00 171,200.00 18,305.00 10.7% Total Revenue Fees594,858.26 598,800.00 (3,941.74) 2,667,278.85 2,628,663.00 38,615.85 3,548,497.00 881,218.15 24.8%594,858.26 598,800.00 (3,941.74) 2,667,278.85 2,628,663.00 38,615.85 3,548,497.00 881,218.15 24.8%SilverRock ResortStatement of Fees RevenueMarch 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$50,948.50$44,625.006,323.50Favorable: Due to increased in the sale of resident cards and an additional professional fee income.ExpensesActualBudgetVariance$11,267.69$13,436.00(2,168.31)Favorable: Due to timing of Miscellaneous Expense for the month. Miscellaneous Expenses to be recognized in the next month or two.ActualBudgetVariance$21,768.36$24,549.00(2,780.64)Favorable: Due to timing of advertisement invoices, also, we are currently tracking with our year to date budgeted amount.Miscellaneous Golf Revenueprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationMarch 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 areMarketingClubhouse3-20-133 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous318.75 - 318.75 2,020.77 - 2,020.77 00 0%4100110 Sales Hard Goods 10,919.58 14,700.00 (3,780.42) 60,515.06 70,154.00 (9,638.94) 97,505.00 36,989.94 37.9%4100112 Sales-Soft Goods34,832.50 27,300.00 7,532.50 139,595.50 130,283.00 9,312.50 181,080.00 41,484.50 22.9%5100639 GS-Discounts-Mdse (5,226.80) - (5,226.80) (23,014.38) - (23,014.38) - 23,014.38 0.0% Total Revenue Golf Shop40,844.03 42,000.00 (1,155.97) 179,116.95 200,437.00 (21,320.05) 278,585.00 101,488.82 36.4%COS 5100150 COS-GS-Hard Goods 5,309.84 8,526.00 (3,216.16) 33,389.98 40,689.32 (7,299.34) 56,552.90 23,162.92 41.0%5100151 COS-GS-Soft Goods 16,133.50 15,834.00 299.50 63,239.11 75,564.14 (12,325.03) 105,026.40 41,787.29 39.8%5100152 COS-GS-Purchase Disc- (1,218.00) 1,218.00 (130.20) (5,814.00) 5,683.80 (8,079.00) (7,948.80) 98.4%5100220 COS-GS-Freight Merch 276.14 365.00 (88.86) 2,927.14 1,744.00 1,183.14 2,424.00 (503.14) -20.8%Cost of Sales - Golf Shop21,719.48 23,507.00 (1,787.52) 99,426.03 112,183.46 (12,757.43) 155,924.30 56,498.27 36.2%Gross Profit19,124.55 18,493.00 631.55 79,690.92 88,253.54 (8,562.62) 122,660.70 44,990.55 36.7%COS % 53.2% 56.0% 2.8% 55.5% 56.0% 0.5% 53.1% 55.7% 104.9%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,514.88 2,387.00 127.88 17,334.51 20,460.00 (3,125.49) 27,621.00 10,286.49 37.2%6101325 Insurance-Workers Comp 651.02 478.00 173.02 5,068.76 3,677.00 1,391.76 5,042.00 (26.76) -0.5%6101720 Salaries4,002.00 3,950.00 52.00 35,062.35 35,550.00 (487.65) 45,000.00 9,937.65 22.1%6101800 Taxes-Employer Payroll 1,838.63 1,786.00 52.63 12,121.38 13,730.00 (1,608.62) 18,825.00 6,703.62 35.6%6101880 Wages-Hourly6,950.14 8,808.00 (1,857.86) 61,645.81 62,528.00 (882.19) 89,463.00 27,817.19 31.1%6101882 Wages-Overtime101.63 - 101.63 373.69 - 373.69 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 16,058.30 17,409.00 (1,350.70) 131,606.50 135,945.00 (4,338.50) 185,951.00 55,671.07 29.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 273.99 - 273.99 - (273.99) 0.0%6103762 Supplies-Office415.45 250.00 165.45 1,388.45 2,250.00 (861.55) 3,000.00 1,611.55 53.7%6109220 Freight & Delivery206.80 - 206.80 346.80 75.00 271.80 75.00 (271.80) -362.4%6109490 Miscellaneous500.00 500.00 - 4,082.24 4,500.00 (417.76) 6,000.00 1,917.76 32.0%6109150 Dues and Subscriptions- - - 102.30 - 102.30 2,300.00 2,197.70 95.6%6109500 ProShop-Over/Short10.44 - 10.44 65.59 - 65.59 - (65.59) 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,134.92 1,800.00 334.92 2,400.00 265.08 11.0%6117840 Telephones104.20 110.00 (5.80) 1,087.32 990.00 97.32 1,320.00 232.68 17.6%1,236.89 1,110.00 126.89 9,481.61 12,030.00 (2,548.39) 18,875.00 9,393.39 49.8%17,295.19 18,519.00 (1,223.81) 141,088.11 147,975.00 (6,886.89) 204,826.00 65,064.46 31.8%Net Income1,829.36 (26.00) 1,855.36 (61,397.19) (59,721.46) (1,675.73) (82,165.30) (20,073.91) 24.4%SilverRock ResortGolf Shop Income StatementMarch 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group9,945.06 8,990.00 955.06 74,173.47 80,910.00 (6,736.53) 107,880.00 33,706.53 31.2%6311325 Insurance-Workers Comp2,929.60 2,065.00 864.60 23,470.14 18,527.00 4,943.14 24,794.00 1,323.86 5.3%6311720 Salaries8,220.80 11,900.00 (3,679.20) 100,897.60 107,100.00 (6,202.40) 142,017.20 41,119.60 29.0%6311800 Taxes-Employer Payroll6,908.86 7,709.00 (800.14) 51,523.35 69,774.00 (18,250.65) 93,302.00 41,778.65 44.8%6311880 Wages-Hourly44,024.50 43,161.00 863.50 381,593.39 378,215.00 3,378.39 508,481.80 126,888.41 25.0%6311882 Wages-Overtime- - - 12,421.76 13,076.00 (654.24) 15,945.00 3,523.24 22.1%Total-CM-SALARIES & BENEFITS72,028.82 73,825.00 (1,796.18) 644,079.71 667,602.00 (23,522.29) 892,420.00 248,340.29 27.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals132.96 1,500.00 (1,367.04) 32,040.21 29,700.00 2,340.21 34,600.00 2,559.79 7.4%6313744 Fertilizer10,631.40 6,000.00 4,631.40 110,916.75 97,500.00 13,416.75 112,500.00 1,583.25 1.4%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 2,950.00 (1,825.56) 3,050.00 1,925.56 63.1%6313748 Fuel-Gasoline1,991.55 3,850.00 (1,858.45) 32,495.40 44,720.00 (12,224.60) 55,020.00 22,524.60 40.9%6313750 Golf Course Accessories- 100.00 (100.00) 11,228.32 12,700.00 (1,471.68) 13,000.00 1,771.68 13.6%6313756 POA Control- - - 6,757.37 7,000.00 (242.63) 7,000.00 242.63 3.5%6313758 Miscellaneous Supp1,032.46 100.00 932.46 6,219.28 4,050.00 2,169.28 4,350.00 (1,869.28) -43.0%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 100.00 (100.00) 1,879.45 13,160.00 (11,280.55) 13,460.00 11,580.55 86.0%6313776 Seed- 350.00 (350.00) 132,015.98 124,850.00 7,165.98 125,900.00 (6,115.98) -4.9%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) 3,149.50 4,700.00 (1,550.50) 5,000.00 1,850.50 37.0%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 & MATERIALS13,788.37 12,200.00 1,588.37 370,005.42 376,080.00 (6,074.58) 411,930.00 41,924.58 10.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,450.00 2,600.00 (150.00) 28,441.50 23,400.00 5,041.50 31,200.00 2,758.50 8.8%6315685 CM-R&M-Bldngs & Othr Structures 235.24 250.00 (14.76) 2,928.18 4,800.00 (1,871.82) 5,550.00 2,621.82 47.2%6315690 CM-R&M-Equipment1,119.05 2,000.00 (880.95) 36,366.29 33,000.00 3,366.29 40,000.00 3,633.71 9.1%6315692 CM-R&M-Irrigation System331.12 1,000.00 (668.88) 14,505.38 16,050.00 (1,544.62) 19,050.00 4,544.62 23.9%6315696 CM-R&M-Pumps984.41 1,000.00 (15.59) 11,124.86 9,000.00 2,124.86 10,500.00 (624.86) -6.0%6315815 CM-R&M-Trees-Pruning Etc- 2,000.00 (2,000.00) 8,555.95 8,050.00 505.95 12,050.00 3,494.05 29.0%Total-CM-REPAIRS & MAINTENANCE5,119.82 8,850.00 (3,730.18) 101,922.16 94,300.00 7,622.16 118,350.00 16,427.84 13.9%6317836 Utilities-Natural Gas/LPG 23.35 15.00 8.35 200.56 135.00 65.56 180.00 (20.56) 0.0%6317840 Telephones238.60 850.00 (611.40) 8,338.52 7,650.00 688.52 10,200.00 1,861.48 18.2%Total-CM-UTILITIES261.95 865.00 (603.05) 8,539.08 7,785.00 754.08 10,380.00 1,840.92 17.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 25.0%6319100 Contract Svcs-Soil/Tissue Test- - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal694.00 524.00 170.00 6,628.07 4,716.00 1,912.07 6,288.00 (340.07) -5.4%6319150 Dues & Subscriptions210.00 - 210.00 1,170.00 240.00 930.00 540.00 (630.00) -116.7%6319170 Employee Education- 50.00 (50.00) 1,650.99 1,400.00 250.99 1,550.00 (100.99) -6.5%6319197 Equipment Rental- 200.00 (200.00) 911.44 2,900.00 (1,988.56) 3,400.00 2,488.56 73.2%6319206 Licenses & Permits- 1,000.00 (1,000.00) 223.89 1,280.00 (1,056.11) 4,180.00 3,956.11 94.6%6319490 Miscellaneous- 100.00 (100.00) 596.14 900.00 (303.86) 1,200.00 603.86 50.3%6319718 Safety Equipment & Training418.51 200.00 218.51 4,104.09 3,550.00 554.09 3,850.00 (254.09) -6.6%6319822 Uniforms856.03 920.00 (63.97) 8,711.59 8,280.00 431.59 11,040.00 2,328.41 21.1%Total-CM-OTHER EXPENSES2,678.54 3,494.00 (815.46) 30,496.21 29,766.00 730.21 42,048.00 11,551.79 27.5%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementMarch 2016Annual Budget5 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 6,214.90 2,728.00 3,486.90 21,950.60 24,552.00 (2,601.40) 32,736.00 10,785.40 32.9%6321325 Insurance-Workers Comp325.51 519.00 (193.49) 4,071.49 4,588.00 (516.51) 6,171.00 2,099.51 34.0%6321800 Taxes-Employer Payroll1,229.43 1,938.00 (708.57) 12,601.19 17,376.00 (4,774.81) 23,334.00 10,732.81 46.0%6321880 Wages-Hourly14,355.83 13,840.00 515.83 122,067.33 118,800.00 3,267.33 160,320.00 38,252.67 23.9%6321882 Wages-Overtime- - - 4,181.01 5,313.00 (1,131.99) 6,351.00 2,169.99 34.2%Total-CM-LM-SALARIES & BENEFITS22,125.67 19,025.00 3,100.67 164,871.62 170,629.00 (5,757.38) 228,912.00 64,040.38 28.0%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 800.00 (800.00) 1,025.00 1,025.00 100.0%6323788 Uniforms155.96 290.00 (134.04) 2,002.49 2,610.00 (607.51) 3,480.00 1,477.51 42.5%Total-CM-LM-SUPPLIES & MATERIALS155.96 365.00 (209.04) 2,002.49 3,410.00 (1,407.51) 4,505.00 2,502.51 55.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) - 3,250.00 (3,250.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 3,250.00 (3,250.00) 4,250.00 4,250.00 100.0%116,159.13 118,874.00 (2,714.87) 1,321,916.69 1,352,822.00 (30,905.31) 1,712,795.00 390,878.31 22.8% MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 16,529.85 15,005.00 1,524.85 128,408.08 117,827.00 10,581.08 179,791.00 51,382.92 28.6%6337842 Utilities-Water598.51 1,550.00 (951.49) 36,450.36 34,023.00 2,427.36 45,338.00 8,887.64 19.6%17,128.36 16,555.00 573.36 164,858.44 151,850.00 13,008.44 225,129.00 60,270.56 26.8%Total-COURSE MAINTENANCECourse Maintenance Expense StatementMarch 2016Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyMarch 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 6,138.00 (6,138.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp1,085.04 613.00 472.04 6,139.32 3,817.00 2,322.32 5,229.00 (910.32) -17.4%6411800 Taxes-Employer Payroll2,743.71 2,036.00 707.71 14,135.31 12,673.00 1,462.31 17,360.00 3,224.69 18.6%6411880 Wages-Hourly18,147.50 16,350.00 1,797.50 110,610.62 101,785.00 8,825.62 139,434.00 28,823.38 20.7%6411882 Wages-Overtime 600.00 - 600.00 1,387.79 - 1,387.79 - (1,387.79) 0.0%Total-CBR-SALARIES & BENEFITS22,576.25 19,681.00 2,895.25 132,273.04 124,413.00 7,860.04 170,207.00 37,933.96 22.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts50.00 50.00 - 3,256.88 1,700.00 1,556.88 1,850.00 `0.0%6413742 Supplies-Expendable113.40 150.00 (36.60) 4,725.52 5,600.00 (874.48) 6,750.00 2,024.48 30.0%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) - 2,250.00 (2,250.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) - 375.00 (375.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary94.87 70.00 24.87 94.87 210.00 (115.13) 420.00 325.13 77.4%6413786 Supplies-Towels - 250.00 (250.00) 2,240.00 1,610.00 630.00 2,182.00 (58.00) -2.7%6413796 Supplies-Bottled Water108.00 50.00 58.00 5,269.20 10,850.00 (5,580.80) 11,000.00 5,730.80 52.1%Total-CBR-SUPPLIES & MATERIALS366.27 1,070.00 (703.73) 24,586.47 31,595.00 (7,008.53) 34,727.00 11,547.41 33.3%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment1,851.09 300.00 1,551.09 3,986.38 2,700.00 1,286.38 3,600.00 (386.38) -10.7%6415695 CBR-R&M-Cart Maintenance & Repair 1,006.18 500.00 506.18 9,236.86 4,950.00 4,286.86 6,450.00 (2,786.86) -43.2%Total-CBR-REPAIRS & MAINTENANCE2,857.27 800.00 2,057.27 13,223.24 7,650.00 5,573.24 10,050.00 (3,173.24) -31.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen402.20 800.00 (397.80) 4,922.50 7,200.00 (2,277.50) 9,600.00 4,677.50 48.7%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 3,435.78 5,400.00 (1,964.22) 7,200.00 3,764.22 52.3%6419820 Uniforms - 500.00 (500.00) 2,917.33 3,500.00 (582.67) 5,200.00 2,282.67 43.9%Total-CBR-OTHER EXPENSES402.20 1,900.00 (1,497.80) 11,275.61 16,550.00 (5,274.39) 22,450.00 11,174.39 49.8%TOTAL-CARTS,BAGROOM & RANGE26,201.99 23,451.00 (1,497.80) 181,358.36 180,208.00 1,150.36 237,434.00 57,482.52 24.2%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp651.02 302.00 349.02 3,064.14 1,746.00 1,318.14 2,179.00 (885.14) -40.6%6431800 Taxes-Employer Payroll1,019.82 1,127.00 (107.18) 5,441.79 6,517.00 (1,075.21) 8,135.00 2,693.21 33.1%6431880 Wages-Hourly7,952.50 8,050.00 (97.50) 48,562.62 46,557.00 2,005.62 58,108.00 9,545.38 16.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS9,623.34 9,479.00 144.34 57,068.55 54,820.00 2,248.55 68,422.00 11,353.45 16.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable427.35 100.00 327.35 627.55 800.00 (172.45) 1,050.00 422.45 40.2%6439490 Miscellaneous- - - 1,031.60 200.00 831.60 200.00 (831.60) -415.8%6439718 Safety Equipment & Training- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 1,702.26 1,575.00 127.26 2,125.00 422.74 19.9%Total-CS-OTHER EXPENSES427.35 225.00 202.35 3,361.41 3,025.00 336.41 3,975.00 613.59 15.4%Total-COURSE SERVICES10,050.69 9,704.00 346.69 60,429.96 57,845.00 2,584.96 72,397.00 11,967.04 16.5%36,252.68 33,155.00 3,097.68 241,788.32 238,053.00 3,735.32 309,831.00 68,835.97 22.2%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementMarch 2016Annual Budget7 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 3,605.00 3,600.00 5.00 4,800.00 1,195.00 24.9%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 3,605.00 3,600.00 5.00 4,800.00 1,195.00 24.9%65-CH-UTILITIES6507836 Utilities-Natural Gas548.20 300.00 248.20 3,679.95 2,700.00 979.95 3,600.00 (79.95) -2.2%6507840 Utilities-Telephone1,114.18 1,150.00 (35.82) 8,621.16 10,350.00 (1,728.84) 13,800.00 5,178.84 37.5%6507842 Utilities-Water924.52 321.00 603.52 7,603.09 2,889.00 4,714.09 3,852.00 (3,751.09) -97.4%6507844 Utilities-Cable 867.14 340.00 527.14 4,720.82 3,060.00 1,660.82 4,080.00 (640.82) -15.7%Total-CH-UTILITIES3,454.04 2,111.00 1,343.04 24,625.02 18,999.00 5,626.02 25,332.00 706.98 2.8%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 16,622.00 17,025.00 (403.00) 22,500.00 5,878.00 26.1%6509099 Contract Services-Security5,289.36 4,900.00 389.36 47,589.68 45,700.00 1,889.68 60,400.00 12,810.32 21.2%6509215 Flowers & Decorations63.73 500.00 (436.27) 586.16 1,500.00 (913.84) 1,900.00 1,313.84 69.1%6509490 Miscellaneous- 2,500.00 (2,500.00) 2,716.16 6,400.00 (3,683.84) 7,000.00 4,283.84 61.2%6509718 Safety Equipment & Training- 100.00 (100.00) 320.32 900.00 (579.68) 1,200.00 879.68 73.3%Total-CH-OTHER EXPENSES7,178.09 9,825.00 (2,646.91) 67,834.32 71,525.00 (3,690.68) 93,000.00 25,165.68 27.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures235.56 300.00 (64.44) 3,376.54 2,700.00 676.54 3,600.00 223.46 6.2%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,339.93 3,600.00 (260.07) 4,800.00 1,460.07 30.4%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,432.04 3,600.00 (1,167.96) 4,800.00 2,367.96 49.3%Total-CH-REPAIRS & MAINTENANCE235.56 1,100.00 (864.44) 9,148.51 9,900.00 (751.49) 13,200.00 4,051.49 30.7%11,267.69 13,436.00 (2,168.31) 105,212.85 104,024.00 1,188.85 136,332.00 8,102.98 5.9%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementMarch 2016Annual Budget8 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 393.80 341.00 52.80 3,075.80 3,069.00 6.80 4,092.00 1,016.20 24.8%6601325 Insurance-Workers Comp- 94.00 (94.00) 676.20 846.00 (169.80) 1,129.00 452.80 40.1%6601720 Salaries1,904.96 2,508.00 (603.04) 17,896.08 22,572.00 (4,675.92) 30,096.00 12,199.92 40.5%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 2,167.52 3,159.00 (991.48) 4,213.00 2,045.48 48.6%Total-MKT-SALARIES & BENEFITS2,443.96 3,294.00 (850.04) 23,815.60 29,646.00 (5,830.40) 39,530.00 15,714.40 39.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 37.57 100.00 (62.43) 659.01 900.00 (240.99) 1,200.00 540.99 45.1%6603768 Supplies-Printing & Stationery 330.28 125.00 205.28 4,949.77 4,050.00 899.77 4,425.00 (524.77) -11.9%367.85 225.00 142.85 5,608.78 4,950.00 658.78 5,625.00 16.22 0.3%66-MKT-UTILITIES6607840 Utilities-Telephone121.00 100.00 21.00 480.48 900.00 (419.52) 1,200.00 719.52 60.0%Total-MKT-UTILITIES121.00 100.00 21.00 480.48 900.00 (419.52) 1,200.00 719.52 60.0%66-MKT-OTHER EXPENSES6609010 Advertising17,988.59 19,680.00 (1,691.41) 147,467.05 147,183.00 284.05 178,987.00 31,519.95 17.6%6609040 Business Meals- - - - - - 300.00 300.00 100.0%6609080 Collateral Material588.99 500.00 88.99 6,596.48 3,000.00 3,596.48 5,500.00 (1,096.48) -19.9%6609102 Contract Services-Web Page99.00 150.00 (51.00) 1,287.00 1,350.00 (63.00) 1,800.00 513.00 28.5%6609490 Miscellaneous- 50.00 (50.00) - 250.00 (250.00) 350.00 350.00 100.0%6609620 Postage158.97 50.00 108.97 158.97 450.00 (291.03) 600.00 441.03 73.5%6609630 Promotion- 25.00 (25.00) - 225.00 (225.00) 700.00 700.00 100.0%6609633 Promotion-Community- 125.00 (125.00) 76.50 2,575.00 (2,498.50) 2,250.00 2,173.50 96.6%6609634 Promotion-Media/Vendor- - - - 2,000.00 (2,000.00) 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- 300.00 (300.00) 110.00 735.00 (625.00) 735.00 625.00 85.0%6609820 Uniforms- 50.00 (50.00) 500.43 550.00 (49.57) 600.00 99.57 16.6%Total-MKT-OTHER EXPENSES18,835.55 20,930.00 (2,094.45) 156,196.43 158,318.00 (2,121.57) 193,822.00 37,625.57 19.4%21,768.36 24,549.00 (2,780.64) 186,101.29 193,814.00 (7,712.71) 240,177.00 54,075.71 22.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementMarch 2016Annual Budget9 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,470.35 1,488.00 982.35 11,332.47 13,392.00 (2,059.53) 17,856.00 6,523.53 36.5%6701325 Insurance-Workers Comp325.53 662.00 (336.47) 5,735.54 5,732.00 3.54 7,717.00 1,981.46 25.7%6701720 Salaries14,821.00 15,050.00 (229.00) 124,854.50 129,450.00 (4,595.50) 177,996.00 53,141.50 29.9%6701800 Taxes-Employer Payroll1,450.02 2,471.00 (1,020.98) 16,949.28 21,399.00 (4,449.72) 28,812.00 11,862.72 41.2%6701880 Wages-Hourly1,986.20 2,600.00 (613.80) 24,523.80 23,398.00 1,125.80 27,800.00 3,276.20 11.8%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS21,053.10 22,271.00 (1,217.90) 183,395.59 193,371.00 (9,975.41) 260,181.00 76,785.41 29.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer85.63 500.00 (414.37) 1,301.72 4,500.00 (3,198.28) 6,300.00 4,998.28 79.3%6703762 Supplies-Office137.87 150.00 (12.13) 1,108.43 1,350.00 (241.57) 1,800.00 691.57 38.4%6703768 Supplies-Printing & Stationery845.49 400.00 445.49 1,933.01 2,100.00 (166.99) 3,300.00 1,366.99 41.4%Total-G&A-SUPPLIES & MATERIALS1,068.99 1,050.00 18.99 4,343.16 7,950.00 (3,606.84) 11,400.00 7,056.84 61.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 100.00 100.00 - 1,300.00 1,600.00 (300.00) 1,900.00 600.00 31.6%Total-G&A-REPAIRS & MAINTENANCE100.00 100.00 - 1,300.00 1,600.00 (300.00) 1,900.00 600.00 31.6%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%6709150 Dues & Subscriptions110.00 50.00 60.00 419.00 1,100.00 (681.00) 1,700.00 1,281.00 75.4%6709180 Employee Recruiting/Relocation235.21 200.00 35.21 1,317.78 1,400.00 (82.22) 1,400.00 82.22 5.9%6709197 Equipment Rental285.79 550.00 (264.21) 5,698.55 4,950.00 748.55 6,600.00 901.45 13.7%6709202 Fees-Bank8.01 90.00 (81.99) 1,002.05 810.00 192.05 1,080.00 77.95 7.2%6709208 Fees-Payroll Processing822.77 1,200.00 (377.23) 10,497.42 10,800.00 (302.58) 14,400.00 3,902.58 27.1%6709220 Freight/Delivery- 50.00 (50.00) 10.68 450.00 (439.32) 600.00 589.32 98.2%6709490 Miscellaneous- 100.00 (100.00) 4,223.20 6,300.00 (2,076.80) 1,200.00 (3,023.20) -251.9%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services111.25 75.00 36.25 887.08 675.00 212.08 900.00 12.92 1.4%6709625 Professional Fees1,353.50 850.00 503.50 7,735.12 7,650.00 85.12 10,200.00 2,464.88 24.2%6709636 Promotion/Entertainment- 100.00 (100.00) - 900.00 (900.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 834.70 1,800.00 (965.30) 2,400.00 1,565.30 65.2%6709810 Travel- - - - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 719.50 825.00 (105.50) 1,050.00 330.50 31.5%Total-G&A-OTHER EXPENSES3,576.53 3,940.00 611.53 36,945.08 41,460.00 (4,514.92) 54,030.00 17,084.92 31.6%25,798.62 27,361.00 (1,562.38) 225,983.83 244,381.00 (18,397.17) 327,511.00 101,527.17 31.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementMarch 2016Annual Budget10 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 93,271.05 90,450.00 2,821.05 121,050.00 27,778.95 22.9%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 50,143.50 54,900.00 (4,756.50) 72,600.00 22,456.50 30.9%6800194 Equipment Leases-Trailer252.61 600.00 (347.39) 4,100.88 5,400.00 (1,299.12) 7,200.00 3,099.12 43.0%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 40,500.00 42,300.00 (1,800.00) 56,400.00 15,900.00 28.2%6800197 Equipment Leases-Others2,150.24 1,150.00 1,000.24 14,959.03 10,350.00 4,609.03 13,800.00 (1,159.03) 0.0%22,837.80 22,550.00 287.80 202,974.46 203,400.00 (425.54) 271,050.00 68,075.54 25.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 74,880.00 74,880.00 - 99,840.00 24,960.00 25.0%6900210 FF&E Reserve10,878.20 11,084.00 (205.80) 47,454.87 47,287.00 167.87 63,985.00 16,530.13 25.8%6900800 Personal Property Taxes- - - 12,117.83 11,800.00 317.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial3,405.25 2,200.00 1,205.25 33,050.75 19,800.00 13,250.75 26,400.00 (6,650.75) -25.2%22,603.45 21,604.00 999.45 167,503.45 153,767.00 13,736.45 202,025.00 34,521.55 17.1%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMarch 2016Annual BudgetMonth to Date Year 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia422SalesPromotion4Golf IndustryVIPCelebrityPGA Comp434244Charity/Gift Certificate426Rain/Wind Checks113Club Staff776683LQ HS Golf2624178159 137 31600012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐2016March 2016 Date Time DescriptionCategoryPlayers3/15/2016 7:00 a.m. Jason Kosky - Locale Magazine Media 213