Analysis of Black Friars Restaurant Sales and Profit: Project Report

This project analyzes the sales and profit data of Black Friars Restaurant from 2005 to 2015, utilizing line and bar graphs to visualize trends. The analysis includes a comparison of sales and profit, identifying key performance indicators. The project further provides a trend analysis of sales and profit over the specified period, employing linear trend lines to project future performance. Based on the analysis, the project offers recommendations regarding investment decisions, specifically addressing the potential of establishing a new outlet. The report suggests that, based on the negative net present value (NPV) and the internal rate of return (IRR) of the proposed investment, the restaurant should not invest in the project as it would result in a loss. The conclusion is drawn from the financial data and the observed trends in sales and profit over the years, providing a data-driven justification for the recommendation.

Business decision
making

Line graphs of the company sales
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0
50
100
150
200
250
300
350
400
300
320
290 300 310
330
315 320
340 350 355
Sales(00)
Sales(00)

Bar graph of profits
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0
50
100
150
200
250
170 175
160
180 180 185 178 190 195 200
240
Profit(00)
Profit(00)

Bar graph of profits and sales of Black
friars Restaurant
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0
50
100
150
200
250
300
350
400
300
320
290 300 310
330 315 320
340 350 355
170 175 160
180 180 185 178 190 195 200
240
Sales(00)
Profit(00)

Trend analysis of sales and profit
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0
50
100
150
200
250
300
350
400
300
320
290 300 310
330 315 320
340 350 355
170 175 160
180 180 185 178 190 195 200
240
Sales(00)
Linear (Sales(00))
Profit(00)
Linear (Profit(00))

Recommendations
In respect to analysis the following outcomes, it could be
recommends that Black friars Restaurant has two choices such as
invest in project to establish new outlet or not. From the help of
both project, the chosen company should implement their
outcomes in second project investment. This is because, net
present value of this invest program is take place in negative
way. In this aspect, the organisation is facing loss to creating
their results. Hence, it is not good option to invest money within
the project. On the other hand, IRR is the effective way which
describes in term of internal rate of return. In capital investment
in second restaurant is not covering in effective way.

THANK YOU