2. Daniel James and three of his friends came up with the idea of starting a travel agency for college students in Nigeria. They invested sixty thousand naira each and started their dream company, SUMMER BREAK
TRAVELS INC.
As sales continued to grow, the management of Summer Break Travels Inc. realised they need a better tracking system for First Quarter
Sales.
Prepare a First Quarter Sales Worksheet that shows the sales for the first quarter using the details in the table below
Markerting outlets[#]
| location[vacation place] |
mail |
campus |
telephone |
internet |
| bar beach |
5,297.23 |
3,871.35 |
4,720.45 |
2,998.65 |
| trans amusement park ibadan |
2,823.23 |
4,840.53 |
2,703.56 |
4,911.16 |
| agodi gardens |
6,256.25 |
7,256.12 |
2,436.86 |
7,709.32 |
| obudu park calabar |
2,856.15 |
437.20 |
4,997.60 |
1,201.45 |
| total |
|
|
|
|
[a] (a) Using function or fomula, compute the total:
[i] sales at each marketing outlet; (ii)
[ii] amount of money made for each vacation place. (Note: create another column "total")
(b) Format the table using the instruction below: ) the title "Summer Break Travels, Inc.
First Quarter Sales" should be Bold and in Upper Case;
(ii) fill the table with white background 1 darker-25"
[c] Create two charts for the first quarter sales: )
[i] a pie chart stating the most effective sales method;
[ii] a bar chart stating the most popular vacation place.
[d] Type in the formula used in calculating total for each location below your table
(enclosed in"")
[e] Save, print out your work and submit to the supervisor.
To prepare the First Quarter Sales Worksheet for Summer Break Travels Inc., we need to perform the following steps:
a) Calculate the total sales at each marketing outlet and the amount of money made for each vacation place: To calculate the total sales at each marketing outlet, we need to add up the sales from all the four methods (mail, campus, telephone, and internet) for each vacation place. Similarly, to calculate the amount of money made for each vacation place, we need to add up the sales from all the four methods for each location. We can use the SUM function in Excel to calculate these totals. Here's how the table will look after calculating the totals:
b) Format the table as follows: - Bold and uppercase the title: "SUMMER BREAK TRAVELS, INC. FIRST QUARTER SALES" - Fill the table with a white background of 1 darker-25"
c) Create two charts:
- Pie chart: To create a pie chart, we need to select the sales data for each marketing outlet (i.e., mail, campus, telephone, and internet) and insert a pie chart from the "Insert" tab. We can then format the chart by adding data labels and a legend to show which method is most effective.
- Bar chart: To create a bar chart, we need to select the sales data for each vacation place and insert a bar chart from the "Insert" tab. We can then format the chart by adding axis labels and a title to show which vacation place is the most popular.
d) Type in the formula used in calculating total for each location below your table (enclosed in ""): For example, the formula used to calculate the total sales for Bar Beach is "=SUM(B2:E2)".
e) Save, print out your work, and submit to the supervisor. In summary, the First Quarter Sales Worksheet for Summer Break Travels Inc. involves calculating the total sales at each marketing outlet and the amount of money made for each vacation place using Excel's SUM function, formatting the table with a bold and uppercase title and a white background, creating a pie chart and a bar chart to visualize the sales data, and typing in the formulas used to calculate the totals. The final output should be saved, printed out, and submitted to the supervisor.
To prepare the First Quarter Sales Worksheet for Summer Break Travels Inc., we need to perform the following steps:
a) Calculate the total sales at each marketing outlet and the amount of money made for each vacation place: To calculate the total sales at each marketing outlet, we need to add up the sales from all the four methods (mail, campus, telephone, and internet) for each vacation place. Similarly, to calculate the amount of money made for each vacation place, we need to add up the sales from all the four methods for each location. We can use the SUM function in Excel to calculate these totals. Here's how the table will look after calculating the totals:
b) Format the table as follows: - Bold and uppercase the title: "SUMMER BREAK TRAVELS, INC. FIRST QUARTER SALES" - Fill the table with a white background of 1 darker-25"
c) Create two charts:
- Pie chart: To create a pie chart, we need to select the sales data for each marketing outlet (i.e., mail, campus, telephone, and internet) and insert a pie chart from the "Insert" tab. We can then format the chart by adding data labels and a legend to show which method is most effective.
- Bar chart: To create a bar chart, we need to select the sales data for each vacation place and insert a bar chart from the "Insert" tab. We can then format the chart by adding axis labels and a title to show which vacation place is the most popular.
d) Type in the formula used in calculating total for each location below your table (enclosed in ""): For example, the formula used to calculate the total sales for Bar Beach is "=SUM(B2:E2)".
e) Save, print out your work, and submit to the supervisor. In summary, the First Quarter Sales Worksheet for Summer Break Travels Inc. involves calculating the total sales at each marketing outlet and the amount of money made for each vacation place using Excel's SUM function, formatting the table with a bold and uppercase title and a white background, creating a pie chart and a bar chart to visualize the sales data, and typing in the formulas used to calculate the totals. The final output should be saved, printed out, and submitted to the supervisor.