With Walmart’s announcement of new changes to its On Time In Full program in 2020, the retailer also rolled out a new app in its Retail Link software for suppliers.
The Retail Link OTIF Scorecard contains many options for analyzing your score and downloading data. This latest version of Walmart’s OTIF Scorecard is a much more user-friendly version than the previous one.
Let’s walk through accessing the dashboard and the reports you can download.
In Retail Link, select Apps, then select On Time In Full (OTIF) Scorecard to access the application.
Retail Link – Apps
Once you log into the landing page, you’ll see the Summary page with the below options across the top and down the left side of the page. Let’s cover them briefly.
Retail Link – OTIF Summary
Left Side Menu
The process for downloading files applies equally throughout the OTIF Scorecard. If the download button below is visible in the top right corner of a page, then the contents of that page are available for download.
OTIF Dashboard – Download button
When you click the Download button from the Summary page, you’ll get the option to select CSV or PDF.
Download options – CSV or PDF
Downloading the Summary page as a PDF will return data as a chart.
Summary – Performance as a PDF report
Downloading as CSV will return the data as a file with tabs included for each data set, such as accountability information and distribution center performance.
Summary – Performance as a CSV report
Note – From the PO Details page, only the CSV download is available.
Let’s discuss filters and saving preferences. When you select the filter button, you’ll get the below filtering options:
Use the dropdowns to filter the data you want to view. You can have as many filters as you want, and in all dropdowns, you may select multiple options.
Click the Apply button to execute. The page will load to reflect your selections. You’ll note there is now a number beside the filter, which indicates the total of filters applied to the current view
OTIF Dashboard – Filter indicator
OTIF Dashboard – Filters applied view
To remove your selections, click the Reset button at the bottom.
You can Save any filter by clicking the Save As button and naming it. You can save up to 10 combinations.
To delete a saved filter:
Filters – Delete Filter button
Filters – Delete confirmation window
Let’s review the Summary page Performance section.
You can filter this page globally by using the Filter option in the top right corner, as described previously in the filtering section. Directly below the download button, you have a view of the current filters you have selected.
The download button works the same way as previously discussed in the Download section. You can choose to download to CSV or PDF. It’s important to note that filters applied will impact what data you can download. To pull all data for a page, ensure the Filters applied is “Total Company.”
Filters applied – Total Company
The OTIF dashboard globally defaults to the latest Walmart week of data. In the “Data displayed for” dropdown, you can select historical weeks.
OTIF Dashboard – “Data displayed for” dropdown
You can view the first two charts, On Time Accountability and In Full Accountability, historically by using the “Week” dropdown selection.
The third chart displays Accountability, On Time Variances, and Trend Analysis. Click each tab name to view these metrics.
OTIF Summary – Accountability View
OTIF Summary – On Time Variance
OTIF Summary – Trend Analysis
Additionally, there is a “Show Me” chart with two dropdown menus to view these three metrics in greater detail.
OTIF Summary – Show Me chart
You may filter this chart in many ways. You can change the views from Top 10 (showing your best-performing metrics) to Bottom 10 (showing your worst-performing metrics).
You may apply these business filters:
Lastly, the DC Performance is also filterable and provides a plethora of detail. You can filter by Location, Metric, and Network. You can also filter by OnTime, In Full, and Collect Ready.
You’ll see dots depicting DC locations, colored green or red, depending on performance status on the map. Click on the dot, and more details will populate to the right side of the map.
OTIF Summary – DC Performance map
While staying on the Summary page, let’s select the “Charges” button at the top of the page. As stated, Filters and Download functionality apply to this page as well.
Default is the latest week. The top chart provides a 13-month view of fines and additionally breaks it down by metric.
OTIF Dashboard – Charges view
The second-row chart provides a breakdown by Accountability and Merchandising Alignment. Additionally, the “Show Me” chart provides additional analysis detail.
Charges Breakdown by Accountability
The third row is your “Trend Analysis.” This option provides a view of “All Metrics.” You can also filter by three 13WK (weeks) ranges and compare those to the same period Last Year.
Charges Summary page – Trend Analysis
Now let’s move to the side menu, and look at the sheet icon.
Side menu – Sheet icon for PO Details
This takes us to the PO Details page, where we have many options and views of the raw purchase order data used throughout the charts we’ve previously discussed. This page defaults to the latest OTIF completed fine month.
OTIF App – PO Details page
This page is filterable at many levels to ensure you have full access to every level of your data. As with the dashboard, you can filter by date using the dropdown. You can also use the global Filter and Download at the top right corner.
On this page, you can view the PO Line Level details, displaying the individual purchase order information, or view the Receiver details, which show the case counts.
For the PO Line Level view, you have the following options for filtering:
For the Receiver view, you have the following options for filtering:
At the far right, you can select the three dots to open a dropdown, revealing more filter column options. These options are:
You can download all filtered data to a CSV file. You can also pin up to six filter views.
There are two additional pages in the OTIF App: FAQs and Announcements.
The Question Mark (?) icon on the side menu links the Supplier Academy article on what OTIF is and how Walmart calculates it.
Side Menu – Question mark icon for FAQs
The megaphone icon provides the latest announcements on what may influence OTIF data (e.g., hurricane activity causing store or DC closures) and what actions Walmart may be taking.
Side Menu – Announcements icon
While the new OTIF Scorecard has a lot of functionality, it still lacks drill-down analyses into how third parties affect OTIF performance. With SupplyPike’s OTIF Radar, you can get in-depth, actionable insights into your data.
OTIF Radar – Drill-down analysis of carrier performance
Export reports and send them to your third parties to negotiate fines settlements, better rates, and improved terms. Get started today to see how SupplyPike can improve your OTIF score!