JPH10207950A - Raw material ordering system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To suppress the degradation in freshness or the deficiency of raw materials due to excessive stock by distinctly calculating whether additional ordering is unnecessary or not at the time of ordering raw materials. SOLUTION: A required raw material calculation processing part 2 stores a quantity predetermined to be used of each required raw material code in an integrating word area in accordance with a quantity predetermined to be produced. A use raw material integrating processing part 3 integrates a corresponding quantity to be predetermined to be used in a raw material integrating file 8 to a quantity predetermined to be cumulatively used in an ordering predetermination area in this file 8 by a raw material code. A required raw material display processing part 4 detects a raw material code by the system date and checks whether there is a preceding ordering area or not; and if there is not, the quantity predetermined to be cumulatively used is set to the quantity of ordering in the ordering determination area. An ordering processing part 5 generates an order slip with the raw material code, the quantity of ordering, etc., from the raw material integrating file 8 and gives an order. A receipt processing part compares the quantity of receipt with the quantity of ordering; and if they are different, a warning message obtained by editing the quantity of receipt, the quantity of ordering, the raw material code, and the ordering number is outputted.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for ordering raw materials in a shop that manufactures and sells commodities, and more particularly to a method for ordering raw materials for determining the order quantity of raw materials constituting a product to be manufactured in a timely manner.

[0002]

2. Description of the Related Art In a conventional raw material ordering method, an ordering operation is performed by deciding an order amount based on a result of individually calculating a raw material constituting one product from a production amount of the product.

For example, Japanese Patent Application Laid-Open No. 7-129660 "MRP
In the “processing device”, a material requirement plan (MRP: Material Requirements) for arranging material parts
An MRP processing control unit corresponding to the product order is provided by an order management unit that manages order information of a plurality of products and a component configuration management unit that manages component configuration information indicating material parts necessary for each product. Through the MRP processing unit, the number of parts required for a predetermined period is calculated, and efficient production management is performed.

In Japanese Patent Application Laid-Open No. 4-122558, "production management system", production plan information storage means comprising the quantity of products to be produced and the order of production, and product composition information comprising parts constituting each product and a required number are stored. Product planning information storage means, and an inventory management means having an automatic warehouse for parts and managing the number of stocks for each part. Create slip data and place an order with a parts manufacturer.

[0005]

In the conventional ordering system described above, in the stage of determining the order quantity of raw materials necessary for manufacturing a product, the raw materials are regarded as one product, and the raw materials necessary for manufacturing the product are simply regarded as one product. Since the quantity of raw materials is determined and the order is placed once a week, it is not suitable for a short delivery order method using fresh food.

SUMMARY OF THE INVENTION It is an object of the present invention to optimize the order quantity of raw materials used for producing short-term products using perishable products at the stage of ordering them from raw material manufacturers. It is an object of the present invention to provide a raw material ordering system with a short delivery time which solves the problem that a product cannot be manufactured due to deterioration in freshness and disposal, or shortage of raw materials.

[0007]

According to a first aspect of the present invention, there is provided a raw material ordering system comprising: a product configuration file recording a configuration of raw materials required for manufacturing the product; a raw material integration file recording a use state of the raw materials; A product manufacturing plan processing unit that obtains manufacturing plan information including a product manufacturing plan, and a necessary raw material calculation processing unit that refers to the product configuration file and calculates a planned use number of raw materials required for manufacturing the product. ,
A raw material integration processing unit that integrates the calculated planned use number of the raw material into the planned use number corresponding to the raw material in the raw material integration file, and a necessary raw material display that determines a raw material that needs to be ordered and displays it on a display device. A processing unit, an order processing unit that creates and displays an order slip for the displayed raw material, and an arrival processing unit that obtains receiving information including the amount of raw material received when receiving and updates the raw material integration file. It is configured.

According to a second aspect of the present invention, in the raw material ordering method according to the first aspect, the production plan information includes a product code indicating a type of a product, a planned production number indicating a production number of the product, The date and time of production indicating the production time are provided.

Further, the raw material ordering method of the third invention is as follows.
In the first invention, the product configuration file includes raw material data required for manufacturing for each product code, the number of constituent raw materials indicating a total number of the raw material data, a raw material code indicating a type of the raw material, and one product. The number of raw materials used to manufacture the raw materials, the ordering unit indicating the unit for ordering the raw materials,
It is provided with. Further, in the raw material ordering method according to a fourth invention, in the first invention, the raw material integration file has a planned ordering area and a pre-ordering area for each raw material, and the planned ordering area includes a raw material necessary for manufacturing a product. Cumulative scheduled use number to accumulate the used number, accumulated update date and time accumulated, order quantity for replenishing stock and shortage by subtracting the cumulative scheduled use number, order number and order year indicating order identification The date, the date of arrival and the amount of arrival used when the ordered raw materials are received, the pre-order area is recorded as a history when the planned order area is ordered It is configured.

Further, a raw material ordering method according to a fifth aspect of the present invention
In the first or fourth aspect of the present invention, the determination of the order in the necessary raw material display processing section is performed by determining a value obtained by subtracting the cumulative use number in the planned order area detected from the raw material integration file from the stock amount in the previous order area. When the quantity is equal to or less than the quantity, the subtracted numerical value is edited into the order quantity of the planned order area, and when the previous order area does not exist, the cumulative use quantity of the planned order area is edited into the order quantity of the same area. I have.

Further, a raw material ordering method according to a sixth aspect of the present invention
In the first invention, the arrival information includes a raw material code indicating a type of the received raw material, an order date and an order number when an order is placed, and an arrival date and an arrival amount when the order is received. It is constituted by.

[0012]

Next, an embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention.

FIG. 2 is a layout diagram of manufacturing plan information including the planned number of products for each product according to the present invention.

FIG. 3 is a layout diagram of a product configuration file in which raw materials required for each product in the present invention are configured.

FIG. 4 is a layout diagram of a raw material integration file in which the planned use number is integrated for each raw material in the present invention.

FIG. 5 is a layout diagram of the arrival information including the amount of arrival for each raw material.

In this embodiment, as shown in FIG. 1, a product manufacturing plan processing unit 1, a necessary raw material calculation processing unit 2, a used raw material integration processing unit 3, a required raw material display processing unit 4, an order processing unit 5, A processing device 12 including a processing unit 6; a storage device 15 including a preset product configuration file 7 and a raw material integration file 8; and a recording medium 9 storing a program for causing a computer to perform the processing of the processing device 12. ,
It comprises an input device 13 and an output device 14.

Next, FIG. 1, FIG. 2, FIG. 3, FIG.
This will be described in detail with reference to FIG.

The product manufacturing plan processing section 1 is activated when the manufacturing plan information 10 of the layout shown in FIG. 2 is input from the input device 13, and the product code, the planned production number, and the production start date of the production planning information 10 And notifies the necessary raw material calculation processing unit 2.

The necessary raw material calculation processing unit 2 uses the product code of the notification to produce a product configuration file 7 having the layout shown in FIG.
Is calculated, and the expected number of used materials for each required raw material code is calculated from the notified number of planned production (the number of planned production times × the number of used raw materials ÷ the ordering unit = the number of planned uses), and the usage schedule calculated for each raw material code is calculated. The numbers are sequentially stored in the integration work area of the internal memory, and when the processing of all the product codes of the manufacturing plan information 10 is completed, the number is notified to the used raw material integration processing unit 3.

The used raw material integration processing section 3 searches the raw material integration file 8 having the layout shown in FIG. 4 by using the raw material code stored in the integrated work area of the internal memory, and corresponds to the raw material code stored in the integrated work area. The planned use number is added to the cumulative planned use number of the ordering area of the retrieved raw material totalization file 8, and the system date managed by the system is set to the cumulative update date of the same area. Output to When the integration processing of all the raw material codes stored in the integration work area into the raw material integration file 8 is completed, the necessary raw material display processing unit 4 is notified.

The necessary raw material display processing section 4 searches the raw material integration file 8 by the system date to detect the raw material code of the same integrated update date. If it is not checked whether there is a previous order area, which is the history information of the detected raw material code, the cumulative use number of the order area is set to the order quantity of the same area.

When there is a pre-order area for the detected raw material code, the stock quantity in the latest pre-order area is checked, and when the stock quantity is less than 1, the cumulative use number of the planned order area is set to the order quantity in the same area. Then, the raw material code, the order quantity of the planned ordering area, and the totalization update date are displayed on the output device 14 and output to the raw material totalization file 8, and then the raw material totalization file 8 is searched by the system date to obtain the same totalization update year. Detect the raw material code of the date.

When there is an order history of the detected raw material code, if the stock quantity in the latest previous order area is 1 or more, a numerical value obtained by subtracting the cumulative use quantity in the order area from the immediately preceding stock quantity. If the value is 1 or more, no order is required, so set the order quantity in the planned order area to 0, and if the subtracted value is less than 1, set the subtracted value to the stock quantity and order quantity in the planned order area, And the order quantity of the planned ordering area and the cumulative update date are displayed on the output device 14 and output to the raw material total file 8. Then, the raw material total file 8 is searched by the system date and the same raw material update date is calculated. Detect code.

When the end of the raw material integration file 8 is detected on the date of the system, the order processing unit 5 is notified.

The order processing section 5 searches the raw material integration file 8 with the raw material code displayed on the output device 14 and sets the order number managed by the serial number to the order number in the planned order area of the detected raw material code. Calculate the order date considering the order unit from the renewal date of the same area, set the order date of the same area, and set the order slip using the raw material code, order date, order number and order quantity. Create and place an order.

The edited contents of the planned ordering area in which the order slip was created are output as history information to the previous ordering area, and all the contents of the planned ordering area are cleared and output to the raw material integration file 8. The processing is sequentially performed until all the raw material codes displayed on the display device are completed. When the processing is completed, the raw material order processing corresponding to the manufacturing plan information 10 is completed. .

The arrival processing section 6 is activated when the arrival information 11 having the layout shown in FIG. 5 is input from the input device 13, and acquires the arrival information 11. The raw material totalization file 8 is searched with the obtained raw material code, order date, and order number, and the received date and amount of the corresponding previous order area detected and detected are added to the received date and amount of the obtained received information 11. Are set, and the obtained arrival amount is added to the stock amount in the same area.

If the received quantity differs from the ordered quantity, a warning message in which the received quantity, the ordered quantity, the raw material code, and the order number are edited is output to an output device, and designated in the received information 11. The processing is performed until all the processed raw material codes are completed.

[0031]

As described above, according to the present invention, at the time of ordering raw materials, it is possible to clearly calculate whether or not it is necessary to additionally order raw materials necessary for producing a product of a planned number of products. Become like As a result, it is possible to place an order in a timely manner, and there is an effect of suppressing a decrease in freshness or a shortage of raw materials due to excess inventory.

The reason for this is that the amount of raw materials necessary for producing the number of products to be manufactured is calculated from the current stock amount of each product, so that the stock is minimized. In addition, since the amount of use is determined from the number of products to be manufactured, the consumption of raw materials can be reliably grasped.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention.

FIG. 2 is a layout diagram of manufacturing plan information including a planned number of products for each product according to the embodiment of the present invention.

FIG. 3 is a layout diagram of a product configuration file in which raw materials required for each product according to the embodiment of the present invention are configured.

FIG. 4 is a layout diagram of a raw material integration file in which the planned number of use is integrated for each raw material according to the embodiment of the present invention.

FIG. 5 is a layout diagram of arrival information including an arrival amount for each raw material according to the embodiment of the present invention.

[Explanation of symbols]

 1 Product Production Planning Processing Section 2 Required Raw Material Calculation Processing Section 3 Used Raw Material Total Processing Section 4 Required Raw Material Display Processing Section 5 Order Processing Section 6 Receiving Processing Section 7 Product Configuration File 8 Raw Material Total File 9 Recording Medium 10 Manufacturing Planning Information 11 Receiving Information Reference Signs List 12 processing device 13 input device 14 output device 15 storage device

Claims (6)

[Claims] 1. A raw material ordering system for determining an order quantity of raw materials necessary for manufacturing a planned product and placing an order, wherein: a product configuration file recording a configuration of raw materials required for manufacturing the product; A raw material integration file that records the use state of the raw materials, a product manufacturing plan processing unit that obtains manufacturing plan information including a product manufacturing plan, and a product configuration file. A necessary raw material calculation processing section for calculating the planned use number, a used raw material integration processing section for integrating the calculated planned use number of the raw material to the planned use number corresponding to the raw material in the raw material integration file, and an order is required. A raw material display processing unit that determines the raw material to be displayed on the display device, an order processing unit that creates an order slip for the displayed raw material and places an order, Raw materials ordering system, characterized in that it comprises a stock processing unit obtains the stock information including the arrival of the raw materials for updating the raw material accumulated file, a. 2. The manufacturing plan information includes: a product code indicating a type of a product; a planned manufacturing number indicating a number of manufactured products;
2. The raw material ordering system according to claim 1, further comprising: a production start date indicating a production time of the product. 3. The product configuration file includes raw material data required for manufacturing for each product code, the number of constituent raw materials indicating a total number of the raw material data, a raw material code indicating a type of the raw material, and one product. 2. The raw material ordering method according to claim 1, further comprising: a number of raw materials used for manufacturing the raw materials; and an order unit indicating a unit for ordering the raw materials. 4. The raw material integration file has a planned order area and a pre-order area for each raw material, and the planned order area includes:
The cumulative number of raw materials used for manufacturing the product, the cumulative use number, the cumulative update date, and the cumulative update number, the stock quantity obtained by subtracting the cumulative use number, the order quantity for replenishing the shortage, and the order identification. The order number indicates the order number, the order date, and the arrival date and time used when the ordered raw material is received, and the pre-order area is the history when the planned order area was ordered. The raw material ordering system according to claim 1, wherein the raw material ordering method is recorded. 5. The determination of an order in the necessary raw material display processing section is such that a value obtained by subtracting the cumulative use number of the planned order area detected from the raw material integration file from the stock amount of the previous order area is equal to or less than a prescribed stock amount. In the case of (1), the subtracted numerical value is edited into the order quantity of the planned order area, and if the previous order area does not exist, the cumulative use number of the planned order area is edited into the order quantity of the same area. Raw material ordering method described in 1 or 4. 6. The receiving information includes a raw material code indicating a type of the received raw material, an order date and an order number when the order is placed, an arrival date and a receiving amount when the order is received. The raw material ordering system according to claim 1, wherein: