Dashboard for Sales Data

📊 Sales Order Dashboard | Digital E-Filing Coach – Amanuddin Education

📊 Sales Order Intelligence Dashboard

Digital E-Filing Coach · Amanuddin Education · FY 2021–22 · 500 Orders Analysed

📌 Key Performance Indicators
💰
Total Revenue
₹6.77Cr
₹6,76,98,630 · FY 2021–22
🛒
Total Orders
500
Apr 2021 – Mar 2022
📊
Avg Order Value
₹1.35L
₹1,35,397 per order
🏆
Commission Earned
₹8.40L
₹8,40,206 total
🚚
Delivered Orders
231
46.2% delivery rate
📅
Avg Receipt Days
97.5
Days from order to receipt
📈 Monthly Sales Trend (Apr 2021 – Mar 2022)
Month-wise Revenue Performance
📦 Product Performance Analysis
Sales by Product (₹)
Quantity Sold by Product
📋 Product Summary Table
#Product NameTotal Sales (₹)Total QtyAvg Rate (₹)Share %
1POWER BANK₹2,40,10,29124,08899735.5%
2BT SPEAKER₹1,16,00,40229,39039517.1%
3TOUCH PAD₹71,96,12214,26150510.6%
4COVER₹66,09,42124,4552709.8%
5BATTERY₹61,57,92111,2015499.1%
6DISPLAY GUARD₹60,65,99329,7562049.0%
7CHARGER₹60,58,48014,9034079.0%
👤 Salesman Performance
Revenue by Salesman (₹)
Salesman Progress Tracker
📋 Salesman Leaderboard
RankSalesmanTotal Sales (₹)Share %Performance
🥇 1Rajesh Chauhan₹1,60,79,33923.8%A+
🥈 2Pooja Vaghela₹1,12,14,57716.6%A
🥉 3Sonal Rane₹87,40,55212.9%A
4Pathik Patel₹86,80,03212.8%B
5Nazin Khan₹76,78,18411.3%B
6Seema Nathwani₹59,79,3378.8%C
7Megha Nayak₹51,75,8837.6%C
8Akash Thakkar₹41,50,7266.1%D
🗺️ State-wise Sales Distribution
Sales by State (₹)
State-wise Revenue Share
📋 State Performance Table
StateTotal Sales (₹)Share %Relative Bar
Gujarat₹2,70,45,27639.9%
Delhi₹1,55,31,61422.9%
Haryana₹1,07,68,06615.9%
Punjab₹78,65,03311.6%
Maharashtra₹64,88,6419.6%
🚚 Delivery Status & Customer Class Analysis
Delivery Status Distribution
Customer Class Distribution
📋 Class & Delivery Summary Table
ClassNo. of OrdersDescriptionBadge
D192 ordersHighest order count – focus area for upgradeD
A+87 ordersPremium customers – top priorityA+
B76 ordersGood customers – growth potentialB
C73 ordersAverage segment – nurture requiredC
A72 ordersStrong customers – nearly premiumA
🏭 Sales Depot Performance
Depot-wise Revenue (₹)
Depot Revenue Tracker

🏭 Satelite₹2.86 Cr (42.2%)

🏭 Naranpura₹2.39 Cr (35.3%)

🏭 Katar Gam₹1.52 Cr (22.5%)


📋 Depot Comparison Table

DepotRevenueShare
Satelite₹2,85,81,55942.2%
Naranpura₹2,38,90,17535.3%
Katar Gam₹1,52,26,89622.5%
⭐ Top 10 Customers by Revenue
Top Customers Revenue (₹)
📋 Customer Rankings
RankCustomer NameRevenue (₹)
🥇 1Arvind Stores₹34,91,179
🥈 2Shreya Patan₹34,90,739
🥉 3Satname Agency₹32,77,866
4B.K.Agencies₹32,27,833
5Madhav Agency₹29,73,520
6Shree Agency₹27,28,398
7S.B.Trading₹25,59,342
8Kama Agency₹24,88,549
9Modi Agencies₹24,65,765
10Hinglaj Agency₹24,59,591
🗓️ Quarterly Sales Breakdown
Quarterly Revenue Comparison (₹)
📋 Quarterly Performance Table

QuarterPeriodRevenue (₹)Share %
Q1Apr–Jun 2021₹1,61,19,07423.8%
Q2Jul–Sep 2021₹1,63,80,31624.2%
Q3Oct–Dec 2021₹1,66,93,12724.7%
Q4Jan–Mar 2022₹1,85,06,11327.3%

Q123.8%

Q224.2%

Q324.7%

Q4 ⭐ Best27.3%
🔀 Sales Order Process Flowchart
📋 CUSTOMER ENQUIRY Customer places inquiry 📝 ORDER CREATION Order No · Date · Product · Qty 🔍 CREDIT CHECK? Customer Verification YES ✅ APPROVED Proceed to Sales NO ❌ REJECTED Notify Customer 💼 SALES PROCESSING Salesman · Rate · Commission 🏭 ASSIGN DEPOT Satelite / Naranpura / Katar Gam 🚚 PRODUCT DISPATCH Pick · Pack · Ship 📦 DELIVERED? Status Check YES ✅ RECEIPT GENERATED Record Receipt Date NO ⏳ PENDING STATUS Follow-up Required 🎯 ORDER CLOSED
🧠 Sales Order Mind Map
SALES ORDER DATA 📦 PRODUCTS 7 Categories Power Bank ₹2.4Cr BT Speaker ₹1.16Cr Touch Pad · Cover 👤 SALESMAN 8 Members Rajesh Chauhan #1 Pooja Vaghela #2 Sonal · Pathik · others 🗺️ STATES 5 States Gujarat 39.9% Delhi 22.9% Haryana · Punjab 🚚 DELIVERY Status Tracking Pending: 269 Delivered: 231 🏭 DEPOTS 3 Locations Satelite 42.2% Naranpura 35.3% Katar Gam 22.5% 🗓️ QUARTERS Q1 to Q4 Q4 Best: ₹1.85Cr Consistent Growth Q1–Q3: ~24% each
🛣️ Sales Growth Roadmap – FY 2021–22 to FY 2024–25
PHASE 1 PHASE 2 PHASE 3 PHASE 4 M1 📊 FY 2021–22 Revenue: ₹6.77 Cr 500 Orders · 8 Salesmen 3 Depots · 5 States M2 🚀 FY 2022–23 TARGET Target: ₹8.5 Cr (+25%) Expand to 7 States Reduce Pending Orders Grow Salesforce M3 🎯 FY 2023–24 TARGET Target: ₹11 Cr (+29%) New Product Lines Digital Orders · CRM M4 🏆 FY 2024–25 VISION Target: ₹15 Cr (+36%) Pan-India Coverage AI-driven Analytics Export Readiness START GOAL 💡 KEY: Gujarat leads (39.9%) · Q4 peak (₹1.85Cr) · Power Bank top product (35.5%) · Satelite depot #1 (42.2%) · Rajesh Chauhan best salesman
⚠️ This resource is for educational purposes only and does not constitute legal or financial advice. All data is based on the uploaded sales dataset for FY 2021–22.
© Digital E-Filing Coach · Amanuddin Education · All Rights Reserved
Scroll to Top