JP4845940B2 - Information processing apparatus and information processing method - Google Patents

Description

  The present invention relates to an information processing apparatus and an information processing method for ordering items.

が一般的である（非特許文献１）。 In general inventory management methods (periodic ordering method, quantitative ordering method, etc.), it is necessary to have a safety stock that absorbs variations in daily shipments and sales. The safety stock amount means “a margin to absorb the fluctuation of the shipping amount”. The daily order quantity is calculated from the demand quantity during the item procurement period and the safety stock quantity.
As a safety stock calculation method,

Is common (Non-patent Document 1).

  The safety factor is determined by the allowable shortage rate (allowable shortage rate). The larger the safety factor, the smaller the shortage rate. On the other hand, the ratio that can respond to customer orders without causing out of stock is called the service rate, where the service rate is γ and the allowable shortage rate is β, the relationship between the service rate and the allowable shortage rate is “γ = 1-β ". FIG. 20 is a diagram illustrating the relationship among the safety stock amount, the service rate, and the allowable shortage rate. The procurement period is a period from when an order is placed until an item arrives.

ここで調達期間の単位は需要予測の予測単位期間とする。即ち需要予測を日時で行う場合は日、週次に行う場合は週、月次に行う場合は月が単位となる。 In addition, when appropriate demand forecast is possible, the variation in demand forecast error is smaller than the variation in demand amount itself, so the same shortage rate can be realized with a smaller amount of safety stock. (Patent Document 1). In this case, the safety stock quantity is calculated as follows.

Here, the unit of the procurement period is the forecast unit period of the demand forecast. That is, when demand prediction is performed by date and time, the unit is day, when weekly it is performed weekly, and when it is performed monthly, month is the unit.

Thus, the stock quantity and the order quantity for each item are managed by the above-described stock management system. On the other hand, when ordering items, there is a case where a purchase budget is set.
For example, when a purchase budget is set for each group to which an item belongs, it is necessary to suppress the total order amount of items belonging to this group to the purchase budget amount of the group. Therefore, work for adjusting the order amount for each item calculated by the above-described inventory management method occurs. Conventionally, this adjustment work has been performed manually by humans based on experience and the like, such as adjusting from an item with a large order amount or adjusting from an item with a small amount of demand.

Japanese Patent No. 3260333 “Appropriate inventory approach and method” by Takao Suguro, Nikkan Kogyo Shimbun

  However, if a person adjusts the order amount for each item, the service rate for each item may vary. The variation in the service rate for each item means that the sales opportunity loss and the excess inventory vary for each item. For example, if the purchase budget and service rate are set for each group, adjusting the order amount of items belonging to the group may result in an out-of-stock frequency or an excessive amount of inventory depending on the item. is there.

  The present invention has been made in view of such problems, and by adjusting the safety stock of each item, the order amount or order quantity for each item is adjusted, and the item service rate is made substantially constant. It is an object of the present invention to provide an information processing apparatus and an information processing method for ordering support that make it possible to place an order.

Therefore, the information processing apparatus according to the present invention is an information processing apparatus that performs ordering support for adjusting the order quantity of an item by adjusting a safety stock that is a reference for determining the order quantity of the item. , safety stock of the item, and storage means for storing unit prices, the first setting means for setting a purchase budget put into stocking the plurality of items, the items that are stored in the storage means First calculation means for calculating a safety stock adjustment ratio for each item according to the safety stock value before adjustment calculated by the safety stock and the unit price, and the purchase budget amount set by the first setting means ; Second for calculating the adjusted safety stock of the item according to the safety stock of the item and the adjustment ratio calculated by the first calculating means for each item stored in the storage means; Wherein a calculating unit, for each of the items, in that it comprises a third calculation means for calculating the adjusted order quantity of the item by using the adjusted safety stock of the said items calculated by the second calculating means And

  By adopting such a configuration, it is possible to adjust the safety stock related to the order quantity so that the total order amount of the item matches the total purchase amount. The service rate of each item can be made substantially constant.

  The present invention may be an information processing method, a program, and a storage medium.

  According to the present invention, an information processing apparatus and information for performing ordering support for adjusting the order amount or the order amount for each item by adjusting the safety stock and making the service rate of items belonging to the group substantially constant A processing method can be provided.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a diagram illustrating an example of a functional configuration of an inventory management apparatus that is an example of an information processing apparatus (computer). The item attribute DB stores information such as attribute values related to various items such as products as shown in FIG.
FIG. 2 is a diagram illustrating an example of setting information registered in the item attribute DB. As shown in FIG. 2, unit price, inventory lot, item classification information (major classification, middle classification, small classification), average sales amount, etc. are registered as item attributes. Here, the stock lot is a numerical value indicating an order quantity unit when ordering the item and a delivery quantity unit when leaving the item. Item classification codes are registered in the product classification information (major classification, medium classification, small classification). For example, the major classification code 10 is a code indicating television, the middle classification code 10 in the major classification code 10 is a code indicating liquid crystal television, and the minor classification code 10 in the major classification code 10 and middle classification code 10 has a screen size of 30 inches to 40 inches. It is a condition such as a code indicating. The average sales volume is, for example, a monthly average sales volume. The configuration of the item attribute DB is not limited to that shown in FIG. 2, and other items such as average sales frequency may be additionally registered in the item attribute DB.
Returning to the description of FIG. 1 again, the order quantity DB stores the order quantity, safety stock quantity, and purchase budget before adjusting the purchase budget by item (inventory management unit) and by period (monthly, weekly, daily, etc.). This database stores adjusted order quantities and safety stock quantities. FIG. 3 is a diagram illustrating an example of setting information registered in the order quantity DB before the purchase budget adjustment. FIG. 4 is a diagram showing an example of setting information registered in the order quantity DB after performing the safety stock adjustment process. Details of the safety stock adjustment process will be described later with reference to FIG.

Returning to the description of FIG. 1 again, the group information setting unit 101 sets items for grouping to be purchased budget management targets. The group information setting unit 101 includes a display unit and an input receiving unit. The display unit of the group information setting unit 101 displays a screen such as that shown in FIG. 7 described later on the display unit 207 described later. The input receiving unit of the group information setting unit 101 receives input (or selected) information based on a user operation via a screen as shown in FIG. The group information setting unit 101 determines a purchase budget management target group according to the characteristics of the input and sale. The grouping is an item registered in the item information DB, or a statistical value (for example, average sales volume or average sales frequency (not shown), etc.) indicating the sales characteristics of the item calculated according to the past sales performance of the item. ) And the like.
The grouping execution unit 102 executes grouping of each item according to the items set by the group information setting unit 101.

The purchase budget information setting unit 103 sets whether or not purchase budget adjustment is possible for each item belonging to each group, and sets the upper and lower limits of the adjusted service rate. The purchase budget information setting unit 103 includes a display unit and an input receiving unit. The display unit of the purchase budget information setting unit 103 displays a screen as shown in FIG. 9 described later on the display unit 207 described later. The input receiving unit of the purchase budget information setting unit 103 receives input (or selected) information based on a user operation via a screen as shown in FIG. Based on the input information, the purchase budget information setting unit 103 sets whether to adjust the purchase budget for each item belonging to each group, and sets the upper and lower limits of the adjusted service rate.
The safety stock amount adjustment execution unit 104 adjusts the safety stock amount of each item in order to match the total purchase order amount of items belonging to the group with the purchase budget amount of the group unit. The result display unit 105 displays a screen as shown in FIG. 11 and FIG. 12 on the display unit 207 or the like for displaying the processing result in the safety stock amount adjustment execution unit 104.

FIG. 5 is a diagram illustrating an example of a hardware configuration of the inventory management apparatus. In FIG. 5, the CPU 201 comprehensively controls each device connected to the system bus 212. The RAM 202 functions as a main memory, work area, temporary save area, and the like for the CPU 201. The ROM 203 stores a boot program.
The input control unit 204 controls input from the input unit 205 realized by a pointing device such as a keyboard or a mouse. The display control unit 206 controls display by the display unit 207 realized by a CRT monitor, a liquid crystal monitor, or the like. The external memory control unit 208 controls access to the external memory 209. The external memory 209 stores an operation system (OS) that is a control program of the CPU 201, a program for realizing the functions of the inventory management apparatus, the various databases (DB), files, applications, master files, user files, and the like. . The external memory 209 further stores a table or the like for realizing the functions of the inventory management apparatus. Examples of the external memory 209 include a hard disk (HD), a flexible disk (FD), a compact flash (registered trademark) that can be connected to a PCMCIA card slot via an adapter, and smart media. Further, the processing or function in the present embodiment is realized by the CPU 201 loading a program recorded in the external memory 209 to the RAM 202 as necessary and executing it.
The communication I / F control unit 210 executes communication control processing between the external device and the inventory management apparatus via a network 211 such as a LAN or the Internet.

  FIG. 6 is a flowchart illustrating an example of processing of the inventory management apparatus. In this process, the computer recorded in the external memory 209 or the like is stored in each functional unit (group information setting unit 101, grouping execution unit 102, purchase budget information setting unit 103, safety stock quantity adjustment execution unit 104) shown in FIG. , And the result display unit 105) is performed by the CPU 201 in accordance with control of a program for causing the computer to function. Hereinafter, in order to clarify the processing executed by each functional unit in the present processing, the subject of each step of the present processing will be described as each functional unit. In step S301, the group information setting unit 101 sets classification items for performing grouping. At this time, the display unit of the group information setting unit 101 displays a grouping setting screen as shown in FIG. 7 on the display unit 207 to prompt the user to input. And the input reception part of the group information setting part 101 receives the information input via the grouping setting fixed screen. Based on this information, the group information setting unit 101 sets classification items when performing grouping. Here, FIG. 7 is a diagram showing an example of the grouping setting setting screen. Note that the user sets a group item for which purchase budget management is to be performed regarding the setting of the classification item. In the inventory management apparatus, the setting item is information that can group items, and a plurality of items can be set. FIG. 7 is an example in the case where it is desired to manage the purchase budget for each item for each major classification, middle classification, minor classification, and average sales volume.

FIG. 8 is a diagram showing an example of a grouping setting screen for converting numerical information into category values when the setting item is numerical information. When the detail button in FIG. 7 is pressed by the user, the display unit of the group information setting unit 101 displays the screen shown in FIG. FIG. 8 shows “classification type A when the average sales volume is 100 or more”, “classification type B when the average sales volume is 50 or more and less than 100”, and “classification type when the average sales volume is less than 50”. In this example, “C” is set. For each item, the user assigns classification types that meet the conditions in order from the smallest priority number. If the condition item is blank, it will be other. Other examples of numerical information include unit sales price, average sales frequency, average sales volume, and average sales price. If there is no need to group items, grouping setting by the group information setting unit 101 may not be performed.
Returning to the description of FIG. 6 again, in step S302, the grouping execution unit 102 executes grouping of each item according to the classification items set in step S301. When the grouping setting by the group information setting unit 101 is not performed, the grouping execution unit 102 performs grouping so that items to be processed are included in one group. In step S302, the grouping execution unit 102 calculates the total order amount at the present time for each group, the total order amount of items already ordered, the calculation of the total safety stock, the average service rate, and the like. This calculation process may be performed by a purchase budget information setting unit 103 described later.

  In step S303, the purchase budget information setting unit 103 sets the purchase budget amount for each group classified in step S302. At this time, the display unit of the purchase budget information setting unit 103 displays a group-specific purchase budget information setting screen as shown in FIG. 9 on the display unit 207 to prompt the user to input. And the input reception part of the purchase budget information setting part 103 receives the information input via the purchase budget information setting screen classified by group. The purchase budget information setting unit 103 sets a purchase budget amount for each group based on this information. Here, FIG. 9 is a diagram illustrating an example of a purchase budget information setting screen for each group before the purchase budget adjustment. The purchase budget information setting unit 103 receives an input of the purchase budget amount (target amount in FIG. 9) for each group via this screen. In the safety stock amount adjustment described later (processing in step S305), the target adjustment amount is determined based on the budget purchase amount and the total order amount (total order amount in FIG. 9). In addition, on the group-by-group purchase budget information setting screen, it is possible to accept input of settings for the purchase budget amount for all groups and the cut rate of the safety stock amount of each group (target cut rate in FIG. 9). . When a cut rate is input, a purchase budget amount corresponding to the cut rate is calculated and the information is also displayed. As shown in FIG. 9, the display unit of the purchase budget information setting unit 103 displays the total order amount (total order amount in FIG. 9) for each group and all groups calculated in step S302, items already ordered. The total order amount (the order amount in FIG. 9), the total safety stock amount (the safety stock amount in FIG. 9), the average service rate, and the like are displayed. When the user detects that the detail button in FIG. 9 is pressed, the display unit of the purchase budget information setting unit 103 displays an item-specific purchase budget information setting screen as shown in FIG. 10 and inputs to the user. Prompt. FIG. 10 is a diagram illustrating an example of a purchase budget information setting screen for each item before the purchase budget adjustment. The purchase budget information setting unit 103 receives, via this screen, an input for setting whether or not the purchase budget can be adjusted for each item and for setting the upper and lower limits of the service rate for each item after the purchase budget adjustment. In addition, the display part of the purchase budget information setting part 103 displays the information of each item on the purchase budget information setting screen classified by item. The information of each item includes the order quantity, unit price, order value, inventory lot, safety stock quantity, safety stock value, service rate, etc. for each product.

When it is detected that the registration button in FIG. 10 has been pressed, in step S304, the input accepting unit of the purchase budget information setting unit 103 accepts information input via the item-specific purchase budget information setting screen. Based on this information, the purchase budget information setting unit 103 sets the purchase budget adjustment availability for each item belonging to the group classified in step S302, and sets the upper and lower limits of the service rate for each item after the purchase budget adjustment. Set.
When the user presses the execution button in FIG. 9, the process in step S305 is started.
In step S305, the safety stock amount adjustment execution unit 104 orders based on the information set in step S301, step S303, and step S304 so that the total order amount of items belonging to the group matches the purchase budget amount for each group. Adjust the safety stock of items belonging to the group that are related to the quantity. After the process of step S305 by the safety stock quantity adjustment execution unit 104 is completed, screens as shown in FIGS. 11 and 12 are displayed on the display unit 207 by the result display unit 105.
FIG. 11 is a diagram illustrating an example of a purchase budget information setting screen for each group after adjusting the purchase budget. The result of executing the process of step S305 is displayed for each group in the after-purchase budget adjustment result column in this screen. Moreover, FIG. 12 is a figure which shows an example of the purchase budget information setting screen classified by item after purchase budget adjustment. FIG. 12 shows the order quantity, order value, safety stock quantity, safety stock quantity, and service rate for each item belonging to the group after the purchase budget adjustment. FIG. 12 is displayed when the “detail” button in FIG. 11 is pressed.

  Hereinafter, with reference to FIG. 13, the details of the processing in step S305 will be described. Here, among items belonging to the group, “items for which the order quantity has already been determined” and “items that are designated as not subject to purchase budget adjustment” are excluded from the processing in step S305. In other words, the safety stock amount adjustment execution unit 104 excludes items whose purchase budget adjustment availability is “No” in step S304.

FIG. 13 is a flowchart for explaining the details of the safety inventory adjustment (step S305) in the flowchart shown in FIG.
In step S701, the safety stock amount adjustment execution unit 104 calculates the difference between the group purchase budget amount (target amount in FIG. 9) and the total order amount (total order amount in FIG. 9) by the following equation. Calculate the target adjustment total amount.
Target adjustment total amount = total order amount-purchase budget amount When target total adjustment amount> 0, the safety stock amount adjustment execution unit 104 decreases the safety stock amount of adjustable items among the items belonging to the group. The total amount of subtraction of the item's safety stock amount is set to the target adjustment total amount. On the other hand, when the target adjustment total amount <0, the safety stock amount adjustment execution unit 104 increases the safety stock amount of adjustable items among the items belonging to the group, so that the total addition amount of each item is the target adjustment. Make the total amount.

In step S702, the safety stock quantity adjustment execution unit 104 can adjust the target adjustment total amount calculated in step S701 and the groups included in the order quantity DB stored in the external memory 209 as an example of the storage device. Based on the total safety stock, the ratio of the target adjustment total is calculated using the following formula.
Adjustment ratio = Target adjustment total ÷ Safety inventory total The total safety stock is calculated from the safety inventory before adjustment and the unit price of items belonging to the group.
In step S703, the safety stock quantity adjustment execution unit 104 determines whether or not the processing target item satisfies “−1.0 <safety stock quantity × adjustment ratio <1.0”. When the item to be processed satisfies “−1.0 <safety stock amount × adjustment ratio <1.0”, the safety stock amount adjustment execution unit 104 advances the process to step S706. On the other hand, when the item to be processed does not satisfy “−1.0 <safety stock amount × adjustment ratio <1.0”, the safety stock amount adjustment execution unit 104 advances the process to step S704.
The process of step S703 is a process of excluding items satisfying “−1.0 <safety stock quantity × adjustment ratio <1.0” from the target of the purchase budget amount adjustment because adjustment with the safe stock quantity is impossible. is there.

In step S704, the safety stock amount adjustment execution unit 104 calculates the adjustment quantity and the adjustment amount for each item belonging to the group by the following formula.
Adjustment quantity = rounded down (safety inventory before adjustment x adjustment ratio ÷ inventory lot) x inventory lot adjustment = adjustment quantity x unit price Here, rounding down (X) means rounding down the calculation result of () The round-up (X) described means rounding up the calculation result of (). The inventory lot of items is included in the item attribute DB stored in the external memory 209 or the like which is an example of a storage device. The pre-adjustment safety stock quantity is included in the order quantity DB stored in the external memory 209, which is an example of a storage device.

In step S <b> 705, the safety stock amount adjustment execution unit 104 calculates an adjusted safety stock amount and an adjusted safety stock amount for each item belonging to the group using the following formulas.
Adjusted safety stock amount = Safety stock amount before adjustment-Adjusted amount Adjusted safety stock amount = Adjusted safety stock amount x Unit price In step S723, the safety stock amount adjustment execution unit 104 calculates the adjusted service rate of the safety stock amount. Calculate with the following formula.
Service rate after purchase budget adjustment = NORMSDIST {NORMSINV (service rate before purchase budget adjustment) × adjusted safety stock amount ÷ safety stock amount}
Here, NORMSDIST () is to obtain the probability of the standard normal distribution in (). NORMSINV () is to obtain the inverse function value of the cumulative distribution function of the normal distribution in ().
In step S724, the safety stock amount adjustment execution unit 104 determines whether the service rate after purchase budget adjustment calculated in step S723 is within the upper and lower limit service rates set in step S304. The safety stock quantity adjustment execution unit 104 proceeds to step S725 when the service rate after purchase budget adjustment is outside the upper and lower limit service rate, and when the service rate after purchase budget adjustment is within the upper and lower limit service rate. Then, the process proceeds to step S706.
In step S725, the safety stock amount adjustment execution unit 104 does not adjust the safety stock amount of the item, determines the order quantity and the order amount as values before adjusting the purchase budget amount, and thereafter targets for the purchase budget amount adjustment. Remove from. Also, the service rate of the item is a value before the purchase budget amount adjustment.
In step S706, the safety stock amount adjustment execution unit 104 determines whether or not the processing from step S703 to step S705 has been completed for all items belonging to the group. If the safety stock amount adjustment execution unit 104 determines that the processing from step S703 to step S705 has been completed for all items belonging to the group, the process proceeds to step S707. On the other hand, if the safety stock amount adjustment execution unit 104 determines that the processing from step S703 to step S705 has not been completed for all items belonging to the group, the process returns to step S703, and the next item to be processed is determined. On the other hand, the processing from step S703 is repeatedly executed.

FIG. 14 is a diagram illustrating an example of a result of the process up to step S706 performed by the safety stock amount adjustment execution unit 104 using the data in FIG. In FIG. 14, it is assumed that the purchase budget amount of the group in FIG. 10 is 58000, and item C is not subject to purchase budget amount adjustment.
In step S707, the safety stock amount adjustment execution unit 104 totals the adjustment amounts of the items belonging to the group calculated in step S704, and calculates the difference between the total amount and the target adjustment total amount of the group by the following formula.
Total target fine adjustment = Total target adjustment-Σ (adjustment amount)
The target fine adjustment total amount indicates that the safety stock amount of each item belonging to the group can still be adjusted by the target fine adjustment total amount.

In step S708, the safety stock amount adjustment execution unit 104 determines whether or not the target fine adjustment total amount calculated in step S707 is zero. If the target fine adjustment total is zero, the safety stock amount adjustment execution unit 104 proceeds to step S722. If the target fine adjustment total is not zero, the safety stock amount adjustment execution unit 104 proceeds to step S709.
In step S722, the safety stock amount adjustment execution unit 104 means a process of calculating the purchase budget adjusted order quantity and the purchase budget adjusted order value for each item belonging to the group using the following formulas.
Order quantity after purchase budget adjustment = Order quantity-Safety stock quantity + Safety stock quantity after adjustment Purchase order amount after purchase budget adjustment = Order quantity after purchase budget adjustment x Unit price Also, the service rate after purchase budget adjustment for the item is It becomes the service rate after the purchase budget adjustment calculated in S723.

On the other hand, in step S709, the safety stock amount adjustment execution unit 104 tabulates the adjusted safety stock amount of the items belonging to the group calculated in step S705, and calculates the ratio of the target fine adjustment total amount to the total amount by the following formula. calculate.
Fine adjustment ratio = Target fine adjustment total ÷ Σ (Adjusted safety stock value)
In step S710, the safety stock amount adjustment execution unit 104 means a process of calculating the fine adjustment quantity and the fine adjustment amount by the following formula for each item belonging to the group.
Fine adjustment quantity = round-up (adjusted safety stock quantity x fine adjustment ratio ÷ stock lot) x stock lot Fine adjustment amount = fine adjustment quantity x unit price In step S711, the safety stock quantity adjustment execution unit 104 sets each item belonging to the group. Calculate the adjusted safety stock and adjusted safety stock using the following formulas.
Safety stock after fine adjustment = Safety stock after adjustment-Fine adjustment quantity Safety stock after fine adjustment = Safety stock after fine adjustment x Unit price In step S726, the safety stock adjustment execution unit 104 performs safety stock after fine adjustment. The service rate of quantity is calculated by the following formula.
Service rate after purchase budget adjustment = NORMSDIST {NORMSINV (service rate before purchase budget adjustment) x safety stock after fine adjustment ÷ safety stock}
In step S727, the safety stock amount adjustment execution unit 104 determines whether the service rate after purchase budget adjustment calculated in step S726 is within the upper and lower limit service rates set in step S304. The safety stock amount adjustment execution unit 104 proceeds to step S728 when the service rate after purchase budget adjustment is outside the upper and lower limit service rate, and when the service rate after purchase budget adjustment is within the upper and lower limit service rate. Then, the process proceeds to step S712.
In step S728, the safety stock amount adjustment execution unit 104 does not finely adjust the safety stock amount of the item, and does not finely adjust the purchase budget amount thereafter. Further, the safety stock amount adjustment execution unit 104 calculates the order quantity after purchase budget adjustment and the order amount after purchase budget adjustment for each item belonging to the group by the following equations.
Order quantity after purchase budget adjustment = Order quantity-Safety stock quantity + Safety stock quantity after adjustment Purchase order amount after purchase budget adjustment = Order quantity after purchase budget adjustment x Unit price Also, the safety stock quantity adjustment execution unit 104 The service rate after adjusting the purchase budget is calculated using the following formula.
Service rate after purchase budget adjustment = NORMSDIST {NORMSINV (service rate before purchase budget adjustment) × adjusted safety stock amount ÷ safety stock amount}

In step S712, the safety stock quantity adjustment execution unit 104 determines whether or not the finely adjusted safety stock quantity calculated in step S711 satisfies the following condition.
Safety stock after fine adjustment <0
When the finely adjusted safety stock quantity calculated in step S711 satisfies the above conditions, the safety stock quantity adjustment execution unit 104 proceeds to step S713, and the finely adjusted safety stock quantity calculated in step S711 satisfies the above conditions. If not, the process proceeds to step S714.

In step S713, the safety stock amount adjustment execution unit 104 calculates the order quantity after the purchase budget adjustment of the item and the order amount after the purchase budget adjustment by the following formula.
Order quantity after purchase budget adjustment = Order quantity-Safety stock quantity Order quantity after purchase budget adjustment = Order quantity after purchase budget adjustment x Unit price In step S713, the safety stock quantity adjustment execution unit 104 adjusts the purchase budget. The post service rate is calculated by the following formula.
Service rate after purchase budget adjustment = NORMSDIST {NORMSINV (service rate before purchase budget adjustment) x safety stock after fine adjustment ÷ safety stock}
At this time, after performing the above calculation, the safety stock amount adjustment execution unit 104 stops the process for the item related to the process and removes it from the subsequent purchase budget adjustment process.

In step S714, the safety stock amount adjustment execution unit 104 determines whether or not the processing from step S710 to step S713 has been completed for all items belonging to the group. When the processes from step S710 to step S713 are completed for all items belonging to the group, the safety stock amount adjustment execution unit 104 advances the process to step S715. On the other hand, when the processes from step S710 to step S713 have not been completed for all items belonging to the group, the safety stock amount adjustment execution unit 104 advances the process to step S710.
FIG. 15 is a diagram illustrating an example of a result of the processing up to step S714 performed by the safety stock amount adjustment execution unit 104 using the data in FIG.

In step S715, the safety stock amount adjustment execution unit 104 determines whether all items belonging to the group have been excluded from the purchase budget adjustment processing targets. When all items belonging to the group are excluded from the purchase budget adjustment process, the safety stock amount adjustment execution unit 104 advances the process to step S721. On the other hand, when all the items belonging to the group are not excluded from the purchase budget adjustment process, the safety stock amount adjustment execution unit 104 advances the process to step S716.
In step S716, the safety stock quantity adjustment execution unit 104 executes a process of selecting an item to be adjusted in order to adjust the safety stock quantity from the items belonging to the group by the target fine adjustment total amount. Here, in order to improve the efficiency of the selection process, the safety stock amount adjustment execution unit 104 increases the fine adjustment amount (fine adjustment amount) of items belonging to the group calculated in step S710 in the descending order or the fine adjustment amount (fine adjustment). Sort and rearrange items in ascending order. Then, the safety stock amount adjustment execution unit 104 selects (selects) items that have not yet been selected in order from the top.

In step S717, the safety stock amount adjustment execution unit 104 accumulates the fine adjustment amount of the item selected in step S716, and determines whether or not the following formula is satisfied.
(When target adjustment total amount ≧ 0): Target fine adjustment total amount-Σ (fine adjustment amount) ≦ 0
(When target adjustment total amount ≦ 0): Target fine adjustment total amount-Σ (fine adjustment amount) ≧ 0
The safety stock amount adjustment execution unit 104 proceeds to step S720 when the accumulated fine adjustment amount satisfies the conditional expression, and proceeds to step S718 when the accumulated fine adjustment amount does not satisfy the conditional expression. .
In step S718, the safety stock amount adjustment execution unit 104 determines whether or not the processing from step S716 to step S717 has been executed for all items in the group. When the processing from step S716 to step S717 is executed for all items in the group, the safety stock amount adjustment execution unit 104 advances the processing to step S719. On the other hand, when the processes from step S716 to step S717 are not executed for all items in the group, the safety stock amount adjustment execution unit 104 returns the process to step S716. When returning to step S716, the safety stock amount adjustment execution unit 104 selects up to the next item selected in order from the top, and repeats the above-described processing.

FIG. 16 is a diagram illustrating an example of a result of the process up to step S718 performed by the safety stock amount adjustment execution unit 104 using the data in FIG. Note that the data in FIG. 15 is an example that does not satisfy the conditional expression in step S717 even if the fine adjustment amounts of all the items in the group are accumulated. That is, in the case of the data shown in FIG. 15, the safety stock quantity adjustment execution unit 104 executes step S719. FIG. 16 shows an example in which the order of accumulating the fine adjustment amounts of items is set in the order of increasing fine adjustment quantity.
In step S719, since the safety stock amount adjustment execution unit 104 can make further adjustments, the safety stock amount adjustment execution unit 104 executes conversion using the following formula, and re-executes the processing from step S707.
Target total adjustment amount = Target fine adjustment total amount Adjustment amount = Fine adjustment amount Adjustment amount = Fine adjustment amount Adjusted safety stock amount = Fine adjustment safety stock amount Adjusted safety stock amount = Fine adjustment safety stock amount

FIG. 17 is a diagram illustrating an example of a result of the safety stock amount adjustment execution unit 104 re-executing from step S707 through step S719 using the data in FIG. 16 and executing the processing up to step S715. .
FIG. 18 is a diagram illustrating an example of a point in time when the safety stock amount adjustment execution unit 104 satisfies the conditional expression in step S717 using the data in FIG.
In step S720, the safety stock amount adjustment execution unit 104 calculates the purchase budget-adjusted order quantity and the purchase budget-adjusted order amount for each item belonging to the group using the following equations.
Order quantity after purchase budget adjustment = Order quantity-Safety stock quantity + Safety stock quantity after fine adjustment Order quantity after purchase budget adjustment = Order quantity after purchase budget adjustment x Unit price In step S720, the safety stock quantity adjustment execution unit In 104, the service rate after adjusting the purchase budget is calculated by the following equation.
Service rate after purchase budget adjustment = NORMSDIST {NORMSINV (service rate before purchase budget adjustment) x safety stock after fine adjustment ÷ safety stock}
FIG. 19 is a diagram illustrating an example of a result of the safety stock amount adjustment execution unit 104 executing the process of step S720 using the data of FIG.

  In step S721, the safety stock amount adjustment execution unit 104 determines whether or not all groups have been processed. The safety stock amount adjustment execution unit 104 ends the process shown in FIG. 13 when the process for all groups is completed, and returns the process to step S701 when the process for all groups is not completed. The above-described processing is executed.

<Other embodiments>
The object of the present invention is achieved by the following. That is, a storage medium (or recording medium) in which a program code of software that realizes the functions of the above-described embodiments is recorded is supplied to the system or apparatus. Then, the central processing means (CPU or MPU) of the system or apparatus reads and executes the program code stored in the storage medium. In this case, the program code itself read from the storage medium realizes the functions of the above-described embodiment, and the storage medium recording the program code constitutes the present invention.

  In addition, by executing the program code read by the central processing means of the system or apparatus, an operating system (OS) or the like operating on the system or apparatus performs actual processing based on the instruction of the program code. Do some or all. The case where the function of the above-described embodiment is realized by the processing is also included.

  Further, it is assumed that the program code read from the storage medium is written in a memory provided in a function expansion card inserted into the system or apparatus or a function expansion unit connected thereto. After that, based on the instruction of the program code, the CPU of the function expansion card or function expansion unit performs part or all of the actual processing, and the function of the above-described embodiment is realized by the processing. It is.

  When the present invention is applied to the storage medium, the storage medium (computer-readable storage medium) stores program codes corresponding to the flowcharts described above.

  As described above, according to each of the above-described embodiments, the order amount or the order amount for each item can be adjusted, and the service rate of items belonging to the group can be made substantially constant.

  The preferred embodiments of the present invention have been described in detail above, but the present invention is not limited to such specific embodiments, and various modifications can be made within the scope of the gist of the present invention described in the claims.・ Change is possible.

It is the figure which showed an example of the functional structure etc. of the inventory management apparatus which is an example of information processing apparatus (computer). It is a figure which shows an example of the setting information registered into item attribute DB. It is a figure which shows an example of the setting information registered into the order quantity DB before the purchase budget adjustment. It is a figure which shows an example of the setting information registered into the order quantity DB after purchase budget adjustment. It is the figure which showed an example of the hardware constitutions of an inventory management apparatus. It is a flowchart which shows an example of a process of an inventory management apparatus. It is a figure which shows an example of a grouping setting screen. When a setting item is numerical information, it is a figure which shows an example of the grouping setting screen which converts numerical information into a category value. It is a figure which shows an example of the purchase budget information setting screen classified by group before purchase budget adjustment. It is a figure which shows an example of the purchase budget information setting screen classified by item before purchase budget adjustment. It is a figure which shows an example of the purchase budget information setting screen classified by group after purchase budget adjustment. It is a figure which shows an example of the purchase budget information setting screen classified by item after purchase budget adjustment. It is a flowchart for demonstrating the detail of the safety stock amount adjustment process (step S305) of the flowchart shown in FIG. It is a figure which shows an example as a result of the safety stock quantity adjustment execution part 104 performing the process to step S706 using the data of FIG. It is a figure which shows an example of the result as which the safety stock quantity adjustment execution part 104 performed the process to step S714 using the data of FIG. It is a figure which shows an example of the result of having performed the process to step S718 using the data of FIG. FIG. 17 is a diagram illustrating an example of a result obtained by the safety stock amount adjustment execution unit 104 performing the processing from step S707 through step S719 using the data in FIG. 16 and executing the processing up to step S715. It is a figure which shows an example at the time of the safety stock quantity adjustment execution part 104 satisfy | filling the conditional expression by step S717 using the data of FIG. It is a figure which shows an example of the result of having performed the process of step S720, using the data of FIG. It is the figure which showed the relationship between the safety stock quantity, the service rate, and the allowable shortage rate.

Explanation of symbols

101 Group Information Setting Unit 102 Grouping Execution Unit 103 Purchase Budget Information Setting Unit 104 Safety Stock Quantity Adjustment Execution Unit 105 Result Display Unit

Claims (9)

An information processing apparatus that performs ordering support for adjusting the order quantity of an item by adjusting a safety stock as a reference for determining the order quantity of the item,
For each of the item, storage means for storing safety stock, and unit price of the item,
First setting means for setting a purchase budget amount to be input for purchasing a plurality of the items;
Adjustment of the safety stock of each item according to the safety stock amount before adjustment calculated by the safety stock and unit price of the item stored in the storage means and the purchase budget amount set by the first setting means First calculating means for calculating a ratio;
Second calculation means for calculating the adjusted safety stock of the item according to the safety stock of the item and the adjustment ratio calculated by the first calculation means for each item stored in the storage means; ,
Third calculation means for calculating an adjusted order quantity of the item using the adjusted safety stock of the item calculated by the second calculation means for each item;
The information processing apparatus comprising: a. A second setting means for setting a classification condition for classifying the plurality of items into a plurality of groups;
According to the classification condition, further comprising a grouping execution means for performing a grouping of a plurality of said items,
The information processing apparatus according to claim 1, wherein the first setting unit sets a purchase budget amount to be purchased for purchasing a plurality of the items for each group . Of the plurality of items, further comprising a designation means for designating an item to be excluded from the safety stock adjustment,
The first calculating means includes a safety stock before adjustment calculated by the safety stock and unit price of the item excluding the item specified by the specifying means, and a purchase budget set by the first setting means. Calculate the safety stock adjustment ratio for each item according to the amount
The information processing apparatus according to claim 1 or 2. The storage means further stores the number of inventory lots of the item,
Said second calculating means, the information processing apparatus according to any one of claims 1 to 3, characterized in that to calculate the adjusted safety stock of the item in the inventory lot number of units. Determining means for determining whether the total amount of adjusted safety stock of each item calculated by the third calculating means satisfies the purchase budget amount;
A fourth calculating means for calculating a fine adjustment ratio from the adjusted total amount of the safety stock and the purchase budget when it is determined that the determination means does not satisfy;
Fifth calculation means for calculating a safety stock after fine adjustment of the item according to the fine adjustment ratio for each item stored in the storage means;
Sixth calculating means for calculating the order quantity after fine adjustment of the item using the adjusted order quantity of the item and the finely adjusted safety stock of the item for each item;
The information processing apparatus according to claim 1, further comprising: A third setting means for setting at least one of an upper limit service rate or a lower limit service rate of the item as a service rate condition;
It said second calculating means, the information processing apparatus according to any one of claims 1乃 optimum 5, characterized in that to calculate the safety stock of the service rate condition is satisfied the item. Display means for displaying a screen for accepting an input of the purchase budget amount;
A receiving means for receiving an input of the purchase budget amount via the screen;
The first setting means sets a purchase budget amount with the contents received by the receiving means.
The information processing apparatus according to any one of claims 1 to 6. Information for providing order support for adjusting the order quantity of an item by adjusting the safety stock as a reference for determining the order quantity of the item, provided with a storage device for storing the safety stock of the item and the unit price for each item An information processing method executed by a processing device,
A first setting step of setting a purchase budget amount to be input for purchasing a plurality of the items;
Adjustment of the safety stock of each item according to the safety stock amount before adjustment calculated by the safety stock and unit price of the item stored in the storage device, and the purchase budget amount set in the first setting step A first calculation step of calculating a ratio;
A second calculation step of calculating an adjusted safety stock of the item according to the safety stock of the item and the adjustment ratio calculated in the first calculation step for each item stored in the storage device; ,
And a third calculation step of calculating an adjusted order quantity of the item using the adjusted safety stock of the item calculated in the second calculation step for each item. Method. Order support that adjusts the order quantity of an item by adjusting the safety stock that is a reference for determining the order quantity of the item by a computer having a storage device that stores the safety stock of the item and the unit price for each item. A computer program for causing an information processing apparatus to function,
The computer,
First setting means for setting a purchase budget amount to be input for purchasing a plurality of the items;
Adjustment of the safety stock of each item according to the safety stock amount before adjustment calculated by the safety stock and unit price of the item stored in the storage device, and the purchase budget amount set by the first setting means First calculating means for calculating a ratio;
Second calculating means for calculating the adjusted safety stock of the item according to the safety stock of the item and the adjustment ratio calculated by the first calculating means for each item stored in the storage device; ,
A computer program for causing each item to function as third calculating means for calculating an adjusted order quantity of the item using the adjusted safety stock of the item calculated by the second calculating means. .

Images