Cálculo de presupuestos estimativos para las áreas estándar que componen los establecimientos de hotelería

Abstract

The objective is to develop a parameterized office automation tool that allows calculating estimated budgets for the areas that make up a hotel, taking into account the standard of each one of them, to generate a correct real estate appraisal. This means that by being able to correctly assess the elements that make up the hotel, the appraisal will be more accurate and thereby ensures the transparency of the negotiations that derive from it. Its development is part of the analysis process on the applications and instruments from which the calculation processes of approximate work budgets are carried out for the basic areas of the hotels, in such a way that the development of an office automation tool that facilitates these calculations and improve the times and precision with which these budgets are estimated and executed. In this sense, the study focuses on analyzing a series of reference budgets for these standard areas at the national level, making calculations from these references based on construction standards, parameterizing an office tool using Microsoft Office Excel, verifying the calculated budgets against to the references and apply the residual methodology for the elaboration of an appraisal of the hotel establishment. This from a proposal for quantitative and qualitative analysis located within the framework of an analytical and descriptive methodology applied to research that provides for the development of technological devices that support the appraisal process. In this way, for the application of the technological tool from the office suite, the general document is designed using the Microsoft Excel program, being formulated in accordance with the need chosen by the standards of the hotels to be referenced, specifying that the Sonesta brands, Collection, Sheraton, were chosen as the object of study, for which, the calculation processes of approximate work budgets are carried out for the basic areas of the hotels, under parameters of construction typology areas, two analyzes are carried out: Analysis 1: The three related brands are calculated, from the initial phase of construction: Hotel Brand (Hotel brand, type of building, city, year and TRM) and Operation Data (King Room, Twin Room, Club Suite Room, Junior Suite Room, Meeting rooms and hotel equipment) and Analysis 2: The conditions of the built building of the three selected brands are analyzed: Parameter (Hotel brand, type of building) ion, city, year and TRM) and operation data (Building construction area and direct cost Hotel M2 construction area), in order to incorporate these quantifications into the model and carry out the calculation, according to the variable of each hotel brand, yielding results for each model, therefore, it is concluded that there is a variation for each hotel standard, according to the brand parameters of each hotel, city, type of room, number of rooms and additional support areas: lounges, among others. . Similarly, an increase in the cost of construction of the Sonesta brand over GHL Collection of 10% and 13% of Sheraton over the GHL Collection brand is identified; that is, there is a variation in construction cost according to the brand, given this, the cost of construction cannot be unified or generalized for different hotel brands. Finally, when developing the office automation tool, the parameterization that allows calculating estimated budgets for the areas that make up the hotels under study is established, taking into account the standard of each one of them, generating a correct real estate appraisal.