1. A Company has 3 profitable retail brands in India (Jeramai, Marzudo and Xandreial). Post covid the company wants to study the following:

Sale Trend of Sept19 – Feb20

· Region wise graphical representation on MRP as well as Net Sales. Net Sales is MRP less Discount and Tax.

· Discount hit trending region wise.

· Average Transaction value (=Net Sale / Qty Sold) store wise and region wise monthly to be made. Final graphical representation should be region wise.

· Summary of brand-wise and channel-wise Net and Average Sales

Use the excel sheets provided to work out the above, you must combine data from all excel sheets in one to display results.

2. Record a 5-minute video explaining the trends identified, upload on youtube. You may use a powerpoint presentation in the video but you must be clearly visible.

3. Create a word document mentioning the formula/function you used to achieve the above. Write a personal reflection in 200 words on the task. At the end of the document, paste the link to the youtube video. Document must have a table of contents, your name and student id in header, page number and date in footer.