Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 October 2013 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2013 – October 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 October Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue56,542.47 49,149.00 7,393.47 15.0% 323,206.40 356,202.00 (32,995.60) 3,294,267.00 2,971,060.60 10%401000 Miscellaneous Golf Revenue 11,096.00 13,786.00 (2,690.00) -19.5% 36,055.50 41,236.00 (5,180.50) 302,480.00 266,424.50 12%410000 Revenue-Golf Shop 4,046.26 4,300.00 (253.74) -5.9% 30,878.75 35,011.00 (4,132.25) 279,585.00 248,706.25 11%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income0.84 - 0.84 0.0% 2.37 - 2.37 - (2.37) 0%Total Income73,185.57 68,735.00 4,450.57 6.5% 393,143.02 435,449.00 (42,305.98) 3,888,332.00 3,495,188.98 10%Cost of Goods Sold510000 COS-Golf Shop 2,345.51 2,282.00 63.51 -2.8% 17,260.76 18,581.05 1,320.29 148,390.00 131,129.24 12%Total COS2,345.51 2,282.00 63.51 -2.8% 17,260.76 18,581.05 1,320.29 148,390.00 131,129.24 12%Gross Profit70,840.06 66,453.00 4,387.06 6.6% 375,882.26 416,867.95 (40,985.69) 3,739,942.00 3,364,059.74 10%Expenses610000 Golf Pro Shop 12,998.05 14,346.00 1,347.95 9.4% 58,363.95 65,611.00 7,247.05 219,667.00 161,303.05 27%630000 Course Maintenance286,799.91 264,493.00 (22,306.91) -8.4% 681,795.85 672,874.00 (8,921.85) 1,684,328.00 1,002,532.15 40%633000 Maintenance Water & Energy17,399.16 16,210.00 (1,189.16) -7.3% 81,883.35 81,770.00 (113.35) 223,629.00 141,745.65 37%640000 Outside Services14,651.12 16,451.00 1,799.88 10.9% 61,659.93 63,446.00 1,786.07 281,182.00 219,522.07 22%650000 Clubhouse 13,194.78 11,736.00 (1,458.78) -12.4% 43,873.03 43,644.00 (229.03) 131,732.00 87,858.97 33%660000 Marketing 13,520.27 16,894.00 3,373.73 20.0% 58,035.65 66,191.00 8,155.35 239,552.00 181,516.35 24%670000 General & Administrative21,829.68 26,667.00 4,837.32 18.1% 99,676.32 106,143.00 6,466.68 323,543.00 223,866.68 31%680000 Leases 17,444.16 18,890.00 1,445.84 7.7% 71,528.54 75,560.00 4,031.46 226,680.00 155,151.46 32%690000 Miscellaneous Other Expense14,623.77 20,783.00 6,159.23 29.6% 54,410.00 62,724.00 8,314.00 203,085.00 148,675.00 27%Total Expenses412,460.90 406,470.00 (5,990.90) -1.5% 1,211,226.62 1,237,963.00 26,736.38 3,533,398.00 2,322,171.38 34%(341,620.84) (340,017.00) (1,603.84) -0.5%(835,344.36) (821,095.05) (14,249.31) 206,544.00 1,041,888.36 -404%Rounds of Golf PlayedPaid Rounds Played 891 860 31 3.6% 8,528 8,860 (332) 46,710 38,182 18%Ave $ Per Paid Round Green Fee63.46 57.15 6.31 11.0% 37.90 40.20 (2.30) 70.53 32.63 54%Ave $ Per Paid Round Merchandise4.54 5.00 (0.46) -9.2% 3.62 3.95 (0.33) 5.99 2.36 60%Ave $ Per Paid Miscellaneous 12.45 16.03 (3.58) -22.3% 4.23 4.65 (0.43) 6.48 2.25 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateOctober 20131 ACTUALBUDGETVARIANCERevenue Fees56,542.47$ 49,149.00$ 7,393.47$ Favorable: Due to additional rounds played and outstanding October weather prior to closure for overseeding.Misc Golf Revenue11,096.00$ 13,786.00$ (2,690.00)$ Unfavorable: Resident card revenue was short of budget by $2,760.00 due to timing of overseeding and the closure of the course in October. Outside Services14,651.12$ 16,451.00$ (1,799.88)$ Favorable: Due to reduced payroll; employees were laid off (non-esstenial employees for October 2013).Clubhouse13,194.78$ 11,736.00$ 1,458.78$ Unfavorable: Due to timing of Drum Security invoices for October 2013Marketing13,520.27$ 16,894.00$ (3,373.73)$ Favorable: Due to timing of invoices for scorecards, tees, pencils. General and Administrative21,829.68$ 26,667.00$ (4,837.32)$ Favorable: Due to reduced labor cost, computer supplies, professional fees, and repair and maintenance.Miscellaneous14,623.77$ 20,783.00$ (6,159.23)$ Favorable: Due to property tax bill not received. Variance ExplanationsOctober 20132 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 56,542.47 49,149.00 7,393.47 323,206.40 356,202.00 (32,995.60) 3,294,267.002,971,060.6010%4010000 Rider Fee 200.00 86.00 114.00 1,300.00 886.00 414.00 7,700.006,400.0017%4040000 Club Rental 505.00 430.00 75.00 3,010.00 4,430.00 (1,420.00) 23,355.0020,345.0013%4050000 Driving Range 1,160.00 860.00 300.00 9,933.00 7,660.00 2,273.00 90,325.0080,392.0011%4060000 Handicap Fees - - - - - - 2,500.002,500.000%4080000 GPS Advertising - 100.00 (100.00) 500.00 400.00 100.00 2,600.00 2,100.0019%4090000 Ball Retriever/Subcontract 681.00 1,000.00 (319.00) 2,247.50 2,000.00 247.50 4,000.00 1,752.5056%4091000 Golf Professional Rental Fee - - - - - - 37,000.00 37,000.00 0%4092000 Golf Lessons - - - - - - - - 0%4093000 Resident Card Issue 8,550.00 11,310.00 (2,760.00) 19,065.00 25,860.00 (6,795.00) 135,000.00 115,935.00 14% Total Revenue Fees 67,638.47 62,935.00 4,703.47 359,261.90 397,438.00 (38,176.10) 3,461,747.00 3,121,550.10 10%67,638.47 62,935.00 4,703.47 359,261.90 397,438.00 (38,176.10) 3,461,747.00 3,121,550.10 10%SilverRock ResortStatement of Fees RevenueOctober 2013Total IncomeMonth to Date Year to Date Annual Budget3 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 61.00 - 61.00 551.28 - 551.28 0 0 0%4100110 Sales Hard Goods 2,271.59 1,505.00 766.59 15,971.45 12,254.00 3,717.45 97,855.00 81,883.55 16%4100112 Sales-Soft Goods 2,123.50 2,795.00 (671.50) 19,099.50 22,757.00 (3,657.50) 181,730.00 162,630.50 11%5100639 GS-Discounts-Mdse (409.83) - (409.83) (4,743.48) - (4,743.48) - 4,743.48 0% Total Revenue Golf Shop 4,046.26 4,300.00 (253.74) 30,878.75 35,011.00 (4,132.25) 279,585.00 249,257.53 11%COS 5100150 COS-GS-Hard Goods 1,030.07 827.75 202.32 8,552.66 6,739.70 1,812.96 53,820.25 45,267.59 16%5100151 COS-GS-Soft Goods 1,004.50 1,537.25 (532.75) 8,518.69 12,516.35 (3,997.66) 99,951.50 91,432.81 9%5100152 COS-GS-Purchase Disc (333.60) (118.00) (215.60) (634.48) (963.00) 328.52 (7,689.00) (7,054.52) -8%5100220 COS-GS-Freight Merch 644.54 35.00 609.54 823.89 288.00 535.89 2,307.00 1,483.11 36%Cost of Sales - Golf Shop 2,345.51 2,282.00 63.51 17,260.76 18,581.05 (1,320.29) 148,389.75 131,128.99 12%Gross Profit 1,700.75 2,018.00 (317.25) 13,617.99 16,429.95 (2,811.96) 131,195.25 118,128.54 10%COS % 58.0% 53.1% -4.9% 55.9% 53.1% -2.8% 53.1% 52.6% 1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,467.71 2,317.00 150.71 9,870.84 8,275.00 1,595.84 26,811.00 16,940.16 37%6101325 Insurance-Workers Comp 705.74 341.00 364.74 2,822.96 1,647.00 1,175.96 5,663.00 2,840.04 50%6101720 Salaries 3,545.44 3,750.00 (204.56) 14,334.48 15,000.00 (665.52) 45,000.00 30,665.52 32%6101800 Taxes-Employer Payroll 53.56 956.00 (902.44) 2,665.08 4,620.00 (1,954.92) 1,588.00 (1,077.08) 168%6101880 Wages-Hourly 4,607.46 4,747.00 (139.54) 23,507.94 26,054.00 (2,546.06) 96,229.00 72,721.06 24%6101882 Wages-Overtime - - - 89.26 - 89.26 - 952.88 0%Total -PS-SALARIES & BENEFITS 11,379.91 12,111.00 (731.09) 53,290.56 55,596.00 (2,305.44) 175,291.00 123,042.58 30%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 105.89 500.00 (394.11) 199.76 2,000.00 (1,800.24) 6,000.00 5,800.24 3%6109090 Contract Services 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 33%6109220 Freight & Delivery - 25.00 (25.00) - 25.00 (25.00) 75.00 75.00 0%6109490 Miscellaneous - 500.00 (500.00) 190.00 2,000.00 (1,810.00) 6,000.00 5,810.00 3%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (0.91) - (0.91) 99.38 - 99.38 - (99.38) 0%6109722 Seminars/Training - 500.00 (500.00) 284.88 3,150.00 (2,865.12) 5,890.00 5,605.12 5%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 898.16 100.00 798.16 1,841.41 400.00 1,441.41 2,400.00 558.59 77%6117840 Telephones 115.00 110.00 5.00 457.96 440.00 17.96 1,320.00 862.04 0%Total PS-OTHER EXPENSES 1,618.14 2,235.00 (616.86) 5,073.39 10,015.00 (4,941.61) 30,075.00 25,001.61 17%12,998.05 14,346.00 (1,347.95) 58,363.95 65,611.00 (7,247.05) 205,366.00 148,044.19 28%Net Income(11,297.30) (12,328.00) 1,030.70 (44,745.96) (49,181.05) 4,435.09 (74,170.75) (29,915.65) -60%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementOctober 20134 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 8,871.11 8,740.00 131.11 40,707.15 34,960.00 5,747.15 104,880.00 64,172.85 61.2%6311325 Insurance-Workers Comp 1,237.04 2,489.00 (1,251.96) 8,496.08 9,113.00 (616.92) 27,280.00 18,783.92 68.9%6311720 Salaries 11,179.51 11,001.60 177.91 44,152.31 44,006.40 145.91 150,996.00 106,843.69 70.8%6311800 Taxes-Employer Payroll 5,247.17 7,378.00 (2,130.83) 18,965.82 25,960.00 (6,994.18) 774,129.00 755,163.18 97.6%6311880 Wages-Hourly 46,016.22 44,054.40 1,961.82 179,340.82 176,217.60 3,123.22 518,654.00 339,313.18 65.4%6311882 Wages-Overtime 12,474.78 10,526.00 1,948.78 12,490.91 10,526.00 1,964.91 15,945.00 3,454.09 21.7%Total-CM-SALARIES & BENEFITS85,025.83 84,189.00 836.83 304,153.09 300,783.00 3,370.09 1,591,884.00 1,287,730.91 80.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 4,838.56 - 4,838.56 11,146.21 - 11,146.21 34,600.00 23,453.79 67.8%6313744 Fertilizer 16,869.39 22,100.00 (5,230.61) 52,078.65 67,100.00 (15,021.35) 112,500.00 60,421.35 53.7%6313745 Herbicides - - - 7,502.63 7,000.00 502.63 17,000.00 9,497.37 55.9%6313746 Flowers/Plants 419.04 250.00 169.04 419.04 1,250.00 (830.96) 3,050.00 2,630.96 86.3%6313748 Fuel-Gasoline 5,933.96 8,000.00 (2,066.04) 17,255.39 23,500.00 (6,244.61) 55,020.00 37,764.61 68.6%6313750 Golf Course Accessories 9,959.68 10,000.00 (40.32) 10,843.63 10,900.00 (56.37) 13,000.00 2,156.37 16.6%6313756 POA Control 231.70 - 231.70 445.64 - 445.64 7,000.00 6,554.36 93.6%6313758 Miscellaneous Supp 620.80 500.00 120.80 2,875.33 2,750.00 125.33 4,350.00 1,474.67 0.0%6313762 Supplies-Office - - - - - - - - 0.0%6313774 Sand - 2,000.00 (2,000.00) 20.00 7,780.00 (7,760.00) 13,460.00 13,440.00 99.9%6313776 Seed 111,611.50 88,060.00 23,551.50 112,700.14 89,010.00 23,690.14 106,810.00 (5,890.14) -5.5%6313778 Small Tools & Non-Capital Equip 2,001.16 2,000.00 1.16 4,339.64 4,200.00 139.64 5,000.00 660.36 13.2%6313780 Sod - 250.00 (250.00) 2,616.72 5,750.00 (3,133.28) 10,450.00 7,833.28 75.0%6313782 Topdressing 2,276.93 2,500.00 (223.07) 5,325.78 5,000.00 325.78 10,600.00 5,274.22 49.8%Total-CM-SUPPLIES & MATERIALS154,762.72 135,660.00 19,102.72 227,568.80 224,240.00 3,328.80 392,840.00 165,271.20 42.1%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 11,320.00 10,400.00 920.00 31,200.00 19,880.00 63.7%6315685 CM-R&M-Bldngs & Othr Structures 98.27 500.00 (401.73) 609.85 3,050.00 (2,440.15) 5,550.00 4,940.15 89.0%6315690 CM-R&M-Equipment 11,369.11 11,000.00 369.11 24,313.68 17,500.00 6,813.68 40,000.00 15,686.32 39.2%6315692 CM-R&M-Irrigation System 1,079.47 2,000.00 (920.53) 10,395.92 11,400.00 (1,004.08) 19,050.00 8,654.08 45.4%6315696 CM-R&M-Pumps 1,786.71 1,000.00 786.71 3,162.79 4,000.00 (837.21) 10,500.00 7,337.21 69.9%6315815 CM-R&M-Trees-Pruning Etc 2,800.00 550.00 2,250.00 8,550.00 6,050.00 2,500.00 12,050.00 3,500.00 29.0%Total-CM-REPAIRS & MAINTENANCE 19,963.56 17,650.00 2,313.56 58,352.24 52,400.00 5,952.24 118,350.00 59,997.76 50.7%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 20.76 15.00 5.76 62.98 60.00 2.98 180.00 117.02 0.0%6317840 Telephones 991.85 850.00 141.85 3,526.91 3,400.00 126.91 10,200.00 6,673.09 65.4%Total-CM-UTILITIES 1,012.61 865.00 147.61 3,589.89 3,460.00 129.89 10,380.00 6,790.11 65.4%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%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 1,504.92 524.00 980.92 3,762.30 2,096.00 1,666.30 6,288.00 2,525.70 0.0%6319150 Dues & Subscriptions - - - 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education - 50.00 (50.00) 69.00 200.00 (131.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental 729.52 1,000.00 (270.48) 729.52 1,500.00 (770.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 86.44 100.00 (13.56) 86.44 400.00 (313.56) 1,200.00 1,113.56 92.8%6319718 Safety Equipment & Training 125.06 800.00 (674.94) 1,239.35 1,850.00 (610.65) 3,850.00 2,610.65 67.8%6319822 Uniforms 1,122.39 920.00 202.39 4,106.06 3,680.00 426.06 11,040.00 6,933.94 62.8%Total-CM-OTHER EXPENSES 4,068.33 3,894.00 174.33 14,202.67 14,006.00 196.67 42,048.00 27,845.33 66.2%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2013Annual Budget5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,843.10 2,648.00 (804.90) 7,656.17 10,592.00 (2,935.83) 31,776.00 24,119.83 75.9%6321325 Insurance-Workers Comp 504.10 607.00 (102.90) 2,016.40 2,181.00 (164.60) 6,361.00 4,344.60 68.3%6321800 Taxes-Employer Payroll 847.77 1,829.00 (981.23) 5,103.45 6,285.00 (1,181.55) 18,094.00 12,990.55 71.8%6321880 Wages-Hourly 13,717.75 12,880.00 837.75 52,377.75 51,520.00 857.75 154,560.00 102,182.25 66.1%6321882 Wages-Overtime 3,864.30 3,381.00 483.30 4,955.70 4,347.00 608.70 6,279.00 1,323.30 21.1%Total-CM-LM-SALARIES & BENEFITS20,777.02 21,345.00 (567.98) 72,109.47 74,925.00 (2,815.53) 217,070.00 144,960.53 66.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 92.04 100.00 (7.96) 92.04 400.00 (307.96) 1,025.00 932.96 91.0%6323788 Uniforms 197.80 290.00 (92.20) 827.65 1,160.00 (332.35) 3,480.00 2,652.35 76.2%Total-CM-LM-SUPPLIES & MATERIALS289.84 390.00 (100.16) 919.69 1,560.00 (640.31) 4,505.00 3,585.31 79.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 900.00 500.00 400.00 900.00 1,500.00 (600.00) 4,250.00 3,350.00 78.8%Total-CM-LM-REPAIRS & MAINTENANCE 900.00 500.00 400.00 900.00 1,500.00 (600.00) 4,250.00 3,350.00 78.8%286,799.91 264,493.00 22,306.91 681,795.85 672,874.00 8,921.85 2,381,327.00 1,699,531.15 71.4% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,892.75 12,010.00 882.75 57,829.69 58,210.00 (380.31) 178,291.00 120,461.31 67.6%6337842 Utilities-Water4,506.41 4,200.00 306.41 24,053.66 23,560.00 493.66 45,338.00 21,284.34 46.9%17,399.16 16,210.00 1,189.16 81,883.35 81,770.00 113.35 223,629.00 141,745.65 63.4%Silverrock ResortCourse Maintenance Water & EnergyOctober 2013Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetTotal-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementOctober 2013Annual BudgetMonth to Date Year to Date6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group - 662.00 (662.00) 737.24 2,648.00 (1,910.76) 7,944.00 7,206.76 90.7%6411325 Insurance-Workers Comp 209.84 268.00 (58.16) 2,839.36 1,192.00 1,647.36 5,092.00 2,252.64 44.2%6411800 Taxes-Employer Payroll 424.78 831.00 (406.22) 2,641.05 3,700.00 (1,058.95) 15,809.00 13,167.95 83.3%6411880 Wages-Hourly 4,031.13 6,676.00 (2,644.87) 26,310.83 29,722.00 (3,411.17) 126,982.00 100,671.17 79.3%6411882 Wages-Overtime 213.00 - 213.00 411.00 - 411.00 - (411.00) 0.0%Total-CBR-SALARIES & BENEFITS4,878.75 8,437.00 (3,558.25) 32,939.48 37,262.00 (4,322.52) 155,827.00 122,887.52 78.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 11.08 500.00 (488.92) 1,850.00 1,838.92 99.4%6413742 Supplies-Expendable 2,820.22 150.00 2,670.22 3,888.37 1,500.00 2,388.37 6,750.00 2,861.63 42.4%6413748 Supplies-Fuel for Shuttle 270.00 100.00 170.00 1,200.16 200.00 1,000.16 3,000.00 1,799.84 60.0%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office - 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 160.00 120.00 40.00 1,280.00 480.00 800.00 2,182.00 902.00 41.3%6413796 Supplies-Bottled Water- 50.00 (50.00) 291.53 200.00 91.53 16,500.00 16,208.47 98.2%Total-CBR-SUPPLIES & MATERIALS3,250.22 970.00 2,280.22 6,671.14 3,005.00 3,666.14 40,227.00 33,555.86 83.4%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 132.35 1,200.00 (1,067.65) 3,600.00 3,467.65 96.3%6415695 CBR-R&M-Cart Maintenance & Repair - 950.00 (950.00) 744.39 2,450.00 (1,705.61) 6,450.00 5,705.61 88.5%Total-CBR-REPAIRS & MAINTENANCE - 1,250.00 (1,250.00) 876.74 3,650.00 (2,773.26) 10,050.00 9,173.26 91.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 290.91 800.00 (509.09) 3,354.73 3,200.00 154.73 9,600.00 6,245.27 65.1%6419220 Freight/Delivery - 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 202.79 350.00 (147.21) 1,150.00 947.21 82.4%6419820 Uniforms 1,750.61 2,000.00 (249.39) 2,045.27 2,000.00 45.27 5,200.00 3,154.73 60.7%Total-CBR-OTHER EXPENSES 2,041.52 2,950.00 (908.48) 5,602.79 5,850.00 (247.21) 16,400.00 10,797.21 65.8%TOTAL-CARTS,BAGROOM & RANGE 10,170.49 13,607.00 (3,436.51) 46,090.15 49,767.00 (3,676.85) 222,504.00 176,413.85 79.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 504.10 64.00 440.10 1,717.22 422.00 1,295.22 1,903.00 185.78 9.8%6431800 Taxes-Employer Payroll 168.53 180.00 (11.47) 1,205.21 1,182.00 23.21 5,339.00 4,133.79 77.4%6431880 Wages-Hourly 1,708.00 1,600.00 108.00 10,430.00 10,500.00 (70.00) 47,460.00 37,030.00 78.0%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,380.63 1,844.00 536.63 13,352.43 12,104.00 1,248.43 54,702.00 41,349.57 75.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 25.76 300.00 (274.24) 1,050.00 1,024.24 97.5%6439490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms 2,100.00 800.00 1,300.00 2,191.59 1,025.00 1,166.59 2,125.00 (66.59) -3.1%Total-CS-OTHER EXPENSES 2,100.00 1,000.00 1,100.00 2,217.35 1,575.00 642.35 3,975.00 1,757.65 44.2%Total-COURSE SERVICES 4,480.63 2,844.00 1,636.63 15,569.78 13,679.00 1,890.78 58,677.00 43,107.22 73.5%14,651.12 16,451.00 (1,799.88) 61,659.93 63,446.00 (1,786.07) 281,181.00 217,763.42 77.4%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementOctober 2013Annual Budget7 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas254.02 300.00 (45.98) 969.20 1,200.00 (230.80) 3,600.00 2,630.80 73.1%6507840 Utilities-Telephone1,315.30 1,150.00 165.30 5,817.56 4,600.00 1,217.56 13,800.00 7,982.44 57.8%6507842 Utilities-Water804.72 321.00 483.72 2,953.42 1,284.00 1,669.42 3,852.00 898.58 23.3%6507844 Utilities-Cable554.42 340.00 214.42 1,590.44 1,360.00 230.44 4,080.00 2,489.56 61.0%Total-CH-UTILITIES 2,928.46 2,111.00 817.46 11,330.62 8,444.00 2,886.62 25,332.00 14,001.38 55.3%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 2,425.00 (675.00) 7,225.00 7,900.00 (675.00) 22,500.00 15,275.00 67.9%6509099 Contract Services-Security6,847.56 4,900.00 1,947.56 21,415.75 19,600.00 1,815.75 60,400.00 38,984.25 64.5%6509215 Flowers & Decorations- 500.00 (500.00) - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 92.32 800.00 (707.68) 2,400.00 2,307.68 96.2%6509718 Safety Equipment & Training- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 8,597.56 8,125.00 472.56 28,733.07 29,200.00 (466.93) 88,400.00 59,666.93 67.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures609.16 300.00 309.16 1,739.74 1,200.00 539.74 3,600.00 1,860.26 51.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,010.00 1,600.00 (590.00) 4,800.00 3,790.00 79.0%6515690 CH-R&M-Equipment Repair1,059.60 400.00 659.60 1,059.60 1,600.00 (540.40) 4,800.00 3,740.40 77.9%Total-CH-REPAIRS & MAINTENANCE 1,668.76 1,100.00 568.76 3,809.34 4,400.00 (590.66) 13,200.00 9,390.66 71.1%13,194.78 11,736.00 1,458.78 43,873.03 43,644.00 229.03 131,732.00 18,781.32 14.3%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementOctober 2013Annual Budget8 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 368.62 331.00 37.62 1,474.48 1,324.00 150.48 3,972.00 2,497.52 62.9%6601325 Insurance-Workers Comp 100.82 101.00 (0.18) 403.28 404.00 (0.72) 1,207.00 803.72 66.6%6601720 Salaries 1,894.75 2,508.00 (613.25) 9,008.36 10,032.00 (1,023.64) 30,096.00 21,087.64 70.1%6601800 Taxes-Employer Payroll 153.60 282.00 (128.40) 766.04 1,128.00 (361.96) 3,386.00 2,619.96 77.4%Total-MKT-SALARIES & BENEFITS 2,517.79 3,222.00 (704.21) 11,652.16 12,888.00 (1,235.84) 38,661.00 27,008.84 69.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 49.67 100.00 (50.33) 109.50 400.00 (290.50) 1,200.00 1,090.50 90.9%6603768 Supplies-Printing & Stationery 221.42 3,000.00 (2,778.58) 1,681.11 3,200.00 (1,518.89) 4,425.00 2,743.89 62.0%271.09 3,100.00 (2,828.91) 1,790.61 3,600.00 (1,809.39) 5,625.00 3,834.39 68.2%66-MKT-UTILITIES6607840 Utilities-Telephone 58.12 100.00 (41.88) 229.33 400.00 (170.67) 1,200.00 970.67 80.9%Total-MKT-UTILITIES 58.12 100.00 (41.88) 229.33 400.00 (170.67) 1,200.00 970.67 80.9%66-MKT-OTHER EXPENSES6609010 Advertising 10,434.17 8,822.00 1,612.17 43,106.20 46,753.00 (3,646.80) 179,231.00 136,124.80 75.9%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material - 500.00 (500.00) - 500.00 (500.00) 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page 99.00 150.00 (51.00) 396.00 600.00 (204.00) 1,800.00 1,404.00 78.0%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6609630 Promotion - 25.00 (25.00) - 100.00 (100.00) 2,000.00 2,000.00 0.0%6609633 Promotion-Community - 125.00 (125.00) 662.09 350.00 312.09 2,250.00 1,587.91 70.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) 59.16 500.00 (440.84) 700.00 640.84 91.5%6609150 Dues and Subscriptions - - - - - - 735.00 735.00 100.0%6609820 Uniforms 140.10 300.00 (159.90) 140.10 300.00 (159.90) 600.00 459.90 76.7%Total-MKT-OTHER EXPENSES 10,673.27 10,472.00 201.27 44,363.55 49,303.00 (4,939.45) 194,066.00 149,702.45 77.1%13,520.27 16,894.00 (3,373.73) 58,035.65 66,191.00 (8,155.35) 239,552.00 181,516.35 75.8%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementOctober 2013Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,875.30 1,458.00 417.30 7,501.20 5,832.00 1,669.20 17,496.00 9,994.80 57.1%6701325 Insurance-Workers Comp403.28 708.00 (304.72) 1,512.30 2,832.00 (1,319.70) 8,493.00 6,980.70 82.2%6701720 Salaries 13,769.60 15,050.00 (1,280.40) 59,376.15 60,200.00 (823.85) 183,961.00 124,584.85 67.7%6701800 Taxes-Employer Payroll 1,165.71 1,986.00 (820.29) 5,269.36 7,944.00 (2,674.64) 23,827.00 18,557.64 77.9%6701880 Wages-Hourly1,468.69 2,600.00 (1,131.31) 9,485.56 10,400.00 (914.44) 27,835.00 18,349.44 65.9%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 18,682.58 21,802.00 (3,119.42) 83,144.57 87,208.00 (4,063.43) 261,612.00 178,467.43 68.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer14.31 500.00 (485.69) 652.11 2,000.00 (1,347.89) 6,300.00 5,647.89 89.6%6703762 Supplies-Office 22.56 150.00 (127.44) 416.19 600.00 (183.81) 1,800.00 1,383.81 76.9%6703768 Supplies-Printing & Stationery95.51 100.00 (4.49) 286.51 400.00 (113.49) 3,300.00 3,013.49 91.3%Total-G&A-SUPPLIES & MATERIALS 132.38 750.00 (617.62) 1,354.81 3,000.00 (1,645.19) 11,400.00 10,045.19 88.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 559.75 300.00 259.75 1,900.00 1,340.25 70.5%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 559.75 300.00 259.75 1,900.00 1,340.25 70.5%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) 165.00 300.00 (135.00) 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation90.00 200.00 (110.00) 150.00 400.00 (250.00) 1,400.00 1,250.00 89.3%6709197 Equipment Rental349.81 550.00 (200.19) 2,433.41 2,200.00 233.41 6,600.00 4,166.59 63.1%6709202 Fees-Bank115.55 90.00 25.55 535.93 360.00 175.93 1,080.00 544.07 50.4%6709208 Fees-Payroll Processing1,152.15 1,200.00 (47.85) 5,087.98 4,800.00 287.98 14,400.00 9,312.02 64.7%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services 196.00 75.00 121.00 356.25 300.00 56.25 900.00 543.75 60.4%6709625 Professional Fees461.21 850.00 (388.79) 3,974.82 3,400.00 574.82 10,200.00 6,225.18 61.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 800.00 (550.00) 2,400.00 2,150.00 89.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 150.00 (150.00) 63.80 375.00 (311.20) 1,050.00 986.20 93.9%Total-G&A-OTHER EXPENSES 3,014.72 4,015.00 (1,000.28) 14,617.19 15,635.00 (1,017.81) 48,630.00 34,012.81 69.9%21,829.68 26,667.00 (4,837.32) 99,676.32 106,143.00 (6,466.68) 323,542.00 223,865.68 69.2%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2013Annual Budget10 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 44,366.52 48,300.00 (3,933.48) 144,900.00 100,533.48 69.4%6800194 Equipment Leases-Trailer 252.61 600.00 (347.39) 1,790.44 2,400.00 (609.56) 7,200.00 5,409.56 75.1%6800196 Equipment Leases-GPS 4,720.32 5,755.00 (1,034.68) 20,155.20 23,020.00 (2,864.80) 69,060.00 48,904.80 70.8%6800197 Equipment Leases-Others 1,379.60 460.00 919.60 5,216.38 1,840.00 3,376.38 5,520.00 303.62 0.0%17,444.16 18,890.00 (1,445.84) 71,528.54 75,560.00 (4,031.46) 226,680.00 155,151.46 68.4%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,000.00 8,000.00 - 32,000.00 32,000.00 - 96,000.00 64,000.00 66.7%6900210 FF&E Reserve 1,130.85 983.00 147.85 6,464.15 7,124.00 (659.85) 65,885.00 59,420.85 90.2%6900800 Personal Property Taxes 2,888.09 9,600.00 (6,711.91) 8,285.36 14,800.00 (6,514.64) 14,800.00 6,514.64 44.0%6900323 Insurance-Commercial 2,604.83 2,200.00 404.83 7,660.49 8,800.00 (1,139.51) 26,400.00 18,739.51 71.0%14,623.77 20,783.00 (6,159.23) 54,410.00 62,724.00 (8,314.00) 203,085.00 148,675.00 73.2%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 201311 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2013-20142013 2013 2013 2013 2013 2013Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia46SalesPromotion4Golf Industry4VIPCelebrityPGA Comp61 41 39 6Charity/Gift Certificate13 6 2Rain/Wind Checks6Club Staff90 42 36 16LQ HS Golf8 6 25 25180 105 108 47 0 02014 2014 2014 2014 2014 2014Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013September 2013 Date Time Description CategoryPlayers(None)13