Simplified calculations often stop after Revenue − Item Cost − Referral Fee, which produces a contribution figure rather than true net profit. WFS sellers may still need to account for storage and return-related charges, while self-fulfilled sellers have carrier costs, packaging, warehouse labor, and handling that do not disappear simply because Walmart is not charging the fulfillment fee. Advertising should also be allocated at SKU level where practical instead of being treated as an unrelated company expense. The more complete model is especially important for low-margin products, because several individually small costs can eliminate the apparent profit.
Consider a compact consumer-electronics product selling for $120 on Walmart Marketplace. Assume the SKU is classified under Consumer Electronics, where the referral fee in this example is 8%, and is fulfilled through Walmart Fulfillment Services. Its inventory cost is $62 per unit, while the packed dimensions and shipping weight result in an illustrative WFS fulfillment fee of $8.15. Using a higher-value electronics product makes it easier to see how fulfillment, advertising, inventory accounting, and storage combine to affect final margin.
Step 1: Start with revenue and COGS. The selling price contributes $120 in revenue, while the inventory system assigns $62 in Cost of Goods Sold to the unit. That $62 should come from the costing method used consistently by the business rather than from a rough estimate based on the latest supplier invoice. If freight, import duties, preparation, or other acquisition expenses form part of inventory cost under the seller's accounting policy, they should be reflected consistently in the profitability model as well. A reliable COGS figure matters because every later margin calculation depends on this starting cost basis.
Step 2: Subtract the Walmart referral fee. At an 8% Consumer Electronics rate, a $120 sale generates a $9.60 referral fee. This is one reason category mapping matters: applying a generic 15% marketplace rate would overstate the cost of this example by $8.40. The reverse problem can occur in categories with higher or tiered rates, where using a lower fixed percentage understates the actual marketplace fee. The applicable category and price tier should therefore be verified before the referral fee is entered into the P&L.
Step 3: Add fulfillment and storage. Suppose the packaged unit measures roughly 18 × 12 × 6 inches, or 0.75 cubic feet, and its dimensional shipping weight results in an illustrative $8.15 WFS fulfillment fee. At a regular storage rate of $0.75 per cubic foot per month, one month of storage adds approximately $0.56 per unit. During the October–December peak period, inventory stored long enough to attract the seasonal surcharge can carry a higher storage cost, which would reduce the unit's final margin even though its selling price has not changed. Storage should therefore be modeled as a variable cost rather than copied into the spreadsheet as one permanent annual figure.
Step 4: Estimate returns, advertising, and overhead. Assume historical return data produces an expected return-related cost of $2.20 per sale, including handling and an allowance for returned products that cannot be resold. Advertising contributes another $7.50 in Cost Per Sale, calculated over the same reporting period as the associated sales, while software, labor, and other allocated overhead add $3.00 per unit. These figures are business-specific assumptions rather than universal Walmart charges, and another seller may have substantially different costs. The important point is that all three reach the SKU-level P&L instead of remaining hidden inside company-wide expense totals.