OUTDOOR RESORT - PALM SPRINGS Forecast
28-Feb-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
Budget Budget Budget
Budget Actual/Budget
Budget
Administration Resort Services
396,086 11,258
402,235
412,519 77,257 23,026 17,080
404,964 33,705
399,673 16,432
398,520 10,301
4,860,365
4,875,409
(15,044) (105,552) (93,783) (74,241)
5,038
3,935
347,319 41,487 24,594 11,352
452,871 135,270 98,835 11,734
Lifestyles
- - -
- - -
- - -
- - -
639
5,000
2,822 4,807 2,822
- -
- -
- - -
Bar
2,707 1,891
-
-
Golf
1,346
1,825
2,276
915
277
(382)
Total Revenues
407,345
407,273
403,991
416,591
450,304
452,729
467,095
482,846
532,158
439,584
416,382
408,821
5,285,118
5,574,119
(289,001)
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
73,614 16,985
67,246 13,928
843,425 192,228 152,111 36,976 76,644
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
48,013 19,322 98,940 46,579 26,099
6,733
8,478
322
19,004
113
113
Lifestyles
(2,716)
6
6
3,511 7,855
5,116
347
41
7,551
- -
- -
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
Golf
(1,796)
10,894 116,580 49,291
1,473,201
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
(24,041)
458,081 46,288 241,793 733,790 73,616 945,669
Security Mailroom Facilities
472,768 54,888 262,118 729,481 76,316 880,709 142,136
14,687
1,698
2,013
2,517
7,257
4,647
2,855
3,972
4,897
4,898
1,659
4,897
4,978
8,600
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
11,673 65,373
13,957 62,988
11,356 45,939
26,103 59,923
22,947 60,403
20,325 (4,309)
Maintenance & Repair Vehicles Maintenance
4,602
5,790
7,965
4,069
7,279
6,353
7,465
5,925
6,794
4,201
7,052
6,121
2,700
103,989
72,827
74,472
82,400
78,928
76,097
78,679
69,323
66,133
Utilities
89,558
81,482
71,781
(64,960) 142,136
Contingency
-
-
-
-
-
-
-
-
-
-
-
-
-
Total Expenses
413,610
438,856
426,177
466,382
435,645
477,981
476,095
385,394
496,250
462,443
405,500
389,489
5,273,822
5,607,913
334,091
Net Income/(Loss)
(6,265)
(31,583)
(22,186)
(49,791)
14,659
(25,252)
(9,000)
97,452
35,908
(22,859)
10,882
19,332
11,296
(33,794)
45,090
Made with FlippingBook Publishing Software