Snapshot Analysis of Sales Data for September of Profitable Retail Brands Assessment 3 Answer

Sales Data Report
Introduction

The following report provides a snapshot analysis of sales data for September 2019 till February 2020. Sales data pertains to three brands sales in India. The data is categorized through stores, regions and format of ownership.

Data Consolidation

Firstly, the given data for various months were consolidated in one sheet of excel for ease of creating pivot tables and charts. This was done by copying and pasting data one after the other for all months. A column for month was also added to identify what month a data point refers to.

Once this was done, various pivot tables and charts were created.

Charts

MRP & Net Sales

The above charts indicate that maximum MRP sale and Net Sales were in South region. The next top region was West followed closely East and NCR. The north region indicated minimum numbers.

The trend charts indicate similar pattern for all states where the numbers are at peak in January and the lowest in September/October. 

It was also seen that while West was higher than East in terms of MRP sale, net sales were higher for East region indicating very high discounts and taxes in West.

Discounts

The table shows that overall, almost 35.6% of MRP is given as discount and taxes. The percentage was highest in North at 38.2% while the lowest in East at 33.2%. This is noted in following charts also that provide average of discounts in regions:

Average Transaction Value

The chart provides monthly average transaction value for various regions and can be seen that it stable at same level for September to December and then dips in January and picks again in February.

Ownership Format

It can be seen that maximum sales are own stores and lesser sales are from franchisee. However, average transaction value is same in either case. Also, Jaremei brand has maximum sales, followed by Marzudo and then Xanderiel.