Loading...
12 June 2020 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2019 – June 2020 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 5 Clubhouse Expense Statement 6 Marketing Expense Statement 7 General & Administrative Expense Statement 8 Operating Leases & Miscellaneous Expense Statement 9 Complimentary Report 10 Annual BudgetAccount Description June 2020Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue127,810.34 141,579.00 (13,768.66) -9.7% 2,379,414.42 3,209,133.00 (829,718.58) 3,209,134.00 829,719.58 74%401000 Miscellaneous Golf Revenue7,127.00 20,770.00 (13,643.00) -65.7% 196,475.97 300,068.00 (103,592.03) 300,066.00 103,590.03 65%410000 Revenue-Golf Shop6,564.44 14,700.00 (8,135.56) -55.3% 141,153.45 249,257.00 (108,103.55) 249,256.00 108,102.55 57%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 12,000.00 12,000.00 - 12,000.00 - 100%890000 Interest Income0.09 - 0.09 0.0%0.46 - 0.46 - (0.46) 0%Total Income142,001.87 177,549.00 (35,547.13) -20.0% 2,729,044.30 3,770,458.00 (1,041,413.70) 3,770,456.00 1,041,411.70 72%Cost of Goods Sold510000 COS-Golf Shop4,531.49 8,229.00 (3,697.51) 44.9% 84,452.96 139,510.00 55,057.04 139,509.00 55,056.04 61%Total COS4,531.49 8,229.00 (3,697.51) 44.9% 84,452.96 139,510.00 55,057.04 139,509.00 55,056.04 61%Gross Profit137,470.38 169,320.00 (31,849.62) -18.8% 2,644,591.34 3,630,948.00 (986,356.66) 3,630,947.00 986,355.66 73%Expenses610000 Golf Pro Shop12,723.49 18,046.00 (5,322.51) 29.5% 185,190.07 208,391.00 (23,200.93) 208,393.00 23,202.93 89%630000 Course Maintenance102,266.55 142,826.00 (40,559.45) 28.4% 1,536,892.24 1,783,656.00 (246,763.76) 1,783,663.00 246,770.76 86%633000 Maintenance Water & Energy16,102.06 30,969.00 (14,866.94) 48.0% 197,960.53 249,838.00 (51,877.47) 249,838.00 51,877.47 79%640000 Outside Services16,928.10 24,135.00 (7,206.90) 29.9% 398,748.98 396,374.00 2,374.98 396,373.00 (2,375.98) 101%650000 Clubhouse10,677.30 10,301.00 376.30 -3.7% 133,845.88 125,312.00 8,533.88 125,312.00 (8,533.88) 107%660000 Marketing7,155.09 12,977.00 (5,821.91) 44.9% 185,324.08 222,205.00 (36,880.92) 222,203.00 36,878.92 83%670000 General & Administrative27,947.56 30,519.00 (2,571.44) 8.4% 328,695.04 360,395.00 (31,699.96) 360,401.00 31,705.96 91%680000 Leases27,714.67 26,650.00 1,064.67 -4.0% 317,969.00 313,250.00 4,719.00 313,250.00 (4,719.00) 102%690000 Miscellaneous Other Expense15,927.07 13,880.00 2,047.07 -14.7% 196,133.00 178,360.00 17,773.00 178,360.00 (17,773.00) 110%Total Expenses237,441.89 310,303.00 (72,861.11) 23.5% 3,480,758.82 3,837,781.00 357,022.18 3,837,793.00 357,034.18 91%(99,971.51) (140,983.00) 41,011.49 29.1%(836,167.48) (206,833.00) (629,334.48) (206,846.00) 629,321.48 0%Rounds of Golf PlayedPaid Rounds Played2,196 2,450 (254) -10.4%33,407 43,667 (10,260) 43,667 10,260 77%Ave $ Per Paid Round Green Fee58.20 57.79 0.41 0.7%71.23 73.49 (2.27) 73.49 2.27 97%Ave $ Per Paid Round Merchandise2.99 6.00 (3.01) -50.2%4.23 5.71 (1.48) 5.71 1.48 74%Ave $ Per Paid Miscellaneous 3.25 8.48 (5.23) -61.7%5.88 6.87 (0.99) 6.87 0.99 86%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJune 20201 Income June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees127,810.34 141,579.00 (13,768.66) 2,379,414.42 3,209,133.00 (829,718.58) 3,209,134.00 829,719.58 25.9%4010000 Rider Fee- 245.00 (245.00) 7,035.00 7,808.00 (773.00) 7,807.00 772.00 9.9%4040000 Club Rental465.00 1,225.00 (760.00) 16,540.00 21,088.00 (4,548.00) 21,087.00 4,547.00 21.6%4050000 Driving Range205.00 3,675.00 (3,470.00) 51,443.00 94,872.00 (43,429.00) 94,872.00 43,429.00 45.8%4060000 Handicap Fees757.00 - 757.00 3,223.00 2,500.00 723.00 2,500.00 (723.00) -28.9%4090000 Ball Retriever/Subcontract- - - 2,464.97 2,500.00 (35.03) 2,500.00 35.03 1.4%4091000 Golf Professional Rental Fee- - - 5,000.00 6,000.00 (1,000.00) 6,000.00 1,000.00 16.7%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue5,700.00 15,625.00 (9,925.00) 110,770.00 165,300.00 (54,530.00) 165,300.00 54,530.00 33.0% Total Revenue Fees134,937.34 162,349.00 (27,411.66) 2,575,890.39 3,509,201.00 (933,310.61) 3,509,200.00 933,309.61 26.6%134,937.34 162,349.00 (27,411.66) 2,575,890.39 3,509,201.00 (933,310.61) 3,509,200.00 933,309.61 26.6%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetJune 20202 Income June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous505.89 - 505.89 8,378.68 - 8,378.68 00 0%4100110 Sales Hard Goods4,316.94 3,675.00 641.94 63,436.70 62,315.00 1,121.70 62,314.00 (1,122.70) -1.8%4100112 Sales-Soft Goods2,422.00 11,025.00 (8,603.00) 91,568.75 186,942.00 (95,373.25) 186,942.00 95,373.25 51.0%5100639 GS-Discounts-Mdse(680.39) - (680.39) (22,230.68) - (22,230.68) - 22,230.68 0.0% Total Revenue Golf Shop6,564.44 14,700.00 (8,135.56) 141,153.45 249,257.00 (108,103.55) 249,256.00 116,481.23 46.7%COS 5100150 COS-GS-Hard Goods 3,027.25 2,132.00 895.25 38,182.97 36,142.00 2,040.97 34,877.15 (3,305.82) -9.5%5100151 COS-GS-Soft Goods 1,456.94 6,395.00 (4,938.06) 44,950.56 108,427.00 (63,476.44) 104,631.44 59,680.88 57.0%5100152 COS-GS-Purchase Disc (12.42) (426.00) 413.58 (479.55) (7,228.00) 6,748.45 (7,228.00) (6,748.45) 93.4%5100220 COS-GS-Freight Merch 59.72 128.00 (68.28) 1,798.98 2,169.00 (370.02) 2,169.00 370.02 17.1%Cost of Sales - Golf Shop4,531.49 8,229.00 (3,697.51) 84,452.96 139,510.00 (55,057.04) 134,449.59 49,996.63 37.2%Gross Profit 2,032.95 6,471.00 (4,438.05) 56,700.49 109,747.00 (53,046.51) 114,806.41 66,484.60 57.9%COS %69.0% 56.0% -13.1% 59.8% 56.0% -3.9% 53.1% 42.9% 80.9%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group144.57 490.00 (345.43) 5,209.44 5,880.00 (670.56) 5,880.00 670.56 11.4%6101325 Insurance-Workers Comp 666.82 542.00 124.82 7,195.93 6,053.00 1,142.93 6,054.00 (1,141.93) -18.9%6101720 Salaries3,907.16 4,530.00 (622.84) 59,703.83 53,060.00 6,643.83 65,000.00 5,296.17 8.1%6101800 Taxes-Employer Payroll 817.99 1,446.00 (628.01) 14,267.43 16,145.00 (1,877.57) 16,144.00 1,876.57 11.6%6101880 Wages-Hourly5,143.61 9,928.00 (4,784.39) 86,517.24 108,378.00 (21,860.76) 98,874.00 12,356.76 12.5%6101882 Wages-Overtime54.00 - 54.00 1,107.80 - 1,107.80 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 10,734.15 16,936.00 (6,201.85) 174,001.67 189,516.00 (15,514.33) 191,952.00 20,011.01 10.4%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 1,347.48 - 1,347.48 - (1,347.48) 0.0%6103762 Supplies-Office106.56 250.00 (143.44) 3,030.81 3,000.00 30.81 3,000.00 (30.81) -1.0%6109220 Freight & Delivery- - - 378.11 75.00 303.11 75.00 (303.11) -404.1%6109490 Miscellaneous593.06 500.00 93.06 2,077.99 6,000.00 (3,922.01) 6,000.00 3,922.01 65.4%6109150 Dues and Subscriptions 1,133.60 - 1,133.60 1,133.60 2,300.00 (1,166.40) 2,300.00 1,166.40 50.7%6109500 ProShop-Over/Short- - - 23.55 - 23.55 - (23.55) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 3,690.00 (3,690.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 90.00 (90.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 1,921.72 2,400.00 (478.28) 2,400.00 478.28 19.9%6117840 Telephones156.12 110.00 46.12 1,275.14 1,320.00 (44.86) 1,320.00 44.86 3.4%1,989.34 1,110.00 879.34 11,188.40 18,875.00 (7,686.60) 18,875.00 7,686.60 40.7%12,723.49 18,046.00 (5,322.51) 185,190.07 208,391.00 (23,200.93) 210,827.00 27,697.61 13.1%Net Income(10,690.54) (11,575.00) 884.46 (128,489.58) (98,644.00) (29,845.58) (96,020.59) 38,786.99 -40.4%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetJune 20203 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group5,538.51 9,810.00 (4,271.49) 102,981.36 117,720.00 (14,738.64) 117,720.00 14,738.64 12.5%6311325 Insurance-Workers Comp2,232.80 2,581.00 (348.20) 28,379.47 28,929.00 (549.53) 28,929.00 549.53 1.9%6311720 Salaries13,012.76 12,480.00 532.76 156,665.63 149,760.00 6,905.63 166,400.00 9,734.37 5.8%6311800 Taxes-Employer Payroll2,338.47 6,884.00 (4,545.53) 60,639.13 77,770.00 (17,130.87) 77,767.00 17,127.87 22.0%6311880 Wages-Hourly23,209.24 56,351.00 (33,141.76) 473,812.21 609,403.00 (135,590.79) 592,769.00 118,956.79 20.1%6311882 Wages-Overtime- - - 41,355.25 18,500.00 22,855.25 18,500.00 (22,855.25) -123.5%Total-CM-SALARIES & BENEFITS46,331.78 88,106.00 (41,774.22) 863,833.05 1,002,082.00 (138,248.95) 1,002,085.00 138,251.95 13.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals2,909.01 6,508.00 (3,598.99) 36,159.72 50,060.00 (13,900.28) 50,060.00 13,900.28 27.8%6313744 Fertilizer7,032.58 10,630.00 (3,597.42) 68,582.34 104,520.00 (35,937.66) 104,520.00 35,937.66 34.4%6313745 Herbicides- - - 1,815.13 - 1,815.13 - (1,815.13) 0.0%6313746 Flowers/Plants- - - (43.37) 3,050.00 (3,093.37) 3,050.00 3,093.37 101.4%6313748 Fuel-Gasoline2,206.71 3,580.00 (1,373.29) 36,621.37 46,860.00 (10,238.63) 46,860.00 10,238.63 21.8%6313750 Golf Course Accessories- - - 20,000.61 13,140.00 6,860.61 13,140.00 (6,860.61) -52.2%6313756 POA Control- - - 160.00 9,900.00 (9,740.00) 9,900.00 9,740.00 98.4%6313758 Miscellaneous Supp439.47 100.00 339.47 5,515.29 4,350.00 1,165.29 4,350.00 (1,165.29) -26.8%6313762 Supplies-Office- - - 1,632.22 - 1,632.22 - (1,632.22) 0.0%6313774 Sand- 100.00 (100.00) 9,215.88 13,460.00 (4,244.12) 13,460.00 4,244.12 31.5%6313776 Seed- - - 103,541.97 117,400.00 (13,858.03) 117,400.00 13,858.03 11.8%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) 3,608.37 5,000.00 (1,391.63) 5,000.00 1,391.63 27.8%6313780 Sod- 3,450.00 (3,450.00) 9,606.61 15,500.00 (5,893.39) 15,500.00 5,893.39 38.0%6313782 Topdressing1,545.93 1,500.00 45.93 2,320.39 10,000.00 (7,679.61) 10,000.00 7,679.61 76.8%Total-CM-SUPPLIES & MATERIALS14,133.70 25,968.00 (11,834.30) 298,736.53 393,240.00 (94,503.47) 393,240.00 94,503.47 24.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 10,500.00 3,850.00 6,650.00 41,578.19 30,800.00 10,778.19 30,800.00 (10,778.19) -35.0%6315685 CM-R&M-Bldngs & Othr Structures 83.50 250.00 (166.50) 9,283.78 5,550.00 3,733.78 5,550.00 (3,733.78) -67.3%6315690 CM-R&M-Equipment3,485.19 2,500.00 985.19 40,911.99 38,500.00 2,411.99 38,500.00 (2,411.99) -6.3%6315692 CM-R&M-Irrigation System1,426.13 1,000.00 426.13 22,788.17 19,050.00 3,738.17 19,050.00 (3,738.17) -19.6%6315696 CM-R&M-Pumps- - - 12,257.03 10,500.00 1,757.03 10,500.00 (1,757.03) -16.7%6315815 CM-R&M-Trees-Pruning Etc8,400.00 - 8,400.00 14,130.00 12,050.00 2,080.00 12,050.00 (2,080.00) -17.3%Total-CM-REPAIRS & MAINTENANCE23,894.82 7,600.00 16,294.82 140,949.16 116,450.00 24,499.16 116,450.00 (24,499.16) -21.0%6317836 Utilities-Natural Gas/LPG26.25 15.00 11.25 269.41 180.00 89.41 180.00 (89.41) 0.0%6317840 Telephones830.39 850.00 (19.61) 9,050.56 10,200.00 (1,149.44) 10,200.00 1,149.44 11.3%Total-CM-UTILITIES856.64 865.00 (8.36) 9,319.97 10,380.00 (1,060.03) 10,380.00 1,060.03 10.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%6319100 Contract Svcs-Soil/Tissue Test- - - 85.00 2,000.00 (1,915.00) 2,000.00 1,915.00 95.8%6319102 Contract Svcs-Trash Removal95.59 524.00 (428.41) 1,436.03 6,288.00 (4,851.97) 6,288.00 4,851.97 77.2%6319150 Dues & Subscriptions210.00 100.00 110.00 4,650.00 680.00 3,970.00 680.00 (3,970.00) -583.8%6319170 Employee Education- 50.00 (50.00) - 3,900.00 (3,900.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 100.00 (100.00) - 3,400.00 (3,400.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits1,102.44 - 1,102.44 5,477.80 4,300.00 1,177.80 4,300.00 (1,177.80) -27.4%6319490 Miscellaneous- 100.00 (100.00) 1,546.82 1,200.00 346.82 1,200.00 (346.82) -28.9%6319718 Safety Equipment & Training550.04 100.00 450.04 2,901.73 3,850.00 (948.27) 3,850.00 948.27 24.6%6319822 Uniforms760.20 920.00 (159.80) 12,632.65 11,040.00 1,592.65 11,040.00 (1,592.65) -14.4%Total-CM-OTHER EXPENSES3,118.27 2,294.00 824.27 33,530.03 41,458.00 (7,927.97) 41,458.00 7,927.97 19.1%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetJune 2020Month to Date Year to Date4 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,054.76 2,450.00 (395.24) 34,278.40 29,400.00 4,878.40 29,400.00 (4,878.40) -16.6%6321325 Insurance-Workers Comp288.50 484.00 (195.50) 6,508.01 5,955.00 553.01 5,955.00 (553.01) -9.3%6321800 Taxes-Employer Payroll343.34 1,290.00 (946.66) 10,818.58 15,990.00 (5,171.42) 15,995.00 5,176.42 32.4%6321880 Wages-Hourly9,880.24 12,904.00 (3,023.76) 126,983.89 156,528.00 (29,544.11) 156,528.00 29,544.11 18.9%6321882 Wages-Overtime- - - 6,374.27 3,418.00 2,956.27 3,418.00 (2,956.27) -86.5%Total-CM-LM-SALARIES & BENEFITS12,566.84 17,128.00 (4,561.16) 184,963.15 211,291.00 (26,327.85) 211,296.00 26,332.85 12.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 1,025.00 (1,025.00) 1,025.00 1,025.00 100.0%6323788 Uniforms542.35 290.00 252.35 2,940.20 3,480.00 (539.80) 3,480.00 539.80 15.5%Total-CM-LM-SUPPLIES & MATERIALS542.35 365.00 177.35 2,940.20 4,505.00 (1,564.80) 4,505.00 1,564.80 34.7%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation822.15 500.00 322.15 2,620.15 4,250.00 (1,629.85) 4,250.00 1,629.85 38.3%Total-CM-LM-REPAIRS & MAINTENANCE822.15 500.00 322.15 2,620.15 4,250.00 (1,629.85) 4,250.00 1,629.85 38.3%102,266.55 142,826.00 (40,559.45) 1,536,892.24 1,783,656.00 (246,763.76) 1,783,664.00 246,771.76 13.8% June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,407.79 12,439.00 (3,031.21) 113,758.60 105,647.00 8,111.60 179,791.00 66,032.40 36.7%6337842 Utilities-Water6,694.27 18,530.00 (11,835.73) 84,201.93 144,191.00 (59,989.07) 70,047.00 (14,154.93) -20.2%16,102.06 30,969.00 (14,866.94) 197,960.53 249,838.00 (51,877.47) 249,838.00 51,877.47 20.8%Silverrock ResortCourse Maintenance Water & EnergyJune 2020Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementJune 2020Silverrock ResortAnnual BudgetMonth to DateYear to Date5 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group715.45 304.00 411.45 6,252.18 3,648.00 2,604.18 3,648.00 (2,604.18) -71.4%6411325 Insurance-Workers Comp635.92 497.00 138.92 8,907.55 7,482.00 1,425.55 7,482.00 (1,425.55) -19.1%6411800 Taxes-Employer Payroll1,077.78 1,651.00 (573.22) 20,745.74 24,841.00 (4,095.26) 24,841.00 4,095.26 16.5%6411880 Wages-Hourly5,188.40 13,260.00 (8,071.60) 165,096.75 199,524.00 (34,427.25) 199,524.00 34,427.25 17.3%6411882 Wages-Overtime39.00 - 39.00 12,869.94 - 12,869.94 - (12,869.94) 0.0%Total-CBR-SALARIES & BENEFITS7,656.55 15,712.00 (8,055.45) 213,872.16 235,495.00 (21,622.84) 235,495.00 21,622.84 9.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 205.50 50.00 155.50 1,698.00 1,850.00 (152.00) 1,850.00 `0.0%6413742 Supplies-Expendable152.28 500.00 (347.72) 7,198.74 6,750.00 448.74 6,750.00 (448.74) -6.6%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 3,000.00 (3,000.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - 10,766.25 10,000.00 766.25 10,000.00 (766.25) -7.7%6413762 Supplies-Office- 50.00 (50.00) 208.68 525.00 (316.32) 525.00 316.32 60.3%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 92.73 420.00 (327.27) 420.00 327.27 77.9%6413786 Supplies-Towels240.00 72.00 168.00 5,475.89 2,182.00 3,293.89 2,182.00 (3,293.89) -151.0%6413796 Supplies-Bottled Water272.99 1,500.00 (1,227.01) 18,482.33 19,900.00 (1,417.67) 19,900.00 1,417.67 7.1%Total-CBR-SUPPLIES & MATERIALS870.77 2,342.00 (1,471.23) 43,922.62 44,627.00 (704.38) 44,627.00 552.38 1.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 1,758.34 300.00 1,458.34 2,711.03 3,600.00 (888.97) 3,600.00 888.97 24.7%6415695 CBR-R&M-Cart Maintenance & Repair 330.71 500.00 (169.29) 29,269.34 6,450.00 22,819.34 6,450.00 (22,819.34) -353.8%Total-CBR-REPAIRS & MAINTENANCE2,089.05 800.00 1,289.05 31,980.37 10,050.00 21,930.37 10,050.00 (21,930.37) -218.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen680.17 800.00 (119.83) 13,129.16 9,600.00 3,529.16 9,600.00 (3,529.16) -36.8%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous2,104.58 600.00 1,504.58 5,803.71 7,200.00 (1,396.29) 7,200.00 1,396.29 19.4%6419820 Uniforms- 200.00 (200.00) 3,449.05 5,200.00 (1,750.95) 5,200.00 1,750.95 33.7%Total-CBR-OTHER EXPENSES2,784.75 1,600.00 1,184.75 22,381.92 22,450.00 (68.08) 22,450.00 68.08 0.3%TOTAL-CARTS,BAGROOM & RANGE 13,401.12 20,454.00 1,184.75 312,157.07 312,622.00 (464.93) 312,622.00 312.93 0.1%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp407.68 115.00 292.68 4,774.50 2,629.00 2,145.50 2,630.00 (2,144.50) -81.5%6431800 Taxes-Employer Payroll623.40 306.00 317.40 8,313.82 7,015.00 1,298.82 7,013.00 (1,300.82) -18.5%6431880 Wages-Hourly2,495.90 3,060.00 (564.10) 69,783.30 70,133.00 (349.70) 70,133.00 349.70 0.5%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,526.98 3,481.00 45.98 82,871.62 79,777.00 3,094.62 79,776.00 (3,095.62) -3.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 75.00 (75.00) 367.61 1,050.00 (682.39) 1,050.00 682.39 65.0%6439490 Miscellaneous- - - - 200.00 (200.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) 58.46 600.00 (541.54) 600.00 541.54 90.3%6439820 Uniforms- 75.00 (75.00) 3,294.22 2,125.00 1,169.22 2,125.00 (1,169.22) -55.0%Total-CS-OTHER EXPENSES- 200.00 (200.00) 3,720.29 3,975.00 (254.71) 3,975.00 254.71 6.4%Total-COURSE SERVICES3,526.98 3,681.00 (154.02) 86,591.91 83,752.00 2,839.91 83,751.00 (2,840.91) -3.4%16,928.10 24,135.00 (7,206.90) 398,748.98 396,374.00 2,374.98 396,373.00 (2,782.69) -0.7%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetJune 20206 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%65-CH-UTILITIES6507836 Utilities-Natural Gas1,327.79 850.00 477.79 17,329.57 10,200.00 7,129.57 10,200.00 (7,129.57) -69.9%6507840 Utilities-Telephone1,330.49 1,150.00 180.49 14,906.07 13,800.00 1,106.07 13,800.00 (1,106.07) -8.0%6507842 Utilities-Water512.70 321.00 191.70 8,437.25 3,852.00 4,585.25 3,852.00 (4,585.25) -119.0%6507844 Utilities-Cable371.97 380.00 (8.03) 4,090.00 4,560.00 (470.00) 4,560.00 470.00 10.3%Total-CH-UTILITIES3,542.95 2,701.00 841.95 44,762.89 32,412.00 12,350.89 32,412.00 (12,350.89) -38.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning645.00 400.00 245.00 5,880.00 4,800.00 1,080.00 4,800.00 (1,080.00) -22.5%6509099 Contract Services-Security4,425.40 5,000.00 (574.60) 63,527.84 60,000.00 3,527.84 60,000.00 (3,527.84) -5.9%6509215 Flowers & Decorations- 400.00 (400.00) 713.10 1,900.00 (1,186.90) 1,900.00 1,186.90 62.5%6509490 Miscellaneous326.94 200.00 126.94 2,317.68 7,000.00 (4,682.32) 7,000.00 4,682.32 66.9%6509718 Safety Equipment & Training- 100.00 (100.00) 1,317.70 1,200.00 117.70 1,200.00 (117.70) -9.8%Total-CH-OTHER EXPENSES5,397.34 6,100.00 (702.66) 73,756.32 74,900.00 (1,143.68) 74,900.00 1,143.68 1.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures333.50 300.00 33.50 3,994.92 3,600.00 394.92 3,600.00 (394.92) -11.0%6515686 CH-R&M-Restaurant Repairs325.00 400.00 (75.00) 2,140.37 4,800.00 (2,659.63) 4,800.00 2,659.63 55.4%6515690 CH-R&M-Equipment Repair678.51 400.00 278.51 4,391.38 4,800.00 (408.62) 4,800.00 408.62 8.5%Total-CH-REPAIRS & MAINTENANCE1,337.01 1,100.00 237.01 10,526.67 13,200.00 (2,673.33) 13,200.00 2,673.33 20.3%10,677.30 10,301.00 376.30 133,845.88 125,312.00 8,533.88 125,312.00 5,346.66 4.3%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetJune 20207 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 391.92 348.00 43.92 5,729.96 4,176.00 1,553.96 4,176.00 (1,553.96) -37.2%6601325 Insurance-Workers Comp193.20 94.00 99.20 1,280.80 1,128.00 152.80 1,129.00 (151.80) -13.4%6601720 Salaries3,059.00 2,508.00 551.00 31,210.91 30,096.00 1,114.91 30,096.00 (1,114.91) -3.7%6601800 Taxes-Employer Payroll308.31 251.00 57.31 3,229.11 3,012.00 217.11 3,010.00 (219.11) -7.3%Total-MKT-SALARIES & BENEFITS3,952.43 3,201.00 751.43 41,450.78 38,412.00 3,038.78 38,411.00 (3,039.78) -7.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office25.20 100.00 (74.80) 609.46 1,200.00 (590.54) 1,200.00 590.54 49.2%6603768 Supplies-Printing & Stationery211.10 125.00 86.10 6,619.66 4,425.00 2,194.66 4,425.00 (2,194.66) -49.6%236.30 225.00 11.30 7,229.12 5,625.00 1,604.12 5,625.00 (1,604.12) -28.5%66-MKT-UTILITIES6607840 Utilities-Telephone 248.27 100.00 148.27 2,080.21 1,200.00 880.21 1,200.00 (880.21) -73.4%Total-MKT-UTILITIES248.27 100.00 148.27 2,080.21 1,200.00 880.21 1,200.00 (880.21) -73.4%66-MKT-OTHER EXPENSES6609010 Advertising 1,506.44 8,101.00 (6,594.56) 118,129.37 163,133.00 (45,003.63) 163,133.00 45,003.63 27.6%6609040 Business Meals- 25.00 (25.00) 59.18 300.00 (240.82) 300.00 240.82 80.3%6609080 Collateral Material244.36 1,000.00 (755.64) 7,027.02 5,500.00 1,527.02 5,500.00 (1,527.02) -27.8%6609102 Contract Services-Web Page649.00 150.00 499.00 6,534.00 1,800.00 4,734.00 1,800.00 (4,734.00) -263.0%6609490 Miscellaneous18.29 - 18.29 18.29 350.00 (331.71) 350.00 331.71 94.8%6609620 Postage- 50.00 (50.00) 117.61 600.00 (482.39) 600.00 482.39 80.4%6609630 Promotion300.00 50.00 250.00 321.74 700.00 (378.26) 700.00 378.26 54.0%6609633 Promotion-Community- 75.00 (75.00) 1,050.18 2,250.00 (1,199.82) 2,250.00 1,199.82 53.3%6609634 Promotion-Media/Vendor- - - 905.78 1,000.00 (94.22) 1,000.00 94.22 9.4%6609150 Dues and Subscriptions- - - - 735.00 (735.00) 735.00 735.00 100.0%6609820 Uniforms- - - 400.80 600.00 (199.20) 600.00 199.20 33.2%Total-MKT-OTHER EXPENSES2,718.09 9,451.00 (6,732.91) 134,563.97 176,968.00 (42,404.03) 176,968.00 42,404.03 24.0%7,155.09 12,977.00 (5,821.91) 185,324.08 222,205.00 (36,880.92) 222,204.00 36,879.92 16.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetJune 20208 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,362.95 2,180.00 (817.05) 31,291.52 26,160.00 5,131.52 26,160.00 (5,131.52) -19.6%6701325 Insurance-Workers Comp1,198.50 761.00 437.50 7,762.63 8,878.00 (1,115.37) 8,881.00 1,118.37 12.6%6701720 Salaries15,317.32 17,012.00 (1,694.68) 172,434.48 196,665.00 (24,230.52) 197,432.00 24,997.52 12.7%6701800 Taxes-Employer Payroll1,418.49 2,030.00 (611.51) 16,959.01 23,680.00 (6,720.99) 23,684.00 6,724.99 28.4%6701880 Wages-Hourly2,113.77 3,291.00 (1,177.23) 26,983.31 40,172.00 (13,188.69) 39,404.00 12,420.69 31.5%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS21,411.03 25,274.00 (3,862.97) 255,430.95 295,555.00 (40,124.05) 295,561.00 40,130.05 13.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer130.89 800.00 (669.11) 4,014.22 6,300.00 (2,285.78) 6,300.00 2,285.78 36.3%6703762 Supplies-Office- 105.00 (105.00) 1,709.89 1,260.00 449.89 1,260.00 (449.89) -35.7%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 1,552.70 3,300.00 (1,747.30) 3,300.00 1,747.30 52.9%Total-G&A-SUPPLIES & MATERIALS130.89 1,305.00 (1,174.11) 7,276.81 10,860.00 (3,583.19) 10,860.00 3,583.19 33.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 331.11 1,900.00 (1,568.89) 1,900.00 1,568.89 82.6%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 331.11 1,900.00 (1,568.89) 1,900.00 1,568.89 82.6%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 0.0%6709150 Dues & Subscriptions202.64 50.00 152.64 1,102.05 1,150.00 (47.95) 1,150.00 47.95 4.2%6709180 Employee Recruiting/Relocation30.00 - 30.00 1,152.27 1,200.00 (47.73) 1,200.00 47.73 4.0%6709197 Equipment Rental550.55 550.00 0.55 7,268.74 6,600.00 668.74 6,600.00 (668.74) -10.1%6709202 Fees-Bank71.64 90.00 (18.36) 1,213.98 1,080.00 133.98 1,080.00 (133.98) -12.4%6709208 Fees-Payroll Processing719.20 1,000.00 (280.80) 8,153.47 12,000.00 (3,846.53) 12,000.00 3,846.53 32.1%6709220 Freight/Delivery- 50.00 (50.00) - 600.00 (600.00) 600.00 600.00 100.0%6709490 Miscellaneous6.51 100.00 (93.49) 4,781.26 6,600.00 (1,818.74) 6,600.00 1,818.74 27.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 1,286.47 900.00 386.47 900.00 (386.47) -42.9%6709625 Professional Fees3,704.10 850.00 2,854.10 31,262.92 10,200.00 21,062.92 10,200.00 (21,062.92) -206.5%6709636 Promotion/Entertainment- 100.00 (100.00) 787.88 1,200.00 (412.12) 1,200.00 412.12 34.3%6709722 Seminars & Training621.00 200.00 421.00 2,245.00 2,400.00 (155.00) 2,400.00 155.00 6.5%6709810 Travel- 200.00 (200.00) - 1,100.00 (1,100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 402.13 1,050.00 (647.87) 1,050.00 647.87 61.7%Total-G&A-OTHER EXPENSES6,405.64 3,840.00 2,565.64 65,656.17 52,080.00 13,576.17 52,080.00 (13,576.17) -26.1%27,947.56 30,519.00 (2,571.44) 328,695.04 360,395.00 (31,699.96) 360,401.00 31,705.96 8.8%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetJune 20209 June 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.Expense68-LEASES6800192 Equipment Leases-Carts10,636.93 12,000.00 (1,363.07) 122,797.20 136,650.00 (13,852.80) 136,650.00 13,852.80 6800193 Equipment Leases-Maintenance 12,321.42 9,500.00 2,821.42 127,805.53 114,000.00 13,805.53 114,000.00 (13,805.53) 6800194 Equipment Leases-Trailer- 300.00 (300.00) 4,077.22 3,600.00 477.22 3,600.00 (477.22) 6800196 Equipment Leases-GPS2,640.00 2,900.00 (260.00) 39,060.00 38,800.00 260.00 38,800.00 (260.00) 6800197 Equipment Leases-Others2,116.32 1,950.00 166.32 24,229.05 20,200.00 4,029.05 20,200.00 (4,029.05) 27,714.67 26,650.00 1,064.67 317,969.00 313,250.00 4,719.00 313,250.00 (4,719.00) 69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,880.00 9,880.00 - 118,560.00 118,560.00 - 118,560.00 - 6900800 Personal Property Taxes- - - 13,171.65 11,800.00 1,371.65 11,800.00 (1,371.65) 6900323 Insurance-Commercial6,047.07 4,000.00 2,047.07 64,401.35 48,000.00 16,401.35 48,000.00 (16,401.35) 15,927.07 13,880.00 2,047.07 196,133.00 178,360.00 17,773.00 178,360.00 (17,773.00) Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to DateYear to DateJune 202010 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2019-20202019 2019 2019 2019 2019 2019Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4SalesPromotion10Golf IndustryVIPCelebrityPGA Comp4543622Charity/Gift Certificate441817Rain/Wind Checks125Club Staff13 22 35427 50LQ HS Golf5522 36 45841 1092020 2020 2020 2020 2020 2020Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia8SalesPromotionGolf IndustryVIPCelebrityPGA Comp13 13710 12Charity/Gift Certificate276964Rain/Wind Checks21005Club Staff56 32 12742 40LQ HS Golf12 41 16116 94 54758 6111