Question: Hi, I need help with a homework question please. We have to fill out the remaining spaces in the excel spreadsheet. The Question is in

 Hi, I need help with a homework question please. We have

Hi, I need help with a homework question please. We have to fill out the remaining spaces in the excel spreadsheet. The Question is in shown below. Thank you.

to fill out the remaining spaces in the excel spreadsheet. The Questionis in shown below. Thank you. 52 EOC P3 / Additional Activities

52 EOC P3 / Additional Activities of a Business ise 17-22 Compensated Absence-Vacation Pay General Aviation Company employs six people. Each employee is entitled to three weeks' paid vacation every year the employee works for the company. The conditions of the paid vacation are (a) for each full year of work, an employee will receive three weeks of paid vacation (no vacation accrues for a portion of a year), (b) each employee will receive the same pay for vacation time as the regular pay in the year taken, and (c) unused vacation pay can be carried forward. Based on the following data, compute the liability for vacation pay as of December 31, 2015. Cumulative Vacation Taken Weekly Employee Starting Date as of December 31, 2015 Salary Marci Clark . ...... December 21, 2008 16 2 14 weeks $850 Bradford Sayer . . ..... . ..... July 17, 2012 5 weeks 725 Sorena Williams ..... . . .. . ... . ...... April 8, 2014 None 650 Jonathan Beecher........ . .. December 17, 2007 18 weeks 800 Brian Giles. .... . . . . . .......... July 17, 2013 1 week 450 Dale Murphy .. . . . . . .......... May 31, 2015 None 50017-22 Name: Enter the appropriate amounts/formulas in the blue-shaded cells. The word \"Wrong\" will appear to the left of incorrect entries. Employee Total Weeks Vacation Earned Total Weeks Vacation Taken Marci Clark Bradford Sayer Sorena Williams Jonathan Beecher Brain Giles Dale Murphy Total liability for vacation pay, December 31, 2015 14 5 0 18 1 0 Total Weeks Vacation Liability Weekly Salary $ 850 725 650 800 450 500 Liability for Vacation Pay

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!