OUTDOOR RESORT - PALM SPRINGS Forecast
30-Nov-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
Actual 409,656 35,411
Budget Budget Budget Budget Budget Budget Budget Actual/Budget
Budget
Administration Resort Services
396,086 11,258
402,235
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,871,519
4,875,409
(3,890) (27,917) (31,436) (19,983)
5,038
3,935
424,954 103,834 78,852 11,891
452,871 135,270 98,835 11,734
Lifestyles
- - -
- - -
- - -
- - -
639
- -
- -
- - -
Bar
2,707 1,891
Golf
1,500
2,228
2,804
2,276
915
277
157
Total Revenues
407,345
407,273
403,991
416,591
450,303
484,272
552,266
572,064
532,158
439,584
416,382
408,821
5,491,049
5,574,119
(83,071)
Expenses Administration Resort Services
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
(26,157) (9,740) (35,023) (9,974) (12,285)
76,952 21,735
64,309 13,200 14,821
63,407 13,245 12,559
66,423 15,482 14,152
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
865,281 201,810 216,028 73,581 90,458
8,478
Lifestyles
(2,716)
322
113
113
Bar
6
7,294
6
6
3,511 7,855
5,116
- -
- -
Golf
(1,796)
10,894 116,580 49,291
-
-
14,467 114,341 30,669
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
23,177
1,472,337
Security Mailroom Facilities
472,768 54,888 262,118 729,481 76,316 880,709
(13,557) (5,203) (14,153)
459,211 49,685 247,965 732,849 71,191 947,464
1,659
4,897
4,978
1,698
2,013
2,517
7,257
4,997
4,977
4,897
4,897
4,898
11,356 45,939
26,103 59,923
22,947 60,403
13,548 65,234
20,620 72,026
27,695 60,131
22,180 59,089
27,088 59,487
26,304 60,334
24,494 61,922
11,673 65,373
13,957 62,988
Maintenance & Repair Vehicles Maintenance
3,368
4,201
7,052
6,121
(5,125) 66,755 (37,918)
4,602
5,790
7,965
4,069
6,380
6,386
5,906
5,925
6,794
Utilities
89,558 413,610
81,482 496,250
71,781 462,443
103,989 438,856
72,827 426,177
74,472 466,382
82,400 435,644
74,884 502,189
87,589 503,849
73,026 487,470
69,323 405,500
66,133 389,489
Total Expenses
5,427,859
5,465,777
Net Income/(Loss)
(6,266)
(31,584)
(22,186)
(49,792)
14,658
(17,917)
48,417
84,594
35,908
(22,859)
10,882
19,332
63,189
108,342
(45,153)
Made with FlippingBook - professional solution for displaying marketing and sales documents online