ur employees work in a company: Ahmed, Zaid, Jassem, and Kazem. They receiv monthly salary of: 1500 dollars, 2000 dollars, 1750 dollars and 2100 dollar pectively. The sales achieved by each employee in each quarter of the year were a own in the table below: Name Ahmed Zaid Jassem Kazem First quarter 400 200 400 100 Second quarter 200 100 450 150 Third quarter 350 500 550 210 Fourth quarter 250 600 650 230 e company's manager decided: If the sales achieved by each employee per mont between (1,000-1,300) dollars, then he gives him an additional salary of 2% of h ary. If the sales are between (1,300-1,500) dollars, he will give 3% of his salary.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
i need the answer quickly
Four employees work in a company: Ahmed, Zaid, Jassem, and Kazem. They receive
a monthly salary of: 1500 dollars, 2000 dollars, 1750 dollars and 2100 dollars,
respectively. The sales achieved by each employee in each quarter of the year were as
shown in the table below:
Name
Ahmed
Zaid
Jassem
Kazem
First
quarter
400
200
400
100
Second
quarter
200
100
450
150
Third
quarter
350
500
550
210
Fourth
quarter
250
600
650
230
The company's manager decided: If the sales achieved by each employee per month
are between (1,000-1,300) dollars, then he gives him an additional salary of 2% of his
salary. If the sales are between (1,300-1,500) dollars, he will give 3% of his salary. If
sales equal or more than 1,500, 5% will be given. Using excel sheet to make the
calculations.
Transcribed Image Text:Four employees work in a company: Ahmed, Zaid, Jassem, and Kazem. They receive a monthly salary of: 1500 dollars, 2000 dollars, 1750 dollars and 2100 dollars, respectively. The sales achieved by each employee in each quarter of the year were as shown in the table below: Name Ahmed Zaid Jassem Kazem First quarter 400 200 400 100 Second quarter 200 100 450 150 Third quarter 350 500 550 210 Fourth quarter 250 600 650 230 The company's manager decided: If the sales achieved by each employee per month are between (1,000-1,300) dollars, then he gives him an additional salary of 2% of his salary. If the sales are between (1,300-1,500) dollars, he will give 3% of his salary. If sales equal or more than 1,500, 5% will be given. Using excel sheet to make the calculations.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY