![terriblexsiren](/avatars/22896.jpg)
terriblexsiren
03.12.2021 •
Business
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)
Solved
Show answers
More tips
- A Animals and plants Want a Perfect Lawn? Learn How to Plant Grass the Right Way...
- A Animals and plants How to Properly Care for a Pet Decorative Rabbit at Home?...
- C Computers and Internet How to Check the Speed of My Internet?...
- H Health and Medicine 10 Ways to Cleanse Your Colon and Improve Your Health...
- W Work and Career How to Write a Resume That Catches the Employer s Attention?...
- C Computers and Internet Е-head: How it Simplifies Life for Users?...
- F Family and Home How to Choose the Best Diapers for Your Baby?...
- F Family and Home Parquet or laminate, which is better?...
- L Leisure and Entertainment How to Properly Wind Fishing Line onto a Reel?...
- L Leisure and Entertainment How to Make a Paper Boat in Simple Steps...
Answers on questions: Business
- B Business Mr. Bob Brown earns $12.00 per hour and works 38 hours each week for his job at a retail store. His wife Matilda is paid $680 bi-weekly as a medical technician. What is their combined...
- B Business If you were to ask Roland to recommend a restaurant in Charleston, South Carolina, he would tell you to go to Brendon s, The Paradise Hotel, or Linda s Dinner Bar. There are obviously...
- B Business Consider the recent data on sun spot activity below, available online from the NOAA Space Weather Service. (Sun spots are massive disturbances on the surface of the sun, and they...
- B Business The Model Company is to begin operations in April. It has budgeted April sales of $62,000, May sales of $66,000, June sales of $72,000, July sales of $74,000, and August sales of...
- B Business For the current year, Peter s Boats has sales of $760,000 and a profit margin of 5 percent. The annual depreciation expense is $80,000. What is the amount of the annual operating...
- B Business Jose wants to upgrade his look before a job interview. A friend tells him about a men s clothing line that allows potential customers to virtually try on suits and see what looks...
- B Business For ABC, Inc., 250,000 units of output per year represent minimum efficient scale. If ABC, Inc. decides to produce 200,000 units this year, it will be operating in the region of...
- B Business An example of product placement is when a: A. Verizon phone is featured in an advertisement, B. TV show has a character who uses an iPhone, c. movie s characters use lots of computers....
- B Business Which of the following items could give rise to the recognition of accrued expenses? A. Salaries, interest payable, interest receivable. B. Sales, interest payable, rent C. Salaries,...
- S Spanish En la Edad Media floreció el estudio científico, se progresó en distintos campos y floreció la Literatura y el Arte...
Ответ:
I took the topic test.