电动工具上游零部件供应厂商分级数据

本公司专业从事电动工具近20年，已积累大量上游零部件供应厂商数据，基于此，本数据的应用场景为：
1.面向本公司：该数据有助于本公司的供应链管理，通过量化评分和评级数据识别、筛选供应商，并进行针对性优化，从而提高供应链的质量。
2.面向其他电动工具制造商：同行公司可以利用本数据来评估和选择供应商，通过比较不同供应商的质量评分、价格评分、交期评分、供应商综合评分和评级数据，针对自身供应链薄弱环节优化供应链结构，从而提升供应链的稳定性和质量。
3.面向投资公司：投资公司可以利用本数据来评估电动工具行业的供应链健康状况作为投资决策的参考。通过分析供应商的评级，投资公司可以识别行业中的优质企业和潜在的投资机会。1.数据收集和预处理：收集公司内部供应商管理平台数据，包括统计时间、供应商编号、供应物料名称、物料合格率、物料退货率、物料供应商平均价格、物料市场平均报价、按时交货次数、总交货次数等数据，并对数据进行清洗，保证数据质量。 2.计算供应商质量评分（QS):QS=(100×(1−退货率)+100×合格率)/2； 3.计算供应商价格评分（CS):CS=100×（物料市场平均报价 / 物料供应商平均价格）； 4.计算供应商交期评分（DS）：DS=100×（按时交货次数/总交货次数）； 5.计算供应商综合评分（OS）：OS=α×QS＋β×CS＋γ×DS；α，β，γ是权重系数，跟据各要素影响程度经行业专家意见研讨确定，且α＋β＋γ＝１； 6.供应商等级分类：跟据专家研讨确定以下分类：OS≥90分：A级；80≤OS＜90：B级；60≤OS＜80：C级；PVD＜60：D级）。

Our company has been specializing in power tools for nearly 20 years and has accumulated a large amount of data from upstream component suppliers. Based on this, the application scenarios of this dataset are as follows:
1. For our company: This data supports supply chain management. We can identify and screen suppliers through quantitative scoring and rating data, and implement targeted optimization to improve supply chain quality.
2. For other power tool manufacturers: Peer enterprises can use this dataset to evaluate and select suppliers. By comparing the quality scores, price scores, delivery lead time scores, comprehensive supplier scores and rating data of different suppliers, they can optimize their supply chain structure targeting their own supply chain pain points, thereby enhancing the stability and quality of the supply chain.
3. For investment institutions: Investment companies can use this dataset to assess the supply chain health of the power tool industry as a reference for investment decision-making. By analyzing supplier ratings, they can identify high-quality enterprises and potential investment opportunities in the industry.

The dataset construction process is as follows:
1. Data collection and preprocessing: Collect data from the company's internal supplier management platform, including statistical time, supplier ID, supplied material name, material pass rate, material return rate, average price of materials supplied by the supplier, average market quotation of materials, number of on-time deliveries, total number of deliveries and other related data, and clean the data to ensure data quality.
2. Calculation of supplier quality score (QS): $QS=(100 imes(1- ext{return rate}) + 100 imes ext{pass rate})/2$
3. Calculation of supplier price score (CS): $CS=100 imes( ext{average market quotation of materials} / ext{average price of materials supplied by the supplier})$
4. Calculation of supplier delivery lead time score (DS): $DS=100 imes( ext{number of on-time deliveries} / ext{total number of deliveries})$
5. Calculation of supplier comprehensive score (OS): $OS=alpha imes QS + eta imes CS + gamma imes DS$; $alpha$, $eta$, $gamma$ are weight coefficients, which are determined through industry expert consultation based on the impact degree of each factor, and satisfy $alpha+eta+gamma=1$.
6. Supplier grade classification: The classification criteria are determined through expert consultation: Grade A when $OSgeq90$; Grade B when $80leq OS<90$; Grade C when $60leq OS<80$; Grade D when $OS<60$.