CN111461590A - Method for calculating complete set of materials according to sales, inventory and purchase information - Google Patents
Method for calculating complete set of materials according to sales, inventory and purchase information Download PDFInfo
- Publication number
- CN111461590A CN111461590A CN202010136124.8A CN202010136124A CN111461590A CN 111461590 A CN111461590 A CN 111461590A CN 202010136124 A CN202010136124 A CN 202010136124A CN 111461590 A CN111461590 A CN 111461590A
- Authority
- CN
- China
- Prior art keywords
- complete set
- materials
- calculating
- sales
- date
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/0637—Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Manufacturing & Machinery (AREA)
- Game Theory and Decision Science (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for calculating the complete set of materials according to sales, inventory and purchase information, which comprises the following steps: obtaining BOMs of products and semi-finished products, wherein the BOMs are bill of materials; based on the BOM, listing all materials related to the complete set, and calculating the complete set condition; listing the complete set condition of the materials according to the date; and acquiring the integral sleeve aligning condition according to the obtained sleeve aligning result. The invention can fully utilize data sources, not only consider inventory, and calculate the complete set information more accurately, and simultaneously can calculate not only the complete set information of the materials in the same day, but also the complete set information after several days. During display, the material shortage and complete set change conditions of specific documents (sales orders and production task lists) within a period of time can be inquired according to the material list.
Description
Technical Field
The invention relates to the technical field of electronic product production and manufacturing, in particular to a method for calculating the complete set of materials according to sales, inventory and purchase information.
Background
At present, electronic product often the structure is complicated, uses raw and other materials a lot, often need make the semi-manufactured goods earlier during the assembly, and raw and other materials and semi-manufactured goods's source is also diversified, has direct purchase piece, the finished piece of oneself, the outsourcing, every raw and other materials and semi-manufactured goods all need place the order in advance, the complete set time of subassembly, the manufacturing time, the transit time is all different, and possibly change moreover, lead to the product of final production, the complete set time overlength or difficult to predict of its raw and other materials and semi-manufactured goods. The unpredictable complete time can further lead to unpredictable shipment time, lower the reputation of the manufacturer and lower the competitiveness of the manufacturer. Meanwhile, the time for completing the process is too long, so that a large amount of raw materials or semi-finished products are retained in a warehouse and account for liquidity. The method has great negative effects on production on demand, ordering on demand, zero stock and extreme speed change of modern electronic production enterprises.
The data sources for computing the inventory of materials are also complex, including current inventory, sales orders, purchase orders, outsourcing orders, production job orders, and may change at any time.
Therefore, a new technical solution is needed to solve this problem.
Disclosure of Invention
The purpose of the invention is as follows: in order to overcome two problems in the prior art, one problem is that the data source is insufficient, and most of the problems only can consider the current stock condition and production task. But not considering, sales orders (converted into future production task lists), purchase orders (converted into future stocks), outsourcing orders (consumed raw material stocks, converted into future semi-finished product stocks and occupied time), and the second problem is that only the current complete set situation can be calculated, and the future complete set situation cannot be displayed in advance, and the method for calculating the complete set of materials according to the sales, stock and purchase information is provided.
The technical scheme is as follows: in order to achieve the purpose, the invention provides a method for calculating the complete set of materials according to sales, inventory and purchase information, which comprises the following steps:
s1: obtaining BOMs of products and semi-finished products, wherein the BOMs are bill of materials;
s2: based on the BOM, listing all materials related to the complete set, and calculating the complete set condition;
s3: listing the complete set condition of the materials according to the date;
s4: from the nesting results obtained in steps S2 and S3, the overall nesting situation is obtained.
Further, the acquisition mode of the BOM in step S1 is as follows: according to the model batch information of the product to be assembled, an EDA model is exported by a designer, an unstructured EDA file is traversed by calling a secondary development interface program of the EDA, circuit boards in the structural topology information of the EDA file and the attributes and the number of used components are read in batch, a product BOM is automatically created by the program and stored in a material batch database.
Further, the specific process of step S2 is as follows:
s2-1: calculating and displaying the complete material set condition required in a certain day, listing all production task lists in the day, calculating and summarizing;
s2-2: calculating the complete set condition of a certain production task list, listing the product name, the production quantity and the production date, and calculating and summarizing;
s2-3: calculating the complete set condition of a certain sales order, listing the product name, the sales quantity and the delivery date, and calculating and summarizing;
s2-4: finding out the corresponding BOM according to the products input in the steps S2-2 and S2-3, and expanding the BOM into a list of raw materials and semi-finished products;
s2-5: after the summary, all the required raw materials and the quantity of the semi-finished products and the required dates are listed.
Further, the specific process of step S3 is as follows: all entries of the materials are listed in order of date from the date on which the calculation is made, all exits of the materials are listed in order of date, and the exits on the same date are sorted in order of priority.
Has the advantages that: compared with the prior art, the invention has the following advantages:
1. the data source can be fully utilized, and the complete set information can be calculated more accurately instead of only considering the inventory. Meanwhile, the complete set information of the materials on the same day can be calculated, and the complete set information after several days can also be calculated. During display, the material shortage and complete set change conditions of specific documents (sales orders and production task lists) within a period of time can be inquired according to the material list.
2. The information of the complete set of materials in the production process can be calculated in real time and in advance, and when the materials are short, the materials are prepared in advance, so that the production is not influenced; when a sales order or a purchase order or an outsourcing order changes, timely responding and recalculating; and sufficient information and prompts are provided for sales personnel, purchasing personnel, production management personnel and the like.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention;
FIG. 2 is a schematic view of the case of a complete set shown by materials and dates;
FIG. 3 is a schematic view of the complete set detected by document.
Detailed Description
The present invention is further illustrated by the following figures and specific examples, which are to be understood as illustrative only and not as limiting the scope of the invention, which is to be given the full breadth of the appended claims and any and all equivalent modifications thereof which may occur to those skilled in the art upon reading the present specification.
As shown in FIG. 1, the present invention provides a method for calculating a material complete set according to sales, inventory and purchase information, comprising the following steps:
s1: obtaining BOM of products and semi-finished products:
BOM (Bill of Material) is a bill of materials, namely a file for describing the product structure in a data format, which is a product structure data file that can be identified by a computer and is also a dominant file of ERP;
the acquisition mode of the BOM in the step is as follows: according to model batch information of a product to be assembled, an EDA (electronic design automation) model is exported by a designer, an unstructured EDA file is traversed by calling a secondary development interface program of the EDA through a recursive algorithm, attributes and the number of circuit boards and used components in structural topology information of the EDA file are read in batch, a product BOM is automatically created by the program and stored in a material alignment database.
It should be noted that the product BOM may be manually entered and maintained, or other product BOMs in the ERP system may be used.
S2: based on the BOM, listing all materials (including raw materials and semi-finished products) related to the complete set, and calculating the complete set condition:
s2-1: calculating and displaying the complete material set condition required in a certain day, listing all production task lists in the day, calculating and summarizing;
s2-2: calculating the complete set condition of a certain production task list, listing the product name, the production quantity and the production date, and calculating and summarizing;
s2-3: calculating the complete set condition of a certain sales order, listing the product name, the sales quantity and the delivery date, and calculating and summarizing;
s2-4: finding out the corresponding BOM according to the products input in the steps S2-2 and S2-3, and expanding the BOM into a list of raw materials and semi-finished products;
s2-5: after the summary, all the required raw materials and the quantity of the semi-finished products and the required dates are listed.
S3: listing the complete set of materials according to the date:
and (3) starting from the date of calculation, listing all input items (including inventory and purchase warehousing lists) of the materials in the order of the date, and listing all output items (including sales output lists, existing production material receiving lists, production material receiving predicted according to the production task lists and the sales orders and paying attention to prevent repetition) of the materials in the order of the date. The entries for the same date are sorted by priority.
In this step, the following can be calculated:
material 1 date 1 document 1 complete set
Material 1 date 1 document 2 starved (8 pieces)
Material 1, date 2 and document 2 set
S4: according to the nesting results obtained in the steps S2 and S3, the overall nesting condition of the specific document on the specific date is collected.
S5: and displaying the overall alignment condition.
In step S5 in this embodiment, there are two display schemes, which are as follows:
scheme 1: one or more items are detected, and on a specific date, whether the items are short or not, and all documents can be displayed when the items are short, as shown in fig. 2.
Scheme 2: checking whether the cover is complete according to the receipt, as shown in fig. 3.
Claims (4)
1. A method for calculating the complete set of materials according to sales, inventory and purchase information is characterized in that: the method comprises the following steps:
s1: obtaining BOMs of products and semi-finished products, wherein the BOMs are bill of materials;
s2: based on the BOM, listing all materials related to the complete set, and calculating the complete set condition;
s3: listing the complete set condition of the materials according to the date;
s4: from the nesting results obtained in steps S2 and S3, the overall nesting situation is obtained.
2. The method of claim 1, wherein the method comprises calculating a complete set of materials based on sales, inventory, and procurement information: the acquisition mode of the BOM in step S1 is: according to the model batch information of the product to be assembled, an EDA model is exported by a designer, an unstructured EDA file is traversed by calling a secondary development interface program of the EDA, circuit boards in the structural topology information of the EDA file and the attributes and the number of used components are read in batch, a product BOM is automatically created by the program and stored in a material batch database.
3. The method of claim 1, wherein the method comprises calculating a complete set of materials based on sales, inventory, and procurement information: the specific process of step S2 is as follows:
s2-1: calculating and displaying the complete material set condition required in a certain day, listing all production task lists in the day, calculating and summarizing;
s2-2: calculating the complete set condition of a certain production task list, listing the product name, the production quantity and the production date, and calculating and summarizing;
s2-3: calculating the complete set condition of a certain sales order, listing the product name, the sales quantity and the delivery date, and calculating and summarizing;
s2-4: finding out the corresponding BOM according to the products input in the steps S2-2 and S2-3, and expanding the BOM into a list of raw materials and semi-finished products;
s2-5: after the summary, all the required raw materials and the quantity of the semi-finished products and the required dates are listed.
4. The method of claim 1, wherein the method comprises calculating a complete set of materials based on sales, inventory, and procurement information: the specific process of step S3 is as follows: all entries of the materials are listed in order of date from the date on which the calculation is made, all exits of the materials are listed in order of date, and the exits on the same date are sorted in order of priority.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010136124.8A CN111461590A (en) | 2020-03-02 | 2020-03-02 | Method for calculating complete set of materials according to sales, inventory and purchase information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010136124.8A CN111461590A (en) | 2020-03-02 | 2020-03-02 | Method for calculating complete set of materials according to sales, inventory and purchase information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111461590A true CN111461590A (en) | 2020-07-28 |
Family
ID=71684148
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010136124.8A Pending CN111461590A (en) | 2020-03-02 | 2020-03-02 | Method for calculating complete set of materials according to sales, inventory and purchase information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111461590A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111680850A (en) * | 2020-08-12 | 2020-09-18 | 中兴软件技术(南昌)有限公司 | Load prediction method and system based on iterative algorithm |
| CN113362011A (en) * | 2021-06-30 | 2021-09-07 | 长沙格力暖通制冷设备有限公司 | Method and system for determining complete sets of materials and display terminal |
| CN113469616A (en) * | 2021-06-18 | 2021-10-01 | 筑友智造建设科技集团有限公司 | PC component material alignment management method, device, equipment and storage medium |
| CN113592170A (en) * | 2021-07-26 | 2021-11-02 | 苏州大学文正学院 | APS planning method and system for project type ERP system |
| CN113742908A (en) * | 2021-08-24 | 2021-12-03 | 吉利汽车集团有限公司 | A method for judging material uniformity based on discrete simulation |
| CN114418479A (en) * | 2021-12-20 | 2022-04-29 | 中通服供应链管理有限公司 | Method, equipment and storage medium for communication base station equipment configuration |
| CN114612043A (en) * | 2022-03-25 | 2022-06-10 | 联想(北京)有限公司 | Material consumption method and system and electronic equipment |
| CN115081953A (en) * | 2022-07-30 | 2022-09-20 | 南京维拓科技股份有限公司 | Purchasing method according to production beat |
| CN117095518A (en) * | 2023-08-04 | 2023-11-21 | 杭州杰牌传动科技有限公司 | Material alignment early warning method and device, storage medium and terminal |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101706912A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Sales order BOM-based method for tracking material and calculating material requirements |
| CN103279613A (en) * | 2013-05-30 | 2013-09-04 | 南京航空航天大学 | Automatic matching method for high-precision complex product assembling materials |
| CN107563640A (en) * | 2017-08-31 | 2018-01-09 | 北京博元盛汽车零部件有限公司 | A kind of multi-purpose vehicle(MPV) parts production system |
-
2020
- 2020-03-02 CN CN202010136124.8A patent/CN111461590A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101706912A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Sales order BOM-based method for tracking material and calculating material requirements |
| CN103279613A (en) * | 2013-05-30 | 2013-09-04 | 南京航空航天大学 | Automatic matching method for high-precision complex product assembling materials |
| CN107563640A (en) * | 2017-08-31 | 2018-01-09 | 北京博元盛汽车零部件有限公司 | A kind of multi-purpose vehicle(MPV) parts production system |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111680850A (en) * | 2020-08-12 | 2020-09-18 | 中兴软件技术(南昌)有限公司 | Load prediction method and system based on iterative algorithm |
| CN113469616A (en) * | 2021-06-18 | 2021-10-01 | 筑友智造建设科技集团有限公司 | PC component material alignment management method, device, equipment and storage medium |
| CN113362011A (en) * | 2021-06-30 | 2021-09-07 | 长沙格力暖通制冷设备有限公司 | Method and system for determining complete sets of materials and display terminal |
| CN113592170B (en) * | 2021-07-26 | 2023-08-08 | 苏州大学文正学院 | APS planning method and system for project-oriented ERP system |
| CN113592170A (en) * | 2021-07-26 | 2021-11-02 | 苏州大学文正学院 | APS planning method and system for project type ERP system |
| CN113742908A (en) * | 2021-08-24 | 2021-12-03 | 吉利汽车集团有限公司 | A method for judging material uniformity based on discrete simulation |
| CN113742908B (en) * | 2021-08-24 | 2024-03-15 | 吉利汽车集团有限公司 | A method for judging the complete set of materials based on discrete simulation |
| CN114418479A (en) * | 2021-12-20 | 2022-04-29 | 中通服供应链管理有限公司 | Method, equipment and storage medium for communication base station equipment configuration |
| CN114612043A (en) * | 2022-03-25 | 2022-06-10 | 联想(北京)有限公司 | Material consumption method and system and electronic equipment |
| CN114612043B (en) * | 2022-03-25 | 2025-01-24 | 联想(北京)有限公司 | Material consumption method, system and electronic equipment |
| CN115081953A (en) * | 2022-07-30 | 2022-09-20 | 南京维拓科技股份有限公司 | Purchasing method according to production beat |
| CN115081953B (en) * | 2022-07-30 | 2024-05-24 | 南京维拓科技股份有限公司 | Purchasing method according to production beats |
| CN117095518A (en) * | 2023-08-04 | 2023-11-21 | 杭州杰牌传动科技有限公司 | Material alignment early warning method and device, storage medium and terminal |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111461590A (en) | Method for calculating complete set of materials according to sales, inventory and purchase information | |
| Giri et al. | Developing a closed-loop supply chain model with price and quality dependent demand and learning in production in a stochastic environment | |
| Junior et al. | Production planning and control for remanufacturing: literature review and analysis | |
| Kurbel | Enterprise resource planning and supply chain management | |
| Giri et al. | A closed-loop supply chain with stochastic product returns and worker experience under learning and forgetting | |
| KR102211437B1 (en) | Production of orders with forecasts, inventory management, integrated planning operating methods | |
| Faccio et al. | Kanban number optimisation in a supermarket warehouse feeding a mixed-model assembly system | |
| US20090063309A1 (en) | System And Method For Automating Engineering Processes For Build-To-Order Projects | |
| US20090132570A1 (en) | Cost Element Managing System | |
| Gharaei et al. | Modeling and optimization the four-level integrated supply chain: sequential quadratic programming | |
| CN114596020A (en) | Project MRP design method and system for large-scale customized production | |
| KR20210082919A (en) | Production and logistics ERP automation system by linking and using customer information | |
| CN101470865A (en) | Quotation information collecting system and collecting method thereof | |
| JP2007323680A (en) | Management decision support system | |
| Land et al. | Production planning and control in SMEs: time for change | |
| Giri et al. | Integrated model for an imperfect production-inventory system with a generalised shipment policy, errors in quality inspection and ordering cost reduction | |
| CN104573903A (en) | Computer program for process control over enterprise production scheduling and production flow management | |
| JP4851796B2 (en) | Traceability information collection method, traceability information collection system, and purchased parts information input terminal | |
| US20040210334A1 (en) | Method and system for planning disassembly and production of recyclable products and for planning procurement of parts for production | |
| JP2021039667A (en) | Information processing system, information processing method, and information processing program | |
| US20150066565A1 (en) | Systems and methods for managing an inventory of component parts | |
| Matilainen | Change requirements on product data structures in S/4HANA implementation | |
| CN101593317A (en) | Material demand scheduling system and method | |
| JP2016184250A (en) | Profit/loss prediction device and profit/loss prediction program | |
| Kurbel | MRP: material requirements planning |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20240507 |