CN115456546A - Method for dynamically generating main plan report - Google Patents

Abstract

A method for dynamically generating a master plan report includes the following steps: s1, preparing relevant conditions for inputting main plan data; s2, calculating an order delivery period; s2-1, making an order delivery commitment; s2-2, one-click commitment; s2-3, the user adjusts the commitment quantity and the corresponding planning time and recalculates the result; s3, checking the main plan, wherein the task states of the main plan are 'waiting for scheduling', 'partially scheduled', 'totally non-scheduled' and 'simulation failure', rechecking operation can be carried out, and eight-step checking is carried out; s4, plan simulation verification; and S5, releasing the plan log.

Description

Method for dynamically generating main plan report

Technical Field

The invention relates to the field of software application development, in particular to a method for dynamically generating a main plan report.

Background

Generally, an enterprise business plan, also called a medium-term and long-term development plan or a sales plan, is a strategy plan adapted to the market environment and made by the enterprise under the guidance of business strategy, which mainly explains the sales objective and profit objective of the enterprise. Business plans serve to reconcile the gap between market demand and enterprise manufacturing capacity. If the market demand increases, the sales goals are expected to increase.

The production planning outline (master plan) is a refinement of the business plan or sales plan of an enterprise to account for the monthly production volumes of each type of product, as well as the monthly and yearly exchange volumes of each type of product and all types of products, within the planning prospect, subject to available resources. It should be noted that the annual aggregated volumes should be consistent with the sales objectives in the business plan or the sales objectives in the sales plan. The main plan prospect is typically rolling year-to-year and breaking month-to-month. The main planning outline has the main function of coordinating the operation plan and guiding the resource requirements of the enterprise.

The creation of a master production plan typically involves the following steps:

1. determining a production forecast for each final project based on the production plan and the schedule;

2. calculating a total demand based on the production forecast, the received customer orders, the fitting forecast, and the demand quantity of the final project as dependent demand items;

3. calculating the planned receiving quantity and the predicted available quantity of the main production in each time zone according to the total demand, a predetermined order strategy and batch, the safe stock and the initial stock;

4. evaluating the feasibility of the alternative scheme of the main production plan by using the rough capacity plan, simulating the optimization, giving a main production plan report, and synchronizing the time-interval versions of the related main plans to related departments or personnel;

the defects of the current main production plan are as follows:

1. the existing network system can not provide dynamic generation of a main plan (including a daily plan, a weekly plan, a monthly plan and the like) for a while;

2. the related plans can be published for many times at different time, are dynamically adjusted, and how to trace and record the edition contents of the plans have no related function in the prior art;

3. the existing system functions do not support the change on-line comparison function under different versions;

4. after the main plan is generated, the main plan needs to be pushed, checked and downloaded to appointed personnel.

Disclosure of Invention

The invention aims to solve the defects in the prior art and provides a method for dynamically generating a main plan report; the technical problem to be solved by the invention is as follows:

1. the traditional production planning mode has the problem which is difficult to solve, so that the production master planning and scheduling become the problems of asymmetric and non-real-time enterprise management information;

2. contradictions and balance points exist between the dynamically changing internal and external environments and the stability of enterprise internal planning and scheduling, and the traditional modes of main production planning and material demand planning are adapted to the on-demand production environment;

3. at present that computer computing power is greatly improved, the invention dynamically generates a master plan schedule based on current system platform perception and required resource condition of an enterprise in a rolling calculation mode, and automatically saves the master plan schedule according to historical versions (users can define the master plan schedule), thereby forming a buffer space from uncertainty to relative certainty, and the enterprise production management is stable, and meanwhile, the change of planning prospect of the enterprise in the future can be perceived and prepared in advance.

In order to achieve the purpose, the invention adopts the following technical scheme: a method for dynamically generating a master plan report includes the following steps:

s1, preparing relevant conditions for inputting main plan data;

s2, calculating an order delivery period;

s2-1, making an order delivery commitment;

s2-2, one-click commitment;

s2-3, the user adjusts the commitment quantity and the corresponding planning time and recalculates the result;

s3, checking the main plan, wherein the task states of the main plan are 'waiting for scheduling', 'partially scheduled', 'totally non-scheduled' and 'simulation failure', rechecking operation can be carried out, and eight-step checking is carried out;

s4, plan simulation verification;

and S5, releasing the plan log.

Preferably, the eight-step verification comprises the following steps:

and S3-1, checking the order BOM or the product BOM.

S3-2, checking a product process path:

s3-3, judging whether each workshop has output materials or not;

s3-4, checking inventory reservation;

s3-5, checking material substitution;

s3-6, purchasing and outsourcing supply resource comparison;

s3-7, comparing the self-made processing resources;

and S3-8, inquiring resource productivity.

Compared with the prior art, the invention has the beneficial effects that:

1. the main plan is based on a dynamic task pool, can be automatically issued regularly, and is managed with the production plan and the material demand in a unified way, and data sources are unified:

2. the main plan is cooperatively updated on line in real time, and the business process is paperless:

3. reduce the information asymmetry, promote communication efficiency:

4. each historical version is convenient for summarizing, comparing and analyzing, and is a reference for enterprise management in advance.

Detailed Description

In order to further understand the objects, structures, features and functions of the present invention, the following embodiments are described in detail.

The method for dynamically generating the main plan report of the embodiment of the invention comprises the following steps:

s1, preparing relevant conditions for inputting main plan data;

data sensing and access are divided;

the method comprises the steps of product safety stock, a demand order, a material list, a BOM (bill of material) table, delivery conditions, an in-process prize and the like;

s2, calculating an order delivery period;

s2-1, inquiring orders;

s2-1-1, order synchronization: and inquiring various orders, including orders in progress, completed, cancelled, abnormal and the like. And generating an order line number of the pigeon according to the order number, and associating the order line number with each order.

S2-1-2, order detail: when the order details are checked, the corresponding available inventory and safety inventory can be inquired according to the product codes of the order details, and the suggested quantity, the suggested starting time and the like are calculated.

S2-2, one-click commitment;

the prerequisites are: if the selected order is not in the updating process, the selected order is in the synchronization process or the commitment process, and the user cannot perceive the selected order because the order information is changed in the updating process, so that the user needs to be informed whether the selected result is operable or not according to the order locking state;

if the order is locked in the updating process, the front-end user is informed of the order updating process and please operate later.

And S2-2-1, acquiring all order details according to the selected order, and displaying the order details in a sequence according to planned delivery time.

And S2-2-2-1, if the product dimension is used as the division, data summarization is carried out according to the product, available inventory and safety inventory are inquired, and finally the data are displayed at the front end.

S2-2-2-2, if the order dimension is used as the division, sorting is carried out according to the order delivery time, and if the same product exists in all the order details, the use of available stock is calculated with the planned delivery time being earlier as the priority;

further, the calculation logic of the available inventory numbers: inquiring the available inventory number of the corresponding material code, if the order commitment detail of the same product code is in progress, deducting the available inventory number occupied by the order commitment detail, wherein the minimum is 0;

namely: if the query result available inventory > accumulatively occupies the available inventory, the number of available inventories = the query result available inventory-accumulatively replenishes the safety inventory;

otherwise the number of available inventory =0;

further, the calculation logic of the security inventory number: inquiring the minimum safe stock number corresponding to the material code, if the safe stock of the material is replenished in the calculation of the ongoing order acceptance detail demand (the product with the corresponding quantity is planned in the demand), the safe stock can not be calculated again when the subsequent same material code is the same, the safe stock in the logic is changed, if the accumulated replenished safe stock is less than the minimum safe stock inquired at the moment, the safe stock number is equal to the inquired minimum safe stock minus the accumulated replenished safe stock;

namely: if the query result minimum safety stock > is accumulated to be supplemented to the safety stock, the number of the safety stocks = the query result minimum safety stock-the accumulated to be supplemented to the safety stock;

otherwise, the number of safe storages =0.

S2-2-3, calculating the demand: the available inventory and the replenishment safety inventory are used preferentially before the planned delivery time, and the corresponding quantity is deducted once the inventory is used and replenished;

namely: net demand = order number-available inventory number + secure inventory number.

S2-2-4, calculating the commitment quantity: calculating the time (in days) required by production according to the committed quantity;

production required time = committed number/daily capacity + cumulative lead time;

daily capacity = man-hour capacity × 8 in the resource capacity configuration; (8 hours is considered by a default day)

The method comprises the steps that the required time is backward pushed forwards according to planned delivery time to obtain suggested start time and suggested finish time, if the suggested start time is smaller than the current time, the suggested start time is the current time, and then production time is added backwards to be the suggested finish time;

resource capacity allocation acquisition: and inquiring the resource capacity configuration according to the material code and the material type to obtain the working hour capacity and the accumulated lead time of the corresponding product.

And S2-3, the user can adjust the amount of the commitments and the corresponding planning time, recalculate the result after adjustment, generate a main planning task according to the calculation result, and update the order commitments to be finished and lock the inventory occupied by the commitments.

S3, checking the main plan, wherein the task states of the main plan are 'waiting for scheduling', 'partially scheduled', 'totally non-scheduled' and 'simulation failure', rechecking operation can be carried out, and eight-step checking is carried out:

and S3-1, checking the order BOM or the product BOM.

S3-2, checking a product process path:

if the product of the planning list does not belong to the self-made piece, all the subsequent steps are not verified and all the steps pass;

and if the product of the planning list belongs to the self-made piece, calling a product process path interface through the product code and the effective state condition to acquire process path information.

Judging whether a virtual part exists according to the material attribute returned by a process path interface (main data), and if so, unfolding downwards until the virtual part does not exist;

and (3) judging according to workshop data returned by the process path interface (main data):

if the workshop is not configured, prompting that the workshop information does not exist under the process path;

and if the workshop is configured, judging whether the working procedures and materials of the workshop are configured, and if not, prompting that the working procedures or the materials of the workshop are not configured.

And S3-3, judging whether each workshop has produced materials according to the materials and workshop information returned by the process path (main data) in the step S3-2, and prompting that the workshop [ XXX ] does not produce materials and please configure the process path at the front end if the workshop does not produce materials.

S3-4, checking inventory reservation: according to the material information returned by the process path (main data) in the step S3-2, firstly inquiring the material plan, strategy configuration and material scheduling, judging and considering the loss rate and available inventory;

net demand number: material usage and planned quantity;

considering the number of wear rate requirements: material usage by projected amount (100 + loss rate)/100;

consider the number of available inventory requirements: calling an interface to obtain the inventory quantity of each material and then calculating, wherein the logic is as follows: material usage amount-planned amount-inventory amount;

considering the number of demand for attrition rates, considering the number of demand for available inventory: material usage amount planned amount (100 + loss rate)/100-inventory amount;

if the calculated number is insufficient, the difference number is prompted.

S3-5, checking material substitution:

and (4) acquiring substitute material information according to the material information batch query interface returned by the process path (main data) in the step (S3-2), and prompting at the front end if no substitute material information exists.

S3-6, purchasing and outsourcing supply resource comparison:

and inquiring a material detail interface according to the material information returned by the process path (main data) in the step S3-2 to obtain the name and code of the supplier to which the material belongs, and prompting at the front end if the information of the supplier cannot be inquired.

S3-7, self-made processing resource comparison;

without check logic, pass directly.

S3-8, resource productivity query:

judging whether each workshop has configured capacity according to workshop information returned by the process path (main data) in the step S3-2, inquiring whether the material plan-strategy configuration-resource capacity has configured capacity information or not if not, and prompting that the resource capacity configuration is lacked at the front end if not;

after the main planning task is rechecked, checking that the steps S3-1, S3-2 and S3-3 or the eight-step check are passed, and changing the planning state into 'normal dischargeable';

if all eight checks fail, the scheduling status becomes "all not discardable" and the checking step becomes "partially discardable" in addition to the two cases described above.

S4, plan simulation verification;

when the main plan task state is 'normal and can be arranged', firstly executing eight-step verification of inspection, and then carrying out simulation verification:

starting simulation calculation according to product codes, plan quantity, delivery time and the like of the main plan task data, refreshing the simulation progress and generating a simulation log in each step of data assembly and calculation;

s4-1, inquiring upper and lower level data of a product process route and a workshop process tree assembly product according to the product code;

the simulation result is embodied in a product plan of a simulation result: the product is grade 1, the output of a workshop is grade 2, and the input material is grade 3;

the working hour capacity of the product is the minimum capacity of all workshops, and the task lead time is the maximum lead time of all workshops;

the working hour capacity and the lead period of the subordinate material list are obtained from the respective workshop. And if the loss rate, the capacity and the lead time of the material are all empty, inquiring and taking the resource capacity in the strategic configuration of the material plan.

And S4-2, inquiring BOM versions and material information of the materials through the material codes.

And S4-3, preliminarily calculating the starting time of all tasks through the task lead period.

And S4-4, inquiring the information of the substitute materials of all the materials.

And S4-5, inquiring material scheduling configuration in the material planning strategy configuration through the product code and the material code.

And S4-6, setting products and whether materials consider available inventory or consider safe inventory and the like through material scheduling configuration.

S4-7, judging whether available stock, safety stock and the like are inquired or not through material scheduling configuration of the task, and setting the available stock safety stock and the like of each product and material;

and if the configuration is not considered, the configuration is uniformly set to 0.

And S4-8, calculating the net requirements of tasks at all levels, wherein the calculation is progressive layer by layer, namely calculating a lower level after the upper level is calculated.

Preferably, the output material does not participate in the net demand calculation, and the input material is calculated according to the superior net demand of the output material.

The product does not consider the substitute, and the temporary removal of the reservation cannot be locked during the purchasing process;

product wool demand = product plan number;

lower wool demand = net demand for product;

if the material scheduling configuration of the material task needs to consider the loss rate:

lower lint demand = net product demand (100 + loss rate)/100;

the loss rate of the product is not considered, and the consumption is 1;

net demand = wool demand-available inventory of replacement materials;

if the net demand is less than the minimum safe inventory for the material or product, then net demand = net demand + maximum safe inventory.

And S4-9, calculating the start time and the end time of the task according to the net demand and the daily capacity. If the start time is earlier than the current time, the start time is set to 0 o' clock of the current date.

And S4-10, inserting a product plan according to the calculation result, wherein the product plan is in an upper-level and lower-level unfolding mode, and the feeding of the self-made parts is not displayed.

S4-11, merging the same material tasks of the same process in the same workshop according to the calculation result, wherein the rest simulation results except the product plan do not generate the simulation result of the output material level;

a resource plan is generated, the resource plan not generating a product level result.

And S4-12, generating a reservation suggestion according to the number of occupied inventory, and not generating if the inventory is not occupied.

S4-13, generating a substitution suggestion according to the occupied substitute stock, and if the substitute stock is not occupied, not generating;

the substitute suggestion detail is the detail of occupying each substitute material.

And S4-14, generating a material complete set suggestion according to the calculation result.

And S4-15, finishing the plan simulation, wherein the simulation progress is set to be 100%.

Simulation result verification logic: checking that the verification of the steps S3-1, S3-2 and S3-3 or the eight steps is passed and the simulation log is not abnormal, the state of the plan can become simulated;

if the simulation fails, the status of the plan may become "simulation failed," at which time a recheck may be required.

S5, a plan log is issued, a main plan can record in the plan log, and the 'simulated' plan can also be issued by one key to be dispatched:

the master plan of one-key simulation will have records in the plan log, and the "simulated" plan can also be issued one-key for dispatching:

s5-1, with the material demand of 0, not generating production order and purchase order

S5-2, arranging the production work order-the production piece corresponding to the product plan, wherein the material attribute is a self-made piece, and the material type is a material issuing and arranging production work order of a finished product or a semi-finished product

S5-3, purchasing work order-input piece corresponding to product plan, material attribute is purchasing piece or outsourcing piece, and material type is material sending purchasing work order of non-virtual piece

And S5-4, updating the states of plan simulation, product plan and resource plan to be issued, and locking the inventory of the reservation suggestions.

And S5-5, storing data of a planning result, namely a product planning table, a purchase planning table, a production planning table, an outsourcing planning table, an inventory reservation table and a complete set tracking table.

And S5-6, after the release is successful, the plan log state is changed into released, and other tasks of the same product code which are simulated but are not released by the plan log are reset (if the lock library is available, the inventory is released).

The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims (2)

1. A method for dynamically generating a master plan report is characterized by comprising the following steps:

s1, preparing relevant conditions for inputting main plan data;

s2, calculating an order delivery period;

s2-1, making an order delivery commitment;

s2-2, one-click commitment;

s2-3, the user adjusts the commitment quantity and the corresponding planning time and recalculates the result;

s3, checking the main plan, wherein the task states of the main plan are 'waiting for scheduling', 'partially scheduled', 'totally non-scheduled' and 'simulation failure', rechecking operation can be carried out, and eight-step checking is carried out;

s4, plan simulation verification;

and S5, issuing a plan log.

2. The method for dynamically generating a master plan report according to claim 1, wherein: the eight-step verification comprises the following steps:

s3-1, checking order BOM or product BOM;

s3-2, checking a product process path;

s3-3, judging whether each workshop has output materials;

s3-4, checking inventory reservation;

s3-5, checking material substitution;

s3-6, purchasing and outsourcing supply resource comparison;

s3-7, comparing the self-made processing resources;

and S3-8, inquiring resource productivity.