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) Bonus c000

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
100%
Python
9:18
Assignment 3 - S4 uall släsll >
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)
Bonus
|1% of Average Sales
2% of Average Sales
4% of Average Sales
7% of Average Sales
AS<5000
50002AS<7500
75002AS<10000
AS210000
Sample Output
Employee Name
Average Sales
Bonus
==-==
AFRAH
8577.000
343.080
ASMA
6476.800
129.536
ATHEER
4943.000
49.430
HAJAR
MALLAK
MARYAM
NOORA
718.200
315.064
135.608
10260.000
7876.600
6780.400
8822.200
352.888
SAHAR
9126.800
365.072
7631.000
7580.400
SHEFAA
305.240
TAGHARID
303.216
===== === -==
=============
Transcribed Image Text:9:18 Assignment 3 - S4 uall släsll > 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) Bonus |1% of Average Sales 2% of Average Sales 4% of Average Sales 7% of Average Sales AS<5000 50002AS<7500 75002AS<10000 AS210000 Sample Output Employee Name Average Sales Bonus ==-== AFRAH 8577.000 343.080 ASMA 6476.800 129.536 ATHEER 4943.000 49.430 HAJAR MALLAK MARYAM NOORA 718.200 315.064 135.608 10260.000 7876.600 6780.400 8822.200 352.888 SAHAR 9126.800 365.072 7631.000 7580.400 SHEFAA 305.240 TAGHARID 303.216 ===== === -== =============
9:18
الصفاء الصبحي As signment 3 - S4
LeakageDeduction.py
Write a python program that calculates the salary deduction of an
employee who spills more petrol.
The program should accept previous reading, current reading and
quantity of petrol loaded in n number of petrol pumps. The petrol
price per gallon is fixed to OMR 0.180. The value of n must be
accepted as input.
The program must define and use a function to calculate the Leakage
quantity and deduction amount.
The Leakage quantity is calculated using the following formula:
Leakage = Quantity loaded - (Current Reading - Previous Reading)
The deduction amount is calculated by multiplying leakage with the
rate of petrol per gallon.
The company has declared not to deduct full amount from employee's
salary due to pandemic. Following table must be used to find the
actual salary deduction:
Deduction Amount (DA) Salary Deduction
10% of DA
20% of DA
DA<10
102DA<20
202DA<40
30% of DA
40% of DA
402DA<50
DA250
50% of DA
Sample Inputs and Output
====
Salary
Deduction
PR
CR
Deduction
Quantity Leakage
Loaded
Amount
1200
2000
2300
2250
4500
1300
2550
1600
250
45.000
13.500
0.900
3.600
50
9.000
3800
100
18.000
1400
2500
1300
200
36.000
14.400
2300
4000
2000
300
54.000
27.000
======
Sample Calculations
Previous
Quantity
Loaded
1300
Deduction
Salary
Deduction
Current
Petrol Pump Name
Difference
Leakage
Reading
Reading
Amount
Nizwa
1200
2250
1050
250
45.000
13.500
Ibri
2000
4500
2500
2550
50
9.000
0.900
Izki
2300
3800
1500
1600
100
18.000
3.600
Smail
1400
2500
1100
1300
200
36.000
14.400
Muscat
2300
4000
1700
2000
300
54.000
27.000
3
A. Marking Criteria
Transcribed Image Text:9:18 الصفاء الصبحي As signment 3 - S4 LeakageDeduction.py Write a python program that calculates the salary deduction of an employee who spills more petrol. The program should accept previous reading, current reading and quantity of petrol loaded in n number of petrol pumps. The petrol price per gallon is fixed to OMR 0.180. The value of n must be accepted as input. The program must define and use a function to calculate the Leakage quantity and deduction amount. The Leakage quantity is calculated using the following formula: Leakage = Quantity loaded - (Current Reading - Previous Reading) The deduction amount is calculated by multiplying leakage with the rate of petrol per gallon. The company has declared not to deduct full amount from employee's salary due to pandemic. Following table must be used to find the actual salary deduction: Deduction Amount (DA) Salary Deduction 10% of DA 20% of DA DA<10 102DA<20 202DA<40 30% of DA 40% of DA 402DA<50 DA250 50% of DA Sample Inputs and Output ==== Salary Deduction PR CR Deduction Quantity Leakage Loaded Amount 1200 2000 2300 2250 4500 1300 2550 1600 250 45.000 13.500 0.900 3.600 50 9.000 3800 100 18.000 1400 2500 1300 200 36.000 14.400 2300 4000 2000 300 54.000 27.000 ====== Sample Calculations Previous Quantity Loaded 1300 Deduction Salary Deduction Current Petrol Pump Name Difference Leakage Reading Reading Amount Nizwa 1200 2250 1050 250 45.000 13.500 Ibri 2000 4500 2500 2550 50 9.000 0.900 Izki 2300 3800 1500 1600 100 18.000 3.600 Smail 1400 2500 1100 1300 200 36.000 14.400 Muscat 2300 4000 1700 2000 300 54.000 27.000 3 A. Marking Criteria
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

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