[原创]Weighted Average Lead Time (WALT) ( Days )
<p>Weighted Average Lead Time (WALT) ( Days ) </p><p> </p>
<p>Let's see if I can still calculate WALT correctly. It's been a while. <br/><br/>1. In Excel make column heading- Item #, lead time (days), Std Cost, Est Annual Usage,Est Annual $, Lead Time X Est Annual $. <br/><br/>2. List all of your SKUs under "Item #" and populate the next 3 colums with respective data from your information system or records. <br/><br/>3. Find your estimated annual $ (spend) by multiplying "estimated annual usage" X "Std Cost". <br/><br/>4. Find LT (lead time) X "Est Annual $" by multiplying those fields. <br/><br/>5. At the bottom of your worksheet, sum "Est Annual $" and "LT X EA $". <br/><br/>6. Divide "LT X EA $" by "Est Annual $" to find your WALT in days. <br/><br/>If anyone sees an adjustment to the logic/ math that needs to be made, please jump in. I'm 98% sure this is the correct way to calculate the WALT. I've nver calcualted WAPT, but I would assume same logic, different variables. Let me know if trhis helps! <br/><br/>这是我从网上查到的，不知道有没有其他的算法。</p>
页:
[1]