The Transportation cube captures the transportation and logistics of finished goods from the source (manufacturing facility) to the destination (distribution centers) along with the associated direct costs.
Demand volumes from the Demand cube
Distribution center sourcing percentage that associates sales geography in the Demand cube to the supplying distribution centers in the Transportation cubes
Percentages can be loaded from external systems or can be maintained in Integrated Margin Planning.
Plant sourcing percentage that associates the distribution center demand with the manufacturing facility that produces the products
Inventory levels at the distribution centers (from the ERP system)
Transportation lead times
Transportation cost rates
Budget transportation cost
Simulate changes to potential drivers that impact transportation costs
For example, distribution center sourcing percentages, plant sourcing percentages, transportation lead times, and transportation costs per unit
Assess the impact on the total transportation costs and how they compare to budgeted transportation costs
Latest projection on transportation costs fed into the Financials cube
Plant demand volumes fed into the Production cube
Table 7. Predefined Information in the Transportation Cube
| Dimensions | Measures | Constraints | Allocation Maps | Related Objects |
|---|---|---|---|---|
| DistributionCenters Manufacturing Plants Product TransportModes | Beginning Inventory Budget Transportation Cost DC Demand Plan Quantity DC Inventory Ending Inventory Lead Time Value Netted DC Demand Quantity Projected Ship Quantity Proposed Receipts Proposed Receipts from Plant Scheduled Receipts Shortage Transportation Cost Transportation Cost – Local Currency | Excess_Transportation_Costs | None | Cubes
Dimensions
Row Sources
|