Comments A A ab v Sha Conditional Formatting Paste B I UVV UVA v Format as Table TE Number Cell Styles Cells Editing Add-ins Analyz C24 x v fx Data B C D E G H Function: SUM; Formula: Subtract, Multiply; Cell Referencing M Using Excel to Calculate Payroll Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input Susan Little's is paid time and a half for work over 40 hours per the required mathematical formulas or functions with cell references to the week. Susan's Information for the pay period ending March 16 is Problem area or work area as indicated. provided here. Regular hours worked each week 40 a . Calculate Susan's gross and net pay for the pay period. Hours worked week ending March 16 48 Regular hourly wage rate S 18.00 Regular pay 47.34 Overtime pay CPP deductions 14.79 Gross pay El deductions 186.00 Income tax withholdings Net pay b. What are Susan's employer's costs for CPP, El, and income tax? Employer's costs