重点产品成本占比结构化分析数据集
收藏资源简介:
数据采集来源于管材企业的生产管理系统、库存管理系统及财务核算系统,涵盖533种产品的基础信息、数量数据、成本数据及交易数据,确保核心字段无缺失;数据加工环节先进行数据清洗(整合分散的产品记录,确保总记录数 2524 条完整可用),再通过“关键词分类”将产品归为排水管类、通用管材类等10大类别,随后计算“成本占比”“平均单位成本”,最后按“总成本降序排序”筛选前50名重点产品并计算累计成本占比,形成多层级结构化数据集,保障数据准确性与分析可用性。
The dataset was collected from the production management system, inventory management system and financial accounting system of a pipe manufacturing enterprise. It covers basic information, quantity data, cost data and transaction data for 533 product types, with no missing core fields guaranteed. In the data processing stage, data cleaning was first conducted: scattered product records were integrated to obtain 2524 complete and usable records. Subsequently, products were classified into 10 major categories such as drainage pipes and general-purpose pipes via keyword-based classification. Then, the cost proportion and average unit cost were calculated. Finally, the top 50 key products were screened out by sorting in descending order of total cost, and their cumulative cost proportion was calculated, forming a multi-level structured dataset to ensure data accuracy and analytical usability.




