JP5096513B2 - Sales support system, sales support method, and sales support program - Google Patents

Description

  The present invention relates to a sales support system, method, and program for supporting sales for a secondary use of a work that has already been released.

  Today, various works are released through various media such as movies and television, and a content business that earns profits using these works is being conducted. Such works involve various parties such as copyright holders and producers (investors), and distribute revenue in the content business.

  Therefore, there is a copyright fee distribution system that distributes the total amount of use / purchase of works by users to right holders, rights brokerage organizations, content holders, etc. related to the contents, and clearly shows the validity. (For example, refer to Patent Document 1). The system described in this document distributes usage fees, which are profits obtained by selling content, to those who have the right to enjoy part of the usage fees (content holders, copyright management companies, right holders). To do. The content management right distribution system has various databases serving as storage means for storing a distribution destination having a right to enjoy a usage fee, a distribution amount for the distribution destination, and the like. The content management right distribution system has a right distribution server that outputs all distribution destinations and distribution amounts for usage fees.

  In some cases, a brokerage business that acquires rights related to works from the owners of various works and sells them to broadcasters may be performed. In view of this, a system that mediates the buying and selling of rights related to program content has also been studied (see, for example, Patent Document 2). The system described in this document is based on personal computers possessed by content sellers such as program production companies and movie production companies, and personal computers possessed by buyers such as terrestrial, BS, CS, or cable television broadcasting stations. To the content distribution mediation system. The buyer can register data related to the content to be sold in the database, and the seller and the buyer negotiate with the buyer on the sales contract of the content and execute a sales contract conclusion process.

Japanese Unexamined Patent Publication No. 2003-196415 (first page, FIG. 1) JP 2002-140555 A (first page, FIG. 1)

For example, income sources in the movie business include box office revenue from screening at a movie theater, income from video sales, income from sales of broadcasting rights, and the like.
In the case of screening in a movie theater, the box office revenue (admission fee sales) is distributed to the box owner (movie theater) according to an individual contract, and the remainder becomes distribution income. Printing costs and advertising expenses (P & A expenses) are top-off as necessary expenses. The distribution company obtains a distribution fee as a ratio determined by the individual contract from the amount obtained by subtracting the P & A expenses from the distribution revenue. The producer (investor) obtains the amount obtained by subtracting the box owner's share, P & A fee, and distribution fee from the box office revenue.

In the case of video sales, revenues are distributed to producers, distributors, distributors, retail stores, etc. according to individual contracts.
In the case of sales of broadcasting rights, a sales window company such as a content holder or an intermediary company may conduct sales to broadcasting companies. In this case, a fee is often paid to the sales counter, but this fee may be determined based on a sales price obtained by multiplying the distribution revenue by a predetermined ratio. Then, the producer is paid the remainder after subtracting the cost for advertising and editing from the selling price, and in the case of brokerage, the brokerage fee.

  As described above, when selling works, it is necessary to distribute revenue to a plurality of parties based on individual contracts. The contents of the individual contracts are diverse, and particularly when there are many related parties, the calculation of profit becomes complicated.

  In addition, a purchaser of a work such as a broadcaster often has a budget for purchasing the work, and the sales window company needs to select a work to be sold in consideration of this budget. Furthermore, it is common for broadcasters and the like to prepare various works in consideration of future program organization. In particular, taking into account sudden program changes, works are often stocked to some extent.

  In addition, the value of a work can be determined with reference to past performances such as box office revenue and audience rating. However, this achievement may be affected by other competing works that were released at the same time. Therefore, there is a possibility that an accurate evaluation cannot be performed depending on the competing works released at the same time.

  The present invention has been made to solve the above-described problems, and provides a sales support system, a sales support method, and a sales support program for supporting sales for a secondary use of a work that has already been released. There is.

In order to solve the above problem, the invention described in claim 1 is related to a work identifier, a work information storage means for recording a keyword, a selling price and a profit calculation formula, and a work identifier associated with each work. A sales support system comprising a balance information storage unit in which data relating to an initial expenditure amount and a cumulative amount of revenue is recorded, and a control unit connected to the user terminal, wherein the control unit receives a budget and a keyword from the user terminal. Means for acquiring, means for extracting a work group consisting of a plurality of works related to the keyword from the work information storage means, and a cumulative amount of revenue recorded in the balance information storage means for the works included in the work group but a means to classify to the recoupment work beyond the initial expenditure, and a non-recoupable work not yet earnings total exceeds the initial expenditure, in the work group In goods, to calculate the package price by summing means for generating a package candidates that combines with the recoupment works and non recoupment works, the selling price of the work constituting each package candidate, this package price falls to the budget A means for identifying a package candidate, a means for calculating a profit amount of each work constituting the package candidate using a profit calculation formula, and calculating a package profit amount by summing up the profits, and configuring the package candidate A summary is provided with means for outputting a package candidate list including each piece of work information and the package revenue to the user terminal.

  The gist of the invention described in claim 2 is that, in the sales support system according to claim 1, the package candidates are arranged and output in order from the highest package revenue in the package candidate list.

The invention according to claim 3 is the sales support system according to claim 1 or 2, wherein the sales information storage means stores information relating to the release time and release results of each work in association with the work identifier ; A correction table in which a correction factor for correcting the release achievement of the work to be processed is recorded using the release achievement, and the control means configures each package candidate from the achievement information storage means Means for obtaining the publication date of the work; means for obtaining the publication results of other competing works published at the same time as the publication time from the result information storage means; and the publication results of the competing works from the correction table. Gets the correction factor corresponding to, by multiplying the correction factor with respect to the public record of each piece making up the package candidate, further comprising means for modifying the public record The modified public performance, and summarized in that the output be included in the package candidate list.

  According to a fourth aspect of the present invention, in the sales support system according to any one of the first to third aspects, the control means further includes means for acquiring the number of package components constituting the package from the user terminal. It is summarized that a package candidate is generated by combining works so as to have the number of package configurations.

The invention described in claim 5 is a piece information storage means that records a keyword, a selling price, and a profit calculation formula in association with a work identifier, and data relating to an initial expenditure amount and a cumulative amount of earnings of each piece in association with the work identifier. Is a method for supporting sales using a sales support system including a balance information storage means recorded with a control means connected to a user terminal, wherein the control means receives a budget and a keyword from a user terminal. A step of obtaining, a step of extracting a work group consisting of a plurality of works related to the keyword from the work information storage means, and a cumulative amount of revenue recorded in the balance information storage means for the works included in the work group but the method to classify to the recoupment work beyond the initial expenditure, and a non-recoupable work not yet earnings total exceeds the initial expenditure, in the work group In goods, to calculate the package price and total and generating a package candidates that combines with the recoupment works and non recoupment works, the selling price of the work constituting each package candidate, this package price falls to the budget Identifying a package candidate, calculating a profit amount of each work constituting the package candidate using a profit calculation formula, calculating the package profit amount by summing the profits, and configuring the package candidate Executing a stage of outputting a package candidate list including each piece of work information and the package revenue to the user terminal.

The invention described in claim 6 is a piece information storage means that records a keyword, a selling price, and a profit calculation formula in association with a piece identifier, and data relating to an initial expenditure amount and a cumulative amount of earnings of each piece in association with the piece identifier. Is a program that supports sales using a sales support system that includes a balance information storage means in which is recorded, and a control means connected to the user terminal, wherein the control means receives the budget and keywords from the user terminal. Means for acquiring, means for extracting a work group consisting of a plurality of works related to the keyword from the work information storage means, and for the works included in the work group, the accumulated revenue amount recorded in the balance information storage means is initial and Recoup work beyond the spending, still it means to be classified as non-recoupment works earnings total does not exceed the initial expenditure, in the work group In goods, to calculate the package price and summing means for generating a package candidates that combines with the recoupment works and non recoupment works, the selling price of the work constituting each package candidates, package the package price falls to the budget Means for identifying candidates, means for calculating the profit amount of each work constituting the package candidate using a profit calculation formula, and calculating the package profit amount by summing up the profits, information on each piece constituting the package candidate And a package candidate list including the package revenue is functioned as means for outputting to the user terminal.

(Function)
According to the first, fifth , and sixth aspects of the invention, the control means acquires a budget and a keyword from the user terminal, and extracts a work group including a plurality of works related to the keyword from the work information storage means. And the package candidate which combined the work in a work group is generated. Next, the package price is calculated by adding the selling prices of the works constituting each package candidate, and the package candidate whose package price falls within the budget is specified. The revenue amount of each work constituting the package candidate is calculated using a revenue calculation formula, and this revenue is added up to calculate the package revenue amount. Then, a package candidate list including each piece of work information constituting the package candidate and the package revenue is output to the user terminal. Thereby, the package candidate which combined the work can be generated according to the budget set by the user. Then, the works can be sold in consideration of the profitability of each package candidate.

According to the invention described in claim 2, in the package candidate list, the package candidates are arranged and output in descending order of the package revenue. As a result, profitable package candidates can be preferentially sold.

  According to the invention described in claim 3, the publication time of each work constituting each package candidate is acquired from the record information storage means. Next, from the achievement information storage means, obtain the publication results of other competing works released at the same time as the publication time, and correct the publication results of each work that constitutes the package candidate using the publication results of the competing works To do. Then, the corrected publication results are included in the package candidate list and output. Thereby, the work to be sold can be evaluated in consideration of the influence of competing works released at the same time.

  According to the fourth aspect of the present invention, the number of package components constituting the package is obtained from the user terminal, and package candidates are generated by combining the works so as to be the number of package components. Thereby, the package candidate which combined the work by the number which a user desires can be generated.

According to the present invention, the works included in the work group are classified into recoup works in which the accumulated amount of revenue exceeds the initial expenditure amount and non-recouped works in which the accumulated amount of revenue has not yet exceeded the initial expenditure amount. Then, a package candidate is generated by combining the recoup work and the non-recoup work. Thereby, the package candidate which combined the work with no bias in profitability can be generated.

  According to the present invention, it is possible to provide a sales support system, a sales support method, and a sales support program for supporting sales for secondary use of works that have already been released.

1 is a system schematic diagram of a first embodiment of the present invention. It is explanatory drawing of the data recorded on each memory | storage part of embodiment of this invention, Comprising: (a) is a work management database, (b) is a balance management database, (c) is an entertainment performance database, (d) is viewing Explanatory drawing of the data recorded on the rate performance database. Explanatory drawing of the process sequence of 1st Embodiment. Explanatory drawing of the process sequence of 1st Embodiment. Explanatory drawing of the process sequence of 1st Embodiment. Explanatory drawing of the process sequence of 2nd Embodiment.

<First Embodiment>
DESCRIPTION OF EMBODIMENTS Hereinafter, embodiments embodying the present invention will be described with reference to FIGS. In this embodiment, a person in charge of a sales window company that sells a work (for example, a work for a movie work or a television program) uses a work that has already been released (primary use) as a third use for secondary use. A sales support system, a sales support method, and a sales support program used when selling to a broadcaster (for example, a broadcaster) will be described. In particular, in the present embodiment, it is assumed that a package in which a plurality of works are collected and output as a sales candidate for this package.

  In the present embodiment, as shown in FIG. 1, the sales support server 20 (sales support system) executes a sales support process for generating package candidates. A client terminal 10 is connected to the sales support server 20 via a network.

The client terminal 10 is a computer terminal (user terminal) used by a person in charge of selling works. The client terminal 10 is used when a person in charge accesses the sales support server 20. The client terminal 10 has a function of transmitting data via a network, a function of displaying received data, and the like. For this reason, the client terminal 10 includes an input unit such as a keyboard and a mouse, an output unit such as a display, a communication unit, and the like in addition to a CPU, RAM, and ROM (not shown).

  The sales support server 20 is a computer system that performs various data processing related to sales support based on data received from the client terminal 10. The sales support server 20 includes a control unit 21, a work management database 22, a balance management database 23, an entertainment performance database 24, an audience rating performance database 25, and a candidate storage unit 27. The work management database 22 functions as a work information storage unit, the balance management database 23 functions as a balance information storage unit, and the performance record database 24 and the audience rating record database 25 function as a record information storage unit.

  The control unit 21 functions as a control unit that performs various data management processing for performing sales support processing. The control unit 21 includes a CPU, RAM, ROM, and the like (not shown). Then, processing described later (support management stage, package generation stage, reevaluation stage, balance calculation stage, etc.) is executed. By executing the sales support program for this purpose, the control unit 21 includes support management means 211, package generation means 212, reevaluation means 213, and balance calculation means 214 as shown in FIG.

  The support management unit 211 receives a request from a person in charge from the client terminal 10 and executes a process of outputting a package candidate generated in response to the request. The support management unit 211 includes a request reception memory that temporarily stores a budget amount acquired from a client terminal, the number of package components, and a keyword.

The package generation unit 212 extracts a work in response to a request from the person in charge, and executes a process of generating a package candidate using the extracted work.
The re-evaluation means 213 executes processing for correcting the evaluation (box performance and audience rating) of each work. For this correction, the re-evaluation means 213 holds a box office income correction table and an audience rating correction table. In the box office revenue correction table, the correction rate for correcting the box office revenue of the work to be processed is recorded using the box office revenue of the competing works. In the audience rating correction table, a correction rate for correcting the audience rating of the processing target work is recorded using the audience rating of the competing work.

  The balance calculation means 214 executes a process for calculating the balance of works included in the package candidates. The balance calculation means 214 holds a balance item table for all balance items that may occur in a predetermined period (prediction period) for predicting the future balance.

  In the work management database 22, a work management record 220 relating to works handled by the sales contact company is recorded. This work management record 220 is registered when a license is acquired for a work. In the work management record 220, as shown in FIG. 2A, data relating to a work code, a genre, a related keyword, a publication date, a sales price, a expenditure calculation formula, and a profit calculation formula are recorded.

In the work code data area, data relating to an identifier (work identifier) for specifying each work is recorded.
In the genre data area, data relating to an identifier for specifying the field to which the work belongs is recorded.

  In the related keyword data area, data related to keywords related to this work is recorded. In the present embodiment, the original author, director, performer, etc. of this work are registered as related keywords.

In the publication date data area, data on the date (year) when this work was first published is recorded.
In the sales price data area, data related to the sales price of this work is recorded.

  In the expenditure calculation formula data area, data relating to a calculation formula for calculating the amount of expenditure to be paid when selling this work is recorded for each balance item. In the present embodiment, this expenditure includes expenses such as P & A expenses, arts and literary expenses such as usage fees and additional compensation, and distributions paid to investors.

  In the income calculation formula data area, data relating to the income calculation formula for calculating the company's revenue when this work is sold is recorded for each balance item. This revenue includes sales commissions and distributions in the case of investors.

  In the present embodiment, the revenue calculation formula is configured by the expenditure calculation formula and the revenue calculation formula. In each calculation formula, a function with the variable of income or the like is set when a fixed amount is set. Then, for the predetermined period in the future (forecast period), the revenue obtained by subtracting the expected expenditure calculated by the expenditure calculation formula from the expected revenue calculated by the revenue calculation formula is the share (expected revenue amount) of this sales window company. Become.

  In the balance management database 23, a balance management record 230 relating to the balance record of works handled by this sales counter company is recorded. This balance management record 230 is recorded when the amount of expenditure or the amount of revenue of a work is registered. In the balance management record 230, as shown in FIG. 2B, data relating to the work code, the date of occurrence, the balance item, and the balance amount are recorded.

In the work code data area, data relating to an identifier for specifying each work is recorded.
In the generation date data area, data related to the date on which payment or income was generated for this work is recorded.

  In the balance item data area, data on the basis of payment and income generated for this work is recorded. For example, expenditures are incurred at each sale, such as production expenses, P & A expenses, etc. that are initially generated (initial expenses), internal expenses related to sales, additional usage fees (rewards), distributions, etc. There is expenditure (expenditure each time). In the balance item data area, balance identification information for identifying initial expenditure and expenditure each time is recorded. Further, the income includes a box office income, a video sales income, and the like, and income and expenditure identification information indicating income is recorded in the income and expenditure item data area.

  In the balance amount data area, data relating to the amount of expenditure paid for this work and the amount of income acquired are recorded. Then, by identifying the expenditure and income by the balance identification information, it is possible to calculate the initial expenditure amount, the accumulated income amount, and the accumulated expenditure amount each time. Furthermore, the total amount of income can be calculated by subtracting the total amount of expenditure from the total amount of income.

  The performance record database 24 records the performance record 240 regarding the performance of each work (movie). The box office record 240 is recorded when a public box office record is obtained and registered. As shown in FIG. 2 (c), the performance record record 240 records data relating to the work code, the performance period, and the box office revenue.

In the work code data area, data relating to an identifier for specifying each work is recorded.
In the box office data area, data relating to the screening period (release time) of this work in the movie theater is recorded.
In the box office revenue data area, data relating to box office revenue (total sales obtained from entrance fee at a movie theater) is recorded as a public performance in the box office period.

  In the audience rating record database 25, an audience rating record 250 relating to the audience rating when this work (television program) is broadcast is recorded. This audience rating record 250 is recorded when audience rating information is obtained from an audience rating research organization and registered. As shown in FIG. 2D, the audience rating record 250 records data relating to the work code, the broadcast date (release date), and the audience rating.

In the work code data area, data relating to an identifier for specifying each work is recorded.
In the broadcast date data area, data related to the date and time of the television broadcast are recorded.
In the audience rating data area, data relating to the audience rating is recorded as a public performance at the time of broadcasting.

  The candidate storage unit 27 temporarily stores candidate work records for sales candidate works and package candidate records related to package candidates generated by combining candidate works. This candidate work record and package candidate record are recorded when a package to be sold is generated.

In the candidate work record, data on the balance record, the balance forecast, the corrected box office income, and the corrected audience rating are recorded for each work code.
Data relating to an identifier for specifying each candidate work is recorded in the work code data area.

In the balance record data area, data on the balance amount obtained by subtracting the cumulative amount of expenditure each time from the cumulative amount of income of this candidate work is recorded.
In the income / expenditure prediction data area, data on the expected expenditure and the expected income when this candidate work is sold is recorded.

In the corrected box office data area, data relating to the correction value of the box office income of the candidate work is recorded.
In the corrected audience rating data area, data relating to the correction value of the audience rating of this candidate work is recorded.

  In addition, the package candidate record stores data regarding the work code of the component work, the package sales price, the package balance record, the package balance prediction, and the determination flag for each package candidate identifier.

In the package candidate identifier, data relating to an identifier for specifying each package candidate generated by combining candidate works is recorded.
In the work code data area, data relating to an identifier for specifying each candidate work constituting the package candidate is recorded.

  In the package sales price data area, data related to the sales price of the package candidate is recorded. The package selling price is calculated by adding up the selling prices of the package candidate component works.

  In the package balance record data area, data relating to the package balance status is recorded. The package balance status is calculated by summing the balance amounts of the component works of this package candidate.

  In the package balance prediction data area, data on the amount of expenditure and the amount of revenue (expected revenue) when this package candidate is sold is recorded. This package revenue prediction is calculated by summing up the revenue and expenditure predictions of the package candidate component works.

  In the determination flag data area, a flag for determining whether or not to output this package candidate as a sales candidate is recorded. If the package sales price exceeds the budget, an “excluded” flag for excluding it from the sales candidate is recorded.

Next, the sales support process of this embodiment will be described. Here, the entire procedure (FIG. 3), package candidate generation processing (FIG. 4), and candidate work reevaluation processing (FIG. 5) will be described in this order.
(Whole procedure)
First, the entire procedure will be described with reference to FIG.

  When creating a package candidate for sale, the person in charge accesses the sales support server 20 using the client terminal 10. In this case, the control unit 21 of the sales support server 20 outputs a menu screen on the display of the client terminal 10. This menu screen displays various selection buttons for performing sales support, and includes a package creation button. When the package creation button is selected, the client terminal 10 transmits a package creation request to the sales support server 20.

  Upon receiving the package creation request, the control unit 21 of the sales support server 20 executes budget information acquisition processing (step S1-1). Specifically, the support management unit 211 of the control unit 21 outputs a budget information input screen on the display of the client terminal 10. This budget information input screen is provided with an input field for inputting a package budget and a transmission execution button. When the budget is input and the transmission execution button is selected, the client terminal 10 transmits the input budget information to the sales support server 20. The support management unit 211 of the control unit 21 temporarily stores the budget acquired from the client terminal 10 in the request reception memory.

  Next, the control unit 21 of the sales support server 20 executes a process for acquiring the number of package components (step S1-2). Specifically, the support management unit 211 of the control unit 21 outputs a package configuration number input screen on the display of the client terminal 10. This package configuration number input screen is provided with an input field and a transmission execution button for inputting the number of works constituting the package. When the package configuration number is input and the transmission execution button is selected, the client terminal 10 transmits the input package configuration number information to the sales support server 20. Then, the support management unit 211 of the control unit 21 temporarily stores the number of package configurations acquired from the client terminal 10 in the request reception memory.

Next, the control unit 21 of the sales support server 20 executes a search keyword acquisition process (step S1-3). Specifically, the support management unit 211 of the control unit 21 outputs a search keyword input screen on the display of the client terminal 10. This search keyword input screen is provided with an input field for inputting a keyword for searching for works constituting the package and a transmission execution button. When a keyword is input and a transmission execution button is selected, the client terminal 10 transmits the input keyword information to the sales support server 20. Then, the support management unit 211 of the control unit 21 temporarily stores the keyword acquired from the client terminal 10 in the request reception memory.

  Next, the control unit 21 of the sales support server 20 executes candidate search processing (step S1-4). Specifically, the support management unit 211 of the control unit 21 searches for a candidate work in the work management database 22 using a keyword acquired from the client terminal 10. Here, the support management unit 211 searches the work management record 220 in which the keyword recorded in the request reception memory is recorded in the genre data area or the related keyword data area.

  Next, the control unit 21 of the sales support server 20 executes a determination process as to whether or not candidate works having the number of package components or more have been extracted (step S1-5). Specifically, the support management unit 211 of the control unit 21 counts the number of candidate works extracted using the work management record 220 extracted from the work management database 22. Then, the support management unit 211 compares the number of package configurations recorded in the request reception memory with the number of extractions.

  Here, when the candidate works exceeding the number of package components cannot be extracted (in the case of “NO” in step S1-5), the control unit 21 of the sales support server 20 executes a search keyword changing process (step S1). -6). Specifically, the support management unit 211 of the control unit 21 outputs a message indicating that the number of package components could not be acquired and a search keyword input screen to the display of the client terminal 10. In this case, the person in charge performs the search again by inputting another keyword.

  On the other hand, when the candidate works more than the number of package components can be extracted (in the case of “YES” in step S1-5), the control unit 21 of the sales support server 20 executes the generation process of the package candidates (step S1-7). ). Specifically, the support management unit 211 of the control unit 21 generates a candidate work record that records the work code recorded in the extracted work management record 220 and records the candidate work record in the candidate storage unit 27. And the package production | generation means 212 of the control part 21 performs the production | generation process of the package candidate shown in FIG. 4 so that it may mention later using this candidate work (works group). During this process, data related to package candidates is recorded in the candidate storage unit 27.

  Next, the control unit 21 of the sales support server 20 executes package candidate output processing (step S1-8). Specifically, the support management unit 211 of the control unit 21 uses package candidate records in which the “exclusion” flag is not recorded in the candidate storage unit 27, and package candidates in which package candidates are arranged in descending order of expected earnings. Generate a list. Then, the support management unit 211 outputs a package candidate screen including the package candidate list to the display of the client terminal 10. Further, the package candidate list includes a revenue forecast of each candidate package, a balance status, and a candidate work list constituting each candidate package. In the candidate work list, the box office revenue or the corrected box office revenue, the audience rating or the corrected audience rating are displayed for each work.

(Package candidate generation process)
Next, package candidate generation processing will be described with reference to FIG.
Here, the control unit 21 of the sales support server 20 executes a candidate combination generation process (step S2-1). Specifically, the package generation means 212 of the control unit 21 selects the number of package configuration pieces recorded in the request reception memory from the extracted candidate works, and generates a package candidate combining the work codes. Next, the package generation unit 212 assigns a package candidate identifier to the generated combination and registers it in the candidate storage unit 27.

And the combination of processing object is specified sequentially and the following processes are repeated for every package candidate.
Here, the control unit 21 of the sales support server 20 executes a package price calculation process (step S2-2). Specifically, the package generation means 212 of the control unit 21 extracts the work management record 220 of the candidate work that constitutes the package candidate from the work management database 22, and specifies the selling price of the candidate work. Then, the package generation unit 212 calculates the package price by adding these sales prices.

  Next, the control unit 21 of the sales support server 20 executes a determination process as to whether the package price is within the budget (step S2-3). Specifically, the package generation unit 212 of the control unit 21 compares the package price with the budget recorded in the request reception memory.

  When the package price is within the budget (in the case of “YES” in step S2-3), the control unit 21 of the sales support server 20 identifies the works that make up the package candidate to be processed and Repeat the process.

  Here, the control unit 21 of the sales support server 20 executes a reevaluation process of the constituent works (step S2-4). Specifically, the re-evaluation means 213 of the control unit 21 reviews the box office revenue and the audience rating of the package candidate constituent works, as will be described later.

  Next, the control unit 21 of the sales support server 20 executes a balance calculation process of the constituent works (step S2-5). Specifically, the balance calculation means 214 of the control unit 21 acquires the balance amount (expenditure amount or income amount) of the constituent works from the balance management database 23. Then, the balance calculation means 214 calculates a total amount of revenue obtained by subtracting the total amount of expenditure from this total amount of revenue, and records it in the candidate storage unit 27 as the actual balance.

  Furthermore, the balance calculation means 214 uses the balance item table to identify balance items (items for which there is no balance record) that may occur within the forecast period. Next, the balance calculation means 214 calculates an expected expenditure amount and an expected revenue amount for the prediction period using the expenditure calculation formula and the revenue calculation formula recorded in the work management record 220 for each identified balance item. Then, the balance calculation means 214 calculates an expected income amount obtained by subtracting the expected expenditure amount from the expected income amount, and records it in the candidate storage unit 27.

  When the repetition for each component work of the package candidate to be processed is completed, the control unit 21 of the sales support server 20 executes a package candidate balance calculation process (step S2-6). Specifically, the package generation unit 212 of the control unit 21 calculates the accumulated revenue amount of the package candidate by summing the accumulated revenue amounts of the constituent works included in the package candidates to be processed. And it records in the candidate memory | storage part 27 as a package balance result.

  Further, the package generation means 212 calculates the balance prediction of this package candidate by summing the expected expenditure amount and the expected revenue amount of each component work included in the package candidate to be processed, and records it in the candidate storage unit 27. To do.

  If the package price exceeds the budget (“NO” in step S2-3), the control unit 21 of the sales support server 20 executes an exclusion flag setting process (step S2-7). Specifically, the package generation unit 212 of the control unit 21 records an “exclusion” flag in the package candidate record recorded in the candidate storage unit 27, and ends the processing for this package candidate.

The above processing is repeated for each combination.
(Candidate work re-evaluation process)
Next, the reevaluation process (step S2-4) of the candidate work (package candidate constituent work) will be described with reference to FIG.

This process is repeated by specifying a work code to be processed for each candidate work.
Here, the control unit 21 of the sales support server 20 executes a box office revenue information acquisition process (step S3-1). Specifically, the re-evaluation unit 213 of the control unit 21 extracts the performance record record 240 in which the work code to be processed is recorded from the performance record database 24.

  Next, the control unit 21 of the sales support server 20 executes a process for searching for works having the same performance time (step S3-2). Specifically, the re-evaluation means 213 of the control unit 21 acquires the performance period recorded in the extracted performance record 240. And the reevaluation means 213 searches the performance record 240 of the other work in which the period which overlaps with this performance period was recorded.

  Next, the control unit 21 of the sales support server 20 executes a determination process as to whether or not there are competing works (step S3-3). Specifically, the re-evaluation means 213 of the control unit 21 specifies the work code of the performance record 240 for other works with overlapping performance periods from the work management database 22, and the work in which this work code is recorded. The management record 220 is extracted. Then, the reevaluation unit 213 compares the genre recorded in the work management record 220 to be processed with the genre recorded in the work management record 220 of other competing works. Here, when a genre is common, it determines with a competition work.

  When it is determined that there is a competing work (in the case of “YES” in step S3-3), the control unit 21 of the sales support server 20 executes a calculation process of corrected box office income (step S3-4). Specifically, the re-evaluation means 213 of the control unit 21 acquires the box office income recorded in the box office performance record 240 of the competing work. And the reevaluation means 213 acquires the correction factor corresponding to the box office income of a competing work from the box office revenue correction table. Then, the re-evaluation means 213 calculates the corrected box office income by multiplying the box office income of the work to be processed by this correction factor, and records it in the candidate storage unit 27.

On the other hand, when it is determined that there is no competing work (in the case of “NO” in step S3-3), the corrected box office income calculation process (step S3-4) is skipped. In this case, the reevaluation unit 213 records the box office income of the work to be processed in the candidate storage unit 27.
Next, the control unit 21 of the sales support server 20 executes audience rating information acquisition processing (step S3-5). Specifically, the re-evaluation means 213 of the control unit 21 extracts the audience rating record 250 in which the work code to be processed is recorded from the audience rating database 25.

  Next, the control unit 21 of the sales support server 20 executes a process for searching for works with overlapping broadcast times (step S3-6). Specifically, the re-evaluation means 213 of the control unit 21 acquires the broadcast date and broadcast time zone recorded in the extracted audience rating record 250. Then, the re-evaluation means 213 searches the audience performance record 250 of other works in which the same broadcast date and broadcast time zone as the work to be re-evaluated are recorded.

Next, the control unit 21 of the sales support server 20 executes a determination process as to whether or not there are competing works (step S3-7). Specifically, the re-evaluation means 213 of the control unit 21 identifies the work code of the audience rating record 250 for other works with overlapping broadcast time zones, and creates a work management record 220 in which this work code is recorded. Extracted from the work management database 22. Then, the genre recorded in the work management record 220 to be processed is compared with the genre recorded in the work management record 220 of another competing work. Here, when a genre is common, it determines with a competition work. In the present embodiment, when a plurality of works are extracted in a common genre, the work with the highest audience rating is treated as a competing work.

  When it is determined that there is a competing work (in the case of “YES” in step S3-7), the control unit 21 of the sales support server 20 executes a corrected audience rating calculation process (step S3-8). Specifically, the re-evaluation means 213 of the control unit 21 acquires the audience rating recorded in the audience rating performance record 250 of the competing work. Then, the re-evaluation unit 213 acquires a correction rate corresponding to the audience rating of the competing work from the audience rating correction table. Then, the re-evaluation means 213 calculates the corrected audience rating by multiplying the audience rating of the work to be processed by this correction rate, and records it in the candidate storage unit 27.

On the other hand, when it is determined that there is no competing work (“NO” in step S3-7), the corrected audience rating calculation process (step S3-8) is skipped. In this case, the reevaluation unit 213 records the audience rating of the processing target work in the candidate storage unit 27.
The above process is repeated for each candidate work.

As described above, according to the present embodiment, the following effects can be obtained.
(1) In the above embodiment, the control unit 21 of the sales support server 20 executes candidate search processing (step S1-4). When more than the number of package components can be extracted (in the case of “YES” in step S1-5), the control unit 21 of the sales support server 20 executes a generation process of package candidates (step S1-7). Then, in the package candidate generation process, a candidate whose package price is within the budget is selected. Thereby, the package candidate within a budget can be produced | generated by the work of a desired package structure number.

  (2) In the above-described embodiment, the control unit 21 of the sales support server 20 executes package candidate output processing (step S1-8). Specifically, the support management unit 211 of the control unit 21 outputs a package candidate screen listing the generated package candidates to the display of the client terminal 10. On this package candidate screen, a package candidate list arranged in the order of the highest revenue prediction when each package is sold is displayed. Thereby, advantageous sales with high profitability can be supported.

  (3) In the above-described embodiment, the control unit 21 of the sales support server 20 executes a candidate product re-evaluation process (step S2-4). Here, the control unit 21 of the sales support server 20 executes a corrected box office income calculation process (step S3-4) and a corrected audience rating calculation process (step S3-8). Thereby, it is possible to calculate an evaluation index that takes into consideration the influence when competing works are simultaneously released.

  The package candidate list includes the revenue of each candidate package, the income and expenditure status, and a list of works constituting each candidate package. In this work list, the corrected box office income and the corrected audience rating are displayed for each work. Thereby, it is possible to make a package proposal with reference to the corrected index (enterprise income, audience rating).

<Second Embodiment>
A second embodiment embodying the present invention will be described with reference to FIG. In addition, since 2nd Embodiment is the structure which added the recoup process to 1st Embodiment, the detailed description is abbreviate | omitted about the same part. In the present embodiment, as shown in FIG. 6, the works are classified into a plurality of attributes (recoup works, non-recoup works) according to the collection status (recoup status) of investment (initial expenditure) for the work, and this attribute is used. To generate package candidates. Unrecouped works are further classified into works that are likely to be recouped and works that are less likely to be recouped. In this case, the controller 21 is provided with a recoupling determination unit. This recoup determination means holds data relating to an evaluation reference period for extracting similar works that have passed a predetermined period from the first publication date.

  Further, in the package candidate record recorded in the candidate storage unit 27, the recoupment status is recorded for the work code. The re-coup determination means determines whether or not the investment in the work has been recovered, and executes a process of classifying the work based on this determination.

With reference to FIG. 6, the process of determining the recouping of candidate works will be described.
This process is also repeatedly performed by specifying a work code to be processed for each candidate work.
The control unit 21 of the sales support server 20 executes a balance information acquisition process (step S4-1). Specifically, the recoup determination means of the control unit 21 extracts the balance management record 230 in which the work code to be processed is recorded from the balance management database 23.

  Next, the control part 21 of the sales support server 20 performs the determination process about whether it has been recoupped (step S4-2). Specifically, the recoup determination unit of the control unit 21 calculates the total amount of income by summing the amounts of income recorded in the balance management record 230. In addition, the recoupling determination means calculates the total expenditure amount each time by summing the expenditure amounts recorded in the balance management record 230. Next, the recoup determination means calculates the accumulated revenue amount by subtracting the accumulated expenditure amount from the accumulated revenue amount each time. Then, the recoupling determination means determines whether or not recouping is performed by comparing the accumulated earnings and the initial expenditure. When the accumulated amount of revenue exceeds the initial expenditure, it is determined that the recoupment has been completed.

  When recoupling has been completed (in the case of “YES” in step S4-2), the control unit 21 of the sales support server 20 executes a first attribute classification process (step S4-3). Specifically, the recoup determination unit of the control unit 21 records the first flag for the work code of the candidate work in the candidate storage unit 27.

  On the other hand, when recoupling has not been completed (in the case of “NO” in step S4-2), the control unit 21 of the sales support server 20 executes a process of searching for similar performances (step S4-4). Specifically, the re-coup determination means of the control unit 21 is a work having the same genre or related keyword of the candidate work, and a work whose evaluation reference period has passed since the first publication date, Search at 22. Next, the recoup determination means acquires the work code recorded in the extracted work management record 220, and extracts the balance management record 230 in which this work code is recorded from the balance management database 23.

  Next, the control unit 21 of the sales support server 20 executes a re-coup rate calculation process (step S4-5). Specifically, the recoup determination means of the control unit 21 counts the number of works (recoup works) in which the accumulated amount of revenue exceeds the total initial expenditure in the balance management record 230. Then, the recoup determination means calculates a ratio (recoup ratio) of the number of recoup works to the total number of all similar works.

  Next, the control unit 21 of the sales support server 20 executes a determination process as to whether or not recouping is possible (step S4-6). Specifically, the recup determination unit of the control unit 21 determines whether or not recoup is possible using the calculated recoup rate. Here, when the recoupling ratio exceeds a reference value (for example, 50%), it is determined that the work to be processed can be recouped.

If it is determined that recouping is possible (“YES” in step S4-6), the control unit 21 of the sales support server 20 executes a second attribute classification process (step S4-7). Specifically, the recoup determination unit of the control unit 21 records the second flag as the recoupment status in the candidate storage unit 27 for the work code of the candidate work.

  On the other hand, if it is determined that recouping is impossible (“NO” in step S4-6), the control unit 21 of the sales support server 20 executes a third attribute classification process (step S4-8). Specifically, the recoup determination means of the control unit 21 records the third flag as the recoupment status in the candidate storage unit 27 for the work code of this candidate work.

The above process is repeated for each candidate work.
Using the works classified in this way, the control unit 21 of the sales support server 20 executes a process for generating a combination of candidate works (step S2-1). Specifically, the package generation unit 212 of the control unit 21 assigns the number of package configurations recorded in the request reception memory to each attribute. In the present embodiment, an integer value (allocated number) is calculated by dividing the number of package components by the number of attributes (here, “3”). Next, the package generation unit 212 distributes the number of packages that are insufficient for the number of package components to an arbitrary attribute and adds the number to the number of allocation. Then, the package generation unit 212 generates a package candidate by a combination of extracted works corresponding to the number of assignments from the work group with each attribute. Hereinafter, the processing after (Step S2-2) is executed for the generated package candidate.

As described above, according to the present embodiment, in addition to the effects (1) to (3), the following effects can be obtained.
(4) In the above embodiment, when recoupling has been completed (in the case of “YES” in step S4-2), the control unit 21 of the sales support server 20 executes the first attribute classification process (step S4-3). If it is determined that recouping is possible (“YES” in step S4-6), the control unit 21 of the sales support server 20 executes a second attribute classification process (step S4-7). When it is determined that recouping is impossible (“NO” in step S4-6), the control unit 21 of the sales support server 20 executes a third attribute classification process (step S4-8). Thereby, a work can be classified according to a recoup situation, and a work can be extracted from each attribute. Therefore, it is possible to suppress the generation of package candidates made up of works that are biased in the recoup situation.

In addition, you may change the said embodiment into the following aspects.
In the above-described embodiment, the control unit 21 of the sales support server 20 executes candidate work re-evaluation processing (step S2-4). Here, the box office revenue and audience rating are reviewed, but the evaluation target is not limited to these. For example, the evaluation may be reviewed based on the motivation viewed in the primary use. Specifically, a questionnaire about advertisements that have motivated viewers is given to viewers. Then, the result of the questionnaire and the cost for the advertisement are input to the sales support server 20. In this case, the re-evaluation means 213 of the control unit 21 calculates the correlation between the advertising advertisement that has become a motivation and the cost for the advertising advertisement. If there is no correlation between the two, the re-evaluation means 213 corrects the box office revenue and the audience rating, assuming that an accurate advertisement has not been performed. Thereby, the evaluation with respect to a work can be reviewed by the accuracy of the advertising method.

  In the above embodiment, the control unit 21 of the sales support server 20 executes package candidate output processing (step S1-8). Specifically, the support management unit 211 of the control unit 21 generates a package candidate list in which the package candidates recorded in the candidate storage unit 27 are arranged in descending order of expected earnings. Here, the output order of the package candidates is not limited to the order in which the expected earnings amount is high. For example, for the works constituting the package candidate, an evaluation index obtained by adding up the corrected box office income and the corrected audience rating may be calculated and arranged using the evaluation index.

  In the above-described embodiment, when the candidate works exceeding the number of package components cannot be extracted (in the case of “NO” in step S1-5), the control unit 21 of the sales support server 20 executes the search keyword changing process. (Step S1-6). Instead of this, candidate works close to the input budget and the number of package components may be output. Specifically, the support management unit 211 of the control unit 21 of the sales support server 20 performs correction to increase the budget until the target number of package components is reached, and outputs candidate works according to the correction result. Further, even if the package configuration number is not reached, the support management unit 211 may output the extracted candidate works. This makes it possible to make a new proposal with a revised budget and the number of package components.

  In the above embodiment, the control unit 21 of the sales support server 20 executes candidate search processing (step S1-4). In this case, the support management unit 211 searches the work management record 220 in which the keyword recorded in the request reception memory is recorded in the genre data area or the related keyword data area. Here, designation of a broadcast time zone may be received from a broadcaster and a search may be performed using this broadcast time zone. In this case, the support management unit 211 of the control unit 21 stores a viewer identification table in which viewer group information (for example, age group) is recorded in correspondence with the broadcast time zone. Further, the work management record 220 records information for specifying the audience layer that is the target of each work.

  And the support management means 211 specifies a viewer layer in a viewer specific table according to the input broadcast time slot | zone. Next, the support management unit 211 extracts the work management record 220 in which the viewer layer is recorded. As a result, it is possible to generate a package including not only the genre and related keywords but also the works extracted in accordance with the broadcast time zone.

  In the above embodiment, the control unit 21 of the sales support server 20 executes a determination process as to whether or not there are competing works (step S3-7). Here, when a plurality of works are extracted in a common genre, the work with the highest audience rating is treated as a competing work. The competing work is not limited to the work with the highest audience rating. For example, a total value of the audience ratings of other works having a higher audience rating with respect to the work to be processed may be used.

  In the second embodiment, works are classified into a plurality of attributes according to the recoup situation, but the work classification method is not limited to this. A plurality of attributes may be provided for the sales price, the box office revenue, the audience rating, the corrected box office revenue, the corrected audience rating, etc., and the works may be classified according to these attributes. This makes it possible to generate package candidates with little uneven distribution of attributes.

  In the second embodiment, the control unit 21 of the sales support server 20 executes a re-coup rate calculation process (step S4-5). And the control part 21 of the sales assistance server 20 performs the determination process about whether recoupling is possible (step S4-6). Here, the ratio of the number of recouped works (recoup ratio) is calculated for all similar works to determine the possibility of recouping. The determination method of the possibility of recouping is not limited to this. For example, for each work, a balance history in which expenditure and income are recorded with respect to time is recorded. Then, other preceding works in common with the balance history of the work to be processed are searched. The future balance of the work to be processed may be predicted using the balance history of the preceding work.

  DESCRIPTION OF SYMBOLS 10 ... Client terminal, 20 ... Sales support server, 21 ... Control part, 211 ... Support management means, 212 ... Package generation means, 213 ... Re-evaluation means, 214 ... Balance calculation means, 22 ... Work management database, 23 ... Balance management Database, 24 ... box office performance database, 25 ... audience rating performance database, 27 ... candidate storage unit.

Claims (6)

A work information storage means that records a keyword, a selling price, and a profit calculation formula in association with the work identifier;
Revenue and expenditure information storage means in which data relating to the initial expenditure amount and the total amount of income of each work is recorded in association with the work identifier;
A sales support system comprising a control means connected to a user terminal,
The control means is
Means for obtaining a budget and keywords from a user terminal;
Means for extracting a work group composed of a plurality of works related to the keyword from the work information storage means;
The works included in the work group are classified into recoup works in which the accumulated revenue recorded in the balance information storage means exceeds the initial expenditure and unrecouped works in which the accumulated earnings still does not exceed the initial expenditure. Means to
Means for generating a package candidate combining the recouped work and the non-recouped work in the work in the work group;
Calculate the package price by adding the selling prices of the works that make up each package candidate,
Means for identifying package candidates whose package price falls within the budget;
Means for calculating the revenue of each work constituting the package candidate using a revenue calculation formula, and calculating the package revenue by adding the revenue;
A sales support system comprising: means for outputting a package candidate list including each piece of work information constituting the package candidate and the package revenue amount to the user terminal.   2. The sales support system according to claim 1, wherein in the package candidate list, package candidates are arranged and output in descending order of package revenue. A record information storage means for accumulating information on the release time and release results of each work in association with the work identifier ,
A correction table in which a correction factor for correcting the release achievement of the work to be processed is recorded using the release achievement of the competing work ;
The control means is
Means for obtaining the release time of each work constituting each package candidate from the record information storage means;
Means for acquiring the publication results of other competing works published at the same time as the publication time from the achievement information storage means;
Means for obtaining a correction rate corresponding to the published performance of the competing work from the correction table, and correcting the published performance by multiplying the published performance of each work constituting the package candidate by the correction rate. In addition,
The sales support system according to claim 1 or 2, wherein the corrected publication results are output by being included in a package candidate list. The control means further comprises means for obtaining the number of package components constituting the package from the user terminal,
The sales support system according to any one of claims 1 to 3, wherein a package candidate is generated by combining works so that the number of package components is the same. A work information storage means that records a keyword, a selling price, and a profit calculation formula in association with the work identifier;
Revenue and expenditure information storage means in which data relating to the initial expenditure amount and the total amount of income of each work is recorded in association with the work identifier;
A method for supporting sales using a sales support system comprising a control means connected to a user terminal,
The control means is
Obtaining a budget and keywords from a user terminal;
Extracting a work group consisting of a plurality of works related to the keyword from the work information storage means;
The works included in the work group are classified into recoup works in which the accumulated revenue recorded in the balance information storage means exceeds the initial expenditure and unrecouped works in which the accumulated earnings still does not exceed the initial expenditure. And the stage of
Generating a package candidate combining the recouped work and the non-recouped work in the work in the work group;
Calculate the package price by adding the selling prices of the works that make up each package candidate,
Identifying package candidates whose package price falls within the budget;
Calculating a revenue amount of each work constituting the package candidate using a revenue calculation formula, and summing the revenues to calculate a package revenue amount;
And a step of outputting a package candidate list including each piece of work information constituting the package candidate and the package revenue to the user terminal. A work information storage means that records a keyword, a selling price, and a profit calculation formula in association with the work identifier;
Revenue and expenditure information storage means in which data relating to the initial expenditure amount and the total amount of income of each work is recorded in association with the work identifier;
A program that supports sales using a sales support system including a control means connected to a user terminal,
The control means;
Means for obtaining a budget and keywords from a user terminal;
Means for extracting a work group consisting of a plurality of works related to the keyword from the work information storage means;
For the works included in the work group, the total amount of revenue recorded in the balance information storage means is
A way to classify recoup works that have exceeded the initial spending and non-recoup works whose cumulative earnings have not yet exceeded the initial spending,
Means for generating a package candidate combining the recouped work and the non-recouped work in the work in the work group;
Calculate the package price by adding the selling prices of the works that make up each package candidate,
Means for identifying package candidates whose package price falls within the budget;
Means for calculating the revenue amount of each work constituting the package candidate using a revenue calculation formula, and calculating the package revenue amount by totaling the revenues;
A sales support program for causing a package candidate list including each piece of work information constituting the package candidate and the package revenue to function as means for outputting to the user terminal.

Images