Loading...
07 January 2013 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2012 – January 2013 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 11 Complimentary Report 12 Annual BudgetAccount Description January Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue342,413.92 387,691.00 (45,277.08) -11.7% 1,265,693.81 1,376,763.00 (111,069.19) 3,350,773.00 2,085,079.19 38%401000 Miscellaneous Golf Revenue 56,139.80 19,425.00 36,714.80 189.0% 149,436.35 71,780.00 77,656.35 159,973.00 10,536.65 93%410000 Revenue-Golf Shop 22,676.93 35,251.00 (12,574.07) -35.7% 106,761.38 129,063.00 (22,301.62) 311,048.00 204,286.62 34%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 7,500.00 7,500.00 - 12,000.00 4,500.00 63%890000 Interest Income0.46 - 0.46 0.0% 4.79 - 4.79 - (4.79) 0%Total Income422,731.11 443,867.00 (21,135.89) -4.8% 1,529,396.33 1,585,106.00 (55,709.67) 3,833,794.00 2,304,397.67 40%Cost of Goods Sold510000 COS-Golf Shop 12,112.25 18,710.05 (6,597.80) 35.3% 58,055.58 68,500.65 10,445.07 165,088.40 107,032.82 35%Total COS12,112.25 18,710.05 (6,597.80) 35.3% 58,055.58 68,500.65 10,445.07 165,088.40 107,032.82 35%Gross Profit410,618.86 425,156.95 (14,538.09) -3.4% 1,471,340.75 1,516,605.35 (45,264.60) 3,668,705.60 2,197,364.85 40%Expenses610000 Golf Pro Shop 19,191.93 19,845.00 653.07 3.3% 116,915.25 119,987.00 3,071.75 212,986.00 96,070.75 55%630000 Course Maintenance140,956.20 131,178.00 (9,778.20) -7.5% 1,074,683.27 1,081,777.00 7,093.73 1,664,207.00 589,523.73 65%633000 Maintenance Water & Energy13,416.41 14,876.00 1,459.59 9.8% 125,112.54 119,226.00 (5,886.54) 221,749.00 96,636.46 56%640000 Outside Services29,055.84 27,326.00 (1,729.84) -6.3% 157,282.08 164,981.00 7,698.92 292,671.00 135,388.92 54%650000 Clubhouse 10,968.62 13,236.00 2,267.38 17.1% 73,296.55 78,152.00 4,855.45 132,232.00 58,935.45 55%660000 Marketing 12,057.15 27,959.00 15,901.85 56.9% 113,396.71 150,334.00 36,937.29 245,611.00 132,214.29 46%670000 General & Administrative28,463.45 25,911.00 (2,552.45) -9.9% 182,106.78 181,477.00 (629.78) 312,385.00 130,278.22 58%680000 Leases 16,662.45 18,890.00 2,227.55 11.8% 123,131.57 132,230.00 9,098.43 226,680.00 103,548.43 54%690000 Miscellaneous Other Expense9,557.01 14,441.00 4,883.99 33.8% 129,774.72 146,159.00 16,384.28 198,215.00 68,440.28 65%Total Expenses280,329.06 293,662.00 13,332.94 4.5% 2,095,699.47 2,174,323.00 78,623.53 3,506,736.00 1,411,036.53 60%130,289.80 131,494.95 (1,205.15) -0.9%(624,358.72) (657,717.65) 33,358.93 161,969.60 786,328.32 -385%Rounds of Golf PlayedPaid Rounds Played 4,588 4,700 (112) -2.4% 22,016 22,100 (84) 45,625 23,609 48%Ave $ Per Paid Round Green Fee74.63 82.49 (7.85) -9.5% 57.49 62.30 (4.81) 73.44 15.95 78%Ave $ Per Paid Round Merchandise4.94 7.50 (2.56) -34.1% 4.85 5.84 (0.99) 6.82 1.97 71%Ave $ Per Paid Miscellaneous 12.24 4.13 8.10 196.1% 6.79 3.25 3.54 3.51 (3.28) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJanuary 20131 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 342,413.92 387,691.00 (45,277.08) 1,265,693.81 1,376,763.00 (111,069.19) 3,350,773.002,085,079.1938%4010000 Rider Fee 925.00 1,175.00 (250.00) 4,770.00 3,500.00 1,270.00 7,643.002,873.0062%4040000 Club Rental 1,619.00 2,350.00 (731.00) 8,924.00 11,050.00 (2,126.00) 23,325.0014,401.0038%4050000 Driving Range 12,915.00 9,400.00 3,515.00 37,934.00 37,330.00 604.00 85,405.0047,471.0044%4060000 Handicap Fees 2,020.00 - 2,020.00 2,020.00 - 2,020.00 0.000.000%4080000 GPS Advertising - 500.00 (500.00) - 1,900.00 (1,900.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract 1,480.80 1,000.00 480.80 3,976.70 3,000.00 976.70 4,000.00 23.3099%4091000 Golf Professional Rental Fee 6,100.00 5,000.00 1,100.00 16,550.00 15,000.00 1,550.00 37,000.00 20,450.00 45%4092000 Golf Lessons - - - 591.65 - 591.65 - (591.65) 0%4093000 Resident Card Issue 31,080.00 - 31,080.00 74,670.00 - 74,670.00 - - 0% Total Revenue Fees 398,553.72 407,116.00 (8,562.28) 1,415,130.16 1,448,543.00 (33,412.84) 3,510,746.00 2,172,305.84 38%398,553.72 407,116.00 (8,562.28) 1,415,130.16 1,448,543.00 (33,412.84) 3,510,746.00 2,172,305.84 38%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueJanuary 20132 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 171.00 - 171.00 968.66 - 968.66 0 0 0%4100110 Sales Hard Goods 9,055.18 12,338.00 (3,282.82) 44,435.46 45,173.00 (737.54) 108,867.00 64,431.54 41%4100112 Sales-Soft Goods 16,529.48 22,913.00 (6,383.52) 77,926.93 83,890.00 (5,963.07) 202,181.00 124,254.07 39%5100639 GS-Discounts-Mdse (3,078.73) - (3,078.73) (16,569.67) - (16,569.67) - 16,569.67 0% Total Revenue Golf Shop 22,676.93 35,251.00 (12,574.07) 106,761.38 129,063.00 (22,301.62) 311,048.00 205,255.28 34%COS 5100150 COS-GS-Hard Goods 4,993.26 6,785.90 (1,792.64) 23,717.81 24,845.15 (1,127.34) 59,876.85 36,159.04 40%5100151 COS-GS-Soft Goods 6,882.28 12,602.15 (5,719.87) 33,203.50 46,139.50 (12,936.00) 111,199.55 77,996.05 30%5100152 COS-GS-Purchase Disc (272.74) (969.00) 696.26 (1,429.31) (3,549.00) 2,119.69 (8,554.00) (7,124.69) -17%5100220 COS-GS-Freight Merch 509.45 291.00 218.45 2,563.58 1,065.00 1,498.58 2,566.00 2.42 100%Cost of Sales - Golf Shop 12,112.25 18,710.05 (6,597.80) 58,055.58 68,500.65 (10,445.07) 165,088.40 107,032.82 35%Gross Profit 10,564.68 16,540.95 (5,976.27) 48,705.80 60,562.35 (11,856.55) 145,959.60 98,222.46 33%COS % 53.4% 53.1% -0.3% 54.4% 53.1% -1.3% 53.1% 52.1% 2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,002.29 2,317.00 (314.71) 16,016.03 15,226.00 790.03 26,811.00 10,794.97 60%6101325 Insurance-Workers Comp 309.05 512.00 (202.95) 2,797.56 3,183.00 (385.44) 5,663.00 2,865.44 49%6101720 Salaries 3,545.44 3,750.00 (204.56) 26,590.80 26,250.00 340.80 45,000.00 18,409.20 59%6101800 Taxes-Employer Payroll 1,456.88 1,333.00 123.88 7,017.70 8,290.00 (1,272.30) 14,758.00 7,740.30 48%6101880 Wages-Hourly 10,867.03 9,008.00 1,859.03 52,334.98 53,078.00 (743.02) 96,229.00 43,894.02 54%6101882 Wages-Overtime 43.13 - 43.13 909.42 - 909.42 - 952.88 0%Total -PS-SALARIES & BENEFITS 18,223.82 16,920.00 1,303.82 105,666.49 106,027.00 (360.51) 188,461.00 84,656.81 55%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 157.08 500.00 (342.92) 676.75 3,500.00 (2,823.25) 6,000.00 5,323.25 11%6109090 Contract Services 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 58%6109220 Freight & Delivery 134.88 - 134.88 212.23 75.00 137.23 75.00 (137.23) 283%6109490 Miscellaneous 51.32 50.00 1.32 1,157.10 200.00 957.10 450.00 (707.10) 257%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 11.22 - 11.22 55.63 - 55.63 - (55.63) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 2,316.25 4,500.00 (2,183.75) 5,890.00 3,573.75 39%6109810 Travel - Merchandise - 15.00 (15.00) - 15.00 (15.00) 90.00 90.00 0%6109820 Uniforms - 500.00 (500.00) 2,664.74 1,400.00 1,264.74 2,400.00 (264.74) 111%6117840 Telephones 113.61 110.00 3.61 666.06 770.00 (103.94) 1,320.00 653.94 0%Total PS-OTHER EXPENSES 968.11 2,925.00 (1,956.89) 11,248.76 13,960.00 (2,711.24) 24,525.00 13,276.24 46%19,191.93 19,845.00 (653.07) 116,915.25 119,987.00 (3,071.75) 212,986.00 97,933.05 54%Net Income(8,627.25) (3,304.05) (5,323.20) (68,209.45) (59,424.65) (8,784.80) (67,026.40) 289.41 -100%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJanuary 20133 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 7,244.12 8,740.00 (1,495.88) 62,041.73 61,180.00 861.73 104,880.00 42,838.27 40.8%6311325 Insurance-Workers Comp 1,290.20 2,510.00 (1,219.80) 11,205.13 16,163.00 (4,957.87) 27,280.00 16,074.87 58.9%6311720 Salaries 11,001.60 11,001.60 - 82,512.00 77,011.20 5,500.80 150,996.00 68,484.00 45.4%6311800 Taxes-Employer Payroll 6,674.36 6,631.00 43.36 35,750.96 42,574.00 (6,823.04) 71,645.00 35,894.04 50.1%6311880 Wages-Hourly 50,031.02 49,901.40 129.62 328,712.65 317,338.80 11,373.85 518,654.00 189,941.35 36.6%6311882 Wages-Overtime 154.81 2,550.00 (2,395.19) 11,750.74 13,076.00 (1,325.26) 15,945.00 4,194.26 26.3%Total-CM-SALARIES & BENEFITS76,396.11 81,334.00 (4,937.89) 531,973.21 527,343.00 4,630.21 889,400.00 357,426.79 40.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 4,220.33 - 4,220.33 19,282.18 - 19,282.18 31,100.00 11,817.82 38.0%6313744 Fertilizer 9,895.34 11,500.00 (1,604.66) 83,670.76 102,700.00 (19,029.24) 114,500.00 30,829.24 26.9%6313745 Herbicides - - - 17,281.37 17,000.00 281.37 17,000.00 (281.37) -1.7%6313746 Flowers/Plants 1,969.92 750.00 1,219.92 2,357.82 2,750.00 (392.18) 3,050.00 692.18 22.7%6313748 Fuel-Gasoline 5,013.98 3,850.00 1,163.98 32,659.02 37,050.00 (4,390.98) 55,020.00 22,360.98 40.6%6313750 Golf Course Accessories - 200.00 (200.00) 14,378.91 12,500.00 1,878.91 13,000.00 (1,378.91) -10.6%6313756 POA Control 3,474.88 3,500.00 (25.12) 7,837.62 7,000.00 837.62 7,000.00 (837.62) -12.0%6313758 Miscellaneous Supp 283.61 100.00 183.61 5,039.35 3,850.00 1,189.35 4,350.00 (689.35) 0.0%6313762 Supplies-Office 49.67 - 49.67 536.39 - 536.39 - (536.39) 0.0%6313774 Sand 576.72 380.00 196.72 6,442.79 15,960.00 (9,517.21) 16,460.00 10,017.21 60.9%6313776 Seed 9,360.78 350.00 9,010.78 106,483.19 105,060.00 1,423.19 106,810.00 326.81 0.3%6313778 Small Tools & Non-Capital Equip 100.72 100.00 0.72 4,293.54 4,500.00 (206.46) 5,000.00 706.46 14.1%6313780 Sod - 500.00 (500.00) 6,767.37 7,250.00 (482.63) 7,950.00 1,182.63 14.9%6313782 Topdressing - - - 7,026.64 5,000.00 2,026.64 7,600.00 573.36 7.5%Total-CM-SUPPLIES & MATERIALS34,945.95 21,230.00 13,715.95 314,056.95 320,620.00 (6,563.05) 388,840.00 74,783.05 19.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 19,810.00 18,200.00 1,610.00 31,200.00 11,390.00 36.5%6315685 CM-R&M-Bldngs & Othr Structures 196.54 250.00 (53.46) 842.94 4,300.00 (3,457.06) 5,550.00 4,707.06 84.8%6315690 CM-R&M-Equipment 3,258.25 2,000.00 1,258.25 31,088.19 20,000.00 11,088.19 31,000.00 (88.19) -0.3%6315692 CM-R&M-Irrigation System 1,507.46 1,200.00 307.46 10,905.02 17,650.00 (6,744.98) 22,650.00 11,744.98 51.9%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 5,556.81 7,000.00 (1,443.19) 10,500.00 4,943.19 47.1%6315815 CM-R&M-Trees-Pruning Etc - - - 7,500.00 4,050.00 3,450.00 10,050.00 2,550.00 25.4%Total-CM-REPAIRS & MAINTENANCE 7,792.25 7,050.00 742.25 75,702.96 71,200.00 4,502.96 110,950.00 35,247.04 31.8%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 32.78 15.00 17.78 169.69 105.00 64.69 180.00 10.31 0.0%6317840 Telephones 1,147.11 850.00 297.11 8,381.31 5,950.00 2,431.31 10,200.00 1,818.69 17.8%Total-CM-UTILITIES 1,179.89 865.00 314.89 8,551.00 6,055.00 2,496.00 10,380.00 1,829.00 17.6%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%6319100 Contract Svcs-Soil/Tissue Test - - - - 2,000.00 (2,000.00) 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal 627.58 524.00 103.58 6,127.68 3,668.00 2,459.68 6,288.00 160.32 0.0%6319150 Dues & Subscriptions 590.00 - 590.00 1,010.00 - 1,010.00 540.00 (470.00) -87.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) 579.13 3,300.00 (2,720.87) 4,200.00 3,620.87 86.2%6319206 Licenses & Permits - - - - 280.00 (280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous 103.49 100.00 3.49 1,944.82 700.00 1,244.82 1,200.00 (744.82) -62.1%6319718 Safety Equipment & Training 672.75 400.00 272.75 3,235.37 3,150.00 85.37 3,850.00 614.63 16.0%6319822 Uniforms 1,026.21 920.00 106.21 8,415.68 6,440.00 1,975.68 11,040.00 2,624.32 23.8%Total-CM-OTHER EXPENSES 3,520.03 2,694.00 826.03 24,812.68 23,388.00 1,424.68 40,098.00 15,285.32 38.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJanuary 2013Annual Budget4 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,068.90 2,648.00 (579.10) 14,380.98 18,536.00 (4,155.02) 31,776.00 17,395.02 54.7%6321325 Insurance-Workers Comp 302.40 516.00 (213.60) 3,496.00 3,755.00 (259.00) 6,361.00 2,865.00 45.0%6321800 Taxes-Employer Payroll 1,865.63 1,346.00 519.63 9,156.03 9,977.00 (820.97) 16,808.00 7,651.97 45.5%6321880 Wages-Hourly 12,673.39 12,880.00 (206.61) 88,966.66 90,160.00 (1,193.34) 154,560.00 65,593.34 42.4%6321882 Wages-Overtime 45.57 - 45.57 1,835.74 5,313.00 (3,477.26) 6,279.00 4,443.26 70.8%Total-CM-LM-SALARIES & BENEFITS16,955.89 17,390.00 (434.11) 117,835.41 127,741.00 (9,905.59) 215,784.00 97,948.59 45.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) - 650.00 (650.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 166.08 290.00 (123.92) 1,751.06 2,030.00 (278.94) 3,480.00 1,728.94 49.7%Total-CM-LM-SUPPLIES & MATERIALS166.08 365.00 (198.92) 1,751.06 2,680.00 (928.94) 4,505.00 2,753.94 61.1%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%140,956.20 131,178.00 9,778.20 1,074,683.27 1,081,777.00 (7,093.73) 1,664,207.00 589,523.73 35.4% January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 11,382.22 13,016.00 (1,633.78) 89,872.35 90,506.00 (633.65) 178,691.00 88,818.65 49.7%6337842 Utilities-Water2,034.19 1,860.00 174.19 35,240.19 28,720.00 6,520.19 43,058.00 7,817.81 18.2%13,416.41 14,876.00 (1,459.59) 125,112.54 119,226.00 5,886.54 221,749.00 96,636.46 43.6%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyJanuary 2013Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementJanuary 2013Annual BudgetMonth to Date Year to Date5 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 419.56 662.00 (242.44) 2,558.24 4,634.00 (2,075.76) 7,944.00 5,385.76 67.8%6411325 Insurance-Workers Comp 207.04 550.00 (342.96) 2,116.67 2,752.00 (635.33) 5,135.00 3,018.33 58.8%6411800 Taxes-Employer Payroll 2,528.72 1,707.00 821.72 8,384.77 8,543.00 (158.23) 15,942.00 7,557.23 47.4%6411880 Wages-Hourly 14,682.59 13,710.00 972.59 69,205.54 68,622.00 583.54 128,052.00 58,846.46 46.0%6411882 Wages-Overtime 289.69 - 289.69 955.90 - 955.90 - (955.90) 0.0%Total-CBR-SALARIES & BENEFITS18,127.60 16,629.00 1,498.60 83,221.12 84,551.00 (1,329.88) 157,073.00 73,851.88 47.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 75.00 (75.00) 671.83 2,075.00 (1,403.17) 2,350.00 1,678.17 71.4%6413742 Supplies-Expendable 620.65 1,000.00 (379.35) 5,809.27 4,450.00 1,359.27 6,750.00 940.73 13.9%6413748 Supplies-Fuel for Shuttle - 450.00 (450.00) 574.85 1,350.00 (775.15) 3,000.00 2,425.15 80.8%6413752 Supplies-Range Balls - - - 9,177.75 9,000.00 177.75 9,000.00 (177.75) -2.0%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) - 70.00 (70.00) 420.00 420.00 100.0%6413786 Supplies-Towels 717.41 72.00 645.41 1,997.41 645.00 1,352.41 1,005.00 (992.41) -98.7%6413796 Supplies-Bottled Water34.99 50.00 (15.01) 9,852.01 12,300.00 (2,447.99) 24,500.00 14,647.99 59.8%Total-CBR-SUPPLIES & MATERIALS1,373.05 1,767.00 (393.95) 28,083.12 30,165.00 (2,081.88) 47,550.00 19,466.88 40.9%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 535.51 300.00 235.51 2,100.14 2,100.00 0.14 3,600.00 1,499.86 41.7%6415695 CBR-R&M-Cart Maintenance & Repair 913.96 750.00 163.96 3,410.62 6,000.00 (2,589.38) 9,750.00 6,339.38 65.0%Total-CBR-REPAIRS & MAINTENANCE 1,449.47 1,050.00 399.47 5,510.76 8,100.00 (2,589.24) 13,350.00 7,839.24 58.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,640.94 800.00 840.94 5,499.79 5,600.00 (100.21) 9,600.00 4,100.21 42.7%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous 188.54 75.00 113.54 255.78 575.00 (319.22) 1,150.00 894.22 77.8%6419820 Uniforms - - - 2,317.39 3,000.00 (682.61) 5,200.00 2,882.61 55.4%Total-CBR-OTHER EXPENSES 1,829.48 875.00 954.48 8,072.96 9,625.00 (1,552.04) 16,400.00 8,327.04 50.8%TOTAL-CARTS,BAGROOM & RANGE 22,779.60 20,321.00 2,458.60 124,887.96 132,441.00 (7,553.04) 234,373.00 109,485.04 46.7%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 107.09 236.00 (128.91) 1,648.18 1,051.00 597.18 1,903.00 254.82 13.4%6431800 Taxes-Employer Payroll 963.15 614.00 349.15 3,110.93 2,734.00 376.93 4,960.00 1,849.07 37.3%6431880 Wages-Hourly 5,206.00 5,880.00 (674.00) 25,182.00 26,180.00 (998.00) 47,460.00 22,278.00 46.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,276.24 6,730.00 (453.76) 29,941.11 29,965.00 (23.89) 54,323.00 24,381.89 44.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 691.76 600.00 91.76 1,050.00 358.24 34.1%6439490 Miscellaneous - 50.00 (50.00) 647.25 200.00 447.25 200.00 (447.25) -223.6%6439718 Safety Equipment & Training - 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 1,114.00 1,425.00 (311.00) 2,125.00 1,011.00 47.6%Total-CS-OTHER EXPENSES - 275.00 (275.00) 2,453.01 2,575.00 (121.99) 3,975.00 1,521.99 38.3%Total-COURSE SERVICES 6,276.24 7,005.00 (728.76) 32,394.12 32,540.00 (145.88) 58,298.00 25,903.88 44.4%29,055.84 27,326.00 1,729.84 157,282.08 164,981.00 (7,698.92) 292,671.00 133,866.93 45.7%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJanuary 2013Annual Budget6 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,264.00 2,800.00 (1,536.00) 4,800.00 3,536.00 73.7%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,264.00 2,800.00 (1,536.00) 4,800.00 3,536.00 73.7%65-CH-UTILITIES6507836 Utilities-Natural Gas682.53 300.00 382.53 1,442.96 2,100.00 (657.04) 3,600.00 2,157.04 59.9%6507840 Utilities-Telephone1,226.27 1,150.00 76.27 8,550.72 8,050.00 500.72 13,800.00 5,249.28 38.0%6507842 Utilities-Water347.92 321.00 26.92 2,412.38 2,247.00 165.38 3,852.00 1,439.62 37.4%6507844 Utilities-Cable336.91 340.00 (3.09) 2,358.37 2,380.00 (21.63) 4,080.00 1,721.63 42.2%Total-CH-UTILITIES 2,593.63 2,111.00 482.63 14,764.43 14,777.00 (12.57) 25,332.00 10,567.57 41.7%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 12,775.00 13,375.00 (600.00) 22,500.00 9,725.00 43.2%6509099 Contract Services-Security5,262.04 6,500.00 (1,237.96) 36,391.68 35,900.00 491.68 60,400.00 24,008.32 39.7%6509215 Flowers & Decorations- 1,000.00 (1,000.00) 98.89 1,500.00 (1,401.11) 2,400.00 2,301.11 95.9%6509490 Miscellaneous- 200.00 (200.00) 206.21 1,400.00 (1,193.79) 2,400.00 2,193.79 91.4%6509718 Safety Equipment & Training476.19 100.00 376.19 597.31 700.00 (102.69) 1,200.00 602.69 50.2%Total-CH-OTHER EXPENSES 7,638.23 9,625.00 (1,986.77) 50,069.09 52,875.00 (2,805.91) 88,900.00 38,830.91 43.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures736.76 300.00 436.76 2,307.06 2,100.00 207.06 3,600.00 1,292.94 35.9%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,018.00 2,800.00 218.00 4,800.00 1,782.00 37.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 1,873.97 2,800.00 (926.03) 4,800.00 2,926.03 61.0%Total-CH-REPAIRS & MAINTENANCE 736.76 1,100.00 (363.24) 7,199.03 7,700.00 (500.97) 13,200.00 6,000.97 45.5%10,968.62 13,236.00 (2,267.38) 73,296.55 78,152.00 (4,855.45) 132,232.00 12,001.94 9.1%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJanuary 2013Annual Budget7 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 249.78 331.00 (81.22) 2,388.46 2,317.00 71.46 3,972.00 1,583.54 39.9%6601325 Insurance-Workers Comp 302.40 101.00 201.40 1,129.56 707.00 422.56 1,207.00 77.44 6.4%6601720 Salaries 2,546.26 2,508.00 38.26 17,105.78 17,556.00 (450.22) 30,096.00 12,990.22 43.2%6601800 Taxes-Employer Payroll 503.47 262.00 241.47 2,364.40 1,834.00 530.40 3,145.00 780.60 24.8%Total-MKT-SALARIES & BENEFITS 3,601.91 3,202.00 399.91 22,988.20 22,414.00 574.20 38,420.00 15,431.80 40.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 700.00 (700.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 307.87 200.00 107.87 4,619.79 3,800.00 819.79 4,425.00 (194.79) -4.4%307.87 300.00 7.87 4,619.79 4,500.00 119.79 5,625.00 1,005.21 17.9%66-MKT-UTILITIES6607840 Utilities-Telephone 105.64 100.00 5.64 739.32 700.00 39.32 1,200.00 460.68 38.4%Total-MKT-UTILITIES 105.64 100.00 5.64 739.32 700.00 39.32 1,200.00 460.68 38.4%66-MKT-OTHER EXPENSES6609010 Advertising 7,147.37 20,472.00 (13,324.63) 82,632.99 108,635.00 (26,002.01) 179,231.00 96,598.01 53.9%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material 894.36 2,500.00 (1,605.64) 1,418.36 6,000.00 (4,581.64) 9,000.00 7,581.64 84.2%6609102 Contract Services-Web Page - 300.00 (300.00) 495.00 2,100.00 (1,605.00) 3,600.00 3,105.00 86.3%6609490 Miscellaneous - 50.00 (50.00) - 150.00 (150.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 19.82 350.00 (330.18) 600.00 580.18 96.7%6609630 Promotion - 25.00 (25.00) 104.43 175.00 (70.57) 3,000.00 2,895.57 0.0%6609633 Promotion-Community - 375.00 (375.00) 278.80 2,325.00 (2,046.20) 2,250.00 1,971.20 87.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 2,500.00 (2,500.00) 700.00 - 0.0%6609150 Dues and Subscriptions - 35.00 (35.00) 100.00 35.00 65.00 735.00 635.00 86.4%6609820 Uniforms - 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 8,041.73 24,357.00 (16,315.27) 85,049.40 122,720.00 (37,670.60) 200,366.00 114,616.60 57.2%12,057.15 27,959.00 (15,901.85) 113,396.71 150,334.00 (36,937.29) 245,611.00 131,514.29 53.5%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJanuary 2013Annual Budget8 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,388.73 1,458.00 (69.27) 11,271.03 10,206.00 1,065.03 17,496.00 6,224.97 35.6%6701325 Insurance-Workers Comp302.40 688.00 (385.60) 3,353.03 4,816.00 (1,462.97) 8,254.00 4,900.97 59.4%6701720 Salaries 15,816.26 15,003.00 813.26 102,121.95 105,021.00 (2,899.05) 178,000.00 75,878.05 42.6%6701800 Taxes-Employer Payroll 1,936.42 1,792.00 144.42 9,866.92 12,544.00 (2,677.08) 21,510.00 11,643.08 54.1%6701880 Wages-Hourly2,398.20 2,150.00 248.20 13,224.29 15,050.00 (1,825.71) 27,835.00 14,610.71 52.5%6701882 Wages-Overtime - - - 22.69 - 22.69 - (22.69) 0.0%Total-G&A-SALARIES & BENEFITS 21,842.01 21,091.00 751.01 139,859.91 147,637.00 (7,777.09) 253,095.00 113,235.09 44.7%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer916.92 400.00 516.92 1,143.99 2,800.00 (1,656.01) 5,200.00 4,056.01 78.0%6703762 Supplies-Office - 100.00 (100.00) 1,046.13 700.00 346.13 1,200.00 153.87 12.8%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 711.44 1,300.00 (588.56) 3,300.00 2,588.56 78.4%Total-G&A-SUPPLIES & MATERIALS 916.92 900.00 16.92 2,901.56 4,800.00 (1,898.44) 9,700.00 6,798.44 70.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 600.00 (600.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 600.00 (600.00) 1,100.00 1,100.00 100.0%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- 100.00 (100.00) 165.00 650.00 (485.00) 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 1,612.60 1,000.00 612.60 1,400.00 (212.60) -15.2%6709197 Equipment Rental559.38 480.00 79.38 4,821.42 3,360.00 1,461.42 5,760.00 938.58 16.3%6709202 Fees-Bank129.53 90.00 39.53 828.63 630.00 198.63 1,080.00 251.37 23.3%6709208 Fees-Payroll Processing1,150.89 1,100.00 50.89 8,891.70 7,700.00 1,191.70 13,200.00 4,308.30 32.6%6709220 Freight/Delivery- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 147.63 700.00 (552.37) 1,200.00 1,052.37 87.7%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services 98.00 75.00 23.00 855.82 525.00 330.82 900.00 44.18 4.9%6709625 Professional Fees461.21 850.00 (388.79) 6,720.47 5,950.00 770.47 10,200.00 3,479.53 34.1%6709636 Promotion/Entertainment- 100.00 (100.00) 2,526.78 2,600.00 (73.22) 3,100.00 573.22 18.5%6709722 Seminars & Training- 200.00 (200.00) 586.08 1,400.00 (813.92) 2,400.00 1,813.92 75.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 290.27 675.00 (384.73) 1,050.00 759.73 72.4%Total-G&A-OTHER EXPENSES 2,799.01 3,820.00 (1,020.99) 30,246.40 28,440.00 1,806.40 48,490.00 18,243.60 37.6%25,557.94 25,911.00 (353.06) 173,007.87 181,477.00 (8,469.13) 312,385.00 139,377.13 44.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJanuary 2013Annual Budget9 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4009300Resident Card Issue31,080.00 - 31,080.00 74,670.00 - 74,670.00 - - 0%- - 0% Total Revenue Resident Cards31,080.00 - 31,080.00 74,670.00 - 74,670.00 - - 0%Expense60-RC-SALARIES & BENEFITS6001800 Taxes-Employer Payroll 261.60 - 261.60 523.20 - 523.20 - - 0%6001880 Wages-Hourly1,562.22 - 1,562.22 3,064.50 - 3,064.50 - - 0%6001882 Wages-Overtime - - - - - - - - 0%Total -RC-SALARIES & BENEFITS 1,823.82 - 1,823.82 3,587.70 - 3,587.70 - - 0%60-RC- OTHER EXPENSES6003762 Supplies-Office - - - - - - - - 0%6009490 Miscellaneous 1,081.69 - 1,081.69 4,631.32 - 4,631.32 - - 0%6003740 Supplies-Computer- - - - - - - - 0%6009625 Professional Fees- - - 879.89 - 879.89 - - 0%Total RC-OTHER EXPENSES 1,081.69 - 1,081.69 5,511.21 - 5,511.21 - - 0%2,905.51 - 2,905.51 9,098.91 - 9,098.91 - - 0%Net Income28,174.49 - 28,174.49 65,571.09 - 65,571.09 - - 0%Month to Date Year to Date Annual BudgetTotal-RESIDENT CARDSSilverRock ResortResident Card Income StatementJanuary 201310 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 82,124.51 84,525.00 (2,400.49) 144,900.00 62,775.49 43.3%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 3,275.24 4,200.00 (924.76) 7,200.00 3,924.76 54.5%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 34,580.00 40,285.00 (5,705.00) 69,060.00 34,480.00 49.9%6800197 Equipment Leases-Others 128.28 460.00 (331.72) 3,151.82 3,220.00 (68.18) 5,520.00 2,368.18 0.0%16,662.45 18,890.00 (2,227.55) 123,131.57 132,230.00 (9,098.43) 226,680.00 103,548.43 45.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (458.47) 4,487.00 (4,945.47) 74,000.25 88,424.00 (14,423.75) 90,000.00 15,999.75 17.8%6900210 FF&E Reserve 6,848.28 7,754.00 (905.72) 25,313.90 27,535.00 (2,221.10) 67,015.00 41,701.10 62.2%6900800 Personal Property Taxes 395.20 - 395.20 12,302.80 14,800.00 (2,497.20) 14,800.00 2,497.20 16.9%6900323 Insurance-Commercial 2,772.00 2,200.00 572.00 18,157.77 15,400.00 2,757.77 26,400.00 8,242.23 31.2%9,557.01 14,441.00 (4,883.99) 129,774.72 146,159.00 (16,384.28) 198,215.00 68,440.28 34.5%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJanuary 201311 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia342 4SalesPromotion8Golf IndustryVIPCelebrityPGA Comp62 16 46 15 20 37Charity/Gift Certificate61511 428Rain/Wind Checks536Club Staff129 60 81 13 78 139LQ HS Golf8123194213 95 152 28 136 3162013 2013 2013 2013 2013 2013Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia6SalesPromotion5Golf IndustryVIPCelebrityPGA Comp23Charity/Gift Certificate8Rain/Wind Checks10Club Staff132LQ HS Golf642480000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013January 2013 Date Time Description CategoryPlayers1/1/2013 8:00 Writers for Aces Golf Magazine / Nor Cal Media 21/11/2013 9:37 Kris Long / Anchor CBS2 Media 41/20/2013 10:45 Tommy Ruehr / Golf Digest Rater Promo 11/25/2013 12:07 Special Event Planner LA Promo 413