Inventory management apparatus, inventory management method, and inventory management program

Abstract

To provide a novel system capable of easily and correctly evaluating material costs in a balanced manner based on the weight of raw materials used directly from the actual volume of a traded product regardless of the form of a product such as whether it is a solid product or a liquid product and the degree of its concentration, properly allocating the material costs, and realizing more precise cost calculation.SOLUTION: An inventory management apparatus comprises: receiving means for receiving a combination of item identification information and an actual purchase quantity together with a purchase unit price or a purchase amount which is obtained by multiplying the actual purchase quantity by the purchase unit price; and conversion means for identifying a conversion coefficient corresponding to the item identification information received by the receiving means from among conversion coefficients registered in advance for each item identification information in an item master, and calculating a purchase quantity converted into a concentration from the actual purchase quantity received by the receiving means based on the identified conversion coefficient.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 technology]

[0002] For example, food raw materials such as sugar cane are secondarily processed into various forms of products, including solid products such as refined sugar, as well as liquid products (such as processed sugar such as syrup) that are liquefied by dissolving it in water, etc. Among these, when liquid products are evaluated based on the actual volume of production when calculating the cost of the product, unlike when evaluating solid products, it is difficult to reflect the weight of the raw materials used in the evaluation, and therefore it may not be possible to evaluate material costs in a balanced and correct manner.

[0003] For these reasons, there is a demand for a new system that can easily and correctly evaluate material costs in a balanced manner based on the weight of the raw materials used, regardless of the product's form (such as whether it is a solid or liquid product, or its concentration), and that can appropriately allocate material costs, thereby enabling more precise cost accounting. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2021-163272 A Summary of the Invention [Problem to be solved by the invention]

[0005] The object of the present invention is to provide a new system that can easily and correctly evaluate material costs in a balanced manner based on the weight of the raw materials used, regardless of the form of the product (such as whether it is a solid or liquid product, or its concentration), and can appropriately allocate material costs, thereby achieving more precise cost accounting. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the inventory management device of the present invention is an inventory management device equipped with a control unit, wherein the control unit is characterized in that it comprises a reception means for receiving a combination of item identification information and actual purchase quantity along with a purchase amount, which is the purchase unit price or the purchase unit price multiplied by the actual purchase quantity, and a conversion means for identifying a conversion coefficient corresponding to the item identification information accepted by the reception means from conversion coefficients pre-registered in an item master for each item identification information, and for calculating the purchase quantity converted into concentration from the actual purchase quantity accepted by the reception means based on the identified conversion coefficient.

[0007] In addition, the inventory management device of the present invention is characterized in that the conversion means identifies a weight conversion coefficient and a concentration conversion coefficient that correspond to the item identification information accepted by the receiving means from among the weight conversion coefficients and concentration conversion coefficients pre-registered in the item master for each item identification information, and calculates the weight conversion purchase quantity and concentration conversion purchase quantity from the actual purchase quantity accepted by the receiving means based on the identified weight conversion coefficient and concentration conversion coefficient.

[0008] In addition, the inventory management device of the present invention is characterized in that the purchase quantity converted into weight is the quantity obtained by multiplying the actual purchase quantity by a weight conversion coefficient, and the purchase quantity converted into concentration is the quantity obtained by multiplying the purchase quantity converted into weight by the concentration conversion coefficient.

[0009] In addition, the inventory management device of the present invention is characterized in that the reception means is a purchase input screen for receiving a combination of item identification information and actual purchase quantity along with the purchase price or purchase amount, and when the combination of item identification information and actual purchase quantity is input onto the screen, a purchase input screen is output on which the purchase quantity converted into weight and the purchase quantity converted into concentration calculated by the conversion means are displayed on the screen.

[0010] In addition, the inventory management device of the present invention is characterized in that the control unit further includes an evaluation means for calculating an evaluated unit price of concentration conversion, which is a unit price obtained by dividing the purchase amount based on the purchase unit price accepted by the receiving means or the inventory amount plus the purchase amount accepted by the receiving means, by the inventory quantity converted to concentration plus the purchase quantity converted to concentration calculated by the conversion means, for each item identification information.

[0011] In addition, the inventory management device of the present invention further includes a registration means, in which the control unit distinguishes item identification information for each acceptance of the combination by the acceptance means, and registers the purchase amount based on the purchase unit price accepted by the acceptance means or the purchase amount accepted by the acceptance means and the purchase quantity converted to concentration calculated by the conversion means as the receipt amount and the receipt quantity converted to concentration in the receipt and payment data in which the inventory and post-shipment amount and the inventory and post-shipment amount converted to concentration are registered, respectively, and is characterized in that the evaluation means calculates, for each item identification information, an evaluation unit price in concentration conversion, which is a unit price obtained by dividing the inventory amount based on the inventory and post-shipment amount registered in the receipt and payment data by the inventory quantity converted to concentration based on the inventory and post-shipment amount registered in the receipt and payment data.

[0012] In addition, the inventory management device of the present invention is characterized in that the evaluation means calculates, at the end of each month, for each item identification information, the end-of-month inventory evaluation unit price converted into concentration, which is a unit price obtained by dividing the current month's balance amount, which is the inventory amount at the end of that month based on the inbound and outbound amounts registered in the receipt and payment data, by the current month's balance quantity, which is the inventory quantity converted into concentration at the end of that month based on the inbound and outbound quantities converted into concentration registered in the receipt and payment data.

[0013] In addition, the inventory management method of the present invention is an inventory management method executed in an inventory management device equipped with a control unit, and is characterized in including a reception step executed by the control unit of receiving a combination of item identification information and actual purchase quantity along with a purchase amount, which is the purchase unit price or the purchase unit price multiplied by the actual purchase quantity, and a conversion step of identifying a conversion coefficient corresponding to the item identification information received in the reception step from conversion coefficients pre-registered in the item master for each item identification information, and calculating the concentration-converted purchase quantity from the actual purchase quantity received in the reception step based on the identified conversion coefficient.

[0014] In addition, the inventory management program of the present invention is an inventory management program to be executed by an inventory management device equipped with a control unit, and is characterized in that it includes a reception step of receiving a combination of item identification information and actual purchase quantity along with a purchase amount, which is the purchase unit price or the purchase unit price multiplied by the actual purchase quantity, to be executed by the control unit, and a conversion step of identifying a conversion coefficient corresponding to the item identification information received in the reception step from conversion coefficients pre-registered in the item master for each item identification information, and calculating the purchase quantity converted into concentration from the actual purchase quantity received in the reception step based on the identified conversion coefficient. Effect of the Invention

[0015] According to the system of the present invention, material costs can be easily and correctly evaluated in a balanced manner based on the weight of the raw materials used, regardless of the form of the product (such as whether it is a solid or liquid product, or its concentration), and material costs can be appropriately allocated, thereby achieving more precise cost accounting. [Brief description of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a PC 100 according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of an item master according to an embodiment. [Diagram 3]FIG. 3 is a diagram showing an example of a purchase input screen according to an embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of receipt and payment data in one embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of a purchase input screen according to an embodiment. [Figure 6] FIG. 6 is a diagram illustrating an example of receipt and payment data in one embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of the tally table and the evaluation unit price table according to an embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0017] 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.

[0018] [1. Configuration] Here, an example of the configuration of a PC (personal computer) 100 according to this embodiment including the inventory management device of the present invention will be described with reference to Fig. 1. Note that the configuration of this embodiment is merely an example, and the present invention is not limited to being realized with the configuration of this embodiment. Also, in the following description of the configuration, duplicated descriptions may be omitted.

[0019] 1 is a block diagram showing an example of the configuration of a PC 100. The PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108, and is communicably connected to a server 200 (e.g., a Web server, etc.) that stores various data (e.g., each data item stored in the storage unit 106, which may be described later) via a network 300 (e.g., the Internet, an intranet, a LAN (Local Area Network), etc.).

[0020] The components of the PC 100 are communicatively connected via any communication path.

[0021] In addition, PC 100 may be, for example, a stationary type such as a desktop personal computer, or may be a portable type such as a notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

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

[0023] The control unit 102 conceptually includes, in terms of functions, a reception unit 102a, a conversion unit 102b, a registration unit 102c, an evaluation unit 102d, and the like.

[0024] The receiving unit 102a receives a combination of the item identification information and the actual purchase quantity together with the unit purchase price or purchase amount. The purchase amount is the unit purchase price multiplied by the actual purchase quantity.

[0025] The actual purchase quantity does not necessarily mean only the quantity based on the amount of raw materials, but includes the quantity based on the sales unit of the product, and is a quantity that can differ for each item, such as the number of lots, number of containers, number of bags, number of pieces, mass number, volume number, etc. The purchase price is the unit purchase price according to the actual purchase quantity. Item identification information is information that makes it possible to identify an item, and can be in the form of item classification, item code, item number, etc. Items are distinguished by differences in product form (especially sales form), including differences in ingredients and concentration.

[0026] The reception unit 102a outputs a purchase input screen for receiving a combination of item identification information and actual purchase quantity together with the purchase unit price or purchase amount. The purchase input screen output by the reception unit 102a is a purchase input screen on which, when a combination of item identification information and actual purchase quantity is input onto the screen, the purchase quantity converted into concentration (particularly the purchase quantity converted into weight and the purchase quantity converted into concentration) calculated by the conversion unit 102b described below is displayed on the screen.

[0027] The accepting unit 102a accepts a combination of a purchase price or purchase amount, item identification information, and actual purchase quantity that is input on a purchase input screen and then confirmed as necessary.

[0028] The conversion unit 102b identifies a conversion coefficient corresponding to the item identification information received by the receiving unit 102a from among the conversion coefficients pre-registered in the item master for each item identification information, and calculates the purchase quantity for concentration conversion from the actual purchase quantity received by the receiving unit 102a based on the identified conversion coefficient.

[0029] With this configuration, material costs can be easily and correctly evaluated in a balanced manner based on the weight of the raw materials used, regardless of the form of the product, such as whether it is a solid or liquid product, or its concentration, and material costs can be appropriately allocated, thereby achieving more precise cost accounting.

[0030] The conversion unit 102b identifies the weight conversion coefficient and concentration conversion coefficient corresponding to the item identification information received by the reception unit 102a from the weight conversion coefficients and concentration conversion coefficients pre-registered in the item master for each item identification information, and calculates the purchase quantity in weight conversion and the purchase quantity in concentration conversion from the actual purchase quantity received by the reception unit 102a based on the identified weight conversion coefficient and concentration conversion coefficient.

[0031] With this configuration, even for products that are not sold based on weight, the material costs can be evaluated in a well-balanced manner based on the quantity.

[0032] The item master can change, update, add, or delete the conversion coefficients (i.e., weight conversion coefficients, concentration conversion coefficients) registered therein at any time for each item identification information, and the conversion unit 102b calculates the purchase quantity converted into concentration (and the purchase quantity converted into weight) based on the conversion coefficients in the latest item master.

[0033] The purchase quantity converted into weight is the quantity obtained by multiplying the actual purchase quantity by the weight conversion coefficient. The purchase quantity converted into concentration is the quantity obtained by multiplying the purchase quantity converted into weight by the concentration conversion coefficient.

[0034] The registration unit 102c distinguishes the item identification information for each acceptance of the combination by the acceptance unit 102a, and registers the purchase amount based on the purchase unit price accepted by the acceptance unit 102a or the purchase amount accepted by the acceptance unit 102a and the purchase quantity converted to concentration calculated by the conversion unit 102b (in particular, the purchase quantity converted to weight and the purchase quantity converted to concentration) as the receipt amount and the receipt quantity converted to concentration (in particular, the receipt quantity converted to weight and the receipt quantity converted to concentration), respectively, in the receipt and payment data in which the receipt and shipment amounts and receipt and shipment quantities converted to concentration are registered.

[0035] The receipt and payment data includes the accounting year and month indicating the time of receipt and shipment, receipt and payment identification information distinguishing receipt and shipment, receipt and payment classification, item identification information, receipt and shipment quantity of the original, receipt and shipment quantity converted into concentration (and receipt and shipment quantity converted into weight), receipt and shipment amount, etc. registered for each receipt and shipment.

[0036] The evaluation unit 102d calculates, for each item identification information, an evaluation unit price converted into concentration, which is the unit price obtained by dividing the purchase amount based on the purchase unit price accepted by the accepting unit 102a or the inventory amount plus the purchase amount accepted by the accepting unit 102a, by the inventory quantity converted into concentration plus the purchase quantity converted into concentration calculated by the conversion unit 102b.

[0037] The evaluation unit 102d counts up the inventory amount and the inventory quantity converted into concentration by item identification information, and calculates the evaluation unit price converted into concentration based on the counted inventory amount and inventory quantity converted into concentration. The inventory amount and inventory quantity converted into concentration are counted up by the evaluation unit 102d based on the inventory amount and inventory quantity registered in the receipt and payment data.

[0038] The evaluation unit 102d creates an aggregation table that summarizes the aggregated inventory amounts and inventory quantities converted into concentrations by item identification information.The evaluation unit 102d creates an evaluation unit price table that summarizes the calculated evaluation unit prices converted into concentrations by item identification information.

[0039] The evaluation unit 102d calculates, for each item identification information, an evaluation unit price converted into concentration, which is the unit price obtained by dividing the inventory amount based on the inbound and outbound amounts registered in the receipt and payment data by the inventory quantity converted into concentration based on the inbound and outbound quantities registered in the receipt and payment data.

[0040] The evaluation unit 102d calculates, at the end of each month, for each item identification information, the end-of-month inventory evaluation unit price converted into concentration, which is the unit price obtained by dividing the current month's balance amount, which is the inventory amount at the end of that month based on the inbound and outbound amounts registered in the receipt and payment data, by the current month's balance quantity, which is the inventory quantity converted into concentration at the end of that month based on the inbound and outbound quantities converted into concentration registered in the receipt and payment data.

[0041] The communication interface unit 104 communicatively connects the PC 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.

[0042] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0043] The storage unit 106 conceptually includes a master storage unit 106a, a data storage unit 106b, a table storage unit 106c, and the like.

[0044] The master storage unit 106a stores an item master in which conversion coefficients, particularly weight conversion coefficients and concentration conversion coefficients, are registered in advance for each item identification information. The data storage unit 106b stores receipt and payment data in which the warehousing and shipping amounts and the warehousing and shipping quantities in concentration conversion are registered. The table storage unit 106c stores an tally table, an evaluation unit price table, and the like created by the evaluation unit 102d.

[0045] An input device 400 and an output device 500 are connected to the input / output interface unit 108. The output device 400 includes display devices such as a display and a projector, audio devices such as a speaker, printing devices such as a printer, and devices that allow downloading in a data file format. The data file format may be a file format known in the art, such as PDF, CSV, a document file, a spreadsheet file, or a text file. The input device 500 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function.

[0046] [2. Specific Examples] Hereinafter, the information processing from reception of the actual purchase quantity by the inventory management device according to the present invention to creation of the tally table and the evaluated unit price table will be described using a specific example with reference to FIGS.

[0047] 2 is a diagram showing the item master in this example. In the item master in this example, item codes (item identification information), item names corresponding to the item codes, actual units, weight conversion coefficients, concentration conversion coefficients, and item classifications are registered for each item code.

[0048] (Example 1: Sugar A) As a first specific example, we will explain in detail the flow of information processing up to registration in receipt and payment data when a product with item code "H002" and item name "Sugar A" of two items registered in the item master shown in Figure 2 is purchased in June 2023 (202306) at a unit price (purchase price) of "15.0" and physical quantity (physical purchase quantity) of "5".

[0049] 3 is a diagram showing a purchase input screen in this specific example. The purchase input screen in this specific example has an input field for item (an input field for item code and item name), an input field for physical quantity (physical purchase quantity), an input field for unit price (purchase price), a display field for physical unit, a display field for weight conversion number (purchase quantity converted into weight), a display field for concentration conversion number (purchase quantity converted into concentration), a display field for amount of production (purchase price), a "Cancel" button, and a "Confirm" button.

[0050] 4 is a diagram showing receipt and payment data in this specific example. In the receipt and payment data in this specific example, the accounting year and month, receipt and payment number (receipt and payment identification information), line number, receipt and payment classification, item classification, item code, item name, actual quantity (actual amount of goods received and sent), weight conversion number (quantity of goods received and sent converted into weight), concentration conversion number (quantity of goods received and sent converted into concentration), receipt and payment amount (quantity of goods sent and received converted into concentration) are registered for each receipt and payment number.

[0051] First, the user inputs the item code "H002" and the item name "Sugar A" in the item input field on the purchase input screen output by the reception unit 102a, as shown in Fig. 3. The reception unit 102a receives the input item code and item name, extracts the actual unit of measure "bag" corresponding to the item code "H002" from the item master shown in Fig. 2, and displays "bag" in the actual unit display field on the purchase input screen, as shown in Fig. 3.

[0052] Furthermore, the user confirms that "bag" is displayed in the display field for the physical unit, and then inputs "5" corresponding to the displayed physical unit in the input field for the physical quantity (physical purchase quantity) on the purchase input screen, as shown in Fig. 3. The reception unit 102a receives the input physical quantity (physical purchase quantity), and the conversion unit 102b identifies the weight conversion coefficient "20.0" and the concentration conversion coefficient "1.0" corresponding to the item code "H002" from the item master shown in Fig. 2.

[0053] The conversion unit 102b multiplies the actual quantity (actual purchase quantity) "5" accepted by the acceptance unit 102a by the specified weight conversion coefficient "20.0" to calculate a weight conversion number (purchase quantity converted into weight) of "100" (5 x 20.0 = 100), and the acceptance unit 102a displays "100" in the weight conversion number (purchase quantity converted into weight) display field on the purchase input screen, as shown in Figure 3.

[0054] The conversion unit 102b multiplies the calculated weight conversion number (purchase quantity in weight conversion) "100" by the specified concentration conversion coefficient "1.0" to calculate the concentration conversion number (purchase quantity in concentration conversion) "100" (100 x 1.0 = 100), and the reception unit 102a displays "100" in the concentration conversion number (purchase quantity in concentration conversion) display field on the purchase input screen, as shown in Figure 3.

[0055] Furthermore, the user inputs "15.0" in the input field for the volume price (purchase price) as shown in FIG. 3. The reception unit 102a accepts the input volume price (purchase price). The conversion unit 102b multiplies the volume price (purchase price) "15.0" accepted by the reception unit 102a by the actual quantity (actual purchase quantity) "5" accepted by the reception unit 102a to calculate the volume amount (purchase amount) "75" (15.0 x 5 = 75), and the reception unit 102a displays "75" in the volume amount (purchase amount) display field on the purchase input screen as shown in FIG. 3. Finally, the user presses the "Confirm" button on the purchase input screen to confirm the input contents.

[0056] As shown in FIG. 4, the registration unit 102c sets the current month as the accounting year and month "202306", automatically assigns the receipt / payment number "U003" and the line number "1", sets the receipt / payment category to "production amount (purchase)", and then registers in the receipt / payment data the item code "H002" received by the reception unit 102a, the item name "Sugar A", the item category "product" corresponding to the above item code extracted from the item master shown in FIG. 2, the actual quantity (actual purchase quantity) "5" bags received by the reception unit 102a as the actual in / out quantity, the weight conversion number (purchase quantity in weight conversion) "100" kg and the concentration conversion number (purchase quantity in concentration conversion) "100" kg calculated by the conversion unit 102b as the weight conversion number and the concentration conversion number (in / out quantity in weight conversion and concentration conversion), and the output amount (purchase amount) "75" yen calculated by the conversion unit 102b as the receipt / payment amount (in / out amount).

[0057] (Example 2: Liquid sugar A) As a second specific example, in June 2023 (202306), a product with item code "H001" and item name "Liquid Sugar A", one of the two items registered in the item master shown in Figure 2, is purchased the first time at a unit price (purchase price) of "3.0" and a physical quantity (physical purchase quantity) of "10", the second time at a unit price (purchase price) of "4.5" and a physical quantity (physical purchase quantity) of "30", and the third time at a unit price (purchase price) of "3.6" and a physical quantity (physical purchase quantity) of "50". The following describes in detail the flow of information processing up to the creation of the aggregation table and evaluation unit price table based on the registration in the receipt and payment data.

[0058] Fig. 5 is a diagram showing a purchase input screen in this specific example. The purchase input screen in this specific example has the same configuration as the purchase input screen shown in Fig. 3 described above, except for the specific input contents and display contents.

[0059] Fig. 6 is a diagram showing receipt and payment data in this specific example. The receipt and payment data in this specific example has the same configuration as the receipt and payment data shown in Fig. 4 described above, except for the specific registered contents.

[0060] 7 shows the tally table and the evaluation unit price table in this specific example. In the tally table in this specific example, the accounting year and month, item code, item name, quantity (concentration-converted stock quantity), and amount (stock amount) are registered for each item. In the evaluation unit price table in this specific example, the accounting year and month, item code, item name, and concentration-converted evaluation unit price are registered for each item.

[0061] First, the user inputs the item code "H001" and the item name "Liquid Sugar A" in the item input field of the purchase input screen output by the reception unit 102a as information on the first purchase, as shown in Fig. 5. The reception unit 102a receives the input item code and item name, extracts the physical unit of measure "Kg" corresponding to the item code "H001" from the item master shown in Fig. 2, and displays "Kg" in the physical unit display field of the purchase input screen, as shown in Fig. 5.

[0062] Furthermore, the user confirms that "Kg" is displayed in the display field for the physical unit, and then inputs "10" corresponding to the displayed physical unit in the input field for the physical quantity (physical purchase quantity) on the purchase input screen as information for the first purchase, as shown in Fig. 5. The reception unit 102a receives the input physical quantity (physical purchase quantity), and the conversion unit 102b identifies the weight conversion coefficient "1.0" and the concentration conversion coefficient "0.3" corresponding to the item code "H001" from the item master shown in Fig. 2.

[0063] The conversion unit 102b multiplies the actual quantity (actual purchase quantity) "10" accepted by the acceptance unit 102a by the specified weight conversion coefficient "1.0" to calculate a weight conversion number (purchase quantity converted into weight) of "10" (10 x 1.0 = 10), and the acceptance unit 102a displays "10" in the weight conversion number (purchase quantity converted into weight) display field on the purchase input screen, as shown in Figure 5.

[0064] The conversion unit 102b multiplies the calculated weight conversion number (purchase quantity in weight conversion) "10" by the specified concentration conversion coefficient "0.3" to calculate the concentration conversion number (purchase quantity in concentration conversion) "3" (10 x 0.3 = 3), and the reception unit 102a displays "3" in the concentration conversion number (purchase quantity in concentration conversion) display field on the purchase input screen, as shown in Figure 5.

[0065] Furthermore, the user inputs "3.0" in the input field for the volume price (unit purchase price) as information on the first purchase, as shown in FIG. 5. The reception unit 102a accepts the input volume price (unit purchase price). The conversion unit 102b multiplies the volume price (unit purchase price) "3.0" accepted by the reception unit 102a by the actual quantity (actual purchase quantity) "10" accepted by the reception unit 102a to calculate the volume amount (purchase amount) "30" (3.0 x 10 = 30), and the reception unit 102a displays "30" in the volume amount (purchase amount) display field on the purchase input screen, as shown in FIG. 5. Finally, the user presses the "Confirm" button on the purchase input screen to confirm the input contents.

[0066] The registration unit 102c, as shown in FIG. 6, sets the current month as the accounting year and month "202306", automatically assigns the receipt and payment number "U004" and the line number "1", sets the receipt and payment category to "production accounting (purchase)", and then records the item code "H001" and item name "liquid sugar A" received by the reception unit 102a, the item category "product" corresponding to the above item code extracted from the item master shown in FIG. 2, and the actual inventory quantity in and out of the warehouse as the information of the first purchase. The physical quantity (physical purchase quantity) "10" kg received by 102a, the weight conversion number (purchase quantity in weight conversion) "10" kg and the concentration conversion number (in / out quantity in weight conversion and concentration conversion) calculated by conversion unit 102b as the weight conversion number and concentration conversion number (purchase quantity in concentration conversion) "3" kg, and the volume amount (purchase amount) "30" yen calculated by conversion unit 102b as the receipt / payment amount (in / out amount) are registered in the receipt / payment data.

[0067] Similarly to the information for the first purchase, the user inputs the following information for the second purchase into the purchase input screen: item code "H001," item name "Liquid Sugar A," actual quantity (actual purchase quantity) "30," and unit price (purchase price) "4.5," and the reception unit 102a accepts the input information.

[0068] For the information on the second purchase, in the same manner as for the information on the first purchase, the conversion unit 102b calculates the weight conversion number (purchase quantity converted into weight) "30" (30 x 1.0 = 30), the concentration conversion number (purchase quantity converted into concentration) "9" (30 x 0.3 = 9), and the volume amount (purchase amount) "135" (4.5 x 30 = 135).

[0069] As with the information for the first purchase, the registration unit 102c registers in the receipt and payment data the accounting year and month "202306", receipt and payment number "U005", line number "1", receipt and payment category "production accounting (purchase)", item category "product", item code "H001", item name "Liquid sugar A", actual quantity (actual purchase quantity) "30" kg as the actual inventory quantity, weight conversion number (in / out quantity in weight conversion) "30" kg as the weight conversion number (in / out quantity in weight conversion), concentration conversion number (purchase quantity in concentration conversion) "9" kg as the concentration conversion number (in / out quantity in concentration conversion), and volume amount (purchase amount) "135" yen as the receipt and payment amount (in / out amount), as shown in FIG. 6.

[0070] Similarly to the information for the first purchase, the user inputs the following information for the third purchase into the purchase input screen: item code "H001," item name "Liquid Sugar A," actual quantity (actual purchase quantity) "50," and unit price (purchase price) "3.6," and the reception unit 102a accepts the input information.

[0071] For the information on the third purchase, in the same manner as for the information on the first purchase, the conversion unit 102b calculates the weight conversion number (purchase quantity converted into weight) "50" (50 x 1.0 = 50), the concentration conversion number (purchase quantity converted into concentration) "15" (50 x 0.3 = 15), and the volume amount (purchase amount) "180" (3.6 x 50 = 180).

[0072] As with the information for the first purchase, the registration unit 102c registers in the receipt and payment data the accounting year and month "202306", receipt and payment number "U006", row number "1", receipt and payment category "production accounting (purchase)", item category "product", item code "H001", item name "Liquid sugar A", actual quantity (actual purchase quantity) "50" kg as the actual inventory quantity, weight conversion number (in / out quantity in weight conversion) "50" kg as the weight conversion number (in / out quantity in weight conversion), concentration conversion number (in / out quantity in concentration conversion) "15" kg as the concentration conversion number (in / out quantity in concentration conversion), and volume amount (purchase amount) "180" yen as the receipt and payment amount (in / out amount), as shown in FIG. 6.

[0073] The evaluation unit 102d tally up the inventory amount (i.e., the current month's balance amount) and the inventory quantity converted into concentration (i.e., the current month's balance quantity) for the item with item code "H001" at the end of June 2023, based on the receipt and payment amount (in / out amount) and the in / out quantity converted into concentration registered in the receipt and payment data.

[0074] In the receipt and payment data, as of the end of June 2023, the receipt and payment amounts (warehouse / shipping amounts) and the receipt and shipment quantities converted into concentrations are registered as receipt and payment information for receipt and payment numbers "U004" to "U006" as shown in Figure 6. Since the receipt and payment information for receipt and payment numbers "U004" to "U006" is all based on the receipt and payment category "recording of output (purchase)", the total of the receipt and payment amounts (warehouse / shipping amounts) is the inventory amount "345" (30 + 135 + 180 = 345), and the total of the receipt and shipment quantities converted into concentrations is the inventory quantity converted into concentrations "27" (3 + 9 + 15 = 27).

[0075] Therefore, the evaluation unit 102d calculates, as a result of tallying up the receipt and payment data, the inventory amount as "345" and the inventory quantity converted into concentration as "27".

[0076] The evaluation unit 102d creates an aggregation table that summarizes the calculated inventory amount of "345" and the inventory quantity converted to concentration of "27" together with the accounting year and month of "202306", the item code of "H001", and the item name of "Liquid Sugar A", as shown in Figure 7, in the form of amount and quantity, respectively.

[0077] The evaluation unit 102d divides the calculated inventory amount "345" by the calculated inventory amount converted into concentration "27" to calculate the concentration-converted evaluation unit price (that is, the end-of-month inventory evaluation unit price) (345 / 27=12.78).

[0078] The evaluation unit 102d creates an evaluation unit price table that lists the calculated concentration-converted evaluation unit prices together with the accounting year and month "202306", the item code "H001", and the item name "Liquid Sugar A", as shown in FIG.

[0079] As described above, according to the system of the present invention, material costs can be easily and correctly evaluated in a balanced manner based on the weight of the raw materials used directly from the actual volume of the product being traded, regardless of the form of the product, such as whether it is a solid or liquid product, or its concentration, and material costs can be appropriately allocated, thereby achieving more precise cost accounting.

[0080] [3. 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.

[0081] 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.

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

[0083] [4. Other embodiments] Although the embodiments of the present invention have been described above, the present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept described in the claims.

[0084] For example, among the processes described in the above-mentioned 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.

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

[0086] Moreover, with regard to the PC 100, each of the components shown in the figures is merely a functional concept, and the PC 100 does not necessarily have to be physically configured as shown in the figures.

[0087] For example, the processing functions of each device constituting the PC100, particularly the processing functions performed by the control unit, 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 the information processing device to execute the processes described in this embodiment, and is mechanically read by each device 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 cooperates with the CPU to form the control unit.

[0088] In addition, this computer program may be stored in an application program server connected to the PC 100 via any network, and it is also possible to download all or part of it as necessary.

[0089] 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 first product. Here, the "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 (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.

[0090] 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 distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

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

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

[0093] 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]

[0094] The present invention is useful for inventory management in manufacturing industries, for example, where raw materials such as sugar are dissolved in water to produce liquid secondary processed products. [Explanation of symbols]

[0095] 100 pcs 102 Control section 102a Reception 102b Conversion section 102c Registration Department 102d Evaluation Section 104 Communication interface section 106 Storage section 106a Master storage unit 106b Data storage unit 106c Table storage section 108 Input / Output Interface Section 200 Servers 300 Network 400 Input Device 500 Output Device

Claims

1. An inventory management device including a control unit, The control unit: a receiving means for receiving a combination of item identification information and the actual purchase quantity together with a purchase amount, which is the unit purchase price or the unit purchase price multiplied by the actual purchase quantity; a conversion means for specifying a conversion coefficient corresponding to the item identification information received by the receiving means from among conversion coefficients registered in advance for each item identification information in the item master, and calculating a purchase quantity converted into a concentration from the purchase quantity of the actual product received by the receiving means based on the specified conversion coefficient. An inventory management device comprising:

2. The conversion means is Among the weight conversion coefficients and concentration conversion coefficients registered in advance in the item master for each item identification information, a weight conversion coefficient and a concentration conversion coefficient corresponding to the item identification information received by the receiving means are identified, and a purchase quantity converted into weight and a purchase quantity converted into concentration are calculated from the actual purchase quantity received by the receiving means based on the identified weight conversion coefficient and concentration conversion coefficient.

2. The inventory management device according to claim 1.

3. The purchase quantity converted into weight is the quantity obtained by multiplying the actual purchase quantity by the weight conversion coefficient, and the purchase quantity converted into concentration is the quantity obtained by multiplying the purchase quantity converted into weight by the concentration conversion coefficient.

3. The inventory management device according to claim 2.

4. The receiving means, A purchase input screen for receiving a combination of item identification information and actual purchase quantity together with a purchase unit price or purchase amount, and when the combination of item identification information and actual purchase quantity is input on the screen, a purchase input screen is output in which the purchase quantity converted into weight and the purchase quantity converted into concentration calculated by the conversion means are displayed on the screen.

3. The inventory management device according to claim 2.

5. The control unit: The apparatus further includes an evaluation means for calculating, for each item identification information, a purchase amount based on the purchase unit price received by the receiving means or an inventory amount including the purchase amount received by the receiving means, divided by an inventory amount including the purchase amount calculated by the conversion means.

2. The inventory management device according to claim 1.

6. The control unit: The method further comprises a registering means for registering, in receipt / payment data in which the warehousing / distribution amount and the warehousing / distribution quantity converted into concentration are registered, a purchase amount based on the purchase unit price accepted by the accepting means or a purchase amount accepted by the accepting means and a purchase quantity converted into concentration calculated by the conversion means as a warehousing amount and a warehousing quantity converted into concentration, respectively, by distinguishing item identification information for each acceptance of the combination by the accepting means, The evaluation means, Calculate the concentration-converted evaluation unit price, which is the unit price obtained by dividing the inventory amount based on the in / out amount registered in the receipt and payment data by the concentration-converted inventory quantity based on the concentration-converted in / out quantity registered in the receipt and payment data, for each item identification information.

6. The inventory management device according to claim 5.

7. The evaluation means, At the end of each month, calculate the end-of-month inventory valuation unit price converted into concentration, which is the unit price obtained by dividing the current month's balance amount, which is the inventory amount at the end of the month based on the in- and out-of-stock amount registered in the receipt and payment data, by the current month's balance amount, which is the inventory amount converted into concentration at the end of the month based on the in- and out-stock amount converted into concentration registered in the receipt and payment data, for each item identification information.

7. The inventory management device according to claim 6.

8. An inventory management method executed in an inventory management device having a control unit, Executed by the control unit, a receiving step of receiving a combination of item identification information and the actual purchase quantity together with a purchase amount, which is the purchase unit price or the purchase unit price multiplied by the actual purchase quantity; A conversion step of identifying a conversion coefficient corresponding to the item identification information received in the receiving step from among conversion coefficients registered in advance in the item master for each item identification information, and calculating a purchase quantity converted into a concentration from the purchase quantity of the actual product received in the receiving step based on the identified conversion coefficient.

1. An inventory management method comprising:

9. An inventory management program to be executed by an inventory management device having a control unit, To cause the control unit to execute a receiving step of receiving a combination of item identification information and the actual purchase quantity together with a purchase amount, which is the purchase unit price or the purchase unit price multiplied by the actual purchase quantity; A conversion step of identifying a conversion coefficient corresponding to the item identification information received in the receiving step from among conversion coefficients registered in advance in the item master for each item identification information, and calculating a purchase quantity converted into a concentration from the purchase quantity of the actual product received in the receiving step based on the identified conversion coefficient. An inventory management program characterized by:

Images