JP2013008218A - Inventory balance management support system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To obtain an inventory balance management support system for supporting inventory balance management in real time by grasping an in-process amount including material costs, processing costs, and expenditure according to a production progress state.SOLUTION: An inventory balance management support system includes a process achievement and in-process amount information generation part 1 which generates process achievement information showing achievement lead time for every process, and in-process amount information showing transition of the expenditure, processing costs, and material costs on the basis of the respective pieces of process information, order information, purchase information, and cost information read based on information source system definition data 200 for every production unit stored in a storage part 2 for every production unit at a point when order numbers for every production unit, or the order numbers and divided lot numbers for every production unit are input, combines the process achievement information with the in-process amount information, generates a process achievement and in-process amount graph 300 in which achievement lead time of the respective processes, and ratio of the expenditure, the processing costs, and the material costs to the respective scheduled total amounts are aligned in time series to be displayed on a display part 3.

Description

  The present invention relates to a shelf remaining management support system that supports management of an inventory balance (hereinafter referred to as “shelf remaining”).

  Conventionally, the process progress and the amount remaining on the shelf are managed separately, and these management statuses are also grasped by aggregating data when production is over, so the cause investigation of the problem is delayed and the problem becomes large. It takes a lot of time and effort to investigate the cause. Even if the cause is known, the current order is too late. There is a problem that it is not possible to manage the “shelf remaining”.

  For example, production performance data (production progress data collected for each machine or line in each process) can be used to enable timely countermeasures for problems such as production progress and in-process inventory status. ) And the production progress status of each production model for each machine or line in all processes, as well as in-process inventory and all process in-process inventory display. (For example, patent document 1) is disclosed.

  In addition, to make it easier to create a production plan change plan that suppresses the increase in the remaining inventory, for example, the parts necessary for production at a certain time are summarized for each order, the amount is calculated, and the result is calculated. A graph is created, and the production plan amount for a certain period and the order amount for parts required for the production are displayed side by side. As a result, a technique for grasping in advance when a part order is generated and the order amount increases in the future is disclosed (for example, Patent Document 2).

Japanese Patent Laid-Open No. 11-053007 JP 2009-116558 A

  However, with the technique described in Patent Document 1, progress management and appropriate inventory can be determined while looking at the production progress status and the in-process inventory status, but it is possible to grasp the in-process amount according to the production progress status. There was a problem that it was not possible. In addition, the technique described in Patent Document 2 can manage the ordering time and ordering amount of parts. However, the processing cost required for parts processing and product assembly, design development, drawing creation, and quality control. There is a problem that it is impossible to manage the in-process amount including expenses related to the above, that is, the transition of the remaining shelf.

  The present invention has been made in view of the above, and it is possible to grasp the in-process amount including material costs, processing costs, and expenses according to the production progress status, and the shelf remaining management that supports real-time shelf remaining management The purpose is to provide a support system.

  In order to solve the above-described problems and achieve the object, the shelf-remaining management support system according to the present invention is a shelf-remaining management support system that supports the management of inventory balances, and manages a plurality of processes related to product production. Each process information from the process management system, order information from the order management system that manages the order number, number of units, and parts configuration for each production unit, from the purchase management system that manages the purchase of various parts necessary for the production of the product Based on cost information from a cost management system that manages costs, processing costs, and material costs associated with production of the product, actual lead time of each process, the cost, the processing cost, And a process result / work-in-process amount information generating unit for generating a process result / work-in-process amount graph that displays the ratio of the material cost to each planned total in time series, and the product A storage unit storing information source system definition data for each production unit that defines an information source system of each process information, purchase information, order information, and cost information for each production unit, and the process performance / in-process amount graph A display unit for displaying the process results / in-process amount information generation unit, based on the production unit-specific information source system definition data corresponding to the production unit input from the outside, each process information, The order information, the purchase information, and the cost information are read, and the process performance / in-process amount graph at the time when the production unit is input is generated.

  According to the present invention, it is possible to grasp a work-in-progress amount including a material cost, a processing cost, and an expense according to a production progress situation, and there is an effect that real-time shelf remaining management can be performed.

FIG. 1 is a diagram illustrating an example of a system configuration of a shelf remaining management support system according to the embodiment. FIG. 2 is a diagram illustrating a configuration example of a process result / in-process amount information generation unit of the remaining shelf management support system according to the embodiment. FIG. 3 is a diagram illustrating an example of information source system definition data for each production unit of the remaining shelf management support system according to the embodiment. FIG. 4 is a diagram illustrating an example of a process performance / in-process amount graph as an output example of the shelf remaining management support system according to the embodiment. FIG. 5 is a diagram illustrating an example of a process performance / in-process amount graph display processing flow of the shelf remaining management support system according to the embodiment.

  Hereinafter, a shelf remaining management support system according to an embodiment of the present invention will be described with reference to the accompanying drawings. In addition, this invention is not limited by embodiment shown below.

Embodiment.
FIG. 1 is a diagram illustrating an example of a system configuration of a shelf remaining management support system according to the embodiment.

  As shown in FIG. 1, a shelf remaining management support system 100 according to an embodiment includes a design development process management system 10 that manages a design development process, and a part arrangement information creation process management system 11 that manages a part arrangement information creation process. A processing process management system 12 for managing the processing processes before assembling the product, such as assembly of parts and exteriors, assembly of the board, or painting, a main body assembly process management system 13 for managing the main body assembly process of the product, A test process management system 14 for managing the test process, a shipping process management system 15 for managing the unloading process and the shipping process, the order date of the product, the order number (order number), the number of orders received, the order issue date, the delivery date, An order management system 16 that manages component configurations and the like, and a purchase management system 17 that manages information related to the purchase of various parts necessary for the production of products. , It is connected to the cost management system 18 for managing the cost and processing costs and material costs arising in association with the production of the product. Hereinafter, the design development process management system 10, the part arrangement information creation process management system 11, the machining process management system 12, the main body assembly process management system 13, the test process management system 14, and the shipping process management system 15 described above are collectively referred to as “ It is called a “process management system”.

  In the present embodiment, when the order quantity is divided and produced, a divided lot number is assigned for each division number. This divided lot number is managed by the order management system 16. If the number of orders received is not divided, or if the number of orders received is one, the production lot for each order number is one production unit. If the number of orders received is divided into multiple divided lots, One production unit is set as the production lot, and the order number and the divided lot number are combined and identified.

  As illustrated in FIG. 1, the shelf remaining management support system 100 according to the embodiment includes each process information from each process management system 10 to 15, order information from the order management system 16, and purchase information from the purchase management system 17. Based on the cost information from the cost management system 18, the actual lead time of each process, and the ratio of the cost, processing cost, and material cost to each planned total amount are displayed in chronological order and displayed in a time series. The process result / in-process amount information generation unit 1 that generates 300 (see FIG. 4), and the information source system definition data 200 for each production unit that defines the information source system of each process information, purchase information, and cost information for each production unit. (See FIG. 3) and a display unit 3 for displaying a process performance / in-process amount graph 300.

  FIG. 2 is a diagram illustrating a configuration example of a process result / in-process amount information generation unit of the remaining shelf management support system according to the embodiment. As shown in FIG. 2, the process performance / in-process amount information generating unit 1 includes design development process information, parts arrangement information creation process information, processing process information, main assembly process information, test process information, unloading / shipping process information, Based on the order information and the purchase information, the process result information generating unit 21 that generates the process result information, the cost, the processing cost, and the material cost obtained from the cost information, and the generation time of the material cost obtained from the purchase information , Design and development process information, parts arrangement information creation process information, machining process information, main body assembly process information, test process information, and the amount of work in process based on the costs and timing of processing costs In-process amount information generating unit 22 that generates information, and process result information and in-process amount information are combined to record the actual lead time of each process, and the schedule of expenses, processing costs, and material costs And a step Results and progress amounts graph generation unit 23 that generates a process actual-progress amounts graph arranged in time series the ratio forehead.

  Next, with respect to the production unit information source system definition data 200 of the remaining shelf management support system 100 according to the embodiment and the process performance / in-process amount graph 300 which is an output example of the remaining shelf management support system 100 according to the embodiment, This will be described with reference to FIGS.

  FIG. 3 is a diagram illustrating an example of information source system definition data for each production unit of the remaining shelf management support system according to the embodiment. FIG. 4 is a diagram illustrating an example of a process performance / in-process amount graph that is an output example of the shelf remaining management support system according to the embodiment.

  In the example shown in FIG. 3, as an example of the production source-specific information source system definition data 200, an information name and an information source system are associated with each production unit, and a serial number is assigned to each. In the storage unit 2, production unit-specific information source system definition data 200 is defined and stored for each production unit.

  FIG. 4 shows an example of a production lot for which production has been completed as an example of the process performance / in-process amount graph 300. In FIG. 4, the horizontal axis indicates the schedule from order receipt to shipment completion.

  An area A shown in FIG. 4 is an area for displaying the process performance information 400. In this area A, the actual result of the lead time (construction period) for each process (hereinafter referred to as “actual lead time”) is indicated by a bar graph.

  The lead time of the design development process is obtained from the design development process information output from the design development process management system 10. The lead time of the parts arrangement information creation process is obtained from the parts arrangement information creation process information output from the parts arrangement information creation process management system 11. The lead time of the parts procurement process is obtained from purchase information output from the purchase management system 17. The lead times for the exterior assembly process and the painting process are obtained from the machining process information output from the machining process management system 12. The lead time of the main assembly process is obtained from the main assembly process information output from the main assembly process management system 13. Further, the lead time of the unloading process and the shipping process is obtained from the unloading / shipping process information output from the shipping process management system 15. In addition, the order date and the order issue date are obtained from the order information output from the order management system 16. The parts arrangement date is set to the day after the completion date of the parts arrangement information creation process, that is, the start date of the parts procurement process. In the example shown in FIG. 3, the test process results are not displayed, but the lead time of the test process is obtained from the test process information output from the test process management system 14. Based on each information described above, process result information 400 indicating the result lead time for each process is generated.

  An area B shown in FIG. 4 is an area for displaying the in-process amount information 500. In this area B, the ratio of the cost, the processing cost, and the material cost to each planned total amount is indicated by a numerical value, and their transition is indicated by a graph. A graph indicated by a dotted line indicates a change in cost, a graph indicated by a one-dot chain line indicates a change in processing cost, and a graph indicated by a solid line indicates a change in material cost.

  Expenses, processing costs, and material costs are costs that accompany the production of products. Costs include design and development costs, drawing costs, quality control costs, etc., and processing costs include assembly of parts. And the cost of painting the exterior and assembly of the board. The material cost is the total cost of each part constituting the product.

  When the amount obtained by multiplying the ratio of the cost, processing cost, and material cost at each time point to the total amount of each cost is accumulated, the work amount at that time point, that is, the remaining shelf amount is obtained.

  Expenses, processing costs, and material costs are obtained from cost information output from the cost management system 18. In addition, the generation time of the material cost is obtained from purchase information output from the purchase management system 17, and the generation time of the expense and processing cost is obtained from each process information output from each process management system 10-15. Based on these pieces of information, work-in-progress amount information 500 indicating changes in expenses, processing costs, and material costs is generated.

  Next, an example of performing shelf remaining management support using the shelf remaining management support system 100 according to the embodiment will be described.

  In the present embodiment, the evaluator inputs the order number or the order number and the divided lot number to the shelf remaining management support system 100 according to the embodiment, so that the process results and the in-process amount up to that point for each production unit. A graph 300 is created and displayed. As a result, the evaluator can grasp the transition of the in-process amount including the material cost, the processing cost, and the cost according to the production progress status, and can evaluate the remaining shelf in real time.

  For example, the parts that make up the product main body need only be in stock immediately before the main body assembly process, but if the parts are delivered earlier than originally scheduled, the main body assembly process starts from the delivery date of the parts. During the period up to the start date, the material cost of the part becomes an extra shelf balance.

  For example, when a part with a high unit price is delivered, the ratio of material costs increases at that time.

  By evaluating the process performance / in-process amount graph 300 shown in FIG. 4 using the shelf remaining management support system 100 according to the embodiment, it is possible to evaluate the start time of each process and grasp the situation where the shelf remaining amount is excessive. For example, by specifying parts with fast delivery dates or parts with high unit prices, the start of each process is advanced in the next order, or orders for parts with early delivery periods are delayed, or replacement of parts with high unit prices Measures such as examining parts can be implemented efficiently.

  Next, the operation of the remaining shelf management support system 100 according to the embodiment will be described with reference to FIGS. FIG. 5 is a diagram illustrating an example of a process performance / in-process amount graph display processing flow of the shelf remaining management support system according to the embodiment.

  When the evaluator inputs the order number or the order number and the divided lot number and designates the production unit to be displayed (step ST101), the process result / in-process amount information generating unit 1 sets the designated production unit. The corresponding production unit-specific information source system definition data 200 is read from the storage unit 2 (step ST102), and an output request for each piece of information relating to the production unit is sent to the information source system of each process information, order information, purchase information, and cost information. Perform (step ST103). More specifically, using the example shown in FIG. 3, the process performance / in-process amount information generation unit 1 requests the design development process management system 10 to output the design development process information, and the part arrangement information creation process management system. 11 requests output of part arrangement information creation process information, requests output of machining process information to the machining process management system 12, requests output of main assembly process information to the main assembly process management system 13, and tests process management system 14 requests output of test process information, requests output of unloading / shipping process information to the shipping process management system 15, requests output of order information to the order management system 16, and sends purchase information to the purchasing management system 17. An output request is made, and the cost management system 18 is requested to output cost information.

  When each process information, order information, purchase information, and cost information are input (step ST104), the process result information generation unit 21 designs design development process information, parts arrangement information creation process information, machining process information, and main body assembly process. Based on the information, test process information, unloading / shipping process information, order information, and purchase information, process result information 400 is generated (step ST105).

  Further, the in-process amount information generating unit 22 performs in parallel with step ST105, the cost, processing cost, and material cost obtained from the cost information, the generation time of the material cost obtained from the purchase information, the design development process information, the parts In-process amount information 500 is generated based on the expenses obtained from the arrangement information creation process information, the machining process information, the main body assembly process information, the test process information, and the unloading / shipping process information and the generation timing of the machining costs (step) ST106).

  Then, the process result / in-process amount graph generation unit 23 combines the process result information 400 and the in-process amount information 500, and the actual lead time of each process and the ratio of the cost, processing cost, and material cost to each planned total amount. Are generated in time series (step ST107), and output to the display unit 3. The display unit 3 displays the process result / in-process amount graph 300 (step ST108).

  The evaluator evaluates the process performance / in-process amount graph 300 displayed on the display unit 3 and examines measures and the like (step ST109).

  As described above, according to the shelf management support system of the embodiment, the information source system definition for each production unit by associating the information source system of each process information, order information, purchase information, and cost information for each production unit. It is stored as data, and when the order number for each production unit, or when the order number and the divided lot number are input, the information source system definition data for each production unit is read, and each process information, order information, purchase information, Output information of each production unit to each information source system of cost information and cost information, and based on each process information, order information, and purchase information output from each information source system, actual lead time for each process In addition to generating process performance information to indicate costs, costs, processing costs, and material costs obtained from cost information, and generation of material costs obtained from purchase information Generates in-process amount information that shows the transition of expenses, processing costs, and material costs based on the period and the cost and processing cost generated from each process information, and combines process result information and in-process amount information In addition, the process results and work-in-progress amount graph in which the ratio of each process result and cost, processing cost, and material cost to each planned total is arranged in chronological order is generated and displayed. It is possible to grasp the amount of work in progress including the corresponding material cost, processing cost, and expense, and real-time shelf management can be performed.

  In addition, it is easy to evaluate the start time of each process and grasp the situation where the remaining amount of shelf is excessive, so identify parts with fast delivery date or parts with high unit price, and specify the start time of each process in the next order. It is possible to efficiently implement measures such as delaying the ordering of parts that are advanced or having a quick delivery date, or considering alternative parts for parts with a high unit price.

  In addition, since the in-process amount is displayed by classifying it into expenses, processing costs, and material costs, more appropriate evaluation can be performed for each cost, and the process plan and purchase plan for the next order or next product Can be reflected appropriately.

  Note that the configuration shown in the above embodiment is an example of the configuration of the present invention, and can be combined with another known technique, and a part thereof is omitted without departing from the gist of the present invention. Needless to say, it is possible to change the configuration.

DESCRIPTION OF SYMBOLS 1 Process results and in-process money amount information generation part 2 Memory | storage part 3 Display part 10 Design development process management system 11 Parts arrangement information creation process management system 12 Processing process management system 13 Main body assembly process management system 14 Test process management system 15 Shipment process management system 16 Order Management System 17 Purchasing Management System 18 Cost Management System 21 Process Result Information Generation Unit 22 In-process Amount Information Generation Unit 23 Process Result / In-process Amount Graph Generation Unit 100 Remaining Shelf Management Support System 200 Information Source System Definition Data by Production Unit 300 Process Actual / In-process amount graph 400 Process result information 500 In-process amount information

Claims (2)

A shelf remaining management support system that supports the management of inventory balance,
Process information from multiple process management systems that manage each process related to product production, order information from the order management system that manages the order number, number, and parts configuration for each production unit, necessary for production of the product Based on the purchase information from the purchase management system that manages the purchase of various parts and the cost information from the cost management system that manages the costs, processing costs, and material costs that accompany the production of the product A process result / in-process amount information generating unit for generating a process result / in-process amount graph that displays the lead time and the ratio of the cost, the processing cost, and the material cost to each planned total in time series; and
A storage unit that stores information source system definition data for each production unit that defines an information source system of each process information, the purchase information, the order information, and the cost information for each production unit of the product;
A display unit for displaying the process performance / in-process amount graph;
With
The process result / in-process amount information generating unit is configured to generate the process information, the order information, the purchase information, and the purchase information based on the production unit-specific information source system definition data corresponding to the production unit input from the outside. A shelf remaining management support system that reads out cost information and generates the process performance / work-in-process amount graph when the production unit is input. The process performance / in-process amount information generating unit
Based on each process information, the order information, and the purchase information, a process result information generating unit that generates process result information indicating the actual lead time of each process;
The cost obtained from the cost information, the processing cost, and the material cost, the generation time of the material cost obtained from the purchase information, the cost and the generation time of the processing cost obtained from each process information In-process amount information generating unit for generating in-process amount information indicating a transition of the expense, the processing cost, and the material cost,
A process result / in-process amount graph generating unit that generates the process result / in-process amount graph by combining the process result information and the in-process amount information;
The shelf remaining management support system according to claim 1, further comprising:

Images