Payroll Accounting Unit3 Assignment Part 1

u3ass1_template2-2a.xlsx

2-2A

Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells.
An asterisk (*) will appear to the right of an incorrect answer.
2-2A
Minimum Weekly Wages
Rate	x	Hours	=
(a)			Mark Sears: Enter as a formula of rate x hours		$2.13	40	$ 85.20

(b)		Minimum weekly wages		85.20
	Weekly wage regulary paid		80.00
Mark Sears: Enter as a formula		Additional weekly wage due	$ 5.20
Also, in order to pay just the minimum amount for a 40-hour
week, the employee must receive the following in tips:
	Weekly minimum wage (nontipped)	$ 290.00
	Minimum weekly wage (tipped)	85.20
Mark Sears: Enter as a formula		Required tips	$ 204.80 Mark Sears: Enter as a formula