I would like to implement a tool vendor capacity chart for my team. They like visual information vs. a bunch of data on a spreadsheet. We work with 5 - 7 tool vendors and I want to be able to assist the team by having them review the capacity chart prior to awarding them the business. We work with smaller ma & pop shops so they will take jobs and say they can meet the lead time and they really can't. At least with this chart we would have an idea of their ability to meet the requested lead time based on what we've given them already. I know they have other tools with other suppliers in their shop so this chart isn't going to show all of their capacity, but at least we will see ours. We have some of the vendors that won't turn down the work and would rather take the job and deliver late than turn it down (it eats into our lead time). Which is why this chart would be very helpful when we are deciding who we want to award the final job to. This would at least give my team a snapshot of the jobs in their queue and determine if we should award the job to one vendor vs. the other. What I would like to be able to show my team is the following information in a chart form.
- tool vendor - VENDOR NAME
- customer name - CUSTOMER
- customer description - TOOL DESCRIPTION
- customer ORD # - ITEM NUMBER
- current tool lead time (ie., 4 weeks, 9 weeks, etc.) - CREATED DATE THROUGH REQUESTED DATE
- classification (this lets me know if the tool is seal, o'ring, bladder, etc) - TOOL CLASSIFICATION
Since I want to see a lot of information I figured viewing the data by tool vendor would be the best way. On the current tool PO tab, this is what I came up with but it looks very sad, so I'm reaching out to the Experts. The data in the tab was test data to see what the chart would look like. The first tab (data) has data that I would be using.
I would like my team to take away something like this. Tool vendor X has 7 tools in the queue. And tool 1 was place on 6/25 and is due 8/1, tool 2 was placed 6/29 and is due 7/15,etc. Not sure if it's possible to show the number of weeks next to each job but that might not even be necessary if I can get the chart look the way I am visioning it.