JP2003044550A - System, method and program for management for manufacture and sale - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system for management for manufacture and sale capable of transmitting quickly information on receiving orders for each item to increase transparency of the information, of avoiding overlapped operations, of responding within a short time period, for example within 24 hours, from the receiving orders to responses of deliveriesand with flexibility, and also of acquiring information on shipping from a factory automatically for sales operations and of outputting shipping instructions automatically for firm orders. SOLUTION: Each system of sales departments has a master database to automatically transfer information on receiving orders ranked on forecast receiving orders, informally noticed orders and firm orders by item, information on orders of inputting and information on sales stocks to a system for production control of the factory during the night. The factory calculates automatically a production plan to transfer responses of shipments from the factory to systems of sales departments. The systems of sales departments assign automatically deliveries to each information on receiving orders to transmit the responses of deliveries to customers, and furthermore, output the shipping instructions for the firm orders to which are in the sales stocks.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a manufacturing and sales management system, and more specifically, it transmits the collected order information to a factory, and further calculates a required quantity for calculating the number of new inputs from order information and inventory information. We can flexibly respond to production plans and delivery deadlines within a predetermined time (for example, within 24 hours of receiving an order), and the shipping information of the factory is automatically purchased for sales. The present invention relates to a manufacturing and sales management system that gives instructions.

[0002]

2. Description of the Related Art FIG. 2 shows a conventional manufacturing and sales management system. As shown in the figure, conventionally, the sales person 202 transmits the order information from the customer 201 to the business person (ordering person) 203 who is in charge of ordering to the factory 206, and the business person (ordering person) 2
03 is in charge of production management of the factory from the stock situation and empirical rule 20
Order 4 The production management person in charge of the factory 204 is in charge of the task (answer) in charge of answering the delivery date by calculating the required amount in consideration of the factory inventory such as work-in-progress along with the information and making a production plan.
5 was answered as the factory delivery date, and the delivery date was answered to the customer via the sales staff 202. And the shipment of the product is the shipment information from the factory (the arrival information to the sales such as the quantity of the product)
The person in charge of shipping (shipping) checked the items and issued a shipping instruction to the confirmed order.

Further, the order information is a monthly cycle system in which the order information is aggregated on a monthly basis, orders are placed to factories, production plans are made, and delivery dates are answered.
Each piece of information is an offline system that processes data by using an electronic medium every predetermined period.

On the other hand, each factory has a business flow and system suitable for manufacturing each product, from ordering to factory arrangement. Inside each factory and sales department, independent databases and systems are provided. It was operating.

The management system of each business unit (sales department) and the accounting system of the head office are separate systems, and are operated offline.

[0006]

However, the above-mentioned system has the following drawbacks. That is, the sales representative,
In order to go through multiple operations (ordering / answers, etc.) and production management, etc., each person processes the order information with margins such as quantity, number of days, and delivery date, and makes a production plan from the initial order information. It takes time and effort to be
There was a problem that the order information was lacking in accuracy, certainty, and transparency.

Further, since each database is operated by an independent database and system, the transmission and correction of information by a person is performed due to the difference in the definition, meaning, data length, etc. of the database of each factory and the system of the sales department. , Supplementary information is required, such as differences in order information, production plans, and inventory information, and mistakes in the meaning of data between the factory side and sales side, impair the accuracy and certainty of information, and improve the speed of information transmission. It had a problem of lack.

[0008] Each factory has a business flow and system from the order received to the factory arrangement for manufacturing each product, and therefore each factory and sales department operate their own independent database and system. Was. In other words, since each factory and sales department have multiple different systems, they are directly connected to each other by a network and the order information of the sales department is directly transmitted to the factory system, and the production plan, factory delivery date and customer delivery date are answered. There is a problem that a manufacturing and sales management system cannot be easily constructed, and a large amount of expenses and human resources are required in terms of operation, management and maintenance support.

For this reason, order information is collected on a monthly basis, orders are sent to the factory, and the delivery date is answered after the production plan is completed. There was a problem that the plan could not be easily and promptly reassembled, and the plan could not be corrected unless waiting for the next month to collect the order information.

Further, when the person in charge of business (answer) is absent, the delivery date reply is not timely sent to the customer even if the delivery date reply is received from the factory. Alternatively, a margin more than necessary (for example, 3 to 5 days) is taken in response to the factory delivery date reply. Alternatively, there was a problem of replying a quantity that exceeds the number of factory deliveries.

[0011] Then, regarding the shipping of the product, the business (shipping) person in charge of the shipping checks the shipping information from the factory (information about the arrival of the product such as the quantity of the product to the sales), and issues a shipping instruction to the confirmed order. Therefore, if the product is shipped early from the factory but you do not notice it, or if there is no business (shipping) person in charge, the check will be delayed and the shipping instruction will be delayed, or even if there is no confirmed order, the shipping instruction will be erroneously made. Had the problem of being able to produce

The present invention has been made in view of the above-mentioned problems, and accurately and swiftly transmits order information, enhances information transparency, eliminates duplicate work, and takes a short time from order receipt to delivery date reply. The purpose is to provide a manufacturing and sales management system that can respond flexibly within 24 hours), automatically purchase the shipping information of the factory, and automatically issue shipping instructions for fixed orders. And

[0013]

[Means for Solving the Problems] In order to achieve the above object, a manufacturing and sales management system according to the present invention provides a means for inputting order information by adding rank information to each item and an order serial number for the order information. A serial number giving means for giving, a storage means for storing the order information and the order serial number, an inventory management means for managing inventory information of each item, a manufacturer of the order information, the order serial number and the inventory information. Means for transmitting to the system on the side, the order calculation information, the stock information, the required quantity calculation means for calculating the number of new inputs from the computer from the stock information on the manufacturer side, the production planning means for creating the production plan, and the production plan The manufacturer's delivery date reply means for responding to the manufacturer's shipment information such as the finished quantity and finish date of each item, and the means for transmitting the manufacturer's delivery date reply to the system of the order information sender From the inventory information and forming side Promise, orders destination Hikiateru delivery date reply means the finish quantity of each item in the order sequence number according to a predetermined method, billing,
It is characterized by comprising master database means in which master codes such as payer, salesperson (employee), and item are standardized.

The rank information includes forecast orders,
It can be changed from forecast order to unofficial order, from forecast order to confirmed order, or from unofficial order to confirmed order, depending on the order accuracy. Is characterized by.

The order information, the order serial number, and the inventory information are transmitted to a system of a factory (manufacturer side) every predetermined time.

[0016] The manufacturer's delivery date reply (factory delivery date reply) is transmitted to the system on the order information sender side (sales management) every predetermined time.

The predetermined method is a delivery date reply means for allocating the finished quantity of each item in the order of the order number.

[0018]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a schematic diagram of a data flow of a manufacturing and sales management system showing an embodiment of the present invention. FIG. 3 is a detailed diagram of the data flow of the manufacturing and sales management system showing an embodiment of the present invention. The data flow of FIGS. 1 and 3 will be described below.

(1) The sales person provides order information 101 such as item, quantity, delivery date, forecast order 102, unofficial order 1
03, fixed order 104, divided into three ranks, sales department sales management system 106 SD (Sales a
nd Distribution: Sales Management Module
Input) 105. When inputting, a serial number automatically assigned by the system is added and the sales management system 1 together with order information.
It is stored in the database of 06.

(2) Next, the automatically assigned serial number, order information 101, and business inventory (business inventory information) 108 are provided to the production management system 110 of the factory 109 that manufactures the corresponding item every day for a predetermined time (eg, Automatic transfer to 20:00).

(3) In the factory 109, the production management system 110 of the factory uses the MRP (Material) based on the information.
(1) Requirements Planning) 120 is executed, and the required number of new inputs for each item is calculated from the order information 101, the sales inventory 108, and the manufacturing inventory (factory inventory information) 111 such as the fact that the factory is in process.

(4) Automatically create a production plan 112 from the MRP 120 up to a predetermined period (for example, at least 3 months ahead) (5) Automatically produce a factory delivery date reply 114 such as the quantity of each item and a planned shipping date from the production plan 112. create.

(6) Then, the factory delivery date reply 114 is automatically transferred to the sales management system 106 of the sales department (for example, 3:00 at the same night).

(7) In the sales management system 106 of the sales department that receives the factory delivery date reply 114, the MM (Material)
al Management: inventory / purchasing management module
(1) 115 as a purchase order backlog and stored in the database.

(8) Factory delivery date reply 114 and operating inventory 10
8 based on ATP (Available To Prom)
ise: Automatic delivery date reply module or Resch
116), and the factory delivery date reply 1
There is a certain logic for 14 (for example, business inventory and receipt schedule,
In other words, the factory delivery date answers are drawn in ascending order of order information, the forecast order is input, etc.) and the delivery date answer 117 is automatically created for each order.

Up to this point, that is, from the input of the order information 101 to the delivery date reply 117 within a predetermined period (for example, from 20:00 the day before the order information is automatically transferred to the production management system 110 of each factory to 9:00 the next day). Order), and the sales order management system 106 of the sales department receives order information 1
If 01 is registered, the delivery date according to the production plan 112 of each factory 109 is automatically shown in the morning of the next day, and the customer can be answered.

Therefore, in each factory 109, a production plan for a predetermined period ahead (for example, at least 3 months ahead) is automatically made every day. For example, in the case where the factory 109 is a semiconductor factory, a production plan in the previous process, a production plan in which a tooling plan such as an inspection device in the semiconductor inspection process is distributed to vacant devices, and an external factory such as a machining process is used. A production plan 112 for a predetermined period ahead (for example, at least 3 months ahead) is automatically established every day for all the payout production plans and the like.

The above items (2) to (8) are automatically processed every predetermined period (for example, every day) until the backlog is exhausted.
Since sales orders are changed daily such as additions and deletions, order information 101 is added, changed, deleted, etc. each time.

(9) When the product is finished in the factory 109, the factory ships the product to the sales department. Factory shipping information is automatically imported as sales purchase from the factory production management system 110 to the sales management system 106 of the sales department, stored in the database, and the sales inventory 108 is updated.

(10) The sales management system 106 automatically issues a shipping instruction for an item that has a commercial inventory and is a confirmed order. Here, the factory shipment (factory shipment 11
8) = The business inventory 108 is updated (almost in real time) at the business receipt 119 at any time, and a shipping instruction is automatically arranged in the business shipping department at night based on the number of business inventory actually received.

(11) The person in charge of the sales and shipping department of each warehouse packages the product based on the shipping instruction arrangement and ships the product.

(12) Various accounting data generated as a result of purchasing and shipping products (accounts receivable, accounts payable, inventory et
c ...) transfers to the headquarters server that night.

The production control system 110 of the factory 109
The transmission of data between the sales management system 106 of the sales department and the sales management system 106 of the sales department is executed by the network via the distribution server 408.

Here, the order of three levels of the order information 101 is from forecast order 102 to unspecified order 103.
The forecast order 102 can be changed to the confirmed order 104, and the unofficial order 103 can be changed to the confirmed order 104 according to the order accuracy. The forecast order is the order forecast expected by the sales department, the fixed order is the order that has received the order form, and the unofficial order is information other than the forecast order or the fixed order.

As described above, the order information of any rank is as follows.
Since the MRP 120 is executed by the production management system 110 of the factory and the production plan 112 is created, the capacity calculation of the factory can be executed. As a result, the factory delivery date reply 114 to the sales department.
You can

However, the production management system 110 makes automatic manufacturing arrangements only for items based on the order information 101 of the unofficial order 103 and the confirmed order 104. In addition, the manufacturing and sales management system of the present invention includes an MRP 120, a production plan 112,
Each of the ATPs 116 (manufacturing) can be executed based on a certain rule, that is, a rank desired delivery date input order (automatic serial number order) of order information, and a priority order such as a priority order for each order.

Next, with reference to FIG. 4, an example of the configuration of the hardware which is the basic system of the manufacturing and sales management system will be described.

FIG. 4 shows a client server type system configuration in which each server is connected by a network. Each function is distributed to a plurality of servers to be distributed to a client (for example, a user). It is a manufacturing and sales management system in which each server processes an instruction from a personal computer.

A business headquarters server 401 for processing the sales management of the business headquarters, and a data warehouse server 402 (data warehouse; DW) for the information management system of the sales department.
H is an information warehouse. A print server 403 that controls forms such as shipping instructions and delivery notes, and is a database of information for strategic or hypothesis verification. Headquarters server 40 that manages accounts receivable and accounts payable data of business headquarters
4. Production control server 4 with production control function for each factory
05, 406, 407 respectively, production control servers 405, 406, 407 and business headquarters servers of each factory.
It is composed of a collection / delivery server 408 which controls exchange of data between 401.

In order to exchange data between each factory and each business entity and the head office online via the network,
It has a master database as a base (for example, each master database in which master codes such as an order receiving party, a billing party, a payer, a sales employee (employee), and an item are standardized).

Next, a schematic flow chart of the manufacturing and sales management system showing an embodiment of the present invention from order receipt to delivery date reply will be described with reference to FIG.

Step 501 for ranking and inputting order information such as items and step 50 for automatically giving serial numbers
2, step 503 of storing order information and automatic serial number
A step 504 of transmitting the sales inventory and order information to the production management system of the factory at a predetermined time, a step 505 of executing the MRP, and a step 50 of creating a production plan.
6, step 507 of creating a factory delivery date, step 508 of transmitting the factory delivery date to the system of the sales department, A
Step 509 of executing TP, step 510 of answering the delivery date, and step 511 of checking the order backlog, and transmitting the business inventory and order information to the production management system of the factory at a predetermined time until the order backlog is exhausted. It is shown from step 504 that the flow is to repeatedly execute step 511 for checking the order backlog.

Next, a schematic flow chart of the manufacturing / sales management system of FIG. 8 from the factory shipment to the customer shipment will be described.

Step 801 of shipping from the factory, step 802 of storing it into a commercial inventory, step 803 of checking from the order information whether it is a definite order or a business inventory, and a definite order has a business inventory. In this case, step 804 of issuing a shipping instruction and step 8 of packing and sending
It is shown that the flow consists of 05.

Next, an example of input items of order information of the manufacturing and sales management system showing one embodiment of the present invention and an example of an input screen of the manufacturing and sales management system showing one embodiment of the present invention will be described. .

Items marked with a circle, such as the customer 601, designated shipping date 602 (customer desired delivery date = sales department desired shipping date), order quantity 603, detailed order 604, etc., are input items including required and optional items. (Including selection from combo box).
The detailed order 604 includes forecast orders 102, unofficial orders 103, and confirmed orders 104 as ranks of the order information 101.
Is entered by selecting from the combo box.

It is a non-input item because it is automatically referenced from the master database marked with X.

[0049]

As described above, according to the present invention, order information can be accurately and promptly transmitted, information transparency can be improved, duplication of work can be eliminated, and orders can be dealt with in a short time (for example, within 24 hours). It is a manufacturing and sales management system that can respond quickly and flexibly even if many changes are made to order information due to market fluctuations, etc. Moreover, factory shipping information is automatically purchased from sales, and fixed orders are accepted. Can provide a manufacturing and sales management system that can automatically issue shipping instructions.

[Brief description of drawings]

FIG. 1 is a schematic diagram of a data flow of a manufacturing and sales management system showing an embodiment of the present invention.

FIG. 2 is a conventional system.

FIG. 3 is a detailed diagram of a data flow of a manufacturing and sales management system showing an embodiment of the present invention.

FIG. 4 is a configuration diagram of a manufacturing and sales management system showing an embodiment of the present invention.

FIG. 5 is a schematic flowchart of the manufacturing and sales management system showing an embodiment of the present invention from order receipt to delivery date reply.

FIG. 6 is an example of input items of order information of a manufacturing and sales management system showing an embodiment of the present invention.

FIG. 7 is an example of an input screen of the manufacturing and sales management system showing the embodiment of the present invention.

FIG. 8 is a schematic flow chart of a manufacturing and sales management system showing an embodiment of the present invention from factory shipment to customer shipment.

[Explanation of symbols]

101: Order information 102: Forecast order 103: Unofficial order 104: Confirmed order 105: SD (Sales and Distribu)
106: Sales management system 108: Sales inventory 109: Factory 110: Production management system 111: Factory inventory 112: Production plan 114: Factory delivery date answer 115: MM (Material Management)
t: inventory / purchasing management module 116: ATP (Available To Prom)
ise: Automatic delivery date reply module or Resch
117: Delivery date response 118: Factory shipment 119: Sales receipt 120: MRP (Material Request)
ents Planning: Material requirement planning) 201: Customer 202: Sales person 203: Business (ordering) person 204: Production management person 205: Business person (answer) person 206: Factory 207: Production factory 208: Sales department 401: Business headquarters service -Bar 402: Data warehouse server 403: Print server 404: Head office server 405: Production management server 406: Production management server 407: Production management server 408: Collection and distribution Server 410: Software development server

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Yoshio Hattori             1-8 Nakase, Nakase, Mihama-ku, Chiba City, Chiba Prefecture             Ico Instruments Co., Ltd. (72) Inventor Masaru Suzuki             1-8 Nakase, Nakase, Mihama-ku, Chiba City, Chiba Prefecture             Ico Instruments Co., Ltd. (72) Inventor Osamu Watanabe             1-8 Nakase, Nakase, Mihama-ku, Chiba City, Chiba Prefecture             Ico Instruments Co., Ltd. (72) Inventor Yasuhiro Matsukawa             1-8 Nakase, Nakase, Mihama-ku, Chiba City, Chiba Prefecture             Ico Instruments Co., Ltd. F-term (reference) 3C100 AA01 BB02 BB03 BB04 BB36                       BB39 CC05

Claims (13)

[Claims] 1. A means for inputting order information such as a quantity and a delivery date by giving rank information for each item, a serial number giving means for giving an order serial number to the order information, the order information and the order serial Storage means for storing a number, inventory management means for managing inventory information of each item, means for transmitting the order information, the order serial number, and the inventory information to a manufacturer's system, the order information, The required quantity calculation means for calculating the number of new inputs from the stock information and the stock information on the manufacturer side by a computer, the production planning means for creating a production plan, and the finished quantity and finish date of each item from the production plan. From the manufacturer's delivery date reply means for responding to the manufacturer's delivery date information, means for transmitting the manufacturer's delivery date reply to the system of the order information sender, and the manufacturer's delivery date reply and the inventory information. Person A manufacturing and sales management system comprising: a delivery date reply means for allocating the finished quantity of each item to the order serial number according to the law. 2. The manufacturing and sales management system according to claim 1, wherein the rank information is one of three ranks of forecast orders, unofficial orders, and confirmed orders. 3. The manufacturing / sales management system according to claim 1, wherein the order information, the order serial number, and the inventory information are transmitted to a system on the manufacturer side every predetermined time. 4. The manufacturing and sales management system according to claim 1, wherein the manufacturer's delivery date reply is transmitted to the system on the order information sender side every predetermined time. 5. The manufacturing and sales management system according to claim 1, wherein the predetermined method is a delivery date reply means for allocating the finished quantity of each item in the order of the order number. 6. The manufacturing and sales management system according to claim 1. 7. A step of adding rank information to each item and inputting order information such as quantity and delivery date, a step of giving an order serial number to the order information, and storing the order information and the order serial number. The step of transmitting the order information, the order serial number, and the inventory information to the manufacturer's system, and calculating the number of new inputs from the order information, the inventory information, and the manufacturer's inventory information. Amount calculation step, a production plan creation step, a step of replying a finished quantity and a finish date of each item from the production plan, a step of transmitting the reply to a system on the order information sender side, a reply And a delivery date response step of allocating the finished quantity of each item to the order serial number according to a predetermined method from the inventory information. Management method. 8. The manufacturing and sales management method according to claim 7, wherein the rank information is one of three ranks of forecast orders, unofficial orders, and confirmed orders. 9. The manufacturing and sales management method according to claim 7, further comprising a step of transmitting the order information, the order serial number, and the inventory information to a manufacturer's system at predetermined time intervals. . 10. The manufacturing and sales management method according to claim 7, further comprising a step of transmitting the manufacturer's delivery date reply to the system on the order information sender side at predetermined time intervals. 11. The manufacturing and sales management method according to claim 7, wherein the predetermined method is a step of allocating a finished quantity of each item in the order of the order number. 12. The step of transmitting order information, order serial number, and inventory information to a manufacturer's system until there is no backorder for each item, from the order information, the inventory information, and the manufacturer's inventory information. Requirement calculation step of calculating the number of new inputs, step of creating a production plan, step of replying the finished quantity and finish date of each item from the production plan, and the reply to the order information sender side system 8. The step of transmitting, and the step of answering the delivery date of allocating the finished quantity of each item to the order serial number according to a predetermined method from the reply and the inventory information are executed at predetermined time intervals. Manufacturing and sales management method described in. 13. The manufacturing and sales management method according to claim 7.