Comprehensive Analysis of Business Income, Tax, and Performance

This assignment presents a detailed analysis of a business income dataset, focusing on key financial metrics and tax implications. The dataset includes information from various businesses, such as mobile phone repair shops, stationery shops, confectionery retailers, watch retailers, shoe repair shops, and computer repair shops. The analysis involves calculating the tax net income based on a given tax rate, determining income ranks (High/Low), and computing total and average net incomes. It also identifies the highest and lowest net incomes within the dataset. Furthermore, the assignment includes a visual representation of the data through charts, comparing income versus net income for each business. The formulas used for the calculations are referenced, and the findings are presented in a clear and organized manner, providing valuable insights into business performance and tax implications. Desklib provides access to similar solved assignments and past papers to aid students in their studies.

PART-B

TABLE OF CONTENT
 Dataset
 Solving of Dataset
 Presentation of chart
 References

DATASET A
Date
No of Businesses Tax 21%
Business Income (£) Rank High/Low Income Tax Net Income
Mobile Phone Repair Shop 750070 1
Stationery Shop 1360600 1
Confectionery Retailer 580000 2
Watch Retailer 150650 4
Shoes Repair Shop 480000 2
Computer Repair Shop 230000 3
Total Net Income Total Net Income of rank 2
Average Net Income
Average Net Income of Rank
1
Highest Net Income Count of Net Income >£500k
Lowest Net Income Count of Net Income <£500k

Solution of Dataset
A B C D E F
Date 3/7/2022
No of Businesses 6Tax 21%
Business Income (£) Rank High/Low Income Tax Net Income
Mobile Phone Repair Shop 750070 1High 157515 592555
Stationery Shop 1360600 1High 285726 1074874
Confectionery Retailer 580000 2High 121800 458200
Watch Retailer 150650 4Low 31636.5 119014
Shoes Repair Shop 480000 2High 100800 379200
Computer Repair Shop 230000 3High 48300 181700
Total Net Income 2805543 Total Net Income of rank 2 837400
Average Net Income 467590.5 Average Net Income of
Rank 1 833715
Highest Net Income 1074874 Count of Net Income
>£500k 2
Lowest Net Income 119013.5 Count of Net Income
<£500k 4

Formula which is used to solve the dataset

Continued…

Continued…

Continued…

Chart
Business Income (£) Net Income
Mobile Phone Repair
Shop 750070 592555.3
Stationery Shop 1360600 1074874
Confectionery Retailer 580000 458200
Watch Retailer 150650 119013.5
Shoes Repair Shop 480000 379200
Computer Repair Shop 230000 181700
Mobile Phone
Repair Shop
Stationery Shop Confectionery
Retailer
Watch Retailer Shoes Repair
Shop
Computer
Repair Shop
0
200000
400000
600000
800000
1000000
1200000
1400000
1600000
750070
1360600
580000
150650
480000
230000
592555.3
1074874
458200
119013.5
379200
181700
Income vs Net Income of Business
Income (£) Net Income

References
 Zhang, C. and Lu, Y., 2021. Study on artificial intelligence: The state of the art and future
prospects. Journal of Industrial Information Integration. 23. p.100224.
 Dick, S., 2019. Artificial intelligence.