STATIONARY SUPPLIES LTD
Gross
Name Basic Pay Allowances Salary Dedactions Net pay $17,000.00
Lewis $ 15,791.00 $ 3,158.20 $ 18,949.20 $ 2,273.90 $ 16,675.30
Francis $ 15,537.00 $ 3,107.40 $ 18,644.40 $ 2,237.33 $ 16,407.07 $16,500.00
Benard $ 15,506.00 $ 3,101.20 $ 18,607.20 $ 2,232.86 $ 16,374.34
amount paid in Ksh
$16,000.00
George $ 15,417.00 $ 3,083.40 $ 18,500.40 $ 2,220.05 $ 16,280.35
Albert $ 14,969.00 $ 2,993.80 $ 17,962.80 $ 2,155.54 $ 15,807.26 $15,500.00
Edward $ 14,651.00 $ 2,930.20 $ 17,581.20 $ 2,109.74 $ 15,471.46
Cornell $ 14,618.00 $ 2,923.60 $ 17,541.60 $ 2,104.99 $ 15,436.61 $15,000.00
John $ 14,553.00 $ 2,910.60 $ 17,463.60 $ 2,095.63 $ 15,367.97
Carl $ 14,508.00 $ 2,901.60 $ 17,409.60 $ 2,089.15 $ 15,320.45 $14,500.00
Lewis Francis B
STATIONARY SUPPLIES LTD
$17,000.00
$16,500.00
amount paid in Ksh
$16,000.00
$15,500.00
$15,000.00
$14,500.00
Lewis Francis Benard George Albert Edward Cornell John Carl
Names
Town/Day Mon Tue Wed Thur Fri
In degree celsius
Average Temp.C
Mombasa 30 29.5 31 28.5 32 30.2
Kisumu 31 33 30 30 32 31.2
Nakuru 22.5 22.1 23.25 21.4 24 22.7
Nairobi 24 23.5 22 23 24.5 23.4
Kericho 18 17.7 18.6 17.1 19.2 18.1
Town/Day Mon Tue Wed Thur Fri
Temp. indegree Fahrenheit
Average Temp.F
Mombasa 29.4 29.1 30 28.5 30.6 29.5
Kisumu 30 31.2 29.4 29.4 30.6 30.1
Nakuru 24.9 24.675 25.35 24.2 25.8 25.0
Nairobi 25.8 25.5 24.6 25.2 26.1 25.4
Kericho 22.2 22.02 22.56 21.7 22.92 22.3
Opening Closing Sold
Item Stock stock Items Buying Price Selling price Total Profit
Sugar (bags) 250 130 120 2500 2650 318000 18000
Unga(ctn) 340 120 220 400 450 99000 11000
Salt(ctn) 250 30 220 220 265 58300 9900
Kimbo(ctn) 241 107 134 200 250 33500 6700
Blue band(ctn) 300 210 90 1150 1200 108000 4500
Grand Total 1381 597 784 4470 4815 616800 50100
Employee Net
Name Department Sex Age Salary Tax Relief Salary Nationality
Fancy Engineering F 30 1000 200 100 900 Kenya
Mesfine Accounting M 23 1234 247 123 1111 Ethiopia
Alexandria Maintainance F 36 2341 468 351 2224 Kenya
Davis Sales M 31 3355 671 503 3187 USA
Bezabih Sales M 41 1267 253 127 1140 Ethiopia
Annet Accounting F 33 5534 1107 1107 5534 USA
Mellion Engineering M 32 7123 1425 1425 7123 USA
Adenech Accounting F 26 1233 247 123 1110 Ethiopia
samson Maintainance M 22 2133 427 320 2026 Kenya
Amina Sales F 31 1543 309 154 1389 Ethiopia
Hellen Sales M 27 5612 1122 1122 5612 USA
Adm
NO Name Physics Chemestry Biology Mathematics Total Average Rank
1001 Abede 65 78 56 45 244 61
1002 Adele 53 85 88 78 304 76
1003 Carol 45 96 76 98 315 78.75
1004 Geresiu 78 76 74 65 293 73.25
1005 Liya 23 59 65 36 183 45.75
1006 Hanna 78 68 67 52 265 66.25
1007 Charity 65 53 63 32 213 53.25
1008 Seth 55 65 65 45 230 57.5
1009 Fridah 48 54 75 58 235 58.75
1010 Mary 88 64 45 79 276 69
1011 Jacob 46 58 61 45 210 52.5
1012 Joseph 54 74 52 56 236 59
MAX 88
MIN 23
Joseph
Jacob
Mary
Fridah
Seth
Charity
Hanna
Liya
Geresiu
Carol
Adele
Abede
0 50 100 150 200 250 300 350
Average
83 70 84
65
78
82
65
64
77 79
Brian Rose Susan Michael Ben Lydia Ann Mary Sharon Joseph
Name Eng Math Phy Chem Bio ICT Total Average Grade
Brian 70 80 95 78 88 90 501 84 B
Rose 78 48 60 67 60 79 392 65 D
Susan 80 75 70 65 90 85 465 78 C
Michael 60 45 65 78 75 68 391 65 D
Ben 70 89 69 88 67 88 471 79 C
Lydia 75 75 85 69 78 80 462 77 C
Ann 80 88 20 60 55 79 382 64 D
Mary 85 78 78 75 90 85 491 82 B
Sharon 85 90 79 80 78 87 499 83 B
Joseph 79 84 75 60 55 65 418 70 D
MAX 85 90 95 88 90 90 501 84 B
MIN 60 45 20 60 55 65 382 64 D
