Scribd
Upload
4 views9 pages

Students Excel)

The document contains employee data including names, departments, salaries, join dates, performance scores, and changes in salary. It also includes bonus percentages, ratings, regions, and target amounts for each employee. Additionally, there are details about super bonuses, tax rates, and product average prices across different regions.

Uploaded by

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

Students Excel)

The document contains employee data including names, departments, salaries, join dates, performance scores, and changes in salary. It also includes bonus percentages, ratings, regions, and target amounts for each employee. Additionally, there are details about super bonuses, tax rates, and product average prices across different regions.

Uploaded by

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

Employee Name | Dept | Salary | Join Date | Performance Score | Change in Salary

JOHN DOE| SALES |45000| 12-5-2022 |8|5000


Jane doe|sales| $52,000.00 | 5-1-2022 |7|-2000
Ravi Kumar | Finance |63000.5| 01/04/23 |8|8000
Meena | finance |70000| Apr 15 2021 |9|-5000
Amitabh B | HR |55000| 2023/11/01 |6|3000
Rashmi | HR |50000| 10.10.2020 |10|4000
Vijay D | IT |82000|3rd March 2022 |7|-7000

▲
▼
EmpID Name Dept Salary Bonus% JoinYear Rating Region Target Bonus Amount
E001 Asha Sales 45000 10% 2018 4.2 North 120
E002 Ravi HR 52000 12% 2019 3.8 South 150
E003 Meera Finance 61000 15% 2017 4.5 East 180
E004 John IT 70000 8% 2020 4 West 160
E005 Sana Sales 48000 10% 2016 4.7 North 140
E006 Arun HR 53000 12% 2018 3.9 South 155
E007 Divya Finance 62000 15% 2019 4.6 East 175
E008 Vikram IT 71000 8% 2017 4.1 West 165
E009 Neha Sales 49000 10% 2020 4.3 North 130
E010 Kiran HR 54000 12% 2016 3.7 South 145
Super Bonus
Total Pay Tax Payable Tax Rate 15%
Bonus Multiplier 1.5
Super Bonus Rule if Rating Greater than 4
Region Region Multi
Prod_A Prod_B Prod_C Prod_D Prod_E Prod_F Prod_G Prod_H
Base Price 120 140 160 180 200 220 240 260
North 5%
South 10%
East 2%
West 10%
Central 5%
NE 2%
NW 2%
SE 10%
SW 5%
International 15%
Product Average Price
Prod_I Prod_J Region Average Price
280 300
RandomNumber EmpID Name Rating Target
EmpID Name Dept Salary Bonus% JoinYear Rating Region Target BonusRs.
E001 Asha Sales 45000 0.1 2018 4.2 North 120 4500
E002 Ravi HR 52000 0.12 2019 3.8 South 150 6240
E003 Meera Finance 61000 0.15 2017 4.5 East 180 9150
E004 John IT 70000 0.08 2020 4 West 160 5600
E005 Sana Sales 48000 0.1 2016 4.7 North 140 4800
E006 Arun HR 53000 0.12 2018 3.9 South 155 6360
E007 Divya Finance 62000 0.15 2019 4.6 East 175 9300
E008 Vikram IT 71000 0.08 2017 4.1 West 165 5680
E009 Neha Sales 49000 0.1 2020 4.3 North 130 4900
E010 Kiran HR 54000 0.12 2016 3.7 South 145 6480
Super Bonus
Total Pay
6750 56250
0 58240
13725 83875
0 75600
7200 60000
0 59360
13950 85250
8520 85200
7350 61250
0 60480

You might also like