Method, device, electronic device and storage medium for obtaining profile procurement plan

Abstract

The present application belongs to the technical field of production management, and discloses a method, device, electronic device and storage medium for obtaining a profile procurement plan, by obtaining order information; the order information includes first model information and first quantity information of a door frame or window frame to be prepared; according to the first model information and the first quantity information, profile type information of the required profile and first length information and second quantity information of various required frame strips are obtained; according to the profile type information, the first length information and the second quantity information, the second length information and third quantity information of the insufficient frame strips are obtained; the insufficient frame strips are the partial frame strips that are insufficient for production due to the profiles currently stored in the warehouse; according to the profile type information, the second length information and the third quantity information, the target model information and the procurement quantity of the target profile with the highest profile utilization rate are determined; thereby facilitating the reduction of the generation of surplus materials, and further facilitating the reduction of production costs.

Description

Technical Field

[0001] The present application relates to the technical field of production management, and more specifically, to a method, device, electronic device and storage medium for obtaining a profile procurement plan. Background Art

[0002] At present, some door frames and window frames are made of profiles (aluminum profiles, steel profiles, etc.). The same door frame or window frame generally includes multiple frame strips of different lengths, and each frame strip is made of a corresponding profile. Generally, door and window manufacturers divide a longer profile into multiple frame strips. When cutting, it is inevitable that there will be unusable residual materials (the length of the residual materials is not enough to be frame strips). This is because the profiles purchased by door and window manufacturers have a fixed length according to the specific model, and the length is usually not exactly an integer multiple of the required frame strip length. Since the residual materials cannot be used, it will cause a waste of resources and increase production costs.

[0003] In fact, when a door and window manufacturer receives an order, they will generally first estimate whether the number of existing profiles in the warehouse can meet the needs of the order. If not, they must purchase them in a timely manner. At this time, how to get a reasonable procurement plan to reduce the generation of surplus materials is an urgent problem to be solved. Summary of the invention

[0004] The purpose of this application is to provide a method, device, electronic device and storage medium for obtaining a profile procurement plan, which is conducive to reducing the generation of waste materials.

[0005] In a first aspect, the present application provides a method for obtaining a profile procurement plan, which is used to obtain a profile procurement plan; the method comprises the following steps:

[0006] A1. Get order information; the order information includes the first model information and the first quantity information of the door frame or window frame to be prepared;

[0007] A2. Obtain the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips according to the first model information and the first quantity information;

[0008] A3. Obtain the second length information and the third quantity information of the insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the frame strips of the profiles currently stored in the warehouse that are insufficient for production;

[0009] A4. Determine the target model information of the target profile with the highest profile utilization rate and the purchase quantity of the target profile according to the profile type information, the second length information and the third quantity information.

[0010] The method for obtaining a profile procurement plan first determines the lengths and quantities of various frame strips that need to be generated based on order information, then determines the lengths and quantities of some frame strips that are not sufficient to be generated by the profiles currently stored in the warehouse, and finally determines the model and corresponding procurement quantity of the target profile with the highest profile utilization rate based on the length and quantity of the insufficient frame strips, thereby obtaining a reasonable procurement plan to reduce the generation of surplus materials, which is beneficial to reducing production costs.

[0011] Preferably, step A2 comprises:

[0012] According to the first model information, query the query table to obtain the profile type information, the first length information and the fourth quantity information of the various frame strips included in a single door frame or a single window frame;

[0013] The second quantity information corresponding to various frame strips is obtained according to the first quantity information and the fourth quantity information.

[0014] Preferably, step A3 comprises:

[0015] A301.According to the profile type information, obtain the second model information, the third length information and the corresponding inventory information of various available profiles; the available profile is the profile currently stored in the warehouse corresponding to the profile type information;

[0016] A302. According to the first length information of the various frame strips and the third length information of the various available profiles, the types of frame strips to be prepared are allocated for the various available profiles;

[0017] A303. According to the allocation result and the third length information of the various available profiles, the types and yield information of the producible frame strips are obtained; the producible frame strips are the frame strips allocated to at least one of the available profiles; the yield information refers to the total number of the producible frame strips that can be produced by the profiles currently stored in the warehouse;

[0018] A304. Obtain the second length information and the third quantity information of the insufficient frame strips according to the type of the producible frame strips and the available production information.

[0019] Preferably, step A302 includes:

[0020] sequentially taking various usable profiles as target usable profiles;

[0021] For each of the target usable profiles, the first excess lengths of the target usable profiles when used to prepare various frame strips are calculated respectively, and the type of the frame strip with the smallest first excess length is allocated to the target usable profile.

[0022] Since the type of the frame strip with the smallest first surplus length is allocated to the target available profile, the utilization rate of the profile currently stored in the warehouse is improved, the generation of surplus is reduced, and the production cost is reduced.

[0023] Preferably, step A4 comprises:

[0024] A401. Get multiple detection length values ​​within a preset length range;

[0025] A402. Sequentially take various insufficient frames as target frames;

[0026] A403. For each of the target frame strips, respectively calculate the profile utilization rate when the profiles with each of the detection length values ​​are used to prepare the target frame strips, and determine the ideal length value of the target profile corresponding to the target frame strip according to the profile utilization rate;

[0027] A404. Determine the target model information of the target profiles of the various target frame strips and the purchase quantity of the target profiles according to the ideal length values ​​of the various target frame strips and the profile type information.

[0028] Preferably, step A403 includes:

[0029] Fitting a curve showing that the profile utilization rate varies with the detection length value;

[0030] The detected length value when the profile utilization rate is maximum is obtained according to the curve as the ideal length value of the target profile corresponding to the target frame strip.

[0031] The ideal length value obtained by fitting the curve corresponds to the lowest waste material generation rate. Selecting the model of the purchased profile according to the ideal length value is conducive to further reducing the generation of waste materials and reducing production costs.

[0032] Preferably, step A404 includes:

[0033] Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market;

[0034] The purchasable profile whose fourth length information is closest to the ideal length value is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile;

[0035] The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

[0036] In a second aspect, the present application provides a profile procurement plan acquisition device, which is used to acquire a profile procurement plan; comprising:

[0037] A first acquisition module is used to acquire order information; the order information includes first model information and first quantity information of the door frame or window frame to be prepared;

[0038] A second acquisition module, used for acquiring profile type information of the required profile and first length information and second quantity information of various required frame strips according to the first model information and the first quantity information;

[0039] A third acquisition module is used to acquire the second length information and the third quantity information of the insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the frame strips of the profiles currently stored in the warehouse that are insufficient for production;

[0040] A solution acquisition module is used to determine the target model information of the target profile with the highest profile utilization rate and the purchase quantity of the target profile according to the profile type information, the second length information and the third quantity information.

[0041] The profile procurement plan acquisition device first determines the lengths and quantities of various frame strips that need to be generated based on the order information, then determines the lengths and quantities of some frame strips that are not sufficient to be generated by the profiles currently stored in the warehouse, and finally determines the model and corresponding procurement quantity of the target profile with the highest profile utilization rate based on the length and quantity of the insufficient frame strips, thereby obtaining a reasonable procurement plan to reduce the generation of surplus materials, which is conducive to reducing production costs.

[0042] In a third aspect, the present application provides an electronic device, comprising a processor and a memory, wherein the memory stores a computer program executable by the processor, and when the processor executes the computer program, it runs the steps in the method for obtaining a profile procurement plan as described above.

[0043] In a fourth aspect, the present application provides a storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the steps in the method for obtaining a profile procurement plan as described above are executed.

[0044] Beneficial effects:

[0045] The profile procurement plan acquisition method, device, electronic device and storage medium provided in the present application obtain order information; the order information includes first model information and first quantity information of the door frame or window frame to be prepared; the profile type information of the required profile and the first length information and second quantity information of the required various frame strips are obtained according to the first model information and the first quantity information; the second length information and third quantity information of the insufficient frame strips are obtained according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the part of the frame strips that the profiles currently stored in the warehouse are insufficient for production; the target model information of the target profile with the highest profile utilization rate and the procurement quantity of the target profile are determined according to the profile type information, the second length information and the third quantity information; thereby facilitating the reduction of the generation of waste materials and further facilitating the reduction of production costs.

[0046] Other features and advantages of the present application will be set forth in the following description, and in part will become apparent from the description, or may be understood through implementation of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 A flowchart of a method for obtaining a profile procurement plan provided in an embodiment of the present application.

[0048] Figure 2 A schematic diagram of the structure of a profile procurement plan acquisition device provided in an embodiment of the present application.

[0049] Figure 3 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0050] The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. The components of the embodiments of the present application described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application claimed for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without making creative work belong to the scope of protection of the present application.

[0051] It should be noted that similar reference numerals and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further defined and explained in subsequent drawings. At the same time, in the description of this application, the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance.

[0052] Please refer to Figure 1 , Figure 1 It is a method for obtaining a profile procurement plan in some embodiments of the present application, which is used to obtain a profile procurement plan; it includes the steps of:

[0053] A1. Get order information; the order information includes the first model information and the first quantity information of the door frame or window frame to be prepared;

[0054] A2. Obtaining the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips (the required various frame strips refer to the various frame strips required to produce the door frames or window frames of the quantity required by the preparation order) according to the first model information and the first quantity information;

[0055] A3. Obtain the second length information and the third quantity information of the insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the partial frame strips that the profiles currently stored in the warehouse are insufficient for production;

[0056] A4. Determine the target model information and the purchase quantity of the target profile with the highest profile utilization rate according to the profile type information, the second length information and the third quantity information.

[0057] The method for obtaining a profile procurement plan first determines the lengths and quantities of various frame strips that need to be generated based on order information, then determines the lengths and quantities of some frame strips that are insufficient for production due to the profiles currently stored in the warehouse, and finally determines the model and corresponding procurement quantity of the target profile with the highest profile utilization rate based on the length and quantity of the insufficient frame strips, thereby obtaining a reasonable procurement plan to reduce the generation of surplus materials, which is beneficial to reducing production costs.

[0058] Among them, the order information can be obtained from the enterprise's order management system or through manual input.

[0059] In some embodiments, a query table may be generated in advance according to the profile type information, length information (hereinafter referred to as the first length information) and quantity information (hereinafter referred to as the fourth quantity information) of various frame strips included in each model of door frame or window frame; thus, step A2 includes:

[0060] According to the first model information, query the query table to obtain the profile type information of the required profile, the first length information and the fourth quantity information of various frame strips included in a single door frame or a single window frame;

[0061] The second quantity information corresponding to various frame strips is obtained according to the first quantity information and the fourth quantity information.

[0062] By looking up the table, the profile type information, the first length information and the fourth quantity information can be obtained conveniently and quickly, and then the second quantity information corresponding to various frame strips can be quickly calculated.

[0063] For example, a certain model of door frame is composed of four frame bars, including two vertical frame bars with a length of L1 and two horizontal frame bars with a length of L2, and the profile types of the vertical frame bars and the horizontal frame bars are both rectangular lining steel. By looking up the table, it can be known that the profile type information of the vertical frame bar of a single door frame of this type is rectangular lining steel, the first length information is L1, and the fourth quantity information is 2, and the profile type information of the horizontal frame bar is rectangular lining steel, the first length information is L2, and the fourth quantity information is 2.

[0064] Specifically, the second quantity information corresponding to the various frame strips can be obtained by multiplying the first quantity information by the fourth quantity information of the various frame strips.

[0065] In this embodiment, step A3 includes:

[0066] A301. Obtain the second model information, third length information and corresponding inventory information of various available profiles according to the profile type information; the available profile is the profile currently stored in the warehouse corresponding to the profile type information;

[0067] A302. According to the first length information of various frame strips and the third length information of various available profiles, the types of frame strips to be prepared are allocated for various available profiles;

[0068] A303. According to the allocation result and the third length information of various available profiles, the types and yield information of the producible frame strips are obtained; the producible frame strips are the frame strips allocated to at least one available profile; the yield information refers to the total number of producible frame strips of the type that can be produced by the profile currently stored in the warehouse;

[0069] A304. Obtain the second length information and the third quantity information of the insufficient frame strips according to the types of producible frame strips and the available production information.

[0070] For example, if the profile type information of the required profile is rectangular lining steel, and the profiles currently stored in the warehouse include M types of rectangular lining steel, then the M types of rectangular lining steel are all available profiles. Therefore, the model information (i.e., the second model information), length information (i.e., the third length information) and quantity information (i.e., inventory information) of these available profiles can be obtained from the warehouse management system, or they can be obtained through manual input.

[0071] In some implementations, step A302 includes:

[0072] Various available profiles are targeted as available profiles in turn;

[0073] For each target usable profile, the first excess length of the target usable profile when used to prepare various frame strips is calculated respectively, and the type of frame strip with the smallest first excess length is allocated to the target usable profile.

[0074] Since the type of the frame strip with the smallest first surplus length is allocated to the target available profile, the utilization rate of the profile currently stored in the warehouse is improved, the generation of surplus materials is reduced, and the production cost is reduced.

[0075] Specifically, the first residual length of the target available profile when used to prepare various frame strips can be calculated by the following formula:

[0076] ;

[0077] in, is the first excess length of the target available profile when used to prepare the i-th frame strip, The third length information of the target available profile, is the first length information of the i-th frame strip, is the cutting allowance (the length of material lost when a profile is cut once, which can be measured in advance), is the floor function.

[0078] For example, there are two types of available profiles, and two types of frame strips need to be produced; for the first type of available profile, the first residual length corresponding to the first frame strip is , the first excess length corresponding to the second frame strip is ,like , then the first frame strip is assigned to the first type of available profile (that is, the first type of available profile is split to prepare the first frame strip), if , the second frame strip is allocated to the first type of available profile (i.e., the first type of available profile is split to prepare the second frame strip); for the second type of available profile, the first residual length corresponding to the first frame strip is , the first excess length corresponding to the second frame strip is ,like , then the first frame strip is allocated to the available profile of the second type (that is, the available profile of the second type is split to prepare the first frame strip), if , then the second frame strip is allocated to the second type of available profile (that is, the second type of available profile is split to prepare the second frame strip).

[0079] In step A303, the available production information of various producible frame strips can be calculated by the following formula:

[0080] ;

[0081] in, is the production capacity information of the j-th producible frame strip, The third length information of the available profiles which are assigned with the jth producible frame strip, is the first length information of the jth producible frame strip, The inventory information of available profiles that are assigned the jth type of producible frame strip.

[0082] The second length information of the insufficient frame strip is the same as the first length information of the corresponding frame strip. The third quantity information of each insufficient frame strip can be obtained by subtracting the corresponding available production information from the second quantity information corresponding to each insufficient frame strip.

[0083] For example, there are two types of frame strips that need to be produced, namely, horizontal frame strips and vertical frame strips. 100 of each type of frame strips need to be produced (i.e., the second quantity information of both types of frame strips is 100), but the profiles in stock are only sufficient to produce 50 horizontal frame strips and 60 vertical frame strips (i.e., the production capacity information of the two types of frame strips is 50 and 60 respectively). In this case, there are two types of insufficient frame strips. The first type of insufficient frame strips are horizontal frame strips, and their second length information is the length information of the horizontal frame strips (first length information), and the third quantity information of the first type of insufficient frame strips is 50 (100-50=50). The second type of insufficient frame strips are vertical frame strips, and their second length information is the length information of the vertical frame strips (first length information), and the third quantity information of the second type of insufficient frame strips is 40 (100-60=40).

[0084] In this embodiment, step A4 includes:

[0085] A401. Obtain multiple detection length values ​​within a preset length range (the detection length value is a length value selected within the preset length range, which can be selected according to actual needs);

[0086] A402. Take various insufficient frames as target frames in turn;

[0087] A403. For each target frame strip, the profile utilization rate of the profiles with each detection length value when used to prepare the target frame strip is calculated, and the ideal length value of the target profile corresponding to the target frame strip is determined according to the profile utilization rate;

[0088] A404. Determine the target model information and purchase quantity of the target profiles of various target frame strips based on the ideal length values ​​and profile type information of various target frame strips.

[0089] The preset length range may be set according to actual needs, and the obtained multiple detection length values ​​may be distributed at equal intervals within the preset length range, but is not limited thereto.

[0090] The profile utilization rate when the profiles with various detection length values ​​are used to prepare the target frame strip can be calculated by the following formula:

[0091] ;

[0092] in, is the profile utilization rate when the profile with the mth detection length value is used to prepare the target frame strip, is the mth detection length value, The second length information of the target frame.

[0093] In some implementations, step A403 includes:

[0094] The detection length value corresponding to the calculated maximum profile utilization rate is taken as the ideal length value.

[0095] Directly using the calculated detection length value corresponding to the maximum profile utilization rate as the ideal length value can reduce the amount of calculation and improve processing efficiency.

[0096] In some other implementations, step A403 includes:

[0097] Fit the curve of profile utilization rate changing with the detection length value;

[0098] According to the curve, the detection length value when the profile utilization rate is the maximum (that is, the detection length value corresponding to the highest point of the curve) is obtained as the ideal length value of the target profile corresponding to the target frame strip.

[0099] The ideal length value obtained by fitting the curve corresponds to the lowest waste material generation rate. Selecting the model of the purchased profile according to the ideal length value is conducive to further reducing the generation of waste materials and reducing production costs.

[0100] In some implementations, step A404 includes:

[0101] Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market;

[0102] The commercially available profile whose fourth length information is closest to the ideal length value is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile;

[0103] The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

[0104] For example, if the profile type information of a certain target frame strip is rectangular lining steel, the ideal length value of the target profile corresponding to the target frame strip is 5380mm. Assuming that the models of rectangular lining steel available on the market include XX1, XX2 and XX3 (that is, the second model information of the purchasable profile includes XX1, XX2 and XX3), the actual lengths (fourth length information) of the three models of rectangular lining steel XX1, XX2 and XX3 are 5300mm, 5400mm and 5500mm respectively. Then, XX2 rectangular lining steel is selected as the target profile of the target frame strip. At this time, the target model information of the target profile is XX2. Finally, the purchase quantity of the target profile is calculated according to the actual length (fourth length information) of the target profile, the second length information of the target frame strip and the third quantity information.

[0105] Specifically, the step of calculating the purchase quantity of the target profile according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information includes:

[0106] Calculate the purchase quantity of each target profile according to the following formula:

[0107] ;

[0108] in, is the purchase quantity of the target profile corresponding to the nth target frame strip, is the third quantity information of the nth target frame bar, is the fourth length information of the target profile corresponding to the nth target frame strip, is the second length information of the nth target frame strip, is the ceiling function.

[0109] In some other implementations, step A404 includes:

[0110] Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market;

[0111] Calculate the deviation (in absolute value) between the fourth length information of each purchasable profile and the ideal length value;

[0112] Sort the available profiles in ascending order according to the size of the deviation;

[0113] Calculate the second residual length of the first K (a preset positive integer, which can be set according to actual needs, for example, K=2) of the sorted available profiles when used to prepare the target frame strip (refer to the calculation method of the first residual length in the previous text);

[0114] The purchasable profile with the smallest second excess length among the K purchasable profiles is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile;

[0115] The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

[0116] Since the second residual material length is first calculated for the K purchasable profiles whose lengths are relatively close to the ideal length value, and then the purchasable profile with the shortest second residual material length is used as the target profile corresponding to the target frame strip, compared with the previous implementation method, it can better ensure that the selected target profile produces the least residual material when preparing the corresponding target frame strip.

[0117] As can be seen from the above, the method for obtaining the profile procurement plan obtains order information; the order information includes the first model information and the first quantity information of the door frame or window frame to be prepared; the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips are obtained according to the first model information and the first quantity information; the second length information and the third quantity information of the insufficient frame strips are obtained according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the part of the frame strips that the profiles currently stored in the warehouse are insufficient for production; the target model information and the purchase quantity of the target profile with the highest profile utilization rate are determined according to the profile type information, the second length information and the third quantity information; this is conducive to reducing the generation of waste materials, and further conducive to reducing production costs.

[0118] Please refer to Figure 2 The present application provides a profile procurement plan acquisition device, which is used to acquire a profile procurement plan; including:

[0119] A first acquisition module 1 is used to acquire order information; the order information includes first model information and first quantity information of the door frame or window frame to be prepared;

[0120] A second acquisition module 2 is used to acquire the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips according to the first model information and the first quantity information;

[0121] The third acquisition module 3 is used to acquire the second length information and the third quantity information of the insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the partial frame strips that the profiles currently stored in the warehouse are insufficient for production;

[0122] The solution acquisition module 4 is used to determine the target model information and the purchase quantity of the target profile with the highest profile utilization rate according to the profile type information, the second length information and the third quantity information.

[0123] The profile procurement plan acquisition device first determines the lengths and quantities of various frame strips that need to be produced based on the order information, then determines the lengths and quantities of some frame strips that are not sufficient to be produced by the profiles currently stored in the warehouse, and finally determines the model and corresponding procurement quantity of the target profile with the highest profile utilization rate based on the length and quantity of the insufficient frame strips, thereby obtaining a reasonable procurement plan to reduce the generation of surplus materials, which is conducive to reducing production costs.

[0124] Among them, the order information can be obtained from the enterprise's order management system or through manual input.

[0125] In some embodiments, a query table may be generated in advance according to the profile type information, length information (hereinafter referred to as the first length information) and quantity information (hereinafter referred to as the fourth quantity information) of various frame strips included in each model of door frame or window frame; thus, the second acquisition module 2 is used to execute the following when acquiring the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips according to the first model information and the first quantity information:

[0126] According to the first model information, query the query table to obtain the profile type information of the required profile, the first length information and the fourth quantity information of various frame strips included in a single door frame or a single window frame;

[0127] The second quantity information corresponding to various frame strips is obtained according to the first quantity information and the fourth quantity information.

[0128] By looking up the table, the profile type information, the first length information and the fourth quantity information can be obtained conveniently and quickly, and then the second quantity information corresponding to various frame strips can be quickly calculated.

[0129] For example, a certain model of door frame is composed of four frame bars, including two vertical frame bars with a length of L1 and two horizontal frame bars with a length of L2, and the profile types of the vertical frame bars and the horizontal frame bars are both rectangular lining steel. By looking up the table, it can be known that the profile type information of the vertical frame bar of a single door frame of this type is rectangular lining steel, the first length information is L1, and the fourth quantity information is 2, and the profile type information of the horizontal frame bar is rectangular lining steel, the first length information is L2, and the fourth quantity information is 2.

[0130] Specifically, the second quantity information corresponding to the various frame strips can be obtained by multiplying the first quantity information by the fourth quantity information of the various frame strips.

[0131] In this embodiment, the third acquisition module 3 is used to execute, when acquiring the second length information and the third quantity information of the insufficient frame strip according to the profile type information, the first length information and the second quantity information:

[0132] According to the profile type information, second model information, third length information and corresponding inventory information of various available profiles are obtained; the available profiles are the profiles corresponding to the profile type information currently stored in the warehouse;

[0133] Allocating the types of frame strips to be prepared for the various available profiles according to the first length information of the various frame strips and the third length information of the various available profiles;

[0134] The type and yield information of the producible frame strips are obtained according to the allocation result and the third length information of various available profiles; the producible frame strips are frame strips allocated to at least one available profile; the yield information refers to the total number of producible frame strips of the type that can be produced by the profile currently stored in the warehouse;

[0135] The second length information and the third quantity information of the insufficient frame strips are obtained according to the types of producible frame strips and the production yield information.

[0136] For example, if the profile type information of the required profile is rectangular lining steel, and the profiles currently stored in the warehouse include M types of rectangular lining steel, then the M types of rectangular lining steel are all available profiles. Therefore, the model information (i.e., the second model information), length information (i.e., the third length information) and quantity information (i.e., inventory information) of these available profiles can be obtained from the warehouse management system, or they can be obtained through manual input.

[0137] In some embodiments, when allocating the types of frame strips to be prepared for various available profiles according to the first length information of various frame strips and the third length information of various available profiles, the third acquisition module 3 executes:

[0138] Various available profiles are targeted as available profiles in turn;

[0139] For each target usable profile, the first excess length of the target usable profile when used to prepare various frame strips is calculated respectively, and the type of frame strip with the smallest first excess length is allocated to the target usable profile.

[0140] Since the type of the frame strip with the smallest first surplus length is allocated to the target available profile, the utilization rate of the profile currently stored in the warehouse is improved, the generation of surplus materials is reduced, and the production cost is reduced.

[0141] Specifically, the third acquisition module 3 can calculate the first residual length when the target usable profile is used to prepare various frame strips by the following formula:

[0142] ;

[0143] in, is the first excess length of the target available profile when used to prepare the i-th frame strip, The third length information of the target available profile, is the first length information of the i-th frame strip, is the cutting allowance (the length of material lost when a profile is cut once, which can be measured in advance), is the floor function.

[0144] For example, there are two types of available profiles, and two types of frame strips need to be produced; for the first type of available profile, the first residual length corresponding to the first frame strip is , the first excess length corresponding to the second frame strip is ,like , then the first frame strip is assigned to the first type of available profile (that is, the first type of available profile is split to prepare the first frame strip), if , the second frame strip is allocated to the first type of available profile (i.e., the first type of available profile is split to prepare the second frame strip); for the second type of available profile, the first residual length corresponding to the first frame strip is , the first excess length corresponding to the second frame strip is ,like , then the first frame strip is allocated to the available profile of the second type (that is, the available profile of the second type is split to prepare the first frame strip), if , then the second frame strip is allocated to the second type of available profile (that is, the second type of available profile is split to prepare the second frame strip).

[0145] The third acquisition module 3 can calculate the available production information of various producible frame strips by the following formula:

[0146] ;

[0147] in, is the production capacity information of the j-th producible frame strip, The third length information of the available profiles which are assigned with the jth producible frame strip, is the first length information of the jth producible frame strip, The inventory information of available profiles that are assigned the jth type of producible frame strip.

[0148] The second length information of the insufficient frame strip is the same as the first length information of the corresponding frame strip. The third quantity information of each insufficient frame strip can be obtained by subtracting the corresponding available production information from the second quantity information corresponding to each insufficient frame strip.

[0149] For example, there are two types of frame strips that need to be produced, namely, horizontal frame strips and vertical frame strips. 100 of each type of frame strips need to be produced (i.e., the second quantity information of both types of frame strips is 100), but the profiles in stock are only sufficient to produce 50 horizontal frame strips and 60 vertical frame strips (i.e., the production capacity information of the two types of frame strips is 50 and 60 respectively). In this case, there are two types of insufficient frame strips. The first type of insufficient frame strips are horizontal frame strips, and their second length information is the length information of the horizontal frame strips (first length information), and the third quantity information of the first type of insufficient frame strips is 50 (100-50=50). The second type of insufficient frame strips are vertical frame strips, and their second length information is the length information of the vertical frame strips (first length information), and the third quantity information of the second type of insufficient frame strips is 40 (100-60=40).

[0150] In this embodiment, the solution acquisition module 4 is used to perform the following when determining the target model information and the purchase quantity of the target profile with the highest profile utilization rate according to the profile type information, the second length information and the third quantity information:

[0151] Obtain multiple detection length values ​​within a preset length range;

[0152] Taking various insufficient frames as target frames in turn;

[0153] For each target frame strip, the profile utilization rate when the profiles with each detection length value are used to prepare the target frame strip is calculated respectively, and the ideal length value of the target profile corresponding to the target frame strip is determined according to the profile utilization rate;

[0154] The target model information and the purchase quantity of the target profiles of the various target frame strips are determined according to the ideal length values ​​and profile type information of the various target frame strips.

[0155] The preset length range may be set according to actual needs, and the obtained multiple detection length values ​​may be distributed at equal intervals within the preset length range, but is not limited thereto.

[0156] The solution acquisition module 4 can calculate the profile utilization rate when the profiles with various detection length values ​​are used to prepare the target frame strips by the following formula:

[0157] ;

[0158] in, is the profile utilization rate when the profile with the mth detection length value is used to prepare the target frame strip, is the mth detection length value, The second length information of the target frame.

[0159] In some implementations, when determining the ideal length value of the target profile corresponding to the target frame strip according to the profile utilization rate, the solution acquisition module 4 executes:

[0160] The detection length value corresponding to the calculated maximum profile utilization rate is taken as the ideal length value.

[0161] Directly using the calculated detection length value corresponding to the maximum profile utilization rate as the ideal length value can reduce the amount of calculation and improve processing efficiency.

[0162] In some other embodiments, when determining the ideal length value of the target profile corresponding to the target frame strip according to the profile utilization rate, the solution acquisition module 4 executes:

[0163] Fit the curve of profile utilization rate changing with the detection length value;

[0164] According to the curve, the detection length value when the profile utilization rate is the maximum (that is, the detection length value corresponding to the highest point of the curve) is obtained as the ideal length value of the target profile corresponding to the target frame strip.

[0165] The ideal length value obtained by fitting the curve corresponds to the lowest waste material generation rate. Selecting the model of the purchased profile according to the ideal length value is conducive to further reducing the generation of waste materials and reducing production costs.

[0166] In some implementations, when determining the target model information and the purchase quantity of the target profiles of the various target frame strips according to the ideal length values ​​and profile type information of the various target frame strips, the solution acquisition module 4 executes:

[0167] Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market;

[0168] The commercially available profile whose fourth length information is closest to the ideal length value is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile;

[0169] The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

[0170] For example, if the profile type information of a certain target frame strip is rectangular lining steel, the ideal length value of the target profile corresponding to the target frame strip is 5380mm. Assuming that the models of rectangular lining steel available on the market include XX1, XX2 and XX3 (that is, the second model information of the purchasable profile includes XX1, XX2 and XX3), the actual lengths (fourth length information) of the three models of rectangular lining steel XX1, XX2 and XX3 are 5300mm, 5400mm and 5500mm respectively. Then, XX2 rectangular lining steel is selected as the target profile of the target frame strip. At this time, the target model information of the target profile is XX2. Finally, the purchase quantity of the target profile is calculated according to the actual length (fourth length information) of the target profile, the second length information of the target frame strip and the third quantity information.

[0171] Specifically, when the solution acquisition module 4 calculates the purchase quantity of the target profile according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information, the solution acquisition module 4 executes:

[0172] Calculate the purchase quantity of each target profile according to the following formula:

[0173] ;

[0174] in, is the purchase quantity of the target profile corresponding to the nth target frame strip, is the third quantity information of the nth target frame bar, is the fourth length information of the target profile corresponding to the nth target frame strip, is the second length information of the nth target frame strip, is the ceiling function.

[0175] In other embodiments, when determining the target model information and the purchase quantity of the target profiles of the various target frame strips according to the ideal length values ​​and profile type information of the various target frame strips, the solution acquisition module 4 executes:

[0176] Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market;

[0177] Calculate the deviation (in absolute value) between the fourth length information of each purchasable profile and the ideal length value;

[0178] Sort the available profiles in ascending order according to the size of the deviation;

[0179] Calculate the second residual length of the first K (a preset positive integer, which can be set according to actual needs, for example, K=2) of the sorted available profiles when used to prepare the target frame strip (refer to the calculation method of the first residual length in the previous text);

[0180] The purchasable profile with the smallest second excess length among the K purchasable profiles is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile;

[0181] The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

[0182] Since the second residual material length is first calculated for the K purchasable profiles whose lengths are relatively close to the ideal length value, and then the purchasable profile with the shortest second residual material length is used as the target profile corresponding to the target frame strip, compared with the previous implementation method, it can better ensure that the selected target profile produces the least residual material when preparing the corresponding target frame strip.

[0183] As can be seen from the above, the profile procurement plan acquisition device obtains order information; the order information includes the first model information and the first quantity information of the door frame or window frame to be prepared; the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips are obtained according to the first model information and the first quantity information; the second length information and the third quantity information of the insufficient frame strips are obtained according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the part of the frame strips that the profiles currently stored in the warehouse are insufficient for production; the target model information and the purchase quantity of the target profile with the highest profile utilization rate are determined according to the profile type information, the second length information and the third quantity information; this is conducive to reducing the generation of waste materials, and further conducive to reducing production costs.

[0184] Please refer to Figure 3 , Figure 3A structural schematic diagram of an electronic device provided in an embodiment of the present application, the present application provides an electronic device, including: a processor 301 and a memory 302, the processor 301 and the memory 302 are interconnected and communicate with each other through a communication bus 303 and / or other forms of connection mechanisms (not shown), the memory 302 stores a computer program executable by the processor 301, when the electronic device is running, the processor 301 executes the computer program to execute the profile procurement plan acquisition method in any optional implementation of the above embodiment to achieve the following functions: obtain order information; the order information includes first model information and first quantity information of the door frame or window frame to be prepared; obtain profile type information of the required profile and first length information and second quantity information of various required frame strips according to the first model information and the first quantity information; obtain second length information and third quantity information of insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are part of the frame strips that are insufficient for production of the profiles currently stored in the warehouse; determine the target model information and the purchase quantity of the target profile with the highest profile utilization rate according to the profile type information, the second length information and the third quantity information.

[0185] An embodiment of the present application provides a storage medium having a computer program stored thereon. When the computer program is executed by a processor, the method for obtaining a profile procurement plan in any optional implementation of the above-mentioned embodiment is executed to achieve the following functions: obtaining order information; the order information includes first model information and first quantity information of a door frame or window frame to be prepared; obtaining profile type information of a required profile and first length information and second quantity information of various required frame strips according to the first model information and the first quantity information; obtaining second length information and third quantity information of insufficient frame strips according to the profile type information, the first length information and the second quantity information; insufficient frame strips are partial frame strips that are insufficient for production of profiles currently stored in a warehouse; determining target model information and the procurement quantity of the target profile with the highest profile utilization rate according to the profile type information, the second length information and the third quantity information. Among them, the storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable red-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk or optical disk.

[0186] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are merely schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some communication interfaces, and the indirect coupling or communication connection of the devices or units can be electrical, mechanical or other forms.

[0187] In addition, the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0188] Furthermore, the functional modules in the various embodiments of the present application may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.

[0189] In this document, relational terms such as first and second, etc. are used merely to distinguish one entity or operation from another entity or operation, but do not necessarily require or imply any such actual relationship or order between these entities or operations.

[0190] The above description is only an embodiment of the present application and is not intended to limit the protection scope of the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method for obtaining a profile procurement plan, used to obtain a profile procurement plan; characterized in that: Includes steps: A1. Get order information; the order information includes the first model information and the first quantity information of the door frame or window frame to be prepared; A2. Obtain the profile type information of the required profile and the first length information and the second quantity information of the required various frame strips according to the first model information and the first quantity information; A3. Obtain the second length information and the third quantity information of the insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the frame strips of the profiles currently stored in the warehouse that are insufficient for production; A4. Determine the target model information of the target profile with the highest profile utilization rate and the purchase quantity of the target profile according to the profile type information, the second length information and the third quantity information; Step A4 includes: A401. Get multiple detection length values ​​within a preset length range; A402. Sequentially take various insufficient frames as target frames; A403. For each of the target frame strips, respectively calculate the profile utilization rate when the profiles with each of the detection length values ​​are used to prepare the target frame strips, and determine the ideal length value of the target profile corresponding to the target frame strip according to the profile utilization rate; A404. Determine the target model information of the target profile of the various target frame strips and the purchase quantity of the target profile according to the ideal length value of the various target frame strips and the profile type information; Step A403 includes: Fitting a curve showing that the profile utilization rate varies with the detection length value; According to the curve, the detection length value when the profile utilization rate is the maximum is obtained as the ideal length value of the target profile corresponding to the target frame strip; Step A404 includes: Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market; The purchasable profile whose fourth length information is closest to the ideal length value is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile; The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

2. The method for obtaining a profile procurement plan according to claim 1, characterized in that: Step A2 includes: According to the first model information, query the query table to obtain the profile type information, the first length information and the fourth quantity information of the various frame strips included in a single door frame or a single window frame; The second quantity information corresponding to various frame strips is obtained according to the first quantity information and the fourth quantity information.

3. The method for obtaining a profile procurement plan according to claim 1, characterized in that: Step A3 includes: A301.According to the profile type information, obtain the second model information, the third length information and the corresponding inventory information of various available profiles; the available profile is the profile currently stored in the warehouse corresponding to the profile type information; A302. According to the first length information of the various frame strips and the third length information of the various available profiles, the types of frame strips to be prepared are allocated for the various available profiles; A303. According to the allocation result and the third length information of the various available profiles, the types and yield information of the producible frame strips are obtained; the producible frame strips are the frame strips allocated to at least one of the available profiles; the yield information refers to the total number of the producible frame strips that can be produced by the profiles currently stored in the warehouse; A304. Obtain the second length information and the third quantity information of the insufficient frame strips according to the type of the producible frame strips and the available production information.

4. The method for obtaining a profile procurement plan according to claim 3, characterized in that: Step A302 includes: sequentially taking various usable profiles as target usable profiles; For each of the target usable profiles, the first excess lengths of the target usable profiles when used to prepare various frame strips are calculated respectively, and the type of the frame strip with the smallest first excess length is allocated to the target usable profile.

5. A profile procurement plan acquisition device, used to acquire a profile procurement plan; characterized in that: include: The first acquisition module is used to acquire order information; The order information includes first model information and first quantity information of the door frame or window frame to be prepared; A second acquisition module, used for acquiring profile type information of the required profile and first length information and second quantity information of various required frame strips according to the first model information and the first quantity information; A third acquisition module is used to acquire the second length information and the third quantity information of the insufficient frame strips according to the profile type information, the first length information and the second quantity information; the insufficient frame strips are the frame strips of the profiles currently stored in the warehouse that are insufficient for production; A solution acquisition module, used to determine the target model information of the target profile with the highest profile utilization rate and the purchase quantity of the target profile according to the profile type information, the second length information and the third quantity information; When the solution acquisition module determines the target model information of the target profile with the highest profile utilization rate and the purchase quantity of the target profile according to the profile type information, the second length information and the third quantity information, the solution acquisition module executes: Obtain multiple detection length values ​​within a preset length range; Taking the various insufficient frame strips as target frame strips in turn; For each of the target frame strips, respectively calculating the profile utilization rate when the profiles with the respective detection length values ​​are used to prepare the target frame strips, and determining the ideal length value of the target profile corresponding to the target frame strip according to the profile utilization rate; Determining target model information of the target profiles of various target frame strips and the purchase quantity of the target profiles according to the ideal length values ​​of the various target frame strips and the profile type information; When determining the ideal length value of the target profile corresponding to the target frame strip according to the profile utilization rate, the solution acquisition module executes: Fitting a curve showing that the profile utilization rate varies with the detection length value; According to the curve, the detection length value when the profile utilization rate is the maximum is obtained as the ideal length value of the target profile corresponding to the target frame strip; When the solution acquisition module determines the target model information of the target profiles of various target frame strips and the purchase quantity of the target profiles according to the ideal length values ​​of the various target frame strips and the profile type information, the solution acquisition module executes: Acquire the second model information and the corresponding fourth length information of the corresponding purchasable profile according to the profile type information; the purchasable profile is a profile that can be purchased from the market; The purchasable profile whose fourth length information is closest to the ideal length value is used as the target profile corresponding to the target frame strip, and the corresponding second model information is used as the target model information of the target profile; The purchase quantity of the target profile is calculated according to the fourth length information of the target profile, the second length information of the target frame strip, and the third quantity information.

6. An electronic device, characterized in that: It comprises a processor and a memory, wherein the memory stores a computer program executable by the processor, and when the processor executes the computer program, it runs the steps in the method for obtaining a profile procurement plan as described in any one of claims 1 to 4.

7. A storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps in the method for obtaining a profile procurement plan as described in any one of claims 1 to 4 are executed.

Images