Ujjaval Rana

Sales Analysis Report The S-Mart Supermarket Prepared By: Date: Email: Ujjaval Rana Bell International 27/10/2021- Th e S - Mar t S u p e r m ar k e t S-Mart supermarket is having wide range of c o n s u m e r product category generating ample amount of sales data on daily basis. Utilizing the sam e fo r understandin g sales pattern so that business decision can be m ade to m eet dem ands of everchanging m arket. Business Task Identify different factors affecting sales so that future business decision can be made to formulate different offers and utilize resources effectively. Key stakeholders O w n e r - Mr . S n e h a l R a n a 1 Prepare Data Data has been gathered from company’s sales register software. Data includes below details  Daily footfall details  Monthly segment-wise sales  Monthly Payment distribution  Total item sales qty in 2021 till oct. Different financial year files have been merged year-wise to make it more useful for analysis Process Data Data has been cleaned and transformed using excel & R-Studio. Different data rows and columns has been formatted and manipulated to make it ready for loading in tableau for analysis Analysis Top 3 Days with highest Customer Count • Sunday (Avg: 209) • Friday (Avg: 152 ) • Wednesday (Avg: 152 ) Avg spend by customers on Top 3 days • Sunday ( Rs-716/-) • Wednesday ( Rs- 553/-) • Friday (Rs-541/-) Major Customer traffic Time on Top 3 Days • Sunday-12 PM,5-8 PM • Wednesday-12 PM,5-6 PM • Friday-5-6 PM Note: In 2021 comparatively on Monday there is good sales (Rs-725/- ) approx. 26.5% higher from last year (Further Exploration needed ) Spend Amount & Customer Count Vs Weekday 2 Highest avg Monthly sales are in July & August from Past 3 years. (Detailed Analysis Required ) Avg Monthly Sales Trend 4 Item segment wise trend throughout the year Total Items are divided in 39 Segment. Major Item Segment for July & August months are 1. OIL/GHEE/VANASPATI(12.5) 2. FOOD GRAINS / GROCERY (22.5) 3. DRY FRUIT(3.0) 4. MASALA/SPICES(4.5) 5. TEA/COFFEE(4.5) 6. FARSHAN CHIKI MITHAI (2.0) For Diwali Period Below are top items Over All Segment Share % Sr No- Segment OIL/GHEE/VANASPATI(12.5) FOOD GRAINS / GROCERY (22.5) DRY FRUIT(3.0) MASALA/SPICES(4.5) TEA/COFFEE(4.5) FARSHAN CHIKI MITHAI (2.0) CLEANIG MATERIAL(3.0) WASHING AID(5.0) BAKERY PRODUCT/BISCUITS(5.0) SUGAR / SALT(3.0) INSTANT FOOD / READY TO EAT (3) DAIRY/FROZEN PRODUCT(2.0) BATH SOAP/ HAND WASH / LIQ.SOAP HAIR CARE(3.0) UPVAS(2.0) 5 Item with below segment sale is expected to rise till Dec      DRY FRUIT(3.0) MASALA/SPICES(4.5) OIL/GHEE/VANASPATI(12.5) SUGAR / SALT(3.0) TOYS With reference to 2019 There is potential to grow Garment segment. Note: Most Profitable item list is prepared in dashboard for further exploration.  Method of Payment distribution. Highest Payment Share is through Credit Cards (51.80%) followed by Cash (39.51%) ,PayTm (4.28%) & Sodexho Pass (2.44%) Sharing Dashboard is shared via tableau. 6 Insights and Recommendation  Is there any offers are running on Sunday, Wednesday & Friday? If not , offers should be formulated to leverage more sales with high foot falls. (Identify major sales products on these days and formulate combo offer)  Since in 2021 There is significant increase in foot fall and sales on Monday. It is recommended to run combo offer or promote items sales for Monday.  Top Product segment items are recommended to be stored in center parts of racks & aisle -Since general study shows while finding products customer’s major focus area (55%) will be in center of racks.  Major Customer traffics on different days are  Sunday-12 PM,5-8 PM  Wednesday-12 PM,5-6 PM  Friday-5-6 PM It is recommended that maximum work force should be available at these times to improve customer’s buying experience. In addition to this it is also recommended to leverage benefits from different payment options as per their distribution.  Explore Possibility of improving garment segment. Thank You