# 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

 Trade fair Profit Books 403644 Builders 159510.2 Clothing 502267.4 Computing 628041 Food 993194.4

 HRM 679749 Manufacturing 20729.6 Sports 157841 Vehicles 122688 Wine 1.13617e+06

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.33 3258.67 Total profit 5.50991e+06 5.50978e+06
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.