JPH1011513A - Integration method for individual department product information - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the diversion of product information (individual department product information) among different departments and also to improve the cooperation of business work among the different departments. SOLUTION: When various types of selling products are shipped via plural departments, the consistency of product information is sometimes lost in such a case where the different product type names are added to the same products. At the same time, the 1:N or N:1 conversion or the N:M conversion of combination of these 1:N and N:1 conversions is sometimes required when the conversion is carried out between the product type names. Then various types of information are collected in a step 142, and a data base is updated in a step 146 with the data meshes of both unconverted and converted product information used as keys. When the number of relevant data meshes are divided before and after conversion of the product information, the number of these data meshes are distributed in a step 148 based on the updated data base. Thus, the diversion of the product information is improved.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION When multi-product sales products are shipped via a plurality of different departments, each department has a different data mesh, and individual department product information for managing these sales products. The invention relates to an individual department product information integration method for converting one department's product information to the other department's, particularly when converting the individual department product information from one department's product to another department's. 1: N
And N-to-1 or N-to-M conversion in which these are combined can be effectively and automatically performed, thereby improving the diversion of the individual section product information between different sections. The present invention relates to an individual section product information integration method capable of improving the coordination of business between different sections.

[0002]

2. Description of the Related Art First, an example of a conventional processing method in our company will be described here.

A sales plan created by a sales department in a profit plan is to predict sales based on "sales quantity" and "sales unit price". With such a sales plan, CRT
(Cathode ray tube) or a book table as shown in FIG. 1 to be printed out from a printer.

[0004] The "sales quantity" shown in FIG. 1 is obtained by the processing shown in the flow of FIG. 3 based on the kind correspondence as shown in FIG. Since the type correspondence is determined according to the circumstances in each main division, it differs for each main division as shown in FIG. Further, in FIG. 2, the sales type is a type classification classified for the purpose of sales management, while the sales classification in FIG. 1 is a group of consumers classified for the purpose of sales management.

[0005] In obtaining the above "sales quantity",
First, based on the sales plan quantity predicted by the sales generalization department in step 112 of FIG. 3 using the coarse mesh of “planned product type”, the production planning department determines the production capacity by the mesh of “factory” and “production type” in step 114. Formulate with consideration. The sales department that creates the sales plan in step 116 makes a plan with another mesh called “business type”. Therefore, it is necessary to convert the “product type” formulated by the production planning department into the “business type” as shown in FIG. A similar variety conversion also occurs in the following.

Next, at step 116,
By further allocating the “sales quantity” set for each “business type” to a “sales division” mesh and setting a price in this unit, it is possible to obtain sales for the first time. The sales department plans sales volume in a mesh called "input quotas". On the other hand, the system does not necessarily match the “sales category” because the difference is mainly focused on the selling price. Therefore, a conversion operation occurs as described above.

As described above, by the time the sales plan is completed, the plan of each department is converted and the plan is completed, but the conversion and distribution standards at that time are based on the standards unique to each department. For example, reflecting past performance, conversion patterns,
In many cases, the allocation ratio is determined, but the period (3 months or 6 months) and method (delivery date or contract month basis) of the results collection are set based on each division's own standard.

[0010] A sales plan can also be created for the sales plan obtained in this way, as in step 118.

[0009]

A profit plan is created by participation of many departments. There is no unified key, and for example, as shown in FIG. 2, each section sets a key with an optimal mesh. In addition, the conversion and distribution of keys required for this have been made on the basis of each division's own standard. These are as described above. As described above, conventionally, the product information is provided for each individual section, and the product information is not unified or cooperated.

For example, in the case of varieties that have seasonal fluctuations, the distribution results may differ significantly between the case where the latest actual data is simply collected as it is and the case where the data of the same period of the previous year is adopted. With such a large difference, the same allocation as in the past causes problems. At this time, if the same new conversion / allocation data is used in all the departments that create the profit plan, a more consistent plan can be formulated. The latest distribution / conversion pattern is automatically presented without registering the pattern each time, which can lead to prevention of leakage and reduction of load.

When a new classification change is set,
For example, when the addition of new varieties is set, the work of confirming the conversion / distribution pattern performed each time while coordinating with the related departments increases as the number of related departments increases. Also in this case, the latest distribution / conversion pattern is automatically presented without registering the pattern each time, which can lead to prevention of leakage and reduction of load.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned conventional problem. When converting the individual department product information from one department to that of another department, a one-to-N ratio is required.
And N-to-1 or N-to-M conversion in which these are combined can be effectively and automatically performed, thereby improving the diversion of the individual section product information between different sections. It is an object of the present invention to provide an individual section product information integration method capable of improving the coordination of business between different sections.

[0013]

SUMMARY OF THE INVENTION According to the present invention, when multi-product sales products are shipped via a plurality of different departments, the respective products have different data meshes for managing these sales products. Product information integration method for converting individual department product information from one department to the other department, using the data mesh of the individual department product information before and after conversion as a key This problem has been solved by collecting actual data before and after, and when the quantity of the corresponding data mesh is divided before and after the conversion, by allocating the quantity according to the actual data before and after the conversion.

[0014] In the method of integrating individual section product information,
If the key of the data mesh is the same even if the quantity is separated after the conversion, the problem is solved by performing the aggregation processing of the quantity according to the actual data before and after the conversion. This is specifically done.

In the method of integrating product information of individual departments, the sold product is a rolled metal strip, and the collection of the actual data before and after the conversion targets data for the latest six months of the actual order received. In addition to solving the above-mentioned problems, the reliability of the actual data before and after the conversion is further improved while using the sold product as a metal rolled strip.

In the method for integrating product information of individual departments,
After the quantity allocation, by increasing or decreasing the largest quantity after the allocation so that the total of the quantity after the allocation matches the quantity before the allocation, by reducing the effect of rounding at the time of the allocation. When the individual section product information is converted, the quantity can be more appropriately distributed.

Hereinafter, the operation of the present invention will be briefly described.

In order to solve the above-mentioned problem, according to the present invention, a mesh of each department is added to order data which is received and stored every day. I found a mechanism that makes it possible to grasp without omission. This promotes cooperation of product information for each department.

First, the “business type” and “sales category” are added to the order data and stored as actual data before and after conversion (conversion / distribution data base). For such processing, a conventional mechanism can be used. In addition, for example, the sales generalization department adds a mesh “sales plan type” with unique logic, and the production planning department adds “production type” with unique logic. By having a conversion and distribution database in addition to these logics,
A mechanism has been constructed that can grasp the correspondence pattern between the two, and based on such grasp, can make the type conversion possible.

As described above, according to the present invention, the conversion / allocation database is used by each department, so that conversion / allocation can be performed on a unified basis, and a consistent plan can be created. become. In addition, even if each department changes the mesh only for that department without being aware of the effect on other departments, the computer should always present the conversion pattern and distribution ratio with the latest mesh. Can also. As a result, leakage of changes and load are minimized.

As described above, according to the present invention, when converting the individual section product information from one section to that of the other section, 1-to-N, N-to-1 or N-to-M combinations of these are combined. Conversion can be effectively and automatically performed, thereby improving the diversion of the individual department product information between different departments, and improving the coordination of business between such departments. The excellent effect that can be obtained can be obtained.

The present invention can be configured as an apparatus using a computer. That is, the individual section product information integration method according to the present invention is configured as an apparatus using a computer. For example, a conversion / distribution database configuring data before and after conversion and various logics using the database are configured by a plurality of departments. can do. Although each department is involved in this way, it is possible to automatically convert and combine plans made by each department with the optimal mesh (classification of products, grouping of customers) for the period, content and purpose. Thus, it is possible to configure the apparatus as an apparatus that can create various plans as needed, for example, using a sales mesh without being aware of plans of other departments.

[0023]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS First, the individual section product information integration method of the present embodiment to which the present invention is applied is intended for a steelmaking company that performs from production to sales, and is intended for this embodiment that performs manufacturing and sales. Is a coil of a continuous rolled strip. Such products are shipped to various industries, such as automobile manufacturers and electric appliance manufacturers. Further, as described above with reference to FIG. 2, even in the case of the same product, the name of the type is different in each supervising department in the steelmaking company for each convenience.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

FIG. 4 is a flowchart showing the overall processing flow of the individual section product information integration method of this embodiment.

First, step 142 in FIG. 4 is a daily process performed for each business day. This daily processing is performed as shown in the block diagram of FIG. In FIG. 5, the order data of the order form 162 accepted daily is
The order information and the production information are added, and the order database 16 is added.
4 is stored. Thereafter, the sales management code issuing process 166 is performed.
As shown in FIG. 2, the sales management basic codes such as the “business type” and “sales classification” shown in FIG. 2 are added and stored in the sales management database 168. Here, the sales management database 168 holds various information for sales management in addition to the order receiving database 164 holding basic information for manufacturing a product.

In FIG. 4, next, in step 144, a semi-annual process including a process relating to a profit plan is performed. This semi-annual processing is performed in semi-annual (6 months) or quarterly (3 months) units. The conversion / distribution database update processing in step 146 and the data conversion processing in step 148 performed in step 144 are performed as part of the profit planning processing.

In this semi-annual process, first, step 146
In the conversion / distribution database update process, as shown in FIG. 6, various keys for issuing various keys to the sales management database 168, such as a sales plan type, a receiving / shipping type, a production plan type, a negotiation type, and an input frame classification. Information issuing process 170
To update the conversion / distribution database 180 combined with the sales management basic code. This conversion / distribution database 180 is used to obtain information used for conversion between different types of products for each of the main departments in FIG. 2 described above, and is used, for example, to obtain conversion information from an input slot division to a sales division. . The conversion and distribution database 180 is used in the subsequent step 148.

Subsequently, in the data conversion processing of step 148 in FIG. 4, the processing shown in the block diagrams of FIGS. 8 and 9 is performed in addition to the flowchart of FIG.

Here, in FIG. 8, step 14 in FIG.
8 shows a part of creating a sales plan centering on steps 244 to 248 in FIG. 7. FIG. 9 shows a part of the profit improvement centering on step 250 of FIG.

First, as shown in FIG. 8, a conversion process 184 is performed on the sales plan in accordance with the conversion / allocation database 180 and the quarterly sales plan 182. The conversion process 188 is performed according to the conversion / distribution database 180 and the storage / delivery plan 186. Further, a final sales plan 192 is obtained according to the results of the conversion processes 184 and 188.

Subsequently, as shown in FIG. 9, conversion processing 184 is performed in accordance with the conversion / allocation database 180 and the quarterly sales plan 182 to improve the profit. conversion·
Conversion processing 198 is performed according to the distribution database 180 and the half-year sales plan 196. Conversion processing 204 is performed according to the shipping plan 200 and the shipping plan 202. Further, according to the results of the conversion processes 184, 198 and 204,
A final profit improvement plan 206 is required.

Next, the flowchart of FIG. 7 will be described in order. First, at step 242, a production / shipment plan is made by the production planning department. In this production / shipment plan, a plan is made on how products that are produced and in stock are to be shipped. Note that the production, storage, and shipping timings of products that are produced and in stock, which are the targets of the production and shipment plan, are predicted in advance by the sales plan and the production plan. For example, the shipment plan in this production / shipment plan predicts a shipment time mainly determined by the circumstances of the delivery destination based on past experience.

In the production / shipping plan in step 242, for example, information on the planned shipping quantity as shown in FIG. 13 is input from the production planning department and obtained. That is,
It is planned how much each product type is produced at each production factory, and how the produced product is distributed to each sales group as a planned shipment quantity.

Subsequently, steps 244, 246 and 248 are performed.
Then, a sales plan is made. In this sales plan, first, the sales price of the product whose shipping time and shipping amount are predicted in step 242 described above is obtained based on the price at the time of receiving an order for each product (product unit price or the like). Further, the sales amount for each month is predicted from the sales price and the predicted shipment amount. Even for the same product with the same shipment time, if the order time is different, the order price will be different, and the sales price at the time of shipment will also be different. In this sales plan,
Different order prices are taken into account depending on such order times.

In the sales plan, first, in step 244, information relating to incoming and outgoing shipment is taken in as information for each type i. Specifically, the information for each “sales group” input in step 242 described above is imported while the “sales group” section is set as the “contract group”, and the “contract group” acquired in this manner is acquired. Information for each “type i” is subdivided at a ratio based on the results of the past six months.

In the sales plan of step 244, for example, a planned quantity as shown in FIG. 14 is obtained. FIG. 14 is an example corresponding to FIG. 13 described above. Figure 1 above
According to the past results, the planned shipment quantity 4,000 of the production type “Hot” of the electric machine group of the factory C1 of No. 3 is 4,000 according to the past results. It is allocated to the planned number of thin sheets of 500 and the planned number of hot rolled sheets of 3,000. FIG. 13
In FIG. 14, the planned shipment quantity 2,500 of the production type “hot” of the electric machine group of the factory C2 is the planned quantity 500 of the hot-rolled hot plate, the planned quantity 0 of the hot-rolled special thin plate of the electric machine group of the factory C2 in FIG. And the planned quantity of hot rolled sheets is 2,000.

In the following step 246, a business request is taken. In step 246, first, the result of the sales plan obtained from the sales department (sales department) as shown in FIG. 10 is fetched. Further, in this step 246,
The sales plan fetched in this way, which is represented by the sales group, the negotiation type, the input frame, and the quantity, is represented by information (sales plan mesh, for example) shown in FIG. ). This conversion is performed as shown in FIG.
This is performed in accordance with the distribution actual quantity and the distribution ratio obtained based on 80. For example, in FIG. 11, in addition to the numerical values also shown in FIG. 10, actual distribution quantities and distribution ratios used for conversion are shown.

Here, the quantity 1 of the electric machine maker A1 shown in FIG.
800 is an electric machine maker B1a and B1 of FIGS.
1b. Quantity 6 of other manufacturer A4 in FIG. 10
00 is distributed to the other manufacturers B4a and B3b in FIGS. 11 and 12. General assembly A5 in FIG.
Of the other manufacturers B4 of FIGS. 11 and 12
b and the electric machine maker B3c.

Here, the maker shown in the input frame in FIG. 10 and the maker shown in the sales section in FIGS. 11 and 12 are the same or related. Specifically, FIG.
1 and FIG. 12 are the same as the electric machine maker A1 in FIG. Further, the electric machine maker B1b is a related company of the electric machine makers A1 and B1a. The electric machine maker B2 is the same as the electric machine maker A2. 11 and 12 are the same as the electric machine maker A3. These electric machine manufacturers B3a to B3c are separated in FIG. 11 and FIG. 12 for the sake of convenience because their input frames are different, such as electric machine manufacturer A3, other manufacturer A4, and general assembly A5.

In FIG. 11, in addition to the sales plan represented by the contract group, type i, sales category, and quantity obtained in step 246, the actual distribution quantity and the distribution ratio for obtaining the quantity are shown. ing. These actual distribution quantities and allocation ratios are stored in the conversion / allocation database 18 described above.
0 is stored. The distribution ratio is obtained based on the actual quantity for distribution.

As an example, FIG. 10 and FIG. 11 will be specifically described. The type i “Hot rolled sheet” of the electric machine maker B1a and the electric machine maker B1b in FIG. 11 to which the negotiation type “hot” of the electric machine maker A1 in FIG. Are 900 and 450, respectively, and the distribution ratio is 0.66 according to the actual quantity for distribution.
66 and 0.3333. Therefore, the quantity 1800 of the electrical maker A1 in FIG. 10 is distributed to the quantity 1200 of the electrical maker B1a and the quantity 600 of the electrical maker B1b according to such an allocation ratio.

Next, regarding the other maker B4a and the electric maker B3b in FIG. 11 to which the other maker A4 in FIG. 10 is distributed, the actual distribution quantities are 200 and 10 respectively.
Since it is 0, the respective distribution ratios are 0.6666 and 0.3333 according to the distribution actual quantity. Therefore, the quantity 600 of the other maker A4 is changed to the quantity 40 of the other maker B4a according to the distribution ratio.
0 and the quantity 200 of the electric machine maker B3b.

Next, as for the other maker B4b and the electric maker B3c to which the general binding A5 of FIG. 10 is distributed, the actual distribution quantities are 50 and 150, respectively. The ratios are 0.2500 and 0.7500. Therefore, the quantity 400 of the general tying A5 is distributed to the quantity 100 of the other maker B4b and the quantity 300 of the electric maker B3c according to the distribution ratio.

The distribution of the quantities A1, A4 and A5 in FIG. 10 described above can be said to be a one-to-N conversion of varieties. Note that the electric manufacturers B3a to B3c in FIG. 11 are actually the same maker as described above, and thus the total quantity is 1,500 (= 1,000 + 200 + 300). The total of such quantities can be said to be N-to-1 conversion of varieties.

When a sales plan is obtained as shown in FIG. 11, the sales plan as shown in FIG.
And organized as shown in That is, as described above, since the electric machine manufacturers B3a to B3c in FIG. 11 are the same manufacturer, in FIG. 12, they are combined into one and the total number is 1,500. Further, the other manufacturers B4a to B4c in FIG. 11 are also summarized as the other manufacturer B4 in FIG. 12, and the total number is 1200.

In the following step 248 in FIG. 7, a sales plan is created. This sales plan is created based on the result of the sales plan in step 244 and the result of taking in the business request in step 246. For example, it is performed according to the above-described FIG. 14 and FIG.

At step 246 in FIG. 7 described above, the quantity to each destination indicated by the sales category is obtained, and the total is, for example, 6,000 as shown in FIG.
It is 0. On the other hand, according to the sales plan shown in step 244, the planned quantity that can be actually produced in the factory is obtained. For example, the planned quantity of the type i “hot rolled thin sheet” in FIG. 000 and Factory C
The total of the planned quantity of 2,000 in 2,000 is 5,000. Therefore, the planned quantity 5,000 (FIG. 14) that can be actually produced is smaller than the total quantity 6,000 (FIG. 12) of FIG. 12 obtained from the sales department (sales department), so that in step 248 The process calculates this total planned quantity of 5,000,
This is performed by allocating to the sales divisions in FIG. This distribution is made in proportion to the quantity of each sales section shown in FIG. For example, when it is determined based on FIGS. 12 and 14, it is as shown in FIG.

Here, for example, the total quantity of FIG.
If it is smaller than the total planned quantity of 4, the respective quantities in FIG. 12 become the planned quantities in FIG. 15 as they are.

Subsequently, at step 248, the sales division is subdivided into the sales sub-categories, and the final sales plan is obtained by allocating the planned quantity to the sales quantity. This is performed using the conversion / distribution database 180 described above. For example, a sales plan creation key stored in the conversion / distribution database 180 as shown in FIG. 18 is finally obtained according to the actual quantity for distribution. FIG. 17 shows a calculation process in the course of obtaining FIG. That is, for example, in FIG. 15 described above, the sales quantity is obtained by performing the processing shown in FIG. 17, and the final sales plan as shown in FIG. 18 is obtained.

In FIG. 17, the sales sub-classification of each sales division is obtained by the sales plan creation key shown in FIG.
Also, the actual distribution quantities as shown in FIG. 17 for each of the business sub-classes are stored in the conversion / allocation database 180.

Here, when the planned quantity of each sales section is distributed to the distribution actual quantity business sub-classification, for example, a temporary distribution quantity as shown in FIG. 17 is obtained.

For example, the planned quantity 1,0 of the electric machine maker B1a
00 is allocated to a general-purpose temporary allocation quantity 839, a non-general provisional allocation quantity 120, and another temporary allocation quantity 40. Here, in the present embodiment, if the sum does not match due to rounding before and after the distribution, the adjustment is performed using the largest of the data calculated and distributed using the common denominator of the distribution ratio. Therefore, the above-mentioned provisional distribution quantity 839 is adjusted to the sales quantity 840.

Next, in the present embodiment, when the distribution does not have the actual recording quantity at the time of distribution, the actual ratio becomes 0. On the other hand, if there is a key that matches the data before distribution as the sales plan creation key, the key To be distributed to For example, in the electric machine maker B2 in FIG. 17, the actual quantity for distribution is 0, and therefore the temporary distribution quantity is 0, but the planned quantity is 1250, so the sales quantity is also 1250.

In the present embodiment, the distribution actual quantity exists at the time of distribution, but if the sales plan creation key does not exist (is not registered), the distribution quantity is the first of the distribution ratio common denominators. Key to adjust. For example, the sales subclass “others” of the other electrical maker B4 in FIG. 17 does not exist in the sales plan creation key in FIG. However, since the actual quantity for distribution of “other” exists as 400, the distribution of the planned quantity is also adjusted for “other”.

Note that the above three concepts regarding the distribution are basically the same for the above-described distribution of FIG. 11 and the above-described distribution from FIG. 13 to FIG.

Step 248 of FIG. 7 as described above
The result of the sales plan creation shown in FIG.
It is as shown in. After the sales plan is created, in step 250, the profit improvement plan as described above with reference to FIG. 9 is performed.

Note that the collection range of the actual data in the conversion / allocation database 180, such as the above-described actual distribution quantity and distribution ratio in FIG. 11, the distribution from FIG. 13 to FIG. 14, and the actual distribution quantity in FIG. In the present embodiment, is assumed to be six months of actual orders. If the collection range of the performance data is as short as, for example, three months, it may be affected by monthly fluctuations or sudden factors. On the other hand, when the period is relatively long, such as one year, the configuration of the past demand level is affected, and it becomes difficult to perform the processing with high accuracy. When the collection range of the actual data is set to six months as in the present embodiment, the situation of the seasonal fluctuation for one year cannot be reflected. The impact is judged to be small.

As described above, according to the embodiment to which the present invention is applied, various excellent effects can be obtained.

First, a quarterly sales plan, a receipt / shipment plan,
Even though a department such as a half-year sales plan creates an optimal mesh in that department, it is automatically converted, and a sales plan and a profit plan are created.

It is not too much to say that there is nothing in the manufacturing industry that involves as many departments as the profit plan. Among them, having a uniform standard is very important for creating a consistent plan. This has been made possible through a centralized database called the conversion and distribution database. In addition, if the related departments are diverse, it takes time to adjust when a change occurs, and it is easy to cause omission or confusion, but according to this embodiment, it is possible to consider almost no influence on other departments , It became possible to change it freely according to the own department.

Thus, according to the present embodiment, when converting the individual section product information from that of one section to that of the other section, 1-to-N, N-to-1 and N-to-N combinations are used. By enabling the automatic conversion of M to M, the diversion of the individual department product information between different departments can be improved, and the coordination of business between such departments can be improved. Can be achieved.

[0063]

As described above, according to the present invention, when converting the individual section product information from one section to that of the other section, one-to-N, N-to-one, and combinations thereof are used. N-to-M conversion can be effectively and automatically performed, thereby improving the diversion of the individual section product information between different sections, and coordinating operations between such sections. The excellent effect that the improvement of can be achieved can be obtained.

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a book table of sales plan results obtained conventionally.

FIG. 2 is a diagram showing types corresponding to different types in which different types are assigned to the same type in different departments.

FIG. 3 is a flowchart showing an example of a conventional sales planning process.

FIG. 4 is a flowchart showing overall processing of an embodiment of an individual section product information integration method to which the present invention is applied;

FIG. 5 is a block diagram showing a configuration for performing a daily process of the embodiment.

FIG. 6 is a block diagram showing a configuration for performing a conversion / distribution database update process of the embodiment.

FIG. 7 is a flowchart showing data conversion processing performed in the embodiment.

FIG. 8 is a block diagram showing a configuration of a process for obtaining a sales plan performed in the embodiment.

FIG. 9 is a block diagram showing a configuration of a process for obtaining a profit improvement plan performed in the embodiment.

FIG. 10 is a diagram showing information input from a sales department in the embodiment.

FIG. 11 is a diagram showing data in a process of processing the information.

FIG. 12 is a diagram showing the quantity of each sales division obtained as a result of the above processing.

FIG. 13 is a diagram showing information input from a production planning department in the sales planning of the embodiment.

FIG. 14 is a diagram showing information for each product type on the production planning department side obtained in the sales plan.

FIG. 15 is a diagram showing a planned quantity for each sales division obtained in creating a sales plan in the embodiment.

FIG. 16 is a diagram showing a sales plan creation key used in the above sales plan creation;

FIG. 17 is a diagram showing each data in the process of creating the sales plan.

FIG. 18 is a diagram showing a book table as a result of creating a sales plan in the embodiment.

[Explanation of symbols]

 162 ... Order Form 164 ... Order Receipt Database 166 ... Sales Management Code Issuing Process 168 ... Sales Management Database 170 ... Various Key Information Issuing Process 180 ... Conversion / Distribution Database 182 ... Quarterly Sales Plan 184,188,198,204 ... Conversion Process 186 ... Incoming / outgoing plan 192 ... Sales plan 196 ... Half-year sales plan 200 ... Shipping plan 202 ... Shipment plan 206 ... Profit improvement plan

Claims (4)

[Claims] 1. When multi-product sales products are shipped via a plurality of different departments, individual department product information for managing these sales products, which have different data meshes in each department, This is a method of integrating individual department product information from one department to that of the other department, using the data mesh of the individual department product information before and after conversion as a key to collect actual data before and after conversion, and perform conversion. When the quantity of the data mesh is divided before and after, the quantity is distributed according to the actual data before and after the conversion. 2. The method according to claim 1, wherein if the key of the data mesh is the same even if the quantity is separated after the conversion, the quantity is aggregated according to the actual data before and after the conversion. Department product information integration method. 3. The product according to claim 1, wherein the sold product is a rolled metal strip, and the collection of the data before and after the conversion is for the data for the latest six months of the order received. Product information integration method for individual departments. 4. The method according to claim 1, wherein after said quantity distribution,
Make sure that the total quantity after distribution matches the quantity before distribution.
A method for integrating individual division product information, characterized in that the largest quantity after allocation is increased or decreased to reduce the effect of rounding upon allocation.