CN111768159B - BIN (building information modeling) dividing method and system for LED light source - Google Patents
BIN (building information modeling) dividing method and system for LED light source Download PDFInfo
- Publication number
- CN111768159B CN111768159B CN202010637422.5A CN202010637422A CN111768159B CN 111768159 B CN111768159 B CN 111768159B CN 202010637422 A CN202010637422 A CN 202010637422A CN 111768159 B CN111768159 B CN 111768159B
- Authority
- CN
- China
- Prior art keywords
- bin
- light source
- led light
- steps
- dividing
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 48
- 239000000463 material Substances 0.000 claims abstract description 61
- 238000000926 separation method Methods 0.000 claims abstract description 13
- 238000013439 planning Methods 0.000 claims abstract description 8
- 238000003860 storage Methods 0.000 claims abstract description 7
- 230000004907 flux Effects 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 7
- 238000012384 transportation and delivery Methods 0.000 claims description 5
- 230000003631 expected effect Effects 0.000 claims description 2
- 230000003068 static effect Effects 0.000 claims description 2
- 238000004519 manufacturing process Methods 0.000 description 14
- 238000009826 distribution Methods 0.000 description 10
- 238000007726 management method Methods 0.000 description 10
- 239000011324 bead Substances 0.000 description 8
- 230000005284 excitation Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 238000012360 testing method Methods 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000002265 prevention Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
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/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; 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/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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
- G06Q50/00—Systems or methods specially adapted for 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
Abstract
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source. The BIN separation method of the LED light source comprises the following steps: step S1: maintaining BIN separation coding parameters; step S2: importing codes of each BIN item; step S3: applying a BIN splitting color scheme; step S4: managing a bill of materials; step S5: planning material requirements; step S6: managing a purchase contract; step S7: managing material to be delivered and put in storage; step S8: and managing the LED light source to obtain color matching. According to the BIN dividing method and system for the LED light source, the theoretical basis of BIN dividing of the LED light source is tightly combined with actual requirements such as logistics purchasing flow, priority and importance of the actual requirements such as logistics purchasing flow are highlighted, and a complete solution is provided for solving the color matching problem of products and materials in the LED industry.
Description
Technical Field
The invention belongs to the field of color matching of products and materials in the LED industry, and particularly relates to a BIN dividing method of an LED light source and a BIN dividing system of the LED light source.
Background
The invention discloses an LED (light-emitting diode) Bin dividing method and an application product thereof, wherein the publication number is CN111185407A, and the technical scheme of the invention discloses the LED Bin dividing method which comprises the following steps: a. randomly selecting a certain amount of sample to be tested, respectively testing parameters such as dominant wavelength, brightness or luminous flux, voltage, color coordinates and the like of each wafer in the product under a preset test current, and respectively carrying out statistical analysis on each test result; b. according to the specific distribution condition of each parameter, respectively defining and dividing interval standards: dominant wavelength interval standard: defining a main wavelength interval span, maximizing the ratio of one interval to the whole statistical data according to the statistical data distribution condition, wherein the interval is a central interval, and the other intervals are divided before/after the maximum/minimum value of the central interval is taken as a limit according to the interval span in sequence, and the like; brightness/luminous flux interval standard: the method is similar to the main wavelength interval standard; voltage interval standard: the method is similar to the main wavelength interval standard; color coordinate interval standard: marking maximum and minimum dominant wavelength lines of a dominant wavelength center interval on a CIE1931 atlas respectively, namely connecting a standard white light point with the maximum and minimum dominant wavelength points on the CIE track line, wherein the proportion from any point to the standard white light point on the line segment is the excitation purity, defining an excitation purity interval span, selecting two corresponding equal proportion excitation purity points according to the excitation purity interval span on the two dominant wavelength lines respectively, determining a line segment each two points, namely, four line segments enclose into an excitation coordinate interval, and representing four inequality equations, maximizing the occupation ratio of the color coordinate interval to the whole statistical data according to the distribution condition of the excitation coordinates of a test sample, wherein the interval is the center interval, and other intervals divide the main wavelength center interval and other main wavelength intervals according to the boundary line of the excitation coordinate center interval in turn according to the excitation purity interval span, and the like; c. selecting each interval containing brightness or luminous flux, voltage and color coordinates of each wafer in the LED product as a final sub-Bin parameter standard, and manufacturing a sub-Bin table, wherein each Bin contains one parameter interval, and the number of the final Bins depends on the product of the number of the respective intervals; d. and carrying out Bin point measurement on all the products to be measured in the same batch according to the final Bin dividing standard, judging and sorting according to the actual measurement parameters of the LEDs and the Bin dividing standard, and distinguishing the products from the Bin products independently to finish the product Bin dividing.
In the field of color matching of products and materials in the LED industry, taking the above-mentioned patent application of the invention as an example, according to the description of the specification of the patent application of the invention, a general idea that "through carrying out scientific and reasonable division on the conditions or ranges of dividing Bin of parameters such as brightness or luminous flux, voltage, color coordinates and the like of each wafer in an LED, thereby improving the consistency of light parameters with products in Bin and greatly improving the color deviation problem of terminal products" is disclosed, but obviously, when the patent application of the invention carries out dividing Bin on an LED light source, classification is carried out only according to the theoretical dividing Bin condition, however, the actual operability is weaker without further combining with practical factors such as logistics purchasing flow in the enterprise management process, and the invention is unfavorable for effectively guiding production practice.
Specifically, in the LED packaging industry, the packaged LED tubes may be classified according to wavelength, luminous intensity, luminous angle, working voltage, etc., and the result thereof is that LEDs are classified into a plurality of grades and categories, then the test sorting machine packages the LEDs in different BINs, and as the requirements of the market for LEDs are more and more strict, different standards are required for BIN values by various customers at present, different color scheme standards at present are maintained, and different color schemes are specified by customers. In the enterprise management process, the material purchasing process comprises the following steps: sales order (designated color scheme) -MRP requirements generate core wafer procurement-procurement contract distribution (tracking color scheme); the product distribution flow comprises the following steps: sales order-production warehouse entry (tracking color scheme) automatic distribution of products-sales shipping (tracking color scheme); in the process, automatic tracking is carried out on BIN splitting information, and further improvement is needed.
Disclosure of Invention
Aiming at the state of the art, the invention overcomes the defects and provides an LED light source BIN dividing method and an LED light source BIN dividing system.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, which mainly aim to tightly combine the theoretical basis of the BIN dividing of the LED light source with actual demands such as logistics purchasing flow, and the like, and focus on the priority and importance of the actual demands such as the logistics purchasing flow, so as to provide a complete solution for solving the color matching problem of products and materials in the LED industry.
Another object of the present invention is to change the BIN splitting information from traditional manual maintenance to automation Wei Hua, and to track the BIN splitting information through technical documents.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, which have the further aim of remarkably reducing daily maintenance workload, providing dynamically allocable stock quantity when color matching is carried out, avoiding manual allocation of stock, simultaneously carrying out automatic matching in a plurality of BIN value ranges, avoiding the need of deducting the stock quantity when one order is allocated and allocating the color matching of the next order, and being beneficial to improving allocation efficiency.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, and aims to provide a BIN dividing color scheme for the LED light source, which can realize full processes of maintenance, value taking, calculation and the like, realize quick calculation and reduce the overall cost of the system.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, which are characterized in that the BIN dividing coding parameter maintenance, BIN dividing coding table, LED application color scheme, bill of materials management, material demand planning, purchase contract management, material arrival warehouse management and LED light source lead color distribution management are taken as the general conception, and the BIN dividing demands of the LED light source are met step by step, clearly and efficiently.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, and the BIN dividing method and the BIN dividing system for the LED light source have the other aims of supporting various data importing, and are convenient to import and rapid to calculate.
The invention discloses a BIN separation method and a BIN separation system for an LED light source, which are used for effectively reducing the workload of data acquisition in a business process, and are used for calculating and obtaining accurate results.
The invention discloses a BIN separation method and a BIN separation system for an LED light source, which are further aimed at effectively reducing the inventory quantity of enterprises, lowering the cost and improving the operation benefit.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, and the BIN dividing method and the BIN dividing system for the LED light source have the other aim that the system participates in material purchase and product delivery inventory utilization according to various parameters according to a color scheme corresponding to products in sales orders, so that an optimal distribution mode is obtained.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, and the other aim is to take 'sales order (appointed color scheme) -MRP demand generation core wafer purchase-purchase contract distribution (tracking color scheme)' as a key flow.
The invention discloses a BIN dividing method and a BIN dividing system for an LED light source, and the BIN dividing method and the BIN dividing system have the other aim of taking 'sales order-production warehouse entry (tracking color scheme)' and 'sales delivery (tracking color scheme)' as important product delivery and distribution flows.
The invention adopts the following technical scheme that the BIN separation method of the LED light source comprises the following steps:
step S1: maintaining BIN separation coding parameters;
step S2: importing codes of each BIN item;
step S3: applying a BIN splitting color scheme;
step S4: managing a bill of materials;
step S5: planning material requirements;
step S6: managing a purchase contract;
step S7: managing material to be delivered and put in storage;
step S8: and managing the LED light source to obtain color matching.
According to the technical scheme, the step S1 is specifically implemented as the following steps:
step S1.1: classifying the items;
step S1.2: setting a BIN dividing item;
step S1.3: parameter names are set.
According to the technical scheme, the step S2 is specifically implemented as the following steps:
step S2.1: importing a BIN-dividing coding table into preset management software;
step S2.2: and distinguishing the code number of each BIN and the related data value of the code number through the BIN coding table.
According to the technical scheme, the step S3 is specifically implemented as the following steps:
step S3.1: recording a color scheme into the preset management software;
step S3.2: and in the subsequent color matching application, the color matching is selected for use by technical application personnel.
According to the technical scheme, the step S3.1 is specifically implemented as the following steps:
step S3.1.1: the name of the color scheme is customized through the preset management software;
step S3.1.2: selectively introducing the color zone and the luminous flux into the custom color scheme;
step S3.1.3: and importing the color matching rule into the custom color matching scheme.
According to the above technical solution, between step S3 and step S4, further includes step P0:
step P0: predetermined material properties are maintained.
According to the above technical solution, between step P0 and step S4, further comprising step Q0:
step Q0: and (5) managing material codes.
The invention further discloses a BIN dividing system for the LED light source, which is used for implementing the steps of the BIN dividing method for the LED light source disclosed by any one of the technical schemes.
The invention further discloses electronic equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the steps of the BIN separation method of the LED light source disclosed in any technical scheme are realized when the processor executes the program.
The invention further discloses a non-transitory computer readable storage medium, on which a computer program is stored, which when executed by a processor, implements the steps of the method for dividing BIN of an LED light source disclosed in any one of the above technical schemes.
The BIN dividing method and system for the LED light source have the beneficial effects that the theoretical basis of BIN dividing of the LED light source is tightly combined with actual demands such as logistics purchasing flow, the priority and importance of the actual demands such as logistics purchasing flow are highlighted, and a complete solution is provided for solving the color matching problem of products and materials in the LED industry.
Drawings
Fig. 1 is a schematic diagram of the overall operation flow of the present invention.
Fig. 2 is a schematic diagram of the overall operation flow of the present invention.
Detailed Description
The invention discloses a BIN (building information modeling) dividing method and a BIN dividing system for an LED light source, and the following is a description of a specific implementation of the invention with reference to a preferred embodiment.
Referring to fig. 1 and 2 of the drawings, fig. 1 and 2 show overall operation flows, respectively.
It should be noted that "PMC", which may be referred to in various embodiments of the present invention, is abbreviated as Production material control, and specifically defined as control of a production plan and a production progress, and supervision and management of various aspects of planning, tracking, transceiving, storing, using, and the like of materials, and prevention and treatment of stagnant materials. The PMC part mainly has two working contents: namely supervision and management of various aspects such as PC (production planning, management of production progress) and MC (planning, purchasing, tracking, receiving, storing, using and the like of materials, and prevention and treatment work of waste materials).
It is worth mentioning that the various embodiments of the present invention may relate to "BIN", as an abbreviation for "BIN" (grading). In order to classify the packaged LED chips, the LED chips are generally labeled Bin according to indexes such as brightness, light color, voltage, color temperature, and the like. In the LED chip industry, the light emission dominant wavelength and the light power are classified into bins (Bin), which are usually used to divide chips with the same optical or electrical parameters into a group. The LED manufacturer performs a partitioning of the luminous flux and color point coordinates (defined as bins) for each LED, the LEDs in each bin having very similar luminous flux and color point coordinates.
Preferred embodiments.
Preferably, the BIN separation method of the LED light source comprises the following steps:
step S1: maintaining BIN separation coding parameters;
step S2: importing codes of each BIN item;
step S3: applying a BIN splitting color scheme;
step S4: managing a bill of materials;
step S5: planning material requirements;
step S6: managing a purchase contract;
step S7: managing material to be delivered and put in storage;
step S8: and managing the LED light source to obtain color matching.
Further, the step S1 is specifically implemented as the following steps:
step S1.1: and classifying the items.
For example, there are a plurality of manufacturers of general beads, and different manufacturers have different BIN values, so that the items can be classified and defined as short names of the manufacturers to show the differences. Such as first, ai Disen, nitasia, etc.
Step S1.2: setting a BIN separation item.
As an example, the item type software may provide a plurality of options, corresponding to each, with reference to three settings, such as color zone, luminous flux, voltage. The BIN-divided item may be custom named. Basically, the above description is intended.
Step S1.3: parameter names are set.
For example, high value, low value, etc. are generally referred to, but in the LED color matching mode, it is generally considered that 8 chromaticity coordinates, respectively X1, Y1, X2, Y2, X3, Y3, X4, Y4, are set, and a color block area can be formed to provide basic data for subsequent graphic display.
Further, the step S2 is specifically implemented as the following steps:
step S2.1: importing a BIN-dividing coding table into preset management software;
step S2.2: and distinguishing the code number of each BIN and the related data value of the code number through the BIN coding table.
In step S2.1, the preset management software preferably uses EXCEL.
It should be noted that, in step S2.1, the preset management software should not be limited to EXCEL, but related software with large-scale data processing capability, such as, but not limited to, seatable, may also be used.
By way of example: such as code numbers C11 and C12 of the color zone BIN division of the first hand, wherein 8 coordinate values of C11 are respectively imported.
By way of example: such as the first luminous flux BIN divided codes K26, K27, etc., wherein the value of each BIN can be entered into the software for reference.
By way of example: such as the code Z56, Z58 of the voltage BIN division of the first hand, etc.
Further, the step S3 is specifically implemented as the following steps:
step S3.1: entering (by a development engineer responsible for the product) a color scheme into the preset management software;
step S3.2: and in the subsequent color matching application, the color matching is selected for use by technical application personnel.
Wherein, the step S3.1 is specifically implemented as the following steps:
step S3.1.1: the name of the color scheme (generally defined for the product) is customized through the preset management software;
step S3.1.2: (when in custom, the color zone and luminous flux are selected and imported into the custom color scheme;
step S3.1.3: the color matching rule is imported into the custom color matching scheme (the color matching rule is used as a guide of color matching application, and has a reference function when the lamp bead collar is used, but the color matching rule provided on the premise does not strictly strengthen the subsequent collar color matching of the management and control);
it should be noted that, between the step S3 and the step S4, the method further includes a step P0:
step P0: predetermined material properties are maintained.
Specifically, the step P0 is implemented as the following steps: when using a BIN value, a third property of the material is turned on (typically recommended) while the name of the property, e.g. "BIN value", is customized, and a list of names is automatically displayed as the defined property name at each interface of the preset management software.
Wherein, the step P0 is specifically implemented as the following steps:
step P0.1: the specific BIN value of the material is displayed on the base document in an editing manner (for the purpose of enabling the column), and inventory calculation is performed.
For example, a BIN value range is typically required when purchasing, but a certain BIN value and the quantity thereof cannot be accurately specified, and when actually warehousing, materials are classified and warehoused according to the BIN value of the delivered goods. The characteristic 3 is enabled, and the manual BIN value ledger can be directly replaced.
Step P0.2: according to different manufacturers, the characteristic rules (binding relation with materials) are set separately and can be normally applied.
By way of example, rule names may be defined as "first BIN, ai Disen BIN, nissan BIN," and the like.
Wherein, as an example, the characteristic options are all possible combinations generated under the first BIN to automatically form the characteristic options, such as first C11 and first C12; k26 and K27; z56 is combined into four combinations of 2 x1, and software can be automatically developed and generated according to the code number maintained without manual programming. These options are the alternate options for the business document when selected.
Step P0.3: and saving the control rule.
For example, the rule name of BIN is applied, and "purchasing front end is generally selected to be not controlled", and the expression means that the BIN value of the material is not specified but the range requirement description when the product BOM, the production BOM, the purchasing plan and the purchasing are combined; when the materials arrive at the goods, are put in warehouse and are led, the characteristic values must be filled according to the characteristic rules specified by the materials, so that the materials can normally operate.
Wherein, the front end of sales is controlled, generally refers to the processing of a lamp bead manufacturing enterprise, and the flow of the processing is exactly opposite to the purchasing environment; all documents are controlled, generally, a setting with characteristics to be controlled in business documents is generally referred to, and most of the non-LED lamp beads are used for controlling all the documents.
It should be noted that, between the step P0 and the step S4, the method further includes a step Q0:
step Q0: and (5) managing material codes.
Specifically, the step Q0 is implemented as the following steps: and specifying material BIN characteristic rules for the lamp beads.
For example, the names of the materials, such as first, ai Disen and Nissan, are generally named separately, and which BIN value is applied to each material is also required to be correspondingly maintained.
For example, the first bead material, such as first bead material, is designated to be applied with first BIN, and each time a material is added, a characteristic rule is required to be designated to ensure normal development when a business document runs.
By way of example, specifying a characteristic rule for each material means that when BIN value selection is made, only the alternate characteristic option under this rule can be selected.
It should be noted that, between the step Q0 and the step S4, the method further includes a step R0:
step R0: and managing a BOM table of the product.
Specifically, the step R0 is implemented as the following steps: a default color scheme is specified for each product.
Further, the step S4 is specifically implemented as the following steps: and setting a color scheme of a BOM table of a default product.
Further, step S5 is specifically implemented as the following steps: when static or dynamic, the preset management software performs statistics (ensures the accuracy of inventory consumption) after eliminating the data of the characteristic list when displaying the inventory quantity and purchase incompleteness data of the material.
Further, step S6 is specifically implemented as the following steps: pushing the formed purchase plan, converting into a requirement for BIN value range in the material description.
Further, the step S7 is specifically implemented as the following steps: and handling and warehousing according to the BIN value of the actual delivery, and sorting and warehousing different BIN values.
Further, step S8 is specifically implemented as the following steps: and (3) debugging and applying combinations of BIN values according to the color matching rules to achieve the expected effect, forming a color matching list and generating a color matching notice.
As an example, the allocable quantity of the interface is a dynamically calculated value, when a plan has been allocated to the quantity, a notice is formed that is not moved, if the quantity is taken, the notice is not moved and the stock is synchronously reduced to reach the allocable quantity. The interface can output a color matching list to inform production line personnel how to feed materials, feed ratio and the like.
It should be noted that the method for dividing BIN by using LED light source further includes step S9:
step S9: pushing the complete batch notification bill.
Specifically, step S9 is implemented as the following steps: and according to the color matching list, the preset management software automatically pushes the complete set of batching notification bill after issuing.
As an example, LED beads are taken as the primary document. Replace the original notification material receiving of the production task list, etc. Other materials other than LEDs are still used for receiving materials according to production task lists and the like.
It should be noted that the method for dividing BIN by using LED light source further includes step S10:
step S10: the material receiving order of the materials is managed,
for example, when the color matching function is activated, the complete batch notice becomes a leading data leading source of the material receiving bill, and the material receiving bill is carried out according to the batch notice.
It should be noted that, the preferred embodiment also discloses a BIN dividing system for an LED light source, which is used for implementing the steps of the BIN dividing method for the LED light source disclosed in any one of the above technical schemes.
It should be noted that the preferred embodiment also discloses an electronic device, which includes a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the steps of the method for dividing the BIN of the LED light source disclosed in any one of the above technical schemes are realized when the processor executes the program.
It should be noted that the preferred embodiment also discloses a non-transitory computer readable storage medium, on which a computer program is stored, which when executed by a processor, implements the steps of the method for dividing BIN of an LED light source disclosed in any of the above technical solutions.
It should be noted that, the EXCEL software and the like related to the present application should be regarded as the prior art, and the specific structure, the working principle, and the control manner and the spatial arrangement that may be related to the technical features should be selected conventionally in the art, and should not be regarded as the point of the invention of the present application, which is not further specifically described in detail.
Modifications of the embodiments described above, or equivalents of some of the features may be made by those skilled in the art, and any modifications, equivalents, improvements or etc. within the spirit and principles of the present invention are intended to be included within the scope of the present invention.
Claims (9)
1. The BIN dividing method for the LED light source is characterized by comprising the following steps of:
step S1: maintaining BIN separation coding parameters;
step S2: importing codes of each BIN item;
the step S2 is specifically implemented as the following steps:
step S2.1: importing a BIN-dividing coding table into preset management software;
step S2.2: dividing the code number of each BIN and the related data value of the code number by the BIN dividing coding table;
step S3: applying a BIN splitting color scheme;
step S4: managing a bill of materials;
the step S4 is specifically implemented as the following steps: setting a color scheme of a BOM table of a default product;
step S5: planning material requirements;
the step S5 is specifically implemented as the following steps: when static or dynamic, the preset management software performs data display of the stock quantity of the materials, and performs statistics after eliminating the data of the characteristic columns;
step S6: managing a purchase contract;
the step S6 is specifically implemented as the following steps: pushing the formed purchasing plan, converting into a requirement for BIN value range in material description at the same time;
step S7: managing material to be delivered and put in storage;
the step S7 is specifically implemented as the following steps: handling and warehousing according to BIN values of actual delivery, and sorting and warehousing different BIN values;
step S8: managing LED light source to obtain color matching;
step S8 is specifically implemented as the following steps: according to the color matching rule, debugging and applying combinations of BIN values to achieve the expected effect, forming a color matching list, and generating a color matching notification bill;
step S9: pushing the complete batch material notification bill;
step S9 is specifically implemented as the following steps: according to the color matching list, the preset management software automatically pushes the complete set of batching notification bill after issuing;
step S10: and managing a material receipt.
2. The method for dividing BIN of an LED light source according to claim 1, wherein step S1 is implemented as the following steps:
step S1.1: classifying the items;
step S1.2: setting a BIN dividing item;
step S1.3: parameter names are set.
3. The method for dividing BIN of an LED light source according to claim 1, wherein step S3 is implemented as the following steps:
step S3.1: recording a color scheme into the preset management software;
step S3.2: and in the subsequent color matching application, the color matching is selected for use by technical application personnel.
4. The method for dividing BIN of an LED light source according to claim 3, wherein the step S3.1 is implemented as the following steps:
step S3.1.1: the name of the color scheme is customized through the preset management software;
step S3.1.2: selectively introducing the color zone and the luminous flux into the custom color scheme;
step S3.1.3: and importing the color matching rule into the custom color matching scheme.
5. The method of claim 1, further comprising step P0 between step S3 and step S4:
step P0: predetermined material properties are maintained.
6. The method of claim 1, further comprising, between step P0 and step S4, step Q0:
step Q0: and (5) managing material codes.
7. A LED light source BIN splitting system, characterized by the steps for implementing the LED light source BIN splitting method of any of claims 1-6.
8. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the BIN splitting method of the LED light source according to any of claims 1-6 when the program is executed by the processor.
9. A non-transitory computer readable storage medium having stored thereon a computer program, characterized in that the computer program when executed by a processor implements the steps of the LED light source BIN splitting method of any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010637422.5A CN111768159B (en) | 2020-07-04 | 2020-07-04 | BIN (building information modeling) dividing method and system for LED light source |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010637422.5A CN111768159B (en) | 2020-07-04 | 2020-07-04 | BIN (building information modeling) dividing method and system for LED light source |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111768159A CN111768159A (en) | 2020-10-13 |
| CN111768159B true CN111768159B (en) | 2024-02-13 |
Family
ID=72723771
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010637422.5A Active CN111768159B (en) | 2020-07-04 | 2020-07-04 | BIN (building information modeling) dividing method and system for LED light source |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111768159B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200641705A (en) * | 2005-05-23 | 2006-12-01 | Hon Hai Prec Ind Co Ltd | Method and system for managing serial numbers of material |
| TW201040770A (en) * | 2009-05-05 | 2010-11-16 | Mitac Int Corp | Material substitute group generation system and method thereof |
| CN103157608A (en) * | 2011-12-16 | 2013-06-19 | 泰金宝电通股份有限公司 | Material selecting system and method for light-emitting diode crystal grains |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150194565A1 (en) * | 2014-01-07 | 2015-07-09 | Kla-Tencor Corporation | Solid State Light Production Using Flexible Grouping Of LEDs |
-
2020
- 2020-07-04 CN CN202010637422.5A patent/CN111768159B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200641705A (en) * | 2005-05-23 | 2006-12-01 | Hon Hai Prec Ind Co Ltd | Method and system for managing serial numbers of material |
| TW201040770A (en) * | 2009-05-05 | 2010-11-16 | Mitac Int Corp | Material substitute group generation system and method thereof |
| CN103157608A (en) * | 2011-12-16 | 2013-06-19 | 泰金宝电通股份有限公司 | Material selecting system and method for light-emitting diode crystal grains |
Non-Patent Citations (1)
| Title |
|---|
| 面向MES应用的MBOM系统实施;环翾;《智能制造》;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111768159A (en) | 2020-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Rewers et al. | Tools and methods of Lean Manufacturing-a literature review | |
| Chu et al. | Simulation studies in JIT production | |
| US20090292381A1 (en) | Production planning method and production planning system for mixed flows of production by order and forecasting | |
| Krajčovič et al. | Comprehensive approach to the inventory control system improvement | |
| Paul | A production scheduling problem in the glass-container industry | |
| CN112149925A (en) | Warehousing task automatic allocation method and device, and warehousing management method and system | |
| Romagnoli | Design and simulation of CONWIP in the complex flexible job shop of a Make-To-Order manufacturing firm | |
| CN109978436A (en) | A kind of device and its installation method and management method for visualization control of storing in a warehouse | |
| KOVÁCS | APPLICATION OF LEAN METHODS FOR IMPROVEMENT OF MANUFACTURING PROCESSES. | |
| CN111768159B (en) | BIN (building information modeling) dividing method and system for LED light source | |
| CN113011933A (en) | Commodity display management method and system | |
| US20170154290A1 (en) | Interregional supply adjustment device and program | |
| Kline et al. | Management of wood products manufacturing using simulation/animation | |
| US20220270033A1 (en) | Work planning system and work planning method | |
| Yavuz et al. | Kanban-based operational planning and control: simulation modelling | |
| JP2017165502A (en) | Article collecting work system, article collecting work method and article collecting work program | |
| Salunkhe et al. | Value Stream Mapping to Reduce Lead Time and Improve Throughput Time in a Manufacturing Organization: A Review | |
| Ozden et al. | Scheduling trucks in a multi-door cross-docking system with time windows | |
| Campbell | Pricing strategy in the automotive glass industry | |
| JP5102525B2 (en) | A method for calculating a material requirement plan for demand including multiple demand dates and priorities | |
| CN111062656A (en) | Improved integrated OMS system module | |
| Clotet | Lean production planning and control in semi-process industries | |
| Satolo et al. | Pull Production Systems: Link Between Lean Manufacturing and PPC | |
| Eng | The art of improvement. The implementation of process innovations in the areas of production and logistics of business activities | |
| Díaz-Reza et al. | Lean Manufacturing Origins and Concepts |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |