Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10 April 2012 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2011 – April 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 April Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue432,906.26 463,400.00 (30,493.74) -6.6% 2,897,120.87 2,863,403.00 33,717.87 3,326,982.00 429,861.13 87%401000 Miscellaneous Golf Revenue 25,381.90 17,760.00 7,621.90 42.9% 168,397.41 130,371.00 38,026.41 146,537.00 (21,860.41) 115%410000 Revenue-Golf Shop 32,037.81 42,000.00 (9,962.19) -23.7% 243,818.98 264,721.00 (20,902.02) 310,919.00 67,100.02 78%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,000.00 11,000.00 - 12,000.00 1,000.00 92%890000 Interest Income0.98 - 0.98 0.0% 23.97 - 23.97 - (23.97) 0%Total Income490,826.95 523,660.00 (32,833.05) -6.3% 3,320,361.23 3,269,495.00 50,866.23 3,796,438.00 476,076.77 87%Cost of Goods Sold510000 COS-Golf Shop 18,583.02 22,292.00 (3,708.98) 16.6% 140,484.56 140,502.55 17.99 165,020.45 24,535.89 85%Total COS18,583.02 22,292.00 (3,708.98) 16.6% 140,484.56 140,502.55 17.99 165,020.45 24,535.89 85%Gross Profit472,243.93 501,368.00 (29,124.07) -5.8% 3,179,876.67 3,128,992.45 50,884.22 3,631,417.55 451,540.88 88%Expenses610000 Golf Pro Shop 18,695.40 18,858.00 162.60 0.9% 164,399.50 183,248.00 18,848.50 223,325.00 58,925.50 74%630000 Course Maintenance132,961.57 116,182.00 (16,779.57) -14.4% 1,437,407.89 1,409,586.00 (27,821.89) 1,638,879.00 201,471.11 88%633000 Maintenance Water & Energy17,109.97 20,967.00 3,857.03 18.4% 174,037.33 218,137.00 44,099.67 270,449.00 96,411.67 64%640000 Outside Services24,758.06 25,575.00 816.94 3.2% 237,528.45 234,067.00 (3,461.45) 281,023.00 43,494.55 85%650000 Clubhouse 10,220.53 10,636.00 415.47 3.9% 105,867.13 110,560.00 4,692.87 132,232.00 26,364.87 80%660000 Marketing 26,336.81 22,984.00 (3,352.81) -14.6% 193,100.55 231,382.00 38,281.45 254,820.00 61,719.45 76%670000 General & Administrative24,368.29 26,052.00 1,683.71 6.5% 249,872.22 261,420.00 11,547.78 314,669.00 64,796.78 79%680000 Leases 18,633.79 19,590.00 956.21 4.9% 195,396.22 195,900.00 503.78 235,080.00 39,683.78 83%690000 Miscellaneous Other Expense11,452.12 6,408.00 (5,044.12) -78.7% 156,801.93 160,671.00 3,869.07 197,740.00 40,938.07 79%Total Expenses284,536.54 267,252.00 (17,284.54) -6.5% 2,914,411.22 3,004,971.00 90,559.78 3,548,217.00 633,805.78 82%187,707.39 234,116.00 (46,408.61) -19.8%265,465.45 124,021.45 141,444.00 83,200.55 (182,264.90) 319%Rounds of Golf PlayedPaid Rounds Played 5,569 5,600 (31) -0.6% 39,719 37,925 1,794 45,625 5,906 87%Ave $ Per Paid Round Green Fee77.74 82.75 (5.01) -6.1% 72.94 75.50 (2.56) 72.92 (0.02) 100%Ave $ Per Paid Round Merchandise5.75 7.50 (1.75) -23.3% 6.14 6.98 (0.84) 6.81 0.68 90%Ave $ Per Paid Miscellaneous 4.56 3.17 1.39 43.7% 4.24 3.44 0.80 3.21 (1.03) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateApril 20121 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 432,906.26 463,400.00 (30,493.74) 2,897,120.87 2,863,403.00 33,717.87 3,326,982.00429,861.1387%4010000 Rider Fee 1,300.00 560.00 740.00 11,175.00 6,678.00 4,497.00 7,446.00-3,729.00150%4040000 Club Rental 3,345.00 2,800.00 545.00 22,214.00 18,964.00 3,250.00 22,813.00599.0097%4050000 Driving Range 10,758.00 8,400.00 2,358.00 78,466.00 61,729.00 16,737.00 73,278.00-5,188.00107%4060000 Handicap Fees - - - 1,600.00 - 1,600.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 1,428.90 1,000.00 428.90 3,269.30 4,000.00 (730.70) 4,000.00 730.7082%4091000 Golf Professional Rental Fee 8,550.00 5,000.00 3,550.00 47,559.25 27,000.00 20,559.25 27,000.00 -20,559.25 176%4092000 Golf Lessons - - - 1,559.38 - 1,559.38 - (1,559.38) 0% Total Revenue Fees 458,288.16 481,160.00 (22,871.84) 3,065,518.28 2,993,774.00 71,744.28 3,473,519.00 409,600.72 88%458,288.16 481,160.00 (22,871.84) 3,065,518.28 2,993,774.00 71,744.28 3,473,519.00 409,600.72 88%SilverRock ResortStatement of Fees RevenueApril 2012Total IncomeMonth to Date Year to Date Annual Budget2 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 778.00 - 778.00 3,432.42 - 3,432.42 0 0 0%4100110 Sales Hard Goods 11,537.24 14,700.00 (3,162.76) 93,860.61 92,653.00 1,207.61 108,822.00 14,961.39 86%4100112 Sales-Soft Goods 24,615.11 27,300.00 (2,684.89) 186,855.26 172,068.00 14,787.26 202,097.00 15,241.74 92%5100639 GS-Discounts-Mdse (4,892.54) - (4,892.54) (40,329.31) - (40,329.31) - 40,329.31 0% Total Revenue Golf Shop 32,037.81 42,000.00 (9,962.19) 243,818.98 264,721.00 (20,902.02) 310,919.00 70,532.44 77%COS 5100150 COS-GS-Hard Goods 7,530.98 8,085.00 (554.02) 51,819.09 50,959.15 859.94 59,852.10 8,033.01 87%5100151 COS-GS-Soft Goods 10,904.91 15,015.00 (4,110.09) 85,875.77 94,637.40 (8,761.63) 111,153.35 25,277.58 77%5100152 COS-GS-Purchase Disc (217.39) (1,155.00) 937.61 (1,141.30) (7,282.00) 6,140.70 (8,550.00) (7,408.70) -13%5100220 COS-GS-Freight Merch 364.52 347.00 17.52 3,931.00 2,188.00 1,743.00 2,565.00 (1,366.00) 153%Cost of Sales - Golf Shop 18,583.02 22,292.00 (3,708.98) 140,484.56 140,502.55 (17.99) 165,020.45 24,535.89 85%Gross Profit 13,454.79 19,708.00 (6,253.21) 103,334.42 124,218.45 (20,884.03) 145,898.55 45,996.55 68%COS % 58.0% 53.1% -4.9% 57.6% 53.1% -4.5% 53.1% 34.8% 34%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 2,317.00 85.29 24,869.36 22,177.00 2,692.36 26,811.00 1,941.64 93%6101325 Insurance-Workers Comp 501.70 539.00 (37.30) 4,330.65 5,094.00 (763.35) 6,131.00 1,800.35 71%6101720 Salaries 3,545.44 3,750.00 (204.56) 38,172.62 37,500.00 672.62 45,000.00 6,827.38 85%6101800 Taxes-Employer Payroll 1,429.45 1,499.00 (69.55) 12,082.39 14,155.00 (2,072.61) 17,040.00 4,957.61 71%6101880 Wages-Hourly 8,140.64 9,343.00 (1,202.36) 70,496.37 86,132.00 (15,635.63) 103,818.00 33,321.63 68%6101882 Wages-Overtime 320.54 - 320.54 1,354.79 - 1,354.79 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,340.06 17,448.00 (1,107.94) 151,306.18 165,058.00 (13,751.82) 198,800.00 49,801.49 75%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 1,144.10 500.00 644.10 3,437.13 5,000.00 (1,562.87) 6,000.00 2,562.87 57%6109090 Contract Services 500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 83%6109220 Freight & Delivery - - - 620.42 75.00 545.42 75.00 (545.42) 827%6109490 Miscellaneous 24.95 50.00 (25.05) 531.18 350.00 181.18 450.00 (81.18) 118%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 80.04 - 80.04 185.11 - 185.11 - (185.11) 0%6109722 Seminars/Training - 35.00 (35.00) 302.96 4,605.00 (4,302.04) 5,890.00 5,587.04 5%6109810 Travel - Merchandise - 15.00 (15.00) - 60.00 (60.00) 90.00 90.00 0%6109820 Uniforms 491.15 200.00 291.15 1,766.28 2,000.00 (233.72) 2,400.00 633.72 74%6117840 Telephones 115.10 110.00 5.10 1,250.24 1,100.00 150.24 1,320.00 69.76 0%Total PS-OTHER EXPENSES 2,355.34 1,410.00 945.34 13,093.32 18,190.00 (5,096.68) 24,525.00 11,431.68 53%18,695.40 18,858.00 (162.60) 164,399.50 183,248.00 (18,848.50) 223,325.00 61,233.17 73%Net Income(5,240.61) 850.00 (6,090.61) (61,065.08) (59,029.55) (2,035.53) (77,426.45) (15,236.62) -80%SilverRock ResortGolf Shop Income StatementApril 2012Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,854.74 8,740.00 1,114.74 88,472.68 87,400.00 1,072.68 104,880.00 16,407.32 15.6%6311325 Insurance-Workers Comp 1,937.02 2,269.00 (331.98) 18,870.00 23,410.00 (4,540.00) 28,026.00 9,156.00 32.7%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 118,450.56 125,830.00 (7,379.44) 150,996.00 32,545.44 21.6%6311800 Taxes-Employer Payroll 6,106.35 6,304.00 (197.65) 57,506.99 65,562.00 (8,055.01) 78,501.00 20,994.01 26.7%6311880 Wages-Hourly 44,816.82 42,478.00 2,338.82 444,353.68 433,698.00 10,655.68 518,654.00 74,300.32 14.3%6311882 Wages-Overtime 7.22 - 7.22 11,217.30 13,076.00 (1,858.70) 15,945.00 4,727.70 29.7%Total-CM-SALARIES & BENEFITS73,723.75 72,374.00 1,349.75 738,871.21 748,976.00 (10,104.79) 897,002.00 158,130.79 17.6%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,742.09 2,000.00 1,742.09 31,731.20 26,400.00 5,331.20 29,300.00 (2,431.20) -8.3%6313744 Fertilizer 11,169.00 5,000.00 6,169.00 111,364.83 94,400.00 16,964.83 104,400.00 (6,964.83) -6.7%6313745 Herbicides - - - 17,751.38 17,000.00 751.38 17,000.00 (751.38) -4.4%6313746 Flowers/Plants 98.04 100.00 (1.96) 3,129.73 3,050.00 79.73 3,050.00 (79.73) -2.6%6313748 Fuel-Gasoline 5,204.43 4,100.00 1,104.43 47,324.67 42,600.00 4,724.67 48,800.00 1,475.33 3.0%6313750 Golf Course Accessories 123.91 100.00 23.91 14,762.71 12,100.00 2,662.71 12,300.00 (2,462.71) -20.0%6313756 POA Control - - - 8,443.26 7,000.00 1,443.26 7,000.00 (1,443.26) -20.6%6313758 Miscellaneous Supp 986.26 100.00 886.26 9,287.03 4,150.00 5,137.03 4,350.00 (4,937.03) 0.0%6313762 Supplies-Office 24.23 - 24.23 435.40 - 435.40 - (435.40) 0.0%6313774 Sand - 100.00 (100.00) 11,809.00 16,260.00 (4,451.00) 16,460.00 4,651.00 28.3%6313776 Seed - 350.00 (350.00) 106,201.53 106,110.00 91.53 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip 85.78 100.00 (14.22) 4,512.09 4,800.00 (287.91) 5,000.00 487.91 9.8%6313780 Sod - - - 7,045.81 5,650.00 1,395.81 6,350.00 (695.81) -11.0%6313782 Topdressing - - - 3,842.05 5,000.00 (1,157.95) 7,600.00 3,757.95 49.4%Total-CM-SUPPLIES & MATERIALS21,433.74 11,950.00 9,483.74 377,640.69 344,520.00 33,120.69 368,420.00 (9,220.69) -2.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 28,210.00 26,000.00 2,210.00 31,200.00 2,990.00 9.6%6315685 CM-R&M-Bldngs & Othr Structures 2,660.76 - 2,660.76 6,742.52 1,250.00 5,492.52 1,750.00 (4,992.52) -285.3%6315690 CM-R&M-Equipment 2,288.56 1,500.00 788.56 27,564.69 17,500.00 10,064.69 20,500.00 (7,064.69) -34.5%6315692 CM-R&M-Irrigation System 1,102.47 1,000.00 102.47 16,732.02 20,650.00 (3,917.98) 22,650.00 5,917.98 26.1%6315696 CM-R&M-Pumps 1,461.43 1,000.00 461.43 10,742.01 10,000.00 742.01 10,500.00 (242.01) -2.3%6315815 CM-R&M-Trees-Pruning Etc 4,000.00 4,000.00 - 8,295.00 10,050.00 (1,755.00) 10,050.00 1,755.00 17.5%Total-CM-REPAIRS & MAINTENANCE 14,343.22 10,100.00 4,243.22 98,286.24 85,450.00 12,836.24 96,650.00 (1,636.24) -1.7%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 24.89 15.00 9.89 177.53 150.00 27.53 180.00 2.47 0.0%6317840 Telephones 1,146.74 850.00 296.74 11,882.21 8,500.00 3,382.21 10,200.00 (1,682.21) -16.5%Total-CM-UTILITIES 1,171.63 865.00 306.63 12,059.74 8,650.00 3,409.74 10,380.00 (1,679.74) -16.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 16.7%6319100 Contract Svcs-Soil/Tissue Test - - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal 659.04 524.00 135.04 8,056.60 5,240.00 2,816.60 6,288.00 (1,768.60) 0.0%6319150 Dues & Subscriptions 495.00 200.00 295.00 1,265.00 440.00 825.00 540.00 (725.00) -134.3%6319170 Employee Education - 50.00 (50.00) 59.00 1,450.00 (1,391.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 200.00 (200.00) 2,695.38 3,900.00 (1,204.62) 4,200.00 1,504.62 35.8%6319206 Licenses & Permits 1,725.00 150.00 1,575.00 1,725.00 1,430.00 295.00 1,430.00 (295.00) -20.6%6319490 Miscellaneous - 100.00 (100.00) 1,954.18 1,000.00 954.18 1,200.00 (754.18) -62.8%6319718 Safety Equipment & Training - 100.00 (100.00) 3,019.88 3,650.00 (630.12) 3,850.00 830.12 21.6%6319822 Uniforms 909.71 920.00 (10.29) 10,318.95 9,200.00 1,118.95 11,040.00 721.05 6.5%Total-CM-OTHER EXPENSES 4,288.75 2,744.00 1,544.75 36,093.99 33,310.00 2,783.99 40,098.00 4,004.01 10.0%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementApril 2012Annual Budget4 April 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 23,596.85 26,480.00 (2,883.15) 31,776.00 8,179.15 25.7%6321325 Insurance-Workers Comp 640.93 531.00 109.93 4,738.46 5,455.00 (716.54) 6,543.00 1,804.54 27.6%6321800 Taxes-Employer Payroll 1,024.99 1,475.00 (450.01) 13,647.66 15,357.00 (1,709.34) 18,416.00 4,768.34 25.9%6321880 Wages-Hourly 12,841.63 12,880.00 (38.37) 125,967.93 128,800.00 (2,832.07) 154,560.00 28,592.07 18.5%6321882 Wages-Overtime 22.04 - 22.04 2,371.14 5,313.00 (2,941.86) 6,279.00 3,907.86 62.2%Total-CM-LM-SALARIES & BENEFITS17,487.83 17,534.00 (46.17) 170,322.04 181,405.00 (11,082.96) 217,574.00 47,251.96 21.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 224.72 875.00 (650.28) 1,025.00 800.28 78.1%6323788 Uniforms 212.05 290.00 (77.95) 2,310.76 2,900.00 (589.24) 3,480.00 1,169.24 33.6%Total-CM-LM-SUPPLIES & MATERIALS212.05 365.00 (152.95) 2,535.48 3,775.00 (1,239.52) 4,505.00 1,969.52 43.7%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 300.60 250.00 50.60 1,598.50 3,500.00 (1,901.50) 4,250.00 2,651.50 62.4%Total-CM-LM-REPAIRS & MAINTENANCE 300.60 250.00 50.60 1,598.50 3,500.00 (1,901.50) 4,250.00 2,651.50 62.4%132,961.57 116,182.00 16,779.57 1,437,407.89 1,409,586.00 27,821.89 1,638,879.00 201,471.11 12.3% April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 13,427.45 19,417.00 (5,989.55) 132,520.85 184,844.00 (52,323.15) 227,391.00 94,870.15 41.7%6337842 Utilities-Water3,682.52 1,550.00 2,132.52 41,516.48 33,293.00 8,223.48 43,058.00 1,541.52 3.6%17,109.97 20,967.00 (3,857.03) 174,037.33 218,137.00 (44,099.67) 270,449.00 96,411.67 35.6%Silverrock ResortCourse Maintenance Expense StatementApril 2012Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyApril 2012Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 420.59 662.00 (241.41) 4,313.71 6,620.00 (2,306.29) 7,944.00 3,630.29 45.7%6411325 Insurance-Workers Comp 401.15 565.00 (163.85) 3,718.20 4,342.00 (623.80) 5,096.00 1,377.80 27.0%6411800 Taxes-Employer Payroll 2,000.14 1,707.00 293.14 14,517.15 13,121.00 1,396.15 15,399.00 881.85 5.7%6411880 Wages-Hourly 13,131.64 13,710.00 (578.36) 108,214.16 105,389.00 2,825.16 123,689.00 15,474.84 12.5%6411882 Wages-Overtime 211.50 - 211.50 1,415.64 - 1,415.64 - (1,415.64) 0.0%Total-CBR-SALARIES & BENEFITS16,165.02 16,644.00 (478.98) 132,178.86 129,472.00 2,706.86 152,128.00 19,949.14 13.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 50.00 (50.00) 1,209.92 2,250.00 (1,040.08) 2,350.00 1,140.08 48.5%6413742 Supplies-Expendable 437.47 150.00 287.47 8,598.48 5,750.00 2,848.48 6,750.00 (1,848.48) -27.4%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) - 425.00 (425.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 70.40 280.00 (209.60) 420.00 349.60 83.2%6413786 Supplies-Towels 160.00 72.00 88.00 2,960.00 861.00 2,099.00 1,005.00 (1,955.00) -194.5%6413796 Supplies-Bottled Water29.99 50.00 (20.01) 11,943.80 12,450.00 (506.20) 24,500.00 12,556.20 51.2%Total-CBR-SUPPLIES & MATERIALS627.46 442.00 185.46 32,528.45 31,016.00 1,512.45 44,550.00 12,021.55 27.0%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 3,476.34 3,000.00 476.34 3,600.00 123.66 3.4%6415695 CBR-R&M-Cart Maintenance & Repair 309.70 750.00 (440.30) 5,155.48 8,250.00 (3,094.52) 9,750.00 4,594.52 47.1%Total-CBR-REPAIRS & MAINTENANCE 309.70 1,050.00 (740.30) 8,631.82 11,250.00 (2,618.18) 13,350.00 4,718.18 35.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 498.85 800.00 (301.15) 6,995.27 8,000.00 (1,004.73) 9,600.00 2,604.73 27.1%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous 185.33 125.00 60.33 637.11 900.00 (262.89) 1,150.00 512.89 44.6%6419820 Uniforms - - - 2,597.37 3,500.00 (902.63) 5,200.00 2,602.63 50.1%Total-CBR-OTHER EXPENSES 684.18 925.00 (240.82) 10,229.75 12,850.00 (2,620.25) 16,400.00 6,170.25 37.6%TOTAL-CARTS,BAGROOM & RANGE 17,786.36 19,061.00 (1,274.64) 183,568.88 184,588.00 (1,019.12) 226,428.00 42,859.12 18.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 213.00 145.70 2,809.44 1,637.00 1,172.44 1,805.00 (1,004.44) -55.6%6431800 Taxes-Employer Payroll 757.60 591.00 166.60 5,684.50 4,547.00 1,137.50 5,015.00 (669.50) -13.3%6431880 Wages-Hourly 5,162.00 5,160.00 2.00 41,276.00 39,720.00 1,556.00 43,800.00 2,524.00 5.8%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,278.30 5,964.00 314.30 49,769.94 45,904.00 3,865.94 50,620.00 850.06 1.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable 66.54 100.00 (33.46) 1,078.29 900.00 178.29 1,050.00 (28.29) -2.7%6439490 Miscellaneous 626.86 - 626.86 1,735.94 200.00 1,535.94 200.00 (1,535.94) -768.0%6439718 Safety Equipment & Training - 50.00 (50.00) 91.59 500.00 (408.41) 600.00 508.41 84.7%6439820 Uniforms - 400.00 (400.00) 1,283.81 1,975.00 (691.19) 2,125.00 841.19 39.6%Total-CS-OTHER EXPENSES 693.40 550.00 143.40 4,189.63 3,575.00 614.63 3,975.00 (214.63) -5.4%Total-COURSE SERVICES 6,971.70 6,514.00 457.70 53,959.57 49,479.00 4,480.57 54,595.00 635.43 1.2%24,758.06 25,575.00 (816.94) 237,528.45 234,067.00 3,461.45 281,023.00 43,709.18 15.6%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementApril 2012Annual Budget6 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable966.75 400.00 566.75 1,867.79 4,000.00 (2,132.21) 4,800.00 2,932.21 61.1%Total-CH-SUPPLIES & MATERIALS 966.75 400.00 566.75 1,867.79 4,000.00 (2,132.21) 4,800.00 2,932.21 61.1%65-CH-UTILITIES6507836 Utilities-Natural Gas426.49 300.00 126.49 4,030.13 3,000.00 1,030.13 3,600.00 (430.13) -11.9%6507840 Utilities-Telephone1,179.55 1,150.00 29.55 11,232.34 11,500.00 (267.66) 13,800.00 2,567.66 18.6%6507842 Utilities-Water356.21 321.00 35.21 3,777.12 3,210.00 567.12 3,852.00 74.88 1.9%6507844 Utilities-Cable336.91 340.00 (3.09) 3,368.98 3,400.00 (31.02) 4,080.00 711.02 17.4%Total-CH-UTILITIES 2,299.16 2,111.00 188.16 22,408.57 21,110.00 1,298.57 25,332.00 2,923.43 11.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 16,425.00 18,850.00 (2,425.00) 22,500.00 6,075.00 27.0%6509099 Contract Services-Security4,565.04 4,900.00 (334.96) 54,361.12 50,600.00 3,761.12 60,400.00 6,038.88 10.0%6509215 Flowers & Decorations- - - - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 616.89 2,000.00 (1,383.11) 2,400.00 1,783.11 74.3%6509718 Safety Equipment & Training- 100.00 (100.00) 127.19 1,000.00 (872.81) 1,200.00 1,072.81 89.4%Total-CH-OTHER EXPENSES 6,390.04 7,025.00 (634.96) 71,530.20 74,450.00 (2,919.80) 88,900.00 17,369.80 19.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures304.58 300.00 4.58 5,852.19 3,000.00 2,852.19 3,600.00 (2,252.19) -62.6%6515686 CH-R&M-Restaurant Repairs260.00 400.00 (140.00) 1,346.01 4,000.00 (2,653.99) 4,800.00 3,453.99 72.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,862.37 4,000.00 (1,137.63) 4,800.00 1,937.63 40.4%Total-CH-REPAIRS & MAINTENANCE 564.58 1,100.00 (535.42) 10,060.57 11,000.00 (939.43) 13,200.00 3,139.43 23.8%10,220.53 10,636.00 (415.47) 105,867.13 110,560.00 (4,692.87) 132,232.00 6,278.86 4.7%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementApril 2012Annual Budget7 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 3,167.82 3,310.00 (142.18) 3,972.00 804.18 20.2%6601325 Insurance-Workers Comp 180.55 103.00 77.55 1,591.48 1,030.00 561.48 1,240.00 (351.48) -28.3%6601720 Salaries 2,111.72 2,508.00 (396.28) 22,451.03 25,080.00 (2,628.97) 30,096.00 7,644.97 25.4%6601800 Taxes-Employer Payroll 223.89 287.00 (63.11) 2,711.37 2,870.00 (158.63) 3,446.00 734.63 21.3%Total-MKT-SALARIES & BENEFITS 2,885.94 3,229.00 (343.06) 29,921.70 32,290.00 (2,368.30) 38,754.00 8,832.30 22.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 506.03 1,000.00 (493.97) 1,200.00 693.97 57.8%6603768 Supplies-Printing & Stationery 2,254.80 125.00 2,129.80 6,527.80 4,175.00 2,352.80 4,425.00 (2,102.80) -47.5%2,254.80 225.00 2,029.80 7,033.83 5,175.00 1,858.83 5,625.00 (1,408.83) -25.0%66-MKT-UTILITIES6607840 Utilities-Telephone 105.66 100.00 5.66 866.10 1,000.00 (133.90) 1,200.00 333.90 27.8%Total-MKT-UTILITIES 105.66 100.00 5.66 866.10 1,000.00 (133.90) 1,200.00 333.90 27.8%66-MKT-OTHER EXPENSES6609010 Advertising 19,793.31 18,230.00 1,563.31 144,441.70 172,157.00 (27,715.30) 185,731.00 41,289.30 22.2%6609040 Business Meals - 25.00 (25.00) - 250.00 (250.00) 300.00 300.00 100.0%6609080 Collateral Material 731.48 500.00 231.48 7,043.27 7,500.00 (456.73) 9,000.00 1,956.73 21.7%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 990.00 4,000.00 (3,010.00) 4,800.00 3,810.00 79.4%6609490 Miscellaneous - 50.00 (50.00) 143.29 300.00 (156.71) 350.00 206.71 59.1%6609620 Postage - 50.00 (50.00) 430.86 500.00 (69.14) 600.00 169.14 28.2%6609630 Promotion - 50.00 (50.00) 32.33 600.00 (567.67) 3,500.00 3,467.67 0.0%6609633 Promotion-Community 358.00 75.00 283.00 442.05 2,775.00 (2,332.95) 2,925.00 2,482.95 84.9%6609634 Promotion-Media/Vendor - - - 465.00 3,500.00 (3,035.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 368.08 735.00 (366.92) 735.00 366.92 49.9%6609820 Uniforms 108.62 50.00 58.62 922.34 600.00 322.34 600.00 (322.34) -53.7%Total-MKT-OTHER EXPENSES 21,090.41 19,430.00 1,660.41 155,278.92 192,917.00 (37,638.08) 209,241.00 53,727.08 25.7%26,336.81 22,984.00 3,352.81 193,100.55 231,382.00 (38,281.45) 254,820.00 61,484.45 24.1%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementApril 2012Annual Budget8 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.11 1,458.00 344.11 22,252.98 14,580.00 7,672.98 17,496.00 (4,756.98) -27.2%6701325 Insurance-Workers Comp602.40 707.00 (104.60) 5,555.12 7,070.00 (1,514.88) 8,480.00 2,924.88 34.5%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 144,448.57 148,333.40 (3,884.83) 178,000.00 33,551.43 18.8%6701800 Taxes-Employer Payroll 1,199.66 1,964.00 (764.34) 13,804.91 19,640.00 (5,835.09) 23,568.00 9,763.09 41.4%6701880 Wages-Hourly2,265.63 2,319.66 (54.03) 19,988.23 23,196.60 (3,208.37) 27,835.00 7,846.77 28.2%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 19,286.06 21,282.00 (1,995.94) 206,060.69 212,820.00 (6,759.31) 255,379.00 49,318.31 19.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,030.52 400.00 630.52 2,921.99 4,000.00 (1,078.01) 5,200.00 2,278.01 43.8%6703762 Supplies-Office - 100.00 (100.00) 899.71 1,000.00 (100.29) 1,200.00 300.29 25.0%6703768 Supplies-Printing & Stationery248.73 400.00 (151.27) 765.62 2,500.00 (1,734.38) 3,300.00 2,534.38 76.8%Total-G&A-SUPPLIES & MATERIALS 1,279.25 900.00 379.25 4,587.32 7,500.00 (2,912.68) 9,700.00 5,112.68 52.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 228.47 900.00 (671.53) 1,100.00 871.53 79.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 228.47 900.00 (671.53) 1,100.00 871.53 79.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%6709150 Dues & Subscriptions- 50.00 (50.00) 491.17 1,150.00 (658.83) 1,700.00 1,208.83 71.1%6709180 Employee Recruiting/Relocation60.00 - 60.00 853.35 1,400.00 (546.65) 1,400.00 546.65 39.0%6709197 Equipment Rental562.45 480.00 82.45 6,030.75 4,800.00 1,230.75 5,760.00 (270.75) -4.7%6709202 Fees-Bank45.46 90.00 (44.54) 804.07 900.00 (95.93) 1,080.00 275.93 25.5%6709208 Fees-Payroll Processing1,120.78 1,100.00 20.78 11,162.16 11,000.00 162.16 13,200.00 2,037.84 15.4%6709220 Freight/Delivery- 50.00 (50.00) - 500.00 (500.00) 600.00 600.00 100.0%6709490 Miscellaneous 100.00 100.00 - 576.48 1,000.00 (423.52) 1,200.00 623.52 52.0%6709620 Postage/Mail Services - 75.00 (75.00) 800.22 750.00 50.22 900.00 99.78 11.1%6709625 Professional Fees1,380.43 850.00 530.43 8,805.23 8,500.00 305.23 10,200.00 1,394.77 13.7%6709636 Promotion/Entertainment- 100.00 (100.00) 3,000.00 2,900.00 100.00 3,100.00 100.00 3.2%6709722 Seminars & Training- 200.00 (200.00) 1,348.61 2,000.00 (651.39) 2,400.00 1,051.39 43.8%6709810 Travel - 200.00 (200.00) 224.38 400.00 (175.62) 1,100.00 875.62 79.6%6709820 Uniforms 133.86 75.00 58.86 899.32 900.00 (0.68) 1,050.00 150.68 14.4%Total-G&A-OTHER EXPENSES 3,802.98 3,770.00 32.98 38,995.74 40,200.00 (1,204.26) 48,490.00 9,494.26 19.6%24,368.29 26,052.00 (1,683.71) 249,872.22 261,420.00 (11,547.78) 314,669.00 64,796.78 20.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementApril 2012Annual Budget9 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 115,399.40 120,750.00 (5,350.60) 144,900.00 29,500.60 20.4%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 5,053.86 6,000.00 (946.14) 7,200.00 2,146.14 29.8%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 56,152.02 57,550.00 (1,397.98) 69,060.00 12,907.98 18.7%6800197 Equipment Leases-Others 1,203.00 1,160.00 43.00 18,790.94 11,600.00 7,190.94 13,920.00 (4,870.94) 0.0%18,633.79 19,590.00 (956.21) 195,396.22 195,900.00 (503.78) 235,080.00 39,683.78 16.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (63.93) (5,060.00) 4,996.07 60,417.38 66,602.00 (6,184.62) 90,000.00 29,582.62 32.9%6900210 FF&E Reserve 8,658.13 9,268.00 (609.87) 57,942.39 57,269.00 673.39 66,540.00 8,597.61 12.9%6900800 Personal Property Taxes 382.85 - 382.85 14,268.17 14,800.00 (531.83) 14,800.00 531.83 3.6%6900323 Insurance-Commercial 2,475.07 2,200.00 275.07 24,173.99 22,000.00 2,173.99 26,400.00 2,226.01 8.4%11,452.12 6,408.00 5,044.12 156,801.93 160,671.00 (3,869.07) 197,740.00 40,938.07 20.7%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementApril 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia5662SalesPromotion1134Golf Industry4VIPCelebrity2PGA Comp37 1055337Charity/Gift Certificate823420Rain/Wind Checks4137Club Staff150 926659LQ HS Golf48 177 199 197255 420 345 322 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012April 2012 Date Time Description CategoryPlayers4/1/2012 10:45 Dori Smith - Writer Desert Entertainer Media 212