手动产品销售情况分析数据

通过采集手动产品的销售订单，计算手动产品大类中不同型号的销售金额及销量占比，用来评价手动产品类别车型的销售情况。应用于评估生产和销售策略，生产、供货企业可以通过该数据算法了解不同产品的销售情况，调整产业结构，掌握市场动向，统筹生产经营，帮助预测市场趋势，降低因市场波动造成的损失，依托数据资料构建产业产品销售趋势图，帮助管理层对手动产品车型制定针对性的营销策略和相应优惠政策，并为企业生产规划提供有效的数据支持，对全行业具有示范指导作用。 1：采集手动产品的销售订单，输入数据内容包括单据编号，单据状态，业务日期，月份，大类，分类，物料编码，物料名称，计量单位，数量。2.算法描述：利用SUM函数计算手动产品型不同车型的总销售额，要求单据状态不为历史版本，总销售额＝SUM(订单台量x订单车辆单价)，输出不同车型销售额占比，销售额占比＝某车型总销售额/三类车大类销售总额；4：依靠市场经验将车型销售情况进行分级评价，当销售额占比达到30%时，评价该车型销售情况为A级产品。当销售额占比为10%-30%时，评价该车型销售情况为B级产品。当销售额占比为0-10%时，评价该车型销售情况为C级产品。对于A级产品，可提高生产和供货数量；对于B级产品，需按固定周期关注该产品的销售情况，适当调整生产和供货策略；而对于C级产品，需每月关注该车型销售情况，了解其销售情况变化，以适应大幅度调整经营策略的需要。This dataset is developed by collecting sales orders of manual products, calculating the sales amount and sales proportion of different models under the manual product category to evaluate the sales performance of manual product category vehicles. It is applied to the evaluation of production and sales strategies. Production and supply enterprises can use this data algorithm to understand the sales status of different products, adjust the industrial structure, grasp market trends, coordinate production and operation, predict market trends, and reduce losses caused by market fluctuations. Based on the collected data, industrial product sales trend charts can be constructed, helping the management formulate targeted marketing strategies and corresponding preferential policies for manual product vehicles, providing effective data support for enterprise production planning, and playing a demonstrative and guiding role for the entire industry. 1. Data Collection: Collect sales orders of manual products. The input data includes document number, document status, business date, month, main category, sub-category, material code, material name, unit of measurement, and order quantity. 2. Algorithm Description: Calculate the total sales revenue of different vehicle models under the manual product category using the SUM function, with the requirement that the document status is not a historical version. The total sales revenue is calculated as: Total Sales Revenue = SUM(quantity of ordered vehicles × unit price of ordered vehicles). Then output the sales revenue proportion of each vehicle model, where the formula is: Sales Revenue Proportion = Total Sales Revenue of a Certain Vehicle Model / Total Sales Revenue of the Manual Product Category. 4. Sales Performance Grading: Conduct graded evaluation of vehicle model sales performance based on market experience. A vehicle model is rated as Class A product when its sales revenue proportion reaches 30%; Class B product when its sales revenue proportion is between 10% and 30%; Class C product when its sales revenue proportion is between 0% and 10%. For Class A products, production and supply quantities can be increased. For Class B products, the sales performance of the product needs to be monitored at fixed intervals, and production and supply strategies should be appropriately adjusted. For Class C products, the sales performance of the vehicle model needs to be monitored monthly to understand changes in sales, so as to adapt to the need for major adjustments to business strategies.

搜集汇总

数据集介绍

特点

该数据集记录了手动产品的销售订单数据，包含详细的销售信息和评价等级，用于分析不同车型的销售情况，帮助企业优化生产和销售策略。数据规模为6295条，格式为xlsx，按需更新。