BDM CAPSTONE · JAN–JUN 2026

Friends
Corner runs
on ₹3.08L

154 days of handwritten stationery-shop bills, digitized and cracked open — here's exactly what's selling, when, and why.

📍 Darbhanga, Bihar 🗓 22 weeks · 75 SKUs 🕘 9AM–9PM · B2C
DATA
VERIFIED
154
Days Tracked
75
Products
8,357
Units Sold
11
Categories
Total Revenue₹3,08,623
₹3,08,623 TOTAL REVENUE 8,357 UNITS SOLD 75 PRODUCTS TRACKED 54.6% FROM FAST-MOVERS SATURDAY TOP SALES DAY ₹8,700 TOP SKU REVENUE ₹3,08,623 TOTAL REVENUE 8,357 UNITS SOLD 75 PRODUCTS TRACKED 54.6% FROM FAST-MOVERS SATURDAY TOP SALES DAY ₹8,700 TOP SKU REVENUE
01 · Business Context

The Store & The Problem

Friends Corner is a single-owner B2C stationery shop selling school and office supplies. Its records lived on paper bills — this project turns them into decisions.

Store Profile
Basic details of the business studied.
Store Name
Friends Corner
Owner
Raj Kamal
Store Type
B2C Stationery
Location
Laheriasarai, Darbhanga
Hours
9 AM – 9 PM
Employees
1
Initial Investment
₹10,000
Study Window
Jan – Jun 2026
Dataset
22 wks · 154 days
Where The Money Lands
Category-level read, before the deeper charts below.
🏆 TOP EARNERS — NOTEBOOK & ART SUPPLIES
40.7% of total revenue from just 2 of 11 categories.
📦 HIGH VOLUME, LOW VALUE — PEN, ADHESIVE, OFFICE
Move the most units, but far less revenue per unit.
📉 STEADY, LOW SHARE — ERASER & SHARPENER
Each under 2% of revenue despite daily demand.
Problem 1 — No Visibility
75 SKUs, no systematic way to see what's actually working.
  • Sales tracked by hand on paper bills
  • No product- or category-wise revenue view
  • Slow/non-moving stock goes unnoticed
  • Purchasing runs on memory, not numbers
Problem 2 — Unexplained Swings
Weekly revenue swings from ₹6,561 to ₹21,787.
  • No structured weekly / day-wise tracking
  • Staffing and stock timed by guesswork
  • Cash vs. account split never analysed
  • Peak sales days undocumented until now
Data Collection
SourcePrimary · Handwritten Bills
Duration1 Jan → 4 Jun 2026
Records22 wks · 75 products
VariablesDate, product, qty, revenue
Digitized InGoogle Sheets
Author
BDM Capstone Project, IIT Madras.
Submitted By
JAY KUMAR
Roll Number
24F2004977
02 · Reading The Numbers

Sales Analytics

22 weeks of product-level data across 11 categories — where the revenue concentrates, when it swings, and which days move the register.

Category Revenue
Share of ₹3,08,623 across 11 categories
FIG 1
Day-wise Sales
Total revenue by weekday
FIG 2
Weekly Revenue Trend
Week 1 to 22 · Jan – Jun 2026
FIG 3
Top 10 Products by Revenue
Highest earners across all 22 weeks
FIG 4
Revenue Pareto
Top 20 products, cumulative %
FIG 5
FSN Revenue Split
Fast / Slow / Non-Moving
FIG 6
Fast-Moving · 47 products54.6%
Slow-Moving · 25 products42.3%
Non-Moving · 3 products3.2%
Descriptive Stats — Weekly Revenue
22-week study period
FIG 7
₹14,028
MEAN
₹13,129
MEDIAN
₹4,493
STD. DEV
₹21,787
HIGH · WEEK 7
₹6,561
LOW · WEEK 18
81.6/18.4
CASH VS ACC. %
03 · How It Was Read

The Framework

Five methods, applied in this order — from a plain overview to specific purchasing and stocking decisions.

01
KPI Analysis
Overall Performance
Total revenue, units sold, average weekly/daily revenue, and cash vs. account collection — one snapshot before drilling into products.
02
Product & Category
Product-wise & Category-wise Sales
Units and revenue computed for 75 products across 11 categories. Notebook (23.1%) and Art Supplies (17.6%) lead — answering Problem Statement 1.
03
Pareto Analysis
80/20 Cumulative Ranking
Products ranked by revenue with cumulative % tracked. Top 20 products already cover 42%+ of total revenue.
04
FSN Classification
Fast, Slow & Non-Moving
Split by units sold. Fast-Moving items — 47 of 75 products — generate 54.6% of revenue.
05
Trend Analysis
Weekly & Day-wise Trend
Saturday and Friday together carry 37% of weekly revenue, Sunday the least at 10.3% — answering Problem Statement 2.
04 · What To Do Next

The Action Plan

Four low-cost, data-backed moves a single-owner store can act on immediately.

PILLAR 01
Inventory Priority
Align stock with what actually earns.
  • Keep 47 Fast-Moving SKUs (54.6% revenue) always stocked
  • Review 3 Non-Moving products (3.2%) for discount or exit
  • Direct budget to the top 20 Pareto products
  • Set a periodic review cycle for Slow-Moving stock
PILLAR 02
Category Focus
Shelf space should follow revenue.
  • Prime placement for Notebook + Art Supplies (40.7%)
  • Bundle Pen + Pencil — high volume, thin margin
  • Keep Eraser/Sharpener stock lean but steady
  • Review category revenue monthly, not from memory
PILLAR 03
Weekly Planning
Match effort to the real rhythm.
  • Full stock and staffing Fri–Sat (37% of weekly revenue)
  • Use quiet Sunday/Wednesday for restocking
  • Plan cash handling around 81.6% cash-collection share
  • Watch revenue against the ₹14,028 average to spot dips
PILLAR 04
Digital & Growth
Keep the habit this project started.
  • Continue digital sales logging, not paper
  • Build back-to-school / exam-season combos
  • Use the dashboard for a quick weekly review
  • Explore bulk orders for schools
Projected Impact
Financial
Fewer stockouts on high-revenue SKUs, less capital in Non-Moving stock.
Operational
Weekend-aligned staffing and stocking with a clear weekly read.
Strategic
A repeatable, dashboard-based habit replacing paper guesswork.