Loading...
06 December 2013 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2013 – December 2013 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 December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue294,645.66 284,456.00 10,189.66 3.6% 949,592.57 940,862.00 8,730.57 3,294,267.00 2,344,674.43 29%401000 Miscellaneous Golf Revenue 44,190.00 38,050.00 6,140.00 16.1% 135,064.25 114,471.00 20,593.25 302,480.00 167,415.75 45%410000 Revenue-Golf Shop 20,377.09 24,375.00 (3,997.91) -16.4% 75,924.40 87,661.00 (11,736.60) 279,585.00 203,660.60 27%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 6,000.00 6,000.00 - 12,000.00 6,000.00 50%890000 Interest Income0.43 - 0.43 0.0% 3.14 - 3.14 - (3.14) 0%Total Income360,713.18 348,381.00 12,332.18 3.5% 1,166,584.36 1,148,994.00 17,590.36 3,888,332.00 2,721,747.64 30%Cost of Goods Sold510000 COS-Golf Shop 11,044.55 12,937.25 (1,892.70) 14.6% 41,687.08 46,524.55 4,837.47 148,390.00 106,702.92 28%Total COS11,044.55 12,937.25 (1,892.70) 14.6% 41,687.08 46,524.55 4,837.47 148,390.00 106,702.92 28%Gross Profit349,668.63 335,443.75 14,224.88 4.2% 1,124,897.28 1,102,469.45 22,427.83 3,739,942.00 2,615,044.72 30%Expenses610000 Golf Pro Shop 12,443.88 18,957.00 6,513.12 34.4% 86,941.44 103,525.00 16,583.56 219,667.00 132,725.56 40%630000 Course Maintenance118,834.87 129,700.00 10,865.13 8.4% 950,920.36 962,115.00 11,194.64 1,684,328.00 733,407.64 56%633000 Maintenance Water & Energy12,158.18 11,415.00 (743.18) -6.5% 105,307.18 107,230.00 1,922.82 223,629.00 118,321.82 47%640000 Outside Services25,251.91 35,288.00 10,036.09 28.4% 112,579.65 130,561.00 17,981.35 281,182.00 168,602.35 40%650000 Clubhouse 12,036.74 10,636.00 (1,400.74) -13.2% 65,183.96 64,916.00 (267.96) 131,732.00 66,548.04 49%660000 Marketing 31,587.82 26,977.00 (4,610.82) -17.1% 114,114.25 118,595.00 4,480.75 239,552.00 125,437.75 48%670000 General & Administrative28,385.41 27,042.00 (1,343.41) -5.0% 152,242.13 160,652.00 8,409.87 323,543.00 171,300.87 47%680000 Leases 16,925.56 18,890.00 1,964.44 10.4% 93,680.05 113,340.00 19,659.95 226,680.00 132,999.95 41%690000 Miscellaneous Other Expense16,973.19 15,889.00 (1,084.19) -6.8% 94,728.95 94,817.00 88.05 203,085.00 108,356.05 47%Total Expenses274,597.56 294,794.00 20,196.44 6.9% 1,775,697.97 1,855,751.00 80,053.03 3,533,398.00 1,757,700.03 50%75,071.07 40,649.75 34,421.32 84.7%(650,800.69) (753,281.55) 102,480.86 206,544.00 857,344.69 -315%Rounds of Golf PlayedPaid Rounds Played 4,348 3,900 448 11.5% 17,384 17,110 274 46,710 29,326 37%Ave $ Per Paid Round Green Fee67.77 72.94 (5.17) -7.1% 54.62 54.99 (0.36) 70.53 15.90 77%Ave $ Per Paid Round Merchandise4.69 6.25 (1.56) -25.0% 4.37 5.12 (0.76) 5.99 1.62 73%Ave $ Per Paid Miscellaneous 10.16 9.76 0.41 4.2% 7.77 6.69 1.08 6.48 (1.29) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateDecember 20131 ACTUALBUDGETVARIANCERevenue Fees294,645.66$ 284,456.00$ 10,189.66$ Favorable: 448 additional rounds played and excellent weather for December contributed to the increasein rounds and revenue for the month of December.Misc Golf Revenue44,190.00$ 38,050.00$ 6,140.00$ Favorable: Due to additional golf schools for Golf Made Simple & increased revenue in driving range. Pro Shop Merchandise Sales20,377.09$ 24,375.00$ (3,997.91)$ Unfavorable: Merchandise sales were down by nearly 16%. Consumer spending in merchandise continues to be lower than budgeted. Golf Pro Shop12,443.88$ 18,957.00$ 6,513.12$ Favorable: Due to reduced salaries and benefits. Two (2) employees were out for medical reasons during the month of December.Outside Services25,251.91$ 35,288.00$ 10,036.09$ Favorable: Due to reduced salaries and benefits, as well as quarterly bottled water reduced cost.Clubhouse12,036.74$ 10,636.00$ (1,400.74)$ Unfavorable: Due to higher hourly rate for holiday season payments to Drum Security and equipment repair for Southern Valley to repair exterior sound system.Marketing31,587.82$ 26,977.00$ (4,610.82)$ Unfavorable: Due to timing of invoices for advertising. YTD advertising is $1,613 under budget.Leases16,925.56$ 18,890.00$ 1,964.44$ Favorable: Reduced monthly GPS cost for golf carts. This is due to the new GPS rental agreement arrangement. Variance ExplanationsDecember 20132 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 294,645.66 284,456.00 10,189.66 949,592.57 940,862.00 8,730.57 3,294,267.002,344,674.4329%4010000 Rider Fee 1,000.00 975.00 25.00 3,375.00 2,296.00 1,079.00 7,700.004,325.0044%4040000 Club Rental 2,250.00 1,950.00 300.00 7,585.00 8,555.00 (970.00) 23,355.0015,770.0032%4050000 Driving Range 10,490.00 7,800.00 2,690.00 32,863.00 23,725.00 9,138.00 90,325.0057,462.0036%4060000 Handicap Fees - - - - - - 2,500.002,500.000%4080000 GPS Advertising - 500.00 (500.00) 500.00 1,400.00 (900.00) 2,600.00 2,100.0019%4090000 Ball Retriever/Subcontract - - - 2,247.50 2,000.00 247.50 4,000.00 1,752.5056%4091000 Golf Professional Rental Fee 9,720.00 5,000.00 4,720.00 15,220.00 10,000.00 5,220.00 37,000.00 21,780.00 41%4092000 Golf Lessons - - - 478.75 - 478.75 - (478.75) 0%4093000 Resident Card Issue 20,730.00 21,825.00 (1,095.00) 72,795.00 66,495.00 6,300.00 135,000.00 62,205.00 54% Total Revenue Fees 338,835.66 322,506.00 16,329.66 1,084,656.82 1,055,333.00 29,323.82 3,461,747.00 2,449,885.18 29%338,835.66 322,506.00 16,329.66 1,084,656.82 1,055,333.00 29,323.82 3,461,747.00 2,449,885.18 29%SilverRock ResortStatement of Fees RevenueDecember 2013Total IncomeMonth to Date Year to Date Annual Budget3 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 495.00 - 495.00 1,410.63 - 1,410.63 0 0 0%4100110 Sales Hard Goods 7,903.55 8,531.00 (627.45) 32,163.31 30,681.00 1,482.31 97,855.00 65,691.69 33%4100112 Sales-Soft Goods 15,099.50 15,844.00 (744.50) 53,780.50 56,980.00 (3,199.50) 181,730.00 127,949.50 30%5100639 GS-Discounts-Mdse (3,120.96) - (3,120.96) (11,430.04) - (11,430.04) - 11,430.04 0% Total Revenue Golf Shop 20,377.09 24,375.00 (3,997.91) 75,924.40 87,661.00 (11,736.60) 279,585.00 205,071.23 27%COS 5100150 COS-GS-Hard Goods 4,707.83 4,692.05 15.78 19,497.37 16,874.55 2,622.82 53,820.25 34,322.88 36%5100151 COS-GS-Soft Goods 6,227.27 8,714.20 (2,486.93) 21,560.39 31,339.00 (9,778.61) 99,951.50 78,391.11 22%5100152 COS-GS-Purchase Disc (303.15) (670.00) 366.85 (980.14) (2,411.00) 1,430.86 (7,689.00) (6,708.86) -13%5100220 COS-GS-Freight Merch 412.60 201.00 211.60 1,609.46 722.00 887.46 2,307.00 697.54 70%Cost of Sales - Golf Shop 11,044.55 12,937.25 (1,892.70) 41,687.08 46,524.55 (4,837.47) 148,389.75 106,702.67 28%Gross Profit 9,332.54 11,437.75 (2,105.21) 34,237.32 41,136.45 (6,899.13) 131,195.25 98,368.56 25%COS % 54.2% 53.1% -1.1% 54.9% 53.1% -1.8% 53.1% 52.0% 2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 1,225.92 2,317.00 (1,091.08) 13,300.85 12,909.00 391.85 26,811.00 13,510.15 50%6101325 Insurance-Workers Comp 501.70 512.00 (10.30) 3,826.36 2,671.00 1,155.36 5,663.00 1,836.64 68%6101720 Salaries 3,545.44 3,750.00 (204.56) 21,425.36 22,500.00 (1,074.64) 45,000.00 23,574.64 48%6101800 Taxes-Employer Payroll 436.47 1,435.00 (998.53) 4,270.98 7,490.00 (3,219.02) 1,588.00 (2,682.98) 269%6101880 Wages-Hourly 6,006.72 9,008.00 (3,001.28) 37,118.43 44,070.00 (6,951.57) 96,229.00 59,110.57 39%6101882 Wages-Overtime - - - 108.76 - 108.76 - 952.88 0%Total -PS-SALARIES & BENEFITS 11,716.25 17,022.00 (5,305.75) 80,050.74 89,640.00 (9,589.26) 175,291.00 96,301.90 45%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 92.08 500.00 (407.92) 525.64 3,000.00 (2,474.36) 6,000.00 5,474.36 9%6109090 Contract Services 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50%6109220 Freight & Delivery 10.58 25.00 (14.42) 10.58 75.00 (64.42) 75.00 64.42 14%6109490 Miscellaneous - 500.00 (500.00) 291.70 3,000.00 (2,708.30) 6,000.00 5,708.30 5%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 9.97 - 9.97 89.38 - 89.38 - (89.38) 0%6109722 Seminars/Training - 100.00 (100.00) 284.88 3,250.00 (2,965.12) 5,890.00 5,605.12 5%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 2,000.56 900.00 1,100.56 2,400.00 399.44 83%6117840 Telephones 115.00 110.00 5.00 687.96 660.00 27.96 1,320.00 632.04 0%Total PS-OTHER EXPENSES 727.63 1,935.00 (1,207.37) 6,890.70 13,885.00 (6,994.30) 30,075.00 23,184.30 23%12,443.88 18,957.00 (6,513.12) 86,941.44 103,525.00 (16,583.56) 205,366.00 119,486.20 42%Net Income(3,111.34) (7,519.25) 4,407.91 (52,704.12) (62,388.55) 9,684.43 (74,170.75) (21,117.64) -72%SilverRock ResortGolf Shop Income StatementDecember 2013Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget4 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 6,539.45 8,740.00 (2,200.55) 56,694.86 52,440.00 4,254.86 104,880.00 48,185.14 45.9%6311325 Insurance-Workers Comp 2,160.40 2,332.00 (171.60) 12,816.88 13,653.00 (836.12) 27,280.00 14,463.12 53.0%6311720 Salaries 10,620.80 11,001.60 (380.80) 66,035.20 66,009.60 25.60 150,996.00 84,960.80 56.3%6311800 Taxes-Employer Payroll 4,430.99 6,544.00 (2,113.01) 27,829.75 38,698.00 (10,868.25) 774,129.00 746,299.25 96.4%6311880 Wages-Hourly 48,814.92 47,165.40 1,649.52 273,987.01 267,437.40 6,549.61 518,654.00 244,666.99 47.2%6311882 Wages-Overtime 7.59 - 7.59 12,643.63 10,526.00 2,117.63 15,945.00 3,301.37 20.7%Total-CM-SALARIES & BENEFITS72,574.15 75,783.00 (3,208.85) 450,007.33 448,764.00 1,243.33 1,591,884.00 1,141,876.67 71.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,417.48 - 3,417.48 14,563.69 - 14,563.69 34,600.00 20,036.31 57.9%6313744 Fertilizer 8,830.37 11,200.00 (2,369.63) 74,159.73 92,700.00 (18,540.27) 112,500.00 38,340.27 34.1%6313745 Herbicides 5,022.00 5,000.00 22.00 19,939.75 17,000.00 2,939.75 17,000.00 (2,939.75) -17.3%6313746 Flowers/Plants - 750.00 (750.00) 419.04 2,000.00 (1,580.96) 3,050.00 2,630.96 86.3%6313748 Fuel-Gasoline 2,700.21 4,200.00 (1,499.79) 24,028.81 33,200.00 (9,171.19) 55,020.00 30,991.19 56.3%6313750 Golf Course Accessories 372.38 1,200.00 (827.62) 11,377.05 12,300.00 (922.95) 13,000.00 1,622.95 12.5%6313756 POA Control 231.34 - 231.34 4,263.44 3,500.00 763.44 7,000.00 2,736.56 39.1%6313758 Miscellaneous Supp 754.99 500.00 254.99 4,715.54 3,750.00 965.54 4,350.00 (365.54) 0.0%6313762 Supplies-Office - - - 151.49 - 151.49 - (151.49) 0.0%6313774 Sand 451.98 800.00 (348.02) 471.98 12,580.00 (12,108.02) 13,460.00 12,988.02 96.5%6313776 Seed - 350.00 (350.00) 132,079.30 104,710.00 27,369.30 106,810.00 (25,269.30) -23.7%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,339.64 4,400.00 (60.36) 5,000.00 660.36 13.2%6313780 Sod - 250.00 (250.00) 2,616.72 9,250.00 (6,633.28) 10,450.00 7,833.28 75.0%6313782 Topdressing - - - 5,325.78 8,000.00 (2,674.22) 10,600.00 5,274.22 49.8%Total-CM-SUPPLIES & MATERIALS21,780.75 24,350.00 (2,569.25) 298,451.96 303,390.00 (4,938.04) 392,840.00 94,388.04 24.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 16,980.00 15,600.00 1,380.00 31,200.00 14,220.00 45.6%6315685 CM-R&M-Bldngs & Othr Structures 348.27 500.00 (151.73) 1,471.39 4,050.00 (2,578.61) 5,550.00 4,078.61 73.5%6315690 CM-R&M-Equipment 3,210.32 3,000.00 210.32 31,540.72 24,500.00 7,040.72 40,000.00 8,459.28 21.1%6315692 CM-R&M-Irrigation System 940.36 550.00 390.36 11,877.42 12,850.00 (972.58) 19,050.00 7,172.58 37.7%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 3,162.79 6,000.00 (2,837.21) 10,500.00 7,337.21 69.9%6315815 CM-R&M-Trees-Pruning Etc - - - 9,045.00 6,050.00 2,995.00 12,050.00 3,005.00 24.9%Total-CM-REPAIRS & MAINTENANCE 7,328.95 7,650.00 (321.05) 74,077.32 69,050.00 5,027.32 118,350.00 44,272.68 37.4%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 23.66 15.00 8.66 106.13 90.00 16.13 180.00 73.87 0.0%6317840 Telephones 389.47 850.00 (460.53) 4,872.31 5,100.00 (227.69) 10,200.00 5,327.69 52.2%Total-CM-UTILITIES 413.13 865.00 (451.87) 4,978.44 5,190.00 (211.56) 10,380.00 5,401.56 52.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.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 Removal 752.46 524.00 228.46 5,424.92 3,144.00 2,280.92 6,288.00 863.08 0.0%6319150 Dues & Subscriptions 210.00 - 210.00 420.00 - 420.00 540.00 120.00 22.2%6319170 Employee Education - 50.00 (50.00) 69.00 300.00 (231.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental - 200.00 (200.00) 729.52 2,300.00 (1,570.48) 3,400.00 2,670.48 78.5%6319206 Licenses & Permits - - - - 280.00 (280.00) 4,180.00 4,180.00 100.0%6319490 Miscellaneous 140.78 100.00 40.78 227.22 600.00 (372.78) 1,200.00 972.78 81.1%6319718 Safety Equipment & Training - 400.00 (400.00) 1,851.74 2,750.00 (898.26) 3,850.00 1,998.26 51.9%6319822 Uniforms 649.27 920.00 (270.73) 5,467.08 5,520.00 (52.92) 11,040.00 5,572.92 50.5%Total-CM-OTHER EXPENSES 2,252.51 2,694.00 (441.49) 19,189.48 19,894.00 (704.52) 42,048.00 22,858.52 54.4%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2013Annual Budget5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,243.05 2,648.00 (1,404.95) 10,742.32 15,888.00 (5,145.68) 31,776.00 21,033.68 66.2%6321325 Insurance-Workers Comp 441.20 516.00 (74.80) 2,898.80 3,239.00 (340.20) 6,361.00 3,462.20 54.4%6321800 Taxes-Employer Payroll 687.34 1,449.00 (761.66) 6,457.18 9,292.00 (2,834.82) 18,094.00 11,636.82 64.3%6321880 Wages-Hourly 11,985.00 12,880.00 (895.00) 77,073.75 77,280.00 (206.25) 154,560.00 77,486.25 50.1%6321882 Wages-Overtime - - - 4,955.70 5,313.00 (357.30) 6,279.00 1,323.30 21.1%Total-CM-LM-SALARIES & BENEFITS14,356.59 17,493.00 (3,136.41) 102,127.75 111,012.00 (8,884.25) 217,070.00 114,942.25 53.0%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 92.04 575.00 (482.96) 1,025.00 932.96 91.0%6323788 Uniforms 128.79 290.00 (161.21) 1,096.04 1,740.00 (643.96) 3,480.00 2,383.96 68.5%Total-CM-LM-SUPPLIES & MATERIALS128.79 365.00 (236.21) 1,188.08 2,315.00 (1,126.92) 4,505.00 3,316.92 73.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) 900.00 2,500.00 (1,600.00) 4,250.00 3,350.00 78.8%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) 900.00 2,500.00 (1,600.00) 4,250.00 3,350.00 78.8%118,834.87 129,700.00 (10,865.13) 950,920.36 962,115.00 (11,194.64) 2,381,327.00 1,430,406.64 60.1% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,245.44 9,090.00 155.44 74,334.48 78,090.00 (3,755.52) 178,291.00 103,956.52 58.3%6337842 Utilities-Water2,912.74 2,325.00 587.74 30,972.70 29,140.00 1,832.70 45,338.00 14,365.30 31.7%12,158.18 11,415.00 743.18 105,307.18 107,230.00 (1,922.82) 223,629.00 118,321.82 52.9%Silverrock ResortCourse Maintenance Water & EnergyDecember 2013Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetTotal-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementDecember 2013Annual BudgetMonth to Date Year to Date6 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group - 662.00 (662.00) 737.24 3,972.00 (3,234.76) 7,944.00 7,206.76 90.7%6411325 Insurance-Workers Comp 307.20 557.00 (249.80) 3,453.76 2,159.00 1,294.76 5,092.00 1,638.24 32.2%6411800 Taxes-Employer Payroll 1,390.36 1,729.00 (338.64) 5,152.05 6,703.00 (1,550.95) 15,809.00 10,656.95 67.4%6411880 Wages-Hourly 10,548.50 13,890.00 (3,341.50) 47,510.96 53,842.00 (6,331.04) 126,982.00 79,471.04 62.6%6411882 Wages-Overtime 102.00 - 102.00 681.00 - 681.00 - (681.00) 0.0%Total-CBR-SALARIES & BENEFITS12,348.06 16,838.00 (4,489.94) 57,535.01 66,676.00 (9,140.99) 155,827.00 98,291.99 63.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 19.31 500.00 (480.69) 889.46 1,500.00 (610.54) 1,850.00 960.54 51.9%6413742 Supplies-Expendable 481.16 150.00 331.16 4,521.51 3,450.00 1,071.51 6,750.00 2,228.49 33.0%6413748 Supplies-Fuel for Shuttle 222.04 400.00 (177.96) 1,467.29 900.00 567.29 3,000.00 1,532.71 51.1%6413752 Supplies-Range Balls - - - 6,750.00 9,000.00 (2,250.00) 9,000.00 2,250.00 25.0%6413762 Supplies-Office - 50.00 (50.00) - 225.00 (225.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 39.83 - 39.83 39.83 - 39.83 420.00 380.17 90.5%6413786 Supplies-Towels 320.00 195.00 125.00 1,680.00 860.00 820.00 2,182.00 502.00 23.0%6413796 Supplies-Bottled Water6,955.20 8,000.00 (1,044.80) 7,398.41 8,250.00 (851.59) 16,500.00 9,101.59 55.2%Total-CBR-SUPPLIES & MATERIALS8,037.54 9,295.00 (1,257.46) 22,746.50 24,185.00 (1,438.50) 40,227.00 17,480.50 43.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 84.00 300.00 (216.00) 216.35 1,800.00 (1,583.65) 3,600.00 3,383.65 94.0%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) 1,067.16 3,450.00 (2,382.84) 6,450.00 5,382.84 83.5%Total-CBR-REPAIRS & MAINTENANCE 84.00 800.00 (716.00) 1,283.51 5,250.00 (3,966.49) 10,050.00 8,766.49 87.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 807.55 800.00 7.55 4,186.95 4,800.00 (613.05) 9,600.00 5,413.05 56.4%6419220 Freight/Delivery - 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous 18.70 75.00 (56.30) 221.49 500.00 (278.51) 1,150.00 928.51 80.7%6419820 Uniforms 213.56 500.00 (286.44) 2,604.27 3,000.00 (395.73) 5,200.00 2,595.73 49.9%Total-CBR-OTHER EXPENSES 1,039.81 1,450.00 (410.19) 7,012.71 8,750.00 (1,737.29) 16,400.00 9,387.29 57.2%TOTAL-CARTS,BAGROOM & RANGE 21,509.41 28,383.00 (6,873.59) 88,577.73 104,861.00 (16,283.27) 222,504.00 133,926.27 60.2%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 104.90 225.00 (120.10) 1,927.02 815.00 1,112.02 1,903.00 (24.02) -1.3%6431800 Taxes-Employer Payroll 347.60 630.00 (282.40) 2,009.77 2,285.00 (275.23) 5,339.00 3,329.23 62.4%6431880 Wages-Hourly 3,290.00 5,600.00 (2,310.00) 17,812.00 20,300.00 (2,488.00) 47,460.00 29,648.00 62.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,742.50 6,455.00 (2,712.50) 21,748.79 23,400.00 (1,651.21) 54,702.00 32,953.21 60.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 25.76 500.00 (474.24) 1,050.00 1,024.24 97.5%6439490 Miscellaneous - 50.00 (50.00) 35.78 150.00 (114.22) 200.00 164.22 82.1%6439718 Safety Equipment & Training - 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6439820 Uniforms - 250.00 (250.00) 2,191.59 1,350.00 841.59 2,125.00 (66.59) -3.1%Total-CS-OTHER EXPENSES - 450.00 (450.00) 2,253.13 2,300.00 (46.87) 3,975.00 1,721.87 43.3%Total-COURSE SERVICES 3,742.50 6,905.00 (3,162.50) 24,001.92 25,700.00 (1,698.08) 58,677.00 34,675.08 59.1%25,251.91 35,288.00 (10,036.09) 112,579.65 130,561.00 (17,981.35) 281,181.00 166,879.48 59.3%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementDecember 2013Annual Budget7 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 2,400.00 (2,400.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 2,400.00 (2,400.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas158.94 300.00 (141.06) 1,391.79 1,800.00 (408.21) 3,600.00 2,208.21 61.3%6507840 Utilities-Telephone1,280.05 1,150.00 130.05 8,415.66 6,900.00 1,515.66 13,800.00 5,384.34 39.0%6507842 Utilities-Water553.48 321.00 232.48 3,929.70 1,926.00 2,003.70 3,852.00 (77.70) -2.0%6507844 Utilities-Cable455.38 340.00 115.38 2,501.20 2,040.00 461.20 4,080.00 1,578.80 38.7%Total-CH-UTILITIES 2,447.85 2,111.00 336.85 16,238.35 12,666.00 3,572.35 25,332.00 9,093.65 35.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,155.00 1,825.00 330.00 11,280.00 11,550.00 (270.00) 22,500.00 11,220.00 49.9%6509099 Contract Services-Security5,206.56 4,900.00 306.56 31,222.35 29,400.00 1,822.35 60,400.00 29,177.65 48.3%6509215 Flowers & Decorations317.50 - 317.50 317.50 500.00 (182.50) 1,900.00 1,582.50 83.3%6509490 Miscellaneous23.74 200.00 (176.26) 125.75 1,200.00 (1,074.25) 2,400.00 2,274.25 94.8%6509718 Safety Equipment & Training- 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 7,702.80 7,025.00 677.80 42,945.60 43,250.00 (304.40) 88,400.00 45,454.40 51.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures541.09 300.00 241.09 2,585.41 1,800.00 785.41 3,600.00 1,014.59 28.2%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,010.00 2,400.00 (1,390.00) 4,800.00 3,790.00 79.0%6515690 CH-R&M-Equipment Repair1,345.00 400.00 945.00 2,404.60 2,400.00 4.60 4,800.00 2,395.40 49.9%Total-CH-REPAIRS & MAINTENANCE 1,886.09 1,100.00 786.09 6,000.01 6,600.00 (599.99) 13,200.00 7,199.99 54.5%12,036.74 10,636.00 1,400.74 65,183.96 64,916.00 267.96 131,732.00 14,399.98 10.9%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementDecember 2013Annual Budget8 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 248.61 331.00 (82.39) 2,091.71 1,986.00 105.71 3,972.00 1,880.29 47.3%6601325 Insurance-Workers Comp 81.40 101.00 (19.60) 566.08 606.00 (39.92) 1,207.00 640.92 53.1%6601720 Salaries 2,085.23 2,508.00 (422.77) 13,096.00 15,048.00 (1,952.00) 30,096.00 17,000.00 56.5%6601800 Taxes-Employer Payroll 167.50 282.00 (114.50) 1,110.88 1,692.00 (581.12) 3,386.00 2,275.12 67.2%Total-MKT-SALARIES & BENEFITS 2,582.74 3,222.00 (639.26) 16,864.67 19,332.00 (2,467.33) 38,661.00 21,796.33 56.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 215.14 600.00 (384.86) 1,200.00 984.86 82.1%6603768 Supplies-Printing & Stationery 280.32 200.00 80.32 2,874.30 3,600.00 (725.70) 4,425.00 1,550.70 35.0%280.32 300.00 (19.68) 3,089.44 4,200.00 (1,110.56) 5,625.00 2,535.56 45.1%66-MKT-UTILITIES6607840 Utilities-Telephone 58.08 100.00 (41.92) 345.49 600.00 (254.51) 1,200.00 854.51 71.2%Total-MKT-UTILITIES 58.08 100.00 (41.92) 345.49 600.00 (254.51) 1,200.00 854.51 71.2%66-MKT-OTHER EXPENSES6609010 Advertising 28,415.24 21,730.00 6,685.24 86,549.42 88,163.00 (1,613.58) 179,231.00 92,681.58 51.7%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material 152.44 - 152.44 5,349.58 1,500.00 3,849.58 5,500.00 150.42 2.7%6609102 Contract Services-Web Page 99.00 150.00 (51.00) 594.00 900.00 (306.00) 1,800.00 1,206.00 67.0%6609490 Miscellaneous - 50.00 (50.00) - 100.00 (100.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6609630 Promotion - 25.00 (25.00) - 150.00 (150.00) 2,000.00 2,000.00 0.0%6609633 Promotion-Community - 800.00 (800.00) 662.09 1,950.00 (1,287.91) 2,250.00 1,587.91 70.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) 59.16 1,000.00 (940.84) 700.00 640.84 91.5%6609150 Dues and Subscriptions - - - - - - 735.00 735.00 100.0%6609820 Uniforms - 50.00 (50.00) 600.40 400.00 200.40 600.00 (0.40) -0.1%Total-MKT-OTHER EXPENSES 28,666.68 23,355.00 5,311.68 93,814.65 94,463.00 (648.35) 194,066.00 100,251.35 51.7%31,587.82 26,977.00 4,610.82 114,114.25 118,595.00 (4,480.75) 239,552.00 125,437.75 52.4%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementDecember 2013Annual Budget9 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group893.56 1,458.00 (564.44) 9,705.88 8,748.00 957.88 17,496.00 7,790.12 44.5%6701325 Insurance-Workers Comp604.20 708.00 (103.80) 2,720.70 4,248.00 (1,527.30) 8,493.00 5,772.30 68.0%6701720 Salaries 13,769.60 15,050.00 (1,280.40) 86,915.35 90,300.00 (3,384.65) 183,961.00 97,045.65 52.8%6701800 Taxes-Employer Payroll 1,245.24 1,986.00 (740.76) 7,757.73 11,916.00 (4,158.27) 23,827.00 16,069.27 67.4%6701880 Wages-Hourly2,508.19 2,600.00 (91.81) 14,474.38 15,600.00 (1,125.62) 27,835.00 13,360.62 48.0%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,020.79 21,802.00 (2,781.21) 121,574.04 130,812.00 (9,237.96) 261,612.00 140,037.96 53.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,449.17 500.00 949.17 2,102.16 3,000.00 (897.84) 6,300.00 4,197.84 66.6%6703762 Supplies-Office 454.94 150.00 304.94 985.60 900.00 85.60 1,800.00 814.40 45.2%6703768 Supplies-Printing & Stationery398.50 400.00 (1.50) 688.97 900.00 (211.03) 3,300.00 2,611.03 79.1%Total-G&A-SUPPLIES & MATERIALS 2,302.61 1,050.00 1,252.61 3,776.73 4,800.00 (1,023.27) 11,400.00 7,623.27 66.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 559.75 1,300.00 (740.25) 1,900.00 1,340.25 70.5%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 559.75 1,300.00 (740.25) 1,900.00 1,340.25 70.5%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%6709150 Dues & Subscriptions- 200.00 (200.00) 165.00 550.00 (385.00) 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation42.00 200.00 (158.00) 504.00 800.00 (296.00) 1,400.00 896.00 64.0%6709197 Equipment Rental505.60 550.00 (44.40) 3,644.62 3,300.00 344.62 6,600.00 2,955.38 44.8%6709202 Fees-Bank115.27 90.00 25.27 765.91 540.00 225.91 1,080.00 314.09 29.1%6709208 Fees-Payroll Processing1,261.96 1,200.00 61.96 7,526.12 7,200.00 326.12 14,400.00 6,873.88 47.7%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous 100.66 100.00 0.66 100.66 600.00 (499.34) 1,200.00 1,099.34 91.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services 98.00 75.00 23.00 565.50 450.00 115.50 900.00 334.50 37.2%6709625 Professional Fees1,261.75 850.00 411.75 6,902.78 5,100.00 1,802.78 10,200.00 3,297.22 32.3%6709636 Promotion/Entertainment2,880.00 100.00 2,780.00 2,880.00 600.00 2,280.00 1,200.00 (1,680.00) -140.0%6709722 Seminars & Training250.00 200.00 50.00 500.00 1,200.00 (700.00) 2,400.00 1,900.00 79.2%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms 146.77 75.00 71.77 377.02 600.00 (222.98) 1,050.00 672.98 64.1%Total-G&A-OTHER EXPENSES 7,062.01 4,090.00 2,972.01 26,331.61 23,740.00 2,591.61 48,630.00 22,298.39 45.9%28,385.41 27,042.00 1,343.41 152,242.13 160,652.00 (8,409.87) 323,542.00 171,299.87 52.9%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2013Annual Budget10 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 10,488.45 12,075.00 (1,586.55) 54,854.97 72,450.00 (17,595.03) 144,900.00 90,045.03 62.1%6800194 Equipment Leases-Trailer 512.61 600.00 (87.39) 3,075.66 3,600.00 (524.34) 7,200.00 4,124.34 57.3%6800196 Equipment Leases-GPS 4,544.80 5,755.00 (1,210.20) 29,640.00 34,530.00 (4,890.00) 69,060.00 39,420.00 57.1%6800197 Equipment Leases-Others 1,379.70 460.00 919.70 6,109.42 2,760.00 3,349.42 5,520.00 (589.42) 0.0%16,925.56 18,890.00 (1,964.44) 93,680.05 113,340.00 (19,659.95) 226,680.00 132,999.95 58.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,000.00 8,000.00 - 48,000.00 48,000.00 - 96,000.00 48,000.00 50.0%6900210 FF&E Reserve 5,892.92 5,689.00 203.92 18,991.88 18,817.00 174.88 65,885.00 46,893.12 71.2%6900800 Personal Property Taxes - - - 8,285.36 14,800.00 (6,514.64) 14,800.00 6,514.64 44.0%6900323 Insurance-Commercial 3,080.27 2,200.00 880.27 19,451.71 13,200.00 6,251.71 26,400.00 6,948.29 26.3%16,973.19 15,889.00 1,084.19 94,728.95 94,817.00 (88.05) 203,085.00 108,356.05 53.4%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 201311 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2013-20142013 2013 2013 2013 2013 2013Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia46 27SalesPromotion4Golf Industry44VIPCelebrityPGA Comp61 41 39 6 20 38Charity/Gift Certificate13 6 2 23 22Rain/Wind Checks642Club Staff90 42 36 16 41 75LQ HS Golf8 6 25 25 11 30180 105 108 47 101 1782014 2014 2014 2014 2014 2014Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013December 2013 Date Time Description CategoryPlayers12/19/2013 9:37 Eric Tracy, Writer Southland Golf Mag Media 312/23/2013 10:30 John White, KESQ Anchor Media 412/26/2013 7:00 Darren Szewaga Golf Ind 413