Item History Price & Cost
The Item History Price & Cost dashboard provides visibility into inventory pricing trends, cost variation, and extended price and cost over time. It helps teams track historical changes, compare standard and actual values, and support pricing and inventory valuation decisions.
Benefits of this dashboard
- Analyze cost and price trends: Tracks historical fluctuations in inventory pricing and costs.
- Gain profitability insights: Helps compare standard pricing against actual performance.
- Optimize inventory valuation: Ensures pricing strategies align with costs to maintain profit margins.
- Enable data‑driven decisions: Supports better procurement and pricing strategies based on historical data.
- Monitor standard vs. actual costs: Identifies discrepancies between expected and actual inventory costs.
Visual components
| Title | View type | Description |
|---|---|---|
| Top 10 Extend Cost By Item | Radar | Shows the 10 items with the highest extended cost. |
| Price and Cost By Year | Stacked Bar | Compares extended price and extended cost by year. |
| Top 10 Std Costs By Item | Radar | Compares unit cost, standard unit cost, standard unit price, and actual unit price for the top 10 items. |
| Ext & Std By Year | Stacked Spline | Compares extended price, extended cost, standard unit cost, and standard unit price by year. |
| Item Costs By Year | Worksheet | Lists item costs and prices by year and item group, including unit cost, unit price, extended cost, extended price, standard unit cost, and standard unit price. |
Ext & Std By Year: key metrics
- Extended Price: Total revenue for items, calculated from unit price and quantity sold.
- Extended Cost: Total cost for items, calculated from unit cost and quantity sold.
- Standard Unit Cost: Standard cost per unit for an item.
- Standard Unit Price: Standard selling price per unit for an item.
Filters
You can filter the dashboard with these panels:
- Inventory Item