Laserfiche WebLink
Month Selection <br />January <br />0 <br />TRUE <br />February <br />❑' <br />TRUE <br />March <br />❑ <br />TRUE <br />April <br />0 <br />TRUE <br />May <br />0 <br />TRUE <br />June <br />0 <br />TRUE <br />July <br />❑ <br />FALSE <br />August <br />❑ <br />FALSE <br />September <br />❑ <br />FALSE <br />October <br />❑ <br />FALSE <br />November <br />❑ <br />FALSE <br />December <br />❑ <br />FALSE <br />ALL <br />N/A <br />N/A <br />*Annual pass revenue is copied directly from monthly <br />municipal reports <br />Cost to produce a round? <br />$ 43.38 <br />Course Maintenance YTD <br />$ 259,632 <br />Golf Ops Salaries Sum YTD <br />$ 300,612 <br />18 Hole Rds Played YTD <br />12915 <br />Calculations - SEE MONTH <br />SELECTION <br />2020 MASTER <br />Monthly SUM <br />Monthly SUM <br />DASHBOARD <br />Actual <br />Budget <br />Playable Days <br />109 <br />127 <br />Total Rounds <br />12915 <br />12179 <br />Revenue <br />Daily Rental <br />$ <br />3,071 <br />$ <br />4,044 <br />Green Fees <br />$ <br />452,722 <br />$ <br />390,648 <br />Golf Cart Fees <br />$ <br />69,659 <br />$ <br />93,381 <br />Golf Club Repair <br />$ <br />2,787 <br />$ <br />6,681 <br />Golf Lessons <br />$ <br />35,725 <br />$ <br />41,501 <br />Handicap fees <br />$ <br />5,045 <br />$ <br />7,914 <br />Pro Shop retail sales <br />$ <br />33,774 <br />$ <br />52,679 <br />Range Fees <br />$ <br />34,254 <br />$ <br />60,468 <br />*Annual pass revenue <br />$ <br />93,510 <br />$ <br />99,421 <br />Sweet Spot lease F&B sales <br />$ <br />5,000 <br />$ <br />2,916 <br />Sweet Spot utilities <br />$ <br />- <br />$ <br />- <br />Insurance Recovery <br />$ <br />$ <br />4th of July Reimbursement <br />$ <br />$ <br />- <br />Interest earnings <br />$ <br />616 <br />$ <br />1,395 <br />Miscelaneous <br />$ <br />- <br />$ <br />44 <br />Total revenue <br />$ <br />736,163 <br />$ <br />761,093 <br />Total revenue per round <br />$ <br />$ <br />57.00 <br />6,753.79 <br />$ <br />$ <br />62.49 <br />5,992.86 <br />Reveunue per playable day <br />Expenditures <br />YTD Actual <br />YTD Budget <br />Course maintenance <br />$ <br />259,632 <br />$ <br />299,941 <br />Golf Operations <br />$ <br />300,612 <br />$ <br />317,448 <br />Clubhouse <br />$ <br />42,370 <br />$ <br />37,424 <br />Marketing/General <br />$ <br />61,891 <br />$ <br />92,367 <br />Total expenditures <br />$ <br />664,506 <br />$ <br />747,180 <br />$ <br />51.45 <br />$ <br />61.35 <br />Expenese per round <br />NET INCOME (Rev - Exp) <br />$ <br />71,657 <br />$ <br />13,913 <br />$ 5.55 <br />1 $ <br />1.14 <br />golf course maintenance + golf ops labor/18 hole equiviant <br />Q1 <br />Q2 <br />Q3 <br />Q4 <br />Annual <br />Actual <br />Budget <br />Actual <br />Budget <br />Actual <br />Budget <br />Actual <br />Budget <br />Actual <br />Budget <br />42 <br />48 <br />67 <br />79 <br />0 <br />89 <br />0 <br />59 <br />109 <br />275 <br />1896 <br />2371 <br />11019 <br />9808 <br />0 <br />12311 <br />0 <br />3571 <br />12915 <br />28061 <br />$ <br />481 <br />$ <br />541 <br />$ <br />2,590 <br />$ <br />3,504 <br />$ <br />$ <br />6,340 <br />$ <br />- <br />$ <br />1,466 <br />$ <br />3,071 <br />$ <br />11,850 <br />$ <br />48,953 <br />$ <br />52,350 <br />$ <br />403,769 <br />$ <br />338,297 <br />$ <br />$ <br />413,284 <br />$ <br />- <br />$ <br />112,768 <br />$ <br />452,722 <br />$ <br />916,700 <br />$ <br />8,784 <br />$ <br />9,848 <br />$ <br />60,875 <br />$ <br />83,533 <br />$ <br />$ <br />111,573 <br />$ <br />- <br />$ <br />26,796 <br />$ <br />69,659 <br />$ <br />231,750 <br />$ <br />829 <br />$ <br />2,654 <br />$ <br />1,959 <br />$ <br />4,027 <br />$ <br />$ <br />2,434 <br />$ <br />- <br />$ <br />1,445 <br />$ <br />2,787 <br />$ <br />10,560 <br />$ <br />3,740 <br />$ <br />4,192 <br />$ <br />31,985 <br />$ <br />37,309 <br />$ <br />$ <br />21,967 <br />$ <br />- <br />$ <br />6,712 <br />$ <br />35,725 <br />$ <br />70,180 <br />$ <br />2,885 <br />$ <br />1,847 <br />$ <br />2,160 <br />$ <br />6,067 <br />$ <br />$ <br />776 <br />$ <br />- <br />$ <br />- <br />$ <br />5,045 <br />$ <br />8,690 <br />$ <br />10,133 <br />$ <br />10,188 <br />$ <br />23,641 <br />$ <br />42,491 <br />$ <br />$ <br />40,257 <br />$ <br />- <br />$ <br />16,245 <br />$ <br />33,774 <br />$ <br />109,180 <br />$ <br />9,547 <br />$ <br />11,620 <br />$ <br />24,707 <br />$ <br />48,848 <br />$ <br />$ <br />45,601 <br />$ <br />- <br />$ <br />12,380 <br />$ <br />34,254 <br />$ <br />118,450 <br />$ <br />20,602 <br />$ <br />49,873 <br />$ <br />72,908 <br />$ <br />49,548 <br />$ <br />$ <br />7,585 <br />$ <br />- <br />$ <br />76,333 <br />$ <br />93,510 <br />$ <br />183,340 <br />$ <br />- <br />$ <br />107 <br />$ <br />5,000 <br />$ <br />2,809 <br />$ <br />$ <br />20,361 <br />$ <br />- <br />$ <br />6,723 <br />$ <br />5,000 <br />$ <br />30,000 <br />$ <br />- <br />$ <br />- <br />$ <br />$ <br />- <br />$ <br />$ <br />8,000 <br />$ <br />- <br />$ <br />- <br />$ <br />- <br />$ <br />8,000 <br />$ <br />616 <br />$ <br />902 <br />$ <br />$ <br />493 <br />$ <br />$ <br />647 <br />$ <br />- <br />$ <br />1,435 <br />$ <br />616 <br />$ <br />3,477 <br />$ <br />- <br />$ <br />35 <br />$ <br />$ <br />10 <br />$ <br />$ <br />95 <br />$ <br />- <br />$ <br />171 <br />$ <br />- <br />$ <br />310 <br />$ <br />106,570 <br />$ <br />144,158 <br />$ <br />629,592 <br />$ <br />616,936 <br />$ <br />- <br />$ <br />678,920 <br />$ <br />- <br />$ <br />262,474 <br />$ <br />736,163 <br />$ <br />1,702,487 <br />$ <br />56.21 <br />$ <br />60.80 <br />$ <br />57.14 <br />$ <br />62.90 <br />#DIV/01 <br />$ <br />55.15 <br />#DIV/01 <br />$ <br />73.50 <br />#DIV/01 <br />$ <br />252.35 <br />$ <br />2,537.39 <br />$ <br />3,003.28 <br />$ <br />9,396.90 <br />$ <br />7,809.31 <br />#DIV/0! <br />$ <br />7,628.31 <br />#DIV/0! <br />$ <br />73.50 <br />#DIV/0! <br />$ <br />18,514.41 <br />Quarter <br />Actual <br />Quarter Budget <br />Quarter Actual <br />Quarter <br />Budget <br />Quarter Actual <br />Quarter Budget <br />Quarter Actual <br />Quarter <br />Budget <br />Annual Actual <br />Annual Budget <br />$ <br />102,475 <br />$ <br />100,822 <br />$ <br />157,157 <br />$ <br />199,119 <br />$ <br />$ <br />241,074 <br />$ <br />- <br />$ <br />234,336 <br />$ <br />259,632 <br />$ <br />775,350 <br />$ <br />106,785 <br />$ <br />76,755 <br />$ <br />193,827 <br />$ <br />240,693 <br />$ <br />$ <br />236,256 <br />$ <br />- <br />$ <br />121,086 <br />$ <br />300,612 <br />$ <br />674,789 <br />$ <br />17,479 <br />$ <br />16,196 <br />$ <br />24,892 <br />$ <br />21,228 <br />$ <br />$ <br />28,579 <br />$ <br />- <br />$ <br />27,537 <br />$ <br />42,370 <br />$ <br />93,540 <br />$ <br />27,353 <br />$ <br />44,411 <br />$ <br />34,538 <br />$ <br />47,957 <br />$ <br />$ <br />43,815 <br />$ <br />- <br />$ <br />41,286 <br />$ <br />61,891 <br />$ <br />177,469 <br />0 <br />0 <br />$ <br />254,092 <br />$ <br />238,184 <br />$ <br />410,414 <br />$ <br />508,996 <br />$ <br />- <br />$ <br />549,724 <br />$ <br />- <br />$ <br />424,245 <br />$ <br />664,506 <br />$ <br />1,721,149 <br />$ <br />134.01 <br />$ <br />100.46 <br />$ <br />37.25 <br />$ <br />51.90 <br />#DIV/O! <br />$ <br />44.65 <br />#DIV/O! <br />$ <br />118.80 <br />#DIV/011 <br />$ <br />315.81 <br />0 <br />0 <br />$ <br />(147,521) <br />$ <br />(94,026) <br />$ <br />219,178 <br />$ <br />107,939 <br />$ <br />- <br />$ <br />129,196 <br />$ <br />- <br />$ <br />(161,771) <br />$ <br />71,657 <br />$ <br />(18,662) <br />0 <br />0 <br />$ <br />(77.81) <br />$ <br />(39.66)1 <br />$ <br />19.89 <br />$ <br />11.01 <br />#DIV/01 <br />$ <br />10.49 <br />1 <br />#DIV/O! <br />$ <br />(45.30) <br />#DIV/01 <br />$ <br />(63.46) <br />