JP2022119994A - Unit price calculation apparatus, unit price calculation method, and unit price calculation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a unit price calculation apparatus which can calculate a commodity unit price for each product class or product number, which is a unit of aggregation on asset management, on the basis of, inventory information in physical distribution management, a unit price calculation method, and a unit price calculation program.

SOLUTION: A unit price calculation apparatus includes: an amount aggregation unit which aggregates an amount of money included in inventory data and specification data associated with commodity identification data included in a commodity master, by an aggregation unit specified by group identification data, on the basis of the commodity identification data, the inventory data including an amount of money and a quantity of inventory on a commodity identified by the commodity identification data, and the specification data; an inventory aggregation unit which aggregates the quantity of inventory included in the inventory data and the specification data associated with the commodity identification data included in the commodity master, on the basis of the inventory data and the specification data, by the aggregation unit specified by the group identification data; and a unit price calculation unit which divides the aggregated amount of money by the aggregated quantity of inventory in accordance with a predetermined unit price calculation method, to calculate a commodity unit price for each product class or product number.

SELECTED DRAWING: Figure 1

COPYRIGHT: (C)2022,JPO&INPIT

Description

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

In Patent Document 1, based on the warehousing information, adding to the warehousing history information and updating the cost management information, updating the warehousing history information based on the shipping information, adding to the shipping history information and updating the cost management information, Calculate the average cost and the cost from the reserved storage amount, and based on this information, calculate the asset value by multiple valuation methods of asset value, sort it, and display the list to obtain a more advantageous cost. An invention aimed at presenting a method for calculating and evaluating the amount of assets has been disclosed (see paragraph 0006, etc.).

JP-A-07-262282

In such a field of calculating the amount of assets, there are many cases where the aggregation unit for physical distribution management and the aggregation unit for asset management are different. For example, in the case of T-shirts, in terms of distribution management, we use an aggregation unit called a size unit, and say, "15 S size items cost 16,000 yen, 8 M size items cost 9,000 yen, and 5 L size items In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, we use aggregation units such as product type units or product number units, and say, "Since there are 28 sheets in all sizes and the inventory value is 30,000 yen, the unit price per sheet is 1,071 yen." It is often calculated and managed accordingly.

In this way, calculating the unit price of 1,071 yen for asset management based on inventory information in physical distribution management has conventionally been done manually by accounting personnel, etc., requiring a great deal of time and labor. was

SUMMARY OF THE INVENTION The present invention has been made in view of the above. A calculation method and a unit price calculation program are provided.

In order to solve the above-described problems and achieve the object, a unit price calculation device according to the present invention is a unit price calculation device comprising a control unit and a storage unit, wherein the storage unit stores a product master including product identification data. and a group master that includes group identification data for specifying an aggregation unit for asset management and is linked to the product master, and the group identification data is the product specified by the product identification data. is data specifying whether to aggregate the amount of money or the amount of inventory in units of product type or product number, and the control unit controls the product identification data and the product specified by the product identification data Based on inventory data and detail data including the amount and amount of inventory, the amount included in the inventory data and the detail data linked to the product identification data included in the product master is identified by the group identification data. an amount aggregation means for aggregating in an aggregation unit; and based on the inventory data and the detail data, the inventory amount included in the inventory data and the detail data linked to the product identification data included in the product master is collected by the group. Inventory amount aggregation means for aggregation 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, thereby calculating the product unit price per product type or product number. and a unit price calculating 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 gross average method.

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

Further, a unit price calculation program according to the present invention is a unit price calculation program to be executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores a product master including product identification data and an asset management unit. A group master linked to the product master, including group identification data for specifying the above aggregation unit, is stored, and the group identification data is the amount or This is data specifying whether the inventory amount is to be aggregated by product type unit or by product number unit, and the product identification data and the product specified by the product identification data to be executed by the control unit Based on inventory data and detail data including the amount and amount of inventory, the amount included in the inventory data and the detail data linked to the product identification data included in the product master is identified by the group identification data. an amount aggregation step of aggregating in an aggregation unit; and based on the inventory data and the detail data, the inventory amount included in the inventory data and the detail data linked to the product identification data included in the product master is aggregated into the group. An inventory amount aggregation step for aggregation in an aggregation unit specified by identification data, and dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method, thereby calculating the product unit price per product type or product number. and a unit price calculation step of calculating.

Advantageous Effects of Invention According to the present invention, it is possible to calculate the product unit price for each product type or product number, which is an aggregation unit for asset management, based on inventory information in physical distribution 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 showing an example of a hierarchy of aggregation units in apparel products. FIG. 4 is a diagram showing an example of a hierarchy of aggregate 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 showing an example of how to calculate the product unit price for each product. FIG. 8 is a diagram showing an example of how to calculate the product unit price for each product number. FIG. 9 is a diagram showing an example of how to calculate the product unit price for each product number.

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 below with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
In the apparel retail industry, the steel material wholesale industry, and the like, the aggregation unit for physical distribution management and the aggregation unit for asset management are often different. For example, in the case of T-shirts, in terms of physical distribution management, size units are aggregated units, and as shown in FIGS. 10 pieces + 5 pieces purchased on September 10th = 15 pieces with an inventory value of 16,000 yen. The number of purchases is 5 pieces = 8 pieces, and the inventory amount is 9,000 yen. In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, as shown in the lower right frame of FIG. The unit price per sheet is 1,071 yen."

In this case, it was necessary for the accounting side to link the inventory unit price information for logistics management using a system or Excel, calculate the inventory unit price for asset management on the accounting side, and receive the results from the accounting side. . Alternatively, the units for physical distribution management were aligned with the units for asset management. However, in the former case, there is a need to customize cooperation with the accounting side and an increase in the workload on the accounting side. In addition, in the latter case, since units for physical distribution management are not used, there is no choice but to procure and ship inventory using description columns, etc., resulting in a significant divergence between on-site work and system operation.

In this way, there is a pattern in which different products are treated as the same asset in terms of accounting, depending on the industry. Therefore, in the present embodiment, an inventory evaluation unit price calculation is performed for each product management hierarchy, and a mechanism has been developed whereby the quantity on assets and the amount of inventory can be managed.

With the above mechanism, like apparel retailers, apparel items of the same model with different sizes and colors are managed as separate items in terms of logistics management, while consolidating them into one model in terms of inventory assets to manage the number of inventories and unit prices. It became possible to correspond to the case to do. In addition, as in the steel wholesale business, logistics management is performed according to dimensions such as thickness, width, length, etc., and even if the dimensions are different in inventory assets, inventory weight and unit price are aggregated by material and shape. It became possible to deal with the case of managing

In addition, with the above-mentioned mechanism, it is possible to grasp both physical distribution inventory and accounting inventory (inventory assets) in inventory management on the subsidiary book side, and grasp accounting inventory in near real time just by setting the master in advance. It became possible. Specific configurations and operations will be described below.

[2. Constitution]
The configuration of the unit price calculation device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the unit price calculation device 100. As shown in FIG.

The unit price calculation device 100 is a commercially available desktop personal computer. Note that the unit price calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. It may be an information processing device.

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

The communication interface unit 104 communicably 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 another device via a communication line. Here, the network 300 has a function of connecting the unit price calculation device 100 and the server 200 so as to be able to 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 to 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 section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to provide a pointing device function. In the following description, the output device 114 may be referred to as the monitor 114 as a display unit, and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks 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. Of these, the product number master 106b is an arbitrary component, and may or may not be included in the storage unit 106. FIG. Items included in each master and each data will be described below.

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

The product type master 106a, as shown in FIG. 5, includes an inventory evaluation tabulation section for specifying an aggregation unit for asset management, and is directly or indirectly associated with the product master.

The unit of aggregating is any one of a product type unit, a product number unit and a product unit. As shown in FIG. be. For example, if the product is an apparel product, as shown in FIG. The product number unit means the middle hierarchy of "Manufacturer A 2016 winter model" and "Manufacturer B 2016 winter model". 2016 winter model BL LL” and “manufacturer A 2016 winter model RD S”. Further, for example, when the product is a steel material, as shown in FIG. is "H-beam steel", the product unit means the lower hierarchy of "H200 x 200", "H250 x 250", and "H300 x 300". ).

The inventory evaluation aggregate classification is data specifying which aggregate unit, type unit, product number unit, or product unit, to aggregate the amount of money or the amount of inventory for the product specified by the product identification data included in the product master 106c. 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. It should be noted that in which aggregation unit to aggregate the amount of money or the amount of inventory for the product depends on the type of industry and the type of product. I would like to recognize in this unit", aggregate the amount of money or the amount of stock for the product in the hatched aggregation unit attached. For example, if the product is a T-shirt, as shown in FIG. 3, the aggregation is performed in the middle hierarchy (that is, by product number) of “Manufacturer A Winter 2016 model” and “Manufacturer B Winter 2016 model”.

The product type master 106a may further include, for example, product identification data (product type code), inventory management unit code, and the like. The inventory management unit code is data specifying a unit for aggregating the inventory amount of the product specified by the product identification data included in the product master 106c. For example, when the product is an apparel product, the unit can be "piece", "piece", or the like, which indicates the number. In addition, when the product is a steel material, the unit is set to "kg (kilogram)", "t (ton)", etc., which represents weight, and by unifying the common weight, which is a common index for asset management, It is possible to manage costs by consolidating steel materials of the same type but different shapes.

The product number master 106b includes, for example, product number identification data (product number code) and the like, and 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 associated with the product type master 106a as shown in FIG.

The inventory data 106d is data for managing inventory information about products. In FIG. 9, it includes the previous month's amount) and the inventory amount (the previous month's balance in FIG. 9). Note that the inventory quantity is the inventory quantity when the product is an apparel product as in the example of FIG. 9, but is not limited to this. may be

The detailed data 106e is data for managing detailed information about a product, and as shown in FIG. 9, includes product identification data (product name in FIG. 9) and the amount of money ( amount in FIG. 9) and inventory amount (quantity in FIG. 9). Note that the inventory amount is not limited to the inventory quantity, and may be, for example, the inventory weight, as described in the preceding paragraph.

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

The control unit 102 functionally and conceptually: (1) identifies products included in the product master based on product identification data, inventory data including the price and inventory amount of the product specified by the product identification data, and detailed data; (2) the inventory data and Inventory quantity aggregation for aggregating, based on the detailed data, the inventory data linked to the product identification data included in the product master and the inventory quantity included in the detailed data in aggregation units specified by the group identification data. and (3) a unit price calculator that calculates the product unit price for each type or product number by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method. and a unit price calculation unit 102c as means. Details of the processing executed by each unit are described in [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 with reference to FIG. 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. Therefore, it is assumed that the product unit price is calculated for each product number. There are many predetermined unit price calculation methods, and they are not particularly limited, but in this item, the case of using the total average method, which is used by a large number of companies, will be described.

The calculation formula of the weighted average method is as follows. Product unit price = (Current term carryover inventory amount + Current term asset acquisition price)/(Current term carryover asset inventory count + Current term acquisition asset count). Hereinafter, the numerator of the above formula will be explained first, then the denominator will be explained, and finally the numerator/denominator will be explained.

[3-1. Calculation of the numerator (inventory carried forward in the current period + acquisition cost of assets incurred in the current period)]
Based on the inventory data 106d and the detail data 106e, the amount aggregation unit 102a specifies the amounts included in the inventory data 106d and the detail data 106e linked to the product identification data included in the product master 106c by the group identification data. Consolidate by aggregation unit (product number unit).

First, the calculation of the current term carry-over inventory amount will be specifically described. The current term carry-over inventory amount can be calculated by referring to the inventory data 106d in FIG. Referring to the inventory data 106d, the amounts associated with the product identification data products AA-1, AA-2, and AA-3 included in the product master 106c are 10,000 yen and 3,000 yen, respectively, the amounts of the previous month. , 5,000 yen. The amount aggregation unit 102a aggregates these amounts, and calculates the current-term carried-over inventory amount for product number AA as follows: 10,000 yen + 3,000 yen + 5,000 yen = 18,000 yen.

Note that the current term carry-over inventory amount of 18,000 yen for the product number AA calculated may be temporarily stored as asset inventory data in FIG. FIG. 8 shows an example in which physical distribution units are disregarded in the asset inventory data and aggregation is performed on an asset-by-asset basis, and evaluation by product number is adopted. Asset information is attached to the purchase data for distribution to the cost detail data by referring to the inventory evaluation summary classification of the product master. In the case of evaluation by type, the area of asset types is used, and in the case of evaluation by product, the area of asset products is used. Separately from physical distribution management, data is aggregated according to the assigned asset management unit and the evaluation is calculated in an appropriate unit.

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

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

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

First, the calculation of the number of carry-over assets in the current period will be specifically described. The carry-over asset inventory quantity for the current term can be calculated by referring to the inventory data 106d of FIG. The inventory amounts associated with the product identification data products AA-1, AA-2, and AA-3 included in the product master 106c are 10 pieces, 3 pieces, and 5 pieces, respectively. is a sheet. The inventory amount aggregating unit 102b aggregates these inventory amounts, and calculates the current term carry-over asset inventory number for the product number AA as 10 pieces+3 pieces+5 pieces=18 pieces. Note that the current term carry-over asset inventory number of 18 for the product number AA calculated may be temporarily stored as the asset inventory data in FIG.

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

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

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

As shown in the monthly inventory data (for the current month) in FIG. 9, the monthly amount can be calculated by multiplying the balance for the current month by the unit price for the current month. Therefore, the monthly amount for product AA-1 is 16,071 yen, product AA-2 is 8,571 yen, and product AA-3 is 5,357 yen. It will be 29,999 yen. Therefore, the above [3-1. ], the maximum monthly amount of 16,071 yen is adjusted to 16,072 yen by adding 1 yen in order to match it with the asset inventory of 30,000 yen. In this way, the amount on the physical distribution data can be adjusted based on the evaluation unit price/asset amount obtained from the asset inventory.

As described above, the unit price calculation device 100 according to the present embodiment can calculate the product unit price for each product type or product number, which is an aggregation unit for asset management, based on inventory information in physical distribution 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 (by product type or product number), conventionally, the accounting department etc. Manually calculating the product unit price has become unnecessary, and furthermore, it has become possible to quickly refer to the product unit price by product type or product number in real time.

[4. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above 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 automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to 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 of the unit price calculation device 100, particularly the processing functions performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. 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 the unit price calculation device as necessary. 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the unit price calculation device 100 via any network, and all or part of it can be downloaded as necessary. be.

Also, the 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 term "recording medium" means memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (Registered trademark) such as Blu- shall include any "portable physical medium". Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted 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, the installation procedure after reading, and the like.

The 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 are used for various processing and website provision. programs, tables, databases, and files for web pages.

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 arbitrary peripheral devices are connected. Also, the unit price calculation device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

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

100 unit price calculation device
102 control unit
102a Amount aggregation unit
102b Inventory Aggregation Unit
102c unit price calculator
104 communication interface unit
106 storage unit
106a Variety master
106b Product number master
106c Product master
106d Inventory data
106e Detailed data
108 input/output interface
112 input device
114 output device 200 server 300 network

Claims (1)

A unit price calculation device comprising a control unit and a storage unit,
The storage unit contains
a product master containing product identification data;
a group master that includes group identification data for identifying aggregation units for asset management and that is associated with the product master;
is stored and
The group identification data is data specifying whether the amount of money or inventory amount of the product specified by the product identification data is aggregated in units of product type or product number,
The control unit
The inventory data and the cost, which are linked to the product identification data contained in the product master, based on the product identification data and the inventory data and cost detail data including the price and inventory amount of the product specified by the product identification data. an amount aggregating means for aggregating the amounts included in the detailed data in an aggregation unit specified by the group identification data;
Aggregation unit specified by the group identification data, based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data linked with the product identification data included in the product master an inventory amount aggregation means that aggregates with
Unit price calculation means for calculating a product unit price per product type or product number by dividing the aggregated amount by the aggregated inventory amount according to a predetermined unit price calculation method;
to provide
A unit price calculation device characterized by:

Images