JP6947507B2 - Profit management equipment, profit management methods, and profit management programs - Google Patents

Description

The present invention relates to a profit management device, a profit management method, and a profit management program.

As a conventional technique relating to profit management for calculating a management evaluation index, for example, Patent Document 1 can be mentioned. Patent Document 1 discloses a technique relating to a method of calculating a gross profit margin, ROA (return on total assets), etc. and using it as an evaluation index. In particular, when the logistics work performed using one warehouse is divided into four companies and outsourced, the total assets of the warehouse including various expenses are distributed to four companies, and the ROA and crude of the four companies are used as evaluation indexes. A method of calculating and comparing the rates of return is disclosed.

JP-A-2002-007529

However, the technique disclosed in Patent Document 1 has a problem that it is not possible to associate sales costs with sales and apportion them.

The present invention has been made in view of the above problems, and an object of the present invention is to provide a profit management device, a profit management method, and a profit management program for associating sales expenses with sales and apportioning them.

In order to solve the above-mentioned problems and achieve the object, the profit management device according to the present invention is a profit management device provided with a control unit, and the control unit is a sales amount linked to the sales amount of the product. It is characterized in that it is provided with an apportionment means for calculating the amount of money apportioned for each product according to a predetermined apportionment standard related to the product.

Further, the profit management device according to the present invention is characterized in that, in the profit management device, the apportionment standard is an apportionment standard based on the quantity of the product or the sales amount.

Further, the profit management device according to the present invention further includes a master data table including information about the product and a reference amount for each product in the profit management device, and the apportioning means further prorates the amount for each product. Is calculated by multiplying the standard amount for each product.

Further, in the profit management device according to the present invention, in the profit management device, the control unit further increases the gross profit and the gross profit for each product based on the sales amount, the cost of sales, and the sales contribution amount. It is characterized in that it is provided with a warning means for calculating the rate and warning about the product whose gross profit margin is equal to or less than a predetermined threshold value.

Further, the profit management method according to the present invention is a profit management method executed by an information processing apparatus provided with a control unit, and a sales amount linked to a sales amount of a product executed by the control unit is used. It is characterized by including an apportionment step of calculating an amount apportioned for each product according to a predetermined apportionment standard related to the product.

Further, the profit management program according to the present invention is a profit management program for being executed by an information processing apparatus provided with a control unit, and is a sales amount linked to the sales amount of the product to be executed by the control unit. It is characterized by including an apportionment step of calculating the amount of money apportioned for each product according to a predetermined apportionment standard related to the product.

According to the present invention, it is possible to realize profit management in which sales costs are linked to sales and apportioned. Therefore, it is possible to create a journal based on the data obtained by apportioning the sales costs, and it is possible to reduce input errors and workload.

FIG. 1 is a block diagram showing an example of the configuration of the profit management device according to the present embodiment. FIG. 2 is a diagram showing an example of a data structure relating to data created in the profit management process according to the present embodiment. FIG. 3 is a diagram showing an example of display on the main screen. FIG. 4 is a diagram showing an example of the display of the detail input screen. FIG. 5 is a diagram showing an example of the display of the sales distribution apportionment input screen. FIG. 6 is a diagram showing an example of the display of the sales record table extraction condition input screen. FIG. 7 is a diagram showing an example of a flowchart of the profit management process according to the present embodiment. FIG. 8 is a diagram showing an example of a sales header data file. FIG. 9 is a diagram showing an example of a sales detail data file. FIG. 10 is a diagram showing an example of a sales miscellaneous header data file. FIG. 11 is a diagram showing an example of a sales details data file. FIG. 12 is a diagram showing an example of a sales apportionment detail data file. FIG. 13 is a diagram showing an example of a product master data table. FIG. 14 is a diagram showing an example of a sales apportionment detail data file. FIG. 15 is a diagram for explaining an example of data aggregation of sales, cost of sales, and sales costs, and a gross profit margin warning list data file. FIG. 16 is a diagram showing an example of the display result of the sales record table.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
The present embodiment relates to a profit management function including sales charges. Sales charges, which are the charges associated with sales, are treated as SG & A expenses that are not originally included in the cost of sales. In the present embodiment, it is possible to manage profits including various charges for each transaction by inputting various charges in association with sales.

For example, in a transaction with sales of 100,000 yen, cost of sales of 60,000 yen, and gross profit (gross profit) of 40,000 yen, if the sales cost is 10,000 yen, the sales cost is included. However, the profit will be 30,000 yen.

In the present embodiment, the apportionment method for various kake may be based on the amount and quantity, or may be provided with a frame called a reference amount so that a coefficient or the like can be specified. For example, in the case of food, it can be a coefficient for determining a luxury item such as a brand. In addition, in the futon, the area can be used as a coefficient.

In the past, it was not possible to manage sales costs by including them as an element of profit management. In addition, it could only be apportioned based on quantitative criteria such as amount and quantity. However, such profit management is important in industries such as trading companies, wholesalers, and retailers that carry out operations that involve costs in sales, and the profit management process according to the present embodiment is useful.

The feature of this embodiment is that in order to manage sales including sales costs, sales costs (debt data) are linked to sales and output to a performance table. Further, in the profit management process according to the present embodiment, the amount breakdown of the sales details can be retained in the "sales apportionment details". At the same time, by holding up to the sales item number, for example, it is possible to link which product cost which expense and how much. Further, the present embodiment is characterized in that it outputs a list that interrupts the specified gross profit rate in order to issue a warning when the gross profit rate falls below a specific value. Further, the present embodiment is characterized in that a reference amount is provided in the product master data table and the coefficient is managed at the time of proportional division in order to perform the coefficient apportionment management for the quantity and the amount.

[2. composition]
Here, an example of the configuration of the profit management device of the present embodiment will be described with reference to FIG. The configuration of the present embodiment is merely an example, and the present invention is not limited to the realization of the configuration of the present embodiment. In addition, duplicate description may be omitted in the following description of the configuration.

FIG. 1 is a block diagram showing an example of the configuration of the profit management device 100 according to the present embodiment. The profit management device 100 is a commercially available desktop personal computer. The profit management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

The profit management 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 profit management device 100 is communicably connected via an arbitrary communication path.

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

The communication interface unit 104 connects the profit management 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 profit management device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The tables, files, and the like described later may be stored in the server 200.

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) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes a sales header data file 106a, a sales detail data file 106b, a sales cost header data file 106c, a sales cost detail data file 106d, a sales apportionment detail data file 106e, a product master data table 106f, and a sales record table data. It has a file 106g, an aggregated data file 106h, and a gross margin warning list data file 106i. FIG. 2 is a diagram showing an example of a data structure (data set) related to data created in the profit management process according to the present embodiment.

As shown in FIG. 2, the sales header data file 106a contains the sales No. Stores records containing information about (number), sales date, customer, and delivery destination.

The sales detail data file 106b stores a record including information about the sales number, the sales detail number, the product CD (code), the quantity (sales quantity), the sales unit price, and the sales amount.

The sales charge header data file 106c stores a sales charge number and a record including information about the sales number.

The sales charge detail data file 106d stores a record including information about the sales charge number, the charge detail number, the supplier, the recording date, the expense, and the charge amount.

The sales apportionment detail data file 106e stores a record including information about the sales multiplication number, the multiplication detail number, the proportional distribution line number, the sales number, the sales detail number, and the apportioned amount.

The product master data table 106f stores a record containing information about the product and the reference quantity. The reference amount is a coefficient or the like according to the classification of products (for example, food, futon, etc.), which is used as a reference when apportioning the sales amount.

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 screen or a monitor (including a home television). As the input device 112, in addition to a keyboard, a mouse, and a microphone, 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 screen 114 or a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The control unit 102 is a CPU or the like that collectively controls the profit management device 100. The control unit 102 conceptually includes a setting unit 102a, a proportional division calculation unit 102b, a gross margin warning unit 102c, an aggregation unit 102d, a creation unit 102e, and a display screen control unit 102f. Further, 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 required data, and various information based on these stored programs. Execute the process.

When the sales input and the sales amount input are performed, the setting unit 102a makes various settings (for example, file and screen display settings corresponding to the items selected on the input screen) based on the input information. I do.

The apportionment calculation unit 102b calculates the sales amount associated with the sales amount based on the data set including the number for identifying the sales item, the product, the quantity, the sales unit price, the sales amount, and the information about the sales amount. Then, the sales amount is apportioned to calculate the amount apportioned for each product according to the predetermined apportionment standard for the product. The predetermined apportionment standard includes, for example, the quantity of goods or the sales amount of goods. Further, the apportionment calculation unit 102b may calculate the apportioned amount based on the reference amount for each product.

The gross profit margin warning unit 102c calculates the gross profit and the gross profit margin for each product based on the sales amount, the cost of sales, and the various contribution amounts, and the calculated gross profit margin is equal to or less than a predetermined threshold value. Warning. For example, the gross margin warning unit 102c can sort the records based on the gross margin based on the aggregated data file 106h, and warns the products obtained by dividing the predetermined gross margin by the gross margin warning list data file 106i. can do.

The aggregation unit 102d aggregates various data such as sales, cost of sales, and sales costs.

The creation unit 102e creates various data files and the like based on the input information, the data file, and the numerical values calculated by the proportional division calculation unit 102b, the gross margin warning unit 102c, and the aggregation unit 102d. For example, the sales header data file 106a and the sales detail data file 106b are created based on the sales input. Further, based on the sales amount input, the sales amount header data file 106c, the sales amount detail data file 106d, the sales apportionment detail data file 106e, and the like are created. Further, according to the extraction conditions input on the sales record table extraction condition input screen shown in FIG. 6, the sales header data file 106a, the sales detail data file 106b, the sales cost header data file 106c, the sales cost detail data file 106d, and , The sales record table data file 106g is created based on the sales apportionment detail data file 106e and the like, and based on the gross profit and the gross profit rate (%) calculated by the gross profit rate warning unit 102c. In addition, the total data file 106h is created based on the numerical value calculated by totaling various data by the total unit 102d. Further, the gross margin warning list data file 106i is created based on the numerical value calculated by the gross margin warning unit 102c.

The display screen control unit 102f is, for example, various types such as the main screen shown in FIG. 3, the detail input screen shown in FIG. 4, the sales amount input screen shown in FIG. 5, and the sales record table extraction condition input screen shown in FIG. Control the display of the input screen. A detailed description of the screen configuration will be described later.

[3. screen structure]
Here, an example of the screen configuration in the present embodiment will be described with reference to FIGS. 3 to 6.

FIG. 3 is a diagram showing an example of display of a main screen (for example, a Web screen). On the main screen, enter sales.

FIG. 4 is a diagram showing an example of display of a detail input screen (for example, a Web screen). On the detail input screen, input the details of sales.

FIG. 5 is a diagram showing an example of a display of a sales distribution apportionment input screen (for example, a Web screen). On the sales-related apportionment input screen, the sales-related apportionment input is performed. As shown in FIG. 5, in the area MA1 of the sales amount apportionment input screen, the foreign currency amount and the Japanese currency amount can be displayed, and the apportionment result can be changed. Further, as shown in the area MA2, the apportionment results can be displayed respectively. In addition, here, an example of quantity apportionment is shown.

FIG. 6 is a diagram showing an example of display of a sales record table extraction condition input screen (for example, a Web screen). On the sales record table extraction condition input screen, input the sales record table extraction condition. As shown in FIG. 6, in the area MB1 of the sales record table extraction condition input screen, it is possible to select whether the cost inclusion category includes only the cost of sales or the cost of sales and the amount of the cost of sales.

[4. process]
An example of each process according to the present embodiment will be described in detail with reference to FIG. 7 and the like. FIG. 7 is a diagram showing an example of a flowchart of the profit management process according to the present embodiment.

As shown in FIG. 7, when the sales are input on the main screen shown in FIG. 3, in step SA1, the setting unit 102a makes various settings based on the sales input, and the creating unit 102e sets the sales header file. Create 106a and sales detail data file 106b.

FIG. 8 is a diagram showing an example of the sales header data file 106a. As shown in FIG. 8, the sales header data file 106a stores a record containing information about the sales number, sales date, customer, and delivery destination. Specifically, the sales header data file 106a contains, for example, a record including the sales number "UR00000001", the sales date "2016/5/1", the customer XX Shoji, and the delivery destination "△△ site". Stored.

FIG. 9 is a diagram showing an example of the sales detail data file 106b. As shown in FIG. 9, the sales detail data file 106b stores a record including information about the sales number, the sales detail number, the product, the quantity, the sales unit price, and the sales amount. Specifically, in the sales detail data file 106b, for example, the sales number "UR00000001", the sales detail number "1", the product "product A", the quantity "10", and the sales unit price "5,000" are on the first line. , And a record including the sales amount "50,000" is stored. In addition, the second line includes the sales number "UR00000001", the sales detail number "2", the product "product B", the quantity "20", the sales unit price "2,000", and the sales amount "40,000". Records are stored. In addition, the third line includes the sales number "UR00000001", the sales detail number "3", the product "product C", the quantity "20", the sales unit price "2,000", and the sales amount "60,000". Records are stored.

Returning to FIG. 7, when the sales amount is input, in step SA2, the setting unit 102a makes various settings based on the sales amount input, and the creation unit 102e sets the sales amount header data file 106c and the sales amount. The credit detail data file 106d and the sales apportionment detail data file 106e are created.

FIG. 10 is a diagram showing an example of the sales amount header data file 106c. As shown in FIG. 10, the sales charge header data file 106c stores a sales charge number and a record including information about the sales number. Specifically, the sales-related header data file 106c stores, for example, a record including the sales-related number "US00000025" and the sales number "UR00000001".

FIG. 11 is a diagram showing an example of the sales details data file 106d. As shown in FIG. 11, the sales charge detail data file 106d stores a record including information about the sales charge detail number, the charge detail number, the supplier, the recording date, the expense, and the charge amount. .. Specifically, in the sales expense statement data file 106d, for example, the sales expense statement number "US00000255", the expense statement number "1", the supplier "XX Transport", and the recording date " A record including "2016/5/31", the expense "packing fare", and the various charges "30,000" is stored. In addition, on the second line, the sales details number "US00000025", the sales details number "2", the supplier "□□ product", the recording date "2016/5/31", the expense "consumables", and so on. , Records including various premiums "6,000" are stored.

Subsequently, the proportional division calculation will be described. The apportionment calculation is calculated by the apportionment calculation unit 102b by proportionally dividing the amount of money by the quantity of goods or the amount of sales based on the data file 106d of the details of sales, and the calculated numerical value and the data file of details of sales. Based on 106d, the creation unit 102e creates the sales apportionment detail data file 106e. Here, the apportionment calculation can also be manually apportioned.

FIG. 12 is a diagram showing an example of the sales apportionment detail data file 106e. As shown in FIG. 12, the sales apportionment detail data file 106e stores a record including information about the sales amount, the sales item number, the apportionment line number, the sales number, the sales item number, and the amount of the item. .. In the sales apportionment detail data file 106e, for each record included in the sales detail data file 106b, the first to third lines store the records in which the quantity is apportioned with respect to the various credit item number "1", and four lines are stored. In the 6th line from the first line, a record obtained by apportioning the amount of each item number "2" is stored.

Specifically, in the sales apportionment detail data file 106e, for example, the sales number "US00000255", the item number "1", the apportionment line number "1", the sales number "UR000000001", and the sales are on the first line. A record including the item number "1" and the amount of money "(amount of money of item number" 1 "30,000 x quantity 10 / total sales quantity (10 + 20 + 30) =) 5,000" is stored. .. In addition, on the second line, the sales number "US000000255", the item number "1", the apportioned line number "2", the sales number "UR00000001", the sales item number "2", and the amount of money "( A record including "amount of money 30,000 x quantity 20 / total sales quantity (10 + 20 + 30) =) 10,000" of the number "1" is stored. Further, on the third line, the sales number "US000000255", the item number "1", the apportioned line number "3", the sales number "UR00000001", the sales item number "3", and the amount of money "( A record including "amount of money 30,000 x quantity 30 / total sales quantity (10 + 20 + 30) =) 15,000" of the number "1" is stored.

In the sales apportionment detail data file 106e, further, on the fourth line, the sales number "US00000025", the various item number "2", the apportionment line number "1", the sales number "UR000000001", and the sales item number "1". , And the record including the amount of money "(the amount of money of the money of each item" 2 "6,000 x the amount of sales 50,000 / the total amount of sales (50,000 + 40,000 + 60,000) =) 2,000" Is stored. In addition, on the fifth line, the sales number "US000000255", the item number "2", the apportioned line number "2", the sales number "UR00000001", the sales item number "2", and the amount of money "( A record including the amount of money 6,000 of the item number "2" x the amount of sales 40,000 / the total amount of sales (50,000 + 40,000 + 60,000) =) 1,600 "is stored. Further, on the 6th line, the sales number "US000000255", the item number "2", the apportioned line number "3", the sales number "UR00000001", the sales item number "3", and the amount of money "( A record including the amount of money 6,000 of the item number "2" x the amount of sales 60,000 / the total amount of sales (50,000 + 40,000 + 60,000) =) 2,400 "is stored.

Next, the proportional division calculation using the reference amount will be described. In the apportionment calculation using the reference amount, the coefficient can be managed at the time of apportionment by providing the reference amount in the product master data table 106f in order to perform the coefficient apportionment management for the quantity of the product or the sales amount.

First, the product master data table 106f will be described. FIG. 13 is a diagram showing an example of the product master data table 106f. As shown in FIG. 10, the product master data table 106f stores a record containing information about the product and the reference quantity. Specifically, in the product master data table 106f, for example, a record including the product "product A" and the reference amount "1.20" is stored in the first row. In addition, a record including the product "product B" and the reference amount "1.30" is stored in the second line. In addition, a record including the product "product C" and the reference amount "1.50" is stored in the third line.

The apportionment calculation unit 102b refers to the product master data table 106f, acquires the reference amount for each corresponding product included in the product master data table 106f, and has the sales item number “1” included in the sales apportionment detail data file 106e. Multiply by the amount of money to calculate each standard amount of money.

FIG. 14 is a diagram showing an example of the sales apportionment detail data file 106e. As shown in FIG. 14, the various contributions calculated proportionally using the reference amount are added to the rightmost column of the sales proportional distribution detail data file 106e shown in FIG. 12 as “multiplication amount × reference amount”. That is, the "money amount x standard amount" is "(money amount 5,000 x standard amount 1.20 =) 6,000" in the first line and "(money amount 5, standard amount" in the second line. 000 x standard amount 1.30 =) 6,500 ", the third line is" (various amount of money 5,000 x standard amount 1.50 =) 7,500 ", and the fourth line is" (various amount of money) 2,000 x standard amount 1.20 =) 2,400 "," (various amount of money 2,000 x standard amount 1.30 =) 2,600 "in the 5th line, and" in the 6th line (Amount of money 2,000 x reference amount 1.50 =) 3,000 "is stored.

Returning to FIG. 7, in step SA3, the gross profit rate warning unit 102c calculates the gross profit and the gross profit rate (%) based on the sales detail data file 106b, the cost of sales details data file 106d, and the like, and the aggregation unit 102d , Sales amount, cost of sales, and sales amount are totaled. The creation unit 102e creates a total data file 106h and a gross profit rate warning list data file 106i based on the numerical values calculated by the gross profit rate warning unit 102c and the totalization unit 102d, and further, the sales record table data file 106g for each product. To create.

The gross profit margin (%) is calculated by the following formula 1.
Gross profit rate (%) = Gross profit / Sales amount x 100 (%)
= (Sales amount-Cost of sales-Miscellaneous amount) / Sales amount x 100 (%) ... (Equation 1)

FIG. 15 is a diagram for explaining an example of data aggregation of sales, cost of sales, and sales costs, and a gross profit margin warning list data file 106i. As shown in FIG. 15, the aggregated data file 106h is a record containing information about the sales number, the sales item number, the product, the quantity, the sales unit price, the sales amount, the cost of sales, the amount of expenses, and the gross profit margin (%). To store.

The gross profit rate warning unit 102c can sort the records based on the gross profit rate based on the aggregated data file 106h, and warns the products obtained by dividing the predetermined gross profit rate by the gross profit rate warning list data file 106i. Can be done. That is, when the threshold value of the gross margin to be warned is specified as 30% or less, the product A having a gross margin of 36% is excluded from the warning, and the products B and C having a gross margin of 21% are warned. Can be done.

Next, the display of the sales record table data file 106 g will be described. FIG. 16 is a diagram showing an example of the display result of the sales record table data file 106 g. The sales record table data file 106g has a sales header data file 106a, a sales detail data file 106b, a sales expense header data file 106c, and a sales record according to the extraction conditions input on the sales record table extraction condition input screen shown in FIG. It is created based on the detail data file 106d and the sales apportionment detail data file 106e, and based on the gross profit and the gross profit rate (%) calculated by the gross profit rate warning unit 102c. As shown in FIG. 16, in the area MC1 of the sales record table data file 106 g, the total sales amount, the gross profit amount, the gross profit rate, and the total sales quantity can be displayed for each product.

[5. Summary of embodiments, and other embodiments]
As described above, according to the present embodiment, it is possible to realize profit management in which sales costs are linked to sales and apportioned. Therefore, it is possible to create a journal based on the data obtained by apportioning the sales costs, and it is possible to reduce input errors and workload.

Moreover, although the embodiment of the present invention has been described so far, the present invention has been implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiment. It's a good one.

For example, among the processes described in the above-described embodiment, all or part of the processes described as being automatically performed may be manually performed, or the processes described as being manually performed. It is also possible to automatically perform all or part of the above by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the above documents and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the profit management 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 profit management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is recorded in each apparatus as necessary. It is read mechanically. 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 the RAM, and constitutes the control unit 102 in cooperation with the CPU.

Further, the computer program may be stored in the application program server connected to the server 200 via an arbitrary network, and all or a part thereof can be downloaded as needed.

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 Optical Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

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 a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration or procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

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 profit management 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 profit management 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.

Further, the specific form of distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary 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 industries such as trading companies, wholesalers, retailers, etc., which operate with costs involved in sales.

100 Profit management device 102 Control unit 102a Setting unit 102b Proportional division calculation unit 102c Gross margin warning unit 102d Aggregation unit 102e Creation unit 102f Display screen control unit 104 Communication interface unit 106 Storage unit 106a Sales header data file 106b Sales details data file 106c Kake header data file 106d Sales details data file 106e Sales apportionment details data file 106f Product master data table 106g Sales record table data file 106h Aggregate data file 106i Gross margin warning list data file 108 Input / output interface unit 112 Input device 114 Output device 200 servers 300 networks

Claims (5)

It is a profit management device equipped with a control unit.
The control unit
An apportionment means for calculating the amount of sales premiums linked to the sales amount of a product for each product according to a predetermined apportionment standard related to the product.
A calculation means for calculating gross profit for each product based on the sales amount, cost of sales, and sales amount, and calculating the gross profit ratio based on the gross profit and the sales amount is provided. Provided with a warning means for warning about the product whose gross profit margin is equal to or less than a predetermined threshold.
A profit management device characterized by. The apportionment standard is an apportionment standard based on the quantity of the product or the sales amount.
The profit management device according to claim 1. The profit management device is
Further provided with a master data table containing information on the product and the reference quantity for each product.
The apportioning means further
Calculate the amount obtained by multiplying the amount proportionally divided for each product by the reference amount for each product.
The profit management device according to claim 1 or 2. It is a profit management method executed by an information processing device equipped with a control unit.
Executed by the control unit,
An apportionment step of calculating the amount of sales premiums linked to the sales amount of a product for each product according to a predetermined apportionment standard related to the product, and
A calculation step is included in which a gross profit is calculated for each product based on the sales amount, the cost of sales, and the sales amount, and the gross profit ratio is calculated based on the gross profit and the sales amount. Including a warning step to warn about the product whose gross profit margin is less than or equal to a predetermined threshold.
A profit management method characterized by. It is a profit management program to be executed by an information processing device equipped with a control unit.
To make the control unit execute
An apportionment step of calculating the amount of sales premiums linked to the sales amount of a product for each product according to a predetermined apportionment standard related to the product, and
A calculation step is included in which a gross profit is calculated for each product based on the sales amount, the cost of sales, and the sales amount, and the gross profit ratio is calculated based on the gross profit and the sales amount. Including a warning step to warn about the product whose gross profit margin is less than or equal to a predetermined threshold.
A profit management program featuring.

Images