Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Database System Concepts
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
See similar textbooks
icon
Related questions
Question
Using list,f’string, write python language
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 ofn 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: Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales Average Sales (AS) AS<5000 50002AS<7500 75002AS<10000 AS210000 Sample Output ===== ===== ===== Employee Name Average Sales Bonus ==== ==== ==== ====== ====== AFRAH ASMA 8577.000 343.080 6476.800 129.536 49.430 718.200 ATHEER 4943.000 HAJAR 10260.000 315.064 135.608 MALLAK 7876.600 MARYAM 6780.400 NOORA 8822.200 352.888 SAHAR 9126.800 365.072 SHEFAA 7631.000 305.240 TAGHARID 7580.400 303.216 ==== ===== ======
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 ofn 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: Bonus 1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales Average Sales (AS) AS<5000 50002AS<7500 75002AS<10000 AS210000 Sample Output ===== ===== ===== Employee Name Average Sales Bonus ==== ==== ==== ====== ====== AFRAH ASMA 8577.000 343.080 6476.800 129.536 49.430 718.200 ATHEER 4943.000 HAJAR 10260.000 315.064 135.608 MALLAK 7876.600 MARYAM 6780.400 NOORA 8822.200 352.888 SAHAR 9126.800 365.072 SHEFAA 7631.000 305.240 TAGHARID 7580.400 303.216 ==== ===== ======
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Introduction to computer system
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.
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
SEE MORE TEXTBOOKS