浙江省杭州市九洲大药房大关二店销售预警数据

采集了九洲大药房大关二店销售分析的预警指标，分析得到经营额同比、来客数同比、效期数、滞销占比、周转天数的预警指标，不仅可用于监控管理门店的销售情况，用于门店即时监控预警、快速预警响应、预知顾客流失、库存积压等问题，同时长期预警数据分析指引未来的业务方向和策略制定；还可用于行业分析与市场调研、供应链管理、金融投资与风险评估、消费者行为分析等场景有需求的企业或机构，包括同行业药店或连锁店、药品供应商和分销商、市场营销与广告公司、政府与监管机构等。1.数据来源
采集了近30天销售总额，滞销金额，库存，经营额同比、来客数同比、效期数、滞销占比、周转天数等预警数据。
2.数据处理
设定不同参数的预警阀值和预警指标，其中预警阈值由九洲大药房大关二店的历史预警数据根据时间序列分析法得到。
(1)经营额同比预警指标：若上一时期同比下降比例达到预警阈值（如5%），视为预警信号，可能意味着销售业绩下滑。
(2)来客数同比预警指标：来客数减少比例达到预警阀值（如降低10%以上），提示需要关注顾客流失问题。
(3)效期数预警指标：若临近有效期商品数量增加比例达到预警阀值，需警惕库存积压和潜在的损耗风险。
(4)周转天数预警指标：周转天数=30/（近30天销售总额/库存），库存周转天数增加超出预警阀值，可能是库存管理不善或市场需求减少的迹象。
(5)滞销占比预警指标：滞销占比=滞销金额/库存，超过预警阀值的滞销商品需特别关注并考虑促销策略。

This dataset collects and analyzes early warning indicators for sales performance from Daguan No.2 Store of Juzhou Pharmacy. The derived core early warning indicators cover year-on-year (YoY) changes in operating revenue, YoY changes in customer traffic, expiring product quantity, slow-moving product ratio, and inventory turnover days. These indicators serve multiple purposes: firstly, they enable real-time monitoring and early warning of the store’s sales status, facilitating rapid alert response, prediction of customer churn and inventory overstock issues; secondly, long-term analysis of the early warning data can guide the formulation of future business directions and strategies. Additionally, the dataset supports various scenarios for targeted enterprises or institutions, including peer pharmacies or chain stores, pharmaceutical suppliers and distributors, marketing and advertising firms, government and regulatory agencies, covering industry analysis and market research, supply chain management, financial investment and risk assessment, and consumer behavior analysis.

1. Data Source
The dataset collects early warning data spanning the past 30 days, including total sales revenue, slow-moving product amount, inventory, YoY changes in operating revenue, YoY changes in customer traffic, expiring product quantity, slow-moving product ratio, and inventory turnover days.

2. Data Processing
Early warning thresholds and indicators with varying parameters are established. Specifically, the early warning thresholds are derived from the historical early warning data of Daguan No.2 Store of Juzhou Pharmacy using time series analysis methods.
(1) Operating Revenue YoY Early Warning Indicator: If the YoY decline rate in the previous period reaches the early warning threshold (e.g., 5%), it is deemed an early warning signal, potentially indicating a decline in sales performance.
(2) Customer Traffic YoY Early Warning Indicator: If the reduction rate of customer traffic exceeds the early warning threshold (e.g., more than 10%), it serves as a prompt to pay attention to potential customer churn issues.
(3) Expiring Product Quantity Early Warning Indicator: If the growth rate of the quantity of near-expiry products reaches the early warning threshold, it is necessary to be vigilant against inventory overstock and potential loss risks.
(4) Inventory Turnover Days Early Warning Indicator: The formula for inventory turnover days is 30 / (total sales revenue over the past 30 days / inventory). An increase in inventory turnover days beyond the early warning threshold may signal poor inventory management or reduced market demand.
(5) Slow-moving Product Ratio Early Warning Indicator: The slow-moving product ratio is calculated as slow-moving product amount / inventory. Slow-moving products exceeding the early warning threshold require special attention and the consideration of promotional strategies.

搜集汇总

数据集介绍

特点

该数据集记录了浙江省杭州市九洲大药房大关二店的销售预警数据，包含17个字段和631条数据，用于监控门店销售情况和预警分析。应用场景广泛，包括门店管理、行业分析和供应链优化等。