Profit and Loss Statement

Submitted by: Md. Atik Shahriar, Foyjul Nabil Gony, Lissa Benny
Submitted to: Professor. Michael Crich
Subject: Plan 5001
Submission Date: 02/14/2021
Profit and Loss Statements (P & L Statements) of Two Year
Peak Season (April to September) Year 1

April May June July August September

Occupancy 70% 80% 90% 100% 100% 80%
(Assumed)
Family (350.00*4) (350.00*4) (350.00*4) (350.00*4) (350.00*4) (350.00*4)
Cottage/Vill *30days *30days *30days *30days *30days *30days
a Sales rate = 42,000 = 42,000 = 42,000 = 42,000 = 42,000 = 42,000
(4 Cottage) (*70%) (*80%) (*90%) (*100%) (*100%) (*80%)

Couple (250.00*3) (250.00*3) (250.00*3) (250.00*3) (250.00*3) (250.00*3)

Honeymoon *30days *30days *30days *30days *30days *30days
Suits Sales = 22,500 = 22,500 = 22,500 = 22,500 = 22,500 = 22,500
rate (3 (*70%) (*80%) (*90%) (*100%) (*100%) (*80%)
Suits)

Room Sale (79.00*14) (79.00*14) (79.00*14) (79.00*14) (79.00*14) (79.00*14)

(14 room) *30days *30days *30days *30days *30days *30days
=33,180 =33,180 =33,180 =33,180 =33,180 =33,180
(*70%) (*80%) (*90%) (*100%) (*100%) (*80%)

Total (42,000 + (42,000 + (42,000 + (42,000 + (42,000 + (42,000 +

Revenue 22,500 + 22,500 + 22,500 + 22,500 + 22,500 + 22,500 +
from Villa, 33,180) 33,180) 33,180) 33,180) 33,180) 33,180)
Suits and =97,680 =97,680 =97,680 =97,680 =97,680 =97,680
Single *70% *80% *90% *100% *100% *80%
rooms = 68,376 = 78,144 = 87,912 = 97,680 = 97,680 = 78,144
EUR EUR EUR EUR EUR EUR

Entertainme 250 ticket / 300 Ticket / 350 Ticket / 400 Ticket / 500 Ticket / 400 Ticket /
nt Ticket 30 EUR 30 EUR 30 EUR 30 EUR 30 EUR 30 EUR
sale = 7, 500 = 9,000 = 10,500 = 12,000 = 15,000 = 12,000
(Assumed) EUR EUR EUR EUR EUR EUR

Grand Total 68376 + 78144 + 87912 + 97,680 + 97,680 + 78144 +

Monthly 7500 9000 10500 12,000 15000 12000
In EURO = = = = = =
75,876.00 87,144.00 98,412.00 109,680.00 112,680.00 90,144.00
Down/Non-peak Season (October to March) Year 1

October November December January February March

Occupancy 75% 70% 65% 60% 65% 70%
(Assumed)
Family (280.00*4) (280.00*4) (280.00*4) (280.00*4) (280.00*4) (280.00*4)
Cottage/Vill *30days *30days *30days *30days *30days *30days
a Sales rate = 33,600 = 33,600 = 33,600 = 33,600 = 33,600 = 33,600
(4 Cottage) (*75%) (*70%) (*65%) (*60%) (*65%) (*70%)

Couple (180.00*3) (180.00*3) (180.00*3) (180.00*3) (180.00*3) (180.00*3)

Honeymoon *30days *30days *30days *30days *30days *30days
Suits Sales = 16,200 = 16,200 = 16,200 = 16,200 = 16,200 = 16,200
rate (3 (*75%) (*70%) (*65%) (*60%) (*65%) (*70%)
Suits)

Room Sale (65.00*14) (65.00*14) (65.00*14) (65.00*14) (65.00*14) (65.00*14)

(14 room) *30days *30days *30days *30days *30days *30days
=27,300 =27,300 =27,300 =27,300 =27,300 =27,300
(*75%) (*70%) (*65%) (*60%) (*65%) (*70%)

Total (33,600 + (33,600 + (33,600 + (33,600 + (33,600 + (33,600 +

Revenue 16,200 + 16,200 + 16,200 + 16,200 + 16,200 + 16,200 +
from Villa, 27,300) 27,300) 27,300) 27,300) 27,300) 27,300)
Suits and =77,100 =77,100 =77,100 =77,100 =77,100 =77,100
Single *75% *70% *65% *60% *65% *70%
rooms = 57,825 = 53,970 = 50,115 = 46,260 = 50,115 = 53,970
EUR EUR EUR EUR EUR EUR

Entertainme 300 ticket / 280 Ticket / 250 Ticket / 250 Ticket / 280 Ticket / 300 Ticket /
nt Ticket 25 EUR 25 EUR 25 EUR 25 EUR 25 EUR 25 EUR
sale
(Assumed) = 7,500 = 7,000 = 6,250 = 6,250 = 7,000 = 7,500
EUR EUR EUR EUR EUR EUR

Grand Total 57,825 + 53,970 + 50,115 + 46,260 + 50,115 + 53,970 +

Monthly 7,500 7000 6250 6,250 7000 7500
In = = = = = =
EURO 65,325.00 60,970.00 56,365.00 52,510.00 57,115.00 61,470.00
Peak Season (April to September) Year 2

April May June July August September

Occupancy 80% 90% 100% 100% 100% 90%
(Assumed)
Family (399.00*4) (399.00*4) (399.00*4) (399.00*4) (399.00*4) (399.00*4)
Cottage/Vill *30days *30days *30days *30days *30days *30days
a Sales rate = 47,880 = 47,880 = 47,880 = 47,880 = 47,880 = 47,880
(4 Cottage) (*80%) (*90%) (*100%) (*100%) (*100%) (*90%)

Couple (299.00*3) (299.00*3) (299.00*3) (299.00*3) (299.00*3) (299.00*3)

Honeymoon *30days *30days *30days *30days *30days *30days
Suits Sales = 26,910 = 26,910 = 26,910 = 26,910 = 26,910 = 26,910
rate (3 (*80%) (*90%) (*100%) (*100%) (*100%) (*90%)
Suits)

Room Sale (89.00*14) (89.00*14) (89.00*14) (89.00*14) (89.00*14) (89.00*14)

(14 room) *30days *30days *30days *30days *30days *30days
=37,380 =37,380 =37,380 =37,380 =37,380 =37,380
(*80%) (*90%) (*100%) (*100%) (*100%) (*90%)

Total (47,880 + (47,880 + (47,880 + (47,880 + (47,880 + (47,880 +

Revenue 26910 + 26910 + 26910 + 26910 + 26910 + 26910 +
from Villa, 37380) 37380) 37380) 37380) 37380) 37380)
Suits and =112170 =112170 =112170 =112170 =112170 =112170
Single *80% *90% *100% *100% *100% *90%
rooms = 89,736 = 100,953 = 112,170 = 112,170 = 112,170 = 100,953
EUR EUR EUR EUR EUR EUR

Entertainme 300 ticket / 350 Ticket / 400 Ticket / 500 Ticket / 500 Ticket / 400 Ticket /
nt Ticket 40 EUR 40 EUR 40 EUR 40 EUR 40 EUR 40 EUR
sale = 12000 =14000 = 16000 = 20,000 =20,000 = 16,000
(Assumed) EUR EUR EUR EUR EUR EUR

Grand Total 89,796+120 100953+14 112170+16 112170+20 112170+20 100953+1600

Monthly 00 000 000 000 000 0
In EURO = = = = = =
 101,796.00 114,953.00 128,170.00 132,170.00 132,170.00 116,953.00

Down/Non-peak Season (October to March) Year 2

October November December January February March

Occupancy 80% 70% 60% 60% 70% 80%
(Assumed)
Family (299.00*4) (299.00*4) (299.00*4) (299.00*4) (299.00*4) (299.00*4)
Cottage/Vill *30days *30days *30days *30days *30days *30days
a Sales rate = 35,880 = 35,880 = 35,880 = 35,880 = 35,880 = 35,880
(4 Cottage) (*80%) (*70%) (*60%) (*60%) (*70%) (*80%)

Couple (199.00*3) (199.00*3) (199.00*3) (199.00*3) (199.00*3) (199.00*3)

Honeymoon *30days *30days *30days *30days *30days *30days
Suits Sales = 17,910 = 17,910 = 17,910 = 17,910 = 17,910 = 17,910
rate (3 (*80%) (*70%) (*60%) (*60%) (*70%) (*80%)
Suits)

Room Sale (69.00*14) (69.00*14) (69.00*14) (69.00*14) (69.00*14) (69.00*14)

(14 room) *30days *30days *30days *30days *30days *30days
=28,980 =28,980 =28,980 =28,980 =28,980 =28,980
(*80%) (*70%) (*60%) (*60%) (*70%) (*80%)

Total (35,880 + (35,880 + (35,880 + (35,880 + (35,880 + (35,880 +

Revenue 17,910 + 17,910 + 17,910 + 17,910 + 17,910 + 17,910 +
from Villa, 28980) 28980) 28980) 28980) 28980) 28980)
Suits and =82,770 =82,770 =82,770 =82,770 =82,770 =82,770
Single *80% *70% *60% *60% *70% *80%
rooms = 66,216 = 57,939 = 49,662 = 49,662 = 57,939 = 66,216
EUR EUR EUR EUR EUR EUR

Entertainme 300 ticket / 280 Ticket / 250 Ticket / 250 Ticket / 280 Ticket / 300 Ticket /
nt Ticket 30 EUR 30 EUR 30 EUR 30 EUR 30 EUR 30 EUR
sale
(Assumed) = 9000 =8400 EUR = 7500 = 7500 =8400 EUR = 9000 EUR
EUR EUR EUR

Grand Total 66,216+900 57,939+840 49662 + 49662 + 57,939+840 66,216 +

Monthly 0 0 7500 7500 0 9000
In EURO = = = = = =
75,216.00 66,339.00 57162.00 57162.00 66,339.00 75,216.00
Profit and Loss of Seven Cities
The Profit and Loss Statement of Seven Cities has been divided into four quarters
in a year which shows two quarters of peak season and two quarters of down
season.
Table for color-coding of the quarters of the year
Quarters Color
Quarter 1 Blue
Quarter 2 -Red

Quarter 3 Green
Quarter 4 Yellow

First Year
In Year 1, the first quarter is not predicted to be a fruitful season since we will be
expecting less global customers in this Season. The first quarter starts from
January – March in the first year we are expecting an occupancy rate of 60- 75
percent which will generate a monthly revenue of about 57510 – €75000.There is
a loss in month of January since we cannot hire more part-time workers in the
house-keeping department whereas we do have the full- time workers so its
difficult to provide the full-time workers with the minimum hours a week.
Though, by the start of March we will be expected to get some customers from
around the world which will raise our profit percent by 10 percent than the
previous two months.
The quarter 2 which starts from April to June is considered as profitable season
which generates an occupancy rate of 70 - 90 percent and a revenue of €75000-
€98000.This is the season we expect to welcome our global visitors even though
April will be considered as a dull period in this quarter where the room revenues
will only start to raise from 70 percent and the loss here mainly occurs in our
Restaurant because we need to hire new part-time staffs who can speak multiple
languages in order to welcome our global guests. But the situation will totally
improve with the end of May where we get more guests and increase the revenue
and profit percent by 20 percent.
The quarter 3 is from July- September may generate an occupancy rate of 80 -100
percent; if that is the case, we can a expect a monthly revenue of €90000-
€150000 in total. Quarter three’s drop month can be considered as July because
Since we are welcoming our guests we need to care for our maintenance and
quality services in order to make our guests comeback at the next time of the year
so we should keep up with the guests request so even we have 80 percent
occupancy rate we could use almost 25 percent of that for the maintenance and
repair services. But we will gain almost 15 percent of that back in month
September
The quarter 4 that starts from October and till December cannot be considered as
an exciting month either where we are expecting a low occupancy rate that can
vary between 60-75 percent and a revenue of €56000 to €65000. This month is
not exciting at all because this is the season, we get low occupancy and the worst
month can be considered as October because this a month we start our contracts
for renovation purposes, such as window cleaning and replacement of furniture's
or machines so we are going to face a loss of almost 20 percent of our total
revenue of that month for this; but we will get back in feet by the end of
November where the contract will get to an end and we get almost a 10-15
percent increase in our profits from last year

Second Year
Our second year of seven cities is also expected to have similar characteristics of
year one with slight improvements.
The first quarter is not anticipated to be a good season, since we are expecting
fewer multinational customers this season. The first quarter begins from January
– March in the first year, with an occupancy rate of 60-80 per cent projected to
produce monthly revenue of about €57000 – €61470. In order improve the quality
we decided to purchase more quality goods so the month of January can be
considered as a low month since the 15 percent of the revenue of the month goes
for the purchase of Materials ( mainly for the restaurant) which will give a loss
15% and then we will improve the situation in March where the revenue
increases and produces a profit of 20 percent more than the month of January
The second quarter, which begins from April to June, is a successful season with
an occupancy rate of 80 -100 per cent and a revenue of €100000- €128000.We
are trying to improve the technology services in our hotel so we will be
welcoming the robotic services to entertain our guest so the purchase of these
may require the 10 percent of the revenue in the month of April but we will gain a
profit of 20 percent in the month of June since we need less staff support due to
the advancement in the technology .

The 3rd quarter is from July-September and may produce an occupancy rate of
90-100 per cent; if that is the case, we may predict a monthly turnover of
€150000- €132000 in total. This is the peak season we welcome more local as well
as international visitors, so we need to give some motivations to our staffs by
providing them with the staff party of the year and some rewards to keep them
motivated throughout the year so there will be a giveaway from the profit share
of the moth of September which will give you a deduction 30 percent and the July
can be considered as the best month with a revenue profit of 80 percent.
The fourth quarter, beginning in October and finishing in December, cannot be
considered an interesting month, either because we expect a low occupancy rate
that can range from 60-80 per cent and a turnover of between €57000 and
€75000. October can still be considered as a best month since we have our guests
around in our hotel and there is an occupancy rate of 80 percent and the month
of December can be considered as the lowest since we have the purchase of
materials for the biggest celebrations of the year in order to keep the guests
entertained.
Peak season: Grand total monthly sales forecasting Year 1 and Year
2 in EURO

Low/Non-Peak season: Grand total monthly sales forecasting Year 1

and Year 2 in EURO