Order determination device, order determination method, and order determination program

Abstract

To provide an order placement determination apparatus, an order placement determination method, and an order placement determination program for verifying validity of order quantity in placing an order for commodities, by presenting a quantitative criterion for determining appropriate order quantity.SOLUTION: An order placement determination apparatus includes: order placement processing means which inputs an order slip including a commodity and order quantity, in accordance with an operation of a person in charge on an order input screen; and inventory turnover month calculation means which refers, when the commodity and the order quantity are input on the order input screen, inventory data, order receipt data, order placement data, and sales data, and calculates, for the commodity, inventory turnover months, which is an index obtained by theoretically calculating how many months are taken for consuming a planned inventory based on the current order quantity, by the following formula: inventory turnover month=current quantity of inventory of the commodity + scheduled quantity of inventory receipts and payments + current order quantity / average of sales quantity for predetermined months, to display the inventory turnover months.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to an order determination device, an order determination method, and an order determination program. [Background technology]

[0002] For example, wholesalers and trading companies need standards for determining the appropriate number of products to order when ordering products in order to ensure that they have an appropriate inventory. Patent Document 1, for example, is an example of a conventional ordering system. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Publication No. 2022-108173 Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not disclose anything about presenting quantitative criteria for determining an appropriate order quantity when ordering products, and making it possible to verify the appropriateness of the order quantity.

[0005] The present invention has been made in consideration of the above, and aims to provide an order determination device, an order determination method, and an order determination program that can present quantitative criteria for determining an appropriate order quantity when ordering goods, thereby enabling the appropriateness of the order quantity to be verified. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an order determination device equipped with a control unit, the control unit being configured to be able to access inventory data including products and current inventory quantities, order data including products, scheduled shipping dates, and order quantities, order data including products, scheduled arrival dates, and order quantities, and sales data including products, sales dates, and sales quantities, and is characterized by comprising: order processing means for inputting an order slip including products and order quantities in response to operations by a person in charge on an order input screen; and inventory turnover months calculation means for, when a product and order quantity are input on the order input screen, referring to the inventory data, order data, order data, and sales data, calculating and displaying inventory turnover months, which is an index that theoretically calculates how many months it will take to consume the planned inventory for the product, taking into account the current order quantity, by calculating inventory turnover months = current inventory quantity of the product + planned inventory quantity to be received or delivered + current order quantity / average sales quantity for a specified month.

[0007] According to another aspect of the present invention, the inventory turnover months calculation means may calculate the inventory turnover months using average sales volumes for a plurality of different predetermined months.

[0008] According to one aspect of the present invention, the control unit may be further configured to be able to access a master that registers an inventory turnover months threshold that defines the range of normal inventory turnover months for each product, and the inventory turnover months calculation means may acquire the inventory turnover months threshold for the product from the master when the inventory turnover months is calculated, and display a warning if the calculated inventory turnover months is outside the range of the acquired inventory turnover months threshold.

[0009] According to another aspect of the present invention, the order processing means may generate an order approval screen according to the display contents of the order input screen, including the inventory turnover months and the warning, and present the screen to the approver.

[0010] According to another aspect of the present invention, the product may include a semiconductor or an electronic component.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides an order determination method executed by an information processing device having a control unit, wherein the control unit is configured to be able to access inventory data including products and current stock quantities, order data including products, scheduled shipping date, and order quantities, order data including products, scheduled arrival date, and order quantities, and sales data including products, sales date, and sales quantities, and the method includes an order processing step executed by the control unit, for inputting an order slip including products and order quantities in response to operations by a person in charge on an order input screen, and an inventory turnover months calculation step, when a product and order quantity are input on the order input screen, for referring to the inventory data, order data, order data, and sales data, to calculate and display inventory turnover months, which is an index that theoretically calculates how many months it will take to consume the planned inventory for the product, taking into account the current order quantity, using the formula inventory turnover months = current stock quantity of the product + planned inventory quantity to be received or delivered + current order quantity / average sales quantity for a specified month.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides an order determination program to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access inventory data including products and current stock quantities, order data including products, scheduled shipping date, and order quantities, order data including products, scheduled arrival date, and order quantities, and sales data including products, sales date, and sales quantities, and the order determination program is characterized by executing: an order processing step executed by the control unit, in which an order slip including products and order quantities is input on an order input screen in response to an operation by a person in charge; and an inventory turnover months calculation step, in which, when a product and order quantity are input on the order input screen, the inventory turnover months is calculated by referring to the inventory data, order data, order data, and sales data, and calculating and displaying the inventory turnover months, which is an index that theoretically calculates how many months it will take to consume the planned inventory for the product, taking into account the current order quantity, using the formula inventory turnover months = current stock quantity of the product + planned inventory quantity to be received and delivered + current order quantity / average sales quantity for a specified month. [Effects of the Invention]

[0013] According to the present invention, when ordering goods, it is possible to present quantitative criteria for determining an appropriate order quantity, thereby making it possible to verify the appropriateness of the order quantity. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an order determination device according to this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the configuration of the product number master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of inventory data. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of order data. [Figure 5] FIG. 5 is a diagram illustrating an example of the configuration of order data. [Figure 6] FIG. 6 is a diagram illustrating an example of the configuration of sales data. [Figure 7] FIG. 7 is a diagram for explaining inventory turnover months. [Figure 8] FIG. 8 is a diagram for explaining a specific example of processing by the control unit of the information processing device according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of processing by the control unit of the information processing device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of processing by the control unit of the information processing device according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to the embodiment.

[0016] [1. Overview] For example, when ordering goods at wholesalers and trading companies, standards for determining the appropriate order quantity are needed to ensure adequate inventory. Typically, the person in charge of ordering enters the appropriate order quantity when submitting a purchase request, and after obtaining approval from their supervisor, the order can be sent to the supplier. One method for determining the appropriate order quantity is to set an order point to ensure safety stock, but this method requires each time the appropriateness of the order quantity is judged, so it cannot be considered a quantitative standard for judgment. For this reason, quantitative standards for determining the appropriate order quantity when ordering goods are desirable.

[0017] Therefore, in this embodiment, when ordering goods, quantitative criteria for determining an appropriate order quantity are presented to the person in charge or approver, and in order to enable verification of the appropriateness of the order quantity, the inventory turnover number (months) is displayed in real time when inputting the order slip. This is an indicator that is theoretically calculated to show how many months it will take to consume the planned inventory taking into account the current order quantity, on a product detail and monthly basis.

[0018] The order determination device of the present invention can be applied to all products and all industries where orders are placed, and is suitable for use in, for example, wholesalers and trading companies that predict future inventory trends and create ordering plans, and industries that handle semiconductors and electronic components.

[0019] [2. Configuration] FIG. 1 is a block diagram showing an example of the configuration of an order determination device 100 according to this embodiment. In the following description, all monetary amounts are expressed in units of yen, and the unit of yen will be omitted. In FIG. 1, the order determination device 100 is a commercially available desktop personal computer. Note that the device is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. The order determination device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units included in the order determination device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0020] The communication interface unit 104 communicatively connects the order determination device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicatively connecting the order determination device 100 with a staff terminal (not shown), an approver terminal (not shown), and the server 200, and is, for example, the Internet or a LAN (Local Area Network). The staff terminal (not shown) is a terminal used by an order staff member. The approver terminal (not shown) is a terminal used by an order approver. The orderer terminal and approver terminal (not shown) are configured to be able to communicate data with the order determination device 100 via the network 300.

[0021] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. Note that hereinafter, the output device 114 may be referred to as the monitor 114.

[0022] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0023] The storage unit 106 includes a product number master 106a and a data table 106b. Fig. 2 shows an example of the configuration of the product number master 106a. Fig. 3 shows an example of the configuration of inventory data, Fig. 4 shows an example of the configuration of order data, Fig. 5 shows an example of the configuration of order data, and Fig. 6 shows an example of the configuration of sales data.

[0024] The product number master 106a is a master that sets an inventory turnover months threshold that defines the range of normal inventory turnover months for each product or type. As shown in Figure 2, the product number master 106a can be configured, for example, as a table that registers products (product code, product name) and inventory turnover months thresholds in association with each other. In Figure 2, the inventory turnover months threshold is set for each product, but it is also possible to set an inventory turnover months threshold for each type. In the example shown in the figure, the first line contains the product code "AB0001", the product name "Product XX", and the inventory turnover months threshold "2.0 to 5.0".

[0025] The data table 106b is a table for storing various data such as inventory data, order data, purchase order data, and sales data.

[0026] The inventory data may include the product code, warehouse, and current inventory quantity, as shown in Figure 3. In the example shown in the figure, the first line contains the product code "AB0001," the warehouse "Tokyo Warehouse," and the current inventory quantity "12,000."

[0027] The order data may include the order number, expected shipping date, product code, and order quantity, as shown in Figure 4. In the example shown in the figure, the first line contains the order number "JU0001," the expected shipping date "2022 / 7 / 10," the product code "AB0001," and the order quantity "2500."

[0028] The order data may include an order number, expected arrival date, product code, and order quantity, as shown in Figure 5. In the example shown in the figure, the first line contains the order number "HA0001," the expected arrival date "2022 / 7 / 30," the product code "AB0001," and the order quantity "1200."

[0029] The sales data may include a sales number, a sales date, a product code, and a sales quantity, as shown in Figure 6. In the example shown in the figure, the first line contains the sales number "UR0001", the sales date "2022 / 2 / 1", the product code "AB0001", and the sales quantity "4500".

[0030] 1, the control unit 102 is a CPU or the like that performs overall control of the order determination device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0031] Control unit 102 is configured to be able to access product number master 106a, data table 106b, etc., stored in storage unit 106. Product number master 106a and data table 106b may be provided elsewhere (e.g., server 200), as long as they are accessible by control unit 102.

[0032] The control unit 102 conceptually includes a data registration unit 102a, an order processing unit 102b, an inventory turnover months calculation unit 102c, a warning unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.

[0033] The data registration unit 102a inputs and updates stock data, order data, and sales data in the data table 106b.

[0034] For example, in response to access from a staff terminal (not shown), the order processing unit 102b provides an order input screen to the staff terminal. The staff at the staff terminal inputs order slip data, including the product and order quantity, on the order input screen. The order input screen displays the inventory turnover months, which will be described later, and a warning regarding this.

[0035] The order processing unit 102b creates an order approval screen according to the display contents of the order input screen, including the inventory turnover months and warnings, and presents it to the approver terminal, and when the approver at the approver terminal approves on the order approval screen, performs order processing (placing an order with a supplier, updating order data in data table 106b, etc.). The inventory turnover months and related warnings are also inherited and displayed on the order approval screen.

[0036] When a product and order quantity are entered by a person in charge on the order input screen, the inventory turnover months calculation unit 102c refers to the inventory data, order data, order data, and sales data in the data table 106b, and calculates and displays the inventory turnover months, which is an index that theoretically calculates how many months it will take to consume the planned inventory taking into account the current order quantity, as follows: inventory turnover months = current inventory quantity of the product + planned inventory quantity to be received or delivered + current order quantity / average sales quantity for a specified month.

[0037] The inventory turnover months calculation unit 102c may calculate multiple inventory turnover months (e.g., 3 months and 6 months) using the average sales volume for multiple (e.g., two) different specified months (e.g., 3 months and 6 months).

[0038] When the inventory turnover months is calculated, the warning unit 102d acquires the inventory turnover months threshold value for the product from the product number master 106a, determines whether the calculated inventory turnover months is outside the range of the acquired inventory turnover months threshold value, and displays a warning if it is outside the range of the inventory turnover months threshold value.

[0039] The master maintenance unit 102e performs settings such as inputting, adding, changing, and updating data in the product number master 106a in response to operations by an administrator on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0040] The screen display control unit 102f controls the display of various screens (for example, an order input screen, a master maintenance screen, etc.) displayed on the monitor 114 and the reception of inputs.

[0041] [3. Inventory turnover period] 7 is a diagram for explaining the inventory turnover months. The inventory turnover months calculated by the inventory turnover months calculation unit 102c will be described with reference to FIG.

[0042] When an ordering person inputs a product and an order quantity on the order input screen, the inventory turnover months calculation unit 102c refers to the inventory data, order data, order data, and sales data in the data table 106b, and calculates and displays the inventory turnover months, which is an index that theoretically calculates how many months it will take to consume the planned inventory taking into account the current order quantity, as follows: inventory turnover months = current inventory quantity of the product + planned inventory quantity to be received or delivered + current order quantity / average sales quantity for a specified month.

[0043] The inventory turnover months calculation unit 102c may use the average sales volume for a plurality of different specified months (e.g., 3 months and 6 months) to calculate a plurality of different (e.g., two) inventory turnover months (e.g., 3 months and 6 months).

[0044] (3-1. Calculation formula) Here, we will explain the case where the average sales volume for the specified month is 3 months and 6 months as an example. Note that the specified months are not limited to 3 months and 6 months. In Figure 7, the formulas for calculating the inventory turnover months (3 months) and inventory turnover months (6 months) are as follows:

[0045] Inventory turnover period (3 months) = current inventory of the product in the order details + inventory to be received or delivered + order quantity on the screen / average sales quantity for 3 months

[0046] Inventory turnover period (6 months) = current inventory of the product in the order details + inventory to be received or delivered + order quantity on the screen / average sales quantity for 6 months

[0047] Here, the planned inventory quantity includes unapproved receipt / order slips.

[0048] Next, we will explain how to obtain the average sales volume for 3 months / 6 months. Using the order date as the base date, obtain the sales volume from the month before the order date to 4 months before (7 months before).

[0049] If the order date is 7 / 1 / 2022, 3 months is the period from 4 / 1 / 2022 to 6 / 30 / 2022. 6 months is the period from 1 / 1 / 2022 to 6 / 30 / 2022. The average sales volume for 3 months / 6 months is calculated by dividing the sales volume for 3 months (6 months) by 3 (6).

[0050] If the same product exists in different details within the same purchase order, it will be calculated by adding up the product code units. If the average sales quantity is 0 (division by 0), the calculation result will be displayed as an "error".

[0051] (3-2. Evaluation Criteria) Next, the evaluation criteria for the calculated inventory turnover months will be explained.

[0052] The result of calculating the inventory turnover months will give you an indication of "how many months it will take for inventory to turn over," including the quantity to be ordered in the future. As shown below, the inventory turnover months (3 months) will be represented as "a" and the inventory turnover months (6 months) will be represented as "b."

[0053] a: Inventory turnover months (3 months)... Turnover months based on sales performance for the most recent 3 months b: Inventory turnover period (6 months) - Number of months of inventory turnover based on sales performance over the past six months

[0054] The importance of indicators A and B may differ depending on the product and industry. For example, for food products, the emphasis is on short-term sales, but for products such as semiconductors, the emphasis is on mid- to long-term sales.

[0055] (3-2-1. Appropriateness for each product / variety) Since the expiration period of inventory varies for each product, the inventor of the present application considered that the normal inventory turnover months are determined for each product or variety. Therefore, as shown in the item number master 106a of FIG. 2 above, a range of normal inventory turnover months (inventory turnover month threshold) is set for each product or variety, and it is evaluated whether the calculated inventory turnover months are within that range. When applying by the person in charge or approving by the approver, if the calculated inventory turnover months are outside the range of the normal inventory turnover months (inventory turnover month threshold), an alert can be issued.

[0056] (3-2-2. Validity Based on Increase or Decrease in Sales According to Time) By comparing the turnover months of a and b, if there is a difference, an evaluation / judgment can be made based on that.

[0057] When a > b, the recent sales performance is low and the inventory turnover months are large. For example, the approver can judge whether future sales will also decrease or whether it is due to seasonality.

[0058] When a < b, the recent sales performance is high and the inventory turnover months are small. If sales are expected to increase further in the future, there may be a shortage of inventory.

[0059] For example, a person can judge the difference in inventory turnover months for each period and use it to judge the validity of the order quantity.

[0060] [4. Specific Example] Referring to FIGS. 8 to 10, a specific example of the processing of the control unit 102 of the order determination device 100 in the present embodiment will be described. FIGS. 8 to 10 are diagrams showing sample data for explaining a specific example of the processing of the control unit 102 of the order determination device 100 in the present embodiment.

[0061] The order processing unit 102b provides an order input screen to the person-in-charge terminal, for example, in response to an access from a person-in-charge terminal (not shown). FIG. 8 is a diagram showing a display example of the order input screen.

[0062] As shown in Figure 8, the order input screen has a header area including items such as order date, expected arrival date, supplier, and person in charge, a detail information area including items such as product, order quantity, inventory turnover months (3 months), inventory turnover months (6 months), purchase price, and purchase amount, an inventory turnover months button 400, and an application button (not shown).

[0063] The person in charge enters data such as order date, expected arrival date, supplier, and person in charge in the header area, and also enters data such as product, order quantity, purchase price, and purchase amount in the detail information area, and after entering the data, presses the inventory turnover months button.

[0064] When the inventory turnover months calculation unit 102c is pressed, it refers to the inventory data, order data, purchase order data, and sales data in the data table 106b and calculates inventory turnover months (3 months) = current inventory quantity of the product in the order details + inventory quantity to be received or delivered + order quantity on the screen / average sales quantity for 3 months, and inventory turnover months (6 months) = current inventory quantity of the product in the order details + inventory quantity to be received or delivered + order quantity on the screen / average sales quantity for 6 months, and displays these on the order input screen.

[0065] In the example shown in the same figure, the order date "2022 / 7 / 1", product "Product XX", order quantity "2000", product "Product XX", order quantity "5000", etc. are entered, and the inventory turnover months button is pressed, and for product "Product XX", the inventory turnover months (3 months) "3.0" and inventory turnover months (6 months) "4.0" are calculated and displayed, and for product "Product XX", the inventory turnover months (3 months) "1.6" and inventory turnover months (6 months) "1.8" are calculated and displayed.

[0066] With reference to Figure 9, a specific example of calculating inventory turnover months (3 months) and inventory turnover months for product "product XX" will be described. A specific calculation example for product "product XX" will not be described. The inventory data, order data, purchase order data, and sales data in Figure 9 are the same as the data in Figures 3 to 6. Note that although the illustration of data for calculating product "product XX" is omitted, it is assumed that the data for calculating product "product XX" is also registered in data table 106b.

[0067] The current stock quantity of "Product XX: AB0001" is "20,000" according to the inventory data. The scheduled shipping amount is -2,500 + (-1,500) = -4,000 according to the order data, and the scheduled arrival amount is 12,000 according to the order data. From these, the scheduled receipt and delivery amount is -4,000 + 12,000 = 8,000.

[0068] Since the order date is "2022 / 7 / 1", the three-month period is from 2022 / 4 / 1 to 2022 / 6 / 30, and the six-month period is from 2022 / 1 / 1 to 2022 / 6 / 30. The three-month average sales quantity is the sales quantity for three months of sales data divided by 3 = 10,000, and the six-month average sales quantity is the sales quantity for six months of sales data divided by 6 = 7,500.

[0069] The inventory turnover period (3 months) is (20,000 + 8,000 + 2,000) ÷ 10,000 = 3.0. The inventory turnover period (6 months) is (20,000 + 8,000 + 2,000) ÷ 7,500 = 4.0.

[0070] In addition, when the inventory turnover months is calculated, the warning unit 102d obtains the inventory turnover months threshold value for the product from the product number master 106a, determines whether the calculated inventory turnover months is outside the range of the obtained inventory turnover months threshold value, and displays a warning "!" if it is outside the range of the inventory turnover months threshold value.

[0071] In the example shown in Figure 8, for the product "Product XX", the inventory turnover months (3 months) = "3.0" and the inventory turnover months (6 months) = "4.0", which is within the inventory turnover months threshold range of "2.0 to 5.0", so it is not subject to a warning.

[0072] On the other hand, for the product "Product XX," the inventory turnover months (3 months) is "1.6" and the inventory turnover months (6 months) is "1.8," both of which are outside the inventory turnover months threshold range of "2.0 to 5.0," so a warning "!" is displayed.

[0073] The person in charge will look at the inventory turnover months (3 months), inventory turnover months (6 months), warnings, etc. and judge the appropriateness of the order quantity. If the person in charge determines that the order quantity is not appropriate, they will correct the order quantity. If the person in charge cannot make a decision, they will leave it to the approver to make the decision.

[0074] When an application button (not shown) is pressed on the order input screen, the order processing unit 102b creates an order approval screen according to the display contents of the order input screen and presents it to the approver terminal, and if the approver at the approver terminal approves on the order approval screen, it performs order processing (placing an order with the supplier, updating the order data in the data table 106b, etc.).

[0075] Figure 10 is a diagram showing an example of the display of the order approval screen (order input checklist screen). The display content of the order approval screen is almost the same as that of the order input screen, and also displays the inventory turnover months (3 months), inventory turnover months (6 months), and a warning. In addition, order numbers are automatically assigned.

[0076] The approver looks at the inventory turnover months (3 months), inventory turnover months (6 months), warnings, etc., judges the appropriateness of the order quantity, and decides whether to approve the order. If the approver presses the approve button (not shown) on the order approval screen, the order is processed. On the other hand, if the approver presses the reject button (not shown), the order is returned to the person in charge.

[0077] As explained above, according to this embodiment, there are provided an order processing unit 102b which inputs an order slip including the product and the order quantity on the order input screen in response to the operation of the person in charge, and an inventory turnover months calculation unit 102c which, when the product and the order quantity are input on the order input screen, refers to the inventory data, order data, order data, and sales data, and calculates and displays the inventory turnover months, which is an index that theoretically calculates how many months it will take to consume the planned inventory for the product, taking into account the current order quantity, by calculating the inventory turnover months = current inventory quantity of the product + planned inventory quantity for receipt and delivery + current order quantity / average sales quantity for a specified month. Therefore, when ordering products, it becomes possible to present quantitative standards for determining an appropriate order quantity to the person in charge or approver, and verify the appropriateness of the order quantity.

[0078] [5. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0079] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0080] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0081] 6. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0082] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0083] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0084] Furthermore, with regard to the order determination device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0085] For example, all or any part of the processing functions of the order determination device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the order determination device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0086] This computer program may be stored in an application program server connected to the order determination device 100 via any network, and all or part of it may be downloaded as needed.

[0087] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0088] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0089] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0090] The order determination device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected to any peripheral device. The order determination device 100 may be realized by installing software (including programs or data) that causes the device to perform the processes described in this embodiment.

[0091] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0092] 100 Order determination device 102 Control section 102a Data Registration Section 102b Order processing unit 102c Inventory turnover months calculation section 102d Warning section 102e Master Maintenance Department 102f Screen display control unit 104 Communication interface unit 106 Storage section 106a Part Number Master 106b Data Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 300 Network

Claims

1. An order determination device including a control unit, The control unit Inventory data including products and current stock quantities, Order data including product, expected shipping date, and order quantity; Order data including product, expected arrival date, and order quantity, Sales data including product, sales date, and sales quantity; It is configured to be accessible to an order processing means for inputting an order slip including the product and the order quantity in response to an operation by a person in charge on an order input screen; an inventory turnover months calculation means for calculating and displaying, when a product and an order quantity are input on the order input screen, inventory turnover months, which is an index theoretically calculated to indicate how many months it will take to consume the planned inventory for the product taking into account the current order quantity, by referring to the inventory data, the order data, the order data, and the sales data, as inventory turnover months = current inventory quantity of the product + planned inventory quantity for receipt and delivery + current order quantity / average sales quantity for a predetermined month; An order determination device comprising:

2. 2. The order determination device according to claim 1, wherein the inventory turnover months calculation means calculates the inventory turnover months using average sales volumes for a plurality of different predetermined months.

3. The control unit further The system is configured to be accessible to a master that registers inventory turnover months thresholds that define the range of normal inventory turnover months for each product, The order determination device according to claim 1 or 2, characterized in that the inventory turnover months calculation means, when calculating the inventory turnover months, acquires an inventory turnover months threshold value for the product from the master, and displays a warning if the calculated inventory turnover months is outside the range of the acquired inventory turnover months threshold value.

4. 4. The order determination device according to claim 3, wherein the order processing means generates an order approval screen according to the display contents of the order input screen including the inventory turnover months and the warning, and presents the screen to the approver.

5. 2. The order determination device according to claim 1, wherein the merchandise includes a semiconductor or an electronic component.

6. An order determination method executed by an information processing device including a control unit, The control unit Inventory data including products and current stock quantities, Order data including product, expected shipping date, and order quantity; Order data including product, expected arrival date, and order quantity, Sales data including product, sales date, and sales quantity; It is configured to be accessible to Executed in the control unit: an order processing step of inputting an order slip including the product and the order quantity in response to an operation by a person in charge on an order input screen; an inventory turnover months calculation process for, when a product and order quantity are input on the order input screen, referring to the inventory data, the order data, the order data, the order data, and the sales data, calculating and displaying the inventory turnover months, which is an index theoretically calculated to indicate how many months it will take to consume the planned inventory for the product taking into account the current order quantity, by calculating inventory turnover months = current inventory quantity for the product + planned inventory quantity for receipt and delivery + current order quantity / average sales quantity for a predetermined month; An order determination method comprising:

7. An order determination program to be executed by an information processing device having a control unit, The control unit Inventory data including products and current stock quantities, Order data including product, expected shipping date, and order quantity; Order data including product, expected arrival date, and order quantity, Sales data including product, sales date, and sales quantity; It is configured to be accessible to Executed in the control unit: an order processing step of inputting an order slip including the product and the order quantity in response to an operation by a person in charge on an order input screen; an inventory turnover months calculation process for, when a product and order quantity are input on the order input screen, referring to the inventory data, the order data, the order data, the order data, and the sales data, calculating and displaying the inventory turnover months, which is an index theoretically calculated to indicate how many months it will take to consume the planned inventory for the product taking into account the current order quantity, by calculating inventory turnover months = current inventory quantity for the product + planned inventory quantity for receipt and delivery + current order quantity / average sales quantity for a predetermined month; An order decision program for executing the above.

Images