Ask Question, Ask an Expert


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

Given the following students test scores 95 92 90 90 83 83

Given the following students' test scores (95, 92, 90, 90, 83, 83, 83, 74, 60, and 50), identify the mean, median, mode, range, variance, and standard deviation for the sample. Write a 500-750-word summary and analysis d ...

Research proposal article reviewprovide an annotation of an

Research proposal article review Provide an annotation of an article for research proposal. Response should be at least 350 words. Post a copy or link to your article with your summary. From the chapters in the textbook ...

Conflict resolution paperpurposethe purpose of this

Conflict Resolution Paper: PURPOSE The purpose of this assignment is to learn how to identify and effectively manage conflicts that arise in care delivery settings resulting in better management of patient care, includin ...

Assignment and presentation-assignment and presentation

Assignment and Presentation- Assignment and Presentation requirements: In pairs, Identify an issue from the above conversation ( and link it in Australian Accounting context Wr ...

In the second assignment you will compare and contrast the

In the second assignment, you will compare and contrast the theories or models that you think are most interesting and relevant to your work. Using the Internet, select two leadership models or theories that interest you ...

Assignmentpurpose this assignment will help you become

Assignment Purpose: This assignment will help you become familiar with documentation standards and Medicare's Conditions of Participation Assignment Description: The CEO of Hospital Anywhere has just hired you as a consu ...

1 watch this ted talk jamie oliver teach every child about

1. Watch this TED Talk (Jamie Oliver: Teach Every Child About Food) 2. Watch and follow along with these breathing exercises (YouTube:Release the Worrier:YogicBreath Wor ...

Your roommate has been coming back to the dorm at all hours

Your roommate has been coming back to the dorm at all hours of the night, disrupting your sleep. Describe a typical night's sleep cycle and then describe how your sleep deprivation impacts your ability to learn and your ...

Create a 8- to 10-slide microsoft powerpoint presentation

Create a 8- to 10-slide Microsoft PowerPoint presentation with detailed speaker notes on each slide answering the following questions throughout the presentation: What conflict styles have you encountered while working i ...

Microsoft word - assignment assignment course

Microsoft Word - Assignment Assignment : Course Reflection Assignment Overview Reflection is an important aspect of learning. In final assignment,  write a memo reflecting on the course, the writing projects that you hav ...

  • 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