ITECH1005-5005 Business Information Systems Proof Reading Service

ITECH1005-5005 Business Information Systems Proof Reading Service

Task 1: Calculations

I. Perform the following calculations using formula:

All other calculations required is mentioned in sales tab of excel attached along with this file

II. Total profit, sub-totalled by each

(a)Trade Fair

From the above Pivot table and pie chart it has been observed that clothing, food, wine and computing are the segments of trade fair which constitute major portion of overall profits.

(b)Sales Representative

From the above Pivot table and pie chart it has been observed that Alex and Luke are the Sales representative which provides maximum contribution profits of BMEC

III. Total hours worked, sub-totalled by each

(a)Trade Fair

From the above Pivot table and pie chart it has been observed that clothing, food, wine and computing are the segments of trade fair which takes major time spent by sales representative in hours

(b)Sales Representative

From the above Pivot table and pie chart it has been observed that Chris and Luke are the Sales representative which take maximum time in hours

Task 2: Observations

I.BEMC’s five best and five worst customers by total profit

(a)Worst 5 customers of BMEC in terms of profits

The above table and charts shows the negative profits or losses attained due to worst 5 customers of the group. BMEC should work in the direction of improving or enhancing the performance of particular customers to at least bring them to breakeven level

(b)Top 5 customers of BMEC in terms of profits

As per the above charts and pie diagrams it tabulates and present in the pictorial form the top leading profit generating customer of BMEC group. Company should sustain these customer and create further relations to increase the revenue.

II.BEMC’s best and worst Trade Fairs by total profit

III.BEMC’s best and worst sales representatives by total income

Task 3: Recommendations

I.Should BEMC focus on any particular

(a)Customer

Although BMEC should not neglect any customers, as customers are the king pin of the market and neglecting customer will decrease the brand image of the group. Still special attention is given to the special group of customer which provides sustainable markets, are regular customers of the group. Onlyscotchco is returning customer of the group and lead the chart of top 5 customer of the group in terms of profitability.

(b)Trade Fair

BMEC should put its major strive of work on food and wine segment of the trade fair. In terms of profitability both leads the chart and is main revenue supplier for the group. Further steps are taken to improve the particular segment. Company should categorise the total number of fairs according to ABC analysis. Top revenue generating trade fair segments are placed in A category. Accordingly other trade fairs are categorised in B and C category.

II.What are your recommendation regarding what other data should be collected to improve decision making for BEMC?

Company should add a column for sales representative earnings made by them in quantitative form. Further to improve the decision making apart from past cost and profit data future predicts on the basis of prospective budgets should also be made accordingly. Preparation of budgets and various tools of financial management will help the business in making analysis and proper decision making.