prsentation on a case study

Attached you will find: 1. Excel material with data series about the Romanian sales trends for Juice market over the last 2 years. The data are given in two-month cycles/periods, so that DJ15 refers to December 2014 – January 2015; ON15 refers to October-November 2015 and so on. 2. PowerPoint material with info about Romanian Shopper preferences Your task is to present, with the help of CHARTS, the evolution of Juice market sales in the Romanian market for the respective 2 years, using an analytical strategy set by you, as if you were presenting it for a new manufacturer which is now entering the Juices market and to formulate recommendations based on both sales data and shopper insights. For this presentation, the following indicators are available: Market: Total Romania, and also the channels (store types) breakdown. Products: Juice category and its segments (juice type, package type, size of pack, fruit contents, main flavours) Indicators: sales volume (1.000 liters), sales value (1.000 EUR), sales items (1.000 pieces), unit price (of one liter), price per piece (price per product) Periods: two-month periods for the respective 2 years – 2014-2015. QUESTIONS THAT YOU NEED TO ANSWER: How do the sales modify on an annual basis? - cummulated years sales evolution in quantity, value, pieces: not calendar years, but the last 12 month, meaning the totals for the last 6 bi-monthy periods compared to the previous 6 bi-monthly periods. Which segments are growing on an annual basis? - Market should be segmented by: type of juice, size of pack, package type, fruit content, main flavours Which is the importance of each channel in volume / value terms within total country sales and channels evolution in time? List your main recommendations (few bullet points) as if your client wants to enter the market and needs to understand what are the main opportunities on this market in terms of: - Products - Price - Channels - Promotions Your recommendations should be based on the data included in the attached table and shopper insights. The created Excel charts need to be saved in a PowerPoint presentation