The Final Project is worth 210 points; the final project will be broken down into six (6) parts as follows:
The October 9 payroll has been completed for you in the template. You will see the Payroll Register, and Journal in the template, this is color coded light green.
Part 1 (40 points) October 20th – November 4th on pages 7-11 and 7-12 in the template this is color coded yellow. Use Journal page 42.
Part 2 (40 points) November 6th – 18th on pages 7-12, 7-13 and 7-14 in the template this is color coded blue. Use Journal page 43.
Part 3 (25 points) November 20th and 30th on pages 7-14, 7-15 and 7-16 in the template this is color coded dark pink. Use Journal page 44.
Part 4 (35 points) December 3rd- 4th on pages 7-16 in the template this is color coded orange. Use Journal page 45. Part 5 (40 points) December 9th – 15th on page 7-17, in the template this is color coded tan. Use Journal page 46.
Part 6 (30 points) December 18th – February 1st on pages 7-17 through 7-20, in the template this is color coded Blue. Use Journal page 47.
Start by Downloading the template from Doc Sharing-you should be using the template called: Final Project Template 2012
This template is color coded by Project Part, the Payroll register and the journal match by color
You will complete the work on pages 7-1 through 7-19 (January 15th transaction) and the February 1st journal entries.
Read everything carefully-begin on page 7-2.
Pages 7-2 through 7-6 give the company information and the employee details
Read and trace the transactions for the October 9thPayroll that has been done for you (pages 7-7 through 7-10)
If you have questions-ask sooner rather than later, and attach your template s that I can see where you are.
Take your time and start early.
For each part of the payroll project you should complete the Journal, General Ledger, Payroll Register, and the Employee Earnings Record as applicable. When completing the Payrolls, complete the payroll register first, then transfer each employee’s amounts to the Employee Earnings Record, then complete the Journal entries applicable to the payroll, and then post to the general ledger.
You have payrolls for the following dates:
October 9 (this one has been done for you) October 23
In between the Payrolls are Journal entries that should be completed. The order to complete the work
1. Complete the Payroll first
2. Transfer the individual employee payroll data to the employee earnings record 3. Complete the General Journal
Be sure that when it says a deposit was made that you record it in the journal 4. Post to the General Ledger
Each Part of the project will be submitted separately for grading, you will submit the entire template, and the instructor will grade each part separately and award points based on completion and correctness. Be sure to look at the feedback provided by the instructor for corrections that may affect your ending balances.
Unit 8 consists of Parts 1-3, Unit 9 consists of Parts 4-6. There is a separate Dropbox for each part.
Some check figures to assist you:
October 9 (this one has been done for you)
Total Earnings: $14,162.77
Net Pay: $ 11,058.80 October 23
Total Earnings: $14,484.69
Net Pay: $ 11,131.63 November 6
Total Earnings: $ 14,130.48
Net Pay: $ 10,897.23 November 13
Total Earnings: $ 2,079.32
Net Pay: $ 1,412.13 November 20
Total Earnings: $ 12,640.23
Net Pay: $ 8,240.91 December 4
Total Earnings: $ 14,431.09
Net Pay: $ 9,722.77 December 14
Total Earnings: $ 1,425.16
Net Pay: $ 1,306.30 December 18
Total Earnings: $ 74,922.49 Net Pay: $ 39,367.66
The template has built in formulas to calculate some of the amounts, you will have some rounding, so if you are off by a few pennies, do not spend a lot of time looking for it, your instructor has been notified to give credit for rounding error in net pay of .10 or less.
Feel free to e-mail your instructor or post questions (not answers) in the virtual office about this recording.