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. 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 q This template is color coded by Project Part, the Payroll register and the journal match by color q 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. qPages 7-2 through 7-6 give the company information and the employee details qRead and trace the transactions for the October 9th Payroll that has been done for you (pages 7-7 through 7-10) qIf you have questions-ask sooner rather than later, and attach your template s that I can see where you are. qTake your time and start early. qFor 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. qYou have payrolls for the following dates: q October 9 (this one has been done for you) q October 23 q November 6 q November 13 q November 20 q December 4 q December 14 q December 18 In between the Payrolls are Journal entries that should be completed. The order to complete the workq 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.
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer