Loading...
06 December 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2012 – December 2012 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Golf Shop Income Statement 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 11 Complimentary Report 12 Annual BudgetAccount Description December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue279,251.66 284,456.00 (5,204.34) -1.8% 923,279.89 989,072.00 (65,792.11) 3,350,773.00 2,427,493.11 28%401000 Miscellaneous Golf Revenue 39,194.65 15,055.00 24,139.65 160.3% 93,296.55 52,946.65 40,349.90 159,973.00 66,676.45 58%410000 Revenue-Golf Shop 23,274.95 26,325.00 (3,050.05) -11.6% 84,084.45 93,812.00 (9,727.55) 311,048.00 226,963.55 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.65 - 0.65 0.0% 4.33 - 4.33 - (4.33) 0%Total Income343,221.91 327,336.00 15,885.91 4.9% 1,106,665.22 1,141,830.65 (35,165.43) 3,833,794.00 2,727,128.78 29%Cost of Goods Sold510000 COS-Golf Shop 13,943.43 13,971.75 (28.32) 0.2% 45,943.33 49,790.60 3,847.27 165,088.40 119,145.07 28%Total COS13,943.43 13,971.75 (28.32) 0.2% 45,943.33 49,790.60 3,847.27 165,088.40 119,145.07 28%Gross Profit329,278.48 313,364.25 15,914.23 5.1% 1,060,721.89 1,092,040.05 (31,318.16) 3,668,705.60 2,607,983.71 29%Expenses610000 Golf Pro Shop 15,872.65 18,405.00 2,532.35 13.8% 97,723.32 100,142.00 2,418.68 212,986.00 115,262.68 46%630000 Course Maintenance119,433.81 128,131.00 8,697.19 6.8% 933,727.07 950,599.00 16,871.93 1,664,207.00 730,479.93 56%633000 Maintenance Water & Energy11,712.10 15,415.00 3,702.90 24.0% 111,696.13 104,350.00 (7,346.13) 221,749.00 110,052.87 50%640000 Outside Services22,864.43 27,420.00 4,555.57 16.6% 128,226.24 137,655.00 9,428.76 292,671.00 164,444.76 44%650000 Clubhouse 9,859.03 10,636.00 776.97 7.3% 62,327.93 64,916.00 2,588.07 132,232.00 69,904.07 47%660000 Marketing 18,422.17 27,107.00 8,684.83 32.0% 101,339.56 122,375.00 21,035.44 245,611.00 144,271.44 41%670000 General & Administrative28,038.82 27,911.00 (127.82) -0.5% 153,643.33 155,566.00 1,922.67 312,385.00 158,741.67 49%680000 Leases 16,545.39 18,890.00 2,344.61 12.4% 106,469.12 113,340.00 6,870.88 226,680.00 120,210.88 47%690000 Miscellaneous Other Expense8,069.69 14,512.00 6,442.31 44.4% 120,217.71 131,718.00 11,500.29 198,215.00 77,997.29 61%Total Expenses250,818.09 288,427.00 37,608.91 13.0% 1,815,370.41 1,880,661.00 65,290.59 3,506,736.00 1,691,365.59 52%78,460.39 24,937.25 53,523.14 214.6%(754,648.52) (788,620.95) 33,972.43 161,969.60 916,618.12 -466%Rounds of Golf PlayedPaid Rounds Played 4,060 3,900 160 4.1% 17,338 17,400 (62) 45,625 28,287 38%Ave $ Per Paid Round Green Fee68.78 72.94 (4.16) -5.7% 53.25 56.84 (3.59) 73.44 20.19 73%Ave $ Per Paid Round Merchandise5.73 6.75 (1.02) -15.1% 4.85 5.39 (0.54) 6.82 1.97 71%Ave $ Per Paid Miscellaneous 9.65 3.86 5.79 150.1% 5.38 3.04 2.34 3.51 (1.87) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateDecember 20121 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 279,251.66 284,456.00 (5,204.34) 923,279.89 989,072.00 (65,792.11) 3,350,773.002,427,493.1128%4010000 Rider Fee 550.00 975.00 (425.00) 3,845.00 2,325.00 1,520.00 7,643.003,798.0050%4040000 Club Rental 1,905.00 1,950.00 (45.00) 7,305.00 8,700.00 (1,395.00) 23,325.0016,020.0031%4050000 Driving Range 8,463.00 6,630.00 1,833.00 25,019.00 27,930.00 (2,911.00) 85,405.0060,386.0029%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 500.00 (500.00) - 1,400.00 (1,400.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract - - - 2,495.90 2,000.00 495.90 4,000.00 1,504.1062%4091000 Golf Professional Rental Fee 5,650.00 5,000.00 650.00 10,450.00 10,000.00 450.00 37,000.00 26,550.00 28%4092000 Golf Lessons 591.65 - 591.65 591.65 591.65 - - (591.65) 0%4093000 Resident Card Issue 22,035.00 - 22,035.00 43,590.00 - 43,590.00 - - 0% Total Revenue Fees 318,446.31 299,511.00 18,935.31 1,016,576.44 1,042,018.65 (25,442.21) 3,510,746.00 2,537,759.56 28%318,446.31 299,511.00 18,935.31 1,016,576.44 1,042,018.65 (25,442.21) 3,510,746.00 2,537,759.56 28%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueDecember 20122 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 325.16 - 325.16 797.66 - 797.66 0 0 0%4100110 Sales Hard Goods 10,314.56 9,214.00 1,100.56 35,380.28 32,835.00 2,545.28 108,867.00 73,486.72 32%4100112 Sales-Soft Goods 16,212.25 17,111.00 (898.75) 61,397.45 60,977.00 420.45 202,181.00 140,783.55 30%5100639 GS-Discounts-Mdse (3,577.02) - (3,577.02) (13,490.94) - (13,490.94) - 13,490.94 0% Total Revenue Golf Shop 23,274.95 26,325.00 (3,050.05) 84,084.45 93,812.00 (9,727.55) 311,048.00 227,761.21 27%COS 5100150 COS-GS-Hard Goods 6,198.77 5,067.70 1,131.07 18,724.55 18,059.25 665.30 59,876.85 41,152.30 31%5100151 COS-GS-Soft Goods 7,452.53 9,411.05 (1,958.52) 26,321.22 33,537.35 (7,216.13) 111,199.55 84,878.33 24%5100152 COS-GS-Purchase Disc (50.10) (724.00) 673.90 (1,156.57) (2,580.00) 1,423.43 (8,554.00) (7,397.43) -14%5100220 COS-GS-Freight Merch 342.23 217.00 125.23 2,054.13 774.00 1,280.13 2,566.00 511.87 80%Cost of Sales - Golf Shop 13,943.43 13,971.75 (28.32) 45,943.33 49,790.60 (3,847.27) 165,088.40 119,145.07 28%Gross Profit 9,331.52 12,353.25 (3,021.73) 38,141.12 44,021.40 (5,880.28) 145,959.60 108,616.14 26%COS % 59.9% 53.1% -6.8% 54.6% 53.1% -1.6% 53.1% 52.3% 1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,002.29 2,317.00 (314.71) 14,013.74 12,909.00 1,104.74 26,811.00 12,797.26 52%6101325 Insurance-Workers Comp 309.05 512.00 (202.95) 2,488.51 2,671.00 (182.49) 5,663.00 3,174.49 44%6101720 Salaries 3,545.44 3,750.00 (204.56) 23,045.36 22,500.00 545.36 45,000.00 21,954.64 51%6101800 Taxes-Employer Payroll 1,109.80 1,333.00 (223.20) 5,560.82 6,957.00 (1,396.18) 14,758.00 9,197.18 38%6101880 Wages-Hourly 8,273.48 9,008.00 (734.52) 41,467.95 44,070.00 (2,602.05) 96,229.00 54,761.05 43%6101882 Wages-Overtime 15.75 - 15.75 866.29 - 866.29 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,255.81 16,920.00 (1,664.19) 87,442.67 89,107.00 (1,664.33) 188,461.00 102,837.50 45%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office - 500.00 (500.00) 519.67 3,000.00 (2,480.33) 6,000.00 5,480.33 9%6109090 Contract Services 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50%6109220 Freight & Delivery - 25.00 (25.00) 77.35 75.00 2.35 75.00 (2.35) 103%6109490 Miscellaneous - 50.00 (50.00) 1,105.78 150.00 955.78 450.00 (655.78) 246%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 8.76 - 8.76 44.41 - 44.41 - (44.41) 0%6109722 Seminars/Training - 100.00 (100.00) 2,316.25 3,250.00 (933.75) 5,890.00 3,573.75 39%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 2,664.74 900.00 1,764.74 2,400.00 (264.74) 111%6117840 Telephones 108.08 110.00 (1.92) 552.45 660.00 (107.55) 1,320.00 767.55 0%Total PS-OTHER EXPENSES 616.84 1,485.00 (868.16) 10,280.65 11,035.00 (754.35) 24,525.00 14,244.35 42%15,872.65 18,405.00 (2,532.35) 97,723.32 100,142.00 (2,418.68) 212,986.00 117,081.85 45%Net Income(6,541.13) (6,051.75) (489.38) (59,582.20) (56,120.60) (3,461.60) (67,026.40) (8,465.71) -87%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementDecember 20123 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 7,235.58 8,740.00 (1,504.42) 54,797.61 52,440.00 2,357.61 104,880.00 50,082.39 47.8%6311325 Insurance-Workers Comp 1,390.20 2,332.00 (941.80) 9,914.93 13,653.00 (3,738.07) 27,280.00 17,365.07 63.7%6311720 Salaries 11,001.60 11,001.60 - 71,510.40 66,009.60 5,500.80 150,996.00 79,485.60 52.6%6311800 Taxes-Employer Payroll 4,987.88 6,078.00 (1,090.12) 29,076.60 35,943.00 (6,866.40) 71,645.00 42,568.40 59.4%6311880 Wages-Hourly 46,956.62 47,165.40 (208.78) 278,681.63 267,437.40 11,244.23 518,654.00 239,972.37 46.3%6311882 Wages-Overtime 278.73 - 278.73 11,595.93 10,526.00 1,069.93 15,945.00 4,349.07 27.3%Total-CM-SALARIES & BENEFITS71,850.61 75,317.00 (3,466.39) 455,577.10 446,009.00 9,568.10 889,400.00 433,822.90 48.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,236.10 - 2,236.10 15,061.85 - 15,061.85 31,100.00 16,038.15 51.6%6313744 Fertilizer 7,239.53 11,200.00 (3,960.47) 73,775.42 91,200.00 (17,424.58) 114,500.00 40,724.58 35.6%6313745 Herbicides 5,000.00 5,000.00 - 17,281.37 17,000.00 281.37 17,000.00 (281.37) -1.7%6313746 Flowers/Plants 64.65 750.00 (685.35) 387.90 2,000.00 (1,612.10) 3,050.00 2,662.10 87.3%6313748 Fuel-Gasoline 2,859.53 4,200.00 (1,340.47) 27,645.04 33,200.00 (5,554.96) 55,020.00 27,374.96 49.8%6313750 Golf Course Accessories 1,100.30 1,200.00 (99.70) 14,378.91 12,300.00 2,078.91 13,000.00 (1,378.91) -10.6%6313756 POA Control - - - 4,362.74 3,500.00 862.74 7,000.00 2,637.26 37.7%6313758 Miscellaneous Supp 1,075.00 500.00 575.00 4,755.74 3,750.00 1,005.74 4,350.00 (405.74) 0.0%6313762 Supplies-Office - - - 486.72 - 486.72 - (486.72) 0.0%6313774 Sand - 800.00 (800.00) 5,866.07 15,580.00 (9,713.93) 16,460.00 10,593.93 64.4%6313776 Seed - 350.00 (350.00) 97,122.41 104,710.00 (7,587.59) 106,810.00 9,687.59 9.1%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,192.82 4,400.00 (207.18) 5,000.00 807.18 16.1%6313780 Sod - 250.00 (250.00) 6,767.37 6,750.00 17.37 7,950.00 1,182.63 14.9%6313782 Topdressing - - - 7,026.64 5,000.00 2,026.64 7,600.00 573.36 7.5%Total-CM-SUPPLIES & MATERIALS19,575.11 24,350.00 (4,774.89) 279,111.00 299,390.00 (20,279.00) 388,840.00 109,729.00 28.2%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 - 500.00 (500.00) 646.40 4,050.00 (3,403.60) 5,550.00 4,903.60 88.4%6315690 CM-R&M-Equipment 3,215.32 2,000.00 1,215.32 27,829.94 18,000.00 9,829.94 31,000.00 3,170.06 10.2%6315692 CM-R&M-Irrigation System 524.07 550.00 (25.93) 9,397.56 16,450.00 (7,052.44) 22,650.00 13,252.44 58.5%6315696 CM-R&M-Pumps 665.00 1,000.00 (335.00) 5,556.81 6,000.00 (443.19) 10,500.00 4,943.19 47.1%6315815 CM-R&M-Trees-Pruning Etc - - - 7,500.00 4,050.00 3,450.00 10,050.00 2,550.00 25.4%Total-CM-REPAIRS & MAINTENANCE 7,234.39 6,650.00 584.39 67,910.71 64,150.00 3,760.71 110,950.00 43,039.29 38.8%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 25.26 15.00 10.26 136.91 90.00 46.91 180.00 43.09 0.0%6317840 Telephones 1,113.90 850.00 263.90 7,234.20 5,100.00 2,134.20 10,200.00 2,965.80 29.1%Total-CM-UTILITIES 1,139.16 865.00 274.16 7,371.11 5,190.00 2,181.11 10,380.00 3,008.89 29.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 4,000.00 100.0%6319102 Contract Svcs-Trash Removal 1,127.48 524.00 603.48 5,500.10 3,144.00 2,356.10 6,288.00 787.90 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) - 300.00 (300.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 200.00 (200.00) 579.13 3,100.00 (2,520.87) 4,200.00 3,620.87 86.2%6319206 Licenses & Permits - - - - 280.00 (280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous 610.77 100.00 510.77 1,841.33 600.00 1,241.33 1,200.00 (641.33) -53.4%6319718 Safety Equipment & Training 722.42 400.00 322.42 2,562.62 2,750.00 (187.38) 3,850.00 1,287.38 33.4%6319822 Uniforms 1,079.66 920.00 159.66 7,389.47 5,520.00 1,869.47 11,040.00 3,650.53 33.1%Total-CM-OTHER EXPENSES 4,250.33 2,694.00 1,556.33 21,292.65 20,694.00 598.65 40,098.00 18,805.35 46.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2012Annual Budget4 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,248.90 2,648.00 (1,399.10) 12,312.08 15,888.00 (3,575.92) 31,776.00 19,463.92 61.3%6321325 Insurance-Workers Comp 302.06 516.00 (213.94) 3,193.60 3,239.00 (45.40) 6,361.00 3,167.40 49.8%6321800 Taxes-Employer Payroll 952.44 1,346.00 (393.56) 7,290.40 8,631.00 (1,340.60) 16,808.00 9,517.60 56.6%6321880 Wages-Hourly 12,564.43 12,880.00 (315.57) 76,293.27 77,280.00 (986.73) 154,560.00 78,266.73 50.6%6321882 Wages-Overtime 65.26 - 65.26 1,790.17 5,313.00 (3,522.83) 6,279.00 4,488.83 71.5%Total-CM-LM-SALARIES & BENEFITS15,133.09 17,390.00 (2,256.91) 100,879.52 110,351.00 (9,471.48) 215,784.00 114,904.48 53.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) - 575.00 (575.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 251.12 290.00 (38.88) 1,584.98 1,740.00 (155.02) 3,480.00 1,895.02 54.5%Total-CM-LM-SUPPLIES & MATERIALS251.12 365.00 (113.88) 1,584.98 2,315.00 (730.02) 4,505.00 2,920.02 64.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%119,433.81 128,131.00 (8,697.19) 933,727.07 950,599.00 (16,871.93) 1,664,207.00 730,479.93 43.9% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 8,715.35 13,090.00 (4,374.65) 78,490.13 77,490.00 1,000.13 178,691.00 100,200.87 56.1%6337842 Utilities-Water2,996.75 2,325.00 671.75 33,206.00 26,860.00 6,346.00 43,058.00 9,852.00 22.9%11,712.10 15,415.00 (3,702.90) 111,696.13 104,350.00 7,346.13 221,749.00 110,052.87 49.6%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyDecember 2012Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementDecember 2012Annual BudgetMonth to Date Year to Date5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 289.78 662.00 (372.22) 2,138.68 3,972.00 (1,833.32) 7,944.00 5,805.32 73.1%6411325 Insurance-Workers Comp 207.04 557.00 (349.96) 1,909.63 2,202.00 (292.37) 5,135.00 3,225.37 62.8%6411800 Taxes-Employer Payroll 1,164.76 1,729.00 (564.24) 5,856.05 6,836.00 (979.95) 15,942.00 10,085.95 63.3%6411880 Wages-Hourly 12,933.21 13,890.00 (956.79) 54,522.95 54,912.00 (389.05) 128,052.00 73,529.05 57.4%6411882 Wages-Overtime 122.63 - 122.63 666.21 - 666.21 - (666.21) 0.0%Total-CBR-SALARIES & BENEFITS14,717.42 16,838.00 (2,120.58) 65,093.52 67,922.00 (2,828.48) 157,073.00 91,979.48 58.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 671.83 2,000.00 (1,328.17) 2,350.00 1,678.17 71.4%6413742 Supplies-Expendable 300.63 150.00 150.63 5,188.62 3,450.00 1,738.62 6,750.00 1,561.38 23.1%6413748 Supplies-Fuel for Shuttle 272.04 400.00 (127.96) 574.85 900.00 (325.15) 3,000.00 2,425.15 80.8%6413752 Supplies-Range Balls - - - 9,177.75 9,000.00 177.75 9,000.00 (177.75) -2.0%6413762 Supplies-Office - 50.00 (50.00) - 225.00 (225.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) 1,280.00 573.00 707.00 1,005.00 (275.00) -27.4%6413796 Supplies-Bottled Water29.95 50.00 (20.05) 9,817.02 12,250.00 (2,432.98) 24,500.00 14,682.98 59.9%Total-CBR-SUPPLIES & MATERIALS602.62 1,222.00 (619.38) 26,710.07 28,398.00 (1,687.93) 47,550.00 20,839.93 43.8%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 1,506.09 300.00 1,206.09 1,564.63 1,800.00 (235.37) 3,600.00 2,035.37 56.5%6415695 CBR-R&M-Cart Maintenance & Repair 175.39 750.00 (574.61) 2,496.66 5,250.00 (2,753.34) 9,750.00 7,253.34 74.4%Total-CBR-REPAIRS & MAINTENANCE 1,681.48 1,050.00 631.48 4,061.29 7,050.00 (2,988.71) 13,350.00 9,288.71 69.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen - 800.00 (800.00) 3,858.85 4,800.00 (941.15) 9,600.00 5,741.15 59.8%6419220 Freight/Delivery - 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 67.24 500.00 (432.76) 1,150.00 1,082.76 94.2%6419820 Uniforms - 500.00 (500.00) 2,317.39 3,000.00 (682.61) 5,200.00 2,882.61 55.4%Total-CBR-OTHER EXPENSES - 1,450.00 (1,450.00) 6,243.48 8,750.00 (2,506.52) 16,400.00 10,156.52 61.9%TOTAL-CARTS,BAGROOM & RANGE 17,001.52 20,560.00 (3,558.48) 102,108.36 112,120.00 (10,011.64) 234,373.00 132,264.64 56.4%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 101.90 225.00 (123.10) 1,541.09 815.00 726.09 1,903.00 361.91 19.0%6431800 Taxes-Employer Payroll 439.01 585.00 (145.99) 2,147.78 2,120.00 27.78 4,960.00 2,812.22 56.7%6431880 Wages-Hourly 5,322.00 5,600.00 (278.00) 19,976.00 20,300.00 (324.00) 47,460.00 27,484.00 57.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS5,862.91 6,410.00 (547.09) 23,664.87 23,235.00 429.87 54,323.00 30,658.13 56.4%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 691.76 500.00 191.76 1,050.00 358.24 34.1%6439490 Miscellaneous - 50.00 (50.00) 647.25 150.00 497.25 200.00 (447.25) -223.6%6439718 Safety Equipment & Training - 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6439820 Uniforms - 250.00 (250.00) 1,114.00 1,350.00 (236.00) 2,125.00 1,011.00 47.6%Total-CS-OTHER EXPENSES - 450.00 (450.00) 2,453.01 2,300.00 153.01 3,975.00 1,521.99 38.3%Total-COURSE SERVICES 5,862.91 6,860.00 (997.09) 26,117.88 25,535.00 582.88 58,298.00 32,180.12 55.2%22,864.43 27,420.00 (4,555.57) 128,226.24 137,655.00 (9,428.76) 292,671.00 162,922.77 55.7%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementDecember 2012Annual Budget6 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,264.00 2,400.00 (1,136.00) 4,800.00 3,536.00 73.7%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,264.00 2,400.00 (1,136.00) 4,800.00 3,536.00 73.7%65-CH-UTILITIES6507836 Utilities-Natural Gas451.83 300.00 151.83 760.43 1,800.00 (1,039.57) 3,600.00 2,839.57 78.9%6507840 Utilities-Telephone1,248.27 1,150.00 98.27 7,324.45 6,900.00 424.45 13,800.00 6,475.55 46.9%6507842 Utilities-Water336.50 321.00 15.50 2,064.46 1,926.00 138.46 3,852.00 1,787.54 46.4%6507844 Utilities-Cable336.91 340.00 (3.09) 2,021.46 2,040.00 (18.54) 4,080.00 2,058.54 50.5%Total-CH-UTILITIES 2,373.51 2,111.00 262.51 12,170.80 12,666.00 (495.20) 25,332.00 13,161.20 52.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 1,825.00 (75.00) 10,875.00 11,550.00 (675.00) 22,500.00 11,625.00 51.7%6509099 Contract Services-Security5,206.56 4,900.00 306.56 31,129.64 29,400.00 1,729.64 60,400.00 29,270.36 48.5%6509215 Flowers & Decorations- - - 98.89 500.00 (401.11) 2,400.00 2,301.11 95.9%6509490 Miscellaneous- 200.00 (200.00) 206.21 1,200.00 (993.79) 2,400.00 2,193.79 91.4%6509718 Safety Equipment & Training- 100.00 (100.00) 121.12 600.00 (478.88) 1,200.00 1,078.88 89.9%Total-CH-OTHER EXPENSES 6,956.56 7,025.00 (68.44) 42,430.86 43,250.00 (819.14) 88,900.00 46,469.14 52.3%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures528.96 300.00 228.96 1,570.30 1,800.00 (229.70) 3,600.00 2,029.70 56.4%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,018.00 2,400.00 618.00 4,800.00 1,782.00 37.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 1,873.97 2,400.00 (526.03) 4,800.00 2,926.03 61.0%Total-CH-REPAIRS & MAINTENANCE 528.96 1,100.00 (571.04) 6,462.27 6,600.00 (137.73) 13,200.00 6,737.73 51.0%9,859.03 10,636.00 (776.97) 62,327.93 64,916.00 (2,588.07) 132,232.00 13,475.46 10.2%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementDecember 2012Annual Budget7 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 289.78 331.00 (41.22) 2,138.68 1,986.00 152.68 3,972.00 1,833.32 46.2%6601325 Insurance-Workers Comp 67.02 101.00 (33.98) 827.16 606.00 221.16 1,207.00 379.84 31.5%6601720 Salaries 2,307.45 2,508.00 (200.55) 14,559.52 15,048.00 (488.48) 30,096.00 15,536.48 51.6%6601800 Taxes-Employer Payroll 235.68 262.00 (26.32) 1,860.93 1,572.00 288.93 3,145.00 1,284.07 40.8%Total-MKT-SALARIES & BENEFITS 2,899.93 3,202.00 (302.07) 19,386.29 19,212.00 174.29 38,420.00 19,033.71 49.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 904.91 200.00 704.91 4,311.92 3,600.00 711.92 4,425.00 113.08 2.6%904.91 300.00 604.91 4,311.92 4,200.00 111.92 5,625.00 1,313.08 23.3%66-MKT-UTILITIES6607840 Utilities-Telephone 105.76 100.00 5.76 633.68 600.00 33.68 1,200.00 566.32 47.2%Total-MKT-UTILITIES 105.76 100.00 5.76 633.68 600.00 33.68 1,200.00 566.32 47.2%66-MKT-OTHER EXPENSES6609010 Advertising 14,150.57 21,730.00 (7,579.43) 75,485.62 88,163.00 (12,677.38) 179,231.00 103,745.38 57.9%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material 262.00 - 262.00 524.00 3,500.00 (2,976.00) 9,000.00 8,476.00 94.2%6609102 Contract Services-Web Page 99.00 300.00 (201.00) 495.00 1,800.00 (1,305.00) 3,600.00 3,105.00 86.3%6609490 Miscellaneous - 50.00 (50.00) - 100.00 (100.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 19.82 300.00 (280.18) 600.00 580.18 96.7%6609630 Promotion - 25.00 (25.00) 104.43 150.00 (45.57) 3,000.00 2,895.57 0.0%6609633 Promotion-Community - 800.00 (800.00) 278.80 1,950.00 (1,671.20) 2,250.00 1,971.20 87.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 2,000.00 (2,000.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 100.00 - 100.00 735.00 635.00 86.4%6609820 Uniforms - 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 14,511.57 23,505.00 (8,993.43) 77,007.67 98,363.00 (21,355.33) 200,366.00 122,658.33 61.2%18,422.17 27,107.00 (8,684.83) 101,339.56 122,375.00 (21,035.44) 245,611.00 143,571.44 58.5%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementDecember 2012Annual Budget8 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,216.49 1,458.00 (241.51) 9,882.30 8,748.00 1,134.30 17,496.00 7,613.70 43.5%6701325 Insurance-Workers Comp302.40 688.00 (385.60) 3,050.63 4,128.00 (1,077.37) 8,254.00 5,203.37 63.0%6701720 Salaries 12,816.26 15,003.00 (2,186.74) 86,305.69 90,018.00 (3,712.31) 178,000.00 91,694.31 51.5%6701800 Taxes-Employer Payroll 1,730.64 1,792.00 (61.36) 7,930.50 10,752.00 (2,821.50) 21,510.00 13,579.50 63.1%6701880 Wages-Hourly2,614.42 2,150.00 464.42 10,826.09 12,900.00 (2,073.91) 27,835.00 17,008.91 61.1%6701882 Wages-Overtime - - - 22.69 - 22.69 - (22.69) 0.0%Total-G&A-SALARIES & BENEFITS 18,680.21 21,091.00 (2,410.79) 118,017.90 126,546.00 (8,528.10) 253,095.00 135,077.10 53.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 227.07 2,400.00 (2,172.93) 5,200.00 4,972.93 95.6%6703762 Supplies-Office 169.06 100.00 69.06 1,046.13 600.00 446.13 1,200.00 153.87 12.8%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 711.44 900.00 (188.56) 3,300.00 2,588.56 78.4%Total-G&A-SUPPLIES & MATERIALS 169.06 900.00 (730.94) 1,984.64 3,900.00 (1,915.36) 9,700.00 7,715.36 79.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 500.00 (500.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 500.00 (500.00) 1,100.00 1,100.00 100.0%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/Relocation30.00 200.00 (170.00) 1,612.60 800.00 812.60 1,400.00 (212.60) -15.2%6709197 Equipment Rental703.26 480.00 223.26 4,262.04 2,880.00 1,382.04 5,760.00 1,497.96 26.0%6709202 Fees-Bank123.31 90.00 33.31 699.10 540.00 159.10 1,080.00 380.90 35.3%6709208 Fees-Payroll Processing1,792.67 1,100.00 692.67 7,740.81 6,600.00 1,140.81 13,200.00 5,459.19 41.4%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous 51.67 100.00 (48.33) 147.63 600.00 (452.37) 1,200.00 1,052.37 87.7%6709620 Postage/Mail Services - 75.00 (75.00) 757.82 450.00 307.82 900.00 142.18 15.8%6709625 Professional Fees1,130.01 850.00 280.01 6,259.26 5,100.00 1,159.26 10,200.00 3,940.74 38.6%6709636 Promotion/Entertainment2,526.78 2,000.00 526.78 2,526.78 2,500.00 26.78 3,100.00 573.22 18.5%6709722 Seminars & Training336.08 200.00 136.08 586.08 1,200.00 (613.92) 2,400.00 1,813.92 75.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 290.27 600.00 (309.73) 1,050.00 759.73 72.4%Total-G&A-OTHER EXPENSES 7,093.78 5,820.00 1,273.78 27,447.39 24,620.00 2,827.39 48,490.00 21,042.61 43.4%25,943.05 27,911.00 (1,967.95) 147,449.93 155,566.00 (8,116.07) 312,385.00 164,935.07 52.8%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2012Annual Budget9 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4009300Resident Card Issue22,035.00 - 22,035.00 43,590.00 - 43,590.00 - - 0%- - 0% Total Revenue Resident Cards22,035.00 - 22,035.00 43,590.00 - 43,590.00 - - 0%Expense60-RC-SALARIES & BENEFITS6001800 Taxes-Employer Payroll 174.40 - 174.40 261.60 - 261.60 - - 0%6001880 Wages-Hourly1,041.48 - 1,041.48 1,502.28 - 1,502.28 - - 0%6001882 Wages-Overtime - - - - - - - - 0%Total -RC-SALARIES & BENEFITS 1,215.88 - 1,215.88 1,763.88 - 1,763.88 - - 0%60-RC- OTHER EXPENSES6003762 Supplies-Office - - - - - - - - 0%6009490 Miscellaneous - - - 3,549.63 - 3,549.63 - - 0%6003740 Supplies-Computer- - - - - - - - 0%6009625 Professional Fees879.89 - 879.89 879.89 - 879.89 - - 0%Total RC-OTHER EXPENSES 879.89 - 879.89 4,429.52 - 4,429.52 - - 0%2,095.77 - 2,095.77 6,193.40 - 6,193.40 - - 0%Net Income19,939.23 - 19,939.23 37,396.60 - 37,396.60 - - 0%Month to Date Year to Date Annual BudgetTotal-RESIDENT CARDSSilverRock ResortResident Card Income StatementDecember 201210 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 71,032.88 72,450.00 (1,417.12) 144,900.00 73,867.12 51.0%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 2,772.70 3,600.00 (827.30) 7,200.00 4,427.30 61.5%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 29,640.00 34,530.00 (4,890.00) 69,060.00 39,420.00 57.1%6800197 Equipment Leases-Others 11.22 460.00 (448.78) 3,023.54 2,760.00 263.54 5,520.00 2,496.46 0.0%16,545.39 18,890.00 (2,344.61) 106,469.12 113,340.00 (6,870.88) 226,680.00 120,210.88 53.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 1,613.46 6,623.00 (5,009.54) 74,458.72 83,937.00 (9,478.28) 90,000.00 15,541.28 17.3%6900210 FF&E Reserve 5,585.04 5,689.00 (103.96) 18,465.62 19,781.00 (1,315.38) 67,015.00 48,549.38 72.4%6900800 Personal Property Taxes 382.85 - 382.85 11,907.60 14,800.00 (2,892.40) 14,800.00 2,892.40 19.5%6900323 Insurance-Commercial 488.34 2,200.00 (1,711.66) 15,385.77 13,200.00 2,185.77 26,400.00 11,014.23 41.7%8,069.69 14,512.00 (6,442.31) 120,217.71 131,718.00 (11,500.29) 198,215.00 77,997.29 39.3%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 201211 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia342 4SalesPromotion8Golf IndustryVIPCelebrityPGA Comp62 16 46 15 20 37Charity/Gift Certificate61511 428Rain/Wind Checks536Club Staff129 60 81 13 78 139LQ HS Golf8123194213 95 152 28 136 3162013 2013 2013 2013 2013 2013Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013December 2012 Date Time Description CategoryPlayers12/1/2012 7:22 Scott Whilte w/ CVA Promo 212/18/2012 8:00 Judd Spicer - Golf Writer Promo 212/26/2012 10:30 John White - News Anchor Promo 412/29/2012 12:15 Tom Nolan - PS Airport Promo 413