June Luxury Resale – Financial & Operational Summary

Overview

• Dataset: Detailed monthly transaction log for June (17 pages) covering sales of luxury goods (handbags, jewelry, watches, accessories).
• Stake-holders & roles
  • “Mitch” (primary reseller/liver), support livers “EJ”, “Tyra”, “Madonna”, “April”, “GK”, “Bro”, “BB”, “Sigma”, “Eight”, etc.
  • Item sourcing channels (Live@): Eight, 1.0 OKA, Global Trade, Brand Bay, Grancha Kauzo, Royal Diamond, Ribero, Vithal, Tacoal, Sigma, Website postings, Inquiries, etc.
• Core numerical columns per line
  • After-PayPal Fee (net sales proceeds)
  • Cost of Item (purchase price)
  • DHL (shipping/handling cost)
  • Profit (reported net ⟶ already computed by seller)
• Each page concludes with subtotals for $\text{After PayPal}$, $\text{Cost}$, $\text{DHL}$, $\text{Profit}$
• Grand profit for the entire file ≈ $\mathbf{¥6{,}220{,}972}$

Column / Formula Reference

• Profit is implicitly:
  $\text{Profit}=\text{After PayPal Fee}-\text{Cost of Item}-\text{DHL}$
  (PayPal fee is already netted out in “After PayPal Fee”)
• Example (Page 2, line 1):
  $273{,}135-275{,}000-2{,}958 = -4{,}823$ (negative margin)

Page-by-Page Financial Snapshot

• Page 1 (Jun 1 batch)
  • 33 items, heavy mix of Prada/LV/Hermès bags & assorted K18 jewelry.
  • Sub-total profit: $¥838{,}985$ (largest single profit: LV ALM Mono Totem PM, $¥46{,}309$).
• Page 2 (Jun 2 batch)
  • 3 Chanel/LV bags.
  • Profit: $¥57{,}818$; one loss (Chanel lambskin shoulder, $-¥4{,}823$).
• Page 3 (Jun 4 batch)
  • 4 Gucci/Balenciaga/LV items.
  • Profit: $¥59{,}378$.
• Page 4 (Jun 5 batch)
  • 23 items (bags + extensive fine-gold jewelry).
  • Profit: $¥308{,}985$; standout: Κ18 Akoya Pearl 2.9 g (¥27,634 profit).
• Page 5 (Jun 9 batch)
  • 62 high-value jewelry & Chanel/LV/Cartier goods.
  • Biggest page this month: profit $¥1{,}034{,}745$.
  • Top earner: Cartier “Love” Earrings (¥91,525).
• Page 6 (Jun 11 batch)
  • 27 items; balanced between bags & diamond jewelry.
  • Profit: $¥530{,}272$.
• Page 7
  • 9 diamond ring/necklace lines.
  • Profit: $¥163{,}638$.
• Page 8
  • 24 items—Ribero, Tacoal, Eight sources; includes Hermès Evelyn 1 PM pouch.
  • Profit: $¥445{,}818$.
• Page 9
  • 8 gold cross/pendant pieces + Gucci posting.
  • Profit: $¥149{,}539$.
• Page 10
  • Single NBJ heart necklace.
  • Profit: $¥12{,}627$.
• Page 11
  • 33 diverse wallet/bag/jewelry items across many live sales (Mitchang Office).
  • Profit: $¥477{,}802$.
• Page 12
  • 69-line mega-lot (watches, bags, bracelets).
  • Profit: $¥885{,}120$.
  • Watch section: 20+ quartz pieces yielding small but steady margins (¥5-17 k each).
• Page 13
  • 10 high-value pieces (Heartbiz bracelets, LV doc case).
  • Profit: $¥205{,}735$.
• Page 14
  • 37 Tacoal bracelet/pendant SKUs + assorted gemstones.
  • Profit: $¥597{,}934$.
  • One negative margin (12.54 g kihei chain, ¥–580) shows thin pricing.
• Page 15
  • 10 items, profit $¥158{,}773$; note back-to-back Heartbiz resale cycles.
• Page 16
  • Single 18KYG heart bracelet → ¥7,527 profit.
• Page 17 (Jun 30 close-out)
  • 17 lines of end-month clearance; mix of LV, Givenchy, diamonds.
  • Profit: $¥286{,}276$.

Category Insights

• Handbags/SLGs (Louis Vuitton, Gucci, Chanel, Hermès, Goyard, Dior):
  • Contribute ~40 % of lines but ~50 % of gross profit; luxury bags carry larger ticket sizes (¥100–330 k cost) yet fees are flat → higher absolute profit.
• Fine Jewelry (18K/24K, PT900 diam):
  • High turnover quantity; margins averaged 20-30 %.
  • Repetitive “K Triple 12 Cuts” bracelets show volume strategy; many brought in via Tacoal then flipped with ¥12–20 k net each.
• Watches: 40+ low-mid-tier Swiss quartz pieces; profit modest (¥7–17 k) but inventory clears quickly.

Highest & Lowest Profit Examples

• Highest single-item gain: Heartbiz 18KYG 14.41 g bracelet (Page 8) → $¥73{,}585$ profit.
• Runner-up: Cartier Love Earrings 750 WG 13 g → $¥91{,}525$ (Page 5).
• Steepest loss: Chanel Lambskin Shoulder Bag (Page 2) $-¥4{,}823$.
• Close to breakeven / negative: K18WG DO.60 heart NC (Page 15) ¥–842 & Kihei 12.54 g chain (Page 14) ¥–580 → illustrate fee or price-cut pressures.

Cash-Flow / Operational Takeaways

• Daily batching: Sales are grouped by the day of accounting (Jun 1 – 30) rather than individual transaction dates.
• DHL/Shipping impact: Typical range ¥1,300 – ¥9,200; heavy bags incur ¥8–9 k; light jewelry often ¥1.3–4 k.
• PayPal effect: After-PayPal numbers already net fees, so gross price received is higher than listed; consistent feed for spreadsheet import.
• Stock rotation: Repeat SKUs (Heartbiz bracelets, Kihei chains) highlighted—implies popular evergreen inventory.

Practical / Managerial Implications

• Tight monitoring of negative or sub-1 % margin deals is critical; even one –¥5 k cut wipes several small jewelry profits.
• Flat shipping fee strategy can distort true margin on high-value light items; consider tiered DHL pass-through.
• Leveraging multiple live platforms (“Eight”, “1.0 OKA”, etc.) diversifies sourcing and buyer pools; cross-listing risks duplicate sales—maintain synchronized inventory system.
• Ethical transparency: Full disclosure of PayPal & shipping deductions ensures accurate partner settlements.

Real-World Connections & Precedents

• The gold bracelet flip model echoes pawn-brokerage arbitrage: buy weight-based, sell style-based.
• Luxury bag margin compression mirrors seasonal fashion cycles—post-launch hype vs mid-season clearance.
• Using “Website / Inquiries” channels reflects DTC e-comm trends where shipping cost share shifts from buyer to seller.

Key Equations & Numerical Highlights

• Mean per-item profit (overall):
  $\text{Mean}=\dfrac{6{,}220{,}972}{\approx!650\text{ items}}\approx¥9{,}571$
• Profit contribution by top 10 items ≈ >¥500{,}000 (≈8 % of grand profit) → classic Pareto.
• Profit variance (illustrative):
  $\sigma_{\text{profit}}\approx¥18{,}000$ (large spread; jewelry small, luxury bag large).

Example Walk-Through (Understanding a Line)

• “K18WG MULTISTONE DIA NC 1.68 g” (Page 1, line 7)
  • After-PayPal: ¥42,648
  • Cost: ¥31,176
  • DHL: ¥4,150
  • $42{,}648-31{,}176-4{,}150 = 7{,}322$ profit (≈23 % margin).

Study Checklist

• Be able to compute profit rapidly using the given formula.
• Recognize high-risk categories (Chanel seasonal bags, heavy kihei chains) vs steady coupon-size gains (tiny diamond pendants).
• Understand the impact of shipping and flat fees on different weight/value classes.
• Interpret page subtotals to track daily cash flow and forecast liquidity.
• Identify patterns of repeated SKUs to anticipate reorder opportunities.