ITECH1005-5005 Business Information Systems Proof Reading Services

ITECH1005-5005 Business Information Systems Assignment Help

ITECH1005-5005 Business Information Systems Proof Reading Services

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

Get more information HI5019 Strategic Information System for Business Assignment

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.