Complete and submit the Practical Problems (A) 1-9, 13, 15 and 16. This is your homework
assignment. When you receive the solutions, review your work.
1
2
3
4
5
6
7
8
9
13
See the attachment
15
See the attachment
1/21, 2/4, 2/18, 3/4, 3/18, 4/3
16
1) 4/15
Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the following e
Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the following e
Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the following e
Excel Instructions using Excel 2010 or 2013:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the fol
Excel Instructions using Excel 2010:
CAUTION: Read Appendix B for specific instructions relating to these templates.
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
2.
Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the following e
Questions for Review
1. Fair Labor Standards Act, (current rate $7.25)
2. Records that explain the basis of wage differentials paid to employees of opposite sex for equal
work.
3. The employer pays the tax. Half is from employees wages half from employer.
Matching Quiz
1 B
2 D
3 F
4 A
5 H
6 I
7 J
8 C
9 E
10 F
Discussion
1 -If you hire employees, your record keeping capacity needs to be advanced enough to comply with
numerous local, state, and federal payroll and personnel legal requirements. If your record
Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the following e
Excel Instructions using Excel 2010:
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answe
2. A formula begins with an equals sign (=) and can consist of any of the following e
Problem 3-2A is a great problem for learning how to use the wage base for calculating
OASDI tax.
32A.
(a)
(b)
(c)
9th paycheck.
$98.60
17th paycheck (only $1,300 is taxableOASDI).
24th paycheck.
OASDI
$421.60
HI
303.80
0
She gets paid the $6,800 twice a m
Problem 4-1B
Name: Melissa O'Neal
Section:
Score:
100%
Key Code: [Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the ri
Problem 5-1B
Name:
Section:
Melissa O'Neal
Score:
100%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the le
Problem 2-3B
Name: Melissa O'Neal
Section:
Score:
78%
Key Code: 2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Enter the appropriate amounts/formulas in the answer
Problem 1-2A
Name: Melissa O'Neal
Section:
Score:
100%
Key Code: 2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Enter the appropriate amounts/formulas in the answe
Problem 3-5B
Name: Melissa O'Neal
Section:
Score:
99%
Key Code: 2
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incor