Management method for inventory turnover period of waste steel industry base

By obtaining and calculating scrap steel inventory information from the business system, displaying inventory turnover cycles in different dimensions and warning of data beyond the scope, the problem of inaccurate estimate of scrap steel inventory turnover time in the existing technology is solved, and more efficient inventory management and reducing inventory costs are achieved.

CN119558772APending Publication Date: 2025-03-04OUYE LIANJIN RENEWABLE RESOURCES CO LTD +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411698247.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-26
Publication Date
2025-03-04

AI Technical Summary

Technical Problem

The existing technology cannot accurately estimate the turnover time of scrap steel inventory, resulting in the inability to accurately know the actual operating conditions of the company and the base, and the inability to make timely warnings and decisions.

Method used

By obtaining the current day and historical inventory information and historical sales volume from the business system, calculate the inventory turnover cycle in different dimensions, and preset the inventory safety threshold, and mark the red warning of data that exceeds the range.

Benefits of technology

It has realized the inventory turnover cycle of each branch company and base from different dimensions, helping the head office and branch company improve inventory management efficiency, reduce inventory costs, and timely identify inventory turnover issues.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119558772A_ABST
    Figure CN119558772A_ABST
Patent Text Reader

Abstract

The invention discloses a waste steel industry base inventory turnover period management method, and belongs to the technical field of waste steel. According to the invention, the problem that the steel scrap inventory management cannot be effectively carried out in the prior art is solved, the inventory turnover period of each sub-company and each base can be displayed from different dimensions by obtaining the current day and historical inventory information and historical sales volume from the business system and calculating the dimensions; therefore, a head office and molecular companies are helped to improve the inventory management efficiency, the inventory cost is reduced, the inventory turnover problem is recognized in time, red marking early warning can be carried out on data exceeding the safety range, an operation decision maker is reminded to make preparations in advance, and it is ensured that supply and demand of products are kept balanced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of scrap steel, and in particular to a method for managing the inventory turnover cycle of a scrap steel industry base. Background Art

[0002] Scrap steel enterprises will generate scrap steel inventory during the course of their business, and its turnover speed is a key indicator to measure their financial flexibility and operating conditions. There are different methods for calculating the goods turnover cycle in different industries. However, because the existing methods in other industries do not conform to the market rules of the scrap steel industry, the estimation of the turnover time of scrap steel inventory is often inaccurate, making it impossible to accurately know the actual operating conditions of the company and the base, and unable to make early warnings and decisions in time; therefore, it does not meet the existing needs. In this regard, we propose a management method for the inventory turnover cycle of the scrap steel industry base. Summary of the invention

[0003] The purpose of the present invention is to provide a management method for the inventory turnover cycle of a scrap steel industry base. By obtaining the current and historical inventory information and historical sales volume from the business system and calculating the dimensions, the inventory turnover cycle of each branch, subsidiary and base can be displayed from different dimensions, and the data exceeding the safety range can be marked in red as a warning, thereby helping the head office and branches and subsidiaries to improve the inventory management efficiency and solving the problems raised in the above-mentioned background technology.

[0004] To achieve the above object, the present invention provides the following technical solution: a method for managing the inventory turnover cycle of a scrap steel industry base, comprising the following steps:

[0005] Obtain data from business systems, including current and historical inventory information and historical sales;

[0006] Based on the acquired data, the inventory turnover cycle of each branch, subsidiary and base can be displayed in different dimensions by calculating the dimensions;

[0007] Pre-set inventory safety thresholds to determine whether the inventory turnover cycle exceeds the set inventory safety thresholds;

[0008] Displays all data and supports displaying detailed information.

[0009] Furthermore, obtaining data from the business system includes the following steps:

[0010] Obtain current and historical inventory information and historical sales from the business system through API interfaces;

[0011] Preprocess the acquired data, including data cleaning, deduplication and format conversion;

[0012] Based on the acquired data, calculate the inventory turnover cycle of each branch, subsidiary and base.

[0013] Furthermore, the preprocessing is specifically as follows:

[0014] Data cleaning: Check and fill missing values ​​caused by input errors, including using the mean, median or most frequent statistics to fill, or directly deleting data containing missing values, and deleting or correcting outliers in the data;

[0015] Data deduplication: Identify and remove duplicate data when acquiring data.

[0016] Data conversion: Convert data types to a uniform type.

[0017] Furthermore, it supports displaying detailed information, including the base name, the branch or subsidiary to which the base belongs, the base type, daily and monthly inventory information, and the total sales volume within the time span.

[0018] Furthermore, the calculation dimensions include:

[0019] According to the granularity: it is divided into two dimensions: branches and subsidiaries and bases;

[0020] The base dimension calculates each scrap steel base separately to obtain the inventory turnover cycle of each base;

[0021] The branch and company dimension is calculated separately according to the branch and company and base type to obtain the inventory turnover cycle of all bases under the base type of the branch and company;

[0022] According to the time span: divided into daily dimension, monthly dimension and annual dimension;

[0023] The daily dimension counts the inventory and sales volume so far this month;

[0024] The monthly dimension counts the inventory and sales volume of the previous month;

[0025] The annual dimension counts inventory and sales volume so far this year.

[0026] Furthermore, when the granularity is set to base granularity, the calculation formulas for base inventory turnover days under different time dimension conditions are:

[0027] Base daily dimension: Base inventory turnover days = number of days in the month of the query date * average inventory in the month of the query date / cumulative sales from the beginning of the month of the query date to the query date;

[0028] Among them, the average inventory of the query date month = (the inventory at the beginning of the month of the query date + the daily inventory of the query date and before the query date of the month) / (the number of days in the query date + 1);

[0029] Base monthly dimension: Base inventory turnover days = 30*query monthly average inventory / query monthly sales;

[0030] Among them, monthly average inventory = (inventory at the beginning of the month + inventory at the end of the month) / 2;

[0031] Base annual dimension: Base inventory turnover days = query month number * 30 * average monthly inventory quantity / cumulative sales volume up to the query month of the year;

[0032] Among them, the average monthly inventory quantity = (inventory quantity at the beginning of the year + inventory quantity at the end of the query month of the current year and each previous month) / (number of the query month + 1).

[0033] Furthermore, when the granularity is set to the branch and company granularity, the report displays the branch and company names, as well as the average inventory of the bases corresponding to each base type under the account set. The calculation formula is as follows:

[0034] Daily dimension of branches and subsidiaries: Inventory turnover days of branches and subsidiaries = number of days in the month when the query date is in the current month * sum of average inventory of all bases of the same type in the current month when the query date is in the current month / sum of cumulative sales of all bases of the same type from the beginning of the month when the query date is in the current month to the query date;

[0035] The sum of the average inventory of all bases of this type on the query date of the month = (the sum of the inventory of all bases of this type at the beginning of the month on the query date + the sum of the daily inventory of all bases of this type on the query date and before the query date) / (number of days on the query date + 1);

[0036] Monthly dimension of branches and subsidiaries: Inventory turnover days of branches and subsidiaries = 30*sum of average inventory of all bases of the same type in that month / sum of sales of all bases of the same type in that month;

[0037] The sum of the average inventory of all bases of this type in that month = (the sum of the inventory of all bases of this type at the beginning of the month + the sum of the inventory of all bases of this type at the end of the month) / 2;

[0038] Branch and subsidiary annual dimension: Branch and subsidiary inventory turnover days = query month number * 30 * sum of monthly average inventory quantity of all bases of this type / sum of sales volume of all bases of this type up to the query month in that year;

[0039] Among them, the sum of the average monthly inventory quantities of all bases of this type = (the sum of the inventory quantities of all bases of this type at the beginning of the year + the sum of the inventory quantities of all bases of this type at the end of the query month of the current year and previous months) / (number of query months + 1).

[0040] Furthermore, the inventory turnover cycle of each branch, subsidiary and base is displayed in different dimensions, including the following steps:

[0041] Use data visualization tools to visualize data;

[0042] Provide detailed description of inventory turnover cycle for the data presented;

[0043] The inventory safety threshold is set in advance. If the inventory level in the displayed data is lower than the inventory safety threshold, the data will be marked in red as a warning.

[0044] Furthermore, all displayed data supports detailed information display. Through data display, you can query the inventory amount, sales volume and estimated turnover days of each branch, subsidiary and base at a specified historical time point, specifically:

[0045] Provide an interactive interface for users;

[0046] The interactive interface provides paging functionality for users to quickly navigate between displayed data;

[0047] The interactive interface also provides filtering and sorting functions for users to query inventory turnover cycle status;

[0048] Users conduct in-depth analysis of the displayed data through the interactive interface.

[0049] Compared with the prior art, the present invention has the following beneficial effects:

[0050] The present invention obtains the current and historical inventory information and historical sales volume from the business system and calculates the dimensions, so as to display the inventory turnover cycle of each branch, subsidiary and base from different dimensions, thereby helping the head office and branches to improve inventory management efficiency, thereby reducing inventory costs, and timely identifying inventory turnover problems. Data that exceeds the safety range will be marked with a red warning to remind operational decision makers to make early preparations to ensure that the supply and demand of products are balanced. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] Figure 1 It is a flow chart of the inventory turnover cycle management method of the scrap steel industry base of the present invention;

[0052] Figure 2 This is a screenshot of the base granularity page of the present invention;

[0053] Figure 3 This is a screenshot of the molecular and company granularity page of the present invention;

[0054] Figure 4 This is a screenshot of the data details page of the present invention. DETAILED DESCRIPTION

[0055] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0056] In order to solve the problem that the existing methods of other industries are not in line with the market rules of the scrap steel industry, the estimation of the scrap steel inventory turnover time is often inaccurate, which makes it impossible to accurately know the actual operating conditions of the company and base, and it is impossible to make early warnings and decisions in time, please refer to Figure 1-Figure 4 , this embodiment provides the following technical solutions:

[0057] A method for managing the inventory turnover cycle of a scrap steel industry base comprises the following steps:

[0058] Obtain data from business systems, including current and historical inventory information and historical sales;

[0059] Based on the acquired data, the inventory turnover cycle of each branch, subsidiary and base can be displayed in different dimensions by calculating the dimensions;

[0060] Pre-set inventory safety thresholds to determine whether the inventory turnover cycle exceeds the set inventory safety thresholds;

[0061] Displays all data and supports displaying detailed information, including the base name, the branch or subsidiary to which the base belongs, the base type, daily and monthly inventory information, and the total sales volume within the time span.

[0062] The technical effect of the above content is: by obtaining the current and historical inventory information and historical sales volume from the business system, calculating the obtained data, and displaying the inventory turnover cycle of each branch, subsidiary and base from different dimensions through calculation dimensions, it can help the head office and branches to improve inventory management efficiency, and mark the data that exceeds the safety range with a red warning to remind operational decision makers to prepare early, so that each company can better predict and plan supply chain activities, thereby ensuring that the supply and demand of products are balanced.

[0063] Obtaining data from the business system includes the following steps:

[0064] Obtain current and historical inventory information and historical sales from the business system through API interfaces;

[0065] Preprocess the acquired data, including data cleaning, deduplication and format conversion;

[0066] Based on the acquired data, calculate the inventory turnover cycle of each branch, subsidiary and base.

[0067] Among them, preprocessing is specifically as follows:

[0068] Data cleaning: Check and fill missing values ​​caused by input errors, including using the mean, median or most frequent statistics to fill, or directly deleting data containing missing values, and deleting or correcting outliers in the data;

[0069] Data deduplication: Identify and remove duplicate data when acquiring data.

[0070] Data conversion: Convert data types to a uniform type.

[0071] The technical effect of the above content is: obtaining data through the API interface can ensure the standardization and consistency of the data, avoiding the format and structural differences that may be caused by direct access to the database, and the API interface allows customization of request parameters and return results, and can obtain specific data as needed, thereby improving the flexibility of data acquisition. At the same time, access permissions can be set to control data access, so as to ensure the security of the data. After the data is obtained, it is cleaned, deduplicated and format converted. Through data cleaning, missing values ​​caused by input errors can be checked and filled, and outliers in the data can be deleted or corrected. Deduplication can identify and delete duplicate data. Through format conversion, the data type can be converted into a unified type. Through the above-mentioned data processing, the data quality and reliability can be improved, thereby ensuring the accuracy of the calculation.

[0072] Calculation dimensions, including:

[0073] According to the granularity: it is divided into two dimensions: branches and subsidiaries and bases;

[0074] The base dimension calculates each scrap steel base separately to obtain the inventory turnover cycle of each base;

[0075] The branch and company dimension is calculated separately according to the branch and company and base type to obtain the inventory turnover cycle of all bases under the base type of the branch and company;

[0076] According to the time span: divided into daily dimension, monthly dimension and annual dimension;

[0077] The daily dimension counts the inventory and sales volume so far this month;

[0078] The monthly dimension counts the inventory and sales volume of the previous month;

[0079] The annual dimension counts inventory and sales volume so far this year.

[0080] The technical effect of the above content is: through calculation dimensions, the inventory turnover cycle of each branch, subsidiary and base can be displayed from different dimensions, thereby helping the head office and branches to improve inventory management efficiency and reduce inventory costs, so as to timely identify inventory turnover problems. The calculation dimension can be calculated according to granularity or according to time span, and according to granularity, it can be divided into two dimensions: branch, subsidiary and base, and according to time span, it can be divided into daily dimension, monthly dimension and annual dimension.

[0081] In this embodiment

[0082] like Figure 2 As shown in the figure, when the granularity is set to base granularity, the report will display the following columns: branch and subsidiary company name, base name, whether it is connected to the scale room, base category, and base inventory turnover days. The first four columns are inherent information of the base, and the calculation formula of the last column of base inventory turnover days under different time dimension conditions are:

[0083] Base daily dimension: Base inventory turnover days = number of days in the month of the query date * average inventory in the month of the query date / cumulative sales from the beginning of the month of the query date to the query date (including the query date);

[0084] Among them, the average inventory of the query date month = (the inventory at the beginning of the month of the query date + the daily inventory of the query date and before the query date of the month) / (the number of days in the query date + 1);

[0085] Base monthly dimension: Base inventory turnover days = 30*query monthly average inventory / query monthly sales;

[0086] Among them, monthly average inventory = (inventory at the beginning of the month + inventory at the end of the month) / 2;

[0087] Base annual dimension: Base inventory turnover days = query month number * 30 * average monthly inventory / cumulative sales volume up to the query month (including the current month);

[0088] Among them, the average monthly inventory quantity = (inventory quantity at the beginning of the year + inventory quantity at the end of the query month of the current year and each previous month) / (number of the query month + 1).

[0089] like Figure 3 As shown in the figure, when the granularity is set to the branch and company granularity, the report displays the branch and company names, as well as the average inventory of each base type under the account set. The calculation formula is as follows:

[0090] Daily dimension of branch and subsidiary: Inventory turnover days of branch and subsidiary = number of days in the month when the query date falls * sum of average inventory of all bases of the same type in the month when the query date falls / sum of cumulative sales of all bases of the same type from the beginning of the month when the query date falls to the query date (including the day);

[0091] The sum of the average inventory of all bases of this type on the query date of the month = (the sum of the inventory of all bases of this type at the beginning of the month on the query date + the sum of the daily inventory of all bases of this type on the query date and before the query date) / (number of days on the query date + 1);

[0092] Monthly dimension of branches and subsidiaries: Inventory turnover days of branches and subsidiaries = 30*sum of average inventory of all bases of the same type in that month / sum of sales of all bases of the same type in that month;

[0093] The sum of the average inventory of all bases of this type in that month = (the sum of the inventory of all bases of this type at the beginning of the month + the sum of the inventory of all bases of this type at the end of the month) / 2;

[0094] Branch and subsidiary annual dimension: Branch and subsidiary inventory turnover days = query month number * 30 * sum of average monthly inventory quantity of all bases of this type / sum of sales volume of all bases of this type from the year to the query month (including the month);

[0095] Among them, the sum of the average monthly inventory quantities of all bases of this type = (the sum of the inventory quantities of all bases of this type at the beginning of the year + the sum of the inventory quantities of all bases of this type at the end of the query month of the current year and previous months) / (number of query months + 1).

[0096] It should be noted that the base type column includes four basic types: central base, processing satellite base, storage satellite base and cooperative base, as well as four composite types: central + processing satellite base, central + satellite base, full-caliber base (including central base, processing satellite base, storage satellite base and cooperative base) and satellite base (including processing satellite base and storage satellite base);

[0097] It should be noted that all the above report query conditions include: the region where the branch or subsidiary is located, the branch or subsidiary name, the date (day dimension) / month (month or year dimension), whether to filter the bases that are not connected to the system scale room, and whether to filter the bases with zero inventory;

[0098] It should be noted that all the special data that cannot be calculated normally are displayed as follows: if the inventory is all 0 and the sales volume is 0 during the corresponding period, "-" is displayed; if the sales volume is 0 but the inventory is not all 0, "∞" is displayed; if the corresponding branch or subsidiary has no corresponding type of base (only for branch or subsidiary granularity), " / " is displayed.

[0099] It should be noted that for all the above values ​​(including special data that cannot be calculated normally), each value has corresponding detailed data, such as Figure 4 As shown, it shows the base information, base sales volume, inventory quantity at each time point involved in the above formula, and the number of days (day dimension) / months (year dimension) used in the calculation formula ( Figure 4The display is monthly dimension, so there is no such column), which is convenient for the head office to view the detailed information of each value and perform offline accounting.

[0100] Display the inventory turnover cycle of each branch, subsidiary and base in different dimensions, including the following steps:

[0101] Use data visualization tools to visualize data;

[0102] Provide detailed description of inventory turnover cycle for the data presented;

[0103] The inventory safety threshold is set in advance. If the inventory level in the displayed data is lower than the inventory safety threshold, the data will be marked in red as a warning.

[0104] All displayed data supports detailed information display. Through data display, you can query the inventory amount, sales volume and estimated turnover days of each branch, subsidiary and base at a specified historical time point, specifically:

[0105] Provide an interactive interface for users;

[0106] The interactive interface provides paging functionality so that users can quickly navigate between displayed data;

[0107] The interactive interface also provides filtering and sorting functions for users to query inventory turnover cycle status;

[0108] Users conduct in-depth analysis of the displayed data through the interactive interface.

[0109] The technical effect of the above content is: the calculated inventory turnover cycle is displayed in different dimensions, and the data is visualized (such as chart display) using data visualization tools, and a detailed description of the inventory turnover cycle is provided for the displayed data, and an interactive interface is provided for users to facilitate users to conduct in-depth analysis of the displayed data through the interactive interface. In this way, users can clearly understand the inventory turnover of each scrap steel industry base and take corresponding measures according to the actual situation. At the same time, an inventory safety threshold is set in advance. For inventory turnover cycles that exceed the safety range, the system will automatically mark a red warning, which can remind operational decision makers to pay attention to inventory turnover problems and take timely measures to solve the problems to avoid inventory backlogs or shortages. In the above method, the inventory turnover of each scrap steel industry base can be monitored in real time and adjusted according to actual conditions. In addition, procurement and production plans can be adjusted in time according to the changing trend of the inventory turnover cycle to ensure the continuity and stability of production.

[0110] Working principle: By obtaining the current and historical inventory information and historical sales volume from the business system and calculating the dimensions, the inventory turnover cycle of each branch, subsidiary and base can be displayed from different dimensions, thereby helping the head office and branches to improve inventory management efficiency, thereby reducing inventory costs, and timely identifying inventory turnover problems, thereby reducing inventory costs, and timely identifying inventory turnover problems. Data that exceeds the safety range will be marked with a red warning to remind operational decision makers to prepare early, avoid inventory backlogs or shortages, and ensure that product supply and demand are balanced.

[0111] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0112] While the embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that many changes, modifications, substitutions and variations can be made to the embodiments without departing from the principles and spirit of the invention.

Claims

1. A method for managing the inventory turnover cycle of a scrap steel industry base, characterized in that: The following steps are involved: Obtain data from business systems, including current and historical inventory information and historical sales; Based on the acquired data, the inventory turnover cycle of each branch, subsidiary and base can be displayed in different dimensions by calculating the dimensions; Pre-set inventory safety thresholds to determine whether the inventory turnover cycle exceeds the set inventory safety thresholds; Displays all data and supports displaying detailed information.

2. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 1, characterized in that: Obtaining data from the business system includes the following steps: Obtain current and historical inventory information and historical sales from the business system through API interfaces; Preprocess the acquired data, including data cleaning, deduplication and format conversion; Based on the acquired data, calculate the inventory turnover cycle of each branch, subsidiary and base.

3. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 2, characterized in that: The preprocessing is specifically as follows: Data cleaning: Check and fill missing values ​​caused by input errors, including using the mean, median or most frequent statistics to fill, or directly deleting data containing missing values, and deleting or correcting outliers in the data; Data deduplication: Identify and remove duplicate data when acquiring data. Data conversion: Convert data types to a uniform type.

4. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 1, characterized in that: Supports display of detailed information, including base name, branch or subsidiary to which the base belongs, base type, daily and monthly inventory information, and total sales volume within a time span.

5. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 1, characterized in that: The calculation dimensions include: According to the granularity: it is divided into two dimensions: branches and subsidiaries and bases; The base dimension calculates each scrap steel base separately to obtain the inventory turnover cycle of each base; The branch and company dimension is calculated separately according to the branch and company and base type to obtain the inventory turnover cycle of all bases under the base type of the branch and company; According to the time span: divided into daily dimension, monthly dimension and annual dimension; The daily dimension counts the inventory and sales volume so far this month; The monthly dimension counts the inventory and sales volume of the previous month; The annual dimension counts inventory and sales volume so far this year.

6. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 5, characterized in that: When the granularity is set to base granularity, the calculation formulas for base inventory turnover days under different time dimension conditions are: Base daily dimension: Base inventory turnover days = number of days in the month of the query date * average inventory in the month of the query date / cumulative sales from the beginning of the month of the query date to the query date; Among them, the average inventory of the query date month = (the inventory at the beginning of the month of the query date + the daily inventory of the query date and before the query date of the month) / (the number of days in the query date + 1); Base monthly dimension: Base inventory turnover days = 30*query monthly average inventory / query monthly sales; Among them, monthly average inventory = (inventory at the beginning of the month + inventory at the end of the month) / 2; Base annual dimension: Base inventory turnover days = query month number * 30 * average monthly inventory quantity / cumulative sales volume up to the query month of the year; Among them, the average monthly inventory quantity = (inventory quantity at the beginning of the year + inventory quantity at the end of the query month of the current year and each previous month) / (number of the query month + 1).

7. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 5, characterized in that: When the granularity is set to the branch and company granularity, the report displays the branch and company names, as well as the average inventory of each base type under the account set. The calculation formula is as follows: Daily dimension of branches and subsidiaries: Inventory turnover days of branches and subsidiaries = number of days in the month when the query date is in the current month * sum of average inventory of all bases of the same type in the current month when the query date is in the current month / sum of cumulative sales of all bases of the same type from the beginning of the month when the query date is in the current month to the query date; The sum of the average inventory of all bases of this type on the query date of the month = (the sum of the inventory of all bases of this type at the beginning of the month on the query date + the sum of the daily inventory of all bases of this type on the query date and before the query date) / (number of days on the query date + 1); Monthly dimension of branches and subsidiaries: Inventory turnover days of branches and subsidiaries = 30*sum of average inventory of all bases of the same type in that month / sum of sales of all bases of the same type in that month; The sum of the average inventory of all bases of this type in that month = (the sum of the inventory of all bases of this type at the beginning of the month + the sum of the inventory of all bases of this type at the end of the month) / 2; Branch and subsidiary annual dimension: Branch and subsidiary inventory turnover days = query month number * 30 * sum of monthly average inventory quantity of all bases of this type / sum of sales volume of all bases of this type up to the query month in that year; Among them, the sum of the average monthly inventory quantities of all bases of this type = (the sum of the inventory quantities of all bases of this type at the beginning of the year + the sum of the inventory quantities of all bases of this type at the end of the query month of the current year and previous months) / (number of query months + 1).

8. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 1, characterized in that: The inventory turnover cycle of each branch, subsidiary and base is displayed in different dimensions, including the following steps: Use data visualization tools to visualize data; Provide detailed description of inventory turnover cycle for the data presented; The inventory safety threshold is set in advance. If the inventory level in the displayed data is lower than the inventory safety threshold, the data will be marked in red as a warning.

9. The method for managing inventory turnover cycle of a scrap steel industry base according to claim 1, characterized in that: All displayed data supports detailed information display. Through data display, you can query the inventory amount, sales volume and estimated turnover days of each branch, subsidiary and base at a specified historical time point, specifically: Provide an interactive interface for users; The interactive interface provides paging functionality for users to quickly navigate between displayed data; The interactive interface also provides filtering and sorting functions for users to query inventory turnover cycle status; Users conduct in-depth analysis of the displayed data through the interactive interface.