OrderDate Region Manager SalesMan Item Units Unit_price

2/26/18 Central Timothy David Cell Phone 27 225.00

10/22/18 East Martha Alexander Cell Phone 64 225.00
11/8/18 East Douglas Karen Cell Phone 15 225.00
4/27/19 East Martha Diana Cell Phone 96 225.00
9/27/19 West Timothy Stephen Cell Phone 76 225.00
Sale_amt
6,075.00
14,400.00
3,375.00
21,600.00
17,100.00
 Region Data
Central
Manager Sales Man Item Sum of Units Sum of Unit p
Douglas 156 1,823.00
John 156 1,823.00
Desk 2 125.00
Home Theater 87 500.00
Television 67 1,198.00
Karen
Cell Phone
Home Theater
Video Games
Michael
Home Theater
Television
Hermann 647 5,953.00
Luis 281 3,454.50
Shelli 193 742.00
Sigal 173 1,756.50
Martha 183 4,094.00
Alexander
Cell Phone
Home Theater
Television
Video Games
Diana
Cell Phone
Home Theater
Steven 183 4,094.00
Home Theater 28 500.00
Television 155 3,594.00
Timothy 213 3,621.00
David 213 3,621.00
Cell Phone 27 225.00
Home Theater 126 1,000.00
Television 60 2,396.00
Stephen
Cell Phone
Desk
Home Theater
Television
Total Result 1199 15,491.00
 East West
Sum of Sale amt Sum of Units Sum of Unit pSum of Sale amt Sum of Units
124,016.00 170 783.50 48,204.00 89
124,016.00
250.00
43,500.00
80,266.00
170 783.50 48,204.00
15 225.00 3,375.00
81 500.00 40,500.00
74 58.50 4,329.00
89
57
32
365,108.50
206,373.00
33,698.00
125,037.50
199,690.00 521 4,963.00 272,803.00
396 4,238.00 236,703.00
64 225.00 14,400.00
124 1,500.00 62,000.00
130 2,396.00 155,740.00
78 117.00 4,563.00
125 725.00 36,100.00
96 225.00 21,600.00
29 500.00 14,500.00
199,690.00
14,000.00
185,690.00
140,955.00 142
140,955.00
6,075.00
63,000.00
71,880.00
142
76
3
7
56
829,769.50 691 5,746.50 321,007.00 231
 Total Sum of Units Total Sum ofTotal Sum of Sale amt
Sum of Unit price Sum of Sale amt
1,698.00 66,836.00 415 4,304.50 ###
156 1,823.00 ###
2 125.00 250.00
87 500.00 ###
67 1,198.00 ###
170 783.50 ###
15 225.00 ###
81 500.00 ###
74 58.50 ###
1,698.00 66,836.00 89 1,698.00 ###
500.00 28,500.00 57 500.00 ###
1,198.00 38,336.00 32 1,198.00 ###
647 5,953.00 ###
281 3,454.50 ###
193 742.00 ###
173 1,756.50 ###
704 9,057.00 ###
396 4,238.00 ###
64 225.00 ###
124 1,500.00 ###
130 2,396.00 ###
78 117.00 ###
125 725.00 ###
96 225.00 ###
29 500.00 ###
183 4,094.00 ###
28 500.00 ###
155 3,594.00 ###
2,048.00 88,063.00 355 5,669.00 ###
213 3,621.00 ###
27 225.00 ###
126 1,000.00 ###
60 2,396.00 ###
2,048.00 88,063.00 142 2,048.00 ###
225.00 17,100.00 76 225.00 ###
125.00 375.00 3 125.00 375.00
500.00 3,500.00 7 500.00 ###
1,198.00 67,088.00 56 1,198.00 ###
3,746.00 154,899.00 2121 24,983.50 ###
m of Sale amt
Order Date Region Manager Sales Man

6/Jan/18 East Alexander

Martha
23/Jan/18 Central Shelli
Hermann
9/Feb/18 Central Luis
Hermann
26/Feb/18 Central David
Timothy
15/Mar/18 West Stephen
Timothy
1/Apr/18 East Alexander
Martha
18/Apr/18 Central Martha Steven

5/May/18 Central Luis

Hermann
22/May/18 West Douglas Michael

8/Jun/18 East Alexander

Martha
25/Jun/18 Central Sigal
Hermann
12/Jul/18 East Martha Diana

29/Jul/18 East Douglas Karen

15/Aug/18 East Alexander

Martha
1/Sep/18 Central Douglas John

18/Sep/18 East Alexander

Martha
5/Oct/18 Central Sigal
Hermann
22/Oct/18 East Alexander
Martha
8/Nov/18 East Douglas Karen

25/Nov/18 Central Shelli

Hermann
12/Dec/18 Central Douglas John

29/Dec/18 East Douglas Karen

15/Jan/19 Central David

Timothy
1/Feb/19 Central Douglas John

18/Feb/19 East Martha Alexander

7/Mar/19 West Stephen

Timothy
24/Mar/19 Central Luis
Hermann
10/Apr/19 Central Martha Steven

27/Apr/19 East Martha Diana

14/May/19 Central David

Timothy
31/May/19 Central David
Timothy
17/Jun/19 Central Shelli
Hermann
4/Jul/19 East Martha Alexander

21/Jul/19 Central Sigal

Hermann
7/Aug/19 Central Shelli
Hermann
24/Aug/19 West Stephen
Timothy
10/Sep/19 Central David
Timothy
27/Sep/19 West Stephen
Timothy
14/Oct/19 West Douglas Michael

31/Oct/19 Central Martha Steven

17/Nov/19 Central Luis

Hermann
4/Dec/19 Central Luis
Hermann
21/Dec/19 Central Martha Steven
 Item Units Unit price Sale amt

Television 95 1,198.00
113810
Home Theater 50 500.00
25,000.00
Television 36 1,198.00
43,128.00
Cell Phone 27 225.00
6,075.00
Television 56 1,198.00
67,088.00
Home Theater 60 500.00
30,000.00
Television 75 1,198.00
89,850.00
Television 90 1,198.00
107,820.00
Television 32 1,198.00
38,336.00
Home Theater 60 500.00
30,000.00
Television 90 1,198.00
107,820.00
Home Theater 29 500.00
14,500.00
Home Theater 81 500.00
40,500.00
Television 35 1,198.00
41,930.00
Desk 2 125.00
250.00
Video Games 16 58.50
936.00
Home Theater 28 500.00
14,000.00
Cell Phone 64 225.00
14,400.00
Cell Phone 15 225.00
3,375.00
Video Games 96 58.50
5,616.00
Television 67 1,198.00
80,266.00
Video Games 74 58.50
4,329.00
Home Theater 46 500.00
23,000.00
Home Theater 87 500.00
43,500.00
Home Theater 4 500.00
2,000.00
Home Theater 7 500.00
3,500.00
Video Games 50 58.50
2,925.00
Television 66 1,198.00
79,068.00
Cell Phone 96 225.00
21,600.00
Television 53 1,198.00
63,494.00
Home Theater 80 500.00
40,000.00
Desk 5 125.00
625.00
Video Games 62 58.50
3,627.00
Video Games 55 58.50
3,217.50
Video Games 42 58.50
2,457.00
Desk 3 125.00
375.00
Television 7 1,198.00
8,386.00
Cell Phone 76 225.00
17,100.00
Home Theater 57 500.00
28,500.00
Television 14 1,198.00
16,772.00
Home Theater 11 500.00
5,500.00
Home Theater 94 500.00
47,000.00
Home Theater 28 500.00
14,000.00
 Stude
Englis Scienc
S No nt Telug Hindi Maths Social Total Avg
h e
name u
1 Ramu 56 47 89 76 45 97 410 68.33333
2 Shiva 76 87 76 54 90 79 462 77
3 Manoj 89 98 88 76 89 65 505 84.16667
4 Rakhi 98 89 76 90 77 89 519 86.5
5 Prasad 98 67 88 67 56 78 454 75.66667
6 Bhashar 78 56 77 89 65 92 457 76.16667
7 Poorna 98 76 89 76 54 67 460 76.66667
8 Amith 89 78 78 77 76 56 454 75.66667
9 Ramarao 78 67 89 67 56 92 449 74.83333
10 Ajay 89 76 89 76 65 72 467 77.83333
 Name of the Department Designation Salary
Employee

Raju Sericulture Accountant 20000

Neeraj Computer DOE 18500

Shiva Revenue SA 23000

Prathap Computer JA 20000

Prasad English SA 40000

Anirudh Science JA 21000

Jathin Acedemic Superendent 52000

Anirudh Examination SA 61000

Janakiram Sericulture JA 25000

Damodar Computer SA 42000

Ramesh Revenue Superendent 58000

 Name of the Department Designation
Employee

Raju Sericulture Accountant

Neeraj Computer DOE

Shiva Revenue SA

Pratap Computer JA

Prasad English SA

Anirudh Science JA

Jatin Academic Supervenient

Anirudh Examination SA

Janaki ram Sericulture JA

Damodar Computer SA

Ramesh Revenue Supervenient

Salary

20000

18500

23000

20000

40000

21000

52000

61000

25000

42000

58000
 Shiva Engineering Shiva Engineering

Ramana Engineering Ramana Engineering

Sruthi Technlogies Sruthi Technlogies

Baba Jewellery Baba Jewellery

Anada Diagnostics Anada Diagnostics

1000-2bc-101 2bc

1001-3bc-102 3bc

1002-4bc-103 4bc

1003-5bc-104 5bc

Jan Feb

Name Salary Name Salary

Ramu 8000 Ramu 8400

Shiva 7500 Shiva 8100

Ajay 9000 Ajay 8800

 Monday o m

Tuesday u t Text column

Wednesday e w Slno,Name,Address,Phone,Details

Thursday h t 1,Shiva,MVP,6646464,Deom

Friday r f

Saturday a s

Sunday u s

Sales Man Item Amount

Raju Plants 7000

Shiva Flowers 8000

Ramu Fruits 9000

March

Name Salary Consolidated

Ramu 9200 Ramu 25600

Shiva 8800 Shiva 24400

Ajay 9100 Ajay 26900

ame,Address,Phone,Details Name fathername Aadharnumber PAN number

,MVP,6646464,Deom Ramu Jairam 76786487326 6324876893583

Slno Name Address Phone Details

1 Shiva MVP 6646464 Deom

Name fathername Aadharnumber PAN

Ramu Jairam 76786487326 766348765

Item Qty

Apple 120

Guava 180

Mango 200

Dragon 150

Pomogranate 220
P Rate Amount Target

16.66666666667 2000 2000

10 1800 1800

15 3000 3000

33.33333333333 5000 5000

18.18181818182 4000 4000

P Amount 20000

Time 12

Rate of Int 4

Simple Interest 9600 25000 70000 45000

12

16

18

24

32
30000
EMP NO EMP NAME DESIGNATION

1 SHIVA SA

2 RAMU JA

3 BUJJI AC

4 KIRAN DC

5 NETAJI SA

6 SUBASH JA

HRA

TA

DA
 EMPLOYEES SALARY STATEMENT
GROSS
BASIC PAY GROSS TOTAL
HRA TA DA

33000 4950 1650 10899.9 50499.9

21000 3150 1050 6936.3 32136.3

25000 3750 1250 8257.5 38257.5

23000 3450 1150 7596.9 35196.9

33000 4950 1650 10899.9 50499.9

21000 3150 1050 6936.3 32136.3

15%

5%

33.03%
 DEDUCTIONS
DEDUCTIONS
NET SALARAY
TOTAL
APGLI PF

1200 6600 7800 42699.9

1201 4200 5401 26735.3

1202 5000 6202 32055.5

1203 4600 5803 29393.9

1204 6600 7804 42695.9

1205 4200 5405 26731.3

S No Name of the studTelugu Hindi

1 SHIVA 72 67

2 RAMU 34 67

3 BUJJI 78 22

4 KIRAN 72 67

5 NETAJI 34 67

6 SUBASH 78 22

7 NANI 28 77
English Maths Science Social Total

89 56 45 98 427

98 77 88 91 455

78 90 78 67 413

89 56 45 98 427

98 77 88 91 455

78 90 78 67 413

88 67 56 77 393
Avg Rank Result Grade

71.16666666667 3 PASS NO GRADE

75.83333333333 1 FAIL NO GRADE

68.83333333333 5 FAIL FIRST

71.16666666667 3 PASS NO GRADE

75.83333333333 1 FAIL NO GRADE

68.83333333333 5 FAIL FIRST

65.5 7 FAIL NO GRADE