ITECH1005-5005 Business Information Systems Assignment Help

ITECH1005-5005 Business Information Systems Assignment Help

ITECH1005-5005 Business Information Systems Assignment Help

Task 1

Question 1

a.

Fee for Exhibitor travel

Fee for Exhibitor accommodation

Fee for Exhibitor hospitality

Fee for Exhibitor stand

Fee for marketing material

68000

52800

27000

51000

34500

b.

Exhibitor stand Cost

Exhibitor travel Cost

Exhibitor accommodation Cost

Exhibitor marketing material Cost

Exhibitor hospitality Cost

39100

57800

42900

17250

22500

c. AUD 43480.5
d. AUD 91612.0
e. AUD 81200.0
f. AUD 27385.44
g. AUD 368392.5
h. AUD 288135.44
i. AUD 80257.06

Question 2

Row Labels

Sum of Profit (AUD)

Books

5449.2

Builders

3836.34

Clothing

12934.56

Computing

9539.44

Food

14745.18

Furniture

4361.76

Government

4019.56

HRM

4121.62

Manufacturing

1482.7

Sports

2985.48

Vehicles

2303.84

Wine

13621.38

Grand Total

79401.06

ITECH1005-5005 Business Information Systems Assignment Help

Row Labels

Sum of Profit (AUD)

Alex

9816.44

Chris

32316.94

Jane

11679.18

Luke

25588.5

Grand Total

79401.06

ITECH1005-5005 Business Information Systems Assignment Help

Question 3

Trade Fair

Sum of Time spent by Sales Representative (hours)

Wine

266.67

Food

259

Clothing

205.67

Computing

175.83

HRM

105.17

Furniture

88

Sports

54.5

Books

54.17

Builders

46.83

Manufacturing

34.67

Vehicles

32.17

Government

30.67

Grand Total

1353.33

ITECH1005-5005 Business Information Systems Assignment Help

Sales Rep

Hours

Chris

522.500

Luke

393.170

Alex

221.170

Jane

216.500

Grand Total

1353.330

ITECH1005-5005 Business Information Systems Assignment Help

Question 4

Row Labels

Alex

Chris

Jane

Luke

Grand Total

Books

2073

12005.5

3486.5

8469

26034

Builders

  

6858

6790.5

13648.5

Clothing

8846

27129

740

15341

52056

Computing

3109

13138

7020

15115

38382

Food

9866

35456.5

6219

13798

65339.5

Furniture

2266.5

6619

7019

9889.5

25794

Government

2660

4956.5

4147

6537.5

18301

HRM

8908.5

6228

5157

4157

24450.5

Manufacturing

2412

1363.5

1733.5

1838.5

7347.5

Sports

1454.5

8480

607.5

3787

14329

Vehicles

  

4056.5

3965.5

8022

Wine

13357.5

37161.5

2305.5

21008

73832.5

Grand Total

54953

152537.5

49349.5

110696.5

367536.5

ITECH1005-5005 Business Information Systems Assignment Help

Row Labels

Sum of Commission received from space rent (AUD)

Sum of Fee for Exhibitor accommodation

Sum of Ticket sales Revenue (AUD)

Sum of Fee for Exhibitor stand

Sum of Fee for Exhibitor travel

Books

3448

4800

1386

6000

5000

Builders

3996

0

1252.5

3000

0

Clothing

16188

9600

6768

3000

12000

Computing

13888

1600

6594

10500

4000

Food

15820

12000

8419.5

0

16000

Furniture

4084

4800

2610

3000

4000

Government

3124

3200

777

6000

4000

HRM

6132

3200

3118.5

0

4000

Manufacturing

3196

0

751.5

0

1000

Sports

3760

0

1569

6000

3000

Vehicles

3528

0

894

0

0

Wine

13592

13600

9340.5

13500

15000

Grand Total

90756

52800

43480.5

51000

68000

Question 5

ITECH1005-5005 Business Information Systems Assignment Help

Row Labels

Books

Builders

Clothing

Computing

Food

Furniture

Government

HRM

Manufacturing

Sports

Vehicles

Wine

Grand Total

Alex

1676

 

7166.96

2750.96

7821.36

2069.92

2178.72

7149.44

1968

1180

 

11175.2

45136.56

Chris

9528.08

 

20599.36

9909.44

27146.08

5598

4038

5696.72

1115.52

6612.8

 

29976.56

120220.56

Jane

2799.84

4726.08

423.92

5221.92

4838.16

5570.4

3251.2

4450

1209.28

364

3009.44

1806.08

37670.32

Luke

6580.88

5086.08

10931.2

10960.24

10788.72

8193.92

4813.52

3032.72

1572

3186.72

2708.72

17253.28

85108

Grand Total

20584.8

9812.16

39121.44

28842.56

50594.32

21432.24

14281.44

20328.88

5864.8

11343.52

5718.16

60211.12

288135.44

Row Labels

Sum of Cost of Exhibitor stand

Sum of Cost ofExhibitor travel

Sum of Cost ofExhibitor accommodation

Sum of Cost ofExhibitor marketing material

Sum of Cost ofExhibitor hospitality

Alex

4600

10200

6500

2500

4000

Chris

18400

26350

21450

7500

5500

Jane

3450

5100

3250

1750

6500

Luke

12650

16150

11700

5500

6500

Grand Total

39100

57800

42900

17250

22500

ITECH1005-5005 Business Information Systems Assignment Help

Task 2

Question 1

 

Sum of Profit (AUD)

magazone

1810.92

onlyscotchco

1793.5

bottomsup

1714.3

readit

1588.12

jeribuilt

1439.42

ITECH1005-5005 Business Information Systems Assignment Help

Hick!

-30

buttoneddownco

-31

farmfoods

-81.14

plonk2u

-211.66

jobsmgtco

-284

Question 2

Row Labels

Sum of Profit (AUD)

Books

5449.2

Builders

3836.34

Clothing

12934.56

Computing

9539.44

Food (Best)

14745.18

Furniture

4361.76

Government

4019.56

HRM

4121.62

Manufacturing (Worst)

1482.7

Sports

2985.48

Vehicles

2303.84

Wine

13621.38

Grand Total

79401.06

ITECH1005-5005 Business Information Systems Assignment Help

Question 3

ITECH1005-5005 Business Information Systems Assignment Help

Row Labels

Sum of Total income (AUD)

Alex

54953

Chris

152537.5

Jane

49349.5

Luke

110696.5

Grand Total

367536.5

Question 4

Row Labels

Sum of Profit (AUD)

Chris

32316.94

PastaCo

1099.26

MyGrub

1038.3

fatduck

979.66

bottomsup

974.5

shirts

847.7

scarf

781.18

onlyscotchco

776.5

magazone

760.92

comsec

756.84

readit

750

myjeans

733.94

kerplonk

690.5

boozeup

684.2

wholeysheet

682.5

redshoes

680

wizzbang

668.3

sushi

647

asiandelico

639.64

books4all

636

housemade

632.5

redsgalore

597

asiacousine

580.5

findPeople

576.78

AllElec

569.78

toys

565.14

sloshedshop

560.9

jeansPL

552.5

DPR

538.5

Yummies

523.5

davidswine

506.78

dressups

505.5

meyersfood

505.5

djclothes

486.44

allfit

485.82

bluejeans

467.88

techexperts

467.5

angryfishwines

464.7

bluetailwines

442.5

sportsbet

433.5

redheaven

432.84

bestWinesCo

405.5

slowfoodco

391.46

Centrelunk

380

tastyrice

367.5

CoolSports

351.5

pillowfluff

338.5

amozoon

330.5

windoze

296.5

size42

287

allbooz

279.08

red&white

276.46

tictac

267.64

clotheshorseco

262.22

factoryBilt

247.98

holyhats

235.18

mydeli

227

espnnet

205.46

atm

202

vineyard

187.5

SportsAUS

178.6

delacombewines

165

humanRec

154

julie

145.78

hunterreds

140.5

fasteddies

137.54

games4all

133

grogshop

124.3

dimsumAUS

123.5

cloaks4all

89.5

expertiseco

84.5

indiyum

62.5

berrydrinkco

33.18

Hick!

-30

buttoneddownco

-31

farmfoods

-50.44

plonk2u

-121.5

jobsmgtco

-284

Grand Total

32316.94

ITECH1005-5005 Business Information Systems Assignment Help

Question 5

ITECH1005-5005 Business Information Systems Assignment Help

Sales Rep

Sum of Profit (AUD)

Chris

19280.94

Luke

17260.5

Jane

5671.18

Alex

5564.44

Grand Total

47777.06

Task 3

Question 1

The primary focus of the organization should be on Onlyscotchco and wine considering the fact that the highest revenue is generated by these two for the organization.

Question 2

A vital piece of information which could have been included in the data is the geo-location of the sales affected as the same would enable the organization to understand the sales pattern and frame strategies accordingly.

Question 3

In order to ensure that the data of the organization is not tampered with and that the same has been recorded efficiently the organization needs to install a point of sale software which should be integrated with an ERP system such as SAP or MYOB.

Question 4

Currently the organization has a higher fixed cost in terms of fixed pay awarded to the employees of the organization. The organization should consider revising the pay structure and allocating a major portion of the pay as Sales incentives and reducing the fixed pay. This would ensure that the organization has healthy results and would in turn improve the profitability and the efficiency of the concern.