Urban Reach Mart

Data Analysis Report

About Urban Reach Mart

Urban Reach Mart is a multi-branch retail store operating in Mandalay, Naypyitaw, and Yangon. We offer diverse products across six categories: Electronic Accessories, Food and Beverages, Sports and Travel, Home and Lifestyle, Fashion Accessories, and Health and Beauty.

Data Analysis Report

This report uncovers sales insights, trends, and customer behavior from January 1, 2019, to March 30, 2019, across 1000 transactions.

Key Metrics:

Sales Insights

Average Gross Income by Day of Week

Day Name Average Gross Income
Monday 14.44
Tuesday 15.52
Wednesday 14.56
Thursday 15.65
Friday 15.05
Saturday 16.30
Sunday 15.92

Insight: Saturday has the highest average gross income compared to other days: 6.18% more than average.

City-Wise Sales & Revenue

City Total Sales Total Quantity Total Gross Income
Mandalay 106,197.67 1,820 5,057.03
Naypyitaw 110,568.71 1,831 5,265.18
Yangon 106,200.37 1,859 5,057.16

Insight:

  • Naypyitaw has the highest gross income compared to other cities: 2.71 % More than average.
  • Yangon has the highest quantity compared to other cities: 1.22 % More than average.

Customer Behavior Analysis

Normal vs Member Customers

Customer Type Total Sales Total Quantity Total Gross Income
Member 164,223.44 2,785 7,820.16
Normal 158,743.30 2,725 7,559.21

Insight: Members account for 3.45% more sales than Normal customers. Continue leveraging loyalty programs.

Female vs Male Distributions

Gender Total Sales Total Quantity Total Gross Income
Female 167,882.93 2,869 7,994.43
Male 155,083.82 2,641 7,384.94

Insight: Female customers lead with 3.96% more gross income than male customers.

Ratings Trends

City wise Ratings Trends

City Branch Average Ratings
Mandalay B 6.81
Naypyitaw C 7.07
Yangon A 7.02

Insight: Branch A has the highest average rating compared to other branches: 1.44 % More than average.

Customer Type Ratings Trends

Customer type Average Ratings
Member 6.94
Normal 7.00

Insight:Normal Customers are more statisfied compared to Members: 0.93 % More than Members.

Product Line Ratings Trends

Product Line Average Ratings
Electronic Accessories 6.92
Fashion Accessories 7.02
Food and Beverages 7.11
Health and Beauty 7.00
Home and Lifestyle 6.84
Sports and Travel 6.91

Insight:Food and beverages has the highest Average Ratings between all the Product lines.

Product Line Analysis

Performance by Product Line

Product Line Total Sales Total Quantity Total Gross Income
Food and Beverages 56,144.84 952 2,673.56
Electronic Accessories 54,337.53 971 2,587.50
Fashion Accessories 54,305.89 902 2,585.99
Health and Beauty 49,193.73 854 2,342.55
Home and Lifestyle 53,861.91 911 2,564.85
Sports and Travel 55,122.82 920 2,624.89

Insight: Food and Beverages has the highest gross income compared to other product lines: 4.30% more than average.

Product Line Performance by Day

Product Line Day with Max Sales Percentage Above Average
Electronic Accessories 19 129.87%
Fashion Accessories 8 119.96%
Food and Beverages 27 82.77%
Health and Beauty 15 138.88%
Home and Lifestyle 3 94.29%
Sports and Travel 17 95.43%

Insight: Health and Beauty has the highest sales on the 15th day, 138.88% above the daily average.

Product Line Performance by Day of Week

Product Line Day with Max Sales Percentage Above Average
Electronic Accessories Thursday 53.55%
Fashion Accessories Saturday 38.91%
Food and Beverages Wednesday 36.03%
Health and Beauty Tuesday 27.05%
Home and Lifestyle Sunday 43.69%
Sports and Travel Saturday 32.39%

Insight: Electronic Accessories has the highest sales on Thursdays, 53.55% above the weekly average.

Hourly Performance Analysis by Product Line

Product Line Hour with Max Sales Percentage Above Average
Electronic Accessories 19 18.95%
Fashion Accessories 13 36.59%
Food and Beverages 19 59.45%
Health and Beauty 14 53.28%
Home and Lifestyle 17 48.52%
Sports and Travel 19 56.63%

Insight:

  • Electronic accessories: Max sales occurred at 19 Hour: 18.95% more than average
  • Fashion accessories: Max sales occurred at 13 Hour: 36.59% more than average
  • Food and beverages: Max sales occurred at 19 Hour: 59.45% more than average
  • Health and beauty: Max sales occurred at 14 Hour: 53.28% more than average
  • Home and lifestyle: Max sales occurred at 17 Hour: 48.52% more than average
  • Sports and travel: Max sales occurred at 19 Hour: 56.63% more than average

Sales Trends

Sales History

Month Total Sales
January 116291.868
February 97219.374
March 109455.507

Insight:

  • Month with highest sales: January
  • Percentage by which it exceeds the average sales: 8.02%

Sales by Day of Week

Day of Week Total
Sunday 37899.0780
Monday 51482.2455
Tuesday 43731.1350
Wednesday 45349.2480
Thursday 43926.3405
Friday 56120.8095
Saturday 44457.8925

Insight: Day with highest sales: Friday with 56120.8095 sales more than average by 21.64%.

Hourly Sales

Insight: Most sales occur at 19 Hour: 35.21 % More than average.

Payment Types Analysis

Distribution

Payment Type Count
Ewallet 345
Cash 344
Credit Card 311

Insight: Ewallet is used for the most transactions.

Distribution of Payment Types in Total Sales Transactions

Payment Type Total Sales Average Sales
Cash 112,206.57 326.18
Credit Card 100,767.07 324.01
Ewallet 109,993.11 318.82

Average Distribution of Payment Types in Gross Income

Payment Type Gross Income Gross Margin Percentage
Cash 15.53 4.76%
Credit Card 15.43 4.76%
Ewallet 15.18 4.76%

Insight: Cash payments generate the highest gross income per transaction at 15.53.

Product line Sales by Payment method

Insight: Ewallet is the most preferred payment method but has the lowest average gross income per transaction.

Q & A

Q1: Which city generates the highest sales and gross income?

Answer: Naypyitaw generates the highest sales and gross income with 110,568.71 in sales and 5,265.18 in gross income, surpassing the average by 2.71%.

Insight: Focus on strengthening marketing campaigns in Naypyitaw to sustain and expand this lead.

Q2: Which customer type contributes more to sales and gross income?

Answer: Members outperform normal customers with 164,223.44 in sales and 7,820.16 in gross income, accounting for 3.45% more than average sales and 2.20% higher quantities sold.

Insight: Membership loyalty programs are effective. Consider adding exclusive perks to retain members.

Q3: How does gender influence sales and gross income?

Answer: Female customers lead with 167,882.93 in sales and 7,994.43 in gross income, contributing 3.96% more to gross income than males.

Insight: Tailored promotions for female customers, especially in Health and Beauty and Fashion Accessories, could increase engagement.

Q4: What is the most profitable day of the week?

Answer: Saturday has the highest average gross income at 16.30, which is 6.18% above the weekly average.

Insight: Targeted promotions or special events on Saturdays could amplify this trend.

Q5: Which product line has the highest gross income?

Answer: Food and Beverages leads with 2,673.56 in gross income, outperforming the average by 4.30%.

Insight: Expand offerings in this category and consider bundling strategies to boost sales.

Q6: How do payment methods impact sales and customer preferences?

Answer: Ewallet is the most preferred payment method with 345 transactions but has the lowest average gross income per transaction at 15.18. Cash payments generate the highest gross income per transaction at 15.53.

Insight: Incentivize the use of Ewallet through discounts to maintain its popularity while improving profitability.

Q7: What is the trend in ratings?

Answer: Branch A (Yangon) has the highest average rating of 7.03. Normal customers have a slightly better satisfaction score (7.01) than members (6.94).

Insight: Investigate member feedback to enhance their experience and satisfaction levels.

Q8: When do most sales occur during the day?

Answer: The 19th hour (7 PM) sees the highest sales, 35.21% above the hourly average.

Insight: Boost staffing and optimize inventory replenishment during this peak hour to maximize efficiency.

Q9: What are the top-performing days and hours for product lines?

Answer: Food and Beverages perform best on Wednesdays and at 7 PM, with sales 82.77% above daily average and 59.45% above hourly average, respectively. Health and Beauty sees peak sales on Tuesdays and at 2 PM, with sales 138.88% above the daily average and 53.28% above hourly average, respectively.

Insight: Develop time-specific campaigns for different product lines to leverage these trends.

Q10: Which product line sells the most quantity?

Answer: Electronic Accessories leads with 971 units sold, exceeding the average quantity by 5.74%.

Insight: Ensure ample stock availability and explore cross-selling opportunities with complementary product lines.

Q11: How does the sales trend evolve over the months?

Answer: January exhibits the highest sales, 8.02% above the average monthly sales.

Insight: Capitalize on this strong start with new year promotions and clearance sales.

Conclusion

Urban Reach Mart's sales are heavily influenced by location (Naypyitaw), customer type (members), and timing (Fridays, 7 PM). Investing in customer loyalty programs, optimizing peak-time operations, and tailoring promotions to customer demographics can drive sustained growth. Payment incentives and product-specific campaigns could further enhance revenue and customer satisfaction. Businesses can capitalize on the growing preference for E-wallets by offering exclusive discounts or rewards for digital payments to further encourage adoption.