Analysis of Dataset A for Income and Net Income

ICT PROJECT A
DATASET A

TABLE OF CONTENTS
• DATASET A
• SOLVING
• FORMULA TAB
• INCOME VS NET INCOME
• 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
Date 3/31/2022
No of Businesses 6Tax 21%
Business Income (£) Rank High/Low Income Tax Net Income
Mobile Phone Repair Shop 750070 1High 157514.7 592555.3
Stationery Shop 1360600 1High 285726 1074874
Confectionery Retailer 580000 2High 121800 458200
Watch Retailer 150650 4Low 31636.5 119013.5
Shoes Repair Shop 480000 2High 100800 379200
Computer Repair Shop 230000 3High 48300 181700
Total Net Income 2805542.8 Total Net Income of rank 2 837400
Average Net Income 467590.47
Average Net Income of Rank
1 833714.65
Highest Net Income 1074874 Count of Net Income >£500k 2
Lowest Net Income 119013.5 Count of Net Income <£500k 4