Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 October 2019 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2019 – October 2019 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 October 2019 Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue48,865.75 45,305.00 3,560.75 7.9% 302,312.94 322,141.00 (19,828.06) 3,209,134.00 2,906,821.06 9%401000 Miscellaneous Golf Revenue7,932.50 8,729.00 (796.50) -9.1% 29,157.50 16,285.00 12,872.50 300,066.00 270,908.50 10%410000 Revenue-Golf Shop5,817.12 3,835.00 1,982.12 51.7% 33,979.35 29,278.00 4,701.35 249,256.00 215,276.65 14%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income0.05 - 0.05 0.0%0.21 - 0.21 - (0.21) 0%Total Income64,115.42 59,369.00 4,746.42 8.0% 368,450.00 370,704.00 (2,254.00) 3,770,456.00 3,402,006.00 10%Cost of Goods Sold510000 COS-Golf Shop4,196.63 2,146.00 2,050.63 -95.6% 20,760.33 16,384.00 (4,376.33) 139,509.00 118,748.67 15%Total COS4,196.63 2,146.00 2,050.63 -95.6% 20,760.33 16,384.00 (4,376.33) 139,509.00 118,748.67 15%Gross Profit59,918.79 57,223.00 2,695.79 4.7% 347,689.67 354,320.00 (6,630.33) 3,630,947.00 3,283,257.33 10%Expenses610000 Golf Pro Shop 13,938.93 11,906.00 2,032.93 -17.1% 58,890.00 52,177.00 6,713.00 208,393.00 149,503.00 28%630000 Course Maintenance261,178.44 305,083.00 (43,904.56) 14.4% 607,668.81 697,283.00 (89,614.19) 1,783,663.00 1,175,994.19 34%633000 Maintenance Water & Energy15,223.08 18,240.00 (3,016.92) 16.5% 85,421.09 87,212.00 (1,790.91) 249,838.00 164,416.91 34%640000 Outside Services19,403.67 20,318.00 (914.33) 4.5% 95,698.45 84,358.00 11,340.45 396,373.00 300,674.55 24%650000 Clubhouse10,001.22 10,401.00 (399.78) 3.8% 44,678.64 40,104.00 4,574.64 125,312.00 80,633.36 36%660000 Marketing19,078.85 21,317.00 (2,238.15) 10.5% 61,653.38 50,467.00 11,186.38 222,203.00 160,549.62 28%670000 General & Administrative25,983.53 28,397.00 (2,413.47) 8.5% 98,049.51 111,618.00 (13,568.49) 360,401.00 262,351.49 27%680000 Leases24,897.25 25,350.00 (452.75) 1.8% 103,895.81 100,050.00 3,845.81 313,250.00 209,354.19 33%690000 Miscellaneous Other Expense21,763.47 16,480.00 5,283.47 -32.1% 66,756.33 67,320.00 (563.67) 178,360.00 111,603.67 37%Total Expenses411,468.44 457,492.00 (46,023.56) 10.1% 1,222,712.02 1,290,589.00 67,876.98 3,837,793.00 2,615,080.98 32%(351,549.65) (400,269.00) 48,719.35 12.2%(875,022.35) (936,269.00) 61,246.65 (206,846.00) 668,176.35 0%Rounds of Golf PlayedPaid Rounds Played848 767 81 10.6%7,628 8,256 (628) 43,667 36,039 17%Ave $ Per Paid Round Green Fee57.62 59.07 (1.44) -2.4%39.63 39.02 0.61 73.49 33.86 54%Ave $ Per Paid Round Merchandise6.86 5.00 1.86 37.2%4.45 3.55 0.91 5.71 1.25 78%Ave $ Per Paid Miscellaneous 9.35 11.38 (2.03) -17.8%3.82 1.97 1.85 6.87 3.05 56%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateOctober 20191 Income October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees48,865.75 45,305.00 3,560.75 302,312.94 322,141.00 (19,828.06) 3,209,134.00 2,906,821.06 90.6%4010000 Rider Fee125.00 46.00 79.00 1,910.00 413.00 1,497.00 7,807.00 5,897.00 75.5%4040000 Club Rental395.00 228.00 167.00 3,650.00 2,063.00 1,587.00 21,087.00 17,437.00 82.7%4050000 Driving Range775.00 455.00 320.00 5,711.00 3,809.00 1,902.00 94,872.00 89,161.00 94.0%4060000 Handicap Fees- - - 249.00 - 249.00 2,500.00 2,251.00 90.0%4090000 Ball Retriever/Subcontract937.50 500.00 437.50 1,487.50 1,000.00 487.50 2,500.00 1,012.50 40.5%4091000 Golf Professional Rental Fee- - - - - - 6,000.00 6,000.00 100.0%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue5,700.00 7,500.00 (1,800.00) 16,150.00 9,000.00 7,150.00 165,300.00 149,150.00 90.2% Total Revenue Fees56,798.25 54,034.00 2,764.25 331,470.44 338,426.00 (6,955.56) 3,509,200.00 3,177,729.56 90.6%56,798.25 54,034.00 2,764.25 331,470.44 338,426.00 (6,955.56) 3,509,200.00 3,177,729.56 90.6%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetOctober 20192 RevenuesActual BudgetVariance$5,817.12 $3,835.001,982.12Favorable: Foot traffic was higher than anticipated. Adjustments made for construction and ability to access the Pro Shop.ExpensesActual BudgetVariance$13,938.93 $11,906.002,032.93Unfavorable: Due to preparing the temporary Golf Shop for business.Actual BudgetVariance$261,178.44 $305,083.00(43,904.56)Favorable: Due to timing of invoices for fertilizer, sand and topdressing.Actual BudgetVariance$15,223.08 $18,240.00(1,000.00)Favorable: Due to turning off the Front Entrance in preparation of closure.Actual BudgetVariance$21,763.47 $16,480.005,283.47Favorable: Due to timing of invoices for property tax and commercial insurance.Golf Course MaintenanceWater & EnergyMiscellaneous Other ExpenseVariance ExplanationOctober 2019The 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 areGolf Shopprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise Sales3-20-133 IncomeOctober 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous138.68 - 138.68 1,883.21 - 1,883.21 00 0%4100110 Sales Hard Goods3,491.27 959.00 2,532.27 17,112.72 7,320.00 9,792.72 62,314.00 45,201.28 72.5%4100112 Sales-Soft Goods3,128.52 2,876.00 252.52 19,330.46 21,958.00 (2,627.54) 186,942.00 167,611.54 89.7%5100639 GS-Discounts-Mdse(941.35) - (941.35) (4,347.04) - (4,347.04) - 4,347.04 0.0% Total Revenue Golf Shop5,817.12 3,835.00 1,982.12 33,979.35 29,278.00 4,701.35 249,256.00 217,159.86 87.1%COS 5100150 COS-GS-Hard Goods2,529.42 556.00 1,973.42 10,466.86 4,244.00 6,222.86 34,877.15 24,410.29 70.0%5100151 COS-GS-Soft Goods1,834.47 1,668.00 166.47 10,392.73 12,734.00 (2,341.27) 104,631.44 94,238.71 90.1%5100152 COS-GS-Purchase Disc (198.00) (111.00) (87.00) (235.33) (849.00) 613.67 (7,228.00) (6,992.67) 96.7%5100220 COS-GS-Freight Merch30.74 33.00 (2.26) 136.07 255.00 (118.93) 2,169.00 2,032.93 93.7%Cost of Sales - Golf Shop4,196.63 2,146.00 2,050.63 20,760.33 16,384.00 4,376.33 134,449.59 113,689.26 84.6%Gross Profit 1,620.49 1,689.00 (68.51) 13,219.02 12,894.00 325.02 114,806.41 103,470.60 90.1%COS % 72.1% 56.0% -16.2% 61.1% 56.0% -5.1% 53.1% 52.4% 98.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group403.91 490.00 (86.09) 1,401.45 1,960.00 (558.55) 5,880.00 4,478.55 76.2%6101325 Insurance-Workers Comp 645.60 327.00 318.60 2,426.59 1,497.00 929.59 6,054.00 3,627.41 59.9%6101720 Salaries5,008.16 4,400.00 608.16 20,032.64 17,600.00 2,432.64 65,000.00 44,967.36 69.2%6101800 Taxes-Employer Payroll708.60 873.00 (164.40) 3,612.64 3,991.00 (378.36) 16,144.00 12,531.36 77.6%6101880 Wages-Hourly3,890.50 4,331.00 (440.50) 26,117.88 22,314.00 3,803.88 98,874.00 72,756.12 73.6%6101882 Wages-Overtime178.50 - 178.50 444.77 - 444.77 - 952.88 0.0%Total -PS-SALARIES & BENEFITS10,835.27 10,421.00 414.27 54,035.97 47,362.00 6,673.97 191,952.00 139,313.68 72.6%61-PS OTHER EXPENSES6103742 Supplies-Expendable1,347.48 - 1,347.48 1,347.48 - 1,347.48 - (1,347.48) 0.0%6103762 Supplies-Office1,145.90 250.00 895.90 1,469.81 1,000.00 469.81 3,000.00 1,530.19 51.0%6109220 Freight & Delivery13.16 25.00 (11.84) 53.44 25.00 28.44 75.00 21.56 28.7%6109490 Miscellaneous156.59 500.00 (343.41) 525.25 2,000.00 (1,474.75) 6,000.00 5,474.75 91.2%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short0.40 - 0.40 17.43 - 17.43 - (17.43) 0.0%6109722 Seminars/Training- 500.00 (500.00) - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms355.17 100.00 255.17 1,220.56 400.00 820.56 2,400.00 1,179.44 49.1%6117840 Telephones84.96 110.00 (25.04) 220.06 440.00 (219.94) 1,320.00 1,099.94 83.3%3,103.66 1,485.00 1,618.66 4,854.03 4,815.00 39.03 18,875.00 14,020.97 74.3%13,938.93 11,906.00 2,032.93 58,890.00 52,177.00 6,713.00 210,827.00 153,334.65 72.7%Net Income(12,318.44) (10,217.00) (2,101.44) (45,670.98) (39,283.00) (6,387.98) (96,020.59) (49,864.05) 51.9%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetOctober 20194 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,692.32 9,810.00 (1,117.68) 36,491.92 39,240.00 (2,748.08) 117,720.00 81,228.08 69.0%6311325 Insurance-Workers Comp2,816.88 2,516.00 300.88 9,731.52 8,408.00 1,323.52 28,929.00 19,197.48 66.4%6311720 Salaries13,012.76 12,480.00 532.76 52,051.04 49,920.00 2,131.04 166,400.00 114,348.96 68.7%6311800 Taxes-Employer Payroll4,759.45 7,242.00 (2,482.55) 14,835.96 22,959.00 (8,123.04) 77,767.00 62,931.04 80.9%6311880 Wages-Hourly42,532.66 43,944.00 (1,411.34) 149,429.71 163,662.00 (14,232.29) 592,769.00 443,339.29 74.8%6311882 Wages-Overtime9,148.21 16,000.00 (6,851.79) 18,772.28 16,000.00 2,772.28 18,500.00 (272.28) -1.5%Total-CM-SALARIES & BENEFITS80,962.28 91,992.00 (11,029.72) 281,312.43 300,189.00 (18,876.57) 1,002,085.00 720,772.57 71.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals2,636.71 9,359.00 (6,722.29) 11,882.06 31,123.00 (19,240.94) 50,060.00 38,177.94 76.3%6313744 Fertilizer15,877.50 29,560.00 (13,682.50) 30,854.61 49,410.00 (18,555.39) 104,520.00 73,665.39 70.5%6313745 Herbicides- - - 953.83 - 953.83 - (953.83) 0.0%6313746 Flowers/Plants- 250.00 (250.00) - 1,250.00 (1,250.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline2,798.84 4,750.00 (1,951.16) 13,199.28 15,250.00 (2,050.72) 46,860.00 33,660.72 71.8%6313750 Golf Course Accessories10,142.29 12,300.00 (2,157.71) 10,142.29 12,300.00 (2,157.71) 13,140.00 2,997.71 22.8%6313756 POA Control- - - 160.00 2,400.00 (2,240.00) 9,900.00 9,740.00 98.4%6313758 Miscellaneous Supp- 500.00 (500.00) 1,363.90 2,750.00 (1,386.10) 4,350.00 2,986.10 68.6%6313762 Supplies-Office- - - 499.35 - 499.35 - (499.35) 0.0%6313774 Sand1,974.74 2,000.00 (25.26) 4,587.04 7,780.00 (3,192.96) 13,460.00 8,872.96 65.9%6313776 Seed103,541.97 105,500.00 (1,958.03) 103,541.97 105,500.00 (1,958.03) 117,400.00 13,858.03 11.8%6313778 Small Tools & Non-Capital Equip1,488.27 2,000.00 (511.73) 2,507.75 4,200.00 (1,692.25) 5,000.00 2,492.25 49.8%6313780 Sod- - - 9,606.61 10,800.00 (1,193.39) 15,500.00 5,893.39 38.0%6313782 Topdressing- 2,200.00 (2,200.00) - 4,400.00 (4,400.00) 10,000.00 10,000.00 100.0%Total-CM-SUPPLIES & MATERIALS138,460.32 168,419.00 (29,958.68) 189,298.69 247,163.00 (57,864.31) 393,240.00 203,941.31 51.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint7,000.00 3,850.00 3,150.00 18,550.00 15,400.00 3,150.00 30,800.00 12,250.00 39.8%6315685 CM-R&M-Bldngs & Othr Structures 299.00 500.00 (201.00) 1,320.76 3,050.00 (1,729.24) 5,550.00 4,229.24 76.2%6315690 CM-R&M-Equipment7,734.65 10,000.00 (2,265.35) 20,012.30 17,500.00 2,512.30 38,500.00 18,487.70 48.0%6315692 CM-R&M-Irrigation System4,210.33 2,000.00 2,210.33 8,289.58 11,400.00 (3,110.42) 19,050.00 10,760.42 56.5%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 663.05 4,000.00 (3,336.95) 10,500.00 9,836.95 93.7%6315815 CM-R&M-Trees-Pruning Etc- 550.00 (550.00) 4,930.00 6,050.00 (1,120.00) 12,050.00 7,120.00 59.1%Total-CM-REPAIRS & MAINTENANCE19,243.98 17,900.00 1,343.98 53,765.69 57,400.00 (3,634.31) 116,450.00 62,684.31 53.8%6317836 Utilities-Natural Gas/LPG - 15.00 (15.00) 59.53 60.00 (0.47) 180.00 120.47 0.0%6317840 Telephones816.98 850.00 (33.02) 3,269.45 3,400.00 (130.55) 10,200.00 6,930.55 67.9%Total-CM-UTILITIES816.98 865.00 (48.02) 3,328.98 3,460.00 (131.02) 10,380.00 7,051.02 67.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6319100 Contract Svcs-Soil/Tissue Test- - - - 1,000.00 (1,000.00) 2,000.00 2,000.00 100.0%6319102 Contract Svcs-Trash Removal164.18 524.00 (359.82) 328.36 2,096.00 (1,767.64) 6,288.00 5,959.64 94.8%6319150 Dues & Subscriptions- - - 210.00 - 210.00 680.00 470.00 69.1%6319170 Employee Education- 50.00 (50.00) - 200.00 (200.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 1,000.00 (1,000.00) - 1,500.00 (1,500.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits750.00 250.00 500.00 1,595.86 350.00 1,245.86 4,300.00 2,704.14 62.9%6319490 Miscellaneous- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training- 800.00 (800.00) 856.83 1,850.00 (993.17) 3,850.00 2,993.17 77.7%6319822 Uniforms911.29 920.00 (8.71) 4,575.64 3,680.00 895.64 11,040.00 6,464.36 58.6%Total-CM-OTHER EXPENSES2,225.47 4,044.00 (1,818.53) 9,166.69 12,676.00 (3,509.31) 41,458.00 32,291.31 77.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAnnual BudgetOctober 20195 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 3,550.48 2,450.00 1,100.48 10,793.69 9,800.00 993.69 29,400.00 18,606.31 63.3%6321325 Insurance-Workers Comp742.80 569.00 173.80 2,771.20 2,053.00 718.20 5,955.00 3,183.80 53.5%6321800 Taxes-Employer Payroll866.12 1,632.00 (765.88) 3,091.48 5,588.00 (2,496.52) 15,995.00 12,903.52 80.7%6321880 Wages-Hourly12,720.00 12,904.00 (184.00) 48,566.38 52,476.00 (3,909.62) 156,528.00 107,961.62 69.0%6321882 Wages-Overtime758.63 3,418.00 (2,659.37) 2,690.26 3,418.00 (727.74) 3,418.00 727.74 21.3%Total-CM-LM-SALARIES & BENEFITS18,638.03 20,973.00 (2,334.97) 67,913.01 73,335.00 (5,421.99) 211,296.00 143,382.99 67.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 400.00 (400.00) 1,025.00 1,025.00 100.0%6323788 Uniforms831.38 290.00 541.38 1,085.32 1,160.00 (74.68) 3,480.00 2,394.68 68.8%Total-CM-LM-SUPPLIES & MATERIALS831.38 390.00 441.38 1,085.32 1,560.00 (474.68) 4,505.00 3,419.68 75.9%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) 1,798.00 1,500.00 298.00 4,250.00 2,452.00 57.7%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) 1,798.00 1,500.00 298.00 4,250.00 2,452.00 57.7%261,178.44 305,083.00 (43,904.56) 607,668.81 697,283.00 (89,614.19) 1,783,664.00 1,175,995.19 65.9%October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,400.40 8,390.00 1,010.40 57,036.43 44,262.00 12,774.43 179,791.00 122,754.57 68.3%6337842 Utilities-Water5,822.68 9,850.00 (4,027.32) 28,384.66 42,950.00 (14,565.34) 70,047.00 41,662.34 59.5%15,223.08 18,240.00 (3,016.92) 85,421.09 87,212.00 (1,790.91) 249,838.00 164,416.91 65.8%Total-COURSE MAINTENANCECourse Maintenance Expense StatementOctober 2019Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyOctober 2019Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group28.45 304.00 (275.55) 863.32 1,216.00 (352.68) 3,648.00 2,784.68 76.3%6411325 Insurance-Workers Comp782.72 360.00 422.72 2,030.88 1,576.00 454.88 7,482.00 5,451.12 72.9%6411800 Taxes-Employer Payroll617.94 1,194.00 (576.06) 3,404.58 5,233.00 (1,828.42) 24,841.00 21,436.42 86.3%6411880 Wages-Hourly7,169.82 9,588.00 (2,418.18) 39,973.58 42,024.00 (2,050.42) 199,524.00 159,550.42 80.0%6411882 Wages-Overtime826.13 - 826.13 1,245.01 - 1,245.01 - (1,245.01) 0.0%Total-CBR-SALARIES & BENEFITS9,425.06 11,446.00(2,020.94) 47,517.37 50,049.00 (2,531.63) 235,495.00 187,977.63 79.8%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) - 500.00 (500.00) 1,850.00 `0.0%6413742 Supplies-Expendable461.39 150.00 311.39 4,112.79 1,500.00 2,612.79 6,750.00 2,637.21 39.1%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 200.00 (200.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 10,000.00 10,000.00 100.0%6413762 Supplies-Office- 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels240.00 120.00 120.00 1,200.00 480.00 720.00 2,182.00 982.00 45.0%6413796 Supplies-Bottled Water553.77 100.00 453.77 4,670.49 4,600.00 70.49 19,900.00 15,229.51 76.5%Total-CBR-SUPPLIES & MATERIALS1,255.16 1,020.00 235.16 9,983.28 7,405.00 2,578.28 44,627.00 32,793.72 73.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 78.57 300.00 (221.43) 419.50 1,200.00 (780.50) 3,600.00 3,180.50 88.3%6415695 CBR-R&M-Cart Maintenance & Repair 3,512.67 950.00 2,562.67 10,267.89 2,450.00 7,817.89 6,450.00 (3,817.89) -59.2%Total-CBR-REPAIRS & MAINTENANCE3,591.24 1,250.00 2,341.24 10,687.39 3,650.00 7,037.39 10,050.00 (637.39) -6.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen551.44 800.00 (248.56) 3,263.63 3,200.00 63.63 9,600.00 6,336.37 66.0%6419220 Freight/Delivery- 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous292.87 600.00 (307.13) 1,129.66 2,400.00 (1,270.34) 7,200.00 6,070.34 84.3%6419820 Uniforms2,205.18 2,000.00 205.18 2,205.18 2,000.00 205.18 5,200.00 2,994.82 57.6%Total-CBR-OTHER EXPENSES3,049.49 3,475.00 (425.51) 6,598.47 7,900.00 (1,301.53) 22,450.00 15,851.53 70.6%TOTAL-CARTS,BAGROOM & RANGE 17,320.95 17,191.00(425.51) 74,786.51 69,004.00 5,782.51 312,622.00 235,985.49 75.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp342.80 70.00 272.80 1,371.20 454.00 917.20 2,630.00 1,258.80 47.9%6431800 Taxes-Employer Payroll164.92 187.00 (22.08) 1,647.74 1,212.00 435.74 7,013.00 5,365.26 76.5%6431880 Wages-Hourly1,575.00 1,870.00 (295.00) 16,947.00 12,113.00 4,834.00 70,133.00 53,186.00 75.8%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,082.72 2,127.00 (44.28) 19,965.94 13,779.00 6,186.94 79,776.00 59,810.06 75.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 300.00 (300.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms- 800.00 (800.00) 946.00 1,025.00 (79.00) 2,125.00 1,179.00 55.5%Total-CS-OTHER EXPENSES- 1,000.00 (1,000.00) 946.00 1,575.00 (629.00) 3,975.00 3,029.00 76.2%Total-COURSE SERVICES2,082.72 3,127.00 (1,044.28) 20,911.94 15,354.00 5,557.94 83,751.00 62,839.06 75.0%19,403.67 20,318.00(914.33) 95,698.45 84,358.00 11,340.45 396,373.00 295,795.55 74.6%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetOctober 20197 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%65-CH-UTILITIES6507836 Utilities-Natural Gas- 850.00 (850.00) 4,425.49 3,400.00 1,025.49 10,200.00 5,774.51 56.6%6507840 Utilities-Telephone1,311.01 1,150.00 161.01 3,889.54 4,600.00 (710.46) 13,800.00 9,910.46 71.8%6507842 Utilities-Water688.33 321.00 367.33 3,517.88 1,284.00 2,233.88 3,852.00 334.12 8.7%6507844 Utilities-Cable 352.93 380.00 (27.07) 1,622.16 1,520.00 102.16 4,560.00 2,937.84 64.4%Total-CH-UTILITIES2,352.27 2,701.00 (348.73) 13,455.07 10,804.00 2,651.07 32,412.00 18,956.93 58.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning480.00 400.00 80.00 2,000.00 1,600.00 400.00 4,800.00 2,800.00 58.3%6509099 Contract Services-Security5,236.05 5,000.00 236.05 22,548.04 20,000.00 2,548.04 60,000.00 37,451.96 62.4%6509215 Flowers & Decorations713.10 500.00 213.10 713.10 500.00 213.10 1,900.00 1,186.90 62.5%6509490 Miscellaneous573.23 200.00 373.23 1,329.80 800.00 529.80 7,000.00 5,670.20 81.0%6509718 Safety Equipment & Training163.07 100.00 63.07 163.07 400.00 (236.93) 1,200.00 1,036.93 86.4%Total-CH-OTHER EXPENSES7,165.45 6,200.00 965.45 26,754.01 23,300.00 3,454.01 74,900.00 48,145.99 64.3%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures83.50 300.00 (216.50) 2,319.56 1,200.00 1,119.56 3,600.00 1,280.44 35.6%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 550.00 1,600.00 (1,050.00) 4,800.00 4,250.00 88.5%Total-CH-REPAIRS & MAINTENANCE83.50 1,100.00 (1,016.50)2,869.56 4,400.00 (1,530.44) 13,200.00 10,330.44 78.3%10,001.22 10,401.00(399.78) 44,678.64 40,104.00 4,574.64 125,312.00 20,660.88 16.5%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetOctober 20198 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 398.91 348.00 50.91 1,595.64 1,392.00 203.64 4,176.00 2,580.36 61.8%6601325 Insurance-Workers Comp108.00 94.00 14.00 417.20 376.00 41.20 1,129.00 711.80 63.0%6601720 Salaries2,415.00 2,508.00 (93.00) 9,660.00 10,032.00 (372.00) 30,096.00 20,436.00 67.9%6601800 Taxes-Employer Payroll243.40 251.00 (7.60) 973.60 1,004.00 (30.40) 3,010.00 2,036.40 67.7%Total-MKT-SALARIES & BENEFITS3,165.31 3,201.00 (35.69) 12,646.44 12,804.00 (157.56) 38,411.00 25,764.56 67.1%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 433.07 400.00 33.07 1,200.00 766.93 63.9%6603768 Supplies-Printing & Stationery134.63 3,000.00 (2,865.37) 1,196.37 3,200.00 (2,003.63) 4,425.00 3,228.63 73.0%134.63 3,100.00 (2,965.37) 1,629.44 3,600.00 (1,970.56) 5,625.00 3,995.56 71.0%66-MKT-UTILITIES6607840 Utilities-Telephone 171.39 100.00 71.39 483.75 400.00 83.75 1,200.00 716.25 59.7%Total-MKT-UTILITIES171.39 100.00 71.39 483.75 400.00 83.75 1,200.00 716.25 59.7%66-MKT-OTHER EXPENSES6609010 Advertising 15,297.09 13,766.00 1,531.09 39,862.94 31,613.00 8,249.94 163,133.00 123,270.06 75.6%6609040 Business Meals- 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material310.43 500.00 (189.57) 6,214.98 500.00 5,714.98 5,500.00 (714.98) -13.0%6609102 Contract Services-Web Page- 150.00 (150.00) 693.00 600.00 93.00 1,800.00 1,107.00 61.5%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) - 50.00 (50.00) 700.00 700.00 100.0%6609633 Promotion-Community- 75.00 (75.00) - 300.00 (300.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- - - - - - 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- 300.00 (300.00) 122.83 300.00 (177.17) 600.00 477.17 79.5%Total-MKT-OTHER EXPENSES15,607.52 14,916.00 691.52 46,893.75 33,663.00 13,230.75 176,968.00 130,074.25 73.5%19,078.85 21,317.00 (2,238.15) 61,653.38 50,467.00 11,186.38 222,204.00 160,550.62 72.3%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetOctober 20199 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,743.89 2,180.00 563.89 11,131.32 8,720.00 2,411.32 26,160.00 15,028.68 57.4%6701325 Insurance-Workers Comp445.68 710.00 (264.32) 1,782.72 2,790.00 (1,007.28) 8,881.00 7,098.28 79.9%6701720 Salaries13,815.78 14,972.00 (1,156.22) 55,263.12 60,569.00 (5,305.88) 197,432.00 142,168.88 72.0%6701800 Taxes-Employer Payroll1,161.06 1,894.00 (732.94) 4,603.22 7,440.00 (2,836.78) 23,684.00 19,080.78 80.6%6701880 Wages-Hourly2,127.44 3,971.00 (1,843.56) 7,666.32 13,844.00 (6,177.68) 39,404.00 31,737.68 80.5%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,293.85 23,727.00 (3,433.15) 80,446.70 93,363.00 (12,916.30) 295,561.00 215,114.30 72.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer105.98 500.00 (394.02) 1,064.86 2,000.00 (935.14) 6,300.00 5,235.14 83.1%6703762 Supplies-Office943.39 105.00 838.39 1,213.20 420.00 793.20 1,260.00 46.80 3.7%6703768 Supplies-Printing & Stationery79.00 100.00 (21.00) 460.66 400.00 60.66 3,300.00 2,839.34 86.0%Total-G&A-SUPPLIES & MATERIALS1,128.37 705.00 423.37 2,738.72 2,820.00 (81.28) 10,860.00 8,121.28 74.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 300.00 (300.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 300.00 (300.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) 620.00 300.00 320.00 1,150.00 530.00 46.1%6709180 Employee Recruiting/Relocation235.62 150.00 85.62 265.62 300.00 (34.38) 1,200.00 934.38 77.9%6709197 Equipment Rental1,984.53 550.00 1,434.53 2,653.97 2,200.00 453.97 6,600.00 3,946.03 59.8%6709202 Fees-Bank156.48 90.00 66.48 388.65 360.00 28.65 1,080.00 691.35 64.0%6709208 Fees-Payroll Processing343.93 1,000.00 (656.07) 1,365.17 4,000.00 (2,634.83) 12,000.00 10,634.83 88.6%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous45.25 100.00 (54.75) 68.24 400.00 (331.76) 6,600.00 6,531.76 99.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 281.10 300.00 (18.90) 900.00 618.90 68.8%6709625 Professional Fees1,295.50 850.00 445.50 7,172.17 3,400.00 3,772.17 10,200.00 3,027.83 29.7%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 800.00 (800.00) 2,400.00 2,400.00 100.0%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 150.00 (150.00) 49.17 375.00 (325.83) 1,050.00 1,000.83 95.3%Total-G&A-OTHER EXPENSES4,561.31 3,865.00 696.31 14,864.09 15,135.00 (270.91) 52,080.00 37,215.91 71.5%25,983.53 28,397.00 (2,413.47) 98,049.51 111,618.00 (13,568.49) 360,401.00 262,351.49 72.8%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetOctober 201910 October 2019 Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.Expense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,500.00 (670.73) 39,317.08 40,650.00 (1,332.92) 136,650.00 97,332.92 6800193 Equipment Leases-Maintenance9,181.20 9,500.00 (318.80) 36,724.80 38,000.00 (1,275.20) 114,000.00 77,275.20 6800194 Equipment Leases-Trailer- 300.00 (300.00) 4,077.22 1,200.00 2,877.22 3,600.00 (477.22) 6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 15,480.00 15,600.00 (120.00) 38,800.00 23,320.00 6800197 Equipment Leases-Others2,016.78 1,150.00 866.78 8,296.71 4,600.00 3,696.71 20,200.00 11,903.29 24,897.25 25,350.00(452.75) 103,895.81100,050.003,845.81 313,250.00 209,354.1969-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,880.00 9,880.00 - 39,520.00 39,520.00 - 118,560.00 79,040.00 6900800 Personal Property Taxes7,763.47 2,600.00 5,163.47 13,171.65 11,800.00 1,371.65 11,800.00 (1,371.65) 6900323 Insurance-Commercial4,120.00 4,000.00 120.00 14,064.68 16,000.00 (1,935.32) 48,000.00 33,935.32 21,763.47 16,480.005,283.47 66,756.33 67,320.00 (563.67) 178,360.00 111,603.67Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to DateYear to DateOctober 201911 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2019-20202019 2019 2019 2019 2019 2019Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4SalesPromotionGolf IndustryVIPCelebrityPGA Comp4543Charity/Gift Certificate441Rain/Wind Checks12Club Staff13 22 354LQ HS Golf522 36 458002020 2020 2020 2020 2020 2020Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012