Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area Betsy Strand's payroll information is provided here. or work area as appropriate. Use the SUM function to add any necessary amounts. Regular hourly wage rate Hourly rate for work in excess of 40 hours Hours worked during a January pay period Federal income tax withholding 24 16.00 %24 24.00 47 $ 95.00 Compute Betsy Strand's gross earnings and net pay for the pay period. FICA tax rate 7.65% 2 3 Betsy has no voluntary deductions. Gross earnings: Regular pay 14 15 16 Overtime pay 17 Total gross earnings 18 19 Gross earnings FICA taxes withheld 2$ 20 21 22 Federal income taxes withheld 23 24 Net pay 25

Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area Betsy Strand's payroll information is provided here. or work area as appropriate. Use the SUM function to add any necessary amounts. Regular hourly wage rate Hourly rate for work in excess of 40 hours Hours worked during a January pay period Federal income tax withholding 24 16.00 %24 24.00 47 $ 95.00 Compute Betsy Strand's gross earnings and net pay for the pay period. FICA tax rate 7.65% 2 3 Betsy has no voluntary deductions. Gross earnings: Regular pay 14 15 16 Overtime pay 17 Total gross earnings 18 19 Gross earnings FICA taxes withheld 2$ 20 21 22 Federal income taxes withheld 23 24 Net pay 25

Accounting Information Systems

11th Edition

ISBN:9781337552127

Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill

Publisher:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill

Chapter14: The Human Resources (hr) Management And Payroll Processes

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

Concerning payroll accounting - What is the order of calculation on Quarter-hour method & Hundreth-hour method? For example: IN 8:08 OUT 11:57 IN 12:59 OUT 4:57 IN 9:04 OUT 12:17 IN 1:28 OUT 5:18 IN 7:45 OUT 11:45 IN 12:43 OUT 4:01 IN 7:57 OUT 12:04 IN 1:03 OUT 5:06 Thank you for your assistance. Jewelee Marple
Payroll Accounting Class (2301-900) Cengage - eBook Bieg/Toland's Payroll Accounting (2021, 31th Edition) Chapter 2 - Computing Wages and Salaries Chapter 2 - Continuing Problem 2B (Onley Company, Excel) I need help finishing the Total Amount (last fourcells) for Regular Earnings and I need all four columns for OT Earnings I will need the formula for the Amount and Total Earnings columns (example: =40*19.5) below I have attached the homework assignment and the information given
Task 2- Service providers1. Based on the company scenario provided above, research the suitability of at least four payroll software products, from different providers, for processing your payroll in-house. Next research the suitability of at least four payroll service providers if you were to consider outsourcing your payroll. You are required to provide a short summary of the providers you have suggested. 2. Research and explain the different payroll lifecycle and software packages selected for two different organisations, one processing payroll for 20,000 employees and another processing payroll for 200 employees, both having a monthly pay frequency. (i) Explain your decision and an estimation of the costs relating to monetary value and time?● Include in your response to this task how you would manage the provider/customer and other stakeholder relationships necessary to influence successful payroll outcomes including delivery, customer care and enquiry handling. Identify the risks…
Question Content Area Continuing Payroll Problem: Chapter 3 As you learned in the previous chapter, Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. In the last chapter, gross wages were computed for each employee. Adjacent to their name, each employee's gross wages are shown in the Payroll Register. The next task is computing the FICA withholding for each employee and the employer's liability. Requirements: Compute the OASDI for each employee. Compute the HI for each employee. On the Employer Register, compute the employer FICA liability. Payroll Register Complete the steps below: Compute the OASDI for each employee. Compute the HI for each employee. Compute the totals for each tax. Note: Round your final answers to the nearest cent. KIPLEY COMPANY, INC.Employee Payroll RegisterFor Period Ending January 8, 20-- EARNINGS DEDUCTIONS NET PAY Name Gross OASDI HI FIT…
DIRECTIONS 1 Journalize the entry to RECORD the payroll 2 Journalize the entry to RECORD the employer's payroll taxes (SUTA rate is 3.7%) 3 Journalize the entry to deposit the FICA and FIT taxes TOTAL EARNINGS FICA OASDI FICA HI FIT W/H STATE TAX UNION DUES NET PAY $36,195.10 $2,244.10 $524.83 $6,515.00 $361.95 $500.00 $26,049.22 1 JOURNAL DATE DESCRIPTION DEBIT CREDIT 2 JOURNAL DATE DESCRIPTION DEBIT CREDIT…
Example 6-5 The journal entry to record the payroll from Figure 6.1, on pages 6-2 and 6-3, would be: Debit Credit Wages Expense 24,762.70 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FIT Payable 3,714.00 SIT Payable 55.25 Group Insurance Payments W/H 54.70 Cash 19,044.40 Example 6-7 The journal entry to record the payroll tax entry from Figure 6.1 on pages 6-2 and 6-3 would be (assume a SUTA tax rate of 3.0%): Debit Credit Payroll Taxes 2,785.81 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FUTA Taxes Payable 148.58 SUTA Taxes Payable 742.88 The employees of Donnelly Music Company earn total wages of $4,690 during January. The total amount is taxable under FICA, FUTA, and SUTA. The state contribution rate for the company is 3.6%. The amount withheld for federal income taxes is $685. Journalize the payment of the monthly wages, and record the payroll taxes. If an amount box does not…
Example 6-5 The journal entry to record the payroll from Figure 6.1, on pages 6-2 and 6-3, would be: Debit Credit Wages Expense 24,762.70 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FIT Payable 3,714.00 SIT Payable 55.25 Group Insurance Payments W/H 54.70 Cash 19,044.40 Example 6-7 The journal entry to record the payroll tax entry from Figure 6.1 on pages 6-2 and 6-3 would be (assume a SUTA tax rate of 3.0%): Debit Credit Payroll Taxes 2,785.81 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FUTA Taxes Payable 148.58 SUTA Taxes Payable 742.88 The employees of Donnelly Music Company earn total wages of $4,690 during January. The total amount is taxable under FICA, FUTA, and SUTA. The state contribution rate for the company is 3.6%. The amount withheld for federal income taxes is $685.
Example 6-5 The journal entry to record the payroll from Figure 6.1, on pages 6-2 and 6-3, would be: Debit Credit Wages Expense 24,762.70 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FIT Payable 3,714.00 SIT Payable 55.25 Group Insurance Payments W/H 54.70 Cash 19,044.40 Example 6-7 The journal entry to record the payroll tax entry from Figure 6.1 on pages 6-2 and 6-3 would be (assume a SUTA tax rate of 3.0%): Debit Credit Payroll Taxes 2,785.81 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FUTA Taxes Payable 148.58 SUTA Taxes Payable 742.88 Vulcra, Inc., has a semimonthly payroll of $66,920 on September 15, 20--. The total payroll is taxable under FICA Taxes-HI; $63,290 is taxable under FICA Taxes-OASDI; and $10,400 is taxable under FUTA and SUTA. The state contribution rate for the company is 4.1%. The amount withheld for federal income taxes is $9,838. The amount withheld for state…
Example 6-5 The journal entry to record the payroll from Figure 6.1, on pages 6-2 and 6-3, would be: Debit Credit Wages Expense 24,762.70 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FIT Payable 3,714.00 SIT Payable 55.25 Group Insurance Payments W/H 54.70 Cash 19,044.40 Example 6-7 The journal entry to record the payroll tax entry from Figure 6.1 on pages 6-2 and 6-3 would be (assume a SUTA tax rate of 3.0%): Debit Credit Payroll Taxes 2,785.81 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FUTA Taxes Payable 148.58 SUTA Taxes Payable 742.88 Kip Bowman is owner and sole employee of KB Corporation. He pays himself a salary of $1,500 each week. Additional tax information includes: FICA tax—OASDI 6.2% on first $132,900 FICA tax—HI 1.45% on total pay Federal income tax $232.00 per pay State income tax 22% of the federal income tax withholding Federal unemployment…
Peyton Company's payroll for the year is $739,020. Of this amount, $464,090 is for wages paid in excess of $7,000 to each individual employee. The SUTA rate in Peyton Company's state is 2.9% on the first $7,000 of each employee's earnings. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Required: Compute: a. Net FUTA taxb. Net SUTA taxc. Total unemployment taxes Round your answers to the nearest cent. a. Net FUTA tax $fill in the blank 2 b. Net SUTA tax fill in the blank 3 c. Total unemployment taxes $fill in the blank 4 Feedback
A Payroll consists of Basic Pay, Allowances, Gross Salary, Deductions and Net Salary. The Allowances are 23% of the Basic Pay while the Deductions are 12% of the Gross Salary. Calculate the total salary for given 3 names Find out who has the maximum net salary Calculate how much money company has to spend on all the 3 employees. A B C D E F 1 Stationery Supplies Ltd 2 3 Name Basic Pay Allowances Gross Salary Deductions Net Salary 4 Lewis 80000 5 Francis 18000 6 Edwin 23000
C4Q5 Need help Prepare journal entries for the December 31 payroll. 2. Use T-accounts to compute the following: a. The total amount of materials requisitioned into work-in-process during December b. The total amount of direct manufacturing labor recorded in work in process during December (Hint: You have to solve requirements 2b and 2c simultaneously) c. The total amount of manufacturing overhead recorded in work-in-process during December d. Ending balance in work-in-process, December 31 e. Cost of goods sold for December before adjustments for under- or overallocated manufacturing overhead 3. Prepare closing journal entries related to manufacturing overhead. Assume that all under- or overallocated manufacturing overhead is closed directly to Cost of Goods Sold.