bussiness info. system

profileboha 11
itech1005_5005_assignment_data_2015_v2.xlsx
Home>Information Systems homework help>bussiness info. system

Sales

Date (of customer order), Trade Fair Customer (i.e. exhibiting company) space sold (sq.m.) Sales Representative time spent by Sales Representative to complete sale (minute) returning Exhibitor? Exhibitor stand organised? Exhibitor travel organised? Exhibitor accommodation organised? Exhibitor marketing material organised? Exhibitor hospitality organised? Visitor tickets sold
3/6/15 Computing AllElec 28 Kylie 16 y y n n n n 141
2/9/15 Computing ByteMe 37 Sheila 34 n n n n n n 21
3/26/15 Wine Hick! 41 Kylie 39 y n n n n n 218
3/3/15 Food PastaCo 35 Kylie 29 y n y y y n 134
1/23/15 Sports mySport 38 Shane 29 n y y n n n 21
2/8/15 Sports games4all 13 Kylie 18 n n y n n n 153
3/7/15 Sports SportsAUS 30 Kylie 29 y n n n n n 164
3/8/15 Food Yummies 31 Kylie 28 y n y y y n 46
3/10/15 Sports CoolSports 32 Kylie 14 n y y n n n 63
3/24/15 Food MyGrub 9 Kylie 12 y n y y y n 53
3/13/15 Vehicles Forrd 21 Sheila 24 y n n n n y 84
2/14/15 Vehicles Hoolden 15 Sheila 44 y n n n n y 136
3/4/15 Government DSEVic 33 Sheila 9 y y y y n y 75
1/29/15 Vehicles Yoyota 32 Sheila 24 y n n n n y 263
3/2/15 Clothing holyhats 11 Kylie 15 y n n n n n 252
1/5/15 Clothing clotheshorseco 36 Kylie 42 y n n n n n 284
2/14/15 Clothing buttoneddownco 43 Kylie 21 y n n n n n 143
2/24/15 Clothing dressups 7 Kylie 17 y n y y y n 163
2/16/15 Clothing DenimToo 31 Shane 13 y n y y y n 230
3/23/15 Clothing BabiesRUs 30 Shane 8 n n y y y n 257
1/19/15 Clothing scarves4all 24 Shane 23 n n y y y n 221
1/20/15 Clothing whiteshoestoo 17 Shane 26 y n n n n n 255
3/9/15 Clothing JocksSocks 25 Shane 15 n n n n n n 111
2/27/15 Clothing beltup 7 Shane 27 n n y y y n 145
2/26/15 Clothing ties4all 26 Shane 20 n y y y n n 197
3/28/15 Computing myCompCo 31 Shane 40 y y n n n n 263
1/20/15 Computing Comp4You 17 Shane 26 y y n n n n 16
3/15/15 Computing TechIsUs 7 Shane 17 y y n n n n 33
2/8/15 Computing DataBase 33 Sheila 9 y n n n n n 276
2/3/15 Computing Dull 5 Sheila 10 y n n n n n 184
1/15/15 HRM jobsmgtco 6 Kylie 29 y n n n n y 137
1/8/15 HRM yourjobco 18 Jarrah 17 y n n n n y 18
1/23/15 HRM HRMrus 40 Jarrah 43 y n n n n y 83
2/1/15 HRM menpower 25 Shane 22 y n n n n y 210
1/10/15 HRM finduwork 14 Shane 28 n n y y y y 37
1/20/15 Government DPR 21 Kylie 36 y y y y n y 290
1/27/15 Government Centrelunk 15 Shane 21 y y y y n y 214
1/6/15 Builders jeribuilt 25 Sheila 22 y y n n y y 14
1/12/15 Builders morganbild 41 Sheila 25 y n n n y y 246
1/15/15 Builders erectus 41 Sheila 43 y n n n n y 182
3/3/15 Builders homeBilt 29 Sheila 21 n n n n y y 298
1/9/15 Manufacturing Jerrys 11 Sheila 17 y n n n n y 262
2/9/15 Manufacturing made4u 5 Sheila 36 y n n n n y 280
2/17/15 Manufacturing factoryBilt 21 Kylie 14 y n n n n y 259
2/6/15 Wine allbooz 17 Shane 34 y y n n n n 23
3/3/15 Wine plonk2u 20 Kylie 9 y n n n n n 223
1/11/15 Books books4all 34 Kylie 26 n n y y y y 254
1/22/15 Books amozoon 42 Kylie 28 n y y y y y 70
3/11/15 Books readit 11 Shane 22 n y y y y y 84
2/8/15 Books magazone 7 Shane 8 y y y y y y 283
2/2/15 Food fasteddies 17 Kylie 34 y n n n y n 300
2/27/15 Food slowfoodco 41 Kylie 28 y n n n y n 197
2/28/15 Food bestWinesCo 34 Kylie 20 y n y y y n 217
3/30/15 Food indiyum 8 Shane 20 y n n n y n 239
3/13/15 Food fastfoodco 13 Jarrah 10 y n n n y n 44
2/25/15 Food dipit 21 Sheila 32 n n n n y n 111
3/10/15 Furniture wholeysheet 43 Shane 8 y n y y y y 33
3/27/15 Furniture chairsRus 10 Sheila 11 y n n y n y 76
1/4/15 Furniture beds2 20 Sheila 31 y y n n y y 145
2/23/15 Furniture homezAUS 28 Sheila 37 y n n n n y 169
1/21/15 Sports crickitOZ 31 Sheila 28 n n y n n n 71
1/3/15 Wine bottomsup 24 Kylie 34 n y y y y n 275
3/5/15 Wine redsgalore 41 Kylie 24 n y y y y n 202
2/9/15 Wine sloshedshop 21 Kylie 33 n n n n n n 258
1/9/15 Wine redheaven 16 Shane 41 n n y y y n 181
2/10/15 Furniture pillowfluff 30 Kylie 40 y n y y y y 70
2/9/15 Furniture chaiseYou 27 Sheila 29 y n n n n y 56
1/16/15 Food asiandelico 26 Kylie 8 y n y y y n 127
2/18/15 Food dimsumAUS 29 Kylie 39 n n n n y n 89
3/27/15 Wine bluetailwines 6 Kylie 43 n n y y y n 173
2/15/15 Wine berrydrinkco 16 Kylie 18 y n n n n n 149
3/30/15 Wine hunterreds 33 Shane 17 y n n n n n 99
2/21/15 Wine angryfishwines 40 Shane 36 n n y y y n 292
1/16/15 Wine onlyscotchco 42 Shane 39 y y y y y n 9
1/19/15 Food farmfoods 17 Kylie 30 y n n n y n 8
1/29/15 Food housemade 15 Shane 25 y n y y y n 77
2/19/15 Food meyersfood 27 Shane 41 y n n n y n 127
1/2/15 Wine davidswine 21 Shane 45 y n n n n n 40
3/29/15 Computing Comp4U 39 Sheila 19 y n n n n n 90
2/14/15 Computing noIdeas 24 Sheila 13 y n n n n n 186
2/14/15 Computing BobsBits 7 Sheila 31 n n n n n n 267
3/18/15 Wine boozeup 13 Kylie 36 y n y y y n 157
1/2/15 Wine red&white 28 Shane 8 y n y y y n 155
1/3/15 Food davidsfood 37 Shane 13 y n n n y n 66
2/20/15 Food bitez 27 Shane 19 n n n n y n 23
3/15/15 Wine grogshop 13 Kylie 18 y n n n n n 100
2/5/15 Wine delacombewines 20 Kylie 10 y n n n n n 267
2/10/15 Food ballaratfoods 32 Jarrah 40 y n y n y n 293
2/24/15 Clothing size42 21 Shane 40 y n n n n n 292
1/12/15 Food mydeli 36 Shane 15 y n n n y n 58
2/14/15 Clothing cloaks4all 22 Kylie 12 y n n n n n 99
1/24/15 Computing wizzbang 11 Kylie 32 y y y y y y 268
3/24/15 Wine kerplonk 15 Shane 18 y y n n y n 77
3/9/15 Computing Itco 13 Sheila 30 y n y n n n 292
2/24/15 Wine vinez 19 Sheila 12 n n n n n n 274
1/11/15 Computing windoze 24 Shane 11 n y y y n n 69
1/26/15 HRM jobsrus 19 Jarrah 15 n n y y y y 139
1/16/15 HRM expertiseco 19 Kylie 27 y n n n n y 273
3/16/15 Clothing jeansPL 33 Kylie 37 y n y n n n 66
2/22/15 Clothing redshoes 20 Shane 12 n n n n n n 213

Fairs

2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
Trade Fair space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG space available for LVPG to sell to exhibitors (sq.m.) Visitor tickets sold by LVPG Total Profit for LVPG
Clothing 200 124 2770 200 88 2580 150 87 2285 150 87 2285 150 87 2285 150 95 2325 150 136 2530 175 141 2705 200 201 3155 250 273 3815 300 322 4703 379
Furniture 100 27 2935 100 27 2935 75 27 2635 75 27 2635 75 12 2560 75 12 2560 75 57 2785 100 52 3060 100 53 3065 100 53 3065 75 137 3752 108
Books 75 202 13735 75 320 14325 75 331 12380 75 325 14350 75 297 14210 75 298 14215 75 318 14315 75 384 14645 75 387 14660 75 501 15230 75 525 15543 124
Sports 200 507 3965 250 124 2200 100 13 1195 10 119 1455 100 120 1730 100 121 1735 125 118 1795 125 200 2205 150 451 3535 175 397 3340 200 424 3948 100
Food 200 950 6950 200 1100 7700 225 1150 8250 225 1150 8250 225 1150 8250 250 1150 8550 250 950 7550 250 950 7550 250 850 7050 275 1300 9600 300 1376 9830 437
Wine 200 856 19160 200 1100 20380 225 887 19765 225 857 19615 225 856 19610 250 895 20255 250 856 20060 250 887 20215 250 897 20265 275 1300 22730 300 1369 23101 373
Manufacturing 150 75 325 75 12 -140 75 22 -12 100 45 95 100 80 250 100 81 255 100 191 805 125 242 1110 150 260 1250 150 75 325 150 150 432 62
Builders 75 201 1255 0 0 0 75 201 1255 0 0 0 75 201 1255 0 0 0 75 201 1255 0 0 0 75 201 1255 0 0 0 75 25 853 74
Vehicles 75 1175 5975 75 1350 6850 75 1395 7075 75 980 5000 75 999 5095 75 878 4490 75 999 5095 75 1375 6975 75 1387 7035 100 1512 7710 125 1554 8270 71
Government 150 502 8760 150 502 8750 150 502 8760 150 502 8760 150 502 8760 150 502 8760 150 502 8760 150 502 8760 150 502 8760 150 502 8760 150 597 9460 72
HRM 150 840 6714 100 845 5660 100 840 5642 100 850 5693 100 888 5882 100 800 5442 100 845 5667 150 840 6714 150 830 6664 200 770 7435 200 862 8198 208
Computing 200 1257 7595 200 1700 7751 200 1950 11060 200 1950 11060 200 2250 12560 200 2250 12560 200 2257 12595 200 2800 15310 200 2999 12222 200 3541 14551 200 3586 15382 368