Loading...
11 May 2020 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2019 – May 2020 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 May 2020Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue161,819.00 274,805.00 (112,986.00) -41.1% 2,251,604.08 3,067,554.00 (815,949.92) 3,209,134.00 957,529.92 70%401000 Miscellaneous Golf Revenue8,955.00 26,020.00 (17,065.00) -65.6% 189,348.97 279,298.00 (89,949.03) 300,066.00 110,717.03 63%410000 Revenue-Golf Shop4,493.03 27,648.00 (23,154.97) -83.7% 134,589.01 234,557.00 (99,967.99) 249,256.00 114,666.99 54%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income- - - 0.0%0.37 - 0.37 - (0.37) 0%Total Income175,767.03 328,973.00 (153,205.97) -46.6% 2,587,042.43 3,592,909.00 (1,005,866.57) 3,770,456.00 1,183,413.57 69%Cost of Goods Sold510000 COS-Golf Shop2,713.99 15,475.00 (12,761.01) 82.5% 79,921.47 131,281.00 51,359.53 139,509.00 59,587.53 57%Total COS2,713.99 15,475.00 (12,761.01) 82.5% 79,921.47 131,281.00 51,359.53 139,509.00 59,587.53 57%Gross Profit173,053.04 313,498.00 (140,444.96) -44.8% 2,507,120.96 3,461,628.00 (954,507.04) 3,630,947.00 1,123,826.04 69%Expenses610000 Golf Pro Shop 13,704.14 22,153.00 (8,448.86) 38.1% 172,466.58 190,345.00 (17,878.42) 208,393.00 35,926.42 83%630000 Course Maintenance82,518.63 128,802.00 (46,283.37) 35.9% 1,423,559.05 1,640,830.00 (217,270.95) 1,783,663.00 360,103.95 80%633000 Maintenance Water & Energy19,036.32 25,736.00 (6,699.68) 26.0% 189,858.47 218,869.00 (29,010.53) 249,838.00 59,979.53 76%640000 Outside Services17,927.49 26,620.00 (8,692.51) 32.7% 381,820.88 372,239.00 9,581.88 396,373.00 14,552.12 96%650000 Clubhouse8,099.26 9,901.00 (1,801.74) 18.2% 123,168.58 115,011.00 8,157.58 125,312.00 2,143.42 98%660000 Marketing9,575.95 17,832.00 (8,256.05) 46.3% 178,168.99 209,228.00 (31,059.01) 222,203.00 44,034.01 80%670000 General & Administrative29,012.12 30,769.00 (1,756.88) 5.7% 299,805.74 329,876.00 (30,070.26) 360,401.00 60,595.26 83%680000 Leases24,397.03 26,650.00 (2,252.97) 8.5% 290,254.33 286,600.00 3,654.33 313,250.00 22,995.67 93%690000 Miscellaneous Other Expense14,944.99 13,880.00 1,064.99 -7.7% 180,205.93 164,480.00 15,725.93 178,360.00 (1,845.93) 101%Total Expenses219,215.93 302,343.00 (83,127.07) 27.5% 3,239,308.55 3,527,478.00 288,169.45 3,837,793.00 598,484.45 84%(46,162.89) 11,155.00 (57,317.89) -513.8%(732,187.59) (65,850.00) (666,337.59) (206,846.00) 525,341.59 0%Rounds of Golf PlayedPaid Rounds Played2,704 4,608 (1,904) -41.3%31,214 41,217 (10,003) 43,667 12,453 71%Ave $ Per Paid Round Green Fee59.84 59.64 0.21 0.3%72.13 74.42 (2.29) 73.49 1.36 98%Ave $ Per Paid Round Merchandise1.66 6.00 (4.34) -72.3%4.31 5.69 (1.38) 5.71 1.40 76%Ave $ Per Paid Miscellaneous 0.33 5.65 (5.32) -94.1%6.07 6.78 (0.71) 6.87 0.81 88%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMay 20201 Income May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees161,819.00 274,805.00 (112,986.00) 2,251,604.08 3,067,554.00 (815,949.92) 3,209,134.00 957,529.92 29.8%4010000 Rider Fee- 495.00 (495.00) 7,035.00 7,563.00 (528.00) 7,807.00 772.00 9.9%4040000 Club Rental90.00 2,475.00 (2,385.00) 16,075.00 19,863.00 (3,788.00) 21,087.00 5,012.00 23.8%4050000 Driving Range- 7,425.00 (7,425.00) 51,238.00 91,197.00 (39,959.00) 94,872.00 43,634.00 46.0%4060000 Handicap Fees- - - 2,466.00 2,500.00 (34.00) 2,500.00 34.00 1.4%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 Issue8,865.00 15,625.00 (6,760.00) 105,070.00 149,675.00 (44,605.00) 165,300.00 60,230.00 36.4% Total Revenue Fees170,774.00 300,825.00 (130,051.00) 2,440,953.05 3,346,852.00 (905,898.95) 3,509,200.00 1,068,246.95 30.4%170,774.00 300,825.00 (130,051.00) 2,440,953.05 3,346,852.00 (905,898.95) 3,509,200.00 1,068,246.95 30.4%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetMay 20202 RevenuesActualBudgetVariance$175,767.03$328,973.00(153,205.97)Unfavorable: All revenues are down due to restrictions implemented by the State and County as a result of The Corona-Virus. Guidelines only allowone person per cart, cutting our rounds for the month in half. All tee-times are prepaid in advance so there is no exposure for sales in the Pro-shop. Our driving is closed for this period allowing only paying golfer's to utilize before their round of golf.Expenses219,215.93$ 302,343.00$ (83,127.07)In efforts to reduce our expenses during this time, we have implemented reduced payroll throughout the Club. Maintenance staff has been reducedsignificantly, as well as the Cart barn and Course Services. The ProShop is being manned with one person per shift due to non-utilization of cash,Tee times reservations are all booked online and prepaid. Our hours of operations have beens reduced due the the restricted play that we have inadvance for a certain period. Our vendors, contractors have worked with us to reduce costs by allowing reduced order requirements and waiving feesnormally charged. We have also incurred a lot of additional expense refitting our facility to make it as clean and compliant as possible. This requires all carts to be thoroughly sanitized after each round played. Bathrooms, offices and restaurant required additional fitting for sanitizing and the layouts for socialdistancing. For this period we were only serving a limited menu, of to go items. Guest were not allowed to utilize the terrace, or any in-door seatingas directed by the County of Riverside. Social distancing, as well as facemask were required.Steps taken to reduce Expenses this periodas a measure to comply with county requirements. We have reduced our marketing expenditures for everything that had not been prepaid or paidVariance ExplanationMay 2020Explanation of Revenues, and expenses for the month as impacted by the Corona-VirusGreen Fees-Misc. Income-Retail3 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.Expense68-LEASES6800192 Equipment Leases-Carts10,636.93 12,000.00 (1,363.07) 112,160.27 124,650.00 (12,489.73) 136,650.00 24,489.73 6800193 Equipment Leases-Maintenance8,789.72 9,500.00 (710.28) 115,484.11 104,500.00 10,984.11 114,000.00 (1,484.11) 6800194 Equipment Leases-Trailer- 300.00 (300.00) 4,077.22 3,300.00 777.22 3,600.00 (477.22) 6800196 Equipment Leases-GPS2,900.00 2,900.00 - 36,420.00 35,900.00 520.00 38,800.00 2,380.00 6800197 Equipment Leases-Others2,070.38 1,950.00 120.38 22,112.73 18,250.00 3,862.73 20,200.00 (1,912.73) 24,397.03 26,650.00 (2,252.97) 290,254.33 286,600.00 3,654.33 313,250.00 22,995.67 69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,880.00 9,880.00 - 108,680.00 108,680.00 - 118,560.00 9,880.00 6900800 Personal Property Taxes- - - 13,171.65 11,800.00 1,371.65 11,800.00 (1,371.65) 6900323 Insurance-Commercial5,064.99 4,000.00 1,064.99 58,354.28 44,000.00 14,354.28 48,000.00 (10,354.28) 14,944.99 13,880.00 1,064.99 180,205.93 164,480.00 15,725.93 178,360.00 (1,845.93) Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to DateYear to DateMay 20204 Income May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous387.25 - 387.25 7,872.79 - 7,872.79 00 0%4100110 Sales Hard Goods2,862.07 6,912.00 (4,049.93) 59,119.76 58,640.00 479.76 62,314.00 3,194.24 5.1%4100112 Sales-Soft Goods1,478.00 20,736.00 (19,258.00) 89,146.75 175,917.00 (86,770.25) 186,942.00 97,795.25 52.3%5100639 GS-Discounts-Mdse(234.29) - (234.29) (21,550.29) - (21,550.29) - 21,550.29 0.0% Total Revenue Golf Shop4,493.03 27,648.00 (23,154.97) 134,589.01 234,557.00 (99,967.99) 249,256.00 122,539.78 49.2%COS 5100150 COS-GS-Hard Goods 1,722.84 4,009.00 (2,286.16) 35,155.72 34,010.00 1,145.72 34,877.15 (278.57) -0.8%5100151 COS-GS-Soft Goods991.15 12,027.00 (11,035.85) 43,493.62 102,032.00 (58,538.38) 104,631.44 61,137.82 58.4%5100152 COS-GS-Purchase Disc- (802.00) 802.00 (467.13) (6,802.00) 6,334.87 (7,228.00) (6,760.87) 93.5%5100220 COS-GS-Freight Merch- 241.00 (241.00) 1,739.26 2,041.00 (301.74) 2,169.00 429.74 19.8%Cost of Sales - Golf Shop2,713.99 15,475.00 (12,761.01) 79,921.47 131,281.00 (51,359.53) 134,449.59 54,528.12 40.6%Gross Profit 1,779.04 12,173.00 (10,393.96) 54,667.54 103,276.00 (48,608.46) 114,806.41 68,011.66 59.2%COS %60.4% 56.0% -4.4% 59.4% 56.0% -3.4% 53.1% 44.5% 83.8%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group903.31 490.00 413.31 5,064.87 5,390.00 (325.13) 5,880.00 815.13 13.9%6101325 Insurance-Workers Comp 1,079.22 562.00 517.22 6,529.11 5,511.00 1,018.11 6,054.00 (475.11) -7.8%6101720 Salaries6,168.16 4,530.00 1,638.16 55,796.67 48,530.00 7,266.67 65,000.00 9,203.33 14.2%6101800 Taxes-Employer Payroll 603.17 1,498.00 (894.83) 13,449.44 14,699.00 (1,249.56) 16,144.00 2,694.56 16.7%6101880 Wages-Hourly4,624.00 10,448.00 (5,824.00) 81,373.63 98,450.00 (17,076.37) 98,874.00 17,500.37 17.7%6101882 Wages-Overtime- - - 1,053.80 - 1,053.80 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 13,377.86 17,528.00 (4,150.14) 163,267.52 172,580.00 (9,312.48) 191,952.00 30,691.16 16.0%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 1,347.48 - 1,347.48 - (1,347.48) 0.0%6103762 Supplies-Office92.42 250.00 (157.58) 2,924.25 2,750.00 174.25 3,000.00 75.75 2.5%6109220 Freight & Delivery- - - 378.11 75.00 303.11 75.00 (303.11) -404.1%6109490 Miscellaneous77.74 500.00 (422.26) 1,484.93 5,500.00 (4,015.07) 6,000.00 4,515.07 75.3%6109150 Dues and Subscriptions- 2,300.00 (2,300.00) - 2,300.00 (2,300.00) 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short- - - 23.55 - 23.55 - (23.55) 0.0%6109722 Seminars/Training- 1,250.00 (1,250.00) - 3,655.00 (3,655.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 1,921.72 2,200.00 (278.28) 2,400.00 478.28 19.9%6117840 Telephones156.12 110.00 46.12 1,119.02 1,210.00 (90.98) 1,320.00 200.98 15.2%326.28 4,625.00 (4,298.72) 9,199.06 17,765.00 (8,565.94) 18,875.00 9,675.94 51.3%13,704.14 22,153.00 (8,448.86) 172,466.58 190,345.00 (17,878.42) 210,827.00 40,367.10 19.1%Net Income(11,925.10) (9,980.00) (1,945.10) (117,799.04) (87,069.00) (30,730.04) (96,020.59) 27,644.56 -28.8%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetMay 20205 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group16,665.15 9,810.00 6,855.15 97,442.85 107,910.00 (10,467.15) 117,720.00 20,277.15 17.2%6311325 Insurance-Workers Comp3,668.05 2,507.00 1,161.05 26,146.67 26,348.00 (201.33) 28,929.00 2,782.33 9.6%6311720 Salaries13,012.76 12,480.00 532.76 143,652.87 137,280.00 6,372.87 166,400.00 22,747.13 13.7%6311800 Taxes-Employer Payroll2,768.02 6,686.00 (3,917.98) 58,300.66 70,886.00 (12,585.34) 77,767.00 19,466.34 25.0%6311880 Wages-Hourly23,667.69 54,378.00 (30,710.31) 453,602.97 553,052.00 (99,449.03) 592,769.00 139,166.03 23.5%6311882 Wages-Overtime- - - 41,355.25 18,500.00 22,855.25 18,500.00 (22,855.25) -123.5%Total-CM-SALARIES & BENEFITS59,781.67 85,861.00 (26,079.33) 820,501.27 913,976.00 (93,474.73) 1,002,085.00 181,583.73 18.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,095.66 2,200.00 895.66 33,250.71 43,552.00 (10,301.29) 50,060.00 16,809.29 33.6%6313744 Fertilizer1,560.39 3,350.00 (1,789.61) 61,549.76 93,890.00 (32,340.24) 104,520.00 42,970.24 41.1%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,546.28 3,850.00 (1,303.72) 34,414.66 43,280.00 (8,865.34) 46,860.00 12,445.34 26.6%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 Supp446.43 100.00 346.43 5,075.82 4,250.00 825.82 4,350.00 (725.82) -16.7%6313762 Supplies-Office- - - 1,632.22 - 1,632.22 - (1,632.22) 0.0%6313774 Sand896.15 100.00 796.15 9,215.88 13,360.00 (4,144.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 4,900.00 (1,291.63) 5,000.00 1,391.63 27.8%6313780 Sod- 1,250.00 (1,250.00) 9,606.61 12,050.00 (2,443.39) 15,500.00 5,893.39 38.0%6313782 Topdressing- 1,500.00 (1,500.00) 774.46 8,500.00 (7,725.54) 10,000.00 9,225.54 92.3%Total-CM-SUPPLIES & MATERIALS8,544.91 12,450.00 (3,905.09) 284,602.83 367,272.00 (82,669.17) 393,240.00 108,637.17 27.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint- 3,850.00 (3,850.00) 31,078.19 26,950.00 4,128.19 30,800.00 (278.19) -0.9%6315685 CM-R&M-Bldngs & Othr Structures 510.79 250.00 260.79 9,200.28 5,300.00 3,900.28 5,550.00 (3,650.28) -65.8%6315690 CM-R&M-Equipment1,336.76 2,500.00 (1,163.24) 37,426.80 36,000.00 1,426.80 38,500.00 1,073.20 2.8%6315692 CM-R&M-Irrigation System116.34 1,000.00 (883.66) 21,362.04 18,050.00 3,312.04 19,050.00 (2,312.04) -12.1%6315696 CM-R&M-Pumps343.13 500.00 (156.87) 4,257.03 10,500.00 (6,242.97) 10,500.00 6,242.97 59.5%6315815 CM-R&M-Trees-Pruning Etc- - - 5,730.00 12,050.00 (6,320.00) 12,050.00 6,320.00 52.4%Total-CM-REPAIRS & MAINTENANCE2,307.02 8,100.00 (5,792.98) 109,054.34 108,850.00 204.34 116,450.00 7,395.66 6.4%6317836 Utilities-Natural Gas/LPG 44.83 15.00 29.83 243.16 165.00 78.16 180.00 (63.16) 0.0%6317840 Telephones828.45 850.00 (21.55) 8,220.17 9,350.00 (1,129.83) 10,200.00 1,979.83 19.4%Total-CM-UTILITIES873.28 865.00 8.28 8,463.33 9,515.00 (1,051.67) 10,380.00 1,916.67 18.5%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%6319100 Contract Svcs-Soil/Tissue Test- 1,000.00 (1,000.00) 85.00 2,000.00 (1,915.00) 2,000.00 1,915.00 95.8%6319102 Contract Svcs-Trash Removal- 524.00 (524.00) 1,340.44 5,764.00 (4,423.56) 6,288.00 4,947.56 78.7%6319150 Dues & Subscriptions- - - 4,440.00 580.00 3,860.00 680.00 (3,760.00) -552.9%6319170 Employee Education- 50.00 (50.00) - 3,850.00 (3,850.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) - 3,300.00 (3,300.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- - - 4,375.36 4,300.00 75.36 4,300.00 (75.36) -1.8%6319490 Miscellaneous70.28 100.00 (29.72) 1,546.82 1,100.00 446.82 1,200.00 (346.82) -28.9%6319718 Safety Equipment & Training- 100.00 (100.00) 2,351.69 3,750.00 (1,398.31) 3,850.00 1,498.31 38.9%6319822 Uniforms885.24 920.00 (34.76) 11,872.45 10,120.00 1,752.45 11,040.00 (832.45) -7.5%Total-CM-OTHER EXPENSES1,355.52 3,294.00 (1,938.48) 30,411.76 39,164.00 (8,752.24) 41,458.00 11,046.24 26.6%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementAnnual BudgetMay 20206 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 4,254.16 2,450.00 1,804.16 32,223.64 26,950.00 5,273.64 29,400.00 (2,823.64) -9.6%6321325 Insurance-Workers Comp954.20 500.00 454.20 6,219.51 5,471.00 748.51 5,955.00 (264.51) -4.4%6321800 Taxes-Employer Payroll268.35 1,333.00 (1,064.65) 9,588.00 14,700.00 (5,112.00) 15,995.00 6,407.00 40.1%6321880 Wages-Hourly4,179.52 13,334.00 (9,154.48) 111,924.25 143,624.00 (31,699.75) 156,528.00 44,603.75 28.5%6321882 Wages-Overtime- - - 6,374.27 3,418.00 2,956.27 3,418.00 (2,956.27) -86.5%Total-CM-LM-SALARIES & BENEFITS9,656.23 17,617.00 (7,960.77) 166,329.67 194,163.00 (27,833.33) 211,296.00 44,966.33 21.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 950.00 (950.00) 1,025.00 1,025.00 100.0%6323788 Uniforms- 290.00 (290.00) 2,397.85 3,190.00 (792.15) 3,480.00 1,082.15 31.1%Total-CM-LM-SUPPLIES & MATERIALS- 365.00 (365.00) 2,397.85 4,140.00 (1,742.15) 4,505.00 2,107.15 46.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) 1,798.00 3,750.00 (1,952.00) 4,250.00 2,452.00 57.7%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) 1,798.00 3,750.00 (1,952.00) 4,250.00 2,452.00 57.7%82,518.63 128,802.00 (46,283.37) 1,423,559.05 1,640,830.00 (217,270.95) 1,783,664.00 360,104.95 20.2% May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,079.78 7,719.00 1,360.78 104,350.81 93,208.00 11,142.81 179,791.00 75,440.19 42.0%6337842 Utilities-Water9,956.54 18,017.00 (8,060.46) 85,507.66 125,661.00 (40,153.34) 70,047.00 (15,460.66) -22.1%19,036.32 25,736.00 (6,699.68) 189,858.47 218,869.00 (29,010.53) 249,838.00 59,979.53 24.0%Total-COURSE MAINTENANCECourse Maintenance Expense StatementMay 2020Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyMay 2020Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget7 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group2,196.50 304.00 1,892.50 5,536.73 3,344.00 2,192.73 3,648.00 (1,888.73) -51.8%6411325 Insurance-Workers Comp709.06 527.00 182.06 8,271.63 6,985.00 1,286.63 7,482.00 (789.63) -10.6%6411800 Taxes-Employer Payroll636.64 1,748.00 (1,111.36) 19,667.96 23,190.00 (3,522.04) 24,841.00 5,173.04 20.8%6411880 Wages-Hourly8,377.39 14,040.00 (5,662.61) 159,908.35 186,264.00 (26,355.65) 199,524.00 39,615.65 19.9%6411882 Wages-Overtime78.02 - 78.02 12,830.94 - 12,830.94 - (12,830.94) 0.0%Total-CBR-SALARIES & BENEFITS11,997.61 16,619.00 (4,621.39) 206,215.61 219,783.00 (13,567.39) 235,495.00 29,279.39 12.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 437.42 50.00 387.42 1,492.50 1,800.00 (307.50) 1,850.00 `0.0%6413742 Supplies-Expendable441.19 500.00 (58.81) 7,046.46 6,250.00 796.46 6,750.00 (296.46) -4.4%6413748 Supplies-Fuel for Shuttle- 200.00 (200.00) - 2,900.00 (2,900.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 475.00 (266.32) 525.00 316.32 60.3%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 92.73 350.00 (257.27) 420.00 327.27 77.9%6413786 Supplies-Towels160.00 250.00 (90.00) 5,235.89 2,110.00 3,125.89 2,182.00 (3,053.89) -140.0%6413796 Supplies-Bottled Water- 1,500.00 (1,500.00) 18,209.34 18,400.00 (190.66) 19,900.00 1,690.66 8.5%Total-CBR-SUPPLIES & MATERIALS1,038.61 2,620.00 (1,581.39) 43,051.85 42,285.00 766.85 44,627.00 1,217.65 2.7%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 952.69 3,300.00 (2,347.31) 3,600.00 2,647.31 73.5%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 28,938.63 5,950.00 22,988.63 6,450.00 (22,488.63) -348.7%Total-CBR-REPAIRS & MAINTENANCE- 800.00 (800.00) 29,891.32 9,250.00 20,641.32 10,050.00 (19,841.32) -197.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen555.29 800.00 (244.71) 12,448.99 8,800.00 3,648.99 9,600.00 (2,848.99) -29.7%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous245.85 600.00 (354.15) 3,699.13 6,600.00 (2,900.87) 7,200.00 3,500.87 48.6%6419820 Uniforms- 1,500.00 (1,500.00) 3,449.05 5,000.00 (1,550.95) 5,200.00 1,750.95 33.7%Total-CBR-OTHER EXPENSES801.14 2,900.00 (2,098.86) 19,597.17 20,850.00 (1,252.83) 22,450.00 2,852.83 12.7%TOTAL-CARTS,BAGROOM & RANGE 13,837.36 22,939.00 (2,098.86) 298,755.95 292,168.00 6,587.95 312,622.00 13,508.55 4.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp311.73 115.00 196.73 4,366.82 2,514.00 1,852.82 2,630.00 (1,736.82) -66.0%6431800 Taxes-Employer Payroll661.15 306.00 355.15 7,690.42 6,709.00 981.42 7,013.00 (677.42) -9.7%6431880 Wages-Hourly3,117.25 3,060.00 57.25 67,287.40 67,073.00 214.40 70,133.00 2,845.60 4.1%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,090.13 3,481.00 609.13 79,344.64 76,296.00 3,048.64 79,776.00 431.36 0.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 75.00 (75.00) 367.61 975.00 (607.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 550.00 (491.54) 600.00 541.54 90.3%6439820 Uniforms- 75.00 (75.00) 3,294.22 2,050.00 1,244.22 2,125.00 (1,169.22) -55.0%Total-CS-OTHER EXPENSES- 200.00 (200.00) 3,720.29 3,775.00 (54.71) 3,975.00 254.71 6.4%Total-COURSE SERVICES4,090.13 3,681.00 409.13 83,064.93 80,071.00 2,993.93 83,751.00 686.07 0.8%17,927.49 26,620.00 (8,692.51) 381,820.88 372,239.00 9,581.88 396,373.00 13,939.91 3.5%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetMay 20208 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%65-CH-UTILITIES6507836 Utilities-Natural Gas461.20 850.00 (388.80) 16,001.78 9,350.00 6,651.78 10,200.00 (5,801.78) -56.9%6507840 Utilities-Telephone768.36 1,150.00 (381.64) 13,575.58 12,650.00 925.58 13,800.00 224.42 1.6%6507842 Utilities-Water215.81 321.00 (105.19) 7,924.55 3,531.00 4,393.55 3,852.00 (4,072.55) -105.7%6507844 Utilities-Cable371.97 380.00 (8.03) 3,718.03 4,180.00 (461.97) 4,560.00 841.97 18.5%Total-CH-UTILITIES1,817.34 2,701.00 (883.66) 41,219.94 29,711.00 11,508.94 32,412.00 (8,807.94) -27.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning350.00 400.00 (50.00) 5,235.00 4,400.00 835.00 4,800.00 (435.00) -9.1%6509099 Contract Services-Security4,527.28 5,000.00 (472.72) 59,102.44 55,000.00 4,102.44 60,000.00 897.56 1.5%6509215 Flowers & Decorations- - - 713.10 1,500.00 (786.90) 1,900.00 1,186.90 62.5%6509490 Miscellaneous- 200.00 (200.00) 1,990.74 6,800.00 (4,809.26) 7,000.00 5,009.26 71.6%6509718 Safety Equipment & Training149.68 100.00 49.68 1,317.70 1,100.00 217.70 1,200.00 (117.70) -9.8%Total-CH-OTHER EXPENSES5,026.96 5,700.00 (673.04) 68,358.98 68,800.00 (441.02) 74,900.00 6,541.02 8.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures458.50 300.00 158.50 3,661.42 3,300.00 361.42 3,600.00 (61.42) -1.7%6515686 CH-R&M-Restaurant Repairs75.37 400.00 (324.63) 1,815.37 4,400.00 (2,584.63) 4,800.00 2,984.63 62.2%6515690 CH-R&M-Equipment Repair321.09 400.00 (78.91) 3,712.87 4,400.00 (687.13) 4,800.00 1,087.13 22.6%Total-CH-REPAIRS & MAINTENANCE854.96 1,100.00 (245.04) 9,189.66 12,100.00 (2,910.34) 13,200.00 4,010.34 30.4%8,099.26 9,901.00 (1,801.74) 123,168.58 115,011.00 8,157.58 125,312.00 8,020.68 6.4%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetMay 20209 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 1,245.10 348.00 897.10 5,338.04 3,828.00 1,510.04 4,176.00 (1,162.04) -27.8%6601325 Insurance-Workers Comp107.10 94.00 13.10 1,087.60 1,034.00 53.60 1,129.00 41.40 3.7%6601720 Salaries2,415.00 2,508.00 (93.00) 28,151.91 27,588.00 563.91 30,096.00 1,944.09 6.5%6601800 Taxes-Employer Payroll243.40 251.00 (7.60) 2,920.80 2,761.00 159.80 3,010.00 89.20 3.0%Total-MKT-SALARIES & BENEFITS4,010.60 3,201.00 809.60 37,498.35 35,211.00 2,287.35 38,411.00 912.65 2.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office- 100.00 (100.00) 584.26 1,100.00 (515.74) 1,200.00 615.74 51.3%6603768 Supplies-Printing & Stationery1,402.83 125.00 1,277.83 6,408.56 4,300.00 2,108.56 4,425.00 (1,983.56) -44.8%1,402.83 225.00 1,177.83 6,992.82 5,400.00 1,592.82 5,625.00 (1,367.82) -24.3%66-MKT-UTILITIES6607840 Utilities-Telephone 248.27 100.00 148.27 1,831.94 1,100.00 731.94 1,200.00 (631.94) -52.7%Total-MKT-UTILITIES248.27 100.00 148.27 1,831.94 1,100.00 731.94 1,200.00 (631.94) -52.7%66-MKT-OTHER EXPENSES6609010 Advertising 2,616.65 12,906.00 (10,289.35) 116,622.93 155,032.00 (38,409.07) 163,133.00 46,510.07 28.5%6609040 Business Meals59.18 25.00 34.18 59.18 275.00 (215.82) 300.00 240.82 80.3%6609080 Collateral Material567.68 1,000.00 (432.32) 6,782.66 4,500.00 2,282.66 5,500.00 (1,282.66) -23.3%6609102 Contract Services-Web Page649.00 150.00 499.00 5,885.00 1,650.00 4,235.00 1,800.00 (4,085.00) -226.9%6609490 Miscellaneous- 50.00 (50.00) - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) 117.61 550.00 (432.39) 600.00 482.39 80.4%6609630 Promotion21.74 50.00 (28.26) 21.74 650.00 (628.26) 700.00 678.26 96.9%6609633 Promotion-Community- 75.00 (75.00) 1,050.18 2,175.00 (1,124.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 EXPENSES3,914.25 14,306.00 (10,391.75) 131,845.88 167,517.00 (35,671.12) 176,968.00 45,122.12 25.5%9,575.95 17,832.00 (8,256.05) 178,168.99 209,228.00 (31,059.01) 222,204.00 44,035.01 19.8%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetMay 202010 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group4,185.88 2,180.00 2,005.88 29,928.57 23,980.00 5,948.57 26,160.00 (3,768.57) -14.4%6701325 Insurance-Workers Comp1,610.00 761.00 849.00 6,564.13 8,117.00 (1,552.87) 8,881.00 2,316.87 26.1%6701720 Salaries13,835.78 17,012.00 (3,176.22) 157,117.16 179,653.00 (22,535.84) 197,432.00 40,314.84 20.4%6701800 Taxes-Employer Payroll1,097.00 2,030.00 (933.00) 15,540.52 21,650.00 (6,109.48) 23,684.00 8,143.48 34.4%6701880 Wages-Hourly1,270.50 3,291.00 (2,020.50) 24,869.54 36,881.00 (12,011.46) 39,404.00 14,534.46 36.9%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS21,999.16 25,274.00 (3,274.84) 234,019.92 270,281.00 (36,261.08) 295,561.00 61,541.08 20.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,865.60 500.00 1,365.60 3,883.33 5,500.00 (1,616.67) 6,300.00 2,416.67 38.4%6703762 Supplies-Office32.61 105.00 (72.39) 1,709.89 1,155.00 554.89 1,260.00 (449.89) -35.7%6703768 Supplies-Printing & Stationery229.43 400.00 (170.57) 1,552.70 2,900.00 (1,347.30) 3,300.00 1,747.30 52.9%Total-G&A-SUPPLIES & MATERIALS2,127.64 1,005.00 1,122.64 7,145.92 9,555.00 (2,409.08) 10,860.00 3,714.08 34.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 287.28 100.00 187.28 331.11 1,800.00 (1,468.89) 1,900.00 1,568.89 82.6%Total-G&A-REPAIRS & MAINTENANCE287.28 100.00 187.28 331.11 1,800.00 (1,468.89) 1,900.00 1,568.89 82.6%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 8.3%6709150 Dues & Subscriptions- 300.00 (300.00) 899.41 1,100.00 (200.59) 1,150.00 250.59 21.8%6709180 Employee Recruiting/Relocation- - - 1,122.27 1,200.00 (77.73) 1,200.00 77.73 6.5%6709197 Equipment Rental382.64 550.00 (167.36) 6,718.19 6,050.00 668.19 6,600.00 (118.19) -1.8%6709202 Fees-Bank- 90.00 (90.00) 1,074.91 990.00 84.91 1,080.00 5.09 0.5%6709208 Fees-Payroll Processing1,000.07 1,000.00 0.07 6,559.96 11,000.00 (4,440.04) 12,000.00 5,440.04 45.3%6709220 Freight/Delivery- 50.00 (50.00) - 550.00 (550.00) 600.00 600.00 100.0%6709490 Miscellaneous57.49 100.00 (42.51) 4,774.75 6,500.00 (1,725.25) 6,600.00 1,825.25 27.7%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services306.79 75.00 231.79 1,286.47 825.00 461.47 900.00 (386.47) -42.9%6709625 Professional Fees1,439.00 850.00 589.00 27,558.82 9,350.00 18,208.82 10,200.00 (17,358.82) -170.2%6709636 Promotion/Entertainment787.88 100.00 687.88 787.88 1,100.00 (312.12) 1,200.00 412.12 34.3%6709722 Seminars & Training124.17 200.00 (75.83) 1,624.00 2,200.00 (576.00) 2,400.00 776.00 32.3%6709810 Travel- 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 402.13 975.00 (572.87) 1,050.00 647.87 61.7%Total-G&A-OTHER EXPENSES4,598.04 4,390.00 208.04 58,308.79 48,240.00 10,068.79 52,080.00 (6,228.79) -12.0%29,012.12 30,769.00 (1,756.88) 299,805.74 329,876.00 (30,070.26) 360,401.00 60,595.26 16.8%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetMay 202011 May 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.Expense68-LEASES6800192 Equipment Leases-Carts10,636.93 12,000.00 (1,363.07) 112,160.27 124,650.00 (12,489.73) 136,650.00 24,489.73 6800193 Equipment Leases-Maintenance8,789.72 9,500.00 (710.28) 115,484.11 104,500.00 10,984.11 114,000.00 (1,484.11) 6800194 Equipment Leases-Trailer- 300.00 (300.00) 4,077.22 3,300.00 777.22 3,600.00 (477.22) 6800196 Equipment Leases-GPS2,900.00 2,900.00 - 36,420.00 35,900.00 520.00 38,800.00 2,380.00 6800197 Equipment Leases-Others2,070.38 1,950.00 120.38 22,112.73 18,250.00 3,862.73 20,200.00 (1,912.73) 24,397.03 26,650.00 (2,252.97) 290,254.33 286,600.00 3,654.33 313,250.00 22,995.67 69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,880.00 9,880.00 - 108,680.00 108,680.00 - 118,560.00 9,880.00 6900800 Personal Property Taxes- - - 13,171.65 11,800.00 1,371.65 11,800.00 (1,371.65) 6900323 Insurance-Commercial5,064.99 4,000.00 1,064.99 58,354.28 44,000.00 14,354.28 48,000.00 (10,354.28) 14,944.99 13,880.00 1,064.99 180,205.93 164,480.00 15,725.93 178,360.00 (1,845.93) Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateMay 202012