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
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
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
Related questions
Question
Using python language, using list and f’string.
![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
402DA<50
40% of DA
DA250
50% of DA
Sample Inputs and Output
==== ===== ==== ======
===== ==== ==== ===
==== ===== ==
Quantity Leakage
Loaded
Salary
Deduction
PR
CR
Deduction
Amount
==== ===== ===
========= ==
==== ===
==== ==== =====
1200
2250
1300
250
45.000
13.500
9.000
18.000
2000
4500
2550
50
0.900
2300
3800
1600
100
3.600
1400
2500
1300
200
36.000
14.400
2300
4000
2000
300
54.000
27.000
===== ===== ===== ===== ===== ===== ===== ===================
Sample Calculations
Current
Quantity
Loaded
Previous
Deduction
Salary
Deduction
Petrol Pump Name
Difference
Leakage
Reading
Reading
Amount
Nizwa
1200
2250
1050
1300
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc12f78b-3450-4285-9461-3b68f20cd3ae%2F46bb36af-e610-43ea-976c-53687a42b649%2Fojdjwcf_processed.jpeg&w=3840&q=75)
Transcribed Image Text: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
402DA<50
40% of DA
DA250
50% of DA
Sample Inputs and Output
==== ===== ==== ======
===== ==== ==== ===
==== ===== ==
Quantity Leakage
Loaded
Salary
Deduction
PR
CR
Deduction
Amount
==== ===== ===
========= ==
==== ===
==== ==== =====
1200
2250
1300
250
45.000
13.500
9.000
18.000
2000
4500
2550
50
0.900
2300
3800
1600
100
3.600
1400
2500
1300
200
36.000
14.400
2300
4000
2000
300
54.000
27.000
===== ===== ===== ===== ===== ===== ===== ===================
Sample Calculations
Current
Quantity
Loaded
Previous
Deduction
Salary
Deduction
Petrol Pump Name
Difference
Leakage
Reading
Reading
Amount
Nizwa
1200
2250
1050
1300
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
![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
==== =====
======](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc12f78b-3450-4285-9461-3b68f20cd3ae%2F46bb36af-e610-43ea-976c-53687a42b649%2Fkjxgzkv_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education