Kanban land rent management device, Kanban land rent management method, and Kanban land rent management program
The billboard land rent management device automates data processing and generates negotiation lists with alerts, addressing inefficiencies in manual contract management to enhance negotiation efficiency and reduce costs.
Patent Information
- Application Number
- JP2022005905
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-01-18
- Publication Date
- 2025-07-15
- Estimated Expiration
- 2042-01-18
AI Technical Summary
Existing systems for managing billboard land rent negotiations are inefficient due to the manual sorting of contracts and invoices, leading to inaccurate information and missed negotiation opportunities.
A billboard land rent management device and method that integrates a storage unit for contract and payment data, a control unit for data processing, and an alert system to identify vacancy periods and cost rates, enabling automated generation of negotiation lists and alerts for efficient land rent management.
The system visualizes availability status, provides timely negotiation alerts, and reduces land rent costs by identifying optimal negotiation targets, thereby improving negotiation efficiency and reducing manual errors.
Smart Images

Figure 0007708679000001 
Figure 0007708679000002 
Figure 0007708679000003
Abstract
Description
Technical Field
[0001] The present invention relates to a billboard land rent management device, a billboard land rent management method, and a billboard land rent management program.
Background Art
[0002] Patent Document 1 discloses a configuration capable of providing the availability status of advertising installation locations where outdoor advertisements can be installed.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] However, in the invention described in Patent Document 1, when it is necessary to check the availability status of outdoor billboards, there is a problem that data obtained by separately sorting out past contracts, invoices, and payments is provided together with the availability status.
[0005] The present invention has been made in view of the above problems, and for the land rent negotiation business with owners in the outdoor advertising industry, by outputting a list of empty billboards without clients on the land under contract with the owner, it is possible to provide efficient negotiation materials by visualizing the availability status, and an object of the present invention is to provide a billboard land rent management device, a billboard land rent management method, and a billboard land rent management program.
Means for Solving the Problems
[0006] In order to solve the above-described problems and achieve the object, the signboard land rent management device according to the present invention is a signboard land rent management device including a storage unit and a control unit, wherein the storage unit associates and sets a payment destination of land rent, a payment contract start date, a payment contract end date, a section where a signboard is installed, and a payment amount, and stores payment destination contract data; and payment storage means for storing payment data set by associating a scheduled payment date, the payment destination, the payment amount, and the presence or absence of payment; a claimant who requested installation of the signboard, a claim contract start date, a claim contract end date, a claim cancellation date, claim destination contract data set by associating the section and the claim amount, and claim data set by associating a scheduled claim date, the claim destination, the claim amount, and the presence or absence of receipt are stored, and the control unit, when a target month is designated, based on the payment destination contract data and the payment data, payment total amount acquisition means for acquiring a total payment amount of the paid payment amount from the payment start month to the target month; past revenue total amount acquisition means for acquiring a total past revenue amount of the received claim amount from the receipt start month to the target month based on the claim destination contract data and the claim data; vacancy acquisition means for acquiring, as a vacancy period, the number of elapsed months from the claim cancellation date to the target month based on the claim destination contract data; and signboard land rent management output means for outputting signboard land rent management data set by associating the payment destination, the payment contract start date, the payment contract end date, the section, the target month payment amount, the claim destination, the claim cancellation date, the total payment amount, the total past revenue amount, and the vacancy period.
[0007] Further, in the signboard land rent management device according to the present invention, when the claim destination contract data corresponding to the section is not stored in the claim storage means, the vacancy acquisition means acquires, as the vacancy period, the number of elapsed months from the payment contract start date to the target month based on the payment destination contract data.
[0008] Also, in the signboard land rent management device according to the present invention, the control unit further includes a cost rate acquisition means for acquiring, as a cost rate, a value obtained by multiplying the quotient when the total payment amount is used as the dividend and the past total income amount is used as the divisor by 100, and the signboard land rent management data further has the cost rate set therein.
[0009] Also, in the signboard land rent management device according to the present invention, the payee contract data further has a vacancy allowance period and a cost allowance ratio set, and the storage unit further includes 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 an alert management master in which alert contents are associated and set. The control unit further includes an alert acquisition means for comparing the cost rate with the cost allowance ratio and comparing the vacancy period with the vacancy allowance period, and matching the result with the alert management master to acquire the alert content for each section. The signboard land rent management data further has the alert content set therein.
[0010] Also, in the signboard land rent management device according to the present invention, the alert acquisition means matches the cost comparison result indicating whether the cost rate is greater than the cost allowance ratio, the half-cost comparison result indicating whether the cost rate is greater than half of the cost allowance ratio, the vacancy comparison result indicating whether the vacancy period is longer than the vacancy allowance period, and the double-vacancy comparison result indicating whether the vacancy period is shorter than twice the vacancy allowance period with the alert management master to acquire the alert content for each section.
[0011] Also, in the signboard land rent management device according to the present invention, the alert acquisition means acquires, based on the alert management master, the alert content indicating that contract cancellation consideration is necessary when 3 results out of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double-vacancy comparison result are positive results.
[0012] Also, in the signboard land rent management device according to the present invention, when two of the cost comparison result, the semi-cost comparison result, the vacancy comparison result, and the double vacancy comparison result are positive results and two are negative results based on the alert management master, the alert acquisition means acquires the alert content indicating that negotiation is necessary.
[0013] Also, in the signboard land rent management device according to the present invention, when three of the cost comparison result, the semi-cost comparison result, the vacancy comparison result, and the double vacancy comparison result are negative results based on the alert management master, the alert acquisition means acquires the alert content indicating that attention is required.
[0014] The signboard land rent management method according to the present invention is a signboard land rent management method for causing a signboard land rent management device including a storage unit and a control unit to execute. The storage unit stores payment destination contract data in which a payment destination, a payment contract start date, a payment contract end date, a section where a signboard is installed, and a payment amount are associated and set, and payment data in which a scheduled payment date, the payment destination, the payment amount, and the presence or absence of payment are associated and set, and a payment storage means for storing, a billing destination that requested the installation of the signboard, a billing contract start date, a billing contract end date, a billing cancellation date, the section, and billing destination contract data in which a billing amount is associated and set, and billing data in which a scheduled billing date, the billing destination, the billing amount, and the presence or absence of payment are associated and set, and a billing storage means for storing. When a target month is specified and executed by the control unit, a total payment amount acquisition step of acquiring a total payment amount obtained by aggregating the paid payment amounts from the payment start month to the target month based on the payment destination contract data and the payment data, a past revenue total amount acquisition step of acquiring a past revenue total amount obtained by aggregating the received billing amounts from the payment start month to the target month based on the billing destination contract data and the billing data, and a signboard land rent management output step of outputting signboard land rent management data in which 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, and the past revenue total amount are associated and set.
[0015] Also, the signboard land rent management program according to the present invention is a signboard land rent management program for causing a signboard land rent management device provided with a storage unit and a control unit to execute. The storage unit sets payment destination contract data in which a payment destination of land rent, a payment contract start date, a payment contract end date, a section where a signboard is installed, and a payment amount are associated, and payment data in which a scheduled payment date, the payment destination, the payment amount, and the presence or absence of payment are associated. A payment storage means for storing; a billing destination that requested the installation of the signboard, a billing contract start date, a billing contract end date, a billing cancellation date, billing destination contract data in which the section and the billing amount are associated, and a scheduled billing date, the billing destination, the billing amount, and a billing storage means for storing billing data in which the presence or absence of payment is associated. In the control unit, when a target month is designated, a total payment amount acquisition step of acquiring a total payment amount obtained by aggregating the paid payment amounts from the payment start month to the target month based on the payment destination contract data and the payment data; A past revenue total acquisition step of acquiring a past revenue total obtained by aggregating the paid billing amounts from the payment start month to the target month based on the billing destination contract data and the billing data; and 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, and a signboard land rent management output step of outputting signboard land rent management data in which the past revenue total is associated and set, characterized in that it is executed.
Effect of the Invention
[0016] According to the present invention, it is possible to visualize the availability status of signboards based on various contract data, billing data, and payment data, and it is also possible to display the availability status and alerts. Further, according to the present invention, it is possible to see the operating status such as the availability of advertising space in addition to the negotiation of land rent. Further, according to the present invention, by outputting alerts such as "negotiation required" or "cancellation consideration required" depending on the situation, it is possible to unify the criteria for selecting negotiation targets. Further, according to the present invention, by being able to output the availability status in a list format, it is possible to make the negotiation targets visible. Further, according to the present invention, by narrowing down the negotiation targets clearly with the alert function, it is possible to unify the criteria for selecting negotiation targets and prevent unevenness in the selection of negotiation targets depending on the judgment of sales staff. Further, according to the present invention, by conducting negotiations based on certain criteria, it is possible to include contracts that have been missed in the negotiations so far as negotiation targets, and thus it is possible to reduce the land rent cost by the amount of successful negotiations for this contract. Further, according to the present invention, in addition to preventing information degradation caused by conventional manual work, it is possible to output a list immediately, enabling timely negotiations.
Brief Description of Drawings
[0017]
Figure 1
Figure 2
Figure 3
Figure 4
Figure 5
Figure 6
Figure 7
Figure 8
Figure 9
Figure 10
Figure 11
Figure 12
Figure 13
Figure 14
DETAILED DESCRIPTION OF THE INVENTION
[0018] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by these embodiments.
[0019] [1. Overview] First, the overview of the present invention will be described.
[0020] Conventionally, in the outdoor advertising (billboard) industry, there is a business of negotiating land rent with the owner. In this business, it may be necessary to confirm the contract status (availability) of the client. However, in the past, it was necessary to separately extract and confirm past contracts, billing data, and payment data. As a result, conventionally, the accuracy of information has decreased and timely negotiation has not been possible. That is, conventionally, as a business reality, the target of land rent negotiation has been selected based on the intuition of salespersons, and land rent negotiation has been carried out.
[0021] Therefore, in this embodiment, focusing on the point that negotiations based on the vacancy situation enable more efficient negotiations, a mechanism is provided that can output the vacancy situation in a list format.
[0022] Also, in this embodiment, at the time of output, if there is a vacancy period exceeding the number of months set for each landlord contract (for example, 6 months, etc.), or if there was a past client contract but the land rent payment amount has reached a predetermined percentage of the cumulative client income set for each landlord contract, an alert (for example, "Negotiation required" or "Consider contract cancellation necessary", etc.) is displayed (for example, in a list display, etc.). Note that as the determination conditions in this embodiment, the total past income, the total payment amount, and / or the cost rate, etc. may be used.
[0023] [2. Configuration] An example of the configuration of the signboard land 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 land rent management device 100 in this embodiment.
[0024] As shown in FIG. 1, the signboard land rent management device 100 is a commercially available desktop personal computer. Note that the signboard land rent management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.
[0025] The signboard land rent management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the signboard land rent management device 100 is communicably connected via an arbitrary communication path.
[0026] The communication interface unit 104 communicably connects the signboard land 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 communicably connecting the signboard land rent management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).
[0027] An input / output interface unit 108 has an input device 112 and an output device 114 connected thereto. For the output device 114, in addition to a monitor (including a touch panel), a speaker or a printer can be used. For the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Hereinafter, the output device 114 may be described as the monitor 114 or the printer 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.
[0028] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records a computer program for giving commands to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. As the storage unit 106, 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, and an optical disk can be used. The storage unit 106 includes a payment database 106a, a billing database 106b, and an alert management master 106c.
[0029] The payment database 106a stores the payment destination contract data for the land rent and the payment data. Here, the payment database 106a may store the payment destination contract data in which the payment destination for the land rent, the start date of the payment contract, the end date of the payment contract, the section where the signboard is installed, and the payment amount are associated, and the payment data in which the scheduled payment date, the payment destination, the payment amount, and the status of payment are associated. Also, the payment destination contract data may be set with an allowable vacancy period and a cost allowable ratio.
[0030] The billing database 106b stores the billing destination contract data for the billing party that requested the installation of the signboard and the billing data. Here, the billing database 106b may store the billing destination contract data in which the billing destination that requested the installation of the signboard, the start date of the billing contract, the end date of the billing contract, the cancellation date of the billing, the section where the signboard is installed, and the billing amount are associated, and the billing data in which the scheduled billing date, the billing destination, the billing amount, and the status of receipt are associated.
[0031] The alert management master 106c is a master that sets the alert content. Here, the alert management master 106c may be set with a cost comparison criterion between the cost rate and the cost allowable ratio, a vacancy comparison criterion between the vacancy period and the allowable vacancy period, and the alert content associated.
[0032] The control unit 102 is a CPU or the like that comprehensively controls the signboard land rent management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, and required data, and executes various information processes based on these stored programs. Functionally conceptually, the control unit 102 includes a registration unit 102a, a total payment acquisition unit 102b, a past total income acquisition unit 102c, a cost rate acquisition unit 102d, a vacancy acquisition unit 102e, an alert acquisition unit 102f, and a signboard land rent management output unit 102g.
[0033] The registration unit 102a registers the payment destination contract data, the payment data, the billing destination contract data, the billing data, etc. in the storage unit 106.
[0034] The total payment amount acquisition unit 102b acquires the total payment amount obtained by aggregating the paid payment amounts from the start month of payment to the target month. Here, when the target month is specified, the total payment amount acquisition unit 102b may acquire the total payment amount obtained by aggregating the paid payment amounts from the start month of payment to the target month based on the payee contract data and the payment data.
[0035] The past total income acquisition unit 102c acquires the past total income of the signboard installation. Here, the past total income acquisition unit 102c may acquire the past total income obtained by aggregating the billed amounts that have been received from the start month of payment to the target month based on the billing destination contract data and the billing data.
[0036] The cost rate acquisition unit 102d acquires the cost rate of the signboard installation. Here, the cost rate acquisition unit 102d may acquire, as the cost rate, a value obtained by multiplying the quotient when the total payment amount is the dividend and the past total income is the divisor by 100.
[0037] The vacant room acquisition unit 102e acquires the vacant room period, which is the non-installation period of the signboard in the section where the signboard is installed. Here, the vacant room acquisition unit 102e may acquire, as the vacant room period, the number of elapsed months from the billing cancellation date to the target month based on the billing destination contract data. Also, when the billing destination contract data corresponding to the section where the signboard is installed is not stored in the billing database 106b, the vacant room acquisition unit 102e may acquire, as the vacant room period, the number of elapsed months from the payment contract start date to the target month based on the payee contract data.
[0038] The alert acquisition unit 102f acquires the alert content for each section where the signboard is installed. Here, the alert acquisition unit 102f may acquire the alert content for each section where the signboard is installed by matching the comparison result of the cost rate and the cost tolerance ratio, and the comparison result of the vacancy period and the vacancy tolerance period with the alert management master 106c. Further, the alert acquisition unit 102f matches the cost comparison result indicating whether the cost rate is greater than the cost tolerance ratio, the semi-cost comparison result indicating whether the cost rate is greater than half of the cost tolerance ratio, the vacancy comparison result indicating whether the vacancy period is longer than the vacancy tolerance period, and the double-vacancy comparison result indicating whether the vacancy period is shorter than twice the vacancy tolerance period with the alert management master 106c to acquire the alert content for each section. Further, based on the alert management master 106c, when three of the cost comparison result, the semi-cost comparison result, the vacancy comparison result, and the double-vacancy comparison result are positive results, the alert acquisition unit 102f may acquire the alert content indicating that contract termination consideration is necessary. Further, based on the alert management master 106c, when two of the cost comparison result, the semi-cost comparison result, the vacancy comparison result, and the double-vacancy comparison result are positive results and two are negative results, the alert acquisition unit 102f may acquire the alert content indicating that negotiation is necessary. Further, based on the alert management master 106c, when three of the cost comparison result, the semi-cost comparison result, the vacancy comparison result, and the double-vacancy comparison result are negative results, the alert acquisition unit 102f may acquire the alert content indicating that attention is required.
[0039] The signboard land rent management output unit 102g outputs the signboard land rent management data. Here, the signboard land rent management output unit 102g may output the signboard land rent management data in which the payee, the start date of the payment contract, the end date of the payment contract, the section, the payment amount for the target month, the billing party, the contract termination request date, the total payment amount, the total past income amount, and the vacancy period are associated and set. Further, the cost rate may be set in the signboard land rent management data. Further, the alert content may be set in the signboard land rent management data.
[0040] [3. Specific Example] The specific example of this embodiment will be described with reference to FIGS. 2 to 10.
[0041] [Kanban Land Rent Management Process] Here, referring to FIG. 2, an example of the kanban land rent management process in the present embodiment will be described. FIG. 2 is a flowchart showing an example of the process of the kanban land rent management device 100 in the present embodiment.
[0042] As shown in FIG. 2, when the total payment amount acquisition unit 102b is specified for the target month on the vacant kanban land rent output screen by the user via the input device 112, it acquires the specified data with the target month set (step SA-1).
[0043] Then, the total payment amount acquisition unit 102b acquires the total payment amount obtained by aggregating the paid payment amounts from the start month of payment to the target month based on the specified data, the payee contract data and the payment data stored in the payment database 106a (step SA-2).
[0044] Then, the past total income acquisition unit 102c acquires the past total income obtained by aggregating the billed amounts that have been received from the start month of receipt to the target month based on the specified data, the billing destination contract data and the billing data stored in the billing database 106b (step SA-3).
[0045] Then, the cost rate acquisition unit 102d acquires, as the cost rate, the value obtained by multiplying the quotient when the total payment amount is the dividend and the past total income is the divisor by 100 (step SA-4).
[0046] Then, the vacant room acquisition unit 102e acquires, based on the billing destination contract data stored in the billing database 106b, the number of months elapsed from the billing cancellation date to the target month as the vacant room period (step SA-5).
[0047] Then, the alert acquisition unit 102f obtains the alert content for each section by matching the cost comparison result indicating whether the cost rate is greater than the allowable cost ratio, the semi-cost comparison result indicating whether the cost rate is greater than half of 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 (step SA-6).
[0048] Then, the kanban land rent management output unit 102g causes the output device 114 to display the kanban land rent management data in which the payee, the start date of the payment contract, the end date of the payment contract, the section, the payment amount for the target month, the billing party, the billing cancellation date, the total payment amount, the total past income amount, the cost rate, the vacancy period, and the alert content are associated and set (step SA-7), and ends the process.
[0049] Here, with reference to FIGS. 3 to 7, an example of the data registration process in the present embodiment will be described. FIGS. 3 to 6 are diagrams showing an example of the data registration process in the present embodiment. FIG. 7 is a diagram showing an example of the registered data configuration in the present embodiment.
[0050] In the present embodiment, as shown in FIG. 3, as the landowner contract registration, the landowner contract data (payee contract data) with the landowner is registered, and by registering the landowner contract, the payment data to the landowner is also created as a plan. And in the present embodiment, as shown in FIG. 4, when the payments up to November are completed, as the payment registration, the payment process (update of the paid FLG and the payment date) is performed.
[0051] And in the present embodiment, as shown in FIG. 5, as the client contract registration, the client contract data (billing party contract data) with the client is registered, and by registering the client contract, the billing data to the client is also created as a plan. And in the present embodiment, as shown in FIG. 6, as the billing registration and the deposit / offset registration, the billing process and the deposit process are performed on the billing data created from the client contract.
[0052] And in this embodiment, as shown in FIG. 7, the landowner contract data, the client contract data, the payment data, and the billing data are associated. Here, as shown in FIG. 7, in this embodiment, the landowner contract data and the client contract data are associated by the section NO.
[0053] Also, with reference to FIGS. 8 to 14, a specific example of the signboard land rent management process in this embodiment will be described. FIGS. 8 to 14 are diagrams showing an example of the signboard land rent management process in this embodiment.
[0054] In this embodiment, as shown in FIG. 8, when the target month: 2011 / 11 is specified on the blank signboard land rent output screen by the user and the Excel(R) output button is pressed, a window for specifying the file output destination is displayed, and the file output destination is specified by the user.
[0055] And in this embodiment, as shown in FIG. 9, since the target month is 2021 / 11, among the payment data associated with the landowner contract data, the data with a check in the paid flag (FLG) by November 30, 2021 is targeted, and the total paid amount until the target month is aggregated as the total payment amount.
[0056] And in this embodiment, as shown in FIG. 10, since the target month is 2021 / 11, among the billing data associated with the client contract data, the data with a check in the received payment flag by November 30, 2021 is targeted, and the total received billing amount until the target month is aggregated as the total past income amount.
[0057] And in this embodiment, as shown in FIG. 11, "cost rate = total payment amount ÷ total past income amount × 100" is calculated, and the cost rate is obtained.
[0058] And 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 obtained as the vacancy period. When there is no client contract data, the number of months elapsed from the contract start date set in the landlord contract data to the target month is obtained as the vacancy period. Here, in this embodiment, as shown in FIG. 12, when there is client contract data but the cancellation date in the client contract data is blank (= under contract), the vacancy period is set to "none".
[0059] And in this embodiment, as shown in FIG. 13, the comparison result between the cost rate and the cost tolerance ratio set in the landlord contract data, and the comparison result between the vacancy period and the vacancy tolerance 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, when there are three or more circles, the alert content may be set to "consider cancellation", when there are two circles, "negotiation required", when there is one circle, "attention required", and when there are no circles, "no alert". Note that, as shown in FIG. 13, in this embodiment, data where there is client contract data but the cancellation date is blank (= under contract) may be excluded from the alert acquisition target.
[0060] And in this embodiment, as shown in FIG. 14, as the final output, an Excel (registered trademark) file in which the total payment amount, the total past income amount, the cost rate, the vacancy period, and the alert content are linked and set is output. Thus, in this embodiment, an Excel (registered trademark) file in which various data are linked is output based on the landlord contract data.
[0061] [4. Contribution to the United Nations Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate business judgment of the enterprise, so it is possible to contribute to Goals 8 and 9 of the SDGs.
[0062] In addition, according to the present embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, and thus it is possible to contribute to SDGs Goals 12, 13, and 15.
[0063] In addition, according to the present embodiment, it is possible to contribute to strengthening control and governance, and thus it is possible to contribute to SDGs Goal 16.
[0064] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the embodiments described above.
[0065] For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all or part of the processes described as being manually performed can be automatically performed by a known method.
[0066] In addition, regarding the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.
[0067] In addition, regarding the signboard land rent management device 100, each illustrated component is a functional concept, and it is not necessarily physically configured as illustrated.
[0068] For example, regarding the processing functions provided by the signboard land rent management device 100, particularly each processing function performed by the control unit 102, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in this embodiment, and is mechanically read by the signboard land rent management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit in cooperation with the CPU.
[0069] Also, this computer program may be stored in an application program server connected to the signboard land rent management device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.
[0070] Also, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an 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 Disk), and a Blu-ray (registered trademark) Disc.
[0071] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in this embodiment, well-known configurations and procedures can be used.
[0072] The various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.
[0073] Further, the sign land 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 an arbitrary peripheral device is connected. Further, the sign land rent management device 100 may be realized by installing software (including programs or data, etc.) for realizing the processes described in the present embodiment in the device.
[0074] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.
Industrial Applicability
[0075] The present invention is useful in industries such as the outdoor advertising industry of signs and the like.
Explanation of Signs
[0076] 100 Sign land rent management device 102 Control unit 102a Registration unit 102b Total payment acquisition unit 102c Total past income acquisition unit 102d Cost rate acquisition unit 102e Vacancy acquisition unit 102f Alert acquisition unit 102g Sign land 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
1. A signboard land rent management device comprising a storage unit and a control unit, wherein the storage unit is provided with payment storage means for storing payment destination contract data in which a payment destination, a payment contract start date, a payment contract end date, a section where a signboard is installed, and a payment amount are associated and set, and payment data in which a payment scheduled date, the payment destination, the payment amount, and the presence or absence of payment are associated and set; claim storage means for storing claim destination contract data in which a claim destination that requested the installation of the signboard, a claim contract start date, a claim contract end date, a claim cancellation date, the section, and a claim amount are associated and set, and claim data in which a claim scheduled date, the claim destination, the claim amount, and the presence or absence of payment are associated and set; and the control unit when a target month is specified, payment total amount acquisition means for acquiring a total payment amount obtained by aggregating the paid payment amounts from the payment start month to the target month based on the payment destination contract data and the payment data; past revenue total amount acquisition means for acquiring a total past revenue amount obtained by aggregating the paid claim amounts from the payment start month to the target month based on the claim destination contract data and the claim data; vacancy acquisition means for acquiring, as a vacancy period, the number of months elapsed from the claim cancellation date to the target month based on the claim destination contract data; signboard land rent management output means for outputting signboard land rent management data in which the payment destination, the payment contract start date, the payment contract end date, the section, the target month payment amount, the claim destination, the claim cancellation date, the total payment amount, the total past revenue amount, and the vacancy period are associated and set; A signboard land rent management device characterized by comprising the above.
2. The vacancy acquisition means acquires, as the vacancy period, the number of months elapsed from the payment contract start date to the target month based on the payment destination contract data when the claim destination contract data corresponding to the section is not stored in the claim storage means. The signboard land rent management device according to claim 1.
3. The control unit further comprises cost rate acquisition means for acquiring, as a cost rate, a value obtained by multiplying the quotient when the total payment amount is used as the dividend and the total past revenue amount is used as the divisor by 100; and the signboard land rent management data further has the cost rate set. The signboard land rent management device according to claim 1 or 2.
4. The payment destination contract data further has a vacancy tolerance period and a cost tolerance ratio set, and the storage unit A cost comparison criterion between the cost rate and the allowable cost ratio, a vacancy comparison criterion between the vacancy period and the allowable vacancy period, and an alert management master in which alert contents are associated and set further comprising the control unit an alert acquisition means for comparing the cost rate with the allowable cost ratio, and comparing the result of comparing the vacancy period with the allowable vacancy period with the alert management master to acquire the alert contents for each section further comprising the kanban land rent management data The kanban land rent management device according to claim 3, further characterized in that the alert content is set
5. The alert acquisition means The alert acquisition means according to claim 4, wherein 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 of 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 are matched with the alert management master to acquire the alert contents for each section
6. The alert acquisition means The kanban land rent management device according to claim 5, wherein, based on the alert management master, when three of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double-vacancy comparison result are positive results, the alert content of "needing to consider contract termination" is acquired
7. The alert acquisition means The kanban land rent management device according to claim 5 or 6, wherein, based on the alert management master, when 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 of "needing negotiation" is acquired
8. The alert acquisition means The kanban land rent management device according to any one of claims 5 to 7, wherein, based on the alert management master, when three of the cost comparison result, the half-cost comparison result, the vacancy comparison result, and the double-vacancy comparison result are negative results, the alert content of "attention required" is acquired
9. A kanban land rent management method for causing a kanban land rent management device including a storage unit and a control unit to execute, wherein the storage unit Payment destination contract data that associates the payment destination of the ground rent, the start date of the payment contract, the end date of the payment contract, the section where the signboard is installed, and the payment amount, and payment storage means for storing payment data that associates the scheduled payment date, the payment destination, the payment amount, and the status of payment made Claimant who requested the installation of the signboard, start date of the claim contract, end date of the claim contract, cancellation date of the claim, claim contract data that associates the section and the claim amount, and claim storage means for storing claim data that associates the scheduled claim date, the claimant, the claim amount, and the status of payment received Comprising To be executed by the control unit When the target month is specified, a total payment amount acquisition step of acquiring the total payment amount of the paid payment amount from the start month of payment to the target month based on the payment destination contract data and the payment data A past total income acquisition step of acquiring the past total income obtained by aggregating the received claim amount from the start month of receipt to the target month based on the claimant contract data and the claim data An empty room acquisition step of acquiring, as an empty room period, the number of months elapsed from the claim cancellation date to the target month based on the claimant contract data A signboard ground rent management output step of outputting signboard ground rent management data that associates the payment destination, the start date of the payment contract, the end date of the payment contract, the section, the target month payment amount, the claimant, the claim cancellation date, the total payment amount, the past total income, and the empty room period A signboard ground rent management method characterized by including
10. A signboard ground rent management program for execution by a signboard ground rent management device including a storage unit and a control unit, The storage unit Payment storage means for storing payment destination contract data that associates the payment destination of the ground rent, the start date of the payment contract, the end date of the payment contract, the section where the signboard is installed, and the payment amount, and payment data that associates the scheduled payment date, the payment destination, the payment amount, and the status of payment made Claim storage means for storing claimant contract data that associates the claimant who requested the installation of the signboard, the start date of the claim contract, the end date of the claim contract, the claim cancellation date, the section, and the claim amount, and claim data that associates the scheduled claim date, the claimant, the claim amount, and the status of payment received Comprising In the control unit When a target month is specified, a total payment amount acquisition step of acquiring a total payment amount obtained by aggregating the paid payment amounts from the payment start month to the target month based on the payee contract data and the payment data; a past revenue total acquisition step of acquiring a past revenue total obtained by aggregating the received claim amounts from the deposit start month to the target month based on the claimant contract data and the claim data; a vacant room acquisition step of acquiring, as a vacant room period, the number of elapsed months from the claim cancellation date to the target month based on the claimant contract data; a billboard land rent management output step of outputting billboard land rent management data in which the payee, the payment contract start date, the payment contract end date, the section, the target month payment amount, the claimant, the claim cancellation date, the total payment amount, the past revenue total, and the vacant room period are associated and set; A billboard land rent management program for causing the above to be executed.
Citation Information
Patent Citations
Outdoor advertisement trading system
JP2003263600A
Blank billboard information provision system
JP2006127285A
Advertisement Location Matching System Using Advertisement Baseplate (Parameter Variable Type) Processing Procedure and Recording Medium
JP3124771U