Loading...
01 July 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2016 – July 2016 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Golf Shop Income Statement 4 Course Maintenance Expense Statement 5 Outside Service Expense Statement 7 Clubhouse Expense Statement 8 Marketing Expense Statement 9 General & Administrative Expense Statement 10 Operating Leases & Miscellaneous Expense Statement 12 Complimentary Report 13 Annual BudgetAccount Description JulyFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue69,829.30 26,648.00 43,181.30 162.0% 69,829.30 26,648.00 43,181.30 3,199,237.00 3,129,407.70 2%401000 Miscellaneous Golf Revenue8,131.80 2,960.00 5,171.80 174.7% 8,131.80 2,960.00 5,171.80 349,259.00 341,127.20 2%410000 Revenue-Golf Shop8,465.03 3,423.00 5,042.03 147.3% 8,465.03 3,423.00 5,042.03 278,585.00 270,119.97 3%420000 Revenue-F&B Concession500.00 500.00 - 0.0%500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income- - - - - - - - 0%Total Income86,926.13 33,531.00 53,395.13 159.2% 86,926.13 33,531.00 53,395.13 3,839,081.00 3,752,154.87 2%Cost of Goods Sold510000 COS-Golf Shop4,716.22 1,916.34 2,799.88 -146.1% 4,716.22 1,916.34 (2,799.88) 155,924.00 151,207.78 3%Total COS4,716.22 1,916.34 2,799.88 -146.1% 4,716.22 1,916.34 (2,799.88) 155,924.00 151,207.78 3%Gross Profit82,209.91 31,614.66 50,595.25 160.0% 82,209.91 31,614.66 50,595.25 3,683,157.00 3,600,947.09 2%Expenses610000 Golf Pro Shop 11,979.96 12,827.00 (847.04) 6.6% 11,979.96 12,827.00 (847.04) 204,827.00 192,847.04 6%630000 Course Maintenance113,463.68 114,030.00 (566.32) 0.5% 113,463.68 114,030.00 (566.32) 1,712,795.00 1,599,331.32 7%633000 Maintenance Water & Energy19,620.43 23,415.00 (3,794.57) 16.2% 19,620.43 23,415.00 (3,794.57) 225,129.00 205,508.57 9%640000 Outside Services15,289.18 15,034.00 255.18 -1.7% 15,289.18 15,034.00 255.18 309,830.00 294,540.82 5%650000 Clubhouse9,455.01 10,636.00 (1,180.99) 11.1%9,455.01 10,636.00 (1,180.99) 136,332.00 126,876.99 7%660000 Marketing8,079.88 7,539.00 540.88 -7.2%8,079.88 7,539.00 540.88 240,177.00 232,097.12 3%670000 General & Administrative22,538.09 24,741.00 (2,202.91) 8.9% 22,538.09 24,741.00 (2,202.91) 327,511.00 304,972.91 7%680000 Leases22,979.60 22,550.00 429.60 -1.9% 22,979.60 22,550.00 429.60 271,050.00 248,070.40 8%690000 Miscellaneous Other Expense18,994.64 17,086.00 1,908.64 -11.2% 18,994.64 17,086.00 1,908.64 202,025.00 183,030.36 9%Total Expenses242,400.47 247,858.00 (5,457.53) 2.2% 242,400.47 247,858.00 5,457.53 3,629,676.00 3,387,275.53 7%(160,190.56) (216,243.34) 56,052.78 25.9%(160,190.56) (216,243.34) 56,052.78 53,481.00 213,671.56 0%Rounds of Golf PlayedPaid Rounds Played2,649 1,007 1,642 163.1%2,649 1,007 1,642 46,475 43,826 6%Ave $ Per Paid Round Green Fee26.36 26.46 (0.10) -0.4%26.36 26.46 (0.10) 68.84 42.48 38%Ave $ Per Paid Round Merchandise3.20 3.40 (0.20) -6.0%3.20 3.40 (0.20) 5.99 2.80 53%Ave $ Per Paid Miscellaneous 3.07 2.94 0.13 4.4%3.07 2.94 0.13 7.51 4.45 41%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJuly 20161 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees69,829.30 26,648.00 43,181.30 69,829.30 26,648.00 43,181.30 3,199,237.00 3,129,407.70 97.8%4010000 Rider Fee442.50 101.00 341.50 442.50 101.00 341.50 7,738.00 7,295.50 94.3%4040000 Club Rental1,000.00 504.00 496.00 1,000.00 504.00 496.00 23,238.00 22,238.00 95.7%4050000 Driving Range1,944.00 755.00 1,189.00 1,944.00 755.00 1,189.00 100,984.00 99,040.00 98.1%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 100.00 (100.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract 995.30 1,000.00 (4.70) 995.30 1,000.00 (4.70) 4,000.00 3,004.70 75.1%4091000 Golf Professional Rental Fee- - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue3,750.00 500.00 3,250.00 3,750.00 500.00 3,250.00 171,200.00 167,450.00 97.8% Total Revenue Fees77,961.10 29,608.00 48,353.10 77,961.10 29,608.00 48,353.10 3,548,497.00 3,470,535.90 97.8%77,961.10 29,608.00 48,353.10 77,961.10 29,608.00 48,353.10 3,548,497.00 3,470,535.90 97.8%SilverRock ResortStatement of Fees RevenueJuly 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$69,829.30$26,648.0043,181.30Favorable: Due to projected closure of nine holes budget projections were reduced.ActualBudgetVariance$8,131.80 $2,960.00 5,171.80Favorable: Due to projected closure of nine holes budget projections were reduced.ActualBudgetVariance$8,465.03 $3,423.00 5,042.03Favorable: Due to projected closure of nine holes budget projections were reduced.ExpensesActualBudgetVariance$19,620.43$23,415.00(3,794.57)Favorable: Due to projected increases in water costs. The billing cycle was through 7/5/16 which only accounted for 5 days of additional costs.ActualBudgetVariance$9,455.01 $10,636.00 (1,180.99)Favorable: Due to no expenses for repair and maintenance.ActualBudgetVariance$18,994.64$17,086.001,908.64Unfavorable: Due to increase in reserve as a result of higher revenues.Miscellaneous Other ExpensesWater & EnergyClubhouseVariance ExplanationJuly 2016The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations arePro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf Revenueprovided for those cost of sales percentage that are greater than 5%.3-20-133 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous702.47 - 702.47 702.47 - 702.47 00 0%4100110 Sales Hard Goods3,799.14 1,198.00 2,601.14 3,799.14 1,198.00 2,601.14 97,505.00 93,705.86 96.1%4100112 Sales-Soft Goods4,736.00 2,225.00 2,511.00 4,736.00 2,225.00 2,511.00 181,080.00 176,344.00 97.4%5100639 GS-Discounts-Mdse(772.58) - (772.58) (772.58) - (772.58) - 772.58 0.0% Total Revenue Golf Shop8,465.03 3,423.00 5,042.03 8,465.03 3,423.00 5,042.03 278,585.00 270,822.44 97.2%COS 5100150 COS-GS-Hard Goods 1,974.55 694.84 1,279.71 1,974.55 694.84 1,279.71 56,552.90 54,578.35 96.5%5100151 COS-GS-Soft Goods 2,609.17 1,290.50 1,318.67 2,609.17 1,290.50 1,318.67 105,026.40 102,417.23 97.5%5100152 COS-GS-Purchase Disc (5.77) (99.00) 93.23 (5.77) (99.00) 93.23 (8,079.00) (8,073.23) 99.9%5100220 COS-GS-Freight Merch 138.27 30.00 108.27 138.27 30.00 108.27 2,424.00 2,285.73 94.3%Cost of Sales - Golf Shop4,716.22 1,916.34 2,799.88 4,716.22 1,916.34 2,799.88 155,924.30 151,208.08 97.0%Gross Profit 3,748.81 1,506.66 2,242.15 3,748.81 1,506.66 2,242.15 122,660.70 119,614.36 97.5%COS % 55.7% 56.0% 0.3% 55.7% 56.0% 0.3% 53.1% 55.8% 105.2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group945.08 1,705.00 (759.92) 945.08 1,705.00 (759.92) 27,621.00 26,675.92 96.6%6101325 Insurance-Workers Comp 321.06 319.00 2.06 321.06 319.00 2.06 5,042.00 4,720.94 93.6%6101720 Salaries4,002.00 4,001.00 1.00 4,002.00 4,001.00 1.00 45,000.00 40,998.00 91.1%6101800 Taxes-Employer Payroll 730.73 1,190.00 (459.27) 730.73 1,190.00 (459.27) 18,825.00 18,094.27 96.1%6101880 Wages-Hourly5,375.97 4,502.00 873.97 5,375.97 4,502.00 873.97 89,463.00 84,087.03 94.0%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 11,374.84 11,717.00 (342.16) 11,374.84 11,717.00 (342.16) 185,951.00 175,529.04 94.4%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) - 250.00 (250.00) 3,000.00 3,000.00 100.0%6109220 Freight & Delivery(23.00) - (23.00) (23.00) - (23.00) 75.00 98.00 130.7%6109490 Miscellaneous500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short55.93 - 55.93 55.93 - 55.93 - (55.93) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 150.00 (150.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms13.13 100.00 (86.87) 13.13 100.00 (86.87) 2,400.00 2,386.87 99.5%6117840 Telephones59.06 110.00 (50.94) 59.06 110.00 (50.94) 1,320.00 1,260.94 95.5%605.12 1,110.00 (504.88) 605.12 1,110.00 (504.88) 18,875.00 18,269.88 96.8%11,979.96 12,827.00 (847.04) 11,979.96 12,827.00 (847.04) 204,826.00 193,798.92 94.6%Net Income(8,231.15) (11,320.34) 3,089.19 (8,231.15) (11,320.34) 3,089.19 (82,165.30) (74,184.56) 90.3%SilverRock ResortGolf Shop Income StatementJuly 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,036.55 8,990.00 (953.45) 8,036.55 8,990.00 (953.45) 107,880.00 99,843.45 92.6%6311325 Insurance-Workers Comp1,401.20 1,663.00 (261.80) 1,401.20 1,663.00 (261.80) 24,794.00 23,392.80 94.3%6311720 Salaries10,620.80 9,333.33 1,287.47 10,620.80 9,333.33 1,287.47 142,017.20 131,396.40 92.5%6311800 Taxes-Employer Payroll3,884.95 6,207.00 (2,322.05) 3,884.95 6,207.00 (2,322.05) 93,302.00 89,417.05 95.8%6311880 Wages-Hourly39,744.90 35,003.67 4,741.23 39,744.90 35,003.67 4,741.23 508,481.80 468,736.90 92.2%6311882 Wages-Overtime50.22 - 50.22 50.22 - 50.22 15,945.00 15,894.78 99.7%Total-CM-SALARIES & BENEFITS63,738.62 61,197.00 2,541.62 63,738.62 61,197.00 2,541.62 892,420.00 828,681.38 92.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals4,818.61 3,000.00 1,818.61 4,818.61 3,000.00 1,818.61 34,600.00 29,781.39 86.1%6313744 Fertilizer5,514.39 9,000.00 (3,485.61) 5,514.39 9,000.00 (3,485.61) 112,500.00 106,985.61 95.1%6313745 Herbicides- - - - - - 17,000.00 17,000.00 100.0%6313746 Flowers/Plants- - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline3,497.28 4,800.00 (1,302.72) 3,497.28 4,800.00 (1,302.72) 55,020.00 51,522.72 93.6%6313750 Golf Course Accessories110.85 200.00 (89.15) 110.85 200.00 (89.15) 13,000.00 12,889.15 99.1%6313756 POA Control- - - - - - 7,000.00 7,000.00 100.0%6313758 Miscellaneous Supp828.74 750.00 78.74 828.74 750.00 78.74 4,350.00 3,521.26 80.9%6313762 Supplies-Office87.74 - 87.74 87.74 - 87.74 - (87.74) 0.0%6313774 Sand1,188.00 390.00 798.00 1,188.00 390.00 798.00 13,460.00 12,272.00 91.2%6313776 Seed864.00 350.00 514.00 864.00 350.00 514.00 125,900.00 125,036.00 99.3%6313778 Small Tools & Non-Capital Equip99.13 100.00 (0.87) 99.13 100.00 (0.87) 5,000.00 4,900.87 98.0%6313780 Sod1,883.06 1,000.00 883.06 1,883.06 1,000.00 883.06 10,450.00 8,566.94 82.0%6313782 Topdressing- - - - - - 10,600.00 10,600.00 100.0%Total-CM-SUPPLIES & MATERIALS18,891.80 19,590.00 (698.20) 18,891.80 19,590.00 (698.20) 411,930.00 393,038.20 95.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,590.00 2,600.00 (10.00) 2,590.00 2,600.00 (10.00) 31,200.00 28,610.00 91.7%6315685 CM-R&M-Bldngs & Othr Structures 150.28 1,250.00 (1,099.72) 150.28 1,250.00 (1,099.72) 5,550.00 5,399.72 97.3%6315690 CM-R&M-Equipment2,236.59 2,000.00 236.59 2,236.59 2,000.00 236.59 40,000.00 37,763.41 94.4%6315692 CM-R&M-Irrigation System3,483.67 4,400.00 (916.33) 3,483.67 4,400.00 (916.33) 19,050.00 15,566.33 81.7%6315696 CM-R&M-Pumps1,417.76 1,000.00 417.76 1,417.76 1,000.00 417.76 10,500.00 9,082.24 86.5%6315815 CM-R&M-Trees-Pruning Etc- - - - - - 12,050.00 12,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE9,878.30 11,250.00 (1,371.70) 9,878.30 11,250.00 (1,371.70) 118,350.00 108,471.70 91.7%6317836 Utilities-Natural Gas/LPG - 15.00 (15.00) - 15.00 (15.00) 180.00 180.00 0.0%6317840 Telephones1,177.56 850.00 327.56 1,177.56 850.00 327.56 10,200.00 9,022.44 88.5%Total-CM-UTILITIES1,177.56 865.00 312.56 1,177.56 865.00 312.56 10,380.00 9,202.44 88.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 500.00 (100.00) 400.00 500.00 (100.00) 6,000.00 5,600.00 93.3%6319100 Contract Svcs-Soil/Tissue Test- - - - - - 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal776.00 524.00 252.00 776.00 524.00 252.00 6,288.00 5,512.00 87.7%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) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits450.00 100.00 350.00 450.00 100.00 350.00 4,180.00 3,730.00 89.2%6319490 Miscellaneous327.83 100.00 227.83 327.83 100.00 227.83 1,200.00 872.17 72.7%6319718 Safety Equipment & Training- 200.00 (200.00) - 200.00 (200.00) 3,850.00 3,850.00 100.0%6319822 Uniforms694.10 920.00 (225.90) 694.10 920.00 (225.90) 11,040.00 10,345.90 93.7%Total-CM-OTHER EXPENSES2,647.93 2,594.00 53.93 2,647.93 2,594.00 53.93 42,048.00 39,400.07 93.7%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2016Annual Budget5 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,651.00 2,728.00 (77.00) 2,651.00 2,728.00 (77.00) 32,736.00 30,085.00 91.9%6321325 Insurance-Workers Comp441.20 483.00 (41.80) 441.20 483.00 (41.80) 6,171.00 5,729.80 92.9%6321800 Taxes-Employer Payroll942.44 1,803.00 (860.56) 942.44 1,803.00 (860.56) 23,334.00 22,391.56 96.0%6321880 Wages-Hourly12,851.97 12,880.00 (28.03) 12,851.97 12,880.00 (28.03) 160,320.00 147,468.03 92.0%6321882 Wages-Overtime24.33 - 24.33 24.33 - 24.33 6,351.00 6,326.67 99.6%Total-CM-LM-SALARIES & BENEFITS16,910.94 17,894.00 (983.06) 16,910.94 17,894.00 (983.06) 228,912.00 212,001.06 92.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 100.00 (100.00) 1,025.00 1,025.00 100.0%6323788 Uniforms218.53 290.00 (71.47) 218.53 290.00 (71.47) 3,480.00 3,261.47 93.7%Total-CM-LM-SUPPLIES & MATERIALS218.53 390.00 (171.47) 218.53 390.00 (171.47) 4,505.00 4,286.47 95.1%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%113,463.68 114,030.00 (566.32) 113,463.68 114,030.00 (566.32) 1,712,795.00 1,599,331.32 93.4% JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,265.00 13,265.00 (1,000.00) 12,265.00 13,265.00 (1,000.00) 179,791.00 167,526.00 93.2%6337842 Utilities-Water7,355.43 10,150.00 (2,794.57) 7,355.43 10,150.00 (2,794.57) 45,338.00 37,982.57 83.8%19,620.43 23,415.00 (3,794.57) 19,620.43 23,415.00 (3,794.57) 225,129.00 205,508.57 91.3%Total-COURSE MAINTENANCECourse Maintenance Expense StatementJuly 2016Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyJuly 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 682.00 (682.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp241.50 258.00 (16.50) 241.50 258.00 (16.50) 5,229.00 4,987.50 95.4%6411800 Taxes-Employer Payroll718.20 857.00 (138.80) 718.20 857.00 (138.80) 17,360.00 16,641.80 95.9%6411880 Wages-Hourly7,502.50 6,885.00 617.50 7,502.50 6,885.00 617.50 139,434.00 131,931.50 94.6%6411882 Wages-Overtime 67.50 - 67.50 67.50 - 67.50 - (67.50) 0.0%Total-CBR-SALARIES & BENEFITS8,529.70 8,682.00 (152.30) 8,529.70 8,682.00 (152.30) 170,207.00 161,677.30 95.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable809.52 600.00 209.52 809.52 600.00 209.52 6,750.00 5,940.48 88.0%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 120.00 200.00 320.00 120.00 200.00 2,182.00 1,862.00 85.3%6413796 Supplies-Bottled Water427.39 50.00 377.39 427.39 50.00 377.39 11,000.00 10,572.61 96.1%Total-CBR-SUPPLIES & MATERIALS1,556.91 795.00 761.91 1,556.91 795.00 761.91 34,727.00 31,320.09 90.2%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 956.45 500.00 456.45 956.45 500.00 456.45 6,450.00 5,493.55 85.2%Total-CBR-REPAIRS & MAINTENANCE956.45 800.00 156.45 956.45 800.00 156.45 10,050.00 9,093.55 90.5%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen660.06 800.00 (139.94) 660.06 800.00 (139.94) 9,600.00 8,939.94 93.1%6419220 Freight/Delivery- 75.00 (75.00) - 75.00 (75.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) - 600.00 (600.00) 7,200.00 7,200.00 100.0%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES660.06 1,475.00 (814.94) 660.06 1,475.00 (814.94) 22,450.00 21,789.94 97.1%TOTAL-CARTS,BAGROOM & RANGE11,703.12 11,752.00 (814.94) 11,703.12 11,752.00 (48.88) 237,434.00 223,880.88 94.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp81.70 99.00 (17.30) 81.70 99.00 (17.30) 2,179.00 2,097.30 96.3%6431800 Taxes-Employer Payroll287.52 369.00 (81.48) 287.52 369.00 (81.48) 8,135.00 7,847.48 96.5%6431880 Wages-Hourly3,095.00 2,639.00 456.00 3,095.00 2,639.00 456.00 58,108.00 55,013.00 94.7%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,464.22 3,107.00 357.22 3,464.22 3,107.00 357.22 68,422.00 64,957.78 94.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable121.84 50.00 71.84 121.84 50.00 71.84 1,050.00 928.16 88.4%6439490 Miscellaneous- - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 75.00 (75.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES121.84 175.00 (53.16) 121.84 175.00 (53.16) 3,975.00 3,853.16 96.9%Total-COURSE SERVICES3,586.06 3,282.00 304.06 3,586.06 3,282.00 304.06 72,397.00 68,810.94 95.0%15,289.18 15,034.00 255.18 15,289.18 15,034.00 255.18 309,831.00 288,838.66 93.2%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementJuly 2016Annual Budget7 JulyFinal 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,400.00 91.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7%65-CH-UTILITIES6507836 Utilities-Natural Gas172.01 300.00 (127.99) 172.01 300.00 (127.99) 3,600.00 3,427.99 95.2%6507840 Utilities-Telephone1,090.00 1,150.00 (60.00) 1,090.00 1,150.00 (60.00) 13,800.00 12,710.00 92.1%6507842 Utilities-Water- 321.00 (321.00) - 321.00 (321.00) 3,852.00 3,852.00 100.0%6507844 Utilities-Cable485.47 340.00 145.47 485.47 340.00 145.47 4,080.00 3,594.53 88.1%Total-CH-UTILITIES1,747.48 2,111.00 (363.52) 1,747.48 2,111.00 (363.52) 25,332.00 23,584.52 93.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 1,825.00 1,825.00 - 22,500.00 20,675.00 91.9%6509099 Contract Services-Security5,158.56 4,900.00 258.56 5,158.56 4,900.00 258.56 60,400.00 55,241.44 91.5%6509215 Flowers & Decorations63.73 - 63.73 63.73 - 63.73 1,900.00 1,836.27 96.6%6509490 Miscellaneous24.68 200.00 (175.32) 24.68 200.00 (175.32) 7,000.00 6,975.32 99.6%6509718 Safety Equipment & Training- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,071.97 7,025.00 46.97 7,071.97 7,025.00 46.97 93,000.00 85,928.03 92.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures235.56 300.00 (64.44) 235.56 300.00 (64.44) 3,600.00 3,364.44 93.5%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.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 & MAINTENANCE235.56 1,100.00 (864.44) 235.56 1,100.00 (864.44) 13,200.00 12,964.44 98.2%9,455.01 10,636.00 (1,180.99) 9,455.01 10,636.00 (1,180.99) 136,332.00 25,928.88 19.0%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementJuly 2016Annual Budget8 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 338.00 341.00 (3.00) 338.00 341.00 (3.00) 4,092.00 3,754.00 91.7%6601325 Insurance-Workers Comp87.90 94.00 (6.10) 87.90 94.00 (6.10) 1,129.00 1,041.10 92.2%6601720 Salaries1,904.96 2,508.00 (603.04) 1,904.96 2,508.00 (603.04) 30,096.00 28,191.04 93.7%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 145.20 351.00 (205.80) 4,213.00 4,067.80 96.6%Total-MKT-SALARIES & BENEFITS2,476.06 3,294.00 (817.94) 2,476.06 3,294.00 (817.94) 39,530.00 37,053.94 93.7%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 275.93 - 275.93 275.93 - 275.93 4,425.00 4,149.07 93.8%275.93 100.00 175.93 275.93 100.00 175.93 5,625.00 5,349.07 95.1%66-MKT-UTILITIES6607840 Utilities-Telephone 67.08 100.00 (32.92) 67.08 100.00 (32.92) 1,200.00 1,132.92 94.4%Total-MKT-UTILITIES67.08 100.00 (32.92) 67.08 100.00 (32.92) 1,200.00 1,132.92 94.4%66-MKT-OTHER EXPENSES6609010 Advertising 5,161.81 3,745.00 1,416.81 5,161.81 3,745.00 1,416.81 178,987.00 173,825.19 97.1%6609040 Business Meals- 25.00 (25.00) - 25.00 (25.00) 300.00 300.00 100.0%6609080 Collateral Material- - - - - - 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page99.00 150.00 (51.00) 99.00 150.00 (51.00) 1,800.00 1,701.00 94.5%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- - - - - - 700.00 700.00 100.0%6609633 Promotion-Community- 75.00 (75.00) - 75.00 (75.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES5,260.81 4,045.00 1,215.81 5,260.81 4,045.00 1,215.81 193,822.00 188,561.19 97.3%8,079.88 7,539.00 540.88 8,079.88 7,539.00 540.88 240,177.00 232,097.12 96.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementJuly 2016Annual Budget9 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,281.00 1,488.00 (207.00) 1,281.00 1,488.00 (207.00) 17,856.00 16,575.00 92.8%6701325 Insurance-Workers Comp581.50 594.00 (12.50) 581.50 594.00 (12.50) 7,717.00 7,135.50 92.5%6701720 Salaries12,421.00 13,250.00 (829.00) 12,421.00 13,250.00 (829.00) 177,996.00 165,575.00 93.0%6701800 Taxes-Employer Payroll1,309.15 2,219.00 (909.85) 1,309.15 2,219.00 (909.85) 28,812.00 27,502.85 95.5%6701880 Wages-Hourly4,034.20 2,600.00 1,434.20 4,034.20 2,600.00 1,434.20 27,800.00 23,765.80 85.5%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS19,626.85 20,151.00 (524.15) 19,626.85 20,151.00 (524.15) 260,181.00 240,554.15 92.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) - 500.00 (500.00) 6,300.00 6,300.00 100.0%6703762 Supplies-Office- 150.00 (150.00) - 150.00 (150.00) 1,800.00 1,800.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- 750.00 (750.00) - 750.00 (750.00) 11,400.00 11,400.00 100.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- - - - - - 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- - - - - - 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 500.00 500.00 - 4,800.00 4,300.00 89.6%6709150 Dues & Subscriptions- 50.00 (50.00) - 50.00 (50.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation- - - - - - 1,400.00 1,400.00 100.0%6709197 Equipment Rental389.56 550.00 (160.44) 389.56 550.00 (160.44) 6,600.00 6,210.44 94.1%6709202 Fees-Bank- 90.00 (90.00) - 90.00 (90.00) 1,080.00 1,080.00 100.0%6709208 Fees-Payroll Processing690.02 1,200.00 (509.98) 690.02 1,200.00 (509.98) 14,400.00 13,709.98 95.2%6709220 Freight/Delivery10.75 50.00 (39.25) 10.75 50.00 (39.25) 600.00 589.25 98.2%6709490 Miscellaneous- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services52.99 75.00 (22.01) 52.99 75.00 (22.01) 900.00 847.01 94.1%6709625 Professional Fees1,267.92 850.00 417.92 1,267.92 850.00 417.92 10,200.00 8,932.08 87.6%6709636 Promotion/Entertainment- 100.00 (100.00) - 100.00 (100.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6709810 Travel- - - - - - 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 - 75.00 (75.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES2,911.24 3,840.00 46.24 2,911.24 3,840.00 (928.76) 54,030.00 51,118.76 94.6%22,538.09 24,741.00 (2,202.91) 22,538.09 24,741.00 (2,202.91) 327,511.00 304,972.91 93.1%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2016Annual Budget10 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 10,363.45 10,050.00 313.45 121,050.00 110,686.55 91.4%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 5,571.50 6,050.00 (478.50) 72,600.00 67,028.50 92.3%6800194 Equipment Leases-Trailer542.07 600.00 (57.93) 542.07 600.00 (57.93) 7,200.00 6,657.93 92.5%6800196 Equipment Leases-GPS4,480.00 4,700.00 (220.00) 4,480.00 4,700.00 (220.00) 56,400.00 51,920.00 92.1%6800197 Equipment Leases-Others2,022.58 1,150.00 872.58 2,022.58 1,150.00 872.58 13,800.00 11,777.42 0.0%22,979.60 22,550.00 429.60 22,979.60 22,550.00 429.60 271,050.00 248,070.40 91.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 8,652.80 8,653.00 (0.20) 99,840.00 91,187.20 91.3%6900210 FF&E Reserve1,396.59 533.00 863.59 1,396.59 533.00 863.59 63,985.00 62,588.41 97.8%6900800 Personal Property Taxes5,540.00 5,200.00 340.00 5,540.00 5,200.00 340.00 11,800.00 6,260.00 53.1%6900323 Insurance-Commercial3,405.25 2,700.00 705.25 3,405.25 2,700.00 705.25 26,400.00 22,994.75 87.1%18,994.64 17,086.00 1,908.64 18,994.64 17,086.00 1,908.64 202,025.00 183,030.36 90.6%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 2016Annual BudgetMonth to DateYear to Date11 SilverRock Resort‐Arnold Palmer Classic CourseComp Golf Report‐2016‐20172016 2016 2016 2016 2016 2016Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4SalesPromotionGolf IndustryVIPCelebrityPGA Comp34Charity/Gift Certificate1Rain/Wind Checks1Club Staff47LQ HS Golf592000002017 2017 2017 2017 2017 2017Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2016‐2017July 2016 Date Time DescriptionCategoryPlayers7/2/2016 10:00 a.m. Kris Long CBS 2 Media 413