1. A Company has 3 profitable retail brands in India (Jeramai, Marzu nd Xandreial).

Post covid the company wants to study the following:

Sale Trend of Sept19 - Feb20

oRegion wise in graphical representation on MRP as well as Net Sales.

oDiscount hit trendingregion wise.

oAverage Transaction value (=Net Sale / Qty Sold) store wise and region wise monthly to be made. Final graphicrepresentation should be region wise.

ProfitabilityAnalysis

oApart from expenses mentioned in the master sheet store wise, company has Cost of Good sold as 24.5%, Taxes of 8.22% of MRP and corporate overheads of 7.12% of MRP.

oAdvise the company on which stores to continue, and which stores to shut down basis the profitability, sales trends and costs involved.

oGive a graphicalrepresentation on the company's profitability month wise and region wise.

Covid analysis

oPost Covid hitting the country, the companyestimates a 15% rise in sales of brand Jeramaiwhile a Monthly drop of 50%, 42%, 21%, 11% and 2% respectively in the months of Mar, Apr, May, Jun, Jul respectively from the existing 6 months avg sales.

oAdvise the company on which stores it should retain and which stores it should shut down basis the store wise profitability analysis.

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