Loading...
12 June 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2011 – June 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 10 Complimentary Report 11 Annual BudgetAccount Description June Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue129,028.37 154,289.00 (25,260.63) -16.4% 3,305,002.33 3,326,982.00 (21,979.67) 3,326,982.00 21,979.67 99%401000 Miscellaneous Golf Revenue 5,228.00 5,145.00 83.00 1.6% 193,459.66 146,541.00 46,918.66 146,537.00 (46,922.66) 132%410000 Revenue-Golf Shop 11,635.28 14,700.00 (3,064.72) -20.8% 282,353.11 310,921.00 (28,567.89) 310,919.00 28,565.89 91%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 12,000.00 12,000.00 - 12,000.00 - 100%890000 Interest Income0.61 - 0.61 0.0% 25.60 - 25.60 - (25.60) 0%Total Income146,392.26 174,634.00 (28,241.74) -16.2% 3,792,840.70 3,796,444.00 (3,603.30) 3,796,438.00 3,597.30 100%Cost of Goods Sold510000 COS-Golf Shop 6,208.36 7,802.00 (1,593.64) 20.4% 162,767.59 165,023.55 2,255.96 165,020.45 2,252.86 99%Total COS6,208.36 7,802.00 (1,593.64) 20.4% 162,767.59 165,023.55 2,255.96 165,020.45 2,252.86 99%Gross Profit140,183.90 166,832.00 (26,648.10) -16.0% 3,630,073.11 3,631,420.45 (1,347.34) 3,631,417.55 1,344.44 100%Expenses610000 Golf Pro Shop 17,751.50 18,061.00 309.50 1.7% 200,280.03 223,325.00 23,044.97 223,325.00 23,044.97 90%630000 Course Maintenance127,359.03 116,084.00 (11,275.03) -9.7% 1,686,920.55 1,638,852.00 (48,068.55) 1,638,879.00 (48,041.55) 103%633000 Maintenance Water & Energy22,616.52 28,040.00 5,423.48 19.3% 211,103.18 270,449.00 59,345.82 270,449.00 59,345.82 78%640000 Outside Services26,123.57 28,523.00 2,399.43 8.4% 288,926.91 281,023.00 (7,903.91) 281,023.00 (7,903.91) 103%650000 Clubhouse 13,952.77 11,036.00 (2,916.77) -26.4% 129,094.44 132,232.00 3,137.56 132,232.00 3,137.56 98%660000 Marketing 21,013.58 10,216.00 (10,797.58) -105.7% 235,512.00 254,814.00 19,302.00 254,820.00 19,308.00 92%670000 General & Administrative26,002.99 26,452.00 449.01 1.7% 299,160.86 314,674.00 15,513.14 314,669.00 15,508.14 95%680000 Leases 22,633.79 19,590.00 (3,043.79) -15.5% 236,663.60 235,080.00 (1,583.60) 235,080.00 (1,583.60) 101%690000 Miscellaneous Other Expense23,540.91 24,104.00 563.09 2.3% 202,325.29 197,740.00 (4,585.29) 197,740.00 (4,585.29) 102%Total Expenses300,994.66 282,106.00 (18,888.66) -6.7% 3,489,986.86 3,548,189.00 58,202.14 3,548,217.00 58,230.14 98%(160,810.76) (115,274.00) (45,536.76) -39.5%140,086.25 83,231.45 56,854.80 83,200.55 (56,885.70) 168%Rounds of Golf PlayedPaid Rounds Played 2,442 2,450 (8) -0.3% 46,949 45,625 1,324 45,625 (1,324) 103%Ave $ Per Paid Round Green Fee52.84 62.98 (10.14) -16.1% 70.40 72.92 (2.52) 72.92 2.52 97%Ave $ Per Paid Round Merchandise4.76 6.00 (1.24) -20.6% 6.01 6.81 (0.80) 6.81 0.80 88%Ave $ Per Paid Miscellaneous 2.14 2.10 0.04 1.9% 4.12 3.21 0.91 3.21 (0.91) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJune 20121 Income June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 129,028.37 154,289.00 (25,260.63) 3,305,002.33 3,326,982.00 (21,979.67) 3,326,982.0021,979.6799%4010000 Rider Fee 1,170.00 245.00 925.00 13,470.00 7,448.00 6,022.00 7,446.00-6,024.00181%4040000 Club Rental 640.00 1,225.00 (585.00) 26,219.00 22,814.00 3,405.00 22,813.00-3,406.00115%4050000 Driving Range 3,418.00 3,675.00 (257.00) 87,982.00 73,279.00 14,703.00 73,278.00-14,704.00120%4060000 Handicap Fees - - - 3,635.00 - 3,635.00 0.000.000%4080000 GPS Advertising - - - 2,554.48 12,000.00 (9,445.52) 12,000.00 9,445.5221%4090000 Ball Retriever/Subcontract - - - 3,269.30 4,000.00 (730.70) 4,000.00 730.7082%4091000 Golf Professional Rental Fee - - - 54,059.25 27,000.00 27,059.25 27,000.00 -27,059.25 200%4092000 Golf Lessons - - - 2,270.63 - 2,270.63 - (2,270.63) 0% Total Revenue Fees 134,256.37 159,434.00 (25,177.63) 3,498,461.99 3,473,523.00 24,938.99 3,473,519.00 (21,307.99) 101%134,256.37 159,434.00 (25,177.63) 3,498,461.99 3,473,523.00 24,938.99 3,473,519.00 (21,307.99) 101%SilverRock ResortStatement of Fees RevenueJune 2012Total IncomeMonth to Date Year to Date Annual Budget2 Income June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 106.07 - 106.07 3,754.49 - 3,754.49 0 0 0%4100110 Sales Hard Goods 5,827.29 5,145.00 682.29 110,548.53 108,823.00 1,725.53 108,822.00 (1,726.53) 102%4100112 Sales-Soft Goods 7,489.04 9,555.00 (2,065.96) 213,328.44 202,098.00 11,230.44 202,097.00 (11,231.44) 106%5100639 GS-Discounts-Mdse (1,787.12) - (1,787.12) (45,278.35) - (45,278.35) - 45,278.35 0% Total Revenue Golf Shop 11,635.28 14,700.00 (3,064.72) 282,353.11 310,921.00 (28,567.89) 310,919.00 32,320.38 90%COS 5100150 COS-GS-Hard Goods 1,885.62 2,829.75 (944.13) 60,611.29 59,852.65 758.64 59,852.10 (759.19) 101%5100151 COS-GS-Soft Goods 4,202.14 5,255.25 (1,053.11) 99,048.92 111,153.90 (12,104.98) 111,153.35 12,104.43 89%5100152 COS-GS-Purchase Disc (198.45) (404.00) 205.55 (1,435.95) (8,552.00) 7,116.05 (8,550.00) (7,114.05) -17%5100220 COS-GS-Freight Merch 319.05 121.00 198.05 4,543.33 2,569.00 1,974.33 2,565.00 (1,978.33) 177%Cost of Sales - Golf Shop 6,208.36 7,802.00 (1,593.64) 162,767.59 165,023.55 (2,255.96) 165,020.45 2,252.86 99%Gross Profit 5,426.92 6,898.00 (1,471.08) 119,585.52 145,897.45 (26,311.93) 145,898.55 30,067.52 79%COS % 53.4% 53.1% -0.3% 57.6% 53.1% -4.6% 53.1% 7.0% 87%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 2,317.00 85.29 29,673.94 26,811.00 2,862.94 26,811.00 (2,862.94) 111%6101325 Insurance-Workers Comp 501.70 511.00 (9.30) 5,334.05 6,132.00 (797.95) 6,131.00 796.95 87%6101720 Salaries 3,745.44 3,750.00 (4.56) 45,463.50 45,000.00 463.50 45,000.00 (463.50) 101%6101800 Taxes-Employer Payroll 1,115.13 1,420.00 (304.87) 14,354.75 17,039.00 (2,684.25) 17,040.00 2,685.25 84%6101880 Wages-Hourly 8,645.66 8,653.00 (7.34) 86,911.67 103,818.00 (16,906.33) 103,818.00 16,906.33 84%6101882 Wages-Overtime 119.26 - 119.26 1,618.15 - 1,618.15 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,529.48 16,651.00 (121.52) 183,356.06 198,800.00 (15,443.94) 198,800.00 18,014.97 91%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 351.07 500.00 (148.93) 3,892.40 6,000.00 (2,107.60) 6,000.00 2,107.60 65%6109090 Contract Services 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 100%6109220 Freight & Delivery - - - 620.42 75.00 545.42 75.00 (545.42) 827%6109490 Miscellaneous 24.95 50.00 (25.05) 556.13 450.00 106.13 450.00 (106.13) 124%6109150 Dues and Subscriptions - - - 1,326.00 2,300.00 (974.00) 2,300.00 974.00 58%6109500 ProShop-Over/Short 9.07 - 9.07 186.67 - 186.67 - (186.67) 0%6109722 Seminars/Training - 35.00 (35.00) 302.96 5,890.00 (5,587.04) 5,890.00 5,587.04 5%6109810 Travel - Merchandise - 15.00 (15.00) - 90.00 (90.00) 90.00 90.00 0%6109820 Uniforms 226.11 200.00 26.11 2,569.65 2,400.00 169.65 2,400.00 (169.65) 107%6117840 Telephones 110.82 110.00 0.82 1,469.74 1,320.00 149.74 1,320.00 (149.74) 0%Total PS-OTHER EXPENSES 1,222.02 1,410.00 (187.98) 16,923.97 24,525.00 (7,601.03) 24,525.00 7,601.03 69%17,751.50 18,061.00 (309.50) 200,280.03 223,325.00 (23,044.97) 223,325.00 25,616.00 89%Net Income(12,324.58) (11,163.00) (1,161.58) (80,694.51) (77,427.55) (3,266.96) (77,426.45) 4,451.52 -106%SilverRock ResortGolf Shop Income StatementJune 2012Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,258.73 8,740.00 518.73 107,686.57 104,880.00 2,806.57 104,880.00 (2,806.57) -2.7%6311325 Insurance-Workers Comp 1,937.02 2,347.00 (409.98) 22,744.04 28,026.00 (5,281.96) 28,026.00 5,281.96 18.8%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 140,453.76 150,996.00 (10,542.24) 150,996.00 10,542.24 7.0%6311800 Taxes-Employer Payroll 6,301.78 6,633.00 (331.22) 68,644.59 78,499.00 (9,854.41) 78,501.00 9,856.41 12.6%6311880 Wages-Hourly 47,393.03 42,478.00 4,915.03 537,841.96 518,654.00 19,187.96 518,654.00 (19,187.96) -3.7%6311882 Wages-Overtime 20.25 2,869.00 (2,848.75) 11,284.05 15,945.00 (4,660.95) 15,945.00 4,660.95 29.2%Total-CM-SALARIES & BENEFITS75,912.41 75,650.00 262.41 888,654.97 897,000.00 (8,345.03) 897,002.00 8,347.03 0.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,270.63 2,000.00 270.63 35,959.99 29,300.00 6,659.99 29,300.00 (6,659.99) -22.7%6313744 Fertilizer 7,648.55 5,000.00 2,648.55 120,702.76 104,400.00 16,302.76 104,400.00 (16,302.76) -15.6%6313745 Herbicides - - - 17,751.38 17,000.00 751.38 17,000.00 (751.38) -4.4%6313746 Flowers/Plants 323.25 - 323.25 3,452.98 3,050.00 402.98 3,050.00 (402.98) -13.2%6313748 Fuel-Gasoline 5,688.95 3,100.00 2,588.95 57,505.86 48,800.00 8,705.86 48,800.00 (8,705.86) -17.8%6313750 Golf Course Accessories 98.11 100.00 (1.89) 14,984.73 12,300.00 2,684.73 12,300.00 (2,684.73) -21.8%6313756 POA Control - - - 8,685.92 7,000.00 1,685.92 7,000.00 (1,685.92) -24.1%6313758 Miscellaneous Supp 463.50 100.00 363.50 10,843.99 4,350.00 6,493.99 4,350.00 (6,493.99) 0.0%6313762 Supplies-Office - - - 435.40 - 435.40 - (435.40) 0.0%6313774 Sand - 100.00 (100.00) 16,864.95 16,460.00 404.95 16,460.00 (404.95) -2.5%6313776 Seed - 350.00 (350.00) 106,201.53 106,810.00 (608.47) 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,512.09 5,000.00 (487.91) 5,000.00 487.91 9.8%6313780 Sod - 200.00 (200.00) 9,393.61 6,350.00 3,043.61 6,350.00 (3,043.61) -47.9%6313782 Topdressing 2,256.50 1,300.00 956.50 6,098.55 7,600.00 (1,501.45) 7,600.00 1,501.45 19.8%Total-CM-SUPPLIES & MATERIALS18,749.49 12,350.00 6,399.49 413,393.74 368,420.00 44,973.74 368,420.00 (44,973.74) -12.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 33,870.00 31,200.00 2,670.00 31,200.00 (2,670.00) -8.6%6315685 CM-R&M-Bldngs & Othr Structures 316.34 250.00 66.34 7,409.46 1,750.00 5,659.46 1,750.00 (5,659.46) -323.4%6315690 CM-R&M-Equipment 5,013.60 1,500.00 3,513.60 35,287.07 20,500.00 14,787.07 20,500.00 (14,787.07) -72.1%6315692 CM-R&M-Irrigation System 1,075.53 1,000.00 75.53 18,759.35 22,650.00 (3,890.65) 22,650.00 3,890.65 17.2%6315696 CM-R&M-Pumps 1,600.00 - 1,600.00 12,342.01 10,500.00 1,842.01 10,500.00 (1,842.01) -17.5%6315815 CM-R&M-Trees-Pruning Etc - - - 8,295.00 10,050.00 (1,755.00) 10,050.00 1,755.00 17.5%Total-CM-REPAIRS & MAINTENANCE 10,835.47 5,350.00 5,485.47 115,962.89 96,650.00 19,312.89 96,650.00 (19,312.89) -20.0%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 617.59 15.00 602.59 815.91 180.00 635.91 180.00 (635.91) 0.0%6317840 Telephones 1,094.43 850.00 244.43 14,055.44 10,200.00 3,855.44 10,200.00 (3,855.44) -37.8%Total-CM-UTILITIES 1,712.02 865.00 847.02 14,871.35 10,380.00 4,491.35 10,380.00 (4,491.35) -43.3%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - 4,000.00 4,000.00 - 4,000.00 - 0.0%6319102 Contract Svcs-Trash Removal - 524.00 (524.00) 8,715.64 6,288.00 2,427.64 6,288.00 (2,427.64) 0.0%6319150 Dues & Subscriptions 720.00 100.00 620.00 1,985.00 540.00 1,445.00 540.00 (1,445.00) -267.6%6319170 Employee Education - 50.00 (50.00) 59.00 1,550.00 (1,491.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 100.00 (100.00) 2,695.38 4,200.00 (1,504.62) 4,200.00 1,504.62 35.8%6319206 Licenses & Permits - - - 2,275.00 1,430.00 845.00 1,430.00 (845.00) -59.1%6319490 Miscellaneous 313.20 100.00 213.20 2,389.06 1,200.00 1,189.06 1,200.00 (1,189.06) -99.1%6319718 Safety Equipment & Training 389.86 100.00 289.86 3,509.14 3,850.00 (340.86) 3,850.00 340.86 8.9%6319822 Uniforms 432.27 920.00 (487.73) 11,744.10 11,040.00 704.10 11,040.00 (704.10) -6.4%Total-CM-OTHER EXPENSES 2,355.33 2,394.00 (38.67) 43,372.32 40,098.00 3,274.32 40,098.00 (3,274.32) -8.2%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJune 2012Annual Budget4 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,958.24 2,648.00 310.24 29,513.33 31,776.00 (2,262.67) 31,776.00 2,262.67 7.1%6321325 Insurance-Workers Comp 640.93 531.00 109.93 6,020.32 6,517.00 (496.68) 6,543.00 522.68 8.0%6321800 Taxes-Employer Payroll 1,479.93 1,585.00 (105.07) 15,898.45 18,417.00 (2,518.55) 18,416.00 2,517.55 13.7%6321880 Wages-Hourly 12,597.47 12,880.00 (282.53) 152,185.84 154,560.00 (2,374.16) 154,560.00 2,374.16 1.5%6321882 Wages-Overtime 9.94 966.00 (956.06) 2,499.95 6,279.00 (3,779.05) 6,279.00 3,779.05 60.2%Total-CM-LM-SALARIES & BENEFITS17,686.51 18,610.00 (923.49) 206,117.89 217,549.00 (11,431.11) 217,574.00 11,456.11 5.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 224.72 1,025.00 (800.28) 1,025.00 800.28 78.1%6323788 Uniforms 107.80 290.00 (182.20) 2,724.17 3,480.00 (755.83) 3,480.00 755.83 21.7%Total-CM-LM-SUPPLIES & MATERIALS107.80 365.00 (257.20) 2,948.89 4,505.00 (1,556.11) 4,505.00 1,556.11 34.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) 1,598.50 4,250.00 (2,651.50) 4,250.00 2,651.50 62.4%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) 1,598.50 4,250.00 (2,651.50) 4,250.00 2,651.50 62.4%127,359.03 116,084.00 11,275.03 1,686,920.55 1,638,852.00 48,068.55 1,638,879.00 (48,041.55) -2.9% June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 15,689.50 21,530.00 (5,840.50) 157,853.13 227,391.00 (69,537.87) 227,391.00 69,537.87 30.6%6337842 Utilities-Water6,927.02 6,510.00 417.02 53,250.05 43,058.00 10,192.05 43,058.00 (10,192.05) -23.7%22,616.52 28,040.00 (5,423.48) 211,103.18 270,449.00 (59,345.82) 270,449.00 59,345.82 21.9%Silverrock ResortCourse Maintenance Expense StatementJune 2012Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyJune 2012Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 369.78 662.00 (292.22) 5,104.08 7,944.00 (2,839.92) 7,944.00 2,839.92 35.7%6411325 Insurance-Workers Comp 401.15 367.00 34.15 4,520.50 5,096.00 (575.50) 5,096.00 575.50 11.3%6411800 Taxes-Employer Payroll 1,541.84 1,109.00 432.84 17,651.56 15,399.00 2,252.56 15,399.00 (2,252.56) -14.6%6411880 Wages-Hourly 10,934.01 8,910.00 2,024.01 130,394.93 123,689.00 6,705.93 123,689.00 (6,705.93) -5.4%6411882 Wages-Overtime 116.62 - 116.62 1,808.82 - 1,808.82 - (1,808.82) 0.0%Total-CBR-SALARIES & BENEFITS13,363.40 11,048.00 2,315.40 159,479.89 152,128.00 7,351.89 152,128.00 (7,351.89) -4.8%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 17.83 50.00 (32.17) 1,227.75 2,350.00 (1,122.25) 2,350.00 1,122.25 47.8%6413742 Supplies-Expendable 724.08 500.00 224.08 10,107.67 6,750.00 3,357.67 6,750.00 (3,357.67) -49.7%6413752 Supplies-Range Balls - - - 7,745.85 9,000.00 (1,254.15) 9,000.00 1,254.15 13.9%6413762 Supplies-Office - 50.00 (50.00) - 525.00 (525.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 70.40 420.00 (349.60) 420.00 349.60 83.2%6413786 Supplies-Towels 320.00 72.00 248.00 3,840.00 1,005.00 2,835.00 1,005.00 (2,835.00) -282.1%6413796 Supplies-Bottled Water5,664.96 12,000.00 (6,335.04) 17,807.99 24,500.00 (6,692.01) 24,500.00 6,692.01 27.3%Total-CBR-SUPPLIES & MATERIALS6,726.87 12,742.00 (6,015.13) 40,799.66 44,550.00 (3,750.34) 44,550.00 3,750.34 8.4%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 100.01 300.00 (199.99) 4,003.65 3,600.00 403.65 3,600.00 (403.65) -11.2%6415695 CBR-R&M-Cart Maintenance & Repair 89.61 750.00 (660.39) 5,245.09 9,750.00 (4,504.91) 9,750.00 4,504.91 46.2%Total-CBR-REPAIRS & MAINTENANCE 189.62 1,050.00 (860.38) 9,248.74 13,350.00 (4,101.26) 13,350.00 4,101.26 30.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 671.46 800.00 (128.54) 9,189.23 9,600.00 (410.77) 9,600.00 410.77 4.3%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous 129.72 125.00 4.72 766.83 1,150.00 (383.17) 1,150.00 383.17 33.3%6419820 Uniforms - 200.00 (200.00) 3,609.50 5,200.00 (1,590.50) 5,200.00 1,590.50 30.6%Total-CBR-OTHER EXPENSES 801.18 1,125.00 (323.82) 13,565.56 16,400.00 (2,834.44) 16,400.00 2,834.44 17.3%TOTAL-CARTS,BAGROOM & RANGE 21,081.07 25,965.00 (4,883.93) 223,093.85 226,428.00 (3,334.15) 226,428.00 3,334.15 1.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 84.00 274.70 3,526.84 1,805.00 1,721.84 1,805.00 (1,721.84) -95.4%6431800 Taxes-Employer Payroll 503.39 234.00 269.39 6,925.80 5,015.00 1,910.80 5,015.00 (1,910.80) -38.1%6431880 Wages-Hourly 3,666.00 2,040.00 1,626.00 49,872.00 43,800.00 6,072.00 43,800.00 (6,072.00) -13.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,528.09 2,358.00 2,170.09 60,324.64 50,620.00 9,704.64 50,620.00 (9,704.64) -19.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 75.00 (75.00) 1,078.29 1,050.00 28.29 1,050.00 (28.29) -2.7%6439490 Miscellaneous 254.19 - 254.19 2,407.91 200.00 2,207.91 200.00 (2,207.91) -1104.0%6439718 Safety Equipment & Training - 50.00 (50.00) 91.59 600.00 (508.41) 600.00 508.41 84.7%6439820 Uniforms 260.22 75.00 185.22 1,930.63 2,125.00 (194.37) 2,125.00 194.37 9.1%Total-CS-OTHER EXPENSES 514.41 200.00 314.41 5,508.42 3,975.00 1,533.42 3,975.00 (1,533.42) -38.6%Total-COURSE SERVICES 5,042.50 2,558.00 2,484.50 65,833.06 54,595.00 11,238.06 54,595.00 (11,238.06) -20.6%26,123.57 28,523.00 (2,399.43) 288,926.91 281,023.00 7,903.91 281,023.00 (6,370.49) -2.3%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJune 2012Annual Budget6 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable124.60 400.00 (275.40) 1,992.39 4,800.00 (2,807.61) 4,800.00 2,807.61 58.5%Total-CH-SUPPLIES & MATERIALS 124.60 400.00 (275.40) 1,992.39 4,800.00 (2,807.61) 4,800.00 2,807.61 58.5%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) 4,030.13 3,600.00 430.13 3,600.00 (430.13) -11.9%6507840 Utilities-Telephone1,144.20 1,150.00 (5.80) 13,523.30 13,800.00 (276.70) 13,800.00 276.70 2.0%6507842 Utilities-Water550.79 321.00 229.79 4,855.97 3,852.00 1,003.97 3,852.00 (1,003.97) -26.1%6507844 Utilities-Cable134.95 340.00 (205.05) 3,840.84 4,080.00 (239.16) 4,080.00 239.16 5.9%Total-CH-UTILITIES 1,829.94 2,111.00 (281.06) 26,250.24 25,332.00 918.24 25,332.00 (918.24) -3.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning75.00 1,825.00 (1,750.00) 16,650.00 22,500.00 (5,850.00) 22,500.00 5,850.00 26.0%6509099 Contract Services-Security6,828.88 4,900.00 1,928.88 67,505.04 60,400.00 7,105.04 60,400.00 (7,105.04) -11.8%6509215 Flowers & Decorations- 400.00 (400.00) - 2,400.00 (2,400.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous2,481.48 200.00 2,281.48 3,228.37 2,400.00 828.37 2,400.00 (828.37) -34.5%6509718 Safety Equipment & Training- 100.00 (100.00) 127.19 1,200.00 (1,072.81) 1,200.00 1,072.81 89.4%Total-CH-OTHER EXPENSES 9,385.36 7,425.00 1,960.36 87,510.60 88,900.00 (1,389.40) 88,900.00 1,389.40 1.6%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures520.67 300.00 220.67 7,015.07 3,600.00 3,415.07 3,600.00 (3,415.07) -94.9%6515686 CH-R&M-Restaurant Repairs17.20 400.00 (382.80) 1,363.21 4,800.00 (3,436.79) 4,800.00 3,436.79 71.6%6515690 CH-R&M-Equipment Repair2,075.00 400.00 1,675.00 4,962.93 4,800.00 162.93 4,800.00 (162.93) -3.4%Total-CH-REPAIRS & MAINTENANCE 2,612.87 1,100.00 1,512.87 13,341.21 13,200.00 141.21 13,200.00 (141.21) -1.1%13,952.77 11,036.00 2,916.77 129,094.44 132,232.00 (3,137.56) 132,232.00 (282.42) -0.2%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJune 2012Annual Budget7 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 3,907.38 3,972.00 (64.62) 3,972.00 64.62 1.6%6601325 Insurance-Workers Comp 180.55 103.00 77.55 1,952.58 1,236.00 716.58 1,240.00 (712.58) -57.5%6601720 Salaries 2,230.98 2,508.00 (277.02) 26,934.52 30,096.00 (3,161.48) 30,096.00 3,161.48 10.5%6601800 Taxes-Employer Payroll 229.74 287.00 (57.26) 3,166.25 3,444.00 (277.75) 3,446.00 279.75 8.1%Total-MKT-SALARIES & BENEFITS 3,011.05 3,229.00 (217.95) 35,960.73 38,748.00 (2,787.27) 38,754.00 2,793.27 7.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 70.26 100.00 (29.74) 576.29 1,200.00 (623.71) 1,200.00 623.71 52.0%6603768 Supplies-Printing & Stationery 62.97 125.00 (62.03) 8,276.35 4,425.00 3,851.35 4,425.00 (3,851.35) -87.0%133.23 225.00 (91.77) 8,852.64 5,625.00 3,227.64 5,625.00 (3,227.64) -57.4%66-MKT-UTILITIES6607840 Utilities-Telephone 105.66 100.00 5.66 1,077.22 1,200.00 (122.78) 1,200.00 122.78 10.2%Total-MKT-UTILITIES 105.66 100.00 5.66 1,077.22 1,200.00 (122.78) 1,200.00 122.78 10.2%66-MKT-OTHER EXPENSES6609010 Advertising 15,838.67 5,562.00 10,276.67 175,394.74 185,731.00 (10,336.26) 185,731.00 10,336.26 5.6%6609040 Business Meals - 25.00 (25.00) - 300.00 (300.00) 300.00 300.00 100.0%6609080 Collateral Material 1,735.97 500.00 1,235.97 9,433.96 9,000.00 433.96 9,000.00 (433.96) -4.8%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,188.00 4,800.00 (3,612.00) 4,800.00 3,612.00 75.3%6609490 Miscellaneous - - - 143.29 350.00 (206.71) 350.00 206.71 59.1%6609620 Postage - 50.00 (50.00) 430.86 600.00 (169.14) 600.00 169.14 28.2%6609630 Promotion 90.00 50.00 40.00 482.01 700.00 (217.99) 3,500.00 3,017.99 0.0%6609633 Promotion-Community - 75.00 (75.00) 289.78 2,925.00 (2,635.22) 2,925.00 2,635.22 90.1%6609634 Promotion-Media/Vendor - - - 968.35 3,500.00 (2,531.65) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 368.08 735.00 (366.92) 735.00 366.92 49.9%6609820 Uniforms - - - 922.34 600.00 322.34 600.00 (322.34) -53.7%Total-MKT-OTHER EXPENSES 17,763.64 6,662.00 11,101.64 189,621.41 209,241.00 (19,619.59) 209,241.00 19,887.94 9.5%21,013.58 10,216.00 10,797.58 235,512.00 254,814.00 (19,302.00) 254,820.00 19,576.35 7.7%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJune 2012Annual Budget8 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.11 1,458.00 344.11 25,857.20 17,496.00 8,361.20 17,496.00 (8,361.20) -47.8%6701325 Insurance-Workers Comp602.40 707.00 (104.60) 6,759.92 8,484.00 (1,724.08) 8,480.00 1,720.08 20.3%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 171,281.09 178,000.08 (6,718.99) 178,000.00 6,718.91 3.8%6701800 Taxes-Employer Payroll 1,764.63 1,964.00 (199.37) 16,757.84 23,568.00 (6,810.16) 23,568.00 6,810.16 28.9%6701880 Wages-Hourly2,207.89 2,319.66 (111.77) 24,313.12 27,835.92 (3,522.80) 27,835.00 3,521.88 12.7%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 19,793.29 21,282.00 (1,488.71) 244,980.05 255,384.00 (10,403.95) 255,379.00 10,398.95 4.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 2,921.99 5,200.00 (2,278.01) 5,200.00 2,278.01 43.8%6703762 Supplies-Office - 100.00 (100.00) 1,055.62 1,200.00 (144.38) 1,200.00 144.38 12.0%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 765.62 3,300.00 (2,534.38) 3,300.00 2,534.38 76.8%Total-G&A-SUPPLIES & MATERIALS - 1,300.00 (1,300.00) 4,743.23 9,700.00 (4,956.77) 9,700.00 4,956.77 51.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment1,570.00 100.00 1,470.00 1,798.47 1,100.00 698.47 1,100.00 (698.47) -63.5%Total-G&A-REPAIRS & MAINTENANCE 1,570.00 100.00 1,470.00 1,798.47 1,100.00 698.47 1,100.00 (698.47) -63.5%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%6709150 Dues & Subscriptions796.00 50.00 746.00 1,287.17 1,700.00 (412.83) 1,700.00 412.83 24.3%6709180 Employee Recruiting/Relocation90.00 - 90.00 1,003.35 1,400.00 (396.65) 1,400.00 396.65 28.3%6709197 Equipment Rental808.05 480.00 328.05 7,507.86 5,760.00 1,747.86 5,760.00 (1,747.86) -30.3%6709202 Fees-Bank63.34 90.00 (26.66) 928.23 1,080.00 (151.77) 1,080.00 151.77 14.1%6709208 Fees-Payroll Processing1,143.32 1,100.00 43.32 13,452.71 13,200.00 252.71 13,200.00 (252.71) -1.9%6709220 Freight/Delivery- 50.00 (50.00) - 600.00 (600.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 576.48 1,200.00 (623.52) 1,200.00 623.52 52.0%6709620 Postage/Mail Services 49.00 75.00 (26.00) 1,058.21 900.00 158.21 900.00 (158.21) -17.6%6709625 Professional Fees790.32 850.00 (59.68) 10,826.80 10,200.00 626.80 10,200.00 (626.80) -6.1%6709636 Promotion/Entertainment- 100.00 (100.00) 3,000.00 3,100.00 (100.00) 3,100.00 100.00 3.2%6709722 Seminars & Training250.00 200.00 50.00 1,598.61 2,400.00 (801.39) 2,400.00 801.39 33.4%6709810 Travel - 200.00 (200.00) 224.38 1,100.00 (875.62) 1,100.00 875.62 79.6%6709820 Uniforms 249.67 75.00 174.67 1,375.31 1,050.00 325.31 1,050.00 (325.31) -31.0%Total-G&A-OTHER EXPENSES 4,639.70 3,770.00 869.70 47,639.11 48,490.00 (850.89) 48,490.00 850.89 1.8%26,002.99 26,452.00 (449.01) 299,160.86 314,674.00 (15,513.14) 314,669.00 15,508.14 4.9%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJune 2012Annual Budget9 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 138,479.08 144,900.00 (6,420.92) 144,900.00 6,420.92 4.4%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 6,058.94 7,200.00 (1,141.06) 7,200.00 1,141.06 15.8%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 66,032.02 69,060.00 (3,027.98) 69,060.00 3,027.98 4.4%6800197 Equipment Leases-Others 6,099.62 1,160.00 4,939.62 26,093.56 13,920.00 12,173.56 13,920.00 (12,173.56) 0.0%22,633.79 19,590.00 3,043.79 236,663.60 235,080.00 1,583.60 235,080.00 (1,583.60) -0.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 16,035.16 18,818.00 (2,782.84) 90,000.00 89,999.00 1.00 90,000.00 - 0.0%6900210 FF&E Reserve 2,580.57 3,086.00 (505.43) 66,100.03 66,541.00 (440.97) 66,540.00 439.97 0.7%6900800 Personal Property Taxes 382.85 - 382.85 15,033.87 14,800.00 233.87 14,800.00 (233.87) -1.6%6900323 Insurance-Commercial 4,542.33 2,200.00 2,342.33 31,191.39 26,400.00 4,791.39 26,400.00 (4,791.39) -18.1%23,540.91 24,104.00 (563.09) 202,325.29 197,740.00 4,585.29 197,740.00 (4,585.29) -2.3%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementJune 2012Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia51 145Sales4Promotion36Golf Industry6VIPCelebrityPGA Comp64 60 50 5 38 29Charity/Gift Certificate214 430Rain/Wind Checks321 13Club Staff65 62 91 8 66 71LQ HS Golf2 4 12 11 34141 136 162 14 136 2052012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia566231Sales2Promotion11341Golf Industry4VIPCelebrity2PGA Comp37 1055337 74 28Charity/Gift Certificate823420 10 2Rain/Wind Checks413713Club Staff150 926659 81 116LQ HS Golf48 177 199 197 29 7255 420 345 322 211 15611 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012June 2012 Date Time Description CategoryPlayers6/6/2012 9:22 Julius Kazen / CVA Sales 26/6/2012 11:15 Kris Long Promo 112