Q: What client type is this cost method best suited for?
A: The Historical Weighted Average Cost method is best suited for Retail clients. Particularly those that do not see high cost fluctuations.
Q: How is the calculated cost determined for this method?
A: The system calculates the cost as the average price paid over the item's purchase history. While this definition is similar to the Weighted Average Cost Calculation, the key difference is that the calculated cost does NOT reset when an inventory item reach zero on hand.
- Cost is recalculated every time new inventory is received.
- Sales or deductions do not influence this cost.
- Calculated Cost does not reset when inventory reaches zero.
- This method can be applied:
- Per store: Cost is calculated independently per store.
- All stores: Cost is calculated using purchase data across all stores.
Q: What are the strengths of this method?
A: Key strengths of the Historical Weighted Average Cost method include:
- Smooths out price fluctuations over time.
- Easy to explain and predict.
- Provides consistent cost data over time by averaging all purchases since inception.
Q: What are things to keep in mind if selecting this method?
A: When using Historical Weighted Average Cost it is important to keep in mind:
- While this is important for any calculated cost method, purchasing must be enter in a consistent and timely manner to ensure accurate costing.
- For the all stores option, averaging across stores may distort true store-level profitability.
- Since this method averages all purchases since inception, the value of inventory can become understated over time.
Q: Can you provide an example of how calculated cost is determined using Historical Weighted Average Cost?
A: The table below demonstrates an example of how the calculated cost is determined using Historical Weighted Average Cost.
Key takeaway: Historical Weighted Average Cost functions similarly to Weighted Average Cost, the only different is the calculated cost does NOT reset when inventory reaches zero on hand.
Related Article:
Feature Overview: Calculated Cost