a b c d Employee Normal Gross Normal Hours Hourly Pay Rate Wages worked Overtime Pay Overtime Rate Hours Hours worked at regular rate Regular Wages Overtime Wages Total Gross Wages Project Notes: 1. Project must be submitted in Excel. If you do not have Excel on your computer. you can access it free on Myhgtc. 2. Make two tabs (worksheets). The first label Exercise 1 and the second label Exercise 2 3. Make rows and columns to present your work like the example above. 4. Adjust column widths so everything can be read. Please practice using wrap text feature if it looks like column are too wide. 5. Add a border to the cells as in the example above. 6. Format wage columns to have 2 decimal places and the dollar sign (do not type the dollar sign, use formatting). 7. Use a formula in higher of federal or state minimum wage column so that you do not have to type each one. Example =max(cell reference, cell reference) 8. Use a formula in Gross Wages, Hourly Pay Rate, Overtime Pay Rate, Regular Wages, Overtime Wages, and Total Gross Wages to calculate the answer.
a b c d Employee Normal Gross Normal Hours Hourly Pay Rate Wages worked Overtime Pay Overtime Rate Hours Hours worked at regular rate Regular Wages Overtime Wages Total Gross Wages Project Notes: 1. Project must be submitted in Excel. If you do not have Excel on your computer. you can access it free on Myhgtc. 2. Make two tabs (worksheets). The first label Exercise 1 and the second label Exercise 2 3. Make rows and columns to present your work like the example above. 4. Adjust column widths so everything can be read. Please practice using wrap text feature if it looks like column are too wide. 5. Add a border to the cells as in the example above. 6. Format wage columns to have 2 decimal places and the dollar sign (do not type the dollar sign, use formatting). 7. Use a formula in higher of federal or state minimum wage column so that you do not have to type each one. Example =max(cell reference, cell reference) 8. Use a formula in Gross Wages, Hourly Pay Rate, Overtime Pay Rate, Regular Wages, Overtime Wages, and Total Gross Wages to calculate the answer.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter18: Cost-volume-profit Analysis (cvp)
Section: Chapter Questions
Problem 2R: Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where...
Related questions
Question
Exercise 2
Make an Excel spreadsheet to compute gross wages due each employee under federal wage-hour law. See notes below.
- Ryan is normally paid $1,000 for a 40-hour workweek. One week, he works 46 hours.
2.Latisha is normally paid $1,200 for a 40-hour workweek. One Monday she is out sick but receives 8 hours sick pay. She then works 40 hours Tuesday–Friday.
3. Al is normally paid $500 for a 40-hour workweek. One week, he works 45 hours.
4. Lee is normally paid $1,500 for a 40-hour workweek. To make up for leaving early one Friday, he works 44 hours this week.
Transcribed Image Text:a
b
c
d
Employee
Normal Gross Normal Hours
Hourly Pay Rate
Wages
worked
Overtime Pay Overtime
Rate
Hours
Hours worked
at regular rate
Regular Wages
Overtime
Wages
Total Gross Wages
Project Notes:
1. Project must be submitted in Excel. If you do not have Excel on your computer.
you can access it free on Myhgtc.
2. Make two tabs (worksheets). The first label Exercise 1 and the second label
Exercise 2
3. Make rows and columns to present your work like the example above.
4. Adjust column widths so everything can be read. Please practice using wrap text
feature if it looks like column are too wide.
5. Add a border to the cells as in the example above.
6. Format wage columns to have 2 decimal places and the dollar sign (do not type
the dollar sign, use formatting).
7. Use a formula in higher of federal or state minimum wage column so that you do
not have to type each one. Example =max(cell reference, cell reference)
8. Use a formula in Gross Wages, Hourly Pay Rate, Overtime Pay Rate, Regular
Wages, Overtime Wages, and Total Gross Wages to calculate the answer.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning