ITECH 1005-5005 Business Information Systems Assignment Help

ITECH 1005-5005 Business Information Systems Assignment Help

ITECH 1005-5005 Business Information Systems Assignment Help

Introduction

In this report, there are various aspects of the business analyzed which could affect the success and development of the organization. These factors include customers, the cost of value added services, the performance of sales representatives etc. We will be analyzing these factors with the help of pivot tables, graphs, and pie charts. We will also provide some recommendation on how an organization can increase its financial performance and improve its decision-making process. We have evaluated the financial data of Ballarat Event Management Company (BEMC), for a better understanding of an organization in a business environment.           

ITECH 1005-5005 Business Information Systems Assignment HelpTask 1- Calculations

1.1Required formulas and calculations

Service value for each value added service

BMEC is charging various kinds of value added services in trade fairs like travel arrangements, accommodation arrangements, and other hospitality services. For each of these services, fees are charged by the organization at a different rate. Total fee charged for these services are $ 233300.  

Formula- Rate for each service * Number of services provides

Calculation-

Service fees for each value added service

Service

Total fees

No. of service

Calculation

Total service charged

Exhibitor stand organized

1500

34

1500*34

51000.00

Exhibitor travel organised 

1000

68

1000*67

68000.00

Exhibitor accommodation arrangement

800

66

800*65

52800.00

Exhibitor marketing material organized

500

69

500*69

34500.00

Exhibitors hospitality organized

600

45

600*45

27000.00

Total

4400

282

 

233300.00

Cost of each Value added service

Similar to the fees charges, the cost incurred on these services are also different. The total cost incurred by BMEC on these services is $ 179550.

Formula- Cost of each service * Number of services provided

Calculation

Cost for each value added service

Service

Total fees

No. of service

Calculation

Service fees per service

Exhibitor stand organized

1150

34

1150*34

39100.00

Exhibitor travel organised 

850

68

850*68

57800.00

Exhibitor accommodation arrangement

650

66

650*66

42900.00

Exhibitor marketing material organized

250

69

250*69

17250.00

Exhibitors hospitality organized

500

45

500*45

22500.00

Total

3400

282

 

179550.00

Total revenue from ticket sale

The company has charged AUD 1.5 for each of the ticket sold in trade fairs.  

Formula- total number of tickets sold * Rate per ticket

Calculation-

Total revenue from ticket sale

Sale price per visitor ticket(a)

1.5

Total tickets sold (b)

28987

Total revenue from ticket sale(a*b)

43480.5

Commission received from space rent

Formula- total fair charged * rate of commission

Calculations

 

Particular

Area(sq. metre)

Total Rate charged (AUD/sq. feet)

Trade fare charges

Commission

Rate (%)

Commission Received

New exhibitor

 

 

 

 

 

Area greater than or equal to 20 sq. feet

1790

80

143200

25%

35800

area less than 20 sq. feet

527

80

42160

30%

12648

Returning Exhibitor

 

 

 

 

 

Area greater than or equal to 20 sq. feet

2078

80

166240

20%

33248

area less than 20 sq. feet

453

80

36240

25%

9060

Total

4848

 

387840

 

90756

Sales representative wages

Formula= Hours worked * Hourly rate

Calculation-

Sales representative wages

Time spent by sales representative (Minutes)

81200

In hours

1353.33

Hourly rate (AUD)

60

Wages received

81200

Sale representative commission-

Formula- Commission received * commission rate for sales representatives 

Calculation-

Commission paid to Sales representatives

Particular

Commission received by BEMC  

Commission rate paid to SR

Total commission paid to SR

New exhibitor

 

 

 

Area greater than or equal to 20 sq. feet

35800

30%

10740

Area less than 20 sq. feet

12648

37%

4679.76

Returning Exhibitor

 

 

 

Area greater than or equal to 20 sq. feet

33248

27%

8976.96

Area less than 20 sq. feet

9060

30%

2718

Total

90756

 

27114.72

Total income

To calculate total income earned by BMEC, all the income earned by it during these six months will be added.

Calculation-

Total income

Revenue from sale of ticket

43480.5

Fees received from VAS

233300.00

Commission received

90756

Total

367536.5

Total expense

Calculation-

Total expense

Expense on VAS

179550

Wages paid

81200

Commission paid to SR

27114.72

Total

287864.72

Total profit

Formula- total income- total expense

Calculation- 367536.5- 287864.72= $79671.78

1.2Total profit, sub-totalled by each (a) Trade Fair and (b) Sales Representative

1. Trade fair

Profits from each of the trade fair have been evaluated with the help of following table and graph.

Table

Trade fair

Sum of Profit (AUD)

Books

5444.64

Builders

3829.38

Clothing

12329.04

Computing

9510.64

Food

15143.1

Furniture

4343.52

Government

3907.72

HRM

4347.46

Manufacturing

1469.98

Sports

2671.8

Vehicles

1979.84

Wine

14694.66

Grand Total

79671.78

Graph               

  organization in trade fair of clothing computing, food, and wine

We can say that maximum profits are earned by the organization in trade fair of clothing computing, food, and wine.

Sales representatives

Table

Name

Profit (AUD)

Alex

10409.96

Chris

32007.82

Jane

11226.54

Luke

26027.46

Grand Total

79671.78

Graph

Chris and Luke in the given period of six months

With the help of above pivot table and graph, we can say the maximum profit are earned by Chris and Luke in the given period of six months.

1.3 Total hours worked, sub-totalled by each (a) Trade Fair, and (b) Sales Representative

1. Trade Fair

Table

Name

Time (hours)

Books

54.17

Builders

46.83

Clothing

205.67

Computing

175.83

Food

259

Furniture

88

Government

30.67

HRM

105.17

Manufacturing

34.67

Sports

54.5

Vehicles

32.17

Wine

266.67

Grand Total

1353.33

Graph

consumed in wine, food, computing and clothing

From the above graph and pivot table, we can say that during the six months most of the time is consumed in wine, food, computing and clothing.  

Sales representatives

Table

Name

Time (Hours)

Alex

221.17

Chris

522.5

Jane

216.5

Luke

393.17

Grand Total

1353.33

Graph

2.	Sales representatives

From the evaluation of the above pivot table and graph, we can conclude that Chris and Luke have spent maximum time during the six month period. 

Task 2- Observations

2.1 BEMC’s five best and five worst customers by total profit

1.  Best five customers

Name

Profit (AUD)

Onlyscotchco

1897.66

Magazone

1816.68

Bottomsup

1720.06

Readit

1591.48

Kerplonk

1453.02

Grand Total

8478.9

Best five customers

2. Worst Five customers

Name

Profit (AUD)

Jobsmgtco

-304.16

Plonk2U

-205.9

Hick!

-73.2

Buttoned-down

-65.56

Hoolden

-57.7

Grand Total

-706.52

Worst Five customers

2.2 BEMC’s best and worst Trade Fairs by total profit

Table and graph showing overall profits from individual trade fair

Name

Profit (AUD)

Manufacturing

1469.98

Vehicles

1979.84

Sports

2671.8

Builders

3829.38

Government

3907.72

Furniture

4343.52

HRM

4347.46

Books

5444.64

Computing

9510.64

Clothing

12329

Wine

14694.7

Food

15143.1

Grand Total

79671.8

graph showing overall profits from individual trade fair

Best and worst trade fare- From the analysis of the above table and graph we can say that the worst trade fare for BMEC is manufacturing and best is food.

2.3 BEMC’s best and worst sales representatives by total income

Table and graph showing total income earned by individual sales representative

Name

Total income

Alex

16743.04

Jane

18072.96

Luke

32169.04

Chris

41329.68

Grand Total

108314.72

 graph showing total income earned by individual sales representative

Worst sales representative- Alex

Best sales representative- Chris   

Task 3- Recommendations

3.1 Focus on any particular (a) customer and (b) Trade Fair

1. Customer

Each and every customer is very important for growth and development of an organization. But in every business, there are various customers which contribute more as compared to the other customers. Hence an organization to give special preference to these customers otherwise it can result in loss of profit for the company. In the above task we have determined the name of top 5 customers of BMEC; therefore the company should focus on these customers. These customers are Onlyscotchco, Magazone, Bottomsup, Readit and Kerplonk. In process of giving special consideration to these 5 customers company should discard other customers. For growth of the organization, company should try to attract new customers.

2. Trade Fair            

In the above task, we have ranked each of the trade fairs in accordance with the total profit earned by the organization. From this ranking, we can conclude that the three worst trade fair in terms of profits are Sports, Vehicles, and Manufacturing. BMEC should give special importance to these three trade fairs. The company should evaluate what are the factors which are affecting their success. The company should also focus on food and wine as they are high profit generating trade fairs and the main source of income for BMEC.

3.2 Data to be collected for improvement in decision making of BEMC

Type of data collected by an organization plays a very important role in the decision-making process of the organization. BMEC should also use relevant and accurate data which are being used by the organization in the decision-making process. These data should include-

1. Cost benefits analysis of financial performance for previous 3 years.
2. Financial statement of previous three years to evaluate the financial performance and standing of the company.
3. Ratio analysis of least performing Trade fair to decide whether the organization should continue with these projects or not.
4. Performance evaluation reports of all the sales representatives employed by the organization.

Conclusion

From the evaluation of above task report, we can conclude that the financial performance of BMEC is good but there is a lot of scope for improvement. It could be observed with the help of tables and graphs that there are various factors which are affecting its success. These factors include loss making trade fairs and inefficient perform of some sales representatives as compared to others. The organization should implement the recommendations provided in the above report for better financial performance.