Loading...
01 July 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2012 – July2012 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 Revenue92,478.52 94,153.00 (1,674.48) -1.8% 92,478.52 94,153.00 (1,674.48) 3,350,773.00 3,258,294.48 3%401000 Miscellaneous Golf Revenue 5,041.90 6,560.00 (1,518.10) -23.1% 5,041.90 6,560.00 (1,518.10) 159,973.00 154,931.10 3%410000 Revenue-Golf Shop 8,898.79 8,840.00 58.79 0.7% 8,898.79 8,840.00 58.79 311,048.00 302,149.21 3%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income0.65 - 0.65 0.0% 0.65 - 0.65 - (0.65) 0%Total Income106,919.86 110,053.00 (3,133.14) -2.8% 106,919.86 110,053.00 (3,133.14) 3,833,794.00 3,726,874.14 3%Cost of Goods Sold510000 COS-Golf Shop 4,731.31 4,692.00 39.31 -0.8% 4,731.31 4,692.00 (39.31) 165,088.40 160,357.09 3%Total COS4,731.31 4,692.00 39.31 -0.8% 4,731.31 4,692.00 (39.31) 165,088.40 160,357.09 3%Gross Profit102,188.55 105,361.00 (3,172.45) -3.0% 102,188.55 105,361.00 (3,172.45) 3,668,705.60 3,566,517.05 3%Expenses610000 Golf Pro Shop 15,369.96 16,885.00 1,515.04 9.0% 15,369.96 16,885.00 1,515.04 212,986.00 197,616.04 7%630000 Course Maintenance120,804.94 126,236.00 5,431.06 4.3% 120,804.94 126,236.00 5,431.06 1,664,207.00 1,543,402.06 7%633000 Maintenance Water & Energy26,002.14 17,625.00 (8,377.14) -47.5% 26,002.14 17,625.00 (8,377.14) 221,749.00 195,746.86 12%640000 Outside Services16,914.98 15,739.00 (1,175.98) -7.5% 16,914.98 15,739.00 (1,175.98) 292,671.00 275,756.02 6%650000 Clubhouse 8,883.10 10,636.00 1,752.90 16.5% 8,883.10 10,636.00 1,752.90 132,232.00 123,348.90 7%660000 Marketing 11,219.27 12,024.00 804.73 6.7% 11,219.27 12,024.00 804.73 245,611.00 234,391.73 5%670000 General & Administrative20,689.03 25,261.00 4,571.97 18.1% 20,689.03 25,261.00 4,571.97 312,385.00 291,695.97 7%680000 Leases 18,556.29 18,890.00 333.71 1.8% 18,556.29 18,890.00 333.71 226,680.00 208,123.71 8%690000 Miscellaneous Other Expense28,485.65 30,504.00 2,018.35 6.6% 28,485.65 30,504.00 2,018.35 198,215.00 169,729.35 14%Total Expenses266,925.36 273,800.00 6,874.64 2.5% 266,925.36 273,800.00 6,874.64 3,506,736.00 3,239,810.64 8%(164,736.81) (168,439.00) 3,702.19 2.2%(164,736.81) (168,439.00) 3,702.19 161,969.60 326,706.41 -102%Rounds of Golf PlayedPaid Rounds Played 2,652 2,600 52 2.0% 2,652 2,600 52 45,625 42,973 6%Ave $ Per Paid Round Green Fee34.87 36.21 (1.34) -3.7% 34.87 36.21 (1.34) 73.44 38.57 47%Ave $ Per Paid Round Merchandise3.36 3.40 (0.04) -1.3% 3.36 3.40 (0.04) 6.82 3.46 49%Ave $ Per Paid Miscellaneous 1.90 2.52 (0.62) -24.6% 1.90 2.52 (0.62) 3.51 1.61 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJuly 20121 Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 92,478.52 94,153.00 (1,674.48) 92,478.52 94,153.00 (1,674.48) 3,350,773.003,258,294.483%4010000 Rider Fee 600.00 260.00 340.00 600.00 260.00 340.00 7,643.007,043.008%4040000 Club Rental 1,085.00 1,300.00 (215.00) 1,085.00 1,300.00 (215.00) 23,325.0022,240.005%4050000 Driving Range 2,187.00 3,900.00 (1,713.00) 2,187.00 3,900.00 (1,713.00) 85,405.0083,218.003%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 100.00 (100.00) - 100.00 (100.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract 1,169.90 1,000.00 169.90 1,169.90 1,000.00 169.90 4,000.00 2,830.1029%4091000 Golf Professional Rental Fee - - - - - - 37,000.00 37,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 97,520.42 100,713.00 (3,192.58) 97,520.42 100,713.00 (3,192.58) 3,510,746.00 3,413,225.58 3%97,520.42 100,713.00 (3,192.58) 97,520.42 100,713.00 (3,192.58) 3,510,746.00 3,413,225.58 3%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueJuly 20122 Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 132.86 - 132.86 132.86 - 132.86 0 0 0%4100110 Sales Hard Goods 4,597.23 3,094.00 1,503.23 4,597.23 3,094.00 1,503.23 108,867.00 104,269.77 4%4100112 Sales-Soft Goods 5,270.00 5,746.00 (476.00) 5,270.00 5,746.00 (476.00) 202,181.00 196,911.00 3%5100639 GS-Discounts-Mdse (1,101.30) - (1,101.30) (1,101.30) - (1,101.30) - 1,101.30 0% Total Revenue Golf Shop 8,898.79 8,840.00 58.79 8,898.79 8,840.00 58.79 311,048.00 302,282.07 3%COS 5100150 COS-GS-Hard Goods 2,907.85 1,701.70 1,206.15 2,907.85 1,701.70 1,206.15 59,876.85 56,969.00 5%5100151 COS-GS-Soft Goods 1,642.28 3,160.30 (1,518.02) 1,642.28 3,160.30 (1,518.02) 111,199.55 109,557.27 1%5100152 COS-GS-Purchase Disc - (243.00) 243.00 - (243.00) 243.00 (8,554.00) (8,554.00) 0%5100220 COS-GS-Freight Merch 181.18 73.00 108.18 181.18 73.00 108.18 2,566.00 2,384.82 7%Cost of Sales - Golf Shop 4,731.31 4,692.00 39.31 4,731.31 4,692.00 39.31 165,088.40 160,357.09 3%Gross Profit 4,167.48 4,148.00 19.48 4,167.48 4,148.00 19.48 145,959.60 141,924.98 3%COS % 53.2% 53.1% -0.1% 53.2% 53.1% -0.1% 53.1% 53.0% 0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 1,986.00 416.29 2,402.29 1,986.00 416.29 26,811.00 24,408.71 9%6101325 Insurance-Workers Comp 365.31 436.00 (70.69) 365.31 436.00 (70.69) 5,663.00 5,297.69 6%6101720 Salaries 3,545.44 3,750.00 (204.56) 3,545.44 3,750.00 (204.56) 45,000.00 41,454.56 8%6101800 Taxes-Employer Payroll 743.42 1,136.00 (392.58) 743.42 1,136.00 (392.58) 14,758.00 14,014.58 5%6101880 Wages-Hourly 5,605.65 7,117.00 (1,511.35) 5,605.65 7,117.00 (1,511.35) 96,229.00 90,623.35 6%6101882 Wages-Overtime 115.51 - 115.51 115.51 - 115.51 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,777.62 14,425.00 (1,647.38) 12,777.62 14,425.00 (1,647.38) 188,461.00 176,751.77 6%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office - 500.00 (500.00) - 500.00 (500.00) 6,000.00 6,000.00 0%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 748.75 - 748.75 748.75 - 748.75 450.00 (298.75) 166%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (12.96) - (12.96) (12.96) - (12.96) - 12.96 0%6109722 Seminars/Training 1,250.00 1,250.00 - 1,250.00 1,250.00 - 5,890.00 4,640.00 21%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 106.55 110.00 (3.45) 106.55 110.00 (3.45) 1,320.00 1,213.45 0%Total PS-OTHER EXPENSES 2,592.34 2,460.00 132.34 2,592.34 2,460.00 132.34 24,525.00 21,932.66 11%15,369.96 16,885.00 (1,515.04) 15,369.96 16,885.00 (1,515.04) 212,986.00 198,684.43 7%Net Income(11,202.48) (12,737.00) 1,534.52 (11,202.48) (12,737.00) 1,534.52 (67,026.40) (56,759.45) -15%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJuly 20123 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,111.48 8,740.00 371.48 9,111.48 8,740.00 371.48 104,880.00 95,768.52 91.3%6311325 Insurance-Workers Comp 1,410.43 2,208.00 (797.57) 1,410.43 2,208.00 (797.57) 27,280.00 25,869.57 94.8%6311720 Salaries 11,001.60 11,001.60 - 11,001.60 11,001.60 - 150,996.00 139,994.40 92.7%6311800 Taxes-Employer Payroll 4,391.31 5,753.00 (1,361.69) 4,391.31 5,753.00 (1,361.69) 71,645.00 67,253.69 93.9%6311880 Wages-Hourly 45,335.32 44,054.40 1,280.92 45,335.32 44,054.40 1,280.92 518,654.00 473,318.68 91.3%6311882 Wages-Overtime 134.68 - 134.68 134.68 - 134.68 15,945.00 15,810.32 99.2%Total-CM-SALARIES & BENEFITS71,384.82 71,757.00 (372.18) 71,384.82 71,757.00 (372.18) 889,400.00 818,015.18 92.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 917.67 - 917.67 917.67 - 917.67 31,100.00 30,182.33 97.0%6313744 Fertilizer 11,614.66 12,000.00 (385.34) 11,614.66 12,000.00 (385.34) 114,500.00 102,885.34 89.9%6313745 Herbicides 622.02 - 622.02 622.02 - 622.02 17,000.00 16,377.98 96.3%6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 4,095.18 5,200.00 (1,104.82) 4,095.18 5,200.00 (1,104.82) 55,020.00 50,924.82 92.6%6313750 Golf Course Accessories 79.18 200.00 (120.82) 79.18 200.00 (120.82) 13,000.00 12,920.82 99.4%6313756 POA Control 230.45 - 230.45 230.45 - 230.45 7,000.00 6,769.55 96.7%6313758 Miscellaneous Supp 1,290.84 750.00 540.84 1,290.84 750.00 540.84 4,350.00 3,059.16 0.0%6313762 Supplies-Office 79.77 - 79.77 79.77 - 79.77 - (79.77) 0.0%6313774 Sand - 390.00 (390.00) - 390.00 (390.00) 16,460.00 16,460.00 100.0%6313776 Seed - 350.00 (350.00) - 350.00 (350.00) 106,810.00 106,810.00 100.0%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) - 100.00 (100.00) 5,000.00 5,000.00 100.0%6313780 Sod 382.52 1,000.00 (617.48) 382.52 1,000.00 (617.48) 7,950.00 7,567.48 95.2%6313782 Topdressing - 1,250.00 (1,250.00) - 1,250.00 (1,250.00) 7,600.00 7,600.00 100.0%Total-CM-SUPPLIES & MATERIALS19,312.29 21,240.00 (1,927.71) 19,312.29 21,240.00 (1,927.71) 388,840.00 369,527.71 95.0%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 177.18 1,250.00 (1,072.82) 177.18 1,250.00 (1,072.82) 5,550.00 5,372.82 96.8%6315690 CM-R&M-Equipment 1,977.91 1,500.00 477.91 1,977.91 1,500.00 477.91 31,000.00 29,022.09 93.6%6315692 CM-R&M-Irrigation System 1,404.92 5,400.00 (3,995.08) 1,404.92 5,400.00 (3,995.08) 22,650.00 21,245.08 93.8%6315696 CM-R&M-Pumps 1,949.17 1,000.00 949.17 1,949.17 1,000.00 949.17 10,500.00 8,550.83 81.4%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 8,339.18 11,750.00 (3,410.82) 8,339.18 11,750.00 (3,410.82) 110,950.00 102,610.82 92.5%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 23.71 15.00 8.71 23.71 15.00 8.71 180.00 156.29 0.0%6317840 Telephones 1,223.11 850.00 373.11 1,223.11 850.00 373.11 10,200.00 8,976.89 88.0%Total-CM-UTILITIES 1,246.82 865.00 381.82 1,246.82 865.00 381.82 10,380.00 9,133.18 88.0%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 - 524.00 (524.00) - 524.00 (524.00) 6,288.00 6,288.00 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 519.55 100.00 419.55 519.55 100.00 419.55 1,200.00 680.45 56.7%6319718 Safety Equipment & Training 471.59 200.00 271.59 471.59 200.00 271.59 3,850.00 3,378.41 87.8%6319822 Uniforms 1,270.12 920.00 350.12 1,270.12 920.00 350.12 11,040.00 9,769.88 88.5%Total-CM-OTHER EXPENSES 2,761.26 2,594.00 167.26 2,761.26 2,594.00 167.26 40,098.00 37,336.74 93.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2012Annual Budget4 July 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 2,958.24 2,648.00 310.24 31,776.00 28,817.76 90.7%6321325 Insurance-Workers Comp 466.69 516.00 (49.31) 466.69 516.00 (49.31) 6,361.00 5,894.31 92.7%6321800 Taxes-Employer Payroll 1,274.89 1,346.00 (71.11) 1,274.89 1,346.00 (71.11) 16,808.00 15,533.11 92.4%6321880 Wages-Hourly 12,811.50 12,880.00 (68.50) 12,811.50 12,880.00 (68.50) 154,560.00 141,748.50 91.7%6321882 Wages-Overtime 10.50 - 10.50 10.50 - 10.50 6,279.00 6,268.50 99.8%Total-CM-LM-SALARIES & BENEFITS17,521.82 17,390.00 131.82 17,521.82 17,390.00 131.82 215,784.00 198,262.18 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 238.75 290.00 (51.25) 238.75 290.00 (51.25) 3,480.00 3,241.25 93.1%Total-CM-LM-SUPPLIES & MATERIALS238.75 390.00 (151.25) 238.75 390.00 (151.25) 4,505.00 4,266.25 94.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%120,804.94 126,236.00 (5,431.06) 120,804.94 126,236.00 (5,431.06) 1,664,207.00 1,543,402.06 92.7% July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 18,969.35 12,665.00 6,304.35 18,969.35 12,665.00 6,304.35 178,691.00 159,721.65 89.4%6337842 Utilities-Water7,032.79 4,960.00 2,072.79 7,032.79 4,960.00 2,072.79 43,058.00 36,025.21 83.7%26,002.14 17,625.00 8,377.14 26,002.14 17,625.00 8,377.14 221,749.00 195,746.86 88.3%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyJuly 2012Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementJuly 2012Annual BudgetMonth to Date Year to Date5 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 369.78 662.00 (292.22) 369.78 662.00 (292.22) 7,944.00 7,574.22 95.3%6411325 Insurance-Workers Comp 292.10 308.00 (15.90) 292.10 308.00 (15.90) 5,135.00 4,842.90 94.3%6411800 Taxes-Employer Payroll 909.07 956.00 (46.93) 909.07 956.00 (46.93) 15,942.00 15,032.93 94.3%6411880 Wages-Hourly 7,777.74 7,682.00 95.74 7,777.74 7,682.00 95.74 128,052.00 120,274.26 93.9%6411882 Wages-Overtime 13.31 - 13.31 13.31 - 13.31 - (13.31) 0.0%Total-CBR-SALARIES & BENEFITS9,362.00 9,608.00 (246.00) 9,362.00 9,608.00 (246.00) 157,073.00 147,711.00 94.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 134.69 - 134.69 134.69 - 134.69 2,350.00 2,215.31 94.3%6413742 Supplies-Expendable 1,301.11 600.00 701.11 1,301.11 600.00 701.11 6,750.00 5,448.89 80.7%6413748 Supplies-Fuel for Shuttle - - - - - - 3,000.00 3,000.00 100.0%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 320.00 72.00 248.00 320.00 72.00 248.00 1,005.00 685.00 68.2%6413796 Supplies-Bottled Water374.10 50.00 324.10 374.10 50.00 324.10 24,500.00 24,125.90 98.5%Total-CBR-SUPPLIES & MATERIALS2,129.90 747.00 1,382.90 2,129.90 747.00 1,382.90 47,550.00 45,420.10 95.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) - 300.00 (300.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair 1,494.02 750.00 744.02 1,494.02 750.00 744.02 9,750.00 8,255.98 84.7%Total-CBR-REPAIRS & MAINTENANCE 1,494.02 1,050.00 444.02 1,494.02 1,050.00 444.02 13,350.00 11,855.98 88.8%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 871.13 800.00 71.13 871.13 800.00 71.13 9,600.00 8,728.87 90.9%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 287.81 - 287.81 287.81 - 287.81 5,200.00 4,912.19 94.5%Total-CBR-OTHER EXPENSES 1,158.94 1,000.00 158.94 1,158.94 1,000.00 158.94 16,400.00 15,241.06 92.9%TOTAL-CARTS,BAGROOM & RANGE 14,144.86 12,405.00 1,739.86 14,144.86 12,405.00 1,739.86 234,373.00 220,228.14 94.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 261.19 111.00 150.19 261.19 111.00 150.19 1,903.00 1,641.81 86.3%6431800 Taxes-Employer Payroll 252.22 288.00 (35.78) 252.22 288.00 (35.78) 4,960.00 4,707.78 94.9%6431880 Wages-Hourly 2,064.00 2,760.00 (696.00) 2,064.00 2,760.00 (696.00) 47,460.00 45,396.00 95.7%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,577.41 3,159.00 (581.59) 2,577.41 3,159.00 (581.59) 54,323.00 51,745.59 95.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 192.71 - 192.71 192.71 - 192.71 200.00 7.29 3.6%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 192.71 175.00 17.71 192.71 175.00 17.71 3,975.00 3,782.29 95.2%Total-COURSE SERVICES 2,770.12 3,334.00 (563.88) 2,770.12 3,334.00 (563.88) 58,298.00 55,527.88 95.2%16,914.98 15,739.00 1,175.98 16,914.98 15,739.00 1,175.98 292,671.00 271,973.73 92.9%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJuly 2012Annual 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 Gas- 300.00 (300.00) - 300.00 (300.00) 3,600.00 3,600.00 100.0%6507840 Utilities-Telephone1,236.32 1,150.00 86.32 1,236.32 1,150.00 86.32 13,800.00 12,563.68 91.0%6507842 Utilities-Water456.41 321.00 135.41 456.41 321.00 135.41 3,852.00 3,395.59 88.2%6507844 Utilities-Cable336.91 340.00 (3.09) 336.91 340.00 (3.09) 4,080.00 3,743.09 91.7%Total-CH-UTILITIES 2,029.64 2,111.00 (81.36) 2,029.64 2,111.00 (81.36) 25,332.00 23,302.36 92.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,628.88 4,900.00 (271.12) 4,628.88 4,900.00 (271.12) 60,400.00 55,771.12 92.3%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,453.88 7,025.00 (571.12) 6,453.88 7,025.00 (571.12) 88,900.00 82,446.12 92.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures304.58 300.00 4.58 304.58 300.00 4.58 3,600.00 3,295.42 91.5%6515686 CH-R&M-Restaurant Repairs95.00 400.00 (305.00) 95.00 400.00 (305.00) 4,800.00 4,705.00 98.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE 399.58 1,100.00 (700.42) 399.58 1,100.00 (700.42) 13,200.00 12,800.42 97.0%8,883.10 10,636.00 (1,752.90) 8,883.10 10,636.00 (1,752.90) 132,232.00 25,600.84 19.4%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJuly 2012Annual Budget7 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 369.78 331.00 38.78 3,972.00 3,602.22 90.7%6601325 Insurance-Workers Comp 131.47 101.00 30.47 131.47 101.00 30.47 1,207.00 1,075.53 89.1%6601720 Salaries 1,773.84 2,508.00 (734.16) 1,773.84 2,508.00 (734.16) 30,096.00 28,322.16 94.1%6601800 Taxes-Employer Payroll 178.36 262.00 (83.64) 178.36 262.00 (83.64) 3,145.00 2,966.64 94.3%Total-MKT-SALARIES & BENEFITS 2,453.45 3,202.00 (748.55) 2,453.45 3,202.00 (748.55) 38,420.00 35,966.55 93.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 293.49 - 293.49 293.49 - 293.49 4,425.00 4,131.51 93.4%293.49 100.00 193.49 293.49 100.00 193.49 5,625.00 5,331.51 94.8%66-MKT-UTILITIES6607840 Utilities-Telephone 105.62 100.00 5.62 105.62 100.00 5.62 1,200.00 1,094.38 91.2%Total-MKT-UTILITIES 105.62 100.00 5.62 105.62 100.00 5.62 1,200.00 1,094.38 91.2%66-MKT-OTHER EXPENSES6609010 Advertising 8,366.71 8,172.00 194.71 8,366.71 8,172.00 194.71 179,231.00 170,864.29 95.3%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page - 300.00 (300.00) - 300.00 (300.00) 3,600.00 3,600.00 100.0%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 - 25.00 (25.00) - 25.00 (25.00) 3,000.00 3,000.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 75.00 (75.00) 2,250.00 2,250.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,366.71 8,622.00 (255.29) 8,366.71 8,622.00 (255.29) 200,366.00 191,299.29 95.5%11,219.27 12,024.00 (804.73) 11,219.27 12,024.00 (804.73) 245,611.00 233,691.73 95.1%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJuly 2012Annual Budget8 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,756.80 1,458.00 298.80 1,756.80 1,458.00 298.80 17,496.00 15,739.20 90.0%6701325 Insurance-Workers Comp438.63 688.00 (249.37) 438.63 688.00 (249.37) 8,254.00 7,815.37 94.7%6701720 Salaries 13,416.26 15,003.00 (1,586.74) 13,416.26 15,003.00 (1,586.74) 178,000.00 164,583.74 92.5%6701800 Taxes-Employer Payroll 1,117.91 1,792.00 (674.09) 1,117.91 1,792.00 (674.09) 21,510.00 20,392.09 94.8%6701880 Wages-Hourly1,191.64 2,150.00 (958.36) 1,191.64 2,150.00 (958.36) 27,835.00 26,643.36 95.7%6701882 Wages-Overtime 5.44 - 5.44 5.44 - 5.44 - (5.44) 0.0%Total-G&A-SALARIES & BENEFITS 17,926.68 21,091.00 (3,164.32) 17,926.68 21,091.00 (3,164.32) 253,095.00 235,168.32 92.9%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 - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.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 - 600.00 (600.00) - 600.00 (600.00) 9,700.00 9,700.00 100.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 & Subscriptions165.00 50.00 115.00 165.00 50.00 115.00 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation60.00 - 60.00 60.00 - 60.00 1,400.00 1,340.00 95.7%6709197 Equipment Rental578.37 480.00 98.37 578.37 480.00 98.37 5,760.00 5,181.63 90.0%6709202 Fees-Bank158.15 90.00 68.15 158.15 90.00 68.15 1,080.00 921.85 85.4%6709208 Fees-Payroll Processing1,127.73 1,100.00 27.73 1,127.73 1,100.00 27.73 13,200.00 12,072.27 91.5%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 155.80 75.00 80.80 155.80 75.00 80.80 900.00 744.20 82.7%6709625 Professional Fees99.00 850.00 (751.00) 99.00 850.00 (751.00) 10,200.00 10,101.00 99.0%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 18.30 75.00 (56.70) 18.30 75.00 (56.70) 1,050.00 1,031.70 98.3%Total-G&A-OTHER EXPENSES 2,762.35 3,570.00 (807.65) 2,762.35 3,570.00 (807.65) 48,490.00 45,727.65 94.3%20,689.03 25,261.00 (4,571.97) 20,689.03 25,261.00 (4,571.97) 312,385.00 291,695.97 93.4%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2012Annual Budget9 July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 11,988.25 12,075.00 (86.75) 144,900.00 132,911.75 91.7%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 502.54 600.00 (97.46) 7,200.00 6,697.46 93.0%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 4,940.00 5,755.00 (815.00) 69,060.00 64,120.00 92.8%6800197 Equipment Leases-Others 1,125.50 460.00 665.50 1,125.50 460.00 665.50 5,520.00 4,394.50 0.0%18,556.29 18,890.00 (333.71) 18,556.29 18,890.00 (333.71) 226,680.00 208,123.71 91.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 18,367.03 21,221.00 (2,853.97) 18,367.03 21,221.00 (2,853.97) 90,000.00 71,632.97 79.6%6900210 FF&E Reserve 1,849.57 1,883.00 (33.43) 1,849.57 1,883.00 (33.43) 67,015.00 65,165.43 97.2%6900800 Personal Property Taxes 5,793.98 5,200.00 593.98 5,793.98 5,200.00 593.98 14,800.00 9,006.02 60.9%6900323 Insurance-Commercial 2,475.07 2,200.00 275.07 2,475.07 2,200.00 275.07 26,400.00 23,924.93 90.6%28,485.65 30,504.00 (2,018.35) 28,485.65 30,504.00 (2,018.35) 198,215.00 169,729.35 85.6%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 201210 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia3SalesPromotionGolf IndustryVIPCelebrityPGA Comp62Charity/Gift Certificate6Rain/Wind Checks5Club Staff129LQ HS Golf8213000002013 2013 2013 2013 2013 2013Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013July 2012 Date Time Description CategoryPlayers7/21/2012 12:00 Kris Long Media 312