The new formulaI started to work on an alternative way of calculating office rent because I think the way it is calculated today very odd - the values tend to change every week - and I'm not sure if it considers the economy level of the countries or the size of the airport appropriately. Initially, I thought the values deducted from my airline were too cheap in some countries and too expensive in others...
In real life I am an engineer specialized in real estate. The formulas we use to estimate sale and rental values are really complex and takes into account dozens of factors in order to take into account its location, its desirability and its feasibility for its intended use, for example. For AWS I created a simpler formula which takes into account the following factors:
- base level;
- number of office staff (excluding pilots, cabin crew and other airport related staff) at a base;
- the infrastructure and traffic level of the airport (higher traffic and infra equals higher costs);
- the country's salary level (to balance the values according to the country's economy strenght);
- company image (Higher CI means offices of higher standard so it grows at higher rates).
Basically, the office rent formula I propose is:
R = A*k, where
R = office rent,
A = office area and
k = its value per square meter or square feet.
The office area is calculated by summing up all the company's staff excluding pilots, cabin crew, safety, ground handling and technical services personnel (which I call airport staff), and multiplying the result by 13,91 m² (150 square feet, same ratio used by 42floors.com to estimate the office area required for staff).
The factor
k is a function of all the factors mentioned above and is shown in the spreadsheet/calculator attached to this post. It was made to use the office area in square meters and will give the office rent value
per month in US dollars.
You can download the spreadsheet/calculator and simulate the values given for your airline. Play with the values to see how the factors will influence the final result. In short, compared to the current way AWS calculates office rent, it is expected to increase the values significantly in large, higher level airports in countries with high salary level, and decrease the values significantly in smaller, lower level airports in countries with low salary level. The values seem to be consistent to real life office rents I have researched when testing the formula.
Link for spreadsheet (safe download - no macros)IMPORTANT NOTICE - The company image to be used must be between 0 and 100, so any airline with negative CI must be considered with CI=0. Although the formula works with negative CI values, it will give irrealisticaly low results.
How office rent calculation should changeBesides the adoption of the new formula above, the following changes should be applied:
- Office rent would be deducted monthly and their costs would be fixed throughout the year;
- Each base will have its own parameters considered individually for office rent calculation, and the company-wide result will be the sum of all of the bases rents;
- New values for the next year would be calculated at the last day of the current year using the airline and airport parameters in that day;
- The registration of office rent deductions could follow the model used for aircraft leasings;