Loading...
10 April 2020 SilverRock Resort - Monthly Financial StatementMonthly Financial Statements July 2019 – April 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 April 2020Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue41,620.25 370,409.00 (328,788.75) -88.8% 2,089,785.08 2,792,749.00 (702,963.92) 3,209,134.00 1,119,348.92 65%401000 Miscellaneous Golf Revenue737.47 28,965.00 (28,227.53) -97.5% 180,393.97 253,278.00 (72,884.03) 300,066.00 119,672.03 60%410000 Revenue-Golf Shop301.82 29,376.00 (29,074.18) -99.0% 130,095.98 206,909.00 (76,813.02) 249,256.00 119,160.02 52%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,000.00 11,000.00 - 12,000.00 1,000.00 92%890000 Interest Income- - - 0.0%0.37 - 0.37 - (0.37) 0%Total Income43,159.54 429,250.00 (386,090.46) -89.9% 2,411,275.40 3,263,936.00 (852,660.60) 3,770,456.00 1,359,180.60 64%Cost of Goods Sold510000 COS-Golf Shop180.34 16,443.00 (16,262.66) 98.9% 77,207.48 115,806.00 38,598.52 139,509.00 62,301.52 55%Total COS180.34 16,443.00 (16,262.66) 98.9% 77,207.48 115,806.00 38,598.52 139,509.00 62,301.52 55%Gross Profit42,979.20 412,807.00 (369,827.80) -89.6% 2,334,067.92 3,148,130.00 (814,062.08) 3,630,947.00 1,296,879.08 64%Expenses610000 Golf Pro Shop11,548.09 18,490.00 (6,941.91) 37.5% 158,762.44 168,192.00 (9,429.56) 208,393.00 49,630.56 76%630000 Course Maintenance84,175.23 143,632.00 (59,456.77) 41.4% 1,348,040.42 1,512,028.00 (163,987.58) 1,783,663.00 435,622.58 76%633000 Maintenance Water & Energy9,483.70 21,664.00 (12,180.30) 56.2% 170,822.15 193,133.00 (22,310.85) 249,838.00 79,015.85 68%640000 Outside Services22,585.89 40,662.00 (18,076.11) 44.5% 363,893.39 345,619.00 18,274.39 396,373.00 32,479.61 92%650000 Clubhouse10,638.93 9,901.00 737.93 -7.5% 115,069.32 105,110.00 9,959.32 125,312.00 10,242.68 92%660000 Marketing12,290.07 22,205.00 (9,914.93) 44.7% 168,593.04 191,396.00 (22,802.96) 222,203.00 53,609.96 76%670000 General & Administrative27,391.56 30,219.00 (2,827.44) 9.4% 269,772.12 299,107.00 (29,334.88) 360,401.00 90,628.88 75%680000 Leases27,316.99 26,650.00 666.99 -2.5% 262,477.87 259,950.00 2,527.87 313,250.00 50,772.13 84%690000 Miscellaneous Other Expense15,436.03 13,880.00 1,556.03 -11.2% 165,260.94 150,600.00 14,660.94 178,360.00 13,099.06 93%Total Expenses220,866.49 327,303.00 (106,436.51) 32.5% 3,022,691.69 3,225,135.00 202,443.31 3,837,793.00 815,101.31 79%(177,887.29) 85,504.00 (263,391.29) -308.0%(688,623.77) (77,005.00) (611,618.77) (206,846.00) 481,777.77 0%Rounds of Golf PlayedPaid Rounds Played664 4,896 (4,232) -86.4%28,510 36,609 (8,099) 43,667 15,157 65%Ave $ Per Paid Round Green Fee62.68 75.66 (12.97) -17.1%73.30 76.29 (2.99) 73.49 0.19 100%Ave $ Per Paid Round Merchandise0.45 6.00 (5.55) -92.4%4.56 5.65 (1.09) 5.71 1.14 80%Ave $ Per Paid Miscellaneous 1.11 5.92 (4.81) -81.2%6.33 6.92 (0.59) 6.87 0.54 92%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateApril 20201 Income April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees41,620.25 370,409.00 (328,788.75) 2,089,785.08 2,792,749.00 (702,963.92) 3,209,134.00 1,119,348.92 34.9%4010000 Rider Fee- 540.00 (540.00) 7,035.00 7,068.00 (33.00) 7,807.00 772.00 9.9%4040000 Club Rental- 2,700.00 (2,700.00) 15,985.00 17,388.00 (1,403.00) 21,087.00 5,102.00 24.2%4050000 Driving Range- 8,100.00 (8,100.00) 51,238.00 83,772.00 (32,534.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/Subcontract437.47 1,000.00 (562.53) 2,464.97 2,500.00 (35.03) 2,500.00 35.03 1.4%4091000 Golf Professional Rental Fee- 1,000.00 (1,000.00) 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 Issue300.00 15,625.00 (15,325.00) 96,205.00 134,050.00 (37,845.00) 165,300.00 69,095.00 41.8% Total Revenue Fees42,357.72 399,374.00 (357,016.28) 2,270,179.05 3,046,027.00 (775,847.95) 3,509,200.00 1,239,020.95 35.3%42,357.72 399,374.00 (357,016.28) 2,270,179.05 3,046,027.00 (775,847.95) 3,509,200.00 1,239,020.95 35.3%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetApril 20202 provided for those cost of sales percentage that are greater than 5%.Variance ExplanationApril 2020The 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 areDue to Closure of Golf Course Facilities the variance report is not reported.3-20-133 Income April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous- - - 7,485.54 - 7,485.54 00 0%4100110 Sales Hard Goods297.14 7,344.00 (7,046.86) 56,257.69 51,728.00 4,529.69 62,314.00 6,056.31 9.7%4100112 Sales-Soft Goods34.00 22,032.00 (21,998.00) 87,668.75 155,181.00 (67,512.25) 186,942.00 99,273.25 53.1%5100639 GS-Discounts-Mdse(29.32) - (29.32) (21,316.00) - (21,316.00) - 21,316.00 0.0% Total Revenue Golf Shop301.82 29,376.00 (29,074.18) 130,095.98 206,909.00 (76,813.02) 249,256.00 126,645.56 50.8%COS 5100150 COS-GS-Hard Goods 166.14 4,260.00 (4,093.86) 33,432.88 30,001.00 3,431.88 34,877.15 1,444.27 4.1%5100151 COS-GS-Soft Goods14.20 12,779.00 (12,764.80) 42,502.47 90,005.00 (47,502.53) 104,631.44 62,128.97 59.4%5100152 COS-GS-Purchase Disc- (852.00) 852.00 (467.13) (6,000.00) 5,532.87 (7,228.00) (6,760.87) 93.5%5100220 COS-GS-Freight Merch- 256.00 (256.00) 1,739.26 1,800.00 (60.74) 2,169.00 429.74 19.8%Cost of Sales - Golf Shop180.34 16,443.00 (16,262.66) 77,207.48 115,806.00 (38,598.52) 134,449.59 57,242.11 42.6%Gross Profit121.48 12,933.00 (12,811.52) 52,888.50 91,103.00 (38,214.50) 114,806.41 69,403.45 60.5%COS % 59.8% 56.0% -3.8% 59.3% 56.0% -3.4% 53.1% 45.2% 85.2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group705.18 490.00 215.18 4,161.56 4,900.00 (738.44) 5,880.00 1,718.44 29.2%6101325 Insurance-Workers Comp 401.20 557.00 (155.80) 5,449.89 4,949.00 500.89 6,054.00 604.11 10.0%6101720 Salaries4,911.06 4,400.00 511.06 49,628.51 44,000.00 5,628.51 65,000.00 15,371.49 23.6%6101800 Taxes-Employer Payroll 849.72 1,485.00 (635.28) 12,846.27 13,201.00 (354.73) 16,144.00 3,297.73 20.4%6101880 Wages-Hourly3,414.50 10,448.00 (7,033.50) 76,749.63 88,002.00 (11,252.37) 98,874.00 22,124.37 22.4%6101882 Wages-Overtime5.25 - 5.25 1,053.80 - 1,053.80 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 10,286.91 17,380.00 (7,093.09) 149,889.66 155,052.00 (5,162.34) 191,952.00 44,069.02 23.0%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 1,347.48 - 1,347.48 - (1,347.48) 0.0%6103762 Supplies-Office177.14 250.00 (72.86) 2,831.83 2,500.00 331.83 3,000.00 168.17 5.6%6109220 Freight & Delivery243.23 - 243.23 378.11 75.00 303.11 75.00 (303.11) -404.1%6109490 Miscellaneous391.96 500.00 (108.04) 1,407.19 5,000.00 (3,592.81) 6,000.00 4,592.81 76.5%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short- - - 23.55 - 23.55 - (23.55) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 2,405.00 (2,405.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 60.00 (60.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 1,921.72 2,000.00 (78.28) 2,400.00 478.28 19.9%6117840 Telephones448.85 110.00 338.85 962.90 1,100.00 (137.10) 1,320.00 357.10 27.1%1,261.18 1,110.00 151.18 8,872.78 13,140.00 (4,267.22) 18,875.00 10,002.22 53.0%11,548.09 18,490.00 (6,941.91) 158,762.44 168,192.00 (9,429.56) 210,827.00 54,071.24 25.6%Net Income(11,426.61) (5,557.00) (5,869.61) (105,873.94) (77,089.00) (28,784.94) (96,020.59) 15,332.21 -16.0%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetApril 20204 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group9,560.38 9,810.00 (249.62) 80,777.70 98,100.00 (17,322.30) 117,720.00 36,942.30 31.4%6311325 Insurance-Workers Comp1,386.40 2,612.00 (1,225.60) 22,478.62 23,841.00 (1,362.38) 28,929.00 6,450.38 22.3%6311720 Salaries13,525.27 12,480.00 1,045.27 130,640.11 124,800.00 5,840.11 166,400.00 35,759.89 21.5%6311800 Taxes-Employer Payroll4,509.28 6,967.00 (2,457.72) 55,532.64 64,200.00 (8,667.36) 77,767.00 22,234.36 28.6%6311880 Wages-Hourly26,846.75 57,181.00 (30,334.25) 429,935.28 498,674.00 (68,738.72) 592,769.00 162,833.72 27.5%6311882 Wages-Overtime- -- 41,355.25 18,500.00 22,855.25 18,500.00 (22,855.25) -123.5%Total-CM-SALARIES & BENEFITS55,828.08 89,050.00 (33,221.92) 760,719.60 828,115.00 (67,395.40) 1,002,085.00 241,365.40 24.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,013.23 3,100.00 (86.77) 30,155.05 41,352.00 (11,196.95) 50,060.00 19,904.95 39.8%6313744 Fertilizer- 10,270.00 (10,270.00) 59,989.37 90,540.00 (30,550.63) 104,520.00 44,530.63 42.6%6313745 Herbicides- - - 1,815.13 - 1,815.13 - (1,815.13) 0.0%6313746 Flowers/Plants- 100.00 (100.00) (43.37) 3,050.00 (3,093.37) 3,050.00 3,093.37 101.4%6313748 Fuel-Gasoline- 3,850.00 (3,850.00) 31,868.38 39,430.00 (7,561.62) 46,860.00 14,991.62 32.0%6313750 Golf Course Accessories- 680.00 (680.00) 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 Supp- 100.00 (100.00) 4,629.39 4,150.00 479.39 4,350.00 (279.39) -6.4%6313762 Supplies-Office- -- 1,632.22 - 1,632.22 - (1,632.22) 0.0%6313774 Sand1,333.61 100.00 1,233.61 8,319.73 13,260.00 (4,940.27) 13,460.00 5,140.27 38.2%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,800.00 (1,191.63) 5,000.00 1,391.63 27.8%6313780 Sod- -- 9,606.61 10,800.00 (1,193.39) 15,500.00 5,893.39 38.0%6313782 Topdressing- -- 774.46 7,000.00 (6,225.54) 10,000.00 9,225.54 92.3%Total-CM-SUPPLIES & MATERIALS4,346.84 18,300.00 (13,953.16) 276,057.92 354,822.00 (78,764.08) 393,240.00 117,182.08 29.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint- 3,850.00 (3,850.00) 31,078.19 23,100.00 7,978.19 30,800.00 (278.19) -0.9%6315685 CM-R&M-Bldngs & Othr Structures 185.62 250.00 (64.38) 8,689.49 5,050.00 3,639.49 5,550.00 (3,139.49) -56.6%6315690 CM-R&M-Equipment2,730.65 2,000.00 730.65 36,090.04 33,500.00 2,590.04 38,500.00 2,409.96 6.3%6315692 CM-R&M-Irrigation System3,605.28 1,000.00 2,605.28 21,245.70 17,050.00 4,195.70 19,050.00 (2,195.70) -11.5%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 3,913.90 10,000.00 (6,086.10) 10,500.00 6,586.10 62.7%6315815 CM-R&M-Trees-Pruning Etc-4,000.00 (4,000.00) 5,730.00 12,050.00 (6,320.00) 12,050.00 6,320.00 52.4%Total-CM-REPAIRS & MAINTENANCE6,521.55 12,100.00 (5,578.45) 106,747.32 100,750.00 5,997.32 116,450.00 9,702.68 8.3%6317836 Utilities-Natural Gas/LPG- 15.00 (15.00) 198.33 150.00 48.33 180.00 (18.33) 0.0%6317840 Telephones404.58 850.00(445.42) 7,391.72 8,500.00 (1,108.28) 10,200.00 2,808.28 27.5%Total-CM-UTILITIES404.58 865.00 (460.42) 7,590.05 8,650.00 (1,059.95) 10,380.00 2,789.95 26.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%6319100 Contract Svcs-Soil/Tissue Test- - - 85.00 1,000.00 (915.00) 2,000.00 1,915.00 95.8%6319102 Contract Svcs-Trash Removal27.00 524.00 (497.00) 1,340.44 5,240.00 (3,899.56) 6,288.00 4,947.56 78.7%6319150 Dues & Subscriptions3,100.00 380.00 2,720.00 4,440.00 580.00 3,860.00 680.00 (3,760.00) -552.9%6319170 Employee Education- 50.00 (50.00) - 3,800.00 (3,800.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 200.00 (200.00) - 3,100.00 (3,100.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits2,779.50 2,900.00 (120.50) 4,375.36 4,300.00 75.36 4,300.00 (75.36) -1.8%6319490 Miscellaneous- 100.00 (100.00) 1,476.54 1,000.00 476.54 1,200.00 (276.54) -23.0%6319718 Safety Equipment & Training- 100.00 (100.00) 2,351.69 3,650.00 (1,298.31) 3,850.00 1,498.31 38.9%6319822 Uniforms271.67 920.00(648.33) 10,987.21 9,200.00 1,787.21 11,040.00 52.79 0.5%Total-CM-OTHER EXPENSES6,578.17 5,574.00 1,004.17 29,056.24 35,870.00 (6,813.76) 41,458.00 12,401.76 29.9%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetApril 2020Month to DateYear to Date5 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,973.00 2,450.00 (477.00) 27,969.48 24,500.00 3,469.48 29,400.00 1,430.52 4.9%6321325 Insurance-Workers Comp417.00 484.00 (67.00) 5,265.31 4,971.00 294.31 5,955.00 689.69 11.6%6321800 Taxes-Employer Payroll536.68 1,290.00 (753.32) 9,319.65 13,367.00 (4,047.35) 15,995.00 6,675.35 41.7%6321880 Wages-Hourly7,522.79 12,904.00 (5,381.21) 114,744.73 130,290.00 (15,545.27) 156,528.00 41,783.27 26.7%6321882 Wages-Overtime- - - 6,374.27 3,418.00 2,956.27 3,418.00 (2,956.27) -86.5%Total-CM-LM-SALARIES & BENEFITS10,449.47 17,128.00 (6,678.53) 163,673.44 176,546.00 (12,872.56) 211,296.00 47,622.56 22.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 875.00 (875.00) 1,025.00 1,025.00 100.0%6323788 Uniforms46.54 290.00 (243.46) 2,397.85 2,900.00 (502.15) 3,480.00 1,082.15 31.1%Total-CM-LM-SUPPLIES & MATERIALS46.54 365.00 (318.46) 2,397.85 3,775.00 (1,377.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,500.00 (1,702.00) 4,250.00 2,452.00 57.7%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) 1,798.00 3,500.00 (1,702.00) 4,250.00 2,452.00 57.7%84,175.23 143,632.00 (59,456.77) 1,348,040.42 1,512,028.00 (163,987.58) 1,783,664.00 435,623.58 24.4% April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 4,090.37 6,247.00 (2,156.63) 95,271.03 85,489.00 9,782.03 179,791.00 84,519.97 47.0%6337842 Utilities-Water5,393.33 15,417.00 (10,023.67) 75,551.12 107,644.00 (32,092.88) 70,047.00 (5,504.12) -7.9%9,483.70 21,664.00 (12,180.30) 170,822.15 193,133.00 (22,310.85) 249,838.00 79,015.85 31.6%Silverrock ResortCourse Maintenance Water & EnergyApril 2020Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementApril 2020Silverrock ResortAnnual BudgetMonth to Date Year to Date6 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group1,131.00 304.00 827.00 3,340.23 3,040.00 300.23 3,648.00 307.77 8.4%6411325 Insurance-Workers Comp461.53 848.00 (386.47) 7,562.57 6,458.00 1,104.57 7,482.00 (80.57) -1.1%6411800 Taxes-Employer Payroll1,158.10 2,816.00 (1,657.90) 19,031.32 21,442.00 (2,410.68) 24,841.00 5,809.68 23.4%6411880 Wages-Hourly9,888.75 22,620.00 (12,731.25) 151,530.96 172,224.00 (20,693.04) 199,524.00 47,993.04 24.1%6411882 Wages-Overtime443.66 - 443.66 12,752.92 - 12,752.92 - (12,752.92) 0.0%Total-CBR-SALARIES & BENEFITS13,083.04 26,588.00 (13,504.96) 194,218.00 203,164.00 (8,946.00) 235,495.00 41,277.00 17.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 882.67 50.00 832.67 1,055.08 1,750.00 (694.92) 1,850.00 `0.0%6413742 Supplies-Expendable120.71 150.00 (29.29) 6,605.27 5,750.00 855.27 6,750.00 144.73 2.1%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) - 2,700.00 (2,700.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 425.00 (216.32) 525.00 316.32 60.3%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 92.73 280.00 (187.27) 420.00 327.27 77.9%6413786 Supplies-Towels- 250.00 (250.00) 5,075.89 1,860.00 3,215.89 2,182.00 (2,893.89) -132.6%6413796 Supplies-Bottled Water120.71 1,500.00 (1,379.29) 18,209.34 16,900.00 1,309.34 19,900.00 1,690.66 8.5%Total-CBR-SUPPLIES & MATERIALS1,124.09 2,520.00 (1,395.91) 42,013.24 39,665.00 2,348.24 44,627.00 1,818.84 4.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 952.69 3,000.00 (2,047.31) 3,600.00 2,647.31 73.5%6415695 CBR-R&M-Cart Maintenance & Repair 3,457.20 500.00 2,957.20 28,938.63 5,450.00 23,488.63 6,450.00 (22,488.63) -348.7%Total-CBR-REPAIRS & MAINTENANCE3,457.20 800.00 2,657.20 29,891.32 8,450.00 21,441.32 10,050.00 (19,841.32) -197.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen249.43 800.00 (550.57) 11,893.70 8,000.00 3,893.70 9,600.00 (2,293.70) -23.9%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 3,453.28 6,000.00 (2,546.72) 7,200.00 3,746.72 52.0%6419820 Uniforms- - - 3,449.05 3,500.00 (50.95) 5,200.00 1,750.95 33.7%Total-CBR-OTHER EXPENSES249.43 1,400.00 (1,150.57) 18,796.03 17,950.00 846.03 22,450.00 3,653.97 16.3%TOTAL-CARTS,BAGROOM & RANGE 17,913.76 31,308.00 (1,150.57) 284,918.59 269,229.00 15,689.59 312,622.00 26,908.49 8.6%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp141.60 290.00 (148.40) 4,055.09 2,399.00 1,656.09 2,630.00 (1,425.09) -54.2%6431800 Taxes-Employer Payroll594.78 774.00 (179.22) 7,029.27 6,403.00 626.27 7,013.00 (16.27) -0.2%6431880 Wages-Hourly3,935.75 7,740.00 (3,804.25) 64,170.15 64,013.00 157.15 70,133.00 5,962.85 8.5%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,672.13 8,804.00 (4,131.87) 75,254.51 72,815.00 2,439.51 79,776.00 4,521.49 5.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 367.61 900.00 (532.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 500.00 (441.54) 600.00 541.54 90.3%6439820 Uniforms- 400.00 (400.00) 3,294.22 1,975.00 1,319.22 2,125.00 (1,169.22) -55.0%Total-CS-OTHER EXPENSES- 550.00 (550.00) 3,720.29 3,575.00 145.29 3,975.00 254.71 6.4%Total-COURSE SERVICES4,672.13 9,354.00 (4,681.87) 78,974.80 76,390.00 2,584.80 83,751.00 4,776.20 5.7%22,585.89 40,662.00 (18,076.11) 363,893.39 345,619.00 18,274.39 396,373.00 31,429.98 7.9%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetApril 20207 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%65-CH-UTILITIES6507836 Utilities-Natural Gas461.20 850.00 (388.80) 15,540.58 8,500.00 7,040.58 10,200.00 (5,340.58) -52.4%6507840 Utilities-Telephone2,060.68 1,150.00 910.68 12,807.22 11,500.00 1,307.22 13,800.00 992.78 7.2%6507842 Utilities-Water301.00 321.00 (20.00) 7,708.74 3,210.00 4,498.74 3,852.00 (3,856.74) -100.1%6507844 Utilities-Cable249.99 380.00 (130.01) 3,346.06 3,800.00 (453.94) 4,560.00 1,213.94 26.6%Total-CH-UTILITIES3,072.87 2,701.00 371.87 39,402.60 27,010.00 12,392.60 32,412.00 (6,990.60) -21.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning250.00 400.00 (150.00) 4,885.00 4,000.00 885.00 4,800.00 (85.00) -1.8%6509099 Contract Services-Security4,465.76 5,000.00 (534.24) 54,575.16 50,000.00 4,575.16 60,000.00 5,424.84 9.0%6509215 Flowers & Decorations- - - 713.10 1,500.00 (786.90) 1,900.00 1,186.90 62.5%6509490 Miscellaneous200.00 200.00 - 1,990.74 6,600.00 (4,609.26) 7,000.00 5,009.26 71.6%6509718 Safety Equipment & Training555.71 100.00 455.71 1,168.02 1,000.00 168.02 1,200.00 31.98 2.7%Total-CH-OTHER EXPENSES5,471.47 5,700.00 (228.53) 63,332.02 63,100.00 232.02 74,900.00 11,567.98 15.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures83.50 300.00 (216.50) 3,202.92 3,000.00 202.92 3,600.00 397.08 11.0%6515686 CH-R&M-Restaurant Repairs 1,290.00 400.00 890.00 1,740.00 4,000.00 (2,260.00) 4,800.00 3,060.00 63.8%6515690 CH-R&M-Equipment Repair321.09 400.00 (78.91) 3,391.78 4,000.00 (608.22) 4,800.00 1,408.22 29.3%Total-CH-REPAIRS & MAINTENANCE1,694.59 1,100.00 594.59 8,334.70 11,000.00 (2,665.30) 13,200.00 4,865.30 36.9%10,638.93 9,901.00 737.93 115,069.32 105,110.00 9,959.32 125,312.00 9,730.60 7.8%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetApril 20208 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 515.46 348.00 167.46 4,092.94 3,480.00 612.94 4,176.00 83.06 2.0%6601325 Insurance-Workers Comp87.20 94.00 (6.80) 980.50 940.00 40.50 1,129.00 148.50 13.2%6601720 Salaries3,622.50 2,508.00 1,114.50 25,736.91 25,080.00 656.91 30,096.00 4,359.09 14.5%6601800 Taxes-Employer Payroll365.10 251.00 114.10 2,677.40 2,510.00 167.40 3,010.00 332.60 11.0%Total-MKT-SALARIES & BENEFITS4,590.26 3,201.00 1,389.26 33,487.75 32,010.00 1,477.75 38,411.00 4,923.25 12.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office- 100.00 (100.00) 584.26 1,000.00 (415.74) 1,200.00 615.74 51.3%6603768 Supplies-Printing & Stationery221.82 125.00 96.82 5,005.73 4,175.00 830.73 4,425.00 (580.73) -13.1%221.82 225.00 (3.18) 5,589.99 5,175.00 414.99 5,625.00 35.01 0.6%66-MKT-UTILITIES6607840 Utilities-Telephone 241.20 100.00 141.20 1,583.67 1,000.00 583.67 1,200.00 (383.67) -32.0%Total-MKT-UTILITIES241.20 100.00 141.20 1,583.67 1,000.00 583.67 1,200.00 (383.67) -32.0%66-MKT-OTHER EXPENSES6609010 Advertising 6,587.79 17,729.00 (11,141.21) 114,006.28 142,126.00 (28,119.72) 163,133.00 49,126.72 30.1%6609040 Business Meals- 25.00 (25.00) - 250.00 (250.00) 300.00 300.00 100.0%6609080 Collateral Material- 500.00 (500.00) 6,214.98 3,500.00 2,714.98 5,500.00 (714.98) -13.0%6609102 Contract Services-Web Page649.00 150.00 499.00 5,236.00 1,500.00 3,736.00 1,800.00 (3,436.00) -190.9%6609490 Miscellaneous- 50.00 (50.00) - 300.00 (300.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) 117.61 500.00 (382.39) 600.00 482.39 80.4%6609630 Promotion- 50.00 (50.00) - 600.00 (600.00) 700.00 700.00 100.0%6609633 Promotion-Community- 75.00 (75.00) 1,050.18 2,100.00 (1,049.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- 50.00 (50.00) 400.80 600.00 (199.20) 600.00 199.20 33.2%Total-MKT-OTHER EXPENSES7,236.79 18,679.00 (11,442.21) 127,931.63 153,211.00 (25,279.37) 176,968.00 49,036.37 27.7%12,290.07 22,205.00 (9,914.93) 168,593.04 191,396.00 (22,802.96) 222,204.00 53,610.96 24.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetApril 20209 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group3,112.43 2,180.00 932.43 25,742.69 21,800.00 3,942.69 26,160.00 417.31 1.6%6701325 Insurance-Workers Comp581.01 761.00 (179.99) 4,954.13 7,356.00 (2,401.87) 8,881.00 3,926.87 44.2%6701720 Salaries16,012.67 17,012.00 (999.33) 143,281.38 162,641.00 (19,359.62) 197,432.00 54,150.62 27.4%6701800 Taxes-Employer Payroll1,623.63 2,030.00 (406.37) 14,443.52 19,620.00 (5,176.48) 23,684.00 9,240.48 39.0%6701880 Wages-Hourly1,540.00 3,291.00 (1,751.00) 23,599.04 33,590.00 (9,990.96) 39,404.00 15,804.96 40.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS22,869.74 25,274.00 (2,404.26) 212,020.76 245,007.00 (32,986.24) 295,561.00 83,540.24 28.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer324.94 500.00 (175.06) 2,017.73 5,000.00 (2,982.27) 6,300.00 4,282.27 68.0%6703762 Supplies-Office58.41 105.00 (46.59) 1,677.28 1,050.00 627.28 1,260.00 (417.28) -33.1%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 1,323.27 2,500.00 (1,176.73) 3,300.00 1,976.73 59.9%Total-G&A-SUPPLIES & MATERIALS383.35 1,005.00 (621.65) 5,018.28 8,550.00 (3,531.72) 10,860.00 5,841.72 53.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 43.83 1,700.00 (1,656.17) 1,900.00 1,856.17 97.7%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 43.83 1,700.00 (1,656.17) 1,900.00 1,856.17 97.7%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 16.7%6709150 Dues & Subscriptions- 50.00 (50.00) 899.41 800.00 99.41 1,150.00 250.59 21.8%6709180 Employee Recruiting/Relocation60.00 - 60.00 1,122.27 1,200.00 (77.73) 1,200.00 77.73 6.5%6709197 Equipment Rental898.43 550.00 348.43 6,335.55 5,500.00 835.55 6,600.00 264.45 4.0%6709202 Fees-Bank- 90.00 (90.00) 961.77 900.00 61.77 1,080.00 118.23 10.9%6709208 Fees-Payroll Processing111.60 1,000.00 (888.40) 4,651.53 10,000.00 (5,348.47) 12,000.00 7,348.47 61.2%6709220 Freight/Delivery- 50.00 (50.00) - 500.00 (500.00) 600.00 600.00 100.0%6709490 Miscellaneous51.47 100.00 (48.53) 4,717.26 6,400.00 (1,682.74) 6,600.00 1,882.74 28.5%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 979.68 750.00 229.68 900.00 (79.68) -8.9%6709625 Professional Fees2,516.97 850.00 1,666.97 26,119.82 8,500.00 17,619.82 10,200.00 (15,919.82) -156.1%6709636 Promotion/Entertainment- 100.00 (100.00) - 1,000.00 (1,000.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 1,499.83 2,000.00 (500.17) 2,400.00 900.17 37.5%6709810 Travel- 200.00 (200.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 (75.00) 402.13 900.00 (497.87) 1,050.00 647.87 61.7%Total-G&A-OTHER EXPENSES4,138.47 3,840.00 298.47 52,689.25 43,850.00 8,839.25 52,080.00 (609.25) -1.2%27,391.56 30,219.00 (2,827.44) 269,772.12 299,107.00 (29,334.88) 360,401.00 90,628.88 25.1%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetApril 202010 April 2020Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.Expense68-LEASES6800192 Equipment Leases-Carts10,636.93 12,000.00 (1,363.07) 101,523.34 112,650.00 (11,126.66) 136,650.00 35,126.66 6800193 Equipment Leases-Maintenance 12,107.49 9,500.00 2,607.49 103,314.96 95,000.00 8,314.96 114,000.00 10,685.04 6800194 Equipment Leases-Trailer- 300.00 (300.00) 4,077.22 3,000.00 1,077.22 3,600.00 (477.22) 6800196 Equipment Leases-GPS2,380.00 2,900.00 (520.00) 33,520.00 33,000.00 520.00 38,800.00 5,280.00 6800197 Equipment Leases-Others2,192.57 1,950.00 242.57 20,042.35 16,300.00 3,742.35 20,200.00 157.65 27,316.99 26,650.00 666.99 262,477.87 259,950.00 2,527.87 313,250.00 50,772.13 69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,880.00 9,880.00 - 98,800.00 98,800.00 - 118,560.00 19,760.00 6900800 Personal Property Taxes- - - 13,171.65 11,800.00 1,371.65 11,800.00 (1,371.65) 6900323 Insurance-Commercial5,556.03 4,000.00 1,556.03 53,289.29 40,000.00 13,289.29 48,000.00 (5,289.29) 15,436.03 13,880.00 1,556.03 165,260.94 150,600.00 14,660.94 178,360.00 13,099.06 Total-LEASESTotal-MISC OTHER EXPENSESOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to DateYear to DateApril 202011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2019-20202019 2019 2019 2019 2019 2019Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4SalesPromotion10Golf IndustryVIPCelebrityPGA Comp4 5 4 3622Charity/Gift Certificate441817Rain/Wind Checks125Club Staff13 22 35427 50LQ HS Golf5522 36 45841 1092020 2020 2020 2020 2020 2020Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia8SalesPromotionGolf IndustryVIPCelebrityPGA Comp13 13 7Charity/Gift Certificate27 6 9Rain/Wind Checks2 10Club Staff56 32 12 7LQ HS Golf12 41 16116 94 5470012