Profitability and marker share

Executive summary

This document provides a report on some aspects of EUHOME real-estate agency business that include profitability and market share, employee satisfaction, appropriateness of the new regional classification and possible expansion to Switzerland. The main reason for the investigation is the managing director’s request to do this.

In addition, several suggestions are provided for the future survey within the management staff. Recommendations on further investigations in the problem as well as the possible error in the provided data are mentioned at the end of the report.

Content

Executive summary 2

Contents 3

1. Introduction 4

2. Profitability and marker share 8

3. Employee satisfaction

4. Appropriateness of the new regional classification

5. Possible expansion to Switzerland

Introduction

The purpose of the report is to summarize and analyze the given information and to show it in a proper way. The data was provided by Emma Morgan, Managing Director of EUHOME real-estate agency.

The report aims to improve understanding of the company’s management on the aspects mentioned in the heading of the report and gives some advices how to improve efficiency of the company.

In order to present the information and describe the findings diagrams, tables and charts were constructed and I have added some information in to the given Excel document. The provided data was summarized and calculated for the purposes of a better presentation of conclusions. Also some calculations have been made.

Profitability and marker share

Country	Revenue share	Annual wage	Costs	Annual profit
Austria	12 029 416,00 €	0,00 €	12 029 416,00 €	12 029 416,00 €
Belgium	6 701 299,80 €	1 699 676,16 €	8 400 975,96 €	13 936 690,04 €
Bulgaria	1 413 104,50 €	202 641,65 €	1 615 746,15 €	1 210 462,85 €
Croatia	3 711 594,40 €	298 880,40 €	4 010 474,80 €	5 268 511,20 €
Cyprus	338 717,50 €	0,00 €	338 717,50 €	338 717,50 €
Czech Republic	1 766 653,50 €	100 464,00 €	1 867 117,50 €	1 666 189,50 €
Denmark	15 734 831,50 €	0,00 €	15 734 831,50 €	15 734 831,50 €
Estonia	541 378,00 €	54 427,89 €	595 805,89 €	757 639,11 €
Finland	5 694 831,00 €	0,00 €	5 694 831,00 €	5 694 831,00 €
France	27 831 745,50 €	884 609,44 €	28 716 354,94 €	64 056 130,06 €
Germany	47 768 121,50 €	0,00 €	47 768 121,50 €	47 768 121,50 €
Greece	2 681 595,20 €	323 718,28 €	3 005 313,48 €	3 698 674,52 €
Hungary	20 731 481,00 €	532 155,00 €	21 263 636,00 €	20 199 326,00 €
Ireland	158 298,90 €	148 650,25 €	306 949,15 €	220 713,85 €
Italy	10 232 181,50 €	0,00 €	10 232 181,50 €	10 232 181,50 €
Latvia	6 342 796,00 €	211 473,96 €	6 554 269,96 €	6 131 322,04 €
Lithuania	964 825,00 €	89 726,56 €	1 054 551,56 €	875 098,44 €
Luxembourg	338 469,90 €	66 722,10 €	405 192,00 €	723 041,00 €
Malta	18 160,40 €	7 180,65 €	25 341,05 €	20 059,95 €
Netherlands	650 943,30 €	138 911,05 €	789 854,35 €	1 379 956,65 €
Poland	2 162 205,20 €	123 617,52 €	2 285 822,72 €	3 119 690,28 €
Portugal	915 741,20 €	408 882,24 €	1 324 623,44 €	964 729,56 €
Romania	8 722 254,00 €	449 728,80 €	9 171 982,80 €	8 272 525,20 €
Slovakia	624 730,00 €	96 239,52 €	720 969,52 €	528 490,48 €
Slovenia	621 316,00 €	165 843,32 €	787 159,32 €	766 130,68 €
Spain	19 198 953,60 €	1 853 735,52 €	21 052 689,12 €	26 944 694,88 €
Sweden	3 489 626,00 €	0,00 €	3 489 626,00 €	3 489 626,00 €
United Kingdom	56 238 696,60 €	3 132 809,68 €	59 371 506,28 €	128 090 815,72 €

In the table above there is information that I have added to the existing one cause there was not enough of it. All data presented in the table has been calculated by formulas.

As we can see in the table the highest profit is generated in the UK, profit generated in France and Germany is quite high as well. But annual profit does not show the most productive country, in order to find it we should calculate profit per staff hour which is shown in the chart below.

The chart above shows that the most productive branches are situated in France and United Kingdom.
Also you might want to know average productivity in the company, we can find it by calculations. Formula to find it: sum of profits per office staff hour in all countries divided by the amount of countries = 2293,04/28,89= 81,89€.

It would make most sense to increase the number of office staff hours in the most productive countries in order to get very high increase in profit while in countries with low productivity the number of office staff hours should be reduced because the productivity is low and reduction of cost might increase profit in these countries.

There is not enough information to calculate the market share of the company in different companies because we do not have any information about rival firms, their and our amount of sales.

Дата добавления: 2015-10-31