AutoSave C Home Insert Draw Page Layout Formulas G X Calibri (Body) 12 Paste B I U A C21 fx B Data Review View Automate MyEducator-Add-in.xlsx - Read-Only Tell me General $ % 9 0 .00 0 .00 Conditional Format Formatting as Table Styles Cell O M 1 Comments Share Insert me Delete Format Sort & Filter Find & Select Sensitivity Analyze Data Tasks A D E F G H | J K L M N O P 1 2 Employee Information Model Assumptions 3 Hours Worked 4 Pay Rate 85 $30.00 # regular hours in Pay Period 80 5 Marital Status Married # of paychecks per year 26 6 # of Allowances 2 Rate Federal Tax Rate Tables "Single" Tax Rate Income "Married" Tax Rate Income Rate 7 Retirement Savings % 5% 8 Health Insurance (every paycheck) $125.00 Payroll Tax information Medicare Rate $0 10% $0 10% 1.45% $725 15% $1,450 15% 9 Flexible Spending (Annual) $1,500.00 Social Security Rate 4.2% $2,945 25% $5,891 25% 10 11 Paycheck Summary Income Tax Information 12 Gross Pay $0.00 Allowance Deduction $146 $7,137 28% $14,887 33% $32,362 35% $11,891 28% $18,120 33% $32,362 35% 13 Total Deductions $0.00 State Tax Rate 5% 14 Adjusted Income $0.00 15 Total Taxes $0.00 16 17 Net Pay $0.00 18 19 Paycheck Calculations 20 Income 21 Hours Worked 22 Pay Rate 23 Regular Pay 24 Overtime Pay 25 Total Gross Pay 26 27 28 Deductions (Items not subject to income tax) Insurance 29 Flexible Spending 30 Retirement 31 Total Deductions 32 33 Adjusted Income 34 35 Taxes 36 Federal Income Tax Rate 37 Federal Income Tax 38 Adjustment for Allowances 39 Net Federal Income Tax 40 State Income Tax 41 Medicare Tax Ready Pricing Paycheck Accessibility: Investigate + MyEducator Tasks 1.1 Enter the hours worked and the pay rate for the employee into the Paycheck Calculations section of the model. a. Reference the hours worked (C3)) and pay rate (C4)) values in the "Employee Information" area of the sp Font Size et model. 2 1.2 Calculate the regular pay. a. Reference cell C21) for the "Hours Worked". b. The regular pay will be the hours worked times the pay rate unless the employee works overtime (more than the number of regular hours in the pay period - described in the model assumptions). c. If the employee works overtime, the regular pay is the rate times the number regular hours in the pay period. 3 1.3 Calculate the overtime pay. a. Reference cell C21) for the "Hours B + 100% 0%