JP2002240949A - Method and device for supporting storage/deivery and inventory control, storage medium and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To increase a workability, remarkably shorten a required time, increasing an accuracy, and remarkably relaxing an attributability when a production planning is performed. SOLUTION: For a previous delivery plan, present performance, this delivery plan, this production plan, delivery amounts are disposed under a reference line, and stock amounts are disposed above the reference line for displaying as bar graphs.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for supporting incoming / outgoing stock management, a device therefor, a storage medium, and a program. More specifically, a method for supporting incoming / outgoing stock management using a bar graph, a device therefor, a storage medium, and a program. About.

[0002]

2. Description of the Related Art Conventionally, when planning a production of a product, first, a post-process is performed based on a market condition, an index indicating the market condition (an index highly relevant to product demand such as temperature and weather) and a delivery history. (4) The process following the process (own process) controlled by itself, in other words, the process using the product (product) of the own process. Includes consumers and sales companies. Delivery plan of the product (final product produced by own process) to｝ (This is a plan of delivery of the product to the post-process, and means the sales plan if the post-process is a consumer or a destination company.) Is created. The delivery plan may be issued and changed a plurality of times during the product delivery period.

[0003] Further description will be made.

A. At the stage when the product release plan for the post-process is created, the current inventory amount in the own process (the process managed by itself) and the expected production amount are compared with the release plan, and the Calculate the excess or deficiency of the production volume by delivery date.

B. After that, the future production plan is drafted after taking into account the future operation rate (availability) of the own process, the production capacity of equipment and personnel, and the upper limit of product inventory.

C. Calculate the required amount of materials (materials necessary for producing products) from the production plan obtained in B, take into account the lot size of the materials, and then add the materials to the previous process (provide or sell the materials to your own process) In some cases, an external company may correspond to this process.), And provide the delivery date and quantity of materials necessary for production.

D. For the presented required material quantity, the deliverable amount of material from the previous process (a table showing the amount of deliverable material by delivery date calculated in the previous process based on the production plan established in the previous process) is presented. You. Based on the presented deliverable amount of the material, the producible amount for each material delivery date (converted from the quantity of material to the number of products that can be produced for each delivery date of material) is calculated.

E. The production amount of D is compared with the production plan of B, and the production plan of B is corrected.

F. The corrected production plan of E and the delivery plan are compared, and the delivery plan is changed for the difference. If the change is accepted, the production planning work is terminated. Conversely, if the consent is not accepted or the delivery plan is changed due to market conditions, the work from A is repeated.

[0010]

The materials necessary for the above-mentioned production planning work and the materials to be created are as follows.

Materials required for A: (previous and current) delivery schedule table, inventory table, production plan table, production results table Material prepared for A: list of production excess / deficiency (produced in production plan before correction) Table showing how much the quantity differs from the corrected shipment quantity) Required data for B: Production capacity table, Production planning table, Product inventory upper limit table (Product inventory in own process Table showing the maximum number of products that can be stored), List of production excess / deficiency List B: Production capacity standard production schedule (Production capacity of own process without considering the amount of materials necessary for product production) Table of production plan calculated only based on vacancy) Necessary materials for C: Production capacity standard production plan table, material requirement conversion table (table showing the amount of material necessary to produce one product), material lot size Table (Minimum lot size that can be ordered) ), Material stock upper limit table (table showing the maximum number of materials that can store material inventory in their own process) Material for C: Material purchase order Document required for D: Material delivery schedule, material Requirement conversion table Material prepared for D: List of producible amount by material delivery date Required material for E: List of producible amount by material delivery date,
Production capacity standard production plan sheet Material prepared for E: Final production plan table (Production plan table that satisfies all conditions to be taken into account in preparing production plan) Required material for F: Final production plan table, Delivery plan Documents prepared for Table F: None. Note that not all of the above required materials and prepared materials are necessarily physically present. These may exist as knowledge and memos of the production planner, or may not exist at all because the procedure of the production planning work itself is simplified.

As a result, the following disadvantages occur.

1. There is an inconvenience that the amount of materials and the time and effort required for searching are increased.

As shown in the necessary materials for the entire business, there are a very large number of materials necessary for making a production plan, and in general, these materials exist as separate materials. In order to make a production plan for each product, it is necessary to find out the parts of the product from each material and compare them each time, which is very time-consuming.

2. There is an inconvenience of making the production planning work an individual.

[0016] As shown in the above A, due to the trouble of acquiring and comparing a large amount of materials, there are many cases where the materials must exist as knowledge of the person in charge of planning. For this reason, a situation has generally arisen in which a production plan can be created only by a limited number of people.

3. There is an inconvenience of inadequate planning.

As shown in the above A and B, a production plan requires a great deal of labor, personal knowledge and work, so that the speed and simplicity of the plan creation are prioritized over the degree of completion of the plan. In many cases, processes that are originally required for creation are omitted. As a result, the plan is inadequate, causing excess inventory, loss of delivery (sales), delay of delivery, and the like.

4. There is an inconvenience of a deviation between the delivery (sales) plan and the production plan.

Originally, production should be performed for delivery (sale), but in many cases, the production plan is performed at a place different from the delivery (sales) plan. Therefore, the production plan may not match the tendency (priority) and priority of dispatch (sales), and as a result, excess inventory, opportunity loss of dispatch (sales), and delivery deadline may occur.

5. There is an inconvenience that it takes time and effort to change the production plan in response to the change of the delivery (sales) plan.

Each time the delivery (sales) plan is changed, it is necessary to change the production plan.
How the plan changed, how much
It is very troublesome to check such things, and it takes a very long time to create a changed production plan.

The present invention has been made in view of the above problems, and it is possible to improve workability in performing a production planning operation and the like, and to significantly reduce the required time. It is an object of the present invention to provide an in-out / out-out stock management support method, an apparatus, a storage medium, and a program capable of improving accuracy and greatly reducing personality.

[0024]

According to a first aspect of the present invention, there is provided a bar inventory management support method, wherein a bar graph representing a stock quantity above a reference line and a shipment quantity below a reference line is created for each product to be managed. This is a method of displaying the created bar graphs for a plurality of products or chronologically.

According to a second embodiment of the present invention, there is provided a bar graph representing a previous retrieval plan, a current retrieval and actual inventory, a bar graph representing a current retrieval plan,
And a method representing a stock quantity calculated in the current production plan.

The inventory control method according to claim 3 is a method of dividing the stock quantity into a product stock quantity, a work-in-process stock quantity, and a material stock quantity and displaying them in this order.

According to a fourth aspect of the present invention, there is provided a method for supporting stock in / out stock management, wherein a product stock quantity and a shipping quantity are classified into time-series quantities and displayed in chronological order.

According to a fifth aspect of the present invention, there is provided an incoming / outgoing inventory management support device, wherein a bar graph representing an inventory quantity above a reference line and a shipping quantity below a reference line for each product to be managed represents a previous outgoing plan. Represents current outgoing and inventory performance,
A bar graph creation and holding unit that creates and holds the inventory schedule calculated in the current production plan and the inventory amount calculated in the current production plan, and displays the created bar graphs for a plurality of products or in chronological order. Display means.

According to a sixth aspect of the present invention, there is provided a storage medium storing a computer program capable of executing each step of the inventory control method according to any one of the first to fourth aspects.

According to a seventh aspect of the present invention, there is provided a program for causing a computer to execute each step of the inventory management support method according to any one of the first to fourth aspects.

[0031]

According to the first aspect of the present invention, there is provided a bar graph representing a stock quantity above a reference line and a shipment quantity below a reference line for each managed product. Can be displayed for multiple products or in chronological order, so anyone can easily and accurately grasp outgoing and inventory just by looking at the bar graph, and also smoothly produce plans in response to changes in outgoing plans. Can be easily changed, and the shipping amount and the stock amount among a plurality of products can be easily compared.

According to the inventory management support method of claim 2, bar graphs representing a previous delivery plan, current delivery and inventory results, current delivery plans, and current production plans are represented as bar graphs. Therefore, in addition to the effect of claim 1, by listing these plans, the validity of the plans can be easily and accurately determined.

According to the third embodiment, the inventory quantity is divided into a product inventory quantity, a work-in-progress inventory quantity, and a material inventory quantity and displayed in this order. In addition to the effect of 2, the stock for each stock form can be easily and accurately grasped.

According to the inventory control system of claim 4, since the product stock quantity and the shipment quantity are classified into time-series quantities and displayed in chronological order, the method according to claim 1 or 2 can be used. In addition to the function, the change of the stock quantity and the shipment quantity can be easily and accurately grasped.

In the inventory control system according to the fifth aspect, for each product to be managed, the bar graph creation and holding means displays a bar graph representing the stock quantity above the reference line and a shipment quantity below the reference line, respectively. It is created and held as one representing the previous delivery plan, one representing the current delivery and inventory results, one representing the current delivery plan, and one representing the inventory quantity calculated in the current production plan, and displayed by the display means. The created bar graph can be displayed for a plurality of products or arranged in chronological order.

Therefore, anyone can easily and accurately grasp the delivery and inventory simply by looking at the bar graph.
In addition, it is possible to easily change the production plan in response to the change in the outgoing plan, compare the shipment volume between multiple products, and compare the stock volume. Furthermore, by listing these plans, the validity of the plan can be simplified and It can be determined accurately.

In the case of the storage medium of claim 6, since the computer program capable of executing each step of the inventory management support method according to any one of claims 1 to 4 is stored, the computer program Is executed by a computer, the same operation as any one of claims 1 to 4 can be achieved.

According to the seventh aspect of the present invention, the program according to any one of the first to fourth aspects is realized by causing a computer to execute each step of the inventory management support method according to any one of the first to fourth aspects. Can be achieved.

[0039]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing a system for supporting inventory management according to the present invention;

FIG. 1 is a block diagram showing an embodiment of a stock-in / out stock management support device according to the present invention.

This entry / exit inventory management support apparatus has been provided with actual values or total numbers of materials to date, total ordered quantities, total planned production quantities (work in progress), completed total products (stock quantities), and total shipment quantities. A material quantity inputting section 1 for inputting each of the plan values, a work in progress quantity inputting section 2, a stock quantity inputting section 3, a delivery quantity inputting section 4,
A totaling unit 1a, 2a for totalizing the input quantities for each actual value or plan value for each unit period (for example, every month);
3a, 4a; a subtraction unit 3b for subtracting the input outgoing quantity from the totaled inventory quantity for each unit period; and a subtraction unit for subtracting from the total in-process quantity by the increment of the inventory quantity for each unit period. 2b, a subtraction unit 1b for subtracting from the material quantity tabulated by the increment of the in-process quantity for each unit period, a counting result from the tabulation unit 4a for each unit period, a subtraction unit 1b, 2
holding unit 5 for holding the subtraction results from b and 3b, respectively
In addition, the counting result from the counting unit 4a held in the holding unit 5 is arranged below the reference line, and the subtraction unit 1
b, an arrangement unit 6 for arranging the subtraction result from the reference line above the reference line, and the arrangement result by the arrangement unit 6 is visually displayed as a bar graph (hereinafter, referred to as a stacked bar graph) based on the reference line. And a display unit 7 to be used.

However, these components do not need to be physically present, and the computer may be controlled to perform processing corresponding to the operation of these components.
Of course, a storage medium storing a computer program for controlling the computer in this way may be prepared in advance, and the computer program may be executed by the computer.

The arranging unit 6 selects necessary results from the tabulation results and the subtraction results held in the holding unit 5 and arranges them so as to represent the previous delivery plan, current results, current delivery plan, and current production plan. Preferably, (see (1), (2), (3) and (4) in FIG. 2).

Here, the previous retrieval plan graph is obtained by stacking bar graphs of a retrieval plan before a new plan is created. The stacked bar chart shows the time points (year, month, week, day,
Is a point representing time, such as time). However, the outgoing volume of the previous plan one time before the plan creation time is displayed below the reference line,
For the delivery volume before that, the actual shipment volume is displayed.

Of course, these calculations are performed each time the inventory control device is operated.

The current performance graph is a bar graph in which the performance amounts of the respective processes, such as the shipping amount, the stock amount, the work-in-process amount, and the material amount, are sequentially stacked from bottom to top. However, the outgoing amount is displayed below the reference line. In addition, the delivery amount is classified according to the time of delivery and the time and the quantity. For inventory, work in progress, and material quantities,
In each step, the product is further subdivided according to the amount and time at which the product can be finally delivered. In each of the subdivided portions, a point in time at which shipment is possible is described. In addition, when the stock amount, the material amount, and the like exceed the prescribed upper limit, it is preferable to display the specific color such as red.

Of course, these calculations are performed every time the entry / exit stock management support device is operated.

The current outgoing plan graph is obtained by stacking the newly outgoing planned times this time into a bar graph. The stacked bar graph shows the scheduled outgoing amount at each time point in a time series from bottom to top. However, as for the outgoing volume at the time before the plan creation time, the actual result is displayed below the reference line.

Of course, these calculations are performed every time the entry / exit stock management support device is operated.

The production plan graph for this time is obtained by stacking the production plan newly prepared by the person in charge of the production plan this time from the bottom to the top according to the planned amount of each process, such as the shipping amount, the stock amount, the work in progress, and the material amount. It is a bar graph. However, the actual output is displayed below the reference line. Also,
The outgoing amount is classified according to the time and the amount of the outgoing warehouse. The stock amount, the work-in-progress amount, and the material amount are further subdivided in each process according to the amount that can be finally delivered as a product and the time. In each of the subdivided portions, a point in time at which shipment is possible is described. In addition, when the stock amount, the material amount, and the like exceed the prescribed upper limit, it is preferable to display the specific color such as red.

Of course, these calculations are performed each time the inventory management support device is operated.

FIG. 2 shows an example using the entry / exit inventory management support apparatus of FIG.
The following operational effects can be obtained by displaying the stacked bar graph.

(1) Previous delivery plan (newest of delivery plans made in the past), current delivery plan (delivery plan newly changed according to the current delivery status, market conditions, etc.) and production plan Are displayed side by side, the degree of change and the reason for change (change of total
(Early delivery, late delivery, etc.) can be clearly understood.

Then, since the current production result is displayed with respect to the present delivery plan, the deviation can be checked at a glance.
Products that need to be produced immediately and products that do not need to be produced can be instantly distinguished.

As a result, it is possible to smoothly change the production plan in response to the change in the delivery plan.

(2) Where (post-process, pre-process, own process), what (product, work-in-progress, material), how much,
Since it is displayed as a graph with the concept (position concept) of when and how much can be flowed to the post-process, both the outgoing planner and the production planner know what is in the whole process, how many, and when can it be used in the post-process At a glance.

As a result, it is possible to easily grasp the entire process by the screen display incorporating the position concept.

(3) By displaying the stacked bar graph for a plurality of products side by side on the screen, it is possible to determine at a glance which products have been issued in large quantities, the actual issued quantities, and the stock quantities (in-process quantities, material quantities). I understand. As a result, it is possible to compare the outgoing status of all types of products handled in the own process, the stock amount (stock risk), and the material amount (material risk).

As a result, it is possible to compare the delivery amount and the stock amount between a plurality of products at a glance.

(4) In the conventional production planning work, a plurality of materials must be compared and referred to, so that the work becomes excessively man-hour or the business process is inadvertently simplified. The apparatus can save the trouble of comparing and referring to materials to some extent.

As a result, it is possible to improve the browsability of materials and the planning process.

(5) In the visual display by the above-described device, the outgoing plan, outgoing results, production results, and production plan can be listed. By sharing it with the post-process, it is possible to easily adjust the planned quantities for delivery, production, materials, and the like.

As a result, the efficiency of the adjustment operation can be improved by sharing the visible display.

FIG. 3 is a diagram showing another display example.

This stacked bar graph shows the amount of work in progress, the amount of stock, and the amount of sales for each size of the Y-shirt in chronological order.

When these stacked bar graphs are compared,
It can be seen that the stacked bar graph is selling well as it falls as a whole, and conversely, it does not sell as much as the whole as a whole.

Therefore, it is possible to easily take measures such as increasing the amount of work in progress of a well-selling size.

FIG. 4 is a diagram showing still another display example.

This stacked bar graph shows, in chronological order, changes in the amount of work in progress, the amount of stock, and the amount of sales of a Y-shirt of a specific size.

If these stacked bar graphs are compared,
It is possible to easily determine whether the sales volume is increasing satisfactorily. Therefore, if the sales volume is increasing steadily, increase the work-in-progress and, on the contrary, prevent or suppress the increase of the work-in-progress, thereby preventing the inventory from increasing more than necessary. can do.

[0071]

According to the first aspect of the present invention, anyone can easily and accurately grasp the delivery and inventory simply by looking at the bar graph, and can smoothly change the production plan in response to the change of the delivery plan. This has a unique effect that the comparison of the shipping amount and the stock amount between the products can be easily performed.

The invention of claim 2 has a unique effect that, in addition to the effect of claim 1, by listing these plans, the validity of the plans can be determined simply and accurately.

The invention of claim 3 has a unique effect that the stock of each stock form can be easily and accurately grasped, in addition to the effect of claim 1 or 2.

The invention of claim 4 has a unique effect that the transition of the stock quantity and the shipment quantity can be easily and accurately grasped in addition to the effect of claim 1 or 2.

According to the fifth aspect of the present invention, anyone can easily and accurately grasp the delivery and inventory simply by looking at the bar graph. This makes it possible to easily compare the shipment amount and the stock amount of the products, and it is possible to easily and accurately determine the validity of the plans by listing these plans.

According to the sixth aspect of the present invention, the same effects as in any one of the first to fourth aspects are obtained by causing the computer program to be executed by a computer.

The invention of claim 7 is the invention of claims 1 to 4
The same effect as any of the above is achieved.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a stock entry / exit stock management support device of the present invention.

FIG. 2 is a diagram showing an example of a visual display.

FIG. 3 is a diagram showing another example of a visual display.

FIG. 4 is a diagram showing still another example of a visual display.

[Explanation of symbols]

 5 Holder 6 Arrangement 7 Display

Claims (7)

[Claims] 1. For each product to be managed, a bar graph representing the stock quantity above the reference line and the shipment quantity below the reference line is created, and the created bar graphs are displayed for a plurality of products or in chronological order. A stock entry / exit stock management support method, comprising: 2. The bar graph represents the previous delivery plan, the current delivery and actual stock, the current delivery plan, and the stock quantity calculated in the current production plan. 2. The in-and-out inventory management support method according to claim 1. 3. The inventory management support method according to claim 1, wherein the stock quantity is classified into a product stock quantity, a work-in-process stock quantity, and a material stock quantity and displayed in this order. 4. The entry / exit inventory management support method according to claim 3, wherein the product inventory quantity and the shipment quantity are classified into time-series quantities and displayed in chronological order. 5. A bar graph representing the stock quantity above the reference line and the shipment quantity below the reference line for each of the products to be managed, representing a previous delivery plan, presenting the current delivery and actual stock. Bar graph creation and holding means (5) and (6) for creating and holding as a representation of the current delivery plan and a representation of the inventory quantity calculated in the current production plan
And a display means (7) for displaying the created bar graphs for a plurality of products or in chronological order. 6. A storage medium storing a computer program capable of executing each step of the input / output inventory management support method according to any one of claims 1 to 4. 7. A program for causing a computer to execute each step of the input / output inventory management support method according to any one of claims 1 to 4.