Apartment building repair cost calculation system, repair cost calculation method, and repair cost calculation program

Abstract

This system provides a way to quickly calculate the cost of large-scale repairs to condominiums without requiring specialized knowledge, and enables the determination of surpluses or deficits in repair reserve funds, as well as future forecasts. [Solution] The system automatically calculates the total repair cost by inputting basic building information (total floor area, number of floors, number of elevators, number of parking spaces, number of units, etc.) and combining multiple calculation methods (total floor area x unit price, number of elevators x unit price, etc.). It also determines whether there is a surplus or deficit by comparing it with the current reserve fund balance, predicts the reserve fund balance for the planned period, and calculates the feasible timing for repairs. Furthermore, it includes a future prediction function that takes into account the amount of compensation from external services, an automatic property information saving function, and a centralized management function for all properties via an administrator dashboard.

Description

Technical Field

[0003]

[0001] The present invention relates to a system, method, and program for automatically calculating the costs required for large-scale repairs in apartment buildings such as condominiums and determining the surplus or deficit of repair reserve funds. In particular, it relates to a technology for automatically calculating repair costs from the physical characteristics of a building (floor area, number of floors, number of elevators, number of parking spaces, etc.), determining the surplus or deficit by comparing with the current balance of the reserve fund, predicting future reserve funds, and calculating the possible repair time.

Background Art

[0002] In apartment buildings such as condominiums, regular large-scale repair work is necessary to address the aging deterioration of the building. These repair works require a large amount of money, and it is common to secure funds through repair reserve funds collected monthly from the co-owners.

[0003] Conventionally, the calculation of repair costs has relied on on-site inspections and estimates by professionals, making it difficult for management associations and real estate management companies to easily grasp the costs. Also, determining whether the current balance of the reserve fund is sufficient for future repairs has required specialized knowledge.

[0004] Patent Document 1 discloses a repair plan system based on building deterioration diagnosis, but it does not have a function to automatically calculate repair costs from only the basic information of the building. Also, Patent Document 2 discloses a management system for repair reserve funds, but it does not disclose an automatic calculation function for repair costs combining multiple calculation methods and a future prediction function considering the amount of supplementary funds.

Prior Art Documents

Patent Documents

[0005]

Patent Document 1

Patent Document 2

Summary of the Invention

[0006] Conventional technologies had the following problems:

[0007] Firstly, calculating repair costs required hiring specialists, which was time-consuming and costly. There was no way for management associations or property management companies to quickly estimate costs based solely on basic building information.

[0008] Secondly, determining whether the repair reserve fund was surplus or deficit was difficult. Comparing the current reserve fund balance with the repair costs that will be needed in the future and evaluating the appropriateness of the financial plan required specialized knowledge.

[0009] Thirdly, it was difficult to predict the future use of revenue from external services (such as issuing important matters investigation reports) for repair funds. There was no means to simulate the trend of the reserve fund while taking into account the amount of compensation.

[0010] Fourthly, there was no means to efficiently manage multiple properties. There was no system that had the functionality to save calculation results for each property and manage their history.

[0011] This invention has been made in view of the above problems, and aims to provide a condominium repair cost calculation system, method, and program that automatically calculates repair costs from basic building information, enables simulations that take into account surplus or deficit determination of reserve funds, future predictions, and compensation amounts. [Means for solving the problem]

[0012] To solve the above problems, the condominium repair cost calculation system of the present invention has the following configuration.

[0013] (1) Building information input method: A method for inputting total floor area, number of floors, number of elevators, number of parking spaces, number of units, current reserve fund balance, year of construction, and scheduled date of the next major repair.

[0014] (2) Repair cost calculation means: Means for automatically calculating the total repair cost by combining a plurality of calculation methods (floor area × unit price, number of elevators × unit price, number of parking spaces × unit price, number of households × unit price, rooftop area × unit price, number of floors × unit price, fixed amount).

[0015] (3) Excess / deficiency determination means: Means for comparing the current balance of the reserve fund with the total repair cost and determining the excess / deficiency.

[0016] (4) Future prediction means: Means for predicting the balance of the reserve fund and the excess / deficiency at the scheduled time (N years later).

[0017] (5) Calculation means for the period when repair can be carried out: Means for calculating the time when the repair cost is reached based on the current savings rate.

[0018] (6) Supplementary amount calculation means: Input the income (supplementary amount) from external services, The aforementioned compensation amount is converted to an annual amount and added to the reserve fund balance at the scheduled time predicted by the aforementioned future forecasting means. means

[0019] (7) Property information storage means: Means for automatically storing property information during calculation execution and selecting and loading saved properties.

[0020] (8) Administrator dashboard: Means for listing property information and calculation history of all accounts.

Advantages of the Invention

[0021] According to the present invention, the following effects can be obtained.

[0022] First, by simply inputting the basic information of the building, it is possible to quickly grasp the approximate repair cost even without professional knowledge. This significantly improves the business efficiency of management associations and real estate management companies.

[0023] Second, by automatically determining the excess / deficiency of the repair reserve fund and visually displaying it in an easy-to-understand manner, it becomes easier to evaluate the validity of the fund plan.

[0024] Third, by future prediction considering the supplementary amount, it becomes possible to simulate the effect of introducing external services, which contributes to supporting business decisions.

[0025] Fourthly, the automatic saving function of property information enables efficient management of multiple properties. The administrator can comprehensively grasp the calculation status of all accounts.

Brief Description of the Drawings

[0026] [Figure 1] It is a block diagram showing the overall configuration of the system [Figure 2] It is a screen for inputting building information [Figure 3] It is a screen for displaying calculation results [Figure 4] It is a screen for displaying a graph [Figure 5] It is a screen for managing repair items [Figure 6] It is a screen for the administrator to manage accounts [Figure 7] It is a diagram showing the database structure of the system [Figure 8] It is a screen showing the procedure for calculating repair costs

Modes for Carrying Out the Invention

[0027] Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. System Configuration

[0028] FIG. 1 is a block diagram showing the overall configuration of an apartment repair cost calculation system according to the present invention. This system is composed of a client terminal (10), a Web server (20), and a database server (30).

[0029] The client terminal (10) is a personal computer equipped with a Web browser, a tablet terminal, or a smartphone. The user accesses this system from the client terminal (10) via a Web browser.

[0030] The web server (20) includes a user interface provision unit (21), a repair cost calculation unit (22), a surplus / deficit determination unit (23), a future forecast unit (24), a compensation amount calculation unit (25), a property information management unit (26), and an account management unit (27).

[0031] The database server (30) stores account information (31), repair item master (32), calculation history (33), and saved property information (34). Repair cost calculation process

[0032] Figure 8 is a flowchart of the repair cost calculation process. Each step is explained below.

[0033] Step S1: The user enters building information (total floor area, number of floors, number of elevators, number of parking spaces, number of units, current reserve fund balance, year of construction, and scheduled date for the next major repair).

[0034] Step S2: The system calculates the cost of each repair item based on the entered building information and repair item master. There are seven calculation methods: • Total floor area × unit price: Exterior wall painting, waterproofing work, etc. • Number of elevators × Unit price: Elevator replacement • Number of parking spaces × Unit price: Parking lot repair • Number of units × Unit price: Water supply and drainage pipe replacement, intercom replacement, etc. • Rooftop area (total floor area ÷ number of floors) × unit price: Rooftop waterproofing • Number of floors × Unit price: Painting of common corridors, etc. • Fixed amount: Design and supervision fees, common temporary construction costs, etc.

[0035] Step S3: Add up the costs for each repair item to calculate the total repair cost.

[0036] Step S4: Compare the current reserve fund balance with the total repair costs to determine any surplus or deficit.

[0037] Step S5: Predict the future balance of the reserve fund based on the total monthly contributions and the planned timeframe (after N years).

[0038] Step S6: If the compensation amount is valid, make a future forecast including the compensation. Convert the compensation amount to an annual amount using the following formula. Annual compensation amount = Amount after the reassessment comes into effect (A) × N times / year + Amount after ownership transfer (B) × N times / year

[0039] Step S7: Display the calculation results and automatically save the property information. Database structure

[0040] Figure 7 is an ER diagram showing the database structure of this system. The main tables are as follows:

[0041] The account table (accounts) stores user ID, email address, company name, authority (administrator / general user), creation date and time, and last login date and time.

[0042] Repair items table (repair_items): Stores item ID, account ID, repair item name, calculation method, and unit price. If the account ID is NULL, it is treated as the default template.

[0043] Calculation history table (calculation_logs): Stores history ID, account ID, building name, reserve fund balance, total repair cost, planned date, planned reserve fund balance, surplus / deficit, deficit flag, and calculation date and time.

[0044] The saved buildings table (saved_buildings) stores the property ID, account ID, building name, all building information, calculation results, and compensation amount settings. If the same account and building name are used, the existing data will be overwritten. Screen configuration

[0045] Figure 2 shows the building information input screen. A dropdown menu for selecting saved properties is located at the top of the screen, allowing users to select and load properties that have been calculated in the past. The input items are building name, total floor area, number of floors, number of elevators, number of parking spaces, current reserve fund balance, year of construction, next major repair scheduled date, and breakdown of repair reserve fund (monthly amount by type and number of units).

[0046] Figure 3 shows the calculation results display screen. It displays the current surplus / deficit, the possible repair time, the reserve fund balance at the planned time, and the surplus / deficit at the planned time. If the compensation amount is valid, the annual reserve fund amount including the compensation and the future forecast including the compensation are also displayed.

[0047] Figure 4 shows the graph display screen. A pie chart shows the breakdown of repair costs, and a line graph shows the projected trend of the reserve fund. If the compensation amount is valid, two lines are displayed for comparison: one without compensation (dotted line) and one with compensation (solid line).

[0048] Figure 5 shows the repair item management screen. Each account can set its own repair items and unit prices. Administrators can manage default templates, which are automatically copied when a new account is registered.

[0049] Figure 6 shows the administrator dashboard screen. It displays a summary of the total number of accounts, active users, total calculations, number of saved properties, and reserve fund deficit rate. It also displays a list of saved properties for all accounts, allowing users to see which company is calculating which properties. [Industrial applicability]

[0050] This invention can be widely used by condominium management associations, real estate management companies, condominium sales companies, construction consultants, and the like. In particular, it is useful for estimating repair costs, evaluating the validity of financial plans, and creating sales proposal materials. [Explanation of symbols]

[0051] 10 client terminals 20 Web Servers 21 User Interface Provision Department 22 Repair Cost Calculation Department 23 Excess / deficiency determination section 24. Future Forecasting Department 25 Compensation Amount Calculation Department 26 Property Information Management Department 27 Account Management Department 30 Database Servers 31 Account Information 32 Repair Item Master 33 Calculation History 34 Saved Property Information

Claims

1. This is a system for calculating the costs necessary for large-scale repairs to condominiums. A building information input method for inputting building information including the total floor area, number of floors, number of elevators, number of parking spaces, number of units, current reserve fund balance, year of construction, and planned date of the next major repair, A repair cost calculation method that calculates the total repair cost by combining calculation methods for total floor area × unit price, number of elevators × unit price, number of parking spaces × unit price, number of units × unit price, rooftop area × unit price, number of floors × unit price, and fixed amount, based on the aforementioned building information, A means for determining a surplus or deficit by comparing the current reserve fund balance with the total repair cost, A future forecasting means that predicts the balance of the reserve fund at the scheduled time based on the total monthly reserve fund and the scheduled date of the next major repair, A condominium repair cost calculation system characterized by comprising the following features.

2. The condominium repair cost calculation system according to claim 1, further comprising a means for calculating the period until the current reserve fund balance reaches the total repair cost.

3. The system further includes a compensation amount calculation means that inputs revenue from external services as the compensation amount, converts the compensation amount to an annual amount, and adds it to the reserve fund balance at the scheduled time predicted by the future forecast means, The condominium repair cost calculation system according to claim 1 or 2, characterized in that the compensation amount calculation means calculates the annual compensation amount as the sum of the value obtained by multiplying the first compensation amount by the first annual occurrence number and the value obtained by multiplying the second compensation amount by the second annual occurrence number.

4. The system includes a checkbox to enable or disable the compensation amount calculation means, The condominium repair cost calculation system according to claim 3, characterized in that it displays the calculation result without considering the compensation amount when it is invalid, and displays a comparative display of both the calculation results with and without compensation when it is valid.

5. Property information storage means that automatically saves the building information and calculation results when the calculation is performed by the repair cost calculation means, The system further comprises a property information reading means for selecting saved property information and loading it into the building information input means, The condominium repair cost calculation system according to claim 1, characterized in that property information with the same building name is overwritten and updated.

6. An account management method for managing multiple user accounts, The administrator dashboard allows users with administrator privileges to view a list of saved property information for all accounts, The condominium repair cost calculation system according to claim 5, further comprising the ability for the administrator to select saved properties from any account and perform calculations.

7. A repair item management system that allows each user account to set its own repair items and unit prices, A template management system for managing default repair item templates, The condominium repair cost calculation system according to claim 6, further comprising the feature that the default template is automatically copied when a new account is registered.

8. A system for calculating the costs necessary for large-scale repairs of an apartment building, A building information input method for inputting building information including the total floor area, number of floors, number of elevators, number of parking spaces, number of units, current reserve fund balance, year of construction, and planned date of the next major repair, A repair cost calculation method that calculates the total repair cost by combining calculation methods for total floor area × unit price, number of elevators × unit price, number of parking spaces × unit price, number of units × unit price, rooftop area × unit price, number of floors × unit price, and fixed amount, based on the aforementioned building information, A means for determining a surplus or deficit by comparing the current reserve fund balance with the total repair cost, A future forecasting means that predicts the balance of the reserve fund at the scheduled time based on the total monthly reserve fund and the scheduled date of the next major repair, Equipped with, The system further includes a means for calculating the compensation amount, which inputs revenue from external services as the compensation amount, converts the compensation amount to an annual amount, and adds it to the reserve fund balance at the planned time predicted by the future forecast. The compensation amount calculation means calculates the annual compensation amount as the sum of the value obtained by multiplying the first compensation amount by the first annual occurrence number and the value obtained by multiplying the second compensation amount by the second annual occurrence number. The system further includes a graphing means that displays the breakdown of the total repair costs in a pie chart and the projected trend of the reserve fund balance in a line graph. A condominium repair cost calculation system characterized in that, when the compensation amount calculation means is effective, the line graph displays the trend without compensation as a dotted line and the trend with compensation as a solid line for comparison.

9. A method for a computer to calculate the costs required for large-scale repairs to an apartment building, comprising the steps of inputting building information including the total floor area, number of floors, number of elevators, number of parking spaces, number of units, current reserve fund balance, age of the building, and the planned date of the next large-scale repair, Based on the aforementioned building information, the total repair cost is calculated by combining multiple calculation methods. The steps include: comparing the current reserve fund balance with the total repair costs to determine whether there is a surplus or deficit; The steps include predicting the reserve fund balance at the scheduled time based on the total monthly reserve fund and the scheduled date of the next major repair, The steps include converting the compensation amount from external services into an annual amount and making future forecasts including compensation, The steps include automatically saving the aforementioned building information and calculation results, A method for calculating apartment building repair costs, characterized by including [a specific element].

10. Computers, A building information input method for entering building information including the total floor area, number of floors, number of elevators, number of parking spaces, number of units, current reserve fund balance, year of construction, and planned date for the next major repair. A repair cost calculation means that calculates the total repair cost by combining multiple calculation methods based on the aforementioned building information. A means for determining whether there is a surplus or deficit by comparing the current reserve fund balance with the total repair cost, A future forecasting means that predicts the balance of the reserve fund at the scheduled time based on the total monthly reserve fund and the scheduled date of the next major repair. A compensation amount calculation method that converts the compensation amount from external services into an annual amount and makes future forecasts including compensation. Property information storage means for automatically saving the aforementioned building information and calculation results, A condominium repair cost calculation program characterized by its function as such.

Images