Posted: November 2nd, 2015
The payroll accounting project is located in Chapter 7 of your textbook. Critical background data for the project is located on pages 7-1 through 7-6. The work begins on page 7-6 with the October 9 information. Look over this information in order to have an idea of the entirety of the project. Use the Excel spreadsheets to complete the project.
Read October and November payrolls in Chapter 7 and follow along in the project template. Complete December payroll and-end-of-year transactions in the the project file and then answer the questions in the questions file. Submit both files for grading.
|
Name: |
Alexandria Lowell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enter the appropriate numbers/formulas in the shaded (gray) cells. |
|
|
|
|
|
|
|
|
An asterisk (*) will appear to the right of an incorrect answer. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7-Q4 |
|
|
|
|
|
|
|
|
|
|
Student Work Area |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross |
|
Bonus |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Wages |
x |
Rate |
= |
Bonus |
|
|
|
|
|
|
|
|
|
Bonno |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ferguson |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ford |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mann |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ryan |
|
|
|
|
|
|
|
|
|
|
Instructor Comment/Grade Area |
|
|
Sokowski |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Student |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Woods |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Young |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Name: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enter the appropriate numbers/formulas in the shaded (gray) cells. |
|
|
|
|
|
|
|
|
|
|
An asterisk (*) will appear to the right of an incorrect answer. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7-Q5 |
|
|
|
|
|
|
|
|
|
|
|
Student Work Area |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calculation of accrued salaries and wages: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Biweekly |
|
Biweekly |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross |
|
14 Days’ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Earnings |
|
Accrual |
|
|
|
|
|
|
|
|
|
Administrative Salaries: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
O’Neill |
|
|
|
|
$ 2,307.70 |
* |
$ 2,307.70 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Instructor Comment/Grade Area |
|
|
Office Salaries: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ford |
|
|
|
|
$ 1,280.00 |
|
$ 1,844.80 |
* |
|
|
|
|
|
|
|
|
|
Student |
|
|
|
|
N/A |
|
1,120.00 |
* |
|
|
|
|
|
|
|
|
|
Woods |
|
|
|
|
1,200.00 |
|
1,200.00 |
* |
|
|
|
|
|
|
|
|
|
Zimmerman |
|
|
|
1,260.00 |
* |
1,260.00 |
* |
|
|
|
|
|
|
|
|
|
Total office salaries |
|
|
|
|
|
$ 5,424.80 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales Salaries: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ferguson |
|
|
|
$ 2,250.00 |
|
$ 3,150.16 |
* |
|
|
|
|
|
|
|
|
|
Mann |
|
|
|
|
1,350.00 |
|
1,151.70 |
* |
|
|
|
|
|
|
|
|
|
Young |
|
|
|
|
1,260.00 |
|
1,260.00 |
* |
|
|
|
|
|
|
|
|
|
Total sales salaries |
|
|
|
|
$ 5,561.86 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Plant Wages: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bonno |
|
|
|
|
N/A |
|
$ 1,976.80 |
|
|
|
|
|
|
|
|
|
|
Ryan |
|
|
|
|
N/A |
|
1,440.00 |
* |
|
|
|
|
|
|
|
|
|
Sokowski |
|
|
|
$ 2,050.00 |
|
2,050.40 |
* |
|
|
|
|
|
|
|
|
|
Total plant wages |
|
|
|
|
|
$ 5,467.20 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JOURNAL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DATE |
DESCRIPTION |
|
DEBIT |
|
CREDIT |
|
|
|
|
|
|
|
|
|
20– |
|
Adjusting Entry |
|
|
|
|
|
|
|
|
|
|
|
|
|
Dec. 31 |
Administrative Salaries |
|
|
2,307.70 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
Office Salaries |
|
|
|
5,424.80 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
Sales Salaries |
|
|
|
5,561.86 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
Plant Wages |
|
|
|
5,467.20 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
Salaries and Wages Payable |
|
|
|
18,761.56 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Name: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enter the appropriate numbers/formulas in the shaded (gray) cells. |
|
|
|
|
|
|
|
|
An asterisk (*) will appear to the right of an incorrect answer. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7-Q6 |
|
|
|
|
|
|
|
|
|
|
|
Student Work Area |
|
|
|
|
|
|
|
|
|
Rate or |
|
Accrued |
|
|
|
|
|
|
|
|
|
|
|
|
Vacation |
|
|
Bi-weekly |
|
Vacation |
|
|
|
|
|
|
|
|
|
|
|
|
Benefits |
|
|
Earnings |
|
Benefits |
|
|
|
|
|
|
|
|
Bonno |
|
|
80 |
hours |
|
|
|
$ 1,412.00 |
|
|
|
|
|
|
|
|
Ferguson |
|
|
3 |
weeks |
|
|
|
3,375.00 |
|
|
|
|
|
|
|
|
Ford |
|
|
|
2 |
weeks |
|
|
|
1,280.00 |
|
|
|
|
|
|
|
|
Mann |
|
|
|
1 |
week |
|
|
|
675.00 |
|
|
|
|
|
|
|
|
O’Neill |
|
|
4 |
weeks |
|
|
|
4,615.40 |
* |
|
|
|
|
|
|
|
Ryan |
|
|
|
80 |
hours |
|
|
|
1,440.00 |
|
|
Instructor Comment/Grade Area |
|
|
Sokowski |
|
|
2 |
weeks |
|
|
|
2,050.00 |
|
|
|
|
|
|
|
|
Student |
|
|
72 |
hours |
|
|
|
1,008.00 |
|
|
|
|
|
|
|
|
Woods |
|
|
– |
|
|
|
|
– |
|
|
|
|
|
|
|
|
Young |
|
|
– |
|
|
|
|
– |
|
|
|
|
|
|
|
|
Zimmerman |
|
– |
|
|
|
|
– |
|
|
|
|
|
|
|
|
Total |
|
|
|
|
|
|
|
$ 15,855.40 |
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JOURNAL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DATE |
DESCRIPTION |
|
DEBIT |
|
CREDIT |
|
|
|
|
|
|
|
|
20– |
|
Adjusting Entry |
|
|
|
|
|
|
|
|
|
|
|
|
Dec. 31 |
Vacation Benefits Expense |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Vacation Benefits Payable |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|