Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Homework Help/Study Tips Expert

problem: You work for a local construction firm, "DeVry Engineering Group" and your supervisor wishes to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to compute weekly payroll for "15" employees with the given assumptions:

• Each employee could have a standard hourly rate between $10.00 and $30.00 per hour.

• Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for each and every hour greater than 40 hours.

• Each employee will encompass a standard 7.65% deduction for social security.

• Each employee will encompass a standard 14.00% deduction for Federal Taxes.

• Each employee will encompass a standard 5.33% deduction for State Taxes.

Describe how you will structure and format your worksheet, comprising titles, column headings, and formulas to compute payroll variables for each employee to find out "Net Pay" comprising and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, find out how you would extract overtime hours from a computed value of "Total Hours" using a conditional formula.

Additionally, your supervisor will require this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll running on one worksheet or by assigning a new worksheet for each week. By using your knowledge learned in this class, descriptively describe whether you would keep all weekly payrolls in one worksheet or assigned to new worksheets by week. Defend your reasoning's on the approach your take based on what you have learned in this course.

Homework Help/Study Tips, Others

  • Category:- Homework Help/Study Tips
  • Reference No.:- M915519

Have any Question? 


Related Questions in Homework Help/Study Tips

Assignment inductive and deductive argumentsin this

Assignment : Inductive and Deductive Arguments In this assignment, you will apply key concepts covered in the module readings. You will identify the component parts of arguments and differentiate between various types of ...

Find an article published within the last 6 years about any

Find an article published within the last 6 years about any area of psychology - social psychology, personality, motivation, emotion, consciousness, facial recognition, mental disorders, psychological treatment, etc. Use ...

Task- off campus noiseoff campus -choose two off campus

Task- Off Campus Noise OFF CAMPUS -Choose two off campus locations; one Mat is representative of low ambient environmental noise and a second that is representative of a high point source environmental noise. Take noise ...

Catherine owens onlyin most neighborhoods especially

Catherine Owens only In most neighborhoods, especially low-income neighborhoods, you don't have to look far to see signs advertising "payday loans" and "title loans." In my old neighborhood, Spring Branch, it seems like ...

1 choose a controversial artwork from 1980-21st century do

1) Choose a controversial artwork from 1980-21st century. Do not choose an artwork illustrated in the sayre textbook. 2) Explain its significance, and why the public rejected it 3) What was the artist's intent or message ...

Psychology 3180 assignmenti - in each of the problems that

Psychology 3180 Assignment I - In each of the problems that follow, you are to use your computer and SPSS as your tools to analyze and interpret quantitative data. An industrial psychologist sought to evaluate the effect ...

How do sitenbspgiven information correctlythe

How do site given information correctly? The information is from a statistical table. Listed below, has the ethnicity on the left with the coinciding number on the right, so only two rows. Add a citation to the article i ...

With the emergence of early greek and roman drama came the

With the emergence of early Greek and Roman drama came the development of satyr plays, which history has shown were bawdy in nature and contained dialogue and imagery that some people today might find offensive (in fact, ...

To engage the idea of research generally i would like you

To engage the idea of research, generally, I would like you to consider how research plays a role in your life. Most of us conduct at least cursory research when making a purchase. For example, when purchasing a new cell ...

With so many individuals using the internet today the

With so many individuals using the Internet today, the psychology of the individual, the family, the community, and the society has changed. Some might argue that the traditional psychological theories cannot be applied ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate