Details of this Paper

Kaplan AC122 Payroll final project

Description

solution


Question

Question;Welcome to your Homework Assistance video for;Units 8 and 9. In Units 8 & 9 you are working on completing the final;project for the class. In this video, you will be reviewing the steps required;for this project.;Chapter 7 of the text is a comprehensive Payroll;Project that should be completed by you to demonstrate understanding of the;material covered in Chapters 1-6. 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.;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.;Page 1 of 3;Unit 8 & 9 [122: Payroll Accounting];q VERY IMPORTANT!;q Read everything carefully-begin on page 7-2.;q Pages 7-2 through 7-6 give the company;information and the employee details;q Read and trace the transactions for the October 9th Payroll that has been done for you (pages 7-7;through 7-10);q If you have questions-ask sooner rather than;later, and attach your template s that I can see where you are.;q Take your time and start early.;q 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.;q You 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;q 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;Complete the General Journal;? Be sure that when it says a deposit was made that;you record it in the journal;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);Page 2 of 3;Unit 8 & 9 [122: Payroll Accounting];? 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.

 

Paper#39842 | Written in 18-Jul-2015

Price : $52
SiteLock