HELP: Inventory vs. COGS for monthly projections
So I know for annual projections inventory can be calculated as (inventory days/365)*COGS. COGS/Inventory is how many times inventory is turned over so it makes sense that annually the COGS will be a lot higher than inventory.
However, I'm a little confused when doing monthly. Say for January 2010 COGS is projected to be 10,000. If we're trying to project inventory based on COGS, and inventory days is 30, should inventory be calculated as (30/360)10,000? Or should it be over # of days in a month: (30/30)10,000? In this case since it takes 30 days to turn over and the # of days in a month is 30, would inventory just equal COGS?
Thanks!
Ok, well think about it this way. Inventory Turnover Days = Days in Period / Inventory Turnover . Therefore, Inventory Turnover = Days in Period / Inventory Turnover Days. In your case of January, IT = 31 / 30 .
Also we know, IT = COGS/Avg Inventory. Solving for Inventory:
Inventory = COGS / IT ==> Inventory = 10,000 / (31/30) or approximately 10,000
From another angle you could think about it this way... if the company were to do the exact same thing every month, IT, Days Inventory and Inventory should all approximately stay the same, so lets test our method.
For FY 2010 then, Inventory = 10,000 & COGS = 10,000*12 = 120,000 IT = 120,000 / 10,000 = 12 Days inventory = 365 / 12 which is approximately 30 (a little off since we assumed about 30 days in a month, but nonetheless logically correct). Therefore, we can conclude our inventory calculation was accurate.
Hope this helps.
Nemo libero et ipsam accusantium laudantium nam. Harum ea est eos dolore blanditiis optio voluptate velit. Dolorem corporis dicta quia error assumenda voluptatem sit. Omnis accusamus non consectetur aut sequi. Est pariatur quis reiciendis magnam voluptates sit.
Aut rem qui cum enim amet qui. Molestiae voluptas officiis aliquam qui vel ut aut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...