Extensive Budget Set Up
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Extensive Budget Set Up as PDF for free.
More details
- Words: 962
- Pages: 1
31 Plan 2006 Resort Name goes here PROFIT & LOSS STATEMENT AVIALABLE ROOMS OCCUPIED - PAID COMPLIMENTARY OCCUPIED - TOTAL PAID OCCUPANCY % TOTAL OCCUPACCY % AVERAGE GUESTS/ROOM NO. OF GUESTS AVERAGE RATE REVPAR ROOM REVENUE F&B REVENUE TELPHONE REVENUE M.O.D. REVENUE R.O.I. REVENUE TOTAL REVENUE ROOM REVENUE ROOMS PAYROLL ROOMS OTHER EXP. ROOM PROFIT ROOM PROFITABILITY CAPTURE RATE NO. OF COVERS FOOD AVG. CHECK F&B REVENUE F&B COST OF SALES F&B PAYROLL & BENEFIT F&B OTHER EXP F&B PROFIT F&B PROFITABILITY TEL.REVENUE TEL. C.O.S. TEL PAYROLL TEL OTHER EXP. TEL. PROFIT MOD REVENUE MOD C.O.S. MOD PAYROLL MOD OTHER EXP. MOD PROFIT ROI REVENUE ROI OTHER EXP ROI PROFIT
Jan-06
Feb-06
Mar-06
30
Apr-06
31
May-06
31 RESORTS Jun-06
Jul-06
31
Aug-06
30
Sep-06
31
Oct-06
30
Nov-06
31
Dec-06
Plan 2006
1,612
1,456
1,612
1,560
4,402
4,260
4,402
4,402
4,260
4,402
4,260
4,402
41,030
403
510
1,200
936
2,641
2,769
2,941
2,941
2,556
2,641
2,556
3,081
25,175
0
0
0
0
0
0
0
0
0
0
0
0
0
403
510
1,200
936
2,641
2,769
2,941
2,941
2,556
2,641
2,556
3,081
25,175
25.0%
35.0%
45.0%
60.0%
60.0%
65.0%
70.0%
70.0%
60.0%
60.0%
60.0%
70.0%
61.4%
25.0%
75.0%
75.0%
60.0%
60.0%
65.0%
70.0%
70.0%
60.0%
60.0%
60.0%
70.0%
61.4%
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2,256
2,200
2,400
1,872
5,282
5,538
5,882
5,882
5,112
5,282
5,112
6,162
52,980
3,200.00
3,200.00
3,200.00
2,800.00
2,500.00
2,700.00
3,200.00
3,200.00
2,700.00
2,500.00
2,700.00
3,500.00
4,725.00
800.00
1,120.00
1,440.00
1,680.00
1,500.00
1,755.00
2,240.00
2,240.00
1,620.00
1,500.00
1,620.00
2,450.00
2,899.14
3,609,600
1,632,000
2,880,000
2,626,800
6,602,500
7,476,300
9,411,200
9,411,200
6,928,200
6,602,500
6,901,200
10,783,500
74,865,000
69.1%
1,941,114
1,906,170
744,250
957,600
1,484,280
1,358,280
1,386,630
942,648
617,400
1,295,490
2,757,300
3,782,250
19,173,412
17.7%
50,000
50,000
50,000
50,000
55,000
60,000
70,000
70,000
55,000
55,000
55,000
70,000
690,000
0.6%
33,000
51,000
674,700
839,880
1,369,393
1,187,723
890,393
489,160
676,500
1,301,510
2,659,343
3,382,368
13,554,970
12.5%
0
0
0
0
0
0
0
0
0
0
0
0
0.0%
5,633,714
3,639,170
4,348,950
4,474,280
9,511,173
10,082,303
11,758,223
10,913,008
8,277,100
9,254,500
12,372,843
18,018,118
108,283,382
100.0%
3,609,600
1,632,000
2,323,200
2,620,800
6,602,500
7,476,300
9,411,200
9,411,200
6,928,200
3,515,400
8,053,500
9,151,200
78,652,533
100.0%
376,700
376,700
376,700
402,900
448,600
459,600
465,100
470,600
476,100
476,100
476,100
476,100
5,281,300
119,097
186,560
203,520
138,903
349,932
396,244
4,987,936
427,494
367,195
186,317
426,835
485,014
8,275,047
10.5%
3,113,803
1,068,740
1,742,980
2,078,997
5,803,968
6,620,456
3,958,164
8,513,106
6,084,905
2,852,983
7,150,565
8,190,086
57,178,753
72.7%
86.26%
65.49%
75.02%
79.33%
87.91%
88.55%
42.06%
90.46%
87.83%
81.16%
88.79%
89.50%
72.70%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0
6.7%
0
#DIV/0!
#DIV/0!
1,941,114
1,906,170
2,030,970
1,555,482
3,108,345
3,449,127
4,203,738
4,203,738
1,873,554
1,429,003
3,674,265
5,302,338
34,677,844
100.0%
324,864
316,800
345,600
235,872
594,225
672,867
847,008
847,008
877,640
316,386
724,815
1,323,608
7,426,693
21.4%
515,600
552,400
635,700
707,800
765,300
790,800
814,800
826,800
826,800
826,800
826,800
826,800
8,916,400
25.7%
28,000
28,000
28,000
18,000
28,000
28,000
28,000
28,000
12,000
12,000
28,000
32,000
2,980,000
8.6%
1,072,650
1,008,970
1,021,670
593,810
1,720,820
1,957,460
2,513,930
2,501,930
157,114
273,817
2,094,650
3,119,930
18,036,751
52.0%
55.3%
52.9%
50.3%
38.2%
55.4%
56.8%
59.8%
59.5%
8.4%
19.2%
57.0%
58.8%
52.0%
38,000
38,000
50,000
50,000
55,000
60,000
70,000
70,000
55,000
55,000
55,000
70,000
666,000
100.0%
9,000
9,500
15,000
15,000
16,500
18,000
21,000
21,000
16,500
16,500
16,500
21,000
195,500
29.4%
0
0
0
0
0
0
0
0
0
0
0
0
0
0.0%
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
1.8%
28,000
27,500
34,000
34,000
37,500
41,000
48,000
48,000
37,500
37,500
37,500
48,000
458,500
68.8%
33,000
51,000
108,500
138,680
199,393
192,123
196,393
165,760
159,500
251,710
610,643
733,268
2,839,970
100.0%
20,475
20,475
20,475
29,106
45,627
44,156
27,342
27,342
19,845
61,520
187,040
227,820
731,223
25.7%
0
0
0
0
0
0
0
0
0
0
0
0
0
0.0%
1,200
1,200
1,200
1,200
1,600
1,600
1,600
1,600
1,600
1,600
1,800
1,800
18,000
0.6%
11,325
29,325
86,825
108,374
152,166
146,367
167,451
136,818
138,055
188,590
421,803
503,648
2,090,747
73.6%
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
DEPT. INCOME A&G PAYROLL A&G OTHER S&M PAYROLL S&M OTHER R&M PAYROLL R&M OTHER ENERGY TOTAL OVERHEADS
4,225,778
2,134,535
2,885,475
2,815,181
7,714,454
8,765,283
6,687,545
11,199,854
6,417,574
3,352,890
9,704,518
11,861,664
77,764,751
71.8%
743,940
743,940
743,940
803,940
803,940
803,940
803,940
803,940
803,940
803,940
803,940
803,940
9,467,280
8.7%
49,000
49,000
49,000
49,000
59,000
59,000
59,000
59,000
59,000
59,000
67,500
139,000
756,500
TOTAL PAYROLL AND RELATED & EXP.
GOP GOP % PROPERTY TAX INSURANCE CASH EARNINGS ( LOSS)
0.7%
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
1,021,920
0.9%
181,870
123,370
147,070
119,620
140,870
223,570
130,870
126,870
152,070
132,370
133,370
151,370
1,763,290
1.6%
163,360
163,360
163,360
163,360
163,360
163,360
163,360
163,360
163,360
163,360
164,400
164,400
1,962,400
1.8%
90,922
80,122
80,122
80,122
90,122
90,122
90,122
91,322
91,322
91,322
93,422
93,422
1,062,464
1.0%
288,000
283,000
238,000
230,000
482,000
511,000
595,000
552,000
420,000
469,000
625,000
906,906
5,599,906
5.2%
1,602,252
1,527,952
1,506,652
1,531,202
1,824,452
1,936,152
1,927,452
1,881,652
1,774,852
1,804,152
1,972,792
2,344,198
21,633,760
20.0%
1,884,760
1,921,560
2,004,860
2,163,160
2,266,360
2,302,860
2,332,360
2,349,860
2,355,360
2,355,360
2,356,400
2,356,400
26,649,300
24.6%
2,623,526
606,583
1,378,823
1,283,979
5,890,002
6,829,131
4,760,093
9,318,202
4,642,722
1,548,738
7,731,726
9,517,466
56,130,991
51.84%
46.57%
16.67%
31.70%
28.70%
61.93%
67.73%
40.48%
85.39%
56.09%
16.73%
62.49%
52.82%
51.84% 0
0.0%
0
0.0%
56,130,991
51.84%
MANAGEMENT FEES - BASIC FEES MANAGEMENT FEES - INCENTIVE FEES LICENSE FEES
0
0.0%
0
0.0%
0
0.0%
PROVISION FOR FF&E PLUS:
0
0.0%
2,623,526
606,583
1,378,823
1,283,979
5,890,002
6,829,131
4,760,093
9,318,202
4,642,722
1,548,738
7,731,726
9,517,466
LESS:
Jan-06
Feb-06
Mar-06
30
Apr-06
31
May-06
31 RESORTS Jun-06
Jul-06
31
Aug-06
30
Sep-06
31
Oct-06
30
Nov-06
31
Dec-06
Plan 2006
1,612
1,456
1,612
1,560
4,402
4,260
4,402
4,402
4,260
4,402
4,260
4,402
41,030
403
510
1,200
936
2,641
2,769
2,941
2,941
2,556
2,641
2,556
3,081
25,175
0
0
0
0
0
0
0
0
0
0
0
0
0
403
510
1,200
936
2,641
2,769
2,941
2,941
2,556
2,641
2,556
3,081
25,175
25.0%
35.0%
45.0%
60.0%
60.0%
65.0%
70.0%
70.0%
60.0%
60.0%
60.0%
70.0%
61.4%
25.0%
75.0%
75.0%
60.0%
60.0%
65.0%
70.0%
70.0%
60.0%
60.0%
60.0%
70.0%
61.4%
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2,256
2,200
2,400
1,872
5,282
5,538
5,882
5,882
5,112
5,282
5,112
6,162
52,980
3,200.00
3,200.00
3,200.00
2,800.00
2,500.00
2,700.00
3,200.00
3,200.00
2,700.00
2,500.00
2,700.00
3,500.00
4,725.00
800.00
1,120.00
1,440.00
1,680.00
1,500.00
1,755.00
2,240.00
2,240.00
1,620.00
1,500.00
1,620.00
2,450.00
2,899.14
3,609,600
1,632,000
2,880,000
2,626,800
6,602,500
7,476,300
9,411,200
9,411,200
6,928,200
6,602,500
6,901,200
10,783,500
74,865,000
69.1%
1,941,114
1,906,170
744,250
957,600
1,484,280
1,358,280
1,386,630
942,648
617,400
1,295,490
2,757,300
3,782,250
19,173,412
17.7%
50,000
50,000
50,000
50,000
55,000
60,000
70,000
70,000
55,000
55,000
55,000
70,000
690,000
0.6%
33,000
51,000
674,700
839,880
1,369,393
1,187,723
890,393
489,160
676,500
1,301,510
2,659,343
3,382,368
13,554,970
12.5%
0
0
0
0
0
0
0
0
0
0
0
0
0.0%
5,633,714
3,639,170
4,348,950
4,474,280
9,511,173
10,082,303
11,758,223
10,913,008
8,277,100
9,254,500
12,372,843
18,018,118
108,283,382
100.0%
3,609,600
1,632,000
2,323,200
2,620,800
6,602,500
7,476,300
9,411,200
9,411,200
6,928,200
3,515,400
8,053,500
9,151,200
78,652,533
100.0%
376,700
376,700
376,700
402,900
448,600
459,600
465,100
470,600
476,100
476,100
476,100
476,100
5,281,300
119,097
186,560
203,520
138,903
349,932
396,244
4,987,936
427,494
367,195
186,317
426,835
485,014
8,275,047
10.5%
3,113,803
1,068,740
1,742,980
2,078,997
5,803,968
6,620,456
3,958,164
8,513,106
6,084,905
2,852,983
7,150,565
8,190,086
57,178,753
72.7%
86.26%
65.49%
75.02%
79.33%
87.91%
88.55%
42.06%
90.46%
87.83%
81.16%
88.79%
89.50%
72.70%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0
6.7%
0
#DIV/0!
#DIV/0!
1,941,114
1,906,170
2,030,970
1,555,482
3,108,345
3,449,127
4,203,738
4,203,738
1,873,554
1,429,003
3,674,265
5,302,338
34,677,844
100.0%
324,864
316,800
345,600
235,872
594,225
672,867
847,008
847,008
877,640
316,386
724,815
1,323,608
7,426,693
21.4%
515,600
552,400
635,700
707,800
765,300
790,800
814,800
826,800
826,800
826,800
826,800
826,800
8,916,400
25.7%
28,000
28,000
28,000
18,000
28,000
28,000
28,000
28,000
12,000
12,000
28,000
32,000
2,980,000
8.6%
1,072,650
1,008,970
1,021,670
593,810
1,720,820
1,957,460
2,513,930
2,501,930
157,114
273,817
2,094,650
3,119,930
18,036,751
52.0%
55.3%
52.9%
50.3%
38.2%
55.4%
56.8%
59.8%
59.5%
8.4%
19.2%
57.0%
58.8%
52.0%
38,000
38,000
50,000
50,000
55,000
60,000
70,000
70,000
55,000
55,000
55,000
70,000
666,000
100.0%
9,000
9,500
15,000
15,000
16,500
18,000
21,000
21,000
16,500
16,500
16,500
21,000
195,500
29.4%
0
0
0
0
0
0
0
0
0
0
0
0
0
0.0%
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
1.8%
28,000
27,500
34,000
34,000
37,500
41,000
48,000
48,000
37,500
37,500
37,500
48,000
458,500
68.8%
33,000
51,000
108,500
138,680
199,393
192,123
196,393
165,760
159,500
251,710
610,643
733,268
2,839,970
100.0%
20,475
20,475
20,475
29,106
45,627
44,156
27,342
27,342
19,845
61,520
187,040
227,820
731,223
25.7%
0
0
0
0
0
0
0
0
0
0
0
0
0
0.0%
1,200
1,200
1,200
1,200
1,600
1,600
1,600
1,600
1,600
1,600
1,800
1,800
18,000
0.6%
11,325
29,325
86,825
108,374
152,166
146,367
167,451
136,818
138,055
188,590
421,803
503,648
2,090,747
73.6%
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
DEPT. INCOME A&G PAYROLL A&G OTHER S&M PAYROLL S&M OTHER R&M PAYROLL R&M OTHER ENERGY TOTAL OVERHEADS
4,225,778
2,134,535
2,885,475
2,815,181
7,714,454
8,765,283
6,687,545
11,199,854
6,417,574
3,352,890
9,704,518
11,861,664
77,764,751
71.8%
743,940
743,940
743,940
803,940
803,940
803,940
803,940
803,940
803,940
803,940
803,940
803,940
9,467,280
8.7%
49,000
49,000
49,000
49,000
59,000
59,000
59,000
59,000
59,000
59,000
67,500
139,000
756,500
TOTAL PAYROLL AND RELATED & EXP.
GOP GOP % PROPERTY TAX INSURANCE CASH EARNINGS ( LOSS)
0.7%
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
85,160
1,021,920
0.9%
181,870
123,370
147,070
119,620
140,870
223,570
130,870
126,870
152,070
132,370
133,370
151,370
1,763,290
1.6%
163,360
163,360
163,360
163,360
163,360
163,360
163,360
163,360
163,360
163,360
164,400
164,400
1,962,400
1.8%
90,922
80,122
80,122
80,122
90,122
90,122
90,122
91,322
91,322
91,322
93,422
93,422
1,062,464
1.0%
288,000
283,000
238,000
230,000
482,000
511,000
595,000
552,000
420,000
469,000
625,000
906,906
5,599,906
5.2%
1,602,252
1,527,952
1,506,652
1,531,202
1,824,452
1,936,152
1,927,452
1,881,652
1,774,852
1,804,152
1,972,792
2,344,198
21,633,760
20.0%
1,884,760
1,921,560
2,004,860
2,163,160
2,266,360
2,302,860
2,332,360
2,349,860
2,355,360
2,355,360
2,356,400
2,356,400
26,649,300
24.6%
2,623,526
606,583
1,378,823
1,283,979
5,890,002
6,829,131
4,760,093
9,318,202
4,642,722
1,548,738
7,731,726
9,517,466
56,130,991
51.84%
46.57%
16.67%
31.70%
28.70%
61.93%
67.73%
40.48%
85.39%
56.09%
16.73%
62.49%
52.82%
51.84% 0
0.0%
0
0.0%
56,130,991
51.84%
MANAGEMENT FEES - BASIC FEES MANAGEMENT FEES - INCENTIVE FEES LICENSE FEES
0
0.0%
0
0.0%
0
0.0%
PROVISION FOR FF&E PLUS:
0
0.0%
2,623,526
606,583
1,378,823
1,283,979
5,890,002
6,829,131
4,760,093
9,318,202
4,642,722
1,548,738
7,731,726
9,517,466
LESS:
Related Documents
Extensive Budget Set Up
June 2020 9
Set Up Time
May 2020 12
Organisational Set Up
May 2020 6
Manual Set Up Pablo.docx
December 2019 24
Winamp Karaoke Set-up
November 2019 12