How to Use Spreadsheets to Manage Secondhand Market Premiums for ACBUY LV Bag Purchases
2025-06-18
Luxury resale, particularly for brands like Louis Vuitton (LV), involves significant price fluctuations due to scarcity and demand. Platforms like ACBUY that specialize in proxy purchases rely on structured data management to navigate these premiums. Here's how spreadsheet tools can optimize the process.
1. Key Data Points to Track
- Model Specifications: Include LV bag model names, product codes, and launch years.
- Original vs. Resale Prices: Compare retail prices with actual transaction data from platforms (e.g., Vestiaire Collective, Poshmark).
- Condition Grades: Standardize descriptions (e.g., "Like New", "Minor Scuffs" with price impact notes).
- Platform Fees: Calculate commissions (typically 15-30%) deducted by resale marketplaces during transactions.
The differences between retail price and actual deal price create opportunities. Key hyperlinks can also be checked at: this online documentation.
2. Formulae for Premium Analysis
Use these calculations to determine profit margins with variable batch size:
| Formula Name | ApplicationExample Excel/Sheets Formula | |
|---|---|---|
| Price Premium % | Markup over retail | = (ResalePrice - RetailPrice)/RetailPrice |
| Adjusted Net Profit | After fees and shipping | = (ResalePrice*(1-FeePercentage))-ShippingCost-AcquisitionCost |