Calculate Days on Hand (DOH) usage for inventory
Requirement
Introduction: In a life science digital supply chain, calculating Days on Hand (DOH) usage for inventory and product plants is crucial for efficient supply chain management. DOH measures the average number of days it takes to sell or use inventory. By analyzing DOH usage, businesses can identify potential stockouts, excess inventory, and optimize inventory levels.
DOH Calculation: DOH = (Average Inventory / Average Daily Sales) * 365
Average Inventory: Calculated from f_inv_movmnt, aggregating inventory values over the quarter and computing the mean
Average Daily Sales: Derived from the f_sales table, aggregating sales over the quarter and dividing by the number of active days in the quarter.
KPI Calculation:
Calculate the DOH usage KPI based on the calculated DOH values. This could involve calculating the average DOH, standard deviation, or other relevant metrics.
Expected Output: Develop simple Databricks SQL logic.
Unity Catalog details: 'f_inv_movmnt', 'f_sales'.