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

Abstract

PROBLEM TO BE SOLVED: To provide a unit price calculation device, a unit price calculation method and a unit price calculation program capable of calculating a product unit price for each product type or product number, which is an aggregation unit in asset management, based on inventory information in physical distribution management. .. In the present embodiment, (1) product identification data and product identification data included in a product master based on inventory data and detailed data including an amount and inventory amount of a product specified by the product identification data. The associated inventory data and the amount of money included in the detail data are aggregated in an aggregation unit specified by the group identification data (2) Product identification included in the product master based on the inventory data and the detail data. The inventory amount associated with the data and the inventory amount included in the detailed data are aggregated in the aggregation unit specified by the group identification data (3) The aggregated amount is aggregated according to a predetermined unit price calculation method. Divide by the amount of stock to calculate the product unit price for each product type or product number. [Selection diagram] FIG. 9

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, addition and cost management information are updated to warehousing history information based on warehousing information, warehousing history information is updated based on warehousing information, addition and cost management information are updated to warehousing history information, Calculate the cost from the warehousing value calculated and allocated the average cost, calculate the asset value by multiple valuation methods of the asset value based on this information, sort and display the list, more advantageous cost An invention for the purpose of presenting a calculation and asset value evaluation method is disclosed (see paragraph 0006 and the like).

Japanese Patent Laid-Open No. 07-262282

  In such a field of calculating the amount of assets, there are many cases where an aggregation unit for physical distribution management and an aggregation unit for asset management are different. For example, in the case of T-shirts, in logistics management, an aggregate unit called size unit is used, and “S size 15 sheets, stock price 16,000 yen, M size 8 sheets, stock price 9,000 yen, L size 5 sheets. In many cases, the inventory amount is 5,000 yen. On the other hand, in asset management, using an aggregation unit of product type or product number unit, “the total unit price is 30,000 yen for 28 pieces in total, so the unit price per piece is 1,071 yen” It is often calculated and managed in the same way.

  In this way, calculating the unit price of 1071 yen for asset management based on inventory information in logistics management has been done manually by accounting staff, etc., and it takes a lot of time and labor. It was.

  The present invention has been made in view of the above, and a unit price calculation device capable of calculating a product unit price in a product unit or a product number unit, which is an aggregation unit in asset management, based on inventory information in logistics management, 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 apparatus according to the present invention is a unit price calculation apparatus including a control unit and a storage unit, and the storage unit includes a product master including product identification data. And a group master associated with the product master, and the group identification data is a product specified by the product identification data. Is the data for identifying whether the product amount unit or the product number unit is aggregated, and the control unit is configured to store the product identification data and the product identified by the product identification data. Based on the inventory data and item data including the amount and the inventory amount, the inventory data and the product identification data included in the product master Amount aggregation means for aggregating the amount included in the description data in an aggregation unit specified by the group identification data, and linking the product identification data included in the product master based on the inventory data and the detail data , Inventory amount aggregating means for aggregating the inventory amount included in the inventory data and the detailed data in an aggregation unit specified by the group identification data, and the aggregated inventory according to a predetermined unit price calculation method Unit price calculating means for calculating a product unit price by product type or product number unit by dividing by quantity.

  The unit price calculation apparatus according to the present invention is characterized in that the predetermined unit price calculation method is a total average method.

  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. The storage unit includes a product master including product identification data, and asset management. A group master associated with the product master is stored, and the group identification data is an amount or a stock for the product specified by the product identification data. This is data that specifies whether the quantity is aggregated by product type unit or product number unit, and is executed by the control unit for the product identification data and the amount for the product specified by the product identification data And the inventory data and the detail data associated with the product identification data included in the product master, Amount aggregation step of aggregating the amount included in the detailed data in an aggregation unit specified by the group identification data, and based on the inventory data and the detailed data, linked to the item identification data included in the item master, An inventory amount aggregating step of aggregating the inventory amount included in the inventory data and the detailed data in an aggregation unit specified by the group identification data, and the aggregated amount of the aggregated amount according to a predetermined unit price calculation method And a unit price calculation step of calculating a product unit price in product type units or product number units.

  A unit price calculation program according to the present invention is a unit price calculation program for causing an information processing apparatus including a control unit and a storage unit to execute, and the storage unit includes a product master including product identification data, and asset management. Group identification data for specifying the above aggregation unit is stored, and a group master associated with the product master is stored, and the group identification data includes an amount of product specified by the product identification data or This is data that specifies whether the stock quantity is aggregated in the product unit or product number unit, and for the product identified by the product identification data and the product identification data to be executed by the control unit Based on the inventory data and the item data including the amount and the inventory amount, the product identification data included in the product master, Amount aggregation step of aggregating the amount included in the inventory data and the detail data in an aggregation unit specified by the group identification data, and the product identification included in the product master based on the inventory data and the detail data In accordance with an inventory amount aggregation step for aggregating the inventory amount included in the inventory data and the detailed data associated with the data in an aggregation unit specified by the group identification data, the aggregated amount is determined according to a predetermined unit price calculation method. And a unit price calculation step of calculating a product unit price by product type or product number unit by dividing by the aggregated inventory amount.

  According to the present invention, it is possible to 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.

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

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

[1. Overview]
In the apparel retail industry, steel wholesale industry, etc., the aggregate unit for logistics management and the aggregate unit for asset management are often different. For example, in the case of a T-shirt, in logistics management, as shown in FIG. 6 and FIG. 7 using an aggregation unit called a size unit, “S size product AA-1 is the remaining as of September 1st. Number 10 pieces + September 10 purchase number 5 pieces = 15 pieces, stock price 16,000 yen, M size product AA-2 as of September 1 remaining number 3 pieces + September 10 Number of purchases = 5 = stock price of 9,000 yen, L size product AA-2 is 5 remaining as of September 1 + 0 purchases on September 10 = 5 In many cases, the inventory amount is 5,000 yen. On the other hand, in the asset management, as shown in the lower right frame of FIG. 6, using the aggregation unit of the product type unit or the product number unit, “the total size is 28, and it is 30,000 yen. In many cases, the unit price is calculated as “1,071 yen per sheet”.

  In this case, it was necessary for the accounting side to link the information on the inventory unit price for logistics management with the system and Excel, calculate the inventory unit price for asset management on the accounting side, and receive the result from the accounting side . Alternatively, the unit for logistics management is matched with the unit for asset management. However, in the former case, it becomes necessary to customize cooperation with the accounting side and increase the workload on the accounting side. In the latter case, since no unit for physical distribution management is used, it is necessary to procure and ship inventory using a summary column and the like, and the field work and system operation are significantly different.

  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 the present embodiment, a system has been developed in which the inventory evaluation unit price calculation aggregated in the product management hierarchy unit is performed, and thereby the quantity on the asset and the inventory inventory amount can be managed.

  With the above-mentioned structure, as in the apparel retail business, while managing apparel products of different sizes and colors in the same model as separate items in terms of logistics management, the inventory quantity and unit price are managed by consolidating them into one model on inventory. It became possible to respond to the case. In addition, as in the steel wholesale business, logistics management is carried out according to dimensions such as thickness, width, length, etc. for logistics management, and inventory weight and unit price are aggregated by material and shape even if the inventory is different in dimensions. It became possible to handle the case of managing.

  In addition, with the above-mentioned mechanism, it is possible to grasp both distribution stock and accounting inventory (inventory assets) in the inventory management on the auxiliary book side, and grasp accounting inventory in near real-time only by setting the master in advance. I was able to do that. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the unit price calculation apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the unit price calculation apparatus 100.

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

  As shown in FIG. 1, the unit price calculation apparatus 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 apparatus 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the unit price calculation apparatus 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 apparatus 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 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 unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, 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 various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk 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 106 b is an arbitrary component, and may or may not be included in the storage unit 106. Hereinafter, items included in each master and each data will be described.

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

  As shown in FIG. 5, the product type master 106 a includes an inventory evaluation summary classification 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, and as shown in FIG. 2, the product unit is an upper level, the product number unit is a middle level, and the product unit is a lower level. is there. For example, when the product is an apparel product, as shown in FIG. 3, the product unit means the upper layer of “T-shirt” and “wallet”, and further, when the product unit is “T-shirt”, The product number unit means the middle level of “Manufacturer A 2016 Winter Model” and “Manufacturer B 2016 Winter Model”. Furthermore, when the product number unit is “Manufacturer A 2016 Winter Model”, the product unit is “Manufacturer A 2016 Winter Model”. It means a lower hierarchy of “2016 Winter Model BL LL” “Manufacturer A 2016 Winter Model RD S”. Further, for example, when the product is a steel material, as shown in FIG. 4, the product type means an upper hierarchy of “H-shaped steel”, “steel sheet pile”, and “standard deformed steel”, and further, product type Is “H-shaped steel”, the product unit means a lower hierarchy of “H200 × 200”, “H250 × 250”, and “H300 × 300” (in the case where the product is a steel material, there is no product number unit) ).

  The inventory evaluation aggregation classification 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 in a product unit, a product number unit, or a product unit. is there. Data specifying the product unit and data specifying the product number unit can be collectively referred to as group identification data. Note that the aggregation unit for 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 is Aggregate the amount of money or the amount of inventory in the hatching aggregation unit attached to “I want to recognize in this unit”. For example, when the product is a T-shirt, as shown in FIG. 3, aggregation is performed in a middle hierarchy (namely, product number unit) of “maker A 2016 winter model” and “maker B 2016 winter model”.

  The product master 106a may further include, for example, product identification data (product code), an inventory management unit code, and the like. The inventory management unit code is data for specifying a unit for aggregating the inventory amount of products 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. In addition, when the product is steel, the unit is expressed as “kg (kilogram)”, “t (ton)”, etc. indicating weight, and by unifying with a common weight that is a common index in asset management, Cost management that integrates steel products of the same type and different shapes is possible.

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

  The inventory data 106d is data for managing inventory information about products, and, as shown in FIG. 9, the product identification data (product name in FIG. 9) and the amount of product specified by the product identification data ( 9 includes the previous month amount) and the inventory amount (the previous month remaining number in FIG. 9). The inventory quantity is an inventory quantity when the product is an apparel product as in the example of FIG. 9, but is not limited to this. For example, when the product is a steel material, the inventory weight It may be.

  The detail data 106e is data for managing detailed 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 ( 9 includes an amount) and an inventory amount (a quantity in FIG. 9). In addition, the said stock quantity is not limited to a stock quantity like the description of the previous paragraph, For example, a stock weight may be sufficient.

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

  The control unit 102 is functionally conceptual (1) a product included in the product master on the basis of inventory data and detailed data including product identification data and an amount and a stock amount for the product specified by the product identification data. An amount aggregating unit 102a as an amount aggregating unit for aggregating the amounts included in the inventory data and the detailed data associated with identification data in an aggregation unit specified by the group identification data; (2) the inventory data and Based on the detail data, inventory quantity aggregation that aggregates the inventory data and the inventory quantity included in the detail data associated with the merchandise identification data included in the merchandise master in an aggregation unit specified by the group identification data. A stock amount aggregating unit 102b as a means, and (3) according to a predetermined unit price calculation method, By dividing the aggregated inventory includes a unit price calculation unit 102c of the unit price calculating means for calculating a unit price of varieties unit or part unit, the. The details of the processing executed by each unit are described in [3. Specific Example of Processing] will be described.

[3. Specific example of processing]
Hereinafter, a specific example 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, the product AA-1, the product AA-2, and the product AA-3 are included in the product master 106c. For these three products, a predetermined unit price calculation method is used. As a result, it is assumed that the product unit price is calculated by product number. There are many predetermined unit price calculation methods, and there is no particular limitation. In this item, a case where a total average method with a large number of employed companies is used will be described.

  The calculation formula of the total average method is as follows. Product unit price = (Inventory value carried forward in the current period + Acquisition cost of assets in the current period) / (Number of assets carried in the current period + Number of acquired assets in the current period). Hereinafter, the numerator of the 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 amount carried forward in the current period + acquisition cost of assets in the current period)]
Based on the inventory data 106d and the detail data 106e, the amount summarizing unit 102a specifies the amount included in the inventory data 106d and the detail data 106e to be associated with the product identification data included in the product master 106c by the group identification data. Aggregate by aggregation unit (part number unit).

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

  The calculated carry-over inventory amount 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 aggregation is performed on the asset unit basis, and the evaluation by product number is adopted. Asset information is assigned by referring to the inventory evaluation summary classification of the product type master for the purchase data on logistics and the cost details data. In the case of product type evaluation, the asset type area is used, and in the case of product type evaluation, the asset product area is used. Aggregate the assigned asset management units, and have data that can be calculated in appropriate units separately from logistics management.

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

  By adding the aggregated amounts as described above, the aggregate amount unit 102a calculates (stock carry-over amount during the current period + acquired asset acquisition price during the current period) = 18,000 yen + 12,000 yen = 30,000 yen for the product number AA.

[3-2. Calculation of denominator (number of assets carried forward during the period + number of assets acquired during the period)]
Based on the inventory data 106d and the detail data 106e, the inventory quantity aggregating unit 102b identifies the inventory quantity included in the inventory data 106d and the detail data 106e associated with the product identification data included in the product master 106c by using the group identification data. Is aggregated in units of aggregation (part number units).

  First, the calculation of the inventory carry-forward asset inventory will be specifically described. The number of assets carried forward in the current period can be calculated with reference to the inventory data 106d in FIG. The inventory quantity associated with the product identification data products AA-1, product AA-2, product AA-3 included in the product master 106c is the remaining number of the previous month, 10 sheets, 3 sheets, It is a sheet. The inventory quantity aggregating unit 102b aggregates these inventory quantities, and calculates the number of assets carried over in the current period for the product number AA as 10 sheets + 3 sheets + 5 sheets = 18 sheets. In addition, you may once preserve | save as the asset inventory data of FIG.

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

  By adding the collected inventory amounts as described above, the inventory amount aggregation unit 102b calculates (number of assets carried forward in the current period + number of assets acquired 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 quantity (28 sheets), so that the product unit price in the product number unit (article number AA) is 30,000 yen ÷ 28. It is calculated that the number of sheets is approximately 1,071.43 yen (the third decimal place is rounded off).

  As shown in the monthly inventory data (for the current month) in FIG. 9, the current month amount can be calculated by the remaining number of the current month × the current month unit price. For this reason, the amount for this month is 16,071 yen for product AA-1, 8,571 yen for product AA-2, and 5,357 yen for product AA-3. It will be 29,999 yen. Therefore, the above [3-1. ] Is adjusted to 16,072 yen by adding 1 yen to the maximum current monthly amount of 16,071 yen. In this way, the amount in the distribution data can be reconstituted based on the evaluation unit price and the amount of the asset obtained from the asset inventory.

  As described above, according to the unit price calculation apparatus 100 according to the present embodiment, the product unit price in the product type unit or the product number unit, which is an aggregation unit in asset management, can be calculated based on the inventory information in logistics management. For this reason, for example, when the aggregation unit (size, color, etc.) for logistics management is different from the aggregation unit (product type unit or product number unit) for asset management, the accounting department, etc. The product unit price was calculated manually, but this is no longer necessary, and the product unit price by product type or product number can be referred to quickly 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, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the 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 the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  Further, regarding the unit price calculation apparatus 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 apparatus 100, particularly the processing functions performed by the control unit 102, are realized in whole or in any part by a CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and a unit price calculation device as necessary. 100 mechanically read. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the unit price calculation apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. is there.

  In addition, 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” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk, etc.), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include. Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  The unit price calculation apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which an arbitrary peripheral device is connected. The unit price calculation apparatus 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the apparatus.

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

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

100 unit price calculation device
102 Control unit
102a Amount Aggregation Department
102b Inventory quantity aggregation part
102c unit price calculation unit
104 Communication interface
106 Storage unit
106a Product master
106b Part number master
106c Product master
106d Stock data
106e Detail data
108 Input / output interface
112 Input device
114 Output device 200 Server 300 Network

Claims (4)

A unit price calculation apparatus comprising a control unit and a storage unit,
In the storage unit,
A product master containing product identification data;
Including group identification data for identifying an aggregation unit in asset management, a group master linked to the product master,
Is stored,
The group identification data is data for specifying whether to aggregate the amount or inventory amount of the product specified by the product identification data in an aggregation unit of a product type unit or a product number unit,
The controller is
The inventory data and the detailed data associated with the product identification data included in the product master based on the product identification data and the stock data and the detail data including the amount and the stock amount of the product specified by the product identification data An amount aggregating means for aggregating the amount included in a unit of aggregation specified by the group identification data;
Based on the inventory data and the detail data, the inventory amount included in the inventory data and the detail data associated with the product identification data included in the product master is aggregated in an aggregation unit specified by the group identification data. Inventory quantity aggregation means,
According to a predetermined unit price calculation method, by dividing the aggregated amount by the aggregated inventory amount, unit price calculating means for calculating a product unit price in product type or product number unit,
Providing
A unit price calculation device characterized by the above. The predetermined unit price calculation method is a gross average method,
The unit price calculation apparatus according to claim 1. A unit price calculation method executed by an information processing apparatus including a control unit and a storage unit,
In the storage unit,
A product master containing product identification data;
Including group identification data for identifying an aggregation unit in asset management, a group master linked to the product master,
Is stored,
The group identification data is data for specifying whether to aggregate the amount or inventory amount of the product specified by the product identification data in an aggregation unit of a product type unit or a product number unit,
Executed by the control unit,
The inventory data and the detailed data associated with the product identification data included in the product master based on the product identification data and the stock data and the detail data including the amount and the stock amount of the product specified by the product identification data An amount summarizing step for consolidating the amount included in a unit of aggregation specified by the group identification data;
Based on the inventory data and the detail data, the inventory amount included in the inventory data and the detail data associated with the product identification data included in the product master is aggregated in an aggregation unit specified by the group identification data. Inventory quantity aggregation step to
According to a predetermined unit price calculation method, by dividing the aggregated amount by the aggregated inventory amount, a unit price calculation step of calculating a product unit price in product type or product number unit,
Including,
Unit price calculation method characterized by A unit price calculation program for causing an information processing apparatus including a control unit and a storage unit to execute,
In the storage unit,
A product master containing product identification data;
Including group identification data for identifying an aggregation unit in asset management, a group master linked to the product master,
Is stored,
The group identification data is data for specifying whether to aggregate the amount or inventory amount of the product specified by the product identification data in an aggregation unit of a product type unit or a product number unit,
For causing the control unit to execute,
The inventory data and the detailed data associated with the product identification data included in the product master based on the product identification data and the stock data and the detail data including the amount and the stock amount of the product specified by the product identification data An amount summarizing step for consolidating the amount included in a unit of aggregation specified by the group identification data;
Based on the inventory data and the detail data, the inventory amount included in the inventory data and the detail data associated with the product identification data included in the product master is aggregated in an aggregation unit specified by the group identification data. Inventory quantity aggregation step to
According to a predetermined unit price calculation method, by dividing the aggregated amount by the aggregated inventory amount, a unit price calculation step of calculating a product unit price in product type or product number unit,
Including,
Unit price calculation program characterized by

Images