The Payroll Challenge

 

 

Introduction

My business: I am a business owner looking for someone to do my payroll work. My company has 4 different departments with 5 employees in each of them. I pay all my employees by the hour. If they work more than 40 hours during a week, they get “time and a half” pay for the extra hours. Paychecks are written after each week.

 

Task

Your job: You are an accounting company looking for work. You are to make a proposal explaining why you are the best company to do the job.

 

Resources

Excel Tutorial

Excel Tips

 

Process

The proposal: Your proposal should be a narrative introduction, a sample spreadsheet, and a conclusion. This is to convince me that I should let you do the payroll for my employees so make it convincing. Your proposal will be given as a presentation using the projection system for the computer. I will be asking you questions throughout your presentation.

 

Payroll Project Requirements

 

  • There must be an oral introduction, a workable spreadsheet and an oral conclusion.
  • The spreadsheet must use formulas. The only data that should be entered as numbers are the regular and overtime hours worked and the hourly pay rate.
  • Don’t forget that overtime is only for hours over 40. Overtime is paid as “time and a half.”
  • The spreadsheet must calculate the pay for a total of 20 employees (four departments with five employees in each). During your presentation, I will ask you to change hours worked and/or pay rates to see that your spreadsheet calculates correctly.
  • The spreadsheet must calculate the total pay for each person, the total pay for each department and the total pay for the whole company.
  • Neatness and spelling will affect your grade. If you aren’t sure of how to spell something look it up. Make your spreadsheet look nice and make sense. Make sure the labels explain what is in the columns so that anyone reading your spreadsheet could understand what all the information is.
  • Don’t forget to be convincing. If two spreadsheets are pretty much the same but one group explains all the calculations and demonstrates how it’s used, but the other group just says, “This is our spreadsheet,” the first group would be the one hired.

 

Evaluation Rubric

 

Contribution to Group (10 max):

Maximized tech lab time

Worked together (if with partner)

 

Format/Neatness (10 max):

Looks good

Money (2 decimal places)

Spelling

 

Explanation (10 max):

Difficulties

Overtime Formula

Steps Explained

 

Formula Test (20 max):

 

Employee

Rate

Reg. Hours

OT Hours

Reg. Pay

OT Pay

Total Pay

Al

$6.50

40.0

4.0

$260.00

$39.00

$299.00

Bob

$10.25

40.0

3.0

$410.00

$46.13

$456.13

Carmen

$11.00

35.5

0.0

$390.50

$0.00

$390.50

Doug

$15.00

39.0

0.0

$585.00

$0.00

$585.00

Ed

$12.50

40.0

2.0

$500.00

$37.50

$537.50

 

 

 

 

 

 

Dept 1 Pay:

$2,268.13

 

Comments:

 

 

 

 

 

 

Conclusion

As a group, fill out the self-assessment worksheet and turn it in to Mrs. Laubach.