JP7097500B1 - Output program, output device and output method - Google Patents

Abstract

An output program, an output device, and an output method for calculating and outputting a company's degree of dependence on a target company in a commercial distribution area. In a commercial flow area analysis system in which an analysis device, a company information DB, and a user terminal are connected to each other via a network so as to be able to communicate with each other, an output program for calculating and outputting a company's degree of dependence on a target company in the commercial flow area is , obtaining the target company from the request, preparing data for calculating the degree of dependence, calculating the degree of influence, creating a directed graph, and transmitting the directed graph to the user terminal. [Selection drawing] Fig. 10

Description

Patent Law Article 30 Paragraph 2 Applicable Published as shown in the attached list of proposals

The present invention relates to an output program or the like that outputs the degree of dependence between companies.

In the management of a company, it is important to analyze the interdependence between multiple businesses and the impact of the impact on a specific business on the entire company. In this regard, Patent Document 1 proposes a method for creating a business association table that analyzes the interdependence between a plurality of businesses in a company and simulates the impact of the impact on a specific business on other businesses or the entire company. Has been done.

Japanese Unexamined Patent Publication No. 2010-224769

On the other hand, in the trading network formed by large companies (such as the top companies in the supply chain, hereinafter referred to as "top companies") and their subcontractor groups (hereinafter referred to as "commercial distribution areas"), the performance of the top companies. Fluctuations affect the performance of companies that exist within the commercial distribution area, such as subcontractors that have no direct business relationship. Therefore, it is hard to say that even a company that is trying to diversify risks by dealing with multiple companies has succeeded in diversifying risks if the business partners are within the same commercial distribution area. Therefore, the degree of dependence of each company on the commercial distribution area is an important index for judging the state of risk in corporate management. However, at present, there is not sufficient performance data for indirect business-to-business transactions that do not have direct transactions, so it is not possible to grasp the highly accurate dependence on the top companies in the commercial distribution area. In calculating the degree of dependence, it is necessary to determine the starting company. In this specification, the company that is the starting point is referred to as the company of interest. The top company is an example of a company of interest. The company of interest is not limited to the top company, but can be determined from among the companies included in the supply chain.

The present invention has been made in view of such circumstances. The purpose is to provide an output program or the like that calculates and outputs the dependence of a company on a company of interest in the commercial distribution area.

The output program according to one aspect of the present application acquires the share of the primary transaction volume, which is the share of the transaction volume with the company of interest, in the sales of the primary transaction company having a business relationship with the company of interest, and the share of the primary transaction volume. Is multiplied by 100% to calculate the degree of primary spillover, and the sales amount of the (n + 1) primary trading company that has a business relationship with the nth trading company (n is a natural number) is multiplied by the transaction amount with the nth trading company. Acquires the (n + 1) order trading volume share occupied by, and multiplies the (n + 1) order trading volume share by the nth order spillover degree. Iteratively calculated up to, and for each company belonging to at least one of the nth-order trading company to the m-th order trading company (m is a value of n satisfying the predetermined condition) It is characterized in that a computer performs a process of calculating a degree and outputting the company and the dependency in association with each other for each company.

In one aspect of the present application, it is possible to calculate and output the dependence of a company on the company of interest in the commercial distribution area.

It is explanatory drawing which shows the structural example of the commercial category analysis system. It is a block diagram which shows the hardware configuration example of an analyzer. It is a block diagram which shows the hardware configuration example of a user terminal. It is explanatory drawing which shows the example of the sales | sales DB. It is explanatory drawing which shows the example of the transaction volume DB. It is explanatory drawing which shows the example of the transaction volume share DB. It is explanatory drawing which shows the calculation example of the ripple degree. It is explanatory drawing which shows the calculation result of the ripple degree. This is an example of a directed graph showing a business relationship. It is a flowchart which shows the procedure example of a main process. It is a flowchart which shows the procedure example of the data preparation process. It is a flowchart which shows the procedure example of the spillover degree calculation process. It is explanatory drawing which shows the expression example of the transaction relation by circle packing. It is explanatory drawing which shows the expression example of the transaction relation by circle packing. It is explanatory drawing which shows the expression example of the transaction relation by circle packing. It is explanatory drawing which shows the expression example of the business relation by a sunburst. It is explanatory drawing which shows the expression example of the transaction relation by the tree map. It is explanatory drawing which shows the expression example of the business relation by icicle.

Hereinafter, embodiments will be described with reference to the drawings. FIG. 1 is an explanatory diagram showing a configuration example of a commercial category analysis system. The commercial distribution area analysis system 100 includes an analysis device (output device) 1, a company information DB (Database) 2, and a user terminal 3. The analyzer 1, the company information DB 2, and the user terminal 3 are communicably connected to each other by the network N. The analyzer 1 is composed of a server computer, a PC (Personal Computer), and the like. Further, the analyzer 1 may be composed of a multi-computer composed of a plurality of computers, a virtual machine virtually constructed by software, or a quantum computer. Further, the function provided in the analyzer 1 may be realized by a cloud service. The user terminal 3 is composed of a notebook computer, a tablet computer, a smartphone, or the like.

The company information DB 2 stores information about a plurality of companies. Corporate information includes basic information of each company (company code, trade name, representative, location, telephone number, company URL, listing classification, date of establishment, capital, business content, bank, number of employees, etc.) , Officer composition, shareholder composition, parent-subsidiary relationship, past performance, future performance outlook, business partners (suppliers and customers), actual values of direct transactions with business partners, financial statements, etc. If the actual value of the direct transaction with the business partner has not been obtained, the estimated value is used. The actual value and estimated value of direct transactions with business partners are hereinafter referred to as "transaction volume".

FIG. 2 is a block diagram showing a hardware configuration example of the analyzer. The analyzer 1 includes a control unit 11, a main storage unit 12, an auxiliary storage unit 13, a communication unit 14, and a reading unit 15. The control unit 11, the main storage unit 12, the auxiliary storage unit 13, the communication unit 14, and the reading unit 15 are connected by a bus B.

The control unit 11 has one or a plurality of arithmetic processing units such as a CPU (Central Processing Unit), an MPU (Micro-Processing Unit), and a GPU (Graphics Processing Unit). The control unit 11 reads and executes the control program 1P (output program, program product) stored in the auxiliary storage unit 13 to perform various information processing, control processing, and the like related to the analyzer 1, and has various functions. Realize the part. For example, the functional unit is a first acquisition unit, a first calculation unit, a second acquisition unit, a second calculation unit, a third calculation unit, and an output unit.

The main storage unit 12 is a SRAM (Static Random Access Memory), a DRAM (Dynamic Random Access Memory), a flash memory, or the like. The main storage unit 12 temporarily stores data necessary for the control unit 11 to execute arithmetic processing.

The auxiliary storage unit 13 is a hard disk, SSD (Solid State Drive), or the like, and stores a control program 1P and various DBs (Databases) necessary for the control unit 11 to execute processing. The auxiliary storage unit 13 stores the sales DB 131, the transaction volume DB 132, and the transaction volume share DB 133. The auxiliary storage unit 13 is separate from the analyzer 1 and may be an externally connected external storage device. Various DBs and the like stored in the auxiliary storage unit 13 may be stored in a database server or cloud storage different from the analyzer 1.

FIG. 3 is a block diagram showing a hardware configuration example of a user terminal. The user terminal 3 includes a control unit 31, a main storage unit 32, an auxiliary storage unit 33, a communication unit 34, an input unit 35, and a display unit 36. Each configuration is connected by bus B.

The control unit 31 controls each hardware unit according to the control program 3P stored in the auxiliary storage unit 33. The main storage unit 32 is, for example, a SRAM, a DRAM, or a flash memory. The main storage unit 32 temporarily stores data generated when the program is executed by the control unit 31. The auxiliary storage unit 33 is, for example, a hard disk or SSD. The auxiliary storage unit 33 stores various data.

The communication unit 34 communicates with the analyzer 1 via the network N. Further, the control unit 31 may use the communication unit 34 to download the control program 3P from another computer via the network N or the like and store it in the auxiliary storage unit 33.

The input unit 35 is a keyboard or a mouse. The display unit 36 includes a liquid crystal display panel and the like. The display unit 36 displays the credit information acquired from the company information DB 2 and the degree of dependence acquired from the analyzer 1. Further, a touch panel display in which the input unit 35 and the display unit 36 are integrated may be configured. The user terminal 3 may display on an external display device.

The outline of the commercial distribution area analysis performed by the analyzer 1 will be described below. In the commercial distribution analysis, the starting company is first determined. It is usually the top company in the supply chain. Next, the company (primary transaction company) that is subcontracting the company of interest is specified. Further, a company that has a transaction with a primary transaction company (secondary transaction company), a company that has a subcontract transaction with a secondary transaction company (tertiary transaction company), and so on are specified in order. Next, the ratio of the transaction volume of the primary trading company to the sales of the target company (primary transaction volume share) is obtained. Furthermore, the ratio of the transaction volume of the secondary trading company to the sales of the primary trading company (secondary trading volume share), and the ratio of the trading volume of the tertiary trading company to the sales of the secondary trading company (3). Next transaction volume share), ... are calculated in sequence. Using the transaction volume share, the degree of influence (primary ripple degree) of the sales fluctuation of the company of interest on the sales of the primary trading company is calculated. From the calculated primary spillover degree and secondary transaction volume, the spillover degree (secondary spillover degree) of the secondary trading company is obtained. Similarly, the third-order spillover degree, the fourth-order spillover degree, and so on are sequentially obtained. The calculation is performed until the spillover degree becomes a sufficiently small value. For example, it is performed until the total ripple rate of the same level becomes equal to or less than the threshold value. Hereinafter, it is assumed that the ripple degree is calculated up to the mth order. Then, the total of the m-th order spillover degree is calculated from the 1 spillover degree for each of the same trading companies. The total value indicates the magnitude of the influence of the sales fluctuation of the company of interest on the trading company (here, referred to as the degree of dependence). It is desirable to create a directed graph showing the business relationship and show the degree of ripple and dependence together with the directed graph.

Next, the database used in the commercial category analysis system 100 will be described. FIG. 4 is an explanatory diagram showing an example of a sales DB. The sales DB 131 is a summary of the sales of each company. The unit is, for example, one million yen. The sales DB 131 may be created by extracting the sales of the target company and the trading company to be processed from the company information DB 2.

FIG. 5 is an explanatory diagram showing an example of a transaction volume DB. The transaction volume DB 132 is a summary of the transaction volume between the two companies. The unit is, for example, one million yen. The ordering companies are lined up horizontally and the ordering companies are lined up vertically. The transaction amount DB 132 may be created by extracting the transaction amount between the target company to be processed and the two companies included in the transaction company from the company information DB2. If the transaction volume is unknown, the estimated value may be used. It is desirable that the transaction volume calculation period is the same as the sales calculation period.

FIG. 6 is an explanatory diagram showing an example of a transaction volume share DB. The transaction volume share DB 133 is a collection of transaction volume shares. The transaction volume share is the transaction volume divided by the sales of the ordering company. The transaction volume share DB 133 is created based on the sales volume DB 131 and the transaction volume DB 132. In FIG. 6, the blank means 0.

Next, the commercial distribution area analysis will be explained assuming a case. In the following explanation, the company G0A is the company of interest. The primary trading companies are T1A and T1B. The secondary trading companies are T2A and T2B. The tertiary trading companies are T3A and T3B. It is assumed that the sales and transaction volume of each company are the values shown in FIGS. 4 and 5 described above. Figure 6 shows the transaction volume share calculated from sales and transaction volume.

FIG. 7 is an explanatory diagram showing a calculation example of the degree of ripple. The n-th order spillover is defined as the transaction volume share × (n-1) spillover degree. However, the 0th order ripple degree = 100%. Since the primary transaction company has a direct transaction with the company of interest, the 0th order ripple is 100%. First, the primary spillover degree will be described. The primary trading companies that have direct transactions with G0A are T1A and T1B. As shown in the transaction volume share DB 133 of FIG. 6, the transaction volume share of G0A in T1A is 70%, and that of T1B is also 70%. Therefore, the primary spillover of T1A and T1B is 70% × 100%, which is 70%.

Next, the secondary spillover degree will be described. The secondary trading companies that have transactions with T1A are T1B, T2A, and T2B. In T1B, the trading volume share of T1A is 20%. In T2A, the trading volume share of T1A is 100%. In T2B, T1A's trading volume share is 25%. The secondary trading company that has a transaction with T1B is T2B. In T2B, the trading volume share of T1B is 50%. The secondary spillover of T1B is 20% × 70%, which is 14%. The secondary spillover of T2A is 100% × 70%, which is 70%. The secondary spillover of T2B through T1A is 25% x 70%, which is 17.5%. The secondary spillover of T2B through T1B is 50% x 70%, which is 35%.

When the third-order spillover degree is calculated from the obtained second-order spillover degree, as shown in FIG. 7, T2B is 7% via T1B, 17.5% via T2A, and T3A is 70% via T2A. Is. T3B is 35% via T1A, T2A, 4.375% via T1A, T2B, and 8.75% via T1B, T2B. After that, it is possible to obtain the fourth-order ripple and subsequent degrees by the same calculation method.

FIG. 8 is an explanatory diagram showing the calculation result of the ripple degree. In FIG. 8, the calculation is performed up to the 10th order ripple degree. Here, as a condition for discontinuing the ripple degree calculation, it is assumed that the total ripple degree is less than 0.01%. Here, as shown in FIG. 8, the total spillover degree of the 10th order is 0.005%, which is less than 0.01%, so that the 10th order is discontinued. Then, the total of the first-order spillover degree to the tenth-order spillover degree is the dependence. In FIG. 8, the blank means 0.

FIG. 9 is an example of a directed graph showing a business relationship. The directed graph is displayed on the user terminal 3, for example. The vertices of the directed graph indicate the company. The directed side of the directed graph shows the business relationship. The source of the directed side indicates the ordering company, and the destination of the directed side indicates the ordering company. The label on the directed side indicates (transaction volume) x (dependency of the ordering company). Inside the figure representing the apex, the company name, transaction volume / sales corresponding to the dependency, and (dependency) are described.

By outputting the directed graph shown in FIG. 9 to the user, it is possible to list the transaction relationship and the degree of dependence. In addition, since the amount of dependence converted into the transaction amount is also displayed, the degree of dependence can be grasped as an amount.

Next, the information processing performed by the analyzer 1 will be described. FIG. 10 is a flowchart showing an example of the procedure of the main process. Processing is started by a request from the user terminal 3. The request includes information on the company of interest. The control unit 11 of the analyzer 1 acquires the company of interest from the request (step S1). The control unit 11 prepares data for calculating the dependency (step S2). The control unit 11 calculates the ripple degree (step S3). The control unit 11 creates a directed graph (step S4). The control unit 11 transmits the directed graph to the user terminal 3 (step S5), and ends the process.

FIG. 11 is a flowchart showing a procedure example of the data preparation process. The control unit 11 identifies the related company (step S11). The related companies are the primary company that has a direct transaction with the company of interest, the secondary company that has a transaction with the primary company, the tertiary company that has a transaction with the secondary company, and so on. The control unit 11 identifies related companies with reference to the company information DB 2. The control unit 11 creates a sales table of the company of interest and related companies (step S12). The control unit 11 stores the created sales table in the sales DB 131. The control unit 11 creates a transaction volume table including the transaction volume between the company of interest and the affiliated company and the transaction volume between the affiliated companies (step S13). The control unit 11 stores the created transaction volume table in the transaction volume DB 132. The control unit 11 creates a transaction volume share table from the sales volume table and the transaction volume table (step S14). The control unit 11 stores the created transaction volume share table in the transaction volume share DB 133. The control unit 11 returns the process to the caller. The sales table, transaction volume table, and transaction volume share table may be created in advance instead of being created each time.

FIG. 12 is a flowchart showing a procedure example of the ripple degree calculation process. The control unit 11 makes initial settings (step S21). For example, the control unit 11 reads the condition setting for discontinuing the ripple degree calculation from the auxiliary storage unit 13 or the like. The control unit 11 assigns 1 to the loop variable i (step S22). The control unit 11 calculates the i-order spillover degree for each i-order company (step S23). The control unit 11 calculates the total i-order ripple degree (step S24). The control unit 11 determines whether or not the total is less than the threshold value α (step S25). When the control unit 11 determines that the total is equal to or greater than the threshold value α (NO in step S25), the loop variable i is incremented by 1 (step S26). The control unit 11 returns the process to step S23. When the control unit 11 determines that the total is less than the threshold value α (YES in step S25), the control unit 11 calculates the dependence of each related company (step S27), and returns the process to the caller.

In FIG. 12, the condition for discontinuing the calculation of the ripple degree is not limited to the condition that the total value of the ripple degree is less than the threshold value α. The order of spillover may be a condition. For example, when calculating up to the 10th order ripple degree, the loop variable i = 10 is the censoring condition.

Ripple degree calculation can be executed by matrix operation. Hereinafter, the description will be described with reference to the examples shown in FIGS. 6 to 8. Assuming that the transaction volume share matrix is R, the matrix R is given by the equation (1). R shown below is a matrix representation of the transaction volume share DB 133 shown in FIG.

_Assuming that the k-th order spillover degree from the company i of interest is Sik, _Sik is obtained by the equation (2).

S _ik is a row vector. Further, in S _i0 , the element of the i row is 1, and the element of the other rows is 0. Here, S _i0 is the equation (3).

From equations (1) to (3), the primary spillover degree _Si1 can be obtained by equation (4).

The result of equation (4) is consistent with the degree of primary spillover shown in FIG. From the equation (4) and the equation (2), the secondary spillover degree _Si2 can be obtained by the equation (5).

Further, from the equation (5) and the equation (2), the third-order ripple degree _Si3 can be obtained by the equation (6).

The result of the formula (5) is consistent with the secondary spillover degree shown in FIG. 8, and the result of the formula (6) is consistent with the tertiary spillover degree shown in FIG.

The degree of dependence Di on company _i , which is the total degree of ripple effect for each related company, can be obtained by equation (7).

Further, the convergence condition of the ripple degree can be expressed by the equation (8). However, when k = l, it is assumed that the convergence has occurred.

As described above, the ripple degree calculation can be executed by matrix operation. By coding in a programming language with built-in matrix operations, such as Python, it is possible to briefly describe the source code for spillover degree calculation. Further, since the matrix operation is executed by the library prepared in advance, it can be expected that the execution efficiency will be higher than the case of coding the matrix operation. The programming language is Python, but it is not limited to that, and SAS language and R language may be used.

In this embodiment, the following effects are obtained. The degree of dependence on the company of interest can be calculated not only for the primary company that has a direct transaction with the company of interest, but also for the secondary company that has a transaction with the primary company. As in the case of the company T2B in the above example, even if there is a transaction with the company T2A in the same hierarchy from the viewpoint of the company of interest, it is possible to calculate the dependency in consideration of the transaction. Further, even when there is a transaction with a company having a lower hierarchy such as company T1B, it is possible to calculate the dependency in consideration of the transaction. In addition, even when the above-mentioned complicated transaction relationships are taken into consideration, the matrix operation is used, so that the dependency can be calculated efficiently. Further, by expressing and displaying the calculation result of the dependency degree in a directed graph as shown in FIG. 9, it is possible to list the transaction relationship and the dependency degree. The company of interest as the starting point for calculating the degree of dependence may be arbitrarily specified. For example, in the above example, if a company other than G0A is designated as the company of interest, the dependence of each company is calculated for the commercial distribution area in which the designated company is the company of interest.

By using the degree of dependence, the following effects are achieved. When the sales of the company of interest increase or decrease, it becomes possible to grasp the scale of influence on the companies within the commercial distribution area. If a subcontractor goes bankrupt or the production volume of the subcontractor decreases, it will be possible to understand the impact on the company of interest and the entire commercial distribution area.

In the above, the company of interest is one company, but it is not limited to this. It is possible to analyze by setting multiple companies as the companies of interest. For example, it can be used for grouping by specific area / industry and analyzing the impact on neighboring companies.

(Method of expressing business relationships)
An example of a directed graph is shown in FIG. 9 as an expression method showing a relationship between a company of interest and a company having direct or indirect transactions, but the present invention is not limited to this. In the following, expression methods other than directed graphs will be described.

(Circle packing)
13, 14 and 15 are explanatory views showing an example of expressing a business relationship by circle packing. Circle Packing is a nested circle that contains multiple circles. In the expression by circle packing, each circle represents one company. The business relationship is expressed by the inclusion of the yen. Companies that include yen are ordering companies. Companies included in the yen are contractors. The diameter of the included circle expresses the dependence of the ordering company on the ordering company.

FIG. 13 shows the business relationship of the company of interest. Yen C0 represents the company of interest. Yen C11, Yen C12, etc. included in Yen C0 indicate a primary company having a direct business relationship with the company of interest. Yen C11 indicates DHK Co., Ltd., and Yen C12 indicates TYAO Co., Ltd. Since the diameter of the circle C11 is larger than the diameter of the circle C12, it is expressed that DHK Co., Ltd. is more dependent on the company of interest than TYAO Co., Ltd.

FIG. 14 corresponds to a partially enlarged view of FIG. FIG. 14 is an enlarged display of the circle C11. The transition from FIG. 13 to FIG. 14 is performed, for example, as follows. In FIG. 13, the mouse pointer is moved inside the circle C11. The shape of the mouse pointer changes from the normal arrow shape to the hand shape. Further, the circumference of the circle C11 is displayed slightly thicker. When the mouse is clicked in this state, the state transitions to the state shown in FIG. Yen C21, Yen C22, Yen C23, etc. included in Yen C11 indicate companies having a direct business relationship with DHK Co., Ltd. corresponding to Yen C11. Yen C21 indicates SDS Co., Ltd., Yen C22 indicates MAT Co., Ltd., and Yen C23 indicates TRI Co., Ltd. SDS Co., Ltd., MAT Co., Ltd., and TRI Co., Ltd. are secondary companies that indirectly deal with the company of interest via DHK Co., Ltd. The magnitude of the diameter of the circle C21, the circle C22, the circle C23, etc. indicates the degree of dependence of SDS Co., Ltd., MAT Co., Ltd., and TRI Co., Ltd. on DHK Co., Ltd. That is, the dependence of MAT Co., Ltd. and TRI Co., Ltd. on DHK Co., Ltd. is almost the same, but the dependence of SDS Co., Ltd. on DHK Co., Ltd. is MAT, TRI Co., Ltd. ) Is the highest among the ordering companies.

Further, the circle indicating the secondary company is included in the circle indicating the primary company, and its diameter varies depending on the degree of dependence on the primary company. Since the diameter of the circle indicating the primary company fluctuates depending on the degree of dependence on the company of interest, the diameter of the circle indicating the secondary company indicates the degree of dependence of the secondary company on the company of interest. Therefore, regardless of which company the primary company is, the size relationship of the diameter of the secondary company indicates the degree of dependence on the company of interest.

FIG. 15 corresponds to a partially enlarged view of FIG. FIG. 15 is an enlarged display of the circle C23. Since the transition from FIG. 14 to FIG. 15 is the same as the transition from FIG. 13 to FIG. 14, the description thereof will be omitted. Yen C31, Yen C32, etc. included in Yen C23 indicate companies having a direct business relationship with TRI Co., Ltd. corresponding to Yen C23. Yen C31 indicates TTC Co., Ltd., and Yen C32 indicates ITS Co., Ltd. TTC Co., Ltd. and ITS Co., Ltd. are tertiary companies that indirectly trade with DHK Co., Ltd. via TRI Co., Ltd., and indirectly with the company of interest via DHK Co., Ltd. be. The size of the diameter of the circle C31, the circle C32, etc. indicates the degree of dependence on TRI Co., Ltd. of TTC Co., Ltd. and ITS Co., Ltd., respectively. That is, it shows that the dependence of TTC Co., Ltd. on TRI Co., Ltd. is slightly higher than the dependence of ITS Co., Ltd. on TRI Co., Ltd.

Since the diameter of the circle indicating the tertiary company fluctuates depending on the degree of dependence on the secondary company, the diameter of the circle indicating the tertiary company indicates the degree of dependence of the tertiary company on the secondary company. Regardless of which company the primary company is, the size relationship of the diameter of the secondary company indicates the degree of dependence on the company of interest. Regardless of whether it is a company or not, the size relationship of the diameter of the tertiary company indicates the degree of dependence on the company of interest.

From the above, when FIG. 13 is described again, the intensional relationship of the yen indicates whether the business relationship with the company of interest is primary, secondary, or tertiary. The diameter of the included circle indicates the degree of dependence on the company of interest regardless of whether the business relationship is primary, secondary, or tertiary. Therefore, by expressing the business relationship by circle packing, it is possible to visually understand the business relationship with the company of interest and the degree of dependence on the company of interest for each company. Although it is rougher than the representation of the directed graph shown in FIG. 9, the magnitude of the dependence can be visually grasped. However, since the shape of the region is only a circle, it can be said that the space efficiency is not so good as compared with the Tree Map described later. In the expression of circle packing, it is possible to embed a glyph or the like in the enclosed circle. A glyph is a figure that expresses a multivariate, and is used in small multiples (multiple views) and the like.

Regarding the transition between drawings, the following transitions can be implemented in addition to the above. When the mouse pointer is moved inside the circle indicating the secondary company and the mouse is clicked while the company of interest is displayed (FIG. 13), the secondary company is partially enlarged (FIG. 15). With the secondary company partially enlarged (Fig. 15), move the mouse pointer inside the circle indicating the enlarged secondary company or the circle indicating the tertiary company contained in the circle. When the mouse is clicked, the system returns to the initial state (FIG. 13) in which the company of interest is displayed. In a partially enlarged state of the secondary company (Fig. 15), inside the circle indicating the secondary company or the circle of the tertiary company contained in the circle other than the circle indicating the enlarged secondary company. When the mouse pointer is moved and the mouse is clicked, the secondary company is partially enlarged. With the secondary company partially enlarged (Fig. 15), move the mouse pointer to a part other than the circle indicating the secondary company and the circle indicating the tertiary company, and click the mouse to move the mouse pointer to the position. It returns to the state of enlarging the circle of the primary company including the corresponding primary company and the partially enlarged secondary company's circle (Fig. 14). In the state where the circle of the primary company is enlarged (Fig. 14), any circle inside the circle indicating the primary company other than the circle indicating the enlarged primary company and indicating the secondary company. When the mouse pointer is moved to a position other than the inside of the and the mouse is clicked, the state shifts to the state of partially enlarging the primary company. In the state where the circle of the primary company is enlarged (Fig. 14), inside the circle indicating the secondary company included in the circle indicating the primary company other than the circle indicating the enlarged primary company, When the mouse pointer is moved and the mouse is clicked, the state transitions to the state of partially enlarging the secondary company (FIG. 15).

Although it is not possible to express using a plurality of colors in FIGS. 13 to 15 due to the convenience of drawing, the colors may be changed for each hierarchy so that the hierarchy of the company can be easily grasped. For example, the internal color may be changed for each circle indicating each of the primary company, the secondary company, and the tertiary company.

(Sunburst)
FIG. 16 is an explanatory diagram showing an example of expressing a business relationship by sunburst. Sunburst is a method of expressing business relationships in a fan shape. In FIG. 15, the primary company for the company of interest is shown in a donut shape close to the center. The outer donut shape indicates a secondary company, and the outer donut shape indicates a tertiary company. The donut shape on the outside of the donut shape indicating the tertiary company indicates the quaternary company. Sunburst is also called a sunburst chart.

Hierarchical relationships are represented by adjacent radial directions. The figure of the secondary company having a business relationship with a certain primary company is in contact with the figure of the primary company.

The area of each company is changed according to the degree of dependence on the company of interest. In FIG. 16, the primary companies are companies A to J. When it is possible to express in multiple colors, each primary company, and each group has a secondary company, a tertiary company, and a quaternary company that have direct or indirect transactions with each primary company. You may change the color to. In FIG. 16, different hatching is added instead of changing the color. In FIG. 16, only the group A and the group B are hatched.

In the expression by sunburst, each arch shape that divides the donut shape indicates the trading company, and the business relationship with the target company is either primary, secondary, or tertiary at the position in the radial direction from the center. Indicates whether it is. The area of the arch shape is proportional to the degree of dependence on the company of interest if the business relationships are of the same order. Therefore, by expressing the business relationship by sunburst, it is possible to visually understand the business relationship with the company of interest and the degree of dependence on the company of interest for each company.

(Treemap)
FIG. 17 is an explanatory diagram showing an example of expressing a transaction relationship by a tree map. Each company is represented by a rectangular area, and the dependency is represented by a rectangular area. The hierarchical relationship between trading companies is expressed by including the area below the hierarchy in the area above the hierarchy. Divide the upper area by the lower weight. (Place the lower part in the upper area without any gap.) Therefore, it may not be possible to strictly visualize the data generated by the current commercial distribution area analysis.

In FIG. 17, the thick line quadrangle indicates the primary company, the quadrangle with the middle thickness included in the primary company indicates the secondary company, and the thin line quadrangle included in the secondary company indicates the tertiary company. ing. In the tree map as well, as with other expression methods, the color of the quadrangle may be changed by grouping each primary company.

In the representation by the tree map, it is possible to grasp the transaction relation by the inclusion relation of the quadrangle and the magnitude of the dependence by the area size of the quadrangle.

(Icicle)
FIG. 18 is an explanatory diagram showing an example of expressing a business relationship by an icicle. In Icicle, each trading company is represented by a rectangle. The hierarchical relationship is expressed by the left and right adjacency. In FIG. 18, the left is the upper rank and the right is the lower rank. In FIG. 18, the degree of dependence is expressed by the height of the rectangle. The hierarchical relationship may be expressed by the upper and lower adjacency relationships. In this case, the dependency is expressed by the width of the rectangle. Also in FIG. 18, as in the case of other expression methods, the color of the quadrangle may be changed by grouping each primary company. In FIG. 18, different hatchings are attached to the top two primary companies. The icicle is also called an icicle tree.

Although the various expression techniques shown in FIGS. 13 to 18 can be intuitively grasped, transactions at the same level (transactions between T2A and T2B in FIG. 9) and transactions across layers (FIG. 9). It should be noted that the transaction between T3B and T1B in 9) cannot be expressed. In addition, it may be difficult to accurately express the magnitude of dependence in consideration of such transactions.

The technical features (constituent requirements) described in each embodiment can be combined with each other, and by combining them, new technical features can be formed.
The embodiments disclosed this time should be considered to be exemplary in all respects and not restrictive. The scope of the present invention is indicated by the scope of claims, not the above-mentioned meaning, and is intended to include all modifications within the meaning and scope equivalent to the scope of claims.

100 Commercial distribution area analysis system 1 Analysis device 11 Control unit 12 Main storage unit 13 Auxiliary storage unit 131 Sales DB
132 Transaction volume DB
133 Transaction volume share DB
14 Communication unit 15 Reading unit 1P control program 2 Corporate information DB
3 User terminal 31 Control unit 32 Main storage unit 33 Auxiliary storage unit 34 Communication unit 35 Input unit 36 Display unit 3P Control program B Bus N Network

Claims (7)

Acquire the share of the primary transaction volume, which is the share of the transaction volume with the target company, in the sales of the primary transaction company that has a business relationship with the target company.
Multiply the primary trading volume share by 100% to calculate the primary spillover degree.
The (n + 1) order trading volume share, in which the transaction volume with the nth trading company accounts for the sales in the (n + 1) order trading company that has a business relationship with the nth trading company (n is a natural number), is acquired.
The (n + 1) order spillover degree, which is obtained by multiplying the (n + 1) order transaction volume share by the nth order spillover degree, is repeatedly calculated while increasing n from 1, until a predetermined condition is met.
For each company belonging to at least one of the m-th order trading company (m is a value of n satisfying the predetermined condition) from the n-th order trading company, the dependence which is the sum of the primary spillover degree and the m-th order spillover degree is calculated.
An output program characterized by having a computer perform a process of associating the company with the dependency for each company and outputting the output. The output program according to claim 1, wherein the predetermined condition is such that n is a predetermined value or more. The output program according to claim 1, wherein the predetermined condition is such that the total m-order spillover degree is less than a predetermined threshold value. From the above-mentioned focused company and n-th order trading company, the m-th order trading company is represented by the apex, and a graph expressing the business relationship between the companies by the edge is generated.
The output program according to any one of claims 1 to 3, wherein the graph is output with the dependency attached to each vertex. The nth-order trading company to the m-th-order trading company are represented by a figure in which the magnitude of the dependence is proportional to the area, and the plurality of the figures are adjacent or included in a figure between companies having a direct business relationship. The output program according to any one of claims 1 to 3, wherein the output program is arranged and the arranged graphic group is output. The first acquisition department that acquires the share of the primary transaction volume, which is the share of the transaction volume with the target company, in the sales of the primary transaction company that has a business relationship with the target company.
The first calculation unit that calculates the primary spillover degree by multiplying the primary transaction volume share by 100% .
The second acquisition unit that acquires the (n + 1) order trading volume share in which the transaction volume with the nth trading company occupies the sales in the (n + 1) order trading company that has a business relationship with the nth trading company (n is a natural number). When,
A second calculation unit that repeatedly calculates the (n + 1) order spillover degree, which is obtained by multiplying the (n + 1) order transaction volume share by the nth order spillover degree, while increasing n from 1, until a predetermined condition is met.
For each company belonging to at least one of the m-th order trading company (m is a value of n satisfying the predetermined condition) from the n-th order trading company, the degree of dependence obtained by adding the primary spillover degree to the m-th order spillover degree is calculated. 3 calculation unit and
An output device characterized in that each company is provided with an output unit that outputs the company and the dependency in association with each other. The computer
Acquire the share of the primary transaction volume, which is the share of the transaction volume with the target company, in the sales of the primary transaction company that has a business relationship with the target company.
Multiply the primary trading volume share by 100% to calculate the primary spillover degree.
The (n + 1) order trading volume share, in which the transaction volume with the nth trading company accounts for the sales in the (n + 1) order trading company that has a business relationship with the nth trading company (n is a natural number), is acquired.
The (n + 1) order spillover degree, which is obtained by multiplying the (n + 1) order transaction volume share by the nth order spillover degree, is repeatedly calculated while increasing n from 1, until a predetermined condition is met.
For each company belonging to at least one of the m-th order trading company (m is a value of n satisfying the predetermined condition) from the n-th order trading company, the dependence which is the sum of the primary spillover degree and the m-th order spillover degree is calculated.
An output method characterized by outputting the company and the dependency in association with each other for each company.

Images