OUTDOOR RESORT - PALM SPRINGS Forecast
31-Dec-20 Actual vs. Budget
Jul-20 Aug-20 Sep-20 Oct-20 Nov-21 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
Actual 409,656 35,411
Actual 408,876 32,507 10,000
Budget Budget Budget Budget Budget Budget Actual/Budget
Budget
Administration Resort Services
396,086 11,258
402,235
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,870,099
4,875,409
(5,310) (43,583) (34,839) (30,883)
5,038
3,935
409,288 100,431 67,952 11,737
452,871 135,270 98,835 11,734
Lifestyles
- - -
- - -
- - -
- - -
639
- -
- -
- - -
Bar
2,707 1,891
-
Golf
1,346
2,228
2,804
2,276
915
277
3
Total Revenues
407,345
407,273
403,991
416,591
450,304
452,729
552,266
572,064
532,158
439,584
416,382
408,821
5,459,507
5,574,119
(114,612)
Expenses Administration Resort Services
76,952 21,735
64,309 13,200 14,821
63,407 13,245 12,559
66,423 15,482 14,152
90,276 19,856 16,087
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
854,393 201,759 201,957 59,993 85,745
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
(37,045) (9,791) (49,094) (23,562) (16,998)
8,478
322
113
113
Lifestyles
(2,716)
6
6
3,511 7,855
5,116
347
- -
- -
Bar
6
7,294
-
-
14,467 114,341 30,669
10,046 116,071 40,239
Golf
(1,796)
10,894 116,580 49,291
1,475,828
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
26,668
462,600 49,335 245,375 743,069 72,090 951,508
Security
472,768 54,888 262,118 729,481 76,316 880,709
(10,168) (5,553) (16,743) 13,588 (4,226) 70,799 (62,124)
1,698
2,013
2,517
7,257
4,647
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
22,180 59,089
24,498 69,707
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
4,602
5,790
7,965
4,069
7,279
6,386
5,906
5,925
6,794
4,201
7,052
6,121
Utilities
89,558
81,482
71,781
103,989 438,856
72,827
74,472
82,400
78,928
87,589
73,026
69,323
66,133
Total Expenses
413,610
426,177
466,382
435,645
477,982
503,849
487,470
496,250
462,443
405,500
389,489
5,403,653
5,465,777
Net Income/(Loss)
(6,266)
(31,584)
(22,186)
(49,792)
14,658
(25,254)
48,417
84,594
35,908
(22,859)
10,882
19,332
55,854
108,342
(52,489)
Made with FlippingBook flipbook maker