Business Information System Assignment Help

Business Information System Assignment Help

Business Information System Assignment Help

Introduction

This business information system assignment help study will focus on the topic of business information system based on some calculations and data representation. Analysis is to be made for a trade fair and relevant information’s given in the case study. Information’s like trade fair ticket, price of value added services, commission to be received for space sold are to be made for the purpose of reporting and recommendation to the owner. Furthermore, total revenue and total profit are also to be calculated in this regard of business information system reporting.

Calculations

I. Calculation table:

Fee for organising Exhibitor stand

Fee for organising Exhibitor travel

Fee for organising Exhibitor accommodation

Fee for organizing Exhibitor marketing material

Fee for organising Exhibitor hospitality

Total revenue from ticket sales (AUD)

Total price of space sold (AUD)

Commission received from space sold (AUD)

Time spent by Sales Representative to complete sale (hours)

Sales Rep wages (AUD)

Sales Rep. commission (AUD)

Total income (AUD)

Total expenses (AUD)

Profit (AUD)

96600

48300

45080

80500

61180

322

12880

 

0.65

32.5

 

344894.5

12912.5

331982

105000

 

 

87500

66500

350

14000

 

1.2

60

 

273410

14060

259350

112200

 

52360

93500

 

374

14960

 

0.4833333333

24.16666667

 

273418.1667

14984.16667

258434

118800

59400

55440

 

 

396

15840

79.2

0.3833333333

19.16666667

99

250073.3667

15958.16667

234115.2

 

61200

57120

102000

 

408

16320

 

0.4

20

 

237068

16340

220728

 

60600

56560

101000

 

404

16160

 

0.4666666667

23.33333333

 

234747.3333

16183.33333

218564

 

60300

56280

 

76380

402

16080

 

0.3333333333

16.66666667

 

209458.6667

16096.66667

193362

 

52200

48720

87000

 

348

13920

 

0.7166666667

35.83333333

 

202223.8333

13955.83333

188268

 

49500

46200

82500

 

330

13200

66

0.3333333333

16.66666667

82.5

191895.1667

13299.16667

178596

 

49500

46200

82500

 

330

13200

 

0.8166666667

40.83333333

 

191770.8333

13240.83333

178530

112800

56400

 

 

 

376

15040

75.2

0.4

20

94

184805.2

15154

169651.2

 

33600

31360

56000

42560

224

8960

 

0.7833333333

39.16666667

 

172743.1667

8999.166667

163744

 

44700

41720

74500

 

298

11920

 

0.7166666667

35.83333333

FALSE

173173.8333

11955.83333

161218

43200

21600

20160

36000

27360

144

5760

 

0.5166666667

25.83333333

 

154249.8333

5785.833333

148464

 

39900

37240

66500

 

266

10640

53.2

0.4333333333

21.66666667

66.5

154687.3667

10728.16667

143959.2

58800

29400

27440

 

 

196

7840

39.2

0.75

37.5

49

123801.7

7926.5

115875.2

105000

 

 

 

 

350

14000

105

0.8666666667

43.33333333

87.5

119585.8333

14130.83333

105455

100200

 

 

 

 

334

13360

100.2

0.6

30

83.5

114107.7

13473.5

100634.2

 

 

 

99000

 

396

15840

79.2

0.5666666667

28.33333333

99

115442.5333

15967.33333

99475.2

 

25800

24080

43000

 

172

6880

51.6

0.6666666667

33.33333333

43

100059.9333

6956.333333

93103.6

 

33900

 

56500

 

226

9040

45.2

0.5333333333

26.66666667

56.5

99794.36667

9123.166667

90671.2

84600

 

 

 

 

282

11280

56.4

0.6333333333

31.66666667

70.5

96320.56667

11382.16667

84938.4

42000

21000

19600

 

 

140

5600

28

0.2166666667

10.83333333

35

88413.83333

5645.833333

82768

 

 

 

 

77140

406

16240

81.2

1.083333333

54.16666667

101.5

94022.86667

16395.66667

77627.2

76800

 

 

 

 

256

10240

 

0.3333333333

16.66666667

 

87312.66667

10256.66667

77056

50400

25200

 

 

 

168

6720

33.6

0.75

37.5

42

82601.1

6799.5

75801.6

 

 

 

 

71440

376

15040

 

0.6333333333

31.66666667

FALSE

86887.66667

15071.66667

71816

 

19800

18480

33000

 

132

5280

39.6

0.65

32.5

33

76797.1

5345.5

71451.6

 

 

 

62500

 

250

10000

50

0.7166666667

35.83333333

 

72835.83333

10035.83333

62800

 

 

 

 

59660

314

12560

 

1.033333333

51.66666667

 

72585.66667

12611.66667

59974

 

12300

11480

20500

15580

82

3280

 

0.65

32.5

 

63254.5

3312.5

59942

 

16500

15400

27500

 

110

4400

33

0.3333333333

16.66666667

27.5

63987.16667

4444.166667

59543

 

16500

15400

27500

 

110

4400

33

0.9

45

27.5

64015.5

4472.5

59543

 

 

 

 

57380

302

12080

60.4

0.35

17.5

75.5

69915.4

12173

57742.4

 

19800

 

33000

 

132

5280

39.6

0.6333333333

31.66666667

33

58316.26667

5344.666667

52971.6

 

10500

9800

17500

13300

70

2800

 

0.8166666667

40.83333333

 

54010.83333

2840.833333

51170

51000

 

 

 

 

170

6800

 

0.4833333333

24.16666667

FALSE

57994.16667

6824.166667

51170

 

 

 

 

50160

264

10560

79.2

0.7

35

66

61164.2

10661

50503.2

 

 

49560

 

 

354

14160

70.8

0.2

10

88.5

64243.3

14258.5

49984.8

47400

 

 

 

 

158

6320

 

0.8

40

 

53918

6360

47558

 

12900

12040

21500

 

86

3440

 

0.3

15

 

49981

3455

46526

 

 

 

25500

19380

102

4080

 

0.4666666667

23.33333333

 

49085.33333

4103.333333

44982

 

 

 

 

43700

230

9200

 

0.35

17.5

 

53147.5

9217.5

43930

 

9000

8400

15000

11400

60

2400

18

0.65

32.5

15

46325.5

2447.5

43878

 

11100

10360

18500

 

74

2960

 

0.7666666667

38.33333333

 

43032.33333

2998.333333

40034

 

 

39200

 

 

280

11200

 

0.4833333333

24.16666667

 

50704.16667

11224.16667

39480

 

37800

 

 

 

252

10080

 

0.7333333333

36.66666667

 

48168.66667

10116.66667

38052

 

 

 

 

36480

192

7680

38.4

0.4166666667

20.83333333

48

44459.23333

7748.833333

36710.4

 

 

 

33500

 

134

5360

26.8

0.8333333333

41.66666667

 

39062.46667

5401.666667

33660.8

 

 

30240

 

 

216

8640

43.2

1.666666667

83.33333333

54

39276.53333

8777.333333

30499.2

 

15000

14000

 

 

100

4000

30

0.35

17.5

25

33172.5

4042.5

29130

 

 

 

25500

 

102

4080

20.4

0.4666666667

23.33333333

25.5

29751.23333

4128.833333

25622.4

 

 

 

22000

 

88

3520

17.6

0.55

27.5

22

25675.1

3569.5

22105.6

 

 

 

20500

 

82

3280

24.6

0.5666666667

28.33333333

20.5

23935.43333

3328.833333

20606.6

 

9900

9240

 

 

66

2640

 

0.9

45

 

21891

2685

19206

 

5100

4760

8500

 

34

1360

 

0.5833333333

29.16666667

 

19783.16667

1389.166667

18394

 

 

 

18000

 

72

2880

14.4

0.75

37.5

18

21021.9

2935.5

18086.4

 

 

 

14000

 

56

2240

11.2

0.25

12.5

14

16333.7

2266.5

14067.2

13800

 

 

 

 

46

1840

 

0.55

27.5

 

15713.5

1867.5

13846

 

 

 

11500

 

46

1840

13.8

0.5166666667

25.83333333

11.5

13437.13333

1877.333333

11559.8

 

 

 

 

11020

58

2320

11.6

0.7666666667

38.33333333

14.5

13462.43333

2372.833333

11089.6

 

3000

2800

5000

 

20

800

4

0.7833333333

39.16666667

5

11668.16667

844.1666667

10824

 

 

 

 

9500

50

2000

10

0.3

15

12.5

11587.5

2027.5

9560

 

 

 

 

7600

40

1600

 

0.9

45

 

9285

1645

7640

 

 

 

 

4940

26

1040

5.2

0.5

25

6.5

6042.7

1071.5

4971.2

 

 

 

 

4560

24

960

4.8

0.5833333333

29.16666667

6

5583.966667

995.1666667

4588.8

 

 

 

 

3040

16

640

 

0.45

22.5

 

3718.5

662.5

3056

 

 

 

 

 

394

15760

78.8

1.066666667

53.33333333

98.5

16384.63333

15911.83333

472.8

 

 

 

 

 

392

15680

78.4

0.4166666667

20.83333333

98

16269.23333

15798.83333

470.4

 

 

 

 

 

386

15440

77.2

0.8

40

96.5

16039.7

15576.5

463.2

 

 

 

 

 

368

14720

73.6

0.5

25

92

15278.6

14837

441.6

 

 

 

 

 

336

13440

100.8

2

100

84

14060.8

13624

436.8

 

 

 

 

 

334

13360

100.2

0.2666666667

13.33333333

83.5

13891.03333

13456.83333

434.2

 

 

 

 

 

408

16320

 

0.95

47.5

 

16775.5

16367.5

408

 

 

 

 

 

338

13520

67.6

0.35

17.5

84.5

14027.6

13622

405.6

 

 

 

 

 

300

12000

90

0.5166666667

25.83333333

75

12490.83333

12100.83333

390

 

 

 

 

 

296

11840

88.8

0.6166666667

30.83333333

74

12329.63333

11944.83333

384.8

 

 

 

 

 

318

12720

63.6

0.9

45

79.5

13226.1

12844.5

381.6

 

 

 

 

 

364

14560

 

0.8666666667

43.33333333

FALSE

14967.33333

14603.33333

364

 

 

 

 

 

348

13920

 

0.4166666667

20.83333333

 

14288.83333

13940.83333

348

 

 

 

 

 

258

10320

77.4

0.4833333333

24.16666667

64.5

10744.06667

10408.66667

335.4

 

 

 

 

 

236

9440

70.8

0.7666666667

38.33333333

59

9844.133333

9537.333333

306.8

 

 

 

 

 

250

10000

50

0.6

30

62.5

10392.5

10092.5

300

 

 

 

 

 

250

10000

50

0.6333333333

31.66666667

62.5

10394.16667

10094.16667

300

 

 

 

 

 

290

11600

 

0.4333333333

21.66666667

 

11911.66667

11621.66667

290

 

 

 

 

 

220

8800

66

0.5

25

55

9166

8880

286

 

 

 

 

 

280

11200

 

0.3

15

 

11495

11215

280

 

 

 

 

 

256

10240

 

0.85

42.5

 

10538.5

10282.5

256

 

 

 

 

 

250

10000

 

0.5166666667

25.83333333

 

10275.83333

10025.83333

250

 

 

 

 

 

172

6880

51.6

0.75

37.5

43

7184.1

6960.5

223.6

 

 

 

 

 

202

8080

 

0.4166666667

20.83333333

 

8302.833333

8100.833333

202

 

 

 

 

 

152

6080

30.4

0.9

45

38

6345.4

6163

182.4

 

 

 

 

 

140

5600

28

0.55

27.5

35

5830.5

5662.5

168

 

 

 

 

 

120

4800

36

0.55

27.5

30

5013.5

4857.5

156

 

 

 

 

 

80

3200

 

0.4833333333

24.16666667

FALSE

3304.166667

3224.166667

80

 

 

 

 

 

78

3120

 

0.45

22.5

 

3220.5

3142.5

78

 

 

 

 

 

48

1920

14.4

0.65

32.5

12

2026.9

1964.5

62.4

 

 

 

 

 

46

1840

 

0.75

37.5

 

1923.5

1877.5

46

 

 

 

 

 

26

1040

5.2

0.5333333333

26.66666667

6.5

1104.366667

1073.166667

31.2

 

 

 

 

 

22

880

4.4

0.9166666667

45.83333333

5.5

957.7333333

931.3333333

26.4

Table 1:Calculation of profit and others.

II. Calculation Table

 

Jarrah

Kylie

Shane

Sheila

Grand Total

Books

 

211302

192342

 

403644

Builders

 

 

 

159510.2

159510.2

Clothing

 

238446.8

263820.6

 

502267.4

Computing

 

293996.2

162592

171452.8

628041

Food

124332

639330.2

229225.4

306.8

993194.4

Furniture

 

51170

59942

393263.2

504375.2

Government

 

3056

82768

115875.2

201699.2

HRM

369165.2

85267.2

225316.8

 

679749.2

Manufacturing

 

11089.6

 

9640

20729.6

Sports

 

52184

105455

202

157841

Vehicles

 

 

 

122687.6

122687.6

Wine

 

726075.2

409870.4

223.6

1136169.2

Grand Total

493497.2

2311917.2

1731332.2

973161.4

5509908

From the above calculation table, total profit is calculated between different departments.

III Total expenditure in terms of trade fair, sales representative and expenses type is $855410.8333.

Observations

I.Jobsrus, Bottoms up, Beds2, Only scotchco, Finduwork are the five best customer as per sales. Whereas, DataBase, Size42, Hick!, Whiteshoestoo and Plonk2u are the worst customer in terms of total sales.

Customer (i.e. exhibiting company)

Sales

finduwork

344894.5

onlyscotchco

273418.17

beds2

273410

bottomsup

250073.37

jobsrus

237068

Table 2: Best customers as per Total sales.

Customer

Total sales

DataBase

10394.17

Hick!

10744.07

plonk2u

11587.5

size42

10538.5

whiteshoestoo

11495

Table 3: Worst customers in terms of sales

II. Best trade fairs table

Trade fair

Profit

Books

403644

Builders

159510.2

Clothing

502267.4

Computing

628041

Food

993194.4

Table 4: Best trade fairs

HRM

679749.2

Manufacturing

20729.6

Sports

157841

Vehicles

122687.6

Wine

1136169.2

 Table 5: Worst trade fairs

III. Jarrah, Sheila, Kylie, and Shane are the best five representative in terms of profit.

Whereas, Shane is the lowest selling representative.

Sales representative

profit

Jarrah

331982

Sheila

259350

Kylie

258434

Shane

234115

Shane

22078

Table 6: Best sales representative


Figure 5: Best sales representative.

Jarrah

Kylie

Shane

Sheila

Sales representatives

493497.2

2311917.2

1731332.2

973161.4

Profits

Table  7: Worst sales representatives

IV. Hospitality to the exhibitors is the best service by the representatives.

Sales representative

profit

Jarrah

331982

Sheila

259350

Kylie

258434

Shane

234115

Shane

22078

Table 8: Sales representatives performance

V. If the wage rises by 40% , profit decreases to $5509782.667.

wages of sales representative

 

3133.333333

3258.666667

Total profit

 

5509908

5509782.667

Table 9: Effect of change in profit due to change in wages

Recommendation

  • LVPG is recommended that the focus should not be given to any customer or customers in future for the purpose of trade fair. In a public fair, the main objective of arranging committee is to promote the sales and advertise the new product in the market (Oberweis and Sinz,  2011, p.8). Therefore, focusing on the highest selling customers could affect the selling opportunities for LVPG in near future. LVPG may consider the group of highest purchasing customers special discount or the customers may be given concession in ticket charges in the next time or LVPG may declare some special offer or service for the customer group (Amit and Zott, 2012, p.41). This kind of offers and discounting may motivate the new small buyers to enhance their space in the fair. Like the same way, LVPG should not prefer any trade fair as it can demotivate other fair organizations. Trade fairs are arranged to promote businesses development and advertise the new products. If LVPG focuses on any particular trade fair, it could not possible to promote other trade fairs. 
  • As per the collected data is concerned, all the data are related to the financial information. These quantitative data is not considered as appropriate or relevant for the future decision making (Österle et al. 2011, p.10). Some qualitative data, like customers or exhibitors view regarding the fair, services required by the exhibitors, exhibitors willingness to attempt the fair for the next time, opinions of the exhibitors are also to be taken for granted for the data reporting. Financial quantitative data helps to measure the current result of the business or other operations, but the above mentioned data facilitates the organizers to take future decisions (Catteddu, 2010, p.17).
  • Record of financial and other quantitative data along with exhibitors opinions are very much crucial for the the decisionmaking for a fair (Friedman et al.2013, p.55). Trade fair depends on the visitors participation and customers, who rent the fair. LVPG is recommended to appoint employees for the data collection, who will be responsible for collecting all relevant data of trade fair. Furthermore, a statistician is also suggested to appoint for forecasting the future prospect of the trade fair, as it would facilitate the organizers to provide sufficient services to the exhibitors (Amit and Zott, 2012, p.41).
  • Currently the sales representatives are getting a salary of AUD 50 per hour worked and a commission, which depends on the space of the trade fair. This salary of AUD 50 could be increased to motivate the sales representatives. LVPG could pay a fixed salary to the sales representatives and hourly bonus could be added with the fixed salary. Fixed salary always reflects a positive impact on the employee efficiency (Yoo et al. 2010, 726). Bonus along with the fixed salary might encourage the employees to work for a longer time (Zott et al. 2011, p.1041). 

Conclusion

This study was about the calculation of profit of a trade fair. Calculation was made by the use of calculations in excel. Topic wise income and revenue have been calculates. Income items such as, ticket fees, revenue from value added services and expenses, such as sales representative wage are calculated and recommendation is also given for the future trade fair. 

References and bibliography:

  • Rainer, R.K., Cegielski, C.G., Splettstoesser-Hogeterp, I. and Sanchez-Rodriguez, C., (2013). Introduction to information systems: Supporting and transforming business. John Wiley & Sons.
  • Scheer, A.W., (2012). Architecture of integrated information systems: foundations of enterprise modelling. Springer Science & Business Media.
  • Galliers, R.D. and Leidner, D.E., (2014). Strategic information management: challenges and strategies in managing information systems. Routledge.
  • Etzion, O. and Niblett, P., (2010). Event processing in action. Manning Publications Co..
  • Reichert, M. and Weber, B., (2012). Enabling flexibility in process-aware information systems: challenges, methods, technologies. Springer Science & Business Media.