Cookie Kingdom Shop Home Office Payroll Prepared by: \begin{tabular}{|l|r|} \hline Fed Tax Rate: & 0.2 \\ \hline SS Tax Rate: & 0.1 \\ \hline State Tax Rate: & 0.0 \\ \hline Overtime Rate: & 1.50 \\ \hline \end{tabular} Part 2: What-If Analysis Answer each question below by modifying values in your worksheet. After finding the answer to each question, reset your worksheet values back to their original value. 1. If the Overtime Rate is changed to 2 times the Regular Rate, how many employees would earn a Net Pay more than $400 ? What is the total Net Pay for all employees? 2. If the Federal Tax Rate increases to 23%, how many employees earn Net Pay of more than $400? 3. Michael Dillon's boss is considering giving him a pay raise to $13.75 an hour. By how much would his Gross Pay change? Net Pay? Cookie Kingdom Shop Home Office Payroll Prepared by: \begin{tabular}{|l|r|} \hline Fed Tax Rate: & 0.2 \\ \hline SS Tax Rate: & 0.1 \\ \hline State Tax Rate: & 0.0 \\ \hline Overtime Rate: & 1.50 \\ \hline \end{tabular} Part 2: What-If Analysis Answer each question below by modifying values in your worksheet. After finding the answer to each question, reset your worksheet values back to their original value. 1. If the Overtime Rate is changed to 2 times the Regular Rate, how many employees would earn a Net Pay more than $400 ? What is the total Net Pay for all employees? 2. If the Federal Tax Rate increases to 23%, how many employees earn Net Pay of more than $400? 3. Michael Dillon's boss is considering giving him a pay raise to $13.75 an hour. By how much would his Gross Pay change? Net Pay