Print each employee, their wages, Hours and gross pay.

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

Write python code: 

**Title: Calculating Employee Wages Using Python Dictionaries**

This educational exercise involves writing a program that processes employee work data using one list and two dictionaries.

**Data Table:**

| Name   | Wage  | Hours |
|--------|-------|-------|
| Juan   | 7.50  | 35    |
| Rae    | 11.00 | 41    |
| Ivanna | 18.25 | 26    |
| Lilly  | 9.25  | 35    |
| Robert | 11.10 | 45    |

**Instructions:**

1. **List and Dictionaries:**
   - **Name** is a list containing employee names.
   - **Wage** and **Hours** are dictionaries mapping each employee's name to their wage rate and hours worked.

2. **Logic for Wage Calculation:**
   - An employee qualifies for overtime if they have worked more than 40 hours in a week.
   
3. **Formulas:**
   - **Overtime Pay:** 
     \[
     \text{Gross Pay} = (35 \times \text{Wage}) + ((\text{Hours} - 35) \times \text{Wage} \times 1.5)
     \]
   - **Regular Pay:** 
     \[
     \text{Gross Pay} = (\text{Hours} \times \text{Wage})
     \]

4. **Usage:**
   - Employees who work more than 35 hours should have their pay computed with the overtime formula.
   - Employees working 35 hours or less use the regular pay calculation.

5. **Implementation:**
   - Use a loop to iterate through the lists and calculate pay for each employee.
   - Print each employee's name, their wage, hours worked, and total gross pay.

This program helps in understanding dictionary manipulation and conditional logic in Python, providing a practical application of basic programming concepts.
Transcribed Image Text:**Title: Calculating Employee Wages Using Python Dictionaries** This educational exercise involves writing a program that processes employee work data using one list and two dictionaries. **Data Table:** | Name | Wage | Hours | |--------|-------|-------| | Juan | 7.50 | 35 | | Rae | 11.00 | 41 | | Ivanna | 18.25 | 26 | | Lilly | 9.25 | 35 | | Robert | 11.10 | 45 | **Instructions:** 1. **List and Dictionaries:** - **Name** is a list containing employee names. - **Wage** and **Hours** are dictionaries mapping each employee's name to their wage rate and hours worked. 2. **Logic for Wage Calculation:** - An employee qualifies for overtime if they have worked more than 40 hours in a week. 3. **Formulas:** - **Overtime Pay:** \[ \text{Gross Pay} = (35 \times \text{Wage}) + ((\text{Hours} - 35) \times \text{Wage} \times 1.5) \] - **Regular Pay:** \[ \text{Gross Pay} = (\text{Hours} \times \text{Wage}) \] 4. **Usage:** - Employees who work more than 35 hours should have their pay computed with the overtime formula. - Employees working 35 hours or less use the regular pay calculation. 5. **Implementation:** - Use a loop to iterate through the lists and calculate pay for each employee. - Print each employee's name, their wage, hours worked, and total gross pay. This program helps in understanding dictionary manipulation and conditional logic in Python, providing a practical application of basic programming concepts.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Top down approach design
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