Coursework, Other Spreadsheets and Data in Economics

Coursework, Different
Spreadsheets and Information in Economics

ECN112 Spreadsheets and Information in Economics Coursework Process 2
Is there competitors within the UK grocery store business The Competitors Fee is curious about investigating the extent

of competitiveness within the business and hires you to hold out the evaluation. The file ECN112 UK Supermarkets Gross sales.xlsx

accessible on QMPlus experiences the extent of gross sales for the UK grocery store chains and impartial outlets in 2012 and 2013. The

figures are in hundreds of kilos.
a) Present an evaluation of the extent of competitors within the business by plotting the Lorenz curves and
by computing the GINI coefficients. Remark in your findings (not more than 300 phrases). (three marks)
b) Just lately Aldi and Lidl have expressed an curiosity in merging. The 2 corporations declare
new bigger firm would be capable of higher problem the market leaders in order that, finally, shoppers would profit. The

Competitors Fee has been requested to research Aldi and
Lidls declare and you’ve got been requested to hold out the evaluation on behalf of the Competitors Fee. What would your

recommendation be (not more than 300 phrases) (2 marks)
Common steering notes
You need to perform your evaluation in Excel and please reply the 2 questions on separate worksheets. You need to submit your

Excel file on-line on QMPlus. When submitting the file on-line please make it possible for the file title is made up of the preliminary

of your title (all one phrase) adopted by your surname (e.g., gvolpe.xlsx). The duty accounts for 5 marks and the

deadline is 23.59pm (GMT) on Sunday 30th November 2014.

SupermarketTotal gross sales in 2012 (000s)Complete gross sales in 2013 (000s)
Aldi 733 061,00 961 395,00
Asda four 242 670,00 four 276 248,00
Co-operative1 580 784,00 1 574 040,00
Farm Meals134 695,00 173 905,00
Iceland 479 105,00 491 597,00
Impartial supermarkets498 294,00 520 051,00
Lidl 660 351,00 751 201,00
Morrisons 2 814 236,00 2 855 745,00
Different grocery store chains439 617,00 496 157,00
Sainsbury’s4 078 869,00 four 186 914,00
Tesco 7 372 225,00 7 427 304,00
Waitrose1 104 036,00 1 201 202,00