Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01 July 2011 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2011 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 July Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue97,534.25 90,531.00 7,003.25 7.7% 97,534.25 90,531.00 7,003.25 3,326,982.00 3,229,447.75 3%401000 Miscellaneous Golf Revenue 5,806.40 7,250.00 (1,443.60) -19.9% 5,806.40 7,250.00 (1,443.60) 146,537.00 140,730.60 4%410000 Revenue-Golf Shop 11,060.58 8,500.00 2,560.58 30.1% 11,060.58 8,500.00 2,560.58 310,919.00 299,858.42 4%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income5.75 - 5.75 0.0% 5.75 - 5.75 - (5.75) 0%Total Income114,906.98 106,781.00 8,125.98 7.6% 114,906.98 106,781.00 8,125.98 3,796,438.00 3,681,531.02 3%Cost of Goods Sold510000 COS-Golf Shop 5,744.74 4,511.00 1,233.74 -27.3% 5,744.74 4,511.00 (1,233.74) 165,020.45 159,275.71 3%Total COS5,744.74 4,511.00 1,233.74 -27.3% 5,744.74 4,511.00 (1,233.74) 165,020.45 159,275.71 3%Gross Profit109,162.24 102,270.00 6,892.24 6.7% 109,162.24 102,270.00 6,892.24 3,631,417.55 3,522,255.31 3%Expenses610000 Golf Pro Shop 13,468.83 17,005.00 3,536.17 20.8% 13,468.83 17,005.00 3,536.17 223,325.00 209,856.17 6%630000 Course Maintenance115,166.01 124,391.00 9,224.99 7.4% 115,166.01 124,391.00 9,224.99 1,638,879.00 1,523,712.99 7%633000 Maintenance Water & Energy27,066.88 26,025.00 (1,041.88) -4.0% 27,066.88 26,025.00 (1,041.88) 270,449.00 243,382.12 10%640000 Outside Services17,256.13 14,668.00 (2,588.13) -17.6% 17,256.13 14,668.00 (2,588.13) 281,023.00 263,766.87 6%650000 Clubhouse 10,573.17 10,636.00 62.83 0.6% 10,573.17 10,636.00 62.83 132,232.00 121,658.83 8%660000 Marketing 11,834.46 12,151.00 316.54 2.6% 11,834.46 12,151.00 316.54 254,820.00 242,985.54 5%670000 General & Administrative24,516.93 25,452.00 935.07 3.7% 24,516.93 25,452.00 935.07 314,669.00 290,152.07 8%680000 Leases 20,046.59 19,590.00 (456.59) -2.3% 20,046.59 19,590.00 (456.59) 235,080.00 215,033.41 9%690000 Miscellaneous Other Expense26,506.54 30,432.00 3,925.46 12.9% 26,506.54 30,432.00 3,925.46 197,740.00 171,233.46 13%Total Expenses266,435.54 280,350.00 13,914.46 5.0% 266,435.54 280,350.00 13,914.46 3,548,217.00 3,281,781.46 8%(157,273.30) (178,080.00) 20,806.70 11.7%(157,273.30) (178,080.00) 20,806.70 83,200.55 240,473.85 -189%Rounds of Golf PlayedPaid Rounds Played 2,753 2,500 253 10.1% 2,753 2,500 253 39,150 36,397 7%Ave $ Per Paid Round Green Fee35.43 36.21 (0.78) -2.2% 35.43 36.21 (0.78) 76.13 40.70 47%Ave $ Per Paid Round Merchandise4.02 3.40 0.62 18.2% 4.02 3.40 0.62 8.07 4.05 50%Ave $ Per Paid Miscellaneous 2.11 2.90 (0.79) -27.3% 2.11 2.90 (0.79) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJuly 20111 Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 97,534.25 90,531.00 7,003.25 97,534.25 90,531.00 7,003.25 3,326,982.003,229,447.753%4010000 Rider Fee 1,925.00 250.00 1,675.00 1,925.00 250.00 1,675.00 7,446.005,521.0026%4040000 Club Rental 1,105.00 1,250.00 (145.00) 1,105.00 1,250.00 (145.00) 22,813.0021,708.005%4050000 Driving Range 1,962.00 3,750.00 (1,788.00) 1,962.00 3,750.00 (1,788.00) 73,278.0071,316.003%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract 814.40 1,000.00 (185.60) 814.40 1,000.00 (185.60) 4,000.00 3,185.6020%4091000 Golf Professional Rental Fee - - - - - - 27,000.00 27,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 103,340.65 97,781.00 5,559.65 103,340.65 97,781.00 5,559.65 3,473,519.00 3,370,178.35 3%103,340.65 97,781.00 5,559.65 103,340.65 97,781.00 5,559.65 3,473,519.00 3,370,178.35 3%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueJuly 20112 Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 366.00 - 366.00 366.00 - 366.00 0 0 0%4100110 Sales Hard Goods 5,380.71 2,975.00 2,405.71 5,380.71 2,975.00 2,405.71 108,822.00 103,441.29 5%4100112 Sales-Soft Goods 6,778.66 5,525.00 1,253.66 6,778.66 5,525.00 1,253.66 202,097.00 195,318.34 3%5100639 GS-Discounts-Mdse (1,464.79) - (1,464.79) (1,464.79) - (1,464.79) - 1,464.79 0% Total Revenue Golf Shop 11,060.58 8,500.00 2,560.58 11,060.58 8,500.00 2,560.58 310,919.00 300,224.42 3%COS 5100150 COS-GS-Hard Goods 2,553.54 1,636.25 917.29 2,553.54 1,636.25 917.29 59,852.10 57,298.56 4%5100151 COS-GS-Soft Goods 3,191.20 3,038.75 152.45 3,191.20 3,038.75 152.45 111,153.35 107,962.15 3%5100152 COS-GS-Purchase Disc - (234.00) 234.00 - (234.00) 234.00 (8,550.00) (8,550.00) 0%5100220 COS-GS-Freight Merch - 70.00 (70.00) - 70.00 (70.00) 2,565.00 2,565.00 0%Cost of Sales - Golf Shop 5,744.74 4,511.00 1,233.74 5,744.74 4,511.00 1,233.74 165,020.45 159,275.71 3%Gross Profit 5,315.84 3,989.00 1,326.84 5,315.84 3,989.00 1,326.84 145,898.55 140,948.71 3%COS % 51.9% 53.1% 1.1% 51.9% 53.1% 1.1% 53.1% 53.1% 0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,607.66 1,986.00 621.66 2,607.66 1,986.00 621.66 26,811.00 24,203.34 10%6101325 Insurance-Workers Comp 441.74 448.00 (6.26) 441.74 448.00 (6.26) 6,131.00 5,689.26 7%6101720 Salaries 3,781.83 3,750.00 31.83 3,781.83 3,750.00 31.83 45,000.00 41,218.17 8%6101800 Taxes-Employer Payroll 745.91 1,244.00 (498.09) 745.91 1,244.00 (498.09) 17,040.00 16,294.09 4%6101880 Wages-Hourly 5,089.85 7,117.00 (2,027.15) 5,089.85 7,117.00 (2,027.15) 103,818.00 98,728.15 5%6101882 Wages-Overtime 73.55 - 73.55 73.55 - 73.55 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,740.54 14,545.00 (1,804.46) 12,740.54 14,545.00 (1,804.46) 198,800.00 187,085.89 6%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 59.69 500.00 (440.31) 59.69 500.00 (440.31) 6,000.00 5,940.31 1%6109090 Contract Services 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 8%6109220 Freight & Delivery 18.29 - 18.29 18.29 - 18.29 75.00 56.71 24%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 37.74 - 37.74 37.74 - 37.74 - (37.74) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) - 1,250.00 (1,250.00) 5,890.00 5,890.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) - 100.00 (100.00) 2,400.00 2,400.00 0%6117840 Telephones 112.57 110.00 2.57 112.57 110.00 2.57 1,320.00 1,207.43 0%Total PS-OTHER EXPENSES 728.29 2,460.00 (1,731.71) 728.29 2,460.00 (1,731.71) 24,525.00 23,796.71 3%13,468.83 17,005.00 (3,536.17) 13,468.83 17,005.00 (3,536.17) 223,325.00 210,882.60 6%Net Income(8,152.99) (13,016.00) 4,863.01 (8,152.99) (13,016.00) 4,863.01 (77,426.45) (69,933.89) -10%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJuly 20113 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 7,571.62 8,740.00 (1,168.38) 7,571.62 8,740.00 (1,168.38) 104,880.00 97,308.38 92.8%6311325 Insurance-Workers Comp 1,824.54 2,268.00 (443.46) 1,824.54 2,268.00 (443.46) 28,026.00 26,201.46 93.5%6311720 Salaries 11,735.04 12,583.00 (847.96) 11,735.04 12,583.00 (847.96) 150,996.00 139,260.96 92.2%6311800 Taxes-Employer Payroll 4,780.31 6,304.00 (1,523.69) 4,780.31 6,304.00 (1,523.69) 78,501.00 73,720.69 93.9%6311880 Wages-Hourly 43,167.63 42,473.00 694.63 43,167.63 42,473.00 694.63 518,654.00 475,486.37 91.7%6311882 Wages-Overtime 151.93 - 151.93 151.93 - 151.93 15,945.00 15,793.07 99.0%Total-CM-SALARIES & BENEFITS69,231.07 72,368.00 (3,136.93) 69,231.07 72,368.00 (3,136.93) 897,002.00 827,770.93 92.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,862.81 3,500.00 (637.19) 2,862.81 3,500.00 (637.19) 29,300.00 26,437.19 90.2%6313744 Fertilizer 9,377.06 8,400.00 977.06 9,377.06 8,400.00 977.06 104,400.00 95,022.94 91.0%6313745 Herbicides - - - - - - 17,000.00 17,000.00 100.0%6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 5,253.51 4,200.00 1,053.51 5,253.51 4,200.00 1,053.51 48,800.00 43,546.49 89.2%6313750 Golf Course Accessories 123.91 200.00 (76.09) 123.91 200.00 (76.09) 12,300.00 12,176.09 99.0%6313756 POA Control - - - - - - 7,000.00 7,000.00 100.0%6313758 Miscellaneous Supp 849.09 750.00 99.09 849.09 750.00 99.09 4,350.00 3,500.91 0.0%6313762 Supplies-Office - - - - - - - - 0.0%6313774 Sand - 390.00 (390.00) - 390.00 (390.00) 16,460.00 16,460.00 100.0%6313776 Seed 282.84 350.00 (67.16) 282.84 350.00 (67.16) 106,810.00 106,527.16 99.7%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) - 100.00 (100.00) 5,000.00 5,000.00 100.0%6313780 Sod 1,160.83 1,000.00 160.83 1,160.83 1,000.00 160.83 6,350.00 5,189.17 81.7%6313782 Topdressing 1,161.12 1,250.00 (88.88) 1,161.12 1,250.00 (88.88) 7,600.00 6,438.88 84.7%Total-CM-SUPPLIES & MATERIALS21,071.17 20,140.00 931.17 21,071.17 20,140.00 931.17 368,420.00 347,348.83 94.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 2,830.00 2,600.00 230.00 31,200.00 28,370.00 90.9%6315685 CM-R&M-Bldngs & Othr Structures 132.50 250.00 (117.50) 132.50 250.00 (117.50) 1,750.00 1,617.50 92.4%6315690 CM-R&M-Equipment 3,285.72 1,000.00 2,285.72 3,285.72 1,000.00 2,285.72 20,500.00 17,214.28 84.0%6315692 CM-R&M-Irrigation System 2,891.76 5,400.00 (2,508.24) 2,891.76 5,400.00 (2,508.24) 22,650.00 19,758.24 87.2%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 10,500.00 10,500.00 100.0%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 9,139.98 10,250.00 (1,110.02) 9,139.98 10,250.00 (1,110.02) 96,650.00 87,510.02 90.5%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 23.80 15.00 8.80 23.80 15.00 8.80 180.00 156.20 0.0%6317840 Telephones 1,026.05 850.00 176.05 1,026.05 850.00 176.05 10,200.00 9,173.95 89.9%Total-CM-UTILITIES 1,049.85 865.00 184.85 1,049.85 865.00 184.85 10,380.00 9,330.15 89.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal 536.65 524.00 12.65 536.65 524.00 12.65 6,288.00 5,751.35 0.0%6319150 Dues & Subscriptions - - - - - - 540.00 540.00 100.0%6319170 Employee Education - 50.00 (50.00) - 50.00 (50.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 200.00 (200.00) - 200.00 (200.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits - 100.00 (100.00) - 100.00 (100.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training 81.40 200.00 (118.60) 81.40 200.00 (118.60) 3,850.00 3,768.60 97.9%6319822 Uniforms 756.64 920.00 (163.36) 756.64 920.00 (163.36) 11,040.00 10,283.36 93.1%Total-CM-OTHER EXPENSES 1,874.69 2,594.00 (719.31) 1,874.69 2,594.00 (719.31) 40,098.00 38,223.31 95.3%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2011Annual Budget4 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,615.33 2,648.00 (1,032.67) 1,615.33 2,648.00 (1,032.67) 31,776.00 30,160.67 94.9%6321325 Insurance-Workers Comp 368.90 531.00 (162.10) 368.90 531.00 (162.10) 6,543.00 6,174.10 94.4%6321800 Taxes-Employer Payroll 599.16 1,475.00 (875.84) 599.16 1,475.00 (875.84) 18,416.00 17,816.84 96.7%6321880 Wages-Hourly 10,058.50 12,880.00 (2,821.50) 10,058.50 12,880.00 (2,821.50) 154,560.00 144,501.50 93.5%6321882 Wages-Overtime 7.88 - 7.88 7.88 - 7.88 6,279.00 6,271.12 99.9%Total-CM-LM-SALARIES & BENEFITS12,649.77 17,534.00 (4,884.23) 12,649.77 17,534.00 (4,884.23) 217,574.00 204,924.23 94.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 100.00 (100.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 149.48 290.00 (140.52) 149.48 290.00 (140.52) 3,480.00 3,330.52 95.7%Total-CM-LM-SUPPLIES & MATERIALS149.48 390.00 (240.52) 149.48 390.00 (240.52) 4,505.00 4,355.52 96.7%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) - 250.00 (250.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) - 250.00 (250.00) 4,250.00 4,250.00 100.0%115,166.01 124,391.00 (9,224.99) 115,166.01 124,391.00 (9,224.99) 1,638,879.00 1,523,712.99 93.0% July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 20,997.77 21,065.00 (67.23) 20,997.77 21,065.00 (67.23) 227,391.00 206,393.23 90.8%6337842 Utilities-Water6,069.11 4,960.00 1,109.11 6,069.11 4,960.00 1,109.11 43,058.00 36,988.89 85.9%27,066.88 26,025.00 1,041.88 27,066.88 26,025.00 1,041.88 270,449.00 243,382.12 90.0%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyJuly 2011Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementJuly 2011Annual BudgetMonth to Date Year to Date5 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 446.57 662.00 (215.43) 446.57 662.00 (215.43) 7,944.00 7,497.43 94.4%6411325 Insurance-Workers Comp 392.19 316.00 76.19 392.19 316.00 76.19 5,096.00 4,703.81 92.3%6411800 Taxes-Employer Payroll 906.55 956.00 (49.45) 906.55 956.00 (49.45) 15,399.00 14,492.45 94.1%6411880 Wages-Hourly 7,869.38 7,682.00 187.38 7,869.38 7,682.00 187.38 123,689.00 115,819.62 93.6%6411882 Wages-Overtime 146.45 - 146.45 146.45 - 146.45 - (146.45) 0.0%Total-CBR-SALARIES & BENEFITS9,761.14 9,616.00 145.14 9,761.14 9,616.00 145.14 152,128.00 142,366.86 93.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 2,350.00 2,350.00 100.0%6413742 Supplies-Expendable 905.31 600.00 305.31 905.31 600.00 305.31 6,750.00 5,844.69 86.6%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office - 25.00 (25.00) - 25.00 (25.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 400.00 72.00 328.00 400.00 72.00 328.00 1,005.00 605.00 60.2%6413796 Supplies-Bottled Water110.00 50.00 60.00 110.00 50.00 60.00 24,500.00 24,390.00 99.6%Total-CBR-SUPPLIES & MATERIALS1,415.31 747.00 668.31 1,415.31 747.00 668.31 44,550.00 43,134.69 96.8%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 523.00 300.00 223.00 523.00 300.00 223.00 3,600.00 3,077.00 85.5%6415695 CBR-R&M-Cart Maintenance & Repair 489.91 750.00 (260.09) 489.91 750.00 (260.09) 9,750.00 9,260.09 95.0%Total-CBR-REPAIRS & MAINTENANCE 1,012.91 1,050.00 (37.09) 1,012.91 1,050.00 (37.09) 13,350.00 12,337.09 92.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,445.55 800.00 645.55 1,445.55 800.00 645.55 9,600.00 8,154.45 84.9%6419220 Freight/Delivery - 75.00 (75.00) - 75.00 (75.00) 450.00 450.00 100.0%6419490 Miscellaneous 238.30 125.00 113.30 238.30 125.00 113.30 1,150.00 911.70 79.3%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES 1,683.85 1,000.00 683.85 1,683.85 1,000.00 683.85 16,400.00 14,716.15 89.7%TOTAL-CARTS,BAGROOM & RANGE 13,873.21 12,413.00 1,460.21 13,873.21 12,413.00 1,460.21 226,428.00 212,554.79 93.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 258.70 74.00 184.70 258.70 74.00 184.70 1,805.00 1,546.30 85.7%6431800 Taxes-Employer Payroll 397.42 206.00 191.42 397.42 206.00 191.42 5,015.00 4,617.58 92.1%6431880 Wages-Hourly 2,726.80 1,800.00 926.80 2,726.80 1,800.00 926.80 43,800.00 41,073.20 93.8%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,382.92 2,080.00 1,302.92 3,382.92 2,080.00 1,302.92 50,620.00 47,237.08 93.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) - 50.00 (50.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 75.00 (75.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES - 175.00 (175.00) - 175.00 (175.00) 3,975.00 3,975.00 100.0%Total-COURSE SERVICES 3,382.92 2,255.00 1,127.92 3,382.92 2,255.00 1,127.92 54,595.00 51,212.08 93.8%17,256.13 14,668.00 2,588.13 17,256.13 14,668.00 2,588.13 281,023.00 259,791.87 92.4%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJuly 2011Annual Budget6 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable29.95 400.00 (370.05) 29.95 400.00 (370.05) 4,800.00 4,770.05 99.4%Total-CH-SUPPLIES & MATERIALS 29.95 400.00 (370.05) 29.95 400.00 (370.05) 4,800.00 4,770.05 99.4%65-CH-UTILITIES6507836 Utilities-Natural Gas340.51 300.00 40.51 340.51 300.00 40.51 3,600.00 3,259.49 90.5%6507840 Utilities-Telephone1,123.72 1,150.00 (26.28) 1,123.72 1,150.00 (26.28) 13,800.00 12,676.28 91.9%6507842 Utilities-Water488.09 321.00 167.09 488.09 321.00 167.09 3,852.00 3,363.91 87.3%6507844 Utilities-Cable336.89 340.00 (3.11) 336.89 340.00 (3.11) 4,080.00 3,743.11 91.7%Total-CH-UTILITIES 2,289.21 2,111.00 178.21 2,289.21 2,111.00 178.21 25,332.00 23,042.79 91.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 1,825.00 1,825.00 - 22,500.00 20,675.00 91.9%6509099 Contract Services-Security4,841.56 4,900.00 (58.44) 4,841.56 4,900.00 (58.44) 60,400.00 55,558.44 92.0%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.00 100.0%6509490 Miscellaneous421.00 200.00 221.00 421.00 200.00 221.00 2,400.00 1,979.00 82.5%6509718 Safety Equipment & Training- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 7,087.56 7,025.00 62.56 7,087.56 7,025.00 62.56 88,900.00 81,812.44 92.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures1,044.21 300.00 744.21 1,044.21 300.00 744.21 3,600.00 2,555.79 71.0%6515686 CH-R&M-Restaurant Repairs65.00 400.00 (335.00) 65.00 400.00 (335.00) 4,800.00 4,735.00 98.6%6515690 CH-R&M-Equipment Repair57.24 400.00 (342.76) 57.24 400.00 (342.76) 4,800.00 4,742.76 98.8%Total-CH-REPAIRS & MAINTENANCE 1,166.45 1,100.00 66.45 1,166.45 1,100.00 66.45 13,200.00 12,033.55 91.2%10,573.17 10,636.00 (62.83) 10,573.17 10,636.00 (62.83) 132,232.00 24,067.10 18.2%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJuly 2011Annual Budget7 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 151.26 331.00 (179.74) 151.26 331.00 (179.74) 3,972.00 3,820.74 96.2%6601325 Insurance-Workers Comp 174.88 103.00 71.88 174.88 103.00 71.88 1,240.00 1,065.12 85.9%6601720 Salaries 2,325.70 2,508.00 (182.30) 2,325.70 2,508.00 (182.30) 30,096.00 27,770.30 92.3%6601800 Taxes-Employer Payroll 216.39 287.00 (70.61) 216.39 287.00 (70.61) 3,446.00 3,229.61 93.7%Total-MKT-SALARIES & BENEFITS 2,868.23 3,229.00 (360.77) 2,868.23 3,229.00 (360.77) 38,754.00 35,885.77 92.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - - - - - - 4,425.00 4,425.00 100.0%- 100.00 (100.00) - 100.00 (100.00) 5,625.00 5,625.00 100.0%66-MKT-UTILITIES6607840 Utilities-Telephone 47.74 100.00 (52.26) 47.74 100.00 (52.26) 1,200.00 1,152.26 96.0%Total-MKT-UTILITIES 47.74 100.00 (52.26) 47.74 100.00 (52.26) 1,200.00 1,152.26 96.0%66-MKT-OTHER EXPENSES6609010 Advertising 8,819.49 8,172.00 647.49 8,819.49 8,172.00 647.49 185,731.00 176,911.51 95.3%6609040 Business Meals - 25.00 (25.00) - 25.00 (25.00) 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 99.00 400.00 (301.00) 4,800.00 4,701.00 97.9%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6609630 Promotion - - - - - - 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 75.00 (75.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - - - - - - 700.00 - 0.0%6609150 Dues and Subscriptions - - - - - - 735.00 735.00 100.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 8,918.49 8,722.00 196.49 8,918.49 8,722.00 196.49 209,241.00 199,622.51 95.4%11,834.46 12,151.00 (316.54) 11,834.46 12,151.00 (316.54) 254,820.00 242,285.54 95.1%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJuly 2011Annual Budget8 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,850.25 1,458.00 1,392.25 2,850.25 1,458.00 1,392.25 17,496.00 14,645.75 83.7%6701325 Insurance-Workers Comp588.76 707.00 (118.24) 588.76 707.00 (118.24) 8,480.00 7,891.24 93.1%6701720 Salaries 14,310.68 14,833.34 (522.66) 14,310.68 14,833.34 (522.66) 178,000.00 163,689.32 92.0%6701800 Taxes-Employer Payroll 1,281.66 1,964.00 (682.34) 1,281.66 1,964.00 (682.34) 23,568.00 22,286.34 94.6%6701880 Wages-Hourly2,420.95 2,319.66 101.29 2,420.95 2,319.66 101.29 27,835.00 25,414.05 91.3%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 21,452.30 21,282.00 170.30 21,452.30 21,282.00 170.30 255,379.00 233,926.70 91.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) - 400.00 (400.00) 5,200.00 5,200.00 100.0%6703762 Supplies-Office 71.62 100.00 (28.38) 71.62 100.00 (28.38) 1,200.00 1,128.38 94.0%6703768 Supplies-Printing & Stationery- 100.00 (100.00) - 100.00 (100.00) 3,300.00 3,300.00 100.0%Total-G&A-SUPPLIES & MATERIALS 71.62 600.00 (528.38) 71.62 600.00 (528.38) 9,700.00 9,628.38 99.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- - - - - - 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - - - - - - 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7%6709150 Dues & Subscriptions150.00 50.00 100.00 150.00 50.00 100.00 1,700.00 1,550.00 91.2%6709180 Employee Recruiting/Relocation56.00 - 56.00 56.00 - 56.00 1,400.00 1,344.00 96.0%6709197 Equipment Rental507.52 480.00 27.52 507.52 480.00 27.52 5,760.00 5,252.48 91.2%6709202 Fees-Bank141.99 90.00 51.99 141.99 90.00 51.99 1,080.00 938.01 86.9%6709208 Fees-Payroll Processing1,200.25 1,100.00 100.25 1,200.25 1,100.00 100.25 13,200.00 11,999.75 90.9%6709220 Freight/Delivery- 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6709620 Postage/Mail Services 98.00 75.00 23.00 98.00 75.00 23.00 900.00 802.00 89.1%6709625 Professional Fees439.25 850.00 (410.75) 439.25 850.00 (410.75) 10,200.00 9,760.75 95.7%6709636 Promotion/Entertainment- 100.00 (100.00) - 100.00 (100.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6709810 Travel - - - - - - 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) - 75.00 (75.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 2,993.01 3,570.00 (576.99) 2,993.01 3,570.00 (576.99) 48,490.00 45,496.99 93.8%24,516.93 25,452.00 (935.07) 24,516.93 25,452.00 (935.07) 314,669.00 290,152.07 92.2%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2011Annual Budget9 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 11,091.63 12,075.00 (983.37) 144,900.00 133,808.37 92.3%6800194 Equipment Leases-Trailer 531.00 600.00 (69.00) 531.00 600.00 (69.00) 7,200.00 6,669.00 92.6%6800196 Equipment Leases-GPS 5,290.50 5,755.00 (464.50) 5,290.50 5,755.00 (464.50) 69,060.00 63,769.50 92.3%6800197 Equipment Leases-Others 3,133.46 1,160.00 1,973.46 3,133.46 1,160.00 1,973.46 13,920.00 10,786.54 0.0%20,046.59 19,590.00 456.59 20,046.59 19,590.00 456.59 235,080.00 215,033.41 91.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 16,176.62 21,221.00 (5,044.38) 16,176.62 21,221.00 (5,044.38) 90,000.00 73,823.38 82.0%6900210 FF&E Reserve 1,950.69 1,811.00 139.69 1,950.69 1,811.00 139.69 66,540.00 64,589.31 97.1%6900800 Personal Property Taxes 5,784.13 5,200.00 584.13 5,784.13 5,200.00 584.13 14,800.00 9,015.87 60.9%6900323 Insurance-Commercial 2,595.10 2,200.00 395.10 2,595.10 2,200.00 395.10 26,400.00 23,804.90 90.2%26,506.54 30,432.00 (3,925.46) 26,506.54 30,432.00 (3,925.46) 197,740.00 171,233.46 86.6%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 201110 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia5SalesPromotionGolf IndustryVIPCelebrityPGA Comp64Charity/Gift Certificate2Rain/Wind Checks3Club Staff65LQ HS Golf2141000002012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012July 2011 Date Time Description CategoryPlayers7/9/2011 12:22 Kris Long Media 17/23/2011 12:00 Kris Long Media 412