高空车及洗地机销售情况分析数据

通过采集高空及洗地机类别产品的销售订单，计算高空及洗地机类别大类中不同型号的销售金额及销量占比，用来评价高空及洗地机类别类别车型的销售情况。应用于评估生产和销售策略，生产、供货企业可以通过该数据算法了解不同产品的销售情况，调整产业结构，掌握市场动向，统筹生产经营，帮助预测市场趋势，降低因市场波动造成的损失，依托数据资料构建产业产品销售趋势图，帮助管理层对车型制定针对性的营销策略和相应优惠政策，并为企业生产规划提供有效的数据支持，对全行业具有示范指导作用。
1：采集本公司高空及洗地机类别的销售订单，输入数据内容包括单据编号，单据状态，业务日期，月份，大类，分类，物料编码，物料名称，计量单位，数量。2.算法描述：利用SUM函数计算不同车型的总销售额，要求单据状态不为历史版本，总销售额＝SUM(订单台量x订单车辆单价)，输出不同车型销售额占比，销售额占比＝某车型总销售额/高空及洗地机类别大类销售总额；4：依靠市场经验将车型销售情况进行分级评价，当销售额占比达到60%时，评价该车型销售情况为A级产品。当销售额占比为20%-40%时，评价该车型销售情况为B级产品。当销售额占比为0-21%时，评价该车型销售情况为C级产品。对于A级产品，可提高生产和供货数量；对于B级产品，需按固定周期关注该产品的销售情况，适当调整生产和供货策略；而对于C级产品，需每月关注该车型销售情况，了解其销售情况变化，以适应大幅度调整经营策略的需要。

This dataset is developed by collecting sales orders of aerial work equipment and floor scrubber products, and calculating the sales amount and sales volume proportion of different models under the aerial work and floor scrubber product category to evaluate the sales performance of products within this category. It is applied to the assessment of production and sales strategies. Manufacturers and supply chain enterprises can leverage this data algorithm to gain insights into the sales performance of various products, adjust the industrial structure, grasp market trends, coordinate production and operation activities, predict market trends, mitigate losses caused by market fluctuations, construct industry-wide product sales trend charts based on the collected data, assist the management team in formulating targeted marketing strategies and corresponding preferential policies for the products, provide effective data support for enterprise production planning, and play a demonstrative and guiding role for the entire industry.

1. Data Collection: Collect sales orders of the company's aerial work equipment and floor scrubber products. The input dataset includes document number, document status, business date, month, product category, classification, material code, material name, unit of measurement, and quantity.

2. Algorithm Description: Calculate the total sales of different product models using the SUM function, with the requirement that the document status is not a historical version. The total sales is calculated as SUM(quantity × unit price per product), and output the sales revenue proportion of each model, which is defined as total sales of a specific model divided by the total sales of the entire aerial work equipment and floor scrubber product category.

3. Sales Performance Grading: Grade the sales performance of products based on market experience:
- Class A product: when the sales revenue proportion reaches 60%;
- Class B product: when the sales revenue proportion ranges from 20% to 40%;
- Class C product: when the sales revenue proportion ranges from 0% to 21%.

4. Corresponding Operational Strategies:
- For Class A products: increase production and supply quantities;
- For Class B products: monitor their sales status at fixed intervals and appropriately adjust production and supply strategies;
- For Class C products: monitor their sales changes on a monthly basis to support large-scale adjustments to business strategies.

搜集汇总

数据集介绍

特点

该数据集为诺力智能装备股份有限公司提供的高空车及洗地机销售分析数据，包含646条销售记录，通过算法计算不同车型销售占比并进行分级评价，用于企业生产销售策略调整和市场趋势预测。