Analyzing Transportation Costs

The Transportation analysis sheet shows the details on the computations for finished goods transportation costs. The default view shows the following measures:

Figure 7. Default View of the Data in the Transportation Analysis Sheet

Transporatation analysis sheet with predefined data

Note:

See Transportation Cube for detailed information about the predefined content in the Transportation analysis sheet.

Right-click an item to change the data display. Table 3 describes the display options available for the items in the Transportation analysis sheet.

Table 3. Transportation Items and Their Display Options

Item in ExcelDisplay Options
ProductZoom In

Zoom Out

Include Parent

Show Summary

Show Product Family

Show Product Line

Show Product Model

Show Description

Distribution CentersZoom In

Zoom Out

Include Parent

Show Summary

Show Distribution Center

Show Description

PlantsZoom In

Zoom Out

Include Parent

Show Summary

Show Plant

Show Description

Transport ModesZoom In

Zoom Out

Include Parent

Show Summary

Show Transport Mode

Show Description

Transportation Select Measures

Show Summary

Show Details

Show Debug Measures

Show Description

Show Formula

Time PeriodInsert/Edit Comment

Add to Key Metrics

DC Inventory Details

DC Sourcing Details

Plant Sourcing Details

Transport Cost Details

Clear Report