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

Can anyone help me with a paper on major depressive

Can anyone help me with a paper on major depressive disorder. 1) Specify the diagnostic criteria of the clinical disorder you have selected. (This is disorder I selected - major depressive disorder). 2) Identify two cond ...

Asignment local controltexas is a small-government state

Assignment: Local Control Texas is a small-government state. Its politicians, of all stripes, bemoan the intrusion of the federal government, yet the 84th legislature acted to impose its will on local government in a num ...

Police mission fighting crime or public servicepolicing is

Police Mission: Fighting Crime or Public Service Policing is complex and involves different characteristics to fight crime and serve the public. Write a 2 page paper. Address the following in your paper: Explain what is ...

Project instructionsyou will prepare the classroom

Project Instructions You will prepare the classroom management plan for a specific classroom. If you are currently teaching, you should prepare the plan for your own classroom. If you are not currently teaching in your o ...

Watch the full movie swat feature 2003 and answer the

Watch the full movie (S.W.A.T. (feature) 2003) and answer the worksheet in attachment. https://www.youtube.com/watch?v=1mlFuYIYZ9U 1) Chapter 2: Kleinig's Models of Policing. Please define each model and indicate the whi ...

Capstone required uniform assignment career

CAPSTONE: Required Uniform Assignment: Career Planning PURPOSE Having a clear vision for the future, setting reasonable goals, and developing strategies for meeting those goals are important steps in ensuring control of ...

Case studylocate a recent court case lawsuit or article

Case Study Locate a recent court case, lawsuit, or article related to employee selection criteria and methods. Write a paper of at least 500 words in length about the selected manuscript. You are required to use at least ...

Assignmentmust be original work no plagarismexecutive

ASSIGNMENT MUST BE ORIGINAL WORK NO PLAGARISM! EXECUTIVE SUMMARY Preparation • Research any of following Websites as you prepare this assignment: Governmental Accounting Office, located at www.gao.gov , www.publicagenda. ...

Projecti reimbursement and the revenue cyclea describe what

Project: I. Reimbursement and the Revenue Cycle A. Describe what reimbursement means to this specific healthcare organization. What would happen if services were provided to patients but no payments were received for the ...

Assignment physical ability testsselect a job that

Assignment : Physical Ability Tests Select a job that requires a moderate level of physical ability, such as security staff, office delivery personnel, door-to-door salespersons, retail salesperson, or nurses at hospital ...

  • 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