We need a highly analytical ecommerce profitability expert to work hourly and build an exact profitability model for our business, starting with Amazon, which currently represents about 95% of our revenue. We sell multiple SKUs and sizes and need someone to go deep into the real numbers, not rough percentages, so we can understand total cost per SKU, true net profitability, and the best pricing to charge.
The work includes identifying exact cost of goods by SKU, packaging components, labor and assembly where relevant, inbound shipping and freight allocation, pallet and prep costs, Amazon referral fees, FBA fees, storage fees, returns where relevant, ad spend by SKU/ASIN, and true net profit before and after ads. We need true landed cost per unit, including inbound shipment cost allocation down to the SKU and per-unit level. We also want pricing analysis so we can understand current margin, break-even points, and recommended pricing ranges by SKU. Goal is to identify current profitable pricing, break-even pricing, and recommended target pricing by SKU.
This person does not need to manage our PPC, but they do need to understand Amazon advertising data well enough to pull or analyze spend by SKU/ASIN and incorporate that into profitability. Helium 10 knowledge is helpful, but not required. Stronger priority is someone who can work from Seller Central, business reports, fee reports, shipment data, accounting/cost data, and build a clean profitability and pricing model in Excel or Google Sheets.
What we need:
-Build exact SKU-level cost and margin model
-Include product cost, bottle, cap, label, box, insert, corrugate, labor/assembly
-Allocate inbound freight, pallet, prep, and shipping costs down to SKU and per-unit level
-Include Amazon referral fees, FBA fees, storage fees, returns, and ad spend
-Calculate landed cost per unit
-Calculate net profit before ads and after ads
-Calculate break-even ACOS and target ACOS by SKU
-Recommend pricing ranges / target sell prices by SKU
-Organize messy data into a clean decision-making spreadsheet
-If Phase 1 goes well, expand into broader full-business profitability across other channels and operating costs
Required experience:
-Strong Excel or Google Sheets
-Amazon Seller Central economics
-Ecommerce profitability modeling
-SKU-level margin analysis
-Freight and landed cost allocation
-Ability to work independently and organize messy real-world data cleanly
To apply, please answer:
-Have you built SKU-level profitability and pricing models for Amazon brands before?
-Have you calculated break-even ACOS by SKU?
-How would you determine recommended pricing by SKU?
-What exact inputs would you need from us?
-Please share a relevant example of a similar project.