From the course: Excel: Value Stream Mapping

Unlock the full course today

Join today to access over 24,000 courses taught by industry experts.

Determine inventory waiting time

Determine inventory waiting time - Microsoft Excel Tutorial

From the course: Excel: Value Stream Mapping

Start my 1-month free trial Buy for my team

Determine inventory waiting time

“

- [Instructor] Once a station completes its part of a process, its output becomes inventory for the next step in the process. In this movie, I'll show you how to calculate inventory waiting time and add that information to your value stream map. I'll start in Excel using the 02_04 Inventory workbook. You can find that in the Exercise Files folder. I have information for my three stations, that is, attaching the limbs, the head, and also the backplate. And I've changed from a takt time to daily demand. The weekly demand, as we've seen in other movies, was 600 units. If you work five days a week, then your daily demand is 120. Now we can use our average inventory levels, that is, the number of units on hand in inventory for each of our three stations, to calculate the number of days of inventory that we have available. So I'll go down to cell C5 and click, and all we need to do is divide the average inventory by the…

Contents