JPH07200683A - Production and sales management system - Google Patents

Abstract

PURPOSE:To provide a production and sales management system capable of more efficiently executing a processing especially by improving a technique for adjusting the total amount of production instruction information to a schedulable amount and allocating it to machines so as to improve the defect of a conventional technique. CONSTITUTION:This system is provided with a production instruction amount calculation means 4 for calculating production instruction amounts for respective ordering departments and respective varieties and the production instruction amount only for the respective varieties, a stock redistribution means 5 for adjusting the excess and shortage of stocks for the respective ordering departments corresponding to sales schedules by transferring the stock and warehousing schedule of the specified ordering department to the specified ordering department so as to make the total amount of the production instruction amounts for the respective ordering departments and for the respective varieties for the same variety coincide with the production instruction amount for the respective varieties and prevent futile production, an automatic allocation means 6 for executing instruction amount for the respective varieties and the ability information of the machines and automatically performing machine allocation and an interactive allocation means 7 for adjusting allocation information displayed on a screen by an interactive system by an operator.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a production / sales management system for managing production and sales of various articles.

[0002]

2. Description of the Related Art Conventionally, in each industry or individual company, when carrying out a normal corporate activity of manufacturing a unique product and selling the manufactured product, generally, a sales and sales department is in charge. , The extent to which a given product produced by the company can be sold or must be sold in a given period, such as a short-term, medium-term, or long-term period. The sales target and the appropriate inventory quantity that should be secured at all times are determined, and the result is used as sales plan information and the production department of the company is notified.

On the other hand, the production department which has received the information makes a production plan of the article on a daily, weekly, monthly, seasonal or yearly basis based on the sales plan information, that is, a daily plan. Short-term, medium-term, corresponding to sales plan, such as weekly plan, monthly plan, seasonal plan, or annual plan.
A long-term production plan will be drawn up and put into practice.

At that time, the sales department has a plurality of departments, and each department independently sells the same product and the same product type, and the essential parts of the product are almost the same. For example, each department produces products with some differences in shape, color, or accessories.
If they are sold individually, there is a risk that the sales plan will be complicated and the contents will not be unified.

On the other hand, the production department is often unfamiliar with the situation of the sales department, and therefore, it is almost the case that the production plan of the product concerned is made up entirely depending on the sales plan which has been contacted. Is. Therefore, for example, when a production factory has a plurality of production lines, or when factories manufacturing the same or similar products are dispersed in different regions, the same production type or alternative production can be used. Inefficient and inefficient operation of producing products of the same variety in different factories while it is more efficient to produce different types of products or to produce them in the same production plant. There were many dangers of going there.

[0006] Furthermore, since the communication between the sales department and the production department is insufficient, for example, if the inventory information is not accurately included in the sales plan, a plurality of sales of the same product are sold. There are departments, and in one department,
If a request is made to the production department to increase the production of the product due to the fact that the product is out of stock in a short period of time, the sales performance will not increase in another department and therefore the inventory will be planned. When the number exceeds the number, it is possible that the excess inventory is accommodated to the department in which the inventory is exhausted, thereby eliminating the need for extra production. However, if such information is not disclosed to a third party, extra production will be carried out, and eventually inventory will be overstocked, leading to an increase in selling costs.

[0007] In general, such a sales plan is made, and based on the sales plan, which production variety, at what time, including the allowance for raw materials, and at what factory and in what amount, what amount? It is extremely important to judge whether or not to manufacture, that is, to determine the optimum condition, that is, whether the manufacturing can be performed under the conditions of being efficient and minimizing the manufacturing cost. However, since it requires a lot of experience and judgment, not everyone can easily and quickly determine such sales and production plans. Therefore,
There is a problem that it takes time because it takes a considerable amount of time for a skilled person to create it.

In order to solve such a problem, in recent years, a computer has been introduced, and the work of the above-mentioned part requiring the knowledge of the expert has been put into practical use in the direction of mechanization and automation, but it is still complete. A complete production and sales management system has not been completed, and a considerable part, that is, a working part that requires the judgment and experience of a skilled person, is still in the existing state.

[0009]

SUMMARY OF THE INVENTION An object of the present invention is to improve the above-mentioned drawbacks of the prior art, in particular, to improve the technique of allocating production instruction information to a machine by adjusting the total amount of production instruction information to a schedulable amount, It is to provide a production and sales management system that enables more efficient processing.

[0010]

The present invention employs the following technical configurations in order to achieve the above objects. That is, the production and sales management system according to the present invention includes a production instruction information creating unit that creates production instruction information by predetermined arithmetic processing based on sales plan information, ordering information, and inventory information, and the production instruction information. Machine allocation means for allocating a production instruction to each machine by a predetermined calculation process based on at least separately prepared production constraint condition information including production capacity (throughput) for each machine / product type, and a machine allocation means from the machine allocation means. In a production and sales management system that includes a scheduling unit that schedules each machine by a predetermined calculation process based on the output information, and creates a desired production plan, the machine allocating unit sets a predetermined unit based on the production instruction information. Ignoring each machine's production capacity, The production instruction amount calculation means for calculating the production instruction amount of only the type and the total amount of the ordering section section / product type production instruction amount for the same product type are matched with the product type production command amount to prevent wasteful production. Therefore, the inventory redistribution means for adjusting the inventory excess and deficiency by the ordering section section according to the sales plan by transferring the inventory and the warehousing schedule of the specific ordering section section to the specific ordering section section, and the production instruction amount for each product type and the machine Automatic allocation means for automatically performing machine allocation by executing efficiency arithmetic processing from capacity information, and a predetermined display pattern by predetermined arithmetic processing based on output information from the automatic allocation means, and the result Is displayed on the screen, and interactive allocation means for the operator to adjust the allocation information displayed on the screen in an interactive manner is provided. It is a production and sales management system that.

[0011]

In the production and sales management system according to the present invention, the production instruction quantity calculation means and the stock redistribution means
In other words, inventory adjustment, which can be called "unevenness adjustment", can be made, and unnecessary production instructions can be suppressed.
Further, the automatic allocating means performs arithmetic processing on which machine is most efficient for producing each product type. Furthermore, the dialogue allocating means allows further adjustment by the expert.

[0012]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A specific example of the production and sales management system according to the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a functional block diagram showing the basic configuration of the production and sales management system according to the present invention. In this figure, the production instruction information creating means 1 is means for producing the production instruction information by a predetermined calculation process based on the sales plan information, the ordering information, and the inventory information. The machine allocating means 2 has at least the production capacity (throughput) for each machine / product type prepared separately from the production instruction information.
It is a means for allocating a production instruction to each machine by a predetermined calculation process based on the production constraint condition information including. The scheduling means 3 is means for scheduling each machine by a predetermined arithmetic processing based on the output information from the machine allocation means 2.

Further, the production instruction amount calculation means 4 ignores the production capacity of each of the predetermined machines based on the production instruction information, and produces only the production instruction amount by ordering section / product type and product type. It is a means for calculating the indicated amount. The stock redistribution means 5 makes the total quantity of the same order of the production order quantity according to the ordering section section / product type coincide with the production instruction quantity according to the product type to prevent the wasteful production, and the stocking and receipt of goods in the specific ordering section section. It is a means for adjusting the inventory excess or deficiency by ordering department according to the sales plan by transferring the schedule to a specific ordering department. The automatic allocating means 6 is a means for automatically allocating machines by executing an efficient calculation process based on the production instruction amount for each product type and machine capability information. The interactive allocating means 7 forms a predetermined pattern by a predetermined arithmetic processing based on the output information from the automatic allocating means 6, displays the result on the screen, and interactively processes the allocation information displayed on the screen. Is a means for the operator to make adjustments.

FIG. 2 is a block diagram showing a hardware configuration of a production and sales management system according to an embodiment of the present invention. In this figure, reference numeral 11 is a CPU, reference numeral 12 is a main storage device, reference numeral 13 is an input device, reference numeral 14 is an output device,
Reference numeral 15 indicates an external storage device, and reference numeral 16 indicates a display device. Then, in such a hardware environment, each means in the above basic configuration is realized by running software as described below.

FIG. 3 is a block diagram showing a software configuration of the production and sales management system. As for the relationship between each means in the basic configuration and each subsystem in this figure, the production instruction information creating means 1 is the sales / production cooperation system 23, and the machine allocating means 2 is the total quantity adjusting system 2.
4. The scheduling means 3 corresponds to the advanced platforming system 25. Then, the processing procedure of the system is roughly as follows. First, the sales person in charge of sales planning system 21
The sales plan is entered in. Required data of the ordering information and the inventory information stored in the external storage device 15 is the sales system 22.
Extracted by. The production / instruction information is calculated by the sales / production cooperation system 23 based on the above information and. The production instruction amount is adjusted to the producible amount by the total amount adjustment system 24, and the distribution machine is determined. In the advanced distribution system 25, the total amount adjustment system 24
Based on the results of "computer placement using artificial intelligence"
And the "dialogue placement by expert" determines the placement plan. Based on the distribution plan created by the advanced distribution system 25, the procurement plan for the materials and raw materials necessary for production, and the specific production work order plan, the work order material procurement system 2
Created by 6. Further, the distribution plan created by the advanced distribution system 25 is returned to the external storage device 15 as receipt information via the production progress grasping system 27. In this embodiment, by constructing the system as described above, a closed loop of input / output inventory information is formed between production and sales, and direct connection between sales information and production information is realized.

Next, the processing of the machine allocating means 2, that is, the total amount adjusting system 24, which is a feature of the present invention, will be described in detail. The production instruction data created by the sales and production cooperation system 23 is determined by the sales plan entered by the sales person and the position (stock inventory) at that time. Here, since the systematic upper limit is not set for the planned sales amount, the production instruction data may have a value of “blue ceiling” that exceeds the capacity of the units in the factory. The total quantity adjustment system 24 keeps the production instruction quantity within the mountable quantity by rationally assigning machines according to the following procedure. The procedure will be described below with reference to the flowchart of FIG.

When a plurality of departments handle the same product,
Transfer a position from a department with excess positions to a department with insufficient positions. By this transfer, departments with insufficient positions can increase their positions and omit useless orders. Specifically, first of all,
Apart from the production instruction amount for each product type, the production instruction amount for each product type is calculated (step 102). Next, the inventory and the warehousing-scheduled varieties calculated therefrom are automatically transferred, that is, the inventory is reallocated (step 104).

A specific example of such "unevenness adjustment" will be described. When the same product type is handled by multiple departments, the production instruction amount is calculated for each department. The formula for calculating the production instruction amount is as follows. Production instruction amount = Sales plan amount + Month end inventory plan amount-Month initial inventory amount Apply the following coefficient to the above formula to calculate the production instruction amount for each department. Department name Sales plan amount Monthly inventory plan amount Monthly inventory amount A 100 50 30 B 60 10 80 (a) Production instruction amount of division name A 120 = 100 + 50-30 (b) Production instruction amount of division name B −10 = 60 + 10-80 (c) Total production instruction quantity by product type 110 = 160 + 60-110 Since the production instruction quantity of B is a negative value,
It is not necessary for B to instruct production, and the data numbers are as follows. Department name Monthly beginning inventory Production instruction quantity Sales plan Month end planned inventory quantity A 30 120 100 50 B 80 0 60 20 However, the total production instruction quantity by product type is 110. In this case, if B's inventory (monthly initial inventory amount) is transferred to A's monthly initial inventory amount by 10, the production instruction amount of A will be 120 to 110, and wasteful production can be prevented. . Following inventory adjustment, the data will be as follows. Department / Department Name Monthly Inventory Production Instructed Quantity Sales Plan Monthly Scheduled Inventory Quantity A 40 110 100 50 B 70 0 60 10

After such "concavo-convex adjustment" is completed, the machines are automatically allocated (step 106). That is, which machine is most efficient for producing each product is calculated by using the linear programming (LP), and the machine allocation corresponding to the capability is performed. This LP calculation is
For example, if A: production amount B: unit production capacity C: score D: number of days that can be produced E: production instruction amount i: product type j: machine, then "the number of production days of each machine is less than or equal to the number of days that can be produced by that machine" ”, And the constraint condition that“ the production amount of each variety is less than or equal to the production instruction amount ”,

[0021]

[Equation 1] Under, the objective function of "allocating machines so that the varieties to be distributed have scores in advance according to the affinity with the machine, and allocate the machines so that the score x the maximum production amount"

[0022]

[Equation 2] Is provided and executed.

After the automatic allocation using the LP calculation, the expert finally executes the allocation correction process by the interactive method (step 10).
8).

Further, the total amount adjustment system 24 in the present embodiment further includes an outsourced transferable type master in which the combination information of the production instructed type and the outsourced transferable type is stored in advance, and is output from the automatic allocation means. Outsourced transfer plan determining means for determining the outsourced transfer type and its quantity by arithmetic processing from the available production amount information for each machine type, information on the outsourced transferable type master, and predetermined outsourcing ordering conditions, and The subcontracting transfer type identifier assigning unit assigns an identifier to the type of the subcontracted transfer in the sales plan information in order to clearly indicate to the sales person the status of the subcontracting transfer determined by the subcontracting transfer plan determining unit.

That is, among the instructed production types, there are various types which can be produced by the in-house factory or the subcontractor. There is a case where the product type is changed to a product type to be produced, that is, an outsourced input type product when the capacity of the allocating machine of the own factory becomes insufficient. Book total adjustment system 24
Among them, the production instructed products are automatically converted into raw materials for outsourcing, securing the production amount on the factory side and "cutting out" on the sales side.
It is useful for prevention.

Although the basic concept of one embodiment of the present invention has been described above, it is easy for those skilled in the art to realize an actual system, that is, a program from this description. Of course, the present invention is not limited to this embodiment, and it will be easy for those skilled in the art to devise various embodiments.

[0027]

As described above, according to the present invention,
In order to improve the above-mentioned drawbacks of the conventional technology, in particular, a production and sales management system that improves the technology of allocating production instruction information to machines by adjusting the total amount of scheduling information to a schedulable amount and enabling more efficient processing execution Will be provided.

[Brief description of drawings]

FIG. 1 is a functional block diagram showing a basic configuration of a production and sales management system according to the present invention.

FIG. 2 is a block diagram showing a hardware configuration of a production and sales management system according to an embodiment of the present invention.

FIG. 3 is a block diagram showing a software configuration of a production and sales management system according to an embodiment of the present invention.

FIG. 4 is a flowchart showing a machine allocation procedure of the production and sales management system according to the embodiment of the present invention.

[Explanation of symbols]

 1 ... Production instruction information creating means 2 ... Machine allocating means 3 ... Scheduling means 4 ... Production instruction amount calculating means 5 ... Stock reallocating means 6 ... Automatic allocating means 7 ... Interactive allocating means 11 ... CPU 12 ... Main storage device 13 ... Input Device 14 ... Output device 15 ... External storage device 16 ... Display device 21 ... Sales planning system 22 ... Sales system 23 ... Sales / production cooperation system 24 ... Total quantity adjustment system 25 ... Advanced distribution system 26 ... Work instruction Material / material procurement system 27 … Production progress monitoring system

Claims (3)

[Claims] 1. A production instruction information creating means (1) for producing production instruction information by predetermined arithmetic processing based on sales plan information, ordering information, and inventory information, and the production instruction information prepared separately. A machine allocating means (2) for allocating a production instruction to each machine by a predetermined calculation process based on the production constraint condition information including at least the production capacity (throughput) for each machine / product type, and the machine allocating means (2) In a production and sales management system for creating a desired production plan, which comprises a scheduling means (3) for scheduling each machine by a predetermined arithmetic processing based on output information from the machine allocation means (2), Based on the production instruction information, disregarding the production capacity of a given machine, the production instruction quantity and product by ordering section and product type The production instruction amount calculation means (4) for calculating only the production instruction amount for each different type and the total amount of the production instruction amount for each ordering section / product type for the same product type are matched with the production instruction amount for each product type, which is wasteful. Inventory redistribution means (5) for adjusting inventory excess and deficiency by ordering section section according to a sales plan by transferring inventory and warehousing schedule of a particular ordering section section to a specific ordering section section in order to prevent production; Automatic allocation means (6) for automatically performing machine allocation by executing efficient calculation processing from the production instruction amount and machine capability information, and predetermined calculation based on output information from the automatic allocation means (6) A dialog allocating means (7) for arranging a predetermined display pattern by processing and displaying the result on a screen and for the operator to adjust the allocation information displayed on the screen by an interactive method. ), And a production and sales management system. 2. The machine allocating means (2) includes a subcontractable transferable type master in which combination information of a production instruction type and an outsourced transferable type is stored in advance, and each machine output means outputs the automatic allocation means. Outsourcing transfer plan determining means for determining the outsourced transfer type and its quantity by arithmetic processing based on the machine type producible amount information, the information of the outsourced transferable type master, and predetermined outsourcing order conditions. The production and sales management system according to claim 1. 3. The machine allocating means (2) is an identifier for a type of product subcontracted in the sales plan information in order to clearly indicate to a salesperson the status of the subcontracting transfer determined by the subcontracting transfer plan determining means. The production / sales management system according to claim 2, further comprising: an outsourced transfer type identifier assigning means for assigning.