Assignment
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.