Inventory turnover
Warmehands Inc. wants to know how often they sold their products during 2021. Your task is to analyze this issue using the Inventory Turnover. Now that you have the current inventory stock, it will be easy to calculate this efficiency ratio. Remember, you can calculate this metric as:
\(Inventory\;turnover = \frac{COGS}{Average\;value\;of\;inventory}\)
We recommend you to keep working in your own workbook but if you lost progress you can open 2_1_sales_by_year_solution.pbix
from the Exercises folder on the Desktop
This exercise is part of the course
Case Study: Inventory Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
