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

Other questions on the subject: Business

Business, 21.06.2019 19:10, postorivofarms

If we know that a firm has a net profit margin of 4.6 %, total asset turnover of 0.62, and a financial leverage multiplier of 1.54, what is its roe? what is the advantage to using the dupont system to calculate roe over the direct calculation of earnings available for common stockholders divided by common stock equity?

Answers: 2

continue

Business, 22.06.2019 03:30, jose0765678755

Joe finally found a house for sale that he liked. which factor could increase the price of the house he likes? a. both he and the seller each have a real estate agent. b. a home inspector finds faulty wiring in the house. c. the house has been for sale for almost a year. d. several buyers all want that same house.

Answers: 2

continue

Business, 22.06.2019 17:10, mikailah0988

At the end of the current year, accounts receivable has a balance of $550,000; allowance for doubtful accounts has a credit balance of $5,500; and sales for the year total $2,500,000. an analysis of receivables estimates uncollectible receivables as $25,000. determine the net realizable value of accounts receivable after adjustment. (hint: determine the amount of the adjusting entry for bad debt expense and the adjusted balance of allowance of doubtful accounts.)

Answers: 3

continue

Business, 22.06.2019 18:30, maddylol3863

Hilary works at klothes kloset. she quickly the customers, and her cash drawer is always correct at the end of her shift. however, she never tries to "upsell" the customers (for example, by asking if they would like to purchase earrings to go with the shirt they chose or by suggesting a purse that matches the shoes they are buying). give hilary some constructive feedback on her performance.

Answers: 3

continue

You know the right answer?

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