JP4178001B2 - Schedule creation device, sales support device, schedule creation method, sales support method, and program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a schedule creation device, a sales support device, a schedule creation method, a sales support method, and a program. In particular, the present invention relates to a schedule creation device, a sales support device, a schedule creation method, a sales support method, and a program that support the seller by creating a schedule for the seller who sells the product.
[0002]
[Prior art]
A seller who sells products sets sales activities necessary for selling products based on his own experience, and creates a schedule based on the set sales activities.
[0003]
[Problems to be solved by the invention]
However, inexperienced sellers may not be able to conduct efficient sales activities because it is difficult to set up correct sales activities. The seller also took time to create a schedule.
[0004]
Accordingly, an object of the present invention is to provide a schedule creation device, a sales support device, a schedule creation method, a sales support method, and a program that can solve the above-described problems. This object is achieved by a combination of features described in the independent claims. The dependent claims define further advantageous specific examples of the present invention.
[0005]
[Means for Solving the Problems]
That is, according to the first aspect of the present invention, a schedule creation device for creating a sales schedule for a seller who sells a product, and stores sales activities required for selling the product in association with the type of product. When the product database to be sold and the seller who sells the product are determined, the sales activity managed in association with the type of product to be sold is extracted from the product database, and the seller's existing schedule is acquired. A schedule creation unit is provided that determines the type of product to be sold using the acquired existing schedule and the extracted sales activity, and creates a new sales schedule including a schedule for selling the determined type of product. .
[0006]
The product database further stores the profits generated by selling products in association with the types of products, and the schedule creation unit supports multiple product types when multiple types of products to be sold are determined Determine the number of each type of product to be sold using the profit stored and add a new sales schedule using each number, the acquired existing schedule, and the extracted sales activity May be created.
[0007]
The product database further stores the likelihood indicating the sales potential of the product in association with the type of product, and the schedule creation unit associates with multiple product types when multiple types of products to be sold are determined. The number of items of multiple types to be sold is determined using the stored likelihood, and a new sales schedule is created using each number, the acquired existing schedule, and the extracted sales activities. May be created.
[0008]
A customer database is further provided that stores the sales time when the product should be sold to the customer in association with the customer, and the schedule creation unit determines the customer who should sell the product based on the sales time and the existing schedule. Good.
[0009]
A customer database that stores the types of products to be sold to specific customers in association with specific customers is further provided, and the schedule creation unit determines the types of products when the types of products to be sold are determined. The customer who sells the product may be determined by extracting the customer stored in the customer database in association with the product.
[0010]
According to the second aspect of the present invention, a merchandise sales support apparatus for supporting a merchant who sells merchandise, wherein a service usage history requested to the merchant in the past is stored in association with a customer. Based on the usage history database, the purchase product database that stores the types of products that the customer has purchased in the past in association with the customers, the service usage history, and the types of products that have been purchased in the past, A prospect calculation unit that calculates a likelihood indicating the degree of purchase.
[0011]
A request degree calculating unit that extracts a service usage history from a service usage history database and calculates a request level indicating a size of a service that a customer has requested from a seller in the past based on the extracted service usage history; In addition, the likelihood calculation unit may calculate the likelihood indicating the degree of the prospect that the customer will newly purchase the product based on the calculated request level and the type of the product purchased in the past.
[0012]
According to the third aspect of the present invention, there is provided a merchandise sales support apparatus for supporting a merchant who sells merchandise, the merchant database storing the merchant's skills in association with the merchant, and a specific skill. A skill database that stores sales methods that support the missing sellers in association with specific skills, and skills that are stored in association with sellers that sell products to be sold. A sales skill processing unit that extracts a sales method stored in the skill database in association with the data and outputs it for recommendation to the seller.
[0013]
According to the fourth aspect of the present invention, there is provided a merchandise sales support apparatus for supporting a merchant who sells merchandise, the merchant database storing the merchant's skills in association with the merchant, and a specific skill. Extract the skills database that stores the tools that support the missing sellers in association with specific skills, and the skills that are stored in association with the sellers who sell the products to be sold. A sales skill processing unit that extracts tools stored in the skill database in association with each other and outputs them to recommend to the seller;
[0014]
According to a fifth aspect of the present invention, there is provided a schedule creation method for creating a sales schedule for a seller who sells products, and the computer manages the sales activities required for selling the products in association with the types of products. Product management steps to be performed and when sellers to sell products are determined, sales activities managed in association with the types of products to be sold are extracted, and the seller's existing schedule is acquired and acquired. Using the existing schedule and the extracted sales activity, a type of product to be sold is determined, and a schedule creation step is included in which the computer creates a new sales schedule including a schedule for selling the determined type of product. .
[0015]
In the product management step, the profit generated by selling the product is further managed in association with the product type, and in the schedule creation step, when multiple types of products to be sold are determined, Using the profits stored in association with each other, determine the number of each type of product to be sold, and use each number, the acquired existing schedule, and the extracted sales activities to create a new sale. A schedule may be created.
[0016]
In the product management step, the likelihood indicating the sales potential of the product is further managed by associating it with the type of product, and when multiple types of products to be sold are determined in the schedule creation step, multiple product types are supported The number of items of multiple types of products to be sold is determined using the likelihood stored together, and new sales are made using each number, the acquired existing schedule, and the extracted sales activities. A schedule may be created.
[0017]
A customer management step is also provided in which the computer manages the sales time when the product should be sold to the customer, and in the schedule creation step, the customer who should sell the product is determined based on the sales time and the existing schedule May be.
[0018]
It further comprises a customer management step for managing the types of products to be sold to a specific customer in association with the specific customers, and when the types of products to be sold are determined in the schedule creation step, the types of products By extracting customers managed in association with each other, customers who should sell products may be determined.
[0019]
According to a sixth aspect of the present invention, there is provided a merchandise sales support method for supporting a merchant who sells merchandise, wherein a computer uses a service history requested by the merchant in the past in association with a customer. Based on the service usage history management step to be managed, the purchase product management step managed by the computer by associating the type of product purchased by the customer with the customer in the past, the service usage history, and the type of product purchased in the past A likelihood calculating step of calculating a likelihood indicating a degree of the prospect that the customer will newly purchase the product.
[0020]
The service usage history is extracted, and based on the extracted service usage history, a request level calculation step for calculating a request level indicating the size of the service requested by the customer in the past from the seller is further provided. In the step, based on the calculated request level and the types of products purchased in the past, a likelihood indicating the degree of likelihood that the customer will purchase a new product may be calculated.
[0021]
According to a seventh aspect of the present invention, there is provided a merchandise sales support method for supporting a merchant who sells merchandise, the merchant managing step for managing the merchant's skills in association with the merchant, and a specific skill Skill management steps for managing sales methods that support sellers who are lacking in association with specific skills, and skills managed in association with sellers who sell products to be sold A sales skill processing step of extracting a sales technique managed in association with the skill and outputting it for recommendation to the seller.
[0022]
According to an eighth aspect of the present invention, there is provided a merchandise sales support method for supporting a merchant who sells merchandise, the merchant managing step for managing the merchant's skills in association with the merchant, and a specific skill. Skill management steps for managing tools that support sellers who are lacking in association with specific skills, and skills stored in association with sellers who sell products to be sold A sales skill processing step of extracting a tool stored in association with the skill and outputting the tool for recommendation to the seller.
[0023]
According to the ninth aspect of the present invention, it is a computer program for creating a sales schedule for a seller who sells products, and manages the sales activities required to sell the products in association with the types of products. When the product management function and the seller who sells the product are determined, the sales activities managed in association with the type of product to be sold are extracted, the existing schedule of the seller is acquired, and the acquired existing Using the schedule and the extracted sales activities, a type of product to be sold is determined, and a schedule creation function is provided for creating a new sales schedule including a schedule for selling the determined type of product.
[0024]
The product management function further manages the profits generated by selling products by associating them with product types, and when the schedule creation function determines multiple product types to be sold, Using the profits stored in association with each other, determine the number of each type of product to be sold, and use each number, the acquired existing schedule, and the extracted sales activities to create a new sale. A schedule may be created.
[0025]
The product management function further manages the likelihood indicating the sales potential of the product in association with the product type, and the schedule creation function supports multiple product types when multiple types of products to be sold are determined The number of items of multiple types of products to be sold is determined using the likelihood stored together, and new sales are made using each number, the acquired existing schedule, and the extracted sales activities. A schedule may be created.
[0026]
A customer management function is also provided to manage the sales time when products should be sold to customers in association with the customers. In the schedule creation function, the customers who should sell the products are determined based on the sales time and existing schedule. Also good.
[0027]
A customer management function for managing the types of products to be sold to specific customers in association with specific customers is further provided. When the types of products to be sold are determined by the schedule creation function, the types of products The customer who sells the product may be determined by extracting the customer stored in association with.
[0028]
According to the tenth aspect of the present invention, there is provided a computer program for supporting a seller who sells a product, and a service for managing the usage history of a service requested to the seller in the past in association with the customer. Based on the usage history management function, the purchase product management function that manages the types of products that the customer has purchased in the past, the service usage history, and the types of products that have been purchased in the past A likelihood calculation function for calculating a likelihood indicating the degree of the likelihood of purchasing the product.
[0029]
The service usage history is extracted, and based on the extracted service usage history, a request degree calculation function is further provided to calculate the degree of request indicating the size of the service requested by the customer to the seller in the past. In the function, based on the calculated degree of request and the type of product purchased in the past, the likelihood that the customer is likely to purchase a new product may be calculated.
[0030]
According to an eleventh aspect of the present invention, there is provided a computer program for supporting a seller who sells merchandise, a seller management function for managing a seller's skills in association with the seller, and a specific skill. The skill management function that manages the sales method to support the seller who lacks the product in association with a specific skill, and the skill stored in association with the seller who sells the product to be sold are extracted and extracted. A sales skill processing function for extracting a sales technique managed in association with the skill and outputting it for recommendation to the seller.
[0031]
According to a twelfth aspect of the present invention, there is provided a computer program for supporting a seller who sells products, a seller management function for storing a seller's skills in association with the seller, and a specific skill. The skill management function that stores tools that support sellers who are lacking in association with specific skills and the skills that are stored in association with sellers that sell products to be sold are extracted and extracted. It has a sales skill processing function for extracting a tool managed in association with a skill and outputting it for recommendation to the seller.
[0032]
The above summary of the invention does not enumerate all the necessary features of the present invention, and sub-combinations of these feature groups can also be the invention.
[0033]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, the present invention will be described through embodiments of the invention. However, the following embodiments do not limit the claimed invention, and all combinations of features described in the embodiments are described below. However, this is not always essential for the solution of the invention.
[0034]
FIG. 1 is a block diagram showing a functional configuration of a merchandise sales support apparatus 10 according to the present embodiment. The product sales support apparatus 10 extracts an existing schedule for each seller, determines a product to be sold and a customer to be sold at a vacant date and time in the extracted existing schedule, and creates a sales schedule for the seller. In the present embodiment, description will be made using car insurance as an example of a product. The “owned insurance database” according to the present embodiment is an example of the “purchased product database” according to the present invention.
[0035]
The merchandise sales support device 10 includes a schedule creation device 30 that creates a seller's insurance sales schedule. The schedule creation device 30 includes a product database 102 that stores sales activities required for insurance sales, profits generated by selling insurance, types of insurance to be sold to customers, and sales periods that can be sold to customers. And a customer database 106 that stores the likelihood indicating the sales prospect to the customer, and a schedule database 108 that stores the existing schedule of the seller.
[0036]
The merchandise sales support apparatus 10 also includes a owned insurance database 112 that stores information on owned insurance already owned by the customer, and a service usage history database 116 that stores the unit price and date of use of the service used by the customer. .
[0037]
Further, the merchandise sales support apparatus 10 calculates a request level indicating the size of the service requested by the customer in the past based on the usage unit price and usage frequency stored in the service usage history database 116. Based on the requested degree calculation unit 114, the calculated requested degree, and information on the owned insurance stored in the owned insurance database 112, the customer is calculated by calculating the expected degree indicating the degree of expectation that the customer will join the insurance. A prospect calculation unit 110 stored in the database 106.
[0038]
Further, the schedule creation device 30 of the product sales support device 10 accepts the input of the seller from the outside, the seller's existing schedule stored in the schedule database 108, the information stored in the product database 102, and the customer database Based on the information stored in 106, a schedule creation unit 100 that newly creates a sales schedule for the seller is provided.
[0039]
The merchandise sales support apparatus 10 further includes a seller database 122 that stores skills possessed by the seller, a skills database 124 that stores sales techniques and tools that supplement specific skills, and a sales skill processing unit 120. The sales skill processing unit 120 is insufficient when an input of an essential skill, which is a skill necessary for selling a product, is received from the outside and the seller database 122 is searched and the seller does not have the required skill. Sales techniques and tools that supplement essential skills are extracted from the skill database 124.
[0040]
The schedule creation unit 100 displays the created sales schedule, the expectation calculation unit 110 displays the calculated likelihood, and the sales skill processing unit 120 displays the extracted sales technique and tool.
[0041]
With the above configuration, the merchandise sales support apparatus 10 can create a sales schedule for the input person in charge, and can present the created sales schedule and a tool and a sales method for supplementing skills that the person in charge does not have to the user. .
[0042]
The recording medium 20 stores a program for causing the schedule creation unit 100, the expectation calculation unit 110, and the sales skill processing unit 120 to operate. As another method, the merchandise sales support apparatus 10 may acquire such a program via a communication line.
[0043]
FIG. 2 shows an example of the data format of the product database 102. The product database 102 stores information indicating sales activities required for insurance sales and profits generated by selling the insurance in association with the type of insurance. The sales activity includes the time that the seller takes for the insurance business once for the customer, the interval at which the seller operates, and the number of times required for the sales. According to the product database 102, for example, it is assumed that the seller can sell the insurance A to the customer by performing sales for 0.8 hours four times at intervals of three months.
[0044]
Thereby, the merchandise sales support apparatus 10 can create a sales schedule based on the sales activities and profits.
[0045]
FIG. 3 shows an example of the data format of the customer database 106. The customer database 106 associates with the customer the types of products to be sold to the customer, that is, the type of insurance, the sales time when the insurance should be sold to the customer, and the likelihood indicating the degree of likelihood that the customer will purchase the insurance. Store.
[0046]
According to the customer database 106, the type of product to be sold to the customer “Hiroshi Suzuki” is “Insurance A”, and the sales period to be sold is “March to May”. In addition, the degree of expectation that the customer “Hiroshi Suzuki” will purchase “Insurance A” is “0.2”.
[0047]
Thereby, the product sales support apparatus 10 can create a sales schedule based on the customer who should sell the product, the sales time, and the likelihood.
[0048]
FIG. 4 shows an example of the data format of the schedule database 108. The schedule database 108 stores a table indicating an existing schedule for each seller.
[0049]
As the schedule database 108 stores the existing schedule in this way, the merchandise sales support apparatus 10 can extract the vacant schedule of the seller.
[0050]
FIG. 5 shows an example of the data format of the service usage history database 116. The service usage history database 116 stores the type of service used by the customer, the usage unit price of the service, and the usage date in association with the customer. In the present embodiment, the service includes a service that a customer has requested a seller in the past, such as a free service such as purchase of products other than insurance or provision of information related to insurance.
[0051]
Thereby, the merchandise sales support apparatus 10 can calculate the size of the service requested by the customer from the seller based on the type of service used by the customer, the usage unit price of the service, and the usage date.
[0052]
FIG. 6 shows an example of the data format of the seller database 122. The seller database 122 stores the skills of the seller in association with the seller. When the seller has a plurality of skills, the plurality of skills are stored in association with one seller. Skills indicate specific qualifications, period of sales experience, educational background, career, characteristics of sellers, skills and skills of sellers, etc., such as “qualification 1”, “qualification 2”, etc. It is expressed using the type or the degree of skill such as “1 year of sales”.
[0053]
Thereby, the merchandise sales support apparatus 10 can extract the skills of the seller.
[0054]
FIG. 7 shows an example of the data format of the skill database 124. The skill database 124 stores a tool for supporting a seller who lacks a specific skill and a sales technique to be used by a seller who lacks the specific skill in association with the specific skill lacking.
[0055]
The tool is, for example, application software or explanatory material to be used when selling insurance, and the seller can make up for the lack of skills by using the tool. The sales method is information indicating a means for contacting with a customer used when selling insurance and a manual type for selling insurance.
[0056]
Thereby, the merchandise sales support apparatus 10 can extract a tool and a sales method for supporting a seller who lacks a specific skill.
[0057]
FIG. 8 is a flowchart showing the operation of the product sales support apparatus 10. The request degree calculation unit 114 periodically extracts the usage unit price and usage date of the service that each customer has used in the past from the service usage history database 116 (S100).
[0058]
Next, the request level calculation unit 114 calculates the request level indicating the size of the service requested by the customer in the past from the seller, using the usage unit price and usage date of the extracted service. For example, the request level calculation unit 114 calculates the service use frequency using the service use date, and increases the request level as the calculated use frequency increases. The higher the service unit price, the higher the request level (S102).
[0059]
Next, the expectation calculation unit 110 indicates the degree of expectation that the customer will join the insurance based on the request degree calculated by the request degree calculation unit 114 and information on the owned insurance stored in the owned insurance database 112. Calculate the degree. Here, information on owned insurance refers to the type and content of insurance that the customer has already subscribed to, past accident history, insurance participation history, participating agents, insurance premium payment history, family insurance participation status, age, occupation, license Including colors. For example, the request level calculation unit 114 sets the likelihood level high when the request level is high, the number of insurances already subscribed is large, and there is an accident history. Even when the degree of request is high, the likelihood is set low if there is no insurance already subscribed (S104). Next, the expectation calculation unit 110 writes the calculated expectation degree in the customer database 106 in association with the corresponding customer (S106).
[0060]
Thus, the expectation calculation unit 110 can calculate the likelihood indicating the degree of expectation that the customer will join the insurance, and can write it in the customer database 106. Accordingly, the merchandise sales support apparatus 10 can create a sales schedule based on the likelihood.
[0061]
Next, when receiving an input from a seller from the outside (S107), the schedule creation unit 100 extracts an empty schedule by referring to an existing schedule stored in the schedule database 108 in association with the input seller. To do. Next, the schedule creation unit 100 selects the types of products that the seller can sell in the vacant schedule by sequentially applying the sales activities stored in the product database 102 to the extracted vacant schedule. Next, the schedule creation unit 100 extracts, from the customer database 106, a customer that is associated with the selected product type and stored in association with a sales time that includes the date and time of a vacant schedule (S108).
[0062]
Next, the schedule creation unit 100 extracts the profit stored in association with the selected product from the product database 102, and extracts the likelihood stored in association with the extracted customer from the customer database 106. Next, the schedule creation unit 100 uses the extracted profit and likelihood to select a combination of products, the number of sales, and a customer that are expected to have the highest sales. For example, the schedule creation unit 100 selects a combination of products, sales quantity, and customer for which Σ (profit × expectedness) has the maximum value (S110).
[0063]
Next, the schedule creation unit 100 creates a sales schedule by inserting the insurance and customer to be sold in the vacant schedule of the existing schedule based on the selected combination of products, the number of sales, and the customer, and can be viewed by the user (S112).
[0064]
As a result, the merchandise sales support apparatus 10 determines the insurance and the customer to be sold based on the profit generated by selling the insurance and the likelihood that the customer will join the insurance. A schedule can be created.
[0065]
When the sales skill processing unit 120 receives the input of the seller and the essential skills from the outside, the sales skill processing unit 120 extracts the skills stored in association with the seller from the seller database 122 and extracts the input required skills The essential skills that are not included in the skills are determined to be insufficient skills that the seller lacks (S114).
[0066]
Next, the sales skill processing unit 120 extracts and displays the sales method and tool stored in association with the determined insufficient skill from the skill database 124 (S116).
[0067]
As a result, the sales skill processing unit 120 can present a sales technique and tool suitable for a seller who lacks a specific skill.
[0068]
In the present embodiment, the essential skills are input from the outside. As another example, there is a database storing essential skills in association with the type of customer or insurance, and the customer or insurance to be sold is stored. The required skills corresponding to the type may be extracted from the database.
[0069]
Further, the merchandise sales support device 10 further acquires sales information indicating whether or not the sales are performed when the seller performs insurance sales activities for the customer according to the generated sales schedule, and based on the acquired sales information The sales technique and tool stored in the skill database 124 and the likelihood stored in the customer database 106 may be updated. As a result, the merchandise sales support apparatus 10 stores data with higher reliability, and thus can create a sales schedule that can sell insurance more efficiently.
[0070]
The recording medium 20 may store a program that causes the product sales support apparatus 10 to perform the operations of S100 to S116 described above. In this case, the product sales support apparatus 10 reads this program from the recording medium 20 and executes it.
[0071]
As mentioned above, although this invention was demonstrated using embodiment, the technical scope of this invention is not limited to the range as described in the said embodiment. Various modifications or improvements can be added to the above embodiment. It is apparent from the description of the scope of claims that embodiments with such changes or improvements can be included in the technical scope of the present invention.
[0072]
【The invention's effect】
As is apparent from the above description, according to the present invention, the seller can efficiently sell the product.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a functional configuration of a product sales support apparatus 10. FIG.
FIG. 2 is a diagram showing an example of a data format of a product database 102. FIG.
3 is a diagram showing an example of a data format of a customer database 106. FIG.
4 is a diagram showing an example of a data format of a schedule database 108. FIG.
FIG. 5 is a diagram illustrating an example of a data format of a service usage history database 116;
6 is a diagram illustrating an example of a data format of a seller database 122. FIG.
7 is a diagram showing an example of a data format of a skill database 124. FIG.
8 is a flowchart showing the operation of the product sales support apparatus 10. FIG.
[Explanation of symbols]
10 Product sales support device
20 recording media
30 Schedule creation device
100 Schedule creation department
102 Product database
106 Customer database
108 Schedule database
110 Prospect calculation part
112 Insurance database
114 Request level calculator
116 Service usage history database
120 Sales skill processing department
122 Seller database
124 Skill Database

Claims (3)

A product sales support device for supporting a seller who sells a product,
A service usage history database that stores the unit price and date of use of the service that the customer has requested the seller in the past, in association with the customer;
A purchased product database that stores the types of products that the customer has purchased in the past in association with the customer,
The usage price and usage date of the service are extracted from the service usage history database, the usage frequency of the service is calculated from the usage date, and the higher the usage cost and usage frequency, the customer A request level calculation unit that calculates a high request level indicating the size of the service requested in the past;
A prospect calculation unit that calculates a higher degree of expectation indicating a degree of a prospect that a customer will newly purchase a product as the request degree is higher and the number of products that the customer has purchased in the past;
A customer database that stores the likelihood in association with a customer, a product, and a sales time when the product should be sold ;
A product database that stores profits generated by selling products in association with product types;
A schedule database that stores a table showing the existing schedule for each salesperson;
The types of products that the seller can sell in the vacant schedule by calculating the vacant schedule by referring to the existing schedule stored in the schedule database in association with the seller. To extract the customer stored in the customer database in association with the sales date that is associated with the selected product type and includes the scheduled date and time, and extracted from the product database the combination of the product value obtained by multiplying the estimated level of the customer extracted from the customer database is maximized by selecting the sales number and customer, the combination of the products selected, the vacant the sales number and the customer A schedule creation unit that creates sales schedules for products by inserting them into the schedule ,
A seller database that stores the skills of the seller in association with the seller,
A skill database for storing sales techniques and tools for supporting sellers lacking specific skills in association with the specific skills;
A database that stores the required skills associated with a customer or product,
Extracting the skills stored in the seller database in association with the seller selling the product to be sold, the essential skills stored in the database in association with the customer or the product Among them, the essential skills that are not included in the extracted skills are determined as insufficient skills, the sales method and the tools stored in the skill database are extracted in association with the determined insufficient skills, and the seller Sales skill processing department to output to recommend to
A product sales support device comprising: A product sales support method for supporting a seller who sells a product,
A service usage history management step in which a computer stores a usage price and usage date of a service requested by a customer in the past from a seller in a service usage history database in association with the customer;
Purchased products in which the computer stores the types of products purchased by the customer in the past in association with the customers and stores the profit generated by selling the products in the product database in association with the types of products. Administrative steps;
The computer extracts the usage price and usage date of the service from the service usage history database , calculates the usage frequency of the service from the usage date, and the higher the usage price and usage frequency, the customer is the seller. A request level calculation step for calculating a high request level indicating the size of the service requested in the past,
A prospect calculation step for calculating a higher likelihood that a computer indicates a degree of a prospect of purchasing a new product as the degree of request is higher and the number of products purchased by the customer in the past is higher;
Computer, and the expected level management step to be stored in the customer database in association with and when sales should be selling the goods the prospect of customers and the goods,
A schedule management step in which a computer stores a table indicating an existing schedule in a schedule database for each salesperson;
The computer calculates the vacant schedule by referring to the existing schedule stored in the schedule database in association with the seller, and the seller can sell the vacant schedule by referring to the product database. Select a product type, extract a customer stored in the customer database in association with a sales time associated with the selected product type and including the scheduled date and time, and extract from the product database The product obtained by multiplying the profit obtained by multiplying the likelihood of the customer extracted from the customer database , the sales number and the customer are selected, and the selected product combination, the sales number and the customer are selected. by inserting into the empty schedule, and schedule to create a sale schedule of goods And Yuru creating step,
A seller management step in which the computer associates the skills of the seller with the seller and stores it in the seller database;
A skill management step in which a computer stores a sales technique and tools for supporting a seller who lacks a specific skill in the skills database in association with the specific skill;
Storing the required skills in the database in association with the customer or product;
The computer extracts the skill stored in the seller database in association with the seller selling the product to be sold, and is stored in the database in association with the customer or the product. Of the essential skills, the essential skills that are not included in the extracted skills are determined as insufficient skills, the sales methods and tools stored in the skills database are associated with the determined insufficient skills, and the skills are extracted. A product sales support method comprising a sales skill processing step for outputting a recommendation to the seller . A computer program for supporting a seller who sells a product, the service usage history storing the unit price and the date of use of the service that the customer has requested the seller in the past in association with the customer. Management functions,
Purchased product management function that stores the types of products the customer has purchased in the past in association with the customer,
The usage price of the service and the usage date are extracted from the service usage history management function, the usage frequency of the service is calculated from the usage date, and the higher the usage price and the usage frequency, the customer A request level calculation function for calculating a high request level indicating the size of the service requested in the past,
A probability calculation function that calculates a higher degree of expectation indicating the degree of prospect that a customer will newly purchase a product as the request level is higher and the number of products that the customer has purchased in the past;
A customer management function for storing the likelihood in association with a customer, a product, and a sales time when the product should be sold ;
A product management function for storing profits generated by selling products in association with product types;
A schedule management function for storing a table showing an existing schedule for each salesperson;
A vacant schedule is calculated by referring to the existing schedule stored in the schedule management function in association with the seller, and the merchandise that the seller can sell to the vacant schedule by referring to the product management function And the customer stored in the customer management function in association with the sales time that is associated with the selected product type and includes the scheduled date and time is extracted from the product management function. the extracted the benefits, the combination of the product value obtained by multiplying the estimated level of the customer extracted from the customer management function is maximized, select the sales number and customer, the combination of the products selected, the sales number and A schedule creation function for creating a sales schedule of products by inserting the customer into the vacant schedule ,
Merchant management function that stores the skills of the merchant in association with the merchant,
A skill management function for storing sales methods and tools for supporting sellers who lack specific skills in association with the specific skills;
A management function to store required skills in association with customers or products,
Extracting the skill stored in the seller management function in association with the seller selling the product to be sold, and the essential stored in the management function in association with the customer or the product Among the skills, the essential skills that are not included in the extracted skills are determined as insufficient skills, the sales method stored in the skill management function is extracted in association with the determined insufficient skills, and the seller Sales skill processing function to output to recommend
A program that further realizes

Images