仓容管理与仓储效率规划 — 仓容测算、仓储效率模拟与精细化5步运营

"""
仓容管理与仓储效率规划系统
功能：仓容测算 + 确定性/随机模拟 + 精细化运营5步 + FBA/自营分配
"""
import numpy as np
import pandas as pd
from dataclasses import dataclass, field
from typing import List, Dict, Tuple, Optional
import warnings
warnings.filterwarnings('ignore')


@dataclass
class WarehouseSKU:
    """仓储SKU信息"""
    sku_id: str
    abc_class: str
    current_stock: int
    volume_per_unit: float      # 体积（立方英尺/件 for FBA）
    weight_per_unit: float      # 重量（磅/件）
    daily_sales: float
    lead_time_days: int
    unit_storage_cost: float    # 仓储费（$/件/月）
    planned_inbound: List[Tuple[int, int]] = field(default_factory=list)  # [(days_from_now, qty)]


@dataclass
class WarehouseConfig:
    """仓库配置"""
    name: str
    capacity_ft3: float         # 总容量（立方英尺）
    utilization_target: float   # 目标利用率（0.75-0.85）
    fixed_monthly_cost: float   # 月固定成本($)
    cost_per_ft3: float         # 每立方英尺月成本($)


class WarehouseCapacityPlanner:
    """仓容管理规划器"""
    
    def __init__(self, warehouse: WarehouseConfig):
        self.wh = warehouse
        self.usable_capacity = warehouse.capacity_ft3 * warehouse.utilization_target
    
    def compute_current_usage(self, skus: List[WarehouseSKU]) -> Dict:
        """计算当前仓容使用情况"""
        total_volume = sum(sku.current_stock * sku.volume_per_unit for sku in skus)
        usage_pct = total_volume / self.wh.capacity_ft3
        usable_remaining = self.usable_capacity - total_volume
        
        by_abc = {}
        for cls in ['A', 'B', 'C']:
            cls_skus = [s for s in skus if s.abc_class == cls]
            vol = sum(s.current_stock * s.volume_per_unit for s in cls_skus)
            by_abc[cls] = {'volume': vol, 'pct': vol / max(total_volume, 1)}
        
        return {
            'total_volume': total_volume,
            'usage_pct': usage_pct,
            'usable_remaining': usable_remaining,
            'by_abc': by_abc,