subject
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)

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 22:00
Which of the following is the term for something that you can't live without 1. need 2. want 3. good 4. service
Answers: 1
question
Business, 22.06.2019 22:10
Scoresby co. uses 6 machine hours and 2 direct labor hours to produce product x. it uses 8 machine hours and 16 direct labor hours to produce product y. scoresby's assembly and finishing departments have factory overhead rates of $240 per machine hour and $160 per direct labor hour, respectively. how much overhead cost will be charged to the two products? a. product x = $1,440; product y = $2,560 b. product x = $1,760; product y = $4,480 c. product x = $3,200; product y = $9,600 d. product x = $800; product y = $800
Answers: 1
question
Business, 22.06.2019 22:40
Colorado rocky cookie company offers credit terms to its customers. at the end of 2018, accounts receivable totaled $715,000. the allowance method is used to account for uncollectible accounts. the allowance for uncollectible accounts had a credit balance of $50,000 at the beginning of 2018 and $30,000 in receivables were written off during the year as uncollectible. also, $3,000 in cash was received in december from a customer whose account previously had been written off. the company estimates bad debts by applying a percentage of 15% to accounts receivable at the end of the year. 1. prepare journal entries to record the write-off of receivables, the collection of $3,000 for previously written off receivables, and the year-end adjusting entry for bad debt expense.2. how would accounts receivable be shown in the 2018 year-end balance sheet?
Answers: 1
question
Business, 22.06.2019 23:00
Customers arrive at rich dunn's styling shop at a rate of 3 per hour, distributed in a poisson fashion. rich can perform an average of 5 haircuts per hour, according to a negative exponential distribution.a) the average number of customers waiting for haircuts= customersb) the average number of customers in the shop= customersc) the average time a customer waits until it is his or her turn= minutesd) the average time a customer spends in the shop= minutese) the percentage of time that rich is busy= percent
Answers: 3
You know the right answer?
Plz help me 1. Read the following data regarding payroll deductions, and answer the questions that f...
Questions
Questions on the website: 13722362