Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07 January 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2009 – January 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 January Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 240,650.40 221,094.00 19,556.40 8.8% 1,233,370.56 1,135,231.00 98,139.56 2,980,503.00 1,747,132.44 41%401000 Miscellaneous Golf Revenue 15,449.68 8,625.00 6,824.68 79.1% 68,268.53 55,290.00 12,978.53 109,297.00 41,028.47 62%410000 Revenue-Golf Shop 37,472.31 35,000.00 2,472.31 7.1% 125,538.36 132,702.00 (7,163.64) 325,551.00 200,012.64 39%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 7,500.00 7,500.00 - 12,000.00 4,500.00 63%890000 Interest Income 4.26 - 4.26 0.0% 36.26 - 36.26 - (36.26) 0%Total Income295,076.65 266,219.00 28,857.65 10.8% 1,434,713.71 1,330,723.00 103,990.71 3,427,351.00 1,992,637.29 42%Cost of Goods Sold510000 COS-Golf Shop 20,470.77 18,576.00 1,894.77 -10.2% 70,414.44 70,431.10 16.66 172,786.05 102,371.61 41%Total COS20,470.77 18,576.00 1,894.77 -10.2% 70,414.44 70,431.10 16.66 172,786.05 102,371.61 41%Gross Profit274,605.88 247,643.00 26,962.88 10.9% 1,364,299.27 1,260,291.90 104,007.37 3,254,564.95 1,890,265.68 42%Expenses610000 Golf Pro Shop 20,888.01 23,191.00 2,302.99 9.9% 110,073.55 135,600.00 25,526.45 243,485.00 133,411.45 45%630000 Course Maintenance 108,723.33 116,774.00 8,050.67 6.9% 961,913.11 1,017,458.00 55,544.89 1,594,579.00 632,665.89 60%633000 Maintenance Water & Energy (5,767.97) 7,504.00 13,271.97 176.9% 38,832.23 51,963.00 13,130.77 86,871.00 48,038.77 45%640000 Outside Services 32,325.08 29,060.00 (3,265.08) -11.2% 157,325.84 160,609.00 3,283.16 277,000.00 119,674.16 57%650000 Clubhouse 9,514.35 11,142.00 1,627.65 14.6% 76,582.45 70,194.00 (6,388.45) 118,900.00 42,317.55 64%660000 Marketing 31,141.75 35,442.00 4,300.25 12.1% 136,946.17 150,349.00 13,402.83 256,759.00 119,812.83 53%670000 General & Administrative27,679.98 28,812.00 1,132.02 3.9% 156,372.57 184,984.00 28,611.43 316,394.00 160,021.43 49%680000 Leases 7,905.58 34,581.00 26,675.42 77.1% 240,777.31 259,299.00 18,521.69 432,204.00 191,426.69 56%690000 Miscellaneous Other Expense 15,853.84 7,539.00 (8,314.84) -110.3% 134,619.95 151,579.00 16,959.05 211,610.00 76,990.05 64%Total Expenses248,263.95 294,045.00 45,781.05 15.6% 2,013,443.18 2,182,035.00 168,591.82 3,537,802.00 1,524,358.82 57%26,341.93 (46,402.00) 72,743.93 156.8%(649,143.91) (921,743.10) 272,599.19 (283,237.05) 365,906.86 229%Rounds of Golf PlayedPaid Rounds Played 2,726 2,500 226 9.0% 20,074 17,500 2,574 39,150 19,076 51%Ave $ Per Paid Round Green Fee 88.28 88.44 (0.16) -0.2% 61.44 64.87 (3.43) 76.13 14.69 81%Ave $ Per Paid Round Merchandise 13.75 14.00 (0.25) -1.8% 6.25 7.58 (1.33) 8.07 1.82 77%Ave $ Per Paid Miscellaneous 5.67 3.45 2.22 64.3% 3.40 3.16 0.24 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJanuary 20101 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 240,650.40 221,094.00 19,556.40 1,233,370.56 1,135,231.00 98,139.56 2,980,503.001,747,132.4441%4010000 Rider Fee 625.00 250.00 375.00 5,425.00 3,664.00 1,761.00 5,829.00404.0093%4040000 Club Rental 1,370.00 1,375.00 (5.00) 9,655.00 9,626.00 29.00 26,168.0016,513.0037%4050000 Driving Range 6,767.00 2,500.00 4,267.00 27,183.00 17,500.00 9,683.00 44,300.0017,117.0061%4060000 Handicap Fees 730.00 1,000.00 (270.00) 7,280.00 7,000.00 280.00 8,000.00 720.0091%4080000 GPS Advertising - 1,000.00 (1,000.00) - 10,000.00 (10,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract 1,682.68 1,000.00 682.68 3,587.28 3,000.00 587.28 4,000.00 412.7290%4091000 Golf Professional Rental Fee 4,275.00 1,500.00 2,775.00 14,275.00 4,500.00 9,775.00 9,000.00 -5,275.00 159%4092000 Golf Lessons - - - 863.25 - 863.25 - (863.25) 0% Total Revenue Fees 256,100.08 229,719.00 26,381.08 1,301,639.09 1,190,521.00 111,118.09 3,089,800.00 1,788,160.91 42%256,100.08 229,719.00 26,381.08 1,301,639.09 1,190,521.00 111,118.09 3,089,800.00 1,788,160.91 42%SilverRock ResortStatement of Fees RevenueJanuary 2010Total IncomeMonth to Date Year to Date Annual Budget2 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 435.20 - 435.20 2,578.41 - 2,578.41 0 04100110 Sales Hard Goods 10,782.64 12,250.00 (1,467.36) 46,077.38 46,446.00 (368.62) 113,943.00 67,865.62 40%4100112 Sales-Soft Goods 29,978.92 22,750.00 7,228.92 94,887.02 86,256.00 8,631.02 211,608.00 116,720.98 45%5100639 GS-Discounts-Mdse (3,724.45) - (3,724.45) (18,004.45) - (18,004.45) - 18,004.45 0% Total Revenue Golf Shop 37,472.31 35,000.00 2,472.31 125,538.36 132,702.00 (7,163.64) 325,551.00 202,591.05 38%COS 5100150 COS-GS-Hard Goods 4,520.85 6,737.50 (2,216.65) 22,034.05 25,545.30 (3,511.25) 62,668.65 40,634.60 35%5100151 COS-GS-Soft Goods 14,372.41 12,512.50 1,859.91 45,434.60 47,440.80 (2,006.20) 116,384.40 70,949.80 39%5100152 COS-GS-Purchase Disc (25.00) (963.00) 938.00 (475.28) (3,651.00) 3,175.72 (8,953.00) (8,477.72) -5%5100220 COS-GS-Freight Merch 1,602.51 289.00 1,313.51 3,421.07 1,096.00 2,325.07 2,686.00 (735.07) 127%Cost of Sales - Golf Shop 20,470.77 18,576.00 1,894.77 70,414.44 70,431.10 (16.66) 172,786.05 102,371.61 41%Gross Profit 17,001.54 16,424.00 577.54 55,123.92 62,270.90 (7,146.98) 152,764.95 100,219.44 34%COS % 54.6% 53.1% -1.6% 56.1% 53.1% -3.0% 53.1% 50.5% 5%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 3,060.00 3,060.00 - 5,400.00 2,340.00 57%6101320 Insurance Group 2,317.00 2,317.00 - 15,004.37 15,226.00 (221.63) 26,811.00 11,806.63 56%6101325 Insurance-Workers Comp 482.79 863.00 (380.21) 2,961.41 5,093.00 (2,131.59) 9,229.00 6,267.59 32%6101720 Salaries 3,959.10 3,582.00 377.10 25,409.13 25,074.00 335.13 20,796.00 (4,613.13) 122%6101800 Taxes-Employer Payroll 2,136.07 1,882.00 254.07 7,087.34 11,104.00 (4,016.66) 20,123.00 13,035.66 35%6101880 Wages-Hourly 9,568.40 11,532.00 (1,963.60) 46,552.94 64,113.00 (17,560.06) 140,831.00 94,278.06 33%6101882 Wages-Overtime 266.45 - 266.45 781.89 - 781.89 - 952.88 0%Total -PS-SALARIES & BENEFITS 19,209.81 20,656.00 (1,446.19) 100,857.08 123,670.00 (22,812.92) 223,190.00 124,067.69 44%61-PS OTHER EXPENSES6103762 Supplies-Office 611.83 150.00 461.83 1,648.70 2,150.00 (501.30) 2,950.00 1,301.30 56%6109090 Contract Services 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 58%6109220 Freight & Delivery 221.39 - 221.39 473.36 75.00 398.36 75.00 (398.36) 631%6109490 Miscellaneous 8.66 50.00 (41.34) 187.11 200.00 (12.89) 450.00 262.89 42%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 4.94 - 4.94 37.01 - 37.01 - (37.01) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 206.00 4,100.00 (3,894.00) 5,490.00 5,284.00 4%6109810 Travel - Merchandise - 15.00 (15.00) - 15.00 (15.00) 90.00 90.00 0%6109820 Uniforms 87.00 500.00 (413.00) 985.44 1,400.00 (414.56) 2,400.00 1,414.56 41%6117840 Telephones 244.38 70.00 174.38 1,748.06 490.00 1,258.06 840.00 (908.06) 0%Total PS-OTHER EXPENSES 1,678.20 2,535.00 (856.80) 9,216.47 11,930.00 (2,713.53) 20,295.00 11,078.53 45%20,888.01 23,191.00 (2,302.99) 110,073.55 135,600.00 (25,526.45) 243,485.00 135,146.22 44%Net Income(3,886.47) (6,767.00) 2,880.53 (54,949.63) (73,329.10) 18,379.47 (90,720.05) (34,926.78) -62%SilverRock ResortGolf Shop Income StatementJanuary 2010Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,620.00 1,680.00 (60.00) 2,880.00 1,260.00 43.8%6311320 Insurance-Group 8,740.00 8,740.00 - 62,188.62 61,180.00 1,008.62 104,880.00 42,691.38 40.7%6311325 Insurance-Workers Comp 2,118.34 3,226.00 (1,107.66) 15,865.32 23,092.00 (7,226.68) 39,329.00 23,463.68 59.7%6311720 Salaries 12,285.12 12,331.00 (45.88) 78,844.80 86,317.00 (7,472.20) 147,972.00 69,127.20 46.7%6311800 Taxes-Employer Payroll 7,002.08 7,033.00 (30.92) 33,255.29 50,903.00 (17,647.71) 86,420.00 53,164.71 61.5%6311880 Wages-Hourly 48,112.93 44,159.00 3,953.93 297,758.37 309,113.00 (11,354.63) 529,928.00 232,169.63 43.8%6311882 Wages-Overtime 126.07 - 126.07 10,157.84 13,426.00 (3,268.16) 16,234.00 6,076.16 37.4%Total-CM-SALARIES & BENEFITS78,624.54 75,729.00 2,895.54 499,690.24 545,711.00 (46,020.76) 927,643.00 427,952.76 46.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 604.67 2,000.00 (1,395.33) 23,095.25 20,900.00 2,195.25 29,300.00 6,204.75 21.2%6313744 Fertilizer 500.00 5,500.00 (5,000.00) 75,453.60 64,200.00 11,253.60 92,200.00 16,746.40 18.2%6313745 Herbicides - - - 6,233.94 10,000.00 (3,766.06) 10,000.00 3,766.06 37.7%6313746 Flowers/Plants - 950.00 (950.00) 1,778.05 3,200.00 (1,421.95) 3,500.00 1,721.95 49.2%6313748 Fuel-Gasoline 3,975.72 2,950.00 1,025.72 25,270.55 27,680.00 (2,409.45) 43,100.00 17,829.45 41.4%6313750 Golf Course Accessories 45.03 200.00 (154.97) 12,987.65 7,500.00 5,487.65 8,000.00 (4,987.65) -62.3%6313756 POA Control - 3,500.00 (3,500.00) 7,699.19 7,000.00 699.19 7,000.00 (699.19) -10.0%6313758 Miscellaneous Supp 712.86 100.00 612.86 3,817.41 3,850.00 (32.59) 4,350.00 532.59 0.0%6313762 Supplies-Office 64.66 - 64.66 450.78 - 450.78 - (450.78) 0.0%6313774 Sand - 380.00 (380.00) 5,683.93 10,960.00 (5,276.07) - (5,683.93) 0.0%6313775 Sand-Bunkers - - - 2,300.69 - 2,300.69 11,460.00 9,159.31 79.9%6313776 Seed - 350.00 (350.00) 88,921.88 90,060.00 (1,138.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip 152.03 100.00 52.03 3,742.48 4,500.00 (757.52) 5,000.00 1,257.52 25.2%6313780 Sod - 500.00 (500.00) 9,039.15 4,250.00 4,789.15 5,750.00 (3,289.15) -57.2%6313782 Topdressing - - - 3,642.00 5,000.00 (1,358.00) 7,600.00 3,958.00 52.1%Total-CM-SUPPLIES & MATERIALS6,054.97 16,530.00 (10,475.03) 270,116.55 259,100.00 11,016.55 319,070.00 48,953.45 15.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,246.99 500.00 746.99 12,918.19 9,500.00 3,418.19 17,000.00 4,081.81 24.0%6315685 CM-R&M-Bldngs & Othr Structures 172.00 250.00 (78.00) 1,390.98 1,000.00 390.98 1,750.00 359.02 20.5%6315690 CM-R&M-Equipment 842.23 1,500.00 (657.77) 26,602.42 28,200.00 (1,597.58) 35,700.00 9,097.58 25.5%6315692 CM-R&M-Irrigation System 1,268.48 1,200.00 68.48 13,468.86 11,050.00 2,418.86 16,050.00 2,581.14 16.1%6315696 CM-R&M-Pumps 605.89 1,000.00 (394.11) 6,904.54 7,000.00 (95.46) 10,500.00 3,595.46 34.2%6315815 CM-R&M-Trees-Pruning Etc 96.34 - 96.34 3,431.93 4,050.00 (618.07) 10,050.00 6,618.07 65.9%Total-CM-REPAIRS & MAINTENANCE 4,231.93 4,450.00 (218.07) 64,716.92 60,800.00 3,916.92 91,050.00 26,333.08 28.9%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 36.39 - 36.39 (36.39) 0.0%6317836 Utilities-Natural Gas/LPG 28.60 50.00 (21.40) 28.60 350.00 (321.40) 600.00 571.40 0.0%6317840 Telephones 1,632.02 850.00 782.02 6,450.39 5,950.00 500.39 10,200.00 3,749.61 36.8%Total-CM-UTILITIES 1,666.00 900.00 766.00 6,515.38 6,300.00 215.38 10,800.00 4,284.62 39.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 41.7%6319099 Contract Svcs-Security Bldgs - - - 210.00 - 210.00 (210.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 487.83 524.00 (36.17) 3,902.64 3,668.00 234.64 6,288.00 2,385.36 0.0%6319150 Dues & Subscriptions - - - 18.00 400.00 (382.00) 900.00 882.00 98.0%6319170 Employee Education - 50.00 (50.00) - 350.00 (350.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 200.00 (200.00) 2,966.74 3,300.00 (333.26) 4,200.00 1,233.26 29.4%6319206 Licenses & Permits 114.05 - 114.05 570.25 280.00 290.25 680.00 109.75 16.1%6319490 Miscellaneous - 100.00 (100.00) 439.92 700.00 (260.08) 1,200.00 760.08 63.3%6319718 Safety Equipment & Training 452.73 200.00 252.73 3,129.20 1,900.00 1,229.20 2,600.00 (529.20) -20.4%6319822 Uniforms 910.13 820.00 90.13 6,891.02 5,740.00 1,151.02 9,840.00 2,948.98 30.0%Total-CM-OTHER EXPENSES 2,464.74 2,394.00 70.74 23,127.77 21,838.00 1,289.77 37,258.00 14,130.23 37.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJanuary 2010Annual Budget4 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 14,439.75 16,219.00 (1,779.25) 27,804.00 13,364.25 48.1%6321325 Insurance-Workers Comp 393.76 669.00 (275.24) 2,973.24 4,853.00 (1,879.76) 8,229.00 5,255.76 63.9%6321800 Taxes-Employer Payroll 1,521.43 1,458.00 63.43 6,259.07 10,762.00 (4,502.93) 18,154.00 11,894.93 65.5%6321880 Wages-Hourly 11,250.22 11,712.00 (461.78) 70,495.93 81,984.00 (11,488.07) 140,544.00 70,048.07 49.8%6321882 Wages-Overtime - - - 2,199.39 4,461.00 (2,261.61) 5,272.00 3,072.61 58.3%Total-CM-LM-SALARIES & BENEFITS15,482.41 16,156.00 (673.59) 96,367.38 118,279.00 (21,911.62) 200,003.00 103,635.62 51.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 89.11 650.00 (560.89) 1,025.00 935.89 91.3%6323788 Uniforms 198.74 290.00 (91.26) 1,289.76 2,030.00 (740.24) 3,480.00 2,190.24 62.9%Total-CM-LM-SUPPLIES & MATERIALS198.74 365.00 (166.26) 1,378.87 2,680.00 (1,301.13) 4,505.00 3,126.13 69.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) - 2,750.00 (2,750.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) - 2,750.00 (2,750.00) 4,250.00 4,250.00 100.0%108,723.33 116,774.00 (8,050.67) 961,913.11 1,017,458.00 (55,544.89) 1,594,579.00 632,665.89 39.7% January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,138.29 6,000.00 (3,861.71) 16,358.70 38,000.00 (21,641.30) 65,000.00 48,641.30 74.8%6337842 Utilities-Water(7,906.26) 1,504.00 (9,410.26) 22,473.53 13,963.00 8,510.53 21,871.00 (602.53) -2.8%(5,767.97) 7,504.00 (13,271.97) 38,832.23 51,963.00 (13,130.77) 86,871.00 48,038.77 55.3%Silverrock ResortCourse Maintenance Expense StatementJanuary 2010Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyJanuary 2010Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 720.00 720.00 - 3,840.00 3,840.00 - 6,960.00 3,120.00 44.8%6411320 Insurance-Group 662.00 662.00 - 3,245.60 4,634.00 (1,388.40) 7,944.00 4,698.40 59.1%6411325 Insurance-Workers Comp 444.72 1,958.00 (1,513.28) 2,456.62 8,577.00 (6,120.38) 16,162.00 13,705.38 84.8%6411800 Taxes-Employer Payroll 1,631.34 1,698.00 (66.66) 6,639.13 7,438.00 (798.87) 14,012.00 7,372.87 52.6%6411880 Wages-Hourly 12,697.75 13,635.00 (937.25) 60,568.31 59,736.00 832.31 112,549.00 51,980.69 46.2%6411882 Wages-Overtime 8.63 - 8.63 633.02 - 633.02 - (633.02) 0.0%Total-CBR-SALARIES & BENEFITS16,164.44 18,673.00 (2,508.56) 77,382.68 84,225.00 (6,842.32) 157,627.00 80,244.32 50.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 110.44 75.00 35.44 1,438.25 2,075.00 (636.75) 2,350.00 911.75 38.8%6413742 Supplies-Expendable 1,013.94 150.00 863.94 4,500.22 2,700.00 1,800.22 5,000.00 499.78 10.0%6413752 Supplies-Range Balls - - - 5,143.75 6,000.00 (856.25) 6,000.00 856.25 14.3%6413762 Supplies-Office - 50.00 (50.00) - 275.00 (275.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 180.65 70.00 110.65 420.00 239.35 57.0%6413786 Supplies-Towels - 72.00 (72.00) 1,650.27 532.00 1,118.27 892.00 (758.27) -85.0%6413796 Supplies-Bottled Water205.10 400.00 (194.90) 14,543.26 17,400.00 (2,856.74) 19,400.00 4,856.74 25.0%Total-CBR-SUPPLIES & MATERIALS1,329.48 817.00 512.48 27,456.40 29,052.00 (1,595.60) 34,587.00 7,130.60 20.6%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 1,063.44 720.00 343.44 5,383.44 5,040.00 343.44 8,640.00 3,256.56 37.7%6415690 CBR-R&M-Equipment 463.00 300.00 163.00 1,779.83 2,100.00 (320.17) 3,600.00 1,820.17 50.6%6415695 CBR-R&M-Cart Maintenance & Repair 473.55 250.00 223.55 3,429.04 2,750.00 679.04 4,000.00 570.96 14.3%Total-CBR-REPAIRS & MAINTENANCE 1,999.99 1,270.00 729.99 10,592.31 9,890.00 702.31 16,240.00 5,647.69 34.8%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 4,050.00 1,000.00 3,050.00 4,945.00 3,350.00 1,595.00 5,000.00 55.00 1.1%6419094 Contract Services-Laundry/Linen 1,530.93 500.00 1,030.93 5,418.40 3,500.00 1,918.40 6,000.00 581.60 9.7%6419220 Freight/Delivery - 75.00 (75.00) - 525.00 (525.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 640.42 575.00 65.42 1,150.00 509.58 44.3%6419820 Uniforms - - - 2,817.06 3,000.00 (182.94) 5,625.00 2,807.94 49.9%Total-CBR-OTHER EXPENSES 5,580.93 1,650.00 3,930.93 13,820.88 10,950.00 2,870.88 18,675.00 4,854.12 26.0%TOTAL-CARTS,BAGROOM & RANGE 25,074.84 22,410.00 2,664.84 129,252.27 134,117.00 (4,864.73) 227,129.00 97,876.73 43.1%643-CS-SALARIES & BENEFITS6431175 Employee Meals 420.00 420.00 - 1,740.00 1,740.00 - 3,300.00 1,560.00 47.3%6431325 Insurance-Workers Comp 200.21 288.00 (87.79) 834.04 1,081.00 (246.96) 2,069.00 1,234.96 59.7%6431800 Taxes-Employer Payroll 795.49 627.00 168.49 2,651.17 2,361.00 290.17 4,512.00 1,860.83 41.2%6431880 Wages-Hourly 5,714.42 5,040.00 674.42 21,109.67 18,960.00 2,149.67 36,240.00 15,130.33 41.8%6431882 Wages-Overtime 6.00 - 6.00 24.00 - 24.00 - (24.00) 0.0%Total-CS-SALARIES & BENEFITS7,136.12 6,375.00 761.12 26,358.88 24,142.00 2,216.88 46,121.00 19,762.12 42.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 86.90 600.00 (513.10) 1,050.00 963.10 91.7%6439490 Miscellaneous 114.12 50.00 64.12 114.12 200.00 (85.88) 200.00 85.88 42.9%6439718 Safety Equipment & Training - 50.00 (50.00) 464.47 350.00 114.47 600.00 135.53 22.6%6439820 Uniforms - 75.00 (75.00) 1,049.20 1,200.00 (150.80) 1,900.00 850.80 44.8%Total-CS-OTHER EXPENSES 114.12 275.00 (160.88) 1,714.69 2,350.00 (635.31) 3,750.00 2,035.31 54.3%Total-COURSE SERVICES 7,250.24 6,650.00 600.24 28,073.57 26,492.00 1,581.57 49,871.00 21,797.43 43.7%32,325.08 29,060.00 3,265.08 157,325.84 160,609.00 (3,283.16) 277,000.00 117,638.85 42.5%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJanuary 2010Annual Budget6 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 270.43 2,800.00 (2,529.57) 4,800.00 4,529.57 94.4%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 270.43 2,800.00 (2,529.57) 4,800.00 4,529.57 94.4%65-CH-UTILITIES6507836 Utilities-Natural Gas629.45 300.00 329.45 1,720.10 2,100.00 (379.90) 3,600.00 1,879.90 52.2%6507838 Utilities-Sewer- 200.00 (200.00) - 1,400.00 (1,400.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,090.53 1,000.00 90.53 7,918.58 7,000.00 918.58 12,000.00 4,081.42 34.0%6507842 Utilities-Water204.35 200.00 4.35 3,472.84 1,400.00 2,072.84 2,400.00 (1,072.84) -44.7%6507844 Utilities-Cable326.47 317.00 9.47 2,278.72 2,219.00 59.72 3,800.00 1,521.28 40.0%Total-CH-UTILITIES 2,250.80 2,017.00 233.80 15,390.24 14,119.00 1,271.24 24,200.00 8,809.76 36.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,930.00 1,825.00 105.00 13,495.00 13,375.00 120.00 22,500.00 9,005.00 40.0%6509098 Contract Services-Refuse Dispose291.34 - 291.34 2,415.72 - 2,415.72 - (2,415.72) 0.0%6509099 Contract Services-Security3,612.82 4,100.00 (487.18) 35,416.58 28,700.00 6,716.58 49,200.00 13,783.42 28.0%6509215 Flowers & Decorations- 1,500.00 (1,500.00) - 2,100.00 (2,100.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous342.60 200.00 142.60 594.39 1,400.00 (805.61) 2,400.00 1,805.61 75.2%6509718 Safety Equipment & Training214.29 100.00 114.29 688.15 700.00 (11.85) 1,200.00 511.85 42.7%Total-CH-OTHER EXPENSES 6,391.05 7,725.00 (1,333.95) 52,609.84 46,275.00 6,334.84 77,900.00 25,290.16 32.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures484.50 200.00 284.50 4,675.78 1,400.00 3,275.78 2,400.00 (2,275.78) -94.8%6515686 CH-R&M-Restaurant Repairs388.00 400.00 (12.00) 3,501.16 2,800.00 701.16 4,800.00 1,298.84 27.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 2,800.00 (2,665.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 872.50 1,000.00 (127.50) 8,311.94 7,000.00 1,311.94 12,000.00 3,688.06 30.7%9,514.35 11,142.00 (1,627.65) 76,582.45 70,194.00 6,388.45 118,900.00 7,376.12 6.2%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJanuary 2010Annual Budget7 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 420.00 420.00 - 720.00 300.00 41.7%6601320 Insurance-Group 331.00 331.00 - 2,226.12 2,317.00 (90.88) 3,972.00 1,745.88 44.0%6601325 Insurance-Workers Comp 87.50 143.00 (55.50) 728.30 1,001.00 (272.70) 1,713.00 984.70 57.5%6601720 Salaries 2,500.00 2,500.00 - 17,500.00 17,500.00 - 30,000.00 12,500.00 41.7%6601800 Taxes-Employer Payroll 311.00 311.00 - 2,177.00 2,177.00 - 3,735.00 1,558.00 41.7%Total-MKT-SALARIES & BENEFITS 3,289.50 3,345.00 (55.50) 23,051.42 23,415.00 (363.58) 40,140.00 17,088.58 42.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 140.15 700.00 (559.85) 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery 613.02 200.00 413.02 1,450.83 3,800.00 (2,349.17) 4,425.00 2,974.17 67.2%613.02 300.00 313.02 1,590.98 4,500.00 (2,909.02) 5,625.00 4,034.02 71.7%66-MKT-UTILITIES6607840 Utilities-Telephone 106.37 100.00 6.37 686.53 700.00 (13.47) 1,200.00 513.47 42.8%Total-MKT-UTILITIES 106.37 100.00 6.37 686.53 700.00 (13.47) 1,200.00 513.47 42.8%66-MKT-OTHER EXPENSES6609010 Advertising 25,022.36 27,937.00 (2,914.64) 108,120.23 104,349.00 3,771.23 185,984.00 77,863.77 41.9%6609040 Business Meals - 25.00 (25.00) 25.00 175.00 (150.00) 300.00 275.00 91.7%6609080 Collateral Material 2,011.50 2,500.00 (488.50) 2,174.61 6,000.00 (3,825.39) 9,000.00 6,825.39 75.8%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 768.00 1,225.00 (457.00) 2,100.00 1,332.00 63.4%6609490 Miscellaneous - 50.00 (50.00) 32.00 150.00 (118.00) 350.00 318.00 90.9%6609620 Postage - 50.00 (50.00) 263.98 350.00 (86.02) 600.00 336.02 56.0%6609630 Promotion - 300.00 (300.00) - 450.00 (450.00) 700.00 700.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 2,550.00 (2,550.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) 93.42 6,000.00 (5,906.58) 6,500.00 - 0.0%6609150 Dues and Subscriptions - 35.00 (35.00) 140.00 35.00 105.00 735.00 595.00 81.0%6609820 Uniforms - 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 27,132.86 31,697.00 (4,564.14) 111,617.24 121,734.00 (10,116.76) 209,794.00 91,770.18 43.7%31,141.75 35,442.00 (4,300.25) 136,946.17 150,349.00 (13,402.83) 256,759.00 113,406.25 44.2%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJanuary 2010Annual Budget8 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,260.00 1,260.00 - 2,160.00 900.00 41.7%6701320 Insurance-Group1,458.00 1,458.00 - 9,597.04 10,206.00 (608.96) 17,496.00 7,898.96 45.1%6701325 Insurance-Workers Comp584.97 981.00 (396.03) 4,371.44 6,867.00 (2,495.56) 11,772.00 7,400.56 62.9%6701720 Salaries 14,981.49 14,534.00 447.49 96,454.57 101,738.00 (5,283.43) 174,408.00 77,953.43 44.7%6701800 Taxes-Employer Payroll 1,852.93 2,140.00 (287.07) 8,602.97 14,980.00 (6,377.03) 25,680.00 17,077.03 66.5%6701880 Wages-Hourly1,726.88 2,654.00 (927.12) 9,897.06 18,578.00 (8,680.94) 31,848.00 21,950.94 68.9%6701882 Wages-Overtime 5.06 - 5.06 10.97 - 10.97 - (10.97) 0.0%Total-G&A-SALARIES & BENEFITS 20,789.33 21,947.00 (1,157.67) 130,194.05 153,629.00 (23,434.95) 263,364.00 133,169.95 50.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer437.41 2,000.00 (1,562.59) 1,636.57 6,800.00 (5,163.43) 10,800.00 9,163.43 84.8%6703762 Supplies-Office 330.97 125.00 205.97 1,372.78 875.00 497.78 1,500.00 127.22 8.5%6703768 Supplies-Printing & Stationery399.60 400.00 (0.40) 973.26 1,200.00 (226.74) 3,200.00 2,226.74 69.6%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 500.00 (500.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 1,167.98 2,625.00 (1,457.02) 3,982.61 9,375.00 (5,392.39) 16,400.00 12,417.39 75.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 297.97 700.00 (402.03) 1,200.00 902.03 75.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 297.97 700.00 (402.03) 1,200.00 902.03 75.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,800.00 2,800.00 - 4,800.00 2,000.00 41.7%6709150 Dues & Subscriptions- 150.00 (150.00) 110.00 700.00 (590.00) 1,500.00 1,390.00 92.7%6709180 Employee Recruiting/Relocation56.00 200.00 (144.00) 1,042.49 2,200.00 (1,157.51) 2,600.00 1,557.51 59.9%6709197 Equipment Rental666.13 350.00 316.13 3,725.89 2,450.00 1,275.89 4,200.00 474.11 11.3%6709202 Fees-Bank49.01 90.00 (40.99) 337.25 630.00 (292.75) 1,080.00 742.75 68.8%6709208 Fees-Payroll Processing1,309.42 550.00 759.42 5,471.18 3,850.00 1,621.18 6,600.00 1,128.82 17.1%6709220 Freight/Delivery85.97 50.00 35.97 195.65 350.00 (154.35) 600.00 404.35 67.4%6709490 Miscellaneous 107.18 100.00 7.18 812.27 700.00 112.27 1,200.00 387.73 32.3%6709620 Postage/Mail Services 228.80 75.00 153.80 842.61 525.00 317.61 900.00 57.39 6.4%6709625 Professional Fees820.16 400.00 420.16 3,245.20 2,800.00 445.20 4,800.00 1,554.80 32.4%6709636 Promotion/Entertainment2,000.00 1,500.00 500.00 2,134.78 2,100.00 34.78 2,600.00 465.22 17.9%6709722 Seminars & Training- 200.00 (200.00) 543.00 1,400.00 (857.00) 2,400.00 1,857.00 77.4%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 637.62 675.00 (37.38) 1,050.00 412.38 39.3%Total-G&A-OTHER EXPENSES 5,722.67 4,140.00 1,582.67 21,897.94 21,280.00 617.94 35,430.00 13,532.06 38.2%27,679.98 28,812.00 (1,132.02) 156,372.57 184,984.00 (28,611.43) 316,394.00 160,021.43 50.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJanuary 2010Annual Budget9 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,785.41 11,581.00 (2,795.59) 78,271.65 81,067.00 (2,795.35) 138,972.00 60,700.35 43.7%6800193 Equipment Leases-Course Maint (11,312.05) 15,000.00 (26,312.05) 80,381.49 114,000.00 (33,618.51) 189,000.00 108,618.51 57.5%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 3,808.50 4,200.00 (391.50) 7,200.00 3,391.50 47.1%6800195 Equipment Leases-Software 419.00 - 419.00 10,216.65 8,232.00 1,984.65 8,232.00 (1,984.65) -24.1%6800196 Equipment Leases-GPS 7,942.00 7,400.00 542.00 50,802.51 51,800.00 (997.49) 88,800.00 37,997.49 42.8%6800197 Equipment Leases-Others 1,531.22 - 1,531.22 17,296.51 - 17,296.51 - - 0.0%7,905.58 34,581.00 (26,675.42) 240,777.31 259,299.00 (18,521.69) 432,204.00 208,723.20 48.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 10,607.39 (383.00) 10,990.39 80,985.75 84,374.00 (3,388.25) 90,000.00 9,014.25 10.0%6900210 FF&E Reserve 4,813.01 4,422.00 391.01 24,667.42 22,705.00 1,962.42 59,610.00 34,942.58 58.6%6900800 Personal Property Taxes - - - 10,777.70 20,000.00 (9,222.30) 20,000.00 9,222.30 46.1%6900323 Insurance-Commercial 433.44 3,500.00 (3,066.56) 18,189.08 24,500.00 (6,310.92) 42,000.00 23,810.92 56.7%15,853.84 7,539.00 8,314.84 134,619.95 151,579.00 (16,959.05) 211,610.00 76,990.05 36.4%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementJanuary 2010Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia74 4Sales8PromotionGolf Industry81711 715VIPCelebrityPGA Comp70 68 67 9 44 62Charity/Gift Certificate14 10 4 20Rain/Wind Checks3 5 36 15Club Staff69 105 91 6 47 105LQ HS Golf39161 200 227 19 138 2252010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSales4PromotionGolf Industry26VIPCelebrityPGA Comp91Charity/Gift Certificate4Rain/Wind Checks9Club Staff63LQ HS Golf1970000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010January 2010 Date Time Description CategoryPlayers1/30/2010 10:45 John White - KESQ Sales 412