Mr. Kaye opened a jewelry store that made

Question # 00418201 Posted By: rey_writer Updated on: 11/04/2016 12:01 AM Due on: 11/04/2016
Subject Finance Topic Finance Tutorials:
Question
Dot Image

Mr. Kaye opened a jewelry store that made and sold high-end jewelry. The store hours are 9:00 am - 5:00 pm Monday through Friday and 9:00 am - noon on Saturdays. Employees include the following:

Store manager - Kerry, $80,000 salary;

Bookkeeper - Kelvin, $40,000 salary;

Clerks - Kassie, $12.00/hr. and Katherine, $15.00/hr.

Jeweler - O.K., $100,000 salary

Two seasonal employees earn $10.00/hr for four weeks in December and two weeks in February.

Employees get a 30-minute unpaid lunch break on days they work more than six hours.

Benefits for full-time employees include medical insurance, life insurance, Medicare and social security taxes (employer portion), are 22% of the employee's salary.

Using Excel, determine the monthly payroll and benefits costs for Kaye Jewelry Store for 2016.

Dot Image
Tutorials for this Question
  1. Tutorial # 00413614 Posted By: rey_writer Posted on: 11/04/2016 12:01 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Mr. Kaye opened a jewelry store that made...
    Attachments
    Payroll.xlsx (9.87 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    cf...am Rating Multiple payment options 12/06/2016

Great! We have found the solution of this question!

Whatsapp Lisa