Pareto Chart for Visualize On-time Shipping Rate

Use Pareto Chart to visualize the common reasons for late shipments.

This example applies to the Supply Chain Module. For more information, go to www.minitab.com/supply-chain-module.

Example

On-time shipping rate is the proportion of orders that are received within the promised shipping window. To calculate on-time shipping rate, divide the total number of on-time shipments by the total number of shipments.

In this worksheet, Problem contains the reasons for a late shipment. Type is the optional grouping variable. You can also use a frequency column.

C1-T	C2-T
`Problem`	`Type`
Inadequate Truck Space	Cordless
Late Pickup	Cable
Rework	Cable
Damage	Cordless

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Delivery, select On-time shipping rate.
Select Visualize on-time shipping rate, then click OK.
Select Pareto Chart, then click OK.
In Defects or attribute data in, enter the column that contains the reasons for the late shipment.
(Optional) In Frequencies in, enter the column that contains the counts of the summary data.
(Optional) In BY variable in, enter the column that contains the group identifiers.
Click OK.

Tip

For more information about this analysis, click Help in the main dialog box.