JP7708679B2 - Signboard rent management device, signboard rent management method, and signboard rent management program - Google Patents

Description

The present invention relates to a signboard rent management device, a signboard rent management method, and a signboard rent management program.

Patent document 1 discloses a configuration that can provide information on available locations for outdoor advertising installation.

Utility Model Registration No. 3124771

However, the invention described in Patent Document 1 above had the problem of providing data that individually identifies past contracts, invoices, and payments along with the availability status when it is necessary to check the availability status of an outdoor sign.

The present invention has been made in consideration of the above problems, and aims to provide a signboard rent management device, a signboard rent management method, and a signboard rent management program that, in the outdoor advertising industry, can provide efficient negotiation material by visualizing vacant status by outputting a list of vacant signboards that have no clients on land under contract with the owner in rent negotiation work with the owner.

In order to solve the above-mentioned problems and achieve the object, the signboard rent management device of the present invention is a signboard rent management device equipped with a memory unit and a control unit, the memory unit is equipped with a payment memory means for storing payment destination contract data that links together the payee of the rent, the payment contract start date, the payment contract end date, the section where the signboard is to be installed, and the payment amount, as well as payment data that links together the scheduled payment date, the payee, the payment amount, and whether or not payment has been made, and a billing memory means for storing billing destination contract data that links together the billing destination that requested the installation of the signboard, the billing contract start date, the billing contract end date, the billing cancellation date, the section, and the billing amount, as well as billing data that links together the scheduled billing date, the billing destination, the billing amount, and whether or not payment has been made, and the control unit is equipped with the The system is characterized by comprising: a total payment acquisition means for acquiring a total payment amount calculated by aggregating the already paid payment amount from the payment start month to the target month based on the payment destination contract data and the payment data; a total past income acquisition means for acquiring a total past income amount calculated by aggregating the already paid billing amount from the payment start month to the target month based on the billing destination contract data and the billing data; a vacancy acquisition means for acquiring the number of months elapsed from the billing cancellation date to the target month as a vacancy period based on the billing destination contract data; and a signboard rent management output means for outputting signboard rent management data set by linking the payment destination, the payment contract start date, the payment contract end date, the section, the target month payment amount, the billing destination, the billing cancellation date, the total payment amount, the total past income amount, and the vacancy period.

In addition, in the signboard rent management device according to the present invention, the vacancy acquisition means is characterized in that, if the billing contract data corresponding to the plot is not stored in the billing storage means, the vacancy acquisition means acquires the number of months elapsed from the payment contract start date to the target month as the vacancy period based on the payment contract data.

In addition, in the signboard rent management device according to the present invention, the control unit further includes a cost rate acquisition means for acquiring a cost rate obtained by multiplying the quotient obtained when the total payment amount is the dividend and the total past income amount is the divisor by 100, and the signboard rent management data further includes the cost rate.

In addition, in the signboard rent management device of the present invention, the payee contract data further includes a vacancy allowance period and a cost allowance ratio, the memory unit further includes an alert management master that links and sets a cost comparison criterion between the cost rate and the cost allowance ratio, a vacancy comparison criterion between the vacancy period and the vacancy allowance period, and alert content, the control unit further includes an alert acquisition means that compares the cost rate with the cost allowance ratio and acquires alert content for each section by comparing the result of the comparison between the vacancy period and the vacancy allowance period with the alert management master, and the signboard rent management data further includes the alert content.

In addition, in the signboard rent management device of the present invention, the alert acquisition means acquires the alert contents for each section by comparing the cost comparison result indicating whether the cost rate is greater than the allowable cost rate, the half-cost comparison result indicating whether the cost rate is greater than half the allowable cost rate, the vacancy comparison result indicating whether the vacancy period is longer than the allowable vacancy period, and the double vacancy comparison result indicating whether the vacancy period is shorter than twice the allowable vacancy period with the alert management master.

In addition, in the signboard rent management device according to the present invention, the alert acquisition means is characterized in that, based on the alert management master, if three of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double vacancy comparison result are positive, the alert content is acquired indicating that cancellation consideration is necessary.

In addition, in the signboard rent management device according to the present invention, the alert acquisition means is characterized in that, based on the alert management master, if two of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double vacancy comparison result are positive and two are negative, the alert content is acquired indicating that negotiation is necessary.

In addition, in the signboard rent management device according to the present invention, the alert acquisition means is characterized in that, based on the alert management master, if three of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double vacancy comparison result are negative, the alert content is acquired indicating that caution is required.

The signboard rent management method according to the present invention is a signboard rent management method to be executed by a signboard rent management device having a memory unit and a control unit, the memory unit including a payment memory means for storing payment destination contract data linking the payee of the rent, the payment contract start date, the payment contract end date, the section in which the signboard is to be installed, and the payment amount, as well as payment data linking the scheduled payment date, the payee, the payment amount, and whether or not payment has been made; and a billing memory means for storing billing destination contract data linking the billing destination requested to install the signboard, the billing contract start date, the billing contract end date, the billing cancellation date, the section in which the signboard is to be installed, the billing amount, and billing data linking the scheduled billing date, the billing destination, the billing amount, and whether or not payment has been made. The control unit executes the following steps: when a target month is specified, a total payment acquisition step for acquiring a total payment amount calculated by aggregating the already paid payment amounts from the payment start month to the target month based on the payment destination contract data and the payment data; a total past income acquisition step for acquiring a total past income amount calculated by aggregating the already paid bill amounts from the payment start month to the target month based on the billing destination contract data and the billing data; and a signboard rent management output step for outputting signboard rent management data set by linking the payment destination, the payment contract start date, the payment contract end date, the plot, the target month payment amount, the billing destination, the billing cancellation date, the total payment amount, and the past total income amount.

The signboard rent management program according to the present invention is a signboard rent management program to be executed by a signboard rent management device having a memory unit and a control unit, the memory unit being a payment memory means for storing payment destination contract data linking the payee of the rent, the payment contract start date, the payment contract end date, the section in which the signboard is to be installed, and the payment amount, as well as payment data linking the scheduled payment date, the payee, the payment amount, and whether or not payment has been made; and a billing memory means for storing billing destination contract data linking the billing destination requested to install the signboard, the billing contract start date, the billing contract end date, the billing cancellation date, the section in which the signboard is to be installed, the billing amount, and billing data linking the scheduled billing date, the billing destination, the billing amount, and whether or not payment has been made. means, and the control unit executes the following when a target month is specified: a total payment acquisition step for acquiring a total payment amount calculated by aggregating the already paid payment amounts from the payment start month to the target month based on the payment destination contract data and the payment data; a total past income acquisition step for acquiring a total past income amount calculated by aggregating the already paid bill amounts from the payment start month to the target month based on the billing destination contract data and the billing data; and a signboard rent management output step for outputting signboard rent management data set by linking the payment destination, the payment contract start date, the payment contract end date, the plot, the target month payment amount, the billing destination, the billing cancellation date, the total payment amount, and the total past income amount.

According to the present invention, it is possible to visualize the availability of signboards based on various contract data, billing data, and payment data, and it is possible to display the availability and alerts. In addition, according to the present invention, it is possible to view the operating status of advertisement availability and other things in addition to land rent negotiations. In addition, according to the present invention, it is possible to unify the criteria for selecting negotiation targets by outputting alerts such as "negotiation required" or "consideration of termination required" depending on the situation. In addition, according to the present invention, it is possible to visualize the negotiation target by outputting the availability in a list format. In addition, according to the present invention, it is possible to unify the criteria for selecting negotiation targets by clearly narrowing down the negotiation targets using the alert function, and it is possible to prevent uneven selection of negotiation targets that depends on the judgment of the sales representative. In addition, according to the present invention, it is possible to negotiate contracts that have been overlooked in negotiations so far by conducting negotiations according to certain criteria, and it is possible to reduce land rent costs by the amount of successful negotiations on these contracts. Furthermore, the present invention not only prevents the degradation of information that occurs with conventional manual work, but also enables timely negotiations by enabling instant list output.

FIG. 1 is a block diagram showing an example of the configuration of a signboard rent management device according to the present embodiment. FIG. 2 is a flowchart showing an example of the process of the signboard rent management device in this embodiment. FIG. 3 is a diagram showing an example of the data registration process in this embodiment. FIG. 4 is a diagram showing an example of the data registration process in this embodiment. FIG. 5 is a diagram showing an example of the data registration process in this embodiment. FIG. 6 is a diagram showing an example of the data registration process in this embodiment. FIG. 7 is a diagram showing an example of a registered data configuration in this embodiment. FIG. 8 is a diagram showing an example of the signboard rent management process in this embodiment. FIG. 9 is a diagram showing an example of the signboard rent management process in this embodiment. FIG. 10 is a diagram showing an example of the signboard rent management process in this embodiment. FIG. 11 is a diagram showing an example of the signboard rent management process in this embodiment. FIG. 12 is a diagram showing an example of the signboard rent management process in this embodiment. FIG. 13 is a diagram showing an example of the signboard rent management process in this embodiment. FIG. 14 is a diagram showing an example of the signboard rent management process in this embodiment.

An embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1. Overview]
First, an overview of the present invention will be described.

Traditionally, the outdoor advertising (billboard) industry has had the task of negotiating rent with owners. When carrying out this task, it may be necessary to check the client's contract status (vacancy status), but this requires a procedure of individually reviewing and checking past contracts, billing data, and payment data. As a result, the accuracy of information has decreased and timely negotiations have not been possible. In other words, in the past, the actual work involved identifying targets for rent negotiations and negotiating rent with a sales sensibility.

Therefore, in this embodiment, focusing on the fact that negotiations based on availability allow for more efficient negotiations, a mechanism is provided that can output availability in list format.

In addition, in this embodiment, if there is a vacant period that exceeds the number of months (e.g., six months) set for each landlord contract at the time of output, or if a past client contract has been concluded but the rent payment has reached a certain percentage of the cumulative client income set for each landlord contract, a mechanism is provided to display (e.g., display a list, etc.) an alert (e.g., "Negotiations required" or "Consider termination," etc.). Note that the judgment criteria in this embodiment may be the total past income, the total payment, and/or the cost rate, etc.

2. Configuration
An example of the configuration of the signboard rent management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the signboard rent management device 100 according to this embodiment.

As shown in FIG. 1, the signboard rent management device 100 is a commercially available desktop personal computer. Note that the signboard rent management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The signboard rent management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the signboard rent management device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the signboard rent management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the signboard rent management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes a payment database 106a, a billing database 106b, and an alert management master 106c.

The payment database 106a stores the payee contract data for the land rent, and the payment data. Here, the payment database 106a may store the payee contract data that is set by linking the payee of the land rent, the payment contract start date, the payment contract end date, the plot for installing the signboard, and the payment amount, as well as the payment data that is set by linking the scheduled payment date, the payee, the payment amount, and whether or not payment has been made. The payee contract data may also set the allowable vacancy period and the allowable cost rate.

The billing database 106b stores billing contract data of the billing recipient who requested the installation of the signboard, and billing data. Here, the billing database 106b may store billing contract data that links the billing recipient who requested the installation of the signboard, the billing contract start date, the billing contract end date, the billing cancellation date, the area where the signboard will be installed, and the billing amount, as well as billing data that links the scheduled billing date, the billing recipient, the billing amount, and whether or not payment has been made.

The alert management master 106c is a master that sets the alert contents. Here, the alert management master 106c may be set in such a way that the cost comparison criterion between the cost rate and the cost allowance ratio, the vacancy comparison criterion between the vacancy period and the allowable vacancy period, and the alert contents are linked to each other.

The control unit 102 is a CPU or the like that controls the signboard rent management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of function, the control unit 102 includes a registration unit 102a, a total payment acquisition unit 102b, a total past income acquisition unit 102c, a cost rate acquisition unit 102d, a vacancy acquisition unit 102e, an alert acquisition unit 102f, and a signboard rent management output unit 102g.

The registration unit 102a registers the payee contract data, payment data, billing contract data, billing data, etc. in the memory unit 106.

The total payment acquisition unit 102b acquires the total payment amount obtained by aggregating the amount of payment already paid from the payment start month to the target month. Here, when the target month is specified, the total payment acquisition unit 102b may acquire the total payment amount obtained by aggregating the amount of payment already paid from the payment start month to the target month based on the payment destination contract data and the payment data.

The past total income acquisition unit 102c acquires the past total income for signboard installation. Here, the past total income acquisition unit 102c may acquire the past total income by tallying up the amount of billing already paid from the payment start month to the target month based on the billing contract data and billing data.

The cost rate acquisition unit 102d acquires the cost rate of signboard installation. Here, the cost rate acquisition unit 102d may acquire the cost rate by multiplying the quotient obtained when the total payment amount is the dividend and the total past income amount is the divisor by 100.

The vacancy acquisition unit 102e acquires the vacancy period, which is the period during which the signboard is not installed in the section where the signboard is to be installed. Here, the vacancy acquisition unit 102e may acquire the number of months elapsed from the billing cancellation date to the target month as the vacancy period based on the billing contract data. Furthermore, when the billing contract data corresponding to the section where the signboard is to be installed is not stored in the billing database 106b, the vacancy acquisition unit 102e may acquire the number of months elapsed from the payment contract start date to the target month as the vacancy period based on the payment contract data.

The alert acquisition unit 102f acquires alert contents for each section in which a signboard is to be installed. Here, the alert acquisition unit 102f may acquire alert contents for each section in which a signboard is to be installed by comparing the cost rate with the allowable cost ratio and comparing the vacancy period with the allowable vacancy period with the alert management master 106c. The alert acquisition unit 102f may also acquire alert contents for each section by comparing the cost comparison result indicating whether the cost rate is greater than the allowable cost ratio, the half-cost comparison result indicating whether the cost rate is greater than half the allowable cost ratio, the vacancy comparison result indicating whether the vacancy period is longer than the allowable vacancy period, and the double vacancy comparison result indicating whether the vacancy period is shorter than twice the allowable vacancy period with the alert management master 106c. The alert acquisition unit 102f may also acquire alert contents indicating the need to consider termination when three results of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double vacancy comparison result are positive, based on the alert management master 106c. Furthermore, the alert acquisition unit 102f may acquire an alert content indicating that negotiation is necessary if two of the cost comparison result, half-cost comparison result, vacancy comparison result, and double vacancy comparison result are positive and two are negative, based on the alert management master 106c. Also, the alert acquisition unit 102f may acquire an alert content indicating that caution is required if three of the cost comparison result, half-cost comparison result, vacancy comparison result, and double vacancy comparison result are negative, based on the alert management master 106c.

The signboard rent management output unit 102g outputs signboard rent management data. Here, the signboard rent management output unit 102g may output signboard rent management data that is set by linking the payee, payment contract start date, payment contract end date, plot, target month payment amount, billing destination, billing cancellation date, total payment amount, past total income, and vacancy period. The signboard rent management data may also be set with a cost rate. The signboard rent management data may also be set with alert content.

3. Specific Examples
A specific example of this embodiment will be described with reference to FIGS.

[Signboard land rent management processing]
An example of the signboard rent management process in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a flowchart showing an example of the process of the signboard rent management device 100 in this embodiment.

As shown in FIG. 2, when the user specifies the target month on the vacant signboard rent output screen via the input device 112, the total payment acquisition unit 102b acquires the specified data that sets the target month (step SA-1).

Then, the total payment acquisition unit 102b acquires the total payment amount calculated by tallying up the payment amounts already paid from the payment start month to the target month based on the specified data and the payment destination contract data and payment data stored in the payment database 106a (step SA-2).

Then, the past total income acquisition unit 102c acquires the past total income amount calculated by tallying up the already paid billing amounts from the payment start month to the target month based on the specified data and the billing contract data and billing data stored in the billing database 106b (step SA-3).

Then, the cost rate acquisition unit 102d acquires the cost rate by multiplying the quotient obtained when the total payment amount is the dividend and the total past income amount is the divisor by 100 (step SA-4).

Then, the vacancy acquisition unit 102e acquires the number of months that have elapsed from the billing cancellation date to the target month as the vacancy period based on the billing contract data stored in the billing database 106b (step SA-5).

The alert acquisition unit 102f then acquires the alert contents for each section by comparing the cost comparison result indicating whether the cost rate is greater than the allowable cost rate, the half-cost comparison result indicating whether the cost rate is greater than half the allowable cost rate, the vacancy comparison result indicating whether the vacancy period is longer than the allowable vacancy period, and the double vacancy comparison result indicating whether the vacancy period is shorter than twice the allowable vacancy period with the alert management master 106c (step SA-6).

Then, the signboard rent management output unit 102g displays on the output device 114 the signboard rent management data that is set by linking the payee, payment contract start date, payment contract end date, plot, target month payment amount, billing destination, billing termination date, total payment amount, total past income, cost rate, vacant period, and alert content (step SA-7), and ends the process.

Now, an example of the data registration process in this embodiment will be described with reference to Figs. 3 to 7. Figs. 3 to 6 are diagrams showing an example of the data registration process in this embodiment. Fig. 7 is a diagram showing an example of the registered data configuration in this embodiment.

In this embodiment, as shown in FIG. 3, landlord contract data (payee contract data) with the landlord is registered as landlord contract registration, and by registering the landlord contract, payment data to the landlord is also created as a schedule. Then, in this embodiment, as shown in FIG. 4, if payments up to November have been completed, payment processing (updating the paid FLG and payment date) is performed as payment registration.

In this embodiment, as shown in FIG. 5, client contract data (billing contract data) with the client is registered as client contract registration, and by registering the client contract, billing data for the client is also created as a schedule. In this embodiment, as shown in FIG. 6, billing processing and payment processing are performed for the billing data created from the client contract as billing registration and payment/settlement registration.

In this embodiment, the landlord contract data, client contract data, payment data, and billing data are linked together as shown in FIG. 7. Here, as shown in FIG. 7, in this embodiment, the landlord contract data and client contract data are linked together by the section number.

Furthermore, a specific example of the signboard rent management process in this embodiment will be described with reference to Figures 8 to 14. Figures 8 to 14 are diagrams showing an example of the signboard rent management process in this embodiment.

In this embodiment, as shown in FIG. 8, when the user specifies the target month: 2011/11 on the vacant signboard rent output screen and presses the Excel(R) output button, a window for specifying the file output destination is displayed and the user can specify the file output destination.

In this embodiment, as shown in FIG. 9, since the target month is November 2021, the payment data linked to the landlord contract data that has a checked paid flag (FLG) by November 30, 2021 is targeted, and the payment amounts paid up to the target month are tallied as the total payment amount.

In this embodiment, as shown in FIG. 10, since the target month is November 2021, the billing data linked to the client contract data that has a check in the Paid by November 30, 2021 FLG is targeted, and the billing amounts that have been paid up to the target month are tallied as the total past income.

In this embodiment, as shown in FIG. 11, the cost rate is calculated as "cost rate = total payment amount ÷ total past income amount × 100" and the cost rate is obtained.

In this embodiment, as shown in FIG. 12, the number of months elapsed from the cancellation date set in the client contract data to the target month is acquired as the vacancy period, and if no client contract data exists, the number of months elapsed from the contract start date set in the landlord contract data to the target month is acquired as the vacancy period. Here, in this embodiment, as shown in FIG. 12, if client contract data exists but the cancellation date in the client contract data is blank (= under contract), the vacancy period will be "none."

In this embodiment, as shown in FIG. 13, the comparison result between the cost rate and the allowable cost rate set in the landlord contract data, and the comparison result between the vacancy period and the allowable vacancy period set in the landlord contract data are matched with the alert management master 106c, and the presence or absence of an alert and the alert content are obtained. Here, as shown in FIG. 13, in the alert management master 106c in this embodiment, the alert content may be set as follows: "Consider termination" when there are three or more circles, "Negotiations required" when there are two circles, "Caution required" when there is one circle, and "No alert" when there are no circles. Note that, as shown in FIG. 13, in this embodiment, data in which client contract data exists but the termination date is blank (= under contract) may not be subject to alert acquisition.

In this embodiment, as shown in FIG. 14, an Excel (registered trademark) file is output as the final output, in which the total payment amount, total past income, cost rate, vacancy period, and alert details are linked together. In this way, in this embodiment, an Excel (registered trademark) file is output in which various data are linked together based on the landlord contract data.

[4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)]
This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

5. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using a known method.

In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

In addition, with regard to the signboard rent management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the signboard rent management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the signboard rent management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the signboard rent management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit 106 are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

The signboard rent management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The signboard rent management device 100 may also be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful in industries such as outdoor advertising, such as signboards.

100 Signboard rent management device 102 Control unit 102a Registration unit 102b Total payment amount acquisition unit 102c Past total income acquisition unit 102d Cost rate acquisition unit 102e Vacancy acquisition unit 102f Alert acquisition unit 102g Signboard rent management output unit 104 Communication interface unit 106 Storage unit 106a Payment database 106b Billing database 106c Alert management master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (10)

A signboard rent management device having a memory unit and a control unit,
The storage unit is
a payment storage means for storing payment destination contract data that is set by linking together a payment destination for land rent, a payment contract start date, a payment contract end date, a section for installing a signboard, and a payment amount, and payment data that is set by linking together a scheduled payment date, the payment destination, the payment amount, and whether or not payment has been made;
a billing storage means for storing billing contract data that is set by linking together a billing destination that has requested the installation of the signboard, a billing contract start date, a billing contract end date, a billing cancellation date, the section, and a billing amount, and billing data that is set by linking together a scheduled billing date, the billing destination, the billing amount, and whether or not payment has been made;
Equipped with
The control unit is
a total payment acquisition means for acquiring a total payment amount calculated by tallying up the amount of payment already paid from the payment start month to the target month based on the payment destination contract data and the payment data when the target month is designated;
a past income total acquisition means for acquiring a past income total amount by tallying up the billing amount already paid from the payment start month to the target month based on the billing destination contract data and the billing data;
A vacancy acquisition means for acquiring the number of months elapsed from the billing cancellation date to the target month as a vacancy period based on the billing contract data;
a signboard land rent management output means for outputting signboard land rent management data that is set by linking the payment destination, the payment contract start date, the payment contract end date, the section, the target month payment amount, the billing destination, the billing cancellation date, the total payment amount, the total past income, and the vacant period;
A signboard rent management device comprising: The vacancy acquisition means includes:
A signboard rent management device as described in claim 1, characterized in that if the billing contract data corresponding to the section is not stored in the billing storage means, the number of months elapsed from the payment contract start date to the target month is obtained as the vacant period based on the payment contract data. The control unit is
a cost rate acquisition means for acquiring a quotient obtained by using the total payment amount as a dividend and the total past income amount as a divisor, and multiplying the quotient by 100 as a cost rate;
Further comprising:
The signboard land rent management data is
3. The signboard rent management device according to claim 1, wherein the cost rate is further set. The payment destination contract data is
In addition, the allowable vacancy period and allowable cost rate are set,
The storage unit is
a cost comparison standard between the cost rate and the cost allowable rate, a vacancy comparison standard between the vacancy period and the allowable vacancy period, and an alert management master set by linking the alert contents;
Further comprising:
The control unit is
an alert acquisition means for acquiring the alert contents for each of the sections by comparing the cost rate with the allowable cost rate and comparing the vacancy period with the allowable vacancy period with the alert management master;
Further comprising:
The signboard land rent management data is
4. The signboard rent management device according to claim 3, further comprising settings for the alert content. The alert acquisition means includes:
The signboard rent management device according to claim 4, characterized in that the alert content for each section is obtained by comparing a cost comparison result indicating whether the cost rate is greater than the cost allowable ratio, a half-cost comparison result indicating whether the cost rate is greater than half of the cost allowable ratio, a vacancy comparison result indicating whether the vacancy period is longer than the vacancy allowable period, and a double vacancy comparison result indicating whether the vacancy period is shorter than twice the vacancy allowable period against the alert management master. The alert acquisition means includes:
The signboard rent management device according to claim 5, characterized in that, when three of the results of the cost comparison, the half-cost comparison, the vacancy comparison and the double vacancy comparison are positive based on the alert management master, the alert content indicates that cancellation is necessary. The alert acquisition means includes:
The signboard rent management device according to claim 5 or 6, characterized in that, based on the alert management master, if two of the cost comparison result, the half-cost comparison result, the vacancy comparison result and the double vacancy comparison result are positive results and two are negative results, the alert content indicates that negotiation is necessary. The alert acquisition means includes:
A signboard rent management device as described in any one of claims 5 to 7, characterized in that if three of the results of the cost comparison, the half-cost comparison, the vacancy comparison and the double vacancy comparison are negative based on the alert management master, the alert content indicating that caution is required is obtained. A signboard rent management method to be executed by a signboard rent management device having a memory unit and a control unit,
The storage unit is
a payment storage means for storing payment destination contract data that is set by linking together a payment destination for land rent, a payment contract start date, a payment contract end date, a section for installing a signboard, and a payment amount, and payment data that is set by linking together a scheduled payment date, the payment destination, the payment amount, and whether or not payment has been made;
a billing storage means for storing billing contract data that is set by linking together a billing destination that has requested the installation of the signboard, a billing contract start date, a billing contract end date, a billing cancellation date, the section, and a billing amount, and billing data that is set by linking together a scheduled billing date, the billing destination, the billing amount, and whether or not payment has been made;
Equipped with
The control unit executes
a total payment acquisition step of acquiring a total payment amount obtained by aggregating the amount of the payment already made from the payment start month to the target month based on the payment destination contract data and the payment data when the target month is designated;
a past income total acquisition step for acquiring a past income total amount by tallying up the invoiced amount already paid from the payment start month to the target month based on the invoice-to-contract data and the invoice data;
A vacancy acquisition step of acquiring the number of months elapsed from the billing cancellation date to the target month as a vacancy period based on the billing contract data;
a signboard land rent management output step for outputting signboard land rent management data set by linking the payment destination, the payment contract start date, the payment contract end date, the section, the target month payment amount , the billing destination, the billing cancellation date, the total payment amount, the total past income, and the vacant period;
A signboard rent management method comprising: A signboard rent management program to be executed by a signboard rent management device having a storage unit and a control unit,
The storage unit is
a payment storage means for storing payment destination contract data that is set by linking together a payment destination for land rent, a payment contract start date, a payment contract end date, a section for installing a signboard, and a payment amount, and payment data that is set by linking together a scheduled payment date, the payment destination, the payment amount, and whether or not payment has been made;
a billing storage means for storing billing contract data that is set by linking together a billing destination that has requested the installation of the signboard, a billing contract start date, a billing contract end date, a billing cancellation date, the section, and a billing amount, and billing data that is set by linking together a scheduled billing date, the billing destination, the billing amount, and whether or not payment has been made;
Equipped with
In the control unit,
a total payment acquisition step of acquiring a total payment amount obtained by aggregating the amount of the payment already made from the payment start month to the target month based on the payment destination contract data and the payment data when the target month is designated;
a past income total acquisition step for acquiring a past income total amount by tallying up the invoiced amount already paid from the payment start month to the target month based on the invoice-to-contract data and the invoice data;
A vacancy acquisition step of acquiring the number of months elapsed from the billing cancellation date to the target month as a vacancy period based on the billing contract data;
a signboard land rent management output step for outputting signboard land rent management data set by linking the payment destination, the payment contract start date, the payment contract end date, the section, the target month payment amount , the billing destination, the billing cancellation date, the total payment amount, the total past income, and the vacant period;
A signboard rent management program to carry out the above.