OUTDOOR RESORT - PALM SPRINGS Forecast
30-Sep-20 Actual vs. Budget
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Total
Total
Variance
Revenue
Actuals Actual
Actual Budget Budget Budget Budget Budget Budget Budget Budget Budget Actual/Budget Budget
Administration Resort Services
396,086 11,258
402,235
400,056
405,407 22,173
413,708 47,456 32,075 21,025
410,296 48,173 13,403 10,900
418,079 77,816 32,945 21,198
416,840 91,632 33,821 26,967
412,519 77,257 23,026 17,080
404,964 33,705
399,673 16,432
398,520 10,301
4,878,383
4,875,409
2,974
5,038
3,935
445,176 135,270 98,835 11,734
452,871 135,270 98,835 11,734
(7,696)
Lifestyles
- - -
- - -
-
- -
- -
- - -
- - -
Bar
1,665
Golf
-
1,734
1,500
2,228
2,804
2,276
915
277
Total Revenues
407,345
407,273
403,991
429,245
515,998
484,272
552,266
572,064
532,158
439,584
416,382
408,821
5,569,398
5,574,119
(4,721)
Expenses Administration Resort Services
76,952 21,735
64,309 13,200 14,821
71,476 16,059 24,494
70,760 17,747 32,007 11,591 21,058 112,580 39,421
101,164 19,907 30,158 13,935 14,759 112,580 36,850
70,892 18,989 43,424 17,099 14,759 116,580 36,516
72,090 19,994 43,776 13,510 14,759 116,580 36,516
73,614 16,985
67,246 13,928
877,687 206,889 245,817 83,573 100,947
64,435
71,112 22,190 38,466 13,098 14,761 118,580 38,586
73,637 17,677 20,840
891,438 211,550 251,051 83,555 102,743
(13,751) (4,661) (5,234)
8,478
322
113
113
Lifestyles
(2,716)
6
6
7,028
- -
- -
Bar
6
7,294
18
-
-
11,753 140,280 50,618
Golf
(1,796)
10,894 116,580 49,291
(1,796)
1,458,394
Grounds & Greens
153,865 38,625
113,929 36,841
119,180 41,385
121,080 36,517
116,580 36,852
1,449,160
9,234 5,250
478,017 49,431 251,929 732,433 72,089 935,122
Security
472,768 54,888 262,118 729,481 76,316 880,709
1,698
2,013
4,623
4,897
4,997
4,977
4,897
4,897
4,898
Mailroom Facilities
1,659
4,897
4,978
(5,457) (10,189)
13,548 65,234
20,620 72,026
30,296 60,175
23,543 58,629
27,088 59,487
26,304 60,334
24,494 61,922
11,673 65,373
13,957 62,988
11,356 45,939
26,103 59,923
22,947 60,403
Maintenance & Repair Vehicles Maintenance
2,952
4,602
5,790
6,317
6,615
6,380
6,386
5,906
5,925
6,794
4,201
7,052
6,121
(4,227) 54,413
Utilities
89,558
81,482
71,781
103,989 438,856
72,827
74,517
70,013
74,884
87,589
73,026
69,323
66,133
Total Expenses
413,610
426,178
497,636
468,861
502,189
503,849
487,470
496,250
462,443
405,500
389,489
5,492,330
5,465,777
26,553
Net Income/(Loss)
(6,266)
(31,584)
(22,186)
(68,391)
47,137
(17,917)
48,417
84,594
35,908
(22,859)
10,882
19,332
77,068
108,342
(31,275)
Made with FlippingBook - Online Brochure Maker