cost-allocation-analysis

Allocate COGS, fulfillment, marketing, and overhead costs to compute per-order profitability.

3|1|Updated Mar 21, 2026
One-click install
npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill cost-allocation-analysis-tomtoto757
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cost-allocation-analysis
Source: https://github.com/tomtoto757/ecomm-ai-team/tree/main/skills/analytics-reporting/finsilabs/data-analytics/cost-allocation-analysis
Command: npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill cost-allocation-analysis-tomtoto757

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? High-revenue products and channels often appear profitable on gross margin while actually losing money once fulfillment, marketing, and overhead costs are factored in. This Skill builds a fully-loaded cost waterfall so you can see true per-unit and per-order profitability across products, channels, and orders. ## Core Features & Use Cases - Four-Bucket Cost Allocation: Allocates COGS, variable fulfillment costs, direct marketing spend, and shared overhead down to the product and order level. - Platform-Specific Setup Guides: Step-by-step cost data entry and profit app configuration for Shopify (BeProfit, Lifetimely, TrueProfit), WooCommerce (Metorik), and BigCommerce (Brightpearl). - Cost Waterfall Framework: A structured P&L cascade from gross revenue through contribution margin to net operating profit per order, including marketplace fees as a cost layer. - Use Case: A DTC brand selling on Shopify and Amazon suspects FBA orders are unprofitable. Use this Skill to allocate FBA fulfillment fees, referral fees, and ad spend per order, then compare Amazon contribution margin against website margin for the same SKU. ## Quick Start Use the cost-allocation-analysis skill to build a per-order profitability waterfall for my Shopify and Amazon channels including COGS, shipping, ad spend, and overhead.

Frequently Asked Questions about cost-allocation-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate true profitability per product in Shopify?▼

Enter landed cost in the Cost per item field for each variant, then view Analytics → Reports → Profit by product for gross margin. For fully-loaded margins including shipping and ad spend, install a profit app like BeProfit, Lifetimely, or TrueProfit.

How to allocate overhead costs to individual ecommerce orders?▼

Calculate a monthly overhead rate by dividing total overhead by total net revenue, then apply that percentage to each order's net revenue. Use a rolling 3-month average revenue to avoid wild rate fluctuations in low-volume months.

What is the difference between gross margin and contribution margin?▼

Gross margin subtracts only COGS from net revenue, while contribution margin also deducts fulfillment costs, payment processing, marketplace fees, and direct marketing spend. Contribution margin reveals whether an order is profitable before fixed overhead.

Does WooCommerce support product cost tracking natively?▼

WooCommerce does not include a cost field by default. Use the Cost of Goods extension or the free ATUM Inventory Management plugin to add COGS tracking, then connect Metorik for per-product and per-order profitability reports.

Why do Amazon FBA orders look profitable but lose money?▼

Amazon orders often show positive gross margin but turn negative once FBA fulfillment fees ($3–$8 per unit), referral fees (8–15%), and advertising spend are allocated. Model marketplace fees as a cost layer in the waterfall, not a revenue reduction.

Why does historical margin change when I update product costs?▼

Updating a single cost field retroactively changes margins on past orders. Use time-effective cost records that store the cost as of the order date; most profit analytics apps like BeProfit track historical cost changes automatically.