Write a python program that accepts name of an employee and employee's yearly sales of last five years. The data should be collected for n employees. The value of n should also be accepted as input. All amounts should be displayed with three decimal places. The output should be displayed as a table containing the Employee name, Average Sales and Bonus. The program must define and use a function with Total Sales as a parameter and should calculate the Average Sales and Bonus for cach employee. Bonus must be calculated based on the following table: Average Sales (AS) AS<5000 50002AS<7500 75002AS<10000 Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales AS210000

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
SalaryStmt.py
Write a python program that accepts name of an employee and
employee's yearly sales of last five years. The data should be
collected for n employees.
The value of n should also be accepted as input.
All amounts should be displayed with three decimal places.
The output should be displayed as a table containing the Employee
name, Average Sales and Bonus.
The program must define and use a function with Total Sales as a
parameter and should calculate the Average Sales and Bonus for
each employee. Bonus must be calculated based on the following
table:
Average Sales (AS)
AS<5000
5000ZAS<7500
7500ZAS<10000
AS210000
Bonus
1% of Average Sales
2% of Average Sales
4% of Average Sales
7% of Average Sales
Sample Output
Employee Name
Average Sales
Bonus
AFRAH
ASMA
ATHEER
НАЈAR
8577.000
6476.800
4943.000
343.080
129.536
49.430
718.200
315.064
135.608
352.888
365.072
305.240
303.216
10260.000
MALLAK
7876.600
6780.400
8822.200
9126.800
MARYAM
NOORA
SAHAR
SHEFAA
7631.000
TAGHARID
7580.400
Transcribed Image Text:SalaryStmt.py Write a python program that accepts name of an employee and employee's yearly sales of last five years. The data should be collected for n employees. The value of n should also be accepted as input. All amounts should be displayed with three decimal places. The output should be displayed as a table containing the Employee name, Average Sales and Bonus. The program must define and use a function with Total Sales as a parameter and should calculate the Average Sales and Bonus for each employee. Bonus must be calculated based on the following table: Average Sales (AS) AS<5000 5000ZAS<7500 7500ZAS<10000 AS210000 Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales Sample Output Employee Name Average Sales Bonus AFRAH ASMA ATHEER НАЈAR 8577.000 6476.800 4943.000 343.080 129.536 49.430 718.200 315.064 135.608 352.888 365.072 305.240 303.216 10260.000 MALLAK 7876.600 6780.400 8822.200 9126.800 MARYAM NOORA SAHAR SHEFAA 7631.000 TAGHARID 7580.400
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Function Arguments
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education