Go to (Links to an external site.) and click Case Study Materials, then click th.
Go to (Links to an external site.) and click Case Study Materials, then click the link to Case Study #4.
Review the case data presented in the case study file, and determine how many people from a law office would be involved in preparing the case for court. Download an appropriate MS Excel template or set up appropriate column headings to prepare a timesheet of employee hours and wages. Be sure to include a column for hours worked and another for hourly wage.
For each employee, add a formula to calculate pay based on the hourly wage. You can research this information via job postings in your area or the Department of Labor for current information on industry wage standards. Add a formula to calculate the total of all of the wages due to be paid to employees.
For each employee, enter a fictitious number of hours worked in a two-week period, and calculate the payroll for the office.
Use the Chart Wizard in MS Excel to create a graphical representation of the payroll expenses for the office in a two-week period.