Basic Business Statistics Using Excel Tasks 2022
Added on 2022-09-18
6 Pages432 Words26 Views
Running head: BASIC BUSINESS STATISTICS USING EXCEL
Basic Business Statistics Using Excel
Name of the Student:
Name of the University:
Author Note:
Basic Business Statistics Using Excel
Name of the Student:
Name of the University:
Author Note:
BASIC BUSINESS STATISTICS USING EXCEL
1
Table of Contents
Task 2.........................................................................................................................................2
Explanation of the sales calculation.......................................................................................2
Excel formula view................................................................................................................3
Explanation of sales using bar chart.......................................................................................3
Reference....................................................................................................................................5
1
Table of Contents
Task 2.........................................................................................................................................2
Explanation of the sales calculation.......................................................................................2
Excel formula view................................................................................................................3
Explanation of sales using bar chart.......................................................................................3
Reference....................................................................................................................................5
BASIC BUSINESS STATISTICS USING EXCEL
2
Task 2
Explanation of the sales calculation
There are five segments of Suma Ltd. which are divided in Mens, Womens, Kids,
Homeware and canteen. In the below table total monthly sales from the each department is
calculated using the formulas in Excel. The table shows that the total monthly sales for each
month from all the departments. The sales amounts are described below:
Total sales for the month October is £14,920.
Total sales for the month November is £16,507.
Total sales for the month December is £41,140.
Total sales for the month January is £8,507.
Total sales for the month February is £12,300.
Total sales for the month March is £14,732.
The total sales for each departments from October to March is described below:
Total sales from Mens Department is £24,258.
Total sales from Womens Department is £24,752.
Total sales from Kids Department is £24,617.
Total sales from Homeware Department is £18,359.
Total sales from Canteen Department is £16,120.
Table 1: Departmental Sales for Suma Ltd. from October to March
2
Task 2
Explanation of the sales calculation
There are five segments of Suma Ltd. which are divided in Mens, Womens, Kids,
Homeware and canteen. In the below table total monthly sales from the each department is
calculated using the formulas in Excel. The table shows that the total monthly sales for each
month from all the departments. The sales amounts are described below:
Total sales for the month October is £14,920.
Total sales for the month November is £16,507.
Total sales for the month December is £41,140.
Total sales for the month January is £8,507.
Total sales for the month February is £12,300.
Total sales for the month March is £14,732.
The total sales for each departments from October to March is described below:
Total sales from Mens Department is £24,258.
Total sales from Womens Department is £24,752.
Total sales from Kids Department is £24,617.
Total sales from Homeware Department is £18,359.
Total sales from Canteen Department is £16,120.
Table 1: Departmental Sales for Suma Ltd. from October to March
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Assignment on Business Datalg...
|10
|2060
|55
The Use of Information Technology in Businesslg...
|9
|1873
|34