Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

----Please help me to using EXCEL sheet and show/explain detail solution--- -. Thank you very much for your help. It helps me a lot to

----Please help me to using EXCEL sheet and show/explain detail solution----. Thank you very much for your help.

It helps me a lot to learn this course. This way I can study myself. I really appreciate for your help.

I need to answer bottom of excel sheet on by one. Thank you so much.

(If you want to make pics big or clear -> "copy of the picture and paste to Word or Excel, to make a big picture"

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Summary of payroll procedures An analysis of the payroll for the month of November for Pro tion Inc. reveals the information shown: 3-9) jec Gross Earnings-Week Ending 11/15 11/22 11/29 Employee Name Hathaway 11/8 s 300 280 290 320 270 300 2,032 260 340 2,032 850 280 280 2,032 870 280 Portman 2,032 800 Streep All regular time Hathaway, Kunis, and Portman are production workers, and Streep is the plant manager. Williams is in charge of the office. Cumulative earnings paid (before deductions) in this calen- dar year prior to the payroll period ending November 8 were as follows: Hathaway, $12,000; Kunis, $7,800; Portman, $11,500; Streep, $89,400; and Williams, $32,800. The solution to this problem requires the following forms, using Reau the indicated column headings: Employee Earnings Record Week Ending Weekly Gross Earnings Payroll Record Employee's Name Gross Earnings Labor Cost Summary Week Ending Dr. Work in Process (Direct Labor) Dr. Factory Overhead (Indirect Labor) Accumulated Gross Withholdings (2 columnsl: FICA Tax Income Tax (10%) Weekly Earnings Subject Net Amount Paid Dr. Administrative to FICA Salaries (Office) Witholding (2 columns: Cr. Payroll (Total FICA Tax Income Tax (10%) Net Amount Paid 1. Prepare an employee earnings record for each of the five employees 2. Prepare a payroll record for each of the four weeks. 3. Prepare a labor cost summary for the month. 4. Prepare journal entries to record the following: a. The payroll for each of the four weeks. b. The payment of wages for each of the four payrolls. c. The distribution of the monthly labor costs per the labor cost summary. d. The company's payroll taxes covering the four payro

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting in an Economic Context

Authors: Jamie Pratt

8th Edition

9781118139424, 9781118139431, 470635290, 1118139429, 1118139437, 978-0470635292

More Books

Students also viewed these Accounting questions

Question

What role does the Fed play in foreign exchange markets?

Answered: 1 week ago