Record a video explaining the trends identified

Reference no: EM132531068

Assessment

Part 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.

Part 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.

Part 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.

Attachment:- Sales_Data.zip

Reference no: EM132531068

Questions Cloud

Discuss the pros and cons of outsourcing : Discuss the pros and cons of outsourcing. One on the advantages side, the other real-life example on the disadvantages.

Find how much is the research and development expense : Design, construction and operation of a pilot plant not of a scale economically,How much is the research and development expense in 20x1?

What is Jacks adjusted basis in the house : Jack purchase a house in January 2015 for 119,000 the house was not his primary residence. What is Jack's adjusted basis in the house

Research on service oriented architecture : Do research on service oriented architecture (SOA) and find three different images/diagram that represent its functions and features.

Record a video explaining the trends identified : 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

Prepare the journal entries required : Sheffield Corporation spent $165,600 in research and development costs. Prepare the journal entries required in 2016 and 2017 as a result of the transactions

How much is the research and development expense : How much is the research and development expense?Conceptual formulation and design on possible product or process alternatives

Find how much is the amortization expense : Idependent research company estimated that the remaining useful lofe of the trademark was 10 years. How much is the amortization expense in 20x4?

Discuss Annas income from personal services : With reference to the relevant legislation and/or case law, discuss whether or not these receipts are Anna's income from personal services

User Account

All Pages