Question: PLEASE HELP. Make an Excel spreadsheet to calculate the required pay for each employee under FLSA. See notes below. One week in February, Andy works

PLEASE HELP.

Make an Excel spreadsheet to calculate the required pay for each employee under FLSA. See notes below.

  1. One week in February, Andy works 40 hours. His states minimum wage is $6 an hour.
  2. One week in April, Ronnell works 38 hours. Her states minimum wage is $6.75 an hour.
  3. One week in May, Christie works 30 hours. Her states minimum wage is $8 an hour.
  4. One week in June, Jamie works 40 hours. His state has no minimum wage.
  5. One week in August, Cho works 30 hours. Her states minimum wage is $7 an hour.
  6. One week in February, Frank works 40 hours. His states minimum wage is $7.95 an hour.

THANK YOU!

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!