Inventory management device, inventory management method, and inventory management program
The inventory management device addresses the challenge of imbalanced cost calculations for liquid products by converting raw material quantities to weight and concentration-based values, ensuring accurate and balanced cost evaluation.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- OBIC CO LTD
- Filing Date
- 2023-08-24
- Publication Date
- 2026-06-16
AI Technical Summary
Existing inventory management systems struggle to accurately evaluate material costs for liquid products based on the weight of raw materials, leading to imbalanced cost calculations.
An inventory management device that includes a control unit capable of receiving item identification information and quantity, converting it to weight and concentration-based quantities using pre-registered conversion coefficients, and calculating concentration-converted evaluation unit prices.
Enables precise cost accounting by accurately evaluating material costs based on the weight of raw materials, regardless of product form, facilitating balanced cost allocation.
Smart Images
Figure 0007874590000001 
Figure 0007874590000002 
Figure 0007874590000003
Abstract
Description
Technical Field
[0001] The present invention relates to an inventory management device, an inventory management method, and an inventory management program.
Background Art
[0002] For example, food raw materials such as sugar cane are processed into various forms of products, including solid products such as refined sugar, and liquid products obtained by dissolving them in water or the like to make them liquid (such as processed sugar like syrup). Among them, when evaluating a liquid product based on the actual production quantity of the physical product when calculating the cost of the product, unlike the case of evaluating a solid product, it is difficult to reflect the weight of the raw materials used in the evaluation, so there are cases where the material cost cannot be properly and accurately evaluated in a balanced manner.
[0003] From this, there is a need for a new system that can easily and accurately evaluate the material cost in a balanced manner based on the weight of the raw materials used as it is, from the actual production quantity of the physical product traded regardless of the form of the product, such as whether it is a solid product, a liquid product, or its concentration, and can appropriately allocate the material cost, thereby realizing a more refined cost calculation.
Prior Art Documents
Patent Documents
[0004]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0005] An object of the present invention is to provide a new system that can easily and accurately evaluate the material cost in a balanced manner based on the weight of the raw materials used as it is, from the actual production quantity of the physical product traded regardless of the form of the product, such as whether it is a solid product, a liquid product, or its concentration, and can appropriately allocate the material cost, thereby realizing a more refined cost calculation. [Means for solving the problem]
[0006] To solve the above-mentioned problems and achieve the objective, the inventory management device according to the present invention is an inventory management device comprising a control unit, wherein the control unit includes a receiving means that receives a combination of item identification information and the quantity of physical goods purchased, along with the purchase price or the purchase amount which is the purchase price multiplied by the quantity of physical goods purchased, and a conversion means that identifies a conversion coefficient corresponding to the item identification information received by the receiving means from among the conversion coefficients that have been pre-registered in the item master for each item identification information, and calculates the quantity of purchase in concentration from the quantity of physical goods purchased received by the receiving means based on the identified conversion coefficient.
[0007] Furthermore, the inventory management device according to the present invention is characterized in that the conversion means identifies the weight conversion coefficient and concentration conversion coefficient that correspond to the item identification information received by the receiving means from among the weight conversion coefficients and concentration conversion coefficients that are pre-registered in the item master for each item identification information, and calculates the weight conversion quantity and concentration conversion quantity from the physical purchase quantity received by the receiving means based on the identified weight conversion coefficient and concentration conversion coefficient.
[0008] Furthermore, the inventory management device according to the present invention is characterized in that the purchase quantity on a weight basis is the quantity obtained by multiplying the purchase quantity of the actual goods by a weight conversion coefficient, and the purchase quantity on a concentration basis is the quantity obtained by multiplying the purchase quantity on a weight basis by a concentration conversion coefficient.
[0009] Furthermore, the inventory management device according to the present invention is characterized in that the receiving means is a purchase input screen for receiving a combination of item identification information and the quantity of physical goods purchased along with the purchase unit price or purchase amount, and when the combination of item identification information and the quantity of physical goods purchased is entered on the screen, the device outputs a purchase input screen in which the purchase quantity calculated by weight and the purchase quantity calculated by concentration, calculated by the conversion means, are displayed on the screen.
[0010] Furthermore, the inventory management device according to the present invention is characterized in that the control unit further comprises an evaluation means that calculates a concentration-converted evaluation unit price for each item identification information, which is the unit price obtained by dividing the purchase amount based on the purchase unit price received by the receiving means or the inventory amount including the purchase amount received by the receiving means by the concentration-converted inventory quantity including the concentration-converted purchase quantity calculated by the conversion means.
[0011] Furthermore, the inventory management device according to the present invention is characterized in that the control unit, for each combination received by the receiving means, distinguishes the item identification information and registers the purchase amount based on the purchase unit price received by the receiving means or the purchase amount received by the receiving means and the purchase quantity calculated by the conversion means as the incoming amount and the incoming quantity calculated by the concentration, respectively, in the receipt and payment data in which the incoming and outgoing amounts and the incoming and outgoing quantities in concentration are registered, and the evaluation means calculates a concentration-converted evaluation unit price for each item identification information, which is the unit price obtained by dividing the inventory amount based on the incoming and outgoing amounts registered in the receipt and payment data by the concentration-converted inventory quantity based on the incoming and outgoing quantities registered in the receipt and payment data.
[0012] Furthermore, the inventory management device according to the present invention is characterized in that, at the end of each month, the evaluation means calculates a unit price for end-of-month inventory valuation, which is obtained by dividing the current month balance amount, which is the inventory amount at the end of the month based on the amount of goods received and issued registered in the receipt and payment data, by the current month balance quantity, which is the inventory quantity at the end of the month based on the quantity of goods received and issued in concentration-converted registered in the receipt and payment data, for each item identification information.
[0013] Furthermore, the inventory management method according to the present invention is an inventory management method performed in an inventory management device equipped with a control unit, and is characterized by including: a reception step performed by the control unit to receive a combination of item identification information and the quantity of physical goods purchased, along with the purchase price or the purchase amount which is the purchase price multiplied by the quantity of physical goods purchased; and a conversion step which identifies a conversion coefficient corresponding to the item identification information received in the reception step from among the conversion coefficients pre-registered in the item master for each item identification information, and calculates the quantity of purchase in concentration conversion from the quantity of physical goods purchased received in the reception step based on the identified conversion coefficient.
[0014] Furthermore, the inventory management program according to the present invention is an inventory management program to be executed by an inventory management device equipped with a control unit, and is characterized by including: a reception step to be executed by the control unit, which receives a combination of item identification information and the quantity of physical goods purchased, along with the purchase price or the purchase amount which is the purchase price multiplied by the quantity of physical goods purchased; and a conversion step which identifies a conversion coefficient corresponding to the item identification information received in the reception step from among the conversion coefficients that have been registered in advance in the item master for each item identification information, and calculates the quantity of purchase in concentration from the quantity of physical goods purchased received in the reception step based on the identified conversion coefficient. [Effects of the Invention]
[0015] According to the system of the present invention, regardless of the form of the product, such as whether it is a solid or liquid product or its concentration, material costs can be easily and accurately evaluated based on the weight of the raw materials used, directly from the quantity of physical goods traded, and the allocation of material costs can be appropriately performed, thereby achieving more precise cost accounting. [Brief explanation of the drawing]
[0016] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of PC100 in one embodiment. [Figure 2] Figure 2 shows an example of an item master in one embodiment. [Figure 3]FIG. 3 is a diagram showing an example of a purchase input screen in one embodiment. [Figure 4] FIG. 4 is a diagram showing an example of payment data in one embodiment. [Figure 5] FIG. 6 is a diagram showing an example of a purchase input screen in one embodiment. [Figure 6] FIG. 9 is a diagram showing an example of payment data in one embodiment. [Figure 7] FIG. 7 is a diagram showing an example of a summary table and an evaluation unit price table in one embodiment.
Mode for Carrying Out the Invention
[0017] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to these embodiments.
[0018] [1. Configuration] Here, an example of the configuration of a PC (Personal Computer) 100 according to this embodiment including an 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 by the configuration of this embodiment. Also, in the following description regarding the configuration, duplicate descriptions may be omitted.
[0019] FIG. 1 is a block diagram showing an example of the configuration of PC 100. PC 100 includes a control unit 102, a communication interface unit 10, a storage unit 106, and an input / output interface unit 108, and is communicably connected to a server 200 (for example, a Web server or the like) that stores various data (for example, each of the data described later that are stored in the storage unit 106) via a network 300 (for example, the Internet, an intranet, a LAN (Local Area Network), or the like).
[0020] Each unit included in PC 100 is communicably connected via an arbitrary communication path.
[0021] The PC100 may be a stationary device such as a desktop personal computer, or it may be a portable device such as a notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.
[0022] The control unit 102 is a CPU or similar component that comprehensively controls the PC 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0023] Functionally, the control unit 102 includes a reception unit 102a, a conversion unit 102b, a registration unit 102c, an evaluation unit 102d, and the like.
[0024] The reception unit 102a accepts the purchase price or purchase amount along with a combination of item identification information and the quantity of the actual goods purchased. The purchase amount is the purchase price multiplied by the quantity of the actual goods purchased.
[0025] The quantity of goods purchased does not necessarily refer only to the quantity based on the amount of raw materials, but also includes the quantity based on the sales unit of the product, and can vary from item to item in terms of lot size, number of containers, number of bags, number of pieces, mass number, volume number, etc. The purchase unit price is the purchase unit price corresponding to the quantity of goods purchased. Item identification information is information that can identify an item, and can take 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 the quantity of physical goods purchased, along with the purchase unit price or purchase amount. The purchase input screen output by the reception unit 102a is a purchase input screen that, once the combination of item identification information and the quantity of physical goods purchased is entered on the screen, displays the concentration-converted purchase quantity (in particular, the weight-converted purchase quantity and the concentration-converted purchase quantity) calculated by the conversion unit 102b described below.
[0027] The reception unit 102a accepts the combination of purchase unit price or purchase amount, item identification information, and physical purchase quantity, which has been entered on the purchase input screen and confirmed as necessary after input.
[0028] The conversion unit 102b identifies the conversion coefficient that corresponds to the item identification information received by the receiving unit 102a from among the conversion coefficients that have been pre-registered in the item master for each item identification information, and calculates the purchase quantity in concentration conversion from the purchase quantity of the physical goods received by the receiving unit 102a based on the identified conversion coefficient.
[0029] This configuration allows for easy, balanced, and accurate evaluation of material costs based on the weight of raw materials used, directly from the quantity of physical goods traded, regardless of whether they are solid or liquid products, or their concentration. This enables proper allocation of material costs and leads to more precise cost accounting.
[0030] The conversion unit 102b identifies the weight conversion coefficient and concentration conversion coefficient that correspond to the item identification information received by the receiving unit 102a from among the weight conversion coefficients and concentration conversion coefficients that have been pre-registered in the item master for each item identification information, and calculates the weight conversion quantity and concentration conversion quantity from the physical purchase quantity received by the receiving unit 102a based on the identified weight conversion coefficient and concentration conversion coefficient.
[0031] This configuration allows for a balanced evaluation of material costs based on quantity, even for products sold in a way that is not weight-based.
[0032] The item master allows for the modification, updating, addition, or deletion of the conversion factors (i.e., weight conversion factors, concentration conversion factors) registered therein, for each item identification information, at any time. The conversion unit 102b calculates the purchase quantity in concentration conversion (and purchase quantity in weight conversion) based on the latest conversion factors in the item master.
[0033] The purchase quantity based on weight is the quantity purchased in physical form multiplied by the weight conversion factor. The purchase quantity based on concentration is the quantity purchased based on weight multiplied by the concentration conversion factor.
[0034] For each combination received by the receiving unit 102a, the registration unit 102c distinguishes the item identification information and registers the purchase amount based on the purchase unit price received by the receiving unit 102a or the purchase amount received by the receiving unit 102a, and the purchase quantity calculated by the conversion unit 102b in terms of concentration (in particular, the purchase quantity in terms of weight and the purchase quantity in terms of concentration), as the receiving amount and the receiving quantity in terms of concentration (in particular, the receiving quantity in terms of weight and the receiving quantity in terms of concentration), respectively, in the receipt and payment data where the receipt and payment amounts and the receipt quantities in terms of concentration are registered.
[0035] The receipt and payment data includes the accounting year and month indicating the time of receipt and payment, receipt and payment identification information to distinguish between receipts and payments, receipt and payment category, item identification information, quantity of original goods received and paid, quantity received and paid based on concentration (and quantity received and paid based on weight), and the amount of receipt and payment, etc., for each receipt and payment.
[0036] The evaluation unit 102d calculates a concentration-converted evaluation unit price for each item identification information, which is the unit price obtained by dividing the purchase amount based on the purchase unit price received by the reception unit 102a, or the inventory amount including the purchase amount received by the reception unit 102a, by the concentration-converted inventory quantity including the concentration-converted purchase quantity calculated by the conversion unit 102b.
[0037] The evaluation unit 102d aggregates the inventory value and the inventory quantity converted to concentration for each item identification information, and calculates the evaluation unit price converted to concentration based on the aggregated inventory value and inventory quantity converted to concentration. The inventory value and inventory quantity converted to concentration are aggregated by the evaluation unit 102d based on the inflow and outflow amounts and quantities registered in the receipt and outflow data.
[0038] The evaluation unit 102d creates an aggregation table summarizing the total inventory value and the inventory quantity converted to concentration, categorized by item identification information. The evaluation unit 102d also creates an evaluation unit price table summarizing the calculated evaluation unit price converted to concentration, categorized by item identification information.
[0039] The evaluation unit 102d calculates a unit price based on concentration conversion, which is obtained by dividing the inventory value based on the amount of goods received and issued registered in the receipt and disbursement data by the inventory quantity based on the quantity of goods received and issued based on concentration conversion registered in the receipt and disbursement data, for each item identification information.
[0040] At the end of each month, the evaluation unit 102d calculates a unit price for end-of-month inventory valuation based on concentration, which is the current month balance amount, which is the inventory amount at the end of the month based on the amount of goods received and issued registered in the receipt and disbursement data, divided by the current month balance quantity, which is the inventory quantity at the end of the month based on the quantity of goods received and issued in concentration, registered in the receipt and disbursement data.
[0041] The communication interface unit 104 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 also has the function of communicating data with other devices via a communication line.
[0042] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory 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, and optical disks can be used.
[0043] Conceptually, the memory unit 106 includes a master memory unit 106a, a data memory unit 106b, a table memory unit 106c, and so on.
[0044] The master storage unit 106a stores item masters, etc., in which conversion factors, particularly weight conversion factors and concentration conversion factors, are pre-registered for each item identification information. The data storage unit 106b stores receipt and payment data, etc., in which the amount of goods issued and issued and the quantity of goods issued and issued based on concentration conversion are registered. The table storage unit 106c stores summary tables, evaluation unit price tables, etc., created by the evaluation unit 102d.
[0045] The input / output interface unit 108 is connected to an input device 400 and an output device 500. The output device 400 includes display devices such as displays and projectors, sound devices such as speakers, printing devices such as printers, and devices that allow data to be downloaded in data file format. The data file format can be any file format known in this field, such as PDF, CSV, document files, spreadsheet software files, or text files. The input device 500 can include a keyboard, mouse, and microphone, as well as a monitor that works in conjunction with the mouse to provide pointing device functionality.
[0046] [2. Specific Examples] The following explanation, using specific examples, describes the information processing performed by the inventory management device according to the present invention, from receiving the quantity of physical goods purchased to creating the summary table and the valuation unit price table, with reference to Figures 2 to 7.
[0047] Figure 2 shows the item master in this specific example. In this specific example, the item master contains the item code (item identification information), the item name corresponding to the item code, the physical unit, the weight conversion factor, the concentration conversion factor, and the item classification, all registered for each item code.
[0048] (Specific example 1: Sugar A) As a first example, we will explain in detail the information processing flow up to the registration of the receipt and payment data when, in June 2023 (202306), a product with item code "H002" and item name "Sugar A," one of the two items registered in the item master shown in Figure 2, is purchased at a unit price (purchase price) of "15.0" and a physical quantity (physical purchase quantity) of "5."
[0049] Figure 3 shows the purchase input screen in this specific example. The purchase input screen in this specific example has input fields for items (input fields for item code and item name), input fields for physical quantity (input quantity of physical items), input field for unit price (purchase unit price), display field for physical units, display field for weight conversion quantity (purchase quantity converted by weight), display field for concentration conversion quantity (purchase quantity converted by concentration), display field for amount (purchase amount), a "Cancel" button, and a "Confirm" button.
[0050] Figure 4 shows the receipt and payment data in this specific example. The receipt and payment data in this example includes the accounting year and month, receipt and payment number (receipt and payment identification information), line number, receipt and payment category, item category, item code, item name, physical quantity (physical quantity of goods received and issued), weight equivalent quantity (weight equivalent quantity of goods received and issued), concentration equivalent quantity (concentration equivalent quantity of goods received and issued), and receipt and payment amount (amount of goods received and issued), registered for each receipt and payment number.
[0051] First, as shown in Figure 3, the user enters the item code "H002" and the item name "Sugar A" into the item input field on the purchase input screen output by the reception unit 102a. The reception unit 102a receives the entered item code and item name, extracts the physical unit "bag" corresponding to item code "H002" from the item master shown in Figure 2, and displays "bag" in the physical unit display field on the purchase input screen, as shown in Figure 3.
[0052] Furthermore, after the user confirms the "bag" displayed in the physical unit display field, they enter "5" in the physical quantity (physical purchase quantity) input field on the purchase input screen, as shown in Figure 3, which corresponds to the displayed physical unit. The reception unit 102a receives the entered physical quantity (physical purchase quantity), and the conversion unit 102b identifies the weight conversion factor "20.0" and the concentration conversion factor "1.0" corresponding to the item code "H002" from the item master shown in Figure 2.
[0053] The conversion unit 102b multiplies the physical quantity (physical purchase quantity) "5" received by the reception unit 102a by the specified weight conversion coefficient "20.0" to calculate the weight conversion number (weight conversion purchase quantity) "100" (5 × 20.0 = 100). The reception unit 102a then displays "100" in the weight conversion number (weight conversion purchase quantity) display field on the purchase input screen, as shown in Figure 3.
[0054] The conversion unit 102b calculates the concentration conversion number (concentration conversion quantity) "100" by multiplying the calculated weight conversion number (purchase quantity in weight conversion) "100" by the specified concentration conversion coefficient "1.0" (100 × 1.0 = 100), and the reception unit 102a displays "100" in the concentration conversion number (concentration conversion quantity) display field on the purchase input screen, as shown in Figure 3.
[0055] Furthermore, as shown in Figure 3, the user enters "15.0" in the input field for the unit price (purchase price). The reception unit 102a receives the entered unit price (purchase price). The conversion unit 102b multiplies the unit price (purchase price) "15.0" received by the reception unit 102a by the physical quantity (physical purchase quantity) "5" received by the reception unit 102a to calculate the purchase amount (purchase amount) "75" (15.0 × 5 = 75). The reception unit 102a then displays "75" in the display field for the purchase amount (purchase amount) on the purchase input screen, as shown in Figure 3. Finally, the user confirms the entered information by pressing the "Confirm" button on the purchase input screen.
[0056] As shown in Figure 4, the registration unit 102c sets the current month as the accounting year and month "202306", automatically assigns the receipt / payment number "U003" and line number "1", sets the receipt / payment category to "Accounting for completed work (Purchases)", and registers the item code "H002", item name "Sugar A", item category "Product" corresponding to the above item code extracted from the item master shown in Figure 2, the physical quantity received by the reception unit 102a as the physical quantity (physical purchase quantity) "5" bags, the weight equivalent quantity (weight equivalent purchase quantity) "100" kg and the concentration equivalent quantity (concentration equivalent purchase quantity) "100" kg calculated by the conversion unit 102b as the weight equivalent quantity and concentration equivalent quantity (weight equivalent and concentration equivalent receipt / payment quantity), and the amount received / paid (received / paid) as the completed work amount (purchase amount) "75" calculated by the conversion unit 102b as the transaction data.
[0057] (Specific example 2: Liquid sugar A) As a second specific example, we will explain in detail the information processing flow from the registration of the receipt and payment data, to the creation of the summary table and valuation price table based on the data, when, in June 2023 (202306), product "Liquid Sugar A," one of the two items registered in the item master shown in Figure 2, is purchased in the first instance at a unit price (purchase price) of "3.0" and a physical quantity (physical purchase quantity) of "10", in the second instance at a unit price (purchase price) of "4.5" and a physical quantity (physical purchase quantity) of "30", and in the third instance at a unit price (purchase price) of "3.6" and a physical quantity (physical purchase quantity) of "50".
[0058] Figure 5 shows the 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 Figure 3 described above, except for the specific input content and display content.
[0059] Figure 6 shows the receipt and payment data in this specific example. The receipt and payment data in this example has the same structure as the receipt and payment data shown in Figure 4 described above, except for the specific registration details.
[0060] Figure 7 shows the summary table and valuation unit price table in this specific example. The summary table in this example registers the accounting year and month, item code, item name, quantity (inventory quantity converted to concentration), and amount (inventory value) for each item. The valuation unit price table in this example registers the accounting year and month, item code, item name, and valuation unit price converted to concentration for each item.
[0061] First, as shown in Figure 5, the user enters the item code "H001" and the item name "Liquid Sugar A" into the item input field on the purchase input screen output by the reception unit 102a as information for the first purchase. The reception unit 102a receives the entered item code and item name, extracts the physical unit "Kg" corresponding to item code "H001" from the item master shown in Figure 2, and displays "Kg" in the physical unit display field on the purchase input screen, as shown in Figure 5.
[0062] Furthermore, after the user confirms the "Kg" displayed in the physical unit display field, as shown in Figure 5, the user enters "10" in the physical quantity (physical quantity purchased) input field on the purchase input screen as information for the first purchase, corresponding to the displayed physical unit. The reception unit 102a receives the entered physical quantity (physical quantity purchased), and the conversion unit 102b identifies the weight conversion factor "1.0" and the concentration conversion factor "0.3" corresponding to the item code "H001" from the item master shown in Figure 2.
[0063] The conversion unit 102b multiplies the physical quantity (physical purchase quantity) "10" received by the reception unit 102a by the specified weight conversion coefficient "1.0" to calculate the weight conversion number (weight conversion purchase quantity) "10" (10 × 1.0 = 10). The reception unit 102a then displays "10" in the weight conversion number (weight conversion purchase quantity) 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 converted by weight) "10" by the specified concentration conversion coefficient "0.3" to calculate the concentration conversion number (purchase quantity converted by concentration) "3" (10 × 0.3 = 3), and the reception unit 102a displays "3" in the concentration conversion number (purchase quantity converted by concentration) display field on the purchase input screen, as shown in Figure 5.
[0065] Furthermore, as shown in Figure 5, the user enters "3.0" in the input field for the unit price (purchase price) as information for the first purchase. The reception unit 102a receives the entered unit price (purchase price). The conversion unit 102b multiplies the unit price (purchase price) "3.0" received by the reception unit 102a by the physical quantity (physical purchase quantity) "10" received by the reception unit 102a to calculate the purchase amount (purchase amount) "30" (3.0 × 10 = 30). The reception unit 102a then displays "30" in the display field for the purchase amount (purchase amount) on the purchase input screen, as shown in Figure 5. Finally, the user confirms the entered information by pressing the "Confirm" button on the purchase input screen.
[0066] The registration unit 102c, as the information for the first purchase, sets the current month as the accounting year and month "202306" as shown in Figure 6, automatically assigns the receipt / disbursement number "U004" and line number "1", sets the receipt / disbursement category to "Accounting for completed work (Purchases)", and then receives the item code "H001", item name "Liquid Sugar A", the item category "Product" corresponding to the above item code extracted from the item master shown in Figure 2, and the quantity of physical goods received and issued as the receipt unit The following are registered in the receipt and payment data: the physical quantity received by 102a (physical purchase quantity) of "10" kg, the weight equivalent quantity (purchase quantity in weight equivalent) of "10" kg and the concentration equivalent quantity (purchase quantity in concentration equivalent) of "3" kg calculated by the conversion unit 102b as weight equivalent and concentration equivalent quantities (inbound and outbound quantities in weight equivalent and concentration equivalent quantities), and the output amount (purchase amount) of ¥30 calculated by the conversion unit 102b as receipt and payment amount (inbound and outbound amount).
[0067] Furthermore, the user enters the following information for the second purchase, similar to the information for the first purchase, into the purchase input screen: item code "H001", item name "Liquid Sugar A", physical quantity (physical quantity purchased) "30", and unit price (purchase unit price) "4.5". The reception unit 102a then accepts the entered information.
[0068] The conversion unit 102b calculates the weight conversion number (purchase quantity converted by weight) "30" (30 × 1.0 = 30), the concentration conversion number (purchase quantity converted by concentration) "9" (30 × 0.3 = 9), and the output amount (purchase amount) "135" (4.5 × 30 = 135) for the information of the second purchase, just as it does for the information of the first purchase.
[0069] The registration unit 102c registers the following information as the second purchase, similar to the information for the first purchase, in the receipt and payment data, as shown in Figure 6: Accounting year and month "202306", receipt and payment number "U005", line number "1", receipt and payment category "Performance Recording (Purchase)", item category "Product", item code "H001", item name "Liquid Sugar A", physical quantity received and issued as physical quantity (physical purchase quantity) "30" kg, weight equivalent quantity (weight equivalent quantity received and issued) as weight equivalent quantity (weight equivalent purchase quantity) "30" kg, concentration equivalent quantity (concentration equivalent quantity received and issued) as concentration equivalent quantity (concentration equivalent purchase quantity) "9" kg, and receipt and payment amount (received and issued amount) as performance amount (purchase amount) "135".
[0070] Furthermore, the user enters the following information for the third purchase, similar to the information for the first purchase, into the purchase input screen: item code "H001", item name "Liquid Sugar A", physical quantity (physical quantity purchased) "50", and unit price (purchase unit price) "3.6". The reception unit 102a then accepts the entered information.
[0071] The conversion unit 102b calculates the weight conversion number (purchase quantity converted by weight) "50" (50 × 1.0 = 50), the concentration conversion number (purchase quantity converted by concentration) "15" (50 × 0.3 = 15), and the output amount (purchase amount) "180" (3.6 × 50 = 180) for the information of the third purchase, just as it does for the information of the first purchase.
[0072] The registration unit 102c registers the following information as the third purchase, similar to the information for the first purchase, in the receipt and payment data, as shown in Figure 6: Accounting year and month "202306", receipt and payment number "U006", line number "1", receipt and payment category "Performance Recording (Purchase)", item category "Product", item code "H001", item name "Liquid Sugar A", physical quantity received and issued as physical quantity (physical purchase quantity) "50" kg, weight equivalent quantity (weight equivalent quantity received and issued) as weight equivalent quantity (weight equivalent purchase quantity) "50" kg, concentration equivalent quantity (concentration equivalent quantity received and issued) as concentration equivalent quantity (concentration equivalent purchase quantity) "15" kg, and receipt and payment amount (received and issued amount) as performance amount (purchase amount) "180".
[0073] The evaluation unit 102d calculates the inventory value (i.e., the balance for the current month) and the inventory quantity converted to concentration (i.e., the balance for the current month) for the item with item code "H001" as of the end of June 2023, based on the receipt and payment amounts (receiving and issuing amounts) and the receiving and issuing quantities converted to concentration registered in the receipt and payment data.
[0074] As of the end of June 2023, the receipt and payment data includes receipt and payment amounts (amounts for goods received and issued) and quantities for goods received and issued in terms of concentration, as shown in Figure 6, for receipt and payment numbers "U004" to "U006". Since all receipt and payment information for receipt and payment numbers "U004" to "U006" is based on the receipt and payment category "Accounting for completed work (purchases)", the sum of the receipt and payment amounts (amounts for goods received and issued) directly becomes the inventory amount "345" (30 + 135 + 180 = 345), and the sum of the quantities for goods received and issued in terms of concentration directly becomes the inventory quantity for concentration "27" (3 + 9 + 15 = 27).
[0075] Therefore, the evaluation unit 102d calculates "345" as the inventory value and "27" as the inventory quantity converted to concentration, based on the aggregation of receipt and payment data.
[0076] As shown in Figure 7, the evaluation unit 102d creates an aggregation table that summarizes the calculated inventory value "345" and the inventory quantity converted to concentration "27" as an amount and quantity, along with the accounting year and month "202306", item code "H001", and item name "Liquid Sugar A".
[0077] The valuation unit 102d calculates the unit price for valuation on a concentration basis (i.e., the unit price for valuation of end-of-month inventory) by dividing the calculated inventory value "345" by the calculated inventory quantity on a concentration basis "27" (345 / 27 = 12.78).
[0078] As shown in Figure 7, the evaluation unit 102d creates an evaluation unit price table that summarizes the calculated evaluation unit price based on concentration, along with the accounting year and month "202306", item code "H001", and item name "Liquid Sugar A".
[0079] As explained above, the system of the present invention allows for the easy, balanced, and accurate evaluation of material costs based on the weight of the raw materials used, directly from the quantity of physical goods traded, regardless of the form of the product, such as whether it is a solid or liquid product or its concentration. This enables the appropriate allocation of material costs and achieves more precise cost accounting.
[0080] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.
[0081] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0082] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0083] [4. Other Embodiments] Although embodiments of the present invention have been described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the embodiments described above.
[0084] For example, among the processes described in the embodiments described above, 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 by known methods.
[0085] In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in the above-mentioned documents and drawings may be changed at will unless otherwise specified.
[0086] Furthermore, with respect to PC100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.
[0087] For example, the processing functions of each device constituting the PC100, particularly those performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by each device as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.
[0088] Furthermore, this computer program may be stored on an application program server connected to the PC100 via any network, and it is possible to download all or part of it as needed.
[0089] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program-first product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.
[0090] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.
[0091] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.
[0092] Furthermore, PC100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, PC100 may be realized by implementing software (including programs or data, etc.) on PC100 to perform the processing described in this embodiment.
[0093] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]
[0094] This invention is useful for inventory management in manufacturing industries, for example, when raw materials such as sugar are dissolved in water to produce liquid secondary processed products. [Explanation of Symbols]
[0095] 100 PC 102 Control Unit 102a Reception Desk 102b Conversion section 102c Registration Section 102d Evaluation Department 104 Communication Interface Section 106 Storage section 106a Master Storage Unit 106b Data storage unit 106c Table Storage Unit 108 Input / Output Interface Section 200 servers 300 Networks 400 Input Devices 500 Output Device
Claims
1. An inventory management device comprising a control unit, The control unit, A receiving means that accepts a combination of item identification information and the quantity of physical goods purchased, along with the purchase price, which is the purchase price multiplied by the purchase price. The system includes a conversion means that identifies a conversion factor corresponding to the item identification information received by the receiving means from among the conversion factors pre-registered in the item master for each item identification information, and calculates the quantity of purchase in concentration from the quantity of physical goods purchased by the receiving means based on the identified conversion factor. An inventory management device characterized by the following features.
2. The aforementioned conversion means The receiving means identifies the weight conversion coefficient and concentration conversion coefficient that correspond to the item identification information received from the weight conversion coefficient and concentration conversion coefficient that have been pre-registered in the item master for each item identification information, and calculates the weight conversion quantity and concentration conversion quantity from the physical purchase quantity received by the receiving means based on the identified weight conversion coefficient and concentration conversion coefficient. The inventory management device according to feature 1.
3. The purchase quantity based on weight is the quantity obtained by multiplying the physical purchase quantity by the weight conversion factor, and the purchase quantity based on concentration is the quantity obtained by multiplying the purchase quantity based on weight by the concentration conversion factor. The inventory management device according to feature 2.
4. The aforementioned receiving means A purchase input screen that accepts a combination of purchase unit price or purchase amount, item identification information, and the quantity of physical goods purchased. When the combination of item identification information and the quantity of physical goods purchased is entered on the screen, the system outputs a purchase input screen that displays the purchase quantity calculated by weight and the purchase quantity calculated by concentration, as calculated by the conversion means. The inventory management device according to feature 2.
5. The control unit, The system further includes an evaluation means for calculating a concentration-converted evaluation unit price, which is obtained by dividing the purchase amount based on the purchase unit price received by the receiving means, or the inventory amount including the purchase amount received by the receiving means, by the concentration-converted inventory quantity including the concentration-converted purchase quantity calculated by the conversion means, for each item identification information. The inventory management device according to feature 1.
6. The control unit, For each combination received by the receiving means, the receiving means further includes a registration means that, distinguishing the item identification information, registers the amount of goods received and the quantity of goods received and the quantity of goods received in conversion to concentration in the receipt and payment data, and registers the purchase amount based on the purchase unit price received by the receiving means or the purchase amount received by the receiving means and the quantity of goods received in conversion to concentration calculated by the conversion means, respectively, as the amount of goods received and the quantity of goods received in conversion to concentration. The evaluation means, For each item identification information, the unit price calculated is the concentration-converted valuation unit price, which is obtained by dividing the inventory value based on the amount of goods received and issued registered in the receipt and disbursement data by the concentration-converted inventory quantity based on the concentration-converted quantity of goods received and issued registered in the receipt and disbursement data. The inventory management device according to feature 5.
7. The evaluation means, At the end of each month, for each item identification information, the unit price for the end-of-month inventory valuation is calculated by dividing the current month's balance amount, which is the inventory value at the end of the month based on the amount of goods received and issued registered in the receipt and disbursement data, by the current month's balance quantity, which is the inventory quantity at the end of the month based on the concentration-converted quantity of goods received and issued registered in the receipt and disbursement data. The inventory management device according to feature 6.
8. An inventory management method performed in an inventory management device equipped with a control unit, The control unit executes the following: A reception step that accepts a combination of item identification information and the quantity of physical goods purchased, along with the purchase price (either the purchase price multiplied by the purchase price) and the purchase amount (the purchase price multiplied by the quantity of physical goods purchased). The conversion step includes: identifying a conversion factor from among the conversion factors pre-registered in the item master for each item identification information that corresponds to the item identification information received in the acceptance step, and calculating the quantity of purchase in concentration from the quantity of physical goods received in the acceptance step based on the identified conversion factor. An inventory management method characterized by the following features.
9. An inventory management program to be executed by an inventory management device equipped with a control unit, To be performed by the control unit, A reception step that accepts a combination of item identification information and the quantity of physical goods purchased, along with the purchase price (either the purchase price multiplied by the purchase price) and the purchase amount (the purchase price multiplied by the quantity of physical goods purchased). The conversion step includes: identifying a conversion factor from among the conversion factors pre-registered in the item master for each item identification information that corresponds to the item identification information received in the acceptance step, and calculating the quantity of purchase in concentration from the quantity of physical goods received in the acceptance step based on the identified conversion factor. An inventory management program characterized by the following features.