OUTDOOR RESORT - PALM SPRINGS Forecast
31-Oct-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 400,056
Actual 402,595 13,996
Budget Budget Budget Budget Budget Budget Budget Budget Actual/Budget
Budget
Administration Resort Services
396,086 11,258
402,235
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,875,571
4,875,409
162
5,038
3,935
436,999 135,270 97,170 11,734
452,871 135,270 98,835 11,734
(15,872)
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
416,591
515,998
484,272
552,266
572,064
532,158
439,584
416,382
408,821
5,556,744
5,574,119
(17,375)
Expenses Administration Resort Services
76,952 21,735
64,309 13,200 14,821
63,407 13,245 12,559
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
869,618 204,075 233,883 80,056 97,049
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
21,820
8,478
7,475
322
113
113
Lifestyles
(2,716)
17,168
6
6
3,511 7,855
- -
- -
Bar
6
7,294
3,499 5,694
-
-
Golf
(1,796)
10,894 116,580 49,291
1,470,576
Grounds & Greens
153,865 38,625
113,929 36,841
119,180 41,385
152,462 40,563
121,080 36,517
116,580 36,852
1,449,160
(21,416)
467,963 47,325 249,328 732,389 73,737 935,077
Security
472,768 54,888 262,118 729,481 76,316 880,709
4,805 7,563
1,698
2,013
2,517
4,897
4,997
4,977
4,897
4,897
4,898
Mailroom Facilities
1,659
4,897
4,978
13,548 65,234
20,620 72,026
27,695 60,131
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
12,790 (2,908)
Maintenance & Repair Vehicles Maintenance
4,602
5,790
7,965
6,615
6,380
6,386
5,906
5,925
6,794
4,201
7,052
6,121
2,579
Utilities
89,558
81,482
71,781
(54,368)
103,989 438,856
72,827
74,472
70,013
74,884
87,589
73,026
69,323
66,133
Total Expenses
413,610
426,177
466,383
468,861
502,189
503,849
487,470
496,250
462,443
405,500
389,489
5,461,077
5,465,777
4,700
Net Income/(Loss)
(6,266)
(31,584)
(22,186)
(49,793)
47,137
(17,917)
48,417
84,594
35,908
(22,859)
10,882
19,332
95,667
108,342
(12,676)
Made with FlippingBook Ebook Creator