Solution-Sandy gross pay and net pay

Sandy gross pay and net pay

Reference no: EM131401856

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

Reference no: EM131401856

Questions Cloud

How much is the car worth today : Your car lease requires a down payment of $1,500 and payments of $450 per month for 36 months. The APR is 6% compounded monthly and payments are made at the end of the month. At the end of the lease, you have the option to buy the vehicle for $20,..

Present value and multiple cash flows : Investment X offers to pay you $4,700 per year for eight years, whereas Investment Y offers to pay you $6,700 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount..

Is diet or exercise effective in combating insomnia : Is diet or exercise effective in combating insomnia?- Some believe that cutting out desserts can help alleviate the problem, while others recommend exercise.

Describe the types of law libraries and their uses : Legal professionals widely agree that there is no single "right" path to take in conducting legal research. As such, each paralegal must devise his or her own strategy. Imagine that your supervising attorney has asked you write a report detailing ..

Sandy gross pay and net pay : 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.

What it mean to say that we live in gender binary system : What does it mean to say that we live in a gender binary system? How does the gender binary system work? What are its limitations? How can we deconstruct it

Calculate the stock price : Starting in 5 years, a stock will make a $5/share dividend payment. They will grow their dividend payments by 5% every year, forever. R=11%. Calculate the stock price.

Develop a rhetorical structure of an essay : COR160 - Essential Academic Writing Skills - Family violence laws under review after spate of abuse cases and Evaluate information critically from various sources to respond to a task and synthesise information from various sources in writing in resp..

How things would change if organism were to be transplanted : Explain how things would change if the organism were to be transplanted to a significantly different environment: Would their organ system still be as efficient? Why or why not?

User Account

All Pages

Sandy gross pay and net pay

Reference no: EM131401856

Reference no: EM131401856

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT