Student Name: Sajjad Khan
Class: MBA C (Weekend) 2023 - 2025
Data analytics & Decision making assignment
Teacher Name: Dr. Atta Ullah Shah
Assignment Introduction:
Take any report describe/Explain
the tools used in the report.
I have taken the data from “Annual
reports 2023” of BURSHANE LPG
(PAKISTAN) LTD. I will be explaining
each of these graph individually.
1. Total Assets
The tool used for the visualization of the data is known as Line Graph or Line Chart is a data visualization
tool that display information as a series of data points connected by a straight line. I helps in the
visualization of trends from start to the end as we can see the trend of this graph is a downward trend.
Except for 2022 where to total assets has increased and there is a little increase in the assets for the year
2022. For the year 2018 & 2020 the company has the highest value of assets that are 1,750 Million, the
lowest value is for the year 2023 which is near to 1,560 Million.
2. Total Equity & Liabilities
This will have the same explanation as the accounting equation is,
Assets = Liabilities + Owner Equity. The only difference will be that instead of assets the description will
be for total equity & liabilities.
3. Net sales
The tool used for visualization of the data is known as bar graph each rectangle represent a class of
categorical data in this cat each rectangle represent a year. Length of the rectangle correspond to the
value of the variable longer the length higher the value. Highest sale for the given data was on the year
2022 the sale value was 4,495 million. The lowest sale for the company was for the year 2020 the value
of the sale for the corresponding year is 2,582 million. There is no recognizable pattern as it keep
increasing & decreasing.
4. Operating Profit
The lowest value for the operating profit was for the year 2021 the company in that year was in the loss
the loss value was 137 million. The highest value of the operating profit was for the year 2018 the profit
value for the year was 84 million. The pattern is a variable pattern as it keep changing each year.
5. Gross Profit
The tool used for the visualization of the data is known as pie chart. Pie chart is a graph each portion
represent a different variable the larger the area means higher the variable value. The highest gross
profit was for the year 2018 which was 233 million. The lowest gross profit is for the year 2021 which is
33 million. There is no recognizable pattern as keep on changing each year.
6. Cash & Cash equivalents
The lowest value is for the year 2023 which is 20 million. The highest value is for the year 2020 which is
265 million. Same here there is no recognizable pattern as it keep changing each year
