Scribd
Upload
19 views36 pages

ESTER (AutoRecovered)

The document contains various academic performance data for students, including scores in different subjects, total scores, averages, and suggestions for continuing or discontinuing studies. It also includes market data for goods sold in Tandle Market, sales figures for supermarkets, and a financial statement for Ruvuma Computers. Additionally, it presents payroll information for employees in a clothing warehouse, summarizing hours worked, pay rates, and taxes.

Uploaded by

abdallahsalma3586
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views36 pages

ESTER (AutoRecovered)

The document contains various academic performance data for students, including scores in different subjects, total scores, averages, and suggestions for continuing or discontinuing studies. It also includes market data for goods sold in Tandle Market, sales figures for supermarkets, and a financial statement for Ruvuma Computers. Additionally, it presents payroll information for employees in a clothing warehouse, summarizing hours worked, pay rates, and taxes.

Uploaded by

abdallahsalma3586
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

AVERAGE

TOTAL
MATH

GEOG

KISW
BIOS
HIST
ENG

PHY
NAMES
Llily 90 88 60 66 70 48 58 480 68.57
James 40 46 68 60 78 45 60 397 56.71
Anne 30 41 28 44 60 10 30 243 34.71
Mary 40 40 50 44 55 28 80 337 48.14
Bernard 20 40 20 10 48 60 40 238 34.00
Ezekiel 50 30 40 10 12 10 70 222 31.71
Silvesta 77 70 90 70 88 48 50 493 70.43
Mussa 88 80 100 98 52 46 58 522 74.57
Abi 90 70 50 60 48 68 55 441 63.00
Aziza 100 60 50 40 77 98 75 500 71.43
SUGGESTION
Continue Studies
Discontinues Studies
Discontinues Studies
Discontinues Studies
Discontinues Studies
Discontinues Studies
Continue Studies
Continue Studies
Continue Studies
Continue Studies
GOODS IN TANDLE MARKET
NAME JAN FEB MARCH APR
CASSAVA 3,000 2,000 2,800 3,900
BEANS 3,000 2,500 3,500 4,000
RICE 2,000 1,800 1,800 200
WHEAT FLOUR 2,800 2,900 3,800 2,500
SWEET POTATOES 3,000 3,500 1,500 2,800
APPLES 3,800 2,500 2,800 2,000

BEANS 3,000 2,500 3,500 4,000


WHEAT FLOUR 2,800 2,900 3,800 2,500

GOODS IN TANDLE MARKET

4,000
3,000
2,000
JAN
1,000
FEB
VALUE

- MARCH
CASSAVA

RICE

WHEAT FLOUR

SWEET POTATOES
BEANS

APPLES
APR

NAMES
MAX MIN AVERAGE
3,900 2,000 2,925
4,000 2,500 3,250
2,000 200 1,450
3,800 2,500 3,000
3,500 1,500 2,700
3,800 2,000 2,775

4,000 2,500 3,250


3,800 2,500 3,000

JAN
FEB
MARCH
APPLES

APR
S/N NAME English Math Pypsics TOTAL AVERAGE Outocome RANK GRADE
1 John 97 98 100 295 98.3 PASS A
2 Richard 86 84 86 256 85.3 PASS A
3 Steve 74 84 97 255 85.0 PASS A
4 Sarah 84 76 73 233 77.7 PASS A
5 Alex 45 46 36 127 42.3 FAIL B
6 Laula 53 48 37 138 46.0 FAIL C
7 Tom 65 84 74 223 74.3 PASS C
8 Mark 37 25 95 157 52.3 FAIL B
9 Paul 85 54 63 202 67.3 PASS C
10 Kate 85 53 63 201 67.0 PASS B
11 Dan 37 37 54 128 42.7 FAIL B
12 Ann 85 95 76 256 85.3 PASS C
23 Diane 33 25 27 85 28.3 FAIL A
14 Joe 41 75 52 168 56.0 FAIL D
15 Sue 32 42 67 141 47.0 FAIL C
16

PASS 8
FAIL 7
FALSE
Exam Result
NAME ENGLISH SWAHILI MATH COMPUTER SCIENCE SOCIAL TOTAL AVERAGE
BATULI 87 96 65 54 63 76 441 74
ASHA 75 87 75 76 54 32 399 67
JUMA 74 73 84 25 95 63 414 69
RICHARD 84 86 84 76 73 85 488 81
RACHEL 52 74 65 63 74 95 423 71
NEEMA 95 85 74 84 97 75 510 85
ESTER 63 74 85 54 63 63 402 67
AVERAGE 75.7 82.1 76.0 61.7 74.1 69.9 439.6 73.3
MAX 95 96 85 84 97 95 510 85
MIN 52 73 65 25 54 32 399 66.5
STATUS GRADE
PASS B
FAIL B
FAIL B
PASS A
PASS B
PASS A
FAIL B
PASS B
PASS A
FAIL B
Cothing warehouse payroll

Name Hours overtime hours Rate per hour monthly pay over time pay Tax
simon 82 2 1,500 123,000 3,750 7,605
Richard 80 4.5 2,000 160,000 11,250 10275
kenneth 77 7.5 3,000 231,000 28,125 15547.5
Juma 79 3 6,500 5,135,000 24,375 32272.5
Lucky 80.5 0 1,000 80,500 - 4830
TOTAL 398.5 17 14000 5729500 67500 70530
AVERAGE 398.5 17 14000 5729500 67500 70530
MAX 82 7.5 6500 5135000 28125 32272.5
MIN 77 0 1000 80500 0 4830

Over time rate Over time rate 125%


Tax 6%
STUDENT EXAMINATION RESULT
NAMES KISWAHILI LITERATURE FRENCH TOTAL
Judith 50 20 65 135
Annie 58 30 87 175
Susan 62 90 74 226
Frida 79 50 96 225
Benjamin 88 75 90 253

Highest marks
Lowest marks
AVERAGE STATUS GRADE
45 PASS C
58 PASS C
75 PASS A
75 PASS A
84 PASS A
RUVUMA COMPUTERS
Income Statement
1 QTR1 QTR2 QTR3 QTR4 TOTAL
2 Sales 240,000 180,000 300,000 270,000 990,000
3 Cost 120,000 100,000 170,000 140,000 530,000
4 gross Profit 120,000 80,000 130,000 130,000 460,000
5 MKTG. Expenses 4,500 2,200 5,000 2,900 14,600
6 G&ADM Expenses 3,600 1,800 2,700 2,850 10,950
7 MISS Expenses 2,400 2,000 3,400 3,200 11,000
8 Total Expenses 10,500 6,000 11,100 8,950 36,550
9 Debit 109,500 74,000 118,900 121,050 423,450
10 Interest(10% of Sales) 24,000 18,000 30,000 27,000 99,000
11 Tax(8% of sales) 19,200 14,400 24,000 21,600 79,200
12 Net Profit 66,300 41,600 64,900 72,450 245,250
13
SUPERMARKET SALES
SALES
TOWN JAN FEB MARCH APRL MAY JUNE JULY AUG TOTAL
MALINYA 43,000 38,000 16,000 33,000 43,000 26,000 32,000 36,000 267,000
MUSOLI 14,000 26,000 22,500 73,000 26,000 31,000 16,000 24,000 232,500
BUKURA 16,000 19,000 29,000 33,000 41,000 21,000 17,000 15,000 191,000
KHWISHO 18,000 34,000 17,000 41,000 36,000 41,000 18,000 16,000 221,000
CHAVAKALI 22,000 25,000 28,000 36,000 24,000 36,000 19,000 18,000 208,000
STATUS
GOOD SALES
FAIR SALES
MORE EFFORT REQUIRED
FAIR SALES
FAIR SALES

You might also like