$1\mathrm{.}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 $(($C$3)$ and pay rate $($C$4)$ values in the "Employee Information" area of the spreadsheet model.

$(2)$

$1\mathrm{.}2$ Calculate the regular pay.

a$.$ Reference cell 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.