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

Test is to be typed and double spaced 1 page250 words make

Test is to be typed and double spaced. (1 page=250 words) Make sure to use appropriate grammar and spelling. Proof read be Ma111..,,re to reference sources including your textbook. Each Question worth 5 points for a tota ...

Guidelines - description-systemdirections getting started

Guidelines - Description-"System" Directions: Getting Started. Select a business or organization real or fictitious, use the cases or your own creativity. Describe it (see below) it can be highly technical or not, but it ...

Discussion - experiencing team conflictrecall a time that

Discussion - Experiencing team conflict Recall a time that you were on a team (work, school or social) and describe a conflict that occurred: What was the conflict? How did you deal with the conflict? How did the leader ...

Read the case study titled ing lifewrite a three to four

Read the case study titled "ING Life". Write a three to four (3-4) page paper in which you: 1. Assess the probable difficulties and risks associated with using a public infrastructure such as the Internet as part of a bu ...

1 john breaks his hip and must be hospitalized for hip

1. John breaks his hip and must be hospitalized for hip repair surgery. This is an example of __________ care. a. primary b. acute c. secondary d. tertiary 2. One advantage of an LLP is __________. a. financial obligatio ...

For this discussion you will obtain information for the

For this discussion, you will obtain information for the Marketing Mix section of your Final Project. Specifically, you will focus on your chosen HCO's marketing opportunities and goals. In addition, examine your healthc ...

1compare and contrast parenting infants and babies

1.Compare and contrast parenting infants and babies, parenting children, parenting teenagers, and parenting adults. Explain how parenting demands vary across time and how social factors outside of the immediate family (e ...

Journalreflect on your coursework so far what assignment

Journal Reflect on your coursework so far. What assignment was the most engaging? Why? Have you learned anything new? What? How will you use your new knowledge? Evaluate your work so far. What assignments and/or activiti ...

Assignment application - protocol for diagnosis management

Assignment: Application - Protocol for Diagnosis, Management, and Follow-Up Care of Growth and Development and Psychosocial Issues As pediatric patients grow from infancy to adolescence, there are many common growth and ...

Answer any one question among them1 what issues have been

Answer any one question among them: 1. What issues have been raised concerning some of the authorities granted to government agencies in the PATRIOT Act? How have those issues been addressed? 2. Should FEMA fall under DH ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro