(Answered) You are the payroll manager at widgets r us you need to

Finance

You are the payroll manager at Widgets R Us. You need to calculate an employee's gross and net pay based on the table below. Sandy worked overtime this past week and would like to know what her gross and net pay will be. Your job is to calculate this using the following data.Note: The company policy is that she is entitled to time and a half for any hours worked over 40.Using Excel, calculate Sandy's gross pay and net pay. You must use a function or formula.

Pay Rate: $10.00/Hour

Federal Tax Rate: 20%

Hours Worked: 50

State Tax Rate: 10%

FICA 5%

Sandy's Gross Pay

Sandy's Net Pay

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92211659
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

If someone owns a hair salon what type if any life

If someone owns a hair salon what type if any life insurance should they have if their spouse works at a nuclear plant? How much coverage should the owner have?

One of your clients wants a trust over which he can

One of your clients wants a trust over which he can exercise exclusive control over disposition of his assets to his children from a former marriage. Which of the following trusts apply? (1) bypass trust (2) power of app ...

International finance please show all work whether in excel

International Finance. Please show all work whether in Excel or Word Assume that Calumet Co. will receive 10 million pesos in 15 months. It does not have a relationship with a bank at this time, and therefore cannot obt ...

Under what circumstances will the irr and npv rules lead to

Under what circumstances will the IRR and NPV rules lead to the same decision (accept/reject)? When might they conflict?

A using an hp 12c calculator what are the correct steps to

a) Using an hp 12c calculator, what are the correct steps to calculate IRR entered as monthly payments and if summed up for a year? b) Using an hp 12c calculator, what is the best way to calculate effective interest rate ...

Lets say there are 10000 lawyers in the usa and 500 of them

Let's say there are 10,000 lawyers in the USA and 500 of them are Oreo cookie lovers. These 500 lawyers consume a total of 500 Oreo cookies in a given time period out of 2,000 cookies sold. What is the BDI for Oreo cooki ...

Explain the systematic risk principle and how it relates to

Explain the systematic risk principle and how it relates to beta. according to the below message SYSTEMATIC RISK AND BETA The question that we now begin to address is this: What determines the size of the risk premium on ...

You manage an equity fund with an expected risk premium of

You manage an equity fund with an expected risk premium of 13% and a standard deviation of 44%. The rate on Treasury bills is 6.6%. Your client chooses to invest $90,000 of her portfolio in your equity fund and $60,000 i ...

How much money would you need to deposit today at 3000

How much money would you need to deposit today at 30.00% annual interest compounded monthly to have $40,610 in the account after 2 years?

Determine the internal rate of return for a project that

Determine the internal rate of return for a project that costs $177,000 and would yield after-tax cash flows of $21,000 per year for the first 5 years, $29,000 per year for the next 5 years, and $42,000 per year for the ...

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

Recent Questions

Ask Basic Finance Expert