1 of 10

Analyzing the Business Model of a Jockey Outlet

Business Data Management

Capstone Project

�

Akash Sharma

22f2000700

2 of 10

About the Company�

SR Associates

Inner, Active & Casual : Wear

City Center Mall, Guwahati

No. of Employees: 4

Annual Turnover: ₹ 2,71,21,109

Owner: Shubham Goyal

Timing: 10:30AM to 09:30PM

3 of 10

Data Overview & Challenges�

Detailed Sales Data

Datewise Sales Summary

Inventory Management

Low Foot Traffic

Revenue Fluctuations

Contains Product Name, Category, Salesman, and Quantity Sold.

From April’23 to July’23, contains Total Bills, Quantity Sold, Revenue & Payments.

Stockouts on high-demand items; overstock of off-season products.

Limited weekday foot-traffic reduces customer exposure and awareness.

Inconsistent sales across months, affecting steady profitability and growth.

4 of 10

Analytical Approach

Division Insights

Data Collection

Descriptive Analysis

Data Cleaning

Visualization

Trend Analysis

Analyzed product categories to identify top-selling items and their revenue impact.

MS Excel & Pandas in Python.

Sales patterns and seasonal fluctuations over time.

Excel & Matplotlib to convey insights and support data-driven decisions.

Sales Data from April to July 2023.

Evaluated total bills, quantity sold, and revenue metrics.

5 of 10

Inventory Performance�

T-Shirts, Shorts, Trunks, Boxers and Brief generate over 40% of total revenue.

44%

Revenue Concentration

Class A products account for over 65% of revenue; Class C items contribute minimally.

67%

Class Analysis

T-SHIRT BRA, EVERYDAY BRA, VEST generate an equivalent revenue highlighting their significant role in overall sales.

₹ 417,843.50

Essential Items

6 of 10

Revenue Dynamics�

In July, the revenue reached its highest point at ₹3,113,873, highlighting a notable increase in sales performance from April to July.

May experiences the lowest revenue, i.e., ₹2,43,6072 indicating a temporary slowdown before recovery in June and July.

May's revenue dip is likely due to seasonal factors like the onset of the monsoon, leading to reduced consumer demand and lower shopping activity during that time.

7 of 10

Transaction Overview�

Customers typically buy 3 items per transaction, reflecting a trend of moderate bundled purchases and potential for upselling.

13 transactions involve the purchase of 2 items, suggesting a pattern of low-commitment or more selective customer buying behavior.

Out of all transactions, only 1 involved the purchase of 5 items, highlighting that high-value purchases of larger baskets are relatively rare occurrences.

8 of 10

Profit Analysis�

POSITIVE

NEGATIVE

EXTERNAL

INTERNAL

Sports Men's, Premium 2, and top-selling items like T-Shirts, Shorts, and Trunks drive significant profit.
69.1% of transactions via card payments, allowing for targeted promotions through digital wallets and credit card offers.

T-Shirts and Shorts exhibit high returns compared to others, indicating issues with product fit or quality, which impacts profitability.
Revenue fluctuations and low weekday traffic reduce sales opportunities, especially during off-peak hours.

Aligning inventory with seasonal demand (summer vs. winter items) can enhance profit by reducing overstock and stockouts.
Weekday promotions, loyalty programs, and upselling strategies can boost customer engagement and increase basket sizes.

Monsoon periods and off-season sales drops pose risks to consistent revenue.
Other brands may attract customers, especially if SR Associates doesn't address low-performing segments like Sports Thermals and Kids products.

STRENGTH

WEAKNESS

OPPORTUNITY

THREAT

9 of 10

Sales Enhancement Strategies�

Run off-season clearance, bundle slow-moving items, and offer loyalty programs for larger basket purchases.

Implement real-time stock tracking to optimize product replenishment.

Maintain consistent mid-month offers and launch weekday discounts to boost low weekday footfall.

Prioritize summer products, increase winter stock, and adjust financial plans based on seasonal sales patterns.

Launch promotional campaigns pre-monsoon to counteract low revenue.

Partner with digital wallets for exclusive offers to attract tech-savvy customers.