Scheduled Delivery Analysis

Overview

The Scheduled Delivery Analysis app is used to track when the Initial Scheduled Delivery date set by the carrier changes while the product is in transit. It is important to note that this feature is different than what UPS on-time performance tracks. 

Solution

When UPS receives package information from a customer, they calculate the planned scheduled delivery date based on their internal metrics. However, sometimes the date changes while a package is in transit. The scheduled delivery performance application tracks both the initial scheduled delivery date, as well as the new scheduled delivery date created. If there has not been a change then the two dates will match up.

Sorting 'tracking units by delivery schedule' (in thousands) by 'delayed' will give you all of the tracking units that have a scheduled delivery date that is later than the initial scheduled delivery date. 

 

 

Keeping the 'delayed' filter active and then sorting 'tracking units by transit status' by 'in-transit' will show you what could be considered 'at risk' packages - those that are still moving and being delivered later than anticipated. This information is meant to show when the carrier thought the package would be delivered, compared to when it will actually be delivered. This can be useful to give you the ability to communicate to customers that a package will arrive later than anticipated or to know that an inbound shipment will not arrive on the initial scheduled date.

 

Once a package is delivered, the delayed designation is no longer determined by the 'scheduled delivery date' being later than the 'initial scheduled date' but instead whether the date the package was actually delivered is later than the initial scheduled date. You can find these packages by keeping the 'delayed' filter but now filtering by 'delivered' rather than 'in-transit.' Doing this will provide you with all the tracking units that were delivered at a later date than what was initially scheduled by the carrier. 

Chart View

The Scheduled Delivery Analysis also provides the option to view reporting data in the form of a visual chart. The data displayed within the chart corresponds to the filters designated at the top of the application screen, and there are multiple ways a user can choose to view the information. 

The standard (or default) chart is shown in the image below, and clicking the full screen button will open the chart in a larger window. 

 

Chart Settings

Clicking on the chart settings button will display a popup allowing the user to adjust the output parameters of the chart itself. 

Chart Dimensions: Selecting "Category" from the drop-down will control the data displayed along the X-axis of the chart. Selecting "Series" will define the criteria the data is being measured against within the visual chart. 

Chart Measures: These settings control the data displayed along the Y-axis of the chart. 

Aggregate View

The user can elect to view chart data in an aggregate view, which collapses the data into nested rows. Multiple levels of data can be added by clicking on Chart Settings and adding additional Dimensions (X-axis) and Measures (Y-axis). Data can be exported by clicking on the Spreadsheet button next to "Full Screen." 

 

 

Flattened View

The user can elect to view chart data in a flattened view, which displays the data in a form that's similar to a spreadsheet. The data displayed can be changed by clicking on Chart Settings and adjusting the Dimensions (X-axis) and Measures (Y-axis).

Two Dimensions are required to view the data in this manner. Data can be exported by clicking on the Spreadsheet button next to "Full Screen." 

Heat Map

Use the Heat Map to view line item data based on where packages are being shipped to/from. Adjust parameters using the drop-downs highlighted at the top of the image below. The Legend on the right will highlight regions where the greatest volume is located. Click on a location to view granular data for that location within the table below the chart.