JP7361162B2 - Unit price calculation device, unit price calculation method, and unit price calculation program - Google Patents

Description

The present invention relates to a unit price calculation device, a unit price calculation method, and a unit price calculation program.

Patent Document 1 describes adding to warehousing history information and updating cost management information based on warehousing information, updating warehousing history information, adding to warehousing history information, and updating cost management information based on outgoing information, Calculate the average cost and calculate the cost from the reserved amount of goods received. Based on this information, calculate the asset value using multiple evaluation methods of the asset value, sort it, and display the list to find a more advantageous cost. An invention aimed at presenting a method for calculating and evaluating an asset amount has been disclosed (see paragraph 0006, etc.).

Japanese Patent Application Publication No. 07-262282

In the field of calculating asset amounts, the aggregation unit for logistics management and the aggregation unit for asset management are often different. For example, in the case of T-shirts, in logistics management, an aggregation unit called size unit is used to calculate the inventory value of 16,000 yen for 15 small size shirts, 9,000 yen for 8 medium size shirts, 9,000 yen for 8 medium size shirts, and 5 large size shirts. In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, we use the aggregation unit of product type or product number to calculate the inventory value of 30,000 yen for 28 pieces of all sizes, so the unit price per piece is 1,071 yen. It is often calculated and managed in a similar manner.

In this way, calculating the unit price of 1,071 yen for asset management based on inventory information for logistics management has traditionally been done manually by accounting personnel, which requires a great deal of time and effort. was.

The present invention has been made in view of the above, and includes a unit price calculation device and a unit price that can calculate a product unit price for each product type or product number, which is an aggregation unit for asset management, based on inventory information in logistics management. Provide calculation methods and unit price calculation programs.

In order to solve the above-mentioned problems and achieve the purpose, a unit price calculation device according to the present invention is a unit price calculation device that includes a control section and a storage section, and the storage section stores a product master including product identification data. and a group master that includes group identification data for identifying an aggregation unit for asset management and is linked to the product master, and the group identification data is used to identify products identified by the product identification data. This is data that specifies whether to aggregate the amount or inventory amount of a product by product type or by product number, and the control unit is configured to collect information about the product identification data and the product specified by the product identification data. Based on the inventory data and detail data including the amount and inventory amount, the amount included in the inventory data and the detail data linked to the product identification data included in the product master is specified by the group identification data. An amount aggregation means that aggregates in aggregation units, and based on the inventory data and the detailed data, the inventory amount included in the inventory data and the detailed data, which are linked to the product identification data included in the product master, is aggregated in the group. Inventory amount aggregation means aggregates in aggregation units specified by identification data, and according to a predetermined unit price calculation method, divides the aggregated amount by the aggregated inventory amount to calculate the product unit price for each product type or product number. A unit price calculation means for calculating the unit price.

Further, the unit price calculation device according to the present invention is characterized in that the predetermined unit price calculation method is a total average method.

Further, the unit price calculation method according to the present invention is a unit price calculation method executed by an information processing device including a control unit and a storage unit, and the storage unit includes a product master including product identification data and a product master for asset management. A group master that includes group identification data for specifying the aggregation unit of the item and is linked to the product master is stored, and the group identification data includes the amount or inventory of the product specified by the product identification data. This is data that specifies whether the quantity is to be aggregated by product type or product number, and is executed by the control unit to determine the product identification data and the amount of money for the product specified by the product identification data. and the amount included in the inventory data and the detailed data, which are linked to the product identification data included in the product master, based on the inventory data including the inventory amount and detailed data, in an aggregation unit specified by the group identification data. and an amount aggregation step of aggregating the amount of stock included in the inventory data and the detailed data, which are linked to the product identification data included in the product master, based on the inventory data and the detailed data, based on the group identification data. an inventory amount aggregation step of aggregating in an aggregation unit specified by , and calculating a product unit price for each product type or product number by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method. The method is characterized by including a step of calculating a unit price.

Further, the unit price calculation program according to the present invention is a unit price calculation program to be executed by an information processing device including a control unit and a storage unit, and the storage unit includes a product master including product identification data and an asset management A group master that includes group identification data for specifying the above aggregation unit and is linked to the product master is stored, and the group identification data includes the amount or amount of the product specified by the product identification data. This is data that specifies whether the inventory amount is to be aggregated by product type or product number, and is for the product identification data and the product specified by the product identification data to be executed by the control unit. Based on the inventory data and detail data including the amount and inventory amount, the amount included in the inventory data and the detail data linked to the product identification data included in the product master is specified by the group identification data. an amount aggregation step of aggregating in an aggregation unit; and based on the inventory data and the detailed data, the inventory amount included in the inventory data and the detailed data that is linked to the product identification data included in the product master is calculated in the group. Inventory amount aggregation step of aggregating in aggregation units specified by identification data, and dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method to calculate the product unit price for each product type or product number. The method is characterized by including a step of calculating a unit price.

According to the present invention, it is possible to calculate the product unit price in units of product types or product numbers, which are aggregation units in asset management, based on inventory information in logistics management.

FIG. 1 is a block diagram showing an example of the configuration of a unit price calculation device. FIG. 2 is a diagram illustrating an example of a hierarchy of aggregation units. FIG. 3 is a diagram illustrating an example of a hierarchy of aggregation units in apparel products. FIG. 4 is a diagram showing an example of a hierarchy of aggregation units in steel materials. FIG. 5 is a diagram showing an example of a product type master, a product number master, and a product master. FIG. 6 is a diagram showing an example of how to calculate the product unit price. FIG. 7 is a diagram illustrating an example of how to calculate the product unit price for each product. FIG. 8 is a diagram illustrating an example of how to calculate a product unit price in units of product numbers. FIG. 9 is a diagram illustrating an example of how to calculate a product unit price in units of product numbers.

DESCRIPTION OF EMBODIMENTS Below, embodiments of a unit price calculation device, a unit price calculation method, and a unit price calculation program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
In the apparel retail industry, steel wholesale industry, etc., the aggregation unit for logistics management and the aggregation unit for asset management are often different. For example, in the case of T-shirts, in logistics management, we use aggregation units called size units, and as shown in Figures 6 and 7, ``For S size product AA-1, the balance as of September 1st is Number of 10 pieces + 5 pieces purchased on September 10th = 15 pieces, inventory amount 16,000 yen, For M size product AA-2, remaining quantity as of September 1st + 3 pieces on September 10th 5 pieces purchased = 8 pieces, inventory amount 9,000 yen, for L size product AA-2, 5 pieces remaining as of September 1st + 0 pieces purchased on September 10th = 5 pieces In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, we use aggregation units such as product types or product numbers, as shown in the lower right frame of Figure 6. The unit price per sheet is often calculated as 1,071 yen for management.

In this case, the accounting side needed to link inventory unit price information for logistics management using a system or Excel, calculate the inventory unit price for asset management, and receive the results from the accounting side. . Or, the units for logistics management were aligned with the units for asset management. However, in the former case, there will be a need to customize cooperation with the accounting side and an increase in the workload on the accounting side. Furthermore, in the latter case, since units for logistics management are not used, inventory must be procured and shipped using a summary column, etc., resulting in a significant disconnect between field work and system operation.

In this way, depending on the industry/industry, there is a pattern in which different products are treated as the same asset for accounting purposes. Therefore, in this embodiment, we have developed a system that calculates the inventory evaluation unit price aggregated for each product management hierarchy, and thereby manages the quantity of assets and the amount of inventory in stock.

With the above system, like in the apparel retail industry, apparel items of different sizes and colors within the same model can be managed as separate items in terms of logistics management, but in terms of inventory, they are consolidated into one model and the inventory quantity and unit price can be managed. It is now possible to handle cases where In addition, like in the steel wholesale business, logistics management is performed by dimensions such as thickness, width, and length, and inventory is aggregated by material and shape even if the dimensions are different, and inventory weight and unit price are calculated. It is now possible to handle cases where management of

In addition, with the above mechanism, it is possible to separately capture logistics inventory and accounting inventory (inventory assets) in inventory management on the subsidiary ledger side, and by simply setting the master in advance, accounting inventory can be grasped in near real-time. Now you can. The specific configuration and operation will be described below.

[2. composition]
The configuration of the unit price calculation device 100 according to this embodiment will be explained using FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of a unit price calculation device 100.

Unit price calculation device 100 is a commercially available desktop personal computer. Note that the unit price calculation device 100 is not limited to stationary information processing devices such as desktop personal computers, but is also applicable to portable types such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. It may also be an information processing device.

As shown in FIG. 1, the unit price calculation device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the unit price calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicatively connects the unit price calculation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the unit price calculation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106, which will be described later, may be stored in the server 200.

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In addition, below, the output device 114 may be described as a monitor 114 as a display unit, and the input device 112 may be described as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used.

The storage unit 106 includes a product type master 106a as a group master, a product number master 106b, a product master 106c, inventory data 106d, and detailed data 106e. Among these, the product number master 106b is an arbitrary component, and may or may not be included in the storage unit 106. The items included in each master and each data will be explained below.

In the following description, the notation in parentheses after each item is a specific example of each item. For example, when it is written as product identification data (product name or product code), it means that the product name or product code is a specific example of product identification data, and the figure shows this specific example. .

As shown in FIG. 5, the product type master 106a includes an inventory evaluation aggregation category for specifying an aggregation unit for asset management, and is directly or indirectly linked to the product master.

The aggregation unit is one of the product type, product number, and product units, and as shown in Figure 2, the product type is the upper layer, the product number is the middle layer, and the product is the lower layer. be. For example, if the product is an apparel product, as shown in Figure 3, the product category means a higher hierarchy of "T-shirts" and "wallets," and furthermore, if the product product is "T-shirts," The product number unit means the middle level of "Manufacturer A 2016 Winter Model" and "Manufacturer B 2016 Winter Model". Furthermore, if the product number unit is "Manufacturer A 2016 Winter Model", the product unit means "Manufacturer A 2016 Winter Model". 2016 Winter Model BL LL" and "Manufacturer A 2016 Winter Model RD S". For example, when the product is steel, as shown in Figure 4, the product type unit means a higher hierarchy of "H-beam steel," "steel sheet pile," and "standard length deformed steel," and If it is "H-beam steel", the product unit means the lower hierarchy of "H200x200", "H250x250", "H300x300" (in addition, if the product is steel material, the product number unit does not exist) ).

The inventory evaluation aggregation category is data that specifies whether the amount or inventory amount of the product specified by the product identification data included in the product master 106c is to be aggregated by type, product number, or product. be. The data specifying the product type unit and the data specifying the product number unit can be collectively referred to as group identification data. The unit of aggregation in which product amounts or inventory amounts are aggregated varies depending on the type of industry and product type. The amount or inventory amount of the product is aggregated in the hatched aggregation unit marked with "I want to recognize in this unit." For example, if the product is a T-shirt, as shown in FIG. 3, the aggregation will be performed in the middle hierarchy (that is, by product number) such as "Manufacturer A 2016 Winter Model" and "Manufacturer B 2016 Winter Model."

The product master 106a may further include, for example, product identification data (product code), inventory management unit code, and the like. The inventory management unit code is data that specifies the unit in which the inventory amount of the product specified by the product identification data included in the product master 106c is aggregated. For example, when the product is an apparel product, the unit may be "piece", "piece", etc., indicating the number of products. In addition, if the product is steel, the units are expressed as "kg (kilogram)", "t (ton)", etc., which represent weight, and by unifying them with a common weight, which is a common index for asset management, It becomes possible to centralize cost management for steel products of the same type but with different shapes.

The product number master 106b includes, for example, product number identification data (product number code), and serves to indirectly link the product type master 106a and the product master 106c, as shown in FIG. As described above, the product number master 106b is an arbitrary component, and if the product number master 106b does not exist, the product type master 106a and the product master 106c are directly linked.

The product master 106c includes product identification data (product name or product code), and is directly or indirectly linked to the product type master 106a, as shown in FIG.

The inventory data 106d is data for managing inventory information about products, and as shown in FIG. In FIG. 9, the amount of money for the previous month) and inventory amount (remaining quantity for the previous month in FIG. 9) are included. Note that the inventory amount is the inventory quantity when the product is an apparel product as in the example of FIG. 9, but is not limited to this. For example, if the product is steel material, the inventory weight It may be.

The detailed data 106e is data for managing detailed information about products, and as shown in FIG. In FIG. 9, the amount) and inventory amount (in FIG. 9, quantity) are included. Note that, similar to the explanation in the previous paragraph, the inventory amount is not limited to the inventory quantity, and may be, for example, the inventory weight.

The control unit 102 is a CPU or the like that controls the unit price calculation device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

Functionally and conceptually, the control unit 102 (1) identifies products included in the product master based on product identification data and inventory data and detailed data including the price and inventory amount of the product specified by the product identification data; (2) an amount aggregation unit 102a as an amount aggregation means for aggregating amounts included in the inventory data and the detailed data linked to the identification data in an aggregation unit specified by the group identification data; Inventory amount aggregation that aggregates the inventory data and the inventory amount included in the detailed data, which are linked to the product identification data included in the product master, based on the detailed data, in an aggregation unit specified by the group identification data. (3) unit price calculation for calculating the product unit price for each product type or product number by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method; A unit price calculation unit 102c as a means is provided. For details of the processing executed by each part, see [3. Specific example of processing].

[3. Specific example of processing]
A specific example of the processing according to this embodiment will be described below, mainly using FIG. 9. In this item, three products belonging to the same product number AA, product AA-1, product AA-2, and product AA-3, are included in the product master 106c, and the predetermined unit price calculation method is used for these three products. According to the above, we assume that the unit price of a product is calculated by product number. Note that there are many predetermined unit price calculation methods, and there are no particular limitations, but in this item, a case will be explained in which the total average method, which is employed by many companies, is used.

The calculation formula for the grand average method is as follows. Product unit price = (Amount of inventory carried forward for the current period + Acquisition price of assets incurred in the current period) / (Number of assets in stock carried forward for the current period + Number of assets acquired in the current period). Hereinafter, the numerator of the above calculation formula will be explained first, then the denominator will be explained, and finally the numerator/denominator will be explained.

[3-1. Regarding the calculation of the numerator (inventory amount carried forward for the current period + acquisition cost of assets incurred in the current period)]
Based on the inventory data 106d and detailed data 106e, the amount aggregation unit 102a identifies the amounts included in the inventory data 106d and detailed data 106e, which are linked to the product identification data included in the product master 106c, based on the group identification data. Aggregate by aggregation unit (product number unit).

First, the calculation of the current period carryover inventory amount will be explained in detail. The carryover inventory amount for the current period can be calculated by referring to the inventory data 106d in FIG. 9. When referring to the inventory data 106d, the amounts associated with the product identification data product AA-1, product AA-2, and product AA-3 included in the product master 106c are the previous month's amounts of 10,000 yen and 3,000 yen, respectively. , 5,000 yen. The amount aggregation unit 102a aggregates these amounts and calculates the carryover inventory amount for the current period for product number AA as 10,000 yen + 3,000 yen + 5,000 yen = 18,000 yen.

Note that the calculated carryover inventory amount for the current period of 18,000 yen for product number AA may be temporarily saved as the asset inventory data in FIG. 8. FIG. 8 is an example in which the asset inventory data ignores the distribution unit and aggregates by asset, and adopts evaluation by product number. Add asset information to the logistics purchasing data to the cost detail data by referring to the inventory evaluation summary classification of the product type master. In this system, the area of asset type is used for evaluation by type, and the area of asset product is used for evaluation by product. Separate from logistics management, data is aggregated using assigned asset management units and evaluations are calculated using appropriate units.

Next, we will specifically explain the calculation of the asset acquisition cost incurred in the current period. The asset acquisition price incurred in the current period can be calculated by referring to the detailed data 106e in FIG. 9. Referring to the detailed data 106e, the amounts associated with the product identification data product AA-1, product AA-2, and product AA-3 included in the product master 106c are 6,000 yen, which is the price of product AA-1, and product AA. -2 amount is 6,000 yen. The amount aggregation unit 102a aggregates these amounts and calculates the asset acquisition price for the current period for product number AA as 6,000 yen + 6,000 yen = 12,000 yen.

By adding the above aggregated amounts, the amount aggregation unit 102a calculates (current period carryover inventory amount + current period acquired asset acquisition price) = 18,000 yen + 12,000 yen = 30,000 yen for product number AA.

[3-2. Regarding the calculation of the denominator (number of assets in stock carried forward for the current period + number of assets acquired during the current period)]
Based on the inventory data 106d and detailed data 106e, the inventory amount aggregation unit 102b identifies the inventory amount included in the inventory data 106d and detailed data 106e, which is linked to the product identification data included in the product master 106c, using group identification data. Consolidate by aggregation unit (product number unit).

First, the calculation of the number of assets in stock carried forward for the current period will be explained in detail. The inventory number of assets carried forward for the current period can be calculated by referring to the inventory data 106d in FIG. 9. When referring to the inventory data 106d, the inventory amounts associated with the product identification data product AA-1, product AA-2, and product AA-3 included in the product master 106c are 10, 3, and 5, respectively, which are the remaining quantities of the previous month. It is one piece. The inventory amount aggregation unit 102b aggregates these inventory amounts and calculates the current period carryover asset inventory number for the product number AA as 10 pieces + 3 pieces + 5 pieces = 18 pieces. Note that the calculated number of 18 assets in stock for the current period for product number AA may be temporarily saved as the asset inventory data in FIG. 8.

Next, we will specifically explain the calculation of the number of assets acquired during the current period. The number of assets acquired during the current period can be calculated by referring to the detailed data 106e in FIG. When referring to the detailed data 106e, the inventory amount associated with the product identification data product AA-1, product AA-2, and product AA-3 included in the product master 106c is 5 pieces, which is the quantity of product AA-1, and product AA- The quantity is 2, which is 5 pieces. The inventory amount aggregation unit 102b aggregates these inventory amounts and calculates the number of assets acquired in the current period for product number AA as 5+5=10.

By adding up the inventory amounts aggregated above, the inventory amount aggregation unit 102b calculates (number of assets in stock carried over from the current period + number of assets acquired during the current period) = 18 sheets + 10 sheets = 28 sheets for the product number AA.

[3-3. Regarding calculation of numerator/denominator]
The unit price calculation unit 102c divides the aggregated amount (30,000 yen) by the aggregated inventory amount (28 pieces) to calculate the unit price of the product in product number units (product number AA) as 30,000 yen/28. Calculated as 1,071.43 yen (rounded to the second decimal place).

Note that, as shown in the monthly inventory data (for the current month) in FIG. 9, the current month amount can be calculated by the current month's remaining quantity x the current month's unit price. Therefore, the monthly amount will be 16,071 yen for product AA-1, 8,571 yen for product AA-2, and 5,357 yen for product AA-3. It will cost 29,999 yen. Therefore, the above [3-1. ] In order to match it with the 30,000 yen on the asset inventory calculated in the item, add 1 yen to the maximum amount for the month, 16,071 yen, and adjust it to 16,072 yen. In this way, the amount on the logistics data can be updated based on the evaluation unit price and asset amount determined from the asset inventory.

In this way, according to the unit price calculation device 100 according to the present embodiment, it is possible to calculate the product unit price in units of product types or product numbers, which are aggregation units in asset management, based on inventory information in logistics management. For this reason, for example, if the aggregation unit for logistics management (size, color, etc.) is different from the aggregation unit for asset management (product type or product number), traditionally, the accounting department etc. Product unit prices used to be calculated manually, but this is no longer necessary, and it is now possible to quickly refer to product unit prices by product type or product number in real time.

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

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

In addition, unless otherwise specified, information including processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings are included. It can be changed arbitrarily.

Further, regarding the unit price calculation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided in the unit price calculation device 100, especially each processing function performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment, and the unit price calculation device Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the unit price calculation device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary. be.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes 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), and an EE. PROM (registration Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk) ), DVD (Digital Versatile Disk), Blu-ray (registered trademark) Disc, etc. shall include any “portable physical medium”. Therefore, a recording medium storing a program for executing the processing or processing method as described in this specification also constitutes the present invention.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

Various databases and the like stored in the storage unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and various databases used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the unit price calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the unit price calculation device 100 may be realized by installing software (including programs, data, etc.) that makes the device realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

The present invention is useful in the apparel retail industry, the steel wholesale industry (including processing wholesale), and the like.

100 Unit price calculation device
102 Control unit
102a Amount aggregation section
102b Inventory aggregation section
102c Unit price calculation section
104 Communication interface section
106 Storage section
106a Variety master
106b Product number master
106c Product master
106d Inventory data
106e Detailed data
108 Input/output interface section
112 Input device
114 Output device 200 Server 300 Network

Claims (6)

A unit price calculation device comprising a control unit and a storage unit,
In the storage unit,
A product master including product identification data,
a group master that includes an inventory evaluation aggregation classification for identifying an aggregation unit for asset management and is linked to the product master;
is stored,
The inventory evaluation aggregation classification is data that specifies which aggregation unit , i.e., product type , product number , or product, to aggregate the amount or inventory amount of the product specified by the product identification data;
The control unit includes:
The inventory data and the cost price linked to the product identification data included in the product master, based on the product identification data and inventory data including the amount and inventory amount of the product specified by the product identification data, and cost detail data. Amount aggregation means for aggregating the amounts included in the detailed data in aggregation units specified by the inventory evaluation aggregation classification ;
Based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data, which is linked to the product identification data included in the product master, is aggregated as specified by the inventory evaluation aggregation category. Inventory amount aggregation means for aggregating in units,
unit price calculation means for calculating a product unit price for each product type , product number , or product by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method;
to have
A unit price calculation device featuring: The cost detail data is generated based on receipt detail data that is detailed data regarding acceptance of the product specified by the product identification data;
The unit price calculation device according to claim 1, characterized in that: the receipt detail data is purchase detail data;
The unit price calculation device according to claim 2, characterized in that: the predetermined unit price calculation method is the gross average method;
The unit price calculation device according to any one of claims 1 to 3, characterized in that: A unit price calculation method executed by an information processing device including a control unit and a storage unit, the method comprising:
In the storage unit,
A product master including product identification data,
a group master that includes an inventory evaluation aggregation classification for identifying an aggregation unit for asset management and is linked to the product master;
is stored,
The inventory evaluation aggregation classification is data that specifies which aggregation unit, i.e., product type, product number, or product, to aggregate the amount or inventory amount of the product specified by the product identification data;
executed by the control unit,
The inventory data and the cost price linked to the product identification data included in the product master, based on the product identification data and inventory data including the amount and inventory amount of the product specified by the product identification data, and cost detail data. an amount aggregation step of aggregating the amounts included in the detailed data in aggregation units specified by the inventory evaluation aggregation classification;
Based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data, which is linked to the product identification data included in the product master, is aggregated as specified by the inventory evaluation aggregation category. an inventory amount aggregation step for aggregating in units;
a unit price calculation step of calculating a product unit price for each type, product number, or product by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method;
including;
A unit price calculation method characterized by: A unit price calculation program to be executed by an information processing device including a control unit and a storage unit, the program comprising:
In the storage unit,
A product master including product identification data,
a group master that includes an inventory evaluation aggregation classification for identifying an aggregation unit for asset management and is linked to the product master;
is stored,
The inventory evaluation aggregation classification is data that specifies which aggregation unit, i.e., product type, product number, or product, to aggregate the amount or inventory amount of the product specified by the product identification data;
for the control unit to execute,
The inventory data and the cost price linked to the product identification data included in the product master, based on the product identification data and inventory data including the amount and inventory amount of the product specified by the product identification data, and cost detail data. an amount aggregation step of aggregating the amounts included in the detailed data in aggregation units specified by the inventory evaluation aggregation classification;
Based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data, which is linked to the product identification data included in the product master, is aggregated as specified by the inventory evaluation aggregation category. an inventory amount aggregation step for aggregating in units;
a unit price calculation step of calculating a product unit price for each type, product number, or product by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method;
including;
A unit price calculation program featuring:

Images