I need help with the following questions refering to the image below.The information for Titan Company, shown in following chart, is available from Titan's time records and the employee's individual earnings records for the pay period ended December 22.1. Complete the payroll register using a Social Security tax rate of 6.2 percent and a Medicare tax rate of 1.45 percent. Concerning Other Deductions, AR refers to Accounts Recievable and UW refers to United Way. Begin payroll checks in the payroll register with No. 2914.2. Prepare the general journal entry to record the payroll. The firm's general ledger contains a Salary Expense account and a Salaries Payable account.3. Prepare the general journal entry to pay the payroll. Assume that funds for this payroll have been transferred to Cash-Payroll Bank Account and that this entry has been made. ### Payroll Data for EmployeesThis table provides a detailed breakdown of the weekly earnings and deductions for several employees. The columns include the employee's name, hours worked, earnings at the end of the previous week, total earnings for the current period, the class they belong to, federal income tax deductions, and other deductions.| Name | Hours Worked | Earnings at End of Previous Week | Total Earnings | Class | Federal Income Tax | Other Deductions ||------------|--------------|----------------------------------|----------------|--------|--------------------|------------------|| Albee, C. | 44 | 63,340.00 | 1,650.00 | Sales | 193.37 | UW 25.00 || Don, V. | 40 | 136,410.00 | 2,841.00 | Sales | 487.03 | AR 95.00 || Fine, J. | 40 | 76,860.00 | 1,507.00 | Sales | 171.92 | UW 25.00 || Ginny, N. | 46 | 33,590.00 | 660.00 | Office | 46.00 | UW 35.00 || Johnson, J.| 47 | 56,980.00 | 1,117.00 | Office | 113.00 | UW 25.00 || Lund, D. | 43 | 116,600.00 | 2,100.00 | Sales | 301.78 | UW 20.00 || Maya, R. | 42 | 66,860.00 | 1,310.00 | Sales | 143.00 | AR 70.00 || Nord, P. | 41 | 36,750.00 | 720.00 | Sales | 55.00 | UW 20.00 || Oscar, T. | 43 | 93,480.00 | 1,832.00 | Sales | 234.78 | UW 25.00 || Troy, B. |

Payroll refers to the total amount that is required to be paid by the company to its employees…

Answered: Earnings at End of Federal Hours…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

I need help with the following questions refering to the image below.

The information for Titan Company, shown in following chart, is available from Titan's time records and the employee's individual earnings records for the pay period ended December 22.

1. Complete the payroll register using a Social Security tax rate of 6.2 percent and a Medicare tax rate of 1.45 percent. Concerning Other Deductions, AR refers to Accounts Recievable and UW refers to United Way. Begin payroll checks in the payroll register with No. 2914.

2. Prepare the general journal entry to record the payroll. The firm's general ledger contains a Salary Expense account and a Salaries Payable account.

3. Prepare the general journal entry to pay the payroll. Assume that funds for this payroll have been transferred to Cash-Payroll Bank Account and that this entry has been made.

### Payroll Data for Employees

This table provides a detailed breakdown of the weekly earnings and deductions for several employees. The columns include the employee's name, hours worked, earnings at the end of the previous week, total earnings for the current period, the class they belong to, federal income tax deductions, and other deductions.

| Name | Hours Worked | Earnings at End of Previous Week | Total Earnings | Class | Federal Income Tax | Other Deductions |
|------------|--------------|----------------------------------|----------------|--------|--------------------|------------------|
| Albee, C. | 44 | 63,340.00 | 1,650.00 | Sales | 193.37 | UW 25.00 |
| Don, V. | 40 | 136,410.00 | 2,841.00 | Sales | 487.03 | AR 95.00 |
| Fine, J. | 40 | 76,860.00 | 1,507.00 | Sales | 171.92 | UW 25.00 |
| Ginny, N. | 46 | 33,590.00 | 660.00 | Office | 46.00 | UW 35.00 |
| Johnson, J.| 47 | 56,980.00 | 1,117.00 | Office | 113.00 | UW 25.00 |
| Lund, D. | 43 | 116,600.00 | 2,100.00 | Sales | 301.78 | UW 20.00 |
| Maya, R. | 42 | 66,860.00 | 1,310.00 | Sales | 143.00 | AR 70.00 |
| Nord, P. | 41 | 36,750.00 | 720.00 | Sales | 55.00 | UW 20.00 |
| Oscar, T. | 43 | 93,480.00 | 1,832.00 | Sales | 234.78 | UW 25.00 |
| Troy, B. |

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions