kprincess16r
14.07.2021 •
Mathematics
As the accountant for Veneskey & Son’s, you have been hired to prepare the payroll and everything that goes along with it for Ol’Fashion Industries which has 4 employees. Their necessary payroll information is listed below and in the Excel spreadsheet for the current year. The employees are paid monthly (last day of the current month) and were last paid Sept. 30th. Assume this is an Indiana company and use the Indiana withholding rates. SUTA rate = 3.5%.
EmployeeGross Wages Marital Status RecentTermination per check Hire date
Larry13,500MarriedN/A
Keagan4,400 Single N/A
Martha3,700Single Aug. 1st Nov. 30th
Nancy3,500Married Sept. 1st
***All Medical Premium Insurance and Flexible Spending are part of a cafeteria plan***
Larry – Has $450/ pay deducted for 401K, $500/pay deducted for Medical Premium insurance , and $400 withheld for his Flexible Spending Account (FSA). Step 3 of W4 = $2,500. Spouse does not work.
Keagan - Has $300/ pay deducted for 401K, $250/pay deducted for Medical Premium insurance , and $150 withheld for FSA. Step 3 of W4 = $500
Martha- Has $50/ pay deducted for 401K, $200/pay deducted for Medical Premium insurance , and $150 withheld for FSA. Nothing for Step 3 or 4
Nancy- Has $50/ pay deducted for 401K, $350/pay deducted for Medical Premium insurance , and $400 withheld for FSA. Spouse makes the same as her (checked step 2 on W4)
**Employer will match 401K contributions up to $500. Employer’s portion of the Medical Premiums is twice what the employee pays.**
Instructions:
1. Using the attached Excel Spreadsheet tabs, complete the payroll register for Oct., Nov., and Dec. (There is a separate monthly tab at the bottom of the Excel file).
a. You may be creative and use your payroll template sheets instead of the nonformatted sheets in this Spreadsheet for Oct, Nov, and Dec register and journal entries. However, make sure your template sheets, if you use them, contain all the answers found in the original tabs provided.
2. Using the Excel Spreadsheet or template sheet, complete the payroll journal entries for each month. Also include the entries to record payment of taxes and other benefits to the respectable parties as outlined below.
** Note: Do Not include the Employers portion of 401K and Medical Premiums in with the Payroll Tax Expense. These are not taxes, but separate expenses.
3. The taxes and other payroll benefit expenses are paid:
a. F/W & FICA – every month (last paid Sept. 15th) next due Oct. 15th (Sept pay)
i. See opening trial balance for current payments due
b. St/W – every 2 months (last paid Sept. 15th) next due Nov. 15th (Sept and Oct pay)
i. For each 2 month item, use the separate Trial balance and your own T-Accts to help keep track of what is due (see below #5 trial balances)
c. 401K – every 2 months (last paid Sept. 15th) next due Nov. 15th (Sept and Oct pay)
d. Medical Prem. & FSA – every 2 months (last paid Sept. 15th) next due Nov. 15th (Sept and Oct pay)
e. FUTA & SUTA – do not pay this year
4. Create a checkbook record of each check written (included in each months Excel tab)
a. Start with check 500 for the Oct 15th payment and then continue with checks 501 – 504 for each employee’s check.
b. You may combine F/W and FICA for one check to the “Department of Treasury”
i. Note: You should also refer to the open trial balance to determine how much is in each account to be paid. Due to the prior accountant not paying the correct amount in Sept., the Sept balances due will be a little different than the Oct. balances calculated.
c. The following are the names of each department receiving checks
i. St/W = “Ind. Dept. of Treasury”
ii. 401K = TIAA Cref
iii. Medical Ins. Prem. = “Anthem”
iv. FSA = “Star Bank”
5. Complete an updated trial balance for the end of each month ending Dec. 31st (separate Excel taps provided)
a. Only update the balances for the entries you make. Thus leave all balance as is that are already filled in for Oct., Nov…etc.
b. Use the attached T-Acct sheet to keep balance up-to-date
6. Complete the W-2 for each employee (included in Dec. Excel tab)
7. Complete Form 941 for the 4th Qtr (included in Dec. Excel tab)
a. Show all work as formulas in current tab or in a separate tab for longer work explanations
8. Complete Form 940 (included in Dec. Excel tab)
a. Show all work as formulas in current tab or in a separate tab for longer work explanations
Solved
Show answers
More tips
- C Computers and Internet Best Antivirus: How to Choose Protection for Your Computer?...
- L Legal consultation What Documents Are Required for a Russian Passport?...
- S Sport How to Choose Tennis Rackets?...
- H Health and Medicine AKDS Vaccination: Ensure Your Child s Safety...
- H Health and Medicine Naskol ko Opasen Ukus Kleshcha i Kak Ego Raspoznat...
- C Computers and Internet How to Delete Your Account on Odnoklassniki...
- H Health and Medicine What to Do When Your Jaw Locks Up?...
- G Goods and services What Are the Most Popular Services?...
- P Philosophy How did the concept of module arise in computer science?...
Answers on questions: Mathematics
- M Mathematics When each of these functions is increasing, which type eventually grows the fastest? A. Linear B. Quadratic C. Exponential D. Constant...
- M Mathematics Help me on this question please!...
- M Mathematics Lily and Aria are employees for a company. Aria is making a salary of $60,060. Aria is earning a salary that is 43% higher than the salary of Lily. What salary is Lily earning?...
- M Mathematics 6. A researcher investigates whether drug A, B, or C influence depression. The data reveals an F test value of 10. This means: a. The variance between treatments is 10 times greater...
- M Mathematics Select the interval whereg(x) 0. -5 -2 4...
- M Mathematics I NEED HELP I NEED TO PASS THIS In the diagram, and . What additional information is necessary to prove that , using the SAS congruence theorem?...
- M Mathematics 1. 6.4% 2 3.6% 3 34.4%...
- M Mathematics Below are two parallel lines with a third line intersecting them. 80 deegres x=?...
- M Mathematics Remington Company purchased office equipment for use in the business with an invoice price of $28,000. The company paid $1,500 to have the equipment delivered and another $500...
- M Mathematics Jet skis rent for $25 per hour plus a flat fee of $50. Noel has $200 to spend. what is the maximum value in the domain of this scenario...
Ответ: