Real-World Examples: Defining COGS with Multiple Elements and Date Ranges

This guide demonstrates how to model realistic product cost scenarios using multiple cost periods, suppliers, currencies, and date ranges.

Example 1: Basic Cost Periods

Prices change over time. A Bluetooth speaker costs $8.25 until June 30, 2024, then increases to $9.10 starting July 1st. SellerLegend applies the appropriate cost based on order dates.

Example 2: Multiple Suppliers with Currency Exchange

Yoga mats from two suppliers with different currencies require conversion:

• Supplier A costs $3.20 per unit (USD)
• Supplier B costs £2.25 per unit, converted to $2.93 USD using a 1.30 exchange rate

Use the Detailed View to track currency and exchange rate information per supplier.

Example 3: Handling Gaps

Cost periods must have complete date coverage with no gaps. A missing May definition causes $0 COGS calculation, artificially inflating profits. Always bridge gaps with intermediate periods.

Example 4: Future Planning

Pre-define upcoming price changes. Set current costs through July 31, then define new rates starting August 1st for seamless transitions.

Example 5: Weighted Average Costs

When old and new inventory batches overlap with different unit costs, calculate the weighted average:

(Total Cost) / (Total Units)

For example: 500 units at $4.00 plus 1,000 units at $4.80:

• Total cost: (500 x $4.00) + (1,000 x $4.80) = $2,000 + $4,800 = $6,800
• Total units: 1,500
• Weighted average: $6,800 / 1,500 = $4.53

Best Practices

• Eliminate gaps in date ranges
• Use Detailed View for international transactions
• Add explanatory notes for cost changes
• Pre-enter future-dated cost adjustments