
Prepare the New Pharmacy payroll record with the following columns: employee name, number of hours worked, hourly wage, weekly gross wage, social security discount, Medicare discount, amount of state taxes and savings of retirement.
Calculate the gross salary of each employee.
Calculate the amount withholding from Social Security and Medicare.
Calculate the net pay for each employee.
Jornalize the entry to record the payroll.
The New Pharmacy pays for overtime hours and a half. It does not pay overtime to employees who are paid by salary. The company has 10 employees and the information on the hours worked is as follows:
Employee Name |
Hours worked |
Hourly wage |
Weekly salary |
Payment of retirement |
Union Payment |
Juan del Pueblo |
43 |
$8.50 |
$21.93 |
$15 |
|
Ramonita Ramírez |
41 |
11.50 |
$37.12 |
Managerial, does not pay fee. |
|
Brenda Montalvo |
55 |
$1,100 |
$88.00 |
Managerial, does not pay fee. |
|
Camilo Monge |
40 |
7.25 |
$23.02 |
15 |
|
Jorge Emmanueli |
46 |
25.00 |
$92.00 |
15 |
|
Mariel Estrada |
60 |
10.00 |
$48.00 |
15 |
|
Emanuel Reyes |
40 |
8.00 |
$25.60 |
15 |
|
Ernesto Ramírez |
40 |
8.25 |
$26.40 |
15 |
|
Daniela Morales |
38 |
10.75 |
$32.68 |
15 |
|
Ángel Carrasquillo |
43 |
$860 |
$68.80 |
Managerial, does not pay fee. |

Trending nowThis is a popular solution!
Step by stepSolved in 3 steps

- The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 Answer is complete but not entirely correct. Union Dues per Period Garnishment per Period S Pay $ 1,810 $ 3,720 $ 3,445 $ 3,070 $ S 120 240 $ $ 50 75 100 $ $ S $ Net Pay 1,489.02 2,906.45 x 2,575.44X 2.425.43arrow_forwardAssume that you are working with a payroll application that produces weekly paychecks, including paystubs. Listed below are 20 data elements that would appear on the paycheck/paystub. For each numbered item, indicate the immediate (versus ultimate) source of the item. For instance, the immediate source of the number of exemptions for an employee would be the employee master data, as opposed to the ultimate source, which is the W-4 form filed by the employee. Some items may have more than one source, as in the case of item 1. You have the following choices: Arrange your answer as follows: The items to be considered are as follows:arrow_forwardRecord the journal entries for each of the following payroll transactions. If an amount box does not require, leave it blank. Apr. 2 Paid $600 and $310 cash to a federal depository for FICA Social Security and FICA Medicare, respectively. Apr. 4 Paid accumulated employee salaries of $16,220. Apr. 11 Issued checks in the amounts of $480 for federal income tax and $300 for state income tax to an IRS-approved bank. Apr. 14 Paid cash to health insurance carrier for total outstanding health insurance liability of $700. Apr. 22 Remitted cash payments for FUTA and SUTA to federal and state unemployment agencies in the amounts of $130 and $250, respectively. Apr. 2 fill in the blank 2 fill in the blank 3 fill in the blank 5 fill in the blank 6 fill in the blank 8 fill in the blank 9 Apr. 4 fill in the blank 11 fill in the blank 12 fill in the blank 14 fill in the blank 15 Apr. 11 fill in the blank 17 fill in the blank 18 fill in the blank 20…arrow_forward
- The payroll register of Seaside Architecture Company indicates $910 of social security and $251 of Medicare tax withheld on total salaries of $15,500 for the period. Federal withholding for the period totaled $3,250. Required: Prepare the journal entry for the period’s payroll. Refer to the Chart of Accounts for exact wording of account titles. Chart Of Accounts CHART OF ACCOUNTS Seaside Architecture Company General Ledger ASSETS 110 Cash 111 Accounts Receivable 112 Interest Receivable 113 Notes Receivable 115 Merchandise Inventory 116 Supplies 118 Prepaid Insurance 120 Land 123 Building 124 Accumulated Depreciation-Building 125 Office Equipment 126 Accumulated Depreciation-Office Equipment LIABILITIES 210 Accounts Payable 213 Interest Payable 214 Notes Payable 221 Salaries Payable 222 Social Security Tax Payable 223 Medicare Tax Payable 224 Employees Federal Income Tax Payable…arrow_forwardThis problem continues the process of preparing the Kipley Company's Employee Payroll Register for the pay period ending January 8th, 20--. In previous chapters, gross wages were computed for each employee and using this data, FICA withholding and employer FICA liability was computed. Requirements: Refer to the SIMPLE Plan Contributions and enter each employee's SIMPLE plan deduction. Determine and record the federal income taxes for each employee. Determine and record the state income taxes for each employee. Determine and record the city income taxes for the city of Pittsburgh. Total each input column. Below lists each employee's assigned Time Card No., Filing Status, and Withholding Allowances. This information is necessary when determining the amount of tax to withhold. TimeCard No. EmployeeName FilingStatus No. ofWithholdingAllowances 11 Fran M. Carson S N/A 12 William A. Wilson S N/A 13 Harry T. Utley MFJ N/A 21 Lawrence R. Fife MFJ N/A 22 Lucy K. Smith S N/A…arrow_forwardThe payroll register of Heritage Co. indicates $3,900 of social security withheld and $975 of Medicare tax withheld on total salaries of $65,000 for the period. Federal withholding for the period totaled $14,250. Retirement savings withheld from employee paychecks were $2,600 for the period. Journalize the entry to record the period’s payroll. Refer to the Chart of Accounts for exact wording of account titles. CHART OF ACCOUNTS Heritage Co. General Ledger ASSETS 110 Cash 111 Accounts Receivable 112 Interest Receivable 113 Notes Receivable 115 Inventory 116 Supplies 118 Prepaid Insurance 120 Land 123 Building 124 Accumulated Depreciation-Building 125 Office Equipment 126 Accumulated Depreciation-Office Equipment LIABILITIES 210 Accounts Payable 213 Interest Payable 214 Notes Payable 215 Salaries Payable 216 Social Security Tax Payable 217 Medicare Tax Payable 218 Employees Federal Income Tax Payable 219…arrow_forward
- Journalize the payroll on March 15, and the accrual of employee payroll taxesarrow_forwardCalculate the Medicare for the following employee, Agwali, whose cumulative earnings up to this pay period are $109,200 and gross pay for the pay period is $12,500. Round to the nearest penny; do not include the $ sign. Numeric Responsearrow_forwardJournalize the February payroll and the payment of the payroll. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit Feb. 28 (To record payroll.) (To record payment of payroll.) Feb. 28arrow_forward
- Exercise 5.1 (Algo) Calculating adjustments. LO 5-2 On June 1, 20X1, Keller Company, a new firm, paid $5,280 rent in advance for a six-month period. The $5,280 was debited to the Prepaid Rent account. On June 1, 20X1, the firm bought supplies for $7,350. The $7,350 was debited to the Supplies account. An inventory of supplies at the end of June showed that items costing $3,000 were on hand. On June 1, 20X1, the firm bought equipment costing $57,600. The equipment has an expected useful life of 10 years and no salvage value. The firm will use the straight-line method of depreciation. Prepare end-of-June adjusting entries for Keller Company. - Prepare the adjusting entry for prepaid rent. - Prepare the adjusting entry for supplies. - Prepare the adjusting entry for depreciation.arrow_forwardAn error was found on Jocelyn's bi - weekly pay cheque. When she brought it to the attention of the Payroll Department, they realized that they had underpaid her by $203.60 so they issued her a separate payment in the same pay period. Calculate the Canada Pension Plan contribution for this separate paymentarrow_forwardThis problem continues the computing and recording employee payroll for the Olney Company for the pay period ending January 8th, 20--. Tasks previously performed include determining gross earnings, FICA withholding, federal, state and city taxes. These computations are shown in the Employee Payroll Register. Requirements: Compute and record the employee's SUTA contributions. Compute and record the Olney Company's SUTA and FUTA contributions. Payroll Register The State Unemployment Tax Act, better known as SUTA, is a form of payroll tax that all states require employers to pay for their employees. SUTA is a counterpart to FUTA, the federal unemployment insurance program. Your tasks now are to compute FUTA and SUTA. Complete the following step: Compute and record the employee's SUTA contributions (employees pay 0.06% on total gross pay). Note: Round your final answers to nearest cent. ONLEY COMPANY, INC.Employee Payroll Register For Period Ending January 8, 20-- EARNINGS…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





