健康库存三层数字化KPI体系 — 可视层/分析层/应用层的量化指标与联通机制

"""
健康库存三层数字化KPI体系
基于《全链路管理》陈凤霞 第七章第六节
可视层 + 分析层 + 应用层的三层量化指标
"""
import numpy as np
import pandas as pd
from dataclasses import dataclass, field
from typing import Dict, List, Optional
import warnings
warnings.filterwarnings('ignore')


@dataclass
class SKUInventoryData:
    """SKU库存数据（整合多源）"""
    sku_id: str
    abc_class: str
    unit_cost: float
    unit_price: float
    current_stock: int
    in_transit: int
    sales_last_7d: float
    sales_last_14d: float
    sales_last_30d: float
    aging_0_30: int     # 0-30天库龄库存
    aging_31_60: int
    aging_61_90: int
    aging_90plus: int
    lead_time_days: int
    safety_stock_days: int


class HealthyInventoryThreeLayerKPI:
    """健康库存三层数字化KPI体系"""

    def layer1_visibility(self, sku: SKUInventoryData) -> Dict:
        """可视层 KPI"""
        total_stock = sku.current_stock + sku.in_transit
        inventory_value = sku.current_stock * sku.unit_cost
        avg_daily_sales = sku.sales_last_30d / 30

        # DOI
        doi = total_stock / max(avg_daily_sales, 0.01)

        # 动销率（近7天是否有销售）
        is_active = sku.sales_last_7d > 0

        # 库龄分布
        total = max(sku.current_stock, 1)
        aging_dist = {
            '0-30天': sku.aging_0_30 / total,
            '31-60天': sku.aging_31_60 / total,
            '61-90天': sku.aging_61_90 / total,
            '90天+': sku.aging_90plus / total,
        }

        # 五色灯
        target_doi = sku.lead_time_days + sku.safety_stock_days
        doi_ratio = doi / max(target_doi, 1)