When sourcing products from EastMallBuy, finding reliable sellers is the key to a smooth supply chain. This guide explains a simple, data-driven method to rank sellers based on Quality Control (QC) success and shipping punctuality using a spreadsheet.
The Reliability Score System
We propose a scoring system from 0 to 100, combining two critical metrics:
- QC Success Rate (Weight: 60%):
- Shipping Punctuality (Weight: 40%):
This weighted approach prioritizes quality but fairly accounts for logistical reliability.
Setting Up Your EastMallBuy Spreadsheet
Create a spreadsheet with the following columns for each order:
| Seller Name | Order ID | QC Passed? (Y/N) | Shipped On Time? (Y/N) |
|---|---|---|---|
| TechGadgetPro | EMP00123 | Y | Y |
| TechGadgetPro | EMP00124 | Y | N |
| StyleHouse | EMP00125 | N | Y |
Compile data from at least 5-10 orders per seller for a meaningful score.
Calculating the Reliability Score
Use these steps (or spreadsheet formulas) to calculate the score for each seller:
- Calculate QC Success Rate:
- Calculate Punctuality Rate:
- Calculate Weighted Score:
- Calculate Punctuality Rate:
Example for 'TechGadgetPro' (2 orders above):
QC Rate = (2/2)*100 = 100%
Punctuality Rate = (1/2)*100 = 50%
Reliability Score80/100.
Creating Your Ranked Seller List
Create a separate summary sheet that lists all sellers sorted by their Reliability Score (highest to lowest). Include their calculated rates for quick reference.
| Rank | Seller Name | QC Rate | Punctuality Rate | Reliability Score |
|---|---|---|---|---|
| 1 | PremiumSource | 98% | 95% | 97 |
| 2 | TechGadgetPro | 100% | 50% | 80 |
| 3 | StyleHouse | 60% | 90% | 72 |
Benefits and Future Reference
This ranked list allows you to:
- Make Informed Decisions:
- Identify Trends:
- Save Time & Reduce Risk:
- Identify Trends:
Pro Tip: