Invention content
The purpose of the present invention is overcoming the disadvantages of the prior art mentioned above, the prediction of client is embodied in systems and can be inquiredHistorical forecast record realizes that sales forecast is eaten up part of, and is operated outside reduction system, expansion sales forecast material data, and location requirement existsRaw material rank, filtering prohibit standby material data, improve demand accuracy, reduction material data is dull, and providing one kind canTo the automations of the data of electronics industry, intelligent management to realize that hybrid predicting is converted to raw material based on computer software pre-The system and method for survey.
In order to achieve the above purpose, of the invention to realize that hybrid predicting is converted to raw material prediction based on computer softwareSystem and method it is specific as follows：
This realizes the system that hybrid predicting is converted to raw material prediction based on computer software, is mainly characterized by, includingMemory module eats up part of module, conversion module and control module, and the memory module, eat up part of module and conversion module withControl module is connected, and the memory module, for storing hybrid predicting, the write-downs module is ordered for realizing saleWrite-downs between list and hybrid predicting, the conversion module are used to the hybrid predicting of acquisition being converted to raw material prediction, instituteThe control module stated is used to control the memory module, eats up part of module and conversion module.
Preferably, the hybrid predicting includes that BOM grades of predictions, the prediction of specific raw materials grade and general raw material grade are pre-It surveys, and
The BOM grades prediction includes the prediction of the electrical material of rank and packaging material material under finished product prediction and finished product BOMPrediction；
The specific raw materials grade prediction includes the prediction for the core starting materials that finished product uses；
The general raw material grade prediction includes the prediction of the raw material and self-control material of friendship phase length.
More preferably, the write-downs module includes that normal unit, difference write-downs unit, the special source materials grade eaten up part of predicts punchingSubtract unit and general raw material grade forecast netting unit, wherein
The normal write-downs unit is used for according to sales order and hybrid predicting, by client and the identical rule of BOM item numbersThen, sales order and hybrid predicting are eaten up part of；
The difference is eaten up part of unit and is used for according to sales order and hybrid predicting, and, BOM item number identical by client differsRule, or differed with the client of hybrid predicting by sales order, the identical rule of BOM item numbers, to sales order and mixedPrediction is closed to be eaten up part of；
The special source materials grade forecast netting unit is used for according to sales order and hybrid predicting, by client and external memberThe identical rule of item number eats up part of the specific raw materials of rank under the external member and external member in sales order, and it is pre- to record mixingThe specific raw materials of rank under corresponding external member and external member are surveyed by write-downs quantity；
And by sales order rule identical with the item number of the client of hybrid predicting and specific raw materials, to sales orderIn specific raw materials eaten up part of, and record the corresponding specific raw materials of hybrid predicting by write-downs quantity；
And the rule identical as the external member item number of hybrid predicting by sales order, client is different, in sales orderThe specific raw materials of rank are eaten up part of under external member and external member, and record the specific original of rank under the corresponding external member of hybrid predicting and external memberMaterial is by write-downs quantity；
And by sales order rule identical with the item number of the specific raw materials of hybrid predicting, to the spy in sales orderDetermine raw material to be eaten up part of, and records the corresponding specific raw materials of hybrid predicting by write-downs quantity；
The general raw material grade forecast netting unit is used for according to sales order and hybrid predicting, by client it is identical withAnd the identical rule of client of general raw material grade prediction, the raw material of sales order are eaten up part of, and the general originalWhen material of the material grade forecast netting unit in hybrid predicting is present in the main replacement material of sales order, to sales orderOne group of main replacement material is eaten up part of, and records the raw material of hybrid predicting by write-downs quantity；
And by sales order rule identical with the general raw material of hybrid predicting, to the raw material in sales order intoRow is eaten up part of, and material data of the general raw material grade forecast netting unit in hybrid predicting is present in sales orderWhen in main replacement material, one group of main replacements in sales order is expected to eat up part of, and the raw material for recording hybrid predicting are rushedSubtrahend amount.
Preferably, the conversion module includes allocation unit and converting unit, wherein the allocation unit is used forThe distribution of raw material, and the sequence of allocation unit time according to demand are carried out, the data of hybrid predicting are allocated,Or the main substitutional relation according to raw material in hybrid predicting, the data of hybrid predicting are allocated, the converting unit is usedIt is predicted in hybrid predicting write-downs result is converted into raw material.
Preferably, the control module includes raw material priority judging unit, for according to preset originalRaw material are ranked up by the height of procurement price, determine the priority of raw material by material priority computation rule.
This realizes that hybrid predicting is converted to the method that raw material are predicted using above system based on computer software, mainFeature is that the method includes the following steps：
(1) hybrid predicting is eaten up part of using write-downs module, obtains forecast netting result；
(2) it uses conversion module that the forecast netting result obtained in step (1) is converted into raw material to predict.
Preferably, including the following steps in the step (1)：
(1.1) hybrid predicting is normally eaten up part of using normal unit of eating up part of；
(1.2) the write-downs result after using difference to eat up part of the normal write-downs that unit exports step (1.1) carries out difference punchingSubtract；
(1.3) special source materials grade forecast netting unit is used, the write-downs knot after being eaten up part of to the difference of step (1.2) outputFruit carries out special source materials grade forecast netting；And unit is eaten up part of using general raw material, the difference of step (1.2) output is rushedWrite-downs result after subtracting carries out general raw material grade forecast netting.
More preferably, the step (1.1) includes the following steps：
Item number in sales order in hybrid predicting is deployed into raw material rank by (1.1.1), and record PCBA BOM,The main replacement item number of packaging material BOM, external member item number, raw material and correspondence；
(1.1.2) is homogeneous by sales order and the client of both hybrid predictings and BOM item numbers using normal write-downs unitTogether or the rule of the client and raw material all same of both sales order and hybrid predicting, to the BOM item numbers on hybrid predictingQuantity eaten up part of, and record the corresponding BOM item numbers of sales order by write-downs quantity and raw material by write-downs quantity；
(1.1.3) eats up part of unit using normal, according to the date that needs in hybrid predicting, the sequencing on date on demandThe plan row of stock in advance that the sales order or the same day created to the same day in hybrid predicting creates is eaten up part of.
More preferably, the step (1.2) includes the following steps：
(1.2.1) eats up part of unit using difference, and step (1.1) is not completed to the corresponding material number of sales order eaten up part of afterwardsAmount is eaten up part of with remaining hybrid predicting after step (1.1), including BOM grades of item numbers are eaten up part of, external member item number is eaten up part of and former materialMaterial is eaten up part of；
(1.2.2) eats up part of unit using difference, and, BOM item number identical as the client of both hybrid predictings by sales order is notSame rule is eaten up part of, and the BOM grades item number in sales order, raw material quantity are gone to the corresponding BOM for eating up part of hybrid predictingGrade item number, raw material quantity, and the corresponding BOM item numbers of sales order are recorded by write-downs quantity and raw material by write-downs quantity；
(1.2.3) eats up part of unit, the client identical as the BOM of both hybrid predictings grade item numbers by sales order using differenceDifferent rules, in sales order BOM grade item number quantity and raw material quantity eat up part of, and record sales order correspondenceBOM grade item numbers eat up part of quantity by write-downs quantity and raw material.
More preferably, step (1.2) is exported using special source materials grade forecast netting unit in the step (1.3)Write-downs result progress special source materials grade forecast netting after difference is eaten up part of includes the following steps：
(1.3.a.1) is not completed after eating up part of step (1.2) in the corresponding material of sales order eaten up part of and step (1.2)It eats up part of remaining prediction to be eaten up part of, including BOM grades of item numbers are eaten up part of, external member item number is eaten up part of and raw material are eaten up part of；
(1.3.a.2) identical as the client of hybrid predicting, sales order and hybrid predicting external member item number by sales orderIdentical rule eats up part of the material quantity of rank under the external member quantity and external member in sales order, and records hybrid predictingIn external member by write-downs quantity；
(1.3.a.3) identical as the client of hybrid predicting, sales order and hybrid predicting specific former material by sales orderThe identical rule of item number of material, eats up part of the specific raw materials material quantity in sales order, and record hybrid predicting pairThe item number for the specific raw materials answered is by write-downs quantity；
(1.3.a.4) identical as the external member item number of hybrid predicting, sales order and hybrid predicting client by sales orderDifferent rules eats up part of the specific raw materials quantity of rank under the external member quantity and external member in sales order, and records mixedThe specific raw materials for predicting rank under corresponding external member and external member are closed by write-downs quantity；
(1.3.a.5) presses sales order rule identical with the item number of the specific raw materials of hybrid predicting, to sales orderIn the quantity of specific raw materials material data eaten up part of, and the item number for recording the corresponding specific raw materials of hybrid predicting is rushedSubtrahend amount.
More preferably, unit is eaten up part of using general raw material in the step (1.3) to rush the difference that step (1.2) exportsWrite-downs result after subtracting carries out general raw material grade forecast netting and includes the following steps：
(1.3.b.1) identical as the client of hybrid predicting, sales order and hybrid predicting general former material by sales orderExpect identical rule, the raw material quantity in sales order is eaten up part of, as long as and the material data presence sale in predictionIn main replacement material in order, then one group of main replacement material quantity in sales order is eaten up part of, and record the original in hybrid predictingMaterial is by write-downs quantity；
(1.3.b.2) presses sales order rule identical with the general raw material of hybrid predicting, to the original in sales orderMaterial quantity is eaten up part of, if the material data in hybrid predicting is present in the main replacement material in sales order, to saleOne group in the order main quantity for substituting material is eaten up part of, and record raw material in hybrid predicting by write-downs quantity.
Preferably, including the following steps in the step (2)：
(2.1) allocation unit is used to be allocated the forecast netting result obtained in step (1)；
(2.2) the forecast netting result distributed raw material are converted to using converting unit to predict.
More preferably, the step (2.1) is specially：
By the raw material grade material data in remaining hybrid predicting, according to the required time of raw material in hybrid predicting withAnd the supply and demand surplus quantity of raw material is allocated, and is predicted the quantity required of each raw material.
Realize that hybrid predicting is converted to the system and method for raw material prediction based on computer software using this kind, it can beThe hybrid predicting of client is successfully converted into the prediction of intra-company raw material, so as to company predicted according to raw material it is wholeReason and raw material prediction directly participate in the operation of material data plan of needs, to realize automation, the intelligence of client's hybrid predictingEnergyization manages.
Specific implementation mode
In order to be more clearly understood that the technology contents of the present invention, spy are lifted following embodiment and are described in detail.
This based on computer software realize hybrid predicting be converted to raw material prediction system, including memory module,Eat up part of module, conversion module and control module, and the memory module, eat up part of module and conversion module with control module phaseConnection, and the memory module, for storing hybrid predicting, the write-downs module is for realizing sales order and mixes in advanceWrite-downs between survey, the conversion module are used to the hybrid predicting of acquisition being converted to raw material prediction, the control mouldBlock is used to control the memory module, eats up part of module and conversion module.
In a kind of preferred embodiment, the hybrid predicting includes BOM grades of predictions, the prediction of specific raw materials grade and leads toIt is predicted with raw material grade, and
The BOM grades prediction includes the prediction of the electrical material of rank and packaging material material under finished product prediction and finished product BOMPrediction；
The specific raw materials grade prediction includes the prediction for the core starting materials that finished product uses；
The general raw material grade prediction includes the prediction of the raw material and self-control material of friendship phase length.
In a kind of more preferably embodiment, the write-downs module include it is normal eat up part of unit, difference eats up part of unit, specialRaw material grade forecast netting unit and general raw material grade forecast netting unit, wherein
The normal write-downs unit is used for according to sales order and hybrid predicting, by client and the identical rule of BOM item numbersThen, sales order and hybrid predicting are eaten up part of；
The difference is eaten up part of unit and is used for according to sales order and hybrid predicting, and, BOM item number identical by client differsRule, or differed with the client of hybrid predicting by sales order, the identical rule of BOM item numbers, to sales order and mixedPrediction is closed to be eaten up part of；
The special source materials grade forecast netting unit is used for according to sales order and hybrid predicting, by client and external memberThe identical rule of item number eats up part of the specific raw materials of rank under the external member and external member in sales order, and it is pre- to record mixingThe specific raw materials of rank under corresponding external member and external member are surveyed by write-downs quantity；
And by sales order rule identical with the item number of the client of hybrid predicting and specific raw materials, to sales orderIn specific raw materials eaten up part of, and record the corresponding specific raw materials of hybrid predicting by write-downs quantity；
And the rule identical as the external member item number of hybrid predicting by sales order, client is different, in sales orderThe specific raw materials of rank are eaten up part of under external member and external member, and record the specific original of rank under the corresponding external member of hybrid predicting and external memberMaterial is by write-downs quantity；
And by sales order rule identical with the item number of the specific raw materials of hybrid predicting, to the spy in sales orderDetermine raw material to be eaten up part of, and records the corresponding specific raw materials of hybrid predicting by write-downs quantity；
The general raw material grade forecast netting unit is used for according to sales order and hybrid predicting, by client it is identical withAnd the identical rule of client of general raw material grade prediction, the raw material of sales order are eaten up part of, and the general originalWhen material of the material grade forecast netting unit in hybrid predicting is present in the main replacement material of sales order, to sales orderOne group of main replacement material is eaten up part of, and records the raw material of hybrid predicting by write-downs quantity；
And by sales order rule identical with the general raw material of hybrid predicting, to the raw material in sales order intoRow is eaten up part of, and material data of the general raw material grade forecast netting unit in hybrid predicting is present in sales orderWhen in main replacement material, one group of main replacements in sales order is expected to eat up part of, and the raw material for recording hybrid predicting are rushedSubtrahend amount.
In a kind of preferred embodiment, the conversion module includes allocation unit and converting unit, wherein describedAllocation unit be used to carry out the distribution of raw material, and the sequence of allocation unit time according to demand, to hybrid predictingData be allocated, or according to the main substitutional relation of raw material in hybrid predicting, the data of hybrid predicting are allocated, instituteThe converting unit stated is used to hybrid predicting write-downs result being converted into raw material prediction.
In a kind of preferred embodiment, the control module includes raw material priority judging unit, is used for rootAccording to preset raw material priority computation rule, raw material are ranked up by the height of procurement price, determine raw materialPriority.
Realize that hybrid predicting is converted to the method that raw material are predicted based on computer software using the above system of the present invention,Method described therein includes following steps：
(1) hybrid predicting is eaten up part of using write-downs module, obtains forecast netting result；
(2) it uses conversion module that the forecast netting result obtained in step (1) is converted into raw material to predict.
In a kind of preferred embodiment, the step includes the following steps in (1)：
(1.1) hybrid predicting is normally eaten up part of using normal unit of eating up part of；
(1.2) the write-downs result after using difference to eat up part of the normal write-downs that unit exports step (1.1) carries out difference punchingSubtract；
(1.3) special source materials grade forecast netting unit is used, the write-downs knot after being eaten up part of to the difference of step (1.2) outputFruit carries out special source materials grade forecast netting；And unit is eaten up part of using general raw material, the difference of step (1.2) output is rushedWrite-downs result after subtracting carries out general raw material grade forecast netting.
In a kind of more preferably embodiment, the step (1.1) includes the following steps：
Item number in sales order in hybrid predicting is deployed into raw material rank by (1.1.1), and record PCBA BOM,The main replacement item number of packaging material BOM, external member item number, raw material and correspondence；
(1.1.2) is homogeneous by sales order and the client of both hybrid predictings and BOM item numbers using normal write-downs unitTogether or the rule of the client and raw material all same of both sales order and hybrid predicting, to the BOM item numbers on hybrid predictingQuantity eaten up part of, and record the corresponding BOM item numbers of sales order by write-downs quantity and raw material by write-downs quantity；
(1.1.3) eats up part of unit using normal, according to the date that needs in hybrid predicting, the sequencing on date on demandThe plan row of stock in advance that the sales order or the same day created to the same day in hybrid predicting creates is eaten up part of.
In a kind of more preferably embodiment, the step (1.2) includes the following steps：
(1.2.1) eats up part of unit using difference, and step (1.1) is not completed to the corresponding material number of sales order eaten up part of afterwardsAmount is eaten up part of with remaining hybrid predicting after step (1.1), including BOM grades of item numbers are eaten up part of, external member item number is eaten up part of and former materialMaterial is eaten up part of；
(1.2.2) eats up part of unit using difference, and, BOM item number identical as the client of both hybrid predictings by sales order is notSame rule is eaten up part of, and the BOM grades item number in sales order, raw material quantity are gone to the corresponding BOM for eating up part of hybrid predictingGrade item number, raw material quantity, and the corresponding BOM item numbers of sales order are recorded by write-downs quantity and raw material by write-downs quantity；
(1.2.3) eats up part of unit, the client identical as the BOM of both hybrid predictings grade item numbers by sales order using differenceDifferent rules, in sales order BOM grade item number quantity and raw material quantity eat up part of, and record sales order correspondenceBOM grade item numbers eat up part of quantity by write-downs quantity and raw material.
In a kind of more preferably embodiment, special source materials grade forecast netting unit pair is used in the step (1.3)Write-downs result progress special source materials grade forecast netting after the difference of step (1.2) output is eaten up part of includes the following steps：
(1.3.a.1) is not completed after eating up part of step (1.2) in the corresponding material of sales order eaten up part of and step (1.2)It eats up part of remaining prediction to be eaten up part of, including BOM grades of item numbers are eaten up part of, external member item number is eaten up part of and raw material are eaten up part of；
(1.3.a.2) identical as the client of hybrid predicting, sales order and hybrid predicting external member item number by sales orderIdentical rule eats up part of the material quantity of rank under the external member quantity and external member in sales order, and records hybrid predictingIn external member by write-downs quantity；
(1.3.a.3) identical as the client of hybrid predicting, sales order and hybrid predicting specific former material by sales orderThe identical rule of item number of material, eats up part of the specific raw materials material quantity in sales order, and record hybrid predicting pairThe item number for the specific raw materials answered is by write-downs quantity；
(1.3.a.4) identical as the external member item number of hybrid predicting, sales order and hybrid predicting client by sales orderDifferent rules eats up part of the specific raw materials quantity of rank under the external member quantity and external member in sales order, and records mixedThe specific raw materials for predicting rank under corresponding external member and external member are closed by write-downs quantity；
(1.3.a.5) presses sales order rule identical with the item number of the specific raw materials of hybrid predicting, to sales orderIn the quantity of specific raw materials material data eaten up part of, and the item number for recording the corresponding specific raw materials of hybrid predicting is rushedSubtrahend amount.
In a kind of more preferably embodiment, unit is eaten up part of to step using general raw material in the step (1.3)(1.2) the write-downs result after the difference exported is eaten up part of carries out general raw material grade forecast netting and includes the following steps：
(1.3.b.1) identical as the client of hybrid predicting, sales order and hybrid predicting general former material by sales orderExpect identical rule, the raw material quantity in sales order is eaten up part of, as long as and the material data presence sale in predictionIn main replacement material in order, then one group of main replacement material quantity in sales order is eaten up part of, and record the original in hybrid predictingMaterial is by write-downs quantity；
(1.3.b.2) presses sales order rule identical with the general raw material of hybrid predicting, to the original in sales orderMaterial quantity is eaten up part of, if the material data in hybrid predicting is present in the main replacement material in sales order, to saleOne group in the order main quantity for substituting material is eaten up part of, and record raw material in hybrid predicting by write-downs quantity.
In a kind of preferred embodiment, the step includes the following steps in (2)：
(2.1) allocation unit is used to be allocated the forecast netting result obtained in step (1)；
(2.2) the forecast netting result distributed raw material are converted to using converting unit to predict.
In a kind of more preferably embodiment, the step (2.1) is specially：
By the raw material grade material data in remaining hybrid predicting, according to the required time of raw material in hybrid predicting withAnd the supply and demand surplus quantity of raw material is allocated, and is predicted the quantity required of each raw material.
In a specific embodiment, the main distribution principle for substituting material can be come by the height of material data priorityTake into account that row major distributes.The height of material data priority is determined that the cost price the low excellent by the procurement price of material dataFirst grade is higher, it is also contemplated that the procurement cycle of material data, whether material data limits the factors such as purchase.
In a particular embodiment, the finished product that BOM grades of prediction management module storage clients send over is predicted and by finished product exhibitionOpen BOM and lower rank there are the BOM of BOM structures grade material forecasts.Referring to Fig. 2, in a particular embodiment, prediction circle of systemIt include following key message on face：Client, current quantity, original amount, eats up part of quantity, Date Required, shape at material dataState prohibits standby material data, prohibits standby LT, company model and article NO.
The item number in sales order in hybrid predicting is deployed into raw material rank, and pair predicted is needed in raw material rankAs including PCBA BOM and packaging material BOM.And special source materials grade predict, then include be unfolded by BOM structures by finished product it is specificThe prediction of raw material material.And due to master chip prediction BOM item numbers not out before with regard to stocking up,It needs master chip is separately provided and be predicted, realization is stocked up in advance, belongs to one kind of specific raw materials, can also input other spiesFixed raw material.
The described general raw material grade prediction due to needing there is no BOM or special circumstances for some, need typing someThe prediction of general raw material includes prediction (such as client, material number of the general raw material rank being derived by client's finished productAccording to, current quantity, original amount, eat up part of quantity, Date Required, state, type of prediction, company model and article NO).It is generalRaw material data predicts that object includes raw material.
The predictive maintenance and change points for attention of three types：
(1) it requires typing to predict and daily shows；
(2) it if necessary to modification prediction result, needs to fail original prediction, increases prediction newly；
(3) when sales order is cancelled or quantity increases the influences such as reduction prediction, after system does not handle the write-downs of this partPrediction, needs to manually adjust prediction result；
(4) inventory organization of the prediction of different company under each company safeguards predictive content respectively.
Above-mentioned several forecast netting results are converted to the prediction of raw material rank by the conversion module, and according to former materialThe priority orders of material subtract the size of quantity required and are allocated processing in conjunction with the supply of raw material.For forecast netting knotFruit, conversion module on demand distributed in order by chronological order, and the first distribution of required time morning, and prediction is rushedSubtract the raw material in result, if there is main substitutional relation then using main one group substituted in material as quantity required, by main replacementIn material material preference score carry out from high to low search material supply and demand surplus data be allocated, until forecast netting resultIn quantity required be assigned, if forecast demand be more than main replacements material supply and demand surplus summation, remaining unappropriated needQuantity is asked all to distribute on the high material of material priority level.(allocation example is as follows：)
When finished product is main chip, the prediction of master chip includes as follows：Client, material data, current quantity, original numberAmount eats up part of quantity, Date Required, state, type of prediction, company model and article NO.The prediction object of master chip includes corePiece external member and master chip item number.
Please refer to Fig.1 to Fig.3, in a particular embodiment, by hybrid predicting be converted to raw material prediction method include withLower step：
(1) the normal write-downs of BOM grades of predictions is carried out；
(2) difference write-downs is carried out；
(3) specific raw materials grade forecast netting and general raw material grade forecast netting are carried out；
(4) expansion of forecast netting result and distribution are carried out；
(5) prediction of raw material grade is carried out to generate.
Wherein, the normal write-downs of the BOM grades prediction in step (1) is a kind of automatic write-downs, is by setting control moduleIn the program that sets carry out automatically, and eat up part of frequency and be generally arranged at once a day.Due to containing future in predictionSales order amount in order to avoid Data duplication needs sales order and prediction to be eaten up part of, but because on sales orderItem number and the item number of prediction are inconsistent, so the normal write-downs of BOM grades of predictions is needed, the specific steps are：
(1.1) material data being unfolded in BOM grades of predictions to raw material rank and filters the standby material data of taboo, filteringRule is as follows：
When one group of main minimum procurement cycle value substituted in expecting is more than taboo standby procurement cycle in BOM grades of predictions, then this group is ledPrediction need not all be shown by substituting material, as long as and the standby material data of taboo is contained in every group of main replacements material of expansion, this organizes main replacesFor generation material there is no need to show prediction, raw material, which are master chip material data and master chip external member, need not then show prediction；
(1.2) item number on sales order is unfolded to raw material rank, and records PCBA BOM, packaging material BOM, external member materialNumber, the main replacement item number of raw material and correspondence；
(1.3) it presses " client+BOM " or " client+raw material " and eats up part of the BOM item number quantity on predicting, and record saleThe corresponding BOM of order, raw material are by write-downs quantity；
(1.4) same day create sales order or the same day create the plan of stock in advance row by prediction need the date fromIt is eaten up part of after going to.
Step (2) is dull for reducing material data, is as follows：
(2.1) step (1) is not completed to the corresponding material of sales order eaten up part of afterwards to mix in advance with remaining after step (1)Survey is eaten up part of, including BOM is eaten up part of, external member item number is eaten up part of and raw material are eaten up part of；
(2.2) rule that client is identical, sales order is different from the BOM item numbers of hybrid predicting is pressed, it will be on sales orderBOM item numbers, raw material go to eat up part of corresponding BOM item numbers on hybrid predicting, raw material quantity, and it is corresponding to record sales orderBOM item numbers are by write-downs quantity and raw material by write-downs quantity, wherein the write-downs of BOM item numbers is to select by hand, is directly carried outDifference is eaten up part of, as long as and in the main replacement material of the major ingredient presence prediction of sales order, then when raw material are eaten up part of, eating up part of the master of predictionSubstitute material quantity；
(2.3) rule that BOM item numbers are identical, client is different is pressed, BOM item numbers quantity and raw material on hybrid predicting are eaten up part ofQuantity, and record sales order corresponding BOM item numbers and quantity is eaten up part of by write-downs quantity and raw material；
In a particular embodiment, the sequence during which eats up part of is determined according to manually choosing, and the frequency that difference is eaten up part ofIt is usually also disposed at once a day.
After completing step (2), due to the particularity of raw material, it is also necessary to it is further eaten up part of, i.e. step (3), it shouldInclude step in detail below in step (3)：
A. specific raw materials write-downs is carried out, is included the following steps：
(3.a.1) the corresponding material of sales order eaten up part of will not be completed in step (2) and write-downs in step (2) is remainingHybrid predicting is eaten up part of, including BOM item numbers are eaten up part of, external member item number is eaten up part of and raw material are eaten up part of；
(3.a.2) presses " client+external member item number " identical rule, to rank under the external member quantity and external member in sales orderMaterial quantity is eaten up part of, and records the external member in hybrid predicting by write-downs quantity；
(3.a.3) presses " item numbers of client+specific raw materials " identical rule, to eating up part of the specific former material in sales orderThe quantity of material material data is eaten up part of, and records the item number of the corresponding specific raw materials of hybrid predicting by write-downs quantity；
(3.a.4) presses the rule that external member item number is identical, client is different, to rank under the external member quantity and external member in sales orderSpecific raw materials quantity eaten up part of, and the specific raw materials for recording rank under the corresponding external member of hybrid predicting and external member are eaten up part ofQuantity；
(3.a.5) presses " item numbers of specific raw materials " identical rule, to the specific raw materials material number in sales orderAccording to quantity eaten up part of, and record the item number of the corresponding specific raw materials of hybrid predicting by write-downs quantity.
B. general raw material forecast netting is carried out, is included the following steps：
(3.b.1) presses " client+general raw material " identical rule, is rushed to the raw material quantity on sales orderSubtract, as long as and the material in hybrid predicting then one group of master on sales order is replaced there are in the main replacement material on sales orderGeneration material quantity is eaten up part of, and records the raw material in hybrid predicting by write-downs quantity；
(3.b.2) presses " general raw material " identical rule, is eaten up part of to the raw material quantity on sales order, as long asMaterial data in hybrid predicting then expects number there are in the main replacement material on sales order to one group of main replacement on sales orderAmount is eaten up part of, and the raw material in hybrid recording prediction are by write-downs quantity.
Specific raw materials are eaten up part of and general raw material forecast netting is all that operation request carries out, and eats up part of frequency generally alsoIt is set as once a day.
Remaining predicted material data row after write-downs is unfolded step (4) by BOM grades, is deployed into raw material rank,Main replacement material is required for showing.Allocation rule in step (4) is as follows：
(4.1) by the raw material grade material data in hybrid predicting, according to the required time sequencing of prediction raw material,In conjunction with the supply and demand surplus quantity of raw material, it is allocated, the quantity required of each raw material is predicted；
(4.2) row major point can be taken into account by the height of material data priority for the main distribution principle for substituting materialMatch；
(4.3) height of material data priority mainly considers that the procurement price of material data, cost price are lower preferentialGrade is higher, it is also contemplated that the procurement cycle of material data, whether material data limits the factors such as purchase.
Above-mentioned distribution is also to be distributed automatically according to the request that program is run.
In step (5), since the sales forecast that client provides is BOM grades of predictions, needs after eating up part of sales forecast and divideThe raw material prediction prepared imported into the prediction of raw material grade, the final demand source as last plan operation.Raw material grade is pre-It includes material data, current quantity, original amount, original amount and remarks to survey, and the prediction of different company is under each companyInventory organization safeguards predictive content respectively.
And raw material prediction object can only be raw material, it is not possible to be other kinds of material data.Raw material grade is predictedIt safeguards and change points for attention is：The prediction of raw material rank need not merge before importing, the prediction of raw material rankIt need not be merged before importing.
Realize that hybrid predicting is converted to the system and method for raw material prediction based on computer software using this kind, it can beThe hybrid predicting of client is successfully converted into intra-company's raw material prediction, so that company carries out hybrid predicting according to raw materialArrangement and raw material prediction directly participation material data plan of needs operation, to realize the automatic of client's hybrid predictingChange, intelligent management.
In this description, the present invention is described with reference to its specific embodiment.But it is clear that can still makeVarious modifications and alterations are without departing from the spirit and scope of the invention.Therefore, the description and the appended drawings should be considered as illustrativeAnd not restrictive.