JP2018116642A - Profit management device, profit management method, and profit management program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a profit management device, a profit management method, and a profit management program for executing proportional division in association of sales various credit with sales.SOLUTION: According to one embodiment, a profit management method includes the steps of: calculating sales various credit amount associated with a sales amount on the basis of a data set including information about a number identifying sales details, a commodity, a quantity, a sales unit price, sales amount of money, and a sales various credit amount of money; and executing proportional division calculation for calculating an amount of money in which the sales various credit amount of money is proportionally divided for each commodity according to a predetermined proportional division reference about the commodity.SELECTED DRAWING: Figure 1

Description

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

  As a conventional technique related to profit management for calculating a management evaluation index, for example, Patent Document 1 can be cited. Patent Document 1 discloses a technique related to a method of calculating a gross profit rate, ROA (return on total assets), and the like and using it as an evaluation index. In particular, when consigning logistics operations using one warehouse to four companies, the total assets of the warehouse, including various expenses, etc. are allocated to four companies, and ROA of four companies and gross A method of calculating and comparing profit rates is disclosed.

JP 2002-007529 A

  However, the technique disclosed in Patent Document 1 has a problem in that it is not possible to apportion the sales credits to sales.

  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 that apportion and distribute sales details to sales.

  In order to solve the above-described problems and achieve the object, a profit management apparatus according to the present invention is a profit management apparatus including a control unit, and the control unit is a sales unit associated with a sales amount of a product. According to the present invention, there is provided an apportioning unit for calculating an apportioned amount for each product according to a predetermined apportioning standard for the product.

  The profit management device according to the present invention is characterized in that, in the profit management device, the apportionment criterion is an apportionment criterion based on the quantity of goods or the sales amount.

  Further, the profit management device according to the present invention further includes a master data table including information on the product and a reference amount for each product in the profit management device, and the apportioning unit further includes an apportioned amount for each product. The amount of money multiplied by the reference amount for each product is calculated.

  Further, the profit management apparatus according to the present invention is the profit management apparatus, wherein the control unit further includes gross profit and gross profit for each product based on the sales amount, the cost of sales, and the sales charge amount. It is characterized by comprising warning means for calculating a rate and warning the product for which the calculated gross profit rate is not more than a predetermined threshold.

  Further, the profit management method according to the present invention is a profit management method executed by an information processing apparatus including a control unit, and executes a sales amount associated with a sales amount of a product executed by the control unit. The method includes a distribution step of calculating an apportioned amount for each product in accordance with a predetermined apportionment standard for the product.

  Further, the profit management program according to the present invention is a profit management program for causing an information processing apparatus provided with a control unit to execute, and is related to the sales amount associated with the sales amount of the product to be executed by the control unit. The method includes a distribution step of calculating an amount that is apportioned for each product according to a predetermined apportionment standard for the product.

  According to the present invention, there is an effect that it is possible to realize profit management that apportions sales charges in association with sales. Therefore, it is possible to create journals based on the data that apportions the sales details, and it is possible to reduce input mistakes and workload.

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

  Embodiments of the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
The present embodiment relates to a profit management function including sales charges. The sales charge, which is a charge associated with the sales, is processed as a sales management cost that is not originally included in the cost of sales. In the present embodiment, profit management including various charges for each transaction is possible by inputting various charges in association with sales.

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

  In the present embodiment, the apportionment method for various charges may be based on the amount of money or quantity, or may be provided with a frame called a reference amount so that a coefficient or the like can be designated. For example, in the case of food, it can be used as a coefficient for judging a luxury product such as a brand. Moreover, in a futon, an area can be made into a coefficient.

  Previously, it was not possible to manage sales details as an element of profit management. In addition, apportionment was possible only by quantitative criteria such as amount and quantity. However, such profit management is important in an industry that performs operations involving expenses in sales, such as trading companies, wholesalers, retailers, etc., and the profit management process according to the present embodiment is useful.

  The present embodiment is characterized in that a sales account (debt data) is linked to sales and output to a performance table in order to manage profits including sales accounts. Furthermore, the profit management process according to the present embodiment can hold the breakdown of the amount of the sales details in the “sales distribution details”. At the same time, by holding up to the sales specification number, for example, it can be linked which expense and how much it costs. In addition, the present embodiment is characterized in that a list that interrupts the specified gross profit rate is output in order to issue a warning when the gross profit rate interrupts a specific value. In addition, the present embodiment is characterized in that a reference amount is provided in the product master data table and coefficient management is performed at the time of distribution in order to perform coefficient distribution management for quantities and amounts.

[2. Constitution]
Here, an example of the configuration of the profit management apparatus of the present embodiment will be described with reference to FIG. Note that the configuration of the present embodiment is merely an example, and the present invention is not limited to being realized by the configuration of the present embodiment. Moreover, in the following description regarding the configuration, overlapping description may be omitted.

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

  The profit management apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part with which profit management device 100 is provided is connected so that communication is possible via arbitrary communication paths.

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

  The communication interface unit 104 connects the profit management 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 a communication line. Here, the network 300 has a function of connecting the profit management apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that tables, files, and the like, which will be described later, may be stored in the server 200.

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

  The storage unit 106 includes a sales header data file 106a, a sales details data file 106b, a sales details header data file 106c, a sales details data file 106d, a sales apportionment details data file 106e, a product master data table 106f, and sales results table data. A file 106g, a total data file 106h, and a gross margin warning list data file 106i. FIG. 2 is a diagram illustrating an example of a data structure (data set) relating to data created in the profit management process according to the present embodiment.

  As shown in FIG. 2, the sales header data file 106a includes a sales number. A record including information on (number), sales date, customer, and delivery destination is stored.

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

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

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

  The sales apportionment detail data file 106e stores a record including information on the sales accrual number, the accrual detail number, the apportioning line number, the sales number, the sales item number, and the apportioned appropriation amount.

  The merchandise master data table 106f stores records including information on merchandise and reference quantities. The reference amount is a coefficient or the like according to the classification of goods (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 screen or a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the screen 114 or the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The control unit 102 is a CPU that controls the profit management apparatus 100 in an integrated manner. In terms of functional concept, the control unit 102 includes a setting unit 102a, a prorated calculation unit 102b, a gross margin warning unit 102c, a totaling 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 necessary data, and various information based on these stored programs. Execute the process.

When the sales input and the sales charge input are performed, the setting unit 102a performs various settings based on the input information (for example, a file corresponding to an item selected on the input screen, a screen display setting, or the like). I do.

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

  The gross margin warning unit 102c calculates the gross profit and the gross profit ratio for each product based on the sales amount, the cost of sales, and the amount of various charges, and the calculated gross profit rate is equal to or less than a predetermined threshold. Warning. For example, the gross margin warning unit 102c can sort the records based on the gross margin based on the aggregate data file 106h, and alerts the gross margin warning list data file 106i for products with a predetermined gross margin. can do.

  The totaling unit 102d totals various data such as sales, cost of sales, and sales charges.

  The creation unit 102e creates various data files and the like based on the input information, the data file, and numerical values calculated by the apportionment calculation unit 102b, the gross margin warning unit 102c, and the totaling unit 102d. For example, the sales header data file 106a and the sales details data file 106b are created based on the sales input. Further, based on the sales charge input, a sales charge header data file 106c, a sales charge detail data file 106d, a sales apportionment detail data file 106e, and the like are created. Further, in accordance with 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 details data file 106b, the sales details header data file 106c, the sales details details data file 106d, and Based on the sales apportionment detailed data file 106e and the like, and based on the gross margin and the gross margin (%) calculated by the gross margin warning unit 102c, the sales record table data file 106g is created. Further, the totaling data file 106h is created based on the numerical values calculated by the totaling unit 102d totaling various data. 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 a main screen shown in FIG. 3, a detail input screen shown in FIG. 4, a sales item input screen shown in FIG. 5, a sales record table extraction condition input screen shown in FIG. Control display of input screen. Details of the screen configuration will be described later.

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

  FIG. 3 is a diagram illustrating an example of display of a main screen (for example, a Web screen). Enter sales on the main screen.

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

  FIG. 5 is a diagram illustrating an example of a display of a sales apportionment input screen (for example, a Web screen). On the sales apportioning apportionment input screen, sales apportioning apportionment is input. As shown in FIG. 5, in the area MA <b> 1 of the sales apportionment apportioning input screen, the apportionment amount can display the foreign currency appropriation amount and the Japanese currency appropriation amount, and the apportionment result can be changed. Further, as shown in the area MA2, it is possible to display the distribution results. Here, an example of apportioning the quantity is shown.

  FIG. 6 is a diagram illustrating 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, the sales record table extraction condition is input. 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 classification includes only the cost of sales or includes the cost of sales and the sales charge amount.

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

  As shown in FIG. 7, when the sales input is performed on the main screen shown in FIG. 3, in step SA1, the setting unit 102a performs various settings based on the sales input, and the creation unit 102e stores the sales header file. 106a and sales description data file 106b are created.

  FIG. 8 is a diagram illustrating an example of the sales header data file 106a. As shown in FIG. 8, the sales header data file 106a stores a record including information on a sales number, a sales date, a customer, and a delivery destination. Specifically, in the sales header data file 106a, for example, a record including a sales number “UR00000001”, a sales date “2016/5/1”, a customer XX trading company, and a delivery destination “△△ site” is stored. Stored.

  FIG. 9 is a diagram illustrating an example of the sales detail data file 106b. As shown in FIG. 9, the sales details data file 106b stores records including information on sales numbers, sales details numbers, products, quantities, sales unit prices, and sales amounts. Specifically, the sales specification data file 106b includes, for example, the sales number “UR00000001”, the sales specification number “1”, the product “product A”, the quantity “10”, and the sales unit price “5,000” on the first line. , And a record including the sales amount “50,000” is stored. The second line includes a sales number “UR00000001”, a sales specification number “2”, a product “product B”, a quantity “20”, a sales unit price “2,000”, and a sales amount “40,000”. Records are stored. The third line includes a sales number “UR00000001”, a sales specification number “3”, a product “product C”, a quantity “20”, a sales unit price “2,000”, and a sales amount “60,000”. Records are stored.

  Returning to FIG. 7, when the sales charge is input, in step SA2, the setting unit 102a performs various settings based on the sales charge input, and the creation unit 102e includes the sales charge header data file 106c, the sales charge, and the like. A product detail data file 106d and a sales apportionment detail data file 106e are created.

  FIG. 10 is a diagram illustrating an example of the sales charge header data file 106c. As shown in FIG. 10, the sales charge header data file 106 c stores a sales charge number and a record including information about the sales number. Specifically, the sales account header data file 106c stores, for example, a record including a sales account number “US00000025” and a sales number “UR00000001”.

  FIG. 11 is a diagram illustrating an example of the sales detail data file 106d. As shown in FIG. 11, the sales account detail data file 106d stores a record including information on the sales account detail number, the account detail number, the supplier, the date of recording, the expense, and the account amount. . Specifically, the sales details item data file 106d includes, for example, the sales details item number “US00000025”, the item details number “1”, the supplier “xx transportation”, the recording date “ A record including “2016/5/31”, an expense “shipping fare”, and a charge amount “30,000” is stored. Also, in the second row, sales item number “US00000025”, item number “2”, supplier “□□ product”, date “2016/5/31”, expense “consumables”, and , A record including a multi-value amount “6,000” is stored.

  Subsequently, the apportionment calculation will be described. In the apportionment calculation, the apportionment calculation unit 102b calculates the apportionment amount by apportioning the product amount or the sales amount based on the sales apportionment detail data file 106d. 106d creates the sales apportionment detailed data file 106e. Here, manual distribution is also possible for the proportional distribution calculation.

  FIG. 12 is a diagram showing an example of the sales distribution details data file 106e. As shown in FIG. 12, the sales apportionment detail data file 106e stores a record including information on the sales accrual number, the accrual detail number, the apportioning line number, the sales number, the sales item number, and the accrual amount. . In the sales apportionment detail data file 106e, a record in which the quantity apportioning of the item number “1” is apportioned is stored in the first to third lines for each record included in the sales detail data file 106b. In the 6th line from the top, a record that apportions the monetary amount for the item number “2” is stored.

  Specifically, the sales apportionment detail data file 106e includes, for example, a sales account number “US00000025”, an account detail number “1”, an apportionment line number “1”, a sales number “UR00000001”, and sales. A record including the item number “1” and the charge amount “(the charge amount 30,000 of the charge item number“ 1 ”× quantity 10 / total sales quantity (10 + 20 + 30) =) 5,000” is stored. . In the second line, the sales charge number “US00000025”, the charge detail number “1”, the prorated line number “2”, the sales number “UR00000001”, the sales detail number “2”, and the charge “( A record that includes a charge amount 30,000 × quantity 20 / total sales quantity (10 + 20 + 30) =) 10,000 ”of the charge detail number“ 1 ”is stored. Also, in the third line, the sales charge number “US00000025”, the charge detail number “1”, the prorated line number “3”, the sales number “UR00000001”, the sales detail number “3”, and the charge “( A record including a charge amount 30,000 × quantity 30 / total sales quantity (10 + 20 + 30) =) 15,000 of the charge detail number “1” is stored.

  The sales apportionment detail data file 106e further includes a sales accrual number “US00000025”, an accrual item number “2”, an apportionment line number “1”, a sales number “UR00000001”, and a sales item number “1”. , And a record including a charge amount of “(charge amount of charge item number“ 2 ”6,000 × sales amount 50,000 / total sales amount (50,000 + 40,000 + 60,000) =) 2,000” ” Is stored. Also, in the fifth line, the sales charge number “US00000025”, the charge detail number “2”, the prorated line number “2”, the sales number “UR00000001”, the sales detail number “2”, and the charge “( A record is included that includes a multi-currency amount of 6,000 x sales amount of 40,000 / total sales amount (50,000 + 40,000 + 60,000) =) 1,600 ”of the multi-detail item number“ 2 ”. In line 6, the sales charge number “US00000025”, the charge detail number “2”, the prorated line number “3”, the sales number “UR00000001”, the sales detail number “3”, and the charge “( A record is included that includes a multi-currency amount of 6,000 × sales amount of 60,000 / total sales amount (50,000 + 40,000 + 60,000) =) 2,400 ”of the multi-detail item number“ 2 ”.

  Next, a proportional 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 apportionment management of the product quantity or the sales amount.

  First, the merchandise master data table 106f will be described. FIG. 13 is a diagram illustrating an example of the product master data table 106f. As illustrated in FIG. 10, the product master data table 106 f stores records including information on products and reference amounts. 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 the second row, a record including the product “product B” and the reference amount “1.30” is stored. In the third row, a record including the product “product C” and the reference amount “1.50” is stored.

  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 stores the sales specification number “1” included in the sales apportionment specification data file 106e. Multiply the charge amount and calculate each reference amount charge amount.

  FIG. 14 is a diagram showing an example of the sales distribution details data file 106e. As shown in FIG. 14, the charge amount prorated by using the reference amount is added as “variable amount × reference amount” to the rightmost column of the sales distribution details data file 106 e shown in FIG. 12. In other words, “the amount of money x reference amount” is “(the amount of money 5,000 × the amount of reference 1.20 =) 6,000” on the first line and “(the amount of charges 5, reference amount”). 000 × reference amount 1.30 =) 6,500 ”on the third line is“ (Make amount 5,000 × reference amount 1.50 =) 7,500 ”, on the fourth line is“ (Make amount) 2,000 × reference amount 1.20 =) 2,400 ”,“ (multiple amount 2,000 × reference amount 1.30 =) 2,600 ”in the fifth row, and“ (Amount of extra money 2,000 × reference amount 1.50 =) 3,000 ”is stored.

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

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

  FIG. 15 is a diagram for explaining an example of sales, cost of sales, sales sales data aggregation, and gross margin warning list data file 106i. As shown in FIG. 15, the total data file 106h includes a record including information on sales number, sales detail number, product, quantity, sales unit price, sales amount, cost of sales, amount charged, and gross margin (%). Is stored.

  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 product with a predetermined gross margin by the gross margin warning list data file 106i. Can do. That is, if 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 product B and the product C having a gross margin of 21% are warned. Can do.

  Next, display of the sales record table data file 106g will be described. FIG. 16 is a diagram illustrating an example of a display result of the sales record table data file 106g. The sales record table data file 106g is a sales header data file 106a, a sales detail data file 106b, a sales charge header data file 106c, and a sales charge according to the extraction conditions entered 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 on the basis of the gross margin and the gross margin (%) calculated by the gross margin warning unit 102c. As shown in FIG. 16, in the area MC1 of the sales record table data file 106g, the total sales amount, gross profit amount, gross profit rate, and 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 that allocates sales charges to sales. Therefore, it is possible to create journals based on the data that apportions the sales details, and it is possible to reduce input mistakes and workload.

  Further, although the embodiments of the present invention have been described so far, the present invention can be implemented in various different embodiments within the scope of the technical idea described in the claims other than the above-described embodiments. It ’s good.

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

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

  Further, regarding the profit management apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, the processing functions provided in the profit management apparatus 100, particularly the processing functions performed by the control unit 102, are realized entirely or arbitrarily by a CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and is stored in each apparatus as necessary. Read mechanically. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the server 200 via an arbitrary network, and may be downloaded in whole or in part as necessary.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk, etc.), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

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

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

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

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

  INDUSTRIAL APPLICABILITY The present invention is useful for industries that perform operations involving expenses in sales, such as trading companies, wholesalers, and retailers.

DESCRIPTION OF SYMBOLS 100 Profit management apparatus 102 Control part 102a Setting part 102b Proportional calculation part 102c Gross margin warning part 102d Total part 102e Creation part 102f Display screen control part 104 Communication interface part 106 Storage part 106a Sales header data file 106b Sales detailed data file 106c Sales various Multiply header data file 106d Sales detail data file 106e Sales distribution detail data file 106f Product master data table 106g Sales performance table data file 106h Total data file 106i Gross margin warning list data file 108 Input / output interface unit 112 Input device 114 Output device 200 server 300 network

Claims (6)

A profit management device comprising a control unit,
The controller is
Providing apportioning means for calculating an apportioned amount for each product in accordance with a predetermined apportionment standard for the product, with a sales apportioning amount associated with the sales amount of the product,
Profit management device. The apportionment criterion is an apportionment criterion based on the quantity of goods or the sales amount.
The profit management apparatus according to claim 1. The profit management device includes:
Further comprising a master data table including information on the product and a reference amount for each product;
The apportioning means further includes
Calculating an amount obtained by multiplying an amount apportioned for each product by a reference amount for each product;
The profit management apparatus according to claim 1 or 2, wherein The control unit further includes:
Based on the sales amount, the cost of sales, and the sales charge amount, the gross profit and the gross profit rate are calculated for each product, and the product whose calculated gross profit rate is equal to or less than a predetermined threshold is warned. Equipped with warning means to
The profit management apparatus according to claim 1 or 2. A profit management method executed by an information processing apparatus including a control unit,
Executed by the control unit,
Including an apportioning step of calculating an apportioned amount for each product according to a predetermined apportionment standard for the product, with a sales apportioning amount associated with the sales amount of the product,
Profit management method characterized by A profit management program for causing an information processing apparatus including a control unit to execute,
For causing the control unit to execute,
Including an apportioning step of calculating an apportioned amount for each product according to a predetermined apportionment standard for the product, with a sales apportioning amount associated with the sales amount of the product,
Profit management program characterized by

Images