JP7025854B2 - Gross profit calculator, gross profit calculation method and gross profit calculation program - Google Patents

Description

The present invention relates to a gross profit calculation unit, a gross profit calculation method and a gross profit calculation program.

In Patent Document 1, when reselling foreign currency purchased goods, the purchase cost difference linked to the exchange fluctuation suitable for managing at least one of the fluctuation value of the purchase cost difference and the gross profit amount due to the exchange fluctuation of the market is described. And the management method of the gross profit amount is disclosed (see paragraph 0001, etc.).

Japanese Unexamined Patent Publication No. 2006-2231315

In the field of managing the gross profit amount of sales, it is difficult to properly evaluate the gross profit on an individual transaction basis because the inventory valuation unit price is calculated when the same product is traded multiple times in the past. Met. In particular, in an industry that handles high-priced products such as machinery, if the sales representative in charge of each individual transaction is different, the gross profit in each individual transaction unit has a large effect on the evaluation of the sales representative, so it is in individual transaction units. There was a request to accurately grasp the gross profit of the company, but it could not be realized.

The present invention has been made in view of the above, and by linking the purchase data and the sales data with the transaction identification data for each product, the purchase unit price included in the purchase data is sold to the sales data. It provides a gross profit calculator, a gross profit calculation method, and a gross profit calculation program that can automatically calculate the gross profit in individual transaction units for commodities by setting it as the cost unit price.

In order to solve the above-mentioned problems and achieve the object, the gross profit calculation device according to the present invention is a gross profit calculation device including a control unit and a storage unit, and the storage unit identifies transactions for each product. The purchase data including the product-specific transaction identification data and the purchase unit price, and the sales data including the product-specific transaction identification data, the sales amount, and the sales quantity are stored, and the control unit stores the product. The purchase unit price included in the purchase data is added to the sales data including the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data, and the sales cost, which is the unit price of the sales cost amount. Based on the setting means set as the unit price and the sales data after the purchase unit price is set as the sales cost unit price by the setting means, the sales amount included in the sales data is included in the sales data. It is characterized by comprising a calculation means for calculating a gross profit in an individual transaction unit for a product by subtracting an amount obtained by multiplying the sales quantity to the sales cost unit price included in the sales data.

Further, in the gross profit calculation device according to the present invention, the calculation means divides the sales amount included in the sales data by the sales unit price included in the sales data, so that the sales quantity included in the sales data is included. It is characterized by calculating.

Further, in the gross profit calculation device according to the present invention, the control unit further provides a generation means for generating the transaction identification data for each product by combining the order number and the line number in the order details specified by the order number. It is characterized by being prepared.

Further, the gross profit calculation device according to the present invention is characterized in that the product is a machine.

Further, the gross profit calculation method according to the present invention is a gross profit calculation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit is used for each product to identify transactions. The purchase data including the transaction identification data and the purchase unit price, and the sales data including the product-specific transaction identification data, the sales amount, and the sales quantity are stored, and the product is executed by the control unit. The purchase unit price included in the purchase data is added to the sales data including the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data as the sales cost unit price, which is the unit price of the sales cost amount. Based on the setting step to be set and the sales data after the purchase unit price is set as the sales cost unit price by the setting step, the sales amount included in the sales data is included in the sales data. It is characterized by including a calculation step of calculating a gross profit for each individual transaction unit for a product by subtracting an amount obtained by multiplying the sales quantity by the sales cost unit price included in the sales data.

Further, the gross profit calculation program according to the present invention is a gross profit calculation program for being executed by an information processing apparatus including a control unit and a storage unit, and the storage unit is a product for identifying a transaction for each product. Purchase data including the separate transaction identification data and the purchase unit price, and sales data including the product-specific transaction identification data, the sales amount, and the sales quantity are stored, and the control unit can execute the purchase data. The purchase unit price included in the purchase data is added to the sales data including the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data, and the sales cost, which is the unit price of the sales cost amount. Based on the setting step to be set as the unit price and the sales data after the purchase unit price is set as the sales cost unit price by the setting step, the sales amount included in the sales data is included in the sales data. It is characterized by including a calculation step of calculating a gross profit in an individual transaction unit for a product by subtracting an amount obtained by multiplying the sales quantity by the sales cost unit price included in the sales data.

According to the present invention, by associating the purchase data and the sales data with the transaction identification data for each product, the purchase unit price included in the purchase data is set in the sales data as the cost of sales unit price. It has the effect of automatically calculating the gross profit for each individual transaction for a product.

FIG. 1 is a block diagram showing an example of the configuration of the gross profit calculation device. FIG. 2 is a diagram showing an example of configuration of each data and an example of data processing in the case where data input is performed in the order of order registration, purchase recording, and sales recording. FIG. 3 is a diagram showing an example of configuration of each data and an example of data processing in the case where data input is performed in the order of order registration, sales recording, and purchase recording. FIG. 4 is a diagram showing an example of an order input screen (upper figure) and an order detail input screen (lower figure) at the time of new registration of a product. FIG. 5 is a diagram showing an example of an order input screen (upper figure) and an order breakdown input screen (lower figure) at the time of making a correction call for a product. FIG. 6 is a diagram showing an example of the relationship of each data.

Hereinafter, embodiments of the gross profit calculation device, the gross profit calculation method, and the gross profit 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 past, the cost of sales was determined manually based on the inventory valuation amount and standard cost amount, so it was difficult to manage individual costs for each transaction. In order to manage individual costs for each transaction, it was necessary to operate by manual recording and specify the cost of sales each time.

Therefore, in the present embodiment, it is possible to manage individual costs for each transaction by automatically setting the purchase unit price having the same order number as the cost of sales at the time of recording sales at the time of ordering transaction. did. By being able to manage individual costs for each transaction, accurate gross profit evaluation is possible. Specifically, in the present embodiment, by using the transaction number management function, it is possible to link the sales data and the purchase data of the same order slip (note that, at the time of order registration, the transaction number is used. "Order No. + Row No." is automatically set, and in the case of Kurade order, the fixed value set in the master is set because cost linking is not possible). As a result, the purchase unit price can be automatically set as the cost of sales in the sales recording.

In this embodiment, in order to accurately grasp the gross profit in each individual transaction unit, the purchase unit price is set as the cost of sales unit price by linking with the same ordering number at the time of ordering transaction (note that direct delivery). In that case, it is not included in the evaluation unit price, so it is not considered). Further, in the present embodiment, the transaction number management function is used to link the same order slips. Then, in the present embodiment, all products are managed by the transaction number. The inventory valuation calculation category is set for each transaction number and each product. Further, the present embodiment has the following features 1 to 7.

1. 1. At the time of order registration, "order No. + row No." is automatically set as the transaction number. For Kurade orders, set a fixed value set separately in the master. Since it is necessary to manage transaction numbers for all products, a fixed value is set for Kurairi inventory as well. The inventory and the inventory in the warehouse in the ordering transaction can be determined by outputting the inventory list by transaction number.

2. 2. The transaction number can be set when the operator inputs (manually) the transaction number on the item registration screen, or when the transaction number is automatically set for the item whose transaction number is empty at the time of slip transaction (when the transaction number has already been entered manually). The transaction number is not overwritten) and exists.

3. 3. If the slip is modified after the order is registered, the transaction number of the received slip cannot be changed. If the line number of the order details fluctuates due to the addition of the details line or the deletion of the details line, the transaction number is automatically set.

4. The automatic set of transaction numbers supports only order entry and order entry (does not consider single recording in sales entry). This is because if the transaction number set is performed in the order input and the order input, it is not necessary to consider the transaction number in the subsequent processing. At the time of sales input, the purchase unit price of the recorded purchase data is set as the cost of sales unit price.

5. If sales are recorded in a state where purchases have not been completed, the purchase unit price cannot be set as the cost of sales unit price at the time of sales recording because the purchase unit price has not been determined. For this reason, if sales are recorded in a state where purchases have not been recorded, the cost of sales is replaced at the timing when the cost calculation process is performed.

6. Managing the transaction numbers of all products raises the issue of whether there are any administrative problems. This problem can be solved by the following measures. That is, there is no transaction number setting function for Morokuchi inventory (inventory without inventory management). In addition, when a profit price and interest rate (sales amount = 0, cost = yes) occur, or when the cost fluctuates, it is necessary to change the product code.

7. When moving inventory, the transaction number shall be specified manually. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the gross profit 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 gross profit calculation device 100.

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

As shown in FIG. 1, the gross profit 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 part of the gross profit calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the gross profit 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 gross profit calculation device 100 and the server 200 so as to be able to communicate 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 order detail data 106a and order detail data 106b, order detail data 106c and order detail data 106d, purchase detail data 106e and purchase detail data 106f as purchase data, and sales as sales data. It includes detailed data 106g and detailed sales data 106h. Of these, the order detail data 106a, the order detail data 106b, the order detail data 106c, and the order detail data 106d are arbitrary components and may or may not be included in the storage unit 106.

The gross profit calculation device 100 according to the present embodiment is more effective when the product for which the gross profit calculation is a target is a high-priced product (for example, a machine). This is because when multiple high-priced same products are traded, the gross profit of each individual transaction becomes high, and as a result, the evaluation of the sales person determined based on the gross profit of each individual transaction is greatly affected. This is due to the fact that the gross profit on transactions of high-priced commodities is strongly requested to obtain accurate values on an individual transaction basis. In the present embodiment, the plurality of transactions includes the concept that the business partners are different, and also includes the concept that the business partners are the same but the number of transactions is different.

Hereinafter, a configuration example of each data will be described in detail with reference to FIG. 2 and the like. FIG. 2 is a diagram showing an example of configuration of each data and an example of data processing in the case where data input is performed in the order of order registration, purchase recording, and sales recording.

As shown in FIG. 2, the order details data 106a includes, for example, an order number (order No.), a line number (order line No.) in the order details specified by the order number, an order number (order No.), and product identification data. Includes (product code), order quantity (quantity), order amount, etc.

As shown in FIG. 2, the order detail data 106b includes, for example, an order number (order No.), a line number (order line No.) in the order details specified by the order number, detailed SEQ, and product identification data (product code). , Includes transaction identification data (transaction number) by product, order amount, etc.

The nature of the transaction identification data (transaction number) for each product will be described with reference to FIG. The transaction identification data (transaction number) for each product is data for identifying a transaction for each product. For example, as shown in the order detail data 106b of FIG. 2, a product having the product code “SHO01” and a product having the product code “SHO02” can be identified by assigning different transaction numbers. Further, although not shown, if the same product is a different transaction, a different transaction number can be assigned to identify which transaction.

The generation of transaction identification data (transaction number) for each product will be described with reference to FIG. FIG. 4 is a diagram showing an example of an order input screen (upper figure) and an order detail input screen (lower figure) at the time of new registration of a product. When registering a new product, one item is registered with transaction category = ordering. Since the transaction number has not been assigned at the time of new registration of the product, the transaction number can be generated as follows, for example, by the generation unit 102c. That is, the generation unit 102c has the order number (order No.) specified on the order input screen at the time of new registration of the product shown in the upper figure of FIG. 4 and the line number (order line No.) in the order details specified by the order number. ) To generate transaction identification data (transaction number) for each product. For example, when the order No. is JU0001 and the order line No. is 001, the generation unit 102c combines these information to generate the transaction number "JU0001-001". As described in this paragraph, the transaction identification data for each product is preferably data having a transaction number that is a combination of the order No. and the order line No. However, as long as the transaction can be identified for each product, any data can be used. May be. In this way, at the time of order registration, "order No. + row No." is automatically set as the transaction number.

The modification of the transaction identification data (transaction number) for each product will be described with reference to FIG. FIG. 5 is a diagram showing an example of an order input screen (upper figure) and an order breakdown input screen (lower figure) at the time of making a correction call for a product. As shown in the transaction number surrounded by a square in FIG. 5, when the product registration data is called, "order No. + order line No." is set as the generated transaction number. Here, the order line No. may change due to addition and deletion of line numbers in the order details. In this case, the transaction number is automatically corrected according to the change in the order line number. For example, when the order line number changes from 001 to 002 for a product with a transaction number "JU0001-001", the transaction number is automatically corrected to "JU0001-002".

As shown in FIG. 2, the order detail data 106c includes, for example, an order number (order No.), a line number (order line No.) in the order details specified by the order number, product identification data (product code), and an order quantity. Includes (quantity), order unit price, order amount, etc.

As shown in FIG. 2, the order detail data 106d includes, for example, an order number (order No.), a line number (order line No.) in the order details specified by the order number, detailed SEQ, and product identification data (product code). , Includes transaction identification data (transaction number) by product, order quantity (quantity), order unit price, order amount, etc. Here, since the order detail data 106a and the order detail data 106c are associated with each other through the order No., the transaction number in the order detail data 106b is automatically set as the transaction number in the order detail data 106d.

Most of the information of the purchase detail data 106e and the purchase detail data 106f described below may be automatically set. That is, when the operator selects (not shown) the details of the purchased product from the order details data 106c and the order details data 106d, the information of the selected details is inherited and the purchase is made. It is automatically set as the information of the detail data 106e and the purchase detail data 106f.

As shown in FIG. 2, the purchase details data 106e includes, for example, a purchase number (purchase No.), a line number (purchase line No.) in the purchase details specified by the purchase number, and an order number (order No.). ), The line number (order line No.), product identification data (product code), purchase quantity (quantity), purchase unit price, purchase amount, etc. in the order details specified by the order number. Of these, the information other than the purchase No. and the purchase line No. is the information automatically set by being inherited from the order detail data 106c and the order detail data 106d by the method described in the preceding paragraph.

As shown in FIG. 2, the purchase details data 106f includes, for example, a purchase number (purchase No.), a line number (purchase line No.) in the purchase details specified by the purchase number, a detailed SEQ, and an order number. (Order No.), line number (order line No.) in the order details specified by the order number, product identification data (product code), transaction identification data by product (transaction number), purchase quantity (quantity), purchase Includes unit price and purchase amount. Of these, other than the purchase No. and the purchase line No., the information including the transaction number is automatically set by being inherited from the order detail data 106c and the order detail data 106d by the method described in the preceding paragraph. In this way, the same number as the transaction number included in the order information is automatically set as the transaction number at the time of purchase recording.

Most of the information of the sales detail data 106g and the sales detail data 106h described below may be automatically set. That is, when the operator selects the details of the sold products on the screen (not shown) from the order details data 106a and the order details data 106b, the information of the selected details is inherited and the sales details data 106g. And it is automatically set as sales detail data 106h.

As shown in FIG. 2, the sales detail data 106g includes, for example, a sales number (sales No.), a row number (sales row No.) in the sales details specified by the sales number, an order number (order No.), and the order number. Includes row number (order row No.), product identification data (product code), sales quantity (quantity), sales amount, cost of sales unit price, cost of sales amount, gross profit amount, etc. in the order details specified in. Of these, except for the sales No., the sales line No., the cost of sales unit price, the cost of sales amount, and the gross profit amount, they were automatically set by being inherited from the order detail data 106a and the order detail data 106b by the method described in the previous paragraph. Information.

As shown in FIG. 2, the detailed sales data 106h includes, for example, a sales number (sales No.), a line number (sales line No.) in the sales statement specified by the sales number, an order number (order No.), and the order number. Includes row number (order row No.), detailed SEQ, product identification data (product code), transaction identification data by product (transaction number), sales amount, cost of sales unit price, etc. in the order details specified in. Of these, except for sales No., sales line No., sales amount, and cost of sales unit price, including the transaction number, they are automatically set by being inherited from the order details data 106a and the order details data 106b by the method explained in the previous paragraph. Information.

Here, the cost of sales unit price is the unit price of the cost of sales amount. Normally, the cost of sales unit price is equal to the unit purchase price, so the setting unit 102a automatically sets the unit purchase price included in the purchase data as the unit cost of sales price in the sales data (details of this process are: It will be explained in the following [3. Specific example of processing]).

Then, the calculation unit 102b describes the product by the formula of sales amount of sales data- (sales quantity of sales data x cost of sales unit price of sales data) based on the sales data after the unit price of sales cost is set. Calculate the gross profit for each individual transaction unit (details of this processing will also be explained in [3. Specific example of processing] below).

In this way, by automatically setting the same number as the transaction number included in the order information as the transaction number at the time of recording sales, the purchase unit price can be automatically set as the cost of sales unit price, so it is individual for each business partner. Cost control is possible. As a result, it is possible to accurately grasp the gross profit for each business partner.

The configuration example of each data and the relevance of each data in the present embodiment may be as shown in FIG. 2 as described above, but may be as shown in FIG. 6, for example.

The control unit 102 is a CPU or the like that comprehensively controls the gross profit 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. Execute.

The control unit 102 functionally conceptually includes (1) the purchase unit price included in the purchase data, and the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data. The setting unit 102a as a setting means for setting the unit price of the cost of sales amount in the sales data, and (2) the sales after the purchase unit price is set as the cost of sales unit price by the setting means. An individual transaction unit related to a product by subtracting the amount obtained by multiplying the sales quantity included in the sales data by the cost of sales unit price included in the sales data from the sales amount included in the sales data based on the data. A generation means for generating the transaction identification data for each product by combining the calculation unit 102b as a calculation means for calculating the cost of goods sold in (3) and (3) the order number and the row number in the order details specified by the order number. The generation unit 102c and the like are provided. Of these, the generation unit 102c is an arbitrary component, and may or may not be included in the control unit 102. 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.

[3-1. Gross profit calculation when data is entered in the order of order registration, purchase recording, and sales recording]
First, the gross profit calculation in the case where data is input in the order of order registration, purchase recording, and sales recording will be described in detail with reference to FIG. Specifically, how to calculate the gross profit amount of 400 yen for the product of the product code “SHO01” in FIG. 2 will be described.

First, as shown in FIG. 2, the setting unit 102a sets the purchase unit price (300 yen) included in the purchase detail data 106f for the product with the product code “SHO01” and the transaction number included in the purchase detail data 106f. The cost of sales unit price is set to 300 yen in the detailed sales data 106h including the same transaction number as (JU0001-001). Here, since the sales detail data 106g and the sales detail data 106h are linked by the sales No. and the like as shown in FIG. 2, when the purchase unit price is automatically set in the sales detail data 106h, the sales detail data 106g The purchase unit price is also set automatically.

Next, as shown in FIG. 2, the calculation unit 102b is based on the sales detail data 106 g after the purchase unit price (300 yen) is set as the cost of sales unit price of 300 yen by the setting unit 102a, and the sales detail data 106 g. By subtracting the amount of sales (1,000 yen) included in the sales details data by multiplying the sales quantity (2 pieces) included in the sales details data 106g by the cost of sales unit price (300 yen) included in the sales details data 106g. The calculation is 1,000 yen- (2 pieces x 300 yen), and the gross profit of the product with the product code "SHO01" is calculated as 400 yen.

Here, the sales quantity (two pieces) included in the sales detail data 106g may be input by the operator, but may be obtained by calculation by the calculation unit 102b as follows. That is, as shown in FIG. 2, the calculation unit 102b determines that the sales amount (1,000 yen) included in the sales detail data 106g is the sales unit price (not shown, but 500 yen) included in the sales detail data 106g. By dividing by), the calculation of 1,000 yen / 500 yen may be performed, and the sales quantity of the product code “SHO01” may be calculated as two.

[3-2. Gross profit calculation when data is entered in the order of order registration, sales recording, and purchase recording]
Next, the gross profit calculation in the case where data is input in the order of order registration, sales recording, and purchase recording (when sales are recorded in a state where the purchase is not completed) will be described in detail with reference to FIG. do.

In this example, the purchase has not been recorded yet at the time of recording the sales. Therefore, as shown by hatching in the detailed sales data 106h of "2. Record sales by inputting sales" in FIG. 3, the transaction number at the time of recording sales is the same as the transaction number included in the order information. Although it is automatically set, 0 yen is set as the unit cost of sales because the purchase has not been recorded.

Then, at the timing when the purchase recording is completed and the cost accounting process is executed, as shown in the sales detail data 106g after the cost accounting process in FIG. 3, the gross profit for the product of the product code “SHO01” is 400 yen. Is calculated. Since the specific calculation method is the same as the item of [3-1] above, the description thereof will be omitted.

In this way, by performing the cost calculation process, the cost of sales information is replaced based on the linked information of the transaction number, and the purchase unit price can be automatically set as the cost of sales unit price. Cost control is possible. As a result, it is possible to accurately grasp the gross profit for each business partner.

As described above, as described in [3-1] and [3-2], according to the gross profit calculation device 100 according to the present embodiment, the purchase data and the sales data are the transaction identification data (transaction number) for each product. By associating with the above, the purchase unit price included in the purchase data is set in the sales data as the cost of sales unit price, whereby the gross profit for each individual transaction unit related to the product can be automatically calculated. That is, according to the gross profit calculation device 100 according to the present embodiment, the gross profit for each product and each transaction can be calculated. Therefore, for example, when a plurality of high-priced same products (for example, machines) are traded. , It is possible to meet the needs of grasping the accurate gross profit for each individual transaction and using it for evaluation of sales staff.

[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 ideas described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part thereof 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 gross profit 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 gross profit calculation unit 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 programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and gross profit calculation is performed as necessary. It is read mechanically by the device 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 gross profit calculation unit 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

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 Programmable Read Only Memory), and an EEPROM (registration). 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 gross profit 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 gross profit 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 the one 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 all industries and industries in which ordering transactions are conducted, but is particularly useful in industries in which high-priced commodities such as machines are traded.

100 Gross profit calculator
102 Control unit
102a setting unit
102b Calculation unit
102c generator
104 Communication interface section
106 Storage unit
106a Order details data
106b Order details data
106c Order details data
106d Ordering details data
106e Purchase details data
106f Purchase details data
106g Sales details data
106h Sales details data
108 Input / output interface section
112 Input device
114 Output device 200 Server 300 Network

Claims (7)

A gross profit calculation unit including a control unit and a storage unit.
In the storage unit
Order data including order identification data, order quantity, and transaction identification data by product for identifying transactions by product,
The order data including the order identification data and the order unit price,
Is stored,
The control unit
A product-specific transaction identification data setting means for setting the product-specific transaction identification data included in the order data to the order data including the same order identification data as the order identification data included in the order data.
Purchase data that includes the product-specific transaction identification data set in the order data by the product-specific transaction identification data setting means and includes the order unit price included in the order data as the purchase unit price. The means of generation and
A sales data generation means for generating sales data including the product-specific transaction identification data included in the order data, including the sales amount, and including the order quantity included in the order data as the sales quantity.
The purchase unit price included in the purchase data is added to the sales data including the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data, and the cost of sales, which is the unit price of the cost of sales amount. The cost of sales unit price setting means that performs the cost of sales unit price set processing, which is the processing to set as the unit price,
Based on the sales data after the purchase unit price is set as the cost of sales unit price by the cost of sales unit price setting means, the sales amount included in the sales data is changed to the sales quantity included in the sales data. A calculation means for calculating the gross profit in each individual transaction unit for a product by subtracting the amount obtained by multiplying the cost of sales unit price included in the sales data.
To prepare for
Gross profit calculation unit characterized by. The calculation means is
To calculate the sales quantity included in the sales data by dividing the sales amount included in the sales data by the sales unit price included in the sales data.
The gross profit calculation device according to claim 1. The control unit
Further provided with a generation means for generating the transaction identification data for each product by combining the order number and the line number in the order details specified by the order number.
The gross profit calculation unit according to claim 1 or 2. That the product is a machine
The gross profit calculation device according to any one of claims 1 to 3. The sales data generation means executes sales recording by generating the sales data including the cost of sales unit price of 0 yen.
The purchase data generation means executes purchase recording by generating the purchase data after the sales recording, and then executes the purchase recording.
The cost of sales unit price setting means performs the cost of sales unit price set processing to replace the cost of sales unit price of 0 yen in the sales data with the purchase unit price.
The gross profit calculation device according to any one of claims 1 to 4. It is a gross profit calculation method executed by an information processing device including a control unit and a storage unit.
In the storage unit
Order data including order identification data, order quantity, and transaction identification data by product for identifying transactions by product,
The order data including the order identification data and the order unit price,
Is stored,
Executed by the control unit,
A product-specific transaction identification data setting step for setting the product-specific transaction identification data included in the order data to the order data including the same order identification data as the order identification data included in the order data.
Purchase data that includes the product-specific transaction identification data set in the order data in the product-specific transaction identification data setting step and includes the order unit price included in the order data as the purchase unit price. Generation step and
A sales data generation step for generating sales data including the product-specific transaction identification data included in the order data, including the sales amount, and including the order quantity included in the order data as the sales quantity.
The purchase unit price included in the purchase data is added to the sales data including the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data, and the cost of sales, which is the unit price of the cost of sales amount. The cost of sales unit price setting step that performs the cost of sales unit price set processing, which is the processing to set as the unit price,
Based on the sales data after the purchase unit price is set as the cost of sales unit price by the cost of sales unit price setting step, the sales amount included in the sales data is changed to the sales quantity included in the sales data. A calculation step for calculating the gross profit for each individual transaction unit for a product by subtracting the amount obtained by multiplying the cost of sales unit price included in the sales data.
Including
The purchase data generation step and the sales data generation step shall be executed in any order.
Gross profit calculation method characterized by. It is a gross profit calculation program to be executed by an information processing device including a control unit and a storage unit.
In the storage unit
Order data including order identification data, order quantity, and transaction identification data by product for identifying transactions by product,
The order data including the order identification data and the order unit price,
Is stored,
To make the control unit execute
A product-specific transaction identification data setting step for setting the product-specific transaction identification data included in the order data to the order data including the same order identification data as the order identification data included in the order data.
Purchase data that includes the product-specific transaction identification data set in the order data in the product-specific transaction identification data setting step and includes the order unit price included in the order data as the purchase unit price. Generation step and
A sales data generation step for generating sales data including the product-specific transaction identification data included in the order data, including the sales amount, and including the order quantity included in the order data as the sales quantity.
The purchase unit price included in the purchase data is added to the sales data including the same product-specific transaction identification data as the product-specific transaction identification data included in the purchase data, and the cost of sales, which is the unit price of the cost of sales amount. The cost of sales unit price setting step that performs the cost of sales unit price set processing, which is the processing to set as the unit price,
Based on the sales data after the purchase unit price is set as the cost of sales unit price by the cost of sales unit price setting step, the sales amount included in the sales data is changed to the sales quantity included in the sales data. A calculation step for calculating the gross profit for each individual transaction unit for a product by subtracting the amount obtained by multiplying the cost of sales unit price included in the sales data.
Including
The purchase data generation step and the sales data generation step shall be executed in any order.
Gross profit calculation program featuring.

Images