JP4199638B2 - Order quantity management apparatus, order quantity management method, and order quantity management program - Google Patents

Description

  The present invention relates to an order quantity management apparatus, an order quantity management method, and an order quantity management program applied to a POS system or the like.

Conventionally, when ordering products from a merchant such as a supermarket or convenience store based on the experience of a manager such as a store manager, it is not possible to correctly reflect customer trends in the order volume. There was a problem. For this reason, it obtains actual data indicating the number of products sold in a specific period in the past and generates a forecast value for the number of products sold.For example, the stock quantity at the end of the day does not fall below the minimum stock quantity. The order quantity calculation system is known to determine the order time and order quantity so that the maximum stock quantity is reached, accumulate the error between the predicted value and the actual sales quantity, and use this accumulated value to correct the next order quantity. (For example, refer to Patent Document 1).
JP 2001-282906 A

However, as in this gazette, simply acquiring actual data indicating the number of products sold in a predetermined period in the past and generating a forecast value of the number of sales, and determining the order quantity based on that, the latest market It was insufficient in that the number of orders for each product was determined reflecting the trend sufficiently.
It is an object of the present invention to provide an order quantity management apparatus, an order quantity management method, and an order quantity management program that can determine the order quantity for each product sufficiently reflecting the latest market trends.

  The present invention accesses a research site on the Internet and conducts research on product information such as product codes and product names of various products belonging to the same product classification, composition ratio corresponding to sales results, growth rate from the previous survey, etc. An information fetching means for fetching information, and an ordering information table creating means for creating an ordering information table in which product information, composition ratio, and growth rate of each product are set based on the research information fetched by the information fetching means; , Ordering input means such as a keyboard for inputting product information to be ordered separately for each product classification and the number of orders, and the composition ratio corresponding to each product input by this ordering input means are read from the ordering information table, and each configuration Calculates the composition ratio distribution ratio from the ratio and its total value, and calculates the correction value for the order quantity of each product from this composition ratio distribution ratio and the total number of orders entered for each product A temporary storage table creation means for creating a table for temporarily storing product information, order quantity, composition ratio, obtained composition ratio distribution ratio and correction value of the order quantity of each inputted commodity, and for this temporary storage And a display for displaying the contents of the table created by the table creating means.

  According to the present invention, by accessing a research site on the Internet, it takes in research information such as product information of each product belonging to the same product classification, composition ratio corresponding to sales results, growth rate from the previous survey, etc. Since the order quantity of each product input based on research information is corrected, the order quantity management device, the order quantity management method, and the order that can determine the order quantity for each product sufficiently reflecting the latest market trends A number management program can be provided.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
(First embodiment)
FIG. 1 is a block diagram showing the configuration of the entire system. An ordering terminal 2 having a built-in order quantity management function, a research site server 3, and a plurality of vendor terminals 4 are connected to the Internet 1. For example, the ordering terminal 2 may be provided separately from a store controller that is a management device in a POS system arranged in a store, or may be integrated into the store controller. Here, the case where it is provided separately will be described.

  The research site, for example, classifies product categories such as snacks, beer, drinking water, and pharmaceuticals as the same product category, conducts market research on tens or hundreds of items for the same product category, and sells for each product. The composition ratio corresponding to the actual results, that is, the composition ratio that is the ratio of the number of sales of each item to the total number of sales of all items, and the growth rate from the previous survey are stored in the research site server 3. To the ordering terminal 2 as research information.

  The research information is provided to the ordering terminal 2 by, for example, a manager of a store that handles the ordering terminal 2 making a contract with the research site and then accessing the ordering terminal 2 to download the research information. The research information may be automatically downloaded, and the ordering terminal 2 may access the research site server 3 periodically to download the research information every week, every two weeks, or every month. The merchant terminal 4 is a terminal installed at a wholesaler or manufacturer that handles merchandise, and serves as a merchandise ordering destination.

  As shown in FIG. 2, the ordering terminal 2 includes a central processing unit (CPU) 21 that constitutes a main body of the control unit, a ROM (read only memory) 22 that stores program data for the CPU 21 to control each unit, RAM (random access memory) 23 provided with a memory for temporarily storing data, display data, print data, etc., a memory used when calculating data, and a memory for forming a temporary storage table, an order information table described later And a hard disk drive (HDD) 24 provided with a memory for forming an ordering table.

  Further, the display controller 26 that controls the display of the liquid crystal display 25, the keyboard controller 28 that controls the input of key signals from the keyboard 27 that constitutes the order input means, the printer controller 30 that controls the drive of the printer 29, and the Internet 1 are connected. An Internet communication unit 31 that performs communication via the Internet 1 is provided.

  The CPU 21, ROM 22, RAM 23, HDD 24, display controller 26, keyboard controller 28, printer controller 30, and Internet communication unit 31 are electrically connected to each other via a bus line 32 such as a data bus, an address bus, and a control bus.

  The CPU 21 of the ordering terminal 2 is programmed to execute the order quantity management process shown in FIG. That is, in S1, the initialization process is performed to clear the memory to be used. Subsequently, in S2, an order input process is performed, and an order quantity and the like are input for the product ordered for each category of the product classification.

  Subsequently, in S3, an order correction information acquisition process is performed. Finally, an order correction process is performed in S4, and the number of orders of each input product is corrected using the information in the order information table.

  The ordering terminal 2 controls the Internet communication unit 31 based on the corrected order number of each product corrected in this way, and orders the product to the corresponding trader terminal 4.

  The order input process in S2 will be described in more detail. When a certain category such as snacks is selected, as shown in FIG. 4, an initial process is performed in S11 and the area for creating the temporary storage table is cleared. . Subsequently, in S12, the keyboard 27 is operated to input a correction category. That is, it is selected and input whether the correction is performed only with the component ratio or the elongation rate is added to the component ratio.

  For example, if you select a correction category to be corrected using only the component ratio, the column for storing the product name of the product to be ordered, the column for storing the number of orders, the column for storing the component ratio, and the calculated component ratio distribution ratio are stored. A temporary storage table having a column for storing, a correction value for the order quantity, that is, a column for storing the corrected order quantity and a column for storing the total value of each field is created (temporary storage table creation means). Then, the contents of the created temporary storage table are displayed on the liquid crystal display 25.

  When a correction category to be corrected by adding an elongation rate to the composition ratio is selected, a temporary storage table having a column for storing the elongation rate is created (temporary storage table creating means). Then, the contents of the created temporary storage table are displayed on the liquid crystal display 25.

In this state, the keyboard 27 is operated, the product name is input in S13, and the order quantity is input in S14. In this case, the product name may be input directly, or the product code may be input and the corresponding product name may be received from the store controller. The input product name is stored in the column for storing the product name in the temporary storage table and displayed on the liquid crystal display 25. The input quantity is stored in the column for storing the number of orders in the temporary storage table and stored in the liquid crystal display 25. Is displayed.
When the above operation is repeated for all the products to be ordered and the end operation is finally performed, the end of the order input is determined in S15, and the process proceeds to the order correction information acquisition process in S3.

  In the order correction information acquisition process of S3, the research information of the corresponding product classification category is downloaded from the research site server 3, and the order information table 241 having the structure shown in FIG. That is, the order of the composition ratio is determined based on the research information, and the order information table 241 in which the product information, composition ratio, and growth rate of the Jan code and the product name are set for each order is created. In the second and subsequent downloads, the ranking, composition ratio, and growth rate are updated based on the research information.

  The order correction process in S4 will be described in more detail. As shown in FIG. 6, in S21, it is checked whether or not the correction classification is only the composition ratio. If it is only the composition ratio, the process is performed in S22. Then, the composition ratio of each product that has been ordered is read from the order information table 241 and stored in the composition ratio storage column of the temporary storage table. For example, if the ordered product is a product ABC, the component ratio “7.27%” of the product ABC is read from the order information table 241 and stored in the component ratio storage column of the product ABC in the temporary storage table.

And the sum total of the component ratio of each product is calculated, and the total value is stored in the corresponding storage column. The stored contents are displayed on the liquid crystal display 25.
Subsequently, in S23, the total order quantity of each product that has been ordered is calculated, and the total value is stored in the corresponding storage field. The stored contents are displayed on the liquid crystal display 25.

  If the correction category is a correction category that is corrected by taking into account the growth rate, in S24, the component ratio and the elongation rate of each product that has been ordered and input are read from the ordering information table 241 and the component ratio × the elongation rate. The component ratio is corrected by performing the above calculation, the corrected component ratio is stored in the component ratio storage column of the temporary storage table, and the corresponding elongation rate is stored in the elongation rate storage column. For example, if the ordered product is a product ABC, the composition ratio “7.27%” and the growth rate “107.01%” of the product ABC are read from the order information table 241 and the corrected composition ratio “7.107 × 107.01≈7.78” is obtained. 7.78% "and the growth rate" 107.01% "are stored in the component ratio storage column and the growth rate storage column of the product ABC in the temporary storage table.

And the sum total of the correction composition ratio of each product is calculated, and the total value is stored in the corresponding storage column. The stored contents are displayed on the liquid crystal display 25.
Subsequently, in S23, the total order quantity of each product that has been ordered is calculated, and the total value is stored in the corresponding storage field. The stored contents are displayed on the liquid crystal display 25.

When the storage of the composition ratio and the growth rate is stored in this way, subsequently, the composition ratio distribution ratio of the ordered product is calculated from the composition ratio of each product and the total value in S25, and the corresponding product in the temporary storage table. And the stored contents are displayed on the liquid crystal display 25. Subsequently, in S26, the corrected order quantity is calculated from the calculated component ratio distribution ratio and the input order quantity, and is stored in the correction value storage column of the corresponding product in the temporary storage table, and the stored content is stored in the liquid crystal display 25. indicate. For example, if the total value of the composition ratio of each product is “23.79%” and the composition ratio of a certain product is “7.27%”, the composition ratio distribution ratio is approximately 31% according to 7.27 / 23.79. Therefore, the correct number of orders reflecting the market trend of this product is 110, which is the total number of orders, that is, 360 × 0.31.
This process is performed for all the products that have been ordered and input, and when it is determined in S27 that the order has been corrected, the order correction process is terminated.

  In the ordering terminal 2 having such a configuration, the name of the product and the number of orders are input for the products of the same category as the product classification with the correction classification as the composition ratio only. For example, the product name “product ABC”, the order quantity “120”, the product name “product BCD”, the order quantity “100”, the product name “product CDE”, the order quantity “80”, and the product name “product DEF”. The order number “60” is input.

  The temporary storage table 231 having the configuration shown in FIG. 7 is created in the RAM 23 by setting the correction category as only the composition ratio, and the storage column for the corresponding data in the temporary storage table 231 is filled by inputting the product name and the number of orders. The result is displayed on the liquid crystal display 25. Further, the ordering terminal 2 accesses the research site server 3, acquires research information for products of the same category as the product classification from the server 3, and creates an ordering information table 241 configured as shown in FIG. 5 in the HDD 24.

  Then, the composition ratio of the corresponding product is read from the order information table 241 and stored in the corresponding storage column of the temporary storage table 231, and the result is displayed on the liquid crystal display 25. Then, the composition ratio distribution ratio is obtained, the correction value of the order quantity is obtained, stored in the corresponding storage field of the temporary storage table 231, and the result is displayed on the liquid crystal display 25.

  For example, if the composition ratio of the product ABC is 7.27%, the composition ratio of the product BCD is 5.86%, the composition ratio of the product CDE is 5.69%, and the composition ratio of the product DEF is 4.97%. The total value is 23.79%, the composition ratio distribution ratio of the product ABC is 7.27% / 23.79% ≈31%, and the composition ratio distribution ratio of the product BCD is 5.86% / 23.79% ≈25. %, The composition ratio distribution ratio of the product CDE is 5.69% / 23.79% ≈24%, and the composition ratio distribution ratio of the commodity DEF is 4.97% / 23.79% ≈21%. However, since this is 101% as a whole, for example, the component ratio distribution rate of the product ABC having the smallest rounding value is set to 30% so that it becomes 100% as a whole.

  Therefore, the corrected order quantity for 120 orders entered for the product ABC is 108 x 360%, and the corrected order quantity for 100 orders entered for the product BCD is 90 x 360 x 25%. The number of corrected orders for the order number 80 input for the product CDE is 86 × 360%, which is 86, and the number of corrected orders for the order number 60, which is input for the product DEF, is 76 × 360% × 21%. The total number of orders is 360 before and after correction.

  In this way, product categories that more accurately reflect only the composition ratio when looking at market trends in product sales, for example, only the composition ratio of research information for product categories with small changes in sales in the market Is used to obtain the order quantity of each product when the total order quantity is 360, and the order quantity of each inputted product is corrected. As a result, it is possible to place an order quantity that more reflects the market trend for each product.

  In addition, when a product category with the same product category is a correction category in which the composition ratio is corrected in consideration of the growth rate, a temporary storage table 232 having the configuration shown in FIG. Then, the composition ratio and the growth rate of the corresponding product are read from the order information table 241, and the composition ratio is corrected by multiplying the growth rate.

For example, the composition ratio of the product ABC is 7.27% and the growth rate is 107.01%, the composition ratio of the product BCD is 5.86%, the growth rate is 94.29%, and the composition ratio of the product CDE is 5.69%. If the growth rate is 113.25%, the composition ratio of the product DEF is 4.97%, and the growth rate is 307.39%, the composition ratio of the product ABC after correction is 7.78%, and the product BCD The composition ratio after correction is 5.53%, the composition ratio after correction of the product CDE is 6.44%, and the composition ratio after correction of the commodity DEF is 15.28%.
The corrected composition ratio and elongation rate are stored in the corresponding storage column of the temporary storage table 231, and the result is displayed on the liquid crystal display 25.

  Since the total composition ratio of each product is 35.03%, the composition ratio distribution ratio of the product ABC is 7.78% / 35.03% ≈22%, and the composition ratio distribution ratio of the product BCD is 5.53% / 35.03% ≒ 16%, Commodity CDE composition ratio distribution ratio is 6.44% / 35.03% ≒ 18%, Commodity DE composition ratio distribution ratio is 15.28% / 35.03% ≈44% Become.

  Therefore, the corrected order quantity for the 120 orders entered for the product ABC is 79 for 360 × 22%, and the corrected order quantity for 100 orders entered for the product BCD is 58 for 360 × 16%. The corrected order number for the order number of 80 items entered for the product CDE is 65.times.18%, which is 65. The corrected order number for the order number of 60 items entered for the product DEF is 360.times.44%, which is 158. The total number of orders is 360 before and after correction.

  In this way, the composition of research information is used for product categories that reflect more accurately when the composition ratio is corrected by the growth rate when looking at the market trends of product sales, for example, product categories with large sales changes in the market. Using the composition ratio obtained by correcting the ratio by the growth rate, the order quantity of each product when the total order quantity is 360 pieces is obtained, and the order quantity of each inputted product is corrected. As a result, it is possible to place an order quantity that more reflects the market trend for each product.

  In this way, the order entry processing is performed for the product classifications of various categories, and when the number of orders for each product is corrected based on the research information, these are collected and the order table 242 having the configuration shown in FIG. That is, an order table 242 is created that lists all products for which the Jan code, product category, correction category, product name, input order quantity, and order correction value are ordered.

  Therefore, the operator of the ordering terminal 2 can print out the contents of the ordering table 242 on a slip or the like by the printer 29. Then, by looking at this list, it is possible to perform an operation of placing an order for various products with respect to the corresponding trader terminal 4.

(Second Embodiment)
In this embodiment, for example, the research site classifies categories such as snacks, beer, drinking water, and pharmaceuticals as the same product classification, conducts market research on tens or hundreds of items for the same product classification, In addition to the composition ratio corresponding to the sales performance, that is, the composition ratio that is the ratio of the number of sales of each item to the total number of sales of all items, the growth rate from the previous survey, and whether the product is a new product or discontinued Product information on whether the product is a non-sale product, a discontinued product, or a normal product that does not correspond to any of the products, is stored in the research site server 3, and is provided as research information from the research site server 3 to the ordering terminal 2. It has become.

The ordering terminal 2 also executes the order quantity management process shown in FIG. 3 in this embodiment.
If the correction category selected in the order quantity input process of S2 is a correction category that is corrected by taking account of the growth rate, a temporary storage table 235 having the configuration shown in FIG. That is, a column for storing the product name of the product to be ordered, a column for storing the number of orders, a column for storing the composition ratio, a column for storing the growth rate, a column for storing the coefficient determined based on the product information, A temporary storage table 235 having a column for storing the composition ratio distribution ratio, a column for storing the correction value of the order quantity, and a column for storing the total value of each column is created. Then, the commodity and the order quantity that have been input to the temporary storage table 235 are stored and the contents thereof are displayed on the liquid crystal display 25.

For example, the product name “product ABC”, the order quantity “120”, the product name “product EFD”, the order quantity “60”, the product name “product FGE”, the order quantity “100”, and the product name “product CAB”. The order quantity “80” is input.
In the order correction information acquisition process in S3, a process for creating or updating the order information table is performed. In this case, a preset coefficient is set according to the product information of the research information.

  That is, as shown in FIG. 10, in S31, the research information of the corresponding product category is downloaded from the research site server 3, and the order information table 245 having the structure shown in FIG. To do. That is, the order of the composition ratio is determined based on the research information, and an order information table 245 is created in which a Jan code, a product name, a composition ratio, an elongation rate are set for each rank, and an area for setting a coefficient is provided. In the second and subsequent downloads, the ranking, composition ratio, and growth rate are updated based on the research information.

  Subsequently, for each downloaded product, it is checked whether the product is a normal product, a new product, a product that has been discontinued, or a product that has been released. If the corresponding product is a normal product, a coefficient “1.0” is set in an area for setting the coefficient of the corresponding product in S32. If the corresponding product is a new product, the coefficient “3.0” is set in the area for setting the coefficient of the corresponding product in S33. If the corresponding product is a production discontinued product, a coefficient “0.5” is set in the area for setting the coefficient of the corresponding product in S34. If the corresponding product is a product whose sale has been canceled, a coefficient “0” is set in the area for setting the coefficient of the corresponding product in S35. As a result, the coefficient is set in the area A in which the coefficient of each product in the order information table 245 is set as shown in FIG.

  Further, in the order correction process of S4, as shown in FIG. 13, an order is input in S41, the component ratio corresponding to the product stored in the temporary storage table 235 is corrected according to the coefficient, and the corrected value Is stored in the component ratio storage column of the temporary storage table 235. For example, if the composition ratio of the product ABC is 7.27%, the composition ratio of the product EFD is 2.53%, the composition ratio of the product FGE is 2.12%, and the composition ratio of the product CAB is 1.37%. The product ABC has a coefficient of “1.0”, so the composition ratio remains the same. The product EFD has a coefficient of “0.0”, so the composition ratio is 0%, and the product FGE has a coefficient of “0.5”, so the composition ratio is The product CAB has a coefficient of “3.0”, so the composition ratio is tripled to 4.11%.

  Subsequently, in S42, it is checked whether or not the correction category is only the composition ratio. If it is only the composition ratio, the composition ratio of each product that has been ordered is input in the order information table 245. Is stored in the storage column of the composition ratio of the temporary storage table, and in S44, the total order quantity of each product that has been ordered is calculated, and the total value is stored in the corresponding storage column. The stored contents are displayed on the liquid crystal display 25.

  If the correction category is a correction category that takes account of the growth rate, the component ratio and the elongation rate are read from the ordering information table 245 for each product that has been ordered and input in S45, and the component ratio × the elongation rate. The component ratio is corrected by performing the above calculation, the corrected component ratio is stored in the component ratio storage column of the temporary storage table, and the corresponding elongation rate is stored in the elongation rate storage column. Then, the sum of the corrected component ratios of each product is calculated, the total value is stored in the corresponding storage field, and the stored content is displayed on the liquid crystal display 25.

Subsequently, in S46, the composition ratio distribution ratio of the ordered product is calculated from the composition ratio of each commodity and the total value thereof, and stored in the composition ratio distribution ratio storage column of the corresponding commodity in the temporary storage table. Displayed on the liquid crystal display 25. Subsequently, in S47, the corrected order quantity is calculated from the calculated composition ratio distribution ratio and the input order quantity, and stored in the correction value storage column of the corresponding product in the temporary storage table 235, and the stored contents are stored in the liquid crystal display 25. To display. Such a process is performed for all the products for which an order has been input, and when it is determined in S48 that the process has been completed, the order correction process is terminated.
The processing from S42 to S48 in the order correction processing described above is the same as the processing from S21 to S27 in FIG.

  Here, since the selected correction category is a correction category that is corrected by taking the elongation rate into account, the component ratio is further corrected by the processing of S24. That is, the composition ratio of the product ABC is 7.27% multiplied by the growth rate to be 7.78%. Since the product EFD has a composition ratio of 0%, it becomes 0% as it is. The composition ratio of the product FGE is 1.06% multiplied by the growth rate to be 0.86%. The composition ratio 4.11% of the product CAB is 14.9% multiplied by the growth rate. The total value is 23.54%.

  By calculating the composition ratio distribution ratio of each product, the composition ratio distribution ratio of the product ABC is 33%, the composition ratio distribution ratio of the product EFD is 0%, the composition ratio distribution ratio of the product FGE is 4%, and the composition of the product CAB. The specific distribution rate is 63%. The total value is 100%. Accordingly, the number of corrected orders for the product ABC is 119, the number of corrected orders for the product EFD is 0, the number of corrected orders for the product FGE is 14, and the number of corrected orders for the product CAB is 227. The total number of orders is 360 before and after correction.

In this way, since the number of orders for each product input using the composition ratio and growth rate of the research information searched on the research site is corrected, it is possible to place an order quantity that fully reflects the market trend for each product.
In addition, the product information in the research information is also used, and the composition ratio is corrected by setting a coefficient depending on whether the product is a new product, a discontinued product, a discontinued product, or a normal product other than that. Since the order quantity of the product has been corrected, even if an order is entered without knowing whether the product is a new product, a discontinued product, a discontinued product or a normal product other than that, The new product is corrected so that the number of orders is increased, the canceled product is corrected so that the number of orders is decreased, and the canceled product is corrected so as not to be ordered at all. As a result, it is possible to place orders for products that more fully reflect the latest market trends.

1 is a block diagram showing a configuration of an entire system according to a first embodiment of the present invention. The block diagram which shows the structure of the order terminal in the embodiment. The flowchart which shows the order quantity management processing of the order terminal in the embodiment. The flowchart which shows the order input process in the order quantity management process of FIG. The figure which shows the structure of the order information table in the embodiment. The flowchart which shows the order correction process in the order quantity management process of FIG. The figure which shows the structure of the temporary storage table at the time of only the structure ratio in the embodiment. The figure which shows the structure of a temporary storage table when the elongation rate is considered to the structure ratio in the embodiment. The figure which shows the structure of the order table produced at the time of ordering in the embodiment. The flowchart which shows the order correction information acquisition process which concerns on the 2nd Embodiment of this invention. The figure which shows the structure of the temporary storage table in the embodiment. The figure which shows the structure of the order information table in the embodiment. The flowchart which shows the order correction process in the embodiment.

Explanation of symbols

  2 ... Order terminal, 21 ... CPU (Central Processing Unit), 25 ... Liquid crystal display, 27 ... Keyboard, 231, 232 ... Temporary storage table.

Claims (6)

Information retrieval means to access research sites on the Internet and capture research information such as product information of various products belonging to the same product classification, composition ratio corresponding to sales results, growth rate from the previous survey,
Order information table creating means for creating an order information table in which product information, composition ratio, and growth rate of each product are set based on the research information captured by the information capturing means;
Order input means for entering product information and the number of orders to order separately for each product category,
The composition ratio corresponding to each product input by the order input means is read from the order information table, the composition ratio distribution ratio is obtained from each composition ratio and the total value, and each composition ratio input ratio and each commodity input. Calculating means for obtaining a correction value of the order quantity of each product from the total value of the order quantity of
A temporary storage table creation means for creating a table for temporarily storing at least the product information, the order quantity, the composition ratio, the obtained composition ratio distribution ratio, and the corrected order quantity of each commodity input;
An order quantity management apparatus comprising: a display for displaying contents of a table created by the temporary storage table creating means. Information retrieval means to access research sites on the Internet and capture research information such as product information of various products belonging to the same product classification, composition ratio corresponding to sales results, growth rate from the previous survey,
Order information table creating means for creating an order information table in which product information, composition ratio, and growth rate of each product are set based on the research information captured by the information capturing means;
Order input means for entering product information and the number of orders to order separately for each product category,
The composition ratio and the growth rate corresponding to each product input by the order input means are read from the ordering information table, each composition ratio is corrected with the corresponding elongation ratio, each of the corrected composition ratios and the total value thereof are corrected. Calculating means for calculating the composition ratio distribution ratio from the above, and calculating means for calculating the correction value of the order quantity of each product from the composition ratio distribution ratio and the total value of the order quantity of each product input;
A temporary storage table creating means for creating a table for temporarily storing at least the product information, the order quantity, the corrected composition ratio, the obtained composition ratio distribution ratio, and the corrected order quantity of each commodity input;
An order quantity management apparatus comprising: a display for displaying contents of a table created by the temporary storage table creating means. Access to research sites on the Internet, research information consisting of product information of various products belonging to the same product category, composition ratio corresponding to sales results, growth rate from the previous survey, information on new products and discontinued products, etc. Information capturing means for capturing,
Order information table creating means for creating an order information table in which product information, composition ratio, and growth rate of each product are set based on the research information captured by the information capturing means;
Coefficient setting means for setting the coefficient of each product determined on the basis of information such as a new product or a discontinued product of research information captured by the information capturing device for each product in the order information table;
Order input means for entering product information and the number of orders to order separately for each product category,
The component ratio and coefficient corresponding to each product input by the order input means are read from the order information table, each component ratio is corrected with the corresponding coefficient, and the component ratio and the total value are corrected. An arithmetic means for obtaining a ratio distribution ratio and obtaining a correction value for the order quantity of each product from the composition ratio distribution ratio and the total value of the order quantity of each product input;
A temporary storage table creating means for creating a table for temporarily storing at least product information, order quantity, corrected composition ratio, obtained composition ratio distribution ratio and order quantity correction value of each commodity;
An order quantity management apparatus comprising: a display for displaying contents of a table created by the temporary storage table creating means.   If there is a product that has been canceled in the research information that has been imported, the coefficient setting means sets the coefficient to zero for the corresponding product in the order information table, thereby forcing the number of orders to be zero with the corresponding product composition ratio set to zero. 4. The order quantity management apparatus according to claim 3, wherein the order quantity management apparatus corrects to zero.   Access to a research site on the Internet and import research information such as product information of various products belonging to the same product category, composition ratio corresponding to sales results, growth rate from the previous survey, and so on. Based on this, create an order information table that sets the product information, composition ratio, and growth rate of each product. On the other hand, enter the product information and the number of orders to be ordered separately for each product category using the order entry means. The composition ratio corresponding to each product is read from the order information table, the composition ratio distribution ratio is obtained from each composition ratio and the total value thereof, and the composition ratio distribution ratio and the total value of the number of orders for each commodity input A correction value for the number of orders for each product is obtained from the table, and at least a table for temporarily storing the product information, order quantity, component ratio, calculated composition ratio distribution ratio and corrected order quantity for each product entered is created. Order number of management method characterized in that it displays the contents of the table that you created in the display. Computer
Information retrieval means to access research sites on the Internet and capture research information such as product information of various products belonging to the same product classification, composition ratio corresponding to sales results, growth rate from the previous survey,
Order information table creating means for creating an order information table in which product information, composition ratio, and growth rate of each product are set based on the research information captured by the information capturing means;
By inputting the product information to be ordered separately for each product category and the number of orders with the order input means, the component ratio corresponding to each input product is read from the order information table, and each component ratio and its total value And calculating means for determining a composition ratio distribution ratio, and calculating a correction value for the number of orders of each product from the composition ratio distribution ratio and the total value of the number of orders of each input product,
An order quantity management program for functioning as a temporary storage table creation means for creating a table for temporarily storing at least product information, order quantity, composition ratio, calculated composition ratio distribution ratio and corrected order quantity of each inputted commodity.

Images