Apr-20 Forecast
Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20
Total
Total
Variance
Revenue Assessment
Actuals Actuals Actuals Actuals Actuals Actuals Actuals Actuals Actuals Actuals Budget
Budget Actual/Forecast Budget
362,687
362,687
362,687
362,687
362,687
362,687
362,687
362,687
362,687
362,687
362,687
362,687
4,352,244
4,352,244
-
Fees & Permits Rental & Other
1,550
1,363 1,955 2,912
1,261 2,311 3,179
2,025 4,926
3,240 8,498
3,969 9,446
3,358 7,332
3,904
3,632
907
2,157 1,295 4,725
2,157 1,195 2,580
29,522 92,456 308,433 99,267 63,395
30,032 63,930 319,635 155,534 68,375
(510)
12,708
19,874 80,505 25,810 19,642
17,352 61,726 13,966
5,564
28,526
Front Office/Admin Fee
2,628
12,858
36,640 21,485 12,414
37,786 13,251
66,747 24,755 15,343
(3,853)
(11,202) (56,267) (4,980)
Activities Direct
- - - -
- - - -
Bar
-
8,655
7,341
Store
-
-
-
-
Golf
1,538
11,588
5,714
4,645
3,822
150
27,457 83,463
14,042 100,397
13,415
Laundry
1,064
902
2,081
6,863
15,516 462,018
1,386
18,336 504,272
17,015 534,082
13,093 483,619
3,956
2,152
1,099
(16,934) (47,952)
Total Revenue Expenses Front Office Activities Direct
380,636
369,818
371,518
389,359
448,768
369,261
373,166
369,718
5,056,237
5,104,189
8,487
(2,764) (42,972)
16,672 7,939 10,153
12,916 14,547 14,184 14,198 12,162
13,699 10,643
8,744
144,344 147,108 61,031 104,003
-
7
7,276 11,895
8,762 21,919 11,055
117 455
Bar
3,579
62,905
5,549
1,957
11,788 13,960 19,539 17,176
68,454
Store
-
-
876
(876)
0
0
Golf
(481)
77,014
898 929
0
4,117 1,122
18,509 14,124 16,557
6,294 15,075
657
3,060
77,912
Laundry
-
-
3,701
542
295
481
479
479
-
417
417
7,004
7,933
Admin
56,274 32,247
110,559 (14,328) (2,927) (19,959) (18,158) (1,876) (2,061) (28,407) (64,101)
72,834 55,827 77,934 29,167 31,987 35,418
81,841 128,487 122,022 61,081 107,832 39,215 39,508 47,782 41,457 27,632
68,416 72,231 35,176 36,184
62,124 36,184
966,903 856,344 431,956 446,284
Security Mailroom
1,241
3,105
46,207
1,449 1,519
2,434
4,835 4,415
6,506
4,838
4,172
4,383
4,383
43,280
Activites Non Direct
107
113 2,186 12,176 9,773 26,653 29,184
21,595 25,030 20,239 18,735 15,394 23,420 27,350 29,789 24,345 20,637
13,538
75
75
129,263 149,222 242,574 260,732 1,404,180 1,406,056
Facilities Grounds
11,150 147,230
15,050 12,720
12,503
108,727 107,467 140,408 109,654 108,329 112,040 112,994 111,744
111,911 118,838 114,838
Vehicle Maint
6,101
5,362
72,733
6,425 5,453
4,794
7,528 4,240
4,828
6,434
6,514
6,604
6,389
70,672
Maint
52,614 77,468
56,581 58,509 55,260 80,794 80,550 57,607
40,888 57,270 53,169 56,939 47,972 72,721 69,314 77,292 71,600 72,079
57,798 71,055 55,981 71,536
54,445 71,527
662,500 690,907 858,469 922,570
Utilities
Contigency
-
-
-
-
-
-
Total Expenses
392,438
382,536
381,791
432,571
452,728
518,764
533,190
458,490
454,107
383,483
407,746
371,629
5,169,472
5,249,965
(80,493)
Net Income/(Loss)
(11,802)
(12,718)
(10,272)
(43,212)
9,291
(69,995)
(28,917)
75,593
29,512
(14,222)
(34,579)
(1,910)
(113,235)
(145,776)
32,541
Made with FlippingBook flipbook maker