Batch purchase date automatic calculation method and system integrating MRP supply and demand information

Abstract

The application discloses a batch purchase date automatic calculation method and system integrating MRP supply-demand information, which takes existing MRP supply-demand information as a basis, establishes temporary supply-demand data for calculation only under the premise of not directly modifying original MRP supply-demand data, and processes each replenishment batch with replenishment quantity according to time sequence one by one. In the calculation process, the system temporarily removes the replenishment quantity of the current replenishment batch and recalculates the expected inventory to determine whether the situation of being lower than a preset threshold value occurs at any time point, find out the time point at which the expected inventory is lower than the preset threshold value earliest, automatically calculate the alternative purchase date of the replenishment batch according to the lead days or the backtracking rule, and put the replenishment quantity into the temporary supply-demand data according to the alternative purchase date, so as to complete the batch-by-batch recursive purchase date automatic calculation.

Description

Technical Field

[0001] This invention relates to a data processing method and system, and more particularly to a method and system for automatically calculating batch delivery dates by integrating MRP supply and demand information, which can be applied to related technical fields such as production planning, procurement management and inventory control. Background Technology

[0002] With the development of manufacturing and supply chain management, enterprises generally adopt Material Requirements Planning (MRP) systems to calculate material replenishment quantities and delivery schedules based on forecasted demand, order data, and inventory status, serving as the basis for production scheduling and procurement operations. Existing MRP systems typically generate a set of supply and demand planning results at a specific point in time based on predetermined parameters and calculation logic, including the expected inventory levels for each period and the corresponding delivery dates.

[0003] However, in actual operation, changes in demand, production schedule adjustments, or delivery date changes frequently occur, meaning that the delivery dates calculated by the MRP system may not reflect the latest inventory risks or supply and demand conditions in real time. When managers need to adjust the delivery schedule, they often have to manually review the MRP supply and demand data and judge based on experience whether each replenishment batch should be delivered earlier or later. Such adjustments are not only time-consuming but also prone to inconsistent results due to differences in human judgment.

[0004] While some existing systems offer recalculation or scheduling functions, they mostly modify or recalculate the original MRP data directly. This makes it difficult to retain the original planning results as a benchmark for comparison, and it also hinders managers from assessing the impact of adjustments to the arrival times of each replenishment batch on inventory. Furthermore, existing practices typically adjust based on overall planning or a single point in time, rarely simulating the impact of adjustments to the arrival times of each replenishment batch on subsequent inventory changes in chronological order.

[0005] Therefore, how to calculate and simulate the delivery date for each replenishment batch without directly modifying the original MRP supply and demand data, and how to automatically determine the impact of delivery schedule adjustments on inventory, has become an urgent issue to be addressed in this technical field. Summary of the Invention

[0006] In view of the shortcomings of the prior art, the present invention provides a method and system for automatically calculating the batch purchase date by integrating MRP supply and demand information, so as to improve the problem that the existing purchase schedule adjustment relies on manual judgment or requires direct modification of the original MRP data, which is not conducive to comparison and evaluation.

[0007] The main objective of this invention is to simulate and calculate the delivery schedule of each replenishment batch through a data processing flow without directly modifying the original MRP supply and demand data, so as to automatically generate alternative delivery dates for each replenishment batch, thereby reducing the risk of insufficient or excessive inventory caused by changes in demand or scheduling adjustments.

[0008] To achieve the above objectives, this invention provides an automatic batch purchase date estimation method. Based on existing MRP supply and demand information, it first filters data with replenishment quantities according to time sequence to form a replenishment batch sequence. During the estimation process, each replenishment batch is processed individually. When processing a particular replenishment batch, the replenishment quantity of that batch is temporarily removed from the corresponding time sequence, and temporary supply and demand data for estimation purposes is established without directly altering the original MRP supply and demand data.

[0009] Next, the system recalculates the expected inventory for subsequent periods based on the temporarily stored supply and demand data, and determines whether the expected inventory falls below a preset threshold at any point in time, thus identifying the earliest point in time when the expected inventory fell below the preset threshold. Then, based on this point in time and a preceding number of days or a backward calculation rule, the system automatically calculates the alternative delivery date for this replenishment batch and includes the replenishment quantity in the temporarily stored supply and demand data according to the alternative delivery date. After completing the calculation for this replenishment batch, the system repeats the above calculation process sequentially for subsequent replenishment batches based on the temporarily stored supply and demand data after the completion of the previous replenishment batch, to complete the automatic calculation of the overall batch delivery date.

[0010] Furthermore, the present invention also provides an automatic batch purchase date calculation system for implementing the aforementioned method, which includes a data acquisition unit, a temporary supply and demand data establishment unit, a replenishment batch calculation unit, and an alternative purchase date update unit. The alternative purchase date refers to the suggested purchase date information generated or updated by the system after calculation, which is used as a basis for subsequent purchase schedule adjustments, rather than necessarily directly modifying the original MRP supply and demand data. Each unit is interconnected and works in coordination to execute the aforementioned automatic batch purchase date calculation method in sequence.

[0011] By employing the above-mentioned technical means, this invention can simulate the impact of adjustments to the procurement schedule on the expected changes in inventory on a batch-by-batch basis while retaining the original MRP planning results as a benchmark. This makes the calculation of the procurement date consistent and repeatable, and reduces the errors caused by manual judgment, thereby improving the stability and reliability of procurement planning and inventory management. Attached Figure Description

[0012] Figure 1 This is a flowchart of the automatic calculation method for batch purchase dates that integrates MRP supply and demand information, as described in an embodiment of the present invention. Figure 2This is a schematic diagram of the functional blocks of the batch delivery date automatic calculation system that integrates MRP supply and demand information in an embodiment of the present invention. Detailed Implementation

[0013] The present invention will be described in detail below with reference to specific embodiments. Example 1

[0014] like Figure 1 As shown, Figure 1 This is a flowchart of the automatic calculation method for batch delivery dates that integrates MRP supply and demand information according to the present invention. It uses existing MRP supply and demand data as a basis and calculates the delivery date of each replenishment batch in chronological order without directly modifying the original MRP supply and demand data.

[0015] like Figure 1 As shown, a method for automatically calculating batch delivery dates by integrating MRP supply and demand information includes: Step S01: Obtain MRP supply and demand information for at least one part number over a period of time. This MRP supply and demand information includes at least the initial inventory, demand, demand date, replenishment quantity, and expected inventory, which will serve as the basis for calculating subsequent delivery dates.

[0016] Step S02: Select data with replenishment quantities from the MRP supply and demand information in chronological order to form a replenishment batch sequence. Each replenishment batch is arranged according to its original delivery time and serves as the processing unit for subsequent batch calculations.

[0017] Step S03: For a replenishment batch in the replenishment batch sequence, the replenishment quantity of that batch is temporarily removed from the corresponding time series. Without directly changing the original MRP supply and demand information, a temporary supply and demand data set for calculation purposes is established based on the MRP supply and demand information. This allows the original MRP supply and demand data to be retained as baseline data, while the purchase date calculation is performed within the temporary supply and demand data set.

[0018] Step S04: Based on the temporarily stored supply and demand data, recalculate the expected inventory for the subsequent period to simulate the impact on the inventory status if the replenishment batch does not arrive at the originally scheduled time.

[0019] Step S05: After recalculating the expected inventory, determine whether the expected inventory falls below a preset threshold at any point in time. If such a situation exists, identify the earliest point in time when the expected inventory falls below the preset threshold. The preset threshold can be set based on safety stock, replenishment batch size, or a combination of both.

[0020] Step S06: When it is determined that the expected inventory will fall below the preset threshold, based on the earliest time point when the inventory shortage occurs, and in conjunction with a lead time, a specified date, or a backtracking rule, an alternative delivery date is automatically pushed back to serve as the adjusted delivery time for the replenishment batch.

[0021] Step S07: Incorporate the replenishment quantity of the replenishment batch into the temporary supply and demand data based on the alternative purchase date, and complete the calculation of the purchase date for the replenishment batch.

[0022] Step S08: Based on the temporary supply and demand data after the completion of the previous replenishment batch, repeat the aforementioned steps S03 to S07 for subsequent replenishment batches in sequence to complete the automatic calculation of the batch-by-batch delivery date for the entire replenishment batch.

[0023] Through the above-described process, this invention can simulate the impact of adjusting the delivery time of each replenishment batch on inventory without directly modifying the original MRP supply and demand data, and automatically calculate the reasonable delivery date for each replenishment batch.

[0024] When the recalculated projected inventory is less than zero at any point in time, the replenishment batch is determined to need to be delivered ahead of schedule. When the recalculated projected inventory is greater than the preset threshold at any point in time, the replenishment batch is determined to be delivered later. The advance number of days or the specified date are settable values ​​and are used to determine the number of days or the date to be pushed back from the earliest point in time for the alternative delivery date. The delivery date for each replenishment batch is calculated sequentially according to time sequence, and the calculation for the next replenishment batch is based on the temporary supply and demand data after the completion of the previous replenishment batch.

[0025] The following specific embodiment is provided to illustrate the operation of the aforementioned automatic batch purchase date calculation method. This specific embodiment is only used to aid understanding and is not intended to limit the scope of the invention.

[0026] In an embodiment of the present invention, the system obtains MRP supply and demand information for a certain part number during a planning period (e.g., on a daily or weekly basis) (corresponding to step S01). This MRP supply and demand information includes initial inventory, demand, replenishment quantity, and projected inventory. The system then filters out data with replenishment quantities in chronological order to form a replenishment batch sequence (corresponding to step S02), for example, forming a first replenishment batch, a second replenishment batch, and a third replenishment batch based on the original scheduled delivery dates.

[0027] When calculating the first replenishment batch, the system first temporarily removes the replenishment quantity of the first replenishment batch from the corresponding time series, and establishes temporary supply and demand data for calculation purposes only without directly changing the original MRP supply and demand information (corresponding to step S03). Next, the system recalculates the expected inventory for subsequent periods based on the temporary supply and demand data (corresponding to step S04), and determines whether a situation occurs at any point in time where the expected inventory falls below a preset threshold. If such a situation exists, the system identifies the earliest point in time when the expected inventory falls below the preset threshold (corresponding to step S05). The preset threshold can be set as, for example, a safety stock level, a replenishment batch size, or a combination of a safety stock level and a replenishment batch size.

[0028] When the system determines that an inventory shortage occurs at the earliest time point, it automatically calculates the corresponding alternative purchase date based on that earliest time point and a preceding number of days or a backtracking rule (corresponding to step S06). For example, if the preceding number of days is set to L days, the system can set the alternative purchase date to a date L days before the earliest time point, so that the replenishment quantity of the first replenishment batch can be completed before the earliest time point, reducing the risk of inventory shortage. Subsequently, the system includes the replenishment quantity of the first replenishment batch in the temporary supply and demand data according to the alternative purchase date (corresponding to step S07), and based on the temporary supply and demand data after the completion of the previous replenishment batch, it sequentially repeats the aforementioned calculation process for the second and third replenishment batches (corresponding to step S08) to complete the automatic calculation of the batch purchase date for the entire replenishment batch.

[0029] As can be seen from the above embodiment 1, the present invention performs batch-by-batch simulation and calculation by temporarily storing supply and demand data without directly modifying the original MRP supply and demand information. This allows the alternative purchase date for each replenishment batch to be automatically generated based on the time point of insufficient inventory and the number of days in advance or the backtracking rules. Furthermore, the calculation results of the previous batch can be used as the basis for the calculation of subsequent batches, thereby improving the consistency and repeatability of the calculation results. Example 2

[0030] like Figure 2 As shown, Figure 2 This is a functional block diagram of the batch delivery date automatic calculation system that integrates MRP supply and demand information according to the present invention. It includes multiple functional units, and each functional unit is interconnected and works in coordination to execute the aforementioned method process in sequence.

[0031] like Figure 2 As shown, an automatic batch purchase date calculation system integrating MRP supply and demand information is provided. The system includes at least a data acquisition unit 10, a temporary supply and demand data establishment unit 20, a replenishment batch calculation unit 30, and an alternative purchase date update unit 40.

[0032] The data acquisition unit 10 is used to acquire MRP supply and demand information for at least one part number over a period of time, and to provide the MRP supply and demand information to subsequent units for processing.

[0033] The temporary supply and demand data establishment unit 20 is used to establish temporary supply and demand data for calculation purposes only based on the MRP supply and demand information, and does not directly change the original MRP supply and demand information during the calculation process.

[0034] The replenishment batch calculation unit 30 is used to process replenishment batches one by one according to time sequence, and to perform temporary removal of replenishment quantity, recalculation of expected inventory, judgment of insufficient inventory time point, and pushback of alternative purchase date for each replenishment batch. The judgment of insufficient inventory is based on a preset threshold value, and the pushback of alternative purchase date is based on a number of days in advance, a specified date, or a pushback rule.

[0035] The replenishment batch estimation unit calculates the replenishment date for the next replenishment batch continuously, based on the temporary supply and demand data after the previous replenishment batch is completed, after the alternative purchase date update unit has completed the inclusion of the replenishment quantity according to the suggested purchase date information.

[0036] The replenishment batch calculation unit determines the time point of insufficient inventory based on a default threshold value, and the default threshold value is set based on safety stock, replenishment batch, or a combination thereof.

[0037] The replenishment batch calculation unit automatically calculates the corresponding alternative purchase date based on a settable lead time or backtracking rule, using the determined time of insufficient inventory as a benchmark.

[0038] The alternative purchase date update unit 40 is used to generate or update the corresponding suggested purchase date information based on the calculation result of the replenishment batch calculation unit 30, and to incorporate the replenishment quantity into the temporary supply and demand data based on the suggested purchase date information to form updated temporary supply and demand data. The updated temporary supply and demand data is then sent back to the replenishment batch calculation unit 30 as the basis for calculating the purchase date of the next replenishment batch.

[0039] Through the coordinated operation of the above-mentioned functional units, the system of the present invention can realize the aforementioned method for automatically calculating the batch purchase date, and based on the temporary supply and demand data after the completion of the previous replenishment batch, calculate the purchase date for subsequent replenishment batches in sequence to complete the automated processing of the overall purchase planning.

[0040] like Figure 1 and Figure 2As shown, the batch purchase date automatic calculation system integrating MRP supply and demand information of the present invention is used to execute the aforementioned batch purchase date automatic calculation method. Its functional units are interconnected and operate in sequence to realize the steps of the method.

[0041] During system operation, the data acquisition unit 10 first acquires MRP supply and demand information for at least one part number over a period of time, and provides the MRP supply and demand information to the temporary supply and demand data establishment unit 20. The temporary supply and demand data establishment unit 20 establishes temporary supply and demand data for calculation purposes only based on the MRP supply and demand information, and does not directly change the original MRP supply and demand information during the establishment and subsequent calculation process.

[0042] Next, the replenishment batch calculation unit 30 processes each replenishment batch sequentially according to time. When processing a particular replenishment batch, it first temporarily removes the replenishment quantity of that batch from the temporary supply and demand data, and then recalculates the expected inventory for subsequent periods based on the temporary supply and demand data to determine whether a situation of inventory shortage occurs at any point in time. When an inventory shortage is determined to exist, the replenishment batch calculation unit 30 automatically calculates the corresponding alternative delivery date based on the earliest time point, in conjunction with the preceding days, a specified date, or a backtracking rule.

[0043] Subsequently, the alternative purchase date update unit 40 incorporates the replenishment quantity into the temporary supply and demand data based on the alternative purchase date, and sends the updated temporary supply and demand data back to the replenishment batch calculation unit 30 as the basis for calculating the purchase date of the next replenishment batch. Through the above data flow and the cyclical cooperation between units, the system can sequentially complete the calculation of the purchase date for each replenishment batch and achieve a batch-by-batch recursive operation mode.

[0044] By employing the above-mentioned technical means, the present invention has the following effects and benefits: First, this invention does not directly modify the original MRP supply and demand data during the calculation of the purchase date, so that the original MRP planning results can be retained as benchmark data, and it is beneficial to compare the impact of the purchase schedule adjustment on inventory, thereby improving the traceability and consistency of the purchase planning.

[0045] Secondly, this invention calculates each replenishment batch in a batch-by-batch manner, and uses the temporary supply and demand data after the completion of the previous replenishment batch as the basis for subsequent calculations. This allows the calculation results on the day of receipt to reflect the mutual influence between batches, avoids inventory fluctuations that may be caused by a one-time adjustment, and improves the stability and repeatability of the calculation results.

[0046] Furthermore, by setting a threshold value and a number of days in advance or a backward rule, the present invention can automatically determine the time point when inventory is insufficient and calculate the alternative purchase date, which can reduce the differences and errors caused by manual judgment, make the adjustment of the purchase date have a consistent judgment benchmark, and improve the reliability of the overall purchase planning.

[0047] In summary, this invention can automatically calculate the batch delivery date through data processing while retaining the original MRP planning architecture, and effectively improves the problems of difficulty in comparing and judging delivery schedule adjustments, inconsistencies in judgment, and susceptibility to human factors in existing methods.

Claims

1. A method for automatically calculating batch delivery dates by integrating MRP supply and demand information, characterized in that, Include: (a) Obtain MRP supply and demand information for at least one part number over a period of time, which includes at least beginning inventory, demand, demand days, replenishment quantity and projected inventory; (b) Select data with replenishment quantities from the MRP supply and demand information according to time order to form a replenishment batch sequence; (c) For a replenishment batch in the replenishment batch sequence, temporarily remove the replenishment quantity of the replenishment batch from the time series corresponding to the MRP supply and demand information, and establish a temporary supply and demand data for estimation purposes only without directly changing the original MRP supply and demand information; (d) Based on the temporary supply and demand data, recalculate the expected inventory to determine whether the expected inventory is lower than a preset threshold at any point in time; (e) When the expected inventory is determined to be below the preset threshold, an alternative purchase date is automatically calculated based on the earliest time point when the state was determined, and according to a preceding number of days, a specified date, or a backtracking rule. as well as (f) The replenishment quantity is included in the temporary supply and demand data according to the alternative purchase date, and based on the temporary supply and demand data after the completion of the previous replenishment batch, steps (a) to (e) of the aforementioned method are repeated sequentially for subsequent replenishment batches to complete the automatic calculation of the batch purchase date.

2. The method for automatically calculating batch delivery dates by integrating MRP supply and demand information according to claim 1, characterized in that, The preset threshold value is set based on safety stock, replenishment quantity, or a combination of both.

3. The method for automatically calculating batch delivery dates by integrating MRP supply and demand information according to claim 1, characterized in that, If the recalculated expected inventory is less than zero at any point in time, it is determined that the replenishment batch needs to be ordered ahead of schedule.

4. The method for automatically calculating batch delivery dates by integrating MRP supply and demand information according to claim 1, characterized in that, If the recalculated expected inventory exceeds the preset threshold at any point in time, it is determined that the replenishment batch can be postponed.

5. The method for automatically calculating batch delivery dates by integrating MRP supply and demand information according to claim 1, characterized in that, The preceding days or specified date are settable values ​​and are used to determine the number of days or the date to be pushed back from the earliest time point to the alternative purchase date.

6. The method for automatically calculating batch delivery dates by integrating MRP supply and demand information according to claim 1, characterized in that, The estimated arrival date for each replenishment batch is calculated sequentially according to time, and the calculation for the next replenishment batch is based on the temporary supply and demand data after the completion of the previous replenishment batch.

7. A batch delivery date automatic calculation system integrating MRP supply and demand information, characterized in that, Include: A data acquisition unit is used to acquire MRP supply and demand information for at least one part number over a period of time, wherein the MRP supply and demand information includes at least the demand quantity and the corresponding demand day; A temporary supply and demand data establishment unit is used to establish temporary supply and demand data for calculation purposes only based on the MRP supply and demand information without directly changing the original MRP supply and demand information. A replenishment batch calculation unit is used to process each replenishment batch in chronological order, and to perform temporary removal of replenishment quantity, recalculation of expected inventory, judgment of the time point when expected inventory is lower than the preset threshold, and pushback of alternative purchase date for each replenishment batch. as well as An alternative purchase date update unit is used to generate or update the corresponding suggested purchase date information based on the calculation results of the replenishment batch calculation unit, and to include the replenishment quantity in the temporary supply and demand data based on the suggested purchase date information. The aforementioned units are interconnected and work together to execute the automatic calculation method for batch delivery dates in sequence.

8. The batch delivery date automatic calculation system integrating MRP supply and demand information according to claim 7, characterized in that, The replenishment batch estimation unit calculates the replenishment date for the next replenishment batch continuously, based on the temporary supply and demand data after the previous replenishment batch is completed, after the alternative purchase date update unit has completed the inclusion of the replenishment quantity according to the suggested purchase date information.

9. The batch delivery date automatic calculation system integrating MRP supply and demand information according to claim 7, characterized in that, The replenishment batch calculation unit determines the time point of insufficient inventory based on a default threshold value, and the preset threshold value is set based on safety stock, replenishment batch, or a combination thereof.

10. The batch delivery date automatic calculation system integrating MRP supply and demand information according to claim 7, characterized in that, The replenishment batch calculation unit automatically calculates the corresponding alternative purchase date based on a settable lead time or backtracking rule and the determined time of insufficient inventory.

Images