Planning is integral to all of your manufacturing processes. Knowing the lead times with your suppliers based on items and locations can allow you to make more informed decisions. Based on current market trends we can see that being able to see how lead times are increasing will affect your ability to manufacture the products you sell and thrive in the complicated marketplace.
Let's Take a Look
Use the numbers in the image to help identify the sections for a deep dive of the functionality below.
- How Do Lead Times Vary by Item, Supplier, and Location
- By Vendor - Expected vs Actual Lead Time
- By Item - Expected vs Actual Lead Time
- Average Lead Time Breakdowns by Item and Supplier
- Download Data
These filters can help you increase or decrease the timing around how you manage lead times. You can also get a visual based on buyers, suppliers or sites. If you are looking for more information on the filters and what they mean, you can see in depth information on each filter here.
2) How Do Lead Times Vary by Item, Supplier, and Location
This top map can help you to see where your items are being received and then dig a little deeper to see the amount of your inventory going to the area of the country as well as how lead times vary by location.
By clicking into a section, you are also filtering all of the other tables to take into account the location that you have chosen. Your first look within this table will show you:
- Average Lead Time to That Location
- Count of PO Lines Going to That Location
This can help you to identify areas of the US where you need to account for lead time when setting up orders, and could also help you with resource and inventory planning for locations where lead time is not trending consistently.
3) By Vendor - Expected vs Actual Lead Time
This chart helps you to see lead time based on a supplier. As you drill in, you can see more about the supplier, the parts they are sending to you and whether they are delivering on time or late.
4) By Item - Expected vs Actual Lead Time
This chart helps you to see lead time based on a item. As you drill in, you can see more about the supplier, the parts they are sending to you and whether they are delivering on time or late.
5) Average Lead Time Breakdowns by Item and Supplier
This chart is filtered by any of the other charts in this dashboard. It can show you the costs and lead times affecting your deliveries. You will also see:
- Item Name - Name of the item. "Item (P/N)" in the PO table.
- Item Description - Description of the item. "Item Description" in the PO table.
- Supplier's Name - Name of the supplier
- PO Spend Calc - Total spend for all PO lines with that item name.
- Most Recent Cost for the Item - The unit cost for the most recent receipt of this item
- A Chart of the Lead Times for The Item Over Time - Total range of lead times for the selected period
6) Download Data
You can download any of your data from these charts for use and additional analysis. You can download to either excel or csv.
- Click the download data link
- When you are taken to the downloads tab, click on "Choose your data download"
- You will see a pop up box that will allow you to choose either:
- Lead Time: Data Download
- Moves: Data Download
- OTIF: Data Download
- PPV: Data Download
- Choose the format: Excel or CSV
- Then click download
The download will include all lines of data that were used to make the dashboard (it will not contain the actual charts)