二丁酰环磷腺苷钠软膏进货商层级数据

通过计算全国区域内的不同进货商进货本公司二丁酰环磷腺苷钠软膏的进货明细信息，对不同的进货商按照EDP模型进行分层，通过对进货商进行分层管理，所有企业可在后期对不同层级的进货商采取不同的运营策略提供数据依据。根据进货商的不同层级，企业可以更有效地规划库存，减少库存积压或短缺的风险，有助于与进货商之间建立更加稳固和高效的供应链体系，提高供应链的整体绩效。1、数据采集：利用进货存管理系统（金蝶供应链云）导出全国区域内的不同进货商每月进货本公司二丁酰环磷腺苷钠软膏的进货明细。2、数据处理：以进货商编号作为唯一标识，对数据进行清洗、去除无效数据和极限数据等操作。3、数据加工：通过LOOKUP函数计算出进货商最近一次进货距离当月月底的天数E，COUNTIF函数计算该月份进货次数D，SUMIF函数计算该月份进货总金额P，进货商最近一次进货距离当月月底的天数大于或者等于当月进货平均天数则E的定档值为1，进货商最近一次进货距离当月月底的天数小于当月进货平均天数则E的定档值为0，同理也分别计算出D、P的定档值（分别用进货次数、进货总金额与各自的平均值相比较），再根据EDP模型分层规则，将进货商分为8个层级，即分为重要价值客户(EDP为111)、重要保持客户(EDP为101)、重要发展客户(EDP为011)、重要挽留客户(EDP为001)、一般价值客户(EDP为110)、一般保持客户(EDP为100)、一般发展客户(EDP为010)和一般挽留客户(EDP为000)。4、数据应用：通过对进货商进行分层管理，所有企业可对不同层级的进货商定制不同的运营策略。

This dataset is constructed to provide data support for enterprises to implement differentiated operational strategies for purchasers at different tiers via tiered purchaser management. The dataset is developed based on the procurement details of Dibutyryl Cyclic Adenosine Sodium Ointment purchased by various purchasers across the national territory, with purchasers tiered using the EDP model. Based on the tier classification of purchasers, enterprises can more efficiently plan inventory, mitigate the risks of inventory overstock or shortage, facilitate the establishment of a more stable and efficient supply chain system with purchasers, and enhance the overall supply chain performance.

1. Data Collection: Export the monthly procurement details of Dibutyryl Cyclic Adenosine Sodium Ointment from different purchasers across the national region using the Inventory Management System (Kingdee Supply Chain Cloud).
2. Data Processing: Use the purchaser ID as the unique identifier, and perform data cleaning, removal of invalid data and outlier data, and other related operations.
3. Data Calculation and Tiering: Calculate the number of days E from a purchaser's last purchase to the end of the current month via the LOOKUP function; calculate the number of purchases D in the current month via the COUNTIF function; calculate the total purchase amount P in the current month via the SUMIF function. If the number of days from the purchaser's last purchase to the end of the current month is greater than or equal to the average purchase days of the current month, the tiered value of E is set to 1; otherwise, it is set to 0. Similarly, calculate the tiered values of D and P respectively by comparing the number of purchases and total purchase amount with their respective averages. Then, classify purchasers into 8 tiers in accordance with the EDP model tiering rules: Important Value Customers (EDP=111), Important Retention Customers (EDP=101), Important Development Customers (EDP=011), Important Win-Back Customers (EDP=001), General Value Customers (EDP=110), General Retention Customers (EDP=100), General Development Customers (EDP=010), and General Win-Back Customers (EDP=000).
4. Data Application: Through tiered management of purchasers, enterprises can formulate customized operational strategies for purchasers at different tiers.

搜集汇总

数据集介绍

特点

该数据集提供了二丁酰环磷腺苷钠软膏的进货商层级信息，包括产品型号、进货商编号、进货月份等关键字段，通过EDP模型对进货商进行分层，帮助企业制定针对性的运营策略，优化供应链管理。