JP7514636B2 - Transaction analysis device, transaction analysis method, and transaction analysis program - Google Patents

Description

The present invention relates to a transaction analysis device, a transaction analysis method, and a transaction analysis program.

For example, in materials industries (such as steel, non-ferrous metals, chemicals, textiles, petroleum, and wood industries) that supply materials to other industries, information on market trends (such as supply and demand balance and market unit prices) from newspapers and research organizations is often expressed in quantities of "KG, L." A conventional system for managing units of materials is disclosed in Patent Document 1.

JP 2002-351947 A

However, the above-mentioned Patent Document 1 does not state anything about objectively and quantitatively analyzing the company's material transactions.

The present invention has been made in consideration of the above, and aims to provide a transaction analysis device, a transaction analysis method, and a transaction analysis program that are capable of objectively and quantitatively analyzing a company's transactions regarding products.

In order to solve the above-mentioned problems and achieve the object, the present invention provides a transaction analysis device equipped with a memory unit and a control unit, the control unit being characterized by comprising: a voucher input means for inputting voucher data including the product being traded, a physical quantity for managing the number of items, a base quantity for managing by weight or volume, a unit price quantity for calculating the transaction amount, a transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price; and an analysis means for calculating an average transaction unit price for each product based on the voucher data by dividing the transaction amount by the base quantity.

Furthermore, according to one aspect of the present invention, the transactions may include receiving orders, placing orders, shipping, receiving goods, and purchasing.

According to one aspect of the present invention, the storage unit may include a master that registers products in association with managed cost quantities of physical quantities or base quantities, and the control unit may include an inventory amount calculation means that refers to the master, obtains the managed cost quantity using the product as a key, calculates an inventory valuation unit price for each product by dividing the transaction amount by the managed cost quantity, and calculates the inventory amount by multiplying the calculated inventory valuation unit price by the cost managed quantity.

According to one aspect of the present invention, the analysis means may calculate the average inventory unit price by dividing the inventory amount by the base quantity.

In order to solve the above-mentioned problems and achieve the object, the present invention provides a transaction analysis method executed by an information processing device having a memory unit and a control unit, characterized in that it includes a voucher input step executed by the control unit to input voucher data including the products to be traded, a physical quantity for managing the number of items, a base quantity for managing by weight or volume, a unit price quantity for calculating the transaction amount, the transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price, and an analysis step to calculate an average transaction unit price for each product based on the voucher data by dividing the transaction amount by the base quantity.

In order to solve the above-mentioned problems and achieve the object, the present invention provides a transaction analysis program to be executed by an information processing device having a memory unit and a control unit, characterized in that the program includes a voucher input step in the control unit to input voucher data including the product to be traded, a physical quantity for managing the number of items, a base quantity for managing by weight or volume, a unit price quantity for calculating the transaction amount, the transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price, and an analysis step to calculate an average transaction unit price for each product based on the voucher data by dividing the transaction amount by the base quantity.

In order to solve the above-mentioned problems and achieve the object, the present invention provides a transaction analysis program to be executed by an information processing device having a memory unit and a control unit, characterized in that the control unit causes a computer to execute a voucher input step of inputting voucher data including the product to be traded, a physical quantity for managing the number of items, a base quantity for managing by weight or volume, a unit price quantity for calculating the transaction amount, the transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price, and an analysis step of calculating an average transaction unit price for each product based on the voucher data by dividing the transaction amount by the base quantity.

The present invention has the effect of making it possible to objectively and quantitatively analyze a company's product transactions.

FIG. 1 is a block diagram showing an example of the configuration of a transaction analysis device according to the present embodiment. FIG. 2 is a diagram illustrating an example of the configuration of a master. FIG. 3 is a flowchart showing an example of the overall processing of the control unit of the transaction analysis device in this embodiment. FIG. 4 is a diagram showing sample data for explaining a specific example 1 of the processing of the transaction analysis device in this embodiment. FIG. 5 is a diagram showing sample data for explaining a second specific example of the processing of the transaction analysis device in this embodiment. FIG. 6 is a diagram showing sample data for explaining a specific example 3 of the processing of the transaction analysis device in this embodiment.

Below, an embodiment of a transaction analysis device, a transaction analysis method, and a transaction analysis program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the present embodiment.

[1. Overview]
For example, in materials industries (such as steel, non-ferrous metals, chemicals, textiles, petroleum, wood, etc.), which supply materials to other industries, information on market trends (such as supply and demand balance, market unit prices, etc.) provided by newspapers, research organizations, etc. is often expressed in quantities of "KG, L".

At this point, there are cases where you want to quantitatively and objectively analyze your company's trading situation. Specifically, for example, when objectively and quantitatively comparing your company's business situation with market trends and other companies, you may want to compare the total supply and demand volume and unit price in "KG, L". By comparing the total supply and demand volume and unit price in "KG, L" when objectively and quantitatively comparing your company's business situation with market trends and other companies, you can, for example, visualize your company's inventory information (sales, purchases, etc. as well) not only in terms of amount, but also whether the total volume and unit price you own are higher or lower than the market price, which can be used for management decisions. For example, you can use this information to make management decisions about whether to purchase the same material from another company when the average inventory valuation is 80 yen and the market price is 70 yen, or to use the inventory.

To achieve the above, it would be sufficient to simply manage one quantity, "KG, L", but a characteristic of the materials industry is that in addition to "KG, L", it is also necessary to "manage the number of pieces, etc.", in order to indicate the quantity of materials (inventory management).

In addition, in commercial transactions, there are cases where "KG, L" or "quantity management such as books or pieces" are used as the unit price quantity for the transaction, or "another unit price quantity: dimensions, size, etc." is used.

In this embodiment, the goods (materials) being traded are managed using three quantities: (1) a physical quantity for managing the number of items, (2) a base quantity for managing by weight (e.g., kg) or volume (e.g., L), and (3) a unit price quantity used to calculate the transaction amount, making it possible to objectively and quantitatively analyze one company's transactions. Specifically, two types of inventory quantities and one unit price quantity for buying and selling are prepared, and one of the inventory quantities is used as the base quantity.

In this specification, the terms "physical quantity" and "base quantity" are used to "manage the number of books, sheets, etc.", "weight (e.g., kg), volume (e.g., L)," and "another unit price quantity: dimensions, size" for calculating the transaction amount. In the following explanation, the base quantity weight is explained in "kg" and the volume in "L," but the present invention is not limited to these units and other units may be used.

By standardizing the base quantity to "KG" or "L", as mentioned above, the total volume for the entire company can be managed using the base quantity and compared with information on market trends (supply and demand balance). By calculating the average unit price based on the base quantity by "transaction amount ÷ base quantity", trading variations due to unit price quantities can be compared with information on market trends (market unit price).

Specifically, the management is carried out as follows.
(1) As inventory management quantity Generally, when handling materials (steel, wood, liquids), there are cases where two kinds of numerical values are required as physical inventory quantities, such as steel (100 pieces, 1,000 kg), wood (100 pieces, 1,000 m3), and liquid (100 cans, 1,000 L). In this case, one quantity is used as the standard, and items that are calculated can be managed with one quantity, but when managing by actual weight, volume, etc. (actual capacity), two kinds of quantities are required as a database structure. Therefore, in this embodiment, both the base quantities of "KG, L" and the physical quantities for "quantity management of books, sheets, etc." are managed.

(2) As sales quantity and purchase quantity (unit price quantity) Generally, when dealing with materials (steel, wood, liquid), there are multiple physical quantities such as steel (100 pieces, 1,000 kg), wood (100 pieces, 1,000 m3), and liquid (100 cans, 1,000 L) (there are two types of quantities to be managed). There are cases where the amount needs to be calculated for different quantities such as the unit price per ton (kg), the unit price per meter, size, dimensions, and set as the unit price when selling (purchasing) (because the unit price quantity differs depending on the transaction unit). In this case, the sales quantity and purchase quantity are required as a database structure. Therefore, in this embodiment, the unit price quantity of "different unit price quantity: dimensions, size" is managed as a separate item.

(3) As inventory management quantity Generally, when handling materials (steel, wood, liquids), there are two types of physical quantities, such as steel (100 pieces, 1,000 kg), wood (100 pieces, 1,000 m3), and liquid (100 cans, 1,000 L), and the unit price at the time of sale and purchase differs depending on the transaction. In this case, the quantity unit for calculating the inventory evaluation unit price is master-controlled for each item as either "KG, M3" or "number management such as pieces, sheets, etc."

(4) As a quantity to quantitatively compare business conditions with market trends When dealing with materials (steel, wood, liquids), there are generally quantities such as steel (100 units, 1,000 kg), wood (100 units, 1,000 m3), and liquid (100 cans, 1,000 L). When only monetary amounts are required to grasp the business conditions of the company as a whole, general financial accounting and management accounting are possible. However, since the unit price of materials fluctuates greatly, it is necessary to grasp the absolute amount of the company's transactions and the market price, regardless of the transaction amount at any given time. Market price information is generally expressed in Kg and L, so information on "KG and L" is necessary to grasp the business conditions of the company.

2. Configuration
The configuration of a transaction analysis device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the transaction analysis device 100.

The transaction analysis device 100 is a commercially available desktop personal computer. Note that the transaction analysis device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

As shown in FIG. 1, the transaction analysis device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the transaction analysis device 100 is connected to each other so as to be able to communicate with each other via any communication path.

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

The input/output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. In addition, the act of a user displaying on the screen of the monitor 114 and operating the input device 112 may be referred to as "user operation via a UI."

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

The storage unit 106 stores the master 106a and the data file 106b. FIG. 2 is a diagram showing an example of the configuration of the master 106a. The operator can check the contents of the data stored in the master 106a and the data file 106b by displaying them on the screen of the monitor 114, and the data can be edited, such as by inputting, changing, or adding, via the input device 112.

Master 106a is a master for registering cost control quantities (base quantities or physical quantities) for calculating inventory valuation unit prices for each item. As shown in FIG. 2, master 106a can be configured as a table or the like in which item numbers are associated with cost control quantities for calculating inventory valuation unit prices. In the example shown in FIG. 2, the first line has item number "Item No. A" and cost control quantity "Base quantity", and the second line has item number "Item No. B" and cost control quantity "Physical quantity". Inventory valuation unit prices are calculated by dividing the transaction amount by the cost control quantity.

Data file 106b is a file for storing various data such as invoice data, analysis data, etc.

The control unit 102 is a CPU or the like that provides overall control of the transaction analysis device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of functional concept, the control unit 102 includes a slip input unit 102a, an analysis unit 102b, an inventory amount calculation unit 102c, a screen display control unit 102d, and a master maintenance unit 102e.

The voucher input unit 102a, for example, inputs voucher data including the product being traded (e.g., product name, product code, and/or product number (item number)), the physical quantity for managing the number of items, the base quantity for managing in KG or L, the unit price, the transaction unit price, and the transaction amount calculated by multiplying the unit price by the transaction unit price, in response to operations by an operator or the like on a voucher input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106b. Here, the transactions may include various transactions such as receiving orders, placing orders, shipping, receiving goods, and purchasing.

The analysis unit 102b is used to perform purchasing analysis, sales analysis, cost of sales analysis, sales profit analysis, inventory analysis, etc. For example, based on invoice data, it calculates the average transaction price for each product by dividing the transaction amount by the base quantity, and also calculates the average inventory price by dividing the inventory amount by the base quantity.

The inventory amount calculation unit 102c refers to the master 106a, obtains the managed cost quantity using the product as a key, calculates the inventory valuation unit price for each product by dividing the transaction amount by the managed cost quantity, and calculates the inventory amount by multiplying the calculated inventory valuation unit price by the cost managed quantity.

The screen display control unit 102d controls the display of various screens and their inputs displayed on the monitor 114.

The master maintenance unit 102e performs editing such as inputting, changing, and adding data to the master 106a in response to, for example, the operator's operations on a master maintenance screen (not shown) displayed on the monitor 114.

3. Specific examples of processing
A specific example of the processing of the transaction analysis device 100 according to this embodiment will be described in detail with reference to Figures 1 to 6. Figure 3 is a flowchart showing an example of the overall processing of the control unit 102 of the transaction analysis device 100 according to this embodiment.

With reference to FIG. 3, the flow of the overall processing of the control unit 102 of the transaction analysis device 100 in this embodiment will be outlined. In FIG. 3, the slip input unit 102a executes a slip input process (step S1). Specifically, in the slip input process, the slip input unit 102a inputs slip data including the product to be traded (e.g., product name, product code, and/or product number (product number)), the physical quantity for managing the number of items, the base quantity for managing in KG or L, the unit price, the transaction unit price, and the transaction amount calculated by multiplying the unit price by the transaction unit price, in response to an operation by an operator or the like on a slip input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106b. Here, the transaction may include various transactions such as receiving an order, placing an order, shipping, receiving an item, and purchasing an item. In addition, the slip may include various slips such as an order slip, an order slip, a shipping slip, a receiving slip, and a purchasing slip.

The inventory amount calculation unit 102c executes the inventory amount calculation process (step S2). Specifically, in the inventory amount calculation process, the inventory amount calculation unit 102c refers to the master 106a, acquires the managed cost quantity using the product as a key, calculates the inventory valuation unit price for each product by dividing the transaction amount by the managed cost quantity, and calculates the inventory amount by multiplying the calculated inventory valuation unit price by the cost managed quantity.

The analysis unit 102b executes the analysis process (step S3). Specifically, in the analysis process, the analysis unit 102b performs purchase analysis, sales analysis, cost of sales analysis, sales profit analysis, inventory analysis, etc., and calculates, for example, for each product, the average transaction price based on the transaction amount divided by the base quantity, and the average inventory price based on the inventory amount divided by the base quantity.

Fig. 4 is a diagram showing sample data for explaining specific example 1 of the processing of transaction analysis device 100 in this embodiment. Fig. 5 is a diagram showing sample data for explaining specific example 2 of the processing of transaction analysis device 100 in this embodiment. Fig. 6 is a diagram showing sample data for explaining specific example 3 of the processing of transaction analysis device 100 in this embodiment.
In the following explanation, all monetary amounts will be expressed in yen.

(Specific Example 1)
A specific example of the process of the control unit 102 of the transaction analysis device 100 in this embodiment will be described with reference to Fig. 4. In specific example 1, the case of purchasing will be described. Note that the same process can be used for ordering.

Figure 4 (A) shows an example of data in master 106a. The example of data in master 106a shown in Figure 2 (A) is the same as that in Figure 2.

The voucher input unit 102a inputs, for example, purchase voucher data as shown in FIG. 4(B). In the example of purchase voucher data shown in FIG. 4(B), the first line has the processing category "Purchase", the accounting date "2019/05/01", the product number "A product number", the physical quantity "10 sheets", the base quantity "5,000 kg", the unit price quantity "5 tons", the purchase price "10,000", and the purchase amount "50,000". The second line has the processing category "Purchase", the accounting date "2019/05/05", the product number "B product number", the physical quantity "5 pieces", the base quantity "3,000 kg", the unit price quantity "3 m", the purchase price "50,000", and the purchase amount "150,000". The third line has the processing category "Purchase", accounting date "2019/05/10", product number "A product number", physical quantity "20 pieces", base quantity "8,000 kg", unit price quantity "20 pieces", purchase price "2,000", and purchase amount "40,000".

The inventory amount calculation unit 102c calculates the inventory valuation unit price as shown in FIG. 4(C). Here, the monthly total average and the inventory amount at the beginning of the month are set to "0". In the case of item number A, the inventory amount calculation unit 102c uses item number A as a key to obtain the "base quantity" as the cost management quantity from master 106a shown in FIG. 4(A), and calculates the purchase amount "90,000 (=50,000 + 40,000)" ÷ base quantity "13,000" = inventory valuation unit price "6.923" based on the purchase slip data. In the case of item number B, the inventory amount calculation unit 102c uses item number B as a key to obtain the physical quantity as the cost management quantity from master 106a shown in FIG. 4(A), and calculates the purchase amount "15,000" ÷ physical quantity "5" = inventory valuation unit price "3,000" based on the purchase slip data.

The analysis unit 102b performs purchase analysis. FIG. 4(D) is a diagram showing an example of purchase analysis. Through purchase analysis, the variation in transaction unit price due to unit price quantity is calculated by "purchase amount ÷ base quantity" to obtain the average purchase price due to the base quantity, which makes it possible to compare with information on market trends (market unit price).

In FIG. 4 (D), the analysis unit 102b calculates, based on the purchase slip data, for item number A, the purchase amount "90,000" ÷ base quantity "13,000 kg" = average purchase price "6.923". For item number B, the analysis unit 102b calculates the purchase amount "150,000" ÷ base quantity "3,000 kg" = average purchase price "50". In this way, by unifying the base quantity to "KG" or "L", the total volume for the entire company can be managed using the base quantity and compared with information on market trends (supply and demand balance).

(Specific Example 2)
5, a second specific example of the process of the control unit 102 of the transaction analysis device 100 in this embodiment will be described. In the second specific example, the case of sales will be described. Note that the same process can be used for receiving orders.

The slip input unit 102a inputs, for example, sales slip data as shown in FIG. 5(A). In the example of sales slip data shown in FIG. 5(A), the first line contains the processing category "Sales", the posting date "2019/05/11", the product number "Product number A", the physical quantity "5 pieces", the base quantity "2.500 kg", the unit price quantity "5 pieces", the sales price "20,000", the sales amount "100,000", the unit cost price "6.923", the cost amount "17,307", and the gross profit amount "82,693".

The second line has the processing category "Sales", accounting date "2019/05/20", product number "B product number", physical quantity "3 units", base quantity "1,800 kg", unit price quantity "1.8 tons", sales price "100,000", sales amount "180,000", cost price "3000", cost amount "90,000", and gross profit amount "90,000".

The third line has the following information: processing category "Sales", accounting date "2019/05/21", product number "A product number", physical quantity "8 pieces", base quantity "3,200 kg", unit price quantity "5 m", sales price "10,000", sales amount "50,000", cost price "6.923", cost amount "22,154", and gross profit amount "27,846".

The analysis unit 102b performs sales analysis, cost of sales analysis, and gross profit analysis.
This is a diagram showing an example of the results of sales analysis, sales cost analysis, and gross profit analysis. In the sales analysis, the variation in sales unit price due to unit price quantity is calculated by "sales amount ÷ base quantity" to obtain the average sales unit price by base quantity, which makes it possible to compare with information on market trends (market unit price).

Based on the sales slip data, for item number A, the analysis unit 102b calculates the sales amount "150,000" ÷ base quantity "5,700 kg" = average sales price "26.316". For item number B, the analysis unit 102b calculates the sales amount "180,000" ÷ base quantity "1,800 kg" = average sales price "100". By standardizing the base quantity to "Kg" or "L", the total volume for the entire company can be managed using the base quantity and compared with information on market trends (supply and demand balance).

(Specific Example 3)
Specific example 3 of the process of the control unit 102 of the transaction analysis device 100 in this embodiment will be described with reference to Fig. 6. In specific example 3, an example of inventory of items purchased in specific example 1 of Fig. 4 will be described. The inventory evaluation unit price uses the value calculated in Fig. 4(C) with reference to the master 106a in Fig. 4(A).

The inventory amount calculation unit 102c calculates the inventory amount for each item number by multiplying the inventory valuation unit price by the cost management quantity.

For example, in FIG. 6(A), the inventory for item A is physical quantity "17 pieces," base quantity "11.300 kg," cost management quantity "11.300 kg," and inventory valuation unit price "6.923." The inventory amount calculation unit 102c calculates the inventory amount "78,230" for item A by multiplying the inventory valuation unit price "6.923" by the cost management quantity "11.300 kg." Also, for item B, the physical quantity is "2 units," base quantity "1.200 kg," cost management quantity "2 units," and inventory valuation unit price "3.000." The inventory amount calculation unit 102c calculates the inventory amount "6,000" for item B by multiplying the inventory valuation unit price "3.000" by the cost management quantity "2 units."

The analysis unit 102b performs an inventory analysis. FIG. 6(B) is a diagram showing an example of the results of the inventory analysis. In the inventory analysis, the average inventory unit price is calculated by dividing the wholesale amount by the base quantity. In FIG. 6(B), the analysis unit 102b calculates an average inventory unit price of "6.923" for item number A by dividing the wholesale amount by "78,230" and the base quantity by "11.300 kg". The analysis unit 102b also calculates an average inventory unit price of "5" for item number B by dividing the wholesale amount by "6,000" and the base quantity by "1.200 kg".

In this way, by managing both the physical quantity and base quantity and calculating the average unit price of inventory based on the base quantity by "inventory amount ÷ base quantity", it becomes possible to compare with information on market trends (market price). Also, by standardizing the base quantity to "kg" or "L", the total amount for the entire company can be managed using the base quantity, making it possible to compare with information on market trends (supply and demand balance).

As described above, according to this embodiment, the system is equipped with a voucher input unit 102a that inputs voucher data including the product being traded, the physical quantity for managing the number of items, the base quantity for managing by weight or volume, the unit price quantity for calculating the transaction amount, the transaction unit price, and the transaction amount calculated by multiplying the unit price quantity by the transaction unit price, and an analysis unit 102b that calculates the average transaction unit price for each product based on the voucher data by dividing the transaction amount by the base quantity, making it possible to objectively and quantitatively analyze the company's transactions regarding products.

4. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using a known method.

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

Furthermore, with regard to the transaction analysis 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, the processing functions of the transaction analysis device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the transaction analysis device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the transaction analysis device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit 106 are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

The transaction analysis device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The transaction analysis device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

100 Transaction analysis device
102 control unit
102a slip input section
102b Analysis section
102c Inventory amount calculation unit
102d Screen display control unit
102e Master Maintenance Department
104 Communication interface unit
106 Memory unit
106a Master
106b Data file
108 Input/Output Interface Unit
112 Input device
114 Output device 200 Server 300 Network

Claims (6)

A transaction analysis device including a memory unit and a control unit,
The control unit is
a slip input means for inputting slip data including, for each traded commodity, a physical quantity for managing the number of items, a base quantity for managing the items by weight or volume, a unit price quantity for calculating the transaction amount, a transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price, in order to manage the traded commodities by three quantities;
an analysis means for calculating an average transaction price for each product by dividing the transaction amount by the base quantity based on the slip data;
A transaction analysis device comprising: The transaction analysis device according to claim 1, characterized in that the transactions include receiving orders, placing orders, shipping, receiving goods, and purchasing. The storage unit is
A master is provided in which the product and the physical quantity or base quantity of the managed cost quantity are associated and registered,
The control unit is
The transaction analysis device according to claim 1 or 2, further comprising an inventory amount calculation means for referencing the master, acquiring a managed cost quantity using a product as a key, calculating an inventory valuation unit price for each product by dividing the transaction amount by the managed cost quantity, and calculating the inventory amount by multiplying the calculated inventory valuation unit price by the cost managed quantity. The transaction analysis device according to claim 3, characterized in that the analysis means calculates the average inventory unit price by dividing the inventory amount by the base quantity. A transaction analysis method executed by an information processing device having a storage unit and a control unit,
Executed by the control unit,
a slip input step of inputting slip data including, for each traded commodity, a physical quantity for managing the number of items, a base quantity for managing the items by weight or volume, a unit price quantity for calculating the transaction amount, a transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price, in order to manage the traded commodities in three quantities;
an analysis step of calculating an average transaction price for each product based on the slip data by dividing the transaction amount by the base quantity;
A transaction analysis method comprising: A transaction analysis program to be executed by an information processing device having a storage unit and a control unit,
The control unit ,
a slip input step of inputting slip data including, for each traded commodity, a physical quantity for managing the number of items, a base quantity for managing the items by weight or volume, a unit price quantity for calculating the transaction amount, a transaction unit price, and a transaction amount calculated by multiplying the unit price quantity by the transaction unit price, in order to manage the traded commodities in three quantities;
an analysis step of calculating an average transaction price for each product based on the slip data by dividing the transaction amount by the base quantity;
A transaction analysis program comprising:

Images