Name Physics Chemistry Math Total Average
Abby 59 79 98 236 78.67
Chip 98 23 32 153 51.00
Maya 98 65 66 229 76.33
Richard 59 65 89 213 71.00
Sum 314 >80
Average 78.5 >70
count 4 0 >60
counta 4 4 <60
max 98
min 59
median 78.5
mode 59
countif 0
Grade Grade Pass/Fail Pass/Fail
B F Pass Fail
F F Fail Fail
B C Pass Pass
B F Pass Fail
A
B 60
C
F
Month Products Sales
January Software 8245 Products
Hardware 5234 Apple
Other 5234 Orange
February Software 2345 Banana
Hardware 5234 Apple
Other 52345
March Software 2345
Hardware 5234
Other 52345
Total Software 12935
Hardware 15702
Other 109924
Profit
Apple 12%
Buying Price Selling Price Orange 15%
7634 8550.08 Banana 20%
5234 6019.1
2345 2814
827345 926626.4
buying price+profit
Payroll Systems
Name Designation Basic HRA Medical Travel SSS
Maya Manager 34543 20725.8 500 3454.3 400
Abby Accountant 52345 20938 500 5234.5 400
Richard Sales 23455 9382 500 2345.5 400
Chip CEO 52345 20938 500 5234.5 400
HRA 40% 60% 40%
Medical 500
Travel 10%
SSS 400
Bonus 50%
Bonus Gross Salary Net Salary
17271.5 75994.6 75094.6
26172.5 104690 103790
11727.5 46910 46010
26172.5 104690 103790
Current date 11/18/2024 Current time 11/18/2024 12:25
Joining date 2/4/2001
7 days
day 18
month 11
year 2024
23
Month Added 2/18/2025
Year Added 10/5/1910 11/18/2031
Day Added 11/25/2024
