Business Development Roadmap Planning Method

By establishing a terminal outlet database and defining the initial center point of the service area, optimizing the store or regional allocation and business development route planning in the commercial marketing field, the problem of unreasonable allocation and inefficiency of visits has been solved, and more efficient business representative activities and sales have been achieved. Performance.

CN112348601BActive Publication Date: 2024-11-08SHANGHAI JINGQUE TECH CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202011401328.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2020-12-04
Publication Date
2024-11-08
Estimated Expiration
2040-12-04

AI Technical Summary

Technical Problem

In the existing commercial marketing field, there are unreasonable situations in store or regional allocation and business development route planning, resulting in unfair competition among business representatives and inefficient visits.

Method used

The terminal outlet database is established through the data processing device, the initial center point of the service area is defined, the scheduling module is established, the outlet allocation and route planning is optimized, and the map information is used to form a grid marked route information to improve visiting efficiency.

Benefits of technology

A reasonable visit route planning has been achieved, the efficiency and value of business representatives have been improved, and the transaction rate and sales performance have been improved.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN112348601B_ABST
    Figure CN112348601B_ABST
Patent Text Reader

Abstract

The present invention provides a business development route planning method, comprising the following steps performed by a data processing device: establishing a terminal network database; inputting the number of business representatives and the number of service areas; defining the initial center point of the service area corresponding to each business representative; establishing a first scheduling module corresponding to each business representative based on the initial center point of the service area, and generating a service area planning allocation result based on the first scheduling module; inputting the number of working days corresponding to each business representative based on the initial center point of the service area, and generating a second scheduling module based on the service area planning allocation result corresponding to each business representative and the input number of working days; and generating business development route planning information based on the second scheduling module.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to a business development route planning method, and more particularly to a method for improving or optimizing store or regional allocation and business development route planning. Background Art

[0002] Currently in the commercial marketing field, the allocation of stores or regions and the planning of sales representatives' visiting routes are generally planned by the sales representatives themselves or directly allocated by the company. Therefore, when allocating stores or regions and planning visiting routes, there is often an unreasonable distribution of the geographical locations of outlets in the divided areas. For example, the distance between stores in the service area of ​​the same sales representative is too large, the service areas of different sales representatives overlap to a large extent, and the distribution of outlets between different sales representatives is unreasonable, etc. This may lead to unfair competition among sales representatives and thus affect performance.

[0003] In addition, the specific planning of visiting routes is mostly decided by the business representatives themselves. Therefore, it mostly depends on the business representatives' familiarity with the street conditions in their service areas. For business representatives who are not familiar with the geographical environment, it is easy to spend too much time or distance on the visit, which also increases the company's intangible costs.

[0004] Therefore, how to improve or optimize the store or regional allocation and the business representative's visit route planning to improve the visit efficiency and the business representative's value is indeed a technical problem that needs to be solved urgently. Summary of the invention

[0005] In order to solve the various deficiencies of the aforementioned prior art, the present invention provides a business development route planning method, the method comprising: establishing a terminal network database through a data processing device, the terminal network database including business development data; inputting the number of business representatives and the number of service areas through the data processing device; defining the initial center point of the service area corresponding to each business representative through the data processing device; establishing a first scheduling module corresponding to each business representative based on the initial center point of the service area through the data processing device, and generating a service area planning allocation result based on the first scheduling module; inputting the number of working days corresponding to each business representative through the data processing device based on the initial center point of the service area, and generating a second scheduling module based on the service area planning allocation result corresponding to each business representative and the input number of working days; and generating business development route planning information through the data processing device based on the second scheduling module.

[0006] In one embodiment of the present invention, the business development route planning method also includes the following steps: inputting customer data through the data processing device; inputting terminal branch data corresponding to each customer or sales data corresponding to each terminal branch through the data processing device; inputting channel information corresponding to each terminal branch, business visit frequency and business visit duration information, terminal branch shelf visit duration information or weight information corresponding to each terminal branch through the data processing device; and generating the terminal branch database based on the data and information through the data processing device.

[0007] In one embodiment of the present invention, after the step of inputting the terminal branch data corresponding to each customer or the sales data corresponding to each terminal branch, before inputting the channel information corresponding to each terminal branch, defining the business visit frequency and business visit duration information, the terminal branch shelf visit duration information or the weight information corresponding to each terminal branch, the following steps are also included: inputting store data through the data processing device.

[0008] In one embodiment of the present invention, the step of establishing a first scheduling module corresponding to each business representative based on the initial center point of the service area and generating a service area planning allocation result based on the first scheduling module also includes the following steps: defining each terminal network point corresponding to each service area as a decision variable through the data processing device; defining the shortest distance information between each terminal network point in each service area as an objective function through the data processing device; defining restriction conditions through the data processing device; and establishing the first scheduling module corresponding to each business representative through the data processing device based on the decision variables, objective function and restriction conditions.

[0009] In one embodiment of the present invention, after establishing the first scheduling module corresponding to each business representative based on the initial center point of the service area and generating the service area planning allocation result based on the first scheduling module, the following steps are also included: using the data processing device, finding the optimization result based on the initial center point of the service area and the first scheduling module; using the data processing device, determining whether the optimization result is less than a default threshold, and if so, outputting the network point allocation result; if not, repeating the step of finding the optimization result based on the initial center point of the service area and the first scheduling module; and using the data processing device, forming a grid on the map information screen based on the network point allocation result, and marking the information corresponding to each business representative.

[0010] In one embodiment of the present invention, the step of inputting the number of working days corresponding to each business representative based on the initial center point of the service area, and generating a second scheduling module based on the service area planning allocation result corresponding to each business representative and the input number of working days, also includes the following steps: defining each terminal network point corresponding to each working day as a decision variable through the data processing device; defining the shortest connection distance information between each terminal network point in each service area as an objective function through the data processing device; defining restriction conditions through the data processing device; and establishing the second scheduling module corresponding to each business representative through the data processing device based on the decision variables, objective function and restriction conditions.

[0011] In one embodiment of the present invention, after inputting the number of working days corresponding to each business representative based on the initial center point of the service area, and generating a second scheduling module based on the service area planning allocation result corresponding to each business representative and the input number of working days, the following steps are also included: using the data processing device to find the optimization result based on the initial center point of the service area and the second scheduling module; using the data processing device to determine whether the optimization result is less than a default threshold, and if so, outputting the working day route point allocation result; if not, repeating the step of finding the optimization result based on the initial center point of the service area and the second scheduling module; and using the data processing device to form a grid on the map information screen based on the point allocation result, and marking the information on the routes and required hours between each point in the working day route.

[0012] In one embodiment of the present invention, a grid is formed on a map information screen based on the result of the network point allocation, and after the information of the routes and the required hours between the network points in the working day route is marked, the following steps are also included: defining the working day visit sequence as a decision variable through the data processing device; defining the minimum time required to visit all network points starting from the business office as an objective function through the data processing device; defining constraints through the data processing device; and establishing the third scheduling module corresponding to each business representative through the data processing device based on the decision variables, objective function and constraints.

[0013] In one embodiment of the present invention, after establishing the third scheduling module corresponding to each of the business representatives, the following steps are also included: using the data processing device to find the optimization result based on the third scheduling module; and using the data processing device to generate business development route planning information based on the optimization results of the second scheduling module and the third scheduling module.

[0014] The business development route planning method of the present invention can establish reasonable visiting routes and service areas, provide optimization suggestions, improve visiting efficiency, and increase output value, so as to further improve transaction rates and sales performance. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 The flowchart is a flow chart of an exemplary embodiment of the business development route planning method of the present invention.

[0016] Figure 2 The flowchart is a flow chart of an exemplary embodiment of the business development route planning method of the present invention.

[0017] Figure 3 The flowchart is a flow chart of an exemplary embodiment of the business development route planning method of the present invention.

[0018] Figure 4 The flowchart of another exemplary embodiment of the business development route planning method of the present invention is shown in FIG.

[0019] Figure 5 The flowchart of another exemplary embodiment of the business development route planning method of the present invention is shown in FIG.

[0020] Figure 6 The flowchart of another exemplary embodiment of the business development route planning method of the present invention is shown in FIG.

[0021] Figure 7 The flowchart of another exemplary embodiment of the business development route planning method of the present invention is shown in FIG.

[0022] Figure 8 The flowchart of another exemplary embodiment of the business development route planning method of the present invention is shown in FIG.

[0023] Component number description:

[0024] Steps S10 to S60

[0025] Steps S101 to S104

[0026] S11 Steps

[0027] Steps S401 to S404

[0028] Steps S41 to S43

[0029] Steps S501 to S504

[0030] Steps S51 to S53

[0031] Steps S54 to S57

[0032] Steps S61 to S62 DETAILED DESCRIPTION

[0033] The following describes the implementation of the present invention by means of specific embodiments. Those skilled in the art can easily understand other advantages and effects of the present invention from the contents disclosed in this specification.

[0034] It should be noted that the structures, proportions, sizes, etc. illustrated in the drawings of this specification are only used to match the contents disclosed in the specification for the understanding and reading of those familiar with this technology, and are not used to limit the limiting conditions for the implementation of the present invention, so they have no substantial technical significance. Any modification of the structure, change of the proportion relationship or adjustment of the size should fall within the scope of the technical content disclosed by the present invention without affecting the effects and purposes that can be achieved by the present invention. At the same time, the terms such as "upper", "inner", "outer", "bottom" and "one" quoted in this specification are only for the convenience of description, and are not used to limit the scope of the implementation of the present invention. The change or adjustment of their relative relationship should also be regarded as the scope of the implementation of the present invention without substantially changing the technical content.

[0035] See also Figure 1 , which is a flow chart of an embodiment of a business development route planning method of the present invention. The present invention provides a business development route planning method, which includes: S10 establishing a terminal network database through a data processing device, wherein the terminal network database includes business development data; S20 inputting the number of business representatives and the number of service areas through the data processing device; S30 defining the initial center point of the service area corresponding to each business representative through the data processing device; S40 establishing a first scheduling module corresponding to each business representative based on the initial center point of the service area through the data processing device, and generating a service area planning allocation result based on the first scheduling module; S50 inputting the number of working days corresponding to each business representative based on the initial center point of the service area through the data processing device, and generating a second scheduling module based on the service area planning allocation result corresponding to each business representative and the input number of working days through the data processing device; and S60 generating business development route planning information through the data processing device based on the second scheduling module.

[0036] See also Figure 2, which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, the step S10 establishes a terminal network database through a data processing device, and the terminal network database includes business development data and may also include the following steps: S101 inputs customer data through the data processing device; S102 inputs terminal network data corresponding to each customer or sales data corresponding to each terminal network through the data processing device; S103 inputs channel information corresponding to each terminal network, defines business visit frequency and business visit duration information, terminal network shelf visit duration information or weight information corresponding to each terminal network through the data processing device; and S104 generates the terminal network database based on the data and information through the data processing device.

[0037] According to the present invention, step S102 inputs the terminal outlet data corresponding to each customer or the sales data corresponding to each terminal outlet through the data processing device, wherein the terminal outlet data of the customer or the sales data corresponding to each terminal outlet may include the dealer master file, such as the number of outlets under its jurisdiction, the latitude and longitude data of each outlet, the pipeline type corresponding to each outlet, etc.; receipt data, such as the monthly effective sales volume of each outlet, the monthly effective sales amount (yuan) of each outlet, etc.; historical visit data, such as the monthly store visit time (minutes) of the business representative of each outlet, the monthly visit frequency (times / week) of the business representative of each outlet, etc.; and organizational structure data, such as the type and quantity of business representatives under the organization and their affiliation, etc.

[0038] According to the present invention, step S103 may include inputting channel information corresponding to each terminal outlet, defining business visit frequency and business visit duration information, terminal outlet shelf visit duration information or corresponding weight information of each terminal outlet through the data processing device.

[0039] The type of channel can be further defined by the store based on sales, number of shelf groups, store size, special channels, etc.

[0040] Among them, corresponding to different channel types, the business development route planning method of the present invention can calculate and define business visit frequency and business visit duration information through the data processing device.

[0041] In one embodiment of the present invention, the data processing device can calculate and restore the recommended values ​​of in-store visit duration and visit frequency using the historical actual visit data of a recent period of time, such as the past three months, using the following formulas 1 and 2.

[0042]

[0043]

[0044] In other embodiments of the present invention, the in-store visit duration and visit frequency may also be defined in other ways.

[0045] According to the present invention, step S104 may include generating the terminal network database through the data processing device based on the data and information, wherein the terminal network weight related to the information of the terminal network can be imported into the data processing device and calculated by the data processing device to generate the terminal network database.

[0046] Among them, the information about the terminal outlets may be, for example, the outlet output value (i.e., outlet sales) may be the average sales volume of the outlet in the valid receipts in the past three months; the number of outlets may be the number of outlets corresponding to the service area or service day route of each business representative after dividing the area or establishing the visiting route; the in-store visit duration may be the product of the recommended visit frequency and the recommended in-store visit duration, etc.

[0047] Among them, the data processing device can further calculate and convert the information of the above-mentioned terminal outlets into the same dimension, and can also standardize the values ​​between different factors, and then calculate the score of each terminal outlet based on the selected terminal outlet weight related to the information of the terminal outlet.

[0048] In one embodiment of the present invention, after inputting the terminal branch data corresponding to each customer or the sales data corresponding to each terminal branch in step S102, before inputting the channel information corresponding to each terminal branch, defining the business visit frequency and business visit duration information, the terminal branch shelf visit duration information or the weight information corresponding to each terminal branch in step S103, it also includes step S11: inputting the store data through the data processing device.

[0049] In one embodiment of the present invention, the step S30 may be performed by the data processing device to define the initial center point of the service area corresponding to each business representative using an appropriate algorithm. In one embodiment, the data processing device may use a vector quantization method, such as a K-means clustering algorithm, but not limited thereto, to cluster data points according to the distance between data points while maximizing the distance between clusters as much as possible and minimizing the distance within the cluster, thereby defining the initial center point of the service area of ​​each business representative.

[0050] In one embodiment of the present invention, the step S40 can be performed by the data processing device to establish a first scheduling module corresponding to each business representative according to the initial center point of the service area, and generate a service area planning allocation result according to the first scheduling module.

[0051] See also Figure 3, which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, the step S40 of establishing a first scheduling module corresponding to each of the business representatives based on the initial center point of the service area and generating a service area planning allocation result based on the first scheduling module also includes: S401, through the data processing device, defining each of the terminal network points corresponding to each of the service areas as a decision variable; S402, through the data processing device, defining the shortest distance information between each of the terminal network points in each of the service areas as an objective function; S403, through the data processing device, defining a restriction condition; and S404, through the data processing device, establishing the first scheduling module corresponding to each of the business representatives based on the decision variables, the objective function and the restriction condition.

[0052] According to the present invention, step S401 defines, through the data processing device, that each service area corresponds to each terminal network point as a decision variable, which may include how each terminal network point should be allocated to the selected service area.

[0053] According to the present invention, the restriction conditions in step S403 may be, for example, each terminal outlet can only be assigned to one service area; the sum of the outlet weight scores of each service area is similar, for example, the score difference is between plus or minus 5%; the total number of outlets allocated to each service area is similar, for example, the total number of outlets differs between plus or minus 5%.

[0054] See also Figure 4 , which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, after the first scheduling module corresponding to each business representative is established according to the initial center point of the service area and the service area planning allocation result is generated according to the first scheduling module, it also includes: S41, through the data processing device, according to the initial center point of the service area and the first scheduling module to find the optimization result; S42, through the data processing device, determine whether the optimization result is less than the default threshold, if so, output the network point allocation result; if not, repeat the step of finding the optimization result according to the initial center point of the service area and the first scheduling module; and S43, through the data processing device, according to the network point allocation result, form a grid on the map information screen, and mark the information corresponding to each business representative on the grid. In this way, the business development route planning method of the present invention can plan an optimized service area.

[0055] In one embodiment of the present invention, step S50 can be performed by the data processing device, based on the initial center point of the service area, inputting the working days corresponding to each business representative, and generating a second scheduling module based on the service area planning allocation results corresponding to each business representative and the input working days.

[0056] See also Figure 5 , which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, the step S50 inputs the number of working days corresponding to each business representative according to the initial center point of the service area, and generates a second scheduling module according to the service area planning allocation result corresponding to each business representative and the input number of working days, and also includes the following steps: S501 defines each terminal network point corresponding to each selected working day as a decision variable through the data processing device; S502 defines the shortest online distance information between each terminal network point defined in each selected working day as an objective function through the data processing device; S503 defines a restriction condition through the data processing device; and S504 establishes the second scheduling module corresponding to each business representative through the data processing device according to the decision variable, the objective function and the restriction condition.

[0057] According to the present invention, step S501 defines each terminal point corresponding to each weekday as a decision variable through the data processing device, which may include how each terminal point should be allocated to a selected weekday route visit. According to one embodiment of the present invention, the point can be allocated to a selected weekday route visit; according to other embodiments of the present invention, the point can be allocated to multiple selected weekday routes.

[0058] According to the present invention, the restriction conditions in step S504 may be, for example, each outlet can only be assigned to a working day equivalent to its visit frequency (whether it is one visit a week or multiple visits a week); the sum of the outlet weight scores of each working day is similar, for example, the difference between their scores is between plus or minus 5%; the total number of outlets assigned to each working day is similar, for example, the total number of outlets differs between plus or minus 5%.

[0059] See also Figure 6 , which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, after inputting the working days corresponding to each business representative according to the initial center point of the service area in step S50, and generating the second scheduling module according to the service area planning allocation result corresponding to each business representative and the input working days, it also includes: S51, through the data processing device, finding the optimal result according to the initial center point of the service area and the second scheduling module; S52, through the data processing device, judging whether the optimal result is less than the default threshold, if so, outputting the working day route network point allocation result; if not, repeating the step of finding the optimal result according to the initial center point of the service area and the second scheduling module; and S53, through the data processing device, forming a grid on the map information screen according to the network point allocation result, and marking the information of the route and the required time between each network point in the working day route.

[0060] Among them, the initial center point of the service area may produce an error when the data processing device executes step S50 to obtain the optimization result of the second scheduling module due to the small amount of data during calculation. Therefore, according to one embodiment of the present invention, the data processing device can run the second scheduling module, select several outlets with the longest total distance from each other among the outermost outlets in the service area as starting points, and then repeat steps S51 to S53 until the distribution of each outlet on the same working day based on the distance between the outlet and the initial center point, the number of outlets and the outlet weight score is averaged, which is regarded as achieving the optimization result.

[0061] In one embodiment of the present invention, step S60 can further generate business development route planning information through the data processing device according to the second scheduling module and the results obtained in the above steps.

[0062] See also Figure 7 , which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, in steps S51 to S53, a grid is formed on the map information screen according to the network point allocation result, and after the information of the routes and required hours between the network points in the workday route is marked, it also includes: S54, through the data processing device, defining the workday visit sequence as a decision variable; S55, through the data processing device, defining the minimum time required to visit all network points starting from the business office as the objective function; S56, through the data processing device, defining constraints; and S57, through the data processing device, establishing the third scheduling module corresponding to each of the business representatives according to the decision variables, objective functions and constraints.

[0063] According to the present invention, the step S54 defines the working day visit sequence as a decision variable through the data processing device, which may include the visit sequence of each network point allocated in the selected working day route.

[0064] According to the present invention, step S55 defines, through the data processing device, that the objective function is to start from the business office and to minimize the time required to visit all outlets, which may include the order of visiting the outlets allocated in the selected working day route, and to select one of the outlets, such as the business office, as the starting point to visit all outlets in the selected working day route with the least time required.

[0065] According to the present invention, step S56 defines restriction conditions through the data processing device, which may include further limiting the visiting frequency of each outlet after confirming the visiting order of each outlet through the aforementioned steps, for example, visiting each outlet once a day, but not limited to this.

[0066] See also Figure 8, which is a flow chart of another embodiment of the business development route planning method of the present invention. In one embodiment of the present invention, after the third scheduling module corresponding to each business representative is established in steps S51 to S57, the method may further include: S61, through the data processing device, finding the optimal result according to the third scheduling module; and S62, through the data processing device, generating business development route planning information according to the optimal results of the second scheduling module and the third scheduling module.

[0067] The business development route planning method of the present invention can establish reasonable visiting routes and service areas, provide optimization suggestions, improve visiting efficiency, and increase output value, so as to further improve transaction rates and sales performance.

[0068] The present invention can be further illustrated by the following examples.

[0069] Example 1 - Establishing a service area

[0070] In a region, there are N terminal outlets, which need to be assigned to M business representatives. A terminal outlet database is established through a data processing device, and the terminal outlet database includes business development data; through the data processing device, the number of business representatives and the number of service areas are input, and the terminal outlets and business representatives are marked respectively to form a matrix D (with a dimension of M×N).

[0071]

[0072] Through the data processing device, the initial center point of the service area corresponding to each business representative is defined; through the data processing device, a first scheduling module corresponding to each business representative is established based on the initial center point of the service area, and the optimal service area planning allocation result is generated based on the first scheduling module.

[0073] Example 2 - Establishing a business development route plan

[0074] By means of the data processing device, the number of working days corresponding to each of the business representatives is inputted according to the initial center point of the service area, and a second scheduling module is generated according to the service area planning allocation result corresponding to each of the business representatives and the input number of working days; by means of the data processing device, an optimization result is found according to the initial center point of the service area and the second scheduling module; by means of the data processing device, it is determined whether the optimization result is less than a default threshold, and if so, a result of the workday route network point allocation is outputted; if not, the step of finding the optimization result according to the initial center point of the service area and the second scheduling module is repeated; and by means of the data processing device, a grid is formed on the map information screen according to the network point allocation result. , and mark the information of the routes and required hours between each outlet in the working day route; define the working day visit sequence as a decision variable through the data processing device; define the minimum time required to visit all outlets starting from the business office as the objective function through the data processing device, as shown in the following formula 3; define the restriction conditions through the data processing device; establish the third scheduling module corresponding to each business representative through the data processing device according to the decision variables, objective function and restriction conditions; and find the optimization result according to the third scheduling module through the data processing device; and generate business development route planning information according to the optimization results of the second scheduling module and the third scheduling module through the data processing device.

[0075] Objective function:

[0076] Among them, the number of business representatives (i) = the number of districts.

[0077] j=1,…,n (n represents the number of terminal outlets in the service area)

[0078] D ij· D ist : Used to calculate the distance from a single terminal point to the center point of the area.

[0079] The terminal outlets in a single service area are summed up to obtain the average value of each terminal outlet in a single service area to the center point of the service area. Finally, the service areas are summed up to obtain the sum of the average distances of each service area.

[0080] The restriction condition is:

[0081] 1. Each outlet can only be assigned to one sales representative, and all outlets are assigned Σ j D ij =1.

[0082] 2. The output value of the outlets assigned to each sales representative is similar. A outlet score S (matrix) is calculated in advance, and its mean s (constant) is calculated.

[0083]

[0084]

[0085] In this embodiment, the default threshold is set to ±5%.

[0086] Example 3 - Route Planning

[0087] First, execute step S10 to establish a terminal network database through a data processing device, wherein the terminal network database includes business development data, including: S101, inputting customer data through the data processing device; S102, inputting terminal network data corresponding to each customer or sales data corresponding to each terminal network through the data processing device; S103, inputting channel information corresponding to each terminal network, defining business visit frequency and business visit duration information, terminal network shelf visit duration information or weight information corresponding to each terminal network through the data processing device; and S104, generating the terminal network database based on the data and information through the data processing device.

[0088] In this embodiment, there are 1345 network points in total.

[0089] Execute step S20, and input the number of business representatives and the number of service areas through the data processing device. In this embodiment, there are 5 business representatives, namely A, B, C, D, and E, and there are 5 corresponding service areas.

[0090] Step S30 is executed to define the initial center point of the service area corresponding to each business representative through the data processing device.

[0091] Execute step S40 through the data processing device, establish a first scheduling module corresponding to each of the business representatives according to the initial center point of the service area, and generate a service area planning allocation result according to the first scheduling module, including: S401 through the data processing device, define each of the terminal outlets corresponding to each of the service areas as a decision variable; S402 through the data processing device, define the shortest distance information between each of the terminal outlets in each of the service areas as an objective function; S403 through the data processing device, define restriction conditions; and S404 through the data processing device, establish the first scheduling module corresponding to each of the business representatives according to the decision variables, objective functions and restriction conditions.

[0092] In this embodiment, there are 1345 dots in total. According to this embodiment, the 1345 dots can be divided into 5 groups using, for example, the K-means clustering algorithm or other algorithms, and the final grouping results are 277, 213, 329, 275, and 251 dots.

[0093] The restrictions that can be set are as follows: A. Each network point can only be assigned to one area; B. The sum of the network point weight scores in each area is close.

[0094] The weight score may include sales weight, outlet weight, visit duration weight, etc. The sales weight is the average effective sales of the outlet in the past three months; the outlet weight is the number of outlets corresponding to each sales representative service area after the division; the visit duration weight is the average weekly visit frequency in the past three months x the average store visit duration in the past three months. Convert the above data into percentiles.

[0095] Finally, the more evenly distributed area distribution is found in the following table.

[0096] Number of outlets Duration score Sales volume score Total score Area 1 271 133 53 118 Area 2 253 141 63 118 Area 3 275 134 48 119 Area 4 273 133 52 119 Area 5 273 131 59 119

[0097] Execute step S50 through the data processing device, input the number of working days corresponding to each business representative according to the initial center point of the service area, and generate a second scheduling module according to the service area planning allocation result corresponding to each business representative and the input number of working days, including: S501 through the data processing device, define each terminal network point corresponding to each selected working day as a decision variable; S502 through the data processing device, define the online shortest distance information between each terminal network point defined in each selected working day as an objective function; S503 through the data processing device, define restriction conditions; and S504 through the data processing device, establish the second scheduling module corresponding to each business representative according to the decision variables, objective function and restriction conditions.

[0098] For example, in this embodiment, area 1 is assigned to business representative A, and according to the workday allocation, the network point should be assigned to which workday route to visit.

[0099] The sum of the distances between the outlets finally assigned to the same working day and the center point is the shortest. The restriction conditions of S504 may include: each outlet can only be assigned to working days equal to its visit frequency (multiple visits per week); the sum of the outlet weight scores on each working day is similar (plus or minus 5%); the total number of outlets assigned to each working day is similar (plus or minus 5%).

[0100] According to the business development route planning method of the present invention, the distribution results of working days are as follows:

[0101] Working Day Sum of scores Number of outlets Visit duration Sales 0 27.63 54 812 134 1 27.67 55 791 127 2 29.22 54 820 182 3 28.57 55 819 116 4 28.62 53 817 153

[0102] Step S60 is executed by the data processing device to generate business development route planning information according to the second scheduling module. Route planning can adopt, for example, TSP (Traveling Salesman Problem), but is not limited thereto, and can use the minimum time required to visit all outlets as the objective function, and each outlet can only be visited once as a constraint condition.

[0103] The above embodiments are only used to illustrate the principles and effects of the present invention, and are not used to limit the present invention. Anyone skilled in the art may modify the above embodiments without violating the spirit and scope of the present invention. Therefore, the scope of protection of the present invention should be as set forth in the claims.

Claims

1. A business development route planning method, characterized in that: The method includes: Inputting customer data through data processing equipment; Inputting the terminal outlet data corresponding to each customer or the sales data corresponding to each terminal outlet through the data processing device; Through the data processing device, input the channel information corresponding to each terminal outlet, define the business visit frequency and business visit duration information, terminal outlet shelf visit duration information or the weight information corresponding to each terminal outlet; By means of the data processing device, a terminal network database is generated according to the data and information, wherein the terminal network database includes business development data; Through the data processing device, the number of business representatives and the number of service areas are input; By means of the data processing device, an initial center point of a service area corresponding to each business representative is defined; By means of the data processing device, a first scheduling module corresponding to each business representative is established according to the initial center point of the service area, and a service area planning allocation result is generated according to the first scheduling module; By means of the data processing device, according to the initial center point of the service area, the number of working days corresponding to each business representative is input, and a second scheduling module is generated according to the service area planning allocation result corresponding to each business representative and the input number of working days; and By means of the data processing device, business development route planning information is generated according to the second scheduling module, wherein the step of establishing a first scheduling module corresponding to each business representative according to the initial center point of the service area and generating a service area planning allocation result according to the first scheduling module further includes the following steps: By means of the data processing device, defining the correspondence between each terminal network point and each service area as a decision variable; By means of the data processing device, the shortest distance information between the terminal network points in the service areas is defined as the objective function; By means of the data processing device, a restriction condition is defined, wherein each terminal outlet can only be allocated to one service area, the sum of the outlet weight scores of each service area is similar, or the total number of outlets allocated to each service area is similar; and By means of the data processing device, the first scheduling module corresponding to each business representative is established according to the decision variables, the objective function and the restriction conditions. The step of inputting the number of working days corresponding to each business representative according to the initial center point of the service area, and generating a second scheduling module according to the service area planning allocation result corresponding to each business representative and the input number of working days, further includes the following steps: By means of the data processing device, the corresponding terminal outlets to the working days are defined as decision variables; By means of the data processing device, the shortest online distance information between the terminal network points defined in the selected working days is defined as the objective function; By means of the data processing device, a restriction condition is defined, wherein each outlet can only be allocated to working days equal to its visit frequency, the sum of the outlet weight scores of the working days is similar, or the total number of outlets allocated to the working days is similar; and The data processing device is used to establish the second scheduling module corresponding to each business representative according to the decision variables, objective function and restriction conditions.

2. The business development route planning method according to claim 1, characterized in that: After inputting the terminal outlet data corresponding to each customer or the sales data corresponding to each terminal outlet, before inputting the channel information corresponding to each terminal outlet, defining the business visit frequency and business visit duration information, the terminal outlet shelf visit duration information or the weight information corresponding to each terminal outlet, the following steps are also included: The store data is input through the data processing device.

3. The business development route planning method according to claim 1, characterized in that: After establishing the first scheduling module corresponding to each business representative according to the initial center point of the service area and generating the service area planning allocation result according to the first scheduling module, the following steps are also included: By means of the data processing device, an optimization result is found according to the initial center point of the service area and the first scheduling module; By means of the data processing device, it is determined whether the optimization result is less than a default threshold value, and if so, the network point allocation result is output; if not, the step of finding the optimization result according to the initial center point of the service area and the first scheduling module is repeated; and The data processing device forms a grid on the map information screen according to the network point allocation result, and annotates the grid with information corresponding to each business representative.

4. The business development route planning method according to claim 1, characterized in that: After inputting the working days corresponding to each business representative according to the initial center point of the service area, and generating a second scheduling module according to the service area planning allocation result corresponding to each business representative and the input working days, the following steps are also included: By means of the data processing device, an optimization result is found according to the initial center point of the service area and the second scheduling module; By means of the data processing device, it is determined whether the optimization result is less than a default threshold value. If so, the result of the route point allocation on weekdays is output; if not, the step of finding the optimization result based on the initial center point of the service area and the second scheduling module is repeated; and The data processing device forms a grid on the map information screen according to the network point allocation result, and marks the information of the route between each network point in the working day route and the required time on the grid.

5. The business development route planning method according to claim 4, characterized in that: After forming a grid on the map information screen according to the network point allocation result and marking the information of the route and the required time between each network point in the working day route on the grid, the following steps are also included: By means of the data processing device, the order of visits during working days is defined as a decision variable; By means of the data processing device, the objective function is defined as the minimum time required to visit all outlets starting from the business office; By means of the data processing device, defining a constraint condition; and The third scheduling module corresponding to each business representative is established through the data processing device according to the decision variables, objective function and restriction conditions.

6. The business development route planning method according to claim 5, characterized in that: After establishing the third scheduling module corresponding to each business representative, the following steps are also included: By means of the data processing device, searching for an optimal result according to the third scheduling module; and The data processing device generates business development route planning information according to the optimization results of the second scheduling module and the third scheduling module.

Citation Information

Patent Citations

  • Route optimization recommendation method based on clustering and saving algorithms

    CN105528649A

  • Client visit plan generation method and terminal

    CN107871232A

  • Method for automatic optimization of visit route according to GPS position

    CN108491964A

  • Intelligent management method and device for stores

    CN109978292A