Calculating the importance of which car spare parts should be expedited based on lead time

[5afff]

[FONT=&quot]Hi all,[/FONT]
[FONT=&quot]Imagine you run a fleet of thousands of vehicles. You have a few hundred which are not usable because they are waiting for one or more spare parts. You keep track of all the spare parts ETA to your workshop. I'm struggling to make a formula which would rank the whole list of spare parts on importance (which could then be used to expedite the delivery of the spare part to the workshop). So for example, if clutches were expedited, then 25 cars would be ready 5 days quicker.

The aim is to identify which spare parts to expedite, which would allow for the greatest number of vehicles back on the road, in the shortest amount of time.

[/FONT]
[FONT=&quot]I've looked into weighted averages, but cant seem to get it to work. What approach would you recommend?[/FONT]

 

[Fazza]

Like you wrote, identify which would give the greatest number of vehicles back on the road in the shortest time.

Just explain how do you do that, and then model it in Excel.