MyAssignmentHelpAU January 17, 2019
The report examines the business of BEMC, an event management company which deals in promoting and selling stand space at trade fairs as well tickets for visitors. The data includes the sources of income and expenses for BEMC during the first half of 2016. It is observed that BEMC earned a total income of 367,536 AUD while its expenses were 282,409 AUD giving a net profit of 85,127 AUD. The objective of the analysis is to cut down expenses and increase business turnover bringing more profitability to the company.
Analysis of the data tells that not all trade fairs are equally profitable. BEMC must try to engage more in trade fairs like books and government in which average profit is highest. At the same time, there are a few customers which have earned the highest gross profit for BEMC and cover more than 10% of the total profit. BEMC must try to have such repeat customers again and again. One of the income sources for BEMC is selling of tickets on which it earns 1.5 AUD for each ticket sold. However, there is no incentive for a sales representative to sell more tickets since his wages and commission depend only on the number of hours and the commission earned by BEMC on the space rent. It is suggested that sales representative’s wage be directly linked with the number of tickets sold as well.
In a few cases, BEMC has even made a loss in its deals. On analyzing, it is observed that the number of hours reported by sales representative is too high for such cases even though not many activities have been done. BEMC must ensure an accurate attendance monitoring system to track the number of hours spent by a sales representative.
Table of Contents
The data consists of a sample of 200 trade fairs falling into 12 different categories. BEMC has 4 sales representatives – Alex, Chris, Jane and Luke looking after the sales of tickets and bringing in customers. There are a total of 141 customers among which some are new and some are repeating customers. BEMC has made a total profit of 85,126 AUD in the first half of 2016
Sources of income for BEMC are collecting fees from customers for the following activities:
Apart from these, income sources are commission on rent and revenue from sale of tickets.
The expenses include fees paid for all the above activities plus the wages and commissions paid to the sales representatives.
Revenue from ticket sales = 1.5 x Number of tickets sold
Total Rent = Rent per sq. meter x Area (sq. m)
Commission received by BEMC on space rent = Commission % x Total Rent
Sales representative wages = 60 x No. of hours spent by the sales representative
Sales rep. commission = Commission % x (Commission received by BEMC on space rent)
Profit = Total Income – Total Expenses
Below graph shows the total gross profits earned by a particular category of trade fair. It can be seen that food trade fairs top the list while manufacturing trade fairs are the bottom of the list in terms of profits.
The total number of trade fairs category wise can be seen below. It is evident that there has been a lot of food and wine trade fairs organized in the first half of the year.
The chart below shows the average profit earned by a particular category of trade fair. Although government and books trade fairs do not happen too often, it is important to note that they are the highest profit earning trade fairs for BEMC.
Below is a graph showing the performance of sales representatives. It can be seen that Chris has outperformed his colleagues earning a maximum profit for BEMC.
The chart below shows the income earned for BEMC by each of the sales representative. It can be seen that although Jane has earned lesser total income than Alex, Jane has earned more profit for BEMC than Alex.
The gross profit earned by each of the sales representative should be proportional to the number of hours they have spent to reflect the results of their efforts. To see this, we draw the chart below. As expected, Chris has spent the maximum number of hours and thus has earned the maximum profit for the company followed by Luke. However, Alex has spent more number of hours than Jane and has thus earned more than Jane but contributed less to the profit for BEMC.
Effect of increasing wages by 40%
As can be seen from the chart below, increase in wages by 40% will lead to an overall decrease in profits from 85,127 to 52,647 AUD.
The list below shows the top 5 valuable customers for BEMC. They collectively account for 10% of the total profit earned by a total 141 customers.
BEMC should focus on the following trade fairs – Government, Books, Builders and Food. These trade fairs have earned the highest average profit to BEMC. The chart below shows the average profit earned by trade fairs:
The top 5 most valuable customers of BEMC are – kerplonk, readit, bottomsup, magazine and onlyscotchco. Focusing on these customers is essential as they re major contributors to total profit. The graph below shows the profit earned by the company from these customers.
Feedback must be obtained from the customers to know their expectations. It is essential to increase the number of returning customers to enhance total profit earned.
Also, the market rate for organizing the trade fair must also be determined. This will help in determining the optimum price that should be set for each of the trade fairs and thus attract more customers.
III. What are your recommendation regarding record-keeping to improve the quality of data collection and management?
It is important to verify that the data collected is accurate. This can be done by ensuring that there are multiple sources of data provision. For example, sales representatives can check if the number of tickets being entered is correct and highlight them if they are not correct. Further, all data should be centrally stored with a pre-defined format so that it is visible to all concerned departments. Maintaining different files and different formats of data often creates confusion.
Further, attendance monitoring should be strict to keep a check on the number of hours spent by a sales representative.
At present, Sales representatives are paid a wage for the number of hours they spend and a commission based on the rent income BEMC receives due to the customer brought by the representative.
Instead of making the wage dependent only on the number of hours, it should also depend on the number of tickets sold because that is how BEMC is earning too. BEMC receives a fee of 1.50 USD per ticket sold. On an average, 21 tickets are sold in an hour by a sales representative. It is proposed that implementing this strategy will improve the efficiency of the sales representative.
Further, performance bonus should also be provided to sales representatives with excellent performance.
Kelley, T.J., 2002. Using Graphs and Visuals to Present Financial Information. Retrieved from http://home.xnet.com/~jkelley/Publications/Using_Graphs.pdf
Levine, D.M., Berenson, M.L. and Stephan, D., 1999. Statistics for managers using Microsoft Excel (Vol. 660). Upper Saddle River, NJ: Prentice Hall.
MyAssignmentHelpAu provides the ideal service for all your assignment and homework related tasks to be completed within the specified time. We are available round the clock to resolve your academic queries. Comprised of more than 4000 learned experts, we promise to provide well research and top-notch quality assignments. Our assignment writing services is not bound to the countries of Australia and UK rather stretches to USA, UAE , Singapore and Malaysia. We pay scrupulous attention to each assignment and provide services that include assignment help, homework help, case study help, coursework help, dissertation help and CDR Report help. Avail the best my assignment help and services at competitive price. We promise ultimate customer satisfaction.
Earlier I used to mess up with numerous academic tasks and was finding it hard to perform well in all the assignments. But when I came across MyAssignmentHelpAu, I just breathed deep as I got a best platform from where I can get best and most effective assignment help. Experts, at this platform offered the best writing help to me. Thank you MyAssignmentHelpAu
To me, the assignments are similar to the nuts which are hard to break. To complete all the relevant assignments is just not an easy task. But team of MyassignmentHelpAu helped me with all the assignment related problems. They served finest assignment solutions for my psychology homework. All my queries have been efficiently solved by them.
I was confused with the various assignment help websites. It was hard for me to select the one which could provide me better service on my assignment solutions. Then, as per my friend’s suggestion, I tried MyAssignmentHelpAu to avail my humanities assignment. And I am glad to share my experience as they provided me the optimum content at very pocket friendly rates.
Myassignmenthelpau helps me to complete my management assignment within three hours. It is one of the top assignment help provider on which everyone can trust blindly. Myassignmenthelpau has a team of well-versed experts that are able to provide quality assignments all over Australia. I am impressed with their services and will contact them again in the future.
I was scared when I was unable to complete my computer science assignment within the deadline. My friend informed me about the Myassignmenthelpau and I avail their services. I am very thankful to them for making my assignment. My professor was so impressed by my assignment and gave me good grades.