Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08 February 2014 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2013 – February 2014 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 February Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue485,025.88 503,790.00 (18,764.12) -3.7% 1,826,884.35 1,794,640.00 32,244.35 3,294,267.00 1,467,382.65 55%401000 Miscellaneous Golf Revenue 55,070.75 41,490.00 13,580.75 32.7% 242,206.85 205,876.00 36,330.85 302,480.00 60,273.15 80%410000 Revenue-Golf Shop 30,243.65 39,200.00 (8,956.35) -22.8% 133,482.07 154,986.00 (21,503.93) 279,585.00 146,102.93 48%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 9,000.00 9,000.00 - 12,000.00 3,000.00 75%890000 Interest Income0.20 - 0.20 0.0% 3.68 - 3.68 - (3.68) 0%Total Income571,840.48 585,980.00 (14,139.52) -2.4% 2,211,576.95 2,164,502.00 47,074.95 3,888,332.00 1,676,755.05 57%Cost of Goods Sold510000 COS-Golf Shop 18,577.01 20,805.00 (2,227.99) 10.7% 76,487.78 82,257.30 5,769.52 148,390.00 71,902.22 52%Total COS18,577.01 20,805.00 (2,227.99) 10.7% 76,487.78 82,257.30 5,769.52 148,390.00 71,902.22 52%Gross Profit553,263.47 565,175.00 (11,911.53) -2.1% 2,135,089.17 2,082,244.70 52,844.47 3,739,942.00 1,604,852.83 57%Expenses610000 Golf Pro Shop 16,636.79 18,882.00 2,245.21 11.9% 122,585.27 142,804.00 20,218.73 219,667.00 97,081.73 56%630000 Course Maintenance126,102.49 122,875.00 (3,227.49) -2.6% 1,215,235.23 1,218,278.00 3,042.77 1,684,328.00 469,092.77 72%633000 Maintenance Water & Energy11,834.49 13,709.00 1,874.51 13.7% 130,611.26 134,815.00 4,203.74 223,629.00 93,017.74 58%640000 Outside Services27,185.03 27,252.00 66.97 0.2% 166,567.41 185,115.00 18,547.59 281,182.00 114,614.59 59%650000 Clubhouse 10,943.29 10,636.00 (307.29) -2.9% 88,238.90 88,288.00 49.10 131,732.00 43,493.10 67%660000 Marketing 23,623.47 24,509.00 885.53 3.6% 161,040.29 168,933.00 7,892.71 239,552.00 78,511.71 67%670000 General & Administrative25,973.64 27,342.00 1,368.36 5.0% 204,376.91 214,936.00 10,559.09 323,543.00 119,166.09 63%680000 Leases 16,216.19 18,890.00 2,673.81 14.2% 126,422.58 151,120.00 24,697.42 226,680.00 100,257.42 56%690000 Miscellaneous Other Expense20,780.79 20,276.00 (504.79) -2.5% 134,435.33 132,293.00 (2,142.33) 203,085.00 68,649.67 66%Total Expenses279,296.18 284,371.00 5,074.82 1.8% 2,349,513.18 2,436,582.00 87,068.82 3,533,398.00 1,183,884.82 66%273,967.29 280,804.00 (6,836.71) -2.4%(214,424.01) (354,337.30) 139,913.29 206,544.00 420,968.01 -104%Rounds of Golf PlayedPaid Rounds Played 5,540 5,600 (60) -1.1% 28,067 26,575 1,492 46,710 18,643 60%Ave $ Per Paid Round Green Fee87.55 89.96 (2.41) -2.7% 65.09 67.53 (2.44) 70.53 5.44 92%Ave $ Per Paid Round Merchandise5.46 7.00 (1.54) -22.0% 4.76 5.83 (1.08) 5.99 1.23 79%Ave $ Per Paid Miscellaneous 9.94 7.41 2.53 34.2% 8.63 7.75 0.88 6.48 (2.15) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateFebruary 20141 ACTUALBUDGETVARIANCEMisc Golf Revenue52,326.75$ 41,090.00$ 11,236.75$ Favorable: Due to additional golf schools for Golf Made Simple & increased revenue from the sale of resident cards.Pro Shop Merchandise Sales30,243.65$ 39,200.00$ (8,956.35)$ Unfavorable: Merchandise sales were down by nearly 22%; consumer spending in merchandise continues to be lower than budgeted throughout the year. Pro Shop Cost of Sales18,577.01$ 20,805.00$ (2,227.99)$ 61.42% 53.07% 8.35%Unfavorable COS %: Due to end of season discounts on apparel and hardgoods.Pro Shop 16,636.79$ 18,882.00$ 2,245.21$ Favorable: Due to reduced payroll with low employee turnover and online tee time bookings. Also, officesupplies and miscellaneous line items were not realized this month.Water & Energy11,834.49$ 13,709.00$ 1,874.51$ Favorable: Electricity is down by 30% due to reduced hours of running the water feature. Leases16,216.19$ 18,890.00$ 2,673.81$ Favorable: Reduced monthly cost for renewed GPS and golf cart leases. Variance ExplanationsFebruary 20142 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 485,025.88 503,790.00 (18,764.12) 1,826,884.35 1,794,640.00 32,244.35 3,294,267.001,467,382.6555%4010000 Rider Fee 1,350.00 1,400.00 (50.00) 5,725.00 4,821.00 904.00 7,700.001,975.0074%4040000 Club Rental 2,695.00 2,800.00 (105.00) 12,655.00 13,605.00 (950.00) 23,355.0010,700.0054%4050000 Driving Range 18,790.00 16,800.00 1,990.00 68,383.00 51,775.00 16,608.00 90,325.0021,942.0076%4060000 Handicap Fees 2,744.00 400.00 2,344.00 2,744.00 2,100.00 644.00 2,500.00-244.000%4080000 GPS Advertising - 500.00 (500.00) 500.00 2,400.00 (1,900.00) 2,600.00 2,100.0019%4090000 Ball Retriever/Subcontract - - - 2,985.60 3,000.00 (14.40) 4,000.00 1,014.4075%4091000 Golf Professional Rental Fee 9,518.75 6,000.00 3,518.75 32,822.50 21,000.00 11,822.50 37,000.00 4,177.50 89%4092000 Golf Lessons 158.00 - 158.00 636.75 - 636.75 - (636.75) 0%4093000 Resident Card Issue 19,815.00 13,590.00 6,225.00 115,755.00 107,175.00 8,580.00 135,000.00 19,245.00 86% Total Revenue Fees 540,096.63 545,280.00 (5,183.37) 2,069,091.20 2,000,516.00 68,575.20 3,461,747.00 1,508,410.80 56%540,096.63 545,280.00 (5,183.37) 2,069,091.20 2,000,516.00 68,575.20 3,461,747.00 1,508,410.80 56%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueFebruary 20143 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 345.00 - 345.00 2,045.63 - 2,045.63 0 0 0%4100110 Sales Hard Goods 11,507.20 13,720.00 (2,212.80) 53,613.00 54,245.00 (632.00) 97,855.00 44,242.00 55%4100112 Sales-Soft Goods 22,465.00 25,480.00 (3,015.00) 97,257.00 100,741.00 (3,484.00) 181,730.00 84,473.00 54%5100639 GS-Discounts-Mdse (4,073.55) - (4,073.55) (19,433.56) - (19,433.56) - 19,433.56 0% Total Revenue Golf Shop 30,243.65 39,200.00 (8,956.35) 133,482.07 154,986.00 (21,503.93) 279,585.00 148,148.56 47%COS 5100150 COS-GS-Hard Goods 6,940.77 7,546.00 (605.23) 31,804.12 29,834.75 1,969.37 53,820.25 22,016.13 59%5100151 COS-GS-Soft Goods 10,989.56 14,014.00 (3,024.44) 43,000.23 55,407.55 (12,407.32) 99,951.50 56,951.27 43%5100152 COS-GS-Purchase Disc (157.89) (1,078.00) 920.11 (1,181.07) (4,262.00) 3,080.93 (7,689.00) (6,507.93) -15%5100220 COS-GS-Freight Merch 804.57 323.00 481.57 2,864.50 1,277.00 1,587.50 2,307.00 (557.50) 124%Cost of Sales - Golf Shop 18,577.01 20,805.00 (2,227.99) 76,487.78 82,257.30 (5,769.52) 148,389.75 71,901.97 52%Gross Profit 11,666.64 18,395.00 (6,728.36) 56,994.29 72,728.70 (15,734.41) 131,195.25 76,246.59 42%COS % 61.4% 53.1% -8.4% 57.3% 53.1% -4.2% 53.1% 48.5% 9%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 1,721.22 2,317.00 (595.78) 16,861.58 17,543.00 (681.42) 26,811.00 9,949.42 63%6101325 Insurance-Workers Comp 314.99 512.00 (197.01) 4,847.09 3,695.00 1,152.09 5,663.00 815.91 86%6101720 Salaries 3,545.44 3,750.00 (204.56) 28,516.24 30,000.00 (1,483.76) 45,000.00 16,483.76 63%6101800 Taxes-Employer Payroll 1,704.75 1,435.00 269.75 8,877.10 10,360.00 (1,482.90) 1,588.00 (7,289.10) 559%6101880 Wages-Hourly 8,565.02 9,008.00 (442.98) 53,619.85 62,086.00 (8,466.15) 96,229.00 42,609.15 56%6101882 Wages-Overtime 189.76 - 189.76 307.52 - 307.52 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,041.18 17,022.00 (980.82) 113,029.38 123,684.00 (10,654.62) 175,291.00 63,522.02 64%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office - 500.00 (500.00) 692.43 4,000.00 (3,307.57) 6,000.00 5,307.57 12%6109090 Contract Services 500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 67%6109220 Freight & Delivery - - - 118.88 75.00 43.88 75.00 (43.88) 159%6109490 Miscellaneous - 500.00 (500.00) 1,342.04 4,000.00 (2,657.96) 6,000.00 4,657.96 22%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (21.68) - (21.68) 29.58 - 29.58 - (29.58) 0%6109722 Seminars/Training - 35.00 (35.00) 284.88 4,535.00 (4,250.12) 5,890.00 5,605.12 5%6109810 Travel - Merchandise - 15.00 (15.00) - 30.00 (30.00) 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 2,152.56 1,600.00 552.56 2,400.00 247.44 90%6117840 Telephones 117.29 110.00 7.29 935.52 880.00 55.52 1,320.00 384.48 0%Total PS-OTHER EXPENSES 595.61 1,860.00 (1,264.39) 9,555.89 19,120.00 (9,564.11) 30,075.00 20,519.11 32%16,636.79 18,882.00 (2,245.21) 122,585.27 142,804.00 (20,218.73) 205,366.00 84,041.13 59%Net Income(4,970.15) (487.00) (4,483.15) (65,590.98) (70,075.30) 4,484.32 (74,170.75) (7,794.54) -89%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementFebruary 20144 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,623.88 8,740.00 883.88 76,034.72 69,920.00 6,114.72 104,880.00 28,845.28 27.5%6311325 Insurance-Workers Comp 2,742.65 2,208.00 534.65 17,679.21 18,371.00 (691.79) 27,280.00 9,600.79 35.2%6311720 Salaries 10,620.80 11,001.60 (380.80) 87,276.80 88,012.80 (736.00) 150,996.00 63,719.20 42.2%6311800 Taxes-Employer Payroll 6,632.35 6,194.00 438.35 45,449.94 52,030.00 (6,580.06) 774,129.00 728,679.06 94.1%6311880 Wages-Hourly 45,008.69 44,054.40 954.29 368,796.61 361,393.20 7,403.41 518,654.00 149,857.39 28.9%6311882 Wages-Overtime - - - 15,043.63 13,076.00 1,967.63 15,945.00 901.37 5.7%Total-CM-SALARIES & BENEFITS74,628.37 72,198.00 2,430.37 610,280.91 602,803.00 7,477.91 1,591,884.00 981,603.09 61.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,450.39 - 2,450.39 19,114.87 - 19,114.87 34,600.00 15,485.13 44.8%6313744 Fertilizer 10,135.89 15,500.00 (5,364.11) 93,638.19 119,700.00 (26,061.81) 112,500.00 18,861.81 16.8%6313745 Herbicides - - - 19,939.75 17,000.00 2,939.75 17,000.00 (2,939.75) -17.3%6313746 Flowers/Plants - 100.00 (100.00) 419.04 2,850.00 (2,430.96) 3,050.00 2,630.96 86.3%6313748 Fuel-Gasoline 3,054.74 3,820.00 (765.26) 30,078.30 40,870.00 (10,791.70) 55,020.00 24,941.70 45.3%6313750 Golf Course Accessories 141.23 100.00 41.23 12,382.33 12,600.00 (217.67) 13,000.00 617.67 4.8%6313756 POA Control 242.03 - 242.03 8,091.93 7,000.00 1,091.93 7,000.00 (1,091.93) -15.6%6313758 Miscellaneous Supp 963.08 100.00 863.08 6,470.41 3,950.00 2,520.41 4,350.00 (2,120.41) 0.0%6313762 Supplies-Office - - - 151.49 - 151.49 - (151.49) 0.0%6313774 Sand 2,185.00 100.00 2,085.00 3,136.69 13,060.00 (9,923.31) 13,460.00 10,323.31 76.7%6313776 Seed 631.80 350.00 281.80 133,342.90 105,410.00 27,932.90 106,810.00 (26,532.90) -24.8%6313778 Small Tools & Non-Capital Equip 86.43 100.00 (13.57) 4,426.07 4,600.00 (173.93) 5,000.00 573.93 11.5%6313780 Sod - - - 2,616.72 9,750.00 (7,133.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 & MATERIALS19,890.59 20,170.00 (279.41) 339,134.47 344,790.00 (5,655.53) 392,840.00 53,705.53 13.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 22,640.00 20,800.00 1,840.00 31,200.00 8,560.00 27.4%6315685 CM-R&M-Bldngs & Othr Structures 196.54 250.00 (53.46) 2,183.60 4,550.00 (2,366.40) 5,550.00 3,366.40 60.7%6315690 CM-R&M-Equipment 2,986.18 3,000.00 (13.82) 38,480.84 31,000.00 7,480.84 40,000.00 1,519.16 3.8%6315692 CM-R&M-Irrigation System 1,325.53 1,000.00 325.53 14,146.76 15,050.00 (903.24) 19,050.00 4,903.24 25.7%6315696 CM-R&M-Pumps 749.36 1,000.00 (250.64) 4,313.91 8,000.00 (3,686.09) 10,500.00 6,186.09 58.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 8,087.61 7,850.00 237.61 90,810.11 85,450.00 5,360.11 118,350.00 27,539.89 23.3%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 28.80 15.00 13.80 159.53 120.00 39.53 180.00 20.47 0.0%6317840 Telephones 1,016.50 850.00 166.50 7,549.23 6,800.00 749.23 10,200.00 2,650.77 26.0%Total-CM-UTILITIES 1,045.30 865.00 180.30 7,708.76 6,920.00 788.76 10,380.00 2,671.24 25.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 33.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 Removal 752.46 524.00 228.46 6,929.84 4,192.00 2,737.84 6,288.00 (641.84) 0.0%6319150 Dues & Subscriptions 135.00 240.00 (105.00) 1,000.00 240.00 760.00 540.00 (460.00) -85.2%6319170 Employee Education - 1,000.00 (1,000.00) 69.00 1,350.00 (1,281.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental - 200.00 (200.00) 729.52 2,700.00 (1,970.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 - 100.00 (100.00) 227.22 800.00 (572.78) 1,200.00 972.78 81.1%6319718 Safety Equipment & Training 1,175.00 200.00 975.00 3,428.32 3,350.00 78.32 3,850.00 421.68 11.0%6319822 Uniforms 2,131.73 920.00 1,211.73 9,031.47 7,360.00 1,671.47 11,040.00 2,008.53 18.2%Total-CM-OTHER EXPENSES 4,694.19 3,684.00 1,010.19 27,415.37 26,272.00 1,143.37 42,048.00 14,632.63 34.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementFebruary 2014Annual Budget5 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,868.05 2,648.00 (779.95) 14,478.42 21,184.00 (6,705.58) 31,776.00 17,297.58 54.4%6321325 Insurance-Workers Comp 402.41 516.00 (113.59) 3,805.31 4,271.00 (465.69) 6,361.00 2,555.69 40.2%6321800 Taxes-Employer Payroll 2,192.19 1,449.00 743.19 11,095.02 12,190.00 (1,094.98) 18,094.00 6,998.98 38.7%6321880 Wages-Hourly 12,850.50 12,880.00 (29.50) 102,544.50 103,040.00 (495.50) 154,560.00 52,015.50 33.7%6321882 Wages-Overtime 11.25 - 11.25 4,966.95 5,313.00 (346.05) 6,279.00 1,312.05 20.9%Total-CM-LM-SALARIES & BENEFITS17,324.40 17,493.00 (168.60) 136,890.20 145,998.00 (9,107.80) 217,070.00 80,179.80 36.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 92.04 725.00 (632.96) 1,025.00 932.96 91.0%6323788 Uniforms 432.03 290.00 142.03 2,003.37 2,320.00 (316.63) 3,480.00 1,476.63 42.4%Total-CM-LM-SUPPLIES & MATERIALS432.03 365.00 67.03 2,095.41 3,045.00 (949.59) 4,505.00 2,409.59 53.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 900.00 3,000.00 (2,100.00) 4,250.00 3,350.00 78.8%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 900.00 3,000.00 (2,100.00) 4,250.00 3,350.00 78.8%126,102.49 122,875.00 3,227.49 1,215,235.23 1,218,278.00 (3,042.77) 2,381,327.00 1,166,091.77 49.0% February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 11,105.71 12,236.00 (1,130.29) 96,484.90 102,342.00 (5,857.10) 178,291.00 81,806.10 45.9%6337842 Utilities-Water728.78 1,473.00 (744.22) 34,126.36 32,473.00 1,653.36 45,338.00 11,211.64 24.7%11,834.49 13,709.00 (1,874.51) 130,611.26 134,815.00 (4,203.74) 223,629.00 93,017.74 41.6%February 2014Annual BudgetMonth to Date Year to DateTotal-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementSilverrock ResortCourse Maintenance Water & EnergyFebruary 2014Total-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget6 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group - 662.00 (662.00) 737.24 5,296.00 (4,558.76) 7,944.00 7,206.76 90.7%6411325 Insurance-Workers Comp 420.60 550.00 (129.40) 4,984.20 3,259.00 1,725.20 5,092.00 107.80 2.1%6411800 Taxes-Employer Payroll 1,887.15 1,707.00 180.15 9,536.03 10,117.00 (580.97) 15,809.00 6,272.97 39.7%6411880 Wages-Hourly 12,531.26 13,710.00 (1,178.74) 72,229.73 81,262.00 (9,032.27) 126,982.00 54,752.27 43.1%6411882 Wages-Overtime 72.94 - 72.94 950.07 - 950.07 - (950.07) 0.0%Total-CBR-SALARIES & BENEFITS14,911.95 16,629.00 (1,717.05) 88,437.27 99,934.00 (11,496.73) 155,827.00 67,389.73 43.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 75.00 (75.00) 889.46 1,650.00 (760.54) 1,850.00 960.54 51.9%6413742 Supplies-Expendable 1,386.25 1,000.00 386.25 6,502.82 5,450.00 1,052.82 6,750.00 247.18 3.7%6413748 Supplies-Fuel for Shuttle 234.00 450.00 (216.00) 1,897.21 1,800.00 97.21 3,000.00 1,102.79 36.8%6413752 Supplies-Range Balls 2,420.00 - 2,420.00 9,170.00 9,000.00 170.00 9,000.00 (170.00) -1.9%6413762 Supplies-Office - 50.00 (50.00) - 325.00 (325.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 39.83 140.00 (100.17) 420.00 380.17 90.5%6413786 Supplies-Towels 320.00 250.00 70.00 2,400.00 1,360.00 1,040.00 2,182.00 (218.00) -10.0%6413796 Supplies-Bottled Water540.00 50.00 490.00 8,083.47 8,350.00 (266.53) 16,500.00 8,416.53 51.0%Total-CBR-SUPPLIES & MATERIALS4,900.25 1,945.00 2,955.25 28,982.79 28,075.00 907.79 40,227.00 11,244.21 28.0%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 1,030.60 2,400.00 (1,369.40) 3,600.00 2,569.40 71.4%6415695 CBR-R&M-Cart Maintenance & Repair 120.56 500.00 (379.44) 1,885.88 4,450.00 (2,564.12) 6,450.00 4,564.12 70.8%Total-CBR-REPAIRS & MAINTENANCE 120.56 800.00 (679.44) 2,916.48 6,850.00 (3,933.52) 10,050.00 7,133.52 71.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 810.48 800.00 10.48 5,973.62 6,400.00 (426.38) 9,600.00 3,626.38 37.8%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous 21.59 75.00 (53.41) 267.91 650.00 (382.09) 1,150.00 882.09 76.7%6419820 Uniforms - - - 2,780.47 3,000.00 (219.53) 5,200.00 2,419.53 46.5%Total-CBR-OTHER EXPENSES 832.07 875.00 (42.93) 9,022.00 10,500.00 (1,478.00) 16,400.00 7,378.00 45.0%TOTAL-CARTS,BAGROOM & RANGE 20,764.83 20,249.00 515.83 129,358.54 145,359.00 (16,000.46) 222,504.00 93,145.46 41.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp - 236.00 (236.00) 2,331.12 1,287.00 1,044.12 1,903.00 (428.12) -22.5%6431800 Taxes-Employer Payroll 756.82 662.00 94.82 3,760.59 3,609.00 151.59 5,339.00 1,578.41 29.6%6431880 Wages-Hourly 5,663.38 5,880.00 (216.62) 28,511.38 32,060.00 (3,548.62) 47,460.00 18,948.62 39.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,420.20 6,778.00 (357.80) 34,603.09 36,956.00 (2,352.91) 54,702.00 20,098.91 36.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 145.86 700.00 (554.14) 1,050.00 904.14 86.1%6439490 Miscellaneous - - - 268.33 200.00 68.33 200.00 (68.33) -34.2%6439718 Safety Equipment & Training - 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 2,191.59 1,500.00 691.59 2,125.00 (66.59) -3.1%Total-CS-OTHER EXPENSES - 225.00 (225.00) 2,605.78 2,800.00 (194.22) 3,975.00 1,369.22 34.4%Total-COURSE SERVICES 6,420.20 7,003.00 (582.80) 37,208.87 39,756.00 (2,547.13) 58,677.00 21,468.13 36.6%27,185.03 27,252.00 (66.97) 166,567.41 185,115.00 (18,547.59) 281,181.00 113,244.37 40.3%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementFebruary 2014Annual Budget7 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 3,200.00 (3,200.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 3,200.00 (3,200.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas763.33 300.00 463.33 2,766.02 2,400.00 366.02 3,600.00 833.98 23.2%6507840 Utilities-Telephone1,314.66 1,150.00 164.66 11,139.99 9,200.00 1,939.99 13,800.00 2,660.01 19.3%6507842 Utilities-Water804.72 321.00 483.72 5,702.15 2,568.00 3,134.15 3,852.00 (1,850.15) -48.0%6507844 Utilities-Cable455.38 340.00 115.38 3,411.96 2,720.00 691.96 4,080.00 668.04 16.4%Total-CH-UTILITIES 3,338.09 2,111.00 1,227.09 23,020.12 16,888.00 6,132.12 25,332.00 2,311.88 9.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 14,930.00 15,200.00 (270.00) 22,500.00 7,570.00 33.6%6509099 Contract Services-Security4,562.57 4,900.00 (337.43) 42,109.14 40,800.00 1,309.14 60,400.00 18,290.86 30.3%6509215 Flowers & Decorations- - - 317.50 1,000.00 (682.50) 1,900.00 1,582.50 83.3%6509490 Miscellaneous621.96 200.00 421.96 778.44 1,600.00 (821.56) 2,400.00 1,621.56 67.6%6509718 Safety Equipment & Training- 100.00 (100.00) 386.04 800.00 (413.96) 1,200.00 813.96 67.8%Total-CH-OTHER EXPENSES 7,084.53 7,025.00 59.53 58,521.12 59,400.00 (878.88) 88,400.00 29,878.88 33.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures520.67 300.00 220.67 3,283.06 2,400.00 883.06 3,600.00 316.94 8.8%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,010.00 3,200.00 (2,190.00) 4,800.00 3,790.00 79.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,404.60 3,200.00 (795.40) 4,800.00 2,395.40 49.9%Total-CH-REPAIRS & MAINTENANCE 520.67 1,100.00 (579.33) 6,697.66 8,800.00 (2,102.34) 13,200.00 6,502.34 49.3%10,943.29 10,636.00 307.29 88,238.90 88,288.00 (49.10) 131,732.00 13,004.68 9.9%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementFebruary 2014Annual Budget8 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 373.61 331.00 42.61 2,838.93 2,648.00 190.93 3,972.00 1,133.07 28.5%6601325 Insurance-Workers Comp 101.49 101.00 0.49 766.39 808.00 (41.61) 1,207.00 440.61 36.5%6601720 Salaries 2,053.76 2,508.00 (454.24) 17,397.30 20,064.00 (2,666.70) 30,096.00 12,698.70 42.2%6601800 Taxes-Employer Payroll 456.56 282.00 174.56 2,188.30 2,256.00 (67.70) 3,386.00 1,197.70 35.4%Total-MKT-SALARIES & BENEFITS 2,985.42 3,222.00 (236.58) 23,190.92 25,776.00 (2,585.08) 38,661.00 15,470.08 40.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 534.73 100.00 434.73 749.87 800.00 (50.13) 1,200.00 450.13 37.5%6603768 Supplies-Printing & Stationery 2,048.12 125.00 1,923.12 5,319.63 3,925.00 1,394.63 4,425.00 (894.63) -20.2%2,582.85 225.00 2,357.85 6,069.50 4,725.00 1,344.50 5,625.00 (444.50) -7.9%66-MKT-UTILITIES6607840 Utilities-Telephone 58.08 100.00 (41.92) 461.65 800.00 (338.35) 1,200.00 738.35 61.5%Total-MKT-UTILITIES 58.08 100.00 (41.92) 461.65 800.00 (338.35) 1,200.00 738.35 61.5%66-MKT-OTHER EXPENSES6609010 Advertising 15,536.90 19,112.00 (3,575.10) 120,790.42 127,747.00 (6,956.58) 179,231.00 58,440.58 32.6%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material 1,094.43 500.00 594.43 6,633.62 2,500.00 4,133.62 5,500.00 (1,133.62) -20.6%6609102 Contract Services-Web Page - 150.00 (150.00) 693.00 1,200.00 (507.00) 1,800.00 1,107.00 61.5%6609490 Miscellaneous - 50.00 (50.00) - 200.00 (200.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6609630 Promotion - 25.00 (25.00) - 200.00 (200.00) 2,000.00 2,000.00 0.0%6609633 Promotion-Community 1,066.00 125.00 941.00 1,728.09 2,450.00 (721.91) 2,250.00 521.91 23.2%6609634 Promotion-Media/Vendor 299.79 500.00 (200.21) 538.95 2,000.00 (1,461.05) 700.00 161.05 23.0%6609150 Dues and Subscriptions - 400.00 (400.00) - 435.00 (435.00) 735.00 735.00 100.0%6609820 Uniforms - 50.00 (50.00) 934.14 500.00 434.14 600.00 (334.14) -55.7%Total-MKT-OTHER EXPENSES 17,997.12 20,962.00 (2,964.88) 131,318.22 137,632.00 (6,313.78) 194,066.00 62,747.78 32.3%23,623.47 24,509.00 (885.53) 161,040.29 168,933.00 (7,892.71) 239,552.00 78,511.71 32.8%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementFebruary 2014Annual Budget9 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,332.83 1,458.00 (125.17) 12,560.79 11,664.00 896.79 17,496.00 4,935.21 28.2%6701325 Insurance-Workers Comp707.13 708.00 (0.87) 3,732.11 5,664.00 (1,931.89) 8,493.00 4,760.89 56.1%6701720 Salaries 14,711.20 15,050.00 (338.80) 115,396.15 120,400.00 (5,003.85) 183,961.00 68,564.85 37.3%6701800 Taxes-Employer Payroll 1,817.23 1,986.00 (168.77) 12,771.70 15,888.00 (3,116.30) 23,827.00 11,055.30 46.4%6701880 Wages-Hourly2,548.38 2,600.00 (51.62) 19,503.39 20,800.00 (1,296.61) 27,835.00 8,331.61 29.9%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 21,116.77 21,802.00 (685.23) 163,964.14 174,416.00 (10,451.86) 261,612.00 97,647.86 37.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer270.00 500.00 (230.00) 2,372.16 4,000.00 (1,627.84) 6,300.00 3,927.84 62.3%6703762 Supplies-Office 43.68 150.00 (106.32) 1,029.28 1,200.00 (170.72) 1,800.00 770.72 42.8%6703768 Supplies-Printing & Stationery224.44 400.00 (175.56) 945.81 1,700.00 (754.19) 3,300.00 2,354.19 71.3%Total-G&A-SUPPLIES & MATERIALS 538.12 1,050.00 (511.88) 4,347.25 6,900.00 (2,552.75) 11,400.00 7,052.75 61.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 559.75 1,500.00 (940.25) 1,900.00 1,340.25 70.5%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 559.75 1,500.00 (940.25) 1,900.00 1,340.25 70.5%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%6709150 Dues & Subscriptions297.00 400.00 (103.00) 462.00 1,050.00 (588.00) 1,700.00 1,238.00 72.8%6709180 Employee Recruiting/Relocation30.00 200.00 (170.00) 827.84 1,200.00 (372.16) 1,400.00 572.16 40.9%6709197 Equipment Rental541.57 550.00 (8.43) 4,813.45 4,400.00 413.45 6,600.00 1,786.55 27.1%6709202 Fees-Bank133.30 90.00 43.30 1,194.85 720.00 474.85 1,080.00 (114.85) -10.6%6709208 Fees-Payroll Processing1,227.50 1,200.00 27.50 10,714.43 9,600.00 1,114.43 14,400.00 3,685.57 25.6%6709220 Freight/Delivery- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 100.66 800.00 (699.34) 1,200.00 1,099.34 91.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services 160.25 75.00 85.25 823.75 600.00 223.75 900.00 76.25 8.5%6709625 Professional Fees1,085.45 850.00 235.45 8,903.48 6,800.00 2,103.48 10,200.00 1,296.52 12.7%6709636 Promotion/Entertainment- 100.00 (100.00) 2,880.00 800.00 2,080.00 1,200.00 (1,680.00) -140.0%6709722 Seminars & Training250.00 200.00 50.00 967.61 1,600.00 (632.39) 2,400.00 1,432.39 59.7%6709810 Travel - 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms 193.68 75.00 118.68 617.70 750.00 (132.30) 1,050.00 432.30 41.2%Total-G&A-OTHER EXPENSES 4,318.75 4,390.00 (71.25) 35,505.77 32,120.00 3,385.77 48,630.00 13,124.23 27.0%25,973.64 27,342.00 (1,368.36) 204,376.91 214,936.00 (10,559.09) 323,542.00 119,165.09 36.8%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementFebruary 2014Annual Budget10 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 9,510.27 12,075.00 (2,564.73) 74,853.69 96,600.00 (21,746.31) 144,900.00 70,046.31 48.3%6800194 Equipment Leases-Trailer 765.22 600.00 165.22 4,093.49 4,800.00 (706.51) 7,200.00 3,106.51 43.1%6800196 Equipment Leases-GPS 4,544.80 5,755.00 (1,210.20) 38,729.60 46,040.00 (7,310.40) 69,060.00 30,330.40 43.9%6800197 Equipment Leases-Others 1,395.90 460.00 935.90 8,745.80 3,680.00 5,065.80 5,520.00 (3,225.80) 0.0%16,216.19 18,890.00 (2,673.81) 126,422.58 151,120.00 (24,697.42) 226,680.00 100,257.42 44.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,000.00 8,000.00 - 64,000.00 64,000.00 - 96,000.00 32,000.00 33.3%6900210 FF&E Reserve 9,700.52 10,076.00 (375.48) 36,537.72 35,893.00 644.72 65,885.00 29,347.28 44.5%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 25,612.25 17,600.00 8,012.25 26,400.00 787.75 3.0%20,780.79 20,276.00 504.79 134,435.33 132,293.00 2,142.33 203,085.00 68,649.67 33.8%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementFebruary 2014Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES11 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia2Sales2Promotion16Golf Industry3VIPCelebrityPGA Comp26Charity/Gift CertificateRain/Wind Checks1Club Staff75LQ HS Golf91340000012