Solutions
Integration of Technology: Utilized a combination of Google Sheets, Zapier, Finale Inventory, and QuickBooks to automate the entire process from quotation approval to commission calculation.
- SKU-Level Margin & Turnover Analysis: Conducted a full contribution margin and velocity review across the entire catalogue.
- Zombie SKU Identification: Flagged unprofitable, low-turnover SKUs that offered minimal contribution to margin.
- SKU Bundling Strategy: Recommended pairing slow-moving items with bestsellers to move stagnant inventory and recover space.
- Ad Spend Reallocation:Focused performance marketing budget exclusively on the top 20% most profitable SKUs by volume and margin.
- Commission Payment Automation: Calculated commissions were automatically posted as bills in QuickBooks, with detailed calculation sheets attached. These bills were then synced to Bill.com for controller approval.





















