JP2017134753A - Information processing apparatus and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processing apparatus capable of calculating a rent of a tenant in a relationship of subletting and subleasing, and a program.SOLUTION: The present invention relates to an information processing apparatus for calculating a rent on the basis of sales of a tenant. The information processing apparatus comprises: selection means for selecting a target tenant subjected to rent calculation from among multiple tenants; first discrimination means for discriminating whether the target tenant is a subleasing source tenant that performs subleasing of property to the other tenant, on the basis of relationship information relating to tenants in a relationship of subletting and subleasing among the multiple tenants; totaling means for totaling the sales of the target tenant and the other tenant in the relationship of subletting and subleasing with the target tenant, on a condition that the target tenant is the subleasing source tenant; and calculation means for calculating the rent of the target tenant on the basis of the totaled result of the totaling means.SELECTED DRAWING: Figure 9

Description

  Embodiments described herein relate generally to an information processing apparatus and a program.

  2. Description of the Related Art Conventionally, in commercial facilities such as shopping centers, sales floor sections have been rented to various companies. In such a complex commercial facility, sales are managed for each tenant occupying and rent is calculated from the sales.

  By the way, in the above-mentioned complex commercial facility, there is a case where a part of a property (sales section) borrowed by a certain tenant is sublet (or leased) to another tenant. In this way, when there is a sublease relationship between tenants, the rent of the tenant that is the sublending source is calculated by including the sales of the tenant that is the sublending destination in the sales of the tenant that is the sublending source.

  However, with the conventional technology, it is possible to calculate the rent for each tenant from the sales of each tenant, but it has not been possible to calculate an appropriate rent for a tenant that has a sublease relationship.

  The problem to be solved by the present invention is to provide an information processing apparatus and program capable of calculating the rent of a tenant in a sublease relationship.

  The information processing apparatus according to the embodiment is an information processing apparatus that calculates rent based on sales of a tenant, and includes a selection unit, a first determination unit, a totaling unit, and a calculation unit. The selection means selects a target tenant to be a rent calculation target from among a plurality of tenants. The first determination unit determines whether the target tenant is a subleasing source tenant that subleases the property to another tenant based on relation information relating a tenant having a sublease relationship among the plurality of tenants. The aggregation means totals sales of the target tenant and other tenants in a sublending relationship with the target tenant on the condition that the target tenant is the sub-leasing source tenant. The calculating means calculates the rent of the target tenant based on the counting result of the counting means.

FIG. 1 is a diagram schematically illustrating an overall configuration of a tenant management system according to the embodiment. FIG. 2 is a diagram illustrating a configuration example of an electrical system of the POS terminal illustrated in FIG. FIG. 3 is a diagram illustrating a configuration example of the electrical system of the tenant management apparatus illustrated in FIG. FIG. 4 is a diagram illustrating an example of a data configuration of the tenant master table according to the embodiment. FIG. 5 is a diagram for explaining an example of a sublease relationship between tenants. FIG. 6 is a diagram for explaining another example of the sublease relationship between tenants. FIG. 7 is a diagram illustrating an example of a data configuration of the sales management table according to the embodiment. FIG. 8 is a diagram illustrating an example of a data configuration of a rent management table according to the embodiment. FIG. 9 is a flowchart illustrating an example of rent calculation processing executed by the tenant management apparatus according to the embodiment.

  Embodiments of an information processing apparatus and a program according to the present invention will be described below in detail with reference to the accompanying drawings. In the following embodiment, an example in which the information processing apparatus and program of the present invention are applied to a complex commercial facility such as a shopping center will be described, but the present invention is not limited to this embodiment.

  FIG. 1 is a diagram schematically showing an overall configuration of a tenant management system 1 according to the present embodiment. The tenant management system 1 includes a plurality of POS (Point Of Sale) terminals 10 and a tenant management device 20. Here, each POS terminal 10 and the tenant management device 20 are connected to be communicable with each other via a network N such as a LAN (Local Area Network).

  The POS terminal 10 is a POS terminal installed in each tenant (store) that moves into the complex commercial facility. Each of the POS terminals 10 generates sales data obtained by tabulating sales in its own tenant based on the sales data of each product registered for sale. The tenant management device 20 is the information processing device of this embodiment, and manages the sales and rent of each tenant. The tenant management device 20 is installed at the headquarters (developer) of a complex commercial facility, for example.

  Hereinafter, a configuration example of each device configuring the tenant management system 1 will be described.

  FIG. 2 is a diagram illustrating a configuration example of the electrical system of the POS terminal 10. The POS terminal 10 includes a control unit 11 having a computer configuration including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like. The control unit 11 is connected via a bus 12 to a communication interface (I / F) 13 and an I / O device control unit 14 that can be connected to the network N. The control unit 11 is connected to the input unit 15, the display unit 16, the storage unit 17, and the like via the bus 12 and the I / O device control unit 14.

  The input unit 15 includes an input device such as a keyboard and a pointing device. The input unit 15 notifies the control unit 11 of a signal corresponding to the operation content received via the input device. The display unit 16 includes a display device such as a liquid crystal display. The display unit 16 displays various information according to the control of the control unit 11. The storage unit 17 includes a storage device such as an HDD (Hard Disk Drive) or an SSD (Solid State Drive). The storage unit 17 stores various programs executed by the CPU of the control unit 11 and setting information, as well as a tenant identifier for identifying the tenant in which the own POS terminal 10 is installed.

  The control unit 11 of the POS terminal 10 generates sales data including information indicating sales of its own tenant every day (every business day). In addition, the control unit 11 of the POS terminal 10 transmits the generated sales data to the tenant management device 20. Note that the sales data includes the tenant identifier of the own POS terminal 10 in addition to the business day and the sales.

  FIG. 3 is a diagram illustrating a configuration example of the electrical system of the tenant management apparatus 20. The tenant management apparatus 20 includes a control unit 21 having a computer configuration including a CPU, a ROM, a RAM, and the like. The control unit 21 is connected via a bus 22 to a communication interface 23 and an I / O device control unit 24 that can be connected to the network N. The control unit 21 is connected to the input unit 25, the display unit 26, the storage unit 27, and the like via the bus 22 and the I / O device control unit 24.

  The input unit 25 includes input devices such as a keyboard and a pointing device. The input unit 25 notifies the control unit 21 of a signal corresponding to the operation content received via the input device. The display unit 26 includes a display device such as a liquid crystal display. The display unit 26 displays various information according to the control of the control unit 21. The storage unit 27 includes a storage device such as an HDD or an SSD. The storage unit 27 stores various programs executed by the CPU of the control unit 21 and setting information. Further, the storage unit 27 stores a tenant master table T1, a sales management table T2, and a rent management table T3.

  FIG. 4 is a diagram illustrating an example of a data configuration of the tenant master table T1. The tenant master table T1 is a data table for storing and managing information regarding each tenant occupying the complex commercial facility. As illustrated in FIG. 4, the tenant master table T1 includes data items for setting rent conditions and sublease relationships in association with the tenant code and tenant name of each tenant.

  Rent conditions include conditions related to rent calculation. The rent condition can be arbitrarily set regardless of the particular rent condition. For example, a rent calculation method such as a complete pay-as-you-go system or a stepwise pay-as-you-go system may be set as the rent condition. Here, the complete pay-as-you-go system is a calculation method for calculating rent according to sales. The stepwise pay-as-you-go system is a calculation method for calculating a rent corresponding to the sales when the sales exceed the threshold when the sales exceed the threshold when the sales are less than the threshold. For example, as a rent condition, a calculation formula related to rent calculation, a parameter such as a threshold value, or the like may be set. In the present embodiment, it is assumed that the above-described complete pay-as-you-go system or stepwise pay-as-you-go system can be set for each tenant as a calculation method. Also, among the tenants that have a sublease relationship, which will be described later, the rent conditions related to the tenant of the sub-lender (sub-lender) are based on the rent conditions of the tenant of the sub-lender (sub-lender).

  In the sublending relationship, relationship information indicating the relationship is set for a tenant in a sublending relationship (hereinafter referred to as a sublending relationship). Here, FIG. 5 is a diagram for explaining an example of a sublease relationship between tenants. In FIG. 5, an area A <b> 1 indicates a property (sale area) that the tenant A borrows from the complex commercial facility. Area A2 is a part of area A1 and indicates a property that tenant A subleases (or lends) to tenant B. In this case, an inclusive relationship based on sublease, that is, a sublease relationship exists between tenant A that is a sublending source and tenant B that is a sublentor.

  In the sublease relationship of the tenant master table T1, for tenants having a sublease relationship such as the tenants A and B described above, relationship information indicating the relationship between both tenants is set. More specifically, the relationship information indicates a tenant that is in a sublending relationship, and indicates which tenant is a sub-lending source or a sub-lending destination. In the example of FIG. 4, tenants A and B that are in a sublending relationship are associated as related information (see arrows). In addition, this relationship information shows an example in which “summing destination” is set in the tenant A of the sublending source and “summing source” is set in the tenant B of the sublending destination based on the rent summing rule. Note that the format of the relationship information is not limited to the example of FIG.

  Further, the sublease relationship between tenants is not limited to the example of FIG. For example, as shown in FIG. 6, one tenant may sublease to a plurality of other tenants. Here, FIG. 6 is a diagram for explaining another example of the sublease relationship between tenants. In FIG. 6, a region A1 and a region A2 are the same as those in FIG. Area A3 is a part of area A1 and indicates a property that tenant A subleases to tenant C. In such a case, it is assumed that relationship information indicating the relationship is set between tenants A, B, and C that are in a sublease relationship.

  FIG. 7 is a diagram illustrating an example of a data configuration of the sales management table T2. The sales management table T2 is a data table for storing and managing daily sales calculated by each tenant. Specifically, the sales management table T2 stores a tenant code, a tenant name, and daily sales in association with each tenant occupying the complex commercial facility.

  FIG. 8 is a diagram illustrating an example of a data configuration of the rent management table T3. The rent management table T3 is a data table for storing and managing the rent calculated for each tenant. Specifically, the rent management table T3 stores a tenant code, a tenant name, and a rent for each target period in association with each tenant occupying the complex commercial facility. Here, the target period corresponds to a period for calculating rent, such as a monthly installment or a daily installment. In the present embodiment, the target period is described as “monthly”.

  The control unit 21 of the tenant management device 20 registers the sales data transmitted from each of the POS terminals 10 in the sales management table T2 in association with the tenant code of the POS terminal 10. More specifically, the control unit 21 stores business days, sales, and tenant codes included in the sales data in the corresponding data items of the sales management table T2. Further, when the control unit 21 specifies the tenant name corresponding to the tenant code based on the tenant master table T1, the control unit 21 registers the tenant name in the corresponding data item of the sales management table T2. Note that the control unit 21 may sort the sales data registered in the sales management table T2 based on business days and tenant codes.

  The control unit 21 of the tenant management apparatus 20 functions as a selection unit, a first determination unit, a totaling unit, a calculation unit, and a second determination unit, and executes a process (rent calculation process) for calculating the rent of each tenant. .

  Specifically, the control unit 21 selects a target tenant to be a rent calculation target from among a plurality of tenants registered in the tenant master table T1. Further, the control unit 21 determines whether or not the target tenant has a sublease relationship with another tenant based on whether or not the relationship information is set for the target tenant.

  Here, the control unit 21 determines that the target tenant is not in a sublending relationship with another tenant on the condition that no relationship information is set for the target tenant. In this case, the control unit 21 reads the sales for the target period related to the target tenant from the sales management table T2. Then, the control unit 21 calculates the rent of the target tenant based on the sales total result read from the sales management table T2. For example, when calculating the rent of a tenant on a monthly basis, the control unit 21 reads the sales associated with the date of the previous month from the sales management table T2, and calculates the rent for the previous month from the aggregated result.

  Further, the control unit 21 determines that the target tenant has a sublease relationship with another tenant on the condition that the relationship information is set for the target tenant. In this case, the control unit 21 determines whether the target tenant is a tenant of a sublease source (hereinafter referred to as a sublentor source tenant) who subleases the property to another tenant based on the relationship information set for the target tenant. When the control unit 21 determines that the target tenant is a subleasing source tenant, the control unit 21 reads the sales for the target period between the target tenant and another tenant in a sublending relationship with the target tenant from the sales management table T2. Then, the control unit 21 calculates the rent of the target tenant based on the sales total result read from the sales management table T2. In addition, when the control unit 21 determines that the target tenant is a sub-leasing destination tenant (hereinafter referred to as a sub-lending destination tenant) that borrows a property from another tenant, the control unit 21 sets the rent of the target tenant to zero.

  Further, when calculating the rent of the target tenant, the control unit 21 refers to the rent condition (calculation method) set in the tenant master table T1 for the target tenant. When the complete pay-as-you-go system is set as the calculation method, the control unit 21 calculates a rent according to the sales total result based on a predetermined calculation formula. On the other hand, when the stepwise pay-as-you-go system is set as the calculation method, the control unit 21 determines whether or not the sales total result is equal to or greater than a threshold value. When the total result of sales is less than the threshold, the control unit 21 sets a predetermined fixed value as the rent. When the sales total result is equal to or greater than the threshold, the control unit 21 calculates a rent according to the total result.

  Further, the control unit 21 registers the rent derived (calculated, set) for the target tenant in the rent management table T3 in association with the tenant code and the target period of the target tenant.

  Next, the operation of the tenant management device 20 will be described. FIG. 9 is a flowchart illustrating an example of rent calculation processing executed by the tenant management device 20. As a premise of the present embodiment, it is assumed that sales data of each tenant is stored in the sales management table T2.

  First, the control unit 21 of the tenant management device 20 selects one target tenant that is a rent calculation target from tenants registered in the tenant master table T1 (step S11). Next, the control unit 21 determines whether the target tenant is in a sublending relationship with another tenant based on whether or not the relationship information is set for the target tenant (step S12).

  In step S12, when the control unit 21 determines that the target tenant is not in a sublending relationship with another tenant (step S12; No), the sales of the target tenant in the target period are read from the sales management table T2. Next, the control unit 21 totals the sales read from the sales management table T2 (step S13), and proceeds to step S17.

  Further, when the control unit 21 determines that the target tenant has a sublease relationship with another tenant (step S12; Yes), the control unit 21 determines whether the target tenant is a subleasing source tenant based on the relationship information set for the target tenant. (Step S14).

  In step S14, when the control unit 21 determines that the target tenant is a sub-leasing destination tenant (step S14; No), the rent of the target tenant in the target period is set to zero (step S15), and the process proceeds to step S21.

  In addition, when the control unit 21 determines that the target tenant is a subleasing source tenant (step S14; Yes), sales management is performed on sales for the target period for all tenants (including the target tenant) in a sublending relationship with the target tenant. Read from table T2. Next, the control unit 21 totals the sales read from the sales management table T2 (step S16), and proceeds to step S17.

  In step S <b> 17, the control unit 21 refers to the rent condition (calculation method) associated with the target tenant, and determines whether a complete pay-as-you-go system or a stepwise pay-as-you-go system is set (step S <b> 17). When the complete pay-as-you-go system is set (step S17; complete), the control unit 21 calculates the rent according to the counting result of step S13 or S16 (step S18), and proceeds to step S21.

  On the other hand, when the stepwise pay-as-you-go system is set (step S17; stepwise), the control unit 21 determines whether or not the counting result of step S13 or S16 is greater than or equal to the threshold (step S19). When the count result is less than the threshold (step S19; No), the control unit 21 sets a predetermined fixed value as the rent (step S20), and proceeds to step S21. Moreover, when a total result is more than a threshold value (step S19; Yes), the control part 21 calculates the rent according to the total result of step S13 or S16 (step S18), and transfers to step S21.

  Subsequently, the control unit 21 registers the rent set or calculated in any one of steps S15, S18, and S20 in the rent management table T3 as the rent of the target tenant (step S21).

  Subsequently, the control unit 21 refers to the tenant master table T1 and the rent management table T3, and determines whether or not the rent for the target period has been registered for all tenants (step S22). When there is a tenant whose rent is not registered (step S22; No), the control unit 21 selects one of the tenants as a target tenant (step S23), and returns to step S12. Moreover, the control part 21 will complete | finish this process, if registration of the rent is completed about all the tenants (step S22; Yes).

  As described above, the tenant management device 20 of the present embodiment determines the sublease relationship of each tenant based on the relationship information set in the tenant master table T1. Then, the tenant management device 20 calculates the rent of the sub-lending source tenant from the sales of the sub-loaning source tenant and the sub-loaning tenant in the tenant group having the sub-loan relationship, and sets the rent of the sub-lenting tenant to zero. As a result, even if tenants moving into a complex commercial facility include a tenant group that is in a sublending relationship, the rent for that tenant group can be calculated. Can be improved.

  As mentioned above, although embodiment of this invention was described, the said embodiment was shown as an example and is not intending limiting the range of invention. The above-described embodiment can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. The above-described embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and equivalents thereof.

  For example, in the above-described embodiment, an example in which the rent is calculated on a monthly basis has been described. In this case, a target period such as a monthly installment or a daily installment may be set for each tenant in the rent condition of the tenant master table T1. When this form is adopted, the control unit 21 of the tenant management device 20 reads the sales corresponding to the target period set in the rent condition from the sales management table T2 for each target tenant. For example, when calculating the rent on a daily basis, the control unit 21 reads the sales for the previous day from the sales management table T2. Then, the control unit 21 calculates the rent for the target period for each tenant based on the read sales total result.

  In the above embodiment, the tenant management device 20 is configured to hold the tenant master table T1, the sales management table T2, and the rent management table T3. However, the present invention is not limited to this. For example, another device (such as a database server) accessible by the tenant management device 20 may hold part or all of the tenant master table T1, the sales management table T2, and the rent management table T3.

  The program executed by the tenant management apparatus 20 of the above embodiment is a file in an installable format or an executable format, such as a CD-ROM, a flexible disk (FD), a CD-R, a DVD (Digital Versatile Disk), or the like. It may be configured to be recorded on a computer-readable recording medium.

  Further, the program executed by the tenant management apparatus 20 of the above-described embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. In addition, the program executed by the tenant management apparatus 20 of the above embodiment may be configured to be provided or distributed via a network such as the Internet.

  In addition, each function of the tenant management apparatus 20 (control unit) of the above embodiment can be realized by one or a plurality of processing circuits. Here, the processing circuit is a concept including a processor (CPU or the like) and hardware such as an ASIC (Application Specific Integrated Circuit) and a circuit module designed to realize each function.

DESCRIPTION OF SYMBOLS 1 Tenant management system 10 POS terminal 11 Control part 12 Bus 13 Communication interface 14 I / O equipment control part 15 Input part 16 Display part 17 Storage part 20 Tenant management apparatus 21 Control part 22 Bus 23 Communication interface 24 I / O equipment control part 25 Input unit 26 Display unit 27 Storage unit N Network T1 Tenant master table T2 Sales management table T3 Rent management table

JP 2014-174572 A

Claims (5)

An information processing device that calculates rent based on tenant sales,
A selection means for selecting a target tenant for which rent is to be calculated from a plurality of tenants;
First determination means for determining whether the target tenant is a subleasing source tenant that subleases the property to another tenant based on relation information relating a tenant in a sublending relationship among the plurality of tenants;
Aggregating means for totaling the sales of the target tenant and other tenants in a sublending relationship with the target tenant on the condition that the target tenant is the sub-lending source tenant;
Calculating means for calculating the rent of the target tenant based on the counting result of the counting means;
An information processing apparatus comprising: The first determination unit determines whether the target tenant is a sub-loan tenant that subleases a property from another tenant based on the relationship information;
The information processing apparatus according to claim 1, wherein the calculation unit sets the rent of the target tenant to zero on the condition that the target tenant is determined to be the sub-leasing destination tenant. A second determining means for determining whether the counting result of the counting means is equal to or greater than a threshold;
The information processing apparatus according to claim 1, wherein the calculation unit calculates the rent of the target tenant based on the aggregation result on the condition that the aggregation result is equal to or greater than the threshold value.   The information processing apparatus according to claim 3, wherein the calculation unit sets a predetermined fixed value as the rent of the target tenant on the condition that the aggregation result is less than the threshold value. A computer for an information processing device that calculates rent based on tenant sales,
A selection means for selecting a target tenant for which rent is to be calculated from a plurality of tenants;
First determination means for determining whether the target tenant is a subleasing source tenant that subleases the property to another tenant based on relation information relating a tenant in a sublending relationship among the plurality of tenants;
Aggregating means for totaling the sales of the target tenant and other tenants in a sublending relationship with the target tenant on the condition that the target tenant is the sub-lending source tenant;
Calculating means for calculating the rent of the target tenant based on the counting result of the counting means;
Program to make it function.

Images