JP6793555B2 - Product profit / loss comparison device and product profit / loss comparison method - Google Patents

Description

The present invention relates to a product profit / loss comparison device and a product profit / loss comparison method for comparing the profit / loss of a product among a plurality of products.

As a conventional technique for setting a price of a product, for example, a technique for setting a price of a product based on information on material costs is known (for example, Patent Document 1). Further, there is known a technique of calculating profitable information about the selling price of a product based on the purchase price of individual parts constituting the product, the processing cost per unit time, and the like (for example, Patent Document 2). Further, as a conventional technique for determining the profit margin of a product or a product group, for example, a technique for evaluating the profit margin of a product or a product group using parts purchase price, customer satisfaction information, etc. is known (for example, Patent Document 3 ).

Japanese Unexamined Patent Publication No. 2004-86515 Japanese Unexamined Patent Publication No. 2003-223543 Japanese Unexamined Patent Publication No. 2003-36293

For example, in the technology disclosed in Patent Document 3, in order to obtain the parts purchase price of the parts constituting the product, it is necessary to acquire the price information for each part and each supplier, which is troublesome. There is a point. Furthermore, considering the occurrence rate of defects and loss of parts after delivery inspection, it is difficult to obtain information on the actual parts purchase price at a high frequency. This also applies to the techniques disclosed in Patent Document 1 and Patent Document 2. If a product is evaluated based on information that is difficult to acquire and cannot be acquired frequently as in the conventional technology, there is a problem that the profit margin of the product group cannot be evaluated immediately in response to fluctuations in the market price of the material. ..

An object of the present invention is to provide a product profit / loss comparison device and a product profit / loss comparison method that can easily and frequently repeat the evaluation of the rate of return on a product and can immediately respond to fluctuations in the market price of materials. It is to be.

The product profit / loss comparison device according to the present invention includes a product information storage unit for storing a plurality of products, the type of one or more materials forming each product, and the weight of the material used for each product, and the material. Based on the market price storage unit that continuously stores and accumulates the market price of the material, the selling price storage unit that stores the selling price of each product, the type of the material, the weight of the material, and the market price of the material. The price information calculation unit calculates the price of the material included in the product as the material cost related to the material, and calculates the ratio of the material cost to the selling price as the material cost ratio, and the above-mentioned material for the material. The price information calculation unit that calculates the amount of fluctuation in the market price as the amount of price fluctuation, and the material cost ratio and the amount of price fluctuation determine the priority among the products in descending order of the profit margin of the product. It has a priority determination unit to be used.

The product profit / loss comparison method according to the present invention is
For multiple products, and product information storage憶部storing one or more kinds of materials constituting each product, and the weight of the material used for each product,
A market price Symbol憶部that continuously stores accumulated market prices for the material,
And selling price Symbol憶部for storing the selling price of each product,
Computers equipped with
A price information calculation process for calculating the price of the material included in the product as a material cost related to the material based on the type of the material, the weight of the material, and the market price of the material.
The ratio of the material cost to the selling price is calculated as the material cost ratio.
A price information calculation process that calculates the amount of fluctuation in the market price of the material as the amount of price fluctuation,
From the material cost ratio and the price fluctuation amount, the priority determination step of determining the priority among the products in the order of increasing the profit margin of the products is executed.

According to the product profit / loss comparison device and the product profit / loss comparison method according to the present invention, the evaluation of the profit margin for the product can be easily and frequently repeated, and the fluctuation of the market price of the material can be immediately responded to.

It is a figure which shows the structure of the product profit / loss comparison apparatus which concerns on Embodiment 1 of this invention. It is a figure which shows the product group which is the object of profit / loss comparison by the product profit / loss comparison apparatus in Embodiment 1 of this invention. It is a figure which shows an example of the product classification information which the product information storage part stores in the product profit and loss comparison apparatus which concerns on Embodiment 1 of this invention. It is a figure which shows an example of the component part information which the product information storage part stores in the product profit and loss comparison apparatus which concerns on Embodiment 1 of this invention. It is a figure which shows an example of the component information which the product information storage part stores in the product profit and loss comparison apparatus which concerns on Embodiment 1 of this invention. It is a figure which shows an example of the weight information by material stored in the product information storage part in the product profit and loss comparison apparatus which concerns on Embodiment 1 of this invention. It is a figure which shows an example of the market price information which the market price storage part stores in the product profit and loss comparison apparatus which concerns on Embodiment 1 of this invention. FIG. 5 is a diagram showing an example of selling price information stored in a selling price storage unit in the product profit / loss comparison device according to the first embodiment of the present invention. It is a figure which shows an example of the information including the material cost among the information calculated by the price information calculation unit in Embodiment 1 of this invention. FIG. 5 is a diagram showing an example of result information including a price fluctuation amount among the information calculated by the price information calculation unit in the first embodiment of the present invention. It is a flowchart which shows each process of the product profit and loss comparison method which concerns on Embodiment 1 of this invention. FIG. 5 is a flowchart showing in more detail the price information calculation process performed by the price information calculation unit in the first embodiment of the present invention. It is a figure which shows an example of the transition of the market price of the material in Embodiment 2 of this invention. It is a flowchart which shows the process performed by the arithmetic unit in Embodiment 2 of this invention. FIG. 5 is a flowchart showing the price information calculation process performed by the price information calculation unit in the second embodiment of the present invention in more detail. It is a figure which shows the structure of the product profit / loss comparison apparatus which concerns on Embodiment 3 of the invention. It is a figure which shows an example of the production plan information stored in the production plan storage part in Embodiment 3 of this invention. FIG. 5 is a diagram showing an example of production planning information, weight information by material, and discount information in the third embodiment of the present invention. It is a figure which shows an example of the selling price information stored in the selling price storage part in the product profit and loss comparison apparatus which concerns on Embodiment 3 of this invention. FIG. 5 is a flowchart showing the price information calculation process performed by the price information calculation unit in the third embodiment of the present invention in more detail. FIG. 5 is a diagram showing an example of selling price information stored in a selling price storage unit in the product profit / loss comparison device according to the fourth embodiment of the present invention. It is a figure which shows an example of the information calculated by the price information calculation part in Embodiment 4 of this invention. It is a figure which shows an example of the transition of the market price of stainless steel and aluminum dealt with in Embodiment 4 of this invention. It is a figure which shows an example of the transition of each composite material unit price dealt with in Embodiment 4 of this invention. It is a figure which shows the fluctuation influence degree calculated by the price information calculation part in Embodiment 4 of this invention. It is a flowchart which showed the price information calculation process performed by the price information calculation part in Embodiment 4 of this invention in more detail.

Hereinafter, a plurality of embodiments of the present invention will be described with reference to the drawings. In the following description, the same reference numerals may be added to the parts corresponding to the matters already described in the forms preceding each form, and duplicate explanations may be omitted. When only a part of the configuration is described, the other parts of the configuration are the same as those described above.

Embodiment 1.
FIG. 1 is a diagram showing a configuration of a product profit / loss comparison device 100 according to a first embodiment of the present invention. The product profit / loss comparison device 100 determines the priority among the products to be expanded in the order of increasing the profit margin of the products. The rate of return of a product is the magnitude of the profit when the product is sold, and specifically, the ratio of the profit to the sales when the product is manufactured.

FIG. 2 is a diagram showing a product group to be compared by the product profit / loss comparison device 100 in the first embodiment of the present invention. FIG. 2 shows, as an example, a case where 11 products, from the first product A1 to the eleventh product C3, are classified into three groups. Each product is produced according to predetermined specifications, shipped to the market and sold.

The first product A1, the second product A2, the third product A3 and the fourth product A4 are classified into the first group A, and these are classified as products that can be replaced with each other. A plurality of products included in one product group are products that can be replaced with each other. Substitutable means that the purchaser of a product is substitutable when deciding which product to purchase, and multiple products that fall into the same product group are intended for use and basic. The function is the same.

The fifth product B1, the sixth product B2, the seventh product B3, and the eighth product B4 are classified into the second product group B, and these are classified as products that can be replaced with each other. The ninth product C1, the tenth product C2, and the eleventh product C3 are classified into the third product group C, and these are classified as products that can be replaced with each other. The first product A1 has a part M101 and a part M102, and the second product A2 has a part M103 and a part M104. The third product A3 has a part M105 and a part M103, and the fourth product A4 has a part M105, a part M104 and a part M106. In this way, the same part may be used in a plurality of different products. As a matter of course, the material and weight of the part M105 included in the third product A3 and the part M105 included in the fourth product A4 are the same.

In the example shown in FIG. 2, the fifth product B1 has the part M107 and the part M108, the sixth product B2 has the part M109 and the part M110, the seventh product B3 has the part M107 and the part M111, and the eighth product. B4 has a component M109 and a component M112. The ninth product C1 has two parts M113, the tenth product C2 has parts M114 and M116, and the eleventh product has parts M115 and M116.

As shown in FIG. 1, the product profit / loss comparison device 100 includes a product information storage unit 2, a market price storage unit 3, a selling price storage unit 4, a calculation unit 5, and a result storage unit 14. The product information storage unit 2 stores component information 6, component information 7, weight information 11 for each material, and product classification information 12. FIG. 3 is a diagram showing an example of product classification information 12 stored in the product information storage unit 2 in the product profit / loss comparison device 100 according to the first embodiment of the present invention. The product classification information 12 is information on which product group each product is classified into. A calculation unit 5 is connected to the product information storage unit 2, and the calculation unit 5 acquires and uses the product classification information 12 stored in the product information storage unit 2.

FIG. 4 is a diagram showing an example of component information 6 stored in the product information storage unit 2 in the product profit / loss comparison device 100 according to the first embodiment of the present invention. The component component information 6 is information on the component configuration included in each product. For example, the component component information 6 includes information that the first product A1 is composed of the component M101 and the component M102, and the product classification information 12 is information that the first product A1 to the fourth product A4 belong to the first product group A. including. In some cases, one component may further include a plurality of components. In that case, the information is divided into parts composed of a single material, and the material and weight are handled as described later.

FIG. 5 is a diagram showing an example of component information 7 stored in the product information storage unit 2 in the product profit / loss comparison device 100 according to the first embodiment of the present invention. The part information 7 has information on which material each part is composed of and information on the weight of each part. For example, the part information 7 shows information that the part M101 is made of stainless steel and that its weight is 0.1 kg. Further, the component information 7 indicates information that the component M102 is made of stainless steel and information that its weight is 0.2 kg.

FIG. 6 is a diagram showing an example of weight information 11 for each material stored in the product information storage unit 2 in the product profit / loss comparison device 100 according to the first embodiment of the present invention. The material-specific weight information 11 is information calculated by the product information calculation unit 51 in the calculation unit 5 based on the component component information 6 and the component information 7, and includes the types of materials included in each product and each product. The total weight of each material used is listed. For example, the product information calculation unit 51 confirms the materials of the part M101 and the part M102 from the part information 7 because the first product A1 has the part M101 and the part M102 as shown in FIG. 4, and both of them are made of stainless steel. Since it is a member made of steel, the weights of both of them are added up, and it is calculated that 0.3 kg of stainless steel is used for the first product A1. The result of this calculation is temporarily stored in the product information storage unit 2 as the weight information 11 for each material. Similarly, the weight information 11 for each material indicates that the amount of aluminum used in the first product A1 is zero kg, that is, it is not used, and 0.5 kg of aluminum is used in the second product. The information is shown.

The material-specific weight information 11 is obtained from the component information 6 and the component information 7, is stored in the product information storage unit 2, and is used by the calculation unit 5. The component information 6 and the component information 7 can be obtained from the design department that designs the product and the production department that produces the product via the input device 13, and if they are obtained in-house in advance, the product It does not need to be updated, nor does it need to be updated frequently, unless the design of the is changed.

FIG. 7 is a diagram showing an example of market price information 31 stored in the market price storage unit 3 in the product profit / loss comparison device 100 according to the first embodiment of the present invention. The market price storage unit 3 stores and stores the market price as information for all the materials indicated by the information included in the part information 7. The calculation unit 5 acquires and uses the market price information 31 stored in the market price storage unit 3. The market price information 31 of each material is a market price of a material such as a bullion made of the material per unit weight. For example, the market price information 31 indicates that the bullion called stainless steel was 400 yen per kg in April 2013, and that it was 390 yen in May 2013. Although FIG. 7 shows only the material of stainless steel, the market price storage unit 3 stores the market price information 31 for the other materials in the same manner, and continuously accumulates the stored information.

FIG. 8 is a diagram showing an example of selling price information 41 stored in the selling price storage unit 4 in the product profit / loss comparison device 100 according to the first embodiment of the present invention. The selling price information 41 is information on the selling price when the product is sold in the market. The calculation unit 5 acquires and uses the selling price information 41 stored in the selling price storage unit 4. In the first embodiment, the selling price storage unit 4 stores the selling price information 41 classified by country and region, and is continuously updated. For example, the selling price information 41 stores information that the first product A1 having a standard price of 240 yen is sold at a selling price of 240 yen in the country X1 and is sold at 230 yen in the country X2.

These selling prices are average values when products are sold in each country and region, and selling price information 41 is input to the selling price storage unit 4 based on a report from the field. When the product is sold locally in a foreign country, the selling price information 41, which is converted into the currency of the home country by the exchange rate, is classified and stored by country, so that the tendency regarding the fluctuation of the selling price can be grasped by country and the sales strategy can be determined. It will be possible to set up by country.

FIG. 9 is a diagram showing an example of information including the material cost 9 among the information calculated by the price information calculation unit 52 in the first embodiment of the present invention. The price information calculation unit 52 in the calculation unit 5 calculates the material cost 9 by multiplying the material-specific weight of the material-specific weight information 11 and the market price of the market price information 31 for each material of each product. .. In the example shown in FIG. 9, it is calculated that the material cost 9 for the stainless steel part included in the first product A1 is 120 yen in total.

Further, the price information calculation unit 52 in the calculation unit 5 calculates the material cost ratio 10. The material cost ratio 10 is the ratio of the material cost 9 of each material in each product to the selling price of the product. For example, the price information calculation unit 52 calculates that the first product A1 sold at a selling price of 240 yen in X1 country contains 120 yen of stainless steel, and the material cost 9 of the material called stainless steel is the second. It is calculated that the ratio of one product A1 to the selling price, that is, the material cost ratio 10 is 0.500.

FIG. 10 is a diagram showing an example of result information 141 including a price fluctuation amount 19 among the information calculated by the price information calculation unit 52 in the first embodiment of the present invention. The price information calculation unit 52 calculates the fluctuation amount of the market price of each material as the “price fluctuation amount 19” from the market price of each material continuously stored and accumulated in the market price storage unit 3. In the first embodiment, the price information calculation unit 52 calculates the price fluctuation amount 19 by dividing the current market price of each material by the market price of the material in the previous month. The price fluctuation amount 19 is represented by a plus when the price of the material rises, and is represented by a minus when the price of the material falls.

Further, the price information calculation unit 52 calculates the fluctuation influence degree 20 by multiplying the price fluctuation amount 19 and the material cost ratio 10. The fluctuation influence degree 20 represents the degree to which the fluctuation of the market price of the material contained in the product affects the profit margin of the product. In FIG. 10, the price fluctuation amount 19 of stainless steel is -1% month-on-month, the price fluctuation amount 19 of aluminum is + 2% month-on-month, and the price fluctuation amount 19 of polypropylene is + 1.2%. The information in the case is illustrated. As shown in FIG. 10, the material cost ratio 10 of stainless steel in the first product A1 is 0.500, and the fluctuation influence degree 20 is 20 in response to the decrease in the price fluctuation amount 19 of stainless steel to -1%. It is calculated that {0.500 × (-1)} = −0.500. In the second product A2, the material cost ratio 10 of aluminum is 0.600, and the fluctuation influence 20 is {0.600 × (+2)} = in response to the increase in the price fluctuation amount 19 of aluminum to + 2%. It is calculated to be +1.200.

In the third product A3 and the fourth product A4, the price fluctuation amount 19 in stainless steel and aluminum is the same as in the case of other products, but the material cost ratio 10 in each product of stainless steel and aluminum is 10 for each product. Since it is different, the degree to which fluctuations in the market price of each material affect the rate of return of each product is different for each product. In the example shown in FIG. 10, in the third product A3, stainless steel shows a fluctuation influence of −0.190%, and aluminum shows a fluctuation influence of +0.458%. In the fourth product A4, stainless steel shows a fluctuation influence of -0.182%, aluminum shows a fluctuation influence of + 0.436%, and polypropylene shows a fluctuation influence of + 0.163%. .. Since the third product A3 and the fourth product A4 include a plurality of materials, the price information calculation unit 52 calculates the total fluctuation influence degree 201 by adding up the fluctuation influence degrees 20 of all the included materials. .. Although FIGS. 9 and 10 show only the information in the X1 country, the price information calculation unit 52 calculates and outputs the same for other countries and regions.

The priority order determination unit 53 in the calculation unit 5 acquires the product classification information 12 from the product information storage unit 2, and acquires the total fluctuation influence degree 201 for each product from the price information calculation unit 52, and within each product group. By comparing the total of the fluctuation impacts 201, the priority 30 of product sales expansion within each product group is determined. Since the first product A1 to the fourth product A4 belong to the first product group A and are replaceable products, the priority determination unit 53 compares these products belonging to the same product group and expands sales. Determine the priority 30 of recommended products.

In the price fluctuation amount 19 and the fluctuation impact degree 20, the decline in the market price for each material is represented by a minus, and the rise is represented by a plus. Therefore, the more the total fluctuation impact degree 201 is negative, the more the product The profit margin will increase. Further, the more positive the total fluctuation influence degree 201 is, the smaller the profit margin of the product is. Based on such a determination, the priority determination unit 53 determines the priority 30 as shown in the rightmost column of FIG. In the example shown in FIG. 10, in the total variation influence degree 201, the priority 30 of the first product A1 showing −0.500 is the highest, and the priority 30 of the third product A3 showing +0.268 is the next highest. Then, the fourth product A4 showing +0.417 and finally the second product A2 showing +1.200 have a priority of 30. Although FIG. 10 shows only the information in the X1 country, the priority determination unit 53 calculates and outputs the same for other countries and regions.

The price information calculation unit 52 and the priority order determination unit 53 output the calculated and determined result as the result information 141 to the result storage unit 14. The result storage unit 14 stores the result information 141 and continuously accumulates the result information 141. The latest result of the result information 141 is output to the output device 15. The output device 15 visually outputs the input information. Since information indicating the priority order 30 of products included in the same product group, in other words, the order of high profit margins, is output to the output device 15, sales are performed based on the information output by the output device 15. And it will be possible to decide or change the policy regarding the expansion of production.

Specifically, the department in charge of product sales is informed of the model name of the product to be expanded and the model name to suppress sales, and the product with high profit margin and profitability is expanded, and the profit margin is low. Suppress sales of unprofitable products. As a result, profit and loss will be improved immediately in accordance with changes in the market price of materials.

The product profit / loss comparison device 100 is realized as a computer 16 equipped with a product profit / loss comparison program. The product profit / loss comparison program causes the computer 16 to function as a product information storage unit 2, a market price storage unit 3, a selling price storage unit 4, a price information calculation unit 52, and a priority determination unit 53. The product profit and loss comparison program is also provided as a computer-readable recording medium. As a result, the product profit / loss comparison device 100 can be realized by the computer 16.

According to the first embodiment, the product profit / loss comparison device 100 has a product information storage unit 2, a market price storage unit 3, a selling price storage unit 4, a price information calculation unit 52, and a priority determination unit. The product information storage unit 2 stores, for a plurality of products, the type of a single or a plurality of materials forming each product, and the weight of the material used for each product. The market price storage unit 3 continuously stores and accumulates the market price of the material. The selling price storage unit 4 stores the selling price of each product. The price information calculation unit 52 calculates the price of the material contained in the product as the material cost 9 related to the material based on the type of the material, the weight of the material, and the market price of the material. Further, the price information calculation unit 52 calculates the ratio of the material cost 9 to the selling price as the material cost ratio 10, and calculates the amount of fluctuation in the market price of the material as the price fluctuation amount 19. The priority determination unit determines the priority 30 among the products in descending order of the profit margin of the products from the material cost 9 and the price fluctuation amount 19.

As a result, the evaluation of the profit margin for the product can be easily and frequently repeated, and it is possible to immediately respond to fluctuations in the market price of the material. Since the material price is calculated as the material cost 9 based on the type, weight, and market price of the material contained in the product, the profit margin of the product is more frequent and easier than when the purchase price of individual parts is obtained. Can be compared to determine the priority 30. The manufacturing cost in the assembly processing industry includes expenses such as labor costs and overhead costs, but the ratio of the material cost 9 is large, and the market price of the material that determines the material cost 9 fluctuates greatly from day to day. However, in order to calculate the manufacturing cost, the work of costing each individual part contained in the product requires a huge amount of time and labor. The part price needs to be obtained for each part, and the cost price for obtaining parts in the future includes information that is difficult to obtain immediately, such as inventory status and the status of parts at the supplier company. In addition, when parts are imported from foreign countries, it is necessary to calculate exchange rate fluctuations, and it takes a lot of time and effort to calculate the cost of parts.

Furthermore, if the material cost 9 rises sharply in a short period of time, there is a risk that the order will be unprofitable due to the delay in responding. On the other hand, in the product profit / loss comparison device 100 according to the present invention, the price fluctuation amount 19 and the fluctuation influence degree 20 are calculated based on the market price of each material which is easily available at a high frequency while avoiding the cost calculation of individual parts. , The priority 30 according to the profit margin of the product can be repeatedly calculated with high frequency. Therefore, even if the market price of each material rises sharply in a short period of time, it is possible to immediately reconsider the policy for expanding sales and production. This makes it easy to avoid unprofitable orders and unprofitable production.

Further, according to the first embodiment, the price information calculation unit 52 calculates the result of multiplying the material cost ratio 10 and the price fluctuation amount 19 for each product as the fluctuation influence degree 20, and the priority order determination unit 53 determines. The fluctuation influence degree 20 is compared among a plurality of products, and the priority 30 is determined from the fluctuation influence degree 20. As a result, the degree to which the price fluctuation amount 19 of the market price affects the profit margin of the product can be estimated as the influence amount according to the material cost ratio 10.

Further, according to the first embodiment, there are a plurality of types of materials, the price information calculation unit 52 calculates the material cost ratio 10 for each type of material, and the priority determination unit 53 adds up the fluctuation influence degree 20. Based on the result, the priority 30 is determined. As a result, even if the market price of some of the materials contained in the product rises or falls, the degree to which the price fluctuation amount 19 of the material affects the profit margin of the product is quantitatively and comprehensively accurate. Can be estimated to.

Further, according to the first embodiment, the selling price storage unit 4 stores the selling price as a plurality of values in a plurality of regions where the product is sold. This makes it possible to grasp trends related to fluctuations in selling prices by country and region, and to formulate sales strategies by region.

FIG. 11 is a flowchart showing each step of the product profit / loss comparison method according to the first embodiment of the present invention. FIG. 12 is a flowchart showing the price information calculation process performed by the price information calculation unit 52 in the first embodiment of the present invention in more detail. The product profit / loss comparison method is a method of comparing the profit / loss of a product using a product profit / loss comparison device. Before the start of this process, the product information storage process, the market price storage process, and the selling price storage process are prepared. In the product information storage process, the product information storage unit 2 stores the component information 6 and the component information 7. In the market price storage process, the market price storage unit 3 continuously stores the market price information 31 for each material. In the selling price storage step, the selling price information 41 of the product is stored by the selling price storage unit 4. These three steps need only be prepared before the process described below, and the order of these three steps does not matter.

After the start of this process, the process proceeds to the product information calculation step of step ST1, and the product information calculation unit 51 calculates the total weight of each material contained in the product. The total weight of each material contained in each product is calculated from the part information 7. Specifically, the total weight of the material is calculated by summing the weights of the parts made of the same type of material contained in each product. Do this for all materials in all products. Next, the process proceeds to the price information calculation step of step ST2. A plurality of steps in this step are shown in FIG.

As shown in FIG. 12, in the price information calculation process, the material cost calculation stage of step ST21 is first performed, and the price information calculation unit 52 calculates the price of the material contained in each product as the material cost 9 for each material. .. The material cost 9 is obtained from the type of material forming each product, the weight of each material, and the market price information 31 for each material. Specifically, the material cost 9 is calculated by multiplying each material type by the total weight of each material and the market price of each material.

Next, the process proceeds to the material cost ratio calculation stage of step ST22, and the price information calculation unit 52 calculates the material cost ratio 10. The material cost ratio 10 is obtained by dividing the material cost 9 for each material by the selling price. Next, the process proceeds to the price fluctuation amount calculation stage of step ST23, and the price fluctuation amount 19 is calculated by the price information calculation unit 52. The price fluctuation amount 19 represents the magnitude of fluctuation in the market price of the material. Next, the process proceeds to the fluctuation impact calculation stage of step ST24, and the fluctuation impact 20 is calculated by the price information calculation unit 52. Specifically, the fluctuation influence degree 20 is calculated by multiplying the material cost ratio 10 and the price fluctuation amount 19 for each material of each product, and the fluctuation influence degree 20 of the materials constituting the product is further added up for each product. ..

Next, the process proceeds to the priority determination step of step ST3 shown in FIG. 11, and the priority determination unit 53 determines the priority 30 among the products in the order of increasing the profit margin of the products. Specifically, the total fluctuation impact 201 is compared for each product, the total fluctuation impact 201 is negative, and the product with the larger absolute value has a higher priority 30, and the total fluctuation impact 201 is positive. The higher the absolute value of the product, the lower the priority 30. The priority determination unit 53 determines the product priority 30 as the order in which sales should be expanded based on such a determination criterion. As a result, the priority determination unit 53 determines the priority 30 based on the result of multiplication of the material cost ratio and the price fluctuation amount 19.

Next, the process proceeds to the result output process of step ST4, and the priority order 30 determined in the priority order determination process of step ST3 is output to the result storage unit 14. At the same time, the total of the fluctuation influence degree 201 calculated by the price information calculation unit 52 is also sent from the price information calculation unit 52 to the result storage unit 14. Of the result information 141, some or all information including at least the priority 30 is output to the output device 15. After that, this process ends.

According to the first embodiment, the product profit / loss comparison method includes a product information storage process, a market price storage process, a product information calculation process, a price information calculation process, and a priority determination process. In the product information storage process, for a plurality of products, the type of one or more materials forming each product and the weight of the material used for each product are stored. In the market price storage process, the market price of the material is continuously stored and accumulated. In the selling price storage process, the selling price of each product is stored. In the price information calculation process, the price of the material contained in the product is calculated as the material cost 9 related to the material from the type of the material, the weight of the material, and the market price of the material. In the priority order determination step, the product priority order 30 is determined in the order of increasing the rate of return of the product from the material cost ratio 10 and the price fluctuation amount 19.

As a result, the evaluation of the profit margin for the product can be easily and frequently repeated, and it is possible to immediately respond to fluctuations in the market price of the material. Since the material price is calculated as the material cost 9 from the type, weight, and market price of the material contained in the product, the profit margin of the product can be compared more frequently and easily than when the purchase price of each part is obtained. The priority order 30 can be determined. Therefore, even if the market price of each material rises sharply in a short period of time, it is possible to immediately reconsider the policy for expanding sales and production. This makes it easy to avoid unprofitable orders and unprofitable production.

Further, according to the first embodiment, in the price information calculation step, the result of multiplying the material cost ratio 10 and the price fluctuation amount 19 is calculated as the fluctuation influence degree 20 for each product, and in the priority determination step, the fluctuation influence is calculated. The degree 20 is compared among a plurality of products, and the priority 30 is determined from the fluctuation influence degree 20. As a result, the degree to which the price fluctuation amount 19 of the market price affects the profit margin of the product can be estimated as the influence amount according to the material cost ratio 10.

Further, according to the first embodiment, there are a plurality of types of materials, and the material cost ratio 10 is calculated for each type of material in the price information calculation process, and the fluctuation influence degree 20 is added up in the priority determination process. Based on this, the priority 30 is determined. As a result, even if the market price of some of the materials contained in the product rises or falls, the degree to which the price fluctuation amount 19 of the material affects the profit margin of the product is quantitatively and comprehensively accurate. Can be estimated to.

Embodiment 2.
Next, the product profit / loss comparison device 100 according to the second embodiment of the present invention will be described below with reference to the drawings. The second embodiment is similar to the first embodiment described above, and the differences between the first and second embodiments will be mainly described below. In the second embodiment, a plurality of products belonging to the same product group are all made of the same single material. In this case, if the market price of the material rises, the material cost rises in all the products, and the profit margin decreases as the material cost ratio of 10 increases. If the market price of raw materials falls, the material cost will fall for all products, and the higher the material cost ratio of 10, the higher the profit margin. Therefore, it is determined whether the market price has risen or fallen above the standard market price, and the priority 30 is determined according to the size of the material cost ratio 10. FIG. 13 is a diagram showing an example of a transition 17 of the market price of a material according to the second embodiment of the present invention. The horizontal axis represents the range from October 2011 to October 2013 on a monthly scale. The vertical axis represents the market price of the material per kg in Japanese yen.

The market price storage unit 3 stores the information shown in FIG. 13, and the price information calculation unit 52 calculates the fluctuation of the market price shown in FIG. 13 as the price fluctuation amount 19. In the second embodiment, the price information calculation unit 52 determines the monthly price fluctuation amount 19 based on the market price of the material at the time when the selling price is determined for the product whose sale is finally determined in the product group. calculate. In the example shown in FIG. 13, the market price as of May 2012 is used as a reference, and the market price of the material at this time is 290 yen per kg. In FIG. 13, the market price of 290 yen is represented by the alternate long and short dash line D1 in the sense that the market price of the material at this time is used as a reference in the subsequent period. In the example shown in FIG. 13, the market price of the material is lower than the standard from June 2012 to January 2013, and is higher than the standard after April 2013.

FIG. 14 is a flowchart showing each step of the product profit / loss comparison method in the second embodiment of the present invention. FIG. 15 is a flowchart showing the price information calculation process performed by the price information calculation unit 52 in the second embodiment of the present invention in more detail. Before the start of this process, the product information storage process, the market price storage process, and the selling price storage process are prepared. After the start of this process, the process proceeds to the product information calculation step of step ST11, and the product information calculation unit 51 calculates the total weight of the materials contained in the product. Next, the process proceeds to the price information calculation step of step ST12, and the price information calculation unit 52 calculates the material cost 9, the material cost ratio 10, and the price fluctuation amount 19. First, as shown in FIG. 15, the process proceeds to the material cost calculation stage of step ST121, and the material cost 9 is calculated. The material cost calculation stage of step ST121 and the material cost ratio calculation stage of step ST122 shown in FIG. 15 are the same as the material cost calculation stage of step ST21 and the material cost ratio calculation stage of step ST22 shown in FIG.

At the price fluctuation amount calculation stage of step ST123 shown in FIG. 15, it is only necessary to know whether the fluctuation of the market price of the material is an upward trend or a downward trend, and therefore it is sufficient to subtract the reference market price from the latest market price. In the second embodiment, if the result of the subtraction is positive, it means an increase in the market price, and if it is negative, it means a decrease in the market price. In the second embodiment, the fluctuation influence calculation step of step ST24 shown in FIG. 12 is not necessary. After the price fluctuation amount calculation step of step ST123 shown in FIG. 15, the process proceeds to the price fluctuation amount determination step of step ST13 shown in FIG.

As shown in FIG. 14, in the price fluctuation amount determination step of step ST13, the priority order determination unit 53 determines whether the price fluctuation amount 19 is positive or negative. If the price of the material rises, the price fluctuation amount 19 becomes positive, and if the material price decreases, the price fluctuation amount 19 becomes negative. In the price fluctuation amount determination step, if the price fluctuation amount 19 is positive, that is, if the price of the material is increased, the process proceeds to the priority order determination step of step ST14, and the priority order determination unit 53 determines the priority order 30. If the price of the material rises, the higher the material cost ratio of 10, the lower the profit margin, so the priority 30 is decided lower. Next, the process proceeds to the result output step of step ST15, and the priority order 30 determined in the priority order determination step of step ST14 is output to the result storage unit 14. After that, this process ends.

If it is determined in the price fluctuation amount determination step of step ST13 that the price fluctuation amount 19 is negative, that is, the price of the material has dropped, the process proceeds to the priority determination process of step ST16, and the priority order 30 is set by the priority determination unit 53. decide. If the price of the material decreases, the higher the material cost ratio of 10, the higher the profit margin, so the priority 30 is determined higher. Next, the process proceeds to the result output step of step ST17, and the priority order 30 determined in the priority order determination step of step ST16 is output to the result storage unit 14. After that, this process ends.

According to the second embodiment of the present invention, when a plurality of products belonging to the same product group are all made of the same single material, the calculation unit 5 has a positive or negative price fluctuation amount 19. Since the priority order 30 can be determined by comparing the size of the material cost ratio 10 in consideration of the above, the calculation procedure required for the calculation of the calculation unit 5 should be less than the calculation procedure in the first embodiment. Can be done.

Embodiment 3.
Next, the product profit / loss comparison device 300 according to the third embodiment of the present invention will be described below with reference to the drawings. This third embodiment is similar to the first embodiment described above, and the differences between the first and third embodiments will be mainly described below. FIG. 16 is a diagram showing the configuration of the product profit / loss comparison device 300 according to the third embodiment of the present invention. Although the product in the third embodiment is, for example, a motor, an air conditioner, an elevator, or the like, the product for which the product profit / loss comparison device 300 according to the present invention is subject to profit / loss comparison is not limited to these.

In the third embodiment, the market price storage unit 3 stores the price after the market price is corrected by the discount due to the mass purchase of the material. The product profit / loss comparison device 300 further includes a production plan storage unit 18 and a discount information storage unit 21. The production plan storage unit 18 stores production plan information 181 for a plurality of products. The production plan information 181 is, for example, information on the number of products produced in one month, and is information on at least one of a plan currently in progress and a plan planned in the future. FIG. 17 is a diagram showing an example of production plan information 181 stored in the production plan storage unit 18 in the third embodiment of the present invention. In the example shown in FIG. 17, the first product A1 was 1,000 units in April 2013, 1,100 units in May of the same year, 900 units in June of the same year, and 1,200 units in July of the same year. , Is planned to be produced.

FIG. 18 is a diagram showing an example of production planning information 181 and material-specific weight information 11 and discount information 211 in the third embodiment of the present invention. The discount information storage unit 21 uses the discount information 211 for each material as a threshold value for how much weight of material should be purchased to receive a discount from the supplier and how much when the amount exceeding the threshold value is purchased. I remember the discount rate or the discount amount of whether or not I can receive the discount. Although the market price storage unit 3 stores the market price information 31 of each material for a plurality of materials, the market price of each material can be discounted by the supplier by purchasing a large amount of the material. There is. The production plan storage unit 18 can grasp the total weight of each material to be purchased by storing the production plan information 181 for at least one of the plan currently in progress and the plan planned in the future. It is possible to grasp whether or not a discount can be received from a supplier and the discounted price when the discount is received.

The price information calculation unit 52 acquires the production plan information 181 and the discount information 211 and collates both information, so that the price of each material to be purchased in the current or future plan is discounted from the market price. Calculate the information. In the example shown in FIG. 18B, the total purchase weight is multiplied by the market price and further multiplied by the discount rate. As a result, the price information calculation unit 52 corrects the market price information 31 and calculates the price of the material to be purchased as if it were realistic. A more specific description will be given with reference to FIG.

As shown in FIG. 18A, 300 units of the first product A1 are planned to be produced, and 0.30 kg of stainless steel is used for each unit of the first product A1. Therefore, in this production of the first product A1, it can be calculated that 90 kg of stainless steel is purchased by multiplying the number of units produced and the weight of each material. The price information calculation unit 52 calculates the purchase weight by multiplying the production volume and the weight of each material for each product. When the purchase weights of stainless steel are added up for all the products from the first product A1 to the fourth product A4, it can be seen that 6,090 kg of stainless steel is required as shown in FIG.

The discount information storage unit 21 stores a threshold value of how many materials should be purchased in the market to receive the discount. In the example shown in FIG. 18B, the purchase of 5,000 kg of stainless steel is used. Indicates that you can receive a discount. Therefore, in this case, a discount is available for the purchase of stainless steel for all products from the first product A1 to the fourth product A4. At least one of the discount rate and the discount amount is stored in the discount information storage unit 21 as the discount information 211, and the price information calculation unit 52 acquires the discount information 211 and uses it for correcting the market price. .. In the example shown in FIG. 18, the discount rate is reduced by 1% and the market price is multiplied by 99% to calculate the actual purchase price.

Although FIG. 18 shows an example of only stainless steel, the production planning information 181, the weight information 11 by material, the discount information 211, and the market price information 31 include similar information for other materials. .. The price information calculation unit 52 also calculates the same information not only for stainless steel but also for other materials. The material price information corrected by the discount information 211 is output from the price information calculation unit 52 to the market price storage unit 3, and the market price storage unit 3 adds and stores the information to the market price information 31. .. In the third embodiment, the price information calculation unit 52 handles the price of the material corrected by the discount information in the same manner as the market price in the first embodiment.

FIG. 19 is a diagram showing an example of selling price information 41 stored in the selling price storage unit 4 in the product profit / loss comparison device 300 according to the third embodiment of the present invention. The selling price storage unit 4 classifies and stores the selling price for each sales channel as a plurality of values in the plurality of sales channels where the product is sold. In FIG. 19, for example, the first product A1 has a standard price of 240 yen and an actual local selling price of 240 yen in the first sales channel, and a standard price of 240 yen and an actual local selling price in the second sales channel. Indicates that is 230 yen.

The selling price is information averaged by dividing the total selling price of each product by the number of units sold, and the number of units sold is grasped for each sales channel. By classifying the selling price information 41 by sales channel, the selling price storage unit 4 can collectively divide the total selling price of each product input from each store by the number of units sold for each sales channel, as an average value. It is possible to collectively obtain the selling price information 41 of. Further, since each sales channel can be used for transmitting the sales strategy, the sales channel can be used for both inputting the selling price information 41 and transmitting the sales strategy, and efficient information transmission can be realized.

According to the third embodiment, the market price storage unit 3 stores the price after the market price is discounted by the large-scale purchase, so that the price information calculation unit 52 is in line with the reality when actually purchasing each material. The price can be used to determine the product priority 30.

Further, according to the third embodiment, since the selling price storage unit 4 stores the selling price as a plurality of values in the plurality of sales channels where the product is sold, the selling price can be used for grasping the selling price.

FIG. 20 is a flowchart showing the price information calculation process performed by the price information calculation unit 52 in the third embodiment of the present invention in more detail. First, the process proceeds to the purchase weight calculation stage of step ST31, and the total purchase weight is calculated for each material. Specifically, the price information calculation unit 52 acquires the production plan information 181 from the production plan storage unit 18, the material-specific weight information 11 from the product information storage unit 2, and the production volume and the material-specific weight for each product. And multiply. By summing up the results of the multiplication, the total purchase weight of each material is calculated for each product. Next, the process proceeds to the discount information comparison stage of step ST32, and the total purchased weight is compared with the threshold value included in the discount information 211.

When the total purchase weight is equal to or greater than the threshold value of the discount information 211, the process proceeds to the market price correction stage of step ST33, and the market price is corrected. Specifically, the discount rate included in the discount information 211 is multiplied by the market price and the result of the multiplication is subtracted from the market price, or the discount amount included in the discount information 211 is subtracted from the market price. Next, the process proceeds to the material cost calculation stage of step ST34, and the material cost 9 is calculated. Specifically, for each product, the corrected market price for each material is multiplied by the weight for each material. Next, the process proceeds to the material cost ratio calculation stage of step ST36.

If the total purchased weight is smaller than the threshold value of the discount information 211 as a result of the comparison in the discount information comparison stage of step ST32, the process proceeds to the material cost calculation stage of step ST35 and the material cost 9 is calculated. Specifically, the market price for each material is multiplied by the weight of each material without correcting the market price. Next, the process proceeds to the material cost ratio calculation stage of step ST36. From step ST36 onward, the same as in the first embodiment, the material cost ratio 10 is calculated at the material cost ratio calculation stage of step ST36, and the price fluctuation amount 19 is calculated at the price fluctuation amount calculation stage of step ST37.

According to the product profit / loss comparison method according to the third embodiment, when each material of the product is purchased in large quantities, the market price information 31 is corrected by the discount information 211, so that the price information calculation unit 52 actually purchases each material. Realistic prices at the time of purchase can be used to determine product priority 30.

Embodiment 4.
Next, the product profit / loss comparison device 100 according to the fourth embodiment of the present invention will be described below with reference to the drawings. The fourth embodiment is similar to the first embodiment described above, and the differences between the first and fourth embodiments will be mainly described below. FIG. 21 is a diagram showing an example of selling price information 41 stored in the selling price storage unit 4 in the product profit / loss comparison device 100 according to the fourth embodiment of the present invention. The selling price storage unit 4 stores the standard price and the selling price of each product by country and region, and by sales channel.

In FIG. 21, for example, the first product A1 has a standard price of 240 yen and an actual local selling price of 240 yen in the first sales channel in country X1, and a standard price of 240 yen and an actual local selling price in the second sales channel. It shows that the selling price at is 235 yen. In addition, the first product A1 has a standard price of 240 yen and an actual local selling price of 230 yen in the third sales channel in X2 country, and a standard price of 240 yen and an actual local selling price in the fourth sales channel. It means that it is 225 yen.

FIG. 22 is a diagram showing an example of information calculated by the price information calculation unit 52 in the fourth embodiment of the present invention. The product has composite parts made of multiple types of materials. The product to be compared by the product profit / loss comparison device 100 in the fourth embodiment has a composite part composed of two kinds of materials, the ninth product is the first composite part M413, and the tenth product is the second. The case where the eleventh product has the third composite part M415 will be taken as an example of the composite part M414. The 9th product, the 10th product and the 11th product are products that can be replaced with each other and belong to the 3rd product group. Hereinafter, the fourth embodiment will be described by taking the value in the first sales channel of the X1 country as an example.

The first composite component M413 is 80% stainless steel by weight and 20% by weight aluminum. The second composite component M414 is 50% stainless steel by weight and 50% aluminum by weight. The third composite component M415 is 20% stainless steel by weight and 80% aluminum by weight. In the fourth embodiment, for a composite material composed of a plurality of materials, the unit price per weight for each composite material is calculated by multiplying the market price of each material by the weight ratio of each material in the composite material. Obtained as "composite material unit price 38". The composite material unit price 38 is the market price of the entire material forming the composite part.

FIG. 23 is a diagram showing an example of changes in market prices of stainless steel and aluminum handled in the fourth embodiment of the present invention. In FIG. 23, among the 9th to 11th products, the market price of each material at the time when the selling price of the last decided product is set as 100%, and the market condition of stainless steel and aluminum is taken. It shows the transition of the price. Each market price is the unit price per kg. In the example shown in FIG. 23, specifically, the market price as of May 2012 is used as a reference, and the market price at another time is represented with this as 100%. In FIG. 23, the reference market price is represented by the alternate long and short dash line D2.

The unit of each market price and composite material unit price 38 is unified to, for example, Japanese yen, the market price of stainless steel is expressed as S (t), the market price of aluminum is expressed as A (t), and the material forming the first composite part M413. When the market price of the composite material is expressed as the composite material unit price SA1, as shown in FIG. 22, the composite material unit price SA1 is
SA1 = 0.8S (t) + 0.2A (t) ... (1)
Can be expressed as. When the market price of the material forming the second composite part M414 is expressed as the composite material unit price SA2, the composite material unit price SA2 is
SA2 = 0.5S (t) + 0.5A (t) ... (2)
Can be expressed as. When the market price of the material forming the third composite part M415 is expressed as the composite material unit price SA3, the composite material unit price SA3 is
SA3 = 0.2S (t) + 0.8A (t) ... (3)
Can be expressed as. Specifically, S (t), A (t), SA1, SA2 and SA3 represent real numbers.

As described above, in the fourth embodiment, each composite part is made of a composite material containing each material according to the weight ratio of each material, and the market price per unit weight of the composite material, that is, the composite material unit price. After calculating 38, the material cost 9 and the material cost ratio 10 for each composite material are calculated by treating this in the same manner as the market price of one material.

FIG. 24 is a diagram showing an example of transition of each composite material unit price 38 handled in the fourth embodiment of the present invention. On the paper of FIG. 24, the transition represented by the upper polygonal line is the transition of the composite material unit price SA3 of the third composite component M415, and the transition represented by the middle polygonal line is the transition of the composite material unit price SA2 of the second composite component M414. The transition represented by the lower polygonal line is the transition of the composite material unit price SA1 of the first composite component M413. In FIG. 24, similarly to FIG. 23, the composite material unit price 38 as of May 2012 is represented as 100%. In FIG. 24, the composite material unit price 38 at this time is represented by the alternate long and short dash line D3.

As is clear from comparison with FIG. 23, the transition of the composite material unit price 38 shown in FIG. 24 is greatly affected by the transition of the market price of aluminum as the weight ratio of aluminum contained in the composite component is larger, and the transition of the composite component The greater the weight ratio of stainless steel contained, the greater the influence on the market price of stainless steel. The material cost for this composite material can be calculated by multiplying the unit price 38 of each composite material by the weight of each component. In the same way as the material cost 9 of each material was obtained in the first embodiment, the material cost of the composite material is obtained in the fourth embodiment, and this is referred to as the “composite material cost”. By dividing the composite material cost by the selling price, the ratio of the composite material cost to the selling price of each product, that is, the composite material cost ratio 40 can be calculated.

As shown in FIG. 22, the component weight of the first composite component M413 is W1, the component weight of the second composite component M414 is W2, and the component weight of the third composite component M415 is W3. The unit of weight of each part is kg. W1, W2 and W3 specifically represent real numbers. The selling price of the 9th product is P1, the selling price of the 10th product is P2, and the selling price of the 11th product is P3. The unit of each selling price is the currency of the country where the product profit / loss comparison device is used, and in Japan it is the Japanese yen. Regarding the ninth product, the composite material cost ratio 40 for the material forming the first composite part M413 is defined as Y1. For the tenth product, the composite material cost ratio 40 for the material forming the second composite part M414 is Y2, and for the eleventh product, the composite material cost ratio 40 for the material forming the third composite part M415 is Y3. The respective composite material cost ratios Y1, Y2 and Y3 are
Y1 = (SA1 ・ W1) / P1 ・ ・ ・ (4)
Y2 = (SA2 ・ W2) / P2 ・ ・ ・ (5)
Y3 = (SA3 ・ W3) / P3 ・ ・ ・ (6)
It can be expressed as. Specifically, P1, P2, P3, Y1, Y2 and Y3 represent real numbers.

In the first embodiment, the price information calculation unit 52 calculates the material cost ratio 10 for each material contained in each product, but in the fourth embodiment, the price information calculation unit 52 calculates the composite material unit price for the parts made of the composite material. After calculating 38, the composite material cost for each composite material is calculated by multiplying each composite material unit price 38 by the total weight of each component. The price information calculation unit 52 calculates the ratio of the composite material cost of each product to the selling price of each product as the composite material cost ratio 40.

When calculated in this way, it can be determined from FIG. 24 whether the composite material unit price 38 of the composite material forming each composite part has increased or decreased from the composite material unit price 38 at the time of reference. For example, in FIG. 24, as of August 2012, the composite material unit price 38 of all of the first composite part M413 to the third composite part M415 has decreased as compared with the time of May 2012. As of November 2012, the composite unit price 38 of the first composite part M413 and the second composite part M414 has decreased compared to the time of May 2012, but the composite unit price of the third composite part M415 has increased. doing. As of December 2012, the composite unit price 38 of the first composite component M413 has decreased compared to the time of May 2012, but the composite unit price of the second composite component M414 and the third composite component M415 has increased. doing.

FIG. 25 is a diagram showing a fluctuation influence degree 20 calculated by the price information calculation unit 52 in the fourth embodiment of the present invention. For each product from the first composite part M413 to the third composite part M415, as shown in FIG. 24, the fluctuation amount 39 of the composite material unit price calculated based on the time of May 2012 is displayed as a percentage, and each is F1%. Let it be F2% and F3%. The fluctuation amounts F1, F2 and F3 of the composite material unit price are multiplied by the composite material cost ratios Y1, Y2 and Y3 calculated as described above, respectively. As a result, the fluctuation influence degree 20 due to the price fluctuation amount 19 is calculated for each product from the first composite component M413 to the third composite component M415. Specifically, F1, F2 and F3 represent real numbers.

The fluctuation influence degree 20 can be added up with the fluctuation influence degree 20 relating to other materials, as in the calculation in the first embodiment. As a result of this summation, a total of 201 fluctuation influence is calculated. As described above in the explanation with reference to FIG. 10, the total degree of fluctuation influence 201 is negative, the more the fluctuation of the market price affects the direction of increasing the profit margin for the product. The more positive the total fluctuation impact is 201, the more the fluctuation of the market price affects the direction of lowering the profit margin on the product. Based on such a policy, the calculation unit 5 determines the priority order 30 for each product from the ninth product to the eleventh product, and outputs the result information 141 to the result storage unit 14. In the fourth embodiment, not only the first sales channel in the X1 country but also other countries and other sales channels are calculated in the same manner as described above for the first sales channel in the X1 country.

In the fourth embodiment, the product profit / loss comparison device 100 targets a product composed of two types of materials, but the material constituting the product may be one type or three or more types. Multiply the fraction of the weight ratio of each material by the market price of each material, and add up the multiplication results for all the materials that make up the composite part to get the market price per unit weight for the entire material that makes up the composite part. Can be calculated. In this way, the price information calculation unit 52 calculates the market price of the entire material forming the composite part, that is, the composite material unit price 38, and uses this for calculating the material cost 9 of the product. This makes it possible to estimate changes in the production cost of products from fluctuations in market prices of materials. Therefore, the profit margins of the products can be easily compared and the priority 30 can be determined more frequently than in the case of obtaining the purchase price of individual parts.

FIG. 26 is a flowchart showing the price information calculation process performed by the price information calculation unit 52 in the fourth embodiment of the present invention in more detail. First, the process proceeds to the material ratio calculation stage of step ST41, and the weight ratio of the materials contained in each composite part is calculated from the weight information 11 for each material. Next, the process proceeds to the composite material unit price calculation stage of step ST42, and the composite material unit price 38 is calculated. Specifically, as shown in equations (1) to (3), the market unit price of each material is multiplied by the weight ratio fraction, and the result of the multiplication is added up for all the materials contained in the composite component. By doing so, the composite material unit price 38 is calculated. Next, the process proceeds to the composite material fluctuation amount calculation stage of step ST43, and the composite material unit price fluctuation amount 39 is calculated. Specifically, the latest composite material unit price 38 is divided by the composite material unit price 38 at the time of reference to obtain the amount of fluctuation. The composite material unit price at the time of reference is calculated by the same procedure as the procedure for calculating the composite material unit price 38 based on the market price at the time of reference.

Next, the process proceeds to the composite material cost calculation stage in step ST44, and the composite material cost is calculated. Specifically, it is obtained by multiplying the composite material unit price 38 and the weight of each part for each product. Next, the process proceeds to the composite material cost ratio calculation stage of step ST45, and the composite material cost ratio 40 is calculated for each product. This is done by calculating the composite material cost, which is the result of multiplying the composite material unit price 38 and the weight of each product, as shown in formulas (4) to (6), and dividing the result of this calculation by the selling price. It is calculated. Next, the process proceeds to the fluctuation impact calculation stage of step ST46, and the fluctuation impact 20 is calculated. As shown in FIG. 25, the fluctuation influence degree 20 is calculated by multiplying the fluctuation amount 39 of the composite material unit price and the composite material cost ratio 40, and the fluctuation amount of each composite material unit price is the rate of return of each product. Indicates the degree of influence on. After that, as in the first embodiment, the priority determination unit 53 compares the total 201 of the fluctuation influences, and determines the order in the order in which the products have the highest profit margins to determine the priority 30 to be expanded. You just have to decide.

According to the product profit / loss comparison method according to the fourth embodiment, regardless of whether the material constituting the part is one type or two or more types, the market price of each material is multiplied by the weight ratio fraction and added up. By doing so, the unit price of the composite material per unit weight can be calculated for the composite material constituting the component. This makes it possible to estimate changes in the production cost of products from fluctuations in market prices of materials. Simply, as shown in FIG. 24, it is possible to grasp whether the composite material unit price 38 of any of the composite parts has increased or decreased from the reference point by simply judging from the transition of the composite material unit price 38. Therefore, based on the composite material unit price 38, it can be determined whether the fluctuation of the market price improves or lowers the profit margin of each composite part.

Further, as shown in FIG. 25, the ratio of the composite material cost to the selling price for each product is calculated as the composite material cost ratio 40, and the composite material cost ratio 40 is multiplied by the fluctuation amount 39 of the composite material unit price, and the multiplication thereof is performed. The result of is calculated as the fluctuation influence degree 20. As a result, the degree of influence of fluctuations in market prices on the profit margin of each product can be grasped in detail from the degree of fluctuation impact 20 by calculating the degree of fluctuation impact 20 via the amount of fluctuation 39 of the composite material unit price. .. Therefore, the priority 30 to be expanded among a plurality of products can be accurately determined. Since all the information required for the product profit / loss comparison device 100 and the product profit / loss comparison method according to the fourth embodiment is easily available information, it is higher than the case where the purchase price of each part is obtained. The profit margins of products can be easily compared by frequency, and the priority 30 of products to be expanded can be determined.

In the first embodiment, the price information calculation unit 52 calculates the price fluctuation amount 19 by dividing the current month's market price for each material by the previous month's market price. Further, in the second to fourth embodiments, the price information calculation unit 52 determines that the product to be sold last in the product group when the price fluctuation amount 19 or the composite material unit price fluctuation amount 39 is calculated. The market price of each material at the time the selling price was decided was used as the standard. However, the method of calculating the amount of price fluctuation is not limited to this. In another embodiment, the price information calculation unit may calculate the price fluctuation amount by dividing the market price of each material in the current month by the market price of the material in the same month of the previous year. In still another embodiment, the price information calculation unit may calculate the price fluctuation amount of the current month by dividing the market price of each material in the current month by the market price of each material at a specific time point. ..

In the first to fourth embodiments, the market price storage unit 3 stores the market price every month and continuously accumulates the market price, but in other embodiments, the market price storage unit stores the market price every day. You may memorize the market price of and continuously accumulate it. Since the market price is information that can be obtained on a daily basis, it is possible to obtain information more frequently and easily than when finding the part price for each part contained in the product and using it to calculate the profit margin. The calculation based on the information obtained can be repeated with high frequency. Therefore, policies regarding sales and production expansion can be reviewed frequently.

In the first to fourth embodiments, the material cost 9, the material cost ratio 10 and the composite material cost ratio 40 are calculated by the price information calculation unit 52 based on the latest market price stored in the market price storage unit 3. However, the material cost, material cost ratio and composite material cost ratio do not necessarily have to be based on the latest market prices. Since it is the price fluctuation amount 19 or the composite material unit price fluctuation amount 39 that most clearly reflects the fluctuation of the market price of the material, the material cost, the material cost ratio, and the composite material unit price fluctuation amount in other embodiments are , May be calculated based on the market price of the previous month. In still another embodiment, the price information calculation unit may calculate the fluctuation amount of the material cost, the material cost ratio, and the composite material unit price based on the market price of each material at a specific time point. For example, the market price of each material at the time when the selling price of the product whose sale is decided last in the product group may be used as a reference.

In the third embodiment, the price information calculation unit 52 adds up the purchase weights of each material for the products in the substitutable product group and compares them with the threshold value of the discount information 211, but the total purchase weight and the discount information 211 are plural. Since the information can be used to correct the market price regardless of the fact that the product is substitutable, the comparison between the total purchased weight by the price information calculation unit and the threshold of the discount information is the product in the substitutable product group. It is not limited to. In other embodiments, the purchase weights of the respective materials may be summed for all products and the summed result may be compared to the discount information threshold.

It should be noted that each embodiment is exemplified in order to embody the technique according to the present invention, and does not limit the technical scope of the present invention. In the present invention, each embodiment can be freely combined, and each embodiment can be appropriately modified or omitted within the scope of the invention.

2 Product information storage unit, 3 Market price storage unit, 4 Selling price storage unit, 5 Calculation unit,
6 component information, 7 part information, 9 material cost, 10 material cost ratio,
11 Weight information by material, 12 Product classification information, 13 Input device, 14 Result storage unit,
15 Output device, 16 Computer, 17 Market price transition, 18 Production planning storage unit, 19 Price fluctuation amount, 20 Fluctuation impact, 21 Discount information storage unit, 30 Priority,
31 Market price information, 38 Composite material unit price, 39 Composite material unit price fluctuation amount,
40 Composite material cost ratio, 41 Selling price information, 51 Product information calculation department, 52 Price information calculation department, 53 Priority determination department, 100, 300 Product profit / loss comparison device, 141 Result information,
181 production planning information, 201 total fluctuation impact, 211 discount information.

Claims (8)

For a plurality of products, a product information storage unit that stores the type of one or more materials forming each product and the weight of the material used for each product,
The market price storage unit that continuously stores and accumulates market prices for the materials,
A selling price storage unit that stores the selling price of each product,
A price information calculation unit that calculates the price of the material included in the product as the material cost related to the material based on the type of the material, the weight of the material, and the market price of the material.
The ratio of the material cost to the selling price is calculated as the material cost ratio.
A price information calculation unit that calculates the amount of fluctuation in the market price of the material as the amount of price fluctuation,
A product profit / loss comparison device having a priority determination unit that determines priorities among the products in order of increasing the rate of return of the products from the material cost ratio and the price fluctuation amount. The price information calculation unit
For each of the products, the result of multiplying the material cost ratio by the price fluctuation amount is calculated as the fluctuation influence degree.
The priority determination unit compares the degree of influence of fluctuation among the plurality of products.
The product profit / loss comparison device according to claim 1, wherein the priority is determined from the degree of influence of fluctuation. There are multiple types of the material,
The price information calculation unit calculates the material cost ratio and the fluctuation influence degree for each type of the material.
The product profit / loss comparison device according to claim 2, wherein the priority order determining unit determines the priority based on the result of summing the fluctuation influence degrees of a plurality of types of the materials. The product profit / loss comparison device according to any one of claims 1 to 3, wherein the selling price storage unit stores the selling price as a plurality of values in a plurality of regions where the product is sold. The product profit / loss comparison device according to any one of claims 1 to 4, wherein the selling price storage unit stores the selling price as a plurality of values in a plurality of sales channels where the product is sold. The market price storage unit stores the price after the market price is discounted by a large-scale purchase of the material, and the price information calculation unit calculates the material cost from the discounted price. The product profit / loss comparison device according to any one of claims 1 to 5. The product has composite parts made of multiple types of materials.
The price information calculation unit multiplies the fraction of the weight ratio of each material in the composite part by the market price of each material, and adds up the results of the multiplication for all the materials forming the composite part. The product profit / loss comparison according to any one of claims 1 to 6, wherein the summed result is used as the market price of the entire material forming the composite part to calculate the material cost of the entire material forming the composite part. apparatus. For multiple products, and product information storage憶部storing one or more kinds of materials constituting each product, and the weight of the material used for each product,
A market price Symbol憶部that continuously stores accumulated market prices for the material,
And selling price Symbol憶部for storing the selling price of each product,
Computers equipped with
A price information calculation process for calculating the price of the material included in the product as a material cost related to the material based on the type of the material, the weight of the material, and the market price of the material.
The ratio of the material cost to the selling price is calculated as the material cost ratio.
A price information calculation process that calculates the amount of fluctuation in the market price of the material as the amount of price fluctuation,
A product profit / loss comparison method for executing a priority determination step of determining priorities among the products in descending order of the rate of return of the products based on the material cost ratio and the price fluctuation amount.

Images