JP2002149226A - System and method for generating production plan - Google Patents

Abstract

PROBLEM TO BE SOLVED: To generate a production plan while taking both regular article sales result information from an agent to a retailer and event plan information as the result of negotiations with retainer' persons in charge into consideration. SOLUTION: An agent computer 1a, etc., where regular article sales results are inputted, an agent communication management computer 2, and an event plan input computer 3a, etc., are connected to a production plan generating computer 4 and a database server 5 through communication networks N1 and N2; and the production plan generating computer 4 generates a production plan by regarding a reference stock quantity-actual stock quantity value as the replenishment request quantity of the regular article as a replenishment request quantity when the actual stock quantity of the regular article decreases below a replenishment point according to the reference stock quantity and replenishment point set according to the sales actual result of the regular article and regarding a reference stock quantity - (actual stock quantity -event quantity) value as the replenishment quantity of an event article when the effective stock quantity obtained by subtracting the event quantity from the actual stock quantity decrease the replenishment point according to the event quantity a certain period before the delivery date obtained from the event plan information.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[Technical field to which the present invention pertains] As a characteristic of sales of life goods (durable consumer goods for daily necessities), it is called a staple item. There are two types of sales methods, which are called “sale sales” and sales methods that sell a large amount at a low unit price. The present invention is applied to such a production plan suitable for sale of life goods, and is a special event which is information on sales results of standard products from an agency to a retail store and a result of a business talk with a person in charge of the retail store. The present invention relates to a production plan creation system and a production plan creation method for creating a production plan based on product planning information.

[0002]

2. Description of the Related Art Conventionally, as a business flow, a manufacturer produces products and sells them to retailers via distributors (wholesalers). It is common to sell to.

However, in such a business flow, a maker can only control shipping information to an agent, and quantitatively grasps how much merchandise is shipped from an agent to which retailer. There was a problem that can not be. For this reason, it is extremely difficult for the manufacturer to predict the production of products that are sold in different ways, such as standard products and special events, in which the products are replaced frequently (for example, when the products are replaced every six months due to seasonal fluctuations, etc.). It was a situation.

That is, in the conventional method of creating a production plan for prospective production, the production part number and the production quantity are often determined by an order point method based on the sales results of the previous year. For this reason, it is necessary to change the ordering point and the replenishing point at any time in consideration of fluctuations (variations) in demand due to replacement of products, etc., and it has been difficult as a practical problem.

Therefore, the present applicant collects information on market movements and sales information from distributors to retailers and sets ordering points and replenishment points, thereby accurately reflecting market movements. Provides production planning equipment (Japanese Patent Application No. Hei 11
-48540).

[0006] According to this production planning device, for a standard product, it becomes possible to follow the movement of cargo in the market by observing the sales trend from the agent to the retail store.

[0007]

However, this production planning device can only predict how to sell stably sold staple products. For so-called special sales, which are called special events, There remains a problem that it is impossible to predict only market movements.

The present invention has been made to solve such a problem. The purpose of the present invention is to provide information on sales results of standard products from an agency to a retail store and a result of a business talk with a person in charge of the retail store. To provide a production plan creation system and a production plan creation method capable of creating a production plan without delay of delivery corresponding to a standard product and an event product by creating a production plan in consideration of both information and production information. It is in.

[0009]

In order to solve the above-mentioned problems, a production plan creation system according to the present invention classifies products to be subjected to a production plan into a standard product and an event product, and sends a product from an agent to a retail store. The standard product sales result acquisition means for obtaining the sales results of the standard products, the event plan information obtaining means for obtaining the special event plan information that is the result of negotiations with the retail store, and the setting based on the sales results of the standard products Based on the reference stock amount and the replenishment point, when the actual stock amount of the staple product falls below the replenishment point, a production plan is created with the reference stock amount-the actual stock amount as the required replenishment amount of the staple product, and the event planning information When the effective inventory amount obtained by subtracting the event quantity from the actual inventory amount based on the event quantity obtained a predetermined period before the delivery date obtained below falls below the replenishment point, the reference inventory amount− (actual inventory amount−event quantity) is calculated. Production plan as required replenishment of special events Characterized in that a production plan creation means for creating.

In the production planning method according to the present invention, the products to be produced are classified into standard products and special events, and the standard products are set based on the sales results from agents to retailers. When the actual stock quantity falls below the replenishment point based on the reference stock quantity and the replenishment point, a production plan is created with the reference stock quantity minus the actual stock quantity as a replenishment request quantity.
Based on the event quantity before a certain period before the delivery date, when the effective stock quantity obtained by subtracting the event quantity from the actual stock quantity falls below the replenishment point, the standard stock quantity-(actual stock quantity-event quantity) is produced as the replenishment request quantity. It is characterized by creating a plan.

According to the production plan creation system and the production plan creation method of the present invention having the above-described features, while the staple product sales result acquisition means acquires the sales results of staple items from the agent to the retail store, The event planning information acquisition means acquires event planning information that is the result of a business talk between a sales representative of the maker and a purchaser of a retail store.

In the production plan creating means, the standard stock amount and the replenishment point are set based on the sales results of the standard products obtained by the standard product sales result obtaining means. Then, based on the set reference stock amount and the replenishment point, when the actual stock amount of the standard product falls below the replenishment point, a production plan is created with the reference stock amount-the actual stock amount as the standard product replenishment request amount.

For example, when the standard stock month is set to one month and the replenishment point month is set to 0.6 months, when the sales amount of standard products in the last month is 1,000, the standard stock amount is 1000.
The number of pieces and replenishment points is (standard stock amount (1000) × number of months of replenishment points (0.6) = 600 pieces). That is, if the actual stock quantity falls below the replenishment point (600 pieces), the stock is reduced to one of the reference stock quantity.
Production will be raised to 000 units.

[0014] In the production plan creation means, based on the event quantity of a certain period before the delivery date obtained from the event planning information,
When the effective stock quantity, which is the actual stock quantity minus the event quantity, falls below the replenishment point, "base stock quantity-(actual stock quantity-event quantity)"
A production plan is created with the replenishment request amount for the event.

The development of a special event is determined by negotiations, and therefore cannot be predicted. Therefore, it is made to order based on the event planning information that is the result of the negotiation. Therefore, assuming that the production lead time of the factory is 10 days, it is necessary to incorporate the event quantity two weeks before the delivery date (a certain period of time) into the production plan. Therefore, when the effective stock amount in consideration of the event falls below the replenishment point, production is performed.
That is, if “supplement point> stock− [event quantity (within two weeks)]”, “production quantity = reference inventory quantity− (actual inventory quantity−event quantity)”. This makes it possible to incorporate both standard products and special events into the production plan.

[0016]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a schematic diagram showing a hardware configuration of a production plan creation system according to this embodiment.

The production plan creation system includes agency computers 1a, 1b, 1c... Installed at each agency.
Is connected via a communication network N1 such as the Internet, a LAN, or a WAN to an agency communication management computer 2 constituting the present system, and is installed in the agency communication management computer 2 and each sales office of a maker. The event planning input computers 3a, 3b, 3c ...
A production plan creation computer 4 and a database server 5 via a communication network N2 such as a LAN or a WAN.
It is configured to be connected to

The agency communication management computer 2 stores the sales results of standard products from the agency to the retail store (information on the retail store, product number, shipping date, shipping amount, etc.) by the respective agency computers 1a,
1b, 1c,... And registered in the sales record database in the database server 5 via the communication network N2.

The event planning input computers 3a, 3
b, 3c ... are the sales representatives of each sales office of the manufacturer.
This is a computer for inputting event planning information as a result of negotiations with a purchaser at a retail store. The input event planning information is registered in the event planning information database in the database server 5 via the communication network N2. .

The production plan creation computer 4 sets a standard stock amount and a replenishment point based on the sales results of the standard products registered in the database server 5. Then, based on the set standard stock amount and the replenishment point, when the actual stock amount of the standard product falls below the replenishment point, a production plan is created with "standard stock amount-actual stock amount" as the standard product replenishment request amount. I do. Further, the event quantity before a certain period of the delivery date is extracted from the event planning information registered in the database server 5, and based on the event quantity, the effective stock quantity obtained by subtracting the event quantity from the actual stock quantity falls below the replenishment point. Then, a production plan is created with "reference stock amount-(actual stock amount-event quantity)" as the event item replenishment request amount.

Hereinafter, an example of the production plan creation system of the present embodiment will be described.

[Embodiment] Agent communication management computer 2
Acquires the information (data) of the agency from the agency computers 1a, 1b, 1c,... The acquired data is the ordering retailer code, part number,
It consists of items of shipping date and shipping quantity. An example of this agency sales performance data is shown in Table 1 below.

[0024]

[Table 1]

According to the sales data of the agency, the retailer with the retailer code 001 stores 30 products of the product number A and product number B
Are shipped on October 10 and 50 products of the product number A are sent to the retail store with the retail store code 002.
This indicates that the product was shipped on October 10th. This agency sales record data is registered in the sales record database in the database server 5.

On the other hand, the event planning input computers 3a, 3
From b, 3c,..., event planning data, which is the result of a sales rep of each sales office of a maker having a business talk with a purchase clerk at a retail store, is input. The event planning data includes items such as a retail store code, a delivery date, a product number, and a quantity. An example of the event planning data is shown in Table 2 below.

[0027]

[Table 2]

In this event planning data, the retail store code 0
It is shown that 500 products of the product number A will be delivered as a special event to the retail store No. 01 on the delivery date of October 20.
The event planning data is registered in the event planning information database in the database server 5.

The production plan making computer 4 sets a standard stock amount and a replenishment point based on the basic product sales data registered in the database server 5.

For example, when the standard stock month of the product of the product number A is set at 1 month and the replenishment point is set at 0.6 month, when the number of sales of the standard product of the product number A in the latest one month is 1,000, The reference stock quantity is 1000 pieces, and the replenishment points are (reference stock quantity (1000 pieces) × replenishment point months (0.6) = 600 pieces). As a result, each production reference value registered in the database server 5 is a value shown in Table 3.

[0031]

[Table 3]

When the actual stock quantity falls below the replenishment point (600 pieces), the production plan making computer 4 performs the production to raise the stock to the standard stock quantity of 1000 pieces.

Next, a method of calculating the production planning amount in consideration of such standard products and special events will be described with reference to a flowchart shown in FIG.

The development of the event is determined by the business negotiation, and therefore cannot be predicted. Therefore, it is made to order based on the event planning information that is the result of the negotiation. Therefore, assuming that the production lead time of the factory is 10 days, it is necessary to incorporate the event quantity two weeks (2W) before the delivery date into the production plan. Therefore, when the effective stock amount including the event falls below the replenishment point (600 pieces), production is performed.

That is, the production planning computer 4
Is the manufacturer's stock information (part number, stock amount) registered in the database server 5, the production reference value (part number, reference stock amount, replenishment point), and event planning information (part number, delivery date, quantity)
(Step S1), and based on the obtained information, it is determined whether or not replenishment point> actual stock amount− [event quantity (within two weeks)] (1) (step S1) S2). as a result,
If “supplement point> actual stock quantity− [event quantity (within 2 weeks)]” (if determined to be Yes in step S2), production quantity = reference inventory quantity− (actual inventory quantity−event quantity) is calculated. Then, the calculation result is registered in the production plan database of the database server 5 as the production amount of the corresponding product number (step S).
3).

Here, looking at the product of the product number A, if the actual stock quantity of the product of the product number A is 700 pieces, when applied to the above equation (1), the replenishment point (600)> the actual stock quantity (700) -Event quantity 2W
(500), which satisfies the condition of step S2 (determined as Yes in step S2).
According to the calculation formula of the next step S3, the production amount = the standard stock amount (1000) − (the actual stock amount (70
0)-Event quantity within 2W (500) = 800 pieces. The production plan creation computer 4 registers this calculation result in the production plan database of the database server 5 as the production quantity of the product number A.

On the other hand, "replenishment point> actual stock quantity-event quantity 2W
If it is not “within” (if No is determined in step S2), it is not necessary to produce the part number yet, so that production is unnecessary (step S4).

If the processing of all the part numbers has not been completed (No in step S5), the next part number is selected (step S6), and the process returns to step S2.

The production plan creating computer 4 repeats such processing until the last part number is completed (step S5).
Is repeated until a production plan is created for each product number, and the database server 5
Register in the production planning database. Incidentally, FIG.
It is a graph which shows the image of the production amount of a standard product and an event product calculated by the production plan creation computer 4.

This makes it possible to create a production plan that takes into account both standard products and special events, so that products sold as both standard products and special events can be reliably incorporated into the production plan without running out of stock. Can be.

[0041]

According to the production plan creation system and the production plan creation method of the present invention, a production plan that takes into account both standard products and special events can be created, so that products sold as both standard products and special events Can be reliably incorporated into a production plan without running out of stock.

[Brief description of the drawings]

FIG. 1 is a schematic diagram showing a hardware configuration of a production plan creation system of the present invention.

FIG. 2 is a flowchart for explaining a method of calculating a production plan amount in consideration of a standard product and an event product in the production plan creation system and the production plan creation method of the present invention.

FIG. 3 is a graph showing an image of a production amount of a standard product and an event product calculated by a production plan creation computer.

[Explanation of symbols]

 1a, 1b, 1c Agency computer 2 Agency communication management computer 3a, 3b, 3c Event planning input computer 4 Production planning computer 5 Database server N1, N2 Communication network

Claims (2)

[Claims] [Claim 1] A standard product sales result acquisition means for classifying products to be subjected to a production plan into a standard product and an event product, and obtaining a sales result of the standard product from an agent to a retail store; Event planning information acquisition means for acquiring event planning information that is the result of a business negotiation, based on the standard stock amount and the replenishment point set based on the sales performance of the staple product, the actual stock amount of the staple product is used as the replenishment point. When it falls below, the standard inventory amount minus the actual inventory amount is used as a request for replenishment of standard products, and a production plan is created. A production plan creating means for creating a production plan by using the reference inventory amount- (actual inventory amount-event quantity) as a replenishment request amount for an event item when the available stock amount after the quantity falls below the replenishment point; Production planning system characterized by M 2. The product to be subjected to the production plan is classified into a standard product and an event product. For the standard product, a reference stock amount and a replenishment point set based on the sales performance from the agency to the retail store are included. When the actual inventory volume falls below the replenishment point, a production plan is created with the standard inventory volume minus the actual inventory volume as the required replenishment volume.For special events, the actual inventory is calculated based on the event volume a certain period before the delivery date. When the effective stock amount obtained by subtracting the event quantity from the quantity falls below the replenishment point, a production plan is created using the reference stock amount- (actual stock amount-event quantity) as a replenishment request amount. .