please do it in excel E11.9 (LO 3) Maria Garza's regular hourly wage...
60.1K
Verified Solution
Link Copied!
Question
Accounting
please do it in excel
E11.9 (LO 3) Maria Garza's regular hourly wage rate is $16, and she receives a wage of 172 times the regular hourly rate for work in excess of 40 hours. During a March weekly pay period, Maria worked 42 hours. Her gross earnings prior to the current week were $6,000. Maria is married and claims three withholding allowances. Her only voluntary deduction is for group hospitalization insurance at $25 per week. Compute net pay and record pay for one employee. Instructions a. Compute the following amounts for Maria's wages for the current week. 1. Gross earnings. 2. FICA taxes. (Assume a 7.65% rate on maximum of $127,200.) 3. Federal income taxes withheld. (Use the withholding table in Illustration 11.11.) 4. State income taxes withheld. (Assume a 2.0% rate.) 5. Net pay. b. Record Maria's pay
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
please do it in excel 