Function: SUM; Formula: Subtract, Multiply; Cell Referencing

Using Excel to Calculate Payroll Amounts

PROBLEM

Betsy Strand's payroll information is provided here.

Regular hourly wage rate

Hourly rate for work in excess of $40$ hours

Hours worked during a January pay period

Federal income tax withholding

FICA tax rate

Betsy has no voluntary deductions

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as appropriate. Use the SUM function to add any necessary amounts.

Compute Betsy Strand's gross earnings and net pay for the pay period.

Gross earnings:

Regular pay

Overtime pay

Total gross earnings

Gross earnings

FICA taxes withheld

Federal income taxes withheld

Net pay