Business, 03.12.2021 14:00 sheazy3709

Plz help me 1. Read the following data regarding payroll deductions, and answer the questions that follow: Lydia: $9.50/hour, worked 20 hours this pay period
Thomas: $12.50/hour, worked 40 hours this pay period
Bruce: $8.50/hour, worked 30 hours this pay period
a) Using a spreadsheet program, create a payroll spreadsheet with the information above. Be sure to include proper headings. (3 points)

b) Add a "Tax (%)" column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that needs to be deducted. For someone who make $9.00 or less an hour, the rate is 5%. For someone who makes between $9.01 and $12.00 an hour, the rate is 6%. For someone who makes more than $12.01 an hour, the rate is 7%. (4 points)

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 19:30

Consider the following ethical argument. which of the three statements represents the moral statement about a moral principle? statement 1: a dealership advertised a car at a very low price, but only had a similar higher priced model in stock. statement 2: it is wrong to perform a bait and switch. statement 3: the dealership was wrong to advertise the car on special sale when in actually it was not available.

Answers: 3

Answer

Business, 22.06.2019 12:10

Drag each label to the correct location on the image determine which actions by a manager are critical interactions - listening to complaints - interacting with customers - responding to complaints - assigning staff duties -taking action to address customer grievances -keeping track of reservations

Answers: 2

Answer

Business, 22.06.2019 21:10

An investor purchases 500 shares of nevada industries common stock for $22.00 per share today. at t = 1 year, this investor receives a $0.42 per share dividend (which is not reinvested) on the 500 shares and purchases an additional 500 shares for $24.75 per share. at t = 2 years, he receives another $0.42 (not reinvested) per share dividend on 1,000 shares and purchases 600 more shares for $31.25 per share. at t = 3 years, he sells 1,000 of the shares for $35.50 per share and the remaining 600 shares at $36.00 per share, but receives no dividends. assuming no commissions or taxes, the money-weighted rate of return received on this investment is closest to:

Answers: 3

Answer

Business, 22.06.2019 22:00

Anheuser-busch inbev is considering you for an entry-level brand management position. you have been asked to prepare an analysis of the u.s. craft beer industry as part of the selection process. prepare a 3-5 page report that includes a description of the industry’s strategically relevant macro-environmental components, evaluates competition in the industry, assesses drivers of change and industry dynamics, and lists industry key success factors. the company’s management also asks that you propose the basic elements of a strategic action plan that will allow the company to improve its competitive position in the market for craft beer. you must provide a heading in your report for each of the required elements of the assignment.

Answers: 3

Answer

You know the right answer?

Plz help me 1. Read the following data regarding payroll deductions, and answer the questions that f...

Questions