Kakobuy Spreadsheet Mastery: Calculate Streetwear Costs for Supreme, Off-White, BAPE
2025.12.240 views2 min read
Why Calculate Costs Upfront?
Streetwear from Supreme, Off-White, BAPE on Kakobuy looks fire but hides fees. Use a spreadsheet to avoid surprises. Focus: item price, agent fees, shipping, customs. Target batches for savings.
Key Cost Breakdown
- Item Price: Taobao or 1688 base (RMB). Example: Supreme Bogo hoodie ~350 RMB.
- Kakobuy Service Fee: 9 RMB/kg (rounded up).
- QC Fee: 8 RMB per item. Skip for bulk if trusted seller.
- Domestic Shipping (China): ~10-20 RMB/item.
- International Shipping: EMS: 25 RMB first kg +14/kg after; DHL/UPS: flat tiers (check Kakobuy sheet).
- Customs Duties/VAT: Item value x duty rate (streetwear ~12%) + 20-27% VAT/handling. Estimate landed value / total items.
- Other: Storage (0.2 RMB/kg/day over 40 days), virtual/non-injected items +15 RMB.
- Supreme/Off-White Tee: 0.25-0.35 kg
- BAPE Hoodie/Jacket: 1.0-1.8 kg
- Supreme Box Logo Hoodie: 1.4 kg avg
- Off-White Track Pants: 0.8 kg
- Pants/Add-ons: 0.5-0.7 kg
- Batch Tip: Group similar weights for optimized KG pricing.
- Input Items: List e.g., 2x Supreme hoodie (1.4kg ea), 3x Off-White tee (0.3kg ea), 1x BAPE shark jacket (1.6kg).
- Calculate Total Weight: =SUM(Qty Weight). Example: (21.4) + (30.3) + (11.6) = 6.7 kg.
- Subtotals: =Qty Unit Price + QC. Hoodies: 2350 +16=716 RMB.
- Agent Fee: =CEILING(Total Weight,1)9. 79=63 RMB.
- Shipping: EMS formula: IF(Total Weight<=1,25,(25+(Total Weight-1)14)). For 6.7kg: 25 + 5.714 ~105 RMB.
- Domestic: ~15 RMB/item total.
- Total to Ship: Subtotals + Agent + QC + Domestic + Shipping.
- Customs Estimate: (Total RMB / 6.8 exchange to USD ~1000) 12% duty +25% VAT + broker. US: ~$200-400 on $1000 haul.
- Total Weight: 1.4 + 0.6 + 1.6 = 3.6kg
- Subtotal Items: 350+480+420=1250 RMB
- QC: 48=32 RMB
- Domestic: 40 RMB
- Agent: CEILING(3.6)9=36 RMB
- EMS Ship: 25 + 2.614=61 RMB
- Kakobuy Total: 1250+32+40+36+61=1419 RMB (~$208 USD)
- Customs (est US): Value $208 *12% duty=$25 +25% VAT=$52. Landed: ~$285 USD ($71/item).
- Batch by Seller: Free domestic shipping combos.
- Weight Optimization: Fill to 2kg tiers for EMS savings.
- Current Rates: Check Kakobuy QC/shipping page—updates monthly.
- Customs Dodge: Declare low, split shipments (risky).
- Tools: Kakobuy haul sheet template + Google converter RMB-USD.
- Brands Alert: Supreme repros heavier (boxes); BAPE fluffier fills.
- Forget rounding KG up.
- Undervalue weights—measure post-QC pics.
- Ignore VAT surges in EU/UK (30%+).
- No buffer: Add 20% for fluctuations.
Spreadsheet Setup
Create in Google Sheets or Excel. Columns: Item Name, Brand, Qty, Weight (kg/item), Unit Price (RMB), QC Fee, Total Weight (kg), Subtotal.
Streetwear Weight Estimates
Step-by-Step Calculation
Example Haul: Supreme-Off-White-BAPE Mix
Items: 1 Supreme hoodie (350 RMB, 1.4kg), 2 Off-White tees (240 ea, 0.3kg ea), 1 BAPE jacket (420 RMB, 1.6kg).
Pro Tips for Streetwear Hauls
Common Pitfalls
Copy this setup, plug in your Supreme drops or Off-White restocks. Total time: 10 mins per haul. Land streetwear under retail.