Sample Calculations Previous Current Quantity Deduction Salary Deduction 13.500 0.900 Petrol Pump Name Difference Leakage Reading Loaded Amount 250 50 45.000 Reading Nizwa 1200 2250 1050 1300 Ibri 2000 4500 2500 2550 9.000 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

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%
Using list, f’string, write python language
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
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
Expert Solution
steps

Step by step

Solved in 3 steps

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