Answered

b) Add a "Tax (%)" column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that need to be deducted. For someone who makes [tex]$\$[/tex]9.00[tex]$ or less an hour, the rate is $[/tex]5\%[tex]$. For someone who makes between $[/tex]\[tex]$9.01$[/tex] and [tex]$\$[/tex]15.00[tex]$ an hour, the rate is $[/tex]10\%[tex]$. For someone who makes more than $[/tex]\[tex]$15.00$[/tex] an hour, the rate is [tex]$15\%$[/tex].

\begin{tabular}{|l|l|l|l|l|l|l|}
\hline
\textbf{Employee Name} & \textbf{Pay/Hour} & \textbf{Total Hours} & \textbf{Overtime Hours} & \textbf{Total Overtime} & \textbf{Gross Pay} & \textbf{Tax (\%)} \\
\hline
\end{tabular}



Answer :

GinnyAnswer
Alright class, let's go through this step by step.

### Step-by-step Solution

1. Understanding the Problem:
To add a "Tax (%)" column, we need to determine the applicable tax rate based on the employee's hourly wage. From the problem:
- If the pay per hour is [tex]$9.00 or less, the tax rate is 5%. - If the pay per hour is between $[/tex]9.01 and [tex]$15.00, the tax rate is 7%. - For anything above $[/tex]15.00, the tax rate is 10%.

2. Employee Details:
We have the following employees and their respective details:
- Alice: [tex]$8.5 per hour - Bob: $[/tex]10 per hour
- Charlie: [tex]$12 per hour 3. Determining the Tax Rate: Let's determine the tax rate for each employee based on their hourly wage: - Alice: - Pay per hour: $[/tex]8.5
- Since [tex]$8.5 ≤ $[/tex]9.00, the tax rate is 5%.

- Bob:
- Pay per hour: [tex]$10 - Since $[/tex]9.01 ≤ [tex]$10 ≤ $[/tex]15.00, the tax rate is 7%.

- Charlie:
- Pay per hour: [tex]$12 - Since $[/tex]9.01 ≤ [tex]$12 ≤ $[/tex]15.00, the tax rate is 7%.

### Completed Table

Here is the table with the added "Tax (%)" column:

| Employee name | Pay/hour | Total hours | Overtime hours | Total Overtime | Gross pay | Tax (%) |
|---------------|----------|-------------|----------------|----------------|-----------|---------|
| Alice | [tex]$8.5 | 40 | 5 | - | - | 5% | | Bob | $[/tex]10 | 38 | 7 | - | - | 7% |
| Charlie | $12 | 50 | 10 | - | - | 7% |

### Conclusion

We have successfully determined the tax rate for each employee and added the "Tax (%)" column to the table. Alice has a tax rate of 5%, while Bob and Charlie both have a tax rate of 7%.