JP7087123B2 - 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.

In Patent Document 1, the goods receipt history information is added and the cost control information is updated based on the goods receipt information, the goods receipt history information is updated based on the goods issue information, and the goods issue history information is added and the cost control information is updated. Calculate the average cost and calculate the cost from the allocated warehousing amount, and based on this information, calculate the asset amount by multiple valuation methods of the asset amount, sort and display the list, and more advantageous cost An invention for the purpose of presenting a calculation method and an asset value evaluation method is disclosed (see paragraph 0006, etc.).

Japanese Unexamined Patent Publication No. 07-2622282

In the field of calculating the amount of assets, 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 logistics management, using an aggregation unit called a size unit, "15 S size sheets have an inventory amount of 16,000 yen, 8 M size sheets have an inventory amount of 9,000 yen, and 5 L size sheets. In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, using an aggregate unit called a product type unit or a product number unit, it is said that "the inventory amount is 30,000 yen for 28 sheets in all sizes, so the unit price per sheet is 1,071 yen." It is often calculated and managed in the same way.

In this way, calculating the unit price of 1,071 yen for asset management based on inventory information in physical distribution management has traditionally been done manually by accounting staff, etc., and it takes a lot of time and effort. Was there.

The present invention has been made in view of the above, and is a unit price calculation device and a unit price that can calculate a product unit price in units of product types or product numbers, which are aggregate units in asset management, based on inventory information in physical distribution management. A calculation method and a unit price calculation program are provided.

In order to solve the above-mentioned problems and achieve the object, the unit price calculation device according to the present invention is a unit price calculation device including a control unit and a storage unit, and the storage unit is a product master including product identification data. And a group master associated with the product master, including group identification data for specifying the aggregation unit in asset management, and the group identification data is the product specified by the product identification data. It is data for specifying whether the amount or inventory amount of the product is aggregated in the product type unit or the product number unit, and the control unit controls the product identification data and the product specified by the product identification data. The group identification data identifies the inventory data and the amount included in the detail data, which are associated with the product identification data included in the product master, based on the inventory data and the detail data including the amount and the inventory amount of. The group includes the amount of money to be aggregated in the aggregation unit, the inventory data and the inventory amount included in the detail data associated with the product identification data included in the product master based on the inventory data and the detail data. The product unit price for each product type or product number is calculated by dividing the aggregated amount by the aggregated inventory amount according to the inventory amount aggregation means that aggregates in the aggregation unit specified by the identification data and the predetermined unit price calculation method. It is characterized by having a unit price calculation means for calculating.

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 apparatus including a control unit and a storage unit, and the storage unit includes a product master including product identification data and asset management. Contains group identification data for specifying the aggregation unit of, and stores the group master associated with the product master, and the group identification data is the amount or inventory of the product specified by the product identification data. It is data that specifies whether the quantity is aggregated in the product type unit or the product number unit, and is the amount of money for the product identification data executed by the control unit and the product specified by the product identification data. And, based on the inventory data including the inventory amount and the detail data, the aggregate unit in which the inventory data and the amount included in the detail data, which are associated with the product identification data included in the product master, are specified by the group identification data. Based on the amount aggregation step and the inventory data and the detail data, the inventory data and the inventory amount included in the detail data associated with the product identification data included in the product master are combined with the group identification data. The product unit price for each product type or product number is calculated by dividing the aggregated amount by the aggregated inventory amount according to the inventory amount aggregation step identified by the aggregation unit and the predetermined unit price calculation method. It is characterized by including a unit price calculation step.

Further, the unit price calculation program according to the present invention is a unit price calculation program for being executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes a product master including product identification data and asset management. The group identification data for specifying the above aggregation unit is included, and the group master associated with the product master is stored, and the group identification data is the amount of money or the amount of money for the product specified by the product identification data. Data that specifies whether to aggregate the inventory amount in the product type unit or the 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 the inventory data and the detail data including the amount and the inventory amount of, the inventory data and the amount included in the detail data associated with the product identification data included in the product master are specified by the group identification data. The group includes the amount aggregation step to be aggregated in the aggregation unit, and the inventory data and the inventory amount included in the detail data associated with the product identification data included in the product master based on the inventory data and the detail data. By dividing the aggregated amount by the aggregated inventory amount according to the inventory amount aggregation step that aggregates in the aggregation unit specified by the identification data and the predetermined unit price calculation method, the product unit price in units of product type or product number can be obtained. It is characterized by including a unit price calculation step to be calculated.

According to the present invention, it is possible to calculate the product unit price in units of product types or product numbers, which are aggregate units in 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 showing 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 the 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 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.

Hereinafter, embodiments of the unit price calculation device, the unit price calculation method, and the unit price calculation program according to the present invention will be described in detail with reference to the drawings. 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 distribution management, using an aggregate unit called a size unit, as shown in FIGS. 6 and 7, "For S size product AA-1, the balance as of September 1". 10 pieces + 5 pieces purchased on September 10 = 15 pieces, inventory amount 16,000 yen, for M size product AA-2, the remaining number as of September 1 + 3 pieces on September 10 5 pieces purchased = 8 pieces, inventory amount 9,000 yen, for L size product AA-2, the remaining number 5 pieces as of September 1 + 0 pieces purchased on September 10 = 5 pieces In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, using an aggregate unit called a product type unit or a product number unit, as shown in the lower right frame of FIG. 6, "28 sheets in total for all sizes are 30,000 yen, so 1 In many cases, the unit price per sheet is calculated as "1,071 yen" and managed.

In this case, it was necessary for the accounting side to link the inventory unit price information for distribution management with the system or Excel, calculate the inventory unit price for asset management on the accounting side, and receive the result from the accounting side. .. Alternatively, the physical distribution management unit was adjusted to the asset management unit. However, in the former case, it becomes necessary to customize the cooperation with the accounting side and the workload on the accounting side increases. Further, in the latter case, since the unit for physical distribution management is not used, the inventory must be procured and shipped by using the summary column or the like, so that the on-site work and the system operation are significantly separated.

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 mechanism that can manage the quantity and inventory of inventories on assets by performing inventory valuation unit price calculation aggregated for each product management hierarchy.

With the above mechanism, like the apparel retail business, apparel products of different sizes and colors in the same model are managed as separate items in terms of logistics management, while inventory quantity and unit price are managed by consolidating them into one model in terms of inventories. It is now possible to handle cases where In addition, as in the steel wholesale business, logistics management is performed according to dimensions such as thickness, width, and length in terms of logistics management, 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 mechanism, it is possible to grasp the distribution inventory and the accounting inventory (inventory assets) in the inventory management on the auxiliary book side, and grasp the accounting inventory in a state close to real time only by setting the master in advance. You can now do it. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the unit price calculation device 100 according to the present 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.

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

As shown in FIG. 1, 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. Each unit included in the unit price calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the unit price calculation device 100 to the network 300 so as to be communicable 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 communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The 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, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114 as a display unit, and the input device 112 may be described as a keyboard 112 or a mouse 112.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like 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. Hereinafter, the items included in each master and each data will be described.

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

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

The aggregation unit is one of a product type unit, a product number unit, and a product unit. As shown in FIG. 2, the product type unit is the upper layer, the product number unit is the middle layer, and the product unit is the lower layer. be. For example, when the product is an apparel product, as shown in FIG. 3, the product type unit means a higher level of "T-shirt" and "wallet", and when the product type unit is "T-shirt". The product number unit means the middle level of "Manufacturer A 2016 winter model" and "Manufacturer B 2016 winter model", and when the product number unit is "Manufacturer A 2016 winter model", the product unit is "Manufacturer A". It means the lower hierarchy of "2016 winter model BL LL" and "Manufacturer A 2016 winter model RDS". Further, for example, when the product is a steel material, as shown in FIG. 4, the product type unit means a higher layer of "H-shaped steel", "steel sheet pile", and "standard-sized deformed steel", and further, the product type unit. When is "H-shaped steel", the product unit means a lower hierarchy of "H200 x 200", "H250 x 250", and "H300 x 300" (Note that if the product is a steel material, the product number unit does not exist. ).

The inventory valuation aggregation category is data that specifies in which aggregation unit, the product type unit, the product number unit, or the product unit, the amount or inventory amount of the product specified by the product identification data included in the product master 106c is aggregated. be. The data that specifies the product type unit and the data that specifies the product number unit can be collectively referred to as group identification data. It should be noted that the unit of aggregation of the amount or inventory of products differs depending on the type of industry and the type of product. Specifically, in FIGS. 3 and 4, "Cost / inventory assets are In the hatching aggregation unit attached to "I want to recognize in this unit", the amount or inventory amount of the product is aggregated. For example, when the product is a T-shirt, as shown in FIG. 3, the products are aggregated in the middle layer (that is, by product number) of "manufacturer A 2016 winter model" and "manufacturer B 2016 winter model".

The product type master 106a may further include, for example, product type identification data (product type code), inventory management unit code, and the like. The inventory management unit code is data for 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 "pieces", "sheets", or the like representing the number of pieces. In addition, when the product is made of steel, the unit is unified as "kg (kilogram)", "t (ton)", etc., which represent the weight, and the common weight, which is a common index in asset management. Cost control is possible 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 serves to indirectly link the product number master 106a and the product master 106c as shown in FIG. As described above, the product number master 106b is an arbitrary component, and when the product number master 106b does not exist, the product number 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 master 106a as shown in FIG.

The inventory data 106d is data for managing inventory information about a product, and as shown in FIG. 9, the product identification data (product name in FIG. 9) and the amount of money for the product specified by the product identification data ( In FIG. 9, the amount of money in the previous month) and the amount of stock (in FIG. 9 the remaining number in the previous month) are included. 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, and for example, when the product is a steel material, the inventory weight is not limited to this. May be.

The detail data 106e is data for managing the detail information about the product, and as shown in FIG. 9, the product identification data (product name in FIG. 9) and the amount of money for the product specified by the product identification data ( Includes amount in FIG. 9) and quantity in stock (quantity in FIG. 9). The inventory amount is not limited to the inventory quantity as described in the previous paragraph, and may be, for example, the inventory weight.

The control unit 102 is a CPU or the like that collectively 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 that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally conceptually includes (1) the product identification data and the product included in the product master based on the inventory data and the detailed data including the amount and the stock amount of the product specified by the product identification data. The amount aggregation unit 102a as an amount aggregation means for aggregating the amounts included in the inventory data and the detail data associated with the identification data in the aggregation unit specified by the group identification data, and (2) the inventory data and Inventory amount aggregation that aggregates the inventory data and the inventory amount contained in the detail data in the aggregation unit specified by the group identification data, which is associated with the product identification data included in the product master based on the detail data. Unit price calculation to calculate the product unit price in units of product type or product number by dividing the aggregated amount of money by the aggregated inventory amount according to the inventory amount aggregation unit 102b as a means and (3) a predetermined unit price calculation method. It is provided with a unit price calculation unit 102c as a means. For details of the processing executed by each part, see the following [3. Specific example of processing] will be described.

[3. Specific example of processing]
Hereinafter, specific examples of the processing according to the present embodiment will be described 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, and a predetermined unit price calculation method is used for these three products. According to this, it is assumed that the product unit price is calculated for each product number. In addition, although there are many predetermined unit price calculation methods and are not particularly limited, in this item, a case where a total average method with a large number of adopted companies is used will be described.

The formula for calculating the total average method is as follows. Product unit price = (inventory carried forward in the current period + acquisition price of assets incurred in the current period) / (inventory of assets carried forward in the current period + number of acquired assets in the current period). Hereinafter, the numerator of the above calculation formula will be described first, then the denominator will be described, and finally the numerator / denominator will be described.

[3-1. Calculation of numerator (inventory carried forward in the current period + acquisition price of assets incurred in the current period)]
Based on the inventory data 106d and the detail data 106e, the amount aggregation unit 102a identifies the amount included in the inventory data 106d and the detail data 106e, which is associated with 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 inventory amount carried forward for the current period will be specifically described. The inventory amount carried forward for the current period can be calculated with reference to the inventory data 106d in FIG. Product identification data included in the product master 106c The amount associated with product AA-1, product AA-2, and product AA-3 is 10,000 yen and 3,000 yen, respectively, of the previous month's amount, referring to inventory data 106d. 5,000 yen. The amount aggregation unit 102a aggregates these amounts and calculates the inventory amount carried forward for the product number AA as 10,000 yen + 3,000 yen + 5,000 yen = 18,000 yen.

The calculated inventory amount carried forward for the current period of 18,000 yen for the product number AA may be temporarily stored as the asset inventory data in FIG. FIG. 8 shows an example in which the distribution unit is ignored in the asset inventory data and the data is aggregated by the asset unit, and the evaluation by product number is adopted. Asset information is added to the cost item data by referring to the inventory valuation summary classification of the product type master. In the case of evaluation by product type, the area of asset type is used, and in the case of evaluation by product, the area of asset product is used. Separately from logistics management, we have data that aggregates the assigned asset management units and calculates the evaluation in appropriate units.

Next, the calculation of the acquisition price of assets incurred in the current period will be specifically described. The acquisition price of assets incurred in the current period can be calculated with reference to the detailed data 106e in FIG. The amount of money associated with the product identification data product AA-1, product AA-2, and product AA-3 included in the product master 106c is 6,000 yen, which is the amount of product AA-1, and the product AA, referring to the detailed data 106e. The amount of -2 is 6,000 yen. The amount aggregation unit 102a aggregates these amounts and calculates the acquisition price of the assets incurred in the current period for the 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 inventory amount carried forward + current asset acquisition price) = 18,000 yen + 12,000 yen = 30,000 yen for the product number AA.

[3-2. Calculation of denominator (inventory of assets carried forward in the current period + number of acquired assets incurred in the current period)]
Based on the inventory data 106d and the detail data 106e, the inventory amount aggregation unit 102b identifies the inventory amount included in the inventory data 106d and the detail data 106e associated with the product identification data included in the product master 106c by the group identification data. Aggregate by the aggregation unit (product number unit).

First, the calculation of the number of assets carried forward for the current period will be specifically described. The number of assets carried forward for the current period can be calculated with reference to the inventory data 106d in FIG. 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 the remaining number of 10 sheets, 3 sheets, and 5 sheets in the previous month, respectively, referring to the inventory data 106d. It is a piece. The inventory amount aggregation unit 102b aggregates these inventory amounts and calculates the number of assets carried forward for the current period for product number AA as 10 + 3 + 5 = 18. The calculated number of asset inventory carried forward for the current period of 18 for the product number AA may be temporarily stored as the asset inventory data in FIG.

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

By adding the above-aggregated inventory amount, the inventory amount aggregation unit 102b calculates (the number of assets carried forward in the current period + the number of acquired assets generated in the current period) = 18 sheets + 10 sheets = 28 sheets for the product number AA.

[3-3. Calculation of numerator / denominator]
The unit price calculation unit 102c divides the aggregated amount (30,000 yen) by the aggregated inventory amount (28 sheets) to reduce the product unit price in the product number unit (product number AA) by 30,000 yen ÷ 28. Sheet ≒ 1,071.43 yen (rounded to the first decimal place).

As shown in the monthly inventory data (for the current month) in FIG. 9, the current month amount can be calculated by multiplying the remaining number of the current month by the unit price of the current month. Therefore, the current month's amount is 16,071 yen for product AA-1, 8,571 yen for product AA-2, and 5,357 yen for product AA-3, but in this case, the total amount of the three products is It will be 29,999 yen. Therefore, the above [3-1. ], Add 1 yen to the maximum current month amount of 16,071 yen to match it with the asset inventory of 30,000 yen, and adjust it to 16,072 yen. In this way, the amount on the distribution data can be replaced based on the valuation unit price and the asset amount obtained from the asset inventory.

As described above, 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 aggregate units in asset management, based on inventory information in physical distribution management. For this reason, for example, when the aggregation unit (size, color, etc.) in logistics management and the aggregation unit (product unit or product number unit) in asset management are different, the accounting department or the like has conventionally used the product unit or product number unit. The product unit price was calculated manually, but this is no longer necessary, and it is now possible to quickly refer to the product unit price by product type or product number in real time.

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

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

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

Further, with respect to the unit price calculation device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the unit price calculation device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the unit price calculation apparatus is required. Read mechanically to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

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 all or a part thereof can be downloaded as needed. be.

Further, the program for executing the process described in the present 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 Program Read Only Memory), and an EPROM (registered). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium". Therefore, a recording medium containing a program for executing a process or a process method as described herein also constitutes the present invention.

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, 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 and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, 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 an arbitrary peripheral device is connected. Further, the unit price calculation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

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 Department
102b Inventory aggregation unit
102c Unit price calculation unit
104 Communication interface section
106 Storage unit
106a Variety Master
106b Part number master
106c Product Master
106d inventory data
106e Detail data
108 Input / output interface section
112 Input device
114 Output device 200 Server 300 Network

Claims (6)

A unit price calculation device including a control unit and a storage unit.
In the storage unit
A product master containing product identification data and
A group master that includes group identification data for identifying aggregate units in asset management and is linked to the product master, and
Is stored,
The group identification data is data for specifying whether the amount or inventory amount of the product specified by the product identification data is aggregated in the product type unit or the product number unit.
The control unit
The inventory data and the cost associated with the product identification data included in the product master based on the product identification data and the inventory data including the amount and the inventory amount of the product specified by the product identification data and the cost item data. A monetary amount aggregation means that aggregates the amount of money included in the detailed data in the aggregation unit specified by the group identification data, and
Based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data associated with the product identification data included in the product master is an aggregation unit specified by the group identification data. Inventory amount aggregation means to be aggregated in
A unit price calculation means for 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.
To prepare for
A unit price calculation device characterized by. The cost item data shall be generated based on the receipt item data which is the item data regarding the acceptance of the item specified by the item identification data.
The unit price calculation device according to claim 1. The receipt detail data is purchase detail data.
2. The unit price calculation device according to claim 2. The predetermined unit price calculation method is the total average method.
The unit price calculation device according to any one of claims 1 to 3. It is a unit price calculation method executed by an information processing device including a control unit and a storage unit.
In the storage unit
A product master containing product identification data and
A group master that includes group identification data for identifying aggregate units in asset management and is linked to the product master, and
Is stored,
The group identification data is data for specifying whether the amount or inventory amount of the product specified by the product identification data is aggregated in the product type unit or the product number unit.
Executed by the control unit,
The inventory data and the cost associated with the product identification data included in the product master based on the product identification data and the inventory data including the amount and the inventory amount of the product specified by the product identification data and the cost item data. An amount aggregation step that aggregates the amounts included in the detailed data in the aggregation unit specified by the group identification data, and
Based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data associated with the product identification data included in the product master is an aggregation unit specified by the group identification data. The inventory amount aggregation step to be aggregated in
A unit price calculation step for 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.
To include,
A unit price calculation method characterized by. It is a unit price calculation program to be executed by an information processing device including a control unit and a storage unit.
In the storage unit
A product master containing product identification data and
A group master that includes group identification data for identifying aggregate units in asset management and is linked to the product master, and
Is stored,
The group identification data is data for specifying whether the amount or inventory amount of the product specified by the product identification data is aggregated in the product type unit or the product number unit.
To make the control unit execute
The inventory data and the cost associated with the product identification data included in the product master based on the product identification data and the inventory data including the amount and the inventory amount of the product specified by the product identification data and the cost item data. An amount aggregation step that aggregates the amounts included in the detailed data in the aggregation unit specified by the group identification data, and
Based on the inventory data and the cost detail data, the inventory amount included in the inventory data and the cost detail data associated with the product identification data included in the product master is an aggregation unit specified by the group identification data. The inventory amount aggregation step to be aggregated in
A unit price calculation step for 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.
To include,
A unit price calculation program featuring.

Images