version 3 page 1 - hggcc.comhggcc.com/hgrd/files/financials/budget.pdf · version 3 page 1 version...

Version Date 08/01-2017

HERONS GLEN RECREATION DISTRICT 2017-2018 BUDGET

FINAL Budget Prior Year ACTUALS Yr End PROJECTIONS Increase (Decrease)

O&M Cost Centers: 2016-2017 BUDGET 2015-2016 2015-2016 2016-2017 2017-2018 BUDGET over 16-17 budget % change

Administration ($725,474.51) ($664,239.41) ($632,368.36) ($660,651.95) ($734,813.38) $9,338.87 1.3%

Restaurant ($320,411.33) ($330,272.00) ($262,968.76) ($354,713.86) ($340,278.29) $19,866.96 6.2%

Clubhouse ($625,119.11) ($621,942.36) ($618,780.14) ($600,351.51) ($681,328.40) $56,209.29 9.0%

Fitness Center ($36,529.49) ($34,600.32) ($48,463.50) ($36,600.83) ($26,986.05) ($9,543.44) -26.1%

TOTAL (1285 homes assessed): ($1,707,534.44) ($1,651,054.09) ($1,562,580.76) ($1,652,318.15) ($1,783,406.12) $75,871.68

CLIS (1284 homes assessed) ($196,270.14) ($193,255.12) ($166,508.43) ($183,439.65) ($184,724.65) ($11,545.49) -5.9%

Annual O&M Assessment: $1,482.04 $1,531.73 $49.69 3.4%

Pro Shop $1,332,923.27 $1,376,033.47 $1,350,582.83 $1,380,595.26 $1,337,280.05 $4,356.78 0.3%

Golf Course Maint ($1,329,518.41) ($1,375,708.50) ($1,333,335.19) ($1,334,100.92) ($1,337,257.05) $7,738.64 0.6%

NET GOLF OPERATIONS: $3,404.86 $23.00 ($3,381.86)

FINAL Quarterly Annual

2016-2017 BUDGET 2017-2018 BUDGET 2017-2018 BUDGET 2016-17 2017-18

Golf Members Golf Members Increase (Decrease)

O&M (1285 homes) $317.25 $347.00 $1,388.00 Household $3,917 $3,987 1.8%

Irrigation (1284 homes) $38.50 $36.00 $144.00 Single $2,352 $2,395 1.8%

Capital Replacement Reserve (1285 homes)* $66.00 $66.00 $264.00

Deferred Maint Reserve(1285 homes)* $36.00 $40.00 $160.00 2016-17 2017-18

Taylor Morrison Land Acquisition Cost $3.75 $0.00 $0.00

Total O&M, Cap, & Def: $461.50 $489.00 $1,956.00 5.9% Tennis Association Tennis Association

$12,000 $12,000

* Capital Replacement and Deferred Maint Reserve quarterly amounts were figured from a 10-yr average of annual needs according to the Long Range Plan

FEES

Version 3 Version Date 7-18-2017

Version Date 7-7-2017

Total

Year Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug SepI N C O M E

4110 ASSESSMENTS, BASE 1285 U

Prior Yr Actual 1844309 157133 157704 157044 127622 118591 120810 147665 161412 169794 164569 166715 195250

Current Budget 1903805 138658 188553 158373 126940 130909 120064 147630 168140 176467 167783 176183 204106

This Yr Projctd 1903843 138658 188553 158373 126940 130909 120065 147671 168139 176467 167782 176182 204106

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

4210 MEMBERSHIP FEES

Prior Yr Actual 1299053 104882 106149 107022 108186 108285 108661 108841 109018 109502 109502 109502 109502

Current Budget 1280817 100172 102784 106376 107943 107943 107943 107943 107943 107943 107943 107943 107943

This Yr Projctd 1289590 104193 105657 106287 108393 108710 108710 107926 107943 107943 107943 107943 107943

Next Yr Budget 1268786 -1% 99051 101711 105366 106962 106962 106962 106962 106962 106962 106962 106962 106962

4230 ANNUAL RANGE MEMBERSHIP

Prior Yr Actual 6124 342 433 458 541 541 544 544 544 544 544 544 544

Current Budget 6876 573 573 573 573 573 573 573 573 573 573 573 573

This Yr Projctd 6975 444 419 501 685 687 687 687 573 573 573 573 573

Next Yr Budget 7545 10% 444 419 501 685 687 687 687 687 687 687 687 687

4231 MEMBER GUEST FEES

Prior Yr Actual 102064 5305 6475 8255 12200 26823 26445 10070 2040 1375 1300 950 825

Current Budget 120423 5265 6422 8342 22440 26792 28017 10020 2625 2625 2625 2625 2625

This Yr Projctd 118548 3560 8153 12581 15888 31043 23143 11055 2625 2625 2625 2625 2625

Next Yr Budget 120207 0% 6302 7558 10128 22483 26792 27955 10152 3166 1525 1697 1225 1225

4260 PUBLIC PLAY FEES

Prior Yr Actual 121004 3115 5420 5795 11952 29760 24002 6571 9168 6679 8378 4827 5339

Current Budget 116270 5375 6930 5700 14750 29640 22232 6518 7125 4500 4500 4500 4500

This Yr Projctd 141993 6817 9800 7220 19811 36352 29738 7131 7125 4500 4500 4500 4500

Next Yr Budget 142249 22% 6850 9500 6460 18220 35352 27738 6824 7705 6600 7200 4500 5300

4270 RESIDENT NON-MEMBER FEES

Prior Yr Actual 124033 5274 9571 12264 18568 17893 25125 17507 5372 2575 4122 1611 4151

Current Budget 133490 5320 9936 12665 21250 20405 27143 19765 4950 3014 3014 3014 3014

This Yr Projctd 143494 7261 10442 12670 21425 27324 32325 15042 4950 3014 3014 3014 3014

Next Yr Budget 144042 8% 6291 10189 12668 21338 26026 31509 17902 5849 2901 3415 1971 3983

4280 RANGE FEES

Prior Yr Actual 5530 119 349 640 977 1175 931 634 198 86 191 112 119

10 - Herons Glen Recreation District

FY 2017-18 Forecast

Budget Worksheet - Design A

Actuals reported up to April/2017 with projected budget 16-17 FC

Company Statement: Income Statement

Version 3


Total

Year Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep


Current Budget 5823 119 349 640 977 1175 931 634 250 200 150 200 200

This Yr Projctd 5716 363 323 554 686 992 1111 687 250 200 150 200 200

Next Yr Budget 5659 -3% 363 369 546 875 1144 1111 641 109 100 150 100 150

4310 PRO SHOP, MDSE

Prior Yr Actual 105883 5415 7777 8188 7995 15990 16738 20060 5571 3291 4965 3653 6240

Current Budget 105913 5415 7777 8188 11995 15990 16738 17060 6150 4150 4150 4150 4150

This Yr Projctd 136537 7661 13538 16174 14370 20108 17925 24010 6150 4150 4150 4150 4150

Next Yr Budget 138433 31% 7661 13538 16174 14370 20108 17925 24010 6498 3291 4965 3653 6240

4315 PRO SHOP, LESSONS - GOLF PRO

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 0 0 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 2500 #DIV/0! 208 208 208 208 208 208 208 208 208 208 208 208

4320

PRO SHOP, LESSONS - ASST.

GOLF PRO

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 430 0 0 0 0 0 300 130 0 0 0 0 0


4325 PRO SHOP, GRIPS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 1053 0 0 0 0 0 317 736 0 0 0 0 0


4370 PRO SHOP, FOOD & BEVERAG

Prior Yr Actual 2954 -207 90 184 115 568 531 276 447 178 324 190 258

Current Budget 3000 250 400 345 300 400 330 325 150 125 125 125 125

This Yr Projctd 3297 288 385 241 327 488 662 256 150 125 125 125 125

Next Yr Budget 3566 19% 222 292 204 274 462 596 266 288 178 324 190 270

4380 PRO SHOP, CLUB RENTAL

Prior Yr Actual 669 0 0 60 0 192 184 45 45 0 83 45 15

Current Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100

This Yr Projctd 680 0 15 30 25 45 65 0 100 100 100 100 100

Next Yr Budget 600 -50% 25 25 25 100 100 100 100 25 25 25 25 25

4410 FOOD SALES-DINING ROOM

Prior Yr Actual 355379 21165 40353 37369 46968 54152 60662 40696 18907 8567 9340 7434 9766

Current Budget 384613 21589 41160 38117 47908 55236 61875 41510 19879 15634 14012 14304 13390

Version 3


Total



This Yr Projctd 357312 14928 39188 35174 37288 51458 61171 50347 17443 13719 12295 12552 11749

Next Yr Budget 367459 -4% 15476 40222 36127 38284 52737 62645 51604 18042 14243 12791 13053 12234

4430 BEVERAGE SALES-DINING RO

Prior Yr Actual 90245 5317 8941 9079 13389 15169 15620 10976 3625 2226 2034 1567 2303

Current Budget 92660 5423 9120 9260 13657 15472 15932 11195 3689 2298 2375 1990 2247

This Yr Projctd 86025 6764 8684 9955 9675 13932 15078 9695 3584 2233 2308 1934 2183

Next Yr Budget 88606 -4% 6967 8945 10254 9965 14350 15531 9986 3692 2300 2377 1992 2249

4433 FOOD REVENUE-LOUNGE

Prior Yr Actual 319153 28494 30086 25166 34072 37210 41151 32186 19889 18614 20635 11575 20076

Current Budget 318809 29161 27696 27016 37418 36841 38880 32441 25375 15424 14429 16935 17193

This Yr Projctd 309544 26974 25510 25840 33530 36835 44017 30006 24659 14989 14022 16457 16708

Next Yr Budget 321231 1% 27983 26475 26815 34736 38140 45537 31106 25598 15638 14642 17151 17409

4434 BEVERAGE REVENUE-LOUNGE

Prior Yr Actual 195661 18541 14789 14039 19792 22566 26304 21384 11885 13467 12091 8468 12334

Current Budget 185118 18541 14789 14039 19792 22566 26304 21384 12145 8771 7548 10494 8745

This Yr Projctd 188229 17851 16645 15625 20142 21903 26274 20587 12526 9046 7785 10824 9020

Next Yr Budget 193876 5% 18387 17144 16094 20746 22560 27063 21205 12902 9318 8019 11148 9290

4550 CATERING FOOD-RESIDENTS

Prior Yr Actual 161378 1447 18235 15545 22672 25701 32684 24018 4158 300 4979 2708 8930

Current Budget 142230 3306 18840 23342 18594 16622 33738 13883 4421 1609 3896 470 3509

This Yr Projctd 141996 2482 17482 15595 18976 26748 26650 20700 4249 1546 3744 452 3372

Next Yr Budget 146256 3% 2556 18006 16063 19545 27550 27450 21321 4376 1593 3857 465 3474

4552 CATERING BEVERAGES- RESI

Prior Yr Actual 35137 2281 3938 5000 3574 4164 6940 5288 1345 41 1071 1415 81

Current Budget 34563 2153 3761 6964 3393 4969 7476 3469 953 0 300 0 1125

This Yr Projctd 34306 1713 4184 6106 4205 6643 5180 3876 962 0 303 0 1135

Next Yr Budget 35335 2% 1764 4309 6289 4331 6843 5336 3992 990 0 312 0 1169

4570 CATERING FOOD - OUTSIDE

Prior Yr Actual 50515 2883 1130 2361 2577 11073 1509 1323 8749 17992 0 271 646

Current Budget 40470 10000 2770 2770 2770 2770 2770 2770 2770 2770 2770 2770 2770

This Yr Projctd 38133 9799 503 7002 6356 5574 1717 1781 1600 3000 800 0 0

Next Yr Budget 40473 0% 5010 5010 5010 2827 2827 2827 2827 2827 2827 2827 2827 2827

4572 CATERING BEVERAGE- OUTSI

Prior Yr Actual 12697 811 254 457 432 3076 304 183 570 6610 0 0 0

Current Budget 10750 2500 750 750 750 750 750 750 750 750 750 750 750

This Yr Projctd 12211 5649 10 1989 1953 328 155 778 500 750 100 0 0

Next Yr Budget 13776 28% 1672 1672 1672 1672 1672 1672 624 624 624 624 624 624

4579 CATERING, OTHER REVENUES

Version 3


Total



Prior Yr Actual 9591 0 100 0 194 2712 385 175 2356 3668 0 0 0

Current Budget 11000 3000 1000 1000 1000 1000 1000 500 500 500 500 500 500

This Yr Projctd 8008 3582 100 472 1681 244 179 100 900 750 0 0 0

Next Yr Budget 8100 1000 1000 1000 1000 1000 1000 350 350 350 350 350 350

4910 LEASE, RETAIL

Prior Yr Actual 1200 100 100 100 100 100 100 100 100 100 100 100 100

Current Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100

This Yr Projctd 1200 100 100 100 100 100 100 100 100 100 100 100 100

Next Yr Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100

4917 CLIS INCOME

Prior Yr Actual 163011 17818 14260 13415 13440 12931 12912 13134 12930 12642 12600 14333 12597

Current Budget 164359 19897 14173 13390 13027 12562 12941 13068 13156 13177 13213 12921 12836

This Yr Projctd 164360 19897 14173 13390 13027 12562 12941 13068 13156 13177 13213 12921 12836

Next Yr Budget 169290 3% 20494 14598 13792 13418 12938 13329 13460 13550 13572 13610 13309 13221

4920 CONCERT SERIES REVENUE

Prior Yr Actual 59335 10 3060 -20 22592 33278 0 0 0 0 0 0 415

Current Budget 65475 0 2500 0 26690 36285 0 0 0 0 0 0 0

This Yr Projctd 62932 0 2330 -20 24639 35973 0 10 0 0 0 0 0

Next Yr Budget 63045 -4% 0 0 0 26718 24218 12109 0 0 0 0 0 0

4945 HOA ACCOUNTING INCOME

Prior Yr Actual 7596 633 633 633 633 633 633 633 633 633 633 633 633

Current Budget 7596 633 633 633 633 633 633 633 633 633 633 633 633

This Yr Projctd 9852 633 633 633 633 633 633 633 633 633 1833 1161 1161

Next Yr Budget 15408 103% 1284 1284 1284 1284 1284 1284 1284 1284 1284 1284 1284 1284

4986 INTEREST INCOME

Prior Yr Actual 882 37 58 67 66 68 82 77 87 83 85 88 83

Current Budget 607 37 58 67 66 68 82 77 30 30 30 30 30

This Yr Projctd 888 100 89 94 91 80 109 174 30 30 30 30 30

Next Yr Budget 2100 246% 175 175 175 175 175 175 175 175 175 175 175 175

4988 LATE FEE/MEMBER INTEREST

Prior Yr Actual 8777 1614 460 873 862 416 716 1234 180 1122 660 368 272

Current Budget 9325 1614 460 873 862 416 716 1234 700 400 1350 350 350

This Yr Projctd 6374 125 563 374 833 611 271 947 700 400 850 350 350

Next Yr Budget 6374 -32% 125 563 374 833 611 271 947 700 400 850 350 350

4990 MISCELLANEOUS OTHER INCO

Prior Yr Actual 45440 15499 896 2472 3468 1449 2854 4054 2398 3438 14801 -9921 4031

Current Budget 53542 15811 1786 3247 4619 2189 3629 5185 3275 3275 3975 3275 3275

This Yr Projctd 95668 18201 2001 2415 17101 7433 7349 12093 5675 5675 6375 5675 5675

Version 3


Total



Next Yr Budget 54453 2% 16866 3379 2647 4353 3699 3287 5407 2800 2800 3200 2800 3215

TOTAL INCOME ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Prior Year Actual 5127618 398028 431261 426466 472988 544516 526828 467671 381629 383527 373006 327186 394511

Current Budget 5199932 395011 463421 442870 498546 542405 530897 458766 386381 365067 356844 364935 394789

This Yr Projected 5269193 398042 469478 449375 498778 577714 536873 480226 384722 365744 354720 361866 391655

Next Year Budget 3375068 -35% 248553 288267 291352 367176 430021 435882 333614 220484 188475 191425 185923 193896

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Cost of Revenues

5280 COS, PRO SHOP GRIPS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 98 0 0 0 0 0 98 0 0 0 0 0 0


5310 COS, PRO SHOP, MDSE

Prior Yr Actual 78011 3425 6266 5978 5686 10230 12406 15194 4054 2333 3855 2867 5717

Current Budget 75198 3844 5522 5813 8516 11353 11884 12113 4367 2947 2947 2947 2947

This Yr Projctd 97904 5765 10734 13047 8913 13748 12430 17115 4367 2947 2947 2947 2947

Next Yr Budget 98287 31% 5439 9612 11484 10203 14277 12727 17047 4614 2337 3525 2594 4430

5360 COS, PRO SHOP, FOOD & BE

Prior Yr Actual 2367 0 57 44 0 431 306 390 180 100 298 355 208

Current Budget 1950 163 260 224 195 260 215 211 98 81 81 81 81

This Yr Projctd 2511 205 265 155 79 207 1010 168 98 81 81 81 81

Next Yr Budget 2318 19% 144 190 132 178 301 388 173 187 116 211 123 175

5420 COS, FOOD

Prior Yr Actual 342036 21670 35056 32295 41475 47942 51776 38069 22328 10461 15199 10870 14895

Current Budget 364165 25622 36186 36498 42676 44587 54905 36241 23600 15947 15798 15516 16588

This Yr Projctd 377344 25424 33858 41122 30607 49720 64303 54301 21578 14964 13888 13257 14323

Next Yr Budget 359602 -1% 20410 35885 33606 38157 48501 55383 42744 22880 15435 15353 15073 16175

5430 COS, BEVERAGE

Prior Yr Actual 84347 6578 6711 7281 9311 11451 11659 9554 4353 6165 3857 4025 3401

Current Budget 80773 7154 7105 7753 9398 10939 12616 9200 4384 2955 2743 3309 3217

This Yr Projctd 81298 6429 7614 9391 9190 9249 14591 8537 4393 3007 2624 3189 3085

Next Yr Budget 82898 3% 7198 8017 8577 9179 11356 12400 8952 4552 3060 2833 3441 3333

TOTAL COST OF REVENUES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 522087 36783 49073 50289 60785 67139 79620 57765 32449 21929 21569 21852 22832


Next Year Budget 545626 5% 33402 53915 54009 57926 74645 81108 69125 32443 21158 22131 21441 24324

Version 3


Total



------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

GROSS PROFIT MARGIN ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 4677846 358228 414347 392582 437761 475265 451277 401001 353933 343138 335275 343083 371957


Next Year Budget 2829442 -40% 215151 234352 237342 309250 355376 354774 264489 188042 167317 169294 164482 169573

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

E X P E N S E S

6100 PAYROLL

Prior Yr Actual 1201365 102356 104056 106655 102486 97458 102608 103665 111007 92868 93692 92465 92052

Current Budget 1332696 110099 109635 110322 109821 103585 110089 109899 116270 107411 113252 113773 118540

This Yr Projctd 1321513 99465 109877 109498 110860 101630 111694 109248 116269 107411 113251 113773 118539

Next Yr Budget 1398257 5% 115908 112934 116272 116308 106286 116108 112834 115906 112108 115442 115442 142708

6125 PAYROLL, O.T.

Prior Yr Actual 32259 2643 3378 697 1491 2096 2728 3868 3816 1867 2586 4410 2679

Current Budget 22306 1281 1281 1982 2333 2333 2333 2274 1873 1873 1581 1581 1581

This Yr Projctd 41666 3159 3884 3076 4359 4396 5606 3698 2872 2872 2581 2581 2581

Next Yr Budget 28131 26% 2327 2520 2520 2871 2871 2871 2520 1926 1926 1926 1926 1926

6150 PAYROLL KITCHEN

Prior Yr Actual 258171 19298 22727 24775 27138 26726 25372 24491 21077 15722 18604 16348 15893

Current Budget 273643 19684 23181 25486 27896 27476 26095 25196 21954 18643 19747 18643 19642

This Yr Projctd 270708 19865 25162 26019 25389 22678 28449 24520 21954 18643 19747 18643 19642

Next Yr Budget 279504 2% 20181 26312 27169 26539 23828 29599 25670 19770 18959 20063 18959 22458

6155 PAYROLL, KITCHEN, OT

Prior Yr Actual 4556 0 589 -173 9 1048 431 2718 -72 0 6 0 0

Current Budget 4200 200 650 200 100 1000 50 2000 0 0 0 0 0

This Yr Projctd 19401 452 1887 2220 2046 4341 3921 4534 0 0 0 0 0

Next Yr Budget 4200 0% 200 650 200 100 1000 50 2000 0 0 0 0 0

6175 PAYROLL, GOLF LESSONS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 0 0 0 0 0 0 0 0 0 0 0 0 0


6180 PAYROLL, SERVICE

Prior Yr Actual 259325 18609 23274 21058 24807 24926 28101 21395 21357 16797 19715 18558 20727

Current Budget 270530 18981 23740 21643 25467 25588 28826 21986 21907 20321 19473 19281 23320

This Yr Projctd 267523 20364 22194 23555 24206 23699 25454 23748 21907 20321 19473 19281 23320

Next Yr Budget 274349 1% 20875 22760 24162 24832 24310 26118 24361 19964 20831 19957 19759 26420

Version 3


Total



6185 PAYROLL, SERVICE, OT

Prior Yr Actual 501 0 132 -49 5 296 110 -30 0 0 0 0 37

Current Budget 450 0 0 0 50 100 250 50 0 0 0 0 0

This Yr Projctd 2768 -11 152 176 80 622 1241 508 0 0 0 0 0

Next Yr Budget 450 0% 0 0 0 50 100 250 50 0 0 0 0 0

6200 PAYROLL TAXES & FEES

Prior Yr Actual 339867 32647 40414 35852 28697 28534 31573 28017 25587 28754 22276 18918 18599

Current Budget 366460 35247 43139 41198 32071 30159 31933 28588 26382 23531 24453 24078 25681

This Yr Projctd 327092 22474 25784 33828 33252 30337 30797 26494 26382 23531 24453 24079 25682

Next Yr Budget 348892 -5% 25321 27821 28452 39155 35217 35591 31595 25072 23797 24056 23775 29041

6202 PAYROLL BENEFITS

Prior Yr Actual 183371 10606 17240 17534 16611 16496 17111 16225 16540 15485 13480 13741 12301

Current Budget 219049 17884 17884 17884 18377 18377 18377 18377 18377 18377 18377 18377 18377

This Yr Projctd 198165 15598 13743 18437 16026 16939 16632 16035 16951 16951 16951 16951 16951

Next Yr Budget 256003 17% 22479 21104 21104 21104 21104 21104 21104 22479 21104 21104 21104 21104

6225 CONCERT SERIES EXPENSES

Prior Yr Actual 37941 0 648 0 16700 20549 0 0 35 0 0 0 9

Current Budget 50600 50 800 0 20670 29080 0 0 0 0 0 0 0

This Yr Projctd 49399 0 924 194 20205 28075 0 0 0 0 0 0 0

Next Yr Budget 53550 6% 350 750 250 21040 22290 8870 0 0 0 0 0 0

6250 H-2B ADDITIONAL EXPENSES

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 16524 2692 5347 5493 2065 52 -253 1129 0 0 0 0 0


6300 ADVERTISING

Prior Yr Actual 8409 999 550 1430 575 1099 1545 990 510 500 160 25 25

Current Budget 7150 1050 1050 1000 450 450 450 450 450 450 450 450 450

This Yr Projctd 11009 508 3960 2898 348 348 348 348 450 450 450 450 450

Next Yr Budget 9800 37% 5400 400 400 400 400 400 400 400 400 400 400 400

6325 AED TRAINING & SUPPLIES

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 525 25 25 25 250 25 25 25 25 25 25 25 25

This Yr Projctd 2475 146 0 425 1779 0 0 0 25 25 25 25 25

Next Yr Budget 1245 137% 745 25 25 250 25 25 25 25 25 25 25 25

6351 BAD DEBT

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

Version 3


Total



This Yr Projctd 0 0 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

6500 CASUAL LABOR

Prior Yr Actual 9227 0 0 0 0 0 1154 0 1063 662 1118 4195 1035

Current Budget 4240 0 0 0 0 0 0 0 848 848 1696 848 0

This Yr Projctd 6283 0 0 0 0 416 703 925 848 848 1696 848 0

Next Yr Budget 5250 0 0 750 0 0 0 0 900 900 900 1800 0

6550 CHEMICALS

Prior Yr Actual 143111 10510 6807 7702 7654 6924 13056 10064 38549 11758 12844 9291 7951

Current Budget 139050 10825 7325 7325 7525 7825 12525 7525 27000 7525 12600 23525 7525

This Yr Projctd 149584 14597 8672 7243 9600 7882 15841 6950 27125 7650 12725 23650 7650

Next Yr Budget 151300 9% 24450 7450 7550 7750 8050 21850 7850 27450 7650 13450 7650 10150

6600 CLEANING SUPPLIES

Prior Yr Actual 16712 1203 1659 1618 1072 1606 2004 1386 806 2185 1199 1103 871

Current Budget 17900 1492 1492 1492 1492 1492 1492 1492 1492 1492 1492 1492 1492

This Yr Projctd 18546 1915 1412 1274 2153 1561 1315 1457 1492 1492 1492 1492 1492

Next Yr Budget 17900 0% 1492 1492 1492 1592 1592 1592 1492 1492 1492 1342 1492 1342

6610 COMPLIMENTARY MEALS

Prior Yr Actual 7864 441 444 758 1258 903 1153 828 608 505 268 317 380

Current Budget 7000 483 608 708 1083 933 883 533 433 333 333 333 337

This Yr Projctd 6077 262 600 485 762 789 640 770 433 333 333 333 337

Next Yr Budget 5950 -15% 383 608 533 683 733 608 733 533 283 283 283 283

6625 COMPUTER SUPPORT

Prior Yr Actual 36830 2934 2934 2934 2934 3164 2934 3104 2934 2934 2942 3882 3199

Current Budget 38600 3100 3100 3100 3100 4500 3100 3100 3100 3100 3100 3100 3100

This Yr Projctd 44490 3659 3419 3782 3199 4599 3199 4434 3400 3400 4600 3400 3400

Next Yr Budget 44856 16% 3440 3440 3728 3440 5190 3440 3440 3440 4295 3440 4123 3440

6630 CONTINGENCY

Prior Yr Actual 26775 0 0 6274 0 0 6274 0 0 6274 0 0 7954

Current Budget 47090 1680 19410 6500 0 0 6500 0 0 6500 0 0 6500

This Yr Projctd 6345 -3196 16214 3149 -9822 0 0 0 0 0 0 0 0

Next Yr Budget 19410 -59% 0 19410 0 0 0 0 0 0 0 0 0 0

6650 CONTINUING EDUCATION

Prior Yr Actual 14252 5457 2095 120 -1105 35 -573 368 527 2932 -295 4469 222

Current Budget 17305 1240 2350 3125 810 850 400 400 320 1625 1370 745 4070

This Yr Projctd 15450 240 40 2950 775 175 3140 0 320 1625 1370 745 4070

Next Yr Budget 19254 11% 5068 5620 220 494 1080 1650 80 420 874 794 80 2874

6652 CONTRACT LABOR - TECHNIC

Version 3


Total



Prior Yr Actual 221 221 0 0 0 0 0 0 0 0 0 0 0

Current Budget 1800 150 150 150 150 150 150 150 150 150 150 150 150

This Yr Projctd 750 0 0 0 0 0 0 0 150 150 150 150 150

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

6750 DISHES & GLASSWARE

Prior Yr Actual 9433 29 162 555 338 1283 697 1049 833 4487 0 0 0

Current Budget 2600 217 217 217 217 217 217 217 217 217 217 217 217

This Yr Projctd 1903 0 0 277 31 170 341 0 217 217 217 217 217

Next Yr Budget 3000 15% 2100 0 0 500 0 0 200 0 0 200 0 0

6850 DUES & SUBSCRIPTIONS

Prior Yr Actual 5830 2200 1075 245 60 360 190 1035 95 570 0 0 0

Current Budget 10974 895 375 110 1800 0 640 400 250 1964 1790 2750 0

This Yr Projctd 10929 200 1840 920 1350 190 1035 0 250 1964 1430 1750 0

Next Yr Budget 10103 -8% 1050 495 1610 3614 0 660 0 420 909 0 1345 0

6900 ELECTRIC*

Prior Yr Actual 186744 14403 16466 15821 15129 15153 14919 16513 15717 16116 16455 15325 14728

Current Budget 189280 14403 16466 15821 15129 15153 14919 16513 16452 16171 16171 15816 16267

This Yr Projctd 181201 14991 15177 14754 15554 14992 11320 14990 16452 15807 15807 15452 15903

Next Yr Budget 178073 -6% 14184 14654 14334 14759 14530 13904 14709 15417 15651 15703 15205 15022

6901 EMPLOYEE MEALS

Prior Yr Actual 3850 425 584 475 592 499 463 -10 153 117 84 448 18

Current Budget 3762 114 536 498 503 536 507 498 114 114 114 114 114

This Yr Projctd 3184 449 380 361 366 380 307 371 114 114 114 114 114

Next Yr Budget 3184 -15% 449 380 361 366 380 307 371 114 114 114 114 114

6902 EMPLOYEE APPRECIATION

Prior Yr Actual 6618 637 160 4069 364 400 0 476 0 424 0 0 89

Current Budget 7200 350 200 4200 350 200 200 350 200 200 350 250 350

This Yr Projctd 6054 0 0 4046 29 0 0 630 200 200 350 250 350

Next Yr Budget 7200 0% 50 50 4800 50 50 50 50 50 50 50 1050 900

6948 ENTERTAINMENT-DINING ROO

Prior Yr Actual 5845 0 1075 990 800 990 780 790 420 0 0 0 0

Current Budget 5190 800 915 480 640 640 640 800 275 0 0 0 0

This Yr Projctd 4505 0 915 480 640 640 640 915 275 0 0 0 0

Next Yr Budget 4825 -7% 0 915 640 640 640 640 915 435 0 0 0 0

6949 ENTERTAINMENT LOUNGE

Prior Yr Actual 16150 1650 1050 950 1500 1350 1300 1400 1400 1600 1350 1050 1550

Current Budget 17300 1350 1000 1650 1400 1350 1650 1450 1350 1750 1250 1750 1350

This Yr Projctd 17000 1350 1000 1650 1450 1350 1650 1500 1350 1750 1250 1350 1350

Version 3


Total



Next Yr Budget 17400 1% 1400 1500 1200 1400 1450 1850 1400 1300 1500 1300 1700 1400

6950 ENTERTAINMENT/DECORATION

Prior Yr Actual 8932 878 1810 361 380 954 442 1882 354 863 326 449 235

Current Budget 8606 878 1810 361 380 954 442 1882 500 300 500 300 300

This Yr Projctd 3852 275 -625 -65 421 108 1104 735 500 300 500 300 300

Next Yr Budget 7650 -11% 900 1800 1200 500 200 500 1000 200 750 200 200 200

6951 EQUIPMENT RENTAL

Prior Yr Actual 3381 0 0 0 0 0 0 0 0 0 0 1473 1908

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 1000 0 0 0 0 0 0 0 0 0 0 1000 0


7100 FERTILIZER

Prior Yr Actual 92513 14737 4097 6748 4844 5002 14394 4241 6103 5010 16826 5195 5317

Current Budget 98250 14800 4900 6200 6200 6200 15100 5500 5500 5500 17350 5500 5500

This Yr Projctd 98410 14944 5075 5339 7077 6369 15448 4808 5500 5500 17350 5500 5500

Next Yr Budget 98410 0% 14944 5075 5339 7077 6369 15448 4808 5500 5500 17350 5500 5500

7150 FIELD SUPPLIES

Prior Yr Actual 32715 8963 1877 1874 627 1755 2581 2988 1927 4254 1980 2690 1198

Current Budget 28204 10054 1650 1650 1650 1650 1650 1650 1650 1650 1650 1650 1650

This Yr Projctd 37176 13050 2782 3741 2232 1816 3351 688 1903 1903 1903 1903 1903

Next Yr Budget 33410 18% 10889 2200 2800 1500 1800 1800 2025 1750 3553 1900 1893 1300

7175 FITNESS CENTER MAINTENAN

Prior Yr Actual 17236 1075 684 617 916 509 693 3383 908 4262 1831 140 2218

Current Budget 5000 416 416 416 416 416 416 416 416 416 416 416 424

This Yr Projctd 7752 91 633 3259 233 260 798 390 416 416 416 416 424

Next Yr Budget 3000 -40% 250 250 250 250 250 250 250 250 250 250 250 250

7185 FOUNTAINS (ELECTRIC)

Prior Yr Actual 2425 450 300 300 0 300 600 0 475 0 0 0 0

Current Budget 5500 458 458 458 458 458 458 458 458 458 458 458 462

This Yr Projctd 7188 0 0 0 0 624 3629 645 458 458 458 458 458

Next Yr Budget 10524 91% 877 877 877 877 877 877 877 877 877 877 877 877

7190 FOUNTAIN & BUBBLER MAINT

Prior Yr Actual 495 0 0 0 0 0 0 0 0 0 0 0 495

Current Budget 3000 250 250 250 250 250 250 250 250 250 250 250 250

This Yr Projctd 2475 175 3895 175 175 175 175 -3545 250 250 250 250 250

Next Yr Budget 3000 0% 250 250 250 250 250 250 250 250 250 250 250 250

7200 GASOLINE

Prior Yr Actual 19107 2579 2083 3120 1024 1442 1637 3658 3261 -5408 1911 2212 1589

Version 3


Total



Current Budget 37014 2795 2377 3351 1548 1655 1727 3765 3958 3958 3958 3958 3962

This Yr Projctd 38132 2234 1691 3790 2623 1728 2965 1808 4258 4258 4258 4258 4262

Next Yr Budget 30294 -18% 2536 2007 4069 2601 1781 2897 2228 3238 2320 2212 2465 1940

7225 GRATIS / MEMBER RELATIONS

Prior Yr Actual 5152 634 770 439 325 508 825 317 194 293 254 252 342

Current Budget 5817 634 770 439 325 508 825 317 400 400 400 400 400

This Yr Projctd 5066 339 466 237 528 488 581 426 400 400 400 400 400

Next Yr Budget 4500 -23% 339 466 237 528 488 581 426 293 293 254 252 342

7230 PRO SHOP, GRIPS EXP

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 760 0 0 0 0 0 324 436 0 0 0 0 0


7251 SMALL EQUIPMENT SOUND

Prior Yr Actual 3521 34 226 0 200 393 1843 0 0 0 0 0 824

Current Budget 3300 275 275 275 275 275 275 275 275 275 275 275 275

This Yr Projctd 1580 0 0 0 0 50 155 0 275 275 275 275 275

Next Yr Budget 3300 0% 275 275 275 275 275 275 275 275 275 275 275 275

7300 INSURANCE

Prior Yr Actual 147092 11980 11980 11980 11980 12397 12397 12397 12397 12397 12397 12397 12397

Current Budget 145000 12083 12083 12083 12083 12083 12083 12083 12083 12083 12083 12083 12083

This Yr Projctd 145002 12083 12083 12083 12083 12083 12083 12083 12084 12084 12084 12084 12084

Next Yr Budget 145006 0% 12084 12084 12084 12084 12084 12084 12084 12084 12084 12084 12084 12084

7350 IRRIGATION

Prior Yr Actual 24145 1863 893 500 1494 1808 4822 1867 3089 2630 1814 3365 0

Current Budget 18000 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500

This Yr Projctd 13069 815 275 835 946 2632 0 67 1500 1500 1500 1500 1500

Next Yr Budget 16000 -11% 1333 1333 1333 1333 1333 1333 1333 1333 1333 1333 1333 1333

7400 LANDSCAPE PLANT/SUPPLIES

Prior Yr Actual 66980 8694 18104 8274 5095 2938 3333 5120 3425 2065 2953 4074 2905

Current Budget 76075 12430 21200 9750 3975 3475 2820 4630 4050 3475 3975 3475 2820

This Yr Projctd 63829 12645 11981 8008 3075 4506 2420 3400 4050 3475 3975 3475 2820

Next Yr Budget 74875 -2% 12630 17100 9750 3875 3375 2720 4530 7550 3375 3875 3375 2720

7450 LEASE

Prior Yr Actual 279937 20950 25612 23926 24299 24434 24829 23371 23581 26133 21093 21113 20596

Current Budget 249352 24783 18888 18834 19191 19688 22217 21774 21471 20504 20504 20997 20504

This Yr Projctd 236038 23645 19340 17695 18931 18877 18434 18931 18399 20432 20432 20492 20432

Next Yr Budget 220202 -12% 26216 17754 15968 17215 16718 16718 17216 15918 19092 19460 18963 18963

Version 3


Total



7500 LICENSES & TAXES

Prior Yr Actual 8943 0 1819 619 0 1910 10 2346 489 1600 0 0 150

Current Budget 7085 0 1457 343 300 1800 451 2309 425 0 0 0 0

This Yr Projctd 4896 0 1656 0 397 0 2372 46 425 0 0 0 0

Next Yr Budget 7154 1% 0 1657 0 397 0 2371 2054 375 0 0 300 0

7550 LINEN

Prior Yr Actual 22967 1275 2072 1942 2496 3002 3571 2393 1599 1510 956 839 1311

Current Budget 23752 1275 2072 1942 2496 3002 3571 2393 1500 1600 1300 1300 1300

This Yr Projctd 25102 2088 2392 2700 2227 2609 3601 2486 1500 1600 1300 1300 1300

Next Yr Budget 24522 3% 2088 2392 2700 2227 2609 3601 2486 1599 1510 1000 1000 1311

7600 MAINTENANCE & REPAIRS

Prior Yr Actual 82447 9098 6766 5327 6739 10751 9819 5976 8495 551 5639 5599 7689

Current Budget 88000 7250 7250 7250 7250 8250 7250 7250 7250 7250 7250 7250 7250

This Yr Projctd 87651 6373 4897 10646 10301 4526 7553 6105 7450 7450 7450 7450 7450

Next Yr Budget 86800 -1% 7150 7150 7150 7150 8150 7150 7150 7150 7150 7150 7150 7150

7655 MAINTENANCE, EQUIPMENT

Prior Yr Actual 65976 6458 5099 4171 3685 8162 2959 4767 6674 5381 5249 6671 6700

Current Budget 56350 4550 4550 4550 4550 4550 4550 4550 4900 4900 4900 4900 4900

This Yr Projctd 63327 7852 6690 5345 4964 6457 3916 3604 4900 4900 4900 4900 4900

Next Yr Budget 62950 12% 5100 5100 5100 5100 5100 5100 5100 5450 5450 5450 5450 5450

7676 PARTS & SUPPLIES

Prior Yr Actual 53934 5913 3951 4318 4812 3172 6347 5215 4874 4810 589 4882 5051

Current Budget 53000 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417

This Yr Projctd 50773 5118 2565 4810 5061 3788 3288 4059 4417 4417 4417 4417 4417

Next Yr Budget 50600 -5% 4217 4217 4217 4217 4217 4217 4217 4217 4217 4217 4217 4217

7685 MAINTENANCE, POOL

Prior Yr Actual 6967 336 242 488 825 1386 212 428 744 1112 27 215 952

Current Budget 4800 400 400 400 400 400 400 400 400 400 400 400 400

This Yr Projctd 8289 1818 -468 939 707 0 1083 1209 600 600 600 600 600

Next Yr Budget 6000 25% 500 500 500 500 500 500 500 500 500 500 500 500

7751 MEMBER REWARDS-FOOD

Prior Yr Actual 54638 4385 5757 5089 6099 6811 8364 5794 3135 2330 2567 1674 2634

Current Budget 56203 4055 5502 5204 6818 7357 8050 5909 3616 2482 2272 2496 2444

This Yr Projctd 51868 3737 5447 5143 5435 6376 7638 6003 3292 2245 2058 2268 2225

Next Yr Budget 51452 -8% 3247 4983 4702 5455 6789 8082 6179 3260 2232 2050 2256 2215

7752 MEMBER REWARDS-BEVERAGE

Prior Yr Actual 24128 2049 2228 1980 2688 3057 3363 2667 1341 1340 1209 917 1289

Current Budget 23195 2001 1996 1945 2793 3176 3527 2720 1322 924 829 1042 918

Version 3


Total



This Yr Projctd 22615 1993 2285 2165 2533 2784 3266 2458 1345 942 843 1065 935

Next Yr Budget 22932 -1% 2058 2118 2139 2493 2996 3458 2532 1347 943 844 1067 937

7755 BANK CHARGES

Prior Yr Actual 20362 577 1048 1731 1217 2230 3361 3060 1885 1674 1766 804 1008

Current Budget 18869 1152 394 1505 1178 1716 3864 3003 1120 2240 1033 592 1072

This Yr Projctd 25850 1086 1008 1953 1732 3326 4726 3962 3120 2240 1033 592 1072

Next Yr Budget 25850 37% 1086 1008 1953 1732 3326 4726 3962 3120 2240 1033 592 1072

7825 OFFICE EQUIPMENT

Prior Yr Actual 17874 1868 1742 941 1868 1599 991 1075 1957 1744 1961 1008 1119

Current Budget 20880 1490 1490 1490 1490 1490 1490 1490 1490 1490 1490 1490 4490

This Yr Projctd 26744 1911 5887 1341 2095 1118 1083 2402 1581 1581 1581 1581 4581

Next Yr Budget 19310 -8% 2219 1387 1292 2219 1292 1292 2219 1292 1292 2219 1292 1292

7850 OFFICE SUPPLIES

Prior Yr Actual 28167 1941 1968 2116 1955 2552 2529 1807 2213 1319 1191 7628 949

Current Budget 19840 1653 1653 1653 1653 1653 1653 1653 1653 1653 1653 1653 1657

This Yr Projctd 18455 1554 1790 2351 1877 1059 357 1558 1582 1582 1582 1582 1582

Next Yr Budget 18400 -7% 1533 1533 1533 1533 1533 1533 1533 1533 1533 1533 1533 1533

7852 PUMP MAINTENANCE

Prior Yr Actual 9560 9010 0 0 550 0 0 0 0 0 0 0 0

Current Budget 9122 9122 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 7810 7810 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 9122 0% 9122 0 0 0 0 0 0 0 0 0 0 0

7870 POSTAGE

Prior Yr Actual 5683 1000 937 315 800 0 541 0 500 500 500 56 534

Current Budget 6843 1000 937 315 800 0 541 0 650 650 650 650 650

This Yr Projctd 6111 576 1005 -71 500 500 551 -200 650 650 650 650 650

Next Yr Budget 6500 -5% 542 542 542 542 542 542 542 542 542 542 542 542

7900 PROFESSIONAL FEES

Prior Yr Actual 116247 7291 9279 9804 8585 8949 8727 10736 9173 5096 8536 12096 17974

Current Budget 116232 9186 11186 9186 9186 9186 9186 11186 9186 11186 9186 9186 9186

This Yr Projctd 116181 8536 10400 13320 8316 9871 9716 8091 9186 11186 9186 9186 9186

Next Yr Budget 107140 -8% 6170 10920 21170 8420 7670 6170 8170 6170 8770 6170 6170 11170

7950 PROPANE GAS

Prior Yr Actual 18196 1314 1397 1973 968 3070 1976 1491 1291 1462 1096 915 1244

Current Budget 18794 1367 1454 2059 998 3001 2062 1552 1260 1260 1260 1260 1260

This Yr Projctd 14714 1230 528 2012 483 279 2018 1805 1272 1272 1272 1272 1272

Next Yr Budget 16938 -10% 1379 1466 2071 1010 1013 2074 1564 1272 1272 1272 1272 1272

8100 RANGE BALLS & MATS

Version 3


Total



Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 8200 8200 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 8316 8316 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 8200 0% 8200 0 0 0 0 0 0 0 0 0 0 0

8125 REC DISTRICT SOCIAL EVEN

Prior Yr Actual 2773 0 0 990 0 0 42 1741 0 0 0 0 0

Current Budget 2950 0 0 1200 0 0 0 1750 0 0 0 0 0

This Yr Projctd 2078 0 0 727 0 0 105 1246 0 0 0 0 0

Next Yr Budget 2900 -2% 50 50 800 50 50 50 1750 50 0 50 0 0

8130 RESIDENT EVENT DECORATIO

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd -2523 -928 -40 -1039 343 -895 -353 389 0 0 0 0 0

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

8150 REFUSE

Prior Yr Actual 19321 2012 1585 1338 1263 1588 2563 1263 1263 1913 1163 1913 1458

Current Budget 22093 1958 1655 1655 1655 1655 1655 1958 1980 1980 1980 1980 1980

This Yr Projctd 22789 1683 1433 2658 1358 2008 2008 1708 1987 1987 1987 1987 1987

Next Yr Budget 23017 4% 1700 1448 2685 1372 2028 2028 1725 2007 2007 2007 2007 2007

8200 RENTAL

Prior Yr Actual 56 0 0 0 0 0 0 0 0 0 0 0 56

Current Budget 1480 40 40 40 40 40 40 40 40 40 40 1040 40

This Yr Projctd 1552 0 0 0 0 186 166 0 40 40 40 1040 40

Next Yr Budget 5280 257% 440 440 440 440 440 440 440 440 440 440 440 440

8225 SECURITY

Prior Yr Actual 14071 1139 1139 1241 1173 1173 1173 1173 1173 1173 1173 1173 1173

Current Budget 14493 1173 1173 1278 1208 1208 1208 1208 1208 1208 1208 1208 1208

This Yr Projctd 14494 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208

Next Yr Budget 14929 3% 1244 1244 1244 1244 1244 1244 1244 1244 1244 1244 1244 1244

8250 SEED, SOD, SAND

Prior Yr Actual 27095 2233 1873 2768 1754 1540 1202 3951 1043 2380 1089 3348 3915

Current Budget 30300 2575 2275 2575 1875 1675 1675 2675 2675 3075 3075 3075 3075

This Yr Projctd 27518 1875 1405 3647 2281 884 1443 1007 2675 3075 3075 3075 3075

Next Yr Budget 29900 -1% 2575 2275 2575 1875 1675 1675 2675 2675 3075 3075 3675 2075

8300 SERVICE CONTRACTS

Prior Yr Actual 174041 21892 15085 13742 16600 14876 12716 14750 13054 14136 11049 14844 11299

Current Budget 173556 22391 15287 13237 14332 15987 13237 14360 13918 12203 11233 14003 13368

This Yr Projctd 173665 20387 15437 13035 14940 15584 13611 15946 13918 12203 11233 14003 13368

Version 3


Total



Next Yr Budget 199988 15% 23973 18608 15638 18191 17593 16400 19144 13663 14733 13108 14468 14468

8350 SMALL TOOLS

Prior Yr Actual 3823 516 174 1351 104 99 354 561 -647 2183 -1310 0 438

Current Budget 8400 700 700 700 700 700 700 700 700 700 700 700 700

This Yr Projctd 6726 447 313 465 205 374 865 558 700 700 700 700 700

Next Yr Budget 8400 0% 700 700 700 700 700 700 700 700 700 700 700 700

8351 SMALL EQUIPMENT-KITCHEN

Prior Yr Actual 8622 164 135 237 0 0 0 984 101 7000 0 0 0

Current Budget 9900 75 75 75 75 75 75 75 75 75 75 75 9075

This Yr Projctd 7232 0 0 0 0 0 0 57 75 75 75 75 6875

Next Yr Budget 7900 -20% 75 75 75 75 75 75 75 75 75 75 75 7075

8400 SUPPLIES

Prior Yr Actual 20257 1854 2012 2195 2228 2724 2666 2081 947 797 712 1226 815

Current Budget 24000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000

This Yr Projctd 24875 1500 1975 1416 2039 3088 2628 2229 2000 2000 2000 2000 2000

Next Yr Budget 20500 -15% 2000 2000 2100 2200 2500 2500 2200 1000 1000 1000 1000 1000

8450 TELEPHONE*

Prior Yr Actual 22522 1754 1618 1828 1787 1727 1630 2582 1854 2009 1551 2501 1679

Current Budget 21112 1759 1759 1759 1759 1759 1759 1759 1759 1759 1759 1759 1759

This Yr Projctd 18292 1650 1636 1359 1492 1482 1490 1917 1453 1453 1453 1453 1453

Next Yr Budget 18718 -11% 1559 1559 1560 1560 1560 1560 1560 1560 1560 1560 1560 1560

8475 TENNIS COURT MAINTENANCE

Prior Yr Actual 17834 1039 262 2005 1507 40 615 1381 300 355 150 5485 4693

Current Budget 9240 217 217 217 217 217 217 217 217 217 217 6767 303

This Yr Projctd 9407 620 0 618 178 0 271 0 217 217 217 6767 303

Next Yr Budget 20156 118% 1039 262 2005 1507 40 615 1381 300 355 150 12350 150

8500 TRAVEL

Prior Yr Actual 17679 1514 1546 151 742 4297 246 2984 707 2485 441 1508 1056

Current Budget 17165 225 1775 275 1075 4675 225 675 225 925 2445 1095 3550

This Yr Projctd 11778 267 55 56 228 1117 1275 540 225 1550 1820 1095 3550

Next Yr Budget 15180 -12% 1560 2070 100 380 2280 2420 130 330 930 1620 130 3230

8550 UNIFORMS

Prior Yr Actual 22113 3849 1223 1636 2261 1207 1174 1569 2260 1704 1651 1104 2474

Current Budget 18312 3914 1094 1805 1094 1094 1305 2114 1094 1305 1094 1239 1160

This Yr Projctd 17944 3453 1629 1528 1337 896 1530 1078 1694 1305 1094 1239 1160

Next Yr Budget 18812 3% 4114 2894 1160 1394 1094 1160 1394 1094 1160 1094 1094 1160

8700 WATER*

Prior Yr Actual 25505 1768 2127 2277 2250 2742 2367 2648 2250 1630 1935 1540 1969

Version 3


Total



Current Budget 26728 1768 2127 2277 2250 2742 2367 2648 2097 2012 2061 2230 2148

This Yr Projctd 26714 788 2188 2321 2449 2834 2895 2692 2097 2012 2061 2230 2148

Next Yr Budget 27216 2% 1163 2195 2328 2440 2803 2890 2720 2123 2038 2087 2256 2174

8701 EFFLUENT WATER

Prior Yr Actual 30532 1304 2983 1281 2716 1651 1818 2304 3634 5330 3078 3218 1215

Current Budget 23528 1404 3060 1354 2216 1851 1868 2404 3620 1550 1736 830 1635

This Yr Projctd 30632 1383 4589 3457 2658 1886 2602 3007 4300 2550 1736 830 1635

Next Yr Budget 30632 1383 4589 3457 2658 1886 2602 3007 4300 2550 1736 830 1635

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 4674441 420273 420100 393389 394760 406807 401356 380188 382747 352889 367572 373198 381162


Next Year Budget 4797070 3% 453965 425146 410941 416936 399948 432962 388807 380989 353156 369146 360938 404136

NET INCOME/(LOSS) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Prior Year Actual 136970 -29366 -9761 -2450 36906 78333 46119 17392 -41930 9172 26468 -30739 36826

Current Budget 3405 -62046 -5753 -807 43001 68458 49921 20813 -28814 -9751 -32297 -30115 -9205

This Yr Projected 116364 -33586 18919 -20729 57620 115466 36045 38932 -29051 -3298 -32655 -30016 -1282

Next Year Budget -1967628 -238814 -190794 -173599 -107686 -44573 -78189 -124318 -192947 -185839 -199852 -196455 -234563

Version 3


Total

Year Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep NotesI N C O M E


Prior Yr Actual 664239 48856 53832 61970 48202 45182 57481 53776 52893 59199 54262 54742 73843

Current Budget 725475 54600 80010 65483 47694 51293 62363 56409 56575 63035 54346 56633 77033

This Yr Projctd 725474 -100% 54600 80010 65483 47694 51293 62363 56409 56575 63035 54346 56633 77033

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

4910 LEASE, RETAIL

Prior Yr Actual 1200 100 100 100 100 100 100 100 100 100 100 100 100

Current Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100 Apex Physical Therapy lease

This Yr Projctd 1200 100 100 100 100 100 100 100 100 100 100 100 100 stays the same

Next Yr Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100

4920 CONCERT SERIES REVENUE

Prior Yr Actual 59335 10 3060 -20 22592 33278 0 0 0 0 0 0 415 5 shows, 2 Jan, 2 Feb & 1 Mar

Current Budget 65475 0 2500 0 26690 36285 0 0 0 0 0 0 0 Package price $90, Individual tix $23

This Yr Projctd 62932 0% 0 2330 -20 24639 35973 0 10 0 0 0 0 0 Showcase Jan

Next Yr Budget 63045 -4% 0 0 0 26718 24218 12109 0 0 0 0 0 0 No Showcase in November

4945 HOA ACCOUNTING INCOME

Prior Yr Actual 7596 633 633 633 633 633 633 633 633 633 633 633 633 Sub-HOA accounting agreements

Current Budget 7596 633 633 633 633 633 633 633 633 633 633 633 633 FHOA $450/mo, MHOA $306/mo

This Yr Projctd 9852 56% 633 633 633 633 633 633 633 633 633 1833 1161 1161 SHOA $528/mo

Next Yr Budget 15408 103% 1284 1284 1284 1284 1284 1284 1284 1284 1284 1284 1284 1284

4986 INTEREST INCOME

Prior Yr Actual 882 37 58 67 66 68 82 77 87 83 85 88 83 Most interest earned used to offset

Current Budget 607 37 58 67 66 68 82 77 30 30 30 30 30 Interest to increase due to transfers

This Yr Projctd 888 137% 100 89 94 91 80 109 174 30 30 30 30 30 to FL Prime SBA for Capital & Def

Next Yr Budget 2100 246% 175 175 175 175 175 175 175 175 175 175 175 175

4988 LATE FEE/MEMBER INTEREST

Prior Yr Actual 8777 1614 460 873 862 416 716 1234 180 1122 660 368 272

Current Budget 9325 1614 460 873 862 416 716 1234 700 400 1350 350 350 Based on current actuals

This Yr Projctd 6374 0% 125 563 374 833 611 271 947 700 400 850 350 350

Next Yr Budget 6374 -32% 125 563 374 833 611 271 947 700 400 850 350 350


Prior Yr Actual 30002 2536 1011 2472 3144 1414 2854 3910 2398 3438 1829 2079 2916 Virtual Mastercard A/P (trending lower)

Current Budget 38542 3261 1736 3197 3869 2139 3579 4635 3225 3225 3225 3225 3225 $150 estoppel and new resident setup fee

This Yr Projctd 76771 -53% 3022 3079 2347 16297 6595 6183 11123 5625 5625 5625 5625 5625 Locker Fees billed in Sep $415

Next Yr Budget 35830 -7% 3022 3079 2347 3514 3399 2987 4567 2500 2500 2500 2500 2915

Based on current actuals less budget

restitution credit & refund of prior yr overpymt

TOTAL INCOME ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 848219 60245 85497 70354 79915 90935 67473 63088 61263 67423 59684 60971 81371

This Yr Projected 883491 -86% 58579 86804 69011 90287 95285 69659 69397 63663 69823 62784 63899 84299

00 - Administration: Income Statement


FY 2017-18 Forecast


Actuals reported up to Apr/2017 with projected budget 16-17 FC

Version 3


Total

Year Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Notes


Next Year Budget 123957 -85% 4706 5201 4280 32624 29787 16926 7073 4759 4459 4909 4409 4824

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

E X P E N S E S

6100 PAYROLL

Prior Yr Actual 281450 26029 26868 25299 25581 25130 26331 25427 28578 22611 16818 15858 16918

Current Budget 352092 28006 29824 28551 28026 28629 28174 27493 31219 27493 28174 28454 38049

This Yr Projctd 346550 12% 18899 31834 28407 28579 28499 28954 27988 31219 27493 28174 28454 38049 Assume 3% salary increases

Next Yr Budget 386588 10% 31567 30675 31831 31567 28892 31567 30675 31831 30675 31567 31567 441756125 PAYROLL, O.T.

Prior Yr Actual 212 0 0 0 0 0 253 -67 0 0 0 0 26

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 476 26 1 36 50 37 135 191 0 0 0 0 0

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 06200 PAYROLL TAXES & FEES

Prior Yr Actual 42590 5465 4731 3503 3247 4008 3756 3540 4042 3199 2247 2316 2536

Current Budget 51295 6063 4982 4288 3911 3940 3880 3790 4237 3692 3733 3756 5022

This Yr Projctd 50972 -2% 2610 4836 5674 4450 4875 4201 3885 4237 3692 3733 3756 5022

Next Yr Budget 49716 -3% 3762 3657 3797 6022 4272 3929 3855 3815 3657 3762 3762 54246202 PAYROLL BENEFITS

Prior Yr Actual 52087 3627 4303 5110 4139 4764 5689 4782 5029 4872 2915 3568 3290 Assume 8% increase health rates

Current Budget 50810 4234 4234 4234 4234 4234 4234 4234 4234 4234 4234 4234 4234

Admin bears the cost for District wide

matching 401k contributions. Assume same

contribution level as previous year.

This Yr Projctd 54301 3% 5307 3082 6805 4132 4256 5031 4518 4234 4234 4234 4234 4234

GM vehicle allowance, Medcom ACA

Reporting Fee Oct $1375 May $1375

Next Yr Budget 55791 10% 5795 4420 4420 4420 4420 4420 4420 5795 4420 4420 4420 44206225 CONCERT SERIES EXPENSES

Prior Yr Actual 37941 0 648 0 16700 20549 0 0 35 0 0 0 9 Concert entertainment, food, chair rentals

Current Budget 50600 50 800 0 20670 29080 0 0 0 0 0 0 0 site visits & ticket stock

This Yr Projctd 49399 8% 0 924 194 20205 28075 0 0 0 0 0 0 0

Next Yr Budget 53550 6% 350 750 250 21040 22290 8870

6325 AED TRAINING & SUPPLIES

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 525 25 25 25 250 25 25 25 25 25 25 25 25 AED/CPR training classes for

This Yr Projctd 2475 -50% 146 0 425 1779 0 0 0 25 25 25 25 25 staff only in Oct $55pp

Next Yr Budget 1245 137% 745 25 25 250 25 25 25 25 25 25 25 25

6351 BAD DEBT

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 0 0 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 0


Prior Yr Actual 2378 188 91 292 264 94 470 304 239 262 38 59 76

Current Budget 2800 233 233 233 233 233 233 233 233 233 233 233 237

This Yr Projctd 2402 -8% 48 163 127 264 223 199 208 233 233 233 233 237

Next Yr Budget 2200 -21% 183 183 183 183 183 183 183 183 183 183 183 183

Version 3


Total



6625 COMPUTER SUPPORT

Prior Yr Actual 36830 2934 2934 2934 2934 3164 2934 3104 2934 2934 2942 3882 3199

Computer support contract $1895/mo Firewall

Jun $855

Current Budget 37200 3100 3100 3100 3100 3100 3100 3100 3100 3100 3100 3100 3100

Northstar support and member portal hosting

$1286/mo (3.3% increase), additional

software

This Yr Projctd 42740 1% 3659 3419 3782 3199 3199 3199 4084 3400 3400 4600 3400 3400 Eventpro Aug $682.95

Next Yr Budget 43106 16% 3440 3440 3728 3440 3440 3440 3440 3440 4295 3440 4123 3440

email hosting Dyn $9/mo, Domain name &

Web hosting Dec $288

6630 CONTINGENCY

Prior Yr Actual 25095 0 0 6274 0 0 6274 0 0 6274 0 0 6274 $19,410 Bond Asmnt for 15 lots

Current Budget 45410 0 19410 6500 0 0 6500 0 0 6500 0 0 6500

This Yr Projctd 6345 -3196 16214 3149 -9822 0 0 0 0 0 0 0 0

Next Yr Budget 19410 -57% 0 19410 0 0 0 0 0 0 0 0 0 0


Prior Yr Actual 6267 149 1995 120 70 35 -638 269 472 1275 525 1848 147 HFTP Annual $750 & Regional Jul $200

Current Budget 8325 100 2300 100 100 800 250 250 100 1275 775 275 2000

& monthly meetings $40/mo - GM, Controller

(asst controller 4/yr)

This Yr Projctd 7665 0% 40 40 0 130 80 2950 0 100 1275 775 275 2000

HFTP holiday party for GM & Controller, CAM

license renewal Jan, BMI Leadership Nov,

CMAA Nat'l Conf Mar

Next Yr Budget 7701 -7% 750 3070 120 399 80 1460 80 120 474 594 80 474 & summer conferences for GM Jun/Jul/Sep


Prior Yr Actual 1980 105 500 245 0 0 0 675 455 0 0 0 0 HFTP dues Dec $375 (Cont & Asst Cont)

Current Budget 4300 0 0 0 450 0 450 400 250 0 0 2750 0

Natl CMAA $850 Oct / FL CMAA $495 Aug,

CAM license renewal fees Jan $300 GM

This Yr Projctd 4555 -35% 0 1345 810 100 0 300 0 250 0 0 1750 0

Survey Monkey $300 Mar, Beekman Report

$275 May

Next Yr Budget 2970 -31% 850 0 750 300 0 300 0 275 0 0 495 0

6900 ELECTRIC*

Prior Yr Actual 18605 1515 1577 1607 1520 1761 1573 1549 1407 1500 1557 1534 1506

Current Budget 17806 1515 1577 1607 1520 1761 1573 1549 1405 1325 1325 1325 1325 Assume rates stay flat

This Yr Projctd 16689 5% 1484 1346 1343 1495 1506 1375 1434 1405 1325 1325 1325 1325

Next Yr Budget 17488 -2% 1484 1346 1343 1495 1506 1375 1434 1407 1500 1557 1534 1506

6902 EMPLOYEE APPRECIATION

Prior Yr Actual 6618 637 160 4069 364 400 0 476 0 424 0 0 89

Employee Holiday $4200, Mgr holiday dinner

$750 & Summer Party $1000 Aug

Current Budget 7200 350 200 4200 350 200 200 350 200 200 350 250 350 Employee Awards

This Yr Projctd 6054 19% 0 0 4046 29 0 0 630 200 200 350 250 350 Management teambuilding Sep $700

Next Yr Budget 7200 0% 50 50 4800 50 50 50 50 50 50 50 1050 900

Employee of the Month $50/mo, Employee of

the yr $150 Sep

7300 INSURANCE

Prior Yr Actual 22064 1797 1797 1797 1797 1859 1859 1859 1859 1859 1859 1859 1859 Est 4.6% increase over actuals plus

Current Budget 21750 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 increase for assessed value on new

This Yr Projctd 21750 0% 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 appraisal to be done FY17

Next Yr Budget 21756 0% 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813 1813

Version 3


Total




Prior Yr Actual 3369 0 1355 196 0 0 0 0 68 1600 0 0 150 Non-advalorem taxes (solid waste asmnt)

Current Budget 1350 0 1000 0 300 0 0 0 50 0 0 0 0 Fingerprint services for new board

This Yr Projctd 1458 -3% 0 1299 0 0 0 109 0 50 0 0 0 0 members

Next Yr Budget 1409 4% 0 1300 0 0 0 109 0 0 0 0 0 0

7755 BANK CHARGES

Prior Yr Actual 20362 577 1048 1731 1217 2230 3361 3060 1885 1674 1766 804 1008

Current Budget 18869 1152 394 1505 1178 1716 3864 3003 1120 2240 1033 592 1072 Based on actuals

This Yr Projctd 25850 0% 1086 1008 1953 1732 3326 4726 3962 3120 2240 1033 592 1072

Next Yr Budget 25850 37% 1086 1008 1953 1732 3326 4726 3962 3120 2240 1033 592 1072


Prior Yr Actual 17874 1868 1742 941 1868 1599 991 1075 1957 1744 1961 1008 1119 Gatekeeper software $550/mo

Current Budget 20880 1490 1490 1490 1490 1490 1490 1490 1490 1490 1490 1490 4490

Dex copier, copy & toner shipping charges

$366.27+$265+$16/mo

This Yr Projctd 26121 -31% 1911 5887 1341 2095 1118 1083 2236 1490 1490 1490 1490 4490 Postage/Folder/Stuffer $927/qtr

Next Yr Budget 18075 -13% 2124 1197 1197 2124 1197 1197 2124 1197 1197 2124 1197 1197


Prior Yr Actual 13830 1232 1218 1154 1208 1353 1376 1261 1141 818 624 2206 239

Current Budget 12000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 Based on actual

This Yr Projctd 10555 -5% 961 970 830 923 593 302 976 1000 1000 1000 1000 1000

Next Yr Budget 10000 -17% 833 833 833 833 833 833 833 833 833 833 833 833

7870 POSTAGE

Prior Yr Actual 5683 1000 937 315 800 0 541 0 500 500 500 56 534

Current Budget 6843 1000 937 315 800 0 541 0 650 650 650 650 650

This Yr Projctd 6111 6% 576 1005 -71 500 500 551 -200 650 650 650 650 650

Next Yr Budget 6500 -5% 542 542 542 542 542 542 542 542 542 542 542 542

7900 PROFESSIONAL FEES

Prior Yr Actual 116247 7291 9279 9804 8585 8949 8727 10736 9173 5096 8536 12096 17974

Current Budget 116232 9186 11186 9186 9186 9186 9186 11186 9186 11186 9186 9186 9186 *See Note 1

This Yr Projctd 116181 -8% 8536 10400 13320 8316 9871 9716 8091 9186 11186 9186 9186 9186 new fiscal auditors are

Next Yr Budget 107140 -8% 6170 10920 21170 8420 7670 6170 8170 6170 8770 6170 6170 11170 $7,890 less expensive

8125 REC DISTRICT SOCIAL EVEN

Prior Yr Actual 2773 0 0 990 0 0 42 1741 0 0 0 0 0 Coffee with the GM

Current Budget 2950 0 0 1200 0 0 0 1750 0 0 0 0 0 Board Christmas Dinner at cost

This Yr Projctd 2078 40% 0 0 727 0 0 105 1246 0 0 0 0 0 Volunteer Appreciation Party

Next Yr Budget 2900 -2% 50 50 800 50 50 50 1750 50 0 50 0 0


Prior Yr Actual 2395 0 0 0 2395 0 0 0 0 0 0 0 0 GCM Property SFWMD ERC Monitoring

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 Report

This Yr Projctd 2200 0% 0 0 0 0 0 0 2200 0 0 0 0 0

Next Yr Budget 2200 0 0 0 0 0 0 2200 0 0 0 0 0

8450 TELEPHONE*

Prior Yr Actual 10113 786 769 778 779 576 780 1246 804 786 586 1536 687

Current Budget 9900 825 825 825 825 825 825 825 825 825 825 825 825 Includes $50/mo cell reimbursement

This Yr Projctd 6255 2% 655 642 496 496 496 495 496 496 496 496 496 496 for GM, Controller & Exec Asst

Next Yr Budget 6360 -36% 530 530 530 530 530 530 530 530 530 530 530 530 Tablet for board email

8500 TRAVEL

Version 3


Total



Prior Yr Actual 8006 -291 165 151 555 2299 50 1030 108 2085 441 1411 0 HFTP Annual Oct & Regional Jul

Current Budget 8065 50 100 100 400 2800 50 500 50 50 1645 920 1400 & monthly meetings mileage - Controller

This Yr Projctd 6625 13% 492 55 0 56 211 1275 472 50 50 1645 920 1400 BMI Leadership, CMAA national & summer

Next Yr Budget 7480 -7% 960 1970 0 30 30 2320 30 30 130 1320 30 630 conferences for GM

8550 UNIFORMS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 45 1233% 0 0 0 0 0 0 45 0 0 0 0 0 for GM


8700 WATER*

Prior Yr Actual 890 53 67 84 80 103 84 97 82 57 60 51 72


This Yr Projctd 1030 2% 25 81 88 87 95 105 100 76 93 93 93 93

Next Yr Budget 1055 4% 50 81 88 87 95 105 100 76 93 93 93 93

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 850054 61020 86222 71079 80340 88960 68248 63413 62038 68198 58864 60876 80796

This Yr Projected 818669 5% 45242 86950 75792 71047 89058 65846 66553 63680 61340 59706 59518 73938

Next Year Budget 858771 1% 62704 85831 80703 85828 81745 72226 68918 61803 61828 59316 59540 78329

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

NET INCOME/(LOSS) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Prior Year Actual 31871 -2254 -3633 -1924 -1123 3941 -3317 -2651 -5174 6304 14049 7790 19863

Current Budget -1835 -775 -725 -725 -425 1975 -775 -325 -775 -775 820 95 575

This Yr Projected 64822 13338 -145 -6780 19241 6227 3813 2844 -17 8483 3078 4381 10361

Next Year Budget -734813 -57999 -80630 -76423 -53204 -51958 -55300 -61845 -57044 -57369 -54407 -55131 -73505

======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =======

*Note 1 = audit fees $20,000, attorney $5,500 retainer/mth plus $250 /mth extra services; Deloitte arbitrage reports $2,000/each (Nov); $2,000 supervisor ballot printing by attorney office(Apr);

Fishkind report $5,000 Sep; US Bank fees $8,550 (allocated/mo); Bond Compliance required Engineering Certification (June) $600, Bond Compliance Fixed Asset survey $2000 Jun; Additional Attorney

work, etc $5,000, Fishkind Dissemination Svcs Feb $1500

Version 3

Total


I N C O M E


Prior Yr Actual 330272 28345 24453 25197 9212 4561 -4491 18850 38422 43801 43124 43718 55081

Current Budget 320411 15946 25209 20762 9339 9063 -11118 16943 39598 44909 45432 44913 59415

This Yr Projctd 320411 -100% 15946 25209 20762 9339 9063 -11118 16943 39598 44909 45432 44913 59415

Next Yr Budget 0 -100%

4410 FOOD SALES-DINING ROOM

Prior Yr Actual 355379 21165 40353 37369 46968 54152 60662 40696 18907 8567 9340 7434 9766 3% increase over actuals

Current Budget 384613 21589 41160 38117 47908 55236 61875 41510 19879 15634 14012 14304 13390 Quarterly menu changes

This Yr Projctd 357312 3% 14928 39188 35174 37288 51458 61171 50347 17443 13719 12295 12552 11749 price adjustment, menu engineering

Next Yr Budget 367459 -4% 15476 40222 36127 38284 52737 62645 51604 18042 14243 12791 13053 12234 & body counts

4430 BEVERAGE SALES-DINING RO


Current Budget 92660 5423 9120 9260 13657 15472 15932 11195 3689 2298 2375 1990 2247 price adjustment, menu engineering

This Yr Projctd 86025 3% 6764 8684 9955 9675 13932 15078 9695 3584 2233 2308 1934 2183 & body counts

Next Yr Budget 88606 -4% 6967 8945 10254 9965 14350 15531 9986 3692 2300 2377 1992 2249

4433 FOOD REVENUE-LOUNGE




Next Yr Budget 321231 1% 27983 26475 26815 34736 38140 45537 31106 25598 15638 14642 17151 17409

4434 BEVERAGE REVENUE-LOUNGE




Next Yr Budget 193876 5% 18387 17144 16094 20746 22560 27063 21205 12902 9318 8019 11148 9290

4550 CATERING FOOD-RESIDENTS


Current Budget 142230 3306 18840 23342 18594 16622 33738 13883 4421 1609 3896 470 3509

This Yr Projctd 141996 3% 2482 17482 15595 18976 26748 26650 20700 4249 1546 3744 452 3372

Next Yr Budget 146256 3% 2556 18006 16063 19545 27550 27450 21321 4376 1593 3857 465 3474

4552 CATERING BEVERAGES- RESI


Current Budget 34563 2153 3761 6964 3393 4969 7476 3469 953 0 300 0 1125

This Yr Projctd 34306 3% 1713 4184 6106 4205 6643 5180 3876 962 0 303 0 1135

Next Yr Budget 35335 2% 1764 4309 6289 4331 6843 5336 3992 990 0 312 0 1169

4570 CATERING FOOD - OUTSIDE

Prior Yr Actual 50515 2883 1130 2361 2577 11073 1509 1323 8749 17992 0 271 646 Based on Budget

Current Budget 40470 10000 2770 2770 2770 2770 2770 2770 2770 2770 2770 2770 2770 One wedding booked in Oct


Next Yr Budget 40473 0% 5010 5010 5010 2827 2827 2827 2827 2827 2827 2827 2827 2827 & body counts

4572 CATERING BEVERAGE- OUTSI

Prior Yr Actual 12697 811 254 457 432 3076 304 183 570 6610 0 0 0

Current Budget 10750 2500 750 750 750 750 750 750 750 750 750 750 750 One wedding booked in Oct

10 - Restaurant: Income Statement


FY 2017-18 Forecast




Total




Next Yr Budget 13776 28% 1672 1672 1672 1672 1672 1672 624 624 624 624 624 624 & body counts

4579 CATERING, OTHER REVENUES

Prior Yr Actual 9591 0 100 0 194 2712 385 175 2356 3668 0 0 0 Based on current year actuals

Current Budget 11000 3000 1000 1000 1000 1000 1000 500 500 500 500 500 500 Revenue from room rent, venue

This Yr Projctd 8008 3582 100 472 1681 244 179 100 900 750 0 0 0 fees, bar setups, etc

Next Yr Budget 8100 1000 1000 1000 1000 1000 1000 350 350 350 350 350 350

TOTAL INCOME ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 1540625 111619 145095 144020 154620 165289 177608 144845 110080 92665 92013 93127 109644


Next Year Budget 1215111 -21% 80816 122784 119324 133106 167679 189060 143015 69403 46893 45798 47609 49626 2.6% overall increase in revenues

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Cost of Revenues

5420 COS, FOOD

Prior Yr Actual 342036 21670 35056 32295 41475 47942 51776 38069 22328 10461 15199 10870 14895

Current Budget 364165 25622 36186 36498 42676 44587 54905 36241 23600 15947 15798 15516 16588 current budget 42%; act YTD 44.21%

This Yr Projctd 377344 -5% 25424 33858 41122 30607 49720 64303 54301 21578 14964 13888 13257 14323 Budgeting for 42% cost of food

Next Yr Budget 359602 -1% 20410 35885 33606 38157 48501 55383 42744 22880 15435 15353 15073 161755430 COS, BEVERAGE

Prior Yr Actual 84347 6578 6711 7281 9311 11451 11659 9554 4353 6165 3857 4025 3401

Current Budget 80773 7154 7105 7753 9398 10939 12616 9200 4384 2955 2743 3309 3217 Current budget 25%; act YTD 25.53%

This Yr Projctd 81298 2% 6429 7614 9391 9190 9249 14591 8537 4393 3007 2624 3189 3085 Budgeting for 25% cost of bev

Next Yr Budget 82898 3% 7198 8017 8577 9179 11356 12400 8952 4552 3060 2833 3441 3333TOTAL COST OF REVENUES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 444938 32777 43291 44251 52074 55527 67521 45441 27985 18901 18542 18824 19805


Next Year Budget 442501 -1% 27607.91 43902.92 42183.33 47335.17 59857.7 67783.69 51695.08 27431.94 18495.8 18185.51 18513.86 19507.77------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------



Current Budget 1095687 78842 101804 99768 102547 109762 110087 99404 82096 73764 73471 74303 89839


Next Year Budget 772611 -29% 53208.14 78880.59 77140.73 85770.64 107820.9 121276.1 91319.91 41970.6 28396.71 27612.84 29095.31 30118.24------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

E X P E N S E S 40% 40% 40% 40% 40% 40% 40% 45% 45% 45% 45% 45% Food Cost%

6150 PAYROLL KITCHEN 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% Bev Cost%

Prior Yr Actual 258171 19298 22727 24775 27138 26726 25372 24491 21077 15722 18604 16348 15893 3% increase to bring wages up to

Current Budget 273643 19684 23181 25486 27896 27476 26095 25196 21954 18643 19747 18643 19642 the prevailing wage as determined

This Yr Projctd 270708 3% 19865 25162 26019 25389 22678 28449 24520 21954 18643 19747 18643 19642 by the Dept of Labor for Lee County

Next Yr Budget 279504 2% 20181 26312 27169 26539 23828 29599 25670 19770 18959 20063 18959 22458 staying bonus for chef moved from May to Sep

6155 PAYROLL, KITCHEN, OT

Prior Yr Actual 4556 0 589 -173 9 1048 431 2718 -72 0 6 0 0 Based on current budget

Current Budget 4200 200 650 200 100 1000 50 2000 0 0 0 0 0

This Yr Projctd 19401 -78% 452 1887 2220 2046 4341 3921 4534 0 0 0 0 0


Total



Next Yr Budget 4200 0% 200 650 200 100 1000 50 2000 0 0 0 0 0

6180 PAYROLL, SERVICE

Prior Yr Actual 259325 18609 23274 21058 24807 24926 28101 21395 21357 16797 19715 18558 20727

Current Budget 270530 18981 23740 21643 25467 25588 28826 21986 21907 20321 19473 19281 23320 3% increase only for FT

This Yr Projctd 267523 3% 20364 22194 23555 24206 23699 25454 23748 21907 20321 19473 19281 23320 Based on projected year budget

Next Yr Budget 274349 1% 20875 22760 24162 24832 24310 26118 24361 19964 20831 19957 19759 26420

staying bonus for F&B Mgr moved from May to

Sep

6185 PAYROLL, SERVICE, OT

Prior Yr Actual 501 0 132 -49 5 296 110 -30 0 0 0 0 37

Current Budget 450 0 0 0 50 100 250 50 0 0 0 0 0 Based on this year's budget

This Yr Projctd 2768 -84% -11 152 176 80 622 1241 508 0 0 0 0 0

Next Yr Budget 450 0% 0 0 0 50 100 250 50 0 0 0 0 0


Prior Yr Actual 151589 9355 19391 17038 13219 14585 16027 13023 9590 19254 9282 5601 5225

Current Budget 154354 9954 20860 20925 14243 14713 15951 12932 10117 8507 8514 8335 9303

This Yr Projctd 124691 11% 8292 9589 12141 13745 12667 13176 10305 10117 8507 8514 8335 9303


Prior Yr Actual 47801 2539 4700 4187 4187 4191 4188 4188 4201 3998 3802 3809 3809 Budgeted for 10 FT positions

Current Budget 54165 4144 4144 4144 4637 4637 4637 4637 4637 4637 4637 4637 4637 Assume 8% increase health rates

This Yr Projctd 50666 31% 3734 4077 3393 3905 4074 4148 4150 4637 4637 4637 4637 4637 Slightly underfunded

Next Yr Budget 66542 23% 5545 5545 5545 5545 5545 5545 5545 5545 5545 5545 5545 55456250 H-2B ADDITIONAL EXPENSES

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 Note#1

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 This yr projected does not include May

This Yr Projctd 16524 43% 2692 5347 5493 2065 52 -253 1129 0 0 0 0 0 final expenses for travel & apt move-out and

Next Yr Budget 23670 #DIV/0! 3250 5585 5585 0 0 1200 0 3750 200 3700 200 200 July Newspress ads for the following season

6300 ADVERTISING

Prior Yr Actual 7569 999 550 825 500 1099 1545 990 510 500 0 25 25 The Wedding Wire

Current Budget 4800 400 400 400 400 400 400 400 400 400 400 400 400

This Yr Projctd 4438 8% 348 348 348 348 348 348 348 400 400 400 400 400

Next Yr Budget 4800 0% 400 400 400 400 400 400 400 400 400 400 400 400

6500 CASUAL LABOR

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 kitchen temps for banquets

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 previously expensed directly to payroll

This Yr Projctd 1236 -39% 0 0 0 0 228 703 306 0 0 0 0 0 GL line item



Prior Yr Actual 4733 390 274 459 424 595 492 515 434 274 503 226 149 chemicals for kitchen dishmachine used

Current Budget 6200 517 517 517 517 517 517 517 517 517 517 517 517 to be included in lease. Last year not

This Yr Projctd 7052 -12% 685 518 576 588 662 632 809 517 517 517 517 517 included in lease and estimated cost was

Next Yr Budget 6200 0% 517 517 517 517 517 517 517 517 517 517 517 517 too low


Prior Yr Actual 5487 252 353 467 993 809 684 524 369 242 230 258 304

Current Budget 4200 250 375 475 850 700 650 300 200 100 100 100 100

This Yr Projctd 3676 2% 213 437 357 499 566 441 562 200 100 100 100 100

Next Yr Budget 3750 -11% 200 425 350 500 550 425 550 350 100 100 100 100


Total




Prior Yr Actual 4178 2100 0 0 265 0 0 0 55 1200 -820 1378 0 CMAA summer conf Jun, Jul or Aug $400

Current Budget 2375 0 0 0 0 0 0 0 0 0 375 0 2000 Scott BMI education Sep $2000

This Yr Projctd 2375 35% 0 0 0 0 0 0 0 0 0 375 0 2000 food safety training $800

Next Yr Budget 3200 35% 800 0 0 0 0 0 0 0 400 0 0 2000

6750 DISHES & GLASSWARE

Prior Yr Actual 9433 29 162 555 338 1283 697 1049 833 4487 0 0 0

Current Budget 2600 217 217 217 217 217 217 217 217 217 217 217 217 silverware, china & glasswear replacement

This Yr Projctd 1903 58% 0 0 277 31 170 341 0 217 217 217 217 217

Next Yr Budget 3000 15% 2100 0 0 500 0 0 200 0 0 200 0 0


Prior Yr Actual 795 695 0 0 100 0 0 0 0 0 0 0 0 FLCMAA dues for F&B mgr Nov $495

Current Budget 1995 695 0 0 100 0 0 0 0 1200 0 0 0 NFM Chamber Jan $100

This Yr Projctd 1695 -15% 0 495 0 0 0 0 0 0 1200 0 0 0 Nat'l CMAA dues Aug $850

Next Yr Budget 1445 -28% 0 495 100 0 0 0 0 0 0 850 0

6900 ELECTRIC*

Prior Yr Actual 43025 3503 3646 3716 3514 4072 3638 3583 3254 3468 3600 3548 3483


This Yr Projctd 41420 0% 3431 3114 3106 3456 3482 3181 3317 3605 3682 3682 3682 3682

Next Yr Budget 41420 -6% 3431 3114 3106 3456 3482 3181 3317 3605 3682 3682 3682 3682

6901 EMPLOYEE MEALS

Prior Yr Actual 3850 425 584 475 592 499 463 -10 153 117 84 448 18 Based on actuals

Current Budget 3762 114 536 498 503 536 507 498 114 114 114 114 114 Cost of tracking employee meals to

This Yr Projctd 3184 0% 449 380 361 366 380 307 371 114 114 114 114 114 FOH & BOH staff when working

Next Yr Budget 3184 -15% 449 380 361 366 380 307 371 114 114 114 114 114 doubles; offset by pd emp meals

6948 ENTERTAINMENT-DINING ROO

Prior Yr Actual 5845 0 1075 990 800 990 780 790 420 0 0 0 0 Start Sunday brunch in Nov

Current Budget 5190 800 915 480 640 640 640 800 275 0 0 0 0 Michael Moore-Kelly $160@

This Yr Projctd 4505 7% 0 915 480 640 640 640 915 275 0 0 0 0 $275 holidays (Thanksgiving, Mother's Day

Next Yr Budget 4825 -7% 0 915 640 640 640 640 915 435 0 0 0 0 and Easter)

6949 ENTERTAINMENT LOUNGE

Prior Yr Actual 16150 1650 1050 950 1500 1350 1300 1400 1400 1600 1350 1050 1550 Based on entertainment schedule

Current Budget 17300 1350 1000 1650 1400 1350 1650 1450 1350 1750 1250 1750 1350 provided by Resident Events

This Yr Projctd 17000 2% 1350 1000 1650 1450 1350 1650 1500 1350 1750 1250 1350 1350 Entertainment for shutdown week will

Next Yr Budget 17400 1% 1400 1500 1200 1400 1450 1850 1400 1300 1500 1300 1700 1400 be dropped when we know when it is

6950 ENTERTAINMENT/DECORATION

Prior Yr Actual 8932 878 1810 361 380 954 442 1882 354 863 326 449 235 includes entertainment for Season

Current Budget 8606 878 1810 361 380 954 442 1882 500 300 500 300 300 Opener, Season Finale, Mens & Ladies

This Yr Projctd 3852 99% 275 -625 -65 421 108 1104 735 500 300 500 300 300 Nights, Christmas Dinner Show

Next Yr Budget 7650 -11% 900 1800 1200 500 200 500 1000 200 750 200 200 200 Helium Oct $700 , Dec $700

7225 GRATIS / Food & Beverage

Prior Yr Actual 5152 634 770 439 325 508 825 317 194 293 254 252 342

Current Budget 5817 634 770 439 325 508 825 317 400 400 400 400 400 Cost of bar snacks and popcorn

This Yr Projctd 5066 -11% 339 466 237 528 488 581 426 400 400 400 400 400

Next Yr Budget 4500 339 466 237 528 488 581 426 293 293 254 252 342

7300 INSURANCE

Prior Yr Actual 14709 1198 1198 1198 1198 1240 1240 1240 1240 1240 1240 1240 1240

Current Budget 14500 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 Est 4.6% increase over actuals plus


Total



This Yr Projctd 14500 0% 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 increase for assessed value on new

Next Yr Budget 14500 0% 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 appraisal to be done FY17

7450 LEASE

Prior Yr Actual 8323 702 601 599 601 742 681 742 740 750 697 771 697 2 dishmachine leases $345/mth

Current Budget 8172 681 681 681 681 681 681 681 681 681 681 681 681 ice machines 200/mth

This Yr Projctd 8472 1% 697 697 697 709 709 709 709 709 709 709 709 709

NuCo $164.38 CO2 Tank Lease (Inc property tax

in Dec)

Next Yr Budget 8561 5% 709 709 759 709 709 709 709 709 709 709 709 709


Prior Yr Actual 5092 0 357 423 0 1910 10 2346 46 0 0 0 0

BMI Apr $2008, SEASAC Jan $397, ASCAP Mar

$342

Current Budget 5260 0 357 343 0 1800 451 2309 0 0 0 0 0

DBPR Business License Nov $357, Liquor

license Mar $1920

This Yr Projctd 3063 75% 0 357 0 397 0 2262 46 0 0 0 0 0

Motion Picture License Aug $300, Van

registration Apr $46

Next Yr Budget 5370 2% 357 0 397 0 2262 2054 0 0 0 300 0

7550 LINEN

Prior Yr Actual 22967 1275 2072 1942 2496 3002 3571 2393 1599 1510 956 839 1311

Current Budget 23752 1275 2072 1942 2496 3002 3571 2393 1500 1600 1300 1300 1300 Based on current year actuals

This Yr Projctd 25102 -2% 2088 2392 2700 2227 2609 3601 2486 1500 1600 1300 1300 1300 Tablecloths in Dining Room

Next Yr Budget 24522 3% 2088 2392 2700 2227 2609 3601 2486 1599 1510 1000 1000 1311


Prior Yr Actual 8713 927 1005 583 383 1258 0 784 1552 -4 0 533 1693

Current Budget 9600 800 800 800 800 800 800 800 800 800 800 800 800 Cost of cooler/freezer repairs

This Yr Projctd 13264 -28% 864 352 1833 2367 0 2921 927 800 800 800 800 800

Next Yr Budget 9600 0% 800 800 800 800 800 800 800 800 800 800 800 800

7751 MEMBER REWARDS-FOOD

Prior Yr Actual 54638 4385 5757 5089 6099 6811 8364 5794 3135 2330 2567 1674 2634

Current Budget 56203 4055 5502 5204 6818 7357 8050 5909 3616 2482 2272 2496 2444 actual YTD 74.71%

This Yr Projctd 51868 -1% 3737 5447 5143 5435 6376 7638 6003 3292 2245 2058 2268 2225

Next Yr Budget 51452 -8% 3247 4983 4702 5455 6789 8082 6179 3260 2232 2050 2256 22157752 MEMBER REWARDS-BEVERAGE

Prior Yr Actual 24128 2049 2228 1980 2688 3057 3363 2667 1341 1340 1209 917 1289

Current Budget 23195 2001 1996 1945 2793 3176 3527 2720 1322 924 829 1042 918 actual YTD 81.18%

This Yr Projctd 22615 1% 1993 2285 2165 2533 2784 3266 2458 1345 942 843 1065 935

Next Yr Budget 22932 -1% 2058 2118 2139 2493 2996 3458 2532 1347 943 844 1067 9377850 OFFICE SUPPLIES

Prior Yr Actual 8128 202 468 97 545 848 458 198 504 169 32 4401 205

Current Budget 2100 175 175 175 175 175 175 175 175 175 175 175 175

This Yr Projctd 3455 4% 407 694 392 568 95 0 424 175 175 175 175 175

Next Yr Budget 3600 71% 300 300 300 300 300 300 300 300 300 300 300 300

7950 PROPANE GAS

Prior Yr Actual 17847 1302 1385 1961 951 2858 1964 1479 1279 1450 1084 903 1232

Current Budget 18794 1367 1454 2059 998 3001 2062 1552 1260 1260 1260 1260 1260

This Yr Projctd 14594 15% 1218 516 2000 495 267 2006 1793 1260 1260 1260 1260 1260

Next Yr Budget 16794 -11% 1367 1454 2059 998 1001 2062 1552 1260 1260 1260 1260 1260

8130 RESIDENT EVENT DECORATIO


Total



Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 Resident event parties

This Yr Projctd -2523 -928 -40 -1039 343 -895 -353 389 0 0 0 0 0

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

8150 REFUSE

Prior Yr Actual 7637 592 636 636 636 636 636 636 636 636 636 636 687

Current Budget 8086 665 665 665 665 665 665 665 687 687 687 687 687 1% increase

This Yr Projctd 8240 1% 687 687 687 687 687 687 687 687 687 687 687 687

Next Yr Budget 8322 3% 693 693 693 693 693 693 693 694 694 694 694 694

8200 RENTAL

Prior Yr Actual 56 0 0 0 0 0 0 0 0 0 0 0 56

Current Budget 1000 0 0 0 0 0 0 0 0 0 0 1000 0 silverware, glasses, chairs

This Yr Projctd 1186 0 0 0 0 186 0 0 0 0 0 1000 0

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 0


Prior Yr Actual 7377 242 242 1094 1140 642 142 837 845 142 837 256 959 Direct TV 165/mth Jan-Aug, $270 Sep-Dec

Current Budget 9465 635 835 135 1250 835 135 635 1450 135 635 2035 750 grease traps 700/qtr, hood cleaning

This Yr Projctd 10322 11% 1071 799 262 2050 119 161 856 1450 135 635 2035 750

3x/yr $755, Preventative Maint on kitchen equip

$656.25 2X/yr

Next Yr Budget 11478 21% 970 1470 270 1620 665 821 865 1420 165 865 665 1681

TWC Services prev maint coolers/freezers

$500/qtr (Oct, Jan, Apr & Jul)

8351 SMALL EQUIPMENT-KITCHEN

Prior Yr Actual 8622 164 135 237 0 0 0 984 101 7000 0 0 0

Current Budget 9900 75 75 75 75 75 75 75 75 75 75 75 9075 various kitchen equipment

This Yr Projctd 7232 9% 0 0 0 0 0 0 57 75 75 75 75 6875 replacement from capital

Next Yr Budget 7900 -20% 75 75 75 75 75 75 75 75 75 75 75 7075

8400 SUPPLIES

Prior Yr Actual 20257 1854 2012 2195 2228 2724 2666 2081 947 797 712 1226 815

Current Budget 24000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 Based on prior year actuals

This Yr Projctd 24875 -18% 1500 1975 1416 2039 3088 2628 2229 2000 2000 2000 2000 2000

Next Yr Budget 20500 -15% 2000 2000 2100 2200 2500 2500 2200 1000 1000 1000 1000 1000

8450 TELEPHONE*

Prior Yr Actual 2404 180 181 181 181 182 182 184 184 236 237 237 238

Current Budget 2700 225 225 225 225 225 225 225 225 225 225 225 225

This Yr Projctd 2854 0% 237 237 238 238 238 238 238 238 238 238 238 238

Next Yr Budget 2854 6% 237 237 238 238 238 238 238 238 238 238 238 238

8500 TRAVEL

Prior Yr Actual 3735 690 0 0 0 64 0 1954 310 225 0 0 493 BMI education in September

Current Budget 3000 75 75 75 75 75 75 75 75 75 700 75 1550 CMAA summer conference

This Yr Projctd 2250 20% -225 0 0 0 0 0 0 75 700 75 75 1550 food show & educational mtgs

Next Yr Budget 2700 -10% 0 0 0 0 0 0 0 0 700 0 0 2000

8550 UNIFORMS

Prior Yr Actual 5134 864 135 840 828 284 252 301 374 151 248 174 683

Current Budget 3500 750 250 250 250 250 250 250 250 250 250 250 250 purchasing black polo shirts

This Yr Projctd 2461 42% 264 351 29 337 46 135 48 250 250 250 250 250 & kitchen chef coats

Next Yr Budget 3500 0% 750 250 250 250 250 250 250 250 250 250 250 250 chef & sous chef coat cleaning

8700 WATER*

Prior Yr Actual 8902 535 675 836 799 1031 843 968 818 570 599 506 724


Total




This Yr Projctd 8399 1% 251 806 884 874 952 1054 995 579 400 449 618 536

Next Yr Budget 8448 2% 300 806 884 874 952 1054 995 579 400 449 618 536

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 1095687 78842 101804 99768 102546 109762 110087 99404 82096 73764 73471 74303 89839


Next Year Budget 1112889 2% 87358 103555 103651 100006 98876 115381 103794 80331 74407 76410 73181 95939

NET INCOME/(LOSS) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Prior Year Actual 67304 2520 341 -1328 2224 9772 8169 5042 3444 11301 6229 -4582 24171

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projected -34303 -3712 1823 -10930 1078 18735 -23813 -7689 -1786 -1240 -2409 -3055 -1305

Next Year Budget -340278 -34149 -24675 -26510 -14236 8945 5895 -12474 -38360 -46010 -48797 -44086 -65821

FY 2018 Budgeted COS Food % 42% 40% 40% 40% 40% 40% 40% 40% 45% 45% 45% 45% 45%

FY 2018 Budgeted COS Bev % 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25%

FY 2018 Budg Operating Revenue 1215111 80816 122784 119324 133106 167679 189060 143015 69403 46893 45798 47609 49626

FY 2018 Budg COGS 442501 27608 43903 42183 47335 59858 67784 51695 27432 18496 18186 18514 19508

FY 2018 Budg Operating Expenses 1112889 87358 103555 103651 100006 98876 115381 103794 80331 74407 76410 73181 95939

FY 2018 Budg Operating Loss -340278 -34149 -24675 -26510 -14236 8945 5895 -12474 -38360 -46010 -48797 -44086 -65821

FY 2018 Assessment 0 0 0 0 0 0 0 0 0 0 0 0 0

FY 2018 Budg Net Income(Loss) -340278 -34149 -24675 -26510 -14236 8945 5895 -12474 -38360 -46010 -48797 -44086 -65821

FY 2017 Budg Operating Revenue 1220213 95673 119886 123258 145281 156225 188726 127902 70482 47756 46581 48214 50229

FY 2017 Budg COGS 444938 32777 43291 44251 52074 55527 67521 45441 27985 18901 18542 18824 19805

FY 2017 Budg Operating Expenses 1095687 78842 101804 99768 102546 109762 110087 99404 82096 73764 73471 74303 89839

FY 2017 Budg Operating Loss -320411 -15946 -25209 -20762 -9339 -9063 11118 -16943 -39598 -44909 -45432 -44913 -59415

FY 2017 Assessment 320411 15946 25209 20762 9339 9063 -11118 16943 39598 44909 45432 44913 59415

FY 2017 Budg Net Income(Loss) 0 0 0 0 0 0 0 0 0 0 0 0 0

FY 2017 Proj Operating Revenue 1175764 89742 112305 117757 133805 163665 180422 137870 66423 46033 41357 42217 44167

FY 2017 Proj COGS 458642 31853 41472 50512 39796 58969 78894 62838 25971 17971 16511 16446 17408

FY 2017 Proj Operating Expenses 1071837 77548 94220 98936 102269 95024 114224 99663 81836 74211 72687 73739 87479

FY 2017 Proj Operating Loss -354714 -19658 -23386 -31691 -8260 9672 -12695 -24632 -41384 -46150 -47841 -47968 -60720

FY 2017 Assessment 320411 15946 25209 20762 9339 9063 -11118 16943 39598 44909 45432 44913 59415

FY 2017 Proj Net Income(Loss) -34303 -3712 1823 -10930 1078 18735 -23813 -7689 -1786 -1240 -2409 -3055 -1305

Note#1 iStorage $200/mo, Pabian Law $11,170 (split between Nov & Dec), Newspress ads Jul $3500, Henry (Recruiting) Mar $150pp ($1200/1500), Travel Airfair $200pp + $50 baggage Oct & May,

$500 (van rental to/from airport, gas, parking, food, tolls), Apt moving $550 Oct May, Apt Cleaning $500 May


Total

Year Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep NotesE X P E N S E S

6100 PAYROLL

Prior Yr Actual 450627 36807 36439 40434 38893 33989 36215 35849 41462 36366 39393 36769 38010 Maintain 16.5 employees Oct-April

Current Budget 473434 38843 37492 38843 38843 34819 38919 37712 43748 39472 43648 41238 39857 Increase to 17.5 May-Sept

This Yr Projctd 472842 1% 39500 37900 39412 39210 34057 37285 37513 43748 39472 43648 41238 39857 Underfund proj turnover = 2 employee


Prior Yr Actual 24520 1704 2576 470 1424 1403 1638 2669 3118 1624 2159 3566 2170

Current Budget 12915 951 951 951 951 951 951 951 1251 1251 1251 1251 1251 Increased amount May-Sept for

This Yr Projctd 27902 -54% 2380 2971 1529 2469 2447 2867 1983 2251 2251 2251 2251 2251 summer renovation work

Next Yr Budget 12915 0% 951 951 951 951 951 951 951 1251 1251 1251 1251 12516200 PAYROLL TAXES & FEES

Prior Yr Actual 74694 8986 7966 7772 7097 4271 5551 5397 6096 5339 5484 5334 5402

Current Budget 76160 9415 8221 7563 6696 5035 5349 5188 6027 5438 6183 5615 5432

This Yr Projctd 72328 5% 5440 5411 8308 7013 5918 5990 5554 6027 5438 6183 5615 5432

Next Yr Budget 76077 0% 5226 5047 5226 9443 7856 7709 6647 5594 5540 5735 5700 63546202 PAYROLL BENEFITS

Prior Yr Actual 49764 2796 4725 4725 4725 4475 4217 4288 4288 4066 4214 3815 3430 Assume 8% increase health rates

Current Budget 59902 4992 4992 4992 4992 4992 4992 4992 4992 4992 4992 4992 4992 Assume 12 out of 16 will take it

This Yr Projctd 60105 37% 4407 4414 5608 5066 5718 5002 4931 4992 4992 4992 4992 4992 Previously underfunded by 7 people

Next Yr Budget 82327 37% 6861 6861 6861 6861 6861 6861 6861 6861 6861 6861 6861 6861 Superintendent vehicle allowance

6500 CASUAL LABOR

Prior Yr Actual 9227 0 0 0 0 0 1154 0 1063 662 1118 4195 1035

Current Budget 4240 0 0 0 0 0 0 0 848 848 1696 848 0 Additional labor during summer

This Yr Projctd 4859 -7% 0 0 0 0 0 0 619 848 848 1696 848 0 aerifications

Next Yr Budget 4500 0 0 0 0 0 0 0 900 900 900 1800 0

6550 CHEMICALS

Prior Yr Actual 135948 10510 6291 6721 7654 6422 13056 8797 37649 11758 12686 6985 7419 Oct, Apr & July pre-emergent

Current Budget 135150 10500 7000 7000 7200 7500 12200 7200 26675 7200 12275 23200 7200 May mole cricket

This Yr Projctd 143740 1% 14160 8309 6833 9297 7220 15057 6315 26675 7200 12275 23200 7200 Nematode control for greens and tees

Next Yr Budget 145200 7% 24000 7000 7000 7200 7500 21200 7200 27000 7200 13000 7200 9700 needed in Aug, Indemnify Oct, Sep & Mar


Prior Yr Actual 1944 420 100 0 660 0 65 99 0 75 0 450 75 Nat'l conf in Feb; State conf in Sept

Current Budget 1810 125 0 125 660 0 100 100 150 0 150 400 0 Various local education seminars

This Yr Projctd 1930 17% 200 0 100 645 95 190 0 150 0 150 400 0 Golf course irrigation show Oct

Next Yr Budget 2264 25% 479 0 100 95 650 190 0 300 0 50 0 400


Prior Yr Actual 1135 0 375 0 0 0 190 0 0 570 0 0 0

Current Budget 1635 0 375 0 0 0 190 0 0 0 1070 0 0 Renewal of membership to GCSAA, FTGA,

This Yr Projctd 1635 -36% 0 0 0 0 190 375 0 0 0 1070 0 0 and EGCSAA for Super and Assistant

Next Yr Budget 1040 -36% 0 0 750 0 0 0 0 145 145 0 0

30 - Golf Maintenance: Income Statement


FY 2017-18 Forecast




Total



6900 ELECTRIC*

Prior Yr Actual 28386 1725 2590 2088 2253 1598 1753 2934 2756 2954 2948 2473 2314


This Yr Projctd 28361 3% 2346 2790 2553 2502 2028 -768 2397 3128 2883 2883 2528 3092

Next Yr Budget 29287 -1% 2346 2500 2300 2300 2000 2000 2397 2756 2954 2948 2473 2314

6951 EQUIPMENT RENTAL

Prior Yr Actual 2799 0 0 0 0 0 0 0 0 0 0 892 1908 Roller, core harvestor, fairway aerifier

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 1000 0% 0 0 0 0 0 0 0 0 0 0 1000 0


7100 FERTILIZER

Prior Yr Actual 92513 14737 4097 6748 4844 5002 14394 4241 6103 5010 16826 5195 5317 Additional liquid fertilizer on tees & fairways Nov - Apr

Current Budget 98250 14800 4900 6200 6200 6200 15100 5500 5500 5500 17350 5500 5500 Wall-to-wall fertilizations in

This Yr Projctd 98410 0% 14944 5075 5339 7077 6369 15448 4808 5500 5500 17350 5500 5500 Oct, March & July

Next Yr Budget 98410 0% 14944 5075 5339 7077 6369 15448 4808 5500 5500 17350 5500 5500 Fertilizer costs haven't increased

7150 FIELD SUPPLIES

Prior Yr Actual 20537 7132 1468 925 470 558 1448 1820 981 3075 1093 1111 457 Increased amount in Oct to replace

Current Budget 18004 8654 850 850 850 850 850 850 850 850 850 850 850 flags, flagsticks, cups

This Yr Projctd 23316 -13% 9361 1665 2974 1755 1043 1833 435 850 850 850 850 850 Watercooler #11

Next Yr Budget 20300 13% 7200 1400 2000 1000 1000 1000 850 850 2500 1000 1000 500

7200 GASOLINE

Prior Yr Actual 15230 2224 1812 2810 742 1096 1152 3353 2939 -5710 1613 1866 1333

Current Budget 31845 2374 1962 2960 1150 1245 1301 3353 3500 3500 3500 3500 3500 Based on current actuals from FY17 thru

This Yr Projctd 32923 -24% 1937 1407 3469 2002 1182 2297 1628 3800 3800 3800 3800 3800 Apr + $150/mo and actuals from FY16 May-Sep

Next Yr Budget 24894 -22% 2087 1557 3619 2152 1332 2447 1778 2789 1871 1763 2016 1483 +$150/mo

7300 INSURANCE

Prior Yr Actual 23535 1917 1917 1917 1917 1983 1983 1983 1983 1983 1983 1983 1983




7350 IRRIGATION

Prior Yr Actual 24145 1863 893 500 1494 1808 4822 1867 3089 2630 1814 3365 0 costs to replace green and

Current Budget 18000 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 slope heads that are failing at a rate

This Yr Projctd 13069 22% 815 275 835 946 2632 0 67 1500 1500 1500 1500 1500 of 3-4/mo remains the same

Next Yr Budget 16000 -11% 1333 1333 1333 1333 1333 1333 1333 1333 1333 1333 1333 1333


Prior Yr Actual 20903 3879 6946 4404 1160 668 1063 1250 0 876 28 649 -20 Palmetto trimming in Def Maint

Current Budget 26000 8200 8800 5400 400 400 400 400 400 400 400 400 400 Pinestraw, coral rock & Annuals

This Yr Projctd 20724 25% 8490 5508 4775 0 201 0 -250 400 400 400 400 400 Cost of pinestraw is up

Next Yr Budget 26000 0% 8500 4800 5500 400 400 400 400 4000 400 400 400 400

7450 LEASE

Prior Yr Actual 207649 15646 18500 18500 18500 18500 18500 18500 18500 20255 15771 15771 10706

1 leases ending in 17-18 (Oct), 2 leases ending 18-19

FY, , 1 lease ending 19-20 FY

Current Budget 176153 14546 13219 13219 13219 13219 15802 15802 15802 15332 15332 15332 15332

1 lease ending 20-21, Attached revised 5 yr

replacement plan


Total



This Yr Projctd 164166 -12% 13259 12796 12796 12796 12796 12796 12796 12802 15332 15332 15332 15332

Capital Lease security cameras - 5yr plan lease to

own including maintenance $135.39/mo

Next Yr Budget 145207 -18% 14893 10692 10692 10692 10692 10692 10692 10692 13867 13867 13867 13867

Adding new 2017-18 GCM lease of $3,174.18/mo in

Jun


Prior Yr Actual 4797 390 563 74 0 2220 0 0 512 0 0 0 1038

Current Budget 3400 200 200 200 200 1200 200 200 200 200 200 200 200 Annual wash station cleanup in Feb

This Yr Projctd 3736 -9% 0 50 0 776 1726 132 53 200 200 200 200 200

Next Yr Budget 3400 0% 200 200 200 200 1200 200 200 200 200 200 200 200

7655 MAINTENANCE, EQUIPMENT

Prior Yr Actual 65976 6458 5099 4171 3685 8162 2959 4767 6674 5381 5249 6671 6700

Current Budget 56350 4550 4550 4550 4550 4550 4550 4550 4900 4900 4900 4900 4900 Repair cost levels stay low with

This Yr Projctd 63327 -1% 7852 6690 5345 4964 6457 3916 3604 4900 4900 4900 4900 4900 proper equipment replacement plan

Next Yr Budget 62950 12% 5100 5100 5100 5100 5100 5100 5100 5450 5450 5450 5450 5450


Prior Yr Actual 2052 91 74 417 32 250 181 67 147 71 0 385 337

Current Budget 1500 125 125 125 125 125 125 125 125 125 125 125 125

This Yr Projctd 1295 16% 80 0 414 0 133 0 42 125 125 125 125 125

Next Yr Budget 1500 0% 125 125 125 125 125 125 125 125 125 125 125 125

8150 REFUSE

Prior Yr Actual 5973 406 525 278 203 528 1503 203 203 853 103 853 314 1% increase

Current Budget 8484 833 530 530 530 530 530 833 833 833 833 833 833 Garbage, recycling, horticultural waste

This Yr Projctd 9013 1% 539 289 1514 214 864 864 564 833 833 833 833 833 $500 in Dec for extra pick-up

Next Yr Budget 9103 7% 544 292 1529 216 872 872 569 842 842 842 842 842


Prior Yr Actual 26797 2233 1873 2470 1754 1540 1202 3951 1043 2380 1089 3348 3915 Sprigs to rebuild nursery green, Oct potting soil

Current Budget 29400 2500 2200 2500 1800 1600 1600 2600 2600 3000 3000 3000 3000 for annuals, Nov & Dec sand for bunkers

This Yr Projctd 26599 9% 1875 1191 3647 1952 884 1443 1007 2600 3000 3000 3000 3000 topdressing sand for course and

Next Yr Budget 29000 -1% 2500 2200 2500 1800 1600 1600 2600 2600 3000 3000 3600 2000 crushed rock to repair cart paths


Prior Yr Actual 18793 10058 1348 748 835 763 763 763 763 763 763 763 463 Hoover pumping maint agreements

Current Budget 18460 10100 760 760 760 760 760 760 760 760 760 760 760 $263/mth Rainbird irr support

This Yr Projctd 17251 11% 8573 763 1063 763 763 763 763 760 760 760 760 760 $300/mth new equip wash station serv agreemt

Next Yr Budget 19116 4% 10723 763 763 763 763 763 763 763 763 763 763 763

$200/mth Golf Safety, USGA Course Consulting Svc

every 2 yrs $2150

8350 SMALL TOOLS

Prior Yr Actual 2268 516 174 551 104 99 322 458 -647 2084 -1394 0 0 weedeaters, edgers, blowers, etc

Current Budget 6600 550 550 550 550 550 550 550 550 550 550 550 550 same as current budget

This Yr Projctd 4814 37% 447 313 465 205 374 0 260 550 550 550 550 550

Next Yr Budget 6600 0% 550 550 550 550 550 550 550 550 550 550 550 550

8450 TELEPHONE*

Prior Yr Actual 4341 411 241 241 491 442 240 719 333 501 241 241 241

Current Budget 2940 245 245 245 245 245 245 245 245 245 245 245 245 Includes $50 cell reimbursement for Tim & Kevin

This Yr Projctd 2911 1% 240 241 106 241 232 241 386 245 245 245 245 245

Next Yr Budget 2940 0% 245 245 245 245 245 245 245 245 245 245 245 245

8500 TRAVEL


Total



Prior Yr Actual 3645 511 0 0 187 1934 28 0 218 140 0 98 529

Current Budget 2600 50 50 50 50 1550 50 50 50 50 50 50 550 Feb GCSAA nat'l conf

This Yr Projctd 1462 122% 0 0 0 0 712 0 0 50 50 50 50 550 Sept FTGA state conf

Next Yr Budget 3250 25% 50 50 50 50 2000 50 50 250 50 50 50 550

8550 UNIFORMS

Prior Yr Actual 10654 1929 581 584 897 580 648 819 1695 847 713 590 772

Current Budget 8980 1300 580 725 580 580 725 1300 580 725 580 725 580

This Yr Projctd 9053 -13% 1316 1095 830 609 607 725 680 580 725 580 725 580

Next Yr Budget 7880 -12% 1500 580 580 580 580 580 580 580 580 580 580 580

8700 WATER*

Prior Yr Actual 4484 426 453 333 350 398 376 475 323 306 442 310 291


This Yr Projctd 4131 4% 158 377 311 321 359 386 380 408 358 358 358 358

Next Yr Budget 4306 -7% 333 377 311 321 359 386 380 408 358 358 358 358

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 1329518 139437 105028 104192 96589 92331 111051 100102 127555 102845 126614 120833 102941


Next Year Budget 1337257 1% 151872 97516 104807 100637 97427 121885 94899 125021 104097 121658 106200 111238


Total


4210 MEMBERSHIP FEES

Prior Yr Actual 1299053 104882 106149 107022 108186 108285 108661 108841 109018 109502 109502 109502 109502 Maxed out at 613 members this yr; Budget

Current Budget 1280817 100172 102784 106376 107943 107943 107943 107943 107943 107943 107943 107943 107943 maxes out at 606 members

This Yr Projctd 1289590 -2% 104193 105657 106287 108393 108710 108710 107926 107943 107943 107943 107943 107943

Next Yr Budget 1268786 -1% 99051 101711 105366 106962 106962 106962 106962 106962 106962 106962 106962 1069624230 RANGE MEMBERSHIP

Prior Yr Actual 6124 342 433 458 541 541 544 544 544 544 544 544 544

Current Budget 6876 573 573 573 573 573 573 573 573 573 573 573 573

This Yr Projctd 6975 8% 444 419 501 685 687 687 687 573 573 573 573 573

Next Yr Budget 7545 10% 444 419 501 685 687 687 687 687 687 687 687 687

4231 MEMBER GUEST FEES

Prior Yr Actual 102064 5305 6475 8255 12200 26823 26445 10070 2040 1375 1300 950 825

Current Budget 120423 5265 6422 8342 22440 26792 28017 10020 2625 2625 2625 2625 2625 Budgted 9% over prior years' actuals

This Yr Projctd 118548 1% 3560 8153 12581 15888 31043 23143 11055 2625 2625 2625 2625 2625

Next Yr Budget 120207 0% 6302 7558 10128 22483 26792 27955 10152 3166 1525 1697 1225 12254260 PUBLIC PLAY FEES

Prior Yr Actual 121004 3115 5420 5795 11952 29760 24002 6571 9168 6679 8378 4827 5339 Based on 36 set asides; an increase of 4/wk

Current Budget 116270 5375 6930 5700 14750 29640 22232 6518 7125 4500 4500 4500 4500 from the current budget

This Yr Projctd 141993 0% 6817 9800 7220 19811 36352 29738 7131 7125 4500 4500 4500 4500 No set asides on Wed or Fri

Next Yr Budget 142249 22% 6850 9500 6460 18220 35352 27738 6824 7705 6600 7200 4500 53004270 RESIDENT NON-MEMBER FEES

Prior Yr Actual 124033 5274 9571 12264 18568 17893 25125 17507 5372 2575 4122 1611 4151

Current Budget 133490 5320 9936 12665 21250 20405 27143 19765 4950 3014 3014 3014 3014 Based on current actuals

This Yr Projctd 143494 0% 7261 10442 12670 21425 27324 32325 15042 4950 3014 3014 3014 3014 Continue RNM Household 10 play card

Next Yr Budget 144042 8% 6291 10189 12668 21338 26026 31509 17902 5849 2901 3415 1971 39834280 RANGE FEES

Prior Yr Actual 5530 119 349 640 977 1175 931 634 198 86 191 112 119

Current Budget 5823 119 349 640 977 1175 931 634 250 200 150 200 200

This Yr Projctd 5716 -1% 363 323 554 686 992 1111 687 250 200 150 200 200

Next Yr Budget 5659 -3% 363 369 546 875 1144 1111 641 109 100 150 100 150

4310 PRO SHOP, MDSE

Prior Yr Actual 105883 5415 7777 8188 7995 15990 16738 20060 5571 3291 4965 3653 6240

Current Budget 105913 5415 7777 8188 11995 15990 16738 17060 6150 4150 4150 4150 4150

This Yr Projctd 136537 1% 7661 13538 16174 14370 20108 17925 24010 6150 4150 4150 4150 4150 December Christmas Party in Pro Shop

Next Yr Budget 138433 31% 7661 13538 16174 14370 20108 17925 24010 6498 3291 4965 3653 6240 1% increase over actuals

4315 PRO SHOP, LESSONS - GOLF PRO

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 This is a new line item with clarification of

This Yr Projctd 0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 independent contractor vs employee


4320

PRO SHOP, LESSONS - ASST.

GOLF PRO

60 - Pro Shop: Income Statement


FY 2017-18 Forecast




Total



Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0


This Yr Projctd 430 2226% 0 0 0 0 0 300 130 0 0 0 0 0 independent contractor vs employee


4325 PRO SHOP, GRIPS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 This is a new line item with clarification of

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 independent contractor vs employee

This Yr Projctd 1053 327% 0 0 0 0 0 317 736 0 0 0 0 0 Approx. 500 grips @ $9.00


4370 PRO SHOP, FOOD & BEVERAG

Prior Yr Actual 2954 -207 90 184 115 568 531 276 447 178 324 190 258

Current Budget 3000 250 400 345 300 400 330 325 150 125 125 125 125

This Yr Projctd 3297 8% 288 385 241 327 488 662 256 150 125 125 125 125

Next Yr Budget 3566 19% 222 292 204 274 462 596 266 288 178 324 190 270

4380 PRO SHOP, CLUB RENTAL

Prior Yr Actual 669 0 0 60 0 192 184 45 45 0 83 45 15

Current Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100

This Yr Projctd 680 -12% 0 15 30 25 45 65 0 100 100 100 100 100

Next Yr Budget 600 -50% 25 25 25 100 100 100 100 25 25 25 25 25


Prior Yr Actual 1602 963 -115 0 324 35 0 144 0 0 216 0 35

Current Budget 2400 500 0 0 700 0 0 500 0 0 700 0 0 quarterly revenue from golf ball diver

This Yr Projctd 3195 -5% 2544 -1078 -50 539 0 0 540 0 0 700 0 0

Next Yr Budget 3023 26% 1544 0 0 539 0 0 540 0 0 400 0 0

TOTAL INCOME ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 1776211 123088 135271 142929 181028 203017 204006 163437 129866 123230 123880 123230 123230


Next Year Budget 1851109 4% 130237 145384 153655 187729 219317 216267 169766 132473 123252 126808 120296 125925

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Cost of Revenues

5280 COS, PRO SHOP GRIPS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 New line item directly related to regripping being

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 run through the POS system

This Yr Projctd 98 2483% 0 0 0 0 0 98 0 0 0 0 0 0 Approx. 42 grips per month

Next Yr Budget 2520 #DIV/0! 210 210 210 210 210 210 210 210 210 210 210 210 at an approx. cost of $5.50 per grip

5310 COS, PRO SHOP, MDSE

Prior Yr Actual 78011 3425 6266 5978 5686 10230 12406 15194 4054 2333 3855 2867 5717 EOY proj 71%

Current Budget 75198 3844 5522 5813 8516 11353 11884 12113 4367 2947 2947 2947 2947 Budgeting for a 71% cost next year

This Yr Projctd 97904 0% 5765 10734 13047 8913 13748 12430 17115 4367 2947 2947 2947 2947

Next Yr Budget 98287 31% 5439 9612 11484 10203 14277 12727 17047 4614 2337 3525 2594 44305360 COS, PRO SHOP, FOOD & BE

Prior Yr Actual 2367 0 57 44 0 431 306 390 180 100 298 355 208

Current Budget 1950 163 260 224 195 260 215 211 98 81 81 81 81 65% cost of pro shop F&B

This Yr Projctd 2511 -8% 205 265 155 79 207 1010 168 98 81 81 81 81

Next Yr Budget 2318 19% 144 190 132 178 301 388 173 187 116 211 123 175TOTAL COST OF REVENUES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 77148 4007 5782 6038 8711 11613 12099 12324 4464 3028 3028 3028 3028


Total




Next Year Budget 103125 34% 5794 10012 11826 10591 14787 13324 17430 5011 2662 3946 2927 4816

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------



Current Budget 1699062 119082 129489 136891 172316 191405 191907 151113 125402 120202 120852 120202 120202


Next Year Budget 1747984 3% 124444 135372 141829 177138 204530 202943 152336 127462 120590 122863 117369 121109

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

E X P E N S E S

6100 PAYROLL

Prior Yr Actual 196361 16646 18229 17344 17110 17444 18330 17512 16680 13732 14044 16066 13225

Current Budget 198225 17462 17258 17098 17121 16613 17121 16952 15246 15077 15246 17851 15178 Includes annual performance bonus for Head Pro

This Yr Projctd 198272 9% 16073 16946 17316 18250 16090 18342 16657 15246 15077 15246 17851 15178


Prior Yr Actual 449 14 50 0 0 73 116 9 128 28 16 -1 17

Current Budget 4557 0 0 701 1052 1052 1052 701 0 0 0 0 0 Asst Pro was originally a salaried position

This Yr Projctd 5158 38% -2 137 807 946 819 1633 819 0 0 0 0 0 and was changed to hourly because the

Next Yr Budget 7119 56% 701 894 894 1245 1245 1245 894 0 0 0 0 0 position doesn't qualify for salary exempt

6175 PAYROLL GOLF LESSONS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0


This Yr Projctd 0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 independent contractor vs employee



Prior Yr Actual 30512 3197 3130 2848 1694 2967 3037 2749 2508 2037 2095 2309 1941

Current Budget 35385 3868 3489 3298 3182 3114 3092 2869 2432 2410 2432 2776 2423

This Yr Projctd 32924 14% 2255 2409 3484 3394 2971 3115 2823 2432 2410 2432 2776 2423


Prior Yr Actual 8464 259 740 741 741 753 752 741 747 747 747 747 747 2 staff take benefits


This Yr Projctd 10486 23% 854 852 877 877 876 879 877 879 879 879 879 879

Next Yr Budget 12899 5% 1075 1075 1075 1075 1075 1075 1075 1075 1075 1075 1075 10756300 ADVERTISING

Prior Yr Actual 840 0 0 605 75 0 0 0 0 0 160 0 0 Incentives for membership drive

Current Budget 2350 650 650 600 50 50 50 50 50 50 50 50 50

This Yr Projctd 6571 159 3611 2550 0 0 0 0 50 50 50 50 50

Next Yr Budget 5000 113% 5000 0 0 0 0 0 0 0 0 0 0 0


Prior Yr Actual 1174 2100 0 0 -2100 0 0 0 0 382 0 792 0 2500 for Nathan in Oct

Current Budget 3515 665 0 2850 0 0 0 0 0 0 0 0 0 2550 for John checkpoint 2 of 3

This Yr Projctd 2850 77% 0 0 2850 0 0 0 0 0 0 0 0 0

Next Yr Budget 5050 44% 2500 2550 0 0 0 0 0 0 0 0 0 0


Prior Yr Actual 1560 1400 200 0 -40 0 0 0 0 0 0 0 0 FSGA $200 Oct, USGA dues $110 Dec

Current Budget 2324 200 0 110 1250 0 0 0 0 764 0 0 0

PGA due for Pro & Asst Pro $764 Jun, Golfnet $2k

Jan


Total



This Yr Projctd 2324 85% 200 0 110 1250 0 0 0 0 764 0 0 0 GAF $2 Per Golfer 17-18 New Chgs

Next Yr Budget 4288 85% 200 110 3214 764 $1,214 assuming 606 members

6900 ELECTRIC*

Prior Yr Actual 16247 1328 1386 1402 1332 1520 1372 1366 1235 1314 1359 1329 1303


This Yr Projctd 15580 0% 1285 1178 1179 1303 1319 1216 1263 1473 1340 1340 1340 1344

Next Yr Budget 15580 -6% 1285 1178 1179 1303 1319 1216 1263 1473 1340 1340 1340 1344

7150 FIELD SUPPLIES

Prior Yr Actual 12179 1831 409 949 157 1197 1133 1168 947 1179 887 1580 742 towels Jun - Sep with lemon scent

Current Budget 10200 1400 800 800 800 800 800 800 800 800 800 800 800 cups, lids, scorecards etc

This Yr Projctd 13859 -5% 3689 1117 767 477 774 1518 253 1053 1053 1053 1053 1053 bag tags and trophies

Next Yr Budget 13110 29% 3689 800 800 500 800 800 1175 900 1053 900 893 800

7200 GASOLINE

Prior Yr Actual 1820 174 104 163 125 177 276 141 153 123 109 168 105

Current Budget 2700 225 225 225 225 225 225 225 225 225 225 225 225 Based on current budget

This Yr Projctd 2606 4% 124 150 144 349 312 369 34 225 225 225 225 225

Next Yr Budget 2700 0% 225 225 225 225 225 225 225 225 225 225 225 225

7230 PRO SHOP, GRIPS EXP

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 Approx. 41 grips at a cost of $5.50 per grip

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 on avg. Grip tape is $14.00 per roll weare saying

This Yr Projctd 760 248% 0 0 0 0 0 324 436 0 0 0 0 0 we will purchase 4 rolls


7300 INSURANCE

Prior Yr Actual 30889 2516 2516 2516 2516 2603 2603 2603 2603 2603 2603 2603 2603




7450 LEASE

Prior Yr Actual 22049 1588 3087 1588 2088 2088 2087 1588 1588 1588 1588 1588 1588

Current Budget 24200 1750 1750 1750 2550 2550 2550 2550 1750 1750 1750 1750 1750 cart fleet lease

This Yr Projctd 24339 -1% 1588 2864 1588 2388 2388 2388 2388 1750 1750 1750 1750 1750 Additional 8 cart lease Jan - April

Next Yr Budget 24000 -1% 1625 2925 1625 2425 2425 2425 2425 1625 1625 1625 1625 1625 Property tax in Nov


Prior Yr Actual 1892 0 61 12 520 0 96 0 938 0 203 62 0

Current Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100 mandatory annual oil changes

This Yr Projctd 1566 -23% 79 -6 382 195 189 129 98 100 100 100 100 100

Next Yr Budget 1200 0% 100 100 100 100 100 100 100 100 100 100 100 100


Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 new copier/printer lease

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 includes estimated property tax equal to

This Yr Projctd 623 98% 0 0 0 0 0 0 166 91 91 91 91 91 one month's lease payment



Prior Yr Actual 2685 368 96 408 169 0 514 86 14 162 514 186 167

Current Budget 3400 283 283 283 283 283 283 283 283 283 283 283 287

This Yr Projctd 2453 -7% 106 126 691 218 238 0 115 192 192 192 192 192 no longer using printer ink since we got the

Next Yr Budget 2280 -33% 190 190 190 190 190 190 190 190 190 190 190 190 new printer/copier. Toner is included in the lease

8100 RANGE BALLS & MATS

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0 Adequate supply of range balls 15-16 FY

Current Budget 8200 8200 0 0 0 0 0 0 0 0 0 0 0


Total



This Yr Projctd 8316 8316 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 8200 0% 8200 0 0 0 0 0 0 0 0 0 0 0 planning on purchasing the same number

8150 REFUSE

Prior Yr Actual 2079 318 159 159 159 159 159 159 159 159 159 159 172


This Yr Projctd 2060 1% 172 172 172 172 172 172 172 172 172 172 172 172

Next Yr Budget 2080 5% 173 173 173 173 173 173 173 173 173 173 173 173


Prior Yr Actual 3936 315 315 315 315 315 315 471 315 315 315 315 315

Current Budget 3780 315 315 315 315 315 315 315 315 315 315 315 315 Chelsea 315/mth

This Yr Projctd 3780 0% 315 315 315 315 315 315 315 315 315 315 315 315

Next Yr Budget 3780 0% 315 315 315 315 315 315 315 315 315 315 315 315

8450 TELEPHONE*

Prior Yr Actual 1734 101 151 101 152 152 152 153 153 154 155 155 155

Current Budget 1740 145 145 145 145 145 145 145 145 145 145 145 145

This Yr Projctd 1861 0% 155 155 155 155 155 155 155 155 155 155 155 155

Next Yr Budget 1861 7% 155 155 155 155 155 155 155 155 155 155 155 155 based on actuals

8500 TRAVEL

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 500 0 0 0 500 0 0 0 0 0 0 0 0 PGA merchandise show in Orlando

This Yr Projctd 351 0 0 0 172 179 0 0 0 0 0 0 0

Next Yr Budget 250 -50% 250

8550 UNIFORMS

Prior Yr Actual 1971 400 149 0 187 90 11 130 0 120 98 17 770

Current Budget 1300 1300 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 1885 6% 1254 -109 431 54 0 0 56 200 0 0 0 0

Next Yr Budget 2000 54% 1000 1000 0 0 0 0 0 0 0 0 0 0

8700 WATER*

Prior Yr Actual 1113 73 87 103 96 122 103 116 98 76 79 70 91


This Yr Projctd 1327 4% 44 100 104 107 114 128 122 116 123 123 123 123

Next Yr Budget 1383 6% 100 100 104 107 114 128 122 116 123 123 123 123

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 366139 41690 30214 33506 32727 30615 30934 30198 26661 27108 26535 29484 26467


Next Year Budget 410704 12% 52009 37576 32599 38911 34048 33996 33988 29070 29084 28416 28319 32688

NET INCOME/(LOSS) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 1332923 77392 99275 103385 139589 160789 160973 120915 98740 93094 94317 90718 93735


Next Year Budget 1337280 0% 72435 97796 109230 138227 170481 168947 118348 98392 91506 94447 89050 88422

======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =======


Total


I N C O M E


Prior Yr Actual 621942 55363 59798 51201 51223 50879 49600 56298 52026 49041 49248 48687 48579

Current Budget 625119 41368 63026 52698 51586 52398 50021 55891 52961 49962 49610 56099 49498

This Yr Projctd 625118 -100% 41368 63026 52698 51586 52398 50021 55891 52961 49962 49610 56099 49498

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

4990 Misc other income

Prior Yr Actual 12000 12000 0 0 0 0 0 0 0 0 12000 -12000 0 HG Tennis Association fees

Current Budget 12000 12000 0 0 0 0 0 0 0 0 0 0 0 5th year annual maintenance moved to deferred

This Yr Projctd 12000 12000 0 0 0 0 0 0 0 0 0 0 0

Next Yr Budget 12000 12000 0 0 0 0 0 0 0 0 0 0 0

Total Income

Prior Yr Actual 633942 67363 59798 51201 51223 50879 49600 56298 52026 49041 61248 36687 48579

Current Budget 637119 53368 63026 52698 51586 52398 50021 55891 52961 49962 49610 56099 49498

This Yr Projctd 637118 -98% 53368 63026 52698 51586 52398 50021 55891 52961 49962 49610 56099 49498

Next Yr Budget 12000 -98% 12000 0 0 0 0 0 0 0 0 0 0 0

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

E X P E N S E S

6100 PAYROLL

Prior Yr Actual 119115 10442 9862 10509 8212 8090 8549 11469 10553 9399 10996 10026 11009 Assume 3% salary increase for Dan

Current Budget 140109 11571 11205 11571 11571 10473 11615 13886 11797 11424 11797 11797 11402 Outsourced housekeeping duties

This Yr Projctd 137298 9% 11293 10824 11361 11595 9031 11929 13048 11797 11424 11797 11797 11402 increasing tenured employees to recent

Next Yr Budget 149666 7% 12499 12096 12499 12499 11289 12499 12096 12499 12096 12499 12499 14596 surveyed average local market rate

6125 PAYROLL, O.T.

Prior Yr Actual 3226 145 281 233 66 176 353 528 134 188 231 537 354

Current Budget 1800 150 150 150 150 150 150 150 150 150 150 150 150 based on current actuals

This Yr Projctd 4166 -57% 436 460 474 373 837 642 194 150 150 150 150 150


Prior Yr Actual 17608 2469 2080 2055 1471 918 1326 1508 1421 -100 1506 1380 1574

Current Budget 21482 2661 2378 2156 1695 1402 1553 1853 1577 1528 1577 1577 1525

This Yr Projctd 20362 11% 1625 1572 1935 2137 1586 1853 1869 1577 1528 1577 1577 1525


Prior Yr Actual 16199 890 1780 1780 1828 1315 1267 1226 1275 1275 1275 1276 1013


This Yr Projctd 14819 30% 875 875 1318 1394 1318 876 603 1512 1512 1512 1512 1512 Assume 3 people take insurance

Next Yr Budget 19280 -20% 1607 1607 1607 1607 1607 1607 1607 1607 1607 1607 1607 16076500 CASUAL LABOR

70 - Clubhouse,Pool,Spa: Income Statement


FY 2017-18 Forecast




Total



Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 188 -100% 0 0 0 0 188 0 0 0 0 0 0 0


6550 CHEMICALS

Prior Yr Actual 7163 0 516 981 0 502 0 1267 900 0 159 2306 532

Current Budget 3900 325 325 325 325 325 325 325 325 325 325 325 325 based on current actuals and

This Yr Projctd 5844 4% 437 362 410 303 662 784 635 450 450 450 450 450 extreme use of pool during season

Next Yr Budget 6100 56% 450 450 550 550 550 650 650 450 450 450 450 450 increased chemical costs


Prior Yr Actual 9678 813 1169 1160 648 378 1212 533 372 1475 588 769 560 based on current budget

Current Budget 9000 750 750 750 750 750 750 750 750 750 750 750 750 paper products & hand soap in house

This Yr Projctd 8913 1% 879 786 590 1028 803 659 417 750 750 750 750 750 floor & carpet cleaning in house

Next Yr Budget 9000 0% 750 750 750 850 850 850 750 750 750 600 750 600

6630 Contingency

Prior Yr Actual 1680 0 0 0 0 0 0 0 0 0 0 0 1680

Current Budget 1680 1680 0 0 0 0 0 0 0 0 0 0 0 Har Tru Major maint every 5th year

This Yr Projctd 0 0 0 0 0 0 0 0 0 0 0 0 0 $25,520 for 5th yr maintenance quote

Next Yr Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 Moved to deferred maintenance


Prior Yr Actual 409 409 0 0 0 0 0 0 0 0 0 0 0 Welch tennis summer seminar $150

Current Budget 600 50 50 50 50 50 50 50 50 50 50 50 50 Summer conference $350

This Yr Projctd 250 0 0 0 0 0 0 0 50 50 50 50 50

additional employee certified in pool maintenance,

maint. Seminar Oct

Next Yr Budget 739 23% 239 0 0 0 350 0 0 0 0 150 0 0 $239 every 5 yrs CPO X2

6900 ELECTRIC*

Prior Yr Actual 41847 3414 3568 3645 3458 3925 3540 3500 3176 3357 3477 3427 3358


This Yr Projctd 40473 -8% 3335 3041 3034 3379 3275 3123 3255 3403 3686 3686 3686 3569 6.5% allocated to Fitness Center 17-18

Next Yr Budget 37388 -13% 3118 3137 3138 3115 3122 3132 3123 3114 3095 3095 3095 3103

7185 FOUNTAINS (ELECTRIC)

Prior Yr Actual 2425 450 300 300 0 300 600 0 475 0 0 0 0 Based on actual monthly averages

Current Budget 5500 458 458 458 458 458 458 458 458 458 458 458 462 plus additional fountain on Mystic

This Yr Projctd 7188 46% 0 0 0 0 624 3629 645 458 458 458 458 458 HOA was paying

Next Yr Budget 10524 91% 877 877 877 877 877 877 877 877 877 877 877 877

7190 FOUNTAIN & BUBBLER MAINT

Prior Yr Actual 495 0 0 0 0 0 0 0 0 0 0 0 495

Current Budget 3000 250 250 250 250 250 250 250 250 250 250 250 250 preventative maint contract

This Yr Projctd 2475 21% 175 3895 175 175 175 175 -3545 250 250 250 250 250 expenses to cover repairs

Next Yr Budget 3000 0% 250 250 250 250 250 250 250 250 250 250 250 250

7200 GASOLINE

Prior Yr Actual 642 51 43 46 49 50 74 42 59 54 77 52 46

Current Budget 800 66 66 66 66 66 66 66 66 66 66 66 74 based on current budget

This Yr Projctd 790 1% 55 49 54 96 63 88 48 66 66 66 66 74

Next Yr Budget 800 0% 66 66 66 66 66 66 66 66 66 66 66 74

7251 SMALL EQUIPMENT SOUND


Total



Prior Yr Actual 3521 34 226 0 200 393 1843 0 0 0 0 0 824

Current Budget 3300 275 275 275 275 275 275 275 275 275 275 275 275 Sound & Light Requests

This Yr Projctd 1580 109% 0 0 0 0 50 155 0 275 275 275 275 275

Next Yr Budget 3300 0% 275 275 275 275 275 275 275 275 275 275 275 275

7300 INSURANCE

Prior Yr Actual 33096 2695 2695 2695 2695 2789 2789 2789 2789 2789 2789 2789 2789





Prior Yr Actual 46077 4815 11158 3870 3935 2270 2270 3870 3425 1189 2925 3425 2925 Outsourced clubhouse landscaping

Current Budget 50075 4230 12400 4350 3575 3075 2420 4230 3650 3075 3575 3075 2420 Includes pinestraw and annuals

This Yr Projctd 43106 13% 4155 6473 3233 3075 4305 2420 3650 3650 3075 3575 3075 2420 Add landscape & pinestraw to pickleball

Next Yr Budget 48875 -2% 4130 12300 4250 3475 2975 2320 4130 3550 2975 3475 2975 2320 courts & lake bank along #9

7450 LEASE

Prior Yr Actual 16794 1399 1399 1399 1399 1399 1399 1399 1399 1399 1399 1399 1399 carbon water filter 174/mth (1% inc)

Current Budget 18180 1515 1515 1515 1515 1515 1515 1515 1515 1515 1515 1515 1515 trash comp 300/mth, ice machines 875/mth

This Yr Projctd 16945 70% 1399 1399 1473 1399 1399 1399 1399 1415 1415 1415 1415 1415 Club Cart Turf 1 cart 170/mth (Oct & Nov)

Next Yr Budget 28772 58% 2539 2539 2369 2369 2369 2369 2369 2369 2369 2369 2369 2369

Capital Lease security cameras - 5yr plan lease to

own including maintenance $1020.30/mo


Prior Yr Actual 483 0 107 0 0 0 0 0 375 0 0 0 0

Current Budget 475 0 100 0 0 0 0 0 375 0 0 0 0 pool permit

This Yr Projctd 375 0% 0 0 0 0 0 0 0 375 0 0 0 0

Next Yr Budget 375 -21% 0 0 0 0 0 0 0 375 0 0 0 0


Prior Yr Actual 66414 7781 5138 4658 5836 7273 9723 5061 4992 555 5436 5004 4958

Current Budget 72000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 costs to maintain an aging facility

This Yr Projctd 60297 17% 5430 4208 7969 5554 891 3996 2249 6000 6000 6000 6000 6000

Next Yr Budget 70800 -2% 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900

7685 MAINTENANCE, POOL

Prior Yr Actual 6967 336 242 488 825 1386 212 428 744 1112 27 215 952

Current Budget 4800 400 400 400 400 400 400 400 400 400 400 400 400

This Yr Projctd 8289 -28% 1818 -468 939 707 0 1083 1209 600 600 600 600 600 money in deferred for potential leaks

Next Yr Budget 6000 25% 500 500 500 500 500 500 500 500 500 500 500 500


Prior Yr Actual 432 0 111 40 0 102 0 0 0 0 20 159 0

Current Budget 240 20 20 20 20 20 20 20 20 20 20 20 20 based on actuals

This Yr Projctd 424 -1% 0 0 0 169 0 55 0 40 40 40 40 40

Next Yr Budget 420 75% 35 35 35 35 35 35 35 35 35 35 35 35

7950 PROPANE GAS

Prior Yr Actual 348 12 12 12 17 212 12 12 12 12 12 12 12 2 gas grills by the pool

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projctd 120 20% 12 12 12 -12 12 12 12 12 12 12 12 12



Total



8150 REFUSE

Prior Yr Actual 3631 696 265 265 265 265 265 265 265 265 265 265 286


This Yr Projctd 3477 1% 286 286 286 286 286 286 286 295 295 295 295 295

Next Yr Budget 3512 -1% 289 289 289 289 289 289 289 298 298 298 298 298

8200 RENTAL

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 480 40 40 40 40 40 40 40 40 40 40 40 40

This Yr Projctd 366 31% 0 0 0 0 0 166 0 40 40 40 40 40

Next Yr Budget 480 0% 40 40 40 40 40 40 40 40 40 40 40 40

8225 SECURITY

Prior Yr Actual 14071 1139 1139 1241 1173 1173 1173 1173 1173 1173 1173 1173 1173

Current Budget 14493 1173 1173 1278 1208 1208 1208 1208 1208 1208 1208 1208 1208 3% increase from HOA for security costs

This Yr Projctd 14494 3% 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208 1208

Next Yr Budget 14929 3% 1244 1244 1244 1244 1244 1244 1244 1244 1244 1244 1244 1244


Prior Yr Actual 141121 11277 13180 11375 11915 13156 11496 12678 11131 12916 8924 13510 9562 *See Note 1

Current Budget 141011 11341 13377 11817 12007 14077 11817 12650 11393 10783 9523 10893 11333

All windows 2x/yr $367.50; Restaurant 4x/yr $834.75

for all (apx 5% inc)

This Yr Projctd 139482 17% 10428 13350 11395 11812 14387 12162 12022 11393 10783 9523 10893 11333

Next Yr Budget 162574 15% 11965 15850 14290 15493 15850 14290 15000 11165 13280 11165 12725 11498

8350 SMALL TOOLS

Prior Yr Actual 1316 0 0 800 0 0 31 103 0 99 83 0 199

Current Budget 1200 100 100 100 100 100 100 100 100 100 100 100 100

This Yr Projctd 798 50% 0 0 0 0 0 0 298 100 100 100 100 100

Next Yr Budget 1200 0% 100 100 100 100 100 100 100 100 100 100 100 100

8450 TELEPHONE*

Prior Yr Actual 1708 87 87 337 87 187 87 88 188 139 140 140 140

Current Budget 1600 133 133 133 133 133 133 133 133 133 133 133 133 based on actuals

This Yr Projctd 1646 2% 140 140 140 140 140 140 140 133 133 133 133 133

Next Yr Budget 1680 5% 140 140 140 140 140 140 140 140 140 140 140 140

8475 TENNIS COURT MAINTENANCE

Prior Yr Actual 17834 1039 262 2005 1507 40 615 1381 300 355 150 5485 4693 $2k baseline budget from historical

Current Budget 9240 217 217 217 217 217 217 217 217 217 217 6767 303 asphalt costs

This Yr Projctd 9407 114% 620 0 618 178 0 271 0 217 217 217 6767 303 Includes actual cost of Welch's annual

Next Yr Budget 20156 118% 1039 262 2005 1507 40 615 1381 300 355 150 12350 150 maintenance for top dressing

8500 TRAVEL

Prior Yr Actual 467 0 158 0 0 0 168 0 71 35 0 0 35 Dan's annual conference in Orlando

Current Budget 1000 50 50 50 50 250 50 50 50 250 50 50 50 mileage reimbursement for trips to

This Yr Projctd 589 70% 0 0 56 0 15 0 68 50 250 50 50 50 pool store, Home Depot, training, etc.

Next Yr Budget 1000 0% 50 50 50 50 250 50 50 50 50 250 50 50

8550 UNIFORMS

Prior Yr Actual 337 77 0 0 26 0 0 0 0 235 0 0 0

Current Budget 500 0 0 500 0 0 0 0 0 0 0 0 0 Logo polo shirts & khaki shorts

This Yr Projctd 752 6% 0 0 0 0 0 100 252 400 0 0 0 0


Total



Next Yr Budget 800 60% 0 800 0 0 0 0 0 0 0 0 0 0

8700 WATER*

Prior Yr Actual 8649 577 749 811 788 970 833 893 729 532 652 471 645


This Yr Projctd 10556 0% 254 713 818 928 1163 1091 1004 821 941 941 941 941

Next Yr Budget 10556 3% 254 713 818 928 1163 1091 1004 821 941 941 941 941

8701 EFFLUENT WATER

Prior Yr Actual 24332 904 2260 754 1466 1251 1218 1854 3001 4913 2828 2943 940 Effluent water used to irrigate

Current Budget 17153 904 2260 754 1466 1251 1218 1854 2920 1300 1486 555 1185 golf course

This Yr Projctd 24257 883 3789 2857 1908 1286 1952 2457 3600 2300 1486 555 1185 based on actuals

Next Yr Budget 24257 883 3789 2857 1908 1286 1952 2457 3600 2300 1486 555 1185

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 637119 53368 63026 52698 51586 52398 50021 55891 52961 49962 49610 56099 49498


Next Year Budget 693328 9% 53776 68543 59435 59831 56709 56204 58900 54912 54477 52499 64628 53413

NET INCOME/(LOSS) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Prior Year Actual 3162 13346 100 -1291 1717 882 -2357 2453 1406 -1044 14622 -20818 -5852

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projected 24766 4905 7332 -373 1033 5975 -2952 9747 -845 -765 235 235 239

Next Year Budget -681328 -41776 -68543 -59435 -59831 -56709 -56204 -58900 -54912 -54477 -52499 -64628 -53413

======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =======

*Note 1 - Ecolab pool salt system 1109/mth; Ecolab pest control 631.36/mth; 2 firelines 60/mth; Bowen Cooling A/C prev maint 1350/qtr; Bowen Cooling chiller prev maint 210/qtr;

lift equipment inspection 800/June; Simplex $2114.70 Jun (firehood inspection 833/2xyear; sprinkler inspection 275; fire extinguisher inspection 400)

lake management contract $3495/month; Thorguard maintenance $650/June; $300 fire alarm monitoring in Feb; $400 fire panel inspection

$4,195/mth (May - Oct) & $6,820/mth (Nov - Apr) for Janpro Cleaning Company


Total



Prior Yr Actual 193255 21172 16910 15899 15929 15319 15296 15562 15317 14973 14922 16998 14959

Current Budget 196270 23783 16926 15989 15554 14996 15451 15603 15708 15733 15777 15427 15325

This Yr Projctd 196311 -100% 23783 16926 15989 15554 14996 15451 15643 15708 15733 15777 15427 15325

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

4917 CLIS INCOME

Prior Yr Actual 163011 17818 14260 13415 13440 12931 12912 13134 12930 12642 12600 14333 12597

Current Budget 164359 19897 14173 13390 13027 12562 12941 13068 13156 13177 13213 12921 12836 Increase of 3%

This Yr Projctd 164360 3% 19897 14173 13390 13027 12562 12941 13068 13156 13177 13213 12921 12836

Next Yr Budget 169290 3% 20494 14598 13792 13418 12938 13329 13460 13550 13572 13610 13309 13221


Prior Yr Actual 1835 0 0 0 0 0 0 0 0 0 756 0 1079

Current Budget 600 50 50 50 50 50 50 50 50 50 50 50 50 Irrigation hookups for new homes

This Yr Projctd 3702 -3% 635 0 117 265 838 1167 430 50 50 50 50 50 driveways, pools, etc

Next Yr Budget 3600 500% 300 300 300 300 300 300 300 300 300 300 300 300 based on an avg of 2 driveways/mo

TOTAL INCOME ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 361230 43730 31149 29429 28630 27608 28441 28720 28913 28959 29040 28398 28211


Next Year Budget 172890 -52% 20794 14898 14092 13718 13238 13629 13760 13850 13872 13910 13609 13521

------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

E X P E N S E S

6100 PAYROLL

Prior Yr Actual 153812 12432 12657 13068 12690 12805 13182 13408 13733 10760 12441 13745 12890 3% wage increase

Current Budget 168837 14217 13857 14259 14259 13051 14259 13857 14259 13945 14386 14433 14053 DOGCM Supervision allocation included

This Yr Projctd 166551 0% 13699 12372 13001 13226 13953 15182 14042 14259 13945 14386 14433 14053

Next Yr Budget 167345 -1% 13952 13583 13952 13952 12845 13952 13583 13952 13583 13952 13952 160836125 PAYROLL, O.T.

Prior Yr Actual 3851 781 472 -6 0 443 369 729 436 27 180 308 113

Current Budget 3034 180 180 180 180 180 180 471 471 471 180 180 180

This Yr Projctd 3964 59% 319 315 229 521 256 330 512 471 471 180 180 180


Prior Yr Actual 22874 3175 3117 2637 1969 1785 1875 1800 1930 -975 1663 1978 1921

Current Budget 27785 3286 3210 2969 2344 1955 2107 1957 1992 1957 2014 2020 1976

This Yr Projctd 25815 -7% 2252 1967 2286 2513 2320 2461 2058 1992 1957 2014 2020 1976


Prior Yr Actual 9057 496 991 991 991 999 999 999 999 526 526 526 12 Assume 3 employees will elect benefits


This Yr Projctd 7787 146% 420 442 437 652 697 697 956 697 697 697 697 697

76 - CLIS: Income Statement


FY 2017-18 Forecast




Total



Next Yr Budget 19164 7% 1597 1597 1597 1597 1597 1597 1597 1597 1597 1597 1597 15976625 COMPUTER SUPPORT

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 1400 0 0 0 0 1400 0 0 0 0 0 0 0

This Yr Projctd 1750 0 0 0 0 1400 0 350 0 0 0 0 0 Tucor Controller access maint fee in Feb

Next Yr Budget 1750 25% 0 0 0 0 1750 0 0 0 0 0 0 0 for front & back of community


Prior Yr Actual 279 279 0 0 0 0 0 0 0 0 0 0 0 Oct Irrigation Association Show $279

Current Budget 680 300 0 0 0 0 0 0 20 300 20 20 20

This Yr Projctd 380 0 0 0 0 0 0 0 20 300 20 20 20

Next Yr Budget 300 -56% 300 0 0 0 0 0 0 0 0 0 0 0

6652 CONTRACT LABOR - TECHNIC

Prior Yr Actual 221 221 0 0 0 0 0 0 0 0 0 0 0 day laborer only as needed

Current Budget 1800 150 150 150 150 150 150 150 150 150 150 150 150

This Yr Projctd 750 -100% 0 0 0 0 0 0 0 150 150 150 150 150

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0


Prior Yr Actual 360 0 0 0 0 360 0 360 -360 0 0 0 0

Current Budget 720 0 0 0 0 0 0 0 0 0 720 0 0 Irrigation Association Membership

This Yr Projctd 720 0 0 0 0 0 360 0 0 0 360 0 0

Next Yr Budget 360 0 0 0 0 0 360 0 0 0 0 0 0

6900 ELECTRIC*

Prior Yr Actual 31294 2168 3014 2795 2528 1847 2578 3006 3341 2866 2778 2292 2080 Assume rates stay flat

Current Budget 32141 2168 3014 2795 2528 1847 2578 3006 2841 2841 2841 2841 2841

This Yr Projctd 34279 0% 2304 3181 3071 2870 2887 2797 2963 2841 2841 2841 2841 2841

Next Yr Budget 34279 7% 2304 3181 3071 2870 2887 2797 2963 2841 2841 2841 2841 2841

7200 GASOLINE

Prior Yr Actual 1415 130 124 100 107 119 135 121 110 124 112 126 105

Current Budget 1669 130 124 100 107 119 135 121 167 167 167 167 163 Gas prices have gone up recently

This Yr Projctd 1813 5% 119 85 123 176 172 210 98 167 167 167 167 163

Next Yr Budget 1900 14% 158 158 158 158 158 158 158 158 158 158 158 158

7300 INSURANCE

Prior Yr Actual 15445 1258 1258 1258 1258 1302 1302 1302 1302 1302 1302 1302 1302




7450 LEASE

Prior Yr Actual 13205 964 964 964 964 964 964 393 393 393 393 393 5458

Current Budget 9781 5458 393 393 393 393 393 393 393 393 393 393 393 Kubota RTV carts 393/mth

This Yr Projctd 9782 0% 5458 393 393 393 393 393 393 393 393 393 393 393 2 additional carts leased last year $5,065/yr

Next Yr Budget 9781 0% 5458 393 393 393 393 393 393 393 393 393 393 393


Prior Yr Actual 631 0 0 0 0 0 0 131 500 0 0 0 0 Expenses associated with

Current Budget 1800 150 150 150 150 150 150 150 150 150 150 150 150 cart maintenance

This Yr Projctd 8789 -80% 0 294 462 1409 1720 375 2779 350 350 350 350 350 GCM needs to allocate charges

Next Yr Budget 1800 0% 150 150 150 150 150 150 150 150 150 150 150 150

7676 PARTS & SUPPLIES


Total



Prior Yr Actual 53934 5913 3951 4318 4812 3172 6347 5215 4874 4810 589 4882 5051 increased costs of maintaining aging

Current Budget 53000 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417 irrigation system; costs of replacing

This Yr Projctd 50773 0% 5118 2565 4810 5061 3788 3288 4059 4417 4417 4417 4417 4417 heads and valves damaged by clams

Next Yr Budget 50600 -5% 4217 4217 4217 4217 4217 4217 4217 4217 4217 4217 4217 4217


Prior Yr Actual 1040 49 0 0 0 0 0 195 407 99 0 290 0

Current Budget 600 50 50 50 50 50 50 50 50 50 50 50 50

This Yr Projctd 274 119% 0 0 24 0 0 0 0 50 50 50 50 50

Next Yr Budget 600 0% 50 50 50 50 50 50 50 50 50 50 50 50

7852 PUMP MAINTENANCE

Prior Yr Actual 9560 9010 0 0 550 0 0 0 0 0 0 0 0 Hoover preventative maint contracts

Current Budget 9122 9122 0 0 0 0 0 0 0 0 0 0 0 for Front, Mystic, #16 & Effluent pumps

This Yr Projctd 7810 17% 7810 0 0 0 0 0 0 0 0 0 0 0 split between GCM & CLIS

Next Yr Budget 9122 0% 9122 0 0 0 0 0 0 0 0 0 0 0 Hoover services non-contracted


Prior Yr Actual 298 0 0 298 0 0 0 0 0 0 0 0 0

Current Budget 900 75 75 75 75 75 75 75 75 75 75 75 75 used to dress up around repairs

This Yr Projctd 919 -2% 0 215 0 329 0 0 0 75 75 75 75 75 and irrigation breaks

Next Yr Budget 900 0% 75 75 75 75 75 75 75 75 75 75 75 75

8350 SMALL TOOLS

Prior Yr Actual 239 0 0 0 0 0 0 0 0 0 0 0 239

Current Budget 600 50 50 50 50 50 50 50 50 50 50 50 50

This Yr Projctd 1115 -46% 0 0 0 0 0 865 0 50 50 50 50 50

Next Yr Budget 600 0% 50 50 50 50 50 50 50 50 50 50 50 50

8450 TELEPHONE*

Prior Yr Actual 1547 135 135 135 33 135 135 135 135 135 135 135 161

Based on three Sprint cell phones & tablet for

monitoring the CLIS system

Current Budget 1620 135 135 135 135 135 135 135 135 135 135 135 135 adding tablet for home monotiring

This Yr Projctd 2113 11% 165 165 167 165 165 165 445 135 135 135 135 135 of pumps

Next Yr Budget 2340 44% 195 195 195 195 195 195 195 195 195 195 195 195

8500 TRAVEL

Prior Yr Actual 1827 604 1223 0 0 0 0 0 0 0 0 0 0

Current Budget 2000 0 1500 0 0 0 0 0 0 500 0 0 0 Oct - Natl Irrig Assoc conf

This Yr Projctd 500 0% 0 0 0 0 0 0 0 0 500 0 0 0

Next Yr Budget 500 -75% 500 0 0 0 0 0 0 0 0 0 0 0

8550 UNIFORMS

Prior Yr Actual 4016 579 358 212 323 253 263 319 191 351 592 323 250

Current Budget 4032 564 264 330 264 264 330 564 264 330 264 264 330

This Yr Projctd 3748 619 291 238 338 242 570 -3 264 330 264 264 330

Next Yr Budget 4032 0% 564 264 330 264 264 330 564 264 330 264 264 330

8700 WATER*

Prior Yr Actual 249 22 26 19 22 16 26 19 19 19 22 19 19


This Yr Projctd 269 0% 26 19 22 22 19 26 19 23 23 23 23 23

Next Yr Budget 269 1% 26 19 22 22 19 26 19 23 23 23 23 23

8701 EFFLUENT WATER

Prior Yr Actual 6200 400 723 527 1250 400 600 450 633 417 250 275 275 Stays flat


Total



Current Budget 6375 500 800 600 750 600 650 550 700 250 250 275 450 Effluent water used to irrigate

This Yr Projctd 6375 500 800 600 750 600 650 550 700 250 250 275 450 back section of homes

Next Yr Budget 6375 500 800 600 750 600 650 550 700 250 250 275 450

TOTAL EXPENSES ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------


Current Budget 361230 43730 31149 29429 28630 27608 28441 28720 28913 28959 29040 28398 28211


Next Year Budget 357615 -1% 42671 28144 28313 29442 29665 29303 28535 28365 27448 27684 27693 30351

NET INCOME/(LOSS) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------

Prior Year Actual 26747 375 2157 1997 1872 3648 -567 113 -397 6761 7293 4735 -1241

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projected 12871 4237 6726 2364 -848 -1487 -79 -1350 591 590 949 589 589

Next Year Budget -184725 -21877 -13246 -14222 -15724 -16426 -15673 -14775 -14515 -13576 -13774 -14085 -16830

======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =======


Total



Prior Yr Actual 34601 3397 2710 2777 3057 2650 2924 3180 2754 2780 3013 2570 2788

Current Budget 36529 2961 3382 3441 2767 3159 3348 2785 3297 2827 2617 3110 2835

This Yr Projctd 36529 -100% 2961 3382 3441 2767 3159 3348 2785 3297 2827 2617 3110 2835

Next Yr Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

TOTAL INCOME


Current Budget 36529 2961 3382 3441 2767 3159 3348 2785 3297 2827 2617 3110 2835


Next Year Budget 0 -100% 0 0 0 0 0 0 0 0 0 0 0 0

E X P E N S E S


Prior Yr Actual 2302 0 216 0 0 634 300 338 0 436 108 108 162

Current Budget 2700 225 225 225 225 225 225 225 225 225 225 225 225 monk wipes, hand towels & hand soap

This Yr Projctd 2580 351 108 108 537 96 25 230 225 225 225 225 225 current budget

Next Yr Budget 2700 0% 225 225 225 225 225 225 225 225 225 225 225 225

6900 ELECTRIC*

Prior Yr Actual 7341 750 685 567 523 430 464 575 547 658 735 722 684 based on square footage of main lobby

Current Budget 6248 750 685 567 523 430 464 575 597 414 414 414 414 6.7% allocated from clubhouse electric

This Yr Projctd 4399 -40% 807 527 467 549 495 396 361 597 50 50 50 50

Next Yr Budget 2631 -58% 217 198 197 220 213 203 212 221 240 240 240 232

7175 FITNESS CENTER MAINTENAN

Prior Yr Actual 17236 1075 684 617 916 509 693 3383 908 4262 1831 140 2218

Current Budget 5000 416 416 416 416 416 416 416 416 416 416 416 424 wall repairs, mats, housekeeping

This Yr Projctd 7752 -61% 91 633 3259 233 260 798 390 416 416 416 416 424

Next Yr Budget 3000 -40% 250 250 250 250 250 250 250 250 250 250 250 250

7300 INSURANCE

Prior Yr Actual 7355 599 599 599 599 620 620 620 620 620 620 620 620




7450 LEASE

Prior Yr Actual 11918 652 1062 877 748 741 1198 748 960 1748 1245 1191 748 Torso rotation $130/mth thru 06/15/18

Current Budget 12866 833 1330 1276 833 1330 1276 833 1330 833 833 1326 833 Octane XT One $497/qtr thru 02/16/19

This Yr Projctd 12335 -69% 1245 1191 748 1245 1191 748 1245 1330 833 833 893 833 scifit bike & calf machine $366.38/mo

Next Yr Budget 3881 -70% 992 495 129 626 129 129 627 129 129 497 0 0 thru 11/18/17

8200 RENTAL

Prior Yr Actual 0 0 0 0 0 0 0 0 0 0 0 0 0

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

77 - Fitness Center: Income Statement


FY 2017-18 Forecast




Total


77 - Fitness Center: Income Statement

This Yr Projctd 0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 iStorage two storage units for fitness center

Next Yr Budget 4800 #DIV/0! 400 400 400 400 400 400 400 400 400 400 400 400 equipment and structures from building


Prior Yr Actual 420 0 0 210 0 0 0 0 0 0 210 0 0

Current Budget 840 0 0 210 0 0 210 0 0 210 0 0 210 Tropic GymTech 210/qtr

This Yr Projctd 630 33% 0 210 0 0 0 210 -210 0 210 0 0 210

Next Yr Budget 840 0% 0 210 0 0 0 210 0 0 210 0 0 210

8450 TELEPHONE*

Prior Yr Actual 675 54 54 54 64 54 54 57 57 57 57 57 57

Current Budget 612 51 51 51 51 51 51 51 51 51 51 51 51

This Yr Projctd 653 5% 57 57 57 57 57 57 57 51 51 51 51 51 based on actuals

Next Yr Budget 684 12% 57 57 57 57 57 57 57 57 57 57 57 57

8700 WATER*

Prior Yr Actual 1217 81 70 92 115 102 102 81 182 70 81 115 126

Current Budget 1013 81 70 92 115 102 102 81 74 74 74 74 74 Culligan Water to make up for

This Yr Projctd 1003 20% 29 93 93 109 131 105 72 74 74 74 74 74 lack of water fountains

Next Yr Budget 1200 18% 100 100 100 100 100 100 100 100 100 100 100 100

TOTAL EXPENSES


Current Budget 36529 2961 3382 3441 2767 3159 3348 2785 3297 2827 2617 3110 2835


Next Year Budget 26986 -26% 2845 2539 1962 2482 1978 2178 2474 1986 2215 2373 1876 2078

NET INCOME/(LOSS)

Prior Year Actual -13863 186 -660 -239 92 -440 -507 -2622 -519 -5071 -1873 -382 -1827

Current Budget 0 0 0 0 0 0 0 0 0 0 0 0 0

This Yr Projected -72 -223 -41 -1895 -567 324 405 37 0 364 364 797 364

Next Year Budget -26986 -2845 -2539 -1962 -2482 -1978 -2178 -2474 -1986 -2215 -2373 -1876 -2078


General Assumptions - 2017-18 Fiscal Budget

O&M Divisor will be 1285 due to acquisition of the 15 HOA/Taylor Morrison lots by the HGRD in Dec 2016

The adjustment of the divisor from 1300 to 1285 represents aproximately $5.39 increase per quarter per household to begin with

The GM Hall Restitution Budget Credit of $53,450 from FY16-17 budget equated to a credit of apx $10.39 per household per quarter in last year's budget, but will not be included in the FY17-18 budget

CLIS Divisor will be 1284 - we still have one vacant lot in the community that has not been built out

Property & Liability insurance should increase by est 4.6% over actuals plus an increase for assessed value on new appraisal to be done FY17 ; estimate from Brad Havemeier

Salary increases - 3% based on performance metrics, with some wages being brought up to prevailing market wage levels

Healthcare premiums are estimated to increase 8%

Electricity will stay relatively flat

Water will stay relatively flat

Refuse - 1% increase

Golf Revenue Assumptions

Single membership is 60% of the couple membership rate

Golf membership maxes out at 606 members (allowed outside memberships up to budget cap) - decrease of 3% from 16-17 actuals in membership number and 1.3% in dollars

El Nino weather pattern for 2016-17 made the weather great for golf

Set-a-sides increased from 2016-17 by 4 additional per week (36/wk, none on Wed or Fri to minimize standby list)

The USGA is forcing all clubs to belong to the Florida State Golf Association (FSGA) and pay $2 per member this year.

Golf Course Maintenance Assumptions

Currently have 12 employees taking the health insurance. Previously only budgeted for 9 employees.

Restaurant Assumptions

Restaurant hours will remain the same

3-4% increase for food revenue

Average food cost 42%, average beverage cost 25%

Administration

Northstar Support Increased 3.3%

Clubhouse Maintenance

Moved 5th year Har-Tru maintenance to deferred maintenance


PRO SHOP BUDGET

WITH TAX

REVENUES: October November December January February March April May June July August September YEAR AT 6%

Member Fees

Household (up to 2) Memberships 193 198 206 209 209 209 209 209 209 209 209 209

Rate/Month 332 332 332 332 332 332 332 332 332 332 332 332 3,986.73 4,225.93 Household increased 69.73 1.8%

Single Memberships 175 180 185 188 188 188 188 188 188 188 188 188

Rate/Month 200 200 200 200 200 200 200 200 200 200 200 200 2,395.30 2,539.02 Single increased 43.30 1.8%

TOTAL MEMBERS 561 576 597 606 606 606 606 606 606 606 606 606

2388.25 2395.3

MEMBER REVENUE 99,051.37 101,710.55 105,366.41 106,961.91 106,961.91 106,961.91 106,961.91 106,961.91 106,961.91 106,961.91 106,961.91 106,961.91 1,268,785.55

Rounds Projected current year

Member 4500 5000 4800 6000 5300 6450 5200 4000 2500 2100 1800 2500 50150 45812

Public 270 266 190 328 535 448 173 284 251 274 180 225 3424 37.1% 4088

Member Guest 195 169 186 330 391 409 164 112 54 60 43 43 2157 23.4% 1887

Resident NonMember 204 479 306 445 579 675 443 169 79 106 60 108 3654 39.6% 3526

Total Guests 669 914 682 1102 1505 1532 780 565 384 440 284 377 9235 9501

TOTAL ROUNDS 5169 5914 5482 7102 6805 7982 5980 4565 2884 2540 2084 2877 59385 55313 56419.26

Rounds/Member/Mo. 8.02 8.68 8.04 9.90 8.75 10.64 8.58 6.60 4.13 3.47 2.97 4.13

Total Outside Rounds/Day 21.59 30.47 22.00 35.56 53.76 49.41 26.01 18.23 12.79 14.20 9.15 12.56

O/S Rds/Day-MemGst 6.29 5.63 6.00 10.65 13.97 13.19 5.47 3.61 1.79 1.94 1.40 1.45

O/S Rds/Day-NonMemGst 15.30 24.84 16.00 24.92 39.79 36.22 20.55 14.62 11.00 12.26 7.76 11.11

Avg.Public Rate-Pre Tax $25.35 $35.70 $34.06 $55.61 $66.06 $61.96 $39.36 $27.12 $26.31 $26.27 $24.98 $23.51 *Avg public rate lower than guest rate because of GolfNow trade times (approx 86/mth)

Avg. Gst PreTax $32.32 $44.72 $54.45 $68.13 $68.49 $68.35 $61.90 $28.27 $28.35 $28.28 $28.29 $28.18

Avg. RNM-PreTax $30.81 $21.27 $41.34 $47.97 $44.95 $46.68 $40.41 $34.61 $36.72 $32.22 $32.70 $36.88

NON MEMBER:

REVENUE 19,443.40 27,246.68 29,255.70 62,040.90 88,170.00 87,202.15 34,877.23 16,720.33 11,025.88 12,312.12 7,696.00 10,508.04 406,498.43 406,498.43

REVENUE PER RD $29.05 $29.81 $42.89 $56.28 $58.57 $56.93 $44.69 $29.59 $28.74 $27.98 $27.13 $27.88

Other Revenue

Range Fees 363.00 369.36 546.34 874.85 1,144.22 1,111.37 640.58 108.95 100.00 150.00 100.00 150.00 5,658.67 5,658.67

Merchandise 7,661.00 13,538.00 16,174.00 14,370.00 20,108.00 17,925.00 24,010.00 6,498.00 3,291.00 4,965.00 3,653.00 6,240.00 138,433.00 138,433.00

Food Sales 222.24 292.34 203.52 273.58 462.45 596.44 265.90 288.00 177.84 324.00 189.64 269.78 3,565.73 3,565.73

Range Memb. 444.00 419.00 501.00 685.00 687.00 687.00 687.00 687.00 687.00 687.00 687.00 687.00 7,545.00 7,545.00

Pro Shop Lessons 1,108.33 1,408.33 1,208.33 1,508.33 1,308.33 1,308.33 1,308.33 808.33 608.33 608.33 608.33 708.33

Pro Shop Grips 375.00 375.00 375.00 375.00 375.00 375.00 375.00 375.00 375.00 375.00 375.00 375.00

TOTAL OTHER 10,173.57 16,402.03 19,008.19 18,086.76 24,085.00 22,003.14 27,286.81 8,765.28 5,239.17 7,109.33 5,612.97 8,430.11 155,202.40

club rental/misc income 3600.00

TOTAL REVENUE 128,668.34 145,359.26 153,630.30 187,089.58 219,216.92 216,167.21 169,125.96 132,447.53 123,226.97 126,383.37 120,270.89 125,900.07 1,851,086.38

Cost of Sales:

Merchandise 5,439.31 9,611.98 11,483.54 10,202.70 14,276.68 12,726.75 17,047.10 4,613.58 2,336.61 3,525.15 2,593.63 4,430.40 98,287.43 98,287.43

Food Sales 144.46 190.02 132.29 177.83 300.59 387.69 172.84 187.20 115.60 210.60 123.27 175.36 2,317.72 2,317.72

Grips 210.00 210.00 210.00 210.00 210.00 210.00 210.00 210.00 210.00 210.00 210.00 210.00 2,520.00

TOTAL C/S 5,793.77 10,012.00 11,825.83 10,590.53 14,787.27 13,324.44 17,429.94 5,010.78 2,662.21 3,945.75 2,926.90 4,815.76 103,125.15

EXPENSES 410,704.17

NET PRO SHOP 122,874.57 135,347.26 141,804.47 176,499.05 204,429.65 202,842.77 151,696.02 127,436.75 120,564.76 122,437.62 117,343.99 121,084.31 1,337,257.05

Golf Course Maintenance Budget 1,337,257.05

NET PRO SHOP 0.00

ASSUMPTIONS:

Set-a-Sides equal to 2015-16 Levels ( 32/wk, none on Wed or Fri to minimize standby list)

2017-2018 FY


Mid Year 2016-17 Capital Budget Review

Capital Cash brought into 2016-17 Budget Yr 360,397$

Collected in this FY 343,200$

Spent through Planned expenditures

2017 Budget 05/31//2017 before FY end

Replace fire sprinkler heads (outdated) $2,600 0 0

Refurbish kitchen backdoor covered area $5,000 0

Replace fountains ($3k) we own 4 $3,000 0

HVAC (Golf Maintenance Center) $12,000 12,000

Payback Emerg/GC Spec Imp fund/loan for Irrig Renov $56,000 56,000

Acoustics/ceiling tiles $15,726 15,726

Replace fans in Ballroom $6,000 0

Replacement of all mics, body packs & receivers $10,000 10,000

Coolers $15,000 7,500

Televisions (5) $5,000 0

Steamer (US Food) $17,000 17,000

Pizza Oven $22,500 22,500

40 Qt Mixer $6,000 6,000

Heavy Duty 36" Gas Range (2 @ $4500 per) $9,000 9,000

Gas 36" Salamander Broiler (2 @ $2600 per) $5,200 5,200

Convection Oven Double Deck (front line) $10,000 10,000

Convection Oven Double Deck (back line) $10,000 10,000

Solstice Fryer (70-90 lbs) $6,800 6,800

83" Refrigerated Prep Table-Pantry $6,500 6,500

Remote Beer System $5,500 5,500

Oven-Dutch Alto Sham $5,300 5,300

Tilt Skillet, Braising Pan 30 gal $10,400 0

Kitchen Service Bar $11,000 8,000

Furniture - replace loungers & chairs with brown $2,000 0

Umbrellas w/stands $5,000 5,000

Air Handler - 3 large (ballroom) $33,000 33,000

Air Handler - 1 large, 1 small $32,000 32,000

Ballroom Chairs - replacement (425 chairs - 100 are red) $5,000 5,000

Dumpster Enclosure (concrete block) $21,372 21,372

GPS mapping of CLIS system $7,000 0

Pickleball Court Project $28,964 9,779 19,185

Additional Restroom at Tennis/Bocce/Shuffleboard $14,000 14,000

403,862$

Items not in original budget but approved by Board:

Community Master Plan Consultant Fee 50,000

Utility Truck or Kuboto 17,810

$9,779 $410,393

Variance between budget (including donations) & FY end expenditures -$16,310

Calculated carryforward into 2017-2018 Budget Yr $283,426

Reconciliation with 2017-18 Capital Master List

Items not in original budget but approved by board (see above) 0

Potential Future Land Acquisition Costs (TW lots) -9,055

Costing Allowance (10% of annual proj needs) -36,300

Estimated New Owner Capital for FY17 73750

15 Unplatted Lots paid out of capital -131868.42PY Rollover Cash from Capital Master List (Cell P183) $179,952

Golf Course Special Improvements Fund

Practice Range Boat for ball retreival 4,379.00

Golf Course Renovation Consultant Fee 25,000


Def Maint Cash brought into 2016-17 Budget Yr 213,467$

Collected in this FY 187,200$

2016-17 Monthly Restitution Deferred Maintenance Budget Credit 15,100$

Spent through Planned expenditures

2017 Budget 5/31/2017 before FY end

Tree trimming throughout property & golf course $20,000 21,600 0

Trees throughout property (replacement/removal) $14,000 3,188 10,812

Parking Lot Traffic Signs $750 0 750

Seal Parking lot (clubhouse -main & pro shop) $22,200 1,530 20,670

Seal Parking lot (club rear, W lot, lot @ Palo Duro) $7,000 0 7,000

Seal Parking lot (fitness area) $3,000 0 0

Seal Parking lot (tennis & shuffle) $2,000 0 2,000

Seal GCM/CLIS building asphalt $10,000 0 10,000

Admin Bldg (breezeway women 2015/men 2017) $10,000 0 10,000

Cart/Multi Use Path (asphalt Via La Quinta to Kaidon Ln) $6,000 0 6,000

Cart Path- Golf Course (concrete) $5,000 4,600 400

Clean Clubhouse Roof - Wet it and forget it $3,000 828 2,172

Clubhouse Roof Checkup & Cracked Tile Repair $9,500 1,950 7,550

Conservation Easement Maintenance (exotic removal) $7,000 3,250 3,750

Palmetto Trimming (includes pinestraw & disposal) $25,500 31,470 0

Tint windows in rest/lounge/admin hall/pro shop $5,500 0 5,500

Aesthetic Clubhouse Facility Improvements $10,000 0 10,000

Lake erosion: property $50,000 0 50,000

Pool pipe/leak maintenance $2,500 0 0

Irrigation Pump Repairs $6,000 0 6,000

Drainage $3,000 0 3,000

Wind screen $1,000 0 1,000

Nets (6) $900 0 900

Pickleball Court Maintenance $2,000 0 2,000

225,850

Items not in original budget but approved by Board:

Bridge 3,000

Freezer Refridgeration (Floor Repair) 5,000

Replace Fountains (3k) we own 4 3,720 0

Furniture - restrap loungers & chairs with brown 450 1,550

Shuffle Board Seating - Repaint and Repair 1,586 0

Turbidity Barrier - 8 anchors installed 2,408

Pro Shop Christmas Tree & Stand 130

Ballroom Fans 2,676

Handi-cap Access for Bathrooms 4,991

Pickle Balls & Paddles (initial supply) 964

Fitness Center Building Issue 12,943

Model Sail Boat Dock 2,199

Replace fire sprinkler heads - moved from capital 2,127 473

GL 102,610 169,527

Variance between budget & FY end expenditures -$46,288

Calculated carryforward into 2017-18 Budget Yr $143,629

Reconciliation with 2017-18 Deferred Maint. Master List

Items not in original budget but approved by board (see above) 26,312

Worse than budget on Tree trimming throughout property & golf course 1600

Worse than budget on Palmetto Trimming (includes pinestraw & disposal) 1470

Worse than budget on Fountain Replacement 720

Worse than budget on Shuffle Board Seating - Repaint and Repair 86

Mid Year 2016-2017 Def Maint Budget Review


REVISED 5 year Equipment Replacement Plan

Quantity Estimated Price Annual lease exp impact

2017-2018

Toro Sand Pro 2040 Z 1 $19,000.00

Toro Reelmaster 5510-D Fairway Mower 1 $54,249.79 based on proposed plan $38,562.72

John Deere 310 Front Loader/Back Hoe 1 $65,000.00 lease expiring 5/17 ($5,638.00)

EZGO 1200 2 $17,920.00 lease expiring 10/17 ($50,401.00)

EZGO Hauler Pro 2 $19,115.32

TOTAL: $175,285.11

2018-2019

Toro Greensmaster 3320 TriFlex Hybrid Tee Mower 1 $41,722.23 based on proposed plan $37,310.68

Toro Groundsmaster 4500-D Rough Mower 1 $68,229.54 lease expiring 11/18 ($22,957.00)

EZGO 1200 2 $17,920.00

Toro Greensmaster 3150 TriFlex Hybrid Greens Mower 1 $41,722.23

TOTAL: $169,594.00

2019-2020

Toro Reelmaster 5510-D Fairway Mower 1 $54,249.79 based on proposed plan $41,978.55

Toro Sidewinder Trim Mower 2 $68,332.28 lease expiring 10/19 ($45,860.00)

Toro Groundsmaster 4500-D Rough Mower 1 $68,229.54

TOTAL: $190,811.61

2020-2021

Toro Groundsmaster 4500-D Rough Mower 1 $68,229.54

Toro Greensmaster 3320 TriFlex Hybrid Greens Mower 1 $41,722.23 based on proposed plan $38,653.35

Toro Pro Core 648 1 $24,023.03 lease expiring ($33,767.00)

Toro Greensmaster 3320 TriFlex Hybrid Tee Mower 1 $41,722.23

TOTAL: $175,697.03

2021-2022

Toro Sprayer 1 $41,642.74 based on proposed plan $36,668.54

Toro Sand Pro 2040 Z 1 $19,000.00

Toro Greensmaster 3320 TriFlex Hybrid Greens Mower 1 $41,722.23

Toro 4x4 1600 2 $22,588.00

Toro Greensmaster 3320 TriFlex Hybrid Tee Mower 1 $41,722.23

TOTAL $166,675.20

Version 3 Final Version Date 7-5-2017

version 3 page 1 - hggcc.comhggcc.com/hgrd/files/financials/budget.pdf · version 3 page 1 version...

Documents