Eric is the president and chief executive officer of his own management consulting firm. He has five employees: Jon Jones, Lupe Bana, Austin Pei, Diane Driscoll, and Yu Chung Wright. Selected information for each employee is listed in the table below:
Employees have three kinds of taxes withheld from their wages: federal income, state income, and Social Security. Social Security is withheld from all employees at 9.75 percent of their gross pay. Single employees have federal income tax withheld at a base rate of $200 plus $50 for each withholding allowance; married employees’ federal tax withholding is $150 plus $25 for each withholding allowance. State income tax is withheld at 30 percent of the federal amount for each employee. Employees are paid every two weeks and receive 1.5 times their regular hourly wage for any hours in excessof 80. In addition, Jon and Austin contribute $50 each pay period to an employee pen-sion fund; Lupe and Diane contribute $75 each pay period for group health insurance. Using Access or Excel, prepare a payroll register based on the preceding data. Then, prepare a report for Eric that shows the average gross pay and the average hourly wage for all five employees. Finally, prepare a pie-chart graph for each employee showing the breakdown of gross pay into each amount withheld and net pay. (An example for Jon is shown below.)
Answer to relevant QuestionsPoint your Web browser to the text’s new blog: bobhurtais.blogspot.com. Read the post titled Critical Thinking (dated 27 February 2011). Generate one question at each level of Bloom’s taxonomy for learning objective 4 ...a. What is information overload? What causes it? What are its effects? How can decision makers deal with information overload in their professional lives? b. Explain the idea of knowledge management. Why is it important? ...a. How would a knowledge management system facilitate knowledge sharing? b. What sources of information overload are accountants likely to experience? What strategies would you recommend for addressing them? c. Use ...Please indicate whether each of the following statements is (i) always true, (ii) sometimes true, or (iii) never true. For those that are (ii) sometimes true, explain when the statement is true. a. Legal behavior is the same ...Determine whether each of the following statements is (i) always true, (ii) sometimes true, or (iii) never true. For those that are (ii) sometimes true, explain when the statement is true. a. A disclaimed audit opinion means ...
Post your question