Business Decision Making:
You are working in WLCBMS as a Business Analyst; the Principal has provided you with the following data:
Year Sales (£’000) Cost(£’000) Profit(£’000)
2002 250 200 50
2003 280 190 90
2004 300 200 100
2005 310 200 110
2006 350 190 160
2007 330 190 140
2008 300 180 120
2009 280 160 120
2010 280 170 110
2011 300 170 130
2012 350 190 160
You have been asked by the Board to forecast future Sales and Profit for the upcoming Annual Board Meeting.
You should include the following on your answer:
• Produce a Column/Bar graph showing Sales, Cost and Profit using Microsoft Excel.
• Produce a sales and profit scattergraph showing trend lines and project sales and profit for 5 years into the future.
• Show the regression equation separately on the graph.