医院骨科耗材入库分析数据

在医院骨科耗材入库分析场景中,通过对医院的骨科耗材入库与时间维度的挖掘,生成的数据可作为模型辅助医院监管人员对医院骨科耗材入库的异常波动分析.从而分析骨科耗材入库的变化幅度与时间范围的关系.以此来管控骨科耗材入库异常波动.定位问题,针对性的做介入管控和调节.该模型普适于各大医院和医疗机构.1:数据来源: 采集多个医院SPD系统中每月骨科耗材入库数据 2: 数据处理: 耗材名称: PN; 规格型号:SPEC; 单位: UN; 本月入库单价: CP 当前月耗材入库价格; 本月入库数量 : CN 当前月耗材入库数量 ; 本月入库总金额 : CA 当前月耗材入库总金额 ; 上月入库单价: LP 上月的耗材入库单价; 上月入库数量: LN 上月的耗材入库数量; 上月入库总金额: LA 上月的耗材入库总金额; 环比增长率: SGR 当前月耗材的入库金额与上月的入库金额的增长率; 环比增长率状态: SGRS 当前月耗材的入库金额与上月的入库金额的增长率状态; ; 入库月份: MT; 3:算法分析: 采用公式计算该骨科耗材入库金额环比增长率 SGR= ( (CP* CN )/(LP*LN)-1) x100%; 4:数据应用: 在医院骨科耗材入库分析场景中,该骨科耗材入库金额环比增长率SGR( 小于-60%,当月该骨科耗材入库异常,(-60% 100%),正常浮动范围, 大于100%当月该骨科耗材入库异常 );In the scenario of hospital orthopedic consumables warehousing analysis, data generated by mining orthopedic consumables warehousing records and time dimensions of hospitals can assist hospital supervisors in analyzing abnormal fluctuations in orthopedic consumables warehousing. By analyzing the relationship between the change amplitude of orthopedic consumables warehousing and the time range, the abnormal fluctuations of orthopedic consumables warehousing can be controlled, problems can be located, and targeted intervention, control and adjustment can be carried out. This model is generally applicable to major hospitals and medical institutions. 1. Data Source: Collect monthly orthopedic consumables warehousing data from the SPD systems of multiple hospitals 2. Data Processing: Consumables Name: PN; Specification Model: SPEC; Unit: UN; Current Month Warehousing Unit Price: CP, referring to the unit price of consumables warehousing in the current month; Current Month Warehousing Quantity: CN, referring to the quantity of consumables warehousing in the current month; Current Month Total Warehousing Amount: CA, referring to the total amount of consumables warehousing in the current month; Last Month Warehousing Unit Price: LP, referring to the unit price of consumables warehousing in the last month; Last Month Warehousing Quantity: LN, referring to the quantity of consumables warehousing in the last month; Last Month Total Warehousing Amount: LA, referring to the total amount of consumables warehousing in the last month; Month-on-Month Growth Rate: SGR, referring to the growth rate of consumables warehousing amount in the current month compared with that in the last month; Month-on-Month Growth Rate Status: SGRS, referring to the status of the month-on-month growth rate of consumables warehousing amount in the current month compared with that in the last month; Warehousing Month: MT; 3. Algorithm Analysis: The month-on-month growth rate SGR of orthopedic consumables warehousing amount is calculated via the formula: SGR= ((CP*CN)/(LP*LN)-1) ×100%; 4. Data Application: In the scenario of hospital orthopedic consumables warehousing analysis, the month-on-month growth rate SGR of orthopedic consumables warehousing amount is used for abnormality judgment: when SGR < -60%, the warehousing of this orthopedic consumables in the current month is abnormal; when -60% ≤ SGR ≤ 100%, it falls within the normal fluctuation range; when SGR > 100%, the warehousing of this orthopedic consumables in the current month is abnormal;