Loading...
01 July 2010 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2010 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 Revenue 89,787.25 96,915.00 (7,127.75) -7.4% 89,787.25 96,915.00 (7,127.75) 3,111,458.00 3,021,670.75 3%401000 Miscellaneous Golf Revenue 4,550.00 9,254.00 (4,704.00) -50.8% 4,550.00 9,254.00 (4,704.00) 117,656.00 113,106.00 4%410000 Revenue-Golf Shop 8,361.55 9,100.00 (738.45) -8.1% 8,361.55 9,100.00 (738.45) 306,492.00 298,130.45 3%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income 3.84 - 3.84 0.0% 3.84 - 3.84 - (3.84) 0%Total Income103,202.64 115,769.00 (12,566.36) -10.9% 103,202.64 115,769.00 (12,566.36) 3,547,606.00 3,444,403.36 3%Cost of Goods Sold510000 COS-Golf Shop 4,866.29 4,830.00 36.29 -0.8% 4,866.29 4,830.00 (36.29) 162,670.60 157,804.31 3%Total COS4,866.29 4,830.00 36.29 -0.8% 4,866.29 4,830.00 (36.29) 162,670.60 157,804.31 3%Gross Profit98,336.35 110,939.00 (12,602.65) -11.4% 98,336.35 110,939.00 (12,602.65) 3,384,935.40 3,286,599.05 3%Expenses610000 Golf Pro Shop 15,633.97 17,474.00 1,840.03 10.5% 15,633.97 17,474.00 1,840.03 230,213.00 214,579.03 7%630000 Course Maintenance 119,196.50 118,457.00 (739.50) -0.6% 119,196.50 118,457.00 (739.50) 1,541,961.00 1,422,764.50 8%633000 Maintenance Water & Energy 8,455.72 9,460.00 1,004.28 10.6% 8,455.72 9,460.00 1,004.28 85,358.00 76,902.28 10%640000 Outside Services 14,916.02 17,606.00 2,689.98 15.3% 14,916.02 17,606.00 2,689.98 297,478.00 282,561.98 5%650000 Clubhouse 10,289.61 10,636.00 346.39 3.3% 10,289.61 10,636.00 346.39 132,232.00 121,942.39 8%660000 Marketing 16,875.06 12,351.00 (4,524.06) -36.6% 16,875.06 12,351.00 (4,524.06) 262,644.00 245,768.94 6%670000 General & Administrative23,361.45 25,464.00 2,102.55 8.3% 23,361.45 25,464.00 2,102.55 314,808.00 291,446.55 7%680000 Leases 18,776.88 20,817.00 2,040.12 9.8% 18,776.88 20,817.00 2,040.12 247,740.00 228,963.12 8%690000 Miscellaneous Other Expense 25,550.84 39,360.00 13,809.16 35.1% 25,550.84 39,360.00 13,809.16 192,199.00 166,648.16 13%Total Expenses253,056.05 271,625.00 18,568.95 6.8% 253,056.05 271,625.00 18,568.95 3,304,633.00 3,051,576.95 8%(154,719.70) (160,686.00) 5,966.30 3.7%(154,719.70) (160,686.00) 5,966.30 80,302.40 235,022.10 -193%Rounds of Golf PlayedPaid Rounds Played 2,596 2,600 (4) -0.2% 2,596 2,600 (4) 39,150 36,554 7%Ave $ Per Paid Round Green Fee 34.59 37.28 (2.69) -7.2% 34.59 37.28 (2.69) 76.13 41.54 45%Ave $ Per Paid Round Merchandise 3.22 3.50 (0.28) -8.0% 3.22 3.50 (0.28) 8.07 4.85 40%Ave $ Per Paid Miscellaneous 1.75 3.56 (1.81) -50.8% 1.75 3.56 (1.81) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJuly 20101 Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 89,787.25 96,915.00 (7,127.75) 89,787.25 96,915.00 (7,127.75) 3,111,458.003,021,670.753%4010000 Rider Fee 550.00 2,574.00 (2,024.00) 550.00 2,574.00 (2,024.00) 6,522.005,972.008%4040000 Club Rental 1,200.00 1,430.00 (230.00) 1,200.00 1,430.00 (230.00) 28,004.0026,804.004%4050000 Driving Range 1,725.00 3,250.00 (1,525.00) 1,725.00 3,250.00 (1,525.00) 48,130.0046,405.004%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 1,075.00 1,000.00 75.00 1,075.00 1,000.00 75.00 4,000.00 2,925.0027%4091000 Golf Professional Rental Fee - - - - - - 19,000.00 19,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 94,337.25 106,169.00 (11,831.75) 94,337.25 106,169.00 (11,831.75) 3,229,114.00 3,134,776.75 3%94,337.25 106,169.00 (11,831.75) 94,337.25 106,169.00 (11,831.75) 3,229,114.00 3,134,776.75 3%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueJuly 20102 Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 291.34 - 291.34 291.34 - 291.34 0 0 0%4100110 Sales Hard Goods 4,709.19 3,185.00 1,524.19 4,709.19 3,185.00 1,524.19 107,272.00 102,562.81 4%4100112 Sales-Soft Goods 4,347.50 5,915.00 (1,567.50) 4,347.50 5,915.00 (1,567.50) 199,220.00 194,872.50 2%5100639 GS-Discounts-Mdse (986.48) - (986.48) (986.48) - (986.48) - 986.48 0% Total Revenue Golf Shop 8,361.55 9,100.00 (738.45) 8,361.55 9,100.00 (738.45) 306,492.00 298,421.79 3%COS 5100150 COS-GS-Hard Goods 2,619.67 1,751.75 867.92 2,619.67 1,751.75 867.92 58,999.60 56,379.93 4%5100151 COS-GS-Soft Goods 2,202.48 3,253.25 (1,050.77) 2,202.48 3,253.25 (1,050.77) 109,571.00 107,368.52 2%5100152 COS-GS-Purchase Disc (58.45) (250.00) 191.55 (58.45) (250.00) 191.55 (8,429.00) (8,370.55) -1%5100220 COS-GS-Freight Merch 102.59 75.00 27.59 102.59 75.00 27.59 2,529.00 2,426.41 4%Cost of Sales - Golf Shop 4,866.29 4,830.00 36.29 4,866.29 4,830.00 36.29 162,670.60 157,804.31 3%Gross Profit 3,495.26 4,270.00 (774.74) 3,495.26 4,270.00 (774.74) 143,821.40 140,617.48 2%COS % 58.2% 53.1% -5.1% 58.2% 53.1% -5.1% 53.1% 52.9% 0%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 360.00 360.00 - 360.00 360.00 - 5,400.00 5,040.00 7%6101320 Insurance Group 2,339.92 1,986.00 353.92 2,339.92 1,986.00 353.92 26,811.00 24,471.08 9%6101325 Insurance-Workers Comp 387.88 448.00 (60.12) 387.88 448.00 (60.12) 6,131.00 5,743.12 6%6101720 Salaries 3,198.49 3,750.00 (551.51) 3,198.49 3,750.00 (551.51) 45,000.00 41,801.51 7%6101800 Taxes-Employer Payroll 766.40 1,353.00 (586.60) 766.40 1,353.00 (586.60) 18,528.00 17,761.60 4%6101880 Wages-Hourly 6,438.75 7,117.00 (678.25) 6,438.75 7,117.00 (678.25) 103,818.00 97,379.25 6%6101882 Wages-Overtime 59.78 - 59.78 59.78 - 59.78 - 952.88 0%Total -PS-SALARIES & BENEFITS 13,551.22 15,014.00 (1,462.78) 13,551.22 15,014.00 (1,462.78) 205,688.00 193,149.44 6%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 1,109.20 500.00 609.20 1,109.20 500.00 609.20 6,000.00 4,890.80 18%6109090 Contract Services 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 8%6109220 Freight & Delivery - - - - - - 75.00 75.00 0%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 48.26 - 48.26 48.26 - 48.26 - (48.26) 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 298.36 100.00 198.36 298.36 100.00 198.36 2,400.00 2,101.64 12%6117840 Telephones 126.93 110.00 16.93 126.93 110.00 16.93 1,320.00 1,193.07 0%Total PS-OTHER EXPENSES 2,082.75 2,460.00 (377.25) 2,082.75 2,460.00 (377.25) 24,525.00 22,442.25 8%15,633.97 17,474.00 (1,840.03) 15,633.97 17,474.00 (1,840.03) 230,213.00 215,591.69 6%Net Income(12,138.71) (13,204.00) 1,065.29 (12,138.71) (13,204.00) 1,065.29 (86,391.60) (74,974.21) -13%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJuly 20103 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 240.00 240.00 - 2,880.00 2,640.00 91.7%6311320 Insurance-Group 8,740.00 8,740.00 - 8,740.00 8,740.00 - 104,880.00 96,140.00 91.7%6311325 Insurance-Workers Comp 2,152.79 2,237.00 (84.21) 2,152.79 2,237.00 (84.21) 27,638.00 25,485.21 92.2%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,347.40 6,761.00 (2,413.60) 4,347.40 6,761.00 (2,413.60) 84,168.00 79,820.60 94.8%6311880 Wages-Hourly 41,884.29 41,725.00 159.29 41,884.29 41,725.00 159.29 509,458.00 467,573.71 91.8%6311882 Wages-Overtime 200.45 - 200.45 200.45 - 200.45 15,598.00 15,397.55 98.7%Total-CM-SALARIES & BENEFITS69,299.97 72,286.00 (2,986.03) 69,299.97 72,286.00 (2,986.03) 895,618.00 826,318.03 92.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,906.08 3,500.00 (593.92) 2,906.08 3,500.00 (593.92) 29,300.00 26,393.92 90.1%6313744 Fertilizer 7,617.26 8,400.00 (782.74) 7,617.26 8,400.00 (782.74) 89,400.00 81,782.74 91.5%6313745 Herbicides - - - - - - 12,000.00 12,000.00 100.0%6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 6,686.34 3,600.00 3,086.34 6,686.34 3,600.00 3,086.34 43,100.00 36,413.66 84.5%6313750 Golf Course Accessories 424.78 200.00 224.78 424.78 200.00 224.78 12,300.00 11,875.22 96.5%6313756 POA Control - - - - - - 7,000.00 7,000.00 100.0%6313758 Miscellaneous Supp 712.26 750.00 (37.74) 712.26 750.00 (37.74) 4,350.00 3,637.74 0.0%6313762 Supplies-Office 238.13 - 238.13 238.13 - 238.13 - (238.13) 0.0%6313774 Sand - 390.00 (390.00) - 390.00 (390.00) 11,460.00 11,460.00 100.0%6313775 Sand-Bunkers - - - - - - - - 0.0%6313776 Seed 3,181.02 350.00 2,831.02 3,181.02 350.00 2,831.02 91,810.00 88,628.98 96.5%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,000.00 (1,000.00) - 1,000.00 (1,000.00) 3,350.00 3,350.00 100.0%6313782 Topdressing 4,149.94 1,250.00 2,899.94 4,149.94 1,250.00 2,899.94 7,600.00 3,450.06 45.4%Total-CM-SUPPLIES & MATERIALS25,915.81 19,540.00 6,375.81 25,915.81 19,540.00 6,375.81 319,720.00 293,804.19 91.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,739.37 3,360.00 (1,620.63) 1,739.37 3,360.00 (1,620.63) 24,610.00 22,870.63 92.9%6315685 CM-R&M-Bldngs & Othr Structures 125.50 250.00 (124.50) 125.50 250.00 (124.50) 1,750.00 1,624.50 92.8%6315690 CM-R&M-Equipment 2,069.45 1,000.00 1,069.45 2,069.45 1,000.00 1,069.45 20,500.00 18,430.55 89.9%6315692 CM-R&M-Irrigation System - 2,100.00 (2,100.00) - 2,100.00 (2,100.00) 16,050.00 16,050.00 100.0%6315696 CM-R&M-Pumps 1,145.07 1,000.00 145.07 1,145.07 1,000.00 145.07 10,500.00 9,354.93 89.1%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 5,079.39 7,710.00 (2,630.61) 5,079.39 7,710.00 (2,630.61) 83,460.00 78,380.61 93.9%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 22.03 15.00 7.03 22.03 15.00 7.03 180.00 157.97 0.0%6317840 Telephones 1,094.79 850.00 244.79 1,094.79 850.00 244.79 10,200.00 9,105.21 89.3%Total-CM-UTILITIES 1,116.82 865.00 251.82 1,116.82 865.00 251.82 10,380.00 9,263.18 89.2%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%6319101 Contract Svcs-Trash Removal 956.15 525.00 431.15 956.15 525.00 431.15 6,288.00 5,331.85 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 178.98 100.00 78.98 178.98 100.00 78.98 1,430.00 1,251.02 87.5%6319490 Miscellaneous - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training 123.65 200.00 (76.35) 123.65 200.00 (76.35) 3,850.00 3,726.35 96.8%6319822 Uniforms 942.53 820.00 122.53 942.53 820.00 122.53 9,840.00 8,897.47 90.4%Total-CM-OTHER EXPENSES 2,701.31 2,495.00 206.31 2,701.31 2,495.00 206.31 38,898.00 36,196.69 93.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2010Annual Budget4 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 2,317.00 2,317.00 - 27,804.00 25,487.00 91.7%6321325 Insurance-Workers Comp 451.20 445.00 6.20 451.20 445.00 6.20 5,487.00 5,035.80 91.8%6321800 Taxes-Employer Payroll 866.38 1,346.00 (479.62) 866.38 1,346.00 (479.62) 16,811.00 15,944.62 94.8%6321880 Wages-Hourly 11,274.31 10,813.00 461.31 11,274.31 10,813.00 461.31 129,756.00 118,481.69 91.3%6321882 Wages-Overtime 5.61 - 5.61 5.61 - 5.61 5,272.00 5,266.39 99.9%Total-CM-LM-SALARIES & BENEFITS14,914.50 14,921.00 (6.50) 14,914.50 14,921.00 (6.50) 185,130.00 170,215.50 91.9%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 168.70 290.00 (121.30) 168.70 290.00 (121.30) 3,480.00 3,311.30 95.2%Total-CM-LM-SUPPLIES & MATERIALS168.70 390.00 (221.30) 168.70 390.00 (221.30) 4,505.00 4,336.30 96.3%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%119,196.50 118,457.00 739.50 119,196.50 118,457.00 739.50 1,541,961.00 1,422,764.50 92.3% July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,900.49 4,500.00 (1,599.51) 2,900.49 4,500.00 (1,599.51) 42,300.00 39,399.51 93.1%6337842 Utilities-Water5,555.23 4,960.00 595.23 5,555.23 4,960.00 595.23 43,058.00 37,502.77 87.1%8,455.72 9,460.00 (1,004.28) 8,455.72 9,460.00 (1,004.28) 85,358.00 76,902.28 90.1%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyJuly 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementJuly 2010Annual BudgetMonth to Date Year to Date5 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 420.00 420.00 - 6,960.00 6,540.00 94.0%6411320 Insurance-Group 662.00 662.00 - 662.00 662.00 - 7,944.00 7,282.00 91.7%6411325 Insurance-Workers Comp 324.20 316.00 8.20 324.20 316.00 8.20 5,096.00 4,771.80 93.6%6411800 Taxes-Employer Payroll 862.08 956.00 (93.92) 862.08 956.00 (93.92) 15,399.00 14,536.92 94.4%6411880 Wages-Hourly 8,083.35 7,682.00 401.35 8,083.35 7,682.00 401.35 123,689.00 115,605.65 93.5%6411882 Wages-Overtime 21.60 - 21.60 21.60 - 21.60 - (21.60) 0.0%Total-CBR-SALARIES & BENEFITS10,373.23 10,036.00 337.23 10,373.23 10,036.00 337.23 159,088.00 148,714.77 93.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 2,350.00 2,350.00 100.0%6413742 Supplies-Expendable 576.31 600.00 (23.69) 576.31 600.00 (23.69) 6,750.00 6,173.69 91.5%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,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 - 72.00 (72.00) - 72.00 (72.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water189.82 50.00 139.82 189.82 50.00 139.82 24,500.00 24,310.18 99.2%Total-CBR-SUPPLIES & MATERIALS766.13 747.00 19.13 766.13 747.00 19.13 41,550.00 40,783.87 98.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 720.00 (720.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment 182.16 300.00 (117.84) 182.16 300.00 (117.84) 3,600.00 3,417.84 94.9%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) - 500.00 (500.00) 5,000.00 5,000.00 100.0%Total-CBR-REPAIRS & MAINTENANCE 182.16 1,520.00 (1,337.84) 182.16 1,520.00 (1,337.84) 17,240.00 17,057.84 98.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,017.69 800.00 217.69 1,017.69 800.00 217.69 9,600.00 8,582.31 89.4%6419220 Freight/Delivery - 75.00 (75.00) - 75.00 (75.00) 450.00 450.00 100.0%6419490 Miscellaneous - 125.00 (125.00) - 125.00 (125.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES 1,017.69 1,000.00 17.69 1,017.69 1,000.00 17.69 16,400.00 15,382.31 93.8%TOTAL-CARTS,BAGROOM & RANGE 12,339.21 13,303.00 (963.79) 12,339.21 13,303.00 (963.79) 234,278.00 221,938.79 94.7%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 180.00 180.00 - 3,420.00 3,240.00 94.7%6431325 Insurance-Workers Comp 81.14 74.00 7.14 81.14 74.00 7.14 1,738.00 1,656.86 95.3%6431800 Taxes-Employer Payroll 287.07 224.00 63.07 287.07 224.00 63.07 5,251.00 4,963.93 94.5%6431880 Wages-Hourly 2,019.60 3,650.00 (1,630.40) 2,019.60 3,650.00 (1,630.40) 48,816.00 46,796.40 95.9%6431882 Wages-Overtime 9.00 - 9.00 9.00 - 9.00 - (9.00) 0.0%Total-CS-SALARIES & BENEFITS2,576.81 4,128.00 (1,551.19) 2,576.81 4,128.00 (1,551.19) 59,225.00 56,648.19 95.6%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 2,576.81 4,303.00 (1,726.19) 2,576.81 4,303.00 (1,726.19) 63,200.00 60,623.19 95.9%14,916.02 17,606.00 (2,689.98) 14,916.02 17,606.00 (2,689.98) 297,478.00 278,586.98 93.6%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJuly 2010Annual Budget6 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas296.93 300.00 (3.07) 296.93 300.00 (3.07) 3,600.00 3,303.07 91.8%6507840 Utilities-Telephone1,065.13 1,150.00 (84.87) 1,065.13 1,150.00 (84.87) 13,800.00 12,734.87 92.3%6507842 Utilities-Water945.21 321.00 624.21 945.21 321.00 624.21 3,852.00 2,906.79 75.5%6507844 Utilities-Cable336.49 340.00 (3.51) 336.49 340.00 (3.51) 4,080.00 3,743.51 91.8%Total-CH-UTILITIES 2,643.76 2,111.00 532.76 2,643.76 2,111.00 532.76 25,332.00 22,688.24 89.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 1,900.00 1,825.00 75.00 22,500.00 20,600.00 91.6%6509099 Contract Services-Security4,948.08 4,900.00 48.08 4,948.08 4,900.00 48.08 60,400.00 55,451.92 91.8%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,848.08 7,025.00 (176.92) 6,848.08 7,025.00 (176.92) 88,900.00 82,051.92 92.3%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures281.00 300.00 (19.00) 281.00 300.00 (19.00) 3,600.00 3,319.00 92.2%6515686 CH-R&M-Restaurant Repairs307.77 400.00 (92.23) 307.77 400.00 (92.23) 4,800.00 4,492.23 93.6%6515690 CH-R&M-Equipment Repair209.00 400.00 (191.00) 209.00 400.00 (191.00) 4,800.00 4,591.00 95.6%Total-CH-REPAIRS & MAINTENANCE 797.77 1,100.00 (302.23) 797.77 1,100.00 (302.23) 13,200.00 12,402.23 94.0%10,289.61 10,636.00 (346.39) 10,289.61 10,636.00 (346.39) 132,232.00 24,804.46 18.8%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJuly 2010Annual Budget7 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 60.00 60.00 - 720.00 660.00 91.7%6601320 Insurance-Group 331.00 331.00 - 331.00 331.00 - 3,972.00 3,641.00 91.7%6601325 Insurance-Workers Comp 100.00 103.00 (3.00) 100.00 103.00 (3.00) 1,240.00 1,140.00 91.9%6601720 Salaries 2,500.00 2,508.00 (8.00) 2,500.00 2,508.00 (8.00) 30,096.00 27,596.00 91.7%6601800 Taxes-Employer Payroll 311.00 312.00 (1.00) 311.00 312.00 (1.00) 3,747.00 3,436.00 91.7%Total-MKT-SALARIES & BENEFITS 3,302.00 3,314.00 (12.00) 3,302.00 3,314.00 (12.00) 39,775.00 36,473.00 91.7%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 1,949.33 - 1,949.33 1,949.33 - 1,949.33 4,425.00 2,475.67 55.9%1,949.33 100.00 1,849.33 1,949.33 100.00 1,849.33 5,625.00 3,675.67 65.3%66-MKT-UTILITIES6607840 Utilities-Telephone 51.09 100.00 (48.91) 51.09 100.00 (48.91) 1,200.00 1,148.91 95.7%Total-MKT-UTILITIES 51.09 100.00 (48.91) 51.09 100.00 (48.91) 1,200.00 1,148.91 95.7%66-MKT-OTHER EXPENSES6609010 Advertising 11,005.14 8,287.00 2,718.14 11,005.14 8,287.00 2,718.14 192,534.00 181,528.86 94.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 361.50 400.00 (38.50) 361.50 400.00 (38.50) 4,800.00 4,438.50 92.5%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 66.00 50.00 16.00 66.00 50.00 16.00 600.00 534.00 89.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 140.00 - 140.00 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 11,572.64 8,837.00 2,735.64 11,572.64 8,837.00 2,735.64 216,044.00 203,771.36 94.3%16,875.06 12,351.00 4,524.06 16,875.06 12,351.00 4,524.06 262,644.00 245,068.94 93.3%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJuly 2010Annual Budget8 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 180.00 180.00 - 2,160.00 1,980.00 91.7%6701320 Insurance-Group1,458.00 1,458.00 - 1,458.00 1,458.00 - 17,496.00 16,038.00 91.7%6701325 Insurance-Workers Comp640.08 707.00 (66.92) 640.08 707.00 (66.92) 8,480.00 7,839.92 92.5%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,320.39 2,136.00 (815.61) 1,320.39 2,136.00 (815.61) 25,627.00 24,306.61 94.8%6701880 Wages-Hourly1,691.43 2,319.66 (628.23) 1,691.43 2,319.66 (628.23) 27,835.00 26,143.57 93.9%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,600.58 21,634.00 (2,033.42) 19,600.58 21,634.00 (2,033.42) 259,598.00 239,997.42 92.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer270.79 400.00 (129.21) 270.79 400.00 (129.21) 5,200.00 4,929.21 94.8%6703762 Supplies-Office 89.28 100.00 (10.72) 89.28 100.00 (10.72) 1,200.00 1,110.72 92.6%6703768 Supplies-Printing & Stationery515.42 100.00 415.42 515.42 100.00 415.42 3,300.00 2,784.58 84.4%Total-G&A-SUPPLIES & MATERIALS 875.49 600.00 275.49 875.49 600.00 275.49 9,700.00 8,824.51 91.0%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 & Subscriptions271.71 50.00 221.71 271.71 50.00 221.71 1,700.00 1,428.29 84.0%6709180 Employee Recruiting/Relocation28.00 - 28.00 28.00 - 28.00 1,400.00 1,372.00 98.0%6709197 Equipment Rental548.16 480.00 68.16 548.16 480.00 68.16 5,760.00 5,211.84 90.5%6709202 Fees-Bank43.76 90.00 (46.24) 43.76 90.00 (46.24) 1,080.00 1,036.24 95.9%6709208 Fees-Payroll Processing1,058.48 760.00 298.48 1,058.48 760.00 298.48 9,120.00 8,061.52 88.4%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 60.27 75.00 (14.73) 60.27 75.00 (14.73) 900.00 839.73 93.3%6709625 Professional Fees475.00 850.00 (375.00) 475.00 850.00 (375.00) 10,200.00 9,725.00 95.3%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,885.38 3,230.00 (344.62) 2,885.38 3,230.00 (344.62) 44,410.00 41,524.62 93.5%23,361.45 25,464.00 (2,102.55) 23,361.45 25,464.00 (2,102.55) 314,808.00 291,446.55 92.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2010Annual Budget9 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,785.41 11,581.00 (2,795.59) 8,785.41 11,581.00 (2,795.59) 150,324.00 141,538.59 94.2%6800194 Equipment Leases-Trailer 520.00 600.00 (80.00) 520.00 600.00 (80.00) 7,200.00 6,680.00 92.8%6800196 Equipment Leases-GPS 7,942.00 8,636.00 (694.00) 7,942.00 8,636.00 (694.00) 90,216.00 82,274.00 91.2%6800197 Equipment Leases-Others 1,529.47 - 1,529.47 1,529.47 - 1,529.47 - - 0.0%18,776.88 20,817.00 (2,040.12) 18,776.88 20,817.00 (2,040.12) 247,740.00 230,492.59 93.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 16,014.36 21,652.00 (5,637.64) 16,014.36 21,652.00 (5,637.64) 90,000.00 73,985.64 82.2%6900210 FF&E Reserve 1,795.75 1,938.00 (142.25) 1,795.75 1,938.00 (142.25) 62,229.00 60,433.25 97.1%6900800 Personal Property Taxes 5,199.29 13,570.00 (8,370.71) 5,199.29 13,570.00 (8,370.71) 13,570.00 8,370.71 61.7%6900323 Insurance-Commercial 2,541.44 2,200.00 341.44 2,541.44 2,200.00 341.44 26,400.00 23,858.56 90.4%25,550.84 39,360.00 (13,809.16) 25,550.84 39,360.00 (13,809.16) 192,199.00 166,648.16 86.7%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 201010 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf Industry8VIPCelebrityPGA Comp68Charity/Gift CertificateRain/Wind ChecksClub Staff77LQ HS Golf153000002011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011