CN104484716A - Reserve quota prediction algorithm of ERP (Enterprise Resource Planning) system - Google Patents
Reserve quota prediction algorithm of ERP (Enterprise Resource Planning) system Download PDFInfo
- Publication number
- CN104484716A CN104484716A CN201410740910.3A CN201410740910A CN104484716A CN 104484716 A CN104484716 A CN 104484716A CN 201410740910 A CN201410740910 A CN 201410740910A CN 104484716 A CN104484716 A CN 104484716A
- Authority
- CN
- China
- Prior art keywords
- reserve
- norm
- enterprise
- erp
- formula
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Quality & Reliability (AREA)
- Biodiversity & Conservation Biology (AREA)
- Game Theory and Decision Science (AREA)
- Life Sciences & Earth Sciences (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Educational Administration (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a reserve quota prediction algorithm of an ERP (Enterprise Resource Planning) system. The method comprises the following steps: firstly collecting delivery quantity and purchasing cycle in last three years of an enterprise; then calculating a predicted value of a material reserve quota according to a formula N=M*T*a+B; finally making a material reserve quota summary sheet by the enterprise according to the predicted value N of the material reserve quota. According to the algorithm, the combination with an enterprise information system is realized, the automation of data extraction and reserve quota calculation is realized, more workers are not required, and the burden of the enterprise workers is relieved.
Description
Technical field
The present invention relates to ERP system field, specifically a kind of reserve norm prediction algorithm of ERP system.
Background technology
ERP system refers to and is based upon on Information Technology Foundation, with systematized management thought, for business decision layer and employee provide decision-making to run the management platform of means.Reserve supply quota, refers under certain management condition, enterprise ensures to produce to carry out reserve supply quantitative criteria that is necessary, economical rationality smoothly.So rationally infer the goods and materials rational inventory amount in enterprise's future, both met enterprise and produced and maintenance of equipment needs, and do not overstock again spare part fund, shorten reservation period.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of reserve norm prediction algorithm of ERP system, realizes the combination with Enterprise Informatization system, realizing data and extracts the robotization determining quota calculation with storage, without the need to dropping into more personnel, alleviating the burden of enterprise staff.
Technical scheme of the present invention is:
The reserve norm prediction algorithm of ERP system, is characterized in that: comprise the following steps:
(1), enterprise's history outbound amount of 3 years and procurement cycle is collected;
(2) predicted value, calculating the norm of material reserve formulates the reference of reserve supply quota as enterprise; The calculating of the predicted value N of the norm of material reserve is shown in shown in formula (1):
N＝Q*a+B (1)；
Wherein, a is correction factor, and B is insurance store quota, and Q is frequent reserve norm, and it is obtained by formula (2):
Q＝M*T (2)；
Wherein, M is order average consumption, and T is procurement cycle;
Bring formula (2) into formula (1) and obtain formula (3):
N＝M*T*a+B (3)；
(3), enterprise formulates norm of material reserve summary sheet according to the predicted value N of reserve supply quota.
Described average daily consumed amt M equals ERP statistics phase outbound amount and obtains divided by statistics phase number of days; Described procurement cycle T equal ERP receive the date deduct procurement request date created buying number of times obtain; Described correction factor a equals to obtain divided by frequent reserve norm after every annual outbound amount deducts frequent reserve norm again; Described insurance store quota B equals monthly average the highest outbound amount and deducts frequent reserve norm and obtain.
The data of the collection in described step (1) are formulated stock's consumption data and are collected template.
Principle of the present invention:
The materials reserve of enterprise is that frequent reserve norm refers to the maximum quantity that enterprise material is often laid in, quantity when namely normally stocking up constantly in variation.At this moment the whole materials reserve of enterprise reaches highest level, is also called the highest storage level.The basic stock amount of enterprise should not exceed the highest storage level, has exceeded and has just cried surplus inventories.
When enterprise carries out normal production and operating activities, stock progressively consumes, and when stock is depleted to minimum reserve amount, the next group goods and materials arrival that enterprise orders, stock returns to the highest storage level again, so circulates.
When working reserve all throw people use, storage level is in floor level, namely only remaining minimum stock time, be called minimum reserve amount, so minimum reserve amount equals insurance store quota.Minimum stock is not often variation, only just employs when there is unexpected accident, generally upper once stock up after namely supplemented.
Relation between frequent reserve norm, insurance store quota, the highest storage level, minimum reserve amount as shown in Figure 1;
Frequent reserve norm is needs for ensureing regular supply in interval of stocking up for twice and the deposit quantitative criteria specified; Insurance store quota be for the process of guaranteeing supply meet accident accident time can tissue supply and the deposit quantitative criteria specified incessantly.
Advantage of the present invention:
(1), the present invention follows the principle of " determining storage to consume ", which goods and materials enterprise lays in, how many deposits depends on standby redundancy consumption and supply cycle, can dope the goods and materials waste in enterprise's future comparatively accurately;
(2), the present invention according to the test value of the annual norm of material reserve and actual occurrence value gap, regulate enterprise material reserve norm predicted value by correction factor, therefore enterprise use more early, historical data is more, and it is more accurate to predict;
(3), the combination of realization of the present invention and Enterprise Informatization system, realizing data and extract the robotization determining quota calculation with storage, without the need to dropping into more personnel, alleviating the burden of enterprise staff.
Embodiment
The reserve norm prediction algorithm of ERP system, is characterized in that: comprise the following steps:
(1), collect enterprise's history outbound amount of 3 years and procurement cycle, and formulate stock's consumption data collection template, as following table 1;
Table 1
(2) predicted value, calculating the norm of material reserve formulates the reference of reserve supply quota as enterprise; The calculating of the predicted value N of the norm of material reserve is shown in shown in formula (1):
N＝Q*a+B (1)；
Wherein, a is correction factor, correction factor a=(every annual outbound amount-often reserve norm)/often reserve norm, and the initial stage is defaulted as 1;
B is insurance store quota, the highest outbound amount of insurance store quota B=monthly average-often reserve norm;
Q is frequent reserve norm, and it is obtained by formula (2):
Q＝M*T (2)；
Wherein, M is average daily consumed amt, and average daily consumed amt M=ERP adds up phase outbound amount/statistics phase number of days;
T is procurement cycle, procurement cycle T=ERP receive date-procurement request date created buying number of times;
Bring formula (2) into formula (1) and obtain formula (3):
N＝M*T*a+B (3)；
(3), enterprise formulates norm of material reserve summary sheet according to the predicted value N of reserve supply quota, as shown in table 2;
Table 2
Claims (3)
- The reserve norm prediction algorithm of 1.ERP system, is characterized in that: comprise the following steps:(1), enterprise's history outbound amount of 3 years and procurement cycle is collected;(2) predicted value, calculating the norm of material reserve formulates the reference of reserve supply quota as enterprise; The calculating of the predicted value N of the norm of material reserve is shown in shown in formula (1):N＝Q*a+B (1)；Wherein, a is correction factor, and B is insurance store quota, and Q is frequent reserve norm, and it is obtained by formula (2):Q＝M*T (2)；Wherein, M is average daily consumed amt, and T is procurement cycle;Bring formula (2) into formula (1) and obtain formula (3):N＝M*T*a+B (3)；(3), enterprise formulates norm of material reserve summary sheet according to the predicted value N of reserve supply quota.
- 2. the reserve norm prediction algorithm of ERP system according to claim 1, is characterized in that: described average daily consumed amt M equals ERP statistics phase outbound amount and obtains divided by statistics phase number of days; Described procurement cycle T equal ERP receive the date deduct procurement request date created buying number of times obtain; Described correction factor a equals to obtain divided by frequent reserve norm after every annual outbound amount deducts frequent reserve norm again; Described insurance store quota B equals monthly average the highest outbound amount and deducts frequent reserve norm and obtain.
- 3. the reserve norm prediction algorithm of ERP system according to claim 1, is characterized in that: the data of the collection in described step (1) are formulated stock's consumption data and collected template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410740910.3A CN104484716A (en) | 2014-11-27 | 2014-11-27 | Reserve quota prediction algorithm of ERP (Enterprise Resource Planning) system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410740910.3A CN104484716A (en) | 2014-11-27 | 2014-11-27 | Reserve quota prediction algorithm of ERP (Enterprise Resource Planning) system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104484716A true CN104484716A (en) | 2015-04-01 |
Family
ID=52759257
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410740910.3A Pending CN104484716A (en) | 2014-11-27 | 2014-11-27 | Reserve quota prediction algorithm of ERP (Enterprise Resource Planning) system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104484716A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107169641A (en) * | 2017-05-05 | 2017-09-15 | 桐乡智果软件科技有限公司 | A kind of weaving ERP material amounts evolvement method |
| CN107909205A (en) * | 2017-11-15 | 2018-04-13 | 华北电力大学（保定） | A kind of inventory optimization method of the wind power plant spare part based on annual quota |
| CN113592309A (en) * | 2021-08-02 | 2021-11-02 | 上海华能电子商务有限公司 | Multi-level inventory quota making method based on data driving |
| CN117151581A (en) * | 2023-08-04 | 2023-12-01 | 华能澜沧江水电股份有限公司 | Balance library and inventory early warning method, device and equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101320455A (en) * | 2008-06-30 | 2008-12-10 | 西安交通大学 | Spare part demand forecast method based on in-service lift estimation |
| KR20140036563A (en) * | 2012-09-17 | 2014-03-26 | 에스티엑스조선해양 주식회사 | Steel piling management system |
-
2014
- 2014-11-27 CN CN201410740910.3A patent/CN104484716A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101320455A (en) * | 2008-06-30 | 2008-12-10 | 西安交通大学 | Spare part demand forecast method based on in-service lift estimation |
| KR20140036563A (en) * | 2012-09-17 | 2014-03-26 | 에스티엑스조선해양 주식회사 | Steel piling management system |
Non-Patent Citations (5)
| Title |
|---|
| 刘兴国: ""备件储备定额的自动计算和改进模式"", 《2009海峡两岸机械科技论坛论文集》 * |
| 叶昕炯: ""配电网物资储备定额的研究与制订"", 《浙江电力》 * |
| 尹小龙: ""采气一厂物资储备定额管理初探"", 《延安职业技术学院学报》 * |
| 白婧等: ""备件储备定额计算方法在改装库房管理中的应用研究"", 《企业研究》 * |
| 钱文丽: ""浅谈物资储备定额的合理确定"", 《中州煤炭》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107169641A (en) * | 2017-05-05 | 2017-09-15 | 桐乡智果软件科技有限公司 | A kind of weaving ERP material amounts evolvement method |
| CN107169641B (en) * | 2017-05-05 | 2020-08-14 | 桐乡智果软件科技有限公司 | Material usage evolution method for textile ERP |
| CN107909205A (en) * | 2017-11-15 | 2018-04-13 | 华北电力大学（保定） | A kind of inventory optimization method of the wind power plant spare part based on annual quota |
| CN107909205B (en) * | 2017-11-15 | 2021-11-30 | 华北电力大学（保定） | Stock optimization method for wind power plant spare parts based on annual quota |
| CN113592309A (en) * | 2021-08-02 | 2021-11-02 | 上海华能电子商务有限公司 | Multi-level inventory quota making method based on data driving |
| CN113592309B (en) * | 2021-08-02 | 2024-04-30 | 上海华能电子商务有限公司 | Multilevel inventory quota formulation method based on data driving |
| CN117151581A (en) * | 2023-08-04 | 2023-12-01 | 华能澜沧江水电股份有限公司 | Balance library and inventory early warning method, device and equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104217320B (en) | The processing system and processing method of warehouse inventory circulation | |
| Zhou et al. | Inventory management of platelets in hospitals: Optimal inventory policy for perishable products with regular and optional expedited replenishments | |
| Thomas et al. | The costs and benefits of advanced maintenance in manufacturing | |
| Li et al. | Risk-constrained bidding strategy with stochastic unit commitment | |
| Meng et al. | A robust optimization model for managing elective admission in a public hospital | |
| Vegunta et al. | Estimation of cost of downtime of industrial process due to voltage sags | |
| CN104484716A (en) | Reserve quota prediction algorithm of ERP (Enterprise Resource Planning) system | |
| CN106296087A (en) | A kind of Spare Parts Inventory Management System of Facing to Manufacturing industry | |
| CN106651089A (en) | Modeling and optimization method for production scheduling problem distribution set robust model | |
| US20080177599A1 (en) | Method Of Determining Safety Stock Levels | |
| CN102376040A (en) | Decision support system for purchasing portion distribution of enterprise | |
| CN103559594A (en) | Management system and method for having control over procurement plan according to inventory level of spare parts | |
| Campo et al. | Linear programming for aggregate production planning in a textile company | |
| Cheng et al. | Intermittent demand forecasting in a tertiary pediatric intensive care unit | |
| Johnson et al. | Multistage capital budgeting for shared investments | |
| Teoh et al. | Invisibility of impact from customer demand and relations between processes in Overall Equipment Effectiveness (OEE) | |
| Gribik et al. | Dealing with uncertainty in dispatching and pricing in power markets | |
| Chen et al. | Capacity-delivery coordination in supply chains: a cost-based approach | |
| Sosodoro et al. | Designing of Inventory Control for Aluminum Industry | |
| JP2017161960A (en) | Safety stock standard determination device and safety stock standard determination method | |
| CN103559595A (en) | Management system and method for having control over procurement plan according to monthly average consumption of spare parts | |
| JP2017049863A (en) | Gcm in-administration operation integral management technology | |
| Balashov et al. | Improvement of operational management of innovative production processes based on the implementation of MES | |
| JP2016051223A (en) | Lead time-based production overhead cost allocation system and program | |
| JP7031730B2 (en) | Control planning device, control planning method, program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150401 |
|
| WD01 | Invention patent application deemed withdrawn after publication |