JP2015114787A - Information processing device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To present information capable of comprehensive analysis of a stock level and a delivery date observance rate in order for the delivery date observance rate to be reflected in inventory management, production management, shipment management, etc.SOLUTION: A months in stock storage unit 104 stores an aggregate stock level that is an aggregated stock level and a reference stock level that is a stock level referenced as standard. A service index storage unit 105 stores an aggregate delivery date observance rate that is an aggregated delivery date observance rate and a delivery date observance rate threshold that is a threshold for the delivery date observance rate. A divergence rate calculation unit 106 calculates a rate of divergence of the aggregate stock level from the reference stock level as a stock level divergence rate, calculates a rate of divergence of the aggregate delivery date observance rate from the delivery date observance rate threshold as a delivery date observance rate divergence rate, calculates a multiplication value of the stock level divergence rate and the delivery date observance rate divergence rate, and outputs the calculated multiplication value.

Description

  The present invention relates to a technology for utilizing product inventory information.

Sales / inventory performance of sales companies / agencies is often managed as data for each location, and the person in charge collects a great deal of time and effort. There are cases where it is not used effectively for production management, shipping management, and the like.
In order to deal with such problems, in the conventional technology, the distribution inventory from the factory to the store and the total inventory quantity of the sales inventory are reflected in the production adjustment (for example, Patent Document 1), or the ratio of the inventory quantity to the reference inventory quantity. It has been utilized for inventory reduction, such as displaying a shortage alarm or an emergency alarm (for example, Patent Document 2).
In addition, it has been utilized for grasping demand trends, such as correcting the deviation of the moving average of sales results of sales companies / agents as an up / down demand (for example, Patent Document 3 and Patent Document 4).

JP 2003-029816 A JP 2001-0273021 A JP 2003-312849 A JP 2004-013532 A

In the prior art, the focus is on utilizing the collected inventory information and the like.
On the other hand, an important factor to be considered in increasing customer satisfaction is the delivery rate compliance rate.
In the conventional technology, the collected inventory information can be reflected in inventory management, production management, shipping management, etc., but it lacks the viewpoint of reflecting the on-time delivery rate and cannot fully pursue customer satisfaction. It was.

  Further, in the prior art, an appropriate alarm according to the degree of inventory shortage at the sales base has not been presented.

The present invention has been made in view of such circumstances, and in order to reflect the delivery date compliance rate in inventory management, production management, shipping management, etc., information capable of comprehensively analyzing the inventory level and the delivery date compliance rate is provided. The main purpose is to present it.
In addition, the main purpose is to present an appropriate alarm according to the degree of inventory shortage at the sales base.

An information processing apparatus according to the present invention includes:
A first storage unit that stores an aggregated inventory level that is an aggregated inventory level and a reference inventory level that is a reference inventory level;
A second storage unit that stores a total delivery date compliance rate that is the aggregated delivery date compliance rate and a delivery date compliance rate threshold that is a threshold of the delivery date compliance rate;
The deviation rate of the aggregated inventory level from the reference inventory level is calculated as an inventory level deviation rate, the deviation rate of the aggregated delivery date compliance rate from the delivery date compliance rate threshold is calculated as the delivery date compliance rate deviation rate, and the inventory level A divergence rate calculation unit that calculates a multiplication value of the divergence rate and the delivery date observance rate divergence rate and outputs the calculated multiplication value is provided.

An information processing apparatus according to the present invention includes:
For a plurality of sales bases, for each sales base, a storage unit that stores a total stock level that is a total stock level and a reference stock level that is a base stock level;
An alarm output unit that evaluates the degree of shortage of the aggregate inventory level at the sales base with respect to the reference inventory level, selects one of the alarms of multiple stages according to the evaluation result, and outputs the selected alarm; It is characterized by having.

In the present invention, as information that can comprehensively analyze the inventory level and the due date compliance rate, the inventory level deviation rate that is the deviation rate from the reference stock level of the aggregate stock level and the due date compliance rate threshold of the aggregate due date compliance rate A product of the delivery rate compliance rate deviation rate, which is a divergence rate, is output, and the delivery date compliance rate can be reflected in inventory management, production management, shipping management, and the like.
Further, in the present invention, the degree of shortage of the total inventory level at the sales base with respect to the reference stock level is evaluated, and an alarm at any one of a plurality of stages is output according to the evaluation result. It is possible to present an appropriate alarm according to the inventory shortage degree.

2 is a diagram illustrating a configuration example of an information processing device according to Embodiment 1. FIG. FIG. 3 is a flowchart showing an operation example of the information processing apparatus according to the first embodiment. FIG. 3 illustrates a configuration example of an information processing apparatus according to a second embodiment. FIG. 10 illustrates a configuration example of an information processing apparatus according to a third embodiment. FIG. 10 is a flowchart showing an operation example of the information processing apparatus according to the third embodiment. FIG. 3 is a diagram illustrating a hardware configuration example of the information processing apparatus according to the first to third embodiments.

Embodiment 1 FIG.
FIG. 1 shows a configuration example of an information processing apparatus 100 according to the present embodiment.

In FIG. 1, the sales record accumulating unit 101 stores the collected sales record.
The sales record accumulating unit 101 stores, for example, sales results for each sales base and each product for a plurality of sales bases (agents / sales companies) and a plurality of products.
The sales performance at each sales base is the total number of sales of all products sold at the target sales base.
The sales performance by product is the total number of sales of the target product at all sales bases.

The stock record accumulating unit 102 stores the summed stock record.
The inventory record storage unit 102 stores, for example, the aggregated inventory record for each sales base and each product.
The actual inventory at each sales base is the total number of all products in stock at the target sales base.
In addition, the actual inventory by product is the total number of inventory at all sales bases of the target product.

The inventory months calculation unit 103 calculates the number of months of inventory using the sales results of the sales results storage unit 101 and the inventory results of the inventory results storage unit 102.
The number of months of inventory is a value obtained by dividing the actual inventory by the actual sales.
The inventory month calculation unit 103 calculates the inventory months for each sales base and each product, for example.

The inventory month number storage unit 104 stores the total number of inventory months calculated by the inventory month number calculation unit 103 (an example of the total inventory level).
Further, the inventory month number storage unit 104 stores a reference inventory month number (an example of a reference inventory level) that is an appropriate inventory month number.
The inventory month number storage unit 104 stores, for example, the reference inventory month number for each sales base and each product.
The reference inventory months are calculated by the following formula, for example.
Standard inventory months = standard inventory ÷ sales performance Standard inventory = 1/2 average + safety factor x √ (supply lead time) x standard deviation In the above formula, for example, the standard inventory and sales inventory use the average value of 6 months .
The standard deviation is, for example, a standard deviation in sales performance for 6 months.
The 1/2 average is 1/2 of the average value of sales performance (for example, 6 months).
The reference inventory month may be calculated in the information processing apparatus 100 (for example, the inventory month calculation unit 103) or may be calculated by another system.
Note that the inventory month storage unit 104 corresponds to an example of a first storage unit.

The service index storage unit 105 stores a total delivery date compliance rate that is a delivery date compliance rate that is aggregated by another system, and a delivery date compliance rate threshold that is a threshold for the delivery date compliance rate.
The service index storage unit 105 stores, for example, a total delivery date compliance rate and a delivery date compliance rate threshold for each sales base and each product.
The delivery date compliance rate targeted by the service index storage unit 105 may be any of the required delivery date compliance rate, the response delivery date compliance rate, and the delivery date ± χ day compliance rate.
The delivery time compliance rate is also called a service index.
The service index storage unit 105 is an example of a second storage unit.

The divergence rate calculation unit 106 calculates the divergence rate of the total inventory months from the standard inventory months as the inventory level divergence rate, and also calculates the divergence rate of the aggregate delivery date compliance rate from the delivery date compliance rate threshold. Calculate as
The divergence rate calculation unit 106 calculates a product of the inventory level divergence rate and the delivery date compliance rate divergence rate as an overall divergence rate, and outputs the calculated overall divergence rate from the display unit 107.
The divergence rate calculation unit 106 calculates, for example, an inventory level divergence rate and a delivery date observance rate divergence rate for each sales base and each product, and calculates a total divergence rate for each sales base and each product.
Further, the divergence rate calculation unit 106 arranges the total divergence rates for each sales base and each product in descending order (in descending order of absolute value), and outputs them from the display unit 107.
The total deviation rate indicates that the larger the absolute value is, the more the number of months of inventory and the due date compliance rate are different from the appropriate values.

The display unit 107 displays the total deviation rates calculated by the deviation rate calculation unit 106 in descending order.
The input unit 108 receives input from the user of the information processing apparatus 100.

Next, an operation example of the information processing apparatus 100 will be described with reference to FIG.
In the following, an example of calculating the total deviation rate for each product for each sales base will be described.
Further, in the following, at the start of the flow of FIG. 2, the total inventory months for each sales base for the target product is calculated by the inventory months calculation unit 103 and stored in the inventory months storage unit 104. Shall.
Further, it is assumed that the inventory month storage unit 104 also stores the reference inventory month for each sales base for the target product.
Furthermore, it is assumed that the service index storage unit 105 stores a total delivery date compliance rate for each sales base for the target product, and also stores a delivery date compliance rate threshold value.
For simplicity of explanation, it is assumed that a common threshold value is applied to all the bases as the delivery date compliance rate threshold value.

  First, the divergence rate calculation unit 106 reads out the total inventory months and the standard inventory months from the inventory month storage unit 104 for each sales base for the product to be calculated, and for each sales base for the calculation target product. Are read from the service index storage unit 105 (S201).

Next, the divergence rate calculation unit 106 calculates an inventory level divergence rate from the total inventory months read in S201 and the reference inventory months (S202).
Specifically, the deviation rate calculation unit 106 calculates the inventory level deviation rate by the following equation.
Inventory level deviation rate = (Total number of months of inventory-Base number of months in stock) ÷ Number of base stock months

Next, the deviation rate calculation unit 106 calculates a delivery date compliance rate deviation rate from the total delivery date compliance rate read in S201 and a delivery date compliance rate threshold (S203).
Specifically, the deviation rate calculation unit 106 calculates the delivery date compliance rate deviation rate by the following equation.
Delivery date compliance rate deviation rate = (delivery date compliance rate threshold-aggregate delivery date compliance rate) ÷ delivery date compliance rate threshold

  Next, the divergence rate calculation unit 106 calculates the total divergence rate by multiplying the inventory level divergence rate calculated in S202 by the delivery date observance rate divergence rate calculated in S203 (S204).

Next, the divergence rate calculation unit 106 determines whether or not the total divergence rate has been calculated for all sales bases (S205).
When there is a sales base that has not calculated the total deviation rate (NO in S205), the processing from S201 is repeated.
In the second and subsequent S201, the delivery date compliance rate threshold value does not have to be read.
When the total deviation rate is calculated for all sales bases (YES in S205), the deviation rate calculation unit 106 outputs the total deviation rate for each sales base to the display unit 107 in descending order. 107 displays the total deviation rate for each sales base in descending order.

The user of the information processing apparatus 100 can take measures such as preferentially shipping products from a sales base with a high total deviation rate in the shipment plan with reference to the total deviation rate displayed on the display unit 107.
Further, when calculating the total deviation rate for each product, the user of the information processing apparatus 100 refers to the total deviation rate displayed on the display unit 107, and gives priority to products with a high total deviation rate in the production plan. It is possible to take measures such as production.
Further, when calculating the total deviation rate for each sales base, the user of the information processing apparatus 100 refers to the total deviation rate displayed on the display unit 107, and sells products with a low product inventory and a low delivery date compliance rate. Bases can be extracted, and measures such as preferential shipment and production of products for sales bases with a high overall deviation rate can be taken.
Furthermore, the total deviation rate may be calculated for each product category such as a common product group, the total deviation rate may be calculated for each region, or the total deviation rate may be calculated by arbitrarily combining the above factors. Good.

  As described above, the information processing apparatus 100 according to the present embodiment has the inventory level deviation rate that is the deviation rate of the aggregated inventory level from the reference inventory level and the delivery date that is the deviation rate of the aggregated delivery date compliance rate from the delivery date compliance rate threshold. Since the total deviation rate, which is a product of the compliance rate deviation rate, can be presented to the user, inventory management, production management, shipping management, etc. reflecting the delivery date compliance rate can be performed.

Embodiment 2. FIG.
FIG. 3 shows a configuration example of the information processing apparatus 100 according to the present embodiment.
In FIG. 3, elements other than the alarm output unit 109 and the moving average calculation unit 110 are the same as those shown in FIG. 1 except for the points described below.

The alarm output unit 109 compares the number of inventory months stored in the inventory month number storage unit 104 with a predetermined lower limit threshold and upper limit threshold, and notifies an alarm that the inventory is insufficient or an excess inventory. An alarm is output from the display unit 107.
The alarm output unit 109 calculates an upper threshold and a lower threshold based on the long-term moving average of sales results.
Then, the alarm output unit 109 determines whether or not the moving average difference that is the difference between the short-term moving average and the long-term moving average of the sales results is within the range between the upper limit threshold and the lower limit threshold, and the moving average difference is the upper limit. When the value is outside the range between the threshold value and the lower limit threshold value, an alarm notifying that the sales trend has changed is output from the display unit 107.
As shown in the first embodiment, the alarm output unit 109 may be out of stock or overstock for each sales base, each product, each product category, each region, or any combination thereof. And whether or not the sales trend has changed.

The moving average calculation unit 110 calculates a long-term moving average and a short-term moving average of sales results stored in the sales result accumulation unit 101.
As shown in the first embodiment, the moving average calculation unit 110 also has a long-term moving average and a short-term moving average for each sales base, each product, each product category, each region, and any combination thereof. Is calculated.
The long-term moving average is, for example, 6 months, and the short-term moving average is, for example, 1 month.

In the present embodiment, the inventory month storage unit 104, in addition to the total inventory months and the reference inventory months described in the first embodiment, is a lower threshold threshold month number (months lower than the reference inventory months) ( An example of a lower threshold inventory level) and an upper threshold inventory month (an example of an upper threshold inventory level) having a number of months higher than the reference inventory month are stored.
The lower threshold inventory months and the upper threshold inventory months are calculated by, for example, the following equations.
Lower threshold inventory months = (reference inventory-1/2 average) / sales performance Upper threshold inventory months = (reference inventory + 1/2 average) / sales performance This is the same as that described in the first embodiment.
Also, the lower threshold inventory months and the upper threshold inventory months may be calculated in the information processing apparatus 100 or may be calculated by another system.

Next, the operation of the alarm output unit 109 will be described.
First, an example of outputting an alarm for notifying that inventory is insufficient and an alarm for notifying that inventory is excessive will be described.
Hereinafter, an example in which the alarm output unit 109 determines whether the inventory is insufficient or excessive in units of products will be described.
In the following description, it is assumed that the total number of months of inventory in product units, the lower limit threshold inventory months, and the upper threshold threshold inventory months are stored in the inventory month storage unit 104.

The alarm output unit 109 reads the total inventory months, lower threshold inventory months, and upper threshold inventory months of the target product from the inventory month storage unit 104, and the product is out of stock according to the following criteria. Or overstock.
Insufficient inventory: Total inventory months <Lower threshold inventory months Excess inventory: Upper threshold inventory months <Total inventory months And if the alarm output unit 109 determines that the inventory is insufficient, the inventory of the product is insufficient. Output an alarm to notify you.
Further, when the alarm output unit 109 determines that the stock is excessive, the alarm output unit 109 outputs an alarm for notifying that the stock of the product is excessive from the display unit 107.

Next, an example in which the alarm output unit 109 notifies a change in sales trend using a long-term moving average and a short-term moving average will be described.
Here, an example in which the alarm output unit 109 determines a change in sales trend for each product will be described.

The alarm output unit 109 inputs a long-term moving average value and a short-term moving average value of the sales performance of the target product from the moving average calculation unit 110.
Next, the alarm output unit 109 calculates an upper limit threshold and a lower limit threshold based on the long-term moving average value.
The upper limit threshold and the lower limit threshold are calculated by the following formulas, for example.
Upper limit threshold = long-term moving average + safety coefficient × standard deviation Lower limit threshold = long-term moving average−safety coefficient × standard deviation In the above formula, the safety coefficient may be specified by the user of the information processing apparatus 100 using the input unit 108, for example. However, it may be stored in any storage area in the information processing apparatus 100.
The standard deviation is a standard deviation of a past certain period of sales performance (for example, 12 months).
Next, the alarm output unit 109 calculates a moving average difference by the following equation.
Moving average difference = Short-term moving average−Long-term moving average Next, the alarm output unit 109 determines whether or not there is a change in sales trend based on the following criteria.
If the following conditions are satisfied, it is determined that there is no change in the sales trend, and if the following conditions are not satisfied, it is determined that the sales trend has changed.
Lower limit threshold <Moving average difference <Upper limit threshold When the moving average difference falls outside the above range (when there is a change in sales trend), the alarm output unit 109 uses the following formula to calculate the long-term movement of the short-term moving average: The deviation rate from the average (an index indicating an increase / decrease tendency exceeding the steady state) is calculated.
Deviation rate = moving average difference ÷ (safety factor × standard deviation)
In the above equation, the safety factor and the standard deviation are the same as those used for calculating the upper threshold and the lower threshold.
Then, the alarm output unit 109 outputs the calculated divergence rate from the display unit 107 together with an alarm notifying the change of the sales trend.

  As described above, in addition to the effects of the first embodiment, the information processing apparatus 100 according to the present embodiment can notify inventory shortage and excess inventory, and can notify changes in sales trends. Inventory management, production management, shipping management, etc. can be performed effectively.

Embodiment 3 FIG.
FIG. 4 shows a configuration example of the information processing apparatus 100 according to the present embodiment.
The sales record storage unit 101, the inventory record storage unit 102, the inventory month number calculation unit 103, the display unit 107, and the input unit 108 are the same as those described in the first embodiment.
In the present embodiment, the alarm output unit 109 evaluates the degree of shortage of the total inventory months stored in the inventory months storage unit 104 with respect to the reference inventory months, and, depending on the evaluation result, alarms of multiple levels. Any one of the alarms is selected, and the selected alarm is output from the display unit 107.
For example, the alarm output unit 109 evaluates the degree of shortage of the total inventory months for each sales base of a specific product with respect to the reference inventory months.
More specifically, as shown in FIG. 5, the alarm output unit 109 evaluates the degree of shortage of the total inventory months relative to the reference inventory months.
Hereinafter, the operation of the alarm output unit 109 will be described with reference to FIG.

First, the alarm output unit 109 counts the number of bases that are out of stock among the main sales bases for the target product, and sets the number of points (S501).
That is, the alarm output unit 109 compares the total inventory months with the standard inventory months for each sales base selected from the plurality of sales bases as the main sales base, The number of bases that does not satisfy the reference inventory number of months is obtained, and the number of points corresponding to the number of bases is set (first analysis process).
The score is set based on the following criteria, for example.
When the number of shortage bases exceeds 1/3 of all major sales bases: 1.0 points When the number of shortage bases exceeds 1/2 of all main sales bases: 1.5 points The number of shortage bases is 2 of all main sales bases / 3 over: 2.0 points

Next, the alarm output unit 109 counts the number of bases that are out of stock among all sales bases for the target product, and sets the number of points (S502).
That is, for all sales bases, the alarm output unit 109 compares the total inventory months with the standard inventory months for each sales base to obtain the number of bases whose total inventory months are less than the standard inventory months, The number of points corresponding to the number of bases is set (second analysis process).
The score is set based on the following criteria, for example.
When the number of shortage bases exceeds 1/3 of all sales bases: 1.0 points When the number of shortage bases exceeds 1/2 of all sales bases: 1.5 points The number of shortage bases is 2/3 of all sales bases When exceeding: 2.0 points

Next, the alarm output unit 109 evaluates the inventory shortage status for each product and sets the score (S503).
That is, the alarm output unit 109 compares the total of the total inventory months at all the sales bases with the total of the reference stock numbers at all the sales bases, and sets a score according to the comparison result (third analysis process). .
The score is set based on the following criteria, for example.
Aggregate total number of months of inventory <Total number of standard inventory months: 2.0 points Aggregate total number of inventory months ≧ Total number of standard inventory months: 0.0 points

Next, the alarm output unit 109 adds the points set in S501 to S503, and selects an alarm according to the addition result (S504).
For example, if the addition result is three points, a priority notification alarm for notifying that the product should be preferentially produced for other products and shipped should be selected.
For example, if the addition result is four points, an emergency notification alarm for notifying that the product should be urgently produced and shipped is selected.
Further, for example, if the addition result is 5 points, a danger stage notification alarm for notifying that the product is in a very dangerous stage is selected.

  Finally, the alarm output unit 109 outputs the alarm selected in S504 from the display unit 107 (S505).

Although FIG. 5 shows an example in which three analysis processes S501, S502, and S503 are performed, an alarm may be selected by performing only one or two of these analysis processes.
In the above, the alarm is selected using the inventory information for each sales base for each product, but the alarm may be selected using the inventory information for each sales base for each product category.

  As described above, according to the information processing apparatus 100 according to the present embodiment, the degree of inventory shortage (severity) is evaluated using the collected inventory information, and an appropriate alarm is presented according to the evaluation result. Can do.

As mentioned above, although embodiment of this invention was described, you may implement in combination of 2 or more among these embodiment.
Alternatively, one of these embodiments may be partially implemented.
Alternatively, two or more of these embodiments may be partially combined.
In addition, this invention is not limited to these embodiment, A various change is possible as needed.

Finally, a hardware configuration example of the information processing apparatus 100 shown in the first to third embodiments will be described with reference to FIG.
The information processing apparatus 100 is a computer, and each element of the information processing apparatus 100 can be realized by a program.
As a hardware configuration of the information processing apparatus 100, an arithmetic device 901, an external storage device 902, a main storage device 903, a communication device 904, and an input / output device 905 are connected to a bus.

The arithmetic device 901 is a CPU (Central Processing Unit) that executes a program.
The external storage device 902 is, for example, a ROM (Read Only Memory), a flash memory, or a hard disk device.
The main storage device 903 is a RAM (Random Access Memory).
The communication device 904 is, for example, a NIC (Network Interface Card).
The input / output device 905 is, for example, a mouse, a keyboard, a display device, or the like.
The sales record storage unit 101, the inventory record storage unit 102, the inventory month storage unit 104, and the service index storage unit 105 are realized by, for example, the external storage device 902.

The program is normally stored in the external storage device 902, and is loaded into the main storage device 903 and sequentially read into the arithmetic device 901 and executed.
The program is a program that realizes the functions described as “˜unit” (excluding “˜accumulation unit” and “˜storage unit”, the same applies hereinafter) shown in FIGS.
Further, an operating system (OS) is also stored in the external storage device 902. At least a part of the OS is loaded into the main storage device 903, and the arithmetic device 901 executes the OS while FIG. 1, FIG. 3, FIG. The program which implement | achieves the function of "-part" shown in 4 is executed.
In the description of the first to third embodiments, “determination of”, “determination of”, “extraction of”, “calculation of”, “calculation of”, “setting of”, “ Information, data, signal values, and variable values indicating the results of the processing described as “Comparison of”, “Selection of”, “Generation of”, “Input of”, “Output of”, etc. It is stored as a file in the device 903.

  6 is merely an example of the hardware configuration of the information processing apparatus 100, and the hardware configuration of the information processing apparatus 100 is not limited to the configuration illustrated in FIG. Also good.

  DESCRIPTION OF SYMBOLS 100 Information processing apparatus, 101 Sales performance accumulation | storage part, 102 Inventory performance accumulation | storage part, 103 Inventory month number calculation part, 104 Inventory month number storage part, 105 Service index storage part, 106 Deviation rate calculation part, 107 Display part, 108 Input part 109 alarm output unit, 110 moving average calculation unit.

Claims (10)

A first storage unit that stores an aggregated inventory level that is an aggregated inventory level and a reference inventory level that is a reference inventory level;
A second storage unit that stores a total delivery date compliance rate that is the aggregated delivery date compliance rate and a delivery date compliance rate threshold that is a threshold of the delivery date compliance rate;
The deviation rate of the aggregated inventory level from the reference inventory level is calculated as an inventory level deviation rate, the deviation rate of the aggregated delivery date compliance rate from the delivery date compliance rate threshold is calculated as the delivery date compliance rate deviation rate, and the inventory level An information processing apparatus comprising: a divergence rate calculation unit that calculates a multiplication value of a divergence rate and the delivery date observance rate divergence rate and outputs the calculated multiplication value. The first storage unit
For a plurality of products, for each product, store the aggregate stock level and the base stock level,
The second storage unit is
For each of the plurality of products, for each product, store the total delivery date compliance rate and the delivery date compliance rate threshold,
The deviation rate calculation unit
For each of the plurality of products, for each product, calculate the inventory level deviation rate and the delivery date compliance rate deviation rate, and calculate a product of the inventory level deviation rate and the delivery date compliance rate deviation rate,
The information processing apparatus according to claim 1, wherein the multiplication value for each product is output in descending order or ascending order. The first storage unit
For a plurality of product categories, for each product category, store the aggregate stock level and the reference stock level,
The second storage unit is
For each of the plurality of product categories, for each product category, store the aggregate delivery date compliance rate and the delivery date compliance rate threshold;
The deviation rate calculation unit
For each of the plurality of product categories, for each product category, calculate the inventory level deviation rate and the delivery date compliance rate deviation rate, and calculate a product of the inventory level deviation rate and the delivery date compliance rate deviation rate,
The information processing apparatus according to claim 1, wherein multiplication values for each product category are output in descending order or ascending order. The first storage unit
For a plurality of sales bases, for each sales base, store the aggregate stock level and the reference stock level,
The second storage unit is
For each of the plurality of sales bases, for each sales base, store the total delivery date compliance rate and the delivery date compliance rate threshold,
The deviation rate calculation unit
For each of the plurality of sales bases, for each sales base, calculate the inventory level deviation rate and the delivery date compliance rate deviation rate, and calculate a product of the inventory level deviation rate and the delivery date compliance rate deviation rate,
The information processing apparatus according to claim 1, wherein the multiplication value for each sales base is output in descending order or ascending order. The deviation rate calculation unit
The inventory level deviation rate is calculated by (aggregated inventory level−reference inventory level) ÷ reference inventory level,
The information processing apparatus according to claim 1, wherein the delivery date compliance rate deviation rate is calculated by (delivery date compliance rate threshold−total delivery date compliance rate) ÷ delivery date compliance rate threshold. The first storage unit
A lower threshold inventory level that is lower than the reference inventory level and an upper threshold inventory level that is higher than the reference inventory level;
The information processing apparatus further includes:
The aggregate inventory level is compared with the lower threshold inventory level and the upper threshold inventory level, and when the aggregate inventory level falls below the lower threshold inventory level, an alarm is sent to notify that the inventory is insufficient, The information processing apparatus according to claim 1, further comprising: an alarm output unit that outputs an alarm notifying that the inventory is excessive when a total inventory level exceeds the upper limit threshold inventory level. The information processing apparatus further includes:
Based on the long-term moving average of sales results, calculate the upper and lower thresholds,
Determining whether or not a moving average difference that is a difference between the short-term moving average of the sales results and the long-term moving average is within the range between the upper limit threshold and the lower limit threshold;
2. The alarm output unit according to claim 1, further comprising: an alarm output unit that outputs an alarm notifying that a sales trend has changed when the moving average difference is outside the range between the upper limit threshold and the lower limit threshold. Information processing device. The alarm output unit
When the moving average difference is outside the range between the upper limit threshold and the lower limit threshold, the deviation rate of the short-term moving average from the long-term moving average is calculated, and the calculated deviation rate is output together with the alarm. The information processing apparatus according to claim 7. For a plurality of sales bases, for each sales base, a storage unit that stores a total stock level that is a total stock level and a reference stock level that is a base stock level;
An alarm output unit that evaluates the degree of shortage of the aggregate inventory level at the sales base with respect to the reference inventory level, selects one of the alarms of multiple stages according to the evaluation result, and outputs the selected alarm; An information processing apparatus comprising: The alarm output unit
For the sales bases selected from among the plurality of sales bases, for each sales base, the total stock level is compared with the reference stock level to derive the number of bases whose total stock level is less than the reference stock level. Analysis processing of
A second analysis process for deriving the number of sites whose total inventory level is less than the standard inventory level by comparing the total inventory level and the standard inventory level for each of the plurality of sales sites;
Performing at least one of the third analysis processes for comparing the total of the inventory levels of the plurality of sales bases and the total of the reference inventory levels of the sales bases to The information processing apparatus according to claim 9, wherein a deficiency degree is evaluated.

Images