Clarification questions:
-
Are we talking about revenues (total sales) rather than profit (total sales – total expenses)? Correct
-
Can I assume that we’re on a regular year before Covid19? Yes
-
Since I’m not familiar with the way waiters are compensated, can we ignore tips? Yes
-
Would you like me to include takeaways and deliveries as well? Yes
My favorite restaurant is an Asian Fusion Restaurant.
Equation:
Yearly Revenues = [# of weeks the restaurant open] X [# of customers a week] X [Average Order Value] + [# of Special Events] X [Extra charge for a special event]
Assumptions:
# of weeks the restaurant open
-
Every year there are 356/7=~51 weeks.
-
I assume that every three years, the restaurant closed for renovations for 2 weeks- once in every 3 years -> 4.66 days for every year.
-
In our country, there are about 5 days every year in which restaurants are closed (holidays, memorial, special events)
-
In total, there are 9.66 days in which restaurants are closed.
-
I’ll assume that the restaurant is open for 49 weeks a year.
# of customers a week
|
Hours
|
Sun
|
Mon
|
Tue
|
Wed
|
Thur
|
Fri
|
Sat
|
|
12:00-14:00
|
90%
|
90%
|
90%
|
90%
|
90%
|
Closed
|
Closed
|
|
14:00-18:00
|
30%
|
30%
|
30%
|
30%
|
30%
|
Closed
|
Closed
|
|
18:00-21:00
|
90%
|
90%
|
90%
|
90%
|
90%
|
Closed
|
90%
|
|
21:00-23:00
|
30%
|
30%
|
30%
|
30%
|
90%
|
Closed
|
60%
|
# of customers in the restaurant a week = sum of (capacity) X (number of hours) X (number of customers an hour) = 90% X 30 X 120 + 30% X 28 X 120 + 60% X 2 X 120 = 3,240 + 1,008 + 144 = 4,392
I assume that in any given time, the restaurant supports additional 15% customers out of the restaurant
# of customers ordering delivery or takeaway a week 4,392 X 15% = 659
Therefore, # of customers a week = 4,392 + 659 = 5,051
[Average Order Value]
[# of Special Events]
-
A special event is when the restaurant is closed only for special guests.
-
I assume that the restaurant will have 3 special events a month, which are 36 events during a year.
[Extra charge of a special event]
Sub equation: [Alternative income during the time of the event] X [% additional charge]
-
Such an event lasts on average 5 hours (incl. preparation and getting back to business).
-
I assume that the restaurant will still serve takeaways and do deliveries in parallel.
-
The alternative to such an event is 3 hours with 30% capacity+ 2 hours with 90% capacity , which are 30% X 3 X 120 + 90% X 2 X 120 = 108 + 216= 324 customers.
-
I assume that the restaurant will charge at least 50% more for a special event, which is 50% X $35 X 324 = $5,670.
Final calculation:
Yearly Revenues = [# of weeks the restaurant open] X [# of customers a week] X [Average Order Value] + [# of Special an year Events] X [Extra charge for a special event] = 49 X 4,392 X $35 + 36 X $5,670 = $7,532,280 + $204,120
Yearly Revenues = $7,736,400.
Sanity check, it seems reasonable.
Things that we can consider if trying to get even more profound:
-
Kids and babies that take a sit.
-
Having a separate calculator for eating in the restaurant and order.
-
Celebration of small events where people usually spent more.