JP2002007823A - Sales distribution system, and appropriate arranging method of stock in the system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To suppress generation of shortage of commodities caused by the increase of the demand after the stock adjustment, or generation of excessive stocks caused by the decrease in the demand after the stock adjustment. SOLUTION: In this sales distribution system in which a keyboard display device 12 of a terminal for setting the order reception sureness for an expected item is connected to an appropriate stock re-arrangement processing device 11 for re-arranging the stocks on the real time basis by adjusting the stocks based on the optimum demand prediction for the order reception sureness, and updating the order reception sureness as necessary via a communication medium such as the Internet, the appropriate stock re-arrangement processing device 11 stores the order reception information comprising the commodity delivery time, the order reception quantity and the order reception sureness one by one, calculates the lead time for procurement from the information on the relative number of days from the reference number of days for procurement pre-defined by the order reception sureness and the commodity delivery time, calculates the actual procurement by multiplying the procurement factor predefined based on the calculated lead time by the order reception quantity, and adjusts the stock arrangement based on the actual procurement.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a sales and distribution system for realizing the proper placement of commodity stocks throughout a physical distribution area, and a method for properly placing stocks in the system.

[0002]

2. Description of the Related Art Advances in production technology have made it difficult to differentiate products from competitors. Specifically, how to prevent shortages and comply with customer requirements for delivery is the biggest challenge to differentiate from competitors.At the same time, the burden of surplus inventory is putting pressure on management, Compression is urgently needed.

In a conventional production management system, actual stock is deducted on the site side from inquiry information reported from the sales side, and a predetermined replenishment amount is arranged when the inventory amount falls below a preset replenishment point. Was.

[0004]

In the above-mentioned conventional example,
It did not take into account expected orders and accuracy information, and arranged inventory only from inquiries, making it difficult to keep up with fluctuations in demand.
There is a drawback that shortage due to an increase in demand after inventory is arranged or surplus inventory is likely to occur due to decrease in demand after inventory is arranged.

SUMMARY OF THE INVENTION The present invention has been made in view of the above circumstances, and it is desirable to set the probability of receiving an order for a prospective order, arrange inventory based on a demand forecast that is optimal for the probability of receiving an order, and update the accuracy of the order as needed. The sales and distribution system and the inventory in the system that can suppress out-of-stock due to increase in demand after inventory arrangement or surplus inventory due to decrease in demand after inventory arrangement by rearranging inventory in real time It is an object of the present invention to provide a proper arrangement method. It is another object of the present invention to provide a sales distribution system in which actual demand in the market is reflected in demand forecast in real time and inventory management is performed through a common database in all departments, and a method for appropriately allocating inventory in the system.

[0006]

According to a first aspect of the present invention, there is provided a terminal device for setting an order accuracy of a prospective order item, and an inventory based on a demand forecast optimal for the order accuracy. And an appropriate stock relocation processor that relocates inventory in real time by updating the order accuracy as needed. With the above configuration, sales order distribution that can follow demand fluctuations by taking into account the order accuracy information that is updated one by one, and that prevents inventory shortage due to an increase in demand after inventory is arranged and surplus inventory due to a decrease in demand after inventory is arranged Can build a system.

According to a second aspect of the present invention, in the sales distribution system according to the first aspect, the appropriate stock relocation processing device receives an order receiving information including a product delivery date, an order quantity, and order accuracy from the terminal device. Information receiving means, procurement lead time calculation means for calculating the lead time of procurement from information on the standard procurement days defined by the order accuracy and relative days from the product delivery date, and pre-defined based on the calculated lead time Actual procurement amount calculation means for calculating the actual procurement amount by multiplying the obtained procurement coefficient by the order amount. With the above configuration, by arranging inventory based on the actual procurement amount calculated by the actual procurement amount calculation means, it is possible to arrange the inventory amount according to actual demand based on the accuracy of the order, preventing shortage and preventing excess inventory. Can be provided.

According to a third aspect of the present invention, in the sales distribution system according to the second aspect, the appropriate stock relocation processing device further includes a selling price necessary for securing a predetermined profit every time the order accuracy is updated. Sales price calculation means for calculating and setting and outputting a discount margin in real time is provided. According to the above configuration, a sales price for securing a predetermined profit can be calculated, and a timely discount margin can be displayed so that the profit can be secured. Therefore, it is possible to provide a sales distribution system that supports sales negotiations via a network.

The invention described in claim 4 is the first to third aspects of the present invention.
In the sales and distribution system described in (1), order information and the calculated actual procurement amount are stored in a database common to the system for each product, and the updated contents are sent to the inventory management, purchase management, sales management, inventory inventory through the database. management,
At least one system for lot management, physical quantity requirement management, and warehouse management is to be reflected in real time. With the above configuration, always check the actual demand in the market,
It is possible to construct a unified sales and distribution system using a common product database in all departments.

[0010] The invention according to claim 5 is used in a distribution and sales system, sets the order accuracy of a prospective order, arranges inventory based on the demand forecast that is optimal for the order accuracy, and updates the order accuracy as needed. By doing so, the stock was relocated in real time. As a result, it is possible to follow demand fluctuations by taking into account the order accuracy information that is updated one by one, and to prevent stockouts due to increased demand after inventory arrangements and surplus inventory due to reduced demand after inventory arrangements. it can.

According to a sixth aspect of the present invention, in the method for properly allocating inventory in the sales and distribution system according to the fifth aspect, every time the accuracy of an order is updated, a sales price required for securing a predetermined profit is calculated. It decided to output the discount margin in real time. As a result, a sales price for securing a predetermined profit can be calculated, and a timely discount margin can be displayed so that the profit can be secured. Therefore, support for business negotiations via a network can be realized.

According to a seventh aspect of the present invention, in the method for properly arranging inventory in the sales and distribution system according to the fifth aspect, the reallocation of inventory is performed by sequentially receiving order information including a delivery date and an order quantity and the order accuracy. Store and calculate the lead time of procurement from the reference procurement days defined in advance by the order accuracy and the relative days information from the product delivery date. Is multiplied to calculate the actual procurement amount, and inventory is arranged based on the actual procurement amount. Thus, by arranging the inventory based on the calculated actual procurement amount, it becomes possible to arrange the inventory amount according to the actual demand based on the probability of receiving the order, thereby realizing both prevention of shortage and surplus inventory. be able to.

[0013]

FIG. 1 is a diagram showing a connection configuration of a sales distribution system according to the present invention. The sales distribution system of the present invention uses the Internet 10 as a communication network.
Using an (intranet), a sales sub-management system such as an inventory management system 1, a purchase management system 2, a sales management system 3, an inventory management system 4, a lot management system 5, a physical quantity requirement management system 6, and a warehouse management system 7 is organic. Are combined.

8 is an EDI (Electronic Data Intercha).
nge), which is a communication protocol used in electronic commerce. Data is exchanged with an externally connected system (not shown) via the EDI 8. Reference numeral 9 denotes a file server, in which an order information database (D) is stored.
B) is constructed. Reference numeral 91 denotes an order information DB in which the order information such as the order quantity is updated and accumulated each time the order accuracy is changed, and 92 denotes an order information DB in which the order information such as the order quantity after the order is confirmed is accumulated. . In the following description, the latter will be referred to as the fixed information DB 92 for convenience and will be described separately. The order information DB 91 and the fixed information DB 92 are commonly used by the sales management subsystems 1 to 7.

FIG. 2 shows an order information DB 91 and a fixed information DB
FIG. 9 is a diagram showing an entry data format of a database constructed at 92. As shown in FIG.
Each of the entries making up the 92 includes fields for a report number, a date, a product code, a customer code, a delivery date, an order quantity, and an order accuracy. Order information DB91 and decision information DB92
Have a one-to-one correspondence by report number.

FIG. 3 is a block diagram showing the internal configuration of the sales management subsystem shown in FIG.
Here, in terms of hardware, a CPU (appropriate stock relocation processing device) 11 and a keyboard display device 1
2. It comprises a printing device 13. Internet 10
(Intranet) Order information DB 91 described above,
It is also connected to the decision information DB 92.

The proper stock relocation processing device 11 includes an order information receiving unit 111, an order accuracy update processing unit 112, a lead time calculation unit 113, an actual procurement amount calculation unit 114, a sales price calculation unit 115, a current time clock unit 116, Table memory 11
7, 118 and 119.

An order information receiving unit 111 receives order information reported from a sales person via the keyboard display device 12 or the Internet 10 (intranet) via a mobile device (not shown) with order accuracy information, and receives the information. Is stored in the order information DB 91. The order-accuracy update processing unit 112 receives an order-accuracy update request from the sales person at any time via the order information receiving unit 111, and reflects the request in the order information DB 91 and the fixed information DB 92 using the report number as a key.

The lead time calculation unit 113 stores a reference procurement period (table memory 1
18) and information on the number of days relative to the delivery date of the product (obtained by calculating between the current time obtained from the current time clocking unit 116) and the actual procurement amount calculation unit by calculating the procurement lead time. 114. The actual procurement amount calculation unit 114 obtains a procurement coefficient defined in advance based on the calculated lead time (contents of the table memory 119).
Is multiplied by the order quantity to calculate the actual procurement quantity and supplies it to the order accuracy update processing unit 112. Each time the order accuracy is updated, the sales price calculation unit 115 prepares a sales price (contents of the data table memory 117) prepared for each order accuracy.
Calculates the sales price necessary to secure a predetermined profit based on the calculated value, and sets and outputs a discount margin in real time. The above-mentioned procured amount and the selling price are output to the outside via the keyboard display device 12 or the printing device 13 and are disclosed to the concerned parties via a sales management subsystem via a network such as the Internet (intranet) 10. .

FIG. 4 and FIG. 5 are flowcharts cited for explaining the operation of the embodiment of the present invention. Hereinafter, the operation of the embodiment of the present invention shown in FIGS. 1 to 3 will be described in detail with reference to FIGS.

First, in FIG. 4, the salesperson makes a business report using the mobile device being carried or using the keyboard display device 12 of the terminal (step S41). As a result, the appropriate stock relocation processing device 11 checks whether the business report is a new case (step S42). If the business report is a new case, the report number, date, product code, customer code, Delivery date, order quantity,
Enter order information consisting of order accuracy. Then, the order accuracy is checked (step S43), and the order accuracy is 100
%, The order information is written into both the order information receiving unit 111, the order accuracy update processing unit 112, and the order information DB 91 and the fixed information DB via the file server (step S44). As a result of the order accuracy check (steps S45 and S47), the order accuracy is N
%, M% (where N> M), the order information is
It is written only in the order information receiving unit 111 and the order information DB 91 via the file server (step S46,
S48).

Here, the order acceptability indicates the degree of confirmation of the order information. For example, 100% of the order acceptability is the level at which the order is confirmed, the order acceptability M is the stage at which the negotiation of the order with the customer is started, the order acceptability, N refers to the level at which the customer has received an announcement of the order.

On the other hand, if it is not a new case, the order information DB 91 is updated including the change in the order quantity (step S4).
9). In this case, the past history is referred to using the report number as a key, and information that needs to be changed is rewritten. Then, the order accuracy is checked (step S50), and the order accuracy is 10
When it reaches 0%, the update information is written into the fixed information DB 92 and the processing shown in FIG.
If not, the process ends.

In FIG. 5, after input of order information for a new case (step S51) and input of order information by update (step S52), the lead time calculation unit 113 stores the order information in the table memory 118 in advance according to the order accuracy. The lead time of the procurement is calculated from the defined reference procurement days and the information on the relative number of days from the previously-entered product delivery date (step S53). The relative number of days information is calculated by subtracting the timer output from the current time counting unit 116 from the delivery date. Then, based on the lead time calculated here, the actual procurement amount calculation unit 114
Then, an actual procurement amount is calculated by indexing a pre-defined procurement coefficient in the table memory 119 and multiplying by the previously input order amount (step S54). The actual procured amount calculated here is the Internet (intranet) 10
It is broadcasted to each sales management subsystem via (step S55).

The sales management subsystems such as the inventory control system 4, the lot management system 5, the physical quantity requirement management system 6, and the warehouse management system 7, which have received the actual procured amount via the Internet 10 (intranet), Arrange inventory based on As described above, the sales management subsystem grasps the order accuracy of all prospective projects and controls sales forecasting in real time. If necessary, the selling price calculation unit 115 calculates a selling price for securing a predetermined profit rate,
Alternatively, a real-time display of a discount margin rate that can secure profits for a mobile device owned by a salesperson via the Internet (intranet) 10 is also performed. The selling price at this time differs depending on the order quantity, and the criterion for that is assumed to be stored in the table memory 117 in advance.

Each of the above-mentioned sales management subsystems has a warehouse supply / reception quantity such as inventory quantity, order quantity, order lead time, order interval, safety time, replenishment warehouse priority, replenishment days, etc. of all warehouses. It monitors item information, distribution configuration, the number of days required for delivery from the delivery source warehouse, early detection of dead stock (management in real time from entry and exit), etc., and manages inventory in units of locations. That is, the shelf position, storage condition, storage priority, inventory capacity, picking order, etc. for each item are instructed to store and retrieve the correct shelf position in an efficient procedure, and the cost is reduced under predetermined constraints (delivery date, site, etc.). Monitor the procurement costs in real time, choosing the transport method to minimize. And it can realize the optimal and inexpensive procurement cost, and also has the function of the performance analysis of early and late distribution and the function of feedback. By linking these functions organically via the Internet 10 (intranet), sales logistics information can be obtained in real time.
In addition, the centralized management enables an appropriate inventory arrangement to be determined at an appropriate timing.

[0027]

According to the first aspect of the present invention, the order accuracy information updated one by one is taken into consideration, so that it is possible to follow a fluctuation in demand, and a shortage or inventory is arranged due to an increase in demand after inventory is arranged. It is possible to provide a sales and distribution system that prevents surplus inventory due to a subsequent decrease in demand. According to the second aspect of the present invention, by arranging inventory based on the actual procurement amount calculated by the actual procurement amount calculation means, it becomes possible to arrange the inventory amount according to actual demand based on the order accuracy. In addition, it is possible to provide a sales distribution system that realizes both shortage prevention and surplus inventory prevention. According to the third aspect of the present invention, it is possible to calculate a selling price for securing a predetermined profit and display a timely discount margin for securing a profit, thereby supporting business negotiations via a network. A sales distribution system can be provided. According to the invention described in claim 4, it is possible to constantly check the actual demand in the market, and to construct a sales and distribution system unified by a common product database in all departments.

According to the fifth aspect of the present invention, since the updated order accuracy information is taken into consideration, it is possible to follow the fluctuation of demand, and it is possible to follow the increase in the demand amount after arranging the inventory and to reduce the demand after the inventory is arranged. Excess inventory due to a decrease in demand can be prevented. According to the invention as set forth in claim 6, it is possible to calculate a selling price for securing a predetermined profit and display a timely discount margin that can secure a profit, so that it is possible to realize support for business negotiations via a network. . According to the seventh aspect of the present invention, by arranging inventory based on the calculated actual procurement amount, it becomes possible to arrange the inventory amount according to actual demand based on the accuracy of the order, and the surplus inventory can be prevented. Both prevention can be realized.

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a connection configuration of a sales distribution system according to the present invention.

FIG. 2 is a diagram showing an entry format of an order information database in FIG. 1;

FIG. 3 is a diagram illustrating an example of a system configuration of a sales management subsystem in FIG. 1;

FIG. 4 is a flowchart showing an operation procedure of a method of properly allocating inventory in the sales distribution system of the present invention.

FIG. 5 is a flowchart showing a continuation of the operation procedure shown in FIG. 4;

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Inventory management system, 2 ... Purchasing management system, 3 ... Sales management system, 4 ... Inventory management system, 5 ... Lot management system, 6 ... Physical quantity requirement management system, 7 ... Warehouse management system, 8 ... EDI, 9 ... File server, 1
0: Internet (intranet), 11: Appropriate stock placement processing device (CPU), 12: Keyboard display device (KB / CRT), 13: Printing device (PR
T), 91 ... Order information DB, 92 ... Fixed information DB, 11
1. Order information receiving unit 112: Order accuracy update processing unit 1
13: lead time calculation unit, 114: actual procurement amount calculation unit
115: Sales price calculation unit, 116: Current time clock unit, 1
17: Sales price table memory, 118: Reference days table memory, 119: Procurement coefficient table memory

Claims (7)

[Claims] 1. A terminal device for setting the order accuracy of a prospective order case, arranging inventory based on a demand forecast optimal for the order accuracy, and updating the order accuracy at any time to renew the inventory in real time. A sales distribution system in which a proper stock relocation processing device to be arranged is connected via a communication medium. 2. The order-replacement processing device according to claim 1, further comprising: an order-information receiving unit configured to receive order information including a product delivery date, an order quantity, and the order accuracy from the terminal device; and a standard procurement defined in advance by the order accuracy. A procurement lead time calculating means for calculating a procurement lead time from information on the number of days and the relative number of days from the product delivery date; and multiplying the order quantity by a procurement coefficient defined in advance based on the calculated lead time. 2. The sales and distribution system according to claim 1, further comprising an actual procurement amount calculation unit for calculating the procurement amount. 3. The proper stock relocation processing device further includes:
3. The sales distribution system according to claim 2, further comprising a sales price calculation means for calculating a sales price required for securing a predetermined profit and updating and setting a discount margin in real time each time the order accuracy is updated. system. 4. The order receiving information and the calculated actual procurement amount are stored in a database common to a system for each product,
The updated content is sent to the relevant database for inventory management,
4. The sales distribution system according to claim 1, wherein at least one system for purchase management, sales management, inventory control, lot management, physical quantity requirement management, and warehouse management is reflected in real time. 5. Used in a distribution / sales system, the order accuracy is set for a prospective order item, inventory is arranged based on a demand forecast that is optimal for the order accuracy, and the order accuracy is updated as needed. And a method for appropriately allocating inventory in a sales and distribution system, wherein reallocation of inventory is performed in real time. 6. The sales distribution system according to claim 5, wherein each time the order accuracy is updated, a sales price necessary for securing a predetermined profit is calculated, and a discount margin is set and output in real time. How to place inventory properly. 7. The reallocation of the stock is performed by sequentially storing order information including a product delivery date, an order quantity, and the order accuracy, and a reference procurement number of days defined in advance by the order accuracy and a relative time from the product delivery date. Calculate the lead time of procurement from the number of days information, calculate the actual procurement amount by multiplying the pre-defined procurement coefficient by the order quantity based on the calculated lead time, and arrange inventory based on the actual procurement amount 6. The method for properly allocating inventory in the sales and distribution system according to claim 5, wherein: