Scribd
Upload
10 views27 pages

Employee Data and Salary Overview

The document contains employee details including names, dates of birth, addresses, phone numbers, departments, and salaries. It also includes financial data such as salary payments per quarter, expenses by department, and order details with associated costs and profits. Additionally, there are calculations related to sales, discounts, and shipping costs for various orders.

Uploaded by

arpit shah
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
10 views27 pages

Employee Data and Salary Overview

The document contains employee details including names, dates of birth, addresses, phone numbers, departments, and salaries. It also includes financial data such as salary payments per quarter, expenses by department, and order details with associated costs and profits. Additionally, there are calculations related to sales, discounts, and shipping costs for various orders.

Uploaded by

arpit shah
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

EMP F NAME EMP L NAME EMP M NAME DOB ADDRESS PH NO.

Dept No
LALIT SHAH ASHOK 1/2/1980 PUNE 9898999899 1
SWAPNIL DESHMUKH ANIL 2/2/1982 MUMBAI 7788996655 2
SWATI RATGI VIPUL 3/1/1960 MUMBAI 9123456789 1
SAPANA TAWARI PRITAK 4/9/1988 PUNE 9766778899 3

BHAVANA BHANDAEI PREEM 8/22/1979 BANGALORE 9654345676 3


KARTIK SHINDE PRAFUL 12/30/1989 MUMBAI 9090909090 4
RAJ SHEGOKAR PAWAN 6/6/1977 BANGALORE 9455665544 4
TAMANA INGLE SUMIT 5/6/1990 MUMBAI 9687868584 5
AARMAN KHAN SURESH 5/9/1984 BANGALORE 7676767676 1
ASHISH SHARMA MUKESH 4/6/1989 BANGALORE 9898909098 2
LALIT SHAH ASHOK 1/2/1980 PUNE 9898999899 1
SWAPNIL DESHMUKH ANIL 2/2/1982 MUMBAI 7788996655 2
SWATI RATGI VIPUL 3/1/1960 MUMBAI 9123456789 1
SAPANA TAWARI PRITAK 4/9/1988 PUNE 9766778899 3
BHAVANA BHANDAEI PREEM 8/22/1978 BANGALORE 9654345676 3
KARTIK SHINDE PRAFUL 12/30/1989 MUMBAI 9090909090 4
RAJ SHEGOKAR PAWAN 6/6/1977 BANGALORE 9455665544 4
TAMANA INGLE SUMIT 5/6/1990 MUMBAI 9687868584 5
AARMAN KHAN SURESH 5/9/1984 BANGALORE 7676767676 1
ASHISH SHARMA MUKESH 4/6/1989 BANGALORE 9898909098 2
DEPT BASIC SAL GENDER City
HR 10000 male Pune
MARKETING 23000 male Mumbai
HR 27000 female Delhi
PRODUCTION 17000 female Nagpur

PRODUCTION 26000 female Pune


FINANCE 30000 male Mumbai
FINANCE 34000 male Delhi
ADMIN 60000 female Nagpur
HR 36000 male Pune
MARKETING 20000 male Mumbai
HR 10000 male Delhi
MARKETING 23000 male Nagpur
HR 27000 female Pune
PRODUCTION 17000 female Mumbai
PRODUCTION 26000 female Delhi
FINANCE 30000 male Nagpur
FINANCE 34000 male Pune
ADMIN 60000 female Mumbai
HR 36000 male Delhi
MARKETING 20000 male Nagpur
Full Name DOJ Department Salary
Rajshree Shah 2-Mar-20 HR 23000
Mukul Jain 4-Jan-22 MKT 37000
Trupti Bhuyar 5-May-11 MKT 31000
Ramesh Sohani 20-Jul-22 Admin 54000
Vikas Rathod 27-Sep-15 Finance 45000
Full Name DOJ Department Salary
Rajshree Shah 3/2/2020 HR 23000
Mukul Jain 1/4/2022 MKT 37000
Trupti Bhuyar 5/5/2011 MKT 31000
Ramesh Sohani 7/20/2022 Admin 54000
Vikas Rathod 9/27/2015 Finance 45000
Qtr Salary Paid
Qtr1 1,000,000
Qtr2 1,200,000
Qtr3 900,000
Qtr4 1,000,000

Total Salary Paid 4,600,000 4600000


Total Salary Paid 4,100,000 4,100,000
Total Salary Paid 4,100,000 4,100,000

10 2
Add 12
Substract 8
Multiply 20
Divide 5
Power 100
Qtr Salary Paid
Qtr1 1,000,000
Qtr2 1,200,000
Qtr3 900,000
Qtr4 1,500,000

Next Year Estimate 3,115,000 3,100,000 15,000 3,115,000

Sum 4,600,000
Next Yr 46,000
4,646,000

4,646,000

Add 10 20
Div 2

20
15
Full Name DOJ Department Salary
Rajshree Shah 3/2/2020 HR 23000
Mukul Jain 1/4/2022 MKT 37000
Trupti Bhuyar 5/5/2011 MKT 31000
Ramesh Sohani 7/20/2022 Admin 54000
Vikas Rathod 9/27/2015 Finance 45000
Expenses Jan Feb Mar Apr May Jun Jul Aug Sep
HR 24600 22200 22500 29200 22300 27100 44400 43200 35000
MKT 27700 36400 31200 21100 44200 48100 36200 49500 20600
ADMIN 32200 29500 49500 27400 45700 24500 33700 47900 38900
Production 20800 33200 43600 34300 30500 33200 49700 41300 26900
Oct Nov Dec
47100 48600 45300
23400 43800 32200
40900 22300 32200
30900 42700 30800
Qtr Salary Paid
Qtr1 1,000,000
Qtr2 1,200,000
Qtr3 900,000
Qtr4 1,000,000
Repeat the
Number 1 Series 1 - 12 Months Week Date
Date(month) Date(year) Time (copy celAlphabets Double Click
Your Name Series Formula
Order ID Order Date Order_Source Product ID Price Quantity Cost Tot_cost
IN-2020-26294 21-Feb-20 Flipkart FUR-BEV-10001217 7623 2 7064 14128
AU-2020-80165 18-Oct-20 Referral FUR-BEV-10001217 7327 4 6658 26632
AU-2020-62657 6-Dec-20 Referral FUR-BEV-10001217 7623 2 7064 14128
GE-2019-81848 7-May-19 Referral FUR-BEV-10001217 7623 1 7064 7064
CH-2020-13412 1-Apr-20 Flipkart FUR-BEV-10001217 7623 1 7064 7064
CH-2018-35467 30-May-18 Snapdeal FUR-BEV-10001217 7474 2 6858 13716
AU-2019-50745 23-Aug-19 India Mart FUR-BEV-10001217 7327 4 6658 26632
IN-2019-61959 26-Jan-19 Flipkart FUR-BEV-10001217 7623 3 7064 21192
Sales Discount Shiping Cost Tot_Amt Profit Order Priority
15246 1% 38 15131.54 1003.54 High
29308 1% 95 29109.92 2477.92 Medium
15246 0% 69 15315 1187 High
7623 1% 65 7611.77 547.77 High
7623 2% 57 7527.54 463.54 Medium
14948 0% 83 15031 1315 Medium
29308 0% 43 29351 2719 Medium
22869 0% 63 22932 1740 Medium
Order ID Order Date Order_Source Product ID Price Quantity Cost
IN-2020-26294 21-Feb-20 Flipkart FUR-BEV-10001217 7623 2 7064
AU-2020-80165 18-Oct-20 Referral FUR-BEV-10001217 7327 4 6658
AU-2020-62657 6-Dec-20 Referral FUR-BEV-10001217 7623 2 7064
GE-2019-81848 7-May-19 Referral 7623 1 7064
CH-2020-13412 1-Apr-20 Flipkart FUR-BEV-10001217 7623 1 7064
CH-2018-35467 30-May-18 Snapdeal FUR-BEV-10001217 7474 2 6858
AU-2019-50745 23-Aug-19 India Mart FUR-BEV-10001217 7327 4 6658
IN-2019-61959 26-Jan-19 Flipkart FUR-BEV-10001217 3 7064
Tot_cost Sales Discount Shiping Cost Tot_Amt Profit Order Priority
14128 700O 0.01 38 #VALUE! #NAME? High
26632 29308 0.01 95 29109.92 2477.92 Medium
14128 15246 0 69 15315 1187 High
14128 7623 0.01 7546.77 -6581.23 High
7064 7623 0.02 57 7527.54 463.54 Medium
13716 #NAME? 0 83 #NAME? #NAME? Medium
26632 29308 0 43 29351 2719 Medium
21192 0 0 63 63 -21129 Medium
Order ID Order Date Order_Source Customer_ID Contact numbeProduct ID Price
IN-2020-26294 21-Feb-20 Flipkart PB-25546 906540050 FUR-BEV-10001217 7623
AU-2020-80165 18-Oct-20 Referral BF-03491 956086801 FUR-BEV-10001217 7327
AU-2020-62657 6-Dec-20 Referral EJ-09999 923538602 FUR-BEV-10001217 7623
GE-2019-81848 7-May-19 Referral HR-14008 959357348 FUR-BEV-10001217 7623
CH-2020-13412 1-Apr-20 Flipkart AG-01268 924438448 FUR-BEV-10001217 7623
CH-2018-35467 30-May-18 Snapdeal AW-01914 994810273 FUR-BEV-10001217 7474
AU-2019-50745 23-Aug-19 India Mart GM-13008 985322345 FUR-BEV-10001217 7327
IN-2019-61959 26-Jan-19 Flipkart TS-33674 893594027 FUR-BEV-10001217 7623

Order ID Order Date Order_Source Customer_ID Contact numberProduct ID Price


IN-2020-26294 43882 Flipkart PB-25546 906540050 FUR-BEV-10001217 7623
AU-2020-80165 44122 Referral BF-03491 956086801 FUR-BEV-10001217 7327
AU-2020-62657 44171 Referral EJ-09999 923538602 FUR-BEV-10001217 7623
GE-2019-81848 43592 Referral HR-14008 959357348 FUR-BEV-10001217 7623
CH-2020-13412 43922 Flipkart AG-01268 924438448 FUR-BEV-10001217 7623
CH-2018-35467 43250 Snapdeal AW-01914 994810273 FUR-BEV-10001217 7474
AU-2019-50745 43700 India Mart GM-13008 985322345 FUR-BEV-10001217 7327
IN-2019-61959 43491 Flipkart TS-33674 893594027 FUR-BEV-10001217 7623
Quantity Cost Tot_cost Sales Discount Shiping Cost Tot_Amt Order Priority
2 7064 14,128.00 15,246.00 1% 38 ₹ 15,131.54 High
4 6658 26,632.00 29,308.00 1% 95 ₹ 29,109.92 Medium
2 7623 15,246.00 15,246.00 0% 69 ₹ 15,315.00 High
1 7064 7,064.00 7,623.00 1% 65 ₹ 7,611.77 High
1 7064 7,064.00 7,623.00 2% 57 ₹ 7,527.54 Medium
2 6858 13,716.00 14,948.00 0% 83 ₹ 15,031.00 Medium
4 6658 26,632.00 29,308.00 0% 43 ₹ 29,351.00 Medium
3 7064 21,192.00 22,869.00 0% 63 ₹ 22,932.00 Medium

Quantity Cost Tot_cost Sales Discount Shiping Cost Tot_Amt Order Priority
2 7064 14128 15246 0.01 38 15131.54 High
4 6658 26632 29308 0.01 95 29109.92 Medium
2 7623 15246 15246 0 69 15315 High
1 7064 7064 7623 0.01 65 7611.77 High
1 7064 7064 7623 0.02 57 7527.54 Medium
2 6858 13716 14948 0 83 15031 Medium
4 6658 26632 29308 0 43 29351 Medium
3 7064 21192 22869 0 63 22932 Medium
Order ID Order Date Order_Source Customer_ID Contact number Product ID Price
IN-2020-26294 21-Feb-20 Flipkart PB-25546 +91-906540050 FUR-BEV-10001217 7623
AU-2020-80165 18-Oct-20 Referral BF-03491 +91-956086801 FUR-BEV-10001217 7327
AU-2020-62657 6-Dec-20 Referral EJ-09999 +91-923538602 FUR-BEV-10001217 7623
GE-2019-81848 7-May-19 Referral HR-14008 +91-959357348 FUR-BEV-10001217 7623
CH-2020-13412 1-Apr-20 Flipkart AG-01268 +91-924438448 FUR-BEV-10001217 7623
CH-2018-35467 30-May-18 Snapdeal AW-01914 +91-994810273 FUR-BEV-10001217 7474
AU-2019-50745 23-Aug-19 India Mart GM-13008 +91-985322345 FUR-BEV-10001217 7327
IN-2019-61959 26-Jan-19 Flipkart TS-33674 +91-893594027 FUR-BEV-10001217 7623

Order ID Order Date Order_Source Customer_ID Contact number Product ID Price


IN-2020-26294 2020/02/21 Flipkart PB-25546 +91-906540050 FUR-BEV-10001217 7623
AU-2020-80165 2020/10/18 Referral BF-03491 +91-956086801 FUR-BEV-10001217 7327
AU-2020-62657 2020/12/06 Referral EJ-09999 +91-5342342342 FUR-BEV-10001217 7623
GE-2019-81848 2019/05/07 Referral HR-14008 +91-959357348 FUR-BEV-10001217 7623
CH-2020-13412 2020/04/01 Flipkart AG-01268 +91-924438448 FUR-BEV-10001217 7623
CH-2018-35467 2018/05/30 Snapdeal AW-01914 +91-994810273 FUR-BEV-10001217 7474
AU-2019-50745 2019/08/23 India Mart GM-13008 +91-985322345 FUR-BEV-10001217 7327
IN-2019-61959 2019/01/26 Flipkart TS-33674 +91-893594027 FUR-BEV-10001217 7623
Quantity Cost Tot_cost Sales Discount Shiping Cost Tot_Amt Order Priority
002 qty 7064 14,128.00 15,246.00 1% 38 ₹ 15,131.54 High
004 qty 6658 26,632.00 29,308.00 1% 95 ₹ 29,109.92 Medium
002 qty 7623 15,246.00 15,246.00 0% 69 ₹ 15,315.00 High
001 qty 7064 7,064.00 7,623.00 1% 65 ₹ 7,611.77 High
001 qty 7064 7,064.00 7,623.00 2% 57 ₹ 7,527.54 Medium
002 qty 6858 13,716.00 14,948.00 0% 83 ₹ 15,031.00 Medium
004 qty 6658 26,632.00 29,308.00 0% 43 ₹ 29,351.00 Medium
003 qty 7064 21,192.00 22,869.00 0% 63 ₹ 22,932.00 Medium

Quantity Cost Tot_cost Sales Discount Shiping Cost Tot_Amt Order Priority
022 qty 7064 155,408.00 15,246.00 1.000% 38.00 15,131.54 ₽ High
033 qty 6658 26,632.00 29,308.00 1.000% -99.00 29,109.92 ₽ Medium
002 qty 7623 15,246.00 15,246.00 0.000% 69.00 15,315.00 ₽ High
001 qty 7064 7,064.00 7,623.00 1.000% 65.00 7,611.77 ₽ High
001 qty 7064 7,064.00 7,623.00 2.000% 57.00 7,527.54 ₽ Medium
222 qty 6858 13,716.00 14,948.00 0.000% 83.00 15,031.00 ₽ Medium
004 qty 6658 26,632.00 29,308.00 0.000% 43.00 29,351.00 ₽ Medium
003 qty 7064 21,192.00 22,869.00 0.000% 63.00 22,932.00 ₽ Medium
Order ID Order Date Order_Source Customer_ID Contact number
IN-2020-26294 21-Feb-20 Flipkart PB-25546 +91-906540050
AU-2020-80165 18-Oct-20 Referral BF-03491 +91-956086801
AU-2020-62657 6-Dec-20 Referral EJ-09999 +91-923538602
GE-2019-81848 7-May-19 Referral HR-14008 +91-959357348
CH-2020-13412 1-Apr-20 Flipkart AG-01268 +91-924438448
CH-2018-35467 30-May-18 Snapdeal AW-01914 +91-994810273
AU-2019-50745 23-Aug-19 India Mart GM-13008 +91-985322345
IN-2019-61959 26-Jan-19 Flipkart TS-33674 +91-893594027

Order ID Order Date Order_Source Customer_ID Contact number


IN-2020-26294 21-Feb-20 Flipkart PB-25546 +91-906540050
AU-2020-80165 18-Oct-20 Referral BF-03491 +91-956086801
AU-2020-62657 6-Dec-20 Referral EJ-09999 +91-923538602
GE-2019-81848 7-May-19 Referral HR-14008 +91-959357348
CH-2020-13412 1-Apr-20 Flipkart AG-01268 +91-924438448
CH-2018-35467 30-May-18 Snapdeal AW-01914 +91-994810273
AU-2019-50745 23-Aug-19 India Mart GM-13008 +91-985322345
IN-2019-61959 26-Jan-19 Flipkart TS-33674 +91-893594027
Product ID Price Quantity Cost Tot_cost Sales Discount Shiping Cost
FUR-BEV-10001217 7623 002 qty 7064 14,128.00 15,246.00 1% 38
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 1% 95
FUR-BEV-10001217 7623 002 qty 7623 15,246.00 15,246.00 0% 69
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 1% 65
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 2% 57
FUR-BEV-10001217 7474 002 qty 6858 13,716.00 14,948.00 0% 83
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 0% 43
FUR-BEV-10001217 7623 003 qty 7064 21,192.00 22,869.00 0% 63

Product ID Price Quantity Cost Tot_cost Sales Discount Shiping Cost


FUR-BEV-10001217 7623 002 qty 7064 14,128.00 15,246.00 1% 38
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 1% 95
FUR-BEV-10001217 7623 002 qty 7623 15,246.00 15,246.00 0% 69
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 1% 65
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 2% 57
FUR-BEV-10001217 7474 002 qty 6858 13,716.00 14,948.00 0% 83
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 0% 43
FUR-BEV-10001217 7623 003 qty 7064 21,192.00 22,869.00 0% 63
Tot_Amt Order Priority
₹ 15,131.54 High
₹ 29,109.92 Medium
₹ 15,315.00 High
₹ 7,611.77 High
₹ 7,527.54 Medium
₹ 15,031.00 Medium
₹ 29,351.00 Medium
₹ 22,932.00 Medium

Tot_Amt Order Priority


₹ 15,131.54 High
₹ 29,109.92 Medium
₹ 15,315.00 High
₹ 7,611.77 High
₹ 7,527.54 Medium
₹ 15,031.00 Medium
₹ 29,351.00 Medium
₹ 22,932.00 Medium
Order ID Order Date Order_Source Customer_ID Contact number
IN-2020-26294 21-Feb-20 Flipkart PB-25546 +91-906540050
AU-2020-80165 18-Oct-20 Referral BF-03491 +91-956086801
AU-2020-62657 6-Dec-20 Referral EJ-09999 +91-923538602
GE-2019-81848 7-May-19 Referral HR-14008 +91-959357348
CH-2020-13412 1-Apr-20 Flipkart AG-01268 +91-924438448
CH-2018-35467 30-May-18 Snapdeal AW-01914 +91-994810273
AU-2019-50745 23-Aug-19 India Mart GM-13008 +91-985322345
IN-2019-61959 26-Jan-19 Flipkart TS-33674 +91-893594027

Order ID Order Date Order_Source Customer_ID Contact number


IN-2020-26294 21-Feb-20 Flipkart PB-25546 +91-906540050
AU-2020-80165 18-Oct-20 Referral BF-03491 +91-956086801
AU-2020-62657 6-Dec-20 Referral EJ-09999 +91-923538602
GE-2019-81848 7-May-19 Referral HR-14008 +91-959357348
CH-2020-13412 1-Apr-20 Flipkart AG-01268 +91-924438448
CH-2018-35467 30-May-18 Snapdeal AW-01914 +91-994810273
AU-2019-50745 23-Aug-19 India Mart GM-13008 +91-985322345
IN-2019-61959 26-Jan-19 Flipkart TS-33674 +91-893594027
Product ID Price Quantity Cost Tot_cost Sales Discount Shiping Cost
FUR-BEV-10001217 7623 002 qty 7064 14,128.00 15,246.00 1% 38
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 1% 95
FUR-BEV-10001217 7623 002 qty 7623 15,246.00 15,246.00 0% 69
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 1% 65
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 2% 57
FUR-BEV-10001217 7474 002 qty 6858 13,716.00 14,948.00 0% 83
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 0% 43
FUR-BEV-10001217 7623 003 qty 7064 21,192.00 22,869.00 0% 63

Product ID Price Quantity Cost Tot_cost Sales Discount Shiping Cost


FUR-BEV-10001217 7623 002 qty 7064 14,128.00 15,246.00 1% 38
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 1% 95
FUR-BEV-10001217 7623 002 qty 7623 15,246.00 15,246.00 0% 69
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 1% 65
FUR-BEV-10001217 7623 001 qty 7064 7,064.00 7,623.00 2% 57
FUR-BEV-10001217 7474 002 qty 6858 13,716.00 14,948.00 0% 83
FUR-BEV-10001217 7327 004 qty 6658 26,632.00 29,308.00 0% 43
FUR-BEV-10001217 7623 003 qty 7064 21,192.00 22,869.00 0% 63
Tot_Amt Order Priority
₹ 15,131.54 High
₹ 29,109.92 Medium
₹ 15,315.00 High
₹ 7,611.77 High
₹ 7,527.54 Medium
₹ 15,031.00 Medium
₹ 29,351.00 Medium
₹ 22,932.00 Medium

Tot_Amt Order Priority


₹ 15,131.54 High
₹ 29,109.92 Medium
₹ 15,315.00 High
₹ 7,611.77 High
₹ 7,527.54 Medium
₹ 15,031.00 Medium
₹ 29,351.00 Medium
₹ 22,932.00 Medium

You might also like