OUTDOOR RESORT - PALM SPRINGS Forecast
Mar-21 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
Actual 413,391 46,879
Actual 411,794 60,600
Actual 422,787 62,764
Budget Budget
Budget Actual/Budget
Budget
Administration Resort Services
396,086 11,258
402,235
404,964 33,705
399,673 16,432
398,520 10,301
4,870,633
4,875,409
(4,776)
5,038
3,935
332,826 27,283 14,850 11,770
452,871 135,270 98,835 11,734
(120,045) (107,987) (83,985)
Lifestyles
- - -
- - -
- - -
- - -
639
5,000
2,822 4,807 2,822
8,822 7,336 2,694
- -
- -
- - -
Bar
2,707 1,891
-
-
Golf
1,346
1,825
915
277
36
Total Revenues
407,345
407,273
403,991
416,591
450,304
452,729
467,095
482,846
504,403
439,584
416,382
408,821
5,257,363
5,574,119
(316,756)
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,224 22,719 18,349
61,790
74,946 14,079 23,370
73,614 16,985
67,246 13,928
847,259 184,118 137,015 33,727 71,968
64,435
73,637 17,677 20,840
891,438 211,550 251,051 83,555 102,743
44,179 27,432 114,036 49,828 30,775 (18,467)
6,733
8,478
322
19,004
113
113
Lifestyles
(2,716)
6
6
3,511 7,855
5,116
347
41
7,551
9,849
- -
- -
Bar
6
7,294
-
-
14,467 114,341 30,669
10,046 116,071 40,239
10,303 116,894 45,044
10,114 113,639 23,468
10,085 113,006 38,171
Golf
(1,796)
10,894 116,580 49,291
1,467,627
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
457,665 46,773 239,665 727,462 77,498 944,384
Security Mailroom Facilities
472,768 54,888 262,118 729,481 76,316 880,709 142,136
15,103
1,698
2,013
2,517
7,257
4,647
2,855
3,972
5,382
4,897
4,898
1,659
4,978
8,115
13,548 65,234
20,620 72,026
27,695 60,131
22,180 59,089
24,498 69,707
31,670 75,545
15,546 37,433
23,975 53,595 10,934 80,197
11,673 65,373
13,957 62,988
11,356 45,939
22,947 60,403
22,453
Maintenance & Repair Vehicles Maintenance
2,019
4,602
5,790
7,965
4,069
7,279
6,353
7,465
5,925
6,794
4,201
6,121
(1,182) (63,675) 142,136 372,751
103,989
72,827
74,472
82,400
78,928
76,097
78,679
69,323
66,133
Utilities
89,558
71,781
Contingency
-
-
-
-
-
-
-
-
-
-
-
-
-
Total Expenses
413,610
438,856
426,177
466,382
435,645
477,981
476,095
385,394
457,590
462,443
405,500
389,489
5,235,162
5,607,913
Net Income/(Loss)
(6,265)
(31,583)
(22,186)
(49,791)
14,659
(25,252)
(9,000)
97,452
46,813
(22,859)
10,882
19,332
22,201
(33,794)
55,995
Page 25 of 88
Made with FlippingBook flipbook maker