Inventory management device, inventory management method, and inventory management program

Abstract

To make it possible to grasp the accurate stocks of commodities within handling time limits.SOLUTION: A detection part refers to the inventory data on the basis of handling time limits added to a commodity to detect the stock quantity of the commodity for each handling time limit. A calculation part subtracts the number of commodity pieces already allocated or to be allocated from the number of stocked commodity pieces of each handling time limit to calculate the number of unallocated pieces of the commodity for each handling time limit. An allocation processing part performs allocation processing of the number of allocated commodity pieces from the number of unallocated commodity pieces of the minimum handling time limit among the handling time limits on and after the reference date which is a designated date. A data generation part generates allocation result data including at least a handling time limit, an allocated number, and a carried-forward number, which is a number obtained by subtracting the allocated number from an unallocated number, of the commodity of which the stocked number is detected. An output control unit outputs the generated allocation result data for display, printing, or the like.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to an inventory management device, an inventory management method, and an inventory management program.

Background Art

[0002] These days, in many cases, when receiving an order for a product, the available inventory quantity at the time of shipment is confirmed, and a shipment determination and a production determination are made.

[0003] As background art related to inventory management, Patent Document 1 (Japanese Patent Application Laid-Open No. 2023-018105) discloses a system for optimizing product inventory by intelligent adjustment of inbound purchase orders.

[0004] This system includes a process of receiving a demand forecast quantity including the demand forecast quantity of each product over each unit time, and a process of receiving supplier statistical data of a supplier associated with a part of a product corresponding to one or more product identifiers. Further, it includes a process of receiving the current product inventory level and the current product order quantity of the product, and a process of determining the preliminary order quantity of the product. Further, based on at least the supplier statistical data, the current product inventory level, and the current order quantity, a process of restricting the preliminary order quantity so as to obtain a recommended order quantity, and a process of generating a purchase order to the supplier of the product based on the recommended order quantity are provided. And by executing these processes, optimization of product inventory by intelligent adjustment of inbound purchase orders is achieved.

Prior Art Documents

Patent Documents

[0005]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0006] Here, conventionally, shipping judgments and manufacturing judgments have been made based on the transition of the total inventory (including planned shipments and planned production). In this way, when making shipping judgments and manufacturing judgments based on the transition of the total inventory, it is impossible to determine whether the current inventory is valid inventory within the handling deadline (such as the shipping deadline or the expiration date), so there has been a problem that it is difficult for sales staff or business staff to grasp the accurate inventory of products.

[0007] The present invention has been made in view of the above problems, and an object thereof is to provide an inventory management device, an inventory management method, and an inventory management program that enable accurate inventory of products within the handling deadline to be grasped.

Means for Solving the Problems

[0008] In order to solve the above problems and achieve the object, the inventory management device according to the present invention includes a detection unit that detects the inventory quantity of products for each handling deadline by referring to inventory data based on the handling deadline attached to the products, a calculation unit that subtracts the quantity of products already reserved or planned to be reserved from the inventory quantity of products for each handling deadline to calculate the unreserved quantity for each product for each handling deadline, a reservation processing unit that performs reservation processing on the reservation quantity of products by subtracting the reservation quantity of products from the unreserved quantity of products with the minimum handling deadline among the handling deadlines after the reference date which is the specified date, a data generation unit that generates reservation result data including at least the handling deadline, the reservation quantity, and the carry-over quantity which is the number obtained by subtracting the reservation quantity from the unreserved quantity for each product whose inventory quantity has been detected, and an output control unit that performs output control on the generated reservation result data.

[0009] Also, in order to solve the above problems and achieve the object, the inventory management method according to the present invention includes a detection step in which a detection unit refers to inventory data based on the expiration date attached to a product to detect the inventory quantity of the product for each expiration date; a calculation step in which a calculation unit subtracts the quantity of products already reserved or scheduled to be reserved from the inventory quantity of the products for each expiration date to calculate the unreserved quantity for each product for each expiration date; a reservation processing step in which a reservation processing unit performs a reservation process on the reservation quantity of the product from the unreserved quantity of the product with the minimum expiration date among the expiration dates after the reference date which is the specified date; a data generation step in which a data generation unit generates reservation result data including, for each product for which the inventory quantity has been detected, at least the expiration date, the reservation quantity, and the carry-over quantity which is the number obtained by subtracting the reservation quantity from the unreserved quantity; and an output control step in which an output control unit performs output control on the generated reservation result data.

[0010] Also, in order to solve the above problems and achieve the object, the inventory management program according to the present invention causes a computer to function as a detection unit that refers to inventory data based on the expiration date attached to a product to detect the inventory quantity of the product for each expiration date; a calculation unit that subtracts the quantity of products already reserved or scheduled to be reserved from the inventory quantity of the products for each expiration date to calculate the unreserved quantity for each product for each expiration date; a reservation processing unit that performs a reservation process on the reservation quantity of the product from the unreserved quantity of the product with the minimum expiration date among the expiration dates after the reference date which is the specified date; a data generation unit that generates reservation result data including, for each product for which the inventory quantity has been detected, at least the expiration date, the reservation quantity, and the carry-over quantity which is the number obtained by subtracting the reservation quantity from the unreserved quantity; and an output control unit that performs output control on the generated reservation result data.

Effects of the Invention

[0011] The present invention can make it possible to grasp the accurate inventory of products within the expiration date.

Brief Description of the Drawings

[0012]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Figure 20

Figure 21

Figure 22

Figure 23

Figure 24

Figure 25

Figure 26

Figure 27

Figure 28

Figure 29

Figure 30

Figure 31

Figure 32

Figure 33

Figure 34

Figure 35

Figure 36

Figure 37

Figure 38

Figure 39

Figure 40

Figure 41

Figure 42

Figure 43

Figure 44

Figure 45

Figure 46

Figure 47

Figure 48

Figure 49

Figure 50

Figure 51

Figure 52

Figure 53

Figure 54

Figure 55

Figure 56

Figure 57

Figure 58

Figure 59

Figure 60

Figure 61

Figure 62

Figure 63

Figure 64

Figure 65

Figure 66

Figure 67

Figure 68

Figure 69

Figure 70

DETAILED DESCRIPTION OF THE INVENTION

[0013] Hereinafter, an inventory management device according to an embodiment to which the present invention is applied will be described in detail with reference to the drawings. Note that the present invention is not limited to the following embodiments.

[0014] (Hardware Configuration) As shown in FIG. 1, the inventory management device 1 according to the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. As the output device 7, a display unit such as a monitor device (including a home TV), a printing device, or a speaker device corresponds. As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, a monitor device that cooperates with the mouse device to realize a pointing device function can be used. The communication interface unit 4 is connected to a network such as a wide area network such as the Internet or a private network such as a LAN (Local Area Network).

[0015] As the storage unit 2, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used. The storage unit 2 stores an inventory management program for performing inventory management based on the handling deadline (such as the shipping deadline or the expiration date) of the product.

[0016] Also, although details will be described later, the storage unit 2 stores or forms inventory data, order receiving data, manufacturing receipt schedule data, manufacturing delivery schedule data, SIM order receiving data, SIM manufacturing delivery schedule data, SIM manufacturing receipt schedule data, simulation order receiving data, simulation delivery schedule data, simulation receipt schedule data, reserved inventory work, order receiving data work, manufacturing delivery schedule data work, result display screen work (initial), result display screen work, etc.

[0017] FIG. 2 is a diagram showing an example of inventory data. The inventory data includes a product code, a lot number (Lot No.), the current inventory quantity, the shipping deadline, the expiration date, and the inventory rank of each product. The shipping deadline and the expiration date are examples of the handling deadline. In this example, the handling of each product is performed in a so-called "lot unit" with a plurality of products as one handling unit. Note that each product may be handled individually.

[0018] The shipping deadline is information indicating the date on which the product can be shipped. The expiration date is information indicating the date (year, month, and day) on which the product can function effectively. Also, the inventory rank corresponds to the "quality" of the product. In this example, the product with an inventory rank of "A rank" has a higher quality than the product with an inventory rank of "B rank".

[0019] FIG. 3 is a diagram showing an example of order receiving data. As shown in FIG. 3, the order receiving data includes an order receiving slip number, a line number, a scheduled shipping date, a product code, the order receiving quantity, a lot number, an inventory rank, and a branch number.

[0020] FIG. 4 is a diagram showing an example of manufacturing receipt schedule data. As shown in FIG. 4, the manufacturing receipt data includes a manufacturing instruction slip number, a manufacturing delivery date, a product code, the received instruction quantity, a lot number, an inventory rank, the shipping deadline, and the expiration date.

[0021] FIG. 5 is a diagram showing an example of manufacturing payout schedule data. As shown in FIG. 5, the manufacturing payout schedule data includes a manufacturing instruction slip number, a line number, a scheduled manufacturing date, a product code, the scheduled payout quantity, a lot number, an inventory rank, and a branch number.

[0022] (Functional Configuration of Business Support Device) Next, the control unit 3 functions as a display control unit 21, an extraction unit 22, a calculation unit 23, a data generation unit 24, and a memory control unit 25 as shown in FIG. 1 by executing an inventory management program stored in the memory unit 2.

[0023] The display control unit 21 is an example of an output control unit, and it displays, via an output device 7 which is an example of a display unit, a product inventory plan inquiry screen, a product inventory plan inquiry schedule adjustment screen, appropriation result data, etc. which will be described later. Hereinafter, although the description will proceed on the assumption that the output control unit is the display control unit 21, a printing control unit may be provided as the output control unit to print and output the appropriation result data, etc. on a predetermined sheet.

[0024] The extraction unit 22 is an example of a detection unit, and it refers to the inventory data based on the handling deadline (for example, the shipping deadline and the expiration date) added to the product, thereby detecting the inventory quantity of the product for each handling deadline.

[0025] The calculation unit 23 subtracts the number of appropriated or planned-to-be-appropriated products from the inventory quantity of the product for each handling deadline, thereby calculating the unappropriated quantity for each product for each handling deadline.

[0026] The storage control unit 25 is an example of an appropriation processing unit, and it performs an appropriation process on the appropriation quantity of the product from the unappropriated quantity of the product with the minimum handling deadline among the handling deadlines after the reference date which is the date specified by the operator.

[0027] The data generation unit 24 generates appropriation result data including the carry-over quantity which is the number obtained by subtracting the appropriation quantity from at least the handling deadline, the appropriation quantity, and the number obtained by subtracting the appropriation quantity from the unappropriated quantity for each product for which the inventory quantity has been detected. This appropriation result data is displayed by the display control unit 21 via the output device 7.

[0028] Also, the storage control unit 25 which is an example of an appropriation processing unit performs an appropriation process for each day corresponding to the number of days of the period from the reference date when a period of a predetermined number of days from the reference date is specified together with the reference date. The data generation unit 24 generates appropriation result data for each day of the appropriation process. Thereby, the daily appropriation result data which is the result of the appropriation process for each day corresponding to the number of days of the period from the reference date is displayed by the display control unit 21.

[0029] In the following description of the embodiments, the reserved quantity of the product will be described as the order reservation quantity corresponding to the order received quantity of the product, or the manufacturing disbursement reservation quantity corresponding to the manufacturing disbursement quantity. Further, the "product" is handled in lot units where a predetermined number of products are grouped together and a handling expiration date and a lot number are added. For this reason, the storage control unit 25, which is an example of the reservation processing unit, performs reservation processing based on the number of lots of products with the same lot number attached.

[0030] Also, the extraction unit 22, which is an example of the detection unit, refers to the manufacturing reception planned data including the acceptance instruction number, which is the number of products to be delivered by the specified manufacturing delivery date, and detects the number of products received in the manufacturing within the period including the reference date. The storage control unit 25, which is an example of the reservation processing unit, performs reservation processing for the reserved quantity of the product based on the number of products received in the manufacturing. Further, the data generation unit 24 generates reservation result data including the number of products received in the manufacturing on the date of manufacturing reception as the reservation result data for the date of manufacturing reception within the specified period described above.

[0031] Also, the extraction unit 22, which is an example of the detection unit, generates data indicating the inventory quantity of the product for each handling expiration date detected by referring to the inventory data, and "lot undetermined" data indicating that the inventory quantity is "0", the handling expiration date is blank, and the lot number for which reservation processing is to be performed is undetermined. The storage control unit 25, which is an example of the reservation processing unit, performs reservation processing from the "lot undetermined" inventory quantity when the inventory quantity of the product is less than the reserved quantity. Then, the data generation unit 24 generates reservation result data indicating that reservation processing has been performed from the "lot undetermined" inventory quantity.

[0032] Also, the data generation unit 24 generates SIM order data for simulation, which includes the scheduled shipment date, the order received quantity, and the update flag, SIM manufacturing disbursement planned data for simulation, which includes the scheduled manufacturing date, the planned disbursement quantity, and the update flag, and SIM manufacturing reception planned data for simulation, which includes the manufacturing delivery date, the acceptance instruction number, the handling expiration date, and the update flag.

[0033] A display control unit 21, which is an example of an output control unit, displays, via an output device 7, simulation order data corresponding to SIM order data, simulation payout schedule data corresponding to SIM manufacturing payout schedule data, and simulation receipt schedule data corresponding to SIM manufacturing receipt schedule data when an adjustment for simulation is instructed. At least the scheduled shipment date, the scheduled manufacturing date, or the manufacturing lead time of this simulation order data, simulation payout schedule data, and simulation receipt schedule data can be changed to desired values respectively.

[0034] When the scheduled shipment date is changed by an operation, the data generation unit 24 changes the scheduled shipment date of the SIM order data and changes the update flag to a value indicating that the scheduled shipment date has been changed. Further, when the scheduled manufacturing date is changed by an operation, the data generation unit 24 changes the scheduled manufacturing date of the SIM manufacturing payout schedule data and changes the update flag to a value indicating that the scheduled manufacturing date has been changed. Further, when the manufacturing lead time is changed by an operation, the data generation unit 24 changes the manufacturing lead time of the SIM manufacturing receipt schedule data and changes the update flag to a value indicating that the manufacturing lead time has been changed.

[0035] When the shipment scheduled date of the SIM order data is changed and the execution of the simulation is instructed, the memory control unit 25, which is an example of the appropriation processing unit, cancels the appropriation result of the order quantity before the change of the shipment scheduled date, and appropriates the order quantity of the product as the appropriation quantity from the unappropriated quantity of the product with the minimum handling deadline among the handling deadlines after the changed shipment scheduled date of the SIM order data. Also, when the manufacturing scheduled date of the SIM manufacturing disbursement scheduled data is changed and the execution of the simulation is instructed, the memory control unit 25 cancels the appropriation result of the disbursement scheduled quantity before the change of the manufacturing scheduled date, and appropriates the disbursement scheduled quantity of the product as the appropriation quantity from the unappropriated quantity of the product with the minimum handling deadline among the handling deadlines after the changed manufacturing scheduled date of the SIM manufacturing disbursement scheduled data. Further, when the manufacturing delivery date of the SIM manufacturing receipt scheduled data is changed and the execution of the simulation is instructed, the memory control unit 25 cancels the appropriation result before the change of the manufacturing delivery date, and performs an appropriation process based on the manufacturing receipt quantity received on the manufacturing delivery date. The display control unit 21 displays the result of such a simulation as the above-described appropriation result data via the output device 7.

[0036] Also, when the execution of the appropriation confirmation process for updating the actual data with the result of the simulation is specified, the memory control unit 25 detects the data including the above-described update flag indicating that the value has been changed among the SIM order data, the SIM manufacturing disbursement scheduled data, and the SIM manufacturing receipt scheduled data. Then, the memory control unit 25 updates the order data, the manufacturing disbursement scheduled data, or the manufacturing receipt scheduled data, which are the actual data stored in the memory unit 2, based on the detected SIM order data, SIM manufacturing disbursement scheduled data, or SIM manufacturing receipt scheduled data.

[0037] Also, when another shipment scheduled date, manufacturing scheduled date, or manufacturing delivery date is additionally specified as the shipment scheduled date, manufacturing scheduled date, or manufacturing delivery date, the extraction unit 22, which is an example of the detection unit, detects the order data corresponding to the additionally specified other shipment scheduled date, detects the manufacturing disbursement scheduled data corresponding to the additionally specified other manufacturing scheduled date, or detects the manufacturing receipt scheduled data corresponding to the additionally specified other manufacturing delivery date.

[0038] The display control unit 21 performs output control by using the record of the order receiving data corresponding to the detected other scheduled shipment dates as an additional record of the simulated order receiving data. Alternatively, the display control unit 21 performs output control by using the record of the manufacturing disbursement scheduled data corresponding to the detected other scheduled manufacturing dates as an additional record of the simulated disbursement scheduled data. Alternatively, the storage control unit 25 performs output control by using the record of the manufacturing acceptance scheduled data corresponding to the detected other manufacturing lead times as an additional record of the simulated acceptance scheduled data.

[0039] Hereinafter, the specific operation of the inventory management apparatus 1 of such an embodiment will be described.

[0040] (Display process of product inventory plan inquiry screen) First, the inventory management apparatus 1 of the embodiment checks the inventory quantity of products that can be shipped on the scheduled shipment date. In this case, for example, an operator such as the sales department or the manufacturing department operates the input device 6 to specify an operation to display the product inventory plan inquiry screen. When this operation is performed, the control unit 3 functions as the display control unit 21 based on the inventory management program stored in the storage unit 2, and displays the product inventory plan inquiry screen illustrated in FIG. 6 via the output device 7.

[0041] This product inventory plan inquiry screen is an inquiry screen for checking the inventory quantity of products that can be shipped on a desired scheduled shipment date. The operator inputs extraction conditions such as the product code, inventory rank, reference date, and period of the product scheduled for shipment to this product inventory plan inquiry screen, and operates the inquiry execution button 50. This example in FIG. 6 is an example in which extraction conditions of a product code of "S001", an inventory rank of "A", a reference date of "October 1, 2022", and a period of "3 days" are input. The display control unit 21 reads out the product name of "Product A" corresponding to the product code of "S001" from a product master (not shown) and displays it adjacent to the product code of "S001". Further, when "A" is input for the inventory rank, the display control unit 21 displays the character "Rank A product" adjacent to the input field of this inventory rank.

[0042] The "reference date" is the date on which the inventory quantity of the product is confirmed and the inventory appropriation process is carried out. The "period" is the number of days from this reference date for which the inventory quantity is confirmed and the inventory appropriation process is carried out. That is, when the reference date is specified as "October 1, 2022" and the period is specified as "3 days", it means that the three days from "October 1, 2022" to "October 3, 2022" are the dates for inventory confirmation and also the dates subject to the inventory appropriation process.

[0043] Note that the input information in the input fields such as product code, inventory rank, reference date, and period is cleared by the display control unit 21 when the screen clear button 53 is operated. Also, at this stage of inventory confirmation, the adjustment button 51 and the appropriation confirmation button 52 are controlled by the display control unit 21 to be in an inoperable state.

[0044] (Initial processing of the appropriation result screen work (grasping the unappropriated quantity of inventory information)) Next, when the extraction conditions are input and the query execution button 50 is operated, the initial processing of the appropriation result screen work outlined in FIG. 7 is performed.

[0045] In the initial processing of the appropriation result screen work, first, based on the extraction conditions input on the product inventory plan query screen, the current inventory information is extracted. That is, when the above-mentioned extraction conditions are input on the product inventory plan query screen and the query execution button 50 is operated, the control unit 3 functions as the extraction unit 22 based on the inventory management program, and extracts the inventory data with the product code "S001" and the inventory rank "A rank" from the inventory data shown in FIG. 2.

[0046] When inventory data corresponding to the extraction conditions is extracted, the control unit 3 functions as the storage control unit 25 based on the inventory management program, and stores and controls (insert: insert) the extracted inventory data in the appropriation inventory work illustrated in FIG. 8, which is a storage area formed in the storage unit 2. The appropriation inventory work stores the product code, lot number (lot No.), current inventory quantity, shipping deadline, expiration date, and inventory rank of the extracted inventory data. In addition, an input field for the unappropriated quantity is provided in the appropriation inventory work. The storage control unit 25 inputs the current inventory quantity of the extracted inventory data into this input field for the unappropriated quantity.

[0047] Next, in the case of an order receipt or production payout, products for which the lot number has already been specified are extracted and subtracted from the current inventory quantity.

[0048] That is, the extraction unit 22 refers to the order receipt data illustrated in FIG. 3 and extracts the order receipt data to which the lot number is added. In the case of the example in FIG. 3, for the order receipt data with a product code of "S001", an inventory rank of "A", and an order receipt quantity of "50 lots", the lot number of "L004" is attached. This indicates that the product has already been lot-specified by the order receipt. Therefore, the extraction unit 22 extracts the order receipt data to which the lot number of "L004" is attached. The storage control unit 25 stores and controls the extracted order receipt data in the first work (order receipt data), which is a storage area of the storage unit 2, as shown in FIG. 9(a).

[0049] In addition, the control unit 3 functions as the data generation unit 24 based on the inventory management program, and generates order receipt data obtained by aggregating the order receipt quantity of the order receipt data stored in the first work (order receipt data) by product code and lot number, as shown in FIG. 9(b). The storage control unit 25 stores and controls this order receipt data in the second work (order receipt data).

[0050] Next, the extraction unit 22 refers to the production payout schedule data illustrated in FIG. 5 and extracts the production payout schedule data with a lot number added. In the case of the example in FIG. 5, for the production payout schedule data with a product code of "S001", an inventory rank of "A", and a payout schedule quantity of "30 lots", a lot number of "L002" is attached. This indicates that it is a product for which a lot has already been specified due to production payout. Therefore, the extraction unit 22 extracts the production payout schedule data with this lot number "L002" attached. The storage control unit 25 stores and controls the extracted production payout schedule data in the first work (production payout schedule data), which is the storage area of the storage unit 2, as shown in FIG. 10(a).

[0051] Also, the data generation unit 24 generates production payout schedule data obtained by aggregating the payout schedule quantities of the production payout schedule data stored in the first work (production payout schedule data) by product code and lot number, as shown in FIG. 9(10). The storage control unit 25 stores and controls this production payout schedule data in the second work (production payout schedule data).

[0052] Next, the control unit 3 functions as the calculation unit 23 based on the inventory management program, and detects, from the inventory data in the allocation inventory work shown in FIG. 11, the inventory data corresponding to the lot number "L004" shown in FIG. 9(b). Then, the received order quantity of the order received data with the lot number "L004" shown in FIG. 9(b) is subtracted from the unallocated quantity of the inventory data corresponding to the lot number "L004". That is, in the case of this example, the unallocated quantity of the inventory data with the lot number "L004" is "60 lots" (see FIG. 8), and the received order quantity of the order received data with the lot number "L004" shown in FIG. 9(b) is "50 lots". Therefore, the calculation unit 23 performs the calculation of "unallocated quantity of inventory data 60 lots - received order quantity of order received data 50 lots = 10 lots".

[0053] Similarly, the calculation unit 23 detects, from the inventory data in the reserved inventory work shown in FIG. 11, the inventory data corresponding to the lot number of "L002" shown in FIG. 10(b). Then, the calculation unit 23 subtracts the planned payout quantity of the manufacturing payout planned data with the lot number of "L002" shown in FIG. 10(b) from the unallocated quantity of the inventory data corresponding to the lot number of "L002". That is, in the case of this example, the unallocated quantity of the inventory data with the lot number of "L002" is "40 lots" (see FIG. 8), and the planned payout quantity of the manufacturing payout planned data with the lot number of "L002" shown in FIG. 10(b) is "30 lots". Therefore, the calculation unit 23 performs an operation of "unallocated quantity of inventory data 40 lots - planned payout quantity of manufacturing payout planned data 30 lots = 10 lots".

[0054] As shown in FIG. 11, the memory control unit 25 reflects the above calculation result on the unallocated quantities of the lot numbers of "L004" and "L002" in the reserved inventory work. As a result, the unallocated quantity of the lot number of "L004" in the reserved inventory work becomes "10 lots", and the unallocated quantity of the lot number of "L002" also becomes "10 lots".

[0055] Next, based on the reserved inventory work in which the above calculation result is reflected on the unallocated quantity, the data generation unit 24 generates the result display screen data (initial) shown in FIG. 12. This result display screen data (initial) is composed of date, lot number, inventory rank, shipping deadline, expiration date, unallocated quantity, variable quantity, carry-over quantity, order reservation quantity, order reservation completed quantity, manufacturing payout reservation quantity, manufacturing payout reservation completed quantity, manufacturing receipt quantity, and product code, etc.

[0056] The data generation unit 24 generates the result display screen data (initial) shown in FIG. 12 by sorting the inventory data in the reserved inventory work shown in FIG. 11 in ascending order of the shipping deadline. As a result, although it is an image, as shown in FIG. 12, the result display screen data (initial) in the form of arranging the inventory data along the column direction in ascending order of the shipping deadline is generated. Note that the data generation unit 24 inputs (sets) the corresponding unallocated quantity for the carry-over quantity.

[0057] The memory control unit 25 stores and controls such result display screen data (initial) in the result display screen work (initial), which is a memory area formed in the memory unit 2. As a result, as shown in FIG. 12, result display screen data (initial) for "October 1, 2022", which is specified by the operator as the reference date, is generated. The display control unit 21 displays this result display screen data (initial) in the result display area 55 of the manufacturing inventory plan inquiry screen shown in FIG. 6.

[0058] (Loop process for the set period from the reference date) Next, when the initial processing of such an allocation result screen work is completed, the control unit 3 performs the following loop process for the period from the reference date input on the manufacturing inventory plan inquiry screen based on the inventory management program. FIG. 13 shows an overview of such a loop process.

[0059] 1. First, prepare the data for the corresponding day (however, only for the reference date, use the result display screen work (initial) as the data extraction basis). Extraction conditions: Date of the result display screen work = maximum (date of the result display screen work), and insert the records extracted with lot No. <> lot undetermined into itself with the date = the corresponding day. The extraction unit 22 extracts data based on the extraction conditions, and the memory control unit 25 performs the insert process.

[0060] 2. Next, perform an inventory addition process based on the manufacturing receipt schedule data (extract from the SIM manufacturing receipt schedule data during simulation). The extraction unit 22 extracts the manufacturing receipt schedule data based on the extraction conditions that the manufacturing due date of the manufacturing receipt schedule data = the corresponding day, the product code of the manufacturing receipt schedule data = the product code of the result display screen work, and the product rank of the manufacturing receipt schedule data = the product rank of the result display screen work. Note that since the planned acceptance data for manufacturing cannot be accepted if payment cannot be made, it is assumed that the lot numbers on the payment side can be reserved. Also, at the timing of extracting this planned acceptance data for manufacturing, the memory control unit 25 updates the SIM planned acceptance data for manufacturing for simulation, which will be described later.

[0061] 3. Next, perform the reservation process based on the order data. In this case, first, the extraction unit 22 extracts the order data (extracted from the SIM order data during simulation). The extraction conditions are as follows: the planned shipment date of the order data = the current date, the lot number of the order data = null data, the product code of the order data = the product code of the result display screen work, and the product rank of the order data = the product rank of the result display screen work (update the SIM order data at this timing for simulation).

[0062] Next, the data generation unit 24 performs the reservation process in the order of the order slip numbers for the extracted order data. The data generation unit 24 identifies the reservation target based on the conditions: "the expiration date of the result display screen work >= the current date and the shipment date is the earliest, and the carry-over quantity of the result display screen work > 0 (when multiple records are obtained with the same expiration date, select the one with the smallest lot No)".

[0063] Next, perform the update process for the result display screen work. This update process is performed by the memory control unit 25 setting the unreserved order quantity to the reserved order quantity. However, the unreserved quantity on the result display screen work is maximized. Also, this update process is performed by the memory control unit 25 setting the variable to "reserved order quantity × (-1)". Furthermore, this update process is performed by the memory control unit 25 setting the carry-over quantity to the unreserved quantity + the variable.

[0064] Next, perform the update process for the order data work. This update process is performed by the memory control unit 25 setting the reserved quantity to the reserved order quantity of the result display screen work. Further, this update process is performed by the calculation unit 23 subtracting the reserved quantity from the unreserved quantity, and the memory control unit 25 setting the value obtained by this subtraction process. Furthermore, the update process is performed by the memory control unit 25 setting the lot No. to the lot number.

[0065] Next, an addition process for the order-receiving data work is performed. The condition is that the unreserved quantity <> 0. For records where the unreserved quantity <> 0, the process returns to the process of "performing the reservation process in the order of the order-receiving slip numbers for the extracted data" and re-executes the process for the unreserved quantity.

[0066] 4. Perform the reservation process based on the planned manufacturing payout data. In this case, first, the extraction unit 22 extracts the planned manufacturing payout data based on the extraction conditions of "the planned manufacturing date of the planned manufacturing payout data = the current date, and the lot number of the planned manufacturing payout data = null data, and the product code = the product on the result display screen work, and the inventory rank of the planned manufacturing payout data = the inventory rank of the result display screen work".

[0067] Note that at the timing of extracting this planned manufacturing payout data, the SIM planned manufacturing payout data for simulation, which will be described later, is updated. Also, the extraction unit 22 extracts the planned manufacturing payout data based on the SIM planned manufacturing payout data during simulation.

[0068] Next, the data generation unit 24 performs the reservation process on the manufacturing instruction slip using the extracted planned manufacturing payout data. The conditions for the reservation target are "the shipping deadline of the result display screen work ≧ the current date and the shipping date is the earliest, and the carry-over quantity of the result display screen work > 0". Note that when a plurality of records with the same shipping deadline are acquired, the reservation process is performed on the one with the smallest lot number among them.

[0069] Next, the memory control unit 25 performs the update process on the result display screen work. In this case, first, the memory control unit 25 sets the manufacturing payout reserved amount to the manufacturing payout unreserved amount. However, the unreserved amount in the result display screen work is maximized. As an exception, when the lot number = lot undetermined, the order unreserved amount is set as it is. Also, the memory control unit 25 sets "manufacturing payout reserved amount × (-1)" to the variable amount. Also, the memory control unit 25 sets "unreserved amount + variable amount" to the carry-over amount.

[0070] Next, the memory control unit 25 performs an update process on the manufacturing payout scheduled data work. In this case, the memory control unit 25 sets the manufacturing payout reserved amount in the result display screen work to the reserved amount. Also, the calculation unit 23 subtracts the reserved amount from the unreserved amount, and the memory control unit 25 sets the value after this subtraction process. Also, the memory control unit 25 sets the lot number.

[0071] Next, the memory control unit 25 performs an addition process on the manufacturing payout scheduled data work. The condition for this addition process is "unreserved amount <> 0".

[0072] For records where "unreserved amount <> 0", the process returns to the process of "performing a reservation process on the manufacturing instruction slip with the extracted manufacturing payout scheduled data" and the process for the unreserved amount is executed again.

[0073] 5. Next, the memory control unit 25 performs a reflection process on the reserved order data at the reference time point. In this case, the extraction unit 22 extracts the order data whose scheduled shipment date in the first work (order data) = the current date. Based on the lot number of the first work (order data) and the product code of the first work (order data), the memory control unit 25 updates the order quantity of the first work (order data) to the reserved order quantity in the result display screen work. As a result, the extracted order data can be reflected in the result display screen work.

[0074] 6. Next, the memory control unit 25 performs a reflection process on the manufacturing payout scheduled data at the reference time point. In this case, the extraction unit 22 extracts the manufacturing disbursement planned data with the manufacturing planned date of the first work 1 (manufacturing disbursement planned data) = the current date. The storage control unit 25 updates the planned disbursement quantity of the first work (manufacturing disbursement planned data) to the already reserved quantity of manufacturing disbursement in the result display screen work based on the lot number of the first work (manufacturing disbursement planned data) and the product code of the first work (manufacturing disbursement planned data).

[0075] 7. When such loop processing ends in the period from the reference date input on the manufacturing inventory plan inquiry screen, the display control unit 21 displays the result display screen for the specified period in the result display area 55 of the manufacturing inventory plan inquiry screen.

[0076] Note that when displaying, the display control unit 21 does not display records that satisfy the conditions of unreserved quantity = 0, variable quantity = null data, carry - over quantity = 0, and order reservation quantity to manufacturing acceptance quantity = null data.

[0077] (Specific example of loop processing for the set period from the reference date) Next, a specific example of loop processing for the set period from such a reference date will be described. In this example, as shown in FIG. 6, it is assumed that the operator designates "S001", which is the product code of product A, and designates the inventory rank "A" indicating grade A products. Also, it is assumed that "October 1, 2022" is designated as the reference date and "3 days" is designated as the period.

[0078] (Processing on October 1 (reference date)) First, for October 1 (reference date), it is the data preparation process for the current date described in "1" above. As described above, the extraction unit 22 extracts with the extraction conditions of "result display screen work date = maximum (result display screen work date), and lot No. <> lot undetermined". Then, the storage control unit 25 inserts the extracted record into the result display screen work with the date = the current date (in this case, the reference date of October 1). Note that the storage control unit 25 also inserts records with lot undetermined into the result display screen work at this time.

[0079] Note that October 1 corresponds to the "reference date", and as shown in FIGS. 12 and 14, since there is data as the result display screen work (initial) (because it has been extracted), the selection unit 3 skips this data preparation process.

[0080] Next, it is the inventory addition process based on the manufacturing receipt schedule data described in "2". In this example, the extraction unit 22 extracts records corresponding to the extraction conditions of "manufacturing receipt schedule manufacturing delivery date = October 1, and product code = S001, and product rank = A" from the manufacturing receipt schedule data shown in FIG. 4. Note that in the case of the manufacturing receipt schedule data shown in FIG. 4, since there are no records corresponding to this extraction condition, no records are extracted.

[0081] Next, it is the appropriation process based on the order receiving data described in "3". In this example, the extraction unit 22 extracts order receiving data corresponding to the extraction conditions of "order receiving data scheduled shipment date = October 1, and order receiving data lot number = null, and product code = S001, and product rank = A" from the order receiving data shown in FIG. 3. In this case, the record with the order receiving slip number "J0000000001" and the order receiving quantity "20 lots" in the first column of FIG. 3 is extracted by the extraction unit 22 as the record that matches the extraction conditions.

[0082] The memory control unit 25 inserts the records extracted by the extraction unit 22 into the order receiving data work shown in FIG. 15. Also, at this timing, the memory control unit 25 updates the SIM order receiving data for simulation shown in FIG. 16 based on the records extracted by the extraction unit 22.

[0083] Next, appropriation processing is performed in the order of the order slip numbers using the extracted data. In this case, the extraction unit 22 extracts records that meet the extraction conditions of "the one with the minimum shipping date in the 'Shipping Deadline ≥ Target Date' of the result display screen work and the carry-over > 0 in the result display screen work" from the result display screen work as shown in FIG. 17. In the case of the example in FIG. 17, since the record in the second column is the record with the minimum shipping date after the reference date (the target date), the record with the lot number "L001" in the second column is extracted by the extraction unit 22.

[0084] Note that since the record in the first column of FIG. 17 has a shipping deadline that is earlier than the reference date (the target date) (September 20, 2022), no extraction is performed and it is not subject to appropriation.

[0085] Also, when no appropriation target is found (when there is no record to be appropriated), a record with "Lot Number = Lot Undetermined" is used as the appropriation target, and the "update process of the result display screen work" and the "update process of the order data work" described below are performed.

[0086] Next, the memory control unit 25 sets the unappropriated number of "20 lots" in the order data work shown in FIG. 15 for the order appropriation number of the record with the lot number "L001", which is the record in the second row of the result display screen work shown in FIG. 18, as the "update process of the result display screen work".

[0087] Also, the calculation unit 23 performs a calculation of "Order Appropriation Number × (-1) = -20 lots". The memory control unit 25 sets the calculated result of "-20 lots" for the variable number of the record with the lot number "L001", which is the record in the second row of the result display screen work shown in FIG. 18.

[0088] Furthermore, the memory control unit 25 sets the value of the outstanding quantity + variable quantity for the carry-over quantity of the record with the lot number "L001", which is the record on the second line of the result display screen work shown in FIG. 18. In the case of this example, since the outstanding quantity is "30 lots" and the variable quantity is "-20 lots", the calculation unit 23 performs an operation of "30 lots + (-20 lots) = 10 lots". The memory control unit 25 sets the value of "10 lots" as the calculation result for the carry-over quantity of the record with the lot number "L001".

[0089] Next, as the "update process of the order reception data work", the memory control unit 25 sets the lot number of "L001" as shown in FIG. 19 for the lot number of the order reception data work shown in FIG. 15. Also, as shown in FIG. 19, the memory control unit 25 sets the order reception appropriation quantity of "20 lots" in the result display screen work for the appropriation quantity of the order reception data work. Furthermore, the calculation unit 23 subtracts the appropriation quantity with "20 lots" set as shown in FIG. 19 from the outstanding quantity with the order reception quantity of "20 lots" set as shown in FIG. 15 (20 lots - 20 lots = 0 lots). The memory control unit 25 sets the calculated "0 lots" for the outstanding quantity of the order reception data work as shown in FIG. 19.

[0090] Next, it is the "appropriation process based on the manufacturing disbursement schedule data" described in "4". In the case of this example, the extraction unit 22 refers to the manufacturing disbursement schedule data shown in FIG. 5 and extracts the manufacturing disbursement schedule data that meets the extraction conditions of "manufacturing scheduled date of the manufacturing disbursement schedule data = October 1st, and lot number of the manufacturing disbursement schedule data = null data, and product code = S001, and product rank = A". In the case of the example in FIG. 5, there is no manufacturing disbursement schedule data that meets this extraction condition. Therefore, "no corresponding data" results, and no manufacturing disbursement schedule data is extracted.

[0091] Next, it is the "reflection process of the ordered sales data already reserved at the reference date and time" described in "5". In this example, the extraction unit 22 extracts the record with the scheduled shipment date = October 1st from the first work (ordered sales data) shown in Fig. 9(a). The memory control unit 25 updates the result display screen work based on the extracted record. However, there is no record with the scheduled shipment date = October 1st in the first work (ordered sales data) shown in Fig. 9(a). Therefore, it becomes "no corresponding data", and the update process of the result display screen work by the memory control unit 25 is not performed.

[0092] Next, it is the "reflection process of the planned manufacturing disbursement data at the reference date and time" described in "6". In this example, the extraction unit 22 extracts the record with the planned manufacturing date = October 1st from the first work (planned manufacturing disbursement data) shown in Fig. 10(a). The memory control unit 25 updates the result display screen work based on the extracted record. However, there is no record with the planned manufacturing date = October 1st in the first work (planned manufacturing disbursement data) shown in Fig. 10(a). Therefore, it becomes "no corresponding data", and the update process of the result display screen work by the memory control unit 25 is not performed.

[0093] The display content of the result display area 55 of the manufacturing inventory plan inquiry screen at this point is, although it is an image, as shown in Fig. 20, it becomes the display content corresponding to the date (reference date) of October 1st, 2022.

[0094] (Processing on October 2nd) Next, it is the data preparation process for the corresponding day described in "1" for October 2nd. As described above, the extraction unit 22 refers to the result display screen work shown in Fig. 18 and extracts the data that meets the extraction conditions of "the date of the result display screen work = maximum (the date of the result display screen work), and the lot No <> lot undetermined". As a result, the data of the result display screen work for October 1st shown in Fig. 18 is extracted.

[0095] The memory control unit 25 adds the date of October 2, 2022 (= the current day) to the date of the data of the result display screen work for October 1 that has been extracted, and inserts it into the result always screen work as shown in Fig. 21. At this time, the memory control unit 25 sets the carry-over number for the outstanding quantity of each record for October 2. Also, the memory control unit 25 clears (empties) the variable quantity, the order appropriation quantity, the appropriated order quantity, the manufacturing payment appropriation quantity, the appropriated manufacturing payment quantity, and the manufacturing receipt quantity of each record for October 2, respectively.

[0096] Next, it is the inventory addition process based on the manufacturing receipt planned data described in "2". In this example, the extraction unit 22 extracts the records corresponding to the extraction conditions of "manufacturing due date of manufacturing receipt plan = October 2, and product code = S001, and product rank = A" from the manufacturing receipt planned data shown in Fig. 4. Note that in the case of the manufacturing receipt planned data shown in Fig. 4, since there is no record corresponding to this extraction condition, the record extraction is not performed.

[0097] Next, it is the appropriation process using the order data described in "3". In this example, the extraction unit 22 extracts the order data corresponding to the extraction conditions of "scheduled shipment date of order data = October 2, and lot number of order data = null, and product code = S001, and product rank = A" from the order data shown in Fig. 3. In the case of the order data shown in Fig. 4, since there is no record corresponding to this extraction condition, the record extraction is not performed.

[0098] Next, it is the "appropriation process based on the manufacturing payment planned data" described in "4". In this example, the extraction unit 22 refers to the manufacturing payment planned data shown in Fig. 5 and extracts the manufacturing payment planned data that meets the extraction conditions of "manufacturing planned date of manufacturing payment planned data = October 2, and lot number of manufacturing payment planned data = null data, and product code = S001, and product rank = A". In the example of Fig. 5, the record with the manufacturing instruction slip number "SSZ00000003" and the order quantity of "40 lots" is extracted by the extraction unit 22 as the record that meets the extraction conditions.

[0099] The memory control unit 25 inserts the record extracted by the extraction unit 22 into the manufacturing disbursement schedule data work as shown in Fig. 22(a). Also, at this timing, the memory control unit 25 updates the SIM manufacturing disbursement schedule data for simulation as shown in Fig. 22(b) based on the record extracted by the extraction unit 22.

[0100] Next, an appropriation process is performed in the order of the manufacturing instruction slip numbers using the extracted data. In this case, the extraction unit 22 extracts records that meet the extraction condition of "the one with the minimum shipping date in the'result display screen work' where'shipping deadline ≥ the current date' and 'carry - over > 0'" from the result display screen work as shown in Fig. 23. In the example of Fig. 23, the record in the third column from the bottom is the record with the minimum shipping date after October 2, which is the current date. Therefore, the record with the lot number of "L002" is extracted by the extraction unit 22.

[0101] Note that for the records in the fifth column from the bottom and the fourth column from the bottom in Fig. 23, since the shipping deadlines are September 20 or October 1, which are dates before October 2 respectively, no extraction is performed and they are not subject to appropriation.

[0102] Also, when no appropriation target is found (when there is no record to extract), the record with "lot number = lot undetermined" becomes the target, and the "update process of the result display screen work" and the "update process of the order - receiving data work" described below are performed.

[0103] Next, as the "update process of the result display screen work", the memory control unit 25 sets the unappropriated number of "10 lots" in the record with the lot number of "L002", which is the record in the third row from the bottom of the result display screen work shown in Fig. 24, to the manufacturing disbursement appropriation number of the record with the lot number of "L002".

[0104] Further, the calculation unit 23 performs an operation of "manufacturing disbursement reserve number × (-1) = -10 lots". The memory control unit 25 sets this calculation result of "-10 lots" for the variable of the record with the lot number "L002", which is the record on the third line from the bottom of the result display screen work shown in FIG. 24.

[0105] Furthermore, the memory control unit 25 sets the value of the undesignated number + variable for the carry-over number of the record with the lot number "L002", which is the record on the third line from the bottom of the result display screen work shown in FIG. 24. In the case of this example, since the undesignated number is "10 lots" and the variable is "-10 lots", the calculation unit 23 performs an operation of "10 lots + (-10 lots) = 0 lots". The memory control unit 25 sets the value of "0 lots" as the calculation result for the carry-over number of the record on the third line from the bottom of the result display screen work shown in FIG. 24.

[0106] Next, as the "update process of the manufacturing disbursement planned data work", the memory control unit 25 sets the lot number "L002" for the lot number of the manufacturing disbursement planned data work shown in FIG. 25(a). Also, as shown in FIG. 25(a), the memory control unit 25 sets the order appropriation number of "10 lots" on the result display screen work for the appropriation number of the manufacturing disbursement planned data work. Further, the calculation unit 23 subtracts the appropriation number of "10 lots" set as shown in FIG. 25 from the undesignated number with the disbursement planned number of "40 lots" set as shown in FIG. 22(a) (40 lots - 10 lots = 30 lots). The memory control unit 25 sets the calculated "30 lots" for the undesignated number of the manufacturing disbursement planned data work as shown in FIG. 25(a).

[0107] Next, as shown in FIG. 25(b), the memory control unit 25 performs an addition process on the production payout schedule data work for the record with the production instruction slip number "SSZ00000003". At this time, the memory control unit 25 clears the lot number (makes it blank). Also, the memory control unit 25 increments the branch number by one to make it "2". Further, the memory control unit 25 sets the reserved quantity to "0". If the record has an unreserved quantity <> 0, the "reservation process in the order of production instruction slips with the extracted data" is executed again for the unreserved quantity.

[0108] FIG. 26 is a diagram showing an example of the result display screen work at this processing stage. In the example for October 2 shown in this FIG. 26, the variable quantities for the lot numbers "L002", "L004", and "lot undetermined" are "-10 lots", "-10 lots", and "-20 lots" respectively, the carry-over quantities are "0 lots", "0 lots", and "-20 lots" respectively, and the production payout reserved quantities are "10 lots", "10 lots", and "20 lots" respectively.

[0109] Correspondingly, as shown in FIG. 27, the memory control unit 25 stores, as the production payout schedule data for the lot numbers "L002", "L004", and "lot undetermined" with the production instruction slip numbers all being "SSZ00000003" and the branch numbers being "1", "2", and "3" respectively, the production payout schedule data with the payout scheduled quantities being "40 lots" respectively, the reserved quantities being "10 lots", "10 lots", and "20 lots" respectively, and the unreserved quantities being "30 lots", "20 lots", and "0 lots" respectively, in the production payout schedule data work.

[0110] Next, it is the "reflection process of the ordered sales data already appropriated at the reference date and time" described in "5". In this example, the extraction unit 22 extracts the record with the scheduled shipment date = October 2 of the first work (ordered sales data) shown in FIG. 9(a). The storage control unit 25 updates the result display screen work based on the extracted record. However, there is no record with the scheduled shipment date = October 2 in the first work (ordered sales data) shown in FIG. 9(a). Therefore, "no corresponding data" results, and the update process of the result display screen work by the storage control unit 25 is not performed.

[0111] Next, it is the "reflection process of the planned manufacturing disbursement data at the reference date and time" described in "6". In this example, the extraction unit 22 extracts the record with the planned manufacturing date = October 2 of the first work (planned manufacturing disbursement data) shown in FIG. 10(a). There is a record with the planned manufacturing date = October 2 in the first work (planned manufacturing disbursement data) shown in FIG. 10(a). Therefore, the extraction unit 22 extracts the record with the planned manufacturing date = October 2 as shown in FIG. 28.

[0112] The storage control unit 25 detects the record corresponding to the lot number "L002" of the record extracted from the first work (planned manufacturing disbursement data) among the records for October 2 of the result display screen work shown in FIG. 29. Then, the storage control unit 25 updates the already appropriated manufacturing disbursement number of the record corresponding to the lot number "L002" for October 2 of the result display screen work shown in FIG. 29 to the planned disbursement number of "30 lots" of the record with the lot number "L002" extracted from the first work (planned manufacturing disbursement data).

[0113] The display content of the result display area 55 of the manufacturing inventory plan inquiry screen at this point is, although it is an image, as shown in FIG. 30, the display content corresponding to the date of October 2, 2022. In FIG. 30, the carry-over number of "-20 lots" of "lot undetermined" for October 2 means that the lot cannot be appropriated, in other words, it means the occurrence of "out of stock".

[0114] (Processing on October 3) Next, it is the data preparation process for the corresponding day of October 3 as described in "1". As described above, the extraction unit 22 refers to the result display screen work shown in FIG. 18 and extracts data that meets the extraction conditions of "result display screen work date = maximum (result display screen work date), and lot No. <> lot undetermined". As a result, the data of the result display screen work for October 2 shown in FIG. 29 is extracted.

[0115] The memory control unit 25 adds the date of October 3, 2022 (= the corresponding day) to the date of the extracted result display screen work data for October 2, and inserts it into the result constant screen work as shown in FIG. 31. At this time, the memory control unit 25 sets the carry-over number for the undistributed quantity of each record for October 3. In addition, the memory control unit 25 clears (empties) the variable quantity, order appropriation quantity, appropriated order quantity, manufacturing payout appropriation quantity, appropriated manufacturing payout quantity, and manufacturing receipt quantity of each record for October 3.

[0116] Next, it is the inventory addition process based on the manufacturing receipt planned data described in "2". In this example, the extraction unit 22 extracts records corresponding to the extraction conditions of "manufacturing delivery date of manufacturing receipt plan = October 3, and product code = S001, and product rank = A" from the manufacturing receipt planned data shown in FIG. 4. As a result, the manufacturing receipt planned data with the manufacturing instruction slip number "SSZ00000001" and lot number "L005" shown in FIG. 32(a) is extracted.

[0117] Note that the memory control unit 25 updates the SIM manufacturing receipt planned data for simulation as shown in FIG. 32(b) based on the manufacturing receipt planned data extracted by the extraction unit 22 at this timing.

[0118] Next, the memory control unit 25 adds the record of the lot number of the extracted "L005" to the result display screen work as shown in FIG. 33. Also, as shown in FIG. 33, the memory control unit 25 sets "0 lots" to the unallocated quantity of the record with the lot number "L005" among the records for October 3. Further, the memory control unit 25 sets the acceptance instruction quantity of "100 lots" in the manufacturing acceptance schedule data shown in FIG. 32(a) to the variable quantity, carry-over quantity, and manufacturing acceptance quantity of the record with the lot number "L005" for October 3 in the result display screen work shown in FIG. 33, respectively.

[0119] Next, it is the allocation process based on the order data described in "3". In this example, the extraction unit 22 extracts the order data corresponding to the extraction conditions of "shipment scheduled date of the order data = October 3, and lot number of the order data = null, and product code = S001, and product rank = A" from the order data shown in FIG. 3. In the case of the order data shown in FIG. 4, since there is no record corresponding to this extraction condition, the record extraction is not performed.

[0120] Next, it is the "allocation process based on the manufacturing disbursement schedule data" described in "4". In this example, the extraction unit 22 refers to the manufacturing disbursement schedule data shown in FIG. 5 and extracts the manufacturing disbursement schedule data that matches the extraction conditions of "manufacturing scheduled date of the manufacturing disbursement schedule data = October 3, and lot number of the manufacturing disbursement schedule data = null data, and product code = S001, and product rank = A". In the case of the manufacturing disbursement schedule data shown in FIG. 5, since there is no record corresponding to this extraction condition, the record extraction is not performed.

[0121] Next, it is the "reflection process of the allocated order data at the reference date and time" described in "5". In this example, the extraction unit 22 extracts the record with the scheduled shipment date = October 3 of the first work (order data) shown in Fig. 9(a). The memory control unit 25 updates the result display screen work based on the extracted record. However, there is no record with the scheduled shipment date = October 3 in the first work (order data) shown in Fig. 9(a). Therefore, "no corresponding data" results, and the update process of the result display screen work by the memory control unit 25 is not performed.

[0122] Next, it is the "reflection process of the planned manufacturing disbursement data at the reference date and time" described in "6". In this example, the extraction unit 22 extracts the record with the planned manufacturing date = October 3 of the first work (planned manufacturing disbursement data) shown in Fig. 10(a). Since there is no record with the planned manufacturing date = October 3 in the first work (planned manufacturing disbursement data) shown in Fig. 10(a), the record extraction is not performed.

[0123] At this point, result display screen work is generated with result display screen data for a period of 3 days from October 1 to October 3, with October 1, 2022 as the reference date. The calculation unit 23 calculates the total number of unallocated quantities and carry-over quantities corresponding to each date from October 1 to October 3 based on this result display screen data. The display control unit 21 displays the result display screen data with the total number of unallocated quantities and carry-over quantities corresponding to each date from October 1 to October 3 added, in the result display area 55 of the manufacturing inventory plan inquiry screen, as shown in Fig. 35.

[0124] In Fig. 35, as described above, the carry-over quantity of "-20 lots" for October 2, which is "lot undetermined", means that the lot cannot be allocated. In other words, it means the occurrence of "stockouts".

[0125] Note that the display control unit 21 does not display records that meet the conditions of unallocated quantity = 0, variable quantity = null, carry-over quantity = 0, and null from the order allocation quantity to the manufacturing receipt quantity on the manufacturing inventory plan inquiry screen.

[0126] (Simulation process) Next, when a shortage occurs as described above, the inventory management device 1 of the embodiment can simulate the appropriation status when the production instruction plan is changed and the appropriation status when the shipment date is changed, respectively. As a result, it is possible to cope with shortages.

[0127] (Simulation process for changing the production instruction plan) First, a case where a simulation for changing the production instruction plan is performed because a shortage has occurred will be described. FIG. 36 is a diagram showing an example of a production inventory plan inquiry screen. When the display control unit 21 displays the display content shown in FIG. 37 in the result display area 55 of this production inventory plan inquiry screen, the input fields for the product code, inventory rank, reference date, and period are set to a locked state so that they cannot be re-entered.

[0128] When unlocking the input fields (when re-entering), the operator operates the screen clear button 53. As a result, the input information in the input fields for the product code, inventory rank, reference date, and period is cleared (becomes an unentered state), and the display content in the result display area 55 is also cleared (becomes non-displayed).

[0129] Next, for example, when changing the production delivery date to October 2, the operator selects and operates the record of October 2, 2022, which is the shortage occurrence date, among the display content displayed in the result display area 55, and then operates the adjustment button 51. As a result, the display control unit 21 displays the production inventory plan inquiry schedule adjustment screen shown in FIG. 38 on the output device 7 instead of the production inventory plan inquiry screen. This production inventory plan inquiry schedule adjustment screen includes a data addition assistance area equipped with an order addition button 57, a payment schedule addition button 58, and a receipt schedule addition button 59, as well as display columns for simulation order data, simulation payment schedule data, and simulation receipt schedule data.

[0130] The display control unit 21 reads out the SIM order-receiving data shown in Fig. 39(a), the SIM manufacturing disbursement schedule data shown in Fig. 39(b), and the SIM manufacturing reception schedule data shown in Fig. 39(c) from the storage unit 2, and displays them in the display columns for the simulated order-receiving data, the simulated disbursement schedule data, and the simulated reception schedule data on the manufacturing inventory plan inquiry schedule adjustment screen as shown in Fig. 38, respectively.

[0131] In addition, when there are multiple pieces of simulated order-receiving data, simulated disbursement schedule data, or simulated reception schedule data, the display control unit 21 arranges and displays the multiple pieces of data in the column direction. Although scroll bars corresponding to each piece of data are shown in Fig. 38, these scroll bars are for the operator to perform a scroll display operation on the multiple pieces of data.

[0132] Next, since this example is an example of performing a simulation to change the manufacturing delivery date to October 2nd, the operator changes the manufacturing delivery date of the simulated reception schedule data, which has been "October 3, 2022" until now, to "October 2, 2022" as shown in Fig. 40 and operates the confirmation button 61.

[0133] Note that this example is an example of bringing forward the manufacturing delivery date of the manufacturing reception schedule data. In addition to this, the scheduled shipment date of the order-receiving data may be postponed, or the scheduled manufacturing date of the manufacturing disbursement schedule data may be postponed.

[0134] Also, for the simulated order-receiving data, it is possible to change and input the "scheduled shipment date" and "inventory rank". For the simulated disbursement schedule data, it is possible to change and input the "scheduled manufacturing date" and "inventory rank". Also, for the simulated reception schedule data, in addition to the "manufacturing delivery date", the "inventory rank", "shipment deadline", and "expiration date" can be changed. Also, when the close button 62 is operated, the display control unit 21 closes this manufacturing inventory plan inquiry schedule adjustment screen and displays the manufacturing inventory plan inquiry screen shown in Fig. 36 on the output device 7.

[0135] Next, when the manufacturing delivery date of the simulation acceptance schedule data is changed to "October 2, 2022", as shown in FIG. 41(c), the memory control unit 25 updates the manufacturing delivery date of the SIM manufacturing acceptance schedule data stored in the memory unit 2 to "October 2, 2022". Note that FIG. 41(a) is an example of SIM order data, and FIG. 41(b) is an example of SIM manufacturing disbursement schedule data.

[0136] At the same time, the memory control unit 25 sets the SIM update flag. This SIM update flag is updated from "0" to "1" when a change input in the simulation is made to the SIM order data, the SIM manufacturing disbursement schedule data, and the SIM manufacturing acceptance schedule data. That is, the SIM update flags of the SIM order data, the SIM manufacturing disbursement schedule data, and the SIM manufacturing acceptance schedule data are initially "0", but are updated to "1" when the above-described change input is made.

[0137] This SIM update flag is used for target determination when updating the actual data. That is, by detecting the SIM update flag, it is possible to recognize the data (SIM order data, SIM manufacturing disbursement schedule data, or SIM manufacturing acceptance schedule data) for which a change input has been made as a simulation, and this change input can be reflected in the actual data (order data, manufacturing disbursement schedule data, or manufacturing acceptance schedule data).

[0138] Next, as described with reference to FIG. 40, when the manufacturing delivery date of the simulation acceptance schedule data is changed to "October 2, 2022" and the confirmation button 61 is operated, the display control unit 21 displays the product inventory plan inquiry screen again, as shown in FIG. 42. The operator operates the inquiry execution button 50 on the product inventory plan inquiry screen to confirm the simulation result in which the manufacturing delivery date of the simulation acceptance schedule data is changed to "October 2, 2022".

[0139] As a result, by advancing the manufacturing delivery date of the simulation acceptance scheduled data from "October 3, 2022" to "October 2, 2022", as shown in Fig. 43, 100 lots of products with the lot number "L005" are received on October 2 (the number of manufacturing acceptance lots for 100 lots), and the variable number and carry-over number are each "100 lots - 10 lots - 10 lots = 80 lots". Also, the manufacturing disbursement provision number due to this becomes "10 lots + 10 lots = 20 lots". Further, since the memory control unit 25 has made a provision for 20 lots of products from the products with the lot number "L005" in this way, as shown in Fig. 27, the lot number of the manufacturing disbursement scheduled data of the manufacturing disbursement scheduled data work that was "lot undetermined" is updated to "L005" as shown in Fig. 44(b) to identify the lot number of the lot for which the provision is made. Note that Fig. 44(a) is the order data of the above-mentioned order data work.

[0140] Also, as shown in Fig. 45(c), the SIM update flag of the SIM manufacturing acceptance scheduled data is in the state of being updated to "1", as described above. Note that Fig. 41(a) and Fig. 41(b) are the above-mentioned SIM order data or SIM manufacturing disbursement scheduled data, respectively.

[0141] Also, Fig. 46 is a diagram showing the display content displayed in the result display area 55 of the product inventory plan inquiry screen by the display control unit 21. From the display content of this Fig. 46, the operator or the like can recognize that by advancing the manufacturing delivery date from October 3 to October 2, the lot for which the provision is made is not undetermined (no provision has been made for the lot undetermined) and no out-of-stock occurs.

[0142] (Simulation process for changing the shipping date because out-of-stock occurs) Next, as another example of the simulation process, an example of performing a simulation to address a shortage by changing the shipping date will be described. Although it is just one example, assume that on October 2, 2022, the date when the shortage was discovered, the lot was undetermined but there was inventory that needed to be remade. In this case, in order to prevent mis-shipment such as shipping expired products and enable the delivery of products to customers with the shortest lead time, the operator checks the shortest lead time after the change for the order received on October 1.

[0143] In this case, the operator operates the adjustment button 51 while the inquiry content shown in FIG. 48 is displayed on the product material and labor plan inquiry screen shown in FIG. 47 as described above. As a result, based on the SIM order data, SIM manufacturing disbursement schedule data, and SIM manufacturing receipt schedule data shown in FIGS. 50(a) to 50(c), the display control unit 21 displays the simulation order data, simulation disbursement schedule data, and simulation receipt schedule data on the manufacturing inventory plan inquiry schedule adjustment screen shown in FIG. 49.

[0144] On the manufacturing inventory plan inquiry schedule adjustment screen, assume that the operator changes and inputs the scheduled shipping date of the simulation order data from, for example, "October 1, 2022" to "October 3, 2022" as shown in FIG. 51 and operates the confirmation button 61.

[0145] As a result, the memory control unit 25 updates the scheduled shipping date of the SIM order data to "October 3, 2022" and updates the SIM update flag from "0" to "1" as shown in FIG. 52(a). In this case, the data of the SIM manufacturing disbursement schedule data shown in FIG. 52(b) and the SIM manufacturing receipt schedule data shown in FIG. 52(c) are not updated.

[0146] Further, when the confirmation button 61 is operated, the display control unit 21 returns the display screen from the manufacturing inventory plan inquiry schedule adjustment screen to the manufacturing inventory plan inquiry screen shown in FIG. 53. The operator operates the inquiry execution button 50 on the manufacturing inventory plan inquiry screen shown in FIG. 53. As a result, the above-described "loop process for the set period from the reference date" is performed again, and the result display screen data shown in FIG. 54 is generated.

[0147] At this time, since the scheduled shipment date has been changed from "October 1, 2022" to "October 3, 2022", the products with the lot number "L001" on October 1 shown in FIG. 54 will expire, so the storage control unit 25 releases the reservation for the products with the lot number "L001". Then, the storage control unit 25 makes a reservation for "20 lots" released from the reservation for the products with the lot number "L001" from "100 lots" of the products with the lot number "L005" whose expiration date is October 20 shown in FIG. 54. As a result, as shown in FIG. 54, the storage control unit 25 sets the variable number and carry-over number of the record with the lot number "L005" to "100 lots - 20 lots = 80 lots", respectively, and sets the order reservation number to "20 lots".

[0148] In addition, as shown in FIG. 55(a), the storage control unit 25 updates the lot number indicating the reservation source of the order data work that has been "L001" so far to "L005". Note that no update is performed on the manufacturing disbursement schedule data work for FIG. 55(b).

[0149] In addition, the storage control unit 25 lowers the SIM update flag of the SIM order data shown in FIG. 56(a) corresponding to the order data for which the reservation has been released (updates from "1" to "0"), and raises the SIM update flag of the SIM manufacturing receipt schedule data shown in FIG. 56(c) corresponding to the lot number "L005" that has newly become the reservation target (updates from "0" to "1"). Note that the storage control unit 25 does not perform an update process on the SIM manufacturing disbursement schedule data shown in FIG. 56(b).

[0150] As a result, the result display screen data of the result display screen work for the result display screen is such that the reservation from the lot of "L001" on October 1, 2022 is cancelled as shown in FIG. 57, and instead, reservation is made from the lot of "L005" on October 3, 2022, resulting in result display screen data indicating this. The display control unit 21 displays this result display screen data in the result display area 55 shown in FIG. 53. As a result, immediate reservation can be made for the received inventory on the same day, and the operator can confirm that the goods can be shipped as early as October 3. Therefore, based on this confirmation result, the operator can negotiate with the consignee regarding the delivery destination and delivery date.

[0151] (Update process of actual data based on simulation results) Next, the inventory management device 1 of the embodiment enables the update process of actual data based on such simulation results. FIG. 59 shows an overview of the update process of actual data based on simulation results. When the operator performs the above-described simulation and, for example, updates the manufacturing receipt schedule data, which is an example of actual data, based on the reflection result on the SIM manufacturing receipt schedule data, the operator operates the reservation confirmation button 52 shown in FIG. 58.

[0152] When this reservation confirmation button 52 is operated, the extraction unit 22 extracts the SIM manufacturing receipt schedule data in which the SIM update flag is "1" as shown in FIG. 60 from the SIM manufacturing receipt schedule data. The storage control unit 25 identifies the manufacturing receipt schedule data with the same manufacturing instruction slip number as the manufacturing instruction slip number "SSZ00000001" attached to the extracted SIM manufacturing receipt schedule data as shown in FIG. 61(a).

[0153] Then, the memory control unit 25 updates the manufacturing instruction slip number, manufacturing due date, product code, received instruction quantity, lot number, inventory rank, shipping deadline, and expiration date of the identified manufacturing acceptance schedule data to those of the extracted SIM manufacturing acceptance schedule data. As a result, as shown in FIG. 61(b), manufacturing acceptance schedule data is generated in which the shipping deadline is updated to "October 19, 2022" and the expiration date is updated to "April 19, 2022".

[0154] Note that when the SIM update flag is "0", as in the SIM order data shown in FIG. 62(a) and the SIM manufacturing disbursement schedule data shown in FIG. 62(b), the memory control unit 25 does not reflect the data in the actual data.

[0155] (Update processing of actual data based on data work) Next, as shown in FIG. 63, the inventory management device 1 of the embodiment can also update actual data based on various data work. For example, when updating order data based on order data work, the extraction unit 22 extracts the order slip number, line number, scheduled shipping date, product code, order quantity, lot number, inventory rank, and branch number from the order data work shown in FIG. 64(a). The memory control unit 25 refers to the order data shown in FIG. 64(b) based on the order slip number and line number extracted from the order data work, and detects the order data with the same order slip number and line number as those extracted from the order data work as shown in FIG. 64(c).

[0156] Then, the memory control unit 25 updates the order slip number, line number, scheduled shipping date, product code, order quantity, lot number, inventory rank, and branch number of the detected order data to those of the order data work. As a result, the data in the order data work can be reflected in the order data.

[0157] In addition, as shown in FIG. 63, it is also possible to update the manufacturing disbursement schedule data based on the manufacturing disbursement schedule data work. In this case, as shown in FIG. 65(a), the extraction unit 22 extracts each data of the manufacturing disbursement schedule data work. The storage control unit 25 refers to the manufacturing disbursement schedule data shown in FIG. 65(b) based on the manufacturing instruction slip number and line number of each data of the extracted manufacturing disbursement schedule data work, and determines the manufacturing disbursement schedule data of the same manufacturing instruction slip number and line number as those of each data of the extracted manufacturing disbursement schedule data work.

[0158] In this example, since the manufacturing instruction slip number of each data of the extracted manufacturing disbursement schedule data work is "SSZ00000003" and the line number is "1", the storage control unit 25 determines the manufacturing disbursement schedule data corresponding to the record in the second column among the manufacturing disbursement schedule data shown in FIG. 65(b), where the manufacturing instruction slip number is "SSZ00000003" and the line number is "1". Then, the storage control unit 25 updates the determined manufacturing disbursement schedule data with the manufacturing disbursement schedule data extracted from the manufacturing disbursement schedule data work.

[0159] Specifically, since the determined manufacturing disbursement schedule data is the manufacturing disbursement schedule data of one column of records, the storage control unit 25 deletes this manufacturing disbursement schedule data once. Then, the storage control unit 25 adds the manufacturing disbursement schedule data of three columns of records extracted from the manufacturing disbursement schedule data work to the manufacturing disbursement schedule data as shown in FIG. 65(c). Thereby, the manufacturing disbursement schedule data can be updated based on the manufacturing disbursement schedule data work.

[0160] Note that for the records with the lot number of the manufacturing disbursement schedule data work being "lot undetermined", the storage control unit 25 updates the lot number of the manufacturing disbursement schedule data to be blank.

[0161] (Data addition auxiliary function) Next, the inventory management device 1 of the embodiment is provided with a "data addition assistance function" that enables a simulation to call data outside the initially specified date range and change the date. Specifically, as shown in FIG. 66, on the product inventory plan inquiry schedule adjustment screen, in the data addition assistance area, there are input fields for the scheduled shipment date of "orders received" and the inventory rank, input fields for the scheduled production date of "planned payment" and the inventory rank, and input fields for the production lead time of "planned receipt" and the inventory rank. Also, in the data addition assistance area, an order received addition button 57, a planned payment addition button 58, and a planned receipt addition button 59 are provided.

[0162] When adding and calling from the production receipt data, as shown in FIG. 68, the operator inputs a date outside the initially specified date range, such as "October 5, 2022", into the production lead time of "planned receipt" in the data addition assistance area, inputs an inventory rank such as "A", and operates the planned receipt addition button 59.

[0163] When the planned receipt addition button 59 is operated, the extraction unit 22 refers to the production receipt schedule data and the SIM production receipt schedule data shown in FIG. 67, and extracts the production receipt schedule data that meets the following extraction conditions.

[0164] Extraction conditions = Production lead time of production receipt schedule data ≤ Input production lead time AND Inventory rank of production receipt schedule data = Input inventory rank AND Does not exist in SIM production receipt schedule data

[0165] As a result, in the example of FIG. 67, the extraction unit 22 extracts the manufacturing acceptance schedule data of the record in the second column as the manufacturing acceptance schedule data of products of rank A with the manufacturing lead time of "October 5, 2022" input by the operator and not existing in the SIM manufacturing acceptance schedule data. The storage control unit 25 adds the extracted manufacturing acceptance schedule data of the record in the second column to the simulation acceptance schedule data in the storage unit 2 and stores it. The display control unit 21 reads out the manufacturing acceptance schedule data in the state where the manufacturing acceptance schedule data of the record in the second column is added as described above from the storage unit 2 and displays it in the display column of the simulation acceptance schedule data as shown in FIG. 68. Thereby, it is possible to additionally call and display data outside the range of the date specified first.

[0166] Next, the operator changes the manufacturing lead time of the added manufacturing acceptance schedule data to, for example, "October 3, 2022" by an operation. Thereby, the added manufacturing acceptance schedule data can be used for the above-described simulation.

[0167] Also, the storage control unit 25 updates the SIM manufacturing acceptance schedule data as described above based on the added manufacturing acceptance schedule data. Thereby, the added manufacturing acceptance schedule data can be reflected in the manufacturing acceptance schedule data which is actual data.

[0168] Next, when calling order data outside the range of the date specified first, as shown in FIG. 69, a desired shipping schedule date is input in the input field of the shipping schedule date of "Order", a desired inventory rank is input in the input field of the inventory rank, and the order addition button 57 is operated.

[0169] As a result, in the same manner as described above, order data that matches the following extraction conditions is extracted by the extraction unit 22, added to the simulation order data shown in FIG. 68, and displayed.

[0170] Extraction conditions = Manufacturing lead time of order data ≤ Input manufacturing lead time AND Inventory rank of order data = Input inventory rank AND Not existing in SIM order data

[0171] By changing the manufacturing delivery schedule of the added order data, the added order data can be used in the above simulation. Also, since the SIM order data is updated as described above based on the added order data, the added order data can be reflected in the actual order data.

[0172] Next, when calling the manufacturing delivery schedule data outside the range of the date specified first, as shown in FIG. 70, enter the desired manufacturing schedule date in the input field for the manufacturing schedule date of "delivery schedule", enter the desired inventory rank in the input field for the inventory rank, and operate the delivery schedule addition button 58.

[0173] As a result, in the same manner as described above, the extraction unit 22 extracts the manufacturing delivery schedule data that matches the following extraction conditions, and adds it to and displays it in the simulation delivery schedule data shown in FIG. 68.

[0174] Extraction conditions = manufacturing delivery schedule of manufacturing delivery schedule data ≤ input manufacturing delivery schedule AND inventory rank of manufacturing delivery schedule data = input inventory rank AND does not exist in SIM manufacturing delivery schedule data

[0175] By changing the manufacturing delivery schedule of the added manufacturing delivery schedule data, the added manufacturing delivery schedule data can be used in the above simulation. Also, since the SIM manufacturing delivery schedule data is updated as described above based on the added manufacturing delivery schedule data, the added manufacturing delivery schedule data can be reflected in the actual manufacturing delivery schedule data.

[0176] (Effects of the Embodiment) Today, for example, manufacturers who produce products through prospective production and order-based production check the available inventory at the time of receiving an order and make shipping and manufacturing decisions. Although it is just an example, in the case of chemical manufacturers that produce high-functional products, quality control is important, and since they handle products with a short shelf life, it is necessary to make shipping and manufacturing decisions taking into account the handling deadline (expiration date or (and) shipping deadline, etc.).

[0177] Conventionally, since shipping and manufacturing decisions were made based on the trend of the total inventory (including planned shipments and planned production), it was difficult to determine whether the inventory was valid within the shipping deadline or (and) the expiration date, and it was difficult for sales staff or business staff to grasp accurate inventory information at the order placement stage from customers.

[0178] However, the inventory management device 1 of the embodiment can generate and make it possible to confirm manufacturing and planned shipment information reflecting the inventory reservation result considering the shipping deadline or (and) the expiration date of the product.

[0179] Specifically, 1. It is possible to confirm the trend of inventory information according to the plan for the specified period (including planned shipments, planned production, and planned receipts). 2. It is possible to confirm the information on the inventory trend with provisional reservation (implement provisional reservation starting from the inventory with an old shipping deadline). 3. It is possible to grasp the total number of reserved lots per day, the number of expired inventory, and the number of in - date inventory. 4. It is possible to confirm the quantity, shipping deadline, expiration date, and inventory rank for each lot number by day. 5. It is possible to perform a simulation with the dates of order - received data, planned payment data, and planned receipt data changed. 6. It is possible to reflect the simulation result in the actual data.

[0180] Therefore, with the inventory management device 1 of the embodiment, business staff can quickly make shipping decisions at the order - received stage of products, and the manufacturing department etc. can make manufacturing plan decisions. Also, in the shipping operation, it is possible to efficiently perform a shipping operation with guaranteed quality.

[0181] [Contribution to the Sustainable Development Goals (SDGs) led by the United Nations] According to this embodiment, since it can contribute to promoting business efficiency and appropriate business judgment of enterprises, it is possible to contribute to Goal 8 and Goal 9 of the SDGs.

[0182] In addition, according to the present embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, and thus it is possible to contribute to SDGs Goal 12, Goal 13, and Goal 15.

[0183] In addition, according to the present embodiment, it is possible to contribute to strengthening control and governance, and thus it is possible to contribute to SDGs Goal 16.

[0184] [Other Embodiments] In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0185] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0186] In addition, regarding 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 the drawings, they can be arbitrarily changed unless otherwise specified.

[0187] In addition, regarding the inventory management device 1, each illustrated component is a functional concept, and it is not necessarily physically configured as illustrated.

[0188] For example, with regard to the processing functions provided by the inventory management device 1, particularly each processing function performed by the control unit 3 and the control unit 3, all or any part thereof may be realized by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in the present embodiment, and is mechanically read by the inventory management device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD. This computer program is executed by being loaded into the RAM and constitutes the control unit 3 in cooperation with the CPU.

[0189] Further, the inventory management program of the inventory management device 1 may be stored in another server device connected to the inventory management device 1 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0191] Also, the "program" is a data processing method described in any language or description method, and is not limited to a specific form such as source code or binary code. Note that the "program" is not necessarily limited to a single configuration, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs represented by an OS. For the specific configuration, reading procedure, and installation procedure after reading for the recording medium in the inventory management device 1 shown in the embodiment, well-known configurations and procedures can be used.

[0192] The storage unit 2 is a storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and stores various programs, tables, databases, and web page files used for various processes and website provision.

[0193] Further, the inventory management device 1 may be configured by an information processing device such as a known personal computer device or a workstation, or may be configured by an information processing device to which an arbitrary peripheral device is connected. Further, the information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in the present embodiment.

[0194] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or functional loads. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0195] The present invention is suitable for application to inventory management operations in industries that manage the inventory of products based on expiration dates (such as expiration dates or shipping dates). In particular, by applying it to inventory management in industries that require strict quality control, such as food manufacturers, chemical (high-performance materials, pharmaceuticals, etc.) manufacturers, etc., more remarkable effects can be obtained.

Explanation of Signs

[0196] 1 Inventory management device 2 Storage unit 3 Control unit 4 Communication interface unit 5 Input / output interface unit 6 Input device 7 Output device 21 Display control unit 22 Extraction unit 23 Calculation unit 24 Data generation unit 25 Storage control unit 50 Inquiry execution button 51 Adjustment button 52 Allocation confirmation button 53 Screen clear button 55 Result display area 57 Order receiving addition button 58 Payment Scheduled Additional Button 59 Receipt Scheduled Additional Button 61 Confirm Button 62 Close Button

Claims

1. A detection unit that detects the inventory quantity of a product for each expiration date by referring to inventory data based on the expiration date added to the product; A calculation unit that subtracts the quantity of products already reserved or scheduled to be reserved from the inventory quantity of products for each expiration date to calculate the unreserved quantity for each product with each expiration date; An appropriation processing unit that appropriates the appropriation quantity of the product from the unappropriated quantity of the product with the minimum expiration date among the expiration dates after the reference date, which is the specified date; A data generation unit that generates appropriation result data including, for each product for which the inventory quantity has been detected, at least the expiration date, the appropriation quantity, and the carry-over quantity, which is the number obtained by subtracting the appropriation quantity from the unappropriated quantity; An output control unit that performs output control on the generated appropriation result data; An inventory management device having the above components.

2. When a period of a predetermined number of days from the reference date is specified together with the reference date, the appropriation processing unit performs the appropriation processing for each day corresponding to the number of days of the period from the reference date. The data generation unit generates appropriation result data for each day of the appropriation processing. The inventory management device according to claim 1, characterized by the above.

3. The appropriation quantity of the product is an order appropriation quantity corresponding to the order receipt quantity of the product or a manufacturing disbursement appropriation quantity corresponding to the manufacturing disbursement quantity. The inventory management device according to claim 2, characterized by the above.

4. The detection unit refers to manufacturing receipt schedule data including the receipt instruction quantity, which is the quantity of the product to be delivered on the specified manufacturing delivery date, and detects the manufacturing receipt quantity of the product within the period including the reference date. The appropriation processing unit appropriates the appropriation quantity of the product based on the manufacturing receipt quantity. The data generation unit generates appropriation result data including the manufacturing receipt quantity on the date of manufacturing receipt as the appropriation result data for the date of manufacturing receipt within the period. The inventory management device according to claim 3, characterized by the above.

5. The product is in lot units where a predetermined number of products are grouped together and the expiration date and lot number are added. The appropriation processing unit performs the appropriation processing based on the lot quantity of the products with the same lot number. The inventory management device according to claim 4, characterized by the above.

6. The detection unit generates data indicating the inventory quantity of products for each expiration date detected by referring to the inventory data, and "lot undetermined" data where the inventory quantity is set to "0", the expiration date is left blank, and the lot number for the appropriation process is undetermined, When the inventory quantity of the product is less than the appropriation quantity, the appropriation processing unit performs an appropriation process from the inventory quantity of "lot undetermined", The data generation unit generates the appropriation result data indicating that an appropriation process has been performed from the inventory quantity of "lot undetermined", The inventory management device according to claim 5, characterized in that.

7. The data generation unit generates SIM order receiving data for simulation, which is order receiving data for simulation and includes a scheduled shipment date, an order receiving quantity, and an update flag, SIM manufacturing payment schedule data for simulation, which is manufacturing payment schedule data for simulation and includes a scheduled manufacturing date, a scheduled payment quantity, and an update flag, and SIM manufacturing receipt schedule data for simulation, which is manufacturing receipt schedule data for simulation and includes a manufacturing lead time, a receipt instruction quantity, an expiration date, and an update flag, When an adjustment for simulation is instructed, the output control unit outputs simulation order receiving data corresponding to the SIM order receiving data, simulation payment schedule data corresponding to the SIM manufacturing payment schedule data, and simulation receipt schedule data corresponding to the SIM manufacturing receipt schedule data, At least the scheduled shipment date, the scheduled manufacturing date, or the manufacturing lead time can be changed to desired values respectively, When the scheduled shipment date is changed, the data generation unit changes the scheduled shipment date of the SIM order receiving data and changes the update flag to a value indicating that the scheduled shipment date has been changed. When the scheduled manufacturing date is changed, the data generation unit changes the scheduled manufacturing date of the SIM manufacturing payment schedule data and changes the update flag to a value indicating that the scheduled manufacturing date has been changed. When the manufacturing lead time is changed, the data generation unit changes the manufacturing lead time of the SIM manufacturing receipt schedule data and changes the update flag to a value indicating that the manufacturing lead time has been changed, When the simulation is instructed to execute with the scheduled shipment date of the SIM order data changed, the provisioning processing unit cancels the provisioning result of the order quantity before the change of the scheduled shipment date, and from the unprovisioned quantity of the product with the minimum handling period among the handling periods after the changed scheduled shipment date of the SIM order data, provisions the order quantity of the product as the provisioned quantity. When the simulation is instructed to execute with the scheduled manufacturing date of the SIM manufacturing disbursement schedule data changed, the provisioning processing unit cancels the provisioning result of the disbursement scheduled quantity before the change of the scheduled manufacturing date, and from the unprovisioned quantity of the product with the minimum handling period among the handling periods after the changed scheduled manufacturing date of the SIM manufacturing disbursement schedule data, provisions the disbursement scheduled quantity of the product as the provisioned quantity. When the simulation is instructed to execute with the manufacturing due date of the SIM manufacturing receipt schedule data changed, the provisioning processing unit cancels the provisioning result before the change of the manufacturing due date, and performs provisioning processing based on the manufacturing receipt quantity received on the manufacturing due date. The output control unit performs output control of the result of the simulation as the provisioning result data. The inventory management device according to claim 6, characterized in that.

8. When execution of the provisioning confirmation process for updating the actual data with the result of the simulation is specified, among the SIM order data, the SIM manufacturing disbursement schedule data, and the SIM manufacturing receipt schedule data, detects data including the update flag indicating that the value has been changed, and based on the detected SIM order data, the SIM manufacturing disbursement schedule data, or the SIM manufacturing receipt schedule data, further includes a storage control unit that updates the order data, the manufacturing disbursement schedule data, or the manufacturing receipt schedule data that is the actual data stored in the storage unit. The inventory management device according to claim 7, characterized in that.

9. When another scheduled shipment date, scheduled manufacturing date, or manufacturing due date is additionally specified as the scheduled shipment date, the scheduled manufacturing date, or the manufacturing due date, the detection unit detects the order data corresponding to the other scheduled shipment date additionally specified, detects the manufacturing disbursement schedule data corresponding to the other scheduled manufacturing date additionally specified, or detects the manufacturing receipt schedule data corresponding to the other manufacturing due date additionally specified. The output control unit performs output control by using the record of the order data corresponding to the detected other scheduled shipment dates as an additional record of the simulated order data, performs output control by using the record of the manufacturing disbursement schedule data corresponding to the detected other scheduled manufacturing dates as an additional record of the simulated disbursement schedule data, and performs output control by using the record of the manufacturing receipt schedule data corresponding to the detected other manufacturing lead times as an additional record of the simulated receipt schedule data. The inventory management device according to claim 7 or claim 8, characterized in that.

10. A detection step in which a detection unit refers to inventory data based on the expiration date attached to a product to detect the inventory quantity of the product for each expiration date; A calculation step in which a calculation unit subtracts the quantity of products already reserved or scheduled to be reserved from the inventory quantity of the products for each expiration date to calculate the unreserved quantity for each product for each expiration date; An appropriation processing step in which an appropriation processing unit appropriates the appropriation quantity of the product from the unappropriated quantity of the product with the minimum expiration date among the expiration dates after a reference date which is the specified date; A data generation step in which a data generation unit generates appropriation result data including, for each of the products for which the inventory quantity has been detected, at least the expiration date, the appropriation quantity, and the carry-over quantity which is the number obtained by subtracting the appropriation quantity from the unappropriated quantity; An output control step in which an output control unit performs output control on the generated appropriation result data; An inventory management method having the above.

11. A computer, A detection unit that refers to inventory data based on the expiration date attached to a product to detect the inventory quantity of the product for each expiration date; A calculation unit that subtracts the quantity of products already reserved or scheduled to be reserved from the inventory quantity of the products for each expiration date to calculate the unreserved quantity for each product for each expiration date; An appropriation processing unit that appropriates the appropriation quantity of the product from the unappropriated quantity of the product with the minimum expiration date among the expiration dates after a reference date which is the specified date; A data generation unit that generates appropriation result data including, for each of the products for which the inventory quantity has been detected, at least the expiration date, the appropriation quantity, and the carry-over quantity which is the number obtained by subtracting the appropriation quantity from the unappropriated quantity; Functioning as an output control unit that performs output control on the generated appropriation result data. An inventory management program, characterized in that.

Images