Hello, Great video, thank you very much for the time and effort put into it. I did have a few questions: When calculating holding cost, to eventually use for EOQ calculating, isn't it supposed to be for an individual SKU? Like, we'd have to calculate this holding cost for every SKU, since depending on the price of the SKU, it'd change the holding cost. Is that correct? Is that implied in this example? Also, is there ever a situation where you'd use the cost associated with all of the different SKU's as Inventory Cost? Thanks
Ian, really useful video as others. However, why did you divide the total cost by 12? You began with the month inventory cost of $1M and then calculated each line item monthly e.g. damage of $20K per month? Why did you then divide the total by 12 again? May be I am missing something here?
Not sure if this is meaningful to you after 3 years but hey...the $1 million dollar inventory figure is the "average inventory value" of the facility or in other words $1 million dollars is the average inventory level they have on any given day during the year so they are financing $1 million dollars of inventory on average which is an annualized number. All the other costs are also annualized hence the "divide by 12"
Hello,
Great video, thank you very much for the time and effort put into it.
I did have a few questions:
When calculating holding cost, to eventually use for EOQ calculating, isn't it supposed to be for an individual SKU?
Like, we'd have to calculate this holding cost for every SKU, since depending on the price of the SKU, it'd change the holding cost. Is that correct? Is that implied in this example?
Also, is there ever a situation where you'd use the cost associated with all of the different SKU's as Inventory Cost?
Thanks
Nicely done.
Is your inventory value based on sales price or cost of goods (excluding admin & other miscellaneous costs)
Ian, really useful video as others. However, why did you divide the total cost by 12? You began with the month inventory cost of $1M and then calculated each line item monthly e.g. damage of $20K per month? Why did you then divide the total by 12 again? May be I am missing something here?
Not sure if this is meaningful to you after 3 years but hey...the $1 million dollar inventory figure is the "average inventory value" of the facility or in other words $1 million dollars is the average inventory level they have on any given day during the year so they are financing $1 million dollars of inventory on average which is an annualized number. All the other costs are also annualized hence the "divide by 12"
V. Good