Loading...
03 September 2017 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2017 – September 2017 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 SeptemberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue35,898.25 36,637.00 (738.75) -2.0% 80,529.00 92,703.00 (12,174.00) 2,964,060.00 2,883,531.00 3%401000 Miscellaneous Golf Revenue8,045.00 2,775.00 5,270.00 189.9% 16,187.00 8,056.00 8,131.00 166,766.00 150,579.00 10%410000 Revenue-Golf Shop4,953.86 6,440.00 (1,486.14) -23.1% 12,314.12 13,763.00 (1,448.88) 262,017.00 249,702.88 5%420000 Revenue-F&B Concession500.00 500.00 - 0.0%1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income- - - - - - - - 0%Total Income49,397.11 46,352.00 3,045.11 6.6% 110,530.12 116,022.00 (5,491.88) 3,404,843.00 3,294,312.88 3%Cost of Goods Sold510000 COS-Golf Shop2,888.25 3,604.20 (715.95) 19.9%7,409.31 7,703.54 294.23 146,651.00 139,241.69 5%Total COS2,888.25 3,604.20 (715.95) 19.9%7,409.31 7,703.54 294.23 146,651.00 139,241.69 5%Gross Profit46,508.86 42,747.80 3,761.06 8.8% 103,120.81 108,318.46 (5,197.65) 3,258,192.00 3,155,071.19 3%Expenses610000 Golf Pro Shop 14,350.07 12,405.00 1,945.07 -15.7% 41,933.55 37,959.00 3,974.55 199,990.00 158,056.45 21%630000 Course Maintenance128,025.58 135,077.67 (7,052.09) 5.2% 353,191.89 376,015.67 (22,823.78) 1,735,790.00 1,382,598.11 20%633000 Maintenance Water & Energy21,181.36 22,747.00 (1,565.64) 6.9% 61,795.91 68,972.00 (7,176.09) 249,838.00 188,042.09 25%640000 Outside Services14,540.96 18,457.00 (3,916.04) 21.2% 58,122.82 54,298.00 3,824.82 331,964.00 273,841.18 18%650000 Clubhouse10,967.89 10,776.00 191.89 -1.8% 31,179.88 32,328.00 (1,148.12) 136,412.00 105,232.12 23%660000 Marketing17,909.72 14,673.00 3,236.72 -22.1% 39,947.33 29,715.00 10,232.33 230,960.00 191,012.67 17%670000 General & Administrative21,872.92 24,641.00 (2,768.08) 11.2% 67,979.92 75,177.00 (7,197.08) 329,053.00 261,073.08 21%680000 Leases25,786.35 22,550.00 3,236.35 -14.4% 76,745.63 67,650.00 9,095.63 321,050.00 244,304.37 24%690000 Miscellaneous Other Expense24,943.09 16,431.00 8,512.09 -51.8% 51,747.33 46,151.00 5,596.33 211,468.00 159,720.67 24%Total Expenses279,577.94 277,757.67 1,820.27 -0.7% 782,644.26 788,265.67 5,621.41 3,746,525.00 2,963,880.74 21%(233,069.08) (235,009.87) 1,940.79 0.8%(679,523.45) (679,947.21) 423.76 (488,333.00) 191,190.45 0%Rounds of Golf PlayedPaid Rounds Played1,398 1,422 (24) -1.7%3,305 3,668 (363) 42,173 38,868 8%Ave $ Per Paid Round Green Fee25.68 25.76 (0.09) -0.3%24.37 25.27 (0.91) 70.28 45.92 35%Ave $ Per Paid Round Merchandise3.54 4.53 (0.99) -21.8%3.73 3.75 (0.03) 6.21 2.49 60%Ave $ Per Paid Miscellaneous 5.75 1.95 3.80 194.9%4.90 2.20 2.70 3.95 (0.94) 124%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateSeptember 20171 Income SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees35,898.25 36,637.00 (738.75) 80,529.00 92,703.00 (12,174.00) 2,964,060.00 2,883,531.00 97.3%4010000 Rider Fee225.00 142.00 83.00 410.00 367.00 43.00 7,307.00 6,897.00 94.4%4040000 Club Rental680.00 711.00 (31.00) 1,460.00 1,835.00 (375.00) 21,087.00 19,627.00 93.1%4050000 Driving Range3,090.00 1,422.00 1,668.00 6,667.00 3,354.00 3,313.00 94,872.00 88,205.00 93.0%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - - 1,000.00 (1,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee- - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue4,050.00 500.00 3,550.00 7,650.00 1,500.00 6,150.00 165,300.00 157,650.00 95.4% Total Revenue Fees43,943.25 39,412.00 4,531.25 96,716.00 100,759.00 (4,043.00) 3,296,126.00 3,199,410.00 97.1%43,943.25 39,412.00 4,531.25 96,716.00 100,759.00 (4,043.00) 3,296,126.00 3,199,410.00 97.1%SilverRock ResortStatement of Fees RevenueSeptember 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$8,045.00 $2,775.00 5,270.00Favorable: Due to Resident Card issue up.ActualBudgetVariance$4,953.86 $6,440.00 (1,486.14)Unfavorable: Due to reduced cost of green fees, and reduction of inventory to prepare for new season.ExpensesActualBudgetVariance$14,350.07$12,405.001,945.07Unfavorable: Due to labor cost driven by assistance in other departments.ActualBudgetVariance$14,540.96$18,457.00(3,916.04)Favorable: Due to reduced payroll and expenses as a result of reduced play.ActualBudgetVariance$17,909.72$14,673.003,236.72Unfavorable: Due to timing of advertising invoices.ActualBudgetVariance$21,872.92$24,641.00(2,768.08)Favorable: Due to less expenditures on line items to assist with reduced income of course.ActualBudgetVariance$25,471.92$28,800.00(3,328.08)Unfavorable: Erroneously budgeted previous lease payments amounts for the first 4 months of the new fiscal year.ActualBudgetVariance$24,943.09$16,431.008,512.09Unfavorable: Due to personal property tax for property and equipment. The timing of the new leases changed budget payment dates.Variance ExplanationSeptember 2017The 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 areprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesMiscellaneous Golf RevenueGolf ShopGeneral and AdministrativeMarketingMiscellaneous Other ExpenseLeasesOutside Services3-20-133 Income SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous302.21 - 302.21 851.10 - 851.10 00 0%4100110 Sales Hard Goods1,798.77 2,254.00 (455.23) 4,744.40 4,817.00 (72.60) 91,706.00 86,961.60 94.8%4100112 Sales-Soft Goods3,788.34 4,186.00 (397.66) 8,684.90 8,946.00 (261.10) 170,311.00 161,626.10 94.9%5100639 GS-Discounts-Mdse(935.46) - (935.46) (1,966.28) - (1,966.28) - 1,966.28 0.0% Total Revenue Golf Shop4,953.86 6,440.00 (1,486.14) 12,314.12 13,763.00 (1,448.88) 262,017.00 250,553.98 95.6%COS 5100150 COS-GS-Hard Goods 921.20 1,307.32 (386.12) 2,669.71 2,793.86 (124.15) 53,189.48 50,519.77 95.0%5100151 COS-GS-Soft Goods 1,680.50 2,427.88 (747.38) 4,083.74 5,188.68 (1,104.94) 97,137.52 93,053.78 95.8%5100152 COS-GS-Purchase Disc (6.48) (187.00) 180.52 (7.62) (399.00) 391.38 (7,598.00) (7,590.38) 99.9%5100220 COS-GS-Freight Merch 293.03 56.00 237.03 663.48 120.00 543.48 2,280.00 1,616.52 70.9%Cost of Sales - Golf Shop2,888.25 3,604.20 (715.95) 7,409.31 7,703.54 (294.23) 145,009.00 137,599.69 94.9%Gross Profit 2,065.61 2,835.80 (770.19) 4,904.81 6,059.46 (1,154.65) 117,008.00 112,954.29 96.5%COS % 58.3% 56.0% -2.3% 60.2% 56.0% -4.2% 53.1% 54.9% 103.5%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,615.72 1,740.00 875.72 5,714.52 5,220.00 494.52 26,796.00 21,081.48 78.7%6101325 Insurance-Workers Comp 301.50 307.00 (5.50) 2,061.84 945.00 1,116.84 4,957.00 2,895.16 58.4%6101720 Salaries4,000.00 4,001.00 (1.00) 12,000.00 12,003.00 (3.00) 45,000.00 33,000.00 73.3%6101800 Taxes-Employer Payroll 732.66 1,064.00 (331.34) 2,310.97 3,274.00 (963.03) 18,825.00 16,514.03 87.7%6101880 Wages-Hourly5,577.26 4,183.00 1,394.26 16,898.66 13,187.00 3,711.66 87,179.00 70,280.34 80.6%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 13,227.14 11,295.00 1,932.14 38,985.99 34,629.00 4,356.99 182,757.00 144,723.89 79.2%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) 83.97 750.00 (666.03) 3,000.00 2,916.03 97.2%6109220 Freight & Delivery18.55 - 18.55 89.16 - 89.16 75.00 (14.16) -18.9%6109490 Miscellaneous- 500.00 (500.00) 1,000.00 1,500.00 (500.00) 6,000.00 5,000.00 83.3%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short1.75 - 1.75 153.20 - 153.20 - (153.20) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 450.00 (450.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms758.03 100.00 658.03 1,068.57 300.00 768.57 2,400.00 1,331.43 55.5%6117840 Telephones344.60 110.00 234.60 552.66 330.00 222.66 1,320.00 767.34 58.1%1,122.93 1,110.00 12.93 2,947.56 3,330.00 (382.44) 18,875.00 15,927.44 84.4%14,350.07 12,405.00 1,945.07 41,933.55 37,959.00 3,974.55 201,632.00 160,651.33 79.7%Net Income(12,284.46) (9,569.20) (2,715.26) (37,028.74) (31,899.54) (5,129.20) (84,624.00) (47,697.04) 56.4%SilverRock ResortGolf Shop Income StatementSeptember 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,058.92 7,425.00 (366.08) 22,145.01 22,275.00 (129.99) 103,020.00 80,874.99 78.5%6311325 Insurance-Workers Comp1,871.50 1,941.00 (69.50) 7,906.92 5,953.00 1,953.92 26,974.00 19,067.08 70.7%6311720 Salaries11,557.08 12,200.00 (642.92) 34,671.24 36,600.00 (1,928.76) 146,400.00 111,728.76 76.3%6311800 Taxes-Employer Payroll3,165.00 6,729.00 (3,564.00) 9,204.96 20,635.00 (11,430.04) 91,481.00 82,276.04 89.9%6311880 Wages-Hourly34,951.16 35,003.67 (52.51) 118,508.79 117,571.67 937.12 567,262.00 448,753.21 79.1%6311882 Wages-Overtime13,613.57 - 13,613.57 13,613.57 - 13,613.57 12,350.00 (1,263.57) -10.2%Total-CM-SALARIES & BENEFITS72,217.23 63,298.67 8,918.56 206,050.49 203,034.67 3,015.82 947,487.00 741,436.51 78.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals1,589.40 7,820.00 (6,230.60) 11,006.49 14,982.00 (3,975.51) 17,760.00 6,753.51 38.0%6313744 Fertilizer- 9,880.00 (9,880.00) 4,532.47 17,850.00 (13,317.53) 105,970.00 101,437.53 95.7%6313745 Herbicides- - - 434.88 - 434.88 25,518.00 25,083.12 98.3%6313746 Flowers/Plants- 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline1,878.68 4,050.00 (2,171.32) 7,252.05 11,130.00 (3,877.95) 48,950.00 41,697.95 85.2%6313750 Golf Course Accessories- - - 989.40 - 989.40 13,140.00 12,150.60 92.5%6313756 POA Control- 2,400.00 (2,400.00) - 2,400.00 (2,400.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp572.55 750.00 (177.45) 762.55 2,250.00 (1,487.45) 4,350.00 3,587.45 82.5%6313762 Supplies-Office- - - 36.00 - 36.00 - (36.00) 0.0%6313774 Sand2,250.01 5,000.00 (2,749.99) 2,250.01 5,780.00 (3,529.99) 13,460.00 11,209.99 83.3%6313776 Seed- - - 3,409.31 - 3,409.31 117,400.00 113,990.69 97.1%6313778 Small Tools & Non-Capital Equip44.27 2,000.00 (1,955.73) 44.27 2,200.00 (2,155.73) 5,000.00 4,955.73 99.1%6313780 Sod3,893.25 1,000.00 2,893.25 4,866.56 8,800.00 (3,933.44) 13,500.00 8,633.44 64.0%6313782 Topdressing- - - 4,975.15 2,200.00 2,775.15 10,000.00 5,024.85 50.2%Total-CM-SUPPLIES & MATERIALS10,228.16 33,900.00 (23,671.84) 40,559.14 68,592.00 (28,032.86) 387,998.00 347,438.86 89.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 10,424.24 8,490.00 1,934.24 33,960.00 23,535.76 69.3%6315685 CM-R&M-Bldngs & Othr Structures- 550.00 (550.00) 1,731.35 2,550.00 (818.65) 5,550.00 3,818.65 68.8%6315690 CM-R&M-Equipment2,841.15 3,000.00 (158.85) 8,484.28 7,500.00 984.28 38,500.00 30,015.72 78.0%6315692 CM-R&M-Irrigation System1,707.17 1,500.00 207.17 8,400.89 9,400.00 (999.11) 19,050.00 10,649.11 55.9%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 1,276.48 3,000.00 (1,723.52) 10,500.00 9,223.52 87.8%6315815 CM-R&M-Trees-Pruning Etc5,480.00 5,500.00 (20.00) 6,680.00 5,500.00 1,180.00 12,050.00 5,370.00 44.6%Total-CM-REPAIRS & MAINTENANCE13,868.32 14,380.00 (511.68) 36,997.24 36,440.00 557.24 119,610.00 82,612.76 69.1%6317836 Utilities-Natural Gas/LPG 18.05 15.00 3.05 77.39 45.00 32.39 180.00 102.61 0.0%6317840 Telephones807.65 850.00 (42.35) 3,699.26 2,550.00 1,149.26 10,200.00 6,500.74 63.7%Total-CM-UTILITIES825.70 865.00 (39.30) 3,776.65 2,595.00 1,181.65 10,380.00 6,603.35 63.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6319100 Contract Svcs-Soil/Tissue Test- 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 2,000.00 2,000.00 100.0%6319102 Contract Svcs-Trash Removal- 524.00 (524.00) - 1,572.00 (1,572.00) 6,288.00 6,288.00 100.0%6319150 Dues & Subscriptions210.00 - 210.00 210.00 - 210.00 680.00 470.00 69.1%6319170 Employee Education- 50.00 (50.00) - 150.00 (150.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental1,785.29 150.00 1,635.29 1,785.29 500.00 1,285.29 3,400.00 1,614.71 47.5%6319206 Licenses & Permits239.29 - 239.29 239.29 100.00 139.29 4,300.00 4,060.71 94.4%6319490 Miscellaneous40.69 100.00 (59.31) 53.37 300.00 (246.63) 1,200.00 1,146.63 95.6%6319718 Safety Equipment & Training- 750.00 (750.00) - 1,050.00 (1,050.00) 3,850.00 3,850.00 100.0%6319822 Uniforms837.88 920.00 (82.12) 2,040.17 2,760.00 (719.83) 11,040.00 8,999.83 81.5%Total-CM-OTHER EXPENSES3,513.15 3,894.00 (380.85) 5,528.12 8,632.00 (3,103.88) 41,458.00 35,929.88 86.7%SilverRock ResortCourse Maintenance Expense StatementSeptember 2017Annual BudgetMonth to DateYear to Date5 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 11,847.04 2,784.00 9,063.04 15,842.94 8,352.00 7,490.94 33,408.00 17,565.06 52.6%6321325 Insurance-Workers Comp480.00 484.00 (4.00) 1,737.38 1,484.00 253.38 5,955.00 4,217.62 70.8%6321800 Taxes-Employer Payroll828.82 1,678.00 (849.18) 2,448.26 5,144.00 (2,695.74) 20,793.00 18,344.74 88.2%6321880 Wages-Hourly12,790.57 12,904.00 (113.43) 37,873.54 39,572.00 (1,698.46) 156,528.00 118,654.46 75.8%6321882 Wages-Overtime200.52 - 200.52 200.52 - 200.52 3,418.00 3,217.48 94.1%Total-CM-LM-SALARIES & BENEFITS26,146.95 17,850.00 8,296.95 58,102.64 54,552.00 3,550.64 220,102.00 161,999.36 73.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools386.77 100.00 286.77 386.77 300.00 86.77 1,025.00 638.23 62.3%6323788 Uniforms- 290.00 (290.00) 268.43 870.00 (601.57) 3,480.00 3,211.57 92.3%Total-CM-LM-SUPPLIES & MATERIALS386.77 390.00 (3.23) 655.20 1,170.00 (514.80) 4,505.00 3,849.80 85.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation839.30 500.00 339.30 1,522.41 1,000.00 522.41 4,250.00 2,727.59 64.2%Total-CM-LM-REPAIRS & MAINTENANCE839.30 500.00 339.30 1,522.41 1,000.00 522.41 4,250.00 2,727.59 64.2%128,025.58 135,077.67 (7,052.09) 353,191.89 376,015.67 (22,823.78) 1,735,790.00 1,382,598.11 79.7% SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 11,265.53 13,815.00 (2,549.47) 34,663.75 40,900.00 (6,236.25) 179,791.00 145,127.25 80.7%6337842 Utilities-Water9,915.83 8,932.00 983.83 27,132.16 28,072.00 (939.84) 70,047.00 42,914.84 61.3%21,181.36 22,747.00 (1,565.64) 61,795.91 68,972.00 (7,176.09) 249,838.00 188,042.09 75.3%Silverrock ResortCourse Maintenance Water & EnergySeptember 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementSeptember 2017Silverrock ResortAnnual BudgetMonth to DateYear to Date6 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 2,088.00 (2,088.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp331.50 339.00 (7.50) 2,545.16 867.00 1,678.16 5,623.00 3,077.84 54.7%6411800 Taxes-Employer Payroll490.75 1,127.00 (636.25) 1,555.91 2,881.00 (1,325.09) 18,667.00 17,111.09 91.7%6411880 Wages-Hourly8,883.17 9,053.00 (169.83) 20,655.64 23,142.00 (2,486.36) 149,934.00 129,278.36 86.2%6411882 Wages-Overtime - - - 25.13 - 25.13 - (25.13) 0.0%Total-CBR-SALARIES & BENEFITS9,705.42 11,215.00 (1,509.58) 24,781.84 28,978.00 (4,196.16) 182,576.00 157,794.16 86.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable282.99 150.00 132.99 1,188.88 1,350.00 (161.12) 6,750.00 5,561.12 82.4%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 100.00 (100.00) 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) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 240.00 120.00 120.00 880.00 360.00 520.00 2,182.00 1,302.00 59.7%6413796 Supplies-Bottled Water107.75 100.00 7.75 323.25 4,600.00 (4,276.75) 12,900.00 12,576.75 97.5%Total-CBR-SUPPLIES & MATERIALS630.74 495.00 135.74 2,392.13 6,485.00 (4,092.87) 36,627.00 32,384.87 88.4%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment325.00 300.00 25.00 17,151.68 900.00 16,251.68 3,600.00 (13,551.68) -376.4%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 500.00 1,500.00 (1,000.00) 6,450.00 5,950.00 92.2%Total-CBR-REPAIRS & MAINTENANCE325.00 800.00 (475.00) 17,651.68 2,400.00 15,251.68 10,050.00 (7,601.68) -75.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen527.35 800.00 (272.65) 1,883.87 2,400.00 (516.13) 9,600.00 7,716.13 80.4%6419220 Freight/Delivery- 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 550.91 1,800.00 (1,249.09) 7,200.00 6,649.09 92.3%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES527.35 1,475.00 (947.65) 2,434.78 4,425.00 (1,990.22) 22,450.00 20,015.22 89.2%TOTAL-CARTS,BAGROOM & RANGE11,188.51 13,985.00 (947.65) 47,260.43 42,288.00 4,972.43 251,703.00 202,592.57 80.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp109.50 136.00 (26.50) 1,618.36 366.00 1,252.36 2,450.00 831.64 33.9%6431800 Taxes-Employer Payroll239.92 473.00 (233.08) 704.83 1,273.00 (568.17) 8,494.00 7,789.17 91.7%6431880 Wages-Hourly3,003.03 3,638.00 (634.97) 8,539.20 9,796.00 (1,256.80) 65,341.00 56,801.80 86.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,352.45 4,247.00 (894.55) 10,862.39 11,435.00 (572.61) 76,285.00 65,422.61 85.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 200.00 (200.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 225.00 (225.00) - 575.00 (575.00) 3,975.00 3,975.00 100.0%Total-COURSE SERVICES3,352.45 4,472.00 (1,119.55) 10,862.39 12,010.00 (1,147.61) 80,260.00 69,397.61 86.5%14,540.96 18,457.00 (3,916.04) 58,122.82 54,298.00 3,824.82 331,963.00 268,015.18 80.7%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementSeptember 2017Annual Budget7 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%65-CH-UTILITIES6507836 Utilities-Natural Gas343.24 300.00 43.24 897.25 900.00 (2.75) 3,600.00 2,702.75 75.1%6507840 Utilities-Telephone1,074.13 1,150.00 (75.87) 2,146.59 3,450.00 (1,303.41) 13,800.00 11,653.41 84.4%6507842 Utilities-Water450.64 321.00 129.64 1,196.37 963.00 233.37 3,852.00 2,655.63 68.9%6507844 Utilities-Cable494.43 380.00 114.43 1,475.41 1,140.00 335.41 4,560.00 3,084.59 67.6%Total-CH-UTILITIES2,362.44 2,151.00 211.44 5,715.62 6,453.00 (737.38) 25,812.00 20,096.38 77.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 5,585.00 5,475.00 110.00 22,500.00 16,915.00 75.2%6509099 Contract Services-Security5,608.56 5,000.00 608.56 15,989.82 15,000.00 989.82 60,000.00 44,010.18 73.4%6509215 Flowers & Decorations- - - - - - 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 600.00 (600.00) 7,000.00 7,000.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,433.56 7,125.00 308.56 21,574.82 21,375.00 199.82 92,600.00 71,025.18 76.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures771.89 300.00 471.89 2,689.44 900.00 1,789.44 3,600.00 910.56 25.3%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 1,200.00 (1,200.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 1,200.00 (1,200.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE771.89 1,100.00 (328.11) 2,689.44 3,300.00 (610.56) 13,200.00 10,510.56 79.6%10,967.89 10,776.00 191.89 31,179.88 32,328.00 (1,148.12) 136,412.00 21,021.12 15.4%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementSeptember 2017Annual Budget8 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 702.04 348.00 354.04 1,401.06 1,044.00 357.06 4,176.00 2,774.94 66.4%6601325 Insurance-Workers Comp91.00 94.00 (3.00) 298.00 282.00 16.00 1,129.00 831.00 73.6%6601720 Salaries1,904.96 2,508.00 (603.04) 5,714.88 7,524.00 (1,809.12) 30,096.00 24,381.12 81.0%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 435.60 978.00 (542.40) 3,912.00 3,476.40 88.9%Total-MKT-SALARIES & BENEFITS2,843.20 3,276.00 (432.80) 7,849.54 9,828.00 (1,978.46) 39,313.00 31,463.46 80.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 203.83 100.00 103.83 332.17 300.00 32.17 1,200.00 867.83 72.3%6603768 Supplies-Printing & Stationery 274.67 200.00 74.67 973.81 200.00 773.81 4,425.00 3,451.19 78.0%478.50 300.00 178.50 1,305.98 500.00 805.98 5,625.00 4,319.02 76.8%66-MKT-UTILITIES6607840 Utilities-Telephone 163.08 100.00 63.08 383.88 300.00 83.88 1,200.00 816.12 68.0%Total-MKT-UTILITIES163.08 100.00 63.08 383.88 300.00 83.88 1,200.00 816.12 68.0%66-MKT-OTHER EXPENSES6609010 Advertising13,939.07 10,697.00 3,242.07 27,659.75 18,187.00 9,472.75 169,987.00 142,327.25 83.7%6609040 Business Meals- 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0%6609080 Collateral Material- - - - - - 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page- 150.00 (150.00) 198.00 450.00 (252.00) 1,800.00 1,602.00 89.0%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6609630 Promotion- - - 2,064.31 - 2,064.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community485.87 75.00 410.87 485.87 225.00 260.87 2,250.00 1,764.13 78.4%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 EXPENSES14,424.94 10,997.00 3,427.94 30,407.93 19,087.00 11,320.93 184,822.00 154,414.07 83.5%17,909.72 14,673.00 3,236.72 39,947.33 29,715.00 10,232.33 230,960.00 191,012.67 82.7%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementSeptember 2017Annual Budget9 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,167.54 1,509.00 658.54 5,193.72 4,527.00 666.72 18,108.00 12,914.28 71.3%6701325 Insurance-Workers Comp601.00 610.00 (9.00) 1,855.38 1,852.00 3.38 7,905.00 6,049.62 76.5%6701720 Salaries12,800.00 13,250.00 (450.00) 38,400.00 40,350.00 (1,950.00) 177,996.00 139,596.00 78.4%6701800 Taxes-Employer Payroll1,153.06 2,115.00 (961.94) 3,459.18 6,423.00 (2,963.82) 32,800.00 29,340.82 89.5%6701880 Wages-Hourly2,272.69 2,412.00 (139.31) 6,818.04 8,440.00 (1,621.96) 27,404.00 20,585.96 75.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS18,994.29 19,896.00 (901.71) 55,726.32 61,592.00 (5,865.68) 264,213.00 208,486.68 78.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer277.29 500.00 (222.71) 2,419.07 1,500.00 919.07 6,300.00 3,880.93 61.6%6703762 Supplies-Office- 105.00 (105.00) 58.45 315.00 (256.55) 1,260.00 1,201.55 95.4%6703768 Supplies-Printing & Stationery- 100.00 (100.00) - 300.00 (300.00) 3,300.00 3,300.00 100.0%Total-G&A-SUPPLIES & MATERIALS277.29 705.00 (427.71) 2,477.52 2,115.00 362.52 10,860.00 8,382.48 77.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6709150 Dues & Subscriptions- 200.00 (200.00) 420.00 250.00 170.00 1,150.00 730.00 63.5%6709180 Employee Recruiting/Relocation120.00 150.00 (30.00) 221.95 150.00 71.95 1,200.00 978.05 81.5%6709197 Equipment Rental723.42 550.00 173.42 1,740.81 1,650.00 90.81 6,600.00 4,859.19 73.6%6709202 Fees-Bank149.71 90.00 59.71 375.08 270.00 105.08 1,080.00 704.92 65.3%6709208 Fees-Payroll Processing314.25 1,000.00 (685.75) 2,196.98 3,000.00 (803.02) 12,000.00 9,803.02 81.7%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous61.40 100.00 (38.60) 144.38 300.00 (155.62) 6,600.00 6,455.62 97.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services149.61 75.00 74.61 372.60 225.00 147.60 900.00 527.40 58.6%6709625 Professional Fees582.95 850.00 (267.05) 2,269.10 2,550.00 (280.90) 10,200.00 7,930.90 77.8%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 600.00 (350.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 285.18 225.00 60.18 1,050.00 764.82 72.8%Total-G&A-OTHER EXPENSES2,601.34 3,940.00 (363.66) 9,776.08 11,270.00 (1,493.92) 52,080.00 42,303.92 81.2%21,872.92 24,641.00 (2,768.08) 67,979.92 75,177.00 (7,197.08) 329,053.00 261,073.08 79.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2017Annual Budget10 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 29,487.81 30,150.00 (662.19) 121,050.00 91,562.19 75.6%6800193 Equipment Leases-Maintenance 9,181.20 6,050.00 3,131.20 27,543.60 18,150.00 9,393.60 116,200.00 88,656.40 76.3%6800194 Equipment Leases-Trailer818.39 600.00 218.39 1,902.53 1,800.00 102.53 7,200.00 5,297.47 73.6%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 11,610.00 14,100.00 (2,490.00) 56,400.00 44,790.00 79.4%6800197 Equipment Leases-Others2,087.49 1,150.00 937.49 6,201.69 3,450.00 2,751.69 20,200.00 13,998.31 0.0%25,786.35 22,550.00 3,236.35 76,745.63 67,650.00 9,095.63 321,050.00 244,304.37 76.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,152.80 8,999.00 153.80 26,458.40 26,997.00 (538.60) 107,987.00 81,528.60 75.5%6900210 FF&E Reserve717.97 732.00 (14.03) 1,610.59 1,854.00 (243.41) 59,281.00 57,670.41 97.3%6900800 Personal Property Taxes15,072.32 4,000.00 11,072.32 15,095.97 9,200.00 5,895.97 11,800.00 (3,295.97) -27.9%6900323 Insurance-Commercial- 2,700.00 (2,700.00) 8,582.37 8,100.00 482.37 32,400.00 23,817.63 73.5%24,943.09 16,431.00 8,512.09 51,747.33 46,151.00 5,596.33 211,468.00 159,720.67 75.5%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2017Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-20182017 2017 2017 2017 2017 2017Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp20 12 27Charity/Gift Certificate22Rain/Wind ChecksClub Staff53 38 65LQ HS Golf106685 58 980002018 2018 2018 2018 2018 2018Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012