Expiration date-specific raw material inventory management device, expiration date-specific raw material inventory management method, and expiration date-specific raw material inventory management program

The raw material inventory management system addresses the challenge of managing inventory by expiration date, improving accuracy and reducing waste through real-time tracking and management.

JP7593958B2Active Publication Date: 2024-12-03OBIC CO LTD
View PDF 11 Cites 0 Cited by

Patent Information

Application Number
JP2022006994
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-01-20
Publication Date
2024-12-03
Estimated Expiration
2042-01-20

AI Technical Summary

Technical Problem

Existing systems fail to manage inventory considering expiration dates, leading to inaccurate order considerations and excess inventory due to delayed updates in raw material consumption and expiration tracking.

Method used

A raw material inventory management system that tracks and manages inventory by expiration date, using a control unit to link raw materials with their expiration dates, lot numbers, and inventory quantities, and updates inventory data in real-time based on manufacturing plans and consumption patterns.

Benefits of technology

Improves inventory accuracy by considering expiration dates, reduces waste, and enhances order consideration speed and accuracy, allowing real-time management and reduction of operational loads.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007593958000001
    Figure 0007593958000001
  • Figure 0007593958000002
    Figure 0007593958000002
  • Figure 0007593958000003
    Figure 0007593958000003
Patent Text Reader

Abstract

To provide an apparatus for managing material inventory per appreciation expiration date, a method of managing material inventory per appreciation expiration date, and a program for managing material inventory per appreciation expiration date which makes material automatically consumed upon counting the number of production to thereby secure real-time inventory information per appreciation expiration date and to manage scheduled inventory in consideration of expiration of appreciation expiration date.SOLUTION: The apparatus for managing material inventory per appreciation expiration date is configured to: acquire production plan data set by associating a product, a production start date, and a scheduled production amount with one another; acquire production instruction data set by associating the production start date, materials required for production of the scheduled production amount, and a scheduled put-out amount of each material with one another based on a production arrangement master and the production plan data; and acquire scheduled inventory data set by associating a scheduled receipt / delivery amount of specified materials as receipt / delivery targets in an order of the lot number and the scheduled inventory amount with each other based on the current inventory data and the production instruction data, in consideration of materials of lot numbers whose appreciation expiration date is expired before the production start date.SELECTED DRAWING: Figure 3
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to an apparatus for managing raw material inventory by expiration date, a method for managing raw material inventory by expiration date, and a program for managing raw material inventory by expiration date. [Background technology]

[0002] Patent Document 1 discloses a configuration in which inventory is managed in a traceable manner so that, in response to a request for delivery of ingredients, ingredients can be delivered in the order in which their expiration dates arrive earliest. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2005-276154 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in Patent Document 1 above has a problem in that it is not possible to perform planned inventory management that takes expiration dates into consideration.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a raw material inventory management device by expiration date, a raw material inventory management method by expiration date, and a raw material inventory management program by expiration date that ensure real-time inventory information by expiration date and enable planned inventory management taking into account expiration of the expiration date by automatically consuming raw materials on a first-in, first-out basis when recording production volume. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the raw material inventory management device according to the present invention is a raw material inventory management device according to the present invention, which is equipped with a memory unit and a control unit, the memory unit is equipped with an inventory storage means for storing current inventory data set by linking raw materials, expiration dates, lot numbers in order of the expiration dates, and inventory quantities, and a manufacturing configuration master set by linking the raw materials constituting a product and the required quantities for each of the raw materials, and the control unit is equipped with a production plan acquisition means for acquiring production plan data set by linking the product, production start date, and planned production quantity, and a production schedule acquisition means for acquiring production schedule ... and a production instruction acquisition means for acquiring production instruction data set by linking the production start date, the raw materials required for manufacturing the product of the planned production quantity, and the planned delivery quantity of each raw material based on the production master and the production plan data, and a planned inventory acquisition means for acquiring planned inventory data set by linking the planned receipt / delivery quantities of the raw materials identified as items to be received / delivered in the order of the lot numbers, taking into account the raw materials of the lot numbers that will expire on the production start date, based on the current inventory data and the production instruction data, and the planned inventory quantity.

[0007] In addition, in the expiration date-based raw material inventory management device of the present invention, the planned inventory data is further set by linking the production start date, the raw materials, and the planned shortage inventory quantity, and the control unit further comprises a planned inventory inquiry means for displaying the planned inventory data, and an order acquisition means for acquiring order data set by linking the raw materials, the planned arrival date, and the order quantity.

[0008] In addition, in the expiration date-based raw material inventory management device of the present invention, the control unit is further characterized by having an arrival acquisition means which, when arrival input data setting the raw materials, the expiration date of the raw materials, and the arrival quantity of the raw materials is input, assigns lot numbers in order of the expiration date based on the arrival input data, acquires arrival data set by linking the raw materials, the expiration date, the lot number, and the inventory quantity that is the arrival quantity, and uses the arrival data to update the current inventory data stored in the inventory storage means.

[0009] In addition, in the expiration date-based raw material inventory management device of the present invention, the control unit is further characterized by having an acceptance acquisition means for acquiring acceptance data set by linking the product, the expiration date of the product, and the acceptance quantity, and a manufacturing history registration means for acquiring delivery detail data setting the delivery quantity of the raw materials required for product manufacturing based on the manufacturing configuration master and the acceptance data, identifying the raw materials set in the current inventory data to be delivered in the order of the lot numbers based on the delivery detail data, acquiring delivery detail data setting the delivery quantity of the raw materials for each lot number, and updating the current inventory data stored in the inventory storage means based on the delivery detail data.

[0010] In addition, in the expiration date-based raw material inventory management device of the present invention, the production history registration means further displays the dispensing quantity set in the dispensing detail data in a modifiable manner, and when a revised dispensing quantity is set, corrects the dispensing detail data based on the revised dispensing quantity, and updates the current inventory data stored in the inventory storage means based on the dispensing detail data.

[0011] In addition, in the expiration date-specific raw material inventory management device of the present invention, the receipt acquisition means acquires receipt data set by a manufacturing staff member linking the product, the product's expiration date, and the receipt quantity, and the production performance registration means displays the dispensing quantity set in the dispensing detail data in an editable manner, and when the revised dispensing quantity is set by a raw material weighing staff member, the dispensing detail data is revised based on the revised dispensing quantity, and the current inventory data stored in the inventory storage means is updated based on the dispensing detail data.

[0012] The method for managing raw materials by expiration date according to the present invention is a method for managing raw materials by expiration date, which is executed by an apparatus for managing raw materials by expiration date, which is equipped with a memory unit and a control unit, and the memory unit is equipped with an inventory storage means for storing current inventory data set by linking raw materials, expiration dates, lot numbers in order of the expiration dates, and inventory quantities, and a manufacturing configuration master set by linking the raw materials constituting a product and the required quantities for each of the raw materials, and the control unit is equipped with a production plan acquisition step for acquiring production plan data set by linking the product, production start date, and planned production quantity, and The method includes a manufacturing instruction acquisition step of acquiring manufacturing instruction data that is set by linking the manufacturing start date, the raw materials required for manufacturing the product of the planned production quantity, and the planned dispensing quantity of each raw material based on the manufacturing configuration master and the production plan data, and a planned inventory acquisition step of acquiring planned inventory data that is set by linking the planned receipt / delivery quantities of the raw materials identified as items to be received / delivered in the order of the lot numbers, taking into account the raw materials of the lot numbers that will expire on the manufacturing start date, based on the current inventory data and the manufacturing instruction data, and the planned inventory quantity.

[0013] In addition, the raw material inventory management program by expiration date according to the present invention is a raw material inventory management program by expiration date to be executed by an raw material inventory management device by expiration date having a memory unit and a control unit, the memory unit has an inventory storage means for storing current inventory data set by linking raw materials, expiration dates, lot numbers in order of the expiration dates, and inventory quantities, and a manufacturing configuration master set by linking the raw materials constituting a product and the required quantities for each of the raw materials, and the control unit has a production plan acquisition step for acquiring production plan data set by linking the product, production start date, and planned production quantity, and The method is characterized in that it executes a manufacturing instruction acquisition step of acquiring manufacturing instruction data that is set by linking the manufacturing start date, the raw materials required to manufacture the product of the planned production quantity, and the planned delivery quantity of each raw material based on the manufacturing configuration master and the production plan data, and a planned inventory acquisition step of acquiring planned inventory data that is set by linking the planned receipt / delivery quantities of the raw materials identified as items to be received / delivered in the order of the lot numbers, taking into account the raw materials of the lot numbers that will expire on the manufacturing start date, based on the current inventory data and the manufacturing instruction data, and planned inventory quantity. Effect of the Invention

[0014] According to the present invention, it is possible to improve the accuracy of order consideration by grasping the appropriate inventory. Also, according to the present invention, it is possible to enable the first-in, first-out dispensing of raw materials based on the manufacturing performance of the business flow and the refinement of the planned inventory including the expiration date of the inventory. Also, according to the present invention, it is possible to support the purchasing work by refining the planned inventory inquiry. Also, according to the present invention, it is possible to provide a function that is almost essential in the food manufacturing industry and to perform real-time inventory management. Also, according to the present invention, it is possible to perform the dispensing of raw materials in real time without linking with the manufacturing equipment. Also, according to the present invention, it is possible to obtain the inventory including the expiration date data in real time by consuming the inventory at the time of production, and it is possible to improve the speed and accuracy of the order consideration. Also, according to the present invention, it is possible to easily control the arrangement of materials that are fast-growing. Also, according to the present invention, it is possible to reduce the operational load when recording the product inventory and improve the real-time accuracy of the raw material inventory data by expiration date. In addition, according to the present invention, the raw material usage lot at the time of initial registration is made a rule, while the actual measured value of raw material consumption can be freely changed and updated, thereby enabling accurate inventory data to be registered. In addition, according to the present invention, the accuracy of order consideration can be improved by calculating the planned inventory taking into account the expiration date. In addition, according to the present invention, the product inventory can be recorded using only the data of the person in charge of counting the product volume, so that the speed of recording product inventory in the system is improved, making it easier for sales people to grasp the inventory, and reducing sales opportunity losses. [Brief description of the drawings]

[0015] [Figure 1] FIG. 1 is a diagram showing an example of conventional raw material inventory management. [Diagram 2] FIG. 2 is a diagram showing an example of raw material inventory management in this embodiment. [Diagram 3]FIG. 3 is a block diagram showing an example of the configuration of an expiration date-based raw material inventory management device in this embodiment. [Figure 4] Referring to FIG. 4, an example of a manufacturing configuration master in this embodiment is shown. [Diagram 5] FIG. 5 is a flowchart showing an example of the process of the expiration date-based raw material inventory management device in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a planned inventory inquiry process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of the planned inventory inquiry process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the manufacturing performance management process in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the manufacturing performance management process in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the manufacturing performance management process in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the manufacturing performance management process in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

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

[0017] [1. Overview] First, an overview of the present invention will be described with reference to Figures 1 and 2. Figure 1 is a diagram showing an example of conventional raw material inventory management. Figure 2 is a diagram showing an example of raw material inventory management in this embodiment.

[0018] In the food industry, it is common for ingredients that have not passed their expiration date to be used during food production, and for them to have a large stock of ingredients in order to prevent opportunity loss. However, this results in a lot of waste from ingredients with short expiration dates.

[0019] Previously, the system did not have real-time inventory by expiration date, and the accuracy of ordering considerations was low, making it impossible to ensure appropriate inventory while managing expiration dates.In addition, since different people measured and registered product output and raw material consumption amounts at different times, it was difficult to improve the accuracy of inventory by expiration date.

[0020] In addition, previously, the number of ingredients dispensed during food manufacturing was not updated in the inventory data, and the accuracy of inventory by expiration date was low, which resulted in excess inventory being ordered when considering ordering ingredients. In other words, as shown in Figure 1, previously, for the inventory data for lot number: L01, the ingredients dispensed during manufacturing were not updated in real time, resulting in discrepancies with the actual inventory, which was a factor in reducing the accuracy of ordering considerations, and since it was difficult to grasp the inventory that would expire when the ingredients were used, more was ordered, resulting in excess eggs, and there was a risk of them expiring and being discarded.

[0021] In addition, the production volume of the product and the consumption of the raw materials occur at the same time, but in the past, if the raw materials were liquid, another person would measure the remaining amount in the raw material tank the next day to confirm the consumption amount, so the raw material consumption amount was often measured after the production volume was recorded, which delayed the timing of recording the raw material consumption amount. Also, it is necessary to record the raw material consumption amount immediately by provisionally recording the raw material consumption lot at the time of recording the production volume of the product, but in the past, the manufacturing person in charge could not determine which raw material expiration date had been consumed.

[0022] Therefore, in this embodiment, focusing on the basic rule that ingredients should be consumed in order of their expiration date when manufacturing food products, a system is provided in which the person in charge of measuring the production volume on the production line automatically records the consumed ingredient lots by expiration date when recording the production volume, and a highly accurate inventory of ingredients by expiration date is grasped in real time. As a result, in this embodiment, the ordering person can grasp the inventory by expiration date with high real-time accuracy at the timing when the ordering person carries out ordering consideration, and the production instruction data (required amount) and the planned inventory that takes expiration date into account can be confirmed from the system with high accuracy.

[0023] 2, in this embodiment, a production plan is created based on a sales plan, showing how many of each product are needed and by when, the ordering person checks the required amount and inventory data, the ordering time and quantity are considered, the production person records the number of products produced, new production performance input is registered, the weighing person registers the amount of raw material consumed, and the production performance input is corrected and registered. As a result, in this embodiment, in order to improve ordering consideration, inventory data by expiration date is updated in real time, making it possible to refer to planned inventory that takes expiration dates into account, and improving the function of improving the accuracy and speed of production performance input.

[0024] [2. Configuration] An example of the configuration of the expiration date-classified raw material inventory management device 100 according to this embodiment will be described with reference to Figures 3 and 4. Figure 3 is a block diagram showing an example of the configuration of the expiration date-classified raw material inventory management device 100 according to this embodiment.

[0025] 3, the expiration date-based raw material inventory management device 100 is a commercially available desktop personal computer. Note that the expiration date-based raw material inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, etc.

[0026] The expiration date-specific raw material inventory management device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the expiration date-specific raw material inventory management device 100 is connected to each other so as to be able to communicate with each other via any communication path.

[0027] The communication interface unit 104 communicably connects the expiration date-specific raw material inventory management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the expiration date-specific raw material inventory management device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0028] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0029] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes an inventory database 106a and a manufacturing configuration master 106b.

[0030] The inventory database 106a stores inventory data. Here, the inventory database 106a may store current inventory data of products and / or raw materials constituting the products. The inventory database 106a may also store current inventory data set in association with raw materials, expiration dates, lot numbers in order of expiration dates, and inventory quantities.

[0031] The manufacturing configuration master 106b is a master that links and sets the raw materials that make up the product and the required quantity of each raw material. Here, the manufacturing configuration master 106b may be set by linking the product (parent product), raw materials (delivered product), required amount of raw materials (component numerator), and product quantity (component denominator).

[0032] An example of the manufacturing configuration master 106b in this embodiment will now be described with reference to Fig. 4. With reference to Fig. 4, an example of the manufacturing configuration master 106b in this embodiment is shown.

[0033] As shown in FIG. 4, in the manufacturing configuration master 106b in this embodiment, recipe data of ingredients (dispense products) required for making 1000 pieces of dressing (parent product) is registered.

[0034] Returning to Fig. 3, the control unit 102 is a CPU or the like that performs overall control of the expiration date-based raw material inventory management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of function concept, the control unit 102 includes a production plan acquisition unit 102a, a manufacturing instruction acquisition unit 102b, a planned inventory acquisition unit 102c, a planned inventory inquiry unit 102d, an order acquisition unit 102e, an arrival acquisition unit 102f, an acceptance acquisition unit 102g, and a manufacturing performance registration unit 102h.

[0035] The production plan acquisition unit 102a acquires production plan data that is set by linking products, production start dates, and planned production quantities.

[0036] The manufacturing instruction acquisition unit 102b acquires manufacturing instruction data for a product. Here, the manufacturing instruction acquisition unit 102b may acquire manufacturing instruction data that is set by linking the manufacturing start date, the raw materials required for the product manufacturing of the planned production quantity, and the planned delivery quantity of each raw material, based on the manufacturing configuration master 106b and the production plan data.

[0037] The planned inventory acquisition unit 102c acquires planned inventory data of raw materials constituting the product. Here, the planned inventory acquisition unit 102c may acquire planned inventory data set by linking the planned quantities of raw materials specified as the objects of receipt and delivery in the order of lot numbers and the planned inventory quantities, taking into account raw materials with lot numbers whose expiration date will expire on the production start date, based on the current inventory data and the production instruction data. Here, the planned inventory data may be set by linking the production start date, raw materials, and planned shortage inventory quantities.

[0038] The planned inventory inquiry unit 102d displays the planned inventory data. Here, the planned inventory inquiry unit 102d displays a planned inventory inquiry screen including the planned inventory data.

[0039] The order acquisition unit 102e acquires order data for the raw materials. Here, the order acquisition unit 102e may acquire order data in which the raw materials, the expected arrival date, and the order quantity are linked together.

[0040] The arrival acquisition unit 102f acquires arrival data of ingredients, and updates the current stock data stored in the inventory database 106a using the arrival data. Here, when arrival input data is input that sets ingredients, the expiration date of ingredients, and the arrival quantity of ingredients, the arrival acquisition unit 102f may number lot numbers in order of expiration date based on the arrival input data, acquire arrival data that links ingredients, the expiration date, the lot number, and the inventory quantity that is the arrival quantity, and update the current stock data stored in the inventory database 106a using the arrival data.

[0041] The receipt acquisition unit 102g acquires receipt data that is set by linking the product, the expiration date of the product, and the receipt quantity. Here, the receipt acquisition unit 102g may acquire receipt data that is set by linking the product, the expiration date of the product, and the receipt quantity set by the production staff.

[0042] The manufacturing record registration unit 102h may acquire delivery detail data in which the delivery quantity of the raw material required for product manufacturing is set, acquire delivery detail data in which the delivery quantity of the raw material for each lot number is set based on the delivery detail data, and update the current inventory data stored in the inventory database 106a based on the delivery detail data. Here, the manufacturing record registration unit 102h may acquire delivery detail data in which the delivery quantity of the raw material required for product manufacturing is set based on the manufacturing configuration master 106b and the receiving data, identify the raw material set in the current inventory data to be delivered in order of lot number based on the delivery detail data, acquire delivery detail data in which the delivery quantity of the raw material for each lot number is set, and update the current inventory data stored in the inventory database 106a based on the delivery detail data. In addition, the manufacturing record registration unit 102h may display the delivery quantity set in the delivery detail data in a modifiable manner, and when the modified delivery quantity is set, modify the delivery detail data based on the modified delivery quantity, and update the current inventory data stored in the inventory database 106a based on the delivery detail data. In addition, the production performance registration unit 102h may display the dispense quantity set in the dispense detail data in a modifiable manner, and when a modified dispense quantity is set by the raw material weighing staff, may modify the dispense detail data based on the modified dispense quantity, and may update the current inventory data stored in the inventory database 106a based on the dispense detail data.

[0043] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0044] [Raw material inventory management by expiration date] Here, an example of the expiration date-based raw material inventory management process in this embodiment will be described with reference to Fig. 5. Fig. 5 is a flow chart showing an example of the process of the expiration date-based raw material inventory management device 100 in this embodiment.

[0045] As shown in FIG. 5, when a product, a production start date, and a planned production quantity based on a sales plan are set by a production staff member via the input device 112, the production plan acquisition unit 102a acquires production plan data that is set by linking the product, the production start date, and the planned production quantity (step SA-1).

[0046] Then, the manufacturing instruction acquisition unit 102b acquires manufacturing instruction data that is linked to the manufacturing start date, the raw materials required to manufacture the planned production quantity of the product, and the planned delivery quantity of each raw material, based on the manufacturing configuration master 106b and the production plan data (step SA-2).

[0047] Then, based on the current inventory data stored in the inventory database 106a and the production instruction data, the planned inventory acquisition unit 102c acquires planned inventory data that is set by linking the planned quantities of raw materials identified as items to be received or delivered in lot number order, the planned inventory quantities, the production start date, the raw materials, and the planned shortage inventory quantities, taking into account the raw materials with lot numbers that will expire on the production start date (step SA-3).

[0048] Then, when an inquiry request is input by the ordering person via the input device 112, the planned stock inquiry unit 102d displays a planned stock inquiry screen including the planned stock data on the output device 114 (step SA-4).

[0049] Then, when the ordering clerk sets the raw materials, expected arrival date, and order quantity via the input device 112, the order acquisition unit 102e acquires order data set by linking the raw materials, expected arrival date, and order quantity, and when the raw materials arrive after the raw materials are ordered, when the ordering clerk inputs arrival input data setting the raw materials, the expiration date of the raw materials, and the arrival quantity of the raw materials via the input device 112, the arrival acquisition unit 102f assigns lot numbers in order of expiration date based on the arrival input data, acquires arrival data set by linking the raw materials, the expiration date, the lot number, and the inventory quantity that is the arrival quantity, and uses the arrival data to update the current inventory data stored in the inventory database 106a (step SA-5).

[0050] Then, when the production staff sets the product, the product's expiration date, and the acceptance quantity via the input device 112, the acceptance acquisition unit 102g acquires the acceptance data set by linking the product, the product's expiration date, and the acceptance quantity (step SA-6).

[0051] Then, the production history registration unit 102h acquires dispensing detail data that sets the dispensing quantity of raw materials required for product production based on the production configuration master 106b and the receiving data, identifies the raw materials set in the current inventory data to be dispensed in lot number order based on the dispensing detail data, acquires dispensing detail data that sets the dispensing quantity of raw materials for each lot number, and updates the current inventory data stored in the inventory database 106a based on the dispensing detail data (step SA-7).

[0052] Then, the production record registration unit 102h displays the dispense quantity set in the dispense detail data on the output device 114 in a modifiable manner, and when the raw material weighing staff sets the modified dispense quantity via the input device 112, modifies the dispense detail data based on the modified dispense quantity, and updates the current inventory data stored in the inventory database 106a based on the dispense detail data (step SA-8), and ends the process.

[0053] Here, an example of the planned inventory inquiry process in this embodiment will be described with reference to Fig. 6 and Fig. 7. Fig. 6 and Fig. 7 are diagrams showing an example of the planned inventory inquiry process in this embodiment.

[0054] In this embodiment, current inventory data by expiration date is used, expiration date stock is taken into account as the planned number to be removed, and the planned inventory quantity is calculated by referring to the current inventory data and planned receipts and payments (production instruction data and order data).

[0055] As shown in FIG. 6, in this embodiment, the starting point of the inventory quantity to be received is obtained from (1) current inventory data, and the quantity to be taken out is obtained from (2) current inventory (expired) and (3) production instruction data, so that the ordering clerk can confirm the planned inventory of 20 kg of raw materials (eggs) required on October 3rd.

[0056] That is, as shown in FIG. 6, in this embodiment, for a record with (1) data = "current inventory", the receipt / payment date is obtained from the current inventory data and is the starting point when calculating the planned inventory, so the receipt / payment date is left blank and displayed on the planned inventory inquiry screen. Also, as shown in FIG. 6, in this embodiment, for a record with (2) data = "expired", the planned receipt / payment date = the expiration date, and the planned inventory quantity is subtracted, so the sign of the planned receipt / payment quantity is inverted, the planned inventory quantity is set to 0 kg, and the current inventory remaining at the time of the expiration date arrival is displayed on the planned inventory inquiry screen from the current inventory data. Also, as shown in FIG. 6, in this embodiment, for a record with (3) data = "production instruction", the planned date = the production start date, and the withdrawal quantity to be used on the production start date from the production instruction data is displayed on the planned inventory inquiry screen. In other words, as shown in Figure 6, in this embodiment, the total planned quantity to be received or paid is obtained from the most recent planned inventory quantity, and if the quantity to be paid is greater than or equal to the planned inventory, the difference with the total planned quantity to be received or paid is subtracted in a record with a blank lot. Therefore, in the case of row = "4", the most recent record with expiration date = "2021 / 10 / 4" (lot number L002) is row = "2", so the planned inventory quantity of 15 kg is compared with the manufacturing instruction data payment quantity of 20 kg, and a blank lot record is created for the difference of 5 kg based on "20kg-15kg", and "-5kg" is displayed as the planned inventory quantity on the planned inventory inquiry screen.

[0057] Then, as shown in FIG. 7, in this embodiment, after ordering consideration, if an order is placed for arrival on 10 / 2 so that the planned inventory quantity on 10 / 3 does not fall short of inventory, the planned quantity to be received is obtained from (4) the ordering data.

[0058] That is, in this embodiment, for records with (4) data = "order", the scheduled receipt / delivery date is set to the scheduled arrival date, the order quantity is added to the scheduled inventory as of the scheduled arrival date, and since the lot number and expiration date are assigned at the time of arrival, the scheduled time is left blank, and the order quantity to be used on the scheduled arrival date from the order data is displayed on the scheduled inventory inquiry screen. Also, as shown in Fig. 7, in this embodiment, for records with (3) data = "production instructions", the scheduled date is set to the production start date, and the dispatch quantity to be used on the production start date from the production instruction data is displayed on the scheduled inventory inquiry screen. In other words, as shown in FIG. 7, in this embodiment, the total value of the planned receipt and payment quantities is subtracted from the planned inventory as of the production start date in order of expiration date until it reaches the dispensing quantity, and the total value of the planned receipt and payment quantities is obtained from the most recent planned inventory quantity. If the dispensing quantity is equal to or greater than the planned inventory, the difference from the total value of the planned receipt and payment quantities is subtracted from the record with the lot blank. Therefore, in the case of row = "5", the most recent record with expiration date = "2021 / 10 / 4" (lot number L002) is row = "2". Therefore, the planned inventory quantity of 15kg is compared with the production instruction data issue quantity of 20kg, and the difference of 5kg is subtracted from the next expiration date due to "20kg - 15kg". As the inventory quantities for lot numbers = L001 and L002 are 0 in the nearest rows = "3" and "5", respectively, this is subtracted from the planned inventory quantity for the blank lot in row = "4", and "10 - 5 = 5kg" is displayed as the planned inventory quantity in row = "6" on the planned inventory inquiry screen.

[0059] An example of manufacturing record management processing in this embodiment will be described with reference to Fig. 8 to Fig. 11. Fig. 8 to Fig. 11 are diagrams showing an example of manufacturing record management processing in this embodiment.

[0060] As shown in FIG. 8, in this embodiment, incoming data by lot is registered by inputting incoming goods, and inventory is managed by lot (by expiration date). For raw materials that are not subject to lot or expiration date management (e.g., tube bottles), the lot number and expiration date are left blank.

[0061] As shown in FIG. 9, in this embodiment, the production person inputs the production results, and new receipt data is registered, which includes the lot number, the expiration date, and the product volume (received quantity).

[0062] As shown in FIG. 10, in this embodiment, there is no need for registration by the product manufacturing line staff, and the number of items to be dispensed is automatically calculated from the manufacturing configuration master 106b which manages the manufacturing configuration master, the number of received products, and the product recipe data, the dispensing detail data is automatically created, the current inventory quantity in the current inventory data is compared with the number of items to be dispensed in the dispensing detail data, and the cumulative number of items to be dispensed by lot is added up until it reaches the number of items to be dispensed in the dispensing detail data, thereby automatically calculating the number of items to be dispensed by lot.

[0063] Then, in this embodiment, as shown in Fig. 11, if the measurement results are different (if there is a difference from the automatically calculated result), the raw material dispense quantity is corrected and registered by the raw material measurement person by inputting the production results, and the area where the difference occurred (the consumption amount of salad oil for lot number: L002) is corrected. Note that, as shown in Fig. 11, in this embodiment, the only area that the raw material measurement person inputs is the raw material dispense data (dispense detail data and dispense detailed data). Also, as shown in Fig. 11, in this embodiment, the receiving data is kept as it has been registered by the production person, and is not changed.

[0064] In this manner, in the first-in, first-out inventory update process when actual production results are input in this embodiment, raw material inventory is managed by lot (by expiration date), and when actual production results are input, the number of products received and the number of raw materials dispensed are recorded simultaneously. When the number of products received is recorded, the number of raw materials dispensed is automatically calculated first-in, first-out from the manufacturing configuration master 106b and the expiration date data in the inventory data, and when the number of products dispensed is recorded, the calculation result when the number of received quantities is recorded can be corrected.

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

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

[0067] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0068] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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

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

[0071] Moreover, with regard to the expiration date-based raw material inventory management device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.

[0072] For example, the processing functions of the expiration date-based raw material inventory management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the expiration date-based raw material inventory management device 100 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 HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and constitutes a control unit in cooperation with the CPU.

[0073] In addition, this computer program may be stored in an application program server connected to the expiration date-based raw material inventory management device 100 via any network, and it is also possible to download all or part of it as needed.

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

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

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

[0077] The expiration date-based raw material inventory management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected to any peripheral device. The expiration date-based raw material inventory management device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0078] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0079] The present invention is useful in industries such as manufacturing industries, including the food manufacturing industry, where expiration date control of raw materials is required. [Explanation of symbols]

[0080] 100 Expiration date-based raw material inventory management device 102 Control section 102a Production Planning Department 102b Manufacturing instruction acquisition department 102c Scheduled Inventory Acquisition Department 102d Scheduled Stock Inquiry Section 102e Order Acquisition Department 102F Arrival Acquisition Department 102g Acceptance and Acquisition Department 102h Manufacturing Record Registration Department 104 Communication interface section 106 Storage section 106a Inventory Database 106b Manufacturing configuration master 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A raw material inventory management device according to expiration date, comprising a memory unit and a control unit, The storage unit is An inventory storage means for storing current inventory data that is set by linking raw materials, expiration dates, lot numbers in the order of the expiration dates, and inventory quantities; A manufacturing configuration master that links and sets the raw materials that make up the product and the required quantity of each raw material; Equipped with The control unit is a production plan acquisition means for acquiring production plan data that is set by linking the product, the production start date, and the planned production quantity; a manufacturing instruction acquisition means for acquiring manufacturing instruction data that is set by linking the manufacturing start date, the raw materials required for manufacturing the product of the planned production quantity, and the planned delivery quantity of each of the raw materials based on the manufacturing configuration master and the production plan data; a planned inventory acquisition means for acquiring planned inventory data that is set by linking the planned quantities of the raw materials specified as the raw materials to be received or delivered in the order of the lot numbers, taking into account the raw materials of the lot numbers whose expiration date will expire on the production start date based on the current inventory data and the production instruction data, and the planned inventory quantities; an arrival acquisition means for, when arrival input data is input that sets the raw materials, the expiration date of the raw materials, and the arrival quantity of the raw materials, assigning lot numbers in the order of the expiration date based on the arrival input data, acquiring arrival data that is set by linking the raw materials, the expiration date, the lot number, and the inventory quantity that is the arrival quantity, and updating the current inventory data stored in the inventory storage means using the arrival data; An acceptance acquisition means for acquiring acceptance data that is set by linking the product, the expiration date of the product, and the acceptance quantity; a production record registration means for acquiring delivery detail data, which sets the delivery quantities of the raw materials required for the manufacture of the product, based on the manufacturing configuration master and the receiving data, identifying the raw materials set in the current inventory data to be delivered in the order of the lot numbers, based on the delivery detail data, acquiring delivery detail data, which sets the delivery quantities of the raw materials for each lot number, and updating the current inventory data stored in the inventory storage means, based on the delivery detail data; A raw material inventory management device according to expiration date, comprising:

2. The planned inventory data is Furthermore, the production start date, the raw materials, and the estimated shortage inventory quantity are set in a linked manner, The control unit is a planned inventory inquiry means for displaying the planned inventory data; An order acquisition means for acquiring order data that is set by linking the raw materials, the expected arrival date, and the order quantity; The raw material inventory management device according to claim 1, further comprising:

3. The manufacturing record registration means The expiration date-based raw material inventory management device as described in claim 1 is further characterized in that the dispensing quantity set in the dispensing detail data is displayed in a modifiable manner, and when a modified dispensing quantity is set, the dispensing detail data is modified based on the modified dispensing quantity, and the current inventory data stored in the inventory storage means is updated based on the dispensing detail data.

4. The receiving and acquiring means is Acquire receipt data that is set by a manufacturing person by linking the product, the expiration date of the product, and the receipt quantity; The manufacturing record registration means The expiration date-based raw material inventory management device as described in claim 3, characterized in that the dispensing quantity set in the dispensing detail data is displayed in an editable manner, and when the revised dispensing quantity is set by the raw material weighing staff, the dispensing detail data is revised based on the revised dispensing quantity, and the current inventory data stored in the inventory storage means is updated based on the dispensing detail data.

5. A method for managing raw material inventory by expiration date to be executed by a raw material inventory management device having a memory unit and a control unit, The storage unit is An inventory storage means for storing current inventory data that is set by linking raw materials, expiration dates, lot numbers in the order of the expiration dates, and inventory quantities; A manufacturing configuration master that links and sets the raw materials that make up the product and the required quantity of each raw material; Equipped with Executed in the control unit: A production plan acquisition step of acquiring production plan data that is set by linking the product, the production start date, and the planned production quantity; a manufacturing instruction acquisition step of acquiring manufacturing instruction data that is set by linking the manufacturing start date, the raw materials required for manufacturing the product of the planned production quantity, and the planned delivery quantity of each of the raw materials based on the manufacturing configuration master and the production plan data; a planned inventory acquisition step of acquiring planned inventory data that is set by linking the planned quantities of the raw materials identified as the raw materials to be received or delivered in the order of the lot numbers, based on the current inventory data and the manufacturing instruction data, with the raw materials having the lot numbers whose expiration dates will expire on the manufacturing start date, and the planned inventory quantities; an arrival acquisition step of, when arrival input data is input that sets the raw materials, the expiration date of the raw materials, and the arrival quantity of the raw materials, assigning lot numbers in the order of the expiration date based on the arrival input data, acquiring arrival data that is set by linking the raw materials, the expiration date, the lot number, and the inventory quantity that is the arrival quantity, and updating the current inventory data stored in the inventory storage means using the arrival data; An acceptance acquisition step of acquiring acceptance data that is set by linking the product, the expiration date of the product, and the acceptance quantity; a production performance registration step of acquiring delivery detail data, which sets the delivery quantities of the raw materials required for the manufacture of the product, based on the manufacturing configuration master and the receiving data, identifying the raw materials set in the current inventory data to be delivered in the order of the lot numbers, based on the delivery detail data, acquiring delivery detail data, which sets the delivery quantities of the raw materials for each lot number, and updating the current inventory data stored in the inventory storage means, based on the delivery detail data; A method for managing raw material inventory by expiration date, comprising:

6. A raw material inventory management program according to expiration date to be executed by a raw material inventory management device having a memory unit and a control unit, The storage unit is An inventory storage means for storing current inventory data that is set by linking raw materials, expiration dates, lot numbers in the order of the expiration dates, and inventory quantities; A manufacturing configuration master that links and sets the raw materials that make up the product and the required quantity of each raw material; Equipped with In the control unit, A production plan acquisition step of acquiring production plan data that is set by linking the product, the production start date, and the planned production quantity; a manufacturing instruction acquisition step of acquiring manufacturing instruction data that is set by linking the manufacturing start date, the raw materials required for manufacturing the product of the planned production quantity, and the planned delivery quantity of each of the raw materials based on the manufacturing configuration master and the production plan data; a planned inventory acquisition step of acquiring planned inventory data that is set by linking the planned quantities of the raw materials identified as the raw materials to be received or delivered in the order of the lot numbers, based on the current inventory data and the manufacturing instruction data, with the raw materials having the lot numbers whose expiration dates will expire on the manufacturing start date, and the planned inventory quantities; an arrival acquisition step of, when arrival input data is input that sets the raw materials, the expiration date of the raw materials, and the arrival quantity of the raw materials, assigning lot numbers in the order of the expiration date based on the arrival input data, acquiring arrival data that is set by linking the raw materials, the expiration date, the lot number, and the inventory quantity that is the arrival quantity, and updating the current inventory data stored in the inventory storage means using the arrival data; An acceptance acquisition step of acquiring acceptance data that is set by linking the product, the expiration date of the product, and the acceptance quantity; a production performance registration step of acquiring delivery detail data, which sets the delivery quantities of the raw materials required for the manufacture of the product, based on the manufacturing configuration master and the receiving data, identifying the raw materials set in the current inventory data to be delivered in the order of the lot numbers, based on the delivery detail data, acquiring delivery detail data, which sets the delivery quantities of the raw materials for each lot number, and updating the current inventory data stored in the inventory storage means, based on the delivery detail data; A program for managing raw material inventory by expiration date.

Citation Information

Patent Citations

  • Stock control system

    JP2001287811A

  • Food trace-back system and method, and two-dimensional code issuing device

    JP2005276154A

  • Shipment planning device and method

    JP2006072701A

  • Production management method of electronic circuit board and production management system

    JP2007019320A

  • Production plan support method and device, and computer program

    JP2009245217A