Invoice Elements
The data model includes measures such as Delivery Count indicating the number of deliveries, Net Weight representing the weight of goods delivered net of packaging, Total Quantity reflecting the total quantity of goods regardless of weight, Freight Invoice Amount showing the total invoiced freight cost, Freight Cost per Qty revealing the average freight cost per quantity, Freight Cost per Weight detailing the average freight cost per unit weight, and Freight Average Cost per Delivery denoting the average freight cost per delivery within the specified period. Additionally, the Freight Cost view offers insights into the freight cost breakdown for each invoice element.
Benefits of This Data Model
- Improved cost analysis: The data model allows for detailed analysis of freight costs per quantity, weight, and delivery, enabling better cost management decisions.
- Enhanced performance monitoring: By utilizing measures such as Delivery Count, Net Weight, and Total Quantity, businesses can effectively monitor and optimize their performance in terms of deliveries and goods quantities.
- In-depth freight cost understanding: The Freight Cost view offers insights into the breakdown of freight costs for each invoice element, providing a comprehensive understanding of cost components.
- Comprehensive reporting capabilities: With dimensions covering various aspects such as Company, Customer, and Date, users can create comprehensive reports for better business insights and decision-making.
Key Performance Indicators (KPIs)
- Delivery Count: The number of deliveries made for the specified time period.
- Net weight: The total weight of goods delivered after deducting packaging and other non-usable materials.
- Total Quantity: The overall quantity of goods delivered, irrespective of weight or volume.
- Freight Invoice Amount: The total amount invoiced for freight services during the specified period.
- Freight Cost per Qty: The average cost of freight per quantity of goods delivered.
- Freight Cost per Weight: The average cost of freight per unit weight of goods delivered.
- Freight Average Cost per Delivery: The average cost of freight per delivery made during the specified time frame.
Available Visualisations
| View Name | Description |
|---|---|
| Freight Cost | Provides insights on the cost of freight for each invoice element. |