Information System

TASK 5: 2-D Column Chart

　　　　Based on the question it request to create a 2-D clustered column chart of the divisions and their quarterly earnings. Based on the Total Sales worksheet, the first step is highlight the cells from A3 to G9 which are the total sales by agents include Avery, Collins, Kinsley, McDonnough, Ross and Shannon from January to June in year 2016. After that under the INSERT tab, there have a chart group, in that group select insert column chart then click on 2-D column chart, it will automatically appear a column chart with all the information that provided on the Total Sales worksheet. Step 3 is under the CHART TOOLS - DESIGN, click on the Switch Row or Column to reverse the rows and columns. After that, click on the Chart Title and type in the related title which is January-June 2016 Sales by Agent and the bold the title. Next, double click on the legend, on the right side panel change legend position to right. Then, double click on the Y axis scale values, on the right side panel changed the maximum scale value to 8000 and major units to 1000. Lastly, click once on the completed chart, under the CHART TOOLS-Design, click on Move Chart. Then, select New Sheet and rename the new sheet as Sales Chart. From the sales chart, in January, March and April, Ross has gains the highest sales which is RM 4038, RM 7015, and RM 6832. In February and May, Kinsley has gains the highest sales than the other agents but in June, there have both agents, Avery and Ross gain the same amount of sales which is RM 5497 Conversely, from January to March, Shannon has gain the lowest sales which is RM 1172, RM 866, and RM 2109 and from April to June, McDonnough has the lowest sales which is RM 1975, RM 2936, and RM 3498. Finally, we will suggest some ways to those agents with the lowest sales includes create a package and try to offer a better price by selling hotel, flight, and activity together, integrate online booking software such as customers can booking accommodation online, seasonable held a sales promotion like the holidays season, festival time and so on. Figure 1 shows the completed 2-D column chart.

　　 Figure 1 Print Screen for Task 5

TASK 10: Scenario Summary

　　　　There have a lot of steps in creating a scenario. In Promotion worksheet, click on the DATA tab, then click What-If Analysis in the Data Tools group and then select Scenario Manager. Click Add, and then click in the scenario name box and type in Best Scenario. Delete the existing contents in the Changing cells box and select the range B2:B4 which B2 is base cost ; B3 is taxes and fees ; B4 is discount. Edit the comment box to display your name and